APPS.IGS_AD_GEN_016 dependencies on FND_NEW_MESSAGES

Line 192: FROM fnd_new_messages

188:
189: CURSOR c_msg_type (lv_message_name VARCHAR2, ln_appl_id NUMBER)
190: IS
191: SELECT NVL(type,'ERROR') type
192: FROM fnd_new_messages
193: WHERE message_name = lv_message_name
194: AND application_id = ln_appl_id
195: AND language_code = l_language;
196:

Line 1001: l_msg_txt fnd_new_messages.message_text%TYPE;

997: l_old_msg_count NUMBER;
998: l_new_msg_count NUMBER;
999: l_msg_inc_factr NUMBER := 1;
1000: l_msg_idx_start NUMBER;
1001: l_msg_txt fnd_new_messages.message_text%TYPE;
1002: l_app_nme varchar2(1000);
1003: l_msg_nme varchar2(2000);
1004: l_err_msg_logged varchar2(5);
1005: l_hash_msg_name_text_type_tab g_msg_name_text_type_table;

Line 1007: l_msg_ret fnd_new_messages.message_text%TYPE;

1003: l_msg_nme varchar2(2000);
1004: l_err_msg_logged varchar2(5);
1005: l_hash_msg_name_text_type_tab g_msg_name_text_type_table;
1006: l_table_index binary_integer := 0;
1007: l_msg_ret fnd_new_messages.message_text%TYPE;
1008: l_msg_sqlerrm VARCHAR2(4000);
1009: BEGIN
1010: l_old_msg_count := p_msg_at_index;
1011: l_new_msg_count := igs_ge_msg_stack.count_msg;