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_016 dependencies on IGS_AD_GEN_016

Line 46: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);

42: cst_dsp CONSTANT VARCHAR2(10) := 'DSPCHECK';
43:
44: cst_unique_record CONSTANT NUMBER := 1;
45:
46: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);

Line 47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

43:
44: cst_unique_record CONSTANT NUMBER := 1;
45:
46: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);

Line 48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

44: cst_unique_record CONSTANT NUMBER := 1;
45:
46: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);
52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);

Line 49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);

45:
46: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);
52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
53: cst_et_val_E014 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E014', 8405);

Line 50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);

46: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);
52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
53: cst_et_val_E014 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E014', 8405);
54:

Line 51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);

47: cst_et_val_E701 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);
52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
53: cst_et_val_E014 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E014', 8405);
54:
55:

Line 52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);

48: cst_et_val_E678 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);
52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
53: cst_et_val_E014 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E014', 8405);
54:
55:
56: cst_ec_val_E322 VARCHAR2(4) := 'E322';

Line 53: cst_et_val_E014 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E014', 8405);

49: cst_et_val_E347 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405);
50: cst_et_val_E577 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E577', 8405);
51: cst_et_val_E705 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E705', 8405);
52: cst_et_val_E322 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
53: cst_et_val_E014 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E014', 8405);
54:
55:
56: cst_ec_val_E322 VARCHAR2(4) := 'E322';
57: cst_ec_val_E014 VARCHAR2(4) := 'E014';

Line 181: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

177: l_msg_at_index NUMBER := 0;
178: l_return_status VARCHAR2(1);
179: l_msg_count NUMBER ;
180: l_msg_data VARCHAR2(2000);
181: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
182:
183: l_records_processed NUMBER;
184: l_rowid VARCHAR2(30);
185: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%TYPE;

Line 775: igs_ad_gen_016.extract_msg_from_stack (

771: ELSIF test_dtls_rec.dmlmode = cst_update THEN
772: l_error_code := 'E014'; -- Update Failed
773: END IF;
774:
775: igs_ad_gen_016.extract_msg_from_stack (
776: p_msg_at_index => l_msg_at_index,
777: p_return_status => l_return_status,
778: p_msg_count => l_msg_count,
779: p_msg_data => l_msg_data,

Line 781: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

777: p_return_status => l_return_status,
778: p_msg_count => l_msg_count,
779: p_msg_data => l_msg_data,
780: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
781: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
782:
783: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
784: IF p_enable_log = 'Y' THEN
785: igs_ad_imp_001.logerrormessage(test_dtls_rec.interface_testsegs_id,l_msg_data,'IGS_AD_TEST_SEGS_INT');

Line 850: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405);

846: EXCEPTION
847: WHEN test_seg_failed THEN
848: ROLLBACK TO test_results_sp;
849: l_error_code :='E347';
850: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405);
851:
852: UPDATE igs_ad_test_int
853: SET status = DECODE (test_rec.dmlmode,cst_dsp,cst_s_val_4,
854: cst_s_val_3)

Line 884: igs_ad_gen_016.extract_msg_from_stack (

880: ELSIF test_rec.dmlmode = cst_update THEN
881: l_error_code := 'E014'; -- Update Failed
882: END IF;
883:
884: igs_ad_gen_016.extract_msg_from_stack (
885: p_msg_at_index => l_msg_at_index,
886: p_return_status => l_return_status,
887: p_msg_count => l_msg_count,
888: p_msg_data => l_msg_data,

Line 890: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

886: p_return_status => l_return_status,
887: p_msg_count => l_msg_count,
888: p_msg_data => l_msg_data,
889: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
890: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
891:
892: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
893: l_error_text := l_msg_data;
894: IF p_enable_log = 'Y' THEN