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 866: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;

862:
863: i NUMBER;
864: l_count NUMBER;
865: l_count_x_relstatus_details NUMBER;
866: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
867: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
868: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
869: l_rel_delivery_detail_id WSH_UTIL_CORE.Id_Tab_Type;
870: l_dummy_rsv_tbl INV_RESERVATION_GLOBAL.Mtl_Reservation_Tbl_Type;

Line 867: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

863: i NUMBER;
864: l_count NUMBER;
865: l_count_x_relstatus_details NUMBER;
866: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
867: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
868: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
869: l_rel_delivery_detail_id WSH_UTIL_CORE.Id_Tab_Type;
870: l_dummy_rsv_tbl INV_RESERVATION_GLOBAL.Mtl_Reservation_Tbl_Type;
871:

Line 868: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

864: l_count NUMBER;
865: l_count_x_relstatus_details NUMBER;
866: l_temp_trolin_rec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
867: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
868: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
869: l_rel_delivery_detail_id WSH_UTIL_CORE.Id_Tab_Type;
870: l_dummy_rsv_tbl INV_RESERVATION_GLOBAL.Mtl_Reservation_Tbl_Type;
871:
872: -- WMS

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

1424: --{
1425: IF p_express_pick_flag = 'N' THEN
1426: --{
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_LINES',
1429: WSH_DEBUG_SV.C_PROC_LEVEL);
1430: WSH_DEBUG_SV.log(l_module_name, 'G_TROLIN_TBL.COUNT',G_TROLIN_TBL.COUNT);
1431: WSH_DEBUG_SV.log(l_module_name, 'Current Time is ',SYSDATE);
1432: END IF;

Line 1433: Inv_Move_Order_Pub.Create_Move_Order_Lines

1429: WSH_DEBUG_SV.C_PROC_LEVEL);
1430: WSH_DEBUG_SV.log(l_module_name, 'G_TROLIN_TBL.COUNT',G_TROLIN_TBL.COUNT);
1431: WSH_DEBUG_SV.log(l_module_name, 'Current Time is ',SYSDATE);
1432: END IF;
1433: Inv_Move_Order_Pub.Create_Move_Order_Lines
1434: (
1435: p_api_version_number => l_api_version_number,
1436: p_init_msg_list => FND_API.G_FALSE,
1437: p_return_values => FND_API.G_TRUE,

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

1452: WSH_DEBUG_SV.log(l_module_name, 'l_msg_data', l_msg_data);
1453: END IF;
1454: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1455: --{
1456: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Create_Move_Order_Lines');
1457: FOR i in 1..l_msg_count LOOP
1458: l_message := fnd_msg_pub.get(i,'F');
1459: l_message := replace(l_message,chr(0),' ');
1460: WSH_UTIL_CORE.PrintMsg(l_message);

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

1461: END LOOP;
1462: fnd_msg_pub.delete_msg();
1463: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1464: --{
1465: WSH_UTIL_CORE.PrintMsg('Unexpected error from Inv_Move_Order_Pub.Create_Move_Order_Lines. Exiting');
1466: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1467: IF l_debug_on THEN
1468: WSH_DEBUG_SV.pop(l_module_name);
1469: END IF;

Line 4002: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

3998:
3999: l_return_status VARCHAR2(1);
4000: l_completion_status VARCHAR2(30);
4001: l_temp BOOLEAN;
4002: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

Line 4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

3999: l_return_status VARCHAR2(1);
4000: l_completion_status VARCHAR2(30);
4001: l_temp BOOLEAN;
4002: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

Line 4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

4000: l_completion_status VARCHAR2(30);
4001: l_temp BOOLEAN;
4002: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
4008: l_api_version_number NUMBER := 1.0;

Line 4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

4001: l_temp BOOLEAN;
4002: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
4008: l_api_version_number NUMBER := 1.0;
4009: l_msg_count NUMBER;

Line 4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

4002: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
4008: l_api_version_number NUMBER := 1.0;
4009: l_msg_count NUMBER;
4010: l_msg_data VARCHAR2(2000);

Line 4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

4003: l_empty_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
4004: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4005: l_empty_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
4006: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
4008: l_api_version_number NUMBER := 1.0;
4009: l_msg_count NUMBER;
4010: l_msg_data VARCHAR2(2000);
4011: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 4111: l_mo_lines_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;

4107: l_org_info_tbl WSH_PICK_LIST.Org_Params_Rec_Tbl;
4108: l_detail_cfetch NUMBER;
4109: l_detail_pfetch NUMBER;
4110: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
4111: l_mo_lines_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4112: l_carton_grouping_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4113: l_print_ps VARCHAR2(1);
4114: l_phase VARCHAR2(100);
4115: l_status VARCHAR2(100);

Line 4112: l_carton_grouping_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;

4108: l_detail_cfetch NUMBER;
4109: l_detail_pfetch NUMBER;
4110: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
4111: l_mo_lines_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4112: l_carton_grouping_tbl INV_MOVE_ORDER_PUB.Num_Tbl_Type;
4113: l_print_ps VARCHAR2(1);
4114: l_phase VARCHAR2(100);
4115: l_status VARCHAR2(100);
4116: l_dev_phase VARCHAR2(100);

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

4580: l_trohdr_rec.request_number := l_batch_name;
4581:
4582: -- 90.7 Create Move Order Header
4583: IF l_debug_on THEN
4584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_HEADER',WSH_DEBUG_SV.C_PROC_LEVEL);
4585: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4586: END IF;
4587:
4588: Inv_Move_Order_Pub.Create_Move_Order_Header

Line 4588: Inv_Move_Order_Pub.Create_Move_Order_Header

4584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.CREATE_MOVE_ORDER_HEADER',WSH_DEBUG_SV.C_PROC_LEVEL);
4585: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4586: END IF;
4587:
4588: Inv_Move_Order_Pub.Create_Move_Order_Header
4589: (
4590: p_api_version_number => l_api_version_number,
4591: p_init_msg_list => FND_API.G_FALSE,
4592: p_return_values => FND_API.G_TRUE,

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

4600: x_msg_data => l_msg_data
4601: );
4602:
4603: IF l_debug_on THEN
4604: WSH_DEBUG_SV.log(l_module_name,'Inv_Move_Order_Pub.Create_Move_Order_Header l_return_status',l_return_status);
4605: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4606: END IF;
4607:
4608: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

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

4607:
4608: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
4609: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --{
4610:
4611: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Create_Move_Order_Header');
4612: FOR i in 1..l_msg_count LOOP
4613: l_message := fnd_msg_pub.get(i,'F');
4614: l_message := replace(l_message,chr(0),' ');
4615: WSH_UTIL_CORE.PrintMsg(l_message);

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

5363: END LOOP;
5364: --bug 7171766 till here
5365:
5366: IF l_debug_on THEN
5367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id'
5368: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5369: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5370: END IF;
5371: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (

Line 5371: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (

5367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id'
5368: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5369: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5370: END IF;
5371: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (
5372: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5373: p_carton_grouping_tbl => l_carton_grouping_tbl,
5374: p_move_order_line_tbl => l_mo_lines_tbl );
5375: IF l_debug_on THEN

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

5373: p_carton_grouping_tbl => l_carton_grouping_tbl,
5374: p_move_order_line_tbl => l_mo_lines_tbl );
5375: IF l_debug_on THEN
5376: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5377: WSH_DEBUG_SV.logmsg(l_module_name,'Return from program unit INV_MOVE_ORDER_PUB.Stamp_Cart_Id');
5378: END IF;
5379:
5380: <>
5381: NULL;

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

5500: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_DELETE;
5501: l_trolin_tbl.delete;
5502: l_trolin_val_tbl.delete;
5503: IF l_debug_on THEN
5504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'
5505: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5506: END IF;
5507: Inv_Move_Order_Pub.Process_Move_Order (
5508: p_api_version_number => l_api_version_number,

Line 5507: Inv_Move_Order_Pub.Process_Move_Order (

5503: IF l_debug_on THEN
5504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER'
5505: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5506: END IF;
5507: Inv_Move_Order_Pub.Process_Move_Order (
5508: p_api_version_number => l_api_version_number,
5509: p_init_msg_list => FND_API.G_FALSE,
5510: p_return_values => FND_API.G_TRUE,
5511: p_commit => l_commit,

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

5517: x_return_status => l_return_status,
5518: x_msg_count => l_msg_count,
5519: x_msg_data => l_msg_data );
5520: IF l_debug_on THEN
5521: WSH_DEBUG_SV.log(l_module_name,'Inv_Move_Order_Pub.Process_Move_Order l_return_status'
5522: ,l_return_status);
5523: END IF;
5524: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5525: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

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

5522: ,l_return_status);
5523: END IF;
5524: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5525: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
5526: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Move_Order_Pub.Process_Move_Order');
5527: FOR i in 1..l_msg_count LOOP
5528: l_message := fnd_msg_pub.get(i,'F');
5529: l_message := replace(l_message,chr(0),' ');
5530: WSH_UTIL_CORE.PrintMsg(l_message);