eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_024 dependencies on IGS_AD_GEN_016

Line 65: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

61: l_msg_at_index NUMBER := 0;
62: l_return_status VARCHAR2(1);
63: l_msg_count NUMBER ;
64: l_msg_data VARCHAR2(2000);
65: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
66:
67:
68: CURSOR trans_cur(cp_start_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE, --ARVSRINI--
69: cp_end_int_id igs_ad_txcpt_int.interface_transcript_id%TYPE) IS --ARVSRINI--

Line 199: igs_ad_gen_016.extract_msg_from_stack (

195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: ROLLBACK TO before_create_transcript;
199: igs_ad_gen_016.extract_msg_from_stack (
200: p_msg_at_index => l_msg_at_index,
201: p_return_status => l_return_status,
202: p_msg_count => l_msg_count,
203: p_msg_data => l_msg_data,

Line 213: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405) ;

209: IF p_enable_log = 'Y' THEN
210: igs_ad_imp_001.logerrormessage(p_trans_record.interface_transcript_id,l_msg_data,'IGS_AD_TXCPT_INT');
211: END IF;
212: ELSE
213: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405) ;
214: l_error_code := 'E518';
215: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
216:
217: l_label :='igs.plsql.igs_ad_imp_024.create_new_transcript_details.exception '||l_msg_data;

Line 264: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

260: l_msg_at_index NUMBER := 0;
261: l_return_status VARCHAR2(1);
262: l_msg_count NUMBER ;
263: l_msg_data VARCHAR2(2000);
264: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
265: l_error_code VARCHAR2(4) := NULL;
266: l_error_text VARCHAR2(2000) := NULL;
267:
268:

Line 330: igs_ad_gen_016.extract_msg_from_stack (

326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: ROLLBACK TO before_update_transcript;
330: igs_ad_gen_016.extract_msg_from_stack (
331: p_msg_at_index => l_msg_at_index,
332: p_return_status => l_return_status,
333: p_msg_count => l_msg_count,
334: p_msg_data => l_msg_data,

Line 344: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);

340: IF p_enable_log = 'Y' THEN
341: igs_ad_imp_001.logerrormessage(p_trans_record.interface_transcript_id,l_msg_data,'IGS_AD_TXCPT_INT');
342: END IF;
343: ELSE
344: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
345: l_error_code := 'E518';
346: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
347:
348: l_label := 'igs.plsql.igs_ad_imp_024.create_new_transcript_details.exception '||l_msg_data;

Line 382: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E707', 8405)

378: --If given invalid update transcript ID then error out.
379: UPDATE IGS_AD_TXCPT_INT trans
380: SET
381: status = '3', error_code = 'E707',
382: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E707', 8405)
383: WHERE interface_run_id = p_interface_run_id
384: AND status = '2'
385: AND trans.update_transcript_id IS NOT NULL
386: AND NOT EXISTS ( SELECT 1 FROM IGS_AD_TRANSCRIPT

Line 396: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)

392:
393: UPDATE IGS_AD_TXCPT_INT trans
394: SET
395: status = '3', error_code = 'E334',
396: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
397: WHERE interface_run_id = p_interface_run_id
398: AND status = '2'
399: AND trans.transcript_source IS NOT NULL
400: AND EXISTS ( SELECT 1 FROM igs_ad_code_classes_v code

Line 413: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

409: UPDATE igs_ad_txcpt_int
410: SET
411: status = '3'
412: , error_code = 'E700'
413: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
414: WHERE interface_run_id = p_interface_run_id
415: AND status = '2'
416: AND NVL (match_ind, '15') <> '15';
417: END IF;

Line 484: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)

480: SET
481: status = '3'
482: , match_ind = '19'
483: ,error_code = 'E708'
484: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)
485: WHERE interface_run_id = p_interface_run_id
486: AND status = '2'
487: AND EXISTS( SELECT 1 FROM IGS_AD_TRMDT_INT term
488: WHERE term.interface_transcript_id = trans.interface_transcript_id

Line 636: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

632: UPDATE igs_ad_txcpt_int trans
633: SET
634: status = '3'
635: , error_code = 'E700'
636: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
637: WHERE interface_run_id = p_interface_run_id
638: AND status = '2'
639: AND match_ind IS NOT NULL;
640: END IF;

Line 776: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

772: l_msg_at_index NUMBER := 0;
773: l_return_status VARCHAR2(1);
774: l_msg_count NUMBER ;
775: l_msg_data VARCHAR2(2000);
776: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
777: l_error_code VARCHAR2(4) := NULL;
778: l_error_text VARCHAR2(2000):= NULL;
779: BEGIN
780: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 807: igs_ad_gen_016.extract_msg_from_stack (

803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: ROLLBACK TO before_create_term;
807: igs_ad_gen_016.extract_msg_from_stack (
808: p_msg_at_index => l_msg_at_index,
809: p_return_status => l_return_status,
810: p_msg_count => l_msg_count,
811: p_msg_data => l_msg_data,

Line 821: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);

817: IF p_enable_log = 'Y' THEN
818: igs_ad_imp_001.logerrormessage(p_term_dtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TRMDT_INT');
819: END IF;
820: ELSE
821: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
822: l_error_code := 'E518';
823: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
824:
825: l_label :='igs.plsql.igs_ad_imp_024.create_term_details.exception '||l_msg_data;

Line 869: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

865: l_msg_at_index NUMBER := 0;
866: l_return_status VARCHAR2(1);
867: l_msg_count NUMBER ;
868: l_msg_data VARCHAR2(2000);
869: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
870: l_error_code VARCHAR2(4) := NULL;
871: l_error_text VARCHAR2(2000):= NULL;
872: BEGIN
873: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 897: igs_ad_gen_016.extract_msg_from_stack (

893:
894: EXCEPTION
895: WHEN OTHERS THEN
896: ROLLBACK TO before_update_term;
897: igs_ad_gen_016.extract_msg_from_stack (
898: p_msg_at_index => l_msg_at_index,
899: p_return_status => l_return_status,
900: p_msg_count => l_msg_count,
901: p_msg_data => l_msg_data,

Line 911: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);

907: IF p_enable_log = 'Y' THEN
908: igs_ad_imp_001.logerrormessage( p_term_dtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TRMDT_INT');
909: END IF;
910: ELSE
911: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
912: l_error_code := 'E518';
913: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
914:
915: l_label := 'igs.plsql.igs_ad_imp_024.update_term_details.exception '||l_msg_data;

Line 950: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)

946: UPDATE igs_ad_trmdt_int term
947: SET
948: status = '3'
949: ,error_code = 'E334'
950: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
951: WHERE interface_run_id = p_interface_run_id
952: AND status = '2'
953: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code
954: WHERE trans.interface_transcript_id = term.interface_transcript_id

Line 968: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

964: UPDATE igs_ad_trmdt_int
965: SET
966: status = '3'
967: , error_code = 'E700'
968: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
969: WHERE interface_run_id = p_interface_run_id
970: AND status = '2'
971: AND NVL (match_ind, '15') <> '15';
972: END IF;

Line 991: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)

987: UPDATE igs_ad_trmdt_int term
988: SET
989: status = '3'
990: , error_code = 'E708'
991: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)
992: WHERE interface_run_id = p_interface_run_id
993: AND status = '2'
994: AND EXISTS ( SELECT 1 FROM igs_ad_tundt_int
995: WHERE interface_term_dtls_id = term.interface_term_dtls_id

Line 1133: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

1129: UPDATE igs_ad_trmdt_int term
1130: SET
1131: status = '3'
1132: , error_code = 'E700'
1133: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
1134: WHERE interface_run_id = p_interface_run_id
1135: AND status = '2'
1136: AND match_ind IS NOT NULL;
1137: END IF;

Line 1212: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1208: l_msg_at_index NUMBER := 0;
1209: l_return_status VARCHAR2(1);
1210: l_msg_count NUMBER ;
1211: l_msg_data VARCHAR2(2000);
1212: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1213: l_error_code VARCHAR2(4) := NULL;
1214: l_error_text VARCHAR2(2000):= NULL;
1215: BEGIN
1216: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 1244: igs_ad_gen_016.extract_msg_from_stack (

1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: ROLLBACK TO before_create_unit;
1244: igs_ad_gen_016.extract_msg_from_stack (
1245: p_msg_at_index => l_msg_at_index,
1246: p_return_status => l_return_status,
1247: p_msg_count => l_msg_count,
1248: p_msg_data => l_msg_data,

Line 1258: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);

1254: IF p_enable_log = 'Y' THEN
1255: igs_ad_imp_001.logerrormessage(p_term_unitdtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TUNDT_INT');
1256: END IF;
1257: ELSE
1258: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1259: l_error_code := 'E518';
1260: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1261:
1262: l_label :='igs.plsql.igs_ad_imp_024.create_term_unit_details.exception '||l_msg_data;

Line 1305: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1301: l_msg_at_index NUMBER := 0;
1302: l_return_status VARCHAR2(1);
1303: l_msg_count NUMBER ;
1304: l_msg_data VARCHAR2(2000);
1305: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1306: l_error_code VARCHAR2(4) := NULL;
1307: l_error_text VARCHAR2(2000):= NULL;
1308: BEGIN
1309: l_msg_at_index := igs_ge_msg_stack.count_msg;

Line 1332: igs_ad_gen_016.extract_msg_from_stack (

1328: WHERE interface_term_unitdtls_id = p_term_unitdtls_record.interface_term_unitdtls_id;
1329: EXCEPTION
1330: WHEN OTHERS THEN
1331: ROLLBACK TO before_update_unit;
1332: igs_ad_gen_016.extract_msg_from_stack (
1333: p_msg_at_index => l_msg_at_index,
1334: p_return_status => l_return_status,
1335: p_msg_count => l_msg_count,
1336: p_msg_data => l_msg_data,

Line 1346: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);

1342: IF p_enable_log = 'Y' THEN
1343: igs_ad_imp_001.logerrormessage( p_term_unitdtls_record.interface_term_unitdtls_id,l_msg_data,'IGS_AD_TUNDT_INT');
1344: END IF;
1345: ELSE
1346: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1347: l_error_code := 'E518';
1348: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1349:
1350: l_label := 'igs.plsql.igs_ad_imp_024.update_term_details.exception '||l_msg_data;

Line 1386: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)

1382: UPDATE igs_ad_tundt_int unit
1383: SET
1384: status = '3'
1385: , error_code = 'E334'
1386: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
1387: WHERE interface_run_id = p_interface_run_id
1388: AND status = '2'
1389: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code,
1390: igs_ad_trmdt_int term

Line 1406: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

1402: UPDATE igs_ad_tundt_int
1403: SET
1404: status = '3'
1405: , error_code = 'E700'
1406: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
1407: WHERE interface_run_id = p_interface_run_id
1408: AND status = '2'
1409: AND NVL (match_ind, '15') <> '15';
1410: END IF;

Line 1541: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

1537: UPDATE igs_ad_tundt_int unit
1538: SET
1539: status = '3'
1540: , error_code = 'E700'
1541: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
1542: WHERE interface_run_id = p_interface_run_id
1543: AND status = '2'
1544: AND match_ind IS NOT NULL;
1545: END IF;