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_INTEGRATION_GRP dependencies on STANDARD

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

55: l_current_location_id NUMBER;
56:
57: BEGIN
58:
59: -- Standard Beginning of Procedure/Function Logging
60: INL_LOGGING_PVT.Log_BeginProc (
61: p_module_name => g_module_name,
62: p_procedure_name => l_api_name);
63:

Line 64: -- Standard Start of API savepoint

60: INL_LOGGING_PVT.Log_BeginProc (
61: p_module_name => g_module_name,
62: p_procedure_name => l_api_name);
63:
64: -- Standard Start of API savepoint
65: SAVEPOINT Insert_LCMInterface_GRP;
66:
67: -- Initialize message list IF p_init_msg_list is SET to TRUE.
68: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 390: -- Standard check of p_commit.

386: END IF;
387: END LOOP;
388: END; -- End of API Body
389:
390: -- Standard check of p_commit.
391: IF FND_API.To_Boolean( p_commit ) THEN
392: COMMIT WORK;
393: END IF;
394:

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

391: IF FND_API.To_Boolean( p_commit ) THEN
392: COMMIT WORK;
393: END IF;
394:
395: -- Standard call to get message count and if count is 1, get message info.
396: FND_MSG_PUB.Count_And_Get(
397: p_encoded => FND_API.g_false,
398: p_count => x_msg_count,
399: p_data => x_msg_data);

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

397: p_encoded => FND_API.g_false,
398: p_count => x_msg_count,
399: p_data => x_msg_data);
400:
401: -- Standard End of Procedure/Function Logging
402: INL_LOGGING_PVT.Log_EndProc (
403: p_module_name => g_module_name,
404: p_procedure_name => l_api_name);
405:

Line 408: -- Standard Expected Error Logging

404: p_procedure_name => l_api_name);
405:
406: EXCEPTION
407: WHEN FND_API.G_EXC_ERROR THEN
408: -- Standard Expected Error Logging
409: INL_LOGGING_PVT.Log_ExpecError (
410: p_module_name => g_module_name,
411: p_procedure_name => l_api_name);
412: ROLLBACK TO Insert_LCMInterface_GRP;

Line 419: -- Standard Unexpected Error Logging

415: p_encoded => FND_API.g_false,
416: p_count => x_msg_count,
417: p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: -- Standard Unexpected Error Logging
420: INL_LOGGING_PVT.Log_UnexpecError (
421: p_module_name => g_module_name,
422: p_procedure_name => l_api_name);
423: ROLLBACK TO Insert_LCMInterface_GRP;

Line 430: -- Standard Unexpected Error Logging

426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429: WHEN OTHERS THEN
430: -- Standard Unexpected Error Logging
431: INL_LOGGING_PVT.Log_UnexpecError (
432: p_module_name => g_module_name,
433: p_procedure_name => l_api_name);
434: ROLLBACK TO Insert_LCMInterface_GRP;

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

519: --Bug#10381495
520:
521: BEGIN
522:
523: -- Standard Beginning of Procedure/Function Logging
524: INL_LOGGING_PVT.Log_BeginProc (
525: p_module_name => g_module_name,
526: p_procedure_name => l_proc_name);
527:

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

1398: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
1399: END IF;
1400: --Bug#10381495
1401:
1402: -- Standard call to get message count and if count is 1, get message info.
1403: FND_MSG_PUB.Count_And_Get (
1404: p_encoded => FND_API.g_false,
1405: p_count => x_msg_count,
1406: p_data => x_msg_data) ;

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

1404: p_encoded => FND_API.g_false,
1405: p_count => x_msg_count,
1406: p_data => x_msg_data) ;
1407:
1408: -- Standard End of Procedure/Function Logging
1409: INL_LOGGING_PVT.Log_EndProc (
1410: p_module_name => g_module_name,
1411: p_procedure_name => l_proc_name);
1412: EXCEPTION

Line 1414: -- Standard Expected Error Logging

1410: p_module_name => g_module_name,
1411: p_procedure_name => l_proc_name);
1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: -- Standard Expected Error Logging
1415: INL_LOGGING_PVT.Log_ExpecError (
1416: p_module_name => g_module_name,
1417: p_procedure_name => l_proc_name) ;
1418: INL_LOGGING_PVT.Log_Statement (

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

1535: l_actual_taxes NUMBER;
1536:
1537: BEGIN
1538:
1539: -- Standard Beginning of Procedure/Function Logging
1540: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1541: p_procedure_name => l_api_name) ;
1542:
1543: -- Standard Start of API savepoint

Line 1543: -- Standard Start of API savepoint

1539: -- Standard Beginning of Procedure/Function Logging
1540: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1541: p_procedure_name => l_api_name) ;
1542:
1543: -- Standard Start of API savepoint
1544: SAVEPOINT Get_LandedCost_GRP;
1545:
1546: -- Initialize message list IF p_init_msg_list is SET to TRUE.
1547: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1603: -- Standard check of p_commit.

1599: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602: END;
1603: -- Standard check of p_commit.
1604: IF FND_API.To_Boolean (p_commit) THEN
1605: COMMIT WORK;
1606: END IF;
1607:

Line 1619: -- Standard Expected Error Logging

1615: p_procedure_name => l_api_name) ;
1616:
1617: EXCEPTION
1618: WHEN FND_API.G_EXC_ERROR THEN
1619: -- Standard Expected Error Logging
1620: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1621: p_procedure_name => l_api_name) ;
1622: ROLLBACK TO Get_LandedCost_GRP;
1623: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1628: -- Standard Unexpected Error Logging

1624: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1625: p_count => x_msg_count,
1626: p_data => x_msg_data) ;
1627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1628: -- Standard Unexpected Error Logging
1629: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1630: p_procedure_name => l_api_name) ;
1631: ROLLBACK TO Get_LandedCost_GRP;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1637: -- Standard Unexpected Error Logging

1633: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1634: p_count => x_msg_count,
1635: p_data => x_msg_data) ;
1636: WHEN OTHERS THEN
1637: -- Standard Unexpected Error Logging
1638: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1639: p_procedure_name => l_api_name) ;
1640: ROLLBACK TO Get_LandedCost_GRP;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1679: l_actual_ajust_num NUMBER;
1680:
1681: BEGIN
1682:
1683: -- Standard Beginning of Procedure/Function Logging
1684: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1685: p_procedure_name => l_api_name) ;
1686:
1687: FOR i IN 1..p_rti_rec.COUNT LOOP

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

1813:
1814: -- Initialize return status to success
1815: x_return_status := FND_API.G_RET_STS_SUCCESS;
1816:
1817: -- Standard Beginning of Procedure/Function Logging
1818: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1819: p_procedure_name => l_proc_name);
1820:
1821: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1840: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1841: p_procedure_name => l_proc_name,
1842: p_debug_info => 'After calling RCV_UPDATE_RTI_LC.Update_RTI: ' || to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS'));
1843:
1844: -- Standard End of Procedure/Function Logging
1845: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1846: p_procedure_name => l_proc_name);
1847:
1848: EXCEPTION

Line 1850: -- Standard Expected Error Logging

1846: p_procedure_name => l_proc_name);
1847:
1848: EXCEPTION
1849: WHEN FND_API.G_EXC_ERROR THEN
1850: -- Standard Expected Error Logging
1851: INL_LOGGING_PVT.Log_ExpecError (
1852: p_module_name => g_module_name,
1853: p_procedure_name => l_proc_name);
1854: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1856: -- Standard Unexpected Error Logging

1852: p_module_name => g_module_name,
1853: p_procedure_name => l_proc_name);
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1856: -- Standard Unexpected Error Logging
1857: INL_LOGGING_PVT.Log_UnexpecError (
1858: p_module_name => g_module_name,
1859: p_procedure_name => l_proc_name);
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1862: -- Standard Unexpected Error Logging

1858: p_module_name => g_module_name,
1859: p_procedure_name => l_proc_name);
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: WHEN OTHERS THEN
1862: -- Standard Unexpected Error Logging
1863: INL_LOGGING_PVT.Log_UnexpecError (
1864: p_module_name => g_module_name,
1865: p_procedure_name => l_proc_name);
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1906: l_ship_lines_table ship_lines_table;
1907:
1908: BEGIN
1909:
1910: -- Standard Beginning of Procedure/Function Logging
1911: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1912: p_procedure_name => l_api_name) ;
1913:
1914: -- Standard Start of API savepoint

Line 1914: -- Standard Start of API savepoint

1910: -- Standard Beginning of Procedure/Function Logging
1911: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1912: p_procedure_name => l_api_name) ;
1913:
1914: -- Standard Start of API savepoint
1915: SAVEPOINT Call_StampLC_GRP;
1916:
1917: -- Initialize message list IF p_init_msg_list is SET to TRUE.
1918: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1963: -- Standard check of p_commit.

1959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962:
1963: -- Standard check of p_commit.
1964: IF FND_API.To_Boolean (p_commit) THEN
1965: COMMIT WORK;
1966: END IF;
1967:

Line 1978: -- Standard Expected Error Logging

1974: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1975: p_procedure_name => l_api_name);
1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: -- Standard Expected Error Logging
1979: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1980: p_procedure_name => l_api_name);
1981: ROLLBACK TO Call_StampLC_GRP;
1982: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1987: -- Standard Unexpected Error Logging

1983: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1987: -- Standard Unexpected Error Logging
1988: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1989: p_procedure_name => l_api_name);
1990: ROLLBACK TO Call_StampLC_GRP;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1996: -- Standard Unexpected Error Logging

1992: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1993: p_count => x_msg_count,
1994: p_data => x_msg_data) ;
1995: WHEN OTHERS THEN
1996: -- Standard Unexpected Error Logging
1997: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1998: p_procedure_name => l_api_name) ;
1999: ROLLBACK TO Call_StampLC_GRP;
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2033:
2034: -- Initialize return status to success
2035: x_return_status := FND_API.G_RET_STS_SUCCESS;
2036:
2037: -- Standard Beginning of Procedure/Function Logging
2038: INL_LOGGING_PVT.Log_BeginProc (
2039: p_module_name => g_module_name,
2040: p_procedure_name => l_proc_name
2041: );

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

2109: p_debug_info => 'After call RCV_INSERT_FROM_INL.insert_rcv_tables'
2110: );
2111: END IF;
2112:
2113: -- Standard End of Procedure/Function Logging
2114: INL_LOGGING_PVT.Log_EndProc (
2115: p_module_name => g_module_name,
2116: p_procedure_name => l_proc_name
2117: );

Line 2121: -- Standard Expected Error Logging

2117: );
2118:
2119: EXCEPTION
2120: WHEN FND_API.G_EXC_ERROR THEN
2121: -- Standard Expected Error Logging
2122: INL_LOGGING_PVT.Log_ExpecError(
2123: p_module_name => g_module_name,
2124: p_procedure_name => l_proc_name);
2125: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2127: -- Standard Unexpected Error Logging

2123: p_module_name => g_module_name,
2124: p_procedure_name => l_proc_name);
2125: x_return_status := FND_API.G_RET_STS_ERROR;
2126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2127: -- Standard Unexpected Error Logging
2128: INL_LOGGING_PVT.Log_UnexpecError(
2129: p_module_name => g_module_name,
2130: p_procedure_name => l_proc_name);
2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2133: -- Standard Unexpected Error Logging

2129: p_module_name => g_module_name,
2130: p_procedure_name => l_proc_name);
2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2132: WHEN OTHERS THEN
2133: -- Standard Unexpected Error Logging
2134: INL_LOGGING_PVT.Log_UnexpecError(
2135: p_module_name => g_module_name,
2136: p_procedure_name => l_proc_name);
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2179: l_ship_lines_table ship_lines_table;
2180:
2181: BEGIN
2182:
2183: -- Standard Beginning of Procedure/Function Logging
2184: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2185: p_procedure_name => l_api_name);
2186:
2187: -- Standard Start of API savepoint

Line 2187: -- Standard Start of API savepoint

2183: -- Standard Beginning of Procedure/Function Logging
2184: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2185: p_procedure_name => l_api_name);
2186:
2187: -- Standard Start of API savepoint
2188: SAVEPOINT Export_ToRCV_GRP;
2189:
2190: -- Initialize message list IF p_init_msg_list is SET to TRUE.
2191: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 2244: -- Standard check of p_commit.

2240: IF c_ship_lines%ISOPEN THEN
2241: CLOSE c_ship_lines;
2242: END IF;
2243:
2244: -- Standard check of p_commit.
2245: IF FND_API.To_Boolean (p_commit) THEN
2246: COMMIT WORK;
2247: END IF;
2248: -- Get message count AND IF count is 1, get message info.

Line 2257: -- Standard Expected Error Logging

2253: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2254: p_procedure_name => l_api_name) ;
2255: EXCEPTION
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: -- Standard Expected Error Logging
2258: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
2259: p_procedure_name => l_api_name) ;
2260: ROLLBACK TO Export_ToRCV_GRP;
2261: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2266: -- Standard Unexpected Error Logging

2262: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2263: p_count => x_msg_count,
2264: p_data => x_msg_data) ;
2265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2266: -- Standard Unexpected Error Logging
2267: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
2268: p_procedure_name => l_api_name) ;
2269: ROLLBACK TO Export_ToRCV_GRP;
2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2275: -- Standard Unexpected Error Logging

2271: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2272: p_count => x_msg_count,
2273: p_data => x_msg_data) ;
2274: WHEN OTHERS THEN
2275: -- Standard Unexpected Error Logging
2276: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
2277: p_procedure_name => l_api_name) ;
2278: ROLLBACK TO Export_ToRCV_GRP;
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2404: l_prior_landed_cost NUMBER;
2405:
2406: BEGIN
2407:
2408: -- Standard Beginning of Procedure/Function Logging
2409: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2410: p_procedure_name => l_api_name) ;
2411:
2412: -- Standard Start of API savepoint

Line 2412: -- Standard Start of API savepoint

2408: -- Standard Beginning of Procedure/Function Logging
2409: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2410: p_procedure_name => l_api_name) ;
2411:
2412: -- Standard Start of API savepoint
2413: SAVEPOINT Export_ToCST_GRP;
2414:
2415: -- Initialize message list IF p_init_msg_list is SET to TRUE.
2416: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 2572: -- Standard check of p_commit.

2568: l_prior_landed_cost:= shipln_landed_costs_v_list(j).unit_landed_cost;--Bug#10032820
2569: END LOOP;
2570: END LOOP;
2571:
2572: -- Standard check of p_commit.
2573: IF FND_API.To_Boolean (p_commit) THEN
2574: COMMIT WORK;
2575: END IF;
2576: -- Get message count AND IF count is 1, get message info.

Line 2590: -- Standard Expected Error Logging

2586: ) ;
2587:
2588: EXCEPTION
2589: WHEN FND_API.G_EXC_ERROR THEN
2590: -- Standard Expected Error Logging
2591: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2592: p_procedure_name => l_api_name) ;
2593: ROLLBACK TO Export_ToCST_GRP;
2594: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2599: -- Standard Unexpected Error Logging

2595: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2596: p_count => x_msg_count,
2597: p_data => x_msg_data) ;
2598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2599: -- Standard Unexpected Error Logging
2600: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2601: p_procedure_name => l_api_name) ;
2602: ROLLBACK TO Export_ToCST_GRP;
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2608: -- Standard Unexpected Error Logging

2604: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2605: p_count => x_msg_count,
2606: p_data => x_msg_data) ;
2607: WHEN OTHERS THEN
2608: -- Standard Unexpected Error Logging
2609: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2610: p_procedure_name => l_api_name) ;
2611: ROLLBACK TO Export_ToCST_GRP;
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2664: l_msg_data VARCHAR2(2000);
2665: l_debug_info VARCHAR2(200);
2666: BEGIN
2667:
2668: -- Standard Beginning of Procedure/Function Logging
2669: INL_LOGGING_PVT.Log_BeginProc (
2670: p_module_name => g_module_name,
2671: p_procedure_name => l_api_name
2672: );

Line 2673: -- Standard Start of API savepoint

2669: INL_LOGGING_PVT.Log_BeginProc (
2670: p_module_name => g_module_name,
2671: p_procedure_name => l_api_name
2672: );
2673: -- Standard Start of API savepoint
2674: SAVEPOINT Get_CurrencyInfo_GRP;
2675:
2676: -- Initialize message list if p_init_msg_list is set to TRUE.
2677: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2696: -- Standard Statement Level Procedure/Function Logging

2692: x_return_status := FND_API.G_RET_STS_SUCCESS;
2693:
2694: -- Api Body
2695:
2696: -- Standard Statement Level Procedure/Function Logging
2697: l_debug_info := 'Get currency info for the ship_line_id: ' || p_ship_line_id;
2698: INL_LOGGING_PVT.Log_Statement (
2699: p_module_name => g_module_name,
2700: p_procedure_name => l_api_name,

Line 2719: -- Standard check of p_commit.

2715: WHERE sl.ship_line_id = p_ship_line_id;
2716:
2717: -- End of Api Body
2718:
2719: -- Standard check of p_commit.
2720: IF FND_API.To_Boolean( p_commit ) THEN
2721: COMMIT WORK;
2722: END IF;
2723:

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

2720: IF FND_API.To_Boolean( p_commit ) THEN
2721: COMMIT WORK;
2722: END IF;
2723:
2724: -- Standard call to get message count and if count is 1, get message info.
2725: FND_MSG_PUB.Count_And_Get(
2726: p_encoded => FND_API.g_false,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data);

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

2726: p_encoded => FND_API.g_false,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data);
2729:
2730: -- Standard End of Procedure/Function Logging
2731: INL_LOGGING_PVT.Log_EndProc (
2732: p_module_name => g_module_name,
2733: p_procedure_name => l_api_name);
2734: EXCEPTION

Line 2736: -- Standard Expected Error Logging

2732: p_module_name => g_module_name,
2733: p_procedure_name => l_api_name);
2734: EXCEPTION
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: -- Standard Expected Error Logging
2737: INL_LOGGING_PVT.Log_ExpecError (
2738: p_module_name => g_module_name,
2739: p_procedure_name => l_api_name
2740: );

Line 2749: -- Standard Unexpected Error Logging

2745: p_count => x_msg_count,
2746: p_data => x_msg_data
2747: );
2748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2749: -- Standard Unexpected Error Logging
2750: INL_LOGGING_PVT.Log_UnexpecError (
2751: p_module_name => g_module_name,
2752: p_procedure_name => l_api_name);
2753: ROLLBACK TO Get_CurrencyInfo_GRP;

Line 2760: -- Standard Unexpected Error Logging

2756: p_encoded => FND_API.g_false,
2757: p_count => x_msg_count,
2758: p_data => x_msg_data);
2759: WHEN OTHERS THEN
2760: -- Standard Unexpected Error Logging
2761: INL_LOGGING_PVT.Log_UnexpecError (
2762: p_module_name => g_module_name,
2763: p_procedure_name => l_api_name);
2764: ROLLBACK TO Get_CurrencyInfo_GRP;

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

2948:
2949: -- Initialize return status to success
2950: x_return_status := FND_API.G_RET_STS_SUCCESS;
2951:
2952: -- Standard Beginning of Procedure/Function Logging
2953: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2954: p_procedure_name => l_proc_name);
2955:
2956: INL_LOGGING_PVT.Log_Variable (

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

3413: p_procedure_name => l_proc_name,
3414: p_var_name => 'g_records_inserted',
3415: p_var_value => g_records_inserted);
3416:
3417: -- Standard End of Procedure/Function Logging
3418: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
3419: p_procedure_name => l_proc_name);
3420:
3421: EXCEPTION

Line 3423: -- Standard Expected Error Logging

3419: p_procedure_name => l_proc_name);
3420:
3421: EXCEPTION
3422: WHEN FND_API.G_EXC_ERROR THEN
3423: -- Standard Expected Error Logging
3424: INL_LOGGING_PVT.Log_ExpecError (
3425: p_module_name => g_module_name,
3426: p_procedure_name => l_proc_name);
3427: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3429: -- Standard Unexpected Error Logging

3425: p_module_name => g_module_name,
3426: p_procedure_name => l_proc_name);
3427: x_return_status := FND_API.G_RET_STS_ERROR;
3428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3429: -- Standard Unexpected Error Logging
3430: INL_LOGGING_PVT.Log_UnexpecError (
3431: p_module_name => g_module_name,
3432: p_procedure_name => l_proc_name);
3433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3435: -- Standard Unexpected Error Logging

3431: p_module_name => g_module_name,
3432: p_procedure_name => l_proc_name);
3433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3434: WHEN OTHERS THEN
3435: -- Standard Unexpected Error Logging
3436: INL_LOGGING_PVT.Log_UnexpecError (
3437: p_module_name => g_module_name,
3438: p_procedure_name => l_proc_name);
3439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3485: l_debug_info VARCHAR2(400);
3486:
3487: BEGIN
3488:
3489: -- Standard Beginning of Procedure/Function Logging
3490: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
3491: p_procedure_name => l_api_name) ;
3492:
3493: -- Standard Start of API savepoint

Line 3493: -- Standard Start of API savepoint

3489: -- Standard Beginning of Procedure/Function Logging
3490: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
3491: p_procedure_name => l_api_name) ;
3492:
3493: -- Standard Start of API savepoint
3494: SAVEPOINT Create_POSimulation_GRP;
3495:
3496: -- Initialize message list if p_init_msg_list is set to TRUE.
3497: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

3497: IF FND_API.to_Boolean(p_init_msg_list) THEN
3498: FND_MSG_PUB.initialize;
3499: END IF;
3500:
3501: -- Standard call to check for call compatibility
3502: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
3503: p_caller_version_number => p_api_version,
3504: p_api_name => l_api_name,
3505: p_pkg_name => g_pkg_name ) THEN

Line 3720: -- Standard check of p_commit.

3716: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3718: END IF;
3719:
3720: -- Standard check of p_commit.
3721: IF FND_API.To_Boolean(p_commit) THEN
3722: COMMIT WORK;
3723: END IF;
3724:

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

3732: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
3733: p_procedure_name => l_api_name,
3734: p_debug_info => l_debug_info);
3735:
3736: -- Standard call to get message count and if count is 1, get message info.
3737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
3738: -- Standard End of Procedure/Function Logging
3739: INL_LOGGING_PVT.Log_EndProc(
3740: p_module_name => g_module_name,

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

3734: p_debug_info => l_debug_info);
3735:
3736: -- Standard call to get message count and if count is 1, get message info.
3737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
3738: -- Standard End of Procedure/Function Logging
3739: INL_LOGGING_PVT.Log_EndProc(
3740: p_module_name => g_module_name,
3741: p_procedure_name => l_api_name);
3742:

Line 3745: -- Standard Expected Error Logging

3741: p_procedure_name => l_api_name);
3742:
3743: EXCEPTION
3744: WHEN FND_API.G_EXC_ERROR THEN
3745: -- Standard Expected Error Logging
3746: INL_LOGGING_PVT.Log_ExpecError (
3747: p_module_name => g_module_name,
3748: p_procedure_name => l_api_name);
3749: ROLLBACK TO Create_POSimulation_GRP;

Line 3756: -- Standard Unexpected Error Logging

3752: p_encoded => FND_API.g_false,
3753: p_count => x_msg_count,
3754: p_data => x_msg_data);
3755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3756: -- Standard Unexpected Error Logging
3757: INL_LOGGING_PVT.Log_UnexpecError (
3758: p_module_name => g_module_name,
3759: p_procedure_name => l_api_name);
3760: ROLLBACK TO Create_POSimulation_GRP;

Line 3767: -- Standard Unexpected Error Logging

3763: p_encoded => FND_API.g_false,
3764: p_count => x_msg_count,
3765: p_data => x_msg_data);
3766: WHEN OTHERS THEN
3767: -- Standard Unexpected Error Logging
3768: INL_LOGGING_PVT.Log_UnexpecError (
3769: p_module_name => g_module_name,
3770: p_procedure_name => l_api_name);
3771: ROLLBACK TO Create_POSimulation_GRP;

Line 3847: OR ph.type_lookup_code = 'STANDARD');

3843: AND (ph.type_lookup_code IN ('PLANNED','BLANKET')
3844: AND EXISTS (SELECT po_release_id
3845: FROM po_releases pr
3846: WHERE pr.po_release_id = pll.po_release_id)
3847: OR ph.type_lookup_code = 'STANDARD');
3848:
3849: TYPE c_po_ln_loc_tp IS TABLE OF c_po_ln_loc%ROWTYPE;
3850: c_po_ln_loc_tab c_po_ln_loc_tp;
3851: BEGIN

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

3852:
3853: -- Initialize return status to success
3854: x_return_status := FND_API.G_RET_STS_SUCCESS;
3855:
3856: -- Standard Beginning of Procedure/Function Logging
3857: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
3858: p_procedure_name => l_proc_name);
3859:
3860: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

3900: END LOOP;
3901:
3902: RETURN l_po_ship_check;
3903:
3904: -- Standard End of Procedure/Function Logging
3905: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
3906: p_procedure_name => l_proc_name);
3907: EXCEPTION
3908: WHEN FND_API.G_EXC_ERROR THEN

Line 3909: -- Standard Expected Error Logging

3905: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
3906: p_procedure_name => l_proc_name);
3907: EXCEPTION
3908: WHEN FND_API.G_EXC_ERROR THEN
3909: -- Standard Expected Error Logging
3910: INL_LOGGING_PVT.Log_ExpecError (
3911: p_module_name => g_module_name,
3912: p_procedure_name => l_proc_name);
3913: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3915: -- Standard Unexpected Error Logging

3911: p_module_name => g_module_name,
3912: p_procedure_name => l_proc_name);
3913: x_return_status := FND_API.G_RET_STS_ERROR;
3914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3915: -- Standard Unexpected Error Logging
3916: INL_LOGGING_PVT.Log_UnexpecError (
3917: p_module_name => g_module_name,
3918: p_procedure_name => l_proc_name);
3919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3921: -- Standard Unexpected Error Logging

3917: p_module_name => g_module_name,
3918: p_procedure_name => l_proc_name);
3919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3920: WHEN OTHERS THEN
3921: -- Standard Unexpected Error Logging
3922: INL_LOGGING_PVT.Log_UnexpecError (
3923: p_module_name => g_module_name,
3924: p_procedure_name => l_proc_name);
3925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3991:
3992: -- Initialize return status to success
3993: x_return_status := FND_API.G_RET_STS_SUCCESS;
3994:
3995: -- Standard Beginning of Procedure/Function Logging
3996: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
3997: p_procedure_name => l_proc_name);
3998:
3999: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

4177: END LOOP;
4178:
4179: RETURN l_ship_ln_check;
4180:
4181: -- Standard End of Procedure/Function Logging
4182: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
4183: p_procedure_name => l_proc_name);
4184:
4185: EXCEPTION

Line 4187: -- Standard Expected Error Logging

4183: p_procedure_name => l_proc_name);
4184:
4185: EXCEPTION
4186: WHEN FND_API.G_EXC_ERROR THEN
4187: -- Standard Expected Error Logging
4188: INL_LOGGING_PVT.Log_ExpecError (
4189: p_module_name => g_module_name,
4190: p_procedure_name => l_proc_name);
4191: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4193: -- Standard Unexpected Error Logging

4189: p_module_name => g_module_name,
4190: p_procedure_name => l_proc_name);
4191: x_return_status := FND_API.G_RET_STS_ERROR;
4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: -- Standard Unexpected Error Logging
4194: INL_LOGGING_PVT.Log_UnexpecError (
4195: p_module_name => g_module_name,
4196: p_procedure_name => l_proc_name);
4197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4199: -- Standard Unexpected Error Logging

4195: p_module_name => g_module_name,
4196: p_procedure_name => l_proc_name);
4197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4198: WHEN OTHERS THEN
4199: -- Standard Unexpected Error Logging
4200: INL_LOGGING_PVT.Log_UnexpecError (
4201: p_module_name => g_module_name,
4202: p_procedure_name => l_proc_name);
4203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4255:
4256: -- Initialize return status to success
4257: x_return_status := FND_API.G_RET_STS_SUCCESS;
4258:
4259: -- Standard Beginning of Procedure/Function Logging
4260: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
4261: p_procedure_name => l_proc_name);
4262:
4263: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

4483: END IF;
4484:
4485: RETURN l_simulation_check;
4486:
4487: -- Standard End of Procedure/Function Logging
4488: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
4489: p_procedure_name => l_proc_name);
4490:
4491: EXCEPTION

Line 4493: -- Standard Expected Error Logging

4489: p_procedure_name => l_proc_name);
4490:
4491: EXCEPTION
4492: WHEN FND_API.G_EXC_ERROR THEN
4493: -- Standard Expected Error Logging
4494: INL_LOGGING_PVT.Log_ExpecError (
4495: p_module_name => g_module_name,
4496: p_procedure_name => l_proc_name);
4497: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4499: -- Standard Unexpected Error Logging

4495: p_module_name => g_module_name,
4496: p_procedure_name => l_proc_name);
4497: x_return_status := FND_API.G_RET_STS_ERROR;
4498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4499: -- Standard Unexpected Error Logging
4500: INL_LOGGING_PVT.Log_UnexpecError (
4501: p_module_name => g_module_name,
4502: p_procedure_name => l_proc_name);
4503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4505: -- Standard Unexpected Error Logging

4501: p_module_name => g_module_name,
4502: p_procedure_name => l_proc_name);
4503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4504: WHEN OTHERS THEN
4505: -- Standard Unexpected Error Logging
4506: INL_LOGGING_PVT.Log_UnexpecError (
4507: p_module_name => g_module_name,
4508: p_procedure_name => l_proc_name);
4509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4554: l_po_ship_check BOOLEAN := TRUE;
4555:
4556: BEGIN
4557:
4558: -- Standard Beginning of Procedure/Function Logging
4559: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
4560: p_procedure_name => l_api_name) ;
4561:
4562: -- Standard Start of API savepoint

Line 4562: -- Standard Start of API savepoint

4558: -- Standard Beginning of Procedure/Function Logging
4559: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
4560: p_procedure_name => l_api_name) ;
4561:
4562: -- Standard Start of API savepoint
4563: SAVEPOINT Check_POLcmSynch_GRP;
4564:
4565: -- Initialize message list if p_init_msg_list is set to TRUE.
4566: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

4566: IF FND_API.to_Boolean(p_init_msg_list) THEN
4567: FND_MSG_PUB.initialize;
4568: END IF;
4569:
4570: -- Standard call to check for call compatibility
4571: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
4572: p_caller_version_number => p_api_version,
4573: p_api_name => l_api_name,
4574: p_pkg_name => g_pkg_name ) THEN

Line 4642: -- Standard check of p_commit.

4638: IF NOT l_simul_against_po OR NOT l_ship_ln_check OR NOT l_po_ship_check THEN
4639: l_check_po_lcm_synch := 'FALSE';
4640: END IF;
4641:
4642: -- Standard check of p_commit.
4643: IF FND_API.To_Boolean(p_commit) THEN
4644: COMMIT WORK;
4645: END IF;
4646: -- Standard call to get message count and if count is 1, get message info.

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

4642: -- Standard check of p_commit.
4643: IF FND_API.To_Boolean(p_commit) THEN
4644: COMMIT WORK;
4645: END IF;
4646: -- Standard call to get message count and if count is 1, get message info.
4647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4648: -- Standard End of Procedure/Function Logging
4649: INL_LOGGING_PVT.Log_EndProc(
4650: p_module_name => g_module_name,

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

4644: COMMIT WORK;
4645: END IF;
4646: -- Standard call to get message count and if count is 1, get message info.
4647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4648: -- Standard End of Procedure/Function Logging
4649: INL_LOGGING_PVT.Log_EndProc(
4650: p_module_name => g_module_name,
4651: p_procedure_name => l_api_name);
4652:

Line 4657: -- Standard Expected Error Logging

4653: RETURN l_check_po_lcm_synch;
4654:
4655: EXCEPTION
4656: WHEN FND_API.G_EXC_ERROR THEN
4657: -- Standard Expected Error Logging
4658: INL_LOGGING_PVT.Log_ExpecError (
4659: p_module_name => g_module_name,
4660: p_procedure_name => l_api_name);
4661: ROLLBACK TO Check_POLcmSynch_GRP;

Line 4668: -- Standard Unexpected Error Logging

4664: p_encoded => FND_API.g_false,
4665: p_count => x_msg_count,
4666: p_data => x_msg_data);
4667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4668: -- Standard Unexpected Error Logging
4669: INL_LOGGING_PVT.Log_UnexpecError (
4670: p_module_name => g_module_name,
4671: p_procedure_name => l_api_name);
4672: ROLLBACK TO Check_POLcmSynch_GRP;

Line 4679: -- Standard Unexpected Error Logging

4675: p_encoded => FND_API.g_false,
4676: p_count => x_msg_count,
4677: p_data => x_msg_data);
4678: WHEN OTHERS THEN
4679: -- Standard Unexpected Error Logging
4680: INL_LOGGING_PVT.Log_UnexpecError (
4681: p_module_name => g_module_name,
4682: p_procedure_name => l_api_name);
4683: ROLLBACK TO Check_POLcmSynch_GRP;

Line 4763: -- Standard Unexpected Error Logging

4759:
4760: RETURN l_is_po_eligible;
4761: EXCEPTION
4762: WHEN NO_DATA_FOUND THEN
4763: -- Standard Unexpected Error Logging
4764: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
4765: p_procedure_name => l_func_name) ;
4766: RETURN l_is_po_eligible;
4767: WHEN OTHERS THEN

Line 4768: -- Standard Unexpected Error Logging

4764: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
4765: p_procedure_name => l_func_name) ;
4766: RETURN l_is_po_eligible;
4767: WHEN OTHERS THEN
4768: -- Standard Unexpected Error Logging
4769: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
4770: p_procedure_name => l_func_name) ;
4771: IF FND_MSG_PUB.Check_Msg_Level (p_message_level =>
4772: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN