61: X_LEVEL_NAME =>'USER',
62: X_LEVEL_VALUE => p_user_id);
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;
62: X_LEVEL_VALUE => p_user_id);
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:
73: X_LEVEL_NAME =>'USER',
74: X_LEVEL_VALUE => p_user_id);
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;
74: X_LEVEL_VALUE => p_user_id);
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:
85: X_LEVEL_NAME =>'USER',
86: X_LEVEL_VALUE => p_user_id);
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;
86: X_LEVEL_VALUE => p_user_id);
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:
97: X_LEVEL_NAME =>'USER',
98: X_LEVEL_VALUE => p_user_id);
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;
98: X_LEVEL_VALUE => p_user_id);
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:
235: X_LEVEL_NAME =>'USER',
236: X_LEVEL_VALUE => p_user_id);
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;
236: X_LEVEL_VALUE => p_user_id);
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;
252: X_LEVEL_NAME =>'USER',
253: X_LEVEL_VALUE => p_user_id);
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;
253: X_LEVEL_VALUE => p_user_id);
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;
269: X_LEVEL_NAME =>'USER',
270: X_LEVEL_VALUE => p_user_id);
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;
270: X_LEVEL_VALUE => p_user_id);
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;
286: X_LEVEL_NAME =>'USER',
287: X_LEVEL_VALUE => p_user_id);
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;
287: X_LEVEL_VALUE => p_user_id);
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;
420: X_LEVEL_NAME =>'USER',
421: X_LEVEL_VALUE => p_user_id);
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;
421: X_LEVEL_VALUE => p_user_id);
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:
432: X_LEVEL_NAME =>'USER',
433: X_LEVEL_VALUE => p_user_id);
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;
433: X_LEVEL_VALUE => p_user_id);
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:
444: X_LEVEL_NAME =>'USER',
445: X_LEVEL_VALUE => p_user_id);
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;
445: X_LEVEL_VALUE => p_user_id);
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:
456: X_LEVEL_NAME =>'USER',
457: X_LEVEL_VALUE => p_user_id);
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;
457: X_LEVEL_VALUE => p_user_id);
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:
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:
495: fnd_msg_pub.Add;
496:
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:
495: fnd_msg_pub.Add;
496:
497: FND_MSG_PUB.Count_And_Get