DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on FND_MESSAGE

Line 574: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');

570: END IF;
571:
572: IF l_gl_date_valid IS NULL
573: THEN
574: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578:

Line 1398: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');

1394: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed
1395: (p_gl_date => l_rev_adj_rec.gl_date);
1396: IF l_gl_date_valid IS NULL
1397: THEN
1398: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF;

Line 1941: FND_MESSAGE.set_name (

1937:
1938: EXCEPTION
1939: WHEN invalid_sc_total THEN
1940: /* Bug 2191739 - call to message API for degovtized message */
1941: FND_MESSAGE.set_name (
1942: application => 'AR',
1943: name => gl_public_sector.get_message_name
1944: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1945: p_app_short_name => 'AR'));

Line 1946: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',

1942: application => 'AR',
1943: name => gl_public_sector.get_message_name
1944: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1945: p_app_short_name => 'AR'));
1946: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1947: arp_global.sysparam.sales_credit_pct_limit);
1948: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1949: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1950: FND_MSG_PUB.Add;

Line 1948: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);

1944: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1945: p_app_short_name => 'AR'));
1946: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1947: arp_global.sysparam.sales_credit_pct_limit);
1948: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1949: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1950: FND_MSG_PUB.Add;
1951: RAISE FND_API.G_EXC_ERROR;
1952:

Line 1949: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);

1945: p_app_short_name => 'AR'));
1946: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1947: arp_global.sysparam.sales_credit_pct_limit);
1948: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1949: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1950: FND_MSG_PUB.Add;
1951: RAISE FND_API.G_EXC_ERROR;
1952:
1953: WHEN invalid_amount THEN

Line 1957: FND_MESSAGE.set_name

1953: WHEN invalid_amount THEN
1954: IF p_rev_adj_rec.amount_mode = 'P'
1955: THEN
1956: l_max_percent := ROUND(l_nonrev_trx_total / l_trx_total * 100,2);
1957: FND_MESSAGE.set_name
1958: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
1959: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1960: ELSE
1961: FND_MESSAGE.SET_NAME

Line 1959: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);

1955: THEN
1956: l_max_percent := ROUND(l_nonrev_trx_total / l_trx_total * 100,2);
1957: FND_MESSAGE.set_name
1958: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
1959: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1960: ELSE
1961: FND_MESSAGE.SET_NAME
1962: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
1963: FND_MESSAGE.set_token('TOT_AVAIL_REV',

Line 1961: FND_MESSAGE.SET_NAME

1957: FND_MESSAGE.set_name
1958: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
1959: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1960: ELSE
1961: FND_MESSAGE.SET_NAME
1962: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
1963: FND_MESSAGE.set_token('TOT_AVAIL_REV',
1964: AR_RAAPI_UTIL.g_trx_currency||' '||l_adj_trx_total);
1965: END IF;

Line 1963: FND_MESSAGE.set_token('TOT_AVAIL_REV',

1959: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1960: ELSE
1961: FND_MESSAGE.SET_NAME
1962: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
1963: FND_MESSAGE.set_token('TOT_AVAIL_REV',
1964: AR_RAAPI_UTIL.g_trx_currency||' '||l_adj_trx_total);
1965: END IF;
1966: FND_MSG_PUB.Add;
1967: RAISE FND_API.G_EXC_ERROR;

Line 1969: FND_MESSAGE.set_name

1965: END IF;
1966: FND_MSG_PUB.Add;
1967: RAISE FND_API.G_EXC_ERROR;
1968: WHEN invalid_zero THEN
1969: FND_MESSAGE.set_name
1970: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
1971: FND_MSG_PUB.Add;
1972: RAISE FND_API.G_EXC_ERROR;
1973: WHEN invalid_ccid THEN

Line 1975: FND_MESSAGE.SET_NAME(application => 'AR',

1971: FND_MSG_PUB.Add;
1972: RAISE FND_API.G_EXC_ERROR;
1973: WHEN invalid_ccid THEN
1974: FND_MSG_PUB.Add;
1975: FND_MESSAGE.SET_NAME(application => 'AR',
1976: name => 'AR_RA_INVALID_CODE_COMB');
1977: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
1978: FND_MSG_PUB.Add;
1979: RAISE FND_API.G_EXC_ERROR;

Line 1977: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);

1973: WHEN invalid_ccid THEN
1974: FND_MSG_PUB.Add;
1975: FND_MESSAGE.SET_NAME(application => 'AR',
1976: name => 'AR_RA_INVALID_CODE_COMB');
1977: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
1978: FND_MSG_PUB.Add;
1979: RAISE FND_API.G_EXC_ERROR;
1980: WHEN OTHERS then
1981: IF (SQLCODE = -20001)

Line 2376: FND_MESSAGE.set_name (

2372:
2373: EXCEPTION
2374: WHEN invalid_sc_total THEN
2375: /* Bug 2191739 - call to message API for degovtized message */
2376: FND_MESSAGE.set_name (
2377: application => 'AR',
2378: name => gl_public_sector.get_message_name
2379: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2380: p_app_short_name => 'AR'));

Line 2381: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',

2377: application => 'AR',
2378: name => gl_public_sector.get_message_name
2379: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2380: p_app_short_name => 'AR'));
2381: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2382: arp_global.sysparam.sales_credit_pct_limit);
2383: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2384: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2385: FND_MSG_PUB.Add;

Line 2383: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);

2379: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2380: p_app_short_name => 'AR'));
2381: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2382: arp_global.sysparam.sales_credit_pct_limit);
2383: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2384: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2385: FND_MSG_PUB.Add;
2386: RAISE FND_API.G_EXC_ERROR;
2387: WHEN invalid_amount THEN

Line 2384: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);

2380: p_app_short_name => 'AR'));
2381: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2382: arp_global.sysparam.sales_credit_pct_limit);
2383: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2384: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2385: FND_MSG_PUB.Add;
2386: RAISE FND_API.G_EXC_ERROR;
2387: WHEN invalid_amount THEN
2388: FND_MESSAGE.SET_NAME

Line 2388: FND_MESSAGE.SET_NAME

2384: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2385: FND_MSG_PUB.Add;
2386: RAISE FND_API.G_EXC_ERROR;
2387: WHEN invalid_amount THEN
2388: FND_MESSAGE.SET_NAME
2389: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2390: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2391: AR_RAAPI_UTIL.g_trx_currency||' '||'0');
2392: FND_MSG_PUB.Add;

Line 2390: FND_MESSAGE.set_token('TOT_AVAIL_REV',

2386: RAISE FND_API.G_EXC_ERROR;
2387: WHEN invalid_amount THEN
2388: FND_MESSAGE.SET_NAME
2389: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2390: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2391: AR_RAAPI_UTIL.g_trx_currency||' '||'0');
2392: FND_MSG_PUB.Add;
2393: RAISE FND_API.G_EXC_ERROR;
2394: WHEN OTHERS then

Line 2694: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');

2690: /* Bug 2146970 - validate the GL date passed in */
2691: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed (p_gl_date => l_gl_date);
2692: IF l_gl_date_valid IS NULL
2693: THEN
2694: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
2695: FND_MSG_PUB.Add;
2696: RAISE FND_API.G_EXC_ERROR;
2697: ELSE
2698: l_gl_date := l_gl_date_valid;

Line 3425: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');

3421: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed
3422: (p_gl_date => l_gl_date);
3423: IF l_gl_date_valid IS NULL
3424: THEN
3425: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
3426: FND_MSG_PUB.Add;
3427: RAISE FND_API.G_EXC_ERROR;
3428: END IF;
3429:

Line 3473: FND_MESSAGE.SET_NAME(application => 'AR',

3469:
3470: EXCEPTION
3471:
3472: WHEN invalid_salesrep THEN
3473: FND_MESSAGE.SET_NAME(application => 'AR',
3474: name => 'AR_RA_NO_REV_SALES_CREDIT');
3475: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3476: FND_MSG_PUB.Add;
3477: RAISE FND_API.G_EXC_ERROR;

Line 3475: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);

3471:
3472: WHEN invalid_salesrep THEN
3473: FND_MESSAGE.SET_NAME(application => 'AR',
3474: name => 'AR_RA_NO_REV_SALES_CREDIT');
3475: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3476: FND_MSG_PUB.Add;
3477: RAISE FND_API.G_EXC_ERROR;
3478: WHEN invalid_ccid THEN
3479: FND_MSG_PUB.Add;

Line 3480: FND_MESSAGE.SET_NAME(application => 'AR',

3476: FND_MSG_PUB.Add;
3477: RAISE FND_API.G_EXC_ERROR;
3478: WHEN invalid_ccid THEN
3479: FND_MSG_PUB.Add;
3480: FND_MESSAGE.SET_NAME(application => 'AR',
3481: name => 'AR_RA_INVALID_CODE_COMB');
3482: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3483: FND_MSG_PUB.Add;
3484: RAISE FND_API.G_EXC_ERROR;

Line 3482: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);

3478: WHEN invalid_ccid THEN
3479: FND_MSG_PUB.Add;
3480: FND_MESSAGE.SET_NAME(application => 'AR',
3481: name => 'AR_RA_INVALID_CODE_COMB');
3482: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3483: FND_MSG_PUB.Add;
3484: RAISE FND_API.G_EXC_ERROR;
3485: WHEN OTHERS then
3486: IF (SQLCODE = -20001)

Line 3824: FND_MESSAGE.SET_NAME(application => 'AR',

3820:
3821: EXCEPTION
3822:
3823: WHEN invalid_salesrep THEN
3824: FND_MESSAGE.SET_NAME(application => 'AR',
3825: name => 'AR_RA_NO_REV_SALES_CREDIT');
3826: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3827: FND_MSG_PUB.Add;
3828: RAISE FND_API.G_EXC_ERROR;

Line 3826: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);

3822:
3823: WHEN invalid_salesrep THEN
3824: FND_MESSAGE.SET_NAME(application => 'AR',
3825: name => 'AR_RA_NO_REV_SALES_CREDIT');
3826: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3827: FND_MSG_PUB.Add;
3828: RAISE FND_API.G_EXC_ERROR;
3829: WHEN invalid_ccid THEN
3830: FND_MSG_PUB.Add;

Line 3831: FND_MESSAGE.SET_NAME(application => 'AR',

3827: FND_MSG_PUB.Add;
3828: RAISE FND_API.G_EXC_ERROR;
3829: WHEN invalid_ccid THEN
3830: FND_MSG_PUB.Add;
3831: FND_MESSAGE.SET_NAME(application => 'AR',
3832: name => 'AR_RA_INVALID_CODE_COMB');
3833: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3834: FND_MSG_PUB.Add;
3835: RAISE FND_API.G_EXC_ERROR;

Line 3833: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);

3829: WHEN invalid_ccid THEN
3830: FND_MSG_PUB.Add;
3831: FND_MESSAGE.SET_NAME(application => 'AR',
3832: name => 'AR_RA_INVALID_CODE_COMB');
3833: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3834: FND_MSG_PUB.Add;
3835: RAISE FND_API.G_EXC_ERROR;
3836: WHEN OTHERS then
3837: IF (SQLCODE = -20001)

Line 4107: FND_MESSAGE.SET_NAME(application => 'AR',

4103:
4104: EXCEPTION
4105: WHEN invalid_ccid THEN
4106: FND_MSG_PUB.Add;
4107: FND_MESSAGE.SET_NAME(application => 'AR',
4108: name => 'AR_RA_INVALID_CODE_COMB');
4109: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
4110: FND_MSG_PUB.Add;
4111: RAISE FND_API.G_EXC_ERROR;

Line 4109: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);

4105: WHEN invalid_ccid THEN
4106: FND_MSG_PUB.Add;
4107: FND_MESSAGE.SET_NAME(application => 'AR',
4108: name => 'AR_RA_INVALID_CODE_COMB');
4109: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
4110: FND_MSG_PUB.Add;
4111: RAISE FND_API.G_EXC_ERROR;
4112: WHEN OTHERS then
4113: IF (SQLCODE = -20001)

Line 4423: FND_MESSAGE.SET_NAME (application => 'AR',

4419:
4420: IF NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,-100) =
4421: NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,-200)
4422: THEN
4423: FND_MESSAGE.SET_NAME (application => 'AR',
4424: name => 'AR_RA_SAME_FROM_AND_TO_LINES');
4425: RAISE invalid_same_lines;
4426: END IF;
4427: IF NVL(AR_RAAPI_UTIL.g_from_category_id,-100) =

Line 4430: FND_MESSAGE.SET_NAME (application => 'AR',

4426: END IF;
4427: IF NVL(AR_RAAPI_UTIL.g_from_category_id,-100) =
4428: NVL(AR_RAAPI_UTIL.g_to_category_id,-200)
4429: THEN
4430: FND_MESSAGE.SET_NAME (application => 'AR',
4431: name => 'AR_RA_SAME_FROM_AND_TO_CATS');
4432: RAISE invalid_same_lines;
4433: END IF;
4434: IF NVL(AR_RAAPI_UTIL.g_from_inventory_item_id,-100) =

Line 4437: FND_MESSAGE.SET_NAME (application => 'AR',

4433: END IF;
4434: IF NVL(AR_RAAPI_UTIL.g_from_inventory_item_id,-100) =
4435: NVL(AR_RAAPI_UTIL.g_to_inventory_item_id,-200)
4436: THEN
4437: FND_MESSAGE.SET_NAME (application => 'AR',
4438: name => 'AR_RA_SAME_FROM_AND_TO_ITEMS');
4439: RAISE invalid_same_lines;
4440: END IF;
4441:

Line 4635: FND_MESSAGE.SET_NAME (application => 'AR',

4631: WHEN invalid_same_lines THEN
4632: FND_MSG_PUB.Add;
4633: RAISE FND_API.G_EXC_ERROR;
4634: WHEN invalid_lines THEN
4635: FND_MESSAGE.SET_NAME (application => 'AR',
4636: name => 'AR_RA_NO_TSFR_LINES_AVAIL');
4637: FND_MSG_PUB.Add;
4638: RAISE FND_API.G_EXC_ERROR;
4639: WHEN invalid_tax THEN

Line 4640: FND_MESSAGE.SET_NAME (application => 'AR',

4636: name => 'AR_RA_NO_TSFR_LINES_AVAIL');
4637: FND_MSG_PUB.Add;
4638: RAISE FND_API.G_EXC_ERROR;
4639: WHEN invalid_tax THEN
4640: FND_MESSAGE.SET_NAME (application => 'AR',
4641: name => 'AR_RA_TAX_TREATMENTS_VARY');
4642: FND_MSG_PUB.Add;
4643: RAISE FND_API.G_EXC_ERROR;
4644: WHEN OTHERS then

Line 5134: FND_MESSAGE.SET_NAME(application => 'AR',

5130: EXCEPTION
5131:
5132: WHEN invalid_ccid THEN
5133: FND_MSG_PUB.Add;
5134: FND_MESSAGE.SET_NAME(application => 'AR',
5135: name => 'AR_RA_INVALID_CODE_COMB');
5136: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5137: FND_MSG_PUB.Add;
5138: RAISE FND_API.G_EXC_ERROR;

Line 5136: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);

5132: WHEN invalid_ccid THEN
5133: FND_MSG_PUB.Add;
5134: FND_MESSAGE.SET_NAME(application => 'AR',
5135: name => 'AR_RA_INVALID_CODE_COMB');
5136: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5137: FND_MSG_PUB.Add;
5138: RAISE FND_API.G_EXC_ERROR;
5139: WHEN OTHERS THEN
5140: IF (SQLCODE = -20001)

Line 5564: FND_MESSAGE.SET_NAME(application => 'AR',

5560:
5561: EXCEPTION
5562: WHEN invalid_ccid THEN
5563: FND_MSG_PUB.Add;
5564: FND_MESSAGE.SET_NAME(application => 'AR',
5565: name => 'AR_RA_INVALID_CODE_COMB');
5566: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5567: FND_MSG_PUB.Add;
5568: RAISE FND_API.G_EXC_ERROR;

Line 5566: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);

5562: WHEN invalid_ccid THEN
5563: FND_MSG_PUB.Add;
5564: FND_MESSAGE.SET_NAME(application => 'AR',
5565: name => 'AR_RA_INVALID_CODE_COMB');
5566: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5567: FND_MSG_PUB.Add;
5568: RAISE FND_API.G_EXC_ERROR;
5569: WHEN OTHERS THEN
5570: IF (SQLCODE = -20001)