[Home] [Help]
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:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF fnd_api.to_boolean(p_init_msg_list) THEN
63: fnd_msg_pub.initialize;
64: END IF;
65:
66: -- Initialize API return status to success
67: x_return_status := fnd_api.g_ret_sts_success;
144: print_debug('track_ind='||x_tracking_quantity_ind||' pricesrc='||x_ont_pricing_qty_source||' defaultind='||x_secondary_default_ind , 4);
145: print_debug('secqty='||x_secondary_quantity||' secuom='||x_secondary_uom_code||' devhigh='||x_uom_deviation_high||' devlow='||x_uom_deviation_low, 4);
146: END IF;
147:
148: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
149: EXCEPTION
150: WHEN OTHERS THEN
151: IF (l_debug = 1) THEN
152: print_debug(l_api_name ||' Error l_progress=' || l_progress, 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:
163:
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:
163:
164: FUNCTION Get_Ont_Pricing_Qty_Source (
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:
188: -- Initialize message list if p_init_msg_list is set to TRUE.
186: END IF;
187:
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF fnd_api.to_boolean(p_init_msg_list) THEN
190: fnd_msg_pub.initialize;
191: END IF;
192:
193: -- Initialize API return status to success
194: x_return_status := fnd_api.g_ret_sts_success;
234: IF ( l_debug = 1 ) THEN
235: print_debug(l_api_name||' Exited '||'ret='||l_ont_pricing_qty_source, 1);
236: END IF;
237:
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239:
240: RETURN l_ont_pricing_qty_source;
241: EXCEPTION
242: WHEN OTHERS THEN
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:
256:
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:
256:
257: PROCEDURE Get_Default_Secondary_Quantity (
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:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
287: END IF;
288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
290: IF fnd_api.to_boolean(p_init_msg_list) THEN
291: fnd_msg_pub.initialize;
292: END IF;
293:
294: -- Initialize API return status to success
295: x_return_status := fnd_api.g_ret_sts_success;
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:
359: -- Use user specified uom if passed
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';
385: ELSE
390: print_debug(l_api_name||' Exited '||' priceind=' ||x_ont_pricing_qty_source, 1);
391: print_debug('secqty='||x_secondary_quantity||' secuom='||x_secondary_uom_code, 4);
392: END IF;
393:
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
395: EXCEPTION
396: WHEN OTHERS THEN
397: IF (l_debug = 1) THEN
398: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);
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:
410:
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:
410:
411: FUNCTION Check_Secondary_Qty_Tolerance (
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:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF fnd_api.to_boolean(p_init_msg_list) THEN
454: fnd_msg_pub.initialize;
455: END IF;
456:
457: -- Initialize API return status to success
458: x_return_status := fnd_api.g_ret_sts_success;
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:
519: IF ( l_uom_deviation_high IS NOT NULL ) THEN
542: print_debug(l_api_name||' Exited '||' ret=' ||l_return, 1);
543: print_debug('uplim='||l_upper_qty_limit||' lowlim'||l_lower_qty_limit, 4);
544: END IF;
545:
546: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
547:
548: RETURN l_return;
549: EXCEPTION
550: WHEN OTHERS THEN
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:
564:
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:
564:
565: PROCEDURE 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:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
604: END IF;
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF fnd_api.to_boolean(p_init_msg_list) THEN
608: fnd_msg_pub.initialize;
609: END IF;
610:
611: -- Initialize API return status to success
612: x_return_status := fnd_api.g_ret_sts_success;
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:
636: Get_Default_Secondary_Quantity (
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:
667: IF ( p_secondary_quantity = FND_API.G_MISS_NUM ) 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:
705: -- User specified sec qty, do not need to use the default value.
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:
717: -- If everything checks out, update wdd.picked_quantity2 with catch weight.
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:
754: l_progress := '400';
762: IF ( l_debug = 1 ) THEN
763: print_debug(l_api_name || ' Exited ', 1);
764: END IF;
765:
766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
767: EXCEPTION
768: WHEN OTHERS THEN
769: IF (l_debug = 1) THEN
770: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);
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:
783:
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:
783:
784: PROCEDURE 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:
836: -- Initialize message list if p_init_msg_list is set to TRUE.
834: END IF;
835:
836: -- Initialize message list if p_init_msg_list is set to TRUE.
837: IF fnd_api.to_boolean(p_init_msg_list) THEN
838: fnd_msg_pub.initialize;
839: END IF;
840:
841: -- Initialize API return status to success
842: x_return_status := fnd_api.g_ret_sts_success;
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
888: l_line_quantity := wdd_rec.picked_quantity;
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:
913: l_progress := '200';
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;
952:
959: IF ( l_debug = 1 ) THEN
960: print_debug( l_api_name || ' Exited ', 1);
961: END IF;
962:
963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
964: EXCEPTION
965: WHEN OTHERS THEN
966: IF (l_debug = 1) THEN
967: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);
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:
980:
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:
980:
981: FUNCTION wdd_src_line_id RETURN numset_t PIPELINED
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:
1627: -- Initialize message list if p_init_msg_list is set to TRUE.
1625: END IF;
1626:
1627: -- Initialize message list if p_init_msg_list is set to TRUE.
1628: IF fnd_api.to_boolean(p_init_msg_list) THEN
1629: fnd_msg_pub.initialize;
1630: END IF;
1631:
1632: -- Initialize API return status to success
1633: x_return_status := fnd_api.g_ret_sts_success;
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;
1733: END IF;
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
2168: l_wdd_qty_incr := l_pri_increase;
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
2196: l_wdd_qty_decr := l_pri_decrease;
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; --}
2255:
3272: EXCEPTION
3273: WHEN fnd_api.g_exc_error THEN
3274: ROLLBACK TO update_lpn_primary_qty_sp;
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: fnd_msg_pub.count_and_get
3277: ( p_count => x_msg_count
3278: , p_data => x_msg_data
3279: , p_encoded => fnd_api.g_false
3280: );
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:
3354: -- Initialize message list if p_init_msg_list is set to TRUE.
3352: END IF;
3353:
3354: -- Initialize message list if p_init_msg_list is set to TRUE.
3355: IF fnd_api.to_boolean(p_init_msg_list) THEN
3356: fnd_msg_pub.initialize;
3357: END IF;
3358:
3359: -- Initialize API return status to success
3360: x_return_status := fnd_api.g_ret_sts_success;
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
3449: l_line_quantity := mmtt_rec.transaction_quantity;
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
3511: l_line_quantity := mtlt_rec.transaction_quantity;
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;
3538:
3545: IF ( l_debug = 1 ) THEN
3546: print_debug(l_api_name || ' Exited ', 1);
3547: END IF;
3548:
3549: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3550: EXCEPTION
3551: WHEN OTHERS THEN
3552: IF (l_debug = 1) THEN
3553: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);
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:
3566:
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:
3566:
3567: FUNCTION Check_LPN_Secondary_Quantity (
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:
3637: -- Initialize message list if p_init_msg_list is set to TRUE.
3635: END IF;
3636:
3637: -- Initialize message list if p_init_msg_list is set to TRUE.
3638: IF fnd_api.to_boolean(p_init_msg_list) THEN
3639: fnd_msg_pub.initialize;
3640: END IF;
3641:
3642: -- Initialize API return status to success
3643: x_return_status := fnd_api.g_ret_sts_success;
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
3733: l_return := G_CHECK_WARNING;
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
3733: l_return := G_CHECK_WARNING;
3734: l_prev_pri_uom := wdd_item_rec.primary_uom_code;
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
3790: l_return := G_CHECK_WARNING;
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
3790: l_return := G_CHECK_WARNING;
3791: l_prev_pri_uom := l_pri_uom;
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
3846: l_return := G_CHECK_WARNING;
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
3846: l_return := G_CHECK_WARNING;
3847: l_prev_pri_uom := l_pri_uom;
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
3873: print_debug(l_api_name||' Exited '||'ret='||l_return, 1);
3872: IF ( l_debug = 1 ) THEN
3873: print_debug(l_api_name||' Exited '||'ret='||l_return, 1);
3874: END IF;
3875:
3876: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3877:
3878: RETURN l_return;
3879: EXCEPTION
3880: WHEN OTHERS THEN
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:
3894:
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:
3894:
3895: FUNCTION check_ds_lpn (
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:
4984: -- Initialize message list if p_init_msg_list is set to TRUE.
4982: END IF;
4983:
4984: -- Initialize message list if p_init_msg_list is set to TRUE.
4985: IF fnd_api.to_boolean(p_init_msg_list) THEN
4986: fnd_msg_pub.initialize;
4987: END IF;
4988:
4989: -- Initialize API return status to success
4990: x_return_status := fnd_api.g_ret_sts_success;
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
5033: l_return := G_CHECK_WARNING;
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
5033: l_return := G_CHECK_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:
5043: END IF;
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:
5043: END IF;
5044:
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:
5068:
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:
5068:
5069: PROCEDURE get_primary_uom_class(
5301: EXCEPTION
5302: WHEN fnd_api.g_exc_error THEN
5303: ROLLBACK TO update_tare_sp;
5304: x_return_status := fnd_api.g_ret_sts_error;
5305: fnd_msg_pub.count_and_get
5306: ( p_count => x_msg_count
5307: , p_data => x_msg_data
5308: , p_encoded => fnd_api.g_false
5309: );