APPS.INV_SERIAL_PICK_PKG dependencies on FND_PROFILE

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

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_SERIAL_PICK_PKG';
5:
6: PROCEDURE DEBUG(p_message IN VARCHAR2) IS
7: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8: BEGIN
9: -- inv_debug.message('wshtxn', p_message);
10: IF (l_debug = 1) THEN
11: inv_trx_util_pub.trace(p_message, 'SNPICK.', 1);

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

29: WHERE nvl(staged_flag,'N') = 'N'
30: AND supply_source_type_id = 13
31: AND demand_source_type_id in (2,8)
32: AND demand_source_line_id = p_source_line_id;
33: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
34: BEGIN
35: x_return_status := fnd_api.g_ret_sts_success;
36:
37: BEGIN

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

103: AND demand_source_type_id in (2,8)
104: AND demand_source_line_id = p_source_line_id;
105: */
106:
107: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
108: BEGIN
109: x_return_status := fnd_api.g_ret_sts_success;
110:
111: -- clean up the marks for the serial numbers

Line 213: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N');

209: l_lot_expiration_date DATE;
210: l_period_id NUMBER;
211: -- Bug 7190635
212: l_ato_item NUMBER := 0;
213: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N');
214: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
215: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
216: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
217: l_error_code NUMBER;

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

220: l_return_status VARCHAR2(1);
221: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
222:
223:
224: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
225: -- Bug 7190635, Adding new cursor to fetch reservation id based on move order line id.
226: CURSOR mrsv_record is
227: SELECT MRSV.*
228: FROM MTL_RESERVATIONS MRSV, MTL_TXN_REQUEST_LINES MTRL

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

1175: l_locator_id NUMBER;
1176: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
1177: l_api_return_status VARCHAR2(1);
1178:
1179: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1180: BEGIN
1181: x_return_status := fnd_api.g_ret_sts_success;
1182:
1183: BEGIN