DBA Data[Home] [Help]

APPS.FND_UPDATE_USER_PREF_PUB dependencies on FND_MSG_PUB

Line 113: fnd_msg_pub.initialize;

109:
110: /* Initialize message list if p_init_msg_list is set to TRUE */
111:
112: IF fnd_api.to_boolean (p_init_msg_list) THEN
113: fnd_msg_pub.initialize;
114: END IF;
115:
116: /*If party id has not been passed then get the party id from fnd_user */
117: if(p_party_id is null)

Line 178: fnd_msg_pub.add;

174: -- Unexpected Execution Error from call to Get_contracts_resources
175: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
176: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
177: fnd_message.set_token('P_API_NAME', l_api_name);
178: fnd_msg_pub.add;
179: RAISE fnd_api.g_exc_error;
180: END IF; -- end of x_return_status check
181:
182: END IF; -- end of DO check

Line 258: fnd_msg_pub.add;

254: -- Unexpected Execution Error from call to Get_contracts_resources
255: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
256: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
257: fnd_message.set_token('P_API_NAME', l_api_name);
258: fnd_msg_pub.add;
259: RAISE fnd_api.g_exc_error;
260: END IF; -- end of x_return_status check
261:
262: END IF; -- end of DO check

Line 278: FND_MSG_PUB.add;

274: END IF;
275:
276: -- add confirmation message
277: fnd_message.set_name ('FND', 'FND_PII_CONFIRM_SAVE');
278: FND_MSG_PUB.add;
279: FND_MSG_PUB.Count_And_Get
280: (
281: p_count => x_msg_count,
282: p_data => x_msg_data

Line 279: FND_MSG_PUB.Count_And_Get

275:
276: -- add confirmation message
277: fnd_message.set_name ('FND', 'FND_PII_CONFIRM_SAVE');
278: FND_MSG_PUB.add;
279: FND_MSG_PUB.Count_And_Get
280: (
281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );

Line 288: FND_MSG_PUB.Count_And_Get

284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_ERROR ;
288: FND_MSG_PUB.Count_And_Get
289: (
290: p_count => x_msg_count,
291: p_data => x_msg_data
292: );

Line 296: FND_MSG_PUB.Count_And_Get

292: );
293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: (
298: p_count => x_msg_count,
299: p_data => x_msg_data
300: );

Line 307: FND_MSG_PUB.add;

303: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
304: fnd_message.set_token('P_SQLCODE',SQLCODE);
305: fnd_message.set_token('P_SQLERRM',SQLERRM);
306: fnd_message.set_token('P_API_NAME',l_api_name);
307: FND_MSG_PUB.add;
308:
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
311: FND_MSG_PUB.Add_Exc_Msg

Line 310: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

306: fnd_message.set_token('P_API_NAME',l_api_name);
307: FND_MSG_PUB.add;
308:
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
311: FND_MSG_PUB.Add_Exc_Msg
312: (
313: G_PKG_NAME,
314: l_api_name

Line 311: FND_MSG_PUB.Add_Exc_Msg

307: FND_MSG_PUB.add;
308:
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
311: FND_MSG_PUB.Add_Exc_Msg
312: (
313: G_PKG_NAME,
314: l_api_name
315: );

Line 318: FND_MSG_PUB.Count_And_Get

314: l_api_name
315: );
316: END IF;
317:
318: FND_MSG_PUB.Count_And_Get
319: (
320: p_count => x_msg_count,
321: p_data => x_msg_data
322: );

Line 385: fnd_msg_pub.initialize;

381: l_party_id := p_party_id;
382:
383:
384: IF fnd_api.to_boolean (p_init_msg_list) THEN
385: fnd_msg_pub.initialize;
386: END IF;
387:
388: /*If party id has not been passed then get the party id from fnd_user */
389: if(p_party_id is null)

Line 410: FND_MSG_PUB.add;

406:
407: END IF; -- end of p_party_id check
408:
409: fnd_message.set_name ('FND', 'FND_PII_CONFIRM_SAVE');
410: FND_MSG_PUB.add;
411: FND_MSG_PUB.Count_And_Get
412: (
413: p_count => x_msg_count,
414: p_data => x_msg_data

Line 411: FND_MSG_PUB.Count_And_Get

407: END IF; -- end of p_party_id check
408:
409: fnd_message.set_name ('FND', 'FND_PII_CONFIRM_SAVE');
410: FND_MSG_PUB.add;
411: FND_MSG_PUB.Count_And_Get
412: (
413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );

Line 420: FND_MSG_PUB.Count_And_Get

416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_ERROR ;
420: FND_MSG_PUB.Count_And_Get
421: (
422: p_count => x_msg_count,
423: p_data => x_msg_data
424: );

Line 428: FND_MSG_PUB.Count_And_Get

424: );
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: (
430: p_count => x_msg_count,
431: p_data => x_msg_data
432: );

Line 439: FND_MSG_PUB.add;

435: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
436: fnd_message.set_token('P_SQLCODE',SQLCODE);
437: fnd_message.set_token('P_SQLERRM',SQLERRM);
438: fnd_message.set_token('P_API_NAME',l_api_name);
439: FND_MSG_PUB.add;
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
443: FND_MSG_PUB.Add_Exc_Msg

Line 442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

438: fnd_message.set_token('P_API_NAME',l_api_name);
439: FND_MSG_PUB.add;
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
443: FND_MSG_PUB.Add_Exc_Msg
444: (
445: G_PKG_NAME,
446: l_api_name

Line 443: FND_MSG_PUB.Add_Exc_Msg

439: FND_MSG_PUB.add;
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
443: FND_MSG_PUB.Add_Exc_Msg
444: (
445: G_PKG_NAME,
446: l_api_name
447: );

Line 450: FND_MSG_PUB.Count_And_Get

446: l_api_name
447: );
448: END IF;
449:
450: FND_MSG_PUB.Count_And_Get
451: (
452: p_count => x_msg_count,
453: p_data => x_msg_data
454: );

Line 539: fnd_msg_pub.initialize;

535: l_all_flag := 'N';
536:
537:
538: IF fnd_api.to_boolean (p_init_msg_list) THEN
539: fnd_msg_pub.initialize;
540: END IF;
541:
542: IF fnd_api.to_boolean (p_init_msg_list) THEN
543: fnd_msg_pub.initialize;

Line 543: fnd_msg_pub.initialize;

539: fnd_msg_pub.initialize;
540: END IF;
541:
542: IF fnd_api.to_boolean (p_init_msg_list) THEN
543: fnd_msg_pub.initialize;
544: END IF;
545:
546: /*If party id has not been passed then get the party id from fnd_user */
547: if(p_party_id is null)

Line 646: fnd_msg_pub.add;

642: -- Unexpected Execution Error from call to Get_contracts_resources
643: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
644: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
645: fnd_message.set_token('P_API_NAME', l_api_name);
646: fnd_msg_pub.add;
647: RAISE fnd_api.g_exc_error;
648: END IF; -- end of x_return_status check
649: END IF; -- end of check of r_cont_pref record
650:

Line 709: fnd_msg_pub.add;

705: -- Unexpected Execution Error from call to Get_contracts_resources
706: fnd_message.set_name('FND', 'FND_PII_GENERIC_API_ERROR');
707: fnd_message.set_token('P_PROC_NAME','CREATE_CONTACT_PREFERENCE');
708: fnd_message.set_token('P_API_NAME', l_api_name);
709: fnd_msg_pub.add;
710: RAISE fnd_api.g_exc_error;
711: END IF; -- end of x_return_status check
712: END IF; -- end of check of r_cont_pref record
713:

Line 736: FND_MSG_PUB.add;

732:
733: END IF; -- end of l_party_id check
734:
735: fnd_message.set_name ('FND', 'FND_PII_CONFIRM_SAVE');
736: FND_MSG_PUB.add;
737: FND_MSG_PUB.Count_And_Get
738: (
739: p_count => x_msg_count,
740: p_data => x_msg_data

Line 737: FND_MSG_PUB.Count_And_Get

733: END IF; -- end of l_party_id check
734:
735: fnd_message.set_name ('FND', 'FND_PII_CONFIRM_SAVE');
736: FND_MSG_PUB.add;
737: FND_MSG_PUB.Count_And_Get
738: (
739: p_count => x_msg_count,
740: p_data => x_msg_data
741: );

Line 746: FND_MSG_PUB.Count_And_Get

742:
743: EXCEPTION
744: WHEN FND_API.G_EXC_ERROR THEN
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get
747: (
748: p_count => x_msg_count,
749: p_data => x_msg_data
750: );

Line 754: FND_MSG_PUB.Count_And_Get

750: );
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get
755: (
756: p_count => x_msg_count,
757: p_data => x_msg_data
758: );

Line 765: FND_MSG_PUB.add;

761: fnd_message.set_name ('FND', 'FND_PII_UNEXP_ERROR');
762: fnd_message.set_token('P_SQLCODE',SQLCODE);
763: fnd_message.set_token('P_SQLERRM',SQLERRM);
764: fnd_message.set_token('P_API_NAME',l_api_name);
765: FND_MSG_PUB.add;
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
769: FND_MSG_PUB.Add_Exc_Msg

Line 768: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN

764: fnd_message.set_token('P_API_NAME',l_api_name);
765: FND_MSG_PUB.add;
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
769: FND_MSG_PUB.Add_Exc_Msg
770: (
771: G_PKG_NAME,
772: l_api_name

Line 769: FND_MSG_PUB.Add_Exc_Msg

765: FND_MSG_PUB.add;
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
769: FND_MSG_PUB.Add_Exc_Msg
770: (
771: G_PKG_NAME,
772: l_api_name
773: );

Line 776: FND_MSG_PUB.Count_And_Get

772: l_api_name
773: );
774: END IF;
775:
776: FND_MSG_PUB.Count_And_Get
777: (
778: p_count => x_msg_count,
779: p_data => x_msg_data
780: );