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_015 dependencies on IGS_AD_IMP_015

Line 1: PACKAGE BODY igs_ad_imp_015 AS

1: PACKAGE BODY igs_ad_imp_015 AS
2: /* $Header: IGSAD93B.pls 120.2 2006/04/13 05:52:53 stammine ship $ */
3:
4: /******************************************************************
5: Created By : knag

Line 53: l_prog_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp';

49: l_label VARCHAR2(4000);
50: l_request_id NUMBER;
51: l_debug_str VARCHAR2(4000);
52: BEGIN
53: l_prog_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp';
54: l_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp.';
55:
56: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
57:

Line 54: l_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp.';

50: l_request_id NUMBER;
51: l_debug_str VARCHAR2(4000);
52: BEGIN
53: l_prog_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp';
54: l_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp.';
55:
56: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
57:
58: IF (l_request_id IS NULL) THEN

Line 62: l_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp.begin';

58: IF (l_request_id IS NULL) THEN
59: l_request_id := fnd_global.conc_request_id;
60: END IF;
61:
62: l_label := 'igs.plsql.igs_ad_imp_015.sel_ad_src_cat_imp.begin';
63: l_debug_str := 'Source Type Id : ' || p_source_type_id || ' Batch ID : ' || p_batch_id;
64:
65: fnd_log.string_with_context (fnd_log.level_procedure,
66: l_label,

Line 139: igs_ad_imp_015.sel_ad_src_cat_imp (p_source_type_id => p_source_type_id,

135:
136: BEGIN
137:
138: -- Select categories for import
139: igs_ad_imp_015.sel_ad_src_cat_imp (p_source_type_id => p_source_type_id,
140: p_batch_id => p_batch_id,
141: p_enable_log => p_enable_log,
142: p_legacy_ind => p_legacy_ind);
143:

Line 144: l_prog_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category';

140: p_batch_id => p_batch_id,
141: p_enable_log => p_enable_log,
142: p_legacy_ind => p_legacy_ind);
143:
144: l_prog_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category';
145: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.';
146:
147: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
148:

Line 145: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.';

141: p_enable_log => p_enable_log,
142: p_legacy_ind => p_legacy_ind);
143:
144: l_prog_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category';
145: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.';
146:
147: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
148:
149: IF (l_request_id IS NULL) THEN

Line 153: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.begin';

149: IF (l_request_id IS NULL) THEN
150: l_request_id := fnd_global.conc_request_id;
151: END IF;
152:
153: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.begin';
154: l_debug_str := 'Source Type Id : ' || p_source_type_id || ' Batch ID : ' || p_batch_id;
155:
156: fnd_log.string_with_context (fnd_log.level_procedure,
157: l_label,

Line 319: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.after_prc_tst_rslt';

315: IF (l_request_id IS NULL) THEN
316: l_request_id := fnd_global.conc_request_id;
317: END IF;
318:
319: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.after_prc_tst_rslt';
320: l_debug_str := 'Test Results Processed Succesfully';
321:
322: fnd_log.string_with_context (fnd_log.level_procedure,
323: l_label,

Line 340: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.before_prc_transcript_dtls';

336: IF (l_request_id IS NULL) THEN
337: l_request_id := fnd_global.conc_request_id;
338: END IF;
339:
340: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.before_prc_transcript_dtls';
341: l_debug_str := 'Befoer Processing Transcript Details';
342:
343: fnd_log.string_with_context (fnd_log.level_procedure,
344: l_label,

Line 897: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.Leaving';

893: IF (l_request_id IS NULL) THEN
894: l_request_id := fnd_global.conc_request_id;
895: END IF;
896:
897: l_label := 'igs.plsql.igs_ad_imp_015.prc_ad_category.Leaving';
898: l_debug_str := 'Leaving prc_ad_category';
899:
900: fnd_log.string_with_context (fnd_log.level_procedure,
901: l_label,

Line 992: l_prog_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records';

988: l_stmt VARCHAR2(2000);
989:
990: BEGIN
991:
992: l_prog_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records';
993: l_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records.';
994:
995: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
996:

Line 993: l_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records.';

989:
990: BEGIN
991:
992: l_prog_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records';
993: l_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records.';
994:
995: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
996:
997: IF (l_request_id IS NULL) THEN

Line 1001: l_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records.begin';

997: IF (l_request_id IS NULL) THEN
998: l_request_id := fnd_global.conc_request_id;
999: END IF;
1000:
1001: l_label := 'igs.plsql.igs_ad_imp_015.del_cmpld_ad_records.begin';
1002: l_debug_str := 'Source Type Id : ' || p_source_type_id || ' Batch ID : ' || p_batch_id;
1003:
1004: fnd_log.string_with_context (fnd_log.level_procedure,
1005: l_label,

Line 1167: END igs_ad_imp_015;

1163: END IF; -- g_person_qual_inc
1164:
1165: END del_cmpld_ad_records;
1166:
1167: END igs_ad_imp_015;