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.IGF_AP_ISIR_IMPORT_PKG dependencies on FND_MESSAGE

Line 170: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

166: END IF;
167:
168: EXCEPTION
169: WHEN others THEN
170: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
171: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.L_IS_COR_FROM_SAME_SCHOOL');
172: fnd_file.put_line(fnd_file.log,SQLERRM);
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;

Line 171: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.L_IS_COR_FROM_SAME_SCHOOL');

167:
168: EXCEPTION
169: WHEN others THEN
170: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
171: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.L_IS_COR_FROM_SAME_SCHOOL');
172: fnd_file.put_line(fnd_file.log,SQLERRM);
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175:

Line 280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');

276:
277: IF l_request_id > 0 THEN
278: -- successfully submitted then log message
279: fnd_file.put_line( fnd_file.LOG ,' ');
280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 281: fnd_message.set_token('REQUEST_ID', l_request_id);

277: IF l_request_id > 0 THEN
278: -- successfully submitted then log message
279: fnd_file.put_line( fnd_file.LOG ,' ');
280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE

Line 282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);

278: -- successfully submitted then log message
279: fnd_file.put_line( fnd_file.LOG ,' ');
280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE
286: -- if error then log message

Line 283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);

279: fnd_file.put_line( fnd_file.LOG ,' ');
280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');

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

280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');
288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);

Line 287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');

283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');
288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
289: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
290: END IF;
291:

Line 288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);

284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');
288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
289: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
290: END IF;
291:
292: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');
288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
289: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
290: END IF;
291:
292: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug','Launched spawned request ' || p_sub_req_number || ' Request ID : ' || l_request_id);

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

298: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
299: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.launch_sub_request.exception','The exception is : ' || SQLERRM );
300: END IF;
301:
302: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: igs_ge_msg_stack.add;
306: RETURN; -- continue processing for the next sub request.

Line 303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');

299: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.launch_sub_request.exception','The exception is : ' || SQLERRM );
300: END IF;
301:
302: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: igs_ge_msg_stack.add;
306: RETURN; -- continue processing for the next sub request.
307: END launch_sub_request;

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

300: END IF;
301:
302: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: igs_ge_msg_stack.add;
306: RETURN; -- continue processing for the next sub request.
307: END launch_sub_request;
308:

Line 368: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');

364: FETCH cur_batch_aw_map INTO l_valid_found ;
365:
366: IF cur_batch_aw_map%NOTFOUND THEN
367: CLOSE cur_batch_aw_map ;
368: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
369: errbuf := fnd_message.get;
370: igs_ge_msg_stack.add;
371: retcode := 2;
372: RETURN;

Line 369: errbuf := fnd_message.get;

365:
366: IF cur_batch_aw_map%NOTFOUND THEN
367: CLOSE cur_batch_aw_map ;
368: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
369: errbuf := fnd_message.get;
370: igs_ge_msg_stack.add;
371: retcode := 2;
372: RETURN;
373: END IF ;

Line 385: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');

381: FETCH cur_lookups INTO l_valid_found;
382:
383: IF cur_lookups%NOTFOUND THEN
384: CLOSE cur_lookups;
385: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
386: fnd_message.set_token('PARAM_TYPE', 'RECORD TYPE');
387: errbuf := fnd_message.get;
388: igs_ge_msg_stack.add;
389: retcode := 2;

Line 386: fnd_message.set_token('PARAM_TYPE', 'RECORD TYPE');

382:
383: IF cur_lookups%NOTFOUND THEN
384: CLOSE cur_lookups;
385: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
386: fnd_message.set_token('PARAM_TYPE', 'RECORD TYPE');
387: errbuf := fnd_message.get;
388: igs_ge_msg_stack.add;
389: retcode := 2;
390: RETURN;

Line 387: errbuf := fnd_message.get;

383: IF cur_lookups%NOTFOUND THEN
384: CLOSE cur_lookups;
385: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
386: fnd_message.set_token('PARAM_TYPE', 'RECORD TYPE');
387: errbuf := fnd_message.get;
388: igs_ge_msg_stack.add;
389: retcode := 2;
390: RETURN;
391: END IF ;

Line 405: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');

401: FETCH cur_lookups INTO l_valid_found;
402:
403: IF cur_lookups%NOTFOUND THEN
404: CLOSE cur_lookups;
405: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
406: fnd_message.set_token('PARAM_TYPE', 'RECORD STATUS');
407: errbuf := fnd_message.get;
408: igs_ge_msg_stack.add;
409: retcode := 2;

Line 406: fnd_message.set_token('PARAM_TYPE', 'RECORD STATUS');

402:
403: IF cur_lookups%NOTFOUND THEN
404: CLOSE cur_lookups;
405: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
406: fnd_message.set_token('PARAM_TYPE', 'RECORD STATUS');
407: errbuf := fnd_message.get;
408: igs_ge_msg_stack.add;
409: retcode := 2;
410: RETURN;

Line 407: errbuf := fnd_message.get;

403: IF cur_lookups%NOTFOUND THEN
404: CLOSE cur_lookups;
405: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
406: fnd_message.set_token('PARAM_TYPE', 'RECORD STATUS');
407: errbuf := fnd_message.get;
408: igs_ge_msg_stack.add;
409: retcode := 2;
410: RETURN;
411: END IF ;

Line 424: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');

420: FETCH cur_lookups INTO l_valid_found;
421:
422: IF cur_lookups%NOTFOUND THEN
423: CLOSE cur_lookups;
424: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
425: fnd_message.set_token('PARAM_TYPE', 'MESSAGE CLASS');
426: errbuf := fnd_message.get;
427: igs_ge_msg_stack.add;
428: retcode := 2;

Line 425: fnd_message.set_token('PARAM_TYPE', 'MESSAGE CLASS');

421:
422: IF cur_lookups%NOTFOUND THEN
423: CLOSE cur_lookups;
424: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
425: fnd_message.set_token('PARAM_TYPE', 'MESSAGE CLASS');
426: errbuf := fnd_message.get;
427: igs_ge_msg_stack.add;
428: retcode := 2;
429: RETURN;

Line 426: errbuf := fnd_message.get;

422: IF cur_lookups%NOTFOUND THEN
423: CLOSE cur_lookups;
424: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
425: fnd_message.set_token('PARAM_TYPE', 'MESSAGE CLASS');
426: errbuf := fnd_message.get;
427: igs_ge_msg_stack.add;
428: retcode := 2;
429: RETURN;
430: END IF ;

Line 444: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');

440: FETCH cur_school_cd INTO l_valid_found;
441:
442: IF cur_school_cd%NOTFOUND THEN
443: CLOSE cur_school_cd;
444: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
445: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');
446: errbuf := fnd_message.get;
447: igs_ge_msg_stack.add;
448: retcode := 2;

Line 445: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');

441:
442: IF cur_school_cd%NOTFOUND THEN
443: CLOSE cur_school_cd;
444: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
445: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');
446: errbuf := fnd_message.get;
447: igs_ge_msg_stack.add;
448: retcode := 2;
449: RETURN;

Line 446: errbuf := fnd_message.get;

442: IF cur_school_cd%NOTFOUND THEN
443: CLOSE cur_school_cd;
444: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
445: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');
446: errbuf := fnd_message.get;
447: igs_ge_msg_stack.add;
448: retcode := 2;
449: RETURN;
450: END IF ;

Line 463: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');

459: FETCH cur_match_set INTO l_valid_found;
460:
461: IF cur_match_set%NOTFOUND THEN
462: CLOSE cur_match_set;
463: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
464: fnd_message.set_token('PARAM_TYPE', 'MATCH SET CODE');
465: errbuf := fnd_message.get;
466: igs_ge_msg_stack.add;
467: retcode := 2;

Line 464: fnd_message.set_token('PARAM_TYPE', 'MATCH SET CODE');

460:
461: IF cur_match_set%NOTFOUND THEN
462: CLOSE cur_match_set;
463: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
464: fnd_message.set_token('PARAM_TYPE', 'MATCH SET CODE');
465: errbuf := fnd_message.get;
466: igs_ge_msg_stack.add;
467: retcode := 2;
468: RETURN;

Line 465: errbuf := fnd_message.get;

461: IF cur_match_set%NOTFOUND THEN
462: CLOSE cur_match_set;
463: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
464: fnd_message.set_token('PARAM_TYPE', 'MATCH SET CODE');
465: errbuf := fnd_message.get;
466: igs_ge_msg_stack.add;
467: retcode := 2;
468: RETURN;
469: END IF ;

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

480: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
481: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.exception','The exception is : ' || SQLERRM );
482: END IF;
483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: fnd_file.put_line(fnd_file.log, SQLERRM);
488: igs_ge_msg_stack.add;

Line 485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');

481: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.validate_parameters.exception','The exception is : ' || SQLERRM );
482: END IF;
483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: fnd_file.put_line(fnd_file.log, SQLERRM);
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;

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

482: END IF;
483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: fnd_file.put_line(fnd_file.log, SQLERRM);
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END validate_parameters;

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

572: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
573: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.exception','The exception is : ' || SQLERRM );
574: END IF;
575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579: fnd_file.put_line(fnd_file.log, SQLERRM);
580: igs_ge_msg_stack.add;

Line 577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');

573: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.exception','The exception is : ' || SQLERRM );
574: END IF;
575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579: fnd_file.put_line(fnd_file.log, SQLERRM);
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;

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

574: END IF;
575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579: fnd_file.put_line(fnd_file.log, SQLERRM);
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END build_selection_criteria;

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

648: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.query_isir_records.exception','The exception is : ' || SQLERRM );
649: END IF;
650: log_debug_message('EXCEPTION : ' || SQLERRM);
651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: fnd_file.put_line(fnd_file.log, SQLERRM);
656: igs_ge_msg_stack.add;

Line 653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');

649: END IF;
650: log_debug_message('EXCEPTION : ' || SQLERRM);
651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: fnd_file.put_line(fnd_file.log, SQLERRM);
656: igs_ge_msg_stack.add;
657: app_exception.raise_exception;

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

650: log_debug_message('EXCEPTION : ' || SQLERRM);
651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: fnd_file.put_line(fnd_file.log, SQLERRM);
656: igs_ge_msg_stack.add;
657: app_exception.raise_exception;
658: END query_isir_records;

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

776: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.exception','The exception is : ' || SQLERRM );
777: END IF;
778: log_debug_message(' EXCEPTION in spawn_processes : ' || SQLERRM);
779:
780: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783: igs_ge_msg_stack.add;
784: app_exception.raise_exception;

Line 781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');

777: END IF;
778: log_debug_message(' EXCEPTION in spawn_processes : ' || SQLERRM);
779:
780: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783: igs_ge_msg_stack.add;
784: app_exception.raise_exception;
785: END spawn_processes;

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

778: log_debug_message(' EXCEPTION in spawn_processes : ' || SQLERRM);
779:
780: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783: igs_ge_msg_stack.add;
784: app_exception.raise_exception;
785: END spawn_processes;
786:

Line 800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');

796: log_debug_message(' Beginning Main process at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
797:
798: -- print input parameters
799: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');
801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');

Line 801: fnd_message.set_token('AWD_YEAR', p_award_year);

797:
798: -- print input parameters
799: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');
801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);

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

798: -- print input parameters
799: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');
801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');

800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');
801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');

Line 805: fnd_message.set_token('CREATE_PRSN', p_force_add);

801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);

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

802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');

804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');

Line 809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);

805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);

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

806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');

808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');

Line 813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);

809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);

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

810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');

812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');

Line 817: fnd_message.set_token('MATCH_CODE', p_match_code);

813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);

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

814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');

816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');

Line 821: fnd_message.set_token('REC_TYPE', p_rec_type);

817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);

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

818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');

820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');

Line 825: fnd_message.set_token('REC_STATUS', p_rec_status);

821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);

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

822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');

824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');

Line 829: fnd_message.set_token('MSG_CLASS', p_message_class);

825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);

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

826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');

828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');

Line 833: fnd_message.set_token('SCHOOL_CD', p_school_code);

829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);

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

830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');

832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');

Line 837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);

833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);

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

834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');

836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');

Line 841: fnd_message.set_token('DEL_FLAG', p_del_int);

837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);

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

838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');

840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);
847:
848: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');

Line 845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);

841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);
847:
848: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
849:

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

842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);
847:
848: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
849:
850: errbuf := NULL;

Line 888: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');

884: FETCH c_batch INTO l_batch;
885: CLOSE c_batch;
886:
887: IF l_batch.batch_year IS NULL THEN
888: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
889: errbuf := fnd_message.get;
890: fnd_file.put_line(fnd_file.log, errbuf);
891: RETCODE := 2;
892: RETURN;

Line 889: errbuf := fnd_message.get;

885: CLOSE c_batch;
886:
887: IF l_batch.batch_year IS NULL THEN
888: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
889: errbuf := fnd_message.get;
890: fnd_file.put_line(fnd_file.log, errbuf);
891: RETCODE := 2;
892: RETURN;
893: END IF;

Line 901: fnd_message.set_name('IGF', 'IGF_AP_SOURCE_TYPE_REQ');

897: -- Initialize the variable with Basic SQL statement to which the dynamic where clause can be appended later.
898: l_sql := 'SELECT si_id, batch_year_num, original_ssn_txt, orig_name_id_txt FROM igf_ap_isir_ints WHERE batch_year_num = ' || g_batch_year ;
899:
900: IF LTRIM(RTRIM(p_create_inquiry)) = 'Y' AND LTRIM(RTRIM(p_adm_source_type)) IS NULL THEN
901: fnd_message.set_name('IGF', 'IGF_AP_SOURCE_TYPE_REQ');
902: errbuf := fnd_message.get;
903: fnd_file.put_line(fnd_file.log,errbuf);
904: retcode := 2;
905: RETURN;

Line 902: errbuf := fnd_message.get;

898: l_sql := 'SELECT si_id, batch_year_num, original_ssn_txt, orig_name_id_txt FROM igf_ap_isir_ints WHERE batch_year_num = ' || g_batch_year ;
899:
900: IF LTRIM(RTRIM(p_create_inquiry)) = 'Y' AND LTRIM(RTRIM(p_adm_source_type)) IS NULL THEN
901: fnd_message.set_name('IGF', 'IGF_AP_SOURCE_TYPE_REQ');
902: errbuf := fnd_message.get;
903: fnd_file.put_line(fnd_file.log,errbuf);
904: retcode := 2;
905: RETURN;
906: END IF;

Line 927: fnd_message.set_name ('IGF','IGF_AP_MATCHING_REC_NT_FND');

923: query_isir_records;
924:
925: -- Check whether any records found for processing for the query
926: IF g_total_recs_fetched = 0 THEN
927: fnd_message.set_name ('IGF','IGF_AP_MATCHING_REC_NT_FND');
928: errbuf := fnd_message.get;
929: fnd_file.put_line(fnd_file.log, errbuf);
930: retcode := 1;
931: RETURN;

Line 928: errbuf := fnd_message.get;

924:
925: -- Check whether any records found for processing for the query
926: IF g_total_recs_fetched = 0 THEN
927: fnd_message.set_name ('IGF','IGF_AP_MATCHING_REC_NT_FND');
928: errbuf := fnd_message.get;
929: fnd_file.put_line(fnd_file.log, errbuf);
930: retcode := 1;
931: RETURN;
932: END IF;

Line 965: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

961: EXCEPTION
962: WHEN others THEN
963: ROLLBACK;
964: retcode := 2;
965: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');
967: fnd_file.put_line(fnd_file.log,SQLERRM);
968: errbuf := fnd_message.get;
969: igs_ge_msg_stack.conc_exception_hndl;

Line 966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');

962: WHEN others THEN
963: ROLLBACK;
964: retcode := 2;
965: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');
967: fnd_file.put_line(fnd_file.log,SQLERRM);
968: errbuf := fnd_message.get;
969: igs_ge_msg_stack.conc_exception_hndl;
970: END main_import_process;

Line 968: errbuf := fnd_message.get;

964: retcode := 2;
965: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');
967: fnd_file.put_line(fnd_file.log,SQLERRM);
968: errbuf := fnd_message.get;
969: igs_ge_msg_stack.conc_exception_hndl;
970: END main_import_process;
971:
972:

Line 1316: fnd_message.set_name ('IGF',p_c_message);

1312:
1313: igf_gr_gen.update_current_ssn(cur_ISIR_rec.base_id,cur_ISIR_rec.current_ssn,p_c_message);
1314:
1315: IF p_c_message = 'IGF_GR_UPDT_SSN_FAIL' THEN
1316: fnd_message.set_name ('IGF',p_c_message);
1317: fnd_file.put_line(fnd_file.log,fnd_message.get);
1318: END IF;
1319: END LOOP;
1320: END IF;

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

1313: igf_gr_gen.update_current_ssn(cur_ISIR_rec.base_id,cur_ISIR_rec.current_ssn,p_c_message);
1314:
1315: IF p_c_message = 'IGF_GR_UPDT_SSN_FAIL' THEN
1316: fnd_message.set_name ('IGF',p_c_message);
1317: fnd_file.put_line(fnd_file.log,fnd_message.get);
1318: END IF;
1319: END LOOP;
1320: END IF;
1321:

Line 1324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1320: END IF;
1321:
1322: EXCEPTION
1323: WHEN others THEN
1324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1325: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_MATCHED_ISIR');
1326: fnd_file.put_line(fnd_file.log,SQLERRM);
1327: igs_ge_msg_stack.add;
1328: app_exception.raise_exception;

Line 1325: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_MATCHED_ISIR');

1321:
1322: EXCEPTION
1323: WHEN others THEN
1324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1325: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_MATCHED_ISIR');
1326: fnd_file.put_line(fnd_file.log,SQLERRM);
1327: igs_ge_msg_stack.add;
1328: app_exception.raise_exception;
1329: END update_matched_ISIR;

Line 1497: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1493: END LOOP;
1494: EXCEPTION
1495:
1496: WHEN others THEN
1497: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1498: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_FABASE');
1499: fnd_file.put_line(fnd_file.log,SQLERRM);
1500: igs_ge_msg_stack.add;
1501: app_exception.raise_exception;

Line 1498: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_FABASE');

1494: EXCEPTION
1495:
1496: WHEN others THEN
1497: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1498: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_FABASE');
1499: fnd_file.put_line(fnd_file.log,SQLERRM);
1500: igs_ge_msg_stack.add;
1501: app_exception.raise_exception;
1502:

Line 1546: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1542: END LOOP;
1543:
1544: EXCEPTION
1545: WHEN others THEN
1546: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1547: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_ISIR_CORR');
1548: fnd_file.put_line(fnd_file.log,SQLERRM);
1549: igs_ge_msg_stack.add;
1550: app_exception.raise_exception;

Line 1547: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_ISIR_CORR');

1543:
1544: EXCEPTION
1545: WHEN others THEN
1546: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1547: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_ISIR_CORR');
1548: fnd_file.put_line(fnd_file.log,SQLERRM);
1549: igs_ge_msg_stack.add;
1550: app_exception.raise_exception;
1551: END update_ISIR_corr;

Line 1636: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');

1632: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,
1633: x_sar_field_number => rec_ISIR_corr.sar_field_number,
1634: x_correction_status => 'ACKNOWLEDGED') THEN
1635: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'ACKNOWLEDGED');
1636: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');
1637: fnd_message.set_token('FIELD', lv_column_meaning);
1638: fnd_file.put_line(fnd_file.log,fnd_message.get);
1639: END IF;
1640:

Line 1637: fnd_message.set_token('FIELD', lv_column_meaning);

1633: x_sar_field_number => rec_ISIR_corr.sar_field_number,
1634: x_correction_status => 'ACKNOWLEDGED') THEN
1635: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'ACKNOWLEDGED');
1636: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');
1637: fnd_message.set_token('FIELD', lv_column_meaning);
1638: fnd_file.put_line(fnd_file.log,fnd_message.get);
1639: END IF;
1640:
1641: ELSE

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

1634: x_correction_status => 'ACKNOWLEDGED') THEN
1635: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'ACKNOWLEDGED');
1636: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');
1637: fnd_message.set_token('FIELD', lv_column_meaning);
1638: fnd_file.put_line(fnd_file.log,fnd_message.get);
1639: END IF;
1640:
1641: ELSE
1642: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,

Line 1647: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');

1643: x_sar_field_number => rec_ISIR_corr.sar_field_number,
1644: x_correction_status => 'READY') THEN
1645: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'READY');
1646: ln_count_corr := ln_count_corr + 1;
1647: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');
1648: fnd_message.set_token('FIELD', lv_column_meaning);
1649: fnd_file.put_line(fnd_file.log,fnd_message.get);
1650: END IF;
1651: END IF;

Line 1648: fnd_message.set_token('FIELD', lv_column_meaning);

1644: x_correction_status => 'READY') THEN
1645: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'READY');
1646: ln_count_corr := ln_count_corr + 1;
1647: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');
1648: fnd_message.set_token('FIELD', lv_column_meaning);
1649: fnd_file.put_line(fnd_file.log,fnd_message.get);
1650: END IF;
1651: END IF;
1652: END LOOP;

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

1645: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'READY');
1646: ln_count_corr := ln_count_corr + 1;
1647: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');
1648: fnd_message.set_token('FIELD', lv_column_meaning);
1649: fnd_file.put_line(fnd_file.log,fnd_message.get);
1650: END IF;
1651: END IF;
1652: END LOOP;
1653:

Line 1667: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1663: END LOOP;
1664:
1665: EXCEPTION
1666: WHEN others THEN
1667: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1668: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_CORRECTIONS');
1669: fnd_file.put_line(fnd_file.log,SQLERRM);
1670: igs_ge_msg_stack.add;
1671: app_exception.raise_exception;

Line 1668: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_CORRECTIONS');

1664:
1665: EXCEPTION
1666: WHEN others THEN
1667: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1668: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_CORRECTIONS');
1669: fnd_file.put_line(fnd_file.log,SQLERRM);
1670: igs_ge_msg_stack.add;
1671: app_exception.raise_exception;
1672: END validate_corrections;

Line 1714: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1710: CLOSE cur_get_name;
1711:
1712: EXCEPTION
1713: WHEN others THEN
1714: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1715: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.PREPARE_MESSAGE');
1716: fnd_file.put_line(fnd_file.log,SQLERRM);
1717: igs_ge_msg_stack.add;
1718: app_exception.raise_exception;

Line 1715: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.PREPARE_MESSAGE');

1711:
1712: EXCEPTION
1713: WHEN others THEN
1714: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1715: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.PREPARE_MESSAGE');
1716: fnd_file.put_line(fnd_file.log,SQLERRM);
1717: igs_ge_msg_stack.add;
1718: app_exception.raise_exception;
1719: END prepare_message;

Line 1801: fnd_message.set_name ( 'IGF','IGF_AP_NO_DATA_FOUND');

1797: END IF;
1798:
1799: IF l_cnt = 0 THEN
1800:
1801: fnd_message.set_name ( 'IGF','IGF_AP_NO_DATA_FOUND');
1802: document := fnd_message.get;
1803: ELSE
1804:
1805: OPEN cur_get_data;

Line 1802: document := fnd_message.get;

1798:
1799: IF l_cnt = 0 THEN
1800:
1801: fnd_message.set_name ( 'IGF','IGF_AP_NO_DATA_FOUND');
1802: document := fnd_message.get;
1803: ELSE
1804:
1805: OPEN cur_get_data;
1806: LOOP

Line 1829: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1825: END IF;
1826:
1827: EXCEPTION
1828: WHEN others THEN
1829: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1830: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE');
1831: fnd_file.put_line(fnd_file.log,SQLERRM);
1832: igs_ge_msg_stack.add;
1833: app_exception.raise_exception;

Line 1830: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE');

1826:
1827: EXCEPTION
1828: WHEN others THEN
1829: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1830: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE');
1831: fnd_file.put_line(fnd_file.log,SQLERRM);
1832: igs_ge_msg_stack.add;
1833: app_exception.raise_exception;
1834: END create_message;

Line 1910: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1906: wf_engine.createprocess('OUTCORR',l_item_key,'NOTIFY');
1907: wf_engine.startprocess('OUTCORR',l_item_key);
1908: EXCEPTION
1909: WHEN others THEN
1910: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1911: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SEND_MESSAGE');
1912: fnd_file.put_line(fnd_file.log,SQLERRM);
1913: igs_ge_msg_stack.add;
1914: app_exception.raise_exception;

Line 1911: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SEND_MESSAGE');

1907: wf_engine.startprocess('OUTCORR',l_item_key);
1908: EXCEPTION
1909: WHEN others THEN
1910: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1911: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SEND_MESSAGE');
1912: fnd_file.put_line(fnd_file.log,SQLERRM);
1913: igs_ge_msg_stack.add;
1914: app_exception.raise_exception;
1915: END send_message;