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_MATCHING_PROCESS_PKG dependencies on FND_FILE

Line 96: -- fnd_file.put_line(fnd_file.log, m);

92:
93: BEGIN
94: IF g_enable_debug_logging = 'Y' THEN
95: g_debug_seq := g_debug_seq + 1;
96: -- fnd_file.put_line(fnd_file.log, m);
97: -- INSERT INTO RAN_DEBUG values (g_debug_seq,m);
98:
99: END IF;
100: END log_debug_message;

Line 212: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

208:
209: RETURN NULL;
210: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
211: igs_ge_msg_stack.add;
212: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215:
216: END get_msg_class_from_filename;

Line 253: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

249: END IF;
250:
251: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
252: igs_ge_msg_stack.add;
253: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END is_payment_isir;
257:

Line 393: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

389: END IF;
390:
391: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
392: igs_ge_msg_stack.add;
393: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END process_todo_items;
397:

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

441:
442: RAM_U_R := RAM_U_R + 1;
443: fnd_message.set_name('IGF','IGF_AP_ISIR_REC_STATUS');
444: fnd_message.set_token('STATUS',p_isir_rec_status);
445: fnd_file.put_line(fnd_file.log, fnd_message.get);
446: END IF;
447:
448: EXCEPTION
449: WHEN OTHERS THEN

Line 456: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

452: END IF;
453:
454: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
455: igs_ge_msg_stack.add;
456: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END update_isir_int_record;
460:

Line 625: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

621: END IF;
622:
623: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
624: igs_ge_msg_stack.add;
625: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
626: igs_ge_msg_stack.add;
627: app_exception.raise_exception;
628: END update_fa_base_rec;
629:

Line 971: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

967: END IF;
968:
969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
970: igs_ge_msg_stack.add;
971: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
972: igs_ge_msg_stack.add;
973: app_exception.raise_exception;
974: END update_isir_matched_rec;
975:

Line 1388: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1384: END IF;
1385:
1386: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1387: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_isir_matched_rec');
1388: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1389: igs_ge_msg_stack.add;
1390: app_exception.raise_exception;
1391: END insert_isir_matched_rec;
1392:

Line 1640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1636: END IF;
1637:
1638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_nslds_data_rec');
1640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1641: igs_ge_msg_stack.add;
1642: app_exception.raise_exception;
1643: END insert_nslds_data_rec;
1644:

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

1882:
1883:
1884: IF pn_base_id IS NULL THEN
1885: fnd_message.set_name ('IGF', 'IGF_AP_ERR_FA_REC');
1886: fnd_file.put_line(fnd_file.log,fnd_message.get );
1887: app_exception.raise_exception;
1888: END IF;
1889:
1890: log_debug_message(' Successfully inserted FA Base Record. Base ID: ' || pn_base_id);

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

1894:
1895: g_base_id := pn_base_id; -- populate global variable
1896:
1897: fnd_message.set_name('IGF','IGF_AP_ISIR_FA_BASE_CREATED');
1898: fnd_file.put_line(fnd_file.log, fnd_message.get);
1899: RAM_I_F := RAM_I_F + 1;
1900:
1901: EXCEPTION
1902: WHEN others THEN

Line 1908: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

1904: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_fa_base_record.exception','The exception is : ' || SQLERRM );
1905: END IF;
1906: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1907: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_fa_base_record');
1908: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1909: igs_ge_msg_stack.add;
1910: app_exception.raise_exception;
1911: END insert_fa_base_record;
1912:

Line 2020: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

2016: END IF;
2017:
2018: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2019: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.update_prsn_match_rec_status');
2020: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2021: igs_ge_msg_stack.add;
2022: app_exception.raise_exception;
2023: END update_prsn_match_rec_status;
2024:

Line 2154: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

2150:
2151: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2152: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.raise_cps_pushed_isir_event');
2153: igs_ge_msg_stack.add;
2154: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
2155: RAISE;
2156: END raise_cps_pushed_isir_event;
2157:
2158:

Line 2299: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

2295:
2296: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2297: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.raise_demographic_chng_event');
2298: igs_ge_msg_stack.add;
2299: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
2300: RAISE;
2301: END raise_demographic_chng_event;
2302:
2303: PROCEDURE create_updt_email_address(p_person_id NUMBER)

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

2384: IF UPPER(l_chk_email.email_address) <> UPPER(g_isir_intrface_rec.s_email_address_txt) THEN
2385: -- Email in ISIR is different from that in the Person record. Log the email id
2386: fnd_message.set_name('IGF','IGF_AP_ISIR_EMAIL_NTFND');
2387: fnd_message.set_token('EMAIL_ID', g_isir_intrface_rec.s_email_address_txt);
2388: fnd_file.put_line(fnd_file.log, fnd_message.get);
2389: END IF;
2390:
2391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2392: fnd_log.string(fnd_log.level_statement,

Line 2436: fnd_file.put_line(FND_FILE.LOG ,l_msg_data||fnd_global.newline ||'STATUS:'||l_return_status);

2432: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.exception','The exception is : ' || SQLERRM );
2433: END IF;
2434: ROLLBACK TO email_SP1;
2435:
2436: fnd_file.put_line(FND_FILE.LOG ,l_msg_data||fnd_global.newline ||'STATUS:'||l_return_status);
2437: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2438: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_updt_email_address');
2439: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2440: igs_ge_msg_stack.add;

Line 2439: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

2435:
2436: fnd_file.put_line(FND_FILE.LOG ,l_msg_data||fnd_global.newline ||'STATUS:'||l_return_status);
2437: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2438: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_updt_email_address');
2439: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2440: igs_ge_msg_stack.add;
2441: END create_updt_email_address;
2442:
2443: PROCEDURE update_person_info (pn_isir_id igf_ap_isir_matched.isir_id%TYPE)

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

2601: FETCH person_id_type_cur INTO lv_person_id_type;
2602:
2603: IF person_id_type_cur%NOTFOUND THEN
2604: fnd_message.set_name ('IGF','IGF_AP_PER_ID_NOT_SET');
2605: fnd_file.put_line ( FND_FILE.LOG, fnd_message.get);
2606: END IF;
2607: CLOSE person_id_type_cur;
2608:
2609:

Line 2715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

2711: END IF;
2712:
2713: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2714: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.update_person_info');
2715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2716: igs_ge_msg_stack.add;
2717: app_exception.raise_exception;
2718: END update_person_info;
2719:

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

2913: fnd_message.set_name('IGF','IGF_AP_FED_NOT_IN_SYSTEM');
2914: fnd_message.set_token('FEDCODE',l_college_code);
2915: END IF;
2916:
2917: fnd_file.put_line(fnd_file.log, fnd_message.get);
2918:
2919: l_transaction_num := g_isir_intrface_rec.original_ssn_txt||g_isir_intrface_rec.orig_name_id_txt||g_isir_intrface_rec.transaction_num_txt;
2920:
2921: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2948: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

2944: END IF;
2945:
2946: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2947: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.validate_correction_school');
2948: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2949: igs_ge_msg_stack.add;
2950: app_exception.raise_exception;
2951: END validate_correction_school;
2952:

Line 3052: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

3048:
3049: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3050: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.delete_person_match_rec' );
3051: igs_ge_msg_stack.add;
3052: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
3053: app_exception.raise_exception;
3054: END delete_person_match_rec;
3055:
3056:

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

3110: IF cur_adm_cal_conf%NOTFOUND THEN
3111: CLOSE cur_adm_cal_conf;
3112:
3113: fnd_message.set_name('IGF','IGF_AP_NO_DEF_ADM_CAL');
3114: fnd_file.put_line(fnd_file.log,fnd_message.get );
3115: app_exception.raise_exception;
3116: END IF;
3117: CLOSE cur_adm_cal_conf;
3118:

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

3131:
3132: IF l_message IS NOT NULL THEN
3133: fnd_message.set_name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');
3134: fnd_message.set_token('CAL_TYPE', l_inq_cal_type);
3135: fnd_file.put_line(fnd_file.log,fnd_message.get);
3136: RETURN;
3137: END IF;
3138:
3139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3211: USING p_person_id, l_acad_cal_type, l_acad_seq, l_inq_cal_type, l_adm_seq,
3212: g_adm_source_type, OUT lv_return_status, OUT lv_msg_data, OUT lv_msg_count;
3213: ELSE
3214: FND_MESSAGE.Set_Name('IGS', 'IGS_AD_INQ_NOT_CRT');
3215: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3216: END IF; -- IGS Recruiting User
3217:
3218: log_debug_message('Created Admission Inquiry record. Status : ' || lv_return_status);
3219: RAM_I_HZ := RAM_I_HZ + 1;

Line 3227: fnd_file.put_line(fnd_file.log,fnd_msg_pub.get(p_encoded => fnd_api.g_false));

3223:
3224: IF lv_return_status IN ('E','U') THEN
3225:
3226: FOR i IN 1..lv_msg_count LOOP
3227: fnd_file.put_line(fnd_file.log,fnd_msg_pub.get(p_encoded => fnd_api.g_false));
3228: END LOOP;
3229:
3230: ELSE
3231: fnd_message.set_name('IGF','IGF_AP_ISIR_ADM_REC');

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

3228: END LOOP;
3229:
3230: ELSE
3231: fnd_message.set_name('IGF','IGF_AP_ISIR_ADM_REC');
3232: fnd_file.put_line(fnd_file.log,fnd_message.get);
3233: END IF;
3234:
3235: END IF; -- g_create_inquiry
3236:

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

3272:
3273: ELSE
3274: CLOSE cur_person_type;
3275: fnd_message.set_name('IGF','IGF_AP_NO_PERSON_TYPE');
3276: fnd_file.put_line(fnd_file.log,fnd_message.get);
3277: END IF;
3278:
3279: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3280: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Completed create_admission_rec procedure successfully');

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

3295: END IF;
3296:
3297: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3298: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.create_admission_rec');
3299: fnd_file.put_line(fnd_file.log,fnd_message.get );
3300: igs_ge_msg_stack.add;
3301: END create_admission_rec;
3302:
3303:

Line 3369: fnd_file.put_line(fnd_file.log, pv_mesg_data); -- log the msg in log file.

3365: fnd_message.set_name('IGF','IGF_AP_PER_ID_NOT_SET');
3366: pv_mesg_data := fnd_message.get;
3367:
3368: IF p_called_from = 'PLSQL' THEN
3369: fnd_file.put_line(fnd_file.log, pv_mesg_data); -- log the msg in log file.
3370: END IF;
3371: CLOSE person_id_type_cur;
3372:
3373: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3465: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' || igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER') || ':' || ln_person_number);

3461: RAM_I_HZ := RAM_I_HZ + 1;
3462: IF lv_return_status = 'S' THEN
3463: fnd_message.set_name('IGF','IGF_AP_ISIR_CREATE_PERSON');
3464: g_person_id := pn_person_id; -- populate into global variable.
3465: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' || igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER') || ':' || ln_person_number);
3466:
3467: ELSE -- error creating person
3468:
3469: log_debug_message(' Error Creating Person. Status ' || lv_return_status || ' Msg:' || lv_msg_data);

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

3611:
3612: RAM_I_HZ := RAM_I_HZ + 1;
3613: IF lv_return_status = 'S' THEN
3614: fnd_message.set_name('IGF','IGF_AP_ISIR_PER_ADD');
3615: fnd_file.put_line(fnd_file.log, fnd_message.get);
3616: ELSIF lv_return_status = 'W' THEN
3617: -- bug 5348743
3618: fnd_file.put_line(fnd_file.log, lv_msg_data);
3619: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3618: fnd_file.put_line(fnd_file.log, lv_msg_data);

3614: fnd_message.set_name('IGF','IGF_AP_ISIR_PER_ADD');
3615: fnd_file.put_line(fnd_file.log, fnd_message.get);
3616: ELSIF lv_return_status = 'W' THEN
3617: -- bug 5348743
3618: fnd_file.put_line(fnd_file.log, lv_msg_data);
3619: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3620: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.debug','Completed Address creation returned status warning : ' || lv_return_status);
3621: END IF;
3622: ELSE

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

3620: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.debug','Completed Address creation returned status warning : ' || lv_return_status);
3621: END IF;
3622: ELSE
3623: fnd_message.set_name('IGS','IGS_AD_CRT_ADDR_FAILED');
3624: fnd_file.put_line(fnd_file.log, fnd_message.get);
3625: END IF;
3626:
3627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.debug','Completed Address creation returned status : ' || lv_return_status);

Line 3637: fnd_file.put_line(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'STATUS:'||lv_return_status);

3633: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3634: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );
3635: END IF;
3636:
3637: fnd_file.put_line(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'STATUS:'||lv_return_status);
3638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_person_addr_record');
3640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3641: igs_ge_msg_stack.add;

Line 3640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3636:
3637: fnd_file.put_line(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'STATUS:'||lv_return_status);
3638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_person_addr_record');
3640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3641: igs_ge_msg_stack.add;
3642: END create_person_addr_record;
3643:
3644:

Line 3814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3810: END IF;
3811:
3812: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3813: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.auto_fa_rec');
3814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3815: igs_ge_msg_stack.add;
3816: app_exception.raise_exception;
3817: END auto_fa_rec;
3818:

Line 3863: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

3859: END IF;
3860:
3861: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3862: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.rvw_fa_rec');
3863: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3864: igs_ge_msg_stack.add;
3865: app_exception.raise_exception;
3866: END rvw_fa_rec ;
3867:

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

3904:
3905:
3906: log_debug_message('Person Created.... ID= ' || lv_person_id);
3907: fnd_message.set_name('IGF','IGF_AP_SUCCESS_CREATE_PERSON');
3908: fnd_file.put_line(fnd_file.log, fnd_message.get);
3909:
3910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3911: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Person Created. Person ID :' || lv_person_id || ', p_msg_out :' || p_msg_out );
3912: END IF;

Line 4024: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

4020: END IF;
4021:
4022: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4023: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.unmatched_rec');
4024: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
4025: igs_ge_msg_stack.add;
4026: app_exception.raise_exception;
4027: END unmatched_rec ;
4028:

Line 4373: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

4369:
4370: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4371: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.calculate_match_score' );
4372: igs_ge_msg_stack.add;
4373: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4374: app_exception.raise_exception;
4375: END calculate_match_score;
4376:
4377:

Line 4651: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

4647:
4648: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4649: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.perform_record_matching' );
4650: igs_ge_msg_stack.add;
4651: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4652: app_exception.raise_exception;
4653: END perform_record_matching ;
4654:
4655:

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

4840: p_seq_num => g_ci_sequence_number
4841: );
4842:
4843: fnd_message.set_name('IGF','IGF_AP_ISIR_AUTO_FA');
4844: fnd_file.put_line(fnd_file.log, fnd_message.get);
4845: END IF;
4846:
4847: CLOSE c_base_id;
4848: ELSIF ln_match_score >= g_setup_score.min_score_rvw_fa THEN

Line 4894: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

4890:
4891: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4892: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_unidentified_isir_rec');
4893: igs_ge_msg_stack.add;
4894: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4895: app_exception.raise_exception;
4896: END process_unidentified_isir_rec;
4897:
4898: /* Added as a part of Bug 4403807

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

6493: END IF;
6494:
6495: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');
6496: fnd_message.set_token('FIELD', isir_corr_rec.column_name);
6497: fnd_file.put_line(fnd_file.log,fnd_message.get);
6498:
6499: ELSE
6500: -- Set the flag that there are still corrections.
6501: lv_all_corr_rcvd := 'N' ;

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

6521:
6522: g_count_corr := g_count_corr + 1;
6523: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');
6524: fnd_message.set_token('FIELD', isir_corr_rec.column_name);
6525: fnd_file.put_line(fnd_file.log,fnd_message.get);
6526: END IF;
6527:
6528: -- Column found and updated hence exit and move to next correction
6529: EXIT;

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

6639: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.exception','The exception is : ' || SQLERRM );
6640: END IF;
6641: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6642: fnd_message.set_token('NAME','PROCESS_ISIR_RECEIPT.PROCESS_CORRECTIONS');
6643: fnd_file.put_line(fnd_file.log,fnd_message.get);
6644: igs_ge_msg_stack.add;
6645:
6646: lv_param_values := TO_CHAR(g_Base_Id)||','|| TO_CHAR(p_new_isir_id);
6647:

Line 6650: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

6646: lv_param_values := TO_CHAR(g_Base_Id)||','|| TO_CHAR(p_new_isir_id);
6647:
6648: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
6649: fnd_message.set_token('VALUE',lv_param_values);
6650: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
6651: igs_ge_msg_stack.add;
6652: app_exception.raise_exception;
6653: END process_corrections;
6654:

Line 6732: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

6728:
6729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6730: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_non_payment_isir');
6731: igs_ge_msg_stack.add;
6732: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
6733: app_exception.raise_exception;
6734: END process_non_payment_isir;
6735:
6736: PROCEDURE process_new_isir_rec IS

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

6863: CLOSE person_cur;
6864:
6865: fnd_message.set_name('IGF','IGF_GR_NEW_PYMNT_ISIR');
6866: fnd_message.set_token('PERSON_NUMBER',person_rec.person_number);
6867: fnd_file.put_line(fnd_file.log, fnd_message.get);
6868: END IF;
6869:
6870: -- Check if Loan is originated for the student
6871: lv_dummy := null;

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

6879:
6880: -- museshad (Bug# 4091601): Modified the incorrect message name
6881: fnd_message.set_name('IGF','IGF_AP_LN_NEW_PYMNT_ISIR');
6882: fnd_message.set_token('PERSON_NUMBER',person_rec.person_number);
6883: fnd_file.put_line(fnd_file.log, fnd_message.get);
6884: ELSE
6885: CLOSE cur_loan_orig_chk;
6886: END IF;
6887: -- Making old ISIR non payment

Line 6960: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

6956:
6957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6958: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_new_isir_rec');
6959: igs_ge_msg_stack.add;
6960: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
6961: app_exception.raise_exception;
6962: END process_new_isir_rec;
6963:
6964:

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

7009:
7010: IF g_pell_match_type = 'D' THEN -- ISIR record is Duplicate
7011:
7012: fnd_message.set_name('IGF','IGF_AP_ISIR_DUPLICATE');
7013: fnd_file.put_line(fnd_file.log, fnd_message.get);
7014:
7015: g_dup_rec := NVL(g_dup_rec ,0)+ 1; -- update Duplicate rec count
7016:
7017: -- update ISIR int record status

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

7038: EXCEPTION
7039: WHEN INVALID_PROFILE_ERROR THEN
7040: -- print the log message
7041: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
7042: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
7043: app_exception.raise_exception;
7044:
7045: WHEN OTHERS THEN
7046: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 7053: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

7049:
7050: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7051: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.pell_match_type_rec_processing');
7052: igs_ge_msg_stack.add;
7053: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
7054: app_exception.raise_exception;
7055: END pell_match_type_rec_processing;
7056:
7057:

Line 7094: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

7090: END IF;
7091:
7092: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7093: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.process_correction_isir');
7094: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7095: igs_ge_msg_stack.add;
7096: app_exception.raise_exception;
7097: END process_correction_isir;
7098:

Line 7187: fnd_file.put_line(fnd_file.log,g_separator_line);

7183:
7184: SAVEPOINT SP1;
7185:
7186: -- Log ISIR Student details
7187: fnd_file.put_line(fnd_file.log,g_separator_line);
7188: fnd_file.put_line(fnd_file.log,'');
7189: fnd_message.set_name ('IGF','IGF_AP_STUD_SSN_DTL');
7190: fnd_message.set_token('NAME',g_isir_intrface_rec.first_name||' '||g_isir_intrface_rec.last_name );
7191: fnd_message.set_token('SSN',g_isir_intrface_rec.current_ssn_txt);

Line 7188: fnd_file.put_line(fnd_file.log,'');

7184: SAVEPOINT SP1;
7185:
7186: -- Log ISIR Student details
7187: fnd_file.put_line(fnd_file.log,g_separator_line);
7188: fnd_file.put_line(fnd_file.log,'');
7189: fnd_message.set_name ('IGF','IGF_AP_STUD_SSN_DTL');
7190: fnd_message.set_token('NAME',g_isir_intrface_rec.first_name||' '||g_isir_intrface_rec.last_name );
7191: fnd_message.set_token('SSN',g_isir_intrface_rec.current_ssn_txt);
7192: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

7188: fnd_file.put_line(fnd_file.log,'');
7189: fnd_message.set_name ('IGF','IGF_AP_STUD_SSN_DTL');
7190: fnd_message.set_token('NAME',g_isir_intrface_rec.first_name||' '||g_isir_intrface_rec.last_name );
7191: fnd_message.set_token('SSN',g_isir_intrface_rec.current_ssn_txt);
7192: fnd_file.put_line(fnd_file.log,fnd_message.get);
7193:
7194: fnd_message.set_name ('IGF','IGF_AP_STUD_TRAN_DTL');
7195: fnd_message.set_token('TRAN', g_isir_intrface_rec.transaction_num_txt);
7196: fnd_message.set_token('NCODE',g_isir_intrface_rec.orig_name_id_txt);

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

7194: fnd_message.set_name ('IGF','IGF_AP_STUD_TRAN_DTL');
7195: fnd_message.set_token('TRAN', g_isir_intrface_rec.transaction_num_txt);
7196: fnd_message.set_token('NCODE',g_isir_intrface_rec.orig_name_id_txt);
7197:
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199:
7200: --count for total number of records.
7201: g_total_recs_processed := g_total_recs_processed +1;
7202:

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

7344: EXCEPTION
7345: WHEN INVALID_PROFILE_ERROR THEN
7346: -- print the log message
7347: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
7348: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
7349: ROLLBACK TO SP1;
7350: RETURN;
7351:
7352: WHEN OTHERS THEN

Line 7363: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);

7359:
7360: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7361: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_int_record');
7362: igs_ge_msg_stack.add;
7363: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
7364: log_debug_message('EXCEPTION : ' || SQLERRM);
7365: RETURN;
7366: END process_int_record;
7367:

Line 7384: fnd_file.put_line(fnd_file.log, g_separator_line);

7380: */
7381:
7382: BEGIN
7383:
7384: fnd_file.put_line(fnd_file.log, g_separator_line);
7385: fnd_file.put_line(fnd_file.log, g_separator_line);
7386: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
7387: fnd_message.set_token('COUNT','');
7388: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.')||TO_CHAR(g_total_recs_processed) );

Line 7385: fnd_file.put_line(fnd_file.log, g_separator_line);

7381:
7382: BEGIN
7383:
7384: fnd_file.put_line(fnd_file.log, g_separator_line);
7385: fnd_file.put_line(fnd_file.log, g_separator_line);
7386: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
7387: fnd_message.set_token('COUNT','');
7388: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.')||TO_CHAR(g_total_recs_processed) );
7389: log_debug_message('TOTAL RECS : ' || TO_CHAR(g_total_recs_processed));

Line 7388: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.')||TO_CHAR(g_total_recs_processed) );

7384: fnd_file.put_line(fnd_file.log, g_separator_line);
7385: fnd_file.put_line(fnd_file.log, g_separator_line);
7386: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
7387: fnd_message.set_token('COUNT','');
7388: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.')||TO_CHAR(g_total_recs_processed) );
7389: log_debug_message('TOTAL RECS : ' || TO_CHAR(g_total_recs_processed));
7390:
7391: fnd_message.set_name('IGF','IGF_AP_MATCHED_RECS');
7392: fnd_message.set_token('COUNT','');

Line 7393: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_matched_rec));

7389: log_debug_message('TOTAL RECS : ' || TO_CHAR(g_total_recs_processed));
7390:
7391: fnd_message.set_name('IGF','IGF_AP_MATCHED_RECS');
7392: fnd_message.set_token('COUNT','');
7393: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_matched_rec));
7394: log_debug_message('MATCHED RECS : ' || TO_CHAR(g_matched_rec));
7395:
7396: fnd_message.set_name('IGF','IGF_AP_UNMATCHED_RECS');
7397: fnd_message.set_token('COUNT','');

Line 7398: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_unmatched_rec));

7394: log_debug_message('MATCHED RECS : ' || TO_CHAR(g_matched_rec));
7395:
7396: fnd_message.set_name('IGF','IGF_AP_UNMATCHED_RECS');
7397: fnd_message.set_token('COUNT','');
7398: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_unmatched_rec));
7399: log_debug_message('UNMATCHED RECS : ' || TO_CHAR(g_unmatched_rec));
7400:
7401:
7402: fnd_message.set_name('IGF','IGF_AP_ISIR_REV');

Line 7403: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,47,' ')||' ' || TO_CHAR(TO_NUMBER(g_review_count)));

7399: log_debug_message('UNMATCHED RECS : ' || TO_CHAR(g_unmatched_rec));
7400:
7401:
7402: fnd_message.set_name('IGF','IGF_AP_ISIR_REV');
7403: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,47,' ')||' ' || TO_CHAR(TO_NUMBER(g_review_count)));
7404: fnd_file.put_line(fnd_file.log, g_separator_line);
7405: fnd_file.put_line(fnd_file.log, g_separator_line);
7406: log_debug_message('REVIEW RECS : ' || TO_CHAR(g_review_count));
7407:

Line 7404: fnd_file.put_line(fnd_file.log, g_separator_line);

7400:
7401:
7402: fnd_message.set_name('IGF','IGF_AP_ISIR_REV');
7403: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,47,' ')||' ' || TO_CHAR(TO_NUMBER(g_review_count)));
7404: fnd_file.put_line(fnd_file.log, g_separator_line);
7405: fnd_file.put_line(fnd_file.log, g_separator_line);
7406: log_debug_message('REVIEW RECS : ' || TO_CHAR(g_review_count));
7407:
7408: fnd_message.set_name('IGF','IGF_AP_DUP_RECS');

Line 7405: fnd_file.put_line(fnd_file.log, g_separator_line);

7401:
7402: fnd_message.set_name('IGF','IGF_AP_ISIR_REV');
7403: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,47,' ')||' ' || TO_CHAR(TO_NUMBER(g_review_count)));
7404: fnd_file.put_line(fnd_file.log, g_separator_line);
7405: fnd_file.put_line(fnd_file.log, g_separator_line);
7406: log_debug_message('REVIEW RECS : ' || TO_CHAR(g_review_count));
7407:
7408: fnd_message.set_name('IGF','IGF_AP_DUP_RECS');
7409: fnd_message.set_token('COUNT','');

Line 7410: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_dup_rec));

7406: log_debug_message('REVIEW RECS : ' || TO_CHAR(g_review_count));
7407:
7408: fnd_message.set_name('IGF','IGF_AP_DUP_RECS');
7409: fnd_message.set_token('COUNT','');
7410: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_dup_rec));
7411: log_debug_message('DUPLICATE RECS : ' || TO_CHAR(g_dup_rec));
7412:
7413:
7414: fnd_message.set_name('IGF','IGF_AP_BAD_RECS');

Line 7416: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_bad_rec));

7412:
7413:
7414: fnd_message.set_name('IGF','IGF_AP_BAD_RECS');
7415: fnd_message.set_token('COUNT','');
7416: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_bad_rec));
7417: log_debug_message('BAD RECS : ' || TO_CHAR(g_bad_rec));
7418:
7419: fnd_message.set_name('IGF','IGF_AP_NEW_PER_RECS');
7420: fnd_message.set_token('COUNT','');

Line 7421: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_unmatched_added));

7417: log_debug_message('BAD RECS : ' || TO_CHAR(g_bad_rec));
7418:
7419: fnd_message.set_name('IGF','IGF_AP_NEW_PER_RECS');
7420: fnd_message.set_token('COUNT','');
7421: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get,50,'.') || TO_CHAR(g_unmatched_added));
7422: log_debug_message('NEW PERSON RECS i.e. => unmatched and added : ' || TO_CHAR(g_unmatched_added));
7423:
7424: END log_statistics;
7425:

Line 7486: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');

7482:
7483: g_gen_party_profile_val := FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER'); -- get the profile value and store in global variable
7484:
7485: -- print input parameters
7486: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
7487: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
7488: fnd_message.set_token('CREATE_PRSN', p_force_add);
7489: fnd_file.put_line(fnd_file.log, fnd_message.get);
7490:

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

7485: -- print input parameters
7486: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
7487: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
7488: fnd_message.set_token('CREATE_PRSN', p_force_add);
7489: fnd_file.put_line(fnd_file.log, fnd_message.get);
7490:
7491: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
7492: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
7493: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7489: fnd_file.put_line(fnd_file.log, fnd_message.get);
7490:
7491: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
7492: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
7493: fnd_file.put_line(fnd_file.log, fnd_message.get);
7494:
7495: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
7496: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
7497: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7493: fnd_file.put_line(fnd_file.log, fnd_message.get);
7494:
7495: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
7496: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
7497: fnd_file.put_line(fnd_file.log, fnd_message.get);
7498:
7499: fnd_message.set_name('IGF', 'IGF_AP_BATCH_YEAR');
7500: fnd_message.set_token('BATCH_YR', p_batch_year);
7501: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7497: fnd_file.put_line(fnd_file.log, fnd_message.get);
7498:
7499: fnd_message.set_name('IGF', 'IGF_AP_BATCH_YEAR');
7500: fnd_message.set_token('BATCH_YR', p_batch_year);
7501: fnd_file.put_line(fnd_file.log, fnd_message.get);
7502:
7503: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
7504: fnd_message.set_token('MATCH_CODE', p_match_code);
7505: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7501: fnd_file.put_line(fnd_file.log, fnd_message.get);
7502:
7503: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
7504: fnd_message.set_token('MATCH_CODE', p_match_code);
7505: fnd_file.put_line(fnd_file.log, fnd_message.get);
7506:
7507: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
7508: fnd_message.set_token('DEL_FLAG', p_del_int);
7509: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7505: fnd_file.put_line(fnd_file.log, fnd_message.get);
7506:
7507: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
7508: fnd_message.set_token('DEL_FLAG', p_del_int);
7509: fnd_file.put_line(fnd_file.log, fnd_message.get);
7510:
7511: fnd_message.set_name('IGF', 'IGF_AP_PRNT_REQ_ID');
7512: fnd_message.set_token('PARENT_REQ_NO', p_parent_req_id);
7513: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7509: fnd_file.put_line(fnd_file.log, fnd_message.get);
7510:
7511: fnd_message.set_name('IGF', 'IGF_AP_PRNT_REQ_ID');
7512: fnd_message.set_token('PARENT_REQ_NO', p_parent_req_id);
7513: fnd_file.put_line(fnd_file.log, fnd_message.get);
7514:
7515: fnd_message.set_name('IGF', 'IGF_AP_SUB_REQ_ID');
7516: fnd_message.set_token('SUB_REQ_NO', p_sub_req_num);
7517: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7513: fnd_file.put_line(fnd_file.log, fnd_message.get);
7514:
7515: fnd_message.set_name('IGF', 'IGF_AP_SUB_REQ_ID');
7516: fnd_message.set_token('SUB_REQ_NO', p_sub_req_num);
7517: fnd_file.put_line(fnd_file.log, fnd_message.get);
7518:
7519: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
7520: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
7521: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

7517: fnd_file.put_line(fnd_file.log, fnd_message.get);
7518:
7519: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
7520: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
7521: fnd_file.put_line(fnd_file.log, fnd_message.get);
7522:
7523: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
7524:
7525:

Line 7523: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');

7519: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
7520: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
7521: fnd_file.put_line(fnd_file.log, fnd_message.get);
7522:
7523: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
7524:
7525:
7526: -- initialize/reset global variables.
7527: reset_global_variables;

Line 7553: fnd_file.put_line(fnd_file.log, errbuf);

7549: IF cur_setup_score%NOTFOUND THEN
7550: CLOSE cur_setup_score ;
7551: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');
7552: errbuf := fnd_message.get;
7553: fnd_file.put_line(fnd_file.log, errbuf);
7554: retcode := 1;
7555: RETURN;
7556: END IF;
7557: CLOSE cur_setup_score ;

Line 7569: fnd_file.put_line(fnd_file.log, errbuf);

7565: IF cur_batch_aw_map%NOTFOUND THEN
7566: CLOSE cur_batch_aw_map ;
7567: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
7568: errbuf := fnd_message.get;
7569: fnd_file.put_line(fnd_file.log, errbuf);
7570: retcode := 1;
7571: RETURN;
7572: END IF ;
7573: CLOSE cur_batch_aw_map ;

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

7584: END IF;
7585:
7586: IF g_isir_intrface_rec.si_id IS NULL THEN
7587: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
7588: fnd_file.put_line(fnd_file.log, fnd_message.get);
7589: RETURN;
7590: END IF;
7591:
7592: log_debug_message(' SI_ID Passed... ' || p_si_id);

Line 7637: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

7633: END IF;
7634:
7635: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7636: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.main');
7637: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7638: igs_ge_msg_stack.add;
7639: igs_ge_msg_stack.conc_exception_hndl;
7640: END main;
7641:

Line 7702: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

7698: END IF;
7699:
7700: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
7701: igs_ge_msg_stack.add;
7702: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7703: RETURN NULL;
7704:
7705: END format_SSN ;
7706:

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

7832: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.is_fa_base_record_present.exception','The exception is : ' || SQLERRM );
7833: END IF;
7834: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7835: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.is_fa_base_record_present');
7836: fnd_file.put_line(fnd_file.log,fnd_message.get);
7837: igs_ge_msg_stack.add;
7838: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7839: RETURN FALSE;
7840: END is_fa_base_record_present;

Line 7838: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

7834: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7835: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.is_fa_base_record_present');
7836: fnd_file.put_line(fnd_file.log,fnd_message.get);
7837: igs_ge_msg_stack.add;
7838: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7839: RETURN FALSE;
7840: END is_fa_base_record_present;
7841:
7842:

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

7924: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.convert_negative_char.exception','The exception is : ' || SQLERRM );
7925: END IF;
7926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7927: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.convert_negative_char');
7928: fnd_file.put_line(fnd_file.log,fnd_message.get);
7929: igs_ge_msg_stack.add;
7930: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7931: app_exception.raise_exception;
7932:

Line 7930: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

7926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7927: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.convert_negative_char');
7928: fnd_file.put_line(fnd_file.log,fnd_message.get);
7929: igs_ge_msg_stack.add;
7930: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7931: app_exception.raise_exception;
7932:
7933: END convert_negative_char;
7934:

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

7982: update_isir_intrface( cur_isir_intrface_rec.si_id, 'MATCHED');
7983:
7984: fnd_message.set_name('IGF','IGF_AP_ISIR_REC_STATUS');
7985: fnd_message.set_token('STATUS','MATCHED');
7986: fnd_file.put_line(fnd_file.log, fnd_message.get);
7987: END LOOP;
7988:
7989: EXCEPTION
7990: WHEN others THEN

Line 7997: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

7993: END IF;
7994:
7995: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7996: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.load_isir_matched');
7997: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7998: igs_ge_msg_stack.add;
7999: app_exception.raise_exception;
8000: END load_matched_isir;
8001:

Line 8053: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

8049: END IF;
8050:
8051: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8052: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_isir_matched');
8053: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
8054: igs_ge_msg_stack.add;
8055: app_exception.raise_exception;
8056:
8057: END create_isir_matched;

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

8094: END LOOP;
8095:
8096: fnd_message.set_name('IGF','IGF_AP_ISIR_REC_STATUS');
8097: fnd_message.set_token('STATUS', pv_record_status);
8098: fnd_file.put_line(fnd_file.log, fnd_message.get);
8099:
8100: EXCEPTION
8101: WHEN others THEN
8102: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 8108: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

8104: END IF;
8105:
8106: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8107: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.UPDATE_ISIR_INTRFACE');
8108: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
8109: igs_ge_msg_stack.add;
8110: app_exception.raise_exception;
8111: END update_isir_intrface;
8112:

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

8176: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_nslds_data.exception','The exception is : ' || SQLERRM );
8177: END IF;
8178: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8179: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_nslds_data');
8180: fnd_file.put_line(fnd_file.log,fnd_message.get);
8181: igs_ge_msg_stack.add;
8182: END create_nslds_data;
8183:
8184: