DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on FND_MSG_PUB

Line 659: FND_MSG_PUB.initialize;

655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661: -- Initialize API return status to success
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: -- API body

Line 776: FND_MSG_PUB.Count_And_Get

772: --dbms_output.put_line('committing');
773: COMMIT WORK;
774: END IF;
775: -- Standard call to get message count and if count is 1, get message info.
776: FND_MSG_PUB.Count_And_Get
777: ( p_count => x_msg_count ,
778: p_data => x_msg_data
779: );
780: EXCEPTION

Line 783: FND_MSG_PUB.Count_And_Get

779: );
780: EXCEPTION
781: WHEN FND_API.G_EXC_ERROR THEN
782: x_return_status := FND_API.G_RET_STS_ERROR ;
783: FND_MSG_PUB.Count_And_Get
784: ( p_count => x_msg_count ,
785: p_data => x_msg_data
786: );
787:

Line 791: FND_MSG_PUB.Count_And_Get

787:
788:
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: FND_MSG_PUB.Count_And_Get
792: (
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );

Line 799: IF FND_MSG_PUB.Check_Msg_Level

795: );
796:
797: WHEN OTHERS THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799: IF FND_MSG_PUB.Check_Msg_Level
800: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: FND_MSG_PUB.Add_Exc_Msg
803: ( G_PKG_NAME,

Line 800: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

796:
797: WHEN OTHERS THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799: IF FND_MSG_PUB.Check_Msg_Level
800: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: FND_MSG_PUB.Add_Exc_Msg
803: ( G_PKG_NAME,
804: l_api_name||'('||l_stmt_num||')'

Line 802: FND_MSG_PUB.Add_Exc_Msg

798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799: IF FND_MSG_PUB.Check_Msg_Level
800: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: FND_MSG_PUB.Add_Exc_Msg
803: ( G_PKG_NAME,
804: l_api_name||'('||l_stmt_num||')'
805: );
806: END IF;

Line 807: FND_MSG_PUB.Count_And_Get

803: ( G_PKG_NAME,
804: l_api_name||'('||l_stmt_num||')'
805: );
806: END IF;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );
811:

Line 912: FND_MSG_PUB.initialize;

908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: -- Initialize message list if p_init_msg_list is set to TRUE.
911: IF FND_API.to_Boolean( p_init_msg_list ) THEN
912: FND_MSG_PUB.initialize;
913: END IF;
914: -- Initialize API return status to success
915: x_return_status := FND_API.G_RET_STS_SUCCESS;
916: -- API body

Line 1052: FND_MSG_PUB.Count_And_Get

1048: --dbms_output.put_line('committing');
1049: COMMIT WORK;
1050: END IF;
1051: -- Standard call to get message count and if count is 1, get message info.
1052: FND_MSG_PUB.Count_And_Get
1053: ( p_count => x_msg_count ,
1054: p_data => x_msg_data
1055: );
1056: EXCEPTION

Line 1059: FND_MSG_PUB.Count_And_Get

1055: );
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: x_return_status := FND_API.G_RET_STS_ERROR ;
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_count => x_msg_count ,
1061: p_data => x_msg_data
1062: );
1063:

Line 1067: FND_MSG_PUB.Count_And_Get

1063:
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067: FND_MSG_PUB.Count_And_Get
1068: (
1069: p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );

Line 1075: IF FND_MSG_PUB.Check_Msg_Level

1071: );
1072:
1073: WHEN OTHERS THEN
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075: IF FND_MSG_PUB.Check_Msg_Level
1076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1077: THEN
1078: FND_MSG_PUB.Add_Exc_Msg
1079: ( G_PKG_NAME,

Line 1076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1072:
1073: WHEN OTHERS THEN
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075: IF FND_MSG_PUB.Check_Msg_Level
1076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1077: THEN
1078: FND_MSG_PUB.Add_Exc_Msg
1079: ( G_PKG_NAME,
1080: l_api_name||'('||l_stmt_num||')'

Line 1078: FND_MSG_PUB.Add_Exc_Msg

1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075: IF FND_MSG_PUB.Check_Msg_Level
1076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1077: THEN
1078: FND_MSG_PUB.Add_Exc_Msg
1079: ( G_PKG_NAME,
1080: l_api_name||'('||l_stmt_num||')'
1081: );
1082: END IF;

Line 1083: FND_MSG_PUB.Count_And_Get

1079: ( G_PKG_NAME,
1080: l_api_name||'('||l_stmt_num||')'
1081: );
1082: END IF;
1083: FND_MSG_PUB.Count_And_Get
1084: ( p_count => x_msg_count,
1085: p_data => x_msg_data
1086: );
1087:

Line 1203: fnd_msg_pub.initialize;

1199:
1200: l_stmt_num := 30;
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF fnd_api.to_boolean(p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: l_stmt_num := 40;
1207: -- Initialize API return status to success

Line 1416: fnd_msg_pub.count_and_get(

1412: END IF;
1413:
1414: l_stmt_num := 999;
1415: -- Standard call to get message count and if count is 1, get message info.
1416: fnd_msg_pub.count_and_get(
1417: p_count => x_msg_count
1418: ,p_data => x_msg_data);
1419: EXCEPTION
1420: WHEN fnd_api.g_exc_error THEN

Line 1423: fnd_msg_pub.count_and_get(

1419: EXCEPTION
1420: WHEN fnd_api.g_exc_error THEN
1421: ROLLBACK TO get_insert_into_wro_pvt;
1422: x_return_status := fnd_api.g_ret_sts_error;
1423: fnd_msg_pub.count_and_get(
1424: -- p_encoded => FND_API.g_false
1425: p_count => x_msg_count
1426: ,p_data => x_msg_data);
1427: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1431: fnd_msg_pub.count_and_get(

1427: WHEN fnd_api.g_exc_unexpected_error THEN
1428: ROLLBACK TO get_insert_into_wro_pvt;
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430:
1431: fnd_msg_pub.count_and_get(
1432: p_count => x_msg_count
1433: ,p_data => x_msg_data);
1434: WHEN OTHERS THEN
1435: ROLLBACK TO get_insert_into_wro_pvt;

Line 1437: IF fnd_msg_pub.check_msg_level(

1433: ,p_data => x_msg_data);
1434: WHEN OTHERS THEN
1435: ROLLBACK TO get_insert_into_wro_pvt;
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;
1437: IF fnd_msg_pub.check_msg_level(
1438: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1440: END IF;
1441:

Line 1438: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1434: WHEN OTHERS THEN
1435: ROLLBACK TO get_insert_into_wro_pvt;
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;
1437: IF fnd_msg_pub.check_msg_level(
1438: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1440: END IF;
1441:
1442: fnd_msg_pub.count_and_get(

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

1435: ROLLBACK TO get_insert_into_wro_pvt;
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;
1437: IF fnd_msg_pub.check_msg_level(
1438: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1440: END IF;
1441:
1442: fnd_msg_pub.count_and_get(
1443: p_count => x_msg_count

Line 1442: fnd_msg_pub.count_and_get(

1438: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1440: END IF;
1441:
1442: fnd_msg_pub.count_and_get(
1443: p_count => x_msg_count
1444: ,p_data => x_msg_data);
1445:
1446: END insert_into_wro;

Line 1569: fnd_msg_pub.initialize;

1565:
1566: l_stmt_num := 30;
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF fnd_api.to_boolean(p_init_msg_list) THEN
1569: fnd_msg_pub.initialize;
1570: END IF;
1571:
1572: l_stmt_num := 40;
1573: -- Initialize API return status to success

Line 1778: fnd_msg_pub.count_and_get(

1774: END IF;
1775:
1776: l_stmt_num := 999;
1777: -- Standard call to get message count and if count is 1, get message info.
1778: fnd_msg_pub.count_and_get(
1779: p_count => x_msg_count
1780: ,p_data => x_msg_data);
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN

Line 1785: fnd_msg_pub.count_and_get(

1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN
1783: ROLLBACK TO get_insert_into_wro_pvt;
1784: x_return_status := fnd_api.g_ret_sts_error;
1785: fnd_msg_pub.count_and_get(
1786: -- p_encoded => FND_API.g_false
1787: p_count => x_msg_count
1788: ,p_data => x_msg_data);
1789: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1793: fnd_msg_pub.count_and_get(

1789: WHEN fnd_api.g_exc_unexpected_error THEN
1790: ROLLBACK TO get_insert_into_wro_pvt;
1791: x_return_status := fnd_api.g_ret_sts_unexp_error;
1792:
1793: fnd_msg_pub.count_and_get(
1794: p_count => x_msg_count
1795: ,p_data => x_msg_data);
1796: WHEN OTHERS THEN
1797: ROLLBACK TO get_insert_into_wro_pvt;

Line 1799: IF fnd_msg_pub.check_msg_level(

1795: ,p_data => x_msg_data);
1796: WHEN OTHERS THEN
1797: ROLLBACK TO get_insert_into_wro_pvt;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: IF fnd_msg_pub.check_msg_level(
1800: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1801: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1802: END IF;
1803:

Line 1800: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1796: WHEN OTHERS THEN
1797: ROLLBACK TO get_insert_into_wro_pvt;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: IF fnd_msg_pub.check_msg_level(
1800: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1801: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1802: END IF;
1803:
1804: fnd_msg_pub.count_and_get(

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

1797: ROLLBACK TO get_insert_into_wro_pvt;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: IF fnd_msg_pub.check_msg_level(
1800: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1801: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1802: END IF;
1803:
1804: fnd_msg_pub.count_and_get(
1805: p_count => x_msg_count

Line 1804: fnd_msg_pub.count_and_get(

1800: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1801: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1802: END IF;
1803:
1804: fnd_msg_pub.count_and_get(
1805: p_count => x_msg_count
1806: ,p_data => x_msg_data);
1807:
1808: END insert_into_wdi;