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 1608: -- Standard Start of API savepoint

1604: SELECT mtl_categories_s.nextval
1605: FROM dual;
1606: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1607: BEGIN
1608: -- Standard Start of API savepoint
1609: SAVEPOINT Create_Category_PUB;
1610:
1611: -- Check for call compatibility.
1612: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1732: -- Standard check of p_commit.

1728: IF (l_debug = 1) THEN
1729: mdebug('Tracing....10');
1730: END IF;
1731:
1732: -- Standard check of p_commit.
1733: IF FND_API.To_Boolean( p_commit ) THEN
1734: COMMIT WORK;
1735: END IF;
1736:

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

1734: COMMIT WORK;
1735: END IF;
1736:
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738: -- Standard call to get message count and if count is 1,
1739: -- get message info.
1740: -- The client will directly display the x_msg_data (which is already
1741: -- translated) if the x_msg_count = 1;
1742: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 1837: -- Standard Start of API savepoint

1833:
1834:
1835: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1836: BEGIN
1837: -- Standard Start of API savepoint
1838: SAVEPOINT Update_Category_PUB;
1839:
1840:
1841: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1945: -- Standard check of p_commit.

1941: IF (l_debug = 1) THEN
1942: mdebug('Update_Category:: Tracing....10');
1943: END IF;
1944:
1945: -- Standard check of p_commit.
1946: IF FND_API.To_Boolean( p_commit ) THEN
1947: COMMIT WORK;
1948: END IF;
1949:

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

1947: COMMIT WORK;
1948: END IF;
1949:
1950: x_return_status := FND_API.G_RET_STS_SUCCESS;
1951: -- Standard call to get message count and if count is 1,
1952: -- get message info.
1953: -- The client will directly display the x_msg_data (which is already
1954: -- translated) if the x_msg_count = 1;
1955: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2035: -- Standard Start of API savepoint

2031: l_api_version CONSTANT NUMBER := 1.0;
2032: l_row_count NUMBER;
2033: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2034: BEGIN
2035: -- Standard Start of API savepoint
2036: SAVEPOINT Update_Category_Desc_PUB;
2037:
2038:
2039: -- Check for call compatibility.

Line 2072: -- Standard check of p_commit.

2068: END IF;
2069: RAISE NO_DATA_FOUND;
2070: END IF;
2071:
2072: -- Standard check of p_commit.
2073: IF FND_API.To_Boolean( p_commit ) THEN
2074: COMMIT WORK;
2075: END IF;
2076:

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

2074: COMMIT WORK;
2075: END IF;
2076:
2077: x_return_status := FND_API.G_RET_STS_SUCCESS;
2078: -- Standard call to get message count and if count is 1,
2079: -- get message info.
2080: -- The client will directly display the x_msg_data (which is already
2081: -- translated) if the x_msg_count = 1;
2082: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2195: -- Standard Start of API savepoint

2191:
2192:
2193: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2194: BEGIN
2195: -- Standard Start of API savepoint
2196: SAVEPOINT Delete_Category_PUB;
2197:
2198: -- Check for call compatibility.
2199: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2290: -- Standard check of p_commit.

2286:
2287: IF (l_debug = 1) THEN
2288: mdebug('Category deleted successfully: '||p_category_id);
2289: END IF;
2290: -- Standard check of p_commit.
2291: IF FND_API.To_Boolean( p_commit ) THEN
2292: COMMIT WORK;
2293: END IF;
2294:

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

2292: COMMIT WORK;
2293: END IF;
2294:
2295: x_return_status := FND_API.G_RET_STS_SUCCESS;
2296: -- Standard call to get message count and if count is 1,
2297: -- get message info.
2298: -- The client will directly display the x_msg_data (which is already
2299: -- translated) if the x_msg_count = 1;
2300: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2383: -- Standard Start of API savepoint

2379:
2380: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2381: BEGIN
2382:
2383: -- Standard Start of API savepoint
2384: SAVEPOINT Create_Category_Assignment_PUB;
2385:
2386: -- Check for call compatibility.
2387: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2452: -- Standard check of p_commit.

2448: mdebug('error occured when Raise EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT business event');
2449: END IF;
2450: END;
2451: --mdebug('Create_Category_Assignment: Done!!');
2452: -- Standard check of p_commit.
2453: IF FND_API.To_Boolean( p_commit ) THEN
2454: COMMIT WORK;
2455: END IF;
2456:

Line 2535: -- Standard Start of API savepoint

2531: l_api_version CONSTANT NUMBER := 1.0;
2532: l_row_count NUMBER;
2533: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2534: BEGIN
2535: -- Standard Start of API savepoint
2536: SAVEPOINT Delete_Category_Assignment_PUB;
2537:
2538: -- Check for call compatibility.
2539: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2626: -- Standard check of p_commit.

2622: mdebug('error occured when Raise EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT business event');
2623: END IF;
2624: END;
2625:
2626: -- Standard check of p_commit.
2627: IF FND_API.To_Boolean( p_commit ) THEN
2628: COMMIT WORK;
2629: END IF;
2630:

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

2629: END IF;
2630:
2631: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
2632: INV_ITEM_MSG.Write_List;
2633: -- Standard call to get message count and if count is 1,
2634: -- get message info.
2635: -- The client will directly display the x_msg_data (which is already
2636: -- translated) if the x_msg_count = 1;
2637: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2815: -- Standard Start of API savepoint

2811: BEGIN
2812: IF l_debug = 1 THEN
2813: mdebug('Create_Valid_Category: Tracing...1');
2814: END IF;
2815: -- Standard Start of API savepoint
2816: IF FND_API.To_Boolean( p_commit ) THEN
2817: SAVEPOINT Create_Valid_Category_PUB;
2818: END IF;
2819: -- Check for call compatibility.

Line 2885: -- Standard check of p_commit.

2881: -- passed parameters are invalid
2882: RAISE FND_API.G_EXC_ERROR;
2883: END IF;
2884:
2885: -- Standard check of p_commit.
2886: IF FND_API.To_Boolean( p_commit ) THEN
2887: COMMIT WORK;
2888: END IF;
2889:

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

2887: COMMIT WORK;
2888: END IF;
2889:
2890: x_return_status := FND_API.G_RET_STS_SUCCESS;
2891: -- Standard call to get message count and if count is 1,
2892: -- get message info.
2893: -- The client will directly display the x_msg_data (which is already
2894: -- translated) if the x_msg_count = 1;
2895: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 2991: -- Standard Start of API savepoint

2987: BEGIN
2988: IF l_debug = 1 THEN
2989: mdebug('Update_Valid_Category: Tracing...1');
2990: END IF;
2991: -- Standard Start of API savepoint
2992: IF FND_API.To_Boolean( p_commit ) THEN
2993: SAVEPOINT Update_Valid_Category_PUB;
2994: END IF;
2995: -- Check for call compatibility.

Line 3045: -- Standard check of p_commit.

3041: ELSE
3042: -- passed parameters are invalid
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045: -- Standard check of p_commit.
3046: IF FND_API.To_Boolean( p_commit ) THEN
3047: COMMIT WORK;
3048: END IF;
3049:

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

3047: COMMIT WORK;
3048: END IF;
3049:
3050: x_return_status := FND_API.G_RET_STS_SUCCESS;
3051: -- Standard call to get message count and if count is 1,
3052: -- get message info.
3053: -- The client will directly display the x_msg_data (which is already
3054: -- translated) if the x_msg_count = 1;
3055: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 3214: -- Standard Start of API savepoint

3210: BEGIN
3211: IF l_debug = 1 THEN
3212: mdebug('Delete_Valid_Category: Tracing...1');
3213: END IF;
3214: -- Standard Start of API savepoint
3215: IF FND_API.To_Boolean( p_commit ) THEN
3216: SAVEPOINT Delete_Valid_Category_PUB;
3217: END IF;
3218: -- Check for call compatibility.

Line 3346: -- Standard check of p_commit.

3342: fnd_msg_pub.ADD;
3343: RAISE FND_API.G_EXC_ERROR;
3344: END IF;
3345:
3346: -- Standard check of p_commit.
3347: IF FND_API.To_Boolean( p_commit ) THEN
3348: COMMIT WORK;
3349: END IF;
3350:

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

3348: COMMIT WORK;
3349: END IF;
3350:
3351: x_return_status := FND_API.G_RET_STS_SUCCESS;
3352: -- Standard call to get message count and if count is 1,
3353: -- get message info.
3354: -- The client will directly display the x_msg_data (which is already
3355: -- translated) if the x_msg_count = 1;
3356: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get

Line 3512: -- Standard Start of API savepoint

3508: l_api_version CONSTANT NUMBER := 1.0;
3509: l_row_count NUMBER;
3510: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3511: BEGIN
3512: -- Standard Start of API savepoint
3513: SAVEPOINT Update_Category_Assignment_PUB;
3514:
3515: -- Check for call compatibility.
3516: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 3585: -- Standard check of p_commit.

3581: IF (l_debug = 1) THEN
3582: mdebug('error occured when Raise EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT business event');
3583: END IF;
3584: END;
3585: -- Standard check of p_commit.
3586: IF FND_API.To_Boolean( p_commit ) THEN
3587: COMMIT WORK;
3588: END IF;
3589:

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

3590: --- Bug 6272365 Start
3591: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
3592: INV_ITEM_MSG.Write_List;
3593: --- Bug 6272365 End
3594: -- Standard call to get message count and if count is 1,
3595: -- get message info.
3596: -- The client will directly display the x_msg_data (which is already
3597: -- translated) if the x_msg_count = 1;
3598: -- Else i.e if x_msg_count > 1, client will call the FND_MSG_PUB.Get