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_PUB dependencies on FND_API

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

2: -- $Header: ICXPTUSB.pls 115.1 99/07/17 03:21:23 porting ship $
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 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 VARCHAR2,
11: p_msg_count OUT 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 VARCHAR2,
11: p_msg_count OUT NUMBER,
12: p_msg_data OUT 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 VARCHAR2,
11: p_msg_count OUT NUMBER,
12: p_msg_data OUT VARCHAR2,
13: -- p_msg_entity OUT VARCHAR2,

Line 43: if NOT FND_API.Compatible_API_Call

39: SAVEPOINT Create_User_Sec_Attr_PUB;
40:
41: -- Standard call to check for call compatibility.
42:
43: if NOT FND_API.Compatible_API_Call
44: (
45: l_api_version_number,
46: p_api_version_number,
47: l_api_name,

Line 51: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 56: if FND_API.to_Boolean( p_init_msg_list)

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

Line 63: p_return_status := FND_API.G_RET_STS_SUCCESS;

59: end if;
60:
61: -- Initialize API return status to success
62:
63: p_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: -- ***************************
66: -- VALIDATION
67:

Line 101: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

97:
98: -- Both G_EXC_ERROR and G_EXC_UNEXPECTED_ERROR are handled in
99: -- the API exception handler.
100:
101: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
102: then
103:
104: -- Unexpected error, abort processing.
105:

Line 106: raise FND_API.G_EXC_UNEXPECTED_ERROR;

102: then
103:
104: -- Unexpected error, abort processing.
105:
106: raise FND_API.G_EXC_UNEXPECTED_ERROR;
107:
108: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
109:
110: -- Error, abort processing

Line 108: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN

104: -- Unexpected error, abort processing.
105:
106: raise FND_API.G_EXC_UNEXPECTED_ERROR;
107:
108: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
109:
110: -- Error, abort processing
111:
112: raise FND_API.G_EXC_ERROR;

Line 112: raise FND_API.G_EXC_ERROR;

108: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
109:
110: -- Error, abort processing
111:
112: raise FND_API.G_EXC_ERROR;
113:
114: end if;
115:
116: -- Standard check of p_simulate and p_commit parameters

Line 118: if FND_API.To_Boolean( p_simulate)

114: end if;
115:
116: -- Standard check of p_simulate and p_commit parameters
117:
118: if FND_API.To_Boolean( p_simulate)
119: then
120: ROLLBACK to Create_User_Sec_Attr_PUB;
121:
122: elsif FND_API.To_Boolean( p_commit)

Line 122: elsif FND_API.To_Boolean( p_commit)

118: if FND_API.To_Boolean( p_simulate)
119: then
120: ROLLBACK to Create_User_Sec_Attr_PUB;
121:
122: elsif FND_API.To_Boolean( p_commit)
123: then
124: commit work;
125: end if;
126:

Line 137: WHEN FND_API.G_EXC_ERROR THEN

133: );
134:
135: EXCEPTION
136:
137: WHEN FND_API.G_EXC_ERROR THEN
138:
139: Rollback to Create_User_Sec_Attr_PUB;
140: p_return_status := FND_API.G_RET_STS_ERROR;
141:

Line 140: p_return_status := FND_API.G_RET_STS_ERROR;

136:
137: WHEN FND_API.G_EXC_ERROR THEN
138:
139: Rollback to Create_User_Sec_Attr_PUB;
140: p_return_status := FND_API.G_RET_STS_ERROR;
141:
142: FND_MSG_PUB.Count_And_Get
143: (
144: p_count => p_msg_count,

Line 148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

144: p_count => p_msg_count,
145: p_data => p_msg_data
146: );
147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149:
150: Rollback to Create_User_Sec_Attr_PUB;
151: p_return_status := FND_API.G_RET_STS_ERROR;
152:

Line 151: p_return_status := FND_API.G_RET_STS_ERROR;

147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149:
150: Rollback to Create_User_Sec_Attr_PUB;
151: p_return_status := FND_API.G_RET_STS_ERROR;
152:
153: FND_MSG_PUB.Count_And_Get
154: (
155: p_count => p_msg_count,

Line 162: p_return_status := FND_API.G_RET_STS_ERROR;

158:
159: WHEN OTHERS THEN
160:
161: Rollback to Create_User_Sec_Attr_PUB;
162: p_return_status := FND_API.G_RET_STS_ERROR;
163:
164: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: then
166: FND_MSG_PUB.Add_Exc_Msg

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

183:
184:
185: PROCEDURE Delete_User_Sec_Attr
186: ( p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT VARCHAR2,

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

184:
185: PROCEDURE Delete_User_Sec_Attr
186: ( p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT VARCHAR2,
192: p_msg_count OUT NUMBER,

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

185: PROCEDURE Delete_User_Sec_Attr
186: ( p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT VARCHAR2,
192: p_msg_count OUT NUMBER,
193: p_msg_data OUT VARCHAR2,

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

186: ( p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT VARCHAR2,
192: p_msg_count OUT NUMBER,
193: p_msg_data OUT VARCHAR2,
194: -- p_msg_entity OUT VARCHAR2,

Line 217: if NOT FND_API.Compatible_API_Call

213: SAVEPOINT Delete_User_Sec_Attr_PUB;
214:
215: -- Standard call to check for call compatibility.
216:
217: if NOT FND_API.Compatible_API_Call
218: (
219: l_api_version_number,
220: p_api_version_number,
221: l_api_name,

Line 225: raise FND_API.G_EXC_UNEXPECTED_ERROR;

221: l_api_name,
222: G_PKG_NAME
223: )
224: then
225: raise FND_API.G_EXC_UNEXPECTED_ERROR;
226: end if;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE.
229:

Line 230: if FND_API.to_Boolean( p_init_msg_list)

226: end if;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE.
229:
230: if FND_API.to_Boolean( p_init_msg_list)
231: then
232: FND_MSG_PUB.initialize;
233: end if;
234:

Line 237: p_return_status := FND_API.G_RET_STS_SUCCESS;

233: end if;
234:
235: -- Initialize API return status to success
236:
237: p_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: ICX_User_Sec_Attr_PVT.Delete_User_Sec_Attr
240: (
241: p_api_version_number => p_api_version_number ,

Line 262: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

258:
259: -- Both G_EXC_ERROR and G_EXC_UNEXPECTED_ERROR are handled in
260: -- the API exception handler.
261:
262: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
263: then
264:
265: -- Unexpected error, abort processing.
266:

Line 267: raise FND_API.G_EXC_UNEXPECTED_ERROR;

263: then
264:
265: -- Unexpected error, abort processing.
266:
267: raise FND_API.G_EXC_UNEXPECTED_ERROR;
268:
269: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
270:
271: -- Error, abort processing

Line 269: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN

265: -- Unexpected error, abort processing.
266:
267: raise FND_API.G_EXC_UNEXPECTED_ERROR;
268:
269: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
270:
271: -- Error, abort processing
272:
273: raise FND_API.G_EXC_ERROR;

Line 273: raise FND_API.G_EXC_ERROR;

269: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
270:
271: -- Error, abort processing
272:
273: raise FND_API.G_EXC_ERROR;
274:
275: end if;
276:
277: -- Standard check of p_simulate and p_commit parameters

Line 279: if FND_API.To_Boolean( p_simulate)

275: end if;
276:
277: -- Standard check of p_simulate and p_commit parameters
278:
279: if FND_API.To_Boolean( p_simulate)
280: then
281: ROLLBACK to Delete_User_Sec_Attr_PUB;
282:
283: elsif FND_API.To_Boolean( p_commit)

Line 283: elsif FND_API.To_Boolean( p_commit)

279: if FND_API.To_Boolean( p_simulate)
280: then
281: ROLLBACK to Delete_User_Sec_Attr_PUB;
282:
283: elsif FND_API.To_Boolean( p_commit)
284: then
285: commit work;
286: end if;
287:

Line 298: WHEN FND_API.G_EXC_ERROR THEN

294: );
295:
296: EXCEPTION
297:
298: WHEN FND_API.G_EXC_ERROR THEN
299:
300: Rollback to Delete_User_Sec_Attr_PUB;
301: p_return_status := FND_API.G_RET_STS_ERROR;
302:

Line 301: p_return_status := FND_API.G_RET_STS_ERROR;

297:
298: WHEN FND_API.G_EXC_ERROR THEN
299:
300: Rollback to Delete_User_Sec_Attr_PUB;
301: p_return_status := FND_API.G_RET_STS_ERROR;
302:
303: FND_MSG_PUB.Count_And_Get
304: (
305: p_count => p_msg_count,

Line 309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

305: p_count => p_msg_count,
306: p_data => p_msg_data
307: );
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310:
311: Rollback to Delete_User_Sec_Attr_PUB;
312: p_return_status := FND_API.G_RET_STS_ERROR;
313:

Line 312: p_return_status := FND_API.G_RET_STS_ERROR;

308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310:
311: Rollback to Delete_User_Sec_Attr_PUB;
312: p_return_status := FND_API.G_RET_STS_ERROR;
313:
314: FND_MSG_PUB.Count_And_Get
315: (
316: p_count => p_msg_count,

Line 323: p_return_status := FND_API.G_RET_STS_ERROR;

319:
320: WHEN OTHERS THEN
321:
322: Rollback to Delete_User_Sec_Attr_PUB;
323: p_return_status := FND_API.G_RET_STS_ERROR;
324:
325: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: then
327: FND_MSG_PUB.Add_Exc_Msg