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

Line 112: FND_MSG_PUB.initialize;

108: begin
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114: IF FND_GLOBAL.User_Id IS NULL THEN
115: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
116: RAISE FND_API.G_EXC_ERROR;

Line 302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

298:
299: WHEN amw_deadlock_detected THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;

Line 307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
313:
314: WHEN OTHERS THEN
315: ROLLBACK;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

313:
314: WHEN OTHERS THEN
315: ROLLBACK;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
320: END IF;
321: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

315: ROLLBACK;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
320: END IF;
321: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
322:
323: end write_amw_process;

Line 321: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
320: END IF;
321: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
322:
323: end write_amw_process;
324:
325:

Line 1139: FND_MSG_PUB.initialize;

1135:
1136: begin
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141: IF FND_GLOBAL.User_Id IS NULL THEN
1142: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1143: RAISE FND_API.G_EXC_ERROR;

Line 1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1198: exception
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1208:
1209: WHEN amw_deadlock_detected THEN
1210: ROLLBACK;
1211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1212: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1208:
1209: WHEN amw_deadlock_detected THEN
1210: ROLLBACK;
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1213:
1214: WHEN OTHERS THEN
1215: ROLLBACK;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1213:
1214: WHEN OTHERS THEN
1215: ROLLBACK;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1220: END IF;
1221: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

1215: ROLLBACK;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1220: END IF;
1221: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1222:
1223: end associate_org_process;

Line 1221: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1220: END IF;
1221: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1222:
1223: end associate_org_process;
1224:
1225: --npanandi commented this on 10/18/2004, for syncing between the version

Line 1256: FND_MSG_PUB.initialize;

1252:
1253: begin
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258: IF FND_GLOBAL.User_Id IS NULL THEN
1259: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1260: RAISE FND_API.G_EXC_ERROR;

Line 1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK;
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1344:
1345: WHEN amw_deadlock_detected THEN
1346: ROLLBACK;
1347: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1344:
1345: WHEN amw_deadlock_detected THEN
1346: ROLLBACK;
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1349:
1350: WHEN OTHERS THEN
1351: ROLLBACK;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1349:
1350: WHEN OTHERS THEN
1351: ROLLBACK;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1354: THEN
1355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1356: END IF;
1357: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

1351: ROLLBACK;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1354: THEN
1355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1356: END IF;
1357: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1358:
1359: end associate_org_process;

Line 1357: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1354: THEN
1355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1356: END IF;
1357: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1358:
1359: end associate_org_process;
1360: **/
1361: ------------------------------------------------------------------------------------------------------------

Line 1461: FND_MSG_PUB.initialize;

1457: begin
1458:
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1461: FND_MSG_PUB.initialize;
1462: END IF;
1463: IF FND_GLOBAL.User_Id IS NULL THEN
1464: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1465: RAISE FND_API.G_EXC_ERROR;

Line 1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1498: exception
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK;
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1508:
1509: WHEN amw_deadlock_detected THEN
1510: ROLLBACK;
1511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1508:
1509: WHEN amw_deadlock_detected THEN
1510: ROLLBACK;
1511: x_return_status := FND_API.G_RET_STS_ERROR;
1512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1513:
1514:
1515: WHEN OTHERS THEN
1516: ROLLBACK;

Line 1518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1514:
1515: WHEN OTHERS THEN
1516: ROLLBACK;
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1519: THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1521: END IF;
1522: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

1516: ROLLBACK;
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1519: THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1521: END IF;
1522: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1523:
1524:

Line 1522: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1519: THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1521: END IF;
1522: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1523:
1524:
1525: end disassociate_process_org;
1526:

Line 1629: FND_MSG_PUB.initialize;

1625:
1626: begin
1627: x_return_status := FND_API.G_RET_STS_SUCCESS;
1628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631: IF FND_GLOBAL.User_Id IS NULL THEN
1632: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1633: RAISE FND_API.G_EXC_ERROR;

Line 1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1769: exception
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1779:
1780: WHEN amw_deadlock_detected THEN
1781: ROLLBACK;
1782: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1779:
1780: WHEN amw_deadlock_detected THEN
1781: ROLLBACK;
1782: x_return_status := FND_API.G_RET_STS_ERROR;
1783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1784:
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1784:
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1789: THEN
1790: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1791: END IF;
1792: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

1786: ROLLBACK;
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1789: THEN
1790: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1791: END IF;
1792: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1793:
1794: end modify_org_relation;

Line 1792: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1789: THEN
1790: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1791: END IF;
1792: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1793:
1794: end modify_org_relation;
1795:
1796:

Line 1848: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_msg_index_out => l_msg_index_out);

1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: ROLLBACK;
1846: retcode := 2;
1847: IF x_msg_count <> 1 THEN
1848: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_msg_index_out => l_msg_index_out);
1849: END IF;
1850: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| x_msg_data);
1851: errbuf := SUBSTR(x_msg_data,1,1000);
1852: ELSE

Line 2027: FND_MSG_PUB.initialize;

2023:
2024: begin
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;
2026: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2027: FND_MSG_PUB.initialize;
2028: END IF;
2029: IF FND_GLOBAL.User_Id IS NULL THEN
2030: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2031: RAISE FND_API.G_EXC_ERROR;

Line 2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2100:
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN amw_deadlock_detected THEN
2112: ROLLBACK;
2113: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2114: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2110:
2111: WHEN amw_deadlock_detected THEN
2112: ROLLBACK;
2113: x_return_status := FND_API.G_RET_STS_ERROR;
2114: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2115:
2116: WHEN OTHERS THEN
2117: ROLLBACK;
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2115:
2116: WHEN OTHERS THEN
2117: ROLLBACK;
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2120: THEN
2121: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2122: END IF;
2123: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

2117: ROLLBACK;
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2120: THEN
2121: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2122: END IF;
2123: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2124:
2125: end refresh_process_org;

Line 2123: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2120: THEN
2121: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2122: END IF;
2123: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2124:
2125: end refresh_process_org;
2126:
2127:

Line 2156: FND_MSG_PUB.initialize;

2152:
2153: begin
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: IF FND_GLOBAL.User_Id IS NULL THEN
2159: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2160: RAISE FND_API.G_EXC_ERROR;

Line 2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2193:
2194: WHEN FND_API.G_EXC_ERROR THEN
2195: ROLLBACK;
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2203:
2204: WHEN amw_deadlock_detected THEN
2205: ROLLBACK;
2206: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2203:
2204: WHEN amw_deadlock_detected THEN
2205: ROLLBACK;
2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2208:
2209: WHEN OTHERS THEN
2210: ROLLBACK;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2208:
2209: WHEN OTHERS THEN
2210: ROLLBACK;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2215: END IF;
2216: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

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

2210: ROLLBACK;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2215: END IF;
2216: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2217:
2218: end refresh_process_org;

Line 2216: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2215: END IF;
2216: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2217:
2218: end refresh_process_org;
2219:
2220:

Line 2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2331:
2332: WHEN amw_deadlock_detected THEN
2333: ROLLBACK;
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2336:
2337: WHEN amw_exception THEN
2338: ROLLBACK;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2346: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2342:
2343: WHEN OTHERS THEN
2344: ROLLBACK;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2347:
2348: end refresh_process_per_org;
2349:
2350:

Line 2414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2410: WHEN OTHERS THEN
2411: ROLLBACK;
2412: p_out := 0;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2415:
2416: end check_org_exist;
2417:
2418:

Line 2527: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2523:
2524: WHEN OTHERS THEN
2525: ROLLBACK;
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2527: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2528:
2529: end check_org_cert_exist;
2530:
2531:

Line 2953: FND_MSG_PUB.initialize;

2949:
2950: begin
2951: x_return_status := FND_API.G_RET_STS_SUCCESS;
2952: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2953: FND_MSG_PUB.initialize;
2954: END IF;
2955: IF FND_GLOBAL.User_Id IS NULL THEN
2956: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2957: RAISE FND_API.G_EXC_ERROR;

Line 3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3194:
3195: WHEN amw_deadlock_detected THEN
3196: ROLLBACK;
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3208: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3208: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3209:
3210:
3211: -- kosriniv begin :- Handle amw_processing_exception
3212: WHEN amw_processing_exception THEN

Line 3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3220:
3221: WHEN OTHERS THEN
3222: ROLLBACK;
3223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3227: END IF;
3228: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

3222: ROLLBACK;
3223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3227: END IF;
3228: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3229:
3230: end adhoc_synch_hier_amw_proc;

Line 3228: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3227: END IF;
3228: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3229:
3230: end adhoc_synch_hier_amw_proc;
3231:
3232: ------------------------------------------------------------------------------------------------------------

Line 3294: FND_MSG_PUB.initialize;

3290:
3291: begin
3292: x_return_status := FND_API.G_RET_STS_SUCCESS;
3293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3294: FND_MSG_PUB.initialize;
3295: END IF;
3296: IF FND_GLOBAL.User_Id IS NULL THEN
3297: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3298: RAISE FND_API.G_EXC_ERROR;

Line 3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3447:
3448: WHEN amw_deadlock_detected THEN
3449: ROLLBACK;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3462:
3463:
3464: -- kosriniv begin :- Handle amw_processing_exception
3465: WHEN amw_processing_exception THEN

Line 3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3473:
3474: WHEN OTHERS THEN
3475: ROLLBACK;
3476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3478: THEN
3479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

3475: ROLLBACK;
3476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3478: THEN
3479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3482:
3483: end old_synch_hier_amw_process;

Line 3481: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3478: THEN
3479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3482:
3483: end old_synch_hier_amw_process;
3484:
3485: