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_BATCH_PROCESS dependencies on WSH_BATCH_PROCESS

Line 1: PACKAGE BODY WSH_BATCH_PROCESS as

1: PACKAGE BODY WSH_BATCH_PROCESS as
2: /* $Header: WSHBHPSB.pls 120.18 2011/04/20 08:19:19 ashimalh ship $ */
3:
4: G_SHIP_CONFIRM CONSTANT VARCHAR2(5) := 'SC';
5: G_AUTO_PACK CONSTANT VARCHAR2(5) := 'AP';

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_BATCH_PROCESS';

3:
4: G_SHIP_CONFIRM CONSTANT VARCHAR2(5) := 'SC';
5: G_AUTO_PACK CONSTANT VARCHAR2(5) := 'AP';
6: g_error_message VARCHAR2(30);
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_BATCH_PROCESS';
8:
9:
10: -- -----------------------------------------------------------------------
11: -- Name

Line 26: p_input_info IN WSH_BATCH_PROCESS.Select_Criteria_Rec,

22: -- x_return_status - Success, Warning, Error, Unexpected Error
23: -- ----------------------------------------------------------------------
24:
25: PROCEDURE Select_Deliveries (
26: p_input_info IN WSH_BATCH_PROCESS.Select_Criteria_Rec,
27: p_batch_rec IN OUT NOCOPY WSH_PICKING_BATCHES%ROWTYPE,
28: x_selected_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
29: x_return_status OUT NOCOPY VARCHAR2)
30: IS

Line 28: x_selected_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,

24:
25: PROCEDURE Select_Deliveries (
26: p_input_info IN WSH_BATCH_PROCESS.Select_Criteria_Rec,
27: p_batch_rec IN OUT NOCOPY WSH_PICKING_BATCHES%ROWTYPE,
28: x_selected_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
29: x_return_status OUT NOCOPY VARCHAR2)
30: IS
31:
32: l_sc_SELECT VARCHAR2(3000) := NULL;

Line 466: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');

462: EXCEPTION
463:
464: WHEN others THEN
465:
466: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468: IF l_debug_on THEN
469: WSH_DEBUG_SV.pop(l_module_name);
470: END IF;

Line 716: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');

712: IF c_first_trip_ship_method%ISOPEN THEN
713: CLOSE c_first_trip_ship_method;
714: END IF;
715: WSH_UTIL_CORE.PrintMsg('ERROR: unhandled exception');
716: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: unhandled exception');
719: WSH_DEBUG_SV.POP(l_module_name);
720: END IF;

Line 894: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,

890: -- x_return_status - Success, Warning, Error, Unexpected Error
891: -- ----------------------------------------------------------------------
892:
893: PROCEDURE Ship_Confirm_Batch(
894: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
895: p_sc_batch_id IN NUMBER,
896: p_log_level IN NUMBER,
897: x_confirmed_del_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
898: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,

Line 898: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,

894: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
895: p_sc_batch_id IN NUMBER,
896: p_log_level IN NUMBER,
897: x_confirmed_del_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
898: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
899: x_return_status OUT NOCOPY VARCHAR2,
900: p_commit IN VARCHAR2) IS -- BugFix #4001135
901:
902: l_batch_creation_date DATE := NULL;

Line 1442: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Ship_Confirm_Batch');

1438: END IF;
1439: IF G_GET_SHIP_CONFIRM_RULE%ISOPEN THEN
1440: CLOSE G_GET_SHIP_CONFIRM_RULE;
1441: END IF;
1442: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Ship_Confirm_Batch');
1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1444: IF l_debug_on THEN
1445: WSH_DEBUG_SV.pop(l_module_name);
1446: END IF;

Line 1628: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Auto_Pack_A_Delivery');

1624:
1625: WHEN OTHERS THEN
1626: CLOSE get_delivery;
1627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1628: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Auto_Pack_A_Delivery');
1629: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock delivery '|| to_char(p_delivery_id));
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: Failed to lock delivery '|| to_char(p_delivery_id));
1632: WSH_DEBUG_SV.pop(l_module_name);

Line 1661: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,

1657: -- x_return_status - Success, Warning, Error, Unexpected Error
1658: -- ----------------------------------------------------------------------
1659:
1660: PROCEDURE Auto_Pack_Deliveries_Batch(
1661: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
1662: p_ap_batch_id IN NUMBER,
1663: p_auto_pack_level IN NUMBER,
1664: p_log_level IN NUMBER,
1665: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,

Line 1665: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,

1661: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
1662: p_ap_batch_id IN NUMBER,
1663: p_auto_pack_level IN NUMBER,
1664: p_log_level IN NUMBER,
1665: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
1666: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
1667: x_return_status OUT NOCOPY VARCHAR2,
1668: P_COMMIT IN VARCHAR2) IS -- BugFix #4001135
1669:

Line 1666: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,

1662: p_ap_batch_id IN NUMBER,
1663: p_auto_pack_level IN NUMBER,
1664: p_log_level IN NUMBER,
1665: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
1666: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
1667: x_return_status OUT NOCOPY VARCHAR2,
1668: P_COMMIT IN VARCHAR2) IS -- BugFix #4001135
1669:
1670: l_ap_packed_dels wsh_util_core.id_tab_type;

Line 1885: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Auto_Pack_Deliveries_Batch');

1881: WSH_DEBUG_SV.pop(l_module_name);
1882: END IF;
1883:
1884: WHEN others THEN
1885: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Auto_Pack_Deliveries_Batch');
1886: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1887: IF l_debug_on THEN
1888: WSH_DEBUG_SV.pop(l_module_name);
1889: END IF;

Line 1979: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;

1975: l_temp BOOLEAN;
1976: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
1977: l_debug_on BOOLEAN;
1978: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1979: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1980: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
1981: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
1982: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Confirm_Delivery_SRS';
1983: WSH_MISSING_SC_RULE EXCEPTION;

Line 1980: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

1976: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
1977: l_debug_on BOOLEAN;
1978: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1979: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1980: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
1981: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
1982: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Confirm_Delivery_SRS';
1983: WSH_MISSING_SC_RULE EXCEPTION;
1984: WSH_MISSING_SC_BATCH_PREFIX EXCEPTION;

Line 1981: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;

1977: l_debug_on BOOLEAN;
1978: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1979: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1980: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
1981: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
1982: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Confirm_Delivery_SRS';
1983: WSH_MISSING_SC_RULE EXCEPTION;
1984: WSH_MISSING_SC_BATCH_PREFIX EXCEPTION;
1985: WSH_SC_BATCH_ERR EXCEPTION;

Line 2459: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;

2455: l_rowid VARCHAR2(30);
2456: l_temp BOOLEAN;
2457: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2458: l_debug_on BOOLEAN;
2459: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2460: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2461: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2462: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2463:

Line 2460: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;

2456: l_temp BOOLEAN;
2457: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2458: l_debug_on BOOLEAN;
2459: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2460: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2461: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2462: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2463:
2464: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Auto_Pack_Deliveries_SRS';

Line 2461: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

2457: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2458: l_debug_on BOOLEAN;
2459: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2460: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2461: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2462: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2463:
2464: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Auto_Pack_Deliveries_SRS';
2465: WSH_PK_BATCH_ERR EXCEPTION;

Line 2462: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;

2458: l_debug_on BOOLEAN;
2459: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2460: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2461: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2462: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2463:
2464: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Auto_Pack_Deliveries_SRS';
2465: WSH_PK_BATCH_ERR EXCEPTION;
2466: WSH_INVALID_AUTO_PACK_LEVEL EXCEPTION;

Line 2862: WSH_UTIL_CORE.Default_Handler('WSH_BATCH_PROCESS.log_batch_messages');

2858:
2859:
2860: EXCEPTION
2861: WHEN OTHERS THEN
2862: WSH_UTIL_CORE.Default_Handler('WSH_BATCH_PROCESS.log_batch_messages');
2863: --
2864: IF l_debug_on THEN
2865: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION: OTHERS');
2866: END IF;

Line 2888: p_select_criteria IN WSH_BATCH_PROCESS.Select_Criteria_Rec,

2884: -- x_return_status Return status
2885: ---- ----------------------------------------------------------------------
2886:
2887: PROCEDURE Select_Delivery_Lines (
2888: p_select_criteria IN WSH_BATCH_PROCESS.Select_Criteria_Rec,
2889: p_autocreate_deliveries IN VARCHAR2,
2890: x_selected_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
2891: x_return_status OUT NOCOPY VARCHAR2)
2892: IS

Line 3332: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');

3328: -- if the cursor is still open then close the cursor
3329: IF v_cursorID <> 0 THEN
3330: DBMS_SQL.Close_Cursor(v_cursorID);
3331: END IF;
3332: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');
3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3334: IF l_debug_on THEN
3335: WSH_DEBUG_SV.pop(l_module_name);
3336: END IF;

Line 3548: WSH_UTIL_CORE.default_handler('WSH_BATCH_PROCESS.Process_Delivery_Lines_Batch');

3544: WHEN OTHERS THEN
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3546: ROLLBACK TO BEFORE_PROCESS_DELIVERIES;
3547: wsh_util_core.add_message(x_return_status, l_module_name);
3548: WSH_UTIL_CORE.default_handler('WSH_BATCH_PROCESS.Process_Delivery_Lines_Batch');
3549: FND_MSG_PUB.Count_And_Get
3550: (
3551: p_count => x_msg_count,
3552: p_data => x_msg_data,

Line 3658: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

3654: l_log_level NUMBER := 0;
3655: l_return_status VARCHAR2(30) := NULL;
3656: l_temp BOOLEAN;
3657: l_debug_on BOOLEAN;
3658: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
3659: l_appended_det_num NUMBER;
3660: l_appended_del_num NUMBER;
3661: l_autocreate_del_det_num NUMBER;
3662: l_selected_det_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 4507: END WSH_BATCH_PROCESS;

4503:
4504: END Process_Deliveries_SRS;
4505:
4506:
4507: END WSH_BATCH_PROCESS;
4508:
4509: