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 IGF_SL_CL_ORIG_ACK

Line 1: PACKAGE BODY igf_sl_cl_orig_ack AS

1: PACKAGE BODY igf_sl_cl_orig_ack AS
2: /* $Header: IGFSL09B.pls 120.25 2006/08/23 11:45:09 bvisvana ship $ */
3: --
4: ---------------------------------------------------------------------------------
5: --

Line 434: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_ACK');

430: RAISE batch_exceptions;
431: END IF;
432:
433:
434: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_ACK');
435: fnd_file.put_line(fnd_file.log, fnd_message.get);
436:
437: g_loaded_batch_id := LTRIM(RTRIM(SUBSTR(header_rec.record_data, 11,12)));
438: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 7' ||' ';

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 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 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 544: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.CL_LOAD_FILE');

540: RAISE;
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 := '';

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 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 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 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 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 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 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 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 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 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 2225: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.PROCESS_ACK');

2221: WHEN OTHERS 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 := '';

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 4335: fnd_message.set_token('NAME','IGF_SL_CL_ORIG_ACK.SHOW_ALT_DETAILS');

4331: EXCEPTION
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 := '';

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 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 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 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 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 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 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 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 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 5650: wf_core.context ('IGF_SL_CL_ORIG_ACK',

5646:
5647: EXCEPTION
5648: WHEN OTHERS 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);

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,

Line 6919: END igf_sl_cl_orig_ack;

6915: BEGIN
6916: fnd_file.put_line(fnd_file.log, p_v_param_typ || ' : ' || p_v_param_val );
6917: END log_parameters;
6918:
6919: END igf_sl_cl_orig_ack;