[Home] [Help]
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.logmsg(l_module_name, 'VALUE_ERROR exception has occured for Document Number', WSH_DEBUG_SV.C_EXCEP_LEVEL);
1019: END IF;
1020: --
1021: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
1022: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DOCUMENT_NUMBER');
1023: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1024: END;
1025:
1018: WSH_DEBUG_SV.logmsg(l_module_name, 'VALUE_ERROR exception has occured for Document Number', WSH_DEBUG_SV.C_EXCEP_LEVEL);
1019: END IF;
1020: --
1021: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
1022: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DOCUMENT_NUMBER');
1023: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1024: END;
1025:
1026: --Validating Document Revision
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.logmsg(l_module_name, 'VALUE_ERROR exception has occured for Document Revision', WSH_DEBUG_SV.C_EXCEP_LEVEL);
1038: END IF;
1039: --
1040: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
1041: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DOCUMENT_REVISION');
1042: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1043: END;
1044:
1037: WSH_DEBUG_SV.logmsg(l_module_name, 'VALUE_ERROR exception has occured for Document Revision', WSH_DEBUG_SV.C_EXCEP_LEVEL);
1038: END IF;
1039: --
1040: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
1041: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DOCUMENT_REVISION');
1042: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1043: END;
1044:
1045: BEGIN
1232: IF l_debug_on THEN
1233: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in WMS_DEPLOY.GET_CLIENT_DETAILS');
1234: END IF;
1235: l_temp_status := 'INVALID_HEADER';
1236: FND_MESSAGE.Set_Name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CLIENT_CODE');
1238: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1239: GOTO loop_end;
1240: --}
1233: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in WMS_DEPLOY.GET_CLIENT_DETAILS');
1234: END IF;
1235: l_temp_status := 'INVALID_HEADER';
1236: FND_MESSAGE.Set_Name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CLIENT_CODE');
1238: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1239: GOTO loop_end;
1240: --}
1241: END IF;
1251: IF l_debug_on THEN
1252: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in get_client_default_parameters => ' || l_return_status, WSH_DEBUG_SV.C_ERR_LEVEL);
1253: END IF;
1254: l_temp_status := 'INVALID_HEADER';
1255: FND_MESSAGE.Set_Name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CLIENT_DEFAULTS');
1257: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1258: GOTO loop_end;
1259: END IF;
1252: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in get_client_default_parameters => ' || l_return_status, WSH_DEBUG_SV.C_ERR_LEVEL);
1253: END IF;
1254: l_temp_status := 'INVALID_HEADER';
1255: FND_MESSAGE.Set_Name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CLIENT_DEFAULTS');
1257: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1258: GOTO loop_end;
1259: END IF;
1260: l_org_id := NULL;
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in get_client_default_parameters => ' || l_return_status, WSH_DEBUG_SV.C_ERR_LEVEL);
1280: END IF;
1281: l_temp_status := 'INVALID_HEADER';
1282: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
1283: FND_MESSAGE.Set_Token('ATTRIBUTE', 'CLIENT_CODE');
1284: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1285: GOTO loop_end;
1286: --} client validation.
1279: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in get_client_default_parameters => ' || l_return_status, WSH_DEBUG_SV.C_ERR_LEVEL);
1280: END IF;
1281: l_temp_status := 'INVALID_HEADER';
1282: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
1283: FND_MESSAGE.Set_Token('ATTRIBUTE', 'CLIENT_CODE');
1284: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1285: GOTO loop_end;
1286: --} client validation.
1287: END IF;
1346: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Some or all of Order Type/Price List/Org Id are not set');
1347: END IF;
1348: --
1349: l_temp_status := 'INVALID_HEADER';
1350: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ERROR');
1351: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1352: goto loop_end;
1353: END IF;
1354:
1369: l_temp_currency_code := l_currency_code;
1370:
1371: WHEN TOO_MANY_ROWS THEN
1372: l_temp_status := 'INVALID_HEADER';
1373: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_CURRENCY_CODE');
1374: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1375: IF l_debug_on THEN
1376: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Shipment Request has lines with more than 1 Currency Code');
1377: END IF;
1380: END;
1381:
1382: IF l_currency_code <> l_temp_currency_code THEN
1383: l_temp_status := 'INVALID_HEADER';
1384: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_CURRENCY_MISMATCH');
1385: FND_MESSAGE.Set_Token('CUR_CODE_HDR', l_currency_code);
1386: FND_MESSAGE.Set_Token('CUR_CODE_LINES', l_temp_currency_code);
1387: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1388: --
1381:
1382: IF l_currency_code <> l_temp_currency_code THEN
1383: l_temp_status := 'INVALID_HEADER';
1384: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_CURRENCY_MISMATCH');
1385: FND_MESSAGE.Set_Token('CUR_CODE_HDR', l_currency_code);
1386: FND_MESSAGE.Set_Token('CUR_CODE_LINES', l_temp_currency_code);
1387: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1388: --
1389: IF l_debug_on THEN
1382: IF l_currency_code <> l_temp_currency_code THEN
1383: l_temp_status := 'INVALID_HEADER';
1384: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_CURRENCY_MISMATCH');
1385: FND_MESSAGE.Set_Token('CUR_CODE_HDR', l_currency_code);
1386: FND_MESSAGE.Set_Token('CUR_CODE_LINES', l_temp_currency_code);
1387: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1388: --
1389: IF l_debug_on THEN
1390: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Shipment Request has lines with more than 1 Currency Code');
1421:
1422: IF l_header_id is not null THEN -- {
1423:
1424: IF l_transaction_rec.action_type = 'A' THEN
1425: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_HEADER_EXISTS');
1426: FND_MESSAGE.Set_Token('DOCUMENT_NUMBER', l_document_number);
1427: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1428: l_temp_status := 'INVALID_HEADER';
1429: --
1422: IF l_header_id is not null THEN -- {
1423:
1424: IF l_transaction_rec.action_type = 'A' THEN
1425: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_HEADER_EXISTS');
1426: FND_MESSAGE.Set_Token('DOCUMENT_NUMBER', l_document_number);
1427: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1428: l_temp_status := 'INVALID_HEADER';
1429: --
1430: IF l_debug_on THEN
1432: END IF;
1433: --
1434: goto loop_end;
1435: ELSIF l_om_header_rec.open_flag = 'N' THEN
1436: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_HEADER_CLOSED');
1437: FND_MESSAGE.Set_Token('DOCUMENT_NUMBER', l_document_number);
1438: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1439: l_temp_status := 'INVALID_HEADER';
1440: --
1433: --
1434: goto loop_end;
1435: ELSIF l_om_header_rec.open_flag = 'N' THEN
1436: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_HEADER_CLOSED');
1437: FND_MESSAGE.Set_Token('DOCUMENT_NUMBER', l_document_number);
1438: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1439: l_temp_status := 'INVALID_HEADER';
1440: --
1441: IF l_debug_on THEN
1444: --
1445: goto loop_end;
1446: ELSIF l_om_header_rec.version_number >= l_document_revision
1447: THEN
1448: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INVALID_REVISION');
1449: FND_MESSAGE.Set_Token('DOCUMENT_REVISION', l_document_revision);
1450: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1451: l_temp_status := 'INVALID_HEADER';
1452: --
1445: goto loop_end;
1446: ELSIF l_om_header_rec.version_number >= l_document_revision
1447: THEN
1448: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INVALID_REVISION');
1449: FND_MESSAGE.Set_Token('DOCUMENT_REVISION', l_document_revision);
1450: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1451: l_temp_status := 'INVALID_HEADER';
1452: --
1453: IF l_debug_on THEN
1725: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: No order lines to process for action Add/Change');
1726: END IF;
1727: --
1728: l_temp_status := 'INVALID_HEADER';
1729: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_LINE_MISSING');
1730: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
1731: goto loop_end;
1732: ELSE
1733: FOR i in l_line_tbl.first..l_line_tbl.last
2041: WSH_DEBUG_SV.log(l_module_name, 'Error: Delivery details not created for Line Id', l_details_interface_tab(i).line_id);
2042: END IF;
2043: --
2044: l_temp_status := 'INVALID_HEADER';
2045: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ERROR');
2046: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
2047: goto loop_end;
2048: END IF;
2049: END IF;
2749: IF l_debug_on THEN
2750: wsh_debug_sv.logmsg(l_module_name, 'Error: Invalid Operating Unit returned');
2751: END IF;
2752: --
2753: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_OU_NOT_ASSIGNED');
2754: FND_MESSAGE.Set_Token('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(x_delivery_interface_rec.organization_id));
2755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2756: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
2757: END IF;
2750: wsh_debug_sv.logmsg(l_module_name, 'Error: Invalid Operating Unit returned');
2751: END IF;
2752: --
2753: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_OU_NOT_ASSIGNED');
2754: FND_MESSAGE.Set_Token('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(x_delivery_interface_rec.organization_id));
2755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2756: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
2757: END IF;
2758: END IF;
2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.log(l_module_name, 'Error: More than one order line exists for same line number', p_line_number);
2968: END IF;
2969: --
2970: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ERROR');
2971: x_return_status := WSH_UTIl_CORE.G_RET_STS_ERROR;
2972: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name);
2973: END IF;
2974:
3177: --
3178: EXCEPTION
3179: WHEN RECORD_LOCKED THEN
3180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3181: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
3182: WSH_UTIL_CORE.add_message (x_return_status);
3183: --
3184: IF l_debug_on THEN
3185: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4188: p_om_header_rec.header_attributes_changed := FALSE;
4189:
4190: IF p_del_interface_rec.organization_id <> p_om_header_rec.ship_from_org_id THEN
4191: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4192: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_REJECT_ORG_CHANGE');
4193: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
4194: --
4195: IF l_debug_on THEN
4196: WSH_DEBUG_SV.logmsg(l_module_name, 'Error => Ship From Changed');
4236: END IF;
4237:
4238: IF ( nvl(l_sold_to, FND_API.G_MISS_NUM) <> p_om_header_rec.sold_to_org_id ) THEN
4239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4240: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_REJECT_SOLDTO_CHANGE');
4241: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
4242: --
4243: IF l_debug_on THEN
4244: WSH_DEBUG_SV.logmsg(l_module_name, 'Error => SoldTo customer changed');
5437: WSH_DEBUG_SV.log(l_module_name, 'x_header_rec.order_source_id', x_header_rec.order_source_id);
5438: END IF;
5439: IF (x_header_rec.order_source_id IS NULL OR x_header_rec.order_source_id = FND_API.G_MISS_NUM ) THEN
5440: --{
5441: FND_MESSAGE.Set_Name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
5442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_SOURCE');
5443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5444: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
5445: IF l_debug_on THEN
5438: END IF;
5439: IF (x_header_rec.order_source_id IS NULL OR x_header_rec.order_source_id = FND_API.G_MISS_NUM ) THEN
5440: --{
5441: FND_MESSAGE.Set_Name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
5442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_SOURCE');
5443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5444: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
5445: IF l_debug_on THEN
5446: WSH_DEBUG_SV.log(l_module_name, 'Return Status',x_return_status);
5604: IF l_debug_on THEN
5605: WSH_DEBUG_SV.log(l_module_name, 'Error: Missing Attributes', l_missing_attr);
5606: END IF;
5607: --
5608: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
5609: FND_MESSAGE.Set_Token('ATTRIBUTE', l_missing_attr);
5610: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5611: l_call_attr_changed := FALSE;
5612: END IF;
5605: WSH_DEBUG_SV.log(l_module_name, 'Error: Missing Attributes', l_missing_attr);
5606: END IF;
5607: --
5608: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
5609: FND_MESSAGE.Set_Token('ATTRIBUTE', l_missing_attr);
5610: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5611: l_call_attr_changed := FALSE;
5612: END IF;
5613:
5623: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: DeliverTo Partner Address is populated without DeliverTo Partner detail');
5624: END IF;
5625: --
5626: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5627: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INVALID_DELIVER_INFO');
5628: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DELIVERTO_PARTNER_ADDRESS');
5629: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5630: l_call_attr_changed := FALSE;
5631: END IF;
5624: END IF;
5625: --
5626: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5627: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INVALID_DELIVER_INFO');
5628: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DELIVERTO_PARTNER_ADDRESS');
5629: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5630: l_call_attr_changed := FALSE;
5631: END IF;
5632: END IF;
5645: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: DeliverTo Partner Contact is populated without DeliverTo Partner detail');
5646: END IF;
5647: --
5648: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5649: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INVALID_DELIVER_INFO');
5650: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DELIVERTO_PARTNER_CONTACT');
5651: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5652: l_call_attr_changed := FALSE;
5653: END IF;
5646: END IF;
5647: --
5648: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5649: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INVALID_DELIVER_INFO');
5650: FND_MESSAGE.Set_Token('ATTRIBUTE', 'DELIVERTO_PARTNER_CONTACT');
5651: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5652: l_call_attr_changed := FALSE;
5653: END IF;
5654: END IF;
5712: wsh_debug_sv.logmsg(l_module_name, 'Error: Ship Method information is incomplete');
5713: END IF;
5714: --
5715: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5716: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_INCOMPLETE_SM');
5717: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5718: END IF;
5719:
5720: EXCEPTION
5718: END IF;
5719:
5720: EXCEPTION
5721: WHEN NO_DATA_FOUND THEN
5722: FND_MESSAGE.Set_Name('WSH', 'WSH_CARRIER_NOT_FOUND');
5723: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5724: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5725: --
5726: IF l_debug_on THEN
5847: l_missing_attr := l_missing_attr || ', ' || 'SHIP_METHOD';
5848: END IF;
5849: END IF;
5850:
5851: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_REJECT_HEADER_CHANGE');
5852: FND_MESSAGE.Set_Token('HEADER_ATTR', l_missing_attr);
5853: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5854: --
5855: IF l_debug_on THEN
5848: END IF;
5849: END IF;
5850:
5851: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_REJECT_HEADER_CHANGE');
5852: FND_MESSAGE.Set_Token('HEADER_ATTR', l_missing_attr);
5853: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name);
5854: --
5855: IF l_debug_on THEN
5856: wsh_debug_sv.logmsg(l_module_name, 'Error: Header attributes cannot be changed');
6012: --
6013:
6014: IF (x_details_interface_rec_tab(i).line_number <= 0) OR
6015: (trunc(x_details_interface_rec_tab(i).line_number) <> x_details_interface_rec_tab(i).line_number) THEN
6016: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
6017: FND_MESSAGE.Set_Token('ATTRIBUTE', 'LINE_NUMBER');
6018: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6019: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6020: --
6013:
6014: IF (x_details_interface_rec_tab(i).line_number <= 0) OR
6015: (trunc(x_details_interface_rec_tab(i).line_number) <> x_details_interface_rec_tab(i).line_number) THEN
6016: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
6017: FND_MESSAGE.Set_Token('ATTRIBUTE', 'LINE_NUMBER');
6018: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6019: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6020: --
6021: IF l_debug_on THEN
6066: IF l_debug_on THEN
6067: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Line is already Closed');
6068: END IF;
6069: --
6070: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_LINE_CLOSED');
6071: FND_MESSAGE.Set_Token('LINE_NUMBER', x_details_interface_rec_tab(i).line_number);
6072: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6073: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6074: goto loop_end;
6067: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Line is already Closed');
6068: END IF;
6069: --
6070: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_LINE_CLOSED');
6071: FND_MESSAGE.Set_Token('LINE_NUMBER', x_details_interface_rec_tab(i).line_number);
6072: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6073: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6074: goto loop_end;
6075: END IF;
6081: IF l_debug_on THEN
6082: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Requested Quantity is NULL');
6083: END IF;
6084: --
6085: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
6086: FND_MESSAGE.Set_Token('ATTRIBUTE', 'ORDERED_QUANTITY');
6087: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6088: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6089: -- Bug 8452056: Check only if ordered quantity is negative.
6082: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Requested Quantity is NULL');
6083: END IF;
6084: --
6085: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
6086: FND_MESSAGE.Set_Token('ATTRIBUTE', 'ORDERED_QUANTITY');
6087: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6088: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6089: -- Bug 8452056: Check only if ordered quantity is negative.
6090: ELSIF ( x_details_interface_rec_tab(i).requested_quantity < 0 )
6093: IF l_debug_on THEN
6094: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Requested Quantity cannot be Negative');
6095: END IF;
6096: --
6097: FND_MESSAGE.Set_Name('WSH', 'WSH_UI_NEGATIVE_QTY');
6098: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6099: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6100: END IF;
6101:
6105: IF l_debug_on THEN
6106: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Requested Quantity UOM is NULL');
6107: END IF;
6108: --
6109: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
6110: FND_MESSAGE.Set_Token('ATTRIBUTE', 'ORDERED_QUANTITY_UOM');
6111: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6112: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6113: END IF;
6106: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Requested Quantity UOM is NULL');
6107: END IF;
6108: --
6109: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_ATTR_MANDATORY');
6110: FND_MESSAGE.Set_Token('ATTRIBUTE', 'ORDERED_QUANTITY_UOM');
6111: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6112: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6113: END IF;
6114:
6120: IF l_debug_on THEN
6121: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Ship Tolerance Above('||x_details_interface_rec_tab(i).ship_tolerance_above||') Validation Failed');
6122: END IF;
6123: --
6124: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
6125: FND_MESSAGE.Set_Token('ATTRIBUTE', 'SHIP_TOLERANCE_ABOVE');
6126: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6127: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6128: END IF;
6121: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Ship Tolerance Above('||x_details_interface_rec_tab(i).ship_tolerance_above||') Validation Failed');
6122: END IF;
6123: --
6124: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
6125: FND_MESSAGE.Set_Token('ATTRIBUTE', 'SHIP_TOLERANCE_ABOVE');
6126: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6127: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6128: END IF;
6129:
6135: IF l_debug_on THEN
6136: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Ship Tolerance Below('||x_details_interface_rec_tab(i).ship_tolerance_below||') Validation Failed');
6137: END IF;
6138: --
6139: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
6140: FND_MESSAGE.Set_Token('ATTRIBUTE', 'SHIP_TOLERANCE_BELOW');
6141: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6142: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6143: END IF;
6136: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Ship Tolerance Below('||x_details_interface_rec_tab(i).ship_tolerance_below||') Validation Failed');
6137: END IF;
6138: --
6139: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_POSITIVE_INTEGER');
6140: FND_MESSAGE.Set_Token('ATTRIBUTE', 'SHIP_TOLERANCE_BELOW');
6141: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6142: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6143: END IF;
6144:
6150: IF l_debug_on THEN
6151: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Inventory Item information is missing');
6152: END IF;
6153: --
6154: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUIRED_FIELD_NULL');
6155: FND_MESSAGE.Set_Token('FIELD_NAME', 'ITEM_NUMBER OR ITEM_ID');
6156: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6157: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6158: ELSIF x_details_interface_rec_tab(i).inventory_item_id is null
6151: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Inventory Item information is missing');
6152: END IF;
6153: --
6154: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUIRED_FIELD_NULL');
6155: FND_MESSAGE.Set_Token('FIELD_NAME', 'ITEM_NUMBER OR ITEM_ID');
6156: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6157: WSH_UTIL_CORE.Add_Message(l_temp_status, l_module_name );
6158: ELSIF x_details_interface_rec_tab(i).inventory_item_id is null
6159: THEN
6736: wsh_debug_sv.logmsg(l_module_name, 'Error: Organization information is missing.');
6737: END IF;
6738: --
6739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6740: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUIRED_FIELD_NULL');
6741: FND_MESSAGE.Set_Token('FIELD_NAME', 'ORGANIZATION');
6742: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
6743: END IF;
6744:
6737: END IF;
6738: --
6739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6740: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUIRED_FIELD_NULL');
6741: FND_MESSAGE.Set_Token('FIELD_NAME', 'ORGANIZATION');
6742: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
6743: END IF;
6744:
6745: --
7151: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Schedule dates cannot be changed.');
7152: END IF;
7153: --
7154: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7155: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_REJ_SCH_DATE_CHANGE');
7156: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
7157: goto end_loop;
7158: END IF;
7159: END IF;
7233: WSH_DEBUG_SV.logmsg(l_module_name, 'Error: Inventory attributes cannot be changed.');
7234: END IF;
7235: --
7236: l_temp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7237: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_REJ_INV_CTRL_CHANGE');
7238: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name );
7239: goto end_loop;
7240: END IF;
7241: END IF;