DBA Data[Home] [Help]

APPS.IGS_AD_ADM_REQ dependencies on FND_MESSAGE

Line 214: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');

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;

Line 215: log_detail(FND_MESSAGE.GET());

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;

Line 221: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PNUM');

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');

Line 222: FND_MESSAGE.SET_TOKEN('PNUM', l_get_person_number);

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);

Line 223: log_detail(FND_MESSAGE.GET());

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());

Line 225: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');

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');

Line 226: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);

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);

Line 227: log_detail(FND_MESSAGE.GET());

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());

Line 229: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');

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');

Line 230: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);

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);

Line 231: log_detail(FND_MESSAGE.GET());

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());

Line 233: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');

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');

Line 234: FND_MESSAGE.SET_TOKEN('CRCD', p_program_code);

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);

Line 235: log_detail(FND_MESSAGE.GET());

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());

Line 237: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');

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');

Line 238: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);

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);

Line 239: log_detail(FND_MESSAGE.GET());

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());

Line 241: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');

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');

Line 242: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);

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);

Line 243: log_detail(FND_MESSAGE.GET());

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());

Line 245: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');

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);

Line 246: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);

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;

Line 247: log_detail(FND_MESSAGE.GET());

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;

Line 253: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_OPNUM');

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');

Line 254: FND_MESSAGE.SET_TOKEN('OPNUM', l_get_person_number);

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);

Line 255: log_detail(FND_MESSAGE.GET());

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());

Line 257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_REQ_TYPE');

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

Line 258: FND_MESSAGE.SET_TOKEN('RTYP', get_meaning_req_type_rec.meaning);

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

Line 259: log_detail(FND_MESSAGE.GET());

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

Line 267: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_MANDATORY_PRM');

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: --

Line 268: log_detail(FND_MESSAGE.GET());

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

Line 319: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));

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

Line 355: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));

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;

Line 395: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');

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;

Line 396: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_adm_req.ini_adm_trk_itm');

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;

Line 397: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);

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

Line 600: log_detail(FND_MESSAGE.GET_STRING ( 'IGS', 'IGS_AD_PROC_ASSIGN_REQ_COMP'));

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');

Line 617: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));

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

Line 625: log_detail(FND_MESSAGE.GET_STRING('IGS', l_message_name));

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

Line 693: log_detail(FND_MESSAGE.GET_STRING( 'IGS', 'IGS_AD_TRAC_NOT_REQ_DELETED'));

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));

Line 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;

Line 760: log_detail(FND_MESSAGE.GET_STRING ( 'IGS', 'IGS_AD_TRAC_NOT_ASSIGN'));

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:

Line 1524: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;

Line 1525: fnd_message.set_token('NAME','IGS_AD_ADM_REQ.admp_get_trk_types - SQL Error is :'||SQLERRM);

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:

Line 1526: log_detail(FND_MESSAGE.GET);

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