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.WSH_PICK_LIST dependencies on INV_MOVE_ORDER_PUB

Line 43: -- fails after successfull call to Inv_Move_Order_Pub.Create_Move_Order_Lines

39: -- Following globals are needed by online_release API to pass back to the Pick Release Form
40: G_ONLINE_PICK_RELEASE_PHASE VARCHAR2(30) := null;
41: -- Possible values are - START, MOVE_ORDER_LINES,SUCCESS
42: -- MOVE_ORDER_LINES is used by Form to give a different message if Process
43: -- fails after successfull call to Inv_Move_Order_Pub.Create_Move_Order_Lines
44:
45: G_ONLINE_PICK_RELEASE_RESULT VARCHAR2(1) := 'F';
46: -- Possible values are S(Success) and F(failure)
47:

Line 56: g_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

52:
53: g_demand_table demRecTabTyp;
54:
55: -- Global Variables
56: g_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
57: g_trolin_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
58: g_order_number NUMBER;
59: g_del_detail_ids WSH_PICK_LIST.DelDetTabTyp;
60: g_exp_pick_release_stat Inv_Express_Pick_Pub.P_Pick_Release_Status_Tbl;

Line 851: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;

847:
848: i NUMBER;
849: l_count NUMBER;
850: l_count_x_relstatus_details NUMBER;
851: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
852: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
853: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
854: l_rel_delivery_detail_id WSH_UTIL_CORE.Id_Tab_Type;
855: l_dummy_rsv_tbl INV_RESERVATION_GLOBAL.Mtl_Reservation_Tbl_Type;

Line 852: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

848: i NUMBER;
849: l_count NUMBER;
850: l_count_x_relstatus_details NUMBER;
851: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
852: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
853: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
854: l_rel_delivery_detail_id WSH_UTIL_CORE.Id_Tab_Type;
855: l_dummy_rsv_tbl INV_RESERVATION_GLOBAL.Mtl_Reservation_Tbl_Type;
856:

Line 853: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

849: l_count NUMBER;
850: l_count_x_relstatus_details NUMBER;
851: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
852: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
853: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
854: l_rel_delivery_detail_id WSH_UTIL_CORE.Id_Tab_Type;
855: l_dummy_rsv_tbl INV_RESERVATION_GLOBAL.Mtl_Reservation_Tbl_Type;
856:
857: -- WMS

Line 1367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_LINES',

1363: --{
1364: IF p_express_pick_flag = 'N' THEN
1365: --{
1366: IF l_debug_on THEN
1367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_LINES',
1368: WSH_DEBUG_SV.C_PROC_LEVEL);
1369: WSH_DEBUG_SV.log(l_module_name, 'G_TROLIN_TBL.COUNT',G_TROLIN_TBL.COUNT);
1370: WSH_DEBUG_SV.log(l_module_name, 'Current Time is ',SYSDATE);
1371: END IF;

Line 1372: Inv_Move_Order_Pub.Create_Move_Order_Lines

1368: WSH_DEBUG_SV.C_PROC_LEVEL);
1369: WSH_DEBUG_SV.log(l_module_name, 'G_TROLIN_TBL.COUNT',G_TROLIN_TBL.COUNT);
1370: WSH_DEBUG_SV.log(l_module_name, 'Current Time is ',SYSDATE);
1371: END IF;
1372: Inv_Move_Order_Pub.Create_Move_Order_Lines
1373: (
1374: p_api_version_number => l_api_version_number,
1375: p_init_msg_list => FND_API.G_FALSE,
1376: p_return_values => FND_API.G_TRUE,

Line 1395: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Create_Move_Order_Lines');

1391: WSH_DEBUG_SV.log(l_module_name, 'l_msg_data', l_msg_data);
1392: END IF;
1393: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1394: --{
1395: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Create_Move_Order_Lines');
1396: FOR i in 1..l_msg_count LOOP
1397: l_message := fnd_msg_pub.get(i,'F');
1398: l_message := replace(l_message,chr(0),' ');
1399: WSH_UTIL_CORE.PrintMsg(l_message);

Line 1404: WSH_UTIL_CORE.PrintMsg('Unexpected error from Inv_Move_Order_Pub.Create_Move_Order_Lines. Exiting');

1400: END LOOP;
1401: fnd_msg_pub.delete_msg();
1402: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1403: --{
1404: WSH_UTIL_CORE.PrintMsg('Unexpected error from Inv_Move_Order_Pub.Create_Move_Order_Lines. Exiting');
1405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1406: IF l_debug_on THEN
1407: WSH_DEBUG_SV.pop(l_module_name);
1408: END IF;

Line 3912: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

3908:
3909: l_return_status VARCHAR2(1);
3910: l_completion_status VARCHAR2(30);
3911: l_temp BOOLEAN;
3912: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

Line 3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

3909: l_return_status VARCHAR2(1);
3910: l_completion_status VARCHAR2(30);
3911: l_temp BOOLEAN;
3912: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

Line 3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

3910: l_completion_status VARCHAR2(30);
3911: l_temp BOOLEAN;
3912: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
3918: l_api_version_number NUMBER := 1.0;

Line 3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

3911: l_temp BOOLEAN;
3912: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
3918: l_api_version_number NUMBER := 1.0;
3919: l_msg_count NUMBER;

Line 3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

3912: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
3918: l_api_version_number NUMBER := 1.0;
3919: l_msg_count NUMBER;
3920: l_msg_data VARCHAR2(2000);

Line 3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

3913: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
3914: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3915: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
3916: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
3918: l_api_version_number NUMBER := 1.0;
3919: l_msg_count NUMBER;
3920: l_msg_data VARCHAR2(2000);
3921: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 4021: l_mo_lines_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;

4017: l_org_info_tbl WSH_PICK_LIST.Org_Params_Rec_Tbl;
4018: l_detail_cfetch NUMBER;
4019: l_detail_pfetch NUMBER;
4020: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
4021: l_mo_lines_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4022: l_carton_grouping_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4023: l_print_ps VARCHAR2(1);
4024: l_phase VARCHAR2(100);
4025: l_status VARCHAR2(100);

Line 4022: l_carton_grouping_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;

4018: l_detail_cfetch NUMBER;
4019: l_detail_pfetch NUMBER;
4020: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
4021: l_mo_lines_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4022: l_carton_grouping_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4023: l_print_ps VARCHAR2(1);
4024: l_phase VARCHAR2(100);
4025: l_status VARCHAR2(100);
4026: l_dev_phase VARCHAR2(100);

Line 4489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_HEADER',WSH_DEBUG_SV.C_PROC_LEVEL);

4485: l_trohdr_rec.request_number := l_batch_name;
4486:
4487: -- 90.7 Create Move Order Header
4488: IF l_debug_on THEN
4489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_HEADER',WSH_DEBUG_SV.C_PROC_LEVEL);
4490: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4491: END IF;
4492:
4493: Inv_Move_Order_Pub.Create_Move_Order_Header

Line 4493: Inv_Move_Order_Pub.Create_Move_Order_Header

4489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_HEADER',WSH_DEBUG_SV.C_PROC_LEVEL);
4490: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4491: END IF;
4492:
4493: Inv_Move_Order_Pub.Create_Move_Order_Header
4494: (
4495: p_api_version_number => l_api_version_number,
4496: p_init_msg_list => FND_API.G_FALSE,
4497: p_return_values => FND_API.G_TRUE,

Line 4509: WSH_DEBUG_SV.log(l_module_name,'Inv_Move_Order_Pub.Create_Move_Order_Header l_return_status',l_return_status);

4505: x_msg_data => l_msg_data
4506: );
4507:
4508: IF l_debug_on THEN
4509: WSH_DEBUG_SV.log(l_module_name,'Inv_Move_Order_Pub.Create_Move_Order_Header l_return_status',l_return_status);
4510: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4511: END IF;
4512:
4513: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

Line 4516: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Create_Move_Order_Header');

4512:
4513: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
4514: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --{
4515:
4516: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Create_Move_Order_Header');
4517: FOR i in 1..l_msg_count LOOP
4518: l_message := fnd_msg_pub.get(i,'F');
4519: l_message := replace(l_message,chr(0),' ');
4520: WSH_UTIL_CORE.PrintMsg(l_message);

Line 5258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id'

5254: END LOOP;
5255: --bug 7171766 till here
5256:
5257: IF l_debug_on THEN
5258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id'
5259: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5260: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5261: END IF;
5262: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (

Line 5262: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (

5258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id'
5259: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5260: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5261: END IF;
5262: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (
5263: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5264: p_carton_grouping_tbl => l_carton_grouping_tbl,
5265: p_move_order_line_tbl => l_mo_lines_tbl );
5266: IF l_debug_on THEN

Line 5268: WSH_DEBUG_SV.logmsg(l_module_name,'Return from program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id');

5264: p_carton_grouping_tbl => l_carton_grouping_tbl,
5265: p_move_order_line_tbl => l_mo_lines_tbl );
5266: IF l_debug_on THEN
5267: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5268: WSH_DEBUG_SV.logmsg(l_module_name,'Return from program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id');
5269: END IF;
5270:
5271: -- Call to WMS Cartonize API
5272: IF l_debug_on THEN

Line 5370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'

5366: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_DELETE;
5367: l_trolin_tbl.delete;
5368: l_trolin_val_tbl.delete;
5369: IF l_debug_on THEN
5370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'
5371: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5372: END IF;
5373: Inv_Move_Order_Pub.Process_Move_Order (
5374: p_api_version_number => l_api_version_number,

Line 5373: Inv_Move_Order_Pub.Process_Move_Order (

5369: IF l_debug_on THEN
5370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'
5371: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5372: END IF;
5373: Inv_Move_Order_Pub.Process_Move_Order (
5374: p_api_version_number => l_api_version_number,
5375: p_init_msg_list => FND_API.G_FALSE,
5376: p_return_values => FND_API.G_TRUE,
5377: p_commit => l_commit,

Line 5387: WSH_DEBUG_SV.log(l_module_name,'Inv_Move_Order_Pub.Process_Move_Order l_return_status'

5383: x_return_status => l_return_status,
5384: x_msg_count => l_msg_count,
5385: x_msg_data => l_msg_data );
5386: IF l_debug_on THEN
5387: WSH_DEBUG_SV.log(l_module_name,'Inv_Move_Order_Pub.Process_Move_Order l_return_status'
5388: ,l_return_status);
5389: END IF;
5390: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5391: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

Line 5392: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Process_Move_Order');

5388: ,l_return_status);
5389: END IF;
5390: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5391: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
5392: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Process_Move_Order');
5393: FOR i in 1..l_msg_count LOOP
5394: l_message := fnd_msg_pub.get(i,'F');
5395: l_message := replace(l_message,chr(0),' ');
5396: WSH_UTIL_CORE.PrintMsg(l_message);