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_ROI_INTEGRATION_GRP

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 18829: in Package INV_ROI_INTEGRATION_GRP to perform the same set of validations for all.

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
18833: IF (NOT l_discrete_transaction) THEN

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 19110: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.

19106: END IF; --IF (l_discrete_transaction) THEN
19107: */
19108:
19109: /*INVCONV , Perform lot validations and create the new lot.
19110: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
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

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 19163: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);

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:
19167: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

Line 19167: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

19163: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
19164: END IF;
19165:
19166:
19167: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
19168: x_return_status => x_return_status
19169: ,x_msg_count => x_msg_count
19170: ,x_msg_data => x_msg_data
19171: ,p_api_version => 1.0

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

19188: );
19189:
19190: /*INVCONV ,*/
19191: IF (l_debug = 1) THEN
19192: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
19193: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
19194: END IF;
19195:
19196: IF X_RETURN_STATUS <> 'S' THEN

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

19189:
19190: /*INVCONV ,*/
19191: IF (l_debug = 1) THEN
19192: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
19193: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
19194: END IF;
19195:
19196: IF X_RETURN_STATUS <> 'S' THEN
19197: --RAISE ERROR

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 21788: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.

21784: END IF; --IF (l_discrete_transaction) THEN
21785:
21786:
21787: /*INVCONV , Perform lot validations and create the new lot.
21788: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
21789: This shall also create lot specific conversions after creating the new Lot.
21790: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
21791: Punit Kumar*/
21792:

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 21841: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);

21837: END IF;
21838:
21839: /*INVCONV ,*/
21840: IF (l_debug = 1) THEN
21841: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
21842: END IF;
21843:
21844: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
21845: x_return_status => x_return_status

Line 21844: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

21840: IF (l_debug = 1) THEN
21841: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
21842: END IF;
21843:
21844: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
21845: x_return_status => x_return_status
21846: ,x_msg_count => x_msg_count
21847: ,x_msg_data => x_msg_data
21848: ,p_api_version => 1.0

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

21864: ,p_mtlt_rowid => L_MTLT_REC.ROWID
21865: );
21866: /*INVCONV ,*/
21867: IF (l_debug = 1) THEN
21868: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
21869: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
21870: END IF;
21871:
21872: IF X_RETURN_STATUS <> 'S' THEN

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

21865: );
21866: /*INVCONV ,*/
21867: IF (l_debug = 1) THEN
21868: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
21869: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
21870: END IF;
21871:
21872: IF X_RETURN_STATUS <> 'S' THEN
21873: --RAISE ERROR

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 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 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 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 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 23695: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.

23691: */
23692: /*end , INVCONV */
23693:
23694: /*INVCONV , Perform lot validations and create the new lot.
23695: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
23696: This shall also create lot specific conversions after creating the new Lot.
23697: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
23698: Punit Kumar*/
23699:

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 23749: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);

23745: END IF;
23746:
23747: /*INVCONV ,*/
23748: IF (l_debug = 1) THEN
23749: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23750: END IF;
23751:
23752: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
23753: x_return_status => x_return_status

Line 23752: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

23748: IF (l_debug = 1) THEN
23749: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23750: END IF;
23751:
23752: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
23753: x_return_status => x_return_status
23754: ,x_msg_count => x_msg_count
23755: ,x_msg_data => x_msg_data
23756: ,p_api_version => 1.0

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

23773: );
23774:
23775: /*INVCONV ,*/
23776: IF (l_debug = 1) THEN
23777: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23778: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
23779: END IF;
23780:
23781: IF X_RETURN_STATUS <> 'S' THEN

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

23774:
23775: /*INVCONV ,*/
23776: IF (l_debug = 1) THEN
23777: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23778: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
23779: END IF;
23780:
23781: IF X_RETURN_STATUS <> 'S' THEN
23782: --RAISE ERROR

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 23987: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);

23983: END IF;
23984:
23985: /*INVCONV ,*/
23986: IF (l_debug = 1) THEN
23987: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23988: END IF;
23989:
23990: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
23991: x_return_status => x_return_status

Line 23990: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

23986: IF (l_debug = 1) THEN
23987: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23988: END IF;
23989:
23990: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
23991: x_return_status => x_return_status
23992: ,x_msg_count => x_msg_count
23993: ,x_msg_data => x_msg_data
23994: ,p_api_version => 1.0

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

24011: );
24012:
24013: /*INVCONV ,*/
24014: IF (l_debug = 1) THEN
24015: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24016: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24017: END IF;
24018:
24019:

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

24012:
24013: /*INVCONV ,*/
24014: IF (l_debug = 1) THEN
24015: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24016: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24017: END IF;
24018:
24019:
24020: IF X_RETURN_STATUS <> 'S' THEN

Line 24174: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.

24170: );
24171:
24172: */
24173: /*INVCONV , Perform lot validations and create the new lot.
24174: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
24175: This shall also create lot specific conversions after creating the new Lot.
24176: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
24177: Punit Kumar*/
24178:

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 24228: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);

24224: END IF;
24225:
24226: /*INVCONV ,*/
24227: IF (l_debug = 1) THEN
24228: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24229: END IF;
24230:
24231: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
24232: x_return_status => x_return_status

Line 24231: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

24227: IF (l_debug = 1) THEN
24228: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24229: END IF;
24230:
24231: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
24232: x_return_status => x_return_status
24233: ,x_msg_count => x_msg_count
24234: ,x_msg_data => x_msg_data
24235: ,p_api_version => 1.0

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

24252: );
24253:
24254: /*INVCONV ,*/
24255: IF (l_debug = 1) THEN
24256: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24257: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24258: END IF;
24259:
24260: IF X_RETURN_STATUS <> 'S' THEN

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

24253:
24254: /*INVCONV ,*/
24255: IF (l_debug = 1) THEN
24256: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24257: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24258: END IF;
24259:
24260: IF X_RETURN_STATUS <> 'S' THEN
24261: --RAISE ERROR

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 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 26547: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.

26543:
26544: */
26545:
26546: /*INVCONV , Perform lot validations and create the new lot.
26547: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
26548: This shall also create lot specific conversions after creating the new Lot.
26549: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
26550: Punit Kumar*/
26551:

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 26601: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);

26597: END IF;
26598:
26599: /*INVCONV ,*/
26600: IF (l_debug = 1) THEN
26601: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
26602: END IF;
26603:
26604: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
26605: x_return_status => x_return_status

Line 26604: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

26600: IF (l_debug = 1) THEN
26601: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
26602: END IF;
26603:
26604: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
26605: x_return_status => x_return_status
26606: ,x_msg_count => x_msg_count
26607: ,x_msg_data => x_msg_data
26608: ,p_api_version => 1.0

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

26625: );
26626:
26627: /*INVCONV ,*/
26628: IF (l_debug = 1) THEN
26629: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
26630: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
26631: END IF;
26632:
26633: IF X_RETURN_STATUS <> 'S' THEN

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

26626:
26627: /*INVCONV ,*/
26628: IF (l_debug = 1) THEN
26629: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
26630: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
26631: END IF;
26632:
26633: IF X_RETURN_STATUS <> 'S' THEN
26634: --RAISE ERROR