DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on FND_MSG_PUB

Line 1018: FND_MSG_PUB.initialize;

1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020: -- Initialize API return status to success
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;
1022: -- API body

Line 1135: FND_MSG_PUB.Count_And_Get

1131: --dbms_output.put_line('committing');
1132: COMMIT WORK;
1133: END IF;
1134: -- Standard call to get message count and if count is 1, get message info.
1135: FND_MSG_PUB.Count_And_Get
1136: ( p_count => x_msg_count ,
1137: p_data => x_msg_data
1138: );
1139: EXCEPTION

Line 1142: FND_MSG_PUB.Count_And_Get

1138: );
1139: EXCEPTION
1140: WHEN FND_API.G_EXC_ERROR THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR ;
1142: FND_MSG_PUB.Count_And_Get
1143: ( p_count => x_msg_count ,
1144: p_data => x_msg_data
1145: );
1146:

Line 1150: FND_MSG_PUB.Count_And_Get

1146:
1147:
1148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150: FND_MSG_PUB.Count_And_Get
1151: (
1152: p_count => x_msg_count,
1153: p_data => x_msg_data
1154: );

Line 1158: IF FND_MSG_PUB.Check_Msg_Level

1154: );
1155:
1156: WHEN OTHERS THEN
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1158: IF FND_MSG_PUB.Check_Msg_Level
1159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: FND_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME,

Line 1159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1155:
1156: WHEN OTHERS THEN
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1158: IF FND_MSG_PUB.Check_Msg_Level
1159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: FND_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME,
1163: l_api_name||'('||l_stmt_num||')'

Line 1161: FND_MSG_PUB.Add_Exc_Msg

1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1158: IF FND_MSG_PUB.Check_Msg_Level
1159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: FND_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME,
1163: l_api_name||'('||l_stmt_num||')'
1164: );
1165: END IF;

Line 1166: FND_MSG_PUB.Count_And_Get

1162: ( G_PKG_NAME,
1163: l_api_name||'('||l_stmt_num||')'
1164: );
1165: END IF;
1166: FND_MSG_PUB.Count_And_Get
1167: ( p_count => x_msg_count,
1168: p_data => x_msg_data
1169: );
1170:

Line 1271: FND_MSG_PUB.initialize;

1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268: END IF;
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1271: FND_MSG_PUB.initialize;
1272: END IF;
1273: -- Initialize API return status to success
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275: -- API body

Line 1411: FND_MSG_PUB.Count_And_Get

1407: --dbms_output.put_line('committing');
1408: COMMIT WORK;
1409: END IF;
1410: -- Standard call to get message count and if count is 1, get message info.
1411: FND_MSG_PUB.Count_And_Get
1412: ( p_count => x_msg_count ,
1413: p_data => x_msg_data
1414: );
1415: EXCEPTION

Line 1418: FND_MSG_PUB.Count_And_Get

1414: );
1415: EXCEPTION
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: x_return_status := FND_API.G_RET_STS_ERROR ;
1418: FND_MSG_PUB.Count_And_Get
1419: ( p_count => x_msg_count ,
1420: p_data => x_msg_data
1421: );
1422:

Line 1426: FND_MSG_PUB.Count_And_Get

1422:
1423:
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1426: FND_MSG_PUB.Count_And_Get
1427: (
1428: p_count => x_msg_count,
1429: p_data => x_msg_data
1430: );

Line 1434: IF FND_MSG_PUB.Check_Msg_Level

1430: );
1431:
1432: WHEN OTHERS THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434: IF FND_MSG_PUB.Check_Msg_Level
1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg
1438: ( G_PKG_NAME,

Line 1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1431:
1432: WHEN OTHERS THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434: IF FND_MSG_PUB.Check_Msg_Level
1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg
1438: ( G_PKG_NAME,
1439: l_api_name||'('||l_stmt_num||')'

Line 1437: FND_MSG_PUB.Add_Exc_Msg

1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434: IF FND_MSG_PUB.Check_Msg_Level
1435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg
1438: ( G_PKG_NAME,
1439: l_api_name||'('||l_stmt_num||')'
1440: );
1441: END IF;

Line 1442: FND_MSG_PUB.Count_And_Get

1438: ( G_PKG_NAME,
1439: l_api_name||'('||l_stmt_num||')'
1440: );
1441: END IF;
1442: FND_MSG_PUB.Count_And_Get
1443: ( p_count => x_msg_count,
1444: p_data => x_msg_data
1445: );
1446:

Line 1562: fnd_msg_pub.initialize;

1558:
1559: l_stmt_num := 30;
1560: -- Initialize message list if p_init_msg_list is set to TRUE.
1561: IF fnd_api.to_boolean(p_init_msg_list) THEN
1562: fnd_msg_pub.initialize;
1563: END IF;
1564:
1565: l_stmt_num := 40;
1566: -- Initialize API return status to success

Line 1782: fnd_msg_pub.count_and_get(

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

Line 1789: fnd_msg_pub.count_and_get(

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

Line 1797: fnd_msg_pub.count_and_get(

1793: WHEN fnd_api.g_exc_unexpected_error THEN
1794: ROLLBACK TO get_insert_into_wro_pvt;
1795: x_return_status := fnd_api.g_ret_sts_unexp_error;
1796:
1797: fnd_msg_pub.count_and_get(
1798: p_count => x_msg_count
1799: ,p_data => x_msg_data);
1800: WHEN OTHERS THEN
1801: ROLLBACK TO get_insert_into_wro_pvt;

Line 1803: IF fnd_msg_pub.check_msg_level(

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

Line 1804: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1800: WHEN OTHERS THEN
1801: ROLLBACK TO get_insert_into_wro_pvt;
1802: x_return_status := fnd_api.g_ret_sts_unexp_error;
1803: IF fnd_msg_pub.check_msg_level(
1804: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1805: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1806: END IF;
1807:
1808: fnd_msg_pub.count_and_get(

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

1801: ROLLBACK TO get_insert_into_wro_pvt;
1802: x_return_status := fnd_api.g_ret_sts_unexp_error;
1803: IF fnd_msg_pub.check_msg_level(
1804: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1805: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1806: END IF;
1807:
1808: fnd_msg_pub.count_and_get(
1809: p_count => x_msg_count

Line 1808: fnd_msg_pub.count_and_get(

1804: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1805: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1806: END IF;
1807:
1808: fnd_msg_pub.count_and_get(
1809: p_count => x_msg_count
1810: ,p_data => x_msg_data);
1811:
1812: END insert_into_wro;

Line 1935: fnd_msg_pub.initialize;

1931:
1932: l_stmt_num := 30;
1933: -- Initialize message list if p_init_msg_list is set to TRUE.
1934: IF fnd_api.to_boolean(p_init_msg_list) THEN
1935: fnd_msg_pub.initialize;
1936: END IF;
1937:
1938: l_stmt_num := 40;
1939: -- Initialize API return status to success

Line 2144: fnd_msg_pub.count_and_get(

2140: END IF;
2141:
2142: l_stmt_num := 999;
2143: -- Standard call to get message count and if count is 1, get message info.
2144: fnd_msg_pub.count_and_get(
2145: p_count => x_msg_count
2146: ,p_data => x_msg_data);
2147: EXCEPTION
2148: WHEN fnd_api.g_exc_error THEN

Line 2151: fnd_msg_pub.count_and_get(

2147: EXCEPTION
2148: WHEN fnd_api.g_exc_error THEN
2149: ROLLBACK TO get_insert_into_wro_pvt;
2150: x_return_status := fnd_api.g_ret_sts_error;
2151: fnd_msg_pub.count_and_get(
2152: -- p_encoded => FND_API.g_false
2153: p_count => x_msg_count
2154: ,p_data => x_msg_data);
2155: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2159: fnd_msg_pub.count_and_get(

2155: WHEN fnd_api.g_exc_unexpected_error THEN
2156: ROLLBACK TO get_insert_into_wro_pvt;
2157: x_return_status := fnd_api.g_ret_sts_unexp_error;
2158:
2159: fnd_msg_pub.count_and_get(
2160: p_count => x_msg_count
2161: ,p_data => x_msg_data);
2162: WHEN OTHERS THEN
2163: ROLLBACK TO get_insert_into_wro_pvt;

Line 2165: IF fnd_msg_pub.check_msg_level(

2161: ,p_data => x_msg_data);
2162: WHEN OTHERS THEN
2163: ROLLBACK TO get_insert_into_wro_pvt;
2164: x_return_status := fnd_api.g_ret_sts_unexp_error;
2165: IF fnd_msg_pub.check_msg_level(
2166: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2168: END IF;
2169:

Line 2166: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2162: WHEN OTHERS THEN
2163: ROLLBACK TO get_insert_into_wro_pvt;
2164: x_return_status := fnd_api.g_ret_sts_unexp_error;
2165: IF fnd_msg_pub.check_msg_level(
2166: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2168: END IF;
2169:
2170: fnd_msg_pub.count_and_get(

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

2163: ROLLBACK TO get_insert_into_wro_pvt;
2164: x_return_status := fnd_api.g_ret_sts_unexp_error;
2165: IF fnd_msg_pub.check_msg_level(
2166: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2168: END IF;
2169:
2170: fnd_msg_pub.count_and_get(
2171: p_count => x_msg_count

Line 2170: fnd_msg_pub.count_and_get(

2166: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2168: END IF;
2169:
2170: fnd_msg_pub.count_and_get(
2171: p_count => x_msg_count
2172: ,p_data => x_msg_data);
2173:
2174: END insert_into_wdi;