[Home] [Help]
107: /* user passed more parameters than needed by global data elements,
108: * even though context is passed as null. hence error out
109: */
110: --DBMS_output.put_line('more params passed than needed');
111: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
112: fnd_message.set_token('CONTEXT', 'NULL');
113: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
114: fnd_msg_pub.ADD;
115: RAISE fnd_api.g_exc_error;
108: * even though context is passed as null. hence error out
109: */
110: --DBMS_output.put_line('more params passed than needed');
111: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
112: fnd_message.set_token('CONTEXT', 'NULL');
113: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
114: fnd_msg_pub.ADD;
115: RAISE fnd_api.g_exc_error;
116: END IF;
109: */
110: --DBMS_output.put_line('more params passed than needed');
111: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
112: fnd_message.set_token('CONTEXT', 'NULL');
113: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
114: fnd_msg_pub.ADD;
115: RAISE fnd_api.g_exc_error;
116: END IF;
117:
124: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR
125: NOT p_attributes_tbl.EXISTS(col))
126: THEN
127: --DBMS_output.put_line('y r we here');
128: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
129: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
130: fnd_msg_pub.ADD;
131: RAISE fnd_api.g_exc_error;
132: END IF;
125: NOT p_attributes_tbl.EXISTS(col))
126: THEN
127: --DBMS_output.put_line('y r we here');
128: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
129: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
130: fnd_msg_pub.ADD;
131: RAISE fnd_api.g_exc_error;
132: END IF;
133: ELSE
197: --DBMS_output.put_line('col is ' || col);
198: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) IS NULL) OR
199: NOT p_attributes_tbl.EXISTS(col))
200: THEN
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
202: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: --DBMS_output.put_line('Req segment is not populated');
198: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) IS NULL) OR
199: NOT p_attributes_tbl.EXISTS(col))
200: THEN
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
202: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: --DBMS_output.put_line('Req segment is not populated');
206: END IF;
255:
256: --DBMS_output.put_line('Here are the error messages: ');
257: WHILE e < 5001
258: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
259: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
260: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
261: fnd_msg_pub.ADD;
262: --DBMS_output.put_line(SUBSTR(error_msg, s, e));
263: s := s + 200;
256: --DBMS_output.put_line('Here are the error messages: ');
257: WHILE e < 5001
258: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
259: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
260: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
261: fnd_msg_pub.ADD;
262: --DBMS_output.put_line(SUBSTR(error_msg, s, e));
263: s := s + 200;
264: e := e + 200;
497: FROM mtl_parameters
498: WHERE organization_id = l_organization_id;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_error;
504: END;
505:
506: ELSE -- p_organization_id is NULL
507:
508: IF p_organization_code IS NULL THEN
509:
510: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
511: fnd_msg_pub.ADD;
512: RAISE fnd_api.g_exc_error;
513:
514: ELSE -- p_organization_code is NULL
523: WHERE organization_code = p_organization_code;
524:
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
528: fnd_msg_pub.ADD;
529: RAISE fnd_api.g_exc_error;
530: END;
531:
544: * is valid or not
545: */
546: IF p_subinventory_code IS NULL THEN
547:
548: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
549: fnd_msg_pub.ADD;
550: RAISE fnd_api.g_exc_error;
551:
552: ELSE -- p_subinventory_code is NULL
567:
568: EXCEPTION
569:
570: WHEN NO_DATA_FOUND THEN
571: fnd_message.set_name('INV', 'INVALID_SUB');
572: fnd_msg_pub.ADD;
573: RAISE fnd_api.g_exc_error;
574:
575: END;
581: -- If the sub is of type 'Receiving', then the locator cannot be of type 'Storage'.
582: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
583: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR -- 4911279
584: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
585: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
586: fnd_msg_pub.ADD;
587: RAISE fnd_api.g_exc_error;
588: END IF;
589:
597: l_alias := p_alias;
598:
599: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
600:
601: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
602: fnd_msg_pub.ADD;
603: RAISE fnd_api.g_exc_error;
604:
605: END IF;
622: WHERE organization_id = p_organization_id
623: AND alias = l_alias
624: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
625:
626: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
627: fnd_message.set_token('LOCATOR', l_locator);
628: fnd_msg_pub.ADD;
629: RAISE fnd_api.g_exc_error;
630:
623: AND alias = l_alias
624: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
625:
626: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
627: fnd_message.set_token('LOCATOR', l_locator);
628: fnd_msg_pub.ADD;
629: RAISE fnd_api.g_exc_error;
630:
631: EXCEPTION
646: AND alias = l_alias
647: AND subinventory_code = p_subinventory_code
648: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
649:
650: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
651: fnd_message.set_token('LOCATOR', l_locator);
652: fnd_msg_pub.ADD;
653: RAISE fnd_api.g_exc_error;
654:
647: AND subinventory_code = p_subinventory_code
648: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
649:
650: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
651: fnd_message.set_token('LOCATOR', l_locator);
652: fnd_msg_pub.ADD;
653: RAISE fnd_api.g_exc_error;
654:
655: EXCEPTION
669: */
670:
671: IF p_concatenated_segments IS NULL THEN
672:
673: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
674: fnd_msg_pub.ADD;
675: RAISE fnd_api.g_exc_error;
676:
677: END IF;
686: AND concatenated_segments = p_concatenated_segments
687: AND ROWNUM < 2;
688:
689: x_locator_exists:= 'Y';
690: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
691: fnd_msg_pub.add;
692: fnd_msg_pub.count_and_get
693: ( p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
715:
716: IF l_val = TRUE THEN
717: x_locator_exists := 'Y';
718: x_inventory_location_id := fnd_flex_keyval.combination_id;
719: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
720: fnd_msg_pub.ADD;
721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
722: RETURN;
723: END IF;
735: WHERE status_id = p_status_id
736: AND enabled_flag = 1;
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
739: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
740: fnd_msg_pub.ADD;
741: RAISE fnd_api.g_exc_error;
742: END;
743: END IF;
749: FROM mtl_units_of_measure
750: WHERE uom_code = p_location_weight_uom_code;
751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
754: fnd_msg_pub.ADD;
755: RAISE fnd_api.g_exc_error;
756: END;
757: END IF;
766: FROM mtl_units_of_measure
767: WHERE uom_code = p_volume_uom_code;
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');
771: fnd_msg_pub.ADD;
772: RAISE fnd_api.g_exc_error;
773: END;
774: END IF;
781: FROM mtl_units_of_measure
782: WHERE uom_code = p_pick_uom_code;
783: EXCEPTION
784: WHEN NO_DATA_FOUND THEN
785: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');
786: fnd_msg_pub.ADD;
787: RAISE fnd_api.g_exc_error;
788: END;
789: END IF;
798: FROM mtl_units_of_measure
799: WHERE uom_code = p_dimension_uom_code;
800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN
802: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
803: fnd_msg_pub.ADD;
804: RAISE fnd_api.g_exc_error;
805: END;
806: END IF;
858:
859: --DBMS_output.put_line('Validity check passed ');
860: IF (l_keystat_val = FALSE) THEN
861: --DBMS_output.put_line('validate segment failed ');
862: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
863: fnd_msg_pub.ADD;
864: RAISE fnd_api.g_exc_unexpected_error;
865: ELSE
866: x_inventory_location_id := fnd_flex_keyval.combination_id;
900: -- l_loc_type := NULL;
901: -- END IF;
902: ELSE
903: --DBMS_output.put_line('Wms installed check failed ');
904: fnd_message.set_name('WMS', 'WMS_INSTALL_CHK_ERROR');
905: fnd_msg_pub.ADD;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END IF;
908:
922:
923: IF(l_project_reference_enabled = 'Y') THEN
924: IF( l_project_control_level =2 AND l_segment20 IS NULL) THEN
925:
926: fnd_message.set_name('INV', 'INV_TASK_NUM_INVALID');
927: fnd_msg_pub.ADD;
928: RAISE fnd_api.g_exc_error;
929: END IF;
930: END IF;
1010: );
1011:
1012: IF l_return_status = 'E' THEN
1013: --DBMS_output.put_line('Error from validate_loc_attr_info');
1014: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1015: fnd_msg_pub.ADD;
1016: RAISE fnd_api.g_exc_error;
1017: ELSIF l_return_status = 'U' THEN
1018: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1015: fnd_msg_pub.ADD;
1016: RAISE fnd_api.g_exc_error;
1017: ELSIF l_return_status = 'U' THEN
1018: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1019: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1020: fnd_msg_pub.ADD;
1021: RAISE fnd_api.g_exc_unexpected_error;
1022: END IF;
1023: /* End locator DFF attributes validation */
1091: inv_material_status_pkg.insert_status_history(l_status_rec);
1092: END IF;
1093: END IF; -- (l_keystat_val = FALSE)
1094: ELSE
1095: fnd_message.set_name('INV', 'INV_LOC_BELONG_TO_OTH_SUB');
1096: fnd_msg_pub.ADD;
1097: RAISE fnd_api.g_exc_error;
1098: END IF; -- (l_validility = passed)
1099:
1332: FROM mtl_parameters
1333: WHERE organization_id = l_organization_id;
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1337: fnd_msg_pub.ADD;
1338: RAISE fnd_api.g_exc_error;
1339: END;
1340:
1341: ELSE -- p_organization_id IS NULL
1342:
1343: IF p_organization_code IS NULL THEN
1344:
1345: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1346: fnd_msg_pub.ADD;
1347: RAISE fnd_api.g_exc_error;
1348:
1349: ELSE -- p_organization_code is NULL
1356: FROM mtl_parameters
1357: WHERE organization_code = p_organization_code;
1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN
1360: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1361: fnd_msg_pub.ADD;
1362: RAISE fnd_api.g_exc_error;
1363: END;
1364:
1372: */
1373:
1374: IF (p_concatenated_segments IS NULL AND p_inventory_location_id IS NULL) THEN
1375:
1376: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1377: fnd_msg_pub.ADD;
1378: RAISE fnd_api.g_exc_error;
1379:
1380: ELSIF p_concatenated_segments IS NOT NULL AND p_inventory_location_id IS NULL THEN
1399: , data_set => l_organization_id
1400: );
1401:
1402: IF l_val = FALSE THEN
1403: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1404: fnd_msg_pub.ADD;
1405: RAISE fnd_api.g_exc_error;
1406: ELSE
1407: l_inventory_location_id := fnd_flex_keyval.combination_id;
1422:
1423: IF (p_inventory_location_type <> fnd_api.g_miss_num AND
1424: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1425:
1426: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1427: fnd_msg_pub.ADD;
1428: RAISE fnd_api.g_exc_error;
1429:
1430: END IF;
1442: AND mil.subinventory_code = msi.secondary_inventory_name
1443: AND msi.organization_id = l_organization_id;
1444: EXCEPTION
1445: WHEN NO_DATA_FOUND THEN
1446: fnd_message.set_name('INV', 'INVALID_SUB');
1447: fnd_msg_pub.ADD;
1448: RAISE fnd_api.g_exc_error;
1449: END;
1450:
1452: -- If the sub is of type 'Receiving', then the locator cannot be of type 'Storage'.
1453: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
1454: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR --4911279
1455: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
1456: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1457: fnd_msg_pub.ADD;
1458: RAISE fnd_api.g_exc_error;
1459: END IF;
1460: END IF;
1493: l_alias := p_alias;
1494:
1495: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
1496:
1497: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
1498: fnd_msg_pub.ADD;
1499: RAISE fnd_api.g_exc_error;
1500:
1501: END IF;
1515: WHERE organization_id = p_organization_id
1516: AND alias = l_alias
1517: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1518:
1519: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1520: fnd_message.set_token('LOCATOR', l_locator);
1521: fnd_msg_pub.ADD;
1522: RAISE fnd_api.g_exc_error;
1523:
1516: AND alias = l_alias
1517: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1518:
1519: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1520: fnd_message.set_token('LOCATOR', l_locator);
1521: fnd_msg_pub.ADD;
1522: RAISE fnd_api.g_exc_error;
1523:
1524: EXCEPTION
1538: AND alias = l_alias
1539: AND subinventory_code = l_subinventory_code
1540: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1541:
1542: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1543: fnd_message.set_token('LOCATOR', l_locator);
1544: fnd_msg_pub.ADD;
1545: RAISE fnd_api.g_exc_error;
1546:
1539: AND subinventory_code = l_subinventory_code
1540: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1541:
1542: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1543: fnd_message.set_token('LOCATOR', l_locator);
1544: fnd_msg_pub.ADD;
1545: RAISE fnd_api.g_exc_error;
1546:
1547: EXCEPTION
1567: FROM mtl_units_of_measure
1568: WHERE uom_code = p_location_weight_uom_code;
1569: EXCEPTION
1570: WHEN NO_DATA_FOUND THEN
1571: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1572: fnd_msg_pub.ADD;
1573: RAISE fnd_api.g_exc_error;
1574: END;
1575: END IF;
1585: FROM mtl_units_of_measure
1586: WHERE uom_code = p_volume_uom_code;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1590: fnd_msg_pub.ADD;
1591: RAISE fnd_api.g_exc_error;
1592: END;
1593: END IF;
1602: FROM mtl_units_of_measure
1603: WHERE uom_code = p_pick_uom_code;
1604: EXCEPTION
1605: WHEN NO_DATA_FOUND THEN
1606: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');
1607: fnd_msg_pub.ADD;
1608: RAISE fnd_api.g_exc_error;
1609: END;
1610: END IF;
1620: FROM mtl_units_of_measure
1621: WHERE uom_code = p_dimension_uom_code;
1622: EXCEPTION
1623: WHEN NO_DATA_FOUND THEN
1624: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
1625: fnd_msg_pub.ADD;
1626: RAISE fnd_api.g_exc_error;
1627: END;
1628: END IF;
1638: WHERE status_id = p_status_id
1639: AND enabled_flag = 1;
1640: EXCEPTION
1641: WHEN NO_DATA_FOUND THEN
1642: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1643: fnd_msg_pub.ADD;
1644: RAISE fnd_api.g_exc_error;
1645: END;
1646: END IF;
1788: );
1789:
1790: IF l_return_status = 'E' THEN
1791: --DBMS_output.put_line('Error from validate_loc_attr_info');
1792: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1793: fnd_msg_pub.ADD;
1794: RAISE fnd_api.g_exc_error;
1795: ELSIF l_return_status = 'U' THEN
1796: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1793: fnd_msg_pub.ADD;
1794: RAISE fnd_api.g_exc_error;
1795: ELSIF l_return_status = 'U' THEN
1796: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1797: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1798: fnd_msg_pub.ADD;
1799: RAISE fnd_api.g_exc_unexpected_error;
1800: END IF;
1801: /* End locator DFF attributes validation */
1980: IF p_organization_id IS NOT NULL THEN
1981: l_organization_id := p_organization_id;
1982: ELSE
1983: IF p_organization_code IS NULL THEN
1984: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1985: /* Organization is required */
1986: fnd_msg_pub.ADD;
1987: RAISE fnd_api.g_exc_error;
1988: ELSE
1992: FROM mtl_parameters
1993: WHERE organization_code = p_organization_code;
1994: EXCEPTION
1995: WHEN NO_DATA_FOUND THEN
1996: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1997: /* The Organization Code provided is invalid */
1998: fnd_msg_pub.ADD;
1999: RAISE fnd_api.g_exc_error;
2000: END;
2005: IF p_inventory_item_id IS NOT NULL THEN
2006: l_inventory_item_id := p_inventory_item_id;
2007: ELSE
2008: IF p_item IS NULL THEN
2009: fnd_message.set_name('INV', 'INV_INT_ITMSEGCODE');
2010: /* Invalid item segments */
2011: fnd_msg_pub.ADD;
2012: RAISE fnd_api.g_exc_error;
2013: ELSE
2018: WHERE concatenated_segments = p_item
2019: AND organization_id = l_organization_id;
2020: EXCEPTION
2021: WHEN NO_DATA_FOUND THEN
2022: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2023: /* The Item provided is invalid */
2024: fnd_msg_pub.ADD;
2025: RAISE fnd_api.g_exc_error;
2026: END;
2028: END IF;
2029:
2030: /*Validate the subinventory code */
2031: IF p_subinventory_code IS NULL THEN
2032: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
2033: /* Please enter a subinventory before proceeding */
2034: fnd_msg_pub.ADD;
2035: RAISE fnd_api.g_exc_error;
2036: ELSE
2041: WHERE secondary_inventory_name = p_subinventory_code
2042: AND organization_id = l_organization_id;
2043: EXCEPTION
2044: WHEN NO_DATA_FOUND THEN
2045: fnd_message.set_name('INV', 'INVALID_SUB');
2046: /* The subinventory provided is invalid */
2047: fnd_msg_pub.ADD;
2048: RAISE fnd_api.g_exc_error;
2049: END;
2053: IF p_inventory_location_id IS NOT NULL THEN
2054: l_locator_id := p_inventory_location_id;
2055: ELSE
2056: IF p_locator IS NULL THEN
2057: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2058: /* Invalid locator segments */
2059: fnd_msg_pub.ADD;
2060: RAISE fnd_api.g_exc_error;
2061: ELSE
2066: WHERE concatenated_segments = p_locator
2067: AND organization_id = l_organization_id;
2068: EXCEPTION
2069: WHEN NO_DATA_FOUND THEN
2070: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2071: /* The Locator provided is invalid */
2072: fnd_msg_pub.ADD;
2073: RAISE fnd_api.g_exc_error;
2074: END;
2084: AND subinventory_code = p_subinventory_code
2085: AND organization_id = l_organization_id;
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: fnd_message.set_name('INV', 'INV_INT_LOCSEGEXP');
2089: /* The Locator segments are invalid for the given subinventory, organization combination */
2090: RAISE fnd_api.g_exc_error;
2091: END;
2092:
2111: WHERE status_id = p_status_id
2112: AND enabled_flag = 1;
2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN
2115: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
2116: /* Invalid status ID. */
2117: fnd_msg_pub.ADD;
2118: RAISE fnd_api.g_exc_error;
2119: END;
2205: , p_status_id
2206: );
2207: END IF;
2208: ELSE
2209: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2210: /* Locator selected has already been assigned to this item and subinventory */
2211: fnd_msg_pub.ADD;
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2213: END IF;
2302:
2303: l_organization_id := p_organization_id;
2304: ELSE
2305: IF p_organization_code IS NULL THEN
2306: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2307: /* Organisation is required */
2308: fnd_msg_pub.ADD;
2309: RAISE fnd_api.g_exc_error;
2310: ELSE
2348: END IF;
2349:
2350: IF l_val = FALSE
2351: OR p_concatenated_segments IS NULL THEN
2352: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2353: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2354: /* LOCATOR does not exist */
2355: fnd_msg_pub.ADD;
2356: RAISE fnd_api.g_exc_error;
2349:
2350: IF l_val = FALSE
2351: OR p_concatenated_segments IS NULL THEN
2352: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2353: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2354: /* LOCATOR does not exist */
2355: fnd_msg_pub.ADD;
2356: RAISE fnd_api.g_exc_error;
2357: ELSE
2376: WHERE physical_location_id = l_inventory_location_id
2377: AND organization_id = l_organization_id
2378: AND inventory_location_id <> physical_location_id); --Bug :5036570
2379:
2380: fnd_message.set_name('INV', 'INV_LOC_PHY');
2381: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2382: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2383: fnd_msg_pub.ADD;
2384: RAISE fnd_api.g_exc_error;
2377: AND organization_id = l_organization_id
2378: AND inventory_location_id <> physical_location_id); --Bug :5036570
2379:
2380: fnd_message.set_name('INV', 'INV_LOC_PHY');
2381: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2382: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2383: fnd_msg_pub.ADD;
2384: RAISE fnd_api.g_exc_error;
2385: EXCEPTION
2401: WHERE inventory_location_id = l_inventory_location_id
2402: AND organization_id = l_organization_id
2403: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
2404:
2405: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2406: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2407: /*Locator locator cannot be deleted as it is active */
2408: fnd_msg_pub.ADD;
2409: RAISE fnd_api.g_exc_error;
2402: AND organization_id = l_organization_id
2403: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
2404:
2405: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2406: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2407: /*Locator locator cannot be deleted as it is active */
2408: fnd_msg_pub.ADD;
2409: RAISE fnd_api.g_exc_error;
2410: EXCEPTION
2427: FROM mtl_onhand_quantities_detail
2428: WHERE locator_id = l_inventory_location_id
2429: AND organization_id = l_organization_id);
2430:
2431: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2432: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2433: /*Locator locator cannot be deleted as items exist in it*/
2434: fnd_msg_pub.ADD;
2435: RAISE fnd_api.g_exc_error;
2428: WHERE locator_id = l_inventory_location_id
2429: AND organization_id = l_organization_id);
2430:
2431: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2432: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2433: /*Locator locator cannot be deleted as items exist in it*/
2434: fnd_msg_pub.ADD;
2435: RAISE fnd_api.g_exc_error;
2436: EXCEPTION
2449: FROM mtl_reservations
2450: WHERE locator_id = l_inventory_location_id
2451: AND organization_id = l_organization_id);
2452:
2453: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2454: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2455: /*The locator locator cannot be deleted as reservations exist against it*/
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2450: WHERE locator_id = l_inventory_location_id
2451: AND organization_id = l_organization_id);
2452:
2453: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2454: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2455: /*The locator locator cannot be deleted as reservations exist against it*/
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2458: EXCEPTION
2470: FROM wms_license_plate_numbers
2471: WHERE locator_id = l_inventory_location_id
2472: AND organization_id = l_organization_id);
2473:
2474: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2475: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2476: /*Locator locator cannot be deleted as LPNs reside in it*/
2477: fnd_msg_pub.ADD;
2478: RAISE fnd_api.g_exc_error;
2471: WHERE locator_id = l_inventory_location_id
2472: AND organization_id = l_organization_id);
2473:
2474: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2475: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2476: /*Locator locator cannot be deleted as LPNs reside in it*/
2477: fnd_msg_pub.ADD;
2478: RAISE fnd_api.g_exc_error;
2479: EXCEPTION
2491: FROM mtl_secondary_locators
2492: WHERE secondary_locator = l_inventory_location_id
2493: AND organization_id = l_organization_id);
2494:
2495: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2496: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2497: /*Locator locator cannot be deleted as it is tied to an item */
2498: fnd_msg_pub.ADD;
2499: RAISE fnd_api.g_exc_error;
2492: WHERE secondary_locator = l_inventory_location_id
2493: AND organization_id = l_organization_id);
2494:
2495: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2496: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2497: /*Locator locator cannot be deleted as it is tied to an item */
2498: fnd_msg_pub.ADD;
2499: RAISE fnd_api.g_exc_error;
2500: EXCEPTION
2512: FROM mtl_transactions_interface
2513: WHERE locator_id = l_inventory_location_id
2514: AND organization_id = l_organization_id);
2515:
2516: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2517: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2518: /*Locator locator cannot be deleted as there are pending transactions against it*/
2519: fnd_msg_pub.ADD;
2520: RAISE fnd_api.g_exc_error;
2513: WHERE locator_id = l_inventory_location_id
2514: AND organization_id = l_organization_id);
2515:
2516: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2517: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2518: /*Locator locator cannot be deleted as there are pending transactions against it*/
2519: fnd_msg_pub.ADD;
2520: RAISE fnd_api.g_exc_error;
2521: EXCEPTION
2539: AND organization_id = l_organization_id)
2540: OR(transfer_to_location = l_inventory_location_id
2541: AND NVL(transfer_organization, organization_id) = l_organization_id));
2542:
2543: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2544: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2545: /*Locator locator cannot be deleted as there are pending transactions against it*/
2546: fnd_msg_pub.ADD;
2547: RAISE fnd_api.g_exc_error;
2540: OR(transfer_to_location = l_inventory_location_id
2541: AND NVL(transfer_organization, organization_id) = l_organization_id));
2542:
2543: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2544: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2545: /*Locator locator cannot be deleted as there are pending transactions against it*/
2546: fnd_msg_pub.ADD;
2547: RAISE fnd_api.g_exc_error;
2548: EXCEPTION
2560: FROM rcv_transactions_interface
2561: WHERE locator_id = l_inventory_location_id
2562: AND to_organization_id = l_organization_id);
2563:
2564: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2565: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2566: /*Locator locator cannot be deleted as there are pending transactions against it*/
2567: fnd_msg_pub.ADD;
2568: RAISE fnd_api.g_exc_error;
2561: WHERE locator_id = l_inventory_location_id
2562: AND to_organization_id = l_organization_id);
2563:
2564: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2565: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2566: /*Locator locator cannot be deleted as there are pending transactions against it*/
2567: fnd_msg_pub.ADD;
2568: RAISE fnd_api.g_exc_error;
2569: EXCEPTION