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

Line 125: fnd_msg_pub.initialize;

121: /*
122: ** Initialize message list
123: */
124: if fnd_api.to_boolean(p_init_msg_lst) then
125: fnd_msg_pub.initialize;
126: end if;
127:
128: /*
129: ** Initialize return status to success

Line 319: fnd_msg_pub.count_and_get(

315: exception
316: when fnd_api.g_exc_error then
317: l_return_status := fnd_api.g_ret_sts_error;
318:
319: fnd_msg_pub.count_and_get(
320: p_count => l_msg_count
321: , p_data => l_msg_data
322: , p_encoded => 'F');
323:

Line 333: fnd_msg_pub.count_and_get(

329:
330: when fnd_api.g_exc_unexpected_error then
331: l_return_status := fnd_api.g_ret_sts_unexp_error;
332:
333: fnd_msg_pub.count_and_get(
334: p_count => l_msg_count
335: , p_data => l_msg_data
336: , p_encoded => 'F');
337:

Line 347: if (fnd_msg_pub.check_msg_level

343:
344: when others then
345: l_return_status := fnd_api.g_ret_sts_unexp_error;
346:
347: if (fnd_msg_pub.check_msg_level
348: (fnd_msg_pub.g_msg_lvl_unexp_error))then
349: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
350: end if;
351:

Line 348: (fnd_msg_pub.g_msg_lvl_unexp_error))then

344: when others then
345: l_return_status := fnd_api.g_ret_sts_unexp_error;
346:
347: if (fnd_msg_pub.check_msg_level
348: (fnd_msg_pub.g_msg_lvl_unexp_error))then
349: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
350: end if;
351:
352: fnd_msg_pub.count_and_get(

Line 349: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);

345: l_return_status := fnd_api.g_ret_sts_unexp_error;
346:
347: if (fnd_msg_pub.check_msg_level
348: (fnd_msg_pub.g_msg_lvl_unexp_error))then
349: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
350: end if;
351:
352: fnd_msg_pub.count_and_get(
353: p_count => l_msg_count

Line 352: fnd_msg_pub.count_and_get(

348: (fnd_msg_pub.g_msg_lvl_unexp_error))then
349: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
350: end if;
351:
352: fnd_msg_pub.count_and_get(
353: p_count => l_msg_count
354: , p_data => l_msg_data
355: , p_encoded => 'F');
356:

Line 485: fnd_msg_pub.initialize;

481: /*
482: ** Initialize message list
483: */
484: if fnd_api.to_boolean(p_init_msg_lst) then
485: fnd_msg_pub.initialize;
486: end if;
487:
488: /*
489: ** Initialize return status to success

Line 639: fnd_msg_pub.count_and_get(

635: exception
636: when fnd_api.g_exc_error then
637: x_return_status := fnd_api.g_ret_sts_error;
638:
639: fnd_msg_pub.count_and_get(
640: p_count => x_msg_count
641: , p_data => x_msg_data
642: , p_encoded => 'F');
643:

Line 653: fnd_msg_pub.count_and_get(

649:
650: when fnd_api.g_exc_unexpected_error then
651: x_return_status := fnd_api.g_ret_sts_unexp_error;
652:
653: fnd_msg_pub.count_and_get(
654: p_count => x_msg_count
655: , p_data => x_msg_data
656: , p_encoded => 'F');
657:

Line 667: if (fnd_msg_pub.check_msg_level

663:
664: when others then
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666:
667: if (fnd_msg_pub.check_msg_level
668: (fnd_msg_pub.g_msg_lvl_unexp_error))then
669: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
670: end if;
671:

Line 668: (fnd_msg_pub.g_msg_lvl_unexp_error))then

664: when others then
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666:
667: if (fnd_msg_pub.check_msg_level
668: (fnd_msg_pub.g_msg_lvl_unexp_error))then
669: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
670: end if;
671:
672: fnd_msg_pub.count_and_get(

Line 669: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);

665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666:
667: if (fnd_msg_pub.check_msg_level
668: (fnd_msg_pub.g_msg_lvl_unexp_error))then
669: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
670: end if;
671:
672: fnd_msg_pub.count_and_get(
673: p_count => x_msg_count

Line 672: fnd_msg_pub.count_and_get(

668: (fnd_msg_pub.g_msg_lvl_unexp_error))then
669: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
670: end if;
671:
672: fnd_msg_pub.count_and_get(
673: p_count => x_msg_count
674: , p_data => x_msg_data
675: , p_encoded => 'F');
676:

Line 868: fnd_msg_pub.initialize;

864: /*
865: ** Initialize message list
866: */
867: if fnd_api.to_boolean(p_init_msg_lst) then
868: fnd_msg_pub.initialize;
869: end if;
870:
871: /*
872: ** Initialize return status to success

Line 1138: fnd_msg_pub.add;

1134: line_id = l_rsv_rec.demand_source_line_id;
1135:
1136: If (l_oe_line_subinventory is not null) and (l_oe_line_subinventory <> l_rsv_rec.subinventory_code) then
1137: fnd_message.set_name('INV','INV_INVALID_SUBINVENTORY');
1138: fnd_msg_pub.add;
1139: raise fnd_api.g_exc_error;
1140: End if;
1141: End if;
1142: End if;

Line 1153: fnd_msg_pub.ADD;

1149: If (l_reservation_action_code in (1,2)) then
1150: IF l_rsv_rec.primary_reservation_quantity <= 0 OR l_rsv_rec.reservation_quantity <= 0 THEN
1151: debug('Primary Reservation Quantity or Reservation Quantity should not be equal to lessa than zero',c_api_name,1);
1152: fnd_message.set_name('INV', 'INV_GREATER_THAN_ZERO');
1153: fnd_msg_pub.ADD;
1154: RAISE fnd_api.g_exc_error;
1155: END IF;
1156:
1157: IF ( inv_cache.set_item_rec(l_rsv_rec.organization_id, l_rsv_rec.inventory_item_id) ) THEN

Line 1182: fnd_msg_pub.ADD;

1178: IF l_tmp_quantity = -99999 THEN
1179: -- conversion failed
1180: debug('Cannot Convert to Primary UOM',c_api_name,1);
1181: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-PRIMARY-UOM');
1182: fnd_msg_pub.ADD;
1183: RAISE fnd_api.g_exc_error;
1184: END IF;
1185: END IF;
1186: END IF;

Line 1210: fnd_msg_pub.add;

1206: Exception
1207: When No_Data_Found Then
1208: debug('For Sales Orders, RMA and Internal Orders DEMAND_SOURCE_HEADER_id Should be mtl_sales_order sales_order_id',c_api_name,1);
1209: fnd_message.set_name('INV','INV_INVALID_DEMAND_SOURCE');
1210: fnd_msg_pub.add;
1211: raise fnd_api.g_exc_error;
1212: End;
1213: Begin
1214: Select Header_ID into l_oe_order_header_id from OE_Order_Lines_All

Line 1221: fnd_msg_pub.add;

1217: If inv_salesorder.get_salesorder_for_oeheader(l_oe_order_header_id) Is NULL
1218: or inv_salesorder.get_salesorder_for_oeheader(l_oe_order_header_id) <> l_mso_sales_order_id Then
1219: debug('This sales_order_id does not belog to the given demand_source_line_id',c_api_name,1);
1220: fnd_message.set_name('INV','INV_INVALID_DEMAND_SOURCE');
1221: fnd_msg_pub.add;
1222: raise fnd_api.g_exc_error;
1223: End If;
1224: EXCEPTION
1225: When No_Data_Found Then

Line 1228: fnd_msg_pub.ADD;

1224: EXCEPTION
1225: When No_Data_Found Then
1226: debug('Demand_Source_line_Id does not exist',c_api_name,1);
1227: fnd_message.set_name('INV', 'INV_INVALID_SALES_ORDER');
1228: fnd_msg_pub.ADD;
1229: RAISE fnd_api.g_exc_error;
1230: End;
1231: End If;
1232: End if;

Line 1485: fnd_msg_pub.add;

1481: end if;
1482:
1483: -- Add message to message list
1484: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_NOT_FOUND');
1485: fnd_msg_pub.add;
1486:
1487: fnd_msg_pub.count_and_get(
1488: p_count => x_msg_count
1489: , p_data => x_msg_data

Line 1487: fnd_msg_pub.count_and_get(

1483: -- Add message to message list
1484: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_NOT_FOUND');
1485: fnd_msg_pub.add;
1486:
1487: fnd_msg_pub.count_and_get(
1488: p_count => x_msg_count
1489: , p_data => x_msg_data
1490: , p_encoded => 'F');
1491:

Line 1494: x_error_text := fnd_msg_pub.get(1, 'F');

1490: , p_encoded => 'F');
1491:
1492: -- Load error code and text
1493: x_error_code := 1;
1494: x_error_text := fnd_msg_pub.get(1, 'F');
1495:
1496: if (p_form_mode in ('N','n')) then
1497: print_error(x_msg_count);
1498: end if;

Line 1513: fnd_msg_pub.add;

1509: end if;
1510:
1511: -- Add message to message list
1512: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_INVALID_CODE');
1513: fnd_msg_pub.add;
1514:
1515: fnd_msg_pub.count_and_get(
1516: p_count => x_msg_count
1517: , p_data => x_msg_data

Line 1515: fnd_msg_pub.count_and_get(

1511: -- Add message to message list
1512: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_INVALID_CODE');
1513: fnd_msg_pub.add;
1514:
1515: fnd_msg_pub.count_and_get(
1516: p_count => x_msg_count
1517: , p_data => x_msg_data
1518: , p_encoded => 'F');
1519:

Line 1522: x_error_text := fnd_msg_pub.get(1, 'F');

1518: , p_encoded => 'F');
1519:
1520: -- Load error code and text
1521: x_error_code := 1;
1522: x_error_text := fnd_msg_pub.get(1, 'F');
1523:
1524: if (p_form_mode in ('N','n')) then
1525: print_error(x_msg_count);
1526: end if;

Line 1539: fnd_msg_pub.count_and_get(

1535: to_char(p_reservation_interface_id));
1536: fnd_file.put_line(fnd_file.log,fnd_message.get);
1537: end if;
1538:
1539: fnd_msg_pub.count_and_get(
1540: p_count => x_msg_count
1541: , p_data => x_msg_data
1542: , p_encoded => 'F');
1543:

Line 1546: x_error_text := fnd_msg_pub.get(1, 'F');

1542: , p_encoded => 'F');
1543:
1544: -- Load error code and text
1545: x_error_code := 1;
1546: x_error_text := fnd_msg_pub.get(1, 'F');
1547:
1548: if (p_form_mode in ('N','n')) then
1549: print_error(x_msg_count);
1550: end if;

Line 1563: fnd_msg_pub.count_and_get(

1559: to_char(p_reservation_interface_id));
1560: fnd_file.put_line(fnd_file.log,fnd_message.get);
1561: end if;
1562:
1563: fnd_msg_pub.count_and_get(
1564: p_count => x_msg_count
1565: , p_data => x_msg_data
1566: , p_encoded => 'F');
1567:

Line 1570: x_error_text := fnd_msg_pub.get(1, 'F');

1566: , p_encoded => 'F');
1567:
1568: -- Load error code and text
1569: x_error_code := 1;
1570: x_error_text := fnd_msg_pub.get(1, 'F');
1571:
1572: if (p_form_mode in ('N','n')) then
1573: print_error(x_msg_count);
1574: end if;

Line 1587: if (fnd_msg_pub.check_msg_level

1583: to_char(p_reservation_interface_id));
1584: fnd_file.put_line(fnd_file.log,fnd_message.get);
1585: end if;
1586:
1587: if (fnd_msg_pub.check_msg_level
1588: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1589: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1590: end if;
1591:

Line 1588: (fnd_msg_pub.g_msg_lvl_unexp_error))then

1584: fnd_file.put_line(fnd_file.log,fnd_message.get);
1585: end if;
1586:
1587: if (fnd_msg_pub.check_msg_level
1588: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1589: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1590: end if;
1591:
1592: fnd_msg_pub.count_and_get(

Line 1589: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);

1585: end if;
1586:
1587: if (fnd_msg_pub.check_msg_level
1588: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1589: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1590: end if;
1591:
1592: fnd_msg_pub.count_and_get(
1593: p_count => x_msg_count

Line 1592: fnd_msg_pub.count_and_get(

1588: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1589: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1590: end if;
1591:
1592: fnd_msg_pub.count_and_get(
1593: p_count => x_msg_count
1594: , p_data => x_msg_data
1595: , p_encoded => 'F');
1596:

Line 1599: x_error_text := fnd_msg_pub.get(1, 'F');

1595: , p_encoded => 'F');
1596:
1597: -- Load error code and text
1598: x_error_code := 1;
1599: x_error_text := fnd_msg_pub.get(1, 'F');
1600:
1601: if (p_form_mode in ('N','n')) then
1602: print_error(x_msg_count);
1603: end if;

Line 1634: l_msg_data := fnd_msg_pub.get(i, 'F');

1630: if p_msg_count = 0 then
1631: null;
1632: else
1633: for i in 1..p_msg_count loop
1634: l_msg_data := fnd_msg_pub.get(i, 'F');
1635: fnd_file.put_line(fnd_file.log, l_msg_data);
1636: end loop;
1637:
1638: fnd_file.put_line(fnd_file.log, ' ');

Line 1641: fnd_msg_pub.initialize;

1637:
1638: fnd_file.put_line(fnd_file.log, ' ');
1639: end if;
1640:
1641: fnd_msg_pub.initialize;
1642:
1643: exception
1644: when others then
1645: fnd_file.put_line(fnd_file.log, sqlerrm);