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.INV_LOC_WMS_PUB dependencies on FND_MSG_PUB

Line 166: fnd_msg_pub.ADD;

162: --DBMS_output.put_line('more params passed than needed');
163: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
164: fnd_message.set_token('CONTEXT', 'NULL');
165: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
166: fnd_msg_pub.ADD;
167: RAISE fnd_api.g_exc_error;
168: END IF;
169:
170: FOR i IN 1 .. l_nsegments LOOP

Line 182: fnd_msg_pub.ADD;

178: THEN
179: --DBMS_output.put_line('y r we here');
180: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
181: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
182: fnd_msg_pub.ADD;
183: RAISE fnd_api.g_exc_error;
184: END IF;
185: ELSE
186: --DBMS_output.put_line('This segment is not required');

Line 255: fnd_msg_pub.ADD;

251: NOT p_attributes_tbl.EXISTS(col))
252: THEN
253: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
254: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
255: fnd_msg_pub.ADD;
256: RAISE fnd_api.g_exc_error;
257: --DBMS_output.put_line('Req segment is not populated');
258: END IF;
259: END IF;

Line 313: fnd_msg_pub.ADD;

309: WHILE e < 5001
310: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
311: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
312: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
313: fnd_msg_pub.ADD;
314: --DBMS_output.put_line(SUBSTR(error_msg, s, e));
315: s := s + 200;
316: e := e + 200;
317: END LOOP;

Line 320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

316: e := e + 200;
317: END LOOP;
318:
319: ROLLBACK TO get_lot_attr_information;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
321: WHEN fnd_api.g_exc_error THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: ROLLBACK TO get_lot_attr_information;
324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

324: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: ROLLBACK TO get_lot_attr_information;
328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: ROLLBACK TO get_lot_attr_information;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: ROLLBACK TO get_lot_attr_information;
332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
333: --DBMS_output.put_line('Error ' || SQLERRM);
334: END validate_loc_attr_info;
335:
336:

Line 560: fnd_msg_pub.ADD;

556: WHERE organization_id = l_organization_id;
557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
560: fnd_msg_pub.ADD;
561: RAISE fnd_api.g_exc_error;
562: END;
563:
564: ELSE -- p_organization_id is NULL

Line 569: fnd_msg_pub.ADD;

565:
566: IF p_organization_code IS NULL THEN
567:
568: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
569: fnd_msg_pub.ADD;
570: RAISE fnd_api.g_exc_error;
571:
572: ELSE -- p_organization_code is NULL
573:

Line 586: fnd_msg_pub.ADD;

582:
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
586: fnd_msg_pub.ADD;
587: RAISE fnd_api.g_exc_error;
588: END;
589:
590: END IF; -- p_organization_code is NULL

Line 607: fnd_msg_pub.ADD;

603: */
604: IF p_subinventory_code IS NULL THEN
605:
606: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
607: fnd_msg_pub.ADD;
608: RAISE fnd_api.g_exc_error;
609:
610: ELSE -- p_subinventory_code is NULL
611:

Line 630: fnd_msg_pub.ADD;

626: EXCEPTION
627:
628: WHEN NO_DATA_FOUND THEN
629: fnd_message.set_name('INV', 'INVALID_SUB');
630: fnd_msg_pub.ADD;
631: RAISE fnd_api.g_exc_error;
632:
633: END;
634:

Line 644: fnd_msg_pub.ADD;

640: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
641: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR -- 4911279
642: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
643: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
644: fnd_msg_pub.ADD;
645: RAISE fnd_api.g_exc_error;
646: END IF;
647:
648: /*

Line 660: fnd_msg_pub.ADD;

656:
657: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
658:
659: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
660: fnd_msg_pub.ADD;
661: RAISE fnd_api.g_exc_error;
662:
663: END IF;
664:

Line 686: fnd_msg_pub.ADD;

682: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
683:
684: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
685: fnd_message.set_token('LOCATOR', l_locator);
686: fnd_msg_pub.ADD;
687: RAISE fnd_api.g_exc_error;
688:
689: EXCEPTION
690: WHEN NO_DATA_FOUND THEN

Line 710: fnd_msg_pub.ADD;

706: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
707:
708: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
709: fnd_message.set_token('LOCATOR', l_locator);
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_error;
712:
713: EXCEPTION
714: WHEN NO_DATA_FOUND THEN

Line 732: fnd_msg_pub.ADD;

728:
729: IF p_concatenated_segments IS NULL THEN
730:
731: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
732: fnd_msg_pub.ADD;
733: RAISE fnd_api.g_exc_error;
734:
735: END IF;
736:

Line 749: fnd_msg_pub.add;

745: AND ROWNUM < 2;
746:
747: x_locator_exists:= 'Y';
748: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
749: fnd_msg_pub.add;
750: fnd_msg_pub.count_and_get
751: ( p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data

Line 750: fnd_msg_pub.count_and_get

746:
747: x_locator_exists:= 'Y';
748: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
749: fnd_msg_pub.add;
750: fnd_msg_pub.count_and_get
751: ( p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );

Line 778: fnd_msg_pub.ADD;

774: IF l_val = TRUE THEN
775: x_locator_exists := 'Y';
776: x_inventory_location_id := fnd_flex_keyval.combination_id;
777: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
778: fnd_msg_pub.ADD;
779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
780: RETURN;
781: END IF;
782: END;

Line 779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

775: x_locator_exists := 'Y';
776: x_inventory_location_id := fnd_flex_keyval.combination_id;
777: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
778: fnd_msg_pub.ADD;
779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
780: RETURN;
781: END IF;
782: END;
783:

Line 798: fnd_msg_pub.ADD;

794: AND enabled_flag = 1;
795: EXCEPTION
796: WHEN NO_DATA_FOUND THEN
797: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
798: fnd_msg_pub.ADD;
799: RAISE fnd_api.g_exc_error;
800: END;
801: END IF;
802:

Line 812: fnd_msg_pub.ADD;

808: WHERE uom_code = p_location_weight_uom_code;
809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN
811: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
812: fnd_msg_pub.ADD;
813: RAISE fnd_api.g_exc_error;
814: END;
815: END IF;
816:

Line 829: fnd_msg_pub.ADD;

825: WHERE uom_code = p_volume_uom_code;
826: EXCEPTION
827: WHEN NO_DATA_FOUND THEN
828: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');
829: fnd_msg_pub.ADD;
830: RAISE fnd_api.g_exc_error;
831: END;
832: END IF;
833:

Line 844: fnd_msg_pub.ADD;

840: WHERE uom_code = p_pick_uom_code;
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');
844: fnd_msg_pub.ADD;
845: RAISE fnd_api.g_exc_error;
846: END;
847: END IF;
848:

Line 861: fnd_msg_pub.ADD;

857: WHERE uom_code = p_dimension_uom_code;
858: EXCEPTION
859: WHEN NO_DATA_FOUND THEN
860: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
861: fnd_msg_pub.ADD;
862: RAISE fnd_api.g_exc_error;
863: END;
864: END IF;
865:

Line 931: fnd_msg_pub.ADD;

927: --DBMS_output.put_line('Validity check passed ');
928: IF (l_keystat_val = FALSE) THEN
929: --DBMS_output.put_line('validate segment failed ');
930: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
931: fnd_msg_pub.ADD;
932: RAISE fnd_api.g_exc_unexpected_error;
933: ELSE
934: x_inventory_location_id := fnd_flex_keyval.combination_id;
935:

Line 973: fnd_msg_pub.ADD;

969: -- END IF;
970: ELSE
971: --DBMS_output.put_line('Wms installed check failed ');
972: fnd_message.set_name('WMS', 'WMS_INSTALL_CHK_ERROR');
973: fnd_msg_pub.ADD;
974: RAISE fnd_api.g_exc_unexpected_error;
975: END IF;
976:
977: --Bug Number 5606275

Line 997: fnd_msg_pub.ADD;

993: IF(l_project_reference_enabled = 'Y') THEN
994: IF( l_project_control_level =2 AND l_segment20 IS NULL AND l_segment19 is NOT NULL) THEN
995:
996: fnd_message.set_name('INV', 'INV_TASK_NUM_INVALID');
997: fnd_msg_pub.ADD;
998: RAISE fnd_api.g_exc_error;
999: END IF;
1000: END IF;
1001: /*bug14298387,added the validation for logic locator without the physical locator id passed*/

Line 1005: fnd_msg_pub.ADD;

1001: /*bug14298387,added the validation for logic locator without the physical locator id passed*/
1002: IF(l_project_reference_enabled = 'Y' AND (l_segment19 IS NOT NULL OR l_segment20 IS NOT NULL)) THEN
1003: IF (Nvl(p_physical_location_id,-1) = -1) THEN
1004: fnd_message.set_name('INV', 'INV_PHY_LOCINVALID');
1005: fnd_msg_pub.ADD;
1006: RAISE fnd_api.g_exc_error;
1007: ELSE
1008: --validate the phy locator id
1009: l_phy_loc_concat_segments := INV_PROJECT.GET_LOCSEGS(p_physical_location_id,l_organization_id);

Line 1012: fnd_msg_pub.ADD;

1008: --validate the phy locator id
1009: l_phy_loc_concat_segments := INV_PROJECT.GET_LOCSEGS(p_physical_location_id,l_organization_id);
1010: IF (l_phy_loc_concat_segments <> l_physical_concat_seg) THEN
1011: fnd_message.set_name('INV', 'INV_PHY_LOCINVALID');
1012: fnd_msg_pub.ADD;
1013: RAISE fnd_api.g_exc_error;
1014: END IF;
1015: END IF;
1016: END IF;

Line 1101: fnd_msg_pub.ADD;

1097:
1098: IF l_return_status = 'E' THEN
1099: --DBMS_output.put_line('Error from validate_loc_attr_info');
1100: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1101: fnd_msg_pub.ADD;
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF l_return_status = 'U' THEN
1104: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1105: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');

Line 1106: fnd_msg_pub.ADD;

1102: RAISE fnd_api.g_exc_error;
1103: ELSIF l_return_status = 'U' THEN
1104: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1105: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1106: fnd_msg_pub.ADD;
1107: RAISE fnd_api.g_exc_unexpected_error;
1108: END IF;
1109: /* End locator DFF attributes validation */
1110:

Line 1182: fnd_msg_pub.ADD;

1178: END IF;
1179: END IF; -- (l_keystat_val = FALSE)
1180: ELSE
1181: fnd_message.set_name('INV', 'INV_LOC_BELONG_TO_OTH_SUB');
1182: fnd_msg_pub.ADD;
1183: RAISE fnd_api.g_exc_error;
1184: END IF; -- (l_validility = passed)
1185:
1186: EXCEPTION

Line 1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1187: WHEN fnd_api.g_exc_error THEN
1188: x_return_status := 'E';
1189: ROLLBACK TO locator_insert;
1190: debug(l_procedure_name ||' Expected Error ');
1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1192: WHEN fnd_api.g_exc_unexpected_error THEN
1193: x_return_status := 'U';
1194: ROLLBACK TO locator_insert;
1195: debug(l_procedure_name ||' Unxpected Error ');

Line 1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1192: WHEN fnd_api.g_exc_unexpected_error THEN
1193: x_return_status := 'U';
1194: ROLLBACK TO locator_insert;
1195: debug(l_procedure_name ||' Unxpected Error ');
1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1197: WHEN OTHERS THEN
1198: x_return_status := 'U';
1199: --DBMS_output.put_line('In others '||sqlerrm);
1200: ROLLBACK TO locator_insert;

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

1198: x_return_status := 'U';
1199: --DBMS_output.put_line('In others '||sqlerrm);
1200: ROLLBACK TO locator_insert;
1201:
1202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1204: END IF;
1205: debug(l_procedure_name ||' Others '||SQLERRM);
1206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);

1199: --DBMS_output.put_line('In others '||sqlerrm);
1200: ROLLBACK TO locator_insert;
1201:
1202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1204: END IF;
1205: debug(l_procedure_name ||' Others '||SQLERRM);
1206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1207: END create_locator;

Line 1206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1204: END IF;
1205: debug(l_procedure_name ||' Others '||SQLERRM);
1206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1207: END create_locator;
1208:
1209: /*
1210: ** ---------------------------------------------------------------------------

Line 1420: fnd_msg_pub.ADD;

1416: WHERE organization_id = l_organization_id;
1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN
1419: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1420: fnd_msg_pub.ADD;
1421: RAISE fnd_api.g_exc_error;
1422: END;
1423:
1424: ELSE -- p_organization_id IS NULL

Line 1429: fnd_msg_pub.ADD;

1425:
1426: IF p_organization_code IS NULL THEN
1427:
1428: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1429: fnd_msg_pub.ADD;
1430: RAISE fnd_api.g_exc_error;
1431:
1432: ELSE -- p_organization_code is NULL
1433:

Line 1444: fnd_msg_pub.ADD;

1440: WHERE organization_code = p_organization_code;
1441: EXCEPTION
1442: WHEN NO_DATA_FOUND THEN
1443: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1444: fnd_msg_pub.ADD;
1445: RAISE fnd_api.g_exc_error;
1446: END;
1447:
1448: END IF; -- p_organization_code is NULL

Line 1460: fnd_msg_pub.ADD;

1456:
1457: IF (p_concatenated_segments IS NULL AND p_inventory_location_id IS NULL) THEN
1458:
1459: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1460: fnd_msg_pub.ADD;
1461: RAISE fnd_api.g_exc_error;
1462:
1463: ELSIF p_concatenated_segments IS NOT NULL AND p_inventory_location_id IS NULL THEN
1464:

Line 1487: fnd_msg_pub.ADD;

1483: );
1484:
1485: IF l_val = FALSE THEN
1486: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1487: fnd_msg_pub.ADD;
1488: RAISE fnd_api.g_exc_error;
1489: ELSE
1490: l_inventory_location_id := fnd_flex_keyval.combination_id;
1491: END IF;

Line 1510: fnd_msg_pub.ADD;

1506: IF (p_inventory_location_type <> fnd_api.g_miss_num AND
1507: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1508:
1509: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1510: fnd_msg_pub.ADD;
1511: RAISE fnd_api.g_exc_error;
1512:
1513: END IF;
1514:

Line 1530: fnd_msg_pub.ADD;

1526: AND msi.organization_id = l_organization_id;
1527: EXCEPTION
1528: WHEN NO_DATA_FOUND THEN
1529: fnd_message.set_name('INV', 'INVALID_SUB');
1530: fnd_msg_pub.ADD;
1531: RAISE fnd_api.g_exc_error;
1532: END;
1533:
1534: -- If the sub is of type 'Storage', then the locator cannot be of type 'Receiving'.

Line 1540: fnd_msg_pub.ADD;

1536: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
1537: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR --4911279
1538: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
1539: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1540: fnd_msg_pub.ADD;
1541: RAISE fnd_api.g_exc_error;
1542: END IF;
1543: END IF;
1544:

Line 1581: fnd_msg_pub.ADD;

1577:
1578: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
1579:
1580: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
1581: fnd_msg_pub.ADD;
1582: RAISE fnd_api.g_exc_error;
1583:
1584: END IF;
1585:

Line 1604: fnd_msg_pub.ADD;

1600: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1601:
1602: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1603: fnd_message.set_token('LOCATOR', l_locator);
1604: fnd_msg_pub.ADD;
1605: RAISE fnd_api.g_exc_error;
1606:
1607: EXCEPTION
1608: WHEN NO_DATA_FOUND THEN

Line 1627: fnd_msg_pub.ADD;

1623: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1624:
1625: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1626: fnd_message.set_token('LOCATOR', l_locator);
1627: fnd_msg_pub.ADD;
1628: RAISE fnd_api.g_exc_error;
1629:
1630: EXCEPTION
1631: WHEN NO_DATA_FOUND THEN

Line 1655: fnd_msg_pub.ADD;

1651: WHERE uom_code = p_location_weight_uom_code;
1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN
1654: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1655: fnd_msg_pub.ADD;
1656: RAISE fnd_api.g_exc_error;
1657: END;
1658: END IF;
1659:

Line 1673: fnd_msg_pub.ADD;

1669: WHERE uom_code = p_volume_uom_code;
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1673: fnd_msg_pub.ADD;
1674: RAISE fnd_api.g_exc_error;
1675: END;
1676: END IF;
1677:

Line 1690: fnd_msg_pub.ADD;

1686: WHERE uom_code = p_pick_uom_code;
1687: EXCEPTION
1688: WHEN NO_DATA_FOUND THEN
1689: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');
1690: fnd_msg_pub.ADD;
1691: RAISE fnd_api.g_exc_error;
1692: END;
1693: END IF;
1694:

Line 1708: fnd_msg_pub.ADD;

1704: WHERE uom_code = p_dimension_uom_code;
1705: EXCEPTION
1706: WHEN NO_DATA_FOUND THEN
1707: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
1708: fnd_msg_pub.ADD;
1709: RAISE fnd_api.g_exc_error;
1710: END;
1711: END IF;
1712:

Line 1726: fnd_msg_pub.ADD;

1722: AND enabled_flag = 1;
1723: EXCEPTION
1724: WHEN NO_DATA_FOUND THEN
1725: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1726: fnd_msg_pub.ADD;
1727: RAISE fnd_api.g_exc_error;
1728: END;
1729: END IF;
1730: --DBMS_output.put_line('setting attribs');

Line 1876: fnd_msg_pub.ADD;

1872:
1873: IF l_return_status = 'E' THEN
1874: --DBMS_output.put_line('Error from validate_loc_attr_info');
1875: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1876: fnd_msg_pub.ADD;
1877: RAISE fnd_api.g_exc_error;
1878: ELSIF l_return_status = 'U' THEN
1879: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1880: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');

Line 1881: fnd_msg_pub.ADD;

1877: RAISE fnd_api.g_exc_error;
1878: ELSIF l_return_status = 'U' THEN
1879: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1880: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1881: fnd_msg_pub.ADD;
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: END IF;
1884: /* End locator DFF attributes validation */
1885:

Line 1898: fnd_msg_pub.ADD;

1894: p_loc_id=> l_inventory_location_id
1895: );
1896: IF (l_is_disable_allow = false) THEN
1897: fnd_message.set_name('INV','INV_LOCATOR_DISABLE_WARN');
1898: fnd_msg_pub.ADD;
1899: RAISE fnd_api.g_exc_error;
1900: END IF;
1901: END IF;
1902: -- end of bug 7297065

Line 1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1982: WHEN fnd_api.g_exc_error THEN
1983: x_return_status := 'E';
1984: ROLLBACK TO locator_update;
1985: debug(l_procedure_name ||' Expected Error ');
1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := 'U';
1989: ROLLBACK TO locator_update;
1990: debug(l_procedure_name ||'Unexpected Error ');

Line 1991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: x_return_status := 'U';
1989: ROLLBACK TO locator_update;
1990: debug(l_procedure_name ||'Unexpected Error ');
1991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1992: WHEN OTHERS THEN
1993: x_return_status := 'U';
1994: ROLLBACK TO locator_update;
1995:

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

1992: WHEN OTHERS THEN
1993: x_return_status := 'U';
1994: ROLLBACK TO locator_update;
1995:
1996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1998: END IF;
1999: debug(l_procedure_name ||' Others '||SQLERRM);
2000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 1997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);

1993: x_return_status := 'U';
1994: ROLLBACK TO locator_update;
1995:
1996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1998: END IF;
1999: debug(l_procedure_name ||' Others '||SQLERRM);
2000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2001: END update_locator;

Line 2000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

1996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1998: END IF;
1999: debug(l_procedure_name ||' Others '||SQLERRM);
2000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2001: END update_locator;
2002:
2003: /*
2004: ** ---------------------------------------------------------------------------

Line 2082: fnd_msg_pub.ADD;

2078: ELSE
2079: IF p_organization_code IS NULL THEN
2080: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2081: /* Organization is required */
2082: fnd_msg_pub.ADD;
2083: RAISE fnd_api.g_exc_error;
2084: ELSE
2085: BEGIN
2086: SELECT organization_id

Line 2094: fnd_msg_pub.ADD;

2090: EXCEPTION
2091: WHEN NO_DATA_FOUND THEN
2092: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2093: /* The Organization Code provided is invalid */
2094: fnd_msg_pub.ADD;
2095: RAISE fnd_api.g_exc_error;
2096: END;
2097: END IF;
2098: END IF;

Line 2107: fnd_msg_pub.ADD;

2103: ELSE
2104: IF p_item IS NULL THEN
2105: fnd_message.set_name('INV', 'INV_INT_ITMSEGCODE');
2106: /* Invalid item segments */
2107: fnd_msg_pub.ADD;
2108: RAISE fnd_api.g_exc_error;
2109: ELSE
2110: BEGIN
2111: SELECT inventory_item_id

Line 2120: fnd_msg_pub.ADD;

2116: EXCEPTION
2117: WHEN NO_DATA_FOUND THEN
2118: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2119: /* The Item provided is invalid */
2120: fnd_msg_pub.ADD;
2121: RAISE fnd_api.g_exc_error;
2122: END;
2123: END IF;
2124: END IF;

Line 2130: fnd_msg_pub.ADD;

2126: /*Validate the subinventory code */
2127: IF p_subinventory_code IS NULL THEN
2128: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
2129: /* Please enter a subinventory before proceeding */
2130: fnd_msg_pub.ADD;
2131: RAISE fnd_api.g_exc_error;
2132: ELSE
2133: BEGIN
2134: SELECT NVL(planning_level, 2)

Line 2143: fnd_msg_pub.ADD;

2139: EXCEPTION
2140: WHEN NO_DATA_FOUND THEN
2141: fnd_message.set_name('INV', 'INVALID_SUB');
2142: /* The subinventory provided is invalid */
2143: fnd_msg_pub.ADD;
2144: RAISE fnd_api.g_exc_error;
2145: END;
2146: END IF;
2147:

Line 2155: fnd_msg_pub.ADD;

2151: ELSE
2152: IF p_locator IS NULL THEN
2153: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2154: /* Invalid locator segments */
2155: fnd_msg_pub.ADD;
2156: RAISE fnd_api.g_exc_error;
2157: ELSE
2158: BEGIN
2159: SELECT inventory_location_id

Line 2168: fnd_msg_pub.ADD;

2164: EXCEPTION
2165: WHEN NO_DATA_FOUND THEN
2166: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2167: /* The Locator provided is invalid */
2168: fnd_msg_pub.ADD;
2169: RAISE fnd_api.g_exc_error;
2170: END;
2171: END IF;
2172: END IF;

Line 2213: fnd_msg_pub.ADD;

2209: EXCEPTION
2210: WHEN NO_DATA_FOUND THEN
2211: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
2212: /* Invalid status ID. */
2213: fnd_msg_pub.ADD;
2214: RAISE fnd_api.g_exc_error;
2215: END;
2216: END IF;
2217:

Line 2307: fnd_msg_pub.ADD;

2303: END IF;
2304: ELSE
2305: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2306: /* Locator selected has already been assigned to this item and subinventory */
2307: fnd_msg_pub.ADD;
2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2309: END IF;
2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN

Line 2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2304: ELSE
2305: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2306: /* Locator selected has already been assigned to this item and subinventory */
2307: fnd_msg_pub.ADD;
2308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2309: END IF;
2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := 'E';

Line 2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2310: EXCEPTION
2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := 'E';
2313: ROLLBACK TO location_item_restrict;
2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2315: WHEN fnd_api.g_exc_unexpected_error THEN
2316: x_return_status := 'U';
2317: ROLLBACK TO location_item_restrict;
2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2315: WHEN fnd_api.g_exc_unexpected_error THEN
2316: x_return_status := 'U';
2317: ROLLBACK TO location_item_restrict;
2318: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2319: WHEN OTHERS THEN
2320: x_return_status := 'U';
2321: --DBMS_output.put_line('In others '||sqlerrm);
2322: ROLLBACK TO location_item_restrict;

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

2320: x_return_status := 'U';
2321: --DBMS_output.put_line('In others '||sqlerrm);
2322: ROLLBACK TO location_item_restrict;
2323:
2324: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2325: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2326: END IF;
2327:
2328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

Line 2325: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');

2321: --DBMS_output.put_line('In others '||sqlerrm);
2322: ROLLBACK TO location_item_restrict;
2323:
2324: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2325: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2326: END IF;
2327:
2328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2329: END create_loc_item_tie;

Line 2328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

2324: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2325: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2326: END IF;
2327:
2328: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2329: END create_loc_item_tie;
2330:
2331: /*
2332: **-----------------------------------------------------------------------------------

Line 2404: fnd_msg_pub.ADD;

2400: ELSE
2401: IF p_organization_code IS NULL THEN
2402: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2403: /* Organisation is required */
2404: fnd_msg_pub.ADD;
2405: RAISE fnd_api.g_exc_error;
2406: ELSE
2407: SELECT organization_id
2408: INTO l_organization_id

Line 2451: fnd_msg_pub.ADD;

2447: OR p_concatenated_segments IS NULL THEN
2448: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2449: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2450: /* LOCATOR does not exist */
2451: fnd_msg_pub.ADD;
2452: RAISE fnd_api.g_exc_error;
2453: ELSE
2454: l_locator := p_concatenated_segments;
2455: l_inventory_location_id := fnd_flex_keyval.combination_id;

Line 2479: fnd_msg_pub.ADD;

2475:
2476: fnd_message.set_name('INV', 'INV_LOC_PHY');
2477: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2478: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2479: fnd_msg_pub.ADD;
2480: RAISE fnd_api.g_exc_error;
2481: EXCEPTION
2482: WHEN NO_DATA_FOUND THEN
2483: NULL;

Line 2504: fnd_msg_pub.ADD;

2500:
2501: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2502: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2503: /*Locator locator cannot be deleted as it is active */
2504: fnd_msg_pub.ADD;
2505: RAISE fnd_api.g_exc_error;
2506: EXCEPTION
2507: WHEN NO_DATA_FOUND THEN
2508: NULL;

Line 2530: fnd_msg_pub.ADD;

2526:
2527: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2528: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2529: /*Locator locator cannot be deleted as items exist in it*/
2530: fnd_msg_pub.ADD;
2531: RAISE fnd_api.g_exc_error;
2532: EXCEPTION
2533: WHEN NO_DATA_FOUND THEN
2534: NULL;

Line 2552: fnd_msg_pub.ADD;

2548:
2549: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2550: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2551: /*The locator locator cannot be deleted as reservations exist against it*/
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: EXCEPTION
2555: WHEN NO_DATA_FOUND THEN
2556: NULL;

Line 2573: fnd_msg_pub.ADD;

2569:
2570: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2571: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2572: /*Locator locator cannot be deleted as LPNs reside in it*/
2573: fnd_msg_pub.ADD;
2574: RAISE fnd_api.g_exc_error;
2575: EXCEPTION
2576: WHEN NO_DATA_FOUND THEN
2577: NULL;

Line 2594: fnd_msg_pub.ADD;

2590:
2591: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2592: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2593: /*Locator locator cannot be deleted as it is tied to an item */
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2596: EXCEPTION
2597: WHEN NO_DATA_FOUND THEN
2598: NULL;

Line 2615: fnd_msg_pub.ADD;

2611:
2612: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2613: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2614: /*Locator locator cannot be deleted as there are pending transactions against it*/
2615: fnd_msg_pub.ADD;
2616: RAISE fnd_api.g_exc_error;
2617: EXCEPTION
2618: WHEN NO_DATA_FOUND THEN
2619: NULL;

Line 2642: fnd_msg_pub.ADD;

2638:
2639: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2640: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2641: /*Locator locator cannot be deleted as there are pending transactions against it*/
2642: fnd_msg_pub.ADD;
2643: RAISE fnd_api.g_exc_error;
2644: EXCEPTION
2645: WHEN NO_DATA_FOUND THEN
2646: NULL;

Line 2663: fnd_msg_pub.ADD;

2659:
2660: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2661: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2662: /*Locator locator cannot be deleted as there are pending transactions against it*/
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: EXCEPTION
2666: WHEN NO_DATA_FOUND THEN
2667: NULL;

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

2677: EXCEPTION
2678: WHEN fnd_api.g_exc_error THEN
2679: x_return_status := fnd_api.g_ret_sts_error;
2680: ROLLBACK TO del_loc_api;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: WHEN fnd_api.g_exc_unexpected_error THEN
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;
2684: ROLLBACK TO del_loc_api;
2685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: WHEN fnd_api.g_exc_unexpected_error THEN
2683: x_return_status := fnd_api.g_ret_sts_unexp_error;
2684: ROLLBACK TO del_loc_api;
2685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2686: WHEN NO_DATA_FOUND THEN
2687: ROLLBACK TO del_loc_api;
2688: x_return_status := fnd_api.g_ret_sts_error;
2689: WHEN OTHERS THEN

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

2689: WHEN OTHERS THEN
2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691: ROLLBACK TO del_loc_api;
2692:
2693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2694: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');
2695: END IF;
2696:
2697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2694: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');

2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691: ROLLBACK TO del_loc_api;
2692:
2693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2694: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');
2695: END IF;
2696:
2697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2698: END delete_locator;

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

2693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2694: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');
2695: END IF;
2696:
2697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2698: END delete_locator;
2699:
2700:
2701: END inv_loc_wms_pub;