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 1091: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1087: l_dummy_date DATE;
1088: l_object_id NUMBER;
1089: l_parent_object_id NUMBER;
1090: l_parent_object_type NUMBER;
1091: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1092: BEGIN
1093: -- Standard Start of API savepoint
1094: SAVEPOINT update_genealogy_pub;
1095:

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

1400: l_count NUMBER;
1401: l_msg_count NUMBER;
1402: l_msg_data VARCHAR2(2000);
1403: l_origin_txn_id NUMBER;
1404: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1405: BEGIN
1406: -- {{- RT: Flow Genealogy. No direct change has been made to this }}
1407: IF (l_debug = 1) THEN
1408: mydebug('Inside Insert_Flow_Genealogy');

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

2688: l_inventory_item_id NUMBER;
2689: l_child_item_type NUMBER;
2690: l_parent_item_type NUMBER;
2691: l_serial_number VARCHAR2(30);
2692: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2693: l_invalid_field_msg VARCHAR2(50);
2694: l_invalid_comb_msg VARCHAR2(150);
2695: l_child_lot_control_code NUMBER;
2696: l_parent_lot_control_code NUMBER;