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_MESSAGE

Line 210: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

206: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.get_msg_class_from_filename.exception','The exception is : ' || SQLERRM );
207: END IF;
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;

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 251: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

247: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
248: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.is_payment_isir.exception','The exception is : ' || 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;

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 391: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

387: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
388: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.exception','The exception is : ' || 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;

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 443: fnd_message.set_name('IGF','IGF_AP_ISIR_REC_STATUS');

439: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.statement','Updated ISIR Interface Record Status to ' || p_isir_rec_status || ' for SI_ID: ' || p_si_id);
440: END IF;
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:

Line 444: fnd_message.set_token('STATUS',p_isir_rec_status);

440: END IF;
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

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 454: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

450: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
451: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.exception','The exception is : ' || 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;

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 623: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

619: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
620: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_fa_base_rec.exception','The exception is : ' || 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;

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 969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

965: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
966: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_matched_rec(.exception','The exception is : ' || 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;

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 1386: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1382: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.exception','The exception is : ' || 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;

Line 1387: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_isir_matched_rec');

1383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.exception','The exception is : ' || 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;

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 1638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1634: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1635: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_nslds_data_rec.exception','The exception is : ' || 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;

Line 1639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_nslds_data_rec');

1635: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_nslds_data_rec.exception','The exception is : ' || 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;

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 1885: fnd_message.set_name ('IGF', 'IGF_AP_ERR_FA_REC');

1881: );
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:

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 1897: fnd_message.set_name('IGF','IGF_AP_ISIR_FA_BASE_CREATED');

1893: END IF;
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

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 1906: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1902: WHEN others THEN
1903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

Line 1907: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_fa_base_record');

1903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

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 2018: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2014: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2015: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.exception','The exception is : ' || 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;

Line 2019: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.update_prsn_match_rec_status');

2015: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.exception','The exception is : ' || 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;

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 2151: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2147: END IF;
2148:
2149: wf_core.context('IGF_AP_PushedIsir_WF', 'PUSHEDISIR', l_seq_val, l_raise_event);
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;

Line 2152: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.raise_cps_pushed_isir_event');

2148:
2149: wf_core.context('IGF_AP_PushedIsir_WF', 'PUSHEDISIR', l_seq_val, l_raise_event);
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;

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

2292: END IF;
2293:
2294: wf_core.context('IGF_AP_DemographicChange_WF', 'DEMOGRAPHICCHANGE', l_seq_val, l_raise_event); -- RAMMOHAN check name
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;

Line 2297: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.raise_demographic_chng_event');

2293:
2294: wf_core.context('IGF_AP_DemographicChange_WF', 'DEMOGRAPHICCHANGE', l_seq_val, l_raise_event); -- RAMMOHAN check name
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;

Line 2386: fnd_message.set_name('IGF','IGF_AP_ISIR_EMAIL_NTFND');

2382: -- Email already exists, so don't insert email again.
2383:
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:

Line 2387: fnd_message.set_token('EMAIL_ID', g_isir_intrface_rec.s_email_address_txt);

2383:
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

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 2437: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;
2441: END create_updt_email_address;

Line 2438: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_updt_email_address');

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;
2441: END create_updt_email_address;
2442:

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 2604: fnd_message.set_name ('IGF','IGF_AP_PER_ID_NOT_SET');

2600: OPEN person_id_type_cur (l_pers_id_type) ;
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:

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 2713: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2709: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2710: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || 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;

Line 2714: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.update_person_info');

2710: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || 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;

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 2906: fnd_message.set_name('IGF','IGF_AP_FEDSCH_NOT_SAME');

2902: OPEN cur_per_det(g_person_id, 'PERSON') ;
2903: FETCH cur_per_det into l_cur_per_rec;
2904: CLOSE cur_per_det;
2905:
2906: fnd_message.set_name('IGF','IGF_AP_FEDSCH_NOT_SAME');
2907: fnd_message.set_token('PERSON_NUM', l_cur_per_rec.person_number);
2908:
2909: ELSIF l_message = 'IGF_AP_INVALID_ELEC_FED_SCH' THEN
2910: fnd_message.set_name('IGF','IGF_AP_INVALID_ELEC_FED_SCH');

Line 2907: fnd_message.set_token('PERSON_NUM', l_cur_per_rec.person_number);

2903: FETCH cur_per_det into l_cur_per_rec;
2904: CLOSE cur_per_det;
2905:
2906: fnd_message.set_name('IGF','IGF_AP_FEDSCH_NOT_SAME');
2907: fnd_message.set_token('PERSON_NUM', l_cur_per_rec.person_number);
2908:
2909: ELSIF l_message = 'IGF_AP_INVALID_ELEC_FED_SCH' THEN
2910: fnd_message.set_name('IGF','IGF_AP_INVALID_ELEC_FED_SCH');
2911:

Line 2910: fnd_message.set_name('IGF','IGF_AP_INVALID_ELEC_FED_SCH');

2906: fnd_message.set_name('IGF','IGF_AP_FEDSCH_NOT_SAME');
2907: fnd_message.set_token('PERSON_NUM', l_cur_per_rec.person_number);
2908:
2909: ELSIF l_message = 'IGF_AP_INVALID_ELEC_FED_SCH' THEN
2910: fnd_message.set_name('IGF','IGF_AP_INVALID_ELEC_FED_SCH');
2911:
2912: ELSE
2913: fnd_message.set_name('IGF','IGF_AP_FED_NOT_IN_SYSTEM');
2914: fnd_message.set_token('FEDCODE',l_college_code);

Line 2913: fnd_message.set_name('IGF','IGF_AP_FED_NOT_IN_SYSTEM');

2909: ELSIF l_message = 'IGF_AP_INVALID_ELEC_FED_SCH' THEN
2910: fnd_message.set_name('IGF','IGF_AP_INVALID_ELEC_FED_SCH');
2911:
2912: ELSE
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);

Line 2914: fnd_message.set_token('FEDCODE',l_college_code);

2910: fnd_message.set_name('IGF','IGF_AP_INVALID_ELEC_FED_SCH');
2911:
2912: ELSE
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:

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 2946: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2942: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2943: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.exception','The exception is : ' || 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;

Line 2947: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.validate_correction_school');

2943: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.exception','The exception is : ' || 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;

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 3049: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3045: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3046: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.exception','The exception is : ' || SQLERRM );
3047: END IF;
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;

Line 3050: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.delete_person_match_rec' );

3046: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.exception','The exception is : ' || SQLERRM );
3047: END IF;
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;

Line 3113: fnd_message.set_name('IGF','IGF_AP_NO_DEF_ADM_CAL');

3109:
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;

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 3133: fnd_message.set_name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');

3129: p_message => l_message
3130: );
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;

Line 3134: fnd_message.set_token('CAL_TYPE', l_inq_cal_type);

3130: );
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:

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 3214: FND_MESSAGE.Set_Name('IGS', 'IGS_AD_INQ_NOT_CRT');

3210: EXECUTE IMMEDIATE l_igr_sql_stmt
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);

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 3231: fnd_message.set_name('IGF','IGF_AP_ISIR_ADM_REC');

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');
3232: fnd_file.put_line(fnd_file.log,fnd_message.get);
3233: END IF;
3234:
3235: END IF; -- g_create_inquiry

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 3275: fnd_message.set_name('IGF','IGF_AP_NO_PERSON_TYPE');

3271: log_debug_message('Inserted record into igs_pe_typ_instances. ID : ' || ln_typ_id);
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

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 3297: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3293: IF cur_person_type%ISOPEN THEN
3294: CLOSE cur_person_type;
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;

Line 3298: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.create_admission_rec');

3294: CLOSE cur_person_type;
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:

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 3365: fnd_message.set_name('IGF','IGF_AP_PER_ID_NOT_SET');

3361: OPEN person_id_type_cur ( l_pers_id_typ) ;
3362: FETCH person_id_type_cur INTO lv_person_id_type;
3363:
3364: IF person_id_type_cur%NOTFOUND THEN
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.

Line 3366: pv_mesg_data := fnd_message.get;

3362: FETCH person_id_type_cur INTO lv_person_id_type;
3363:
3364: IF person_id_type_cur%NOTFOUND THEN
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;

Line 3463: fnd_message.set_name('IGF','IGF_AP_ISIR_CREATE_PERSON');

3459: );
3460:
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

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 3493: pv_mesg_data := fnd_message.get;

3489: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.exception','The exception is : ' || SQLERRM );
3490: END IF;
3491:
3492: IF fnd_msg_pub.count_msg = 1 THEN
3493: pv_mesg_data := fnd_message.get;
3494:
3495: ELSIF fnd_msg_pub.count_msg > 1 THEN
3496: pv_mesg_data := SQLERRM;
3497: END IF ;

Line 3614: fnd_message.set_name('IGF','IGF_AP_ISIR_PER_ADD');

3610: );
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);

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 3623: fnd_message.set_name('IGS','IGS_AD_CRT_ADDR_FAILED');

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
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

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 3638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;
3642: END create_person_addr_record;

Line 3639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_person_addr_record');

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;
3642: END create_person_addr_record;
3643:

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 3812: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3808: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3809: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.exception','The exception is : ' || 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;

Line 3813: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.auto_fa_rec');

3809: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.exception','The exception is : ' || 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;

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 3861: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3857: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3858: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.exception','The exception is : ' || 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;

Line 3862: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.rvw_fa_rec');

3858: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.exception','The exception is : ' || 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 ;

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 3907: fnd_message.set_name('IGF','IGF_AP_SUCCESS_CREATE_PERSON');

3903: ); -- igs_pe_person_pkg.insert_row();
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 );

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 4022: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

4018: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4019: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.exception','The exception is : ' || 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;

Line 4023: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.unmatched_rec');

4019: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.exception','The exception is : ' || 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 ;

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 4370: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

4366: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4367: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );
4368: END IF;
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;

Line 4371: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.calculate_match_score' );

4367: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );
4368: END IF;
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;

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

4644: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4645: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );
4646: END IF;
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;

Line 4649: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.perform_record_matching' );

4645: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );
4646: END IF;
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 ;

Line 4843: fnd_message.set_name('IGF','IGF_AP_ISIR_AUTO_FA');

4839: p_cal_type => g_ci_cal_type,
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;

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 4891: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

4887: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4888: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );
4889: END IF;
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;

Line 4892: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_unidentified_isir_rec');

4888: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );
4889: END IF;
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;

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

6491: x_mode => 'R');
6492: RAM_I_CORR := RAM_I_CORR +1;
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

Line 6496: fnd_message.set_token('FIELD', isir_corr_rec.column_name);

6492: RAM_I_CORR := RAM_I_CORR +1;
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.

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 6523: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');

6519: RAM_U_CORR := RAM_U_CORR +1;
6520: END IF;
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:

Line 6524: fnd_message.set_token('FIELD', isir_corr_rec.column_name);

6520: END IF;
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

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 6641: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

6637: WHEN OTHERS THEN
6638: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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:

Line 6642: fnd_message.set_token('NAME','PROCESS_ISIR_RECEIPT.PROCESS_CORRECTIONS');

6638: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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);

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 6648: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

6644: igs_ge_msg_stack.add;
6645:
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;

Line 6649: fnd_message.set_token('VALUE',lv_param_values);

6645:
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;

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 6729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

6725: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
6726: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.exception','The exception is : ' || SQLERRM );
6727: END IF;
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;

Line 6730: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_non_payment_isir');

6726: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.exception','The exception is : ' || SQLERRM );
6727: END IF;
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;

Line 6865: fnd_message.set_name('IGF','IGF_GR_NEW_PYMNT_ISIR');

6861: OPEN person_cur(g_person_id);
6862: FETCH person_cur INTO person_rec;
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:

Line 6866: fnd_message.set_token('PERSON_NUMBER',person_rec.person_number);

6862: FETCH person_cur INTO person_rec;
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

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 6881: fnd_message.set_name('IGF','IGF_AP_LN_NEW_PYMNT_ISIR');

6877: FETCH person_cur INTO person_rec;
6878: CLOSE person_cur;
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;

Line 6882: fnd_message.set_token('PERSON_NUMBER',person_rec.person_number);

6878: CLOSE person_cur;
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;

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 6957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

6953: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
6954: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.exception','The exception is : ' || SQLERRM );
6955: END IF;
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;

Line 6958: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_new_isir_rec');

6954: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.exception','The exception is : ' || SQLERRM );
6955: END IF;
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;

Line 7012: fnd_message.set_name('IGF','IGF_AP_ISIR_DUPLICATE');

7008:
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:

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 7041: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');

7037:
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

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 7050: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

7046: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7047: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.exception','The exception is : ' || SQLERRM);
7048: END IF;
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;

Line 7051: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.pell_match_type_rec_processing');

7047: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.exception','The exception is : ' || SQLERRM);
7048: END IF;
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;

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

7088: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7089: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_correction_isir.exception','The exception is : ' || 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;

Line 7093: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.process_correction_isir');

7089: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_correction_isir.exception','The exception is : ' || 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;

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 7189: fnd_message.set_name ('IGF','IGF_AP_STUD_SSN_DTL');

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);
7193:

Line 7190: fnd_message.set_token('NAME',g_isir_intrface_rec.first_name||' '||g_isir_intrface_rec.last_name );

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);
7193:
7194: fnd_message.set_name ('IGF','IGF_AP_STUD_TRAN_DTL');

Line 7191: fnd_message.set_token('SSN',g_isir_intrface_rec.current_ssn_txt);

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);
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);

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 7194: fnd_message.set_name ('IGF','IGF_AP_STUD_TRAN_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);
7197:
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 7195: fnd_message.set_token('TRAN', g_isir_intrface_rec.transaction_num_txt);

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);
7197:
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199:

Line 7196: fnd_message.set_token('NCODE',g_isir_intrface_rec.orig_name_id_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);
7197:
7198: fnd_file.put_line(fnd_file.log,fnd_message.get);
7199:
7200: --count for total number of records.

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 7347: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');

7343:
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:

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 7360: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

7356: END IF;
7357:
7358: g_bad_rec := g_bad_rec + 1; -- update bad rec count
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);

Line 7361: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_int_record');

7357:
7358: g_bad_rec := g_bad_rec + 1; -- update bad rec count
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;

Line 7386: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');

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));
7390:

Line 7387: fnd_message.set_token('COUNT','');

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));
7390:
7391: fnd_message.set_name('IGF','IGF_AP_MATCHED_RECS');

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 7391: fnd_message.set_name('IGF','IGF_AP_MATCHED_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','');
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:

Line 7392: 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','');
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');

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 7396: fnd_message.set_name('IGF','IGF_AP_UNMATCHED_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','');
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:

Line 7397: 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','');
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:

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 7402: fnd_message.set_name('IGF','IGF_AP_ISIR_REV');

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');
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));

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 7408: fnd_message.set_name('IGF','IGF_AP_DUP_RECS');

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','');
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:

Line 7409: fnd_message.set_token('COUNT','');

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','');
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:

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 7414: fnd_message.set_name('IGF','IGF_AP_BAD_RECS');

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');
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:

Line 7415: fnd_message.set_token('COUNT','');

7411: log_debug_message('DUPLICATE RECS : ' || TO_CHAR(g_dup_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');

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 7419: fnd_message.set_name('IGF','IGF_AP_NEW_PER_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','');
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:

Line 7420: 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','');
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;

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 7487: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');

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:
7491: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');

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

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:
7491: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
7492: fnd_message.set_token('CREATE_INQ', p_create_inquiry);

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 7491: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');

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);
7494:
7495: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');

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

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);
7494:
7495: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
7496: fnd_message.set_token('INQ_METHOD', p_adm_source_type);

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 7495: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');

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);
7498:
7499: fnd_message.set_name('IGF', 'IGF_AP_BATCH_YEAR');

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

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);
7498:
7499: fnd_message.set_name('IGF', 'IGF_AP_BATCH_YEAR');
7500: fnd_message.set_token('BATCH_YR', p_batch_year);

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 7499: fnd_message.set_name('IGF', 'IGF_AP_BATCH_YEAR');

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);
7502:
7503: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');

Line 7500: fnd_message.set_token('BATCH_YR', p_batch_year);

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);
7502:
7503: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
7504: fnd_message.set_token('MATCH_CODE', p_match_code);

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 7503: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');

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);
7506:
7507: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');

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

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);
7506:
7507: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
7508: fnd_message.set_token('DEL_FLAG', p_del_int);

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 7507: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');

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);
7510:
7511: fnd_message.set_name('IGF', 'IGF_AP_PRNT_REQ_ID');

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

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);
7510:
7511: fnd_message.set_name('IGF', 'IGF_AP_PRNT_REQ_ID');
7512: fnd_message.set_token('PARENT_REQ_NO', p_parent_req_id);

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 7511: fnd_message.set_name('IGF', 'IGF_AP_PRNT_REQ_ID');

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);
7514:
7515: fnd_message.set_name('IGF', 'IGF_AP_SUB_REQ_ID');

Line 7512: fnd_message.set_token('PARENT_REQ_NO', p_parent_req_id);

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);
7514:
7515: fnd_message.set_name('IGF', 'IGF_AP_SUB_REQ_ID');
7516: fnd_message.set_token('SUB_REQ_NO', p_sub_req_num);

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 7515: fnd_message.set_name('IGF', 'IGF_AP_SUB_REQ_ID');

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);
7518:
7519: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');

Line 7516: fnd_message.set_token('SUB_REQ_NO', p_sub_req_num);

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);
7518:
7519: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
7520: fnd_message.set_token('UPD_ANT', p_upd_ant_val);

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 7519: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');

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);
7522:
7523: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');

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

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);
7522:
7523: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
7524:

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 7551: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');

7547: FETCH cur_setup_score INTO g_setup_score;
7548:
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;

Line 7552: errbuf := fnd_message.get;

7548:
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;

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

7563: FETCH cur_batch_aw_map INTO g_ci_cal_type,g_ci_sequence_number ;
7564:
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;

Line 7568: errbuf := fnd_message.get;

7564:
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 ;

Line 7587: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');

7583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Procedure invoked by passing SI ID ' || p_si_id);
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:

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 7635: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

7631: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7632: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.main.exception','The exception is : ' || 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;

Line 7636: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.main');

7632: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.main.exception','The exception is : ' || 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;

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 7700: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

7696: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7697: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.format_SSN.exception','The exception is : ' || 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:

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 7834: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

7830: WHEN others THEN
7831: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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);

Line 7835: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.is_fa_base_record_present');

7831: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

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 7926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

7922: WHEN others THEN
7923: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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);

Line 7927: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.convert_negative_char');

7923: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

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 7984: fnd_message.set_name('IGF','IGF_AP_ISIR_REC_STATUS');

7980: create_nslds_data( cur_isir_intrface_rec.si_id, ln_isir_id, pn_base_id);
7981:
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:

Line 7985: fnd_message.set_token('STATUS','MATCHED');

7981:
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

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 7995: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

7991: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7992: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.load_matched_isir.exception','The exception is : ' || 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;

Line 7996: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.load_isir_matched');

7992: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.load_matched_isir.exception','The exception is : ' || 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;

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 8051: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

8047: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8048: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_isir_matched.exception','The exception is : ' || 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;

Line 8052: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_isir_matched');

8048: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_isir_matched.exception','The exception is : ' || 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:

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 8096: fnd_message.set_name('IGF','IGF_AP_ISIR_REC_STATUS');

8092: WHERE si_id = cur_isir_intrface_rec.si_id;
8093:
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

Line 8097: fnd_message.set_token('STATUS', pv_record_status);

8093:
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

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 8106: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

8102: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8103: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_intrface.exception','The exception is : ' || 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;

Line 8107: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.UPDATE_ISIR_INTRFACE');

8103: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_intrface.exception','The exception is : ' || 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;

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 8178: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

8174: WHEN others THEN
8175: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

Line 8179: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_nslds_data');

8175: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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:

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:

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

8224: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.check_ptyp_code.exception','The exception is : ' || SQLERRM );
8226: END IF;
8227:
8228: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8229: fnd_message.set_token('NAME','igf_ap_matching_process.check_ptyp_code');
8230: igs_ge_msg_stack.add;
8231:
8232: END check_ptyp_code;

Line 8229: fnd_message.set_token('NAME','igf_ap_matching_process.check_ptyp_code');

8225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.check_ptyp_code.exception','The exception is : ' || SQLERRM );
8226: END IF;
8227:
8228: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8229: fnd_message.set_token('NAME','igf_ap_matching_process.check_ptyp_code');
8230: igs_ge_msg_stack.add;
8231:
8232: END check_ptyp_code;
8233:

Line 8284: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');

8280: FETCH cur_isir_intrface INTO g_isir_intrface_rec;
8281: CLOSE cur_isir_intrface ;
8282:
8283: IF g_isir_intrface_rec.si_id IS NULL THEN
8284: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
8285: p_message_out := fnd_message.get;
8286: p_return_status := 'E'; -- indicate Failure
8287: RETURN;
8288: END IF;

Line 8285: p_message_out := fnd_message.get;

8281: CLOSE cur_isir_intrface ;
8282:
8283: IF g_isir_intrface_rec.si_id IS NULL THEN
8284: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
8285: p_message_out := fnd_message.get;
8286: p_return_status := 'E'; -- indicate Failure
8287: RETURN;
8288: END IF;
8289:

Line 8297: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');

8293: FETCH cur_setup_score INTO g_setup_score;
8294:
8295: IF cur_setup_score%NOTFOUND THEN
8296: CLOSE cur_setup_score ;
8297: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');
8298: p_return_status := 'E';
8299: p_message_out := fnd_message.get;
8300: RETURN;
8301: END IF;

Line 8299: p_message_out := fnd_message.get;

8295: IF cur_setup_score%NOTFOUND THEN
8296: CLOSE cur_setup_score ;
8297: fnd_message.set_name('IGF','IGF_AP_SETUP_SCORE_NOT_FOUND');
8298: p_return_status := 'E';
8299: p_message_out := fnd_message.get;
8300: RETURN;
8301: END IF;
8302: CLOSE cur_setup_score ;
8303:

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

8371: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_refresh_matches.exception','The exception is : ' || SQLERRM );
8372: END IF;
8373:
8374: p_return_status := 'E'; -- indicate error
8375: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8376: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8377: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8378: END wrpr_refresh_matches;
8379:

Line 8376: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');

8372: END IF;
8373:
8374: p_return_status := 'E'; -- indicate error
8375: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8376: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8377: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8378: END wrpr_refresh_matches;
8379:
8380: -- Added p_award_yr as a part of Bug Fix 4241350

Line 8377: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;

8373:
8374: p_return_status := 'E'; -- indicate error
8375: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8376: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8377: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8378: END wrpr_refresh_matches;
8379:
8380: -- Added p_award_yr as a part of Bug Fix 4241350
8381: PROCEDURE wrpr_auto_fa_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,

Line 8451: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');

8447: FETCH cur_isir_intrface INTO g_isir_intrface_rec;
8448: CLOSE cur_isir_intrface ;
8449:
8450: IF g_isir_intrface_rec.si_id IS NULL THEN
8451: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
8452: p_message_out := fnd_message.get;
8453: p_return_status := 'E'; -- indicate Failure
8454: RETURN;
8455: END IF;

Line 8452: p_message_out := fnd_message.get;

8448: CLOSE cur_isir_intrface ;
8449:
8450: IF g_isir_intrface_rec.si_id IS NULL THEN
8451: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
8452: p_message_out := fnd_message.get;
8453: p_return_status := 'E'; -- indicate Failure
8454: RETURN;
8455: END IF;
8456:

Line 8471: fnd_message.set_name('IGF','IGF_AP_SSN_FOR_BASEREC');

8467: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%NOTFOUND. raising error');
8468: END IF;
8469: CLOSE c_ssn;
8470: p_return_status := 'E';
8471: fnd_message.set_name('IGF','IGF_AP_SSN_FOR_BASEREC');
8472: p_message_out := fnd_message.get;
8473: RETURN;
8474: ELSE
8475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 8472: p_message_out := fnd_message.get;

8468: END IF;
8469: CLOSE c_ssn;
8470: p_return_status := 'E';
8471: fnd_message.set_name('IGF','IGF_AP_SSN_FOR_BASEREC');
8472: p_message_out := fnd_message.get;
8473: RETURN;
8474: ELSE
8475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8476: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%FOUND.');

Line 8504: fnd_message.set_name('IGF','IGF_AP_TRAN_NUM_EXISTS');

8500: CLOSE cur_isir_matched ;
8501:
8502: IF l_trans_exists = 'Y' THEN
8503: --i.e. The Person Base ID and the current trans rec already exists. Hence report error and return
8504: fnd_message.set_name('IGF','IGF_AP_TRAN_NUM_EXISTS');
8505: fnd_message.set_token('TRAN_NUM',g_isir_intrface_rec.transaction_num_txt);
8506: p_message_out := fnd_message.get;
8507: p_return_status := 'E'; -- indicate Failure
8508: RETURN;

Line 8505: fnd_message.set_token('TRAN_NUM',g_isir_intrface_rec.transaction_num_txt);

8501:
8502: IF l_trans_exists = 'Y' THEN
8503: --i.e. The Person Base ID and the current trans rec already exists. Hence report error and return
8504: fnd_message.set_name('IGF','IGF_AP_TRAN_NUM_EXISTS');
8505: fnd_message.set_token('TRAN_NUM',g_isir_intrface_rec.transaction_num_txt);
8506: p_message_out := fnd_message.get;
8507: p_return_status := 'E'; -- indicate Failure
8508: RETURN;
8509: END IF; -- l_trans_exists

Line 8506: p_message_out := fnd_message.get;

8502: IF l_trans_exists = 'Y' THEN
8503: --i.e. The Person Base ID and the current trans rec already exists. Hence report error and return
8504: fnd_message.set_name('IGF','IGF_AP_TRAN_NUM_EXISTS');
8505: fnd_message.set_token('TRAN_NUM',g_isir_intrface_rec.transaction_num_txt);
8506: p_message_out := fnd_message.get;
8507: p_return_status := 'E'; -- indicate Failure
8508: RETURN;
8509: END IF; -- l_trans_exists
8510:

Line 8529: fnd_message.set_name('IGF','IGF_AP_SUCCESS_FA_BASE');

8525: p_cal_type => g_ci_cal_type,
8526: p_seq_num => g_ci_sequence_number
8527: );
8528:
8529: fnd_message.set_name('IGF','IGF_AP_SUCCESS_FA_BASE');
8530: p_message_out := fnd_message.get;
8531:
8532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.statement','ISIR Imported successfully for the specified person');

Line 8530: p_message_out := fnd_message.get;

8526: p_seq_num => g_ci_sequence_number
8527: );
8528:
8529: fnd_message.set_name('IGF','IGF_AP_SUCCESS_FA_BASE');
8530: p_message_out := fnd_message.get;
8531:
8532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.statement','ISIR Imported successfully for the specified person');
8534: END IF;

Line 8545: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');

8541: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.exception','The exception is : ' || SQLERRM );
8542: END IF;
8543:
8544: p_return_status := 'E'; -- return error
8545: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
8546: p_message_out := fnd_message.get;
8547:
8548: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8549: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');

Line 8546: p_message_out := fnd_message.get;

8542: END IF;
8543:
8544: p_return_status := 'E'; -- return error
8545: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
8546: p_message_out := fnd_message.get;
8547:
8548: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8549: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8550: p_message_out := p_message_out || '. ' || fnd_message.get || ' Exception is : ' || SQLERRM;

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

8544: p_return_status := 'E'; -- return error
8545: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
8546: p_message_out := fnd_message.get;
8547:
8548: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8549: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8550: p_message_out := p_message_out || '. ' || fnd_message.get || ' Exception is : ' || SQLERRM;
8551: END wrpr_auto_fa_rec;
8552:

Line 8549: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');

8545: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
8546: p_message_out := fnd_message.get;
8547:
8548: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8549: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8550: p_message_out := p_message_out || '. ' || fnd_message.get || ' Exception is : ' || SQLERRM;
8551: END wrpr_auto_fa_rec;
8552:
8553:

Line 8550: p_message_out := p_message_out || '. ' || fnd_message.get || ' Exception is : ' || SQLERRM;

8546: p_message_out := fnd_message.get;
8547:
8548: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8549: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_refresh_matches');
8550: p_message_out := p_message_out || '. ' || fnd_message.get || ' Exception is : ' || SQLERRM;
8551: END wrpr_auto_fa_rec;
8552:
8553:
8554: PROCEDURE wrpr_unmatched_rec(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,

Line 8589: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');

8585: FETCH cur_isir_intrface INTO g_isir_intrface_rec;
8586: CLOSE cur_isir_intrface ;
8587:
8588: IF g_isir_intrface_rec.si_id IS NULL THEN
8589: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
8590: p_message_out := fnd_message.get;
8591: p_return_status := 'E'; -- indicate Failure
8592: RETURN;
8593: END IF;

Line 8590: p_message_out := fnd_message.get;

8586: CLOSE cur_isir_intrface ;
8587:
8588: IF g_isir_intrface_rec.si_id IS NULL THEN
8589: fnd_message.set_name('IGF','IGF_AP_NO_INT_REC_FOUND');
8590: p_message_out := fnd_message.get;
8591: p_return_status := 'E'; -- indicate Failure
8592: RETURN;
8593: END IF;
8594:

Line 8612: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');

8608: -- Check if HZ gen party profile is set to YES as a new person is to be created. If set to No. return with error message
8609: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
8610: p_return_status := 'E'; -- indicate error
8611:
8612: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
8613: p_message_out := fnd_message.get;
8614: RETURN;
8615: END IF;
8616:

Line 8613: p_message_out := fnd_message.get;

8609: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
8610: p_return_status := 'E'; -- indicate error
8611:
8612: fnd_message.set_name('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
8613: p_message_out := fnd_message.get;
8614: RETURN;
8615: END IF;
8616:
8617: -- call procedure to create person and import ISIR.

Line 8623: fnd_message.set_name('IGF','IGF_AP_SUCCESS_CREATE_PERSON');

8619: p_called_from => 'FORM',
8620: p_msg_out => p_message_out);
8621:
8622:
8623: fnd_message.set_name('IGF','IGF_AP_SUCCESS_CREATE_PERSON');
8624: p_message_out := fnd_message.get;
8625:
8626: p_return_status := 'S'; -- indicate success
8627:

Line 8624: p_message_out := fnd_message.get;

8620: p_msg_out => p_message_out);
8621:
8622:
8623: fnd_message.set_name('IGF','IGF_AP_SUCCESS_CREATE_PERSON');
8624: p_message_out := fnd_message.get;
8625:
8626: p_return_status := 'S'; -- indicate success
8627:
8628: EXCEPTION

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

8631: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_unmatched_rec.exception','The exception is : ' || SQLERRM );
8632: END IF;
8633:
8634: p_return_status := 'E'; -- indicate error
8635: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8636: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_unmatched_rec');
8637: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8638: END wrpr_unmatched_rec;
8639:

Line 8636: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_unmatched_rec');

8632: END IF;
8633:
8634: p_return_status := 'E'; -- indicate error
8635: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8636: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_unmatched_rec');
8637: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8638: END wrpr_unmatched_rec;
8639:
8640: END igf_ap_matching_process_pkg;

Line 8637: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;

8633:
8634: p_return_status := 'E'; -- indicate error
8635: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8636: fnd_message.set_token('NAME','igf_ap_matching_process.wrpr_unmatched_rec');
8637: p_message_out := fnd_message.get || '. Exception is : ' || SQLERRM;
8638: END wrpr_unmatched_rec;
8639:
8640: END igf_ap_matching_process_pkg;