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.INV_ITEM_CATEGORY_PUB dependencies on STANDARD

Line 1589: -- Standard Start of API savepoint

1585: SELECT mtl_categories_s.nextval
1586: FROM dual;
1587: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1588: BEGIN
1589: -- Standard Start of API savepoint
1590: SAVEPOINT Create_Category_PUB;
1591:
1592: -- Check for call compatibility.
1593: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1713: -- Standard check of p_commit.

1709: IF (l_debug = 1) THEN
1710: mdebug('Tracing....10');
1711: END IF;
1712:
1713: -- Standard check of p_commit.
1714: IF FND_API.To_Boolean( p_commit ) THEN
1715: COMMIT WORK;
1716: END IF;
1717:

Line 1719: -- Standard call to get message count and if count is 1,

1715: COMMIT WORK;
1716: END IF;
1717:
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;
1719: -- Standard call to get message count and if count is 1,
1720: -- get message info.
1721: -- The client will directly display the x_msg_data (which is already
1722: -- translated) if the x_msg_count = 1;
1723: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 1818: -- Standard Start of API savepoint

1814:
1815:
1816: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1817: BEGIN
1818: -- Standard Start of API savepoint
1819: SAVEPOINT Update_Category_PUB;
1820:
1821:
1822: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1926: -- Standard check of p_commit.

1922: IF (l_debug = 1) THEN
1923: mdebug('Update_Category:: Tracing....10');
1924: END IF;
1925:
1926: -- Standard check of p_commit.
1927: IF FND_API.To_Boolean( p_commit ) THEN
1928: COMMIT WORK;
1929: END IF;
1930:

Line 1932: -- Standard call to get message count and if count is 1,

1928: COMMIT WORK;
1929: END IF;
1930:
1931: x_return_status := FND_API.G_RET_STS_SUCCESS;
1932: -- Standard call to get message count and if count is 1,
1933: -- get message info.
1934: -- The client will directly display the x_msg_data (which is already
1935: -- translated) if the x_msg_count = 1;
1936: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2016: -- Standard Start of API savepoint

2012: l_api_version CONSTANT NUMBER := 1.0;
2013: l_row_count NUMBER;
2014: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2015: BEGIN
2016: -- Standard Start of API savepoint
2017: SAVEPOINT Update_Category_Desc_PUB;
2018:
2019:
2020: -- Check for call compatibility.

Line 2053: -- Standard check of p_commit.

2049: END IF;
2050: RAISE NO_DATA_FOUND;
2051: END IF;
2052:
2053: -- Standard check of p_commit.
2054: IF FND_API.To_Boolean( p_commit ) THEN
2055: COMMIT WORK;
2056: END IF;
2057:

Line 2059: -- Standard call to get message count and if count is 1,

2055: COMMIT WORK;
2056: END IF;
2057:
2058: x_return_status := FND_API.G_RET_STS_SUCCESS;
2059: -- Standard call to get message count and if count is 1,
2060: -- get message info.
2061: -- The client will directly display the x_msg_data (which is already
2062: -- translated) if the x_msg_count = 1;
2063: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2176: -- Standard Start of API savepoint

2172:
2173:
2174: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2175: BEGIN
2176: -- Standard Start of API savepoint
2177: SAVEPOINT Delete_Category_PUB;
2178:
2179: -- Check for call compatibility.
2180: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2271: -- Standard check of p_commit.

2267:
2268: IF (l_debug = 1) THEN
2269: mdebug('Category deleted successfully: '||p_category_id);
2270: END IF;
2271: -- Standard check of p_commit.
2272: IF FND_API.To_Boolean( p_commit ) THEN
2273: COMMIT WORK;
2274: END IF;
2275:

Line 2277: -- Standard call to get message count and if count is 1,

2273: COMMIT WORK;
2274: END IF;
2275:
2276: x_return_status := FND_API.G_RET_STS_SUCCESS;
2277: -- Standard call to get message count and if count is 1,
2278: -- get message info.
2279: -- The client will directly display the x_msg_data (which is already
2280: -- translated) if the x_msg_count = 1;
2281: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2364: -- Standard Start of API savepoint

2360:
2361: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2362: BEGIN
2363:
2364: -- Standard Start of API savepoint
2365: SAVEPOINT Create_Category_Assignment_PUB;
2366:
2367: -- Check for call compatibility.
2368: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2404: -- Standard check of p_commit.

2400: , x_msg_data => x_msg_data
2401: );
2402:
2403: --mdebug('Create_Category_Assignment: Done!!');
2404: -- Standard check of p_commit.
2405: IF FND_API.To_Boolean( p_commit ) THEN
2406: COMMIT WORK;
2407: END IF;
2408:

Line 2487: -- Standard Start of API savepoint

2483: l_api_version CONSTANT NUMBER := 1.0;
2484: l_row_count NUMBER;
2485: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2486: BEGIN
2487: -- Standard Start of API savepoint
2488: SAVEPOINT Delete_Category_Assignment_PUB;
2489:
2490: -- Check for call compatibility.
2491: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2548: -- Standard check of p_commit.

2544: IF (l_debug = 1) THEN
2545: mdebug('Delete_Category_Assignment: Done!!');
2546: END IF;
2547:
2548: -- Standard check of p_commit.
2549: IF FND_API.To_Boolean( p_commit ) THEN
2550: COMMIT WORK;
2551: END IF;
2552:

Line 2555: -- Standard call to get message count and if count is 1,

2551: END IF;
2552:
2553: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
2554: INV_ITEM_MSG.Write_List;
2555: -- Standard call to get message count and if count is 1,
2556: -- get message info.
2557: -- The client will directly display the x_msg_data (which is already
2558: -- translated) if the x_msg_count = 1;
2559: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2736: -- Standard Start of API savepoint

2732: BEGIN
2733: IF l_debug = 1 THEN
2734: mdebug('Create_Valid_Category: Tracing...1');
2735: END IF;
2736: -- Standard Start of API savepoint
2737: IF FND_API.To_Boolean( p_commit ) THEN
2738: SAVEPOINT Create_Valid_Category_PUB;
2739: END IF;
2740: -- Check for call compatibility.

Line 2806: -- Standard check of p_commit.

2802: -- passed parameters are invalid
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805:
2806: -- Standard check of p_commit.
2807: IF FND_API.To_Boolean( p_commit ) THEN
2808: COMMIT WORK;
2809: END IF;
2810:

Line 2812: -- Standard call to get message count and if count is 1,

2808: COMMIT WORK;
2809: END IF;
2810:
2811: x_return_status := FND_API.G_RET_STS_SUCCESS;
2812: -- Standard call to get message count and if count is 1,
2813: -- get message info.
2814: -- The client will directly display the x_msg_data (which is already
2815: -- translated) if the x_msg_count = 1;
2816: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2912: -- Standard Start of API savepoint

2908: BEGIN
2909: IF l_debug = 1 THEN
2910: mdebug('Update_Valid_Category: Tracing...1');
2911: END IF;
2912: -- Standard Start of API savepoint
2913: IF FND_API.To_Boolean( p_commit ) THEN
2914: SAVEPOINT Update_Valid_Category_PUB;
2915: END IF;
2916: -- Check for call compatibility.

Line 2966: -- Standard check of p_commit.

2962: ELSE
2963: -- passed parameters are invalid
2964: RAISE FND_API.G_EXC_ERROR;
2965: END IF;
2966: -- Standard check of p_commit.
2967: IF FND_API.To_Boolean( p_commit ) THEN
2968: COMMIT WORK;
2969: END IF;
2970:

Line 2972: -- Standard call to get message count and if count is 1,

2968: COMMIT WORK;
2969: END IF;
2970:
2971: x_return_status := FND_API.G_RET_STS_SUCCESS;
2972: -- Standard call to get message count and if count is 1,
2973: -- get message info.
2974: -- The client will directly display the x_msg_data (which is already
2975: -- translated) if the x_msg_count = 1;
2976: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 3135: -- Standard Start of API savepoint

3131: BEGIN
3132: IF l_debug = 1 THEN
3133: mdebug('Delete_Valid_Category: Tracing...1');
3134: END IF;
3135: -- Standard Start of API savepoint
3136: IF FND_API.To_Boolean( p_commit ) THEN
3137: SAVEPOINT Delete_Valid_Category_PUB;
3138: END IF;
3139: -- Check for call compatibility.

Line 3267: -- Standard check of p_commit.

3263: fnd_msg_pub.ADD;
3264: RAISE FND_API.G_EXC_ERROR;
3265: END IF;
3266:
3267: -- Standard check of p_commit.
3268: IF FND_API.To_Boolean( p_commit ) THEN
3269: COMMIT WORK;
3270: END IF;
3271:

Line 3273: -- Standard call to get message count and if count is 1,

3269: COMMIT WORK;
3270: END IF;
3271:
3272: x_return_status := FND_API.G_RET_STS_SUCCESS;
3273: -- Standard call to get message count and if count is 1,
3274: -- get message info.
3275: -- The client will directly display the x_msg_data (which is already
3276: -- translated) if the x_msg_count = 1;
3277: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 3433: -- Standard Start of API savepoint

3429: l_api_version CONSTANT NUMBER := 1.0;
3430: l_row_count NUMBER;
3431: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3432: BEGIN
3433: -- Standard Start of API savepoint
3434: SAVEPOINT Update_Category_Assignment_PUB;
3435:
3436: -- Check for call compatibility.
3437: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 3478: -- Standard check of p_commit.

3474: IF (l_debug = 1) THEN
3475: mdebug('Update_Category_Assignment: Done!!');
3476: END IF;
3477:
3478: -- Standard check of p_commit.
3479: IF FND_API.To_Boolean( p_commit ) THEN
3480: COMMIT WORK;
3481: END IF;
3482:

Line 3487: -- Standard call to get message count and if count is 1,

3483: --- Bug 6272365 Start
3484: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
3485: INV_ITEM_MSG.Write_List;
3486: --- Bug 6272365 End
3487: -- Standard call to get message count and if count is 1,
3488: -- get message info.
3489: -- The client will directly display the x_msg_data (which is already
3490: -- translated) if the x_msg_count = 1;
3491: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get