DBA Data[Home] [Help]

APPS.OKS_RENEW_UTIL_PUB dependencies on FND_MSG_PUB

Line 33: FND_MSG_PUB.initialize;

29: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: IF FND_API.to_boolean(p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37:

Line 60: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

56:
57: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
58: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_return_status='|| x_return_status);
59: END IF;
60: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
61:
62: EXCEPTION
63: WHEN FND_API.g_exc_error THEN
64: x_return_status := FND_API.g_ret_sts_error ;

Line 69: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

65:
66: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
67: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
68: END IF;
69: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73:

Line 77: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

73:
74: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
76: END IF;
77: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
78:
79: WHEN OTHERS THEN
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
81:

Line 87: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

83: --first log the sqlerrm
84: l_error_text := substr (SQLERRM, 1, 240);
85: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
86: --then add it to the message api list
87: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
88: END IF;
89: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
90:
91: END GET_RENEW_RULES;

Line 89: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

85: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
86: --then add it to the message api list
87: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
88: END IF;
89: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
90:
91: END GET_RENEW_RULES;
92:
93: --===========================================================================

Line 488: FND_MSG_PUB.initialize;

484: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: IF FND_API.to_boolean(p_init_msg_list ) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: OKS_RENEW_UTIL_PVT.get_template_set(

Line 511: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

507:
508: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
509: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_return_status='|| x_return_status);
510: END IF;
511: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
512:
513: EXCEPTION
514: WHEN FND_API.g_exc_error THEN
515: x_return_status := FND_API.g_ret_sts_error ;

Line 520: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

516:
517: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
518: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
519: END IF;
520: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524:

Line 528: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

524:
525: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
526: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
527: END IF;
528: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
529:
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532:

Line 538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

534: --first log the sqlerrm
535: l_error_text := substr (SQLERRM, 1, 240);
536: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
537: --then add it to the message api list
538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
539: END IF;
540: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
541:
542: END get_template_set;

Line 540: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

536: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
537: --then add it to the message api list
538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
539: END IF;
540: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
541:
542: END get_template_set;
543:
544:

Line 608: FND_MSG_PUB.initialize;

604: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: IF FND_API.to_boolean(p_init_msg_list ) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:
612: OKS_RENEW_UTIL_PVT.get_renewal_type(

Line 635: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

631:
632: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
633: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_return_status='|| x_return_status);
634: END IF;
635: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
636:
637: EXCEPTION
638: WHEN FND_API.g_exc_error THEN
639: x_return_status := FND_API.g_ret_sts_error ;

Line 644: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

640:
641: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
642: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
643: END IF;
644: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
648:

Line 652: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

648:
649: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
650: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
651: END IF;
652: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
653:
654: WHEN OTHERS THEN
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
656:

Line 662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

658: --first log the sqlerrm
659: l_error_text := substr (SQLERRM, 1, 240);
660: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
661: --then add it to the message api list
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
663: END IF;
664: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
665:
666: END GET_RENEWAL_TYPE;

Line 664: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

660: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
661: --then add it to the message api list
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
663: END IF;
664: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
665:
666: END GET_RENEWAL_TYPE;
667:
668: END OKS_RENEW_UTIL_PUB;