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_UC_PROC_APPLICATION_DATA dependencies on FND_MESSAGE

Line 45: fnd_message.set_name('IGS','IGS_UC_CURR_INST_NOT_SET');

41: FETCH crnt_inst_cur INTO g_crnt_institute;
42: CLOSE crnt_inst_cur;
43:
44: IF g_crnt_institute IS NULL THEN
45: fnd_message.set_name('IGS','IGS_UC_CURR_INST_NOT_SET');
46: errbuf := fnd_message.get;
47: fnd_file.put_line(fnd_file.log, errbuf);
48: retcode := 2;
49: END IF;

Line 46: errbuf := fnd_message.get;

42: CLOSE crnt_inst_cur;
43:
44: IF g_crnt_institute IS NULL THEN
45: fnd_message.set_name('IGS','IGS_UC_CURR_INST_NOT_SET');
46: errbuf := fnd_message.get;
47: fnd_file.put_line(fnd_file.log, errbuf);
48: retcode := 2;
49: END IF;
50:

Line 57: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');

53: FETCH get_config_cycle_cur INTO g_config_cycle; --JCHAKRAB - modified for UCAS 2005 changes
54: CLOSE get_config_cycle_cur;
55:
56: IF g_config_cycle IS NULL THEN
57: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
58: errbuf := fnd_message.get;
59: fnd_file.put_line(fnd_file.log, errbuf);
60: retcode := 2;
61: END IF;

Line 58: errbuf := fnd_message.get;

54: CLOSE get_config_cycle_cur;
55:
56: IF g_config_cycle IS NULL THEN
57: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
58: errbuf := fnd_message.get;
59: fnd_file.put_line(fnd_file.log, errbuf);
60: retcode := 2;
61: END IF;
62:

Line 66: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: ROLLBACK;
66: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
67: fnd_message.set_token('NAME', 'PROCESS_UCAS_DATA.APPL_DATA_SETUP');
68: retcode := 2;
69: errbuf := fnd_message.get;
70: fnd_file.put_line(fnd_file.log, errbuf);

Line 67: fnd_message.set_token('NAME', 'PROCESS_UCAS_DATA.APPL_DATA_SETUP');

63: EXCEPTION
64: WHEN OTHERS THEN
65: ROLLBACK;
66: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
67: fnd_message.set_token('NAME', 'PROCESS_UCAS_DATA.APPL_DATA_SETUP');
68: retcode := 2;
69: errbuf := fnd_message.get;
70: fnd_file.put_line(fnd_file.log, errbuf);
71: END appl_data_setup;

Line 69: errbuf := fnd_message.get;

65: ROLLBACK;
66: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
67: fnd_message.set_token('NAME', 'PROCESS_UCAS_DATA.APPL_DATA_SETUP');
68: retcode := 2;
69: errbuf := fnd_message.get;
70: fnd_file.put_line(fnd_file.log, errbuf);
71: END appl_data_setup;
72:
73: PROCEDURE validate_applicant (p_appno igs_uc_applicants.app_no%TYPE,

Line 196: fnd_Message.Set_name('IGS','IGS_UC_ERR_CREATE_PRSN');

192: -- update count for failure records
193: l_failure_cnt := l_failure_cnt + 1;
194:
195: -- log error message/meaning.
196: fnd_Message.Set_name('IGS','IGS_UC_ERR_CREATE_PRSN');
197: fnd_message.set_token('APPNO', ivstarn_rec.appno);
198: fnd_message.set_token('INTERFACE_ID', ivstarn_rec.ad_interface_id);
199: fnd_message.set_token('BATCH', ivstarn_rec.ad_batch_id);
200: fnd_file.put_line(fnd_file.LOG, fnd_message.get());

Line 197: fnd_message.set_token('APPNO', ivstarn_rec.appno);

193: l_failure_cnt := l_failure_cnt + 1;
194:
195: -- log error message/meaning.
196: fnd_Message.Set_name('IGS','IGS_UC_ERR_CREATE_PRSN');
197: fnd_message.set_token('APPNO', ivstarn_rec.appno);
198: fnd_message.set_token('INTERFACE_ID', ivstarn_rec.ad_interface_id);
199: fnd_message.set_token('BATCH', ivstarn_rec.ad_batch_id);
200: fnd_file.put_line(fnd_file.LOG, fnd_message.get());
201:

Line 198: fnd_message.set_token('INTERFACE_ID', ivstarn_rec.ad_interface_id);

194:
195: -- log error message/meaning.
196: fnd_Message.Set_name('IGS','IGS_UC_ERR_CREATE_PRSN');
197: fnd_message.set_token('APPNO', ivstarn_rec.appno);
198: fnd_message.set_token('INTERFACE_ID', ivstarn_rec.ad_interface_id);
199: fnd_message.set_token('BATCH', ivstarn_rec.ad_batch_id);
200: fnd_file.put_line(fnd_file.LOG, fnd_message.get());
201:
202: END IF;

Line 199: fnd_message.set_token('BATCH', ivstarn_rec.ad_batch_id);

195: -- log error message/meaning.
196: fnd_Message.Set_name('IGS','IGS_UC_ERR_CREATE_PRSN');
197: fnd_message.set_token('APPNO', ivstarn_rec.appno);
198: fnd_message.set_token('INTERFACE_ID', ivstarn_rec.ad_interface_id);
199: fnd_message.set_token('BATCH', ivstarn_rec.ad_batch_id);
200: fnd_file.put_line(fnd_file.LOG, fnd_message.get());
201:
202: END IF;
203:

Line 200: fnd_file.put_line(fnd_file.LOG, fnd_message.get());

196: fnd_Message.Set_name('IGS','IGS_UC_ERR_CREATE_PRSN');
197: fnd_message.set_token('APPNO', ivstarn_rec.appno);
198: fnd_message.set_token('INTERFACE_ID', ivstarn_rec.ad_interface_id);
199: fnd_message.set_token('BATCH', ivstarn_rec.ad_batch_id);
200: fnd_file.put_line(fnd_file.LOG, fnd_message.get());
201:
202: END IF;
203:
204: END LOOP;

Line 217: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

213: CLOSE ad_interface_cur;
214: END IF;
215:
216: -- even though the admission import process completes in error , this process should continue processing
217: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
218: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_UPDATE_IVSTARN_STATUS'||' - '||SQLERRM);
219: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
220:
221: END proc_update_ivstarn_status;

Line 218: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_UPDATE_IVSTARN_STATUS'||' - '||SQLERRM);

214: END IF;
215:
216: -- even though the admission import process completes in error , this process should continue processing
217: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
218: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_UPDATE_IVSTARN_STATUS'||' - '||SQLERRM);
219: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
220:
221: END proc_update_ivstarn_status;
222:

Line 219: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

215:
216: -- even though the admission import process completes in error , this process should continue processing
217: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
218: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_UPDATE_IVSTARN_STATUS'||' - '||SQLERRM);
219: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
220:
221: END proc_update_ivstarn_status;
222:
223:

Line 265: fnd_Message.Set_name('IGS','IGS_UC_PRSN_UPDATE_FOR_APPNO');

261: BEGIN
262:
263: -- log Processing message
264: fnd_file.put_line(fnd_file.log, '==========================================================================');
265: fnd_Message.Set_name('IGS','IGS_UC_PRSN_UPDATE_FOR_APPNO');
266: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
267: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
268: fnd_file.put_line(fnd_file.log, '==========================================================================');
269:

Line 266: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

262:
263: -- log Processing message
264: fnd_file.put_line(fnd_file.log, '==========================================================================');
265: fnd_Message.Set_name('IGS','IGS_UC_PRSN_UPDATE_FOR_APPNO');
266: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
267: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
268: fnd_file.put_line(fnd_file.log, '==========================================================================');
269:
270: FOR ucas_app_person_rec IN ucas_app_person_cur

Line 267: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

263: -- log Processing message
264: fnd_file.put_line(fnd_file.log, '==========================================================================');
265: fnd_Message.Set_name('IGS','IGS_UC_PRSN_UPDATE_FOR_APPNO');
266: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
267: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
268: fnd_file.put_line(fnd_file.log, '==========================================================================');
269:
270: FOR ucas_app_person_rec IN ucas_app_person_cur
271: LOOP

Line 303: fnd_Message.Set_name('IGS','IGS_UC_PRSN_POPULATE_APPNO');

299:
300: IF l_oss_person_id IS NOT NULL THEN
301:
302: -- log Processing message
303: fnd_Message.Set_name('IGS','IGS_UC_PRSN_POPULATE_APPNO');
304: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));
305: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
306:
307: -- update UCAS Applicants table with Person ID.

Line 304: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));

300: IF l_oss_person_id IS NOT NULL THEN
301:
302: -- log Processing message
303: fnd_Message.Set_name('IGS','IGS_UC_PRSN_POPULATE_APPNO');
304: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));
305: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
306:
307: -- update UCAS Applicants table with Person ID.
308: BEGIN

Line 305: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

301:
302: -- log Processing message
303: fnd_Message.Set_name('IGS','IGS_UC_PRSN_POPULATE_APPNO');
304: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));
305: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
306:
307: -- update UCAS Applicants table with Person ID.
308: BEGIN
309: igs_uc_applicants_pkg.update_row -- IGSXI01B.pls

Line 437: fnd_Message.Set_name('IGS','IGS_UC_ERR_PRSN_POPULATION');

433: CLOSE get_person_cur;
434: END IF;
435:
436: fnd_file.put_line(fnd_file.LOG, SQLERRM);
437: fnd_Message.Set_name('IGS','IGS_UC_ERR_PRSN_POPULATION');
438: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));
439: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
440: END;
441:

Line 438: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));

434: END IF;
435:
436: fnd_file.put_line(fnd_file.LOG, SQLERRM);
437: fnd_Message.Set_name('IGS','IGS_UC_ERR_PRSN_POPULATION');
438: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));
439: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
440: END;
441:
442: END LOOP;

Line 439: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

435:
436: fnd_file.put_line(fnd_file.LOG, SQLERRM);
437: fnd_Message.Set_name('IGS','IGS_UC_ERR_PRSN_POPULATION');
438: fnd_message.set_token('APPNO', TO_CHAR(ucas_app_person_rec.app_no));
439: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
440: END;
441:
442: END LOOP;
443:

Line 447: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: -- even though Exception is raised in this process, process should continue.
447: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
448: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_POPULATE_OSS_PERSON'||' - '||SQLERRM);
449: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
450: END proc_populate_oss_person ;
451:

Line 448: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_POPULATE_OSS_PERSON'||' - '||SQLERRM);

444: EXCEPTION
445: WHEN OTHERS THEN
446: -- even though Exception is raised in this process, process should continue.
447: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
448: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_POPULATE_OSS_PERSON'||' - '||SQLERRM);
449: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
450: END proc_populate_oss_person ;
451:
452:

Line 449: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

445: WHEN OTHERS THEN
446: -- even though Exception is raised in this process, process should continue.
447: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
448: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_POPULATE_OSS_PERSON'||' - '||SQLERRM);
449: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
450: END proc_populate_oss_person ;
451:
452:
453:

Line 482: fnd_Message.Set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');

478:
479: BEGIN
480:
481: fnd_file.put_line(fnd_file.log, '==========================================================================');
482: fnd_Message.Set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
483: fnd_message.set_token('REQ_ID', TO_CHAR(p_batch_id) || ' At ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
484: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
485: fnd_file.put_line(fnd_file.log, '==========================================================================');
486:

Line 483: fnd_message.set_token('REQ_ID', TO_CHAR(p_batch_id) || ' At ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

479: BEGIN
480:
481: fnd_file.put_line(fnd_file.log, '==========================================================================');
482: fnd_Message.Set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
483: fnd_message.set_token('REQ_ID', TO_CHAR(p_batch_id) || ' At ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
484: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
485: fnd_file.put_line(fnd_file.log, '==========================================================================');
486:
487: -- Get the match set criteria corresponding to the ucas source type to be used for the person import

Line 484: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

480:
481: fnd_file.put_line(fnd_file.log, '==========================================================================');
482: fnd_Message.Set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
483: fnd_message.set_token('REQ_ID', TO_CHAR(p_batch_id) || ' At ' || TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
484: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
485: fnd_file.put_line(fnd_file.log, '==========================================================================');
486:
487: -- Get the match set criteria corresponding to the ucas source type to be used for the person import
488: match_set_rec := NULL ;

Line 515: fnd_Message.Set_name('IGS', 'IGS_UC_RTRN_ADM_IMP_PROC') ;

511: P_org_id => NULL
512: );
513:
514: fnd_file.put_line(fnd_file.log, '==========================================================================');
515: fnd_Message.Set_name('IGS', 'IGS_UC_RTRN_ADM_IMP_PROC') ;
516: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
517: fnd_file.put_line(fnd_file.log, fnd_message.get);
518: fnd_file.put_line(fnd_file.log, '==========================================================================');
519:

Line 516: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

512: );
513:
514: fnd_file.put_line(fnd_file.log, '==========================================================================');
515: fnd_Message.Set_name('IGS', 'IGS_UC_RTRN_ADM_IMP_PROC') ;
516: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
517: fnd_file.put_line(fnd_file.log, fnd_message.get);
518: fnd_file.put_line(fnd_file.log, '==========================================================================');
519:
520: EXCEPTION

Line 517: fnd_file.put_line(fnd_file.log, fnd_message.get);

513:
514: fnd_file.put_line(fnd_file.log, '==========================================================================');
515: fnd_Message.Set_name('IGS', 'IGS_UC_RTRN_ADM_IMP_PROC') ;
516: fnd_message.set_token('TIME', TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
517: fnd_file.put_line(fnd_file.log, fnd_message.get);
518: fnd_file.put_line(fnd_file.log, '==========================================================================');
519:
520: EXCEPTION
521: WHEN OTHERS THEN

Line 529: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

525: IF cur_match_set%ISOPEN THEN
526: CLOSE cur_match_set;
527: END IF;
528:
529: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
530: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_INVOKE_ADM_IMP_PROCESS'||' - '||SQLERRM);
531: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
532:
533: END proc_invoke_adm_imp_process;

Line 530: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_INVOKE_ADM_IMP_PROCESS'||' - '||SQLERRM);

526: CLOSE cur_match_set;
527: END IF;
528:
529: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
530: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_INVOKE_ADM_IMP_PROCESS'||' - '||SQLERRM);
531: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
532:
533: END proc_invoke_adm_imp_process;
534:

Line 531: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

527: END IF;
528:
529: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
530: fnd_message.set_token('NAME','IGS_UC_PROC_APPLICATION_DATA.PROC_INVOKE_ADM_IMP_PROCESS'||' - '||SQLERRM);
531: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
532:
533: END proc_invoke_adm_imp_process;
534:
535:

Line 660: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

656: g_error_rec_cnt := 0;
657: g_error_code := NULL;
658: l_invoke_adm_import_Proc_flag := 'N';
659:
660: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
661: fnd_message.set_token('VIEW', 'IVSTARN ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
662: fnd_file.put_line(fnd_file.log, fnd_message.get);
663:
664: ----------------------------------------------------

Line 661: fnd_message.set_token('VIEW', 'IVSTARN ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

657: g_error_code := NULL;
658: l_invoke_adm_import_Proc_flag := 'N';
659:
660: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
661: fnd_message.set_token('VIEW', 'IVSTARN ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
662: fnd_file.put_line(fnd_file.log, fnd_message.get);
663:
664: ----------------------------------------------------
665: -- Derive the SOURCE TYPE ID value for UCAS PER.

Line 662: fnd_file.put_line(fnd_file.log, fnd_message.get);

658: l_invoke_adm_import_Proc_flag := 'N';
659:
660: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
661: fnd_message.set_token('VIEW', 'IVSTARN ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
662: fnd_file.put_line(fnd_file.log, fnd_message.get);
663:
664: ----------------------------------------------------
665: -- Derive the SOURCE TYPE ID value for UCAS PER.
666: -- Derived only once per execution of this procedure

Line 673: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');

669: FETCH src_types_cur INTO l_source_type_id;
670:
671: IF (src_types_cur%NOTFOUND) THEN
672: CLOSE src_types_cur;
673: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');
674: fnd_file.put_line(fnd_file.log, fnd_message.get);
675: App_Exception.Raise_Exception;
676: END IF;
677: CLOSE src_types_cur;

Line 674: fnd_file.put_line(fnd_file.log, fnd_message.get);

670:
671: IF (src_types_cur%NOTFOUND) THEN
672: CLOSE src_types_cur;
673: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');
674: fnd_file.put_line(fnd_file.log, fnd_message.get);
675: App_Exception.Raise_Exception;
676: END IF;
677: CLOSE src_types_cur;
678:

Line 700: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

696: l_interface_id := 0;
697: l_alt_pers_seq_id := 0;
698:
699: -- log record processing info.
700: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
701: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarn_rec.appno));
702: fnd_file.put_line(fnd_file.log, fnd_message.get);
703:
704:

Line 701: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarn_rec.appno));

697: l_alt_pers_seq_id := 0;
698:
699: -- log record processing info.
700: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
701: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarn_rec.appno));
702: fnd_file.put_line(fnd_file.log, fnd_message.get);
703:
704:
705: SAVEPOINT ivstarn_rec_savepoint;

Line 702: fnd_file.put_line(fnd_file.log, fnd_message.get);

698:
699: -- log record processing info.
700: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
701: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarn_rec.appno));
702: fnd_file.put_line(fnd_file.log, fnd_message.get);
703:
704:
705: SAVEPOINT ivstarn_rec_savepoint;
706:

Line 770: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

766: FETCH cur_map INTO l_oss_sex_val;
767: CLOSE cur_map;
768:
769: IF l_oss_sex_val IS NULL THEN
770: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
771: fnd_message.set_token('CODE', new_ivstarn_rec.sex);
772: fnd_message.set_token('TYPE', 'SEX');
773: fnd_file.put_line(fnd_file.log, fnd_message.get);
774: g_error_code := '1054';

Line 771: fnd_message.set_token('CODE', new_ivstarn_rec.sex);

767: CLOSE cur_map;
768:
769: IF l_oss_sex_val IS NULL THEN
770: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
771: fnd_message.set_token('CODE', new_ivstarn_rec.sex);
772: fnd_message.set_token('TYPE', 'SEX');
773: fnd_file.put_line(fnd_file.log, fnd_message.get);
774: g_error_code := '1054';
775: END IF;

Line 772: fnd_message.set_token('TYPE', 'SEX');

768:
769: IF l_oss_sex_val IS NULL THEN
770: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
771: fnd_message.set_token('CODE', new_ivstarn_rec.sex);
772: fnd_message.set_token('TYPE', 'SEX');
773: fnd_file.put_line(fnd_file.log, fnd_message.get);
774: g_error_code := '1054';
775: END IF;
776:

Line 773: fnd_file.put_line(fnd_file.log, fnd_message.get);

769: IF l_oss_sex_val IS NULL THEN
770: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
771: fnd_message.set_token('CODE', new_ivstarn_rec.sex);
772: fnd_message.set_token('TYPE', 'SEX');
773: fnd_file.put_line(fnd_file.log, fnd_message.get);
774: g_error_code := '1054';
775: END IF;
776:
777: END IF;

Line 812: fnd_message.set_name('IGS','IGS_UC_INVALID_TITLE');

808:
809: IF cur_chk_adjunct%NOTFOUND THEN
810: -- log appropriate message and pass UCAS Title as NULL to OSS Pre name adjunct field.
811: -- The record should get processed with TITLE as NULL.
812: fnd_message.set_name('IGS','IGS_UC_INVALID_TITLE');
813: fnd_message.set_token('UCAS_TITLE', new_ivstarn_rec.title);
814: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
815: fnd_file.put_line(fnd_file.log, fnd_message.get);
816: new_ivstarn_rec.title := NULL;

Line 813: fnd_message.set_token('UCAS_TITLE', new_ivstarn_rec.title);

809: IF cur_chk_adjunct%NOTFOUND THEN
810: -- log appropriate message and pass UCAS Title as NULL to OSS Pre name adjunct field.
811: -- The record should get processed with TITLE as NULL.
812: fnd_message.set_name('IGS','IGS_UC_INVALID_TITLE');
813: fnd_message.set_token('UCAS_TITLE', new_ivstarn_rec.title);
814: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
815: fnd_file.put_line(fnd_file.log, fnd_message.get);
816: new_ivstarn_rec.title := NULL;
817:

Line 814: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));

810: -- log appropriate message and pass UCAS Title as NULL to OSS Pre name adjunct field.
811: -- The record should get processed with TITLE as NULL.
812: fnd_message.set_name('IGS','IGS_UC_INVALID_TITLE');
813: fnd_message.set_token('UCAS_TITLE', new_ivstarn_rec.title);
814: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
815: fnd_file.put_line(fnd_file.log, fnd_message.get);
816: new_ivstarn_rec.title := NULL;
817:
818: ELSE -- since found with '.', append it to Title.

Line 815: fnd_file.put_line(fnd_file.log, fnd_message.get);

811: -- The record should get processed with TITLE as NULL.
812: fnd_message.set_name('IGS','IGS_UC_INVALID_TITLE');
813: fnd_message.set_token('UCAS_TITLE', new_ivstarn_rec.title);
814: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
815: fnd_file.put_line(fnd_file.log, fnd_message.get);
816: new_ivstarn_rec.title := NULL;
817:
818: ELSE -- since found with '.', append it to Title.
819: new_ivstarn_rec.title := new_ivstarn_rec.title || '.';

Line 840: fnd_message.set_name('IGS','IGS_UC_PROC_UCAS_APP');

836:
837: IF g_error_code IS NULL THEN
838:
839: -- log appropriate message
840: fnd_message.set_name('IGS','IGS_UC_PROC_UCAS_APP');
841: fnd_file.put_line(fnd_file.log, fnd_message.get);
842:
843: -- check whether the Application rec already exists in UCAS Applicants table.
844: OPEN old_appl_cur(new_ivstarn_rec.appno);

Line 841: fnd_file.put_line(fnd_file.log, fnd_message.get);

837: IF g_error_code IS NULL THEN
838:
839: -- log appropriate message
840: fnd_message.set_name('IGS','IGS_UC_PROC_UCAS_APP');
841: fnd_file.put_line(fnd_file.log, fnd_message.get);
842:
843: -- check whether the Application rec already exists in UCAS Applicants table.
844: OPEN old_appl_cur(new_ivstarn_rec.appno);
845: FETCH old_appl_cur INTO appl_rec;

Line 983: fnd_message.set_name('IGS','IGS_UC_PROC_UCAS_NAMES');

979: ----------------------------------------------------------------------------------------
980: IF g_error_code IS NULL THEN
981:
982: -- log appropriate message
983: fnd_message.set_name('IGS','IGS_UC_PROC_UCAS_NAMES');
984: fnd_file.put_line(fnd_file.log, fnd_message.get);
985:
986:
987: -- check whether the Application rec already exists in UCAS NAMES table.

Line 984: fnd_file.put_line(fnd_file.log, fnd_message.get);

980: IF g_error_code IS NULL THEN
981:
982: -- log appropriate message
983: fnd_message.set_name('IGS','IGS_UC_PROC_UCAS_NAMES');
984: fnd_file.put_line(fnd_file.log, fnd_message.get);
985:
986:
987: -- check whether the Application rec already exists in UCAS NAMES table.
988: OPEN old_starn_cur(new_ivstarn_rec.appno);

Line 1076: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_BATCH_ID');

1072: FETCH get_batch_id_cur INTO l_adm_batch_id;
1073: CLOSE get_batch_id_cur ;
1074:
1075: -- log appropriate message
1076: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_BATCH_ID');
1077: fnd_message.set_token('BATCHID', TO_CHAR(l_adm_batch_id));
1078: fnd_file.put_line(fnd_file.log, fnd_message.get);
1079:
1080: -- Populate a batch record into Adm Batch table

Line 1077: fnd_message.set_token('BATCHID', TO_CHAR(l_adm_batch_id));

1073: CLOSE get_batch_id_cur ;
1074:
1075: -- log appropriate message
1076: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_BATCH_ID');
1077: fnd_message.set_token('BATCHID', TO_CHAR(l_adm_batch_id));
1078: fnd_file.put_line(fnd_file.log, fnd_message.get);
1079:
1080: -- Populate a batch record into Adm Batch table
1081: INSERT INTO igs_ad_imp_batch_det ( batch_id,

Line 1078: fnd_file.put_line(fnd_file.log, fnd_message.get);

1074:
1075: -- log appropriate message
1076: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_BATCH_ID');
1077: fnd_message.set_token('BATCHID', TO_CHAR(l_adm_batch_id));
1078: fnd_file.put_line(fnd_file.log, fnd_message.get);
1079:
1080: -- Populate a batch record into Adm Batch table
1081: INSERT INTO igs_ad_imp_batch_det ( batch_id,
1082: batch_desc,

Line 1093: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),

1089: program_application_id,
1090: program_update_date,
1091: program_id)
1092: VALUES ( l_adm_batch_id,
1093: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1094: fnd_global.user_id,
1095: SYSDATE,
1096: fnd_global.user_id,
1097: SYSDATE,

Line 1116: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ADM');

1112:
1113: -- Populating person details into Adm Interface table
1114: IF g_error_code IS NULL THEN
1115: BEGIN
1116: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ADM');
1117: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
1118: fnd_file.put_line(fnd_file.log, fnd_message.get);
1119:
1120: -- get the IGS_AD_INTERFACE ID.

Line 1117: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));

1113: -- Populating person details into Adm Interface table
1114: IF g_error_code IS NULL THEN
1115: BEGIN
1116: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ADM');
1117: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
1118: fnd_file.put_line(fnd_file.log, fnd_message.get);
1119:
1120: -- get the IGS_AD_INTERFACE ID.
1121: OPEN get_interface_id;

Line 1118: fnd_file.put_line(fnd_file.log, fnd_message.get);

1114: IF g_error_code IS NULL THEN
1115: BEGIN
1116: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ADM');
1117: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
1118: fnd_file.put_line(fnd_file.log, fnd_message.get);
1119:
1120: -- get the IGS_AD_INTERFACE ID.
1121: OPEN get_interface_id;
1122: FETCH get_interface_id INTO l_interface_id;

Line 1167: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_INT_ID');

1163: l_last_update_login
1164: );
1165:
1166: -- log appropriate message
1167: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_INT_ID');
1168: fnd_message.set_token('INT_ID', TO_CHAR(l_interface_id));
1169: fnd_file.put_line(fnd_file.log, fnd_message.get);
1170:
1171:

Line 1168: fnd_message.set_token('INT_ID', TO_CHAR(l_interface_id));

1164: );
1165:
1166: -- log appropriate message
1167: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_INT_ID');
1168: fnd_message.set_token('INT_ID', TO_CHAR(l_interface_id));
1169: fnd_file.put_line(fnd_file.log, fnd_message.get);
1170:
1171:
1172: EXCEPTION

Line 1169: fnd_file.put_line(fnd_file.log, fnd_message.get);

1165:
1166: -- log appropriate message
1167: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_INT_ID');
1168: fnd_message.set_token('INT_ID', TO_CHAR(l_interface_id));
1169: fnd_file.put_line(fnd_file.log, fnd_message.get);
1170:
1171:
1172: EXCEPTION
1173: WHEN OTHERS THEN

Line 1187: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ALT_PRSN');

1183:
1184: -- Processing for Populating Alternate Person ID table.
1185: IF g_error_code IS NULL THEN
1186:
1187: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ALT_PRSN');
1188: fnd_file.put_line(fnd_file.log, fnd_message.get);
1189:
1190: --Derive the Alternate Person ID Type based on the system to which the Application belongs.
1191: IF l_system_code = 'U' THEN

Line 1188: fnd_file.put_line(fnd_file.log, fnd_message.get);

1184: -- Processing for Populating Alternate Person ID table.
1185: IF g_error_code IS NULL THEN
1186:
1187: fnd_message.set_name('IGS','IGS_UC_APP_REC_INTO_ALT_PRSN');
1188: fnd_file.put_line(fnd_file.log, fnd_message.get);
1189:
1190: --Derive the Alternate Person ID Type based on the system to which the Application belongs.
1191: IF l_system_code = 'U' THEN
1192: l_alt_pers_id_type := 'UCASID';

Line 1246: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_API_INT_ID');

1242: ,l_last_update_login
1243: );
1244:
1245: -- log appropriate message
1246: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_API_INT_ID');
1247: fnd_message.set_token('INT_ID', TO_CHAR(l_alt_pers_seq_id));
1248: fnd_file.put_line(fnd_file.log, fnd_message.get);
1249:
1250:

Line 1247: fnd_message.set_token('INT_ID', TO_CHAR(l_alt_pers_seq_id));

1243: );
1244:
1245: -- log appropriate message
1246: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_API_INT_ID');
1247: fnd_message.set_token('INT_ID', TO_CHAR(l_alt_pers_seq_id));
1248: fnd_file.put_line(fnd_file.log, fnd_message.get);
1249:
1250:
1251: EXCEPTION

Line 1248: fnd_file.put_line(fnd_file.log, fnd_message.get);

1244:
1245: -- log appropriate message
1246: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_API_INT_ID');
1247: fnd_message.set_token('INT_ID', TO_CHAR(l_alt_pers_seq_id));
1248: fnd_file.put_line(fnd_file.log, fnd_message.get);
1249:
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN

Line 1314: fnd_message.set_name('IGS','IGS_UC_REC_FAIL_PROC');

1310: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1311: -- while processing the record.
1312: IF g_error_code IS NOT NULL THEN
1313:
1314: fnd_message.set_name('IGS','IGS_UC_REC_FAIL_PROC');
1315: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
1316: fnd_file.put_line(fnd_file.log, fnd_message.get);
1317:
1318:

Line 1315: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));

1311: -- while processing the record.
1312: IF g_error_code IS NOT NULL THEN
1313:
1314: fnd_message.set_name('IGS','IGS_UC_REC_FAIL_PROC');
1315: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
1316: fnd_file.put_line(fnd_file.log, fnd_message.get);
1317:
1318:
1319: -- rollback the insert/updates made for this record

Line 1316: fnd_file.put_line(fnd_file.log, fnd_message.get);

1312: IF g_error_code IS NOT NULL THEN
1313:
1314: fnd_message.set_name('IGS','IGS_UC_REC_FAIL_PROC');
1315: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarn_rec.appno));
1316: fnd_file.put_line(fnd_file.log, fnd_message.get);
1317:
1318:
1319: -- rollback the insert/updates made for this record
1320: ROLLBACK TO ivstarn_rec_savepoint;

Line 1352: fnd_message.set_name('IGS','IGS_UC_RECS_INTO_AD_INT');

1348:
1349: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1350: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1351: fnd_file.put_line(fnd_file.log, '==========================================================================');
1352: fnd_message.set_name('IGS','IGS_UC_RECS_INTO_AD_INT');
1353: fnd_message.set_token('RECCNT', TO_CHAR(l_recs_inserted));
1354: fnd_file.put_line(fnd_file.log, fnd_message.get);
1355: fnd_file.put_line(fnd_file.log, '==========================================================================');
1356: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line

Line 1353: fnd_message.set_token('RECCNT', TO_CHAR(l_recs_inserted));

1349: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1350: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1351: fnd_file.put_line(fnd_file.log, '==========================================================================');
1352: fnd_message.set_name('IGS','IGS_UC_RECS_INTO_AD_INT');
1353: fnd_message.set_token('RECCNT', TO_CHAR(l_recs_inserted));
1354: fnd_file.put_line(fnd_file.log, fnd_message.get);
1355: fnd_file.put_line(fnd_file.log, '==========================================================================');
1356: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1357: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line

Line 1354: fnd_file.put_line(fnd_file.log, fnd_message.get);

1350: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1351: fnd_file.put_line(fnd_file.log, '==========================================================================');
1352: fnd_message.set_name('IGS','IGS_UC_RECS_INTO_AD_INT');
1353: fnd_message.set_token('RECCNT', TO_CHAR(l_recs_inserted));
1354: fnd_file.put_line(fnd_file.log, fnd_message.get);
1355: fnd_file.put_line(fnd_file.log, '==========================================================================');
1356: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1357: fnd_file.put_line(fnd_file.log, ''); -- to get a blank line
1358:

Line 1387: fnd_message.set_name('IGS','IGS_UC_VW_PROC_ERROR');

1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: ROLLBACK;
1387: fnd_message.set_name('IGS','IGS_UC_VW_PROC_ERROR');
1388: fnd_message.set_token('VIEW_NAME', 'IVSTARN'||' - '||SQLERRM);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END process_ivstarn;
1391:

Line 1388: fnd_message.set_token('VIEW_NAME', 'IVSTARN'||' - '||SQLERRM);

1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: ROLLBACK;
1387: fnd_message.set_name('IGS','IGS_UC_VW_PROC_ERROR');
1388: fnd_message.set_token('VIEW_NAME', 'IVSTARN'||' - '||SQLERRM);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END process_ivstarn;
1391:
1392:

Line 1389: fnd_file.put_line(fnd_file.log, fnd_message.get);

1385: WHEN OTHERS THEN
1386: ROLLBACK;
1387: fnd_message.set_name('IGS','IGS_UC_VW_PROC_ERROR');
1388: fnd_message.set_token('VIEW_NAME', 'IVSTARN'||' - '||SQLERRM);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END process_ivstarn;
1391:
1392:
1393:

Line 1445: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1441: g_error_rec_cnt := 0;
1442: g_error_code := NULL;
1443: l_valid := NULL;
1444:
1445: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1446: fnd_message.set_token('VIEW', 'IVSTARA ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1447: fnd_file.put_line(fnd_file.log, fnd_message.get);
1448:
1449: -- Get all the reocords from interface table with status = 'N'

Line 1446: fnd_message.set_token('VIEW', 'IVSTARA ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1442: g_error_code := NULL;
1443: l_valid := NULL;
1444:
1445: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1446: fnd_message.set_token('VIEW', 'IVSTARA ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1447: fnd_file.put_line(fnd_file.log, fnd_message.get);
1448:
1449: -- Get all the reocords from interface table with status = 'N'
1450: FOR new_ivstara_rec IN new_ivstara_cur

Line 1447: fnd_file.put_line(fnd_file.log, fnd_message.get);

1443: l_valid := NULL;
1444:
1445: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1446: fnd_message.set_token('VIEW', 'IVSTARA ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1447: fnd_file.put_line(fnd_file.log, fnd_message.get);
1448:
1449: -- Get all the reocords from interface table with status = 'N'
1450: FOR new_ivstara_rec IN new_ivstara_cur
1451: LOOP

Line 1460: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

1456: old_stara_rec := NULL;
1457: app_rec := NULL;
1458:
1459: -- log Application processing message.
1460: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
1461: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstara_rec.appno));
1462: fnd_file.put_line(fnd_file.log, fnd_message.get);
1463:
1464:

Line 1461: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstara_rec.appno));

1457: app_rec := NULL;
1458:
1459: -- log Application processing message.
1460: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
1461: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstara_rec.appno));
1462: fnd_file.put_line(fnd_file.log, fnd_message.get);
1463:
1464:
1465: -- mandatory field validations

Line 1462: fnd_file.put_line(fnd_file.log, fnd_message.get);

1458:
1459: -- log Application processing message.
1460: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
1461: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstara_rec.appno));
1462: fnd_file.put_line(fnd_file.log, fnd_message.get);
1463:
1464:
1465: -- mandatory field validations
1466: IF new_ivstara_rec.appno IS NULL THEN

Line 1779: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1775:
1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: ROLLBACK;
1779: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1780: fnd_message.set_token('VIEW', 'IVSTARA'||' - '||SQLERRM);
1781: fnd_file.put_line(fnd_file.log, fnd_message.get);
1782: END process_ivstara;
1783:

Line 1780: fnd_message.set_token('VIEW', 'IVSTARA'||' - '||SQLERRM);

1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: ROLLBACK;
1779: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1780: fnd_message.set_token('VIEW', 'IVSTARA'||' - '||SQLERRM);
1781: fnd_file.put_line(fnd_file.log, fnd_message.get);
1782: END process_ivstara;
1783:
1784:

Line 1781: fnd_file.put_line(fnd_file.log, fnd_message.get);

1777: WHEN OTHERS THEN
1778: ROLLBACK;
1779: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1780: fnd_message.set_token('VIEW', 'IVSTARA'||' - '||SQLERRM);
1781: fnd_file.put_line(fnd_file.log, fnd_message.get);
1782: END process_ivstara;
1783:
1784:
1785:

Line 1880: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1876: g_success_rec_cnt := 0;
1877: g_error_rec_cnt := 0;
1878: g_error_code := NULL;
1879:
1880: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1881: fnd_message.set_token('VIEW', 'IVSTARK ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1882: fnd_file.put_line(fnd_file.log, fnd_message.get);
1883:
1884: -- Get all the reocords from interface table with status = 'N'

Line 1881: fnd_message.set_token('VIEW', 'IVSTARK ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1877: g_error_rec_cnt := 0;
1878: g_error_code := NULL;
1879:
1880: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1881: fnd_message.set_token('VIEW', 'IVSTARK ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1882: fnd_file.put_line(fnd_file.log, fnd_message.get);
1883:
1884: -- Get all the reocords from interface table with status = 'N'
1885: FOR new_ivstark_rec IN new_ivstark_cur

Line 1882: fnd_file.put_line(fnd_file.log, fnd_message.get);

1878: g_error_code := NULL;
1879:
1880: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1881: fnd_message.set_token('VIEW', 'IVSTARK ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1882: fnd_file.put_line(fnd_file.log, fnd_message.get);
1883:
1884: -- Get all the reocords from interface table with status = 'N'
1885: FOR new_ivstark_rec IN new_ivstark_cur
1886: LOOP

Line 1895: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

1891: old_stark_rec := NULL;
1892: l_valid := NULL;
1893:
1894: -- log Application processing message.
1895: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
1896: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstark_rec.appno));
1897: fnd_file.put_line(fnd_file.log, fnd_message.get);
1898:
1899: -- Mandatory field validations.

Line 1896: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstark_rec.appno));

1892: l_valid := NULL;
1893:
1894: -- log Application processing message.
1895: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
1896: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstark_rec.appno));
1897: fnd_file.put_line(fnd_file.log, fnd_message.get);
1898:
1899: -- Mandatory field validations.
1900: IF new_ivstark_rec.appno IS NULL THEN

Line 1897: fnd_file.put_line(fnd_file.log, fnd_message.get);

1893:
1894: -- log Application processing message.
1895: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
1896: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstark_rec.appno));
1897: fnd_file.put_line(fnd_file.log, fnd_message.get);
1898:
1899: -- Mandatory field validations.
1900: IF new_ivstark_rec.appno IS NULL THEN
1901: g_error_code := '1037';

Line 2493: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

2489:
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: ROLLBACK;
2493: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2494: fnd_message.set_token('VIEW', 'IVSTARK'||' - '||SQLERRM);
2495: fnd_file.put_line(fnd_file.log, fnd_message.get);
2496: END process_ivstark;
2497:

Line 2494: fnd_message.set_token('VIEW', 'IVSTARK'||' - '||SQLERRM);

2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: ROLLBACK;
2493: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2494: fnd_message.set_token('VIEW', 'IVSTARK'||' - '||SQLERRM);
2495: fnd_file.put_line(fnd_file.log, fnd_message.get);
2496: END process_ivstark;
2497:
2498:

Line 2495: fnd_file.put_line(fnd_file.log, fnd_message.get);

2491: WHEN OTHERS THEN
2492: ROLLBACK;
2493: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2494: fnd_message.set_token('VIEW', 'IVSTARK'||' - '||SQLERRM);
2495: fnd_file.put_line(fnd_file.log, fnd_message.get);
2496: END process_ivstark;
2497:
2498:
2499:

Line 2608: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

2604: g_success_rec_cnt := 0;
2605: g_error_rec_cnt := 0;
2606: g_error_code := NULL;
2607:
2608: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
2609: fnd_message.set_token('VIEW', 'IVSTARC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2610: fnd_file.put_line(fnd_file.log, fnd_message.get);
2611:
2612: -- Get all the reocords from interface table with status = 'N'

Line 2609: fnd_message.set_token('VIEW', 'IVSTARC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2605: g_error_rec_cnt := 0;
2606: g_error_code := NULL;
2607:
2608: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
2609: fnd_message.set_token('VIEW', 'IVSTARC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2610: fnd_file.put_line(fnd_file.log, fnd_message.get);
2611:
2612: -- Get all the reocords from interface table with status = 'N'
2613: FOR new_ivstarc_rec IN new_ivstarc_cur

Line 2610: fnd_file.put_line(fnd_file.log, fnd_message.get);

2606: g_error_code := NULL;
2607:
2608: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
2609: fnd_message.set_token('VIEW', 'IVSTARC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2610: fnd_file.put_line(fnd_file.log, fnd_message.get);
2611:
2612: -- Get all the reocords from interface table with status = 'N'
2613: FOR new_ivstarc_rec IN new_ivstarc_cur
2614: LOOP

Line 2629: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');

2625: curr_inst_rec := NULL;
2626: old_starc_9_rec := NULL;
2627:
2628: -- log Application Choice processing message.
2629: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
2630: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarc_rec.appno));
2631: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarc_rec.choiceno));
2632: fnd_file.put_line(fnd_file.log, fnd_message.get);
2633:

Line 2630: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarc_rec.appno));

2626: old_starc_9_rec := NULL;
2627:
2628: -- log Application Choice processing message.
2629: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
2630: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarc_rec.appno));
2631: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarc_rec.choiceno));
2632: fnd_file.put_line(fnd_file.log, fnd_message.get);
2633:
2634:

Line 2631: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarc_rec.choiceno));

2627:
2628: -- log Application Choice processing message.
2629: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
2630: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarc_rec.appno));
2631: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarc_rec.choiceno));
2632: fnd_file.put_line(fnd_file.log, fnd_message.get);
2633:
2634:
2635: -- no mandatory field validations as this is an update

Line 2632: fnd_file.put_line(fnd_file.log, fnd_message.get);

2628: -- log Application Choice processing message.
2629: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
2630: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarc_rec.appno));
2631: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarc_rec.choiceno));
2632: fnd_file.put_line(fnd_file.log, fnd_message.get);
2633:
2634:
2635: -- no mandatory field validations as this is an update
2636: IF new_ivstarc_rec.appno IS NULL OR new_ivstarc_rec.choiceno IS NULL OR

Line 3233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

3229:
3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: ROLLBACK;
3233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
3234: fnd_message.set_token('VIEW', 'IVSTARC'||' - '||SQLERRM);
3235: fnd_file.put_line(fnd_file.log, fnd_message.get);
3236: END process_ivstarc;
3237:

Line 3234: fnd_message.set_token('VIEW', 'IVSTARC'||' - '||SQLERRM);

3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: ROLLBACK;
3233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
3234: fnd_message.set_token('VIEW', 'IVSTARC'||' - '||SQLERRM);
3235: fnd_file.put_line(fnd_file.log, fnd_message.get);
3236: END process_ivstarc;
3237:
3238:

Line 3235: fnd_file.put_line(fnd_file.log, fnd_message.get);

3231: WHEN OTHERS THEN
3232: ROLLBACK;
3233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
3234: fnd_message.set_token('VIEW', 'IVSTARC'||' - '||SQLERRM);
3235: fnd_file.put_line(fnd_file.log, fnd_message.get);
3236: END process_ivstarc;
3237:
3238:
3239:

Line 3341: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

3337: g_success_rec_cnt := 0;
3338: g_error_rec_cnt := 0;
3339: g_error_code := NULL;
3340:
3341: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
3342: fnd_message.set_token('VIEW', 'IVSTARG ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
3343: fnd_file.put_line(fnd_file.log, fnd_message.get);
3344:
3345: -- Get all the reocords from interface table with status = 'N'

Line 3342: fnd_message.set_token('VIEW', 'IVSTARG ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

3338: g_error_rec_cnt := 0;
3339: g_error_code := NULL;
3340:
3341: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
3342: fnd_message.set_token('VIEW', 'IVSTARG ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
3343: fnd_file.put_line(fnd_file.log, fnd_message.get);
3344:
3345: -- Get all the reocords from interface table with status = 'N'
3346: FOR new_ivstarg_rec IN new_ivstarg_cur

Line 3343: fnd_file.put_line(fnd_file.log, fnd_message.get);

3339: g_error_code := NULL;
3340:
3341: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
3342: fnd_message.set_token('VIEW', 'IVSTARG ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
3343: fnd_file.put_line(fnd_file.log, fnd_message.get);
3344:
3345: -- Get all the reocords from interface table with status = 'N'
3346: FOR new_ivstarg_rec IN new_ivstarg_cur
3347: LOOP

Line 3365: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');

3361: -- Issue a savepoint
3362: SAVEPOINT process_ivstarg;
3363:
3364: -- log Application Choice processing message.
3365: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
3366: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarg_rec.appno));
3367: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarg_rec.roundno));
3368: fnd_file.put_line(fnd_file.log, fnd_message.get);
3369:

Line 3366: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarg_rec.appno));

3362: SAVEPOINT process_ivstarg;
3363:
3364: -- log Application Choice processing message.
3365: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
3366: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarg_rec.appno));
3367: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarg_rec.roundno));
3368: fnd_file.put_line(fnd_file.log, fnd_message.get);
3369:
3370:

Line 3367: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarg_rec.roundno));

3363:
3364: -- log Application Choice processing message.
3365: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
3366: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarg_rec.appno));
3367: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarg_rec.roundno));
3368: fnd_file.put_line(fnd_file.log, fnd_message.get);
3369:
3370:
3371: -- no mandatory field validations as this is an update

Line 3368: fnd_file.put_line(fnd_file.log, fnd_message.get);

3364: -- log Application Choice processing message.
3365: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
3366: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarg_rec.appno));
3367: fnd_message.set_token('CHOICE',TO_CHAR(new_ivstarg_rec.roundno));
3368: fnd_file.put_line(fnd_file.log, fnd_message.get);
3369:
3370:
3371: -- no mandatory field validations as this is an update
3372: IF new_ivstarg_rec.appno IS NULL OR

Line 4040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

4036: EXCEPTION
4037: WHEN OTHERS THEN
4038: ROLLBACK TO process_ivstarg;
4039: COMMIT;
4040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4041: fnd_message.set_token('VIEW', 'IVSTARG'||' - '||SQLERRM);
4042: fnd_file.put_line(fnd_file.log, fnd_message.get);
4043: END process_ivstarg;
4044:

Line 4041: fnd_message.set_token('VIEW', 'IVSTARG'||' - '||SQLERRM);

4037: WHEN OTHERS THEN
4038: ROLLBACK TO process_ivstarg;
4039: COMMIT;
4040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4041: fnd_message.set_token('VIEW', 'IVSTARG'||' - '||SQLERRM);
4042: fnd_file.put_line(fnd_file.log, fnd_message.get);
4043: END process_ivstarg;
4044:
4045:

Line 4042: fnd_file.put_line(fnd_file.log, fnd_message.get);

4038: ROLLBACK TO process_ivstarg;
4039: COMMIT;
4040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4041: fnd_message.set_token('VIEW', 'IVSTARG'||' - '||SQLERRM);
4042: fnd_file.put_line(fnd_file.log, fnd_message.get);
4043: END process_ivstarg;
4044:
4045:
4046:

Line 4079: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

4075: g_success_rec_cnt := 0;
4076: g_error_rec_cnt := 0;
4077: g_error_code := NULL;
4078:
4079: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4080: fnd_message.set_token('VIEW', 'IVSTART ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4081: fnd_file.put_line(fnd_file.log, fnd_message.get);
4082:
4083: -- Get all the reocords from interface table with status = 'N'

Line 4080: fnd_message.set_token('VIEW', 'IVSTART ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

4076: g_error_rec_cnt := 0;
4077: g_error_code := NULL;
4078:
4079: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4080: fnd_message.set_token('VIEW', 'IVSTART ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4081: fnd_file.put_line(fnd_file.log, fnd_message.get);
4082:
4083: -- Get all the reocords from interface table with status = 'N'
4084: FOR new_ivstart_rec IN new_ivstart_cur

Line 4081: fnd_file.put_line(fnd_file.log, fnd_message.get);

4077: g_error_code := NULL;
4078:
4079: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4080: fnd_message.set_token('VIEW', 'IVSTART ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4081: fnd_file.put_line(fnd_file.log, fnd_message.get);
4082:
4083: -- Get all the reocords from interface table with status = 'N'
4084: FOR new_ivstart_rec IN new_ivstart_cur
4085: LOOP

Line 4093: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

4089: old_start_rec := NULL;
4090:
4091:
4092: -- log Application processing message.
4093: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4094: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstart_rec.appno));
4095: fnd_file.put_line(fnd_file.log, fnd_message.get);
4096:
4097:

Line 4094: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstart_rec.appno));

4090:
4091:
4092: -- log Application processing message.
4093: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4094: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstart_rec.appno));
4095: fnd_file.put_line(fnd_file.log, fnd_message.get);
4096:
4097:
4098: -- mandatory field validations

Line 4095: fnd_file.put_line(fnd_file.log, fnd_message.get);

4091:
4092: -- log Application processing message.
4093: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4094: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstart_rec.appno));
4095: fnd_file.put_line(fnd_file.log, fnd_message.get);
4096:
4097:
4098: -- mandatory field validations
4099: IF new_ivstart_rec.appno IS NULL THEN

Line 4298: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

4294:
4295: EXCEPTION
4296: WHEN OTHERS THEN
4297: ROLLBACK;
4298: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4299: fnd_message.set_token('VIEW', 'IVSTART'||' - '||SQLERRM);
4300: fnd_file.put_line(fnd_file.log, fnd_message.get);
4301: END process_ivstart;
4302:

Line 4299: fnd_message.set_token('VIEW', 'IVSTART'||' - '||SQLERRM);

4295: EXCEPTION
4296: WHEN OTHERS THEN
4297: ROLLBACK;
4298: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4299: fnd_message.set_token('VIEW', 'IVSTART'||' - '||SQLERRM);
4300: fnd_file.put_line(fnd_file.log, fnd_message.get);
4301: END process_ivstart;
4302:
4303:

Line 4300: fnd_file.put_line(fnd_file.log, fnd_message.get);

4296: WHEN OTHERS THEN
4297: ROLLBACK;
4298: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4299: fnd_message.set_token('VIEW', 'IVSTART'||' - '||SQLERRM);
4300: fnd_file.put_line(fnd_file.log, fnd_message.get);
4301: END process_ivstart;
4302:
4303:
4304:

Line 4338: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

4334: g_success_rec_cnt := 0;
4335: g_error_rec_cnt := 0;
4336: g_error_code := NULL;
4337:
4338: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4339: fnd_message.set_token('VIEW', 'IVQUALIFICATION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4340: fnd_file.put_line(fnd_file.log, fnd_message.get);
4341:
4342: -- Get all the reocords from interface table with status = 'N'

Line 4339: fnd_message.set_token('VIEW', 'IVQUALIFICATION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

4335: g_error_rec_cnt := 0;
4336: g_error_code := NULL;
4337:
4338: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4339: fnd_message.set_token('VIEW', 'IVQUALIFICATION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4340: fnd_file.put_line(fnd_file.log, fnd_message.get);
4341:
4342: -- Get all the reocords from interface table with status = 'N'
4343: FOR new_ivqual_rec IN new_ivqual_cur

Line 4340: fnd_file.put_line(fnd_file.log, fnd_message.get);

4336: g_error_code := NULL;
4337:
4338: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4339: fnd_message.set_token('VIEW', 'IVQUALIFICATION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4340: fnd_file.put_line(fnd_file.log, fnd_message.get);
4341:
4342: -- Get all the reocords from interface table with status = 'N'
4343: FOR new_ivqual_rec IN new_ivqual_cur
4344: LOOP

Line 4353: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

4349: old_qual_rec := NULL;
4350:
4351:
4352: -- log Application processing message.
4353: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4354: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivqual_rec.appno));
4355: fnd_file.put_line(fnd_file.log, fnd_message.get);
4356:
4357:

Line 4354: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivqual_rec.appno));

4350:
4351:
4352: -- log Application processing message.
4353: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4354: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivqual_rec.appno));
4355: fnd_file.put_line(fnd_file.log, fnd_message.get);
4356:
4357:
4358: -- mandatory field validations as this is an update

Line 4355: fnd_file.put_line(fnd_file.log, fnd_message.get);

4351:
4352: -- log Application processing message.
4353: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4354: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivqual_rec.appno));
4355: fnd_file.put_line(fnd_file.log, fnd_message.get);
4356:
4357:
4358: -- mandatory field validations as this is an update
4359: IF new_ivqual_rec.appno IS NULL THEN

Line 4556: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

4552:
4553: EXCEPTION
4554: WHEN OTHERS THEN
4555: ROLLBACK;
4556: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4557: fnd_message.set_token('VIEW', 'IVQUALIFICATION'||' - '||SQLERRM);
4558: fnd_file.put_line(fnd_file.log, fnd_message.get);
4559: END process_ivqualification;
4560:

Line 4557: fnd_message.set_token('VIEW', 'IVQUALIFICATION'||' - '||SQLERRM);

4553: EXCEPTION
4554: WHEN OTHERS THEN
4555: ROLLBACK;
4556: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4557: fnd_message.set_token('VIEW', 'IVQUALIFICATION'||' - '||SQLERRM);
4558: fnd_file.put_line(fnd_file.log, fnd_message.get);
4559: END process_ivqualification;
4560:
4561:

Line 4558: fnd_file.put_line(fnd_file.log, fnd_message.get);

4554: WHEN OTHERS THEN
4555: ROLLBACK;
4556: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4557: fnd_message.set_token('VIEW', 'IVQUALIFICATION'||' - '||SQLERRM);
4558: fnd_file.put_line(fnd_file.log, fnd_message.get);
4559: END process_ivqualification;
4560:
4561:
4562:

Line 4599: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

4595: g_success_rec_cnt := 0;
4596: g_error_rec_cnt := 0;
4597: g_error_code := NULL;
4598:
4599: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4600: fnd_message.set_token('VIEW', 'IVSTATEMENT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4601: fnd_file.put_line(fnd_file.log, fnd_message.get);
4602:
4603: -- Get all the reocords from interface table with status = 'N'

Line 4600: fnd_message.set_token('VIEW', 'IVSTATEMENT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

4596: g_error_rec_cnt := 0;
4597: g_error_code := NULL;
4598:
4599: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4600: fnd_message.set_token('VIEW', 'IVSTATEMENT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4601: fnd_file.put_line(fnd_file.log, fnd_message.get);
4602:
4603: -- Get all the reocords from interface table with status = 'N'
4604: FOR new_ivstmt_rec IN new_ivstmnt_cur

Line 4601: fnd_file.put_line(fnd_file.log, fnd_message.get);

4597: g_error_code := NULL;
4598:
4599: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4600: fnd_message.set_token('VIEW', 'IVSTATEMENT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4601: fnd_file.put_line(fnd_file.log, fnd_message.get);
4602:
4603: -- Get all the reocords from interface table with status = 'N'
4604: FOR new_ivstmt_rec IN new_ivstmnt_cur
4605: LOOP

Line 4614: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

4610: g_error_code := NULL;
4611: old_stmt_rec := NULL;
4612:
4613: -- log Application processing message.
4614: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4615: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstmt_rec.appno));
4616: fnd_file.put_line(fnd_file.log, fnd_message.get);
4617:
4618:

Line 4615: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstmt_rec.appno));

4611: old_stmt_rec := NULL;
4612:
4613: -- log Application processing message.
4614: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4615: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstmt_rec.appno));
4616: fnd_file.put_line(fnd_file.log, fnd_message.get);
4617:
4618:
4619: -- mandatory field validations as this is an update

Line 4616: fnd_file.put_line(fnd_file.log, fnd_message.get);

4612:
4613: -- log Application processing message.
4614: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
4615: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstmt_rec.appno));
4616: fnd_file.put_line(fnd_file.log, fnd_message.get);
4617:
4618:
4619: -- mandatory field validations as this is an update
4620: IF new_ivstmt_rec.appno IS NULL THEN

Line 4827: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

4823:
4824: EXCEPTION
4825: WHEN OTHERS THEN
4826: ROLLBACK;
4827: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4828: fnd_message.set_token('VIEW', 'IVSTATEMENT'||' - '||SQLERRM);
4829: fnd_file.put_line(fnd_file.log, fnd_message.get);
4830: END process_ivstatement;
4831:

Line 4828: fnd_message.set_token('VIEW', 'IVSTATEMENT'||' - '||SQLERRM);

4824: EXCEPTION
4825: WHEN OTHERS THEN
4826: ROLLBACK;
4827: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4828: fnd_message.set_token('VIEW', 'IVSTATEMENT'||' - '||SQLERRM);
4829: fnd_file.put_line(fnd_file.log, fnd_message.get);
4830: END process_ivstatement;
4831:
4832:

Line 4829: fnd_file.put_line(fnd_file.log, fnd_message.get);

4825: WHEN OTHERS THEN
4826: ROLLBACK;
4827: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
4828: fnd_message.set_token('VIEW', 'IVSTATEMENT'||' - '||SQLERRM);
4829: fnd_file.put_line(fnd_file.log, fnd_message.get);
4830: END process_ivstatement;
4831:
4832:
4833:

Line 4872: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

4868: g_success_rec_cnt := 0;
4869: g_error_rec_cnt := 0;
4870: g_error_code := NULL;
4871:
4872: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4873: fnd_message.set_token('VIEW', 'IVOFFER ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4874: fnd_file.put_line(fnd_file.log, fnd_message.get);
4875:
4876: -- Get all the reocords from interface table with status = 'N'

Line 4873: fnd_message.set_token('VIEW', 'IVOFFER ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

4869: g_error_rec_cnt := 0;
4870: g_error_code := NULL;
4871:
4872: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4873: fnd_message.set_token('VIEW', 'IVOFFER ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4874: fnd_file.put_line(fnd_file.log, fnd_message.get);
4875:
4876: -- Get all the reocords from interface table with status = 'N'
4877: FOR new_ivoffer_rec IN new_ivoffer_cur

Line 4874: fnd_file.put_line(fnd_file.log, fnd_message.get);

4870: g_error_code := NULL;
4871:
4872: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
4873: fnd_message.set_token('VIEW', 'IVOFFER ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
4874: fnd_file.put_line(fnd_file.log, fnd_message.get);
4875:
4876: -- Get all the reocords from interface table with status = 'N'
4877: FOR new_ivoffer_rec IN new_ivoffer_cur
4878: LOOP

Line 4887: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');

4883: old_offer_rec := NULL;
4884: l_app_choice_id := NULL;
4885:
4886: -- log Application Choice processing message.
4887: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
4888: fnd_message.set_token('APPNO', TO_CHAR(new_ivoffer_rec.appno));
4889: fnd_message.set_token('CHOICE',TO_CHAR(new_ivoffer_rec.choiceno));
4890: fnd_file.put_line(fnd_file.log, fnd_message.get);
4891:

Line 4888: fnd_message.set_token('APPNO', TO_CHAR(new_ivoffer_rec.appno));

4884: l_app_choice_id := NULL;
4885:
4886: -- log Application Choice processing message.
4887: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
4888: fnd_message.set_token('APPNO', TO_CHAR(new_ivoffer_rec.appno));
4889: fnd_message.set_token('CHOICE',TO_CHAR(new_ivoffer_rec.choiceno));
4890: fnd_file.put_line(fnd_file.log, fnd_message.get);
4891:
4892:

Line 4889: fnd_message.set_token('CHOICE',TO_CHAR(new_ivoffer_rec.choiceno));

4885:
4886: -- log Application Choice processing message.
4887: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
4888: fnd_message.set_token('APPNO', TO_CHAR(new_ivoffer_rec.appno));
4889: fnd_message.set_token('CHOICE',TO_CHAR(new_ivoffer_rec.choiceno));
4890: fnd_file.put_line(fnd_file.log, fnd_message.get);
4891:
4892:
4893: -- no mandatory field validations as this is an update

Line 4890: fnd_file.put_line(fnd_file.log, fnd_message.get);

4886: -- log Application Choice processing message.
4887: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
4888: fnd_message.set_token('APPNO', TO_CHAR(new_ivoffer_rec.appno));
4889: fnd_message.set_token('CHOICE',TO_CHAR(new_ivoffer_rec.choiceno));
4890: fnd_file.put_line(fnd_file.log, fnd_message.get);
4891:
4892:
4893: -- no mandatory field validations as this is an update
4894: IF new_ivoffer_rec.appno IS NULL OR new_ivoffer_rec.choiceno IS NULL OR

Line 5051: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

5047:
5048: EXCEPTION
5049: WHEN OTHERS THEN
5050: ROLLBACK;
5051: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5052: fnd_message.set_token('VIEW', 'IVOFFER'||' - '||SQLERRM);
5053: fnd_file.put_line(fnd_file.log, fnd_message.get);
5054: END process_ivoffer;
5055:

Line 5052: fnd_message.set_token('VIEW', 'IVOFFER'||' - '||SQLERRM);

5048: EXCEPTION
5049: WHEN OTHERS THEN
5050: ROLLBACK;
5051: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5052: fnd_message.set_token('VIEW', 'IVOFFER'||' - '||SQLERRM);
5053: fnd_file.put_line(fnd_file.log, fnd_message.get);
5054: END process_ivoffer;
5055:
5056:

Line 5053: fnd_file.put_line(fnd_file.log, fnd_message.get);

5049: WHEN OTHERS THEN
5050: ROLLBACK;
5051: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5052: fnd_message.set_token('VIEW', 'IVOFFER'||' - '||SQLERRM);
5053: fnd_file.put_line(fnd_file.log, fnd_message.get);
5054: END process_ivoffer;
5055:
5056:
5057:

Line 5116: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

5112: g_success_rec_cnt := 0;
5113: g_error_rec_cnt := 0;
5114: g_error_code := NULL;
5115:
5116: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5117: fnd_message.set_token('VIEW', 'IVSTARX ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5118: fnd_file.put_line(fnd_file.log, fnd_message.get);
5119:
5120: -- Get all the reocords from interface table with status = 'N'

Line 5117: fnd_message.set_token('VIEW', 'IVSTARX ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

5113: g_error_rec_cnt := 0;
5114: g_error_code := NULL;
5115:
5116: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5117: fnd_message.set_token('VIEW', 'IVSTARX ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5118: fnd_file.put_line(fnd_file.log, fnd_message.get);
5119:
5120: -- Get all the reocords from interface table with status = 'N'
5121: FOR new_ivstarx_rec IN new_ivstarx_cur

Line 5118: fnd_file.put_line(fnd_file.log, fnd_message.get);

5114: g_error_code := NULL;
5115:
5116: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5117: fnd_message.set_token('VIEW', 'IVSTARX ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5118: fnd_file.put_line(fnd_file.log, fnd_message.get);
5119:
5120: -- Get all the reocords from interface table with status = 'N'
5121: FOR new_ivstarx_rec IN new_ivstarx_cur
5122: LOOP

Line 5131: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

5127: old_starx_rec := NULL;
5128: l_valid := NULL;
5129:
5130: -- log record processing info.
5131: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5132: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarx_rec.appno));
5133: fnd_file.put_line(fnd_file.log, fnd_message.get);
5134:
5135:

Line 5132: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarx_rec.appno));

5128: l_valid := NULL;
5129:
5130: -- log record processing info.
5131: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5132: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarx_rec.appno));
5133: fnd_file.put_line(fnd_file.log, fnd_message.get);
5134:
5135:
5136: -- no mandatory field validations as this is an update

Line 5133: fnd_file.put_line(fnd_file.log, fnd_message.get);

5129:
5130: -- log record processing info.
5131: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5132: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarx_rec.appno));
5133: fnd_file.put_line(fnd_file.log, fnd_message.get);
5134:
5135:
5136: -- no mandatory field validations as this is an update
5137: IF new_ivstarx_rec.appno IS NULL THEN

Line 5360: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

5356:
5357: EXCEPTION
5358: WHEN OTHERS THEN
5359: ROLLBACK;
5360: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5361: fnd_message.set_token('VIEW', 'IVSTARX'||' - '||SQLERRM);
5362: fnd_file.put_line(fnd_file.log, fnd_message.get);
5363: END process_ivstarx;
5364:

Line 5361: fnd_message.set_token('VIEW', 'IVSTARX'||' - '||SQLERRM);

5357: EXCEPTION
5358: WHEN OTHERS THEN
5359: ROLLBACK;
5360: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5361: fnd_message.set_token('VIEW', 'IVSTARX'||' - '||SQLERRM);
5362: fnd_file.put_line(fnd_file.log, fnd_message.get);
5363: END process_ivstarx;
5364:
5365:

Line 5362: fnd_file.put_line(fnd_file.log, fnd_message.get);

5358: WHEN OTHERS THEN
5359: ROLLBACK;
5360: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5361: fnd_message.set_token('VIEW', 'IVSTARX'||' - '||SQLERRM);
5362: fnd_file.put_line(fnd_file.log, fnd_message.get);
5363: END process_ivstarx;
5364:
5365:
5366:

Line 5427: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

5423: g_success_rec_cnt := 0;
5424: g_error_rec_cnt := 0;
5425: g_error_code := NULL;
5426:
5427: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5428: fnd_message.set_token('VIEW', 'IVSTARH ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5429: fnd_file.put_line(fnd_file.log, fnd_message.get);
5430:
5431: -- Get all the reocords from interface table with status = 'N'

Line 5428: fnd_message.set_token('VIEW', 'IVSTARH ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

5424: g_error_rec_cnt := 0;
5425: g_error_code := NULL;
5426:
5427: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5428: fnd_message.set_token('VIEW', 'IVSTARH ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5429: fnd_file.put_line(fnd_file.log, fnd_message.get);
5430:
5431: -- Get all the reocords from interface table with status = 'N'
5432: FOR new_ivstarh_rec IN new_ivstarh_cur

Line 5429: fnd_file.put_line(fnd_file.log, fnd_message.get);

5425: g_error_code := NULL;
5426:
5427: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5428: fnd_message.set_token('VIEW', 'IVSTARH ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5429: fnd_file.put_line(fnd_file.log, fnd_message.get);
5430:
5431: -- Get all the reocords from interface table with status = 'N'
5432: FOR new_ivstarh_rec IN new_ivstarh_cur
5433: LOOP

Line 5442: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

5438: old_starh_rec := NULL;
5439: l_valid := NULL;
5440:
5441: -- log record processing info.
5442: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5443: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarh_rec.appno));
5444: fnd_file.put_line(fnd_file.log, fnd_message.get);
5445:
5446:

Line 5443: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarh_rec.appno));

5439: l_valid := NULL;
5440:
5441: -- log record processing info.
5442: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5443: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarh_rec.appno));
5444: fnd_file.put_line(fnd_file.log, fnd_message.get);
5445:
5446:
5447: -- no mandatory field validations as this is an update

Line 5444: fnd_file.put_line(fnd_file.log, fnd_message.get);

5440:
5441: -- log record processing info.
5442: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5443: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarh_rec.appno));
5444: fnd_file.put_line(fnd_file.log, fnd_message.get);
5445:
5446:
5447: -- no mandatory field validations as this is an update
5448: IF new_ivstarh_rec.appno IS NULL THEN

Line 5673: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

5669:
5670: EXCEPTION
5671: WHEN OTHERS THEN
5672: ROLLBACK;
5673: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5674: fnd_message.set_token('VIEW', 'IVSTARH'||' - '||SQLERRM);
5675: fnd_file.put_line(fnd_file.log, fnd_message.get);
5676: END process_ivstarh;
5677:

Line 5674: fnd_message.set_token('VIEW', 'IVSTARH'||' - '||SQLERRM);

5670: EXCEPTION
5671: WHEN OTHERS THEN
5672: ROLLBACK;
5673: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5674: fnd_message.set_token('VIEW', 'IVSTARH'||' - '||SQLERRM);
5675: fnd_file.put_line(fnd_file.log, fnd_message.get);
5676: END process_ivstarh;
5677:
5678:

Line 5675: fnd_file.put_line(fnd_file.log, fnd_message.get);

5671: WHEN OTHERS THEN
5672: ROLLBACK;
5673: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
5674: fnd_message.set_token('VIEW', 'IVSTARH'||' - '||SQLERRM);
5675: fnd_file.put_line(fnd_file.log, fnd_message.get);
5676: END process_ivstarh;
5677:
5678:
5679:

Line 5802: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

5798: g_success_rec_cnt := 0;
5799: g_error_rec_cnt := 0;
5800: g_error_code := NULL;
5801:
5802: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5803: fnd_message.set_token('VIEW', 'IVSTARZ1 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5804: fnd_file.put_line(fnd_file.log, fnd_message.get);
5805:
5806: -- Get all the reocords from interface table with status = 'N'

Line 5803: fnd_message.set_token('VIEW', 'IVSTARZ1 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

5799: g_error_rec_cnt := 0;
5800: g_error_code := NULL;
5801:
5802: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5803: fnd_message.set_token('VIEW', 'IVSTARZ1 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5804: fnd_file.put_line(fnd_file.log, fnd_message.get);
5805:
5806: -- Get all the reocords from interface table with status = 'N'
5807: FOR new_ivstarz1_rec IN new_ivstarz1_cur

Line 5804: fnd_file.put_line(fnd_file.log, fnd_message.get);

5800: g_error_code := NULL;
5801:
5802: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
5803: fnd_message.set_token('VIEW', 'IVSTARZ1 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
5804: fnd_file.put_line(fnd_file.log, fnd_message.get);
5805:
5806: -- Get all the reocords from interface table with status = 'N'
5807: FOR new_ivstarz1_rec IN new_ivstarz1_cur
5808: LOOP

Line 5820: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

5816: uc_app_choices_rec :=NULL; -- added wrt UCCR008 arvsrini
5817: curr_inst_rec := NULL; -- added wrt UCCR008 arvsrini
5818:
5819: -- log record processing info.
5820: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5821: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarz1_rec.appno));
5822: fnd_file.put_line(fnd_file.log, fnd_message.get);
5823:
5824:

Line 5821: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarz1_rec.appno));

5817: curr_inst_rec := NULL; -- added wrt UCCR008 arvsrini
5818:
5819: -- log record processing info.
5820: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5821: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarz1_rec.appno));
5822: fnd_file.put_line(fnd_file.log, fnd_message.get);
5823:
5824:
5825: -- mandatory field validations

Line 5822: fnd_file.put_line(fnd_file.log, fnd_message.get);

5818:
5819: -- log record processing info.
5820: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
5821: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarz1_rec.appno));
5822: fnd_file.put_line(fnd_file.log, fnd_message.get);
5823:
5824:
5825: -- mandatory field validations
5826: IF new_ivstarz1_rec.appno IS NULL THEN

Line 6239: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

6235:
6236: EXCEPTION
6237: WHEN OTHERS THEN
6238: ROLLBACK;
6239: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6240: fnd_message.set_token('VIEW', 'IVSTARZ1'||' - '||SQLERRM);
6241: fnd_file.put_line(fnd_file.log, fnd_message.get);
6242: END process_ivstarz1;
6243:

Line 6240: fnd_message.set_token('VIEW', 'IVSTARZ1'||' - '||SQLERRM);

6236: EXCEPTION
6237: WHEN OTHERS THEN
6238: ROLLBACK;
6239: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6240: fnd_message.set_token('VIEW', 'IVSTARZ1'||' - '||SQLERRM);
6241: fnd_file.put_line(fnd_file.log, fnd_message.get);
6242: END process_ivstarz1;
6243:
6244:

Line 6241: fnd_file.put_line(fnd_file.log, fnd_message.get);

6237: WHEN OTHERS THEN
6238: ROLLBACK;
6239: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6240: fnd_message.set_token('VIEW', 'IVSTARZ1'||' - '||SQLERRM);
6241: fnd_file.put_line(fnd_file.log, fnd_message.get);
6242: END process_ivstarz1;
6243:
6244:
6245:

Line 6344: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

6340: g_success_rec_cnt := 0;
6341: g_error_rec_cnt := 0;
6342: g_error_code := NULL;
6343:
6344: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6345: fnd_message.set_token('VIEW', 'IVSTARZ2 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6346: fnd_file.put_line(fnd_file.log, fnd_message.get);
6347:
6348: -- Get all the reocords from interface table with status = 'N'

Line 6345: fnd_message.set_token('VIEW', 'IVSTARZ2 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

6341: g_error_rec_cnt := 0;
6342: g_error_code := NULL;
6343:
6344: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6345: fnd_message.set_token('VIEW', 'IVSTARZ2 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6346: fnd_file.put_line(fnd_file.log, fnd_message.get);
6347:
6348: -- Get all the reocords from interface table with status = 'N'
6349: FOR new_ivstarz2_rec IN new_ivstarz2_cur

Line 6346: fnd_file.put_line(fnd_file.log, fnd_message.get);

6342: g_error_code := NULL;
6343:
6344: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6345: fnd_message.set_token('VIEW', 'IVSTARZ2 ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6346: fnd_file.put_line(fnd_file.log, fnd_message.get);
6347:
6348: -- Get all the reocords from interface table with status = 'N'
6349: FOR new_ivstarz2_rec IN new_ivstarz2_cur
6350: LOOP

Line 6363: fnd_message.set_name('IGS','IGS_UC_APPNO_ROUND_PROC');

6359: validate_inst_rec := NULL;
6360: l_clearing_id := NULL;
6361:
6362: -- log record processing info.
6363: fnd_message.set_name('IGS','IGS_UC_APPNO_ROUND_PROC');
6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));
6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);
6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);
6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);

Line 6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));

6360: l_clearing_id := NULL;
6361:
6362: -- log record processing info.
6363: fnd_message.set_name('IGS','IGS_UC_APPNO_ROUND_PROC');
6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));
6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);
6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);
6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);
6368: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);

6361:
6362: -- log record processing info.
6363: fnd_message.set_name('IGS','IGS_UC_APPNO_ROUND_PROC');
6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));
6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);
6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);
6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);
6368: fnd_file.put_line(fnd_file.log, fnd_message.get);
6369:

Line 6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);

6362: -- log record processing info.
6363: fnd_message.set_name('IGS','IGS_UC_APPNO_ROUND_PROC');
6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));
6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);
6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);
6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);
6368: fnd_file.put_line(fnd_file.log, fnd_message.get);
6369:
6370:

Line 6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);

6363: fnd_message.set_name('IGS','IGS_UC_APPNO_ROUND_PROC');
6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));
6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);
6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);
6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);
6368: fnd_file.put_line(fnd_file.log, fnd_message.get);
6369:
6370:
6371: -- no mandatory field validations as this is an update

Line 6368: fnd_file.put_line(fnd_file.log, fnd_message.get);

6364: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarz2_rec.appno));
6365: fnd_message.set_token('INST', new_ivstarz2_rec.inst);
6366: fnd_message.set_token('PROGRAM', new_ivstarz2_rec.course);
6367: fnd_message.set_token('CAMPUS', new_ivstarz2_rec.campus);
6368: fnd_file.put_line(fnd_file.log, fnd_message.get);
6369:
6370:
6371: -- no mandatory field validations as this is an update
6372: IF new_ivstarz2_rec.appno IS NULL OR

Line 6638: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

6634:
6635: EXCEPTION
6636: WHEN OTHERS THEN
6637: ROLLBACK;
6638: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6639: fnd_message.set_token('VIEW', 'IVSTARZ2'||' - '||SQLERRM);
6640: fnd_file.put_line(fnd_file.log, fnd_message.get);
6641: END process_ivstarz2;
6642:

Line 6639: fnd_message.set_token('VIEW', 'IVSTARZ2'||' - '||SQLERRM);

6635: EXCEPTION
6636: WHEN OTHERS THEN
6637: ROLLBACK;
6638: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6639: fnd_message.set_token('VIEW', 'IVSTARZ2'||' - '||SQLERRM);
6640: fnd_file.put_line(fnd_file.log, fnd_message.get);
6641: END process_ivstarz2;
6642:
6643:

Line 6640: fnd_file.put_line(fnd_file.log, fnd_message.get);

6636: WHEN OTHERS THEN
6637: ROLLBACK;
6638: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6639: fnd_message.set_token('VIEW', 'IVSTARZ2'||' - '||SQLERRM);
6640: fnd_file.put_line(fnd_file.log, fnd_message.get);
6641: END process_ivstarz2;
6642:
6643:
6644:

Line 6690: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

6686: g_success_rec_cnt := 0;
6687: g_error_rec_cnt := 0;
6688: g_error_code := NULL;
6689:
6690: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6691: fnd_message.set_token('VIEW', 'IVSTARW ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6692: fnd_file.put_line(fnd_file.log, fnd_message.get);
6693:
6694: --get the reinstate remark text from IGS_UC_APP_WITHDRAWN lookup

Line 6691: fnd_message.set_token('VIEW', 'IVSTARW ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

6687: g_error_rec_cnt := 0;
6688: g_error_code := NULL;
6689:
6690: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6691: fnd_message.set_token('VIEW', 'IVSTARW ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6692: fnd_file.put_line(fnd_file.log, fnd_message.get);
6693:
6694: --get the reinstate remark text from IGS_UC_APP_WITHDRAWN lookup
6695: OPEN c_reinstate_meaning;

Line 6692: fnd_file.put_line(fnd_file.log, fnd_message.get);

6688: g_error_code := NULL;
6689:
6690: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6691: fnd_message.set_token('VIEW', 'IVSTARW ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6692: fnd_file.put_line(fnd_file.log, fnd_message.get);
6693:
6694: --get the reinstate remark text from IGS_UC_APP_WITHDRAWN lookup
6695: OPEN c_reinstate_meaning;
6696: FETCH c_reinstate_meaning INTO l_reinstate_meaning;

Line 6709: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');

6705: g_error_code := NULL;
6706: old_starw_rec := NULL;
6707:
6708: -- log record processing info.
6709: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
6710: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarw_rec.appno));
6711: fnd_file.put_line(fnd_file.log, fnd_message.get);
6712:
6713:

Line 6710: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarw_rec.appno));

6706: old_starw_rec := NULL;
6707:
6708: -- log record processing info.
6709: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
6710: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarw_rec.appno));
6711: fnd_file.put_line(fnd_file.log, fnd_message.get);
6712:
6713:
6714: -- no mandatory field validations as this is an update

Line 6711: fnd_file.put_line(fnd_file.log, fnd_message.get);

6707:
6708: -- log record processing info.
6709: fnd_message.set_name('IGS','IGS_UC_APPNO_PROC');
6710: fnd_message.set_token('APPL_NO', TO_CHAR(new_ivstarw_rec.appno));
6711: fnd_file.put_line(fnd_file.log, fnd_message.get);
6712:
6713:
6714: -- no mandatory field validations as this is an update
6715: IF new_ivstarw_rec.appno IS NULL THEN

Line 6869: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

6865:
6866: EXCEPTION
6867: WHEN OTHERS THEN
6868: ROLLBACK;
6869: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6870: fnd_message.set_token('VIEW', 'IVSTARW'||' - '||SQLERRM);
6871: fnd_file.put_line(fnd_file.log, fnd_message.get);
6872: END process_ivstarw;
6873:

Line 6870: fnd_message.set_token('VIEW', 'IVSTARW'||' - '||SQLERRM);

6866: EXCEPTION
6867: WHEN OTHERS THEN
6868: ROLLBACK;
6869: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6870: fnd_message.set_token('VIEW', 'IVSTARW'||' - '||SQLERRM);
6871: fnd_file.put_line(fnd_file.log, fnd_message.get);
6872: END process_ivstarw;
6873:
6874:

Line 6871: fnd_file.put_line(fnd_file.log, fnd_message.get);

6867: WHEN OTHERS THEN
6868: ROLLBACK;
6869: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
6870: fnd_message.set_token('VIEW', 'IVSTARW'||' - '||SQLERRM);
6871: fnd_file.put_line(fnd_file.log, fnd_message.get);
6872: END process_ivstarw;
6873:
6874:
6875:

Line 6924: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

6920: g_success_rec_cnt := 0;
6921: g_error_rec_cnt := 0;
6922: g_error_code := NULL;
6923:
6924: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6925: fnd_message.set_token('VIEW', 'IVREFERENCE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6926: fnd_file.put_line(fnd_file.log, fnd_message.get);
6927:
6928: -- Get all the reocords from interface table with status = 'N'

Line 6925: fnd_message.set_token('VIEW', 'IVREFERENCE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

6921: g_error_rec_cnt := 0;
6922: g_error_code := NULL;
6923:
6924: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6925: fnd_message.set_token('VIEW', 'IVREFERENCE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6926: fnd_file.put_line(fnd_file.log, fnd_message.get);
6927:
6928: -- Get all the reocords from interface table with status = 'N'
6929: FOR new_ireference_rec IN new_ivrefer_cur

Line 6926: fnd_file.put_line(fnd_file.log, fnd_message.get);

6922: g_error_code := NULL;
6923:
6924: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
6925: fnd_message.set_token('VIEW', 'IVREFERENCE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
6926: fnd_file.put_line(fnd_file.log, fnd_message.get);
6927:
6928: -- Get all the reocords from interface table with status = 'N'
6929: FOR new_ireference_rec IN new_ivrefer_cur
6930: LOOP

Line 6939: fnd_message.set_name('IGS','IGS_UC_APPNO_REFEREE_PROC');

6935: old_refer_rec := NULL;
6936:
6937:
6938: -- log record processing info.
6939: fnd_message.set_name('IGS','IGS_UC_APPNO_REFEREE_PROC');
6940: fnd_message.set_token('APPNO', TO_CHAR(new_ireference_rec.appno));
6941: fnd_message.set_token('REFEREE', new_ireference_rec.refereename);
6942: fnd_file.put_line(fnd_file.log, fnd_message.get);
6943:

Line 6940: fnd_message.set_token('APPNO', TO_CHAR(new_ireference_rec.appno));

6936:
6937:
6938: -- log record processing info.
6939: fnd_message.set_name('IGS','IGS_UC_APPNO_REFEREE_PROC');
6940: fnd_message.set_token('APPNO', TO_CHAR(new_ireference_rec.appno));
6941: fnd_message.set_token('REFEREE', new_ireference_rec.refereename);
6942: fnd_file.put_line(fnd_file.log, fnd_message.get);
6943:
6944:

Line 6941: fnd_message.set_token('REFEREE', new_ireference_rec.refereename);

6937:
6938: -- log record processing info.
6939: fnd_message.set_name('IGS','IGS_UC_APPNO_REFEREE_PROC');
6940: fnd_message.set_token('APPNO', TO_CHAR(new_ireference_rec.appno));
6941: fnd_message.set_token('REFEREE', new_ireference_rec.refereename);
6942: fnd_file.put_line(fnd_file.log, fnd_message.get);
6943:
6944:
6945: -- no mandatory field validations as this is an update

Line 6942: fnd_file.put_line(fnd_file.log, fnd_message.get);

6938: -- log record processing info.
6939: fnd_message.set_name('IGS','IGS_UC_APPNO_REFEREE_PROC');
6940: fnd_message.set_token('APPNO', TO_CHAR(new_ireference_rec.appno));
6941: fnd_message.set_token('REFEREE', new_ireference_rec.refereename);
6942: fnd_file.put_line(fnd_file.log, fnd_message.get);
6943:
6944:
6945: -- no mandatory field validations as this is an update
6946: IF new_ireference_rec.appno IS NULL THEN

Line 7119: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

7115:
7116: EXCEPTION
7117: WHEN OTHERS THEN
7118: ROLLBACK;
7119: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7120: fnd_message.set_token('VIEW', 'IVREFERENCE'||' - '||SQLERRM);
7121: fnd_file.put_line(fnd_file.log, fnd_message.get);
7122: END process_ivreference;
7123:

Line 7120: fnd_message.set_token('VIEW', 'IVREFERENCE'||' - '||SQLERRM);

7116: EXCEPTION
7117: WHEN OTHERS THEN
7118: ROLLBACK;
7119: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7120: fnd_message.set_token('VIEW', 'IVREFERENCE'||' - '||SQLERRM);
7121: fnd_file.put_line(fnd_file.log, fnd_message.get);
7122: END process_ivreference;
7123:
7124:

Line 7121: fnd_file.put_line(fnd_file.log, fnd_message.get);

7117: WHEN OTHERS THEN
7118: ROLLBACK;
7119: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7120: fnd_message.set_token('VIEW', 'IVREFERENCE'||' - '||SQLERRM);
7121: fnd_file.put_line(fnd_file.log, fnd_message.get);
7122: END process_ivreference;
7123:
7124:
7125:

Line 7168: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

7164: g_success_rec_cnt := 0;
7165: g_error_rec_cnt := 0;
7166: g_error_code := NULL;
7167:
7168: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
7169: fnd_message.set_token('VIEW', 'IVFORMQUALS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
7170: fnd_file.put_line(fnd_file.log, fnd_message.get);
7171:
7172: -- Get all the reocords from interface table with status = 'N'

Line 7169: fnd_message.set_token('VIEW', 'IVFORMQUALS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

7165: g_error_rec_cnt := 0;
7166: g_error_code := NULL;
7167:
7168: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
7169: fnd_message.set_token('VIEW', 'IVFORMQUALS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
7170: fnd_file.put_line(fnd_file.log, fnd_message.get);
7171:
7172: -- Get all the reocords from interface table with status = 'N'
7173: FOR new_ivfrmqual_rec IN new_ivfrmqual_cur

Line 7170: fnd_file.put_line(fnd_file.log, fnd_message.get);

7166: g_error_code := NULL;
7167:
7168: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
7169: fnd_message.set_token('VIEW', 'IVFORMQUALS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
7170: fnd_file.put_line(fnd_file.log, fnd_message.get);
7171:
7172: -- Get all the reocords from interface table with status = 'N'
7173: FOR new_ivfrmqual_rec IN new_ivfrmqual_cur
7174: LOOP

Line 7182: fnd_message.set_name('IGS','IGS_UC_APPNO_QUAL_PROC');

7178: g_error_code := NULL;
7179: old_frmqual_rec := NULL;
7180:
7181: -- log record processing info.
7182: fnd_message.set_name('IGS','IGS_UC_APPNO_QUAL_PROC');
7183: fnd_message.set_token('APPNO', TO_CHAR(new_ivfrmqual_rec.appno));
7184: fnd_message.set_token('QUAL', TO_CHAR(new_ivfrmqual_rec.qualid));
7185: fnd_file.put_line(fnd_file.log, fnd_message.get);
7186:

Line 7183: fnd_message.set_token('APPNO', TO_CHAR(new_ivfrmqual_rec.appno));

7179: old_frmqual_rec := NULL;
7180:
7181: -- log record processing info.
7182: fnd_message.set_name('IGS','IGS_UC_APPNO_QUAL_PROC');
7183: fnd_message.set_token('APPNO', TO_CHAR(new_ivfrmqual_rec.appno));
7184: fnd_message.set_token('QUAL', TO_CHAR(new_ivfrmqual_rec.qualid));
7185: fnd_file.put_line(fnd_file.log, fnd_message.get);
7186:
7187:

Line 7184: fnd_message.set_token('QUAL', TO_CHAR(new_ivfrmqual_rec.qualid));

7180:
7181: -- log record processing info.
7182: fnd_message.set_name('IGS','IGS_UC_APPNO_QUAL_PROC');
7183: fnd_message.set_token('APPNO', TO_CHAR(new_ivfrmqual_rec.appno));
7184: fnd_message.set_token('QUAL', TO_CHAR(new_ivfrmqual_rec.qualid));
7185: fnd_file.put_line(fnd_file.log, fnd_message.get);
7186:
7187:
7188: -- no mandatory field validations as this is an update

Line 7185: fnd_file.put_line(fnd_file.log, fnd_message.get);

7181: -- log record processing info.
7182: fnd_message.set_name('IGS','IGS_UC_APPNO_QUAL_PROC');
7183: fnd_message.set_token('APPNO', TO_CHAR(new_ivfrmqual_rec.appno));
7184: fnd_message.set_token('QUAL', TO_CHAR(new_ivfrmqual_rec.qualid));
7185: fnd_file.put_line(fnd_file.log, fnd_message.get);
7186:
7187:
7188: -- no mandatory field validations as this is an update
7189: IF new_ivfrmqual_rec.appno IS NULL THEN

Line 7318: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

7314:
7315: EXCEPTION
7316: WHEN OTHERS THEN
7317: ROLLBACK;
7318: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7319: fnd_message.set_token('VIEW', 'IVFORMQUALS'||' - '||SQLERRM);
7320: fnd_file.put_line(fnd_file.log, fnd_message.get);
7321: END process_ivformquals;
7322:

Line 7319: fnd_message.set_token('VIEW', 'IVFORMQUALS'||' - '||SQLERRM);

7315: EXCEPTION
7316: WHEN OTHERS THEN
7317: ROLLBACK;
7318: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7319: fnd_message.set_token('VIEW', 'IVFORMQUALS'||' - '||SQLERRM);
7320: fnd_file.put_line(fnd_file.log, fnd_message.get);
7321: END process_ivformquals;
7322:
7323:

Line 7320: fnd_file.put_line(fnd_file.log, fnd_message.get);

7316: WHEN OTHERS THEN
7317: ROLLBACK;
7318: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7319: fnd_message.set_token('VIEW', 'IVFORMQUALS'||' - '||SQLERRM);
7320: fnd_file.put_line(fnd_file.log, fnd_message.get);
7321: END process_ivformquals;
7322:
7323:
7324:

Line 7452: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

7448: g_success_rec_cnt := 0;
7449: g_error_rec_cnt := 0;
7450: g_error_code := NULL;
7451:
7452: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
7453: fnd_message.set_token('VIEW', 'IVSTARPQR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
7454: fnd_file.put_line(fnd_file.log, fnd_message.get);
7455:
7456: -- Bug No. 3114787. Code added to so that all the records for an applicant get processed or none

Line 7453: fnd_message.set_token('VIEW', 'IVSTARPQR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

7449: g_error_rec_cnt := 0;
7450: g_error_code := NULL;
7451:
7452: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
7453: fnd_message.set_token('VIEW', 'IVSTARPQR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
7454: fnd_file.put_line(fnd_file.log, fnd_message.get);
7455:
7456: -- Bug No. 3114787. Code added to so that all the records for an applicant get processed or none
7457: -- the processing is rolled back.

Line 7454: fnd_file.put_line(fnd_file.log, fnd_message.get);

7450: g_error_code := NULL;
7451:
7452: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
7453: fnd_message.set_token('VIEW', 'IVSTARPQR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
7454: fnd_file.put_line(fnd_file.log, fnd_message.get);
7455:
7456: -- Bug No. 3114787. Code added to so that all the records for an applicant get processed or none
7457: -- the processing is rolled back.
7458: -- LOOP through the Applications to be processed

Line 7488: fnd_message.set_name('IGS','IGS_UC_APPNO_SUBJ_PROC');

7484: l_conv_ebl_code := NULL;
7485: l_subjectid := NULL;
7486:
7487: -- log record processing info.
7488: fnd_message.set_name('IGS','IGS_UC_APPNO_SUBJ_PROC');
7489: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarpqr_rec.appno));
7490: fnd_message.set_token('SUBJ', TO_CHAR(new_ivstarpqr_rec.subjectid));
7491: fnd_file.put_line(fnd_file.log, fnd_message.get);
7492:

Line 7489: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarpqr_rec.appno));

7485: l_subjectid := NULL;
7486:
7487: -- log record processing info.
7488: fnd_message.set_name('IGS','IGS_UC_APPNO_SUBJ_PROC');
7489: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarpqr_rec.appno));
7490: fnd_message.set_token('SUBJ', TO_CHAR(new_ivstarpqr_rec.subjectid));
7491: fnd_file.put_line(fnd_file.log, fnd_message.get);
7492:
7493: ----------------------------

Line 7490: fnd_message.set_token('SUBJ', TO_CHAR(new_ivstarpqr_rec.subjectid));

7486:
7487: -- log record processing info.
7488: fnd_message.set_name('IGS','IGS_UC_APPNO_SUBJ_PROC');
7489: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarpqr_rec.appno));
7490: fnd_message.set_token('SUBJ', TO_CHAR(new_ivstarpqr_rec.subjectid));
7491: fnd_file.put_line(fnd_file.log, fnd_message.get);
7492:
7493: ----------------------------
7494: -- AppNo validation

Line 7491: fnd_file.put_line(fnd_file.log, fnd_message.get);

7487: -- log record processing info.
7488: fnd_message.set_name('IGS','IGS_UC_APPNO_SUBJ_PROC');
7489: fnd_message.set_token('APPNO', TO_CHAR(new_ivstarpqr_rec.appno));
7490: fnd_message.set_token('SUBJ', TO_CHAR(new_ivstarpqr_rec.subjectid));
7491: fnd_file.put_line(fnd_file.log, fnd_message.get);
7492:
7493: ----------------------------
7494: -- AppNo validation
7495: ----------------------------

Line 7558: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_MAP_REC') ;

7554:
7555: IF c_map_exam_ebl%NOTFOUND THEN
7556: CLOSE c_map_exam_ebl ;
7557: g_error_code := '1059';
7558: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_MAP_REC') ;
7559: fnd_message.set_token ('EXAM_BRD', new_ivstarpqr_rec.examboard) ;
7560: fnd_message.set_token('EBL_CD',l_gen_ebl_format) ;
7561: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7562:

Line 7559: fnd_message.set_token ('EXAM_BRD', new_ivstarpqr_rec.examboard) ;

7555: IF c_map_exam_ebl%NOTFOUND THEN
7556: CLOSE c_map_exam_ebl ;
7557: g_error_code := '1059';
7558: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_MAP_REC') ;
7559: fnd_message.set_token ('EXAM_BRD', new_ivstarpqr_rec.examboard) ;
7560: fnd_message.set_token('EBL_CD',l_gen_ebl_format) ;
7561: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7562:
7563: ELSE

Line 7560: fnd_message.set_token('EBL_CD',l_gen_ebl_format) ;

7556: CLOSE c_map_exam_ebl ;
7557: g_error_code := '1059';
7558: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_MAP_REC') ;
7559: fnd_message.set_token ('EXAM_BRD', new_ivstarpqr_rec.examboard) ;
7560: fnd_message.set_token('EBL_CD',l_gen_ebl_format) ;
7561: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7562:
7563: ELSE
7564: -- If mapping seeded record is found then set the correct exam_level in cases where the cursor

Line 7561: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;

7557: g_error_code := '1059';
7558: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_MAP_REC') ;
7559: fnd_message.set_token ('EXAM_BRD', new_ivstarpqr_rec.examboard) ;
7560: fnd_message.set_token('EBL_CD',l_gen_ebl_format) ;
7561: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7562:
7563: ELSE
7564: -- If mapping seeded record is found then set the correct exam_level in cases where the cursor
7565: -- will fetch more than 1 rows , these cases are exam board A/L/O/N/W and generic ebl code ANN

Line 7631: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_SUBJ_REC') ;

7627: IF c_subjectid%NOTFOUND THEN
7628: CLOSE c_subjectid ;
7629: g_error_code := '1021'; -- subject not in ebl subject table.
7630:
7631: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_SUBJ_REC') ;
7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;
7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;

Line 7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;

7628: CLOSE c_subjectid ;
7629: g_error_code := '1021'; -- subject not in ebl subject table.
7630:
7631: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_SUBJ_REC') ;
7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;
7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;
7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;

Line 7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;

7629: g_error_code := '1021'; -- subject not in ebl subject table.
7630:
7631: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_SUBJ_REC') ;
7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;
7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;
7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;
7637: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;

Line 7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;

7630:
7631: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_SUBJ_REC') ;
7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;
7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;
7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;
7637: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7638: ELSE

Line 7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;

7631: fnd_message.set_name( 'IGS','IGS_UC_NO_EBL_SUBJ_REC') ;
7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;
7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;
7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;
7637: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7638: ELSE
7639: -- populate subject ID value into Rec so that it can be processed as usual(as a record)

Line 7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;

7632: fnd_message.set_token ('YEAR', new_ivstarpqr_rec.yearofexam) ;
7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;
7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;
7637: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7638: ELSE
7639: -- populate subject ID value into Rec so that it can be processed as usual(as a record)
7640: new_ivstarpqr_rec.subjectid := l_subjectid;

Line 7637: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;

7633: fnd_message.set_token('SITTING', new_ivstarpqr_rec.sitting) ;
7634: fnd_message.set_token('AWD_BDY',c_map_exam_ebl_rec.awarding_body) ;
7635: fnd_message.set_token('EXAM_LEVEL',c_map_exam_ebl_rec.exam_level) ;
7636: fnd_message.set_token('EBL_SUBJ',l_conv_ebl_code ) ;
7637: fnd_file.put_line(fnd_file.LOG,fnd_message.get()) ;
7638: ELSE
7639: -- populate subject ID value into Rec so that it can be processed as usual(as a record)
7640: new_ivstarpqr_rec.subjectid := l_subjectid;
7641: CLOSE c_subjectid ;

Line 7882: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

7878:
7879: EXCEPTION
7880: WHEN OTHERS THEN
7881: ROLLBACK;
7882: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7883: fnd_message.set_token('VIEW', 'IVSTARPQR'||' - '||SQLERRM);
7884: fnd_file.put_line(fnd_file.log, fnd_message.get);
7885: END process_ivstarpqr;
7886:

Line 7883: fnd_message.set_token('VIEW', 'IVSTARPQR'||' - '||SQLERRM);

7879: EXCEPTION
7880: WHEN OTHERS THEN
7881: ROLLBACK;
7882: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7883: fnd_message.set_token('VIEW', 'IVSTARPQR'||' - '||SQLERRM);
7884: fnd_file.put_line(fnd_file.log, fnd_message.get);
7885: END process_ivstarpqr;
7886:
7887:

Line 7884: fnd_file.put_line(fnd_file.log, fnd_message.get);

7880: WHEN OTHERS THEN
7881: ROLLBACK;
7882: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
7883: fnd_message.set_token('VIEW', 'IVSTARPQR'||' - '||SQLERRM);
7884: fnd_file.put_line(fnd_file.log, fnd_message.get);
7885: END process_ivstarpqr;
7886:
7887:
7888: END igs_uc_proc_application_data;