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_SL_CL_ORIG_ACK dependencies on FND_LOG

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

517:
518: -- Call Procedure to Process all the Transaction Records
519:
520: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 10' ||' ';
521: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);
523: END IF;
524: gv_debug_str := '';
525: process_1_records;

Line 522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);

518: -- Call Procedure to Process all the Transaction Records
519:
520: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 10' ||' ';
521: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);
523: END IF;
524: gv_debug_str := '';
525: process_1_records;
526: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 11' ||' ';

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

528:
529: EXCEPTION
530:
531: WHEN batch_exceptions THEN
532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);
534: END IF;
535: RAISE;
536: WHEN app_exception.record_lock_exception THEN

Line 533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);

529: EXCEPTION
530:
531: WHEN batch_exceptions THEN
532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);
534: END IF;
535: RAISE;
536: WHEN app_exception.record_lock_exception THEN
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

533: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str);
534: END IF;
535: RAISE;
536: WHEN app_exception.record_lock_exception THEN
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str || ' Lock ');
539: END IF;
540: RAISE;
541: WHEN OTHERS THEN

Line 538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str || ' Lock ');

534: END IF;
535: RAISE;
536: WHEN app_exception.record_lock_exception THEN
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.debug',gv_debug_str || ' Lock ');
539: END IF;
540: RAISE;
541: WHEN OTHERS THEN
542:

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

541: WHEN OTHERS THEN
542:
543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
544: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.CL_LOAD_FILE');
545: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.exception',gv_debug_str||' '|| SQLERRM);
547: END IF;
548: gv_debug_str := '';
549: igs_ge_msg_stack.add;

Line 546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.exception',gv_debug_str||' '|| SQLERRM);

542:
543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
544: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.CL_LOAD_FILE');
545: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.cl_load_file.exception',gv_debug_str||' '|| SQLERRM);
547: END IF;
548: gv_debug_str := '';
549: igs_ge_msg_stack.add;
550: app_exception.raise_exception;

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

1092: ELSIF NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') = 'ALT' THEN
1093: l_n_resp_actual_approved_amt := l_n_resp_alt_approved_amt;
1094: END IF;
1095:
1096: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1097: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.AmountComparison',
1098: '|Fed Fund Type - ' || NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') ||
1099: '|Guaranteed Amount - ' || l_n_resp_guarantee_amt ||
1100: '|Approved Amount - ' || l_n_resp_actual_approved_amt ||

Line 1097: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.AmountComparison',

1093: l_n_resp_actual_approved_amt := l_n_resp_alt_approved_amt;
1094: END IF;
1095:
1096: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1097: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.AmountComparison',
1098: '|Fed Fund Type - ' || NVL(rec_c_igf_aw_award_v.fed_fund_code, '*') ||
1099: '|Guaranteed Amount - ' || l_n_resp_guarantee_amt ||
1100: '|Approved Amount - ' || l_n_resp_actual_approved_amt ||
1101: '|Accepted Amount - ' || rec_c_igf_aw_award_v.accepted_amt ||

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

1124: );
1125: END IF;
1126: END IF;
1127: END IF;
1128: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1129: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.debug',gv_debug_str);
1130: END IF;
1131: gv_debug_str := '';
1132: insert_into_resp1(l_loan_number, l_resp_record_status, l_v_rec_type_ind);

Line 1129: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.debug',gv_debug_str);

1125: END IF;
1126: END IF;
1127: END IF;
1128: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1129: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.debug',gv_debug_str);
1130: END IF;
1131: gv_debug_str := '';
1132: insert_into_resp1(l_loan_number, l_resp_record_status, l_v_rec_type_ind);
1133: EXCEPTION

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

1142: RAISE;
1143: WHEN OTHERS THEN
1144: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1145: fnd_message.set_token('NAME','IGF_SL_CL_ACK.PROCESS_1_RECORDS');
1146: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1147: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.exception',gv_debug_str||' '||SQLERRM);
1148: END IF;
1149: gv_debug_str := '';
1150: igs_ge_msg_stack.add;

Line 1147: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.exception',gv_debug_str||' '||SQLERRM);

1143: WHEN OTHERS THEN
1144: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1145: fnd_message.set_token('NAME','IGF_SL_CL_ACK.PROCESS_1_RECORDS');
1146: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1147: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_1_records.exception',gv_debug_str||' '||SQLERRM);
1148: END IF;
1149: gv_debug_str := '';
1150: igs_ge_msg_stack.add;
1151: app_exception.raise_exception;

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

1649: IF LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,188,2)))='AL' THEN
1650:
1651: --Insert into igf_sl_cl_resp_r4 table
1652: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 9' || ' ';
1653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.debug',gv_debug_str);
1655: END IF;
1656: insert_into_resp_r4(l_clrp1_id,
1657: other_rec.record_data);

Line 1654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.debug',gv_debug_str);

1650:
1651: --Insert into igf_sl_cl_resp_r4 table
1652: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 9' || ' ';
1653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.debug',gv_debug_str);
1655: END IF;
1656: insert_into_resp_r4(l_clrp1_id,
1657: other_rec.record_data);
1658: gv_debug_str := '';

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

1791: END LOOP;
1792:
1793: --Delete the Disbursement records from the PL/SQL Table after inserting into CL_RESP_R8 Table.
1794: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 14' || ' ';
1795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.debug',gv_debug_str);
1797: END IF;
1798: r8_tab.delete;
1799: gv_debug_str := '';

Line 1796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.debug',gv_debug_str);

1792:
1793: --Delete the Disbursement records from the PL/SQL Table after inserting into CL_RESP_R8 Table.
1794: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 14' || ' ';
1795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1796: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.debug',gv_debug_str);
1797: END IF;
1798: r8_tab.delete;
1799: gv_debug_str := '';
1800:

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

1866: RAISE;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1869: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP1');
1870: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1871: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.exception',gv_debug_str||' '|| SQLERRM);
1872: END IF;
1873: gv_debug_str := '';
1874: igs_ge_msg_stack.add;

Line 1871: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.exception',gv_debug_str||' '|| SQLERRM);

1867: WHEN OTHERS THEN
1868: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1869: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP1');
1870: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1871: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp1.exception',gv_debug_str||' '|| SQLERRM);
1872: END IF;
1873: gv_debug_str := '';
1874: igs_ge_msg_stack.add;
1875: app_exception.raise_exception;

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

1933:
1934: --
1935: -- Load the Datafile into the Interface tables.
1936: --
1937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
1939: END IF;
1940: cl_load_file;
1941: gv_debug_str := '';

Line 1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);

1934: --
1935: -- Load the Datafile into the Interface tables.
1936: --
1937: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
1939: END IF;
1940: cl_load_file;
1941: gv_debug_str := '';
1942:

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

1974: --
1975: -- Delete records from Edit Report table with type="R" (Rejections) for this Loan Number
1976: --
1977: gv_debug_str := gv_debug_str || 'MAIN - 5' || ' ';
1978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
1980: END IF;
1981:
1982: igf_sl_edit.delete_edit(l_loan_number, 'R');

Line 1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);

1975: -- Delete records from Edit Report table with type="R" (Rejections) for this Loan Number
1976: --
1977: gv_debug_str := gv_debug_str || 'MAIN - 5' || ' ';
1978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
1980: END IF;
1981:
1982: igf_sl_edit.delete_edit(l_loan_number, 'R');
1983: gv_debug_str := '';

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

2044: -- Call Procedure to update the LOR Table
2045: --
2046:
2047: gv_debug_str := gv_debug_str || 'MAIN - 11' || ' ';
2048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
2050: END IF;
2051: fnd_file.new_line(fnd_file.log,1);
2052: update_lor(loaded_1rec.clrp1_id,l_loan_number,lb_rejected_rec);

Line 2049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);

2045: --
2046:
2047: gv_debug_str := gv_debug_str || 'MAIN - 11' || ' ';
2048: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2049: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
2050: END IF;
2051: fnd_file.new_line(fnd_file.log,1);
2052: update_lor(loaded_1rec.clrp1_id,l_loan_number,lb_rejected_rec);
2053: gv_debug_str := '';

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

2222: ROLLBACK;
2223: RETCODE := 2;
2224: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2225: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.PROCESS_ACK');
2226: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2227: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_ack.exception',gv_debug_str||' '|| SQLERRM);
2228: END IF;
2229: gv_debug_str := '';
2230: errbuf := fnd_message.get;

Line 2227: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_ack.exception',gv_debug_str||' '|| SQLERRM);

2223: RETCODE := 2;
2224: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2225: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.PROCESS_ACK');
2226: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2227: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.process_ack.exception',gv_debug_str||' '|| SQLERRM);
2228: END IF;
2229: gv_debug_str := '';
2230: errbuf := fnd_message.get;
2231: igs_ge_msg_stack.conc_exception_hndl;

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

2568: -- Procedure call to compare the Disbursement Information in the Awards Disbursement and the newly
2569: -- inserted Disbursement Information
2570:
2571: gv_debug_str := gv_debug_str || 'UPDATE_LOR - 10' || ' ';
2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2573: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str);
2574: END IF;
2575: --Procedure call to compare the Alternate Borrow Details
2576: gv_debug_str := '';

Line 2573: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str);

2569: -- inserted Disbursement Information
2570:
2571: gv_debug_str := gv_debug_str || 'UPDATE_LOR - 10' || ' ';
2572: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2573: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str);
2574: END IF;
2575: --Procedure call to compare the Alternate Borrow Details
2576: gv_debug_str := '';
2577: gv_debug_str := gv_debug_str || 'UPDATE_LOR - 11' || ' ';

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

3090:
3091:
3092: -- Update the Loan Status in Loans Table based on the below conditions
3093: l_loan_status := NULL;
3094: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);
3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);
3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);
3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);

Line 3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);

3091:
3092: -- Update the Loan Status in Loans Table based on the below conditions
3093: l_loan_status := NULL;
3094: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);
3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);
3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);
3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);
3099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.credit_override ' || tbh_rec.crdt_decision_status );

Line 3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);

3092: -- Update the Loan Status in Loans Table based on the below conditions
3093: l_loan_status := NULL;
3094: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);
3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);
3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);
3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);
3099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.credit_override ' || tbh_rec.crdt_decision_status );
3100: END IF;

Line 3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);

3093: l_loan_status := NULL;
3094: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);
3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);
3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);
3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);
3099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.credit_override ' || tbh_rec.crdt_decision_status );
3100: END IF;
3101:

Line 3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);

3094: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);
3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);
3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);
3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);
3099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.credit_override ' || tbh_rec.crdt_decision_status );
3100: END IF;
3101:
3102: IF loaded_1rec.cl_version_code = 'RELEASE-5' THEN

Line 3099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.credit_override ' || tbh_rec.crdt_decision_status );

3095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' loaded_1rec.prc_type_code ' || loaded_1rec.prc_type_code);
3096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.guarnt_status_code ' || tbh_rec.guarnt_status_code);
3097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.lend_status_code ' || tbh_rec.lend_status_code);
3098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.pnote_status ' || tbh_rec.pnote_status);
3099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str||' tbh_rec.credit_override ' || tbh_rec.crdt_decision_status );
3100: END IF;
3101:
3102: IF loaded_1rec.cl_version_code = 'RELEASE-5' THEN
3103: IF loaded_1rec.prc_type_code='GP' THEN

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

3276: gv_debug_str := '';
3277: END LOOP;
3278:
3279: gv_debug_str := gv_debug_str || 'UPDATE_LOR-20' || ' ';
3280: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str);
3282: END IF;
3283: gv_debug_str := '';
3284:

Line 3281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str);

3277: END LOOP;
3278:
3279: gv_debug_str := gv_debug_str || 'UPDATE_LOR-20' || ' ';
3280: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3281: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_lor.debug',gv_debug_str);
3282: END IF;
3283: gv_debug_str := '';
3284:
3285: EXCEPTION

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

3292:
3293: WHEN OTHERS THEN
3294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3295: fnd_message.set_token('NAME','IGF_SL_CL_ACK.UPDATE_LOR');
3296: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.update_lor.exception',gv_debug_str||' '|| SQLERRM);
3298: END IF;
3299: gv_debug_str := '';
3300: igs_ge_msg_stack.add;

Line 3297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.update_lor.exception',gv_debug_str||' '|| SQLERRM);

3293: WHEN OTHERS THEN
3294: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3295: fnd_message.set_token('NAME','IGF_SL_CL_ACK.UPDATE_LOR');
3296: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.update_lor.exception',gv_debug_str||' '|| SQLERRM);
3298: END IF;
3299: gv_debug_str := '';
3300: igs_ge_msg_stack.add;
3301: app_exception.raise_exception;

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

3433: );
3434: gv_debug_str := '';
3435: END LOOP;
3436:
3437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_resp8_rec_status.debug',gv_debug_str);
3439: END IF;
3440:
3441: END update_resp8_rec_status;

Line 3438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_resp8_rec_status.debug',gv_debug_str);

3434: gv_debug_str := '';
3435: END LOOP;
3436:
3437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.update_resp8_rec_status.debug',gv_debug_str);
3439: END IF;
3440:
3441: END update_resp8_rec_status;
3442:

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

3516: ||LPAD(LOC_disb.direct_to_borr_flag,30));
3517:
3518: END LOOP;
3519: gv_debug_str := gv_debug_str || 'SHOW_DISB_DETAILS-2' ||' ';
3520: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3521: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.show_disb_details.debug',gv_debug_str);
3522: END IF;
3523: END show_disb_details;
3524:

Line 3521: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.show_disb_details.debug',gv_debug_str);

3517:
3518: END LOOP;
3519: gv_debug_str := gv_debug_str || 'SHOW_DISB_DETAILS-2' ||' ';
3520: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3521: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.show_disb_details.debug',gv_debug_str);
3522: END IF;
3523: END show_disb_details;
3524:
3525: /***************************************************************

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

3740: END IF; -- End Update Flag Check
3741: ELSE -- Else Diff Check
3742: l_resp_record_status := 'Y';
3743: END IF; -- End LOR LOC Diff Check
3744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3745: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.upd_disb_details.debug',gv_debug_str ||
3746: '|clrp1_id - ' || loc_disb.clrp1_id ||
3747: '|clrp8_id - ' || loc_disb.clrp8_id ||
3748: '|l_resp_record_status - ' || l_resp_record_status

Line 3745: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.upd_disb_details.debug',gv_debug_str ||

3741: ELSE -- Else Diff Check
3742: l_resp_record_status := 'Y';
3743: END IF; -- End LOR LOC Diff Check
3744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3745: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.upd_disb_details.debug',gv_debug_str ||
3746: '|clrp1_id - ' || loc_disb.clrp1_id ||
3747: '|clrp8_id - ' || loc_disb.clrp8_id ||
3748: '|l_resp_record_status - ' || l_resp_record_status
3749: );

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

3752: update_resp8_rec_status(loc_disb.clrp1_id,
3753: loc_disb.clrp8_id,
3754: l_resp_record_status);
3755: END LOOP; --END CLRP8 Loop
3756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3757: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.upd_disb_details.debug',gv_debug_str);
3758: END IF;
3759: gv_debug_str := '';
3760: END LOOP; -- END LOC Loop

Line 3757: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.upd_disb_details.debug',gv_debug_str);

3753: loc_disb.clrp8_id,
3754: l_resp_record_status);
3755: END LOOP; --END CLRP8 Loop
3756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3757: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.upd_disb_details.debug',gv_debug_str);
3758: END IF;
3759: gv_debug_str := '';
3760: END LOOP; -- END LOC Loop
3761:

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

3813: );
3814: gv_debug_str := gv_debug_str || 'PLACE_DISB_HOLDS - 3 '||' ';
3815: END IF;
3816: CLOSE cur_disb_hold_exists;
3817: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.place_disb_holds.debug',gv_debug_str);
3819: END IF;
3820: gv_debug_str := '';
3821: END LOOP;

Line 3818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.place_disb_holds.debug',gv_debug_str);

3814: gv_debug_str := gv_debug_str || 'PLACE_DISB_HOLDS - 3 '||' ';
3815: END IF;
3816: CLOSE cur_disb_hold_exists;
3817: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3818: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.place_disb_holds.debug',gv_debug_str);
3819: END IF;
3820: gv_debug_str := '';
3821: END LOOP;
3822:

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

3855: -- Guarantee Adj Indicator (From File)
3856: -- Guarantee Amount (From File)
3857: -- Requested Loan Amount (from File)
3858: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 4' ||' ';
3859: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3861: END IF;
3862: gv_debug_str := '';
3863: --

Line 3860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);

3856: -- Guarantee Amount (From File)
3857: -- Requested Loan Amount (from File)
3858: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 4' ||' ';
3859: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3861: END IF;
3862: gv_debug_str := '';
3863: --
3864: -- put a message here comparing loc and system data,

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

3872: show_disb_details;
3873:
3874: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 5' ||' ';
3875: -- Place Process Holds on All the Disbursement records.
3876: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3878: END IF;
3879: gv_debug_str := '';
3880: place_disb_holds(l_award_id);

Line 3877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);

3873:
3874: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 5' ||' ';
3875: -- Place Process Holds on All the Disbursement records.
3876: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3878: END IF;
3879: gv_debug_str := '';
3880: place_disb_holds(l_award_id);
3881: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 6' ||' ';

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

3895: -- Update Fee_1, fee_2, fee_paid_1, fee_paid_2 from the file into
3896: -- disbursements records.
3897: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 8' ||' ';
3898:
3899: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3901: END IF;
3902: gv_debug_str := '';
3903: show_differing_disb_details;

Line 3900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);

3896: -- disbursements records.
3897: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 8' ||' ';
3898:
3899: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3901: END IF;
3902: gv_debug_str := '';
3903: show_differing_disb_details;
3904: -- if the parameter update disbursement details is set to 'y' only then

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

3910:
3911: ELSE
3912:
3913: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 9' ||' ';
3914: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3915: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3916: END IF;
3917: gv_debug_str := '';
3918: --

Line 3915: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);

3911: ELSE
3912:
3913: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 9' ||' ';
3914: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3915: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3916: END IF;
3917: gv_debug_str := '';
3918: --
3919: -- put a message here

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

3927: show_disb_details;
3928:
3929: -- Place Process Holds on All the Disbursement records.
3930: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 10' ||' ';
3931: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3932: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3933: END IF;
3934: gv_debug_str := '';
3935:

Line 3932: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);

3928:
3929: -- Place Process Holds on All the Disbursement records.
3930: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 10' ||' ';
3931: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3932: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3933: END IF;
3934: gv_debug_str := '';
3935:
3936: -- bvisvana - SBCC Bug # 4575843 - Instead of placing holds do an update.

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

3943: END IF;
3944:
3945: -- Update the Status of the records in cl_resp_r8 to processed.
3946: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 11' ||' ';
3947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3949: END IF;
3950: gv_debug_str := '';
3951: update_resp8_rec_status(loaded_1rec.clrp1_id, NULL, 'N');

Line 3948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);

3944:
3945: -- Update the Status of the records in cl_resp_r8 to processed.
3946: gv_debug_str := gv_debug_str || 'COMPARE_DISBURSEMENTS - 11' ||' ';
3947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.debug',gv_debug_str);
3949: END IF;
3950: gv_debug_str := '';
3951: update_resp8_rec_status(loaded_1rec.clrp1_id, NULL, 'N');
3952:

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

3957:
3958: WHEN OTHERS THEN
3959: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3960: fnd_message.set_token('NAME','IGF_SL_CL_ACK.COMPARE_DISBURSEMENTS');
3961: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3962: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.exception',gv_debug_str||' '|| SQLERRM);
3963: END IF;
3964: gv_debug_str := '';
3965: igs_ge_msg_stack.add;

Line 3962: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.exception',gv_debug_str||' '|| SQLERRM);

3958: WHEN OTHERS THEN
3959: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3960: fnd_message.set_token('NAME','IGF_SL_CL_ACK.COMPARE_DISBURSEMENTS');
3961: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3962: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.compare_disbursements.exception',gv_debug_str||' '|| SQLERRM);
3963: END IF;
3964: gv_debug_str := '';
3965: igs_ge_msg_stack.add;
3966: app_exception.raise_exception;

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

4138: EXCEPTION
4139: WHEN OTHERS THEN
4140: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4141: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP_R4');
4142: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4143: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp_r4.exception',gv_debug_str||' '|| SQLERRM);
4144: END IF;
4145: gv_debug_str := '';
4146: igs_ge_msg_stack.add;

Line 4143: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp_r4.exception',gv_debug_str||' '|| SQLERRM);

4139: WHEN OTHERS THEN
4140: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4141: fnd_message.set_token('NAME','IGF_SL_CL_ACK.INSERT_INTO_RESP_R4');
4142: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4143: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.insert_into_resp_r4.exception',gv_debug_str||' '|| SQLERRM);
4144: END IF;
4145: gv_debug_str := '';
4146: igs_ge_msg_stack.add;
4147: app_exception.raise_exception;

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

4332:
4333: WHEN OTHERS THEN
4334: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4335: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.SHOW_ALT_DETAILS');
4336: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4337: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.show_alt_details.exception',gv_debug_str||' '|| SQLERRM);
4338: END IF;
4339: gv_debug_str := '';
4340: igs_ge_msg_stack.add;

Line 4337: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.show_alt_details.exception',gv_debug_str||' '|| SQLERRM);

4333: WHEN OTHERS THEN
4334: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
4335: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.SHOW_ALT_DETAILS');
4336: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4337: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.show_alt_details.exception',gv_debug_str||' '|| SQLERRM);
4338: END IF;
4339: gv_debug_str := '';
4340: igs_ge_msg_stack.add;
4341: app_exception.raise_exception;

Line 4367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4363: --Change History:
4364: --Who When What
4365: ------------------------------------------------------------------
4366: BEGIN
4367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig_ack.'||p_v_module, p_v_string);
4369: END IF;
4370: END log_to_fnd;
4371:

Line 4368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig_ack.'||p_v_module, p_v_string);

4364: --Who When What
4365: ------------------------------------------------------------------
4366: BEGIN
4367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig_ack.'||p_v_module, p_v_string);
4369: END IF;
4370: END log_to_fnd;
4371:
4372: PROCEDURE process_borrow_stud_rec (p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE) AS

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

5179: -- END IF;
5180: -- bvisvana - Bug # 4522973 - To create the phone contact point once the person is created
5181: -- Do this only for the borrower.
5182: IF l_n_person_id IS NOT NULL AND p_c_pers_typ_ind = 'B' THEN
5183: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5184: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_record.debug','Before calling create_person_telephone_record ');
5185: END IF;
5186: l_b_ret_status := create_person_telephone_record ( p_n_person_id => l_n_person_id,
5187: p_rec_resp_r1 => l_rec_resp_r1

Line 5184: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_record.debug','Before calling create_person_telephone_record ');

5180: -- bvisvana - Bug # 4522973 - To create the phone contact point once the person is created
5181: -- Do this only for the borrower.
5182: IF l_n_person_id IS NOT NULL AND p_c_pers_typ_ind = 'B' THEN
5183: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5184: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_record.debug','Before calling create_person_telephone_record ');
5185: END IF;
5186: l_b_ret_status := create_person_telephone_record ( p_n_person_id => l_n_person_id,
5187: p_rec_resp_r1 => l_rec_resp_r1
5188: ) ;

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

5185: END IF;
5186: l_b_ret_status := create_person_telephone_record ( p_n_person_id => l_n_person_id,
5187: p_rec_resp_r1 => l_rec_resp_r1
5188: ) ;
5189: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5190: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_record.debug','After calling create_person_telephone_record ');
5191: END IF;
5192: END IF;
5193:

Line 5190: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_record.debug','After calling create_person_telephone_record ');

5186: l_b_ret_status := create_person_telephone_record ( p_n_person_id => l_n_person_id,
5187: p_rec_resp_r1 => l_rec_resp_r1
5188: ) ;
5189: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5190: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_record.debug','After calling create_person_telephone_record ');
5191: END IF;
5192: END IF;
5193:
5194: p_n_person_id := l_n_person_id;

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

5435: IF l_area_code = '000' THEN
5436: l_area_code := NULL;
5437: ENd IF;
5438: l_phone_num := SUBSTR(l_perm_phone,4);
5439: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5440: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','p_n_person_id = '||p_n_person_id);
5441: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Area_code = '||l_area_code);
5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);
5443: END IF;

Line 5440: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','p_n_person_id = '||p_n_person_id);

5436: l_area_code := NULL;
5437: ENd IF;
5438: l_phone_num := SUBSTR(l_perm_phone,4);
5439: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5440: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','p_n_person_id = '||p_n_person_id);
5441: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Area_code = '||l_area_code);
5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);
5443: END IF;
5444: ELSE

Line 5441: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Area_code = '||l_area_code);

5437: ENd IF;
5438: l_phone_num := SUBSTR(l_perm_phone,4);
5439: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5440: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','p_n_person_id = '||p_n_person_id);
5441: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Area_code = '||l_area_code);
5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);
5443: END IF;
5444: ELSE
5445: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);

5438: l_phone_num := SUBSTR(l_perm_phone,4);
5439: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5440: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','p_n_person_id = '||p_n_person_id);
5441: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Area_code = '||l_area_code);
5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);
5443: END IF;
5444: ELSE
5445: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5446: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Since phone number N/A or length not equal to 10 ..returning as false');

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

5441: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Area_code = '||l_area_code);
5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);
5443: END IF;
5444: ELSE
5445: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5446: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Since phone number N/A or length not equal to 10 ..returning as false');
5447: END IF;
5448: RETURN FALSE;
5449: END IF;

Line 5446: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Since phone number N/A or length not equal to 10 ..returning as false');

5442: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Phone_num = '||l_phone_num);
5443: END IF;
5444: ELSE
5445: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5446: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','Since phone number N/A or length not equal to 10 ..returning as false');
5447: END IF;
5448: RETURN FALSE;
5449: END IF;
5450: igs_pe_contact_point_pkg.hz_contact_points_akp(

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

5486: p_attribute19 => NULL,
5487: p_attribute20 => NULL
5488: );
5489: IF l_return_status <> 'S' THEN
5490: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5491: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','FALSE - Telephone return status = '||l_return_status);
5492: END IF;
5493: RETURN FALSE;
5494: ELSE

Line 5491: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','FALSE - Telephone return status = '||l_return_status);

5487: p_attribute20 => NULL
5488: );
5489: IF l_return_status <> 'S' THEN
5490: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5491: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','FALSE - Telephone return status = '||l_return_status);
5492: END IF;
5493: RETURN FALSE;
5494: ELSE
5495: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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

5491: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','FALSE - Telephone return status = '||l_return_status);
5492: END IF;
5493: RETURN FALSE;
5494: ELSE
5495: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5496: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','TRUE - Telephone return status = '||l_return_status);
5497: END IF;
5498: RETURN TRUE;
5499: END IF;

Line 5496: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','TRUE - Telephone return status = '||l_return_status);

5492: END IF;
5493: RETURN FALSE;
5494: ELSE
5495: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5496: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.create_person_telephone_record.debug','TRUE - Telephone return status = '||l_return_status);
5497: END IF;
5498: RETURN TRUE;
5499: END IF;
5500: END create_person_telephone_record;

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

5639: resultout := wf_engine.getitemattrtext(
5640: itemtype,
5641: itemkey,
5642: 'RELEASE_VERSION');
5643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','resultout ' || resultout);
5645: END IF;
5646:
5647: EXCEPTION

Line 5644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','resultout ' || resultout);

5640: itemtype,
5641: itemkey,
5642: 'RELEASE_VERSION');
5643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','resultout ' || resultout);
5645: END IF;
5646:
5647: EXCEPTION
5648: WHEN OTHERS THEN

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

5649: resultout := NULL;
5650: wf_core.context ('IGF_SL_CL_ORIG_ACK',
5651: 'PREPARE_SCR_MESSAGE', itemtype,
5652: itemkey,TO_CHAR(actid), funcmode);
5653: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5654: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','sqlerrm ' || SQLERRM);
5655: END IF;
5656: END prepare_scr_message;
5657:

Line 5654: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','sqlerrm ' || SQLERRM);

5650: wf_core.context ('IGF_SL_CL_ORIG_ACK',
5651: 'PREPARE_SCR_MESSAGE', itemtype,
5652: itemkey,TO_CHAR(actid), funcmode);
5653: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5654: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_orig_ack.prepare_scr_message.debug','sqlerrm ' || SQLERRM);
5655: END IF;
5656: END prepare_scr_message;
5657:
5658: PROCEDURE raise_scr_event ( p_rec_resp_r1 IN igf_sl_cl_resp_r1_all%ROWTYPE,