DBA Data[Home] [Help]

APPS.ICX_USER_PROFILE_PVT dependencies on FND_MESSAGE

Line 65: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 66: fnd_message.set_token('TABLE','FND_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;
70:

Line 77: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 78: fnd_message.set_token('TABLE','FND_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;
82:

Line 89: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 90: fnd_message.set_token('TABLE','FND_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;
94:

Line 101: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 102: fnd_message.set_token('TABLE','FND_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;
106:

Line 239: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 240: fnd_message.set_token('TABLE','FND_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;
244: end if;

Line 256: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 257: fnd_message.set_token('TABLE','FND_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;
261: end if;

Line 273: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 274: fnd_message.set_token('TABLE','FND_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;
278: end if;

Line 290: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 291: fnd_message.set_token('TABLE','FND_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;
295: end if;

Line 424: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 425: fnd_message.set_token('TABLE','FND_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;
429:

Line 436: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 437: fnd_message.set_token('TABLE','FND_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;
441:

Line 448: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 449: fnd_message.set_token('TABLE','FND_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;
453:

Line 460: fnd_message.set_name('FND','SQL-NO INSERT');

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;

Line 461: fnd_message.set_token('TABLE','FND_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;
465:

Line 492: fnd_message.set_name('FND','SQL-NO DELETE');

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:

Line 493: fnd_message.set_token('TABLE', 'ICX_USER_PROFILES');

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