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

Line 310: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');

306:
307: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
308: l_chk_profile := igf_ap_gen.check_profile;
309: IF l_chk_profile = 'N' THEN
310: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
311: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
312: RETURN;
313: END IF;
314:

Line 311: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

307: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
308: l_chk_profile := igf_ap_gen.check_profile;
309: IF l_chk_profile = 'N' THEN
310: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
311: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
312: RETURN;
313: END IF;
314:
315: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'BASE');

Line 317: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');

313: END IF;
314:
315: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'BASE');
316: IF l_chk_batch = 'N' THEN
317: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
318: add_log_table_process(NULL,l_error,fnd_message.get);
319: l_terminate_flag := TRUE;
320: END IF;
321: -- this is to get the alternate code

Line 318: add_log_table_process(NULL,l_error,fnd_message.get);

314:
315: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'BASE');
316: IF l_chk_batch = 'N' THEN
317: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
318: add_log_table_process(NULL,l_error,fnd_message.get);
319: l_terminate_flag := TRUE;
320: END IF;
321: -- this is to get the alternate code
322: l_get_alternate_code := NULL;

Line 334: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');

330: FETCH c_get_status INTO l_get_status;
331: CLOSE c_get_status;
332:
333: IF l_get_status.award_year_status_code IS NULL OR l_get_status.award_year_status_code IN ('C') THEN
334: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
335: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);
336: add_log_table_process(NULL,l_error,fnd_message.get);
337: l_terminate_flag := TRUE;
338: END IF;

Line 335: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);

331: CLOSE c_get_status;
332:
333: IF l_get_status.award_year_status_code IS NULL OR l_get_status.award_year_status_code IN ('C') THEN
334: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
335: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);
336: add_log_table_process(NULL,l_error,fnd_message.get);
337: l_terminate_flag := TRUE;
338: END IF;
339:

Line 336: add_log_table_process(NULL,l_error,fnd_message.get);

332:
333: IF l_get_status.award_year_status_code IS NULL OR l_get_status.award_year_status_code IN ('C') THEN
334: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
335: fnd_message.set_token('AWARD_STATUS',l_get_status.award_year_status_code);
336: add_log_table_process(NULL,l_error,fnd_message.get);
337: l_terminate_flag := TRUE;
338: END IF;
339:
340: IF l_terminate_flag = TRUE THEN

Line 372: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

368: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','lv_base_id:'||lv_base_id);
369: END IF;
370:
371: IF lv_person_id IS NULL THEN
372: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
373: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
374: l_error_flag := TRUE;
375: ELSE
376: IF lv_base_id IS NULL THEN

Line 373: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

369: END IF;
370:
371: IF lv_person_id IS NULL THEN
372: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
373: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
374: l_error_flag := TRUE;
375: ELSE
376: IF lv_base_id IS NULL THEN
377: l_create_flag := TRUE;

Line 395: fnd_message.set_name('IGF','IGF_AP_LI_APS_DT_INVALID');

391:
392: -- HERE ALL THE VALIDATIONS TO BE DONE AT ONE GO
393: -- VALIDATION FOR THE AWARD PROCESS STATUS DATE
394: IF l_get_records.award_process_status_date IS NOT NULL AND l_get_records.award_process_status_date > TRUNC(SYSDATE) THEN
395: fnd_message.set_name('IGF','IGF_AP_LI_APS_DT_INVALID');
396: fnd_message.set_token('APS_DT',l_get_records.award_process_status_date);
397: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
398: l_error_flag := TRUE;
399: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 396: fnd_message.set_token('APS_DT',l_get_records.award_process_status_date);

392: -- HERE ALL THE VALIDATIONS TO BE DONE AT ONE GO
393: -- VALIDATION FOR THE AWARD PROCESS STATUS DATE
394: IF l_get_records.award_process_status_date IS NOT NULL AND l_get_records.award_process_status_date > TRUNC(SYSDATE) THEN
395: fnd_message.set_name('IGF','IGF_AP_LI_APS_DT_INVALID');
396: fnd_message.set_token('APS_DT',l_get_records.award_process_status_date);
397: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
398: l_error_flag := TRUE;
399: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Award process status date is invalid');

Line 397: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

393: -- VALIDATION FOR THE AWARD PROCESS STATUS DATE
394: IF l_get_records.award_process_status_date IS NOT NULL AND l_get_records.award_process_status_date > TRUNC(SYSDATE) THEN
395: fnd_message.set_name('IGF','IGF_AP_LI_APS_DT_INVALID');
396: fnd_message.set_token('APS_DT',l_get_records.award_process_status_date);
397: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
398: l_error_flag := TRUE;
399: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Award process status date is invalid');
401: END IF;

Line 406: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

402: END IF;
403:
404: -- VALIDATION FOR THE AWARD NOTIFICATION STATUS NULL IS ALSO VALID
405: IF NVL(l_get_records.award_notify_status,'S') NOT IN ('S','R','D') THEN
406: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
407: fnd_message.set_token('FIELD','AWARD_NOTIFY_STATUS');
408: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
409: l_error_flag := TRUE;
410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 407: fnd_message.set_token('FIELD','AWARD_NOTIFY_STATUS');

403:
404: -- VALIDATION FOR THE AWARD NOTIFICATION STATUS NULL IS ALSO VALID
405: IF NVL(l_get_records.award_notify_status,'S') NOT IN ('S','R','D') THEN
406: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
407: fnd_message.set_token('FIELD','AWARD_NOTIFY_STATUS');
408: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
409: l_error_flag := TRUE;
410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Award notification status is invalid');

Line 408: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

404: -- VALIDATION FOR THE AWARD NOTIFICATION STATUS NULL IS ALSO VALID
405: IF NVL(l_get_records.award_notify_status,'S') NOT IN ('S','R','D') THEN
406: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
407: fnd_message.set_token('FIELD','AWARD_NOTIFY_STATUS');
408: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
409: l_error_flag := TRUE;
410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Award notification status is invalid');
412: END IF;

Line 417: fnd_message.set_name('IGF','IGF_AP_LI_ANS_DT_INVALID');

413: END IF;
414:
415: -- VALIDATION FOR AWARD NOTIFICATION STATUS DATE
416: IF l_get_records.award_notify_status_date IS NOT NULL AND l_get_records.award_notify_status_date > TRUNC(SYSDATE) THEN
417: fnd_message.set_name('IGF','IGF_AP_LI_ANS_DT_INVALID');
418: fnd_message.set_token('AWD_NOT_STAT_DT',l_get_records.award_notify_status_date);
419: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
420: l_error_flag := TRUE;
421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 418: fnd_message.set_token('AWD_NOT_STAT_DT',l_get_records.award_notify_status_date);

414:
415: -- VALIDATION FOR AWARD NOTIFICATION STATUS DATE
416: IF l_get_records.award_notify_status_date IS NOT NULL AND l_get_records.award_notify_status_date > TRUNC(SYSDATE) THEN
417: fnd_message.set_name('IGF','IGF_AP_LI_ANS_DT_INVALID');
418: fnd_message.set_token('AWD_NOT_STAT_DT',l_get_records.award_notify_status_date);
419: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
420: l_error_flag := TRUE;
421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Award notification status date in invalid');

Line 419: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

415: -- VALIDATION FOR AWARD NOTIFICATION STATUS DATE
416: IF l_get_records.award_notify_status_date IS NOT NULL AND l_get_records.award_notify_status_date > TRUNC(SYSDATE) THEN
417: fnd_message.set_name('IGF','IGF_AP_LI_ANS_DT_INVALID');
418: fnd_message.set_token('AWD_NOT_STAT_DT',l_get_records.award_notify_status_date);
419: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
420: l_error_flag := TRUE;
421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Award notification status date in invalid');
423: END IF;

Line 432: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

428: END IF;
429:
430: -- VALIDATION FOR OVERRIDE NSLDS DEFAULT
431: IF NVL(l_get_records.override_nslds_flag,'X') NOT IN ('Y','N') THEN
432: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
433: fnd_message.set_token('FIELD','OVERRIDE_NSLDS_FLAG');
434: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
435: l_error_flag := TRUE;
436: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 433: fnd_message.set_token('FIELD','OVERRIDE_NSLDS_FLAG');

429:
430: -- VALIDATION FOR OVERRIDE NSLDS DEFAULT
431: IF NVL(l_get_records.override_nslds_flag,'X') NOT IN ('Y','N') THEN
432: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
433: fnd_message.set_token('FIELD','OVERRIDE_NSLDS_FLAG');
434: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
435: l_error_flag := TRUE;
436: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
437: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Override NSLDS flag value is invalid');

Line 434: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

430: -- VALIDATION FOR OVERRIDE NSLDS DEFAULT
431: IF NVL(l_get_records.override_nslds_flag,'X') NOT IN ('Y','N') THEN
432: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
433: fnd_message.set_token('FIELD','OVERRIDE_NSLDS_FLAG');
434: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
435: l_error_flag := TRUE;
436: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
437: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Override NSLDS flag value is invalid');
438: END IF;

Line 443: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

439: END IF;
440:
441: -- VALIDATION FOR PROFESSIONAL JUDGEMENT
442: IF NVL(l_get_records.professional_judgment_flag,'X') NOT IN ('Y','N') THEN
443: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
444: fnd_message.set_token('FIELD','PROFESSIONAL_JUDGMENT_FLAG');
445: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
446: l_error_flag := TRUE;
447: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 444: fnd_message.set_token('FIELD','PROFESSIONAL_JUDGMENT_FLAG');

440:
441: -- VALIDATION FOR PROFESSIONAL JUDGEMENT
442: IF NVL(l_get_records.professional_judgment_flag,'X') NOT IN ('Y','N') THEN
443: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
444: fnd_message.set_token('FIELD','PROFESSIONAL_JUDGMENT_FLAG');
445: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
446: l_error_flag := TRUE;
447: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
448: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Professional Judgement flag value is invalid');

Line 445: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

441: -- VALIDATION FOR PROFESSIONAL JUDGEMENT
442: IF NVL(l_get_records.professional_judgment_flag,'X') NOT IN ('Y','N') THEN
443: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
444: fnd_message.set_token('FIELD','PROFESSIONAL_JUDGMENT_FLAG');
445: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
446: l_error_flag := TRUE;
447: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
448: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Professional Judgement flag value is invalid');
449: END IF;

Line 458: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

454: END IF;
455:
456: -- VALIDATION FOR VERIFICATION HOLD ON DISBURSEMENT
457: IF NVL(l_get_records.disburse_verification_hold,'X') NOT IN ('Y','N') THEN
458: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
459: fnd_message.set_token('FIELD','DISBURSE_VERIFICATION_HOLD');
460: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
461: l_error_flag := TRUE;
462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 459: fnd_message.set_token('FIELD','DISBURSE_VERIFICATION_HOLD');

455:
456: -- VALIDATION FOR VERIFICATION HOLD ON DISBURSEMENT
457: IF NVL(l_get_records.disburse_verification_hold,'X') NOT IN ('Y','N') THEN
458: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
459: fnd_message.set_token('FIELD','DISBURSE_VERIFICATION_HOLD');
460: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
461: l_error_flag := TRUE;
462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Disburse verification flag value is invalid');

Line 460: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

456: -- VALIDATION FOR VERIFICATION HOLD ON DISBURSEMENT
457: IF NVL(l_get_records.disburse_verification_hold,'X') NOT IN ('Y','N') THEN
458: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
459: fnd_message.set_token('FIELD','DISBURSE_VERIFICATION_HOLD');
460: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
461: l_error_flag := TRUE;
462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','Disburse verification flag value is invalid');
464: END IF;

Line 469: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

465: END IF;
466:
467: -- VALIDATION FOR AWARD PROCESS STATUS NULL IS ALSO VALID
468: IF NVL(l_get_records.award_process_status_code,'REVISED') NOT IN ('REVISED','AUTO_PACKAGED') THEN
469: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
470: fnd_message.set_token('FIELD','AWARD_PROCESS_STATUS_CODE');
471: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
472: l_error_flag := TRUE;
473: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 470: fnd_message.set_token('FIELD','AWARD_PROCESS_STATUS_CODE');

466:
467: -- VALIDATION FOR AWARD PROCESS STATUS NULL IS ALSO VALID
468: IF NVL(l_get_records.award_process_status_code,'REVISED') NOT IN ('REVISED','AUTO_PACKAGED') THEN
469: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
470: fnd_message.set_token('FIELD','AWARD_PROCESS_STATUS_CODE');
471: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
472: l_error_flag := TRUE;
473: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','award process status is invalid');

Line 471: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

467: -- VALIDATION FOR AWARD PROCESS STATUS NULL IS ALSO VALID
468: IF NVL(l_get_records.award_process_status_code,'REVISED') NOT IN ('REVISED','AUTO_PACKAGED') THEN
469: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
470: fnd_message.set_token('FIELD','AWARD_PROCESS_STATUS_CODE');
471: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
472: l_error_flag := TRUE;
473: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','award process status is invalid');
475: END IF;

Line 653: fnd_message.set_name('IGF','IGF_AP_SSN_REQD');

649: OPEN ssn_cur(lv_person_id) ;
650: FETCH ssn_cur INTO rec_ssn_cur;
651: IF ssn_cur%NOTFOUND THEN
652: CLOSE ssn_cur;
653: fnd_message.set_name('IGF','IGF_AP_SSN_REQD');
654: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
655: l_create_base_rec := FALSE;
656: l_error_flag := FALSE;
657: ELSE

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

650: FETCH ssn_cur INTO rec_ssn_cur;
651: IF ssn_cur%NOTFOUND THEN
652: CLOSE ssn_cur;
653: fnd_message.set_name('IGF','IGF_AP_SSN_REQD');
654: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
655: l_create_base_rec := FALSE;
656: l_error_flag := FALSE;
657: ELSE
658: CLOSE ssn_cur;

Line 786: fnd_message.set_name('IGS','IGS_EN_LGCY_SUCCESS');

782: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_base_id:'||l_base_id);
784: END IF;
785: END IF;
786: fnd_message.set_name('IGS','IGS_EN_LGCY_SUCCESS');
787: add_log_table_process(l_get_records.person_number,' ',fnd_message.get);
788: l_success_record_cnt := l_success_record_cnt + 1;
789: END IF; -- ERROR FLAG CHECK
790:

Line 787: add_log_table_process(l_get_records.person_number,' ',fnd_message.get);

783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','l_base_id:'||l_base_id);
784: END IF;
785: END IF;
786: fnd_message.set_name('IGS','IGS_EN_LGCY_SUCCESS');
787: add_log_table_process(l_get_records.person_number,' ',fnd_message.get);
788: l_success_record_cnt := l_success_record_cnt + 1;
789: END IF; -- ERROR FLAG CHECK
790:
791:

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

838: EXCEPTION
839: WHEN others THEN
840: l_debug_str := NULL;
841: l_error_flag := FALSE;
842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
843: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');
844: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
845: ROLLBACK TO sp1;
846: END;

Line 843: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');

839: WHEN others THEN
840: l_debug_str := NULL;
841: l_error_flag := FALSE;
842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
843: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');
844: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
845: ROLLBACK TO sp1;
846: END;
847: COMMIT;

Line 844: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);

840: l_debug_str := NULL;
841: l_error_flag := FALSE;
842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
843: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');
844: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
845: ROLLBACK TO sp1;
846: END;
847: COMMIT;
848: END LOOP;

Line 852: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');

848: END LOOP;
849: CLOSE c_get_records;
850:
851: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
852: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
853: add_log_table_process(NULL,l_error,fnd_message.get);
854: END IF;
855:
856: -- CALL THE PRINT LOG PROCESS

Line 853: add_log_table_process(NULL,l_error,fnd_message.get);

849: CLOSE c_get_records;
850:
851: IF l_success_record_cnt = 0 AND l_error_record_cnt = 0 THEN
852: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
853: add_log_table_process(NULL,l_error,fnd_message.get);
854: END IF;
855:
856: -- CALL THE PRINT LOG PROCESS
857: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind,l_get_status.award_year_status_code);

Line 860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');

856: -- CALL THE PRINT LOG PROCESS
857: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind,l_get_status.award_year_status_code);
858:
859: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

Line 861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);

857: print_log_process(l_get_alternate_code.alternate_code,p_batch_id,p_del_ind,l_get_status.award_year_status_code);
858:
859: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

Line 862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');

858:
859: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
866: EXCEPTION

Line 863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);

859: l_total_record_cnt := l_success_record_cnt + l_error_record_cnt;
860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
866: EXCEPTION
867: WHEN others THEN

Line 864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

860: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
866: EXCEPTION
867: WHEN others THEN
868: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);

861: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' ' || l_total_record_cnt);
862: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
863: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_success_record_cnt);
864: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
865: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_error_record_cnt);
866: EXCEPTION
867: WHEN others THEN
868: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_ap_li_base_rec_import.main.exception',SQLERRM);

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

867: WHEN others THEN
868: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_ap_li_base_rec_import.main.exception',SQLERRM);
870: END IF;
871: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
872: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');
873: errbuf := fnd_message.get;
874: igs_ge_msg_stack.conc_exception_hndl;
875:

Line 872: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');

868: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
869: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_ap_li_base_rec_import.main.exception',SQLERRM);
870: END IF;
871: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
872: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');
873: errbuf := fnd_message.get;
874: igs_ge_msg_stack.conc_exception_hndl;
875:
876: END main;

Line 873: errbuf := fnd_message.get;

869: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_ap_li_base_rec_import.main.exception',SQLERRM);
870: END IF;
871: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
872: fnd_message.set_token('NAME','IGF_AP_LI_BASE_REC_IMPORT.MAIN');
873: errbuf := fnd_message.get;
874: igs_ge_msg_stack.conc_exception_hndl;
875:
876: END main;
877:

Line 963: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');

959: FOR i IN 1..l_count LOOP
960: IF g_log_tab(i).person_number IS NOT NULL THEN
961: IF l_old_person <> g_log_tab(i).person_number THEN
962: IF i <> 1 AND l_print_message_flag THEN
963: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
964: fnd_file.put_line(fnd_file.log,fnd_message.get);
965: END IF;
966: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
967: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);

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

960: IF g_log_tab(i).person_number IS NOT NULL THEN
961: IF l_old_person <> g_log_tab(i).person_number THEN
962: IF i <> 1 AND l_print_message_flag THEN
963: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
964: fnd_file.put_line(fnd_file.log,fnd_message.get);
965: END IF;
966: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------------');
967: fnd_file.put_line(fnd_file.log,l_person_number || ' : ' || g_log_tab(i).person_number);
968:

Line 979: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');

975: l_print_message_flag := FALSE;
976: END IF;
977: END LOOP;
978: IF l_print_message_flag THEN
979: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
980: fnd_file.put_line(fnd_file.log,fnd_message.get);
981: END IF;
982:
983: END print_log_process;

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

976: END IF;
977: END LOOP;
978: IF l_print_message_flag THEN
979: fnd_message.set_name('IGF','IGF_AW_LI_SKIPPING_AWD');
980: fnd_file.put_line(fnd_file.log,fnd_message.get);
981: END IF;
982:
983: END print_log_process;
984: