[Home] [Help]
159: /* user passed more parameters than needed by global data elements,
160: * even though context is passed as null. hence error out
161: */
162: --DBMS_output.put_line('more params passed than needed');
163: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
164: fnd_message.set_token('CONTEXT', 'NULL');
165: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
166: fnd_msg_pub.ADD;
167: RAISE fnd_api.g_exc_error;
160: * even though context is passed as null. hence error out
161: */
162: --DBMS_output.put_line('more params passed than needed');
163: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
164: fnd_message.set_token('CONTEXT', 'NULL');
165: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
166: fnd_msg_pub.ADD;
167: RAISE fnd_api.g_exc_error;
168: END IF;
161: */
162: --DBMS_output.put_line('more params passed than needed');
163: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
164: fnd_message.set_token('CONTEXT', 'NULL');
165: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
166: fnd_msg_pub.ADD;
167: RAISE fnd_api.g_exc_error;
168: END IF;
169:
176: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) = fnd_api.g_miss_char) OR
177: NOT p_attributes_tbl.EXISTS(col))
178: THEN
179: --DBMS_output.put_line('y r we here');
180: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
181: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
182: fnd_msg_pub.ADD;
183: RAISE fnd_api.g_exc_error;
184: END IF;
177: NOT p_attributes_tbl.EXISTS(col))
178: THEN
179: --DBMS_output.put_line('y r we here');
180: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
181: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
182: fnd_msg_pub.ADD;
183: RAISE fnd_api.g_exc_error;
184: END IF;
185: ELSE
249: --DBMS_output.put_line('col is ' || col);
250: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) IS NULL) OR
251: NOT p_attributes_tbl.EXISTS(col))
252: THEN
253: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
254: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
255: fnd_msg_pub.ADD;
256: RAISE fnd_api.g_exc_error;
257: --DBMS_output.put_line('Req segment is not populated');
250: IF ((p_attributes_tbl.EXISTS(col) AND p_attributes_tbl(col) IS NULL) OR
251: NOT p_attributes_tbl.EXISTS(col))
252: THEN
253: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
254: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
255: fnd_msg_pub.ADD;
256: RAISE fnd_api.g_exc_error;
257: --DBMS_output.put_line('Req segment is not populated');
258: END IF;
307:
308: --DBMS_output.put_line('Here are the error messages: ');
309: WHILE e < 5001
310: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
311: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
312: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
313: fnd_msg_pub.ADD;
314: --DBMS_output.put_line(SUBSTR(error_msg, s, e));
315: s := s + 200;
308: --DBMS_output.put_line('Here are the error messages: ');
309: WHILE e < 5001
310: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
311: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
312: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
313: fnd_msg_pub.ADD;
314: --DBMS_output.put_line(SUBSTR(error_msg, s, e));
315: s := s + 200;
316: e := e + 200;
555: FROM mtl_parameters
556: WHERE organization_id = l_organization_id;
557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
560: fnd_msg_pub.ADD;
561: RAISE fnd_api.g_exc_error;
562: END;
563:
564: ELSE -- p_organization_id is NULL
565:
566: IF p_organization_code IS NULL THEN
567:
568: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
569: fnd_msg_pub.ADD;
570: RAISE fnd_api.g_exc_error;
571:
572: ELSE -- p_organization_code is NULL
581: WHERE organization_code = p_organization_code;
582:
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
586: fnd_msg_pub.ADD;
587: RAISE fnd_api.g_exc_error;
588: END;
589:
602: * is valid or not
603: */
604: IF p_subinventory_code IS NULL THEN
605:
606: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
607: fnd_msg_pub.ADD;
608: RAISE fnd_api.g_exc_error;
609:
610: ELSE -- p_subinventory_code is NULL
625:
626: EXCEPTION
627:
628: WHEN NO_DATA_FOUND THEN
629: fnd_message.set_name('INV', 'INVALID_SUB');
630: fnd_msg_pub.ADD;
631: RAISE fnd_api.g_exc_error;
632:
633: END;
639: -- If the sub is of type 'Receiving', then the locator cannot be of type 'Storage'.
640: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
641: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR -- 4911279
642: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
643: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
644: fnd_msg_pub.ADD;
645: RAISE fnd_api.g_exc_error;
646: END IF;
647:
655: l_alias := p_alias;
656:
657: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
658:
659: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
660: fnd_msg_pub.ADD;
661: RAISE fnd_api.g_exc_error;
662:
663: END IF;
680: WHERE organization_id = p_organization_id
681: AND alias = l_alias
682: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
683:
684: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
685: fnd_message.set_token('LOCATOR', l_locator);
686: fnd_msg_pub.ADD;
687: RAISE fnd_api.g_exc_error;
688:
681: AND alias = l_alias
682: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
683:
684: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
685: fnd_message.set_token('LOCATOR', l_locator);
686: fnd_msg_pub.ADD;
687: RAISE fnd_api.g_exc_error;
688:
689: EXCEPTION
704: AND alias = l_alias
705: AND subinventory_code = p_subinventory_code
706: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
707:
708: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
709: fnd_message.set_token('LOCATOR', l_locator);
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_error;
712:
705: AND subinventory_code = p_subinventory_code
706: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
707:
708: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
709: fnd_message.set_token('LOCATOR', l_locator);
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_error;
712:
713: EXCEPTION
727: */
728:
729: IF p_concatenated_segments IS NULL THEN
730:
731: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
732: fnd_msg_pub.ADD;
733: RAISE fnd_api.g_exc_error;
734:
735: END IF;
744: AND concatenated_segments = p_concatenated_segments
745: AND ROWNUM < 2;
746:
747: x_locator_exists:= 'Y';
748: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
749: fnd_msg_pub.add;
750: fnd_msg_pub.count_and_get
751: ( p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
773:
774: IF l_val = TRUE THEN
775: x_locator_exists := 'Y';
776: x_inventory_location_id := fnd_flex_keyval.combination_id;
777: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
778: fnd_msg_pub.ADD;
779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
780: RETURN;
781: END IF;
793: WHERE status_id = p_status_id
794: AND enabled_flag = 1;
795: EXCEPTION
796: WHEN NO_DATA_FOUND THEN
797: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
798: fnd_msg_pub.ADD;
799: RAISE fnd_api.g_exc_error;
800: END;
801: END IF;
807: FROM mtl_units_of_measure
808: WHERE uom_code = p_location_weight_uom_code;
809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
812: fnd_msg_pub.ADD;
813: RAISE fnd_api.g_exc_error;
814: END;
815: END IF;
824: FROM mtl_units_of_measure
825: WHERE uom_code = p_volume_uom_code;
826: EXCEPTION
827: WHEN NO_DATA_FOUND THEN
828: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');
829: fnd_msg_pub.ADD;
830: RAISE fnd_api.g_exc_error;
831: END;
832: END IF;
839: FROM mtl_units_of_measure
840: WHERE uom_code = p_pick_uom_code;
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');
844: fnd_msg_pub.ADD;
845: RAISE fnd_api.g_exc_error;
846: END;
847: END IF;
856: FROM mtl_units_of_measure
857: WHERE uom_code = p_dimension_uom_code;
858: EXCEPTION
859: WHEN NO_DATA_FOUND THEN
860: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
861: fnd_msg_pub.ADD;
862: RAISE fnd_api.g_exc_error;
863: END;
864: END IF;
926:
927: --DBMS_output.put_line('Validity check passed ');
928: IF (l_keystat_val = FALSE) THEN
929: --DBMS_output.put_line('validate segment failed ');
930: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
931: fnd_msg_pub.ADD;
932: RAISE fnd_api.g_exc_unexpected_error;
933: ELSE
934: x_inventory_location_id := fnd_flex_keyval.combination_id;
968: -- l_loc_type := NULL;
969: -- END IF;
970: ELSE
971: --DBMS_output.put_line('Wms installed check failed ');
972: fnd_message.set_name('WMS', 'WMS_INSTALL_CHK_ERROR');
973: fnd_msg_pub.ADD;
974: RAISE fnd_api.g_exc_unexpected_error;
975: END IF;
976:
992:
993: IF(l_project_reference_enabled = 'Y') THEN
994: IF( l_project_control_level =2 AND l_segment20 IS NULL AND l_segment19 is NOT NULL) THEN
995:
996: fnd_message.set_name('INV', 'INV_TASK_NUM_INVALID');
997: fnd_msg_pub.ADD;
998: RAISE fnd_api.g_exc_error;
999: END IF;
1000: END IF;
1000: END IF;
1001: /*bug14298387,added the validation for logic locator without the physical locator id passed*/
1002: IF(l_project_reference_enabled = 'Y' AND (l_segment19 IS NOT NULL OR l_segment20 IS NOT NULL)) THEN
1003: IF (Nvl(p_physical_location_id,-1) = -1) THEN
1004: fnd_message.set_name('INV', 'INV_PHY_LOCINVALID');
1005: fnd_msg_pub.ADD;
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: --validate the phy locator id
1007: ELSE
1008: --validate the phy locator id
1009: l_phy_loc_concat_segments := INV_PROJECT.GET_LOCSEGS(p_physical_location_id,l_organization_id);
1010: IF (l_phy_loc_concat_segments <> l_physical_concat_seg) THEN
1011: fnd_message.set_name('INV', 'INV_PHY_LOCINVALID');
1012: fnd_msg_pub.ADD;
1013: RAISE fnd_api.g_exc_error;
1014: END IF;
1015: END IF;
1096: );
1097:
1098: IF l_return_status = 'E' THEN
1099: --DBMS_output.put_line('Error from validate_loc_attr_info');
1100: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1101: fnd_msg_pub.ADD;
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF l_return_status = 'U' THEN
1104: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1101: fnd_msg_pub.ADD;
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF l_return_status = 'U' THEN
1104: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1105: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1106: fnd_msg_pub.ADD;
1107: RAISE fnd_api.g_exc_unexpected_error;
1108: END IF;
1109: /* End locator DFF attributes validation */
1177: inv_material_status_pkg.insert_status_history(l_status_rec);
1178: END IF;
1179: END IF; -- (l_keystat_val = FALSE)
1180: ELSE
1181: fnd_message.set_name('INV', 'INV_LOC_BELONG_TO_OTH_SUB');
1182: fnd_msg_pub.ADD;
1183: RAISE fnd_api.g_exc_error;
1184: END IF; -- (l_validility = passed)
1185:
1415: FROM mtl_parameters
1416: WHERE organization_id = l_organization_id;
1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN
1419: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1420: fnd_msg_pub.ADD;
1421: RAISE fnd_api.g_exc_error;
1422: END;
1423:
1424: ELSE -- p_organization_id IS NULL
1425:
1426: IF p_organization_code IS NULL THEN
1427:
1428: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1429: fnd_msg_pub.ADD;
1430: RAISE fnd_api.g_exc_error;
1431:
1432: ELSE -- p_organization_code is NULL
1439: FROM mtl_parameters
1440: WHERE organization_code = p_organization_code;
1441: EXCEPTION
1442: WHEN NO_DATA_FOUND THEN
1443: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1444: fnd_msg_pub.ADD;
1445: RAISE fnd_api.g_exc_error;
1446: END;
1447:
1455: */
1456:
1457: IF (p_concatenated_segments IS NULL AND p_inventory_location_id IS NULL) THEN
1458:
1459: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1460: fnd_msg_pub.ADD;
1461: RAISE fnd_api.g_exc_error;
1462:
1463: ELSIF p_concatenated_segments IS NOT NULL AND p_inventory_location_id IS NULL THEN
1482: , data_set => l_organization_id
1483: );
1484:
1485: IF l_val = FALSE THEN
1486: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1487: fnd_msg_pub.ADD;
1488: RAISE fnd_api.g_exc_error;
1489: ELSE
1490: l_inventory_location_id := fnd_flex_keyval.combination_id;
1505:
1506: IF (p_inventory_location_type <> fnd_api.g_miss_num AND
1507: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1508:
1509: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1510: fnd_msg_pub.ADD;
1511: RAISE fnd_api.g_exc_error;
1512:
1513: END IF;
1525: AND mil.subinventory_code = msi.secondary_inventory_name
1526: AND msi.organization_id = l_organization_id;
1527: EXCEPTION
1528: WHEN NO_DATA_FOUND THEN
1529: fnd_message.set_name('INV', 'INVALID_SUB');
1530: fnd_msg_pub.ADD;
1531: RAISE fnd_api.g_exc_error;
1532: END;
1533:
1535: -- If the sub is of type 'Receiving', then the locator cannot be of type 'Storage'.
1536: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
1537: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR --4911279
1538: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
1539: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1540: fnd_msg_pub.ADD;
1541: RAISE fnd_api.g_exc_error;
1542: END IF;
1543: END IF;
1576: l_alias := p_alias;
1577:
1578: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
1579:
1580: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
1581: fnd_msg_pub.ADD;
1582: RAISE fnd_api.g_exc_error;
1583:
1584: END IF;
1598: WHERE organization_id = p_organization_id
1599: AND alias = l_alias
1600: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1601:
1602: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1603: fnd_message.set_token('LOCATOR', l_locator);
1604: fnd_msg_pub.ADD;
1605: RAISE fnd_api.g_exc_error;
1606:
1599: AND alias = l_alias
1600: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1601:
1602: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1603: fnd_message.set_token('LOCATOR', l_locator);
1604: fnd_msg_pub.ADD;
1605: RAISE fnd_api.g_exc_error;
1606:
1607: EXCEPTION
1621: AND alias = l_alias
1622: AND subinventory_code = l_subinventory_code
1623: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1624:
1625: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1626: fnd_message.set_token('LOCATOR', l_locator);
1627: fnd_msg_pub.ADD;
1628: RAISE fnd_api.g_exc_error;
1629:
1622: AND subinventory_code = l_subinventory_code
1623: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1624:
1625: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1626: fnd_message.set_token('LOCATOR', l_locator);
1627: fnd_msg_pub.ADD;
1628: RAISE fnd_api.g_exc_error;
1629:
1630: EXCEPTION
1650: FROM mtl_units_of_measure
1651: WHERE uom_code = p_location_weight_uom_code;
1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN
1654: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1655: fnd_msg_pub.ADD;
1656: RAISE fnd_api.g_exc_error;
1657: END;
1658: END IF;
1668: FROM mtl_units_of_measure
1669: WHERE uom_code = p_volume_uom_code;
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1673: fnd_msg_pub.ADD;
1674: RAISE fnd_api.g_exc_error;
1675: END;
1676: END IF;
1685: FROM mtl_units_of_measure
1686: WHERE uom_code = p_pick_uom_code;
1687: EXCEPTION
1688: WHEN NO_DATA_FOUND THEN
1689: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');
1690: fnd_msg_pub.ADD;
1691: RAISE fnd_api.g_exc_error;
1692: END;
1693: END IF;
1703: FROM mtl_units_of_measure
1704: WHERE uom_code = p_dimension_uom_code;
1705: EXCEPTION
1706: WHEN NO_DATA_FOUND THEN
1707: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
1708: fnd_msg_pub.ADD;
1709: RAISE fnd_api.g_exc_error;
1710: END;
1711: END IF;
1721: WHERE status_id = p_status_id
1722: AND enabled_flag = 1;
1723: EXCEPTION
1724: WHEN NO_DATA_FOUND THEN
1725: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1726: fnd_msg_pub.ADD;
1727: RAISE fnd_api.g_exc_error;
1728: END;
1729: END IF;
1871: );
1872:
1873: IF l_return_status = 'E' THEN
1874: --DBMS_output.put_line('Error from validate_loc_attr_info');
1875: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1876: fnd_msg_pub.ADD;
1877: RAISE fnd_api.g_exc_error;
1878: ELSIF l_return_status = 'U' THEN
1879: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1876: fnd_msg_pub.ADD;
1877: RAISE fnd_api.g_exc_error;
1878: ELSIF l_return_status = 'U' THEN
1879: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1880: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1881: fnd_msg_pub.ADD;
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: END IF;
1884: /* End locator DFF attributes validation */
1893: l_is_disable_allow := is_disable_allow(p_org_id =>l_organization_id,
1894: p_loc_id=> l_inventory_location_id
1895: );
1896: IF (l_is_disable_allow = false) THEN
1897: fnd_message.set_name('INV','INV_LOCATOR_DISABLE_WARN');
1898: fnd_msg_pub.ADD;
1899: RAISE fnd_api.g_exc_error;
1900: END IF;
1901: END IF;
2076: IF p_organization_id IS NOT NULL THEN
2077: l_organization_id := p_organization_id;
2078: ELSE
2079: IF p_organization_code IS NULL THEN
2080: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2081: /* Organization is required */
2082: fnd_msg_pub.ADD;
2083: RAISE fnd_api.g_exc_error;
2084: ELSE
2088: FROM mtl_parameters
2089: WHERE organization_code = p_organization_code;
2090: EXCEPTION
2091: WHEN NO_DATA_FOUND THEN
2092: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2093: /* The Organization Code provided is invalid */
2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_error;
2096: END;
2101: IF p_inventory_item_id IS NOT NULL THEN
2102: l_inventory_item_id := p_inventory_item_id;
2103: ELSE
2104: IF p_item IS NULL THEN
2105: fnd_message.set_name('INV', 'INV_INT_ITMSEGCODE');
2106: /* Invalid item segments */
2107: fnd_msg_pub.ADD;
2108: RAISE fnd_api.g_exc_error;
2109: ELSE
2114: WHERE concatenated_segments = p_item
2115: AND organization_id = l_organization_id;
2116: EXCEPTION
2117: WHEN NO_DATA_FOUND THEN
2118: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2119: /* The Item provided is invalid */
2120: fnd_msg_pub.ADD;
2121: RAISE fnd_api.g_exc_error;
2122: END;
2124: END IF;
2125:
2126: /*Validate the subinventory code */
2127: IF p_subinventory_code IS NULL THEN
2128: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
2129: /* Please enter a subinventory before proceeding */
2130: fnd_msg_pub.ADD;
2131: RAISE fnd_api.g_exc_error;
2132: ELSE
2137: WHERE secondary_inventory_name = p_subinventory_code
2138: AND organization_id = l_organization_id;
2139: EXCEPTION
2140: WHEN NO_DATA_FOUND THEN
2141: fnd_message.set_name('INV', 'INVALID_SUB');
2142: /* The subinventory provided is invalid */
2143: fnd_msg_pub.ADD;
2144: RAISE fnd_api.g_exc_error;
2145: END;
2149: IF p_inventory_location_id IS NOT NULL THEN
2150: l_locator_id := p_inventory_location_id;
2151: ELSE
2152: IF p_locator IS NULL THEN
2153: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2154: /* Invalid locator segments */
2155: fnd_msg_pub.ADD;
2156: RAISE fnd_api.g_exc_error;
2157: ELSE
2162: WHERE concatenated_segments = p_locator
2163: AND organization_id = l_organization_id;
2164: EXCEPTION
2165: WHEN NO_DATA_FOUND THEN
2166: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2167: /* The Locator provided is invalid */
2168: fnd_msg_pub.ADD;
2169: RAISE fnd_api.g_exc_error;
2170: END;
2180: AND subinventory_code = p_subinventory_code
2181: AND organization_id = l_organization_id;
2182: EXCEPTION
2183: WHEN NO_DATA_FOUND THEN
2184: fnd_message.set_name('INV', 'INV_INT_LOCSEGEXP');
2185: /* The Locator segments are invalid for the given subinventory, organization combination */
2186: RAISE fnd_api.g_exc_error;
2187: END;
2188:
2207: WHERE status_id = p_status_id
2208: AND enabled_flag = 1;
2209: EXCEPTION
2210: WHEN NO_DATA_FOUND THEN
2211: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
2212: /* Invalid status ID. */
2213: fnd_msg_pub.ADD;
2214: RAISE fnd_api.g_exc_error;
2215: END;
2301: , p_status_id
2302: );
2303: END IF;
2304: ELSE
2305: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2306: /* Locator selected has already been assigned to this item and subinventory */
2307: fnd_msg_pub.ADD;
2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2309: END IF;
2398:
2399: l_organization_id := p_organization_id;
2400: ELSE
2401: IF p_organization_code IS NULL THEN
2402: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2403: /* Organisation is required */
2404: fnd_msg_pub.ADD;
2405: RAISE fnd_api.g_exc_error;
2406: ELSE
2444: END IF;
2445:
2446: IF l_val = FALSE
2447: OR p_concatenated_segments IS NULL THEN
2448: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2449: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2450: /* LOCATOR does not exist */
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_error;
2445:
2446: IF l_val = FALSE
2447: OR p_concatenated_segments IS NULL THEN
2448: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2449: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2450: /* LOCATOR does not exist */
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_error;
2453: ELSE
2472: WHERE physical_location_id = l_inventory_location_id
2473: AND organization_id = l_organization_id
2474: AND inventory_location_id <> physical_location_id); --Bug :5036570
2475:
2476: fnd_message.set_name('INV', 'INV_LOC_PHY');
2477: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2478: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2479: fnd_msg_pub.ADD;
2480: RAISE fnd_api.g_exc_error;
2473: AND organization_id = l_organization_id
2474: AND inventory_location_id <> physical_location_id); --Bug :5036570
2475:
2476: fnd_message.set_name('INV', 'INV_LOC_PHY');
2477: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2478: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2479: fnd_msg_pub.ADD;
2480: RAISE fnd_api.g_exc_error;
2481: EXCEPTION
2497: WHERE inventory_location_id = l_inventory_location_id
2498: AND organization_id = l_organization_id
2499: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
2500:
2501: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2502: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2503: /*Locator locator cannot be deleted as it is active */
2504: fnd_msg_pub.ADD;
2505: RAISE fnd_api.g_exc_error;
2498: AND organization_id = l_organization_id
2499: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
2500:
2501: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2502: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2503: /*Locator locator cannot be deleted as it is active */
2504: fnd_msg_pub.ADD;
2505: RAISE fnd_api.g_exc_error;
2506: EXCEPTION
2523: FROM mtl_onhand_quantities_detail
2524: WHERE locator_id = l_inventory_location_id
2525: AND organization_id = l_organization_id);
2526:
2527: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2528: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2529: /*Locator locator cannot be deleted as items exist in it*/
2530: fnd_msg_pub.ADD;
2531: RAISE fnd_api.g_exc_error;
2524: WHERE locator_id = l_inventory_location_id
2525: AND organization_id = l_organization_id);
2526:
2527: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2528: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2529: /*Locator locator cannot be deleted as items exist in it*/
2530: fnd_msg_pub.ADD;
2531: RAISE fnd_api.g_exc_error;
2532: EXCEPTION
2545: FROM mtl_reservations
2546: WHERE locator_id = l_inventory_location_id
2547: AND organization_id = l_organization_id);
2548:
2549: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2550: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2551: /*The locator locator cannot be deleted as reservations exist against it*/
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2546: WHERE locator_id = l_inventory_location_id
2547: AND organization_id = l_organization_id);
2548:
2549: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2550: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2551: /*The locator locator cannot be deleted as reservations exist against it*/
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: EXCEPTION
2566: FROM wms_license_plate_numbers
2567: WHERE locator_id = l_inventory_location_id
2568: AND organization_id = l_organization_id);
2569:
2570: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2571: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2572: /*Locator locator cannot be deleted as LPNs reside in it*/
2573: fnd_msg_pub.ADD;
2574: RAISE fnd_api.g_exc_error;
2567: WHERE locator_id = l_inventory_location_id
2568: AND organization_id = l_organization_id);
2569:
2570: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2571: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2572: /*Locator locator cannot be deleted as LPNs reside in it*/
2573: fnd_msg_pub.ADD;
2574: RAISE fnd_api.g_exc_error;
2575: EXCEPTION
2587: FROM mtl_secondary_locators
2588: WHERE secondary_locator = l_inventory_location_id
2589: AND organization_id = l_organization_id);
2590:
2591: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2592: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2593: /*Locator locator cannot be deleted as it is tied to an item */
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2588: WHERE secondary_locator = l_inventory_location_id
2589: AND organization_id = l_organization_id);
2590:
2591: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2592: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2593: /*Locator locator cannot be deleted as it is tied to an item */
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2596: EXCEPTION
2608: FROM mtl_transactions_interface
2609: WHERE locator_id = l_inventory_location_id
2610: AND organization_id = l_organization_id);
2611:
2612: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2613: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2614: /*Locator locator cannot be deleted as there are pending transactions against it*/
2615: fnd_msg_pub.ADD;
2616: RAISE fnd_api.g_exc_error;
2609: WHERE locator_id = l_inventory_location_id
2610: AND organization_id = l_organization_id);
2611:
2612: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2613: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2614: /*Locator locator cannot be deleted as there are pending transactions against it*/
2615: fnd_msg_pub.ADD;
2616: RAISE fnd_api.g_exc_error;
2617: EXCEPTION
2635: AND organization_id = l_organization_id)
2636: OR(transfer_to_location = l_inventory_location_id
2637: AND NVL(transfer_organization, organization_id) = l_organization_id));
2638:
2639: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2640: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2641: /*Locator locator cannot be deleted as there are pending transactions against it*/
2642: fnd_msg_pub.ADD;
2643: RAISE fnd_api.g_exc_error;
2636: OR(transfer_to_location = l_inventory_location_id
2637: AND NVL(transfer_organization, organization_id) = l_organization_id));
2638:
2639: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2640: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2641: /*Locator locator cannot be deleted as there are pending transactions against it*/
2642: fnd_msg_pub.ADD;
2643: RAISE fnd_api.g_exc_error;
2644: EXCEPTION
2656: FROM rcv_transactions_interface
2657: WHERE locator_id = l_inventory_location_id
2658: AND to_organization_id = l_organization_id);
2659:
2660: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2661: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2662: /*Locator locator cannot be deleted as there are pending transactions against it*/
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2657: WHERE locator_id = l_inventory_location_id
2658: AND to_organization_id = l_organization_id);
2659:
2660: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2661: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2662: /*Locator locator cannot be deleted as there are pending transactions against it*/
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: EXCEPTION