eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_PVT dependencies on INV_SERIAL_NUMBER_PUB

Line 1741: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)

1737:
1738: if nvl(p_serial_control_code,1) <> 1 then
1739: BEGIN
1740: l_progress := 'WMSINB-11324';
1741: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
1742: INTO l_total_ser_qty
1743: FROM mtl_serial_numbers_temp
1744: WHERE product_code = p_product_code
1745: AND product_transaction_id = p_product_txn_id;

Line 1770: , inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity

1766: Loop
1767: l_progress := 'WMSINB-11351';
1768: For l_serial_rec in ( select fm_serial_number
1769: , to_serial_number
1770: , inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1771: from mtl_serial_numbers_temp msnt
1772: where msnt.transaction_temp_id = l_lot_rec.serial_transaction_temp_id
1773: and msnt.product_transaction_id = p_product_txn_id
1774: and msnt.product_code = 'RCV'

Line 1887: ,inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity

1883:
1884: l_progress := 'WMSINB-11453';
1885: For l_serial_rec in ( select fm_serial_number
1886: ,to_serial_number
1887: ,inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1888: from mtl_serial_numbers_temp msnt
1889: where msnt.product_transaction_id = p_product_txn_id
1890: and msnt.product_code = 'RCV'
1891: )

Line 2671: inv_serial_number_pub.get_serial_diff

2667: END IF;
2668:
2669: l_progress := 'WMSINB-12090';
2670: l_serial_qty :=
2671: inv_serial_number_pub.get_serial_diff
2672: (p_fm_serial => l_msni_rec.fm_serial_number
2673: ,p_to_serial=> l_msni_rec.to_serial_number
2674: );
2675: l_progress := 'WMSINB-12096';

Line 8424: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)

8420: AND product_transaction_id = l_rti_rec.interface_transaction_id;
8421:
8422: -- GET the TOTAL SERIAL QTY
8423: l_progress := 'WMSINB-14439';
8424: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
8425: INTO l_total_serial_qty
8426: FROM mtl_serial_numbers_temp
8427: WHERE product_code = 'RCV'
8428: AND product_transaction_id = l_rti_rec.interface_transaction_id;

Line 16475: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))

16471: print_debug('SPLIT_LOT_SERIAL:l_total_lot_qty:'||l_total_lot_qty,1);
16472: END IF;
16473:
16474: BEGIN
16475: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
16476: INTO l_total_serial_qty
16477: FROM mtl_serial_numbers_interface
16478: WHERE product_code = 'RCV'
16479: AND product_transaction_id = l_orig_interface_trx_id;

Line 16581: = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,

16577: OR nvl(mtli.primary_quantity,
16578: get_primary_qty(l_to_organization_id,l_item_id,l_uom_code,
16579: mtli.transaction_quantity)
16580: )
16581: = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
16582: msni.to_serial_number))
16583: FROM mtl_serial_numbers_interface msni
16584: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
16585: EXCEPTION

Line 16695: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))

16691: print_debug('SPLIT_LOT_SERIAL:l_total_lot_qty:'||l_total_lot_qty,1);
16692: END IF;
16693:
16694: BEGIN
16695: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
16696: INTO l_total_serial_qty
16697: FROM mtl_serial_numbers_interface
16698: WHERE product_code = 'RCV'
16699: AND product_transaction_id = l_orig_interface_trx_id;

Line 16752: ) = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,

16748: AND (mtli.serial_transaction_temp_id IS NULL
16749: OR nvl(mtli.primary_quantity,
16750: get_primary_qty(l_to_organization_id,l_item_id,l_uom_code,
16751: mtli.transaction_quantity)
16752: ) = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
16753: msni.to_serial_number))
16754: FROM mtl_serial_numbers_interface msni
16755: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
16756: EXCEPTION

Line 16968: inv_serial_number_pub.get_serial_diff(l_msni_rec.fm_serial_number,

16964: FETCH msni_recs_lotserial INTO l_msni_rec;
16965: EXIT WHEN msni_recs_lotserial%notfound;
16966:
16967: l_serial_quantity :=
16968: inv_serial_number_pub.get_serial_diff(l_msni_rec.fm_serial_number,
16969: l_msni_rec.to_serial_number);
16970:
16971: IF (l_debug = 1) THEN
16972: print_debug('split_lot_serial:200: serial quantity '||l_serial_quantity, 1);

Line 17073: inv_serial_number_pub.get_serial_diff(l_msni_rec.fm_serial_number,l_msni_rec.to_serial_number);

17069: print_debug('split_lot_serial:236: remaining quantity '||l_remaining_quantity, 1);
17070: END If;
17071:
17072: l_serial_quantity :=
17073: inv_serial_number_pub.get_serial_diff(l_msni_rec.fm_serial_number,l_msni_rec.to_serial_number);
17074:
17075: IF (l_debug = 1) THEN
17076: print_debug('split_lot_serial:237: serial quantity '||l_serial_quantity, 1);
17077: END If;

Line 19244: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

19240: RAISE fnd_api.g_exc_error;
19241: END IF;
19242:
19243: L_SERIAL_QUANTITY :=
19244: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
19245: L_MSNT_REC.TO_SERIAL_NUMBER);
19246:
19247: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
19248: l_serial_quantity;

Line 19807: inv_serial_number_pub.validate_update_serial_att

19803: END IF;
19804:
19805: IF (Nvl(l_curr_status, 1) IN (1,6)) THEN
19806: --validate and update the attributes.
19807: inv_serial_number_pub.validate_update_serial_att
19808: (x_return_status => x_return_status,
19809: x_msg_count => x_msg_count,
19810: x_msg_data => x_msg_data,
19811: x_validation_status => l_validation_status,

Line 19863: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

19859: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
19860: --(INCLUDING ATT VALIDATION)
19861: --CREATE MSN
19862:
19863: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
19864: , p_inventory_item_id => l_item_id
19865: , p_organization_id => l_org_id
19866: , p_from_serial_number => l_serial_number
19867: , p_to_serial_number => l_serial_number

Line 19906: inv_serial_number_pub.validate_update_serial_att

19902: RAISE fnd_api.g_exc_error;
19903: END IF;
19904:
19905: --validate and update the attributes.
19906: inv_serial_number_pub.validate_update_serial_att
19907: (x_return_status => x_return_status,
19908: x_msg_count => x_msg_count,
19909: x_msg_data => x_msg_data,
19910: x_validation_status => l_validation_status,

Line 20016: inv_serial_number_pub.validate_update_serial_att

20012: END IF;
20013:
20014: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
20015: --validate and update the attributes.
20016: inv_serial_number_pub.validate_update_serial_att
20017: (x_return_status => x_return_status,
20018: x_msg_count => x_msg_count,
20019: x_msg_data => x_msg_data,
20020: x_validation_status => l_validation_status,

Line 20051: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

20047: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
20048: --(INCLUDING ATT VALIDATION)
20049: --CREATE MSN
20050:
20051: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
20052: , p_inventory_item_id => l_item_id
20053: , p_organization_id => l_org_id
20054: , p_from_serial_number => l_serial_number
20055: , p_to_serial_number => l_serial_number

Line 20095: inv_serial_number_pub.validate_update_serial_att

20091: RAISE fnd_api.g_exc_error;
20092: END IF;
20093:
20094: --validate and update the attributes.
20095: inv_serial_number_pub.validate_update_serial_att
20096: (x_return_status => x_return_status,
20097: x_msg_count => x_msg_count,
20098: x_msg_data => x_msg_data,
20099: x_validation_status => l_validation_status,

Line 20303: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

20299: RAISE fnd_api.g_exc_error;
20300: END IF;
20301:
20302: L_SERIAL_QUANTITY :=
20303: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
20304: L_MSNT_REC.TO_SERIAL_NUMBER);
20305:
20306: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
20307: l_serial_quantity;

Line 20881: inv_serial_number_pub.validate_update_serial_att

20877: END IF;
20878:
20879: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
20880: --validate and update the attributes.
20881: inv_serial_number_pub.validate_update_serial_att
20882: (x_return_status => x_return_status,
20883: x_msg_count => x_msg_count,
20884: x_msg_data => x_msg_data,
20885: x_validation_status => l_validation_status,

Line 20937: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

20933: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
20934: --(INCLUDING ATT VALIDATION)
20935: --CREATE MSN
20936:
20937: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
20938: , p_inventory_item_id => l_item_id
20939: , p_organization_id => l_org_id
20940: , p_from_serial_number => l_serial_number
20941: , p_to_serial_number => l_serial_number

Line 20980: inv_serial_number_pub.validate_update_serial_att

20976: RAISE fnd_api.g_exc_error;
20977: END IF;
20978:
20979: --validate and update the attributes.
20980: inv_serial_number_pub.validate_update_serial_att
20981: (x_return_status => x_return_status,
20982: x_msg_count => x_msg_count,
20983: x_msg_data => x_msg_data,
20984: x_validation_status => l_validation_status,

Line 21089: inv_serial_number_pub.validate_update_serial_att

21085: END IF;
21086:
21087: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
21088: --validate and update the attributes.
21089: inv_serial_number_pub.validate_update_serial_att
21090: (x_return_status => x_return_status,
21091: x_msg_count => x_msg_count,
21092: x_msg_data => x_msg_data,
21093: x_validation_status => l_validation_status,

Line 21124: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

21120: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
21121: --(INCLUDING ATT VALIDATION)
21122: --CREATE MSN
21123:
21124: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
21125: , p_inventory_item_id => l_item_id
21126: , p_organization_id => l_org_id
21127: , p_from_serial_number => l_serial_number
21128: , p_to_serial_number => l_serial_number

Line 21167: inv_serial_number_pub.validate_update_serial_att

21163: RAISE fnd_api.g_exc_error;
21164: END IF;
21165:
21166: --validate and update the attributes.
21167: inv_serial_number_pub.validate_update_serial_att
21168: (x_return_status => x_return_status,
21169: x_msg_count => x_msg_count,
21170: x_msg_data => x_msg_data,
21171: x_validation_status => l_validation_status,

Line 21905: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

21901:
21902: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
21903:
21904: L_SERIAL_QUANTITY :=
21905: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
21906: L_MSNT_REC.TO_SERIAL_NUMBER);
21907:
21908: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
21909:

Line 22116: inv_serial_number_pub.validate_update_serial_att

22112: END IF;
22113:
22114: IF (Nvl(l_curr_status, 1) IN (1,6)) THEN
22115: --validate and update the attributes.
22116: inv_serial_number_pub.validate_update_serial_att
22117: (x_return_status => x_return_status,
22118: x_msg_count => x_msg_count,
22119: x_msg_data => x_msg_data,
22120: x_validation_status => l_validation_status,

Line 22152: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

22148: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
22149: --(INCLUDING ATT VALIDATION)
22150: --CREATE MSN
22151:
22152: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
22153: , p_inventory_item_id => l_item_id
22154: , p_organization_id => l_org_id
22155: , p_from_serial_number => l_serial_number
22156: , p_to_serial_number => l_serial_number

Line 22195: inv_serial_number_pub.validate_update_serial_att

22191: RAISE fnd_api.g_exc_error;
22192: END IF;
22193:
22194: --validate and update the attributes.
22195: inv_serial_number_pub.validate_update_serial_att
22196: (x_return_status => x_return_status,
22197: x_msg_count => x_msg_count,
22198: x_msg_data => x_msg_data,
22199: x_validation_status => l_validation_status,

Line 22328: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

22324:
22325: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
22326:
22327: L_SERIAL_QUANTITY :=
22328: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
22329: L_MSNT_REC.TO_SERIAL_NUMBER);
22330:
22331: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
22332:

Line 22535: inv_serial_number_pub.validate_update_serial_att

22531: END IF;
22532:
22533: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
22534: --validate and update the attributes.
22535: inv_serial_number_pub.validate_update_serial_att
22536: (x_return_status => x_return_status,
22537: x_msg_count => x_msg_count,
22538: x_msg_data => x_msg_data,
22539: x_validation_status => l_validation_status,

Line 22571: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

22567: --PERFORM SERIAL VALIDATION FOR NEW SERIAL
22568: --(INCLUDING ATT VALIDATION)
22569: --CREATE MSN
22570:
22571: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
22572: , p_inventory_item_id => l_item_id
22573: , p_organization_id => l_org_id
22574: , p_from_serial_number => l_serial_number
22575: , p_to_serial_number => l_serial_number

Line 22614: inv_serial_number_pub.validate_update_serial_att

22610: RAISE fnd_api.g_exc_error;
22611: END IF;
22612:
22613: --validate and update the attributes.
22614: inv_serial_number_pub.validate_update_serial_att
22615: (x_return_status => x_return_status,
22616: x_msg_count => x_msg_count,
22617: x_msg_data => x_msg_data,
22618: x_validation_status => l_validation_status,

Line 24305: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

24301:
24302: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
24303:
24304: L_SERIAL_QUANTITY :=
24305: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
24306: L_MSNT_REC.TO_SERIAL_NUMBER);
24307:
24308: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
24309:

Line 24516: inv_serial_number_pub.validate_update_serial_att

24512: END IF;
24513:
24514: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
24515: --validate and update the attributes.
24516: inv_serial_number_pub.validate_update_serial_att
24517: (x_return_status => x_return_status,
24518: x_msg_count => x_msg_count,
24519: x_msg_data => x_msg_data,
24520: x_validation_status => l_validation_status,

Line 24557: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

24553: ELSE
24554: l_transaction_action_id := 1;
24555: END IF;
24556:
24557: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
24558: , p_inventory_item_id => l_item_id
24559: , p_organization_id => l_org_id
24560: , p_from_serial_number => l_serial_number
24561: , p_to_serial_number => l_serial_number

Line 24600: inv_serial_number_pub.validate_update_serial_att

24596: RAISE fnd_api.g_exc_error;
24597: END IF;
24598:
24599: --validate and update the attributes.
24600: inv_serial_number_pub.validate_update_serial_att
24601: (x_return_status => x_return_status,
24602: x_msg_count => x_msg_count,
24603: x_msg_data => x_msg_data,
24604: x_validation_status => l_validation_status,

Line 24722: inv_serial_number_pub.validate_update_serial_att

24718: END IF;
24719:
24720: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
24721: --validate and update the attributes.
24722: inv_serial_number_pub.validate_update_serial_att
24723: (x_return_status => x_return_status,
24724: x_msg_count => x_msg_count,
24725: x_msg_data => x_msg_data,
24726: x_validation_status => l_validation_status,

Line 24763: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

24759: ELSE
24760: l_transaction_action_id := 1;
24761: END IF;
24762:
24763: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
24764: , p_inventory_item_id => l_item_id
24765: , p_organization_id => l_org_id
24766: , p_from_serial_number => l_serial_number
24767: , p_to_serial_number => l_serial_number

Line 24806: inv_serial_number_pub.validate_update_serial_att

24802: RAISE fnd_api.g_exc_error;
24803: END IF;
24804:
24805: --validate and update the attributes.
24806: inv_serial_number_pub.validate_update_serial_att
24807: (x_return_status => x_return_status,
24808: x_msg_count => x_msg_count,
24809: x_msg_data => x_msg_data,
24810: x_validation_status => l_validation_status,

Line 24942: inv_serial_number_pub.validate_update_serial_att

24938: END IF;
24939:
24940: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
24941: --validate and update the attributes.
24942: inv_serial_number_pub.validate_update_serial_att
24943: (x_return_status => x_return_status,
24944: x_msg_count => x_msg_count,
24945: x_msg_data => x_msg_data,
24946: x_validation_status => l_validation_status,

Line 25071: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

25067:
25068: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
25069:
25070: L_SERIAL_QUANTITY :=
25071: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
25072: L_MSNT_REC.TO_SERIAL_NUMBER);
25073:
25074: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25075:

Line 25280: inv_serial_number_pub.validate_update_serial_att

25276: END IF;
25277:
25278: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
25279: --validate and update the attributes.
25280: inv_serial_number_pub.validate_update_serial_att
25281: (x_return_status => x_return_status,
25282: x_msg_count => x_msg_count,
25283: x_msg_data => x_msg_data,
25284: x_validation_status => l_validation_status,

Line 25321: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

25317: ELSE
25318: l_transaction_action_id := 1;
25319: END IF;
25320:
25321: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
25322: , p_inventory_item_id => l_item_id
25323: , p_organization_id => l_org_id
25324: , p_from_serial_number => l_serial_number
25325: , p_to_serial_number => l_serial_number

Line 25364: inv_serial_number_pub.validate_update_serial_att

25360: RAISE fnd_api.g_exc_error;
25361: END IF;
25362:
25363: --validate and update the attributes.
25364: inv_serial_number_pub.validate_update_serial_att
25365: (x_return_status => x_return_status,
25366: x_msg_count => x_msg_count,
25367: x_msg_data => x_msg_data,
25368: x_validation_status => l_validation_status,

Line 25481: inv_serial_number_pub.validate_update_serial_att

25477: END IF;
25478:
25479: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
25480: --validate and update the attributes.
25481: inv_serial_number_pub.validate_update_serial_att
25482: (x_return_status => x_return_status,
25483: x_msg_count => x_msg_count,
25484: x_msg_data => x_msg_data,
25485: x_validation_status => l_validation_status,

Line 25522: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

25518: ELSE
25519: l_transaction_action_id := 1;
25520: END IF;
25521:
25522: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
25523: , p_inventory_item_id => l_item_id
25524: , p_organization_id => l_org_id
25525: , p_from_serial_number => l_serial_number
25526: , p_to_serial_number => l_serial_number

Line 25565: inv_serial_number_pub.validate_update_serial_att

25561: RAISE fnd_api.g_exc_error;
25562: END IF;
25563:
25564: --validate and update the attributes.
25565: inv_serial_number_pub.validate_update_serial_att
25566: (x_return_status => x_return_status,
25567: x_msg_count => x_msg_count,
25568: x_msg_data => x_msg_data,
25569: x_validation_status => l_validation_status,

Line 25698: inv_serial_number_pub.validate_update_serial_att

25694: END IF;
25695:
25696: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
25697: --validate and update the attributes.
25698: inv_serial_number_pub.validate_update_serial_att
25699: (x_return_status => x_return_status,
25700: x_msg_count => x_msg_count,
25701: x_msg_data => x_msg_data,
25702: x_validation_status => l_validation_status,

Line 26668: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

26664:
26665: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
26666:
26667: L_SERIAL_QUANTITY :=
26668: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
26669: L_MSNT_REC.TO_SERIAL_NUMBER);
26670:
26671: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
26672:

Line 26932: inv_serial_number_pub.validate_update_serial_att

26928: END IF;
26929:
26930: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
26931: --validate and update the attributes.
26932: inv_serial_number_pub.validate_update_serial_att
26933: (x_return_status => x_return_status,
26934: x_msg_count => x_msg_count,
26935: x_msg_data => x_msg_data,
26936: x_validation_status => l_validation_status,

Line 27049: inv_serial_number_pub.validate_update_serial_att

27045: END IF;
27046:
27047: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27048: --validate and update the attributes.
27049: inv_serial_number_pub.validate_update_serial_att
27050: (x_return_status => x_return_status,
27051: x_msg_count => x_msg_count,
27052: x_msg_data => x_msg_data,
27053: x_validation_status => l_validation_status,

Line 27090: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

27086: ELSE
27087: l_transaction_action_id := 1;
27088: END IF;
27089:
27090: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
27091: , p_inventory_item_id => l_item_id
27092: , p_organization_id => l_org_id
27093: , p_from_serial_number => l_serial_number
27094: , p_to_serial_number => l_serial_number

Line 27133: inv_serial_number_pub.validate_update_serial_att

27129: RAISE fnd_api.g_exc_error;
27130: END IF;
27131:
27132: --validate and update the attributes.
27133: inv_serial_number_pub.validate_update_serial_att
27134: (x_return_status => x_return_status,
27135: x_msg_count => x_msg_count,
27136: x_msg_data => x_msg_data,
27137: x_validation_status => l_validation_status,

Line 27268: inv_serial_number_pub.validate_update_serial_att

27264: END IF;
27265:
27266: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27267: --validate and update the attributes.
27268: inv_serial_number_pub.validate_update_serial_att
27269: (x_return_status => x_return_status,
27270: x_msg_count => x_msg_count,
27271: x_msg_data => x_msg_data,
27272: x_validation_status => l_validation_status,

Line 27335: inv_serial_number_pub.validate_update_serial_att

27331: END IF;
27332:
27333: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27334: --validate and update the attributes.
27335: inv_serial_number_pub.validate_update_serial_att
27336: (x_return_status => x_return_status,
27337: x_msg_count => x_msg_count,
27338: x_msg_data => x_msg_data,
27339: x_validation_status => l_validation_status,

Line 27399: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

27395: ELSE
27396: l_transaction_action_id := 1;
27397: END IF;
27398:
27399: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
27400: , p_inventory_item_id => l_item_id
27401: , p_organization_id => l_org_id
27402: , p_from_serial_number => l_serial_number
27403: , p_to_serial_number => l_serial_number

Line 27442: inv_serial_number_pub.validate_update_serial_att

27438: RAISE fnd_api.g_exc_error;
27439: END IF;
27440:
27441: --validate and update the attributes.
27442: inv_serial_number_pub.validate_update_serial_att
27443: (x_return_status => x_return_status,
27444: x_msg_count => x_msg_count,
27445: x_msg_data => x_msg_data,
27446: x_validation_status => l_validation_status,

Line 27588: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,

27584:
27585: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
27586:
27587: L_SERIAL_QUANTITY :=
27588: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
27589: L_MSNT_REC.TO_SERIAL_NUMBER);
27590:
27591: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
27592:

Line 27848: inv_serial_number_pub.validate_update_serial_att

27844: END IF;
27845:
27846: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27847: --validate and update the attributes.
27848: inv_serial_number_pub.validate_update_serial_att
27849: (x_return_status => x_return_status,
27850: x_msg_count => x_msg_count,
27851: x_msg_data => x_msg_data,
27852: x_validation_status => l_validation_status,

Line 27960: inv_serial_number_pub.validate_update_serial_att

27956: END IF;
27957:
27958: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
27959: --validate and update the attributes.
27960: inv_serial_number_pub.validate_update_serial_att
27961: (x_return_status => x_return_status,
27962: x_msg_count => x_msg_count,
27963: x_msg_data => x_msg_data,
27964: x_validation_status => l_validation_status,

Line 28001: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

27997: ELSE
27998: l_transaction_action_id := 1;
27999: END IF;
28000:
28001: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
28002: , p_inventory_item_id => l_item_id
28003: , p_organization_id => l_org_id
28004: , p_from_serial_number => l_serial_number
28005: , p_to_serial_number => l_serial_number

Line 28044: inv_serial_number_pub.validate_update_serial_att

28040: RAISE fnd_api.g_exc_error;
28041: END IF;
28042:
28043: --validate and update the attributes.
28044: inv_serial_number_pub.validate_update_serial_att
28045: (x_return_status => x_return_status,
28046: x_msg_count => x_msg_count,
28047: x_msg_data => x_msg_data,
28048: x_validation_status => l_validation_status,

Line 28177: inv_serial_number_pub.validate_update_serial_att

28173: END IF;
28174:
28175: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
28176: --validate and update the attributes.
28177: inv_serial_number_pub.validate_update_serial_att
28178: (x_return_status => x_return_status,
28179: x_msg_count => x_msg_count,
28180: x_msg_data => x_msg_data,
28181: x_validation_status => l_validation_status,

Line 28243: inv_serial_number_pub.validate_update_serial_att

28239: END IF;
28240:
28241: IF (Nvl(l_curr_status, 1) in (1,6)) THEN
28242: --validate and update the attributes.
28243: inv_serial_number_pub.validate_update_serial_att
28244: (x_return_status => x_return_status,
28245: x_msg_count => x_msg_count,
28246: x_msg_data => x_msg_data,
28247: x_validation_status => l_validation_status,

Line 28308: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0

28304: ELSE
28305: l_transaction_action_id := 1;
28306: END IF;
28307:
28308: inv_serial_number_pub.insert_range_serial(p_api_version => 1.0
28309: , p_inventory_item_id => l_item_id
28310: , p_organization_id => l_org_id
28311: , p_from_serial_number => l_serial_number
28312: , p_to_serial_number => l_serial_number

Line 28351: inv_serial_number_pub.validate_update_serial_att

28347: RAISE fnd_api.g_exc_error;
28348: END IF;
28349:
28350: --validate and update the attributes.
28351: inv_serial_number_pub.validate_update_serial_att
28352: (x_return_status => x_return_status,
28353: x_msg_count => x_msg_count,
28354: x_msg_data => x_msg_data,
28355: x_validation_status => l_validation_status,