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

Line 12: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

8: -- add your constants here if any
9:
10: -- Forward declaration
11: PROCEDURE Lock_Related_Entities(
12: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
13: p_action_prms IN action_parameters_rectype,
14: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
15: x_return_status OUT NOCOPY VARCHAR2
16: );

Line 56: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,

52: ( p_api_version_number IN NUMBER,
53: p_init_msg_list IN VARCHAR2,
54: p_commit IN VARCHAR2,
55: p_action_prms IN action_parameters_rectype,
56: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
57: x_delivery_out_rec OUT NOCOPY Delivery_Action_Out_Rec_Type,
58: x_defaults_rec OUT NOCOPY default_parameters_rectype,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

Line 145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag

141: --OTM R12
142: --selecting deliveries that has 'AR' status on a trip
143: CURSOR c_get_delivery_id(p_trip_id IN NUMBER) IS
144: SELECT wdl.delivery_id,
145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
146: FROM wsh_delivery_legs wdl,
147: wsh_trip_stops wts,
148: wsh_new_deliveries wnd,
149: wsh_trips wt

Line 155: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;

151: AND wts.trip_id = wt.trip_id
152: AND wt.status_code = 'OP'
153: AND wdl.pick_up_stop_id = wts.stop_id
154: AND wnd.delivery_id = wdl.delivery_id
155: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;
156: --END OTM R12
157:
158: l_first NUMBER;
159: l_last NUMBER;

Line 184: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

180: l_valid_ids_tab wsh_util_core.id_tab_type;
181: l_valid_index_tab wsh_util_core.id_tab_type;
182: l_error_ids wsh_util_core.id_tab_type;
183: l_org_id_tab wsh_util_core.id_tab_type;
184: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
185: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.ship_method_type;
186: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;
187: l_dummy_id_tab wsh_util_core.id_tab_type;
188: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;

Line 202: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

198: b_cc_linefailed boolean;
199: b_cc_groupidexists boolean;
200: l_delivery_id_tab_temp wsh_util_core.id_tab_type;
201: l_delivery_id_tab_t wsh_util_core.id_tab_type;
202: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
203: l_cc_count_success NUMBER;
204: l_cc_count_group_ids NUMBER;
205: l_cc_count_rec NUMBER;
206: l_cc_group_ids wsh_util_core.id_tab_type;

Line 220: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

216: l_cc_count_grouping_rows NUMBER;
217: l_cc_trip_id wsh_util_core.id_tab_type;
218: l_cc_trip_id_tab wsh_util_core.id_tab_type;
219: --dummy tables for calling validate_constraint_mainper
220: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
221: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
222: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
223: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
224: l_cc_in_ids wsh_util_core.id_tab_type;

Line 530: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(

526: --
527: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
528: AND p_action_prms.action_code = 'DELETE'
529: ) THEN --BUG 4354579
530: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(
531: p_rec_attr_tab => p_rec_attr_tab,
532: p_caller => p_action_prms.caller,
533: p_valid_index_tab => l_valid_index_tab,
534: x_valid_ids_tab => l_valid_ids_tab,

Line 1861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

1857:
1858: IF (l_new_delivery_id_tab.COUNT > 0) THEN
1859:
1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1862: END IF;
1863:
1864: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1865: p_delivery_id_tab => l_new_delivery_id_tab,

Line 1864: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1862: END IF;
1863:
1864: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1865: p_delivery_id_tab => l_new_delivery_id_tab,
1866: p_tms_interface_flag_tab => l_new_interface_flag_tab,
1867: x_return_status => l_return_status);
1868:

Line 2277: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

2273:
2274: WHILE i IS NOT NULL LOOP
2275:
2276: --allow delete for all 'NS' deliveries
2277: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2278: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2279: --generate allowed list of deliveries to be deleted
2280: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2281: l_counter := l_counter + 1;

Line 2278: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

2274: WHILE i IS NOT NULL LOOP
2275:
2276: --allow delete for all 'NS' deliveries
2277: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2278: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2279: --generate allowed list of deliveries to be deleted
2280: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2281: l_counter := l_counter + 1;
2282: ELSE

Line 2291: FND_MESSAGE.SET_TOKEN('DEL_NAME',WSH_NEW_DELIVERIES_PVT.get_name(l_delivery_id_tab(i)));

2287: wsh_debug_sv.logmsg(l_module_name,'ERROR: delivery ' || l_delivery_id_tab(i) || ' cannot be deleted when it is not NS status');
2288: END IF;
2289:
2290: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DEL_DELETE_ERROR');
2291: FND_MESSAGE.SET_TOKEN('DEL_NAME',WSH_NEW_DELIVERIES_PVT.get_name(l_delivery_id_tab(i)));
2292:
2293: --we do not want the prefix error or warning for the message, so adding it with success
2294: --status will leave out the prefix. Reason being this is an error message but could be
2295: --displayed as a warning if not all deliveries fail.

Line 2886: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(i).delivery_id));

2882: -- If no leg exist for this Delivery,there should be a ERROR/WARNING message here
2883: -- Indicates there is no associated trip for the delivery
2884: IF l_dleg_found = 'N' THEN
2885: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NO_TRIP_FOR_DLVY');
2886: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(i).delivery_id));
2887: l_num_errors := l_num_errors + 1;
2888: l_return_status := wsh_util_core.g_ret_sts_error;
2889: wsh_util_core.add_message(l_return_status,l_module_name);
2890: IF l_debug_on THEN

Line 3479: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

3475: -- I Harmonization: rvishnuv ******* Create/Update ******
3476: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3477: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3478: PROCEDURE Validate_Delivery
3479: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3480: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3481: p_action_code IN VARCHAR2,
3482: p_caller IN VARCHAR2,
3483: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,

Line 3480: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354

3476: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3477: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3478: PROCEDURE Validate_Delivery
3479: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3480: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3481: p_action_code IN VARCHAR2,
3482: p_caller IN VARCHAR2,
3483: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
3484: x_return_status OUT NOCOPY VARCHAR2)

Line 4393: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4389: ( p_api_version_number IN NUMBER,
4390: p_init_msg_list IN VARCHAR2,
4391: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4392: p_in_rec IN del_In_Rec_Type,
4393: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4394: x_del_out_rec_tab OUT NOCOPY Del_Out_Tbl_Type,
4395: x_return_status OUT NOCOPY VARCHAR2,
4396: x_msg_count OUT NOCOPY NUMBER,
4397: x_msg_data OUT NOCOPY VARCHAR2)

Line 4414: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4410: l_msg_count NUMBER;
4411: l_msg_data VARCHAR2(32767);
4412:
4413: --
4414: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4415: l_index_tab wsh_util_core.id_tab_type;
4416: --
4417: l_input_param_flag BOOLEAN := TRUE;
4418: --

Line 4440: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4436: l_cc_count_grouping_rows NUMBER;
4437: l_cc_trip_id wsh_util_core.id_tab_type;
4438: l_cc_trip_id_tab wsh_util_core.id_tab_type;
4439: b_cc_linefailed boolean;
4440: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4441: l_cc_count_success NUMBER;
4442:
4443: --dummy tables for calling validate_constraint_mainper
4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

Line 4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4440: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4441: l_cc_count_success NUMBER;
4442:
4443: --dummy tables for calling validate_constraint_mainper
4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4445: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4446: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4447: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4448: l_cc_in_ids wsh_util_core.id_tab_type;

Line 4847: WSH_NEW_DELIVERIES_PVT.Create_Delivery(

4843:
4844:
4845:
4846: --
4847: WSH_NEW_DELIVERIES_PVT.Create_Delivery(
4848: p_delivery_info => l_rec_attr_tab(l_index),
4849: x_rowid => x_del_out_rec_tab(l_index).rowid,
4850: x_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
4851: x_name => x_del_out_rec_tab(l_index).name,

Line 5001: WSH_NEW_DELIVERIES_PVT.Update_Delivery(

4997: x_num_errors => l_num_errors);
4998:
4999:
5000:
5001: WSH_NEW_DELIVERIES_PVT.Update_Delivery(
5002: p_rowid => l_rec_attr_tab(l_index).rowid,
5003: p_delivery_info => l_rec_attr_tab(l_index),
5004: x_return_status => l_return_status);
5005: --

Line 5865: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));

5861: IF l_debug_on THEN
5862: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_ASSIGNED_ERROR');
5863: END IF;
5864: --
5865: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
5866: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5867: wsh_util_core.add_message(x_return_status,l_module_name);
5868: IF l_debug_on THEN
5869: WSH_DEBUG_SV.log(l_module_name,'x_return_status',

Line 5899: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,

5895: -- The below procedue will be obsoleted after patchset I.
5896:
5897: PROCEDURE map_grp_to_pvt(
5898: p_pub_rec IN delivery_pub_rec_type,
5899: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
5900: x_return_status OUT NOCOPY VARCHAR2)
5901: IS
5902: --
5903: l_debug_on BOOLEAN;

Line 6110: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;

6106: --
6107: l_message VARCHAR2(50);
6108: l_num_errors NUMBER;
6109: l_num_warnings NUMBER;
6110: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
6111: l_delivery_in_rec Del_In_Rec_Type;
6112: l_del_out_rec_tab Del_Out_Tbl_Type;
6113: l_return_status VARCHAR2(1);
6114: l_commit VARCHAR2(100) := FND_API.G_FALSE;

Line 6565: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

6561: Created : Patchset I
6562: ----------------------------------------------------------------------- */
6563:
6564: PROCEDURE Lock_Related_Entities(
6565: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
6566: p_action_prms IN action_parameters_rectype,
6567: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
6568: x_return_status OUT NOCOPY VARCHAR2
6569: ) IS

Line 6637: l_dlvy_name := wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(l_index).delivery_id);

6633: l_stop_rows.delete;
6634:
6635: IF p_rec_attr_tab(l_index).name is null
6636: THEN
6637: l_dlvy_name := wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(l_index).delivery_id);
6638: ELSE
6639: l_dlvy_name := p_rec_attr_tab(l_index).name;
6640: END IF;
6641: