DBA Data[Home] [Help]

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.19.12010000.3 2008/10/17 11:54:35 brana 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 537: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT');

533: IF l_debug_on THEN
534: 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);
535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
536: END IF;
537: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT');
538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
539:
540: END transfer_serial_numbers_pvt;
541:

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

609: IF l_debug_on THEN
610: 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);
611: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
612: END IF;
613: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS');
614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
615:
616: END transfer_serial_numbers;
617:

Line 2305: p_mtl_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.Mtl_txn_if_rec_type,

2301:
2302: PROCEDURE Insert_inv_records(
2303: p_start_index IN number,
2304: p_end_index IN number,
2305: p_mtl_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.Mtl_txn_if_rec_type,
2306: p_mtl_ser_txn_if_rec IN OUT NOCOPY Mtl_ser_txn_if_rec_type,
2307: p_mtl_lot_txn_if_rec IN OUT NOCOPY Mtl_lot_txn_if_rec_type,
2308: p_def_inv_online IN VARCHAR2,
2309: x_return_status OUT NOCOPY VARCHAR2) IS

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

3074: /* getting the source_document_type id to see if it is an internal order or not */
3075: /* get order line info to decide if this is part of an internal order */
3076: IF l_debug_on THEN
3077: WSH_DEBUG_SV.log(l_module_name,'source_code',l_mtl_txn_if_rec.source_code(l_index));
3078: WSH_DEBUG_SV.log(l_module_name,'ont_source_code', WSH_SHIP_CONFIRM_ACTIONS.ont_source_code);
3079: END IF;
3080:
3081: -- for non-opm items derive additional information, based on the
3082: -- source_code

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

3082: -- source_code
3083:
3084: IF ( l_mtl_txn_if_rec.source_code(l_index) = 'OE' ) THEN --{
3085:
3086: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN
3087: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3088: END IF;
3089:
3090: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;

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

3083:
3084: IF ( l_mtl_txn_if_rec.source_code(l_index) = 'OE' ) THEN --{
3085:
3086: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN
3087: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3088: END IF;
3089:
3090: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;
3091: --

Line 3090: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;

3086: IF (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) THEN
3087: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3088: END IF;
3089:
3090: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;
3091: --
3092: IF l_debug_on THEN
3093: WSH_DEBUG_SV.log(l_module_name,'l_source_code',l_source_code);
3094: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER',

Line 4085: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := NULL;

4081: WSH_DEBUG_SV.push(l_module_name);
4082: WSH_DEBUG_SV.log(l_module_name,'p_batch_id',p_batch_id);
4083: END IF;
4084: --
4085: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := NULL;
4086:
4087:
4088: -- the batch should be fully interfaced to OM first.
4089:

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

5164:
5165: WHEN OTHERS THEN
5166: ROLLBACK TO s_Filter_Stops_From_Batch;
5167: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
5168: wsh_util_core.default_handler('WSH_SHIP_CONFIRM_ACTIONS.Filter_Stops_From_Batch');
5169:
5170: IF l_debug_on THEN
5171: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
5172: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 5275: WSH_SHIP_CONFIRM_ACTIONS.l_currentDate := SYSDATE;

5271: WSH_DEBUG_SV.logmsg(l_module_name, 'OM INTERFACING BATCH ' || TO_CHAR ( p_batch_id ) );
5272: END IF;
5273: --
5274:
5275: WSH_SHIP_CONFIRM_ACTIONS.l_currentDate := SYSDATE;
5276:
5277: --HVOP heali
5278: Interface_Stop_To_OM(
5279: p_batch_id => p_batch_id ,

Line 9162: END WSH_SHIP_CONFIRM_ACTIONS;

9158: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
9159: END IF;
9160: --
9161: END interface_ALL_wrp;
9162: END WSH_SHIP_CONFIRM_ACTIONS;