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 44: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

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

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

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

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

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

533: , p_volume_uom_change IN VARCHAR2
534: ) IS
535:
536: l_api_name CONSTANT VARCHAR2(30) := 'Update_Locator_Capacity';
537: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
538: wtdiff NUMBER := 0;
539: voldiff NUMBER := 0;
540: l_loc_wt_uom VARCHAR2(3);
541: l_loc_vol_uom VARCHAR2(3);

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

730: p_client_code IN VARCHAR2,
731: x_ret_status OUT NOCOPY VARCHAR2
732: ) IS
733: l_api_name CONSTANT VARCHAR2(30) := 'set_client_info';
734: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
735: l_client_id NUMBER;
736: l_client_rec inv_cache.ct_rec_type;
737: BEGIN
738: SELECT client_id INTO l_client_id

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

770: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
771: ) IS
772: l_api_name CONSTANT VARCHAR2(30) := 'Create_LPNs';
773: l_api_version CONSTANT NUMBER := 1.0;
774: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
775: l_progress VARCHAR2(500) := 'Entered API';
776: l_msgdata VARCHAR2(1000);
777:
778: l_lpn_bulk_rec LPNBulkRecType;

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

819:
820: l_progress := 'Getting any profile user values';
821:
822: SELECT fnd_global.user_id
823: , FND_PROFILE.value('CONC_REQUEST_ID')
824: INTO l_user_id
825: , l_request_id
826: FROM DUAL;
827:

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

1218: p_client_id IN NUMBER
1219: , p_qty IN NUMBER
1220: , x_curr_seq OUT NOCOPY NUMBER
1221: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
1222: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1223: l_lpn_start_num NUMBER:=0;
1224:
1225: BEGIN
1226:

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

1266: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
1267: ) IS
1268: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Create_LPNs New';
1269: l_api_version CONSTANT NUMBER := 1.0;
1270: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1271: l_progress VARCHAR2(500) := 'Entered API';
1272: l_msgdata VARCHAR2(1000);
1273:
1274: -- Constants used for LPN processing

Line 1305: l_lsp_installed NUMBER := NVL(FND_PROFILE.VALUE('WMS_DEPLOYMENT_MODE'),1); --Added for LSPs, bug 9087971

1301: l_current_serial VARCHAR2(30);
1302: l_current_number NUMBER;
1303: l_padded_length NUMBER;
1304:
1305: l_lsp_installed NUMBER := NVL(FND_PROFILE.VALUE('WMS_DEPLOYMENT_MODE'),1); --Added for LSPs, bug 9087971
1306:
1307: BEGIN
1308: -- Standard Start of API savepoint
1309: SAVEPOINT AUTO_CREATE_LPNS_PVT;

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

1773: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
1774: ) IS
1775: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPNs';
1776: l_api_version CONSTANT NUMBER := 1.0;
1777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1778: l_progress VARCHAR2(500) := 'Entered API';
1779: l_msgdata VARCHAR2(1000);
1780: l_delivery_id NUMBER ; --7119011
1781: l_status_code VARCHAR2(2) := 'OP'; --7119011 / 7603755

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

3953: , p_source IN NUMBER := LPN_CONTEXT_PREGENERATED
3954: , p_cost_group_id IN NUMBER := NULL
3955: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
3956: ) IS
3957: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3958: x_return_status VARCHAR2(4);
3959: x_msg_count NUMBER;
3960: x_msg_data VARCHAR2(300);
3961: ret BOOLEAN;

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

4180: , p_client_code IN VARCHAR2 -- Adding for LSP, bug 9087971
4181: ) IS
4182: l_api_name CONSTANT VARCHAR2(30) := 'Generate_LPN New';
4183: l_api_version CONSTANT NUMBER := 1.0;
4184: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4185: l_progress VARCHAR2(10) := '0';
4186:
4187: l_ucc_128_suffix_flag VARCHAR2(1);
4188: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

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

4350: p_source_line_detail_id IN NUMBER := NULL
4351: ) IS
4352: l_api_name CONSTANT VARCHAR2(30) := 'Associate_LPN';
4353: l_api_version CONSTANT NUMBER := 1.0;
4354: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4355:
4356: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4357: BEGIN
4358: -- Standard Start of API savepoint

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

4475: , x_lpn_id OUT NOCOPY NUMBER
4476: ) IS
4477: l_api_name CONSTANT VARCHAR2(30) := 'Create_LPN';
4478: l_api_version CONSTANT NUMBER := 1.0;
4479: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4480: l_progress VARCHAR2(10) := '0';
4481: l_msgdata VARCHAR2(1000);
4482:
4483: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

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

4613: , p_source_transaction_id IN NUMBER := NULL
4614: ) IS
4615: l_api_name CONSTANT VARCHAR2(30) := 'PackUnpack_Container';
4616: l_api_version CONSTANT NUMBER := 1.0;
4617: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4618: l_request_id NUMBER := FND_PROFILE.value('CONC_REQUEST_ID');
4619: l_progress VARCHAR2(100) := '0';
4620: l_msgdata VARCHAR2(1000);
4621:

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

4614: ) IS
4615: l_api_name CONSTANT VARCHAR2(30) := 'PackUnpack_Container';
4616: l_api_version CONSTANT NUMBER := 1.0;
4617: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4618: l_request_id NUMBER := FND_PROFILE.value('CONC_REQUEST_ID');
4619: l_progress VARCHAR2(100) := '0';
4620: l_msgdata VARCHAR2(1000);
4621:
4622: -- Constants defined for transaction types

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

6527: , p_caller IN VARCHAR2 := NULL
6528: ) IS
6529: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPN_Wrapper';
6530: l_api_version CONSTANT NUMBER := 1.0;
6531: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6532: l_progress VARCHAR2(10) := '0';
6533: l_msgdata VARCHAR2(1000);
6534:
6535: l_lpn WMS_Data_Type_Definitions_PUB.LPNTableType;

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

6640: , x_valid_operation OUT NOCOPY NUMBER
6641: ) IS
6642: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Update_Wt_Volume';
6643: l_api_version CONSTANT NUMBER := 1.0;
6644: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6645: l_progress VARCHAR2(10) := '0';
6646:
6647: BEGIN
6648: -- Initialize API return status to success

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

6702: WHERE mtl_transactions_enabled_flag = 'Y'
6703: AND container_item_flag = 'Y'
6704: AND organization_id = p_organization_id);
6705:
6706: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6707: BEGIN
6708: -- Standard Start of API savepoint
6709: SAVEPOINT CONTAINER_REQUIRED_QTY_PVT;
6710: -- Standard call to check for call compatibility.

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

7028: x_return_status VARCHAR2(4);
7029: x_msg_count NUMBER;
7030: x_msg_data VARCHAR2(300);
7031: ret BOOLEAN;
7032: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7033:
7034: BEGIN
7035: -- Standard Start of API savepoint
7036: SAVEPOINT PREPACK_LPN_CP_PVT;

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

7143: , p_sec_uom IN VARCHAR2 := NULL --INVCONV kkillams
7144: ) IS
7145: l_api_name CONSTANT VARCHAR2(30) := 'Prepack_LPN';
7146: l_api_version CONSTANT NUMBER := 1.0;
7147: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7148: l_progress VARCHAR2(10) := '0';
7149:
7150: l_result NUMBER;
7151: l_container_item_id NUMBER := p_container_item_id;

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

8009: , p_source_type_id IN NUMBER := NULL
8010: ) IS
8011: l_api_name CONSTANT VARCHAR2(30) := 'Pack_Prepack_Container';
8012: l_api_version CONSTANT NUMBER := 1.0;
8013: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8014: l_progress VARCHAR2(10) := '0';
8015:
8016: l_current_serial VARCHAR2(30):= p_from_serial_number;
8017: l_prefix VARCHAR2(30);

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

8163: , x_content_tbl OUT NOCOPY WMS_CONTAINER_PUB.WMS_Container_Tbl_Type
8164: ) IS
8165: l_api_name CONSTANT VARCHAR2(30) := 'Explode_LPN';
8166: l_api_version CONSTANT NUMBER := 1.0;
8167: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8168: l_progress VARCHAR2(10) := '0';
8169: l_msgdata VARCHAR2(1000);
8170:
8171: l_counter NUMBER := 1; -- Counter variable initialized to 1

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

8449: , p_lock IN NUMBER := 2
8450: ) RETURN NUMBER IS
8451: l_api_name CONSTANT VARCHAR2(30) := 'Validate_LPN';
8452: l_api_version CONSTANT NUMBER := 1.0;
8453: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8454: l_progress VARCHAR2(10) := '0';
8455:
8456: BEGIN
8457: /* Check that either an lpn id or license plate number was given */

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

8528: , p_validation_type IN VARCHAR2
8529: ) RETURN NUMBER IS
8530: l_api_name CONSTANT VARCHAR2(30) := 'Validate_LPN';
8531: l_api_version CONSTANT NUMBER := 1.0;
8532: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8533: l_progress VARCHAR2(10) := '0';
8534:
8535: CURSOR Nested_LPN_Cursor IS
8536: SELECT lpn_id, lpn_context

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

8707: , p_outermost_lpn_id IN NUMBER
8708: ) IS
8709: l_api_name CONSTANT VARCHAR2(30) := 'Merge_Up_LPN';
8710: l_api_version CONSTANT NUMBER := 1.0;
8711: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8712: l_progress VARCHAR2(10) := '0';
8713:
8714: l_contents_tbl WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE;
8715: l_return_status NUMBER;

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

9148: , p_outermost_lpn_id IN NUMBER
9149: ) IS
9150: l_api_name CONSTANT VARCHAR2(30) := 'Break_Down_LPN';
9151: l_api_version CONSTANT NUMBER := 1.0;
9152: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9153: l_progress VARCHAR2(10) := '0';
9154:
9155: CURSOR nested_lpn_cursor IS
9156: SELECT rowid, lpn_id, parent_lpn_id, subinventory_code, locator_id

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

9293: , p_outermost_lpn_id IN NUMBER
9294: )IS
9295: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_LPNs';
9296: l_api_version CONSTANT NUMBER := 1.0;
9297: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9298: l_progress VARCHAR2(10) := '0';
9299:
9300: CURSOR nested_lpn_cursor IS
9301: SELECT rowid, lpn_id

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

9387:
9388: l_return_status VARCHAR2(1);
9389: l_msg_count NUMBER;
9390: l_msg_data VARCHAR2(2000);
9391: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9392: BEGIN
9393:
9394: SELECT wda.delivery_id
9395: INTO l_delivery_id

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

9469: p_lpn_context IN NUMBER,
9470: x_item OUT NOCOPY VARCHAR2 )
9471: IS
9472: l_api_name CONSTANT VARCHAR2(30) := 'get_item_from_lpn';
9473: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9474: l_lpn_context NUMBER;
9475: l_concatenated_segments mtl_system_items_b_kfv.concatenated_segments%TYPE;
9476: BEGIN
9477:

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

9538: FUNCTION get_lock_handle( p_type_name IN VARCHAR2 ) RETURN VARCHAR2
9539: IS
9540: PRAGMA AUTONOMOUS_TRANSACTION;
9541: l_lock_handle VARCHAR2(128);
9542: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9543:
9544: BEGIN
9545: IF (l_debug = 1) THEN
9546: mdebug('get lock handler ' ||p_type_name,4);

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

9559: l_lock_handle VARCHAR2(128);
9560: L_OUTER_LPN_ID NUMBER;
9561: l_type_name varchar2(100);
9562: l_lpn_name varchar2(100);
9563: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9564:
9565: BEGIN
9566:
9567: SELECT OUTERMOST_LPN_ID, LICENSE_PLATE_NUMBER