[Home] [Help]
61: IF ar_receipt_lib_pvt.pg_profile_def_x_rate_type = FND_API.G_MISS_CHAR THEN
62: ar_receipt_lib_pvt.pg_profile_def_x_rate_type
63: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
64: END IF;
65: arp_util.debug('*******Profile Option Values************');
66: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
62: ar_receipt_lib_pvt.pg_profile_def_x_rate_type
63: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
64: END IF;
65: arp_util.debug('*******Profile Option Values************');
66: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
63: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
64: END IF;
65: arp_util.debug('*******Profile Option Values************');
66: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
64: END IF;
65: arp_util.debug('*******Profile Option Values************');
66: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
72: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
65: arp_util.debug('*******Profile Option Values************');
66: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
72: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
73: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
66: arp_util.debug('pg_profile_appln_gl_date_def :'||ar_receipt_lib_pvt.pg_profile_appln_gl_date_def);
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
72: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
73: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
74:
67: arp_util.debug('pg_profile_amt_applied_def :'||ar_receipt_lib_pvt.pg_profile_amt_applied_def);
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
72: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
73: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
74:
75: END initialize_profile_globals;
68: arp_util.debug('pg_profile_cc_rate_type :'||ar_receipt_lib_pvt.pg_profile_cc_rate_type);
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
72: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
73: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
74:
75: END initialize_profile_globals;
76:
69: arp_util.debug('pg_profile_doc_seq :'||ar_receipt_lib_pvt.pg_profile_doc_seq);
70: arp_util.debug('pg_profile_enable_cc :'||ar_receipt_lib_pvt.pg_profile_enable_cc);
71: arp_util.debug('pg_profile_dsp_inv_rate :'||ar_receipt_lib_pvt.pg_profile_dsp_inv_rate);
72: arp_util.debug('pg_profile_create_bk_charges :'||ar_receipt_lib_pvt.pg_profile_create_bk_charges);
73: arp_util.debug('pg_profile_def_x_rate_type :'||ar_receipt_lib_pvt.pg_profile_def_x_rate_type);
74:
75: END initialize_profile_globals;
76:
77:
294: Original_create_cash_info.receipt_method_name
295: := p_receipt_method_name;
296:
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('Create_cash_1: ' || 'Create_cash_receipt()+ ');
299: END IF;
300: /*-----------------------------------------+
301: | Initialize return status to SUCCESS |
302: +-----------------------------------------*/
370: );
371: END IF;
372: END IF;
373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_util.debug('Create_cash_1: ' || 'Default_cash_ids return status :'||l_derive_cust_return_status);
375: END IF;
376: ar_receipt_lib_pvt.Get_cash_defaults(
377: l_currency_code,
378: l_exchange_rate_type,
394: l_creation_method_code,
395: l_cash_def_return_status
396: );
397: IF PG_DEBUG in ('Y', 'C') THEN
398: arp_util.debug('Create_cash_1: ' || 'Get_Cash_defaults return status :'||l_cash_def_return_status);
399: END IF;
400:
401: /*------------------------------------------+
402: | Get legal_entity_id |
535: FND_MSG_PUB.Add;
536: END IF;
537: ELSE
538: IF PG_DEBUG in ('Y', 'C') THEN
539: arp_util.debug('Create_cash_1: ' || 'Receipt Number is null ');
540: END IF;
541: --raise error message
542: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
543: FND_MSG_PUB.Add;
559: -- HERE we have to call the payment engine in order to get the payment_trx_extension_id
560: -- the conditions are if creation_method = 'A' and p_payment_trx_extension_id is null.
561: -- bichatte payment_uptake project.
562:
563: arp_util.debug ('Create_cash -- CHECK' || p_installment );
564:
565: -- We have to check the receipt_creation_rule_code and
566: -- accordingly call create or COPY
567:
577:
578:
579: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
580:
581: arp_util.debug('Create_cash_122: ' || l_creation_method_code);
582: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
583: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
584: FND_MSG_PUB.Add;
585: x_return_status := FND_API.G_RET_STS_ERROR;
578:
579: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
580:
581: arp_util.debug('Create_cash_122: ' || l_creation_method_code);
582: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
583: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
584: FND_MSG_PUB.Add;
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: END IF;
609: o_payment_trxn_extension_id =>l_copy_pmt_trxn_extension_id
610: );
611:
612: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: arp_util.debug('Create_cash_123: ' );
614: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
615: FND_MSG_PUB.Add;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: END IF;
622: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));
623: END IF;
624:
625: ELSE
626: arp_util.debug ('Create_cash -- CHECK2' || p_installment );
627: IF l_creation_method = 'A' THEN
628: arp_standard.debug('calling CREATE Extension....');
629: Create_payment_extension (
630: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
640: o_payment_trxn_extension_id =>l_create_pmt_trxn_extension_id
641: );
642:
643: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
644: arp_util.debug('Create_cash_123: ' );
645: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
646: FND_MSG_PUB.Add;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: END IF;
663: END IF; /* Return Status */
664:
665: --Dump all the variables before calling the entity handler
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
668: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
664:
665: --Dump all the variables before calling the entity handler
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
668: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
665: --Dump all the variables before calling the entity handler
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
668: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
668: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
667: arp_util.debug('Create_cash_1: ' || '*********DUMPING ALL THE VARIABLES ********');
668: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
668: arp_util.debug('Create_cash_1: ' || 'l_currency_code = '||l_currency_code);
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
669: arp_util.debug('Create_cash_1: ' || 'l_amount = '||to_char(l_amount));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
670: arp_util.debug('Create_cash_1: ' || 'l_customer_id = '||to_char(l_customer_id));
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
671: arp_util.debug('Create_cash_1: ' || 'l_receipt_number = '||l_receipt_number);
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
672: arp_util.debug('Create_cash_1: ' || 'l_receipt_date = '||to_char(l_receipt_date,'dd-mon-yy'));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
673: arp_util.debug('Create_cash_1: ' || 'l_gl_date = '||to_char(l_gl_date,'dd-mon-yy'));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
674: arp_util.debug('Create_cash_1: ' || 'l_maturity_date = '||to_char(l_maturity_date,'dd-mon-yyy'));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
675: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_type = '||l_exchange_rate_type);
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
676: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate = '||to_char(l_exchange_rate));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
677: arp_util.debug('Create_cash_1: ' || 'l_exchange_rate_date = '||to_char(l_exchange_rate_date,'dd-mon-yy'));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
685: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
678: arp_util.debug('Create_cash_1: ' || 'l_override_remit_account_flag = '||l_override_remit_account_flag);
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
685: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
686: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
679: arp_util.debug('Create_cash_1: ' || 'l_remit_bank_acct_use_id = '||to_char(l_remit_bank_acct_use_id));
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
685: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
686: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
687: END IF;
680: arp_util.debug('Create_cash_1: ' || 'l_payment_trxn_extension_id = '||to_char(l_payment_trxn_extension_id));
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
685: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
686: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
687: END IF;
688: /*------------------------------------------------------------+
681: arp_util.debug('Create_cash_1: ' || 'l_customer_site_use_id = '||to_char(l_customer_site_use_id));
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
685: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
686: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
687: END IF;
688: /*------------------------------------------------------------+
689: | If any errors - including validation failures - occurred, |
682: arp_util.debug('Create_cash_1: ' || 'l_factor_discount_amount = '||to_char(l_factor_discount_amount));
683: arp_util.debug('Create_cash_1: ' || 'l_deposit_date = '||to_char(l_deposit_date,'dd-mon-yy'));
684: arp_util.debug('Create_cash_1: ' || 'l_receipt_method_id = '||to_char(l_receipt_method_id));
685: arp_util.debug('Create_cash_1: ' || 'l_doc_sequence_value = '||to_char(l_doc_sequence_value));
686: arp_util.debug('Create_cash_1: ' || 'l_legal_entity_id = '||to_char(l_legal_entity_id)); /* R12 LE uptake */
687: END IF;
688: /*------------------------------------------------------------+
689: | If any errors - including validation failures - occurred, |
690: | rollback any changes and return an error status. |
689: | If any errors - including validation failures - occurred, |
690: | rollback any changes and return an error status. |
691: +------------------------------------------------------------*/
692: IF PG_DEBUG in ('Y', 'C') THEN
693: arp_util.debug('Create_cash_1: ' || 'x_return_status : '||x_return_status);
694: arp_util.debug('Create_cash_1: ' || 'l_doc_seq_status : '||l_doc_seq_status);
695: END IF;
696: IF (
697: x_return_status <> FND_API.G_RET_STS_SUCCESS
690: | rollback any changes and return an error status. |
691: +------------------------------------------------------------*/
692: IF PG_DEBUG in ('Y', 'C') THEN
693: arp_util.debug('Create_cash_1: ' || 'x_return_status : '||x_return_status);
694: arp_util.debug('Create_cash_1: ' || 'l_doc_seq_status : '||l_doc_seq_status);
695: END IF;
696: IF (
697: x_return_status <> FND_API.G_RET_STS_SUCCESS
698: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_util.debug('Create_cash_1: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
712: END IF;
713: Return;
714: END IF;
715: IF PG_DEBUG in ('Y', 'C') THEN
712: END IF;
713: Return;
714: END IF;
715: IF PG_DEBUG in ('Y', 'C') THEN
716: arp_util.debug('Create_cash_1: ' || 'x_return_status '||x_return_status);
717: END IF;
718: /* bichatte removed customer bank variables for the payment uptake project
719: added the l_payment_trxn_extension_id */
720: BEGIN
827: END;
828:
829: p_cr_id := l_cr_id;
830: IF PG_DEBUG in ('Y', 'C') THEN
831: arp_util.debug('Create_cash_1: ' || 'Cash Receipt id : '||to_char(l_cr_id));
832: END IF;
833:
834: /*-------------------------------------------------------+
835: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
849:
850: IF FND_API.To_Boolean( p_commit )
851: THEN
852: IF PG_DEBUG in ('Y', 'C') THEN
853: arp_util.debug('Create_cash_1: ' || 'committing');
854: END IF;
855: Commit;
856: END IF;
857:
855: Commit;
856: END IF;
857:
858: IF PG_DEBUG in ('Y', 'C') THEN
859: arp_util.debug('Create_cash_1: ' || 'Create_Cash_Receipt()- ');
860: END IF;
861:
862:
863: EXCEPTION
863: EXCEPTION
864: WHEN FND_API.G_EXC_ERROR THEN
865:
866: IF PG_DEBUG in ('Y', 'C') THEN
867: arp_util.debug('Create_cash_1: ' || SQLCODE, G_MSG_ERROR);
868: arp_util.debug('Create_cash_1: ' || SQLERRM, G_MSG_ERROR);
869: END IF;
870:
871: ROLLBACK TO Create_Cash_PVT;
864: WHEN FND_API.G_EXC_ERROR THEN
865:
866: IF PG_DEBUG in ('Y', 'C') THEN
867: arp_util.debug('Create_cash_1: ' || SQLCODE, G_MSG_ERROR);
868: arp_util.debug('Create_cash_1: ' || SQLERRM, G_MSG_ERROR);
869: END IF;
870:
871: ROLLBACK TO Create_Cash_PVT;
872: x_return_status := FND_API.G_RET_STS_ERROR ;
880:
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882:
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug('Create_cash_1: ' || SQLERRM, G_MSG_ERROR);
885: END IF;
886: ROLLBACK TO Create_Cash_PVT;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888:
923: FND_MSG_PUB.Add;
924: END IF;
925:
926: IF PG_DEBUG in ('Y', 'C') THEN
927: arp_util.debug('Create_cash_1: ' || SQLCODE);
928: arp_util.debug('Create_cash_1: ' || SQLERRM);
929: END IF;
930:
931: ROLLBACK TO Create_Cash_PVT;
924: END IF;
925:
926: IF PG_DEBUG in ('Y', 'C') THEN
927: arp_util.debug('Create_cash_1: ' || SQLCODE);
928: arp_util.debug('Create_cash_1: ' || SQLERRM);
929: END IF;
930:
931: ROLLBACK TO Create_Cash_PVT;
932:
1281: Original_application_info.amount_applied_from := p_amount_applied_from;
1282: Original_application_info.trans_to_receipt_rate := p_trans_to_receipt_rate;
1283:
1284: IF PG_DEBUG in ('Y', 'C') THEN
1285: arp_util.debug('Apply()+ ');
1286: END IF;
1287:
1288: /*-----------------------------------------+
1289: | Initialize return status to SUCCESS |
1350: l_def_ids_return_status);
1351:
1352:
1353: IF PG_DEBUG in ('Y', 'C') THEN
1354: arp_util.debug('Apply: ' || 'Defaulting Ids Return_status = '||l_def_ids_return_status);
1355: END IF;
1356: /*---------------------+
1357: | |
1358: | DEFAULTING |
1358: | DEFAULTING |
1359: | |
1360: +---------------------*/
1361: IF PG_DEBUG in ('Y', 'C') THEN
1362: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1363: END IF;
1364: ar_receipt_lib_pvt.Default_application_info(
1365: l_cash_receipt_id ,
1366: l_cr_gl_date,
1419: p_called_from,
1420: l_def_return_status
1421: );
1422: IF PG_DEBUG in ('Y', 'C') THEN
1423: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1424: arp_util.debug('Apply: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
1425: arp_util.debug('Apply: ' || 'Defaulting Return_status = '||l_def_return_status);
1426: END IF;
1427: /*---------------------+
1420: l_def_return_status
1421: );
1422: IF PG_DEBUG in ('Y', 'C') THEN
1423: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1424: arp_util.debug('Apply: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
1425: arp_util.debug('Apply: ' || 'Defaulting Return_status = '||l_def_return_status);
1426: END IF;
1427: /*---------------------+
1428: | |
1421: );
1422: IF PG_DEBUG in ('Y', 'C') THEN
1423: arp_util.debug('Apply: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
1424: arp_util.debug('Apply: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
1425: arp_util.debug('Apply: ' || 'Defaulting Return_status = '||l_def_return_status);
1426: END IF;
1427: /*---------------------+
1428: | |
1429: | VALIDATION |
1481: l_rec_charges_remaining,
1482: l_val_return_status
1483: );
1484: IF PG_DEBUG in ('Y', 'C') THEN
1485: arp_util.debug('Apply: ' || 'Validation Return_status = '||l_val_return_status);
1486: END IF;
1487: END IF;
1488:
1489: --Validate application reference details passed.
1505: l_app_validation_return_status
1506: );
1507:
1508: IF PG_DEBUG in ('Y', 'C') THEN
1509: arp_util.debug('Apply: ' || 'Application ref Validation return status :'||l_app_validation_return_status);
1510: END IF;
1511:
1512: --validate and default the flexfields
1513: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
1576:
1577: x_return_status := FND_API.G_RET_STS_ERROR ;
1578:
1579: IF PG_DEBUG in ('Y', 'C') THEN
1580: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
1581: END IF;
1582: Return;
1583: END IF;
1584:
1583: END IF;
1584:
1585: --Dump the input variables to the entity handler
1586: IF PG_DEBUG in ('Y', 'C') THEN
1587: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1588: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1584:
1585: --Dump the input variables to the entity handler
1586: IF PG_DEBUG in ('Y', 'C') THEN
1587: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1588: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1585: --Dump the input variables to the entity handler
1586: IF PG_DEBUG in ('Y', 'C') THEN
1587: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1588: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1586: IF PG_DEBUG in ('Y', 'C') THEN
1587: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1588: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1587: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
1588: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1588: arp_util.debug('Apply: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1589: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1597: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1590: arp_util.debug('Apply: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1597: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1598: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1591: arp_util.debug('Apply: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1597: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1598: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1599: END IF;
1592: arp_util.debug('Apply: ' || 'l_trx_currency_code : '||l_trx_currency_code);
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1597: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1598: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1599: END IF;
1600:
1593: arp_util.debug('Apply: ' || 'l_cr_currency_code : '||l_cr_currency_code);
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1597: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1598: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1599: END IF;
1600:
1601: --lock the receipt before calling the entity handler
1594: arp_util.debug('Apply: ' || 'l_discount_earned : '||to_char(l_discount_earned));
1595: arp_util.debug('Apply: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
1596: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
1597: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
1598: arp_util.debug('Apply: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
1599: END IF;
1600:
1601: --lock the receipt before calling the entity handler
1602: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
1765:
1766: IF FND_API.To_Boolean( p_commit )
1767: THEN
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: arp_util.debug('Apply: ' || 'committing');
1770: END IF;
1771: Commit;
1772: END IF;
1773: IF PG_DEBUG in ('Y', 'C') THEN
1770: END IF;
1771: Commit;
1772: END IF;
1773: IF PG_DEBUG in ('Y', 'C') THEN
1774: arp_util.debug('Apply ()- ');
1775: END IF;
1776: EXCEPTION
1777: WHEN FND_API.G_EXC_ERROR THEN
1778:
1776: EXCEPTION
1777: WHEN FND_API.G_EXC_ERROR THEN
1778:
1779: IF PG_DEBUG in ('Y', 'C') THEN
1780: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1781: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1782: END IF;
1783:
1784: ROLLBACK TO Apply_PVT;
1777: WHEN FND_API.G_EXC_ERROR THEN
1778:
1779: IF PG_DEBUG in ('Y', 'C') THEN
1780: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1781: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1782: END IF;
1783:
1784: ROLLBACK TO Apply_PVT;
1785: x_return_status := FND_API.G_RET_STS_ERROR ;
1793:
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795:
1796: IF PG_DEBUG in ('Y', 'C') THEN
1797: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1798: END IF;
1799: ROLLBACK TO Apply_PVT;
1800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1801:
1841: FND_MSG_PUB.Add;
1842: END IF;
1843:
1844: IF PG_DEBUG in ('Y', 'C') THEN
1845: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1846: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1847: END IF;
1848:
1849: ROLLBACK TO Apply_PVT;
1842: END IF;
1843:
1844: IF PG_DEBUG in ('Y', 'C') THEN
1845: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
1846: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
1847: END IF;
1848:
1849: ROLLBACK TO Apply_PVT;
1850:
2057: := p_trans_to_receipt_rate;
2058: Original_application_info.applied_payment_schedule_id
2059: := p_applied_payment_schedule_id;
2060: IF PG_DEBUG in ('Y', 'C') THEN
2061: arp_util.debug('Apply_In_Detail()+ ');
2062: END IF;
2063:
2064: /*-----------------------------------------+
2065: | Initialize return status to SUCCESS |
2087: | ===== Dump the Input Parameters ======== |
2088: +---------------------------------------------*/
2089:
2090: IF PG_DEBUG in ('Y', 'C') THEN
2091: arp_util.debug('=======================================================');
2092: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2088: +---------------------------------------------*/
2089:
2090: IF PG_DEBUG in ('Y', 'C') THEN
2091: arp_util.debug('=======================================================');
2092: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2089:
2090: IF PG_DEBUG in ('Y', 'C') THEN
2091: arp_util.debug('=======================================================');
2092: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2090: IF PG_DEBUG in ('Y', 'C') THEN
2091: arp_util.debug('=======================================================');
2092: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2091: arp_util.debug('=======================================================');
2092: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2092: arp_util.debug(' Apply_In_Detail ( INPUT PARAMETERS ........)+ ');
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2093: arp_util.debug('=======================================================');
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2094: arp_util.debug('p_api_version =>'||to_char(p_api_version));
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2095: arp_util.debug('p_init_msg_list =>'||p_init_msg_list);
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2096: arp_util.debug('p_commit =>'||p_commit);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2097: arp_util.debug('p_validation_level =>'||to_char(p_validation_level));
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2098: arp_util.debug('p_cash_receipt_id =>'||to_char(p_cash_receipt_id));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2099: arp_util.debug('p_receipt_number =>'||p_receipt_number);
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2100: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2101: arp_util.debug('p_trx_number =>'||p_trx_number);
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2102: arp_util.debug('p_installment =>'||p_installment);
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2103: arp_util.debug('p_applied_payment_schedule_id =>'||to_char(p_applied_payment_schedule_id));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2104: arp_util.debug('p_llca_type =>'||p_llca_type);
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2105: arp_util.debug('p_group_id =>'||p_group_id);
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2106: arp_util.debug('p_line_amount =>'||to_char(p_line_amount));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2107: arp_util.debug('p_tax_amount =>'||to_char(p_tax_amount));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2108: arp_util.debug('p_freight_amount =>'||to_char(p_freight_amount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2109: arp_util.debug('p_charges_amount =>'||to_char(p_charges_amount));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2110: arp_util.debug('p_amount_applied =>'||to_char(p_amount_applied));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2111: arp_util.debug('p_line_discount =>'||to_char(p_line_discount));
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2112: arp_util.debug('p_tax_discount =>'||to_char(p_tax_discount));
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2113: arp_util.debug('p_freight_discount =>'||to_char(p_freight_discount));
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2114: arp_util.debug('p_amount_applied_from =>'||to_char(p_amount_applied_from));
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2115: arp_util.debug('p_trans_to_receipt_rate =>'||to_char(p_trans_to_receipt_rate));
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2116: arp_util.debug('p_discount =>'||to_char(p_discount));
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2117: arp_util.debug('p_apply_date =>'||to_char(p_apply_date));
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2118: arp_util.debug('p_apply_gl_date =>'||to_char(p_apply_gl_date));
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2119: arp_util.debug('p_ussgl_transaction_code =>'||p_ussgl_transaction_code);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2120: arp_util.debug('p_show_closed_invoices =>'||p_show_closed_invoices);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2121: arp_util.debug('p_called_from =>'||p_called_from);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2122: arp_util.debug('p_move_deferred_tax =>'||p_move_deferred_tax);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2123: arp_util.debug('p_link_to_trx_hist_id =>'||p_link_to_trx_hist_id);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2124: arp_util.debug('p_comments =>'||p_comments);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2125: arp_util.debug('p_payment_set_id =>'||p_payment_set_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2133: arp_util.debug('p_org_id =>'||p_org_id);
2126: arp_util.debug('p_application_ref_type =>'||p_application_ref_type);
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2133: arp_util.debug('p_org_id =>'||p_org_id);
2134: arp_util.debug('=======================================================');
2127: arp_util.debug('p_application_ref_id =>'||p_application_ref_id);
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2133: arp_util.debug('p_org_id =>'||p_org_id);
2134: arp_util.debug('=======================================================');
2135: END IF;
2128: arp_util.debug('p_application_ref_num =>'||p_application_ref_num);
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2133: arp_util.debug('p_org_id =>'||p_org_id);
2134: arp_util.debug('=======================================================');
2135: END IF;
2136:
2129: arp_util.debug('p_secondary_application_ref_id=>'||p_secondary_application_ref_id);
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2133: arp_util.debug('p_org_id =>'||p_org_id);
2134: arp_util.debug('=======================================================');
2135: END IF;
2136:
2137: /*---------------------------------------------+
2130: arp_util.debug('p_application_ref_reason =>'||p_application_ref_reason);
2131: arp_util.debug('p_customer_reference =>'||p_customer_reference);
2132: arp_util.debug('p_customer_reason =>'||p_customer_reason);
2133: arp_util.debug('p_org_id =>'||p_org_id);
2134: arp_util.debug('=======================================================');
2135: END IF;
2136:
2137: /*---------------------------------------------+
2138: | ========== Start of API Body ========== |
2182: p_amount_applied_from => l_amount_applied_from,
2183: p_return_status => l_gt_return_status);
2184:
2185: IF PG_DEBUG in ('Y', 'C') THEN
2186: arp_util.debug('Apply_In_Detail: ' || 'Plsql table Return_status = '||l_gt_return_status);
2187: END IF;
2188:
2189: IF l_gt_return_status <> FND_API.G_RET_STS_SUCCESS
2190: THEN
2191: ROLLBACK TO Apply_In_Detail_PVT;
2192: x_return_status := FND_API.G_RET_STS_ERROR ;
2193:
2194: IF PG_DEBUG in ('Y', 'C') THEN
2195: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2196: END IF;
2197: Return;
2198: END IF;
2199:
2215: p_group_id => l_group_id,
2216: p_return_status => l_def_ids_return_status);
2217:
2218: IF PG_DEBUG in ('Y', 'C') THEN
2219: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Ids Return_status = '||l_def_ids_return_status);
2220: END IF;
2221:
2222: -- Inorder to retained the errors on GT, we need to return the call without rollback.
2223: IF l_def_ids_return_status <> FND_API.G_RET_STS_SUCCESS
2229: THEN
2230: x_return_status := FND_API.G_RET_STS_ERROR ;
2231:
2232: IF PG_DEBUG in ('Y', 'C') THEN
2233: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred in PLSQL table parameters. ');
2234: END IF;
2235: Return;
2236: END IF;
2237: END IF ;
2240: | DEFAULTING |
2241: | |
2242: +---------------------*/
2243: IF PG_DEBUG in ('Y', 'C') THEN
2244: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2245: END IF;
2246: ar_receipt_lib_pvt.Default_application_info(
2247: p_cash_receipt_id => l_cash_receipt_id ,
2248: p_cr_gl_date => l_cr_gl_date,
2301: p_called_from => p_called_from,
2302: p_return_status => l_def_return_status
2303: );
2304: IF PG_DEBUG in ('Y', 'C') THEN
2305: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2306: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2307: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2308: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2309: END IF;
2302: p_return_status => l_def_return_status
2303: );
2304: IF PG_DEBUG in ('Y', 'C') THEN
2305: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2306: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2307: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2308: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2309: END IF;
2310:
2303: );
2304: IF PG_DEBUG in ('Y', 'C') THEN
2305: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2306: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2307: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2308: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2309: END IF;
2310:
2311: /*---------------------+
2304: IF PG_DEBUG in ('Y', 'C') THEN
2305: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2306: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2307: arp_util.debug('Apply_In_Detail: ' || 'l_new_amount_due_remaining :'||to_char(l_new_amount_due_remaining));
2308: arp_util.debug('Apply_In_Detail: ' || 'Defaulting Return_status = '||l_def_return_status);
2309: END IF;
2310:
2311: /*---------------------+
2312: | |
2361: p_return_status => l_val_return_status
2362: );
2363:
2364: IF PG_DEBUG in ('Y', 'C') THEN
2365: arp_util.debug('Apply_In_Detail: ' || 'Validation Return_status = '||l_val_return_status);
2366: END IF;
2367:
2368: --validate and default the flexfields
2369: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
2372: l_dflex_val_return_status
2373: );
2374:
2375: IF PG_DEBUG in ('Y', 'C') THEN
2376: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2377: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2373: );
2374:
2375: IF PG_DEBUG in ('Y', 'C') THEN
2376: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2377: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2374:
2375: IF PG_DEBUG in ('Y', 'C') THEN
2376: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2377: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2375: IF PG_DEBUG in ('Y', 'C') THEN
2376: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2377: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2376: arp_util.debug('Apply_In_Detail: ' || 'l_line_amount :'||to_char(l_line_amount));
2377: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2384: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2377: arp_util.debug('Apply_In_Detail: ' || 'l_tax_amount :'||to_char(l_tax_amount));
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2384: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2385: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2378: arp_util.debug('Apply_In_Detail: ' || 'l_freight_amount :'||to_char(l_freight_amount));
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2384: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2385: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2386: End If;
2379: arp_util.debug('Apply_In_Detail: ' || 'l_charges_amount :'||to_char(l_charges_amount));
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2384: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2385: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2386: End If;
2387: --bug7311231
2380: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied :'||to_char(l_amount_applied));
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2384: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2385: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2386: End If;
2387: --bug7311231
2388: --validate and default the flexfields
2381: arp_util.debug('Apply_In_Detail: ' || 'l_line_discount :'||to_char(l_line_discount));
2382: arp_util.debug('Apply_In_Detail: ' || 'l_tax_discount :'||to_char(l_tax_discount));
2383: arp_util.debug('Apply_In_Detail: ' || 'l_freight_discount :'||to_char(l_freight_discount));
2384: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from :'||to_char(l_amount_applied_from));
2385: arp_util.debug('Apply_In_Detail: ' || 'Validate Return_status = '||l_val_return_status);
2386: End If;
2387: --bug7311231
2388: --validate and default the flexfields
2389: IF l_llca_type = 'S' OR l_llca_type = 'G'
2394: l_ad_dflex_val_return_status
2395: );
2396: END IF;
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('Desc Flexfield Validation return status: '||l_ad_dflex_val_return_status);
2399: END IF;
2400:
2401: -- Validate the LLCA data and populate to AD and GT
2402: -- bug7311231, Modified the parameter list passing the flexfield info.
2483:
2484: x_return_status := FND_API.G_RET_STS_ERROR ;
2485:
2486: IF PG_DEBUG in ('Y', 'C') THEN
2487: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2488: END IF;
2489: Return;
2490: END IF;
2491:
2559:
2560: x_return_status := FND_API.G_RET_STS_ERROR ;
2561:
2562: IF PG_DEBUG in ('Y', 'C') THEN
2563: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2564: END IF;
2565: Return;
2566: END IF;
2567:
2566: END IF;
2567:
2568: --Dump the input variables to the entity handler
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2571: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2567:
2568: --Dump the input variables to the entity handler
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2571: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2568: --Dump the input variables to the entity handler
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2571: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2571: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2570: arp_util.debug('Apply_In_Detail: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
2571: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2571: arp_util.debug('Apply_In_Detail: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2572: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied : '||to_char(l_amount_applied));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2580: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2573: arp_util.debug('Apply_In_Detail: ' || 'l_amount_applied_from : '||to_char(l_amount_applied_from));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2580: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2581: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2574: arp_util.debug('Apply_In_Detail: ' || 'l_trans_to_receipt_rate : '||to_char(l_trans_to_receipt_rate));
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2580: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2581: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2582: END IF;
2575: arp_util.debug('Apply_In_Detail: ' || 'l_trx_currency_code : '||l_trx_currency_code);
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2580: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2581: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2582: END IF;
2583:
2576: arp_util.debug('Apply_In_Detail: ' || 'l_cr_currency_code : '||l_cr_currency_code);
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2580: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2581: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2582: END IF;
2583:
2584: --lock the receipt before calling the entity handler
2577: arp_util.debug('Apply_In_Detail: ' || 'l_discount_earned : '||to_char(l_discount_earned));
2578: arp_util.debug('Apply_In_Detail: ' || 'l_discount_unearned : '||to_char(l_discount_unearned));
2579: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
2580: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
2581: arp_util.debug('Apply_In_Detail: ' || 'l_customer_trx_line_id : '||to_char(l_customer_trx_line_id));
2582: END IF;
2583:
2584: --lock the receipt before calling the entity handler
2585: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
2650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2651: ROLLBACK TO Apply_In_Detail_PVT;
2652: x_return_status := FND_API.G_RET_STS_ERROR ;
2653: IF PG_DEBUG in ('Y', 'C') THEN
2654: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2655: END IF;
2656: Return;
2657: END IF;
2658:
2757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2758: ROLLBACK TO Apply_In_Detail_PVT;
2759: x_return_status := FND_API.G_RET_STS_ERROR ;
2760: IF PG_DEBUG in ('Y', 'C') THEN
2761: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
2762: END IF;
2763: Return;
2764: END IF;
2765:
2769:
2770: IF FND_API.To_Boolean( p_commit )
2771: THEN
2772: IF PG_DEBUG in ('Y', 'C') THEN
2773: arp_util.debug('Apply_In_Detail: ' || 'committing');
2774: END IF;
2775: Commit;
2776: END IF;
2777: IF PG_DEBUG in ('Y', 'C') THEN
2774: END IF;
2775: Commit;
2776: END IF;
2777: IF PG_DEBUG in ('Y', 'C') THEN
2778: arp_util.debug('Apply_In_Detail ()- ');
2779: END IF;
2780: EXCEPTION
2781: WHEN FND_API.G_EXC_ERROR THEN
2782:
2780: EXCEPTION
2781: WHEN FND_API.G_EXC_ERROR THEN
2782:
2783: IF PG_DEBUG in ('Y', 'C') THEN
2784: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2785: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2786: END IF;
2787:
2788: ROLLBACK TO Apply_In_Detail_PVT;
2781: WHEN FND_API.G_EXC_ERROR THEN
2782:
2783: IF PG_DEBUG in ('Y', 'C') THEN
2784: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2785: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2786: END IF;
2787:
2788: ROLLBACK TO Apply_In_Detail_PVT;
2789: x_return_status := FND_API.G_RET_STS_ERROR ;
2797:
2798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2799:
2800: IF PG_DEBUG in ('Y', 'C') THEN
2801: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2802: END IF;
2803: ROLLBACK TO Apply_In_Detail_PVT;
2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2805:
2845: FND_MSG_PUB.Add;
2846: END IF;
2847:
2848: IF PG_DEBUG in ('Y', 'C') THEN
2849: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2850: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2851: END IF;
2852:
2853: ROLLBACK TO Apply_In_Detail_PVT;
2846: END IF;
2847:
2848: IF PG_DEBUG in ('Y', 'C') THEN
2849: arp_util.debug('Apply_In_Detail: ' || SQLCODE, G_MSG_ERROR);
2850: arp_util.debug('Apply_In_Detail: ' || SQLERRM, G_MSG_ERROR);
2851: END IF;
2852:
2853: ROLLBACK TO Apply_In_Detail_PVT;
2854:
2945: FND_MSG_PUB.initialize;
2946: END IF;
2947:
2948: IF PG_DEBUG in ('Y', 'C') THEN
2949: arp_util.debug('ar_receipt_api.Unapply()+ ');
2950: END IF;
2951:
2952: Original_unapp_info.trx_number := p_trx_number;
2953: Original_unapp_info.customer_trx_id := p_customer_trx_id;
3044: p_return_status => l_clm_return_status);
3045: END IF;
3046:
3047: IF PG_DEBUG in ('Y', 'C') THEN
3048: arp_util.debug('Apply: ' || 'validation return status :'||l_val_return_status);
3049: END IF;
3050:
3051: jg_ar_receivable_applications.Unapply(
3052: l_cash_receipt_id,
3074: p_data => x_msg_data
3075: );
3076:
3077: IF PG_DEBUG in ('Y', 'C') THEN
3078: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
3079: END IF;
3080: Return;
3081: END IF;
3082:
3080: Return;
3081: END IF;
3082:
3083: IF PG_DEBUG in ('Y', 'C') THEN
3084: arp_util.debug('Apply: ' || '*******DUMP THE INPUT PARAMETERS ********');
3085: arp_util.debug('Apply: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
3086: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3087: END IF;
3088:
3081: END IF;
3082:
3083: IF PG_DEBUG in ('Y', 'C') THEN
3084: arp_util.debug('Apply: ' || '*******DUMP THE INPUT PARAMETERS ********');
3085: arp_util.debug('Apply: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
3086: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3087: END IF;
3088:
3089: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3082:
3083: IF PG_DEBUG in ('Y', 'C') THEN
3084: arp_util.debug('Apply: ' || '*******DUMP THE INPUT PARAMETERS ********');
3085: arp_util.debug('Apply: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
3086: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3087: END IF;
3088:
3089: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3090: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of
3263:
3264: IF FND_API.To_Boolean( p_commit )
3265: THEN
3266: IF PG_DEBUG in ('Y', 'C') THEN
3267: arp_util.debug('Apply: ' || 'committing');
3268: END IF;
3269: Commit;
3270: END IF;
3271:
3269: Commit;
3270: END IF;
3271:
3272: IF PG_DEBUG in ('Y', 'C') THEN
3273: arp_util.debug('ar_receipt_api.Unapply ()- ');
3274: END IF;
3275:
3276:
3277: EXCEPTION
3277: EXCEPTION
3278: WHEN FND_API.G_EXC_ERROR THEN
3279:
3280: IF PG_DEBUG in ('Y', 'C') THEN
3281: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3282: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3283: END IF;
3284:
3285: ROLLBACK TO Unapply_PVT;
3278: WHEN FND_API.G_EXC_ERROR THEN
3279:
3280: IF PG_DEBUG in ('Y', 'C') THEN
3281: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3282: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3283: END IF;
3284:
3285: ROLLBACK TO Unapply_PVT;
3286: x_return_status := FND_API.G_RET_STS_ERROR ;
3294:
3295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3296:
3297: IF PG_DEBUG in ('Y', 'C') THEN
3298: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3299: END IF;
3300: ROLLBACK TO Unapply_PVT;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3302:
3342: FND_MSG_PUB.Add;
3343: END IF;
3344:
3345: IF PG_DEBUG in ('Y', 'C') THEN
3346: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3347: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3348: END IF;
3349:
3350: ROLLBACK TO Unapply_PVT;
3343: END IF;
3344:
3345: IF PG_DEBUG in ('Y', 'C') THEN
3346: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
3347: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
3348: END IF;
3349:
3350: ROLLBACK TO Unapply_PVT;
3351:
3623: x_return_status := l_return_status;
3624: RETURN;
3625: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3626: --bug 3398538
3627: arp_util.debug('Create_cash_124: ');
3628: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
3629: FND_MSG_PUB.Add;
3630: x_return_status := l_return_status;
3631: RETURN;
4258:
4259: EXCEPTION
4260: WHEN others THEN
4261: IF PG_DEBUG in ('Y', 'C') THEN
4262: arp_util.debug('Exception : process_payment_1() ');
4263: END IF;
4264:
4265: END process_payment_1;
4266:
4747: -- ** OUT NOCOPY variables
4748: l_cash_receipt_id --out variable
4749: );
4750: IF PG_DEBUG in ('Y', 'C') THEN
4751: arp_util.debug('Apply: ' || 'Receipt create_return_status '||l_create_return_status);
4752: END IF;
4753: --IF the receipt creation part returns no errors then
4754: --call the application routine.
4755: IF l_create_return_status = FND_API.G_RET_STS_SUCCESS THEN
4848: Return;
4849: END IF;
4850:
4851: IF PG_DEBUG in ('Y', 'C') THEN
4852: arp_util.debug('ar_receipt_api.Create_and_apply ()-');
4853: END IF;
4854: EXCEPTION
4855: WHEN others THEN
4856: IF PG_DEBUG in ('Y', 'C') THEN
4853: END IF;
4854: EXCEPTION
4855: WHEN others THEN
4856: IF PG_DEBUG in ('Y', 'C') THEN
4857: arp_util.debug('Exception : Create_and_apply() ');
4858: END IF;
4859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4860: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4861: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_AND_APPLY : '||SQLERRM);
5131: );
5132:
5133:
5134: IF PG_DEBUG in ('Y', 'C') THEN
5135: arp_util.debug( 'Receipt create_return_status '||l_create_return_status);
5136: END IF;
5137:
5138:
5139: /*------------------------------------------------------+
5212: ELSE
5213:
5214:
5215: IF PG_DEBUG in ('Y', 'C') THEN
5216: arp_util.debug('Create_Apply_On_Acc: ' || 'Checking p_call_payment_processor: ' || p_call_payment_processor);
5217: END IF;
5218:
5219: IF ( p_call_payment_processor = FND_API.G_TRUE ) THEN
5220:
5232: x_return_status => l_cc_return_status,
5233: p_payment_trxn_extension_id => l_payment_trxn_extension_id);
5234:
5235: IF PG_DEBUG in ('Y', 'C') THEN
5236: arp_util.debug('Create_Apply_On_Acc: ' || 'Process_Credit_card return status: ' || l_cc_return_status);
5237: END IF;
5238:
5239: /*------------------------------------------------------+
5240: | Check the return status from Process_Payment |
5242: IF l_cc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5243: x_return_status := l_cc_return_status;
5244:
5245: IF PG_DEBUG in ('Y', 'C') THEN
5246: arp_util.debug('Create_Apply_On_Acc: ' || 'p_payment_response_error_code: ' || l_response_error_code);
5247: END IF;
5248:
5249: ROLLBACK TO Create_Apply_On_Acc;
5250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5270: EXCEPTION
5271: WHEN OTHERS THEN
5272:
5273: IF PG_DEBUG in ('Y', 'C') THEN
5274: arp_util.debug('Create_Apply_On_Acc: ' || 'Exception:'|| SQLERRM);
5275: END IF;
5276:
5277: x_return_status := FND_API.G_RET_STS_ERROR ;
5278: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
5391: END;
5392: EXCEPTION
5393: WHEN others THEN
5394: IF PG_DEBUG in ('Y', 'C') THEN
5395: arp_util.debug('Apply: ' || 'EXCEPTION: reverse_cover()');
5396: END IF;
5397: raise;
5398: END reverse_cover;
5399:
5491: x_return_status := FND_API.G_RET_STS_SUCCESS;
5492:
5493:
5494: IF PG_DEBUG in ('Y', 'C') THEN
5495: arp_util.debug('Apply: ' || 'Reverse()+ ');
5496: END IF;
5497:
5498:
5499: /* SSA change */
5543: l_reversal_reason_code,
5544: l_def_id_return_status
5545: );
5546: IF PG_DEBUG in ('Y', 'C') THEN
5547: arp_util.debug('Apply: ' || 'l_def_id_return_status :'||l_def_id_return_status);
5548: END IF;
5549: /*---------------------+
5550: | |
5551: | DEFAULTING |
5576: l_reversal_date,
5577: l_val_return_status
5578: );
5579: IF PG_DEBUG in ('Y', 'C') THEN
5580: arp_util.debug('Apply: ' || 'l_val_return_status :'||l_val_return_status);
5581: END IF;
5582:
5583: --Check if the reversal is possible.
5584:
5591: );
5592:
5593: IF l_std_reversal_possible <> 'Y' THEN
5594: IF PG_DEBUG in ('Y', 'C') THEN
5595: arp_util.debug('Apply: ' || 'Standard reversal not possible for this receipt');
5596: END IF;
5597: FND_MESSAGE.SET_NAME('AR','AR_RAPI_NON_REVERSIBLE');
5598: FND_MSG_PUB.Add;
5599: l_rev_return_status := FND_API.G_RET_STS_ERROR;
5623: 'AR_CASH_RECEIPTS',
5624: l_dflex_val_return_status
5625: );
5626: IF PG_DEBUG in ('Y', 'C') THEN
5627: arp_util.debug('Apply: ' || 'l_dflex_val_return_status :'||l_dflex_val_return_status);
5628: END IF;
5629:
5630:
5631: /* Bug fix 3539008 */
5645: );
5646: END IF;
5647: END IF;
5648: IF PG_DEBUG in ('Y', 'C') THEN
5649: arp_util.debug( 'l_dflex_def_return_status :'||l_dflex_def_return_status);
5650: arp_util.debug( 'l_dflex_val1_return_status :'||l_dflex_val1_return_status);
5651: END IF;
5652:
5653: jg_ar_cash_receipts.reverse(
5646: END IF;
5647: END IF;
5648: IF PG_DEBUG in ('Y', 'C') THEN
5649: arp_util.debug( 'l_dflex_def_return_status :'||l_dflex_def_return_status);
5650: arp_util.debug( 'l_dflex_val1_return_status :'||l_dflex_val1_return_status);
5651: END IF;
5652:
5653: jg_ar_cash_receipts.reverse(
5654: l_cash_receipt_id,
5654: l_cash_receipt_id,
5655: l_glob_return_status);
5656:
5657: IF PG_DEBUG in ('Y', 'C') THEN
5658: arp_util.debug('Apply: ' || 'l_glob_return_status :'||l_glob_return_status);
5659: END IF;
5660: END IF;
5661:
5662: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
5681: p_data => x_msg_data
5682: );
5683:
5684: IF PG_DEBUG in ('Y', 'C') THEN
5685: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
5686: END IF;
5687: Return;
5688: END IF;
5689:
5829: p_data => x_msg_data
5830: );
5831:
5832: IF PG_DEBUG in ('Y', 'C') THEN
5833: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
5834: END IF;
5835: Return;
5836: ELSE
5837: --Bug 1847350: Added the check on p_commit and then the commit.
5842:
5843: IF FND_API.To_Boolean( p_commit )
5844: THEN
5845: IF PG_DEBUG in ('Y', 'C') THEN
5846: arp_util.debug('Apply: ' || 'committing');
5847: END IF;
5848: Commit;
5849: END IF;
5850:
5855: EXCEPTION
5856: WHEN FND_API.G_EXC_ERROR THEN
5857:
5858: IF PG_DEBUG in ('Y', 'C') THEN
5859: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
5860: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
5861: END IF;
5862:
5863: ROLLBACK TO Reverse_PVT;
5856: WHEN FND_API.G_EXC_ERROR THEN
5857:
5858: IF PG_DEBUG in ('Y', 'C') THEN
5859: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
5860: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
5861: END IF;
5862:
5863: ROLLBACK TO Reverse_PVT;
5864: x_return_status := FND_API.G_RET_STS_ERROR ;
5871:
5872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5873:
5874: IF PG_DEBUG in ('Y', 'C') THEN
5875: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
5876: END IF;
5877: ROLLBACK TO Reverse_PVT;
5878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5879:
5918: FND_MSG_PUB.Add;
5919: END IF;
5920:
5921: IF PG_DEBUG in ('Y', 'C') THEN
5922: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
5923: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
5924: END IF;
5925:
5926: ROLLBACK TO Reverse_PVT;
5919: END IF;
5920:
5921: IF PG_DEBUG in ('Y', 'C') THEN
5922: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
5923: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
5924: END IF;
5925:
5926: ROLLBACK TO Reverse_PVT;
5927:
6022: FND_MSG_PUB.initialize;
6023: END IF;
6024:
6025: IF PG_DEBUG in ('Y', 'C') THEN
6026: arp_util.debug('Apply_on_account()+ ');
6027: END IF;
6028: /*-----------------------------------------+
6029: | Initialize return status to SUCCESS |
6030: +-----------------------------------------*/
6074: l_id_conv_return_status
6075: );
6076:
6077: IF PG_DEBUG in ('Y', 'C') THEN
6078: arp_util.debug('Apply: ' || 'Defaulting Ids Return_status = '||l_id_conv_return_status);
6079: END IF;
6080: /*---------------------+
6081: | |
6082: | DEFAULTING |
6094: l_apply_date,
6095: l_cr_currency_code,
6096: l_default_return_status
6097: );
6098: arp_util.debug('after ar_receipt_lib_pvt.default_on_ac_app_info');
6099: /*---------------------+
6100: | |
6101: | VALIDATION |
6102: | |
6114: l_validation_return_status,
6115: NULL,
6116: p_called_from
6117: );
6118: arp_util.debug('after ar_receipt_lib_pvt.validate_on_ac_info');
6119:
6120: IF PG_DEBUG in ('Y', 'C') THEN
6121: arp_util.debug('Apply: ' || 'Validation return status :'||l_validation_return_status);
6122: END IF;
6117: );
6118: arp_util.debug('after ar_receipt_lib_pvt.validate_on_ac_info');
6119:
6120: IF PG_DEBUG in ('Y', 'C') THEN
6121: arp_util.debug('Apply: ' || 'Validation return status :'||l_validation_return_status);
6122: END IF;
6123:
6124: --validate and default the flexfields
6125: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
6128: l_dflex_val_return_status
6129: );
6130:
6131: IF PG_DEBUG in ('Y', 'C') THEN
6132: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6133: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6134: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6135: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6136: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6129: );
6130:
6131: IF PG_DEBUG in ('Y', 'C') THEN
6132: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6133: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6134: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6135: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6136: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6137: END IF;
6130:
6131: IF PG_DEBUG in ('Y', 'C') THEN
6132: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6133: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6134: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6135: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6136: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6137: END IF;
6138: END IF;
6131: IF PG_DEBUG in ('Y', 'C') THEN
6132: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6133: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6134: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6135: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6136: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6137: END IF;
6138: END IF;
6139:
6132: arp_util.debug('Apply: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
6133: arp_util.debug('Apply: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
6134: arp_util.debug('Apply: ' || 'l_amount_applied : '||to_char(l_amount_applied));
6135: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
6136: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
6137: END IF;
6138: END IF;
6139:
6140:
6158: p_data => x_msg_data
6159: );
6160:
6161: IF PG_DEBUG in ('Y', 'C') THEN
6162: arp_util.debug('Apply: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
6163: END IF;
6164: Return;
6165: END IF;
6166:
6267:
6268: IF FND_API.To_Boolean( p_commit )
6269: THEN
6270: IF PG_DEBUG in ('Y', 'C') THEN
6271: arp_util.debug('Apply: ' || 'committing');
6272: END IF;
6273: Commit;
6274: END IF;
6275: IF PG_DEBUG in ('Y', 'C') THEN
6272: END IF;
6273: Commit;
6274: END IF;
6275: IF PG_DEBUG in ('Y', 'C') THEN
6276: arp_util.debug('Apply_on_account ()- ');
6277: END IF;
6278: EXCEPTION
6279: WHEN FND_API.G_EXC_ERROR THEN
6280:
6278: EXCEPTION
6279: WHEN FND_API.G_EXC_ERROR THEN
6280:
6281: IF PG_DEBUG in ('Y', 'C') THEN
6282: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6283: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6284: END IF;
6285:
6286: ROLLBACK TO Apply_on_ac_PVT;
6279: WHEN FND_API.G_EXC_ERROR THEN
6280:
6281: IF PG_DEBUG in ('Y', 'C') THEN
6282: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6283: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6284: END IF;
6285:
6286: ROLLBACK TO Apply_on_ac_PVT;
6287: x_return_status := FND_API.G_RET_STS_ERROR ;
6295:
6296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6297:
6298: IF PG_DEBUG in ('Y', 'C') THEN
6299: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6300: END IF;
6301: ROLLBACK TO Apply_on_ac_PVT;
6302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6303:
6345: FND_MSG_PUB.Add;
6346: END IF;
6347:
6348: IF PG_DEBUG in ('Y', 'C') THEN
6349: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6350: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6351: END IF;
6352:
6353: ROLLBACK TO Apply_on_ac_PVT;
6346: END IF;
6347:
6348: IF PG_DEBUG in ('Y', 'C') THEN
6349: arp_util.debug('Apply: ' || SQLCODE, G_MSG_ERROR);
6350: arp_util.debug('Apply: ' || SQLERRM, G_MSG_ERROR);
6351: END IF;
6352:
6353: ROLLBACK TO Apply_on_ac_PVT;
6354:
6427: FND_MSG_PUB.initialize;
6428: END IF;
6429:
6430: IF PG_DEBUG in ('Y', 'C') THEN
6431: arp_util.debug('Unapply_on_account: ' || 'ar_receipt_api.Unapply_on_ac()+ ');
6432: END IF;
6433: /*-----------------------------------------+
6434: | Initialize return status to SUCCESS |
6435: +-----------------------------------------*/
6493: l_cr_unapp_amt, /* Bug fix 3569640 */
6494: l_val_return_status);
6495:
6496: IF PG_DEBUG in ('Y', 'C') THEN
6497: arp_util.debug('Unapply_on_account: ' || 'validation return status :'||l_val_return_status);
6498: END IF;
6499: END IF;
6500:
6501: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
6515: p_data => x_msg_data
6516: );
6517:
6518: IF PG_DEBUG in ('Y', 'C') THEN
6519: arp_util.debug('Unapply_on_account: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
6520: END IF;
6521: Return;
6522: END IF;
6523:
6521: Return;
6522: END IF;
6523:
6524: IF PG_DEBUG in ('Y', 'C') THEN
6525: arp_util.debug('Unapply_on_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6526: arp_util.debug('Unapply_on_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6527: arp_util.debug('Unapply_on_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6528: END IF;
6529:
6522: END IF;
6523:
6524: IF PG_DEBUG in ('Y', 'C') THEN
6525: arp_util.debug('Unapply_on_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6526: arp_util.debug('Unapply_on_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6527: arp_util.debug('Unapply_on_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6528: END IF;
6529:
6530: --lock the receipt before calling the entity handler
6523:
6524: IF PG_DEBUG in ('Y', 'C') THEN
6525: arp_util.debug('Unapply_on_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6526: arp_util.debug('Unapply_on_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6527: arp_util.debug('Unapply_on_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6528: END IF;
6529:
6530: --lock the receipt before calling the entity handler
6531: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
6575:
6576: IF FND_API.To_Boolean( p_commit )
6577: THEN
6578: IF PG_DEBUG in ('Y', 'C') THEN
6579: arp_util.debug('Unapply_on_account: ' || 'committing');
6580: END IF;
6581: Commit;
6582: END IF;
6583:
6581: Commit;
6582: END IF;
6583:
6584: IF PG_DEBUG in ('Y', 'C') THEN
6585: arp_util.debug('Unapply_on_account: ' || 'ar_receipt_api.Unapply_on_ac ()- ');
6586: END IF;
6587:
6588:
6589: EXCEPTION
6589: EXCEPTION
6590: WHEN FND_API.G_EXC_ERROR THEN
6591:
6592: IF PG_DEBUG in ('Y', 'C') THEN
6593: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6594: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6595: END IF;
6596:
6597: ROLLBACK TO Unapply_on_ac_PVT;
6590: WHEN FND_API.G_EXC_ERROR THEN
6591:
6592: IF PG_DEBUG in ('Y', 'C') THEN
6593: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6594: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6595: END IF;
6596:
6597: ROLLBACK TO Unapply_on_ac_PVT;
6598: x_return_status := FND_API.G_RET_STS_ERROR ;
6606:
6607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6608:
6609: IF PG_DEBUG in ('Y', 'C') THEN
6610: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6611: END IF;
6612: ROLLBACK TO Unapply_on_ac_PVT;
6613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6614:
6653: FND_MSG_PUB.Add;
6654: END IF;
6655:
6656: IF PG_DEBUG in ('Y', 'C') THEN
6657: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6658: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6659: END IF;
6660:
6661: ROLLBACK TO Unapply_on_ac_PVT;
6654: END IF;
6655:
6656: IF PG_DEBUG in ('Y', 'C') THEN
6657: arp_util.debug('Unapply_on_account: ' || SQLCODE, G_MSG_ERROR);
6658: arp_util.debug('Unapply_on_account: ' || SQLERRM, G_MSG_ERROR);
6659: END IF;
6660:
6661: ROLLBACK TO Unapply_on_ac_PVT;
6662:
6745: FND_MSG_PUB.initialize;
6746: END IF;
6747:
6748: IF PG_DEBUG in ('Y', 'C') THEN
6749: arp_util.debug('ar_receipt_api.Unapply_other_account()+ ');
6750: END IF;
6751: /*-----------------------------------------+
6752: | Initialize return status to SUCCESS |
6753: +-----------------------------------------*/
6864: END IF;
6865: END IF;
6866:
6867: IF PG_DEBUG in ('Y', 'C') THEN
6868: arp_util.debug('Unapply_other_account: ' || 'validation return status :'||l_val_return_status);
6869: END IF;
6870: END IF;
6871:
6872: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
6887: p_data => x_msg_data
6888: );
6889:
6890: IF PG_DEBUG in ('Y', 'C') THEN
6891: arp_util.debug('Unapply_other_account: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
6892: END IF;
6893: Return;
6894: END IF;
6895:
6893: Return;
6894: END IF;
6895:
6896: IF PG_DEBUG in ('Y', 'C') THEN
6897: arp_util.debug('Unapply_other_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6898: arp_util.debug('Unapply_other_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6899: arp_util.debug('Unapply_other_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6900: END IF;
6901:
6894: END IF;
6895:
6896: IF PG_DEBUG in ('Y', 'C') THEN
6897: arp_util.debug('Unapply_other_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6898: arp_util.debug('Unapply_other_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6899: arp_util.debug('Unapply_other_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6900: END IF;
6901:
6902: --lock the receipt before calling the entity handler
6895:
6896: IF PG_DEBUG in ('Y', 'C') THEN
6897: arp_util.debug('Unapply_other_account: ' || '*******DUMP THE INPUT PARAMETERS ********');
6898: arp_util.debug('Unapply_other_account: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
6899: arp_util.debug('Unapply_other_account: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
6900: END IF;
6901:
6902: --lock the receipt before calling the entity handler
6903: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
6947:
6948: IF FND_API.To_Boolean( p_commit )
6949: THEN
6950: IF PG_DEBUG in ('Y', 'C') THEN
6951: arp_util.debug('Unapply_other_account: ' || 'committing');
6952: END IF;
6953: Commit;
6954: END IF;
6955:
6953: Commit;
6954: END IF;
6955:
6956: IF PG_DEBUG in ('Y', 'C') THEN
6957: arp_util.debug('ar_receipt_api.Unapply_other_account ()- ');
6958: END IF;
6959:
6960:
6961: EXCEPTION
6961: EXCEPTION
6962: WHEN FND_API.G_EXC_ERROR THEN
6963:
6964: IF PG_DEBUG in ('Y', 'C') THEN
6965: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
6966: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
6967: END IF;
6968:
6969: ROLLBACK TO Unapply_other_ac_PVT;
6962: WHEN FND_API.G_EXC_ERROR THEN
6963:
6964: IF PG_DEBUG in ('Y', 'C') THEN
6965: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
6966: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
6967: END IF;
6968:
6969: ROLLBACK TO Unapply_other_ac_PVT;
6970: x_return_status := FND_API.G_RET_STS_ERROR ;
6978:
6979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6980:
6981: IF PG_DEBUG in ('Y', 'C') THEN
6982: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
6983: END IF;
6984: ROLLBACK TO Unapply_other_ac_PVT;
6985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6986:
7025: FND_MSG_PUB.Add;
7026: END IF;
7027:
7028: IF PG_DEBUG in ('Y', 'C') THEN
7029: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
7030: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7031: END IF;
7032:
7033: ROLLBACK TO Unapply_other_ac_PVT;
7026: END IF;
7027:
7028: IF PG_DEBUG in ('Y', 'C') THEN
7029: arp_util.debug('Unapply_other_account: ' || SQLCODE, G_MSG_ERROR);
7030: arp_util.debug('Unapply_other_account: ' || SQLERRM, G_MSG_ERROR);
7031: END IF;
7032:
7033: ROLLBACK TO Unapply_other_ac_PVT;
7034:
7187: FND_MSG_PUB.initialize;
7188: END IF;
7189:
7190: IF PG_DEBUG in ('Y', 'C') THEN
7191: arp_util.debug('Activity_application()+ ');
7192: END IF;
7193: /*-----------------------------------------+
7194: | Initialize return status to SUCCESS |
7195: +-----------------------------------------*/
7245: l_id_conv_return_status
7246: );
7247:
7248: IF PG_DEBUG in ('Y', 'C') THEN
7249: arp_util.debug('Activity_application: ' || 'Default_cash_receipt_i return status :'||l_default_return_status);
7250: END IF;
7251:
7252: /*---------------------+
7253: | |
7316:
7317: END IF;
7318:
7319: IF PG_DEBUG in ('Y', 'C') THEN
7320: arp_util.debug('Activity_application: ' || 'Default_on_ac_app_info return status :'||l_default_return_status);
7321: arp_util.debug('Activity_application: ' || 'Default_refund_attributes return status :'||l_dft_ref_return_status);
7322: END IF;
7323: /*---------------------+
7324: | |
7317: END IF;
7318:
7319: IF PG_DEBUG in ('Y', 'C') THEN
7320: arp_util.debug('Activity_application: ' || 'Default_on_ac_app_info return status :'||l_default_return_status);
7321: arp_util.debug('Activity_application: ' || 'Default_refund_attributes return status :'||l_dft_ref_return_status);
7322: END IF;
7323: /*---------------------+
7324: | |
7325: | VALIDATION |
7344: p_called_from
7345: );
7346:
7347: IF PG_DEBUG in ('Y', 'C') THEN
7348: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7349: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7350: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7351: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7352: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7345: );
7346:
7347: IF PG_DEBUG in ('Y', 'C') THEN
7348: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7349: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7350: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7351: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7352: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7353: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7346:
7347: IF PG_DEBUG in ('Y', 'C') THEN
7348: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7349: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7350: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7351: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7352: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7353: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7354: END IF;
7347: IF PG_DEBUG in ('Y', 'C') THEN
7348: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7349: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7350: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7351: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7352: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7353: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7354: END IF;
7355: END IF;
7348: arp_util.debug('Activity_application: ' || 'Validation return status :'||l_validation_return_status);
7349: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7350: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7351: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7352: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7353: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7354: END IF;
7355: END IF;
7356:
7349: arp_util.debug('Activity_application: ' || '*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
7350: arp_util.debug('Activity_application: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
7351: arp_util.debug('Activity_application: ' || 'l_amount_applied : '||to_char(l_amount_applied));
7352: arp_util.debug('Activity_application: ' || 'l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
7353: arp_util.debug('Activity_application: ' || 'l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
7354: END IF;
7355: END IF;
7356:
7357: IF l_validation_return_status <> FND_API.G_RET_STS_SUCCESS OR
7359: l_dft_ref_return_status <> FND_API.G_RET_STS_SUCCESS OR
7360: l_id_conv_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7361:
7362: IF PG_DEBUG in ('Y', 'C') THEN
7363: arp_util.debug('Activity_application: ' || 'Validation FAILED ');
7364: END IF;
7365: x_return_status := FND_API.G_RET_STS_ERROR;
7366: END IF;
7367:
7377: p_data => x_msg_data
7378: );
7379:
7380: IF PG_DEBUG in ('Y', 'C') THEN
7381: arp_util.debug('Activity_application: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
7382: END IF;
7383: Return;
7384: END IF;
7385:
7557:
7558: IF FND_API.To_Boolean( p_commit )
7559: THEN
7560: IF PG_DEBUG in ('Y', 'C') THEN
7561: arp_util.debug('Activity_application: ' || 'committing');
7562: END IF;
7563: Commit;
7564: END IF;
7565: IF PG_DEBUG in ('Y', 'C') THEN
7562: END IF;
7563: Commit;
7564: END IF;
7565: IF PG_DEBUG in ('Y', 'C') THEN
7566: arp_util.debug('Activity_application ()- ');
7567: END IF;
7568: EXCEPTION
7569: WHEN FND_API.G_EXC_ERROR THEN
7570:
7568: EXCEPTION
7569: WHEN FND_API.G_EXC_ERROR THEN
7570:
7571: IF PG_DEBUG in ('Y', 'C') THEN
7572: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
7573: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7574: END IF;
7575:
7576: ROLLBACK TO Activity_app_PVT;
7569: WHEN FND_API.G_EXC_ERROR THEN
7570:
7571: IF PG_DEBUG in ('Y', 'C') THEN
7572: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
7573: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7574: END IF;
7575:
7576: ROLLBACK TO Activity_app_PVT;
7577: x_return_status := FND_API.G_RET_STS_ERROR ;
7585:
7586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7587:
7588: IF PG_DEBUG in ('Y', 'C') THEN
7589: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7590: END IF;
7591: ROLLBACK TO Activity_app_PVT;
7592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7593:
7636: FND_MSG_PUB.Add;
7637: END IF;
7638:
7639: IF PG_DEBUG in ('Y', 'C') THEN
7640: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
7641: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7642: END IF;
7643:
7644: ROLLBACK TO Activity_app_PVT;
7637: END IF;
7638:
7639: IF PG_DEBUG in ('Y', 'C') THEN
7640: arp_util.debug('Activity_application: ' || SQLCODE, G_MSG_ERROR);
7641: arp_util.debug('Activity_application: ' || SQLERRM, G_MSG_ERROR);
7642: END IF;
7643:
7644: ROLLBACK TO Activity_app_PVT;
7645:
7722: FND_MSG_PUB.initialize;
7723: END IF;
7724:
7725: IF PG_DEBUG in ('Y', 'C') THEN
7726: arp_util.debug('ar_receipt_api.activity_unapplication()+ ');
7727: END IF;
7728: /*-----------------------------------------+
7729: | Initialize return status to SUCCESS |
7730: +-----------------------------------------*/
7798: l_cr_unapp_amt, /* Bug fix 3569640 */
7799: l_val_return_status);
7800:
7801: IF PG_DEBUG in ('Y', 'C') THEN
7802: arp_util.debug('Activity_Unapplication: ' || 'validation return status :'||l_val_return_status);
7803: END IF;
7804: END IF;
7805:
7806: /* Refunds - check for refund and cancel if refund application */
7837: p_data => x_msg_data
7838: );
7839:
7840: IF PG_DEBUG in ('Y', 'C') THEN
7841: arp_util.debug('Activity_Unapplication: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
7842: END IF;
7843: Return;
7844: END IF;
7845:
7843: Return;
7844: END IF;
7845:
7846: IF PG_DEBUG in ('Y', 'C') THEN
7847: arp_util.debug('Activity_Unapplication: ' || '*******DUMP THE INPUT PARAMETERS ********');
7848: arp_util.debug('Activity_Unapplication: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
7849: arp_util.debug('Activity_Unapplication: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
7850: END IF;
7851:
7844: END IF;
7845:
7846: IF PG_DEBUG in ('Y', 'C') THEN
7847: arp_util.debug('Activity_Unapplication: ' || '*******DUMP THE INPUT PARAMETERS ********');
7848: arp_util.debug('Activity_Unapplication: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
7849: arp_util.debug('Activity_Unapplication: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
7850: END IF;
7851:
7852: --lock the receipt before calling the entity handler
7845:
7846: IF PG_DEBUG in ('Y', 'C') THEN
7847: arp_util.debug('Activity_Unapplication: ' || '*******DUMP THE INPUT PARAMETERS ********');
7848: arp_util.debug('Activity_Unapplication: ' || 'l_receivable_application_id :'||to_char(l_receivable_application_id));
7849: arp_util.debug('Activity_Unapplication: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
7850: END IF;
7851:
7852: --lock the receipt before calling the entity handler
7853: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
7897:
7898: IF FND_API.To_Boolean( p_commit )
7899: THEN
7900: IF PG_DEBUG in ('Y', 'C') THEN
7901: arp_util.debug('Activity_Unapplication: ' || 'committing');
7902: END IF;
7903: Commit;
7904: END IF;
7905:
7903: Commit;
7904: END IF;
7905:
7906: IF PG_DEBUG in ('Y', 'C') THEN
7907: arp_util.debug('ar_receipt_api.Activity_unapplication()- ');
7908: END IF;
7909:
7910:
7911: EXCEPTION
7911: EXCEPTION
7912: WHEN FND_API.G_EXC_ERROR THEN
7913:
7914: IF PG_DEBUG in ('Y', 'C') THEN
7915: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
7916: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
7917: END IF;
7918:
7919: ROLLBACK TO Activity_unapplication_PVT;
7912: WHEN FND_API.G_EXC_ERROR THEN
7913:
7914: IF PG_DEBUG in ('Y', 'C') THEN
7915: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
7916: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
7917: END IF;
7918:
7919: ROLLBACK TO Activity_unapplication_PVT;
7920: x_return_status := FND_API.G_RET_STS_ERROR ;
7928:
7929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7930:
7931: IF PG_DEBUG in ('Y', 'C') THEN
7932: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
7933: END IF;
7934: ROLLBACK TO Activity_unapplication_PVT;
7935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7936:
7975: FND_MSG_PUB.Add;
7976: END IF;
7977:
7978: IF PG_DEBUG in ('Y', 'C') THEN
7979: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
7980: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
7981: END IF;
7982:
7983: ROLLBACK TO Activity_unapplication_PVT;
7976: END IF;
7977:
7978: IF PG_DEBUG in ('Y', 'C') THEN
7979: arp_util.debug('Activity_Unapplication: ' || SQLCODE, G_MSG_ERROR);
7980: arp_util.debug('Activity_Unapplication: ' || SQLERRM, G_MSG_ERROR);
7981: END IF;
7982:
7983: ROLLBACK TO Activity_unapplication_PVT;
7984:
8091: THEN
8092: FND_MSG_PUB.initialize;
8093: END IF;
8094:
8095: arp_util.debug('Apply_other_account()+ ');
8096: /*-----------------------------------------+
8097: | Initialize return status to SUCCESS |
8098: +-----------------------------------------*/
8099:
8140: p_receipt_number ,
8141: l_id_conv_return_status
8142: );
8143:
8144: arp_util.debug('Defaulting Ids Return_status = '||l_id_conv_return_status);
8145: /*---------------------+
8146: | |
8147: | DEFAULTING |
8148: | |
8160: l_cr_currency_code,
8161: l_default_return_status
8162: );
8163:
8164: arp_util.debug('Default_on_ac_app_info return status = '||l_default_return_status);
8165: /*---------------------+
8166: | |
8167: | VALIDATION |
8168: | |
8185: l_validation_return_status,
8186: p_called_from);
8187:
8188:
8189: arp_util.debug('Validation return status :'||l_validation_return_status);
8190:
8191: --Validate application reference details passed.
8192: ar_receipt_val_pvt.validate_application_ref(
8193: l_applied_payment_schedule_id,
8203: p_application_ref_reason,
8204: l_app_validation_return_status
8205: );
8206:
8207: arp_util.debug('Application ref Validation return status :'||l_app_validation_return_status);
8208:
8209:
8210: --validate and default the flexfields
8211: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
8212: l_attribute_rec,
8213: 'AR_RECEIVABLE_APPLICATIONS',
8214: l_dflex_val_return_status
8215: );
8216: arp_util.debug('Desc flexfield Validation return status :'||l_dflex_val_return_status);
8217:
8218: --default and validate the global descriptive flexfield
8219: jg_ar_receivable_applications.apply(
8220: p_apply_before_after => 'BEFORE',
8249: p_global_attribute19 => l_global_attribute_rec.global_attribute19,
8250: p_global_attribute20 => l_global_attribute_rec.global_attribute20,
8251: p_return_status => l_gdflex_return_status);
8252:
8253: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8254: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8255: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8256: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8257: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8250: p_global_attribute20 => l_global_attribute_rec.global_attribute20,
8251: p_return_status => l_gdflex_return_status);
8252:
8253: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8254: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8255: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8256: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8257: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8258: END IF;
8251: p_return_status => l_gdflex_return_status);
8252:
8253: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8254: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8255: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8256: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8257: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8258: END IF;
8259:
8252:
8253: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8254: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8255: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8256: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8257: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8258: END IF;
8259:
8260:
8253: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
8254: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
8255: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
8256: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
8257: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
8258: END IF;
8259:
8260:
8261: IF l_validation_return_status <> FND_API.G_RET_STS_SUCCESS OR
8279: p_count => x_msg_count,
8280: p_data => x_msg_data
8281: );
8282:
8283: arp_util.debug('Error(s) occurred. Rolling back and setting status to ERROR');
8284: Return;
8285: END IF;
8286:
8287: --lock the receipt before calling the entity handler
8363:
8364: p_application_ref_id := l_temp_ref_id;
8365: p_application_ref_num := l_temp_ref_num;
8366:
8367: arp_util.debug('Application ID :'||to_char(ln_rec_application_id));
8368: p_receivable_application_id := ln_rec_application_id;
8369: arp_util.debug('Other Accounting Application return status :'||x_return_status);
8370: EXCEPTION
8371: WHEN OTHERS THEN
8365: p_application_ref_num := l_temp_ref_num;
8366:
8367: arp_util.debug('Application ID :'||to_char(ln_rec_application_id));
8368: p_receivable_application_id := ln_rec_application_id;
8369: arp_util.debug('Other Accounting Application return status :'||x_return_status);
8370: EXCEPTION
8371: WHEN OTHERS THEN
8372:
8373: /*-------------------------------------------------------+
8401: +--------------------------------*/
8402:
8403: IF FND_API.To_Boolean( p_commit )
8404: THEN
8405: arp_util.debug('committing');
8406: Commit;
8407: END IF;
8408: arp_util.debug('Apply_other_account ()- ');
8409: EXCEPTION
8404: THEN
8405: arp_util.debug('committing');
8406: Commit;
8407: END IF;
8408: arp_util.debug('Apply_other_account ()- ');
8409: EXCEPTION
8410: WHEN FND_API.G_EXC_ERROR THEN
8411:
8412: arp_util.debug(SQLCODE, G_MSG_ERROR);
8408: arp_util.debug('Apply_other_account ()- ');
8409: EXCEPTION
8410: WHEN FND_API.G_EXC_ERROR THEN
8411:
8412: arp_util.debug(SQLCODE, G_MSG_ERROR);
8413: arp_util.debug(SQLERRM, G_MSG_ERROR);
8414:
8415: ROLLBACK TO Apply_other_ac_PVT;
8416: x_return_status := FND_API.G_RET_STS_ERROR ;
8409: EXCEPTION
8410: WHEN FND_API.G_EXC_ERROR THEN
8411:
8412: arp_util.debug(SQLCODE, G_MSG_ERROR);
8413: arp_util.debug(SQLERRM, G_MSG_ERROR);
8414:
8415: ROLLBACK TO Apply_other_ac_PVT;
8416: x_return_status := FND_API.G_RET_STS_ERROR ;
8417:
8423: );
8424:
8425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8426:
8427: arp_util.debug(SQLERRM, G_MSG_ERROR);
8428: ROLLBACK TO Apply_other_ac_PVT;
8429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8430:
8431: -- Display_Parameters;
8471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','APPLY_OTHER_ACCOUNT : '||SQLERRM);
8472: FND_MSG_PUB.Add;
8473: END IF;
8474:
8475: arp_util.debug(SQLCODE, G_MSG_ERROR);
8476: arp_util.debug(SQLERRM, G_MSG_ERROR);
8477:
8478: ROLLBACK TO Apply_other_ac_PVT;
8479:
8472: FND_MSG_PUB.Add;
8473: END IF;
8474:
8475: arp_util.debug(SQLCODE, G_MSG_ERROR);
8476: arp_util.debug(SQLERRM, G_MSG_ERROR);
8477:
8478: ROLLBACK TO Apply_other_ac_PVT;
8479:
8480: IF FND_MSG_PUB.Check_Msg_Level
8644: FND_MSG_PUB.initialize;
8645: END IF;
8646:
8647: IF PG_DEBUG in ('Y', 'C') THEN
8648: arp_util.debug('ar_receipt_api.create_misc()+ ');
8649: END IF;
8650: /*-----------------------------------------+
8651: | Initialize return status to SUCCESS |
8652: +-----------------------------------------*/
8804: l_creation_method := 'M';
8805: END IF;
8806:
8807: IF PG_DEBUG in ('Y', 'C') THEN
8808: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
8809: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8805: END IF;
8806:
8807: IF PG_DEBUG in ('Y', 'C') THEN
8808: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
8809: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8806:
8807: IF PG_DEBUG in ('Y', 'C') THEN
8808: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
8809: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8814: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
8807: IF PG_DEBUG in ('Y', 'C') THEN
8808: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
8809: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8814: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
8815: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
8808: arp_util.debug('create_misc: l_misc_def_return_status = ' || l_misc_def_return_status);
8809: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8814: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
8815: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
8816: END IF;
8809: arp_util.debug('create_misc: l_val_return_status = ' || l_val_return_status);
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8814: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
8815: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
8816: END IF;
8817: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8810: arp_util.debug('create_misc: l_def_misc_id_return_status = ' || l_def_misc_id_return_status);
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8814: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
8815: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
8816: END IF;
8817: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8818:
8811: arp_util.debug('create_misc: l_dflex_val_return_status = ' || l_dflex_val_return_status);
8812: arp_util.debug('create_misc: l_creation_method = ' || l_creation_method );
8813: arp_util.debug('create_misc: arp_global.set_of_books_id = ' || arp_global.set_of_books_id );
8814: arp_util.debug('create_misc: l_receipt_date = ' || l_receipt_date );
8815: arp_util.debug('create_misc: x_return_status = ' || x_return_status );
8816: END IF;
8817: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8818:
8819: ar_receipt_lib_pvt.get_doc_seq(
8842: FND_MSG_PUB.Add;
8843: END IF;
8844: ELSE
8845: IF PG_DEBUG in ('Y', 'C') THEN
8846: arp_util.debug('create_misc: ' || 'Receipt Number is null ');
8847: END IF;
8848: --raise error message
8849: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NUM_NULL');
8850: FND_MSG_PUB.Add;
8871: p_count => x_msg_count,
8872: p_data => x_msg_data);
8873:
8874: IF PG_DEBUG in ('Y', 'C') THEN
8875: arp_util.debug('create_misc: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
8876: END IF;
8877: Return;
8878: END IF;
8879: IF PG_DEBUG in ('Y', 'C') THEN
8876: END IF;
8877: Return;
8878: END IF;
8879: IF PG_DEBUG in ('Y', 'C') THEN
8880: arp_util.debug('create_misc: ' || 'x_return_status '||x_return_status);
8881: END IF;
8882:
8883: /* Bug fix 2300268
8884: Get the tax account id corresponding to the vat_tax_id */
8903: /*-------------------------------+
8904: | Call to the Entity Handler |
8905: +-------------------------------*/
8906: IF PG_DEBUG in ('Y', 'C') THEN
8907: arp_util.debug('create_misc: ' || ' orig payment_trxn_extension_id '||l_payment_trxn_extension_id);
8908: END IF;
8909: /* bichatte payment uptake copy extn start */
8910:
8911: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
8909: /* bichatte payment uptake copy extn start */
8910:
8911: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
8912:
8913: arp_util.debug('Create_cash_122: ' || l_creation_method);
8914: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
8915: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
8916: FND_MSG_PUB.Add;
8917: x_return_status := FND_API.G_RET_STS_ERROR;
8910:
8911: IF ( l_creation_method = 'A' and l_payment_trxn_extension_id is NULL) THEN
8912:
8913: arp_util.debug('Create_cash_122: ' || l_creation_method);
8914: arp_util.debug('Create_cash_122: ' || l_payment_trxn_extension_id );
8915: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
8916: FND_MSG_PUB.Add;
8917: x_return_status := FND_API.G_RET_STS_ERROR;
8918: END IF;
8927: --Bug : 6855895
8928: where cash_receipt_id = l_reference_id;
8929:
8930: IF PG_DEBUG in ('Y','C') THEN
8931: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
8932: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
8933: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
8934: arp_util.debug ( 'the value of org_id '|| l_org_id);
8935: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
8928: where cash_receipt_id = l_reference_id;
8929:
8930: IF PG_DEBUG in ('Y','C') THEN
8931: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
8932: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
8933: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
8934: arp_util.debug ( 'the value of org_id '|| l_org_id);
8935: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
8936: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
8929:
8930: IF PG_DEBUG in ('Y','C') THEN
8931: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
8932: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
8933: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
8934: arp_util.debug ( 'the value of org_id '|| l_org_id);
8935: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
8936: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
8937: END IF;
8930: IF PG_DEBUG in ('Y','C') THEN
8931: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
8932: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
8933: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
8934: arp_util.debug ( 'the value of org_id '|| l_org_id);
8935: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
8936: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
8937: END IF;
8938:
8931: arp_util.debug ( 'the value of pmt_trxn_extn_id '|| l_payment_trxn_extension_id);
8932: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
8933: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
8934: arp_util.debug ( 'the value of org_id '|| l_org_id);
8935: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
8936: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
8937: END IF;
8938:
8939: Copy_payment_extension (
8932: arp_util.debug ( 'the value of customer_id '|| l_customer_id);
8933: arp_util.debug ( 'the value of receipt_met_id '|| l_receipt_method_id);
8934: arp_util.debug ( 'the value of org_id '|| l_org_id);
8935: arp_util.debug ( 'the value of cust_site_use_id '|| l_customer_site_use_id);
8936: arp_util.debug ( 'the value of rec_number '|| l_receipt_number);
8937: END IF;
8938:
8939: Copy_payment_extension (
8940: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
8949: o_payment_trxn_extension_id =>l_copy_pmt_trxn_extension_id
8950: );
8951:
8952: IF l_copy_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8953: arp_util.debug('Create_cash_123: ' );
8954: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
8955: FND_MSG_PUB.Add;
8956: x_return_status := FND_API.G_RET_STS_ERROR;
8957: END IF;
9146:
9147: END;
9148:
9149: IF PG_DEBUG in ('Y', 'C') THEN
9150: arp_util.debug('create_misc: ' || 'Misc Receipt id : '||to_char(p_misc_receipt_id));
9151: END IF;
9152:
9153: /*-------------------------------------------------------+
9154: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
9168:
9169: IF FND_API.To_Boolean( p_commit )
9170: THEN
9171: IF PG_DEBUG in ('Y', 'C') THEN
9172: arp_util.debug('create_misc: ' || 'committing');
9173: END IF;
9174: Commit;
9175: END IF;
9176:
9174: Commit;
9175: END IF;
9176:
9177: IF PG_DEBUG in ('Y', 'C') THEN
9178: arp_util.debug('Create_Misc_Receipt()- ');
9179: END IF;
9180:
9181:
9182:
9186: EXCEPTION
9187: WHEN FND_API.G_EXC_ERROR THEN
9188:
9189: IF PG_DEBUG in ('Y', 'C') THEN
9190: arp_util.debug('create_misc: ' || SQLCODE, G_MSG_ERROR);
9191: arp_util.debug('create_misc: ' || SQLERRM, G_MSG_ERROR);
9192: END IF;
9193:
9194: ROLLBACK TO Create_misc_PVT;
9187: WHEN FND_API.G_EXC_ERROR THEN
9188:
9189: IF PG_DEBUG in ('Y', 'C') THEN
9190: arp_util.debug('create_misc: ' || SQLCODE, G_MSG_ERROR);
9191: arp_util.debug('create_misc: ' || SQLERRM, G_MSG_ERROR);
9192: END IF;
9193:
9194: ROLLBACK TO Create_misc_PVT;
9195: x_return_status := FND_API.G_RET_STS_ERROR ;
9203:
9204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9205:
9206: IF PG_DEBUG in ('Y', 'C') THEN
9207: arp_util.debug('create_misc: ' || SQLERRM, G_MSG_ERROR);
9208: END IF;
9209: ROLLBACK TO Create_misc_PVT;
9210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9211:
9246: FND_MSG_PUB.Add;
9247: END IF;
9248:
9249: IF PG_DEBUG in ('Y', 'C') THEN
9250: arp_util.debug('create_misc: ' || SQLCODE);
9251: arp_util.debug('create_misc: ' || SQLERRM);
9252: END IF;
9253:
9254: ROLLBACK TO Create_misc_PVT;
9247: END IF;
9248:
9249: IF PG_DEBUG in ('Y', 'C') THEN
9250: arp_util.debug('create_misc: ' || SQLCODE);
9251: arp_util.debug('create_misc: ' || SQLERRM);
9252: END IF;
9253:
9254: ROLLBACK TO Create_misc_PVT;
9255:
9422: END IF;
9423:
9424:
9425: IF PG_DEBUG in ('Y', 'C') THEN
9426: arp_util.debug('Apply_Open_Receipt ()+ ');
9427: END IF;
9428: /*-----------------------------------------+
9429: | Initialize return status to SUCCESS |
9430: +-----------------------------------------*/
9498: l_open_cr_customer_id,
9499: l_def_return_status);
9500:
9501: IF PG_DEBUG in ('Y', 'C') THEN
9502: arp_util.debug('Apply_Open_Receipt: ' || 'Defaulting Ids Return_status = '||l_def_return_status);
9503: END IF;
9504: /*---------------------+
9505: | |
9506: | VALIDATION |
9531: , p_called_from => p_called_from -- bug 2897244
9532: , p_return_status => l_val_return_status);
9533:
9534: IF PG_DEBUG in ('Y', 'C') THEN
9535: arp_util.debug('Apply_Open_Receipt: ' || 'Validation Return_status = '||l_val_return_status);
9536: END IF;
9537: END IF;
9538:
9539: --validate and default the flexfields
9542: 'AR_RECEIVABLE_APPLICATIONS',
9543: l_dflex_val_return_status
9544: );
9545:
9546: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9547: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9548: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9549: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9550: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9543: l_dflex_val_return_status
9544: );
9545:
9546: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9547: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9548: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9549: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9550: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9551: END IF;
9544: );
9545:
9546: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9547: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9548: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9549: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9550: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9551: END IF;
9552:
9545:
9546: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9547: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9548: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9549: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9550: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9551: END IF;
9552:
9553:
9546: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9547: arp_util.debug('l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9548: arp_util.debug('l_amount_applied : '||to_char(l_amount_applied));
9549: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9550: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9551: END IF;
9552:
9553:
9554: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
9569: p_data => x_msg_data
9570: );
9571:
9572: IF PG_DEBUG in ('Y', 'C') THEN
9573: arp_util.debug('Apply_Open_Receipt: ' || 'Error(s) occurred. Rolling back and setting status to ERROR');
9574: END IF;
9575: Return;
9576: END IF;
9577:
9576: END IF;
9577:
9578: --Dump the input variables to the entity handler
9579: IF PG_DEBUG in ('Y', 'C') THEN
9580: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9581: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9577:
9578: --Dump the input variables to the entity handler
9579: IF PG_DEBUG in ('Y', 'C') THEN
9580: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9581: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9585: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9578: --Dump the input variables to the entity handler
9579: IF PG_DEBUG in ('Y', 'C') THEN
9580: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9581: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9585: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9586: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9579: IF PG_DEBUG in ('Y', 'C') THEN
9580: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9581: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9585: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9586: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9587: END IF;
9580: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_payment_schedule_id : '||to_char(l_cr_payment_schedule_id));
9581: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9585: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9586: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9587: END IF;
9588:
9581: arp_util.debug('Apply_Open_Receipt: ' || 'l_applied_payment_schedule_id : '||to_char(l_applied_payment_schedule_id));
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9585: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9586: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9587: END IF;
9588:
9589: --lock both receipts before calling the entity handlers
9582: arp_util.debug('Apply_Open_Receipt: ' || 'l_amount_applied : '||to_char(l_amount_applied));
9583: arp_util.debug('Apply_Open_Receipt: ' || 'l_cr_currency : '||l_cr_currency);
9584: arp_util.debug('Apply_Open_Receipt: ' || 'l_open_cr_currency : '||l_open_cr_currency);
9585: arp_util.debug('l_apply_date : '||to_char(l_apply_date,'DD-MON-YY'));
9586: arp_util.debug('l_apply_gl_date : '||to_char(l_apply_gl_date,'DD-MON-YY'));
9587: END IF;
9588:
9589: --lock both receipts before calling the entity handlers
9590: arp_cash_receipts_pkg.nowaitlock_p(p_cr_id => l_cash_receipt_id);
9768: --
9769: -- Setting the applied_rec_app_id on each netting application..
9770: --
9771: IF PG_DEBUG in ('Y', 'C') THEN
9772: arp_util.debug('Apply_Open_Receipt: Updating applications ');
9773: END IF;
9774:
9775: IF (l_net_rec_app_id IS NULL OR l_open_net_rec_app_id IS NULL)
9776: THEN
9774:
9775: IF (l_net_rec_app_id IS NULL OR l_open_net_rec_app_id IS NULL)
9776: THEN
9777: IF PG_DEBUG in ('Y', 'C') THEN
9778: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
9779: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
9780: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
9781: END IF;
9782: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
9775: IF (l_net_rec_app_id IS NULL OR l_open_net_rec_app_id IS NULL)
9776: THEN
9777: IF PG_DEBUG in ('Y', 'C') THEN
9778: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
9779: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
9780: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
9781: END IF;
9782: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
9783: FND_MSG_PUB.Add;
9776: THEN
9777: IF PG_DEBUG in ('Y', 'C') THEN
9778: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLERRM);
9779: arp_util.debug('Apply_Open_Receipt: l_net_rec_app_id = ' || l_net_rec_app_id);
9780: arp_util.debug('Apply_Open_Receipt: l_open_net_rec_app_id = ' || l_open_net_rec_app_id);
9781: END IF;
9782: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
9783: FND_MSG_PUB.Add;
9784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9798:
9799: EXCEPTION
9800: when others THEN
9801: IF PG_DEBUG in ('Y', 'C') THEN
9802: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLCODE, G_MSG_ERROR);
9803: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9804: END IF;
9805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9806: RAISE;
9799: EXCEPTION
9800: when others THEN
9801: IF PG_DEBUG in ('Y', 'C') THEN
9802: arp_util.debug('Apply_Open_Receipt: error updating applications ' || SQLCODE, G_MSG_ERROR);
9803: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9804: END IF;
9805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9806: RAISE;
9807: END;
9832:
9833: IF FND_API.To_Boolean( p_commit )
9834: THEN
9835: IF PG_DEBUG in ('Y', 'C') THEN
9836: arp_util.debug('Apply_Open_Receipt: ' || 'committing');
9837: END IF;
9838: Commit;
9839: END IF;
9840: IF PG_DEBUG in ('Y', 'C') THEN
9837: END IF;
9838: Commit;
9839: END IF;
9840: IF PG_DEBUG in ('Y', 'C') THEN
9841: arp_util.debug('Apply_Open_Receipt()- ');
9842: END IF;
9843: EXCEPTION
9844: WHEN FND_API.G_EXC_ERROR THEN
9845:
9843: EXCEPTION
9844: WHEN FND_API.G_EXC_ERROR THEN
9845:
9846: IF PG_DEBUG in ('Y', 'C') THEN
9847: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
9848: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9849: END IF;
9850:
9851: ROLLBACK TO Apply_Open_Receipt_PVT;
9844: WHEN FND_API.G_EXC_ERROR THEN
9845:
9846: IF PG_DEBUG in ('Y', 'C') THEN
9847: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
9848: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9849: END IF;
9850:
9851: ROLLBACK TO Apply_Open_Receipt_PVT;
9852: x_return_status := FND_API.G_RET_STS_ERROR ;
9860:
9861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9862:
9863: IF PG_DEBUG in ('Y', 'C') THEN
9864: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9865: END IF;
9866: ROLLBACK TO Apply_Open_Receipt_PVT;
9867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9868:
9908: FND_MSG_PUB.Add;
9909: END IF;
9910:
9911: IF PG_DEBUG in ('Y', 'C') THEN
9912: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
9913: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9914: END IF;
9915:
9916: ROLLBACK TO Apply_Open_Receipt_PVT;
9909: END IF;
9910:
9911: IF PG_DEBUG in ('Y', 'C') THEN
9912: arp_util.debug('Apply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
9913: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
9914: END IF;
9915:
9916: ROLLBACK TO Apply_Open_Receipt_PVT;
9917:
9990: FND_MSG_PUB.initialize;
9991: END IF;
9992:
9993: IF PG_DEBUG in ('Y', 'C') THEN
9994: arp_util.debug('Unapply_Open_Receipt: ' || 'ar_receipt_api.Unapply_Open_Receipt()+ ');
9995: END IF;
9996: /*-----------------------------------------+
9997: | Initialize return status to SUCCESS |
9998: +-----------------------------------------*/
10116:
10117: IF FND_API.To_Boolean( p_commit )
10118: THEN
10119: IF PG_DEBUG in ('Y', 'C') THEN
10120: arp_util.debug('Unapply_Open_Receipt: ' || 'committing');
10121: END IF;
10122: Commit;
10123: END IF;
10124: IF PG_DEBUG in ('Y', 'C') THEN
10121: END IF;
10122: Commit;
10123: END IF;
10124: IF PG_DEBUG in ('Y', 'C') THEN
10125: arp_util.debug('Unapply_Open_Receipt()- ');
10126: END IF;
10127: EXCEPTION
10128: WHEN FND_API.G_EXC_ERROR THEN
10129:
10127: EXCEPTION
10128: WHEN FND_API.G_EXC_ERROR THEN
10129:
10130: IF PG_DEBUG in ('Y', 'C') THEN
10131: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10132: arp_util.debug('Unapply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10133: END IF;
10134:
10135: ROLLBACK TO Unapply_Open_Receipt_PVT;
10128: WHEN FND_API.G_EXC_ERROR THEN
10129:
10130: IF PG_DEBUG in ('Y', 'C') THEN
10131: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10132: arp_util.debug('Unapply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10133: END IF;
10134:
10135: ROLLBACK TO Unapply_Open_Receipt_PVT;
10136: x_return_status := FND_API.G_RET_STS_ERROR ;
10144:
10145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10146:
10147: IF PG_DEBUG in ('Y', 'C') THEN
10148: arp_util.debug('Unapply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10149: END IF;
10150: ROLLBACK TO Unapply_Open_Receipt_PVT;
10151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10152:
10192: FND_MSG_PUB.Add;
10193: END IF;
10194:
10195: IF PG_DEBUG in ('Y', 'C') THEN
10196: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10197: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10198: END IF;
10199:
10200: ROLLBACK TO Unapply_Open_Receipt_PVT;
10193: END IF;
10194:
10195: IF PG_DEBUG in ('Y', 'C') THEN
10196: arp_util.debug('Unapply_Open_Receipt: ' || SQLCODE, G_MSG_ERROR);
10197: arp_util.debug('Apply_Open_Receipt: ' || SQLERRM, G_MSG_ERROR);
10198: END IF;
10199:
10200: ROLLBACK TO Unapply_Open_Receipt_PVT;
10201:
10216: END Unapply_Open_Receipt;
10217:
10218:
10219: BEGIN
10220: arp_util.debug('initialization section of ar_receipt_api_pub');
10221: ar_receipt_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
10222: ar_receipt_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
10223: ar_receipt_lib_pvt.pg_profile_appln_gl_date_def := FND_API.G_MISS_CHAR;
10224: ar_receipt_lib_pvt.pg_profile_amt_applied_def := FND_API.G_MISS_CHAR;