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

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

80: FETCH cur_doc_dtls INTO p_rowid,lv_document_id_txt, p_xml_clob;
81: CLOSE cur_doc_dtls;
82: END IF;
83:
84: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
85: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','p doc id is valid');
86: END IF;
87:
88: -- Editing LoB

Line 85: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','p doc id is valid');

81: CLOSE cur_doc_dtls;
82: END IF;
83:
84: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
85: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','p doc id is valid');
86: END IF;
87:
88: -- Editing LoB
89: ln_amount := DBMS_LOB.GETLENGTH(p_xml_clob);

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

87:
88: -- Editing LoB
89: ln_amount := DBMS_LOB.GETLENGTH(p_xml_clob);
90: DBMS_LOB.ERASE(p_xml_clob,ln_amount,1);
91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','CLOB ln_amount ' || ln_amount);
93: END IF;
94:
95: -- find doc between first tag and end of root tag

Line 92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','CLOB ln_amount ' || ln_amount);

88: -- Editing LoB
89: ln_amount := DBMS_LOB.GETLENGTH(p_xml_clob);
90: DBMS_LOB.ERASE(p_xml_clob,ln_amount,1);
91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','CLOB ln_amount ' || ln_amount);
93: END IF;
94:
95: -- find doc between first tag and end of root tag
96: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','CLOB ln_amount ' || ln_amount);
93: END IF;
94:
95: -- find doc between first tag and end of root tag
96: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
97: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','Find start and end positions ');
98: END IF;
99:
100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,'

Line 97: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','Find start and end positions ');

93: END IF;
94:
95: -- find doc between first tag and end of root tag
96: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
97: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','Find start and end positions ');
98: END IF;
99:
100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,' 101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);

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

101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);
102:
103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);
104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','End of printing ');
107: END IF;
108:
109: EXCEPTION

Line 106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','End of printing ');

102:
103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);
104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','End of printing ');
107: END IF;
108:
109: EXCEPTION
110: WHEN OTHERS THEN

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

107: END IF;
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.exception','Exception:'||SQLERRM);
113: END IF;
114: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
115: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.EDIT_CLOB');

Line 112: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.exception','Exception:'||SQLERRM);

108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.exception','Exception:'||SQLERRM);
113: END IF;
114: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
115: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.EDIT_CLOB');
116: igs_ge_msg_stack.add;

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

143: disb.disb_num = p_disb_num AND
144: disb.disb_seq_num = p_disb_seq;
145: BEGIN
146:
147: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
148: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);
149: END IF;
150:
151: FOR cod_rec IN cur_cod_loans(p_document_id_txt)

Line 148: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);

144: disb.disb_seq_num = p_disb_seq;
145: BEGIN
146:
147: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
148: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);
149: END IF;
150:
151: FOR cod_rec IN cur_cod_loans(p_document_id_txt)
152: LOOP

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

215: END LOOP;
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.update_status.exception','Exception:'||SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.UPDATE_STATUS');

Line 220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.update_status.exception','Exception:'||SQLERRM);

216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.update_status.exception','Exception:'||SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.UPDATE_STATUS');
224: igs_ge_msg_stack.add;

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

236: ln_len := dbms_lob.getlength(p_xml_clob);
237: ln_offset := 1;
238: ln_amount := 1023; -- changed from 32767 to 1023 so that it can handle upto Fixed-width-32-byte CLOBs objects (32767/1023 = 32) Bug 4323926
239:
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_len ' || ln_len);
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_offset ' || ln_offset);
243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount ' || ln_amount);
244: END IF;

Line 241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_len ' || ln_len);

237: ln_offset := 1;
238: ln_amount := 1023; -- changed from 32767 to 1023 so that it can handle upto Fixed-width-32-byte CLOBs objects (32767/1023 = 32) Bug 4323926
239:
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_len ' || ln_len);
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_offset ' || ln_offset);
243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount ' || ln_amount);
244: END IF;
245:

Line 242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_offset ' || ln_offset);

238: ln_amount := 1023; -- changed from 32767 to 1023 so that it can handle upto Fixed-width-32-byte CLOBs objects (32767/1023 = 32) Bug 4323926
239:
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_len ' || ln_len);
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_offset ' || ln_offset);
243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount ' || ln_amount);
244: END IF;
245:
246: WHILE (ln_len > 0) LOOP

Line 243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount ' || ln_amount);

239:
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_len ' || ln_len);
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_offset ' || ln_offset);
243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount ' || ln_amount);
244: END IF;
245:
246: WHILE (ln_len > 0) LOOP
247: lv_myclob_text := DBMS_LOB.SUBSTR (p_xml_clob, ln_amount, ln_offset);

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

247: lv_myclob_text := DBMS_LOB.SUBSTR (p_xml_clob, ln_amount, ln_offset);
248: fnd_file.put(fnd_file.output,lv_myclob_text);
249: ln_amount := LENGTH(lv_myclob_text); -- this will handle any Character Set. But to be optimistic ln_amount is initialized to 1023 instead of 32767. Bug 4323926
250: IF ln_amount = 0 THEN
251: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
252: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount is Zero after DBMS_LOB.SUBSTR, ln_len = ' || ln_len);
253: END IF;
254: EXIT;
255: END IF;

Line 252: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount is Zero after DBMS_LOB.SUBSTR, ln_len = ' || ln_len);

248: fnd_file.put(fnd_file.output,lv_myclob_text);
249: ln_amount := LENGTH(lv_myclob_text); -- this will handle any Character Set. But to be optimistic ln_amount is initialized to 1023 instead of 32767. Bug 4323926
250: IF ln_amount = 0 THEN
251: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
252: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount is Zero after DBMS_LOB.SUBSTR, ln_len = ' || ln_len);
253: END IF;
254: EXIT;
255: END IF;
256: ln_len := ln_len - ln_amount;

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

254: EXIT;
255: END IF;
256: ln_len := ln_len - ln_amount;
257: ln_offset := ln_offset + ln_amount;
258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
259: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_len ' || ln_len);
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_offset ' || ln_offset);
261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_amount ' || ln_amount);
262: END IF;

Line 259: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_len ' || ln_len);

255: END IF;
256: ln_len := ln_len - ln_amount;
257: ln_offset := ln_offset + ln_amount;
258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
259: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_len ' || ln_len);
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_offset ' || ln_offset);
261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_amount ' || ln_amount);
262: END IF;
263: END LOOP;

Line 260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_offset ' || ln_offset);

256: ln_len := ln_len - ln_amount;
257: ln_offset := ln_offset + ln_amount;
258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
259: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_len ' || ln_len);
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_offset ' || ln_offset);
261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_amount ' || ln_amount);
262: END IF;
263: END LOOP;
264: fnd_file.new_line(fnd_file.output,1);

Line 261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_amount ' || ln_amount);

257: ln_offset := ln_offset + ln_amount;
258: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
259: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_len ' || ln_len);
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_offset ' || ln_offset);
261: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','Loop ln_amount ' || ln_amount);
262: END IF;
263: END LOOP;
264: fnd_file.new_line(fnd_file.output,1);
265:

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

264: fnd_file.new_line(fnd_file.output,1);
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
269: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.exception','Exception:'||SQLERRM);
270: END IF;
271: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PRINT_OUT_XML');

Line 269: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.exception','Exception:'||SQLERRM);

265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
269: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.exception','Exception:'||SQLERRM);
270: END IF;
271: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PRINT_OUT_XML');
273: igs_ge_msg_stack.add;

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

322: OPEN cur_setup(p_loan_rec.ci_cal_type,p_loan_rec.ci_sequence_number);
323: FETCH cur_setup INTO setup_rec;
324: CLOSE cur_setup;
325:
326: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
327: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',setup_rec.response_option_code);
328: END IF;
329:
330: OPEN cur_loan_oldinfo(p_loan_rec.loan_id);

Line 327: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',setup_rec.response_option_code);

323: FETCH cur_setup INTO setup_rec;
324: CLOSE cur_setup;
325:
326: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
327: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',setup_rec.response_option_code);
328: END IF;
329:
330: OPEN cur_loan_oldinfo(p_loan_rec.loan_id);
331: FETCH cur_loan_oldinfo INTO loan_oldinfo_rec;

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

330: OPEN cur_loan_oldinfo(p_loan_rec.loan_id);
331: FETCH cur_loan_oldinfo INTO loan_oldinfo_rec;
332: CLOSE cur_loan_oldinfo;
333:
334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
335:
336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);

Line 336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);

332: CLOSE cur_loan_oldinfo;
333:
334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
335:
336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);

Line 337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);

333:
334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
335:
336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);

Line 338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);

334: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
335:
336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);

Line 339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);

335:
336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);

Line 340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);

336: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);

Line 341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);

337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);

Line 342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);

338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);

Line 343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);

339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);

Line 344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);

340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);

Line 345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);

341: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);

Line 346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);

342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);

Line 347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);

343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);

Line 348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);

344: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);

Line 349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);

345: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);

Line 350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);

346: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);

Line 351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);

347: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);

Line 352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);

348: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);
356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');

Line 353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);

349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);
356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');
357: END IF;

Line 354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);

350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);
356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');
357: END IF;
358:

Line 355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);

351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);
356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');
357: END IF;
358:
359:

Line 356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');

352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
355: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);
356: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');
357: END IF;
358:
359:
360: IF loan_oldinfo_rec.loan_number IS NOT NULL THEN

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

392: --
393: -- use same PL/SQL table data
394: --
395: NULL;
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
400: END IF;

Line 397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');

393: -- use same PL/SQL table data
394: --
395: NULL;
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
400: END IF;
401: ELSE

Line 398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );

394: --
395: NULL;
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
400: END IF;
401: ELSE
402: --

Line 399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );

395: NULL;
396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
400: END IF;
401: ELSE
402: --
403: -- re-initialize the PL/SQL table

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

402: --
403: -- re-initialize the PL/SQL table
404: --
405: loan_key_rec.DELETE;
406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
410: END IF;

Line 407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');

403: -- re-initialize the PL/SQL table
404: --
405: loan_key_rec.DELETE;
406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
410: END IF;
411: END IF;

Line 408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );

404: --
405: loan_key_rec.DELETE;
406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
410: END IF;
411: END IF;
412:

Line 409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );

405: loan_key_rec.DELETE;
406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
407: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
408: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
409: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
410: END IF;
411: END IF;
412:
413: ln_count := loan_key_rec.COUNT;

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

411: END IF;
412:
413: ln_count := loan_key_rec.COUNT;
414:
415: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine ln_count ' || ln_count);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key gn_new_base_id = gn_old_base_id ');
418: END IF;
419:

Line 416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine ln_count ' || ln_count);

412:
413: ln_count := loan_key_rec.COUNT;
414:
415: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine ln_count ' || ln_count);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key gn_new_base_id = gn_old_base_id ');
418: END IF;
419:
420: IF ln_count = 0 THEN

Line 417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key gn_new_base_id = gn_old_base_id ');

413: ln_count := loan_key_rec.COUNT;
414:
415: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
416: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine ln_count ' || ln_count);
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key gn_new_base_id = gn_old_base_id ');
418: END IF;
419:
420: IF ln_count = 0 THEN
421: loan_key_rec.EXTEND;

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

429: loan_key_rec(ln_count).fin_awd_end_date := p_loan_rec.loan_per_end_date;
430: loan_key_rec(ln_count).acad_yr_begin_date := p_acad_begin;
431: loan_key_rec(ln_count).acad_yr_end_date := p_acad_end;
432: ln_loan_key := ln_count;
433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key ' || ln_loan_key);
435: END IF;
436: END IF;
437:

Line 434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key ' || ln_loan_key);

430: loan_key_rec(ln_count).acad_yr_begin_date := p_acad_begin;
431: loan_key_rec(ln_count).acad_yr_end_date := p_acad_end;
432: ln_loan_key := ln_count;
433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key ' || ln_loan_key);
435: END IF;
436: END IF;
437:
438: IF ln_count >= 1 THEN

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

469: loan_key_rec(ln_loan_key).acad_yr_end_date := p_acad_end;
470: END IF;
471: END IF;
472:
473: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key = ' || ln_loan_key);
475: END IF;
476:
477: IF ln_loan_key > 99 THEN

Line 474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key = ' || ln_loan_key);

470: END IF;
471: END IF;
472:
473: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key = ' || ln_loan_key);
475: END IF;
476:
477: IF ln_loan_key > 99 THEN
478: fnd_message.set_name('IGF','IGF_SL_COD_99_KEYS');

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

482: END IF;
483:
484: lv_rowid := NULL;
485:
486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc ');
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_p_phone ' || p_p_phone);
489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_s_phone ' || p_s_phone);
490: END IF;

Line 487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc ');

483:
484: lv_rowid := NULL;
485:
486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc ');
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_p_phone ' || p_p_phone);
489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_s_phone ' || p_s_phone);
490: END IF;
491: --

Line 488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_p_phone ' || p_p_phone);

484: lv_rowid := NULL;
485:
486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc ');
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_p_phone ' || p_p_phone);
489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_s_phone ' || p_s_phone);
490: END IF;
491: --
492: -- update change identifiers and new identifiers

Line 489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_s_phone ' || p_s_phone);

485:
486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc ');
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_p_phone ' || p_p_phone);
489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_s_phone ' || p_s_phone);
490: END IF;
491: --
492: -- update change identifiers and new identifiers
493: --

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

722:
723: --
724: -- insert/update disbursement information
725: --
726: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
727: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting cod db dtls');
728: END IF;
729:
730: FOR rec IN cur_disb_rec (p_loan_rec.award_id)

Line 727: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting cod db dtls');

723: --
724: -- insert/update disbursement information
725: --
726: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
727: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting cod db dtls');
728: END IF;
729:
730: FOR rec IN cur_disb_rec (p_loan_rec.award_id)
731: LOOP

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

756: x_rep_entity_id_txt => p_loan_rec.rep_entity_id_txt,
757: x_atd_entity_id_txt => p_loan_rec.atd_entity_id_txt,
758: x_mode => 'R');
759:
760: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);
762: END IF;
763: END LOOP;
764:

Line 761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);

757: x_atd_entity_id_txt => p_loan_rec.atd_entity_id_txt,
758: x_mode => 'R');
759:
760: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);
762: END IF;
763: END LOOP;
764:
765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

761: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);
762: END IF;
763: END LOOP;
764:
765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls');
767: END IF;
768:
769: EXCEPTION

Line 766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls');

762: END IF;
763: END LOOP;
764:
765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls');
767: END IF;
768:
769: EXCEPTION
770: WHEN OTHERS THEN

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

767: END IF;
768:
769: EXCEPTION
770: WHEN OTHERS THEN
771: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
772: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
773: END IF;
774: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
775: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');

Line 772: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);

768:
769: EXCEPTION
770: WHEN OTHERS THEN
771: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
772: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
773: END IF;
774: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
775: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');
776: app_exception.raise_exception;

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

820: --
821: -- 4. validate loans
822: --
823:
824: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','Calling validate Loan for Loan Number : ' || p_loan_rec.loan_number);
826: END IF;
827:
828: lb_valid_loan := igf_sl_dl_validation.cod_loan_validations(p_loan_rec,'JOB',p_isir_ssn,

Line 825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','Calling validate Loan for Loan Number : ' || p_loan_rec.loan_number);

821: -- 4. validate loans
822: --
823:
824: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
825: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','Calling validate Loan for Loan Number : ' || p_loan_rec.loan_number);
826: END IF;
827:
828: lb_valid_loan := igf_sl_dl_validation.cod_loan_validations(p_loan_rec,'JOB',p_isir_ssn,
829: p_isir_dob,p_isir_lname,

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

847: l_aid,
848: l_loan_tab,
849: l_msg_name
850: );
851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','The values returned from check_loan_limits l_aid : ' || l_aid);
853: END IF;
854: -- If the returned l_aid is 0 with no message returned or l_aid is greater than 0 then
855: -- the set up is fine otherwise show the corresponding error message in the log.

Line 852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','The values returned from check_loan_limits l_aid : ' || l_aid);

848: l_loan_tab,
849: l_msg_name
850: );
851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
852: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','The values returned from check_loan_limits l_aid : ' || l_aid);
853: END IF;
854: -- If the returned l_aid is 0 with no message returned or l_aid is greater than 0 then
855: -- the set up is fine otherwise show the corresponding error message in the log.
856: IF l_msg_name IS NOT NULL THEN

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

881: --
882: lb_spoint_est := FALSE;
883: SAVEPOINT IGFSL25B_PROCESS_LOAN;
884: lb_spoint_est := TRUE;
885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','inert lor loc for Loan Loan Number : ' || p_loan_rec.loan_number);
887: END IF;
888:
889: -- Get ISIR Information

Line 886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','inert lor loc for Loan Loan Number : ' || p_loan_rec.loan_number);

882: lb_spoint_est := FALSE;
883: SAVEPOINT IGFSL25B_PROCESS_LOAN;
884: lb_spoint_est := TRUE;
885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug','inert lor loc for Loan Loan Number : ' || p_loan_rec.loan_number);
887: END IF;
888:
889: -- Get ISIR Information
890: --

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

940: p_acad_begin,p_acad_end,p_s_phone, p_p_phone);
941:
942:
943: ELSE
944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug',' Failed validations Loan Number : ' || p_loan_rec.loan_number);
946: END IF;
947: END IF; -- valid loan
948:

Line 945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug',' Failed validations Loan Number : ' || p_loan_rec.loan_number);

941:
942:
943: ELSE
944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.process_loan.debug',' Failed validations Loan Number : ' || p_loan_rec.loan_number);
946: END IF;
947: END IF; -- valid loan
948:
949: EXCEPTION

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

947: END IF; -- valid loan
948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.process_loan.exception','Exception:'||SQLERRM);
953: END IF;
954: fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');
955: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);

Line 952: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.process_loan.exception','Exception:'||SQLERRM);

948:
949: EXCEPTION
950: WHEN OTHERS THEN
951: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.process_loan.exception','Exception:'||SQLERRM);
953: END IF;
954: fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');
955: fnd_message.set_token('LOAN_NUMBER',p_loan_rec.loan_number);
956: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PER_IN_FA');
1015: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.per_in_fa.exception','Exception:'||SQLERRM);
1017: END IF;
1018: igs_ge_msg_stack.add;
1019: app_exception.raise_exception;

Line 1016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.per_in_fa.exception','Exception:'||SQLERRM);

1012: WHEN OTHERS THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.PER_IN_FA');
1015: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1016: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.per_in_fa.exception','Exception:'||SQLERRM);
1017: END IF;
1018: igs_ge_msg_stack.add;
1019: app_exception.raise_exception;
1020: END per_in_fa;

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

1033: CURSOR cur_sequence IS SELECT IGF_SL_DL_GEN_XML_S.NEXTVAL FROM DUAL;
1034:
1035: BEGIN
1036:
1037: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1038: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','p_document id: '||p_document_id_txt);
1039: END IF;
1040:
1041: l_parameter_list := wf_parameter_list_t();

Line 1038: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','p_document id: '||p_document_id_txt);

1034:
1035: BEGIN
1036:
1037: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1038: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','p_document id: '||p_document_id_txt);
1039: END IF;
1040:
1041: l_parameter_list := wf_parameter_list_t();
1042: l_event_name := 'oracle.apps.igf.sl.genxml';

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

1047: OPEN cur_sequence;
1048: FETCH cur_sequence INTO l_event_key;
1049: CLOSE cur_sequence;
1050:
1051: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','l_event_key : '||l_event_key);
1053: END IF;
1054:
1055: -- Now add the parameters to the list to be passed to the workflow

Line 1052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','l_event_key : '||l_event_key);

1048: FETCH cur_sequence INTO l_event_key;
1049: CLOSE cur_sequence;
1050:
1051: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1052: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','l_event_key : '||l_event_key);
1053: END IF;
1054:
1055: -- Now add the parameters to the list to be passed to the workflow
1056:

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

1094: fnd_file.new_line(fnd_file.log,1);
1095: fnd_file.put_line(fnd_file.log,fnd_message.get);
1096: fnd_file.new_line(fnd_file.log,1);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','raised event ');
1100: END IF;
1101:
1102: EXCEPTION

Line 1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','raised event ');

1095: fnd_file.put_line(fnd_file.log,fnd_message.get);
1096: fnd_file.new_line(fnd_file.log,1);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','raised event ');
1100: END IF;
1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN

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

1100: END IF;
1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');

Line 1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);

1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1105: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.exception','Exception:'||SQLERRM);
1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;

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

1106: END IF;
1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;
1110: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);
1112: END IF;
1113: app_exception.raise_exception;
1114: END submit_xml_event;

Line 1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);

1107: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1108: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.SUBMIT_XML_EVENT');
1109: igs_ge_msg_stack.add;
1110: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event.debug','sqlerrm ' || SQLERRM);
1112: END IF;
1113: app_exception.raise_exception;
1114: END submit_xml_event;
1115:

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

1249: lv_person_id_group VARCHAR2(80);
1250:
1251: BEGIN
1252:
1253: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1254: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.debug','In log parameters');
1255: END IF;
1256:
1257: OPEN c_get_parameters;

Line 1254: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.debug','In log parameters');

1250:
1251: BEGIN
1252:
1253: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1254: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.debug','In log parameters');
1255: END IF;
1256:
1257: OPEN c_get_parameters;
1258: LOOP

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

1299: fnd_file.new_line(fnd_file.log,1);
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1304: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
1305: END IF;
1306: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1307: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');

Line 1304: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);

1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1304: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.log_parameters.exception','Exception:'||SQLERRM);
1305: END IF;
1306: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1307: fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.LOG_PARAMETERS');
1308: igs_ge_msg_stack.add;

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

1481: loan_key_rec.DELETE;
1482: gn_old_base_id := -1;
1483: gn_new_base_id := 0;
1484:
1485: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);

Line 1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);

1482: gn_old_base_id := -1;
1483: gn_new_base_id := 0;
1484:
1485: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);

Line 1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);

1483: gn_new_base_id := 0;
1484:
1485: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);

Line 1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);

1484:
1485: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);

Line 1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);

1485: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);

Line 1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);

1486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_award_year: '||p_award_year);
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);

Line 1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);

1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award cal_type : ' || lv_cal_type);
1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);

Line 1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);

1488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award ci_seq_num : ' || ln_seq_number);
1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);

Line 1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);

1489: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_source_id: '||p_source_id);
1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);
1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);

Line 1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);

1490: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_report_id:'||p_report_id);
1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);
1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);
1498: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_pgroup_id: '||p_pgroup_id);

Line 1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);

1491: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_attend_id: '||p_attend_id);
1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);
1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);
1498: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_pgroup_id: '||p_pgroup_id);
1499: END IF;

Line 1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);

1492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_id: '||p_fund_id);
1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);
1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);
1498: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_pgroup_id: '||p_pgroup_id);
1499: END IF;
1500:

Line 1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);

1493: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_fund_dummy: '||p_fund_dummy);
1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);
1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);
1498: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_pgroup_id: '||p_pgroup_id);
1499: END IF;
1500:
1501: -- 1. Print parameters

Line 1498: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_pgroup_id: '||p_pgroup_id);

1494: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_id: '||p_base_id);
1495: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_base_dummy: '||p_base_dummy);
1496: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_id: '||p_loan_id);
1497: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_loan_dummy: '||p_loan_dummy);
1498: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','p_pgroup_id: '||p_pgroup_id);
1499: END IF;
1500:
1501: -- 1. Print parameters
1502: log_parameters(lv_cal_type,ln_seq_number,

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

1507: p_base_id,
1508: p_loan_id,
1509: p_pgroup_id);
1510:
1511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','after log parameters');
1513: END IF;
1514:
1515: -- 2. Validate parameters

Line 1512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','after log parameters');

1508: p_loan_id,
1509: p_pgroup_id);
1510:
1511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','after log parameters');
1513: END IF;
1514:
1515: -- 2. Validate parameters
1516: IF p_award_year IS NULL OR lv_cal_type IS NULL OR ln_seq_number IS NULL THEN

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

1520: fnd_file.new_line(fnd_file.log, 1);
1521: RETURN;
1522: END IF;
1523:
1524: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year is not null');
1526: END IF;
1527:
1528: IF TRIM(p_source_id) IS NULL THEN

Line 1525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year is not null');

1521: RETURN;
1522: END IF;
1523:
1524: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1525: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year is not null');
1526: END IF;
1527:
1528: IF TRIM(p_source_id) IS NULL THEN
1529: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');

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

1540: fnd_file.new_line(fnd_file.log, 1);
1541: RETURN;
1542: END IF;
1543:
1544: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','source id is not null');
1546: END IF;
1547:
1548: IF p_pgroup_id IS NOT NULL AND p_base_id IS NOT NULL THEN

Line 1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','source id is not null');

1541: RETURN;
1542: END IF;
1543:
1544: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','source id is not null');
1546: END IF;
1547:
1548: IF p_pgroup_id IS NOT NULL AND p_base_id IS NOT NULL THEN
1549: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

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

1553: fnd_file.new_line(fnd_file.log, 1);
1554: RETURN;
1555: END IF;
1556:
1557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','base id and pgroup id check');
1559: END IF;
1560:
1561: IF p_pgroup_id IS NOT NULL AND p_loan_id IS NOT NULL THEN

Line 1558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','base id and pgroup id check');

1554: RETURN;
1555: END IF;
1556:
1557: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','base id and pgroup id check');
1559: END IF;
1560:
1561: IF p_pgroup_id IS NOT NULL AND p_loan_id IS NOT NULL THEN
1562: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

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

1566: fnd_file.new_line(fnd_file.log, 1);
1567: RETURN;
1568: END IF;
1569:
1570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check');
1572: END IF;
1573:
1574: IF p_attend_id IS NOT NULL AND p_report_id IS NULL THEN

Line 1571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check');

1567: RETURN;
1568: END IF;
1569:
1570: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1571: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check');
1572: END IF;
1573:
1574: IF p_attend_id IS NOT NULL AND p_report_id IS NULL THEN
1575: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATD_PARAM');

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

1581: OPEN cur_award_year(lv_cal_type,ln_seq_number);
1582: FETCH cur_award_year INTO award_year_rec;
1583: CLOSE cur_award_year;
1584:
1585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check 1');
1587: END IF;
1588:
1589: IF award_year_rec.sys_award_year IS NULL OR

Line 1586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check 1');

1582: FETCH cur_award_year INTO award_year_rec;
1583: CLOSE cur_award_year;
1584:
1585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','loan id and pgroup id check 1');
1587: END IF;
1588:
1589: IF award_year_rec.sys_award_year IS NULL OR
1590: award_year_rec.dl_participant_code IS NULL OR

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

1595: fnd_file.new_line(fnd_file.log, 1);
1596: RETURN;
1597: END IF;
1598:
1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','batch year not empty');
1601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','sys award year ' || award_year_rec.sys_award_year);
1602: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','dl participant code ' || award_year_rec.dl_participant_code);
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);

Line 1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','batch year not empty');

1596: RETURN;
1597: END IF;
1598:
1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','batch year not empty');
1601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','sys award year ' || award_year_rec.sys_award_year);
1602: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','dl participant code ' || award_year_rec.dl_participant_code);
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);
1604: END IF;

Line 1601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','sys award year ' || award_year_rec.sys_award_year);

1597: END IF;
1598:
1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','batch year not empty');
1601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','sys award year ' || award_year_rec.sys_award_year);
1602: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','dl participant code ' || award_year_rec.dl_participant_code);
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);
1604: END IF;
1605:

Line 1602: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','dl participant code ' || award_year_rec.dl_participant_code);

1598:
1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','batch year not empty');
1601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','sys award year ' || award_year_rec.sys_award_year);
1602: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','dl participant code ' || award_year_rec.dl_participant_code);
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);
1604: END IF;
1605:
1606: IF award_year_rec.award_year_status_code <> 'O' THEN

Line 1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);

1599: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1600: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','batch year not empty');
1601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','sys award year ' || award_year_rec.sys_award_year);
1602: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','dl participant code ' || award_year_rec.dl_participant_code);
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','award year status code ' || award_year_rec.award_year_status_code);
1604: END IF;
1605:
1606: IF award_year_rec.award_year_status_code <> 'O' THEN
1607: fnd_message.set_name('IGF','IGF_SL_COD_AWDYR_OPEN');

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

1702: END IF;
1703:
1704: -- End of validations
1705:
1706: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','parameter validation successful');
1708: END IF;
1709: --
1710: -- 3. Find Loans to be processed

Line 1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','parameter validation successful');

1703:
1704: -- End of validations
1705:
1706: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1707: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','parameter validation successful');
1708: END IF;
1709: --
1710: -- 3. Find Loans to be processed
1711: --

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

1753: END IF;
1754:
1755: FETCH cur_per_grp INTO l_person_id;
1756:
1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','Starting to process person group '||p_pgroup_id);
1759: END IF;
1760:
1761: IF cur_per_grp%NOTFOUND THEN

Line 1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','Starting to process person group '||p_pgroup_id);

1754:
1755: FETCH cur_per_grp INTO l_person_id;
1756:
1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','Starting to process person group '||p_pgroup_id);
1759: END IF;
1760:
1761: IF cur_per_grp%NOTFOUND THEN
1762: CLOSE cur_per_grp;

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

1761: IF cur_per_grp%NOTFOUND THEN
1762: CLOSE cur_per_grp;
1763: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1764: fnd_file.put_line(fnd_file.log,fnd_message.get);
1765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','No persons in group '||p_pgroup_id);
1767: END IF;
1768: ELSE
1769: IF cur_per_grp%FOUND THEN -- Check if the person exists in FA.

Line 1766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','No persons in group '||p_pgroup_id);

1762: CLOSE cur_per_grp;
1763: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1764: fnd_file.put_line(fnd_file.log,fnd_message.get);
1765: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','No persons in group '||p_pgroup_id);
1767: END IF;
1768: ELSE
1769: IF cur_per_grp%FOUND THEN -- Check if the person exists in FA.
1770: lb_record_exist := FALSE;

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

1776: IF ln_base_id IS NOT NULL THEN
1777: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1778: fnd_message.set_token('STDNT',lv_person_number);
1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);
1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);
1783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG l_person_id ' || l_person_id);
1784: END IF;

Line 1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);

1777: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1778: fnd_message.set_token('STDNT',lv_person_number);
1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);
1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);
1783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG l_person_id ' || l_person_id);
1784: END IF;
1785: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,

Line 1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);

1778: fnd_message.set_token('STDNT',lv_person_number);
1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);
1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);
1783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG l_person_id ' || l_person_id);
1784: END IF;
1785: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1786: ln_base_id,p_report_id,p_attend_id,

Line 1783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG l_person_id ' || l_person_id);

1779: fnd_file.put_line(fnd_file.log, fnd_message.get);
1780: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1781: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG base id ' || ln_base_id);
1782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG lv_person_number ' || lv_person_number);
1783: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','PIDG l_person_id ' || l_person_id);
1784: END IF;
1785: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1786: ln_base_id,p_report_id,p_attend_id,
1787: p_fund_id,p_loan_id)

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

1785: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1786: ln_base_id,p_report_id,p_attend_id,
1787: p_fund_id,p_loan_id)
1788: LOOP
1789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1790: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','Processing PIDG base id ' || ln_base_id);
1791: END IF;
1792: rec.grade_level_code := NVL(rec.override_grade_level_code,rec.grade_level_code);
1793: process_loan(rec,p_source_id);

Line 1790: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','Processing PIDG base id ' || ln_base_id);

1786: ln_base_id,p_report_id,p_attend_id,
1787: p_fund_id,p_loan_id)
1788: LOOP
1789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1790: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','Processing PIDG base id ' || ln_base_id);
1791: END IF;
1792: rec.grade_level_code := NVL(rec.override_grade_level_code,rec.grade_level_code);
1793: process_loan(rec,p_source_id);
1794: IF NOT lb_record_exist THEN

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

1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;
1806: END IF; -- base id not found
1807: ELSE

Line 1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');

1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;
1806: END IF; -- base id not found
1807: ELSE
1808: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

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

1828: -- base id or person group id is not given, so process records for given
1829: -- input combination
1830: IF p_base_id IS NULL AND p_pgroup_id IS NULL THEN
1831: lb_record_exist := FALSE;
1832: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' processing for other combo');
1834: END IF;
1835: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1836: p_base_id,p_report_id,p_attend_id,

Line 1833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' processing for other combo');

1829: -- input combination
1830: IF p_base_id IS NULL AND p_pgroup_id IS NULL THEN
1831: lb_record_exist := FALSE;
1832: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1833: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' processing for other combo');
1834: END IF;
1835: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1836: p_base_id,p_report_id,p_attend_id,
1837: p_fund_id,p_loan_id)

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

1858: OPEN cur_cod_dtls(gv_document_id_txt);
1859: FETCH cur_cod_dtls INTO cod_dtls_rec;
1860: CLOSE cur_cod_dtls;
1861:
1862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);
1864: END IF;
1865:
1866: IF cod_dtls_rec.document_id_txt IS NULL THEN

Line 1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);

1859: FETCH cur_cod_dtls INTO cod_dtls_rec;
1860: CLOSE cur_cod_dtls;
1861:
1862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1863: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' gv_document_id_txt ' || gv_document_id_txt);
1864: END IF;
1865:
1866: IF cod_dtls_rec.document_id_txt IS NULL THEN
1867: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');

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

1876: SELECT COUNT(*) INTO ln_rp FROM igf_sl_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1877: SELECT COUNT(*) INTO ln_as FROM igf_sl_rep_as_v WHERE document_id_txt = gv_document_id_txt;
1878: SELECT COUNT(*) INTO ln_st FROM igf_sl_rep_stdnt_v WHERE document_id_txt = gv_document_id_txt;
1879: SELECT COUNT(*) INTO ln_db FROM igf_sl_db_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );

Line 1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);

1877: SELECT COUNT(*) INTO ln_as FROM igf_sl_rep_as_v WHERE document_id_txt = gv_document_id_txt;
1878: SELECT COUNT(*) INTO ln_st FROM igf_sl_rep_stdnt_v WHERE document_id_txt = gv_document_id_txt;
1879: SELECT COUNT(*) INTO ln_db FROM igf_sl_db_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );

Line 1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );

1878: SELECT COUNT(*) INTO ln_st FROM igf_sl_rep_stdnt_v WHERE document_id_txt = gv_document_id_txt;
1879: SELECT COUNT(*) INTO ln_db FROM igf_sl_db_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );
1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );

Line 1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );

1879: SELECT COUNT(*) INTO ln_db FROM igf_sl_db_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );
1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );
1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );

Line 1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );

1880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );
1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );
1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );
1888: END IF;

Line 1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );

1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);
1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );
1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );
1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );
1888: END IF;
1889: IF ln_top = 0 OR ln_sm = 0 OR ln_rs = 0 OR ln_rp = 0 OR ln_as = 0 OR ln_st = 0 THEN

Line 1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );

1882: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_sm ' ||ln_sm );
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );
1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );
1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );
1888: END IF;
1889: IF ln_top = 0 OR ln_sm = 0 OR ln_rs = 0 OR ln_rp = 0 OR ln_as = 0 OR ln_st = 0 THEN
1890: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');

Line 1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );

1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rs ' ||ln_rs );
1884: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_rp ' ||ln_rp );
1885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_as ' ||ln_as );
1886: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_st ' ||ln_st );
1887: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_db ' ||ln_db );
1888: END IF;
1889: IF ln_top = 0 OR ln_sm = 0 OR ln_rs = 0 OR ln_rp = 0 OR ln_as = 0 OR ln_st = 0 THEN
1890: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');
1891: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1890: fnd_message.set_name('IGF','IGF_SL_COD_NO_DL_REC');
1891: fnd_file.put_line(fnd_file.log,fnd_message.get);
1892: RETURN;
1893: ELSE
1894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' before submit event ');
1896: END IF;
1897: submit_xml_event (gv_document_id_txt);
1898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' before submit event ');

1891: fnd_file.put_line(fnd_file.log,fnd_message.get);
1892: RETURN;
1893: ELSE
1894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' before submit event ');
1896: END IF;
1897: submit_xml_event (gv_document_id_txt);
1898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' after submit event ');

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

1894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' before submit event ');
1896: END IF;
1897: submit_xml_event (gv_document_id_txt);
1898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' after submit event ');
1900: END IF;
1901: END IF;
1902: END IF;

Line 1899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' after submit event ');

1895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' before submit event ');
1896: END IF;
1897: submit_xml_event (gv_document_id_txt);
1898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',' after submit event ');
1900: END IF;
1901: END IF;
1902: END IF;
1903:

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

1950: -- 5. Update LOR_LOC table, DISB table for Status
1951: -- 5. Print CLOB on the output file
1952: --
1953:
1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','p doc id ' || p_document_id_txt);
1956: END IF;
1957:
1958: OPEN c_get_parameters;

Line 1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','p doc id ' || p_document_id_txt);

1951: -- 5. Print CLOB on the output file
1952: --
1953:
1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','p doc id ' || p_document_id_txt);
1956: END IF;
1957:
1958: OPEN c_get_parameters;
1959: LOOP

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

1978: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
1979: fnd_file.new_line(fnd_file.log,1);
1980:
1981: edit_clob(p_document_id_txt,lc_newxmldoc,lv_rowid);
1982: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','After edit CLOB ');
1984: END IF;
1985: --
1986: -- update loan status or loan change status to sent

Line 1983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','After edit CLOB ');

1979: fnd_file.new_line(fnd_file.log,1);
1980:
1981: edit_clob(p_document_id_txt,lc_newxmldoc,lv_rowid);
1982: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','After edit CLOB ');
1984: END IF;
1985: --
1986: -- update loan status or loan change status to sent
1987: -- update disb status to sent

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

1985: --
1986: -- update loan status or loan change status to sent
1987: -- update disb status to sent
1988: update_status(p_document_id_txt);
1989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','Calling update status, doc id ' || p_document_id_txt);
1991: END IF;
1992: --
1993: --

Line 1990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','Calling update status, doc id ' || p_document_id_txt);

1986: -- update loan status or loan change status to sent
1987: -- update disb status to sent
1988: update_status(p_document_id_txt);
1989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','Calling update status, doc id ' || p_document_id_txt);
1991: END IF;
1992: --
1993: --
1994: -- print xml outfile

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

2012: retcode := 2;
2013: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2014: fnd_file.put_line(fnd_file.log,SQLERRM);
2015: igs_ge_msg_stack.conc_exception_hndl;
2016: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','sqlerrm ' || SQLERRM);
2018: END IF;
2019: app_exception.raise_exception;
2020:

Line 2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','sqlerrm ' || SQLERRM);

2013: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2014: fnd_file.put_line(fnd_file.log,SQLERRM);
2015: igs_ge_msg_stack.conc_exception_hndl;
2016: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','sqlerrm ' || SQLERRM);
2018: END IF;
2019: app_exception.raise_exception;
2020:
2021: END print_xml;

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

2040: -- 1. Read event data
2041: -- 2. Push xml into table
2042: -- 3. Launch Concurrent Request
2043: --
2044: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before reading lob ');
2046: END IF;
2047: l_event := wf_engine.getitemattrevent(
2048: itemtype,

Line 2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before reading lob ');

2041: -- 2. Push xml into table
2042: -- 3. Launch Concurrent Request
2043: --
2044: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before reading lob ');
2046: END IF;
2047: l_event := wf_engine.getitemattrevent(
2048: itemtype,
2049: itemkey,

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

2048: itemtype,
2049: itemkey,
2050: 'ECX_EVENT_MESSAGE');
2051:
2052: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2053: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' after reading lob ');
2054: END IF;
2055: l_clob := l_event.geteventdata;
2056:

Line 2053: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' after reading lob ');

2049: itemkey,
2050: 'ECX_EVENT_MESSAGE');
2051:
2052: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2053: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' after reading lob ');
2054: END IF;
2055: l_clob := l_event.geteventdata;
2056:
2057: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN

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

2057: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN
2058: resultout := 'EMPTY_CLOB';
2059: ELSE
2060:
2061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id ');
2063: END IF;
2064: lv_document_id_txt := NULL;
2065: lv_document_id_txt := wf_engine.getitemattrtext(

Line 2062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id ');

2058: resultout := 'EMPTY_CLOB';
2059: ELSE
2060:
2061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id ');
2063: END IF;
2064: lv_document_id_txt := NULL;
2065: lv_document_id_txt := wf_engine.getitemattrtext(
2066: itemtype,

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

2065: lv_document_id_txt := wf_engine.getitemattrtext(
2066: itemtype,
2067: itemkey,
2068: 'ECX_PARAMETER1');
2069: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2070: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id_txt);
2071: END IF;
2072:
2073: IF lv_document_id_txt IS NULL THEN

Line 2070: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id_txt);

2066: itemtype,
2067: itemkey,
2068: 'ECX_PARAMETER1');
2069: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2070: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' get doc id = ' || lv_document_id_txt);
2071: END IF;
2072:
2073: IF lv_document_id_txt IS NULL THEN
2074: resultout := 'DOCUMENT_ID_NOT_FOUND';

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

2073: IF lv_document_id_txt IS NULL THEN
2074: resultout := 'DOCUMENT_ID_NOT_FOUND';
2075: ELSE
2076: lv_rowid := NULL;
2077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');
2079: END IF;
2080:
2081: igf_sl_cod_doc_dtls_pkg.insert_row(

Line 2078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');

2074: resultout := 'DOCUMENT_ID_NOT_FOUND';
2075: ELSE
2076: lv_rowid := NULL;
2077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');
2079: END IF;
2080:
2081: igf_sl_cod_doc_dtls_pkg.insert_row(
2082: x_rowid => lv_rowid,

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

2089: x_doc_type => 'DL',
2090: x_full_resp_code => NULL,
2091: x_mode => 'R');
2092:
2093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2094: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before submitting req ');
2095: END IF;
2096:
2097: ln_request_id := apps.fnd_request.submit_request(

Line 2094: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before submitting req ');

2090: x_full_resp_code => NULL,
2091: x_mode => 'R');
2092:
2093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2094: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' before submitting req ');
2095: END IF;
2096:
2097: ln_request_id := apps.fnd_request.submit_request(
2098: 'IGF','IGFSLJ19','','',FALSE,

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

2108: '','','','','','','','','','',
2109: '','','','','','','','','','');
2110:
2111:
2112: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' request id ' || ln_request_id);
2114: END IF;
2115:
2116: IF ln_request_id = 0 THEN

Line 2113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' request id ' || ln_request_id);

2109: '','','','','','','','','','');
2110:
2111:
2112: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2113: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' request id ' || ln_request_id);
2114: END IF;
2115:
2116: IF ln_request_id = 0 THEN
2117: resultout := 'CONCURRENT_REQUEST_FAILED';

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

2126: resultout := 'E';
2127: wf_core.context ('IGF_SL_DL_GEN_XML',
2128: 'STORE_XML', itemtype,
2129: itemkey,to_char(actid), funcmode);
2130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);
2132: END IF;
2133: END store_xml;
2134:

Line 2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);

2127: wf_core.context ('IGF_SL_DL_GEN_XML',
2128: 'STORE_XML', itemtype,
2129: itemkey,to_char(actid), funcmode);
2130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug','sqlerrm ' || SQLERRM);
2132: END IF;
2133: END store_xml;
2134:
2135: END igf_sl_dl_gen_xml;