[Home] [Help]
1763:
1764: if nvl(p_serial_control_code,1) <> 1 then
1765: BEGIN
1766: l_progress := 'WMSINB-11324';
1767: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
1768: INTO l_total_ser_qty
1769: FROM mtl_serial_numbers_temp
1770: WHERE product_code = p_product_code
1771: AND product_transaction_id = p_product_txn_id;
1792: Loop
1793: l_progress := 'WMSINB-11351';
1794: For l_serial_rec in ( select fm_serial_number
1795: , to_serial_number
1796: , inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1797: from mtl_serial_numbers_temp msnt
1798: where msnt.transaction_temp_id = l_lot_rec.serial_transaction_temp_id
1799: and msnt.product_transaction_id = p_product_txn_id
1800: and msnt.product_code = 'RCV'
1911:
1912: l_progress := 'WMSINB-11453';
1913: For l_serial_rec in ( select fm_serial_number
1914: ,to_serial_number
1915: ,inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1916: from mtl_serial_numbers_temp msnt
1917: where msnt.product_transaction_id = p_product_txn_id
1918: and msnt.product_code = 'RCV'
1919: )
2696: END IF;
2697:
2698: l_progress := 'WMSINB-12090';
2699: l_serial_qty :=
2700: inv_serial_number_pub.get_serial_diff
2701: (p_fm_serial => l_msni_rec.fm_serial_number
2702: ,p_to_serial=> l_msni_rec.to_serial_number
2703: );
2704: l_progress := 'WMSINB-12096';
8804: AND product_transaction_id = l_rti_rec.interface_transaction_id;
8805:
8806: -- GET the TOTAL SERIAL QTY
8807: l_progress := 'WMSINB-14439';
8808: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
8809: INTO l_total_serial_qty
8810: FROM mtl_serial_numbers_temp
8811: WHERE product_code = 'RCV'
8812: AND product_transaction_id = l_rti_rec.interface_transaction_id;
17256: print_debug('SPLIT_LOT_SERIAL:l_total_lot_qty:'||l_total_lot_qty,1);
17257: END IF;
17258:
17259: BEGIN
17260: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
17261: INTO l_total_serial_qty
17262: FROM mtl_serial_numbers_interface
17263: WHERE product_code = 'RCV'
17264: AND product_transaction_id = l_orig_interface_trx_id;
17362: OR nvl(mtli.primary_quantity,
17363: get_primary_qty(l_to_organization_id,l_item_id,l_uom_code,
17364: mtli.transaction_quantity)
17365: )
17366: = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
17367: msni.to_serial_number))
17368: FROM mtl_serial_numbers_interface msni
17369: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
17370: EXCEPTION
17477: print_debug('SPLIT_LOT_SERIAL:l_total_lot_qty:'||l_total_lot_qty,1);
17478: END IF;
17479:
17480: BEGIN
17481: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
17482: INTO l_total_serial_qty
17483: FROM mtl_serial_numbers_interface
17484: WHERE product_code = 'RCV'
17485: AND product_transaction_id = l_orig_interface_trx_id;
17534: AND (mtli.serial_transaction_temp_id IS NULL
17535: OR nvl(mtli.primary_quantity,
17536: get_primary_qty(l_to_organization_id,l_item_id,l_uom_code,
17537: mtli.transaction_quantity)
17538: ) = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
17539: msni.to_serial_number))
17540: FROM mtl_serial_numbers_interface msni
17541: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id))
17542: AND (p_rti_tb(newrti).lot_number IS NULL OR (p_rti_tb(newrti).lot_number IS NOT NULL AND lot_number=p_rti_tb(newrti).lot_number)); -- for 13972742
17822: FETCH msni_recs_lotserial INTO l_msni_rec;
17823: EXIT WHEN msni_recs_lotserial%notfound;
17824:
17825: l_serial_quantity :=
17826: inv_serial_number_pub.get_serial_diff(l_msni_rec.fm_serial_number,
17827: l_msni_rec.to_serial_number);
17828:
17829: IF (l_debug = 1) THEN
17830: print_debug('split_lot_serial:200: serial quantity '||l_serial_quantity, 1);
17976: print_debug('split_lot_serial:236: remaining quantity '||l_remaining_quantity, 1);
17977: END If;
17978:
17979: l_serial_quantity :=
17980: inv_serial_number_pub.get_serial_diff(l_msni_rec.fm_serial_number,l_msni_rec.to_serial_number);
17981:
17982: IF (l_debug = 1) THEN
17983: print_debug('split_lot_serial:237: serial quantity '||l_serial_quantity, 1);
17984: END If;
19391: from rcv_transactions
19392: where transaction_id=l_parent_transaction_id;
19393:
19394: if( l_parent_transaction_type='DELIVER') THEN
19395: inv_serial_number_pub.is_serial_controlled(
19396: p_inventory_item_id => l_item_id,
19397: p_organization_id => l_org_id,
19398: p_transfer_org_id => NULL,
19399: p_txn_type_id => 36,
20366: RAISE fnd_api.g_exc_error;
20367: END IF;
20368:
20369: L_SERIAL_QUANTITY :=
20370: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
20371: L_MSNT_REC.TO_SERIAL_NUMBER);
20372:
20373: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
20374: l_serial_quantity;
20964: END IF;
20965:
20966: IF (Nvl(l_curr_status, 1) IN (1,6)) THEN
20967: --validate and update the attributes.
20968: inv_serial_number_pub.validate_update_serial_att
20969: (x_return_status => x_return_status,
20970: x_msg_count => x_msg_count,
20971: x_msg_data => x_msg_data,
20972: x_validation_status => l_validation_status,
21020: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
21021: --(INCLUDING ATT VALIDATION)
21022: --CREATE MSN
21023:
21024: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
21025: , p_inventory_item_id => l_item_id
21026: , p_organization_id => l_org_id
21027: , p_from_serial_number => l_serial_number
21028: , p_to_serial_number => l_serial_number
21063: RAISE fnd_api.g_exc_error;
21064: END IF;
21065:
21066: --validate and update the attributes.
21067: inv_serial_number_pub.validate_update_serial_att
21068: (x_return_status => x_return_status,
21069: x_msg_count => x_msg_count,
21070: x_msg_data => x_msg_data,
21071: x_validation_status => l_validation_status,
21173: END IF;
21174:
21175: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
21176: --validate and update the attributes.
21177: inv_serial_number_pub.validate_update_serial_att
21178: (x_return_status => x_return_status,
21179: x_msg_count => x_msg_count,
21180: x_msg_data => x_msg_data,
21181: x_validation_status => l_validation_status,
21208: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
21209: --(INCLUDING ATT VALIDATION)
21210: --CREATE MSN
21211:
21212: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
21213: , p_inventory_item_id => l_item_id
21214: , p_organization_id => l_org_id
21215: , p_from_serial_number => l_serial_number
21216: , p_to_serial_number => l_serial_number
21252: RAISE fnd_api.g_exc_error;
21253: END IF;
21254:
21255: --validate and update the attributes.
21256: inv_serial_number_pub.validate_update_serial_att
21257: (x_return_status => x_return_status,
21258: x_msg_count => x_msg_count,
21259: x_msg_data => x_msg_data,
21260: x_validation_status => l_validation_status,
21462: RAISE fnd_api.g_exc_error;
21463: END IF;
21464:
21465: L_SERIAL_QUANTITY :=
21466: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
21467: L_MSNT_REC.TO_SERIAL_NUMBER);
21468:
21469: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
21470: l_serial_quantity;
22074: END IF;
22075:
22076: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
22077: --validate and update the attributes.
22078: inv_serial_number_pub.validate_update_serial_att
22079: (x_return_status => x_return_status,
22080: x_msg_count => x_msg_count,
22081: x_msg_data => x_msg_data,
22082: x_validation_status => l_validation_status,
22130: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
22131: --(INCLUDING ATT VALIDATION)
22132: --CREATE MSN
22133:
22134: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
22135: , p_inventory_item_id => l_item_id
22136: , p_organization_id => l_org_id
22137: , p_from_serial_number => l_serial_number
22138: , p_to_serial_number => l_serial_number
22173: RAISE fnd_api.g_exc_error;
22174: END IF;
22175:
22176: --validate and update the attributes.
22177: inv_serial_number_pub.validate_update_serial_att
22178: (x_return_status => x_return_status,
22179: x_msg_count => x_msg_count,
22180: x_msg_data => x_msg_data,
22181: x_validation_status => l_validation_status,
22282: END IF;
22283:
22284: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
22285: --validate and update the attributes.
22286: inv_serial_number_pub.validate_update_serial_att
22287: (x_return_status => x_return_status,
22288: x_msg_count => x_msg_count,
22289: x_msg_data => x_msg_data,
22290: x_validation_status => l_validation_status,
22317: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
22318: --(INCLUDING ATT VALIDATION)
22319: --CREATE MSN
22320:
22321: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
22322: , p_inventory_item_id => l_item_id
22323: , p_organization_id => l_org_id
22324: , p_from_serial_number => l_serial_number
22325: , p_to_serial_number => l_serial_number
22360: RAISE fnd_api.g_exc_error;
22361: END IF;
22362:
22363: --validate and update the attributes.
22364: inv_serial_number_pub.validate_update_serial_att
22365: (x_return_status => x_return_status,
22366: x_msg_count => x_msg_count,
22367: x_msg_data => x_msg_data,
22368: x_validation_status => l_validation_status,
23094:
23095: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
23096:
23097: L_SERIAL_QUANTITY :=
23098: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
23099: L_MSNT_REC.TO_SERIAL_NUMBER);
23100:
23101: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
23102:
23337: END IF;
23338:
23339: IF (Nvl(l_curr_status, 1) IN (1,6)) THEN
23340: --validate and update the attributes.
23341: inv_serial_number_pub.validate_update_serial_att
23342: (x_return_status => x_return_status,
23343: x_msg_count => x_msg_count,
23344: x_msg_data => x_msg_data,
23345: x_validation_status => l_validation_status,
23373: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
23374: --(INCLUDING ATT VALIDATION)
23375: --CREATE MSN
23376:
23377: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
23378: , p_inventory_item_id => l_item_id
23379: , p_organization_id => l_org_id
23380: , p_from_serial_number => l_serial_number
23381: , p_to_serial_number => l_serial_number
23416: RAISE fnd_api.g_exc_error;
23417: END IF;
23418:
23419: --validate and update the attributes.
23420: inv_serial_number_pub.validate_update_serial_att
23421: (x_return_status => x_return_status,
23422: x_msg_count => x_msg_count,
23423: x_msg_data => x_msg_data,
23424: x_validation_status => l_validation_status,
23548:
23549: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
23550:
23551: L_SERIAL_QUANTITY :=
23552: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
23553: L_MSNT_REC.TO_SERIAL_NUMBER);
23554:
23555: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
23556:
23788: END IF;
23789:
23790: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
23791: --validate and update the attributes.
23792: inv_serial_number_pub.validate_update_serial_att
23793: (x_return_status => x_return_status,
23794: x_msg_count => x_msg_count,
23795: x_msg_data => x_msg_data,
23796: x_validation_status => l_validation_status,
23824: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
23825: --(INCLUDING ATT VALIDATION)
23826: --CREATE MSN
23827:
23828: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
23829: , p_inventory_item_id => l_item_id
23830: , p_organization_id => l_org_id
23831: , p_from_serial_number => l_serial_number
23832: , p_to_serial_number => l_serial_number
23867: RAISE fnd_api.g_exc_error;
23868: END IF;
23869:
23870: --validate and update the attributes.
23871: inv_serial_number_pub.validate_update_serial_att
23872: (x_return_status => x_return_status,
23873: x_msg_count => x_msg_count,
23874: x_msg_data => x_msg_data,
23875: x_validation_status => l_validation_status,
25110: FETCH C_MSNT_LOTSERIAL INTO L_MSNT_REC;
25111: EXIT WHEN C_MSNT_LOTSERIAL%NOTFOUND;
25112:
25113: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
25114: L_SERIAL_QUANTITY := INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
25115: L_MSNT_REC.TO_SERIAL_NUMBER);
25116:
25117: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25118:
25342: END IF;
25343:
25344: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
25345: --validate and update the attributes.
25346: inv_serial_number_pub.validate_update_serial_att
25347: (x_return_status => x_return_status,
25348: x_msg_count => x_msg_count,
25349: x_msg_data => x_msg_data,
25350: x_validation_status => l_validation_status,
25383: ELSE
25384: l_transaction_action_id := 1;
25385: END IF;
25386:
25387: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
25388: , p_inventory_item_id => l_item_id
25389: , p_organization_id => l_org_id
25390: , p_from_serial_number => l_serial_number
25391: , p_to_serial_number => l_serial_number
25426: RAISE fnd_api.g_exc_error;
25427: END IF;
25428:
25429: --validate and update the attributes.
25430: inv_serial_number_pub.validate_update_serial_att
25431: (x_return_status => x_return_status,
25432: x_msg_count => x_msg_count,
25433: x_msg_data => x_msg_data,
25434: x_validation_status => l_validation_status,
25542: END IF;
25543:
25544: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
25545: --validate and update the attributes.
25546: inv_serial_number_pub.validate_update_serial_att
25547: (x_return_status => x_return_status,
25548: x_msg_count => x_msg_count,
25549: x_msg_data => x_msg_data,
25550: x_validation_status => l_validation_status,
25583: ELSE
25584: l_transaction_action_id := 1;
25585: END IF;
25586:
25587: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
25588: , p_inventory_item_id => l_item_id
25589: , p_organization_id => l_org_id
25590: , p_from_serial_number => l_serial_number
25591: , p_to_serial_number => l_serial_number
25626: RAISE fnd_api.g_exc_error;
25627: END IF;
25628:
25629: --validate and update the attributes.
25630: inv_serial_number_pub.validate_update_serial_att
25631: (x_return_status => x_return_status,
25632: x_msg_count => x_msg_count,
25633: x_msg_data => x_msg_data,
25634: x_validation_status => l_validation_status,
25763: END IF;
25764:
25765: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
25766: --validate and update the attributes.
25767: inv_serial_number_pub.validate_update_serial_att
25768: (x_return_status => x_return_status,
25769: x_msg_count => x_msg_count,
25770: x_msg_data => x_msg_data,
25771: x_validation_status => l_validation_status,
25888: FETCH C_MSNT INTO L_MSNT_REC;
25889: EXIT WHEN C_MSNT%NOTFOUND;
25890:
25891: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
25892: L_SERIAL_QUANTITY := INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
25893: L_MSNT_REC.TO_SERIAL_NUMBER);
25894: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25895:
25896: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
26119: END IF;
26120:
26121: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
26122: --validate and update the attributes.
26123: inv_serial_number_pub.validate_update_serial_att
26124: (x_return_status => x_return_status,
26125: x_msg_count => x_msg_count,
26126: x_msg_data => x_msg_data,
26127: x_validation_status => l_validation_status,
26160: ELSE
26161: l_transaction_action_id := 1;
26162: END IF;
26163:
26164: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
26165: , p_inventory_item_id => l_item_id
26166: , p_organization_id => l_org_id
26167: , p_from_serial_number => l_serial_number
26168: , p_to_serial_number => l_serial_number
26203: RAISE fnd_api.g_exc_error;
26204: END IF;
26205:
26206: --validate and update the attributes.
26207: inv_serial_number_pub.validate_update_serial_att
26208: (x_return_status => x_return_status,
26209: x_msg_count => x_msg_count,
26210: x_msg_data => x_msg_data,
26211: x_validation_status => l_validation_status,
26317: END IF;
26318:
26319: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
26320: --validate and update the attributes.
26321: inv_serial_number_pub.validate_update_serial_att
26322: (x_return_status => x_return_status,
26323: x_msg_count => x_msg_count,
26324: x_msg_data => x_msg_data,
26325: x_validation_status => l_validation_status,
26358: ELSE
26359: l_transaction_action_id := 1;
26360: END IF;
26361:
26362: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
26363: , p_inventory_item_id => l_item_id
26364: , p_organization_id => l_org_id
26365: , p_from_serial_number => l_serial_number
26366: , p_to_serial_number => l_serial_number
26401: RAISE fnd_api.g_exc_error;
26402: END IF;
26403:
26404: --validate and update the attributes.
26405: inv_serial_number_pub.validate_update_serial_att
26406: (x_return_status => x_return_status,
26407: x_msg_count => x_msg_count,
26408: x_msg_data => x_msg_data,
26409: x_validation_status => l_validation_status,
26535: END IF;
26536:
26537: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
26538: --validate and update the attributes.
26539: inv_serial_number_pub.validate_update_serial_att
26540: (x_return_status => x_return_status,
26541: x_msg_count => x_msg_count,
26542: x_msg_data => x_msg_data,
26543: x_validation_status => l_validation_status,
27329: FETCH C_MSNT_LOTSERIAL INTO L_MSNT_REC;
27330: EXIT WHEN C_MSNT_LOTSERIAL%NOTFOUND;
27331:
27332: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
27333: L_SERIAL_QUANTITY := INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
27334: L_MSNT_REC.TO_SERIAL_NUMBER);
27335: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
27336: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
27337: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
27581: END IF;
27582:
27583: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27584: --validate and update the attributes.
27585: inv_serial_number_pub.validate_update_serial_att
27586: (x_return_status => x_return_status,
27587: x_msg_count => x_msg_count,
27588: x_msg_data => x_msg_data,
27589: x_validation_status => l_validation_status,
27698: END IF;
27699:
27700: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27701: --validate and update the attributes.
27702: inv_serial_number_pub.validate_update_serial_att
27703: (x_return_status => x_return_status,
27704: x_msg_count => x_msg_count,
27705: x_msg_data => x_msg_data,
27706: x_validation_status => l_validation_status,
27739: ELSE
27740: l_transaction_action_id := 1;
27741: END IF;
27742:
27743: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
27744: , p_inventory_item_id => l_item_id
27745: , p_organization_id => l_org_id
27746: , p_from_serial_number => l_serial_number
27747: , p_to_serial_number => l_serial_number
27782: RAISE fnd_api.g_exc_error;
27783: END IF;
27784:
27785: --validate and update the attributes.
27786: inv_serial_number_pub.validate_update_serial_att
27787: (x_return_status => x_return_status,
27788: x_msg_count => x_msg_count,
27789: x_msg_data => x_msg_data,
27790: x_validation_status => l_validation_status,
27917: END IF;
27918:
27919: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27920: --validate and update the attributes.
27921: inv_serial_number_pub.validate_update_serial_att
27922: (x_return_status => x_return_status,
27923: x_msg_count => x_msg_count,
27924: x_msg_data => x_msg_data,
27925: x_validation_status => l_validation_status,
27984: END IF;
27985:
27986: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27987: --validate and update the attributes.
27988: inv_serial_number_pub.validate_update_serial_att
27989: (x_return_status => x_return_status,
27990: x_msg_count => x_msg_count,
27991: x_msg_data => x_msg_data,
27992: x_validation_status => l_validation_status,
28048: ELSE
28049: l_transaction_action_id := 1;
28050: END IF;
28051:
28052: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
28053: , p_inventory_item_id => l_item_id
28054: , p_organization_id => l_org_id
28055: , p_from_serial_number => l_serial_number
28056: , p_to_serial_number => l_serial_number
28091: RAISE fnd_api.g_exc_error;
28092: END IF;
28093:
28094: --validate and update the attributes.
28095: inv_serial_number_pub.validate_update_serial_att
28096: (x_return_status => x_return_status,
28097: x_msg_count => x_msg_count,
28098: x_msg_data => x_msg_data,
28099: x_validation_status => l_validation_status,
28235: EXIT WHEN C_MSNT%NOTFOUND;
28236:
28237: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
28238: L_SERIAL_QUANTITY :=
28239: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
28240: L_MSNT_REC.TO_SERIAL_NUMBER);
28241:
28242: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
28243: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
28517: END IF;
28518:
28519: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
28520: --validate and update the attributes.
28521: inv_serial_number_pub.validate_update_serial_att
28522: (x_return_status => x_return_status,
28523: x_msg_count => x_msg_count,
28524: x_msg_data => x_msg_data,
28525: x_validation_status => l_validation_status,
28629: END IF;
28630:
28631: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
28632: --validate and update the attributes.
28633: inv_serial_number_pub.validate_update_serial_att
28634: (x_return_status => x_return_status,
28635: x_msg_count => x_msg_count,
28636: x_msg_data => x_msg_data,
28637: x_validation_status => l_validation_status,
28670: ELSE
28671: l_transaction_action_id := 1;
28672: END IF;
28673:
28674: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
28675: , p_inventory_item_id => l_item_id
28676: , p_organization_id => l_org_id
28677: , p_from_serial_number => l_serial_number
28678: , p_to_serial_number => l_serial_number
28713: RAISE fnd_api.g_exc_error;
28714: END IF;
28715:
28716: --validate and update the attributes.
28717: inv_serial_number_pub.validate_update_serial_att
28718: (x_return_status => x_return_status,
28719: x_msg_count => x_msg_count,
28720: x_msg_data => x_msg_data,
28721: x_validation_status => l_validation_status,
28844: END IF;
28845:
28846: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
28847: --validate and update the attributes.
28848: inv_serial_number_pub.validate_update_serial_att
28849: (x_return_status => x_return_status,
28850: x_msg_count => x_msg_count,
28851: x_msg_data => x_msg_data,
28852: x_validation_status => l_validation_status,
28910: END IF;
28911:
28912: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
28913: --validate and update the attributes.
28914: inv_serial_number_pub.validate_update_serial_att
28915: (x_return_status => x_return_status,
28916: x_msg_count => x_msg_count,
28917: x_msg_data => x_msg_data,
28918: x_validation_status => l_validation_status,
28975: ELSE
28976: l_transaction_action_id := 1;
28977: END IF;
28978:
28979: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
28980: , p_inventory_item_id => l_item_id
28981: , p_organization_id => l_org_id
28982: , p_from_serial_number => l_serial_number
28983: , p_to_serial_number => l_serial_number
29018: RAISE fnd_api.g_exc_error;
29019: END IF;
29020:
29021: --validate and update the attributes.
29022: inv_serial_number_pub.validate_update_serial_att
29023: (x_return_status => x_return_status,
29024: x_msg_count => x_msg_count,
29025: x_msg_data => x_msg_data,
29026: x_validation_status => l_validation_status,