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 19842: we shall now call a new procedure INV_ROI_INTEGRATION_GRP. INV_VALIDATE_LOT.

19838: END IF;
19839: END IF; --IF (l_transaction_type = 'DELIVER' OR l_auto_transact_code = 'DELIVER') THEN
19840:
19841: /*INVCONV , Instead of calling OPM specific API gml_opm_roi_grp.validate_opm_lot,
19842: we shall now call a new procedure INV_ROI_INTEGRATION_GRP. INV_VALIDATE_LOT.
19843: This new procedure shall validate the extra process attributes
19844: that are being merged for discrete items too.
19845: Punit Kumar */
19846: /*

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

19860: );
19861: */
19862:
19863: IF (l_debug = 1) THEN
19864: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19865: print_debug('transaction type id before calling in validate_lot_serial_info is : '||l_transaction_type_id||' : '||l_progress, 1);
19866: END IF;
19867:
19868:

Line 19871: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

19867:
19868:
19869:
19870:
19871: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
19872: x_return_status => x_return_status
19873: ,x_msg_data => x_msg_data
19874: ,x_msg_count => x_msg_count
19875: ,p_api_version => 1.0

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

19897: ,p_parent_txn_type => l_parent_txn_type
19898: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
19899: );
19900: IF (l_debug = 1) THEN
19901: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19902: END IF;
19903: /* end , INVCONV */
19904:
19905: IF X_RETURN_STATUS <> 'S' THEN

Line 19965: in Package INV_ROI_INTEGRATION_GRP to perform the same set of validations for all.

19961: RAISE fnd_api.g_exc_error;
19962: END;
19963:
19964: /*INVCONV , Removing the process specific call. Shall call a new procedure INV_VALIDATE_LOT
19965: in Package INV_ROI_INTEGRATION_GRP to perform the same set of validations for all.
19966: Punit Kumar*/
19967: /*
19968: -- opm change bug# 3061052
19969: IF (NOT l_discrete_transaction) THEN

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

19980: x_msg_count => x_msg_count
19981: );
19982: */
19983: IF (l_debug = 1) THEN
19984: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19985: END IF;
19986:
19987: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
19988: x_return_status => x_return_status

Line 19987: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

19983: IF (l_debug = 1) THEN
19984: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
19985: END IF;
19986:
19987: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
19988: x_return_status => x_return_status
19989: ,x_msg_data => x_msg_data
19990: ,x_msg_count => x_msg_count
19991: ,p_api_version => 1.0

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

20014: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
20015: );
20016:
20017: IF (l_debug = 1) THEN
20018: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
20019: END IF;
20020:
20021: IF X_RETURN_STATUS <> 'S' THEN
20022: --RAISE ERROR

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

20237: END IF; --IF (l_discrete_transaction) THEN
20238: */
20239:
20240: /*INVCONV , Perform lot validations and create the new lot.
20241: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
20242: This shall also create lot specific conversions after creating the new Lot.
20243: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
20244: Punit Kumar*/
20245: IF (l_debug = 1) THEN

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

20242: This shall also create lot specific conversions after creating the new Lot.
20243: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
20244: Punit Kumar*/
20245: IF (l_debug = 1) THEN
20246: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
20247: END IF;
20248:
20249: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
20250: x_return_status => x_return_status

Line 20249: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

20245: IF (l_debug = 1) THEN
20246: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
20247: END IF;
20248:
20249: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
20250: x_return_status => x_return_status
20251: ,x_msg_data => x_msg_data
20252: ,x_msg_count => x_msg_count
20253: ,p_api_version => 1.0

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

20276: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
20277: );
20278:
20279: IF (l_debug = 1) THEN
20280: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
20281: END IF;
20282:
20283: IF X_RETURN_STATUS <> 'S' THEN
20284: --RAISE ERROR

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

20287: END IF;
20288:
20289: /*INVCONV ,*/
20290: IF (l_debug = 1) THEN
20291: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
20292: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
20293: END IF;
20294:
20295:

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

20288:
20289: /*INVCONV ,*/
20290: IF (l_debug = 1) THEN
20291: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
20292: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
20293: END IF;
20294:
20295:
20296: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

Line 20296: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

20292: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
20293: END IF;
20294:
20295:
20296: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
20297: x_return_status => x_return_status
20298: ,x_msg_count => x_msg_count
20299: ,x_msg_data => x_msg_data
20300: ,p_api_version => 1.0

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

20317: );
20318:
20319: /*INVCONV ,*/
20320: IF (l_debug = 1) THEN
20321: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
20322: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
20323: END IF;
20324:
20325: IF X_RETURN_STATUS <> 'S' THEN

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

20318:
20319: /*INVCONV ,*/
20320: IF (l_debug = 1) THEN
20321: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
20322: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
20323: END IF;
20324:
20325: IF X_RETURN_STATUS <> 'S' THEN
20326: --RAISE ERROR

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

22783: end , INVCONV */
22784:
22785: /*INVCONV ,*/
22786: IF (l_debug = 1) THEN
22787: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
22788: END IF;
22789:
22790: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
22791: x_return_status => x_return_status

Line 22790: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

22786: IF (l_debug = 1) THEN
22787: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
22788: END IF;
22789:
22790: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
22791: x_return_status => x_return_status
22792: ,x_msg_data => x_msg_data
22793: ,x_msg_count => x_msg_count
22794: ,p_api_version => 1.0

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

22817: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
22818: );
22819: /*INVCONV ,*/
22820: IF (l_debug = 1) THEN
22821: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
22822: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
22823: END IF;
22824:
22825: IF X_RETURN_STATUS <> 'S' THEN

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

22818: );
22819: /*INVCONV ,*/
22820: IF (l_debug = 1) THEN
22821: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
22822: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
22823: END IF;
22824:
22825: IF X_RETURN_STATUS <> 'S' THEN
22826: --RAISE ERROR

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

22978: END IF; --IF (l_discrete_transaction) THEN
22979:
22980:
22981: /*INVCONV , Perform lot validations and create the new lot.
22982: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
22983: This shall also create lot specific conversions after creating the new Lot.
22984: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
22985: Punit Kumar*/
22986:

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

22985: Punit Kumar*/
22986:
22987: /*INVCONV ,*/
22988: IF (l_debug = 1) THEN
22989: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
22990: END IF;
22991:
22992: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
22993: x_return_status => x_return_status

Line 22992: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

22988: IF (l_debug = 1) THEN
22989: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
22990: END IF;
22991:
22992: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
22993: x_return_status => x_return_status
22994: ,x_msg_data => x_msg_data
22995: ,x_msg_count => x_msg_count
22996: ,p_api_version => 1.0

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

23019: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
23020: );
23021: /*INVCONV ,*/
23022: IF (l_debug = 1) THEN
23023: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23024: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23025: END IF;
23026:
23027: IF (x_return_status <> 'S') THEN

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

23020: );
23021: /*INVCONV ,*/
23022: IF (l_debug = 1) THEN
23023: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
23024: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
23025: END IF;
23026:
23027: IF (x_return_status <> 'S') THEN
23028: --raise error

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

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

Line 23038: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

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

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

23058: ,p_mtlt_rowid => L_MTLT_REC.ROWID
23059: );
23060: /*INVCONV ,*/
23061: IF (l_debug = 1) THEN
23062: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23063: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
23064: END IF;
23065:
23066: IF X_RETURN_STATUS <> 'S' THEN

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

23059: );
23060: /*INVCONV ,*/
23061: IF (l_debug = 1) THEN
23062: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
23063: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
23064: END IF;
23065:
23066: IF X_RETURN_STATUS <> 'S' THEN
23067: --RAISE ERROR

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

24270: );
24271:
24272: */
24273: IF (l_debug = 1) THEN
24274: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24275: END IF;
24276:
24277: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24278: x_return_status => x_return_status

Line 24277: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24273: IF (l_debug = 1) THEN
24274: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24275: END IF;
24276:
24277: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24278: x_return_status => x_return_status
24279: ,x_msg_data => x_msg_data
24280: ,x_msg_count => x_msg_count
24281: ,p_api_version => 1.0

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

24305: );
24306:
24307: /*INVCONV ,*/
24308: IF (l_debug = 1) THEN
24309: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24310: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24311: END IF;
24312:
24313: IF X_RETURN_STATUS <> 'S' THEN

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

24306:
24307: /*INVCONV ,*/
24308: IF (l_debug = 1) THEN
24309: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24310: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24311: END IF;
24312:
24313: IF X_RETURN_STATUS <> 'S' THEN
24314: --RAISE ERROR

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

24348: x_msg_count => x_msg_count
24349: );
24350: */
24351: IF (l_debug = 1) THEN
24352: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24353: END IF;
24354:
24355: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24356: x_return_status => x_return_status

Line 24355: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24351: IF (l_debug = 1) THEN
24352: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24353: END IF;
24354:
24355: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24356: x_return_status => x_return_status
24357: ,x_msg_data => x_msg_data
24358: ,x_msg_count => x_msg_count
24359: ,p_api_version => 1.0

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

24383: );
24384:
24385: /*INVCONV ,*/
24386: IF (l_debug = 1) THEN
24387: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24388: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24389: END IF;
24390:
24391: IF X_RETURN_STATUS <> 'S' THEN

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

24384:
24385: /*INVCONV ,*/
24386: IF (l_debug = 1) THEN
24387: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24388: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24389: END IF;
24390:
24391: IF X_RETURN_STATUS <> 'S' THEN
24392: --RAISE ERROR

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

24494: x_msg_count => x_msg_count
24495: );
24496: */
24497: IF (l_debug = 1) THEN
24498: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24499: END IF;
24500:
24501: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24502: x_return_status => x_return_status

Line 24501: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24497: IF (l_debug = 1) THEN
24498: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24499: END IF;
24500:
24501: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24502: x_return_status => x_return_status
24503: ,x_msg_data => x_msg_data
24504: ,x_msg_count => x_msg_count
24505: ,p_api_version => 1.0

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

24528: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
24529: );
24530:
24531: IF (l_debug = 1) THEN
24532: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24533: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24534: END IF;
24535:
24536: IF X_RETURN_STATUS <> 'S' THEN

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

24529: );
24530:
24531: IF (l_debug = 1) THEN
24532: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24533: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24534: END IF;
24535:
24536: IF X_RETURN_STATUS <> 'S' THEN
24537: --RAISE ERROR

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

24588: x_msg_count => x_msg_count
24589: );
24590: */
24591: IF (l_debug = 1) THEN
24592: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24593: END IF;
24594:
24595: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24596: x_return_status => x_return_status

Line 24595: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24591: IF (l_debug = 1) THEN
24592: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24593: END IF;
24594:
24595: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24596: x_return_status => x_return_status
24597: ,x_msg_data => x_msg_data
24598: ,x_msg_count => x_msg_count
24599: ,p_api_version => 1.0

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

24622: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
24623: );
24624:
24625: IF (l_debug = 1) THEN
24626: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24627: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24628: END IF;
24629:
24630: IF X_RETURN_STATUS <> 'S' THEN

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

24623: );
24624:
24625: IF (l_debug = 1) THEN
24626: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24627: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24628: END IF;
24629:
24630: IF X_RETURN_STATUS <> 'S' THEN
24631: --RAISE ERROR

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

24732: x_msg_data => x_msg_data,
24733: x_msg_count => x_msg_count
24734: );*/
24735: IF (l_debug = 1) THEN
24736: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24737: END IF;
24738:
24739: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24740: x_return_status => x_return_status

Line 24739: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24735: IF (l_debug = 1) THEN
24736: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24737: END IF;
24738:
24739: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24740: x_return_status => x_return_status
24741: ,x_msg_data => x_msg_data
24742: ,x_msg_count => x_msg_count
24743: ,p_api_version => 1.0

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

24767: );
24768:
24769: /*INVCONV ,*/
24770: IF (l_debug = 1) THEN
24771: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24772: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24773: END IF;
24774:
24775: IF X_RETURN_STATUS <> 'S' THEN

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

24768:
24769: /*INVCONV ,*/
24770: IF (l_debug = 1) THEN
24771: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24772: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24773: END IF;
24774:
24775: IF X_RETURN_STATUS <> 'S' THEN
24776: --RAISE ERROR

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

24789: IF (l_grand_parent_txn_type = 'DELIVER') THEN
24790: -- opm change bug# 3061052
24791: /* INVCONV, replace the existing create_inv_lot call with a new call */
24792: /*INVCONV , Perform lot validations and create the new lot.
24793: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
24794: This shall also create lot specific conversions after creating the new Lot.
24795: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT */
24796:
24797: IF (l_debug = 1) THEN

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

24794: This shall also create lot specific conversions after creating the new Lot.
24795: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT */
24796:
24797: IF (l_debug = 1) THEN
24798: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24799: END IF;
24800:
24801: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24802: x_return_status => x_return_status

Line 24801: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24797: IF (l_debug = 1) THEN
24798: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24799: END IF;
24800:
24801: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24802: x_return_status => x_return_status
24803: ,x_msg_data => x_msg_data
24804: ,x_msg_count => x_msg_count
24805: ,p_api_version => 1.0

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

24828: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
24829: );
24830:
24831: IF (l_debug = 1) THEN
24832: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24833: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24834: END IF;
24835:
24836: IF (x_return_status <> 'S') THEN

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

24829: );
24830:
24831: IF (l_debug = 1) THEN
24832: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24833: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24834: END IF;
24835:
24836: IF (x_return_status <> 'S') THEN
24837: --raise error

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

24840: END IF;
24841:
24842: /*INVCONV ,*/
24843: IF (l_debug = 1) THEN
24844: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24845: END IF;
24846:
24847: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
24848: x_return_status => x_return_status

Line 24847: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

24843: IF (l_debug = 1) THEN
24844: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24845: END IF;
24846:
24847: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
24848: x_return_status => x_return_status
24849: ,x_msg_count => x_msg_count
24850: ,x_msg_data => x_msg_data
24851: ,p_api_version => 1.0

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

24868: );
24869:
24870: /*INVCONV ,*/
24871: IF (l_debug = 1) THEN
24872: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24873: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24874: END IF;
24875:
24876: IF X_RETURN_STATUS <> 'S' THEN

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

24869:
24870: /*INVCONV ,*/
24871: IF (l_debug = 1) THEN
24872: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24873: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24874: END IF;
24875:
24876: IF X_RETURN_STATUS <> 'S' THEN
24877: --RAISE ERROR

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

24893: END IF;
24894:
24895: /*INVCONV, Replace existing create lot call with a new call */
24896: IF (l_debug = 1) THEN
24897: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24898: END IF;
24899:
24900: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24901: x_return_status => x_return_status

Line 24900: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24896: IF (l_debug = 1) THEN
24897: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24898: END IF;
24899:
24900: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
24901: x_return_status => x_return_status
24902: ,x_msg_data => x_msg_data
24903: ,x_msg_count => x_msg_count
24904: ,p_api_version => 1.0

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

24927: ,p_lot_primary_qty => l_mtlt_rec.primary_quantity -- Bug# 4233182
24928: );
24929:
24930: IF (l_debug = 1) THEN
24931: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24932: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24933: END IF;
24934:
24935: IF (x_return_status <> 'S') THEN

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

24928: );
24929:
24930: IF (l_debug = 1) THEN
24931: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
24932: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
24933: END IF;
24934:
24935: IF (x_return_status <> 'S') THEN
24936: --raise error

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

24938: RAISE fnd_api.g_exc_error;
24939: END IF;
24940:
24941: IF (l_debug = 1) THEN
24942: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24943: END IF;
24944:
24945: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
24946: x_return_status => x_return_status

Line 24945: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

24941: IF (l_debug = 1) THEN
24942: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24943: END IF;
24944:
24945: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
24946: x_return_status => x_return_status
24947: ,x_msg_count => x_msg_count
24948: ,x_msg_data => x_msg_data
24949: ,p_api_version => 1.0

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

24966: );
24967:
24968: /*INVCONV ,*/
24969: IF (l_debug = 1) THEN
24970: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24971: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24972: END IF;
24973:
24974:

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

24967:
24968: /*INVCONV ,*/
24969: IF (l_debug = 1) THEN
24970: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
24971: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
24972: END IF;
24973:
24974:
24975: IF X_RETURN_STATUS <> 'S' THEN

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

24991: ELSE
24992: --CALL CREATE_INV_LOT
24993: /* INVCONV, replace the existing create_inv_lot call with a new call */
24994: /*INVCONV , Perform lot validations and create the new lot.
24995: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
24996: This shall also create lot specific conversions after creating the new Lot.
24997: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT*/
24998:
24999: IF (l_debug = 1) THEN

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

24996: This shall also create lot specific conversions after creating the new Lot.
24997: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT*/
24998:
24999: IF (l_debug = 1) THEN
25000: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
25001: END IF;
25002:
25003: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
25004: x_return_status => x_return_status

Line 25003: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

24999: IF (l_debug = 1) THEN
25000: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
25001: END IF;
25002:
25003: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
25004: x_return_status => x_return_status
25005: ,x_msg_data => x_msg_data
25006: ,x_msg_count => x_msg_count
25007: ,p_api_version => 1.0

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

25031: );
25032:
25033: /*INVCONV ,*/
25034: IF (l_debug = 1) THEN
25035: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
25036: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
25037: END IF;
25038:
25039: IF (x_return_status <> 'S') THEN

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

25032:
25033: /*INVCONV ,*/
25034: IF (l_debug = 1) THEN
25035: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
25036: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
25037: END IF;
25038:
25039: IF (x_return_status <> 'S') THEN
25040: --raise error

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

25042: RAISE fnd_api.g_exc_error;
25043: END IF;
25044:
25045: IF (l_debug = 1) THEN
25046: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
25047: END IF;
25048:
25049: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
25050: x_return_status => x_return_status

Line 25049: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

25045: IF (l_debug = 1) THEN
25046: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
25047: END IF;
25048:
25049: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
25050: x_return_status => x_return_status
25051: ,x_msg_count => x_msg_count
25052: ,x_msg_data => x_msg_data
25053: ,p_api_version => 1.0

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

25070: );
25071:
25072: /*INVCONV ,*/
25073: IF (l_debug = 1) THEN
25074: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
25075: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
25076: END IF;
25077:
25078: IF X_RETURN_STATUS <> 'S' THEN

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

25071:
25072: /*INVCONV ,*/
25073: IF (l_debug = 1) THEN
25074: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
25075: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
25076: END IF;
25077:
25078: IF X_RETURN_STATUS <> 'S' THEN
25079: --RAISE ERROR

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

26848: x_msg_count => x_msg_count
26849: );*/
26850:
26851: IF (l_debug = 1) THEN
26852: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26853: END IF;
26854:
26855: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26856: x_return_status => x_return_status

Line 26855: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

26851: IF (l_debug = 1) THEN
26852: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26853: END IF;
26854:
26855: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26856: x_return_status => x_return_status
26857: ,x_msg_data => x_msg_data
26858: ,x_msg_count => x_msg_count
26859: ,p_api_version => 1.0

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

26883: );
26884:
26885: /*INVCONV ,*/
26886: IF (l_debug = 1) THEN
26887: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26888: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26889: END IF;
26890:
26891: IF X_RETURN_STATUS <> 'S' THEN

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

26884:
26885: /*INVCONV ,*/
26886: IF (l_debug = 1) THEN
26887: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26888: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
26889: END IF;
26890:
26891: IF X_RETURN_STATUS <> 'S' THEN
26892: --RAISE ERROR

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

26967: x_msg_data => x_msg_data,
26968: x_msg_count => x_msg_count
26969: );*/
26970: IF (l_debug = 1) THEN
26971: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26972: END IF;
26973:
26974: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26975: x_return_status => x_return_status

Line 26974: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

26970: IF (l_debug = 1) THEN
26971: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
26972: END IF;
26973:
26974: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
26975: x_return_status => x_return_status
26976: ,x_msg_data => x_msg_data
26977: ,x_msg_count => x_msg_count
26978: ,p_api_version => 1.0

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

27002: );
27003:
27004: /*INVCONV ,*/
27005: IF (l_debug = 1) THEN
27006: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27007: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
27008: END IF;
27009:
27010: IF X_RETURN_STATUS <> 'S' THEN

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

27003:
27004: /*INVCONV ,*/
27005: IF (l_debug = 1) THEN
27006: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27007: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
27008: END IF;
27009:
27010: IF X_RETURN_STATUS <> 'S' THEN
27011: --RAISE ERROR

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

27155: x_msg_data => x_msg_data,
27156: x_msg_count => x_msg_count
27157: );*/
27158: IF (l_debug = 1) THEN
27159: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27160: END IF;
27161:
27162: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
27163: x_return_status => x_return_status

Line 27162: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

27158: IF (l_debug = 1) THEN
27159: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27160: END IF;
27161:
27162: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
27163: x_return_status => x_return_status
27164: ,x_msg_data => x_msg_data
27165: ,x_msg_count => x_msg_count
27166: ,p_api_version => 1.0

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

27191:
27192:
27193: /*INVCONV ,*/
27194: IF (l_debug = 1) THEN
27195: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27196: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
27197: END IF;
27198:
27199: IF X_RETURN_STATUS <> 'S' THEN

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

27192:
27193: /*INVCONV ,*/
27194: IF (l_debug = 1) THEN
27195: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27196: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
27197: END IF;
27198:
27199: IF X_RETURN_STATUS <> 'S' THEN
27200: --RAISE ERROR

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

27213: IF (l_discrete_transaction) THEN */
27214: --call CREATE_INV_LOT
27215:
27216: /*INVCONV , Perform lot validations and create the new lot.
27217: Call Lot Create API INV_ROI_INTEGRATION_GRP.INV_NEW_LOT to create the new lot.
27218: This shall also create lot specific conversions after creating the new Lot.
27219: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
27220: Punit Kumar*/
27221:

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

27219: This replaces the existing procedure INV_LOT_API_PUB.CREATE_INV_LOT to create NEW LOT
27220: Punit Kumar*/
27221:
27222: IF (l_debug = 1) THEN
27223: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27224: END IF;
27225:
27226: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
27227: x_return_status => x_return_status

Line 27226: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(

27222: IF (l_debug = 1) THEN
27223: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27224: END IF;
27225:
27226: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT(
27227: x_return_status => x_return_status
27228: ,x_msg_data => x_msg_data
27229: ,x_msg_count => x_msg_count
27230: ,p_api_version => 1.0

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

27254: );
27255:
27256: /*INVCONV ,*/
27257: IF (l_debug = 1) THEN
27258: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27259: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
27260: END IF;
27261:
27262: IF (x_return_status <> 'S') THEN

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

27255:
27256: /*INVCONV ,*/
27257: IF (l_debug = 1) THEN
27258: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT :'||l_progress,1);
27259: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT return status: '||x_return_status||' : '||l_progress, 1);
27260: END IF;
27261:
27262: IF (x_return_status <> 'S') THEN
27263: --raise error

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

27266: END IF;
27267:
27268: /*INVCONV ,*/
27269: IF (l_debug = 1) THEN
27270: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
27271: END IF;
27272:
27273: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
27274: x_return_status => x_return_status

Line 27273: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(

27269: IF (l_debug = 1) THEN
27270: print_debug('INVCONV, Before calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
27271: END IF;
27272:
27273: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT(
27274: x_return_status => x_return_status
27275: ,x_msg_count => x_msg_count
27276: ,x_msg_data => x_msg_data
27277: ,p_api_version => 1.0

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

27294: );
27295:
27296: /*INVCONV ,*/
27297: IF (l_debug = 1) THEN
27298: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
27299: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
27300: END IF;
27301:
27302: IF X_RETURN_STATUS <> 'S' THEN

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

27295:
27296: /*INVCONV ,*/
27297: IF (l_debug = 1) THEN
27298: print_debug('INVCONV, After calling INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'||l_progress,1);
27299: print_debug('INVCONV,VALIDATE_LOT_SERIAL_INFO: INV_ROI_INTEGRATION_GRP.INV_NEW_LOT return status: '||x_return_status||' : '||l_progress, 1);
27300: END IF;
27301:
27302: IF X_RETURN_STATUS <> 'S' THEN
27303: --RAISE ERROR