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_LOG

Line 205: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

201: RETURN(l_mesg_class);
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

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

202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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');

Line 247: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

243: RETURN (lv_payment_isir);
244:
245: EXCEPTION
246: WHEN OTHERS THEN
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');

Line 248: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.is_payment_isir.exception','The exception is : ' || SQLERRM );

244:
245: EXCEPTION
246: WHEN OTHERS THEN
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;

Line 299: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

295: lv_rowid ROWID;
296:
297: BEGIN
298:
299: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
300: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Beginning processing of TODO Items for BASE ID: ' || p_base_id || ', Payment ISIR Flag: ' || p_payment_isir );
301: END IF;
302:
303: log_debug_message(' Processing TODO items.... ');

Line 300: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Beginning processing of TODO Items for BASE ID: ' || p_base_id || ', Payment ISIR Flag: ' || p_payment_isir );

296:
297: BEGIN
298:
299: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
300: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Beginning processing of TODO Items for BASE ID: ' || p_base_id || ', Payment ISIR Flag: ' || p_payment_isir );
301: END IF;
302:
303: log_debug_message(' Processing TODO items.... ');
304: -- populate the variable with the status to be updated for the records

Line 325: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

321:
322: IF check_todo_exists_inst_cur%NOTFOUND THEN
323:
324: log_debug_message(' Attaching new ISIR with item_sequence_number : ' || todo_items_for_isir_rec.todo_number || ' and TODO status : ' || l_todo_status || ' for Base ID: ' || p_base_id);
325: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
326: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Attaching new ISIR with item_sequence_number : ' || todo_items_for_isir_rec.todo_number || ' for Base ID: ' || p_base_id);
327: END IF;
328:
329: -- insert new row

Line 326: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Attaching new ISIR with item_sequence_number : ' || todo_items_for_isir_rec.todo_number || ' for Base ID: ' || p_base_id);

322: IF check_todo_exists_inst_cur%NOTFOUND THEN
323:
324: log_debug_message(' Attaching new ISIR with item_sequence_number : ' || todo_items_for_isir_rec.todo_number || ' and TODO status : ' || l_todo_status || ' for Base ID: ' || p_base_id);
325: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
326: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Attaching new ISIR with item_sequence_number : ' || todo_items_for_isir_rec.todo_number || ' for Base ID: ' || p_base_id);
327: END IF;
328:
329: -- insert new row
330: lv_rowid := NULL;

Line 351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

347: );
348: ELSE
349:
350: log_debug_message(' Update TODO Items to Status : ' || l_todo_status);
351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Processing TODO status to : ' || l_todo_status || ' for Base ID: ' || p_base_id);
353: END IF;
354:
355: -- update the status to complete

Line 352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Processing TODO status to : ' || l_todo_status || ' for Base ID: ' || p_base_id);

348: ELSE
349:
350: log_debug_message(' Update TODO Items to Status : ' || l_todo_status);
351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Processing TODO status to : ' || l_todo_status || ' for Base ID: ' || p_base_id);
353: END IF;
354:
355: -- update the status to complete
356: igf_ap_td_item_inst_pkg.update_row (

Line 380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

376: CLOSE check_todo_exists_inst_cur;
377:
378: log_debug_message('Successfully processed TODO processing.');
379: RAM_U_TODO := RAM_U_TODO + 1;
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Item No.: ' || todo_items_for_isir_rec.todo_number);
382: END IF;
383: END LOOP;
384:

Line 381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Item No.: ' || todo_items_for_isir_rec.todo_number);

377:
378: log_debug_message('Successfully processed TODO processing.');
379: RAM_U_TODO := RAM_U_TODO + 1;
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.debug','Item No.: ' || todo_items_for_isir_rec.todo_number);
382: END IF;
383: END LOOP;
384:
385: EXCEPTION

Line 387: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

383: END LOOP;
384:
385: EXCEPTION
386: WHEN OTHERS THEN
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');

Line 388: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.exception','The exception is : ' || SQLERRM );

384:
385: EXCEPTION
386: WHEN OTHERS THEN
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;

Line 426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

422: DELETE FROM igf_ap_isir_ints_all
423: WHERE si_id = p_si_id;
424:
425: log_debug_message('Deleted ISIR Interface record. SI ID : ' || p_si_id);
426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.statement','Deleted ISIR Interface record for SI_ID: ' || p_si_id);
428: END IF;
429:
430: ELSE -- if parameter is No or status is not 'MATCHED'

Line 427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.statement','Deleted ISIR Interface record for SI_ID: ' || p_si_id);

423: WHERE si_id = p_si_id;
424:
425: log_debug_message('Deleted ISIR Interface record. SI ID : ' || p_si_id);
426: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
427: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.statement','Deleted ISIR Interface record for SI_ID: ' || p_si_id);
428: END IF;
429:
430: ELSE -- if parameter is No or status is not 'MATCHED'
431: UPDATE igf_ap_isir_ints_all

Line 438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

434: last_update_date = SYSDATE
435: WHERE si_id = p_si_id;
436:
437: log_debug_message('Updated ISIR Interface record. SI ID : ' || p_si_id);
438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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;

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

435: WHERE si_id = p_si_id;
436:
437: log_debug_message('Updated ISIR Interface record. SI ID : ' || p_si_id);
438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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');

Line 450: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

446: END IF;
447:
448: EXCEPTION
449: WHEN OTHERS THEN
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');

Line 451: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.exception','The exception is : ' || SQLERRM );

447:
448: EXCEPTION
449: WHEN OTHERS THEN
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;

Line 612: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

608:
609: );
610:
611: log_debug_message(' Successfully Updated FA Base record. BASE ID : ' || p_fabase_rec.base_id || '. Person ID" ' || p_fabase_rec.person_id);
612: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
613: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_fa_base_rec.debug','Updated FA Base Record for BASE ID: ' || p_fabase_rec.base_id || ', Person ID" ' || p_fabase_rec.person_id);
614: END IF;
615: RAM_U_F := RAM_U_F + 1;
616:

Line 613: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_fa_base_rec.debug','Updated FA Base Record for BASE ID: ' || p_fabase_rec.base_id || ', Person ID" ' || p_fabase_rec.person_id);

609: );
610:
611: log_debug_message(' Successfully Updated FA Base record. BASE ID : ' || p_fabase_rec.base_id || '. Person ID" ' || p_fabase_rec.person_id);
612: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
613: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_fa_base_rec.debug','Updated FA Base Record for BASE ID: ' || p_fabase_rec.base_id || ', Person ID" ' || p_fabase_rec.person_id);
614: END IF;
615: RAM_U_F := RAM_U_F + 1;
616:
617: EXCEPTION

Line 619: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

615: RAM_U_F := RAM_U_F + 1;
616:
617: EXCEPTION
618: WHEN OTHERS THEN
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');

Line 620: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_fa_base_rec.exception','The exception is : ' || SQLERRM );

616:
617: EXCEPTION
618: WHEN OTHERS THEN
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;

Line 958: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

954: x_verification_selection_flag => p_isir_matched_record.verification_selection_flag
955: );
956:
957: log_debug_message(' Successfully updated Isir Matched record. ' || p_isir_matched_record.isir_id || '. Payment ISIR Flag: ' || p_payment_isir || '. Active ISIR Flag: ' || p_active_isir);
958: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
959: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_matched_rec.statement','Successfully updated ISIR record for ISIR ID : ' || p_isir_matched_record.isir_id);
960: END IF;
961: RAM_U_M := RAM_U_M + 1;
962:

Line 959: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_matched_rec.statement','Successfully updated ISIR record for ISIR ID : ' || p_isir_matched_record.isir_id);

955: );
956:
957: log_debug_message(' Successfully updated Isir Matched record. ' || p_isir_matched_record.isir_id || '. Payment ISIR Flag: ' || p_payment_isir || '. Active ISIR Flag: ' || p_active_isir);
958: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
959: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_isir_matched_rec.statement','Successfully updated ISIR record for ISIR ID : ' || p_isir_matched_record.isir_id);
960: END IF;
961: RAM_U_M := RAM_U_M + 1;
962:
963: EXCEPTION

Line 965: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

961: RAM_U_M := RAM_U_M + 1;
962:
963: EXCEPTION
964: WHEN OTHERS THEN
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');

Line 966: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_matched_rec(.exception','The exception is : ' || SQLERRM );

962:
963: EXCEPTION
964: WHEN OTHERS THEN
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;

Line 1048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1044: BEGIN
1045: lv_rowid := NULL;
1046:
1047: log_debug_message(' Beginning Insert of ISIR Matched record. Base ID: ' || p_base_id || ', Payment ISIR Flag: ' || p_payment_isir);
1048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.debug','Inserting ISIR Matched record: Base ID: ' || p_Base_id || ', Payment: ' || p_payment_isir);
1050: END IF;
1051:
1052:

Line 1049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.debug','Inserting ISIR Matched record: Base ID: ' || p_Base_id || ', Payment: ' || p_payment_isir);

1045: lv_rowid := NULL;
1046:
1047: log_debug_message(' Beginning Insert of ISIR Matched record. Base ID: ' || p_base_id || ', Payment ISIR Flag: ' || p_payment_isir);
1048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.debug','Inserting ISIR Matched record: Base ID: ' || p_Base_id || ', Payment: ' || p_payment_isir);
1050: END IF;
1051:
1052:
1053: -- Call function which extracts and returns message class from a given data file name.

Line 1375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1371: x_verification_selection_flag => cp_isir_int_rec.verification_selection_flag
1372: );
1373:
1374: log_debug_message(' SUccessfully Inserted ISIR Matched record. ISIR ID : ' || p_out_isir_id);
1375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.statement','Successfully inserted new ISIR record into ISIR Matched table. ISIR ID : ' || p_out_isir_id );
1377: END IF;
1378: RAM_I_M := RAM_I_M + 1;
1379:

Line 1376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.statement','Successfully inserted new ISIR record into ISIR Matched table. ISIR ID : ' || p_out_isir_id );

1372: );
1373:
1374: log_debug_message(' SUccessfully Inserted ISIR Matched record. ISIR ID : ' || p_out_isir_id);
1375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.statement','Successfully inserted new ISIR record into ISIR Matched table. ISIR ID : ' || p_out_isir_id );
1377: END IF;
1378: RAM_I_M := RAM_I_M + 1;
1379:
1380: EXCEPTION

Line 1382: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1378: RAM_I_M := RAM_I_M + 1;
1379:
1380: EXCEPTION
1381: WHEN others THEN
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');

Line 1383: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_isir_matched_rec.exception','The exception is : ' || SQLERRM );

1379:
1380: EXCEPTION
1381: WHEN others THEN
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');

Line 1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1623: );
1624:
1625: log_debug_message(' Successfully Inserted NSLDS record. NSLDS ID : ' || p_out_nslds_id);
1626:
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_nslds_data_rec.statement','Inserted data into NSLDS data table. NSLDS ID : ' || p_out_nslds_id);
1629: END IF;
1630: RAM_I_N := RAM_I_N + 1;
1631:

Line 1628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_nslds_data_rec.statement','Inserted data into NSLDS data table. NSLDS ID : ' || p_out_nslds_id);

1624:
1625: log_debug_message(' Successfully Inserted NSLDS record. NSLDS ID : ' || p_out_nslds_id);
1626:
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_nslds_data_rec.statement','Inserted data into NSLDS data table. NSLDS ID : ' || p_out_nslds_id);
1629: END IF;
1630: RAM_I_N := RAM_I_N + 1;
1631:
1632: EXCEPTION

Line 1634: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1630: RAM_I_N := RAM_I_N + 1;
1631:
1632: EXCEPTION
1633: WHEN others THEN
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');

Line 1635: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_nslds_data_rec.exception','The exception is : ' || SQLERRM );

1631:
1632: EXCEPTION
1633: WHEN others THEN
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');

Line 1891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1887: app_exception.raise_exception;
1888: END IF;
1889:
1890: log_debug_message(' Successfully inserted FA Base Record. Base ID: ' || pn_base_id);
1891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_fa_base_record.statement','Inserted FA Base Record. BASE ID : ' || pn_base_id || ', Person ID:' || pn_person_id);
1893: END IF;
1894:
1895: g_base_id := pn_base_id; -- populate global variable

Line 1892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_fa_base_record.statement','Inserted FA Base Record. BASE ID : ' || pn_base_id || ', Person ID:' || pn_person_id);

1888: END IF;
1889:
1890: log_debug_message(' Successfully inserted FA Base Record. Base ID: ' || pn_base_id);
1891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1892: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.insert_fa_base_record.statement','Inserted FA Base Record. BASE ID : ' || pn_base_id || ', Person ID:' || pn_person_id);
1893: END IF;
1894:
1895: g_base_id := pn_base_id; -- populate global variable
1896:

Line 1903: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1899: RAM_I_F := RAM_I_F + 1;
1900:
1901: EXCEPTION
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');

Line 1904: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.insert_fa_base_record.exception','The exception is : ' || SQLERRM );

1900:
1901: EXCEPTION
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);

Line 1966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1962: x_record_status => p_rec_status,
1963: x_mode => 'R'
1964: );
1965:
1966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.statement',' Updated Record Status for APM ID : ' || person_match_rec.apm_id);
1968: END IF;
1969: RAM_U_PM := RAM_U_PM + 1;
1970:

Line 1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.statement',' Updated Record Status for APM ID : ' || person_match_rec.apm_id);

1963: x_mode => 'R'
1964: );
1965:
1966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.statement',' Updated Record Status for APM ID : ' || person_match_rec.apm_id);
1968: END IF;
1969: RAM_U_PM := RAM_U_PM + 1;
1970:
1971: -- update record status for corresponding match detail records

Line 2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2002:
2003:
2004: RAM_U_MD := RAM_U_MD + 1;
2005: log_debug_message(' Updated Match Details record status to : ' || p_rec_status);
2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2007: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.statement',' Updated Record Status for Person ID : ' || match_details_rec.person_id || ' AMD ID: ' || match_details_rec.amd_id);
2008: END IF;
2009: END LOOP; -- match_details_rec
2010: END LOOP; -- person_match_rec

Line 2007: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.statement',' Updated Record Status for Person ID : ' || match_details_rec.person_id || ' AMD ID: ' || match_details_rec.amd_id);

2003:
2004: RAM_U_MD := RAM_U_MD + 1;
2005: log_debug_message(' Updated Match Details record status to : ' || p_rec_status);
2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2007: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.update_prsn_match_rec_status.statement',' Updated Record Status for Person ID : ' || match_details_rec.person_id || ' AMD ID: ' || match_details_rec.amd_id);
2008: END IF;
2009: END LOOP; -- match_details_rec
2010: END LOOP; -- person_match_rec
2011:

Line 2014: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2010: END LOOP; -- person_match_rec
2011:
2012: EXCEPTION
2013: WHEN others THEN
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');

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

2011:
2012: EXCEPTION
2013: WHEN others THEN
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');

Line 2064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2060:
2061: l_seq_val := 'IGFAPW06'|| TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'); -- for unique identification
2062:
2063: log_debug_message(' Beginning raise_cps_pushed_isir_event Proc for raising Notification');
2064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raising Business event Notification for a CPS Pushed ISIR. Message Class:' || l_message_class);
2066: END IF;
2067:
2068:

Line 2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raising Business event Notification for a CPS Pushed ISIR. Message Class:' || l_message_class);

2061: l_seq_val := 'IGFAPW06'|| TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'); -- for unique identification
2062:
2063: log_debug_message(' Beginning raise_cps_pushed_isir_event Proc for raising Notification');
2064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2065: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raising Business event Notification for a CPS Pushed ISIR. Message Class:' || l_message_class);
2066: END IF;
2067:
2068:
2069: OPEN get_fa_rec_verif_stat(g_base_id);

Line 2075: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2071: CLOSE get_fa_rec_verif_stat ;
2072:
2073: IF l_verification_status NOT IN ('ACCURATE','REPROCESSED','WITHOUTDOC') THEN
2074: log_debug_message('No need to raise notification as the Verification Status is NOT complete.');
2075: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','No need to raise notification as the Verification Status is NOT complete');
2077: END IF;
2078:
2079: RETURN;

Line 2076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','No need to raise notification as the Verification Status is NOT complete');

2072:
2073: IF l_verification_status NOT IN ('ACCURATE','REPROCESSED','WITHOUTDOC') THEN
2074: log_debug_message('No need to raise notification as the Verification Status is NOT complete.');
2075: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','No need to raise notification as the Verification Status is NOT complete');
2077: END IF;
2078:
2079: RETURN;
2080: END IF;

Line 2083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2079: RETURN;
2080: END IF;
2081:
2082: log_debug_message('Raising Business event Notification');
2083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raising Business event Notification');
2085: END IF;
2086:
2087: IF g_person_id IS NOT NULL THEN

Line 2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raising Business event Notification');

2080: END IF;
2081:
2082: log_debug_message('Raising Business event Notification');
2083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raising Business event Notification');
2085: END IF;
2086:
2087: IF g_person_id IS NOT NULL THEN
2088: OPEN person_dtls_cur(g_person_id);

Line 2138: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2134:
2135: -- Deleting the Parameter list after the event is raised
2136: l_parameter_list_t.delete;
2137:
2138: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2139: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raised Business event Notification for a CPS Pushed ISIR. Message Class:' || l_message_class);
2140: END IF;
2141: log_debug_message(' Raised CPS PUSHED ISIR Business Event successfully.') ;
2142:

Line 2139: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raised Business event Notification for a CPS Pushed ISIR. Message Class:' || l_message_class);

2135: -- Deleting the Parameter list after the event is raised
2136: l_parameter_list_t.delete;
2137:
2138: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2139: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.processed_cps_pushed_isir.statement','Raised Business event Notification for a CPS Pushed ISIR. Message Class:' || l_message_class);
2140: END IF;
2141: log_debug_message(' Raised CPS PUSHED ISIR Business Event successfully.') ;
2142:
2143: EXCEPTION

Line 2145: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2141: log_debug_message(' Raised CPS PUSHED ISIR Business Event successfully.') ;
2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2146: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.raise_cps_pushed_isir_event.exception','The exception is : ' || SQLERRM );
2147: END IF;
2148:
2149: wf_core.context('IGF_AP_PushedIsir_WF', 'PUSHEDISIR', l_seq_val, l_raise_event);

Line 2146: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.raise_cps_pushed_isir_event.exception','The exception is : ' || SQLERRM );

2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2146: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.raise_cps_pushed_isir_event.exception','The exception is : ' || SQLERRM );
2147: END IF;
2148:
2149: wf_core.context('IGF_AP_PushedIsir_WF', 'PUSHEDISIR', l_seq_val, l_raise_event);
2150:

Line 2192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2188: l_seq_val := 'DATACHNG'|| TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'); -- for unique identification
2189:
2190: log_debug_message(' Beginning demographic data changed event. Person ID: ' || g_person_id);
2191:
2192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.statement','Raising demographic data changes Business event Notification. Person ID : ' || g_person_id);
2194: END IF;
2195:
2196: IF g_person_id IS NOT NULL THEN

Line 2193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.statement','Raising demographic data changes Business event Notification. Person ID : ' || g_person_id);

2189:
2190: log_debug_message(' Beginning demographic data changed event. Person ID: ' || g_person_id);
2191:
2192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.statement','Raising demographic data changes Business event Notification. Person ID : ' || g_person_id);
2194: END IF;
2195:
2196: IF g_person_id IS NOT NULL THEN
2197: OPEN person_dtls_cur(g_person_id);

Line 2282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2278:
2279: -- Deleting the Parameter list after the event is raised
2280: l_parameter_list_t.delete;
2281:
2282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.statement','Raised Demographic data changes Business event Notification. Message Class:' ||l_message_class);
2284: END IF;
2285:
2286: log_debug_message('Completed demographic data changed event. Raised Notification');

Line 2283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.statement','Raised Demographic data changes Business event Notification. Message Class:' ||l_message_class);

2279: -- Deleting the Parameter list after the event is raised
2280: l_parameter_list_t.delete;
2281:
2282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.statement','Raised Demographic data changes Business event Notification. Message Class:' ||l_message_class);
2284: END IF;
2285:
2286: log_debug_message('Completed demographic data changed event. Raised Notification');
2287:

Line 2290: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2286: log_debug_message('Completed demographic data changed event. Raised Notification');
2287:
2288: EXCEPTION
2289: WHEN OTHERS THEN
2290: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2291: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.exception','The exception is : ' || SQLERRM );
2292: END IF;
2293:
2294: wf_core.context('IGF_AP_DemographicChange_WF', 'DEMOGRAPHICCHANGE', l_seq_val, l_raise_event); -- RAMMOHAN check name

Line 2291: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.exception','The exception is : ' || SQLERRM );

2287:
2288: EXCEPTION
2289: WHEN OTHERS THEN
2290: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2291: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.raise_demographic_chng_event.exception','The exception is : ' || SQLERRM );
2292: END IF;
2293:
2294: wf_core.context('IGF_AP_DemographicChange_WF', 'DEMOGRAPHICCHANGE', l_seq_val, l_raise_event); -- RAMMOHAN check name
2295:

Line 2363: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2359: BEGIN
2360: SAVEPOINT email_SP1;
2361:
2362: log_debug_message(' Beginning create/update email address. Person ID : ' || p_person_id);
2363: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug','Beginning create_updt_email_address for person_id : ' || p_person_id);
2365: END IF;
2366:
2367: -- check whether email already exists for the person

Line 2364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug','Beginning create_updt_email_address for person_id : ' || p_person_id);

2360: SAVEPOINT email_SP1;
2361:
2362: log_debug_message(' Beginning create/update email address. Person ID : ' || p_person_id);
2363: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2364: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug','Beginning create_updt_email_address for person_id : ' || p_person_id);
2365: END IF;
2366:
2367: -- check whether email already exists for the person
2368: OPEN cur_chk_email_addr(p_person_id);

Line 2391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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,
2393: 'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug',
2394: 'Person id ' ||p_person_id|| ' already has email. Not considering email address in ISIR');
2395: END IF;

Line 2392: fnd_log.string(fnd_log.level_statement,

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,
2393: 'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug',
2394: 'Person id ' ||p_person_id|| ' already has email. Not considering email address in ISIR');
2395: END IF;
2396: ELSE

Line 2400: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2396: ELSE
2397: -- Email does not exist. Hence insert a new e-mail address as Primary
2398: p_contact_points_rec.primary_flag := 'Y';
2399:
2400: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2401: fnd_log.string(fnd_log.level_statement,
2402: 'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug',
2403: 'Person id ' ||p_person_id|| ' does not have email. Inserting email address into Person record from ISIR');
2404: END IF;

Line 2401: fnd_log.string(fnd_log.level_statement,

2397: -- Email does not exist. Hence insert a new e-mail address as Primary
2398: p_contact_points_rec.primary_flag := 'Y';
2399:
2400: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2401: fnd_log.string(fnd_log.level_statement,
2402: 'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug',
2403: 'Person id ' ||p_person_id|| ' does not have email. Inserting email address into Person record from ISIR');
2404: END IF;
2405:

Line 2420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2416: );
2417: END IF;
2418:
2419: RAM_I_HZ := RAM_I_HZ + 1;
2420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug','Email Creation resulted in Status : ' || l_return_status || ', Person ID: ' || p_person_id);
2422: END IF;
2423:
2424: IF l_return_status IN ('E','U') THEN

Line 2421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug','Email Creation resulted in Status : ' || l_return_status || ', Person ID: ' || p_person_id);

2417: END IF;
2418:
2419: RAM_I_HZ := RAM_I_HZ + 1;
2420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.debug','Email Creation resulted in Status : ' || l_return_status || ', Person ID: ' || p_person_id);
2422: END IF;
2423:
2424: IF l_return_status IN ('E','U') THEN
2425: ROLLBACK TO email_SP1;

Line 2431: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2427: END IF;
2428:
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2432: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.exception','The exception is : ' || SQLERRM );
2433: END IF;
2434: ROLLBACK TO email_SP1;
2435:

Line 2432: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.exception','The exception is : ' || SQLERRM );

2428:
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2432: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_updt_email_address.exception','The exception is : ' || SQLERRM );
2433: END IF;
2434: ROLLBACK TO email_SP1;
2435:
2436: fnd_file.put_line(FND_FILE.LOG ,l_msg_data||fnd_global.newline ||'STATUS:'||l_return_status);

Line 2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2568: END IF;
2569:
2570: ln_person_id := g_person_id ;
2571:
2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2573: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Checking for any person data changes for person : ' || ln_person_id);
2574: END IF;
2575:
2576:

Line 2573: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Checking for any person data changes for person : ' || ln_person_id);

2569:
2570: ln_person_id := g_person_id ;
2571:
2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2573: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Checking for any person data changes for person : ' || ln_person_id);
2574: END IF;
2575:
2576:
2577: -- get person details from OSS

Line 2616: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2612:
2613: log_debug_message(' End Date for Alternate Person ID fetched by alt_person_id_cur : ' || TO_CHAR(alt_person_id_rec.end_dt));
2614: -- check whether the alt pers id is active
2615: IF SYSDATE > alt_person_id_rec.end_dt THEN
2616: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','SSN Type Alternate Person ID record for the person is already End Dated. SSN No.: ' || person_rec.api_person_id);
2618: END IF;
2619:
2620: EXIT; --

Line 2617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','SSN Type Alternate Person ID record for the person is already End Dated. SSN No.: ' || person_rec.api_person_id);

2613: log_debug_message(' End Date for Alternate Person ID fetched by alt_person_id_cur : ' || TO_CHAR(alt_person_id_rec.end_dt));
2614: -- check whether the alt pers id is active
2615: IF SYSDATE > alt_person_id_rec.end_dt THEN
2616: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2617: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','SSN Type Alternate Person ID record for the person is already End Dated. SSN No.: ' || person_rec.api_person_id);
2618: END IF;
2619:
2620: EXIT; --
2621: END IF;

Line 2623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2619:
2620: EXIT; --
2621: END IF;
2622:
2623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Active Alternate Person ID record found for the person. SSN No.:' || person_rec.api_person_id);
2625: END IF;
2626: END LOOP;
2627:

Line 2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Active Alternate Person ID record found for the person. SSN No.:' || person_rec.api_person_id);

2620: EXIT; --
2621: END IF;
2622:
2623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Active Alternate Person ID record found for the person. SSN No.:' || person_rec.api_person_id);
2625: END IF;
2626: END LOOP;
2627:
2628: -- museshad (Bug 4291874)

Line 2636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2632: END IF;
2633: -- museshad (Bug 4291874)
2634:
2635: -- NOW compare OSS values with the new ISIR values and determine whether any data has changed.
2636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Comparing OSS data with ISIR data to identify changes to demographic data');
2638: END IF;
2639:
2640: l_demo_data_changed := 'N'; -- initialize

Line 2637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Comparing OSS data with ISIR data to identify changes to demographic data');

2633: -- museshad (Bug 4291874)
2634:
2635: -- NOW compare OSS values with the new ISIR values and determine whether any data has changed.
2636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Comparing OSS data with ISIR data to identify changes to demographic data');
2638: END IF;
2639:
2640: l_demo_data_changed := 'N'; -- initialize
2641:

Line 2690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2686: l_demo_data_changed := 'Y';
2687: END IF;
2688:
2689:
2690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Person Demographic data changed: ' || l_demo_data_changed);
2692: END IF;
2693: log_debug_message('Person Demographic data changed flag : ' || l_demo_data_changed);
2694:

Line 2691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Person Demographic data changed: ' || l_demo_data_changed);

2687: END IF;
2688:
2689:
2690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Person Demographic data changed: ' || l_demo_data_changed);
2692: END IF;
2693: log_debug_message('Person Demographic data changed flag : ' || l_demo_data_changed);
2694:
2695:

Line 2701: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2697:
2698: -- raise notification
2699: raise_demographic_chng_event; -- call the procedure to raise the event
2700:
2701: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2702: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Person Demographic data changed and hence send notification: ');
2703: END IF;
2704: END IF;
2705: log_debug_message('Completed update_person_info Proc. Person data changed ? : ' || l_demo_data_changed);

Line 2702: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Person Demographic data changed and hence send notification: ');

2698: -- raise notification
2699: raise_demographic_chng_event; -- call the procedure to raise the event
2700:
2701: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2702: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.person_update_info.debug','Person Demographic data changed and hence send notification: ');
2703: END IF;
2704: END IF;
2705: log_debug_message('Completed update_person_info Proc. Person data changed ? : ' || l_demo_data_changed);
2706:

Line 2709: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2705: log_debug_message('Completed update_person_info Proc. Person data changed ? : ' || l_demo_data_changed);
2706:
2707: EXCEPTION
2708: WHEN others THEN
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');

Line 2710: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || SQLERRM );

2706:
2707: EXCEPTION
2708: WHEN others THEN
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');

Line 2790: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2786: l_send_workflow := FALSE;
2787: l_college_code := NULL;
2788: p_payment_isir := 'N';
2789:
2790: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2791: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','This ISIR is a Correction ISIR. Performing School validation' );
2792: END IF;
2793:
2794: IF NVL(g_isir_intrface_rec.fedral_schl_type,'X') NOT IN ('1','2','3','4','5','6') THEN

Line 2791: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','This ISIR is a Correction ISIR. Performing School validation' );

2787: l_college_code := NULL;
2788: p_payment_isir := 'N';
2789:
2790: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2791: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','This ISIR is a Correction ISIR. Performing School validation' );
2792: END IF;
2793:
2794: IF NVL(g_isir_intrface_rec.fedral_schl_type,'X') NOT IN ('1','2','3','4','5','6') THEN
2795: -- invalid.. Lot a message and send WF notification

Line 2847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2843: log_debug_message('Correction School code is ' || l_college_code);
2844:
2845: IF l_college_code IS NOT NULL THEN
2846:
2847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Correction School code is : ' || l_college_code);
2849: END IF;
2850:
2851: -- open the cursor to see if the l_school_code obtained is valid or not

Line 2848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Correction School code is : ' || l_college_code);

2844:
2845: IF l_college_code IS NOT NULL THEN
2846:
2847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Correction School code is : ' || l_college_code);
2849: END IF;
2850:
2851: -- open the cursor to see if the l_school_code obtained is valid or not
2852: l_chk_valid := NULL;

Line 2921: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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
2922: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Sending School Code validation workflow notification');
2923: END IF;
2924:
2925: lv_rowid := NULL;

Line 2922: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Sending School Code validation workflow notification');

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
2922: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Sending School Code validation workflow notification');
2923: END IF;
2924:
2925: lv_rowid := NULL;
2926: igf_ap_outcorr_wf_pkg.insert_row (

Line 2942: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2938: log_debug_message('Successfully completed validate_correction_school proc');
2939:
2940: EXCEPTION
2941: WHEN others THEN
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');

Line 2943: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.exception','The exception is : ' || SQLERRM );

2939:
2940: EXCEPTION
2941: WHEN others THEN
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');

Line 3024: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3020: WHERE amd_id = g_amd_id_tab(k);
3021:
3022: log_debug_message(' Deleted Match Details records for APM ID : ' || l_apm_id);
3023: RAM_D_MD := RAM_D_MD + 1;
3024: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.debug','Deleted Match Details records for APM ID: ' || l_apm_id);
3026: END IF;
3027: END IF; -- l_cnt_match_dtls
3028:

Line 3025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.debug','Deleted Match Details records for APM ID: ' || l_apm_id);

3021:
3022: log_debug_message(' Deleted Match Details records for APM ID : ' || l_apm_id);
3023: RAM_D_MD := RAM_D_MD + 1;
3024: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.debug','Deleted Match Details records for APM ID: ' || l_apm_id);
3026: END IF;
3027: END IF; -- l_cnt_match_dtls
3028:
3029:

Line 3035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3031: igf_ap_person_match_pkg.delete_row(prsn_match_rec.row_id);
3032: RAM_D_PM := RAM_D_PM + 1;
3033:
3034: log_debug_message(' Deleted Person Match record for APM ID : ' || l_apm_id);
3035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.debug','Deleted Person Match record. APM ID: ' || prsn_match_rec.apm_id);
3037: END IF;
3038:
3039: END LOOP;

Line 3036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.debug','Deleted Person Match record. APM ID: ' || prsn_match_rec.apm_id);

3032: RAM_D_PM := RAM_D_PM + 1;
3033:
3034: log_debug_message(' Deleted Person Match record for APM ID : ' || l_apm_id);
3035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.debug','Deleted Person Match record. APM ID: ' || prsn_match_rec.apm_id);
3037: END IF;
3038:
3039: END LOOP;
3040:

Line 3045: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3041: log_debug_message(' Successfully deleted Person match and Match details data for APM ID: ' || l_apm_id);
3042:
3043: EXCEPTION
3044: WHEN OTHERS THEN
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');

Line 3046: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.delete_person_match_rec.exception','The exception is : ' || SQLERRM );

3042:
3043: EXCEPTION
3044: WHEN OTHERS THEN
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' );

Line 3101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3097:
3098: BEGIN
3099:
3100: log_debug_message(' Beginning Create Admission rec proc');
3101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3102: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Beginning of Create Admission Record. Person ID: ' || p_person_id || ',Batch Year:' || p_batch_year);
3103: END IF;
3104:
3105: -- Check if the parameter to create inquiry record is set to Y.

Line 3102: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Beginning of Create Admission Record. Person ID: ' || p_person_id || ',Batch Year:' || p_batch_year);

3098: BEGIN
3099:
3100: log_debug_message(' Beginning Create Admission rec proc');
3101: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3102: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Beginning of Create Admission Record. Person ID: ' || p_person_id || ',Batch Year:' || p_batch_year);
3103: END IF;
3104:
3105: -- Check if the parameter to create inquiry record is set to Y.
3106: IF (g_create_inquiry = 'Y') THEN

Line 3119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3115: app_exception.raise_exception;
3116: END IF;
3117: CLOSE cur_adm_cal_conf;
3118:
3119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Calling igs_ad_gen_008.get_acad_cal');
3121: END IF;
3122:
3123: igs_ad_gen_008.get_acad_cal(

Line 3120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Calling igs_ad_gen_008.get_acad_cal');

3116: END IF;
3117: CLOSE cur_adm_cal_conf;
3118:
3119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Calling igs_ad_gen_008.get_acad_cal');
3121: END IF;
3122:
3123: igs_ad_gen_008.get_acad_cal(
3124: p_adm_cal_type => l_inq_cal_type,

Line 3139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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
3140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Inserting into igr_inquiry');
3141: END IF;
3142:
3143: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN

Line 3140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Inserting into igr_inquiry');

3136: RETURN;
3137: END IF;
3138:
3139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Before Inserting into igr_inquiry');
3141: END IF;
3142:
3143: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
3144:

Line 3220: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
3220: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Inquiry creation returned status: ' || lv_return_status);
3222: END IF;
3223:
3224: IF lv_return_status IN ('E','U') THEN

Line 3221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Inquiry creation returned status: ' || lv_return_status);

3217:
3218: log_debug_message('Created Admission Inquiry record. Status : ' || lv_return_status);
3219: RAM_I_HZ := RAM_I_HZ + 1;
3220: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','Inquiry creation returned status: ' || lv_return_status);
3222: END IF;
3223:
3224: IF lv_return_status IN ('E','U') THEN
3225:

Line 3237: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3233: END IF;
3234:
3235: END IF; -- g_create_inquiry
3236:
3237: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3238: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','After Create Inquiry. Before inserting into igs_pe_typ_instances_pkg');
3239: END IF;
3240:
3241:

Line 3238: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','After Create Inquiry. Before inserting into igs_pe_typ_instances_pkg');

3234:
3235: END IF; -- g_create_inquiry
3236:
3237: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3238: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.debug','After Create Inquiry. Before inserting into igs_pe_typ_instances_pkg');
3239: END IF;
3240:
3241:
3242: l_sys_type := 'PROSPECT' ;

Line 3279: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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');
3281: END IF;
3282:
3283: EXCEPTION

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

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');
3281: END IF;
3282:
3283: EXCEPTION
3284: WHEN others THEN

Line 3285: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3281: END IF;
3282:
3283: EXCEPTION
3284: WHEN others THEN
3285: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3286: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.exception','The exception is : ' || SQLERRM );
3287: END IF;
3288:
3289: IF cur_adm_cal_conf%ISOPEN THEN

Line 3286: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.exception','The exception is : ' || SQLERRM );

3282:
3283: EXCEPTION
3284: WHEN others THEN
3285: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3286: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_admission_rec.exception','The exception is : ' || SQLERRM );
3287: END IF;
3288:
3289: IF cur_adm_cal_conf%ISOPEN THEN
3290: CLOSE cur_adm_cal_conf;

Line 3355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3351: l_msg_data VARCHAR2(4000);
3352:
3353: BEGIN
3354:
3355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Beginning Person Creation.');
3357: END IF;
3358: log_debug_message(' Beginning Person Creation procedure');
3359:

Line 3356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Beginning Person Creation.');

3352:
3353: BEGIN
3354:
3355: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Beginning Person Creation.');
3357: END IF;
3358: log_debug_message(' Beginning Person Creation procedure');
3359:
3360: l_pers_id_typ := 'SSN' ;

Line 3373: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3369: fnd_file.put_line(fnd_file.log, pv_mesg_data); -- log the msg in log file.
3370: END IF;
3371: CLOSE person_id_type_cur;
3372:
3373: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug',pv_mesg_data);
3375: END IF;
3376:
3377: RETURN;

Line 3374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug',pv_mesg_data);

3370: END IF;
3371: CLOSE person_id_type_cur;
3372:
3373: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug',pv_mesg_data);
3375: END IF;
3376:
3377: RETURN;
3378: END IF;

Line 3392: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3388: END IF;
3389: CLOSE cur_lookups;
3390:
3391:
3392: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3393: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Inserting Into Person table.');
3394: END IF;
3395:
3396: SAVEPOINT person_SP1;

Line 3393: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Inserting Into Person table.');

3389: CLOSE cur_lookups;
3390:
3391:
3392: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3393: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Inserting Into Person table.');
3394: END IF;
3395:
3396: SAVEPOINT person_SP1;
3397: lv_row_id := NULL;

Line 3470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3466:
3467: ELSE -- error creating person
3468:
3469: log_debug_message(' Error Creating Person. Status ' || lv_return_status || ' Msg:' || lv_msg_data);
3470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Error creating person. Return Status : ' || lv_return_status || ' ' || 'Message: ' || lv_msg_data);
3472: END IF;
3473:
3474: ROLLBACK TO person_SP1;

Line 3471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Error creating person. Return Status : ' || lv_return_status || ' ' || 'Message: ' || lv_msg_data);

3467: ELSE -- error creating person
3468:
3469: log_debug_message(' Error Creating Person. Status ' || lv_return_status || ' Msg:' || lv_msg_data);
3470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Error creating person. Return Status : ' || lv_return_status || ' ' || 'Message: ' || lv_msg_data);
3472: END IF;
3473:
3474: ROLLBACK TO person_SP1;
3475: pn_person_id := NULL;

Line 3481: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3477: END IF;
3478:
3479: g_person_id := pn_person_id; -- assign to global variable.
3480:
3481: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3482: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Person Created Successfully... ' || g_person_id);
3483: END IF;
3484:
3485: EXCEPTION

Line 3482: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Person Created Successfully... ' || g_person_id);

3478:
3479: g_person_id := pn_person_id; -- assign to global variable.
3480:
3481: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3482: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.debug','Person Created Successfully... ' || g_person_id);
3483: END IF;
3484:
3485: EXCEPTION
3486: WHEN OTHERS THEN

Line 3488: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3484:
3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: log_debug_message(' EXCEPTON in create_person_record proc : ' || SQLERRM);
3488: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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

Line 3489: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_person_record.exception','The exception is : ' || SQLERRM );

3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: log_debug_message(' EXCEPTON in create_person_record proc : ' || SQLERRM);
3488: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

Line 3543: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3539:
3540: BEGIN
3541:
3542: log_debug_message('Beginning creation of Person Address. Person ID : ' || pn_person_id);
3543: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.debug','Beginning Address creation for Person ID: ' || pn_person_id);
3545: END IF;
3546:
3547:

Line 3544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.debug','Beginning Address creation for Person ID: ' || pn_person_id);

3540: BEGIN
3541:
3542: log_debug_message('Beginning creation of Person Address. Person ID : ' || pn_person_id);
3543: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3544: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.debug','Beginning Address creation for Person ID: ' || pn_person_id);
3545: END IF;
3546:
3547:
3548: lv_row_id := NULL;

Line 3619: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

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

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

Line 3627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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);
3629: END IF;
3630:
3631: EXCEPTION

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

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);
3629: END IF;
3630:
3631: EXCEPTION
3632: WHEN others THEN

Line 3633: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3629: END IF;
3630:
3631: EXCEPTION
3632: WHEN others THEN
3633: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3634: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );
3635: END IF;
3636:
3637: fnd_file.put_line(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'STATUS:'||lv_return_status);

Line 3634: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );

3630:
3631: EXCEPTION
3632: WHEN others THEN
3633: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3634: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );
3635: END IF;
3636:
3637: fnd_file.put_line(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'STATUS:'||lv_return_status);
3638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3689: l_awd_prc_status VARCHAR2(30);
3690:
3691: BEGIN
3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Auto FA Rec processing for APM ID: ' || p_apm_id || ' Person ID: ' || p_person_id);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Interface Record Email Address : ' || g_isir_intrface_rec.s_email_address_txt );
3696: END IF;
3697:

Line 3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Auto FA Rec processing for APM ID: ' || p_apm_id || ' Person ID: ' || p_person_id);

3690:
3691: BEGIN
3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Auto FA Rec processing for APM ID: ' || p_apm_id || ' Person ID: ' || p_person_id);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Interface Record Email Address : ' || g_isir_intrface_rec.s_email_address_txt );
3696: END IF;
3697:
3698: g_person_id := p_person_id; -- since matched, populate value into global

Line 3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Interface Record Email Address : ' || g_isir_intrface_rec.s_email_address_txt );

3691: BEGIN
3692:
3693: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3694: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Auto FA Rec processing for APM ID: ' || p_apm_id || ' Person ID: ' || p_person_id);
3695: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Interface Record Email Address : ' || g_isir_intrface_rec.s_email_address_txt );
3696: END IF;
3697:
3698: g_person_id := p_person_id; -- since matched, populate value into global
3699:

Line 3721: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3717: insert_fa_base_record( pn_person_id => p_person_id, pn_base_id => lv_base_id); -- OUT parameter
3718: l_chk_fo_ant_data := FALSE; -- bcoz, freshly created student will not have any anticipated data and existing awards
3719: ELSE
3720: -- FA Base record exists
3721: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3722: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','FA Base Record found, base_id= ' ||lv_base_id);
3723: END IF;
3724:
3725: OPEN chk_isir_exist(cp_base_id => lv_base_id);

Line 3722: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','FA Base Record found, base_id= ' ||lv_base_id);

3718: l_chk_fo_ant_data := FALSE; -- bcoz, freshly created student will not have any anticipated data and existing awards
3719: ELSE
3720: -- FA Base record exists
3721: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3722: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','FA Base Record found, base_id= ' ||lv_base_id);
3723: END IF;
3724:
3725: OPEN chk_isir_exist(cp_base_id => lv_base_id);
3726: FETCH chk_isir_exist INTO l_chk_isir_exist;

Line 3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3731: OPEN cur_fabase(cp_base_id => lv_base_id);
3732: FETCH cur_fabase INTO lv_cur_fabase_rec;
3733: CLOSE cur_fabase;
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','ISIR does not exist for base_id= ' ||lv_base_id|| '. ISIR matched record will be inserted.');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Calling update_fa_base_rec() to update FA Base record with the ISIR details.');
3738: END IF;
3739:

Line 3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','ISIR does not exist for base_id= ' ||lv_base_id|| '. ISIR matched record will be inserted.');

3732: FETCH cur_fabase INTO lv_cur_fabase_rec;
3733: CLOSE cur_fabase;
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','ISIR does not exist for base_id= ' ||lv_base_id|| '. ISIR matched record will be inserted.');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Calling update_fa_base_rec() to update FA Base record with the ISIR details.');
3738: END IF;
3739:
3740: update_fa_base_rec( p_fabase_rec => lv_cur_fabase_rec,

Line 3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Calling update_fa_base_rec() to update FA Base record with the ISIR details.');

3733: CLOSE cur_fabase;
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','ISIR does not exist for base_id= ' ||lv_base_id|| '. ISIR matched record will be inserted.');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Calling update_fa_base_rec() to update FA Base record with the ISIR details.');
3738: END IF;
3739:
3740: update_fa_base_rec( p_fabase_rec => lv_cur_fabase_rec,
3741: p_isir_verification_flag => g_isir_intrface_rec.verification_flag);

Line 3802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3798: p_awd_prc_status => l_awd_prc_status
3799: );
3800: END IF;
3801:
3802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Successfully Completed processing Auto Fa Record procedure');
3804: END IF;
3805:
3806: EXCEPTION

Line 3803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Successfully Completed processing Auto Fa Record procedure');

3799: );
3800: END IF;
3801:
3802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.debug','Successfully Completed processing Auto Fa Record procedure');
3804: END IF;
3805:
3806: EXCEPTION
3807: WHEN others THEN

Line 3808: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3804: END IF;
3805:
3806: EXCEPTION
3807: WHEN others THEN
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');

Line 3809: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.auto_fa_rec.exception','The exception is : ' || SQLERRM );

3805:
3806: EXCEPTION
3807: WHEN others THEN
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');

Line 3835: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3831: */
3832:
3833: BEGIN
3834:
3835: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3836: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Review FA Rec processing for APM ID: ' || p_apm_id);
3837: END IF;
3838:
3839: -- call procedure to update the record_status of igf_ap_person_match and match details table

Line 3836: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Review FA Rec processing for APM ID: ' || p_apm_id);

3832:
3833: BEGIN
3834:
3835: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3836: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Review FA Rec processing for APM ID: ' || p_apm_id);
3837: END IF;
3838:
3839: -- call procedure to update the record_status of igf_ap_person_match and match details table
3840: update_prsn_match_rec_status(p_apm_id => p_apm_id,

Line 3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3847:
3848: --Incrementing the count of review records
3849: g_review_count := g_review_count + 1 ; -- update count
3850:
3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Successfully Completed processing Review FA Record procedure');
3853: END IF;
3854:
3855: EXCEPTION

Line 3852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Successfully Completed processing Review FA Record procedure');

3848: --Incrementing the count of review records
3849: g_review_count := g_review_count + 1 ; -- update count
3850:
3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.debug','Successfully Completed processing Review FA Record procedure');
3853: END IF;
3854:
3855: EXCEPTION
3856: WHEN others THEN

Line 3857: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3853: END IF;
3854:
3855: EXCEPTION
3856: WHEN others THEN
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');

Line 3858: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.rvw_fa_rec.exception','The exception is : ' || SQLERRM );

3854:
3855: EXCEPTION
3856: WHEN others THEN
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');

Line 3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3890:
3891: BEGIN
3892:
3893:
3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Unmatched rec processing for APM ID: ' || p_apm_id);
3896: END IF;
3897: log_debug_message('Before Create Person');
3898:

Line 3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Unmatched rec processing for APM ID: ' || p_apm_id);

3891: BEGIN
3892:
3893:
3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Unmatched rec processing for APM ID: ' || p_apm_id);
3896: END IF;
3897: log_debug_message('Before Create Person');
3898:
3899: -- Creation of Person record for the unmatched record

Line 3910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
3913:
3914:

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

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;
3913:
3914:
3915: IF lv_person_id IS NOT NULL THEN

Line 3917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3913:
3914:
3915: IF lv_person_id IS NOT NULL THEN
3916:
3917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Creating Address');
3919: END IF;
3920:
3921: -- create person address

Line 3918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Creating Address');

3914:
3915: IF lv_person_id IS NOT NULL THEN
3916:
3917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Creating Address');
3919: END IF;
3920:
3921: -- create person address
3922: create_person_addr_record(lv_person_id); -- igs_pe_addr_pkg.insert_row();

Line 3928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3924: -- Admission inquiry record
3925: IF g_create_inquiry = 'Y' THEN
3926: IF NOT check_ptyp_code(lv_person_id) THEN
3927:
3928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Before calling Create Admission Record');
3930: END IF;
3931:
3932: create_admission_rec(lv_person_id,g_isir_intrface_rec.batch_year_num);

Line 3929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Before calling Create Admission Record');

3925: IF g_create_inquiry = 'Y' THEN
3926: IF NOT check_ptyp_code(lv_person_id) THEN
3927:
3928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Before calling Create Admission Record');
3930: END IF;
3931:
3932: create_admission_rec(lv_person_id,g_isir_intrface_rec.batch_year_num);
3933: END IF;

Line 3952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3948: -- get the payment ISIR flag value
3949: l_pymt_isir_flag := is_payment_isir(p_primary_efc_amt => g_isir_intrface_rec.primary_efc_amt);
3950:
3951:
3952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3953: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Before Inserting ISIR Matched record ');
3954: END IF;
3955:
3956: -- create ISIR Matched record

Line 3953: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Before Inserting ISIR Matched record ');

3949: l_pymt_isir_flag := is_payment_isir(p_primary_efc_amt => g_isir_intrface_rec.primary_efc_amt);
3950:
3951:
3952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3953: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Before Inserting ISIR Matched record ');
3954: END IF;
3955:
3956: -- create ISIR Matched record
3957: insert_isir_matched_rec(cp_isir_int_rec => g_isir_intrface_rec,

Line 4011: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4007:
4008: END IF; -- lv_person_id
4009:
4010:
4011: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4012: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Successfully Completed processing Unmatched record procedure. Person ID ' || lv_person_id);
4013: END IF;
4014: log_debug_message('Compeleted Unmatched rec processing with Force add');
4015:

Line 4012: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Successfully Completed processing Unmatched record procedure. Person ID ' || lv_person_id);

4008: END IF; -- lv_person_id
4009:
4010:
4011: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4012: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.debug','Successfully Completed processing Unmatched record procedure. Person ID ' || lv_person_id);
4013: END IF;
4014: log_debug_message('Compeleted Unmatched rec processing with Force add');
4015:
4016: EXCEPTION

Line 4018: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4014: log_debug_message('Compeleted Unmatched rec processing with Force add');
4015:
4016: EXCEPTION
4017: WHEN others THEN
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');

Line 4019: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );

4015:
4016: EXCEPTION
4017: WHEN others THEN
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');

Line 4082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4078: l_primary_match_score NUMBER;
4079:
4080: BEGIN
4081:
4082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Deriving Matching score values. APM_ID: ' || p_apm_id || ', Person_ID: ' || p_person_id);
4084: END IF;
4085:
4086: l_ssn_match := 0;

Line 4083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Deriving Matching score values. APM_ID: ' || p_apm_id || ', Person_ID: ' || p_person_id);

4079:
4080: BEGIN
4081:
4082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Deriving Matching score values. APM_ID: ' || p_apm_id || ', Person_ID: ' || p_person_id);
4084: END IF;
4085:
4086: l_ssn_match := 0;
4087: l_given_name_match := 0;

Line 4135: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4131: END IF;
4132: END IF;
4133:
4134: l_primary_match_score := NVL(l_ssn_match,0) + NVL(l_given_name_match,0) + NVL(l_surname_match,0);
4135: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Total Primary Matching Attributes score : ' || l_primary_match_score);
4137: END IF;
4138:
4139: -- =============== SECOND MATCH ATTRIBUTES ===============

Line 4136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Total Primary Matching Attributes score : ' || l_primary_match_score);

4132: END IF;
4133:
4134: l_primary_match_score := NVL(l_ssn_match,0) + NVL(l_given_name_match,0) + NVL(l_surname_match,0);
4135: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Total Primary Matching Attributes score : ' || l_primary_match_score);
4137: END IF;
4138:
4139: -- =============== SECOND MATCH ATTRIBUTES ===============
4140:

Line 4252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4248: NVL(l_email_id_match,0) +
4249: NVL(l_dob_match,0) +
4250: NVL(l_gender_match,0) ;
4251:
4252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Total Match Score calculated is ' || p_match_dtls_rec.match_score);
4254: END IF;
4255: log_debug_message(' SSN MATCH SCORE : ' || l_ssn_match);
4256: log_debug_message(' FNAME MATCH SCORE : ' || l_given_name_match);

Line 4253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Total Match Score calculated is ' || p_match_dtls_rec.match_score);

4249: NVL(l_dob_match,0) +
4250: NVL(l_gender_match,0) ;
4251:
4252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Total Match Score calculated is ' || p_match_dtls_rec.match_score);
4254: END IF;
4255: log_debug_message(' SSN MATCH SCORE : ' || l_ssn_match);
4256: log_debug_message(' FNAME MATCH SCORE : ' || l_given_name_match);
4257: log_debug_message(' LNAME MATCH SCORE : ' || l_surname_match);

Line 4315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4311: x_email_id_match => l_email_id_match
4312: );
4313:
4314: RAM_I_MD := RAM_I_MD + 1;
4315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Inserted match details record. AMD_ID: ' || chk_match_dtls_exists_rec.amd_id);
4317: END IF;
4318: log_debug_message(' Inserted Match Details record. AMD ID: ' || chk_match_dtls_exists_rec.amd_id || ' Person ID: ' || p_person_id);
4319:

Line 4316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Inserted match details record. AMD_ID: ' || chk_match_dtls_exists_rec.amd_id);

4312: );
4313:
4314: RAM_I_MD := RAM_I_MD + 1;
4315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Inserted match details record. AMD_ID: ' || chk_match_dtls_exists_rec.amd_id);
4317: END IF;
4318: log_debug_message(' Inserted Match Details record. AMD ID: ' || chk_match_dtls_exists_rec.amd_id || ' Person ID: ' || p_person_id);
4319:
4320:

Line 4358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4354: x_email_id_match => chk_match_dtls_exists_rec.email_id_match
4355: );
4356:
4357: RAM_U_MD := RAM_U_MD + 1;
4358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Updated match details record. APM ID: ' || p_apm_id || ' AMD ID: ' || chk_match_dtls_exists_rec.amd_id);
4360: END IF;
4361:
4362: END IF;

Line 4359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Updated match details record. APM ID: ' || p_apm_id || ' AMD ID: ' || chk_match_dtls_exists_rec.amd_id);

4355: );
4356:
4357: RAM_U_MD := RAM_U_MD + 1;
4358: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4359: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.debug','Updated match details record. APM ID: ' || p_apm_id || ' AMD ID: ' || chk_match_dtls_exists_rec.amd_id);
4360: END IF;
4361:
4362: END IF;
4363:

Line 4366: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4362: END IF;
4363:
4364: EXCEPTION
4365: WHEN others THEN
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');

Line 4367: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );

4363:
4364: EXCEPTION
4365: WHEN others THEN
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' );

Line 4440: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4436: lv_tot NUMBER;
4437:
4438: BEGIN
4439:
4440: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Beginning Person Matching ');
4442: END IF;
4443:
4444: -- get SSN by removing any special characters

Line 4441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Beginning Person Matching ');

4437:
4438: BEGIN
4439:
4440: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4441: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Beginning Person Matching ');
4442: END IF;
4443:
4444: -- get SSN by removing any special characters
4445: lv_ssn := remove_spl_chr(g_isir_intrface_rec.current_ssn_txt) ;

Line 4469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4465: END IF;
4466:
4467: log_debug_message(' About to execute the main matching query. ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
4468:
4469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4470: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Matching Attribute Values: ');
4471: END IF;
4472:
4473: -- main query to fetch all the records from OSS which match

Line 4470: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Matching Attribute Values: ');

4466:
4467: log_debug_message(' About to execute the main matching query. ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
4468:
4469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4470: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Matching Attribute Values: ');
4471: END IF;
4472:
4473: -- main query to fetch all the records from OSS which match
4474: SELECT rec_type,

Line 4564: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4560: RAM_MQ := RAM_MQ +1;
4561: lv_tot := t_rec_tab.COUNT;
4562:
4563:
4564: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Total No. of matched records found : ' || lv_tot);
4566: END IF;
4567: log_debug_message(' Matching query execution completed. Fetched recs ' || lv_tot || ' .Time : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
4568:

Line 4565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Total No. of matched records found : ' || lv_tot);

4561: lv_tot := t_rec_tab.COUNT;
4562:
4563:
4564: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4565: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Total No. of matched records found : ' || lv_tot);
4566: END IF;
4567: log_debug_message(' Matching query execution completed. Fetched recs ' || lv_tot || ' .Time : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
4568:
4569: -- Loop thru and process a person at a time

Line 4575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4571: LOOP
4572:
4573: l_process_rec := 'N'; -- initialize flag variable
4574:
4575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Processing for Person_id: ' || t_pid_tab(l_row) || ', Match in: ' || t_rec_tab(l_row));
4577: END IF;
4578:
4579: log_debug_message(' Processing match rec for Person ID: ' || t_pid_tab(l_row) || '. Rec No. ' || l_row);

Line 4576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Processing for Person_id: ' || t_pid_tab(l_row) || ', Match in: ' || t_rec_tab(l_row));

4572:
4573: l_process_rec := 'N'; -- initialize flag variable
4574:
4575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Processing for Person_id: ' || t_pid_tab(l_row) || ', Match in: ' || t_rec_tab(l_row));
4577: END IF;
4578:
4579: log_debug_message(' Processing match rec for Person ID: ' || t_pid_tab(l_row) || '. Rec No. ' || l_row);
4580: IF t_rec_tab(l_row) = 'OSS' THEN

Line 4602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4598: END IF;
4599: CLOSE check_oss_person_match;
4600:
4601: log_debug_message(' HRMS MATCH REC ?????. SSN : ' || oss_person_match_rec.ssn_txt || '. Process Record : ' || l_process_rec);
4602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','HRMS Matching Record. SSN: ' || t_prsn_ssn(l_row) || '. Process flag : ' || l_process_rec);
4604: END IF;
4605: END IF; -- t_rec_tab
4606:

Line 4603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','HRMS Matching Record. SSN: ' || t_prsn_ssn(l_row) || '. Process flag : ' || l_process_rec);

4599: CLOSE check_oss_person_match;
4600:
4601: log_debug_message(' HRMS MATCH REC ?????. SSN : ' || oss_person_match_rec.ssn_txt || '. Process Record : ' || l_process_rec);
4602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','HRMS Matching Record. SSN: ' || t_prsn_ssn(l_row) || '. Process flag : ' || l_process_rec);
4604: END IF;
4605: END IF; -- t_rec_tab
4606:
4607:

Line 4621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4617: match_details_rec.birth_date := t_dob_tab(l_row);
4618: match_details_rec.gender_txt := t_gender(l_row);
4619:
4620: log_debug_message(' calling calculate match score proc.... ');
4621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4622: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Before calling calculate_match_score procedure... ');
4623: END IF;
4624:
4625: -- call the procedure to match the attributes, compute score and insert rec into match details table

Line 4622: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Before calling calculate_match_score procedure... ');

4618: match_details_rec.gender_txt := t_gender(l_row);
4619:
4620: log_debug_message(' calling calculate match score proc.... ');
4621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4622: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Before calling calculate_match_score procedure... ');
4623: END IF;
4624:
4625: -- call the procedure to match the attributes, compute score and insert rec into match details table
4626: calculate_match_score(p_isir_rec => g_isir_intrface_rec,

Line 4637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4633:
4634: END IF;
4635: END LOOP;
4636:
4637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4638: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Successfully Completed processing perform_record_matching');
4639: END IF;
4640: log_debug_message(' END of Perform record matching....... ');
4641:

Line 4638: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Successfully Completed processing perform_record_matching');

4634: END IF;
4635: END LOOP;
4636:
4637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4638: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Successfully Completed processing perform_record_matching');
4639: END IF;
4640: log_debug_message(' END of Perform record matching....... ');
4641:
4642: EXCEPTION

Line 4644: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4640: log_debug_message(' END of Perform record matching....... ');
4641:
4642: EXCEPTION
4643: WHEN OTHERS THEN
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');

Line 4645: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );

4641:
4642: EXCEPTION
4643: WHEN OTHERS THEN
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' );

Line 4719: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4715:
4716: BEGIN
4717:
4718: log_debug_message(' Beginning Process Unidentified rec proc ');
4719: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4720: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Beginning processing Unidentified record.');
4721: END IF;
4722:
4723: -- Unidentified ISIR. Hence first insert a record in person match table.

Line 4720: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Beginning processing Unidentified record.');

4716: BEGIN
4717:
4718: log_debug_message(' Beginning Process Unidentified rec proc ');
4719: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4720: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Beginning processing Unidentified record.');
4721: END IF;
4722:
4723: -- Unidentified ISIR. Hence first insert a record in person match table.
4724: -- first check whether a record already exists for this Int rec si_id

Line 4746: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4742: x_mode => 'R');
4743:
4744: log_debug_message(' Inserted New Person Match record. APM ID: ' || ln_apm_id);
4745:
4746: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Inserted record into Person Match table with APM_ID: ' || ln_apm_id);
4748: END IF;
4749:
4750: ELSE

Line 4747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Inserted record into Person Match table with APM_ID: ' || ln_apm_id);

4743:
4744: log_debug_message(' Inserted New Person Match record. APM ID: ' || ln_apm_id);
4745:
4746: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Inserted record into Person Match table with APM_ID: ' || ln_apm_id);
4748: END IF;
4749:
4750: ELSE
4751: CLOSE cur_prsn_match;

Line 4768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4764:
4765: ln_apm_id := person_match_rec.apm_id; -- assign it to local variable which can be used for passing to person match proc
4766:
4767: log_debug_message(' Updated Person Match record. APM ID: ' || ln_apm_id);
4768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Updated record in Person Match table with APM_ID: ' || ln_apm_id);
4770: END IF;
4771: END IF; -- cur_prsn_match%NOTFOUND
4772:

Line 4769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Updated record in Person Match table with APM_ID: ' || ln_apm_id);

4765: ln_apm_id := person_match_rec.apm_id; -- assign it to local variable which can be used for passing to person match proc
4766:
4767: log_debug_message(' Updated Person Match record. APM ID: ' || ln_apm_id);
4768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.perform_record_matching.debug','Updated record in Person Match table with APM_ID: ' || ln_apm_id);
4770: END IF;
4771: END IF; -- cur_prsn_match%NOTFOUND
4772:
4773:

Line 4786: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4782: OPEN cur_get_max_data(ln_apm_id);
4783: FETCH cur_get_max_data INTO lv_person_id, ln_match_score;
4784: CLOSE cur_get_max_data;
4785:
4786: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4787: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. APM ID: ' || ln_apm_id || ' Person ID: ' || lv_person_id);
4788: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. Total Score: ' || ln_match_score);
4789: END IF;
4790: log_debug_message(' Max score matched record found. Person ID: ' || lv_person_id || ' Score: ' || ln_match_score);

Line 4787: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. APM ID: ' || ln_apm_id || ' Person ID: ' || lv_person_id);

4783: FETCH cur_get_max_data INTO lv_person_id, ln_match_score;
4784: CLOSE cur_get_max_data;
4785:
4786: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4787: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. APM ID: ' || ln_apm_id || ' Person ID: ' || lv_person_id);
4788: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. Total Score: ' || ln_match_score);
4789: END IF;
4790: log_debug_message(' Max score matched record found. Person ID: ' || lv_person_id || ' Score: ' || ln_match_score);
4791:

Line 4788: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. Total Score: ' || ln_match_score);

4784: CLOSE cur_get_max_data;
4785:
4786: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4787: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. APM ID: ' || ln_apm_id || ' Person ID: ' || lv_person_id);
4788: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Matching record with Max Total Score. Total Score: ' || ln_match_score);
4789: END IF;
4790: log_debug_message(' Max score matched record found. Person ID: ' || lv_person_id || ' Score: ' || ln_match_score);
4791:
4792: -- compare total score against the setup scores

Line 4801: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4797: p_seq_num => g_ci_sequence_number
4798: );
4799: FETCH c_base_id INTO l_base_id;
4800: IF c_base_id%FOUND THEN
4801: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Base_id ' ||l_base_id|| ' found for mached person_id ' ||lv_person_id);
4803: END IF;
4804:
4805: -- Chk if ISIR record exists for this matched person

Line 4802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Base_id ' ||l_base_id|| ' found for mached person_id ' ||lv_person_id);

4798: );
4799: FETCH c_base_id INTO l_base_id;
4800: IF c_base_id%FOUND THEN
4801: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4802: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Base_id ' ||l_base_id|| ' found for mached person_id ' ||lv_person_id);
4803: END IF;
4804:
4805: -- Chk if ISIR record exists for this matched person
4806: OPEN chk_isir_exist(cp_base_id => l_base_id);

Line 4812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4808:
4809: IF (chk_isir_exist%NOTFOUND) THEN
4810: -- ISIR does not exist for this matched person. So create new ISIR and move it to MATCHED.
4811:
4812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','ISIR does NOT exist for base_id ' ||l_base_id|| '. Calling auto_fa_rec() to create new ISIR and mark it as MATCHED.');
4814: END IF;
4815:
4816: auto_fa_rec(

Line 4813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','ISIR does NOT exist for base_id ' ||l_base_id|| '. Calling auto_fa_rec() to create new ISIR and mark it as MATCHED.');

4809: IF (chk_isir_exist%NOTFOUND) THEN
4810: -- ISIR does not exist for this matched person. So create new ISIR and move it to MATCHED.
4811:
4812: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4813: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','ISIR does NOT exist for base_id ' ||l_base_id|| '. Calling auto_fa_rec() to create new ISIR and mark it as MATCHED.');
4814: END IF;
4815:
4816: auto_fa_rec(
4817: p_person_id => lv_person_id ,

Line 4828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4824: -- from the new ISIR in the interface table. In both cases, we move the ISIR for manual review.
4825:
4826: rvw_fa_rec(p_apm_id => ln_apm_id);
4827:
4828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4829: fnd_log.string(fnd_log.level_statement,
4830: 'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug',
4831: 'ISIR exists for base_id ' ||l_base_id|| '. But the tran_num does NOT match with interface table. Marked ISIR for REVIEW');
4832: END IF;

Line 4829: fnd_log.string(fnd_log.level_statement,

4825:
4826: rvw_fa_rec(p_apm_id => ln_apm_id);
4827:
4828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4829: fnd_log.string(fnd_log.level_statement,
4830: 'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug',
4831: 'ISIR exists for base_id ' ||l_base_id|| '. But the tran_num does NOT match with interface table. Marked ISIR for REVIEW');
4832: END IF;
4833: END IF;

Line 4880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4876:
4877: END IF;
4878: END IF ; -- ln_match_score
4879:
4880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Completed process_unidentified_isir_rec successfully..');
4882: END IF;
4883: log_debug_message(' Completed process_unidentified_isir_rec Proc');
4884:

Line 4881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Completed process_unidentified_isir_rec successfully..');

4877: END IF;
4878: END IF ; -- ln_match_score
4879:
4880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.debug','Completed process_unidentified_isir_rec successfully..');
4882: END IF;
4883: log_debug_message(' Completed process_unidentified_isir_rec Proc');
4884:
4885: EXCEPTION

Line 4887: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4883: log_debug_message(' Completed process_unidentified_isir_rec Proc');
4884:
4885: EXCEPTION
4886: WHEN OTHERS THEN
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');

Line 4888: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );

4884:
4885: EXCEPTION
4886: WHEN OTHERS THEN
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');

Line 5043: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5039:
5040:
5041: -- Process Corrections
5042: -- Load the pl/sql Table
5043: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Before processing the correction items');
5045: END IF;
5046:
5047: n := 1 ;

Line 5044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Before processing the correction items');

5040:
5041: -- Process Corrections
5042: -- Load the pl/sql Table
5043: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Before processing the correction items');
5045: END IF;
5046:
5047: n := 1 ;
5048: lv_corr_tab.extend;

Line 5174: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5170: lv_corr_tab(n).column_value := g_isir_intrface_rec.fathers_highst_edu_lvl_type ;
5171: n := n + 1 ;
5172: lv_corr_tab.extend;
5173:
5174: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5175: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items1');
5176: END IF;
5177:
5178: lv_corr_tab(n).column_name := 'MOTHERS_HIGHEST_EDU_LEVEL';

Line 5175: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items1');

5171: n := n + 1 ;
5172: lv_corr_tab.extend;
5173:
5174: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5175: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items1');
5176: END IF;
5177:
5178: lv_corr_tab(n).column_name := 'MOTHERS_HIGHEST_EDU_LEVEL';
5179: lv_corr_tab(n).column_value := g_isir_intrface_rec.mothers_highst_edu_lvl_type ;

Line 5298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5294: lv_corr_tab(n).column_value := g_isir_intrface_rec.s_total_from_wsc_amt ;
5295: n := n + 1 ;
5296: lv_corr_tab.extend;
5297:
5298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','processing correction items2');
5300: END IF;
5301:
5302: lv_corr_tab(n).column_name := 'S_INVESTMENT_NETWORTH';

Line 5299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','processing correction items2');

5295: n := n + 1 ;
5296: lv_corr_tab.extend;
5297:
5298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','processing correction items2');
5300: END IF;
5301:
5302: lv_corr_tab(n).column_name := 'S_INVESTMENT_NETWORTH';
5303: lv_corr_tab(n).column_value := g_isir_intrface_rec.s_investment_networth_amt ;

Line 5417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5413: lv_corr_tab(n).column_value := g_isir_intrface_rec.age_older_parent_num ;
5414: n := n + 1 ;
5415: lv_corr_tab.extend;
5416:
5417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items3');
5419: END IF;
5420:
5421: lv_corr_tab(n).column_name := 'P_TAX_RETURN_STATUS';

Line 5418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items3');

5414: n := n + 1 ;
5415: lv_corr_tab.extend;
5416:
5417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items3');
5419: END IF;
5420:
5421: lv_corr_tab(n).column_name := 'P_TAX_RETURN_STATUS';
5422: lv_corr_tab(n).column_value := g_isir_intrface_rec.p_tax_return_status_type ;

Line 5536: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5532: lv_corr_tab(n).column_value := g_isir_intrface_rec.fourth_college_cd ;
5533: n := n + 1 ;
5534: lv_corr_tab.extend;
5535:
5536: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5537: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items4');
5538: END IF;
5539:
5540: lv_corr_tab(n).column_name := 'FOURTH_HOUSE_PLAN';

Line 5537: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items4');

5533: n := n + 1 ;
5534: lv_corr_tab.extend;
5535:
5536: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5537: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items4');
5538: END IF;
5539:
5540: lv_corr_tab(n).column_name := 'FOURTH_HOUSE_PLAN';
5541: lv_corr_tab(n).column_value := g_isir_intrface_rec.fourth_house_plan_type ;

Line 5660: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5656: lv_corr_tab(n).column_value := g_isir_intrface_rec.assum_override_1_flag ;
5657: n := n + 1 ;
5658: lv_corr_tab.extend;
5659:
5660: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5661: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items5');
5662: END IF;
5663:
5664: lv_corr_tab(n).column_name := 'ASSUM_OVERRIDE_2';

Line 5661: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items5');

5657: n := n + 1 ;
5658: lv_corr_tab.extend;
5659:
5660: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5661: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items5');
5662: END IF;
5663:
5664: lv_corr_tab(n).column_name := 'ASSUM_OVERRIDE_2';
5665: lv_corr_tab(n).column_value := g_isir_intrface_rec.assum_override_2_flag ;

Line 5904: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

5900: lv_corr_tab(n).column_value := g_isir_intrface_rec.sec_efc_type ;
5901: n := n + 1 ;
5902: lv_corr_tab.extend;
5903:
5904: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5905: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items6');
5906: END IF;
5907:
5908: lv_corr_tab(n).column_name := 'PRIMARY_ALTERNATE_MONTH_1';

Line 5905: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items6');

5901: n := n + 1 ;
5902: lv_corr_tab.extend;
5903:
5904: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5905: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items6');
5906: END IF;
5907:
5908: lv_corr_tab(n).column_name := 'PRIMARY_ALTERNATE_MONTH_1';
5909: lv_corr_tab(n).column_value := g_isir_intrface_rec.primary_alt_month_1_amt ;

Line 6223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6219: lv_corr_tab(n).column_value := g_isir_intrface_rec.secsca_amt ;
6220: n := n + 1 ;
6221: lv_corr_tab.extend;
6222:
6223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items7');
6225: END IF;
6226:
6227: lv_corr_tab(n).column_name := 'SECFTI';

Line 6224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items7');

6220: n := n + 1 ;
6221: lv_corr_tab.extend;
6222:
6223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Processing correction items7');
6225: END IF;
6226:
6227: lv_corr_tab(n).column_name := 'SECFTI';
6228: lv_corr_tab(n).column_value := g_isir_intrface_rec.secfti_amt ;

Line 6452: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6448: -- Initialised to assume that the user has no New corrections
6449: lv_all_corr_rcvd := 'Y' ;
6450: l_corr_stat := 'ACKNOWLEDGED' ;
6451:
6452: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6453: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Correction poulation completed.');
6454: END IF;
6455:
6456: FOR isir_corr_rec IN cur_ISIR_corr(g_base_id, l_corr_stat )

Line 6453: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Correction poulation completed.');

6449: lv_all_corr_rcvd := 'Y' ;
6450: l_corr_stat := 'ACKNOWLEDGED' ;
6451:
6452: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6453: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Correction poulation completed.');
6454: END IF;
6455:
6456: FOR isir_corr_rec IN cur_ISIR_corr(g_base_id, l_corr_stat )
6457: LOOP

Line 6538: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6534:
6535: -- Get the next correction.
6536: END LOOP; -- isir_corr_rec
6537:
6538: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6539: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Corrections updated...');
6540: END IF;
6541:
6542:

Line 6539: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Corrections updated...');

6535: -- Get the next correction.
6536: END LOOP; -- isir_corr_rec
6537:
6538: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6539: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.validate_correction_school.debug','Corrections updated...');
6540: END IF;
6541:
6542:
6543: IF p_new_isir_is_pymnt_isir = 'Y' THEN

Line 6546: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6542:
6543: IF p_new_isir_is_pymnt_isir = 'Y' THEN
6544: -- Payment ISIR is got changed
6545: -- So update the Payment ISIR ID for all existing correction records that Have not been udated
6546: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6547: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Before updating the paymnet ISIR');
6548: END IF;
6549:
6550: FOR l_cur_isir_corr_pymnt IN cur_isir_corr_pymt(p_old_payment_isir)

Line 6547: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Before updating the paymnet ISIR');

6543: IF p_new_isir_is_pymnt_isir = 'Y' THEN
6544: -- Payment ISIR is got changed
6545: -- So update the Payment ISIR ID for all existing correction records that Have not been udated
6546: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6547: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Before updating the paymnet ISIR');
6548: END IF;
6549:
6550: FOR l_cur_isir_corr_pymnt IN cur_isir_corr_pymt(p_old_payment_isir)
6551: LOOP

Line 6575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6571: END IF;
6572:
6573: END LOOP;
6574:
6575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Updated ISIR Information for Correction Items to New Payment ISIR');
6577: END IF;
6578: END IF; -- payment isir check
6579:

Line 6576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Updated ISIR Information for Correction Items to New Payment ISIR');

6572:
6573: END LOOP;
6574:
6575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Updated ISIR Information for Correction Items to New Payment ISIR');
6577: END IF;
6578: END IF; -- payment isir check
6579:
6580:

Line 6587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6583: -- Since all corrections are recieved, delete existing CORRECTION ISIR record in the ISIR matched table
6584: -- (so that the save as correction record functionality is enabled in the ISIR review SS Page)
6585: -- Return Y to OUT parameter so that the newly created ISIR, can now be made as the Active ISIR
6586:
6587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','All Corrections received..');
6589: END IF;
6590:
6591: -- Bug 4403807 - changed the argument to get_isir from p_new_isir_id to NVL(p_new_isir_id,p_new_payment_isir)

Line 6588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','All Corrections received..');

6584: -- (so that the save as correction record functionality is enabled in the ISIR review SS Page)
6585: -- Return Y to OUT parameter so that the newly created ISIR, can now be made as the Active ISIR
6586:
6587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','All Corrections received..');
6589: END IF;
6590:
6591: -- Bug 4403807 - changed the argument to get_isir from p_new_isir_id to NVL(p_new_isir_id,p_new_payment_isir)
6592: FOR cur_new_isir_rec IN get_ISIR(NVL(p_new_isir_id,p_new_payment_isir)) LOOP

Line 6604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6600: -- now delete the correction isir
6601: IF l_cor_isir.row_id IS NOT NULL THEN
6602: igf_ap_isir_matched_pkg.delete_row(l_cor_isir.row_id); -- delete the correction type isir.
6603:
6604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Deleted existing Correction ISIR ID: ' || l_cor_isir.isir_id);
6606: END IF;
6607: END IF;
6608:

Line 6605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Deleted existing Correction ISIR ID: ' || l_cor_isir.isir_id);

6601: IF l_cor_isir.row_id IS NOT NULL THEN
6602: igf_ap_isir_matched_pkg.delete_row(l_cor_isir.row_id); -- delete the correction type isir.
6603:
6604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Deleted existing Correction ISIR ID: ' || l_cor_isir.isir_id);
6606: END IF;
6607: END IF;
6608:
6609: -- update the new ISIR record to make it an ACTIVE ISIR as all corrections have been received.

Line 6626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6622: p_anticip_status => l_anticip_status,
6623: p_awd_prc_status => l_awd_prc_status
6624: );
6625:
6626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6627: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Made the new ISIR as Active ISIR for ISIR ID: ' || cur_new_isir_rec.isir_id);
6628: END IF;
6629: END LOOP;
6630: END IF; -- lv_all_corr_rcvd = 'Y'

Line 6627: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Made the new ISIR as Active ISIR for ISIR ID: ' || cur_new_isir_rec.isir_id);

6623: p_awd_prc_status => l_awd_prc_status
6624: );
6625:
6626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6627: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Made the new ISIR as Active ISIR for ISIR ID: ' || cur_new_isir_rec.isir_id);
6628: END IF;
6629: END LOOP;
6630: END IF; -- lv_all_corr_rcvd = 'Y'
6631:

Line 6632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6628: END IF;
6629: END LOOP;
6630: END IF; -- lv_all_corr_rcvd = 'Y'
6631:
6632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6633: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Successfully processed corrections.');
6634: END IF;
6635:
6636: EXCEPTION

Line 6633: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Successfully processed corrections.');

6629: END LOOP;
6630: END IF; -- lv_all_corr_rcvd = 'Y'
6631:
6632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6633: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.debug','Successfully processed corrections.');
6634: END IF;
6635:
6636: EXCEPTION
6637: WHEN OTHERS THEN

Line 6638: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

6634: END IF;
6635:
6636: EXCEPTION
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');

Line 6639: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_corrections.exception','The exception is : ' || SQLERRM );

6635:
6636: EXCEPTION
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);

Line 6674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6670: lv_corrected_isir NUMBER;
6671: BEGIN
6672:
6673: log_debug_message(' Beginning process_non_payment_isir Proc');
6674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6675: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.debug','Beginning processing the ISIR as a NON Payment ISIR.');
6676: END IF;
6677:
6678: -- call procedure to insert a row into isir matched table.

Line 6675: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.debug','Beginning processing the ISIR as a NON Payment ISIR.');

6671: BEGIN
6672:
6673: log_debug_message(' Beginning process_non_payment_isir Proc');
6674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6675: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.debug','Beginning processing the ISIR as a NON Payment ISIR.');
6676: END IF;
6677:
6678: -- call procedure to insert a row into isir matched table.
6679: insert_isir_matched_rec(cp_isir_int_rec => g_isir_intrface_rec,

Line 6718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6714: update_isir_int_record (p_si_id => g_isir_intrface_rec.si_id,
6715: p_isir_rec_status => 'MATCHED',
6716: p_match_code => NULL);
6717:
6718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6719: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.debug','Completed processing the ISIR as a NON Payment ISIR.');
6720: END IF;
6721: log_debug_message(' Completed process_non_payment_isir Proc');
6722:

Line 6719: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.debug','Completed processing the ISIR as a NON Payment ISIR.');

6715: p_isir_rec_status => 'MATCHED',
6716: p_match_code => NULL);
6717:
6718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6719: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.debug','Completed processing the ISIR as a NON Payment ISIR.');
6720: END IF;
6721: log_debug_message(' Completed process_non_payment_isir Proc');
6722:
6723: EXCEPTION

Line 6725: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

6721: log_debug_message(' Completed process_non_payment_isir Proc');
6722:
6723: EXCEPTION
6724: WHEN OTHERS THEN
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');

Line 6726: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_non_payment_isir.exception','The exception is : ' || SQLERRM );

6722:
6723: EXCEPTION
6724: WHEN OTHERS THEN
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');

Line 6827: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6823: g_person_id := lv_cur_fabase_rec.person_id;
6824:
6825: -- Check if the New ISIR is an Original ISIR or a Correction ISIR.
6826: IF g_isir_intrface_rec.processed_rec_type = 'H' THEN -- This is an CORRECTION ISIR
6827: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','This ISIR is a Correction ISIR');
6829: END IF;
6830:
6831: -- since correction ISIR. Perform school validation and determine flags for further processing

Line 6828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','This ISIR is a Correction ISIR');

6824:
6825: -- Check if the New ISIR is an Original ISIR or a Correction ISIR.
6826: IF g_isir_intrface_rec.processed_rec_type = 'H' THEN -- This is an CORRECTION ISIR
6827: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6828: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','This ISIR is a Correction ISIR');
6829: END IF;
6830:
6831: -- since correction ISIR. Perform school validation and determine flags for further processing
6832: validate_correction_school(p_payment_isir => lv_payment_isir);

Line 6834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6830:
6831: -- since correction ISIR. Perform school validation and determine flags for further processing
6832: validate_correction_school(p_payment_isir => lv_payment_isir);
6833:
6834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','validate_correction_school returns Payment ISIR Flag as ' || lv_payment_isir);
6836: END IF;
6837: END IF;
6838:

Line 6835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','validate_correction_school returns Payment ISIR Flag as ' || lv_payment_isir);

6831: -- since correction ISIR. Perform school validation and determine flags for further processing
6832: validate_correction_school(p_payment_isir => lv_payment_isir);
6833:
6834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6835: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','validate_correction_school returns Payment ISIR Flag as ' || lv_payment_isir);
6836: END IF;
6837: END IF;
6838:
6839:

Line 6851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6847: CLOSE cur_old_pymt_isir;
6848:
6849: IF old_pymt_isir_rec.isir_id IS NOT NULL THEN -- -- i.e. there already exists a payment isir.
6850:
6851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment ISIR Rec exists. Old Payment ISIR No: ' || old_pymt_isir_rec.isir_id);
6853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment Transaction No.: ' || old_pymt_isir_rec.Transaction_num);
6854: END IF;
6855: log_debug_message('Old Payment ISIR Exists. Making it a Non Payment isir ' || old_pymt_isir_rec.isir_id || ' Trans: ' || old_pymt_isir_rec.Transaction_Num || ' Active: ' || old_pymt_isir_rec.Active_isir);

Line 6852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment ISIR Rec exists. Old Payment ISIR No: ' || old_pymt_isir_rec.isir_id);

6848:
6849: IF old_pymt_isir_rec.isir_id IS NOT NULL THEN -- -- i.e. there already exists a payment isir.
6850:
6851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment ISIR Rec exists. Old Payment ISIR No: ' || old_pymt_isir_rec.isir_id);
6853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment Transaction No.: ' || old_pymt_isir_rec.Transaction_num);
6854: END IF;
6855: log_debug_message('Old Payment ISIR Exists. Making it a Non Payment isir ' || old_pymt_isir_rec.isir_id || ' Trans: ' || old_pymt_isir_rec.Transaction_Num || ' Active: ' || old_pymt_isir_rec.Active_isir);
6856:

Line 6853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment Transaction No.: ' || old_pymt_isir_rec.Transaction_num);

6849: IF old_pymt_isir_rec.isir_id IS NOT NULL THEN -- -- i.e. there already exists a payment isir.
6850:
6851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment ISIR Rec exists. Old Payment ISIR No: ' || old_pymt_isir_rec.isir_id);
6853: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Old Payment Transaction No.: ' || old_pymt_isir_rec.Transaction_num);
6854: END IF;
6855: log_debug_message('Old Payment ISIR Exists. Making it a Non Payment isir ' || old_pymt_isir_rec.isir_id || ' Trans: ' || old_pymt_isir_rec.Transaction_Num || ' Active: ' || old_pymt_isir_rec.Active_isir);
6856:
6857: -- check if PELL is already granted for the old payment isir. If so, log a warning message before updating.

Line 6890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6886: END IF;
6887: -- Making old ISIR non payment
6888: make_old_isir_non_payment(g_base_id);
6889:
6890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6891: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Made the exisiting payment ISIR as Non Payment ISIR');
6892: END IF;
6893: END IF; --old_pymt_isir_rec
6894: END IF; -- lv_payment_isir

Line 6891: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Made the exisiting payment ISIR as Non Payment ISIR');

6887: -- Making old ISIR non payment
6888: make_old_isir_non_payment(g_base_id);
6889:
6890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6891: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Made the exisiting payment ISIR as Non Payment ISIR');
6892: END IF;
6893: END IF; --old_pymt_isir_rec
6894: END IF; -- lv_payment_isir
6895:

Line 6934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6930: p_new_isir_is_pymnt_isir => lv_payment_isir);
6931: END IF; -- lv_payment_isir;
6932:
6933: IF g_isir_intrface_rec.transaction_num_txt > g_max_tran_num THEN
6934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6935: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Incoming Transaction No. > Existing Max Trans and hence Invoking Update Person Info Procedure');
6936: END IF;
6937:
6938: -- This procedure should be called only when the incoming trans num > existing max trans num

Line 6935: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Incoming Transaction No. > Existing Max Trans and hence Invoking Update Person Info Procedure');

6931: END IF; -- lv_payment_isir;
6932:
6933: IF g_isir_intrface_rec.transaction_num_txt > g_max_tran_num THEN
6934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6935: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.debug','Incoming Transaction No. > Existing Max Trans and hence Invoking Update Person Info Procedure');
6936: END IF;
6937:
6938: -- This procedure should be called only when the incoming trans num > existing max trans num
6939: g_called_from_process := TRUE;

Line 6953: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

6949: log_debug_message('Completed processing New Interface record.');
6950:
6951: EXCEPTION
6952: WHEN others THEN
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');

Line 6954: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_new_isir_rec.exception','The exception is : ' || SQLERRM );

6950:
6951: EXCEPTION
6952: WHEN others THEN
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');

Line 7000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

6996: FETCH get_person_cur INTO g_person_id;
6997: CLOSE get_person_cur ;
6998: END IF;
6999:
7000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','p_si_id : ' || g_isir_intrface_rec.si_id || ' , Pell Match Type : ' || g_pell_match_type );
7002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','The g_base_id : ' || g_base_id || ', Person ID: ' || g_person_id);
7003: END IF;
7004:

Line 7001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','p_si_id : ' || g_isir_intrface_rec.si_id || ' , Pell Match Type : ' || g_pell_match_type );

6997: CLOSE get_person_cur ;
6998: END IF;
6999:
7000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','p_si_id : ' || g_isir_intrface_rec.si_id || ' , Pell Match Type : ' || g_pell_match_type );
7002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','The g_base_id : ' || g_base_id || ', Person ID: ' || g_person_id);
7003: END IF;
7004:
7005: -- First delete existing match records, if any, from match tables for this si_id.

Line 7002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','The g_base_id : ' || g_base_id || ', Person ID: ' || g_person_id);

6998: END IF;
6999:
7000: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7001: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','p_si_id : ' || g_isir_intrface_rec.si_id || ' , Pell Match Type : ' || g_pell_match_type );
7002: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.pell_match_type_rec_processing.debug','The g_base_id : ' || g_base_id || ', Person ID: ' || g_person_id);
7003: END IF;
7004:
7005: -- First delete existing match records, if any, from match tables for this si_id.
7006: delete_person_match_rec(p_si_id => g_isir_intrface_rec.si_id,

Line 7046: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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

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

7043: app_exception.raise_exception;
7044:
7045: WHEN OTHERS THEN
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');

Line 7082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7078:
7079: -- update review records count
7080: g_review_count := g_review_count + 1;
7081:
7082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_correction_isir.statement','Updated ISIR Interface record status to REVIEW');
7084: END IF;
7085:
7086: EXCEPTION

Line 7083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_correction_isir.statement','Updated ISIR Interface record status to REVIEW');

7079: -- update review records count
7080: g_review_count := g_review_count + 1;
7081:
7082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_correction_isir.statement','Updated ISIR Interface record status to REVIEW');
7084: END IF;
7085:
7086: EXCEPTION
7087: WHEN others THEN

Line 7088: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7084: END IF;
7085:
7086: EXCEPTION
7087: WHEN others THEN
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');

Line 7089: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_correction_isir.exception','The exception is : ' || SQLERRM );

7085:
7086: EXCEPTION
7087: WHEN others THEN
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');

Line 7216: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7212: -- put such records to REVIEW status.
7213: process_correction_isir;
7214:
7215: ELSE
7216: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7217: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for Max Transaction Number');
7218: END IF;
7219:
7220: --Check if ISIR record exists. If it does, get the max Transaction Number.

Line 7217: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for Max Transaction Number');

7213: process_correction_isir;
7214:
7215: ELSE
7216: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7217: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for Max Transaction Number');
7218: END IF;
7219:
7220: --Check if ISIR record exists. If it does, get the max Transaction Number.
7221: OPEN cur_max_isir ( g_isir_intrface_rec.original_ssn_txt ,

Line 7243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7239: -- populate base id and max transaction num to global variables.
7240: g_base_id := l_max_isir_rec.base_id;
7241: g_max_tran_num := l_max_isir_rec.max_id;
7242:
7243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7244: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for Duplicate');
7245: END IF;
7246:
7247: -- check whether it is a duplicate isir.

Line 7244: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for Duplicate');

7240: g_base_id := l_max_isir_rec.base_id;
7241: g_max_tran_num := l_max_isir_rec.max_id;
7242:
7243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7244: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for Duplicate');
7245: END IF;
7246:
7247: -- check whether it is a duplicate isir.
7248: -- check whether ISIR rec with same transaction Num already exists.

Line 7270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7266: IF lv_valid_isir_flag = 'N' THEN
7267: g_pell_match_type := 'O' ; -- Process the ISIR as a non payment isir
7268: ELSE
7269:
7270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7271: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for ISIR Locking');
7272: END IF;
7273:
7274: log_debug_message('Checking for Payment ISIR being locked');

Line 7271: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for ISIR Locking');

7267: g_pell_match_type := 'O' ; -- Process the ISIR as a non payment isir
7268: ELSE
7269:
7270: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7271: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Checking for ISIR Locking');
7272: END IF;
7273:
7274: log_debug_message('Checking for Payment ISIR being locked');
7275: -- check if the payment isir is locked. If so the locked isir should remain as payment isir.

Line 7288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7284: -- Hence Process this incoming isir as a Non payment isir.
7285: g_pell_match_type := 'O' ;
7286: ELSE
7287: log_debug_message('Checking for Payment ISIR For this person with higher Transaction Number');
7288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Payment ISIR Transaction No. checking');
7290: END IF;
7291:
7292: -- Check whether there already exists a payment isir with transaction number > incoming isir.

Line 7289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Payment ISIR Transaction No. checking');

7285: g_pell_match_type := 'O' ;
7286: ELSE
7287: log_debug_message('Checking for Payment ISIR For this person with higher Transaction Number');
7288: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.debug','Payment ISIR Transaction No. checking');
7290: END IF;
7291:
7292: -- Check whether there already exists a payment isir with transaction number > incoming isir.
7293: -- IF so, the incoming isir should be processed as Non payment isir Else as Payment ISIR.

Line 7314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7310:
7311: END IF; -- cur_max_isir%NOTFOUND
7312:
7313: log_debug_message(' PELL MATCH TYPE for this Interface record : ' || g_pell_match_type);
7314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','PELL_MATCH_TYPE for this ISIR record : ' || g_pell_match_type );
7316: END IF;
7317:
7318:

Line 7315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','PELL_MATCH_TYPE for this ISIR record : ' || g_pell_match_type );

7311: END IF; -- cur_max_isir%NOTFOUND
7312:
7313: log_debug_message(' PELL MATCH TYPE for this Interface record : ' || g_pell_match_type);
7314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','PELL_MATCH_TYPE for this ISIR record : ' || g_pell_match_type );
7316: END IF;
7317:
7318:
7319: -- call procedure which would process ISIR rec based on the pell match type.

Line 7323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7319: -- call procedure which would process ISIR rec based on the pell match type.
7320: pell_match_type_rec_processing; -- call procedure which would process ISIR rec based on the pell match type.
7321:
7322:
7323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Processed Interface record successfully. Commiting Changes');
7325: END IF;
7326:
7327: END IF; -- g_isir_intrface_rec.processed_record_type

Line 7324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Processed Interface record successfully. Commiting Changes');

7320: pell_match_type_rec_processing; -- call procedure which would process ISIR rec based on the pell match type.
7321:
7322:
7323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Processed Interface record successfully. Commiting Changes');
7325: END IF;
7326:
7327: END IF; -- g_isir_intrface_rec.processed_record_type
7328:

Line 7336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7332: -- IF CPS Pushed ISIR processed then raise business event notification.
7333: l_message_class := get_msg_class_from_filename(p_filename => g_isir_intrface_rec.data_file_name_txt);
7334:
7335: IF l_message_class IN ('IGCO05OP','IGSA05OP') THEN
7336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.statement','CPS Pushed ISIR processed. Message Class:' || l_message_class);
7338: END IF;
7339:
7340: -- Raise a Business Event Notification if the processed record is a CPS Pushed ISIR.

Line 7337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.statement','CPS Pushed ISIR processed. Message Class:' || l_message_class);

7333: l_message_class := get_msg_class_from_filename(p_filename => g_isir_intrface_rec.data_file_name_txt);
7334:
7335: IF l_message_class IN ('IGCO05OP','IGSA05OP') THEN
7336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.statement','CPS Pushed ISIR processed. Message Class:' || l_message_class);
7338: END IF;
7339:
7340: -- Raise a Business Event Notification if the processed record is a CPS Pushed ISIR.
7341: raise_cps_pushed_isir_event;

Line 7354: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7350: RETURN;
7351:
7352: WHEN OTHERS THEN
7353: ROLLBACK TO SP1;
7354: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7355: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.exception','The exception is : ' || SQLERRM );
7356: END IF;
7357:
7358: g_bad_rec := g_bad_rec + 1; -- update bad rec count

Line 7355: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.exception','The exception is : ' || SQLERRM );

7351:
7352: WHEN OTHERS THEN
7353: ROLLBACK TO SP1;
7354: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7355: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_int_record.exception','The exception is : ' || SQLERRM );
7356: END IF;
7357:
7358: g_bad_rec := g_bad_rec + 1; -- update bad rec count
7359:

Line 7479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7475:
7476:
7477: BEGIN
7478: igf_aw_gen.set_org_id(NULL);
7479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7480: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Beginning Processing');
7481: END IF;
7482:
7483: g_gen_party_profile_val := FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER'); -- get the profile value and store in global variable

Line 7480: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Beginning Processing');

7476:
7477: BEGIN
7478: igf_aw_gen.set_org_id(NULL);
7479: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7480: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Beginning Processing');
7481: END IF;
7482:
7483: g_gen_party_profile_val := FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER'); -- get the profile value and store in global variable
7484:

Line 7582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7578: OPEN cur_isir_intrface (p_si_id);
7579: FETCH cur_isir_intrface INTO g_isir_intrface_rec;
7580: CLOSE cur_isir_intrface ;
7581:
7582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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

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

7579: FETCH cur_isir_intrface INTO g_isir_intrface_rec;
7580: CLOSE cur_isir_intrface ;
7581:
7582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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');

Line 7605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7601: FETCH cur_sub_req_int INTO g_isir_intrface_rec;
7602:
7603: WHILE cur_sub_req_int%FOUND LOOP
7604: log_debug_message('Processing Interface record. SI_ID = ' || g_isir_intrface_rec.si_id || ' at : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
7605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Processing Interface record. SI ID : ' || g_isir_intrface_rec.si_id);
7607: END IF;
7608:
7609: process_int_record; -- call the process for processing the Interface record.

Line 7606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Processing Interface record. SI ID : ' || g_isir_intrface_rec.si_id);

7602:
7603: WHILE cur_sub_req_int%FOUND LOOP
7604: log_debug_message('Processing Interface record. SI_ID = ' || g_isir_intrface_rec.si_id || ' at : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
7605: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7606: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Processing Interface record. SI ID : ' || g_isir_intrface_rec.si_id);
7607: END IF;
7608:
7609: process_int_record; -- call the process for processing the Interface record.
7610:

Line 7622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7618: log_statistics;
7619:
7620: ram_log_dml_count;
7621:
7622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Completed Main Processing at : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
7624: END IF;
7625:
7626: log_debug_message(' Ended main procedure... ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));

Line 7623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Completed Main Processing at : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));

7619:
7620: ram_log_dml_count;
7621:
7622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.main.debug','Completed Main Processing at : ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
7624: END IF;
7625:
7626: log_debug_message(' Ended main procedure... ' || TO_CHAR(SYSDATE, 'HH24:MI:SS'));
7627: RETURN;

Line 7631: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7627: RETURN;
7628:
7629: EXCEPTION
7630: WHEN OTHERS THEN
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');

Line 7632: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.main.exception','The exception is : ' || SQLERRM );

7628:
7629: EXCEPTION
7630: WHEN OTHERS THEN
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');

Line 7696: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7692: RETURN l_formated_ssn;
7693:
7694: EXCEPTION
7695: WHEN OTHERS THEN
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');

Line 7697: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.format_SSN.exception','The exception is : ' || SQLERRM );

7693:
7694: EXCEPTION
7695: WHEN OTHERS THEN
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;

Line 7831: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7827: END IF;
7828:
7829: EXCEPTION
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');

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

7828:
7829: EXCEPTION
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);

Line 7923: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7919:
7920: EXCEPTION
7921:
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');

Line 7924: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.convert_negative_char.exception','The exception is : ' || SQLERRM );

7920: EXCEPTION
7921:
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);

Line 7991: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

7987: END LOOP;
7988:
7989: EXCEPTION
7990: WHEN others THEN
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');

Line 7992: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.load_matched_isir.exception','The exception is : ' || SQLERRM );

7988:
7989: EXCEPTION
7990: WHEN others THEN
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');

Line 8047: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

8043:
8044: EXCEPTION
8045:
8046: WHEN others THEN
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');

Line 8048: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_isir_matched.exception','The exception is : ' || SQLERRM );

8044: EXCEPTION
8045:
8046: WHEN others THEN
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');

Line 8102: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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

Line 8103: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_intrface.exception','The exception is : ' || SQLERRM );

8099:
8100: EXCEPTION
8101: WHEN others THEN
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');

Line 8175: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

8171: END LOOP;
8172:
8173: EXCEPTION
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');

Line 8176: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_nslds_data.exception','The exception is : ' || SQLERRM );

8172:
8173: EXCEPTION
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);

Line 8224: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

8220: END IF;
8221:
8222: EXCEPTION
8223: WHEN OTHERS THEN
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');

Line 8225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.check_ptyp_code.exception','The exception is : ' || SQLERRM );

8221:
8222: EXCEPTION
8223: WHEN OTHERS THEN
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');

Line 8370: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

8366: log_debug_message(' Interface record status Updated');
8367: p_return_status := 'S'; -- indicate success
8368: EXCEPTION
8369: WHEN OTHERS THEN
8370: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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

Line 8371: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_refresh_matches.exception','The exception is : ' || SQLERRM );

8367: p_return_status := 'S'; -- indicate success
8368: EXCEPTION
8369: WHEN OTHERS THEN
8370: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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');

Line 8459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

8455: END IF;
8456:
8457:
8458: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
8459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));
8461: END IF;
8462: IF NVL(lv_profile_value,'N') = 'Y' THEN
8463: OPEN c_ssn(p_person_id);

Line 8460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));

8456:
8457:
8458: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
8459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));
8461: END IF;
8462: IF NVL(lv_profile_value,'N') = 'Y' THEN
8463: OPEN c_ssn(p_person_id);
8464: FETCH c_ssn INTO l_ssn;

Line 8466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

8462: IF NVL(lv_profile_value,'N') = 'Y' THEN
8463: OPEN c_ssn(p_person_id);
8464: FETCH c_ssn INTO l_ssn;
8465: IF c_ssn%NOTFOUND THEN
8466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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';

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

8463: OPEN c_ssn(p_person_id);
8464: FETCH c_ssn INTO l_ssn;
8465: IF c_ssn%NOTFOUND THEN
8466: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
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');

Line 8475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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.');
8477: END IF;
8478: CLOSE c_ssn;
8479: END IF;

Line 8476: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%FOUND.');

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.');
8477: END IF;
8478: CLOSE c_ssn;
8479: END IF;
8480: END IF;

Line 8532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
8535:
8536: p_return_status := 'S'; -- return success

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

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;
8535:
8536: p_return_status := 'S'; -- return success
8537: EXCEPTION

Line 8539: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

8535:
8536: p_return_status := 'S'; -- return success
8537: EXCEPTION
8538: WHEN OTHERS THEN
8539: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8540: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.exception','Exception encountered and hence process could not complete successfully');
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:

Line 8540: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.exception','Exception encountered and hence process could not complete successfully');

8536: p_return_status := 'S'; -- return success
8537: EXCEPTION
8538: WHEN OTHERS THEN
8539: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8540: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.exception','Exception encountered and hence process could not complete successfully');
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

Line 8541: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.exception','The exception is : ' || SQLERRM );

8537: EXCEPTION
8538: WHEN OTHERS THEN
8539: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8540: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.exception','Exception encountered and hence process could not complete successfully');
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');

Line 8630: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

8626: p_return_status := 'S'; -- indicate success
8627:
8628: EXCEPTION
8629: WHEN OTHERS THEN
8630: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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

Line 8631: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.wrpr_unmatched_rec.exception','The exception is : ' || SQLERRM );

8627:
8628: EXCEPTION
8629: WHEN OTHERS THEN
8630: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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');