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 39: ozf_utility_pvt.write_conc_log(' -- Begin Materialized view refresh -- ');

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

Line 46: ozf_utility_pvt.write_conc_log(' -- End Materialized view refresh -- ');

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

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

47:
48: --------------------------------------------------------
49: -- Gather statistics for the use of cost-based optimizer
50: --------------------------------------------------------
51: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
54: END IF;
55:

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

49: -- Gather statistics for the use of cost-based optimizer
50: --------------------------------------------------------
51: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
54: END IF;
55:
56: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
57: EXCEPTION

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

52: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>l_view_name);
53: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
54: END IF;
55:
56: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
57: EXCEPTION
58: WHEN FND_API.G_EXC_ERROR THEN
59: x_return_status := FND_API.g_ret_sts_error ;
60: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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

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

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

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

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

80: p_data => x_msg_data);
81:
82: ERRBUF := sqlerrm(sqlcode);
83: RETCODE := sqlcode;
84: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');
85:
86: END load;
87:
88: PROCEDURE REFRESH_SUMMARY_TABLE(p_table_name IN VARCHAR2) IS

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

124:
125: ddl_curs integer;
126:
127: BEGIN
128: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': Start');
129: -- Initialize API return status to SUCCESS
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: select u.oracle_username

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

681: FOR chg_tbl in dis_obj LOOP
682: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
683: END LOOP;
684: dbms_sql.close_CURSOR(ddl_curs);
685: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
686:
687: /*truncate and rename main table as an intermediate table.
688: rename temp table as main table.
689: rename intermediate table as temp table.*/