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 WSH_BATCH_PROCESS

Line 2413: l_ship_confirm_rule_rec WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%ROWTYPE;

2409: FROM wsh_picking_batches
2410: WHERE batch_id = c_batch_id;
2411:
2412: --
2413: l_ship_confirm_rule_rec WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%ROWTYPE;
2414: l_ship_confirm_rule_id NUMBER;
2415: l_batch_creation_date DATE;
2416: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
2417: l_curr_count NUMBER;

Line 3377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BATCH_PROCESS.Auto_Pack_A_Delivery'

3373: --{
3374: IF crec.ap_level > 0 THEN
3375: --{
3376: IF l_debug_on THEN
3377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BATCH_PROCESS.Auto_Pack_A_Delivery'
3378: ,WSH_DEBUG_SV.C_PROC_LEVEL);
3379: END IF;
3380: l_del_pack_count := l_del_pack_count + 1;
3381: WSH_BATCH_PROCESS.Auto_Pack_A_Delivery (

Line 3381: WSH_BATCH_PROCESS.Auto_Pack_A_Delivery (

3377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BATCH_PROCESS.Auto_Pack_A_Delivery'
3378: ,WSH_DEBUG_SV.C_PROC_LEVEL);
3379: END IF;
3380: l_del_pack_count := l_del_pack_count + 1;
3381: WSH_BATCH_PROCESS.Auto_Pack_A_Delivery (
3382: p_delivery_id => crec.delivery_id,
3383: p_ap_batch_id => crec.PA_SC_BATCH_ID,
3384: p_auto_pack_level => crec.ap_level,
3385: p_log_level => p_log_level,

Line 3392: WSH_BATCH_PROCESS.log_batch_messages (

3388: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3389: l_packed_results_success := l_packed_results_success + 1;
3390: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3391: l_packed_results_warning := l_packed_results_warning + 1;
3392: WSH_BATCH_PROCESS.log_batch_messages (
3393: crec.PA_SC_BATCH_ID,
3394: crec.delivery_id,
3395: NULL,
3396: crec.PICKUP_LOCATION_ID,

Line 3400: WSH_BATCH_PROCESS.log_batch_messages (

3396: crec.PICKUP_LOCATION_ID,
3397: 'W' );
3398: ELSE
3399: l_packed_results_failure := l_packed_results_failure + 1;
3400: WSH_BATCH_PROCESS.log_batch_messages (
3401: crec.PA_SC_BATCH_ID,
3402: crec.delivery_id,
3403: NULL,
3404: crec.PICKUP_LOCATION_ID,

Line 3423: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);

3419: BEGIN
3420: l_del_sc_count := l_del_sc_count + 1;
3421: IF crec.sc_rule_id <> nvl(l_prev_sc_rule_id,-99) THEN
3422: --{
3423: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3424: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3425: INTO l_ship_confirm_rule_rec;
3426: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3427: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

Line 3424: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE

3420: l_del_sc_count := l_del_sc_count + 1;
3421: IF crec.sc_rule_id <> nvl(l_prev_sc_rule_id,-99) THEN
3422: --{
3423: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3424: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3425: INTO l_ship_confirm_rule_rec;
3426: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3427: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3428: RAISE WSH_MISSING_SC_RULE;

Line 3426: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN

3422: --{
3423: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3424: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3425: INTO l_ship_confirm_rule_rec;
3426: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3427: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3428: RAISE WSH_MISSING_SC_RULE;
3429: ELSE
3430: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

Line 3427: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

3423: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3424: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3425: INTO l_ship_confirm_rule_rec;
3426: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3427: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3428: RAISE WSH_MISSING_SC_RULE;
3429: ELSE
3430: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3431: END IF;

Line 3430: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

3426: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3427: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3428: RAISE WSH_MISSING_SC_RULE;
3429: ELSE
3430: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3431: END IF;
3432: l_prev_sc_rule_id := crec.sc_rule_id;
3433: --}
3434: END IF;

Line 3438: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');

3434: END IF;
3435:
3436: --{
3437: IF l_debug_on THEN
3438: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');
3439: END IF;
3440: WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery (
3441: p_delivery_id => crec.delivery_id,
3442: p_sc_batch_id => crec.pa_sc_batch_id,

Line 3440: WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery (

3436: --{
3437: IF l_debug_on THEN
3438: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');
3439: END IF;
3440: WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery (
3441: p_delivery_id => crec.delivery_id,
3442: p_sc_batch_id => crec.pa_sc_batch_id,
3443: p_ship_confirm_rule_rec => l_ship_confirm_rule_rec,
3444: p_log_level => p_log_level,

Line 3452: WSH_BATCH_PROCESS.log_batch_messages (

3448: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3449: l_confirmed_results_success := l_confirmed_results_success + 1;
3450: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3451: l_confirmed_results_warning := l_confirmed_results_warning + 1;
3452: WSH_BATCH_PROCESS.log_batch_messages (
3453: crec.PA_SC_BATCH_ID,
3454: crec.delivery_id,
3455: NULL,
3456: crec.PICKUP_LOCATION_ID,

Line 3460: WSH_BATCH_PROCESS.log_batch_messages (

3456: crec.PICKUP_LOCATION_ID,
3457: 'W' );
3458: ELSE
3459: l_confirmed_results_failure := l_confirmed_results_failure + 1;
3460: WSH_BATCH_PROCESS.log_batch_messages (
3461: crec.PA_SC_BATCH_ID,
3462: crec.delivery_id,
3463: NULL,
3464: crec.PICKUP_LOCATION_ID,

Line 6114: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Close_A_Stop');

6110: END IF;
6111: FOR i in 1..l_stops_to_close.count LOOP
6112: --{
6113: IF l_debug_on THEN
6114: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Close_A_Stop');
6115: END IF;
6116: WSH_BATCH_PROCESS.Close_A_Stop (
6117: p_stop_id => l_stops_to_close(i),
6118: p_actual_date => NVL(WSH_PR_CRITERIA.g_actual_departure_date, SYSDATE),

Line 6116: WSH_BATCH_PROCESS.Close_A_Stop (

6112: --{
6113: IF l_debug_on THEN
6114: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Close_A_Stop');
6115: END IF;
6116: WSH_BATCH_PROCESS.Close_A_Stop (
6117: p_stop_id => l_stops_to_close(i),
6118: p_actual_date => NVL(WSH_PR_CRITERIA.g_actual_departure_date, SYSDATE),
6119: p_defer_interface_flag => 'Y',
6120: x_return_status => l_return_status );

Line 6132: WSH_BATCH_PROCESS.log_batch_messages(l_stops_sc_ids(i), NULL , l_stops_to_close(i) ,

6128: IF l_debug_on THEN
6129: WSH_DEBUG_SV.log(l_module_name,'Trip stop ', l_stops_to_close(i) ||' is closed with warnings');
6130: END IF;
6131: l_closing_stop_warning := l_closing_stop_warning + 1;
6132: WSH_BATCH_PROCESS.log_batch_messages(l_stops_sc_ids(i), NULL , l_stops_to_close(i) ,
6133: l_stop_location_ids(i), NULL);
6134: ELSE
6135: IF l_debug_on THEN
6136: WSH_DEBUG_SV.log(l_module_name,'Failed to close stop ', l_stops_to_close(i));

Line 6139: WSH_BATCH_PROCESS.log_batch_messages(l_stops_sc_ids(i), NULL , l_stops_to_close(i) ,

6135: IF l_debug_on THEN
6136: WSH_DEBUG_SV.log(l_module_name,'Failed to close stop ', l_stops_to_close(i));
6137: END IF;
6138: l_closing_stop_failure := l_closing_stop_failure + 1;
6139: WSH_BATCH_PROCESS.log_batch_messages(l_stops_sc_ids(i), NULL , l_stops_to_close(i) ,
6140: l_stop_location_ids(i), NULL);
6141: END IF;
6142: IF l_debug_on THEN
6143: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');