[Home] [Help]
1192: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- UnExp Erro
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN -- STS Error
1195: IF l_msg_data is not null THEN -- msg.data not null
1196: fnd_message.set_encoded(l_msg_data);
1197: l_buffer := fnd_message.get;
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_TEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN -- STS Error
1195: IF l_msg_data is not null THEN -- msg.data not null
1196: fnd_message.set_encoded(l_msg_data);
1197: l_buffer := fnd_message.get;
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_TEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
1201: END IF;
2269: END IF;
2270: /* Added code to check for grouping attributes */
2271: IF (l_del_id_for_detail.organization_id <>
2272: l_del_id_for_container.organization_id) THEN
2273: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
2274: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2275: --
2276: IF l_debug_on THEN
2277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2270: /* Added code to check for grouping attributes */
2271: IF (l_del_id_for_detail.organization_id <>
2272: l_del_id_for_container.organization_id) THEN
2273: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
2274: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2275: --
2276: IF l_debug_on THEN
2277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2278: END IF;
2276: IF l_debug_on THEN
2277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2278: END IF;
2279: --
2280: FND_MESSAGE.SET_TOKEN('ENTITY2',
2281: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2282: p_parent_detail_id));
2283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2284: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2290: RETURN;
2291: END IF;
2292: IF (l_del_id_for_detail.ship_from_location_id <>
2293: l_del_id_for_container.ship_from_location_id) THEN
2294: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2295: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2296: --
2297: IF l_debug_on THEN
2298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2291: END IF;
2292: IF (l_del_id_for_detail.ship_from_location_id <>
2293: l_del_id_for_container.ship_from_location_id) THEN
2294: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2295: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2296: --
2297: IF l_debug_on THEN
2298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2299: END IF;
2297: IF l_debug_on THEN
2298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2299: END IF;
2300: --
2301: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2302: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2303: p_parent_detail_id));
2304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2305: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2337: x_return_status => x_return_status);
2338:
2339: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2340:
2341: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2342: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2343: --
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2338:
2339: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2340:
2341: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2342: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2343: --
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2346: END IF;
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2346: END IF;
2347: --
2348: FND_MESSAGE.SET_TOKEN('ENTITY2',
2349: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2350: p_parent_detail_id));
2351: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2352: --
2377: END IF;--}
2378: END IF ; --}
2379:
2380: IF l_display_error THEN --{
2381: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2382: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2383: --
2384: IF l_debug_on THEN
2385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2378: END IF ; --}
2379:
2380: IF l_display_error THEN --{
2381: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2382: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2383: --
2384: IF l_debug_on THEN
2385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2386: END IF;
2384: IF l_debug_on THEN
2385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2386: END IF;
2387: --
2388: FND_MESSAGE.SET_TOKEN('ENTITY2',
2389: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2390: p_parent_detail_id));
2391: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2392: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2418: NULL;
2419: --}
2420: ELSE
2421: --{
2422: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2423: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2424: --
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2419: --}
2420: ELSE
2421: --{
2422: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2423: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2424: --
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2427: END IF;
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2427: END IF;
2428: --
2429: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2430: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2431: p_parent_detail_id));
2432: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2433: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2497: FETCH c_get_plan_flag into l_plan_flag;
2498: CLOSE c_get_plan_flag;
2499:
2500: if l_plan_flag <> 'N' then
2501: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
2502:
2503: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2504:
2505: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2517: FETCH c_get_plan_flag into l_plan_flag;
2518: CLOSE c_get_plan_flag;
2519:
2520: if l_plan_flag <> 'N' then
2521: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
2522:
2523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2524:
2525: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2543: IF l_group_by_flags.customer = 'Y' THEN
2544: IF (NVL(l_del_id_for_detail.customer_id,-1) <>
2545: NVL(l_del_id_for_container.customer_id,-1)) THEN
2546:
2547: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2548: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2549: --
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2544: IF (NVL(l_del_id_for_detail.customer_id,-1) <>
2545: NVL(l_del_id_for_container.customer_id,-1)) THEN
2546:
2547: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2548: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2549: --
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2552: END IF;
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2552: END IF;
2553: --
2554: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2555: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2556: p_parent_detail_id));
2557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2558: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2568: IF (NVL(l_del_id_for_detail.intmed_ship_to_location_id,-1)<>
2569: NVL(l_del_id_for_container.intmed_ship_to_location_id,-1))
2570: THEN
2571:
2572: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2573: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2574: --
2575: IF l_debug_on THEN
2576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2569: NVL(l_del_id_for_container.intmed_ship_to_location_id,-1))
2570: THEN
2571:
2572: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2573: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2574: --
2575: IF l_debug_on THEN
2576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2577: END IF;
2575: IF l_debug_on THEN
2576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2577: END IF;
2578: --
2579: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2580: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2581: p_parent_detail_id));
2582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2583: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2602: IF l_group_by_flags.fob = 'Y' THEN
2603: IF (NVL(l_del_id_for_detail.fob_code,'#')<>
2604: NVL(l_del_id_for_container.fob_code,'#')) THEN
2605:
2606: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2607: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2608: --
2609: IF l_debug_on THEN
2610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2603: IF (NVL(l_del_id_for_detail.fob_code,'#')<>
2604: NVL(l_del_id_for_container.fob_code,'#')) THEN
2605:
2606: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2607: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2608: --
2609: IF l_debug_on THEN
2610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2611: END IF;
2609: IF l_debug_on THEN
2610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2611: END IF;
2612: --
2613: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2614: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2615: p_parent_detail_id));
2616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2617: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2636: IF l_group_by_flags.freight_terms = 'Y' THEN
2637: IF (NVL(l_del_id_for_detail.freight_terms_code,'#')<>
2638: NVL(l_del_id_for_container.freight_terms_code,'#')) THEN
2639:
2640: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2641: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2642: --
2643: IF l_debug_on THEN
2644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2637: IF (NVL(l_del_id_for_detail.freight_terms_code,'#')<>
2638: NVL(l_del_id_for_container.freight_terms_code,'#')) THEN
2639:
2640: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2641: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2642: --
2643: IF l_debug_on THEN
2644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2645: END IF;
2643: IF l_debug_on THEN
2644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2645: END IF;
2646: --
2647: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2648: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2649: p_parent_detail_id));
2650: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2651: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2674: NVL(NVL(l_del_id_for_container.service_level,l_del_id_for_detail.service_level),'#'))
2675: OR (NVL(NVL(l_del_id_for_detail.carrier_id,l_del_id_for_container.carrier_id),-1)<>
2676: NVL(NVL(l_del_id_for_container.carrier_id,l_del_id_for_detail.carrier_id),-1)) THEN
2677:
2678: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2679: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2680: --
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2675: OR (NVL(NVL(l_del_id_for_detail.carrier_id,l_del_id_for_container.carrier_id),-1)<>
2676: NVL(NVL(l_del_id_for_container.carrier_id,l_del_id_for_detail.carrier_id),-1)) THEN
2677:
2678: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2679: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2680: --
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2683: END IF;
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2683: END IF;
2684: --
2685: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2686: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2687: p_parent_detail_id));
2688: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2689: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2710: IF (l_del_id_for_detail.parent_delivery_detail_id IS NOT NULL
2711: AND l_del_id_for_detail.parent_delivery_detail_id <>
2712: p_parent_detail_id
2713: ) THEN
2714: FND_MESSAGE.SET_NAME('WSH','WSH_DET_PACK_ERROR');
2715: FND_MESSAGE.SET_TOKEN('DET_LINE',p_detail_id);
2716: --
2717: IF l_debug_on THEN
2718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2711: AND l_del_id_for_detail.parent_delivery_detail_id <>
2712: p_parent_detail_id
2713: ) THEN
2714: FND_MESSAGE.SET_NAME('WSH','WSH_DET_PACK_ERROR');
2715: FND_MESSAGE.SET_TOKEN('DET_LINE',p_detail_id);
2716: --
2717: IF l_debug_on THEN
2718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2719: END IF;
2717: IF l_debug_on THEN
2718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2719: END IF;
2720: --
2721: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2722: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2723: p_parent_detail_id));
2724: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2725: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2747: /* bug 2677298 frontport from bug 2655474: issue #2:
2748: ** set x_return_status to error if line and container are in different deliveries.
2749: */
2750: IF (l_del_id_for_detail.delivery_id <> l_del_id_for_container.delivery_id) THEN
2751: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_DELIVERIES');
2752: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2748: ** set x_return_status to error if line and container are in different deliveries.
2749: */
2750: IF (l_del_id_for_detail.delivery_id <> l_del_id_for_container.delivery_id) THEN
2751: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_DELIVERIES');
2752: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2756: END IF;
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2756: END IF;
2757: --
2758: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2759: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2760: p_parent_detail_id));
2761: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2762: WSH_UTIL_CORE.Add_Message(x_return_status);
2895: EXCEPTION
2896:
2897: WHEN OTHERS THEN
2898: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2899: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
2900: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR);
2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.log(l_module_name,'Could not lock delivery: ',l_del_id_for_container.delivery_id);
2903: WSH_DEBUG_SV.pop(l_module_name);
3497: RETURN;
3498: -- End of OTM R12 : assign delivery detail
3499:
3500: WHEN mark_reprice_error then
3501: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
3502: x_return_status := l_return_status;
3503: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3504: --
3505: IF l_debug_on THEN
3508: END IF;
3509: --
3510: WHEN invalid_detail then
3511: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3512: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
3513: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
3514: wsh_util_core.add_message(x_return_status,l_module_name);
3515: --
3516: IF l_debug_on THEN
3509: --
3510: WHEN invalid_detail then
3511: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3512: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
3513: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
3514: wsh_util_core.add_message(x_return_status,l_module_name);
3515: --
3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3872: WSH_DEBUG_SV.pop(l_module_name);
3873: END IF;
3874:
3875: WHEN mark_reprice_error THEN
3876: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
3877: x_return_status := l_return_status;
3878: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3879:
3880: --
3884: END IF;
3885: --
3886: WHEN invalid_detail then
3887: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3888: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
3889: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
3890: wsh_util_core.add_message(x_return_status,l_module_name);
3891: --
3892: IF l_debug_on THEN
3885: --
3886: WHEN invalid_detail then
3887: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3888: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
3889: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
3890: wsh_util_core.add_message(x_return_status,l_module_name);
3891: --
3892: IF l_debug_on THEN
3893: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4154: close g_get_detail_info;
4155:
4156: IF l_delivery_id is NOT NULL THEN
4157: IF l_delivery_id <> p_delivery_id THEN
4158: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4159: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_id);
4160: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_id);
4161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4162: wsh_util_core.add_message(x_return_status,l_module_name);
4155:
4156: IF l_delivery_id is NOT NULL THEN
4157: IF l_delivery_id <> p_delivery_id THEN
4158: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4159: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_id);
4160: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_id);
4161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4162: wsh_util_core.add_message(x_return_status,l_module_name);
4163: --
4156: IF l_delivery_id is NOT NULL THEN
4157: IF l_delivery_id <> p_delivery_id THEN
4158: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4159: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_id);
4160: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_id);
4161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4162: wsh_util_core.add_message(x_return_status,l_module_name);
4163: --
4164: IF l_debug_on THEN
4180: -- J-IB-NPARIKH-{
4181: IF x_dlvy_has_lines IS NULL
4182: THEN
4183: --{
4184: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
4185: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'x_dlvy_has_lines');
4186: RAISE FND_API.G_EXC_ERROR;
4187: --}
4188: END IF;
4181: IF x_dlvy_has_lines IS NULL
4182: THEN
4183: --{
4184: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
4185: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'x_dlvy_has_lines');
4186: RAISE FND_API.G_EXC_ERROR;
4187: --}
4188: END IF;
4189: -- J-IB-NPARIKH-}
4214: (l_del.planned_flag IN ('Y','F')))
4215: AND l_del.shipment_direction IN ('O','IO') -- J-IB-NPARIKH
4216: THEN
4217: IF l_del.planned_flag IN ('Y','F') THEN
4218: fnd_message.SET_name('WSH', 'WSH_PLAN_DEL_NOT_UPDATABLE');
4219: ELSE
4220: OPEN get_lookup(l_del.status_code);
4221: FETCH get_lookup INTO l_status;
4222: CLOSE get_lookup;
4219: ELSE
4220: OPEN get_lookup(l_del.status_code);
4221: FETCH get_lookup INTO l_status;
4222: CLOSE get_lookup;
4223: fnd_message.SET_name('WSH', 'WSH_DET_DEL_NOT_UPDATABLE');
4224: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
4225: END IF;
4226: RAISE DEL_NOT_UPDATABLE;
4227: END IF;
4220: OPEN get_lookup(l_del.status_code);
4221: FETCH get_lookup INTO l_status;
4222: CLOSE get_lookup;
4223: fnd_message.SET_name('WSH', 'WSH_DET_DEL_NOT_UPDATABLE');
4224: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
4225: END IF;
4226: RAISE DEL_NOT_UPDATABLE;
4227: END IF;
4228:
4254:
4255: --J TP Release ttrichy
4256: FOR cur in c_getdet_ignore LOOP
4257: IF l_del.ignore_for_planning <> cur.ignore_for_planning THEN
4258: fnd_message.set_name('WSH', 'WSH_DET_DEL_DIFF_IGNOREPLAN');
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4261: END IF;
4262: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4258: fnd_message.set_name('WSH', 'WSH_DET_DEL_DIFF_IGNOREPLAN');
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4261: END IF;
4262: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4263: IF l_debug_on THEN
4264: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4265: END IF;
4266: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4262: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4263: IF l_debug_on THEN
4264: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4265: END IF;
4266: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4267: END IF;
4268: END LOOP;
4269:
4270: OPEN c_all_details_below;
4284: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4285: /* For each detail */
4286: IF (l_dd_id(j) < 0) THEN
4287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4288: fnd_message.SET_name('WSH', 'WSH_DET_DETAIL_NOT_ASSIGNED');
4289: wsh_util_core.add_message(x_return_status,l_module_name);
4290: --
4291: IF l_debug_on THEN
4292: WSH_DEBUG_SV.pop(l_module_name);
4321: END IF;
4322:
4323:
4324: IF ((l_detail.delivery_id IS NOT NULL) AND (l_detail.delivery_id <> p_delivery_id)) THEN
4325: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4326: FND_MESSAGE.SET_TOKEN('DET_NAME',l_detail.delivery_detail_id);
4327: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_detail.delivery_id);
4328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4329: wsh_util_core.add_message(x_return_status,l_module_name);
4322:
4323:
4324: IF ((l_detail.delivery_id IS NOT NULL) AND (l_detail.delivery_id <> p_delivery_id)) THEN
4325: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4326: FND_MESSAGE.SET_TOKEN('DET_NAME',l_detail.delivery_detail_id);
4327: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_detail.delivery_id);
4328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4329: wsh_util_core.add_message(x_return_status,l_module_name);
4330: --
4323:
4324: IF ((l_detail.delivery_id IS NOT NULL) AND (l_detail.delivery_id <> p_delivery_id)) THEN
4325: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4326: FND_MESSAGE.SET_TOKEN('DET_NAME',l_detail.delivery_detail_id);
4327: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_detail.delivery_id);
4328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4329: wsh_util_core.add_message(x_return_status,l_module_name);
4330: --
4331: IF l_debug_on THEN
4461: x_return_status);
4462:
4463: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4465: fnd_message.SET_name('WSH', 'WSH_CONT_ATTR_ERROR');
4466: FND_MESSAGE.SET_TOKEN('DETAIL_ID',l_detail.delivery_detail_id);
4467: wsh_util_core.add_message(x_return_status,l_module_name);
4468: --
4469: IF l_debug_on THEN
4462:
4463: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4465: fnd_message.SET_name('WSH', 'WSH_CONT_ATTR_ERROR');
4466: FND_MESSAGE.SET_TOKEN('DETAIL_ID',l_detail.delivery_detail_id);
4467: wsh_util_core.add_message(x_return_status,l_module_name);
4468: --
4469: IF l_debug_on THEN
4470: WSH_DEBUG_SV.pop(l_module_name);
4850: p_delivery_id,
4851: l_detail.delivery_detail_id,
4852: x_return_status);
4853: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4854: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
4855: --
4856: IF l_debug_on THEN
4857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4858: END IF;
4857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4858: END IF;
4859: --
4860: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_detail.delivery_detail_id);
4861: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4862: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4863: --
4864: IF l_debug_on THEN
4865: WSH_DEBUG_SV.pop(l_module_name);
4989: END IF;
4990: -- J-IB-NPARIKH-}
4991:
4992: WHEN mark_reprice_error THEN
4993: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4994: x_return_status := l_return_status;
4995: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
4996:
4997: --
5000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
5001: END IF;
5002: --
5003: WHEN update_mol_carton_group_error THEN
5004: fnd_message.SET_name('WSH', 'WSH_MOL_CARTON_GROUP_ERROR');
5005: x_return_status := l_return_status;
5006: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5007:
5008: --
5013:
5014:
5015: WHEN INVALID_DEL THEN
5016: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5017: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DEL');
5018: wsh_util_core.add_message(x_return_status,l_module_name);
5019: --
5020: IF l_debug_on THEN
5021: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DEL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5034: --
5035: RETURN;
5036: WHEN INVALID_DETAIL THEN
5037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5038: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DETAIL');
5039: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5040: wsh_util_core.add_message(x_return_status,l_module_name);
5041: --
5042: IF l_debug_on THEN
5035: RETURN;
5036: WHEN INVALID_DETAIL THEN
5037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5038: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DETAIL');
5039: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5040: wsh_util_core.add_message(x_return_status,l_module_name);
5041: --
5042: IF l_debug_on THEN
5043: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5046: --
5047: RETURN;
5048: WHEN DET_CONFIRMED THEN
5049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5050: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
5051: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5052: wsh_util_core.add_message(x_return_status,l_module_name);
5053: --
5054: IF l_debug_on THEN
5047: RETURN;
5048: WHEN DET_CONFIRMED THEN
5049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5050: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
5051: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5052: wsh_util_core.add_message(x_return_status,l_module_name);
5053: --
5054: IF l_debug_on THEN
5055: WSH_DEBUG_SV.logmsg(l_module_name,'DET_CONFIRMED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5058: --
5059: RETURN;
5060: WHEN detail_del_FROM_to_not_same THEN
5061: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5062: fnd_message.SET_name('WSH', 'WSH_DET_SHIP_F_T_N_MATCH');
5063: wsh_util_core.add_message(x_return_status,l_module_name);
5064:
5065:
5066:
5072: --
5073: RETURN;
5074: WHEN ship_method_not_match THEN
5075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5076: fnd_message.SET_name('WSH', 'WSH_DET_SHIP_METHOD_NOT_MATCH');
5077: wsh_util_core.add_message(x_return_status,l_module_name);
5078: --
5079: IF l_debug_on THEN
5080: WSH_DEBUG_SV.logmsg(l_module_name,'SHIP_METHOD_NOT_MATCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5411: IF (l_del_id_for_container1.parent_delivery_detail_id IS NOT NULL
5412: AND l_del_id_for_container1.parent_delivery_detail_id <>
5413: p_detail_id2
5414: ) THEN
5415: FND_MESSAGE.SET_NAME('WSH','WSH_DET_PACK_ERROR');
5416: --
5417: IF l_debug_on THEN
5418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5419: END IF;
5417: IF l_debug_on THEN
5418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5419: END IF;
5420: --
5421: FND_MESSAGE.SET_TOKEN('DET_LINE',
5422: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5423: --
5424: IF l_debug_on THEN
5425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5424: IF l_debug_on THEN
5425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5426: END IF;
5427: --
5428: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5429: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5430: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5431: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5432: --
5474:
5475: IF (check_loop%FOUND) THEN
5476:
5477: CLOSE check_loop;
5478: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOOP_NO_PACK');
5479: --
5480: IF l_debug_on THEN
5481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5482: END IF;
5480: IF l_debug_on THEN
5481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5482: END IF;
5483: --
5484: FND_MESSAGE.SET_TOKEN('DETAIL_CONTAINER',
5485: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5486: --
5487: IF l_debug_on THEN
5488: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5487: IF l_debug_on THEN
5488: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5489: END IF;
5490: --
5491: FND_MESSAGE.SET_TOKEN('PARENT_CONTAINER',
5492: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5494: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5495: --
5505: /* Added code to validate grouping attributes for Child Container and master
5506: Container */
5507: IF (l_del_id_for_container1.organization_id <>
5508: l_del_id_for_container2.organization_id) THEN
5509: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
5510: --
5511: IF l_debug_on THEN
5512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5513: END IF;
5511: IF l_debug_on THEN
5512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5513: END IF;
5514: --
5515: FND_MESSAGE.SET_TOKEN('ENTITY1',
5516: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5517: --
5518: IF l_debug_on THEN
5519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5518: IF l_debug_on THEN
5519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5520: END IF;
5521: --
5522: FND_MESSAGE.SET_TOKEN('ENTITY2',
5523: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5525: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5526: --
5532: END IF;
5533:
5534: IF (l_del_id_for_container1.ship_from_location_id <>
5535: l_del_id_for_container2.ship_from_location_id) THEN
5536: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5537: --
5538: IF l_debug_on THEN
5539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5540: END IF;
5538: IF l_debug_on THEN
5539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5540: END IF;
5541: --
5542: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5543: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5544: --
5545: IF l_debug_on THEN
5546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5545: IF l_debug_on THEN
5546: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5547: END IF;
5548: --
5549: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5550: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5552: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5553: --
5585: x_return_status => x_return_status);
5586:
5587: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5588:
5589: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
5590: FND_MESSAGE.SET_TOKEN('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5591: --
5592: IF l_debug_on THEN
5593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5586:
5587: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5588:
5589: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
5590: FND_MESSAGE.SET_TOKEN('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5591: --
5592: IF l_debug_on THEN
5593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5594: END IF;
5592: IF l_debug_on THEN
5593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5594: END IF;
5595: --
5596: FND_MESSAGE.SET_TOKEN('ENTITY2',nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5597: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5598: --
5599: IF l_debug_on THEN
5600: WSH_DEBUG_SV.pop(l_module_name);
5632: END IF; --}
5633: END IF ; --}
5634:
5635: IF l_display_error THEN --{
5636: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
5637: --
5638: IF l_debug_on THEN
5639: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5640: END IF;
5637: --
5638: IF l_debug_on THEN
5639: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5640: END IF;
5641: FND_MESSAGE.SET_TOKEN('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5642: --
5643: IF l_debug_on THEN
5644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5645: END IF;
5643: IF l_debug_on THEN
5644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5645: END IF;
5646: --
5647: FND_MESSAGE.SET_TOKEN('ENTITY2',nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5648: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5649: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5650: --
5651: IF l_debug_on THEN
5675: NULL;
5676: --}
5677: ELSE
5678: --{
5679: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5680: --
5681: IF l_debug_on THEN
5682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5683: END IF;
5681: IF l_debug_on THEN
5682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5683: END IF;
5684: --
5685: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5686: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5687: --
5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5690: END IF;
5691: --
5692: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5693: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5695: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5696: --
5745: FETCH c_get_plan_flag into l_plan_flag;
5746: CLOSE c_get_plan_flag;
5747:
5748: if l_plan_flag <> 'N' then
5749: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
5750:
5751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5752:
5753: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5765: FETCH c_get_plan_flag into l_plan_flag;
5766: CLOSE c_get_plan_flag;
5767:
5768: if l_plan_flag <> 'N' then
5769: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
5770:
5771: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5772:
5773: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5786:
5787: IF l_group_by_flags.customer = 'Y' THEN
5788: IF (l_del_id_for_container1.customer_id <>
5789: l_del_id_for_container2.customer_id) THEN
5790: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5791: --
5792: IF l_debug_on THEN
5793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5794: END IF;
5792: IF l_debug_on THEN
5793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5794: END IF;
5795: --
5796: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5797: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5798: --
5799: IF l_debug_on THEN
5800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5799: IF l_debug_on THEN
5800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5801: END IF;
5802: --
5803: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5804: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5805: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5806: --
5807: IF l_debug_on THEN
5813: END IF;
5814: IF l_group_by_flags.intmed = 'Y' THEN
5815: IF (l_del_id_for_container1.intmed_ship_to_location_id <>
5816: l_del_id_for_container2.intmed_ship_to_location_id) THEN
5817: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5818: --
5819: IF l_debug_on THEN
5820: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5821: END IF;
5819: IF l_debug_on THEN
5820: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5821: END IF;
5822: --
5823: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5824: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5825: --
5826: IF l_debug_on THEN
5827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5826: IF l_debug_on THEN
5827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5828: END IF;
5829: --
5830: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5831: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5832: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5833: --
5834: IF l_debug_on THEN
5840: END IF;
5841: IF l_group_by_flags.fob = 'Y' THEN
5842: IF (l_del_id_for_container1.fob_code <>
5843: l_del_id_for_container2.fob_code) THEN
5844: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5845: --
5846: IF l_debug_on THEN
5847: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5848: END IF;
5846: IF l_debug_on THEN
5847: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5848: END IF;
5849: --
5850: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5851: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5852: --
5853: IF l_debug_on THEN
5854: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5853: IF l_debug_on THEN
5854: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5855: END IF;
5856: --
5857: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5858: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5859: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5860: --
5861: IF l_debug_on THEN
5867: END IF;
5868: IF l_group_by_flags.freight_terms = 'Y' THEN
5869: IF (l_del_id_for_container1.freight_terms_code <>
5870: l_del_id_for_container2.freight_terms_code) THEN
5871: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5872: --
5873: IF l_debug_on THEN
5874: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5875: END IF;
5873: IF l_debug_on THEN
5874: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5875: END IF;
5876: --
5877: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5878: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5879: --
5880: IF l_debug_on THEN
5881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5880: IF l_debug_on THEN
5881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5882: END IF;
5883: --
5884: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5885: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5886: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5887: --
5888: IF l_debug_on THEN
5899: NVL(l_del_id_for_container2.service_level, l_del_id_for_container1.service_level))
5900: OR (NVL(l_del_id_for_container1.carrier_id, l_del_id_for_container2.carrier_id) <>
5901: NVL(l_del_id_for_container2.carrier_id, l_del_id_for_container1.carrier_id))
5902: THEN
5903: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5904: --
5905: IF l_debug_on THEN
5906: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5907: END IF;
5905: IF l_debug_on THEN
5906: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5907: END IF;
5908: --
5909: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5910: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5911: --
5912: IF l_debug_on THEN
5913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5912: IF l_debug_on THEN
5913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5914: END IF;
5915: --
5916: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5917: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5918: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5919: --
5920: IF l_debug_on THEN
6405: exception
6406: WHEN others THEN
6407: rollback to before_cont_assignment;
6408: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6409: fnd_message.SET_name('WSH', 'WSH_CONT_LOOP_NO_PACK');
6410: fnd_message.set_token('DETAIL_CONTAINER', detail_cont_name);
6411: fnd_message.set_token('PARENT_CONTAINER', parent_cont_name);
6412: wsh_util_core.add_message(x_return_status,l_module_name);
6413: --
6406: WHEN others THEN
6407: rollback to before_cont_assignment;
6408: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6409: fnd_message.SET_name('WSH', 'WSH_CONT_LOOP_NO_PACK');
6410: fnd_message.set_token('DETAIL_CONTAINER', detail_cont_name);
6411: fnd_message.set_token('PARENT_CONTAINER', parent_cont_name);
6412: wsh_util_core.add_message(x_return_status,l_module_name);
6413: --
6414: IF l_debug_on THEN
6407: rollback to before_cont_assignment;
6408: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6409: fnd_message.SET_name('WSH', 'WSH_CONT_LOOP_NO_PACK');
6410: fnd_message.set_token('DETAIL_CONTAINER', detail_cont_name);
6411: fnd_message.set_token('PARENT_CONTAINER', parent_cont_name);
6412: wsh_util_core.add_message(x_return_status,l_module_name);
6413: --
6414: IF l_debug_on THEN
6415: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected Error has occured. Oracle Err Mesg is'||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6471: RETURN;
6472: -- End of OTM R12 : assign delivery detail
6473:
6474: WHEN mark_reprice_error THEN
6475: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
6476: x_return_status := l_return_status;
6477: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6478: --
6479: IF l_debug_on THEN
6800: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE WSH_UTIL_CORE.C_IB_ASN_PREFIX || '%' -- J-IB-NPARIKH
6801: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE WSH_UTIL_CORE.C_IB_RECEIPT_PREFIX || '%' -- J-IB-NPARIKH
6802: THEN
6803: IF l_del1.planned_flag IN ('Y','F') THEN
6804: fnd_message.SET_name('WSH', 'WSH_DET_UNASSIGN_FIRMDEL');
6805: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del1.name);
6806: ELSE
6807: OPEN get_lookup(l_del1.status_code);
6808: FETCH get_lookup INTO l_status;
6801: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE WSH_UTIL_CORE.C_IB_RECEIPT_PREFIX || '%' -- J-IB-NPARIKH
6802: THEN
6803: IF l_del1.planned_flag IN ('Y','F') THEN
6804: fnd_message.SET_name('WSH', 'WSH_DET_UNASSIGN_FIRMDEL');
6805: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del1.name);
6806: ELSE
6807: OPEN get_lookup(l_del1.status_code);
6808: FETCH get_lookup INTO l_status;
6809: CLOSE get_lookup;
6806: ELSE
6807: OPEN get_lookup(l_del1.status_code);
6808: FETCH get_lookup INTO l_status;
6809: CLOSE get_lookup;
6810: fnd_message.SET_name('WSH',
6811: 'WSH_DET_DEL_NOT_UPDATABLE');
6812: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
6813: END IF;
6814: RAISE DEL_NOT_UPDATABLE;
6808: FETCH get_lookup INTO l_status;
6809: CLOSE get_lookup;
6810: fnd_message.SET_name('WSH',
6811: 'WSH_DET_DEL_NOT_UPDATABLE');
6812: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
6813: END IF;
6814: RAISE DEL_NOT_UPDATABLE;
6815: END IF;
6816:
7455: --
7456: EXCEPTION
7457: WHEN mark_reprice_error THEN
7458: x_return_status := l_return_status;
7459: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
7460: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
7461: ROLLBACK TO before_unassign;
7462: --
7463: IF l_debug_on THEN
7466: END IF;
7467: --
7468: WHEN detail_not_assigned THEN
7469: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7470: fnd_message.set_name('WSH', 'WSH_DET_DETAIL_NOT_ASSIGNED');
7471: wsh_util_core.add_message(x_return_status,l_module_name);
7472: ROLLBACK TO before_unassign;
7473: --
7474: IF l_debug_on THEN
7486: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DEL_NOT_UPDATABLE');
7487: END IF;
7488: --
7489: WHEN update_mol_carton_group_error THEN
7490: fnd_message.SET_name('WSH', 'WSH_MOL_CARTON_GROUP_ERROR');
7491: x_return_status := l_return_status;
7492: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
7493:
7494: --
7521: WSH_DEBUG_SV.logmsg(l_module_name,'Remove_FTE_Freight_Costs failed.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7522: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REMOVE_FC_ERROR');
7523: END IF;
7524: --
7525: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
7526: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
7527: ROLLBACK TO before_unassign;
7528:
7529: WHEN get_shipping_param_err THEN
7527: ROLLBACK TO before_unassign;
7528:
7529: WHEN get_shipping_param_err THEN
7530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7531: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
7532: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
7533: wsh_util_core.get_org_name(l_assign.organization_id));
7534: wsh_util_core.add_message(x_return_status,l_module_name);
7535: ROLLBACK TO before_unassign;
7528:
7529: WHEN get_shipping_param_err THEN
7530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7531: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
7532: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
7533: wsh_util_core.get_org_name(l_assign.organization_id));
7534: wsh_util_core.add_message(x_return_status,l_module_name);
7535: ROLLBACK TO before_unassign;
7536: --
7540: END IF;
7541:
7542: WHEN adjust_parent_wv_err THEN
7543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7544: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
7545: FND_MESSAGE.SET_TOKEN('CONT_NAME',WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_assign.parent_delivery_detail_id));
7546: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7547:
7548: ROLLBACK TO before_unassign;
7541:
7542: WHEN adjust_parent_wv_err THEN
7543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7544: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
7545: FND_MESSAGE.SET_TOKEN('CONT_NAME',WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_assign.parent_delivery_detail_id));
7546: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7547:
7548: ROLLBACK TO before_unassign;
7549: --
7745:
7746: IF (c_multi_assign_rec%NOTFOUND) THEN
7747: l_num_warnings := l_num_warnings + 1;
7748: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7749: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7750: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7751: wsh_util_core.add_message(x_return_status,l_module_name);
7752: /* go ahead and process the next line */
7753: CLOSE c_multi_assign_rec;
7746: IF (c_multi_assign_rec%NOTFOUND) THEN
7747: l_num_warnings := l_num_warnings + 1;
7748: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7749: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7750: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7751: wsh_util_core.add_message(x_return_status,l_module_name);
7752: /* go ahead and process the next line */
7753: CLOSE c_multi_assign_rec;
7754: GOTO start_over_1;
7757:
7758: IF (l_multi_assign_rec.delivery_id IS null) THEN
7759: l_num_warnings := l_num_warnings + 1;
7760: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7761: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7762: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7763: wsh_util_core.add_message(x_return_status,l_module_name);
7764: /* go ahead and process the next line */
7765: GOTO start_over_1;
7758: IF (l_multi_assign_rec.delivery_id IS null) THEN
7759: l_num_warnings := l_num_warnings + 1;
7760: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7761: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7762: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7763: wsh_util_core.add_message(x_return_status,l_module_name);
7764: /* go ahead and process the next line */
7765: GOTO start_over_1;
7766: END IF;
7977: l_multi_assign_rec.delivery_id);
7978: END IF;
7979: IF (c_multi_assign_rec%NOTFOUND) THEN
7980: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7981: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7982: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7983: wsh_util_core.add_message(x_return_status,l_module_name);
7984: /* go ahead and process the next line */
7985: CLOSE c_multi_assign_rec;
7978: END IF;
7979: IF (c_multi_assign_rec%NOTFOUND) THEN
7980: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7981: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7982: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7983: wsh_util_core.add_message(x_return_status,l_module_name);
7984: /* go ahead and process the next line */
7985: CLOSE c_multi_assign_rec;
7986: GOTO start_over_2;
7988: CLOSE c_multi_assign_rec;
7989:
7990: /* Bug 2166715 - check if line was actually packed or not */
7991: IF l_multi_assign_rec.parent_delivery_detail_id IS NULL THEN l_num_warnings := l_num_warnings + 1;
7992: fnd_message.SET_name('WSH','WSH_CONT_UNASSG_NULL');
7993: wsh_util_core.add_message(x_return_status,l_module_name);
7994: END IF;
7995:
7996: Unassign_detail_FROM_cont(
8577: --
8578: exception
8579: WHEN mark_reprice_error THEN
8580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8581: fnd_message.SET_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
8582: wsh_util_core.add_message(x_return_status,l_module_name);
8583:
8584: --
8585: IF l_debug_on THEN
8588: END IF;
8589: --
8590: WHEN delivery_id_locked THEN
8591: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8592: fnd_message.SET_name('WSH', 'WSH_NO_LOCK');
8593: wsh_util_core.add_message(x_return_status,l_module_name);
8594: --
8595: IF l_debug_on THEN
8596: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Id Locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8973: --
8974: EXCEPTION
8975: WHEN chk_decimal_qty_failed THEN
8976: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8977: fnd_message.set_name('WSH', 'WSH_DET_DECIMAL_QTY_NOT_VALID');
8978: wsh_util_core.add_message(x_return_status,l_module_name);
8979: --
8980: IF l_debug_on THEN
8981: WSH_DEBUG_SV.logmsg(l_module_name,'CHK_DECIMAL_QTY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8983: END IF;
8984: --
8985: WHEN quantity_over THEN
8986: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8987: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
8988: wsh_util_core.add_message(x_return_status,l_module_name);
8989: --
8990: IF l_debug_on THEN
8991: WSH_DEBUG_SV.logmsg(l_module_name,'QUANTITY_OVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8993: END IF;
8994: --
8995: WHEN zero_qty THEN
8996: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8997: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
8998: wsh_util_core.add_message(x_return_status,l_module_name);
8999: --
9000: IF l_debug_on THEN
9001: WSH_DEBUG_SV.logmsg(l_module_name,'ZERO_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9003: END IF;
9004: --
9005: WHEN negative_qty THEN
9006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9007: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
9008: wsh_util_core.add_message(x_return_status,l_module_name);
9009: --
9010: IF l_debug_on THEN
9011: WSH_DEBUG_SV.logmsg(l_module_name,'NEGATIVE_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9013: END IF;
9014: --
9015: WHEN reprice_required_err THEN
9016: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9017: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
9018: wsh_util_core.add_message(x_return_status,l_module_name);
9019: --
9020: IF l_debug_on THEN
9021: WSH_DEBUG_SV.logmsg(l_module_name,'REPRICE_REQUIRED_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9842:
9843: WHEN old_det_wt_vol_failed THEN
9844: rollback to split_savepoint;
9845: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9846: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
9847: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
9848: wsh_util_core.add_message(x_return_status,l_module_name);
9849: --
9850: IF l_debug_on THEN
9843: WHEN old_det_wt_vol_failed THEN
9844: rollback to split_savepoint;
9845: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9846: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
9847: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
9848: wsh_util_core.add_message(x_return_status,l_module_name);
9849: --
9850: IF l_debug_on THEN
9851: WSH_DEBUG_SV.logmsg(l_module_name,'OLD_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9854: --
9855: WHEN new_det_wt_vol_failed THEN
9856: rollback to split_savepoint;
9857: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9858: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
9859: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
9860: wsh_util_core.add_message(x_return_status,l_module_name);
9861: --
9862: IF l_debug_on THEN
9855: WHEN new_det_wt_vol_failed THEN
9856: rollback to split_savepoint;
9857: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9858: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
9859: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
9860: wsh_util_core.add_message(x_return_status,l_module_name);
9861: --
9862: IF l_debug_on THEN
9863: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9866: --
9867: WHEN WSH_SPLIT_ERROR THEN
9868: rollback to split_savepoint;
9869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9870: fnd_message.set_name('WSH', 'WSH_SPLIT_ERROR');
9871: fnd_message.set_token('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
9872: wsh_util_core.add_message(x_return_status,l_module_name);
9873: --
9874: IF l_debug_on THEN
9867: WHEN WSH_SPLIT_ERROR THEN
9868: rollback to split_savepoint;
9869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9870: fnd_message.set_name('WSH', 'WSH_SPLIT_ERROR');
9871: fnd_message.set_token('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
9872: wsh_util_core.add_message(x_return_status,l_module_name);
9873: --
9874: IF l_debug_on THEN
9875: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SPLIT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9877: END IF;
9878: WHEN WSH_SN_SPLIT_ERR THEN
9879: rollback to split_savepoint;
9880: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9881: fnd_message.set_name('WSH', 'WSH_SN_SPLIT_ERR');
9882: wsh_util_core.add_message(x_return_status,l_module_name);
9883: --
9884: IF l_debug_on THEN
9885: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SN_SPLIT_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9891: CLOSE c_get_req_pick_qty;
9892: END IF;
9893: rollback to split_savepoint;
9894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9895: fnd_message.set_name('WSH', 'WSH_NO_DATA_FOUND');
9896: IF l_debug_on THEN
9897: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9898: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_DATA_FOUND');
9899: END IF;
10196: --
10197: EXCEPTION
10198: WHEN chk_decimal_qty_failed THEN
10199: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10200: fnd_message.set_name('WSH', 'WSH_DET_DECIMAL_QTY_NOT_VALID');
10201: wsh_util_core.add_message(x_return_status,l_module_name);
10202: --
10203: IF l_debug_on THEN
10204: WSH_DEBUG_SV.logmsg(l_module_name,'CHK_DECIMAL_QTY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10206: END IF;
10207: --
10208: WHEN quantity_over THEN
10209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10210: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
10211: wsh_util_core.add_message(x_return_status,l_module_name);
10212: --
10213: IF l_debug_on THEN
10214: WSH_DEBUG_SV.logmsg(l_module_name,'QUANTITY_OVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10216: END IF;
10217: --
10218: WHEN zero_qty THEN
10219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10220: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
10221: wsh_util_core.add_message(x_return_status,l_module_name);
10222: --
10223: IF l_debug_on THEN
10224: WSH_DEBUG_SV.logmsg(l_module_name,'ZERO_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10226: END IF;
10227: --
10228: WHEN negative_qty THEN
10229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10230: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
10231: wsh_util_core.add_message(x_return_status,l_module_name);
10232: --
10233: IF l_debug_on THEN
10234: WSH_DEBUG_SV.logmsg(l_module_name,'NEGATIVE_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10236: END IF;
10237: --
10238: WHEN reprice_required_err THEN
10239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10240: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
10241: wsh_util_core.add_message(x_return_status,l_module_name);
10242: --
10243: IF l_debug_on THEN
10244: WSH_DEBUG_SV.logmsg(l_module_name,'REPRICE_REQUIRED_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11004: -- HW OPMCONV. Removed OPM exception
11005:
11006: WHEN old_det_wt_vol_failed THEN
11007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11008: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11009: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
11010: wsh_util_core.add_message(x_return_status,l_module_name);
11011: --
11012: IF l_debug_on THEN
11005:
11006: WHEN old_det_wt_vol_failed THEN
11007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11008: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11009: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
11010: wsh_util_core.add_message(x_return_status,l_module_name);
11011: --
11012: IF l_debug_on THEN
11013: WSH_DEBUG_SV.logmsg(l_module_name,'OLD_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11015: END IF;
11016: --
11017: WHEN new_det_wt_vol_failed THEN
11018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11019: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11020: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
11021: wsh_util_core.add_message(x_return_status,l_module_name);
11022: --
11023: IF l_debug_on THEN
11016: --
11017: WHEN new_det_wt_vol_failed THEN
11018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11019: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11020: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
11021: wsh_util_core.add_message(x_return_status,l_module_name);
11022: --
11023: IF l_debug_on THEN
11024: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11026: END IF;
11027: --
11028: WHEN WSH_SN_SPLIT_ERR THEN
11029: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11030: fnd_message.set_name('WSH', 'WSH_SN_SPLIT_ERR');
11031: wsh_util_core.add_message(x_return_status,l_module_name);
11032: --
11033: IF l_debug_on THEN
11034: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SN_SPLIT_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11422: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11423: END IF;
11424:
11425: IF l_success < 0 THEN
11426: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11427: FND_MESSAGE.SET_TOKEN('FM_SERIAL',l_new_sn);
11428: FND_MESSAGE.SET_TOKEN('TO_SERIAL',l_new_to_sn);
11429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11430: WSH_UTIL_CORE.Add_Message(x_return_status);
11423: END IF;
11424:
11425: IF l_success < 0 THEN
11426: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11427: FND_MESSAGE.SET_TOKEN('FM_SERIAL',l_new_sn);
11428: FND_MESSAGE.SET_TOKEN('TO_SERIAL',l_new_to_sn);
11429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11430: WSH_UTIL_CORE.Add_Message(x_return_status);
11431: END IF;
11424:
11425: IF l_success < 0 THEN
11426: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11427: FND_MESSAGE.SET_TOKEN('FM_SERIAL',l_new_sn);
11428: FND_MESSAGE.SET_TOKEN('TO_SERIAL',l_new_to_sn);
11429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11430: WSH_UTIL_CORE.Add_Message(x_return_status);
11431: END IF;
11432: -- bug 2740681
11498: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11499: END IF;
11500:
11501: IF l_success < 0 THEN
11502: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11503: FND_MESSAGE.SET_TOKEN('FM_SERIAL', c.fm_serial_number);
11504: FND_MESSAGE.SET_TOKEN('TO_SERIAL', c.to_serial_number);
11505: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11506: WSH_UTIL_CORE.Add_Message(x_return_status);
11499: END IF;
11500:
11501: IF l_success < 0 THEN
11502: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11503: FND_MESSAGE.SET_TOKEN('FM_SERIAL', c.fm_serial_number);
11504: FND_MESSAGE.SET_TOKEN('TO_SERIAL', c.to_serial_number);
11505: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11506: WSH_UTIL_CORE.Add_Message(x_return_status);
11507: END IF;
11500:
11501: IF l_success < 0 THEN
11502: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11503: FND_MESSAGE.SET_TOKEN('FM_SERIAL', c.fm_serial_number);
11504: FND_MESSAGE.SET_TOKEN('TO_SERIAL', c.to_serial_number);
11505: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11506: WSH_UTIL_CORE.Add_Message(x_return_status);
11507: END IF;
11508: --bug 2740681
11707: END IF;
11708: --
11709: -- Check if the Parent Container is empty, if yes, recursivelly call this API
11710: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
11711: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
11712: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
11713: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
11714: x_return_status := l_return_status;
11715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
11708: --
11709: -- Check if the Parent Container is empty, if yes, recursivelly call this API
11710: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
11711: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
11712: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
11713: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
11714: x_return_status := l_return_status;
11715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
11716: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
11709: -- Check if the Parent Container is empty, if yes, recursivelly call this API
11710: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
11711: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
11712: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
11713: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
11714: x_return_status := l_return_status;
11715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
11716: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
11717: --