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.

[Home] [Help]

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.10 2006/12/13 18:31:19 rlanka noship $ */
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 442: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');

438: EXCEPTION
439:
440: WHEN others THEN
441:
442: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');
443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.pop(l_module_name);
446: END IF;

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

688: IF c_first_trip_ship_method%ISOPEN THEN
689: CLOSE c_first_trip_ship_method;
690: END IF;
691: WSH_UTIL_CORE.PrintMsg('ERROR: unhandled exception');
692: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');
693: IF l_debug_on THEN
694: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: unhandled exception');
695: WSH_DEBUG_SV.POP(l_module_name);
696: END IF;

Line 870: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,

866: -- x_return_status - Success, Warning, Error, Unexpected Error
867: -- ----------------------------------------------------------------------
868:
869: PROCEDURE Ship_Confirm_Batch(
870: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
871: p_sc_batch_id IN NUMBER,
872: p_log_level IN NUMBER,
873: x_confirmed_del_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
874: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,

Line 874: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,

870: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
871: p_sc_batch_id IN NUMBER,
872: p_log_level IN NUMBER,
873: x_confirmed_del_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
874: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
875: x_return_status OUT NOCOPY VARCHAR2,
876: p_commit IN VARCHAR2) IS -- BugFix #4001135
877:
878: l_batch_creation_date DATE := NULL;

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

1414: END IF;
1415: IF G_GET_SHIP_CONFIRM_RULE%ISOPEN THEN
1416: CLOSE G_GET_SHIP_CONFIRM_RULE;
1417: END IF;
1418: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Ship_Confirm_Batch');
1419: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.pop(l_module_name);
1422: END IF;

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

1600:
1601: WHEN OTHERS THEN
1602: CLOSE get_delivery;
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1604: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Auto_Pack_A_Delivery');
1605: WSH_UTIL_CORE.PrintMsg('ERROR: Failed to lock delivery '|| to_char(p_delivery_id));
1606: IF l_debug_on THEN
1607: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: Failed to lock delivery '|| to_char(p_delivery_id));
1608: WSH_DEBUG_SV.pop(l_module_name);

Line 1637: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,

1633: -- x_return_status - Success, Warning, Error, Unexpected Error
1634: -- ----------------------------------------------------------------------
1635:
1636: PROCEDURE Auto_Pack_Deliveries_Batch(
1637: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
1638: p_ap_batch_id IN NUMBER,
1639: p_auto_pack_level IN NUMBER,
1640: p_log_level IN NUMBER,
1641: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,

Line 1641: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,

1637: p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
1638: p_ap_batch_id IN NUMBER,
1639: p_auto_pack_level IN NUMBER,
1640: p_log_level IN NUMBER,
1641: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
1642: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
1643: x_return_status OUT NOCOPY VARCHAR2,
1644: P_COMMIT IN VARCHAR2) IS -- BugFix #4001135
1645:

Line 1642: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,

1638: p_ap_batch_id IN NUMBER,
1639: p_auto_pack_level IN NUMBER,
1640: p_log_level IN NUMBER,
1641: x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
1642: x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
1643: x_return_status OUT NOCOPY VARCHAR2,
1644: P_COMMIT IN VARCHAR2) IS -- BugFix #4001135
1645:
1646: l_ap_packed_dels wsh_util_core.id_tab_type;

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

1857: WSH_DEBUG_SV.pop(l_module_name);
1858: END IF;
1859:
1860: WHEN others THEN
1861: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Auto_Pack_Deliveries_Batch');
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1863: IF l_debug_on THEN
1864: WSH_DEBUG_SV.pop(l_module_name);
1865: END IF;

Line 1952: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;

1948: l_temp BOOLEAN;
1949: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
1950: l_debug_on BOOLEAN;
1951: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1952: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1953: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
1954: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
1955: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Confirm_Delivery_SRS';
1956: WSH_MISSING_SC_RULE EXCEPTION;

Line 1953: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

1949: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
1950: l_debug_on BOOLEAN;
1951: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1952: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1953: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
1954: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
1955: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Confirm_Delivery_SRS';
1956: WSH_MISSING_SC_RULE EXCEPTION;
1957: WSH_MISSING_SC_BATCH_PREFIX EXCEPTION;

Line 1954: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;

1950: l_debug_on BOOLEAN;
1951: l_confirmed_del_tab WSH_UTIL_CORE.Id_Tab_Type;
1952: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
1953: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
1954: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
1955: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Confirm_Delivery_SRS';
1956: WSH_MISSING_SC_RULE EXCEPTION;
1957: WSH_MISSING_SC_BATCH_PREFIX EXCEPTION;
1958: WSH_SC_BATCH_ERR EXCEPTION;

Line 2429: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;

2425: l_rowid VARCHAR2(30);
2426: l_temp BOOLEAN;
2427: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2428: l_debug_on BOOLEAN;
2429: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2430: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2431: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2432: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2433:

Line 2430: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;

2426: l_temp BOOLEAN;
2427: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2428: l_debug_on BOOLEAN;
2429: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2430: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2431: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2432: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2433:
2434: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Auto_Pack_Deliveries_SRS';

Line 2431: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

2427: l_batch_rec WSH_PICKING_BATCHES%ROWTYPE;
2428: l_debug_on BOOLEAN;
2429: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2430: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2431: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2432: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2433:
2434: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Auto_Pack_Deliveries_SRS';
2435: WSH_PK_BATCH_ERR EXCEPTION;

Line 2432: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;

2428: l_debug_on BOOLEAN;
2429: l_packed_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2430: l_selected_del_tab WSH_BATCH_PROCESS.Del_Info_Tab;
2431: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
2432: l_results_summary WSH_BATCH_PROCESS.Results_Summary_Rec;
2433:
2434: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Auto_Pack_Deliveries_SRS';
2435: WSH_PK_BATCH_ERR EXCEPTION;
2436: WSH_INVALID_AUTO_PACK_LEVEL EXCEPTION;

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

2828:
2829:
2830: EXCEPTION
2831: WHEN OTHERS THEN
2832: WSH_UTIL_CORE.Default_Handler('WSH_BATCH_PROCESS.log_batch_messages');
2833: --
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION: OTHERS');
2836: END IF;

Line 2858: p_select_criteria IN WSH_BATCH_PROCESS.Select_Criteria_Rec,

2854: -- x_return_status Return status
2855: ---- ----------------------------------------------------------------------
2856:
2857: PROCEDURE Select_Delivery_Lines (
2858: p_select_criteria IN WSH_BATCH_PROCESS.Select_Criteria_Rec,
2859: p_autocreate_deliveries IN VARCHAR2,
2860: x_selected_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
2861: x_return_status OUT NOCOPY VARCHAR2)
2862: IS

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

3238: -- if the cursor is still open then close the cursor
3239: IF v_cursorID <> 0 THEN
3240: DBMS_SQL.Close_Cursor(v_cursorID);
3241: END IF;
3242: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');
3243: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3244: IF l_debug_on THEN
3245: WSH_DEBUG_SV.pop(l_module_name);
3246: END IF;

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

3466: WHEN OTHERS THEN
3467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3468: ROLLBACK TO BEFORE_PROCESS_DELIVERIES;
3469: wsh_util_core.add_message(x_return_status, l_module_name);
3470: WSH_UTIL_CORE.default_handler('WSH_BATCH_PROCESS.Process_Delivery_Lines_Batch');
3471: FND_MSG_PUB.Count_And_Get
3472: (
3473: p_count => x_msg_count,
3474: p_data => x_msg_data,

Line 3569: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;

3565: l_log_level NUMBER := 0;
3566: l_return_status VARCHAR2(30) := NULL;
3567: l_temp BOOLEAN;
3568: l_debug_on BOOLEAN;
3569: l_select_criteria WSH_BATCH_PROCESS.Select_Criteria_Rec;
3570: l_appended_det_num NUMBER;
3571: l_appended_del_num NUMBER;
3572: l_autocreate_del_det_num NUMBER;
3573: l_selected_det_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 4354: END WSH_BATCH_PROCESS;

4350:
4351: END Process_Deliveries_SRS;
4352:
4353:
4354: END WSH_BATCH_PROCESS;
4355:
4356: