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:
55: -- Initialize API return status to success
56:
63:
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',
75:
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',
87:
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',
99:
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
116: end if;
117:
118: -- Standard call to get message count and if count is 1, get message info.
119:
120: FND_MSG_PUB.Count_And_Get
121: (
122: p_count => p_msg_count,
123: p_data => p_msg_data
124: );
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,
136: p_data => p_msg_data
137: );
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,
147: p_data => p_msg_data
148: );
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
158: (
159: G_FILE_NAME,
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
158: (
159: G_FILE_NAME,
160: G_PKG_NAME,
161: l_api_name
161: l_api_name
162: );
163: end if;
164:
165: FND_MSG_PUB.Count_And_Get
166: (
167: p_count => p_msg_count,
168: p_data => p_msg_data
169: );
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:
224: -- Initialize API return status to success
225:
237:
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: -- ************
254:
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: -- ************
271:
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: -- ************
288:
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:
306: end if;
307:
308: -- Standard call to get message count and if count is 1, get message info.
309:
310: FND_MSG_PUB.Count_And_Get
311: (
312: p_count => p_msg_count,
313: p_data => p_msg_data
314: );
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,
326: p_data => p_msg_data
327: );
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,
337: p_data => p_msg_data
338: );
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
348: (
349: G_FILE_NAME,
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
348: (
349: G_FILE_NAME,
350: G_PKG_NAME,
351: l_api_name
351: l_api_name
352: );
353: end if;
354:
355: FND_MSG_PUB.Count_And_Get
356: (
357: p_count => p_msg_count,
358: p_data => p_msg_data
359: );
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:
413: -- Initialize API return status to success
414:
422:
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',
434:
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',
446:
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',
458:
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
475: end if;
476:
477: -- Standard call to get message count and if count is 1, get message info.
478:
479: FND_MSG_PUB.Count_And_Get
480: (
481: p_count => p_msg_count,
482: p_data => p_msg_data
483: );
491:
492: fnd_message.set_name('FND','SQL-NO DELETE');
493: fnd_message.set_token('TABLE', 'ICX_USER_PROFILES');
494:
495: fnd_msg_pub.Add;
496:
497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => p_msg_count,
493: fnd_message.set_token('TABLE', 'ICX_USER_PROFILES');
494:
495: fnd_msg_pub.Add;
496:
497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => p_msg_count,
500: p_data => p_msg_data
501: );
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,
511: p_data => p_msg_data
512: );
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,
522: p_data => p_msg_data
523: );
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
533: (
534: G_FILE_NAME,
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
533: (
534: G_FILE_NAME,
535: G_PKG_NAME,
536: l_api_name
536: l_api_name
537: );
538: end if;
539:
540: FND_MSG_PUB.Count_And_Get
541: (
542: p_count => p_msg_count,
543: p_data => p_msg_data
544: );