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_USA_CATEGORIES_PVT dependencies on WSH_UTIL_CORE

Line 244: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

240: EXCEPTION
241:
242: WHEN OTHERS THEN
243: -- close open cursors as needed
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
245: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Log_Exception',l_module_name);
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 245: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Log_Exception',l_module_name);

241:
242: WHEN OTHERS THEN
243: -- close open cursors as needed
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
245: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Log_Exception',l_module_name);
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
249: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 284: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

280: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
281: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
282: END IF;
283: --
284: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
285:
286: IF g_cache_detail_rec.cache_flag = 'Y'
287: AND g_cache_detail_rec.source_line_id = p_source_line_id
288: AND g_cache_detail_rec.source_code = p_source_code

Line 310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

306: FETCH c_cache_attributes_2 INTO g_cache_detail_rec;
307: IF c_cache_attributes_2%NOTFOUND THEN
308: CLOSE c_cache_attributes_2;
309: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DATA_FOUND');
310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
312: --
313: IF l_debug_on THEN
314: WSH_DEBUG_SV.pop(l_module_name,'WSH_NO_DATA_FOUND');

Line 311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

307: IF c_cache_attributes_2%NOTFOUND THEN
308: CLOSE c_cache_attributes_2;
309: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DATA_FOUND');
310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
312: --
313: IF l_debug_on THEN
314: WSH_DEBUG_SV.pop(l_module_name,'WSH_NO_DATA_FOUND');
315: END IF;

Line 357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

353: END IF;
354: IF c_cache_attributes_2%ISOPEN THEN
355: CLOSE c_cache_attributes_2;
356: END IF;
357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
358: --
359: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Cache_Changed_Attributes',l_module_name);
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 359: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Cache_Changed_Attributes',l_module_name);

355: CLOSE c_cache_attributes_2;
356: END IF;
357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
358: --
359: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Cache_Changed_Attributes',l_module_name);
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
362: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
363: END IF;

Line 416: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

412: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
413: WSH_DEBUG_SV.log(l_module_name,'g_cache_wms_org_id',g_cache_wms_org_id);
414: END IF;
415: --
416: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
417: x_wms_flag := 'N';
418:
419: IF g_cache_wms_org_id = p_organization_id THEN
420: x_wms_flag := g_cache_wms_flag;

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

435: x_msg_count => l_msg_count,
436: x_msg_data => l_msg_data,
437: p_organization_id => p_organization_id);
438:
439: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
440: --
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR IN CHECK_WMS' );
443: END IF;

Line 462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

458: END IF;
459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_WMS',l_module_name);
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 463: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_WMS',l_module_name);

459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_WMS',l_module_name);
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
467: END IF;

Line 483: l_rs VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

479: IS
480: update_not_allowed EXCEPTION;
481: others EXCEPTION;
482:
483: l_rs VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
484: l_update_allowed VARCHAR2(1) := 'Y';
485: l_wms_flag VARCHAR2(1);
486: -- HW OPM for OM changes
487: -- HW OPMCONV. Removed OPM variables

Line 518: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

514: Cache_Changed_Attributes(p_source_line_id => p_attributes_rec.source_line_id,
515: p_source_code => p_source_code,
516: p_delivery_detail_id => p_attributes_rec.delivery_detail_id,
517: x_return_status => l_rs);
518: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
519: IF l_debug_on THEN
520: WSH_DEBUG_SV.log(l_module_name,'Cache_Changed_Attributes returns Error');
521: END IF;
522: RAISE update_not_allowed;

Line 533: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

529: Check_WMS(
530: p_organization_id => g_cache_detail_rec.organization_id,
531: x_wms_flag => l_wms_flag,
532: x_return_status => l_rs);
533: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
534: RAISE others;
535: END IF;
536:
537: WSH_USA_CATEGORIES_PVT.Change_Schedule(

Line 544: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

540: p_wms_flag => l_wms_flag,
541: x_update_allowed => l_update_allowed,
542: x_return_status => l_rs);
543: IF (l_update_allowed = 'N')
544: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
545: RAISE update_not_allowed;
546: END IF;
547: WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date(
548: p_attributes_rec => p_attributes_rec,

Line 554: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

550: p_wms_flag => l_wms_flag,
551: x_update_allowed => l_update_allowed,
552: x_return_status => l_rs);
553: IF (l_update_allowed = 'N')
554: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.log(l_module_name,'Change_Scheduled_Date returned Error');
557: END IF;
558: RAISE update_not_allowed;

Line 570: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

566: p_wms_flag => l_wms_flag,
567: x_update_allowed => l_update_allowed,
568: x_return_status => l_rs);
569: IF (l_update_allowed = 'N')
570: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
571: RAISE update_not_allowed;
572: END IF;
573:
574: WSH_USA_CATEGORIES_PVT.Change_Delivery_Group(

Line 581: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

577: p_wms_flag => l_wms_flag,
578: x_update_allowed => l_update_allowed,
579: x_return_status => l_rs);
580: IF (l_update_allowed = 'N')
581: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
582: RAISE update_not_allowed;
583: END IF;
584:
585: -- Bug 2181132 for overship tolerance

Line 593: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

589: p_wms_flag => l_wms_flag,
590: x_update_allowed => l_update_allowed,
591: x_return_status => l_rs);
592: IF (l_update_allowed = 'N')
593: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
594: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
595: RAISE update_not_allowed;
596: END IF;
597:

Line 594: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

590: x_update_allowed => l_update_allowed,
591: x_return_status => l_rs);
592: IF (l_update_allowed = 'N')
593: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
594: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
595: RAISE update_not_allowed;
596: END IF;
597:
598: IF (p_attributes_rec.action_flag <> 'S') THEN

Line 608: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

604: x_update_allowed => l_update_allowed,
605: x_return_status => l_rs);
606: END IF; -- action_flag <> 'S'
607: IF (l_update_allowed = 'N')
608: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
609: RAISE update_not_allowed;
610: END IF;
611: WSH_USA_CATEGORIES_PVT.Change_TP_DATES(
612: p_attributes_rec => p_attributes_rec,

Line 618: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

614: x_changed_detail => x_changed_detail,
615: x_update_allowed => l_update_allowed,
616: x_return_status => l_rs);
617: IF(l_update_allowed = 'N')
618: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
619: RAISE update_not_allowed;
620: END IF;
621: x_return_status := l_rs;
622: x_update_allowed := l_update_allowed;

Line 642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

638: END IF;
639: --
640: RETURN;
641: WHEN OTHERS THEN
642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
643: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_Categories',l_module_name);
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 643: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_Categories',l_module_name);

639: --
640: RETURN;
641: WHEN OTHERS THEN
642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
643: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_Categories',l_module_name);
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 666: l_in_id wsh_util_core.id_tab_type;

662: update_not_allowed EXCEPTION;
663:
664: l_datetype VARCHAR2(20);
665:
666: l_in_id wsh_util_core.id_tab_type;
667:
668: l_earliest_pickup_date DATE;
669: l_latest_pickup_date DATE;
670: l_earliest_dropoff_date DATE;

Line 731: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

727: x_latest_pickup_date => l_latest_pickup_date,
728: x_earliest_dropoff_date => l_earliest_dropoff_date,
729: x_latest_dropoff_date => l_latest_dropoff_date
730: );
731: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
732: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_TP_DATES',
733: txt=>'Error in calculating TP dates: Date Type : '||l_datetype
734: ||'Latest Acceptable Date : '||p_attributes_rec.latest_acceptable_date
735: ||'Promise Date : '||p_attributes_rec.promise_date

Line 781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

777: EXCEPTION
778:
779: WHEN OTHERS THEN
780: -- close open cursors as needed
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
782: x_update_allowed := 'N';
783: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_TP_DATES',l_module_name);
784: --
785: IF l_debug_on THEN

Line 783: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_TP_DATES',l_module_name);

779: WHEN OTHERS THEN
780: -- close open cursors as needed
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
782: x_update_allowed := 'N';
783: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_TP_DATES',l_module_name);
784: --
785: IF l_debug_on THEN
786: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
787: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 867: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

863: --
864: RETURN;
865: WHEN OTHERS THEN
866: -- close open cursors as needed
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
868: x_update_allowed := 'N';
869: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Quantity',l_module_name);
870: --
871: IF l_debug_on THEN

Line 869: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Quantity',l_module_name);

865: WHEN OTHERS THEN
866: -- close open cursors as needed
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
868: x_update_allowed := 'N';
869: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Quantity',l_module_name);
870: --
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 992: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines

988: l_return_status VARCHAR2(30);
989: -- bug fix 2095105
990:
991: --wrudge
992: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines
993:
994: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
995: l_dbi_rs VARCHAR2(1); -- DBI Project
996:

Line 994: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

990:
991: --wrudge
992: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines
993:
994: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
995: l_dbi_rs VARCHAR2(1); -- DBI Project
996:
997: /* H projects: pricing integration csun */
998: i NUMBER := 0;

Line 999: l_del_tab WSH_UTIL_CORE.Id_Tab_Type ; -- to mark reprice required flag

995: l_dbi_rs VARCHAR2(1); -- DBI Project
996:
997: /* H projects: pricing integration csun */
998: i NUMBER := 0;
999: l_del_tab WSH_UTIL_CORE.Id_Tab_Type ; -- to mark reprice required flag
1000: mark_reprice_error EXCEPTION;
1001: -- deliveryMerge
1002: Adjust_Planned_Flag_Err EXCEPTION;
1003: l_num_warning NUMBER := 0;

Line 1028: l_del_planned_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1024: l_new_weight NUMBER;
1025: l_new_volume NUMBER;
1026: l_weight_uom_code VARCHAR2(3);
1027: l_volume_uom_code VARCHAR2(3);
1028: l_del_planned_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1029: l_otm_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1030: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1031: l_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1032: l_item_rec c_specific_item_info%ROWTYPE;

Line 1029: l_otm_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1025: l_new_volume NUMBER;
1026: l_weight_uom_code VARCHAR2(3);
1027: l_volume_uom_code VARCHAR2(3);
1028: l_del_planned_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1029: l_otm_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1030: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1031: l_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1032: l_item_rec c_specific_item_info%ROWTYPE;
1033: l_final_org_id NUMBER;

Line 1030: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1026: l_weight_uom_code VARCHAR2(3);
1027: l_volume_uom_code VARCHAR2(3);
1028: l_del_planned_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1029: l_otm_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1030: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1031: l_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1032: l_item_rec c_specific_item_info%ROWTYPE;
1033: l_final_org_id NUMBER;
1034: l_ordered_quantity NUMBER;

Line 1031: l_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1027: l_volume_uom_code VARCHAR2(3);
1028: l_del_planned_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1029: l_otm_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1030: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1031: l_tms_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1032: l_item_rec c_specific_item_info%ROWTYPE;
1033: l_final_org_id NUMBER;
1034: l_ordered_quantity NUMBER;
1035: l_ordered_quantity_uom VARCHAR2(5);

Line 1134: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1130: --2.Check if detail is associated to OPM org - if so, do not allow update of item.
1131: --check for old org.
1132: IF INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => g_cache_detail_rec.organization_id) THEN
1133: --{
1134: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name, 'Item Update is not allowed as it is associated to OPM organization.');
1137: END IF;
1138: RAISE item_update_not_allowed;

Line 1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1144: --{
1145: l_final_org_id:= p_attributes_rec.ship_from_org_id;
1146: IF INV_GMI_RSV_BRANCH.Process_Branch(p_organization_id => l_final_org_id) THEN
1147: --{
1148: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1149: IF l_debug_on THEN
1150: WSH_DEBUG_SV.logmsg(l_module_name, 'Item Update is not allowed as it is associated to OPM organization.');
1151: END IF;
1152: RAISE item_update_not_allowed;

Line 1166: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1162: OPEN c_det_status;
1163: FETCH c_det_status INTO x_update_allowed;
1164: IF c_det_status%FOUND THEN
1165: CLOSE c_det_status;
1166: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1167: IF l_debug_on THEN
1168: WSH_DEBUG_SV.logmsg(l_module_name, 'Item Update is not allowed as there are Detail(s) that are already Pick Released ');
1169: END IF;
1170: RAISE item_update_not_allowed;

Line 1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1175: OPEN c_packed_det;
1176: FETCH c_packed_det INTO x_update_allowed;
1177: IF c_packed_det%FOUND THEN
1178: CLOSE c_packed_det;
1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1180: IF l_debug_on THEN
1181: WSH_DEBUG_SV.logmsg(l_module_name, 'Item Update is not allowed as there are Detail(s) that are packed into Containers ');
1182: END IF;
1183: RAISE item_update_not_allowed;

Line 1192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1188: OPEN c_del_status;
1189: FETCH c_del_status INTO l_del_status,l_export_screening_flag;
1190: IF c_del_status%FOUND THEN
1191: CLOSE c_del_status;
1192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1193: IF l_debug_on THEN
1194: IF ( l_del_status in ('SA','SR') ) THEN
1195: WSH_DEBUG_SV.logmsg(l_module_name, 'Update is not allowed as there is a Delivery that belongs to tpw/carrier manifesting Organization with status '||l_del_status);
1196: END IF;

Line 1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1210: --7. Check if the primary UOM of the new Item is different than the primary UOM of old Item - if so
1211: -- do not allow update of item.
1212: IF (g_cache_detail_rec.requested_quantity_uom <> l_item_rec.primary_uom_code ) THEN
1213: --{
1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.logmsg(l_module_name, 'Update is not allowed as there is a difference in primary UOM for old and new item');
1217: END IF;
1218: RAISE item_update_not_allowed;

Line 1248: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1244: g_cache_detail_rec.inventory_item_id);
1245:
1246: IF NVL(l_new_tot_requested_quantity, 0) <> nvl(l_old_tot_requested_quantity,0) THEN
1247: --{
1248: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name, 'Update is not allowed as there is a difference in UOM conversions for old and new item');
1251: END IF;
1252: RAISE item_update_not_allowed;

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

1276: x_param_info => l_shipping_param_info,
1277: x_return_status => x_return_status
1278: );
1279:
1280: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1281: --{
1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1283: IF l_debug_on THEN
1284: WSH_DEBUG_SV.logmsg(l_module_name, 'Update is not allowed as there are no shipping parameters defined for the org: '||l_final_org_id);

Line 1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1278: );
1279:
1280: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1281: --{
1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1283: IF l_debug_on THEN
1284: WSH_DEBUG_SV.logmsg(l_module_name, 'Update is not allowed as there are no shipping parameters defined for the org: '||l_final_org_id);
1285: END IF;
1286: RAISE item_update_not_allowed;

Line 1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1342: IF l_debug_on THEN
1343: WSH_DEBUG_SV.log(l_module_name,'l_status is set to Y');
1344: END IF;
1345: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1347: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1348: RAISE update_not_allowed;
1349: exit; -- exit loop if action breaks WMS.
1350: -- how does it come to exit,when we raise update_not_allowed?

Line 1347: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

1343: WSH_DEBUG_SV.log(l_module_name,'l_status is set to Y');
1344: END IF;
1345: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1347: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1348: RAISE update_not_allowed;
1349: exit; -- exit loop if action breaks WMS.
1350: -- how does it come to exit,when we raise update_not_allowed?
1351: END IF;

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

1434: x_msg_count => l_msg_count,
1435: x_msg_data => l_msg_data
1436: );
1437:
1438: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1439: IF l_debug_on THEN
1440: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line returned error');
1441: END IF;
1442: RAISE update_not_allowed;

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

1455: p_detail_id => l_del_det,
1456: p_validate_flag => 'N',
1457: x_return_status => x_return_status);
1458:
1459: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1460:
1461: RAISE update_not_allowed;
1462:
1463: END IF;

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

1469: p_entity_name => 'WSH_DELIVERY',
1470: p_entity_id => l_delivery,
1471: x_return_status => x_return_status);
1472:
1473: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1474:
1475: RAISE update_not_allowed;
1476:
1477: END IF;

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

1483: p_detail_id => l_del_det,
1484: p_validate_flag => 'N',
1485: x_return_status => x_return_status);
1486:
1487: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1488:
1489: RAISE update_not_allowed;
1490:
1491: END IF;

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

1497: p_entity_name => 'WSH_CONTAINER',
1498: p_entity_id => l_parent_det,
1499: x_return_status => x_return_status);
1500:
1501: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1502:
1503: RAISE update_not_allowed;
1504:
1505: END IF;

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

1517: p_subinventory => l_subinventory,
1518: x_inv_controls_rec => l_inv_controls,
1519: x_return_status => x_return_status);
1520:
1521: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1522:
1523: RAISE update_not_allowed;
1524:
1525: END IF;

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

1529: p_serial_number => l_serial_number,
1530: p_transaction_temp_id => l_trx_temp_id,
1531: x_return_status => x_return_status);
1532:
1533: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1534:
1535: RAISE update_not_allowed;
1536:
1537: END IF;

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

1562: p_unreserve_mode => 'UNRESERVE',
1563: x_return_status => l_return_status
1564: );
1565:
1566: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1567: RAISE update_not_allowed;
1568: END IF;
1569: END IF;
1570: --} Subinventory specific code.

Line 1588: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1584: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL(
1585: p_delivery_detail_id => l_del_det,
1586: p_primary_quantity => 0, --- WMS will delete the records from WMS table.
1587: x_return_status => x_return_status);
1588: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1589: --{
1590: IF l_debug_on THEN
1591: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
1592: WSH_DEBUG_SV.pop(l_module_name);

Line 1621: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1617: p_diff_net_wt => -1 * l_net_weight,
1618: p_diff_volume => -1 * l_volume,
1619: p_diff_fill_volume => -1 * l_volume,
1620: x_return_status => l_return_status);
1621: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1622: x_return_status := l_return_status;
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.log(l_module_name,'Return Status after DD_WV_Post_Process',x_return_status);
1625: END IF;

Line 1702: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1698: p_diff_net_wt => l_new_weight,
1699: p_diff_volume => l_new_volume,
1700: p_diff_fill_volume => l_new_volume,
1701: x_return_status => l_return_status);
1702: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1703: x_return_status := l_return_status;
1704: IF l_debug_on THEN
1705: WSH_DEBUG_SV.log(l_module_name,'Return Status after DD_WV_Post_Process',x_return_status);
1706: END IF;

Line 1735: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1731:
1732: IF l_debug_on THEN
1733: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
1734: END IF;
1735: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1736: x_return_status := l_dbi_rs;
1737: Rollback to before_changes;
1738: -- just pass this return status to caller API
1739: IF l_debug_on THEN

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

1754: p_details_id => l_delete_dds,
1755: x_return_status => x_return_status
1756: );
1757:
1758: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1759: RAISE update_not_allowed;
1760: END IF;
1761: END IF;
1762: --brana

Line 1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,

1768: --Intialize the message and location id
1769: IF ( l_del_planned_tab.count > 0) THEN
1770: --{
1771: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUBSTITUTED');
1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,
1773: l_final_org_id));
1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,
1775: l_final_org_id));
1776: l_msg := FND_MESSAGE.GET;

Line 1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,

1770: --{
1771: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUBSTITUTED');
1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,
1773: l_final_org_id));
1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,
1775: l_final_org_id));
1776: l_msg := FND_MESSAGE.GET;
1777: l_exception_location_id := l_location_id;
1778: --}

Line 1827: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1823: WSH_NEW_DELIVERIES_PVT.Update_TMS_Interface_Flag
1824: (p_delivery_id_tab => l_delivery_id_tab,
1825: p_tms_interface_flag_tab => l_tms_interface_flag_tab,
1826: x_return_status => l_return_status);
1827: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1828: x_return_status := l_return_status;
1829: IF l_debug_on THEN
1830: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_NEW_DELIVERIES_PVT.Update_Tms_interface_flag',l_return_status);
1831: END IF;

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

1853: x_mtl_reservation_tbl => l_resv_tbl,
1854: x_mtl_reservation_tbl_count => l_count,
1855: x_return_status => x_return_status);
1856:
1857: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1858: RAISE update_not_allowed;
1859: END IF;
1860:
1861: --END IF;

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

1893: WSH_USA_INV_PVT.delete_reservation (
1894: p_query_input => l_resv_tbl(i),
1895: x_return_status => x_return_status);
1896:
1897: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1898:
1899: RAISE update_not_allowed;
1900:
1901: END IF;

Line 2026: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2022: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2023: p_entity_type => 'DELIVERY',
2024: p_entity_ids => l_del_tab,
2025: x_return_status => l_return_status);
2026: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2027: raise mark_reprice_error;
2028: END IF;
2029:
2030: -- deliveryMerge

Line 2045: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2041: IF l_debug_on THEN
2042: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag l_return_status',l_return_status);
2043: END IF;
2044:
2045: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2046: raise Adjust_Planned_Flag_Err;
2047: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2048: l_num_warning := l_num_warning + 1;
2049: END IF;

Line 2047: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2043: END IF;
2044:
2045: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2046: raise Adjust_Planned_Flag_Err;
2047: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2048: l_num_warning := l_num_warning + 1;
2049: END IF;
2050:
2051: END IF;

Line 2055: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2051: END IF;
2052:
2053: END IF;
2054: IF l_num_warning > 0 THEN
2055: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2056: ELSE
2057: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2058: END IF;
2059: --

Line 2057: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2053: END IF;
2054: IF l_num_warning > 0 THEN
2055: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2056: ELSE
2057: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2058: END IF;
2059: --
2060: IF l_debug_on THEN
2061: WSH_DEBUG_SV.pop(l_module_name);

Line 2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));

2067: x_update_allowed := 'N';
2068: --
2069: -- For item change case, enter both item names.
2070: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUB_NOT_ALLOWED');
2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));
2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));
2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));

2068: --
2069: -- For item change case, enter both item names.
2070: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUB_NOT_ALLOWED');
2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));
2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));
2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');

Line 2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

2069: -- For item change case, enter both item names.
2070: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUB_NOT_ALLOWED');
2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));
2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));
2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');
2077: END IF;

Line 2091: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

2087: --
2088: WHEN mark_reprice_error THEN
2089: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2090: x_return_status := l_return_status;
2091: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2092: IF l_debug_on THEN
2093: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
2095: END IF;

Line 2099: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);

2095: END IF;
2096: --
2097: WHEN Adjust_Planned_Flag_Err THEN
2098: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
2099: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
2100: x_return_status := l_return_status;
2101:
2102: IF l_debug_on THEN
2103: WSH_DEBUG_SV.logmsg(l_module_name,'Adjust_Planned_Flag_Err exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2110: END IF;
2111:
2112: -- close open cursors as needed
2113: --ROLLBACK TO before_changes;
2114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2115: x_update_allowed := 'N';
2116: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Schedule',l_module_name);
2117: --
2118: IF l_debug_on THEN

Line 2116: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Schedule',l_module_name);

2112: -- close open cursors as needed
2113: --ROLLBACK TO before_changes;
2114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2115: x_update_allowed := 'N';
2116: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Schedule',l_module_name);
2117: --
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2147: l_det_tab WSH_UTIL_CORE.Id_Tab_Type ; -- to mark reprice required flag

2143: update_not_allowed EXCEPTION;
2144:
2145: /* H integration: Pricing integration csun */
2146: i NUMBER := 0;
2147: l_det_tab WSH_UTIL_CORE.Id_Tab_Type ; -- to mark reprice required flag
2148: l_return_status VARCHAR2(1);
2149: mark_reprice_error EXCEPTION;
2150:
2151:

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

2201: p_location_id => l_location_id,
2202: p_exception_name => 'WSH_CHANGE_SCHED_DATE',
2203: x_return_status => x_return_status);
2204:
2205: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2206:
2207: RAISE update_not_allowed;
2208:
2209: END IF;

Line 2221: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2217: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
2218: p_entity_type => 'DELIVERY_DETAIL',
2219: p_entity_ids => l_det_tab,
2220: x_return_status => l_return_status);
2221: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2222: raise mark_reprice_error;
2223: END IF;
2224: END IF;
2225: END IF;

Line 2245: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

2241: RETURN;
2242: WHEN mark_reprice_error THEN
2243: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2244: x_return_status := l_return_status;
2245: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2246: --
2247: IF l_debug_on THEN
2248: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2249: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');

Line 2257: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2253: -- close open cursors as needed
2254: IF c_delivery_detail%ISOPEN THEN
2255: close c_delivery_detail;
2256: END IF;
2257: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2258: x_update_allowed := 'N';
2259: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date',l_module_name);
2260: --
2261: IF l_debug_on THEN

Line 2259: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date',l_module_name);

2255: close c_delivery_detail;
2256: END IF;
2257: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2258: x_update_allowed := 'N';
2259: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date',l_module_name);
2260: --
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2263: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2354: x_param_info => g_param_info,
2355: x_return_status => x_return_status
2356: );
2357:
2358: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2359: RAISE update_not_allowed;
2360: END IF;
2361:
2362: END IF;

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

2433: p_trolin_tbl => l_trolin_tbl,
2434: p_trolin_old_tbl => l_trolin_old_tbl,
2435: x_trolin_tbl => l_trolin_out_tbl);
2436:
2437: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2438: IF l_debug_on THEN
2439: WSH_DEBUG_SV.log(l_module_name,'Process_Move_Order_Line returns ERROR');
2440: END IF;
2441: RAISE update_not_allowed;

Line 2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2460: --
2461: EXCEPTION
2462:
2463: WHEN update_not_allowed THEN
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2465: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2466: x_update_allowed := 'N';
2467: --
2468: IF l_debug_on THEN

Line 2465: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

2461: EXCEPTION
2462:
2463: WHEN update_not_allowed THEN
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2465: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2466: x_update_allowed := 'N';
2467: --
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2474: -- close open cursors as needed
2475: IF c_get_released_status%isopen THEN
2476: close c_get_released_status;
2477: END IF;
2478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2479: x_update_allowed := 'N';
2480: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Sets',l_module_name);
2481: --
2482: IF l_debug_on THEN

Line 2480: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Sets',l_module_name);

2476: close c_get_released_status;
2477: END IF;
2478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2479: x_update_allowed := 'N';
2480: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Sets',l_module_name);
2481: --
2482: IF l_debug_on THEN
2483: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2519: l_matched_entities wsh_util_core.id_tab_type;

2515: l_attr_tab Wsh_delivery_autocreate.grp_attr_tab_type;
2516: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
2517: l_action_rec wsh_delivery_autocreate.action_rec_type;
2518: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2519: l_matched_entities wsh_util_core.id_tab_type;
2520: l_out_rec wsh_delivery_autocreate.out_rec_type;
2521: l_generic_flag varchar2(1);
2522: l_sm_changed_flag varchar2(1) := 'N';
2523:

Line 2563: l_delivery_ids wsh_util_core.id_tab_type;

2559: l_parent_container NUMBER;
2560:
2561: l_msg_count NUMBER;
2562: l_msg_data VARCHAR2(4000);
2563: l_delivery_ids wsh_util_core.id_tab_type;
2564:
2565:
2566: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2567: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;

Line 2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2593: WSH_DEBUG_SV.log(l_module_name,'P_WMS_FLAG',P_WMS_FLAG);
2594: WSH_DEBUG_SV.log(l_module_name,'X_UPDATE_ALLOWED',X_UPDATE_ALLOWED);
2595: END IF;
2596: --
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2598: IF p_attributes_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
2599: l_attr_tab(1).organization_id := g_cache_detail_rec.organization_id;
2600: l_attr_tab(1).ship_from_location_id := g_cache_detail_rec.organization_id;
2601: ELSE

Line 2626: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE',

2622:
2623: l_intmed_ship_to_location_id := g_cache_detail_rec.intmed_ship_to_location_id;
2624:
2625: ELSIF (p_attributes_rec.intmed_ship_to_org_id IS NOT NULL) THEN
2626: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE',
2627: p_attributes_rec.intmed_ship_to_org_id,
2628: l_intmed_ship_to_location_id,
2629: x_return_status);
2630: /* Bug Fix 2852545 passed x_return_status instead of l_return_status to api_post_call */

Line 2631: wsh_util_core.api_post_call(p_return_status =>x_return_status,

2627: p_attributes_rec.intmed_ship_to_org_id,
2628: l_intmed_ship_to_location_id,
2629: x_return_status);
2630: /* Bug Fix 2852545 passed x_return_status instead of l_return_status to api_post_call */
2631: wsh_util_core.api_post_call(p_return_status =>x_return_status,
2632: x_num_warnings =>l_num_warning,
2633: x_num_errors =>l_num_errors);
2634:
2635: END IF;

Line 2746: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2742: x_out_rec => l_out_rec,
2743: x_return_status => x_return_status);
2744:
2745:
2746: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2747:
2748: l_mandatory_flag := 'N';
2749:
2750: ELSIF l_out_rec.single_group = 'N' THEN

Line 2801: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2797: WSH_DEBUG_SV.logmsg(l_module_name, 'carrier_id: '||l_group_tab(l_group_tab.first).carrier_id );
2798: WSH_DEBUG_SV.logmsg(l_module_name, 'ship_method_code: '||l_group_tab(l_group_tab.first).carrier_id );
2799: END IF;
2800:
2801: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2802:
2803: l_mandatory_flag := 'N';
2804:
2805: ELSIF l_out_rec.single_group = 'N' THEN

Line 2826: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

2822:
2823: IF dd.released_status = 'Y' THEN
2824:
2825: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
2826: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2827: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2828: RAISE update_not_allowed;
2829:
2830: END IF;

Line 2827: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2823: IF dd.released_status = 'Y' THEN
2824:
2825: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
2826: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2827: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2828: RAISE update_not_allowed;
2829:
2830: END IF;
2831:

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

2844: p_detail_id => dd.delivery_detail_id,
2845: p_validate_flag => 'N',
2846: x_return_status => x_return_status);
2847:
2848: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2849:
2850: RAISE update_not_allowed;
2851:
2852: END IF;

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

2858: p_entity_name => 'WSH_DELIVERY',
2859: p_entity_id => dd.delivery_id,
2860: x_return_status => x_return_status);
2861:
2862: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2863:
2864: RAISE update_not_allowed;
2865:
2866: END IF;

Line 2878: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2874: p_call_lcss => 'Y',
2875: p_event => NULL,
2876: x_return_status => l_return_status);
2877:
2878: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE update_not_allowed;
2880: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2881: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2882: ELSE

Line 2880: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2876: x_return_status => l_return_status);
2877:
2878: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE update_not_allowed;
2880: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2881: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2882: ELSE
2883: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2884: END IF;

Line 2881: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2877:
2878: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE update_not_allowed;
2880: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2881: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2882: ELSE
2883: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2884: END IF;
2885:

Line 2883: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2879: RAISE update_not_allowed;
2880: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2881: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2882: ELSE
2883: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2884: END IF;
2885:
2886:
2887: END IF;

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

2892: p_detail_id => dd.delivery_detail_id,
2893: p_validate_flag => 'N',
2894: x_return_status => x_return_status);
2895:
2896: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2897:
2898: RAISE update_not_allowed;
2899:
2900: END IF;

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

2906: p_entity_name => 'WSH_CONTAINER',
2907: p_entity_id => dd.parent_delivery_detail_id,
2908: x_return_status => x_return_status);
2909:
2910: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2911:
2912: RAISE update_not_allowed;
2913:
2914: END IF;

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

2932: p_delivery_id => dd.delivery_id,
2933: x_delivery_rec => l_delivery_info_tab(1),
2934: x_return_status => x_return_status);
2935:
2936: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2937: RAISE update_not_allowed;
2938: END IF;
2939:
2940:

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

2969: x_msg_data => l_msg_data);
2970:
2971:
2972:
2973: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2974: RAISE update_not_allowed;
2975: END IF;
2976:
2977: END IF;

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

2989: p_entity_name => 'WSH_CONTAINER',
2990: p_entity_id => dd.parent_delivery_detail_id,
2991: x_return_status => x_return_status);
2992:
2993: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2994:
2995: RAISE update_not_allowed;
2996:
2997: END IF;

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

3018: p_delivery_detail_id => dd.parent_delivery_detail_id,
3019: x_delivery_detail_rec => l_detail_info_tab(1),
3020: x_return_status => x_return_status);
3021:
3022: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3023: RAISE update_not_allowed;
3024: END IF;
3025:
3026: IF l_group_tab(l_group_index).service_level IS NOT NULL THEN

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

3053: p_detail_info_tab => l_detail_info_tab,
3054: p_IN_rec => l_detail_in_rec,
3055: x_OUT_rec => l_detail_out_rec);
3056:
3057: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3058: RAISE update_not_allowed;
3059: END IF;
3060:
3061: -- The GRP API does not cascade the changes upwards.

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

3074: p_delivery_id => NULL,
3075: p_container_instance_id => l_parent_container,
3076: x_return_status => x_return_status);
3077:
3078: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3079: RAISE update_not_allowed;
3080: END IF;
3081:
3082: END IF;

Line 3104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3100: EXCEPTION
3101:
3102: WHEN update_not_allowed THEN
3103: x_update_allowed := 'N';
3104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3105: --
3106: IF l_debug_on THEN
3107: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');

Line 3113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3109: END IF;
3110: --
3111: RETURN;
3112: WHEN FND_API.G_EXC_ERROR THEN
3113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3114: IF l_debug_on THEN
3115: wsh_debug_sv.logmsg(l_module_name,'G_EXC_ERROR');
3116: WSH_DEBUG_SV.pop(l_module_name);
3117: END IF;

Line 3119: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3115: wsh_debug_sv.logmsg(l_module_name,'G_EXC_ERROR');
3116: WSH_DEBUG_SV.pop(l_module_name);
3117: END IF;
3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3119: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3120: IF l_debug_on THEN
3121: wsh_debug_sv.logmsg(l_module_name,'G_EXC_UNEXPECTED_ERROR');
3122: WSH_DEBUG_SV.pop(l_module_name);
3123: END IF;

Line 3132: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3128: END IF;
3129: IF c_get_parent_container%ISOPEN THEN
3130: CLOSE c_get_parent_container;
3131: END IF;
3132: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3133: x_update_allowed := 'N';
3134: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Delivery_Group',l_module_name);
3135: --
3136: IF l_debug_on THEN

Line 3134: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Delivery_Group',l_module_name);

3130: CLOSE c_get_parent_container;
3131: END IF;
3132: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3133: x_update_allowed := 'N';
3134: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Delivery_Group',l_module_name);
3135: --
3136: IF l_debug_on THEN
3137: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3138: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3238: CLOSE c_get_released_status;
3239:
3240: IF l_delivery_detail_id IS NOT NULL THEN
3241: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_TOL_NOT_ALLOWED');
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3243: WSH_UTIL_CORE.Add_Message(x_return_status);
3244: RAISE update_not_allowed;
3245: END IF;
3246:

Line 3243: WSH_UTIL_CORE.Add_Message(x_return_status);

3239:
3240: IF l_delivery_detail_id IS NOT NULL THEN
3241: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_TOL_NOT_ALLOWED');
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3243: WSH_UTIL_CORE.Add_Message(x_return_status);
3244: RAISE update_not_allowed;
3245: END IF;
3246:
3247: END IF;

Line 3250: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3246:
3247: END IF;
3248:
3249: x_update_allowed := 'Y';
3250: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3251:
3252: IF l_debug_on THEN
3253: WSH_DEBUG_SV.log(l_module_name,'Update Allowed'||x_update_allowed);
3254: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3255: END IF;
3256:
3257: EXCEPTION
3258: WHEN update_not_allowed THEN
3259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3260: x_update_allowed := 'N';
3261:
3262: IF l_debug_on THEN
3263: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3266: RETURN;
3267:
3268: WHEN OTHERS THEN
3269: -- close open cursors as needed
3270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3271: x_update_allowed := 'N';
3272: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance',l_module_name);
3273: --
3274: IF l_debug_on THEN

Line 3272: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance',l_module_name);

3268: WHEN OTHERS THEN
3269: -- close open cursors as needed
3270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3271: x_update_allowed := 'N';
3272: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance',l_module_name);
3273: --
3274: IF l_debug_on THEN
3275: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');