APPS.INV_GENEALOGY_PUB dependencies on FND_PROFILE

Line 149: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

145: counter NUMBER;
146: l_start_date DATE;
147: l_end_date DATE;
148: l_count NUMBER;
149: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
150: BEGIN
151: -- check if the parent asset is an immediate child of the given asset
152:
153: IF end_date IS NULL THEN

Line 379: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

375: l_object_table object_id_tbl_t;
376: l_serial_number VARCHAR2(30);
377: l_instance_number VARCHAR2(30);
378: l_parent_instance_number VARCHAR2(30);
379: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
380: l_invalid_field_msg VARCHAR2(50);
381: l_invalid_comb_msg VARCHAR2(150);
382: l_child_lot_control_code NUMBER; -- R12
383: l_parent_lot_control_code NUMBER; -- R12

Line 1111: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1107: l_dummy_date DATE;
1108: l_object_id NUMBER;
1109: l_parent_object_id NUMBER;
1110: l_parent_object_type NUMBER;
1111: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1112: BEGIN
1113: -- Standard Start of API savepoint
1114: SAVEPOINT update_genealogy_pub;
1115:

Line 1424: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1420: l_count NUMBER;
1421: l_msg_count NUMBER;
1422: l_msg_data VARCHAR2(2000);
1423: l_origin_txn_id NUMBER;
1424: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1425: BEGIN
1426: -- {{- RT: Flow Genealogy. No direct change has been made to this }}
1427: IF (l_debug = 1) THEN
1428: mydebug('Inside Insert_Flow_Genealogy');

Line 2715: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2711: l_inventory_item_id NUMBER;
2712: l_child_item_type NUMBER;
2713: l_parent_item_type NUMBER;
2714: l_serial_number VARCHAR2(30);
2715: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2716: l_invalid_field_msg VARCHAR2(50);
2717: l_invalid_comb_msg VARCHAR2(150);
2718: l_child_lot_control_code NUMBER;
2719: l_parent_lot_control_code NUMBER;