DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on FND_MSG_PUB

Line 219: fnd_msg_pub.initialize;

215: END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF fnd_api.to_boolean(p_init_msg_list) THEN
219: fnd_msg_pub.initialize;
220: END IF;
221:
222: -- Initialize API return status to success
223: x_return_status := fnd_api.g_ret_sts_success;

Line 387: x_msg_data := FND_MSG_PUB.GET

383: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
384: l_msg_index := 1;
385: l_msg_count := x_msg_count;
386: WHILE l_msg_count > 0 LOOP
387: x_msg_data := FND_MSG_PUB.GET
388: ( l_msg_index,
389: FND_API.G_FALSE );
390: -- csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
391: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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

410: COMMIT WORK;
411: END IF;
412:
413: -- Standard call to get message count and if count is 1, get message info.
414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO insert_row;
418: x_return_status := fnd_api.g_ret_sts_error;

Line 419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/

415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO insert_row;
418: x_return_status := fnd_api.g_ret_sts_error;
419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
420: WHEN fnd_api.g_exc_unexpected_error THEN
421: ROLLBACK TO insert_row;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: /*fnd_msg_pub.count_and_get(

Line 423: /*fnd_msg_pub.count_and_get(

419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
420: WHEN fnd_api.g_exc_unexpected_error THEN
421: ROLLBACK TO insert_row;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: /*fnd_msg_pub.count_and_get(
424: p_count => x_msg_count
425: ,p_data => x_msg_data);*/
426: WHEN OTHERS THEN
427: ROLLBACK TO insert_row;

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

426: WHEN OTHERS THEN
427: ROLLBACK TO insert_row;
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429:
430: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
432: END IF;
433:
434: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */

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

427: ROLLBACK TO insert_row;
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429:
430: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
432: END IF;
433:
434: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */
435:

Line 434: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */

430: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
432: END IF;
433:
434: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */
435:
436:
437: end insert_row;
438:

Line 545: fnd_msg_pub.initialize;

541: END IF;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.
544: IF fnd_api.to_boolean(p_init_msg_list) THEN
545: fnd_msg_pub.initialize;
546: END IF;
547:
548: -- Initialize API return status to success
549: x_return_status := fnd_api.g_ret_sts_success;

Line 749: FND_MSG_PUB.Add;

745: where instance_id = p_instance_id;
746:
747: if (l_old_location_type_code = 'INVENTORY') then
748: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_LOCATION_UPDATE');
749: FND_MSG_PUB.Add;
750: RAISE FND_API.G_EXC_ERROR;
751: end if;
752: end if;
753: end if;

Line 782: x_msg_data := FND_MSG_PUB.GET

778: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
779: l_msg_index := 1;
780: l_msg_count := x_msg_count;
781: WHILE l_msg_count > 0 LOOP
782: x_msg_data := FND_MSG_PUB.GET
783: ( l_msg_index,
784: FND_API.G_FALSE );
785: -- csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
786: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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

803: COMMIT WORK;
804: END IF;
805:
806: -- Standard call to get message count and if count is 1, get message info.
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
808: EXCEPTION
809: WHEN fnd_api.g_exc_error THEN
810: ROLLBACK TO update_row;
811: x_return_status := fnd_api.g_ret_sts_error;

Line 812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/

808: EXCEPTION
809: WHEN fnd_api.g_exc_error THEN
810: ROLLBACK TO update_row;
811: x_return_status := fnd_api.g_ret_sts_error;
812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: ROLLBACK TO update_row;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: /*fnd_msg_pub.count_and_get(

Line 816: /*fnd_msg_pub.count_and_get(

812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: ROLLBACK TO update_row;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: /*fnd_msg_pub.count_and_get(
817: p_count => x_msg_count
818: ,p_data => x_msg_data);*/
819: WHEN OTHERS THEN
820: ROLLBACK TO update_row;

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

819: WHEN OTHERS THEN
820: ROLLBACK TO update_row;
821: x_return_status := fnd_api.g_ret_sts_unexp_error;
822:
823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
824: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
825: END IF;
826:
827: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */

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

820: ROLLBACK TO update_row;
821: x_return_status := fnd_api.g_ret_sts_unexp_error;
822:
823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
824: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
825: END IF;
826:
827: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */
828:

Line 827: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */

823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
824: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
825: END IF;
826:
827: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data); */
828:
829: end update_row;
830:
831: PROCEDURE LOCK_ROW(

Line 1166: fnd_msg_pub.initialize;

1162: END IF;
1163:
1164: -- Initialize message list if p_init_msg_list is set to TRUE.
1165: IF fnd_api.to_boolean(p_init_msg_list) THEN
1166: fnd_msg_pub.initialize;
1167: END IF;
1168:
1169: -- Initialize API return status to success
1170: x_return_status := fnd_api.g_ret_sts_success;

Line 1294: fnd_msg_pub.count_and_get(

1290: COMMIT WORK;
1291: END IF;
1292:
1293: -- Standard call to get message count and if count is 1, get message info.
1294: fnd_msg_pub.count_and_get(
1295: p_count => x_msg_count
1296: ,p_data => x_msg_data);
1297:
1298:

Line 1303: /*fnd_msg_pub.count_and_get(

1299: EXCEPTION
1300: WHEN fnd_api.g_exc_error THEN
1301: ROLLBACK TO create_asset;
1302: x_return_status := fnd_api.g_ret_sts_error;
1303: /*fnd_msg_pub.count_and_get(
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);*/
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_asset;

Line 1309: /*fnd_msg_pub.count_and_get(

1305: ,p_data => x_msg_data);*/
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_asset;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: /*fnd_msg_pub.count_and_get(
1310: p_count => x_msg_count
1311: ,p_data => x_msg_data);*/
1312: WHEN OTHERS THEN
1313: ROLLBACK TO create_asset;

Line 1316: IF fnd_msg_pub.check_msg_level(

1312: WHEN OTHERS THEN
1313: ROLLBACK TO create_asset;
1314: x_return_status := fnd_api.g_ret_sts_unexp_error;
1315:
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1319: END IF;
1320:

Line 1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1313: ROLLBACK TO create_asset;
1314: x_return_status := fnd_api.g_ret_sts_unexp_error;
1315:
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1319: END IF;
1320:
1321: /*fnd_msg_pub.count_and_get(

Line 1318: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

1314: x_return_status := fnd_api.g_ret_sts_unexp_error;
1315:
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1319: END IF;
1320:
1321: /*fnd_msg_pub.count_and_get(
1322: p_count => x_msg_count

Line 1321: /*fnd_msg_pub.count_and_get(

1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1319: END IF;
1320:
1321: /*fnd_msg_pub.count_and_get(
1322: p_count => x_msg_count
1323: ,p_data => x_msg_data);*/
1324:
1325: end create_asset;

Line 1431: fnd_msg_pub.initialize;

1427: END IF;
1428:
1429: -- Initialize message list if p_init_msg_list is set to TRUE.
1430: IF fnd_api.to_boolean(p_init_msg_list) THEN
1431: fnd_msg_pub.initialize;
1432: END IF;
1433:
1434: -- Initialize API return status to success
1435: x_return_status := fnd_api.g_ret_sts_success;

Line 1663: fnd_msg_pub.count_and_get(

1659: END IF;
1660:
1661:
1662: -- Standard call to get message count and if count is 1, get message info.
1663: fnd_msg_pub.count_and_get(
1664: p_count => x_msg_count
1665: ,p_data => x_msg_data);
1666:
1667:

Line 1672: /*fnd_msg_pub.count_and_get(

1668: EXCEPTION
1669: WHEN fnd_api.g_exc_error THEN
1670: ROLLBACK TO update_asset;
1671: x_return_status := fnd_api.g_ret_sts_error;
1672: /*fnd_msg_pub.count_and_get(
1673: p_count => x_msg_count
1674: ,p_data => x_msg_data);*/
1675: WHEN fnd_api.g_exc_unexpected_error THEN
1676: ROLLBACK TO update_asset;

Line 1678: /*fnd_msg_pub.count_and_get(

1674: ,p_data => x_msg_data);*/
1675: WHEN fnd_api.g_exc_unexpected_error THEN
1676: ROLLBACK TO update_asset;
1677: x_return_status := fnd_api.g_ret_sts_unexp_error;
1678: /*fnd_msg_pub.count_and_get(
1679: p_count => x_msg_count
1680: ,p_data => x_msg_data);*/
1681: WHEN OTHERS THEN
1682: ROLLBACK TO update_asset;

Line 1685: IF fnd_msg_pub.check_msg_level(

1681: WHEN OTHERS THEN
1682: ROLLBACK TO update_asset;
1683: x_return_status := fnd_api.g_ret_sts_unexp_error;
1684:
1685: IF fnd_msg_pub.check_msg_level(
1686: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1687: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1688: END IF;
1689:

Line 1686: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1682: ROLLBACK TO update_asset;
1683: x_return_status := fnd_api.g_ret_sts_unexp_error;
1684:
1685: IF fnd_msg_pub.check_msg_level(
1686: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1687: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1688: END IF;
1689:
1690: /*fnd_msg_pub.count_and_get(

Line 1687: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

1683: x_return_status := fnd_api.g_ret_sts_unexp_error;
1684:
1685: IF fnd_msg_pub.check_msg_level(
1686: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1687: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1688: END IF;
1689:
1690: /*fnd_msg_pub.count_and_get(
1691: p_count => x_msg_count

Line 1690: /*fnd_msg_pub.count_and_get(

1686: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1687: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1688: END IF;
1689:
1690: /*fnd_msg_pub.count_and_get(
1691: p_count => x_msg_count
1692: ,p_data => x_msg_data);*/
1693:
1694:

Line 1732: fnd_msg_pub.initialize;

1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF fnd_api.to_boolean(p_init_msg_list) THEN
1732: fnd_msg_pub.initialize;
1733: END IF;
1734:
1735: -- Initialize API return status to success
1736: x_return_status := fnd_api.g_ret_sts_success;

Line 1787: fnd_msg_pub.count_and_get(

1783: COMMIT WORK;
1784: END IF;
1785:
1786: -- Standard call to get message count and if count is 1, get message info.
1787: fnd_msg_pub.count_and_get(
1788: p_count => x_msg_count
1789: ,p_data => x_msg_data);
1790:
1791:

Line 1796: fnd_msg_pub.count_and_get(

1792: EXCEPTION
1793: WHEN fnd_api.g_exc_error THEN
1794: ROLLBACK TO serial_check;
1795: x_return_status := fnd_api.g_ret_sts_error;
1796: fnd_msg_pub.count_and_get(
1797: p_count => x_msg_count
1798: ,p_data => x_msg_data);
1799: WHEN fnd_api.g_exc_unexpected_error THEN
1800: ROLLBACK TO serial_check;

Line 1802: fnd_msg_pub.count_and_get(

1798: ,p_data => x_msg_data);
1799: WHEN fnd_api.g_exc_unexpected_error THEN
1800: ROLLBACK TO serial_check;
1801: x_return_status := fnd_api.g_ret_sts_unexp_error;
1802: fnd_msg_pub.count_and_get(
1803: p_count => x_msg_count
1804: ,p_data => x_msg_data);
1805: WHEN OTHERS THEN
1806: ROLLBACK TO serial_check;

Line 1809: IF fnd_msg_pub.check_msg_level(

1805: WHEN OTHERS THEN
1806: ROLLBACK TO serial_check;
1807: x_return_status := fnd_api.g_ret_sts_unexp_error;
1808:
1809: IF fnd_msg_pub.check_msg_level(
1810: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1811: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1812: END IF;
1813:

Line 1810: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1806: ROLLBACK TO serial_check;
1807: x_return_status := fnd_api.g_ret_sts_unexp_error;
1808:
1809: IF fnd_msg_pub.check_msg_level(
1810: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1811: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1812: END IF;
1813:
1814: fnd_msg_pub.count_and_get(

Line 1811: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

1807: x_return_status := fnd_api.g_ret_sts_unexp_error;
1808:
1809: IF fnd_msg_pub.check_msg_level(
1810: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1811: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1812: END IF;
1813:
1814: fnd_msg_pub.count_and_get(
1815: p_count => x_msg_count

Line 1814: fnd_msg_pub.count_and_get(

1810: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1811: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1812: END IF;
1813:
1814: fnd_msg_pub.count_and_get(
1815: p_count => x_msg_count
1816: ,p_data => x_msg_data);
1817:
1818: END SERIAL_CHECK;