DBA Data[Home] [Help]

APPS.INV_ABC_ASSIGNMENTS_PVT dependencies on FND_PROFILE

Line 31: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);

27: x_msg_count OUT nocopy NUMBER,
28: x_msg_data OUT nocopy VARCHAR2)
29: IS
30:
31: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
32:
33: l_abc_class_id NUMBER;
34: l_abc_classid_old NUMBER;
35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;

Line 283: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);

279: , p_creation_date IN DATE
280: )
281: IS
282: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ABC_ASSIGNMENTS';
283: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
284: BEGIN
285: IF ( l_debug = 1 ) THEN
286: Mydebug(l_api_name ||' Inserting new record into MTL_ABC_ASSIGNMENTS ');
287: Mydebug(l_api_name ||' p_inventory_item_id : ' || p_inventory_item_id);

Line 330: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);

326: , p_last_updated_by IN VARCHAR2
327: , p_last_update_date IN DATE)
328: IS
329: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ABC_ASSIGNMENTS';
330: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
331: BEGIN
332: IF ( l_debug = 1 ) THEN
333: Mydebug(l_api_name || ' Updating MTL_ABC_ASSIGNMENTS ');
334: Mydebug(l_api_name || ' inventory_item_id : ' || p_inventory_item_id);