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_IMP_024

Line 1: PACKAGE BODY igs_ad_imp_024 AS

1: PACKAGE BODY igs_ad_imp_024 AS
2: /* $Header: IGSADB2B.pls 120.4 2006/04/13 05:53:45 stammine ship $ */
3: /***************************Status,Discrepancy Rule, Match Indicators, Error Codes********************/
4: cst_rule_val_I CONSTANT VARCHAR2(1) := 'I';
5: cst_rule_val_E CONSTANT VARCHAR2(1) := 'E';

Line 113: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_024.prc_trscrpt';

109: l_minint NUMBER(15);
110:
111:
112: dup_cur_rec c_dup_cur%ROWTYPE;
113: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_024.prc_trscrpt';
114: l_label VARCHAR2(1000) ;
115: l_debug_str VARCHAR2(1000) ;
116: l_processed_records NUMBER(5) ;
117: l_count_interface_txpt_id NUMBER;

Line 217: l_label :='igs.plsql.igs_ad_imp_024.create_new_transcript_details.exception '||l_msg_data;

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;
218:
219: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
220: fnd_message.set_token('INTERFACE_ID',p_trans_record.interface_transcript_id);
221: fnd_message.set_token('ERROR_CD','E322');

Line 348: l_label := 'igs.plsql.igs_ad_imp_024.create_new_transcript_details.exception '||l_msg_data;

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;
349:
350: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
351: fnd_message.set_token('INTERFACE_ID',p_trans_record.interface_transcript_id);
352: fnd_message.set_token('ERROR_CD','E014');

Line 750: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_024.process_term_details';

746: l_minint NUMBER(15);
747:
748:
749: dup_cur_rec c_dup_cur%ROWTYPE;
750: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_024.process_term_details';
751: l_label VARCHAR2(1000) ;
752: l_debug_str VARCHAR2(1000) ;
753: l_processed_records NUMBER(5) ;
754:

Line 825: l_label :='igs.plsql.igs_ad_imp_024.create_term_details.exception '||l_msg_data;

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;
826:
827: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
828: fnd_message.set_token('INTERFACE_ID',p_term_dtls_record.interface_term_dtls_id);
829: fnd_message.set_token('ERROR_CD','E322');

Line 915: l_label := 'igs.plsql.igs_ad_imp_024.update_term_details.exception '||l_msg_data;

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;
916:
917: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
918: fnd_message.set_token('INTERFACE_ID',p_term_dtls_record.interface_term_dtls_id);
919: fnd_message.set_token('ERROR_CD','E014');

Line 1188: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_024.process_term_unit_details';

1184: l_maxint NUMBER(15);
1185: l_minint NUMBER(15);
1186:
1187: dup_cur_rec c_dup_cur%ROWTYPE;
1188: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_024.process_term_unit_details';
1189: l_label VARCHAR2(1000) ;
1190: l_debug_str VARCHAR2(1000) ;
1191: l_total_records_prcessed NUMBER;
1192: l_count_interface_unitdtls_id NUMBER;

Line 1262: l_label :='igs.plsql.igs_ad_imp_024.create_term_unit_details.exception '||l_msg_data;

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;
1263:
1264: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1265: fnd_message.set_token('INTERFACE_ID', p_term_unitdtls_record.interface_term_dtls_id);
1266: fnd_message.set_token('ERROR_CD','E322');

Line 1350: l_label := 'igs.plsql.igs_ad_imp_024.update_term_details.exception '||l_msg_data;

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;
1351:
1352: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1353: fnd_message.set_token('INTERFACE_ID',p_term_unitdtls_record.interface_term_unitdtls_id);
1354: fnd_message.set_token('ERROR_CD','E014');

Line 1551: END igs_ad_imp_024;

1547:
1548: END process_term_unit_details;
1549:
1550:
1551: END igs_ad_imp_024;