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_VALIDATE

Line 850: inv_validate.number_from_sequence(l_msnt.fm_serial_number, l_temp_prefix, l_from_ser_number);

846: ' to_serial_number = ' || l_msnt.to_serial_number,1);
847: END IF;
848:
849: l_progress := 'WMSINB-10677';
850: inv_validate.number_from_sequence(l_msnt.fm_serial_number, l_temp_prefix, l_from_ser_number);
851: l_progress := 'WMSINB-10679';
852: inv_validate.number_from_sequence(l_msnt.to_serial_number
853: ,l_temp_prefix
854: ,l_to_ser_number);

Line 852: inv_validate.number_from_sequence(l_msnt.to_serial_number

848:
849: l_progress := 'WMSINB-10677';
850: inv_validate.number_from_sequence(l_msnt.fm_serial_number, l_temp_prefix, l_from_ser_number);
851: l_progress := 'WMSINB-10679';
852: inv_validate.number_from_sequence(l_msnt.to_serial_number
853: ,l_temp_prefix
854: ,l_to_ser_number);
855: l_progress := 'WMSINB-10683';
856: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;

Line 16992: inv_validate.number_from_sequence(l_msni_rec.fm_serial_number, l_temp_prefix, l_from_ser_number);

16988: l_remaining_serial_qty := l_remaining_serial_qty
16989: - l_serial_quantity;
16990: ELSE
16991: -- split the msni row
16992: inv_validate.number_from_sequence(l_msni_rec.fm_serial_number, l_temp_prefix, l_from_ser_number);
16993:
16994: l_new_to_ser_num :=
16995: SUBSTR(l_msni_rec.fm_serial_number, 1,
16996: LENGTH(l_msni_rec.fm_serial_number) -

Line 17094: inv_validate.number_from_sequence(l_msni_rec.fm_serial_number, l_temp_prefix, l_from_ser_number);

17090: l_remaining_quantity := l_remaining_quantity -
17091: l_serial_quantity;
17092: ELSE
17093: -- split msni
17094: inv_validate.number_from_sequence(l_msni_rec.fm_serial_number, l_temp_prefix, l_from_ser_number);
17095:
17096: IF (l_debug = 1) THEN
17097: print_debug('split_lot_serial:242: Almost ready to split msni ', 1);
17098: END If;

Line 18719: we shall now call a new procedure INV_ROI_INTEGRATION_GRP. INV_VALIDATE_LOT.

18715: END IF;
18716: END IF; --IF (l_transaction_type = 'DELIVER' OR l_auto_transact_code = 'DELIVER') THEN
18717:
18718: /*INVCONV , Instead of calling OPM specific API gml_opm_roi_grp.validate_opm_lot,
18719: we shall now call a new procedure INV_ROI_INTEGRATION_GRP. INV_VALIDATE_LOT.
18720: This new procedure shall validate the extra process attributes
18721: that are being merged for discrete items too.
18722: Punit Kumar */
18723: /*

Line 18741: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

18737: );
18738: */
18739:
18740: IF (l_debug = 1) THEN
18741: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
18742: print_debug('transaction type id before calling in validate_lot_serial_info is : '||l_transaction_type_id||' : '||l_progress, 1);
18743: END IF;
18744:
18745:

Line 18748: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

18744:
18745:
18746:
18747:
18748: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
18749: x_return_status => x_return_status
18750: ,x_msg_data => x_msg_data
18751: ,x_msg_count => x_msg_count
18752: ,p_api_version => 1.0

Line 18778: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

18774: ,p_parent_txn_type => l_parent_txn_type
18775: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
18776: );
18777: IF (l_debug = 1) THEN
18778: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
18779: END IF;
18780: /* end , INVCONV */
18781:
18782:

Line 18828: /*INVCONV , Removing the process specific call. Shall call a new procedure INV_VALIDATE_LOT

18824: l_progress := 'WMSINB-22290';
18825: RAISE fnd_api.g_exc_error;
18826: END;
18827:
18828: /*INVCONV , Removing the process specific call. Shall call a new procedure INV_VALIDATE_LOT
18829: in Package INV_ROI_INTEGRATION_GRP to perform the same set of validations for all.
18830: Punit Kumar*/
18831: /*
18832: -- opm change bug# 3061052

Line 18849: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

18845: );
18846:
18847: */
18848: IF (l_debug = 1) THEN
18849: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
18850: END IF;
18851:
18852: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
18853: x_return_status => x_return_status

Line 18852: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

18848: IF (l_debug = 1) THEN
18849: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
18850: END IF;
18851:
18852: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
18853: x_return_status => x_return_status
18854: ,x_msg_data => x_msg_data
18855: ,x_msg_count => x_msg_count
18856: ,p_api_version => 1.0

Line 18883: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

18879: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
18880: );
18881:
18882: IF (l_debug = 1) THEN
18883: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
18884: END IF;
18885:
18886: IF X_RETURN_STATUS <> 'S' THEN
18887: --RAISE ERROR

Line 19115: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

19111: This shall also create lot specific conversions after creating the new Lot.
19112: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
19113: Punit Kumar*/
19114: IF (l_debug = 1) THEN
19115: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19116: END IF;
19117:
19118: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
19119: x_return_status => x_return_status

Line 19118: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

19114: IF (l_debug = 1) THEN
19115: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19116: END IF;
19117:
19118: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
19119: x_return_status => x_return_status
19120: ,x_msg_data => x_msg_data
19121: ,x_msg_count => x_msg_count
19122: ,p_api_version => 1.0

Line 19150: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

19146: );
19147:
19148: IF (l_debug = 1) THEN
19149:
19150: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19151: END IF;
19152:
19153:
19154: IF X_RETURN_STATUS <> 'S' THEN

Line 19162: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

19158: END IF;
19159:
19160: /*INVCONV ,*/
19161: IF (l_debug = 1) THEN
19162: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
19163: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
19164: END IF;
19165:
19166:

Line 19250: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

19246:
19247: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
19248: l_serial_quantity;
19249:
19250: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
19251: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
19252:
19253: IF (l_debug = 1) THEN
19254: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 19251: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

19247: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
19248: l_serial_quantity;
19249:
19250: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
19251: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
19252:
19253: IF (l_debug = 1) THEN
19254: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
19255: l_progress := 'WMSINB-22551';

Line 20309: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

20305:
20306: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
20307: l_serial_quantity;
20308:
20309: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
20310: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
20311:
20312: IF (l_debug = 1) THEN
20313: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 20310: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

20306: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
20307: l_serial_quantity;
20308:
20309: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
20310: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
20311:
20312: IF (l_debug = 1) THEN
20313: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
20314: l_progress := 'WMSINB-23233';

Line 21593: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

21589: end , INVCONV */
21590:
21591: /*INVCONV ,*/
21592: IF (l_debug = 1) THEN
21593: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21594: END IF;
21595:
21596: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
21597: x_return_status => x_return_status

Line 21596: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

21592: IF (l_debug = 1) THEN
21593: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21594: END IF;
21595:
21596: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
21597: x_return_status => x_return_status
21598: ,x_msg_data => x_msg_data
21599: ,x_msg_count => x_msg_count
21600: ,p_api_version => 1.0

Line 21627: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

21623: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
21624: );
21625: /*INVCONV ,*/
21626: IF (l_debug = 1) THEN
21627: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21628: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
21629: END IF;
21630:
21631: IF X_RETURN_STATUS <> 'S' THEN

Line 21628: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

21624: );
21625: /*INVCONV ,*/
21626: IF (l_debug = 1) THEN
21627: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21628: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
21629: END IF;
21630:
21631: IF X_RETURN_STATUS <> 'S' THEN
21632: --RAISE ERROR

Line 21638: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

21634: RAISE fnd_api.g_exc_error;
21635: END IF;
21636:
21637: IF (l_debug = 1) THEN
21638: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
21639: END IF;
21640:
21641: /*END IF; --IF (l_discrete_transaction) THEN */
21642:

Line 21795: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

21791: Punit Kumar*/
21792:
21793: /*INVCONV ,*/
21794: IF (l_debug = 1) THEN
21795: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21796: END IF;
21797:
21798: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
21799: x_return_status => x_return_status

Line 21798: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

21794: IF (l_debug = 1) THEN
21795: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21796: END IF;
21797:
21798: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
21799: x_return_status => x_return_status
21800: ,x_msg_data => x_msg_data
21801: ,x_msg_count => x_msg_count
21802: ,p_api_version => 1.0

Line 21829: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

21825: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
21826: );
21827: /*INVCONV ,*/
21828: IF (l_debug = 1) THEN
21829: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21830: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
21831: END IF;
21832:
21833: IF (x_return_status <> 'S') THEN

Line 21830: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

21826: );
21827: /*INVCONV ,*/
21828: IF (l_debug = 1) THEN
21829: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
21830: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
21831: END IF;
21832:
21833: IF (x_return_status <> 'S') THEN
21834: --raise error

Line 21910: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

21906: L_MSNT_REC.TO_SERIAL_NUMBER);
21907:
21908: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
21909:
21910: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
21911: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
21912:
21913: IF (l_debug = 1) THEN
21914: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 21911: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

21907:
21908: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
21909:
21910: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
21911: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
21912:
21913: IF (l_debug = 1) THEN
21914: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
21915: l_progress := 'WMSINB-24127';

Line 22333: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

22329: L_MSNT_REC.TO_SERIAL_NUMBER);
22330:
22331: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
22332:
22333: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
22334: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
22335:
22336: IF (l_debug = 1) THEN
22337: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 22334: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

22330:
22331: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
22332:
22333: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
22334: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
22335:
22336: IF (l_debug = 1) THEN
22337: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
22338: print_debug('VALIDATE_LOT_SERIAL_INFO: L_TEMP_PREFIX: '||L_TEMP_PREFIX, 1);

Line 23036: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23032:
23033: */
23034: /*INVCONV ,*/
23035: IF (l_debug = 1) THEN
23036: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23037: END IF;
23038:
23039: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23040: x_return_status => x_return_status

Line 23039: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23035: IF (l_debug = 1) THEN
23036: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23037: END IF;
23038:
23039: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23040: x_return_status => x_return_status
23041: ,x_msg_data => x_msg_data
23042: ,x_msg_count => x_msg_count
23043: ,p_api_version => 1.0

Line 23071: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23067: );
23068:
23069: /*INVCONV ,*/
23070: IF (l_debug = 1) THEN
23071: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23072: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23073: END IF;
23074:
23075: IF X_RETURN_STATUS <> 'S' THEN

Line 23072: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23068:
23069: /*INVCONV ,*/
23070: IF (l_debug = 1) THEN
23071: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23072: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23073: END IF;
23074:
23075: IF X_RETURN_STATUS <> 'S' THEN
23076: --RAISE ERROR

Line 23082: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

23078: RAISE fnd_api.g_exc_error;
23079: END IF;
23080:
23081: IF (l_debug = 1) THEN
23082: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
23083: END IF;
23084: /*END IF; --IF (l_discrete_transaction) THEN*/
23085: ELSE --IF (l_grand_parent_txn_type = 'DELIVER') THEN
23086: IF (validate_rs(NULL,l_grand_parent_txn_id,l_dummy_lpn)) THEN

Line 23117: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23113: */
23114:
23115: /*INVCONV ,*/
23116: IF (l_debug = 1) THEN
23117: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23118: END IF;
23119:
23120: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23121: x_return_status => x_return_status

Line 23120: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23116: IF (l_debug = 1) THEN
23117: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23118: END IF;
23119:
23120: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23121: x_return_status => x_return_status
23122: ,x_msg_data => x_msg_data
23123: ,x_msg_count => x_msg_count
23124: ,p_api_version => 1.0

Line 23152: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23148: );
23149:
23150: /*INVCONV ,*/
23151: IF (l_debug = 1) THEN
23152: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23153: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23154: END IF;
23155:
23156: IF X_RETURN_STATUS <> 'S' THEN

Line 23153: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23149:
23150: /*INVCONV ,*/
23151: IF (l_debug = 1) THEN
23152: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23153: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23154: END IF;
23155:
23156: IF X_RETURN_STATUS <> 'S' THEN
23157: --RAISE ERROR

Line 23163: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

23159: RAISE fnd_api.g_exc_error;
23160: END IF;
23161:
23162: IF (l_debug = 1) THEN
23163: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
23164: END IF;
23165: /*END IF; --IF (NOT l_discrete_transaction) THEN*/
23166:
23167: END IF; --IF (l_grand_parent_txn_type = 'DELIVER') THEN

Line 23273: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23269: */
23270:
23271: /*INVCONV ,*/
23272: IF (l_debug = 1) THEN
23273: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23274: END IF;
23275:
23276:
23277: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

Line 23277: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23273: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23274: END IF;
23275:
23276:
23277: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23278: x_return_status => x_return_status
23279: ,x_msg_data => x_msg_data
23280: ,x_msg_count => x_msg_count
23281: ,p_api_version => 1.0

Line 23309: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23305: );
23306:
23307: /*INVCONV ,*/
23308: IF (l_debug = 1) THEN
23309: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23310: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23311: END IF;
23312:
23313: IF X_RETURN_STATUS <> 'S' THEN

Line 23310: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23306:
23307: /*INVCONV ,*/
23308: IF (l_debug = 1) THEN
23309: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23310: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23311: END IF;
23312:
23313: IF X_RETURN_STATUS <> 'S' THEN
23314: --RAISE ERROR

Line 23320: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

23316: RAISE fnd_api.g_exc_error;
23317: END IF;
23318:
23319: IF (l_debug = 1) THEN
23320: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
23321: END IF;
23322: /*END IF; --IF (l_discrete_transaction) THEN*/
23323:
23324: ELSE -- ELSIF (l_parent_txn_type = g_rtr)

Line 23375: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23371:
23372: */
23373: /*INVCONV ,*/
23374: IF (l_debug = 1) THEN
23375: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23376: END IF;
23377:
23378:
23379: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

Line 23379: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23375: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23376: END IF;
23377:
23378:
23379: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23380: x_return_status => x_return_status
23381: ,x_msg_data => x_msg_data
23382: ,x_msg_count => x_msg_count
23383: ,p_api_version => 1.0

Line 23411: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23407: );
23408:
23409: /*INVCONV ,*/
23410: IF (l_debug = 1) THEN
23411: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23412: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23413: END IF;
23414:
23415: IF X_RETURN_STATUS <> 'S' THEN

Line 23412: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23408:
23409: /*INVCONV ,*/
23410: IF (l_debug = 1) THEN
23411: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23412: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23413: END IF;
23414:
23415: IF X_RETURN_STATUS <> 'S' THEN
23416: --RAISE ERROR

Line 23422: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

23418: RAISE fnd_api.g_exc_error;
23419: END IF;
23420:
23421: IF (l_debug = 1) THEN
23422: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
23423: END IF;
23424: /*END IF; --IF (NOT l_discrete_transaction) THEN*/
23425: /*end , INVCONV*/
23426: ELSE --IF l_parent_txn_type <> 'DELIVER' THEN

Line 23501: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23497:
23498: */
23499: /*INVCONV ,*/
23500: IF (l_debug = 1) THEN
23501: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23502: END IF;
23503:
23504:
23505: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

Line 23505: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23501: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23502: END IF;
23503:
23504:
23505: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23506: x_return_status => x_return_status
23507: ,x_msg_data => x_msg_data
23508: ,x_msg_count => x_msg_count
23509: ,p_api_version => 1.0

Line 23537: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23533: );
23534:
23535: /*INVCONV ,*/
23536: IF (l_debug = 1) THEN
23537: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23538: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23539: END IF;
23540:
23541: IF X_RETURN_STATUS <> 'S' THEN

Line 23538: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23534:
23535: /*INVCONV ,*/
23536: IF (l_debug = 1) THEN
23537: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23538: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23539: END IF;
23540:
23541: IF X_RETURN_STATUS <> 'S' THEN
23542: --RAISE ERROR

Line 23548: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

23544: RAISE fnd_api.g_exc_error;
23545: END IF;
23546:
23547: IF (l_debug = 1) THEN
23548: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
23549: END IF;
23550: /*END IF; -- IF (l_discrete_transaction) THEN*/
23551: END IF; --IF l_parent_txn_type <> 'DELIVER' THEN
23552: END IF; --IF (l_parent_txn_type IN (g_rtv, g_rtc)) THEN

Line 23702: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23698: Punit Kumar*/
23699:
23700: /*INVCONV ,*/
23701: IF (l_debug = 1) THEN
23702: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23703: END IF;
23704:
23705: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23706: x_return_status => x_return_status

Line 23705: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23701: IF (l_debug = 1) THEN
23702: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23703: END IF;
23704:
23705: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23706: x_return_status => x_return_status
23707: ,x_msg_data => x_msg_data
23708: ,x_msg_count => x_msg_count
23709: ,p_api_version => 1.0

Line 23737: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23733: );
23734:
23735: /*INVCONV ,*/
23736: IF (l_debug = 1) THEN
23737: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23738: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23739: END IF;
23740:
23741: IF (x_return_status <> 'S') THEN

Line 23738: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23734:
23735: /*INVCONV ,*/
23736: IF (l_debug = 1) THEN
23737: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23738: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23739: END IF;
23740:
23741: IF (x_return_status <> 'S') THEN
23742: --raise error

Line 23788: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

23784: RAISE fnd_api.g_exc_error;
23785: END IF;
23786:
23787: IF (l_debug = 1) THEN
23788: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
23789: END IF;
23790: /*END IF; --IF (l_discrete_transaction) THEN*/
23791: ELSE --IF (l_grand_parent_txn_type = 'DELIVER') THEN
23792: IF (validate_rs(NULL,l_grand_parent_txn_id,l_dummy_lpn)) THEN

Line 23940: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23936: */
23937:
23938: /*INVCONV ,*/
23939: IF (l_debug = 1) THEN
23940: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23941: END IF;
23942:
23943: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23944: x_return_status => x_return_status

Line 23943: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

23939: IF (l_debug = 1) THEN
23940: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23941: END IF;
23942:
23943: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
23944: x_return_status => x_return_status
23945: ,x_msg_data => x_msg_data
23946: ,x_msg_count => x_msg_count
23947: ,p_api_version => 1.0

Line 23975: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

23971: );
23972:
23973: /*INVCONV ,*/
23974: IF (l_debug = 1) THEN
23975: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23976: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23977: END IF;
23978:
23979: IF (x_return_status <> 'S') THEN

Line 23976: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

23972:
23973: /*INVCONV ,*/
23974: IF (l_debug = 1) THEN
23975: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23976: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23977: END IF;
23978:
23979: IF (x_return_status <> 'S') THEN
23980: --raise error

Line 24027: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24023: RAISE fnd_api.g_exc_error;
24024: END IF;
24025:
24026: IF (l_debug = 1) THEN
24027: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24028: END IF;
24029: /*END IF; --IF (l_discrete_transaction) THEN*/
24030: END IF; --IF (l_grand_parent_txn_type = 'DELIVER') THEN
24031: ELSIF (l_parent_txn_type = g_rtr) THEN --IF (l_parent_txn_type IN (g_rtv,g_rtc)) THEN

Line 24181: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

24177: Punit Kumar*/
24178:
24179: /*INVCONV ,*/
24180: IF (l_debug = 1) THEN
24181: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24182: END IF;
24183:
24184: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24185: x_return_status => x_return_status

Line 24184: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24180: IF (l_debug = 1) THEN
24181: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24182: END IF;
24183:
24184: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24185: x_return_status => x_return_status
24186: ,x_msg_data => x_msg_data
24187: ,x_msg_count => x_msg_count
24188: ,p_api_version => 1.0

Line 24216: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

24212: );
24213:
24214: /*INVCONV ,*/
24215: IF (l_debug = 1) THEN
24216: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24217: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24218: END IF;
24219:
24220: IF (x_return_status <> 'S') THEN

Line 24217: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

24213:
24214: /*INVCONV ,*/
24215: IF (l_debug = 1) THEN
24216: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24217: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24218: END IF;
24219:
24220: IF (x_return_status <> 'S') THEN
24221: --raise error

Line 24267: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24263: RAISE fnd_api.g_exc_error;
24264: END IF;
24265:
24266: IF (l_debug = 1) THEN
24267: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24268: END IF;
24269: /* END IF ; -- IF (l_discrete_transaction) THEN*/
24270: END IF; ---- IF (lot_entered_on_parent(l_great_grand_parent_txn_id)) THEN
24271:

Line 24310: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

24306: L_MSNT_REC.TO_SERIAL_NUMBER);
24307:
24308: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
24309:
24310: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
24311: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
24312:
24313: IF (l_debug = 1) THEN
24314: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 24311: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

24307:
24308: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
24309:
24310: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
24311: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
24312:
24313: IF (l_debug = 1) THEN
24314: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
24315: l_progress := 'WMSINB-25398';

Line 25076: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

25072: L_MSNT_REC.TO_SERIAL_NUMBER);
25073:
25074: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25075:
25076: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
25077: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
25078:
25079: IF (l_debug = 1) THEN
25080: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 25077: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

25073:
25074: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25075:
25076: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
25077: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
25078:
25079: IF (l_debug = 1) THEN
25080: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
25081: l_progress := 'WMSINB-25907';

Line 26031: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26027: */
26028:
26029: /*INVCONV ,*/
26030: IF (l_debug = 1) THEN
26031: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26032: END IF;
26033:
26034: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26035: x_return_status => x_return_status

Line 26034: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

26030: IF (l_debug = 1) THEN
26031: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26032: END IF;
26033:
26034: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26035: x_return_status => x_return_status
26036: ,x_msg_data => x_msg_data
26037: ,x_msg_count => x_msg_count
26038: ,p_api_version => 1.0

Line 26066: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26062: );
26063:
26064: /*INVCONV ,*/
26065: IF (l_debug = 1) THEN
26066: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26067: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26068: END IF;
26069:
26070: IF X_RETURN_STATUS <> 'S' THEN

Line 26067: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

26063:
26064: /*INVCONV ,*/
26065: IF (l_debug = 1) THEN
26066: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26067: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26068: END IF;
26069:
26070: IF X_RETURN_STATUS <> 'S' THEN
26071: --RAISE ERROR

Line 26158: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26154: );
26155: */
26156: /*INVCONV ,*/
26157: IF (l_debug = 1) THEN
26158: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26159: END IF;
26160:
26161: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26162: x_return_status => x_return_status

Line 26161: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

26157: IF (l_debug = 1) THEN
26158: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26159: END IF;
26160:
26161: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26162: x_return_status => x_return_status
26163: ,x_msg_data => x_msg_data
26164: ,x_msg_count => x_msg_count
26165: ,p_api_version => 1.0

Line 26193: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26189: );
26190:
26191: /*INVCONV ,*/
26192: IF (l_debug = 1) THEN
26193: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26194: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26195: END IF;
26196:
26197: IF X_RETURN_STATUS <> 'S' THEN

Line 26194: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

26190:
26191: /*INVCONV ,*/
26192: IF (l_debug = 1) THEN
26193: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26194: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26195: END IF;
26196:
26197: IF X_RETURN_STATUS <> 'S' THEN
26198: --RAISE ERROR

Line 26204: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

26200: RAISE fnd_api.g_exc_error;
26201: END IF;
26202:
26203: IF (l_debug = 1) THEN
26204: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
26205: END IF;
26206:
26207: /*END IF; -- IF (l_discrete_transaction) THEN */
26208: ELSE --IF (l_lot_exists = 1) THEN

Line 26356: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26352:
26353: */
26354: /*INVCONV ,*/
26355: IF (l_debug = 1) THEN
26356: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26357: END IF;
26358:
26359: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26360: x_return_status => x_return_status

Line 26359: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

26355: IF (l_debug = 1) THEN
26356: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26357: END IF;
26358:
26359: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26360: x_return_status => x_return_status
26361: ,x_msg_data => x_msg_data
26362: ,x_msg_count => x_msg_count
26363: ,p_api_version => 1.0

Line 26392: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26388:
26389:
26390: /*INVCONV ,*/
26391: IF (l_debug = 1) THEN
26392: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26393: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26394: END IF;
26395:
26396: IF X_RETURN_STATUS <> 'S' THEN

Line 26393: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

26389:
26390: /*INVCONV ,*/
26391: IF (l_debug = 1) THEN
26392: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26393: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26394: END IF;
26395:
26396: IF X_RETURN_STATUS <> 'S' THEN
26397: --RAISE ERROR

Line 26554: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26550: Punit Kumar*/
26551:
26552: /*INVCONV ,*/
26553: IF (l_debug = 1) THEN
26554: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26555: END IF;
26556:
26557: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26558: x_return_status => x_return_status

Line 26557: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

26553: IF (l_debug = 1) THEN
26554: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26555: END IF;
26556:
26557: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26558: x_return_status => x_return_status
26559: ,x_msg_data => x_msg_data
26560: ,x_msg_count => x_msg_count
26561: ,p_api_version => 1.0

Line 26589: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);

26585: );
26586:
26587: /*INVCONV ,*/
26588: IF (l_debug = 1) THEN
26589: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26590: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26591: END IF;
26592:
26593: IF (x_return_status <> 'S') THEN

Line 26590: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);

26586:
26587: /*INVCONV ,*/
26588: IF (l_debug = 1) THEN
26589: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26590: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26591: END IF;
26592:
26593: IF (x_return_status <> 'S') THEN
26594: --raise error

Line 26673: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

26669: L_MSNT_REC.TO_SERIAL_NUMBER);
26670:
26671: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
26672:
26673: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
26674: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
26675:
26676: IF (l_debug = 1) THEN
26677: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 26674: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

26670:
26671: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
26672:
26673: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
26674: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
26675:
26676: IF (l_debug = 1) THEN
26677: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
26678: l_progress := 'WMSINB-26859';

Line 27593: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

27589: L_MSNT_REC.TO_SERIAL_NUMBER);
27590:
27591: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
27592:
27593: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
27594: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
27595:
27596: IF (l_debug = 1) THEN
27597: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

Line 27594: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);

27590:
27591: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
27592:
27593: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
27594: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
27595:
27596: IF (l_debug = 1) THEN
27597: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
27598: l_progress := 'WMSINB-27485';