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_MISSING_QTY_ACTIONS_ENGINE dependencies on FND_MSG_PUB

Line 335: fnd_msg_pub.ADD;

331:
332: IF c_rsv_info%NOTFOUND THEN
333: CLOSE c_rsv_info;
334: fnd_message.set_name('INV','INV-ROW-NOT-FOUND');
335: fnd_msg_pub.ADD;
336: /*Bug:4700706. When the reservation record is deleted somehow by this time we need not
337: deal with the reservation.So we just return. */
338: RETURN;
339: --RAISE fnd_api.g_exc_unexpected_error;

Line 439: fnd_msg_pub.ADD;

435: );
436:
437: IF x_return_status <> fnd_api.g_ret_sts_success THEN
438: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
439: fnd_msg_pub.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442: EXCEPTION
443: WHEN fnd_api.g_exc_error THEN

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

441: END IF;
442: EXCEPTION
443: WHEN fnd_api.g_exc_error THEN
444: x_return_status := fnd_api.g_ret_sts_error;
445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN

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

444: x_return_status := fnd_api.g_ret_sts_error;
445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
452: fnd_msg_pub.add_exc_msg(g_pkg_name, 'UNDO_PICK_RELEASE');

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

447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
452: fnd_msg_pub.add_exc_msg(g_pkg_name, 'UNDO_PICK_RELEASE');
453: END IF;
454: END backorder_only;
455:

Line 452: fnd_msg_pub.add_exc_msg(g_pkg_name, 'UNDO_PICK_RELEASE');

448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
452: fnd_msg_pub.add_exc_msg(g_pkg_name, 'UNDO_PICK_RELEASE');
453: END IF;
454: END backorder_only;
455:
456: PROCEDURE split_allocation(

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

667: END IF;
668: EXCEPTION
669: WHEN OTHERS THEN
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
672: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
673: END IF;
674: IF l_debug = 1 THEN
675: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);

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

668: EXCEPTION
669: WHEN OTHERS THEN
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
672: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
673: END IF;
674: IF l_debug = 1 THEN
675: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
676: END IF;

Line 745: fnd_msg_pub.ADD;

741: IF l_debug = 1 THEN
742: print_debug('Error: Querying the Quantity Tree errored out', l_api_name, g_error);
743: END IF;
744: fnd_message.set_name('INV','INV-CANNOT QUERY TREE');
745: fnd_msg_pub.ADD;
746: p_res_qty :=0;
747: p_sec_qty :=0;
748: RETURN;
749: END IF;

Line 873: fnd_msg_pub.ADD;

869: IF l_debug = 1 THEN
870: print_debug('Error: Querying Reservations to check for any existing reservation failed', l_api_name, g_error);
871: END IF;
872: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
873: fnd_msg_pub.ADD;
874: RAISE fnd_api.g_exc_unexpected_error;
875: END IF;
876:
877: IF l_debug = 1 THEN

Line 886: fnd_msg_pub.ADD;

882: IF l_debug = 1 THEN
883: print_debug('Error: Query Reservation returned more than one record', l_api_name, g_error);
884: END IF;
885: fnd_message.set_name('INV', 'INV_NON_UNIQUE_RSV');
886: fnd_msg_pub.ADD;
887: RAISE fnd_api.g_exc_unexpected_error;
888: END IF;
889:
890: l_update_rsv := (l_reservation_count = 1);

Line 991: fnd_msg_pub.ADD;

987: IF l_debug = 1 THEN
988: print_debug('Call to Transfer Reservation API Failed', l_api_name, g_error);
989: END IF;
990: fnd_message.set_name('INV','INV_TRANSFER_RSV_FAILED');
991: fnd_msg_pub.ADD;
992: RAISE fnd_api.g_exc_unexpected_error;
993: END IF;
994:
995: -- The Reservation created below will always be updated in the Reservation created now.

Line 1026: fnd_msg_pub.ADD;

1022: , p_validation_flag => fnd_api.g_true
1023: );
1024: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1025: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1026: fnd_msg_pub.ADD;
1027: RAISE fnd_api.g_exc_unexpected_error;
1028: END IF;
1029: ELSE
1030: l_cc_rsv_rec.primary_reservation_quantity := p_primary_quantity;

Line 1055: fnd_msg_pub.ADD;

1051: , p_force_reservation_flag => fnd_api.g_false
1052: );
1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1054: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
1055: fnd_msg_pub.ADD;
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: END IF;
1058:
1059: /* Since a new Reservation is created, the next Reservation created below should be

Line 1100: fnd_msg_pub.ADD;

1096: , p_validation_flag => fnd_api.g_true
1097: );
1098: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1099: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1100: fnd_msg_pub.ADD;
1101: RAISE fnd_api.g_exc_unexpected_error;
1102: END IF;
1103: END IF;
1104: EXCEPTION

Line 1107: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);

1103: END IF;
1104: EXCEPTION
1105: WHEN fnd_api.g_exc_error THEN
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1108: IF l_debug = 1 THEN
1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;
1111: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1113: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);

1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: x_return_status := fnd_api.g_ret_sts_unexp_error;
1113: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1114: IF l_debug = 1 THEN
1115: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
1116: END IF;
1117: WHEN OTHERS THEN

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

1280: END IF;
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: x_return_status := fnd_api.g_ret_sts_unexp_error;
1284: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1285: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1286: END IF;
1287: IF l_debug = 1 THEN
1288: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);

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

1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: x_return_status := fnd_api.g_ret_sts_unexp_error;
1284: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1285: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1286: END IF;
1287: IF l_debug = 1 THEN
1288: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1289: END IF;

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

1321: END IF;
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := fnd_api.g_ret_sts_unexp_error;
1325: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1327: END IF;
1328: IF l_debug = 1 THEN
1329: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);

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

1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := fnd_api.g_ret_sts_unexp_error;
1325: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1327: END IF;
1328: IF l_debug = 1 THEN
1329: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1330: END IF;

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

1374: END IF;
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;
1378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1379: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1380: END IF;
1381: IF l_debug = 1 THEN
1382: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);

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

1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;
1378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1379: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1380: END IF;
1381: IF l_debug = 1 THEN
1382: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1383: END IF;

Line 1417: fnd_msg_pub.ADD;

1413: IF l_debug = 1 THEN
1414: print_debug('Error: Either TxnTmpID or MOLineID has to be passed', l_api_name, g_error);
1415: END IF;
1416: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1417: fnd_msg_pub.ADD;
1418: RAISE fnd_api.g_exc_error;
1419: END IF;
1420:
1421: -- Determining the Item Controls.

Line 1435: fnd_msg_pub.ADD;

1431: IF l_debug = 1 THEN
1432: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1433: END IF;
1434: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1435: fnd_msg_pub.ADD;
1436: RAISE fnd_api.g_exc_error;
1437: END IF;
1438: END IF;
1439:

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

1459: END IF;
1460: EXCEPTION
1461: WHEN fnd_api.g_exc_error THEN
1462: x_return_status := fnd_api.g_ret_sts_error;
1463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1464: IF l_debug = 1 THEN
1465: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1466: END IF;
1467: WHEN fnd_api.g_exc_unexpected_error THEN

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

1465: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1466: END IF;
1467: WHEN fnd_api.g_exc_unexpected_error THEN
1468: x_return_status := fnd_api.g_ret_sts_unexp_error;
1469: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1470: IF l_debug = 1 THEN
1471: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);
1472: END IF;
1473: WHEN OTHERS THEN

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

1471: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);
1472: END IF;
1473: WHEN OTHERS THEN
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1477: END IF;
1478: IF l_debug = 1 THEN
1479: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);

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

1472: END IF;
1473: WHEN OTHERS THEN
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1477: END IF;
1478: IF l_debug = 1 THEN
1479: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1480: END IF;

Line 1539: fnd_msg_pub.ADD;

1535: IF l_debug = 1 THEN
1536: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1537: END IF;
1538: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1539: fnd_msg_pub.ADD;
1540: RAISE fnd_api.g_exc_error;
1541: END IF;
1542: END IF;
1543:

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

1585: END IF;
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: x_return_status := fnd_api.g_ret_sts_error;
1589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1590: IF l_debug = 1 THEN
1591: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1592: END IF;
1593: WHEN fnd_api.g_exc_unexpected_error THEN

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

1591: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1592: END IF;
1593: WHEN fnd_api.g_exc_unexpected_error THEN
1594: x_return_status := fnd_api.g_ret_sts_unexp_error;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1596: IF l_debug = 1 THEN
1597: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);
1598: END IF;
1599: WHEN OTHERS THEN

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

1597: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);
1598: END IF;
1599: WHEN OTHERS THEN
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: END IF;
1604: IF l_debug = 1 THEN
1605: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);

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

1598: END IF;
1599: WHEN OTHERS THEN
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: END IF;
1604: IF l_debug = 1 THEN
1605: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1606: END IF;

Line 1660: fnd_msg_pub.ADD;

1656: , to_name => null
1657: );
1658: IF ( l_confirmed_quantity_primary < 0 )THEN
1659: fnd_message.set_name('INV','INV_UOM_CONV_ERROR');
1660: fnd_msg_pub.ADD;
1661: RAISE fnd_api.g_exc_error;
1662: END IF;
1663:
1664: ELSE

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

1677:
1678: EXCEPTION
1679: WHEN fnd_api.g_exc_error THEN
1680: x_return_status := fnd_api.g_ret_sts_error;
1681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1682: IF l_debug = 1 THEN
1683: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1684: END IF;
1685: WHEN OTHERS THEN

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

1683: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1684: END IF;
1685: WHEN OTHERS THEN
1686: x_return_status := fnd_api.g_ret_sts_unexp_error;
1687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1688: IF l_debug = 1 THEN
1689: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1690: END IF;
1691: