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 874: inv_validate.number_from_sequence(l_msnt.fm_serial_number, l_temp_prefix, l_from_ser_number);

870: ' to_serial_number = ' || l_msnt.to_serial_number,1);
871: END IF;
872:
873: l_progress := 'WMSINB-10677';
874: inv_validate.number_from_sequence(l_msnt.fm_serial_number, l_temp_prefix, l_from_ser_number);
875: l_progress := 'WMSINB-10679';
876: inv_validate.number_from_sequence(l_msnt.to_serial_number
877: ,l_temp_prefix
878: ,l_to_ser_number);

Line 876: inv_validate.number_from_sequence(l_msnt.to_serial_number

872:
873: l_progress := 'WMSINB-10677';
874: inv_validate.number_from_sequence(l_msnt.fm_serial_number, l_temp_prefix, l_from_ser_number);
875: l_progress := 'WMSINB-10679';
876: inv_validate.number_from_sequence(l_msnt.to_serial_number
877: ,l_temp_prefix
878: ,l_to_ser_number);
879: l_progress := 'WMSINB-10683';
880: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;

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

17846: l_remaining_serial_qty := l_remaining_serial_qty
17847: - l_serial_quantity;
17848: ELSE
17849: -- split the msni row
17850: inv_validate.number_from_sequence(l_msni_rec.fm_serial_number, l_temp_prefix, l_from_ser_number);
17851:
17852: l_new_to_ser_num :=
17853: SUBSTR(l_msni_rec.fm_serial_number, 1,
17854: LENGTH(l_msni_rec.fm_serial_number) -

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

17997: l_remaining_quantity := l_remaining_quantity -
17998: l_serial_quantity;
17999: ELSE
18000: -- split msni
18001: inv_validate.number_from_sequence(l_msni_rec.fm_serial_number, l_temp_prefix, l_from_ser_number);
18002:
18003: IF (l_debug = 1) THEN
18004: print_debug('split_lot_serial:242: Almost ready to split msni ', 1);
18005: END If;

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 19964: /*INVCONV , Removing the process specific call. Shall call a new procedure INV_VALIDATE_LOT

19960: l_progress := 'WMSINB-22290';
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

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 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 20376: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

20372:
20373: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
20374: l_serial_quantity;
20375:
20376: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
20377: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
20378:
20379: IF (l_debug = 1) THEN
20380: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

20373: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
20374: l_serial_quantity;
20375:
20376: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
20377: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
20378:
20379: IF (l_debug = 1) THEN
20380: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
20381: l_progress := 'WMSINB-22551';

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

21468:
21469: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
21470: l_serial_quantity;
21471:
21472: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
21473: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
21474:
21475: IF (l_debug = 1) THEN
21476: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

21469: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty +
21470: l_serial_quantity;
21471:
21472: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
21473: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
21474:
21475: IF (l_debug = 1) THEN
21476: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
21477: l_progress := 'WMSINB-23233';

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 22832: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

22828: RAISE fnd_api.g_exc_error;
22829: END IF;
22830:
22831: IF (l_debug = 1) THEN
22832: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
22833: END IF;
22834:
22835: /*END IF; --IF (l_discrete_transaction) THEN */
22836:

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 23103: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

23099: L_MSNT_REC.TO_SERIAL_NUMBER);
23100:
23101: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
23102:
23103: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
23104: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
23105:
23106: IF (l_debug = 1) THEN
23107: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

23100:
23101: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
23102:
23103: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
23104: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
23105:
23106: IF (l_debug = 1) THEN
23107: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
23108: l_progress := 'WMSINB-24127';

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

23553: L_MSNT_REC.TO_SERIAL_NUMBER);
23554:
23555: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
23556:
23557: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
23558: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
23559:
23560: IF (l_debug = 1) THEN
23561: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

23554:
23555: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
23556:
23557: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
23558: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
23559:
23560: IF (l_debug = 1) THEN
23561: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
23562: print_debug('VALIDATE_LOT_SERIAL_INFO: L_TEMP_PREFIX: '||L_TEMP_PREFIX, 1);

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 24320: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24316: RAISE fnd_api.g_exc_error;
24317: END IF;
24318:
24319: IF (l_debug = 1) THEN
24320: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24321: END IF;
24322: /*END IF; --IF (l_discrete_transaction) THEN*/
24323: ELSE --IF (l_grand_parent_txn_type = 'DELIVER') THEN
24324: IF (validate_rs(NULL,l_grand_parent_txn_id,l_dummy_lpn)) THEN

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 24398: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24394: RAISE fnd_api.g_exc_error;
24395: END IF;
24396:
24397: IF (l_debug = 1) THEN
24398: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24399: END IF;
24400: /*END IF; --IF (NOT l_discrete_transaction) THEN*/
24401:
24402: END IF; --IF (l_grand_parent_txn_type = 'DELIVER') THEN

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 24543: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24539: RAISE fnd_api.g_exc_error;
24540: END IF;
24541:
24542: IF (l_debug = 1) THEN
24543: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24544: END IF;
24545: /*END IF; --IF (l_discrete_transaction) THEN*/
24546:
24547: ELSE -- ELSIF (l_parent_txn_type = g_rtr)

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 24637: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24633: RAISE fnd_api.g_exc_error;
24634: END IF;
24635:
24636: IF (l_debug = 1) THEN
24637: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24638: END IF;
24639: /*END IF; --IF (NOT l_discrete_transaction) THEN*/
24640: ELSE --IF l_parent_txn_type <> 'DELIVER' THEN
24641:

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 24782: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24778: RAISE fnd_api.g_exc_error;
24779: END IF;
24780:
24781: IF (l_debug = 1) THEN
24782: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24783: END IF;
24784: /*END IF; -- IF (l_discrete_transaction) THEN*/
24785: END IF; --IF l_parent_txn_type <> 'DELIVER' THEN
24786: END IF; --IF (l_parent_txn_type IN (g_rtv, g_rtc)) 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 24883: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24879: RAISE fnd_api.g_exc_error;
24880: END IF;
24881:
24882: IF (l_debug = 1) THEN
24883: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24884: END IF;
24885: /*END IF; --IF (l_discrete_transaction) THEN*/
24886: ELSE --IF (l_grand_parent_txn_type = 'DELIVER') THEN
24887: IF (validate_rs(NULL,l_grand_parent_txn_id,l_dummy_lpn)) THEN

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 24982: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

24978: RAISE fnd_api.g_exc_error;
24979: END IF;
24980:
24981: IF (l_debug = 1) THEN
24982: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
24983: END IF;
24984: /*END IF; --IF (l_discrete_transaction) THEN*/
24985: END IF; --IF (l_grand_parent_txn_type = 'DELIVER') THEN
24986: ELSIF (l_parent_txn_type = g_rtr) THEN --IF (l_parent_txn_type IN (g_rtv,g_rtc)) 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 25085: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

25081: RAISE fnd_api.g_exc_error;
25082: END IF;
25083:
25084: IF (l_debug = 1) THEN
25085: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
25086: END IF;
25087: /* END IF ; -- IF (l_discrete_transaction) THEN*/
25088: END IF; ---- IF (lot_entered_on_parent(l_great_grand_parent_txn_id)) THEN
25089: /*the comment for above end if was wrong*/

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

25115: L_MSNT_REC.TO_SERIAL_NUMBER);
25116:
25117: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25118:
25119: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
25120: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
25121:
25122: IF (l_debug = 1) THEN
25123: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

25116:
25117: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25118:
25119: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
25120: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
25121:
25122: IF (l_debug = 1) THEN
25123: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
25124: l_progress := 'WMSINB-25398';

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

25892: L_SERIAL_QUANTITY := INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
25893: L_MSNT_REC.TO_SERIAL_NUMBER);
25894: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25895:
25896: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
25897: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
25898:
25899: IF (l_debug = 1) THEN
25900: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

25893: L_MSNT_REC.TO_SERIAL_NUMBER);
25894: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
25895:
25896: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
25897: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
25898:
25899: IF (l_debug = 1) THEN
25900: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
25901: l_progress := 'WMSINB-25907';

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 27017: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);

27013: RAISE fnd_api.g_exc_error;
27014: END IF;
27015:
27016: IF (l_debug = 1) THEN
27017: print_debug('VALIDATE_LOT_SERIAL_INFO: INV_VALIDATE_LOT STATUS: '||x_return_status||' : '||l_progress, 1);
27018: END IF;
27019: /*END IF; -- IF (l_discrete_transaction) THEN */
27020: ELSE --IF (l_lot_exists = 1) THEN
27021: --raise an 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 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 27336: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);

27332: L_NUM_MSNT_RECS := L_NUM_MSNT_RECS + 1;
27333: L_SERIAL_QUANTITY := INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
27334: L_MSNT_REC.TO_SERIAL_NUMBER);
27335: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
27336: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
27337: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
27338:
27339: IF (l_debug = 1) THEN
27340: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

27333: L_SERIAL_QUANTITY := INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
27334: L_MSNT_REC.TO_SERIAL_NUMBER);
27335: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
27336: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
27337: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
27338:
27339: IF (l_debug = 1) THEN
27340: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
27341: l_progress := 'WMSINB-26859';

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

28239: INV_SERIAL_NUMBER_PUB.GET_SERIAL_DIFF(L_MSNT_REC.FM_SERIAL_NUMBER,
28240: L_MSNT_REC.TO_SERIAL_NUMBER);
28241:
28242: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
28243: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
28244: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
28245:
28246: IF (l_debug = 1) THEN
28247: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);

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

28240: L_MSNT_REC.TO_SERIAL_NUMBER);
28241:
28242: l_tot_msnt_serial_qty := l_tot_msnt_serial_qty + l_serial_quantity;
28243: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.FM_SERIAL_NUMBER, L_TEMP_PREFIX, L_FROM_SER_NUMBER);
28244: INV_VALIDATE.NUMBER_FROM_SEQUENCE(L_MSNT_REC.TO_SERIAL_NUMBER, L_TEMP_PREFIX, L_TO_SER_NUMBER);
28245:
28246: IF (l_debug = 1) THEN
28247: print_debug('VALIDATE_LOT_SERIAL_INFO: SERIAL QUANTITY: '||l_serial_quantity||' : '||l_progress, 1);
28248: l_progress := 'WMSINB-27485';