DBA Data[Home] [Help]

APPS.IGS_EN_LGCY_PRC dependencies on FND_NEW_MESSAGES

Line 160: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

156: AND int_table_code = p_int_table_code;
157: END;
158: -------------------------------------------------------------------------------
159: PROCEDURE log_resource_busy(p_int_table_code IN VARCHAR2) AS
160: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
161: l_table_meaning igs_lookup_values.meaning%TYPE;
162: l_meaning igs_lookup_values.meaning%TYPE;
163: BEGIN
164:

Line 182: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

178: END log_resource_busy;
179:
180: -------------------------------------------------------------------------------
181: PROCEDURE log_no_data_exists(p_log IN BOOLEAN) AS
182: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
183: BEGIN
184: IF p_log THEN
185: FND_MESSAGE.SET_NAME('FND','FND_DEF_ALTERNATE_TEXT');
186: l_msg_text := FND_MESSAGE.GET;

Line 195: l_msg_text5 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

191: -------------------------------------------------------------------------------
192: PROCEDURE log_headers(
193: p_int_table_code IN VARCHAR2
194: ) AS
195: l_msg_text5 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
196: l_table_meaning igs_lookup_values.meaning%TYPE;
197:
198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

194: ) AS
195: l_msg_text5 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
196: l_table_meaning igs_lookup_values.meaning%TYPE;
197:
198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
200: l_msg_text3 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
201: l_msg_text4 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
202:

Line 199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

195: l_msg_text5 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
196: l_table_meaning igs_lookup_values.meaning%TYPE;
197:
198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
200: l_msg_text3 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
201: l_msg_text4 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
202:
203:

Line 200: l_msg_text3 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

196: l_table_meaning igs_lookup_values.meaning%TYPE;
197:
198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
200: l_msg_text3 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
201: l_msg_text4 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
202:
203:
204: BEGIN

Line 201: l_msg_text4 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

197:
198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
200: l_msg_text3 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
201: l_msg_text4 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
202:
203:
204: BEGIN
205: /*

Line 246: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

242: -------------------------------------------------------------------------------
243: PROCEDURE log_suc_message(
244: P_int_table_id IN NUMBER
245: ) AS
246: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
247: l_meaning igs_lookup_values.meaning%TYPE;
248: BEGIN
249:
250: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LGCY_SUCCESS');

Line 395: cp_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE) IS

391: ------------------------------------------------------------------------------*/
392:
393: --smaddali: bug#3930425, modified this cursor for performance, to be based on appl_id and message_name as this is the PK
394: CURSOR c_msg_text_num (cp_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE ,
395: cp_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE) IS
396: SELECT message_number
397: FROM FND_NEW_MESSAGES msg ,fnd_application apl
398: WHERE apl.application_id = msg.application_id
399: AND apl.application_short_name = cp_appl_name

Line 397: FROM FND_NEW_MESSAGES msg ,fnd_application apl

393: --smaddali: bug#3930425, modified this cursor for performance, to be based on appl_id and message_name as this is the PK
394: CURSOR c_msg_text_num (cp_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE ,
395: cp_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE) IS
396: SELECT message_number
397: FROM FND_NEW_MESSAGES msg ,fnd_application apl
398: WHERE apl.application_id = msg.application_id
399: AND apl.application_short_name = cp_appl_name
400: AND message_name = cp_message_name;
401:

Line 407: l_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

403: l_msg_data VARCHAR2(4000);
404: l_enc_msg VARCHAR2(2000);
405: l_msg_index NUMBER(4);
406: l_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
407: l_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
408: l_msg_number FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;
409: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
410: l_err_msg_id igs_en_lgcy_err_int.err_message_id%TYPE;
411: l_app VARCHAR2(10);

Line 408: l_msg_number FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;

404: l_enc_msg VARCHAR2(2000);
405: l_msg_index NUMBER(4);
406: l_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
407: l_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
408: l_msg_number FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;
409: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
410: l_err_msg_id igs_en_lgcy_err_int.err_message_id%TYPE;
411: l_app VARCHAR2(10);
412: BEGIN

Line 409: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

405: l_msg_index NUMBER(4);
406: l_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
407: l_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
408: l_msg_number FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;
409: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
410: l_err_msg_id igs_en_lgcy_err_int.err_message_id%TYPE;
411: l_app VARCHAR2(10);
412: BEGIN
413:

Line 3711: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

3707: WHERE batch_id = p_batch_id;
3708:
3709: l_description igs_en_lgcy_bat_int.description%TYPE;
3710: l_deletion_flag BOOLEAN;
3711: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
3712: l_msg_text0 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
3713: BEGIN
3714: /*
3715: This batch process has two modes.

Line 3712: l_msg_text0 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

3708:
3709: l_description igs_en_lgcy_bat_int.description%TYPE;
3710: l_deletion_flag BOOLEAN;
3711: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
3712: l_msg_text0 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
3713: BEGIN
3714: /*
3715: This batch process has two modes.
3716: 1. When the p_table_code is passed as 'All'