503: END IF;
504: EXCEPTION
505: WHEN wsh_incorrect_org THEN
506: x_return_status := wsh_util_core.g_ret_sts_error;
507: FND_MESSAGE.Set_Name('WSH', 'WSH_INCORRECT_ORG');
508: FND_MESSAGE.Set_Token('ORG_CODE', l_org_code);
509: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_incorrect_org exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
504: EXCEPTION
505: WHEN wsh_incorrect_org THEN
506: x_return_status := wsh_util_core.g_ret_sts_error;
507: FND_MESSAGE.Set_Name('WSH', 'WSH_INCORRECT_ORG');
508: FND_MESSAGE.Set_Token('ORG_CODE', l_org_code);
509: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_incorrect_org exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_incorrect_org');
512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_incorrect_org');
513: END IF;
514: WHEN wsh_invalid_delivery THEN
515: x_return_status := wsh_util_core.g_ret_sts_error;
516: FND_MESSAGE.Set_Name('WSH', 'WSH_INCOMPLETE_DELIVERY');
517: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
518: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
519: IF l_debug_on THEN
520: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: END IF;
514: WHEN wsh_invalid_delivery THEN
515: x_return_status := wsh_util_core.g_ret_sts_error;
516: FND_MESSAGE.Set_Name('WSH', 'WSH_INCOMPLETE_DELIVERY');
517: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
518: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
519: IF l_debug_on THEN
520: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
521: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery');
521: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery');
522: END IF;
523: WHEN wsh_details_not_packed THEN
524: x_return_status := wsh_util_core.g_ret_sts_error;
525: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_PACK_ITEMS_UNPACKED');
526: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
527: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_not_packed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
522: END IF;
523: WHEN wsh_details_not_packed THEN
524: x_return_status := wsh_util_core.g_ret_sts_error;
525: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_PACK_ITEMS_UNPACKED');
526: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
527: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_not_packed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_not_packed');
530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_not_packed');
531: END IF;
532: WHEN wsh_tpw_del_det_rel_stat THEN
533: x_return_status := wsh_util_core.g_ret_sts_error;
534: FND_MESSAGE.Set_Name('WSH', 'WSH_TPW_DEL_DET_REL_STAT');
535: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
536: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_tpw_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
531: END IF;
532: WHEN wsh_tpw_del_det_rel_stat THEN
533: x_return_status := wsh_util_core.g_ret_sts_error;
534: FND_MESSAGE.Set_Name('WSH', 'WSH_TPW_DEL_DET_REL_STAT');
535: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
536: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_tpw_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_tpw_del_det_rel_stat');
539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_tpw_del_det_rel_stat');
540: END IF;
541: WHEN wsh_cms_del_det_rel_stat THEN
542: x_return_status := wsh_util_core.g_ret_sts_error;
543: FND_MESSAGE.Set_Name('WSH', 'WSH_CMS_DEL_DET_REL_STAT');
544: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
545: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cms_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
540: END IF;
541: WHEN wsh_cms_del_det_rel_stat THEN
542: x_return_status := wsh_util_core.g_ret_sts_error;
543: FND_MESSAGE.Set_Name('WSH', 'WSH_CMS_DEL_DET_REL_STAT');
544: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
545: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cms_del_det_rel_stat exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cms_del_det_rel_stat');
590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
591: END IF;
592: WHEN wsh_delivery_locked THEN
593: x_return_status := wsh_util_core.g_ret_sts_error;
594: FND_MESSAGE.Set_Name('WSH', 'WSH_DELIVERY_LOCKED');
595: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
596: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_delivery_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
591: END IF;
592: WHEN wsh_delivery_locked THEN
593: x_return_status := wsh_util_core.g_ret_sts_error;
594: FND_MESSAGE.Set_Name('WSH', 'WSH_DELIVERY_LOCKED');
595: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
596: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_delivery_locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_delivery_locked');
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_delivery_locked');
600: END IF;
601: WHEN wsh_cancel_disallowed THEN
602: x_return_status := wsh_util_core.g_ret_sts_error;
603: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_DISALLOWED');
604: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
605: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cancel_disallowed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
600: END IF;
601: WHEN wsh_cancel_disallowed THEN
602: x_return_status := wsh_util_core.g_ret_sts_error;
603: FND_MESSAGE.Set_Name('WSH', 'WSH_CANCEL_DISALLOWED');
604: FND_MESSAGE.Set_Token('DEL_NAME', l_entity_number);
605: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cancel_disallowed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cancel_disallowed');
607: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_cancel_disallowed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cancel_disallowed');
609: END IF;
610: WHEN wsh_del_assign_to_trip THEN
611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_OUTBOUND_FAILED_TRIP');
612: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
614: wsh_util_core.add_message(x_return_status,l_module_name);
615: IF l_debug_on THEN
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cancel_disallowed');
609: END IF;
610: WHEN wsh_del_assign_to_trip THEN
611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_OUTBOUND_FAILED_TRIP');
612: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
614: wsh_util_core.add_message(x_return_status,l_module_name);
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_assign_to_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
616: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_assign_to_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
617: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_assign_to_trip');
618: END IF;
619: WHEN wsh_details_exceptions THEN
620: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_DET');
621: FND_MESSAGE.SET_TOKEN('DEL_DET_ID', to_char(l_delivery_detail_id));
622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
623: wsh_util_core.add_message(x_return_status,l_module_name);
624: IF l_debug_on THEN
617: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_assign_to_trip');
618: END IF;
619: WHEN wsh_details_exceptions THEN
620: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_DET');
621: FND_MESSAGE.SET_TOKEN('DEL_DET_ID', to_char(l_delivery_detail_id));
622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
623: wsh_util_core.add_message(x_return_status,l_module_name);
624: IF l_debug_on THEN
625: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_exceptions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
625: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_exceptions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
626: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_exceptions');
627: END IF;
628: WHEN wsh_details_credit_hold THEN
629: FND_MESSAGE.SET_NAME('WSH','WSH_SR_CREDIT_HOLD_ERR');
630: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_entity_number);
631: FND_MESSAGE.SET_TOKEN('DET_NAME',to_char(l_delivery_detail_id));
632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
633: wsh_util_core.add_message(x_return_status,l_module_name);
626: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_exceptions');
627: END IF;
628: WHEN wsh_details_credit_hold THEN
629: FND_MESSAGE.SET_NAME('WSH','WSH_SR_CREDIT_HOLD_ERR');
630: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_entity_number);
631: FND_MESSAGE.SET_TOKEN('DET_NAME',to_char(l_delivery_detail_id));
632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
633: wsh_util_core.add_message(x_return_status,l_module_name);
634: IF l_debug_on THEN
627: END IF;
628: WHEN wsh_details_credit_hold THEN
629: FND_MESSAGE.SET_NAME('WSH','WSH_SR_CREDIT_HOLD_ERR');
630: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_entity_number);
631: FND_MESSAGE.SET_TOKEN('DET_NAME',to_char(l_delivery_detail_id));
632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
633: wsh_util_core.add_message(x_return_status,l_module_name);
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_credit_hold exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
635: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_details_credit_hold exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_credit_hold ');
637: END IF;
638: WHEN wsh_invalid_customer THEN
639: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CUST_DEF_ERROR');
640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: wsh_util_core.add_message(x_return_status,l_module_name);
643: IF l_debug_on THEN
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_credit_hold ');
637: END IF;
638: WHEN wsh_invalid_customer THEN
639: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CUST_DEF_ERROR');
640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: wsh_util_core.add_message(x_return_status,l_module_name);
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_customer exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1621: IF c_del_status%NOTFOUND THEN
1622: IF l_debug_on THEN
1623: wsh_debug_sv.logmsg(l_module_name, 'ERROR Invalid delivery');
1624: END IF;
1625: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
1626: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1627: CLOSE c_del_status;
1628: RAISE fnd_api.g_exc_error;
1629: END IF;
2113:
2114: OPEN c_get_del_status (l_entity_number);
2115: FETCH c_get_del_status INTO l_status;
2116: IF c_get_del_status%NOTFOUND THEN
2117: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
2118: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
2119: CLOSE c_get_del_status;
2120: RAISE e_send_false;
2121: END IF;