Tuesday, November 27, 2012

API to Create New Messages in FND_NEW_MESSAGE

DECLARE
   CURSOR c1
   IS
      SELECT *
        FROM xx_fnd_new_messages_stg;
BEGIN
   FOR z IN c1
   LOOP
      fnd_new_messages_pkg.load_row (x_application_id        => z.application_id
                                   , x_message_name          => z.message_name
                                   , x_message_number        => z.message_number
                                   , x_message_text          => z.MESSAGE_TEXT
                                   , x_description           => z.description
                                   , x_type                  => z.TYPE
                                   , x_max_length            => z.max_length
                                   , x_category              => z.CATEGORY
                                   , x_severity              => z.severity
                                   , x_fnd_log_severity      => z.fnd_log_severity
                                   , x_owner                 => &USER_NAME
                                   , x_custom_mode           => 'FORCE'
                                   , x_last_update_date      => NULL
                                    );
   END LOOP;
   COMMIT;
END;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.