APPS.WMS_ASN_LOT_ATT dependencies on FND_PROFILE

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

4: PROCEDURE print_debug(p_err_msg VARCHAR2,
5: p_level NUMBER)
6: IS
7: l_trace_on NUMBER := 0;
8: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9: BEGIN
10:
11: inv_mobile_helper_functions.tracelog
12: (p_err_msg => p_err_msg,

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

13: p_module => 'WMS_ASN_LOT_ATT',
14: p_level => p_level);
15:
16:
17: SELECT fnd_profile.value('INV_DEBUG_TRACE')
18: INTO l_trace_on
19: FROM dual;
20:
21: IF l_trace_on = 1 THEN

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

28:
29:
30: procedure populatelotattributescolumn IS
31: l_column_idx BINARY_INTEGER;
32: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
33: BEGIN
34: g_lot_attributes_tbl(1).COLUMN_NAME := 'GRADE_CODE';
35: g_lot_attributes_tbl(1).COLUMN_TYPE := 'VARCHAR2';
36:

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

404:
405:
406:
407:
408: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
409: BEGIN
410:
411: l_progress := '10';
412:

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

1106: END;
1107:
1108:
1109: procedure populateSerAttributesColumn IS
1110: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1111: BEGIN
1112: g_serial_attributes_tbl(1).COLUMN_NAME := 'SERIAL_ATTRIBUTE_CATEGORY';
1113: g_serial_attributes_tbl(1).COLUMN_TYPE := 'VARCHAR2';
1114:

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

1443: where TRANSACTION_INTERFACE_ID = P_SERIAL_TRANSACTION_INTF_ID;
1444:
1445: l_input_idx BINARY_INTEGER;
1446:
1447: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1448: BEGIN
1449:
1450: IF (l_debug = 1) THEN
1451: print_debug('Inside Insert Serial ',4);

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

2157: l_group_mark_id NUMBER;
2158:
2159: l_progress varchar2(100);
2160:
2161: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2162: l_serial_profile NUMBER := NVL(FND_PROFILE.VALUE('INV_RESTRICT_RCPT_SER'),2); --Bug#4122161
2163: BEGIN
2164:
2165: IF (l_debug = 1) THEN

Line 2162: l_serial_profile NUMBER := NVL(FND_PROFILE.VALUE('INV_RESTRICT_RCPT_SER'),2); --Bug#4122161

2158:
2159: l_progress varchar2(100);
2160:
2161: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2162: l_serial_profile NUMBER := NVL(FND_PROFILE.VALUE('INV_RESTRICT_RCPT_SER'),2); --Bug#4122161
2163: BEGIN
2164:
2165: IF (l_debug = 1) THEN
2166: print_debug('Inside Range Serial ',4);