[Home] [Help]
437: BEGIN
438: IF (l_debug = 1) THEN
439: mdebug('Inserting row with SL NO '||l_serial_number);
440: END IF;
441: INSERT INTO MTL_SERIAL_NUMBERS
442: (INVENTORY_ITEM_ID,
443: SERIAL_NUMBER,
444: LAST_UPDATE_DATE,
445: LAST_UPDATED_BY,
589: |
590: | A serial number may be assigned to at most one
591: | unit of each item across all organizations. This
592: | translates into at most one record in
593: | MTL_SERIAL_NUMBERS for each combination of
594: | SERIAL_NUMBER and INVENTORY_ITEM_ID.
595: |
596: | o 2 Unique serial numbers within organization.
597: | No duplicate serial numbers within any particular
601: | of one item in each organization, with the caveat
602: | that the same serial number may not be assigned to
603: | the same item in two different organizations. This
604: | translates into at most one record in
605: | MTL_SERIAL_NUMBERS for each combination of
606: | SERIAL_NUMBER and INVENTORY_ITEM_ID with the
607: | overriding condition that there be at most one
608: | record for any given combination of SERIAL_NUMBER
609: | and ORGANIZATION_ID.
613: |
614: | A serial number may be assigned to at most one unit
615: | of one item across all organizations. This
616: | translates into at most one record in
617: | MTL_SERIAL_NUMBERS for each value of SERIAL_NUMBER.
618: +-------------------------------------------------------------*/
619: PROCEDURE SNUniqueCheck
620: (
621: p_api_version IN NUMBER,
663: IF P_serial_number_type = 2 then
664: BEGIN
665: SELECT 'X'
666: INTO L_nothing
667: FROM MTL_SERIAL_NUMBERS
668: WHERE SERIAL_NUMBER = P_serial_number
669: AND CURRENT_ORGANIZATION_ID + 0 = P_org_id;
670: --
671: if L_nothing is not NULL then
689:
690: BEGIN
691: SELECT 'x'
692: INTO L_nothing
693: FROM MTL_SERIAL_NUMBERS S,
694: MTL_PARAMETERS P
695: WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
696: AND S.SERIAL_NUMBER = P_serial_number
697: AND P.SERIAL_NUMBER_TYPE = 3;
718: ELSIF P_serial_number_type = 3 then
719: BEGIN
720: SELECT 'x'
721: INTO L_nothing
722: FROM MTL_SERIAL_NUMBERS
723: WHERE SERIAL_NUMBER = P_serial_number;
724: if L_nothing is not NULL then
725: FND_MESSAGE.set_name('INV','INV_INLTIS_SER1');
726: FND_MESSAGE.SET_TOKEN('TOKEN1',P_serial_number);
985: L_current_subinventory,
986: L_current_locator_id,
987: L_current_organization_id,
988: L_wip_entity_id
989: FROM MTL_SERIAL_NUMBERS
990: WHERE inventory_item_id = P_Item_id
991: AND serial_number = P_serial_number;
992: IF (l_debug = 1) THEN
993: mdebug ('SNValidate : After SQL ');