APPS.WMS_CONTAINER2_PUB dependencies on FND_PROFILE

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

8: PROCEDURE mdebug(msg in varchar2)
9: IS
10: l_msg VARCHAR2(5100);
11: l_ts VARCHAR2(30);
12: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14:
15: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
16: l_msg:=l_ts||' '||msg;

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

69: (SELECT 'Serialized items'
70: FROM MTL_SERIAL_NUMBERS
71: WHERE lpn_id = p_lpn_id);
72:
73: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
74: BEGIN
75: -- Standard Start of API savepoint
76: SAVEPOINT Purge_LPN_PUB;
77: -- Standard call to check for call compatibility.

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

260: WHERE lpn_id = l_current_lpn;
261: l_container_content_rec WMS_CONTAINER_PUB.WMS_Container_Content_Rec_Type;
262: l_temp_uom_code VARCHAR2(3);
263:
264: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Explode_LPN_PUB;
268: -- Standard call to check for call compatibility.

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

515: l_lpn_source WMS_CONTAINER_PUB.LPN;
516: l_lpn_dest WMS_CONTAINER_PUB.LPN;
517: l_result NUMBER;
518:
519: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
520: BEGIN
521: -- Standard Start of API savepoint
522: SAVEPOINT Transfer_LPN_Contents_PUB;
523: -- Standard call to check for call compatibility.

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

671: WHERE mtl_transactions_enabled_flag = 'Y'
672: AND container_item_flag = 'Y'
673: AND organization_id = p_organization_id);
674:
675: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
676: BEGIN
677: -- Standard Start of API savepoint
678: SAVEPOINT Container_Required_Qty_PUB;
679: -- Standard call to check for call compatibility.

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

1027: l_index_2 BINARY_INTEGER := 1;
1028: l_duplicate_index BINARY_INTEGER := 1;
1029: l_result NUMBER;
1030:
1031: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1032: BEGIN
1033: -- Standard Start of API savepoint
1034: SAVEPOINT Get_Outermost_LPN_PUB;
1035: -- Standard call to check for call compatibility.

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

1284: SELECT parent_lpn_id
1285: FROM WMS_LICENSE_PLATE_NUMBERS
1286: WHERE parent_lpn_id = l_temp_lpn;
1287:
1288: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1289: BEGIN
1290: -- Standard Start of API savepoint
1291: SAVEPOINT Get_LPN_List_PUB;
1292: -- Standard call to check for call compatibility.

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

1556: AND wdd.organization_id = p_organization_id ;
1557:
1558: l_delivery_match_flag NUMBER;
1559:
1560: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1561: BEGIN
1562:
1563: IF (l_debug = 1) THEN
1564: mdebug ('Start Validate_Pick_Drop_Lpn.');

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

1792: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
1793: AND wdd.lpn_id = l_lpn_id
1794: AND wdd.organization_id = p_organization_id;
1795:
1796: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1797: BEGIN
1798:
1799: IF (l_debug = 1) THEN
1800: mdebug ('Start Validate_Pick_Drop_Lpn.');

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

2117:
2118: delivery_id_rec pick_delivery_cursor%ROWTYPE;
2119: license_plate_rec drop_delivery_cursor%ROWTYPE;
2120:
2121: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2122: BEGIN
2123:
2124:
2125: IF NOT fnd_api.compatible_api_call (l_api_version_number