1: PACKAGE BODY Igs_Ad_Imp_010 AS
2: /* $Header: IGSAD88B.pls 120.0 2005/06/02 03:46:30 appldev noship $ */
3: /******************************************************************
4: Created By:
5: Date Created By:
101: BEGIN
102: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
103:
104:
105: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.crt_apcnt_notes';
106: l_debug_str := 'Interface Run ID' || p_interface_run_id;
107:
108: fnd_log.string_with_context( fnd_log.level_procedure,
109: l_label,
199: END IF;
200: ELSE
201: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
202:
203: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.crt_apcnt_notes.for_loop.execption'||l_error_code;
204:
205: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
206: fnd_message.set_token('INTERFACE_ID',notes_rec.interface_notes_id);
207: fnd_message.set_token('ERROR_CD',l_error_code);
250: END crt_apcnt_notes;
251: -- Local Procedure crt_apcnt_notes end here
252: BEGIN
253:
254: l_prog_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots';
255: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.';
256: l_request_id := fnd_global.conc_request_id;
257:
258: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
251: -- Local Procedure crt_apcnt_notes end here
252: BEGIN
253:
254: l_prog_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots';
255: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.';
256: l_request_id := fnd_global.conc_request_id;
257:
258: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
259: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.begin';
255: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.';
256: l_request_id := fnd_global.conc_request_id;
257:
258: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
259: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.begin';
260: l_debug_str := 'igs_ad_imp_010.admp_val_pappl_nots';
261: fnd_log.string_with_context(fnd_log.level_procedure,
262: l_label,
263: l_debug_str, NULL,
256: l_request_id := fnd_global.conc_request_id;
257:
258: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
259: l_label := 'igs.plsql.igs_ad_imp_010.admp_val_pappl_nots.begin';
260: l_debug_str := 'igs_ad_imp_010.admp_val_pappl_nots';
261: fnd_log.string_with_context(fnd_log.level_procedure,
262: l_label,
263: l_debug_str, NULL,
264: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
325:
326: BEGIN
327:
328: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
329: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.create_applicant_edu_goals';
330: l_debug_str := 'Interface Run ID' || p_interface_run_id;
331: fnd_log.string_with_context( fnd_log.level_procedure,
332: l_label,
333: l_debug_str, NULL,
402: igs_ad_imp_001.logerrormessage(edugoal_rec.interface_edugoal_id,l_msg_data,'IGS_AD_EDUGOAL_INT');
403: END IF;
404: ELSE
405: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
406: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.create_applicant_edu_goals.for_loop.execption'||l_error_code;
407: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
408: fnd_message.set_token('INTERFACE_ID',edugoal_rec.interface_edugoal_id);
409: fnd_message.set_token('ERROR_CD',l_error_code);
410: l_debug_str := fnd_message.get;
448: END create_applicant_edu_goals;
449:
450: BEGIN
451:
452: l_prog_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls';
453: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.';
454: l_request_id := fnd_global.conc_request_id;
455:
456: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
449:
450: BEGIN
451:
452: l_prog_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls';
453: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.';
454: l_request_id := fnd_global.conc_request_id;
455:
456: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
457: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.begin';
453: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.';
454: l_request_id := fnd_global.conc_request_id;
455:
456: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
457: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.begin';
458: l_debug_str := 'igs_ad_imp_010.prcs_applnt_edu_goal_dtls';
459: fnd_log.string_with_context( fnd_log.level_procedure,
460: l_label,
461: l_debug_str, NULL,
454: l_request_id := fnd_global.conc_request_id;
455:
456: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
457: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.begin';
458: l_debug_str := 'igs_ad_imp_010.prcs_applnt_edu_goal_dtls';
459: fnd_log.string_with_context( fnd_log.level_procedure,
460: l_label,
461: l_debug_str, NULL,
462: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
856: END IF;
857:
858: END prc_apcnt_uset_apl;
859:
860: END Igs_Ad_Imp_010;