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

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

2: -- $Header: ICXVUPFB.pls 120.1 2005/10/07 14:29:07 gjimenez noship $
3:
4: PROCEDURE Create_Profile
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_Profile
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_Profile
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_user_id IN NUMBER,

Line 37: if NOT FND_API.Compatible_API_Call

33: SAVEPOINT Create_Profile_PVT;
34:
35: -- Standard call to check for call compatibility.
36:
37: if NOT FND_API.Compatible_API_Call
38: (
39: l_api_version_number,
40: p_api_version_number,
41: l_api_name,

Line 45: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 50: if FND_API.to_Boolean( p_init_msg_list)

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

Line 57: p_return_status := FND_API.G_RET_STS_SUCCESS;

53: end if;
54:
55: -- Initialize API return status to success
56:
57: p_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_DAYS_NEEDED_BY',
60: X_VALUE => p_days_needed_by,
61: X_LEVEL_NAME =>'USER',

Line 68: raise FND_API.G_EXC_ERROR;

64: if l_return_stat = FALSE then
65: fnd_message.set_name('FND','SQL-NO INSERT');
66: fnd_message.set_token('TABLE','FND_USER');
67: fnd_msg_pub.Add;
68: raise FND_API.G_EXC_ERROR;
69: end if;
70:
71: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_DEFAULT_TEMPLATE',
72: X_VALUE => p_req_default_template,

Line 80: raise FND_API.G_EXC_ERROR;

76: if l_return_stat = FALSE then
77: fnd_message.set_name('FND','SQL-NO INSERT');
78: fnd_message.set_token('TABLE','FND_USER');
79: fnd_msg_pub.Add;
80: raise FND_API.G_EXC_ERROR;
81: end if;
82:
83: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
84: X_VALUE => p_req_override_req_code,

Line 92: raise FND_API.G_EXC_ERROR;

88: if l_return_stat = FALSE then
89: fnd_message.set_name('FND','SQL-NO INSERT');
90: fnd_message.set_token('TABLE','FND_USER');
91: fnd_msg_pub.Add;
92: raise FND_API.G_EXC_ERROR;
93: end if;
94:
95: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_LOCATION_FLAG',
96: X_VALUE => p_req_override_loc_flag,

Line 104: raise FND_API.G_EXC_ERROR;

100: if l_return_stat = FALSE then
101: fnd_message.set_name('FND','SQL-NO INSERT');
102: fnd_message.set_token('TABLE','FND_USER');
103: fnd_msg_pub.Add;
104: raise FND_API.G_EXC_ERROR;
105: end if;
106:
107: -- Standard check of p_simulate and p_commit parameters
108:

Line 109: if FND_API.To_Boolean( p_simulate)

105: end if;
106:
107: -- Standard check of p_simulate and p_commit parameters
108:
109: if FND_API.To_Boolean( p_simulate)
110: then
111: ROLLBACK to Create_Profile_PVT;
112:
113: elsif FND_API.To_Boolean( p_commit)

Line 113: elsif FND_API.To_Boolean( p_commit)

109: if FND_API.To_Boolean( p_simulate)
110: then
111: ROLLBACK to Create_Profile_PVT;
112:
113: elsif FND_API.To_Boolean( p_commit)
114: then
115: commit work;
116: end if;
117:

Line 128: WHEN FND_API.G_EXC_ERROR THEN

124: );
125:
126: EXCEPTION
127:
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: Rollback to Create_Profile_PVT;
131: p_return_status := FND_API.G_RET_STS_ERROR;
132:

Line 131: p_return_status := FND_API.G_RET_STS_ERROR;

127:
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: Rollback to Create_Profile_PVT;
131: p_return_status := FND_API.G_RET_STS_ERROR;
132:
133: FND_MSG_PUB.Count_And_Get
134: (
135: p_count => p_msg_count,

Line 139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

135: p_count => p_msg_count,
136: p_data => p_msg_data
137: );
138:
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140:
141: Rollback to Create_Profile_PVT;
142: p_return_status := FND_API.G_RET_STS_ERROR;
143:

Line 142: p_return_status := FND_API.G_RET_STS_ERROR;

138:
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140:
141: Rollback to Create_Profile_PVT;
142: p_return_status := FND_API.G_RET_STS_ERROR;
143:
144: FND_MSG_PUB.Count_And_Get
145: (
146: p_count => p_msg_count,

Line 153: p_return_status := FND_API.G_RET_STS_ERROR;

149:
150: WHEN OTHERS THEN
151:
152: Rollback to Create_Profile_PVT;
153: p_return_status := FND_API.G_RET_STS_ERROR;
154:
155: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: then
157: FND_MSG_PUB.Add_Exc_Msg

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

172:
173:
174: PROCEDURE Update_Profile
175: ( p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_return_status OUT NOCOPY VARCHAR2,

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

173:
174: PROCEDURE Update_Profile
175: ( p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,

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

174: PROCEDURE Update_Profile
175: ( p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,
182: p_msg_data OUT NOCOPY VARCHAR2,

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

175: ( p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: p_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,
182: p_msg_data OUT NOCOPY VARCHAR2,
183: p_user_id IN NUMBER,

Line 184: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,

180: p_return_status OUT NOCOPY VARCHAR2,
181: p_msg_count OUT NOCOPY NUMBER,
182: p_msg_data OUT NOCOPY VARCHAR2,
183: p_user_id IN NUMBER,
184: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
185: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_last_updated_by IN NUMBER,

Line 185: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,

181: p_msg_count OUT NOCOPY NUMBER,
182: p_msg_data OUT NOCOPY VARCHAR2,
183: p_user_id IN NUMBER,
184: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
185: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_last_updated_by IN NUMBER,
189: p_last_update_date IN DATE,

Line 186: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

182: p_msg_data OUT NOCOPY VARCHAR2,
183: p_user_id IN NUMBER,
184: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
185: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_last_updated_by IN NUMBER,
189: p_last_update_date IN DATE,
190: p_last_update_login IN NUMBER

Line 187: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

183: p_user_id IN NUMBER,
184: p_days_needed_by IN NUMBER := FND_API.G_MISS_NUM,
185: p_req_default_template IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_req_override_loc_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_req_override_req_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_last_updated_by IN NUMBER,
189: p_last_update_date IN DATE,
190: p_last_update_login IN NUMBER
191: )

Line 206: if NOT FND_API.Compatible_API_Call

202: SAVEPOINT Update_Profile_PVT;
203:
204: -- Standard call to check for call compatibility.
205:
206: if NOT FND_API.Compatible_API_Call
207: (
208: l_api_version_number,
209: p_api_version_number,
210: l_api_name,

Line 214: raise FND_API.G_EXC_UNEXPECTED_ERROR;

210: l_api_name,
211: G_PKG_NAME
212: )
213: then
214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
215: end if;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218:

Line 219: if FND_API.to_Boolean( p_init_msg_list)

215: end if;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218:
219: if FND_API.to_Boolean( p_init_msg_list)
220: then
221: FND_MSG_PUB.initialize;
222: end if;
223:

Line 226: p_return_status := FND_API.G_RET_STS_SUCCESS;

222: end if;
223:
224: -- Initialize API return status to success
225:
226: p_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: -- ************
229: -- DAYS_NEEDED_BY
230: -- ************

Line 231: if p_days_needed_by <> FND_API.G_MISS_NUM

227:
228: -- ************
229: -- DAYS_NEEDED_BY
230: -- ************
231: if p_days_needed_by <> FND_API.G_MISS_NUM
232: then
233: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_DAYS_NEEDED_BY',
234: X_VALUE => p_days_needed_by,
235: X_LEVEL_NAME =>'USER',

Line 242: raise FND_API.G_EXC_ERROR;

238: if l_return_stat = FALSE then
239: fnd_message.set_name('FND','SQL-NO INSERT');
240: fnd_message.set_token('TABLE','FND_USER');
241: fnd_msg_pub.Add;
242: raise FND_API.G_EXC_ERROR;
243: end if;
244: end if;
245: -- ************
246: -- REQ_DEFAULT_TEMPLATE

Line 248: if p_req_default_template <> FND_API.G_MISS_CHAR

244: end if;
245: -- ************
246: -- REQ_DEFAULT_TEMPLATE
247: -- ************
248: if p_req_default_template <> FND_API.G_MISS_CHAR
249: then
250: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_DEFAULT_TEMPLATE',
251: X_VALUE => p_req_default_template,
252: X_LEVEL_NAME =>'USER',

Line 259: raise FND_API.G_EXC_ERROR;

255: if l_return_stat = FALSE then
256: fnd_message.set_name('FND','SQL-NO INSERT');
257: fnd_message.set_token('TABLE','FND_USER');
258: fnd_msg_pub.Add;
259: raise FND_API.G_EXC_ERROR;
260: end if;
261: end if;
262: -- ************
263: -- REQ_OVERRIDE_LOC_FLAG

Line 265: if p_req_override_loc_flag <> FND_API.G_MISS_CHAR

261: end if;
262: -- ************
263: -- REQ_OVERRIDE_LOC_FLAG
264: -- ************
265: if p_req_override_loc_flag <> FND_API.G_MISS_CHAR
266: then
267: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_LOCATION_FLAG',
268: X_VALUE => p_req_override_loc_flag,
269: X_LEVEL_NAME =>'USER',

Line 276: raise FND_API.G_EXC_ERROR;

272: if l_return_stat = FALSE then
273: fnd_message.set_name('FND','SQL-NO INSERT');
274: fnd_message.set_token('TABLE','FND_USER');
275: fnd_msg_pub.Add;
276: raise FND_API.G_EXC_ERROR;
277: end if;
278: end if;
279: -- ************
280: -- REQ_OVERRIDE_REQ_CODE

Line 282: if p_req_override_req_code <> FND_API.G_MISS_CHAR

278: end if;
279: -- ************
280: -- REQ_OVERRIDE_REQ_CODE
281: -- ************
282: if p_req_override_req_code <> FND_API.G_MISS_CHAR
283: then
284: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
285: X_VALUE => p_req_override_req_code,
286: X_LEVEL_NAME =>'USER',

Line 293: raise FND_API.G_EXC_ERROR;

289: if l_return_stat = FALSE then
290: fnd_message.set_name('FND','SQL-NO INSERT');
291: fnd_message.set_token('TABLE','FND_USER');
292: fnd_msg_pub.Add;
293: raise FND_API.G_EXC_ERROR;
294: end if;
295: end if;
296:
297: -- Standard check of p_simulate and p_commit parameters

Line 299: if FND_API.To_Boolean( p_simulate)

295: end if;
296:
297: -- Standard check of p_simulate and p_commit parameters
298:
299: if FND_API.To_Boolean( p_simulate)
300: then
301: ROLLBACK to Update_Profile_PVT;
302:
303: elsif FND_API.To_Boolean( p_commit)

Line 303: elsif FND_API.To_Boolean( p_commit)

299: if FND_API.To_Boolean( p_simulate)
300: then
301: ROLLBACK to Update_Profile_PVT;
302:
303: elsif FND_API.To_Boolean( p_commit)
304: then
305: commit work;
306: end if;
307:

Line 318: WHEN FND_API.G_EXC_ERROR THEN

314: );
315:
316: EXCEPTION
317:
318: WHEN FND_API.G_EXC_ERROR THEN
319:
320: Rollback to Update_Profile_PVT;
321: p_return_status := FND_API.G_RET_STS_ERROR;
322:

Line 321: p_return_status := FND_API.G_RET_STS_ERROR;

317:
318: WHEN FND_API.G_EXC_ERROR THEN
319:
320: Rollback to Update_Profile_PVT;
321: p_return_status := FND_API.G_RET_STS_ERROR;
322:
323: FND_MSG_PUB.Count_And_Get
324: (
325: p_count => p_msg_count,

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

325: p_count => p_msg_count,
326: p_data => p_msg_data
327: );
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: Rollback to Update_Profile_PVT;
332: p_return_status := FND_API.G_RET_STS_ERROR;
333:

Line 332: p_return_status := FND_API.G_RET_STS_ERROR;

328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: Rollback to Update_Profile_PVT;
332: p_return_status := FND_API.G_RET_STS_ERROR;
333:
334: FND_MSG_PUB.Count_And_Get
335: (
336: p_count => p_msg_count,

Line 343: p_return_status := FND_API.G_RET_STS_ERROR;

339:
340: WHEN OTHERS THEN
341:
342: Rollback to Update_Profile_PVT;
343: p_return_status := FND_API.G_RET_STS_ERROR;
344:
345: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
346: then
347: FND_MSG_PUB.Add_Exc_Msg

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

363:
364:
365: PROCEDURE Delete_Profile
366: ( p_api_version_number IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371: p_return_status OUT nocopy VARCHAR2,

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

364:
365: PROCEDURE Delete_Profile
366: ( p_api_version_number IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371: p_return_status OUT nocopy VARCHAR2,
372: p_msg_count OUT nocopy NUMBER,

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

365: PROCEDURE Delete_Profile
366: ( p_api_version_number IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371: p_return_status OUT nocopy VARCHAR2,
372: p_msg_count OUT nocopy NUMBER,
373: p_msg_data OUT nocopy VARCHAR2,

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

366: ( p_api_version_number IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371: p_return_status OUT nocopy VARCHAR2,
372: p_msg_count OUT nocopy NUMBER,
373: p_msg_data OUT nocopy VARCHAR2,
374: p_user_id IN NUMBER

Line 395: if NOT FND_API.Compatible_API_Call

391: SAVEPOINT Delete_Profile_PVT;
392:
393: -- Standard call to check for call compatibility.
394:
395: if NOT FND_API.Compatible_API_Call
396: (
397: l_api_version_number,
398: p_api_version_number,
399: l_api_name,

Line 403: raise FND_API.G_EXC_UNEXPECTED_ERROR;

399: l_api_name,
400: G_PKG_NAME
401: )
402: then
403: raise FND_API.G_EXC_UNEXPECTED_ERROR;
404: end if;
405:
406: -- Initialize message list if p_init_msg_list is set to TRUE.
407:

Line 408: if FND_API.to_Boolean( p_init_msg_list)

404: end if;
405:
406: -- Initialize message list if p_init_msg_list is set to TRUE.
407:
408: if FND_API.to_Boolean( p_init_msg_list)
409: then
410: FND_MSG_PUB.initialize;
411: end if;
412:

Line 415: p_return_status := FND_API.G_RET_STS_SUCCESS;

411: end if;
412:
413: -- Initialize API return status to success
414:
415: p_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417:
418: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_DAYS_NEEDED_BY',
419: X_VALUE => '',

Line 427: raise FND_API.G_EXC_ERROR;

423: if l_return_stat = FALSE then
424: fnd_message.set_name('FND','SQL-NO INSERT');
425: fnd_message.set_token('TABLE','FND_USER');
426: fnd_msg_pub.Add;
427: raise FND_API.G_EXC_ERROR;
428: end if;
429:
430: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_DEFAULT_TEMPLATE',
431: X_VALUE => '',

Line 439: raise FND_API.G_EXC_ERROR;

435: if l_return_stat = FALSE then
436: fnd_message.set_name('FND','SQL-NO INSERT');
437: fnd_message.set_token('TABLE','FND_USER');
438: fnd_msg_pub.Add;
439: raise FND_API.G_EXC_ERROR;
440: end if;
441:
442: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_REQUESTOR_CODE',
443: X_VALUE => '',

Line 451: raise FND_API.G_EXC_ERROR;

447: if l_return_stat = FALSE then
448: fnd_message.set_name('FND','SQL-NO INSERT');
449: fnd_message.set_token('TABLE','FND_USER');
450: fnd_msg_pub.Add;
451: raise FND_API.G_EXC_ERROR;
452: end if;
453:
454: l_return_stat := FND_PROFILE.SAVE(X_NAME =>'ICX_REQ_OVERRIDE_LOCATION_FLAG',
455: X_VALUE => '',

Line 463: raise FND_API.G_EXC_ERROR;

459: if l_return_stat = FALSE then
460: fnd_message.set_name('FND','SQL-NO INSERT');
461: fnd_message.set_token('TABLE','FND_USER');
462: fnd_msg_pub.Add;
463: raise FND_API.G_EXC_ERROR;
464: end if;
465:
466: -- Standard check of p_simulate and p_commit parameters
467:

Line 468: if FND_API.To_Boolean( p_simulate)

464: end if;
465:
466: -- Standard check of p_simulate and p_commit parameters
467:
468: if FND_API.To_Boolean( p_simulate)
469: then
470: ROLLBACK to Delete_Profile_PVT;
471:
472: elsif FND_API.To_Boolean( p_commit)

Line 472: elsif FND_API.To_Boolean( p_commit)

468: if FND_API.To_Boolean( p_simulate)
469: then
470: ROLLBACK to Delete_Profile_PVT;
471:
472: elsif FND_API.To_Boolean( p_commit)
473: then
474: commit work;
475: end if;
476:

Line 490: p_return_status := FND_API.G_RET_STS_ERROR;

486:
487: WHEN NO_DATA_FOUND or e_cannot_delete THEN
488:
489: Rollback to Delete_Profile_PVT;
490: p_return_status := FND_API.G_RET_STS_ERROR;
491:
492: fnd_message.set_name('FND','SQL-NO DELETE');
493: fnd_message.set_token('TABLE', 'ICX_USER_PROFILES');
494:

Line 503: WHEN FND_API.G_EXC_ERROR THEN

499: p_count => p_msg_count,
500: p_data => p_msg_data
501: );
502:
503: WHEN FND_API.G_EXC_ERROR THEN
504:
505: Rollback to Delete_Profile_PVT;
506: p_return_status := FND_API.G_RET_STS_ERROR;
507:

Line 506: p_return_status := FND_API.G_RET_STS_ERROR;

502:
503: WHEN FND_API.G_EXC_ERROR THEN
504:
505: Rollback to Delete_Profile_PVT;
506: p_return_status := FND_API.G_RET_STS_ERROR;
507:
508: FND_MSG_PUB.Count_And_Get
509: (
510: p_count => p_msg_count,

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: p_count => p_msg_count,
511: p_data => p_msg_data
512: );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515:
516: Rollback to Delete_Profile_PVT;
517: p_return_status := FND_API.G_RET_STS_ERROR;
518:

Line 517: p_return_status := FND_API.G_RET_STS_ERROR;

513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515:
516: Rollback to Delete_Profile_PVT;
517: p_return_status := FND_API.G_RET_STS_ERROR;
518:
519: FND_MSG_PUB.Count_And_Get
520: (
521: p_count => p_msg_count,

Line 528: p_return_status := FND_API.G_RET_STS_ERROR;

524:
525: WHEN OTHERS THEN
526:
527: Rollback to Delete_Profile_PVT;
528: p_return_status := FND_API.G_RET_STS_ERROR;
529:
530: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: then
532: FND_MSG_PUB.Add_Exc_Msg