DBA Data[Home] [Help]

APPS.WMS_ASN_INTERFACE dependencies on FND_PROFILE

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

12: IS
13: l_trace_on NUMBER := 0;
14:
15:
16: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17: BEGIN
18:
19: inv_mobile_helper_functions.tracelog
20: (p_err_msg => p_err_msg,

Line 25: SELECT fnd_profile.value('INV_DEBUG_TRACE')

21: p_module => 'WMS_ASN_INTERFACE',
22: p_level => p_level);
23:
24:
25: SELECT fnd_profile.value('INV_DEBUG_TRACE')
26: INTO l_trace_on
27: FROM dual;
28:
29: IF l_trace_on = 1 THEN

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

43: WHERE source_header_id = p_shipment_header_id
44: AND lpn_context = 7
45: AND source_type_id = 1;
46: l_lpn_id NUMBER;
47: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
48: BEGIN
49: IF (l_debug = 1) THEN
50: print_debug('shipment_header_cleanup - p_shipment_header_id : '||p_shipment_header_id, 1);
51: END IF;

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

185:
186: /* Bug 2224521 */
187: l_valid_lot BOOLEAN := TRUE;
188:
189: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
190: BEGIN
191: IF (l_debug = 1) THEN
192: print_debug('Enter Process 10', 1);
193: print_debug('p_interface_transaction_id = ' || p_interface_transaction_id, 4);

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

1033: l_msg_data VARCHAR2(400);
1034: l_label_status VARCHAR2(500);
1035:
1036:
1037: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1038: BEGIN
1039: OPEN l_lpn_curs;
1040:
1041: LOOP