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