DBA Data[Home] [Help]

APPS.INV_RESERVATIONS_INTERFACE dependencies on FND_MSG_PUB

Line 124: fnd_msg_pub.initialize;

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

Line 318: fnd_msg_pub.count_and_get(

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

Line 332: fnd_msg_pub.count_and_get(

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

Line 346: if (fnd_msg_pub.check_msg_level

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

Line 347: (fnd_msg_pub.g_msg_lvl_unexp_error))then

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

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

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

Line 351: fnd_msg_pub.count_and_get(

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

Line 484: fnd_msg_pub.initialize;

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

Line 638: fnd_msg_pub.count_and_get(

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

Line 652: fnd_msg_pub.count_and_get(

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

Line 666: if (fnd_msg_pub.check_msg_level

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

Line 667: (fnd_msg_pub.g_msg_lvl_unexp_error))then

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

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

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

Line 671: fnd_msg_pub.count_and_get(

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

Line 865: fnd_msg_pub.initialize;

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

Line 1135: fnd_msg_pub.add;

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

Line 1150: fnd_msg_pub.ADD;

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

Line 1177: fnd_msg_pub.ADD;

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

Line 1443: fnd_msg_pub.add;

1439: end if;
1440:
1441: -- Add message to message list
1442: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_NOT_FOUND');
1443: fnd_msg_pub.add;
1444:
1445: fnd_msg_pub.count_and_get(
1446: p_count => x_msg_count
1447: , p_data => x_msg_data

Line 1445: fnd_msg_pub.count_and_get(

1441: -- Add message to message list
1442: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_NOT_FOUND');
1443: fnd_msg_pub.add;
1444:
1445: fnd_msg_pub.count_and_get(
1446: p_count => x_msg_count
1447: , p_data => x_msg_data
1448: , p_encoded => 'F');
1449:

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

1448: , p_encoded => 'F');
1449:
1450: -- Load error code and text
1451: x_error_code := 1;
1452: x_error_text := fnd_msg_pub.get(1, 'F');
1453:
1454: if (p_form_mode in ('N','n')) then
1455: print_error(x_msg_count);
1456: end if;

Line 1471: fnd_msg_pub.add;

1467: end if;
1468:
1469: -- Add message to message list
1470: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_INVALID_CODE');
1471: fnd_msg_pub.add;
1472:
1473: fnd_msg_pub.count_and_get(
1474: p_count => x_msg_count
1475: , p_data => x_msg_data

Line 1473: fnd_msg_pub.count_and_get(

1469: -- Add message to message list
1470: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_INVALID_CODE');
1471: fnd_msg_pub.add;
1472:
1473: fnd_msg_pub.count_and_get(
1474: p_count => x_msg_count
1475: , p_data => x_msg_data
1476: , p_encoded => 'F');
1477:

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

1476: , p_encoded => 'F');
1477:
1478: -- Load error code and text
1479: x_error_code := 1;
1480: x_error_text := fnd_msg_pub.get(1, 'F');
1481:
1482: if (p_form_mode in ('N','n')) then
1483: print_error(x_msg_count);
1484: end if;

Line 1497: fnd_msg_pub.count_and_get(

1493: to_char(p_reservation_interface_id));
1494: fnd_file.put_line(fnd_file.log,fnd_message.get);
1495: end if;
1496:
1497: fnd_msg_pub.count_and_get(
1498: p_count => x_msg_count
1499: , p_data => x_msg_data
1500: , p_encoded => 'F');
1501:

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

1500: , p_encoded => 'F');
1501:
1502: -- Load error code and text
1503: x_error_code := 1;
1504: x_error_text := fnd_msg_pub.get(1, 'F');
1505:
1506: if (p_form_mode in ('N','n')) then
1507: print_error(x_msg_count);
1508: end if;

Line 1521: fnd_msg_pub.count_and_get(

1517: to_char(p_reservation_interface_id));
1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519: end if;
1520:
1521: fnd_msg_pub.count_and_get(
1522: p_count => x_msg_count
1523: , p_data => x_msg_data
1524: , p_encoded => 'F');
1525:

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

1524: , p_encoded => 'F');
1525:
1526: -- Load error code and text
1527: x_error_code := 1;
1528: x_error_text := fnd_msg_pub.get(1, 'F');
1529:
1530: if (p_form_mode in ('N','n')) then
1531: print_error(x_msg_count);
1532: end if;

Line 1545: if (fnd_msg_pub.check_msg_level

1541: to_char(p_reservation_interface_id));
1542: fnd_file.put_line(fnd_file.log,fnd_message.get);
1543: end if;
1544:
1545: if (fnd_msg_pub.check_msg_level
1546: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1547: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1548: end if;
1549:

Line 1546: (fnd_msg_pub.g_msg_lvl_unexp_error))then

1542: fnd_file.put_line(fnd_file.log,fnd_message.get);
1543: end if;
1544:
1545: if (fnd_msg_pub.check_msg_level
1546: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1547: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1548: end if;
1549:
1550: fnd_msg_pub.count_and_get(

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

1543: end if;
1544:
1545: if (fnd_msg_pub.check_msg_level
1546: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1547: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1548: end if;
1549:
1550: fnd_msg_pub.count_and_get(
1551: p_count => x_msg_count

Line 1550: fnd_msg_pub.count_and_get(

1546: (fnd_msg_pub.g_msg_lvl_unexp_error))then
1547: fnd_msg_pub.add_exc_msg(g_pkg_name,c_api_name);
1548: end if;
1549:
1550: fnd_msg_pub.count_and_get(
1551: p_count => x_msg_count
1552: , p_data => x_msg_data
1553: , p_encoded => 'F');
1554:

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

1553: , p_encoded => 'F');
1554:
1555: -- Load error code and text
1556: x_error_code := 1;
1557: x_error_text := fnd_msg_pub.get(1, 'F');
1558:
1559: if (p_form_mode in ('N','n')) then
1560: print_error(x_msg_count);
1561: end if;

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

1588: if p_msg_count = 0 then
1589: null;
1590: else
1591: for i in 1..p_msg_count loop
1592: l_msg_data := fnd_msg_pub.get(i, 'F');
1593: fnd_file.put_line(fnd_file.log, l_msg_data);
1594: end loop;
1595:
1596: fnd_file.put_line(fnd_file.log, ' ');

Line 1599: fnd_msg_pub.initialize;

1595:
1596: fnd_file.put_line(fnd_file.log, ' ');
1597: end if;
1598:
1599: fnd_msg_pub.initialize;
1600:
1601: exception
1602: when others then
1603: fnd_file.put_line(fnd_file.log, sqlerrm);