536:
537: WHEN wsh_invalid_action THEN
538: ROLLBACK TO detail_to_delivery_grp;
539: x_return_status := wsh_util_core.g_ret_sts_error;
540: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
541: wsh_util_core.add_message(x_return_status);
542: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
543: p_encoded => fnd_api.g_false);
544:
549:
550: WHEN wsh_no_del_det_tbl THEN
551: ROLLBACK TO detail_to_delivery_grp;
552: x_return_status := wsh_util_core.g_ret_sts_error;
553: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
554: wsh_util_core.add_message(x_return_status);
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
556: p_encoded => fnd_api.g_false);
557:
562: --
563: WHEN wsh_no_delivery_id THEN
564: ROLLBACK TO detail_to_delivery_grp;
565: x_return_status := wsh_util_core.g_ret_sts_error;
566: fnd_message.set_name('WSH', 'WSH_PUB_NO_DELIVERY');
567: wsh_util_core.add_message(x_return_status);
568: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
569: p_encoded => fnd_api.g_false);
570:
578:
579: WHEN wsh_no_delivery THEN
580: ROLLBACK TO detail_to_delivery_grp;
581: x_return_status := wsh_util_core.g_ret_sts_error;
582: fnd_message.set_name('WSH', 'WSH_DELIVERY_NOT_EXIST');
583: fnd_message.set_token('DELIVERY_NAME', p_delivery_name);
584: wsh_util_core.add_message(x_return_status);
585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
586: p_encoded => fnd_api.g_false);
579: WHEN wsh_no_delivery THEN
580: ROLLBACK TO detail_to_delivery_grp;
581: x_return_status := wsh_util_core.g_ret_sts_error;
582: fnd_message.set_name('WSH', 'WSH_DELIVERY_NOT_EXIST');
583: fnd_message.set_token('DELIVERY_NAME', p_delivery_name);
584: wsh_util_core.add_message(x_return_status);
585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
586: p_encoded => fnd_api.g_false);
587:
592: --
593: WHEN wsh_invalid_delivery_id THEN
594: ROLLBACK TO detail_to_delivery_grp;
595: x_return_status := wsh_util_core.g_ret_sts_error;
596: fnd_message.set_name('WSH', 'WSH_INVALID_DELIVERY');
597: fnd_message.set_token('DELIVERY', p_delivery_id);
598: wsh_util_core.add_message(x_return_status);
599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
600: p_encoded => fnd_api.g_false);
593: WHEN wsh_invalid_delivery_id THEN
594: ROLLBACK TO detail_to_delivery_grp;
595: x_return_status := wsh_util_core.g_ret_sts_error;
596: fnd_message.set_name('WSH', 'WSH_INVALID_DELIVERY');
597: fnd_message.set_token('DELIVERY', p_delivery_id);
598: wsh_util_core.add_message(x_return_status);
599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
600: p_encoded => fnd_api.g_false);
601:
1001:
1002: /* Bug 2777869 : Instead of message "WSH_PUB_INALID_DETAIL_ID",now we are using
1003: "WSH_DET_INVALID_DETAIL".*/
1004:
1005: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1006: fnd_message.set_token('DETAIL_ID',p_from_detail_id);
1007: wsh_util_core.add_message(x_return_status);
1008:
1009: fnd_msg_pub.count_and_get(
1002: /* Bug 2777869 : Instead of message "WSH_PUB_INALID_DETAIL_ID",now we are using
1003: "WSH_DET_INVALID_DETAIL".*/
1004:
1005: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1006: fnd_message.set_token('DETAIL_ID',p_from_detail_id);
1007: wsh_util_core.add_message(x_return_status);
1008:
1009: fnd_msg_pub.count_and_get(
1010: p_count => x_msg_count,
1018: --
1019: WHEN wsh_invalid_split_qty THEN
1020: ROLLBACK TO split_line_grp;
1021: x_return_status := wsh_util_core.g_ret_sts_error;
1022: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
1023: wsh_util_core.add_message(x_return_status);
1024:
1025: fnd_msg_pub.count_and_get(
1026: p_count => x_msg_count,
1034: --
1035: WHEN wsh_invalid_split_qty2 THEN /* OPM changes. NC - Added */
1036: ROLLBACK TO split_line_grp;
1037: x_return_status := wsh_util_core.g_ret_sts_error;
1038: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_SPLIT_QTY');
1039: wsh_util_core.add_message(x_return_status);
1040:
1041: fnd_msg_pub.count_and_get(
1042: p_count => x_msg_count,
1418: --
1419: EXCEPTION
1420: WHEN mark_reprice_error then
1421: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1422: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
1423: x_return_status := l_return_status;
1424: WSH_UTIL_CORE.add_message (x_return_status);
1425: FND_MSG_PUB.Count_And_Get
1426: ( p_count => x_msg_count,
1437: --
1438: WHEN invalid_source_code THEN
1439: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1442: WSH_UTIL_CORE.Add_Message(x_return_status);
1443: FND_MSG_PUB.Count_And_Get
1444: ( p_count => x_msg_count,
1445: p_data => x_msg_data,
1455: --
1456: WHEN update_failed THEN
1457: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1459: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_VALIDATION_FAILED');
1460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1461: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1462: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1463: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1456: WHEN update_failed THEN
1457: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1459: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_VALIDATION_FAILED');
1460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1461: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1462: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1463: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1464: FND_MSG_PUB.Count_And_Get
1457: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1459: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_VALIDATION_FAILED');
1460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1461: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1462: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1463: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1464: FND_MSG_PUB.Count_And_Get
1465: ( p_count => x_msg_count,
1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1459: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_VALIDATION_FAILED');
1460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1461: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1462: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1463: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1464: FND_MSG_PUB.Count_And_Get
1465: ( p_count => x_msg_count,
1466: p_data => x_msg_data,
2532: l_delivery_ids.delete;
2533:
2534: -- Mandatory parameters check
2535: IF( p_action_prms.caller IS NULL) THEN
2536: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2537: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CALLER');
2538: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2539: IF l_debug_on THEN
2540: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
2533:
2534: -- Mandatory parameters check
2535: IF( p_action_prms.caller IS NULL) THEN
2536: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2537: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CALLER');
2538: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2539: IF l_debug_on THEN
2540: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
2541: END IF;
2540: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
2541: END IF;
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF(p_action_prms.action_code IS NULL) THEN
2544: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2545: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
2546: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2547: IF l_debug_on THEN
2548: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
2541: END IF;
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF(p_action_prms.action_code IS NULL) THEN
2544: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2545: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
2546: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2547: IF l_debug_on THEN
2548: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
2549: END IF;
2738:
2739: IF(l_number_of_errors >0 ) THEN
2740: --{
2741: IF p_action_prms.caller = 'WSH_FSTRX' THEN
2742: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION');
2743: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2744: END IF;
2745: --
2746: IF l_debug_on THEN
2764: l_tms_interface_flag; -- OTM R12 : WSHDEVLS
2765:
2766: IF del_cur%NOTFOUND THEN
2767: CLOSE del_cur;
2768: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY');
2769: FND_MESSAGE.SET_TOKEN('DELIVERY', p_action_prms.delivery_id);
2770: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2771: IF l_debug_on THEN
2772: wsh_debug_sv.logmsg(l_module_name, 'Delivery does not exist');
2765:
2766: IF del_cur%NOTFOUND THEN
2767: CLOSE del_cur;
2768: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY');
2769: FND_MESSAGE.SET_TOKEN('DELIVERY', p_action_prms.delivery_id);
2770: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2771: IF l_debug_on THEN
2772: wsh_debug_sv.logmsg(l_module_name, 'Delivery does not exist');
2773: END IF;
2774: RAISE FND_API.G_EXC_ERROR;
2775: END IF;
2776: CLOSE del_cur;
2777: ELSE
2778: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2779: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'DELIVERY_ID');
2780: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2781: IF l_debug_on THEN
2782: wsh_debug_sv.logmsg(l_module_name, 'Null Delivery Id');
2775: END IF;
2776: CLOSE del_cur;
2777: ELSE
2778: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2779: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'DELIVERY_ID');
2780: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2781: IF l_debug_on THEN
2782: wsh_debug_sv.logmsg(l_module_name, 'Null Delivery Id');
2783: END IF;
2862: END IF;
2863:
2864: --
2865: IF(l_number_of_errors >0 ) THEN
2866: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION');
2867: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2868: IF l_debug_on THEN
2869: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
2870: END IF;
2872: END IF;
2873: --
2874: IF l_number_of_warnings > 0 THEN
2875:
2876: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION_WARN');
2877: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2878: IF l_debug_on THEN
2879: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION_WARN');
2880: END IF;
2951: b_cc_linefailed:=FALSE;
2952: FOR j in l_cc_failed_records.FIRST..l_cc_failed_records.LAST LOOP
2953: IF (p_rec_attr_tab(i).delivery_detail_id=l_cc_failed_records(j).entity_line_id) THEN
2954: b_cc_linefailed:=TRUE;
2955: FND_MESSAGE.SET_NAME('WSH','WSH_DELDET_COMP_FAILED');
2956: FND_MESSAGE.SET_TOKEN('DELDET_ID',l_cc_failed_records(j).entity_line_id);
2957: wsh_util_core.add_message(l_return_status);
2958: END IF;
2959: END LOOP;
2952: FOR j in l_cc_failed_records.FIRST..l_cc_failed_records.LAST LOOP
2953: IF (p_rec_attr_tab(i).delivery_detail_id=l_cc_failed_records(j).entity_line_id) THEN
2954: b_cc_linefailed:=TRUE;
2955: FND_MESSAGE.SET_NAME('WSH','WSH_DELDET_COMP_FAILED');
2956: FND_MESSAGE.SET_TOKEN('DELDET_ID',l_cc_failed_records(j).entity_line_id);
2957: wsh_util_core.add_message(l_return_status);
2958: END IF;
2959: END LOOP;
2960: IF (NOT(b_cc_linefailed)) THEN
3043: p_organization_id => l_organization_id,
3044: p_inventory_item_id => l_inv_item_id,
3045: p_released_status => l_released_status)
3046: ) THEN
3047: FND_MESSAGE.SET_NAME('WSH', 'WSH_OPM_LOT_INDIVISIBLE');
3048: IF p_action_prms.caller = 'WSH_FSTRX' THEN
3049: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3050: END IF;
3051: RAISE FND_API.G_EXC_ERROR;
3072: -- HW end of BUG#:2677054
3073:
3074: IF p_action_prms.action_code IN('SPLIT-LINE', 'CYCLE-COUNT', 'PICK-RELEASE-UI', 'RESOLVE-EXCEPTIONS-UI') THEN
3075: IF(p_rec_attr_tab.count > 1) THEN
3076: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
3077: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3078: IF l_debug_on THEN
3079: wsh_debug_sv.logmsg(l_module_name,'WSH_UI_MULTI_SELECTION');
3080: END IF;
3205: ELSIF p_action_prms.action_code = 'SPLIT-LINE' THEN
3206: --
3207: --
3208: IF(nvl(p_action_prms.split_quantity,0) =0) THEN
3209: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ZERO_NUM');
3210: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3211: IF l_debug_on THEN
3212: wsh_debug_sv.logmsg(l_module_name,'Zero or Null split quantity');
3213: END IF;
3924: ELSE
3925: IF l_debug_on THEN
3926: wsh_debug_sv.logmsg(l_module_name,'Incorrect Released status or incorrect quantities');
3927: END IF;
3928: fnd_message.set_name('WSH', 'WSH_CC_RSV_INSUFF');
3929: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3930: raise FND_API.G_EXC_ERROR;
3931: END IF;
3932: --
3947: p_released_status => l_released_status,
3948: p_picked_qty => l_picked_quantity,
3949: p_cycle_qty => p_action_prms.quantity_to_split)
3950: ) THEN
3951: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_PARTIAL_CYCLE_COUNT');
3952:
3953: IF p_action_prms.caller = 'WSH_FSTRX' THEN
3954: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3955: END IF;
3983:
3984: IF l_debug_on THEN
3985: wsh_debug_sv.logmsg(l_module_name,'Incorrect quantities');
3986: END IF;
3987: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_SPLIT_EXCEED');
3988: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3989: raise FND_API.G_EXC_ERROR;
3990:
3991: END IF;
4154: --} -- End Bug 3326794
4155:
4156: ELSE
4157: --
4158: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
4159: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
4160: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4161: IF l_debug_on THEN
4162: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
4155:
4156: ELSE
4157: --
4158: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
4159: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
4160: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4161: IF l_debug_on THEN
4162: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
4163: END IF;
4875: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4876: END IF;
4877: --
4878: WHEN mark_reprice_error then
4879: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4880: wsh_util_core.add_message(x_return_status, l_module_name);
4881: x_return_status := l_return_status;
4882: FND_MSG_PUB.Count_And_Get
4883: (
5045: l_organization_code,
5046: l_return_status);
5047: IF l_return_status NOT IN ( wsh_util_core.g_ret_sts_success ,WSH_UTIL_CORE.G_RET_STS_WARNING)
5048: THEN
5049: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
5050: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5051: END IF;
5052:
5053: wsh_util_core.api_post_call(
5090: IF (l_wms_enabled = FALSE) THEN --{
5091: IF (l_cont_item_id IS NULL
5092: AND l_cont_item_name IS NULL
5093: AND l_cont_item_seg.count = 0) then --{
5094: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
5095: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5096: RAISE e_NO_INV_ITEM;
5097: ELSE --}{
5098: --
5104: x_return_status => l_return_status,
5105: p_item_type => 'CONT_ITEM');
5106: IF l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
5107: THEN
5108: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
5109: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5110: wsh_util_core.api_post_call(
5111: p_return_status => l_return_status,
5112: x_num_warnings => l_number_of_warnings,
5114: );
5115: END IF;
5116: END IF; --}
5117: ELSE --}{
5118: fnd_message.set_name('WSH', 'WSH_INCORRECT_ORG');
5119: fnd_message.set_token('ORG_CODE', l_organization_code);
5120: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5121: RAISE FND_API.G_EXC_ERROR;
5122: END IF; -- wms_enabled }
5115: END IF;
5116: END IF; --}
5117: ELSE --}{
5118: fnd_message.set_name('WSH', 'WSH_INCORRECT_ORG');
5119: fnd_message.set_token('ORG_CODE', l_organization_code);
5120: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5121: RAISE FND_API.G_EXC_ERROR;
5122: END IF; -- wms_enabled }
5123: END IF; -- verify item}
5133: THEN
5134: IF l_debug_on THEN
5135: wsh_debug_sv.log(l_module_name, 'Error ucc_128_suffix_flag is set to 1 and name_suffix is set to ',p_detail_IN_rec.name_suffix);
5136: END IF;
5137: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_ERROR'); --bmso new
5138: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;
5141:
5146: IF TRUNC(NVL(p_detail_IN_rec.name_prefix,0))
5147: <> NVL(p_detail_IN_rec.name_prefix,0)
5148: OR TRUNC(NVL(p_detail_IN_rec.name_prefix,0)) < 0
5149: THEN
5150: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_PREFIX_ERR'); --bmso new
5151: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5152:
5153: END IF;
5154: EXCEPTION
5152:
5153: END IF;
5154: EXCEPTION
5155: WHEN OTHERS THEN
5156: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_PREFIX_ERR'); --bmso new
5157: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5158: END;
5159: ELSE
5160: l_suffix_length := NVL(LENGTH(p_detail_IN_rec.name_suffix),0);
5269: l_container_info_rec.lpn_ids(j));
5270: END IF;
5271:
5272: IF l_container_info_rec.lpn_ids(j) IS NULL THEN
5273: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5274: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5275: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5276: RAISE FND_API.G_EXC_ERROR;
5277:
5270: END IF;
5271:
5272: IF l_container_info_rec.lpn_ids(j) IS NULL THEN
5273: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5274: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5275: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5276: RAISE FND_API.G_EXC_ERROR;
5277:
5278: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5275: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5276: RAISE FND_API.G_EXC_ERROR;
5277:
5278: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5279: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5280: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5282: RAISE FND_API.G_EXC_ERROR;
5283:
5276: RAISE FND_API.G_EXC_ERROR;
5277:
5278: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5279: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5280: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5282: RAISE FND_API.G_EXC_ERROR;
5283:
5284: END IF;
5377: l_container_info_rec.container_names(1) := l_lpn_table(1).license_plate_number;
5378: l_container_info_rec.lpn_ids(1) := l_lpn_table(1).lpn_id;
5379:
5380: IF l_container_info_rec.lpn_ids(1) IS NULL THEN
5381: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5382: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5383: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5384: RAISE FND_API.G_EXC_ERROR;
5385:
5378: l_container_info_rec.lpn_ids(1) := l_lpn_table(1).lpn_id;
5379:
5380: IF l_container_info_rec.lpn_ids(1) IS NULL THEN
5381: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5382: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5383: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5384: RAISE FND_API.G_EXC_ERROR;
5385:
5386: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5383: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5384: RAISE FND_API.G_EXC_ERROR;
5385:
5386: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5387: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5388: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5389: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5390: RAISE FND_API.G_EXC_ERROR;
5391:
5384: RAISE FND_API.G_EXC_ERROR;
5385:
5386: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5387: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5388: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5389: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5390: RAISE FND_API.G_EXC_ERROR;
5391:
5392: END IF;
5457: IF l_debug_on THEN
5458: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5459: END IF;
5460: --
5461: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5462: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5463: RAISE FND_API.G_EXC_ERROR;
5464: END IF;
5465:
5489: END IF;
5490:
5491: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5492: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5493: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5494: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5495: RAISE FND_API.G_EXC_ERROR;
5496: END IF;
5497:
5506: -- Create container for WMS callers
5507: i := p_detail_info_tab.FIRST;
5508: WHILE i IS NOT NULL LOOP --{
5509: IF p_detail_info_tab(i).organization_id IS NULL THEN --{
5510: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5511: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ORGANIZATION_ID');
5512: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5513: IF l_debug_on THEN
5514: wsh_debug_sv.log(l_module_name,'ERROR organization id is null for', p_detail_info_tab(i).lpn_id);
5507: i := p_detail_info_tab.FIRST;
5508: WHILE i IS NOT NULL LOOP --{
5509: IF p_detail_info_tab(i).organization_id IS NULL THEN --{
5510: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5511: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ORGANIZATION_ID');
5512: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5513: IF l_debug_on THEN
5514: wsh_debug_sv.log(l_module_name,'ERROR organization id is null for', p_detail_info_tab(i).lpn_id);
5515: END IF;
5517: raise FND_API.G_EXC_ERROR;
5518:
5519: END IF; --}
5520: IF p_detail_info_tab(i).lpn_id IS NULL THEN
5521: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5522: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5523: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5524: RAISE FND_API.G_EXC_ERROR;
5525:
5518:
5519: END IF; --}
5520: IF p_detail_info_tab(i).lpn_id IS NULL THEN
5521: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5522: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5523: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5524: RAISE FND_API.G_EXC_ERROR;
5525:
5526: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5523: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5524: RAISE FND_API.G_EXC_ERROR;
5525:
5526: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5527: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5528: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5529: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5530: RAISE FND_API.G_EXC_ERROR;
5531:
5524: RAISE FND_API.G_EXC_ERROR;
5525:
5526: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5527: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5528: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5529: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5530: RAISE FND_API.G_EXC_ERROR;
5531:
5532: END IF;
5569: IF l_debug_on THEN
5570: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5571: END IF;
5572: --
5573: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5574: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5575: RAISE FND_API.G_EXC_ERROR;
5576: END IF;
5577:
5601: END IF;
5602:
5603: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5604: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5605: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5606: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5607: RAISE FND_API.G_EXC_ERROR;
5608: END IF;
5609: --
5650: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5651:
5652: rollback to s_create_containers_DDGPB;
5653: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5654: fnd_message.set_name('WSH', 'WSH_LPN_COUNT_INVALID');
5655: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5656: IF l_debug_on THEN
5657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_lpn_count_invalid');
5658: END IF;
5819:
5820: -- logic for creating containers
5821: IF nvl(WSH_WMS_LPN_GRP.g_caller,'WSH') NOT LIKE 'WMS%' THEN --{
5822: IF( p_detail_IN_rec.organization_id IS NULL and p_detail_IN_rec.organization_code IS NULL) THEN
5823: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_ORG_NULL');
5824: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5825: IF l_debug_on THEN
5826: wsh_debug_sv.logmsg(l_module_name,'Null Organization');
5827: END IF;
5828: raise FND_API.G_EXC_ERROR;
5829: ELSIF(p_detail_IN_rec.container_item_id IS NULL
5830: AND p_detail_IN_rec.container_item_name IS NULL
5831: AND p_detail_IN_rec.container_item_seg.count = 0) THEN
5832: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5833: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_ITEM');
5834: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5835: IF l_debug_on THEN
5836: wsh_debug_sv.logmsg(l_module_name,'Null Container item');
5829: ELSIF(p_detail_IN_rec.container_item_id IS NULL
5830: AND p_detail_IN_rec.container_item_name IS NULL
5831: AND p_detail_IN_rec.container_item_seg.count = 0) THEN
5832: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5833: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_ITEM');
5834: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5835: IF l_debug_on THEN
5836: wsh_debug_sv.logmsg(l_module_name,'Null Container item');
5837: END IF;
5922: p_raise_error_flag => FALSE
5923: );
5924: --
5925: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5926: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_DET_FAILED');
5927: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;
5930: l_delivery_assignments_info.delivery_id := NULL;
5953: p_raise_error_flag => FALSE
5954: );
5955:
5956: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5957: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_AS_FAILED');
5958: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5959: RAISE FND_API.G_EXC_ERROR;
5960: END IF;
5961:
6519: IF l_debug_on THEN
6520: wsh_debug_sv.logmsg(l_module_name,'No Original Detail Record ');
6521: END IF;
6522: l_number_of_errors := l_number_of_errors + 1;
6523: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
6524: FND_MESSAGE.SET_TOKEN('DETAIL_ID', x_detail_info_tab(l_index).delivery_detail_id);
6525: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6526: RAISE FND_API.G_EXC_ERROR;
6527: END IF;
6520: wsh_debug_sv.logmsg(l_module_name,'No Original Detail Record ');
6521: END IF;
6522: l_number_of_errors := l_number_of_errors + 1;
6523: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
6524: FND_MESSAGE.SET_TOKEN('DETAIL_ID', x_detail_info_tab(l_index).delivery_detail_id);
6525: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6526: RAISE FND_API.G_EXC_ERROR;
6527: END IF;
6528:
6789: END IF;
6790: WHEN e_required_field_null THEN
6791: ROLLBACK TO validate_det_loop_grp;
6792: l_number_of_errors := l_number_of_errors + 1;
6793: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
6794: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_required_field);
6795: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6796: IF l_debug_on THEN
6797: WSH_DEBUG_SV.logmsg(l_module_name,'E_REQUIRED_FIELD_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6790: WHEN e_required_field_null THEN
6791: ROLLBACK TO validate_det_loop_grp;
6792: l_number_of_errors := l_number_of_errors + 1;
6793: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
6794: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_required_field);
6795: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6796: IF l_debug_on THEN
6797: WSH_DEBUG_SV.logmsg(l_module_name,'E_REQUIRED_FIELD_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6798: END IF;
6799: -- J-IB-NPARIKH-{
6800: WHEN e_ib_create_error THEN
6801: ROLLBACK TO validate_det_loop_grp;
6802: l_number_of_errors := l_number_of_errors + 1;
6803: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_CREATE_LINE_ERROR');
6804: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6805: IF l_debug_on THEN
6806: WSH_DEBUG_SV.logmsg(l_module_name,'e_ib_create_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6807: END IF;
6807: END IF;
6808: -- J-IB-NPARIKH-}
6809:
6810: when uom_conversion_failed then
6811: FND_MESSAGE.SEt_NAME('WSH','UOM_CONVERSION_FAILED');
6812: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6813:
6814: IF l_debug_on THEN
6815: WSH_DEBUG_SV.logmsg(l_module_name,'UOM_CONVERSION_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7239: --
7240: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7241: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7242: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7243: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
7244: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
7245: IF l_debug_on THEN
7246: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:delivery_detail_locked');
7247: END IF;
8799: IF l_inv_controls.ser_flag = 'N'
8800: THEN
8801: -- (
8802: l_return_status := wsh_util_core.g_ret_sts_error;
8803: fnd_message.set_name('WSH', 'WSH_INV_INVALID');
8804: fnd_message.set_token('INV_ATTRIBUTE', 'Serial Number Code');
8805: wsh_util_core.add_message(l_return_status);
8806: RAISE fnd_api.g_exc_error;
8807: -- )
8800: THEN
8801: -- (
8802: l_return_status := wsh_util_core.g_ret_sts_error;
8803: fnd_message.set_name('WSH', 'WSH_INV_INVALID');
8804: fnd_message.set_token('INV_ATTRIBUTE', 'Serial Number Code');
8805: wsh_util_core.add_message(l_return_status);
8806: RAISE fnd_api.g_exc_error;
8807: -- )
8808: END IF;
9480: EXCEPTION
9481: WHEN e_invalid_delivered_qty THEN
9482: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9483: x_return_status := FND_API.G_RET_STS_ERROR ;
9484: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERED_QTY');
9485: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
9486: FND_MSG_PUB.Count_And_Get
9487: (
9488: p_count => x_msg_count,
9719: CLOSE parent_detail_cur;
9720:
9721: IF(l_parent_detail_id IS NOT NULL) THEN
9722: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9723: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9724: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9725: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9726: END IF;
9727: ELSIF (p_original_rec.container_flag = 'N') THEN -- R12 MDC
9725: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9726: END IF;
9727: ELSIF (p_original_rec.container_flag = 'N') THEN -- R12 MDC
9728: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9729: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9730: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9731: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9732: END IF;
9733: END IF;
9744: END IF;
9745:
9746: IF(x_detail_rec.inspection_flag = 'N' AND p_original_rec.inspection_flag IN ('I', 'R')) THEN
9747: x_detail_rec.inspection_flag := p_original_rec.inspection_flag;
9748: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_INSPECT_FLAG');
9749: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9750: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9751: END IF;
9752:
10134: l_number_of_warnings := 0;
10135:
10136: -- Check for generic mandatory parameters
10137: IF p_In_rec.caller IS NULL THEN
10138: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10139: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CALLER');
10140: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10141: IF l_debug_on THEN
10142: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
10135:
10136: -- Check for generic mandatory parameters
10137: IF p_In_rec.caller IS NULL THEN
10138: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10139: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CALLER');
10140: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10141: IF l_debug_on THEN
10142: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
10143: END IF;
10144: RAISE FND_API.G_EXC_ERROR;
10145: END IF;
10146:
10147: IF p_In_rec.action_code IS NULL THEN
10148: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10149: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
10150: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10151: IF l_debug_on THEN
10152: wsh_debug_sv.logmsg(l_module_name,'Null Action Code');
10145: END IF;
10146:
10147: IF p_In_rec.action_code IS NULL THEN
10148: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10149: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
10150: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10151: IF l_debug_on THEN
10152: wsh_debug_sv.logmsg(l_module_name,'Null Action Code');
10153: END IF;
10153: END IF;
10154: RAISE FND_API.G_EXC_ERROR;
10155: ELSIF(p_In_rec.action_code NOT IN('CREATE', 'UPDATE', 'CANCEL')
10156: OR (p_In_rec.action_code = 'CANCEL' AND p_In_rec.caller <> 'WSH_INBOUND')) THEN
10157: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
10158: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_In_rec.action_code );
10159: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10160: IF l_debug_on THEN
10161: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
10154: RAISE FND_API.G_EXC_ERROR;
10155: ELSIF(p_In_rec.action_code NOT IN('CREATE', 'UPDATE', 'CANCEL')
10156: OR (p_In_rec.action_code = 'CANCEL' AND p_In_rec.caller <> 'WSH_INBOUND')) THEN
10157: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
10158: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_In_rec.action_code );
10159: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10160: IF l_debug_on THEN
10161: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
10162: END IF;
10758: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10759: END IF;
10760: --
10761: WHEN mark_reprice_error then
10762: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
10763: wsh_util_core.add_message(x_return_status, l_module_name);
10764: x_return_status := l_return_status;
10765: --
10766: -- Start code for Bugfix 4070732