DBA Data[Home] [Help]

APPS.ICX_USER_PROFILE_PVT dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.initialize;

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:

Line 67: fnd_msg_pub.Add;

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',

Line 79: fnd_msg_pub.Add;

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',

Line 91: fnd_msg_pub.Add;

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',

Line 103: fnd_msg_pub.Add;

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

Line 120: FND_MSG_PUB.Count_And_Get

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: );

Line 133: FND_MSG_PUB.Count_And_Get

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: );

Line 144: FND_MSG_PUB.Count_And_Get

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: );

Line 155: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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,

Line 157: FND_MSG_PUB.Add_Exc_Msg

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

Line 165: FND_MSG_PUB.Count_And_Get

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: );

Line 221: FND_MSG_PUB.initialize;

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:

Line 241: fnd_msg_pub.Add;

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: -- ************

Line 258: fnd_msg_pub.Add;

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: -- ************

Line 275: fnd_msg_pub.Add;

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: -- ************

Line 292: fnd_msg_pub.Add;

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:

Line 310: FND_MSG_PUB.Count_And_Get

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: );

Line 323: FND_MSG_PUB.Count_And_Get

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: );

Line 334: FND_MSG_PUB.Count_And_Get

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: );

Line 345: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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,

Line 347: FND_MSG_PUB.Add_Exc_Msg

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

Line 355: FND_MSG_PUB.Count_And_Get

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: );

Line 410: FND_MSG_PUB.initialize;

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:

Line 426: fnd_msg_pub.Add;

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',

Line 438: fnd_msg_pub.Add;

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',

Line 450: fnd_msg_pub.Add;

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',

Line 462: fnd_msg_pub.Add;

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

Line 479: FND_MSG_PUB.Count_And_Get

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: );

Line 495: fnd_msg_pub.Add;

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,

Line 497: FND_MSG_PUB.Count_And_Get

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: );

Line 508: FND_MSG_PUB.Count_And_Get

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: );

Line 519: FND_MSG_PUB.Count_And_Get

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: );

Line 530: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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,

Line 532: FND_MSG_PUB.Add_Exc_Msg

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

Line 540: FND_MSG_PUB.Count_And_Get

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: );