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 IGS_FI_GEN_GL

Line 32: igs_fi_gen_gl.get_lkp_meaning function.

28: smadathi 9-Jan-2003 Bug 2722096. Modified procedures mass_apply and mass_application.
29: vvutukur 13-Dec-2002 Enh#2584741.Deposits Build. Modifications done in eff_max_date,eff_min_date,mass_apply.
30: smadathi 20-NOV-2002 Enh. Bug 2584986. Added new parameter GL Date to procedure mass_application
31: and mass_apply.Private function lookup_desc removed and usage replaced by
32: igs_fi_gen_gl.get_lkp_meaning function.
33: schodava 19-Sep-2002 Enh # 2564643 - Subaccount Removal
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

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 725: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PARTY'));

721: FETCH cur_fund_auth INTO l_fund_auth;
722: CLOSE cur_fund_auth;
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');

Line 730: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));

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));
732: fnd_file.put_line(fnd_file.log, fnd_message.Get);
733:
734: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');

Line 735: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_NUMBER'));

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);
737: fnd_file.put_line(fnd_file.log, fnd_message.Get);
738:
739: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');

Line 740: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_TYPE_NAME'));

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);
742: fnd_file.put_line(fnd_file.log, fnd_message.Get);
743:
744: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');

Line 745: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CREDIT_DATE_LOW'));

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);
747: fnd_file.put_line(fnd_file.log, fnd_message.Get);
748:
749: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');

Line 750: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_HIGH'));

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);
752: fnd_file.put_line(fnd_file.log, fnd_message.Get);
753:
754: fnd_message.set_name('IGS','IGS_FI_GEN_PARAMETER');

Line 755: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE'));

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);
757: fnd_file.put_line(fnd_file.log, fnd_message.Get);
758:
759:

Line 790: igs_fi_gen_gl.get_period_status_for_date (p_d_date => p_d_gl_date,

786: END IF;
787:
788: -- validate the GL Date parameter passed to the process
789: -- This procedure returns the derived Closing status of the period in which the passed GL Date belongs to
790: igs_fi_gen_gl.get_period_status_for_date (p_d_date => p_d_gl_date,
791: p_v_closing_status => l_c_closing_status,
792: p_v_message_name => l_message_name
793: );
794: -- if the derived closing status is other than 'F' or 'O' , log the error and error out NOCOPY of the process

Line 826: fnd_message.set_token('DATE_LOW',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_LOW'));

822: --If both credit date high and credit date low are specified then high date should be greater than or equal to low date
823: IF p_credit_date_low IS NOT NULL AND p_credit_date_high IS NOT NULL THEN
824: IF TRUNC(l_credit_date_low) > TRUNC(l_credit_date_high) THEN
825: fnd_message.Set_Name('IGS','IGS_FI_TRAN_LOW_HIGH');
826: fnd_message.set_token('DATE_LOW',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_LOW'));
827: fnd_message.set_token('DATE_HIGH',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_HIGH'));
828: igs_ge_msg_stack.add;
829: app_exception.raise_exception;
830: END IF;

Line 827: fnd_message.set_token('DATE_HIGH',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_HIGH'));

823: IF p_credit_date_low IS NOT NULL AND p_credit_date_high IS NOT NULL THEN
824: IF TRUNC(l_credit_date_low) > TRUNC(l_credit_date_high) THEN
825: fnd_message.Set_Name('IGS','IGS_FI_TRAN_LOW_HIGH');
826: fnd_message.set_token('DATE_LOW',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_LOW'));
827: fnd_message.set_token('DATE_HIGH',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','CREDIT_DATE_HIGH'));
828: igs_ge_msg_stack.add;
829: app_exception.raise_exception;
830: END IF;
831: END IF;

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 927: l_msg_str_1 :=igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','APPL_HIER_NAME') || l_hierarchies.hierarchy_name;

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;
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 */

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

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

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 998: l_msg_str_1 := ' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPES') || l_adl_app_rules.fee_type ||

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

Line 999: ','|| igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RULE_SEQ') ||to_char( l_adl_app_rules.rule_sequence);

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

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 1155: l_msg_str_1 := ' '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPES') || l_app_rules.fee_type

1151: LOOP
1152: FETCH cur_app_rules INTO l_app_rules;
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;

Line 1156: ||','|| igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','RULE_SEQ') ||to_char( l_app_rules.rule_sequence);

1152: FETCH cur_app_rules INTO l_app_rules;
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);

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

1198: LOOP
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;

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;