[Home] [Help]
44: l_result VARCHAR2(30);
45: BEGIN
46: -- Standard call to check for call compatibility.
47: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
48: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
49: fnd_msg_pub.ADD;
50: RAISE fnd_api.g_exc_unexpected_error;
51: END IF;
52:
146: print_debug('SQL error: ' || SQLERRM(SQLCODE), 1);
147: END IF;
148: END IF;
149: x_return_status := fnd_api.g_ret_sts_error;
150: fnd_message.set_name('WMS', 'WMS_GET_CWT_ATTR_FAIL');
151: fnd_msg_pub.ADD;
152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
153: END Get_Catch_Weight_Attributes;
154:
171: l_ont_pricing_qty_source VARCHAR(30);
172: BEGIN
173: -- Standard call to check for call compatibility.
174: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
175: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
176: fnd_msg_pub.ADD;
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
232: END IF;
233: END IF;
234:
235: x_return_status := fnd_api.g_ret_sts_error;
236: fnd_message.set_name('WMS', 'WMS_API_FAIL');
237: fnd_msg_pub.ADD;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239: END Get_Ont_Pricing_Qty_Source;
240:
265: l_secondary_uom VARCHAR(3);
266: BEGIN
267: -- Standard call to check for call compatibility.
268: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
269: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
270: fnd_msg_pub.ADD;
271: RAISE fnd_api.g_exc_unexpected_error;
272: END IF;
273:
335: IF ( x_secondary_uom_code IS NULL ) THEN
336: IF (l_debug = 1) THEN
337: print_debug('Secondary UOM is not defined for this secondary priced item', 1);
338: END IF;
339: fnd_message.set_name('WMS', 'WMS_SEC_UOM_UNDEF_ERROR');
340: fnd_msg_pub.ADD;
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:
358: IF ( x_secondary_quantity < 0 ) THEN
359: IF ( l_debug = 1 ) THEN
360: print_debug('Error converting to from '||p_uom_code||' to '||x_secondary_uom_code, 1);
361: END IF;
362: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
363: fnd_message.set_token('uom1', p_uom_code);
364: fnd_message.set_token('uom2', x_secondary_uom_code);
365: fnd_message.set_token('module', l_api_name);
366: fnd_msg_pub.ADD;
359: IF ( l_debug = 1 ) THEN
360: print_debug('Error converting to from '||p_uom_code||' to '||x_secondary_uom_code, 1);
361: END IF;
362: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
363: fnd_message.set_token('uom1', p_uom_code);
364: fnd_message.set_token('uom2', x_secondary_uom_code);
365: fnd_message.set_token('module', l_api_name);
366: fnd_msg_pub.ADD;
367: RAISE FND_API.G_EXC_ERROR;
360: print_debug('Error converting to from '||p_uom_code||' to '||x_secondary_uom_code, 1);
361: END IF;
362: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
363: fnd_message.set_token('uom1', p_uom_code);
364: fnd_message.set_token('uom2', x_secondary_uom_code);
365: fnd_message.set_token('module', l_api_name);
366: fnd_msg_pub.ADD;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
361: END IF;
362: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
363: fnd_message.set_token('uom1', p_uom_code);
364: fnd_message.set_token('uom2', x_secondary_uom_code);
365: fnd_message.set_token('module', l_api_name);
366: fnd_msg_pub.ADD;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369: l_progress := '400';
386: END IF;
387: END IF;
388:
389: x_return_status := fnd_api.g_ret_sts_error;
390: fnd_message.set_name('WMS', 'WMS_CALC_SEC_QTY_FAIL');
391: fnd_msg_pub.ADD;
392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
393: END Get_Default_Secondary_Quantity;
394:
428: l_converted_qty NUMBER;
429: BEGIN
430: -- Standard call to check for call compatibility.
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
433: fnd_msg_pub.ADD;
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:
493: IF ( l_converted_qty < 0 ) THEN
494: IF ( l_debug = 1 ) THEN
495: print_debug('Error converting qty from '||l_uom_code||' to '||l_secondary_uom_code, 1);
496: END IF;
497: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
498: fnd_message.set_token('uom1', l_uom_code);
499: fnd_message.set_token('uom2', l_secondary_uom_code);
500: fnd_message.set_token('module', l_api_name);
501: fnd_msg_pub.ADD;
494: IF ( l_debug = 1 ) THEN
495: print_debug('Error converting qty from '||l_uom_code||' to '||l_secondary_uom_code, 1);
496: END IF;
497: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
498: fnd_message.set_token('uom1', l_uom_code);
499: fnd_message.set_token('uom2', l_secondary_uom_code);
500: fnd_message.set_token('module', l_api_name);
501: fnd_msg_pub.ADD;
502: RAISE FND_API.G_EXC_ERROR;
495: print_debug('Error converting qty from '||l_uom_code||' to '||l_secondary_uom_code, 1);
496: END IF;
497: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
498: fnd_message.set_token('uom1', l_uom_code);
499: fnd_message.set_token('uom2', l_secondary_uom_code);
500: fnd_message.set_token('module', l_api_name);
501: fnd_msg_pub.ADD;
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
496: END IF;
497: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
498: fnd_message.set_token('uom1', l_uom_code);
499: fnd_message.set_token('uom2', l_secondary_uom_code);
500: fnd_message.set_token('module', l_api_name);
501: fnd_msg_pub.ADD;
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504:
541: END IF;
542: END IF;
543:
544: x_return_status := fnd_api.g_ret_sts_error;
545: fnd_message.set_name('WMS', 'WMS_API_FAIL');
546: fnd_msg_pub.ADD;
547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
548: END Check_Secondary_Qty_Tolerance;
549:
583: SAVEPOINT UPDATE_SHIPPING_SECONDARY_QTY;
584:
585: -- Standard call to check for call compatibility.
586: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
587: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
588: fnd_msg_pub.ADD;
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
613: END IF;
614: EXCEPTION
615: WHEN OTHERS THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: fnd_message.set_name('WMS', 'WMS_MISSING_WDD_ERR');
618: fnd_msg_pub.ADD;
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END;
621:
642: IF ( l_pricing_ind = G_PRICE_SECONDARY ) THEN
643: l_progress := '100';
644: -- Item is catch weight enabled.
645: IF ( l_secondary_uom_code <> p_secondary_uom_code ) THEN
646: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH');
647: fnd_message.set_token('uom1', p_secondary_uom_code);
648: fnd_message.set_token('uom2', l_secondary_uom_code);
649: fnd_msg_pub.ADD;
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: l_progress := '100';
644: -- Item is catch weight enabled.
645: IF ( l_secondary_uom_code <> p_secondary_uom_code ) THEN
646: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH');
647: fnd_message.set_token('uom1', p_secondary_uom_code);
648: fnd_message.set_token('uom2', l_secondary_uom_code);
649: fnd_msg_pub.ADD;
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
644: -- Item is catch weight enabled.
645: IF ( l_secondary_uom_code <> p_secondary_uom_code ) THEN
646: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH');
647: fnd_message.set_token('uom1', p_secondary_uom_code);
648: fnd_message.set_token('uom2', l_secondary_uom_code);
649: fnd_msg_pub.ADD;
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
682: IF ( l_tolerance <> 0 ) THEN
683: IF ( l_debug = 1 ) THEN
684: print_debug('Secondary quantity out of tolerance', 4);
685: END IF;
686: fnd_message.set_name('WMS', 'WMS_CTWT_TOLERANCE_ERROR');
687: fnd_msg_pub.ADD;
688: RAISE FND_API.G_EXC_ERROR;
689: END IF;
690:
694: -- cannot defualt secondary quantity error out
695: IF ( l_debug = 1 ) THEN
696: print_debug('Cannot default secondary quantity', 4);
697: END IF;
698: fnd_message.set_name('WMS','WMS_CTWT_DEFAULT_ERROR');
699: fnd_msg_pub.ADD;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
730:
731: IF (l_debug = 1) THEN
732: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
733: END IF;
734: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
735: fnd_message.set_token('MSG1', x_msg_data);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.g_exc_unexpected_error;
738: END IF;
731: IF (l_debug = 1) THEN
732: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
733: END IF;
734: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
735: fnd_message.set_token('MSG1', x_msg_data);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.g_exc_unexpected_error;
738: END IF;
739:
760: END IF;
761:
762: ROLLBACK TO UPDATE_SHIPPING_SECONDARY_QTY;
763: x_return_status := fnd_api.g_ret_sts_error;
764: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
765: fnd_msg_pub.ADD;
766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
767: END Update_Shipping_Secondary_Qty;
768:
813: SAVEPOINT UPDATE_PARENT_DELIVERY_SEC_QTY;
814:
815: -- Standard call to check for call compatibility.
816: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
817: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
818: fnd_msg_pub.ADD;
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821:
862: IF ( l_line_quantity < 0 ) THEN
863: IF (l_debug = 1) THEN
864: print_debug('Error converting to picked qty from '||wdd_rec.requested_quantity_uom||' to '||p_uom_code, 1);
865: END IF;
866: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
867: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
868: fnd_message.set_token('uom2', p_uom_code);
869: fnd_message.set_token('module', l_api_name);
870: fnd_msg_pub.ADD;
863: IF (l_debug = 1) THEN
864: print_debug('Error converting to picked qty from '||wdd_rec.requested_quantity_uom||' to '||p_uom_code, 1);
865: END IF;
866: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
867: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
868: fnd_message.set_token('uom2', p_uom_code);
869: fnd_message.set_token('module', l_api_name);
870: fnd_msg_pub.ADD;
871: RAISE FND_API.G_EXC_ERROR;
864: print_debug('Error converting to picked qty from '||wdd_rec.requested_quantity_uom||' to '||p_uom_code, 1);
865: END IF;
866: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
867: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
868: fnd_message.set_token('uom2', p_uom_code);
869: fnd_message.set_token('module', l_api_name);
870: fnd_msg_pub.ADD;
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
865: END IF;
866: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
867: fnd_message.set_token('uom1', wdd_rec.requested_quantity_uom);
868: fnd_message.set_token('uom2', p_uom_code);
869: fnd_message.set_token('module', l_api_name);
870: fnd_msg_pub.ADD;
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: ELSE
888: IF ( p_secondary_quantity IS NOT NULL AND round(p_quantity, g_precision) <> round(l_total_quantity, g_precision) ) THEN
889: IF (l_debug = 1) THEN
890: print_debug('p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
891: END IF;
892: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERR');
893: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
894: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
895: FND_MSG_PUB.ADD;
896: RAISE FND_API.G_EXC_ERROR;
889: IF (l_debug = 1) THEN
890: print_debug('p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
891: END IF;
892: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERR');
893: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
894: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
895: FND_MSG_PUB.ADD;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
890: print_debug('p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
891: END IF;
892: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERR');
893: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
894: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
895: FND_MSG_PUB.ADD;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898:
928:
929: IF (l_debug = 1) THEN
930: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
931: END IF;
932: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
933: fnd_message.set_token('MSG1', x_msg_data);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.g_exc_unexpected_error;
936: END IF;
929: IF (l_debug = 1) THEN
930: print_debug('Error calling Create_Update_Delivery_Detail: '||x_msg_data, 9);
931: END IF;
932: FND_MESSAGE.SET_NAME('WMS','WMS_UPD_DELIVERY_ERROR' );
933: fnd_message.set_token('MSG1', x_msg_data);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.g_exc_unexpected_error;
936: END IF;
937: END IF;
957: END IF;
958:
959: ROLLBACK TO UPDATE_PARENT_DELIVERY_SEC_QTY;
960: x_return_status := fnd_api.g_ret_sts_error;
961: fnd_message.set_name('WMS', 'WMS_API_FAIL');
962: fnd_msg_pub.ADD;
963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
964: END Update_Parent_Delivery_Sec_Qty;
965:
1014: SAVEPOINT UPDATE_LPN_SECONDARY_QUANTITY;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1018: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1019: fnd_msg_pub.ADD;
1020: RAISE fnd_api.g_exc_unexpected_error;
1021: END IF;
1022:
1106: IF ( l_line_quantity < 0 ) THEN
1107: IF ( l_debug = 1 ) THEN
1108: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
1109: END IF;
1110: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1111: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1112: fnd_message.set_token('uom2', p_uom_code);
1113: fnd_message.set_token('module', l_api_name);
1114: fnd_msg_pub.ADD;
1107: IF ( l_debug = 1 ) THEN
1108: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
1109: END IF;
1110: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1111: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1112: fnd_message.set_token('uom2', p_uom_code);
1113: fnd_message.set_token('module', l_api_name);
1114: fnd_msg_pub.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1108: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
1109: END IF;
1110: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1111: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1112: fnd_message.set_token('uom2', p_uom_code);
1113: fnd_message.set_token('module', l_api_name);
1114: fnd_msg_pub.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1109: END IF;
1110: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1111: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1112: fnd_message.set_token('uom2', p_uom_code);
1113: fnd_message.set_token('module', l_api_name);
1114: fnd_msg_pub.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117: ELSE
1168: IF ( l_line_quantity < 0 ) THEN
1169: IF ( l_debug = 1 ) THEN
1170: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
1171: END IF;
1172: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1173: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1174: fnd_message.set_token('uom2', p_uom_code);
1175: fnd_message.set_token('module', l_api_name);
1176: fnd_msg_pub.ADD;
1169: IF ( l_debug = 1 ) THEN
1170: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
1171: END IF;
1172: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1173: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1174: fnd_message.set_token('uom2', p_uom_code);
1175: fnd_message.set_token('module', l_api_name);
1176: fnd_msg_pub.ADD;
1177: RAISE FND_API.G_EXC_ERROR;
1170: print_debug('Error converting to trx qty from '||mmtt_rec.transaction_uom||' to '||p_uom_code, 1);
1171: END IF;
1172: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1173: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1174: fnd_message.set_token('uom2', p_uom_code);
1175: fnd_message.set_token('module', l_api_name);
1176: fnd_msg_pub.ADD;
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1171: END IF;
1172: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
1173: fnd_message.set_token('uom1', mmtt_rec.transaction_uom);
1174: fnd_message.set_token('uom2', p_uom_code);
1175: fnd_message.set_token('module', l_api_name);
1176: fnd_msg_pub.ADD;
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179: ELSE
1196: IF(p_secondary_quantity IS NOT NULL AND round(p_quantity, g_precision) <> round(l_total_quantity, g_precision) ) THEN
1197: IF (l_debug = 1) THEN
1198: print_debug('the p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
1199: END IF;
1200: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERROR');
1201: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
1202: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
1203: FND_MSG_PUB.ADD;
1204: RAISE FND_API.G_EXC_ERROR;
1197: IF (l_debug = 1) THEN
1198: print_debug('the p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
1199: END IF;
1200: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERROR');
1201: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
1202: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
1203: FND_MSG_PUB.ADD;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1198: print_debug('the p_quantity '||p_quantity||' does not match the sum quantity '||l_total_quantity, 9);
1199: END IF;
1200: FND_MESSAGE.SET_NAME('WMS','WMS_QTY_UPD_MISMATCH_ERROR');
1201: FND_MESSAGE.SET_TOKEN('QTY1', p_quantity);
1202: FND_MESSAGE.SET_TOKEN('QTY2', l_total_quantity);
1203: FND_MSG_PUB.ADD;
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206: END IF;
1226: END IF;
1227:
1228: ROLLBACK TO UPDATE_LPN_SECONDARY_QUANTITY;
1229: x_return_status := fnd_api.g_ret_sts_error;
1230: fnd_message.set_name('WMS', 'WMS_OTHERS_ERROR_CALL'||l_progress);
1231: fnd_msg_pub.ADD;
1232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1233: END Update_LPN_Secondary_Quantity;
1234:
1297: l_uom_conv_rate NUMBER;
1298: BEGIN
1299: -- Standard call to check for call compatibility.
1300: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1301: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1302: fnd_msg_pub.ADD;
1303: RAISE fnd_api.g_exc_unexpected_error;
1304: END IF;
1305:
1393: IF ( l_uom_conv_rate < 0 ) THEN
1394: -- no valid connection uom conversion between these two uoms
1395: l_return := G_CHECK_ERROR;
1396:
1397: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
1398: fnd_msg_pub.ADD;
1399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1400: ELSE
1401: -- there is a valid conversion, change status to warning
1450: IF ( l_uom_conv_rate < 0 ) THEN
1451: -- no valid connection uom conversion between these two uoms
1452: l_return := G_CHECK_ERROR;
1453:
1454: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
1455: fnd_msg_pub.ADD;
1456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1457: ELSE
1458: -- there is a valid conversion, change status to warning
1506: IF ( l_uom_conv_rate < 0 ) THEN
1507: -- no valid connection uom conversion between these two uoms
1508: l_return := G_CHECK_ERROR;
1509:
1510: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
1511: fnd_msg_pub.ADD;
1512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1513: ELSE
1514: -- there is a valid conversion, change status to warning
1533:
1534: -- if the return is a warning populate an appropreate
1535: -- message in the message stack
1536: IF ( l_return = G_CHECK_WARNING ) THEN
1537: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_WARNING');
1538: fnd_msg_pub.ADD;
1539: END IF;
1540:
1541: IF ( l_debug = 1 ) THEN
1554: END IF;
1555: END IF;
1556:
1557: x_return_status := fnd_api.g_ret_sts_error;
1558: fnd_message.set_name('WMS', 'WMS_API_FAIL');
1559: fnd_msg_pub.ADD;
1560: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1561: END Check_LPN_Secondary_Quantity;
1562:
2476:
2477:
2478: -- Standard call to check for call compatibility.
2479: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2480: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2481: fnd_msg_pub.ADD;
2482: RAISE fnd_api.g_exc_unexpected_error;
2483: END IF;
2484:
2525:
2526: IF ( l_uom_conv_rate < 0 ) THEN
2527: -- no valid connection uom conversion between these two uoms
2528: l_return := G_CHECK_ERROR;
2529: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
2530: fnd_msg_pub.ADD;
2531: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2532: ELSE
2533: -- there is a valid conversion, change status to warning
2535: END IF;
2536: ELSE
2537: IF (item_rec.secondary_default_ind = G_SECONDARY_NO_DEFAULT AND item_rec.picked_quantity2 IS NULL) THEN
2538: l_return := G_CHECK_ERROR;
2539: fnd_message.set_name('WMS', 'WMS_CTWT_DEFAULT_ERROR');
2540: fnd_msg_pub.ADD;
2541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2542: END IF;
2543:
2560: print_debug('SQL error: ' || SQLERRM(SQLCODE), 1);
2561: END IF;
2562: END IF;
2563: x_return_status := fnd_api.g_ret_sts_error;
2564: fnd_message.set_name('WMS', 'WMS_CALC_SEC_QTY_FAIL');
2565: fnd_msg_pub.ADD;
2566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2567: END VALIDATE_CT_WT_FOR_DELIVERYNUM;
2568: