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_PREPAYMENTS dependencies on FND_MESSAGE

Line 68: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_REMITTED_OR_CLEARED')

64: ---
65: --- For CC receipts, receipt should be remitted
66: ---
67: BEGIN
68: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_REMITTED_OR_CLEARED')
69: INTO x_rec_in_doubt, x_rid_reason
70: FROM dual
71: WHERE
72: (

Line 100: SELECT 'Y', arp_standard.fnd_message('AR_RID_CLAIM_OR_CB_APP_EXISTS')

96: ---
97: --- There should not be any Claims Investigation or CB special application
98: ---
99: BEGIN
100: SELECT 'Y', arp_standard.fnd_message('AR_RID_CLAIM_OR_CB_APP_EXISTS')
101: INTO x_rec_in_doubt, x_rid_reason
102: FROM dual
103: WHERE
104: EXISTS

Line 131: SELECT 'Y', arp_standard.fnd_message('AR_RID_RECEIPT_REVERSED')

127: ---
128: --- Receipt should not be reversed
129: ---
130: BEGIN
131: SELECT 'Y', arp_standard.fnd_message('AR_RID_RECEIPT_REVERSED')
132: INTO x_rec_in_doubt, x_rid_reason
133: FROM dual
134: WHERE
135: EXISTS

Line 1098: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');

1094:
1095: IF (l_payment_set_id IS NULl AND p_receipt_number IS NULL
1096: AND l_cash_receipt_id IS NULL AND l_receivable_application_id IS NULL)
1097: THEN
1098: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
1099: FND_MSG_PUB.Add;
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: RETURN;
1102: END IF;

Line 1157: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');

1153:
1154: ---Bug: 3504678
1155: if nvl(l_refund_amount,0) > nvl(l_max_refund_amt,0) then
1156: --raise error X validation failed
1157: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');
1158: FND_MSG_PUB.Add;
1159: x_return_status := FND_API.G_RET_STS_ERROR ;
1160: RETURN;
1161: end if;

Line 1178: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');

1174: END IF;
1175:
1176: EXCEPTION
1177: when no_data_found then
1178: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');
1179: FND_MSG_PUB.Add;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: RETURN ;
1182:

Line 1244: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');

1240: where ra.payment_set_id= l_payment_set_id
1241: AND cr.cash_receipt_id = ra.cash_receipt_id;
1242:
1243: if l_dummy = 0 then
1244: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1245: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PAYMENT_SET_ID');
1246: FND_MESSAGE.SET_TOKEN('VALUE',l_payment_set_id);
1247: FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1245: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PAYMENT_SET_ID');

1241: AND cr.cash_receipt_id = ra.cash_receipt_id;
1242:
1243: if l_dummy = 0 then
1244: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1245: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PAYMENT_SET_ID');
1246: FND_MESSAGE.SET_TOKEN('VALUE',l_payment_set_id);
1247: FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: RETURN;

Line 1246: FND_MESSAGE.SET_TOKEN('VALUE',l_payment_set_id);

1242:
1243: if l_dummy = 0 then
1244: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1245: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PAYMENT_SET_ID');
1246: FND_MESSAGE.SET_TOKEN('VALUE',l_payment_set_id);
1247: FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: RETURN;
1250: end if;

Line 1272: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');

1268: AND cr.cash_receipt_id = ra.cash_receipt_id
1269: and cr.customer_bank_account_id = t_bank_account_id;
1270:
1271: if l_dummy = 0 then
1272: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1273: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BANK_ACCOUNT_ID');
1274: FND_MESSAGE.SET_TOKEN('VALUE',t_bank_account_id);
1275: FND_MSG_PUB.Add;
1276: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1273: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BANK_ACCOUNT_ID');

1269: and cr.customer_bank_account_id = t_bank_account_id;
1270:
1271: if l_dummy = 0 then
1272: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1273: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BANK_ACCOUNT_ID');
1274: FND_MESSAGE.SET_TOKEN('VALUE',t_bank_account_id);
1275: FND_MSG_PUB.Add;
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: RETURN;

Line 1274: FND_MESSAGE.SET_TOKEN('VALUE',t_bank_account_id);

1270:
1271: if l_dummy = 0 then
1272: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1273: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BANK_ACCOUNT_ID');
1274: FND_MESSAGE.SET_TOKEN('VALUE',t_bank_account_id);
1275: FND_MSG_PUB.Add;
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: RETURN;
1278: end if;

Line 1301: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');

1297: AND cr.cash_receipt_id = ra.cash_receipt_id
1298: and cr.receipt_method_id = t_receipt_method_id;
1299:
1300: if l_dummy = 0 then
1301: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1302: FND_MESSAGE.SET_TOKEN('PARAMETER','P_RECEIPT_METHOD_ID');
1303: FND_MESSAGE.SET_TOKEN('VALUE',t_receipt_method_id);
1304: FND_MSG_PUB.Add;
1305: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1302: FND_MESSAGE.SET_TOKEN('PARAMETER','P_RECEIPT_METHOD_ID');

1298: and cr.receipt_method_id = t_receipt_method_id;
1299:
1300: if l_dummy = 0 then
1301: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1302: FND_MESSAGE.SET_TOKEN('PARAMETER','P_RECEIPT_METHOD_ID');
1303: FND_MESSAGE.SET_TOKEN('VALUE',t_receipt_method_id);
1304: FND_MSG_PUB.Add;
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: RETURN;

Line 1303: FND_MESSAGE.SET_TOKEN('VALUE',t_receipt_method_id);

1299:
1300: if l_dummy = 0 then
1301: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1302: FND_MESSAGE.SET_TOKEN('PARAMETER','P_RECEIPT_METHOD_ID');
1303: FND_MESSAGE.SET_TOKEN('VALUE',t_receipt_method_id);
1304: FND_MSG_PUB.Add;
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: RETURN;
1307: end if;

Line 1329: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');

1325:
1326: ---Bug 3504678
1327: if nvl(l_refund_amount,0) > nvl(l_max_refund_amt,0) then
1328: --raise error X validation failed
1329: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');
1330: FND_MSG_PUB.Add;
1331: x_return_status := FND_API.G_RET_STS_ERROR ;
1332: RETURN;
1333: end if;

Line 1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

1532: ROLLBACK TO refund_prepay_PVT;
1533:
1534: -- Display_Parameters;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,

Line 1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);

1533:
1534: -- Display_Parameters;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data);

Line 1545: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

1541: p_data => x_msg_data);
1542: RETURN;
1543: ELSE
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1546: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REFUND_PREPAYMENT : '||SQLERRM);
1547: FND_MSG_PUB.Add;
1548: END IF;
1549:

Line 1546: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REFUND_PREPAYMENT : '||SQLERRM);

1542: RETURN;
1543: ELSE
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1546: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REFUND_PREPAYMENT : '||SQLERRM);
1547: FND_MSG_PUB.Add;
1548: END IF;
1549:
1550: IF PG_DEBUG in ('Y', 'C') THEN

Line 1944: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');

1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: /*-------Validate the p_term_id---------------*/
1943: IF p_term_id IS NULL THEN
1944: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1945: FND_MSG_PUB.Add;
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSE
1948: BEGIN

Line 1954: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');

1950: FROM RA_TERMS_B
1951: WHERE term_id = p_term_id;
1952: EXCEPTION
1953: WHEN NO_DATA_FOUND THEN
1954: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1955: FND_MSG_PUB.Add;
1956: RAISE FND_API.G_EXC_ERROR;
1957: END;
1958: END IF;

Line 1962: FND_MESSAGE.SET_NAME('AR','AR_PPAY_BASE_AMOUNT_INVALID');

1958: END IF;
1959:
1960: -----Input amount should not be null or 0 -------
1961: IF ( (p_amount is null) or (p_amount <= 0) ) THEN
1962: FND_MESSAGE.SET_NAME('AR','AR_PPAY_BASE_AMOUNT_INVALID');
1963: FND_MSG_PUB.Add;
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966:

Line 1969: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');

1965: END IF;
1966:
1967: -----Input currency code should not be invalid -------
1968: IF p_currency_code IS NULL THEN
1969: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1970: FND_MSG_PUB.Add;
1971: RAISE FND_API.G_EXC_ERROR;
1972: ELSE
1973: BEGIN

Line 1979: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');

1975: FROM fnd_currencies
1976: WHERE currency_code = p_currency_code;
1977: EXCEPTION
1978: WHEN NO_DATA_FOUND THEN
1979: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1980: FND_MSG_PUB.Add;
1981: RAISE FND_API.G_EXC_ERROR;
1982: END;
1983: END IF;

Line 2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

2013: WHEN others THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: --Bug 3107679 removed to_char call
2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
2019: FND_MSG_PUB.Add;
2020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2021: p_count => x_msg_count,

Line 2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);

2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: --Bug 3107679 removed to_char call
2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
2019: FND_MSG_PUB.Add;
2020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2021: p_count => x_msg_count,
2022: p_data => x_msg_data);

Line 2090: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );

2086: EXCEPTION
2087: WHEN OTHERS THEN
2088: ROLLBACK TO Select_Prepay_Event;
2089:
2090: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2091: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2092: FND_MSG_PUB.ADD;
2093:
2094: RETURN 'ERROR';

Line 2091: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );

2087: WHEN OTHERS THEN
2088: ROLLBACK TO Select_Prepay_Event;
2089:
2090: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2091: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2092: FND_MSG_PUB.ADD;
2093:
2094: RETURN 'ERROR';
2095: END;

Line 2120: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

2116: 'AutoInvoice Batch',
2117: l_request_id );
2118:
2119: IF l_conc_request_id = 0 THEN
2120: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: END IF;

Line 2133: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );

2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: ROLLBACK TO Select_Prepay_Event;
2132:
2133: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2134: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2135: FND_MSG_PUB.ADD;
2136:
2137: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);

Line 2134: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );

2130: WHEN OTHERS THEN
2131: ROLLBACK TO Select_Prepay_Event;
2132:
2133: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2134: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2135: FND_MSG_PUB.ADD;
2136:
2137: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);
2138: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 2236: FND_MESSAGE.SET_NAME('AR','AR_PPAY_INVALID_REQ_ID');

2232: ---Validate that if p_batch_source is NOT 'ALL' then there is request_id
2233: if p_batch_source <> 'All Invoices' then
2234:
2235: IF( l_request_id IS NULL OR l_request_id = 0 )THEN
2236: FND_MESSAGE.SET_NAME('AR','AR_PPAY_INVALID_REQ_ID');
2237: FND_MSG_PUB.Add;
2238: l_retcode := 10;
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;

Line 2363: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');

2359:
2360:
2361: EXCEPTION
2362: WHEN fnd_api.g_exc_error THEN
2363: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');
2364: FND_MSG_PUB.Add;
2365:
2366: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2367: l_msg_data :=