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.IGS_FI_PRC_APPL dependencies on FND_FILE

Line 38: vvutukur 26-apr-2002 Changed the case of fnd_file.put_line to lower and

34: Modified procedures mass_application, mass_apply
35: agairola 23-May-2002 Added the procedure get_cal_details for the bug 2378182. Modified
36: the code in the procedure mass_apply
37: agairola 21-May-2002 Modified the procedure mass_apply for bug 2377976
38: vvutukur 26-apr-2002 Changed the case of fnd_file.put_line to lower and
39: used fnd_file.new_line instead of writing a null string by fnd_file.put_line.
40: bug#2326163.
41: vvutukur 22-APR-2002 Modified as part of bug#2326163 not to show ids in log file but
42: numbers and names.

Line 39: used fnd_file.new_line instead of writing a null string by fnd_file.put_line.

35: agairola 23-May-2002 Added the procedure get_cal_details for the bug 2378182. Modified
36: the code in the procedure mass_apply
37: agairola 21-May-2002 Modified the procedure mass_apply for bug 2377976
38: vvutukur 26-apr-2002 Changed the case of fnd_file.put_line to lower and
39: used fnd_file.new_line instead of writing a null string by fnd_file.put_line.
40: bug#2326163.
41: vvutukur 22-APR-2002 Modified as part of bug#2326163 not to show ids in log file but
42: numbers and names.
43: smadathi 28-Feb-2002 Bug. 2238413. modified mass _application procedure.

Line 154: vvutukur 26-apr-2002 fnd_file.put_line is changed to lower case and fnd_file.new_line is used

150: akandreg 17-May-2006 Bug 5134636: Removed commit for each application record
151: smadathi 20-NOV-2002 Enh. Bug 2584986. Added new parameter GL Date to procedure. Added cursors
152: c_igs_fi_invln_int and c_igs_fi_credits to obtain the charge and credit
153: GL Dates.
154: vvutukur 26-apr-2002 fnd_file.put_line is changed to lower case and fnd_file.new_line is used
155: instead of writing null string by fnd_file.put_line.bug#2326163.
156: vvutukur 22-apr-2002 Removed the code showing log horizontally. Modified to show numbers and
157: names in the log file instead of ids. bug#2326163.
158: ****************************************************************/

Line 155: instead of writing null string by fnd_file.put_line.bug#2326163.

151: smadathi 20-NOV-2002 Enh. Bug 2584986. Added new parameter GL Date to procedure. Added cursors
152: c_igs_fi_invln_int and c_igs_fi_credits to obtain the charge and credit
153: GL Dates.
154: vvutukur 26-apr-2002 fnd_file.put_line is changed to lower case and fnd_file.new_line is used
155: instead of writing null string by fnd_file.put_line.bug#2326163.
156: vvutukur 22-apr-2002 Removed the code showing log horizontally. Modified to show numbers and
157: names in the log file instead of ids. bug#2326163.
158: ****************************************************************/
159:

Line 242: fnd_file.put_line(fnd_file.log,fnd_message.Get);

238: fnd_message.set_name('IGS',l_v_app_error_message);
239: fnd_message.set_token('GL_DATE',p_d_gl_date);
240: fnd_message.set_token('CHG_GL_DATE',rec_c_igs_fi_invln_int.gl_date);
241: fnd_message.set_token('CRD_GL_DATE',rec_c_igs_fi_credits.gl_date);
242: fnd_file.put_line(fnd_file.log,fnd_message.Get);
243: END IF;
244:
245: P_counter := NVL(P_counter,0) + 1;
246: /** logging Invoice table details **/

Line 259: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_NUMBER')||' : '||l_invoice_number);

255: l_cr_ccid_str := l_v_cr_account_cd;
256: END IF;
257:
258: --Show log for invoice and application details.
259: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_NUMBER')||' : '||l_invoice_number);
260: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||' : '||p_fee_type);
261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);
262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));

Line 260: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||' : '||p_fee_type);

256: END IF;
257:
258: --Show log for invoice and application details.
259: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_NUMBER')||' : '||l_invoice_number);
260: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||' : '||p_fee_type);
261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);
262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:

Line 261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);

257:
258: --Show log for invoice and application details.
259: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_NUMBER')||' : '||l_invoice_number);
260: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||' : '||p_fee_type);
261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);
262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));

Line 262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));

258: --Show log for invoice and application details.
259: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_NUMBER')||' : '||l_invoice_number);
260: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||' : '||p_fee_type);
261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);
262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));
266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);

Line 263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));

259: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_NUMBER')||' : '||l_invoice_number);
260: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||' : '||p_fee_type);
261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);
262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));
266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);
267: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CR_ACCOUNT')||' : '||l_cr_ccid_str);

Line 265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));

261: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_CAL_TYPE')||' : '||p_fee_cal_type);
262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));
266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);
267: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CR_ACCOUNT')||' : '||l_cr_ccid_str);
268: fnd_file.new_line(fnd_file.log);
269:

Line 266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);

262: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_DUE')||' : '||TO_CHAR(p_orig_invoice_amount_due));
263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));
266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);
267: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CR_ACCOUNT')||' : '||l_cr_ccid_str);
268: fnd_file.new_line(fnd_file.log);
269:
270: ELSE

Line 267: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CR_ACCOUNT')||' : '||l_cr_ccid_str);

263: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','INVOICE_AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_invoice_amount_due),0));
264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));
266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);
267: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CR_ACCOUNT')||' : '||l_cr_ccid_str);
268: fnd_file.new_line(fnd_file.log);
269:
270: ELSE
271: /*Failure*/

Line 268: fnd_file.new_line(fnd_file.log);

264:
265: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','AMOUNT_APPLIED')||' : '||NVL(TO_CHAR(p_amount_applied),0));
266: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','DR_ACCOUNT')||' : '||l_dr_ccid_str);
267: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CR_ACCOUNT')||' : '||l_cr_ccid_str);
268: fnd_file.new_line(fnd_file.log);
269:
270: ELSE
271: /*Failure*/
272: fnd_message.Set_Name('IGS',l_v_app_error_message);

Line 273: fnd_file.put_line(fnd_file.log, fnd_message.Get);

269:
270: ELSE
271: /*Failure*/
272: fnd_message.Set_Name('IGS',l_v_app_error_message);
273: fnd_file.put_line(fnd_file.log, fnd_message.Get);
274: fnd_file.put_line(fnd_file.log,' ');
275: END IF;
276:
277: EXCEPTION

Line 274: fnd_file.put_line(fnd_file.log,' ');

270: ELSE
271: /*Failure*/
272: fnd_message.Set_Name('IGS',l_v_app_error_message);
273: fnd_file.put_line(fnd_file.log, fnd_message.Get);
274: fnd_file.put_line(fnd_file.log,' ');
275: END IF;
276:
277: EXCEPTION
278: WHEN OTHERS THEN

Line 280: fnd_file.put_line(fnd_file.log, fnd_message.Get);

276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
280: fnd_file.put_line(fnd_file.log, fnd_message.Get);
281: RETURN;
282: END apply_and_log_messages;
283:
284: PROCEDURE get_cal_details(p_fee_cal_type igs_ca_inst.cal_type%TYPE,

Line 427: fnd_file.put_line(fnd_file.log,fnd_message.get);

423:
424: EXCEPTION
425: WHEN OTHERS THEN
426: IF IGS_GE_MSG_STACK.COUNT_MSG <> 0 THEN
427: fnd_file.put_line(fnd_file.log,fnd_message.get);
428: RAISE l_err_exception;
429: ELSE
430: RAISE;
431: END IF;

Line 441: fnd_file.put_line(fnd_file.log,sqlerrm);

437: WHEN OTHERS THEN
438: retcode := 2;
439: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
440: errbuf := fnd_message.get;
441: fnd_file.put_line(fnd_file.log,sqlerrm);
442: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
443: END mass_application;
444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,

Line 727: fnd_file.put_line(fnd_file.log, fnd_message.Get);

723:
724: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
725: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY'));
726: fnd_message.set_token('PARM_VALUE', l_fund_auth.party_number);
727: fnd_file.put_line(fnd_file.log, fnd_message.Get);
728:
729: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
730: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
731: fnd_message.set_token('PARM_VALUE',igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));

Line 732: fnd_file.put_line(fnd_file.log, fnd_message.Get);

728:
729: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
730: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
731: fnd_message.set_token('PARM_VALUE',igs_fi_gen_005.finp_get_prsid_grp_code(p_person_id_grp));
732: fnd_file.put_line(fnd_file.log, fnd_message.Get);
733:
734: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
735: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER'));
736: fnd_message.set_token('PARM_VALUE', p_credit_number);

Line 737: fnd_file.put_line(fnd_file.log, fnd_message.Get);

733:
734: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
735: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER'));
736: fnd_message.set_token('PARM_VALUE', p_credit_number);
737: fnd_file.put_line(fnd_file.log, fnd_message.Get);
738:
739: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
740: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_TYPE_NAME'));
741: fnd_message.set_token('PARM_VALUE', l_credit_type_name);

Line 742: fnd_file.put_line(fnd_file.log, fnd_message.Get);

738:
739: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
740: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_TYPE_NAME'));
741: fnd_message.set_token('PARM_VALUE', l_credit_type_name);
742: fnd_file.put_line(fnd_file.log, fnd_message.Get);
743:
744: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
745: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_DATE_LOW'));
746: fnd_message.set_token('PARM_VALUE', p_credit_date_low);

Line 747: fnd_file.put_line(fnd_file.log, fnd_message.Get);

743:
744: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
745: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_DATE_LOW'));
746: fnd_message.set_token('PARM_VALUE', p_credit_date_low);
747: fnd_file.put_line(fnd_file.log, fnd_message.Get);
748:
749: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
750: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_HIGH'));
751: fnd_message.set_token('PARM_VALUE', p_credit_date_high);

Line 752: fnd_file.put_line(fnd_file.log, fnd_message.Get);

748:
749: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
750: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_HIGH'));
751: fnd_message.set_token('PARM_VALUE', p_credit_date_high);
752: fnd_file.put_line(fnd_file.log, fnd_message.Get);
753:
754: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
755: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE'));
756: fnd_message.set_token('PARM_VALUE', p_d_gl_date);

Line 757: fnd_file.put_line(fnd_file.log, fnd_message.Get);

753:
754: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');
755: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE'));
756: fnd_message.set_token('PARM_VALUE', p_d_gl_date);
757: fnd_file.put_line(fnd_file.log, fnd_message.Get);
758:
759:
760: -- Obtain the value of manage_accounts in the System Options form
761: -- If it is null or 'OTHER', then this process is not available, so error out.

Line 878: fnd_file.put_line(fnd_file.log,l_msg_str_0);

874: CLOSE cur_title4_ind;
875:
876: l_msg_str_0 := '----------------------------------------------------------------------------------------';
877:
878: fnd_file.put_line(fnd_file.log,l_msg_str_0);
879: fnd_file.new_line(fnd_file.log);
880:
881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);

Line 879: fnd_file.new_line(fnd_file.log);

875:
876: l_msg_str_0 := '----------------------------------------------------------------------------------------';
877:
878: fnd_file.put_line(fnd_file.log,l_msg_str_0);
879: fnd_file.new_line(fnd_file.log);
880:
881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);

Line 881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);

877:
878: fnd_file.put_line(fnd_file.log,l_msg_str_0);
879: fnd_file.new_line(fnd_file.log);
880:
881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));

Line 882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);

878: fnd_file.put_line(fnd_file.log,l_msg_str_0);
879: fnd_file.new_line(fnd_file.log);
880:
881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));

Line 883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);

879: fnd_file.new_line(fnd_file.log);
880:
881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));
887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));

Line 884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));

880:
881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));
887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));
888: fnd_file.new_line(fnd_file.log);

Line 885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));

881: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));
887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));
888: fnd_file.new_line(fnd_file.log);
889:

Line 886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));

882: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER')||' : '||l_credits.credit_number);
883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));
887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));
888: fnd_file.new_line(fnd_file.log);
889:
890: -- Capture the credits unapplied amount before the application to charges begin

Line 887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));

883: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_TYPE_NAME')||' : '||l_credits.credit_type_name);
884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));
887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));
888: fnd_file.new_line(fnd_file.log);
889:
890: -- Capture the credits unapplied amount before the application to charges begin
891: l_credits_unapplied_amount := l_credits.unapplied_amount;

Line 888: fnd_file.new_line(fnd_file.log);

884: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','UNAPPLIED_AMOUNT')||' : '||TO_CHAR(l_credits.unapplied_amount));
885: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TITLE4_IND')||' : '||NVL(l_title4_ind.title4_type_ind,'N'));
886: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FUND_AUTH')||' : '||NVL(l_fund_auth.fund_authorization,'N'));
887: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||' : '||l_credits.fee_cal_type||' '||TO_CHAR(l_credits.fee_ci_sequence_number));
888: fnd_file.new_line(fnd_file.log);
889:
890: -- Capture the credits unapplied amount before the application to charges begin
891: l_credits_unapplied_amount := l_credits.unapplied_amount;
892:

Line 906: fnd_file.put_line(fnd_file.log,

902: p_message => l_message_name,
903: p_status => l_status);
904: IF NOT l_status THEN
905: fnd_message.set_name('IGS',l_message_name);
906: fnd_file.put_line(fnd_file.log,
907: fnd_message.get);
908: l_process_credit := FALSE;
909: END IF;
910: END IF;

Line 922: fnd_file.put_line(fnd_file.log,fnd_message.Get);

918: FETCH cur_hierarchies INTO l_hierarchies;
919: IF cur_hierarchies%NOTFOUND THEN
920: fnd_message.set_name('IGS','IGS_FI_NO_APPL_HIER');
921: fnd_message.set_token('CREDIT_ID',l_credits.credit_number);
922: fnd_file.put_line(fnd_file.log,fnd_message.Get);
923: fnd_file.new_line(fnd_file.log);
924: END IF;
925: CLOSE cur_hierarchies;
926:

Line 923: fnd_file.new_line(fnd_file.log);

919: IF cur_hierarchies%NOTFOUND THEN
920: fnd_message.set_name('IGS','IGS_FI_NO_APPL_HIER');
921: fnd_message.set_token('CREDIT_ID',l_credits.credit_number);
922: fnd_file.put_line(fnd_file.log,fnd_message.Get);
923: fnd_file.new_line(fnd_file.log);
924: END IF;
925: CLOSE cur_hierarchies;
926:
927: l_msg_str_1 :=igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','APPL_HIER_NAME') || l_hierarchies.hierarchy_name;

Line 928: fnd_file.put_line(fnd_file.log,l_msg_str_1);

924: END IF;
925: CLOSE cur_hierarchies;
926:
927: l_msg_str_1 :=igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','APPL_HIER_NAME') || l_hierarchies.hierarchy_name;
928: fnd_file.put_line(fnd_file.log,l_msg_str_1);
929: fnd_file.new_line(fnd_file.log);
930:
931: /* Check if the IGS_FI_FUND_AUTH profile is set to Y */
932: IF l_v_fund_auth_profile = 'Y' THEN

Line 929: fnd_file.new_line(fnd_file.log);

925: CLOSE cur_hierarchies;
926:
927: l_msg_str_1 :=igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','APPL_HIER_NAME') || l_hierarchies.hierarchy_name;
928: fnd_file.put_line(fnd_file.log,l_msg_str_1);
929: fnd_file.new_line(fnd_file.log);
930:
931: /* Check if the IGS_FI_FUND_AUTH profile is set to Y */
932: IF l_v_fund_auth_profile = 'Y' THEN
933: /* Check if the credit is title 4 */

Line 940: fnd_file.put_line(fnd_file.log,' '||fnd_message.Get);

936: IF (l_credits.fee_cal_type IS NULL OR l_credits.fee_ci_sequence_number IS NULL) THEN
937: l_b_f_period_missing := TRUE;
938: fnd_message.set_name('IGS','IGS_FI_FEEPERIOD_NULL');
939: fnd_message.set_token('CREDIT_ID', l_credits.credit_number );
940: fnd_file.put_line(fnd_file.log,' '||fnd_message.Get);
941: fnd_file.new_line(fnd_file.log);
942: END IF;
943: /* Proceed only if the fee period is present for Title IV Credits */
944: IF NOT l_b_f_period_missing THEN

Line 941: fnd_file.new_line(fnd_file.log);

937: l_b_f_period_missing := TRUE;
938: fnd_message.set_name('IGS','IGS_FI_FEEPERIOD_NULL');
939: fnd_message.set_token('CREDIT_ID', l_credits.credit_number );
940: fnd_file.put_line(fnd_file.log,' '||fnd_message.Get);
941: fnd_file.new_line(fnd_file.log);
942: END IF;
943: /* Proceed only if the fee period is present for Title IV Credits */
944: IF NOT l_b_f_period_missing THEN
945: /* Check if the person has funds authorization */

Line 948: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ALLOW'));

944: IF NOT l_b_f_period_missing THEN
945: /* Check if the person has funds authorization */
946: IF NVL(l_fund_auth.fund_authorization,'N') = 'Y' THEN
947: /** This section is for profile Y , title4 Y and fund auth Y **/
948: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ALLOW'));
949: OPEN cur_app_rules(l_hierarchies.appl_hierarchy_id); -- All Allowed rules
950: LOOP
951: FETCH cur_app_rules INTO l_app_rules;
952: EXIT WHEN ( cur_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);

Line 954: fnd_file.put_line(fnd_file.log,l_msg_str_1);

950: LOOP
951: FETCH cur_app_rules INTO l_app_rules;
952: EXIT WHEN ( cur_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);
953: l_msg_str_1 := ' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPES') || l_app_rules.fee_type ||','|| igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RULE_SEQ') ||to_char( l_app_rules.rule_sequence);
954: fnd_file.put_line(fnd_file.log,l_msg_str_1);
955:
956: -- Get the records from the charges table for a fee_type, person id and fee period
957: l_charges_amount := 0;
958: OPEN cur_charges(l_app_rules.fee_type,l_credits.party_id,l_credits.fee_cal_type,l_credits.fee_ci_sequence_number);

Line 992: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ADDITION'));

988: CLOSE cur_app_rules;
989:
990: /**** If local varible unapplied amount is still left then proceed to pick up from Additional Authorized****/
991: IF l_credits_unapplied_amount > 0 THEN
992: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ADDITION'));
993: OPEN cur_adl_app_rules(l_hierarchies.appl_hierarchy_id);
994: LOOP
995: FETCH cur_adl_app_rules INTO l_adl_app_rules;
996: EXIT WHEN ( cur_adl_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);

Line 1000: fnd_file.put_line(fnd_file.log,l_msg_str_1);

996: EXIT WHEN ( cur_adl_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);
997:
998: l_msg_str_1 := ' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPES') || l_adl_app_rules.fee_type ||
999: ','|| igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RULE_SEQ') ||to_char( l_adl_app_rules.rule_sequence);
1000: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1001:
1002: -- Get the records from the charges table for a fee_type, person id and fee period
1003: l_charges_amount := 0;
1004: OPEN cur_charges(l_adl_app_rules.fee_type,l_credits.party_id,l_credits.fee_cal_type,l_credits.fee_ci_sequence_number);

Line 1149: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ALLOW'));

1145: CLOSE cur_adl_app_rules;
1146: END IF; -- Unapplied amount
1147: ELSIF NVL(l_fund_auth.fund_authorization,'N') = 'N' THEN
1148: /** This section is for profile Y , title4 Y and fund auth N **/
1149: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ALLOW'));
1150: OPEN cur_app_rules(l_hierarchies.appl_hierarchy_id);
1151: LOOP
1152: FETCH cur_app_rules INTO l_app_rules;
1153: EXIT WHEN ( cur_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);

Line 1157: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1153: EXIT WHEN ( cur_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);
1154:
1155: l_msg_str_1 := ' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPES') || l_app_rules.fee_type
1156: ||','|| igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RULE_SEQ') ||to_char( l_app_rules.rule_sequence);
1157: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1158: -- Get the records from the charges table for a fee_type, person id for the fee period only
1159: l_charges_amount := 0;
1160: OPEN cur_charges(l_app_rules.fee_type,l_credits.party_id,l_credits.fee_cal_type,l_credits.fee_ci_sequence_number);
1161: LOOP

Line 1196: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ALLOW'));

1192: END IF; -- For Fee Period Present
1193: END IF; --For title4 = 'Y'
1194: END IF; --For Profile = 'Y'
1195: IF (l_v_fund_auth_profile = 'N' OR NVL(l_title4_ind.title4_type_ind,'N') = 'N') THEN
1196: fnd_file.put_line(fnd_file.log,' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RULE_TYPE','ALLOW'));
1197: OPEN cur_app_rules(l_hierarchies.appl_hierarchy_id); -- All Allowed rules
1198: LOOP
1199: FETCH cur_app_rules INTO l_app_rules;
1200: EXIT WHEN ( cur_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);

Line 1203: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1199: FETCH cur_app_rules INTO l_app_rules;
1200: EXIT WHEN ( cur_app_rules%NOTFOUND OR l_credits_unapplied_amount = 0);
1201:
1202: l_msg_str_1 := ' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPES') || l_app_rules.fee_type ||','|| igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RULE_SEQ') ||to_char( l_app_rules.rule_sequence);
1203: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1204:
1205: -- Get the records from the charges table for a fee_type, person id w/o considering fee period at all - Fund Authorization also need not considered
1206: l_charges_amount := 0;
1207: OPEN cur_charges_normal(l_app_rules.fee_type,l_credits.party_id);

Line 1246: fnd_file.put_line(fnd_file.log,' '||fnd_message.Get);

1242: IF l_n_charges_app_count = 0 THEN
1243: fnd_message.set_name('IGS','IGS_FI_NO_ELIG_CHGAPP');
1244: fnd_message.set_token('PERSON_ID', l_fund_auth.party_number);
1245: fnd_message.set_token('CREDIT_ID', l_credits.credit_number);
1246: fnd_file.put_line(fnd_file.log,' '||fnd_message.Get);
1247: fnd_file.new_line(fnd_file.log);
1248: END IF;
1249: END IF; -- For the l_process_credit
1250: END LOOP;

Line 1247: fnd_file.new_line(fnd_file.log);

1243: fnd_message.set_name('IGS','IGS_FI_NO_ELIG_CHGAPP');
1244: fnd_message.set_token('PERSON_ID', l_fund_auth.party_number);
1245: fnd_message.set_token('CREDIT_ID', l_credits.credit_number);
1246: fnd_file.put_line(fnd_file.log,' '||fnd_message.Get);
1247: fnd_file.new_line(fnd_file.log);
1248: END IF;
1249: END IF; -- For the l_process_credit
1250: END LOOP;
1251: CLOSE cur_credits;

Line 1256: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);

1252: EXCEPTION
1253: WHEN e_lock_exception THEN
1254: ROLLBACK TO APPL_SP1;
1255: g_v_lock := 'Y';
1256: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
1257: fnd_message.set_name('IGS',
1258: 'IGS_FI_APPL_PRC_RUN');
1259: fnd_file.put_line(fnd_file.log, fnd_message.get);
1260: END;

Line 1259: fnd_file.put_line(fnd_file.log, fnd_message.get);

1255: g_v_lock := 'Y';
1256: fnd_file.put_line(fnd_file.log,igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY')||' : '||l_fund_auth.party_number);
1257: fnd_message.set_name('IGS',
1258: 'IGS_FI_APPL_PRC_RUN');
1259: fnd_file.put_line(fnd_file.log, fnd_message.get);
1260: END;
1261: END LOOP;
1262: END IF; -- End if of IF checking for v_tab_party_rec.COUNT > 0
1263: END mass_apply;