[Home] [Help]
1278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN -- UnExp Erro
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN -- STS Error
1281: IF l_msg_data is not null THEN -- msg.data not null
1282: fnd_message.set_encoded(l_msg_data);
1283: l_buffer := fnd_message.get;
1284: --
1285: IF l_debug_on THEN
1286: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_TEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN -- STS Error
1281: IF l_msg_data is not null THEN -- msg.data not null
1282: fnd_message.set_encoded(l_msg_data);
1283: l_buffer := fnd_message.get;
1284: --
1285: IF l_debug_on THEN
1286: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit OE_MSG_PUB.ADD_TEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
1287: END IF;
2375: END IF;
2376: /* Added code to check for grouping attributes */
2377: IF (l_del_id_for_detail.organization_id <>
2378: l_del_id_for_container.organization_id) THEN
2379: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
2380: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2381: --
2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2376: /* Added code to check for grouping attributes */
2377: IF (l_del_id_for_detail.organization_id <>
2378: l_del_id_for_container.organization_id) THEN
2379: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
2380: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2381: --
2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2384: END IF;
2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2384: END IF;
2385: --
2386: FND_MESSAGE.SET_TOKEN('ENTITY2',
2387: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2388: p_parent_detail_id));
2389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2390: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2396: RETURN;
2397: END IF;
2398: IF (l_del_id_for_detail.ship_from_location_id <>
2399: l_del_id_for_container.ship_from_location_id) THEN
2400: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2401: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2402: --
2403: IF l_debug_on THEN
2404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2397: END IF;
2398: IF (l_del_id_for_detail.ship_from_location_id <>
2399: l_del_id_for_container.ship_from_location_id) THEN
2400: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2401: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2402: --
2403: IF l_debug_on THEN
2404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2405: END IF;
2403: IF l_debug_on THEN
2404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2405: END IF;
2406: --
2407: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2408: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2409: p_parent_detail_id));
2410: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2411: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2443: x_return_status => x_return_status);
2444:
2445: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2446:
2447: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2448: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2449: --
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2444:
2445: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2446:
2447: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2448: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2449: --
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2453: --
2454: FND_MESSAGE.SET_TOKEN('ENTITY2',
2455: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2456: p_parent_detail_id));
2457: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2458: --
2483: END IF;--}
2484: END IF ; --}
2485:
2486: IF l_display_error THEN --{
2487: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2488: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2489: --
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2484: END IF ; --}
2485:
2486: IF l_display_error THEN --{
2487: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
2488: FND_MESSAGE.SET_TOKEN('ENTITY1',p_detail_id);
2489: --
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2492: END IF;
2490: IF l_debug_on THEN
2491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2492: END IF;
2493: --
2494: FND_MESSAGE.SET_TOKEN('ENTITY2',
2495: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2496: p_parent_detail_id));
2497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2498: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2524: NULL;
2525: --}
2526: ELSE
2527: --{
2528: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2529: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2530: --
2531: IF l_debug_on THEN
2532: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2525: --}
2526: ELSE
2527: --{
2528: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2529: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2530: --
2531: IF l_debug_on THEN
2532: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2533: END IF;
2531: IF l_debug_on THEN
2532: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2533: END IF;
2534: --
2535: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2536: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2537: p_parent_detail_id));
2538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2539: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2604: FETCH c_get_plan_flag into l_plan_flag;
2605: CLOSE c_get_plan_flag;
2606:
2607: if l_plan_flag <> 'N' then
2608: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
2609:
2610: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2611:
2612: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2624: FETCH c_get_plan_flag into l_plan_flag;
2625: CLOSE c_get_plan_flag;
2626:
2627: if l_plan_flag <> 'N' then
2628: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
2629:
2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2631:
2632: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2653: OR (NVL(l_del_id_for_detail.consignee_flag,'C') <> --RTV changes
2654: NVL(l_del_id_for_container.consignee_flag,'C'))
2655: ) THEN
2656:
2657: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2658: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2654: NVL(l_del_id_for_container.consignee_flag,'C'))
2655: ) THEN
2656:
2657: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2658: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2662: END IF;
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2662: END IF;
2663: --
2664: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2665: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2666: p_parent_detail_id));
2667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2668: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2678: IF (NVL(l_del_id_for_detail.intmed_ship_to_location_id,-1)<>
2679: NVL(l_del_id_for_container.intmed_ship_to_location_id,-1))
2680: THEN
2681:
2682: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2683: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2684: --
2685: IF l_debug_on THEN
2686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2679: NVL(l_del_id_for_container.intmed_ship_to_location_id,-1))
2680: THEN
2681:
2682: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2683: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2684: --
2685: IF l_debug_on THEN
2686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2687: END IF;
2685: IF l_debug_on THEN
2686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2687: END IF;
2688: --
2689: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2690: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2691: p_parent_detail_id));
2692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2693: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2712: IF l_group_by_flags.fob = 'Y' THEN
2713: IF (NVL(l_del_id_for_detail.fob_code,'#')<>
2714: NVL(l_del_id_for_container.fob_code,'#')) THEN
2715:
2716: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2717: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2718: --
2719: IF l_debug_on THEN
2720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2713: IF (NVL(l_del_id_for_detail.fob_code,'#')<>
2714: NVL(l_del_id_for_container.fob_code,'#')) THEN
2715:
2716: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2717: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2718: --
2719: IF l_debug_on THEN
2720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2721: END IF;
2719: IF l_debug_on THEN
2720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2721: END IF;
2722: --
2723: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2724: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2725: p_parent_detail_id));
2726: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2727: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2746: IF l_group_by_flags.freight_terms = 'Y' THEN
2747: IF (NVL(l_del_id_for_detail.freight_terms_code,'#')<>
2748: NVL(l_del_id_for_container.freight_terms_code,'#')) THEN
2749:
2750: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2751: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2752: --
2753: IF l_debug_on THEN
2754: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2747: IF (NVL(l_del_id_for_detail.freight_terms_code,'#')<>
2748: NVL(l_del_id_for_container.freight_terms_code,'#')) THEN
2749:
2750: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2751: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2752: --
2753: IF l_debug_on THEN
2754: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2755: END IF;
2753: IF l_debug_on THEN
2754: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2755: END IF;
2756: --
2757: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2758: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2759: p_parent_detail_id));
2760: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2761: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2784: NVL(NVL(l_del_id_for_container.service_level,l_del_id_for_detail.service_level),'#'))
2785: OR (NVL(NVL(l_del_id_for_detail.carrier_id,l_del_id_for_container.carrier_id),-1)<>
2786: NVL(NVL(l_del_id_for_container.carrier_id,l_del_id_for_detail.carrier_id),-1)) THEN
2787:
2788: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2789: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2790: --
2791: IF l_debug_on THEN
2792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2785: OR (NVL(NVL(l_del_id_for_detail.carrier_id,l_del_id_for_container.carrier_id),-1)<>
2786: NVL(NVL(l_del_id_for_container.carrier_id,l_del_id_for_detail.carrier_id),-1)) THEN
2787:
2788: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2789: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2790: --
2791: IF l_debug_on THEN
2792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2793: END IF;
2791: IF l_debug_on THEN
2792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2793: END IF;
2794: --
2795: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2796: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2797: p_parent_detail_id));
2798: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2799: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2816: WSH_DEBUG_SV.log(l_module_name,'WMS_DEPLOY.wms_deployment_mode', WMS_DEPLOY.wms_deployment_mode);
2817: END IF;
2818: IF ( NVL(l_del_id_for_detail.client_id,-1) <> NVL(l_del_id_for_container.client_id,NVL(l_del_id_for_detail.client_id,-1))) THEN
2819: --{
2820: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2821: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2822: --
2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2817: END IF;
2818: IF ( NVL(l_del_id_for_detail.client_id,-1) <> NVL(l_del_id_for_container.client_id,NVL(l_del_id_for_detail.client_id,-1))) THEN
2819: --{
2820: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
2821: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2822: --
2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2825: END IF;
2823: IF l_debug_on THEN
2824: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2825: END IF;
2826: --
2827: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2828: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2829: p_parent_detail_id));
2830: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2831: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2855: IF (l_del_id_for_detail.parent_delivery_detail_id IS NOT NULL
2856: AND l_del_id_for_detail.parent_delivery_detail_id <>
2857: p_parent_detail_id
2858: ) THEN
2859: FND_MESSAGE.SET_NAME('WSH','WSH_DET_PACK_ERROR');
2860: FND_MESSAGE.SET_TOKEN('DET_LINE',p_detail_id);
2861: --
2862: IF l_debug_on THEN
2863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2856: AND l_del_id_for_detail.parent_delivery_detail_id <>
2857: p_parent_detail_id
2858: ) THEN
2859: FND_MESSAGE.SET_NAME('WSH','WSH_DET_PACK_ERROR');
2860: FND_MESSAGE.SET_TOKEN('DET_LINE',p_detail_id);
2861: --
2862: IF l_debug_on THEN
2863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2864: END IF;
2862: IF l_debug_on THEN
2863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2864: END IF;
2865: --
2866: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2867: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2868: p_parent_detail_id));
2869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2870: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2892: /* bug 2677298 frontport from bug 2655474: issue #2:
2893: ** set x_return_status to error if line and container are in different deliveries.
2894: */
2895: IF (l_del_id_for_detail.delivery_id <> l_del_id_for_container.delivery_id) THEN
2896: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_DELIVERIES');
2897: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2898: --
2899: IF l_debug_on THEN
2900: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2893: ** set x_return_status to error if line and container are in different deliveries.
2894: */
2895: IF (l_del_id_for_detail.delivery_id <> l_del_id_for_container.delivery_id) THEN
2896: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_DELIVERIES');
2897: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
2898: --
2899: IF l_debug_on THEN
2900: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2901: END IF;
2899: IF l_debug_on THEN
2900: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2901: END IF;
2902: --
2903: FND_MESSAGE.SET_TOKEN('CONT_NAME',
2904: nvl(wsh_container_utilities.get_cont_name(p_parent_detail_id),
2905: p_parent_detail_id));
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2907: WSH_UTIL_CORE.Add_Message(x_return_status);
3040: EXCEPTION
3041:
3042: WHEN OTHERS THEN
3043: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3044: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
3045: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR);
3046: IF l_debug_on THEN
3047: WSH_DEBUG_SV.log(l_module_name,'Could not lock delivery: ',l_del_id_for_container.delivery_id);
3048: WSH_DEBUG_SV.pop(l_module_name);
3642: RETURN;
3643: -- End of OTM R12 : assign delivery detail
3644:
3645: WHEN mark_reprice_error then
3646: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
3647: x_return_status := l_return_status;
3648: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3649: --
3650: IF l_debug_on THEN
3653: END IF;
3654: --
3655: WHEN invalid_detail then
3656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3657: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
3658: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
3659: wsh_util_core.add_message(x_return_status,l_module_name);
3660: --
3661: IF l_debug_on THEN
3654: --
3655: WHEN invalid_detail then
3656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3657: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
3658: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
3659: wsh_util_core.add_message(x_return_status,l_module_name);
3660: --
3661: IF l_debug_on THEN
3662: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4017: WSH_DEBUG_SV.pop(l_module_name);
4018: END IF;
4019:
4020: WHEN mark_reprice_error THEN
4021: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4022: x_return_status := l_return_status;
4023: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
4024:
4025: --
4029: END IF;
4030: --
4031: WHEN invalid_detail then
4032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4033: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
4034: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
4035: wsh_util_core.add_message(x_return_status,l_module_name);
4036: --
4037: IF l_debug_on THEN
4030: --
4031: WHEN invalid_detail then
4032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4033: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
4034: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
4035: wsh_util_core.add_message(x_return_status,l_module_name);
4036: --
4037: IF l_debug_on THEN
4038: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4302: close g_get_detail_info;
4303:
4304: IF l_delivery_id is NOT NULL THEN
4305: IF l_delivery_id <> p_delivery_id THEN
4306: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4307: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_id);
4308: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_id);
4309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4310: wsh_util_core.add_message(x_return_status,l_module_name);
4303:
4304: IF l_delivery_id is NOT NULL THEN
4305: IF l_delivery_id <> p_delivery_id THEN
4306: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4307: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_id);
4308: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_id);
4309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4310: wsh_util_core.add_message(x_return_status,l_module_name);
4311: --
4304: IF l_delivery_id is NOT NULL THEN
4305: IF l_delivery_id <> p_delivery_id THEN
4306: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4307: FND_MESSAGE.SET_TOKEN('DET_NAME',p_detail_id);
4308: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_id);
4309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4310: wsh_util_core.add_message(x_return_status,l_module_name);
4311: --
4312: IF l_debug_on THEN
4328: -- J-IB-NPARIKH-{
4329: IF x_dlvy_has_lines IS NULL
4330: THEN
4331: --{
4332: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
4333: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'x_dlvy_has_lines');
4334: RAISE FND_API.G_EXC_ERROR;
4335: --}
4336: END IF;
4329: IF x_dlvy_has_lines IS NULL
4330: THEN
4331: --{
4332: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
4333: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'x_dlvy_has_lines');
4334: RAISE FND_API.G_EXC_ERROR;
4335: --}
4336: END IF;
4337: -- J-IB-NPARIKH-}
4362: (l_del.planned_flag IN ('Y','F')))
4363: AND l_del.shipment_direction IN ('O','IO') -- J-IB-NPARIKH
4364: THEN
4365: IF l_del.planned_flag IN ('Y','F') THEN
4366: fnd_message.SET_name('WSH', 'WSH_PLAN_DEL_NOT_UPDATABLE');
4367: ELSE
4368: OPEN get_lookup(l_del.status_code);
4369: FETCH get_lookup INTO l_status;
4370: CLOSE get_lookup;
4367: ELSE
4368: OPEN get_lookup(l_del.status_code);
4369: FETCH get_lookup INTO l_status;
4370: CLOSE get_lookup;
4371: fnd_message.SET_name('WSH', 'WSH_DET_DEL_NOT_UPDATABLE');
4372: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
4373: END IF;
4374: RAISE DEL_NOT_UPDATABLE;
4375: END IF;
4368: OPEN get_lookup(l_del.status_code);
4369: FETCH get_lookup INTO l_status;
4370: CLOSE get_lookup;
4371: fnd_message.SET_name('WSH', 'WSH_DET_DEL_NOT_UPDATABLE');
4372: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
4373: END IF;
4374: RAISE DEL_NOT_UPDATABLE;
4375: END IF;
4376:
4402:
4403: --J TP Release ttrichy
4404: FOR cur in c_getdet_ignore LOOP
4405: IF l_del.ignore_for_planning <> cur.ignore_for_planning THEN
4406: fnd_message.set_name('WSH', 'WSH_DET_DEL_DIFF_IGNOREPLAN');
4407: IF l_debug_on THEN
4408: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4409: END IF;
4410: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4406: fnd_message.set_name('WSH', 'WSH_DET_DEL_DIFF_IGNOREPLAN');
4407: IF l_debug_on THEN
4408: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4409: END IF;
4410: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4411: IF l_debug_on THEN
4412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4413: END IF;
4414: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4410: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4411: IF l_debug_on THEN
4412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4413: END IF;
4414: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4415: END IF;
4416: END LOOP;
4417:
4418: OPEN c_all_details_below;
4432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4433: /* For each detail */
4434: IF (l_dd_id(j) < 0) THEN
4435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4436: fnd_message.SET_name('WSH', 'WSH_DET_DETAIL_NOT_ASSIGNED');
4437: wsh_util_core.add_message(x_return_status,l_module_name);
4438: --
4439: IF l_debug_on THEN
4440: WSH_DEBUG_SV.pop(l_module_name);
4469: END IF;
4470:
4471:
4472: IF ((l_detail.delivery_id IS NOT NULL) AND (l_detail.delivery_id <> p_delivery_id)) THEN
4473: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4474: FND_MESSAGE.SET_TOKEN('DET_NAME',l_detail.delivery_detail_id);
4475: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_detail.delivery_id);
4476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4477: wsh_util_core.add_message(x_return_status,l_module_name);
4470:
4471:
4472: IF ((l_detail.delivery_id IS NOT NULL) AND (l_detail.delivery_id <> p_delivery_id)) THEN
4473: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4474: FND_MESSAGE.SET_TOKEN('DET_NAME',l_detail.delivery_detail_id);
4475: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_detail.delivery_id);
4476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4477: wsh_util_core.add_message(x_return_status,l_module_name);
4478: --
4471:
4472: IF ((l_detail.delivery_id IS NOT NULL) AND (l_detail.delivery_id <> p_delivery_id)) THEN
4473: FND_MESSAGE.SET_NAME('WSH','WSH_DET_ASSIGNED_DEL');
4474: FND_MESSAGE.SET_TOKEN('DET_NAME',l_detail.delivery_detail_id);
4475: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_detail.delivery_id);
4476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4477: wsh_util_core.add_message(x_return_status,l_module_name);
4478: --
4479: IF l_debug_on THEN
4610: x_return_status);
4611:
4612: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4614: fnd_message.SET_name('WSH', 'WSH_CONT_ATTR_ERROR');
4615: FND_MESSAGE.SET_TOKEN('DETAIL_ID',l_detail.delivery_detail_id);
4616: wsh_util_core.add_message(x_return_status,l_module_name);
4617: --
4618: IF l_debug_on THEN
4611:
4612: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4614: fnd_message.SET_name('WSH', 'WSH_CONT_ATTR_ERROR');
4615: FND_MESSAGE.SET_TOKEN('DETAIL_ID',l_detail.delivery_detail_id);
4616: wsh_util_core.add_message(x_return_status,l_module_name);
4617: --
4618: IF l_debug_on THEN
4619: WSH_DEBUG_SV.pop(l_module_name);
5003: p_delivery_id,
5004: l_detail.delivery_detail_id,
5005: x_return_status);
5006: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5007: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
5008: --
5009: IF l_debug_on THEN
5010: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5011: END IF;
5010: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5011: END IF;
5012: --
5013: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_detail.delivery_detail_id);
5014: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
5015: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5016: --
5017: IF l_debug_on THEN
5018: WSH_DEBUG_SV.pop(l_module_name);
5142: END IF;
5143: -- J-IB-NPARIKH-}
5144:
5145: WHEN mark_reprice_error THEN
5146: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
5147: x_return_status := l_return_status;
5148: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5149:
5150: --
5153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
5154: END IF;
5155: --
5156: WHEN update_mol_carton_group_error THEN
5157: fnd_message.SET_name('WSH', 'WSH_MOL_CARTON_GROUP_ERROR');
5158: x_return_status := l_return_status;
5159: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5160:
5161: --
5166:
5167:
5168: WHEN INVALID_DEL THEN
5169: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5170: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DEL');
5171: wsh_util_core.add_message(x_return_status,l_module_name);
5172: --
5173: IF l_debug_on THEN
5174: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DEL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5187: --
5188: RETURN;
5189: WHEN INVALID_DETAIL THEN
5190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5191: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DETAIL');
5192: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5193: wsh_util_core.add_message(x_return_status,l_module_name);
5194: --
5195: IF l_debug_on THEN
5188: RETURN;
5189: WHEN INVALID_DETAIL THEN
5190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5191: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DETAIL');
5192: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5193: wsh_util_core.add_message(x_return_status,l_module_name);
5194: --
5195: IF l_debug_on THEN
5196: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5199: --
5200: RETURN;
5201: WHEN DET_CONFIRMED THEN
5202: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5203: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
5204: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5205: wsh_util_core.add_message(x_return_status,l_module_name);
5206: --
5207: IF l_debug_on THEN
5200: RETURN;
5201: WHEN DET_CONFIRMED THEN
5202: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5203: fnd_message.SET_name('WSH', 'WSH_DET_CONFIRMED_DETAIL');
5204: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_detail_id);
5205: wsh_util_core.add_message(x_return_status,l_module_name);
5206: --
5207: IF l_debug_on THEN
5208: WSH_DEBUG_SV.logmsg(l_module_name,'DET_CONFIRMED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5211: --
5212: RETURN;
5213: WHEN detail_del_FROM_to_not_same THEN
5214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5215: fnd_message.SET_name('WSH', 'WSH_DET_SHIP_F_T_N_MATCH');
5216: wsh_util_core.add_message(x_return_status,l_module_name);
5217:
5218:
5219:
5225: --
5226: RETURN;
5227: WHEN ship_method_not_match THEN
5228: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5229: fnd_message.SET_name('WSH', 'WSH_DET_SHIP_METHOD_NOT_MATCH');
5230: wsh_util_core.add_message(x_return_status,l_module_name);
5231: --
5232: IF l_debug_on THEN
5233: WSH_DEBUG_SV.logmsg(l_module_name,'SHIP_METHOD_NOT_MATCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5564: IF (l_del_id_for_container1.parent_delivery_detail_id IS NOT NULL
5565: AND l_del_id_for_container1.parent_delivery_detail_id <>
5566: p_detail_id2
5567: ) THEN
5568: FND_MESSAGE.SET_NAME('WSH','WSH_DET_PACK_ERROR');
5569: --
5570: IF l_debug_on THEN
5571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5572: END IF;
5570: IF l_debug_on THEN
5571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5572: END IF;
5573: --
5574: FND_MESSAGE.SET_TOKEN('DET_LINE',
5575: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5576: --
5577: IF l_debug_on THEN
5578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5577: IF l_debug_on THEN
5578: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5579: END IF;
5580: --
5581: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5582: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5583: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5584: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5585: --
5627:
5628: IF (check_loop%FOUND) THEN
5629:
5630: CLOSE check_loop;
5631: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LOOP_NO_PACK');
5632: --
5633: IF l_debug_on THEN
5634: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5635: END IF;
5633: IF l_debug_on THEN
5634: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5635: END IF;
5636: --
5637: FND_MESSAGE.SET_TOKEN('DETAIL_CONTAINER',
5638: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5639: --
5640: IF l_debug_on THEN
5641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5640: IF l_debug_on THEN
5641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5642: END IF;
5643: --
5644: FND_MESSAGE.SET_TOKEN('PARENT_CONTAINER',
5645: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5646: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5647: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5648: --
5658: /* Added code to validate grouping attributes for Child Container and master
5659: Container */
5660: IF (l_del_id_for_container1.organization_id <>
5661: l_del_id_for_container2.organization_id) THEN
5662: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
5663: --
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5666: END IF;
5664: IF l_debug_on THEN
5665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5666: END IF;
5667: --
5668: FND_MESSAGE.SET_TOKEN('ENTITY1',
5669: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5670: --
5671: IF l_debug_on THEN
5672: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5671: IF l_debug_on THEN
5672: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5673: END IF;
5674: --
5675: FND_MESSAGE.SET_TOKEN('ENTITY2',
5676: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5677: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5678: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5679: --
5685: END IF;
5686:
5687: IF (l_del_id_for_container1.ship_from_location_id <>
5688: l_del_id_for_container2.ship_from_location_id) THEN
5689: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5690: --
5691: IF l_debug_on THEN
5692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5693: END IF;
5691: IF l_debug_on THEN
5692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5693: END IF;
5694: --
5695: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5696: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5697: --
5698: IF l_debug_on THEN
5699: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5698: IF l_debug_on THEN
5699: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5700: END IF;
5701: --
5702: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5703: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5704: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5705: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5706: --
5738: x_return_status => x_return_status);
5739:
5740: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5741:
5742: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
5743: FND_MESSAGE.SET_TOKEN('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5744: --
5745: IF l_debug_on THEN
5746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5739:
5740: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5741:
5742: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
5743: FND_MESSAGE.SET_TOKEN('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5744: --
5745: IF l_debug_on THEN
5746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5747: END IF;
5745: IF l_debug_on THEN
5746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5747: END IF;
5748: --
5749: FND_MESSAGE.SET_TOKEN('ENTITY2',nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5750: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5751: --
5752: IF l_debug_on THEN
5753: WSH_DEBUG_SV.pop(l_module_name);
5785: END IF; --}
5786: END IF ; --}
5787:
5788: IF l_display_error THEN --{
5789: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_DIFF_IGNOREPLAN');
5790: --
5791: IF l_debug_on THEN
5792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5793: END IF;
5790: --
5791: IF l_debug_on THEN
5792: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5793: END IF;
5794: FND_MESSAGE.SET_TOKEN('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5795: --
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5798: END IF;
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5798: END IF;
5799: --
5800: FND_MESSAGE.SET_TOKEN('ENTITY2',nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5801: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5802: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5803: --
5804: IF l_debug_on THEN
5828: NULL;
5829: --}
5830: ELSE
5831: --{
5832: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5833: --
5834: IF l_debug_on THEN
5835: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5836: END IF;
5834: IF l_debug_on THEN
5835: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5836: END IF;
5837: --
5838: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5839: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5840: --
5841: IF l_debug_on THEN
5842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5841: IF l_debug_on THEN
5842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5843: END IF;
5844: --
5845: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5846: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5848: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5849: --
5899: FETCH c_get_plan_flag into l_plan_flag;
5900: CLOSE c_get_plan_flag;
5901:
5902: if l_plan_flag <> 'N' then
5903: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
5904:
5905: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5906:
5907: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5919: FETCH c_get_plan_flag into l_plan_flag;
5920: CLOSE c_get_plan_flag;
5921:
5922: if l_plan_flag <> 'N' then
5923: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_STATUS_NOT_PROPER');
5924:
5925: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5926:
5927: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5940:
5941: IF l_group_by_flags.customer = 'Y' THEN
5942: IF (l_del_id_for_container1.customer_id <>
5943: l_del_id_for_container2.customer_id) THEN
5944: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5945: --
5946: IF l_debug_on THEN
5947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5948: END IF;
5946: IF l_debug_on THEN
5947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5948: END IF;
5949: --
5950: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5951: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5952: --
5953: IF l_debug_on THEN
5954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5953: IF l_debug_on THEN
5954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5955: END IF;
5956: --
5957: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5958: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5959: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5960: --
5961: IF l_debug_on THEN
5967: END IF;
5968: IF l_group_by_flags.intmed = 'Y' THEN
5969: IF (l_del_id_for_container1.intmed_ship_to_location_id <>
5970: l_del_id_for_container2.intmed_ship_to_location_id) THEN
5971: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5972: --
5973: IF l_debug_on THEN
5974: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5975: END IF;
5973: IF l_debug_on THEN
5974: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5975: END IF;
5976: --
5977: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
5978: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
5979: --
5980: IF l_debug_on THEN
5981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5980: IF l_debug_on THEN
5981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5982: END IF;
5983: --
5984: FND_MESSAGE.SET_TOKEN('CONT_NAME',
5985: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
5986: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5987: --
5988: IF l_debug_on THEN
5994: END IF;
5995: IF l_group_by_flags.fob = 'Y' THEN
5996: IF (l_del_id_for_container1.fob_code <>
5997: l_del_id_for_container2.fob_code) THEN
5998: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
5999: --
6000: IF l_debug_on THEN
6001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6002: END IF;
6000: IF l_debug_on THEN
6001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6002: END IF;
6003: --
6004: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
6005: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
6006: --
6007: IF l_debug_on THEN
6008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6007: IF l_debug_on THEN
6008: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6009: END IF;
6010: --
6011: FND_MESSAGE.SET_TOKEN('CONT_NAME',
6012: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
6013: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6014: --
6015: IF l_debug_on THEN
6021: END IF;
6022: IF l_group_by_flags.freight_terms = 'Y' THEN
6023: IF (l_del_id_for_container1.freight_terms_code <>
6024: l_del_id_for_container2.freight_terms_code) THEN
6025: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
6026: --
6027: IF l_debug_on THEN
6028: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6029: END IF;
6027: IF l_debug_on THEN
6028: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6029: END IF;
6030: --
6031: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
6032: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
6033: --
6034: IF l_debug_on THEN
6035: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6034: IF l_debug_on THEN
6035: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6036: END IF;
6037: --
6038: FND_MESSAGE.SET_TOKEN('CONT_NAME',
6039: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
6040: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6041: --
6042: IF l_debug_on THEN
6053: NVL(l_del_id_for_container2.service_level, l_del_id_for_container1.service_level))
6054: OR (NVL(l_del_id_for_container1.carrier_id, l_del_id_for_container2.carrier_id) <>
6055: NVL(l_del_id_for_container2.carrier_id, l_del_id_for_container1.carrier_id))
6056: THEN
6057: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NOT_MATCH');
6058: --
6059: IF l_debug_on THEN
6060: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6061: END IF;
6059: IF l_debug_on THEN
6060: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6061: END IF;
6062: --
6063: FND_MESSAGE.SET_TOKEN('DETAIL_ID',
6064: nvl(wsh_container_utilities.get_cont_name(p_detail_id1), p_detail_id1));
6065: --
6066: IF l_debug_on THEN
6067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6066: IF l_debug_on THEN
6067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6068: END IF;
6069: --
6070: FND_MESSAGE.SET_TOKEN('CONT_NAME',
6071: nvl(wsh_container_utilities.get_cont_name(p_detail_id2), p_detail_id2));
6072: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6073: --
6074: IF l_debug_on THEN
6559: exception
6560: WHEN others THEN
6561: rollback to before_cont_assignment;
6562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6563: fnd_message.SET_name('WSH', 'WSH_CONT_LOOP_NO_PACK');
6564: fnd_message.set_token('DETAIL_CONTAINER', detail_cont_name);
6565: fnd_message.set_token('PARENT_CONTAINER', parent_cont_name);
6566: wsh_util_core.add_message(x_return_status,l_module_name);
6567: --
6560: WHEN others THEN
6561: rollback to before_cont_assignment;
6562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6563: fnd_message.SET_name('WSH', 'WSH_CONT_LOOP_NO_PACK');
6564: fnd_message.set_token('DETAIL_CONTAINER', detail_cont_name);
6565: fnd_message.set_token('PARENT_CONTAINER', parent_cont_name);
6566: wsh_util_core.add_message(x_return_status,l_module_name);
6567: --
6568: IF l_debug_on THEN
6561: rollback to before_cont_assignment;
6562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6563: fnd_message.SET_name('WSH', 'WSH_CONT_LOOP_NO_PACK');
6564: fnd_message.set_token('DETAIL_CONTAINER', detail_cont_name);
6565: fnd_message.set_token('PARENT_CONTAINER', parent_cont_name);
6566: wsh_util_core.add_message(x_return_status,l_module_name);
6567: --
6568: IF l_debug_on THEN
6569: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected Error has occured. Oracle Err Mesg is'||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6625: RETURN;
6626: -- End of OTM R12 : assign delivery detail
6627:
6628: WHEN mark_reprice_error THEN
6629: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
6630: x_return_status := l_return_status;
6631: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6632: --
6633: IF l_debug_on THEN
6982: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE WSH_UTIL_CORE.C_IB_ASN_PREFIX || '%' -- J-IB-NPARIKH
6983: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE WSH_UTIL_CORE.C_IB_RECEIPT_PREFIX || '%' -- J-IB-NPARIKH
6984: THEN
6985: IF l_del1.planned_flag IN ('Y','F') THEN
6986: fnd_message.SET_name('WSH', 'WSH_DET_UNASSIGN_FIRMDEL');
6987: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del1.name);
6988: ELSE
6989: OPEN get_lookup(l_del1.status_code);
6990: FETCH get_lookup INTO l_status;
6983: AND NVL(p_action_prms.caller,'!!!!') NOT LIKE WSH_UTIL_CORE.C_IB_RECEIPT_PREFIX || '%' -- J-IB-NPARIKH
6984: THEN
6985: IF l_del1.planned_flag IN ('Y','F') THEN
6986: fnd_message.SET_name('WSH', 'WSH_DET_UNASSIGN_FIRMDEL');
6987: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del1.name);
6988: ELSE
6989: OPEN get_lookup(l_del1.status_code);
6990: FETCH get_lookup INTO l_status;
6991: CLOSE get_lookup;
6988: ELSE
6989: OPEN get_lookup(l_del1.status_code);
6990: FETCH get_lookup INTO l_status;
6991: CLOSE get_lookup;
6992: fnd_message.SET_name('WSH',
6993: 'WSH_DET_DEL_NOT_UPDATABLE');
6994: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
6995: END IF;
6996: RAISE DEL_NOT_UPDATABLE;
6990: FETCH get_lookup INTO l_status;
6991: CLOSE get_lookup;
6992: fnd_message.SET_name('WSH',
6993: 'WSH_DET_DEL_NOT_UPDATABLE');
6994: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
6995: END IF;
6996: RAISE DEL_NOT_UPDATABLE;
6997: END IF;
6998:
7619: --
7620: EXCEPTION
7621: WHEN mark_reprice_error THEN
7622: x_return_status := l_return_status;
7623: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
7624: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
7625: ROLLBACK TO before_unassign;
7626: --
7627: IF l_debug_on THEN
7630: END IF;
7631: --
7632: WHEN detail_not_assigned THEN
7633: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7634: fnd_message.set_name('WSH', 'WSH_DET_DETAIL_NOT_ASSIGNED');
7635: wsh_util_core.add_message(x_return_status,l_module_name);
7636: ROLLBACK TO before_unassign;
7637: --
7638: IF l_debug_on THEN
7650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DEL_NOT_UPDATABLE');
7651: END IF;
7652: --
7653: WHEN update_mol_carton_group_error THEN
7654: fnd_message.SET_name('WSH', 'WSH_MOL_CARTON_GROUP_ERROR');
7655: x_return_status := l_return_status;
7656: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
7657:
7658: --
7685: WSH_DEBUG_SV.logmsg(l_module_name,'Remove_FTE_Freight_Costs failed.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REMOVE_FC_ERROR');
7687: END IF;
7688: --
7689: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
7690: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
7691: ROLLBACK TO before_unassign;
7692:
7693: WHEN get_shipping_param_err THEN
7691: ROLLBACK TO before_unassign;
7692:
7693: WHEN get_shipping_param_err THEN
7694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7695: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
7696: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
7697: wsh_util_core.get_org_name(l_assign.organization_id));
7698: wsh_util_core.add_message(x_return_status,l_module_name);
7699: ROLLBACK TO before_unassign;
7692:
7693: WHEN get_shipping_param_err THEN
7694: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7695: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
7696: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
7697: wsh_util_core.get_org_name(l_assign.organization_id));
7698: wsh_util_core.add_message(x_return_status,l_module_name);
7699: ROLLBACK TO before_unassign;
7700: --
7704: END IF;
7705:
7706: WHEN adjust_parent_wv_err THEN
7707: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7708: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
7709: FND_MESSAGE.SET_TOKEN('CONT_NAME',WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_assign.parent_delivery_detail_id));
7710: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7711:
7712: ROLLBACK TO before_unassign;
7705:
7706: WHEN adjust_parent_wv_err THEN
7707: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7708: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
7709: FND_MESSAGE.SET_TOKEN('CONT_NAME',WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_assign.parent_delivery_detail_id));
7710: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7711:
7712: ROLLBACK TO before_unassign;
7713: --
7909:
7910: IF (c_multi_assign_rec%NOTFOUND) THEN
7911: l_num_warnings := l_num_warnings + 1;
7912: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7913: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7914: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7915: wsh_util_core.add_message(x_return_status,l_module_name);
7916: /* go ahead and process the next line */
7917: CLOSE c_multi_assign_rec;
7910: IF (c_multi_assign_rec%NOTFOUND) THEN
7911: l_num_warnings := l_num_warnings + 1;
7912: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7913: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7914: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7915: wsh_util_core.add_message(x_return_status,l_module_name);
7916: /* go ahead and process the next line */
7917: CLOSE c_multi_assign_rec;
7918: GOTO start_over_1;
7921:
7922: IF (l_multi_assign_rec.delivery_id IS null) THEN
7923: l_num_warnings := l_num_warnings + 1;
7924: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7925: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7926: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7927: wsh_util_core.add_message(x_return_status,l_module_name);
7928: /* go ahead and process the next line */
7929: GOTO start_over_1;
7922: IF (l_multi_assign_rec.delivery_id IS null) THEN
7923: l_num_warnings := l_num_warnings + 1;
7924: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7925: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
7926: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
7927: wsh_util_core.add_message(x_return_status,l_module_name);
7928: /* go ahead and process the next line */
7929: GOTO start_over_1;
7930: END IF;
8141: l_multi_assign_rec.delivery_id);
8142: END IF;
8143: IF (c_multi_assign_rec%NOTFOUND) THEN
8144: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8145: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
8146: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
8147: wsh_util_core.add_message(x_return_status,l_module_name);
8148: /* go ahead and process the next line */
8149: CLOSE c_multi_assign_rec;
8142: END IF;
8143: IF (c_multi_assign_rec%NOTFOUND) THEN
8144: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8145: fnd_message.SET_name('WSH','WSH_DET_SPEC_DET_NOT_ASSIGNED');
8146: fnd_message.SET_token('DELIVERY_DETAIL_ID', p_rec_of_detail_ids(i));
8147: wsh_util_core.add_message(x_return_status,l_module_name);
8148: /* go ahead and process the next line */
8149: CLOSE c_multi_assign_rec;
8150: GOTO start_over_2;
8152: CLOSE c_multi_assign_rec;
8153:
8154: /* Bug 2166715 - check if line was actually packed or not */
8155: IF l_multi_assign_rec.parent_delivery_detail_id IS NULL THEN l_num_warnings := l_num_warnings + 1;
8156: fnd_message.SET_name('WSH','WSH_CONT_UNASSG_NULL');
8157: wsh_util_core.add_message(x_return_status,l_module_name);
8158: END IF;
8159:
8160: Unassign_detail_FROM_cont(
8741: --
8742: exception
8743: WHEN mark_reprice_error THEN
8744: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8745: fnd_message.SET_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
8746: wsh_util_core.add_message(x_return_status,l_module_name);
8747:
8748: --
8749: IF l_debug_on THEN
8752: END IF;
8753: --
8754: WHEN delivery_id_locked THEN
8755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8756: fnd_message.SET_name('WSH', 'WSH_NO_LOCK');
8757: wsh_util_core.add_message(x_return_status,l_module_name);
8758: --
8759: IF l_debug_on THEN
8760: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Id Locked exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9137: --
9138: EXCEPTION
9139: WHEN chk_decimal_qty_failed THEN
9140: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9141: fnd_message.set_name('WSH', 'WSH_DET_DECIMAL_QTY_NOT_VALID');
9142: wsh_util_core.add_message(x_return_status,l_module_name);
9143: --
9144: IF l_debug_on THEN
9145: WSH_DEBUG_SV.logmsg(l_module_name,'CHK_DECIMAL_QTY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9147: END IF;
9148: --
9149: WHEN quantity_over THEN
9150: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9151: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
9152: wsh_util_core.add_message(x_return_status,l_module_name);
9153: --
9154: IF l_debug_on THEN
9155: WSH_DEBUG_SV.logmsg(l_module_name,'QUANTITY_OVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9157: END IF;
9158: --
9159: WHEN zero_qty THEN
9160: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9161: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
9162: wsh_util_core.add_message(x_return_status,l_module_name);
9163: --
9164: IF l_debug_on THEN
9165: WSH_DEBUG_SV.logmsg(l_module_name,'ZERO_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9167: END IF;
9168: --
9169: WHEN negative_qty THEN
9170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9171: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
9172: wsh_util_core.add_message(x_return_status,l_module_name);
9173: --
9174: IF l_debug_on THEN
9175: WSH_DEBUG_SV.logmsg(l_module_name,'NEGATIVE_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9177: END IF;
9178: --
9179: WHEN reprice_required_err THEN
9180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9181: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
9182: wsh_util_core.add_message(x_return_status,l_module_name);
9183: --
9184: IF l_debug_on THEN
9185: WSH_DEBUG_SV.logmsg(l_module_name,'REPRICE_REQUIRED_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10022:
10023: WHEN old_det_wt_vol_failed THEN
10024: rollback to split_savepoint;
10025: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10026: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
10027: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
10028: wsh_util_core.add_message(x_return_status,l_module_name);
10029: --
10030: IF l_debug_on THEN
10023: WHEN old_det_wt_vol_failed THEN
10024: rollback to split_savepoint;
10025: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10026: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
10027: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
10028: wsh_util_core.add_message(x_return_status,l_module_name);
10029: --
10030: IF l_debug_on THEN
10031: WSH_DEBUG_SV.logmsg(l_module_name,'OLD_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10034: --
10035: WHEN new_det_wt_vol_failed THEN
10036: rollback to split_savepoint;
10037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10038: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
10039: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
10040: wsh_util_core.add_message(x_return_status,l_module_name);
10041: --
10042: IF l_debug_on THEN
10035: WHEN new_det_wt_vol_failed THEN
10036: rollback to split_savepoint;
10037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10038: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
10039: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
10040: wsh_util_core.add_message(x_return_status,l_module_name);
10041: --
10042: IF l_debug_on THEN
10043: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10046: --
10047: WHEN WSH_SPLIT_ERROR THEN
10048: rollback to split_savepoint;
10049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10050: fnd_message.set_name('WSH', 'WSH_SPLIT_ERROR');
10051: fnd_message.set_token('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
10052: wsh_util_core.add_message(x_return_status,l_module_name);
10053: --
10054: IF l_debug_on THEN
10047: WHEN WSH_SPLIT_ERROR THEN
10048: rollback to split_savepoint;
10049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10050: fnd_message.set_name('WSH', 'WSH_SPLIT_ERROR');
10051: fnd_message.set_token('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
10052: wsh_util_core.add_message(x_return_status,l_module_name);
10053: --
10054: IF l_debug_on THEN
10055: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SPLIT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10057: END IF;
10058: WHEN WSH_SN_SPLIT_ERR THEN
10059: rollback to split_savepoint;
10060: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10061: fnd_message.set_name('WSH', 'WSH_SN_SPLIT_ERR');
10062: wsh_util_core.add_message(x_return_status,l_module_name);
10063: --
10064: IF l_debug_on THEN
10065: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SN_SPLIT_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10071: CLOSE c_get_req_pick_qty;
10072: END IF;
10073: rollback to split_savepoint;
10074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10075: fnd_message.set_name('WSH', 'WSH_NO_DATA_FOUND');
10076: IF l_debug_on THEN
10077: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10078: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_DATA_FOUND');
10079: END IF;
10426: --
10427: EXCEPTION
10428: WHEN chk_decimal_qty_failed THEN
10429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10430: fnd_message.set_name('WSH', 'WSH_DET_DECIMAL_QTY_NOT_VALID');
10431: wsh_util_core.add_message(x_return_status,l_module_name);
10432: --
10433: IF l_debug_on THEN
10434: WSH_DEBUG_SV.logmsg(l_module_name,'CHK_DECIMAL_QTY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10436: END IF;
10437: --
10438: WHEN quantity_over THEN
10439: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10440: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
10441: wsh_util_core.add_message(x_return_status,l_module_name);
10442: --
10443: IF l_debug_on THEN
10444: WSH_DEBUG_SV.logmsg(l_module_name,'QUANTITY_OVER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10446: END IF;
10447: --
10448: WHEN zero_qty THEN
10449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10450: fnd_message.set_name('WSH', 'WSH_NO_ZERO_NUM');
10451: wsh_util_core.add_message(x_return_status,l_module_name);
10452: --
10453: IF l_debug_on THEN
10454: WSH_DEBUG_SV.logmsg(l_module_name,'ZERO_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10456: END IF;
10457: --
10458: WHEN negative_qty THEN
10459: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10460: fnd_message.set_name('WSH', 'WSH_NO_NEG_NUM');
10461: wsh_util_core.add_message(x_return_status,l_module_name);
10462: --
10463: IF l_debug_on THEN
10464: WSH_DEBUG_SV.logmsg(l_module_name,'NEGATIVE_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10466: END IF;
10467: --
10468: WHEN reprice_required_err THEN
10469: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10470: fnd_message.set_name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
10471: wsh_util_core.add_message(x_return_status,l_module_name);
10472: --
10473: IF l_debug_on THEN
10474: WSH_DEBUG_SV.logmsg(l_module_name,'REPRICE_REQUIRED_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11435: -- HW OPMCONV. Removed OPM exception
11436:
11437: WHEN old_det_wt_vol_failed THEN
11438: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11439: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11440: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
11441: wsh_util_core.add_message(x_return_status,l_module_name);
11442: --
11443: IF l_debug_on THEN
11436:
11437: WHEN old_det_wt_vol_failed THEN
11438: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11439: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11440: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_old_delivery_detail_rec.delivery_detail_id);
11441: wsh_util_core.add_message(x_return_status,l_module_name);
11442: --
11443: IF l_debug_on THEN
11444: WSH_DEBUG_SV.logmsg(l_module_name,'OLD_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11446: END IF;
11447: --
11448: WHEN new_det_wt_vol_failed THEN
11449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11450: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11451: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
11452: wsh_util_core.add_message(x_return_status,l_module_name);
11453: --
11454: IF l_debug_on THEN
11447: --
11448: WHEN new_det_wt_vol_failed THEN
11449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11450: fnd_message.set_name('WSH', 'WSH_DET_WT_VOL_FAILED');
11451: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_new_DELIVERY_DETAIL_ID);
11452: wsh_util_core.add_message(x_return_status,l_module_name);
11453: --
11454: IF l_debug_on THEN
11455: WSH_DEBUG_SV.logmsg(l_module_name,'NEW_DET_WT_VOL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11457: END IF;
11458: --
11459: WHEN WSH_SN_SPLIT_ERR THEN
11460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11461: fnd_message.set_name('WSH', 'WSH_SN_SPLIT_ERR');
11462: wsh_util_core.add_message(x_return_status,l_module_name);
11463: --
11464: IF l_debug_on THEN
11465: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SN_SPLIT_ERR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
11870: END IF;
11871: END IF;
11872: --RTV Changes
11873: IF l_success < 0 THEN
11874: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11875: FND_MESSAGE.SET_TOKEN('FM_SERIAL',l_new_sn);
11876: FND_MESSAGE.SET_TOKEN('TO_SERIAL',l_new_to_sn);
11877: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11878: WSH_UTIL_CORE.Add_Message(x_return_status);
11871: END IF;
11872: --RTV Changes
11873: IF l_success < 0 THEN
11874: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11875: FND_MESSAGE.SET_TOKEN('FM_SERIAL',l_new_sn);
11876: FND_MESSAGE.SET_TOKEN('TO_SERIAL',l_new_to_sn);
11877: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11878: WSH_UTIL_CORE.Add_Message(x_return_status);
11879: END IF;
11872: --RTV Changes
11873: IF l_success < 0 THEN
11874: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11875: FND_MESSAGE.SET_TOKEN('FM_SERIAL',l_new_sn);
11876: FND_MESSAGE.SET_TOKEN('TO_SERIAL',l_new_to_sn);
11877: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11878: WSH_UTIL_CORE.Add_Message(x_return_status);
11879: END IF;
11880: -- bug 2740681
11963: END IF;
11964: END IF;
11965: --RTV changes
11966: IF l_success < 0 THEN
11967: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11968: FND_MESSAGE.SET_TOKEN('FM_SERIAL', c.fm_serial_number);
11969: FND_MESSAGE.SET_TOKEN('TO_SERIAL', c.to_serial_number);
11970: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11971: WSH_UTIL_CORE.Add_Message(x_return_status);
11964: END IF;
11965: --RTV changes
11966: IF l_success < 0 THEN
11967: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11968: FND_MESSAGE.SET_TOKEN('FM_SERIAL', c.fm_serial_number);
11969: FND_MESSAGE.SET_TOKEN('TO_SERIAL', c.to_serial_number);
11970: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11971: WSH_UTIL_CORE.Add_Message(x_return_status);
11972: END IF;
11965: --RTV changes
11966: IF l_success < 0 THEN
11967: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');
11968: FND_MESSAGE.SET_TOKEN('FM_SERIAL', c.fm_serial_number);
11969: FND_MESSAGE.SET_TOKEN('TO_SERIAL', c.to_serial_number);
11970: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11971: WSH_UTIL_CORE.Add_Message(x_return_status);
11972: END IF;
11973: --bug 2740681
12172: END IF;
12173: --
12174: -- Check if the Parent Container is empty, if yes, recursivelly call this API
12175: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
12176: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
12177: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
12178: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
12179: x_return_status := l_return_status;
12180: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
12173: --
12174: -- Check if the Parent Container is empty, if yes, recursivelly call this API
12175: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
12176: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
12177: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
12178: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
12179: x_return_status := l_return_status;
12180: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
12181: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
12174: -- Check if the Parent Container is empty, if yes, recursivelly call this API
12175: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
12176: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
12177: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
12178: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
12179: x_return_status := l_return_status;
12180: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
12181: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
12182: --