DBA Data[Home] [Help]

APPS.AP_NOTES_PUB dependencies on FND_MSG_PUB

Line 123: FND_MSG_PUB.initialize;

119: END IF;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE.
122: IF FND_API.to_Boolean( p_init_msg_list ) THEN
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: -- Initialize API return status to success
127: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

188: COMMIT WORK;
189: END IF;
190:
191: -- Standard call to get message count and if count is 1, get message info.
192: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
193: p_data => x_msg_data);
194:
195: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
196: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);

Line 206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

202: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
203: end if;
204: ROLLBACK TO Create_Note_PUB;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
207: p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

211: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
212: end if;
213: ROLLBACK TO Create_Note_PUB;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

220: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
221: end if;
222: ROLLBACK TO Create_Note_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
225: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
226: END IF;
227: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
228: p_data => x_msg_data);

Line 225: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

221: end if;
222: ROLLBACK TO Create_Note_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
225: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
226: END IF;
227: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
228: p_data => x_msg_data);
229:

Line 227: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
225: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
226: END IF;
227: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
228: p_data => x_msg_data);
229:
230: END Create_Note;
231:

Line 303: FND_MSG_PUB.initialize;

299: END IF;
300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.to_Boolean( p_init_msg_list ) THEN
303: FND_MSG_PUB.initialize;
304: END IF;
305:
306: -- Initialize API return status to success
307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

349: COMMIT WORK;
350: END IF;
351:
352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
354: p_data => x_msg_data);
355:
356: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
357: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);

Line 367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

363: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
364: end if;
365: ROLLBACK TO Delete_Notes;
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
368: p_data => x_msg_data);
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

372: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
373: end if;
374: ROLLBACK TO Delete_Notes;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
376: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
377: p_data => x_msg_data);
378:
379: WHEN OTHERS THEN
380: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

381: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
382: end if;
383: ROLLBACK TO Delete_Notes;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
387: END IF;
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
389: p_data => x_msg_data);

Line 386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

382: end if;
383: ROLLBACK TO Delete_Notes;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
387: END IF;
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
389: p_data => x_msg_data);
390:

Line 388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
386: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
387: END IF;
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
389: p_data => x_msg_data);
390:
391: END Delete_Notes;
392:

Line 468: FND_MSG_PUB.initialize;

464: END IF;
465:
466: -- Initialize message list if p_init_msg_list is set to TRUE.
467: IF FND_API.to_Boolean( p_init_msg_list ) THEN
468: FND_MSG_PUB.initialize;
469: END IF;
470:
471: -- Initialize API return status to success
472: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 496: FND_MSG_PUB.Add;

492: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
493: fnd_log.string(fnd_log.level_statement,G_MODULE_PREFIX||l_api_name,'old and new source objects are same!');
494: end if;
495: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_COPY_ON_ITSELF_ERR');
496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 548: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

544: COMMIT WORK;
545: END IF;
546:
547: -- Standard call to get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
552: fnd_log.string(fnd_log.level_procedure,G_MODULE_PREFIX||l_api_name,G_EXIT);

Line 562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

558: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_ERROR');
559: end if;
560: ROLLBACK TO Copy_Notes;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
563: p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

567: fnd_log.string(fnd_log.level_unexpected,G_MODULE_PREFIX||l_api_name,'error - FND_API.G_EXC_UNEXPECTED_ERROR');
568: end if;
569: ROLLBACK TO Copy_Notes;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: WHEN OTHERS THEN
575: if ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

576: fnd_log.string(fnd_log.level_exception,G_MODULE_PREFIX||l_api_name,'error - OTHERS:sqlerrm'||sqlerrm);
577: end if;
578: ROLLBACK TO Copy_Notes;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
582: END IF;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data);

Line 581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

577: end if;
578: ROLLBACK TO Copy_Notes;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
582: END IF;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data);
585:

Line 583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
582: END IF;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data);
585:
586: END Copy_Notes;
587: