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 376: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

696: arp_util.debug('Validate_amount: ' || 'Validate_Receipt_Method ()-');
697: END IF;
698: EXCEPTION
699: WHEN receipt_method_invalid THEN
700: IF ar_receipt_api_pub.Original_create_cash_info.receipt_method_id IS NOT NULL THEN
701: p_return_status := FND_API.G_RET_STS_ERROR;
702: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_MD_ID_INVALID');
703: FND_MSG_PUB.Add;
704: IF PG_DEBUG in ('Y', 'C') THEN

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

703: FND_MSG_PUB.Add;
704: IF PG_DEBUG in ('Y', 'C') THEN
705: arp_util.debug('Validate_amount: ' || 'Invalid receipt method id ');
706: END IF;
707: ELSIF ar_receipt_api_pub.Original_create_cash_info.receipt_method_name IS NOT NULL THEN
708: p_return_status := FND_API.G_RET_STS_ERROR;
709: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCT_MD_NAME_INVALID');
710: FND_MSG_PUB.Add;
711: IF PG_DEBUG in ('Y', 'C') THEN

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

719: arp_util.debug('Validate_amount: ' || 'Exception: remittance_bank_valid ');
720: END IF;
721:
722: WHEN remittance_bank_invalid THEN
723: IF ar_receipt_api_pub.Original_create_cash_info.remit_bank_acct_use_id IS NOT NULL THEN
724: p_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_ID_INVALID');
726: FND_MSG_PUB.Add;
727: IF PG_DEBUG in ('Y', 'C') THEN

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

726: FND_MSG_PUB.Add;
727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account id');
729: END IF;
730: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_num 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_NUM_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_name 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 number');
736: END IF;
737: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_name 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_NAME_INVALID');
740: FND_MSG_PUB.Add;
741: IF PG_DEBUG in ('Y', 'C') THEN

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

1590: -- = amount_applied_from.
1591: --this is to be done only if the user had passed in the values
1592: --for both amount_applied_from and trans_to_receipt_rate
1593: IF p_amount_applied IS NOT NULL AND
1594: ar_receipt_api_pub.Original_application_info.amount_applied_from IS NOT NULL AND
1595: ar_receipt_api_pub.Original_application_info.trans_to_receipt_rate IS NOT NULL
1596: THEN
1597: l_amount_applied := arp_util.CurrRound(
1598: p_amount_applied,

Line 1595: ar_receipt_api_pub.Original_application_info.trans_to_receipt_rate IS NOT NULL

1591: --this is to be done only if the user had passed in the values
1592: --for both amount_applied_from and trans_to_receipt_rate
1593: IF p_amount_applied IS NOT NULL AND
1594: ar_receipt_api_pub.Original_application_info.amount_applied_from IS NOT NULL AND
1595: ar_receipt_api_pub.Original_application_info.trans_to_receipt_rate IS NOT NULL
1596: THEN
1597: l_amount_applied := arp_util.CurrRound(
1598: p_amount_applied,
1599: p_trx_currency_code

Line 2148: ar_receipt_api_pub.Original_unapp_info.receivable_application_id IS NOT NULL

2144: END IF;
2145: --validate the receivable application id only if it was passed in
2146: --directly as a parameter. No need to validate if it was derived.
2147: IF p_receivable_application_id IS NOT NULL AND
2148: ar_receipt_api_pub.Original_unapp_info.receivable_application_id IS NOT NULL
2149: THEN
2150: SELECT count(*)
2151: INTO l_valid
2152: FROM AR_RECEIVABLE_APPLICATIONS ra

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

2161: p_return_status := FND_API.G_RET_STS_ERROR;
2162: END IF;
2163:
2164: ELSIF p_receivable_application_id IS NULL THEN
2165: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2166: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2167: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2168: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2169: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

Line 2166: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND

2162: END IF;
2163:
2164: ELSIF p_receivable_application_id IS NULL THEN
2165: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2166: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2167: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2168: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2169: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2170: THEN

Line 2167: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND

2163:
2164: ELSIF p_receivable_application_id IS NULL THEN
2165: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2166: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2167: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2168: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2169: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2170: THEN
2171: --receivable application id is null

Line 2168: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND

2164: ELSIF p_receivable_application_id IS NULL THEN
2165: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2166: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2167: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2168: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2169: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2170: THEN
2171: --receivable application id is null
2172: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');

Line 2169: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

2165: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2166: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2167: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2168: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2169: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2170: THEN
2171: --receivable application id is null
2172: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2173: FND_MSG_PUB.Add;

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

2171: --receivable application id is null
2172: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2173: FND_MSG_PUB.Add;
2174: p_return_status := FND_API.G_RET_STS_ERROR;
2175: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2178: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2179: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)

Line 2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND

2172: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2173: FND_MSG_PUB.Add;
2174: p_return_status := FND_API.G_RET_STS_ERROR;
2175: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2178: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2179: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2180: THEN

Line 2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND

2173: FND_MSG_PUB.Add;
2174: p_return_status := FND_API.G_RET_STS_ERROR;
2175: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2178: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2179: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2180: THEN
2181: --the transaction was not specified

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

2174: p_return_status := FND_API.G_RET_STS_ERROR;
2175: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2178: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2179: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2180: THEN
2181: --the transaction was not specified
2182: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');

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

2175: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2178: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR
2179: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NOT NULL)
2180: THEN
2181: --the transaction was not specified
2182: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2183: FND_MSG_PUB.Add;

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

2181: --the transaction was not specified
2182: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2183: FND_MSG_PUB.Add;
2184: p_return_status := FND_API.G_RET_STS_ERROR;
2185: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2186: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2187: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2189: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

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

2182: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2183: FND_MSG_PUB.Add;
2184: p_return_status := FND_API.G_RET_STS_ERROR;
2185: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2186: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2187: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2189: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2190: THEN

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

2183: FND_MSG_PUB.Add;
2184: p_return_status := FND_API.G_RET_STS_ERROR;
2185: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2186: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2187: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2189: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2190: THEN
2191: --the receipt was not specified

Line 2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND

2184: p_return_status := FND_API.G_RET_STS_ERROR;
2185: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2186: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2187: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2189: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2190: THEN
2191: --the receipt was not specified
2192: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');

Line 2189: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL

2185: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2186: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2187: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND
2189: ar_receipt_api_pub.Original_unapp_info.receipt_number IS NULL
2190: THEN
2191: --the receipt was not specified
2192: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
2193: FND_MSG_PUB.Add;

Line 4168: l_attribute_rec ar_receipt_api_pub.attribute_rec_type; --bug7311231

4164: l_calc_tax_amount NUMBER;
4165: l_calc_freight_amount NUMBER;
4166: l_cr_unapp_bal NUMBER;
4167: l_dflex_val_return_status VARCHAR2(1); --bug7311231
4168: l_attribute_rec ar_receipt_api_pub.attribute_rec_type; --bug7311231
4169: BEGIN
4170: IF PG_DEBUG in ('Y', 'C') THEN
4171: arp_util.debug('ar_receipt_val_pvt.validate_llac_insert_ad()+');
4172: END IF;