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 STANDARD

Line 92: -- Standard Beginning of Procedure/Function Logging

88: TaxLines_List TaxLines_List_Type;
89:
90: BEGIN
91:
92: -- Standard Beginning of Procedure/Function Logging
93: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
94: p_procedure_name => l_api_name) ;
95:
96: -- Standard Start of API savepoint

Line 96: -- Standard Start of API savepoint

92: -- Standard Beginning of Procedure/Function Logging
93: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
94: p_procedure_name => l_api_name) ;
95:
96: -- Standard Start of API savepoint
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

Line 104: -- Standard call to check for call compatibility

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,
106: p_caller_version_number => p_api_version,
107: p_api_name => l_api_name,
108: p_pkg_name => g_pkg_name ) THEN

Line 237: -- Standard check of p_commit.

233: SYSDATE,
234: fnd_global.login_id);
235: END LOOP;
236:
237: -- Standard check of p_commit.
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.

Line 241: -- Standard call to get message count and if count is 1, get message info.

237: -- Standard check of p_commit.
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:

Line 246: -- Standard End of Procedure/Function Logging

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
247: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
248: p_procedure_name => l_api_name);
249:
250: EXCEPTION

Line 252: -- Standard Expected Error Logging

248: p_procedure_name => l_api_name);
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: -- Standard Expected Error Logging
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;

Line 261: -- Standard Unexpected Error Logging

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

Line 270: -- Standard Unexpected Error Logging

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

Line 395: -- Standard Beginning of Procedure/Function Logging

391: ChargeLines_List ChargeLines_List_Type;
392:
393: BEGIN
394:
395: -- Standard Beginning of Procedure/Function Logging
396: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
397: p_procedure_name => l_api_name) ;
398:
399: -- Standard Start of API savepoint

Line 399: -- Standard Start of API savepoint

395: -- Standard Beginning of Procedure/Function Logging
396: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
397: p_procedure_name => l_api_name) ;
398:
399: -- Standard Start of API savepoint
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

Line 407: -- Standard call to check for call compatibility

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,
409: p_caller_version_number => p_api_version,
410: p_api_name => l_api_name,
411: p_pkg_name => g_pkg_name ) THEN

Line 582: -- Standard check of p_commit.

578: SYSDATE,
579: fnd_global.login_id);
580: END LOOP;
581:
582: -- Standard check of p_commit.
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.

Line 586: -- Standard call to get message count and if count is 1, get message info.

582: -- Standard check of p_commit.
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:

Line 591: -- Standard End of Procedure/Function Logging

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
592: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
593: p_procedure_name => l_api_name);
594:
595: EXCEPTION

Line 597: -- Standard Expected Error Logging

593: p_procedure_name => l_api_name);
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: -- Standard Expected Error Logging
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;

Line 606: -- Standard Unexpected Error Logging

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

Line 615: -- Standard Unexpected Error Logging

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

Line 760: -- Standard Beginning of Procedure/Function Logging

756: ShipLines_List ShipLines_List_Type;
757:
758: BEGIN
759:
760: -- Standard Beginning of Procedure/Function Logging
761: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
762: p_procedure_name => l_api_name) ;
763:
764: -- Standard Start of API savepoint

Line 764: -- Standard Start of API savepoint

760: -- Standard Beginning of Procedure/Function Logging
761: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
762: p_procedure_name => l_api_name) ;
763:
764: -- Standard Start of API savepoint
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

Line 772: -- Standard call to check for call compatibility

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,
774: p_caller_version_number => p_api_version,
775: p_api_name => l_api_name,
776: p_pkg_name => g_pkg_name ) THEN

Line 1060: -- Standard check of p_commit.

1056: END IF;
1057: END LOOP;
1058: END LOOP;
1059:
1060: -- Standard check of p_commit.
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.

Line 1064: -- Standard call to get message count and if count is 1, get message info.

1060: -- Standard check of p_commit.
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:

Line 1069: -- Standard End of Procedure/Function Logging

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
1070: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1071: p_procedure_name => l_api_name);
1072:
1073: EXCEPTION

Line 1075: -- Standard Expected Error Logging

1071: p_procedure_name => l_api_name);
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: -- Standard Expected Error Logging
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;

Line 1084: -- Standard Unexpected Error Logging

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

Line 1093: -- Standard Unexpected Error Logging

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

Line 1196: -- Standard Beginning of Procedure/Function Logging

1192: LineGroups_List LineGroups_List_Type;
1193:
1194: BEGIN
1195:
1196: -- Standard Beginning of Procedure/Function Logging
1197: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1198: p_procedure_name => l_api_name) ;
1199:
1200: -- Standard Start of API savepoint

Line 1200: -- Standard Start of API savepoint

1196: -- Standard Beginning of Procedure/Function Logging
1197: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1198: p_procedure_name => l_api_name) ;
1199:
1200: -- Standard Start of API savepoint
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

Line 1208: -- Standard call to check for call compatibility

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,
1210: p_caller_version_number => p_api_version,
1211: p_api_name => l_api_name,
1212: p_pkg_name => g_pkg_name ) THEN

Line 1401: -- Standard check of p_commit.

1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399: END LOOP;
1400:
1401: -- Standard check of p_commit.
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.

Line 1405: -- Standard call to get message count and if count is 1, get message info.

1401: -- Standard check of p_commit.
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:

Line 1410: -- Standard End of Procedure/Function Logging

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
1411: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1412: p_procedure_name => l_api_name);
1413:
1414: EXCEPTION

Line 1416: -- Standard Expected Error Logging

1412: p_procedure_name => l_api_name);
1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: -- Standard Expected Error Logging
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;

Line 1425: -- Standard Unexpected Error Logging

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

Line 1434: -- Standard Unexpected Error Logging

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

Line 1552: -- Standard Beginning of Procedure/Function Logging

1548: ShipHeaders_List ShipHeaders_List_Type;
1549:
1550: BEGIN
1551:
1552: -- Standard Beginning of Procedure/Function Logging
1553: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1554: p_procedure_name => l_api_name) ;
1555:
1556: -- Standard Start of API savepoint

Line 1556: -- Standard Start of API savepoint

1552: -- Standard Beginning of Procedure/Function Logging
1553: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1554: p_procedure_name => l_api_name) ;
1555:
1556: -- Standard Start of API savepoint
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

Line 1564: -- Standard call to check for call compatibility

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,
1566: p_caller_version_number => p_api_version,
1567: p_api_name => l_api_name,
1568: p_pkg_name => g_pkg_name ) THEN

Line 1857: -- Standard check of p_commit.

1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: END IF;
1855: END LOOP;
1856:
1857: -- Standard check of p_commit.
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.

Line 1861: -- Standard call to get message count and if count is 1, get message info.

1857: -- Standard check of p_commit.
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:

Line 1866: -- Standard End of Procedure/Function Logging

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
1867: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1868: p_procedure_name => l_api_name);
1869:
1870: EXCEPTION

Line 1872: -- Standard Expected Error Logging

1868: p_procedure_name => l_api_name);
1869:
1870: EXCEPTION
1871: WHEN FND_API.G_EXC_ERROR THEN
1872: -- Standard Expected Error Logging
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;

Line 1881: -- Standard Unexpected Error Logging

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

Line 1890: -- Standard Unexpected Error Logging

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

Line 1952: -- Standard Beginning of Procedure/Function Logging

1948: l_lock_status NUMBER;
1949:
1950: BEGIN
1951:
1952: -- Standard Beginning of Procedure/Function Logging
1953: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1954: p_procedure_name => l_api_name) ;
1955:
1956: -- Standard Start of API savepoint

Line 1956: -- Standard Start of API savepoint

1952: -- Standard Beginning of Procedure/Function Logging
1953: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1954: p_procedure_name => l_api_name) ;
1955:
1956: -- Standard Start of API savepoint
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

Line 1964: -- Standard call to check for call compatibility

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,
1966: p_caller_version_number => p_api_version,
1967: p_api_name => l_api_name,
1968: p_pkg_name => g_pkg_name ) THEN

Line 2156: -- Standard check of p_commit.

2152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155:
2156: -- Standard check of p_commit.
2157: IF FND_API.To_Boolean(p_commit) THEN
2158: COMMIT WORK;
2159: END IF;
2160: -- Any other problems in acquiring the lock,

Line 2171: -- Standard call to get message count and if count is 1, get message info.

2167: -- Release the lock
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:

Line 2176: -- Standard End of Procedure/Function Logging

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
2177: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2178: p_procedure_name => l_api_name);
2179:
2180: EXCEPTION

Line 2182: -- Standard Expected Error Logging

2178: p_procedure_name => l_api_name);
2179:
2180: EXCEPTION
2181: WHEN FND_API.G_EXC_ERROR THEN
2182: -- Standard Expected Error Logging
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;

Line 2194: -- Standard Unexpected Error Logging

2190: IF l_lock_handle IS NOT NULL THEN
2191: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2192: END IF;
2193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2194: -- Standard Unexpected Error Logging
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;

Line 2206: -- Standard Unexpected Error Logging

2202: IF l_lock_handle IS NOT NULL THEN
2203: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2204: END IF;
2205: WHEN OTHERS THEN
2206: -- Standard Unexpected Error Logging
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 ;

Line 2285: -- Standard Beginning of Procedure/Function Logging

2281: l_attribute15 VARCHAR2(150);
2282:
2283: BEGIN
2284:
2285: -- Standard Beginning of Procedure/Function Logging
2286: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
2287: p_procedure_name => l_api_name) ;
2288:
2289: -- Standard Start of API savepoint

Line 2289: -- Standard Start of API savepoint

2285: -- Standard Beginning of Procedure/Function Logging
2286: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
2287: p_procedure_name => l_api_name) ;
2288:
2289: -- Standard Start of API savepoint
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

Line 2297: -- Standard call to check for call compatibility

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,
2299: p_caller_version_number => p_api_version,
2300: p_api_name => l_api_name,
2301: p_pkg_name => g_pkg_name ) THEN

Line 2464: -- Standard check of p_commit.

2460: l_attribute13, -- 30
2461: l_attribute14, -- 31
2462: l_attribute15); -- 32
2463:
2464: -- Standard check of p_commit.
2465: IF FND_API.To_Boolean(p_commit) THEN
2466: COMMIT WORK;
2467: END IF;
2468: -- Any other problems in acquiring the lock,

Line 2479: -- Standard call to get message count and if count is 1, get message info.

2475: -- Release the lock
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:

Line 2484: -- Standard End of Procedure/Function Logging

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
2485: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2486: p_procedure_name => l_api_name);
2487:
2488: EXCEPTION

Line 2490: -- Standard Expected Error Logging

2486: p_procedure_name => l_api_name);
2487:
2488: EXCEPTION
2489: WHEN FND_API.G_EXC_ERROR THEN
2490: -- Standard Expected Error Logging
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;

Line 2502: -- Standard Unexpected Error Logging

2498: IF l_lock_handle IS NOT NULL THEN
2499: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2500: END IF;
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: -- Standard Unexpected Error Logging
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;

Line 2514: -- Standard Unexpected Error Logging

2510: IF l_lock_handle IS NOT NULL THEN
2511: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2512: END IF;
2513: WHEN OTHERS THEN
2514: -- Standard Unexpected Error Logging
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 ;

Line 2589: -- Standard Beginning of Procedure/Function Logging

2585: l_check_simul_tbl BOOLEAN := FALSE;
2586: l_remove_simulated BOOLEAN := FALSE;
2587: BEGIN
2588:
2589: -- Standard Beginning of Procedure/Function Logging
2590: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
2591: p_procedure_name => l_api_name) ;
2592:
2593: -- Standard Start of API savepoint

Line 2593: -- Standard Start of API savepoint

2589: -- Standard Beginning of Procedure/Function Logging
2590: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
2591: p_procedure_name => l_api_name) ;
2592:
2593: -- Standard Start of API savepoint
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

Line 2601: -- Standard call to check for call compatibility

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,
2603: p_caller_version_number => p_api_version,
2604: p_api_name => l_api_name,
2605: p_pkg_name => g_pkg_name ) THEN

Line 2674: -- Standard check of p_commit.

2670: WHERE s.simulation_id = c_simul_tbl(i).simulation_id;
2671: END IF;
2672: END LOOP;
2673:
2674: -- Standard check of p_commit.
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.

Line 2678: -- Standard call to get message count and if count is 1, get message info.

2674: -- Standard check of p_commit.
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:

Line 2683: -- Standard End of Procedure/Function Logging

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
2684: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2685: p_procedure_name => l_api_name);
2686:
2687: EXCEPTION

Line 2689: -- Standard Expected Error Logging

2685: p_procedure_name => l_api_name);
2686:
2687: EXCEPTION
2688: WHEN FND_API.G_EXC_ERROR THEN
2689: -- Standard Expected Error Logging
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;

Line 2698: -- Standard Unexpected Error Logging

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

Line 2707: -- Standard Unexpected Error Logging

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