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_CONTAINER_PVT dependencies on FND_PROFILE

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

37: , p_to_uom IN VARCHAR2
38: , p_mode IN VARCHAR2 := null
39: ) RETURN NUMBER
40: IS
41: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
42:
43: l_conversion_rate NUMBER;
44: l_inventory_item_id NUMBER;
45:

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

115: p_org_id IN NUMBER
116: , p_qty IN NUMBER
117: , x_curr_seq OUT NOCOPY NUMBER
118: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
120: l_lpn_start_num NUMBER:=0;
121:
122: BEGIN
123: --Creating an overloaded procedure so that the select of the

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

342: p_lpn_record IN WMS_Data_Type_Definitions_PUB.LPNRecordType
343: )
344: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type IS
345:
346: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
347: l_wsh_dd_rec WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;
348:
349: BEGIN
350:

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

527: , p_volume_uom_change IN VARCHAR2
528: ) IS
529:
530: l_api_name CONSTANT VARCHAR2(30) := 'Update_Locator_Capacity';
531: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
532: wtdiff NUMBER := 0;
533: voldiff NUMBER := 0;
534: l_loc_wt_uom VARCHAR2(3);
535: l_loc_vol_uom VARCHAR2(3);

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

715: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
716: ) IS
717: l_api_name CONSTANT VARCHAR2(30) := 'Create_LPNs';
718: l_api_version CONSTANT NUMBER := 1.0;
719: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
720: l_progress VARCHAR2(500) := 'Entered API';
721: l_msgdata VARCHAR2(1000);
722:
723: l_lpn_bulk_rec LPNBulkRecType;

Line 768: , FND_PROFILE.value('CONC_REQUEST_ID')

764:
765: l_progress := 'Getting any profile user values';
766:
767: SELECT fnd_global.user_id
768: , FND_PROFILE.value('CONC_REQUEST_ID')
769: INTO l_user_id
770: , l_request_id
771: FROM DUAL;
772:

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

1133: , x_created_lpns OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
1134: ) IS
1135: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Create_LPNs';
1136: l_api_version CONSTANT NUMBER := 1.0;
1137: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1138: l_progress VARCHAR2(500) := 'Entered API';
1139: l_msgdata VARCHAR2(1000);
1140:
1141: -- Constants used for LPN processing

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

1580: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
1581: ) IS
1582: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPNs';
1583: l_api_version CONSTANT NUMBER := 1.0;
1584: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1585: l_progress VARCHAR2(500) := 'Entered API';
1586: l_msgdata VARCHAR2(1000);
1587: l_delivery_id NUMBER ; --7119011
1588: l_status_code VARCHAR2(2) := 'OP'; --7119011 / 7603755

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

3596: , p_quantity IN NUMBER := 1
3597: , p_source IN NUMBER := LPN_CONTEXT_PREGENERATED
3598: , p_cost_group_id IN NUMBER := NULL
3599: ) IS
3600: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3601: x_return_status VARCHAR2(4);
3602: x_msg_count NUMBER;
3603: x_msg_data VARCHAR2(300);
3604: ret BOOLEAN;

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

3745: , p_ucc_128_suffix_flag IN NUMBER := 2
3746: ) IS
3747: l_api_name CONSTANT VARCHAR2(30) := 'Generate_LPN';
3748: l_api_version CONSTANT NUMBER := 1.0;
3749: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3750: l_progress VARCHAR2(10) := '0';
3751:
3752: l_ucc_128_suffix_flag VARCHAR2(1);
3753: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

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

3908: p_source_line_detail_id IN NUMBER := NULL
3909: ) IS
3910: l_api_name CONSTANT VARCHAR2(30) := 'Associate_LPN';
3911: l_api_version CONSTANT NUMBER := 1.0;
3912: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3913:
3914: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3915: BEGIN
3916: -- Standard Start of API savepoint

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

4033: , x_lpn_id OUT NOCOPY NUMBER
4034: ) IS
4035: l_api_name CONSTANT VARCHAR2(30) := 'Create_LPN';
4036: l_api_version CONSTANT NUMBER := 1.0;
4037: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4038: l_progress VARCHAR2(10) := '0';
4039: l_msgdata VARCHAR2(1000);
4040:
4041: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

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

4171: , p_source_transaction_id IN NUMBER := NULL
4172: ) IS
4173: l_api_name CONSTANT VARCHAR2(30) := 'PackUnpack_Container';
4174: l_api_version CONSTANT NUMBER := 1.0;
4175: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4176: l_request_id NUMBER := FND_PROFILE.value('CONC_REQUEST_ID');
4177: l_progress VARCHAR2(100) := '0';
4178: l_msgdata VARCHAR2(1000);
4179:

Line 4176: l_request_id NUMBER := FND_PROFILE.value('CONC_REQUEST_ID');

4172: ) IS
4173: l_api_name CONSTANT VARCHAR2(30) := 'PackUnpack_Container';
4174: l_api_version CONSTANT NUMBER := 1.0;
4175: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4176: l_request_id NUMBER := FND_PROFILE.value('CONC_REQUEST_ID');
4177: l_progress VARCHAR2(100) := '0';
4178: l_msgdata VARCHAR2(1000);
4179:
4180: -- Constants defined for transaction types

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

5967: , p_caller IN VARCHAR2 := NULL
5968: ) IS
5969: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPN_Wrapper';
5970: l_api_version CONSTANT NUMBER := 1.0;
5971: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5972: l_progress VARCHAR2(10) := '0';
5973: l_msgdata VARCHAR2(1000);
5974:
5975: l_lpn WMS_Data_Type_Definitions_PUB.LPNTableType;

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

6080: , x_valid_operation OUT NOCOPY NUMBER
6081: ) IS
6082: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Update_Wt_Volume';
6083: l_api_version CONSTANT NUMBER := 1.0;
6084: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6085: l_progress VARCHAR2(10) := '0';
6086:
6087: BEGIN
6088: -- Initialize API return status to success

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

6142: WHERE mtl_transactions_enabled_flag = 'Y'
6143: AND container_item_flag = 'Y'
6144: AND organization_id = p_organization_id);
6145:
6146: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6147: BEGIN
6148: -- Standard Start of API savepoint
6149: SAVEPOINT CONTAINER_REQUIRED_QTY_PVT;
6150: -- Standard call to check for call compatibility.

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

6468: x_return_status VARCHAR2(4);
6469: x_msg_count NUMBER;
6470: x_msg_data VARCHAR2(300);
6471: ret BOOLEAN;
6472: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6473:
6474: BEGIN
6475: -- Standard Start of API savepoint
6476: SAVEPOINT PREPACK_LPN_CP_PVT;

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

6583: , p_sec_uom IN VARCHAR2 := NULL --INVCONV kkillams
6584: ) IS
6585: l_api_name CONSTANT VARCHAR2(30) := 'Prepack_LPN';
6586: l_api_version CONSTANT NUMBER := 1.0;
6587: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6588: l_progress VARCHAR2(10) := '0';
6589:
6590: l_result NUMBER;
6591: l_container_item_id NUMBER := p_container_item_id;

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

7449: , p_source_type_id IN NUMBER := NULL
7450: ) IS
7451: l_api_name CONSTANT VARCHAR2(30) := 'Pack_Prepack_Container';
7452: l_api_version CONSTANT NUMBER := 1.0;
7453: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7454: l_progress VARCHAR2(10) := '0';
7455:
7456: l_current_serial VARCHAR2(30):= p_from_serial_number;
7457: l_prefix VARCHAR2(30);

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

7603: , x_content_tbl OUT NOCOPY WMS_CONTAINER_PUB.WMS_Container_Tbl_Type
7604: ) IS
7605: l_api_name CONSTANT VARCHAR2(30) := 'Explode_LPN';
7606: l_api_version CONSTANT NUMBER := 1.0;
7607: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7608: l_progress VARCHAR2(10) := '0';
7609: l_msgdata VARCHAR2(1000);
7610:
7611: l_counter NUMBER := 1; -- Counter variable initialized to 1

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

7884: , p_lock IN NUMBER := 2
7885: ) RETURN NUMBER IS
7886: l_api_name CONSTANT VARCHAR2(30) := 'Validate_LPN';
7887: l_api_version CONSTANT NUMBER := 1.0;
7888: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7889: l_progress VARCHAR2(10) := '0';
7890:
7891: BEGIN
7892: /* Check that either an lpn id or license plate number was given */

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

7963: , p_validation_type IN VARCHAR2
7964: ) RETURN NUMBER IS
7965: l_api_name CONSTANT VARCHAR2(30) := 'Validate_LPN';
7966: l_api_version CONSTANT NUMBER := 1.0;
7967: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7968: l_progress VARCHAR2(10) := '0';
7969:
7970: CURSOR Nested_LPN_Cursor IS
7971: SELECT lpn_id

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

8136: , p_outermost_lpn_id IN NUMBER
8137: ) IS
8138: l_api_name CONSTANT VARCHAR2(30) := 'Merge_Up_LPN';
8139: l_api_version CONSTANT NUMBER := 1.0;
8140: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8141: l_progress VARCHAR2(10) := '0';
8142:
8143: l_contents_tbl WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE;
8144: l_return_status NUMBER;

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

8575: , p_outermost_lpn_id IN NUMBER
8576: ) IS
8577: l_api_name CONSTANT VARCHAR2(30) := 'Break_Down_LPN';
8578: l_api_version CONSTANT NUMBER := 1.0;
8579: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8580: l_progress VARCHAR2(10) := '0';
8581:
8582: CURSOR nested_lpn_cursor IS
8583: SELECT rowid, lpn_id, parent_lpn_id, subinventory_code, locator_id

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

8720: , p_outermost_lpn_id IN NUMBER
8721: )IS
8722: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_LPNs';
8723: l_api_version CONSTANT NUMBER := 1.0;
8724: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8725: l_progress VARCHAR2(10) := '0';
8726:
8727: CURSOR nested_lpn_cursor IS
8728: SELECT rowid, lpn_id

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

8814:
8815: l_return_status VARCHAR2(1);
8816: l_msg_count NUMBER;
8817: l_msg_data VARCHAR2(2000);
8818: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8819: BEGIN
8820:
8821: SELECT wda.delivery_id
8822: INTO l_delivery_id