APPS.ZPB_DATA_COLLECTION_UTIL_PVT dependencies on ZPB_LOG

Line 87: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Building Data Collection ownership view...');

83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: -- API body
86:
87: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Building Data Collection ownership view...');
88:
89: select dataentry_obj_path, dataentry_obj_name
90: into l_query_path, l_query_name
91: from zpb_dc_objects

Line 97: --ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running zpb_aw_status.run_olapi_queries(' ||

93:
94: l_query_key := l_query_path || '/' || l_query_name;
95:
96: --set zpb_status_sql_members
97: --ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running zpb_aw_status.run_olapi_queries(' ||
98: -- l_query_key || ').');
99:
100: --not needed for new cm.setsqlstatus procecure
101: --zpb_aw_status.run_olapi_queries(l_query_key);

Line 104: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running sc.get.dstr.own');

100: --not needed for new cm.setsqlstatus procecure
101: --zpb_aw_status.run_olapi_queries(l_query_key);
102:
103: --run the ownership query
104: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'running sc.get.dstr.own');
105:
106: l_stat_len := zpb_aw.interp('shw sc.get.dstr.own(''' || to_char(p_object_id) || ''', ''' ||
107: to_char(p_user_id) || ''', ''' || p_query_type || ''')');
108:

Line 109: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'sc.get.dstr.own found ' || l_stat_len || ' owners.');

105:
106: l_stat_len := zpb_aw.interp('shw sc.get.dstr.own(''' || to_char(p_object_id) || ''', ''' ||
107: to_char(p_user_id) || ''', ''' || p_query_type || ''')');
108:
109: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'sc.get.dstr.own found ' || l_stat_len || ' owners.');
110:
111: --dbms_output.put_line('Stat Length = ' || l_stat_len);
112:
113: l_length := to_number(l_stat_len);

Line 140: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Data Collection ownership view complete.');

136:
137: x_owner_list := l_lob;
138: end if;
139:
140: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Data Collection ownership view complete.');
141:
142: -- End of API body.
143:
144: -- Standard check of p_commit.