DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on FND_MESSAGE

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

559: END IF;
560:
561: IF l_gl_date_valid IS NULL
562: THEN
563: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_ERROR;
566: ELSE
567: /* date was returned, use it */

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

1317: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed
1318: (p_gl_date => l_rev_adj_rec.gl_date);
1319: IF l_gl_date_valid IS NULL
1320: THEN
1321: FND_MESSAGE.set_name('AR','AR_VAL_GL_DATE');
1322: FND_MSG_PUB.Add;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325: END IF;

Line 1864: FND_MESSAGE.set_name (

1860:
1861: EXCEPTION
1862: WHEN invalid_sc_total THEN
1863: /* Bug 2191739 - call to message API for degovtized message */
1864: FND_MESSAGE.set_name (
1865: application => 'AR',
1866: name => gl_public_sector.get_message_name
1867: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1868: p_app_short_name => 'AR'));

Line 1869: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',

1865: application => 'AR',
1866: name => gl_public_sector.get_message_name
1867: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1868: p_app_short_name => 'AR'));
1869: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1870: arp_global.sysparam.sales_credit_pct_limit);
1871: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1872: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1873: FND_MSG_PUB.Add;

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

1867: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1868: p_app_short_name => 'AR'));
1869: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1870: arp_global.sysparam.sales_credit_pct_limit);
1871: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1872: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1873: FND_MSG_PUB.Add;
1874: RAISE FND_API.G_EXC_ERROR;
1875:

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

1868: p_app_short_name => 'AR'));
1869: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1870: arp_global.sysparam.sales_credit_pct_limit);
1871: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1872: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1873: FND_MSG_PUB.Add;
1874: RAISE FND_API.G_EXC_ERROR;
1875:
1876: WHEN invalid_amount THEN

Line 1880: FND_MESSAGE.set_name

1876: WHEN invalid_amount THEN
1877: IF p_rev_adj_rec.amount_mode = 'P'
1878: THEN
1879: l_max_percent := ROUND(l_nonrev_trx_total / l_trx_total * 100,2);
1880: FND_MESSAGE.set_name
1881: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
1882: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1883: ELSE
1884: FND_MESSAGE.SET_NAME

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

1878: THEN
1879: l_max_percent := ROUND(l_nonrev_trx_total / l_trx_total * 100,2);
1880: FND_MESSAGE.set_name
1881: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
1882: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1883: ELSE
1884: FND_MESSAGE.SET_NAME
1885: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
1886: FND_MESSAGE.set_token('TOT_AVAIL_REV',

Line 1884: FND_MESSAGE.SET_NAME

1880: FND_MESSAGE.set_name
1881: (application => 'AR', name => 'AR_RA_PCT_EXCEEDS_AVAIL_PCT');
1882: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1883: ELSE
1884: FND_MESSAGE.SET_NAME
1885: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
1886: FND_MESSAGE.set_token('TOT_AVAIL_REV',
1887: AR_RAAPI_UTIL.g_trx_currency||' '||l_adj_trx_total);
1888: END IF;

Line 1886: FND_MESSAGE.set_token('TOT_AVAIL_REV',

1882: FND_MESSAGE.set_token('TOT_AVAIL_PCT',l_max_percent);
1883: ELSE
1884: FND_MESSAGE.SET_NAME
1885: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
1886: FND_MESSAGE.set_token('TOT_AVAIL_REV',
1887: AR_RAAPI_UTIL.g_trx_currency||' '||l_adj_trx_total);
1888: END IF;
1889: FND_MSG_PUB.Add;
1890: RAISE FND_API.G_EXC_ERROR;

Line 1892: FND_MESSAGE.set_name

1888: END IF;
1889: FND_MSG_PUB.Add;
1890: RAISE FND_API.G_EXC_ERROR;
1891: WHEN invalid_zero THEN
1892: FND_MESSAGE.set_name
1893: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');
1894: FND_MSG_PUB.Add;
1895: RAISE FND_API.G_EXC_ERROR;
1896: WHEN invalid_ccid THEN

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

1894: FND_MSG_PUB.Add;
1895: RAISE FND_API.G_EXC_ERROR;
1896: WHEN invalid_ccid THEN
1897: FND_MSG_PUB.Add;
1898: FND_MESSAGE.SET_NAME(application => 'AR',
1899: name => 'AR_RA_INVALID_CODE_COMB');
1900: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
1901: FND_MSG_PUB.Add;
1902: RAISE FND_API.G_EXC_ERROR;

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

1896: WHEN invalid_ccid THEN
1897: FND_MSG_PUB.Add;
1898: FND_MESSAGE.SET_NAME(application => 'AR',
1899: name => 'AR_RA_INVALID_CODE_COMB');
1900: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
1901: FND_MSG_PUB.Add;
1902: RAISE FND_API.G_EXC_ERROR;
1903: WHEN OTHERS then
1904: IF (SQLCODE = -20001)

Line 2299: FND_MESSAGE.set_name (

2295:
2296: EXCEPTION
2297: WHEN invalid_sc_total THEN
2298: /* Bug 2191739 - call to message API for degovtized message */
2299: FND_MESSAGE.set_name (
2300: application => 'AR',
2301: name => gl_public_sector.get_message_name
2302: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2303: p_app_short_name => 'AR'));

Line 2304: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',

2300: application => 'AR',
2301: name => gl_public_sector.get_message_name
2302: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2303: p_app_short_name => 'AR'));
2304: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2305: arp_global.sysparam.sales_credit_pct_limit);
2306: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2307: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2308: FND_MSG_PUB.Add;

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

2302: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2303: p_app_short_name => 'AR'));
2304: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2305: arp_global.sysparam.sales_credit_pct_limit);
2306: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2307: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2308: FND_MSG_PUB.Add;
2309: RAISE FND_API.G_EXC_ERROR;
2310: WHEN invalid_amount THEN

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

2303: p_app_short_name => 'AR'));
2304: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2305: arp_global.sysparam.sales_credit_pct_limit);
2306: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2307: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2308: FND_MSG_PUB.Add;
2309: RAISE FND_API.G_EXC_ERROR;
2310: WHEN invalid_amount THEN
2311: FND_MESSAGE.SET_NAME

Line 2311: FND_MESSAGE.SET_NAME

2307: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2308: FND_MSG_PUB.Add;
2309: RAISE FND_API.G_EXC_ERROR;
2310: WHEN invalid_amount THEN
2311: FND_MESSAGE.SET_NAME
2312: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2313: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2314: AR_RAAPI_UTIL.g_trx_currency||' '||'0');
2315: FND_MSG_PUB.Add;

Line 2313: FND_MESSAGE.set_token('TOT_AVAIL_REV',

2309: RAISE FND_API.G_EXC_ERROR;
2310: WHEN invalid_amount THEN
2311: FND_MESSAGE.SET_NAME
2312: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');
2313: FND_MESSAGE.set_token('TOT_AVAIL_REV',
2314: AR_RAAPI_UTIL.g_trx_currency||' '||'0');
2315: FND_MSG_PUB.Add;
2316: RAISE FND_API.G_EXC_ERROR;
2317: WHEN OTHERS then

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

2613: /* Bug 2146970 - validate the GL date passed in */
2614: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed (p_gl_date => l_gl_date);
2615: IF l_gl_date_valid IS NULL
2616: THEN
2617: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
2618: FND_MSG_PUB.Add;
2619: RAISE FND_API.G_EXC_ERROR;
2620: ELSE
2621: l_gl_date := l_gl_date_valid;

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

3229: l_gl_date_valid := AR_RAAPI_UTIL.bump_gl_date_if_closed
3230: (p_gl_date => l_gl_date);
3231: IF l_gl_date_valid IS NULL
3232: THEN
3233: FND_MESSAGE.set_name('AR','AR_RA_NO_OPEN_PERIODS');
3234: FND_MSG_PUB.Add;
3235: RAISE FND_API.G_EXC_ERROR;
3236: END IF;
3237:

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

3277:
3278: EXCEPTION
3279:
3280: WHEN invalid_salesrep THEN
3281: FND_MESSAGE.SET_NAME(application => 'AR',
3282: name => 'AR_RA_NO_REV_SALES_CREDIT');
3283: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3284: FND_MSG_PUB.Add;
3285: RAISE FND_API.G_EXC_ERROR;

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

3279:
3280: WHEN invalid_salesrep THEN
3281: FND_MESSAGE.SET_NAME(application => 'AR',
3282: name => 'AR_RA_NO_REV_SALES_CREDIT');
3283: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3284: FND_MSG_PUB.Add;
3285: RAISE FND_API.G_EXC_ERROR;
3286: WHEN invalid_ccid THEN
3287: FND_MSG_PUB.Add;

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

3284: FND_MSG_PUB.Add;
3285: RAISE FND_API.G_EXC_ERROR;
3286: WHEN invalid_ccid THEN
3287: FND_MSG_PUB.Add;
3288: FND_MESSAGE.SET_NAME(application => 'AR',
3289: name => 'AR_RA_INVALID_CODE_COMB');
3290: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3291: FND_MSG_PUB.Add;
3292: RAISE FND_API.G_EXC_ERROR;

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

3286: WHEN invalid_ccid THEN
3287: FND_MSG_PUB.Add;
3288: FND_MESSAGE.SET_NAME(application => 'AR',
3289: name => 'AR_RA_INVALID_CODE_COMB');
3290: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3291: FND_MSG_PUB.Add;
3292: RAISE FND_API.G_EXC_ERROR;
3293: WHEN OTHERS then
3294: IF (SQLCODE = -20001)

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

3619:
3620: EXCEPTION
3621:
3622: WHEN invalid_salesrep THEN
3623: FND_MESSAGE.SET_NAME(application => 'AR',
3624: name => 'AR_RA_NO_REV_SALES_CREDIT');
3625: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MSG_PUB.Add;
3627: RAISE FND_API.G_EXC_ERROR;

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

3621:
3622: WHEN invalid_salesrep THEN
3623: FND_MESSAGE.SET_NAME(application => 'AR',
3624: name => 'AR_RA_NO_REV_SALES_CREDIT');
3625: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MSG_PUB.Add;
3627: RAISE FND_API.G_EXC_ERROR;
3628: WHEN invalid_ccid THEN
3629: FND_MSG_PUB.Add;

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

3626: FND_MSG_PUB.Add;
3627: RAISE FND_API.G_EXC_ERROR;
3628: WHEN invalid_ccid THEN
3629: FND_MSG_PUB.Add;
3630: FND_MESSAGE.SET_NAME(application => 'AR',
3631: name => 'AR_RA_INVALID_CODE_COMB');
3632: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3633: FND_MSG_PUB.Add;
3634: RAISE FND_API.G_EXC_ERROR;

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

3628: WHEN invalid_ccid THEN
3629: FND_MSG_PUB.Add;
3630: FND_MESSAGE.SET_NAME(application => 'AR',
3631: name => 'AR_RA_INVALID_CODE_COMB');
3632: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3633: FND_MSG_PUB.Add;
3634: RAISE FND_API.G_EXC_ERROR;
3635: WHEN OTHERS then
3636: IF (SQLCODE = -20001)

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

3888:
3889: EXCEPTION
3890: WHEN invalid_ccid THEN
3891: FND_MSG_PUB.Add;
3892: FND_MESSAGE.SET_NAME(application => 'AR',
3893: name => 'AR_RA_INVALID_CODE_COMB');
3894: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3895: FND_MSG_PUB.Add;
3896: RAISE FND_API.G_EXC_ERROR;

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

3890: WHEN invalid_ccid THEN
3891: FND_MSG_PUB.Add;
3892: FND_MESSAGE.SET_NAME(application => 'AR',
3893: name => 'AR_RA_INVALID_CODE_COMB');
3894: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
3895: FND_MSG_PUB.Add;
3896: RAISE FND_API.G_EXC_ERROR;
3897: WHEN OTHERS then
3898: IF (SQLCODE = -20001)

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

4203:
4204: IF NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,-100) =
4205: NVL(AR_RAAPI_UTIL.g_to_cust_trx_line_id,-200)
4206: THEN
4207: FND_MESSAGE.SET_NAME (application => 'AR',
4208: name => 'AR_RA_SAME_FROM_AND_TO_LINES');
4209: RAISE invalid_same_lines;
4210: END IF;
4211: IF NVL(AR_RAAPI_UTIL.g_from_category_id,-100) =

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

4210: END IF;
4211: IF NVL(AR_RAAPI_UTIL.g_from_category_id,-100) =
4212: NVL(AR_RAAPI_UTIL.g_to_category_id,-200)
4213: THEN
4214: FND_MESSAGE.SET_NAME (application => 'AR',
4215: name => 'AR_RA_SAME_FROM_AND_TO_CATS');
4216: RAISE invalid_same_lines;
4217: END IF;
4218: IF NVL(AR_RAAPI_UTIL.g_from_inventory_item_id,-100) =

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

4217: END IF;
4218: IF NVL(AR_RAAPI_UTIL.g_from_inventory_item_id,-100) =
4219: NVL(AR_RAAPI_UTIL.g_to_inventory_item_id,-200)
4220: THEN
4221: FND_MESSAGE.SET_NAME (application => 'AR',
4222: name => 'AR_RA_SAME_FROM_AND_TO_ITEMS');
4223: RAISE invalid_same_lines;
4224: END IF;
4225:

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

4406: WHEN invalid_same_lines THEN
4407: FND_MSG_PUB.Add;
4408: RAISE FND_API.G_EXC_ERROR;
4409: WHEN invalid_lines THEN
4410: FND_MESSAGE.SET_NAME (application => 'AR',
4411: name => 'AR_RA_NO_TSFR_LINES_AVAIL');
4412: FND_MSG_PUB.Add;
4413: RAISE FND_API.G_EXC_ERROR;
4414: WHEN invalid_tax THEN

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

4411: name => 'AR_RA_NO_TSFR_LINES_AVAIL');
4412: FND_MSG_PUB.Add;
4413: RAISE FND_API.G_EXC_ERROR;
4414: WHEN invalid_tax THEN
4415: FND_MESSAGE.SET_NAME (application => 'AR',
4416: name => 'AR_RA_TAX_TREATMENTS_VARY');
4417: FND_MSG_PUB.Add;
4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN OTHERS then

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

4905: EXCEPTION
4906:
4907: WHEN invalid_ccid THEN
4908: FND_MSG_PUB.Add;
4909: FND_MESSAGE.SET_NAME(application => 'AR',
4910: name => 'AR_RA_INVALID_CODE_COMB');
4911: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
4912: FND_MSG_PUB.Add;
4913: RAISE FND_API.G_EXC_ERROR;

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

4907: WHEN invalid_ccid THEN
4908: FND_MSG_PUB.Add;
4909: FND_MESSAGE.SET_NAME(application => 'AR',
4910: name => 'AR_RA_INVALID_CODE_COMB');
4911: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
4912: FND_MSG_PUB.Add;
4913: RAISE FND_API.G_EXC_ERROR;
4914: WHEN OTHERS THEN
4915: IF (SQLCODE = -20001)

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

5339:
5340: EXCEPTION
5341: WHEN invalid_ccid THEN
5342: FND_MSG_PUB.Add;
5343: FND_MESSAGE.SET_NAME(application => 'AR',
5344: name => 'AR_RA_INVALID_CODE_COMB');
5345: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5346: FND_MSG_PUB.Add;
5347: RAISE FND_API.G_EXC_ERROR;

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

5341: WHEN invalid_ccid THEN
5342: FND_MSG_PUB.Add;
5343: FND_MESSAGE.SET_NAME(application => 'AR',
5344: name => 'AR_RA_INVALID_CODE_COMB');
5345: FND_MESSAGE.SET_TOKEN('CODE_COMBINATION',l_concat_segments);
5346: FND_MSG_PUB.Add;
5347: RAISE FND_API.G_EXC_ERROR;
5348: WHEN OTHERS THEN
5349: IF (SQLCODE = -20001)