DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on FND_MSG_PUB

Line 91: FND_MSG_PUB.initialize;

87: END IF;
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list )
90: THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93: -- Initialize API return status to success
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:

Line 124: FND_MSG_PUB.Count_And_Get

120: THEN
121: COMMIT WORK;
122: END IF;
123: -- Standard call to get message count and if count is 1, get message info.
124: FND_MSG_PUB.Count_And_Get
125: (p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data);
128: IF PG_DEBUG in ('Y', 'C') THEN

Line 135: FND_MSG_PUB.Count_And_Get

131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Unearn_Revenue_PVT;
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136: (p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 146: FND_MSG_PUB.Count_And_Get

142: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
143: END IF;
144: ROLLBACK TO Unearn_Revenue_PVT;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.Count_And_Get
147: (p_encoded => FND_API.G_FALSE,
148: p_count => x_msg_count,
149: p_data => x_msg_data);
150: WHEN OTHERS THEN

Line 164: IF FND_MSG_PUB.Check_Msg_Level

160: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
161: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
162: END IF;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: IF FND_MSG_PUB.Check_Msg_Level
165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN
167: FND_MSG_PUB.Add_Exc_Msg
168: ( G_PKG_NAME ,

Line 165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

161: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
162: END IF;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: IF FND_MSG_PUB.Check_Msg_Level
165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN
167: FND_MSG_PUB.Add_Exc_Msg
168: ( G_PKG_NAME ,
169: l_api_name

Line 167: FND_MSG_PUB.Add_Exc_Msg

163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: IF FND_MSG_PUB.Check_Msg_Level
165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN
167: FND_MSG_PUB.Add_Exc_Msg
168: ( G_PKG_NAME ,
169: l_api_name
170: );
171: END IF;

Line 174: FND_MSG_PUB.Count_And_Get

170: );
171: END IF;
172: END IF;
173: ROLLBACK TO Unearn_Revenue_PVT;
174: FND_MSG_PUB.Count_And_Get
175: (p_encoded => FND_API.G_FALSE,
176: p_count => x_msg_count,
177: p_data => x_msg_data);
178: END Unearn_Revenue;

Line 245: FND_MSG_PUB.initialize;

241: END IF;
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean( p_init_msg_list )
244: THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247: -- Initialize API return status to success
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:

Line 277: FND_MSG_PUB.Count_And_Get

273: THEN
274: COMMIT WORK;
275: END IF;
276: -- Standard call to get message count and if count is 1, get message info.
277: FND_MSG_PUB.Count_And_Get
278: (p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data);
281: IF PG_DEBUG in ('Y', 'C') THEN

Line 288: FND_MSG_PUB.Count_And_Get

284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: ROLLBACK TO Earn_Revenue_PVT;
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 299: FND_MSG_PUB.Count_And_Get

295: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
296: END IF;
297: ROLLBACK TO Earn_Revenue_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: (p_encoded => FND_API.G_FALSE,
301: p_count => x_msg_count,
302: p_data => x_msg_data);
303: WHEN OTHERS THEN

Line 317: IF FND_MSG_PUB.Check_Msg_Level

313: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
314: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
315: END IF;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: IF FND_MSG_PUB.Check_Msg_Level
318: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg
321: ( G_PKG_NAME ,

Line 318: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

314: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
315: END IF;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: IF FND_MSG_PUB.Check_Msg_Level
318: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg
321: ( G_PKG_NAME ,
322: l_api_name

Line 320: FND_MSG_PUB.Add_Exc_Msg

316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: IF FND_MSG_PUB.Check_Msg_Level
318: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
319: THEN
320: FND_MSG_PUB.Add_Exc_Msg
321: ( G_PKG_NAME ,
322: l_api_name
323: );
324: END IF;

Line 327: FND_MSG_PUB.Count_And_Get

323: );
324: END IF;
325: END IF;
326: ROLLBACK TO Earn_Revenue_PVT;
327: FND_MSG_PUB.Count_And_Get
328: (p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data);
331: END Earn_Revenue;

Line 564: FND_MSG_PUB.Add;

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 */
568: l_rev_adj_rec.gl_date := l_gl_date_valid;

Line 1228: FND_MSG_PUB.initialize;

1224: END IF;
1225: -- Initialize message list if p_init_msg_list is set to TRUE.
1226: IF FND_API.to_Boolean( p_init_msg_list )
1227: THEN
1228: FND_MSG_PUB.initialize;
1229: END IF;
1230: -- Initialize API return status to success
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:

Line 1322: FND_MSG_PUB.Add;

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;
1326: --

Line 1873: FND_MSG_PUB.Add;

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
1877: IF p_rev_adj_rec.amount_mode = 'P'

Line 1889: FND_MSG_PUB.Add;

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;
1891: WHEN invalid_zero THEN
1892: FND_MESSAGE.set_name
1893: (application => 'AR', name => 'AR_RA_ZERO_AMOUNT');

Line 1894: 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
1897: FND_MSG_PUB.Add;
1898: FND_MESSAGE.SET_NAME(application => 'AR',

Line 1897: FND_MSG_PUB.Add;

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
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;

Line 1901: FND_MSG_PUB.Add;

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)
1905: THEN

Line 1929: FND_MSG_PUB.Count_And_Get

1925: THEN
1926: COMMIT WORK;
1927: END IF;
1928: -- Standard call to get message count and if count is 1, get message info.
1929: FND_MSG_PUB.Count_And_Get
1930: (p_encoded => FND_API.G_FALSE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data);
1933: IF PG_DEBUG in ('Y', 'C') THEN

Line 1940: FND_MSG_PUB.Count_And_Get

1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: ROLLBACK TO Transfer_Sales_Credits_PVT;
1939: x_return_status := FND_API.G_RET_STS_ERROR ;
1940: FND_MSG_PUB.Count_And_Get
1941: (p_encoded => FND_API.G_FALSE,
1942: p_count => x_msg_count,
1943: p_data => x_msg_data);
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1951: FND_MSG_PUB.Count_And_Get

1947: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1948: END IF;
1949: ROLLBACK TO Transfer_Sales_Credits_PVT;
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: FND_MSG_PUB.Count_And_Get
1952: (p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data);
1955: WHEN OTHERS THEN

Line 1969: IF FND_MSG_PUB.Check_Msg_Level

1965: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1966: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1967: END IF;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level
1970: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: FND_MSG_PUB.Add_Exc_Msg
1973: ( G_PKG_NAME ,

Line 1970: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1966: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1967: END IF;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level
1970: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: FND_MSG_PUB.Add_Exc_Msg
1973: ( G_PKG_NAME ,
1974: l_api_name

Line 1972: FND_MSG_PUB.Add_Exc_Msg

1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level
1970: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: FND_MSG_PUB.Add_Exc_Msg
1973: ( G_PKG_NAME ,
1974: l_api_name
1975: );
1976: END IF;

Line 1979: FND_MSG_PUB.Count_And_Get

1975: );
1976: END IF;
1977: END IF;
1978: ROLLBACK TO Transfer_Sales_Credits_PVT;
1979: FND_MSG_PUB.Count_And_Get
1980: (p_encoded => FND_API.G_FALSE,
1981: p_count => x_msg_count,
1982: p_data => x_msg_data);
1983:

Line 2156: FND_MSG_PUB.initialize;

2152: END IF;
2153: -- Initialize message list if p_init_msg_list is set to TRUE.
2154: IF FND_API.to_Boolean( p_init_msg_list )
2155: THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: -- Initialize API return status to success
2159: x_return_status := FND_API.G_RET_STS_SUCCESS;
2160:

Line 2308: FND_MSG_PUB.Add;

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
2312: (application => 'AR', name => 'AR_RA_AMT_EXCEEDS_AVAIL_REV');

Line 2315: FND_MSG_PUB.Add;

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
2318: IF (SQLCODE = -20001)
2319: THEN

Line 2344: FND_MSG_PUB.Count_And_Get

2340: THEN
2341: COMMIT WORK;
2342: END IF;
2343: -- Standard call to get message count and if count is 1, get message info.
2344: FND_MSG_PUB.Count_And_Get
2345: (p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data);
2348: IF PG_DEBUG in ('Y', 'C') THEN

Line 2355: FND_MSG_PUB.Count_And_Get

2351: EXCEPTION
2352: WHEN FND_API.G_EXC_ERROR THEN
2353: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2354: x_return_status := FND_API.G_RET_STS_ERROR ;
2355: FND_MSG_PUB.Count_And_Get
2356: (p_encoded => FND_API.G_FALSE,
2357: p_count => x_msg_count,
2358: p_data => x_msg_data);
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2366: FND_MSG_PUB.Count_And_Get

2362: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2363: END IF;
2364: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: FND_MSG_PUB.Count_And_Get
2367: (p_encoded => FND_API.G_FALSE,
2368: p_count => x_msg_count,
2369: p_data => x_msg_data);
2370: WHEN OTHERS THEN

Line 2384: IF FND_MSG_PUB.Check_Msg_Level

2380: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2381: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2382: END IF;
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2384: IF FND_MSG_PUB.Check_Msg_Level
2385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg
2388: ( G_PKG_NAME ,

Line 2385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2381: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2382: END IF;
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2384: IF FND_MSG_PUB.Check_Msg_Level
2385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg
2388: ( G_PKG_NAME ,
2389: l_api_name

Line 2387: FND_MSG_PUB.Add_Exc_Msg

2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2384: IF FND_MSG_PUB.Check_Msg_Level
2385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2386: THEN
2387: FND_MSG_PUB.Add_Exc_Msg
2388: ( G_PKG_NAME ,
2389: l_api_name
2390: );
2391: END IF;

Line 2394: FND_MSG_PUB.Count_And_Get

2390: );
2391: END IF;
2392: END IF;
2393: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2394: FND_MSG_PUB.Count_And_Get
2395: (p_encoded => FND_API.G_FALSE,
2396: p_count => x_msg_count,
2397: p_data => x_msg_data);
2398: END Add_Non_Revenue_Sales_Credits;

Line 2618: FND_MSG_PUB.Add;

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;
2622: END IF;

Line 3234: FND_MSG_PUB.Add;

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:
3238: --

Line 3284: FND_MSG_PUB.Add;

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;
3288: FND_MESSAGE.SET_NAME(application => 'AR',

Line 3287: FND_MSG_PUB.Add;

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;
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;

Line 3291: FND_MSG_PUB.Add;

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)
3295: THEN

Line 3626: FND_MSG_PUB.Add;

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;
3630: FND_MESSAGE.SET_NAME(application => 'AR',

Line 3629: FND_MSG_PUB.Add;

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;
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;

Line 3633: FND_MSG_PUB.Add;

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)
3637: THEN

Line 3891: FND_MSG_PUB.Add;

3887: END IF;
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;

Line 3895: FND_MSG_PUB.Add;

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)
3899: THEN

Line 4174: FND_MSG_PUB.initialize;

4170: END IF;
4171: -- Initialize message list if p_init_msg_list is set to TRUE.
4172: IF FND_API.to_Boolean( p_init_msg_list )
4173: THEN
4174: FND_MSG_PUB.initialize;
4175: END IF;
4176: -- Initialize API return status to success
4177: x_return_status := FND_API.G_RET_STS_SUCCESS;
4178:

Line 4407: FND_MSG_PUB.Add;

4403: END LOOP; -- c_lines_to loop
4404:
4405: EXCEPTION
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');

Line 4412: 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
4415: FND_MESSAGE.SET_NAME (application => 'AR',
4416: name => 'AR_RA_TAX_TREATMENTS_VARY');

Line 4417: 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
4420: IF (SQLCODE = -20001)
4421: THEN

Line 4445: FND_MSG_PUB.Count_And_Get

4441: THEN
4442: COMMIT WORK;
4443: END IF;
4444: -- Standard call to get message count and if count is 1, get message info.
4445: FND_MSG_PUB.Count_And_Get
4446: (p_encoded => FND_API.G_FALSE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data);
4449: IF PG_DEBUG in ('Y', 'C') THEN

Line 4456: FND_MSG_PUB.Count_And_Get

4452: EXCEPTION
4453: WHEN FND_API.G_EXC_ERROR THEN
4454: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4455: x_return_status := FND_API.G_RET_STS_ERROR ;
4456: FND_MSG_PUB.Count_And_Get
4457: (p_encoded => FND_API.G_FALSE,
4458: p_count => x_msg_count,
4459: p_data => x_msg_data);
4460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4467: FND_MSG_PUB.Count_And_Get

4463: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4464: END IF;
4465: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4467: FND_MSG_PUB.Count_And_Get
4468: (p_encoded => FND_API.G_FALSE,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data);
4471: WHEN OTHERS THEN

Line 4485: IF FND_MSG_PUB.Check_Msg_Level

4481: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4482: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4483: END IF;
4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4487: THEN
4488: FND_MSG_PUB.Add_Exc_Msg
4489: ( G_PKG_NAME ,

Line 4486: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4482: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4483: END IF;
4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4487: THEN
4488: FND_MSG_PUB.Add_Exc_Msg
4489: ( G_PKG_NAME ,
4490: l_api_name

Line 4488: FND_MSG_PUB.Add_Exc_Msg

4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4487: THEN
4488: FND_MSG_PUB.Add_Exc_Msg
4489: ( G_PKG_NAME ,
4490: l_api_name
4491: );
4492: END IF;

Line 4495: FND_MSG_PUB.Count_And_Get

4491: );
4492: END IF;
4493: END IF;
4494: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4495: FND_MSG_PUB.Count_And_Get
4496: (p_encoded => FND_API.G_FALSE,
4497: p_count => x_msg_count,
4498: p_data => x_msg_data);
4499:

Line 4908: FND_MSG_PUB.Add;

4904:
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;

Line 4912: FND_MSG_PUB.Add;

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)
4916: THEN

Line 5342: FND_MSG_PUB.Add;

5338: END IF;
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;

Line 5346: FND_MSG_PUB.Add;

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)
5350: THEN