APPS.OZF_REFRESH_VIEW_PVT dependencies on OZF_UTILITY_PVT

Line 21: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': Start');

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');
22:
23: -- Initialize API return status to SUCCESS
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25:

Line 36: ozf_utility_pvt.write_conc_log(' -- Begin Materialized view refresh -- ');

32: ELSIF p_view_name = 'CUSTFUND' THEN
33: l_view_name := 'OZF_CUST_FUND_SUMMARY_MV';
34: END IF;
35:
36: ozf_utility_pvt.write_conc_log(' -- Begin Materialized view refresh -- ');
37:
38: DBMS_MVIEW.REFRESH(
39: list => l_view_name ,
40: method => '?'

Line 43: ozf_utility_pvt.write_conc_log(' -- End Mataerialized view refresh -- ');

39: list => l_view_name ,
40: method => '?'
41: );
42:
43: ozf_utility_pvt.write_conc_log(' -- End Mataerialized view refresh -- ');
44:
45: --------------------------------------------------------
46: -- Gather statistics for the use of cost-based optimizer
47: --------------------------------------------------------

Line 48: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');

44:
45: --------------------------------------------------------
46: -- Gather statistics for the use of cost-based optimizer
47: --------------------------------------------------------
48: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
49: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
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');

Line 50: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');

46: -- Gather statistics for the use of cost-based optimizer
47: --------------------------------------------------------
48: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
49: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
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

Line 52: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');

48: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
49: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
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,

Line 61: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');

57: p_count => x_msg_count,
58: p_data => x_msg_data);
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,

Line 70: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');

66: p_count => x_msg_count,
67: p_data => x_msg_data);
68: ERRBUF := x_msg_data;
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,

Line 80: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');

76: p_data => x_msg_data);
77:
78: ERRBUF := sqlerrm(sqlcode);
79: RETCODE := sqlcode;
80: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');
81:
82: END load;
83:
84: