30: l_return_status VARCHAR2(1);
31: l_msg_count NUMBER;
32: l_msg_data VARCHAR2(2000);
33:
34: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
35: l_func_amount_applied_tot NUMBER := 0;
36: l_rcpt_amount_applied_tot NUMBER := 0;
37: l_amount_unapplied NUMBER := 0;
38:
38:
39: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
40: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
41:
42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
45:
46: l_over_pay VARCHAR2(1) DEFAULT NULL;
39: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
40: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
41:
42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
45:
46: l_over_pay VARCHAR2(1) DEFAULT NULL;
47: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
40: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
41:
42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
45:
46: l_over_pay VARCHAR2(1) DEFAULT NULL;
47: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
48: l_counter NUMBER;
434: l_return_status VARCHAR2(1);
435: l_msg_count NUMBER;
436: l_msg_data VARCHAR2(2000);
437:
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
436: l_msg_data VARCHAR2(2000);
437:
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
437:
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECEIPT';
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECEIPT';
446:
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECEIPT';
446:
447: -- BEGIN abindal bug 4316610 --
576: l_return_status VARCHAR2(1);
577: l_msg_count NUMBER;
578: l_msg_data VARCHAR2(2000);
579:
580: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
581: l_func_amount_applied_tot NUMBER := 0;
582: l_rcpt_amount_applied_tot NUMBER := 0;
583: l_amount_unapplied NUMBER := 0;
584:
584:
585: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
586: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
587:
588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
591:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;
585: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
586: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
587:
588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
591:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;
593: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
586: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
587:
588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
591:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;
593: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
594: l_counter NUMBER;