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.ICX_USER_SEC_ATTR_PVT dependencies on FND_API

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

2: -- $Header: ICXVTUSB.pls 120.4 2005/10/26 14:08:59 tshort noship $
3:
4: PROCEDURE Create_User_Sec_Attr
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,

Line 7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

3:
4: PROCEDURE Create_User_Sec_Attr
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,

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

4: PROCEDURE Create_User_Sec_Attr
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
12: p_msg_data OUT NOCOPY VARCHAR2,

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

5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
12: p_msg_data OUT NOCOPY VARCHAR2,
13: -- p_msg_entity OUT VARCHAR2,

Line 40: if NOT FND_API.Compatible_API_Call

36: SAVEPOINT Create_User_Sec_Attr_PVT;
37:
38: -- Standard call to check for call compatibility.
39:
40: if NOT FND_API.Compatible_API_Call
41: (
42: l_api_version_number,
43: p_api_version_number,
44: l_api_name,

Line 48: raise FND_API.G_EXC_UNEXPECTED_ERROR;

44: l_api_name,
45: G_PKG_NAME
46: )
47: then
48: raise FND_API.G_EXC_UNEXPECTED_ERROR;
49: end if;
50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52:

Line 53: if FND_API.to_Boolean( p_init_msg_list)

49: end if;
50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52:
53: if FND_API.to_Boolean( p_init_msg_list)
54: then
55: FND_MSG_PUB.initialize;
56: end if;
57:

Line 60: p_return_status := FND_API.G_RET_STS_SUCCESS;

56: end if;
57:
58: -- Initialize API return status to success
59:
60: p_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: -- ************************************
63: -- VALIDATION - RESP_SEC_ATTR
64: -- ************************************

Line 88: raise FND_API.G_EXC_ERROR;

84: -- !!!!Need create message through Rami
85:
86: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
87: fnd_msg_pub.Add;
88: raise FND_API.G_EXC_ERROR;
89: else
90: INSERT into AK_WEB_USER_SEC_ATTR_VALUES
91: (
92: WEB_USER_ID ,

Line 128: raise FND_API.G_EXC_ERROR;

124:
125: fnd_message.set_name('FND','SQL-NO INSERT');
126: fnd_message.set_token('TABLE','FND_USER');
127: fnd_msg_pub.Add;
128: raise FND_API.G_EXC_ERROR;
129: end if;
130: */
131: end if;
132:

Line 135: if FND_API.To_Boolean( p_commit)

131: end if;
132:
133: -- Standard check of p_commit;
134:
135: if FND_API.To_Boolean( p_commit)
136: then
137: commit work;
138: end if;
139:

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: );
147:
148: EXCEPTION
149:
150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: Rollback to Create_User_Sec_Attr_PVT;
153: p_return_status := FND_API.G_RET_STS_ERROR;
154:

Line 153: p_return_status := FND_API.G_RET_STS_ERROR;

149:
150: WHEN FND_API.G_EXC_ERROR THEN
151:
152: Rollback to Create_User_Sec_Attr_PVT;
153: p_return_status := FND_API.G_RET_STS_ERROR;
154:
155: FND_MSG_PUB.Count_And_Get
156: (
157: p_count => p_msg_count,

Line 161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

157: p_count => p_msg_count,
158: p_data => p_msg_data
159: );
160:
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162:
163: Rollback to Create_User_Sec_Attr_PVT;
164: p_return_status := FND_API.G_RET_STS_ERROR;
165:

Line 164: p_return_status := FND_API.G_RET_STS_ERROR;

160:
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162:
163: Rollback to Create_User_Sec_Attr_PVT;
164: p_return_status := FND_API.G_RET_STS_ERROR;
165:
166: FND_MSG_PUB.Count_And_Get
167: (
168: p_count => p_msg_count,

Line 175: p_return_status := FND_API.G_RET_STS_ERROR;

171:
172: WHEN OTHERS THEN
173:
174: Rollback to Create_User_Sec_Attr_PVT;
175: p_return_status := FND_API.G_RET_STS_ERROR;
176:
177: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: then
179: FND_MSG_PUB.Add_Exc_Msg

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

195:
196:
197: PROCEDURE Delete_User_Sec_Attr
198: ( p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_return_status OUT NOCOPY VARCHAR2,

Line 200: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

196:
197: PROCEDURE Delete_User_Sec_Attr
198: ( p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_return_status OUT NOCOPY VARCHAR2,
204: p_msg_count OUT NOCOPY NUMBER,

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

197: PROCEDURE Delete_User_Sec_Attr
198: ( p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_return_status OUT NOCOPY VARCHAR2,
204: p_msg_count OUT NOCOPY NUMBER,
205: p_msg_data OUT NOCOPY VARCHAR2,

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

198: ( p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: p_return_status OUT NOCOPY VARCHAR2,
204: p_msg_count OUT NOCOPY NUMBER,
205: p_msg_data OUT NOCOPY VARCHAR2,
206: -- p_msg_entity OUT VARCHAR2,

Line 228: if NOT FND_API.Compatible_API_Call

224: SAVEPOINT Delete_User_Sec_Attr_PVT;
225:
226: -- Standard call to check for call compatibility.
227:
228: if NOT FND_API.Compatible_API_Call
229: (
230: l_api_version_number,
231: p_api_version_number,
232: l_api_name,

Line 236: raise FND_API.G_EXC_UNEXPECTED_ERROR;

232: l_api_name,
233: G_PKG_NAME
234: )
235: then
236: raise FND_API.G_EXC_UNEXPECTED_ERROR;
237: end if;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE.
240:

Line 241: if FND_API.to_Boolean( p_init_msg_list)

237: end if;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE.
240:
241: if FND_API.to_Boolean( p_init_msg_list)
242: then
243: FND_MSG_PUB.initialize;
244: end if;
245:

Line 248: p_return_status := FND_API.G_RET_STS_SUCCESS;

244: end if;
245:
246: -- Initialize API return status to success
247:
248: p_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: Delete from AK_WEB_USER_SEC_ATTR_VALUES
251: where web_user_id = p_web_user_id
252: and attribute_code = p_attribute_code

Line 270: raise FND_API.G_EXC_ERROR;

266:
267: fnd_message.set_name('FND','SQL-NO DELETE');
268: fnd_message.set_token('TABLE','FND_USER_RESPONSIBILITY');
269: fnd_msg_pub.Add;
270: raise FND_API.G_EXC_ERROR;
271: end if;
272:
273: -- Standard check of p_commit;
274:

Line 275: if FND_API.To_Boolean( p_commit)

271: end if;
272:
273: -- Standard check of p_commit;
274:
275: if FND_API.To_Boolean( p_commit)
276: then
277: commit work;
278: end if;
279:

Line 290: WHEN FND_API.G_EXC_ERROR THEN

286: );
287:
288: EXCEPTION
289:
290: WHEN FND_API.G_EXC_ERROR THEN
291:
292: Rollback to Delete_User_Sec_Attr_PVT;
293: p_return_status := FND_API.G_RET_STS_ERROR;
294:

Line 293: p_return_status := FND_API.G_RET_STS_ERROR;

289:
290: WHEN FND_API.G_EXC_ERROR THEN
291:
292: Rollback to Delete_User_Sec_Attr_PVT;
293: p_return_status := FND_API.G_RET_STS_ERROR;
294:
295: FND_MSG_PUB.Count_And_Get
296: (
297: p_count => p_msg_count,

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: p_count => p_msg_count,
298: p_data => p_msg_data
299: );
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302:
303: Rollback to Delete_User_Sec_Attr_PVT;
304: p_return_status := FND_API.G_RET_STS_ERROR;
305:

Line 304: p_return_status := FND_API.G_RET_STS_ERROR;

300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302:
303: Rollback to Delete_User_Sec_Attr_PVT;
304: p_return_status := FND_API.G_RET_STS_ERROR;
305:
306: FND_MSG_PUB.Count_And_Get
307: (
308: p_count => p_msg_count,

Line 315: p_return_status := FND_API.G_RET_STS_ERROR;

311:
312: WHEN OTHERS THEN
313:
314: Rollback to Delete_User_Sec_Attr_PVT;
315: p_return_status := FND_API.G_RET_STS_ERROR;
316:
317: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: then
319: FND_MSG_PUB.Add_Exc_Msg

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

333: end Delete_User_Sec_Attr;
334:
335: PROCEDURE Create_Def_User_Sec_Attr
336: ( p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: p_web_user_id IN NUMBER,

Line 338: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

334:
335: PROCEDURE Create_Def_User_Sec_Attr
336: ( p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: p_web_user_id IN NUMBER,
342: p_resp_application_id IN NUMBER,

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

335: PROCEDURE Create_Def_User_Sec_Attr
336: ( p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: p_web_user_id IN NUMBER,
342: p_resp_application_id IN NUMBER,
343: p_responsibility_id IN NUMBER,

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

336: ( p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: p_web_user_id IN NUMBER,
342: p_resp_application_id IN NUMBER,
343: p_responsibility_id IN NUMBER,
344: p_created_by IN NUMBER,

Line 415: if NOT FND_API.Compatible_API_Call

411: SAVEPOINT Create_Def_User_Sec_Attr;
412:
413: -- Standard call to check for call compatibility.
414:
415: if NOT FND_API.Compatible_API_Call
416: (
417: l_api_version_number,
418: p_api_version_number,
419: l_api_name,

Line 423: raise FND_API.G_EXC_UNEXPECTED_ERROR;

419: l_api_name,
420: G_PKG_NAME
421: )
422: then
423: raise FND_API.G_EXC_UNEXPECTED_ERROR;
424: end if;
425:
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427:

Line 428: if FND_API.to_Boolean( p_init_msg_list)

424: end if;
425:
426: -- Initialize message list if p_init_msg_list is set to TRUE.
427:
428: if FND_API.to_Boolean( p_init_msg_list)
429: then
430: FND_MSG_PUB.initialize;
431: end if;
432:

Line 435: p_return_status := FND_API.G_RET_STS_SUCCESS;

431: end if;
432:
433: -- Initialize API return status to success
434:
435: p_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437: -- ************************************
438: -- VALIDATION - RESP_SEC_ATTR
439: -- ************************************

Line 636: raise FND_API.G_EXC_ERROR;

632: -- !!!!Need create message through Rami
633:
634: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
635: fnd_msg_pub.Add;
636: raise FND_API.G_EXC_ERROR;
637: else
638: end if;
639: */
640:

Line 643: if FND_API.To_Boolean( p_commit)

639: */
640:
641: -- Standard check of p_commit;
642:
643: if FND_API.To_Boolean( p_commit)
644: then
645: commit work;
646: end if;
647:

Line 658: WHEN FND_API.G_EXC_ERROR THEN

654: );
655:
656: EXCEPTION
657:
658: WHEN FND_API.G_EXC_ERROR THEN
659:
660: Rollback to Create_Def_User_Sec_Attr;
661: p_return_status := FND_API.G_RET_STS_ERROR;
662:

Line 661: p_return_status := FND_API.G_RET_STS_ERROR;

657:
658: WHEN FND_API.G_EXC_ERROR THEN
659:
660: Rollback to Create_Def_User_Sec_Attr;
661: p_return_status := FND_API.G_RET_STS_ERROR;
662:
663: FND_MSG_PUB.Count_And_Get
664: (
665: p_count => p_msg_count,

Line 669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

665: p_count => p_msg_count,
666: p_data => p_msg_data
667: );
668:
669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670:
671: Rollback to Create_Def_User_Sec_Attr;
672: p_return_status := FND_API.G_RET_STS_ERROR;
673:

Line 672: p_return_status := FND_API.G_RET_STS_ERROR;

668:
669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670:
671: Rollback to Create_Def_User_Sec_Attr;
672: p_return_status := FND_API.G_RET_STS_ERROR;
673:
674: FND_MSG_PUB.Count_And_Get
675: (
676: p_count => p_msg_count,

Line 683: p_return_status := FND_API.G_RET_STS_ERROR;

679:
680: WHEN OTHERS THEN
681:
682: Rollback to Create_Def_User_Sec_Attr;
683: p_return_status := FND_API.G_RET_STS_ERROR;
684:
685: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: then
687: FND_MSG_PUB.Add_Exc_Msg