eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_VAL_PVT dependencies on AR_RECEIPT_API_PUB

Line 377: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL THEN

373: and bb.bank_account_id = p_customer_bank_account_id;
374:
375: EXCEPTION
376: WHEN no_data_found THEN
377: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL THEN
378: p_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
380: FND_MSG_PUB.Add;
381: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL THEN

Line 381: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL THEN

377: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL THEN
378: p_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
380: FND_MSG_PUB.Add;
381: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL THEN
382: p_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
384: FND_MSG_PUB.Add;
385: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL THEN

Line 385: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL THEN

381: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL THEN
382: p_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
384: FND_MSG_PUB.Add;
385: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL THEN
386: p_return_status := FND_API.G_RET_STS_ERROR;
387: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NAME_INVALID');
388: FND_MSG_PUB.Add;
389: END IF;

Line 428: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL

424: --If p_customer_id is null and the customer_bank_account_id or
425: --the site_use_id has been passed in, then raise an error.
426: /* 6612301 */
427: IF p_customer_bank_account_id IS NOT NULL THEN
428: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL
429: THEN
430: p_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
432: FND_MSG_PUB.Add;

Line 433: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL

429: THEN
430: p_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
432: FND_MSG_PUB.Add;
433: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL
434: THEN
435: p_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
437: FND_MSG_PUB.Add;

Line 438: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL

434: THEN
435: p_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
437: FND_MSG_PUB.Add;
438: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL
439: THEN
440: p_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NAME_INVALID');
442: FND_MSG_PUB.Add;

Line 448: IF ar_receipt_api_pub.Original_create_cash_info.cust_site_use_id IS NOT NULL

444:
445: END IF; /* bichatte payment uptake commenting ( Reverted) */
446:
447: IF p_customer_site_use_id IS NOT NULL THEN
448: IF ar_receipt_api_pub.Original_create_cash_info.cust_site_use_id IS NOT NULL
449: THEN
450: p_return_status := FND_API.G_RET_STS_ERROR;
451: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_SITE_USE_ID_INVALID');
452: FND_MSG_PUB.Add;

Line 453: ELSIF ar_receipt_api_pub.Original_create_cash_info.location IS NULL THEN

449: THEN
450: p_return_status := FND_API.G_RET_STS_ERROR;
451: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_SITE_USE_ID_INVALID');
452: FND_MSG_PUB.Add;
453: ELSIF ar_receipt_api_pub.Original_create_cash_info.location IS NULL THEN
454: p_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_LOC_INVALID');
456: FND_MSG_PUB.Add;
457: END IF;

Line 707: IF ar_receipt_api_pub.Original_create_cash_info.receipt_method_id IS NOT NULL THEN

703: arp_util.debug('Validate_amount: ' || 'Validate_Receipt_Method ()-');
704: END IF;
705: EXCEPTION
706: WHEN receipt_method_invalid THEN
707: IF ar_receipt_api_pub.Original_create_cash_info.receipt_method_id IS NOT NULL THEN
708: p_return_status := FND_API.G_RET_STS_ERROR;
709: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_MD_ID_INVALID');
710: FND_MSG_PUB.Add;
711: IF PG_DEBUG in ('Y', 'C') THEN

Line 714: ELSIF ar_receipt_api_pub.Original_create_cash_info.receipt_method_name IS NOT NULL THEN

710: FND_MSG_PUB.Add;
711: IF PG_DEBUG in ('Y', 'C') THEN
712: arp_util.debug('Validate_amount: ' || 'Invalid receipt method id ');
713: END IF;
714: ELSIF ar_receipt_api_pub.Original_create_cash_info.receipt_method_name IS NOT NULL THEN
715: p_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCT_MD_NAME_INVALID');
717: FND_MSG_PUB.Add;
718: IF PG_DEBUG in ('Y', 'C') THEN

Line 730: IF ar_receipt_api_pub.Original_create_cash_info.remit_bank_acct_use_id IS NOT NULL THEN

726: arp_util.debug('Validate_amount: ' || 'Exception: remittance_bank_valid ');
727: END IF;
728:
729: WHEN remittance_bank_invalid THEN
730: IF ar_receipt_api_pub.Original_create_cash_info.remit_bank_acct_use_id IS NOT NULL THEN
731: p_return_status := FND_API.G_RET_STS_ERROR;
732: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_ID_INVALID');
733: FND_MSG_PUB.Add;
734: IF PG_DEBUG in ('Y', 'C') THEN

Line 737: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_num IS NOT NULL THEN

733: FND_MSG_PUB.Add;
734: IF PG_DEBUG in ('Y', 'C') THEN
735: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account id');
736: END IF;
737: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_num IS NOT NULL THEN
738: p_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_NUM_INVALID');
740: FND_MSG_PUB.Add;
741: IF PG_DEBUG in ('Y', 'C') THEN

Line 744: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_name IS NOT NULL THEN

740: FND_MSG_PUB.Add;
741: IF PG_DEBUG in ('Y', 'C') THEN
742: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account number');
743: END IF;
744: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_name IS NOT NULL THEN
745: p_return_status := FND_API.G_RET_STS_ERROR;
746: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_NAME_INVALID');
747: FND_MSG_PUB.Add;
748: IF PG_DEBUG in ('Y', 'C') THEN

Line 1603: ar_receipt_api_pub.Original_application_info.amount_applied_from IS NOT NULL AND

1599: -- = amount_applied_from.
1600: --this is to be done only if the user had passed in the values
1601: --for both amount_applied_from and trans_to_receipt_rate
1602: IF p_amount_applied IS NOT NULL AND
1603: ar_receipt_api_pub.Original_application_info.amount_applied_from IS NOT NULL AND
1604: ar_receipt_api_pub.Original_application_info.trans_to_receipt_rate IS NOT NULL
1605: THEN
1606: l_amount_applied := arp_util.CurrRound(
1607: p_amount_applied,

Line 1604: ar_receipt_api_pub.Original_application_info.trans_to_receipt_rate IS NOT NULL

1600: --this is to be done only if the user had passed in the values
1601: --for both amount_applied_from and trans_to_receipt_rate
1602: IF p_amount_applied IS NOT NULL AND
1603: ar_receipt_api_pub.Original_application_info.amount_applied_from IS NOT NULL AND
1604: ar_receipt_api_pub.Original_application_info.trans_to_receipt_rate IS NOT NULL
1605: THEN
1606: l_amount_applied := arp_util.CurrRound(
1607: p_amount_applied,
1608: p_trx_currency_code

Line 2218: ar_receipt_api_pub.Original_unapp_info.receivable_application_id IS NOT NULL

2214: END IF;
2215: --validate the receivable application id only if it was passed in
2216: --directly as a parameter. No need to validate if it was derived.
2217: IF p_receivable_application_id IS NOT NULL AND
2218: ar_receipt_api_pub.Original_unapp_info.receivable_application_id IS NOT NULL
2219: THEN
2220: SELECT count(*)
2221: INTO l_valid
2222: FROM AR_RECEIVABLE_APPLICATIONS ra

Line 2235: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND

2231: p_return_status := FND_API.G_RET_STS_ERROR;
2232: END IF;
2233:
2234: ELSIF p_receivable_application_id IS NULL THEN
2235: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2236: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2237: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2238: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2239: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

Line 2236: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND

2232: END IF;
2233:
2234: ELSIF p_receivable_application_id IS NULL THEN
2235: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2236: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2237: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2238: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2239: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2240: THEN

Line 2237: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND

2233:
2234: ELSIF p_receivable_application_id IS NULL THEN
2235: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2236: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2237: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2238: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2239: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2240: THEN
2241: --receivable application id is null

Line 2238: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND

2234: ELSIF p_receivable_application_id IS NULL THEN
2235: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2236: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2237: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2238: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2239: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2240: THEN
2241: --receivable application id is null
2242: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');

Line 2239: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

2235: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2236: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2237: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2238: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2239: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2240: THEN
2241: --receivable application id is null
2242: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2243: FND_MSG_PUB.Add;

Line 2245: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND

2241: --receivable application id is null
2242: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2243: FND_MSG_PUB.Add;
2244: p_return_status := FND_API.G_RET_STS_ERROR;
2245: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2246: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2247: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2248: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2249: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)

Line 2246: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND

2242: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2243: FND_MSG_PUB.Add;
2244: p_return_status := FND_API.G_RET_STS_ERROR;
2245: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2246: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2247: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2248: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2249: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2250: THEN

Line 2247: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND

2243: FND_MSG_PUB.Add;
2244: p_return_status := FND_API.G_RET_STS_ERROR;
2245: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2246: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2247: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2248: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2249: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2250: THEN
2251: --the transaction was not specified

Line 2248: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR

2244: p_return_status := FND_API.G_RET_STS_ERROR;
2245: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2246: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2247: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2248: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2249: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2250: THEN
2251: --the transaction was not specified
2252: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');

Line 2249: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)

2245: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2246: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2247: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2248: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2249: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2250: THEN
2251: --the transaction was not specified
2252: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2253: FND_MSG_PUB.Add;

Line 2255: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR

2251: --the transaction was not specified
2252: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2253: FND_MSG_PUB.Add;
2254: p_return_status := FND_API.G_RET_STS_ERROR;
2255: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2256: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2257: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2258: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2259: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

Line 2256: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR

2252: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2253: FND_MSG_PUB.Add;
2254: p_return_status := FND_API.G_RET_STS_ERROR;
2255: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2256: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2257: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2258: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2259: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2260: THEN

Line 2257: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND

2253: FND_MSG_PUB.Add;
2254: p_return_status := FND_API.G_RET_STS_ERROR;
2255: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2256: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2257: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2258: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2259: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2260: THEN
2261: --the receipt was not specified

Line 2258: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND

2254: p_return_status := FND_API.G_RET_STS_ERROR;
2255: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2256: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2257: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2258: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2259: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2260: THEN
2261: --the receipt was not specified
2262: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');

Line 2259: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

2255: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2256: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2257: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2258: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2259: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2260: THEN
2261: --the receipt was not specified
2262: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
2263: FND_MSG_PUB.Add;

Line 4306: l_attribute_rec ar_receipt_api_pub.attribute_rec_type; --bug7311231

4302: l_calc_tax_amount NUMBER;
4303: l_calc_freight_amount NUMBER;
4304: l_cr_unapp_bal NUMBER;
4305: l_dflex_val_return_status VARCHAR2(1); --bug7311231
4306: l_attribute_rec ar_receipt_api_pub.attribute_rec_type; --bug7311231
4307: BEGIN
4308: IF PG_DEBUG in ('Y', 'C') THEN
4309: arp_util.debug('ar_receipt_val_pvt.validate_llac_insert_ad()+');
4310: END IF;