[Home] [Help]
67: IF ar_receipt_lib_pvt.pg_profile_def_x_rate_type = FND_API.G_MISS_CHAR THEN
68: ar_receipt_lib_pvt.pg_profile_def_x_rate_type
69: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
70: END IF;
71: arp_util.debug('*******Profile Option Values************');
72: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
68: ar_receipt_lib_pvt.pg_profile_def_x_rate_type
69: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
70: END IF;
71: arp_util.debug('*******Profile Option Values************');
72: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
69: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
70: END IF;
71: arp_util.debug('*******Profile Option Values************');
72: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
70: END IF;
71: arp_util.debug('*******Profile Option Values************');
72: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
78: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
71: arp_util.debug('*******Profile Option Values************');
72: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
78: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
79: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
72: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
78: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
79: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
80:
73: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
78: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
79: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
80:
81: END initialize_profile_globals;
74: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
78: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
79: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
80:
81: END initialize_profile_globals;
82:
75: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
76: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
77: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
78: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
79: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
80:
81: END initialize_profile_globals;
82:
83:
300: Original_create_cash_info.receipt_method_name
301: := p_receipt_method_name;
302:
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug('Create_cash_1: ' || 'Create_cash_receipt()+ ');
305: END IF;
306: /*-----------------------------------------+
307: | Initialize return status to SUCCESS |
308: +-----------------------------------------*/
376: );
377: END IF;
378: END IF;
379: IF PG_DEBUG in ('Y', 'C') THEN
380: arp_util.debug('Create_cash_1: ' || 'Default_cash_ids return status :'||l_derive_cust_return_status);
381: END IF;
382: ar_receipt_lib_pvt.Get_cash_defaults(
383: l_currency_code,
384: l_exchange_rate_type,
400: l_creation_method_code,
401: l_cash_def_return_status
402: );
403: IF PG_DEBUG in ('Y', 'C') THEN
404: arp_util.debug('Create_cash_1: ' || 'Get_Cash_defaults return status :'||l_cash_def_return_status);
405: END IF;
406:
407: /*------------------------------------------+
408: | Get legal_entity_id |
543: FND_MSG_PUB.Add;
544: END IF;
545: ELSE
546: IF PG_DEBUG in ('Y', 'C') THEN
547: arp_util.debug('Create_cash_1: ' || 'Receipt Number is null ');
548: END IF;
549: --raise error message
550: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
551: FND_MSG_PUB.Add;
567: -- HERE we have to call the payment engine in order to get the payment_trx_extension_id
568: -- the conditions are if creation_method = 'A' and p_payment_trx_extension_id is null.
569: -- bichatte payment_uptake project.
570:
571: arp_util.debug ('Create_cash -- CHECK' || p_installment );
572:
573: -- We have to check the receipt_creation_rule_code and
574: -- accordingly call create or COPY
575:
585:
586:
587: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
588:
589: arp_util.debug('Create_cash_122: ' || l_creation_method_code);
590: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
591: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
592: FND_MSG_PUB.Add;
593: x_return_status := FND_API.G_RET_STS_ERROR;
586:
587: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
588:
589: arp_util.debug('Create_cash_122: ' || l_creation_method_code);
590: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
591: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
592: FND_MSG_PUB.Add;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: END IF;
619: p_receipt_date => l_receipt_date
620: );
621:
622: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: arp_util.debug('Create_cash_123: ' );
624: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
632: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));
633: END IF;
634:
635: ELSE
636: arp_util.debug ('Create_cash -- CHECK2' || p_installment );
637: IF l_creation_method = 'A' THEN
638: arp_standard.debug('calling CREATE Extension....');
639: Create_payment_extension (
640: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
651: p_receipt_date => l_receipt_date
652: );
653:
654: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
655: arp_util.debug('Create_cash_123: ' );
656: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
657: FND_MSG_PUB.Add;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: END IF;
674: END IF; /* Return Status */
675:
676: --Dump all the variables before calling the entity handler
677: IF PG_DEBUG in ('Y', 'C') THEN
678: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
679: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
675:
676: --Dump all the variables before calling the entity handler
677: IF PG_DEBUG in ('Y', 'C') THEN
678: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
679: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
676: --Dump all the variables before calling the entity handler
677: IF PG_DEBUG in ('Y', 'C') THEN
678: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
679: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
677: IF PG_DEBUG in ('Y', 'C') THEN
678: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
679: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
678: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
679: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
679: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
680: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
682: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
683: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
684: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
685: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
686: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
687: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
688: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
696: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
689: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
696: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
697: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
690: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
696: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
697: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
698: END IF;
691: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
696: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
697: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
698: END IF;
699: /*------------------------------------------------------------+
692: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
696: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
697: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
698: END IF;
699: /*------------------------------------------------------------+
700: | If any errors - including validation failures - occurred, |
693: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
694: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
695: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
696: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
697: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
698: END IF;
699: /*------------------------------------------------------------+
700: | If any errors - including validation failures - occurred, |
701: | rollback any changes and return an error status. |
700: | If any errors - including validation failures - occurred, |
701: | rollback any changes and return an error status. |
702: +------------------------------------------------------------*/
703: IF PG_DEBUG in ('Y', 'C') THEN
704: arp_util.debug('Create_cash_1: ' || 'x_return_status : '||x_return_status);
705: arp_util.debug('Create_cash_1: ' || 'l_doc_seq_status : '||l_doc_seq_status);
706: END IF;
707: IF (
708: x_return_status <> FND_API.G_RET_STS_SUCCESS
701: | rollback any changes and return an error status. |
702: +------------------------------------------------------------*/
703: IF PG_DEBUG in ('Y', 'C') THEN
704: arp_util.debug('Create_cash_1: ' || 'x_return_status : '||x_return_status);
705: arp_util.debug('Create_cash_1: ' || 'l_doc_seq_status : '||l_doc_seq_status);
706: END IF;
707: IF (
708: x_return_status <> FND_API.G_RET_STS_SUCCESS
709: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS
718: p_count => x_msg_count,
719: p_data => x_msg_data);
720:
721: IF PG_DEBUG in ('Y', 'C') THEN
722: arp_util.debug('Create_cash_1: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
723: END IF;
724: Return;
725: END IF;
726: IF PG_DEBUG in ('Y', 'C') THEN
723: END IF;
724: Return;
725: END IF;
726: IF PG_DEBUG in ('Y', 'C') THEN
727: arp_util.debug('Create_cash_1: ' || 'x_return_status '||x_return_status);
728: END IF;
729: /* bichatte removed customer bank variables for the payment uptake project
730: added the l_payment_trxn_extension_id */
731: BEGIN
838: END;
839:
840: p_cr_id := l_cr_id;
841: IF PG_DEBUG in ('Y', 'C') THEN
842: arp_util.debug('Create_cash_1: ' || 'Cash Receipt id : '||to_char(l_cr_id));
843: END IF;
844:
845: /*-------------------------------------------------------+
846: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
860:
861: IF FND_API.To_Boolean( p_commit )
862: THEN
863: IF PG_DEBUG in ('Y', 'C') THEN
864: arp_util.debug('Create_cash_1: ' || 'committing');
865: END IF;
866: Commit;
867: END IF;
868:
866: Commit;
867: END IF;
868:
869: IF PG_DEBUG in ('Y', 'C') THEN
870: arp_util.debug('Create_cash_1: ' || 'Create_Cash_Receipt()- ');
871: END IF;
872:
873:
874: EXCEPTION
874: EXCEPTION
875: WHEN FND_API.G_EXC_ERROR THEN
876:
877: IF PG_DEBUG in ('Y', 'C') THEN
878: arp_util.debug('Create_cash_1: ' || SQLCODE, G_MSG_ERROR);
879: arp_util.debug('Create_cash_1: ' || SQLERRM, G_MSG_ERROR);
880: END IF;
881:
882: ROLLBACK TO Create_Cash_PVT;
875: WHEN FND_API.G_EXC_ERROR THEN
876:
877: IF PG_DEBUG in ('Y', 'C') THEN
878: arp_util.debug('Create_cash_1: ' || SQLCODE, G_MSG_ERROR);
879: arp_util.debug('Create_cash_1: ' || SQLERRM, G_MSG_ERROR);
880: END IF;
881:
882: ROLLBACK TO Create_Cash_PVT;
883: x_return_status := FND_API.G_RET_STS_ERROR ;
891:
892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
893:
894: IF PG_DEBUG in ('Y', 'C') THEN
895: arp_util.debug('Create_cash_1: ' || SQLERRM, G_MSG_ERROR);
896: END IF;
897: ROLLBACK TO Create_Cash_PVT;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
899:
934: FND_MSG_PUB.Add;
935: END IF;
936:
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_util.debug('Create_cash_1: ' || SQLCODE);
939: arp_util.debug('Create_cash_1: ' || SQLERRM);
940: END IF;
941:
942: ROLLBACK TO Create_Cash_PVT;
935: END IF;
936:
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_util.debug('Create_cash_1: ' || SQLCODE);
939: arp_util.debug('Create_cash_1: ' || SQLERRM);
940: END IF;
941:
942: ROLLBACK TO Create_Cash_PVT;
943:
1294: Original_application_info.amount_applied_from := p_amount_applied_from;
1295: Original_application_info.trans_to_receipt_rate := p_trans_to_receipt_rate;
1296:
1297: IF PG_DEBUG in ('Y', 'C') THEN
1298: arp_util.debug('Apply()+ ');
1299: END IF;
1300:
1301: /*-----------------------------------------+
1302: | Initialize return status to SUCCESS |
1379: l_def_ids_return_status);
1380:
1381:
1382: IF PG_DEBUG in ('Y', 'C') THEN
1383: arp_util.debug('Apply: ' || 'Defaulting Ids Return_status = '||l_def_ids_return_status);
1384: END IF;
1385: /*---------------------+
1386: | |
1387: | DEFAULTING |
1387: | DEFAULTING |
1388: | |
1389: +---------------------*/
1390: IF PG_DEBUG in ('Y', 'C') THEN
1391: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1392: END IF;
1393: ar_receipt_lib_pvt.Default_application_info(
1394: l_cash_receipt_id ,
1395: l_cr_gl_date,
1448: l_called_from,
1449: l_def_return_status
1450: );
1451: IF PG_DEBUG in ('Y', 'C') THEN
1452: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1453: arp_util.debug('Apply: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
1454: arp_util.debug('Apply: ' || 'Defaulting Return_status = '||l_def_return_status);
1455: END IF;
1456: /*---------------------+
1449: l_def_return_status
1450: );
1451: IF PG_DEBUG in ('Y', 'C') THEN
1452: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1453: arp_util.debug('Apply: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
1454: arp_util.debug('Apply: ' || 'Defaulting Return_status = '||l_def_return_status);
1455: END IF;
1456: /*---------------------+
1457: | |
1450: );
1451: IF PG_DEBUG in ('Y', 'C') THEN
1452: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1453: arp_util.debug('Apply: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
1454: arp_util.debug('Apply: ' || 'Defaulting Return_status = '||l_def_return_status);
1455: END IF;
1456: /*---------------------+
1457: | |
1458: | VALIDATION |
1510: l_rec_charges_remaining,
1511: l_val_return_status
1512: );
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_util.debug('Apply: ' || 'Validation Return_status = '||l_val_return_status);
1515: END IF;
1516: END IF;
1517:
1518: --Validate application reference details passed.
1534: l_app_validation_return_status
1535: );
1536:
1537: IF PG_DEBUG in ('Y', 'C') THEN
1538: arp_util.debug('Apply: ' || 'Application ref Validation return status :'||l_app_validation_return_status);
1539: END IF;
1540:
1541: /* Bug 9501452 Bypass DFF validation in case call is for AP/AR Netting*/
1542: IF nvl(l_receipt_method_id,-99) <> -1 THEN
1609:
1610: x_return_status := FND_API.G_RET_STS_ERROR ;
1611:
1612: IF PG_DEBUG in ('Y', 'C') THEN
1613: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1614: END IF;
1615: Return;
1616: END IF;
1617:
1616: END IF;
1617:
1618: --Dump the input variables to the entity handler
1619: IF PG_DEBUG in ('Y', 'C') THEN
1620: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1621: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1617:
1618: --Dump the input variables to the entity handler
1619: IF PG_DEBUG in ('Y', 'C') THEN
1620: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1621: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1618: --Dump the input variables to the entity handler
1619: IF PG_DEBUG in ('Y', 'C') THEN
1620: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1621: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1619: IF PG_DEBUG in ('Y', 'C') THEN
1620: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1621: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1620: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1621: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1621: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1622: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1630: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1623: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1630: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1631: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1624: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1630: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1631: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1632: END IF;
1625: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1630: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1631: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1632: END IF;
1633:
1626: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1630: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1631: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1632: END IF;
1633:
1634: --lock the receipt before calling the entity handler
1627: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1628: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1629: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1630: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1631: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1632: END IF;
1633:
1634: --lock the receipt before calling the entity handler
1635: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
1798:
1799: IF FND_API.To_Boolean( p_commit )
1800: THEN
1801: IF PG_DEBUG in ('Y', 'C') THEN
1802: arp_util.debug('Apply: ' || 'committing');
1803: END IF;
1804: Commit;
1805: END IF;
1806: IF PG_DEBUG in ('Y', 'C') THEN
1803: END IF;
1804: Commit;
1805: END IF;
1806: IF PG_DEBUG in ('Y', 'C') THEN
1807: arp_util.debug('Apply ()- ');
1808: END IF;
1809: EXCEPTION
1810: WHEN FND_API.G_EXC_ERROR THEN
1811:
1809: EXCEPTION
1810: WHEN FND_API.G_EXC_ERROR THEN
1811:
1812: IF PG_DEBUG in ('Y', 'C') THEN
1813: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1814: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1815: END IF;
1816:
1817: ROLLBACK TO Apply_PVT;
1810: WHEN FND_API.G_EXC_ERROR THEN
1811:
1812: IF PG_DEBUG in ('Y', 'C') THEN
1813: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1814: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1815: END IF;
1816:
1817: ROLLBACK TO Apply_PVT;
1818: x_return_status := FND_API.G_RET_STS_ERROR ;
1826:
1827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1828:
1829: IF PG_DEBUG in ('Y', 'C') THEN
1830: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1831: END IF;
1832: ROLLBACK TO Apply_PVT;
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834:
1874: FND_MSG_PUB.Add;
1875: END IF;
1876:
1877: IF PG_DEBUG in ('Y', 'C') THEN
1878: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1879: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1880: END IF;
1881:
1882: ROLLBACK TO Apply_PVT;
1875: END IF;
1876:
1877: IF PG_DEBUG in ('Y', 'C') THEN
1878: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1879: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1880: END IF;
1881:
1882: ROLLBACK TO Apply_PVT;
1883:
2090: := p_trans_to_receipt_rate;
2091: Original_application_info.applied_payment_schedule_id
2092: := p_applied_payment_schedule_id;
2093: IF PG_DEBUG in ('Y', 'C') THEN
2094: arp_util.debug('Apply_In_Detail()+ ');
2095: END IF;
2096:
2097: /*-----------------------------------------+
2098: | Initialize return status to SUCCESS |
2126: | ===== Dump the Input Parameters ======== |
2127: +---------------------------------------------*/
2128:
2129: IF PG_DEBUG in ('Y', 'C') THEN
2130: arp_util.debug('=======================================================');
2131: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2127: +---------------------------------------------*/
2128:
2129: IF PG_DEBUG in ('Y', 'C') THEN
2130: arp_util.debug('=======================================================');
2131: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2128:
2129: IF PG_DEBUG in ('Y', 'C') THEN
2130: arp_util.debug('=======================================================');
2131: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2129: IF PG_DEBUG in ('Y', 'C') THEN
2130: arp_util.debug('=======================================================');
2131: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2130: arp_util.debug('=======================================================');
2131: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2131: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2132: arp_util.debug('=======================================================');
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2133: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2134: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2135: arp_util.debug('p_commit =>'||p_commit);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2136: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2137: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2138: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2139: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2140: arp_util.debug('p_trx_number =>'||p_trx_number);
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2141: arp_util.debug('p_installment =>'||p_installment);
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2142: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2143: arp_util.debug('p_llca_type =>'||p_llca_type);
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2144: arp_util.debug('p_group_id =>'||p_group_id);
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2145: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2146: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2147: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2148: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2149: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2150: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2151: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2152: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2153: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2154: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2155: arp_util.debug('p_discount =>'||to_char(p_discount));
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2156: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2157: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2158: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2159: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2160: arp_util.debug('p_called_from =>'||p_called_from);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2161: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2162: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2163: arp_util.debug('p_comments =>'||p_comments);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2164: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2172: arp_util.debug('p_org_id =>'||p_org_id);
2165: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2172: arp_util.debug('p_org_id =>'||p_org_id);
2173: arp_util.debug('=======================================================');
2166: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2172: arp_util.debug('p_org_id =>'||p_org_id);
2173: arp_util.debug('=======================================================');
2174: END IF;
2167: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2172: arp_util.debug('p_org_id =>'||p_org_id);
2173: arp_util.debug('=======================================================');
2174: END IF;
2175:
2168: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2172: arp_util.debug('p_org_id =>'||p_org_id);
2173: arp_util.debug('=======================================================');
2174: END IF;
2175:
2176: /*---------------------------------------------+
2169: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2170: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2171: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2172: arp_util.debug('p_org_id =>'||p_org_id);
2173: arp_util.debug('=======================================================');
2174: END IF;
2175:
2176: /*---------------------------------------------+
2177: | ========== Start of API Body ========== |
2221: p_amount_applied_from => l_amount_applied_from,
2222: p_return_status => l_gt_return_status);
2223:
2224: IF PG_DEBUG in ('Y', 'C') THEN
2225: arp_util.debug('Apply_In_Detail: ' || 'Plsql table Return_status = '||l_gt_return_status);
2226: END IF;
2227:
2228: IF l_gt_return_status <> FND_API.G_RET_STS_SUCCESS
2229: THEN
2230: ROLLBACK TO Apply_In_Detail_PVT;
2231: x_return_status := FND_API.G_RET_STS_ERROR ;
2232:
2233: IF PG_DEBUG in ('Y', 'C') THEN
2234: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2235: END IF;
2236: Return;
2237: END IF;
2238:
2254: p_group_id => l_group_id,
2255: p_return_status => l_def_ids_return_status);
2256:
2257: IF PG_DEBUG in ('Y', 'C') THEN
2258: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Ids Return_status = '||l_def_ids_return_status);
2259: END IF;
2260:
2261: -- Inorder to retained the errors on GT, we need to return the call without rollback.
2262: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS
2268: THEN
2269: x_return_status := FND_API.G_RET_STS_ERROR ;
2270:
2271: IF PG_DEBUG in ('Y', 'C') THEN
2272: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred in PLSQL table parameters. ');
2273: END IF;
2274: Return;
2275: END IF;
2276: END IF ;
2279: | DEFAULTING |
2280: | |
2281: +---------------------*/
2282: IF PG_DEBUG in ('Y', 'C') THEN
2283: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2284: END IF;
2285: ar_receipt_lib_pvt.Default_application_info(
2286: p_cash_receipt_id => l_cash_receipt_id ,
2287: p_cr_gl_date => l_cr_gl_date,
2340: p_called_from => p_called_from,
2341: p_return_status => l_def_return_status
2342: );
2343: IF PG_DEBUG in ('Y', 'C') THEN
2344: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2345: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2346: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2347: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2348: END IF;
2341: p_return_status => l_def_return_status
2342: );
2343: IF PG_DEBUG in ('Y', 'C') THEN
2344: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2345: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2346: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2347: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2348: END IF;
2349:
2342: );
2343: IF PG_DEBUG in ('Y', 'C') THEN
2344: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2345: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2346: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2347: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2348: END IF;
2349:
2350: /*---------------------+
2343: IF PG_DEBUG in ('Y', 'C') THEN
2344: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2345: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2346: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2347: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2348: END IF;
2349:
2350: /*---------------------+
2351: | |
2400: p_return_status => l_val_return_status
2401: );
2402:
2403: IF PG_DEBUG in ('Y', 'C') THEN
2404: arp_util.debug('Apply_In_Detail: ' || 'Validation Return_status = '||l_val_return_status);
2405: END IF;
2406:
2407: /* Bug 9501452 Bypass DFF validation in case call is for AP/AR Netting*/
2408: IF nvl(l_receipt_method_id,-99) <> -1 THEN
2415: );
2416:
2417:
2418: IF PG_DEBUG in ('Y', 'C') THEN
2419: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2420: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2416:
2417:
2418: IF PG_DEBUG in ('Y', 'C') THEN
2419: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2420: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2417:
2418: IF PG_DEBUG in ('Y', 'C') THEN
2419: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2420: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2418: IF PG_DEBUG in ('Y', 'C') THEN
2419: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2420: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2419: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2420: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2427: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2420: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2427: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2428: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2421: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2427: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2428: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2429: End If;
2422: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2427: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2428: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2429: End If;
2430: --bug7311231
2423: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2427: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2428: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2429: End If;
2430: --bug7311231
2431: --validate and default the flexfields
2424: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2425: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2426: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2427: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2428: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2429: End If;
2430: --bug7311231
2431: --validate and default the flexfields
2432: IF l_llca_type = 'S' OR l_llca_type = 'G'
2437: l_ad_dflex_val_return_status
2438: );
2439: END IF;
2440: IF PG_DEBUG in ('Y', 'C') THEN
2441: arp_util.debug('Desc Flexfield Validation return status: '||l_ad_dflex_val_return_status);
2442: END IF;
2443:
2444: END IF;
2445:
2528:
2529: x_return_status := FND_API.G_RET_STS_ERROR ;
2530:
2531: IF PG_DEBUG in ('Y', 'C') THEN
2532: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2533: END IF;
2534: Return;
2535: END IF;
2536:
2604:
2605: x_return_status := FND_API.G_RET_STS_ERROR ;
2606:
2607: IF PG_DEBUG in ('Y', 'C') THEN
2608: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2609: END IF;
2610: Return;
2611: END IF;
2612:
2611: END IF;
2612:
2613: --Dump the input variables to the entity handler
2614: IF PG_DEBUG in ('Y', 'C') THEN
2615: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2616: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2612:
2613: --Dump the input variables to the entity handler
2614: IF PG_DEBUG in ('Y', 'C') THEN
2615: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2616: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2613: --Dump the input variables to the entity handler
2614: IF PG_DEBUG in ('Y', 'C') THEN
2615: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2616: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2614: IF PG_DEBUG in ('Y', 'C') THEN
2615: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2616: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2615: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2616: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2616: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2617: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2625: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2618: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2625: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2626: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2619: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2625: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2626: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2627: END IF;
2620: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2625: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2626: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2627: END IF;
2628:
2621: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2625: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2626: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2627: END IF;
2628:
2629: --lock the receipt before calling the entity handler
2622: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2623: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2624: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2625: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2626: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2627: END IF;
2628:
2629: --lock the receipt before calling the entity handler
2630: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
2695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2696: ROLLBACK TO Apply_In_Detail_PVT;
2697: x_return_status := FND_API.G_RET_STS_ERROR ;
2698: IF PG_DEBUG in ('Y', 'C') THEN
2699: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2700: END IF;
2701: Return;
2702: END IF;
2703:
2803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2804: ROLLBACK TO Apply_In_Detail_PVT;
2805: x_return_status := FND_API.G_RET_STS_ERROR ;
2806: IF PG_DEBUG in ('Y', 'C') THEN
2807: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2808: END IF;
2809: Return;
2810: END IF;
2811:
2815:
2816: IF FND_API.To_Boolean( p_commit )
2817: THEN
2818: IF PG_DEBUG in ('Y', 'C') THEN
2819: arp_util.debug('Apply_In_Detail: ' || 'committing');
2820: END IF;
2821: Commit;
2822: END IF;
2823: IF PG_DEBUG in ('Y', 'C') THEN
2820: END IF;
2821: Commit;
2822: END IF;
2823: IF PG_DEBUG in ('Y', 'C') THEN
2824: arp_util.debug('Apply_In_Detail ()- ');
2825: END IF;
2826: EXCEPTION
2827: WHEN FND_API.G_EXC_ERROR THEN
2828:
2826: EXCEPTION
2827: WHEN FND_API.G_EXC_ERROR THEN
2828:
2829: IF PG_DEBUG in ('Y', 'C') THEN
2830: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2831: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2832: END IF;
2833:
2834: ROLLBACK TO Apply_In_Detail_PVT;
2827: WHEN FND_API.G_EXC_ERROR THEN
2828:
2829: IF PG_DEBUG in ('Y', 'C') THEN
2830: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2831: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2832: END IF;
2833:
2834: ROLLBACK TO Apply_In_Detail_PVT;
2835: x_return_status := FND_API.G_RET_STS_ERROR ;
2843:
2844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2845:
2846: IF PG_DEBUG in ('Y', 'C') THEN
2847: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2848: END IF;
2849: ROLLBACK TO Apply_In_Detail_PVT;
2850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2851:
2891: FND_MSG_PUB.Add;
2892: END IF;
2893:
2894: IF PG_DEBUG in ('Y', 'C') THEN
2895: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2896: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2897: END IF;
2898:
2899: ROLLBACK TO Apply_In_Detail_PVT;
2892: END IF;
2893:
2894: IF PG_DEBUG in ('Y', 'C') THEN
2895: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2896: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2897: END IF;
2898:
2899: ROLLBACK TO Apply_In_Detail_PVT;
2900:
2991: FND_MSG_PUB.initialize;
2992: END IF;
2993:
2994: IF PG_DEBUG in ('Y', 'C') THEN
2995: arp_util.debug('ar_receipt_api.Unapply()+ ');
2996: END IF;
2997:
2998: Original_unapp_info.trx_number := p_trx_number;
2999: Original_unapp_info.customer_trx_id := p_customer_trx_id;
3090: p_return_status => l_clm_return_status);
3091: END IF;
3092:
3093: IF PG_DEBUG in ('Y', 'C') THEN
3094: arp_util.debug('Apply: ' || 'validation return status :'||l_val_return_status);
3095: END IF;
3096:
3097: jg_ar_receivable_applications.Unapply(
3098: l_cash_receipt_id,
3120: p_data => x_msg_data
3121: );
3122:
3123: IF PG_DEBUG in ('Y', 'C') THEN
3124: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
3125: END IF;
3126: Return;
3127: END IF;
3128:
3126: Return;
3127: END IF;
3128:
3129: IF PG_DEBUG in ('Y', 'C') THEN
3130: arp_util.debug('Apply: ' || '*******DUMP THE INPUT PARAMETERS ********');
3131: arp_util.debug('Apply: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
3132: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3133: END IF;
3134:
3127: END IF;
3128:
3129: IF PG_DEBUG in ('Y', 'C') THEN
3130: arp_util.debug('Apply: ' || '*******DUMP THE INPUT PARAMETERS ********');
3131: arp_util.debug('Apply: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
3132: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3133: END IF;
3134:
3135: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3128:
3129: IF PG_DEBUG in ('Y', 'C') THEN
3130: arp_util.debug('Apply: ' || '*******DUMP THE INPUT PARAMETERS ********');
3131: arp_util.debug('Apply: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
3132: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3133: END IF;
3134:
3135: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3136: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of
3309:
3310: IF FND_API.To_Boolean( p_commit )
3311: THEN
3312: IF PG_DEBUG in ('Y', 'C') THEN
3313: arp_util.debug('Apply: ' || 'committing');
3314: END IF;
3315: Commit;
3316: END IF;
3317:
3315: Commit;
3316: END IF;
3317:
3318: IF PG_DEBUG in ('Y', 'C') THEN
3319: arp_util.debug('ar_receipt_api.Unapply ()- ');
3320: END IF;
3321:
3322:
3323: EXCEPTION
3323: EXCEPTION
3324: WHEN FND_API.G_EXC_ERROR THEN
3325:
3326: IF PG_DEBUG in ('Y', 'C') THEN
3327: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3328: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3329: END IF;
3330:
3331: ROLLBACK TO Unapply_PVT;
3324: WHEN FND_API.G_EXC_ERROR THEN
3325:
3326: IF PG_DEBUG in ('Y', 'C') THEN
3327: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3328: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3329: END IF;
3330:
3331: ROLLBACK TO Unapply_PVT;
3332: x_return_status := FND_API.G_RET_STS_ERROR ;
3340:
3341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3342:
3343: IF PG_DEBUG in ('Y', 'C') THEN
3344: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3345: END IF;
3346: ROLLBACK TO Unapply_PVT;
3347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3348:
3388: FND_MSG_PUB.Add;
3389: END IF;
3390:
3391: IF PG_DEBUG in ('Y', 'C') THEN
3392: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3393: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3394: END IF;
3395:
3396: ROLLBACK TO Unapply_PVT;
3389: END IF;
3390:
3391: IF PG_DEBUG in ('Y', 'C') THEN
3392: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3393: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3394: END IF;
3395:
3396: ROLLBACK TO Unapply_PVT;
3397:
3669: x_return_status := l_return_status;
3670: RETURN;
3671: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3672: --bug 3398538
3673: arp_util.debug('Create_cash_124: ');
3674: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
3675: FND_MSG_PUB.Add;
3676: x_return_status := l_return_status;
3677: RETURN;
4326:
4327: EXCEPTION
4328: WHEN others THEN
4329: IF PG_DEBUG in ('Y', 'C') THEN
4330: arp_util.debug('Exception : process_payment_1() ');
4331: END IF;
4332:
4333: END process_payment_1;
4334:
4920: -- ** OUT NOCOPY variables
4921: l_cash_receipt_id --out variable
4922: );
4923: IF PG_DEBUG in ('Y', 'C') THEN
4924: arp_util.debug('Apply: ' || 'Receipt create_return_status '||l_create_return_status);
4925: END IF;
4926: --IF the receipt creation part returns no errors then
4927: --call the application routine.
4928: IF l_create_return_status = FND_API.G_RET_STS_SUCCESS THEN
5021: Return;
5022: END IF;
5023:
5024: IF PG_DEBUG in ('Y', 'C') THEN
5025: arp_util.debug('ar_receipt_api.Create_and_apply ()-');
5026: END IF;
5027: EXCEPTION
5028: WHEN others THEN
5029: IF PG_DEBUG in ('Y', 'C') THEN
5026: END IF;
5027: EXCEPTION
5028: WHEN others THEN
5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: arp_util.debug('Exception : Create_and_apply() ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5033: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);
5304: );
5305:
5306:
5307: IF PG_DEBUG in ('Y', 'C') THEN
5308: arp_util.debug( 'Receipt create_return_status '||l_create_return_status);
5309: END IF;
5310:
5311:
5312: /*------------------------------------------------------+
5385: ELSE
5386:
5387:
5388: IF PG_DEBUG in ('Y', 'C') THEN
5389: arp_util.debug('Create_Apply_On_Acc: ' || 'Checking p_call_payment_processor: ' || p_call_payment_processor);
5390: END IF;
5391:
5392: IF ( p_call_payment_processor = FND_API.G_TRUE ) THEN
5393:
5405: x_return_status => l_cc_return_status,
5406: p_payment_trxn_extension_id => l_payment_trxn_extension_id);
5407:
5408: IF PG_DEBUG in ('Y', 'C') THEN
5409: arp_util.debug('Create_Apply_On_Acc: ' || 'Process_Credit_card return status: ' || l_cc_return_status);
5410: END IF;
5411:
5412: /*------------------------------------------------------+
5413: | Check the return status from Process_Payment |
5415: IF l_cc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5416: x_return_status := l_cc_return_status;
5417:
5418: IF PG_DEBUG in ('Y', 'C') THEN
5419: arp_util.debug('Create_Apply_On_Acc: ' || 'p_payment_response_error_code: ' || l_response_error_code);
5420: END IF;
5421:
5422: ROLLBACK TO Create_Apply_On_Acc;
5423: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5443: EXCEPTION
5444: WHEN OTHERS THEN
5445:
5446: IF PG_DEBUG in ('Y', 'C') THEN
5447: arp_util.debug('Create_Apply_On_Acc: ' || 'Exception:'|| SQLERRM);
5448: END IF;
5449:
5450: x_return_status := FND_API.G_RET_STS_ERROR ;
5451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5486: /*
5487: Added apr_standard.sysparm.org_id as IN parameter while calling
5488: arp_standard.init_standard. Bug 10016914
5489: */
5490: arp_util.debug('Before calling ARP_STANDARD.INIT_STANDARD(), arp_standard.sysparm.org_id = ' || arp_standard.sysparm.org_id);
5491: arp_standard.init_standard(arp_standard.sysparm.org_id);
5492:
5493: -- --------------------------------------------------------------
5494: -- First lock existing records from database for update
5570: END;
5571: EXCEPTION
5572: WHEN others THEN
5573: IF PG_DEBUG in ('Y', 'C') THEN
5574: arp_util.debug('Apply: ' || 'EXCEPTION: reverse_cover()');
5575: END IF;
5576: raise;
5577: END reverse_cover;
5578:
5678: x_return_status := FND_API.G_RET_STS_SUCCESS;
5679:
5680:
5681: IF PG_DEBUG in ('Y', 'C') THEN
5682: arp_util.debug('Apply: ' || 'Reverse()+ ');
5683: END IF;
5684:
5685:
5686: /* SSA change */
5730: l_reversal_reason_code,
5731: l_def_id_return_status
5732: );
5733: IF PG_DEBUG in ('Y', 'C') THEN
5734: arp_util.debug('Apply: ' || 'l_def_id_return_status :'||l_def_id_return_status);
5735: END IF;
5736: /*---------------------+
5737: | |
5738: | DEFAULTING |
5763: l_reversal_date,
5764: l_val_return_status
5765: );
5766: IF PG_DEBUG in ('Y', 'C') THEN
5767: arp_util.debug('Apply: ' || 'l_val_return_status :'||l_val_return_status);
5768: END IF;
5769:
5770: --Check if the reversal is possible.
5771:
5778: );
5779:
5780: IF l_std_reversal_possible <> 'Y' THEN
5781: IF PG_DEBUG in ('Y', 'C') THEN
5782: arp_util.debug('Apply: ' || 'Standard reversal not possible for this receipt');
5783: END IF;
5784: FND_MESSAGE.SET_NAME('AR','AR_RAPI_NON_REVERSIBLE');
5785: FND_MSG_PUB.Add;
5786: l_rev_return_status := FND_API.G_RET_STS_ERROR;
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);
5842: x_return_status := FND_API.G_RET_STS_ERROR ;
5843: WHEN OTHERS THEN
5844: arp_util.debug( 'Others exception while getting Receipt Method Id : '||sqlerrm);
5845: x_return_status := FND_API.G_RET_STS_ERROR ;
5840: EXCEPTION WHEN NO_DATA_FOUND THEN
5841: arp_util.debug( 'No Data Found exception while getting Receipt Method Id : '||sqlerrm);
5842: x_return_status := FND_API.G_RET_STS_ERROR ;
5843: WHEN OTHERS THEN
5844: arp_util.debug( 'Others exception while getting Receipt Method Id : '||sqlerrm);
5845: x_return_status := FND_API.G_RET_STS_ERROR ;
5846: END;
5847:
5848: IF l_receipt_method_id = -1 THEN
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);
5859: END IF;
5860: END IF;
5861:
5862: /* Bug fix 3539008 */
5876: );
5877: END IF;
5878: END IF;
5879: IF PG_DEBUG in ('Y', 'C') THEN
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(
5877: END IF;
5878: END IF;
5879: IF PG_DEBUG in ('Y', 'C') THEN
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,
5885: l_cash_receipt_id,
5886: l_glob_return_status);
5887:
5888: IF PG_DEBUG in ('Y', 'C') THEN
5889: arp_util.debug('Apply: ' || 'l_glob_return_status :'||l_glob_return_status);
5890: END IF;
5891: END IF;
5892:
5893: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
5913: p_data => x_msg_data
5914: );
5915:
5916: IF PG_DEBUG in ('Y', 'C') THEN
5917: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
5918: END IF;
5919: Return;
5920: END IF;
5921:
6061: p_data => x_msg_data
6062: );
6063:
6064: IF PG_DEBUG in ('Y', 'C') THEN
6065: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
6066: END IF;
6067: Return;
6068: ELSE
6069:
6071: begin
6072: --if the receipt is executed from concurrent program,
6073: IF(arp_global.request_id IS NOT NULL) THEN
6074: IF PG_DEBUG in ('Y', 'C') THEN
6075: arp_util.debug('Check if the receipts MCD exists with out eventids');
6076: end if;
6077:
6078: select count(*) into l_exist_flag
6079: from AR_MISC_CASH_DISTRIBUTIONS_ALL mcd, ar_cash_receipt_history_all rh
6086: and mcd.event_id is null;
6087:
6088: if( l_exist_flag >0) then
6089: IF PG_DEBUG in ('Y', 'C') THEN
6090: arp_util.debug('eventid with null exists for l_cash_receipt_id:'||l_cash_receipt_id);
6091: end if;
6092:
6093: l_xla_ev_rec.xla_from_doc_id := l_cash_receipt_id;
6094: l_xla_ev_rec.xla_to_doc_id := l_cash_receipt_id;
6098:
6099: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
6100:
6101: IF PG_DEBUG in ('Y', 'C') THEN
6102: arp_util.debug('after stamping the eventid on MCD');
6103: end if;
6104:
6105: end if;
6106:
6107: END IF;
6108: exception
6109: when others then
6110: IF PG_DEBUG in ('Y', 'C') THEN
6111: arp_util.debug('Exception while stamping the event id on MCD');
6112: end if;
6113: end;
6114:
6115:
6121:
6122: IF FND_API.To_Boolean( p_commit )
6123: THEN
6124: IF PG_DEBUG in ('Y', 'C') THEN
6125: arp_util.debug('Apply: ' || 'committing');
6126: END IF;
6127: Commit;
6128: END IF;
6129:
6134: EXCEPTION
6135: WHEN FND_API.G_EXC_ERROR THEN
6136:
6137: IF PG_DEBUG in ('Y', 'C') THEN
6138: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6139: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6140: END IF;
6141:
6142: ROLLBACK TO Reverse_PVT;
6135: WHEN FND_API.G_EXC_ERROR THEN
6136:
6137: IF PG_DEBUG in ('Y', 'C') THEN
6138: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6139: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6140: END IF;
6141:
6142: ROLLBACK TO Reverse_PVT;
6143: x_return_status := FND_API.G_RET_STS_ERROR ;
6150:
6151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6152:
6153: IF PG_DEBUG in ('Y', 'C') THEN
6154: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6155: END IF;
6156: ROLLBACK TO Reverse_PVT;
6157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6158:
6197: FND_MSG_PUB.Add;
6198: END IF;
6199:
6200: IF PG_DEBUG in ('Y', 'C') THEN
6201: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6202: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6203: END IF;
6204:
6205: ROLLBACK TO Reverse_PVT;
6198: END IF;
6199:
6200: IF PG_DEBUG in ('Y', 'C') THEN
6201: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6202: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6203: END IF;
6204:
6205: ROLLBACK TO Reverse_PVT;
6206:
6301: FND_MSG_PUB.initialize;
6302: END IF;
6303:
6304: IF PG_DEBUG in ('Y', 'C') THEN
6305: arp_util.debug('Apply_on_account()+ ');
6306: END IF;
6307: /*-----------------------------------------+
6308: | Initialize return status to SUCCESS |
6309: +-----------------------------------------*/
6353: l_id_conv_return_status
6354: );
6355:
6356: IF PG_DEBUG in ('Y', 'C') THEN
6357: arp_util.debug('Apply: ' || 'Defaulting Ids Return_status = '||l_id_conv_return_status);
6358: END IF;
6359: /*---------------------+
6360: | |
6361: | DEFAULTING |
6373: l_apply_date,
6374: l_cr_currency_code,
6375: l_default_return_status
6376: );
6377: arp_util.debug('after ar_receipt_lib_pvt.default_on_ac_app_info');
6378: /*---------------------+
6379: | |
6380: | VALIDATION |
6381: | |
6393: l_validation_return_status,
6394: NULL,
6395: p_called_from
6396: );
6397: arp_util.debug('after ar_receipt_lib_pvt.validate_on_ac_info');
6398:
6399: IF PG_DEBUG in ('Y', 'C') THEN
6400: arp_util.debug('Apply: ' || 'Validation return status :'||l_validation_return_status);
6401: END IF;
6396: );
6397: arp_util.debug('after ar_receipt_lib_pvt.validate_on_ac_info');
6398:
6399: IF PG_DEBUG in ('Y', 'C') THEN
6400: arp_util.debug('Apply: ' || 'Validation return status :'||l_validation_return_status);
6401: END IF;
6402:
6403: --validate and default the flexfields
6404: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
6407: l_dflex_val_return_status
6408: );
6409:
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6412: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6413: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6414: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6415: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6408: );
6409:
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6412: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6413: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6414: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6415: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6416: END IF;
6409:
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6412: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6413: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6414: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6415: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6416: END IF;
6417: END IF;
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6412: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6413: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6414: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6415: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6416: END IF;
6417: END IF;
6418:
6411: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6412: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6413: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6414: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6415: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6416: END IF;
6417: END IF;
6418:
6419:
6437: p_data => x_msg_data
6438: );
6439:
6440: IF PG_DEBUG in ('Y', 'C') THEN
6441: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
6442: END IF;
6443: Return;
6444: END IF;
6445:
6546:
6547: IF FND_API.To_Boolean( p_commit )
6548: THEN
6549: IF PG_DEBUG in ('Y', 'C') THEN
6550: arp_util.debug('Apply: ' || 'committing');
6551: END IF;
6552: Commit;
6553: END IF;
6554: IF PG_DEBUG in ('Y', 'C') THEN
6551: END IF;
6552: Commit;
6553: END IF;
6554: IF PG_DEBUG in ('Y', 'C') THEN
6555: arp_util.debug('Apply_on_account ()- ');
6556: END IF;
6557: EXCEPTION
6558: WHEN FND_API.G_EXC_ERROR THEN
6559:
6557: EXCEPTION
6558: WHEN FND_API.G_EXC_ERROR THEN
6559:
6560: IF PG_DEBUG in ('Y', 'C') THEN
6561: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6562: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6563: END IF;
6564:
6565: ROLLBACK TO Apply_on_ac_PVT;
6558: WHEN FND_API.G_EXC_ERROR THEN
6559:
6560: IF PG_DEBUG in ('Y', 'C') THEN
6561: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6562: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6563: END IF;
6564:
6565: ROLLBACK TO Apply_on_ac_PVT;
6566: x_return_status := FND_API.G_RET_STS_ERROR ;
6574:
6575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6576:
6577: IF PG_DEBUG in ('Y', 'C') THEN
6578: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6579: END IF;
6580: ROLLBACK TO Apply_on_ac_PVT;
6581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6582:
6624: FND_MSG_PUB.Add;
6625: END IF;
6626:
6627: IF PG_DEBUG in ('Y', 'C') THEN
6628: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6629: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6630: END IF;
6631:
6632: ROLLBACK TO Apply_on_ac_PVT;
6625: END IF;
6626:
6627: IF PG_DEBUG in ('Y', 'C') THEN
6628: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6629: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6630: END IF;
6631:
6632: ROLLBACK TO Apply_on_ac_PVT;
6633:
6706: FND_MSG_PUB.initialize;
6707: END IF;
6708:
6709: IF PG_DEBUG in ('Y', 'C') THEN
6710: arp_util.debug('Unapply_on_account: ' || 'ar_receipt_api.Unapply_on_ac()+ ');
6711: END IF;
6712: /*-----------------------------------------+
6713: | Initialize return status to SUCCESS |
6714: +-----------------------------------------*/
6772: l_cr_unapp_amt, /* Bug fix 3569640 */
6773: l_val_return_status);
6774:
6775: IF PG_DEBUG in ('Y', 'C') THEN
6776: arp_util.debug('Unapply_on_account: ' || 'validation return status :'||l_val_return_status);
6777: END IF;
6778: END IF;
6779:
6780: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
6794: p_data => x_msg_data
6795: );
6796:
6797: IF PG_DEBUG in ('Y', 'C') THEN
6798: arp_util.debug('Unapply_on_account: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
6799: END IF;
6800: Return;
6801: END IF;
6802:
6800: Return;
6801: END IF;
6802:
6803: IF PG_DEBUG in ('Y', 'C') THEN
6804: arp_util.debug('Unapply_on_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6805: arp_util.debug('Unapply_on_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6806: arp_util.debug('Unapply_on_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6807: END IF;
6808:
6801: END IF;
6802:
6803: IF PG_DEBUG in ('Y', 'C') THEN
6804: arp_util.debug('Unapply_on_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6805: arp_util.debug('Unapply_on_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6806: arp_util.debug('Unapply_on_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6807: END IF;
6808:
6809: --lock the receipt before calling the entity handler
6802:
6803: IF PG_DEBUG in ('Y', 'C') THEN
6804: arp_util.debug('Unapply_on_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6805: arp_util.debug('Unapply_on_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6806: arp_util.debug('Unapply_on_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6807: END IF;
6808:
6809: --lock the receipt before calling the entity handler
6810: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
6854:
6855: IF FND_API.To_Boolean( p_commit )
6856: THEN
6857: IF PG_DEBUG in ('Y', 'C') THEN
6858: arp_util.debug('Unapply_on_account: ' || 'committing');
6859: END IF;
6860: Commit;
6861: END IF;
6862:
6860: Commit;
6861: END IF;
6862:
6863: IF PG_DEBUG in ('Y', 'C') THEN
6864: arp_util.debug('Unapply_on_account: ' || 'ar_receipt_api.Unapply_on_ac ()- ');
6865: END IF;
6866:
6867:
6868: EXCEPTION
6868: EXCEPTION
6869: WHEN FND_API.G_EXC_ERROR THEN
6870:
6871: IF PG_DEBUG in ('Y', 'C') THEN
6872: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6873: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6874: END IF;
6875:
6876: ROLLBACK TO Unapply_on_ac_PVT;
6869: WHEN FND_API.G_EXC_ERROR THEN
6870:
6871: IF PG_DEBUG in ('Y', 'C') THEN
6872: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6873: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6874: END IF;
6875:
6876: ROLLBACK TO Unapply_on_ac_PVT;
6877: x_return_status := FND_API.G_RET_STS_ERROR ;
6885:
6886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6887:
6888: IF PG_DEBUG in ('Y', 'C') THEN
6889: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6890: END IF;
6891: ROLLBACK TO Unapply_on_ac_PVT;
6892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6893:
6932: FND_MSG_PUB.Add;
6933: END IF;
6934:
6935: IF PG_DEBUG in ('Y', 'C') THEN
6936: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6937: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6938: END IF;
6939:
6940: ROLLBACK TO Unapply_on_ac_PVT;
6933: END IF;
6934:
6935: IF PG_DEBUG in ('Y', 'C') THEN
6936: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6937: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6938: END IF;
6939:
6940: ROLLBACK TO Unapply_on_ac_PVT;
6941:
7024: FND_MSG_PUB.initialize;
7025: END IF;
7026:
7027: IF PG_DEBUG in ('Y', 'C') THEN
7028: arp_util.debug('ar_receipt_api.Unapply_other_account()+ ');
7029: END IF;
7030: /*-----------------------------------------+
7031: | Initialize return status to SUCCESS |
7032: +-----------------------------------------*/
7143: END IF;
7144: END IF;
7145:
7146: IF PG_DEBUG in ('Y', 'C') THEN
7147: arp_util.debug('Unapply_other_account: ' || 'validation return status :'||l_val_return_status);
7148: END IF;
7149: END IF;
7150:
7151: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
7166: p_data => x_msg_data
7167: );
7168:
7169: IF PG_DEBUG in ('Y', 'C') THEN
7170: arp_util.debug('Unapply_other_account: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
7171: END IF;
7172: Return;
7173: END IF;
7174:
7172: Return;
7173: END IF;
7174:
7175: IF PG_DEBUG in ('Y', 'C') THEN
7176: arp_util.debug('Unapply_other_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
7177: arp_util.debug('Unapply_other_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
7178: arp_util.debug('Unapply_other_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
7179: END IF;
7180:
7173: END IF;
7174:
7175: IF PG_DEBUG in ('Y', 'C') THEN
7176: arp_util.debug('Unapply_other_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
7177: arp_util.debug('Unapply_other_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
7178: arp_util.debug('Unapply_other_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
7179: END IF;
7180:
7181: --lock the receipt before calling the entity handler
7174:
7175: IF PG_DEBUG in ('Y', 'C') THEN
7176: arp_util.debug('Unapply_other_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
7177: arp_util.debug('Unapply_other_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
7178: arp_util.debug('Unapply_other_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
7179: END IF;
7180:
7181: --lock the receipt before calling the entity handler
7182: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
7238:
7239: IF FND_API.To_Boolean( p_commit )
7240: THEN
7241: IF PG_DEBUG in ('Y', 'C') THEN
7242: arp_util.debug('Unapply_other_account: ' || 'committing');
7243: END IF;
7244: Commit;
7245: END IF;
7246:
7244: Commit;
7245: END IF;
7246:
7247: IF PG_DEBUG in ('Y', 'C') THEN
7248: arp_util.debug('ar_receipt_api.Unapply_other_account ()- ');
7249: END IF;
7250:
7251:
7252: EXCEPTION
7252: EXCEPTION
7253: WHEN FND_API.G_EXC_ERROR THEN
7254:
7255: IF PG_DEBUG in ('Y', 'C') THEN
7256: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
7257: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7258: END IF;
7259:
7260: ROLLBACK TO Unapply_other_ac_PVT;
7253: WHEN FND_API.G_EXC_ERROR THEN
7254:
7255: IF PG_DEBUG in ('Y', 'C') THEN
7256: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
7257: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7258: END IF;
7259:
7260: ROLLBACK TO Unapply_other_ac_PVT;
7261: x_return_status := FND_API.G_RET_STS_ERROR ;
7269:
7270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7271:
7272: IF PG_DEBUG in ('Y', 'C') THEN
7273: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7274: END IF;
7275: ROLLBACK TO Unapply_other_ac_PVT;
7276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7277:
7316: FND_MSG_PUB.Add;
7317: END IF;
7318:
7319: IF PG_DEBUG in ('Y', 'C') THEN
7320: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
7321: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7322: END IF;
7323:
7324: ROLLBACK TO Unapply_other_ac_PVT;
7317: END IF;
7318:
7319: IF PG_DEBUG in ('Y', 'C') THEN
7320: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
7321: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7322: END IF;
7323:
7324: ROLLBACK TO Unapply_other_ac_PVT;
7325:
7486: FND_MSG_PUB.initialize;
7487: END IF;
7488:
7489: IF PG_DEBUG in ('Y', 'C') THEN
7490: arp_util.debug('Activity_application()+ ');
7491: END IF;
7492: /*-----------------------------------------+
7493: | Initialize return status to SUCCESS |
7494: +-----------------------------------------*/
7556: l_id_conv_return_status
7557: );
7558:
7559: IF PG_DEBUG in ('Y', 'C') THEN
7560: arp_util.debug('Activity_application: ' || 'Default_cash_receipt_i return status :'||l_default_return_status);
7561: END IF;
7562:
7563: /*---------------------+
7564: | |
7631:
7632: END IF;
7633:
7634: IF PG_DEBUG in ('Y', 'C') THEN
7635: arp_util.debug('Activity_application: ' || 'Default_on_ac_app_info return status :'||l_default_return_status);
7636: arp_util.debug('Activity_application: ' || 'Default_refund_attributes return status :'||l_dft_ref_return_status);
7637: END IF;
7638: /*---------------------+
7639: | |
7632: END IF;
7633:
7634: IF PG_DEBUG in ('Y', 'C') THEN
7635: arp_util.debug('Activity_application: ' || 'Default_on_ac_app_info return status :'||l_default_return_status);
7636: arp_util.debug('Activity_application: ' || 'Default_refund_attributes return status :'||l_dft_ref_return_status);
7637: END IF;
7638: /*---------------------+
7639: | |
7640: | VALIDATION |
7659: p_called_from
7660: );
7661:
7662: IF PG_DEBUG in ('Y', 'C') THEN
7663: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7664: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7665: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7666: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7667: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7660: );
7661:
7662: IF PG_DEBUG in ('Y', 'C') THEN
7663: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7664: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7665: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7666: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7667: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7668: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7661:
7662: IF PG_DEBUG in ('Y', 'C') THEN
7663: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7664: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7665: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7666: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7667: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7668: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7669: END IF;
7662: IF PG_DEBUG in ('Y', 'C') THEN
7663: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7664: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7665: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7666: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7667: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7668: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7669: END IF;
7670: END IF;
7663: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7664: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7665: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7666: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7667: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7668: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7669: END IF;
7670: END IF;
7671:
7664: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7665: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7666: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7667: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7668: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7669: END IF;
7670: END IF;
7671:
7672: -- Bug8290172 Changes Start Here
7685: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Invalid Payment Term');
7686: FND_MSG_PUB.Add;
7687:
7688: IF PG_DEBUG in ('Y', 'C') THEN
7689: arp_util.debug('Activity_application: ' || 'Invalid Payment Term. Rolling back and setting status to ERROR');
7690: END IF;
7691: END;
7692: END IF;
7693:
7701: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Payment Priority Not In Range(1-99)');
7702: FND_MSG_PUB.Add;
7703:
7704: IF PG_DEBUG in ('Y', 'C') THEN
7705: arp_util.debug('Activity_application: ' || 'Payment Priority Not In Range(1-99). Rolling back and setting status to ERROR');
7706: END IF;
7707: END IF;
7708: END IF;
7709: -- Bug8290172 Changes End Here
7715: l_pay_term_return_status <> FND_API.G_RET_STS_SUCCESS OR -- Bug8290172
7716: l_pay_priority_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- Bug8290172
7717:
7718: IF PG_DEBUG in ('Y', 'C') THEN
7719: arp_util.debug('Activity_application: ' || 'Validation FAILED ');
7720: END IF;
7721: x_return_status := FND_API.G_RET_STS_ERROR;
7722: END IF;
7723:
7733: p_data => x_msg_data
7734: );
7735:
7736: IF PG_DEBUG in ('Y', 'C') THEN
7737: arp_util.debug('Activity_application: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
7738: END IF;
7739: Return;
7740: END IF;
7741:
7917:
7918: IF FND_API.To_Boolean( p_commit )
7919: THEN
7920: IF PG_DEBUG in ('Y', 'C') THEN
7921: arp_util.debug('Activity_application: ' || 'committing');
7922: END IF;
7923: Commit;
7924: END IF;
7925: IF PG_DEBUG in ('Y', 'C') THEN
7922: END IF;
7923: Commit;
7924: END IF;
7925: IF PG_DEBUG in ('Y', 'C') THEN
7926: arp_util.debug('Activity_application ()- ');
7927: END IF;
7928: EXCEPTION
7929: WHEN FND_API.G_EXC_ERROR THEN
7930:
7928: EXCEPTION
7929: WHEN FND_API.G_EXC_ERROR THEN
7930:
7931: IF PG_DEBUG in ('Y', 'C') THEN
7932: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
7933: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7934: END IF;
7935:
7936: ROLLBACK TO Activity_app_PVT;
7929: WHEN FND_API.G_EXC_ERROR THEN
7930:
7931: IF PG_DEBUG in ('Y', 'C') THEN
7932: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
7933: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7934: END IF;
7935:
7936: ROLLBACK TO Activity_app_PVT;
7937: x_return_status := FND_API.G_RET_STS_ERROR ;
7945:
7946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7947:
7948: IF PG_DEBUG in ('Y', 'C') THEN
7949: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7950: END IF;
7951: ROLLBACK TO Activity_app_PVT;
7952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7953:
7996: FND_MSG_PUB.Add;
7997: END IF;
7998:
7999: IF PG_DEBUG in ('Y', 'C') THEN
8000: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
8001: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
8002: END IF;
8003:
8004: ROLLBACK TO Activity_app_PVT;
7997: END IF;
7998:
7999: IF PG_DEBUG in ('Y', 'C') THEN
8000: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
8001: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
8002: END IF;
8003:
8004: ROLLBACK TO Activity_app_PVT;
8005:
8082: FND_MSG_PUB.initialize;
8083: END IF;
8084:
8085: IF PG_DEBUG in ('Y', 'C') THEN
8086: arp_util.debug('ar_receipt_api.activity_unapplication()+ ');
8087: END IF;
8088: /*-----------------------------------------+
8089: | Initialize return status to SUCCESS |
8090: +-----------------------------------------*/
8158: l_cr_unapp_amt, /* Bug fix 3569640 */
8159: l_val_return_status);
8160:
8161: IF PG_DEBUG in ('Y', 'C') THEN
8162: arp_util.debug('Activity_Unapplication: ' || 'validation return status :'||l_val_return_status);
8163: END IF;
8164: END IF;
8165:
8166: /* Refunds - check for refund and cancel if refund application */
8197: p_data => x_msg_data
8198: );
8199:
8200: IF PG_DEBUG in ('Y', 'C') THEN
8201: arp_util.debug('Activity_Unapplication: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
8202: END IF;
8203: Return;
8204: END IF;
8205:
8203: Return;
8204: END IF;
8205:
8206: IF PG_DEBUG in ('Y', 'C') THEN
8207: arp_util.debug('Activity_Unapplication: ' || '*******DUMP THE INPUT PARAMETERS ********');
8208: arp_util.debug('Activity_Unapplication: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
8209: arp_util.debug('Activity_Unapplication: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
8210: END IF;
8211:
8204: END IF;
8205:
8206: IF PG_DEBUG in ('Y', 'C') THEN
8207: arp_util.debug('Activity_Unapplication: ' || '*******DUMP THE INPUT PARAMETERS ********');
8208: arp_util.debug('Activity_Unapplication: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
8209: arp_util.debug('Activity_Unapplication: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
8210: END IF;
8211:
8212: --lock the receipt before calling the entity handler
8205:
8206: IF PG_DEBUG in ('Y', 'C') THEN
8207: arp_util.debug('Activity_Unapplication: ' || '*******DUMP THE INPUT PARAMETERS ********');
8208: arp_util.debug('Activity_Unapplication: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
8209: arp_util.debug('Activity_Unapplication: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
8210: END IF;
8211:
8212: --lock the receipt before calling the entity handler
8213: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
8257:
8258: IF FND_API.To_Boolean( p_commit )
8259: THEN
8260: IF PG_DEBUG in ('Y', 'C') THEN
8261: arp_util.debug('Activity_Unapplication: ' || 'committing');
8262: END IF;
8263: Commit;
8264: END IF;
8265:
8263: Commit;
8264: END IF;
8265:
8266: IF PG_DEBUG in ('Y', 'C') THEN
8267: arp_util.debug('ar_receipt_api.Activity_unapplication()- ');
8268: END IF;
8269:
8270:
8271: EXCEPTION
8271: EXCEPTION
8272: WHEN FND_API.G_EXC_ERROR THEN
8273:
8274: IF PG_DEBUG in ('Y', 'C') THEN
8275: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
8276: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
8277: END IF;
8278:
8279: ROLLBACK TO Activity_unapplication_PVT;
8272: WHEN FND_API.G_EXC_ERROR THEN
8273:
8274: IF PG_DEBUG in ('Y', 'C') THEN
8275: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
8276: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
8277: END IF;
8278:
8279: ROLLBACK TO Activity_unapplication_PVT;
8280: x_return_status := FND_API.G_RET_STS_ERROR ;
8288:
8289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8290:
8291: IF PG_DEBUG in ('Y', 'C') THEN
8292: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
8293: END IF;
8294: ROLLBACK TO Activity_unapplication_PVT;
8295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8296:
8335: FND_MSG_PUB.Add;
8336: END IF;
8337:
8338: IF PG_DEBUG in ('Y', 'C') THEN
8339: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
8340: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
8341: END IF;
8342:
8343: ROLLBACK TO Activity_unapplication_PVT;
8336: END IF;
8337:
8338: IF PG_DEBUG in ('Y', 'C') THEN
8339: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
8340: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
8341: END IF;
8342:
8343: ROLLBACK TO Activity_unapplication_PVT;
8344:
8451: THEN
8452: FND_MSG_PUB.initialize;
8453: END IF;
8454:
8455: arp_util.debug('Apply_other_account()+ ');
8456: /*-----------------------------------------+
8457: | Initialize return status to SUCCESS |
8458: +-----------------------------------------*/
8459:
8500: p_receipt_number ,
8501: l_id_conv_return_status
8502: );
8503:
8504: arp_util.debug('Defaulting Ids Return_status = '||l_id_conv_return_status);
8505: /*---------------------+
8506: | |
8507: | DEFAULTING |
8508: | |
8520: l_cr_currency_code,
8521: l_default_return_status
8522: );
8523:
8524: arp_util.debug('Default_on_ac_app_info return status = '||l_default_return_status);
8525: /*---------------------+
8526: | |
8527: | VALIDATION |
8528: | |
8545: l_validation_return_status,
8546: p_called_from);
8547:
8548:
8549: arp_util.debug('Validation return status :'||l_validation_return_status);
8550:
8551: --Validate application reference details passed.
8552: ar_receipt_val_pvt.validate_application_ref(
8553: l_applied_payment_schedule_id,
8563: p_application_ref_reason,
8564: l_app_validation_return_status
8565: );
8566:
8567: arp_util.debug('Application ref Validation return status :'||l_app_validation_return_status);
8568:
8569:
8570: --validate and default the flexfields
8571: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
8572: l_attribute_rec,
8573: 'AR_RECEIVABLE_APPLICATIONS',
8574: l_dflex_val_return_status
8575: );
8576: arp_util.debug('Desc flexfield Validation return status :'||l_dflex_val_return_status);
8577:
8578: --default and validate the global descriptive flexfield
8579: jg_ar_receivable_applications.apply(
8580: p_apply_before_after => 'BEFORE',
8609: p_global_attribute19 => l_global_attribute_rec.global_attribute19,
8610: p_global_attribute20 => l_global_attribute_rec.global_attribute20,
8611: p_return_status => l_gdflex_return_status);
8612:
8613: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8614: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8615: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8616: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8617: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8610: p_global_attribute20 => l_global_attribute_rec.global_attribute20,
8611: p_return_status => l_gdflex_return_status);
8612:
8613: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8614: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8615: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8616: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8617: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8618: END IF;
8611: p_return_status => l_gdflex_return_status);
8612:
8613: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8614: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8615: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8616: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8617: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8618: END IF;
8619:
8612:
8613: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8614: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8615: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8616: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8617: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8618: END IF;
8619:
8620:
8613: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8614: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8615: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8616: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8617: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8618: END IF;
8619:
8620:
8621: IF l_validation_return_status <> FND_API.G_RET_STS_SUCCESS OR
8639: p_count => x_msg_count,
8640: p_data => x_msg_data
8641: );
8642:
8643: arp_util.debug('Error(s) occurred. Rolling back and setting status to ERROR');
8644: Return;
8645: END IF;
8646:
8647: --lock the receipt before calling the entity handler
8723:
8724: p_application_ref_id := l_temp_ref_id;
8725: p_application_ref_num := l_temp_ref_num;
8726:
8727: arp_util.debug('Application ID :'||to_char(ln_rec_application_id));
8728: p_receivable_application_id := ln_rec_application_id;
8729: arp_util.debug('Other Accounting Application return status :'||x_return_status);
8730: EXCEPTION
8731: WHEN OTHERS THEN
8725: p_application_ref_num := l_temp_ref_num;
8726:
8727: arp_util.debug('Application ID :'||to_char(ln_rec_application_id));
8728: p_receivable_application_id := ln_rec_application_id;
8729: arp_util.debug('Other Accounting Application return status :'||x_return_status);
8730: EXCEPTION
8731: WHEN OTHERS THEN
8732:
8733: /*-------------------------------------------------------+
8761: +--------------------------------*/
8762:
8763: IF FND_API.To_Boolean( p_commit )
8764: THEN
8765: arp_util.debug('committing');
8766: Commit;
8767: END IF;
8768: arp_util.debug('Apply_other_account ()- ');
8769: EXCEPTION
8764: THEN
8765: arp_util.debug('committing');
8766: Commit;
8767: END IF;
8768: arp_util.debug('Apply_other_account ()- ');
8769: EXCEPTION
8770: WHEN FND_API.G_EXC_ERROR THEN
8771:
8772: arp_util.debug(SQLCODE, G_MSG_ERROR);
8768: arp_util.debug('Apply_other_account ()- ');
8769: EXCEPTION
8770: WHEN FND_API.G_EXC_ERROR THEN
8771:
8772: arp_util.debug(SQLCODE, G_MSG_ERROR);
8773: arp_util.debug(SQLERRM, G_MSG_ERROR);
8774:
8775: ROLLBACK TO Apply_other_ac_PVT;
8776: x_return_status := FND_API.G_RET_STS_ERROR ;
8769: EXCEPTION
8770: WHEN FND_API.G_EXC_ERROR THEN
8771:
8772: arp_util.debug(SQLCODE, G_MSG_ERROR);
8773: arp_util.debug(SQLERRM, G_MSG_ERROR);
8774:
8775: ROLLBACK TO Apply_other_ac_PVT;
8776: x_return_status := FND_API.G_RET_STS_ERROR ;
8777:
8783: );
8784:
8785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8786:
8787: arp_util.debug(SQLERRM, G_MSG_ERROR);
8788: ROLLBACK TO Apply_other_ac_PVT;
8789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8790:
8791: -- Display_Parameters;
8831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8832: FND_MSG_PUB.Add;
8833: END IF;
8834:
8835: arp_util.debug(SQLCODE, G_MSG_ERROR);
8836: arp_util.debug(SQLERRM, G_MSG_ERROR);
8837:
8838: ROLLBACK TO Apply_other_ac_PVT;
8839:
8832: FND_MSG_PUB.Add;
8833: END IF;
8834:
8835: arp_util.debug(SQLCODE, G_MSG_ERROR);
8836: arp_util.debug(SQLERRM, G_MSG_ERROR);
8837:
8838: ROLLBACK TO Apply_other_ac_PVT;
8839:
8840: IF FND_MSG_PUB.Check_Msg_Level
9004: FND_MSG_PUB.initialize;
9005: END IF;
9006:
9007: IF PG_DEBUG in ('Y', 'C') THEN
9008: arp_util.debug('ar_receipt_api.create_misc()+ ');
9009: END IF;
9010: /*-----------------------------------------+
9011: | Initialize return status to SUCCESS |
9012: +-----------------------------------------*/
9164: l_creation_method := 'M';
9165: END IF;
9166:
9167: IF PG_DEBUG in ('Y', 'C') THEN
9168: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
9169: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9165: END IF;
9166:
9167: IF PG_DEBUG in ('Y', 'C') THEN
9168: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
9169: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9166:
9167: IF PG_DEBUG in ('Y', 'C') THEN
9168: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
9169: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9174: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
9167: IF PG_DEBUG in ('Y', 'C') THEN
9168: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
9169: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9174: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
9175: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
9168: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
9169: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9174: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
9175: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
9176: END IF;
9169: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9174: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
9175: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
9176: END IF;
9177: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9170: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9174: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
9175: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
9176: END IF;
9177: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9178:
9171: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
9172: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
9173: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
9174: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
9175: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
9176: END IF;
9177: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9178:
9179: ar_receipt_lib_pvt.get_doc_seq(
9202: FND_MSG_PUB.Add;
9203: END IF;
9204: ELSE
9205: IF PG_DEBUG in ('Y', 'C') THEN
9206: arp_util.debug('create_misc: ' || 'Receipt Number is null ');
9207: END IF;
9208: --raise error message
9209: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
9210: FND_MSG_PUB.Add;
9231: p_count => x_msg_count,
9232: p_data => x_msg_data);
9233:
9234: IF PG_DEBUG in ('Y', 'C') THEN
9235: arp_util.debug('create_misc: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
9236: END IF;
9237: Return;
9238: END IF;
9239: IF PG_DEBUG in ('Y', 'C') THEN
9236: END IF;
9237: Return;
9238: END IF;
9239: IF PG_DEBUG in ('Y', 'C') THEN
9240: arp_util.debug('create_misc: ' || 'x_return_status '||x_return_status);
9241: END IF;
9242:
9243: /* Bug fix 2300268
9244: Get the tax account id corresponding to the vat_tax_id */
9263: /*-------------------------------+
9264: | Call to the Entity Handler |
9265: +-------------------------------*/
9266: IF PG_DEBUG in ('Y', 'C') THEN
9267: arp_util.debug('create_misc: ' || ' orig payment_trxn_extension_id '||l_payment_trxn_extension_id);
9268: END IF;
9269: /* bichatte payment uptake copy extn start */
9270:
9271: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
9269: /* bichatte payment uptake copy extn start */
9270:
9271: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
9272:
9273: arp_util.debug('Create_cash_122: ' || l_creation_method);
9274: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
9275: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
9276: FND_MSG_PUB.Add;
9277: x_return_status := FND_API.G_RET_STS_ERROR;
9270:
9271: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
9272:
9273: arp_util.debug('Create_cash_122: ' || l_creation_method);
9274: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
9275: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
9276: FND_MSG_PUB.Add;
9277: x_return_status := FND_API.G_RET_STS_ERROR;
9278: END IF;
9287: --Bug : 6855895
9288: where cash_receipt_id = l_reference_id;
9289:
9290: IF PG_DEBUG in ('Y','C') THEN
9291: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
9292: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
9293: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
9294: arp_util.debug ( 'the value of org_id '|| l_org_id);
9295: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
9288: where cash_receipt_id = l_reference_id;
9289:
9290: IF PG_DEBUG in ('Y','C') THEN
9291: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
9292: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
9293: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
9294: arp_util.debug ( 'the value of org_id '|| l_org_id);
9295: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
9296: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
9289:
9290: IF PG_DEBUG in ('Y','C') THEN
9291: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
9292: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
9293: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
9294: arp_util.debug ( 'the value of org_id '|| l_org_id);
9295: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
9296: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
9297: END IF;
9290: IF PG_DEBUG in ('Y','C') THEN
9291: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
9292: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
9293: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
9294: arp_util.debug ( 'the value of org_id '|| l_org_id);
9295: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
9296: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
9297: END IF;
9298:
9291: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
9292: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
9293: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
9294: arp_util.debug ( 'the value of org_id '|| l_org_id);
9295: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
9296: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
9297: END IF;
9298:
9299: Copy_payment_extension (
9292: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
9293: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
9294: arp_util.debug ( 'the value of org_id '|| l_org_id);
9295: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
9296: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
9297: END IF;
9298:
9299: Copy_payment_extension (
9300: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
9310: p_receipt_date => l_receipt_date
9311: );
9312:
9313: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9314: arp_util.debug('Create_cash_123: ' );
9315: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
9316: FND_MSG_PUB.Add;
9317: x_return_status := FND_API.G_RET_STS_ERROR;
9318: END IF;
9507:
9508: END;
9509:
9510: IF PG_DEBUG in ('Y', 'C') THEN
9511: arp_util.debug('create_misc: ' || 'Misc Receipt id : '||to_char(p_misc_receipt_id));
9512: END IF;
9513:
9514: /*-------------------------------------------------------+
9515: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
9529:
9530: IF FND_API.To_Boolean( p_commit )
9531: THEN
9532: IF PG_DEBUG in ('Y', 'C') THEN
9533: arp_util.debug('create_misc: ' || 'committing');
9534: END IF;
9535: Commit;
9536: END IF;
9537:
9535: Commit;
9536: END IF;
9537:
9538: IF PG_DEBUG in ('Y', 'C') THEN
9539: arp_util.debug('Create_Misc_Receipt()- ');
9540: END IF;
9541:
9542:
9543:
9547: EXCEPTION
9548: WHEN FND_API.G_EXC_ERROR THEN
9549:
9550: IF PG_DEBUG in ('Y', 'C') THEN
9551: arp_util.debug('create_misc: ' || SQLCODE, G_MSG_ERROR);
9552: arp_util.debug('create_misc: ' || SQLERRM, G_MSG_ERROR);
9553: END IF;
9554:
9555: ROLLBACK TO Create_misc_PVT;
9548: WHEN FND_API.G_EXC_ERROR THEN
9549:
9550: IF PG_DEBUG in ('Y', 'C') THEN
9551: arp_util.debug('create_misc: ' || SQLCODE, G_MSG_ERROR);
9552: arp_util.debug('create_misc: ' || SQLERRM, G_MSG_ERROR);
9553: END IF;
9554:
9555: ROLLBACK TO Create_misc_PVT;
9556: x_return_status := FND_API.G_RET_STS_ERROR ;
9564:
9565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9566:
9567: IF PG_DEBUG in ('Y', 'C') THEN
9568: arp_util.debug('create_misc: ' || SQLERRM, G_MSG_ERROR);
9569: END IF;
9570: ROLLBACK TO Create_misc_PVT;
9571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9572:
9607: FND_MSG_PUB.Add;
9608: END IF;
9609:
9610: IF PG_DEBUG in ('Y', 'C') THEN
9611: arp_util.debug('create_misc: ' || SQLCODE);
9612: arp_util.debug('create_misc: ' || SQLERRM);
9613: END IF;
9614:
9615: ROLLBACK TO Create_misc_PVT;
9608: END IF;
9609:
9610: IF PG_DEBUG in ('Y', 'C') THEN
9611: arp_util.debug('create_misc: ' || SQLCODE);
9612: arp_util.debug('create_misc: ' || SQLERRM);
9613: END IF;
9614:
9615: ROLLBACK TO Create_misc_PVT;
9616:
9783: END IF;
9784:
9785:
9786: IF PG_DEBUG in ('Y', 'C') THEN
9787: arp_util.debug('Apply_Open_Receipt ()+ ');
9788: END IF;
9789: /*-----------------------------------------+
9790: | Initialize return status to SUCCESS |
9791: +-----------------------------------------*/
9859: l_open_cr_customer_id,
9860: l_def_return_status);
9861:
9862: IF PG_DEBUG in ('Y', 'C') THEN
9863: arp_util.debug('Apply_Open_Receipt: ' || 'Defaulting Ids Return_status = '||l_def_return_status);
9864: END IF;
9865: /*---------------------+
9866: | |
9867: | VALIDATION |
9892: , p_called_from => p_called_from -- bug 2897244
9893: , p_return_status => l_val_return_status);
9894:
9895: IF PG_DEBUG in ('Y', 'C') THEN
9896: arp_util.debug('Apply_Open_Receipt: ' || 'Validation Return_status = '||l_val_return_status);
9897: END IF;
9898: END IF;
9899:
9900: --validate and default the flexfields
9903: 'AR_RECEIVABLE_APPLICATIONS',
9904: l_dflex_val_return_status
9905: );
9906:
9907: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9908: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9909: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9910: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9911: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9904: l_dflex_val_return_status
9905: );
9906:
9907: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9908: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9909: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9910: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9911: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9912: END IF;
9905: );
9906:
9907: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9908: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9909: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9910: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9911: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9912: END IF;
9913:
9906:
9907: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9908: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9909: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9910: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9911: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9912: END IF;
9913:
9914:
9907: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9908: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9909: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9910: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9911: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9912: END IF;
9913:
9914:
9915: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
9930: p_data => x_msg_data
9931: );
9932:
9933: IF PG_DEBUG in ('Y', 'C') THEN
9934: arp_util.debug('Apply_Open_Receipt: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
9935: END IF;
9936: Return;
9937: END IF;
9938:
9937: END IF;
9938:
9939: --Dump the input variables to the entity handler
9940: IF PG_DEBUG in ('Y', 'C') THEN
9941: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9942: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9938:
9939: --Dump the input variables to the entity handler
9940: IF PG_DEBUG in ('Y', 'C') THEN
9941: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9942: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9946: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9939: --Dump the input variables to the entity handler
9940: IF PG_DEBUG in ('Y', 'C') THEN
9941: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9942: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9946: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9947: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9940: IF PG_DEBUG in ('Y', 'C') THEN
9941: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9942: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9946: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9947: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9948: END IF;
9941: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9942: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9946: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9947: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9948: END IF;
9949:
9942: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9946: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9947: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9948: END IF;
9949:
9950: --lock both receipts before calling the entity handlers
9943: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9944: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9945: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9946: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9947: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9948: END IF;
9949:
9950: --lock both receipts before calling the entity handlers
9951: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
10129: --
10130: -- Setting the applied_rec_app_id on each netting application..
10131: --
10132: IF PG_DEBUG in ('Y', 'C') THEN
10133: arp_util.debug('Apply_Open_Receipt: Updating applications ');
10134: END IF;
10135:
10136: IF (l_net_rec_app_id IS NULL OR l_open_net_rec_app_id IS NULL)
10137: THEN
10135:
10136: IF (l_net_rec_app_id IS NULL OR l_open_net_rec_app_id IS NULL)
10137: THEN
10138: IF PG_DEBUG in ('Y', 'C') THEN
10139: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
10140: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
10141: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
10142: END IF;
10143: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
10136: IF (l_net_rec_app_id IS NULL OR l_open_net_rec_app_id IS NULL)
10137: THEN
10138: IF PG_DEBUG in ('Y', 'C') THEN
10139: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
10140: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
10141: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
10142: END IF;
10143: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
10144: FND_MSG_PUB.Add;
10137: THEN
10138: IF PG_DEBUG in ('Y', 'C') THEN
10139: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
10140: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
10141: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
10142: END IF;
10143: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
10144: FND_MSG_PUB.Add;
10145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10159:
10160: EXCEPTION
10161: when others THEN
10162: IF PG_DEBUG in ('Y', 'C') THEN
10163: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLCODE, G_MSG_ERROR);
10164: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10165: END IF;
10166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10167: RAISE;
10160: EXCEPTION
10161: when others THEN
10162: IF PG_DEBUG in ('Y', 'C') THEN
10163: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLCODE, G_MSG_ERROR);
10164: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10165: END IF;
10166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10167: RAISE;
10168: END;
10193:
10194: IF FND_API.To_Boolean( p_commit )
10195: THEN
10196: IF PG_DEBUG in ('Y', 'C') THEN
10197: arp_util.debug('Apply_Open_Receipt: ' || 'committing');
10198: END IF;
10199: Commit;
10200: END IF;
10201: IF PG_DEBUG in ('Y', 'C') THEN
10198: END IF;
10199: Commit;
10200: END IF;
10201: IF PG_DEBUG in ('Y', 'C') THEN
10202: arp_util.debug('Apply_Open_Receipt()- ');
10203: END IF;
10204: EXCEPTION
10205: WHEN FND_API.G_EXC_ERROR THEN
10206:
10204: EXCEPTION
10205: WHEN FND_API.G_EXC_ERROR THEN
10206:
10207: IF PG_DEBUG in ('Y', 'C') THEN
10208: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10209: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10210: END IF;
10211:
10212: ROLLBACK TO Apply_Open_Receipt_PVT;
10205: WHEN FND_API.G_EXC_ERROR THEN
10206:
10207: IF PG_DEBUG in ('Y', 'C') THEN
10208: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10209: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10210: END IF;
10211:
10212: ROLLBACK TO Apply_Open_Receipt_PVT;
10213: x_return_status := FND_API.G_RET_STS_ERROR ;
10221:
10222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10223:
10224: IF PG_DEBUG in ('Y', 'C') THEN
10225: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10226: END IF;
10227: ROLLBACK TO Apply_Open_Receipt_PVT;
10228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10229:
10269: FND_MSG_PUB.Add;
10270: END IF;
10271:
10272: IF PG_DEBUG in ('Y', 'C') THEN
10273: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10274: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10275: END IF;
10276:
10277: ROLLBACK TO Apply_Open_Receipt_PVT;
10270: END IF;
10271:
10272: IF PG_DEBUG in ('Y', 'C') THEN
10273: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10274: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10275: END IF;
10276:
10277: ROLLBACK TO Apply_Open_Receipt_PVT;
10278:
10351: FND_MSG_PUB.initialize;
10352: END IF;
10353:
10354: IF PG_DEBUG in ('Y', 'C') THEN
10355: arp_util.debug('Unapply_Open_Receipt: ' || 'ar_receipt_api.Unapply_Open_Receipt()+ ');
10356: END IF;
10357: /*-----------------------------------------+
10358: | Initialize return status to SUCCESS |
10359: +-----------------------------------------*/
10477:
10478: IF FND_API.To_Boolean( p_commit )
10479: THEN
10480: IF PG_DEBUG in ('Y', 'C') THEN
10481: arp_util.debug('Unapply_Open_Receipt: ' || 'committing');
10482: END IF;
10483: Commit;
10484: END IF;
10485: IF PG_DEBUG in ('Y', 'C') THEN
10482: END IF;
10483: Commit;
10484: END IF;
10485: IF PG_DEBUG in ('Y', 'C') THEN
10486: arp_util.debug('Unapply_Open_Receipt()- ');
10487: END IF;
10488: EXCEPTION
10489: WHEN FND_API.G_EXC_ERROR THEN
10490:
10488: EXCEPTION
10489: WHEN FND_API.G_EXC_ERROR THEN
10490:
10491: IF PG_DEBUG in ('Y', 'C') THEN
10492: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10493: arp_util.debug('Unapply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10494: END IF;
10495:
10496: ROLLBACK TO Unapply_Open_Receipt_PVT;
10489: WHEN FND_API.G_EXC_ERROR THEN
10490:
10491: IF PG_DEBUG in ('Y', 'C') THEN
10492: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10493: arp_util.debug('Unapply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10494: END IF;
10495:
10496: ROLLBACK TO Unapply_Open_Receipt_PVT;
10497: x_return_status := FND_API.G_RET_STS_ERROR ;
10505:
10506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10507:
10508: IF PG_DEBUG in ('Y', 'C') THEN
10509: arp_util.debug('Unapply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10510: END IF;
10511: ROLLBACK TO Unapply_Open_Receipt_PVT;
10512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10513:
10553: FND_MSG_PUB.Add;
10554: END IF;
10555:
10556: IF PG_DEBUG in ('Y', 'C') THEN
10557: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10558: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10559: END IF;
10560:
10561: ROLLBACK TO Unapply_Open_Receipt_PVT;
10554: END IF;
10555:
10556: IF PG_DEBUG in ('Y', 'C') THEN
10557: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10558: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10559: END IF;
10560:
10561: ROLLBACK TO Unapply_Open_Receipt_PVT;
10562:
10692: and crh.request_id =p_req_id
10693: );
10694: BEGIN
10695: IF PG_DEBUG in ('Y', 'C') THEN
10696: arp_util.debug('Reverse_Remittances_in_err+' );
10697: END IF;
10698:
10699: -- SAVEPOINT Reverse_Rem_PVT;
10700:
10898: LOOP
10899:
10900: l_entered_date := l_crh_upd.gl_date(i);
10901:
10902: IF (arp_util.validate_and_default_gl_date(
10903: l_entered_date,
10904: NULL,
10905: l_crh_upd.gl_date(i),
10906: NULL,
10930: END LOOP;
10931:
10932:
10933: IF PG_DEBUG in ('Y', 'C') THEN
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
10946: AND l_crh_upd.cc_instrtype(i) in ('CREDITCARD','BANKACCOUNT')
10947: AND l_crh_upd.rec_status(i) ='VALID';
10948:
10949: IF PG_DEBUG in ('Y', 'C') THEN
10950: arp_util.debug('After CR Updation');
10951: END IF;
10952:
10953:
10954: /*Update existing CRH record of remittance*/
10966: AND status = 'REMITTED'
10967: AND l_crh_upd.rec_status(i) = 'VALID';
10968:
10969: IF PG_DEBUG in ('Y', 'C') THEN
10970: arp_util.debug('After updating existing Remittance records');
10971: END IF;
10972:
10973:
10974: /*Inserting new CRH record for CONFIRM State*/
11091: WHERE reversal_cash_receipt_hist_id=l_crh_upd.cash_receipt_history_id(i)
11092: AND l_crh_upd.rec_status(i)='VALID';
11093:
11094: IF PG_DEBUG in ('Y', 'C') THEN
11095: arp_util.debug('Inserted new CRH record for new status CONFIRM');
11096: END IF;
11097:
11098:
11099: /*Creating events for newly created CRH records*/
11133: l_xla_ev_rec.xla_mode := 'O';
11134: l_xla_ev_rec.xla_call := 'B';
11135:
11136: IF PG_DEBUG in ('Y', 'C') THEN
11137: arp_util.debug('xla_from_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11138: arp_util.debug('xla_to_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11139: arp_util.debug('xla_doc_table= '|| 'CRH');
11140: arp_util.debug('xla_mode= '|| 'O');
11141: arp_util.debug('xla_call= '|| 'B');
11134: l_xla_ev_rec.xla_call := 'B';
11135:
11136: IF PG_DEBUG in ('Y', 'C') THEN
11137: arp_util.debug('xla_from_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11138: arp_util.debug('xla_to_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11139: arp_util.debug('xla_doc_table= '|| 'CRH');
11140: arp_util.debug('xla_mode= '|| 'O');
11141: arp_util.debug('xla_call= '|| 'B');
11142: END IF;
11135:
11136: IF PG_DEBUG in ('Y', 'C') THEN
11137: arp_util.debug('xla_from_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11138: arp_util.debug('xla_to_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11139: arp_util.debug('xla_doc_table= '|| 'CRH');
11140: arp_util.debug('xla_mode= '|| 'O');
11141: arp_util.debug('xla_call= '|| 'B');
11142: END IF;
11143:
11136: IF PG_DEBUG in ('Y', 'C') THEN
11137: arp_util.debug('xla_from_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11138: arp_util.debug('xla_to_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11139: arp_util.debug('xla_doc_table= '|| 'CRH');
11140: arp_util.debug('xla_mode= '|| 'O');
11141: arp_util.debug('xla_call= '|| 'B');
11142: END IF;
11143:
11144: arp_xla_events.create_events(l_xla_ev_rec);
11137: arp_util.debug('xla_from_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11138: arp_util.debug('xla_to_doc_id= '|| l_crh_upd(i).cash_receipt_id);
11139: arp_util.debug('xla_doc_table= '|| 'CRH');
11140: arp_util.debug('xla_mode= '|| 'O');
11141: arp_util.debug('xla_call= '|| 'B');
11142: END IF;
11143:
11144: arp_xla_events.create_events(l_xla_ev_rec);
11145:
11144: arp_xla_events.create_events(l_xla_ev_rec);
11145:
11146:
11147: IF PG_DEBUG in ('Y', 'C') THEN
11148: arp_util.debug('RETURN STATUS FROM XLA () '|| to_char(SQLCODE));
11149: END IF;
11150:
11151: END IF;
11152: END LOOP;
11152: END LOOP;
11153: */
11154:
11155: IF PG_DEBUG in ('Y', 'C') THEN
11156: arp_util.debug('Generated events for CRH');
11157: END IF;
11158:
11159:
11160: /*Creating distributions as follow
11260: and ard.source_table = 'CRH'
11261: and cash_receipt_history_id=l_crh_upd.cash_receipt_history_id(i)
11262: AND l_crh_upd.rec_status(i)='VALID';
11263: IF PG_DEBUG in ('Y', 'C') THEN
11264: arp_util.debug('Created Distributions');
11265: END IF;
11266:
11267:
11268:
11269: IF l_crh_upd.cash_receipt_history_id.count > 0 THEN
11270: FOR i in l_crh_upd.cash_receipt_history_id.first..l_crh_upd.cash_receipt_history_id.last
11271: LOOP
11272: IF l_crh_upd.rec_status(i) <> 'VALID' THEN
11273: arp_util.debug('Could Not Process Receipt with receipt id -' || l_crh_upd.cash_receipt_id(i) ||
11274: ' Its getting into status- ' || l_crh_upd.rec_status(i) );
11275: END IF;
11276: END LOOP;
11277: END IF;
11284:
11285: close crh_upd_rec;
11286:
11287: IF PG_DEBUG in ('Y', 'C') THEN
11288: arp_util.debug('Reverse_Remittances_in_err-' );
11289: END IF;
11290:
11291: EXCEPTION
11292: WHEN OTHERS THEN
11294: IF l_request_id <> -1 THEN
11295:
11296: FOR i in cr_exp_rec(l_request_id)
11297: LOOP
11298: arp_util.debug('Cash Receipts not processed: ' || i.cash_receipt_id );
11299: END LOOP;
11300: END IF;
11301: END IF;
11302:
11448: END IF;
11449:
11450: EXCEPTION
11451: WHEN others THEN
11452: arp_util.debug('Exception : process_events() '|| SQLERRM);
11453:
11454: END process_events;
11455:
11456:
11795:
11796: IF l_msg_count = 1 THEN
11797:
11798: IF PG_DEBUG in ('Y', 'C') THEN
11799: arp_util.debug('l_msg_count '||l_msg_count);
11800: arp_standard.debug ( 'the message data is ' || l_msg_data );
11801: END IF;
11802:
11803: l_rcpt_error_info_tab.receipt_number(l_err_rcpt_index) := l_rcpt_info_tab(i).receipt_number;
11962: END IF;
11963:
11964:
11965: IF PG_DEBUG in ('Y', 'C') THEN
11966: arp_util.debug('Change_customer()+ ');
11967: END IF;
11968:
11969: /*-------------------------------------------------+
11970: | Initialize the profile option package variables |
12126: EXCEPTION
12127: WHEN FND_API.G_EXC_ERROR THEN
12128:
12129: IF PG_DEBUG in ('Y', 'C') THEN
12130: arp_util.debug('Change_customer: ' || SQLCODE, G_MSG_ERROR);
12131: arp_util.debug('Change_customer: ' || SQLERRM, G_MSG_ERROR);
12132: END IF;
12133:
12134: ROLLBACK TO Change_customer_PVT;
12127: WHEN FND_API.G_EXC_ERROR THEN
12128:
12129: IF PG_DEBUG in ('Y', 'C') THEN
12130: arp_util.debug('Change_customer: ' || SQLCODE, G_MSG_ERROR);
12131: arp_util.debug('Change_customer: ' || SQLERRM, G_MSG_ERROR);
12132: END IF;
12133:
12134: ROLLBACK TO Change_customer_PVT;
12135: x_return_status := FND_API.G_RET_STS_ERROR ;
12143:
12144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12145:
12146: IF PG_DEBUG in ('Y', 'C') THEN
12147: arp_util.debug('Change_customer: ' || SQLERRM, G_MSG_ERROR);
12148: END IF;
12149: ROLLBACK TO Unapply_Open_Receipt_PVT;
12150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12151:
12182: FND_MSG_PUB.Add;
12183: END IF;
12184:
12185: IF PG_DEBUG in ('Y', 'C') THEN
12186: arp_util.debug( SQLCODE, G_MSG_ERROR);
12187: arp_util.debug( SQLERRM, G_MSG_ERROR);
12188: END IF;
12189:
12190: ROLLBACK TO Change_customer_PVT;
12183: END IF;
12184:
12185: IF PG_DEBUG in ('Y', 'C') THEN
12186: arp_util.debug( SQLCODE, G_MSG_ERROR);
12187: arp_util.debug( SQLERRM, G_MSG_ERROR);
12188: END IF;
12189:
12190: ROLLBACK TO Change_customer_PVT;
12191:
12205:
12206: END Change_customer;
12207:
12208: BEGIN
12209: arp_util.debug('initialization section of ar_receipt_api_pub');
12210: ar_receipt_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
12211: ar_receipt_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
12212: ar_receipt_lib_pvt.pg_profile_appln_gl_date_def := FND_API.G_MISS_CHAR;
12213: ar_receipt_lib_pvt.pg_profile_amt_applied_def := FND_API.G_MISS_CHAR;