eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CONTAINER_PUB dependencies on FND_MSG_PUB

Line 270: fnd_msg_pub.ADD;

266:
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 301: fnd_msg_pub.ADD;

297: IF (l_debug = 1) THEN
298: mdebug(p_organization_id || ' is not a valid org id', G_ERROR);
299: END IF;
300: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
301: fnd_msg_pub.ADD;
302: RAISE fnd_api.g_exc_error;
303: END IF;
304:
305: l_progress := 'Validate Container Item';

Line 315: fnd_msg_pub.ADD;

311: IF (l_debug = 1) THEN
312: mdebug(p_container_item_id || ' is not a valid container item id', 1);
313: END IF;
314: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
315: fnd_msg_pub.ADD;
316: RAISE fnd_api.g_exc_error;
317: END IF;
318:
319: IF (l_container_item.container_item_flag = 'N') THEN

Line 324: fnd_msg_pub.ADD;

320: IF (l_debug = 1) THEN
321: mdebug(p_container_item_id || ' is not a container', 1);
322: END IF;
323: fnd_message.set_name('WMS', 'WMS_CONT_ITEM_NOT_A_CONT');
324: fnd_msg_pub.ADD;
325: RAISE fnd_api.g_exc_error;
326: END IF;
327: END IF;
328:

Line 339: fnd_msg_pub.ADD;

335: IF (l_debug = 1) THEN
336: mdebug(p_subinventory || ' is not a valid sub', 1);
337: END IF;
338: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
339: fnd_msg_pub.ADD;
340: RAISE fnd_api.g_exc_error;
341: END IF;
342: END IF;
343:

Line 352: fnd_msg_pub.ADD;

348: IF (l_debug = 1) THEN
349: mdebug('Generate_LPN is missing required loc', 1);
350: END IF;
351: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOC');
352: fnd_msg_pub.ADD;
353: RAISE fnd_api.g_exc_error;
354: END IF;
355:
356: l_locator.inventory_location_id := p_locator_id;

Line 364: fnd_msg_pub.ADD;

360: IF (l_debug = 1) THEN
361: mdebug(p_locator_id || ' is not a valid loc id', 1);
362: END IF;
363: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
364: fnd_msg_pub.ADD;
365: RAISE fnd_api.g_exc_error;
366: END IF;
367: END IF;
368: END IF;

Line 381: fnd_msg_pub.ADD;

377: IF (l_debug = 1) THEN
378: mdebug(p_revision || ' is not a valid rev', 1);
379: END IF;
380: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_REV');
381: fnd_msg_pub.ADD;
382: RAISE fnd_api.g_exc_error;
383: END IF;
384: ELSE
385: --Rev not supported for container items currently. Allow to use rev controlled items

Line 390: --fnd_msg_pub.ADD;

386: IF (l_debug = 1) THEN
387: mdebug('Generate_LPN is missing the rev for rev container item..ok', 1);
388: END IF;
389: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_REV');
390: --fnd_msg_pub.ADD;
391: --RAISE fnd_api.g_exc_error;
392: END IF;
393: END IF;
394: END IF;

Line 408: fnd_msg_pub.ADD;

404: IF (l_debug = 1) THEN
405: mdebug(p_lot_number || ' is not a valid lot', 1);
406: END IF;
407: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
408: fnd_msg_pub.ADD;
409: RAISE fnd_api.g_exc_error;
410: END IF;
411: ELSE
412: --Lots not supported for container items currently. Allow to use lot controlled items

Line 417: --fnd_msg_pub.ADD;

413: IF (l_debug = 1) THEN
414: mdebug('Generate_LPN is missing lot for lot container item..ok', 1);
415: END IF;
416: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOT');
417: --fnd_msg_pub.ADD;
418: --RAISE fnd_api.g_exc_error;
419: END IF;
420: END IF;
421: END IF;

Line 433: fnd_msg_pub.ADD;

429: IF (l_debug = 1) THEN
430: mdebug(p_to_serial_number || ' failed MTL_Serial_Check', 1);
431: END IF;
432: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
433: fnd_msg_pub.ADD;
434: RAISE fnd_api.g_exc_error;
435: END IF;
436:
437: -- Check that in the case of a range of serial numbers, that the

Line 445: fnd_msg_pub.ADD;

441: IF (l_debug = 1) THEN
442: mdebug(p_quantity || ' does not match sn range qty of ' || l_quantity_serial, 1);
443: END IF;
444: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_X_QTY');
445: fnd_msg_pub.ADD;
446: RAISE fnd_api.g_exc_error;
447: END IF;
448: END IF;
449:

Line 467: fnd_msg_pub.ADD;

463: IF (l_debug = 1) THEN
464: mdebug(l_current_serial || 'failed validate_serial', 1);
465: END IF;
466: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
467: fnd_msg_pub.ADD;
468: RAISE fnd_api.g_exc_error;
469: END IF;
470: ELSE
471: -- Subinventory was not given so will need to do

Line 481: fnd_msg_pub.ADD;

477: IF (l_debug = 1) THEN
478: mdebug(l_current_serial || ' could not be found in MTL_SERIAL_NUMBERS', 1);
479: END IF;
480: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
481: fnd_msg_pub.ADD;
482: RAISE fnd_api.g_exc_error;
483: END IF;
484:
485: CLOSE serial_validation_cursor;

Line 509: --fnd_msg_pub.ADD;

505: IF (l_debug = 1) THEN
506: mdebug('Generate_LPN is missing sn for serial container item..ok', 1);
507: END IF;
508: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_SER_NUM');
509: --fnd_msg_pub.ADD;
510: --RAISE fnd_api.g_exc_error;
511: END IF;
512: END IF;
513: END IF;

Line 522: fnd_msg_pub.ADD;

518: IF (l_debug = 1) THEN
519: mdebug(p_quantity || ' is a negative qty', 1);
520: END IF;
521: fnd_message.set_name('WMS', 'WMS_CONT_NEG_QTY');
522: fnd_msg_pub.ADD;
523: RAISE fnd_api.g_exc_error;
524: END IF;
525:
526: l_quantity := p_quantity;

Line 538: fnd_msg_pub.ADD;

534: IF (l_debug = 1) THEN
535: mdebug(p_source || ' is an invalid source', 1);
536: END IF;
537: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
538: fnd_msg_pub.ADD;
539: RAISE fnd_api.g_exc_error;
540: END IF;
541: END IF;
542:

Line 552: fnd_msg_pub.ADD;

548: IF (l_debug = 1) THEN
549: mdebug(p_cost_group_id || ' is an invalid cost group id', 1);
550: END IF;
551: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CST_GRP');
552: fnd_msg_pub.ADD;
553: RAISE fnd_api.g_exc_error;
554: END IF;
555: END IF;
556: END IF;

Line 616: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

612: END IF;
613:
614: -- Standard call to get message count and if count is 1,
615: -- get message info.
616: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN
619: x_return_status := fnd_api.g_ret_sts_error;
620: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

616: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN
619: x_return_status := fnd_api.g_ret_sts_error;
620: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
621: IF (l_debug = 1) THEN
622: FOR i in 1..x_msg_count LOOP
623: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
624: END LOOP;

Line 623: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

619: x_return_status := fnd_api.g_ret_sts_error;
620: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
621: IF (l_debug = 1) THEN
622: FOR i in 1..x_msg_count LOOP
623: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
624: END LOOP;
625: mdebug(l_api_name ||' EXC_ERROR progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
626: mdebug('msg: '||l_msgdata, G_ERROR);
627: END IF;

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

627: END IF;
628: ROLLBACK TO GENERATE_LPN_PUB;
629: WHEN OTHERS THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
632: IF (l_debug = 1) THEN
633: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
634: END IF;
635: ROLLBACK TO GENERATE_LPN_PUB;

Line 688: fnd_msg_pub.ADD;

684:
685: -- Standard call to check for call compatibility.
686: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
687: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
688: fnd_msg_pub.ADD;
689: RAISE fnd_api.g_exc_unexpected_error;
690: END IF;
691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 694: fnd_msg_pub.initialize;

690: END IF;
691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: IF fnd_api.to_boolean(p_init_msg_list) THEN
694: fnd_msg_pub.initialize;
695: END IF;
696:
697: -- Initialize API return status to success
698: x_return_status := fnd_api.g_ret_sts_success;

Line 713: fnd_msg_pub.ADD;

709: IF (p_validation_level = fnd_api.g_valid_level_full) THEN
710: /* Check that lpn id is given */
711: IF (p_lpn_id IS NULL) THEN
712: fnd_message.set_name('WMS', 'WMS_CONT_LPN_NOT_GIVEN');
713: fnd_msg_pub.ADD;
714: RAISE fnd_api.g_exc_error;
715: END IF;
716:
717: /* Validate the LPN */

Line 738: fnd_msg_pub.ADD;

734: IF (l_debug = 1) THEN
735: mdebug(p_organization_id || ' is an invalid org id', 1);
736: END IF;
737: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
738: fnd_msg_pub.ADD;
739: RAISE fnd_api.g_exc_error;
740: END IF;
741:
742: /* Validate Subinventory */

Line 752: fnd_msg_pub.ADD;

748: IF (l_debug = 1) THEN
749: mdebug(p_subinventory || ' is an invalid sub', 1);
750: END IF;
751: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
752: fnd_msg_pub.ADD;
753: RAISE fnd_api.g_exc_error;
754: END IF;
755: END IF;
756:

Line 762: fnd_msg_pub.ADD;

758: IF (p_subinventory IS NOT NULL) THEN
759: IF (l_sub.locator_type IN (2, 3)) THEN
760: IF (p_locator_id IS NULL) THEN
761: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOC');
762: fnd_msg_pub.ADD;
763: RAISE fnd_api.g_exc_error;
764: END IF;
765:
766: l_locator.inventory_location_id := p_locator_id;

Line 774: fnd_msg_pub.ADD;

770: IF (l_debug = 1) THEN
771: mdebug(p_locator_id || ' is an invalid loc id', 1);
772: END IF;
773: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
774: fnd_msg_pub.ADD;
775: RAISE fnd_api.g_exc_error;
776: END IF;
777: END IF;
778: END IF;

Line 791: fnd_msg_pub.ADD;

787: IF (l_debug = 1) THEN
788: mdebug(p_container_item_id || ' is an invalid container item id', 1);
789: END IF;
790: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
791: fnd_msg_pub.ADD;
792: RAISE fnd_api.g_exc_error;
793: END IF;
794:
795: IF (l_container_item.container_item_flag = 'N') THEN

Line 800: fnd_msg_pub.ADD;

796: IF (l_debug = 1) THEN
797: mdebug(p_container_item_id || ' is not a container item', 1);
798: END IF;
799: fnd_message.set_name('WMS', 'WMS_CONT_ITEM_NOT_A_CONT');
800: fnd_msg_pub.ADD;
801: RAISE fnd_api.g_exc_error;
802: END IF;
803:
804: IF (l_container_item.unit_weight IS NOT NULL) THEN

Line 824: fnd_msg_pub.ADD;

820: l_new_weight_uom := l_lpn.gross_weight_uom_code;
821: END IF;
822: ELSE
823: fnd_message.set_name('WMS', 'WMS_CONT_CONTAINER_NOT_GIVEN');
824: fnd_msg_pub.ADD;
825: RAISE fnd_api.g_exc_error;
826: END IF;
827:
828: /* Validate Revision */

Line 839: fnd_msg_pub.ADD;

835: IF (l_debug = 1) THEN
836: mdebug(p_revision || ' is an invalid rev', 1);
837: END IF;
838: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_REV');
839: fnd_msg_pub.ADD;
840: RAISE fnd_api.g_exc_error;
841: END IF;
842: ELSE
843: --Rev not supported for container items currently. Allow to use rev controlled items

Line 848: --fnd_msg_pub.ADD;

844: IF (l_debug = 1) THEN
845: mdebug('Associate_LPN is missing the rev for rev container item..ok', 1);
846: END IF;
847: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_REV');
848: --fnd_msg_pub.ADD;
849: --RAISE fnd_api.g_exc_error;
850: END IF;
851: END IF;
852: END IF;

Line 866: fnd_msg_pub.ADD;

862: IF (l_debug = 1) THEN
863: mdebug(p_lot_number || ' is not a valid lot', 1);
864: END IF;
865: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
866: fnd_msg_pub.ADD;
867: RAISE fnd_api.g_exc_error;
868: END IF;
869: ELSE
870: --Lots not supported for container items currently. Allow to use lot controlled items

Line 875: --fnd_msg_pub.ADD;

871: IF (l_debug = 1) THEN
872: mdebug('Associate_LPN is missing lot for lot container item..ok', 1);
873: END IF;
874: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOT');
875: --fnd_msg_pub.ADD;
876: --RAISE fnd_api.g_exc_error;
877: END IF;
878: END IF;
879: END IF;

Line 893: fnd_msg_pub.ADD;

889: IF (l_debug = 1) THEN
890: mdebug(p_serial_number || ' is an invalid sn', 1);
891: END IF;
892: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
893: fnd_msg_pub.ADD;
894: RAISE fnd_api.g_exc_error;
895: END IF;
896: ELSE
897: --SN not supported for container items currently. Allow to use serial controlled items

Line 902: --fnd_msg_pub.ADD;

898: IF (l_debug = 1) THEN
899: mdebug('Associate_LPN is missing sn for serial container item..ok', 1);
900: END IF;
901: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_SER');
902: --fnd_msg_pub.ADD;
903: --RAISE fnd_api.g_exc_error;
904: END IF;
905: END IF;
906: END IF;

Line 917: fnd_msg_pub.ADD;

913: IF (l_debug = 1) THEN
914: mdebug(p_cost_group_id || ' is an invalid cg', 1);
915: END IF;
916: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CST_GRP');
917: fnd_msg_pub.ADD;
918: RAISE fnd_api.g_exc_error;
919: END IF;
920: END IF;
921: END IF;

Line 946: fnd_msg_pub.ADD;

942: l_result := inv_validate.ORGANIZATION(l_org);
943:
944: IF (l_result = inv_validate.f) THEN
945: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
946: fnd_msg_pub.ADD;
947: RAISE fnd_api.g_exc_error;
948: END IF;
949:
950: /* Validate Container Item */

Line 957: fnd_msg_pub.ADD;

953: l_result := inv_validate.inventory_item(l_container_item, l_org);
954:
955: IF (l_result = inv_validate.f) THEN
956: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
957: fnd_msg_pub.ADD;
958: RAISE fnd_api.g_exc_error;
959: END IF;
960:
961: IF (l_container_item.container_item_flag = 'N') THEN

Line 963: fnd_msg_pub.ADD;

959: END IF;
960:
961: IF (l_container_item.container_item_flag = 'N') THEN
962: fnd_message.set_name('WMS', 'WMS_CONT_ITEM_NOT_A_CONT');
963: fnd_msg_pub.ADD;
964: RAISE fnd_api.g_exc_error;
965: END IF;
966:
967: IF (l_container_item.unit_weight IS NOT NULL) THEN

Line 987: fnd_msg_pub.ADD;

983: l_new_weight_uom := l_lpn.gross_weight_uom_code;
984: END IF;
985: ELSE
986: fnd_message.set_name('WMS', 'WMS_CONT_CONTAINER_NOT_GIVEN');
987: fnd_msg_pub.ADD;
988: RAISE fnd_api.g_exc_error;
989: END IF;
990: END IF;
991:

Line 1137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1133: END IF;
1134:
1135: -- Standard call to get message count and if count is 1,
1136: -- get message info.
1137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1138: EXCEPTION
1139: WHEN fnd_api.g_exc_error THEN
1140: ROLLBACK TO associate_lpn_pub;
1141: x_return_status := fnd_api.g_ret_sts_error;

Line 1142: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1138: EXCEPTION
1139: WHEN fnd_api.g_exc_error THEN
1140: ROLLBACK TO associate_lpn_pub;
1141: x_return_status := fnd_api.g_ret_sts_error;
1142: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1143: WHEN fnd_api.g_exc_unexpected_error THEN
1144: ROLLBACK TO associate_lpn_pub;
1145: x_return_status := fnd_api.g_ret_sts_unexp_error;
1146: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1146: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1142: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1143: WHEN fnd_api.g_exc_unexpected_error THEN
1144: ROLLBACK TO associate_lpn_pub;
1145: x_return_status := fnd_api.g_ret_sts_unexp_error;
1146: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1147: WHEN OTHERS THEN
1148: ROLLBACK TO associate_lpn_pub;
1149: x_return_status := fnd_api.g_ret_sts_unexp_error;
1150:

Line 1151: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1147: WHEN OTHERS THEN
1148: ROLLBACK TO associate_lpn_pub;
1149: x_return_status := fnd_api.g_ret_sts_unexp_error;
1150:
1151: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1153: END IF;
1154:
1155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1148: ROLLBACK TO associate_lpn_pub;
1149: x_return_status := fnd_api.g_ret_sts_unexp_error;
1150:
1151: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1153: END IF;
1154:
1155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1156: END associate_lpn;

Line 1155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1151: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1153: END IF;
1154:
1155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1156: END associate_lpn;
1157:
1158: -- ----------------------------------------------------------------------------------
1159: -- ----------------------------------------------------------------------------------

Line 1206: fnd_msg_pub.ADD;

1202:
1203: -- Standard call to check for call compatibility.
1204: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1205: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1206: fnd_msg_pub.ADD;
1207: RAISE fnd_api.g_exc_unexpected_error;
1208: END IF;
1209:
1210: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1212: fnd_msg_pub.initialize;

1208: END IF;
1209:
1210: -- Initialize message list if p_init_msg_list is set to TRUE.
1211: IF fnd_api.to_boolean(p_init_msg_list) THEN
1212: fnd_msg_pub.initialize;
1213: END IF;
1214:
1215: -- Initialize API return status to success
1216: x_return_status := fnd_api.g_ret_sts_success;

Line 1236: fnd_msg_pub.ADD;

1232: IF (l_debug = 1) THEN
1233: mdebug(p_lpn || ' failed LPN validation', 1);
1234: END IF;
1235: fnd_message.set_name('WMS', 'WMS_CONT_DUPLICATE_LPN');
1236: fnd_msg_pub.ADD;
1237: RAISE fnd_api.g_exc_error;
1238: END IF;
1239:
1240: /* Validate Parent LPN */

Line 1251: fnd_msg_pub.ADD;

1247: IF (l_debug = 1) THEN
1248: mdebug(p_parent_lpn_id || ' parent LPN failed validation', 1);
1249: END IF;
1250: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
1251: fnd_msg_pub.ADD;
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254: END IF;
1255:

Line 1265: fnd_msg_pub.ADD;

1261: IF (l_debug = 1) THEN
1262: mdebug(p_organization_id || ' is an invalid Org', 1);
1263: END IF;
1264: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
1265: fnd_msg_pub.ADD;
1266: RAISE fnd_api.g_exc_error;
1267: END IF;
1268:
1269: /* Validate Subinventory */

Line 1279: fnd_msg_pub.ADD;

1275: IF (l_debug = 1) THEN
1276: mdebug(p_subinventory || ' Invalid Subinventory', 1);
1277: END IF;
1278: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
1279: fnd_msg_pub.ADD;
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282: END IF;
1283:

Line 1292: fnd_msg_pub.ADD;

1288: IF (l_debug = 1) THEN
1289: mdebug('Missing required locator', 1);
1290: END IF;
1291: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOC');
1292: fnd_msg_pub.ADD;
1293: RAISE fnd_api.g_exc_error;
1294: END IF;
1295:
1296: l_locator.inventory_location_id := p_locator_id;

Line 1304: fnd_msg_pub.ADD;

1300: IF (l_debug = 1) THEN
1301: mdebug(p_locator_id || ' is an invalid locator', 1);
1302: END IF;
1303: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
1304: fnd_msg_pub.ADD;
1305: RAISE fnd_api.g_exc_error;
1306: END IF;
1307: END IF;
1308: END IF;

Line 1320: fnd_msg_pub.ADD;

1316: IF (l_debug = 1) THEN
1317: mdebug(p_container_item_id || ' is an invalid container item', 1);
1318: END IF;
1319: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
1320: fnd_msg_pub.ADD;
1321: RAISE fnd_api.g_exc_error;
1322: END IF;
1323:
1324: IF (l_container_item.container_item_flag = 'N') THEN

Line 1329: fnd_msg_pub.ADD;

1325: IF (l_debug = 1) THEN
1326: mdebug(p_container_item_id || ' is not a container', 1);
1327: END IF;
1328: fnd_message.set_name('WMS', 'WMS_CONT_ITEM_NOT_A_CONTAINER');
1329: fnd_msg_pub.ADD;
1330: RAISE fnd_api.g_exc_error;
1331: END IF;
1332: END IF;
1333:

Line 1345: fnd_msg_pub.ADD;

1341: IF (l_debug = 1) THEN
1342: mdebug(p_revision || ' is an invalid Revision', 1);
1343: END IF;
1344: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_REV');
1345: fnd_msg_pub.ADD;
1346: RAISE fnd_api.g_exc_error;
1347: END IF;
1348: ELSE
1349: --Revision not supported for container items currently. Allow to use rev controlled items

Line 1354: --fnd_msg_pub.ADD;

1350: IF (l_debug = 1) THEN
1351: mdebug('Generate_LPN is missing rev for lot container item..ok', 1);
1352: END IF;
1353: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_REV');
1354: --fnd_msg_pub.ADD;
1355: --RAISE fnd_api.g_exc_error;
1356: END IF;
1357: END IF;
1358: END IF;

Line 1372: fnd_msg_pub.ADD;

1368: IF (l_debug = 1) THEN
1369: mdebug(p_lot_number || ' is an invalid lot', 1);
1370: END IF;
1371: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
1372: fnd_msg_pub.ADD;
1373: RAISE fnd_api.g_exc_error;
1374: END IF;
1375: ELSE
1376: --Lots not supported for container items currently. Allow to use lot controlled items

Line 1381: fnd_msg_pub.ADD;

1377: IF (l_debug = 1) THEN
1378: mdebug('Generate_LPN is missing lot for lot container item..ok', 1);
1379: END IF;
1380: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOT');
1381: fnd_msg_pub.ADD;
1382: RAISE fnd_api.g_exc_error;
1383: END IF;
1384: END IF;
1385: END IF;

Line 1399: fnd_msg_pub.ADD;

1395: IF (l_debug = 1) THEN
1396: mdebug(l_serial.serial_number || ' is an invalid Serial Number', 1);
1397: END IF;
1398: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
1399: fnd_msg_pub.ADD;
1400: RAISE fnd_api.g_exc_error;
1401: END IF;
1402: ELSE
1403: --SN not supported for container items currently. Allow to use serial controlled items

Line 1408: --fnd_msg_pub.ADD;

1404: IF (l_debug = 1) THEN
1405: mdebug('Create_LPN is missing sn for serial container item..ok', 1);
1406: END IF;
1407: --fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_SER');
1408: --fnd_msg_pub.ADD;
1409: --RAISE fnd_api.g_exc_error;
1410: END IF;
1411: END IF;
1412: END IF;

Line 1421: fnd_msg_pub.ADD;

1417: IF (l_debug = 1) THEN
1418: mdebug(p_source || 'is an invalid source type', 1);
1419: END IF;
1420: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
1421: fnd_msg_pub.ADD;
1422: RAISE fnd_api.g_exc_error;
1423: END IF;
1424: END IF;
1425:

Line 1435: fnd_msg_pub.ADD;

1431: IF (l_debug = 1) THEN
1432: mdebug(p_cost_group_id || 'is an invalid cost group', 1);
1433: END IF;
1434: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CST_GRP');
1435: fnd_msg_pub.ADD;
1436: RAISE fnd_api.g_exc_error;
1437: END IF;
1438: END IF;
1439: END IF;

Line 1483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1479: END IF;
1480:
1481: -- Standard call to get message count and if count is 1,
1482: -- get message info.
1483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1484: EXCEPTION
1485: WHEN fnd_api.g_exc_error THEN
1486: ROLLBACK TO create_lpn_pub;
1487: x_return_status := fnd_api.g_ret_sts_error;

Line 1488: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1484: EXCEPTION
1485: WHEN fnd_api.g_exc_error THEN
1486: ROLLBACK TO create_lpn_pub;
1487: x_return_status := fnd_api.g_ret_sts_error;
1488: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1489: WHEN fnd_api.g_exc_unexpected_error THEN
1490: ROLLBACK TO create_lpn_pub;
1491: x_return_status := fnd_api.g_ret_sts_unexp_error;
1492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1488: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1489: WHEN fnd_api.g_exc_unexpected_error THEN
1490: ROLLBACK TO create_lpn_pub;
1491: x_return_status := fnd_api.g_ret_sts_unexp_error;
1492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1493: WHEN OTHERS THEN
1494: ROLLBACK TO create_lpn_pub;
1495: x_return_status := fnd_api.g_ret_sts_unexp_error;
1496:

Line 1497: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1493: WHEN OTHERS THEN
1494: ROLLBACK TO create_lpn_pub;
1495: x_return_status := fnd_api.g_ret_sts_unexp_error;
1496:
1497: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1498: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1499: END IF;
1500:
1501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1498: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1494: ROLLBACK TO create_lpn_pub;
1495: x_return_status := fnd_api.g_ret_sts_unexp_error;
1496:
1497: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1498: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1499: END IF;
1500:
1501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1502: END create_lpn;

Line 1501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1497: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1498: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1499: END IF;
1500:
1501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1502: END create_lpn;
1503:
1504: -- ----------------------------------------------------------------------------------
1505: -- ----------------------------------------------------------------------------------

Line 1598: fnd_msg_pub.ADD;

1594:
1595: -- Standard call to check for call compatibility.
1596: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1597: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1598: fnd_msg_pub.ADD;
1599: RAISE fnd_api.g_exc_unexpected_error;
1600: END IF;
1601:
1602: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1604: fnd_msg_pub.initialize;

1600: END IF;
1601:
1602: -- Initialize message list if p_init_msg_list is set to TRUE.
1603: IF fnd_api.to_boolean(p_init_msg_list) THEN
1604: fnd_msg_pub.initialize;
1605: END IF;
1606:
1607: -- Initialize API return status to success
1608: x_return_status := fnd_api.g_ret_sts_success;

Line 1620: fnd_msg_pub.ADD;

1616: l_result := validate_lpn(l_lpn);
1617:
1618: IF (l_result = inv_validate.f) THEN
1619: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
1620: fnd_msg_pub.ADD;
1621: RAISE fnd_api.g_exc_error;
1622: END IF;
1623:
1624: /* Validate Organization */

Line 1631: fnd_msg_pub.ADD;

1627: l_result := inv_validate.ORGANIZATION(l_org);
1628:
1629: IF (l_result = inv_validate.f) THEN
1630: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
1631: fnd_msg_pub.ADD;
1632: RAISE fnd_api.g_exc_error;
1633: END IF;
1634: END IF;
1635:

Line 1643: fnd_msg_pub.ADD;

1639: l_result := inv_validate.subinventory(l_sub, l_org);
1640:
1641: IF (l_result = inv_validate.f) THEN
1642: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
1643: fnd_msg_pub.ADD;
1644: RAISE fnd_api.g_exc_error;
1645: END IF;
1646: END IF;
1647:

Line 1653: fnd_msg_pub.ADD;

1649: IF (p_lpn.subinventory_code IS NOT NULL) THEN
1650: IF (l_sub.locator_type IN (2, 3)) THEN
1651: IF (p_lpn.locator_id IS NULL) THEN
1652: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOC');
1653: fnd_msg_pub.ADD;
1654: RAISE fnd_api.g_exc_error;
1655: END IF;
1656:
1657: l_locator.inventory_location_id := p_lpn.locator_id;

Line 1662: fnd_msg_pub.ADD;

1658: l_result := inv_validate.validatelocator(l_locator, l_org, l_sub);
1659:
1660: IF (l_result = inv_validate.f) THEN
1661: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
1662: fnd_msg_pub.ADD;
1663: RAISE fnd_api.g_exc_error;
1664: END IF;
1665: END IF;
1666: END IF;

Line 1675: fnd_msg_pub.ADD;

1671: l_result := inv_validate.inventory_item(l_container_item, l_org);
1672:
1673: IF (l_result = inv_validate.f) THEN
1674: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
1675: fnd_msg_pub.ADD;
1676: RAISE fnd_api.g_exc_error;
1677: END IF;
1678:
1679: IF (l_container_item.container_item_flag = 'N') THEN

Line 1681: fnd_msg_pub.ADD;

1677: END IF;
1678:
1679: IF (l_container_item.container_item_flag = 'N') THEN
1680: fnd_message.set_name('WMS', 'WMS_CONT_ITEM_NOT_A_CONTAINER');
1681: fnd_msg_pub.ADD;
1682: RAISE fnd_api.g_exc_error;
1683: END IF;
1684: END IF;
1685:

Line 1693: fnd_msg_pub.ADD;

1689: IF (l_debug = 1) THEN
1690: mdebug('gross weight= '|| p_lpn.gross_weight, 9);
1691: END IF;
1692: fnd_message.set_name('WMS', 'WMS_CONT_NEG_WEIGHT');
1693: fnd_msg_pub.ADD;
1694: RAISE fnd_api.g_exc_error;
1695: END IF;
1696: END IF;
1697:

Line 1702: fnd_msg_pub.ADD;

1698: /* Validate Content Volume */
1699: IF (p_lpn.content_volume IS NOT NULL) THEN
1700: IF (p_lpn.content_volume < 0) THEN
1701: fnd_message.set_name('WMS', 'WMS_CONT_NEG_VOLUME');
1702: fnd_msg_pub.ADD;
1703: RAISE fnd_api.g_exc_error;
1704: END IF;
1705: END IF;
1706:

Line 1711: fnd_msg_pub.ADD;

1707: /* Validate LPN Status ID */
1708: IF (p_lpn.status_id IS NOT NULL) THEN
1709: IF (p_lpn.status_id NOT IN (1, 2, 3, 4, 5, 6)) THEN
1710: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1711: fnd_msg_pub.ADD;
1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714: END IF;
1715:

Line 1720: fnd_msg_pub.ADD;

1716: /* Validate LPN Context */
1717: IF (p_lpn.lpn_context IS NOT NULL) THEN
1718: IF (p_lpn.lpn_context NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)) THEN
1719: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
1720: fnd_msg_pub.ADD;
1721: RAISE fnd_api.g_exc_error;
1722: END IF;
1723: END IF;
1724:

Line 1729: fnd_msg_pub.ADD;

1725: /* Validate Sealed Status */
1726: IF (p_lpn.sealed_status IS NOT NULL) THEN
1727: IF (p_lpn.sealed_status NOT IN (1, 2)) THEN
1728: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SEALED_STAT');
1729: fnd_msg_pub.ADD;
1730: RAISE fnd_api.g_exc_error;
1731: END IF;
1732: END IF;
1733: END IF;

Line 1791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1787: END IF;
1788:
1789: -- Standard call to get message count and if count is 1,
1790: -- get message info.
1791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1792: EXCEPTION
1793: WHEN fnd_api.g_exc_error THEN
1794: ROLLBACK TO modify_lpn_pub;
1795: x_return_status := fnd_api.g_ret_sts_error;

Line 1796: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1792: EXCEPTION
1793: WHEN fnd_api.g_exc_error THEN
1794: ROLLBACK TO modify_lpn_pub;
1795: x_return_status := fnd_api.g_ret_sts_error;
1796: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1797: WHEN fnd_api.g_exc_unexpected_error THEN
1798: ROLLBACK TO modify_lpn_pub;
1799: x_return_status := fnd_api.g_ret_sts_unexp_error;
1800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1796: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1797: WHEN fnd_api.g_exc_unexpected_error THEN
1798: ROLLBACK TO modify_lpn_pub;
1799: x_return_status := fnd_api.g_ret_sts_unexp_error;
1800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1801: WHEN OTHERS THEN
1802: ROLLBACK TO modify_lpn_pub;
1803: x_return_status := fnd_api.g_ret_sts_unexp_error;
1804:

Line 1805: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1801: WHEN OTHERS THEN
1802: ROLLBACK TO modify_lpn_pub;
1803: x_return_status := fnd_api.g_ret_sts_unexp_error;
1804:
1805: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1806: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1807: END IF;
1808:
1809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1806: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1802: ROLLBACK TO modify_lpn_pub;
1803: x_return_status := fnd_api.g_ret_sts_unexp_error;
1804:
1805: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1806: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1807: END IF;
1808:
1809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1810: END modify_lpn;

Line 1809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1805: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1806: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1807: END IF;
1808:
1809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1810: END modify_lpn;
1811:
1812: PROCEDURE modify_lpn_wrapper(
1813: p_api_version IN NUMBER,

Line 1851: fnd_msg_pub.ADD;

1847:
1848: -- Standard call to check for call compatibility.
1849: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1850: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1851: fnd_msg_pub.ADD;
1852: RAISE fnd_api.g_exc_unexpected_error;
1853: END IF;
1854:
1855: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1857: fnd_msg_pub.initialize;

1853: END IF;
1854:
1855: -- Initialize message list if p_init_msg_list is set to TRUE.
1856: IF fnd_api.to_boolean(p_init_msg_list) THEN
1857: fnd_msg_pub.initialize;
1858: END IF;
1859:
1860: -- Initialize API return status to success
1861: x_return_status := fnd_api.g_ret_sts_success;

Line 1871: fnd_msg_pub.ADD;

1867: l_result := validate_lpn(l_lpn);
1868:
1869: IF (l_result = inv_validate.f) THEN
1870: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
1871: fnd_msg_pub.ADD;
1872: RAISE fnd_api.g_exc_error;
1873: END IF;
1874:
1875: WMS_CONTAINER_PVT.Modify_LPN_Wrapper(

Line 1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1912: END IF;
1913:
1914: -- Standard call to get message count and if count is 1,
1915: -- get message info.
1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1917: EXCEPTION
1918: WHEN fnd_api.g_exc_error THEN
1919: ROLLBACK TO modify_lpn_wrapper_pub;
1920: x_return_status := fnd_api.g_ret_sts_error;

Line 1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1917: EXCEPTION
1918: WHEN fnd_api.g_exc_error THEN
1919: ROLLBACK TO modify_lpn_wrapper_pub;
1920: x_return_status := fnd_api.g_ret_sts_error;
1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1922: WHEN fnd_api.g_exc_unexpected_error THEN
1923: ROLLBACK TO modify_lpn_wrapper_pub;
1924: x_return_status := fnd_api.g_ret_sts_unexp_error;
1925: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1925: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1922: WHEN fnd_api.g_exc_unexpected_error THEN
1923: ROLLBACK TO modify_lpn_wrapper_pub;
1924: x_return_status := fnd_api.g_ret_sts_unexp_error;
1925: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1926: WHEN OTHERS THEN
1927: ROLLBACK TO modify_lpn_wrapper_pub;
1928: x_return_status := fnd_api.g_ret_sts_unexp_error;
1929:

Line 1930: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1926: WHEN OTHERS THEN
1927: ROLLBACK TO modify_lpn_wrapper_pub;
1928: x_return_status := fnd_api.g_ret_sts_unexp_error;
1929:
1930: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1931: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1932: END IF;
1933:
1934: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1931: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1927: ROLLBACK TO modify_lpn_wrapper_pub;
1928: x_return_status := fnd_api.g_ret_sts_unexp_error;
1929:
1930: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1931: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1932: END IF;
1933:
1934: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1935: END modify_lpn_wrapper;

Line 1934: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1930: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1931: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1932: END IF;
1933:
1934: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1935: END modify_lpn_wrapper;
1936:
1937: -- ----------------------------------------------------------------------------------
1938: -- ----------------------------------------------------------------------------------

Line 2169: fnd_msg_pub.ADD;

2165:
2166: -- Standard call to check for call compatibility.
2167: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2168: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2169: fnd_msg_pub.ADD;
2170: RAISE fnd_api.g_exc_unexpected_error;
2171: END IF;
2172:
2173: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2175: fnd_msg_pub.initialize;

2171: END IF;
2172:
2173: -- Initialize message list if p_init_msg_list is set to TRUE.
2174: IF fnd_api.to_boolean(p_init_msg_list) THEN
2175: fnd_msg_pub.initialize;
2176: END IF;
2177:
2178: -- Initialize API return status to success
2179: x_return_status := fnd_api.g_ret_sts_success;

Line 2199: fnd_msg_pub.ADD;

2195: IF (l_debug = 1) THEN
2196: mdebug(p_lpn_id || 'is an invalid lpn_id', G_ERROR);
2197: END IF;
2198: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2199: fnd_msg_pub.ADD;
2200: RAISE fnd_api.g_exc_error;
2201: END IF;
2202:
2203: /* Validate all inputs if validation level is set to full */

Line 2215: fnd_msg_pub.ADD;

2211: IF (l_debug = 1) THEN
2212: mdebug(p_content_lpn_id || 'is and invalid content lpn id', G_ERROR);
2213: END IF;
2214: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CONTENT_LPN');
2215: fnd_msg_pub.ADD;
2216: RAISE fnd_api.g_exc_error;
2217: END IF;
2218:
2219: -- Check that the content lpn is in fact stored within the given parent lpn

Line 2227: fnd_msg_pub.ADD;

2223: IF (l_debug = 1) THEN
2224: mdebug('child lpn is not in lpn parent lpn', G_ERROR);
2225: END IF;
2226: fnd_message.set_name('WMS', 'WMS_CONT_LPN_NOT_IN_LPN');
2227: fnd_msg_pub.ADD;
2228: RAISE fnd_api.g_exc_error;
2229: END IF;
2230: END IF;
2231: END IF;

Line 2242: fnd_msg_pub.ADD;

2238: IF (l_debug = 1) THEN
2239: mdebug(p_organization_id || 'is not a valid org_id', G_ERROR);
2240: END IF;
2241: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
2242: fnd_msg_pub.ADD;
2243: RAISE fnd_api.g_exc_error;
2244: END IF;
2245:
2246: /* Validate Content Item */

Line 2256: fnd_msg_pub.ADD;

2252: IF (l_debug = 1) THEN
2253: mdebug(p_content_item_id || 'is not a valid content item id', G_ERROR);
2254: END IF;
2255: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CONTENT_ITEM');
2256: fnd_msg_pub.ADD;
2257: RAISE fnd_api.g_exc_error;
2258: END IF;
2259: END IF;
2260:

Line 2273: fnd_msg_pub.ADD;

2269: IF (l_debug = 1) THEN
2270: mdebug('no item description for unpack all', G_ERROR);
2271: END IF;
2272: fnd_message.set_name('WMS', 'WMS_CONT_NO_ITEM_DESC');
2273: fnd_msg_pub.ADD;
2274: RAISE fnd_api.g_exc_error;
2275: END IF;
2276: END IF;
2277:

Line 2286: fnd_msg_pub.ADD;

2282: IF (l_debug = 1) THEN
2283: mdebug('Can not specify both content item and container item at same time', G_ERROR);
2284: END IF;
2285: fnd_message.set_name('WMS', 'WMS_CONT_LPN_AND_ITEM');
2286: fnd_msg_pub.ADD;
2287: RAISE fnd_api.g_exc_error;
2288: END IF;
2289:
2290: /* Validate that Subinventory must be given if pack operation and in INV*/

Line 2296: fnd_msg_pub.ADD;

2292: IF (p_operation = 1) THEN
2293: IF (l_lpn.lpn_context IN (1, 11)) THEN
2294: IF (p_subinventory IS NULL) THEN
2295: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2296: fnd_msg_pub.ADD;
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2299: END IF;
2300: END IF;

Line 2313: fnd_msg_pub.ADD;

2309: IF (l_debug = 1) THEN
2310: mdebug(p_subinventory || 'is an invalid sub', G_ERROR);
2311: END IF;
2312: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2313: fnd_msg_pub.ADD;
2314: RAISE fnd_api.g_exc_error;
2315: END IF;
2316: END IF;
2317:

Line 2343: fnd_msg_pub.ADD;

2339: IF (l_debug = 1) THEN
2340: mdebug('Missing required locator', G_ERROR);
2341: END IF;
2342: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOC');
2343: fnd_msg_pub.ADD;
2344: RAISE fnd_api.g_exc_error;
2345: END IF;
2346:
2347: l_locator.inventory_location_id := p_locator_id;

Line 2355: fnd_msg_pub.ADD;

2351: IF (l_debug = 1) THEN
2352: mdebug(p_locator_id || ' is an invalid locator_id', G_ERROR);
2353: END IF;
2354: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
2355: fnd_msg_pub.ADD;
2356: RAISE fnd_api.g_exc_error;
2357: END IF;
2358: --END IF;
2359: END IF;

Line 2374: fnd_msg_pub.ADD;

2370: IF (l_debug = 1) THEN
2371: mdebug(p_revision || ' is an invalid revision', G_ERROR);
2372: END IF;
2373: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_REV');
2374: fnd_msg_pub.ADD;
2375: RAISE fnd_api.g_exc_error;
2376: END IF;
2377: ELSE
2378: IF (l_debug = 1) THEN

Line 2382: fnd_msg_pub.ADD;

2378: IF (l_debug = 1) THEN
2379: mdebug('Mission required revision', G_ERROR);
2380: END IF;
2381: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_REV');
2382: fnd_msg_pub.ADD;
2383: RAISE fnd_api.g_exc_error;
2384: END IF;
2385: END IF;
2386: END IF;

Line 2417: fnd_msg_pub.ADD;

2413: IF (l_debug = 1) THEN
2414: mdebug(p_lot_number || ' is an invalid lot number', G_ERROR);
2415: END IF;
2416: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
2417: fnd_msg_pub.ADD;
2418: RAISE fnd_api.g_exc_error;
2419: END IF;
2420: END IF;
2421: ELSE

Line 2432: fnd_msg_pub.ADD;

2428: IF (l_debug = 1) THEN
2429: mdebug(p_lot_number || ' is an invalid lot number', G_ERROR);
2430: END IF;
2431: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
2432: fnd_msg_pub.ADD;
2433: RAISE fnd_api.g_exc_error;
2434: END IF;
2435:
2436: CLOSE lot_validation_cursor;

Line 2448: fnd_msg_pub.ADD;

2444: IF (l_debug = 1) THEN
2445: mdebug('Missing required lot', G_ERROR);
2446: END IF;
2447: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOT');
2448: fnd_msg_pub.ADD;
2449: RAISE fnd_api.g_exc_error;
2450: END IF;
2451: END IF;
2452: END IF;

Line 2464: fnd_msg_pub.ADD;

2460: IF (l_debug = 1) THEN
2461: mdebug('Requested a negative item qty', G_ERROR);
2462: END IF;
2463: fnd_message.set_name('WMS', 'WMS_CONT_NEG_ITEM_QTY');
2464: fnd_msg_pub.ADD;
2465: RAISE fnd_api.g_exc_error;
2466: ELSE
2467: l_quantity := p_quantity;
2468: END IF;

Line 2483: fnd_msg_pub.ADD;

2479: IF (l_debug = 1) THEN
2480: mdebug('For container item unpack quantitiy must be 1', G_ERROR);
2481: END IF;
2482: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_QTY');
2483: fnd_msg_pub.ADD;
2484: RAISE fnd_api.g_exc_error;
2485: END IF;
2486: ELSE
2487: l_quantity := 1;

Line 2504: fnd_msg_pub.ADD;

2500: IF (l_debug = 1) THEN
2501: mdebug('Invalid serial number given in range', G_ERROR);
2502: END IF;
2503: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2504: fnd_msg_pub.ADD;
2505: RAISE fnd_api.g_exc_error;
2506: END IF;
2507:
2508: -- Check that in the case of a range of serial numbers, that the

Line 2516: fnd_msg_pub.ADD;

2512: IF (l_debug = 1) THEN
2513: mdebug('Serial range quantity '||l_quantity||' not the same as given qty '||p_quantity, G_ERROR);
2514: END IF;
2515: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_X_QTY');
2516: fnd_msg_pub.ADD;
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519: END IF;
2520:

Line 2552: fnd_msg_pub.ADD;

2548: IF (l_debug = 1) THEN
2549: mdebug(l_current_serial || ' is not a valid serial number', G_ERROR);
2550: END IF;
2551: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: END IF;
2555: ELSE
2556: -- Either the subinventory was not given or

Line 2567: fnd_msg_pub.ADD;

2563: IF (l_debug = 1) THEN
2564: mdebug(l_current_serial || ' is not a valid serial number', G_ERROR);
2565: END IF;
2566: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2567: fnd_msg_pub.ADD;
2568: RAISE fnd_api.g_exc_error;
2569: END IF;
2570:
2571: CLOSE serial_validation_cursor;

Line 2601: fnd_msg_pub.ADD;

2597: IF (l_debug = 1) THEN
2598: mdebug('Missing require serial number', G_ERROR);
2599: END IF;
2600: fnd_message.set_name('WMS', 'WMS_CONT_MISS_SER_NUM');
2601: fnd_msg_pub.ADD;
2602: RAISE fnd_api.g_exc_error;
2603: END IF;
2604: END IF;
2605: END IF;

Line 2616: fnd_msg_pub.ADD;

2612: IF (l_debug = 1) THEN
2613: mdebug(p_uom || ' is an invalid UOM', G_ERROR);
2614: END IF;
2615: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_UOM');
2616: fnd_msg_pub.ADD;
2617: RAISE fnd_api.g_exc_error;
2618: END IF;
2619: END IF;
2620:

Line 2627: fnd_msg_pub.ADD;

2623: IF (l_debug = 1) THEN
2624: mdebug(p_operation || ' is an invalid operation type', G_ERROR);
2625: END IF;
2626: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_OPERATION');
2627: fnd_msg_pub.ADD;
2628: RAISE fnd_api.g_exc_error;
2629: END IF;
2630:
2631: /* Validate the enforce weight and volume constraint flag */

Line 2638: fnd_msg_pub.ADD;

2634: IF (l_debug = 1) THEN
2635: mdebug(p_enforce_wv_constraints || ' is an invalid constraint type', G_MESSAGE);
2636: END IF;
2637: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CONSTRAINT');
2638: fnd_msg_pub.ADD;
2639: RAISE fnd_api.g_exc_error;
2640: END IF;
2641: END IF;
2642:

Line 2652: fnd_msg_pub.ADD;

2648: IF (l_debug = 1) THEN
2649: mdebug(p_cost_group_id || ' is an invalid cost group is', G_ERROR);
2650: END IF;
2651: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CST_GRP');
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_error;
2654: END IF;
2655: END IF;
2656: END IF;

Line 2718: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2714: END IF;
2715:
2716: -- Standard call to get message count and if count is 1,
2717: -- get message info.
2718: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2719: EXCEPTION
2720: WHEN fnd_api.g_exc_error THEN
2721: ROLLBACK TO packunpack_container_pub;
2722: x_return_status := fnd_api.g_ret_sts_error;

Line 2723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2719: EXCEPTION
2720: WHEN fnd_api.g_exc_error THEN
2721: ROLLBACK TO packunpack_container_pub;
2722: x_return_status := fnd_api.g_ret_sts_error;
2723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2724: WHEN fnd_api.g_exc_unexpected_error THEN
2725: ROLLBACK TO packunpack_container_pub;
2726: x_return_status := fnd_api.g_ret_sts_unexp_error;
2727: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2727: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2723: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2724: WHEN fnd_api.g_exc_unexpected_error THEN
2725: ROLLBACK TO packunpack_container_pub;
2726: x_return_status := fnd_api.g_ret_sts_unexp_error;
2727: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2728: WHEN OTHERS THEN
2729: ROLLBACK TO packunpack_container_pub;
2730: x_return_status := fnd_api.g_ret_sts_unexp_error;
2731:

Line 2732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2728: WHEN OTHERS THEN
2729: ROLLBACK TO packunpack_container_pub;
2730: x_return_status := fnd_api.g_ret_sts_unexp_error;
2731:
2732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2733: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2734: END IF;
2735:
2736: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2733: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2729: ROLLBACK TO packunpack_container_pub;
2730: x_return_status := fnd_api.g_ret_sts_unexp_error;
2731:
2732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2733: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2734: END IF;
2735:
2736: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2737: END packunpack_container;

Line 2736: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2733: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2734: END IF;
2735:
2736: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2737: END packunpack_container;
2738:
2739: PROCEDURE pack_prepack_container(
2740: p_api_version IN NUMBER,

Line 2803: fnd_msg_pub.ADD;

2799:
2800: -- Standard call to check for call compatibility.
2801: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2802: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2803: fnd_msg_pub.ADD;
2804: RAISE fnd_api.g_exc_unexpected_error;
2805: END IF;
2806:
2807: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2809: fnd_msg_pub.initialize;

2805: END IF;
2806:
2807: -- Initialize message list if p_init_msg_list is set to TRUE.
2808: IF fnd_api.to_boolean(p_init_msg_list) THEN
2809: fnd_msg_pub.initialize;
2810: END IF;
2811:
2812: -- Initialize API return status to success
2813: x_return_status := fnd_api.g_ret_sts_success;

Line 2835: fnd_msg_pub.ADD;

2831: IF (l_debug = 1) THEN
2832: mdebug(p_lpn_id || 'is an invalid lpn_id', 1);
2833: END IF;
2834: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2835: fnd_msg_pub.ADD;
2836: RAISE fnd_api.g_exc_error;
2837: END IF;
2838:
2839: /* Validate Organization ID */

Line 2848: fnd_msg_pub.ADD;

2844: IF (l_debug = 1) THEN
2845: mdebug(p_organization_id || 'is not a valid org_id', 1);
2846: END IF;
2847: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
2848: fnd_msg_pub.ADD;
2849: RAISE fnd_api.g_exc_error;
2850: END IF;
2851:
2852: /* Validate Content Item */

Line 2862: fnd_msg_pub.ADD;

2858: IF (l_debug = 1) THEN
2859: mdebug(p_content_item_id || 'is not a valid content item id', 1);
2860: END IF;
2861: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_CONTENT_ITEM');
2862: fnd_msg_pub.ADD;
2863: RAISE fnd_api.g_exc_error;
2864: END IF;
2865: END IF;
2866:

Line 2878: fnd_msg_pub.ADD;

2874: IF (l_debug = 1) THEN
2875: mdebug(p_revision || ' is an invalid revision', 1);
2876: END IF;
2877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_REV');
2878: fnd_msg_pub.ADD;
2879: RAISE fnd_api.g_exc_error;
2880: END IF;
2881: ELSE
2882: IF (l_debug = 1) THEN

Line 2886: fnd_msg_pub.ADD;

2882: IF (l_debug = 1) THEN
2883: mdebug('Mission required revision', 1);
2884: END IF;
2885: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_REV');
2886: fnd_msg_pub.ADD;
2887: RAISE fnd_api.g_exc_error;
2888: END IF;
2889: END IF;
2890: END IF;

Line 2901: fnd_msg_pub.ADD;

2897: IF (l_debug = 1) THEN
2898: mdebug('Missing required lot', 1);
2899: END IF;
2900: fnd_message.set_name('WMS', 'WMS_CONT_MISS_REQ_LOT');
2901: fnd_msg_pub.ADD;
2902: RAISE fnd_api.g_exc_error;
2903: END IF;
2904: END IF;
2905: END IF;

Line 2917: fnd_msg_pub.ADD;

2913: IF (l_debug = 1) THEN
2914: mdebug('Requested a negative item qty', 1);
2915: END IF;
2916: fnd_message.set_name('WMS', 'WMS_CONT_NEG_ITEM_QTY');
2917: fnd_msg_pub.ADD;
2918: RAISE fnd_api.g_exc_error;
2919: ELSE
2920: l_quantity := p_quantity;
2921: END IF;

Line 2938: fnd_msg_pub.ADD;

2934: IF (l_debug = 1) THEN
2935: mdebug('Invalid serial number given in range', 1);
2936: END IF;
2937: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2938: fnd_msg_pub.ADD;
2939: RAISE fnd_api.g_exc_error;
2940: END IF;
2941:
2942: -- Check that in the case of a range of serial numbers, that the

Line 2950: fnd_msg_pub.ADD;

2946: IF (l_debug = 1) THEN
2947: mdebug('Serial range quantity '||l_quantity||' not the same as given qty '||p_quantity, G_ERROR);
2948: END IF;
2949: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_X_QTY');
2950: fnd_msg_pub.ADD;
2951: RAISE fnd_api.g_exc_error;
2952: END IF;
2953: END IF;
2954:

Line 2990: fnd_msg_pub.ADD;

2986: IF (l_debug = 1) THEN
2987: mdebug(l_current_serial || ' is not a valid serial number', 1);
2988: END IF;
2989: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2990: fnd_msg_pub.ADD;
2991: RAISE fnd_api.g_exc_error;
2992: END IF;
2993:
2994: CLOSE serial_validation_cursor;

Line 3023: fnd_msg_pub.ADD;

3019: IF (l_debug = 1) THEN
3020: mdebug('Missing require serial number', 1);
3021: END IF;
3022: fnd_message.set_name('WMS', 'WMS_CONT_MISS_SER_NUM');
3023: fnd_msg_pub.ADD;
3024: RAISE fnd_api.g_exc_error;
3025: END IF;
3026: END IF;
3027: END IF;

Line 3038: fnd_msg_pub.ADD;

3034: IF (l_debug = 1) THEN
3035: mdebug(p_uom || ' is an invalid UOM', 1);
3036: END IF;
3037: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_UOM');
3038: fnd_msg_pub.ADD;
3039: RAISE fnd_api.g_exc_error;
3040: END IF;
3041: END IF;
3042:

Line 3049: fnd_msg_pub.ADD;

3045: IF (l_debug = 1) THEN
3046: mdebug(p_operation || ' is an invalid operation type', 1);
3047: END IF;
3048: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_OPERATION');
3049: fnd_msg_pub.ADD;
3050: RAISE fnd_api.g_exc_error;
3051: END IF;
3052: END IF;
3053: /* End of Input Validation */

Line 3088: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3084: END IF;
3085:
3086: -- Standard call to get message count and if count is 1,
3087: -- get message info.
3088: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3089: EXCEPTION
3090: WHEN fnd_api.g_exc_error THEN
3091: ROLLBACK TO pack_prepack_container_pub;
3092: x_return_status := fnd_api.g_ret_sts_error;

Line 3093: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3089: EXCEPTION
3090: WHEN fnd_api.g_exc_error THEN
3091: ROLLBACK TO pack_prepack_container_pub;
3092: x_return_status := fnd_api.g_ret_sts_error;
3093: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3094: WHEN fnd_api.g_exc_unexpected_error THEN
3095: ROLLBACK TO pack_prepack_container_pub;
3096: x_return_status := fnd_api.g_ret_sts_unexp_error;
3097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3093: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3094: WHEN fnd_api.g_exc_unexpected_error THEN
3095: ROLLBACK TO pack_prepack_container_pub;
3096: x_return_status := fnd_api.g_ret_sts_unexp_error;
3097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3098: WHEN OTHERS THEN
3099: ROLLBACK TO pack_prepack_container_pub;
3100: x_return_status := fnd_api.g_ret_sts_unexp_error;
3101:

Line 3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3098: WHEN OTHERS THEN
3099: ROLLBACK TO pack_prepack_container_pub;
3100: x_return_status := fnd_api.g_ret_sts_unexp_error;
3101:
3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3104: END IF;
3105:
3106: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3099: ROLLBACK TO pack_prepack_container_pub;
3100: x_return_status := fnd_api.g_ret_sts_unexp_error;
3101:
3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3104: END IF;
3105:
3106: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3107: END pack_prepack_container;

Line 3106: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3103: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3104: END IF;
3105:
3106: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3107: END pack_prepack_container;
3108:
3109: -- ----------------------------------------------------------------------------------
3110: -- ----------------------------------------------------------------------------------

Line 3220: fnd_msg_pub.ADD;

3216:
3217: -- Standard call to check for call compatibility.
3218: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3219: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3220: fnd_msg_pub.ADD;
3221: RAISE fnd_api.g_exc_unexpected_error;
3222: END IF;
3223:
3224: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3226: fnd_msg_pub.initialize;

3222: END IF;
3223:
3224: -- Initialize message list if p_init_msg_list is set to TRUE.
3225: IF fnd_api.to_boolean(p_init_msg_list) THEN
3226: fnd_msg_pub.initialize;
3227: END IF;
3228:
3229: -- Initialize API return status to success
3230: x_return_status := fnd_api.g_ret_sts_success;

Line 3280: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3276: END IF;
3277:
3278: -- Standard call to get message count and if count is 1,
3279: -- get message info.
3280: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3281: EXCEPTION
3282: WHEN fnd_api.g_exc_error THEN
3283: ROLLBACK TO prepack_lpn_cp_pub;
3284: x_return_status := fnd_api.g_ret_sts_error;

Line 3285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3281: EXCEPTION
3282: WHEN fnd_api.g_exc_error THEN
3283: ROLLBACK TO prepack_lpn_cp_pub;
3284: x_return_status := fnd_api.g_ret_sts_error;
3285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3286: WHEN fnd_api.g_exc_unexpected_error THEN
3287: ROLLBACK TO prepack_lpn_cp_pub;
3288: x_return_status := fnd_api.g_ret_sts_unexp_error;
3289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3286: WHEN fnd_api.g_exc_unexpected_error THEN
3287: ROLLBACK TO prepack_lpn_cp_pub;
3288: x_return_status := fnd_api.g_ret_sts_unexp_error;
3289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3290: WHEN OTHERS THEN
3291: ROLLBACK TO prepack_lpn_cp_pub;
3292: x_return_status := fnd_api.g_ret_sts_unexp_error;
3293:

Line 3294: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3290: WHEN OTHERS THEN
3291: ROLLBACK TO prepack_lpn_cp_pub;
3292: x_return_status := fnd_api.g_ret_sts_unexp_error;
3293:
3294: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3296: END IF;
3297:
3298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3291: ROLLBACK TO prepack_lpn_cp_pub;
3292: x_return_status := fnd_api.g_ret_sts_unexp_error;
3293:
3294: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3296: END IF;
3297:
3298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3299: END prepack_lpn_cp;

Line 3298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3294: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3296: END IF;
3297:
3298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3299: END prepack_lpn_cp;
3300:
3301: -- ----------------------------------------------------------------------------------
3302: -- ----------------------------------------------------------------------------------

Line 3379: fnd_msg_pub.ADD;

3375: BEGIN
3376: -- Standard call to check for call compatibility.
3377: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3378: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3379: fnd_msg_pub.ADD;
3380: RAISE fnd_api.g_exc_error;
3381: END IF;
3382:
3383: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3385: fnd_msg_pub.initialize;

3381: END IF;
3382:
3383: -- Initialize message list if p_init_msg_list is set to TRUE.
3384: IF fnd_api.to_boolean(p_init_msg_list) THEN
3385: fnd_msg_pub.initialize;
3386: END IF;
3387:
3388: -- Initialize API return status to success
3389: x_return_status := fnd_api.g_ret_sts_success;

Line 3405: fnd_msg_pub.ADD;

3401: IF ( l_debug = 1 ) THEN
3402: mdebug(p_organization_id || ' is not a valid org id', G_ERROR);
3403: END IF;
3404: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
3405: fnd_msg_pub.ADD;
3406: RAISE fnd_api.g_exc_error;
3407: END IF;
3408:
3409: l_progress := '200';

Line 3419: FND_MSG_PUB.ADD;

3415: IF ( l_debug = 1 ) THEN
3416: mdebug(p_outermost_lpn_id || ' is an invalid lpn id', G_ERROR);
3417: END IF;
3418: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3419: FND_MSG_PUB.ADD;
3420: RAISE FND_API.G_EXC_ERROR;
3421: END IF;
3422:
3423: l_progress := '300';

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

3451: END IF;
3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3453: END IF;
3454:
3455: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3456: EXCEPTION
3457: WHEN FND_API.G_EXC_ERROR THEN
3458: x_return_status := fnd_api.g_ret_sts_error;
3459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

3455: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3456: EXCEPTION
3457: WHEN FND_API.G_EXC_ERROR THEN
3458: x_return_status := fnd_api.g_ret_sts_error;
3459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3460: IF (l_debug = 1) THEN
3461: FOR i in 1..x_msg_count LOOP
3462: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
3463: END LOOP;

Line 3462: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

3458: x_return_status := fnd_api.g_ret_sts_error;
3459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3460: IF (l_debug = 1) THEN
3461: FOR i in 1..x_msg_count LOOP
3462: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
3463: END LOOP;
3464: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), 1);
3465: mdebug('msg: '||l_msgdata, 1);
3466: END IF;

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

3465: mdebug('msg: '||l_msgdata, 1);
3466: END IF;
3467: WHEN OTHERS THEN
3468: x_return_status := fnd_api.g_ret_sts_unexp_error;
3469: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3470: IF (l_debug = 1) THEN
3471: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), 1);
3472: END IF;
3473: END Merge_Up_LPN;

Line 3503: fnd_msg_pub.ADD;

3499: BEGIN
3500: -- Standard call to check for call compatibility.
3501: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3502: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3503: fnd_msg_pub.ADD;
3504: RAISE fnd_api.g_exc_error;
3505: END IF;
3506:
3507: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3509: fnd_msg_pub.initialize;

3505: END IF;
3506:
3507: -- Initialize message list if p_init_msg_list is set to TRUE.
3508: IF fnd_api.to_boolean(p_init_msg_list) THEN
3509: fnd_msg_pub.initialize;
3510: END IF;
3511:
3512: -- Initialize API return status to success
3513: x_return_status := fnd_api.g_ret_sts_success;

Line 3529: fnd_msg_pub.ADD;

3525: IF ( l_debug = 1 ) THEN
3526: mdebug(p_organization_id || ' is not a valid org id', G_ERROR);
3527: END IF;
3528: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
3529: fnd_msg_pub.ADD;
3530: RAISE fnd_api.g_exc_error;
3531: END IF;
3532:
3533: l_progress := '200';

Line 3543: FND_MSG_PUB.ADD;

3539: IF ( l_debug = 1 ) THEN
3540: mdebug(p_outermost_lpn_id || ' is an invalid lpn id', G_ERROR);
3541: END IF;
3542: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3543: FND_MSG_PUB.ADD;
3544: RAISE FND_API.G_EXC_ERROR;
3545: END IF;
3546:
3547: l_progress := '300';

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

3575: END IF;
3576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3577: END IF;
3578:
3579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3580: EXCEPTION
3581: WHEN FND_API.G_EXC_ERROR THEN
3582: x_return_status := fnd_api.g_ret_sts_error;
3583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

3579: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3580: EXCEPTION
3581: WHEN FND_API.G_EXC_ERROR THEN
3582: x_return_status := fnd_api.g_ret_sts_error;
3583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3584: IF (l_debug = 1) THEN
3585: FOR i in 1..x_msg_count LOOP
3586: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
3587: END LOOP;

Line 3586: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

3582: x_return_status := fnd_api.g_ret_sts_error;
3583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3584: IF (l_debug = 1) THEN
3585: FOR i in 1..x_msg_count LOOP
3586: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
3587: END LOOP;
3588: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), 1);
3589: mdebug('msg: '||l_msgdata, 1);
3590: END IF;

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

3589: mdebug('msg: '||l_msgdata, 1);
3590: END IF;
3591: WHEN OTHERS THEN
3592: x_return_status := fnd_api.g_ret_sts_unexp_error;
3593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3594: IF (l_debug = 1) THEN
3595: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), 1);
3596: END IF;
3597: END Break_Down_LPN;

Line 3627: fnd_msg_pub.ADD;

3623: BEGIN
3624: -- Standard call to check for call compatibility.
3625: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3626: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3627: fnd_msg_pub.ADD;
3628: RAISE fnd_api.g_exc_error;
3629: END IF;
3630:
3631: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3633: fnd_msg_pub.initialize;

3629: END IF;
3630:
3631: -- Initialize message list if p_init_msg_list is set to TRUE.
3632: IF fnd_api.to_boolean(p_init_msg_list) THEN
3633: fnd_msg_pub.initialize;
3634: END IF;
3635:
3636: -- Initialize API return status to success
3637: x_return_status := fnd_api.g_ret_sts_success;

Line 3653: fnd_msg_pub.ADD;

3649: IF ( l_debug = 1 ) THEN
3650: mdebug(p_organization_id || ' is not a valid org id', G_ERROR);
3651: END IF;
3652: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
3653: fnd_msg_pub.ADD;
3654: RAISE fnd_api.g_exc_error;
3655: END IF;
3656:
3657: l_progress := '200';

Line 3667: FND_MSG_PUB.ADD;

3663: IF ( l_debug = 1 ) THEN
3664: mdebug(p_outermost_lpn_id || ' is an invalid lpn id', G_ERROR);
3665: END IF;
3666: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: END IF;
3670:
3671: l_progress := '300';

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

3699: END IF;
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: END IF;
3702:
3703: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3704: EXCEPTION
3705: WHEN FND_API.G_EXC_ERROR THEN
3706: x_return_status := fnd_api.g_ret_sts_error;
3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

3703: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3704: EXCEPTION
3705: WHEN FND_API.G_EXC_ERROR THEN
3706: x_return_status := fnd_api.g_ret_sts_error;
3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3708: IF (l_debug = 1) THEN
3709: FOR i in 1..x_msg_count LOOP
3710: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
3711: END LOOP;

Line 3710: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

3706: x_return_status := fnd_api.g_ret_sts_error;
3707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3708: IF (l_debug = 1) THEN
3709: FOR i in 1..x_msg_count LOOP
3710: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
3711: END LOOP;
3712: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), 1);
3713: mdebug('msg: '||l_msgdata, 1);
3714: END IF;

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

3713: mdebug('msg: '||l_msgdata, 1);
3714: END IF;
3715: WHEN OTHERS THEN
3716: x_return_status := fnd_api.g_ret_sts_unexp_error;
3717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3718: IF (l_debug = 1) THEN
3719: mdebug(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), 1);
3720: END IF;
3721: END Initialize_LPN;

Line 3916: FND_MSG_PUB.ADD;

3912:
3913: EXCEPTION
3914: WHEN l_transactions_pending THEN
3915: FND_MESSAGE.SET_NAME('WMS', 'WMS_PENDING_TRX_RECORDS');
3916: FND_MSG_PUB.ADD;
3917: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3918: x_return_status := 'E';
3919: WHEN l_invalid_lpn_context THEN
3920: FND_MESSAGE.SET_NAME('WMS', 'WMS_WRONG_TO_LPN_CONTEXT');

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

3913: EXCEPTION
3914: WHEN l_transactions_pending THEN
3915: FND_MESSAGE.SET_NAME('WMS', 'WMS_PENDING_TRX_RECORDS');
3916: FND_MSG_PUB.ADD;
3917: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3918: x_return_status := 'E';
3919: WHEN l_invalid_lpn_context THEN
3920: FND_MESSAGE.SET_NAME('WMS', 'WMS_WRONG_TO_LPN_CONTEXT');
3921: FND_MSG_PUB.ADD;

Line 3921: FND_MSG_PUB.ADD;

3917: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3918: x_return_status := 'E';
3919: WHEN l_invalid_lpn_context THEN
3920: FND_MESSAGE.SET_NAME('WMS', 'WMS_WRONG_TO_LPN_CONTEXT');
3921: FND_MSG_PUB.ADD;
3922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3923: x_return_status := 'E';
3924: WHEN l_lpn_not_found THEN
3925: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_NOTFOUND');

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

3918: x_return_status := 'E';
3919: WHEN l_invalid_lpn_context THEN
3920: FND_MESSAGE.SET_NAME('WMS', 'WMS_WRONG_TO_LPN_CONTEXT');
3921: FND_MSG_PUB.ADD;
3922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3923: x_return_status := 'E';
3924: WHEN l_lpn_not_found THEN
3925: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_NOTFOUND');
3926: FND_MSG_PUB.ADD;

Line 3926: FND_MSG_PUB.ADD;

3922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3923: x_return_status := 'E';
3924: WHEN l_lpn_not_found THEN
3925: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_NOTFOUND');
3926: FND_MSG_PUB.ADD;
3927: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3928: x_return_status := 'E';
3929: WHEN OTHERS THEN
3930: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');

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

3923: x_return_status := 'E';
3924: WHEN l_lpn_not_found THEN
3925: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_NOTFOUND');
3926: FND_MSG_PUB.ADD;
3927: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3928: x_return_status := 'E';
3929: WHEN OTHERS THEN
3930: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
3931: FND_MSG_PUB.ADD;

Line 3931: FND_MSG_PUB.ADD;

3927: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3928: x_return_status := 'E';
3929: WHEN OTHERS THEN
3930: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
3931: FND_MSG_PUB.ADD;
3932: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3933: x_return_status := 'E';
3934: END validate_lpn;
3935:

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

3928: x_return_status := 'E';
3929: WHEN OTHERS THEN
3930: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
3931: FND_MSG_PUB.ADD;
3932: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3933: x_return_status := 'E';
3934: END validate_lpn;
3935:
3936:

Line 4004: fnd_msg_pub.initialize;

4000: mdebug('p_clear_containter_item_id : '||p_clear_containter_item_id);
4001: END IF;
4002:
4003: IF p_init_msg_list ='Y' THEN
4004: fnd_msg_pub.initialize;
4005: END IF;
4006:
4007: IF NOT FND_API.Compatible_API_Call( l_api_version
4008: , p_api_version

Line 4591: FND_MSG_PUB.ADD;

4587: EXCEPTION
4588:
4589: WHEN l_invalid_org THEN
4590: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
4591: FND_MSG_PUB.ADD;
4592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4593: x_return_status := 'E';
4594: WHEN l_invalid_lpn THEN
4595: x_return_status := 'E';

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

4588:
4589: WHEN l_invalid_org THEN
4590: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_ORG');
4591: FND_MSG_PUB.ADD;
4592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4593: x_return_status := 'E';
4594: WHEN l_invalid_lpn THEN
4595: x_return_status := 'E';
4596: WHEN OTHERS THEN

Line 4598: FND_MSG_PUB.ADD;

4594: WHEN l_invalid_lpn THEN
4595: x_return_status := 'E';
4596: WHEN OTHERS THEN
4597: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
4598: FND_MSG_PUB.ADD;
4599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4600: x_return_status := 'E';
4601: ROLLBACK TO REUSE_LPN_SP;
4602: END REUSE_LPNS;

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

4595: x_return_status := 'E';
4596: WHEN OTHERS THEN
4597: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
4598: FND_MSG_PUB.ADD;
4599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4600: x_return_status := 'E';
4601: ROLLBACK TO REUSE_LPN_SP;
4602: END REUSE_LPNS;
4603: -- End of package