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_TP_RELEASE_INT dependencies on WSH_NEW_DELIVERIES_PVT

Line 280: x_delivery_attrs_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,

276:
277:
278: PROCEDURE copy_delivery_record(
279: p_plan_delivery_rec IN plan_delivery_rec_type,
280: x_delivery_attrs_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
281: x_return_status OUT NOCOPY VARCHAR2
282: );
283:
284: PROCEDURE copy_trip_record(

Line 2135: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

2131: RETURN;
2132: END IF;
2133:
2134: BEGIN
2135: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
2136: p_delivery_id => idel.delivery_id);
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: stamp_interface_error(

Line 2483: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

2479: -- Lock its delivery if it will be unassigned
2480: IF candidate.delivery_id IS NOT NULL
2481: AND candidate.delivery_id <> NVL(x_plan_deliveries(l_target_delivery_index).delivery_id,0) THEN
2482: BEGIN
2483: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
2484: p_delivery_id => candidate.delivery_id);
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: stamp_interface_error(

Line 2493: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(candidate.delivery_id),

2489: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
2490: p_entity_interface_id => iline.dd_interface_id,
2491: p_message_name => 'WSH_TP_I_NO_LOCK_DEL',
2492: p_token_1_name => 'DELIVERY_NAME',
2493: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(candidate.delivery_id),
2494: x_errors_tab => x_errors_tab,
2495: x_return_status => l_return_status);
2496: GOTO next_candidate;
2497: END;

Line 3365: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(

3361: p_entity_table_name => 'WSH_DEL_DETAILS_INTERFACE',
3362: p_entity_interface_id => x_used_details(l_new_index).dd_interface_id,
3363: p_message_name => 'WSH_TP_F_FIRM_DEL_UNUSED',
3364: p_token_1_name => 'DELIVERY_NAME',
3365: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(
3366: x_plan_deliveries(l_target_delivery_index).delivery_id),
3367: p_token_2_name => 'PLAN_TRIP_NUM',
3368: p_token_2_value => get_plan_trip_num(x_context),
3369: p_token_3_name => 'PLAN_DEL_NUM',

Line 3782: WSH_NEW_DELIVERIES_PVT.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),

3778: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
3779: p_message_name => 'WSH_TP_F_NO_LOCK_LEGS',
3780: p_token_1_name => 'DELIVERY_NAME',
3781: p_token_1_value =>
3782: WSH_NEW_DELIVERIES_PVT.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),
3783: x_errors_tab => x_errors_tab,
3784: x_return_status => l_return_status);
3785: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3786: IF l_debug_on THEN

Line 4272: p_token_1_value => wsh_new_deliveries_pvt.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),

4268: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
4269: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
4270: p_message_name => 'WSH_TP_F_DEL_FIRM_LEG_DIFF',
4271: p_token_1_name => 'DELIVERY_NAME',
4272: p_token_1_value => wsh_new_deliveries_pvt.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),
4273: p_token_2_name => 'PLAN_TRIP_NUM',
4274: p_token_2_value => x_plan_trips(1).tp_trip_number,
4275: x_errors_tab => x_errors_tab,
4276: x_return_status => l_return_status);

Line 4303: p_token_1_value => wsh_new_deliveries_pvt.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),

4299: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
4300: p_entity_interface_id => x_plan_deliveries(l_plan_del_index).del_interface_id,
4301: p_message_name => 'WSH_TP_F_TRIP_FIRM_NO_UNASSIGN',
4302: p_token_1_name => 'DELIVERY_NAME',
4303: p_token_1_value => wsh_new_deliveries_pvt.get_name(x_plan_deliveries(l_plan_del_index).delivery_id),
4304: p_token_2_name => 'PLAN_TRIP_NUM',
4305: p_token_2_value => x_plan_trips(1).tp_trip_number,
4306: x_errors_tab => x_errors_tab,
4307: x_return_status => l_return_status);

Line 4706: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

4702: l_sd_dd_count NUMBER := 0;
4703: l_skip_step BOOLEAN;
4704: l_is_inbound BOOLEAN;
4705:
4706: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
4707: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4708: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
4709: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4710: l_del_in_rec WSH_DELIVERIES_GRP.DEL_IN_REC_TYPE;

Line 5961: l_cf_dels WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

5957: END IF;
5958:
5959: DECLARE
5960: -- list of deliveries to become contents firmed.
5961: l_cf_dels WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
5962: -- list of deliveries to become routing and contents firmed.
5963: l_rcf_dels WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
5964: l_discard_return_status VARCHAR2(1);
5965: BEGIN --{

Line 5963: l_rcf_dels WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

5959: DECLARE
5960: -- list of deliveries to become contents firmed.
5961: l_cf_dels WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
5962: -- list of deliveries to become routing and contents firmed.
5963: l_rcf_dels WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
5964: l_discard_return_status VARCHAR2(1);
5965: BEGIN --{
5966:
5967: l_index := x_plan_deliveries.FIRST;

Line 6726: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

6722: l_message_name VARCHAR2(30);
6723: l_msg_data VARCHAR2(32767);
6724: l_msg_count NUMBER;
6725:
6726: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
6727: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
6728: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
6729: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
6730:

Line 7060: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);

7056:
7057: IF dd.earliest_pickup_date > l_initial_pu_date THEN
7058: -- Log exception.
7059: IF l_delivery_name is null THEN
7060: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);
7061: END IF;
7062: FND_MESSAGE.SET_NAME('WSH', 'WSH_TP_EARLY_PICKUP');
7063: FND_MESSAGE.SET_TOKEN('SHIP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_initial_pu_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7064: FND_MESSAGE.SET_TOKEN('PICK_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.earliest_pickup_date,calendar_aware=>FND_DATE.calendar_aware_alt));

Line 7090: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);

7086:
7087: IF dd.latest_dropoff_date < l_final_do_date THEN
7088: -- Log exception.
7089: IF l_delivery_name is null THEN
7090: l_delivery_name := wsh_new_deliveries_pvt.get_name(x_plan_deliveries(i).delivery_id);
7091: END IF;
7092: FND_MESSAGE.SET_NAME('WSH', 'WSH_TP_LATE_DROPOFF');
7093: FND_MESSAGE.SET_TOKEN('DROP_DATE',FND_DATE.DATE_TO_DISPLAYDT(l_final_do_date,calendar_aware=>FND_DATE.calendar_aware_alt));
7094: FND_MESSAGE.SET_TOKEN('DELIVER_DATE',FND_DATE.DATE_TO_DISPLAYDT(dd.latest_dropoff_date,calendar_aware=>FND_DATE.calendar_aware_alt));

Line 8315: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(

8311: p_entity_table_name => 'WSH_NEW_DEL_INTERFACE',
8312: p_entity_interface_id => x_plan_deliveries(i).del_interface_id,
8313: p_message_name => 'WSH_TP_F_PLAN_DEL_NOT_MATCH',
8314: p_token_1_name => 'DELIVERY_NAME',
8315: p_token_1_value => WSH_NEW_DELIVERIES_PVT.get_name(
8316: x_plan_deliveries(i).delivery_id),
8317: p_token_2_name => 'PLAN_TRIP_NUM',
8318: p_token_2_value => get_plan_trip_num(x_context),
8319: p_token_3_name => 'PLAN_DEL_NUM',

Line 9185: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

9181:
9182: IF l_delivery_matches = 'N' THEN
9183: -- Lock the delivery.
9184: BEGIN
9185: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
9186: p_delivery_id => leg.delivery_id);
9187: EXCEPTION
9188: WHEN OTHERS THEN
9189: l_tmp_entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(leg.delivery_id);

Line 9189: l_tmp_entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(leg.delivery_id);

9185: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
9186: p_delivery_id => leg.delivery_id);
9187: EXCEPTION
9188: WHEN OTHERS THEN
9189: l_tmp_entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(leg.delivery_id);
9190: stamp_interface_error(
9191: p_group_id => x_context.group_id,
9192: p_entity_table_name => 'WSH_TRIP_INTERFACE',
9193: p_entity_interface_id => x_plan_trips(i).trip_interface_id,

Line 9635: x_delivery_attrs_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,

9631: -- transforms plan data structure into group api data structure for delivery.
9632: --
9633: PROCEDURE copy_delivery_record(
9634: p_plan_delivery_rec IN plan_delivery_rec_type,
9635: x_delivery_attrs_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
9636: x_return_status OUT NOCOPY VARCHAR2
9637: ) IS
9638: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'COPY_DELIVERY_RECORD';
9639: --