eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_SECURITY_UTIL_PVT dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

10:
11: PROCEDURE validate_user(p_user_id IN NUMBER,
12: p_business_area_id IN NUMBER,
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: x_user_account_state OUT NOCOPY varchar2,
18: x_return_status OUT NOCOPY varchar2,

Line 15: p_commit IN VARCHAR2 := FND_API.G_FALSE,

11: PROCEDURE validate_user(p_user_id IN NUMBER,
12: p_business_area_id IN NUMBER,
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: x_user_account_state OUT NOCOPY varchar2,
18: x_return_status OUT NOCOPY varchar2,
19: x_msg_count OUT NOCOPY number,

Line 16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

12: p_business_area_id IN NUMBER,
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: x_user_account_state OUT NOCOPY varchar2,
18: x_return_status OUT NOCOPY varchar2,
19: x_msg_count OUT NOCOPY number,
20: x_msg_data OUT NOCOPY varchar2)

Line 48: IF NOT FND_API.Compatible_API_Call( l_api_version,

44:
45: -- Standard Start of API savepoint
46: SAVEPOINT zpb_excp_pvt_populate_results;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call( l_api_version,
49: p_api_version,
50: l_api_name,
51: G_PKG_NAME)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;

Line 56: IF FND_API.to_Boolean(p_init_msg_list) THEN

52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59: -- Initialize API return status to success
60: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: IF FND_API.to_Boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59: -- Initialize API return status to success
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 || '...');

Line 80: IF FND_API.To_Boolean( p_commit ) THEN

76:
77: -- End of API body.
78:
79: -- Standard check of p_commit.
80: IF FND_API.To_Boolean( p_commit ) THEN
81: COMMIT WORK;
82: END IF;
83: -- Standard call to get message count and if count is 1, get message info.
84: FND_MSG_PUB.Count_And_Get(

Line 88: WHEN FND_API.G_EXC_ERROR THEN

84: FND_MSG_PUB.Count_And_Get(
85: p_count => x_msg_count, p_data => x_msg_data );
86:
87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: ROLLBACK TO zpb_excp_pvt_populate_results;
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: FND_MSG_PUB.Count_And_Get(
92: p_count => x_msg_count,

Line 90: x_return_status := FND_API.G_RET_STS_ERROR;

86:
87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: ROLLBACK TO zpb_excp_pvt_populate_results;
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: FND_MSG_PUB.Count_And_Get(
92: p_count => x_msg_count,
93: p_data => x_msg_data
94: );

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: FND_MSG_PUB.Count_And_Get(
92: p_count => x_msg_count,
93: p_data => x_msg_data
94: );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO zpb_excp_pvt_populate_results;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_And_Get(
99: p_count => x_msg_count,

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: p_data => x_msg_data
94: );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO zpb_excp_pvt_populate_results;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_And_Get(
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: p_data => x_msg_data
101: );
102: WHEN OTHERS THEN
103: ROLLBACK TO zpb_excp_pvt_populate_results;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
106: FND_MSG_PUB.Add_Exc_Msg(
107: G_PKG_NAME,
108: l_api_name

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

118:
119: PROCEDURE has_read_access (p_user_id IN NUMBER,
120: p_business_area_id IN NUMBER,
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: x_user_read_access OUT NOCOPY varchar2,
126: x_return_status OUT NOCOPY varchar2,

Line 123: p_commit IN VARCHAR2 := FND_API.G_FALSE,

119: PROCEDURE has_read_access (p_user_id IN NUMBER,
120: p_business_area_id IN NUMBER,
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: x_user_read_access OUT NOCOPY varchar2,
126: x_return_status OUT NOCOPY varchar2,
127: x_msg_count OUT NOCOPY number,

Line 124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

120: p_business_area_id IN NUMBER,
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: x_user_read_access OUT NOCOPY varchar2,
126: x_return_status OUT NOCOPY varchar2,
127: x_msg_count OUT NOCOPY number,
128: x_msg_data OUT NOCOPY varchar2)

Line 149: IF NOT FND_API.Compatible_API_Call( l_api_version,

145:
146: -- Standard Start of API savepoint
147: SAVEPOINT zpb_excp_pvt_populate_results;
148: -- Standard call to check for call compatibility.
149: IF NOT FND_API.Compatible_API_Call( l_api_version,
150: p_api_version,
151: l_api_name,
152: G_PKG_NAME)
153: THEN

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: p_api_version,
151: l_api_name,
152: G_PKG_NAME)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 158: IF FND_API.to_Boolean(p_init_msg_list) THEN

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF FND_API.to_Boolean(p_init_msg_list) THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: -- Initialize API return status to success

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: -- Initialize API return status to success
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 || '...');

Line 185: IF FND_API.To_Boolean( p_commit ) THEN

181:
182: -- End of API body.
183:
184: -- Standard check of p_commit.
185: IF FND_API.To_Boolean( p_commit ) THEN
186: COMMIT WORK;
187: END IF;
188: -- Standard call to get message count and if count is 1, get message info.
189: FND_MSG_PUB.Count_And_Get(

Line 193: WHEN FND_API.G_EXC_ERROR THEN

189: FND_MSG_PUB.Count_And_Get(
190: p_count => x_msg_count, p_data => x_msg_data );
191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: ROLLBACK TO zpb_excp_pvt_populate_results;
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.Count_And_Get(
197: p_count => x_msg_count,

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: ROLLBACK TO zpb_excp_pvt_populate_results;
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MSG_PUB.Count_And_Get(
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );

Line 200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

196: FND_MSG_PUB.Count_And_Get(
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO zpb_excp_pvt_populate_results;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get(
204: p_count => x_msg_count,

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: p_data => x_msg_data
199: );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO zpb_excp_pvt_populate_results;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get(
204: p_count => x_msg_count,
205: p_data => x_msg_data
206: );

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205: p_data => x_msg_data
206: );
207: WHEN OTHERS THEN
208: ROLLBACK TO zpb_excp_pvt_populate_results;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
211: FND_MSG_PUB.Add_Exc_Msg(
212: G_PKG_NAME,
213: l_api_name

Line 231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

227: PROCEDURE set_user_access_state
228: (p_user_id IN NUMBER,
229: p_read_access_state IN varchar2,
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: x_read_access_state OUT NOCOPY varchar2,
235: x_return_status OUT NOCOPY varchar2,

Line 232: p_commit IN VARCHAR2 := FND_API.G_FALSE,

228: (p_user_id IN NUMBER,
229: p_read_access_state IN varchar2,
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: x_read_access_state OUT NOCOPY varchar2,
235: x_return_status OUT NOCOPY varchar2,
236: x_msg_count OUT NOCOPY number,

Line 233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

229: p_read_access_state IN varchar2,
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_commit IN VARCHAR2 := FND_API.G_FALSE,
233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234: x_read_access_state OUT NOCOPY varchar2,
235: x_return_status OUT NOCOPY varchar2,
236: x_msg_count OUT NOCOPY number,
237: x_msg_data OUT NOCOPY varchar2)

Line 265: IF NOT FND_API.Compatible_API_Call( l_api_version,

261:
262: -- Standard Start of API savepoint
263: SAVEPOINT zpb_excp_pvt_populate_results;
264: -- Standard call to check for call compatibility.
265: IF NOT FND_API.Compatible_API_Call( l_api_version,
266: p_api_version,
267: l_api_name,
268: G_PKG_NAME)
269: THEN

Line 270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

266: p_api_version,
267: l_api_name,
268: G_PKG_NAME)
269: THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: -- Initialize message list if p_init_msg_list is set to TRUE.
273: IF FND_API.to_Boolean(p_init_msg_list) THEN
274: FND_MSG_PUB.initialize;

Line 273: IF FND_API.to_Boolean(p_init_msg_list) THEN

269: THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: -- Initialize message list if p_init_msg_list is set to TRUE.
273: IF FND_API.to_Boolean(p_init_msg_list) THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276: -- Initialize API return status to success
277: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 277: x_return_status := FND_API.G_RET_STS_SUCCESS;

273: IF FND_API.to_Boolean(p_init_msg_list) THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276: -- Initialize API return status to success
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 || ' ...');

Line 301: IF FND_API.To_Boolean( p_commit ) THEN

297:
298: -- End of API body.
299:
300: -- Standard check of p_commit.
301: IF FND_API.To_Boolean( p_commit ) THEN
302: COMMIT WORK;
303: END IF;
304: -- Standard call to get message count and if count is 1, get message info.
305: FND_MSG_PUB.Count_And_Get(

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305: FND_MSG_PUB.Count_And_Get(
306: p_count => x_msg_count, p_data => x_msg_data );
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: ROLLBACK TO zpb_excp_pvt_populate_results;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_count => x_msg_count,

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: ROLLBACK TO zpb_excp_pvt_populate_results;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_count => x_msg_count,
314: p_data => x_msg_data
315: );

Line 316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

312: FND_MSG_PUB.Count_And_Get(
313: p_count => x_msg_count,
314: p_data => x_msg_data
315: );
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: ROLLBACK TO zpb_excp_pvt_populate_results;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_count => x_msg_count,

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

314: p_data => x_msg_data
315: );
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: ROLLBACK TO zpb_excp_pvt_populate_results;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_count => x_msg_count,
321: p_data => x_msg_data
322: );

Line 325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

321: p_data => x_msg_data
322: );
323: WHEN OTHERS THEN
324: ROLLBACK TO zpb_excp_pvt_populate_results;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
327: FND_MSG_PUB.Add_Exc_Msg(
328: G_PKG_NAME,
329: l_api_name