APPS.WSH_TP_RELEASE dependencies on WSH_UTIL_CORE

Line 42: p_in_ids IN wsh_util_core.id_tab_type, -- table of ids of above entity

38: -- END
39:
40: PROCEDURE change_ignoreplan_status
41: (p_entity IN VARCHAR2, --'DLVY', 'DLVB', 'TRIP' dep on place from which it is called
42: p_in_ids IN wsh_util_core.id_tab_type, -- table of ids of above entity
43: p_action_code IN VARCHAR2, -- either 'IGNORE_PLAN', 'INCLUDE_PLAN'
44: x_return_status OUT NOCOPY VARCHAR2) IS
45:
46: CURSOR c_get_deliveries (p_tripid NUMBER) IS

Line 142: l_tmp_trip_ids wsh_util_core.id_tab_type;

138:
139: l_del_cur c_get_deliveries%ROWTYPE;
140: --l_del_forlines_cur c_get_del_forlines%ROWTYPE;
141: l_lines_cur c_get_lines%ROWTYPE;
142: l_tmp_trip_ids wsh_util_core.id_tab_type;
143: l_tmp_del_ids wsh_util_core.id_tab_type;
144: l_tmp_det_ids wsh_util_core.id_tab_type;
145: l_tmp_detail_ids wsh_util_core.id_tab_type;
146: l_ignoreplan VARCHAR2(1);

Line 143: l_tmp_del_ids wsh_util_core.id_tab_type;

139: l_del_cur c_get_deliveries%ROWTYPE;
140: --l_del_forlines_cur c_get_del_forlines%ROWTYPE;
141: l_lines_cur c_get_lines%ROWTYPE;
142: l_tmp_trip_ids wsh_util_core.id_tab_type;
143: l_tmp_del_ids wsh_util_core.id_tab_type;
144: l_tmp_det_ids wsh_util_core.id_tab_type;
145: l_tmp_detail_ids wsh_util_core.id_tab_type;
146: l_ignoreplan VARCHAR2(1);
147: l_is_container VARCHAR2(1);

Line 144: l_tmp_det_ids wsh_util_core.id_tab_type;

140: --l_del_forlines_cur c_get_del_forlines%ROWTYPE;
141: l_lines_cur c_get_lines%ROWTYPE;
142: l_tmp_trip_ids wsh_util_core.id_tab_type;
143: l_tmp_del_ids wsh_util_core.id_tab_type;
144: l_tmp_det_ids wsh_util_core.id_tab_type;
145: l_tmp_detail_ids wsh_util_core.id_tab_type;
146: l_ignoreplan VARCHAR2(1);
147: l_is_container VARCHAR2(1);
148: l_container_name wsh_delivery_details.container_name%TYPE;

Line 145: l_tmp_detail_ids wsh_util_core.id_tab_type;

141: l_lines_cur c_get_lines%ROWTYPE;
142: l_tmp_trip_ids wsh_util_core.id_tab_type;
143: l_tmp_del_ids wsh_util_core.id_tab_type;
144: l_tmp_det_ids wsh_util_core.id_tab_type;
145: l_tmp_detail_ids wsh_util_core.id_tab_type;
146: l_ignoreplan VARCHAR2(1);
147: l_is_container VARCHAR2(1);
148: l_container_name wsh_delivery_details.container_name%TYPE;
149: l_num_error NUMBER :=0;

Line 161: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

157:
158: --OTM R12, glog proj
159: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.DELIVERY_ATTR_TBL_TYPE;
160: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;
161: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
162: l_new_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
163: l_temp NUMBER;
164: l_msg_count NUMBER;
165: l_msg_data VARCHAR2(2000);

Line 162: l_new_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;

158: --OTM R12, glog proj
159: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.DELIVERY_ATTR_TBL_TYPE;
160: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;
161: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
162: l_new_version_number_tab WSH_UTIL_CORE.ID_TAB_TYPE;
163: l_temp NUMBER;
164: l_msg_count NUMBER;
165: l_msg_data VARCHAR2(2000);
166: l_del_trip_tab WMS_SHIPPING_INTERFACE_GRP.G_DLVY_TRIP_TBL;

Line 180: l_cont_flag_tbl wsh_util_core.Column_Tab_Type;

176: l_sync_tmp_wms_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
177: l_sync_tmp_inv_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
178: TYPE T_V1 is TABLE OF VARCHAR2(01);
179:
180: l_cont_flag_tbl wsh_util_core.Column_Tab_Type;
181: l_line_dir_tbl wsh_util_core.Column_Tab_Type;
182: l_orgn_id_tbl wsh_util_core.id_Tab_Type;
183: --l_cont_flag_tbl T_V1 := T_V1();
184:

Line 181: l_line_dir_tbl wsh_util_core.Column_Tab_Type;

177: l_sync_tmp_inv_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
178: TYPE T_V1 is TABLE OF VARCHAR2(01);
179:
180: l_cont_flag_tbl wsh_util_core.Column_Tab_Type;
181: l_line_dir_tbl wsh_util_core.Column_Tab_Type;
182: l_orgn_id_tbl wsh_util_core.id_Tab_Type;
183: --l_cont_flag_tbl T_V1 := T_V1();
184:
185: l_child_cnt_counter NUMBER;

Line 182: l_orgn_id_tbl wsh_util_core.id_Tab_Type;

178: TYPE T_V1 is TABLE OF VARCHAR2(01);
179:
180: l_cont_flag_tbl wsh_util_core.Column_Tab_Type;
181: l_line_dir_tbl wsh_util_core.Column_Tab_Type;
182: l_orgn_id_tbl wsh_util_core.id_Tab_Type;
183: --l_cont_flag_tbl T_V1 := T_V1();
184:
185: l_child_cnt_counter NUMBER;
186: l_cnt_wms_counter NUMBER;

Line 211: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

207: IF l_debug_on THEN
208: WSH_DEBUG_SV.push(l_module_name);
209: END IF;
210:
211: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
212:
213: --OTM R12, glog proj, use Global Variable
214: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
215:

Line 214: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

210:
211: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
212:
213: --OTM R12, glog proj, use Global Variable
214: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
215:
216: -- If null, call the function
217: IF l_gc3_is_installed IS NULL THEN
218: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 218: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

214: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
215:
216: -- If null, call the function
217: IF l_gc3_is_installed IS NULL THEN
218: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
219: END IF;
220: -- Initialize these as they are used in UPDATE statement and in cases where
221: -- these are not actually populated
222: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

Line 226: IF ((WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' OR

222: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
223: l_new_version_number_tab(1) := 1;
224: -- end of OTM R12, glog proj
225:
226: IF ((WSH_UTIL_CORE.TP_IS_INSTALLED = 'Y' OR
227: l_gc3_is_installed = 'Y') -- OTM R12, glog proj
228: AND p_entity IN ('DLVY', 'DLVB', 'TRIP')
229: AND p_in_ids is not null AND p_in_ids.COUNT>0) THEN
230:

Line 279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

275: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_IGNOREPLAN_ERROR');
276: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
277: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_cur.delivery_name);
278: FND_MESSAGE.SET_TOKEN('REL_TRIP_NAME',cur_othertrip.trip_name);
279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 284: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

280:
281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
284: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.pop(l_module_name);
288: END IF;

Line 285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

281: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
282: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
283: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
284: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.pop(l_module_name);
288: END IF;
289: RETURN;

Line 312: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

308: END IF;
309:
310: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
311: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
312: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
313: l_num_error:=l_num_error+1;
314: GOTO next_trip;
315: END IF;
316: IF cur.delivery_type = 'CONSOLIDATION' THEN

Line 319: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

315: END IF;
316: IF cur.delivery_type = 'CONSOLIDATION' THEN
317: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
318: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
319: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
320: l_num_error:=l_num_error+1;
321: GOTO next_trip;
322: END IF;
323: END LOOP;

Line 335: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

331: AND l_gc3_is_installed = 'N' THEN -- OTM R12
332: --do not allow lines in thrid party instance to be set to include for planning
333: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
335: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
336: l_num_error:=l_num_error+1;
337: GOTO next_trip;
338: ELSE
339: l_tmp_detail_ids(l_tmp_detail_ids.COUNT+1):=l_det_cur.delivery_detail_id;

Line 406: WSH_UTIL_CORE.API_POST_CALL

402: IF l_debug_on THEN
403: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
404: END IF;
405: --
406: WSH_UTIL_CORE.API_POST_CALL
407: (
408: p_return_status => l_return_status,
409: x_num_warnings => l_warn,
410: x_num_errors => l_num_error,

Line 417: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

413: -- deleting the tables right here as they are being used in a loop.
414: l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
415: l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
416: --
417: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
418: rollback to before_update;
419: GOTO next_trip;
420: END IF;
421: --

Line 445: WSH_UTIL_CORE.API_POST_CALL

441: IF l_debug_on THEN
442: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
443: END IF;
444: --
445: WSH_UTIL_CORE.API_POST_CALL
446: (
447: p_return_status => l_return_status,
448: x_num_warnings => l_warn,
449: x_num_errors => l_num_error,

Line 456: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

452: -- deleting the tables right here as they are being used in a loop.
453: l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
454: l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
455: --
456: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
457: rollback to before_update;
458: GOTO next_trip;
459: END IF;
460: --

Line 482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
479: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
480: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
481: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
482: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
483: l_num_error:=l_num_error+1;
484: GOTO next_trip;
485: END IF;
486: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,

Line 490: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

486: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,
487: p_ignore_for_planning=>l_ignoreplan,
488: p_logexcep=>false,
489: x_return_status=>l_return_status );
490: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
491: l_warn:=l_warn+1;
492: END IF;
493: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
494: raise OTHERS;

Line 493: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

489: x_return_status=>l_return_status );
490: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
491: l_warn:=l_warn+1;
492: END IF;
493: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
494: raise OTHERS;
495: END IF;
496: END IF;
497:

Line 513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

509: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
510: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
511: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
512: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
513: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
514: l_num_error:=l_num_error+1;
515: GOTO next_trip;
516: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string
517: FOR i in l_tmp_del_ids.FIRST..l_tmp_del_ids.LAST LOOP

Line 532: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

528: IF l_debug_on THEN
529: wsh_debug_sv.log(l_module_name,'Return Status After Calling table_to_record ',l_return_status);
530: END IF;
531: --
532: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: rollback to before_update;
534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

534: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
535: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
536: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
537: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
538: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
539: l_num_error:=l_num_error+1;
540: goto next_trip;
541: END IF;
542: --

Line 554: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

550: IF l_debug_on THEN
551: wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_hash ',l_return_status);
552: END IF;
553: --
554: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
555: rollback to before_update;
556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

556: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
557: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
558: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
559: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
560: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
561: l_num_error:=l_num_error+1;
562: goto next_trip;
563: END IF;
564: --

Line 577: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

573: IF l_debug_on THEN
574: wsh_debug_sv.log(l_module_name,'Return Status After Calling update_delivery ',l_return_status);
575: END IF;
576: --
577: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
578: rollback to before_update;
579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

579: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
580: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
581: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
582: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
583: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
584: l_num_error:=l_num_error+1;
585: goto next_trip;
586: END IF;
587: --}

Line 639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

635: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
636: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
637: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
638: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
639: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
640: l_num_error:=l_num_error+1;
641: END IF;
642:
643: <>

Line 652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

648: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
649: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
650: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
651: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.pop(l_module_name);
656: END IF;

Line 653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

649: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
650: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
651: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.pop(l_module_name);
656: END IF;
657: RETURN;

Line 659: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

655: WSH_DEBUG_SV.pop(l_module_name);
656: END IF;
657: RETURN;
658: ELSIF l_num_error>0 THEN
659: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
660: END IF;
661:
662: elsif p_entity='DLVY' then
663:

Line 676: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

672: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
673: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
674: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
675: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
676: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
677: l_num_error:=l_num_error+1;
678: GOTO next_del;
679: END LOOP;
680:

Line 701: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

697: END IF;
698:
699: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
700: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
701: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
702: l_num_error:=l_num_error+1;
703: GOTO next_del;
704: END IF;
705: IF cur.delivery_type = 'CONSOLIDATION' THEN

Line 708: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

704: END IF;
705: IF cur.delivery_type = 'CONSOLIDATION' THEN
706: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
707: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
708: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
709: l_num_error:=l_num_error+1;
710: GOTO next_del;
711: END IF;
712: END IF;

Line 725: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

721: and l_gc3_is_installed = 'N' THEN -- OTM R12
722: --do not allow lines in thrid party instance to be set to include for planning
723: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
724: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
725: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
726: l_num_error:=l_num_error+1;
727: GOTO next_del;
728: ELSE
729: l_tmp_detail_ids(l_tmp_detail_ids.COUNT+1):=l_det_cur.delivery_detail_id;

Line 792: WSH_UTIL_CORE.API_POST_CALL

788: IF l_debug_on THEN
789: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
790: END IF;
791: --
792: WSH_UTIL_CORE.API_POST_CALL
793: (
794: p_return_status => l_return_status,
795: x_num_warnings => l_warn,
796: x_num_errors => l_num_error,

Line 803: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

799: -- deleting the tables right here as they are being used in a loop.
800: l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
801: l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
802: --
803: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
804: ROLLBACK to before_update;
805: GOTO next_del;
806: END IF;
807: --

Line 831: WSH_UTIL_CORE.API_POST_CALL

827: IF l_debug_on THEN
828: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
829: END IF;
830: --
831: WSH_UTIL_CORE.API_POST_CALL
832: (
833: p_return_status => l_return_status,
834: x_num_warnings => l_warn,
835: x_num_errors => l_num_error,

Line 842: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

838: -- deleting the tables right here as they are being used in a loop.
839: l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
840: l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
841: --
842: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
843: ROLLBACK to before_update;
844: GOTO next_del;
845: END IF;
846: --

Line 872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
869: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
870: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
871: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
872: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
873: l_num_error:=l_num_error+1;
874: GOTO next_del;
875: END IF;
876: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,

Line 880: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

876: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,
877: p_ignore_for_planning=>l_ignoreplan,
878: p_logexcep=>false,
879: x_return_status=>l_return_status );
880: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
881: l_warn:=l_warn+1;
882: END IF;
883: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
884: raise OTHERS;

Line 883: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

879: x_return_status=>l_return_status );
880: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
881: l_warn:=l_warn+1;
882: END IF;
883: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
884: raise OTHERS;
885: END IF;
886: END IF;
887: END IF;

Line 908: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

904: IF l_debug_on THEN
905: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
906: END IF;
907:
908: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
909: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
910: ROLLBACK to before_update;
911: l_num_error := l_num_error + 1;
912: GOTO next_del;

Line 909: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

905: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
906: END IF;
907:
908: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
909: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
910: ROLLBACK to before_update;
911: l_num_error := l_num_error + 1;
912: GOTO next_del;
913: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 913: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

909: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
910: ROLLBACK to before_update;
911: l_num_error := l_num_error + 1;
912: GOTO next_del;
913: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
914: l_warn:=l_warn+1;
915: END IF;
916:
917: l_delivery_info_tab(1) := l_delivery_info;

Line 1013: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

1009: WSH_DEBUG_SV.log(l_module_name,'Return Status after WMS API Call',l_return_status);
1010: WSH_DEBUG_SV.log(l_module_name,'Message Code',l_del_trip_tab(l_del_trip_tab.LAST).r_message_code);
1011: END IF;
1012:
1013: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1014: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1015: ROLLBACK to before_update;
1016: l_num_error := l_num_error + 1;
1017: GOTO next_del;

Line 1014: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1010: WSH_DEBUG_SV.log(l_module_name,'Message Code',l_del_trip_tab(l_del_trip_tab.LAST).r_message_code);
1011: END IF;
1012:
1013: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1014: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1015: ROLLBACK to before_update;
1016: l_num_error := l_num_error + 1;
1017: GOTO next_del;
1018: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1018: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1014: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1015: ROLLBACK to before_update;
1016: l_num_error := l_num_error + 1;
1017: GOTO next_del;
1018: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1019: l_warn:=l_warn+1;
1020: END IF;
1021:
1022: l_temp := l_del_trip_tab.LAST;

Line 1030: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);

1026: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,
1027: l_del_trip_tab(l_temp).r_message_code);
1028: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,
1029: l_del_trip_tab(l_temp).r_message_token);
1030: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);
1031: l_num_error:=l_num_error+1;
1032: GOTO next_del;
1033: END IF; --}
1034: END IF;--}

Line 1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1056: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1057: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1058: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1059: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1060: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1061: l_num_error:=l_num_error+1;
1062: goto next_del;
1063: ELSE --Added for bug 7611042 .More than zero rows updated. So calling the API to update the hash string
1064: --{

Line 1078: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1074: IF l_debug_on THEN
1075: wsh_debug_sv.log(l_module_name,'Return Status After Calling table_to_record ',l_return_status);
1076: END IF;
1077: --
1078: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1079: rollback to before_update;
1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1080: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1081: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1082: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1083: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1084: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1085: l_num_error:=l_num_error+1;
1086: goto next_del;
1087: END IF;
1088: --

Line 1100: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1096: IF l_debug_on THEN
1097: wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_hash ',l_return_status);
1098: END IF;
1099: --
1100: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1101: rollback to before_update;
1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1102: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1103: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1104: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1105: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1106: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1107: l_num_error:=l_num_error+1;
1108: goto next_del;
1109: END IF;
1110: --

Line 1123: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1119: IF l_debug_on THEN
1120: wsh_debug_sv.log(l_module_name,'Return Status After Calling update_delivery ',l_return_status);
1121: END IF;
1122: --
1123: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1124: rollback to before_update;
1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);

Line 1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1125: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1126: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1127: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1128: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
1129: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1130: l_num_error:=l_num_error+1;
1131: goto next_del;
1132: END IF;
1133: --}

Line 1155: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

1151: IF l_debug_on THEN
1152: WSH_DEBUG_SV.log(l_module_name,'Return Status after log_otm_exception',l_return_status);
1153: END IF;
1154:
1155: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1156: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1157: ROLLBACK to before_update;
1158: l_num_error := l_num_error + 1;
1159: GOTO next_del;

Line 1156: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1152: WSH_DEBUG_SV.log(l_module_name,'Return Status after log_otm_exception',l_return_status);
1153: END IF;
1154:
1155: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1156: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1157: ROLLBACK to before_update;
1158: l_num_error := l_num_error + 1;
1159: GOTO next_del;
1160: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1160: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1156: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1157: ROLLBACK to before_update;
1158: l_num_error := l_num_error + 1;
1159: GOTO next_del;
1160: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1161: l_warn := l_warn + 1;
1162: END IF;
1163:
1164: END IF;--}

Line 1176: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1172: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1173: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1174: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1175: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1176: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.pop(l_module_name);
1180: END IF;

Line 1177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1173: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1174: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1175: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1176: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.pop(l_module_name);
1180: END IF;
1181: RETURN;

Line 1183: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1179: WSH_DEBUG_SV.pop(l_module_name);
1180: END IF;
1181: RETURN;
1182: ELSIF l_num_error>0 THEN
1183: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1184: END IF;
1185:
1186:
1187: else

Line 1196: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1192: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1193: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1194: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1195: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1196: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1197: l_num_error:=l_num_error+1;
1198: GOTO next_det;
1199: END LOOP;
1200:

Line 1222: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1218: END IF;
1219:
1220: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');
1221: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1222: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1223: l_num_error:=l_num_error+1;
1224: GOTO next_det;
1225: END IF;
1226:

Line 1234: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1230: --3. check if line is assigned to a container. if so, user has to perform from topmost entity
1231: FOR cur IN c_get_det_ignoreflag_diff_cont(p_in_ids(i), l_ignoreplan) LOOP
1232: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');
1233: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1234: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1235: l_num_error:=l_num_error+1;
1236: GOTO next_det;
1237: END LOOP;
1238:

Line 1272: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1268: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1269: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1270: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1271: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1272: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1273: l_num_error:=l_num_error+1;
1274: GOTO next_det;
1275: END IF;
1276:

Line 1341: WSH_UTIL_CORE.API_POST_CALL

1337: IF l_debug_on THEN
1338: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1339: END IF;
1340: --
1341: WSH_UTIL_CORE.API_POST_CALL
1342: (
1343: p_return_status => l_return_status,
1344: x_num_warnings => l_warn,
1345: x_num_errors => l_num_error,

Line 1352: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1348: -- deleting the tables right here as they are being used in a loop.
1349: l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
1350: l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
1351: --
1352: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1353: GOTO next_det;
1354: END IF;
1355: --
1356: --}

Line 1379: WSH_UTIL_CORE.API_POST_CALL

1375: IF l_debug_on THEN
1376: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1377: END IF;
1378: --
1379: WSH_UTIL_CORE.API_POST_CALL
1380: (
1381: p_return_status => l_return_status,
1382: x_num_warnings => l_warn,
1383: x_num_errors => l_num_error,

Line 1390: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

1386: -- deleting the tables right here as they are being used in a loop.
1387: l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
1388: l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
1389: --
1390: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1391: GOTO next_det;
1392: END IF;
1393: --
1394: --}

Line 1404: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1400: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,
1401: p_ignore_for_planning=>l_ignoreplan,
1402: p_logexcep=>false,
1403: x_return_status=>l_return_status );
1404: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1405: l_warn:=l_warn+1;
1406: END IF;
1407: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1408: raise OTHERS;

Line 1407: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1403: x_return_status=>l_return_status );
1404: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1405: l_warn:=l_warn+1;
1406: END IF;
1407: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1408: raise OTHERS;
1409: END IF;
1410: END IF;
1411: ELSE --not a container

Line 1424: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1420: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1421: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1422: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1423: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1424: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1425: l_num_error:=l_num_error+1;
1426: END IF;
1427: Check_Shipset_Ignoreflag( p_delivery_detail_id=>p_in_ids(i),
1428: p_ignore_for_planning=>l_ignoreplan,

Line 1431: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1427: Check_Shipset_Ignoreflag( p_delivery_detail_id=>p_in_ids(i),
1428: p_ignore_for_planning=>l_ignoreplan,
1429: p_logexcep=>false,
1430: x_return_status=>l_return_status );
1431: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1432: l_warn:=l_warn+1;
1433: END IF;
1434: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1435: raise OTHERS;

Line 1434: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1430: x_return_status=>l_return_status );
1431: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1432: l_warn:=l_warn+1;
1433: END IF;
1434: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1435: raise OTHERS;
1436: END IF;
1437: END IF; --container
1438:

Line 1448: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1444: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1445: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1446: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1447: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1448: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: IF l_debug_on THEN
1451: WSH_DEBUG_SV.pop(l_module_name);
1452: END IF;

Line 1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1445: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1446: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1447: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1448: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: IF l_debug_on THEN
1451: WSH_DEBUG_SV.pop(l_module_name);
1452: END IF;
1453: RETURN;

Line 1455: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1451: WSH_DEBUG_SV.pop(l_module_name);
1452: END IF;
1453: RETURN;
1454: ELSIF l_num_error>0 THEN
1455: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1456: END IF;
1457: end if; --entity
1458: IF l_warn>0 THEN
1459: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');

Line 1460: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);

1456: END IF;
1457: end if; --entity
1458: IF l_warn>0 THEN
1459: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');
1460: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);
1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1462: END IF;
1463:
1464: END IF; --tp_is_installed

Line 1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1457: end if; --entity
1458: IF l_warn>0 THEN
1459: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');
1460: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);
1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1462: END IF;
1463:
1464: END IF; --tp_is_installed
1465:

Line 1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1468: END IF;
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1473: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');
1474: --
1475: -- Debug Statements
1476: --

Line 1473: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');

1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1473: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');
1474: --
1475: -- Debug Statements
1476: --
1477: IF l_debug_on THEN

Line 1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1568: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
1569: WSH_DEBUG_SV.log(l_module_name,'p_entity_id',p_entity_id);
1570: END IF;
1571:
1572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1573:
1574: SAVEPOINT before_firm;
1575:
1576: IF (p_entity='TRIP') THEN

Line 1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1577: FOR del_cur IN c_deliveries(p_entity_id) LOOP
1578:
1579: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,
1580: x_return_status => x_return_status);
1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1586: wsh_util_core.add_message(x_return_status);
1587: IF l_debug_on THEN
1588: WSH_DEBUG_SV.pop(l_module_name);
1589: END IF;

Line 1586: wsh_util_core.add_message(x_return_status);

1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1584: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1586: wsh_util_core.add_message(x_return_status);
1587: IF l_debug_on THEN
1588: WSH_DEBUG_SV.pop(l_module_name);
1589: END IF;
1590: RETURN;

Line 1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: IF l_debug_on THEN
1608: WSH_DEBUG_SV.pop(l_module_name);
1609: END IF;

Line 1606: wsh_util_core.add_message(x_return_status);

1602: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1603: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1604: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: IF l_debug_on THEN
1608: WSH_DEBUG_SV.pop(l_module_name);
1609: END IF;
1610: rollback to before_firm;

Line 1619: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1615: FOR l_trips_cur IN c_trips(p_entity_id,del_cur.delivery_id) LOOP
1616:
1617: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1618: x_return_status => x_return_status);
1619: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1620: rollback to before_firm;
1621: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1622: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1619: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1620: rollback to before_firm;
1621: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1622: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1624: wsh_util_core.add_message(x_return_status);
1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.pop(l_module_name);
1627: END IF;

Line 1624: wsh_util_core.add_message(x_return_status);

1620: rollback to before_firm;
1621: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1622: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1624: wsh_util_core.add_message(x_return_status);
1625: IF l_debug_on THEN
1626: WSH_DEBUG_SV.pop(l_module_name);
1627: END IF;
1628: RETURN;

Line 1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: wsh_util_core.add_message(x_return_status);
1647: IF l_debug_on THEN
1648: WSH_DEBUG_SV.pop(l_module_name);
1649: END IF;

Line 1646: wsh_util_core.add_message(x_return_status);

1642: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1643: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1644: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: wsh_util_core.add_message(x_return_status);
1647: IF l_debug_on THEN
1648: WSH_DEBUG_SV.pop(l_module_name);
1649: END IF;
1650: rollback to before_firm;

Line 1661: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1657: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1658: IF l_deliveries_exist IS null THEN
1659: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1660: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1661: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.pop(l_module_name);
1665: END IF;

Line 1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1658: IF l_deliveries_exist IS null THEN
1659: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1660: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1661: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.pop(l_module_name);
1665: END IF;
1666: rollback to before_firm;

Line 1676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1672: last_updated_by = FND_GLOBAL.USER_ID
1673: WHERE trip_id = p_entity_id;
1674: IF (SQL%NOTFOUND) THEN
1675: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1677: wsh_util_core.add_message(x_return_status);
1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.pop(l_module_name);
1680: END IF;

Line 1677: wsh_util_core.add_message(x_return_status);

1673: WHERE trip_id = p_entity_id;
1674: IF (SQL%NOTFOUND) THEN
1675: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1677: wsh_util_core.add_message(x_return_status);
1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.pop(l_module_name);
1680: END IF;
1681: rollback to before_firm;

Line 1701: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1697:
1698: IF NVL(l_trips_cur.planned_flag, 'N') = 'N' THEN
1699: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1700: x_return_status => x_return_status);
1701: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1702: rollback to before_firm;
1703: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1704: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1701: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1702: rollback to before_firm;
1703: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1704: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.pop(l_module_name);
1709: END IF;

Line 1706: wsh_util_core.add_message(x_return_status);

1702: rollback to before_firm;
1703: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1704: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: IF l_debug_on THEN
1708: WSH_DEBUG_SV.pop(l_module_name);
1709: END IF;
1710: RETURN;

Line 1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1721: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1726: wsh_util_core.add_message(x_return_status);
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.pop(l_module_name);
1729: END IF;

Line 1726: wsh_util_core.add_message(x_return_status);

1722: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1723: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1724: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1726: wsh_util_core.add_message(x_return_status);
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.pop(l_module_name);
1729: END IF;
1730: rollback to before_firm;

Line 1741: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1737: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1738: IF l_plannedflag IS null THEN
1739: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1740: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1741: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.pop(l_module_name);
1745: END IF;

Line 1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1738: IF l_plannedflag IS null THEN
1739: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1740: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1741: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.pop(l_module_name);
1745: END IF;
1746: rollback to before_firm;

Line 1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1753: WHERE delivery_id = p_entity_id;
1754:
1755: IF (SQL%NOTFOUND) THEN
1756: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1758: wsh_util_core.add_message(x_return_status);
1759: IF l_debug_on THEN
1760: WSH_DEBUG_SV.pop(l_module_name);
1761: END IF;

Line 1758: wsh_util_core.add_message(x_return_status);

1754:
1755: IF (SQL%NOTFOUND) THEN
1756: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1758: wsh_util_core.add_message(x_return_status);
1759: IF l_debug_on THEN
1760: WSH_DEBUG_SV.pop(l_module_name);
1761: END IF;
1762: rollback to before_firm;

Line 1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1771: WSH_DEBUG_SV.pop(l_module_name);
1772: END IF;
1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1776: rollback to before_firm;
1777: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');
1778: --
1779: -- Debug Statements

Line 1777: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');

1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1776: rollback to before_firm;
1777: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');
1778: --
1779: -- Debug Statements
1780: --
1781: IF l_debug_on THEN

Line 1870: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1866: WSH_DEBUG_SV.log(l_module_name,'p_entity_id',p_entity_id);
1867: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
1868: END IF;
1869:
1870: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1871:
1872: IF p_action='PLAN' THEN
1873: l_action:='Y';
1874: ELSIF p_action='UNPLAN' THEN

Line 1894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1890: WHERE trip_id = p_entity_id;
1891:
1892: IF (SQL%NOTFOUND) THEN
1893: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1895: wsh_util_core.add_message(x_return_status);
1896: IF l_debug_on THEN
1897: WSH_DEBUG_SV.pop(l_module_name);
1898: END IF;

Line 1895: wsh_util_core.add_message(x_return_status);

1891:
1892: IF (SQL%NOTFOUND) THEN
1893: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1895: wsh_util_core.add_message(x_return_status);
1896: IF l_debug_on THEN
1897: WSH_DEBUG_SV.pop(l_module_name);
1898: END IF;
1899: rollback to before_unfirm;

Line 1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1924: wsh_util_core.add_message(x_return_status);
1925: IF l_debug_on THEN
1926: WSH_DEBUG_SV.pop(l_module_name);
1927: END IF;

Line 1924: wsh_util_core.add_message(x_return_status);

1920: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1921: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1922: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1924: wsh_util_core.add_message(x_return_status);
1925: IF l_debug_on THEN
1926: WSH_DEBUG_SV.pop(l_module_name);
1927: END IF;
1928: rollback to before_unfirm;

Line 1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1946: wsh_util_core.add_message(x_return_status);
1947: IF l_debug_on THEN
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;

Line 1946: wsh_util_core.add_message(x_return_status);

1942: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1943: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1944: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1946: wsh_util_core.add_message(x_return_status);
1947: IF l_debug_on THEN
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950: rollback to before_unfirm;

Line 1967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1963: WHERE delivery_id = p_entity_id;
1964:
1965: IF (SQL%NOTFOUND) THEN
1966: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1968: wsh_util_core.add_message(x_return_status);
1969: IF l_debug_on THEN
1970: WSH_DEBUG_SV.pop(l_module_name);
1971: END IF;

Line 1968: wsh_util_core.add_message(x_return_status);

1964:
1965: IF (SQL%NOTFOUND) THEN
1966: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1968: wsh_util_core.add_message(x_return_status);
1969: IF l_debug_on THEN
1970: WSH_DEBUG_SV.pop(l_module_name);
1971: END IF;
1972: rollback to before_unfirm;

Line 1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1985: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1990: wsh_util_core.add_message(x_return_status);
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.pop(l_module_name);
1993: END IF;

Line 1990: wsh_util_core.add_message(x_return_status);

1986: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1987: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1988: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1990: wsh_util_core.add_message(x_return_status);
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.pop(l_module_name);
1993: END IF;
1994: rollback to before_unfirm;

Line 2007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2003: END IF;
2004:
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2008: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');
2009: rollback to before_unfirm;
2010: --
2011: -- Debug Statements

Line 2008: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');

2004:
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2008: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');
2009: rollback to before_unfirm;
2010: --
2011: -- Debug Statements
2012: --

Line 2025: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,

2021: PROCEDURE calculate_lpn_tpdates(p_delivery_detail_id NUMBER,
2022: x_updated_flag OUT NOCOPY VARCHAR2,
2023: x_delivery_id OUT NOCOPY NUMBER,
2024: x_return_status OUT NOCOPY VARCHAR2);
2025: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
2026: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
2027: x_return_status OUT NOCOPY VARCHAR2);
2028: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
2029: l_refresh_lpn_flag IN VARCHAR2,

Line 2026: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,

2022: x_updated_flag OUT NOCOPY VARCHAR2,
2023: x_delivery_id OUT NOCOPY NUMBER,
2024: x_return_status OUT NOCOPY VARCHAR2);
2025: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
2026: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
2027: x_return_status OUT NOCOPY VARCHAR2);
2028: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
2029: l_refresh_lpn_flag IN VARCHAR2,
2030: x_return_status OUT NOCOPY VARCHAR2);

Line 2028: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,

2024: x_return_status OUT NOCOPY VARCHAR2);
2025: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
2026: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
2027: x_return_status OUT NOCOPY VARCHAR2);
2028: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
2029: l_refresh_lpn_flag IN VARCHAR2,
2030: x_return_status OUT NOCOPY VARCHAR2);
2031:
2032: --needs to be changed based on Roy's email and after talking to Hema

Line 2134: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2130: THEN
2131: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2132: END IF;
2133:
2134: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2135:
2136:
2137: --
2138: IF l_debug_on THEN

Line 2529: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

2525: END IF;
2526: --
2527: EXCEPTION
2528: WHEN OTHERS THEN
2529: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2530: IF l_debug_on THEN
2531: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2532: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2552: p_entity_ids IN wsh_util_core.id_tab_type,

2548: * Atlast the tp dates are calculated for sorted delivery_list and container_list.
2549: */
2550:
2551: PROCEDURE calculate_cont_del_tpdates(p_entity IN VARCHAR2,
2552: p_entity_ids IN wsh_util_core.id_tab_type,
2553: x_return_status OUT NOCOPY VARCHAR2) IS
2554:
2555: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'calculate_cont_del_tpdates';
2556: --

Line 2581: l_del_ids wsh_util_core.id_tab_type;

2577: l_mas_detail_id NUMBER;
2578: l_container_flag VARCHAR(2);
2579:
2580:
2581: l_del_ids wsh_util_core.id_tab_type;
2582: l_dummy_ids wsh_util_core.id_tab_type;
2583: l_lpndetail_ids wsh_util_core.id_tab_type;
2584:
2585: del_index NUMBER;

Line 2582: l_dummy_ids wsh_util_core.id_tab_type;

2578: l_container_flag VARCHAR(2);
2579:
2580:
2581: l_del_ids wsh_util_core.id_tab_type;
2582: l_dummy_ids wsh_util_core.id_tab_type;
2583: l_lpndetail_ids wsh_util_core.id_tab_type;
2584:
2585: del_index NUMBER;
2586: detail_index NUMBER;

Line 2583: l_lpndetail_ids wsh_util_core.id_tab_type;

2579:
2580:
2581: l_del_ids wsh_util_core.id_tab_type;
2582: l_dummy_ids wsh_util_core.id_tab_type;
2583: l_lpndetail_ids wsh_util_core.id_tab_type;
2584:
2585: del_index NUMBER;
2586: detail_index NUMBER;
2587:

Line 2604: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2600: wsh_debug_sv.log (l_module_name,'p_entity', p_entity);
2601: wsh_debug_sv.log (l_module_name,'p_entity_ids.count', p_entity_ids.count);
2602: END IF;
2603:
2604: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2605: --
2606: --
2607:
2608: IF p_entity = 'DLVY' THEN

Line 2615: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2611: l_del_ids => p_entity_ids,
2612: l_refresh_lpn_flag => 'Y',
2613: x_return_status => x_return_status);
2614:
2615: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2616: return;
2617: END IF;
2618: END IF;
2619: ELSIF p_entity = 'LPN' THEN

Line 2629: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2625: IF ( l_del_ids.COUNT > 0 ) THEN
2626: calculate_del_tpdates( l_del_ids => l_del_ids,
2627: l_refresh_lpn_flag => 'N',
2628: x_return_status => x_return_status );
2629: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2630: raise OTHERS;
2631: END IF;
2632: END IF;
2633:

Line 2664: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2660: END LOOP;
2661: refresh_lpn_hierarchy_dates(l_lpndetail_ids => l_lpndetail_ids,
2662: x_upd_del_tab => l_dummy_ids,
2663: x_return_status => x_return_status);
2664: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2665: return;
2666: END IF;
2667: END IF;
2668:

Line 2680: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2676: calculate_del_tpdates( l_del_ids => l_del_ids,
2677: l_refresh_lpn_flag => 'Y',
2678: x_return_status => x_return_status );
2679:
2680: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2681: return;
2682: END IF;
2683: END IF;
2684:

Line 2697: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2693: END IF;
2694:
2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2698: WSH_UTIL_CORE.DEFAULT_HANDLER(
2699: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',
2700: l_module_name);
2701:

Line 2698: WSH_UTIL_CORE.DEFAULT_HANDLER(

2694:
2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2698: WSH_UTIL_CORE.DEFAULT_HANDLER(
2699: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',
2700: l_module_name);
2701:
2702: IF l_debug_on THEN

Line 2712: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,

2708: /**
2709: * calculate_del_tpdates calculates TPdates for the Deliveries.
2710: * l_del_ids is the list of deliveries for which tpdates have to be calculated or recalculated
2711: */
2712: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
2713: l_refresh_lpn_flag IN VARCHAR2,
2714: x_return_status OUT NOCOPY VARCHAR2
2715: ) IS
2716:

Line 2736: l_masdet_id wsh_util_core.id_tab_type;

2732: l_min_detSch_date DATE;
2733: l_min_detReq_date DATE;
2734: l_max_detSch_date DATE;
2735: l_delivery_id NUMBER;
2736: l_masdet_id wsh_util_core.id_tab_type;
2737: l_dummy_ids wsh_util_core.id_tab_type;
2738: l_del_date_calc_method VARCHAR(1);
2739: l_shp_dir VARCHAR2(5);
2740: others EXCEPTION;

Line 2737: l_dummy_ids wsh_util_core.id_tab_type;

2733: l_min_detReq_date DATE;
2734: l_max_detSch_date DATE;
2735: l_delivery_id NUMBER;
2736: l_masdet_id wsh_util_core.id_tab_type;
2737: l_dummy_ids wsh_util_core.id_tab_type;
2738: l_del_date_calc_method VARCHAR(1);
2739: l_shp_dir VARCHAR2(5);
2740: others EXCEPTION;
2741:

Line 2797: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

2793:
2794: --OTM R12, glog proj
2795: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2796: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2797: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2798: l_tms_update VARCHAR2(1);
2799: l_trip_not_found VARCHAR2(1);
2800: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2801: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

Line 2821: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2817: IF l_debug_on THEN
2818: WSH_DEBUG_SV.push(l_module_name);
2819: END IF;
2820: --
2821: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2822: --
2823:
2824: --
2825: --OTM R12, glog proj, use Global Variable

Line 2826: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

2822: --
2823:
2824: --
2825: --OTM R12, glog proj, use Global Variable
2826: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2827:
2828: -- If null, call the function
2829: IF l_gc3_is_installed IS NULL THEN
2830: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 2830: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

2826: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2827:
2828: -- If null, call the function
2829: IF l_gc3_is_installed IS NULL THEN
2830: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2831: END IF;
2832: -- Initialize these as they are used in UPDATE statement and in cases where
2833: -- these are not actually populated
2834: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

Line 2849: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2845: WSH_DEBUG_SV.log(l_module_name, 'After calling Get_Global_Parameters',
2846: x_return_status );
2847: END IF;
2848: --
2849: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2851: END IF;
2852: --
2853: l_del_date_calc_method := l_global_param_rec_type.DEL_DATE_CALC_METHOD;

Line 2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2846: x_return_status );
2847: END IF;
2848: --
2849: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2850: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2851: END IF;
2852: --
2853: l_del_date_calc_method := l_global_param_rec_type.DEL_DATE_CALC_METHOD;
2854: --

Line 2876: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2872:
2873: refresh_lpn_hierarchy_dates(l_lpndetail_ids => l_masdet_id, x_upd_del_tab => l_dummy_ids, x_return_status => x_return_status);
2874:
2875: --
2876: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2877: raise others;
2878: END IF;
2879: --}
2880: END LOOP;

Line 3057: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

3053: IF l_debug_on THEN
3054: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_trip_information', l_return_status);
3055: END IF;
3056:
3057: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3058: x_return_status := l_return_status;
3059: IF l_debug_on THEN
3060: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
3061: END IF;

Line 3084: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

3080: IF l_debug_on THEN
3081: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_delivery_information', l_return_status);
3082: END IF;
3083:
3084: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3085: x_return_status := l_return_status;
3086: IF l_debug_on THEN
3087: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
3088: END IF;

Line 3158: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

3154: IF l_debug_on THEN
3155: WSH_DEBUG_SV.log(l_module_name,'l_return_status after log_otm_exception', l_return_status);
3156: END IF;
3157:
3158: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3159: x_return_status := l_return_status;
3160: IF l_debug_on THEN
3161: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
3162: END IF;

Line 3208: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3204: CLOSE is_inbound_dropshp;
3205: END IF;
3206:
3207: -- The APIs which errored out would have set appropriate message
3208: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3209:
3210: IF l_debug_on THEN
3211: WSH_DEBUG_SV.logmsg(l_module_name,'Error Calculating TP Dates');
3212: WSH_DEBUG_SV.pop(l_module_name);

Line 3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3231: CLOSE is_inbound_dropshp;
3232: END IF;
3233:
3234: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3236: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
3237:
3238: IF l_debug_on THEN
3239: WSH_DEBUG_SV.log(l_module_name,'Cannot lock delivery for update',l_delivery_id);

Line 3236: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

3232: END IF;
3233:
3234: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3236: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
3237:
3238: IF l_debug_on THEN
3239: WSH_DEBUG_SV.log(l_module_name,'Cannot lock delivery for update',l_delivery_id);
3240: WSH_DEBUG_SV.pop(l_module_name);

Line 3261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3257: IF is_inbound_dropshp%ISOPEN THEN
3258: CLOSE is_inbound_dropshp;
3259: END IF;
3260:
3261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3262: WSH_UTIL_CORE.DEFAULT_HANDLER(
3263: 'WSH_TP_RELEASE.calculate_del_tpdates',
3264: l_module_name);
3265:

Line 3262: WSH_UTIL_CORE.DEFAULT_HANDLER(

3258: CLOSE is_inbound_dropshp;
3259: END IF;
3260:
3261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3262: WSH_UTIL_CORE.DEFAULT_HANDLER(
3263: 'WSH_TP_RELEASE.calculate_del_tpdates',
3264: l_module_name);
3265:
3266: IF l_debug_on THEN

Line 3279: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,

3275: * l_lpndetail_ids is the list of containers or items of containers for the which container tpdates
3276: * have to be calculated or recalculated
3277: * The LPN dates ripple upwards, So all the outer contaniers tpdates are recalculated.
3278: */
3279: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
3280: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
3281: x_return_status OUT NOCOPY VARCHAR2) IS
3282:
3283: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_lpn_hierarchy_dates';

Line 3280: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,

3276: * have to be calculated or recalculated
3277: * The LPN dates ripple upwards, So all the outer contaniers tpdates are recalculated.
3278: */
3279: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
3280: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
3281: x_return_status OUT NOCOPY VARCHAR2) IS
3282:
3283: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_lpn_hierarchy_dates';
3284: --

Line 3287: l_detail_tab WSH_UTIL_CORE.id_tab_type;

3283: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_lpn_hierarchy_dates';
3284: --
3285: l_debug_on BOOLEAN;
3286: --
3287: l_detail_tab WSH_UTIL_CORE.id_tab_type;
3288: l_container_flag VARCHAR(2);
3289: --Added for bug 5234326
3290: l_updated_flag VARCHAR2(1);
3291: l_delivery_id NUMBER;

Line 3317: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3313: IF l_debug_on THEN
3314: WSH_DEBUG_SV.push(l_module_name);
3315: END IF;
3316:
3317: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3318: --
3319: --
3320:
3321: FOR i IN 1..l_lpndetail_ids.count LOOP

Line 3330: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3326: calculate_lpn_tpdates(p_delivery_detail_id=> l_lpndetail_ids(i),
3327: x_updated_flag=> l_updated_flag,
3328: x_delivery_id => l_delivery_id,
3329: x_return_status=> x_return_status);
3330: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3331: raise OTHERS;
3332: END IF;
3333:
3334: --Added for bug 5234326

Line 3352: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3348: calculate_lpn_tpdates(p_delivery_detail_id=> l_detail_tab(j),
3349: x_delivery_id => l_delivery_id,
3350: x_updated_flag=> l_updated_flag,
3351: x_return_status=> x_return_status);
3352: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3353: raise OTHERS;
3354: END IF;
3355: IF (l_updated_flag = 'N') THEN
3356: EXIT;

Line 3378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3374: END IF;
3375:
3376: EXCEPTION
3377: WHEN OTHERS THEN
3378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3379: WSH_UTIL_CORE.DEFAULT_HANDLER(
3380: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',
3381: l_module_name);
3382:

Line 3379: WSH_UTIL_CORE.DEFAULT_HANDLER(

3375:
3376: EXCEPTION
3377: WHEN OTHERS THEN
3378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3379: WSH_UTIL_CORE.DEFAULT_HANDLER(
3380: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',
3381: l_module_name);
3382:
3383: IF l_debug_on THEN

Line 3440: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3436: IF l_debug_on THEN
3437: WSH_DEBUG_SV.push(l_module_name);
3438: END IF;
3439:
3440: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3441: --
3442: --
3443: OPEN max_min_tp_dates(p_delivery_detail_id);
3444: FETCH max_min_tp_dates INTO l_earliest_mpickup_date,l_earliest_mdropoff_date,l_latest_mpickup_date,l_latest_mdropoff_date;

Line 3527: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
3525: END IF;
3526: --
3527: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3528: IF l_debug_on THEN
3529: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
3530: WSH_DEBUG_SV.pop(l_module_name);
3531: END IF;

Line 3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3545: END IF;
3546:
3547: EXCEPTION
3548: WHEN OTHERS THEN
3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3550: WSH_UTIL_CORE.DEFAULT_HANDLER(
3551: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',
3552: l_module_name);
3553:

Line 3550: WSH_UTIL_CORE.DEFAULT_HANDLER(

3546:
3547: EXCEPTION
3548: WHEN OTHERS THEN
3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3550: WSH_UTIL_CORE.DEFAULT_HANDLER(
3551: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',
3552: l_module_name);
3553:
3554: IF l_debug_on THEN

Line 3674: PROCEDURE Check_Shipset_Ignoreflag( p_delivery_detail_ids wsh_util_core.id_tab_type,

3670: * Check_Shipset_Ignoreflag Checks if the p_delivery_detail_id ignore_for_planning
3671: * is different from other lines ignore_for_palnning which are in same ship set.
3672: * If so exception is logged if p_logexcep is True otherwise warinig message is thrown.
3673: */
3674: PROCEDURE Check_Shipset_Ignoreflag( p_delivery_detail_ids wsh_util_core.id_tab_type,
3675: p_ignore_for_planning VARCHAR2,
3676: p_logexcep boolean,
3677: x_return_status OUT NOCOPY VARCHAR2) IS
3678:

Line 3719: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3715: --
3716: BEGIN
3717:
3718: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3719: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3720: IF l_debug_on IS NULL THEN
3721: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3722: END IF;
3723:

Line 3767: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3763: p_message => l_exception_message,
3764: p_delivery_detail_id => l_delivery_detail_id
3765: );
3766: END IF;
3767: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3768: x_return_status := l_return_status;
3769: raise OTHERS;
3770: END IF;
3771: IF l_debug_on THEN

Line 3779: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3775: ELSE
3776: IF l_debug_on THEN
3777: WSH_DEBUG_SV.log(l_module_name,'Log waring l_delivery_detail_id',l_delivery_detail_id);
3778: END IF;
3779: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3780: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3781: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3782: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3783: END IF;

Line 3782: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3778: END IF;
3779: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3780: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3781: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3782: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3783: END IF;
3784: END IF;
3785: CLOSE c_check_ignore_for_planning;
3786: END LOOP;

Line 3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3793: WHEN OTHERS THEN
3794: IF c_check_ignore_for_planning%ISOPEN THEN
3795: CLOSE c_check_ignore_for_planning;
3796: END IF;
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3798: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');
3799: --
3800: --
3801: IF l_debug_on THEN

Line 3798: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');

3794: IF c_check_ignore_for_planning%ISOPEN THEN
3795: CLOSE c_check_ignore_for_planning;
3796: END IF;
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3798: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');
3799: --
3800: --
3801: IF l_debug_on THEN
3802: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| x_return_status||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3813: p_delivery_detail_ids wsh_util_core.id_tab_type;

3809: p_ignore_for_planning VARCHAR2,
3810: p_logexcep boolean,
3811: x_return_status OUT NOCOPY VARCHAR2) IS
3812:
3813: p_delivery_detail_ids wsh_util_core.id_tab_type;
3814:
3815: BEGIN
3816: p_delivery_detail_ids(0) := p_delivery_detail_id;
3817: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>p_delivery_detail_ids,