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.PSB_BUDGET_REVISIONS_PVT dependencies on FND_MSG_PUB

Line 262: FND_MSG_PUB.initialize;

258:
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260:
261: if FND_API.to_Boolean (p_init_msg_list) THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265: -- Perform the delete
266:

Line 278: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

274: p_return_status := FND_API.G_RET_STS_SUCCESS;
275:
276: -- Standard call to get message count and if count is 1, get message info.
277:
278: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
279: p_data => p_msg_data);
280:
281: -- Standard check of p_commit.
282:

Line 294: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

290: WHEN FND_API.G_EXC_ERROR THEN
291: rollback to DELETE_ROW;
292: p_return_status := FND_API.G_RET_STS_ERROR;
293:
294: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
295: p_data => p_msg_data);
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: rollback to DELETE_ROW;

Line 301: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: rollback to DELETE_ROW;
299: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300:
301: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
302: p_data => p_msg_data);
303:
304: WHEN OTHERS THEN
305: rollback to DELETE_ROW;

Line 308: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

304: WHEN OTHERS THEN
305: rollback to DELETE_ROW;
306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307:
308: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
310: l_api_name);
311: END IF;
312:

Line 309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

305: rollback to DELETE_ROW;
306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307:
308: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
310: l_api_name);
311: END IF;
312:
313: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 313: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
310: l_api_name);
311: END IF;
312:
313: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
314: p_data => p_msg_data);
315:
316: END Delete_Row;
317:

Line 417: FND_MSG_PUB.initialize;

413:
414: -- Initialize message list if p_init_msg_list is set to TRUE.
415:
416: IF FND_API.to_Boolean (p_init_msg_list) THEN
417: FND_MSG_PUB.initialize;
418: END IF;
419:
420: if p_budget_revision_id is not null then
421:

Line 636: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

632: END IF;
633:
634: -- Standard call to get message count and if count is 1, get message info.
635:
636: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
637: p_data => p_msg_data);
638:
639: EXCEPTION
640:

Line 644: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

640:
641: WHEN FND_API.G_EXC_ERROR THEN
642: rollback to Create_Budget_Revision;
643: p_return_status := FND_API.G_RET_STS_ERROR;
644: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
645: p_data => p_msg_data);
646:
647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
648: rollback to Create_Budget_Revision;

Line 650: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

646:
647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
648: rollback to Create_Budget_Revision;
649: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
651: p_data => p_msg_data);
652:
653: WHEN OTHERS THEN
654: rollback to Create_Budget_Revision;

Line 657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

653: WHEN OTHERS THEN
654: rollback to Create_Budget_Revision;
655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656:
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
658: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
659: l_api_name);
660: END IF;
661:

Line 658: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

654: rollback to Create_Budget_Revision;
655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656:
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
658: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
659: l_api_name);
660: END IF;
661:
662: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 662: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

658: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
659: l_api_name);
660: END IF;
661:
662: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
663: p_data => p_msg_data);
664: END Create_Budget_Revision;
665:
666: /* ----------------------------------------------------------------------- */

Line 971: FND_MSG_PUB.initialize;

967: END IF;
968:
969: -- Initialize message list if p_init_msg_list is set to TRUE.
970: IF FND_API.to_Boolean (p_init_msg_list) THEN
971: FND_MSG_PUB.initialize;
972: END IF;
973:
974: Cache_Revision_Variables
975: ( p_return_status => l_return_status,

Line 1182: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1178: p_return_status := FND_API.G_RET_STS_SUCCESS;
1179:
1180: -- Standard call to get message count and if count is 1, get message info.
1181:
1182: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1183: p_data => p_msg_data);
1184:
1185: EXCEPTION
1186:

Line 1190: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1186:
1187: when FND_API.G_EXC_ERROR then
1188: p_return_status := FND_API.G_RET_STS_ERROR;
1189:
1190: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1191: p_data => p_msg_data);
1192:
1193: when FND_API.G_EXC_UNEXPECTED_ERROR then
1194: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1196: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1192:
1193: when FND_API.G_EXC_UNEXPECTED_ERROR then
1194: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195:
1196: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1197: p_data => p_msg_data);
1198:
1199: when OTHERS then
1200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

1198:
1199: when OTHERS then
1200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1204: l_api_name);
1205: end if;
1206:

Line 1203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1199: when OTHERS then
1200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1204: l_api_name);
1205: end if;
1206:
1207: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1207: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1204: l_api_name);
1205: end if;
1206:
1207: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1208: p_data => p_msg_data);
1209:
1210: End Create_Revision_Accounts;
1211:

Line 1633: FND_MSG_PUB.initialize;

1629:
1630: -- Initialize message list if p_init_msg_list is set to TRUE.
1631:
1632: IF FND_API.to_Boolean (p_init_msg_list) THEN
1633: FND_MSG_PUB.initialize;
1634: END IF;
1635:
1636: /* Bug 3029168 Start */
1637: IF p_event_type = 'SW' THEN

Line 1771: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1767: END IF;
1768:
1769: -- Standard call to get message count and if count is 1, get message info.
1770:
1771: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1772: p_data => p_msg_data);
1773:
1774:
1775: EXCEPTION

Line 1781: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1777: WHEN FND_API.G_EXC_ERROR THEN
1778: rollback to CREATE_BASE_BUDGET_REVISIONS;
1779: p_return_status := FND_API.G_RET_STS_ERROR;
1780:
1781: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1782: p_data => p_msg_data);
1783:
1784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1785: rollback to CREATE_BASE_BUDGET_REVISIONS;

Line 1788: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1785: rollback to CREATE_BASE_BUDGET_REVISIONS;
1786: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787:
1788: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1789: p_data => p_msg_data);
1790:
1791: WHEN OTHERS THEN
1792: rollback to CREATE_BASE_BUDGET_REVISIONS;

Line 1795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1791: WHEN OTHERS THEN
1792: rollback to CREATE_BASE_BUDGET_REVISIONS;
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794:
1795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1797: l_api_name);
1798: END IF;
1799:

Line 1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1792: rollback to CREATE_BASE_BUDGET_REVISIONS;
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794:
1795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1797: l_api_name);
1798: END IF;
1799:
1800: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1800: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1797: l_api_name);
1798: END IF;
1799:
1800: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1801: p_data => p_msg_data);
1802:
1803: END Create_Base_Budget_Revision;
1804:

Line 2055: /* FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data

2051:
2052: EXCEPTION
2053: WHEN FND_API.G_EXC_ERROR THEN
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: /* FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data
2056: );*/
2057:
2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2059: ROLLBACK TO Budget_Revision_Funds_Check;

Line 2061: /* FND_MSG_PUB.Count_And_Get (p_count => p_msg_count, p_data => p_msg_data);*/

2057:
2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2059: ROLLBACK TO Budget_Revision_Funds_Check;
2060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2061: /* FND_MSG_PUB.Count_And_Get (p_count => p_msg_count, p_data => p_msg_data);*/
2062:
2063: WHEN OTHERS THEN
2064: ROLLBACK TO Budget_Revision_Funds_Check;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2066: /* FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);

2062:
2063: WHEN OTHERS THEN
2064: ROLLBACK TO Budget_Revision_Funds_Check;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: /* FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
2067:
2068: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2069: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2070: END IF;*/

Line 2068: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2064: ROLLBACK TO Budget_Revision_Funds_Check;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: /* FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
2067:
2068: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2069: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2070: END IF;*/
2071: END;
2072:

Line 2069: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: /* FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
2067:
2068: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2069: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2070: END IF;*/
2071: END;
2072:
2073: /*==========================================================================+

Line 2200: FND_MSG_PUB.initialize;

2196: END IF;
2197:
2198: -- Initialize message list if p_init_msg_list is set to TRUE.
2199: if FND_API.to_Boolean (p_init_msg_list) then
2200: FND_MSG_PUB.initialize;
2201: end if;
2202:
2203: -- Initialize global variables.
2204: Cache_Revision_Variables(p_budget_revision_id => p_budget_revision_id,

Line 2369: FND_MSG_PUB.Add;

2365: )
2366: THEN
2367: -- Bug#4310411 End
2368: Savepoint Budget_Revision_Funds_Check;
2369: FND_MSG_PUB.Add;
2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371: end if;
2372:
2373: p_fund_check_failures := 0;

Line 2424: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2420: ROLLBACK TO Budget_Revision_Funds_Check;
2421: l_sql_code := sqlcode;
2422: l_sql_errm := sqlerrm;
2423: p_return_status := FND_API.G_RET_STS_ERROR;
2424: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2425: p_data => p_msg_data);
2426:
2427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2428: l_sql_code := sqlcode;

Line 2432: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2428: l_sql_code := sqlcode;
2429: l_sql_errm := sqlerrm;
2430: ROLLBACK TO Budget_Revision_Funds_Check;
2431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2432: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2433: p_data => p_msg_data);
2434:
2435: WHEN OTHERS THEN
2436: l_sql_code := sqlcode;

Line 2441: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2437: l_sql_errm := sqlerrm;
2438: ROLLBACK TO Budget_Revision_Funds_Check;
2439: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440:
2441: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2442: p_data => p_msg_data);
2443:
2444: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2445: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

Line 2444: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

2440:
2441: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2442: p_data => p_msg_data);
2443:
2444: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2445: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2446: l_api_name);
2447: end if;
2448:

Line 2445: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

2441: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2442: p_data => p_msg_data);
2443:
2444: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2445: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2446: l_api_name);
2447: end if;
2448:
2449: End Budget_Revision_Funds_Check;

Line 3258: FND_MSG_PUB.initialize;

3254:
3255: -- Initialize message list if p_init_msg_list is set to TRUE.
3256:
3257: if FND_API.to_Boolean (p_init_msg_list) then
3258: FND_MSG_PUB.initialize;
3259: end if;
3260:
3261: -- Initialize global variables.
3262:

Line 3670: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3666: end if;
3667:
3668: -- Standard call to get message count and if count is 1, get message info.
3669:
3670: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3671: p_data => p_msg_data);
3672:
3673: EXCEPTION
3674:

Line 3679: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3675: when FND_API.G_EXC_ERROR then
3676: rollback to Create_Mass_Revision_Entries;
3677: p_return_status := FND_API.G_RET_STS_ERROR;
3678:
3679: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3680: p_data => p_msg_data);
3681:
3682: when FND_API.G_EXC_UNEXPECTED_ERROR then
3683: rollback to Create_Mass_Revision_Entries;

Line 3686: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3682: when FND_API.G_EXC_UNEXPECTED_ERROR then
3683: rollback to Create_Mass_Revision_Entries;
3684: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3685:
3686: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3687: p_data => p_msg_data);
3688:
3689: when OTHERS then
3690: rollback to Create_Mass_Revision_Entries;

Line 3693: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

3689: when OTHERS then
3690: rollback to Create_Mass_Revision_Entries;
3691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692:
3693: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3694:
3695: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3696: l_api_name);
3697: end if;

Line 3695: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

3691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3692:
3693: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3694:
3695: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3696: l_api_name);
3697: end if;
3698:
3699: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 3699: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3695: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3696: l_api_name);
3697: end if;
3698:
3699: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3700: p_data => p_msg_data);
3701:
3702: END Create_Mass_Revision_Entries;
3703:

Line 3921: FND_MSG_PUB.initialize;

3917:
3918: -- Initialize message list if p_init_msg_list is set to TRUE.
3919:
3920: IF FND_API.to_Boolean (p_init_msg_list) THEN
3921: FND_MSG_PUB.initialize;
3922: END IF;
3923:
3924: update PSB_BUDGET_REVISION_POSITIONS brp
3925: set budget_group_id = p_budget_group_id,

Line 4217: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4213: end if;
4214:
4215: -- Standard call to get message count and if count is 1, get message info.
4216:
4217: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4218: p_data => p_msg_data);
4219:
4220: EXCEPTION
4221:

Line 4226: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4222: when FND_API.G_EXC_ERROR then
4223: rollback to Create_Revision_Positions;
4224: p_return_status := FND_API.G_RET_STS_ERROR;
4225:
4226: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4227: p_data => p_msg_data);
4228:
4229: when FND_API.G_EXC_UNEXPECTED_ERROR then
4230: rollback to Create_Revision_Positions;

Line 4233: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4229: when FND_API.G_EXC_UNEXPECTED_ERROR then
4230: rollback to Create_Revision_Positions;
4231: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4232:
4233: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4234: p_data => p_msg_data);
4235:
4236: when OTHERS then
4237: rollback to Create_Revision_Positions;

Line 4240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

4236: when OTHERS then
4237: rollback to Create_Revision_Positions;
4238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4239:
4240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4242: l_api_name);
4243: end if;
4244:

Line 4241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4237: rollback to Create_Revision_Positions;
4238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4239:
4240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4242: l_api_name);
4243: end if;
4244:
4245: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 4245: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4242: l_api_name);
4243: end if;
4244:
4245: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4246: p_data => p_msg_data);
4247:
4248: End Create_Revision_Positions;
4249:

Line 4726: FND_MSG_PUB.initialize;

4722:
4723: -- Initialize message list if p_init_msg_list is set to TRUE.
4724:
4725: if FND_API.to_Boolean (p_init_msg_list) THEN
4726: FND_MSG_PUB.initialize;
4727: END IF;
4728:
4729: Cache_Revision_Variables(p_budget_revision_id => p_budget_revision_id,
4730: p_return_status => l_return_status);

Line 5017: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

5013: END IF;
5014:
5015: -- Standard call to get message count and if count is 1, get message info.
5016:
5017: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5018: p_data => p_msg_data);
5019:
5020: p_return_status := FND_API.G_RET_STS_SUCCESS;
5021:

Line 5030: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

5026: -- rollback to Update_Baseline_Values;
5027: /* Bug No 2532617 End */
5028: p_return_status := FND_API.G_RET_STS_ERROR;
5029:
5030: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5031: p_data => p_msg_data);
5032:
5033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5034: /* Bug No 2532617 Start */

Line 5039: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

5035: -- rollback to Update_Baseline_Values;
5036: /* Bug No 2532617 End */
5037: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5038:
5039: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5040: p_data => p_msg_data);
5041:
5042: WHEN OTHERS THEN
5043: /* Bug No 2532617 Start */

Line 5048: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5044: -- rollback to Update_Baseline_Values;
5045: /* Bug No 2532617 End */
5046: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5047:
5048: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5050: l_api_name);
5051: END IF;
5052:

Line 5049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5045: /* Bug No 2532617 End */
5046: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5047:
5048: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5050: l_api_name);
5051: END IF;
5052:
5053: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 5053: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

5049: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5050: l_api_name);
5051: END IF;
5052:
5053: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5054: p_data => p_msg_data);
5055:
5056: End Update_Baseline_Values;
5057:

Line 5238: FND_MSG_PUB.initialize;

5234: END IF;
5235:
5236: -- Initialize message list if p_init_msg_list is set to TRUE.
5237: IF FND_API.to_Boolean (p_init_msg_list) THEN
5238: FND_MSG_PUB.initialize;
5239: END IF;
5240:
5241: -- Find base FTE for the position.
5242: FOR l_base_fte_rec IN l_base_fte_csr LOOP

Line 5329: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

5325: -- Initialize API return status to success
5326: p_return_status := FND_API.G_RET_STS_SUCCESS;
5327:
5328: -- Standard call to get message count and if count is 1, get message info.
5329: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5330: p_data => p_msg_data);
5331: --
5332: EXCEPTION
5333: when OTHERS then

Line 5336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

5332: EXCEPTION
5333: when OTHERS then
5334: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5335:
5336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5337: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5338: l_api_name);
5339: end if;
5340:

Line 5337: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5333: when OTHERS then
5334: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5335:
5336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5337: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5338: l_api_name);
5339: end if;
5340:
5341: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 5341: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

5337: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5338: l_api_name);
5339: end if;
5340:
5341: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5342: p_data => p_msg_data);
5343: End Find_FTE;
5344: /*---------------------------------------------------------------------------*/
5345:

Line 6001: FND_MSG_PUB.Add;

5997: combination_id => PSB_WS_POS1.g_salary_dist(l_saldist_index).ccid,
5998: n_segments => PSB_WS_ACCT1.g_num_segs,
5999: segments => l_ccid_val) then
6000:
6001: FND_MSG_PUB.Add;
6002: raise FND_API.G_EXC_ERROR;
6003: end if;
6004:
6005: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop

Line 6142: FND_MSG_PUB.Add;

6138: n_segments => PSB_WS_ACCT1.g_num_segs,
6139: segments => l_seg_val,
6140: combination_id => l_ccid) then
6141:
6142: FND_MSG_PUB.Add;
6143: raise FND_API.G_EXC_ERROR;
6144: end if;
6145:
6146:

Line 7334: -- Added call to FND_MSG_PUB.Count_And_Get()

7330: p_return_status := FND_API.G_RET_STS_SUCCESS;
7331:
7332: EXCEPTION
7333: -- Fix for Bug:3337401
7334: -- Added call to FND_MSG_PUB.Count_And_Get()
7335:
7336: when FND_API.G_EXC_ERROR then
7337: p_return_status := FND_API.G_RET_STS_ERROR;
7338: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 7338: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

7334: -- Added call to FND_MSG_PUB.Count_And_Get()
7335:
7336: when FND_API.G_EXC_ERROR then
7337: p_return_status := FND_API.G_RET_STS_ERROR;
7338: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7339: p_data => p_msg_data);
7340:
7341: when FND_API.G_EXC_UNEXPECTED_ERROR then
7342: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

7339: p_data => p_msg_data);
7340:
7341: when FND_API.G_EXC_UNEXPECTED_ERROR then
7342: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7344: p_data => p_msg_data);
7345:
7346: when OTHERS then
7347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7348: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

7344: p_data => p_msg_data);
7345:
7346: when OTHERS then
7347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7348: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7349: p_data => p_msg_data);
7350:
7351: End Calculate_Position_Cost;
7352:

Line 7959: l_description := FND_MSG_PUB.Get

7955: end if;
7956:
7957: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
7958:
7959: l_description := FND_MSG_PUB.Get
7960: (p_encoded => FND_API.G_FALSE);
7961: FND_MSG_PUB.Delete_Msg;
7962:
7963: -- Constraint Validation failures are logged in PSB_ERROR_MESSAGES and

Line 7961: FND_MSG_PUB.Delete_Msg;

7957: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
7958:
7959: l_description := FND_MSG_PUB.Get
7960: (p_encoded => FND_API.G_FALSE);
7961: FND_MSG_PUB.Delete_Msg;
7962:
7963: -- Constraint Validation failures are logged in PSB_ERROR_MESSAGES and
7964: -- viewed using a Form
7965:

Line 8468: l_description := FND_MSG_PUB.Get

8464: message_token('FORMULA_VALUE', l_grade_name || ' ' || l_grade_step);
8465: message_token('NAME', p_position_name);
8466: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8467:
8468: l_description := FND_MSG_PUB.Get
8469: (p_encoded => FND_API.G_FALSE);
8470: FND_MSG_PUB.Delete_Msg;
8471:
8472: insert into PSB_ERROR_MESSAGES

Line 8470: FND_MSG_PUB.Delete_Msg;

8466: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8467:
8468: l_description := FND_MSG_PUB.Get
8469: (p_encoded => FND_API.G_FALSE);
8470: FND_MSG_PUB.Delete_Msg;
8471:
8472: insert into PSB_ERROR_MESSAGES
8473: (Concurrent_Request_ID,
8474: Process_ID,

Line 8552: l_description := FND_MSG_PUB.Get

8548: message_token('FORMULA_VALUE', l_grade_name || ' ' || l_grade_step);
8549: message_token('NAME', c_SalaryNeqAll_Rec.position_name);
8550: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8551:
8552: l_description := FND_MSG_PUB.Get
8553: (p_encoded => FND_API.G_FALSE);
8554: FND_MSG_PUB.Delete_Msg;
8555:
8556: insert into PSB_ERROR_MESSAGES

Line 8554: FND_MSG_PUB.Delete_Msg;

8550: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8551:
8552: l_description := FND_MSG_PUB.Get
8553: (p_encoded => FND_API.G_FALSE);
8554: FND_MSG_PUB.Delete_Msg;
8555:
8556: insert into PSB_ERROR_MESSAGES
8557: (Concurrent_Request_ID,
8558: Process_ID,

Line 8675: l_description := FND_MSG_PUB.Get

8671: end if;
8672:
8673: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8674:
8675: l_description := FND_MSG_PUB.Get
8676: (p_encoded => FND_API.G_FALSE);
8677: FND_MSG_PUB.Delete_Msg;
8678:
8679: insert into PSB_ERROR_MESSAGES

Line 8677: FND_MSG_PUB.Delete_Msg;

8673: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8674:
8675: l_description := FND_MSG_PUB.Get
8676: (p_encoded => FND_API.G_FALSE);
8677: FND_MSG_PUB.Delete_Msg;
8678:
8679: insert into PSB_ERROR_MESSAGES
8680: (Concurrent_Request_ID,
8681: Process_ID,

Line 8950: l_description := FND_MSG_PUB.Get

8946: end if;
8947:
8948: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8949:
8950: l_description := FND_MSG_PUB.Get
8951: (p_encoded => FND_API.G_FALSE);
8952: FND_MSG_PUB.Delete_Msg;
8953:
8954: insert into PSB_ERROR_MESSAGES

Line 8952: FND_MSG_PUB.Delete_Msg;

8948: add_message('PSB', 'PSB_REV_CONSTRAINT_FAILURE');
8949:
8950: l_description := FND_MSG_PUB.Get
8951: (p_encoded => FND_API.G_FALSE);
8952: FND_MSG_PUB.Delete_Msg;
8953:
8954: insert into PSB_ERROR_MESSAGES
8955: (Concurrent_Request_ID,
8956: Process_ID,

Line 9361: if FND_MSG_PUB.Check_Msg_Level

9357:
9358: when OTHERS then
9359: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9360:
9361: if FND_MSG_PUB.Check_Msg_Level
9362: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9363: FND_MSG_PUB.Add_Exc_Msg
9364: (p_pkg_name => G_PKG_NAME,
9365: p_procedure_name => l_api_name);

Line 9362: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

9358: when OTHERS then
9359: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9360:
9361: if FND_MSG_PUB.Check_Msg_Level
9362: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9363: FND_MSG_PUB.Add_Exc_Msg
9364: (p_pkg_name => G_PKG_NAME,
9365: p_procedure_name => l_api_name);
9366:

Line 9363: FND_MSG_PUB.Add_Exc_Msg

9359: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9360:
9361: if FND_MSG_PUB.Check_Msg_Level
9362: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9363: FND_MSG_PUB.Add_Exc_Msg
9364: (p_pkg_name => G_PKG_NAME,
9365: p_procedure_name => l_api_name);
9366:
9367: end if;

Line 9422: FND_MSG_PUB.initialize;

9418:
9419: -- Initialize message list if p_init_msg_list is set to TRUE.
9420:
9421: IF FND_API.to_Boolean (p_init_msg_list) THEN
9422: FND_MSG_PUB.initialize;
9423: END IF;
9424:
9425: Cache_Revision_Variables
9426: (p_return_status => l_return_status,

Line 9480: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9476: p_return_status := FND_API.G_RET_STS_SUCCESS;
9477:
9478: -- Standard call to get message count and if count is 1, get message info.
9479:
9480: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9481: p_data => p_msg_data);
9482:
9483: EXCEPTION
9484:

Line 9488: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9484:
9485: when FND_API.G_EXC_ERROR then
9486: p_return_status := FND_API.G_RET_STS_ERROR;
9487:
9488: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9489: p_data => p_msg_data);
9490:
9491: when FND_API.G_EXC_UNEXPECTED_ERROR then
9492: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9494: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9490:
9491: when FND_API.G_EXC_UNEXPECTED_ERROR then
9492: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9493:
9494: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9495: p_data => p_msg_data);
9496:
9497: when OTHERS then
9498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

9496:
9497: when OTHERS then
9498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9499:
9500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9501: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
9502: l_api_name);
9503: end if;
9504:

Line 9501: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

9497: when OTHERS then
9498: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9499:
9500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9501: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
9502: l_api_name);
9503: end if;
9504:
9505: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 9505: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9501: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
9502: l_api_name);
9503: end if;
9504:
9505: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9506: p_data => p_msg_data);
9507:
9508: End Delete_Revision_Positions;
9509:

Line 9563: FND_MSG_PUB.initialize;

9559:
9560: -- Initialize message list if p_init_msg_list is set to TRUE.
9561:
9562: IF FND_API.to_Boolean (p_init_msg_list) THEN
9563: FND_MSG_PUB.initialize;
9564: END IF;
9565:
9566: -- Initialize API return status to success
9567:

Line 9601: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9597: end if;
9598:
9599: -- Standard call to get message count and if count is 1, get message info.
9600:
9601: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9602: p_data => p_msg_data);
9603:
9604: EXCEPTION
9605:

Line 9609: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9605:
9606: when FND_API.G_EXC_ERROR then
9607: p_return_status := FND_API.G_RET_STS_ERROR;
9608:
9609: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9610: p_data => p_msg_data);
9611:
9612: when FND_API.G_EXC_UNEXPECTED_ERROR then
9613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9615: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9611:
9612: when FND_API.G_EXC_UNEXPECTED_ERROR then
9613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9614:
9615: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9616: p_data => p_msg_data);
9617:
9618: when OTHERS then
9619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9621: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

9617:
9618: when OTHERS then
9619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9620:
9621: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9622:
9623: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
9624: l_api_name);
9625: end if;

Line 9623: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

9619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9620:
9621: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9622:
9623: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
9624: l_api_name);
9625: end if;
9626:
9627: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 9627: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

9623: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
9624: l_api_name);
9625: end if;
9626:
9627: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9628: p_data => p_msg_data);
9629:
9630: End Delete_Revision_Accounts;
9631:

Line 9897: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9893: WHEN OTHERS THEN
9894: --
9895: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9896: --
9897: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9898: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9899: l_api_name );
9900: END IF;
9901: --

Line 9898: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

9894: --
9895: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9896: --
9897: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9898: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9899: l_api_name );
9900: END IF;
9901: --
9902: END Delete_Budget_Revision_Pvt ;

Line 9951: FND_MSG_PUB.initialize ;

9947: END IF;
9948: --
9949:
9950: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
9951: FND_MSG_PUB.initialize ;
9952: END IF;
9953: --
9954: p_return_status := FND_API.G_RET_STS_SUCCESS ;
9955: --

Line 10137: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10133: IF FND_API.To_Boolean ( p_commit ) THEN
10134: COMMIT WORK;
10135: END IF;
10136: --
10137: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10138: p_data => p_msg_data );
10139: --
10140: EXCEPTION
10141: --

Line 10146: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10142: WHEN FND_API.G_EXC_ERROR THEN
10143: --
10144: ROLLBACK TO Delete_Budget_Revision ;
10145: p_return_status := FND_API.G_RET_STS_ERROR;
10146: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10147: p_data => p_msg_data );
10148: --
10149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10150: --

Line 10153: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10150: --
10151: ROLLBACK TO Delete_Budget_Revision ;
10152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10153: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10154: p_data => p_msg_data );
10155: --
10156: WHEN OTHERS THEN
10157: --

Line 10161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

10157: --
10158: ROLLBACK TO Delete_Budget_Revision ;
10159: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10160: --
10161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10162: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
10163: l_api_name);
10164: END if;
10165: --

Line 10162: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

10158: ROLLBACK TO Delete_Budget_Revision ;
10159: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10160: --
10161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10162: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
10163: l_api_name);
10164: END if;
10165: --
10166: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 10166: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

10162: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
10163: l_api_name);
10164: END if;
10165: --
10166: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
10167: p_data => p_msg_data );
10168: --
10169: END Delete_Budget_Revision ;
10170:

Line 10307: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

10303: COMMIT WORK ;
10304: --
10305: WHEN OTHERS THEN
10306: --
10307: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10308: --
10309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10310: l_api_name ) ;
10311: END IF ;

Line 10309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

10305: WHEN OTHERS THEN
10306: --
10307: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10308: --
10309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10310: l_api_name ) ;
10311: END IF ;
10312: --
10313: l_return_status := FND_API.G_RET_STS_ERROR;

Line 10400: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

10396: COMMIT WORK ;
10397: --
10398: WHEN OTHERS THEN
10399: --
10400: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10401: --
10402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10403: l_api_name ) ;
10404: END IF ;

Line 10402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

10398: WHEN OTHERS THEN
10399: --
10400: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10401: --
10402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10403: l_api_name ) ;
10404: END IF ;
10405: --
10406: l_return_status := FND_API.G_RET_STS_ERROR;

Line 10549: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

10545: COMMIT WORK ;
10546: --
10547: WHEN OTHERS THEN
10548: --
10549: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10550: --
10551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10552: l_api_name ) ;
10553: END IF ;

Line 10551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

10547: WHEN OTHERS THEN
10548: --
10549: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10550: --
10551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10552: l_api_name ) ;
10553: END IF ;
10554: --
10555: l_return_status := FND_API.G_RET_STS_ERROR;

Line 10676: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

10672: --
10673: WHEN OTHERS THEN
10674: --
10675: ROLLBACK TO Delete_Budget_Revision_CP_Pvt ;
10676: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10677: --
10678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10679: l_api_name ) ;
10680: END IF ;

Line 10678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

10674: --
10675: ROLLBACK TO Delete_Budget_Revision_CP_Pvt ;
10676: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10677: --
10678: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
10679: l_api_name ) ;
10680: END IF ;
10681: --
10682: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 10735: FND_MSG_PUB.Add;

10731: end loop;
10732:
10733: end if;
10734:
10735: FND_MSG_PUB.Add;
10736:
10737: end if;
10738:
10739: -- Clear Message Token stack

Line 11030: l_description := FND_MSG_PUB.Get

11026: message_token('RULNAME', c_Brrule_Rec.name);
11027: message_token('RULETYPE', c_Brrule_Rec.rule_type);
11028: add_message('PSB', 'PSB_REVISION_RULE_VIOLATION');
11029:
11030: l_description := FND_MSG_PUB.Get
11031: (p_encoded => FND_API.G_FALSE);
11032: FND_MSG_PUB.Delete_Msg;
11033:
11034: /*For Bug No : 2150471 Start*/

Line 11032: FND_MSG_PUB.Delete_Msg;

11028: add_message('PSB', 'PSB_REVISION_RULE_VIOLATION');
11029:
11030: l_description := FND_MSG_PUB.Get
11031: (p_encoded => FND_API.G_FALSE);
11032: FND_MSG_PUB.Delete_Msg;
11033:
11034: /*For Bug No : 2150471 Start*/
11035: l_apply_message := NULL;
11036: l_balance_message := NULL;

Line 11053: l_apply_message := FND_MSG_PUB.Get

11049:
11050: l_description := l_description||l_apply_message;
11051: IF (c_Brrule_Rec.rule_type ='BALANCE') THEN
11052: add_message('PSB', 'PSB_REV_RULE_BALANCE_ACCTS');
11053: l_apply_message := FND_MSG_PUB.Get
11054: (p_encoded => FND_API.G_FALSE);
11055: FND_MSG_PUB.Delete_Msg;
11056: l_description := l_description||fnd_global.local_chr(10)||l_apply_message||l_balance_message;
11057: END IF;

Line 11055: FND_MSG_PUB.Delete_Msg;

11051: IF (c_Brrule_Rec.rule_type ='BALANCE') THEN
11052: add_message('PSB', 'PSB_REV_RULE_BALANCE_ACCTS');
11053: l_apply_message := FND_MSG_PUB.Get
11054: (p_encoded => FND_API.G_FALSE);
11055: FND_MSG_PUB.Delete_Msg;
11056: l_description := l_description||fnd_global.local_chr(10)||l_apply_message||l_balance_message;
11057: END IF;
11058: /*For Bug No : 2150471 End*/
11059:

Line 11825: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

11821: EXCEPTION
11822:
11823: when FND_API.G_EXC_ERROR then
11824: p_return_status := FND_API.G_RET_STS_ERROR;
11825: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
11826: p_data => l_msg_data);
11827:
11828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11829: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11830: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

11826: p_data => l_msg_data);
11827:
11828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11829: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11830: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
11831: p_data => l_msg_data);
11832:
11833: WHEN OTHERS THEN
11834: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11836: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

11832:
11833: WHEN OTHERS THEN
11834: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11835:
11836: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
11837: 'Create_Note');
11838:
11839: END Create_Note;
11840: /* Bug No 1808330 End */

Line 11857: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

11853: EXCEPTION
11854: WHEN others THEN
11855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11856:
11857: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
11858: l_api_name);
11859:
11860: END set_position_update_flag;
11861: /* bug no 3439168 */