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

110: --DBMS_output.put_line('more params passed than needed');
111: fnd_message.set_name('FND', 'FLEX-INVALID CONTEXT');
112: fnd_message.set_token('CONTEXT', 'NULL');
113: fnd_message.set_token('ROUTINE','INV_LOC_WMS_PUB');
114: fnd_msg_pub.ADD;
115: RAISE fnd_api.g_exc_error;
116: END IF;
117:
118: FOR i IN 1 .. l_nsegments LOOP

Line 130: fnd_msg_pub.ADD;

126: THEN
127: --DBMS_output.put_line('y r we here');
128: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
129: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
130: fnd_msg_pub.ADD;
131: RAISE fnd_api.g_exc_error;
132: END IF;
133: ELSE
134: --DBMS_output.put_line('This segment is not required');

Line 203: fnd_msg_pub.ADD;

199: NOT p_attributes_tbl.EXISTS(col))
200: THEN
201: fnd_message.set_name('INV', 'INV_REQ_SEG_MISS');
202: fnd_message.set_token('SEGMENT', l_segments_dr.segment_name(i));
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: --DBMS_output.put_line('Req segment is not populated');
206: END IF;
207: END IF;

Line 261: fnd_msg_pub.ADD;

257: WHILE e < 5001
258: AND SUBSTR(error_msg, s, e) IS NOT NULL LOOP
259: fnd_message.set_name('INV', 'INV_FND_GENERIC_MSG');
260: fnd_message.set_token('MSG', SUBSTR(error_msg, s, e));
261: fnd_msg_pub.ADD;
262: --DBMS_output.put_line(SUBSTR(error_msg, s, e));
263: s := s + 200;
264: e := e + 200;
265: END LOOP;

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

264: e := e + 200;
265: END LOOP;
266:
267: ROLLBACK TO get_lot_attr_information;
268: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

268: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
269: WHEN fnd_api.g_exc_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO get_lot_attr_information;
272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
273: WHEN fnd_api.g_exc_unexpected_error THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: ROLLBACK TO get_lot_attr_information;
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: ROLLBACK TO get_lot_attr_information;
280: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
277: WHEN OTHERS THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: ROLLBACK TO get_lot_attr_information;
280: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
281: --DBMS_output.put_line('Error ' || SQLERRM);
282: END validate_loc_attr_info;
283:
284:

Line 502: fnd_msg_pub.ADD;

498: WHERE organization_id = l_organization_id;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_error;
504: END;
505:
506: ELSE -- p_organization_id is NULL

Line 511: fnd_msg_pub.ADD;

507:
508: IF p_organization_code IS NULL THEN
509:
510: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
511: fnd_msg_pub.ADD;
512: RAISE fnd_api.g_exc_error;
513:
514: ELSE -- p_organization_code is NULL
515:

Line 528: fnd_msg_pub.ADD;

524:
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
528: fnd_msg_pub.ADD;
529: RAISE fnd_api.g_exc_error;
530: END;
531:
532: END IF; -- p_organization_code is NULL

Line 549: fnd_msg_pub.ADD;

545: */
546: IF p_subinventory_code IS NULL THEN
547:
548: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
549: fnd_msg_pub.ADD;
550: RAISE fnd_api.g_exc_error;
551:
552: ELSE -- p_subinventory_code is NULL
553:

Line 572: fnd_msg_pub.ADD;

568: EXCEPTION
569:
570: WHEN NO_DATA_FOUND THEN
571: fnd_message.set_name('INV', 'INVALID_SUB');
572: fnd_msg_pub.ADD;
573: RAISE fnd_api.g_exc_error;
574:
575: END;
576:

Line 586: fnd_msg_pub.ADD;

582: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
583: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR -- 4911279
584: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
585: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
586: fnd_msg_pub.ADD;
587: RAISE fnd_api.g_exc_error;
588: END IF;
589:
590: /*

Line 602: fnd_msg_pub.ADD;

598:
599: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
600:
601: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
602: fnd_msg_pub.ADD;
603: RAISE fnd_api.g_exc_error;
604:
605: END IF;
606:

Line 628: fnd_msg_pub.ADD;

624: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
625:
626: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
627: fnd_message.set_token('LOCATOR', l_locator);
628: fnd_msg_pub.ADD;
629: RAISE fnd_api.g_exc_error;
630:
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN

Line 652: fnd_msg_pub.ADD;

648: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
649:
650: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
651: fnd_message.set_token('LOCATOR', l_locator);
652: fnd_msg_pub.ADD;
653: RAISE fnd_api.g_exc_error;
654:
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN

Line 674: fnd_msg_pub.ADD;

670:
671: IF p_concatenated_segments IS NULL THEN
672:
673: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
674: fnd_msg_pub.ADD;
675: RAISE fnd_api.g_exc_error;
676:
677: END IF;
678:

Line 691: fnd_msg_pub.add;

687: AND ROWNUM < 2;
688:
689: x_locator_exists:= 'Y';
690: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
691: fnd_msg_pub.add;
692: fnd_msg_pub.count_and_get
693: ( p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
695: p_data => x_msg_data

Line 692: fnd_msg_pub.count_and_get

688:
689: x_locator_exists:= 'Y';
690: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
691: fnd_msg_pub.add;
692: fnd_msg_pub.count_and_get
693: ( p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );

Line 720: fnd_msg_pub.ADD;

716: IF l_val = TRUE THEN
717: x_locator_exists := 'Y';
718: x_inventory_location_id := fnd_flex_keyval.combination_id;
719: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
720: fnd_msg_pub.ADD;
721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
722: RETURN;
723: END IF;
724: END;

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

717: x_locator_exists := 'Y';
718: x_inventory_location_id := fnd_flex_keyval.combination_id;
719: fnd_message.set_name('INV', 'INV_LOC_DISABLED');
720: fnd_msg_pub.ADD;
721: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
722: RETURN;
723: END IF;
724: END;
725:

Line 740: fnd_msg_pub.ADD;

736: AND enabled_flag = 1;
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
739: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
740: fnd_msg_pub.ADD;
741: RAISE fnd_api.g_exc_error;
742: END;
743: END IF;
744:

Line 754: fnd_msg_pub.ADD;

750: WHERE uom_code = p_location_weight_uom_code;
751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
754: fnd_msg_pub.ADD;
755: RAISE fnd_api.g_exc_error;
756: END;
757: END IF;
758:

Line 771: fnd_msg_pub.ADD;

767: WHERE uom_code = p_volume_uom_code;
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: fnd_message.set_name('INV', 'INV_IOI_VOLUME_UOM_CODE');
771: fnd_msg_pub.ADD;
772: RAISE fnd_api.g_exc_error;
773: END;
774: END IF;
775:

Line 786: fnd_msg_pub.ADD;

782: WHERE uom_code = p_pick_uom_code;
783: EXCEPTION
784: WHEN NO_DATA_FOUND THEN
785: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE');
786: fnd_msg_pub.ADD;
787: RAISE fnd_api.g_exc_error;
788: END;
789: END IF;
790:

Line 803: fnd_msg_pub.ADD;

799: WHERE uom_code = p_dimension_uom_code;
800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN
802: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
803: fnd_msg_pub.ADD;
804: RAISE fnd_api.g_exc_error;
805: END;
806: END IF;
807:

Line 863: fnd_msg_pub.ADD;

859: --DBMS_output.put_line('Validity check passed ');
860: IF (l_keystat_val = FALSE) THEN
861: --DBMS_output.put_line('validate segment failed ');
862: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
863: fnd_msg_pub.ADD;
864: RAISE fnd_api.g_exc_unexpected_error;
865: ELSE
866: x_inventory_location_id := fnd_flex_keyval.combination_id;
867:

Line 905: fnd_msg_pub.ADD;

901: -- END IF;
902: ELSE
903: --DBMS_output.put_line('Wms installed check failed ');
904: fnd_message.set_name('WMS', 'WMS_INSTALL_CHK_ERROR');
905: fnd_msg_pub.ADD;
906: RAISE fnd_api.g_exc_unexpected_error;
907: END IF;
908:
909: --Bug Number 5606275

Line 927: fnd_msg_pub.ADD;

923: IF(l_project_reference_enabled = 'Y') THEN
924: IF( l_project_control_level =2 AND l_segment20 IS NULL) THEN
925:
926: fnd_message.set_name('INV', 'INV_TASK_NUM_INVALID');
927: fnd_msg_pub.ADD;
928: RAISE fnd_api.g_exc_error;
929: END IF;
930: END IF;
931:

Line 1015: fnd_msg_pub.ADD;

1011:
1012: IF l_return_status = 'E' THEN
1013: --DBMS_output.put_line('Error from validate_loc_attr_info');
1014: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1015: fnd_msg_pub.ADD;
1016: RAISE fnd_api.g_exc_error;
1017: ELSIF l_return_status = 'U' THEN
1018: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1019: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');

Line 1020: fnd_msg_pub.ADD;

1016: RAISE fnd_api.g_exc_error;
1017: ELSIF l_return_status = 'U' THEN
1018: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1019: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1020: fnd_msg_pub.ADD;
1021: RAISE fnd_api.g_exc_unexpected_error;
1022: END IF;
1023: /* End locator DFF attributes validation */
1024:

Line 1096: fnd_msg_pub.ADD;

1092: END IF;
1093: END IF; -- (l_keystat_val = FALSE)
1094: ELSE
1095: fnd_message.set_name('INV', 'INV_LOC_BELONG_TO_OTH_SUB');
1096: fnd_msg_pub.ADD;
1097: RAISE fnd_api.g_exc_error;
1098: END IF; -- (l_validility = passed)
1099:
1100: EXCEPTION

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

1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := 'E';
1103: ROLLBACK TO locator_insert;
1104: debug(l_procedure_name ||' Expected Error ');
1105: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1106: WHEN fnd_api.g_exc_unexpected_error THEN
1107: x_return_status := 'U';
1108: ROLLBACK TO locator_insert;
1109: debug(l_procedure_name ||' Unxpected Error ');

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

1106: WHEN fnd_api.g_exc_unexpected_error THEN
1107: x_return_status := 'U';
1108: ROLLBACK TO locator_insert;
1109: debug(l_procedure_name ||' Unxpected Error ');
1110: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN OTHERS THEN
1112: x_return_status := 'U';
1113: --DBMS_output.put_line('In others '||sqlerrm);
1114: ROLLBACK TO locator_insert;

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

1112: x_return_status := 'U';
1113: --DBMS_output.put_line('In others '||sqlerrm);
1114: ROLLBACK TO locator_insert;
1115:
1116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1117: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1118: END IF;
1119: debug(l_procedure_name ||' Others '||SQLERRM);
1120: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1113: --DBMS_output.put_line('In others '||sqlerrm);
1114: ROLLBACK TO locator_insert;
1115:
1116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1117: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1118: END IF;
1119: debug(l_procedure_name ||' Others '||SQLERRM);
1120: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1121: END create_locator;

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

1116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1117: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1118: END IF;
1119: debug(l_procedure_name ||' Others '||SQLERRM);
1120: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1121: END create_locator;
1122:
1123: /*
1124: ** ---------------------------------------------------------------------------

Line 1337: fnd_msg_pub.ADD;

1333: WHERE organization_id = l_organization_id;
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1337: fnd_msg_pub.ADD;
1338: RAISE fnd_api.g_exc_error;
1339: END;
1340:
1341: ELSE -- p_organization_id IS NULL

Line 1346: fnd_msg_pub.ADD;

1342:
1343: IF p_organization_code IS NULL THEN
1344:
1345: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1346: fnd_msg_pub.ADD;
1347: RAISE fnd_api.g_exc_error;
1348:
1349: ELSE -- p_organization_code is NULL
1350:

Line 1361: fnd_msg_pub.ADD;

1357: WHERE organization_code = p_organization_code;
1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN
1360: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1361: fnd_msg_pub.ADD;
1362: RAISE fnd_api.g_exc_error;
1363: END;
1364:
1365: END IF; -- p_organization_code is NULL

Line 1377: fnd_msg_pub.ADD;

1373:
1374: IF (p_concatenated_segments IS NULL AND p_inventory_location_id IS NULL) THEN
1375:
1376: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1377: fnd_msg_pub.ADD;
1378: RAISE fnd_api.g_exc_error;
1379:
1380: ELSIF p_concatenated_segments IS NOT NULL AND p_inventory_location_id IS NULL THEN
1381:

Line 1404: fnd_msg_pub.ADD;

1400: );
1401:
1402: IF l_val = FALSE THEN
1403: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
1404: fnd_msg_pub.ADD;
1405: RAISE fnd_api.g_exc_error;
1406: ELSE
1407: l_inventory_location_id := fnd_flex_keyval.combination_id;
1408: END IF;

Line 1427: fnd_msg_pub.ADD;

1423: IF (p_inventory_location_type <> fnd_api.g_miss_num AND
1424: p_inventory_location_type NOT IN(1, 2, 3, 4, 5, 6, 7)) THEN
1425:
1426: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1427: fnd_msg_pub.ADD;
1428: RAISE fnd_api.g_exc_error;
1429:
1430: END IF;
1431:

Line 1447: fnd_msg_pub.ADD;

1443: AND msi.organization_id = l_organization_id;
1444: EXCEPTION
1445: WHEN NO_DATA_FOUND THEN
1446: fnd_message.set_name('INV', 'INVALID_SUB');
1447: fnd_msg_pub.ADD;
1448: RAISE fnd_api.g_exc_error;
1449: END;
1450:
1451: -- If the sub is of type 'Storage', then the locator cannot be of type 'Receiving'.

Line 1457: fnd_msg_pub.ADD;

1453: IF ((l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 6) OR
1454: (l_subinventory_type = 1 AND NVL(p_inventory_location_type, 3) = 7) OR --4911279
1455: (l_subinventory_type = 2 AND NVL(p_inventory_location_type, 3) = 3)) THEN
1456: fnd_message.set_name('INV', 'INV_INVALID_LOCATOR_TYPE');
1457: fnd_msg_pub.ADD;
1458: RAISE fnd_api.g_exc_error;
1459: END IF;
1460: END IF;
1461:

Line 1498: fnd_msg_pub.ADD;

1494:
1495: IF l_alias_enabled = 'Y' AND l_alias IS NULL THEN
1496:
1497: fnd_message.set_name('INV', 'INV_ALIAS_REQUIRED');
1498: fnd_msg_pub.ADD;
1499: RAISE fnd_api.g_exc_error;
1500:
1501: END IF;
1502:

Line 1521: fnd_msg_pub.ADD;

1517: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1518:
1519: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1520: fnd_message.set_token('LOCATOR', l_locator);
1521: fnd_msg_pub.ADD;
1522: RAISE fnd_api.g_exc_error;
1523:
1524: EXCEPTION
1525: WHEN NO_DATA_FOUND THEN

Line 1544: fnd_msg_pub.ADD;

1540: AND NVL(physical_location_id,inventory_location_id) = inventory_location_id;
1541:
1542: fnd_message.set_name('INV', 'INV_ALIAS_IN_USE');
1543: fnd_message.set_token('LOCATOR', l_locator);
1544: fnd_msg_pub.ADD;
1545: RAISE fnd_api.g_exc_error;
1546:
1547: EXCEPTION
1548: WHEN NO_DATA_FOUND THEN

Line 1572: fnd_msg_pub.ADD;

1568: WHERE uom_code = p_location_weight_uom_code;
1569: EXCEPTION
1570: WHEN NO_DATA_FOUND THEN
1571: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1572: fnd_msg_pub.ADD;
1573: RAISE fnd_api.g_exc_error;
1574: END;
1575: END IF;
1576:

Line 1590: fnd_msg_pub.ADD;

1586: WHERE uom_code = p_volume_uom_code;
1587: EXCEPTION
1588: WHEN NO_DATA_FOUND THEN
1589: fnd_message.set_name('INV', 'INV_IOI_WEIGHT_UOM_CODE');
1590: fnd_msg_pub.ADD;
1591: RAISE fnd_api.g_exc_error;
1592: END;
1593: END IF;
1594:

Line 1607: fnd_msg_pub.ADD;

1603: WHERE uom_code = p_pick_uom_code;
1604: EXCEPTION
1605: WHEN NO_DATA_FOUND THEN
1606: fnd_message.set_name('INV', 'INV_IOI_PICK_UOM_CODE ');
1607: fnd_msg_pub.ADD;
1608: RAISE fnd_api.g_exc_error;
1609: END;
1610: END IF;
1611:

Line 1625: fnd_msg_pub.ADD;

1621: WHERE uom_code = p_dimension_uom_code;
1622: EXCEPTION
1623: WHEN NO_DATA_FOUND THEN
1624: fnd_message.set_name('INV', 'INV_IOI_DIMENSION_UOM_CODE');
1625: fnd_msg_pub.ADD;
1626: RAISE fnd_api.g_exc_error;
1627: END;
1628: END IF;
1629:

Line 1643: fnd_msg_pub.ADD;

1639: AND enabled_flag = 1;
1640: EXCEPTION
1641: WHEN NO_DATA_FOUND THEN
1642: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
1643: fnd_msg_pub.ADD;
1644: RAISE fnd_api.g_exc_error;
1645: END;
1646: END IF;
1647: --DBMS_output.put_line('setting attribs');

Line 1793: fnd_msg_pub.ADD;

1789:
1790: IF l_return_status = 'E' THEN
1791: --DBMS_output.put_line('Error from validate_loc_attr_info');
1792: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1793: fnd_msg_pub.ADD;
1794: RAISE fnd_api.g_exc_error;
1795: ELSIF l_return_status = 'U' THEN
1796: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1797: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');

Line 1798: fnd_msg_pub.ADD;

1794: RAISE fnd_api.g_exc_error;
1795: ELSIF l_return_status = 'U' THEN
1796: --DBMS_output.put_line('Unexpected Error from validate_loc_attr_info');
1797: fnd_message.set_name('INV', 'INV_LOC_CREATION_FAIL');
1798: fnd_msg_pub.ADD;
1799: RAISE fnd_api.g_exc_unexpected_error;
1800: END IF;
1801: /* End locator DFF attributes validation */
1802:

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

1886: WHEN fnd_api.g_exc_error THEN
1887: x_return_status := 'E';
1888: ROLLBACK TO locator_update;
1889: debug(l_procedure_name ||' Expected Error ');
1890: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1891: WHEN fnd_api.g_exc_unexpected_error THEN
1892: x_return_status := 'U';
1893: ROLLBACK TO locator_update;
1894: debug(l_procedure_name ||'Unexpected Error ');

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

1891: WHEN fnd_api.g_exc_unexpected_error THEN
1892: x_return_status := 'U';
1893: ROLLBACK TO locator_update;
1894: debug(l_procedure_name ||'Unexpected Error ');
1895: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1896: WHEN OTHERS THEN
1897: x_return_status := 'U';
1898: ROLLBACK TO locator_update;
1899:

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

1896: WHEN OTHERS THEN
1897: x_return_status := 'U';
1898: ROLLBACK TO locator_update;
1899:
1900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1902: END IF;
1903: debug(l_procedure_name ||' Others '||SQLERRM);
1904: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

1897: x_return_status := 'U';
1898: ROLLBACK TO locator_update;
1899:
1900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1902: END IF;
1903: debug(l_procedure_name ||' Others '||SQLERRM);
1904: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1905: END update_locator;

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

1900: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_procedure_name);
1902: END IF;
1903: debug(l_procedure_name ||' Others '||SQLERRM);
1904: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1905: END update_locator;
1906:
1907: /*
1908: ** ---------------------------------------------------------------------------

Line 1986: fnd_msg_pub.ADD;

1982: ELSE
1983: IF p_organization_code IS NULL THEN
1984: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
1985: /* Organization is required */
1986: fnd_msg_pub.ADD;
1987: RAISE fnd_api.g_exc_error;
1988: ELSE
1989: BEGIN
1990: SELECT organization_id

Line 1998: fnd_msg_pub.ADD;

1994: EXCEPTION
1995: WHEN NO_DATA_FOUND THEN
1996: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
1997: /* The Organization Code provided is invalid */
1998: fnd_msg_pub.ADD;
1999: RAISE fnd_api.g_exc_error;
2000: END;
2001: END IF;
2002: END IF;

Line 2011: fnd_msg_pub.ADD;

2007: ELSE
2008: IF p_item IS NULL THEN
2009: fnd_message.set_name('INV', 'INV_INT_ITMSEGCODE');
2010: /* Invalid item segments */
2011: fnd_msg_pub.ADD;
2012: RAISE fnd_api.g_exc_error;
2013: ELSE
2014: BEGIN
2015: SELECT inventory_item_id

Line 2024: fnd_msg_pub.ADD;

2020: EXCEPTION
2021: WHEN NO_DATA_FOUND THEN
2022: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2023: /* The Item provided is invalid */
2024: fnd_msg_pub.ADD;
2025: RAISE fnd_api.g_exc_error;
2026: END;
2027: END IF;
2028: END IF;

Line 2034: fnd_msg_pub.ADD;

2030: /*Validate the subinventory code */
2031: IF p_subinventory_code IS NULL THEN
2032: fnd_message.set_name('INV', 'INV_ENTER_SUBINV');
2033: /* Please enter a subinventory before proceeding */
2034: fnd_msg_pub.ADD;
2035: RAISE fnd_api.g_exc_error;
2036: ELSE
2037: BEGIN
2038: SELECT NVL(planning_level, 2)

Line 2047: fnd_msg_pub.ADD;

2043: EXCEPTION
2044: WHEN NO_DATA_FOUND THEN
2045: fnd_message.set_name('INV', 'INVALID_SUB');
2046: /* The subinventory provided is invalid */
2047: fnd_msg_pub.ADD;
2048: RAISE fnd_api.g_exc_error;
2049: END;
2050: END IF;
2051:

Line 2059: fnd_msg_pub.ADD;

2055: ELSE
2056: IF p_locator IS NULL THEN
2057: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
2058: /* Invalid locator segments */
2059: fnd_msg_pub.ADD;
2060: RAISE fnd_api.g_exc_error;
2061: ELSE
2062: BEGIN
2063: SELECT inventory_location_id

Line 2072: fnd_msg_pub.ADD;

2068: EXCEPTION
2069: WHEN NO_DATA_FOUND THEN
2070: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
2071: /* The Locator provided is invalid */
2072: fnd_msg_pub.ADD;
2073: RAISE fnd_api.g_exc_error;
2074: END;
2075: END IF;
2076: END IF;

Line 2117: fnd_msg_pub.ADD;

2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN
2115: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_STATUS_ID');
2116: /* Invalid status ID. */
2117: fnd_msg_pub.ADD;
2118: RAISE fnd_api.g_exc_error;
2119: END;
2120: END IF;
2121:

Line 2211: fnd_msg_pub.ADD;

2207: END IF;
2208: ELSE
2209: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2210: /* Locator selected has already been assigned to this item and subinventory */
2211: fnd_msg_pub.ADD;
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2213: END IF;
2214: EXCEPTION
2215: WHEN fnd_api.g_exc_error THEN

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

2208: ELSE
2209: fnd_message.set_name('INV', 'INV_LOCATOR_ASSIGNED');
2210: /* Locator selected has already been assigned to this item and subinventory */
2211: fnd_msg_pub.ADD;
2212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2213: END IF;
2214: EXCEPTION
2215: WHEN fnd_api.g_exc_error THEN
2216: x_return_status := 'E';

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

2214: EXCEPTION
2215: WHEN fnd_api.g_exc_error THEN
2216: x_return_status := 'E';
2217: ROLLBACK TO location_item_restrict;
2218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2219: WHEN fnd_api.g_exc_unexpected_error THEN
2220: x_return_status := 'U';
2221: ROLLBACK TO location_item_restrict;
2222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

2218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2219: WHEN fnd_api.g_exc_unexpected_error THEN
2220: x_return_status := 'U';
2221: ROLLBACK TO location_item_restrict;
2222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2223: WHEN OTHERS THEN
2224: x_return_status := 'U';
2225: --DBMS_output.put_line('In others '||sqlerrm);
2226: ROLLBACK TO location_item_restrict;

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

2224: x_return_status := 'U';
2225: --DBMS_output.put_line('In others '||sqlerrm);
2226: ROLLBACK TO location_item_restrict;
2227:
2228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2229: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2230: END IF;
2231:
2232: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

2225: --DBMS_output.put_line('In others '||sqlerrm);
2226: ROLLBACK TO location_item_restrict;
2227:
2228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2229: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2230: END IF;
2231:
2232: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2233: END create_loc_item_tie;

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

2228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2229: fnd_msg_pub.add_exc_msg('INV_LOC_WMS_PUB', 'create_loc_item_tie');
2230: END IF;
2231:
2232: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2233: END create_loc_item_tie;
2234:
2235: /*
2236: **-----------------------------------------------------------------------------------

Line 2308: fnd_msg_pub.ADD;

2304: ELSE
2305: IF p_organization_code IS NULL THEN
2306: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
2307: /* Organisation is required */
2308: fnd_msg_pub.ADD;
2309: RAISE fnd_api.g_exc_error;
2310: ELSE
2311: SELECT organization_id
2312: INTO l_organization_id

Line 2355: fnd_msg_pub.ADD;

2351: OR p_concatenated_segments IS NULL THEN
2352: fnd_message.set_name('INV', 'INV_LOC_SEGCODE');
2353: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2354: /* LOCATOR does not exist */
2355: fnd_msg_pub.ADD;
2356: RAISE fnd_api.g_exc_error;
2357: ELSE
2358: l_locator := p_concatenated_segments;
2359: l_inventory_location_id := fnd_flex_keyval.combination_id;

Line 2383: fnd_msg_pub.ADD;

2379:
2380: fnd_message.set_name('INV', 'INV_LOC_PHY');
2381: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2382: /*Locator LOCATOR cannot be deleted as it exists as a Physical Locator to Some other Locators*/
2383: fnd_msg_pub.ADD;
2384: RAISE fnd_api.g_exc_error;
2385: EXCEPTION
2386: WHEN NO_DATA_FOUND THEN
2387: NULL;

Line 2408: fnd_msg_pub.ADD;

2404:
2405: fnd_message.set_name('INV', 'INV_LOC_ACTIVE');
2406: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2407: /*Locator locator cannot be deleted as it is active */
2408: fnd_msg_pub.ADD;
2409: RAISE fnd_api.g_exc_error;
2410: EXCEPTION
2411: WHEN NO_DATA_FOUND THEN
2412: NULL;

Line 2434: fnd_msg_pub.ADD;

2430:
2431: fnd_message.set_name('INV', 'INV_LOC_ONHANDQTY');
2432: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2433: /*Locator locator cannot be deleted as items exist in it*/
2434: fnd_msg_pub.ADD;
2435: RAISE fnd_api.g_exc_error;
2436: EXCEPTION
2437: WHEN NO_DATA_FOUND THEN
2438: NULL;

Line 2456: fnd_msg_pub.ADD;

2452:
2453: fnd_message.set_name('INV', 'INV_LOC_RESERVE');
2454: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2455: /*The locator locator cannot be deleted as reservations exist against it*/
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2458: EXCEPTION
2459: WHEN NO_DATA_FOUND THEN
2460: NULL;

Line 2477: fnd_msg_pub.ADD;

2473:
2474: fnd_message.set_name('INV', 'INV_LOC_LPNEXIST');
2475: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2476: /*Locator locator cannot be deleted as LPNs reside in it*/
2477: fnd_msg_pub.ADD;
2478: RAISE fnd_api.g_exc_error;
2479: EXCEPTION
2480: WHEN NO_DATA_FOUND THEN
2481: NULL;

Line 2498: fnd_msg_pub.ADD;

2494:
2495: fnd_message.set_name('INV', 'INV_LOC_ITEMTIE');
2496: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2497: /*Locator locator cannot be deleted as it is tied to an item */
2498: fnd_msg_pub.ADD;
2499: RAISE fnd_api.g_exc_error;
2500: EXCEPTION
2501: WHEN NO_DATA_FOUND THEN
2502: NULL;

Line 2519: fnd_msg_pub.ADD;

2515:
2516: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2517: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2518: /*Locator locator cannot be deleted as there are pending transactions against it*/
2519: fnd_msg_pub.ADD;
2520: RAISE fnd_api.g_exc_error;
2521: EXCEPTION
2522: WHEN NO_DATA_FOUND THEN
2523: NULL;

Line 2546: fnd_msg_pub.ADD;

2542:
2543: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2544: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2545: /*Locator locator cannot be deleted as there are pending transactions against it*/
2546: fnd_msg_pub.ADD;
2547: RAISE fnd_api.g_exc_error;
2548: EXCEPTION
2549: WHEN NO_DATA_FOUND THEN
2550: NULL;

Line 2567: fnd_msg_pub.ADD;

2563:
2564: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');
2565: fnd_message.set_token('LOCATOR', l_locator, TRUE);
2566: /*Locator locator cannot be deleted as there are pending transactions against it*/
2567: fnd_msg_pub.ADD;
2568: RAISE fnd_api.g_exc_error;
2569: EXCEPTION
2570: WHEN NO_DATA_FOUND THEN
2571: NULL;

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

2581: EXCEPTION
2582: WHEN fnd_api.g_exc_error THEN
2583: x_return_status := fnd_api.g_ret_sts_error;
2584: ROLLBACK TO del_loc_api;
2585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: ROLLBACK TO del_loc_api;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: ROLLBACK TO del_loc_api;
2589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2590: WHEN NO_DATA_FOUND THEN
2591: ROLLBACK TO del_loc_api;
2592: x_return_status := fnd_api.g_ret_sts_error;
2593: WHEN OTHERS THEN

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

2593: WHEN OTHERS THEN
2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: ROLLBACK TO del_loc_api;
2596:
2597: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2598: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');
2599: END IF;
2600:
2601: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2594: x_return_status := fnd_api.g_ret_sts_unexp_error;
2595: ROLLBACK TO del_loc_api;
2596:
2597: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2598: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');
2599: END IF;
2600:
2601: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2602: END delete_locator;

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

2597: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2598: fnd_msg_pub.add_exc_msg('inv_loc_wms_pub', 'delete_locator');
2599: END IF;
2600:
2601: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2602: END delete_locator;
2603:
2604:
2605: END inv_loc_wms_pub;