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 2352: l_ship_confirm_rule_rec WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%ROWTYPE;

2348: FROM wsh_picking_batches
2349: WHERE batch_id = c_batch_id;
2350:
2351: --
2352: l_ship_confirm_rule_rec WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%ROWTYPE;
2353: l_ship_confirm_rule_id NUMBER;
2354: l_batch_creation_date DATE;
2355: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
2356: l_curr_count NUMBER;

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

3289: --{
3290: IF crec.ap_level > 0 THEN
3291: --{
3292: IF l_debug_on THEN
3293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BATCH_PROCESS.Auto_Pack_A_Delivery'
3294: ,WSH_DEBUG_SV.C_PROC_LEVEL);
3295: END IF;
3296: l_del_pack_count := l_del_pack_count + 1;
3297: WSH_BATCH_PROCESS.Auto_Pack_A_Delivery (

Line 3297: WSH_BATCH_PROCESS.Auto_Pack_A_Delivery (

3293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BATCH_PROCESS.Auto_Pack_A_Delivery'
3294: ,WSH_DEBUG_SV.C_PROC_LEVEL);
3295: END IF;
3296: l_del_pack_count := l_del_pack_count + 1;
3297: WSH_BATCH_PROCESS.Auto_Pack_A_Delivery (
3298: p_delivery_id => crec.delivery_id,
3299: p_ap_batch_id => crec.PA_SC_BATCH_ID,
3300: p_auto_pack_level => crec.ap_level,
3301: p_log_level => p_log_level,

Line 3308: WSH_BATCH_PROCESS.log_batch_messages (

3304: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3305: l_packed_results_success := l_packed_results_success + 1;
3306: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3307: l_packed_results_warning := l_packed_results_warning + 1;
3308: WSH_BATCH_PROCESS.log_batch_messages (
3309: crec.PA_SC_BATCH_ID,
3310: crec.delivery_id,
3311: NULL,
3312: crec.PICKUP_LOCATION_ID,

Line 3316: WSH_BATCH_PROCESS.log_batch_messages (

3312: crec.PICKUP_LOCATION_ID,
3313: 'W' );
3314: ELSE
3315: l_packed_results_failure := l_packed_results_failure + 1;
3316: WSH_BATCH_PROCESS.log_batch_messages (
3317: crec.PA_SC_BATCH_ID,
3318: crec.delivery_id,
3319: NULL,
3320: crec.PICKUP_LOCATION_ID,

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

3335: BEGIN
3336: l_del_sc_count := l_del_sc_count + 1;
3337: IF crec.sc_rule_id <> nvl(l_prev_sc_rule_id,-99) THEN
3338: --{
3339: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3340: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3341: INTO l_ship_confirm_rule_rec;
3342: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3343: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

Line 3340: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE

3336: l_del_sc_count := l_del_sc_count + 1;
3337: IF crec.sc_rule_id <> nvl(l_prev_sc_rule_id,-99) THEN
3338: --{
3339: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3340: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3341: INTO l_ship_confirm_rule_rec;
3342: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3343: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3344: RAISE WSH_MISSING_SC_RULE;

Line 3342: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN

3338: --{
3339: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3340: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3341: INTO l_ship_confirm_rule_rec;
3342: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3343: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3344: RAISE WSH_MISSING_SC_RULE;
3345: ELSE
3346: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

Line 3343: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

3339: OPEN WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE(crec.sc_rule_id);
3340: FETCH WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE
3341: INTO l_ship_confirm_rule_rec;
3342: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3343: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3344: RAISE WSH_MISSING_SC_RULE;
3345: ELSE
3346: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3347: END IF;

Line 3346: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;

3342: IF WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE%NOTFOUND THEN
3343: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3344: RAISE WSH_MISSING_SC_RULE;
3345: ELSE
3346: CLOSE WSH_BATCH_PROCESS.G_GET_SHIP_CONFIRM_RULE;
3347: END IF;
3348: l_prev_sc_rule_id := crec.sc_rule_id;
3349: --}
3350: END IF;

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

3350: END IF;
3351:
3352: --{
3353: IF l_debug_on THEN
3354: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');
3355: END IF;
3356: WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery (
3357: p_delivery_id => crec.delivery_id,
3358: p_sc_batch_id => crec.pa_sc_batch_id,

Line 3356: WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery (

3352: --{
3353: IF l_debug_on THEN
3354: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery');
3355: END IF;
3356: WSH_BATCH_PROCESS.Ship_Confirm_A_Delivery (
3357: p_delivery_id => crec.delivery_id,
3358: p_sc_batch_id => crec.pa_sc_batch_id,
3359: p_ship_confirm_rule_rec => l_ship_confirm_rule_rec,
3360: p_log_level => p_log_level,

Line 3368: WSH_BATCH_PROCESS.log_batch_messages (

3364: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3365: l_confirmed_results_success := l_confirmed_results_success + 1;
3366: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3367: l_confirmed_results_warning := l_confirmed_results_warning + 1;
3368: WSH_BATCH_PROCESS.log_batch_messages (
3369: crec.PA_SC_BATCH_ID,
3370: crec.delivery_id,
3371: NULL,
3372: crec.PICKUP_LOCATION_ID,

Line 3376: WSH_BATCH_PROCESS.log_batch_messages (

3372: crec.PICKUP_LOCATION_ID,
3373: 'W' );
3374: ELSE
3375: l_confirmed_results_failure := l_confirmed_results_failure + 1;
3376: WSH_BATCH_PROCESS.log_batch_messages (
3377: crec.PA_SC_BATCH_ID,
3378: crec.delivery_id,
3379: NULL,
3380: crec.PICKUP_LOCATION_ID,

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

5975: END IF;
5976: FOR i in 1..l_stops_to_close.count LOOP
5977: --{
5978: IF l_debug_on THEN
5979: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Close_A_Stop');
5980: END IF;
5981: WSH_BATCH_PROCESS.Close_A_Stop (
5982: p_stop_id => l_stops_to_close(i),
5983: p_actual_date => NVL(WSH_PR_CRITERIA.g_actual_departure_date, SYSDATE),

Line 5981: WSH_BATCH_PROCESS.Close_A_Stop (

5977: --{
5978: IF l_debug_on THEN
5979: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_BATCH_PROCESS.Close_A_Stop');
5980: END IF;
5981: WSH_BATCH_PROCESS.Close_A_Stop (
5982: p_stop_id => l_stops_to_close(i),
5983: p_actual_date => NVL(WSH_PR_CRITERIA.g_actual_departure_date, SYSDATE),
5984: p_defer_interface_flag => 'Y',
5985: x_return_status => l_return_status );

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

5993: IF l_debug_on THEN
5994: WSH_DEBUG_SV.log(l_module_name,'Trip stop ', l_stops_to_close(i) ||' is closed with warnings');
5995: END IF;
5996: l_closing_stop_warning := l_closing_stop_warning + 1;
5997: WSH_BATCH_PROCESS.log_batch_messages(l_stops_sc_ids(i), NULL , l_stops_to_close(i) ,
5998: l_stop_location_ids(i), NULL);
5999: ELSE
6000: IF l_debug_on THEN
6001: WSH_DEBUG_SV.log(l_module_name,'Failed to close stop ', l_stops_to_close(i));

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

6000: IF l_debug_on THEN
6001: WSH_DEBUG_SV.log(l_module_name,'Failed to close stop ', l_stops_to_close(i));
6002: END IF;
6003: l_closing_stop_failure := l_closing_stop_failure + 1;
6004: WSH_BATCH_PROCESS.log_batch_messages(l_stops_sc_ids(i), NULL , l_stops_to_close(i) ,
6005: l_stop_location_ids(i), NULL);
6006: END IF;
6007: IF l_debug_on THEN
6008: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');