[Home] [Help]
147: IS
148: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
149: l_api_version CONSTANT NUMBER := 1.0;
150:
151: l_currency_code ar_cash_receipts.currency_code%TYPE;
152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
148: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
149: l_api_version CONSTANT NUMBER := 1.0;
150:
151: l_currency_code ar_cash_receipts.currency_code%TYPE;
152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
149: l_api_version CONSTANT NUMBER := 1.0;
150:
151: l_currency_code ar_cash_receipts.currency_code%TYPE;
152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
150:
151: l_currency_code ar_cash_receipts.currency_code%TYPE;
152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
151: l_currency_code ar_cash_receipts.currency_code%TYPE;
152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
153: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
161: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
154: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
155: l_amount ar_cash_receipts.amount%TYPE;
156: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
161: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
162: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
157: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
161: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
162: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
163: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
164: /* 6612301 */
165: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
161: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
162: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
163: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
164: /* 6612301 */
165: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
166: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
167: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
163: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
164: /* 6612301 */
165: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
166: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
167: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
168: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
164: /* 6612301 */
165: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
166: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
167: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
168: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
168: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
168: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
169: l_location hz_cust_site_uses.location%TYPE;
170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
178: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
179: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
178: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
179: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
180: l_state VARCHAR2(30);
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
178: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
179: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
180: l_state VARCHAR2(30);
181: l_cr_id NUMBER;
182: l_ps_id NUMBER;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
178: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
179: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
180: l_state VARCHAR2(30);
181: l_cr_id NUMBER;
182: l_ps_id NUMBER;
183: l_row_id VARCHAR2(30);
202: /* bichatte payment uptake */
203: l_copy_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
204: l_copy_msg_count NUMBER;
205: l_copy_msg_data VARCHAR2(2000);
206: l_copy_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
207: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
208: l_create_msg_count NUMBER;
209: l_create_msg_data VARCHAR2(2000);
210: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
206: l_copy_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
207: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
208: l_create_msg_count NUMBER;
209: l_create_msg_data VARCHAR2(2000);
210: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
211: l_default_site_use VARCHAR2(1); --bug4448307-4509459
212: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
213:
214: BEGIN
455: ELSE
456: --validate and default the flexfields
457: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
458: l_attribute_rec,
459: 'AR_CASH_RECEIPTS',
460: l_dflex_val_return_status
461: );
462:
463: --validation and defaulting of the global descriptive flexfield
460: l_dflex_val_return_status
461: );
462:
463: --validation and defaulting of the global descriptive flexfield
464: JG_AR_CASH_RECEIPTS.Validate_gbl(
465: l_global_attribute_rec.global_attribute_category,
466: l_global_attribute_rec.global_attribute1,
467: l_global_attribute_rec.global_attribute2,
468: l_global_attribute_rec.global_attribute3,
1018: IS
1019: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
1020: l_api_version CONSTANT NUMBER := 1.0;
1021:
1022: l_currency_code ar_cash_receipts.currency_code%TYPE;
1023: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1019: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
1020: l_api_version CONSTANT NUMBER := 1.0;
1021:
1022: l_currency_code ar_cash_receipts.currency_code%TYPE;
1023: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1020: l_api_version CONSTANT NUMBER := 1.0;
1021:
1022: l_currency_code ar_cash_receipts.currency_code%TYPE;
1023: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1021:
1022: l_currency_code ar_cash_receipts.currency_code%TYPE;
1023: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1022: l_currency_code ar_cash_receipts.currency_code%TYPE;
1023: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1023: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1024: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1025: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1026: l_amount ar_cash_receipts.amount%TYPE;
1027: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1028: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1044: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1045: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1044: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1045: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1046: l_state VARCHAR2(30);
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1044: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1045: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1046: l_state VARCHAR2(30);
1047: l_cr_id NUMBER;
1048: l_ps_id NUMBER;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1044: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1045: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1046: l_state VARCHAR2(30);
1047: l_cr_id NUMBER;
1048: l_ps_id NUMBER;
1049: l_row_id VARCHAR2(30);
1134: x_return_status OUT NOCOPY VARCHAR2,
1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: -- Receipt application parameters.
1138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1139: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: -- Receipt application parameters.
1138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1139: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1140: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1141: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1142: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1143: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1906: x_return_status OUT NOCOPY VARCHAR2,
1907: x_msg_count OUT NOCOPY NUMBER,
1908: x_msg_data OUT NOCOPY VARCHAR2,
1909: -- Receipt application parameters.
1910: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1911: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1912: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1913: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1914: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1907: x_msg_count OUT NOCOPY NUMBER,
1908: x_msg_data OUT NOCOPY VARCHAR2,
1909: -- Receipt application parameters.
1910: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1911: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1912: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1913: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1914: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1915: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2922: x_return_status OUT NOCOPY VARCHAR2,
2923: x_msg_count OUT NOCOPY NUMBER,
2924: x_msg_data OUT NOCOPY VARCHAR2,
2925: -- *** Receipt Info. parameters *****
2926: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2923: x_msg_count OUT NOCOPY NUMBER,
2924: x_msg_data OUT NOCOPY VARCHAR2,
2925: -- *** Receipt Info. parameters *****
2926: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2928: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2929: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2930: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2931: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
3431: ba.bank_account_num,
3432: ba.bank_account_name,
3433: ba.inactive_date,
3434: cr.unique_reference --bug 3672953
3435: FROM ar_cash_receipts cr,
3436: ar_receipt_methods rm,
3437: ar_receipt_classes rc,
3438: ap_bank_accounts ba
3439: WHERE cr.cash_receipt_id = p_cash_receipt_id
3443:
3444:
3445: rct_info rct_info_cur%ROWTYPE;
3446:
3447: l_cr_rec ar_cash_receipts%ROWTYPE;
3448:
3449:
3450: l_payee_rec IBY_Payment_Adapter_pub.Payee_Rec_type;
3451: l_customer_rec IBY_Payment_Adapter_pub.Payer_Rec_type;
3828: cr.customer_site_use_id,
3829: cr.payment_trxn_extension_id,
3830: cr.receipt_date,
3831: pr.home_country
3832: FROM ar_cash_receipts_all cr,
3833: ar_receipt_methods rm,
3834: ar_receipt_classes rc,
3835: hz_cust_accounts hca,
3836: hz_parties party,
3849: AND bank.party_id = cba.bank_id
3850: AND pr.party_id = bank.party_id;
3851:
3852: rct_info rct_info_cur%ROWTYPE;
3853: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3854: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3855: l_action VARCHAR2(80);
3856: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3857: l_msg_count NUMBER;
4357: l_msg_data VARCHAR2(2000);
4358: l_cpy_msg_data VARCHAR2(2000);
4359: l_assignment_id NUMBER;
4360: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
4361: l_payment_trxn_extension_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4362: p_trxn_entity_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4363: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4364: l_party_id NUMBER;
4365: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4358: l_cpy_msg_data VARCHAR2(2000);
4359: l_assignment_id NUMBER;
4360: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
4361: l_payment_trxn_extension_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4362: p_trxn_entity_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4363: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4364: l_party_id NUMBER;
4365: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4366: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4362: p_trxn_entity_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4363: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4364: l_party_id NUMBER;
4365: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4366: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4367: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4368: l_org_id ar_cash_receipts.org_id%TYPE;
4369: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4370: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4363: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4364: l_party_id NUMBER;
4365: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4366: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4367: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4368: l_org_id ar_cash_receipts.org_id%TYPE;
4369: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4370: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4371:
4364: l_party_id NUMBER;
4365: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4366: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4367: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4368: l_org_id ar_cash_receipts.org_id%TYPE;
4369: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4370: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4371:
4372: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
4365: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4366: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4367: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4368: l_org_id ar_cash_receipts.org_id%TYPE;
4369: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4370: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4371:
4372: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
4373: l_rcpt_creation_rec AR_AUTOREC_API.rcpt_creation_info;
4366: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4367: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4368: l_org_id ar_cash_receipts.org_id%TYPE;
4369: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4370: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4371:
4372: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
4373: l_rcpt_creation_rec AR_AUTOREC_API.rcpt_creation_info;
4374:
4767: x_msg_count OUT NOCOPY NUMBER,
4768: x_msg_data OUT NOCOPY VARCHAR2,
4769: -- Receipt info. parameters
4770: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4771: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4772: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4773: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4769: -- Receipt info. parameters
4770: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4771: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4772: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4773: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4770: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4771: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4772: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4773: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4771: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4772: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4773: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4772: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4773: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4780: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4773: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4780: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4781: p_maturity_date IN DATE DEFAULT NULL,
4774: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4780: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4781: p_maturity_date IN DATE DEFAULT NULL,
4782: p_postmark_date IN DATE DEFAULT NULL,
4775: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4776: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4777: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4778: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4780: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4781: p_maturity_date IN DATE DEFAULT NULL,
4782: p_postmark_date IN DATE DEFAULT NULL,
4783: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4779: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4780: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4781: p_maturity_date IN DATE DEFAULT NULL,
4782: p_postmark_date IN DATE DEFAULT NULL,
4783: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4784: /* tca uptake */
4785: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4786: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4787: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4783: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4784: /* tca uptake */
4785: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4786: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4787: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4788: /* 6612301 */
4789: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
4790: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
4791: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4791: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4792: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4793: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4794: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4792: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4793: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4794: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4793: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4794: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4803: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4804: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4803: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4804: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4805: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4803: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4804: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4805: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4806: p_called_from IN VARCHAR2 DEFAULT NULL,
4807: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4808: -- ******* Global Flexfield parameters *******
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4803: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4804: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4805: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4806: p_called_from IN VARCHAR2 DEFAULT NULL,
4807: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4808: -- ******* Global Flexfield parameters *******
4809: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4808: -- ******* Global Flexfield parameters *******
4809: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4810: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4811: -- *** Notes Receivable Additional Information ***
4812: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4813: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4814: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4815: -- ** OUT NOCOPY variables for Creating receipt
4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4809: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4810: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4811: -- *** Notes Receivable Additional Information ***
4812: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4813: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4814: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4815: -- ** OUT NOCOPY variables for Creating receipt
4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4817: -- Receipt application parameters
4810: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4811: -- *** Notes Receivable Additional Information ***
4812: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4813: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4814: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4815: -- ** OUT NOCOPY variables for Creating receipt
4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4817: -- Receipt application parameters
4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4812: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4813: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4814: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4815: -- ** OUT NOCOPY variables for Creating receipt
4816: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4817: -- Receipt application parameters
4818: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4819: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4820: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4842: l_cash_receipt_id NUMBER(15);
4843: l_create_return_status VARCHAR2(1);
4844: l_create_msg_count NUMBER;
4845: l_create_msg_data VARCHAR2(2000);
4846: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
4847:
4848: -- OSTEINME 3/2/2001: added return variable for credit card call
4849: l_cc_return_status VARCHAR2(1); -- credit card return status
4850: l_response_error_code VARCHAR2(80);
5089: x_msg_count OUT NOCOPY NUMBER,
5090: x_msg_data OUT NOCOPY VARCHAR2,
5091: -- Receipt info. parameters
5092: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
5093: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
5094: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
5095: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
5096: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5091: -- Receipt info. parameters
5092: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
5093: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
5094: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
5095: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
5096: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5092: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
5093: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
5094: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
5095: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
5096: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5093: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
5094: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
5095: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
5096: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5101: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5094: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
5095: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
5096: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5101: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5102: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
5095: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
5096: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5101: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5102: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
5103: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
5097: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5101: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5102: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
5103: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
5104: p_maturity_date IN DATE DEFAULT NULL,
5105: p_postmark_date IN DATE DEFAULT NULL,
5098: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
5099: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
5100: DEFAULT NULL,
5101: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5102: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
5103: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
5104: p_maturity_date IN DATE DEFAULT NULL,
5105: p_postmark_date IN DATE DEFAULT NULL,
5106: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5102: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
5103: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
5104: p_maturity_date IN DATE DEFAULT NULL,
5105: p_postmark_date IN DATE DEFAULT NULL,
5106: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5107: /* tca uptake */
5108: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
5109: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
5110: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
5106: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5107: /* tca uptake */
5108: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
5109: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
5110: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
5111: DEFAULT NULL,
5112: /* 6612301 */
5113: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
5114: DEFAULT NULL,
5117: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
5118: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
5119: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
5120: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
5121: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
5122: DEFAULT NULL,
5123: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
5124: DEFAULT NULL,
5125: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
5119: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
5120: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
5121: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
5122: DEFAULT NULL,
5123: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
5124: DEFAULT NULL,
5125: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
5126: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
5127: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
5124: DEFAULT NULL,
5125: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
5126: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
5127: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
5128: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
5129: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
5130: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
5131: p_doc_sequence_value IN NUMBER DEFAULT NULL,
5132: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
5125: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
5126: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
5127: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
5128: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
5129: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
5130: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
5131: p_doc_sequence_value IN NUMBER DEFAULT NULL,
5132: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
5133: DEFAULT NULL,
5128: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
5129: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
5130: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
5131: p_doc_sequence_value IN NUMBER DEFAULT NULL,
5132: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
5133: DEFAULT NULL,
5134: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
5135: DEFAULT NULL,
5136: p_called_from IN VARCHAR2 DEFAULT NULL,
5130: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
5131: p_doc_sequence_value IN NUMBER DEFAULT NULL,
5132: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
5133: DEFAULT NULL,
5134: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
5135: DEFAULT NULL,
5136: p_called_from IN VARCHAR2 DEFAULT NULL,
5137: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5138: -- ******* Global Flexfield parameters *******
5139: p_global_attribute_rec IN global_attribute_rec_type
5140: DEFAULT global_attribute_rec_const,
5141: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
5142: -- *** Notes Receivable Additional Information ***
5143: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
5144: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
5145: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
5146: -- ** OUT NOCOPY variables for Creating receipt
5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5140: DEFAULT global_attribute_rec_const,
5141: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
5142: -- *** Notes Receivable Additional Information ***
5143: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
5144: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
5145: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
5146: -- ** OUT NOCOPY variables for Creating receipt
5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5148: -- Receipt application parameters
5141: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
5142: -- *** Notes Receivable Additional Information ***
5143: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
5144: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
5145: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
5146: -- ** OUT NOCOPY variables for Creating receipt
5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5148: -- Receipt application parameters
5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5143: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
5144: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
5145: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
5146: -- ** OUT NOCOPY variables for Creating receipt
5147: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
5148: -- Receipt application parameters
5149: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5150: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5151: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5170: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5171: p_org_id IN NUMBER DEFAULT NULL
5172: ) IS
5173:
5174: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
5175:
5176: l_create_return_status VARCHAR2(1);
5177: l_create_msg_count NUMBER;
5178: l_create_msg_data VARCHAR2(2000);
5186: l_api_name CONSTANT VARCHAR2(20) := 'Create_Apply_On_Acc';
5187: l_api_version CONSTANT NUMBER := 1.0;
5188: l_creation_method_code VARCHAR2(50);
5189: l_response_error_code VARCHAR2(80);
5190: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
5191:
5192: BEGIN
5193:
5194: IF PG_DEBUG in ('Y', 'C') THEN
5473:
5474: ) IS
5475: l_rev_crh_id NUMBER;
5476: l_crh_rec ar_cash_receipt_history%ROWTYPE;
5477: l_cr_rec ar_cash_receipts%ROWTYPE;
5478: l_ps_rec ar_payment_schedules%ROWTYPE;
5479: BEGIN
5480: p_return_status := FND_API.G_RET_STS_SUCCESS;
5481: /*-------------------------------------------------+
5587: x_return_status OUT NOCOPY VARCHAR2,
5588: x_msg_count OUT NOCOPY NUMBER,
5589: x_msg_data OUT NOCOPY VARCHAR2,
5590: -- Receipt reversal related parameters
5591: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5592: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5593: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5594: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5588: x_msg_count OUT NOCOPY NUMBER,
5589: x_msg_data OUT NOCOPY VARCHAR2,
5590: -- Receipt reversal related parameters
5591: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5592: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5593: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5594: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5596: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5589: x_msg_data OUT NOCOPY VARCHAR2,
5590: -- Receipt reversal related parameters
5591: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5592: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5593: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5594: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5596: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5597: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5592: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5593: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5594: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5596: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5597: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5598: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5599: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
5600: p_called_from IN VARCHAR2 DEFAULT NULL,
5593: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5594: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5596: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5597: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5598: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5599: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
5600: p_called_from IN VARCHAR2 DEFAULT NULL,
5601: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5595: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5596: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5597: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5598: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5599: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
5600: p_called_from IN VARCHAR2 DEFAULT NULL,
5601: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5602: --p_global_attribute_rec IN global_attribute_rec_type_upd DEFAULT global_attribute_rec_upd_cons
5603: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5791: Settlement is not run for remitted receipts*/
5792: BEGIN
5793:
5794: select cr.payment_trxn_extension_id into l_trxn_extn_id
5795: from ar_Cash_receipts cr, ar_cash_receipt_history crh
5796: where cr.cash_receipt_id=crh.cash_receipt_id
5797: and crh.current_record_flag= 'Y'
5798: and crh.status = 'REMITTED'
5799: and cr.cash_receipt_id = p_cash_receipt_id;
5833:
5834: BEGIN
5835: Select receipt_method_id
5836: INTO l_receipt_method_id
5837: FROM ar_cash_receipts
5838: WHERE cash_receipt_id = l_cash_receipt_id ;
5839:
5840: EXCEPTION WHEN NO_DATA_FOUND THEN
5841: arp_util.debug( 'No Data Found exception while getting Receipt Method Id : '||sqlerrm);
5850: ELSE
5851: --validate and default the flexfields
5852: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
5853: l_attribute_rec,
5854: 'AR_CASH_RECEIPTS',
5855: l_dflex_val_return_status
5856: );
5857: IF PG_DEBUG in ('Y', 'C') THEN
5858: arp_util.debug('Apply: ' || 'l_dflex_val_return_status :'||l_dflex_val_return_status);
5870: );
5871: IF l_attribute_rec.attribute_category IS NOT NULL THEN
5872: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
5873: l_attribute_rec,
5874: 'AR_CASH_RECEIPTS',
5875: l_dflex_val1_return_status
5876: );
5877: END IF;
5878: END IF;
5880: arp_util.debug( 'l_dflex_def_return_status :'||l_dflex_def_return_status);
5881: arp_util.debug( 'l_dflex_val1_return_status :'||l_dflex_val1_return_status);
5882: END IF;
5883:
5884: jg_ar_cash_receipts.reverse(
5885: l_cash_receipt_id,
5886: l_glob_return_status);
5887:
5888: IF PG_DEBUG in ('Y', 'C') THEN
6229: x_return_status OUT NOCOPY VARCHAR2,
6230: x_msg_count OUT NOCOPY NUMBER,
6231: x_msg_data OUT NOCOPY VARCHAR2,
6232: -- Receipt application parameters.
6233: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6234: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
6230: x_msg_count OUT NOCOPY NUMBER,
6231: x_msg_data OUT NOCOPY VARCHAR2,
6232: -- Receipt application parameters.
6233: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6234: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6235: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
6236: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
6237: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
6238: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6655: x_return_status OUT NOCOPY VARCHAR2 ,
6656: x_msg_count OUT NOCOPY NUMBER ,
6657: x_msg_data OUT NOCOPY VARCHAR2 ,
6658: -- *** Receipt Info. parameters *****
6659: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6660: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6661: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6662: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6663: p_org_id IN NUMBER DEFAULT NULL
6656: x_msg_count OUT NOCOPY NUMBER ,
6657: x_msg_data OUT NOCOPY VARCHAR2 ,
6658: -- *** Receipt Info. parameters *****
6659: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6660: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6661: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6662: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6663: p_org_id IN NUMBER DEFAULT NULL
6664: ) IS
6963: x_return_status OUT NOCOPY VARCHAR2 ,
6964: x_msg_count OUT NOCOPY NUMBER ,
6965: x_msg_data OUT NOCOPY VARCHAR2 ,
6966: -- *** Receipt Info. parameters *****
6967: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6968: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6969: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6970: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6971: p_cancel_claim_flag IN VARCHAR2,
6964: x_msg_count OUT NOCOPY NUMBER ,
6965: x_msg_data OUT NOCOPY VARCHAR2 ,
6966: -- *** Receipt Info. parameters *****
6967: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6968: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6969: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6970: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6971: p_cancel_claim_flag IN VARCHAR2,
6972: p_called_from IN VARCHAR2,
6975: l_api_name CONSTANT VARCHAR2(20) := 'Unapply_on_account';
6976: l_api_version CONSTANT NUMBER := 1.0;
6977: l_customer_trx_id NUMBER;
6978: l_cash_receipt_id NUMBER;
6979: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
6980: l_receivable_application_id NUMBER;
6981: l_applied_ps_id NUMBER;
6982: l_sec_app_ref_id NUMBER;
6983: l_amount_applied NUMBER;
7347: x_return_status OUT NOCOPY VARCHAR2,
7348: x_msg_count OUT NOCOPY NUMBER,
7349: x_msg_data OUT NOCOPY VARCHAR2,
7350: -- Receipt application parameters.
7351: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7352: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7348: x_msg_count OUT NOCOPY NUMBER,
7349: x_msg_data OUT NOCOPY VARCHAR2,
7350: -- Receipt application parameters.
7351: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7352: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7353: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7354: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7355: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7356: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7374: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7375: p_val_writeoff_limits_flag IN VARCHAR2,
7376: p_called_from IN VARCHAR2,
7377: p_netted_receipt_flag IN VARCHAR2,
7378: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7379: p_secondary_app_ref_type IN
7380: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
7381: p_secondary_app_ref_num IN
7382: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7393: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
7394: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
7395: ,p_party_id IN hz_parties.party_id%TYPE
7396: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
7397: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
7398: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE --Bug8290172
7399: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE --Bug8290172
7400: ) IS
7401:
7439: l_payment_reason_name iby_payment_reasons_vl.meaning%TYPE;
7440: l_delivery_channel_code iby_delivery_channels_vl.delivery_channel_code%TYPE;
7441: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;
7442: l_pay_alone_flag VARCHAR2(1);
7443: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7444: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7445: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7446: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7447: l_invoice_id ap_invoices.invoice_id%TYPE;
7440: l_delivery_channel_code iby_delivery_channels_vl.delivery_channel_code%TYPE;
7441: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;
7442: l_pay_alone_flag VARCHAR2(1);
7443: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7444: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7445: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7446: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7447: l_invoice_id ap_invoices.invoice_id%TYPE;
7448: l_dft_ref_return_status VARCHAR2(1);
7441: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;
7442: l_pay_alone_flag VARCHAR2(1);
7443: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7444: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7445: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7446: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7447: l_invoice_id ap_invoices.invoice_id%TYPE;
7448: l_dft_ref_return_status VARCHAR2(1);
7449: l_called_from varchar2(20); /*5444407*/
7442: l_pay_alone_flag VARCHAR2(1);
7443: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7444: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7445: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7446: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7447: l_invoice_id ap_invoices.invoice_id%TYPE;
7448: l_dft_ref_return_status VARCHAR2(1);
7449: l_called_from varchar2(20); /*5444407*/
7450:
8027: x_return_status OUT NOCOPY VARCHAR2 ,
8028: x_msg_count OUT NOCOPY NUMBER ,
8029: x_msg_data OUT NOCOPY VARCHAR2 ,
8030: -- *** Receipt Info. parameters *****
8031: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8032: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8033: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
8034: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
8035: p_called_from IN VARCHAR2,
8028: x_msg_count OUT NOCOPY NUMBER ,
8029: x_msg_data OUT NOCOPY VARCHAR2 ,
8030: -- *** Receipt Info. parameters *****
8031: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8032: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8033: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
8034: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
8035: p_called_from IN VARCHAR2,
8036: p_org_id IN NUMBER DEFAULT NULL
8367: x_msg_count OUT NOCOPY NUMBER,
8368: x_msg_data OUT NOCOPY VARCHAR2,
8369: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8370: -- Receipt application parameters.
8371: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8368: x_msg_data OUT NOCOPY VARCHAR2,
8369: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8370: -- Receipt application parameters.
8371: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8372: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8373: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8374: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8375: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8376: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8896: p_comments IN VARCHAR2 DEFAULT NULL,
8897: p_org_id IN NUMBER DEFAULT NULL,
8898: p_misc_receipt_id OUT NOCOPY NUMBER,
8899: p_called_from IN VARCHAR2 DEFAULT NULL,
8900: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL ) /* Bug fix 3619780*/
8901: IS
8902: l_currency_code ar_cash_receipts.currency_code%TYPE;
8903: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8904: l_exchange_rate NUMBER;
8898: p_misc_receipt_id OUT NOCOPY NUMBER,
8899: p_called_from IN VARCHAR2 DEFAULT NULL,
8900: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL ) /* Bug fix 3619780*/
8901: IS
8902: l_currency_code ar_cash_receipts.currency_code%TYPE;
8903: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8904: l_exchange_rate NUMBER;
8905: l_exchange_date DATE;
8906: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
8899: p_called_from IN VARCHAR2 DEFAULT NULL,
8900: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL ) /* Bug fix 3619780*/
8901: IS
8902: l_currency_code ar_cash_receipts.currency_code%TYPE;
8903: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8904: l_exchange_rate NUMBER;
8905: l_exchange_date DATE;
8906: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
8907: l_amount NUMBER;
8902: l_currency_code ar_cash_receipts.currency_code%TYPE;
8903: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8904: l_exchange_rate NUMBER;
8905: l_exchange_date DATE;
8906: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
8907: l_amount NUMBER;
8908: l_receipt_date DATE;
8909: l_gl_date DATE;
8910: l_receivables_trx_id NUMBER(15);
8940: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
8941: l_org_return_status VARCHAR2(1);
8942: l_org_id NUMBER;
8943: l_legal_entity_id NUMBER; /* R12 LE uptake */
8944: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
8945: /* bichatte payment uptake */
8946: l_copy_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8947: l_copy_msg_count NUMBER;
8948: l_copy_msg_data VARCHAR2(2000);
8945: /* bichatte payment uptake */
8946: l_copy_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8947: l_copy_msg_count NUMBER;
8948: l_copy_msg_data VARCHAR2(2000);
8949: l_copy_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
8950: l_default_site_use VARCHAR2(1);
8951: l_customer_id NUMBER(15);
8952: l_customer_site_use_id NUMBER(15);
8953: BEGIN
9136: IF NVL(p_called_from ,'X') NOT IN
9137: ('CC_REFUND','CM_REFUND','CC_CHARGEBACK') THEN
9138: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
9139: l_attribute_rec,
9140: 'AR_CASH_RECEIPTS',
9141: l_dflex_val_return_status
9142: );
9143: END IF;
9144: END IF;
9281: arp_standard.debug('calling copy Extension....');
9282: /* 5955921 */
9283: select pay_from_customer,customer_site_use_id
9284: into l_customer_id,l_customer_site_use_id
9285: from ar_cash_receipts
9286: --where payment_trxn_extension_id = l_payment_trxn_extension_id;
9287: --Bug : 6855895
9288: where cash_receipt_id = l_reference_id;
9289:
9665: x_return_status OUT NOCOPY VARCHAR2,
9666: x_msg_count OUT NOCOPY NUMBER,
9667: x_msg_data OUT NOCOPY VARCHAR2,
9668: -- Receipt application parameters.
9669: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9670: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9666: x_msg_count OUT NOCOPY NUMBER,
9667: x_msg_data OUT NOCOPY VARCHAR2,
9668: -- Receipt application parameters.
9669: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9670: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9668: -- Receipt application parameters.
9669: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9670: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9669: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9670: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9671: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9672: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9673: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9674: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9675: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9676: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9677: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9690: ) IS
9691: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9692: l_api_version CONSTANT NUMBER := 1.0;
9693: l_cash_receipt_id NUMBER;
9694: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9695: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9696: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9697: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9698: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9691: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9692: l_api_version CONSTANT NUMBER := 1.0;
9693: l_cash_receipt_id NUMBER;
9694: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9695: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9696: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9697: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9698: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9699: l_cr_gl_date DATE;
9692: l_api_version CONSTANT NUMBER := 1.0;
9693: l_cash_receipt_id NUMBER;
9694: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9695: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9696: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9697: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9698: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9699: l_cr_gl_date DATE;
9700: l_open_cr_gl_date DATE;
10934: arp_util.debug('After gl date validation');
10935: END IF;
10936:
10937: FORALL i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
10938: UPDATE ar_cash_receipts SET
10939: CC_ERROR_FLAG ='Y',
10940: CC_ERROR_CODE = l_crh_upd.cc_error_code(i),
10941: CC_ERROR_TEXT = l_crh_upd.cc_error_text(i),
10942: LAST_UPDATE_DATE = sysdate,
11326: IF PG_DEBUG in ('Y', 'C') THEN
11327: arp_standard.debug('process_events()+');
11328: END IF;
11329:
11330: update ar_cash_receipts
11331: SET last_update_date = sysdate,
11332: request_id = p_request_id
11333: WHERE cash_receipt_id in
11334: ( select cash_receipt_id
11914: x_return_status OUT NOCOPY VARCHAR2,
11915: x_msg_count OUT NOCOPY NUMBER,
11916: x_msg_data OUT NOCOPY VARCHAR2,
11917: -- Receipt application parameters.
11918: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
11919: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
11920: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
11921: p_location IN ar_cash_receipts.customer_site_use_id%TYPE
11922: ) IS
11916: x_msg_data OUT NOCOPY VARCHAR2,
11917: -- Receipt application parameters.
11918: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
11919: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
11920: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
11921: p_location IN ar_cash_receipts.customer_site_use_id%TYPE
11922: ) IS
11923: l_api_name CONSTANT VARCHAR2(20) := 'Change_customer';
11924: l_api_version CONSTANT NUMBER := 1.0;
11917: -- Receipt application parameters.
11918: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
11919: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
11920: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
11921: p_location IN ar_cash_receipts.customer_site_use_id%TYPE
11922: ) IS
11923: l_api_name CONSTANT VARCHAR2(20) := 'Change_customer';
11924: l_api_version CONSTANT NUMBER := 1.0;
11925: l_cash_receipt_id NUMBER;
12007: SELECT pay_from_customer
12008: , receipt_date
12009: INTO l_rec_customer_id
12010: , l_rec_date
12011: FROM ar_cash_receipts
12012: WHERE cash_receipt_id = l_cash_receipt_id;
12013:
12014:
12015: /*----------------------------------------------+