121:
122: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
123: p_s_admission_process_type => l_s_admission_process_type,
124: p_s_admission_step_type => 'APPL-NOTES') = 'FALSE' THEN
125: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
126: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
127: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
128: l_error_text := FND_MESSAGE.GET;
129: UPDATE igs_ad_notes_int
122: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
123: p_s_admission_process_type => l_s_admission_process_type,
124: p_s_admission_step_type => 'APPL-NOTES') = 'FALSE' THEN
125: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
126: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
127: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
128: l_error_text := FND_MESSAGE.GET;
129: UPDATE igs_ad_notes_int
130: SET
123: p_s_admission_process_type => l_s_admission_process_type,
124: p_s_admission_step_type => 'APPL-NOTES') = 'FALSE' THEN
125: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
126: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
127: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
128: l_error_text := FND_MESSAGE.GET;
129: UPDATE igs_ad_notes_int
130: SET
131: status = cst_s_val_3
124: p_s_admission_step_type => 'APPL-NOTES') = 'FALSE' THEN
125: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
126: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
127: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
128: l_error_text := FND_MESSAGE.GET;
129: UPDATE igs_ad_notes_int
130: SET
131: status = cst_s_val_3
132: , error_code = cst_ec_val_E701
137: ELSIF NOT igs_ad_note_types_pkg.Get_UK2_For_Validation(
138: x_notes_type_id => notes_rec.Note_Type_Id,
139: x_notes_category => 'APPLICATION',
140: x_closed_ind => 'N') THEN
141: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
142: FND_MESSAGE.SET_TOKEN ('ATTRIBUTE', FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
143: l_error_text := FND_MESSAGE.GET;
144: UPDATE igs_ad_notes_int
145: SET
138: x_notes_type_id => notes_rec.Note_Type_Id,
139: x_notes_category => 'APPLICATION',
140: x_closed_ind => 'N') THEN
141: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
142: FND_MESSAGE.SET_TOKEN ('ATTRIBUTE', FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
143: l_error_text := FND_MESSAGE.GET;
144: UPDATE igs_ad_notes_int
145: SET
146: status = cst_s_val_3
139: x_notes_category => 'APPLICATION',
140: x_closed_ind => 'N') THEN
141: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
142: FND_MESSAGE.SET_TOKEN ('ATTRIBUTE', FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
143: l_error_text := FND_MESSAGE.GET;
144: UPDATE igs_ad_notes_int
145: SET
146: status = cst_s_val_3
147: , error_code = cst_ec_val_E701
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);
208:
209: l_debug_str := fnd_message.get;
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);
208:
209: l_debug_str := fnd_message.get;
210: fnd_log.string_with_context( fnd_log.level_exception,
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);
208:
209: l_debug_str := fnd_message.get;
210: fnd_log.string_with_context( fnd_log.level_exception,
211: l_label,
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);
208:
209: l_debug_str := fnd_message.get;
210: fnd_log.string_with_context( fnd_log.level_exception,
211: l_label,
212: l_debug_str, NULL,
213: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
225: END;
226: END IF;
227:
228: ELSE
229: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
230: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
231: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
232: l_error_text := FND_MESSAGE.GET;
233:
226: END IF;
227:
228: ELSE
229: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
230: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
231: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
232: l_error_text := FND_MESSAGE.GET;
233:
234: UPDATE igs_ad_notes_int
227:
228: ELSE
229: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
230: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
231: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
232: l_error_text := FND_MESSAGE.GET;
233:
234: UPDATE igs_ad_notes_int
235: SET status = cst_s_val_3
228: ELSE
229: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
230: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
231: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
232: l_error_text := FND_MESSAGE.GET;
233:
234: UPDATE igs_ad_notes_int
235: SET status = cst_s_val_3
236: , error_code = cst_ec_val_E701
344:
345: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
346: p_s_admission_process_type => l_s_admission_process_type,
347: p_s_admission_step_type => 'EDU-GOALS') = 'FALSE' THEN
348: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
349: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
350: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
351: l_error_text := FND_MESSAGE.GET;
352: UPDATE igs_ad_edugoal_int
345: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
346: p_s_admission_process_type => l_s_admission_process_type,
347: p_s_admission_step_type => 'EDU-GOALS') = 'FALSE' THEN
348: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
349: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
350: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
351: l_error_text := FND_MESSAGE.GET;
352: UPDATE igs_ad_edugoal_int
353: SET
346: p_s_admission_process_type => l_s_admission_process_type,
347: p_s_admission_step_type => 'EDU-GOALS') = 'FALSE' THEN
348: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
349: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
350: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
351: l_error_text := FND_MESSAGE.GET;
352: UPDATE igs_ad_edugoal_int
353: SET
354: status = cst_s_val_3
347: p_s_admission_step_type => 'EDU-GOALS') = 'FALSE' THEN
348: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
349: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
350: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
351: l_error_text := FND_MESSAGE.GET;
352: UPDATE igs_ad_edugoal_int
353: SET
354: status = cst_s_val_3
355: , error_code = cst_ec_val_E701
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;
411: fnd_log.string_with_context( fnd_log.level_exception,
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;
411: fnd_log.string_with_context( fnd_log.level_exception,
412: l_label,
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;
411: fnd_log.string_with_context( fnd_log.level_exception,
412: l_label,
413: l_debug_str, NULL,
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;
411: fnd_log.string_with_context( fnd_log.level_exception,
412: l_label,
413: l_debug_str, NULL,
414: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
423: l_records_processed := l_records_processed + 1;
424: END;
425: END IF;
426: ELSE
427: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
428: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
429: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
430: l_error_text := FND_MESSAGE.GET;
431: UPDATE igs_ad_edugoal_int
424: END;
425: END IF;
426: ELSE
427: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
428: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
429: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
430: l_error_text := FND_MESSAGE.GET;
431: UPDATE igs_ad_edugoal_int
432: SET
425: END IF;
426: ELSE
427: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
428: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
429: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
430: l_error_text := FND_MESSAGE.GET;
431: UPDATE igs_ad_edugoal_int
432: SET
433: status = cst_s_val_3
426: ELSE
427: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
428: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
429: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
430: l_error_text := FND_MESSAGE.GET;
431: UPDATE igs_ad_edugoal_int
432: SET
433: status = cst_s_val_3
434: , error_code = cst_ec_val_E701
577: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
578: p_s_admission_process_type => l_s_admission_process_type,
579: p_s_admission_step_type => 'DES-UNITSETS') = 'FALSE' THEN
580:
581: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
582: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
583: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
584: l_error_text := FND_MESSAGE.GET;
585:
578: p_s_admission_process_type => l_s_admission_process_type,
579: p_s_admission_step_type => 'DES-UNITSETS') = 'FALSE' THEN
580:
581: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
582: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
583: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
584: l_error_text := FND_MESSAGE.GET;
585:
586: UPDATE igs_ad_unitsets_int
579: p_s_admission_step_type => 'DES-UNITSETS') = 'FALSE' THEN
580:
581: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
582: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
583: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
584: l_error_text := FND_MESSAGE.GET;
585:
586: UPDATE igs_ad_unitsets_int
587: SET status = cst_s_val_3
580:
581: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
582: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
583: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
584: l_error_text := FND_MESSAGE.GET;
585:
586: UPDATE igs_ad_unitsets_int
587: SET status = cst_s_val_3
588: ,match_ind = DECODE (unitsets_rec.dmlmode, cst_update, DECODE (match_ind,NULL, cst_mi_val_12,match_ind),
667: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
668:
669: l_label := 'igs.plsql.igs_ad_imp_014.prc_apcnt_uset_apl.crt_upd_apcnt_uset_apl.for_loop.execption'||l_error_code;
670:
671: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
672: fnd_message.set_token('INTERFACE_ID',unitsets_rec.interface_unitsets_id);
673: fnd_message.set_token('ERROR_CD',l_error_code);
674:
675: l_debug_str := fnd_message.get;
668:
669: l_label := 'igs.plsql.igs_ad_imp_014.prc_apcnt_uset_apl.crt_upd_apcnt_uset_apl.for_loop.execption'||l_error_code;
670:
671: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
672: fnd_message.set_token('INTERFACE_ID',unitsets_rec.interface_unitsets_id);
673: fnd_message.set_token('ERROR_CD',l_error_code);
674:
675: l_debug_str := fnd_message.get;
676: fnd_log.string_with_context( fnd_log.level_exception,
669: l_label := 'igs.plsql.igs_ad_imp_014.prc_apcnt_uset_apl.crt_upd_apcnt_uset_apl.for_loop.execption'||l_error_code;
670:
671: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
672: fnd_message.set_token('INTERFACE_ID',unitsets_rec.interface_unitsets_id);
673: fnd_message.set_token('ERROR_CD',l_error_code);
674:
675: l_debug_str := fnd_message.get;
676: fnd_log.string_with_context( fnd_log.level_exception,
677: l_label,
671: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
672: fnd_message.set_token('INTERFACE_ID',unitsets_rec.interface_unitsets_id);
673: fnd_message.set_token('ERROR_CD',l_error_code);
674:
675: l_debug_str := fnd_message.get;
676: fnd_log.string_with_context( fnd_log.level_exception,
677: l_label,
678: l_debug_str, NULL,
679: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
695: END;
696: END IF;
697:
698: ELSE
699: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
700: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
701: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
702: l_error_text := FND_MESSAGE.GET;
703:
696: END IF;
697:
698: ELSE
699: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
700: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
701: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
702: l_error_text := FND_MESSAGE.GET;
703:
704: UPDATE igs_ad_unitsets_int
697:
698: ELSE
699: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
700: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
701: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
702: l_error_text := FND_MESSAGE.GET;
703:
704: UPDATE igs_ad_unitsets_int
705: SET status = cst_s_val_3
698: ELSE
699: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
700: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
701: FND_MESSAGE.SET_TOKEN ('APPLTYPE', unitsets_rec.admission_application_type);
702: l_error_text := FND_MESSAGE.GET;
703:
704: UPDATE igs_ad_unitsets_int
705: SET status = cst_s_val_3
706: , match_ind = DECODE (unitsets_rec.dmlmode, cst_update, DECODE (match_ind,NULL, cst_mi_val_12,match_ind),