[Home] [Help]
309: WHEN Error THEN
310:
311: L_Success := 3;
312: Error_Counter := Error_Counter + 1;
313: FND_MESSAGE.Set_Token('TABLE',
314: 'MTL_CI_INTERFACE', FALSE);
315: Error_Message := FND_MESSAGE.Get;
316: Manage_Error_Code('OUT', NULL, Curr_Error);
317:
311: L_Success := 3;
312: Error_Counter := Error_Counter + 1;
313: FND_MESSAGE.Set_Token('TABLE',
314: 'MTL_CI_INTERFACE', FALSE);
315: Error_Message := FND_MESSAGE.Get;
316: Manage_Error_Code('OUT', NULL, Curr_Error);
317:
318: UPDATE MTL_CI_INTERFACE MCII
319: SET MCII.Error_Code = Curr_Error,
345: CLOSE CI_Cur;
346:
347: IF (Error_Counter > 0) THEN
348: L_Success := 3;
349: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
350: FND_MESSAGE.Set_Token('TABLE', 'MTL_CI_INTERFACE', FALSE);
351: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
352: Error_Message := FND_MESSAGE.Get;
353: --DBMS_OUTPUT.Put_Line(Error_Message);
346:
347: IF (Error_Counter > 0) THEN
348: L_Success := 3;
349: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
350: FND_MESSAGE.Set_Token('TABLE', 'MTL_CI_INTERFACE', FALSE);
351: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
352: Error_Message := FND_MESSAGE.Get;
353: --DBMS_OUTPUT.Put_Line(Error_Message);
354: END IF;
347: IF (Error_Counter > 0) THEN
348: L_Success := 3;
349: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
350: FND_MESSAGE.Set_Token('TABLE', 'MTL_CI_INTERFACE', FALSE);
351: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
352: Error_Message := FND_MESSAGE.Get;
353: --DBMS_OUTPUT.Put_Line(Error_Message);
354: END IF;
355:
348: L_Success := 3;
349: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
350: FND_MESSAGE.Set_Token('TABLE', 'MTL_CI_INTERFACE', FALSE);
351: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
352: Error_Message := FND_MESSAGE.Get;
353: --DBMS_OUTPUT.Put_Line(Error_Message);
354: END IF;
355:
356: COMMIT;
362: WHEN Error THEN
363:
364: L_Success := 3;
365: Error_Counter := Error_Counter + 1;
366: FND_MESSAGE.Set_Token('TABLE', 'MTL_CI_INTERFACE', FALSE);
367: Error_Message := FND_MESSAGE.Get;
368: Manage_Error_Code('OUT', NULL, Curr_Error);
369:
370: UPDATE MTL_CI_INTERFACE MCII
363:
364: L_Success := 3;
365: Error_Counter := Error_Counter + 1;
366: FND_MESSAGE.Set_Token('TABLE', 'MTL_CI_INTERFACE', FALSE);
367: Error_Message := FND_MESSAGE.Get;
368: Manage_Error_Code('OUT', NULL, Curr_Error);
369:
370: UPDATE MTL_CI_INTERFACE MCII
371: SET MCII.Error_Code = Curr_Error,
682: Master_Container_Segment20,
683: Container_Item_Org_Id);
684:
685: ELSE
686: FND_MESSAGE.Set_Name('INV',
687: 'INV_NO_MASTER_CONTAINER');
688: Manage_Error_Code('IN', 'APP-43049',
689: Curr_Error);
690: RAISE Error;
715: Container_Item_Org_Id);
716: END IF;
717: ELSE
718:
719: FND_MESSAGE.Set_Name('INV', 'INV_NO_ORGANIZATION');
720: FND_MESSAGE.Set_Token('COLUMN1',
721: 'MASTER_ORGANIZATION_ID', FALSE);
722: FND_MESSAGE.Set_Token('COLUMN2',
723: 'MASTER_ORGANIZATION_CODE', FALSE);
716: END IF;
717: ELSE
718:
719: FND_MESSAGE.Set_Name('INV', 'INV_NO_ORGANIZATION');
720: FND_MESSAGE.Set_Token('COLUMN1',
721: 'MASTER_ORGANIZATION_ID', FALSE);
722: FND_MESSAGE.Set_Token('COLUMN2',
723: 'MASTER_ORGANIZATION_CODE', FALSE);
724: FND_MESSAGE.Set_Token('COLUMN3',
718:
719: FND_MESSAGE.Set_Name('INV', 'INV_NO_ORGANIZATION');
720: FND_MESSAGE.Set_Token('COLUMN1',
721: 'MASTER_ORGANIZATION_ID', FALSE);
722: FND_MESSAGE.Set_Token('COLUMN2',
723: 'MASTER_ORGANIZATION_CODE', FALSE);
724: FND_MESSAGE.Set_Token('COLUMN3',
725: 'MASTER_ORGANIZATION_NAME', FALSE);
726: Manage_Error_Code('IN', 'APP-43045', Curr_Error);
720: FND_MESSAGE.Set_Token('COLUMN1',
721: 'MASTER_ORGANIZATION_ID', FALSE);
722: FND_MESSAGE.Set_Token('COLUMN2',
723: 'MASTER_ORGANIZATION_CODE', FALSE);
724: FND_MESSAGE.Set_Token('COLUMN3',
725: 'MASTER_ORGANIZATION_NAME', FALSE);
726: Manage_Error_Code('IN', 'APP-43045', Curr_Error);
727: RAISE Error;
728: END IF;
835: Manage_Error_Code('IN', 'APP-00000', Curr_Error);
836:
837: ELSE
838:
839: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ITEM_DEF_LEVEL');
840: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_DEFINITION_LEVEL', FALSE);
841: Manage_Error_Code('IN', 'APP-43000', Curr_Error);
842: RAISE Error;
843:
836:
837: ELSE
838:
839: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ITEM_DEF_LEVEL');
840: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_DEFINITION_LEVEL', FALSE);
841: Manage_Error_Code('IN', 'APP-43000', Curr_Error);
842: RAISE Error;
843:
844: END IF;
889: Manage_Error_Code('IN', 'APP-00000', Curr_Error);
890:
891: ELSE
892:
893: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ITEM_DEF_LEVEL');
894: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_DEFINITION_LEVEL_DESC', FALSE);
895: Manage_Error_Code('IN', 'APP-43000', Curr_Error);
896: RAISE Error;
897:
890:
891: ELSE
892:
893: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ITEM_DEF_LEVEL');
894: FND_MESSAGE.Set_Token('COLUMN', 'ITEM_DEFINITION_LEVEL_DESC', FALSE);
895: Manage_Error_Code('IN', 'APP-43000', Curr_Error);
896: RAISE Error;
897:
898: END IF;
898: END IF;
899:
900: ELSE
901:
902: FND_MESSAGE.Set_Name('INV', 'INV_NO_ITEM_DEF_LEVEL');
903: Manage_Error_Code('IN', 'APP-43001', Curr_Error);
904: RAISE Error;
905:
906: END IF;
908: EXCEPTION
909:
910: WHEN NO_DATA_FOUND THEN
911:
912: FND_MESSAGE.Set_Name('INV', 'INV_NO_SEED_DATA_ITEM_DEF');
913: Manage_Error_Code('IN', 'APP-43047', Curr_Error);
914: RAISE Error;
915:
916: WHEN TOO_MANY_ROWS THEN
914: RAISE Error;
915:
916: WHEN TOO_MANY_ROWS THEN
917:
918: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_ITEM_DEF');
919: Manage_Error_Code('IN', 'APP-43048', Curr_Error);
920: RAISE Error;
921:
922: END Validate_CI_Def_Level;
945: AND CUST_ACCT.CUST_ACCOUNT_ID = P_Customer_Id;
946:
947: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
948:
949: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_CUSTOMER');
950: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID', FALSE);
951: Manage_Error_Code('IN', 'APP-43002', Curr_Error);
952: RAISE Error;
953:
946:
947: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
948:
949: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_CUSTOMER');
950: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID', FALSE);
951: Manage_Error_Code('IN', 'APP-43002', Curr_Error);
952: RAISE Error;
953:
954: ELSE
973: AND CUST_ACCT.ACCOUNT_NUMBER = P_Customer_Number;
974:
975: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
976:
977: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_CUSTOMER');
978: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NUMBER', FALSE);
979: Manage_Error_Code('IN', 'APP-43002', Curr_Error);
980: RAISE Error;
981:
974:
975: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
976:
977: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_CUSTOMER');
978: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NUMBER', FALSE);
979: Manage_Error_Code('IN', 'APP-43002', Curr_Error);
980: RAISE Error;
981:
982: ELSE
1001: AND PARTY.PARTY_NAME like P_Customer_Name || '%';
1002:
1003: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
1004:
1005: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_CUSTOMER');
1006: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NAME', FALSE);
1007: Manage_Error_Code('IN', 'APP-43002', Curr_Error);
1008: RAISE Error;
1009:
1002:
1003: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
1004:
1005: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_CUSTOMER');
1006: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NAME', FALSE);
1007: Manage_Error_Code('IN', 'APP-43002', Curr_Error);
1008: RAISE Error;
1009:
1010: ELSE
1016: END IF;
1017:
1018: ELSE
1019:
1020: FND_MESSAGE.Set_Name('INV', 'INV_NO_CUSTOMER');
1021: Manage_Error_Code('IN', 'APP-43003', Curr_Error);
1022: RAISE Error;
1023:
1024: END IF;
1026: EXCEPTION
1027:
1028: WHEN NO_DATA_FOUND THEN
1029:
1030: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CUSTOMER');
1031: IF (P_Customer_Id IS NOT NULL) THEN
1032: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID', FALSE);
1033: ELSIF ((P_Customer_Id IS NULL) AND (P_Customer_Number IS NOT NULL)) THEN
1034: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NUMBER', FALSE);
1028: WHEN NO_DATA_FOUND THEN
1029:
1030: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CUSTOMER');
1031: IF (P_Customer_Id IS NOT NULL) THEN
1032: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID', FALSE);
1033: ELSIF ((P_Customer_Id IS NULL) AND (P_Customer_Number IS NOT NULL)) THEN
1034: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NUMBER', FALSE);
1035: ELSE
1036: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NAME', FALSE);
1030: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CUSTOMER');
1031: IF (P_Customer_Id IS NOT NULL) THEN
1032: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID', FALSE);
1033: ELSIF ((P_Customer_Id IS NULL) AND (P_Customer_Number IS NOT NULL)) THEN
1034: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NUMBER', FALSE);
1035: ELSE
1036: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NAME', FALSE);
1037: END IF;
1038: Manage_Error_Code('IN', 'APP-43004', Curr_Error);
1032: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID', FALSE);
1033: ELSIF ((P_Customer_Id IS NULL) AND (P_Customer_Number IS NOT NULL)) THEN
1034: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NUMBER', FALSE);
1035: ELSE
1036: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_NAME', FALSE);
1037: END IF;
1038: Manage_Error_Code('IN', 'APP-43004', Curr_Error);
1039: RAISE Error;
1040:
1039: RAISE Error;
1040:
1041: WHEN TOO_MANY_ROWS THEN
1042:
1043: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_CUSTOMERS');
1044: Manage_Error_Code('IN', 'APP-43005', Curr_Error);
1045: RAISE Error;
1046:
1047: END Validate_Customer;
1090: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);
1091:
1092: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
1093:
1094: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDRESS');
1095: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1096: Manage_Error_Code('IN', 'APP-43006', Curr_Error);
1097: RAISE Error;
1098:
1091:
1092: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
1093:
1094: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDRESS');
1095: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1096: Manage_Error_Code('IN', 'APP-43006', Curr_Error);
1097: RAISE Error;
1098:
1099: ELSE
1153:
1154:
1155: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
1156:
1157: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDRESS');
1158: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1159: Manage_Error_Code('IN', 'APP-43006', Curr_Error);
1160: RAISE Error;
1161:
1154:
1155: IF ((SQL%FOUND) AND (Temp_Status <> 'A')) THEN
1156:
1157: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDRESS');
1158: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1159: Manage_Error_Code('IN', 'APP-43006', Curr_Error);
1160: RAISE Error;
1161:
1162: ELSE
1168: END IF;
1169:
1170: ELSE
1171:
1172: FND_MESSAGE.Set_Name('INV', 'INV_NO_ADDRESS');
1173: Manage_Error_Code('IN', 'APP-43007', Curr_Error);
1174: RAISE Error;
1175:
1176: END IF;
1178: EXCEPTION
1179:
1180: WHEN NO_DATA_FOUND THEN
1181:
1182: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ADDRESS');
1183: IF (P_Address_Id IS NOT NULL) THEN
1184: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1185: ELSE
1186: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS1-4, CITY, STATE, ETC.', FALSE);
1180: WHEN NO_DATA_FOUND THEN
1181:
1182: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ADDRESS');
1183: IF (P_Address_Id IS NOT NULL) THEN
1184: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1185: ELSE
1186: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS1-4, CITY, STATE, ETC.', FALSE);
1187: END IF;
1188: Manage_Error_Code('IN', 'APP-43008', Curr_Error);
1182: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ADDRESS');
1183: IF (P_Address_Id IS NOT NULL) THEN
1184: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS_ID', FALSE);
1185: ELSE
1186: FND_MESSAGE.Set_Token('COLUMN', 'ADDRESS1-4, CITY, STATE, ETC.', FALSE);
1187: END IF;
1188: Manage_Error_Code('IN', 'APP-43008', Curr_Error);
1189: RAISE Error;
1190:
1189: RAISE Error;
1190:
1191: WHEN TOO_MANY_ROWS THEN
1192:
1193: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_ADDRESSES');
1194: Manage_Error_Code('IN', 'APP-43009', Curr_Error);
1195: RAISE Error;
1196:
1197: END Validate_Address;
1217: AND rownum = 1;
1218:
1219: IF ((SQL%FOUND) AND (Temp_Enabled_Flag = 'N')) THEN
1220:
1221: FND_MESSAGE.Set_Name('INV', 'INV_DISABLED_ADDR_CAT');
1222: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1223: Manage_Error_Code('IN', 'APP-43010', Curr_Error);
1224: RAISE Error;
1225:
1218:
1219: IF ((SQL%FOUND) AND (Temp_Enabled_Flag = 'N')) THEN
1220:
1221: FND_MESSAGE.Set_Name('INV', 'INV_DISABLED_ADDR_CAT');
1222: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1223: Manage_Error_Code('IN', 'APP-43010', Curr_Error);
1224: RAISE Error;
1225:
1226: ELSIF ((SQL%FOUND) AND NOT (TRUNC(SYSDATE) BETWEEN NVL(TRUNC((Temp_Start_Date_Active)),SYSDATE)AND NVL(TRUNC((Temp_End_Date_Active)), SYSDATE))) THEN
1224: RAISE Error;
1225:
1226: ELSIF ((SQL%FOUND) AND NOT (TRUNC(SYSDATE) BETWEEN NVL(TRUNC((Temp_Start_Date_Active)),SYSDATE)AND NVL(TRUNC((Temp_End_Date_Active)), SYSDATE))) THEN
1227:
1228: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDR_CAT');
1229: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1230: Manage_Error_Code('IN', 'APP-43011', Curr_Error);
1231: RAISE Error;
1232:
1225:
1226: ELSIF ((SQL%FOUND) AND NOT (TRUNC(SYSDATE) BETWEEN NVL(TRUNC((Temp_Start_Date_Active)),SYSDATE)AND NVL(TRUNC((Temp_End_Date_Active)), SYSDATE))) THEN
1227:
1228: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDR_CAT');
1229: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1230: Manage_Error_Code('IN', 'APP-43011', Curr_Error);
1231: RAISE Error;
1232:
1233: ELSE
1248: AND rownum = 1;
1249:
1250: IF ((SQL%FOUND) AND (Temp_Enabled_Flag = 'N')) THEN
1251:
1252: FND_MESSAGE.Set_Name('INV', 'INV_DISABLED_ADDR_CAT');
1253: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1254: Manage_Error_Code('IN', 'APP-43010', Curr_Error);
1255: RAISE Error;
1256:
1249:
1250: IF ((SQL%FOUND) AND (Temp_Enabled_Flag = 'N')) THEN
1251:
1252: FND_MESSAGE.Set_Name('INV', 'INV_DISABLED_ADDR_CAT');
1253: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1254: Manage_Error_Code('IN', 'APP-43010', Curr_Error);
1255: RAISE Error;
1256:
1257: ELSIF ((SQL%FOUND) AND NOT (TRUNC(SYSDATE) BETWEEN NVL(TRUNC((Temp_Start_Date_Active)),SYSDATE)AND NVL(TRUNC((Temp_End_Date_Active)), SYSDATE))) THEN
1255: RAISE Error;
1256:
1257: ELSIF ((SQL%FOUND) AND NOT (TRUNC(SYSDATE) BETWEEN NVL(TRUNC((Temp_Start_Date_Active)),SYSDATE)AND NVL(TRUNC((Temp_End_Date_Active)), SYSDATE))) THEN
1258:
1259: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDR_CAT');
1260: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1261: Manage_Error_Code('IN', 'APP-43011', Curr_Error);
1262: RAISE Error;
1263:
1256:
1257: ELSIF ((SQL%FOUND) AND NOT (TRUNC(SYSDATE) BETWEEN NVL(TRUNC((Temp_Start_Date_Active)),SYSDATE)AND NVL(TRUNC((Temp_End_Date_Active)), SYSDATE))) THEN
1258:
1259: FND_MESSAGE.Set_Name('INV', 'INV_INACTIVE_ADDR_CAT');
1260: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1261: Manage_Error_Code('IN', 'APP-43011', Curr_Error);
1262: RAISE Error;
1263:
1264: ELSE
1270: END IF;
1271:
1272: ELSE
1273:
1274: FND_MESSAGE.Set_Name('INV', 'INV_NO_ADDR_CAT');
1275: Manage_Error_Code('IN', 'APP-43012', Curr_Error);
1276: RAISE Error;
1277:
1278: END IF;
1280: EXCEPTION
1281:
1282: WHEN NO_DATA_FOUND THEN
1283:
1284: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ADDR_CAT');
1285: IF (P_Customer_Category_Code IS NOT NULL) THEN
1286: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1287: ELSE
1288: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1282: WHEN NO_DATA_FOUND THEN
1283:
1284: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ADDR_CAT');
1285: IF (P_Customer_Category_Code IS NOT NULL) THEN
1286: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1287: ELSE
1288: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1289: END IF;
1290: Manage_Error_Code('IN', 'APP-43013', Curr_Error);
1284: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ADDR_CAT');
1285: IF (P_Customer_Category_Code IS NOT NULL) THEN
1286: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY_CODE', FALSE);
1287: ELSE
1288: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_CATEGORY', FALSE);
1289: END IF;
1290: Manage_Error_Code('IN', 'APP-43013', Curr_Error);
1291: RAISE Error;
1292:
1374: AND id_flex_code = 'MSTK'
1375: AND upper(enabled_flag) = 'Y';
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: FND_MESSAGE.Set_Name('INV', 'INV_NO_ITEM_FLEX_STRUCT');
1379: Manage_Error_Code('IN', 'APP-43014',
1380: Curr_Error);
1381: RAISE Error;
1382:
1380: Curr_Error);
1381: RAISE Error;
1382:
1383: WHEN TOO_MANY_ROWS THEN
1384: FND_MESSAGE.Set_Name('INV',
1385: 'INV_MULT_ITEM_FLEX_STRUCT');
1386: Manage_Error_Code('IN', 'APP-43014',
1387: Curr_Error);
1388: RAISE Error;
1408: end if;
1409:
1410: If P_Container_Item_Id is NULL then
1411:
1412: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CONTAINER');
1413: FND_MESSAGE.Set_Token('COLUMN',
1414: 'CONTAINER_ITEM', FALSE);
1415: Manage_Error_Code('IN', 'APP-43014',
1416: Curr_Error);
1409:
1410: If P_Container_Item_Id is NULL then
1411:
1412: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CONTAINER');
1413: FND_MESSAGE.Set_Token('COLUMN',
1414: 'CONTAINER_ITEM', FALSE);
1415: Manage_Error_Code('IN', 'APP-43014',
1416: Curr_Error);
1417: RAISE Error;
1428: AND id_flex_code = 'MSTK'
1429: AND upper(enabled_flag) = 'Y';
1430: EXCEPTION
1431: WHEN NO_DATA_FOUND THEN
1432: FND_MESSAGE.Set_Name('INV', 'INV_NO_ITEM_FLEX_STRUCT');
1433: Manage_Error_Code('IN', 'APP-43014',
1434: Curr_Error);
1435: RAISE Error;
1436:
1434: Curr_Error);
1435: RAISE Error;
1436:
1437: WHEN TOO_MANY_ROWS THEN
1438: FND_MESSAGE.Set_Name('INV',
1439: 'INV_MULT_ITEM_FLEX_STRUCT');
1440: Manage_Error_Code('IN', 'APP-43014',
1441: Curr_Error);
1442: RAISE Error;
1468: and application_column_name = 'SEGMENT1';
1469:
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: FND_MESSAGE.Set_Name('INV',
1473: 'INV_INVALID_CONTAINER_SEG');
1474: FND_MESSAGE.Set_Token('SEGMENT',
1475: 'CONTAINER_SEGMENT1',
1476: FALSE);
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: FND_MESSAGE.Set_Name('INV',
1473: 'INV_INVALID_CONTAINER_SEG');
1474: FND_MESSAGE.Set_Token('SEGMENT',
1475: 'CONTAINER_SEGMENT1',
1476: FALSE);
1477: Manage_Error_Code('IN', 'APP-43014',
1478: Curr_Error);
1478: Curr_Error);
1479: RAISE Error;
1480:
1481: WHEN TOO_MANY_ROWS THEN
1482: FND_MESSAGE.Set_Name('INV',
1483: 'INV_MULTIPLE_FLEX_SEG');
1484: Manage_Error_Code('IN', 'APP-43014',
1485: Curr_Error);
1486: RAISE Error;
1500: if L_SegNumIndex <= L_FlexSeg_Counter then
1501: L_Segment_Array(L_SegNumIndex) :=
1502: P_Container_Item_Segment1;
1503: else
1504: FND_MESSAGE.Set_Name('INV',
1505: 'INV_FLEX_SEG_OUT_OF_RANGE');
1506: Manage_Error_Code('IN', 'APP-43014',
1507: Curr_Error);
1508: RAISE Error;
1524: and application_column_name = 'SEGMENT2';
1525:
1526: EXCEPTION
1527: WHEN NO_DATA_FOUND THEN
1528: FND_MESSAGE.Set_Name('INV',
1529: 'INV_INVALID_CONTAINER_SEG');
1530: FND_MESSAGE.Set_Token('SEGMENT',
1531: 'CONTAINER_SEGMENT2',
1532: FALSE);
1526: EXCEPTION
1527: WHEN NO_DATA_FOUND THEN
1528: FND_MESSAGE.Set_Name('INV',
1529: 'INV_INVALID_CONTAINER_SEG');
1530: FND_MESSAGE.Set_Token('SEGMENT',
1531: 'CONTAINER_SEGMENT2',
1532: FALSE);
1533: Manage_Error_Code('IN', 'APP-43014',
1534: Curr_Error);
1534: Curr_Error);
1535: RAISE Error;
1536:
1537: WHEN TOO_MANY_ROWS THEN
1538: FND_MESSAGE.Set_Name('INV',
1539: 'INV_MULTIPLE_FLEX_SEG');
1540: Manage_Error_Code('IN', 'APP-43014',
1541: Curr_Error);
1542: RAISE Error;
1556: if L_SegNumIndex <= L_FlexSeg_Counter then
1557: L_Segment_Array(L_SegNumIndex) :=
1558: P_Container_Item_Segment2;
1559: else
1560: FND_MESSAGE.Set_Name('INV',
1561: 'INV_FLEX_SEG_OUT_OF_RANGE');
1562: Manage_Error_Code('IN', 'APP-43014',
1563: Curr_Error);
1564: RAISE Error;
1579: and application_column_name = 'SEGMENT3';
1580:
1581: EXCEPTION
1582: WHEN NO_DATA_FOUND THEN
1583: FND_MESSAGE.Set_Name('INV',
1584: 'INV_INVALID_CONTAINER_SEG');
1585: FND_MESSAGE.Set_Token('SEGMENT',
1586: 'CONTAINER_SEGMENT3',
1587: FALSE);
1581: EXCEPTION
1582: WHEN NO_DATA_FOUND THEN
1583: FND_MESSAGE.Set_Name('INV',
1584: 'INV_INVALID_CONTAINER_SEG');
1585: FND_MESSAGE.Set_Token('SEGMENT',
1586: 'CONTAINER_SEGMENT3',
1587: FALSE);
1588: Manage_Error_Code('IN', 'APP-43014',
1589: Curr_Error);
1589: Curr_Error);
1590: RAISE Error;
1591:
1592: WHEN TOO_MANY_ROWS THEN
1593: FND_MESSAGE.Set_Name('INV',
1594: 'INV_MULTIPLE_FLEX_SEG');
1595: Manage_Error_Code('IN', 'APP-43014',
1596: Curr_Error);
1597: RAISE Error;
1611: if L_SegNumIndex <= L_FlexSeg_Counter then
1612: L_Segment_Array(L_SegNumIndex) :=
1613: P_Container_Item_Segment3;
1614: else
1615: FND_MESSAGE.Set_Name('INV',
1616: 'INV_FLEX_SEG_OUT_OF_RANGE');
1617: Manage_Error_Code('IN', 'APP-43014',
1618: Curr_Error);
1619: RAISE Error;
1634: and application_column_name = 'SEGMENT4';
1635:
1636: EXCEPTION
1637: WHEN NO_DATA_FOUND THEN
1638: FND_MESSAGE.Set_Name('INV',
1639: 'INV_INVALID_CONTAINER_SEG');
1640: FND_MESSAGE.Set_Token('SEGMENT',
1641: 'CONTAINER_SEGMENT4',
1642: FALSE);
1636: EXCEPTION
1637: WHEN NO_DATA_FOUND THEN
1638: FND_MESSAGE.Set_Name('INV',
1639: 'INV_INVALID_CONTAINER_SEG');
1640: FND_MESSAGE.Set_Token('SEGMENT',
1641: 'CONTAINER_SEGMENT4',
1642: FALSE);
1643: Manage_Error_Code('IN', 'APP-43014',
1644: Curr_Error);
1644: Curr_Error);
1645: RAISE Error;
1646:
1647: WHEN TOO_MANY_ROWS THEN
1648: FND_MESSAGE.Set_Name('INV',
1649: 'INV_MULTIPLE_FLEX_SEG');
1650: Manage_Error_Code('IN', 'APP-43014',
1651: Curr_Error);
1652: RAISE Error;
1666: if L_SegNumIndex <= L_FlexSeg_Counter then
1667: L_Segment_Array(L_SegNumIndex) :=
1668: P_Container_Item_Segment4;
1669: else
1670: FND_MESSAGE.Set_Name('INV',
1671: 'INV_FLEX_SEG_OUT_OF_RANGE');
1672: Manage_Error_Code('IN', 'APP-43014',
1673: Curr_Error);
1674: RAISE Error;
1689: and application_column_name = 'SEGMENT5';
1690:
1691: EXCEPTION
1692: WHEN NO_DATA_FOUND THEN
1693: FND_MESSAGE.Set_Name('INV',
1694: 'INV_INVALID_CONTAINER_SEG');
1695: FND_MESSAGE.Set_Token('SEGMENT',
1696: 'CONTAINER_SEGMENT5',
1697: FALSE);
1691: EXCEPTION
1692: WHEN NO_DATA_FOUND THEN
1693: FND_MESSAGE.Set_Name('INV',
1694: 'INV_INVALID_CONTAINER_SEG');
1695: FND_MESSAGE.Set_Token('SEGMENT',
1696: 'CONTAINER_SEGMENT5',
1697: FALSE);
1698: Manage_Error_Code('IN', 'APP-43014',
1699: Curr_Error);
1699: Curr_Error);
1700: RAISE Error;
1701:
1702: WHEN TOO_MANY_ROWS THEN
1703: FND_MESSAGE.Set_Name('INV',
1704: 'INV_MULTIPLE_FLEX_SEG');
1705: Manage_Error_Code('IN', 'APP-43014',
1706: Curr_Error);
1707: RAISE Error;
1721: if L_SegNumIndex <= L_FlexSeg_Counter then
1722: L_Segment_Array(L_SegNumIndex) :=
1723: P_Container_Item_Segment5;
1724: else
1725: FND_MESSAGE.Set_Name('INV',
1726: 'INV_FLEX_SEG_OUT_OF_RANGE');
1727: Manage_Error_Code('IN', 'APP-43014',
1728: Curr_Error);
1729: RAISE Error;
1744: and application_column_name = 'SEGMENT6';
1745:
1746: EXCEPTION
1747: WHEN NO_DATA_FOUND THEN
1748: FND_MESSAGE.Set_Name('INV',
1749: 'INV_INVALID_CONTAINER_SEG');
1750: FND_MESSAGE.Set_Token('SEGMENT',
1751: 'CONTAINER_SEGMENT6',
1752: FALSE);
1746: EXCEPTION
1747: WHEN NO_DATA_FOUND THEN
1748: FND_MESSAGE.Set_Name('INV',
1749: 'INV_INVALID_CONTAINER_SEG');
1750: FND_MESSAGE.Set_Token('SEGMENT',
1751: 'CONTAINER_SEGMENT6',
1752: FALSE);
1753: Manage_Error_Code('IN', 'APP-43014',
1754: Curr_Error);
1754: Curr_Error);
1755: RAISE Error;
1756:
1757: WHEN TOO_MANY_ROWS THEN
1758: FND_MESSAGE.Set_Name('INV',
1759: 'INV_MULTIPLE_FLEX_SEG');
1760: Manage_Error_Code('IN', 'APP-43014',
1761: Curr_Error);
1762: RAISE Error;
1776: if L_SegNumIndex <= L_FlexSeg_Counter then
1777: L_Segment_Array(L_SegNumIndex) :=
1778: P_Container_Item_Segment6;
1779: else
1780: FND_MESSAGE.Set_Name('INV',
1781: 'INV_FLEX_SEG_OUT_OF_RANGE');
1782: Manage_Error_Code('IN', 'APP-43014',
1783: Curr_Error);
1784: RAISE Error;
1799: and application_column_name = 'SEGMENT7';
1800:
1801: EXCEPTION
1802: WHEN NO_DATA_FOUND THEN
1803: FND_MESSAGE.Set_Name('INV',
1804: 'INV_INVALID_CONTAINER_SEG');
1805: FND_MESSAGE.Set_Token('SEGMENT',
1806: 'CONTAINER_SEGMENT7',
1807: FALSE);
1801: EXCEPTION
1802: WHEN NO_DATA_FOUND THEN
1803: FND_MESSAGE.Set_Name('INV',
1804: 'INV_INVALID_CONTAINER_SEG');
1805: FND_MESSAGE.Set_Token('SEGMENT',
1806: 'CONTAINER_SEGMENT7',
1807: FALSE);
1808: Manage_Error_Code('IN', 'APP-43014',
1809: Curr_Error);
1809: Curr_Error);
1810: RAISE Error;
1811:
1812: WHEN TOO_MANY_ROWS THEN
1813: FND_MESSAGE.Set_Name('INV',
1814: 'INV_MULTIPLE_FLEX_SEG');
1815: Manage_Error_Code('IN', 'APP-43014',
1816: Curr_Error);
1817: RAISE Error;
1831: if L_SegNumIndex <= L_FlexSeg_Counter then
1832: L_Segment_Array(L_SegNumIndex) :=
1833: P_Container_Item_Segment7;
1834: else
1835: FND_MESSAGE.Set_Name('INV',
1836: 'INV_FLEX_SEG_OUT_OF_RANGE');
1837: Manage_Error_Code('IN', 'APP-43014',
1838: Curr_Error);
1839: RAISE Error;
1854: and application_column_name = 'SEGMENT8';
1855:
1856: EXCEPTION
1857: WHEN NO_DATA_FOUND THEN
1858: FND_MESSAGE.Set_Name('INV',
1859: 'INV_INVALID_CONTAINER_SEG');
1860: FND_MESSAGE.Set_Token('SEGMENT',
1861: 'CONTAINER_SEGMENT8',
1862: FALSE);
1856: EXCEPTION
1857: WHEN NO_DATA_FOUND THEN
1858: FND_MESSAGE.Set_Name('INV',
1859: 'INV_INVALID_CONTAINER_SEG');
1860: FND_MESSAGE.Set_Token('SEGMENT',
1861: 'CONTAINER_SEGMENT8',
1862: FALSE);
1863: Manage_Error_Code('IN', 'APP-43014',
1864: Curr_Error);
1864: Curr_Error);
1865: RAISE Error;
1866:
1867: WHEN TOO_MANY_ROWS THEN
1868: FND_MESSAGE.Set_Name('INV',
1869: 'INV_MULTIPLE_FLEX_SEG');
1870: Manage_Error_Code('IN', 'APP-43014',
1871: Curr_Error);
1872: RAISE Error;
1886: if L_SegNumIndex <= L_FlexSeg_Counter then
1887: L_Segment_Array(L_SegNumIndex) :=
1888: P_Container_Item_Segment8;
1889: else
1890: FND_MESSAGE.Set_Name('INV',
1891: 'INV_FLEX_SEG_OUT_OF_RANGE');
1892: Manage_Error_Code('IN', 'APP-43014',
1893: Curr_Error);
1894: RAISE Error;
1909: and application_column_name = 'SEGMENT9';
1910:
1911: EXCEPTION
1912: WHEN NO_DATA_FOUND THEN
1913: FND_MESSAGE.Set_Name('INV',
1914: 'INV_INVALID_CONTAINER_SEG');
1915: FND_MESSAGE.Set_Token('SEGMENT',
1916: 'CONTAINER_SEGMENT9',
1917: FALSE);
1911: EXCEPTION
1912: WHEN NO_DATA_FOUND THEN
1913: FND_MESSAGE.Set_Name('INV',
1914: 'INV_INVALID_CONTAINER_SEG');
1915: FND_MESSAGE.Set_Token('SEGMENT',
1916: 'CONTAINER_SEGMENT9',
1917: FALSE);
1918: Manage_Error_Code('IN', 'APP-43014',
1919: Curr_Error);
1919: Curr_Error);
1920: RAISE Error;
1921:
1922: WHEN TOO_MANY_ROWS THEN
1923: FND_MESSAGE.Set_Name('INV',
1924: 'INV_MULTIPLE_FLEX_SEG');
1925: Manage_Error_Code('IN', 'APP-43014',
1926: Curr_Error);
1927: RAISE Error;
1941: if L_SegNumIndex <= L_FlexSeg_Counter then
1942: L_Segment_Array(L_SegNumIndex) :=
1943: P_Container_Item_Segment9;
1944: else
1945: FND_MESSAGE.Set_Name('INV',
1946: 'INV_FLEX_SEG_OUT_OF_RANGE');
1947: Manage_Error_Code('IN', 'APP-43014',
1948: Curr_Error);
1949: RAISE Error;
1964: and application_column_name = 'SEGMENT10';
1965:
1966: EXCEPTION
1967: WHEN NO_DATA_FOUND THEN
1968: FND_MESSAGE.Set_Name('INV',
1969: 'INV_INVALID_CONTAINER_SEG');
1970: FND_MESSAGE.Set_Token('SEGMENT',
1971: 'CONTAINER_SEGMENT10',
1972: FALSE);
1966: EXCEPTION
1967: WHEN NO_DATA_FOUND THEN
1968: FND_MESSAGE.Set_Name('INV',
1969: 'INV_INVALID_CONTAINER_SEG');
1970: FND_MESSAGE.Set_Token('SEGMENT',
1971: 'CONTAINER_SEGMENT10',
1972: FALSE);
1973: Manage_Error_Code('IN', 'APP-43014',
1974: Curr_Error);
1974: Curr_Error);
1975: RAISE Error;
1976:
1977: WHEN TOO_MANY_ROWS THEN
1978: FND_MESSAGE.Set_Name('INV',
1979: 'INV_MULTIPLE_FLEX_SEG');
1980: Manage_Error_Code('IN', 'APP-43014',
1981: Curr_Error);
1982: RAISE Error;
1996: if L_SegNumIndex <= L_FlexSeg_Counter then
1997: L_Segment_Array(L_SegNumIndex) :=
1998: P_Container_Item_Segment10;
1999: else
2000: FND_MESSAGE.Set_Name('INV',
2001: 'INV_FLEX_SEG_OUT_OF_RANGE');
2002: Manage_Error_Code('IN', 'APP-43014',
2003: Curr_Error);
2004: RAISE Error;
2019: and application_column_name = 'SEGMENT11';
2020:
2021: EXCEPTION
2022: WHEN NO_DATA_FOUND THEN
2023: FND_MESSAGE.Set_Name('INV',
2024: 'INV_INVALID_CONTAINER_SEG');
2025: FND_MESSAGE.Set_Token('SEGMENT',
2026: 'CONTAINER_SEGMENT11',
2027: FALSE);
2021: EXCEPTION
2022: WHEN NO_DATA_FOUND THEN
2023: FND_MESSAGE.Set_Name('INV',
2024: 'INV_INVALID_CONTAINER_SEG');
2025: FND_MESSAGE.Set_Token('SEGMENT',
2026: 'CONTAINER_SEGMENT11',
2027: FALSE);
2028: Manage_Error_Code('IN', 'APP-43014',
2029: Curr_Error);
2029: Curr_Error);
2030: RAISE Error;
2031:
2032: WHEN TOO_MANY_ROWS THEN
2033: FND_MESSAGE.Set_Name('INV',
2034: 'INV_MULTIPLE_FLEX_SEG');
2035: Manage_Error_Code('IN', 'APP-43014',
2036: Curr_Error);
2037: RAISE Error;
2051: if L_SegNumIndex <= L_FlexSeg_Counter then
2052: L_Segment_Array(L_SegNumIndex) :=
2053: P_Container_Item_Segment11;
2054: else
2055: FND_MESSAGE.Set_Name('INV',
2056: 'INV_FLEX_SEG_OUT_OF_RANGE');
2057: Manage_Error_Code('IN', 'APP-43014',
2058: Curr_Error);
2059: RAISE Error;
2074: and application_column_name = 'SEGMENT12';
2075:
2076: EXCEPTION
2077: WHEN NO_DATA_FOUND THEN
2078: FND_MESSAGE.Set_Name('INV',
2079: 'INV_INVALID_CONTAINER_SEG');
2080: FND_MESSAGE.Set_Token('SEGMENT',
2081: 'CONTAINER_SEGMENT12',
2082: FALSE);
2076: EXCEPTION
2077: WHEN NO_DATA_FOUND THEN
2078: FND_MESSAGE.Set_Name('INV',
2079: 'INV_INVALID_CONTAINER_SEG');
2080: FND_MESSAGE.Set_Token('SEGMENT',
2081: 'CONTAINER_SEGMENT12',
2082: FALSE);
2083: Manage_Error_Code('IN', 'APP-43014',
2084: Curr_Error);
2084: Curr_Error);
2085: RAISE Error;
2086:
2087: WHEN TOO_MANY_ROWS THEN
2088: FND_MESSAGE.Set_Name('INV',
2089: 'INV_MULTIPLE_FLEX_SEG');
2090: Manage_Error_Code('IN', 'APP-43014',
2091: Curr_Error);
2092: RAISE Error;
2106: if L_SegNumIndex <= L_FlexSeg_Counter then
2107: L_Segment_Array(L_SegNumIndex) :=
2108: P_Container_Item_Segment12;
2109: else
2110: FND_MESSAGE.Set_Name('INV',
2111: 'INV_FLEX_SEG_OUT_OF_RANGE');
2112: Manage_Error_Code('IN', 'APP-43014',
2113: Curr_Error);
2114: RAISE Error;
2129: and application_column_name = 'SEGMENT13';
2130:
2131: EXCEPTION
2132: WHEN NO_DATA_FOUND THEN
2133: FND_MESSAGE.Set_Name('INV',
2134: 'INV_INVALID_CONTAINER_SEG');
2135: FND_MESSAGE.Set_Token('SEGMENT',
2136: 'CONTAINER_SEGMENT13',
2137: FALSE);
2131: EXCEPTION
2132: WHEN NO_DATA_FOUND THEN
2133: FND_MESSAGE.Set_Name('INV',
2134: 'INV_INVALID_CONTAINER_SEG');
2135: FND_MESSAGE.Set_Token('SEGMENT',
2136: 'CONTAINER_SEGMENT13',
2137: FALSE);
2138: Manage_Error_Code('IN', 'APP-43014',
2139: Curr_Error);
2139: Curr_Error);
2140: RAISE Error;
2141:
2142: WHEN TOO_MANY_ROWS THEN
2143: FND_MESSAGE.Set_Name('INV',
2144: 'INV_MULTIPLE_FLEX_SEG');
2145: Manage_Error_Code('IN', 'APP-43014',
2146: Curr_Error);
2147: RAISE Error;
2161: if L_SegNumIndex <= L_FlexSeg_Counter then
2162: L_Segment_Array(L_SegNumIndex) :=
2163: P_Container_Item_Segment13;
2164: else
2165: FND_MESSAGE.Set_Name('INV',
2166: 'INV_FLEX_SEG_OUT_OF_RANGE');
2167: Manage_Error_Code('IN', 'APP-43014',
2168: Curr_Error);
2169: RAISE Error;
2184: and application_column_name = 'SEGMENT14';
2185:
2186: EXCEPTION
2187: WHEN NO_DATA_FOUND THEN
2188: FND_MESSAGE.Set_Name('INV',
2189: 'INV_INVALID_CONTAINER_SEG');
2190: FND_MESSAGE.Set_Token('SEGMENT',
2191: 'CONTAINER_SEGMENT14',
2192: FALSE);
2186: EXCEPTION
2187: WHEN NO_DATA_FOUND THEN
2188: FND_MESSAGE.Set_Name('INV',
2189: 'INV_INVALID_CONTAINER_SEG');
2190: FND_MESSAGE.Set_Token('SEGMENT',
2191: 'CONTAINER_SEGMENT14',
2192: FALSE);
2193: Manage_Error_Code('IN', 'APP-43014',
2194: Curr_Error);
2194: Curr_Error);
2195: RAISE Error;
2196:
2197: WHEN TOO_MANY_ROWS THEN
2198: FND_MESSAGE.Set_Name('INV',
2199: 'INV_MULTIPLE_FLEX_SEG');
2200: Manage_Error_Code('IN', 'APP-43014',
2201: Curr_Error);
2202: RAISE Error;
2216: if L_SegNumIndex <= L_FlexSeg_Counter then
2217: L_Segment_Array(L_SegNumIndex) :=
2218: P_Container_Item_Segment14;
2219: else
2220: FND_MESSAGE.Set_Name('INV',
2221: 'INV_FLEX_SEG_OUT_OF_RANGE');
2222: Manage_Error_Code('IN', 'APP-43014',
2223: Curr_Error);
2224: RAISE Error;
2239: and application_column_name = 'SEGMENT15';
2240:
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: FND_MESSAGE.Set_Name('INV',
2244: 'INV_INVALID_CONTAINER_SEG');
2245: FND_MESSAGE.Set_Token('SEGMENT',
2246: 'CONTAINER_SEGMENT15',
2247: FALSE);
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: FND_MESSAGE.Set_Name('INV',
2244: 'INV_INVALID_CONTAINER_SEG');
2245: FND_MESSAGE.Set_Token('SEGMENT',
2246: 'CONTAINER_SEGMENT15',
2247: FALSE);
2248: Manage_Error_Code('IN', 'APP-43014',
2249: Curr_Error);
2249: Curr_Error);
2250: RAISE Error;
2251:
2252: WHEN TOO_MANY_ROWS THEN
2253: FND_MESSAGE.Set_Name('INV',
2254: 'INV_MULTIPLE_FLEX_SEG');
2255: Manage_Error_Code('IN', 'APP-43014',
2256: Curr_Error);
2257: RAISE Error;
2271: if L_SegNumIndex <= L_FlexSeg_Counter then
2272: L_Segment_Array(L_SegNumIndex) :=
2273: P_Container_Item_Segment15;
2274: else
2275: FND_MESSAGE.Set_Name('INV',
2276: 'INV_FLEX_SEG_OUT_OF_RANGE');
2277: Manage_Error_Code('IN', 'APP-43014',
2278: Curr_Error);
2279: RAISE Error;
2294: and application_column_name = 'SEGMENT16';
2295:
2296: EXCEPTION
2297: WHEN NO_DATA_FOUND THEN
2298: FND_MESSAGE.Set_Name('INV',
2299: 'INV_INVALID_CONTAINER_SEG');
2300: FND_MESSAGE.Set_Token('SEGMENT',
2301: 'CONTAINER_SEGMENT16',
2302: FALSE);
2296: EXCEPTION
2297: WHEN NO_DATA_FOUND THEN
2298: FND_MESSAGE.Set_Name('INV',
2299: 'INV_INVALID_CONTAINER_SEG');
2300: FND_MESSAGE.Set_Token('SEGMENT',
2301: 'CONTAINER_SEGMENT16',
2302: FALSE);
2303: Manage_Error_Code('IN', 'APP-43014',
2304: Curr_Error);
2304: Curr_Error);
2305: RAISE Error;
2306:
2307: WHEN TOO_MANY_ROWS THEN
2308: FND_MESSAGE.Set_Name('INV',
2309: 'INV_MULTIPLE_FLEX_SEG');
2310: Manage_Error_Code('IN', 'APP-43014',
2311: Curr_Error);
2312: RAISE Error;
2326: if L_SegNumIndex <= L_FlexSeg_Counter then
2327: L_Segment_Array(L_SegNumIndex) :=
2328: P_Container_Item_Segment16;
2329: else
2330: FND_MESSAGE.Set_Name('INV',
2331: 'INV_FLEX_SEG_OUT_OF_RANGE');
2332: Manage_Error_Code('IN', 'APP-43014',
2333: Curr_Error);
2334: RAISE Error;
2349: and application_column_name = 'SEGMENT17';
2350:
2351: EXCEPTION
2352: WHEN NO_DATA_FOUND THEN
2353: FND_MESSAGE.Set_Name('INV',
2354: 'INV_INVALID_CONTAINER_SEG');
2355: FND_MESSAGE.Set_Token('SEGMENT',
2356: 'CONTAINER_SEGMENT17',
2357: FALSE);
2351: EXCEPTION
2352: WHEN NO_DATA_FOUND THEN
2353: FND_MESSAGE.Set_Name('INV',
2354: 'INV_INVALID_CONTAINER_SEG');
2355: FND_MESSAGE.Set_Token('SEGMENT',
2356: 'CONTAINER_SEGMENT17',
2357: FALSE);
2358: Manage_Error_Code('IN', 'APP-43014',
2359: Curr_Error);
2359: Curr_Error);
2360: RAISE Error;
2361:
2362: WHEN TOO_MANY_ROWS THEN
2363: FND_MESSAGE.Set_Name('INV',
2364: 'INV_MULTIPLE_FLEX_SEG');
2365: Manage_Error_Code('IN', 'APP-43014',
2366: Curr_Error);
2367: RAISE Error;
2381: if L_SegNumIndex <= L_FlexSeg_Counter then
2382: L_Segment_Array(L_SegNumIndex) :=
2383: P_Container_Item_Segment17;
2384: else
2385: FND_MESSAGE.Set_Name('INV',
2386: 'INV_FLEX_SEG_OUT_OF_RANGE');
2387: Manage_Error_Code('IN', 'APP-43014',
2388: Curr_Error);
2389: RAISE Error;
2404: and application_column_name = 'SEGMENT18';
2405:
2406: EXCEPTION
2407: WHEN NO_DATA_FOUND THEN
2408: FND_MESSAGE.Set_Name('INV',
2409: 'INV_INVALID_CONTAINER_SEG');
2410: FND_MESSAGE.Set_Token('SEGMENT',
2411: 'CONTAINER_SEGMENT18',
2412: FALSE);
2406: EXCEPTION
2407: WHEN NO_DATA_FOUND THEN
2408: FND_MESSAGE.Set_Name('INV',
2409: 'INV_INVALID_CONTAINER_SEG');
2410: FND_MESSAGE.Set_Token('SEGMENT',
2411: 'CONTAINER_SEGMENT18',
2412: FALSE);
2413: Manage_Error_Code('IN', 'APP-43014',
2414: Curr_Error);
2414: Curr_Error);
2415: RAISE Error;
2416:
2417: WHEN TOO_MANY_ROWS THEN
2418: FND_MESSAGE.Set_Name('INV',
2419: 'INV_MULTIPLE_FLEX_SEG');
2420: Manage_Error_Code('IN', 'APP-43014',
2421: Curr_Error);
2422: RAISE Error;
2436: if L_SegNumIndex <= L_FlexSeg_Counter then
2437: L_Segment_Array(L_SegNumIndex) :=
2438: P_Container_Item_Segment18;
2439: else
2440: FND_MESSAGE.Set_Name('INV',
2441: 'INV_FLEX_SEG_OUT_OF_RANGE');
2442: Manage_Error_Code('IN', 'APP-43014',
2443: Curr_Error);
2444: RAISE Error;
2459: and application_column_name = 'SEGMENT19';
2460:
2461: EXCEPTION
2462: WHEN NO_DATA_FOUND THEN
2463: FND_MESSAGE.Set_Name('INV',
2464: 'INV_INVALID_CONTAINER_SEG');
2465: FND_MESSAGE.Set_Token('SEGMENT',
2466: 'CONTAINER_SEGMENT19',
2467: FALSE);
2461: EXCEPTION
2462: WHEN NO_DATA_FOUND THEN
2463: FND_MESSAGE.Set_Name('INV',
2464: 'INV_INVALID_CONTAINER_SEG');
2465: FND_MESSAGE.Set_Token('SEGMENT',
2466: 'CONTAINER_SEGMENT19',
2467: FALSE);
2468: Manage_Error_Code('IN', 'APP-43014',
2469: Curr_Error);
2469: Curr_Error);
2470: RAISE Error;
2471:
2472: WHEN TOO_MANY_ROWS THEN
2473: FND_MESSAGE.Set_Name('INV',
2474: 'INV_MULTIPLE_FLEX_SEG');
2475: Manage_Error_Code('IN', 'APP-43014',
2476: Curr_Error);
2477: RAISE Error;
2491: if L_SegNumIndex <= L_FlexSeg_Counter then
2492: L_Segment_Array(L_SegNumIndex) :=
2493: P_Container_Item_Segment19;
2494: else
2495: FND_MESSAGE.Set_Name('INV',
2496: 'INV_FLEX_SEG_OUT_OF_RANGE');
2497: Manage_Error_Code('IN', 'APP-43014',
2498: Curr_Error);
2499: RAISE Error;
2514: and application_column_name = 'SEGMENT20';
2515:
2516: EXCEPTION
2517: WHEN NO_DATA_FOUND THEN
2518: FND_MESSAGE.Set_Name('INV',
2519: 'INV_INVALID_CONTAINER_SEG');
2520: FND_MESSAGE.Set_Token('SEGMENT',
2521: 'CONTAINER_SEGMENT20',
2522: FALSE);
2516: EXCEPTION
2517: WHEN NO_DATA_FOUND THEN
2518: FND_MESSAGE.Set_Name('INV',
2519: 'INV_INVALID_CONTAINER_SEG');
2520: FND_MESSAGE.Set_Token('SEGMENT',
2521: 'CONTAINER_SEGMENT20',
2522: FALSE);
2523: Manage_Error_Code('IN', 'APP-43014',
2524: Curr_Error);
2524: Curr_Error);
2525: RAISE Error;
2526:
2527: WHEN TOO_MANY_ROWS THEN
2528: FND_MESSAGE.Set_Name('INV',
2529: 'INV_MULTIPLE_FLEX_SEG');
2530: Manage_Error_Code('IN', 'APP-43014',
2531: Curr_Error);
2532: RAISE Error;
2546: if L_SegNumIndex <= L_FlexSeg_Counter then
2547: L_Segment_Array(L_SegNumIndex) :=
2548: P_Container_Item_Segment20;
2549: else
2550: FND_MESSAGE.Set_Name('INV',
2551: 'INV_FLEX_SEG_OUT_OF_RANGE');
2552: Manage_Error_Code('IN', 'APP-43014',
2553: Curr_Error);
2554: RAISE Error;
2566: L_FlexSeg_Counter,
2567: L_Segment_Array,
2568: L_Delimiter);
2569: else
2570: FND_MESSAGE.Set_Name('INV',
2571: 'INV_FLEX_SEG_MISMATCH');
2572: Manage_Error_Code('IN', 'APP-43014',
2573: Curr_Error);
2574: RAISE Error;
2596: end if;
2597:
2598: If P_Container_Item_Id is NULL then
2599:
2600: FND_MESSAGE.Set_Name('INV',
2601: 'INV_INVALID_CONTAINER');
2602: FND_MESSAGE.Set_Token('COLUMN',
2603: 'CONTAINER_ITEM', FALSE);
2604: Manage_Error_Code('IN', 'APP-43014',
2598: If P_Container_Item_Id is NULL then
2599:
2600: FND_MESSAGE.Set_Name('INV',
2601: 'INV_INVALID_CONTAINER');
2602: FND_MESSAGE.Set_Token('COLUMN',
2603: 'CONTAINER_ITEM', FALSE);
2604: Manage_Error_Code('IN', 'APP-43014',
2605: Curr_Error);
2606: RAISE Error;
2606: RAISE Error;
2607: END IF;
2608:
2609: else
2610: FND_MESSAGE.Set_Name('INV',
2611: 'INV_CONCAT_SEG_ERROR');
2612: Manage_Error_Code('IN', 'APP-43014',
2613: Curr_Error);
2614: RAISE Error;
2623: EXCEPTION
2624:
2625: WHEN NO_DATA_FOUND THEN
2626:
2627: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CONTAINER');
2628: IF (P_Container_Item_Id IS NOT NULL) THEN
2629: FND_MESSAGE.Set_Token('COLUMN',
2630: 'CONTAINER_ITEM_ID', FALSE);
2631: ELSIF ((P_Container_Item_Id IS NULL) AND
2625: WHEN NO_DATA_FOUND THEN
2626:
2627: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CONTAINER');
2628: IF (P_Container_Item_Id IS NOT NULL) THEN
2629: FND_MESSAGE.Set_Token('COLUMN',
2630: 'CONTAINER_ITEM_ID', FALSE);
2631: ELSIF ((P_Container_Item_Id IS NULL) AND
2632: (P_Container_Item IS NOT NULL)) THEN
2633: FND_MESSAGE.Set_Token('COLUMN',
2629: FND_MESSAGE.Set_Token('COLUMN',
2630: 'CONTAINER_ITEM_ID', FALSE);
2631: ELSIF ((P_Container_Item_Id IS NULL) AND
2632: (P_Container_Item IS NOT NULL)) THEN
2633: FND_MESSAGE.Set_Token('COLUMN',
2634: 'CONTAINER_ITEM', FALSE);
2635: ELSE
2636: FND_MESSAGE.Set_Token('COLUMN',
2637: 'CONTAINER_ITEM_SEGMENT1 - 20', FALSE);
2632: (P_Container_Item IS NOT NULL)) THEN
2633: FND_MESSAGE.Set_Token('COLUMN',
2634: 'CONTAINER_ITEM', FALSE);
2635: ELSE
2636: FND_MESSAGE.Set_Token('COLUMN',
2637: 'CONTAINER_ITEM_SEGMENT1 - 20', FALSE);
2638: END IF;
2639: Manage_Error_Code('IN', 'APP-43014', Curr_Error);
2640: RAISE Error;
2640: RAISE Error;
2641:
2642: WHEN TOO_MANY_ROWS THEN
2643:
2644: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_CONTAINERS');
2645: Manage_Error_Code('IN', 'APP-43055', Curr_Error);
2646: RAISE Error;
2647:
2648: END Validate_Containers;
2667:
2668: IF ((SQL%FOUND) AND ((Temp_Inactive_Date IS NOT NULL)
2669: AND (Temp_Inactive_Date <= SYSDATE))) THEN
2670:
2671: FND_MESSAGE.Set_Name('INV',
2672: 'INV_INACTIVE_COMMODITY_CODE');
2673: FND_MESSAGE.Set_Token('COLUMN',
2674: 'COMMODITY_CODE_ID', FALSE);
2675: Manage_Error_Code('IN', 'APP-43015', Curr_Error);
2669: AND (Temp_Inactive_Date <= SYSDATE))) THEN
2670:
2671: FND_MESSAGE.Set_Name('INV',
2672: 'INV_INACTIVE_COMMODITY_CODE');
2673: FND_MESSAGE.Set_Token('COLUMN',
2674: 'COMMODITY_CODE_ID', FALSE);
2675: Manage_Error_Code('IN', 'APP-43015', Curr_Error);
2676: RAISE Error;
2677:
2694: IF ((SQL%FOUND) AND
2695: ((Temp_Inactive_Date IS NOT NULL) AND
2696: (Temp_Inactive_Date <= SYSDATE))) THEN
2697:
2698: FND_MESSAGE.Set_Name('INV',
2699: 'INV_INACTIVE_COMMODITY_CODE');
2700: FND_MESSAGE.Set_Token('COLUMN',
2701: 'COMMODITY_CODE', FALSE);
2702: Manage_Error_Code('IN', 'APP-43015', Curr_Error);
2696: (Temp_Inactive_Date <= SYSDATE))) THEN
2697:
2698: FND_MESSAGE.Set_Name('INV',
2699: 'INV_INACTIVE_COMMODITY_CODE');
2700: FND_MESSAGE.Set_Token('COLUMN',
2701: 'COMMODITY_CODE', FALSE);
2702: Manage_Error_Code('IN', 'APP-43015', Curr_Error);
2703: RAISE Error;
2704:
2709:
2710: END IF;
2711:
2712: ELSE
2713: FND_MESSAGE.Set_Name('INV', 'INV_NO_COMMODITY_CODE');
2714: Manage_Error_Code('IN', 'APP-43016', Curr_Error);
2715: RAISE Error;
2716: END IF;
2717:
2718: EXCEPTION
2719:
2720: WHEN NO_DATA_FOUND THEN
2721:
2722: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_COMMODITY_CODE');
2723: IF (P_Commodity_Code_Id IS NOT NULL) THEN
2724: FND_MESSAGE.Set_Token('COLUMN',
2725: 'COMMODITY_CODE_ID', FALSE);
2726: ELSE
2720: WHEN NO_DATA_FOUND THEN
2721:
2722: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_COMMODITY_CODE');
2723: IF (P_Commodity_Code_Id IS NOT NULL) THEN
2724: FND_MESSAGE.Set_Token('COLUMN',
2725: 'COMMODITY_CODE_ID', FALSE);
2726: ELSE
2727: FND_MESSAGE.Set_Token('COLUMN',
2728: 'COMMODITY_CODE', FALSE);
2723: IF (P_Commodity_Code_Id IS NOT NULL) THEN
2724: FND_MESSAGE.Set_Token('COLUMN',
2725: 'COMMODITY_CODE_ID', FALSE);
2726: ELSE
2727: FND_MESSAGE.Set_Token('COLUMN',
2728: 'COMMODITY_CODE', FALSE);
2729: END IF;
2730: Manage_Error_Code('IN', 'APP-43017', Curr_Error);
2731: RAISE Error;
2731: RAISE Error;
2732:
2733: WHEN TOO_MANY_ROWS THEN
2734:
2735: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_COMMODITY_CODES');
2736: Manage_Error_Code('IN', 'APP-43018', Curr_Error);
2737: RAISE Error;
2738:
2739: END Validate_Commodity_Code;
2760: (P_Customer_Category_Code IS NULL)) OR
2761: (P_Item_Definition_Level IS NULL) OR
2762: (P_Customer_Item_Number IS NULL)) THEN
2763:
2764: FND_MESSAGE.Set_Name('INV', 'INV_NO_MODEL_CI_INFORMATION');
2765: Manage_Error_Code('IN', 'APP-00000', Curr_Error);
2766: RETURN;
2767: ELSE
2768:
2780: P_Customer_Id;
2781:
2782: IF ((SQL%FOUND) AND (Temp_Inactive_Flag = 'Y')) THEN
2783:
2784: FND_MESSAGE.Set_Name('INV',
2785: 'INV_INACTIVE_MODEL_CI');
2786: FND_MESSAGE.Set_Token('COLUMN',
2787: 'MODEL_CUSTOMER_ITEM_ID',
2788: FALSE);
2782: IF ((SQL%FOUND) AND (Temp_Inactive_Flag = 'Y')) THEN
2783:
2784: FND_MESSAGE.Set_Name('INV',
2785: 'INV_INACTIVE_MODEL_CI');
2786: FND_MESSAGE.Set_Token('COLUMN',
2787: 'MODEL_CUSTOMER_ITEM_ID',
2788: FALSE);
2789: Manage_Error_Code('IN', 'APP-43019',
2790: Curr_Error);
2800: Temp_Model_Customer_Item_Id;
2801: RETURN;
2802:
2803: ELSE
2804: FND_MESSAGE.Set_Name('INV',
2805: 'INV_INV_MODEL_DEF_LVL');
2806: FND_MESSAGE.Set_Token('COLUMN',
2807: 'MODEL_CUSTOMER_ITEM_ID',
2808: FALSE);
2802:
2803: ELSE
2804: FND_MESSAGE.Set_Name('INV',
2805: 'INV_INV_MODEL_DEF_LVL');
2806: FND_MESSAGE.Set_Token('COLUMN',
2807: 'MODEL_CUSTOMER_ITEM_ID',
2808: FALSE);
2809: Manage_Error_Code('IN', 'APP-43050',
2810: Curr_Error);
2827: OR MCI.Address_Id = P_Address_Id;
2828:
2829: IF ((SQL%FOUND) AND (Temp_Inactive_Flag = 'Y')) THEN
2830:
2831: FND_MESSAGE.Set_Name('INV',
2832: 'INV_INACTIVE_MODEL_CI');
2833: FND_MESSAGE.Set_Token('COLUMN',
2834: 'MODEL_CUSTOMER_ITEM', FALSE);
2835: Manage_Error_Code('IN', 'APP-43019',
2829: IF ((SQL%FOUND) AND (Temp_Inactive_Flag = 'Y')) THEN
2830:
2831: FND_MESSAGE.Set_Name('INV',
2832: 'INV_INACTIVE_MODEL_CI');
2833: FND_MESSAGE.Set_Token('COLUMN',
2834: 'MODEL_CUSTOMER_ITEM', FALSE);
2835: Manage_Error_Code('IN', 'APP-43019',
2836: Curr_Error);
2837: RAISE Error;
2846: Temp_Model_Customer_Item_Id;
2847: RETURN;
2848: ELSE
2849:
2850: FND_MESSAGE.Set_Name('INV',
2851: 'INV_INV_MODEL_DEF_LVL');
2852: FND_MESSAGE.Set_Token('COLUMN',
2853: 'MODEL_CUSTOMER_ITEM', FALSE);
2854: Manage_Error_Code('IN', 'APP-43050',
2848: ELSE
2849:
2850: FND_MESSAGE.Set_Name('INV',
2851: 'INV_INV_MODEL_DEF_LVL');
2852: FND_MESSAGE.Set_Token('COLUMN',
2853: 'MODEL_CUSTOMER_ITEM', FALSE);
2854: Manage_Error_Code('IN', 'APP-43050',
2855: Curr_Error);
2856: RAISE Error;
2858: END IF;
2859:
2860: ELSE
2861:
2862: FND_MESSAGE.Set_Name('INV',
2863: 'INV_NO_MODEL_CI_INFORMATION');
2864: Manage_Error_Code('IN', 'APP-00000', Curr_Error);
2865: RETURN;
2866:
2871: EXCEPTION
2872:
2873: WHEN NO_DATA_FOUND THEN
2874:
2875: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_MODEL_CI');
2876: IF (P_Model_Customer_Item_Id IS NULL) THEN
2877: FND_MESSAGE.Set_Token('COLUMN',
2878: 'MODEL_CUSTOMER_ITEM_ID', FALSE);
2879: ELSE
2873: WHEN NO_DATA_FOUND THEN
2874:
2875: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_MODEL_CI');
2876: IF (P_Model_Customer_Item_Id IS NULL) THEN
2877: FND_MESSAGE.Set_Token('COLUMN',
2878: 'MODEL_CUSTOMER_ITEM_ID', FALSE);
2879: ELSE
2880: FND_MESSAGE.Set_Token('COLUMN',
2881: 'MODEL_CUSTOMER_ITEM', FALSE);
2876: IF (P_Model_Customer_Item_Id IS NULL) THEN
2877: FND_MESSAGE.Set_Token('COLUMN',
2878: 'MODEL_CUSTOMER_ITEM_ID', FALSE);
2879: ELSE
2880: FND_MESSAGE.Set_Token('COLUMN',
2881: 'MODEL_CUSTOMER_ITEM', FALSE);
2882: END IF;
2883: Manage_Error_Code('IN', 'APP-43020', Curr_Error);
2884: RAISE Error;
2884: RAISE Error;
2885:
2886: WHEN TOO_MANY_ROWS THEN
2887:
2888: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_MODELS');
2889: Manage_Error_Code('IN', 'APP-43021', Curr_Error);
2890: RAISE Error;
2891:
2892: END Validate_Model;
2897: BEGIN
2898:
2899: IF ((P_Demand_Tolerance >= 999.99) OR (P_Demand_Tolerance <= 0)) THEN
2900:
2901: FND_MESSAGE.Set_Name('INV', 'INV_TOLERANCE_OUT_RANGE');
2902: Manage_Error_Code('IN', 'APP-43022', Curr_Error);
2903: RAISE Error;
2904:
2905: ELSE
2917: BEGIN
2918:
2919: IF ((P_Min_Fill_Percentage > 100) OR (P_Min_Fill_Percentage < 0)) THEN
2920:
2921: FND_MESSAGE.Set_Name('INV', 'INV_FILL_PERCENT_OUT_RANGE');
2922: Manage_Error_Code('IN', 'APP-43023', Curr_Error);
2923: RAISE Error;
2924:
2925: ELSE
2953: ((P_Dep_Plan_Prior_Bld_Flag = '1') OR
2954: (P_Dep_Plan_Prior_Bld_Flag = '2') OR
2955: (P_Dep_Plan_Prior_Bld_Flag IS NULL))) THEN
2956:
2957: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2958: FND_MESSAGE.Set_Token('RULE',
2959: 'Departure Planning Flags <> 1, 2, or NULL', FALSE);
2960: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2961: RAISE Error;
2954: (P_Dep_Plan_Prior_Bld_Flag = '2') OR
2955: (P_Dep_Plan_Prior_Bld_Flag IS NULL))) THEN
2956:
2957: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2958: FND_MESSAGE.Set_Token('RULE',
2959: 'Departure Planning Flags <> 1, 2, or NULL', FALSE);
2960: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2961: RAISE Error;
2962:
2962:
2963: ELSIF ((P_Dep_Plan_Required_Flag = '2') AND
2964: (P_Dep_Plan_Prior_Bld_Flag = '1')) THEN
2965:
2966: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2967: FND_MESSAGE.Set_Token('RULE',
2968: 'Departure Planning Prior Build = 1, Departure Planning Required = 2', FALSE);
2969: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2970: RAISE Error;
2963: ELSIF ((P_Dep_Plan_Required_Flag = '2') AND
2964: (P_Dep_Plan_Prior_Bld_Flag = '1')) THEN
2965:
2966: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2967: FND_MESSAGE.Set_Token('RULE',
2968: 'Departure Planning Prior Build = 1, Departure Planning Required = 2', FALSE);
2969: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2970: RAISE Error;
2971:
2971:
2972: ELSIF ((P_Dep_Plan_Required_Flag IS NULL) AND
2973: (P_Dep_Plan_Prior_Bld_Flag = '1')) THEN
2974:
2975: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2976: FND_MESSAGE.Set_Token('RULE',
2977: 'Departure Planning Prior Build = 1, Departure Planning Required = NULL', FALSE);
2978: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2979: RAISE Error;
2972: ELSIF ((P_Dep_Plan_Required_Flag IS NULL) AND
2973: (P_Dep_Plan_Prior_Bld_Flag = '1')) THEN
2974:
2975: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2976: FND_MESSAGE.Set_Token('RULE',
2977: 'Departure Planning Prior Build = 1, Departure Planning Required = NULL', FALSE);
2978: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2979: RAISE Error;
2980:
2980:
2981: ELSIF ((P_Dep_Plan_Required_Flag = '1') AND
2982: (P_Dep_Plan_Prior_Bld_Flag IS NULL)) THEN
2983:
2984: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2985: FND_MESSAGE.Set_Token('RULE',
2986: 'Departure Planning Prior Build = NULL, Departure Planning Required = 1', FALSE);
2987: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2988: RAISE Error;
2981: ELSIF ((P_Dep_Plan_Required_Flag = '1') AND
2982: (P_Dep_Plan_Prior_Bld_Flag IS NULL)) THEN
2983:
2984: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2985: FND_MESSAGE.Set_Token('RULE',
2986: 'Departure Planning Prior Build = NULL, Departure Planning Required = 1', FALSE);
2987: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2988: RAISE Error;
2989:
2989:
2990: ELSIF ((P_Dep_Plan_Required_Flag = '2') AND
2991: (P_Dep_Plan_Prior_Bld_Flag IS NULL)) THEN
2992:
2993: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2994: FND_MESSAGE.Set_Token('RULE',
2995: 'Departure Planning Prior Build = NULL, Departure Planning Required = 2', FALSE);
2996: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2997: RAISE Error;
2990: ELSIF ((P_Dep_Plan_Required_Flag = '2') AND
2991: (P_Dep_Plan_Prior_Bld_Flag IS NULL)) THEN
2992:
2993: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
2994: FND_MESSAGE.Set_Token('RULE',
2995: 'Departure Planning Prior Build = NULL, Departure Planning Required = 2', FALSE);
2996: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
2997: RAISE Error;
2998:
2998:
2999: ELSIF ((P_Dep_Plan_Required_Flag IS NULL) AND
3000: (P_Dep_Plan_Prior_Bld_Flag = '2')) THEN
3001:
3002: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
3003: FND_MESSAGE.Set_Token('RULE',
3004: 'Departure Planning Prior Build = 2, Departure Planning Required = NULL', FALSE);
3005: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
3006: RAISE Error;
2999: ELSIF ((P_Dep_Plan_Required_Flag IS NULL) AND
3000: (P_Dep_Plan_Prior_Bld_Flag = '2')) THEN
3001:
3002: FND_MESSAGE.Set_Name('INV', 'INV_INV_DEP_PLAN_FLAG');
3003: FND_MESSAGE.Set_Token('RULE',
3004: 'Departure Planning Prior Build = 2, Departure Planning Required = NULL', FALSE);
3005: Manage_Error_Code('IN', 'APP-43024', Curr_Error);
3006: RAISE Error;
3007:
3297:
3298: L_Success := 3;
3299:
3300: Error_Counter := Error_Counter + 1;
3301: FND_MESSAGE.Set_Token('TABLE',
3302: 'MTL_CI_XREFS_INTERFACE', FALSE);
3303: Error_Message := FND_MESSAGE.Get;
3304: Manage_Error_Code('OUT', NULL, Curr_Error);
3305:
3299:
3300: Error_Counter := Error_Counter + 1;
3301: FND_MESSAGE.Set_Token('TABLE',
3302: 'MTL_CI_XREFS_INTERFACE', FALSE);
3303: Error_Message := FND_MESSAGE.Get;
3304: Manage_Error_Code('OUT', NULL, Curr_Error);
3305:
3306: UPDATE MTL_CI_XREFS_INTERFACE MCIXI
3307: SET MCIXI.Error_Code = Curr_Error,
3336: IF (Error_Counter > 0) THEN
3337:
3338: L_Success := 3;
3339:
3340: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
3341: FND_MESSAGE.Set_Token('TABLE',
3342: 'MTL_CI_XREFS_INTERFACE', FALSE);
3343: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
3344: Error_Message := FND_MESSAGE.Get;
3337:
3338: L_Success := 3;
3339:
3340: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
3341: FND_MESSAGE.Set_Token('TABLE',
3342: 'MTL_CI_XREFS_INTERFACE', FALSE);
3343: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
3344: Error_Message := FND_MESSAGE.Get;
3345: --DBMS_OUTPUT.Put_Line(Error_Message);
3339:
3340: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
3341: FND_MESSAGE.Set_Token('TABLE',
3342: 'MTL_CI_XREFS_INTERFACE', FALSE);
3343: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
3344: Error_Message := FND_MESSAGE.Get;
3345: --DBMS_OUTPUT.Put_Line(Error_Message);
3346: END IF;
3347:
3340: FND_MESSAGE.Set_Name('INV', 'INV_CI_OPEN_INT_WARNING');
3341: FND_MESSAGE.Set_Token('TABLE',
3342: 'MTL_CI_XREFS_INTERFACE', FALSE);
3343: FND_MESSAGE.Set_Token('ERROR_COUNT', Error_Counter, FALSE);
3344: Error_Message := FND_MESSAGE.Get;
3345: --DBMS_OUTPUT.Put_Line(Error_Message);
3346: END IF;
3347:
3348: COMMIT;
3355:
3356: L_Success := 3;
3357:
3358: Error_Counter := Error_Counter + 1;
3359: FND_MESSAGE.Set_Token('TABLE',
3360: 'MTL_CI_XREFS_INTERFACE', FALSE);
3361: Error_Message := FND_MESSAGE.Get;
3362: Manage_Error_Code('OUT', NULL, Curr_Error);
3363:
3357:
3358: Error_Counter := Error_Counter + 1;
3359: FND_MESSAGE.Set_Token('TABLE',
3360: 'MTL_CI_XREFS_INTERFACE', FALSE);
3361: Error_Message := FND_MESSAGE.Get;
3362: Manage_Error_Code('OUT', NULL, Curr_Error);
3363:
3364: UPDATE MTL_CI_XREFS_INTERFACE MCIXI
3365: SET MCIXI.Error_Code = Curr_Error,
3660: END IF;
3661:
3662: ELSE
3663:
3664: FND_MESSAGE.Set_Name('INV', 'INV_MISSING_CI_INFO');
3665: Manage_Error_Code('IN', 'APP-43051', Curr_Error);
3666: RAISE Error;
3667:
3668: END IF;
3671: EXCEPTION
3672:
3673: WHEN NO_DATA_FOUND THEN
3674:
3675: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CI');
3676: IF (P_Customer_Item_Id IS NULL) THEN
3677: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ITEM_ID', FALSE);
3678: ELSE
3679: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ITEM_NUMBER', FALSE);
3673: WHEN NO_DATA_FOUND THEN
3674:
3675: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CI');
3676: IF (P_Customer_Item_Id IS NULL) THEN
3677: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ITEM_ID', FALSE);
3678: ELSE
3679: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ITEM_NUMBER', FALSE);
3680: END IF;
3681: Manage_Error_Code('IN', 'APP-43052', Curr_Error);
3675: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_CI');
3676: IF (P_Customer_Item_Id IS NULL) THEN
3677: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ITEM_ID', FALSE);
3678: ELSE
3679: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ITEM_NUMBER', FALSE);
3680: END IF;
3681: Manage_Error_Code('IN', 'APP-43052', Curr_Error);
3682: RAISE Error;
3683:
3682: RAISE Error;
3683:
3684: WHEN TOO_MANY_ROWS THEN
3685:
3686: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_CI');
3687: Manage_Error_Code('IN', 'APP-43053', Curr_Error);
3688: RAISE Error;
3689:
3690: END Validate_Cust_Item;
3719: (NOT (TRUNC(SYSDATE) BETWEEN
3720: NVL(TRUNC((Temp_Date_From)),SYSDATE)
3721: AND NVL(TRUNC((Temp_Date_To)), SYSDATE)))) THEN
3722:
3723: FND_MESSAGE.Set_Name('INV',
3724: 'INV_INACTIVE_ORGANIZATION');
3725: FND_MESSAGE.Set_Token('COLUMN',
3726: 'MASTER_ORGANIZATION_ID', FALSE);
3727: Manage_Error_Code('IN', 'APP-43027', Curr_Error);
3721: AND NVL(TRUNC((Temp_Date_To)), SYSDATE)))) THEN
3722:
3723: FND_MESSAGE.Set_Name('INV',
3724: 'INV_INACTIVE_ORGANIZATION');
3725: FND_MESSAGE.Set_Token('COLUMN',
3726: 'MASTER_ORGANIZATION_ID', FALSE);
3727: Manage_Error_Code('IN', 'APP-43027', Curr_Error);
3728: RAISE Error;
3729: ELSE
3749: (NOT (TRUNC(SYSDATE) BETWEEN
3750: NVL(TRUNC((Temp_Date_From)),SYSDATE)
3751: AND NVL(TRUNC((Temp_Date_To)), SYSDATE)))) THEN
3752:
3753: FND_MESSAGE.Set_Name('INV',
3754: 'INV_INACTIVE_ORGANIZATION');
3755: FND_MESSAGE.Set_Token('COLUMN',
3756: 'MASTER_ORGANIZATION_CODE', FALSE);
3757: Manage_Error_Code('IN', 'APP-43027', Curr_Error);
3751: AND NVL(TRUNC((Temp_Date_To)), SYSDATE)))) THEN
3752:
3753: FND_MESSAGE.Set_Name('INV',
3754: 'INV_INACTIVE_ORGANIZATION');
3755: FND_MESSAGE.Set_Token('COLUMN',
3756: 'MASTER_ORGANIZATION_CODE', FALSE);
3757: Manage_Error_Code('IN', 'APP-43027', Curr_Error);
3758: RAISE Error;
3759: ELSE
3785: (NOT (TRUNC(SYSDATE) BETWEEN
3786: NVL(TRUNC((Temp_Date_From)),SYSDATE)
3787: AND NVL(TRUNC((Temp_Date_To)), SYSDATE)))) THEN
3788:
3789: FND_MESSAGE.Set_Name('INV',
3790: 'INV_INACTIVE_ORGANIZATION');
3791: FND_MESSAGE.Set_Token('COLUMN',
3792: 'MASTER_ORGANIZATION_NAME', FALSE);
3793: Manage_Error_Code('IN', 'APP-43027', Curr_Error);
3787: AND NVL(TRUNC((Temp_Date_To)), SYSDATE)))) THEN
3788:
3789: FND_MESSAGE.Set_Name('INV',
3790: 'INV_INACTIVE_ORGANIZATION');
3791: FND_MESSAGE.Set_Token('COLUMN',
3792: 'MASTER_ORGANIZATION_NAME', FALSE);
3793: Manage_Error_Code('IN', 'APP-43027', Curr_Error);
3794: RAISE Error;
3795: ELSE
3798: Temp_Master_Organization_Id;
3799: RETURN;
3800: END IF;
3801: ELSE
3802: FND_MESSAGE.Set_Name('INV', 'INV_NO_ORGANIZATION');
3803: FND_MESSAGE.Set_Token('COLUMN1',
3804: 'MASTER_ORGANIZATION_ID', FALSE);
3805: FND_MESSAGE.Set_Token('COLUMN2',
3806: 'MASTER_ORGANIZATION_CODE', FALSE);
3799: RETURN;
3800: END IF;
3801: ELSE
3802: FND_MESSAGE.Set_Name('INV', 'INV_NO_ORGANIZATION');
3803: FND_MESSAGE.Set_Token('COLUMN1',
3804: 'MASTER_ORGANIZATION_ID', FALSE);
3805: FND_MESSAGE.Set_Token('COLUMN2',
3806: 'MASTER_ORGANIZATION_CODE', FALSE);
3807: FND_MESSAGE.Set_Token('COLUMN3',
3801: ELSE
3802: FND_MESSAGE.Set_Name('INV', 'INV_NO_ORGANIZATION');
3803: FND_MESSAGE.Set_Token('COLUMN1',
3804: 'MASTER_ORGANIZATION_ID', FALSE);
3805: FND_MESSAGE.Set_Token('COLUMN2',
3806: 'MASTER_ORGANIZATION_CODE', FALSE);
3807: FND_MESSAGE.Set_Token('COLUMN3',
3808: 'MASTER_ORGANIZATION_NAME', FALSE);
3809: Manage_Error_Code('IN', 'APP-43045', Curr_Error);
3803: FND_MESSAGE.Set_Token('COLUMN1',
3804: 'MASTER_ORGANIZATION_ID', FALSE);
3805: FND_MESSAGE.Set_Token('COLUMN2',
3806: 'MASTER_ORGANIZATION_CODE', FALSE);
3807: FND_MESSAGE.Set_Token('COLUMN3',
3808: 'MASTER_ORGANIZATION_NAME', FALSE);
3809: Manage_Error_Code('IN', 'APP-43045', Curr_Error);
3810: RAISE Error;
3811: END IF;
3812:
3813: EXCEPTION
3814: WHEN NO_DATA_FOUND THEN
3815:
3816: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ORGANIZATION');
3817: IF (P_Master_Organization_Id IS NOT NULL) THEN
3818: FND_MESSAGE.Set_Token('COLUMN',
3819: 'MASTER_ORGANIZATION_ID', FALSE);
3820: ELSIF ((P_Master_Organization_Id IS NULL)
3814: WHEN NO_DATA_FOUND THEN
3815:
3816: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_ORGANIZATION');
3817: IF (P_Master_Organization_Id IS NOT NULL) THEN
3818: FND_MESSAGE.Set_Token('COLUMN',
3819: 'MASTER_ORGANIZATION_ID', FALSE);
3820: ELSIF ((P_Master_Organization_Id IS NULL)
3821: AND (P_Master_Organization_Code IS NOT NULL)) THEN
3822: FND_MESSAGE.Set_Token('COLUMN',
3818: FND_MESSAGE.Set_Token('COLUMN',
3819: 'MASTER_ORGANIZATION_ID', FALSE);
3820: ELSIF ((P_Master_Organization_Id IS NULL)
3821: AND (P_Master_Organization_Code IS NOT NULL)) THEN
3822: FND_MESSAGE.Set_Token('COLUMN',
3823: 'MASTER_ORGANIZATION_CODE', FALSE);
3824: ELSE
3825: FND_MESSAGE.Set_Token('COLUMN',
3826: 'MASTER_ORGANIZATION_NAME', FALSE);
3821: AND (P_Master_Organization_Code IS NOT NULL)) THEN
3822: FND_MESSAGE.Set_Token('COLUMN',
3823: 'MASTER_ORGANIZATION_CODE', FALSE);
3824: ELSE
3825: FND_MESSAGE.Set_Token('COLUMN',
3826: 'MASTER_ORGANIZATION_NAME', FALSE);
3827: END IF;
3828: Manage_Error_Code('IN', 'APP-43028', Curr_Error);
3829: RAISE Error;
3829: RAISE Error;
3830:
3831: WHEN TOO_MANY_ROWS THEN
3832:
3833: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_ORGANIZATIONS');
3834: Manage_Error_Code('IN', 'APP-43029', Curr_Error);
3835: RAISE Error;
3836:
3837: END Validate_Master_Organization;
3918: AND id_flex_code = 'MSTK'
3919: AND upper(enabled_flag) = 'Y';
3920: EXCEPTION
3921: WHEN NO_DATA_FOUND THEN
3922: FND_MESSAGE.Set_Name('INV', 'INV_NO_ITEM_FLEX_STRUCT');
3923: Manage_Error_Code('IN', 'APP-43014',
3924: Curr_Error);
3925: RAISE Error;
3926:
3924: Curr_Error);
3925: RAISE Error;
3926:
3927: WHEN TOO_MANY_ROWS THEN
3928: FND_MESSAGE.Set_Name('INV',
3929: 'INV_MULT_ITEM_FLEX_STRUCT');
3930: Manage_Error_Code('IN', 'APP-43014',
3931: Curr_Error);
3932: RAISE Error;
3950: end if;
3951:
3952: If P_Inventory_Item_Id is NULL then
3953:
3954: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_INV_ITEM');
3955: FND_MESSAGE.Set_Token('COLUMN',
3956: 'INVENTORY_ITEM', FALSE);
3957: Manage_Error_Code('IN', 'APP-43014',
3958: Curr_Error);
3951:
3952: If P_Inventory_Item_Id is NULL then
3953:
3954: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_INV_ITEM');
3955: FND_MESSAGE.Set_Token('COLUMN',
3956: 'INVENTORY_ITEM', FALSE);
3957: Manage_Error_Code('IN', 'APP-43014',
3958: Curr_Error);
3959: RAISE Error;
3970: AND id_flex_code = 'MSTK'
3971: AND upper(enabled_flag) = 'Y';
3972: EXCEPTION
3973: WHEN NO_DATA_FOUND THEN
3974: FND_MESSAGE.Set_Name('INV', 'INV_NO_ITEM_FLEX_STRUCT');
3975: Manage_Error_Code('IN', 'APP-43014',
3976: Curr_Error);
3977: RAISE Error;
3978:
3976: Curr_Error);
3977: RAISE Error;
3978:
3979: WHEN TOO_MANY_ROWS THEN
3980: FND_MESSAGE.Set_Name('INV',
3981: 'INV_MULT_ITEM_FLEX_STRUCT');
3982: Manage_Error_Code('IN', 'APP-43014',
3983: Curr_Error);
3984: RAISE Error;
4010: and application_column_name = 'SEGMENT1';
4011:
4012: EXCEPTION
4013: WHEN NO_DATA_FOUND THEN
4014: FND_MESSAGE.Set_Name('INV',
4015: 'INV_INVALID_ITEM_SEG');
4016: FND_MESSAGE.Set_Token('SEGMENT',
4017: 'SEGMENT1',
4018: FALSE);
4012: EXCEPTION
4013: WHEN NO_DATA_FOUND THEN
4014: FND_MESSAGE.Set_Name('INV',
4015: 'INV_INVALID_ITEM_SEG');
4016: FND_MESSAGE.Set_Token('SEGMENT',
4017: 'SEGMENT1',
4018: FALSE);
4019: Manage_Error_Code('IN', 'APP-43014',
4020: Curr_Error);
4020: Curr_Error);
4021: RAISE Error;
4022:
4023: WHEN TOO_MANY_ROWS THEN
4024: FND_MESSAGE.Set_Name('INV',
4025: 'INV_MULTIPLE_FLEX_SEG');
4026: Manage_Error_Code('IN', 'APP-43014',
4027: Curr_Error);
4028: RAISE Error;
4042: if L_SegNumIndex <= L_FlexSeg_Counter then
4043: L_Segment_Array(L_SegNumIndex) :=
4044: P_Inventory_Item_Segment1;
4045: else
4046: FND_MESSAGE.Set_Name('INV',
4047: 'INV_FLEX_SEG_OUT_OF_RANGE');
4048: Manage_Error_Code('IN', 'APP-43014',
4049: Curr_Error);
4050: RAISE Error;
4065: and application_column_name = 'SEGMENT2';
4066:
4067: EXCEPTION
4068: WHEN NO_DATA_FOUND THEN
4069: FND_MESSAGE.Set_Name('INV',
4070: 'INV_INVALID_ITEM_SEG');
4071: FND_MESSAGE.Set_Token('SEGMENT',
4072: 'SEGMENT2',
4073: FALSE);
4067: EXCEPTION
4068: WHEN NO_DATA_FOUND THEN
4069: FND_MESSAGE.Set_Name('INV',
4070: 'INV_INVALID_ITEM_SEG');
4071: FND_MESSAGE.Set_Token('SEGMENT',
4072: 'SEGMENT2',
4073: FALSE);
4074: Manage_Error_Code('IN', 'APP-43014',
4075: Curr_Error);
4075: Curr_Error);
4076: RAISE Error;
4077:
4078: WHEN TOO_MANY_ROWS THEN
4079: FND_MESSAGE.Set_Name('INV',
4080: 'INV_MULTIPLE_FLEX_SEG');
4081: Manage_Error_Code('IN', 'APP-43014',
4082: Curr_Error);
4083: RAISE Error;
4097: if L_SegNumIndex <= L_FlexSeg_Counter then
4098: L_Segment_Array(L_SegNumIndex) :=
4099: P_Inventory_Item_Segment2;
4100: else
4101: FND_MESSAGE.Set_Name('INV',
4102: 'INV_FLEX_SEG_OUT_OF_RANGE');
4103: Manage_Error_Code('IN', 'APP-43014',
4104: Curr_Error);
4105: RAISE Error;
4120: and application_column_name = 'SEGMENT3';
4121:
4122: EXCEPTION
4123: WHEN NO_DATA_FOUND THEN
4124: FND_MESSAGE.Set_Name('INV',
4125: 'INV_INVALID_ITEM_SEG');
4126: FND_MESSAGE.Set_Token('SEGMENT',
4127: 'SEGMENT3',
4128: FALSE);
4122: EXCEPTION
4123: WHEN NO_DATA_FOUND THEN
4124: FND_MESSAGE.Set_Name('INV',
4125: 'INV_INVALID_ITEM_SEG');
4126: FND_MESSAGE.Set_Token('SEGMENT',
4127: 'SEGMENT3',
4128: FALSE);
4129: Manage_Error_Code('IN', 'APP-43014',
4130: Curr_Error);
4130: Curr_Error);
4131: RAISE Error;
4132:
4133: WHEN TOO_MANY_ROWS THEN
4134: FND_MESSAGE.Set_Name('INV',
4135: 'INV_MULTIPLE_FLEX_SEG');
4136: Manage_Error_Code('IN', 'APP-43014',
4137: Curr_Error);
4138: RAISE Error;
4152: if L_SegNumIndex <= L_FlexSeg_Counter then
4153: L_Segment_Array(L_SegNumIndex) :=
4154: P_Inventory_Item_Segment3;
4155: else
4156: FND_MESSAGE.Set_Name('INV',
4157: 'INV_FLEX_SEG_OUT_OF_RANGE');
4158: Manage_Error_Code('IN', 'APP-43014',
4159: Curr_Error);
4160: RAISE Error;
4175: and application_column_name = 'SEGMENT4';
4176:
4177: EXCEPTION
4178: WHEN NO_DATA_FOUND THEN
4179: FND_MESSAGE.Set_Name('INV',
4180: 'INV_INVALID_ITEM_SEG');
4181: FND_MESSAGE.Set_Token('SEGMENT',
4182: 'SEGMENT4',
4183: FALSE);
4177: EXCEPTION
4178: WHEN NO_DATA_FOUND THEN
4179: FND_MESSAGE.Set_Name('INV',
4180: 'INV_INVALID_ITEM_SEG');
4181: FND_MESSAGE.Set_Token('SEGMENT',
4182: 'SEGMENT4',
4183: FALSE);
4184: Manage_Error_Code('IN', 'APP-43014',
4185: Curr_Error);
4185: Curr_Error);
4186: RAISE Error;
4187:
4188: WHEN TOO_MANY_ROWS THEN
4189: FND_MESSAGE.Set_Name('INV',
4190: 'INV_MULTIPLE_FLEX_SEG');
4191: Manage_Error_Code('IN', 'APP-43014',
4192: Curr_Error);
4193: RAISE Error;
4207: if L_SegNumIndex <= L_FlexSeg_Counter then
4208: L_Segment_Array(L_SegNumIndex) :=
4209: P_Inventory_Item_Segment4;
4210: else
4211: FND_MESSAGE.Set_Name('INV',
4212: 'INV_FLEX_SEG_OUT_OF_RANGE');
4213: Manage_Error_Code('IN', 'APP-43014',
4214: Curr_Error);
4215: RAISE Error;
4230: and application_column_name = 'SEGMENT5';
4231:
4232: EXCEPTION
4233: WHEN NO_DATA_FOUND THEN
4234: FND_MESSAGE.Set_Name('INV',
4235: 'INV_INVALID_ITEM_SEG');
4236: FND_MESSAGE.Set_Token('SEGMENT',
4237: 'SEGMENT5',
4238: FALSE);
4232: EXCEPTION
4233: WHEN NO_DATA_FOUND THEN
4234: FND_MESSAGE.Set_Name('INV',
4235: 'INV_INVALID_ITEM_SEG');
4236: FND_MESSAGE.Set_Token('SEGMENT',
4237: 'SEGMENT5',
4238: FALSE);
4239: Manage_Error_Code('IN', 'APP-43014',
4240: Curr_Error);
4240: Curr_Error);
4241: RAISE Error;
4242:
4243: WHEN TOO_MANY_ROWS THEN
4244: FND_MESSAGE.Set_Name('INV',
4245: 'INV_MULTIPLE_FLEX_SEG');
4246: Manage_Error_Code('IN', 'APP-43014',
4247: Curr_Error);
4248: RAISE Error;
4262: if L_SegNumIndex <= L_FlexSeg_Counter then
4263: L_Segment_Array(L_SegNumIndex) :=
4264: P_Inventory_Item_Segment5;
4265: else
4266: FND_MESSAGE.Set_Name('INV',
4267: 'INV_FLEX_SEG_OUT_OF_RANGE');
4268: Manage_Error_Code('IN', 'APP-43014',
4269: Curr_Error);
4270: RAISE Error;
4285: and application_column_name = 'SEGMENT6';
4286:
4287: EXCEPTION
4288: WHEN NO_DATA_FOUND THEN
4289: FND_MESSAGE.Set_Name('INV',
4290: 'INV_INVALID_ITEM_SEG');
4291: FND_MESSAGE.Set_Token('SEGMENT',
4292: 'SEGMENT6',
4293: FALSE);
4287: EXCEPTION
4288: WHEN NO_DATA_FOUND THEN
4289: FND_MESSAGE.Set_Name('INV',
4290: 'INV_INVALID_ITEM_SEG');
4291: FND_MESSAGE.Set_Token('SEGMENT',
4292: 'SEGMENT6',
4293: FALSE);
4294: Manage_Error_Code('IN', 'APP-43014',
4295: Curr_Error);
4295: Curr_Error);
4296: RAISE Error;
4297:
4298: WHEN TOO_MANY_ROWS THEN
4299: FND_MESSAGE.Set_Name('INV',
4300: 'INV_MULTIPLE_FLEX_SEG');
4301: Manage_Error_Code('IN', 'APP-43014',
4302: Curr_Error);
4303: RAISE Error;
4317: if L_SegNumIndex <= L_FlexSeg_Counter then
4318: L_Segment_Array(L_SegNumIndex) :=
4319: P_Inventory_Item_Segment6;
4320: else
4321: FND_MESSAGE.Set_Name('INV',
4322: 'INV_FLEX_SEG_OUT_OF_RANGE');
4323: Manage_Error_Code('IN', 'APP-43014',
4324: Curr_Error);
4325: RAISE Error;
4340: and application_column_name = 'SEGMENT7';
4341:
4342: EXCEPTION
4343: WHEN NO_DATA_FOUND THEN
4344: FND_MESSAGE.Set_Name('INV',
4345: 'INV_INVALID_ITEM_SEG');
4346: FND_MESSAGE.Set_Token('SEGMENT',
4347: 'SEGMENT7',
4348: FALSE);
4342: EXCEPTION
4343: WHEN NO_DATA_FOUND THEN
4344: FND_MESSAGE.Set_Name('INV',
4345: 'INV_INVALID_ITEM_SEG');
4346: FND_MESSAGE.Set_Token('SEGMENT',
4347: 'SEGMENT7',
4348: FALSE);
4349: Manage_Error_Code('IN', 'APP-43014',
4350: Curr_Error);
4350: Curr_Error);
4351: RAISE Error;
4352:
4353: WHEN TOO_MANY_ROWS THEN
4354: FND_MESSAGE.Set_Name('INV',
4355: 'INV_MULTIPLE_FLEX_SEG');
4356: Manage_Error_Code('IN', 'APP-43014',
4357: Curr_Error);
4358: RAISE Error;
4372: if L_SegNumIndex <= L_FlexSeg_Counter then
4373: L_Segment_Array(L_SegNumIndex) :=
4374: P_Inventory_Item_Segment7;
4375: else
4376: FND_MESSAGE.Set_Name('INV',
4377: 'INV_FLEX_SEG_OUT_OF_RANGE');
4378: Manage_Error_Code('IN', 'APP-43014',
4379: Curr_Error);
4380: RAISE Error;
4395: and application_column_name = 'SEGMENT8';
4396:
4397: EXCEPTION
4398: WHEN NO_DATA_FOUND THEN
4399: FND_MESSAGE.Set_Name('INV',
4400: 'INV_INVALID_ITEM_SEG');
4401: FND_MESSAGE.Set_Token('SEGMENT',
4402: 'SEGMENT8',
4403: FALSE);
4397: EXCEPTION
4398: WHEN NO_DATA_FOUND THEN
4399: FND_MESSAGE.Set_Name('INV',
4400: 'INV_INVALID_ITEM_SEG');
4401: FND_MESSAGE.Set_Token('SEGMENT',
4402: 'SEGMENT8',
4403: FALSE);
4404: Manage_Error_Code('IN', 'APP-43014',
4405: Curr_Error);
4405: Curr_Error);
4406: RAISE Error;
4407:
4408: WHEN TOO_MANY_ROWS THEN
4409: FND_MESSAGE.Set_Name('INV',
4410: 'INV_MULTIPLE_FLEX_SEG');
4411: Manage_Error_Code('IN', 'APP-43014',
4412: Curr_Error);
4413: RAISE Error;
4427: if L_SegNumIndex <= L_FlexSeg_Counter then
4428: L_Segment_Array(L_SegNumIndex) :=
4429: P_Inventory_Item_Segment8;
4430: else
4431: FND_MESSAGE.Set_Name('INV',
4432: 'INV_FLEX_SEG_OUT_OF_RANGE');
4433: Manage_Error_Code('IN', 'APP-43014',
4434: Curr_Error);
4435: RAISE Error;
4450: and application_column_name = 'SEGMENT9';
4451:
4452: EXCEPTION
4453: WHEN NO_DATA_FOUND THEN
4454: FND_MESSAGE.Set_Name('INV',
4455: 'INV_INVALID_ITEM_SEG');
4456: FND_MESSAGE.Set_Token('SEGMENT',
4457: 'SEGMENT9',
4458: FALSE);
4452: EXCEPTION
4453: WHEN NO_DATA_FOUND THEN
4454: FND_MESSAGE.Set_Name('INV',
4455: 'INV_INVALID_ITEM_SEG');
4456: FND_MESSAGE.Set_Token('SEGMENT',
4457: 'SEGMENT9',
4458: FALSE);
4459: Manage_Error_Code('IN', 'APP-43014',
4460: Curr_Error);
4460: Curr_Error);
4461: RAISE Error;
4462:
4463: WHEN TOO_MANY_ROWS THEN
4464: FND_MESSAGE.Set_Name('INV',
4465: 'INV_MULTIPLE_FLEX_SEG');
4466: Manage_Error_Code('IN', 'APP-43014',
4467: Curr_Error);
4468: RAISE Error;
4482: if L_SegNumIndex <= L_FlexSeg_Counter then
4483: L_Segment_Array(L_SegNumIndex) :=
4484: P_Inventory_Item_Segment9;
4485: else
4486: FND_MESSAGE.Set_Name('INV',
4487: 'INV_FLEX_SEG_OUT_OF_RANGE');
4488: Manage_Error_Code('IN', 'APP-43014',
4489: Curr_Error);
4490: RAISE Error;
4505: and application_column_name = 'SEGMENT10';
4506:
4507: EXCEPTION
4508: WHEN NO_DATA_FOUND THEN
4509: FND_MESSAGE.Set_Name('INV',
4510: 'INV_INVALID_ITEM_SEG');
4511: FND_MESSAGE.Set_Token('SEGMENT',
4512: 'SEGMENT10',
4513: FALSE);
4507: EXCEPTION
4508: WHEN NO_DATA_FOUND THEN
4509: FND_MESSAGE.Set_Name('INV',
4510: 'INV_INVALID_ITEM_SEG');
4511: FND_MESSAGE.Set_Token('SEGMENT',
4512: 'SEGMENT10',
4513: FALSE);
4514: Manage_Error_Code('IN', 'APP-43014',
4515: Curr_Error);
4515: Curr_Error);
4516: RAISE Error;
4517:
4518: WHEN TOO_MANY_ROWS THEN
4519: FND_MESSAGE.Set_Name('INV',
4520: 'INV_MULTIPLE_FLEX_SEG');
4521: Manage_Error_Code('IN', 'APP-43014',
4522: Curr_Error);
4523: RAISE Error;
4537: if L_SegNumIndex <= L_FlexSeg_Counter then
4538: L_Segment_Array(L_SegNumIndex) :=
4539: P_Inventory_Item_Segment10;
4540: else
4541: FND_MESSAGE.Set_Name('INV',
4542: 'INV_FLEX_SEG_OUT_OF_RANGE');
4543: Manage_Error_Code('IN', 'APP-43014',
4544: Curr_Error);
4545: RAISE Error;
4560: and application_column_name = 'SEGMENT11';
4561:
4562: EXCEPTION
4563: WHEN NO_DATA_FOUND THEN
4564: FND_MESSAGE.Set_Name('INV',
4565: 'INV_INVALID_ITEM_SEG');
4566: FND_MESSAGE.Set_Token('SEGMENT',
4567: 'SEGMENT11',
4568: FALSE);
4562: EXCEPTION
4563: WHEN NO_DATA_FOUND THEN
4564: FND_MESSAGE.Set_Name('INV',
4565: 'INV_INVALID_ITEM_SEG');
4566: FND_MESSAGE.Set_Token('SEGMENT',
4567: 'SEGMENT11',
4568: FALSE);
4569: Manage_Error_Code('IN', 'APP-43014',
4570: Curr_Error);
4570: Curr_Error);
4571: RAISE Error;
4572:
4573: WHEN TOO_MANY_ROWS THEN
4574: FND_MESSAGE.Set_Name('INV',
4575: 'INV_MULTIPLE_FLEX_SEG');
4576: Manage_Error_Code('IN', 'APP-43014',
4577: Curr_Error);
4578: RAISE Error;
4592: if L_SegNumIndex <= L_FlexSeg_Counter then
4593: L_Segment_Array(L_SegNumIndex) :=
4594: P_Inventory_Item_Segment11;
4595: else
4596: FND_MESSAGE.Set_Name('INV',
4597: 'INV_FLEX_SEG_OUT_OF_RANGE');
4598: Manage_Error_Code('IN', 'APP-43014',
4599: Curr_Error);
4600: RAISE Error;
4615: and application_column_name = 'SEGMENT12';
4616:
4617: EXCEPTION
4618: WHEN NO_DATA_FOUND THEN
4619: FND_MESSAGE.Set_Name('INV',
4620: 'INV_INVALID_ITEM_SEG');
4621: FND_MESSAGE.Set_Token('SEGMENT',
4622: 'SEGMENT12',
4623: FALSE);
4617: EXCEPTION
4618: WHEN NO_DATA_FOUND THEN
4619: FND_MESSAGE.Set_Name('INV',
4620: 'INV_INVALID_ITEM_SEG');
4621: FND_MESSAGE.Set_Token('SEGMENT',
4622: 'SEGMENT12',
4623: FALSE);
4624: Manage_Error_Code('IN', 'APP-43014',
4625: Curr_Error);
4625: Curr_Error);
4626: RAISE Error;
4627:
4628: WHEN TOO_MANY_ROWS THEN
4629: FND_MESSAGE.Set_Name('INV',
4630: 'INV_MULTIPLE_FLEX_SEG');
4631: Manage_Error_Code('IN', 'APP-43014',
4632: Curr_Error);
4633: RAISE Error;
4647: if L_SegNumIndex <= L_FlexSeg_Counter then
4648: L_Segment_Array(L_SegNumIndex) :=
4649: P_Inventory_Item_Segment12;
4650: else
4651: FND_MESSAGE.Set_Name('INV',
4652: 'INV_FLEX_SEG_OUT_OF_RANGE');
4653: Manage_Error_Code('IN', 'APP-43014',
4654: Curr_Error);
4655: RAISE Error;
4670: and application_column_name = 'SEGMENT13';
4671:
4672: EXCEPTION
4673: WHEN NO_DATA_FOUND THEN
4674: FND_MESSAGE.Set_Name('INV',
4675: 'INV_INVALID_ITEM_SEG');
4676: FND_MESSAGE.Set_Token('SEGMENT',
4677: 'SEGMENT13',
4678: FALSE);
4672: EXCEPTION
4673: WHEN NO_DATA_FOUND THEN
4674: FND_MESSAGE.Set_Name('INV',
4675: 'INV_INVALID_ITEM_SEG');
4676: FND_MESSAGE.Set_Token('SEGMENT',
4677: 'SEGMENT13',
4678: FALSE);
4679: Manage_Error_Code('IN', 'APP-43014',
4680: Curr_Error);
4680: Curr_Error);
4681: RAISE Error;
4682:
4683: WHEN TOO_MANY_ROWS THEN
4684: FND_MESSAGE.Set_Name('INV',
4685: 'INV_MULTIPLE_FLEX_SEG');
4686: Manage_Error_Code('IN', 'APP-43014',
4687: Curr_Error);
4688: RAISE Error;
4702: if L_SegNumIndex <= L_FlexSeg_Counter then
4703: L_Segment_Array(L_SegNumIndex) :=
4704: P_Inventory_Item_Segment13;
4705: else
4706: FND_MESSAGE.Set_Name('INV',
4707: 'INV_FLEX_SEG_OUT_OF_RANGE');
4708: Manage_Error_Code('IN', 'APP-43014',
4709: Curr_Error);
4710: RAISE Error;
4725: and application_column_name = 'SEGMENT14';
4726:
4727: EXCEPTION
4728: WHEN NO_DATA_FOUND THEN
4729: FND_MESSAGE.Set_Name('INV',
4730: 'INV_INVALID_ITEM_SEG');
4731: FND_MESSAGE.Set_Token('SEGMENT',
4732: 'SEGMENT14',
4733: FALSE);
4727: EXCEPTION
4728: WHEN NO_DATA_FOUND THEN
4729: FND_MESSAGE.Set_Name('INV',
4730: 'INV_INVALID_ITEM_SEG');
4731: FND_MESSAGE.Set_Token('SEGMENT',
4732: 'SEGMENT14',
4733: FALSE);
4734: Manage_Error_Code('IN', 'APP-43014',
4735: Curr_Error);
4735: Curr_Error);
4736: RAISE Error;
4737:
4738: WHEN TOO_MANY_ROWS THEN
4739: FND_MESSAGE.Set_Name('INV',
4740: 'INV_MULTIPLE_FLEX_SEG');
4741: Manage_Error_Code('IN', 'APP-43014',
4742: Curr_Error);
4743: RAISE Error;
4757: if L_SegNumIndex <= L_FlexSeg_Counter then
4758: L_Segment_Array(L_SegNumIndex) :=
4759: P_Inventory_Item_Segment14;
4760: else
4761: FND_MESSAGE.Set_Name('INV',
4762: 'INV_FLEX_SEG_OUT_OF_RANGE');
4763: Manage_Error_Code('IN', 'APP-43014',
4764: Curr_Error);
4765: RAISE Error;
4780: and application_column_name = 'SEGMENT15';
4781:
4782: EXCEPTION
4783: WHEN NO_DATA_FOUND THEN
4784: FND_MESSAGE.Set_Name('INV',
4785: 'INV_INVALID_ITEM_SEG');
4786: FND_MESSAGE.Set_Token('SEGMENT',
4787: 'SEGMENT15',
4788: FALSE);
4782: EXCEPTION
4783: WHEN NO_DATA_FOUND THEN
4784: FND_MESSAGE.Set_Name('INV',
4785: 'INV_INVALID_ITEM_SEG');
4786: FND_MESSAGE.Set_Token('SEGMENT',
4787: 'SEGMENT15',
4788: FALSE);
4789: Manage_Error_Code('IN', 'APP-43014',
4790: Curr_Error);
4790: Curr_Error);
4791: RAISE Error;
4792:
4793: WHEN TOO_MANY_ROWS THEN
4794: FND_MESSAGE.Set_Name('INV',
4795: 'INV_MULTIPLE_FLEX_SEG');
4796: Manage_Error_Code('IN', 'APP-43014',
4797: Curr_Error);
4798: RAISE Error;
4812: if L_SegNumIndex <= L_FlexSeg_Counter then
4813: L_Segment_Array(L_SegNumIndex) :=
4814: P_Inventory_Item_Segment15;
4815: else
4816: FND_MESSAGE.Set_Name('INV',
4817: 'INV_FLEX_SEG_OUT_OF_RANGE');
4818: Manage_Error_Code('IN', 'APP-43014',
4819: Curr_Error);
4820: RAISE Error;
4835: and application_column_name = 'SEGMENT16';
4836:
4837: EXCEPTION
4838: WHEN NO_DATA_FOUND THEN
4839: FND_MESSAGE.Set_Name('INV',
4840: 'INV_INVALID_ITEM_SEG');
4841: FND_MESSAGE.Set_Token('SEGMENT',
4842: 'SEGMENT16',
4843: FALSE);
4837: EXCEPTION
4838: WHEN NO_DATA_FOUND THEN
4839: FND_MESSAGE.Set_Name('INV',
4840: 'INV_INVALID_ITEM_SEG');
4841: FND_MESSAGE.Set_Token('SEGMENT',
4842: 'SEGMENT16',
4843: FALSE);
4844: Manage_Error_Code('IN', 'APP-43014',
4845: Curr_Error);
4845: Curr_Error);
4846: RAISE Error;
4847:
4848: WHEN TOO_MANY_ROWS THEN
4849: FND_MESSAGE.Set_Name('INV',
4850: 'INV_MULTIPLE_FLEX_SEG');
4851: Manage_Error_Code('IN', 'APP-43014',
4852: Curr_Error);
4853: RAISE Error;
4867: if L_SegNumIndex <= L_FlexSeg_Counter then
4868: L_Segment_Array(L_SegNumIndex) :=
4869: P_Inventory_Item_Segment16;
4870: else
4871: FND_MESSAGE.Set_Name('INV',
4872: 'INV_FLEX_SEG_OUT_OF_RANGE');
4873: Manage_Error_Code('IN', 'APP-43014',
4874: Curr_Error);
4875: RAISE Error;
4890: and application_column_name = 'SEGMENT17';
4891:
4892: EXCEPTION
4893: WHEN NO_DATA_FOUND THEN
4894: FND_MESSAGE.Set_Name('INV',
4895: 'INV_INVALID_ITEM_SEG');
4896: FND_MESSAGE.Set_Token('SEGMENT',
4897: 'SEGMENT17',
4898: FALSE);
4892: EXCEPTION
4893: WHEN NO_DATA_FOUND THEN
4894: FND_MESSAGE.Set_Name('INV',
4895: 'INV_INVALID_ITEM_SEG');
4896: FND_MESSAGE.Set_Token('SEGMENT',
4897: 'SEGMENT17',
4898: FALSE);
4899: Manage_Error_Code('IN', 'APP-43014',
4900: Curr_Error);
4900: Curr_Error);
4901: RAISE Error;
4902:
4903: WHEN TOO_MANY_ROWS THEN
4904: FND_MESSAGE.Set_Name('INV',
4905: 'INV_MULTIPLE_FLEX_SEG');
4906: Manage_Error_Code('IN', 'APP-43014',
4907: Curr_Error);
4908: RAISE Error;
4922: if L_SegNumIndex <= L_FlexSeg_Counter then
4923: L_Segment_Array(L_SegNumIndex) :=
4924: P_Inventory_Item_Segment17;
4925: else
4926: FND_MESSAGE.Set_Name('INV',
4927: 'INV_FLEX_SEG_OUT_OF_RANGE');
4928: Manage_Error_Code('IN', 'APP-43014',
4929: Curr_Error);
4930: RAISE Error;
4945: and application_column_name = 'SEGMENT18';
4946:
4947: EXCEPTION
4948: WHEN NO_DATA_FOUND THEN
4949: FND_MESSAGE.Set_Name('INV',
4950: 'INV_INVALID_ITEM_SEG');
4951: FND_MESSAGE.Set_Token('SEGMENT',
4952: 'SEGMENT18',
4953: FALSE);
4947: EXCEPTION
4948: WHEN NO_DATA_FOUND THEN
4949: FND_MESSAGE.Set_Name('INV',
4950: 'INV_INVALID_ITEM_SEG');
4951: FND_MESSAGE.Set_Token('SEGMENT',
4952: 'SEGMENT18',
4953: FALSE);
4954: Manage_Error_Code('IN', 'APP-43014',
4955: Curr_Error);
4955: Curr_Error);
4956: RAISE Error;
4957:
4958: WHEN TOO_MANY_ROWS THEN
4959: FND_MESSAGE.Set_Name('INV',
4960: 'INV_MULTIPLE_FLEX_SEG');
4961: Manage_Error_Code('IN', 'APP-43014',
4962: Curr_Error);
4963: RAISE Error;
4977: if L_SegNumIndex <= L_FlexSeg_Counter then
4978: L_Segment_Array(L_SegNumIndex) :=
4979: P_Inventory_Item_Segment18;
4980: else
4981: FND_MESSAGE.Set_Name('INV',
4982: 'INV_FLEX_SEG_OUT_OF_RANGE');
4983: Manage_Error_Code('IN', 'APP-43014',
4984: Curr_Error);
4985: RAISE Error;
5000: and application_column_name = 'SEGMENT19';
5001:
5002: EXCEPTION
5003: WHEN NO_DATA_FOUND THEN
5004: FND_MESSAGE.Set_Name('INV',
5005: 'INV_INVALID_ITEM_SEG');
5006: FND_MESSAGE.Set_Token('SEGMENT',
5007: 'SEGMENT19',
5008: FALSE);
5002: EXCEPTION
5003: WHEN NO_DATA_FOUND THEN
5004: FND_MESSAGE.Set_Name('INV',
5005: 'INV_INVALID_ITEM_SEG');
5006: FND_MESSAGE.Set_Token('SEGMENT',
5007: 'SEGMENT19',
5008: FALSE);
5009: Manage_Error_Code('IN', 'APP-43014',
5010: Curr_Error);
5010: Curr_Error);
5011: RAISE Error;
5012:
5013: WHEN TOO_MANY_ROWS THEN
5014: FND_MESSAGE.Set_Name('INV',
5015: 'INV_MULTIPLE_FLEX_SEG');
5016: Manage_Error_Code('IN', 'APP-43014',
5017: Curr_Error);
5018: RAISE Error;
5032: if L_SegNumIndex <= L_FlexSeg_Counter then
5033: L_Segment_Array(L_SegNumIndex) :=
5034: P_Inventory_Item_Segment19;
5035: else
5036: FND_MESSAGE.Set_Name('INV',
5037: 'INV_FLEX_SEG_OUT_OF_RANGE');
5038: Manage_Error_Code('IN', 'APP-43014',
5039: Curr_Error);
5040: RAISE Error;
5055: and application_column_name = 'SEGMENT20';
5056:
5057: EXCEPTION
5058: WHEN NO_DATA_FOUND THEN
5059: FND_MESSAGE.Set_Name('INV',
5060: 'INV_INVALID_ITEM_SEG');
5061: FND_MESSAGE.Set_Token('SEGMENT',
5062: 'SEGMENT20',
5063: FALSE);
5057: EXCEPTION
5058: WHEN NO_DATA_FOUND THEN
5059: FND_MESSAGE.Set_Name('INV',
5060: 'INV_INVALID_ITEM_SEG');
5061: FND_MESSAGE.Set_Token('SEGMENT',
5062: 'SEGMENT20',
5063: FALSE);
5064: Manage_Error_Code('IN', 'APP-43014',
5065: Curr_Error);
5065: Curr_Error);
5066: RAISE Error;
5067:
5068: WHEN TOO_MANY_ROWS THEN
5069: FND_MESSAGE.Set_Name('INV',
5070: 'INV_MULTIPLE_FLEX_SEG');
5071: Manage_Error_Code('IN', 'APP-43014',
5072: Curr_Error);
5073: RAISE Error;
5087: if L_SegNumIndex <= L_FlexSeg_Counter then
5088: L_Segment_Array(L_SegNumIndex) :=
5089: P_Inventory_Item_Segment20;
5090: else
5091: FND_MESSAGE.Set_Name('INV',
5092: 'INV_FLEX_SEG_OUT_OF_RANGE');
5093: Manage_Error_Code('IN', 'APP-43014',
5094: Curr_Error);
5095: RAISE Error;
5107: L_FlexSeg_Counter,
5108: L_Segment_Array,
5109: L_Delimiter);
5110: else
5111: FND_MESSAGE.Set_Name('INV',
5112: 'INV_FLEX_SEG_MISMATCH');
5113: Manage_Error_Code('IN', 'APP-43014',
5114: Curr_Error);
5115: RAISE Error;
5135: end if;
5136:
5137: If P_Inventory_Item_Id is NULL then
5138:
5139: FND_MESSAGE.Set_Name('INV',
5140: 'INV_INVALID_CONTAINER');
5141: FND_MESSAGE.Set_Token('COLUMN',
5142: 'INVENTORY_ITEM', FALSE);
5143: Manage_Error_Code('IN', 'APP-43014',
5137: If P_Inventory_Item_Id is NULL then
5138:
5139: FND_MESSAGE.Set_Name('INV',
5140: 'INV_INVALID_CONTAINER');
5141: FND_MESSAGE.Set_Token('COLUMN',
5142: 'INVENTORY_ITEM', FALSE);
5143: Manage_Error_Code('IN', 'APP-43014',
5144: Curr_Error);
5145: RAISE Error;
5145: RAISE Error;
5146: END IF;
5147:
5148: else
5149: FND_MESSAGE.Set_Name('INV',
5150: 'INV_CONCAT_SEG_ERROR');
5151: Manage_Error_Code('IN', 'APP-43014',
5152: Curr_Error);
5153: RAISE Error;
5153: RAISE Error;
5154: end if;
5155:
5156: ELSE
5157: FND_MESSAGE.Set_Name('INV', 'INV_NO_ITEM');
5158: Manage_Error_Code('IN', 'APP-43030', Curr_Error);
5159: RAISE Error;
5160: END IF;
5161: --PLM 11.5.10 validation. XRef can be done only for Approved Items
5171:
5172: EXCEPTION
5173:
5174: WHEN NO_DATA_FOUND THEN
5175: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_INV_ITEM');
5176: IF (P_Inventory_Item_Id IS NOT NULL) THEN
5177: FND_MESSAGE.Set_Token('COLUMN',
5178: 'INVENTORY_ITEM_ID', FALSE);
5179: ELSIF ((P_Inventory_Item_Id IS NULL) AND
5173:
5174: WHEN NO_DATA_FOUND THEN
5175: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_INV_ITEM');
5176: IF (P_Inventory_Item_Id IS NOT NULL) THEN
5177: FND_MESSAGE.Set_Token('COLUMN',
5178: 'INVENTORY_ITEM_ID', FALSE);
5179: ELSIF ((P_Inventory_Item_Id IS NULL) AND
5180: (P_Inventory_Item IS NOT NULL)) THEN
5181: FND_MESSAGE.Set_Token('COLUMN',
5177: FND_MESSAGE.Set_Token('COLUMN',
5178: 'INVENTORY_ITEM_ID', FALSE);
5179: ELSIF ((P_Inventory_Item_Id IS NULL) AND
5180: (P_Inventory_Item IS NOT NULL)) THEN
5181: FND_MESSAGE.Set_Token('COLUMN',
5182: 'INVENTORY_ITEM', FALSE);
5183: ELSE
5184: FND_MESSAGE.Set_Token('COLUMN',
5185: 'INVENTORY_ITEM_SEGMENT1 - 20',
5180: (P_Inventory_Item IS NOT NULL)) THEN
5181: FND_MESSAGE.Set_Token('COLUMN',
5182: 'INVENTORY_ITEM', FALSE);
5183: ELSE
5184: FND_MESSAGE.Set_Token('COLUMN',
5185: 'INVENTORY_ITEM_SEGMENT1 - 20',
5186: FALSE);
5187: END IF;
5188: Manage_Error_Code('IN', 'APP-43031', Curr_Error);
5189: RAISE Error;
5190:
5191: WHEN TOO_MANY_ROWS THEN
5192:
5193: FND_MESSAGE.Set_Name('INV', 'INV_MULTIPLE_ITEMS');
5194: Manage_Error_Code('IN', 'APP-43056', Curr_Error);
5195: RAISE Error;
5196:
5197: END Validate_Inventory_Item;
5220: P_Inactive_Flag := 'N';
5221: RETURN;
5222: END IF;
5223: ELSE
5224: FND_MESSAGE.Set_Name('INV', 'INV_INVALID_INACTIVE_FLAG');
5225: Manage_Error_Code('IN', 'APP-43032', Curr_Error);
5226: RAISE Error;
5227: END IF;
5228:
5243: RETURN;
5244:
5245: ELSE
5246:
5247: FND_MESSAGE.Set_Name('INV', 'INV_NO_CONCURRENT_PROG_INFO');
5248: Manage_Error_Code('IN', 'APP-43033', Curr_Error);
5249: RAISE Error;
5250:
5251: END IF;
5289: AND MCI.Item_Definition_Level = P_Item_Definition_Level
5290: AND NVL(MCI.Customer_Category_Code, ' ') = NVL(P_Customer_Category_Code, ' ')
5291: AND NVL(MCI.Address_Id, -1) = NVL(P_Address_Id, -1);
5292: IF (SQL%FOUND) THEN
5293: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_RECORD');
5294: Manage_Error_Code('IN', 'APP-43034', Curr_Error);
5295: RAISE Error;
5296: END IF;
5297:
5307: AND Rownum = 1;
5308:
5309: IF (SQL%FOUND) THEN
5310:
5311: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5312: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5313: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5314: FND_MESSAGE.Set_Token('COLUMN3', 'INVENTORY_ITEM_ID', FALSE);
5315: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5308:
5309: IF (SQL%FOUND) THEN
5310:
5311: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5312: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5313: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5314: FND_MESSAGE.Set_Token('COLUMN3', 'INVENTORY_ITEM_ID', FALSE);
5315: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5316: RAISE Error;
5309: IF (SQL%FOUND) THEN
5310:
5311: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5312: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5313: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5314: FND_MESSAGE.Set_Token('COLUMN3', 'INVENTORY_ITEM_ID', FALSE);
5315: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5316: RAISE Error;
5317:
5310:
5311: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5312: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5313: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5314: FND_MESSAGE.Set_Token('COLUMN3', 'INVENTORY_ITEM_ID', FALSE);
5315: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5316: RAISE Error;
5317:
5318: ELSE
5326: AND Rownum = 1;
5327:
5328: IF (SQL%FOUND) THEN
5329:
5330: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5331: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5332: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5333: FND_MESSAGE.Set_Token('COLUMN3', 'PREFERENCE_NUMBER', FALSE);
5334: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5327:
5328: IF (SQL%FOUND) THEN
5329:
5330: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5331: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5332: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5333: FND_MESSAGE.Set_Token('COLUMN3', 'PREFERENCE_NUMBER', FALSE);
5334: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5335: RAISE Error;
5328: IF (SQL%FOUND) THEN
5329:
5330: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5331: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5332: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5333: FND_MESSAGE.Set_Token('COLUMN3', 'PREFERENCE_NUMBER', FALSE);
5334: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5335: RAISE Error;
5336:
5329:
5330: FND_MESSAGE.Set_Name('INV', 'INV_NON_UNIQUE_CI_XREF_RECORD');
5331: FND_MESSAGE.Set_Token('COLUMN1', 'CUSTOMER_ITEM_ID', FALSE);
5332: FND_MESSAGE.Set_Token('COLUMN2', 'MASTER_ORGANIZATION_ID', FALSE);
5333: FND_MESSAGE.Set_Token('COLUMN3', 'PREFERENCE_NUMBER', FALSE);
5334: Manage_Error_Code('IN', 'APP-43035', Curr_Error);
5335: RAISE Error;
5336:
5337: END IF;
5379: (P_Last_Update_Date IS NULL) OR
5380: (P_Created_By IS NULL) OR
5381: (P_Creation_Date IS NULL)) THEN
5382:
5383: FND_MESSAGE.Set_Name('INV', 'INV_REQUIRED_COLUMNS_MISSING');
5384: Manage_Error_Code('IN', 'APP-43036', Curr_Error);
5385: RAISE Error;
5386:
5387: ELSE
5402: (P_Last_Update_Date IS NULL) OR
5403: (P_Created_By IS NULL) OR
5404: (P_Creation_Date IS NULL)) THEN
5405:
5406: FND_MESSAGE.Set_Name('INV', 'INV_REQUIRED_COLUMNS_MISSING');
5407: Manage_Error_Code('IN', 'APP-43036', Curr_Error);
5408: RAISE Error;
5409:
5410: ELSE
5648: EXCEPTION
5649:
5650: WHEN NO_DATA_FOUND THEN
5651:
5652: FND_MESSAGE.Set_Name('INV', 'INV_NO_ROW_INSERTED');
5653: Manage_Error_Code('IN', 'APP-43025', Curr_Error);
5654: RAISE Error;
5655:
5656: END Insert_Row;
5701: EXCEPTION
5702:
5703: WHEN NO_DATA_FOUND THEN
5704:
5705: FND_MESSAGE.Set_Name('INV', 'INV_NO_ROW_DELETED');
5706: Manage_Error_Code('IN', 'APP-43026', Curr_Error);
5707: RAISE Error;
5708:
5709: END Delete_Row;