eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on FND_PROFILE

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

15: '$Header: WMSPSHPB.pls 120.35.12010000.3 2008/09/30 09:21:36 shrmitra ship $' ;
16:
17: PROCEDURE DEBUG(p_message IN VARCHAR2,
18: p_module IN VARCHAR2) IS
19: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: if g_debug IS NULL THEN
22: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
23: end if;

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

18: p_module IN VARCHAR2) IS
19: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: if g_debug IS NULL THEN
22: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
23: end if;
24: if( g_debug = 1 ) then
25: inv_trx_util_pub.trace(p_message, 'WMS_SHPTRX.'||p_module, 1);
26: end if;

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

319: l_lot_number varchar2(80);
320: l_serial_number varchar2(30);
321: l_transaction_temp_id NUMBER;
322: l_trx_status_enabled number := 1;
323: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
324: l_debug number;
325:
326: CURSOR serial_numbers(p_transaction_temp_id NUMBER) IS
327: SELECT msnt.fm_serial_number

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

347: and wda.delivery_detail_id = wdd.delivery_detail_id;
348:
349: BEGIN
350: if g_debug IS NULL THEN
351: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
352: end if;
353: l_debug := g_debug;
354:
355: -- validate the status of item, sub, locator of the content of the lpn

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

494: END get_deliveries;
495:
496: procedure get_delivery_info(x_delivery_info OUT NOCOPY t_genref,
497: p_delivery_id IN NUMBER) IS
498: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
499: l_debug number;
500: BEGIN
501: IF g_debug IS NULL THEN
502: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

498: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
499: l_debug number;
500: BEGIN
501: IF g_debug IS NULL THEN
502: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
503: END IF;
504: l_debug := g_debug;
505:
506: IF (l_debug = 1) THEN

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

631: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
632: l_delivery_id_tab wsh_util_core.id_tab_type;
633: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
634:
635: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
636: l_debug number;
637: BEGIN
638: IF g_debug IS NULL THEN
639: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

635: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
636: l_debug number;
637: BEGIN
638: IF g_debug IS NULL THEN
639: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
640: END IF;
641: l_debug := g_debug;
642:
643: IF (l_debug = 1) THEN

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

888: p_trip_stop_id IN NUMBER,
889: p_lpn IN VARCHAR2) is
890:
891: l_count NUMBER;
892: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
893: l_debug number;
894: BEGIN
895: IF g_debug IS NULL THEN
896: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

892: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
893: l_debug number;
894: BEGIN
895: IF g_debug IS NULL THEN
896: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
897: END IF;
898: l_debug := g_debug;
899:
900: IF (l_debug = 1) THEN

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

1358: l_result NUMBER;
1359: l_sum_requested_quantity NUMBER;
1360: l_item_name VARCHAR2(80);
1361: l_delivery_id NUMBER;
1362: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1363: l_debug number;
1364: BEGIN
1365: IF g_debug IS NULL THEN
1366: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

1362: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1363: l_debug number;
1364: BEGIN
1365: IF g_debug IS NULL THEN
1366: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1367: END IF;
1368: l_debug := g_debug;
1369:
1370: IF (l_debug = 1) THEN

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

1625: -- populated correctly, do credit hold check will fail with those WDD lines.
1626: -- Added above to not pickup WDD records with lpn_id
1627: -- Also added order by so that the check_credit_holds only needs to be called when
1628: -- header or line is different.
1629: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1630: l_debug number;
1631:
1632: begin
1633: IF g_debug IS NULL THEN

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

1630: l_debug number;
1631:
1632: begin
1633: IF g_debug IS NULL THEN
1634: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1635: END IF;
1636: l_debug := g_debug;
1637: x_result := 0;
1638: l_prev_hdr_id := -999;

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

1737: l_msg_count NUMBER;
1738: l_msg_data VARCHAR2(2000);
1739:
1740: l_consol_delivery_id NUMBER; --mdc
1741: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1742: l_debug number;
1743: BEGIN
1744: IF g_debug IS NULL THEN
1745: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

1741: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1742: l_debug number;
1743: BEGIN
1744: IF g_debug IS NULL THEN
1745: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1746: END IF;
1747: l_debug := g_debug;
1748: x_error_code := 0;
1749: IF (l_debug = 1) THEN

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

2081: SELECT ignore_for_planning, tms_interface_flag
2082: FROM wsh_new_deliveries_ob_grp_v
2083: WHERE delivery_id = l_delivery_id;
2084:
2085: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2086: l_debug number;
2087:
2088: l_delivery_type VARCHAR2(30); -- MDC : 5239774
2089: BEGIN

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

2087:
2088: l_delivery_type VARCHAR2(30); -- MDC : 5239774
2089: BEGIN
2090: IF g_debug IS NULL THEN
2091: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2092: END IF;
2093: l_debug := g_debug;
2094:
2095: x_error_code := 0;

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

2400: l_msg_data VARCHAR2(2000);
2401: l_previous_lpn_id NUMBER;
2402: l_outermost_lpn_id NUMBER;
2403:
2404: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2405: l_debug number;
2406: BEGIN
2407: IF g_debug IS NULL THEN
2408: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

2404: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2405: l_debug number;
2406: BEGIN
2407: IF g_debug IS NULL THEN
2408: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2409: END IF;
2410: l_debug := g_debug;
2411:
2412: x_return_status:= 'S';

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

2758: p_bol IN VARCHAR2,
2759: p_ship_method_code IN VARCHAR2,
2760: x_return_status OUT NOCOPY VARCHAR2) IS
2761:
2762: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2763: l_debug number;
2764:
2765: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;
2766: l_delivery_id NUMBER;

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

2786:
2787:
2788: BEGIN
2789: IF g_debug IS NULL THEN
2790: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2791: END IF;
2792: l_debug := g_debug;
2793:
2794: IF l_debug = 1 THEN

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

3022: p_dock_door_id IN NUMBER,
3023: p_organization_id IN NUMBER,
3024: x_missing_count OUT NOCOPY NUMBER) IS
3025: l_count NUMBER;
3026: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3027: l_debug number;
3028: BEGIN
3029: IF g_debug IS NULL THEN
3030: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3026: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3027: l_debug number;
3028: BEGIN
3029: IF g_debug IS NULL THEN
3030: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3031: END IF;
3032: l_debug := g_debug;
3033:
3034: IF (l_debug = 1) THEN

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

3215: p_dock_door_id IN NUMBER,
3216: p_organization_id IN NUMBER,
3217: x_missing_count OUT NOCOPY NUMBER) IS
3218: l_count NUMBER;
3219: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3220: l_debug number;
3221: BEGIN
3222: IF g_debug IS NULL THEN
3223: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3219: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3220: l_debug number;
3221: BEGIN
3222: IF g_debug IS NULL THEN
3223: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3224: END IF;
3225: l_debug := g_debug;
3226:
3227: IF (l_debug = 1) THEN

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

3420: AND wdd.source_header_id = oel.header_id
3421: AND wdd.ship_set_id = p_ship_set_id
3422: AND wdd.shipped_quantity is null;
3423:
3424: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3425: l_debug number;
3426: BEGIN
3427: IF g_debug IS NULL THEN
3428: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3424: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3425: l_debug number;
3426: BEGIN
3427: IF g_debug IS NULL THEN
3428: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3429: END IF;
3430: l_debug := g_debug;
3431:
3432: x_return_status := 'C';

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

3595: l_return_status VARCHAR2(1);
3596:
3597: l_autocreate_flag VARCHAR2(1);
3598: l_report_set_name VARCHAR2(80);
3599: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3600: l_debug number;
3601:
3602: l_count NUMBER;
3603: l_tmp_out NUMBER;

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

3631:
3632:
3633: BEGIN
3634: IF g_debug IS NULL THEN
3635: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3636: END IF;
3637: l_debug := g_debug;
3638:
3639: l_del_rows(1) := p_delivery_id;

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

3813: x_return_status OUT NOCOPY VARCHAR2,
3814: x_msg_data OUT NOCOPY VARCHAR2,
3815: x_msg_count OUT NOCOPY NUMBER) IS
3816:
3817: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3818: l_debug number;
3819: BEGIN
3820: IF g_debug IS NULL THEN
3821: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3817: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3818: l_debug number;
3819: BEGIN
3820: IF g_debug IS NULL THEN
3821: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3822: END IF;
3823: l_debug := g_debug;
3824:
3825: -- call ship confirm

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

4002: l_drop_off_stop_id NUMBER;
4003: l_stop_sequence_number NUMBER;
4004: l_pick_up_count NUMBER := 0;
4005:
4006: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4007: l_debug number;
4008:
4009: l_count NUMBER;
4010: l_tmp_out NUMBER;

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

4027:
4028: x_return_status := FND_API.G_RET_STS_SUCCESS;
4029:
4030: IF g_debug IS NULL THEN
4031: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4032: END IF;
4033: l_debug := g_debug;
4034:
4035: IF l_debug = 1 THEN

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

5001: p_delivery_detail_id IN NUMBER,
5002: x_return_status OUT NOCOPY VARCHAR2,
5003: p_delivery_id IN NUMBER DEFAULT NULL,
5004: p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_true) IS
5005: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5006: l_debug number;
5007:
5008: /* Bug: 5585359: 10/09/06 Start*/
5009: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

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

5016: l_msg_count NUMBER;
5017: l_msg_data VARCHAR2(2000);
5018: BEGIN
5019: IF g_debug IS NULL THEN
5020: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5021: END IF;
5022: l_debug := g_debug;
5023:
5024: l_delivery_details(1) := p_delivery_detail_id;

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

5208: AND mol.line_id = wdd.move_order_line_id
5209: AND ol.line_id = wdd.source_line_id;
5210:
5211:
5212: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5213: l_debug number;
5214: BEGIN
5215: l_progress := '10';
5216: IF g_debug IS NULL THEN

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

5213: l_debug number;
5214: BEGIN
5215: l_progress := '10';
5216: IF g_debug IS NULL THEN
5217: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5218: END IF;
5219: l_debug := g_debug;
5220:
5221: IF (l_debug = 1) THEN

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

5383: p_organization_id IN NUMBER,
5384: p_dock_door_id IN NUMBER,
5385: p_lpn IN VARCHAR2)
5386: IS
5387: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5388: l_debug number;
5389: BEGIN
5390: IF g_debug IS NULL THEN
5391: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

5387: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5388: l_debug number;
5389: BEGIN
5390: IF g_debug IS NULL THEN
5391: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5392: END IF;
5393: l_debug := g_debug;
5394:
5395: IF (l_debug = 1) THEN

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

5455: l_return_status VARCHAR2(1);
5456: l_msg_data VARCHAR2(2000);
5457: l_msg_count NUMBER;
5458:
5459: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5460: l_debug number;
5461:
5462: BEGIN
5463: IF g_debug IS NULL THEN

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

5460: l_debug number;
5461:
5462: BEGIN
5463: IF g_debug IS NULL THEN
5464: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5465: END IF;
5466: l_debug := g_debug;
5467:
5468: x_error_code := 0;

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

5556: p_organization_id IN NUMBER,
5557: x_nt_count OUT NOCOPY NUMBER)
5558: IS
5559: l_count NUMBER;
5560: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5561: l_debug number;
5562: BEGIN
5563: IF g_debug IS NULL THEN
5564: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

5560: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5561: l_debug number;
5562: BEGIN
5563: IF g_debug IS NULL THEN
5564: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5565: END IF;
5566: l_debug := g_debug;
5567:
5568: IF (l_debug = 1) THEN

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

5801: IS
5802: l_select_stmt VARCHAR2(2000);
5803: l_prj_where VARCHAR2(2000);
5804: l_group_by VARCHAR2(2000);
5805: --l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5806: l_debug number;
5807:
5808: BEGIN
5809: IF g_debug IS NULL THEN

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

5806: l_debug number;
5807:
5808: BEGIN
5809: IF g_debug IS NULL THEN
5810: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5811: END IF;
5812: l_debug := g_debug;
5813:
5814: IF (l_debug = 1) THEN

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

6361:
6362: lpn_id_str VARCHAR(2000);
6363: lpn_contents_select_str VARCHAR2(4000);
6364: v_lpn_id NUMBER;
6365: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6366: l_debug number;
6367: BEGIN
6368: IF g_debug IS NULL THEN
6369: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

6365: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6366: l_debug number;
6367: BEGIN
6368: IF g_debug IS NULL THEN
6369: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6370: END IF;
6371: l_debug := g_debug;
6372:
6373: IF (l_debug = 1) THEN

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

6417:
6418: x VARCHAR2(30);
6419: to_return NUMBER:=0;
6420:
6421: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6422: l_debug number;
6423: BEGIN
6424: IF g_debug IS NULL THEN
6425: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

6421: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6422: l_debug number;
6423: BEGIN
6424: IF g_debug IS NULL THEN
6425: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6426: END IF;
6427: l_debug := g_debug;
6428:
6429: FOR l_cont_cur IN l_container LOOP

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

6526: l_missing_lpns t_genref;
6527: l_ship_set VARCHAR2(30);
6528: l_delivery_info t_genref;
6529: l_deli_count NUMBER;
6530: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6531: l_debug number;
6532:
6533: BEGIN
6534:

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

6533: BEGIN
6534:
6535: x_return_status := FND_API.g_ret_sts_success;
6536: IF g_debug IS NULL THEN
6537: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6538: END IF;
6539: l_debug := g_debug;
6540:
6541: IF (l_debug = 1) THEN

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

6739:
6740: l_parent_lpn_id lpn_id_tbl_type;
6741: l_inventory_item_id inventory_item_id_tbl_type;
6742:
6743: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6744: l_debug number;
6745: BEGIN
6746: IF g_debug IS NULL THEN
6747: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

6743: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6744: l_debug number;
6745: BEGIN
6746: IF g_debug IS NULL THEN
6747: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6748: END IF;
6749: l_debug := g_debug;
6750:
6751: debug('Entered with p_outermost_lpn_id : ' || p_outermost_lpn_id