APPS.LOT_SPLIT_DATA_INSERT dependencies on FND_PROFILE

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

119: ind INTEGER := 0;
120: l_dir VARCHAR2(1000) := NULL;
121: l_filename VARCHAR2(100) := 'ins_mmtt' || to_char(sysdate, 'dd:mm:hh24:mi');
122: x_mesg_data VARCHAR2(2000) := 'None';
123: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
124: BEGIN
125: /* For lot split transaction (INV_Globals.G_type_inv_lot_split) there is a single start
126: lot and multiple resulting
127: Start Lot always gets stored in the 1st index position .

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

353: p_dist_account_id IN NUMBER,
354: x_return_status OUT NOCOPY VARCHAR2)
355: IS
356: l_msg_data VARCHAR2(2000) := 'None..' ;
357: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
358: BEGIN
359: x_return_status := FND_API.G_RET_STS_SUCCESS;
360: BEGIN
361: l_msg_data := 'mtl_material_transactions_temp';

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

696: l_msg_count NUMBER := NULL;
697: l_msg_data VARCHAR2(2000) := NULL;
698: l_label_status VARCHAR2(300) := NULL;
699:
700: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
701: BEGIN
702: IF (l_debug = 1) THEN
703: INV_TRX_UTIL_PUB.trace('in insert_mmtt',g_pkg_name,9);
704: END IF;

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

1167: WHERE transaction_type_id IN ( INV_Globals.G_type_inv_lot_split,
1168: INV_Globals.G_type_inv_lot_merge,
1169: INV_Globals.G_type_inv_lot_translate);
1170: -- (82, 83, 84);
1171: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1172: BEGIN
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174: x_wmsinstall := 'N';
1175: x_wmsorg := 'N';