eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TP_RELEASE 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: END IF;
517:

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

562: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
563: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
564: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
565: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_in_ids(i)));
566: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
567: l_num_error:=l_num_error+1;
568: END IF;
569:
570: <>

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

575: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
576: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
579: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.pop(l_module_name);
583: END IF;

Line 580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

576: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_TRIP');
578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
579: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.pop(l_module_name);
583: END IF;
584: RETURN;

Line 586: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

582: WSH_DEBUG_SV.pop(l_module_name);
583: END IF;
584: RETURN;
585: ELSIF l_num_error>0 THEN
586: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
587: END IF;
588:
589: elsif p_entity='DLVY' then
590:

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

599: FOR cur IN c_get_del_ignoreflag_difftrip(p_in_ids(i), l_ignoreplan) LOOP
600: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR');
601: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
602: FND_MESSAGE.SET_TOKEN('TRIP_NAME',cur.trip_name);
603: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
604: l_num_error:=l_num_error+1;
605: GOTO next_del;
606: END LOOP;
607:

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

624: END IF;
625:
626: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
627: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
628: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
629: l_num_error:=l_num_error+1;
630: GOTO next_del;
631: END IF;
632: IF cur.delivery_type = 'CONSOLIDATION' THEN

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

631: END IF;
632: IF cur.delivery_type = 'CONSOLIDATION' THEN
633: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_MDC_ERROR');
634: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
635: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
636: l_num_error:=l_num_error+1;
637: GOTO next_del;
638: END IF;
639: END IF;

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

648: and l_gc3_is_installed = 'N' THEN -- OTM R12
649: --do not allow lines in thrid party instance to be set to include for planning
650: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_TPW_ERROR');
651: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_cur.delivery_id));
652: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
653: l_num_error:=l_num_error+1;
654: GOTO next_del;
655: ELSE
656: l_tmp_detail_ids(l_tmp_detail_ids.COUNT+1):=l_det_cur.delivery_detail_id;

Line 719: WSH_UTIL_CORE.API_POST_CALL

715: IF l_debug_on THEN
716: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
717: END IF;
718: --
719: WSH_UTIL_CORE.API_POST_CALL
720: (
721: p_return_status => l_return_status,
722: x_num_warnings => l_warn,
723: x_num_errors => l_num_error,

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

726: -- deleting the tables right here as they are being used in a loop.
727: l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
728: l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
729: --
730: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
731: ROLLBACK to before_update;
732: GOTO next_del;
733: END IF;
734: --

Line 758: WSH_UTIL_CORE.API_POST_CALL

754: IF l_debug_on THEN
755: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
756: END IF;
757: --
758: WSH_UTIL_CORE.API_POST_CALL
759: (
760: p_return_status => l_return_status,
761: x_num_warnings => l_warn,
762: x_num_errors => l_num_error,

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

765: -- deleting the tables right here as they are being used in a loop.
766: l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
767: l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
768: --
769: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
770: ROLLBACK to before_update;
771: GOTO next_del;
772: END IF;
773: --

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

795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
796: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
797: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
798: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
799: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
800: l_num_error:=l_num_error+1;
801: GOTO next_del;
802: END IF;
803: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,

Line 807: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

803: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,
804: p_ignore_for_planning=>l_ignoreplan,
805: p_logexcep=>false,
806: x_return_status=>l_return_status );
807: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
808: l_warn:=l_warn+1;
809: END IF;
810: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
811: raise OTHERS;

Line 810: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

806: x_return_status=>l_return_status );
807: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
808: l_warn:=l_warn+1;
809: END IF;
810: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
811: raise OTHERS;
812: END IF;
813: END IF;
814: END IF;

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

831: IF l_debug_on THEN
832: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
833: END IF;
834:
835: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
836: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
837: ROLLBACK to before_update;
838: l_num_error := l_num_error + 1;
839: GOTO next_del;

Line 836: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

832: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
833: END IF;
834:
835: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
836: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
837: ROLLBACK to before_update;
838: l_num_error := l_num_error + 1;
839: GOTO next_del;
840: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 840: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

836: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
837: ROLLBACK to before_update;
838: l_num_error := l_num_error + 1;
839: GOTO next_del;
840: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
841: l_warn:=l_warn+1;
842: END IF;
843:
844: l_delivery_info_tab(1) := l_delivery_info;

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

936: WSH_DEBUG_SV.log(l_module_name,'Return Status after WMS API Call',l_return_status);
937: WSH_DEBUG_SV.log(l_module_name,'Message Code',l_del_trip_tab(l_del_trip_tab.LAST).r_message_code);
938: END IF;
939:
940: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
941: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
942: ROLLBACK to before_update;
943: l_num_error := l_num_error + 1;
944: GOTO next_del;

Line 941: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

937: WSH_DEBUG_SV.log(l_module_name,'Message Code',l_del_trip_tab(l_del_trip_tab.LAST).r_message_code);
938: END IF;
939:
940: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
941: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
942: ROLLBACK to before_update;
943: l_num_error := l_num_error + 1;
944: GOTO next_del;
945: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 945: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

941: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
942: ROLLBACK to before_update;
943: l_num_error := l_num_error + 1;
944: GOTO next_del;
945: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
946: l_warn:=l_warn+1;
947: END IF;
948:
949: l_temp := l_del_trip_tab.LAST;

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

953: FND_MESSAGE.SET_NAME(l_del_trip_tab(l_temp).r_message_appl,
954: l_del_trip_tab(l_temp).r_message_code);
955: FND_MESSAGE.SET_TOKEN(l_del_trip_tab(l_temp).r_message_token_name,
956: l_del_trip_tab(l_temp).r_message_token);
957: wsh_util_core.add_message(l_del_trip_tab(l_temp).r_message_type, l_module_name);
958: l_num_error:=l_num_error+1;
959: GOTO next_del;
960: END IF; --}
961: END IF;--}

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

983: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
984: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
985: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
986: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(p_in_ids(i)));
987: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
988: l_num_error:=l_num_error+1;
989: END IF;
990:
991: -- OTM R12, glog proj

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

1006: IF l_debug_on THEN
1007: WSH_DEBUG_SV.log(l_module_name,'Return Status after log_otm_exception',l_return_status);
1008: END IF;
1009:
1010: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1011: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1012: ROLLBACK to before_update;
1013: l_num_error := l_num_error + 1;
1014: GOTO next_del;

Line 1011: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN

1007: WSH_DEBUG_SV.log(l_module_name,'Return Status after log_otm_exception',l_return_status);
1008: END IF;
1009:
1010: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1011: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1012: ROLLBACK to before_update;
1013: l_num_error := l_num_error + 1;
1014: GOTO next_del;
1015: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1015: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1011: WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1012: ROLLBACK to before_update;
1013: l_num_error := l_num_error + 1;
1014: GOTO next_del;
1015: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1016: l_warn := l_warn + 1;
1017: END IF;
1018:
1019: END IF;--}

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

1027: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1028: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1029: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1030: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1031: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.pop(l_module_name);
1035: END IF;

Line 1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1028: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1029: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1030: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1031: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.pop(l_module_name);
1035: END IF;
1036: RETURN;

Line 1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1034: WSH_DEBUG_SV.pop(l_module_name);
1035: END IF;
1036: RETURN;
1037: ELSIF l_num_error>0 THEN
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1039: END IF;
1040:
1041:
1042: else

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

1047: FOR cur IN c_get_det_ignoreflag_diff_del(p_in_ids(i), l_ignoreplan) LOOP
1048: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_ERROR_DETAIL');
1049: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1050: FND_MESSAGE.SET_TOKEN('DEL_NAME',cur.delivery_name);
1051: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1052: l_num_error:=l_num_error+1;
1053: GOTO next_det;
1054: END LOOP;
1055:

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

1073: END IF;
1074:
1075: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_DETTPW_ERROR');
1076: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1077: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1078: l_num_error:=l_num_error+1;
1079: GOTO next_det;
1080: END IF;
1081:

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

1085: --3. check if line is assigned to a container. if so, user has to perform from topmost entity
1086: FOR cur IN c_get_det_ignoreflag_diff_cont(p_in_ids(i), l_ignoreplan) LOOP
1087: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_DET_ASSN_CONT');
1088: FND_MESSAGE.SET_TOKEN('DET_ID',p_in_ids(i));
1089: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1090: l_num_error:=l_num_error+1;
1091: GOTO next_det;
1092: END LOOP;
1093:

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

1123: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1124: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_CONTAINER');
1125: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1126: FND_MESSAGE.SET_TOKEN('NAME',l_container_name);
1127: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1128: l_num_error:=l_num_error+1;
1129: GOTO next_det;
1130: END IF;
1131:

Line 1196: WSH_UTIL_CORE.API_POST_CALL

1192: IF l_debug_on THEN
1193: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1194: END IF;
1195: --
1196: WSH_UTIL_CORE.API_POST_CALL
1197: (
1198: p_return_status => l_return_status,
1199: x_num_warnings => l_warn,
1200: x_num_errors => l_num_error,

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

1203: -- deleting the tables right here as they are being used in a loop.
1204: l_sync_tmp_wms_recTbl.delivery_detail_id_tbl.delete;
1205: l_sync_tmp_wms_recTbl.operation_type_tbl.delete;
1206: --
1207: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1208: GOTO next_det;
1209: END IF;
1210: --
1211: --}

Line 1234: WSH_UTIL_CORE.API_POST_CALL

1230: IF l_debug_on THEN
1231: wsh_debug_sv.log(l_module_name, 'Return status after the call to WSH_WMS_SYNC_TMP_PKG.MERGE_BULK is ', l_return_status);
1232: END IF;
1233: --
1234: WSH_UTIL_CORE.API_POST_CALL
1235: (
1236: p_return_status => l_return_status,
1237: x_num_warnings => l_warn,
1238: x_num_errors => l_num_error,

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

1241: -- deleting the tables right here as they are being used in a loop.
1242: l_sync_tmp_inv_recTbl.delivery_detail_id_tbl.delete;
1243: l_sync_tmp_inv_recTbl.operation_type_tbl.delete;
1244: --
1245: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1246: GOTO next_det;
1247: END IF;
1248: --
1249: --}

Line 1259: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1255: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>l_tmp_detail_ids,
1256: p_ignore_for_planning=>l_ignoreplan,
1257: p_logexcep=>false,
1258: x_return_status=>l_return_status );
1259: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1260: l_warn:=l_warn+1;
1261: END IF;
1262: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1263: raise OTHERS;

Line 1262: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1258: x_return_status=>l_return_status );
1259: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1260: l_warn:=l_warn+1;
1261: END IF;
1262: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1263: raise OTHERS;
1264: END IF;
1265: END IF;
1266: ELSE --not a container

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

1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');
1276: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1277: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1278: FND_MESSAGE.SET_TOKEN('NAME',p_in_ids(i));
1279: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1280: l_num_error:=l_num_error+1;
1281: END IF;
1282: Check_Shipset_Ignoreflag( p_delivery_detail_id=>p_in_ids(i),
1283: p_ignore_for_planning=>l_ignoreplan,

Line 1286: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1282: Check_Shipset_Ignoreflag( p_delivery_detail_id=>p_in_ids(i),
1283: p_ignore_for_planning=>l_ignoreplan,
1284: p_logexcep=>false,
1285: x_return_status=>l_return_status );
1286: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1287: l_warn:=l_warn+1;
1288: END IF;
1289: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1290: raise OTHERS;

Line 1289: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1285: x_return_status=>l_return_status );
1286: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1287: l_warn:=l_warn+1;
1288: END IF;
1289: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1290: raise OTHERS;
1291: END IF;
1292: END IF; --container
1293:

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

1299: IF l_num_error>0 AND l_num_error=p_in_ids.COUNT THEN
1300: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1301: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1302: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1303: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.pop(l_module_name);
1307: END IF;

Line 1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1300: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_IGNORE_PLAN_ERROR');
1301: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_LINE');
1302: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1303: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.pop(l_module_name);
1307: END IF;
1308: RETURN;

Line 1310: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1306: WSH_DEBUG_SV.pop(l_module_name);
1307: END IF;
1308: RETURN;
1309: ELSIF l_num_error>0 THEN
1310: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1311: END IF;
1312: end if; --entity
1313: IF l_warn>0 THEN
1314: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');

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

1311: END IF;
1312: end if; --entity
1313: IF l_warn>0 THEN
1314: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');
1315: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);
1316: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1317: END IF;
1318:
1319: END IF; --tp_is_installed

Line 1316: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1312: end if; --entity
1313: IF l_warn>0 THEN
1314: FND_MESSAGE.SET_NAME('WSH','WSH_IGNORE_PLAN_WARN');
1315: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_warning,l_module_name);
1316: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1317: END IF;
1318:
1319: END IF; --tp_is_installed
1320:

Line 1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1323: END IF;
1324:
1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1328: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');
1329: --
1330: -- Debug Statements
1331: --

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

1324:
1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1328: wsh_util_core.default_handler('WSH_TP_RELEASE.change_ignoreplan_status');
1329: --
1330: -- Debug Statements
1331: --
1332: IF l_debug_on THEN

Line 1427: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1423: WSH_DEBUG_SV.log(l_module_name,'p_entity',p_entity);
1424: WSH_DEBUG_SV.log(l_module_name,'p_entity_id',p_entity_id);
1425: END IF;
1426:
1427: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1428:
1429: SAVEPOINT before_firm;
1430:
1431: IF (p_entity='TRIP') THEN

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

1432: FOR del_cur IN c_deliveries(p_entity_id) LOOP
1433:
1434: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,
1435: x_return_status => x_return_status);
1436: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1436: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1441: wsh_util_core.add_message(x_return_status);
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.pop(l_module_name);
1444: END IF;

Line 1441: wsh_util_core.add_message(x_return_status);

1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');
1439: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1441: wsh_util_core.add_message(x_return_status);
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.pop(l_module_name);
1444: END IF;
1445: RETURN;

Line 1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.pop(l_module_name);
1464: END IF;

Line 1461: wsh_util_core.add_message(x_return_status);

1457: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1458: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1459: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.pop(l_module_name);
1464: END IF;
1465: rollback to before_firm;

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

1470: FOR l_trips_cur IN c_trips(p_entity_id,del_cur.delivery_id) LOOP
1471:
1472: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1473: x_return_status => x_return_status);
1474: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1475: rollback to before_firm;
1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1474: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1475: rollback to before_firm;
1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1479: wsh_util_core.add_message(x_return_status);
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.pop(l_module_name);
1482: END IF;

Line 1479: wsh_util_core.add_message(x_return_status);

1475: rollback to before_firm;
1476: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1477: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1479: wsh_util_core.add_message(x_return_status);
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.pop(l_module_name);
1482: END IF;
1483: RETURN;

Line 1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: wsh_util_core.add_message(x_return_status);
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.pop(l_module_name);
1504: END IF;

Line 1501: wsh_util_core.add_message(x_return_status);

1497: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1498: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1499: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: wsh_util_core.add_message(x_return_status);
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.pop(l_module_name);
1504: END IF;
1505: rollback to before_firm;

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

1512: --if l_deliveries_exist is null, no deliveries exist for trip => trip can't be firmed
1513: IF l_deliveries_exist IS null THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1516: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1517: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1518: IF l_debug_on THEN
1519: WSH_DEBUG_SV.pop(l_module_name);
1520: END IF;

Line 1517: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1513: IF l_deliveries_exist IS null THEN
1514: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_TRIP_ERROR');
1515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_entity_id));
1516: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1517: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1518: IF l_debug_on THEN
1519: WSH_DEBUG_SV.pop(l_module_name);
1520: END IF;
1521: rollback to before_firm;

Line 1531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1527: last_updated_by = FND_GLOBAL.USER_ID
1528: WHERE trip_id = p_entity_id;
1529: IF (SQL%NOTFOUND) THEN
1530: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1532: wsh_util_core.add_message(x_return_status);
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.pop(l_module_name);
1535: END IF;

Line 1532: wsh_util_core.add_message(x_return_status);

1528: WHERE trip_id = p_entity_id;
1529: IF (SQL%NOTFOUND) THEN
1530: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1532: wsh_util_core.add_message(x_return_status);
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.pop(l_module_name);
1535: END IF;
1536: rollback to before_firm;

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

1552:
1553: IF NVL(l_trips_cur.planned_flag, 'N') = 'N' THEN
1554: wsh_trip_validations.check_plan(p_trip_id => l_trips_cur.trip_id,
1555: x_return_status => x_return_status);
1556: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1557: rollback to before_firm;
1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1556: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1557: rollback to before_firm;
1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1561: wsh_util_core.add_message(x_return_status);
1562: IF l_debug_on THEN
1563: WSH_DEBUG_SV.pop(l_module_name);
1564: END IF;

Line 1561: wsh_util_core.add_message(x_return_status);

1557: rollback to before_firm;
1558: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_CANNOT_FIRM');
1559: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1561: wsh_util_core.add_message(x_return_status);
1562: IF l_debug_on THEN
1563: WSH_DEBUG_SV.pop(l_module_name);
1564: END IF;
1565: RETURN;

Line 1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1576: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: IF l_debug_on THEN
1583: WSH_DEBUG_SV.pop(l_module_name);
1584: END IF;

Line 1581: wsh_util_core.add_message(x_return_status);

1577: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1578: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1579: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: IF l_debug_on THEN
1583: WSH_DEBUG_SV.pop(l_module_name);
1584: END IF;
1585: rollback to before_firm;

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

1592: --if l_plannedflag is null, no trip is associated => delivery can't be firmed
1593: IF l_plannedflag IS null THEN
1594: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1595: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1596: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.pop(l_module_name);
1600: END IF;

Line 1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1593: IF l_plannedflag IS null THEN
1594: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_DELIVERY_ERROR');
1595: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
1596: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.pop(l_module_name);
1600: END IF;
1601: rollback to before_firm;

Line 1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1608: WHERE delivery_id = p_entity_id;
1609:
1610: IF (SQL%NOTFOUND) THEN
1611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1613: wsh_util_core.add_message(x_return_status);
1614: IF l_debug_on THEN
1615: WSH_DEBUG_SV.pop(l_module_name);
1616: END IF;

Line 1613: wsh_util_core.add_message(x_return_status);

1609:
1610: IF (SQL%NOTFOUND) THEN
1611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1613: wsh_util_core.add_message(x_return_status);
1614: IF l_debug_on THEN
1615: WSH_DEBUG_SV.pop(l_module_name);
1616: END IF;
1617: rollback to before_firm;

Line 1630: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1626: WSH_DEBUG_SV.pop(l_module_name);
1627: END IF;
1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1631: rollback to before_firm;
1632: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');
1633: --
1634: -- Debug Statements

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

1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1631: rollback to before_firm;
1632: wsh_util_core.default_handler('WSH_TP_RELEASE.firm_entity');
1633: --
1634: -- Debug Statements
1635: --
1636: IF l_debug_on THEN

Line 1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1721: WSH_DEBUG_SV.log(l_module_name,'p_entity_id',p_entity_id);
1722: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
1723: END IF;
1724:
1725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1726:
1727: IF p_action='PLAN' THEN
1728: l_action:='Y';
1729: ELSIF p_action='UNPLAN' THEN

Line 1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1745: WHERE trip_id = p_entity_id;
1746:
1747: IF (SQL%NOTFOUND) THEN
1748: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1750: wsh_util_core.add_message(x_return_status);
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.pop(l_module_name);
1753: END IF;

Line 1750: wsh_util_core.add_message(x_return_status);

1746:
1747: IF (SQL%NOTFOUND) THEN
1748: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1750: wsh_util_core.add_message(x_return_status);
1751: IF l_debug_on THEN
1752: WSH_DEBUG_SV.pop(l_module_name);
1753: END IF;
1754: rollback to before_unfirm;

Line 1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: wsh_util_core.add_message(x_return_status);
1780: IF l_debug_on THEN
1781: WSH_DEBUG_SV.pop(l_module_name);
1782: END IF;

Line 1779: wsh_util_core.add_message(x_return_status);

1775: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_DELIVERY');
1776: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1777: FND_MESSAGE.SET_TOKEN('NAME',wsh_new_deliveries_pvt.get_name(del_cur.delivery_id));
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: wsh_util_core.add_message(x_return_status);
1780: IF l_debug_on THEN
1781: WSH_DEBUG_SV.pop(l_module_name);
1782: END IF;
1783: rollback to before_unfirm;

Line 1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1801: wsh_util_core.add_message(x_return_status);
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.pop(l_module_name);
1804: END IF;

Line 1801: wsh_util_core.add_message(x_return_status);

1797: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1798: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1799: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(l_trips_cur.trip_id));
1800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1801: wsh_util_core.add_message(x_return_status);
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.pop(l_module_name);
1804: END IF;
1805: rollback to before_unfirm;

Line 1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1818: WHERE delivery_id = p_entity_id;
1819:
1820: IF (SQL%NOTFOUND) THEN
1821: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1823: wsh_util_core.add_message(x_return_status);
1824: IF l_debug_on THEN
1825: WSH_DEBUG_SV.pop(l_module_name);
1826: END IF;

Line 1823: wsh_util_core.add_message(x_return_status);

1819:
1820: IF (SQL%NOTFOUND) THEN
1821: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1823: wsh_util_core.add_message(x_return_status);
1824: IF l_debug_on THEN
1825: WSH_DEBUG_SV.pop(l_module_name);
1826: END IF;
1827: rollback to before_unfirm;

Line 1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1840: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');
1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: wsh_util_core.add_message(x_return_status);
1846: IF l_debug_on THEN
1847: WSH_DEBUG_SV.pop(l_module_name);
1848: END IF;

Line 1845: wsh_util_core.add_message(x_return_status);

1841: l_entity := FND_MESSAGE.GET_STRING('WSH','WSH_ENTITY_RELATED_TRIP');
1842: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity);
1843: FND_MESSAGE.SET_TOKEN('NAME',wsh_trips_pvt.get_name(p_entity_id));
1844: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1845: wsh_util_core.add_message(x_return_status);
1846: IF l_debug_on THEN
1847: WSH_DEBUG_SV.pop(l_module_name);
1848: END IF;
1849: rollback to before_unfirm;

Line 1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1858: END IF;
1859:
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1863: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');
1864: rollback to before_unfirm;
1865: --
1866: -- Debug Statements

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

1859:
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1863: wsh_util_core.default_handler('WSH_TP_RELEASE.unfirm_entity');
1864: rollback to before_unfirm;
1865: --
1866: -- Debug Statements
1867: --

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

1876: PROCEDURE calculate_lpn_tpdates(p_delivery_detail_id NUMBER,
1877: x_updated_flag OUT NOCOPY VARCHAR2,
1878: x_delivery_id OUT NOCOPY NUMBER,
1879: x_return_status OUT NOCOPY VARCHAR2);
1880: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
1881: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
1882: x_return_status OUT NOCOPY VARCHAR2);
1883: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
1884: l_refresh_lpn_flag IN VARCHAR2,

Line 1881: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,

1877: x_updated_flag OUT NOCOPY VARCHAR2,
1878: x_delivery_id OUT NOCOPY NUMBER,
1879: x_return_status OUT NOCOPY VARCHAR2);
1880: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
1881: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
1882: x_return_status OUT NOCOPY VARCHAR2);
1883: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
1884: l_refresh_lpn_flag IN VARCHAR2,
1885: x_return_status OUT NOCOPY VARCHAR2);

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

1879: x_return_status OUT NOCOPY VARCHAR2);
1880: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
1881: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
1882: x_return_status OUT NOCOPY VARCHAR2);
1883: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
1884: l_refresh_lpn_flag IN VARCHAR2,
1885: x_return_status OUT NOCOPY VARCHAR2);
1886:
1887: --needs to be changed based on Roy's email and after talking to Hema

Line 1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1985: THEN
1986: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1987: END IF;
1988:
1989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1990:
1991:
1992: --
1993: IF l_debug_on THEN

Line 2382: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

2378: END IF;
2379: --
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2383: IF l_debug_on THEN
2384: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2385: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2405: p_entity_ids IN wsh_util_core.id_tab_type,

2401: * Atlast the tp dates are calculated for sorted delivery_list and container_list.
2402: */
2403:
2404: PROCEDURE calculate_cont_del_tpdates(p_entity IN VARCHAR2,
2405: p_entity_ids IN wsh_util_core.id_tab_type,
2406: x_return_status OUT NOCOPY VARCHAR2) IS
2407:
2408: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'calculate_cont_del_tpdates';
2409: --

Line 2434: l_del_ids wsh_util_core.id_tab_type;

2430: l_mas_detail_id NUMBER;
2431: l_container_flag VARCHAR(2);
2432:
2433:
2434: l_del_ids wsh_util_core.id_tab_type;
2435: l_dummy_ids wsh_util_core.id_tab_type;
2436: l_lpndetail_ids wsh_util_core.id_tab_type;
2437:
2438: del_index NUMBER;

Line 2435: l_dummy_ids wsh_util_core.id_tab_type;

2431: l_container_flag VARCHAR(2);
2432:
2433:
2434: l_del_ids wsh_util_core.id_tab_type;
2435: l_dummy_ids wsh_util_core.id_tab_type;
2436: l_lpndetail_ids wsh_util_core.id_tab_type;
2437:
2438: del_index NUMBER;
2439: detail_index NUMBER;

Line 2436: l_lpndetail_ids wsh_util_core.id_tab_type;

2432:
2433:
2434: l_del_ids wsh_util_core.id_tab_type;
2435: l_dummy_ids wsh_util_core.id_tab_type;
2436: l_lpndetail_ids wsh_util_core.id_tab_type;
2437:
2438: del_index NUMBER;
2439: detail_index NUMBER;
2440:

Line 2457: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2453: wsh_debug_sv.log (l_module_name,'p_entity', p_entity);
2454: wsh_debug_sv.log (l_module_name,'p_entity_ids.count', p_entity_ids.count);
2455: END IF;
2456:
2457: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2458: --
2459: --
2460:
2461: IF p_entity = 'DLVY' THEN

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

2464: l_del_ids => p_entity_ids,
2465: l_refresh_lpn_flag => 'Y',
2466: x_return_status => x_return_status);
2467:
2468: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2469: return;
2470: END IF;
2471: END IF;
2472: ELSIF p_entity = 'LPN' THEN

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

2478: IF ( l_del_ids.COUNT > 0 ) THEN
2479: calculate_del_tpdates( l_del_ids => l_del_ids,
2480: l_refresh_lpn_flag => 'N',
2481: x_return_status => x_return_status );
2482: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2483: raise OTHERS;
2484: END IF;
2485: END IF;
2486:

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

2513: END LOOP;
2514: refresh_lpn_hierarchy_dates(l_lpndetail_ids => l_lpndetail_ids,
2515: x_upd_del_tab => l_dummy_ids,
2516: x_return_status => x_return_status);
2517: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2518: return;
2519: END IF;
2520: END IF;
2521:

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

2529: calculate_del_tpdates( l_del_ids => l_del_ids,
2530: l_refresh_lpn_flag => 'Y',
2531: x_return_status => x_return_status );
2532:
2533: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2534: return;
2535: END IF;
2536: END IF;
2537:

Line 2550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2546: END IF;
2547:
2548: EXCEPTION
2549: WHEN OTHERS THEN
2550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2551: WSH_UTIL_CORE.DEFAULT_HANDLER(
2552: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',
2553: l_module_name);
2554:

Line 2551: WSH_UTIL_CORE.DEFAULT_HANDLER(

2547:
2548: EXCEPTION
2549: WHEN OTHERS THEN
2550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2551: WSH_UTIL_CORE.DEFAULT_HANDLER(
2552: 'WSH_TP_RELEASE.calculate_cont_del_tpdates',
2553: l_module_name);
2554:
2555: IF l_debug_on THEN

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

2561: /**
2562: * calculate_del_tpdates calculates TPdates for the Deliveries.
2563: * l_del_ids is the list of deliveries for which tpdates have to be calculated or recalculated
2564: */
2565: PROCEDURE calculate_del_tpdates(l_del_ids IN wsh_util_core.id_tab_type,
2566: l_refresh_lpn_flag IN VARCHAR2,
2567: x_return_status OUT NOCOPY VARCHAR2
2568: ) IS
2569:

Line 2589: l_masdet_id wsh_util_core.id_tab_type;

2585: l_min_detSch_date DATE;
2586: l_min_detReq_date DATE;
2587: l_max_detSch_date DATE;
2588: l_delivery_id NUMBER;
2589: l_masdet_id wsh_util_core.id_tab_type;
2590: l_dummy_ids wsh_util_core.id_tab_type;
2591: l_del_date_calc_method VARCHAR(1);
2592: l_shp_dir VARCHAR2(5);
2593: others EXCEPTION;

Line 2590: l_dummy_ids wsh_util_core.id_tab_type;

2586: l_min_detReq_date DATE;
2587: l_max_detSch_date DATE;
2588: l_delivery_id NUMBER;
2589: l_masdet_id wsh_util_core.id_tab_type;
2590: l_dummy_ids wsh_util_core.id_tab_type;
2591: l_del_date_calc_method VARCHAR(1);
2592: l_shp_dir VARCHAR2(5);
2593: others EXCEPTION;
2594:

Line 2650: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

2646:
2647: --OTM R12, glog proj
2648: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2649: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2650: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2651: l_tms_update VARCHAR2(1);
2652: l_trip_not_found VARCHAR2(1);
2653: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2654: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

Line 2674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2670: IF l_debug_on THEN
2671: WSH_DEBUG_SV.push(l_module_name);
2672: END IF;
2673: --
2674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2675: --
2676:
2677: --
2678: --OTM R12, glog proj, use Global Variable

Line 2679: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

2675: --
2676:
2677: --
2678: --OTM R12, glog proj, use Global Variable
2679: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2680:
2681: -- If null, call the function
2682: IF l_gc3_is_installed IS NULL THEN
2683: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 2683: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

2679: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2680:
2681: -- If null, call the function
2682: IF l_gc3_is_installed IS NULL THEN
2683: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2684: END IF;
2685: -- Initialize these as they are used in UPDATE statement and in cases where
2686: -- these are not actually populated
2687: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

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

2698: WSH_DEBUG_SV.log(l_module_name, 'After calling Get_Global_Parameters',
2699: x_return_status );
2700: END IF;
2701: --
2702: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2704: END IF;
2705: --
2706: l_del_date_calc_method := l_global_param_rec_type.DEL_DATE_CALC_METHOD;

Line 2703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2699: x_return_status );
2700: END IF;
2701: --
2702: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2704: END IF;
2705: --
2706: l_del_date_calc_method := l_global_param_rec_type.DEL_DATE_CALC_METHOD;
2707: --

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

2725:
2726: refresh_lpn_hierarchy_dates(l_lpndetail_ids => l_masdet_id, x_upd_del_tab => l_dummy_ids, x_return_status => x_return_status);
2727:
2728: --
2729: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2730: raise others;
2731: END IF;
2732: --}
2733: END LOOP;

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

2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_trip_information', l_return_status);
2908: END IF;
2909:
2910: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2911: x_return_status := l_return_status;
2912: IF l_debug_on THEN
2913: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
2914: END IF;

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

2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_delivery_information', l_return_status);
2935: END IF;
2936:
2937: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2938: x_return_status := l_return_status;
2939: IF l_debug_on THEN
2940: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
2941: END IF;

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

3007: IF l_debug_on THEN
3008: WSH_DEBUG_SV.log(l_module_name,'l_return_status after log_otm_exception', l_return_status);
3009: END IF;
3010:
3011: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3012: x_return_status := l_return_status;
3013: IF l_debug_on THEN
3014: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
3015: END IF;

Line 3061: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3057: CLOSE is_inbound_dropshp;
3058: END IF;
3059:
3060: -- The APIs which errored out would have set appropriate message
3061: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3062:
3063: IF l_debug_on THEN
3064: WSH_DEBUG_SV.logmsg(l_module_name,'Error Calculating TP Dates');
3065: WSH_DEBUG_SV.pop(l_module_name);

Line 3088: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3084: CLOSE is_inbound_dropshp;
3085: END IF;
3086:
3087: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3088: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3089: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
3090:
3091: IF l_debug_on THEN
3092: WSH_DEBUG_SV.log(l_module_name,'Cannot lock delivery for update',l_delivery_id);

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

3085: END IF;
3086:
3087: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3088: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3089: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
3090:
3091: IF l_debug_on THEN
3092: WSH_DEBUG_SV.log(l_module_name,'Cannot lock delivery for update',l_delivery_id);
3093: WSH_DEBUG_SV.pop(l_module_name);

Line 3114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3110: IF is_inbound_dropshp%ISOPEN THEN
3111: CLOSE is_inbound_dropshp;
3112: END IF;
3113:
3114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3115: WSH_UTIL_CORE.DEFAULT_HANDLER(
3116: 'WSH_TP_RELEASE.calculate_del_tpdates',
3117: l_module_name);
3118:

Line 3115: WSH_UTIL_CORE.DEFAULT_HANDLER(

3111: CLOSE is_inbound_dropshp;
3112: END IF;
3113:
3114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3115: WSH_UTIL_CORE.DEFAULT_HANDLER(
3116: 'WSH_TP_RELEASE.calculate_del_tpdates',
3117: l_module_name);
3118:
3119: IF l_debug_on THEN

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

3128: * l_lpndetail_ids is the list of containers or items of containers for the which container tpdates
3129: * have to be calculated or recalculated
3130: * The LPN dates ripple upwards, So all the outer contaniers tpdates are recalculated.
3131: */
3132: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
3133: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
3134: x_return_status OUT NOCOPY VARCHAR2) IS
3135:
3136: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_lpn_hierarchy_dates';

Line 3133: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,

3129: * have to be calculated or recalculated
3130: * The LPN dates ripple upwards, So all the outer contaniers tpdates are recalculated.
3131: */
3132: PROCEDURE refresh_lpn_hierarchy_dates(l_lpndetail_ids IN wsh_util_core.id_tab_type,
3133: x_upd_del_tab OUT NOCOPY wsh_util_core.id_tab_type,
3134: x_return_status OUT NOCOPY VARCHAR2) IS
3135:
3136: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_lpn_hierarchy_dates';
3137: --

Line 3140: l_detail_tab WSH_UTIL_CORE.id_tab_type;

3136: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'refresh_lpn_hierarchy_dates';
3137: --
3138: l_debug_on BOOLEAN;
3139: --
3140: l_detail_tab WSH_UTIL_CORE.id_tab_type;
3141: l_container_flag VARCHAR(2);
3142: --Added for bug 5234326
3143: l_updated_flag VARCHAR2(1);
3144: l_delivery_id NUMBER;

Line 3170: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3166: IF l_debug_on THEN
3167: WSH_DEBUG_SV.push(l_module_name);
3168: END IF;
3169:
3170: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3171: --
3172: --
3173:
3174: FOR i IN 1..l_lpndetail_ids.count LOOP

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

3179: calculate_lpn_tpdates(p_delivery_detail_id=> l_lpndetail_ids(i),
3180: x_updated_flag=> l_updated_flag,
3181: x_delivery_id => l_delivery_id,
3182: x_return_status=> x_return_status);
3183: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3184: raise OTHERS;
3185: END IF;
3186:
3187: --Added for bug 5234326

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

3201: calculate_lpn_tpdates(p_delivery_detail_id=> l_detail_tab(j),
3202: x_delivery_id => l_delivery_id,
3203: x_updated_flag=> l_updated_flag,
3204: x_return_status=> x_return_status);
3205: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3206: raise OTHERS;
3207: END IF;
3208: IF (l_updated_flag = 'N') THEN
3209: EXIT;

Line 3231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3227: END IF;
3228:
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3232: WSH_UTIL_CORE.DEFAULT_HANDLER(
3233: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',
3234: l_module_name);
3235:

Line 3232: WSH_UTIL_CORE.DEFAULT_HANDLER(

3228:
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3232: WSH_UTIL_CORE.DEFAULT_HANDLER(
3233: 'WSH_TP_RELEASE.refresh_lpn_hierarchy_dates',
3234: l_module_name);
3235:
3236: IF l_debug_on THEN

Line 3293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3289: IF l_debug_on THEN
3290: WSH_DEBUG_SV.push(l_module_name);
3291: END IF;
3292:
3293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3294: --
3295: --
3296: OPEN max_min_tp_dates(p_delivery_detail_id);
3297: FETCH max_min_tp_dates INTO l_earliest_mpickup_date,l_earliest_mdropoff_date,l_latest_mpickup_date,l_latest_mdropoff_date;

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

3376: IF l_debug_on THEN
3377: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
3378: END IF;
3379: --
3380: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE');
3383: WSH_DEBUG_SV.pop(l_module_name);
3384: END IF;

Line 3402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3398: END IF;
3399:
3400: EXCEPTION
3401: WHEN OTHERS THEN
3402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3403: WSH_UTIL_CORE.DEFAULT_HANDLER(
3404: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',
3405: l_module_name);
3406:

Line 3403: WSH_UTIL_CORE.DEFAULT_HANDLER(

3399:
3400: EXCEPTION
3401: WHEN OTHERS THEN
3402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3403: WSH_UTIL_CORE.DEFAULT_HANDLER(
3404: 'WSH_TP_RELEASE.calculate_lpn_tpdates(delivery_id)',
3405: l_module_name);
3406:
3407: IF l_debug_on THEN

Line 3527: PROCEDURE Check_Shipset_Ignoreflag( p_delivery_detail_ids wsh_util_core.id_tab_type,

3523: * Check_Shipset_Ignoreflag Checks if the p_delivery_detail_id ignore_for_planning
3524: * is different from other lines ignore_for_palnning which are in same ship set.
3525: * If so exception is logged if p_logexcep is True otherwise warinig message is thrown.
3526: */
3527: PROCEDURE Check_Shipset_Ignoreflag( p_delivery_detail_ids wsh_util_core.id_tab_type,
3528: p_ignore_for_planning VARCHAR2,
3529: p_logexcep boolean,
3530: x_return_status OUT NOCOPY VARCHAR2) IS
3531:

Line 3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3568: --
3569: BEGIN
3570:
3571: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3573: IF l_debug_on IS NULL THEN
3574: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3575: END IF;
3576:

Line 3620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3616: p_message => l_exception_message,
3617: p_delivery_detail_id => l_delivery_detail_id
3618: );
3619: END IF;
3620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3621: x_return_status := l_return_status;
3622: raise OTHERS;
3623: END IF;
3624: IF l_debug_on THEN

Line 3632: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3628: ELSE
3629: IF l_debug_on THEN
3630: WSH_DEBUG_SV.log(l_module_name,'Log waring l_delivery_detail_id',l_delivery_detail_id);
3631: END IF;
3632: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3633: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3634: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3635: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3636: END IF;

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

3631: END IF;
3632: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3633: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3634: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3635: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3636: END IF;
3637: END IF;
3638: CLOSE c_check_ignore_for_planning;
3639: END LOOP;

Line 3650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3646: WHEN OTHERS THEN
3647: IF c_check_ignore_for_planning%ISOPEN THEN
3648: CLOSE c_check_ignore_for_planning;
3649: END IF;
3650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3651: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');
3652: --
3653: --
3654: IF l_debug_on THEN

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

3647: IF c_check_ignore_for_planning%ISOPEN THEN
3648: CLOSE c_check_ignore_for_planning;
3649: END IF;
3650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3651: wsh_util_core.default_handler('WSH_TP_RELEASE.Check_Shipset_Ignoreflag');
3652: --
3653: --
3654: IF l_debug_on THEN
3655: 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 3666: p_delivery_detail_ids wsh_util_core.id_tab_type;

3662: p_ignore_for_planning VARCHAR2,
3663: p_logexcep boolean,
3664: x_return_status OUT NOCOPY VARCHAR2) IS
3665:
3666: p_delivery_detail_ids wsh_util_core.id_tab_type;
3667:
3668: BEGIN
3669: p_delivery_detail_ids(0) := p_delivery_detail_id;
3670: Check_Shipset_Ignoreflag( p_delivery_detail_ids=>p_delivery_detail_ids,