210:
211: ELSE
212:
213: -- Log the Initial parameters into the LOG file.
214: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');
215: log_detail(FND_MESSAGE.GET());
216:
217: OPEN c_get_person_number(p_person_id);
218: FETCH c_get_person_number INTO l_get_person_number;
211: ELSE
212:
213: -- Log the Initial parameters into the LOG file.
214: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');
215: log_detail(FND_MESSAGE.GET());
216:
217: OPEN c_get_person_number(p_person_id);
218: FETCH c_get_person_number INTO l_get_person_number;
219: CLOSE c_get_person_number;
217: OPEN c_get_person_number(p_person_id);
218: FETCH c_get_person_number INTO l_get_person_number;
219: CLOSE c_get_person_number;
220:
221: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PNUM');
222: FND_MESSAGE.SET_TOKEN('PNUM', l_get_person_number);
223: log_detail(FND_MESSAGE.GET());
224:
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
218: FETCH c_get_person_number INTO l_get_person_number;
219: CLOSE c_get_person_number;
220:
221: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PNUM');
222: FND_MESSAGE.SET_TOKEN('PNUM', l_get_person_number);
223: log_detail(FND_MESSAGE.GET());
224:
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
219: CLOSE c_get_person_number;
220:
221: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PNUM');
222: FND_MESSAGE.SET_TOKEN('PNUM', l_get_person_number);
223: log_detail(FND_MESSAGE.GET());
224:
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
227: log_detail(FND_MESSAGE.GET());
221: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PNUM');
222: FND_MESSAGE.SET_TOKEN('PNUM', l_get_person_number);
223: log_detail(FND_MESSAGE.GET());
224:
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
227: log_detail(FND_MESSAGE.GET());
228:
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
222: FND_MESSAGE.SET_TOKEN('PNUM', l_get_person_number);
223: log_detail(FND_MESSAGE.GET());
224:
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
227: log_detail(FND_MESSAGE.GET());
228:
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
223: log_detail(FND_MESSAGE.GET());
224:
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
227: log_detail(FND_MESSAGE.GET());
228:
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
231: log_detail(FND_MESSAGE.GET());
225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
227: log_detail(FND_MESSAGE.GET());
228:
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
231: log_detail(FND_MESSAGE.GET());
232:
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
227: log_detail(FND_MESSAGE.GET());
228:
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
231: log_detail(FND_MESSAGE.GET());
232:
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
227: log_detail(FND_MESSAGE.GET());
228:
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
231: log_detail(FND_MESSAGE.GET());
232:
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
235: log_detail(FND_MESSAGE.GET());
229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
231: log_detail(FND_MESSAGE.GET());
232:
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
235: log_detail(FND_MESSAGE.GET());
236:
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
231: log_detail(FND_MESSAGE.GET());
232:
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
235: log_detail(FND_MESSAGE.GET());
236:
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
231: log_detail(FND_MESSAGE.GET());
232:
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
235: log_detail(FND_MESSAGE.GET());
236:
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
239: log_detail(FND_MESSAGE.GET());
233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
235: log_detail(FND_MESSAGE.GET());
236:
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
239: log_detail(FND_MESSAGE.GET());
240:
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);
235: log_detail(FND_MESSAGE.GET());
236:
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
239: log_detail(FND_MESSAGE.GET());
240:
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
235: log_detail(FND_MESSAGE.GET());
236:
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
239: log_detail(FND_MESSAGE.GET());
240:
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
243: log_detail(FND_MESSAGE.GET());
237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
239: log_detail(FND_MESSAGE.GET());
240:
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
243: log_detail(FND_MESSAGE.GET());
244:
245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
239: log_detail(FND_MESSAGE.GET());
240:
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
243: log_detail(FND_MESSAGE.GET());
244:
245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
246: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
239: log_detail(FND_MESSAGE.GET());
240:
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
243: log_detail(FND_MESSAGE.GET());
244:
245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
246: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
247: log_detail(FND_MESSAGE.GET());
241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
243: log_detail(FND_MESSAGE.GET());
244:
245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
246: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
247: log_detail(FND_MESSAGE.GET());
248:
249: OPEN c_get_person_number(p_originator_person);
242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
243: log_detail(FND_MESSAGE.GET());
244:
245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
246: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
247: log_detail(FND_MESSAGE.GET());
248:
249: OPEN c_get_person_number(p_originator_person);
250: FETCH c_get_person_number INTO l_get_person_number;
243: log_detail(FND_MESSAGE.GET());
244:
245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
246: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
247: log_detail(FND_MESSAGE.GET());
248:
249: OPEN c_get_person_number(p_originator_person);
250: FETCH c_get_person_number INTO l_get_person_number;
251: CLOSE c_get_person_number;
249: OPEN c_get_person_number(p_originator_person);
250: FETCH c_get_person_number INTO l_get_person_number;
251: CLOSE c_get_person_number;
252:
253: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_OPNUM');
254: FND_MESSAGE.SET_TOKEN('OPNUM', l_get_person_number);
255: log_detail(FND_MESSAGE.GET());
256:
257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');
250: FETCH c_get_person_number INTO l_get_person_number;
251: CLOSE c_get_person_number;
252:
253: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_OPNUM');
254: FND_MESSAGE.SET_TOKEN('OPNUM', l_get_person_number);
255: log_detail(FND_MESSAGE.GET());
256:
257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');
258: FND_MESSAGE.SET_TOKEN('RTYP', get_meaning_req_type_rec.meaning);
251: CLOSE c_get_person_number;
252:
253: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_OPNUM');
254: FND_MESSAGE.SET_TOKEN('OPNUM', l_get_person_number);
255: log_detail(FND_MESSAGE.GET());
256:
257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');
258: FND_MESSAGE.SET_TOKEN('RTYP', get_meaning_req_type_rec.meaning);
259: log_detail(FND_MESSAGE.GET());
253: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_OPNUM');
254: FND_MESSAGE.SET_TOKEN('OPNUM', l_get_person_number);
255: log_detail(FND_MESSAGE.GET());
256:
257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');
258: FND_MESSAGE.SET_TOKEN('RTYP', get_meaning_req_type_rec.meaning);
259: log_detail(FND_MESSAGE.GET());
260:
261: IF p_person_id IS NULL AND
254: FND_MESSAGE.SET_TOKEN('OPNUM', l_get_person_number);
255: log_detail(FND_MESSAGE.GET());
256:
257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');
258: FND_MESSAGE.SET_TOKEN('RTYP', get_meaning_req_type_rec.meaning);
259: log_detail(FND_MESSAGE.GET());
260:
261: IF p_person_id IS NULL AND
262: p_person_id_group IS NULL AND
255: log_detail(FND_MESSAGE.GET());
256:
257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');
258: FND_MESSAGE.SET_TOKEN('RTYP', get_meaning_req_type_rec.meaning);
259: log_detail(FND_MESSAGE.GET());
260:
261: IF p_person_id IS NULL AND
262: p_person_id_group IS NULL AND
263: p_calendar_details IS NULL AND
263: p_calendar_details IS NULL AND
264: p_admission_process_category IS NULL THEN
265: --Message One of the following Parameters Person Id, Person Id Group, Calendar Details
266: --or Admission Process Category is mandatory.
267: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_MANDATORY_PRM');
268: log_detail(FND_MESSAGE.GET());
269: ELSE
270: SAVEPOINT ini_adm_trk_prcs;
271: --
264: p_admission_process_category IS NULL THEN
265: --Message One of the following Parameters Person Id, Person Id Group, Calendar Details
266: --or Admission Process Category is mandatory.
267: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_MANDATORY_PRM');
268: log_detail(FND_MESSAGE.GET());
269: ELSE
270: SAVEPOINT ini_adm_trk_prcs;
271: --
272: -- Split the calendar details and the admission process category into seperate variables
315: p_tracking_status => get_dflt_active_track_stat_rec.tracking_status,
316: p_message_name => l_message_name
317: ) THEN
318: IF l_message_name IS NOT NULL THEN
319: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));
320: END IF;
321: END IF;
322: END LOOP;
323: ELSIF p_requirements_type = 'POST_ADMISSION' THEN
351: p_tracking_status => get_dflt_active_track_stat_rec.tracking_status,
352: p_message_name => l_message_name
353: ) THEN
354: IF l_message_name IS NOT NULL THEN
355: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));
356: END IF;
357: END IF;
358: END LOOP;
359: END IF;
391: END IF;
392: EXCEPTION
393: WHEN OTHERS THEN
394: log_detail( FND_GLOBAL.NEWLINE );
395: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');
396: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_adm_req.ini_adm_trk_itm');
397: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);
398: -- Rollback the transaction
399: ROLLBACK TO ini_adm_trk_prcs;
392: EXCEPTION
393: WHEN OTHERS THEN
394: log_detail( FND_GLOBAL.NEWLINE );
395: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');
396: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_adm_req.ini_adm_trk_itm');
397: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);
398: -- Rollback the transaction
399: ROLLBACK TO ini_adm_trk_prcs;
400: retcode := 2;
393: WHEN OTHERS THEN
394: log_detail( FND_GLOBAL.NEWLINE );
395: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');
396: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_adm_req.ini_adm_trk_itm');
397: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);
398: -- Rollback the transaction
399: ROLLBACK TO ini_adm_trk_prcs;
400: retcode := 2;
401: -- Handle the standard igs-message stack
596: --
597: -- Process completed successfully tracking items
598: -- created for the Application Instances entered
599: --
600: log_detail(FND_MESSAGE.GET_STRING ( 'IGS', 'IGS_AD_PROC_ASSIGN_REQ_COMP'));
601: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN ( l_tracking_id) ||' for tracking type :: ' || p_tracking_type);
602:
603: ELSE
604: log_detail('Failed to create the tracking item link to admission application instance');
613: log_detail('Failed to create the tracking item for the admission application instance');
614: log_detail('For the tracking type :: ' || p_tracking_type);
615: p_message_name := l_message_name;
616: IF l_message_name IS NOT NULL THEN
617: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));
618: END IF;
619: END IF;
620: EXCEPTION
621: WHEN OTHERS THEN
621: WHEN OTHERS THEN
622: log_detail('Failed to create the tracking item for the admission application instance');
623: log_detail('For the tracking type :: ' || p_tracking_type);
624: IF l_message_name IS NOT NULL THEN
625: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));
626: END IF;
627: END crt_adm_trkitm;
628: --
629: -- End Of Local Function crt_adm_trkitm
689: */
690: FOR check_existence_rec IN check_existence_cur LOOP
691: igs_ad_aplins_admreq_pkg.delete_row ( check_existence_rec.rowid);
692: IF igs_tr_gen_002.trkp_del_tri ( check_existence_rec.tracking_id, l_message_name) THEN
693: log_detail(FND_MESSAGE.GET_STRING( 'IGS', 'IGS_AD_TRAC_NOT_REQ_DELETED'));
694: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
695: ' of tracking type :: ' || check_existence_rec.tracking_type);
696: ELSE
697: log_detail(FND_MESSAGE.GET_STRING( 'IGS', l_message_name));
693: log_detail(FND_MESSAGE.GET_STRING( 'IGS', 'IGS_AD_TRAC_NOT_REQ_DELETED'));
694: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
695: ' of tracking type :: ' || check_existence_rec.tracking_type);
696: ELSE
697: log_detail(FND_MESSAGE.GET_STRING( 'IGS', l_message_name));
698: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
699: ' of tracking type :: ' || check_existence_rec.tracking_type);
700: ROLLBACK TO sp_trkitm_aplproc;
701: RETURN FALSE;
756: END IF;
757: CLOSE process_apc_cur;
758:
759: IF NOT l_trk_ind THEN
760: log_detail(FND_MESSAGE.GET_STRING ( 'IGS', 'IGS_AD_TRAC_NOT_ASSIGN'));
761: ROLLBACK TO sp_trkitm_aplproc;
762: RETURN FALSE;
763: ELSE
764:
1520: No need to display in log, since has nothing to do with user defined rule
1521: but parsing and evaluation of the same through code and system defined rule
1522: If it fails here need to debug igs_ru_gen_001.rulp_val_senna
1523:
1524: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1525: fnd_message.set_token('NAME','IGS_AD_ADM_REQ.admp_get_trk_types - SQL Error is :'||SQLERRM);
1526: log_detail(FND_MESSAGE.GET);
1527: */
1528: END;
1521: but parsing and evaluation of the same through code and system defined rule
1522: If it fails here need to debug igs_ru_gen_001.rulp_val_senna
1523:
1524: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1525: fnd_message.set_token('NAME','IGS_AD_ADM_REQ.admp_get_trk_types - SQL Error is :'||SQLERRM);
1526: log_detail(FND_MESSAGE.GET);
1527: */
1528: END;
1529:
1522: If it fails here need to debug igs_ru_gen_001.rulp_val_senna
1523:
1524: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1525: fnd_message.set_token('NAME','IGS_AD_ADM_REQ.admp_get_trk_types - SQL Error is :'||SQLERRM);
1526: log_detail(FND_MESSAGE.GET);
1527: */
1528: END;
1529:
1530: IF lv_result IS NOT NULL THEN