APPS.IGS_PE_GEN_002 dependencies on FND_NEW_MESSAGES

Line 42: l_app fnd_new_messages.application_id%TYPE;

38: l_rowid varchar2(30);
39: l_message_name varchar2(2000);
40: l_message_string varchar2(2000);
41: l_err_raised BOOLEAN;
42: l_app fnd_new_messages.application_id%TYPE;
43: ln_msg_index number;
44:
45: BEGIN
46:

Line 302: l_app fnd_new_messages.application_id%TYPE;

298: l_role_name VARCHAR2(320);
299: l_role_display_name VARCHAR2(320);
300:
301: l_error VARCHAR2(30);
302: l_app fnd_new_messages.application_id%TYPE;
303: v_message_name VARCHAR2(30);
304:
305:
306: PROCEDURE Message_Get(

Line 317: CURSOR c_text (cp_message_name fnd_new_messages.message_name%TYPE) IS

313: || (reverse chronological order - newest change first)
314: asbala 22-AUG-2003 3071111: GSCC FILE.DATE.5 Compliance
315: */
316:
317: CURSOR c_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
318: SELECT message_text
319: FROM fnd_new_messages
320: WHERE message_name = cp_message_name AND
321: application_id=8405 AND

Line 319: FROM fnd_new_messages

315: */
316:
317: CURSOR c_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
318: SELECT message_text
319: FROM fnd_new_messages
320: WHERE message_name = cp_message_name AND
321: application_id=8405 AND
322: LANGUAGE_CODE = USERENV('LANG');
323:

Line 324: l_text fnd_new_messages.message_text%TYPE;

320: WHERE message_name = cp_message_name AND
321: application_id=8405 AND
322: LANGUAGE_CODE = USERENV('LANG');
323:
324: l_text fnd_new_messages.message_text%TYPE;
325: BEGIN
326:
327: OPEN c_text (p_message_name);
328: FETCH c_text into l_text;