[Home] [Help]
52: l_result VARCHAR2(30);
53: BEGIN
54: -- Standard call to check for call compatibility.
55: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
56: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
57: fnd_msg_pub.ADD;
58: RAISE fnd_api.g_exc_unexpected_error;
59: END IF;
60:
154: print_debug('SQL error: ' || SQLERRM(SQLCODE), 1);
155: END IF;
156: END IF;
157: x_return_status := fnd_api.g_ret_sts_error;
158: fnd_message.set_name('WMS', 'WMS_GET_CWT_ATTR_FAIL');
159: fnd_msg_pub.ADD;
160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
161: END Get_Catch_Weight_Attributes;
162:
179: l_ont_pricing_qty_source VARCHAR(30);
180: BEGIN
181: -- Standard call to check for call compatibility.
182: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
183: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
184: fnd_msg_pub.ADD;
185: RAISE fnd_api.g_exc_unexpected_error;
186: END IF;
187:
247: END IF;
248: END IF;
249:
250: x_return_status := fnd_api.g_ret_sts_error;
251: fnd_message.set_name('WMS', 'WMS_API_FAIL');
252: fnd_msg_pub.ADD;
253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
254: END Get_Ont_Pricing_Qty_Source;
255:
280: l_secondary_uom VARCHAR(3);
281: BEGIN
282: -- Standard call to check for call compatibility.
283: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
284: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
285: fnd_msg_pub.ADD;
286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:
350: IF ( x_secondary_uom_code IS NULL ) THEN
351: IF (l_debug = 1) THEN
352: print_debug('Secondary UOM is not defined for this secondary priced item', 1);
353: END IF;
354: fnd_message.set_name('WMS', 'WMS_SEC_UOM_UNDEF_ERROR');
355: fnd_msg_pub.ADD;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:
373: IF ( x_secondary_quantity < 0 ) THEN
374: IF ( l_debug = 1 ) THEN
375: print_debug('Error converting to from '||p_uom_code||' to '||x_secondary_uom_code, 1);
376: END IF;
377: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
378: fnd_message.set_token('uom1', p_uom_code);
379: fnd_message.set_token('uom2', x_secondary_uom_code);
380: fnd_message.set_token('module', l_api_name);
381: fnd_msg_pub.ADD;
374: IF ( l_debug = 1 ) THEN
375: print_debug('Error converting to from '||p_uom_code||' to '||x_secondary_uom_code, 1);
376: END IF;
377: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
378: fnd_message.set_token('uom1', p_uom_code);
379: fnd_message.set_token('uom2', x_secondary_uom_code);
380: fnd_message.set_token('module', l_api_name);
381: fnd_msg_pub.ADD;
382: RAISE FND_API.G_EXC_ERROR;
375: print_debug('Error converting to from '||p_uom_code||' to '||x_secondary_uom_code, 1);
376: END IF;
377: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
378: fnd_message.set_token('uom1', p_uom_code);
379: fnd_message.set_token('uom2', x_secondary_uom_code);
380: fnd_message.set_token('module', l_api_name);
381: fnd_msg_pub.ADD;
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
376: END IF;
377: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
378: fnd_message.set_token('uom1', p_uom_code);
379: fnd_message.set_token('uom2', x_secondary_uom_code);
380: fnd_message.set_token('module', l_api_name);
381: fnd_msg_pub.ADD;
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384: l_progress := '400';
401: END IF;
402: END IF;
403:
404: x_return_status := fnd_api.g_ret_sts_error;
405: fnd_message.set_name('WMS', 'WMS_CALC_SEC_QTY_FAIL');
406: fnd_msg_pub.ADD;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
408: END Get_Default_Secondary_Quantity;
409:
443: l_converted_qty NUMBER;
444: BEGIN
445: -- Standard call to check for call compatibility.
446: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
447: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
448: fnd_msg_pub.ADD;
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
507: IF ( l_converted_qty < 0 ) THEN
508: IF ( l_debug = 1 ) THEN
509: print_debug('Error converting qty from '||l_uom_code||' to '||l_secondary_uom_code, 1);
510: END IF;
511: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
512: fnd_message.set_token('uom1', l_uom_code);
513: fnd_message.set_token('uom2', l_secondary_uom_code);
514: fnd_message.set_token('module', l_api_name);
515: fnd_msg_pub.ADD;
508: IF ( l_debug = 1 ) THEN
509: print_debug('Error converting qty from '||l_uom_code||' to '||l_secondary_uom_code, 1);
510: END IF;
511: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
512: fnd_message.set_token('uom1', l_uom_code);
513: fnd_message.set_token('uom2', l_secondary_uom_code);
514: fnd_message.set_token('module', l_api_name);
515: fnd_msg_pub.ADD;
516: RAISE FND_API.G_EXC_ERROR;
509: print_debug('Error converting qty from '||l_uom_code||' to '||l_secondary_uom_code, 1);
510: END IF;
511: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
512: fnd_message.set_token('uom1', l_uom_code);
513: fnd_message.set_token('uom2', l_secondary_uom_code);
514: fnd_message.set_token('module', l_api_name);
515: fnd_msg_pub.ADD;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
510: END IF;
511: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
512: fnd_message.set_token('uom1', l_uom_code);
513: fnd_message.set_token('uom2', l_secondary_uom_code);
514: fnd_message.set_token('module', l_api_name);
515: fnd_msg_pub.ADD;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
518:
555: END IF;
556: END IF;
557:
558: x_return_status := fnd_api.g_ret_sts_error;
559: fnd_message.set_name('WMS', 'WMS_API_FAIL');
560: fnd_msg_pub.ADD;
561: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
562: END Check_Secondary_Qty_Tolerance;
563:
597: SAVEPOINT UPDATE_SHIPPING_SECONDARY_QTY;
598:
599: -- Standard call to check for call compatibility.
600: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
601: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
602: fnd_msg_pub.ADD;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
627: END IF;
628: EXCEPTION
629: WHEN OTHERS THEN
630: x_return_status := fnd_api.g_ret_sts_error;
631: fnd_message.set_name('WMS', 'WMS_MISSING_WDD_ERR');
632: fnd_msg_pub.ADD;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END;
635:
656: IF ( l_pricing_ind = G_PRICE_SECONDARY ) THEN
657: l_progress := '100';
658: -- Item is catch weight enabled.
659: IF ( l_secondary_uom_code <> p_secondary_uom_code ) THEN
660: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH');
661: fnd_message.set_token('uom1', p_secondary_uom_code);
662: fnd_message.set_token('uom2', l_secondary_uom_code);
663: fnd_msg_pub.ADD;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: l_progress := '100';
658: -- Item is catch weight enabled.
659: IF ( l_secondary_uom_code <> p_secondary_uom_code ) THEN
660: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH');
661: fnd_message.set_token('uom1', p_secondary_uom_code);
662: fnd_message.set_token('uom2', l_secondary_uom_code);
663: fnd_msg_pub.ADD;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
658: -- Item is catch weight enabled.
659: IF ( l_secondary_uom_code <> p_secondary_uom_code ) THEN
660: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH');
661: fnd_message.set_token('uom1', p_secondary_uom_code);
662: fnd_message.set_token('uom2', l_secondary_uom_code);
663: fnd_msg_pub.ADD;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666:
696: IF ( l_tolerance <> 0 ) THEN
697: IF ( l_debug = 1 ) THEN
698: print_debug('Secondary quantity out of tolerance', 4);
699: END IF;
700: fnd_message.set_name('WMS', 'WMS_CTWT_TOLERANCE_ERROR');
701: fnd_msg_pub.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:
708: -- cannot defualt secondary quantity error out
709: IF ( l_debug = 1 ) THEN
710: print_debug('Cannot default secondary quantity', 4);
711: END IF;
712: fnd_message.set_name('WMS','WMS_CTWT_DEFAULT_ERROR');
713: fnd_msg_pub.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
744:
745: IF (l_debug = 1) THEN
746: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
747: END IF;
748: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
749: fnd_message.set_token('MSG1', x_msg_data);
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.g_exc_unexpected_error;
752: END IF;
745: IF (l_debug = 1) THEN
746: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
747: END IF;
748: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
749: fnd_message.set_token('MSG1', x_msg_data);
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.g_exc_unexpected_error;
752: END IF;
753:
774: END IF;
775:
776: ROLLBACK TO UPDATE_SHIPPING_SECONDARY_QTY;
777: x_return_status := fnd_api.g_ret_sts_error;
778: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
779: fnd_msg_pub.ADD;
780: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
781: END Update_Shipping_Secondary_Qty;
782:
827: SAVEPOINT UPDATE_PARENT_DELIVERY_SEC_QTY;
828:
829: -- Standard call to check for call compatibility.
830: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
831: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
832: fnd_msg_pub.ADD;
833: RAISE fnd_api.g_exc_unexpected_error;
834: END IF;
835:
876: IF ( l_line_quantity < 0 ) THEN
877: IF (l_debug = 1) THEN
878: print_debug('Error converting to picked qty from '||wdd_rec.requested_quantity_uom||' to '||p_uom_code, 1);
879: END IF;
880: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
881: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
882: fnd_message.set_token('uom2', p_uom_code);
883: fnd_message.set_token('module', l_api_name);
884: fnd_msg_pub.ADD;
877: IF (l_debug = 1) THEN
878: print_debug('Error converting to picked qty from '||wdd_rec.requested_quantity_uom||' to '||p_uom_code, 1);
879: END IF;
880: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
881: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
882: fnd_message.set_token('uom2', p_uom_code);
883: fnd_message.set_token('module', l_api_name);
884: fnd_msg_pub.ADD;
885: RAISE FND_API.G_EXC_ERROR;
878: print_debug('Error converting to picked qty from '||wdd_rec.requested_quantity_uom||' to '||p_uom_code, 1);
879: END IF;
880: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
881: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
882: fnd_message.set_token('uom2', p_uom_code);
883: fnd_message.set_token('module', l_api_name);
884: fnd_msg_pub.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
879: END IF;
880: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
881: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
882: fnd_message.set_token('uom2', p_uom_code);
883: fnd_message.set_token('module', l_api_name);
884: fnd_msg_pub.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887: ELSE
902: IF ( p_secondary_quantity IS NOT NULL AND round(p_quantity, g_precision) <> round(l_total_quantity, g_precision) ) THEN
903: IF (l_debug = 1) THEN
904: print_debug('p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
905: END IF;
906: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERR');
907: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
908: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
909: FND_MSG_PUB.ADD;
910: RAISE FND_API.G_EXC_ERROR;
903: IF (l_debug = 1) THEN
904: print_debug('p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
905: END IF;
906: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERR');
907: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
908: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
909: FND_MSG_PUB.ADD;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
904: print_debug('p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
905: END IF;
906: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERR');
907: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
908: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
909: FND_MSG_PUB.ADD;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:
942:
943: IF (l_debug = 1) THEN
944: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
945: END IF;
946: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
947: fnd_message.set_token('MSG1', x_msg_data);
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.g_exc_unexpected_error;
950: END IF;
943: IF (l_debug = 1) THEN
944: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
945: END IF;
946: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
947: fnd_message.set_token('MSG1', x_msg_data);
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.g_exc_unexpected_error;
950: END IF;
951: END IF;
971: END IF;
972:
973: ROLLBACK TO UPDATE_PARENT_DELIVERY_SEC_QTY;
974: x_return_status := fnd_api.g_ret_sts_error;
975: fnd_message.set_name('WMS', 'WMS_API_FAIL');
976: fnd_msg_pub.ADD;
977: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
978: END Update_Parent_Delivery_Sec_Qty;
979:
1618: SAVEPOINT update_lpn_primary_qty_sp;
1619:
1620: -- Standard call to check for call compatibility.
1621: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1622: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1623: fnd_msg_pub.ADD;
1624: RAISE fnd_api.g_exc_unexpected_error;
1625: END IF;
1626:
1724: IF (l_primary_qty = -99999) THEN
1725: IF (l_debug = 1) THEN
1726: print_debug('UOM conversion error', 4);
1727: END IF;
1728: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1729: fnd_msg_pub.ADD;
1730: RAISE fnd_api.g_exc_error;
1731: END IF;
1732: END IF;
2159: IF (l_wdd_qty_incr = -99999) THEN
2160: IF (l_debug = 1) THEN
2161: print_debug('UOM conversion error', 4);
2162: END IF;
2163: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2164: fnd_msg_pub.ADD;
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167: ELSE
2187: IF (l_wdd_qty_decr = -99999) THEN
2188: IF (l_debug = 1) THEN
2189: print_debug('UOM conversion error', 4);
2190: END IF;
2191: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2192: fnd_msg_pub.ADD;
2193: RAISE FND_API.G_EXC_ERROR;
2194: END IF;
2195: ELSE
2245:
2246: IF (l_debug = 1) THEN
2247: print_debug('Error calling create_update_delivery_detail: '||x_msg_data, 4);
2248: END IF;
2249: FND_MESSAGE.set_name('WMS','WMS_UPD_DELIVERY_ERROR' );
2250: FND_MESSAGE.set_token('MSG1', x_msg_data);
2251: FND_MSG_PUB.add;
2252: RAISE FND_API.g_exc_unexpected_error;
2253: END IF;
2246: IF (l_debug = 1) THEN
2247: print_debug('Error calling create_update_delivery_detail: '||x_msg_data, 4);
2248: END IF;
2249: FND_MESSAGE.set_name('WMS','WMS_UPD_DELIVERY_ERROR' );
2250: FND_MESSAGE.set_token('MSG1', x_msg_data);
2251: FND_MSG_PUB.add;
2252: RAISE FND_API.g_exc_unexpected_error;
2253: END IF;
2254: END IF; --}
3345: SAVEPOINT UPDATE_LPN_SECONDARY_QUANTITY;
3346:
3347: -- Standard call to check for call compatibility.
3348: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3349: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3350: fnd_msg_pub.ADD;
3351: RAISE fnd_api.g_exc_unexpected_error;
3352: END IF;
3353:
3437: IF ( l_line_quantity < 0 ) THEN
3438: IF ( l_debug = 1 ) THEN
3439: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
3440: END IF;
3441: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3442: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3443: fnd_message.set_token('uom2', p_uom_code);
3444: fnd_message.set_token('module', l_api_name);
3445: fnd_msg_pub.ADD;
3438: IF ( l_debug = 1 ) THEN
3439: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
3440: END IF;
3441: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3442: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3443: fnd_message.set_token('uom2', p_uom_code);
3444: fnd_message.set_token('module', l_api_name);
3445: fnd_msg_pub.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3439: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
3440: END IF;
3441: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3442: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3443: fnd_message.set_token('uom2', p_uom_code);
3444: fnd_message.set_token('module', l_api_name);
3445: fnd_msg_pub.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: END IF;
3440: END IF;
3441: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3442: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3443: fnd_message.set_token('uom2', p_uom_code);
3444: fnd_message.set_token('module', l_api_name);
3445: fnd_msg_pub.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: END IF;
3448: ELSE
3499: IF ( l_line_quantity < 0 ) THEN
3500: IF ( l_debug = 1 ) THEN
3501: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
3502: END IF;
3503: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3504: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3505: fnd_message.set_token('uom2', p_uom_code);
3506: fnd_message.set_token('module', l_api_name);
3507: fnd_msg_pub.ADD;
3500: IF ( l_debug = 1 ) THEN
3501: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
3502: END IF;
3503: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3504: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3505: fnd_message.set_token('uom2', p_uom_code);
3506: fnd_message.set_token('module', l_api_name);
3507: fnd_msg_pub.ADD;
3508: RAISE FND_API.G_EXC_ERROR;
3501: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
3502: END IF;
3503: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3504: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3505: fnd_message.set_token('uom2', p_uom_code);
3506: fnd_message.set_token('module', l_api_name);
3507: fnd_msg_pub.ADD;
3508: RAISE FND_API.G_EXC_ERROR;
3509: END IF;
3502: END IF;
3503: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3504: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
3505: fnd_message.set_token('uom2', p_uom_code);
3506: fnd_message.set_token('module', l_api_name);
3507: fnd_msg_pub.ADD;
3508: RAISE FND_API.G_EXC_ERROR;
3509: END IF;
3510: ELSE
3527: IF(p_secondary_quantity IS NOT NULL AND round(p_quantity, g_precision) <> round(l_total_quantity, g_precision) ) THEN
3528: IF (l_debug = 1) THEN
3529: print_debug('the p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
3530: END IF;
3531: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERROR');
3532: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
3533: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
3534: FND_MSG_PUB.ADD;
3535: RAISE FND_API.G_EXC_ERROR;
3528: IF (l_debug = 1) THEN
3529: print_debug('the p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
3530: END IF;
3531: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERROR');
3532: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
3533: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
3534: FND_MSG_PUB.ADD;
3535: RAISE FND_API.G_EXC_ERROR;
3536: END IF;
3529: print_debug('the p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
3530: END IF;
3531: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERROR');
3532: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
3533: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
3534: FND_MSG_PUB.ADD;
3535: RAISE FND_API.G_EXC_ERROR;
3536: END IF;
3537: END IF;
3557: END IF;
3558:
3559: ROLLBACK TO UPDATE_LPN_SECONDARY_QUANTITY;
3560: x_return_status := fnd_api.g_ret_sts_error;
3561: fnd_message.set_name('WMS', 'WMS_OTHERS_ERROR_CALL'||l_progress);
3562: fnd_msg_pub.ADD;
3563: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3564: END Update_LPN_Secondary_Quantity;
3565:
3628: l_uom_conv_rate NUMBER;
3629: BEGIN
3630: -- Standard call to check for call compatibility.
3631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3632: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3633: fnd_msg_pub.ADD;
3634: RAISE fnd_api.g_exc_unexpected_error;
3635: END IF;
3636:
3724: IF ( l_uom_conv_rate < 0 ) THEN
3725: -- no valid connection uom conversion between these two uoms
3726: l_return := G_CHECK_ERROR;
3727:
3728: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
3729: fnd_msg_pub.ADD;
3730: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3731: ELSE
3732: -- there is a valid conversion, change status to warning
3781: IF ( l_uom_conv_rate < 0 ) THEN
3782: -- no valid connection uom conversion between these two uoms
3783: l_return := G_CHECK_ERROR;
3784:
3785: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
3786: fnd_msg_pub.ADD;
3787: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3788: ELSE
3789: -- there is a valid conversion, change status to warning
3837: IF ( l_uom_conv_rate < 0 ) THEN
3838: -- no valid connection uom conversion between these two uoms
3839: l_return := G_CHECK_ERROR;
3840:
3841: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
3842: fnd_msg_pub.ADD;
3843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3844: ELSE
3845: -- there is a valid conversion, change status to warning
3864:
3865: -- if the return is a warning populate an appropreate
3866: -- message in the message stack
3867: IF ( l_return = G_CHECK_WARNING ) THEN
3868: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_WARNING');
3869: fnd_msg_pub.ADD;
3870: END IF;
3871:
3872: IF ( l_debug = 1 ) THEN
3885: END IF;
3886: END IF;
3887:
3888: x_return_status := fnd_api.g_ret_sts_error;
3889: fnd_message.set_name('WMS', 'WMS_API_FAIL');
3890: fnd_msg_pub.ADD;
3891: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3892: END Check_LPN_Secondary_Quantity;
3893:
4975:
4976:
4977: -- Standard call to check for call compatibility.
4978: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4979: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
4980: fnd_msg_pub.ADD;
4981: RAISE fnd_api.g_exc_unexpected_error;
4982: END IF;
4983:
5024:
5025: IF ( l_uom_conv_rate < 0 ) THEN
5026: -- no valid connection uom conversion between these two uoms
5027: l_return := G_CHECK_ERROR;
5028: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
5029: fnd_msg_pub.ADD;
5030: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5031: ELSE
5032: -- there is a valid conversion, change status to warning
5034: END IF;
5035: ELSE
5036: IF (item_rec.secondary_default_ind = G_SECONDARY_NO_DEFAULT AND item_rec.picked_quantity2 IS NULL) THEN
5037: l_return := G_CHECK_ERROR;
5038: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
5039: fnd_msg_pub.ADD;
5040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5041: END IF;
5042:
5059: print_debug('SQL error: ' || SQLERRM(SQLCODE), 1);
5060: END IF;
5061: END IF;
5062: x_return_status := fnd_api.g_ret_sts_error;
5063: fnd_message.set_name('WMS', 'WMS_CALC_SEC_QTY_FAIL');
5064: fnd_msg_pub.ADD;
5065: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5066: END VALIDATE_CT_WT_FOR_DELIVERYNUM;
5067: