[Home] [Help]
11: || (reverse chronological order - newest change first)
12: || pathipat 17-May-2006 Bug 5104599 - Modified create_credit
13: || sapanigr 03-May-2006 Enh#3924836 Precision Issue. Modified create_credit.
14: uudayapr 8-Oct-2005 BUG 4660773 Commentted the Code LOgic introduced as part of Credit Card Enryption enhancement
15: || gurprsin 26-Sep-2005 Bug 4607540, In create_credit, Credit Card Enryption enhancement, Modified the call to igs_fi_credits_pkg.insert_row method.
16: || gurprsin 13-Sep-2005 Bug 3627209, After calling build accounts process, Added message on to the stack before adding it on to the fnd_message_pub.
17: || pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
18: || parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
19: || svuppala 9-JUN-2005 Enh 4213629 - The automatic generation of the Receipt Number.
20: || Added x_credit_number OUT parameter
21: || bannamal 03-Jun-2005 Bug#3442712 Unit Level Fee Assessment Build. Modified the call
22: to igs_fi_prc_acct_pkg.build_accounts to add new paramters.
23: || pathipat 22-Apr-2004 Enh 3558549 - Comm Receivables Enhancements
24: || Modified TBH call to igs_fi_credits_pkg in create_credit()
25: || vvutukur 14-Sep-2003 Enh#3045007.Payment Plans Build. Modified create_credit.
26: || pathipat 13-Aug-2003 Enh 3076768 - Automatic Release of Holds
27: || Proc create_credit(): Added call to finp_auto_release_holds()
28: || vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Modified create_credit procedure.
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_credit_rec IN credit_rec_type,
44: p_attribute_record IN igs_fi_credits_api_pub.attribute_rec_type,
45: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
46: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
47: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
48: ) AS
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_credit_rec IN credit_rec_type,
44: p_attribute_record IN igs_fi_credits_api_pub.attribute_rec_type,
45: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
46: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
47: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
48: ) AS
49: /*----------------------------------------------------------------------------
43: p_credit_rec IN credit_rec_type,
44: p_attribute_record IN igs_fi_credits_api_pub.attribute_rec_type,
45: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
46: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
47: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
48: ) AS
49: /*----------------------------------------------------------------------------
50: || Created By : vvutukur
51: || Created On : 03-Apr-2003
56: || (reverse chronological order - newest change first)
57: || pathipat 17-May-2006 Bug 5104599 - After call to igs_fi_prc_balances.update_balances, added condition to not raise
58: || exception if the messages were regd exclusion of credit types or fee types
59: || svuppala 05-May-2006 Enh#3924836 Precision Issue. Done the formatting of amount in the beginning itslef
60: || sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted to igs_fi_credits and
61: || igs_fi_cr_activities_pkg are now rounded off to currency precision
62: uudayapr 8-Oct-2005 BUG 4660773 Commentted the Code LOgic introduced as part of Credit Card Enryption enhancement
63: || gurprsin 26-Sep-2005 Bug 4607540, Credit Card Enryption enhancement, Modified the call to igs_fi_credits_pkg.insert_row method.
64: || pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
59: || svuppala 05-May-2006 Enh#3924836 Precision Issue. Done the formatting of amount in the beginning itslef
60: || sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted to igs_fi_credits and
61: || igs_fi_cr_activities_pkg are now rounded off to currency precision
62: uudayapr 8-Oct-2005 BUG 4660773 Commentted the Code LOgic introduced as part of Credit Card Enryption enhancement
63: || gurprsin 26-Sep-2005 Bug 4607540, Credit Card Enryption enhancement, Modified the call to igs_fi_credits_pkg.insert_row method.
64: || pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
65: || parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
66: || svuppala 9-JUN-2005 Enh 4213629 - The automatic generation of the Receipt Number.
67: || Added x_credit_number OUT parameter
65: || parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
66: || svuppala 9-JUN-2005 Enh 4213629 - The automatic generation of the Receipt Number.
67: || Added x_credit_number OUT parameter
68: || pathipat 22-Apr-2004 Enh 3558549 - Comm Receivables Enhancements
69: || Added param x_source_invoice_id in call to igs_fi_credits_pkg.insert_row()
70: || Modified IF condition in validation of p_invoice_id.
71: || vvutukur 14-Sep-2003 Enh#3045007.Payment Plans Build. Changes as specified in TD.
72: || pathipat 13-Aug-2003 Enh 3076768 - Automatic Release of Holds
73: || Added call to finp_auto_release_holds()
71: || vvutukur 14-Sep-2003 Enh#3045007.Payment Plans Build. Changes as specified in TD.
72: || pathipat 13-Aug-2003 Enh 3076768 - Automatic Release of Holds
73: || Added call to finp_auto_release_holds()
74: || vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Added 3 new paramters lockbox_interface_id,batch_name,deposit_date
75: || in the TBH call igs_fi_credits_pkg.insert_row.
76: || shtatiko 30-APR-2003 Enh# 2831569, Added check for Manage Accounts
77: || System Option. If its value is NULL then this will
78: || error out. If its value is OTHER then it tries
79: || to create a credit but doesn't update Standard
129: l_n_version_number igs_fi_balance_rules.version_number%TYPE;
130: l_n_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
131: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
132: l_v_currency_cd igs_fi_control_all.currency_cd%TYPE := NULL;
133: l_n_amount igs_fi_credits_all.amount%TYPE;
134:
135: l_n_dr_gl_ccid igs_fi_cr_activities.dr_gl_ccid%TYPE;
136: l_n_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
137: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
143: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
144: l_v_acct_mthd igs_fi_control_all.accounting_method%TYPE;
145: l_var VARCHAR2(1);
146:
147: l_n_credit_id igs_fi_credits.credit_id%TYPE := NULL;
148: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
149: l_v_rowid VARCHAR2(25) := NULL;
150:
151: l_adm_app_number igs_ad_appl_all.admission_appl_number%TYPE;
150:
151: l_adm_app_number igs_ad_appl_all.admission_appl_number%TYPE;
152: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
153:
154: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
155: l_v_cc_number igs_fi_credits_all.credit_card_number%TYPE;
156:
157: BEGIN
158:
151: l_adm_app_number igs_ad_appl_all.admission_appl_number%TYPE;
152: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
153:
154: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
155: l_v_cc_number igs_fi_credits_all.credit_card_number%TYPE;
156:
157: BEGIN
158:
159: --Create a savepoint.
385:
386:
387: --Call the table handler for the credits table for creating a record in the credits table.
388: --passed l_v_credit_number for x_credit_number (svuppala - Enh# 4213629)
389: igs_fi_credits_pkg.insert_row( x_rowid => l_v_rowid,
390: x_credit_id => l_n_credit_id,
391: x_credit_number => l_v_credit_number,
392: x_status => p_credit_rec.p_credit_status,
393: x_credit_source => p_credit_rec.p_credit_source,