DBA Data[Home] [Help]

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 165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag

161: --OTM R12
162: --selecting deliveries that has 'AR' status on a trip
163: CURSOR c_get_delivery_id(p_trip_id IN NUMBER) IS
164: SELECT wdl.delivery_id,
165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
166: FROM wsh_delivery_legs wdl,
167: wsh_trip_stops wts,
168: wsh_new_deliveries wnd,
169: wsh_trips wt

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

171: AND wts.trip_id = wt.trip_id
172: AND wt.status_code = 'OP'
173: AND wdl.pick_up_stop_id = wts.stop_id
174: AND wnd.delivery_id = wdl.delivery_id
175: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;
176: --END OTM R12
177: --
178: -- LSP PROJECT :
179: CURSOR c_get_client(p_delivery_id NUMBER) IS

Line 214: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

210: l_valid_index_tab wsh_util_core.id_tab_type;
211: l_error_ids wsh_util_core.id_tab_type;
212: l_org_id_tab wsh_util_core.id_tab_type;
213: l_Client_id_tab wsh_util_core.id_tab_type; -- Modified R12.1.1 LSP PROJECT
214: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
215: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.ship_method_type;
216: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;
217: l_dummy_id_tab wsh_util_core.id_tab_type;
218: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;

Line 232: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

228: b_cc_linefailed boolean;
229: b_cc_groupidexists boolean;
230: l_delivery_id_tab_temp wsh_util_core.id_tab_type;
231: l_delivery_id_tab_t wsh_util_core.id_tab_type;
232: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
233: l_cc_count_success NUMBER;
234: l_cc_count_group_ids NUMBER;
235: l_cc_count_rec NUMBER;
236: l_cc_group_ids wsh_util_core.id_tab_type;

Line 250: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

246: l_cc_count_grouping_rows NUMBER;
247: l_cc_trip_id wsh_util_core.id_tab_type;
248: l_cc_trip_id_tab wsh_util_core.id_tab_type;
249: --dummy tables for calling validate_constraint_mainper
250: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
251: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
252: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
253: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
254: l_cc_in_ids wsh_util_core.id_tab_type;

Line 566: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(

562: --
563: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
564: AND p_action_prms.action_code = 'DELETE'
565: ) THEN --BUG 4354579
566: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(
567: p_rec_attr_tab => p_rec_attr_tab,
568: p_caller => p_action_prms.caller,
569: p_valid_index_tab => l_valid_index_tab,
570: x_valid_ids_tab => l_valid_ids_tab,

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

1912:
1913: IF (l_new_delivery_id_tab.COUNT > 0) THEN
1914:
1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1917: END IF;
1918:
1919: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1920: p_delivery_id_tab => l_new_delivery_id_tab,

Line 1919: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1917: END IF;
1918:
1919: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1920: p_delivery_id_tab => l_new_delivery_id_tab,
1921: p_tms_interface_flag_tab => l_new_interface_flag_tab,
1922: x_return_status => l_return_status);
1923:

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

2361:
2362: WHILE i IS NOT NULL LOOP
2363:
2364: --allow delete for all 'NS' deliveries
2365: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2366: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2367: --generate allowed list of deliveries to be deleted
2368: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2369: l_counter := l_counter + 1;

Line 2366: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

2362: WHILE i IS NOT NULL LOOP
2363:
2364: --allow delete for all 'NS' deliveries
2365: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2366: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2367: --generate allowed list of deliveries to be deleted
2368: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2369: l_counter := l_counter + 1;
2370: ELSE

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

2375: wsh_debug_sv.logmsg(l_module_name,'ERROR: delivery ' || l_delivery_id_tab(i) || ' cannot be deleted when it is not NS status');
2376: END IF;
2377:
2378: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DEL_DELETE_ERROR');
2379: FND_MESSAGE.SET_TOKEN('DEL_NAME',WSH_NEW_DELIVERIES_PVT.get_name(l_delivery_id_tab(i)));
2380:
2381: --we do not want the prefix error or warning for the message, so adding it with success
2382: --status will leave out the prefix. Reason being this is an error message but could be
2383: --displayed as a warning if not all deliveries fail.

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

2970: -- If no leg exist for this Delivery,there should be a ERROR/WARNING message here
2971: -- Indicates there is no associated trip for the delivery
2972: IF l_dleg_found = 'N' THEN
2973: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NO_TRIP_FOR_DLVY');
2974: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(i).delivery_id));
2975: l_num_errors := l_num_errors + 1;
2976: l_return_status := wsh_util_core.g_ret_sts_error;
2977: wsh_util_core.add_message(l_return_status,l_module_name);
2978: IF l_debug_on THEN

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

3563: -- I Harmonization: rvishnuv ******* Create/Update ******
3564: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3565: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3566: PROCEDURE Validate_Delivery
3567: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3568: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3569: p_action_code IN VARCHAR2,
3570: p_caller IN VARCHAR2,
3571: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,

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

3564: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3565: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3566: PROCEDURE Validate_Delivery
3567: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3568: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3569: p_action_code IN VARCHAR2,
3570: p_caller IN VARCHAR2,
3571: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
3572: x_return_status OUT NOCOPY VARCHAR2)

Line 4566: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4562: ( p_api_version_number IN NUMBER,
4563: p_init_msg_list IN VARCHAR2,
4564: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4565: p_in_rec IN del_In_Rec_Type,
4566: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4567: x_del_out_rec_tab OUT NOCOPY Del_Out_Tbl_Type,
4568: x_return_status OUT NOCOPY VARCHAR2,
4569: x_msg_count OUT NOCOPY NUMBER,
4570: x_msg_data OUT NOCOPY VARCHAR2)

Line 4587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4583: l_msg_count NUMBER;
4584: l_msg_data VARCHAR2(32767);
4585:
4586: --
4587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4588: l_index_tab wsh_util_core.id_tab_type;
4589: --
4590: l_input_param_flag BOOLEAN := TRUE;
4591: --

Line 4613: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4609: l_cc_count_grouping_rows NUMBER;
4610: l_cc_trip_id wsh_util_core.id_tab_type;
4611: l_cc_trip_id_tab wsh_util_core.id_tab_type;
4612: b_cc_linefailed boolean;
4613: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4614: l_cc_count_success NUMBER;
4615:
4616: --dummy tables for calling validate_constraint_mainper
4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

Line 4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4613: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4614: l_cc_count_success NUMBER;
4615:
4616: --dummy tables for calling validate_constraint_mainper
4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4618: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4619: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4620: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4621: l_cc_in_ids wsh_util_core.id_tab_type;

Line 5022: WSH_NEW_DELIVERIES_PVT.Create_Delivery(

5018:
5019:
5020:
5021: --
5022: WSH_NEW_DELIVERIES_PVT.Create_Delivery(
5023: p_delivery_info => l_rec_attr_tab(l_index),
5024: x_rowid => x_del_out_rec_tab(l_index).rowid,
5025: x_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
5026: x_name => x_del_out_rec_tab(l_index).name,

Line 5176: WSH_NEW_DELIVERIES_PVT.Update_Delivery(

5172: x_num_errors => l_num_errors);
5173:
5174:
5175:
5176: WSH_NEW_DELIVERIES_PVT.Update_Delivery(
5177: p_rowid => l_rec_attr_tab(l_index).rowid,
5178: p_delivery_info => l_rec_attr_tab(l_index),
5179: x_return_status => l_return_status);
5180: --

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

6041: IF l_debug_on THEN
6042: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_ASSIGNED_ERROR');
6043: END IF;
6044: --
6045: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6047: wsh_util_core.add_message(x_return_status,l_module_name);
6048: IF l_debug_on THEN
6049: WSH_DEBUG_SV.log(l_module_name,'x_return_status',

Line 6079: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,

6075: -- The below procedue will be obsoleted after patchset I.
6076:
6077: PROCEDURE map_grp_to_pvt(
6078: p_pub_rec IN delivery_pub_rec_type,
6079: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
6080: x_return_status OUT NOCOPY VARCHAR2)
6081: IS
6082: --
6083: l_debug_on BOOLEAN;

Line 6290: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;

6286: --
6287: l_message VARCHAR2(50);
6288: l_num_errors NUMBER;
6289: l_num_warnings NUMBER;
6290: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
6291: l_delivery_in_rec Del_In_Rec_Type;
6292: l_del_out_rec_tab Del_Out_Tbl_Type;
6293: l_return_status VARCHAR2(1);
6294: l_commit VARCHAR2(100) := FND_API.G_FALSE;

Line 6745: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

6741: Created : Patchset I
6742: ----------------------------------------------------------------------- */
6743:
6744: PROCEDURE Lock_Related_Entities(
6745: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
6746: p_action_prms IN action_parameters_rectype,
6747: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
6748: x_return_status OUT NOCOPY VARCHAR2
6749: ) IS

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

6813: l_stop_rows.delete;
6814:
6815: IF p_rec_attr_tab(l_index).name is null
6816: THEN
6817: l_dlvy_name := wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(l_index).delivery_id);
6818: ELSE
6819: l_dlvy_name := p_rec_attr_tab(l_index).name;
6820: END IF;
6821: