APPS.INV_LOT_TRX_VALIDATION_PVT dependencies on FND_PROFILE

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

92: ';
93:
94: PROCEDURE print_debug (p_message IN VARCHAR2, p_module IN VARCHAR2)
95: IS
96: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
97: --PRAGMA AUTONOMOUS_TRANSACTION;
98: BEGIN
99: --dbms_output.put_line(g_pkg_name||'.'||p_module||': ' || p_message);
100: IF (l_debug = 1)

Line 423: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

419: l_validation_status VARCHAR2 (1);
420: l_start_primary_uom VARCHAR2 (3);
421: l_revision_control VARCHAR2 (5);
422: l_debug NUMBER
423: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
424: BEGIN
425: l_validation_status := 'Y';
426:
427: IF (l_debug = 1)

Line 1224: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1220: PROCEDURE get_lot_attr_table
1221: IS
1222: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1223: l_debug NUMBER
1224: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1225:
1226: BEGIN
1227:
1228: print_debug('Before setting all the column names and types' , 'get_lot_attr_table');

Line 1524: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1520: l_line NUMBER := 1;
1521: l_stmt LONG;
1522: l_lot_num NUMBER := 0;
1523: l_debug NUMBER
1524: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1525: BEGIN
1526:
1527: /*Bug 5354721. The following satement copies all the columns names, type and length into l_lot_attr_tbl*/
1528: l_lot_attr_tbl := g_lot_attr_tbl;

Line 1773: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1769: l_update_stmt LONG := 'UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET ';
1770: l_sql_p INTEGER := NULL;
1771: l_rows_processed INTEGER := NULL;
1772: l_debug NUMBER
1773: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1774: BEGIN
1775: print_debug ('Inside update attr', 'Validate_Lot_Split');
1776: print_debug ('Count' || p_lot_attr_tbl.COUNT, 'Update Lot attr');
1777: print_debug ('Lot Number' || p_lot_number, 'Update Lot attr');

Line 1906: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1902: l_wsm_enabled VARCHAR2 (1);
1903: l_st_dist_account_id NUMBER;
1904: l_rs_dist_account_id NUMBER;
1905: l_debug NUMBER
1906: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1907: l_is_serial_controlled VARCHAR2 (1);
1908: BEGIN
1909: IF (l_debug = 1)
1910: THEN

Line 2810: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2806: l_wsm_enabled VARCHAR2 (1);
2807: l_st_dist_account_id NUMBER;
2808: l_rs_dist_account_id NUMBER;
2809: l_debug NUMBER
2810: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2811: BEGIN
2812: l_validation_status := 'Y';
2813: x_return_status := fnd_api.g_ret_sts_success;
2814:

Line 3592: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

3588: l_wsm_enabled VARCHAR2 (1);
3589: l_st_dist_account_id NUMBER;
3590: l_rs_dist_account_id NUMBER;
3591: l_debug NUMBER
3592: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3593: l_dist_id NUMBER;
3594: l_interface_id NUMBER;
3595: BEGIN
3596: l_validation_status := 'Y';