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

Line 101: FND_MSG_PUB.initialize;

97: SAVEPOINT Duplicate_Tax_GRP;
98:
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean(p_init_msg_list) THEN
101: FND_MSG_PUB.initialize;
102: END IF;
103:
104: -- Standard call to check for call compatibility
105: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

238: IF FND_API.To_Boolean(p_commit) THEN
239: COMMIT WORK;
240: END IF;
241: -- Standard call to get message count and if count is 1, get message info.
242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data) ;
245:
246: -- Standard End of Procedure/Function Logging

Line 257: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

253: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
254: p_procedure_name => l_api_name);
255: ROLLBACK TO Duplicate_Tax_GRP;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
258: p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: -- Standard Unexpected Error Logging

Line 266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

262: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
263: p_procedure_name => l_api_name);
264: -- ROLLBACK TO Import_FromPO_GRP;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
267: p_count => x_msg_count,
268: p_data => x_msg_data);
269: WHEN OTHERS THEN
270: -- Standard Unexpected Error Logging

Line 275: IF FND_MSG_PUB.Check_Msg_Level(

271: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
272: p_procedure_name => l_api_name);
273: ROLLBACK TO Duplicate_Tax_GRP;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: IF FND_MSG_PUB.Check_Msg_Level(
276: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
277: ) THEN
278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
279: p_procedure_name => l_api_name);

Line 276: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

272: p_procedure_name => l_api_name);
273: ROLLBACK TO Duplicate_Tax_GRP;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: IF FND_MSG_PUB.Check_Msg_Level(
276: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
277: ) THEN
278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
279: p_procedure_name => l_api_name);
280: END IF;

Line 278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: IF FND_MSG_PUB.Check_Msg_Level(
276: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
277: ) THEN
278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
279: p_procedure_name => l_api_name);
280: END IF;
281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
282: p_count => x_msg_count,

Line 281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

277: ) THEN
278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
279: p_procedure_name => l_api_name);
280: END IF;
281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data);
284: END Duplicate_Tax;
285:

Line 404: FND_MSG_PUB.initialize;

400: SAVEPOINT Duplicate_Charge_GRP;
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean(p_init_msg_list) THEN
404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Standard call to check for call compatibility
408: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 587: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

583: IF FND_API.To_Boolean(p_commit) THEN
584: COMMIT WORK;
585: END IF;
586: -- Standard call to get message count and if count is 1, get message info.
587: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
588: p_count => x_msg_count,
589: p_data => x_msg_data) ;
590:
591: -- Standard End of Procedure/Function Logging

Line 602: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

598: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
599: p_procedure_name => l_api_name);
600: ROLLBACK TO Duplicate_Charge_GRP;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
603: p_count => x_msg_count,
604: p_data => x_msg_data);
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: -- Standard Unexpected Error Logging

Line 611: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

607: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
608: p_procedure_name => l_api_name);
609: -- ROLLBACK TO Import_FromPO_GRP;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
612: p_count => x_msg_count,
613: p_data => x_msg_data);
614: WHEN OTHERS THEN
615: -- Standard Unexpected Error Logging

Line 620: IF FND_MSG_PUB.Check_Msg_Level(

616: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
617: p_procedure_name => l_api_name);
618: ROLLBACK TO Duplicate_Charge_GRP;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
624: p_procedure_name => l_api_name);

Line 621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

617: p_procedure_name => l_api_name);
618: ROLLBACK TO Duplicate_Charge_GRP;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
624: p_procedure_name => l_api_name);
625: END IF;

Line 623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
624: p_procedure_name => l_api_name);
625: END IF;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
627: p_count => x_msg_count,

Line 626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
624: p_procedure_name => l_api_name);
625: END IF;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
627: p_count => x_msg_count,
628: p_data => x_msg_data);
629: END Duplicate_Charge;
630:

Line 769: FND_MSG_PUB.initialize;

765: SAVEPOINT Duplicate_ShipLines_GRP;
766:
767: -- Initialize message list if p_init_msg_list is set to TRUE.
768: IF FND_API.to_Boolean(p_init_msg_list) THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:
772: -- Standard call to check for call compatibility
773: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 1065: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1061: IF FND_API.To_Boolean(p_commit) THEN
1062: COMMIT WORK;
1063: END IF;
1064: -- Standard call to get message count and if count is 1, get message info.
1065: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data) ;
1068:
1069: -- Standard End of Procedure/Function Logging

Line 1080: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1076: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1077: p_procedure_name => l_api_name);
1078: ROLLBACK TO Duplicate_ShipLines_GRP;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data);
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: -- Standard Unexpected Error Logging

Line 1089: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1085: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1086: p_procedure_name => l_api_name);
1087: -- ROLLBACK TO Import_FromPO_GRP;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data);
1092: WHEN OTHERS THEN
1093: -- Standard Unexpected Error Logging

Line 1098: IF FND_MSG_PUB.Check_Msg_Level(

1094: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1095: p_procedure_name => l_api_name);
1096: ROLLBACK TO Duplicate_ShipLines_GRP;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF FND_MSG_PUB.Check_Msg_Level(
1099: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1100: ) THEN
1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1102: p_procedure_name => l_api_name);

Line 1099: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1095: p_procedure_name => l_api_name);
1096: ROLLBACK TO Duplicate_ShipLines_GRP;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF FND_MSG_PUB.Check_Msg_Level(
1099: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1100: ) THEN
1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1102: p_procedure_name => l_api_name);
1103: END IF;

Line 1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF FND_MSG_PUB.Check_Msg_Level(
1099: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1100: ) THEN
1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1102: p_procedure_name => l_api_name);
1103: END IF;
1104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1105: p_count => x_msg_count,

Line 1104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1100: ) THEN
1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1102: p_procedure_name => l_api_name);
1103: END IF;
1104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107: END Duplicate_ShipLines;
1108:

Line 1205: FND_MSG_PUB.initialize;

1201: SAVEPOINT Duplicate_LineGroups_GRP;
1202:
1203: -- Initialize message list if p_init_msg_list is set to TRUE.
1204: IF FND_API.to_Boolean(p_init_msg_list) THEN
1205: FND_MSG_PUB.initialize;
1206: END IF;
1207:
1208: -- Standard call to check for call compatibility
1209: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 1406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1402: IF FND_API.To_Boolean(p_commit) THEN
1403: COMMIT WORK;
1404: END IF;
1405: -- Standard call to get message count and if count is 1, get message info.
1406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data) ;
1409:
1410: -- Standard End of Procedure/Function Logging

Line 1421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1417: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1418: p_procedure_name => l_api_name);
1419: ROLLBACK TO Duplicate_LineGroups_GRP;
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1422: p_count => x_msg_count,
1423: p_data => x_msg_data);
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: -- Standard Unexpected Error Logging

Line 1430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1426: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1427: p_procedure_name => l_api_name);
1428: -- ROLLBACK TO Import_FromPO_GRP;
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433: WHEN OTHERS THEN
1434: -- Standard Unexpected Error Logging

Line 1439: IF FND_MSG_PUB.Check_Msg_Level(

1435: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1436: p_procedure_name => l_api_name);
1437: ROLLBACK TO Duplicate_LineGroups_GRP;
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1439: IF FND_MSG_PUB.Check_Msg_Level(
1440: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1441: ) THEN
1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1443: p_procedure_name => l_api_name);

Line 1440: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1436: p_procedure_name => l_api_name);
1437: ROLLBACK TO Duplicate_LineGroups_GRP;
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1439: IF FND_MSG_PUB.Check_Msg_Level(
1440: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1441: ) THEN
1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1443: p_procedure_name => l_api_name);
1444: END IF;

Line 1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1439: IF FND_MSG_PUB.Check_Msg_Level(
1440: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1441: ) THEN
1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1443: p_procedure_name => l_api_name);
1444: END IF;
1445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1446: p_count => x_msg_count,

Line 1445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1441: ) THEN
1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1443: p_procedure_name => l_api_name);
1444: END IF;
1445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1446: p_count => x_msg_count,
1447: p_data => x_msg_data);
1448: END Duplicate_LineGroups;
1449:

Line 1561: FND_MSG_PUB.initialize;

1557: SAVEPOINT Duplicate_ShipHeaders_GRP;
1558:
1559: -- Initialize message list if p_init_msg_list is set to TRUE.
1560: IF FND_API.to_Boolean(p_init_msg_list) THEN
1561: FND_MSG_PUB.initialize;
1562: END IF;
1563:
1564: -- Standard call to check for call compatibility
1565: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 1862: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1858: IF FND_API.To_Boolean(p_commit) THEN
1859: COMMIT WORK;
1860: END IF;
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1863: p_count => x_msg_count,
1864: p_data => x_msg_data) ;
1865:
1866: -- Standard End of Procedure/Function Logging

Line 1877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1873: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1874: p_procedure_name => l_api_name);
1875: ROLLBACK TO Duplicate_ShipHeaders_GRP;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1878: p_count => x_msg_count,
1879: p_data => x_msg_data);
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1881: -- Standard Unexpected Error Logging

Line 1886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1882: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1883: p_procedure_name => l_api_name);
1884: -- ROLLBACK TO Import_FromPO_GRP;
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data);
1889: WHEN OTHERS THEN
1890: -- Standard Unexpected Error Logging

Line 1895: IF FND_MSG_PUB.Check_Msg_Level(

1891: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_api_name);
1893: ROLLBACK TO Duplicate_ShipHeaders_GRP;
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1895: IF FND_MSG_PUB.Check_Msg_Level(
1896: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1897: ) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1899: p_procedure_name => l_api_name);

Line 1896: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1892: p_procedure_name => l_api_name);
1893: ROLLBACK TO Duplicate_ShipHeaders_GRP;
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1895: IF FND_MSG_PUB.Check_Msg_Level(
1896: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1897: ) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1899: p_procedure_name => l_api_name);
1900: END IF;

Line 1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1895: IF FND_MSG_PUB.Check_Msg_Level(
1896: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1897: ) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1899: p_procedure_name => l_api_name);
1900: END IF;
1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1902: p_count => x_msg_count,

Line 1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1897: ) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1899: p_procedure_name => l_api_name);
1900: END IF;
1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1902: p_count => x_msg_count,
1903: p_data => x_msg_data);
1904: END Duplicate_ShipHeaders;
1905:

Line 1961: FND_MSG_PUB.initialize;

1957: SAVEPOINT Copy_Simulation_GRP;
1958:
1959: -- Initialize message list if p_init_msg_list is set to TRUE.
1960: IF FND_API.to_Boolean(p_init_msg_list) THEN
1961: FND_MSG_PUB.initialize;
1962: END IF;
1963:
1964: -- Standard call to check for call compatibility
1965: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 2164: FND_MSG_PUB.Add;

2160: -- Any other problems in acquiring the lock,
2161: -- raise error and return
2162: ELSE
2163: FND_MESSAGE.set_name('INL', 'INL_SIMUL_COPY_LOCKED');
2164: FND_MSG_PUB.Add;
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167: -- Release the lock
2168: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2172: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2168: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2169: l_lock_handle := NULL;
2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data) ;
2175:
2176: -- Standard End of Procedure/Function Logging

Line 2187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2183: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2184: p_procedure_name => l_api_name);
2185: ROLLBACK TO Copy_Simulation_GRP;
2186: x_return_status := FND_API.G_RET_STS_ERROR;
2187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2188: p_count => x_msg_count,
2189: p_data => x_msg_data);
2190: IF l_lock_handle IS NOT NULL THEN
2191: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2195: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2196: p_procedure_name => l_api_name);
2197: -- ROLLBACK TO Import_FromPO_GRP;
2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data);
2202: IF l_lock_handle IS NOT NULL THEN
2203: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2211: IF FND_MSG_PUB.Check_Msg_Level(

2207: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2208: p_procedure_name => l_api_name);
2209: ROLLBACK TO Copy_Simulation_GRP;
2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2211: IF FND_MSG_PUB.Check_Msg_Level(
2212: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2213: ) THEN
2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2215: p_procedure_name => l_api_name);

Line 2212: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2208: p_procedure_name => l_api_name);
2209: ROLLBACK TO Copy_Simulation_GRP;
2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2211: IF FND_MSG_PUB.Check_Msg_Level(
2212: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2213: ) THEN
2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2215: p_procedure_name => l_api_name);
2216: END IF;

Line 2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2211: IF FND_MSG_PUB.Check_Msg_Level(
2212: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2213: ) THEN
2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2215: p_procedure_name => l_api_name);
2216: END IF;
2217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2218: p_count => x_msg_count,

Line 2217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2213: ) THEN
2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2215: p_procedure_name => l_api_name);
2216: END IF;
2217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2218: p_count => x_msg_count,
2219: p_data => x_msg_data);
2220: IF l_lock_handle IS NOT NULL THEN
2221: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2294: FND_MSG_PUB.initialize;

2290: SAVEPOINT Create_Simulation_GRP;
2291:
2292: -- Initialize message list if p_init_msg_list is set to TRUE.
2293: IF FND_API.to_Boolean(p_init_msg_list) THEN
2294: FND_MSG_PUB.initialize;
2295: END IF;
2296:
2297: -- Standard call to check for call compatibility
2298: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 2472: FND_MSG_PUB.Add;

2468: -- Any other problems in acquiring the lock,
2469: -- raise error and return
2470: ELSE
2471: FND_MESSAGE.set_name('INL', 'INL_SIMUL_CREATE_LOCKED');
2472: FND_MSG_PUB.Add;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475: -- Release the lock
2476: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2476: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2477: l_lock_handle := NULL;
2478:
2479: -- Standard call to get message count and if count is 1, get message info.
2480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2481: p_count => x_msg_count,
2482: p_data => x_msg_data) ;
2483:
2484: -- Standard End of Procedure/Function Logging

Line 2495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2491: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2492: p_procedure_name => l_api_name);
2493: ROLLBACK TO Create_Simulation_GRP;
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2496: p_count => x_msg_count,
2497: p_data => x_msg_data);
2498: IF l_lock_handle IS NOT NULL THEN
2499: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2503: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2504: p_procedure_name => l_api_name);
2505: ROLLBACK TO Create_Simulation_GRP;
2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2508: p_count => x_msg_count,
2509: p_data => x_msg_data);
2510: IF l_lock_handle IS NOT NULL THEN
2511: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2519: IF FND_MSG_PUB.Check_Msg_Level(

2515: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2516: p_procedure_name => l_api_name);
2517: ROLLBACK TO Create_Simulation_GRP;
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: IF FND_MSG_PUB.Check_Msg_Level(
2520: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2521: ) THEN
2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2523: p_procedure_name => l_api_name);

Line 2520: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2516: p_procedure_name => l_api_name);
2517: ROLLBACK TO Create_Simulation_GRP;
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: IF FND_MSG_PUB.Check_Msg_Level(
2520: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2521: ) THEN
2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2523: p_procedure_name => l_api_name);
2524: END IF;

Line 2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: IF FND_MSG_PUB.Check_Msg_Level(
2520: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2521: ) THEN
2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2523: p_procedure_name => l_api_name);
2524: END IF;
2525: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2526: p_count => x_msg_count,

Line 2525: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2521: ) THEN
2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2523: p_procedure_name => l_api_name);
2524: END IF;
2525: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2526: p_count => x_msg_count,
2527: p_data => x_msg_data);
2528: IF l_lock_handle IS NOT NULL THEN
2529: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2598: FND_MSG_PUB.initialize;

2594: SAVEPOINT Purge_SimulShipments_GRP;
2595:
2596: -- Initialize message list if p_init_msg_list is set to TRUE.
2597: IF FND_API.to_Boolean(p_init_msg_list) THEN
2598: FND_MSG_PUB.initialize;
2599: END IF;
2600:
2601: -- Standard call to check for call compatibility
2602: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 2679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2675: IF FND_API.To_Boolean(p_commit) THEN
2676: COMMIT WORK;
2677: END IF;
2678: -- Standard call to get message count and if count is 1, get message info.
2679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2680: p_count => x_msg_count,
2681: p_data => x_msg_data) ;
2682:
2683: -- Standard End of Procedure/Function Logging

Line 2694: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2690: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2691: p_procedure_name => l_api_name);
2692: ROLLBACK TO Purge_SimulShipments_GRP;
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2695: p_count => x_msg_count,
2696: p_data => x_msg_data);
2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2698: -- Standard Unexpected Error Logging

Line 2703: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2699: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2700: p_procedure_name => l_api_name);
2701: ROLLBACK TO Purge_SimulShipments_GRP;
2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2703: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2704: p_count => x_msg_count,
2705: p_data => x_msg_data);
2706: WHEN OTHERS THEN
2707: -- Standard Unexpected Error Logging

Line 2712: IF FND_MSG_PUB.Check_Msg_Level(

2708: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2709: p_procedure_name => l_api_name);
2710: ROLLBACK TO Purge_SimulShipments_GRP;
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2712: IF FND_MSG_PUB.Check_Msg_Level(
2713: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2714: ) THEN
2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2716: p_procedure_name => l_api_name);

Line 2713: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2709: p_procedure_name => l_api_name);
2710: ROLLBACK TO Purge_SimulShipments_GRP;
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2712: IF FND_MSG_PUB.Check_Msg_Level(
2713: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2714: ) THEN
2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2716: p_procedure_name => l_api_name);
2717: END IF;

Line 2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2712: IF FND_MSG_PUB.Check_Msg_Level(
2713: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2714: ) THEN
2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2716: p_procedure_name => l_api_name);
2717: END IF;
2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2719: p_count => x_msg_count,

Line 2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2714: ) THEN
2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2716: p_procedure_name => l_api_name);
2717: END IF;
2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2719: p_count => x_msg_count,
2720: p_data => x_msg_data);
2721: END Purge_Simulations;
2722: