APPS.IGS_AD_IMP_028 dependencies on IGS_AD_IMP_028

Line 1: PACKAGE BODY Igs_Ad_Imp_028 AS

1: PACKAGE BODY Igs_Ad_Imp_028 AS
2: /* $Header: IGSADC8B.pls 115.8 2003/12/09 13:32:42 pbondugu noship $ */
3:
4: /*************************************
5: || Change History

Line 83: l_prog_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details';

79: l_msg_data VARCHAR2(2000);
80: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
81:
82: BEGIN
83: l_prog_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details';
84:
85: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
86: l_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details.begin';
87: l_debug_str := 'igs_ad_imp_028.prc_pe_qual_details.start';

Line 86: l_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details.begin';

82: BEGIN
83: l_prog_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details';
84:
85: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
86: l_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details.begin';
87: l_debug_str := 'igs_ad_imp_028.prc_pe_qual_details.start';
88:
89: fnd_log.string_with_context( fnd_log.level_procedure,
90: l_label,

Line 87: l_debug_str := 'igs_ad_imp_028.prc_pe_qual_details.start';

83: l_prog_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details';
84:
85: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
86: l_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details.begin';
87: l_debug_str := 'igs_ad_imp_028.prc_pe_qual_details.start';
88:
89: fnd_log.string_with_context( fnd_log.level_procedure,
90: l_label,
91: l_debug_str, NULL,

Line 141: FOR uc_qual_rec IN IGS_AD_IMP_028.c_uc_qual_cur(p_interface_run_id )

137:
138: COMMIT;
139: l_person_id := NULL;
140: l_person_id_errored := NULL;
141: FOR uc_qual_rec IN IGS_AD_IMP_028.c_uc_qual_cur(p_interface_run_id )
142: LOOP
143: IF uc_qual_rec.person_id <> NVL(l_person_id, uc_qual_rec.person_id) THEN
144: COMMIT;
145: END IF;

Line 228: l_label := 'igs.plsql.igs_ad_imp_028.prc_uc_qual_dtls.exception '||l_msg_data;

224: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
225: l_error_Code := 'E518';
226: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
227:
228: l_label := 'igs.plsql.igs_ad_imp_028.prc_uc_qual_dtls.exception '||l_msg_data;
229:
230: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
231: fnd_message.set_token('INTERFACE_ID',uc_qual_rec.interface_qual_id);
232: fnd_message.set_token('ERROR_CD','E322');

Line 265: END Igs_Ad_Imp_028;

261: END LOOP;
262: COMMIT;
263: END prc_pe_qual_details;
264:
265: END Igs_Ad_Imp_028;