DBA Data[Home] [Help]

APPS.ZPB_SECURITY_UTIL_PVT dependencies on ZPB_LOG

Line 64: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Validating user ' || p_user_id || '...');

60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: -- API body
63:
64: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Validating user ' || p_user_id || '...');
65:
66: l_user_id := to_char(p_user_id);
67:
68: l_readAcc := ZPB_AW.INTERP('shw sc.has.read.acc(''' || p_user_id || ''')');

Line 75: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'User validation complete.');

71: else
72: x_user_account_state := l_no_read_acc;
73: end if;
74:
75: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'User validation complete.');
76:
77: -- End of API body.
78:
79: -- Standard check of p_commit.

Line 167: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Check for read access assigned to user ' || p_user_id || '...');

163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: -- API body
166:
167: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Check for read access assigned to user ' || p_user_id || '...');
168:
169: select max(has_read_access) into l_read_acc
170: from zpb_account_states
171: where user_id = p_user_id

Line 180: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Read access check complete.');

176: else
177: x_user_read_access := l_no_read_acc;
178: end if;
179:
180: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Read access check complete.');
181:
182: -- End of API body.
183:
184: -- Standard check of p_commit.

Line 281: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Setting read access state for user ' || p_user_id || ' ...');

277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279: -- API body
280:
281: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Setting read access state for user ' || p_user_id || ' ...');
282:
283: l_user_id := to_char(p_user_id);
284:
285: if p_read_access_state = l_has_read_acc

Line 296: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'User access state has been set to ' || l_readAcc || '.');

292: update ZPB_ACCOUNT_STATES
293: set has_read_access = l_readAcc
294: where user_id = p_user_id;
295:
296: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'User access state has been set to ' || l_readAcc || '.');
297:
298: -- End of API body.
299:
300: -- Standard check of p_commit.