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.50.12020000.6 2013/03/14 00:04:52 stdavid 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 374: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

370: l_lot_number varchar2(80);
371: l_serial_number varchar2(30);
372: l_transaction_temp_id NUMBER;
373: l_trx_status_enabled number := 1;
374: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
375: l_debug number;
376:
377: CURSOR serial_numbers(p_transaction_temp_id NUMBER) IS
378: SELECT msnt.fm_serial_number

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

399: order by wdd.source_code; --bug7601434;
400:
401: BEGIN
402: if g_debug IS NULL THEN
403: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
404: end if;
405: l_debug := g_debug;
406:
407: -- validate the status of item, sub, locator of the content of the lpn

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

547: END get_deliveries;
548:
549: procedure get_delivery_info(x_delivery_info OUT NOCOPY t_genref,
550: p_delivery_id IN NUMBER) IS
551: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
552: l_debug number;
553: BEGIN
554: IF g_debug IS NULL THEN
555: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

551: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
552: l_debug number;
553: BEGIN
554: IF g_debug IS NULL THEN
555: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
556: END IF;
557: l_debug := g_debug;
558:
559: IF (l_debug = 1) THEN

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

684: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
685: l_delivery_id_tab wsh_util_core.id_tab_type;
686: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
687:
688: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
689: l_debug number;
690: BEGIN
691: IF g_debug IS NULL THEN
692: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

688: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
689: l_debug number;
690: BEGIN
691: IF g_debug IS NULL THEN
692: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
693: END IF;
694: l_debug := g_debug;
695:
696: IF (l_debug = 1) THEN

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

941: p_trip_stop_id IN NUMBER,
942: p_lpn IN VARCHAR2) is
943:
944: l_count NUMBER;
945: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
946: l_debug number;
947: BEGIN
948: IF g_debug IS NULL THEN
949: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

945: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
946: l_debug number;
947: BEGIN
948: IF g_debug IS NULL THEN
949: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
950: END IF;
951: l_debug := g_debug;
952:
953: IF (l_debug = 1) THEN

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

1416: l_result NUMBER;
1417: l_sum_requested_quantity NUMBER;
1418: l_item_name VARCHAR2(80);
1419: l_delivery_id NUMBER;
1420: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1421: l_debug number;
1422: BEGIN
1423: IF g_debug IS NULL THEN
1424: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

1420: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1421: l_debug number;
1422: BEGIN
1423: IF g_debug IS NULL THEN
1424: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1425: END IF;
1426: l_debug := g_debug;
1427:
1428: IF (l_debug = 1) THEN

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

1683: -- populated correctly, do credit hold check will fail with those WDD lines.
1684: -- Added above to not pickup WDD records with lpn_id
1685: -- Also added order by so that the check_credit_holds only needs to be called when
1686: -- header or line is different.
1687: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1688: l_debug number;
1689:
1690: begin
1691: IF g_debug IS NULL THEN

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

1688: l_debug number;
1689:
1690: begin
1691: IF g_debug IS NULL THEN
1692: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1693: END IF;
1694: l_debug := g_debug;
1695: x_result := 0;
1696: l_prev_hdr_id := -999;

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

1797: l_msg_count NUMBER;
1798: l_msg_data VARCHAR2(2000);
1799:
1800: l_consol_delivery_id NUMBER; --mdc
1801: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1802: l_debug number;
1803: BEGIN
1804: IF g_debug IS NULL THEN
1805: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

1801: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1802: l_debug number;
1803: BEGIN
1804: IF g_debug IS NULL THEN
1805: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1806: END IF;
1807: l_debug := g_debug;
1808: x_error_code := 0;
1809: IF (l_debug = 1) THEN

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

2142: SELECT ignore_for_planning, tms_interface_flag
2143: FROM wsh_new_deliveries_ob_grp_v
2144: WHERE delivery_id = l_delivery_id;
2145:
2146: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2147: l_debug number;
2148:
2149: l_delivery_type VARCHAR2(30); -- MDC : 5239774
2150: BEGIN

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

2148:
2149: l_delivery_type VARCHAR2(30); -- MDC : 5239774
2150: BEGIN
2151: IF g_debug IS NULL THEN
2152: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2153: END IF;
2154: l_debug := g_debug;
2155:
2156: x_error_code := 0;

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

2461: l_msg_data VARCHAR2(2000);
2462: l_previous_lpn_id NUMBER;
2463: l_outermost_lpn_id NUMBER;
2464:
2465: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2466: l_debug number;
2467: BEGIN
2468: IF g_debug IS NULL THEN
2469: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

2465: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2466: l_debug number;
2467: BEGIN
2468: IF g_debug IS NULL THEN
2469: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2470: END IF;
2471: l_debug := g_debug;
2472:
2473: x_return_status:= 'S';

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

2819: p_bol IN VARCHAR2,
2820: p_ship_method_code IN VARCHAR2,
2821: x_return_status OUT NOCOPY VARCHAR2) IS
2822:
2823: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2824: l_debug number;
2825:
2826: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;
2827: l_delivery_id NUMBER;

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

2847:
2848:
2849: BEGIN
2850: IF g_debug IS NULL THEN
2851: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2852: END IF;
2853: l_debug := g_debug;
2854:
2855: IF l_debug = 1 THEN

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

3083: p_dock_door_id IN NUMBER,
3084: p_organization_id IN NUMBER,
3085: x_missing_count OUT NOCOPY NUMBER) IS
3086: l_count NUMBER;
3087: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3088: l_debug number;
3089: BEGIN
3090: IF g_debug IS NULL THEN
3091: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3087: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3088: l_debug number;
3089: BEGIN
3090: IF g_debug IS NULL THEN
3091: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3092: END IF;
3093: l_debug := g_debug;
3094:
3095: IF (l_debug = 1) THEN

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

3276: p_dock_door_id IN NUMBER,
3277: p_organization_id IN NUMBER,
3278: x_missing_count OUT NOCOPY NUMBER) IS
3279: l_count NUMBER;
3280: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3281: l_debug number;
3282: BEGIN
3283: IF g_debug IS NULL THEN
3284: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3280: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3281: l_debug number;
3282: BEGIN
3283: IF g_debug IS NULL THEN
3284: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3285: END IF;
3286: l_debug := g_debug;
3287:
3288: IF (l_debug = 1) THEN

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

3481: AND wdd.source_header_id = oel.header_id
3482: AND wdd.ship_set_id = p_ship_set_id
3483: AND wdd.shipped_quantity is null;
3484:
3485: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3486: l_debug number;
3487: BEGIN
3488: IF g_debug IS NULL THEN
3489: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3485: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3486: l_debug number;
3487: BEGIN
3488: IF g_debug IS NULL THEN
3489: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3490: END IF;
3491: l_debug := g_debug;
3492:
3493: x_return_status := 'C';

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

3656: l_return_status VARCHAR2(1);
3657:
3658: l_autocreate_flag VARCHAR2(1);
3659: l_report_set_name VARCHAR2(80);
3660: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3661: l_debug number;
3662:
3663: l_count NUMBER;
3664: l_tmp_out NUMBER;

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

3711: AND wscr.ship_confirm_rule_id = wsp.ship_confirm_rule_id;
3712:
3713: BEGIN
3714: IF g_debug IS NULL THEN
3715: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3716: END IF;
3717: l_debug := g_debug;
3718:
3719: l_del_rows(1) := p_delivery_id;

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

3949: x_return_status OUT NOCOPY VARCHAR2,
3950: x_msg_data OUT NOCOPY VARCHAR2,
3951: x_msg_count OUT NOCOPY NUMBER) IS
3952:
3953: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3954: l_debug number;
3955: BEGIN
3956: IF g_debug IS NULL THEN
3957: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3953: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3954: l_debug number;
3955: BEGIN
3956: IF g_debug IS NULL THEN
3957: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3958: END IF;
3959: l_debug := g_debug;
3960:
3961: -- call ship confirm

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

4162: l_drop_off_stop_id NUMBER;
4163: l_stop_sequence_number NUMBER;
4164: l_pick_up_count NUMBER := 0;
4165:
4166: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4167: l_debug number;
4168:
4169: l_count NUMBER;
4170: l_tmp_out NUMBER;

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

4187:
4188: x_return_status := FND_API.G_RET_STS_SUCCESS;
4189:
4190: IF g_debug IS NULL THEN
4191: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4192: END IF;
4193: l_debug := g_debug;
4194:
4195: IF l_debug = 1 THEN

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

5161: p_delivery_detail_id IN NUMBER,
5162: x_return_status OUT NOCOPY VARCHAR2,
5163: p_delivery_id IN NUMBER DEFAULT NULL,
5164: p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_true) IS
5165: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5166: l_debug number;
5167:
5168: /* Bug: 5585359: 10/09/06 Start*/
5169: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;

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

5176: l_msg_count NUMBER;
5177: l_msg_data VARCHAR2(2000);
5178: BEGIN
5179: IF g_debug IS NULL THEN
5180: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5181: END IF;
5182: l_debug := g_debug;
5183:
5184: l_delivery_details(1) := p_delivery_detail_id;

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

5368: AND mol.line_id = wdd.move_order_line_id
5369: AND ol.line_id = wdd.source_line_id;
5370:
5371:
5372: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5373: l_debug number;
5374: BEGIN
5375: l_progress := '10';
5376: IF g_debug IS NULL THEN

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

5373: l_debug number;
5374: BEGIN
5375: l_progress := '10';
5376: IF g_debug IS NULL THEN
5377: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5378: END IF;
5379: l_debug := g_debug;
5380:
5381: IF (l_debug = 1) THEN

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

5543: p_organization_id IN NUMBER,
5544: p_dock_door_id IN NUMBER,
5545: p_lpn IN VARCHAR2)
5546: IS
5547: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5548: l_debug number;
5549: BEGIN
5550: IF g_debug IS NULL THEN
5551: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

5547: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5548: l_debug number;
5549: BEGIN
5550: IF g_debug IS NULL THEN
5551: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5552: END IF;
5553: l_debug := g_debug;
5554:
5555: IF (l_debug = 1) THEN

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

5630: l_return_status VARCHAR2(1);
5631: l_msg_data VARCHAR2(2000);
5632: l_msg_count NUMBER;
5633:
5634: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5635: l_debug number;
5636:
5637: BEGIN
5638: IF g_debug IS NULL THEN

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

5635: l_debug number;
5636:
5637: BEGIN
5638: IF g_debug IS NULL THEN
5639: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5640: END IF;
5641: l_debug := g_debug;
5642:
5643: x_error_code := 0;

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

5733: p_organization_id IN NUMBER,
5734: x_nt_count OUT NOCOPY NUMBER)
5735: IS
5736: l_count NUMBER;
5737: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5738: l_debug number;
5739: BEGIN
5740: IF g_debug IS NULL THEN
5741: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

5737: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5738: l_debug number;
5739: BEGIN
5740: IF g_debug IS NULL THEN
5741: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5742: END IF;
5743: l_debug := g_debug;
5744:
5745: IF (l_debug = 1) THEN

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

6024: l_fulfillment_base VARCHAR2(1) := 'P';
6025:
6026: BEGIN
6027: IF g_debug IS NULL THEN
6028: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6029: END IF;
6030: l_debug := g_debug;
6031:
6032: l_fulfillment_base := wms_direct_ship_pvt.get_fulfillment_base;

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

6608:
6609: lpn_id_str VARCHAR(2000);
6610: lpn_contents_select_str VARCHAR2(4000);
6611: v_lpn_id NUMBER;
6612: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6613: l_debug number;
6614: BEGIN
6615: IF g_debug IS NULL THEN
6616: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

6612: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6613: l_debug number;
6614: BEGIN
6615: IF g_debug IS NULL THEN
6616: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6617: END IF;
6618: l_debug := g_debug;
6619:
6620: IF (l_debug = 1) THEN

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

6664:
6665: x VARCHAR2(30);
6666: to_return NUMBER:=0;
6667:
6668: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6669: l_debug number;
6670: BEGIN
6671: IF g_debug IS NULL THEN
6672: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

6668: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6669: l_debug number;
6670: BEGIN
6671: IF g_debug IS NULL THEN
6672: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6673: END IF;
6674: l_debug := g_debug;
6675:
6676: FOR l_cont_cur IN l_container LOOP

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

6773: l_missing_lpns t_genref;
6774: l_ship_set VARCHAR2(30);
6775: l_delivery_info t_genref;
6776: l_deli_count NUMBER;
6777: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6778: l_debug number;
6779:
6780: BEGIN
6781:

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

6780: BEGIN
6781:
6782: x_return_status := FND_API.g_ret_sts_success;
6783: IF g_debug IS NULL THEN
6784: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6785: END IF;
6786: l_debug := g_debug;
6787:
6788: IF (l_debug = 1) THEN

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

6986:
6987: l_parent_lpn_id lpn_id_tbl_type;
6988: l_inventory_item_id inventory_item_id_tbl_type;
6989:
6990: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6991: l_debug number;
6992: BEGIN
6993: IF g_debug IS NULL THEN
6994: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

6990: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6991: l_debug number;
6992: BEGIN
6993: IF g_debug IS NULL THEN
6994: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6995: END IF;
6996: l_debug := g_debug;
6997:
6998: debug('Entered with p_outermost_lpn_id : ' || p_outermost_lpn_id