eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_TI_COMP dependencies on FND_MESSAGE

Line 26: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_SUCFL');

22: l_message_name
23: )
24: THEN
25: -- Tracking Step Update to complete Successful
26: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_SUCFL');
27: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
28: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
29: RETURN TRUE ;
30: ELSE

Line 27: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);

23: )
24: THEN
25: -- Tracking Step Update to complete Successful
26: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_SUCFL');
27: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
28: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
29: RETURN TRUE ;
30: ELSE
31: -- Tracking Step Update to complete Failed

Line 28: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

24: THEN
25: -- Tracking Step Update to complete Successful
26: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_SUCFL');
27: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
28: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
29: RETURN TRUE ;
30: ELSE
31: -- Tracking Step Update to complete Failed
32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');

Line 32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');

28: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
29: RETURN TRUE ;
30: ELSE
31: -- Tracking Step Update to complete Failed
32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');
33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );
36: FND_MESSAGE.SET_NAME('IGS', l_message_name);

Line 33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);

29: RETURN TRUE ;
30: ELSE
31: -- Tracking Step Update to complete Failed
32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');
33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );
36: FND_MESSAGE.SET_NAME('IGS', l_message_name);
37: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);

30: ELSE
31: -- Tracking Step Update to complete Failed
32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');
33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );
36: FND_MESSAGE.SET_NAME('IGS', l_message_name);
37: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
38: RETURN FALSE;

Line 35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );

31: -- Tracking Step Update to complete Failed
32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');
33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );
36: FND_MESSAGE.SET_NAME('IGS', l_message_name);
37: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
38: RETURN FALSE;
39: END IF;

Line 36: FND_MESSAGE.SET_NAME('IGS', l_message_name);

32: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_STP_NT_SUCFL');
33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );
36: FND_MESSAGE.SET_NAME('IGS', l_message_name);
37: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
38: RETURN FALSE;
39: END IF;
40: END upd_trk_step_complete ;

Line 37: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

33: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
34: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
35: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET() );
36: FND_MESSAGE.SET_NAME('IGS', l_message_name);
37: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
38: RETURN FALSE;
39: END IF;
40: END upd_trk_step_complete ;
41:

Line 246: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ENR_DPT_NT_PAID');

242: OPEN cur_enrolment_deposit(p_person_id,p_admission_appl_number);
243: FETCH cur_enrolment_deposit INTO l_count;
244: IF cur_enrolment_deposit%NOTFOUND THEN
245: CLOSE cur_enrolment_deposit;
246: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ENR_DPT_NT_PAID');
247: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
248: RAISE tr_stp_no_records_exp;
249: ELSE
250: CLOSE cur_enrolment_deposit;

Line 247: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

243: FETCH cur_enrolment_deposit INTO l_count;
244: IF cur_enrolment_deposit%NOTFOUND THEN
245: CLOSE cur_enrolment_deposit;
246: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ENR_DPT_NT_PAID');
247: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
248: RAISE tr_stp_no_records_exp;
249: ELSE
250: CLOSE cur_enrolment_deposit;
251: -- If Enrollment Deposit records are present, then update the status to COMPLETED

Line 271: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CRD_DTL_NT_EXISTS');

267: FETCH cur_credentials INTO l_count;
268: -- If Credential records are not present in the system, then log a message and process the next Tracking Item in the Application.
269: IF cur_credentials%NOTFOUND THEN
270: CLOSE cur_credentials;
271: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CRD_DTL_NT_EXISTS');
272: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
273: RAISE tr_stp_no_records_exp;
274: ELSE
275: CLOSE cur_credentials;

Line 272: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

268: -- If Credential records are not present in the system, then log a message and process the next Tracking Item in the Application.
269: IF cur_credentials%NOTFOUND THEN
270: CLOSE cur_credentials;
271: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CRD_DTL_NT_EXISTS');
272: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
273: RAISE tr_stp_no_records_exp;
274: ELSE
275: CLOSE cur_credentials;
276: -- If Credential records are present, then update the status to COMPLETED

Line 295: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TST_DTL_NT_EXISTS');

291: FETCH cur_test INTO l_count;
292: -- If Test records are not present in the system, then log a message and process the next Tracking Item in the Application.
293: IF cur_test%NOTFOUND THEN
294: CLOSE cur_test;
295: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TST_DTL_NT_EXISTS');
296: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
297: RAISE tr_stp_no_records_exp;
298: ELSE
299: CLOSE cur_test;

Line 296: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

292: -- If Test records are not present in the system, then log a message and process the next Tracking Item in the Application.
293: IF cur_test%NOTFOUND THEN
294: CLOSE cur_test;
295: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TST_DTL_NT_EXISTS');
296: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
297: RAISE tr_stp_no_records_exp;
298: ELSE
299: CLOSE cur_test;
300: -- If Test records are present, then update the status to COMPLETED

Line 341: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');

337: IF (l_eid_records_not_found = TRUE) THEN
338: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
339: -- Message ('Tracking items do not exist for this application');
340: l_need_to_update := FALSE;
341: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
342: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
343: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
344: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
345: END IF;

Line 342: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);

338: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
339: -- Message ('Tracking items do not exist for this application');
340: l_need_to_update := FALSE;
341: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
342: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
343: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
344: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
345: END IF;
346: IF l_need_to_update THEN

Line 343: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);

339: -- Message ('Tracking items do not exist for this application');
340: l_need_to_update := FALSE;
341: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
342: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
343: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
344: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
345: END IF;
346: IF l_need_to_update THEN
347: IF NOT upd_trk_step_complete ( p_tracking_id,

Line 344: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

340: l_need_to_update := FALSE;
341: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
342: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
343: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
344: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
345: END IF;
346: IF l_need_to_update THEN
347: IF NOT upd_trk_step_complete ( p_tracking_id,
348: p_tracking_step_id,

Line 384: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');

380: IF l_eid_records_not_found THEN
381: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
382: -- Message ('Tracking items do not exist for this application');
383: l_need_to_update := FALSE;
384: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
385: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
386: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
387: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
388: END IF;

Line 385: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);

381: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
382: -- Message ('Tracking items do not exist for this application');
383: l_need_to_update := FALSE;
384: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
385: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
386: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
387: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
388: END IF;
389: IF l_need_to_update THEN

Line 386: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);

382: -- Message ('Tracking items do not exist for this application');
383: l_need_to_update := FALSE;
384: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
385: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
386: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
387: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
388: END IF;
389: IF l_need_to_update THEN
390: IF NOT upd_trk_step_complete ( p_tracking_id,

Line 387: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

383: l_need_to_update := FALSE;
384: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
385: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
386: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
387: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
388: END IF;
389: IF l_need_to_update THEN
390: IF NOT upd_trk_step_complete ( p_tracking_id,
391: p_tracking_step_id,

Line 430: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');

426: IF (l_eid_records_not_found = TRUE) THEN
427: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
428: -- Message ('Tracking items do not exist for this application');
429: l_need_to_update := FALSE;
430: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
431: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
432: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
433: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
434: END IF;

Line 431: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);

427: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
428: -- Message ('Tracking items do not exist for this application');
429: l_need_to_update := FALSE;
430: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
431: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
432: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
433: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
434: END IF;
435: IF l_need_to_update THEN

Line 432: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);

428: -- Message ('Tracking items do not exist for this application');
429: l_need_to_update := FALSE;
430: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
431: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
432: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
433: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
434: END IF;
435: IF l_need_to_update THEN
436: IF NOT upd_trk_step_complete ( p_tracking_id,

Line 433: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

429: l_need_to_update := FALSE;
430: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
431: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
432: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
433: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
434: END IF;
435: IF l_need_to_update THEN
436: IF NOT upd_trk_step_complete ( p_tracking_id,
437: p_tracking_step_id,

Line 473: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');

469: IF l_eid_records_not_found THEN
470: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
471: -- Message ('Tracking items do not exist for this application');
472: l_need_to_update := FALSE;
473: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
474: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
475: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
476: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
477: END IF;

Line 474: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);

470: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
471: -- Message ('Tracking items do not exist for this application');
472: l_need_to_update := FALSE;
473: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
474: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
475: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
476: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
477: END IF;
478: IF l_need_to_update THEN

Line 475: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);

471: -- Message ('Tracking items do not exist for this application');
472: l_need_to_update := FALSE;
473: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
474: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
475: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
476: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
477: END IF;
478: IF l_need_to_update THEN
479: IF NOT upd_trk_step_complete ( p_tracking_id,

Line 476: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

472: l_need_to_update := FALSE;
473: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_EID_NT_FND');
474: FND_MESSAGE.SET_TOKEN('TRID', p_tracking_id);
475: FND_MESSAGE.SET_TOKEN('STPID', p_tracking_step_id);
476: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
477: END IF;
478: IF l_need_to_update THEN
479: IF NOT upd_trk_step_complete ( p_tracking_id,
480: p_tracking_step_id,

Line 618: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_STPS');

614: END LOOP; -- End of Each Tracking Item Steps.
615: IF l_stp_records_not_found THEN
616: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
617: -- Message ('Tracking items do not exist for this application');
618: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_STPS');
619: FND_MESSAGE.SET_TOKEN('TRID', cur_tr_rec.tracking_id);
620: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
621:
622: END IF;

Line 619: FND_MESSAGE.SET_TOKEN('TRID', cur_tr_rec.tracking_id);

615: IF l_stp_records_not_found THEN
616: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
617: -- Message ('Tracking items do not exist for this application');
618: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_STPS');
619: FND_MESSAGE.SET_TOKEN('TRID', cur_tr_rec.tracking_id);
620: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
621:
622: END IF;
623:

Line 620: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

616: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
617: -- Message ('Tracking items do not exist for this application');
618: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_STPS');
619: FND_MESSAGE.SET_TOKEN('TRID', cur_tr_rec.tracking_id);
620: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
621:
622: END IF;
623:
624: END LOOP;

Line 629: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_ITM');

625:
626: IF l_records_not_found THEN
627: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
628: -- Message ('Tracking items do not exist for this application');
629: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_ITM');
630: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
631:
632: END IF;
633:

Line 630: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

626: IF l_records_not_found THEN
627: -- The tracking items are yet to be created for this application so the tracking items completion cannot take place.
628: -- Message ('Tracking items do not exist for this application');
629: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_NO_TR_ITM');
630: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
631:
632: END IF;
633:
634: EXCEPTION

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

755: RETCODE := 0;
756: ERRBUF := NULL;
757: lv_sql_stmt := igs_pe_dynamic_persid_group.get_dynamic_sql(p_person_id_group,lv_status,lv_group_type);
758: -- Log the Initial parameters into the LOG file.
759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761:
762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);

Line 760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

756: ERRBUF := NULL;
757: lv_sql_stmt := igs_pe_dynamic_persid_group.get_dynamic_sql(p_person_id_group,lv_status,lv_group_type);
758: -- Log the Initial parameters into the LOG file.
759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761:
762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');

758: -- Log the Initial parameters into the LOG file.
759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761:
762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
765:
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');

Line 763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);

759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_PRMS');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761:
762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
765:
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);

Line 764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761:
762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
765:
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

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

762: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
765:
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769:
770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');

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

763: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
765:
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769:
770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);

Line 768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

764: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
765:
766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769:
770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

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

766: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769:
770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
773:
774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');

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

767: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769:
770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
773:
774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);

Line 772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769:
770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
773:
774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

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

770: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
773:
774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
777:
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');

Line 775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);

771: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
773:
774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
777:
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);

Line 776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

772: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
773:
774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
777:
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

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

774: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
777:
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
781:
782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');

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

775: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
777:
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
781:
782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);

Line 780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

776: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
777:
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
781:
782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

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

778: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
781:
782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');

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

779: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
781:
782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
787: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);

Line 784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

780: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
781:
782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
787: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
788: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

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

782: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
787: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
788: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
789:
790: -- Get the Academic Calander details form the Academic Calender Parameter

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

783: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
787: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
788: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
789:
790: -- Get the Academic Calander details form the Academic Calender Parameter
791: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));

Line 788: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

784: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
787: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
788: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
789:
790: -- Get the Academic Calander details form the Academic Calender Parameter
791: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
792: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

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

824:
825: --Message One of the following Parameters Person Id, Person Id Group, Calendar Details
826: --or Admission Process Category is mandatory.
827:
828: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_MANDATORY_PRM');
829: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
830: RETURN;
831:
832:

Line 829: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

825: --Message One of the following Parameters Person Id, Person Id Group, Calendar Details
826: --or Admission Process Category is mandatory.
827:
828: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_MANDATORY_PRM');
829: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
830: RETURN;
831:
832:
833: ELSIF (p_person_id IS NOT NULL AND

Line 840: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');

836: -- to be entered is Person ID or Person Group ID or Person ID, Admission Application
837: -- Number, Program Code, Sequence Number or Academic Calendar, Admission Calendar,
838: -- Admission Process Category.
839:
840: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');
841: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
842: RETURN;
843:
844:

Line 841: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

837: -- Number, Program Code, Sequence Number or Academic Calendar, Admission Calendar,
838: -- Admission Process Category.
839:
840: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');
841: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
842: RETURN;
843:
844:
845: ELSIF ( p_person_id IS NULL AND

Line 948: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');

944: -- If the Applicaiton records are not found then log a message
945: IF l_records_not_found THEN
946: -- Tracking steps cannot be completed for applications not having application completion status of pending
947: -- and application outcome status of pending or conditional offer
948: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
949: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
950:
951: -- Abort the process and raise error
952: RETURN;

Line 949: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

945: IF l_records_not_found THEN
946: -- Tracking steps cannot be completed for applications not having application completion status of pending
947: -- and application outcome status of pending or conditional offer
948: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
949: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
950:
951: -- Abort the process and raise error
952: RETURN;
953: END IF;

Line 957: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');

953: END IF;
954:
955: EXCEPTION
956: WHEN OTHERS THEN
957: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
958: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
959: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);
960: END;
961:

Line 958: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);

954:
955: EXCEPTION
956: WHEN OTHERS THEN
957: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
958: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
959: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);
960: END;
961:
962: ELSE

Line 963: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');

959: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);
960: END;
961:
962: ELSE
963: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');
964: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
965: END IF;
966:
967: ELSE

Line 964: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);

960: END;
961:
962: ELSE
963: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');
964: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
965: END IF;
966:
967: ELSE
968:

Line 1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');

1005: END LOOP;
1006: IF l_records_not_found THEN
1007: -- Tracking steps cannot be completed for applications not having application completion status of pending
1008: -- and application outcome status of pending or conditional offer
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
1010: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1011:
1012: -- Abort the process and raise error
1013: RETURN;

Line 1010: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

1006: IF l_records_not_found THEN
1007: -- Tracking steps cannot be completed for applications not having application completion status of pending
1008: -- and application outcome status of pending or conditional offer
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
1010: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1011:
1012: -- Abort the process and raise error
1013: RETURN;
1014: END IF;

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

1021: END IF;
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');
1026: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_ti_comp.upd_trk_itm_st');
1027: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);
1028: -- Rollback the transaction
1029: ROLLBACK;

Line 1026: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_ti_comp.upd_trk_itm_st');

1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');
1026: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_ti_comp.upd_trk_itm_st');
1027: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);
1028: -- Rollback the transaction
1029: ROLLBACK;
1030: retcode := 2;

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

1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: FND_MESSAGE.SET_NAME ( 'IGS', 'IGS_GE_UNHANDLED_EXP');
1026: FND_MESSAGE.SET_TOKEN ( 'NAME', ' igs_ad_ti_comp.upd_trk_itm_st');
1027: errbuf := FND_MESSAGE.GET_STRING ( 'IGS', FND_MESSAGE.GET);
1028: -- Rollback the transaction
1029: ROLLBACK;
1030: retcode := 2;
1031: -- Handle the standard igs-message stack