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 129: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

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

617: SELECT structure_id
618: FROM mtl_categories_b
619: WHERE category_id = p_category_id;
620:
621: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
622:
623: --Bug:6485437
624: CURSOR default_catalog_csr(cp_functional_area NUMBER)
625: IS

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

886: FUNCTION Get_Category_Rec_Type
887: RETURN INV_ITEM_CATEGORY_PVT.CATEGORY_REC_TYPE
888: IS
889: l_category_rec_type INV_ITEM_CATEGORY_PVT.CATEGORY_REC_TYPE;
890: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
891: BEGIN
892: RETURN l_category_rec_type;
893: END;
894: */

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

1116: FROM mtl_categories_b
1117: WHERE category_id = p_category_id
1118: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE; /*Bug no: 5946409 Checking whether the category is disabled */
1119:
1120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1121: BEGIN
1122:
1123: -- Set savepoint
1124: SAVEPOINT Update_Category_Assignment_PVT;