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:
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;
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;
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:
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:
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
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: /*
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');
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
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:
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);
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
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:
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.
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'