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_ROI_INTEGRATION_GRP dependencies on INV_CONVERT

Line 396: l_rma_quantity := INV_CONVERT.inv_um_convert(

392: WHERE INVENTORY_ITEM_ID = p_item_id
393: AND organization_id = p_to_organization_id;
394:
395: IF Nvl(l_rma_unit_of_measure,-1) <> Nvl(l_pri_unit_of_measure,-1) THEN
396: l_rma_quantity := INV_CONVERT.inv_um_convert(
397: item_id => p_item_id ,
398: lot_number => p_lot_number ,
399: organization_id => p_to_organization_id ,
400: precision => 5 ,

Line 833: l_lot_qty := INV_CONVERT.inv_um_convert(

829: l_progress := '102';
830:
831: /* Convert transaction qty in p_transaction_unit_of_measure to l_pmy_unit_of_meas */
832: /*I
833: l_lot_qty := INV_CONVERT.inv_um_convert(
834: item_id => p_item_id ,
835: lot_number => p_lot_number ,
836: organization_id => p_to_organization_id ,
837: precision => 5 ,

Line 846: print_debug('Program INV_CONVERT.inv_um_convert return: ' || l_progress, 9);

842: to_name => l_pmy_unit_of_meas
843: );
844:
845: IF g_debug = 1 THEN
846: print_debug('Program INV_CONVERT.inv_um_convert return: ' || l_progress, 9);
847: print_debug('l_lot_qty: ' || l_lot_qty, 9);
848: END IF;
849:
850: l_progress := '103';

Line 855: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);

851:
852: IF l_lot_qty = -99999 THEN
853:
854: IF g_debug = 1 THEN
855: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
856: END IF;
857:
858: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
859: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

Line 859: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

855: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
856: END IF;
857:
858: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
859: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
860: fnd_msg_pub.ADD;
861:
862: RAISE g_exc_unexpected_error;
863: END IF;

Line 936: print_debug('Before calling INV_CONVERT.Within_deviation ' || l_progress, 1);

932:
933: l_progress := '013' ;
934:
935: IF g_debug = 1 THEN
936: print_debug('Before calling INV_CONVERT.Within_deviation ' || l_progress, 1);
937: print_debug('p_quantity ' || p_lot_quantity, 1);
938: print_debug('p_quantity2 ' || l_lot_secondary_quantity, 1);
939: print_debug('p_unit_of_measure1 ' || p_transaction_unit_of_measure, 1);
940: print_debug('p_unit_of_measure2 ' || p_secondary_unit_of_measure, 1);

Line 949: l_lot_secondary_quantity:= INV_CONVERT.inv_um_convert (

945: END IF;
946:
947: /* Bug 5365360 for a fixed type of item just recompute the lot secondary quantity)*/
948: IF (INV_CACHE.item_rec.secondary_default_ind = 'F') THEN
949: l_lot_secondary_quantity:= INV_CONVERT.inv_um_convert (
950: item_id => p_item_id
951: ,
952: lot_number => p_lot_number
953: ,

Line 993: l_deviation_check := INV_CONVERT.Within_deviation(

989:
990:
991: ELSE
992:
993: l_deviation_check := INV_CONVERT.Within_deviation(
994: p_organization_id => p_to_organization_id ,
995: p_inventory_item_id => p_item_id ,
996: p_lot_number => p_lot_number ,
997: p_precision => 5 ,

Line 1010: print_debug('Program INV_CONVERT.Within_deviation return ' || l_progress, 1);

1006:
1007: /*RETURN Number , 1 for True and 0 for False */
1008:
1009: IF g_debug = 1 THEN
1010: print_debug('Program INV_CONVERT.Within_deviation return ' || l_progress, 1);
1011: END IF;
1012: END IF;
1013:
1014:

Line 1019: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 1);

1015: l_progress := '014';
1016:
1017: IF l_deviation_check = 0 THEN
1018: IF g_debug = 1 THEN
1019: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 1);
1020: END IF;
1021: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1023: fnd_msg_pub.ADD;

Line 1022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');

1018: IF g_debug = 1 THEN
1019: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 1);
1020: END IF;
1021: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1023: fnd_msg_pub.ADD;
1024: RAISE g_exc_unexpected_error;
1025: END IF;
1026:

Line 1032: print_debug('Before calling INV_CONVERT.inv_um_convert ' || l_progress, 1);

1028:
1029: l_progress := '015';
1030:
1031: IF g_debug = 1 THEN
1032: print_debug('Before calling INV_CONVERT.inv_um_convert ' || l_progress, 1);
1033: print_debug('from_quantity ' || p_lot_quantity, 1);
1034: print_debug('from_unit ' || l_from_unit, 1);
1035: print_debug('to_unit ' || l_to_unit, 1);
1036: print_debug('from_name ' || p_transaction_unit_of_measure, 1);

Line 1041: l_lot_secondary_quantity:= INV_CONVERT.inv_um_convert (

1037: print_debug('to_name ' || p_secondary_unit_of_measure, 1);
1038: END IF;
1039:
1040:
1041: l_lot_secondary_quantity:= INV_CONVERT.inv_um_convert (
1042: item_id => p_item_id ,
1043: lot_number => p_lot_number ,
1044: organization_id => p_to_organization_id ,
1045: precision => 5 ,

Line 1054: print_debug('Program INV_CONVERT.inv_um_convert return: ' || l_progress, 9);

1050: to_name => p_secondary_unit_of_measure
1051: );
1052:
1053: IF g_debug = 1 THEN
1054: print_debug('Program INV_CONVERT.inv_um_convert return: ' || l_progress, 9);
1055: print_debug('l_lot_secondary_quantity: ' || l_lot_secondary_quantity, 9);
1056: END IF;
1057:
1058: l_progress := '016';

Line 1062: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);

1058: l_progress := '016';
1059:
1060: IF l_lot_secondary_quantity = -99999 THEN
1061: IF g_debug = 1 THEN
1062: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
1063: END IF;
1064: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1065: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1066: fnd_msg_pub.ADD;

Line 1065: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

1061: IF g_debug = 1 THEN
1062: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
1063: END IF;
1064: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1065: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1066: fnd_msg_pub.ADD;
1067:
1068: RAISE g_exc_unexpected_error;
1069: END IF;

Line 1143: print_debug('Before calling INV_CONVERT.Within_deviation ' || l_progress, 1);

1139: IF l_lot_secondary_quantity IS NOT NULL THEN
1140: ---Validate the secondary quantity
1141:
1142: IF g_debug = 1 THEN
1143: print_debug('Before calling INV_CONVERT.Within_deviation ' || l_progress, 1);
1144: print_debug('p_quantity ' || p_lot_quantity, 1);
1145: print_debug('p_quantity2 ' || l_lot_secondary_quantity, 1);
1146: print_debug('p_unit_of_measure1 ' || p_transaction_unit_of_measure, 1);
1147: print_debug('p_unit_of_measure2 ' || p_secondary_unit_of_measure, 1);

Line 1156: l_lot_secondary_quantity:= INV_CONVERT.inv_um_convert (

1152: END IF;
1153:
1154: /* Bug 5365360 for a fixed type of item just recompute the lot secondary quantity)*/
1155: IF (INV_CACHE.item_rec.secondary_default_ind = 'F') THEN
1156: l_lot_secondary_quantity:= INV_CONVERT.inv_um_convert (
1157: item_id => p_item_id ,
1158: lot_number => p_lot_number ,
1159: organization_id => p_to_organization_id ,
1160: precision => 5 ,

Line 1198: l_deviation_check := INV_CONVERT.Within_deviation(

1194: ELSE
1195:
1196:
1197: ---Do item level deviation check
1198: l_deviation_check := INV_CONVERT.Within_deviation(
1199: p_organization_id => p_to_organization_id ,
1200: p_inventory_item_id => p_item_id ,
1201: p_lot_number => p_lot_number ,---new lot number
1202: p_precision => 5 ,

Line 1216: print_debug('Program INV_CONVERT.Within_deviation return ' || l_progress, 1);

1212:
1213: /*RETURN Number , 1 for True and 0 for False */
1214:
1215: IF g_debug = 1 THEN
1216: print_debug('Program INV_CONVERT.Within_deviation return ' || l_progress, 1);
1217: END IF;
1218:
1219: IF l_deviation_check = 0 THEN
1220: IF g_debug = 1 THEN

Line 1221: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 9);

1217: END IF;
1218:
1219: IF l_deviation_check = 0 THEN
1220: IF g_debug = 1 THEN
1221: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 9);
1222: END IF;
1223: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1224: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1225: fnd_msg_pub.ADD;

Line 1224: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');

1220: IF g_debug = 1 THEN
1221: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 9);
1222: END IF;
1223: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1224: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1225: fnd_msg_pub.ADD;
1226: RAISE g_exc_error;
1227: END IF;
1228:

Line 1234: print_debug('Before calling INV_CONVERT.inv_um_convert ' || l_progress, 1);

1230:
1231: ELSE -----if l_lot_secondary_quantity is NULL
1232:
1233: IF g_debug = 1 THEN
1234: print_debug('Before calling INV_CONVERT.inv_um_convert ' || l_progress, 1);
1235: print_debug('from_quantity ' || p_lot_quantity, 1);
1236: print_debug('from_unit ' || l_from_unit, 1);
1237: print_debug('to_unit ' || l_to_unit, 1);
1238: print_debug('from_name ' || p_transaction_unit_of_measure, 1);

Line 1243: l_lot_secondary_quantity:= INV_CONVERT.Inv_um_convert(

1239: print_debug('to_name ' || p_secondary_unit_of_measure, 1);
1240: END IF;
1241:
1242: ---Default the secondary quantity.
1243: l_lot_secondary_quantity:= INV_CONVERT.Inv_um_convert(
1244: item_id => p_item_id ,
1245: lot_number => p_lot_number,----new lot number
1246: organization_id => p_to_organization_id ,
1247: precision => 5 ,

Line 1257: print_debug('Program INV_CONVERT.inv_um_convert return: '||l_progress , 1);

1253: );
1254: l_progress :='021';
1255:
1256: IF g_debug = 1 THEN
1257: print_debug('Program INV_CONVERT.inv_um_convert return: '||l_progress , 1);
1258: END IF;
1259:
1260: IF l_lot_secondary_quantity = -99999 THEN
1261: IF g_debug = 1 THEN

Line 1262: print_debug('INV_CONVERT.inv_um_convert has failed'|| l_progress, 9);

1258: END IF;
1259:
1260: IF l_lot_secondary_quantity = -99999 THEN
1261: IF g_debug = 1 THEN
1262: print_debug('INV_CONVERT.inv_um_convert has failed'|| l_progress, 9);
1263: END IF;
1264: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1265: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1266: fnd_msg_pub.ADD;

Line 1265: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

1261: IF g_debug = 1 THEN
1262: print_debug('INV_CONVERT.inv_um_convert has failed'|| l_progress, 9);
1263: END IF;
1264: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1265: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1266: fnd_msg_pub.ADD;
1267: RAISE g_exc_unexpected_error;
1268: END IF;
1269:

Line 2109: INV_CONVERT.inv_um_conversion(

2105: all of these situations and will do the appropriate business rule validations.*/
2106:
2107: /* Fetching the conversion rate */
2108: /*
2109: INV_CONVERT.inv_um_conversion(
2110: from_unit =>p_lot_uom_conv_rec.FROM_UOM_CODE,
2111: to_unit =>p_lot_uom_conv_rec.TO_UOM_CODE,
2112: item_id =>p_lot_uom_conv_rec.INVENTORY_ITEM_ID,
2113: lot_number =>p_lot_uom_conv_rec.LOT_NUMBER,

Line 2461: l_rti_sourcedoc_quantity := INV_CONVERT.inv_um_convert(

2457: in p_rti_unit_of_measure (RTI.UNIT_OF_MEASURE )for each lot of that item into
2458: RTI.SOURCE_DOC_UNIT_OF_MEASURE taking lot specific conversion into consideration */
2459:
2460:
2461: l_rti_sourcedoc_quantity := INV_CONVERT.inv_um_convert(
2462: item_id => p_inventory_item_id ,
2463: lot_number => p_lot_number ,
2464: organization_id => p_to_organization_id ,
2465: precision => 5 ,

Line 2476: print_debug('Program INV_CONVERT.inv_um_convert return :' ||l_progress , 1);

2472:
2473: l_progress :='040';
2474:
2475: IF g_debug = 1 THEN
2476: print_debug('Program INV_CONVERT.inv_um_convert return :' ||l_progress , 1);
2477: print_debug('l_rti_sourcedoc_quantity :' ||l_rti_sourcedoc_quantity , 1);
2478: END IF;
2479:
2480: IF l_rti_sourcedoc_quantity = -99999 THEN

Line 2482: print_debug('INV_CONVERT.inv_um_convert has failed in inv_synch_quantities:'|| l_progress, 1);

2478: END IF;
2479:
2480: IF l_rti_sourcedoc_quantity = -99999 THEN
2481: IF g_debug = 1 THEN
2482: print_debug('INV_CONVERT.inv_um_convert has failed in inv_synch_quantities:'|| l_progress, 1);
2483: END IF;
2484: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2485: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
2486: fnd_msg_pub.ADD;

Line 2485: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

2481: IF g_debug = 1 THEN
2482: print_debug('INV_CONVERT.inv_um_convert has failed in inv_synch_quantities:'|| l_progress, 1);
2483: END IF;
2484: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2485: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
2486: fnd_msg_pub.ADD;
2487: RAISE g_exc_unexpected_error;
2488: END IF;
2489:

Line 2996: l_trx_quantity := INV_CONVERT.inv_um_convert(

2992: print_debug('l_trx_unit_of_measure <> l_lot_recv_unit_of_measure :' ||l_progress, 1);
2993: END IF;
2994:
2995:
2996: l_trx_quantity := INV_CONVERT.inv_um_convert(
2997: item_id => p_item_id ,
2998: lot_number => p_lot_number ,
2999: organization_id => p_to_organization_id ,
3000: precision => l_precision ,

Line 3010: print_debug('Program INV_CONVERT.inv_um_convert return: ' || l_return_status||':'||l_progress, 1);

3006: );
3007:
3008: IF g_debug = 1 THEN
3009: print_debug('quantity when l_trx_unit_of_measure <> l_lot_recv_unit_of_measure is :'|| l_trx_quantity ,1);
3010: print_debug('Program INV_CONVERT.inv_um_convert return: ' || l_return_status||':'||l_progress, 1);
3011: END IF;
3012:
3013:
3014: IF l_trx_quantity = -99999 THEN

Line 3019: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 1);

3015:
3016: l_progress := '070';
3017:
3018: IF g_debug = 1 THEN
3019: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 1);
3020: END IF;
3021: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
3023: fnd_msg_pub.ADD;

Line 3022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

3018: IF g_debug = 1 THEN
3019: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 1);
3020: END IF;
3021: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
3023: fnd_msg_pub.ADD;
3024: RAISE g_exc_unexpected_error;
3025: END IF;
3026:

Line 3042: l_rma_quantity := INV_CONVERT.inv_um_convert(

3038: IF g_debug = 1 THEN
3039: print_debug('l_rma_lot_unit_of_measure <> l_lot_recv_unit_of_measure :' ||l_progress, 1);
3040: END IF;
3041:
3042: l_rma_quantity := INV_CONVERT.inv_um_convert(
3043: item_id => p_item_id ,
3044: lot_number => p_lot_number ,
3045: organization_id => p_to_organization_id ,
3046: precision => 5 ,

Line 3056: print_debug('Program INV_CONVERT.inv_um_convert return: ' ||l_progress, 1);

3052: );
3053:
3054: IF g_debug = 1 THEN
3055: print_debug('quantity when l_rma_lot_unit_of_measure <> l_lot_recv_unit_of_measure is :'|| l_rma_quantity ,1);
3056: print_debug('Program INV_CONVERT.inv_um_convert return: ' ||l_progress, 1);
3057: END IF;
3058:
3059:
3060: IF l_rma_quantity = -99999 THEN

Line 3065: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 9);

3061:
3062: l_progress :='072';
3063:
3064: IF g_debug = 1 THEN
3065: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 9);
3066: END IF;
3067: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3068: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
3069: fnd_msg_pub.ADD;

Line 3068: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');

3064: IF g_debug = 1 THEN
3065: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 9);
3066: END IF;
3067: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3068: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
3069: fnd_msg_pub.ADD;
3070: RAISE g_exc_unexpected_error;
3071: END IF;
3072:

Line 3096: X_allowed_quantity:= INV_CONVERT.inv_um_convert(

3092: IF l_trx_unit_of_measure <> l_lot_recv_unit_of_measure THEN
3093:
3094: l_progress := '074';
3095:
3096: X_allowed_quantity:= INV_CONVERT.inv_um_convert(
3097: item_id => p_item_id ,
3098: lot_number => p_lot_number ,
3099: organization_id => p_to_organization_id ,
3100: precision => 5 ,

Line 3109: print_debug('Program INV_CONVERT.inv_um_convert return ' || l_progress, 1);

3105: to_name => l_trx_unit_of_measure
3106: );
3107: IF g_debug = 1 THEN
3108: print_debug('x_allowed_quantity when l_trx_unit_of_measure <> l_lot_recv_unit_of_measure is :'|| X_allowed_quantity ,1);
3109: print_debug('Program INV_CONVERT.inv_um_convert return ' || l_progress, 1);
3110: END IF;
3111:
3112: IF X_allowed_quantity = -99999 THEN
3113: l_progress := '075';

Line 3116: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'|| l_progress, 1);

3112: IF X_allowed_quantity = -99999 THEN
3113: l_progress := '075';
3114:
3115: IF g_debug = 1 THEN
3116: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'|| l_progress, 1);
3117: END IF;
3118: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3119: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');
3120: fnd_msg_pub.ADD;