DBA Data[Home] [Help]

APPS.SERIAL_CHECK dependencies on FND_PROFILE

Line 23: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

19:
20: /*** {{ R12 Enhanced reservations code changes ***/
21: -- call the overloaded inv_mark_serial API, with null reservation_id
22: IF (g_debug IS NULL) THEN
23: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
24: END IF;
25:
26: l_debug := g_debug;
27:

Line 84: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

80: l_msg_data VARCHAR2(2000);
81: /*** End R12 }} ***/
82: BEGIN
83: IF (g_debug IS NULL) THEN
84: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
85: END IF;
86:
87: l_debug := g_debug;
88:

Line 300: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

296:
297: /*** {{ R12 Enhanced reservations code changes ***/
298: -- call the overloaded inv_unmark_rsv_serial API, with null reservation_id
299: IF (g_debug IS NULL) THEN
300: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
301: END IF;
302:
303: l_debug := g_debug;
304:

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

337: , p_inventory_item_id IN NUMBER DEFAULT NULL
338: , p_update_reservation IN VARCHAR2 DEFAULT fnd_api.g_true
339: ) IS /*** {{ R12 Enhanced reservations code changes ***/
340: unmarked_value NUMBER := -1;
341: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
342: /*** {{ R12 Enhanced reservations code changes ***/
343: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
344: l_msg_count NUMBER;
345: l_msg_data VARCHAR2(2000);

Line 777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

773: hdr_id IN NUMBER DEFAULT NULL,
774: lot_temp_id IN NUMBER DEFAULT NULL,
775: success OUT NOCOPY BOOLEAN ) IS
776:
777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
778: BEGIN
779: IF (l_debug = 1) THEN
780: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');