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_SHIP_CONFIRM_ACTIONS dependencies on WSH_SHIP_CONFIRM_ACTIONS

Line 1: PACKAGE BODY WSH_SHIP_CONFIRM_ACTIONS as

1: PACKAGE BODY WSH_SHIP_CONFIRM_ACTIONS as
2: /* $Header: WSHDDSHB.pls 120.35.12020000.7 2013/05/21 13:07:46 sunilku ship $ */
3:
4: c_inv_int_partial CONSTANT VARCHAR2(1) := 'P';
5: c_inv_int_full CONSTANT VARCHAR2(1) := 'Y';

Line 14: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIP_CONFIRM_ACTIONS';

10: g_intransit_time NUMBER;
11: g_prv_ship_method_code VARCHAR2(30);
12: --
13:
14: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIP_CONFIRM_ACTIONS';
15: --
16:
17: -- Bug 3628620
18: -- Old Procedure transfer_serial_numbers is modified to be a wrapper

Line 980: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT');

976: IF l_debug_on THEN
977: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
978: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
979: END IF;
980: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT');
981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
982:
983: END transfer_serial_numbers_pvt;
984:

Line 1056: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS');

1052: IF l_debug_on THEN
1053: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1054: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1055: END IF;
1056: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS');
1057: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1058:
1059: END transfer_serial_numbers;
1060:

Line 2794: p_mtl_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.Mtl_txn_if_rec_type,

2790:
2791: PROCEDURE Insert_inv_records(
2792: p_start_index IN number,
2793: p_end_index IN number,
2794: p_mtl_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.Mtl_txn_if_rec_type,
2795: p_mtl_ser_txn_if_rec IN OUT NOCOPY Mtl_ser_txn_if_rec_type,
2796: p_mtl_lot_txn_if_rec IN OUT NOCOPY Mtl_lot_txn_if_rec_type,
2797: p_def_inv_online IN VARCHAR2,
2798: x_return_status OUT NOCOPY VARCHAR2) IS

Line 3697: WSH_DEBUG_SV.log(l_module_name,'ont_source_code', WSH_SHIP_CONFIRM_ACTIONS.ont_source_code);

3693: /* getting the source_document_type id to see if it is an internal order or not */
3694: /* get order line info to decide if this is part of an internal order */
3695: IF l_debug_on THEN
3696: WSH_DEBUG_SV.log(l_module_name,'source_code',l_mtl_txn_if_rec.source_code(l_index));
3697: WSH_DEBUG_SV.log(l_module_name,'ont_source_code', WSH_SHIP_CONFIRM_ACTIONS.ont_source_code);
3698: END IF;
3699:
3700: -- for non-opm items derive additional information, based on the
3701: -- source_code

Line 3705: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN

3701: -- source_code
3702:
3703: IF ( l_mtl_txn_if_rec.source_code(l_index) = 'OE' ) THEN --{
3704:
3705: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN
3706: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3707: END IF;
3708:
3709: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;

Line 3706: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

3702:
3703: IF ( l_mtl_txn_if_rec.source_code(l_index) = 'OE' ) THEN --{
3704:
3705: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN
3706: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3707: END IF;
3708:
3709: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;
3710: --

Line 3709: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;

3705: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN
3706: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3707: END IF;
3708:
3709: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;
3710: --
3711: IF l_debug_on THEN
3712: WSH_DEBUG_SV.log(l_module_name,'l_source_code',l_source_code);
3713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER',

Line 5026: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := NULL;

5022: WSH_DEBUG_SV.push(l_module_name);
5023: WSH_DEBUG_SV.log(l_module_name,'p_batch_id',p_batch_id);
5024: END IF;
5025: --
5026: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := NULL;
5027:
5028:
5029: -- the batch should be fully interfaced to OM first.
5030:

Line 5770: p_oe_interface_rec IN WSH_SHIP_CONFIRM_ACTIONS.oe_interface_rec,

5766: -- As well as existing API Interface_stop_to_OM
5767: --========================================================================
5768: PROCEDURE Handle_Tolerances(
5769: p_batch_id IN NUMBER,
5770: p_oe_interface_rec IN WSH_SHIP_CONFIRM_ACTIONS.oe_interface_rec,
5771: x_fulfilled_flag OUT NOCOPY VARCHAR2,
5772: x_over_reason OUT NOCOPY VARCHAR2,
5773: x_return_status OUT NOCOPY VARCHAR2 ) IS
5774: l_debug_on BOOLEAN;

Line 6693: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.Filter_Stops_From_Batch');

6689:
6690: WHEN OTHERS THEN
6691: ROLLBACK TO s_Filter_Stops_From_Batch;
6692: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
6693: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.Filter_Stops_From_Batch');
6694:
6695: IF l_debug_on THEN
6696: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
6697: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 6800: WSH_SHIP_CONFIRM_ACTIONS.l_currentDate := SYSDATE;

6796: WSH_DEBUG_SV.logmsg(l_module_name, 'OM INTERFACING BATCH ' || TO_CHAR ( p_batch_id ) );
6797: END IF;
6798: --
6799:
6800: WSH_SHIP_CONFIRM_ACTIONS.l_currentDate := SYSDATE;
6801:
6802: --HVOP heali
6803: Interface_Stop_To_OM(
6804: p_batch_id => p_batch_id ,

Line 10577: --This cursor type should match with WSH_SHIP_CONFIRM_ACTIONS.oe_interface_rec

10573: l_remain_details_id WSH_UTIL_CORE.Id_Tab_Type ;
10574:
10575: --This cursor should fetch only one records per order line
10576: --Get total_requested_quantity and total_shipped_quantity for the order line
10577: --This cursor type should match with WSH_SHIP_CONFIRM_ACTIONS.oe_interface_rec
10578:
10579: /*Get all the details at order line level of the delivery passed which are shipped and not interfaced to OM */
10580: CURSOR c_get_oe_interface_line_detail(c_delivery_id NUMBER) IS
10581: SELECT dd.source_header_id ,

Line 10652: line_rec wsh_ship_confirm_actions.oe_interface_rec;

10648: ol.flow_status_code
10649: ORDER BY dd.organization_id ,
10650: dd.source_line_id ;
10651:
10652: line_rec wsh_ship_confirm_actions.oe_interface_rec;
10653: l_over_reason varchar2(1);
10654: l_delete_detail_id NUMBER;
10655: line_id_tab wsh_util_core.id_tab_type;
10656: i NUMBER :=0;

Line 10718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS.Process_lines_To_OM', WSH_DEBUG_SV.C_PROC_LEVEL);

10714: --Interfaces lines to OM
10715: IF (line_id_tab.count > 0 ) THEN
10716: --{
10717: IF l_debug_on THEN
10718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIP_CONFIRM_ACTIONS.Process_lines_To_OM', WSH_DEBUG_SV.C_PROC_LEVEL);
10719: END IF;
10720:
10721: /*Interface the delivery details to OM*/
10722: Process_lines_To_OM(p_line_id_tab =>line_id_tab,

Line 11273: END WSH_SHIP_CONFIRM_ACTIONS;

11269: END IF;
11270:
11271: END Process_lines_To_OM;
11272:
11273: END WSH_SHIP_CONFIRM_ACTIONS;