DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on FND_MSG_PUB

Line 49: fnd_msg_pub.ADD;

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:
53: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 55: fnd_msg_pub.initialize;

51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF fnd_api.to_boolean(p_init_msg_list) THEN
55: fnd_msg_pub.initialize;
56: END IF;
57:
58: -- Initialize API return status to success
59: x_return_status := fnd_api.g_ret_sts_success;

Line 140: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

136: print_debug('track_ind='||x_tracking_quantity_ind||' pricesrc='||x_ont_pricing_qty_source||' defaultind='||x_secondary_default_ind , 4);
137: print_debug('secqty='||x_secondary_quantity||' secuom='||x_secondary_uom_code||' devhigh='||x_uom_deviation_high||' devlow='||x_uom_deviation_low, 4);
138: END IF;
139:
140: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
141: EXCEPTION
142: WHEN OTHERS THEN
143: IF (l_debug = 1) THEN
144: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);

Line 151: fnd_msg_pub.ADD;

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:
155:

Line 152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
155:
156: FUNCTION Get_Ont_Pricing_Qty_Source (

Line 176: fnd_msg_pub.ADD;

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:
180: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 182: fnd_msg_pub.initialize;

178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF fnd_api.to_boolean(p_init_msg_list) THEN
182: fnd_msg_pub.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := fnd_api.g_ret_sts_success;

Line 223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

219: IF ( l_debug = 1 ) THEN
220: print_debug(l_api_name||' Exited '||'ret='||l_ont_pricing_qty_source, 1);
221: END IF;
222:
223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
224:
225: RETURN l_ont_pricing_qty_source;
226: EXCEPTION
227: WHEN OTHERS THEN

Line 237: fnd_msg_pub.ADD;

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:
241:

Line 238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
241:
242: PROCEDURE Get_Default_Secondary_Quantity (

Line 270: fnd_msg_pub.ADD;

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:
274: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 276: fnd_msg_pub.initialize;

272: END IF;
273:
274: -- Initialize message list if p_init_msg_list is set to TRUE.
275: IF fnd_api.to_boolean(p_init_msg_list) THEN
276: fnd_msg_pub.initialize;
277: END IF;
278:
279: -- Initialize API return status to success
280: x_return_status := fnd_api.g_ret_sts_success;

Line 340: fnd_msg_pub.ADD;

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:
344: -- Use user specified uom if passed

Line 366: fnd_msg_pub.ADD;

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';
370: ELSE

Line 379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

375: print_debug(l_api_name||' Exited '||' priceind=' ||x_ont_pricing_qty_source, 1);
376: print_debug('secqty='||x_secondary_quantity||' secuom='||x_secondary_uom_code, 4);
377: END IF;
378:
379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
380: EXCEPTION
381: WHEN OTHERS THEN
382: IF (l_debug = 1) THEN
383: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);

Line 391: fnd_msg_pub.ADD;

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:
395:

Line 392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
395:
396: FUNCTION Check_Secondary_Qty_Tolerance (

Line 433: fnd_msg_pub.ADD;

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:
437: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 439: fnd_msg_pub.initialize;

435: END IF;
436:
437: -- Initialize message list if p_init_msg_list is set to TRUE.
438: IF fnd_api.to_boolean(p_init_msg_list) THEN
439: fnd_msg_pub.initialize;
440: END IF;
441:
442: -- Initialize API return status to success
443: x_return_status := fnd_api.g_ret_sts_success;

Line 501: fnd_msg_pub.ADD;

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:
505: IF ( l_uom_deviation_high IS NOT NULL ) THEN

Line 532: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

528: print_debug(l_api_name||' Exited '||' ret=' ||l_return, 1);
529: print_debug('uplim='||l_upper_qty_limit||' lowlim'||l_lower_qty_limit, 4);
530: END IF;
531:
532: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
533:
534: RETURN l_return;
535: EXCEPTION
536: WHEN OTHERS THEN

Line 546: fnd_msg_pub.ADD;

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:
550:

Line 547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
550:
551: PROCEDURE Update_Shipping_Secondary_Qty (

Line 588: fnd_msg_pub.ADD;

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:
592: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 594: fnd_msg_pub.initialize;

590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE.
593: IF fnd_api.to_boolean(p_init_msg_list) THEN
594: fnd_msg_pub.initialize;
595: END IF;
596:
597: -- Initialize API return status to success
598: x_return_status := fnd_api.g_ret_sts_success;

Line 618: fnd_msg_pub.ADD;

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:
622: Get_Default_Secondary_Quantity (

Line 649: fnd_msg_pub.ADD;

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:
653: IF ( p_secondary_quantity = FND_API.G_MISS_NUM ) THEN

Line 687: fnd_msg_pub.ADD;

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:
691: -- User specified sec qty, do not need to use the default value.

Line 699: fnd_msg_pub.ADD;

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:
703: -- If everything checks out, update wdd.picked_quantity2 with catch weight.

Line 736: FND_MSG_PUB.ADD;

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:
740: l_progress := '400';

Line 752: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

748: IF ( l_debug = 1 ) THEN
749: print_debug(l_api_name || ' Exited ', 1);
750: END IF;
751:
752: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
753: EXCEPTION
754: WHEN OTHERS THEN
755: IF (l_debug = 1) THEN
756: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);

Line 765: fnd_msg_pub.ADD;

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:
769:

Line 766: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
769:
770: PROCEDURE Update_Parent_Delivery_Sec_Qty (

Line 818: fnd_msg_pub.ADD;

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:
822: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 824: fnd_msg_pub.initialize;

820: END IF;
821:
822: -- Initialize message list if p_init_msg_list is set to TRUE.
823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: -- Initialize API return status to success
828: x_return_status := fnd_api.g_ret_sts_success;

Line 870: fnd_msg_pub.ADD;

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
874: l_line_quantity := wdd_rec.picked_quantity;

Line 895: FND_MSG_PUB.ADD;

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:
899: l_progress := '200';

Line 934: FND_MSG_PUB.ADD;

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;
938:

Line 949: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

945: IF ( l_debug = 1 ) THEN
946: print_debug( l_api_name || ' Exited ', 1);
947: END IF;
948:
949: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF (l_debug = 1) THEN
953: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);

Line 962: fnd_msg_pub.ADD;

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:
966: --

Line 963: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
966: --
967: -- Procedure: Update_Delivery_Detail_Secondary_Quantity

Line 1019: fnd_msg_pub.ADD;

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:
1023: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1025: fnd_msg_pub.initialize;

1021: END IF;
1022:
1023: -- Initialize message list if p_init_msg_list is set to TRUE.
1024: IF fnd_api.to_boolean(p_init_msg_list) THEN
1025: fnd_msg_pub.initialize;
1026: END IF;
1027:
1028: -- Initialize API return status to success
1029: x_return_status := fnd_api.g_ret_sts_success;

Line 1114: fnd_msg_pub.ADD;

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
1118: l_line_quantity := mmtt_rec.transaction_quantity;

Line 1176: fnd_msg_pub.ADD;

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
1180: l_line_quantity := mtlt_rec.transaction_quantity;

Line 1203: FND_MSG_PUB.ADD;

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;
1207:

Line 1218: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1214: IF ( l_debug = 1 ) THEN
1215: print_debug(l_api_name || ' Exited ', 1);
1216: END IF;
1217:
1218: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1219: EXCEPTION
1220: WHEN OTHERS THEN
1221: IF (l_debug = 1) THEN
1222: print_debug(l_api_name ||' Error l_progress=' || l_progress, 1);

Line 1231: fnd_msg_pub.ADD;

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:
1235:

Line 1232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1235:
1236: FUNCTION Check_LPN_Secondary_Quantity (

Line 1302: fnd_msg_pub.ADD;

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:
1306: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1308: fnd_msg_pub.initialize;

1304: END IF;
1305:
1306: -- Initialize message list if p_init_msg_list is set to TRUE.
1307: IF fnd_api.to_boolean(p_init_msg_list) THEN
1308: fnd_msg_pub.initialize;
1309: END IF;
1310:
1311: -- Initialize API return status to success
1312: x_return_status := fnd_api.g_ret_sts_success;

Line 1398: fnd_msg_pub.ADD;

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
1402: l_return := G_CHECK_WARNING;

Line 1399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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
1402: l_return := G_CHECK_WARNING;
1403: l_prev_pri_uom := wdd_item_rec.primary_uom_code;

Line 1455: fnd_msg_pub.ADD;

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
1459: l_return := G_CHECK_WARNING;

Line 1456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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
1459: l_return := G_CHECK_WARNING;
1460: l_prev_pri_uom := l_pri_uom;

Line 1511: fnd_msg_pub.ADD;

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
1515: l_return := G_CHECK_WARNING;

Line 1512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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
1515: l_return := G_CHECK_WARNING;
1516: l_prev_pri_uom := l_pri_uom;

Line 1538: fnd_msg_pub.ADD;

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
1542: print_debug(l_api_name||' Exited '||'ret='||l_return, 1);

Line 1545: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1541: IF ( l_debug = 1 ) THEN
1542: print_debug(l_api_name||' Exited '||'ret='||l_return, 1);
1543: END IF;
1544:
1545: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1546:
1547: RETURN l_return;
1548: EXCEPTION
1549: WHEN OTHERS THEN

Line 1559: fnd_msg_pub.ADD;

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:
1563:

Line 1560: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1563:
1564: PROCEDURE GET_OUTER_CATCH_WT_LPN

Line 2481: fnd_msg_pub.ADD;

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:
2485: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2487: fnd_msg_pub.initialize;

2483: END IF;
2484:
2485: -- Initialize message list if p_init_msg_list is set to TRUE.
2486: IF fnd_api.to_boolean(p_init_msg_list) THEN
2487: fnd_msg_pub.initialize;
2488: END IF;
2489:
2490: -- Initialize API return status to success
2491: x_return_status := fnd_api.g_ret_sts_success;

Line 2530: fnd_msg_pub.ADD;

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
2534: l_return := G_CHECK_WARNING;

Line 2531: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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
2534: l_return := G_CHECK_WARNING;
2535: END IF;

Line 2540: fnd_msg_pub.ADD;

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:
2544: END IF;

Line 2541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
2544: END IF;
2545:

Line 2565: fnd_msg_pub.ADD;

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:
2569: END WMS_CATCH_WEIGHT_PVT;

Line 2566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
2569: END WMS_CATCH_WEIGHT_PVT;