APPS.INV_ITEM_CATEGORY_PVT dependencies on FND_PROFILE

Line 28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

24: PROCEDURE Validate_Assignment
25: ( p_Debug_Level IN NUMBER
26: , p_Msg_Text IN VARCHAR2
27: ) IS
28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29: BEGIN
30:
31: -- currently validation is done in the procedure Create_Category_Assignment
32:

Line 128: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

124: inventory_item_id = p_inventory_item_id
125: AND organization_id = p_organization_id
126: AND category_set_id = p_category_set_id;
127:
128: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
129: l_default_cats number;
130: BEGIN
131:
132: -- Set savepoint

Line 611: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

607: SELECT structure_id
608: FROM mtl_categories_b
609: WHERE category_id = p_category_id;
610:
611: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
612:
613: --Bug:6485437
614: CURSOR default_catalog_csr(cp_functional_area NUMBER)
615: IS

Line 878: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

874: FUNCTION Get_Category_Rec_Type
875: RETURN INV_ITEM_CATEGORY_PVT.CATEGORY_REC_TYPE
876: IS
877: l_category_rec_type INV_ITEM_CATEGORY_PVT.CATEGORY_REC_TYPE;
878: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
879: BEGIN
880: RETURN l_category_rec_type;
881: END;
882: */

Line 1108: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1104: FROM mtl_categories_b
1105: WHERE category_id = p_category_id
1106: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE; /*Bug no: 5946409 Checking whether the category is disabled */
1107:
1108: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1109: BEGIN
1110:
1111: -- Set savepoint
1112: SAVEPOINT Update_Category_Assignment_PVT;