APPS.OZF_REFRESH_VIEW_PVT dependencies on FND_API

Line 17: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

13: l_user_id NUMBER := FND_GLOBAL.USER_ID();
14: x_msg_count NUMBER;
15: x_msg_data VARCHAR2(240);
16: x_return_status VARCHAR2(1) ;
17: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
18:
19: l_view_name varchar2(30);
20: BEGIN
21: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': Start');

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: BEGIN
21: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': Start');
22:
23: -- Initialize API return status to SUCCESS
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25:
26: IF p_view_name = 'EARNING' THEN
27: l_view_name := 'OZF_EARNING_SUMMARY_MV';
28: ELSIF p_view_name = 'INVENTORY' THEN

Line 54: WHEN FND_API.G_EXC_ERROR THEN

50: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
51:
52: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: x_return_status := FND_API.g_ret_sts_error ;
56: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
57: p_count => x_msg_count,
58: p_data => x_msg_data);

Line 55: x_return_status := FND_API.g_ret_sts_error ;

51:
52: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: x_return_status := FND_API.g_ret_sts_error ;
56: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
57: p_count => x_msg_count,
58: p_data => x_msg_data);
59: ERRBUF := x_msg_data;

Line 56: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

52: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: x_return_status := FND_API.g_ret_sts_error ;
56: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
57: p_count => x_msg_count,
58: p_data => x_msg_data);
59: ERRBUF := x_msg_data;
60: RETCODE := 2;

Line 63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

59: ERRBUF := x_msg_data;
60: RETCODE := 2;
61: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: x_return_status := FND_API.g_ret_sts_unexp_error ;
65: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
66: p_count => x_msg_count,
67: p_data => x_msg_data);

Line 64: x_return_status := FND_API.g_ret_sts_unexp_error ;

60: RETCODE := 2;
61: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: x_return_status := FND_API.g_ret_sts_unexp_error ;
65: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
66: p_count => x_msg_count,
67: p_data => x_msg_data);
68: ERRBUF := x_msg_data;

Line 65: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

61: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: x_return_status := FND_API.g_ret_sts_unexp_error ;
65: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
66: p_count => x_msg_count,
67: p_data => x_msg_data);
68: ERRBUF := x_msg_data;
69: RETCODE := 2;

Line 73: x_return_status := FND_API.g_ret_sts_unexp_error ;

69: RETCODE := 2;
70: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');
71:
72: WHEN OTHERS THEN
73: x_return_status := FND_API.g_ret_sts_unexp_error ;
74: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
75: p_count => x_msg_count,
76: p_data => x_msg_data);
77:

Line 74: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

70: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');
71:
72: WHEN OTHERS THEN
73: x_return_status := FND_API.g_ret_sts_unexp_error ;
74: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
75: p_count => x_msg_count,
76: p_data => x_msg_data);
77:
78: ERRBUF := sqlerrm(sqlcode);