DBA Data[Home] [Help]

APPS.OKC_TERMS_MULTIREC_GRP dependencies on FND_MSG_PUB

Line 150: FND_MSG_PUB.initialize;

146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: -- Initialize message list if p_init_msg_list is set to TRUE.
149: IF FND_API.to_Boolean( p_init_msg_list ) THEN
150: FND_MSG_PUB.initialize;
151: END IF;
152:
153: IF p_kart_tbl.COUNT >0
154: AND FND_API.To_Boolean( p_validate_commit ) THEN

Line 349: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

345: COMMIT WORK;
346: END IF;
347:
348: -- Standard call to get message count and if count is 1, get message info.
349: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
350:
351: /*IF (l_debug = 'Y') THEN
352: okc_debug.log('200: Leaving create_article', 2);
353: END IF;*/

Line 381: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

377: END IF;
378:
379: ROLLBACK TO g_create_article_GRP;
380: x_return_status := G_RET_STS_ERROR ;
381: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: /*IF (l_debug = 'Y') THEN
385: okc_debug.log('400: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 403: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

399: END IF;
400:
401: ROLLBACK TO g_create_article_GRP;
402: x_return_status := G_RET_STS_UNEXP_ERROR ;
403: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
404:
405: WHEN OTHERS THEN
406: /*IF (l_debug = 'Y') THEN
407: okc_debug.log('500: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);

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

421: END IF;
422:
423: ROLLBACK TO g_create_article_GRP;
424: x_return_status := G_RET_STS_UNEXP_ERROR ;
425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
427: END IF;
428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
429:

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

422:
423: ROLLBACK TO g_create_article_GRP;
424: x_return_status := G_RET_STS_UNEXP_ERROR ;
425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
427: END IF;
428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
429:
430: END create_article;

Line 428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

424: x_return_status := G_RET_STS_UNEXP_ERROR ;
425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
427: END IF;
428: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
429:
430: END create_article;
431:
432: PROCEDURE update_article_variable(

Line 506: FND_MSG_PUB.initialize;

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list ) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: IF p_art_var_tbl.FIRST IS NOT NULL
510: AND FND_API.To_Boolean( p_validate_commit ) THEN

Line 616: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

612: COMMIT WORK;
613: END IF;
614:
615: -- Standard call to get message count and if count is 1, get message info.
616: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
617:
618: /*IF (l_debug = 'Y') THEN
619: okc_debug.log('200: Leaving update_article_variable', 2);
620: END IF;*/

Line 644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

640: END IF;
641:
642: ROLLBACK TO g_update_article_variable_GRP;
643: x_return_status := G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: /*IF (l_debug = 'Y') THEN
648: okc_debug.log('400: Leaving update_article_variable: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

658: END IF;
659:
660: ROLLBACK TO g_update_article_variable_GRP;
661: x_return_status := G_RET_STS_UNEXP_ERROR ;
662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
663:
664: WHEN OTHERS THEN
665: /*IF (l_debug = 'Y') THEN
666: okc_debug.log('500: Leaving update_article_variable because of EXCEPTION: '||sqlerrm, 2);

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

676: END IF;
677:
678: ROLLBACK TO g_update_article_variable_GRP;
679: x_return_status := G_RET_STS_UNEXP_ERROR ;
680: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
682: END IF;
683: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
684:

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

677:
678: ROLLBACK TO g_update_article_variable_GRP;
679: x_return_status := G_RET_STS_UNEXP_ERROR ;
680: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
682: END IF;
683: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
684:
685: END update_article_variable;

Line 683: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

679: x_return_status := G_RET_STS_UNEXP_ERROR ;
680: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
682: END IF;
683: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
684:
685: END update_article_variable;
686:
687: PROCEDURE update_structure(

Line 756: FND_MSG_PUB.initialize;

752: END IF;
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_Boolean( p_init_msg_list ) THEN
756: FND_MSG_PUB.initialize;
757: END IF;
758:
759: -- Initialize API return status to success
760: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 863: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

859: COMMIT WORK;
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
864:
865: /*IF (l_debug = 'Y') THEN
866: okc_debug.log('200: Leaving update_structure', 2);
867: END IF;*/

Line 895: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

891: END IF;
892:
893: ROLLBACK TO g_update_structure_GRP;
894: x_return_status := G_RET_STS_ERROR ;
895: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: /*IF (l_debug = 'Y') THEN
899: okc_debug.log('400: Leaving update_structure: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

913: END IF;
914:
915: ROLLBACK TO g_update_structure_GRP;
916: x_return_status := G_RET_STS_UNEXP_ERROR ;
917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
918:
919: WHEN OTHERS THEN
920: /*IF (l_debug = 'Y') THEN
921: okc_debug.log('500: Leaving update_structure because of EXCEPTION: '||sqlerrm, 2);

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

935: END IF;
936:
937: ROLLBACK TO g_update_structure_GRP;
938: x_return_status := G_RET_STS_UNEXP_ERROR ;
939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
941: END IF;
942: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
943:

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

936:
937: ROLLBACK TO g_update_structure_GRP;
938: x_return_status := G_RET_STS_UNEXP_ERROR ;
939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
941: END IF;
942: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
943:
944: END update_structure;

Line 942: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

938: x_return_status := G_RET_STS_UNEXP_ERROR ;
939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
941: END IF;
942: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
943:
944: END update_structure;
945:
946: PROCEDURE sync_doc_with_expert(

Line 1174: FND_MSG_PUB.initialize;

1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171: END IF;
1172: -- Initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1174: FND_MSG_PUB.initialize;
1175: END IF;
1176:
1177: -- Initialize API return status to success
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1655: COMMIT WORK;
1656: END IF;
1657:
1658: -- Standard call to get message count and if count is 1, get message info.
1659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1660:
1661: /*IF (l_debug = 'Y') THEN
1662: okc_debug.log('200: Leaving sync_doc_with_expert', 2);
1663: END IF;*/

Line 1727: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1723: END IF;
1724:
1725: ROLLBACK TO g_sync_doc_with_expert_GRP;
1726: x_return_status := G_RET_STS_ERROR ;
1727: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: /*IF (l_debug = 'Y') THEN
1731: okc_debug.log('400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 1785: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1781: END IF;
1782:
1783: ROLLBACK TO g_sync_doc_with_expert_GRP;
1784: x_return_status := G_RET_STS_UNEXP_ERROR ;
1785: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1786:
1787: WHEN OTHERS THEN
1788: /*IF (l_debug = 'Y') THEN
1789: okc_debug.log('500: Leaving sync_doc_with_expert because of EXCEPTION: '||sqlerrm, 2);

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

1848: ROLLBACK TO g_sync_doc_with_expert_GRP;
1849:
1850: x_return_status := G_RET_STS_UNEXP_ERROR ;
1851:
1852: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1854: END IF;
1855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1856:

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

1849:
1850: x_return_status := G_RET_STS_UNEXP_ERROR ;
1851:
1852: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1854: END IF;
1855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1856:
1857: END sync_doc_with_expert;

Line 1855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1851:
1852: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1854: END IF;
1855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1856:
1857: END sync_doc_with_expert;
1858:
1859: PROCEDURE refresh_articles(

Line 1932: FND_MSG_PUB.initialize;

1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: END IF;
1930: -- Initialize message list if p_init_msg_list is set to TRUE.
1931: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1932: FND_MSG_PUB.initialize;
1933: END IF;
1934:
1935: -- Initialize API return status to success
1936: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1997: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1993: COMMIT WORK;
1994: END IF;
1995:
1996: -- Standard call to get message count and if count is 1, get message info.
1997: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1998:
1999: /*IF (l_debug = 'Y') THEN
2000: okc_debug.log('200: Leaving refresh_articles', 2);
2001: END IF;*/

Line 2025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2021: END IF;
2022:
2023: ROLLBACK TO g_refresh_articles_GRP;
2024: x_return_status := G_RET_STS_ERROR ;
2025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2026:
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: /*IF (l_debug = 'Y') THEN
2029: okc_debug.log('400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 2043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2039: END IF;
2040:
2041: ROLLBACK TO g_refresh_articles_GRP;
2042: x_return_status := G_RET_STS_UNEXP_ERROR ;
2043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2044:
2045: WHEN OTHERS THEN
2046: /*IF (l_debug = 'Y') THEN
2047: okc_debug.log('500: Leaving refresh_articles because of EXCEPTION: '||sqlerrm, 2);

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

2067: ROLLBACK TO g_refresh_articles_GRP;
2068:
2069: x_return_status := G_RET_STS_UNEXP_ERROR ;
2070:
2071: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2073: END IF;
2074: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2075:

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

2068:
2069: x_return_status := G_RET_STS_UNEXP_ERROR ;
2070:
2071: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2073: END IF;
2074: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2075:
2076: END refresh_articles;

Line 2074: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2070:
2071: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2073: END IF;
2074: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2075:
2076: END refresh_articles;
2077:
2078: PROCEDURE organize_layout(

Line 2217: FND_MSG_PUB.initialize;

2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: -- Initialize message list if p_init_msg_list is set to TRUE.
2216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2217: FND_MSG_PUB.initialize;
2218: END IF;
2219:
2220: -- Initialize API return status to success
2221: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2597: COMMIT WORK;
2598: END IF;
2599:
2600: -- Standard call to get message count and if count is 1, get message info.
2601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2602:
2603: /*IF (l_debug = 'Y') THEN
2604: okc_debug.log('1000: Leaving organize_layout', 2);
2605: END IF;*/

Line 2645: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2641: ROLLBACK TO g_organize_layout_GRP;
2642: END IF;
2643: ROLLBACK TO g_organize_layout_GRP;
2644: x_return_status := G_RET_STS_ERROR ;
2645: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2646:
2647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2648: /*IF (l_debug = 'Y') THEN
2649: okc_debug.log('1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 2679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2675: ROLLBACK TO g_organize_layout_GRP;
2676: END IF;
2677:
2678: x_return_status := G_RET_STS_UNEXP_ERROR ;
2679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2680:
2681: WHEN OTHERS THEN
2682: /*IF (l_debug = 'Y') THEN
2683: okc_debug.log('1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm, 2);

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

2718: ROLLBACK TO g_organize_layout_GRP;
2719:
2720: x_return_status := G_RET_STS_UNEXP_ERROR ;
2721:
2722: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2724: END IF;
2725: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2726: END organize_layout;

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

2719:
2720: x_return_status := G_RET_STS_UNEXP_ERROR ;
2721:
2722: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2724: END IF;
2725: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2726: END organize_layout;
2727:

Line 2725: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2721:
2722: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2724: END IF;
2725: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2726: END organize_layout;
2727:
2728:
2729:

Line 2828: FND_MSG_PUB.initialize;

2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: END IF;
2826: -- Initialize message list if p_init_msg_list is set to TRUE.
2827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:
2831: -- Initialize API return status to success
2832: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3082: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3078: COMMIT WORK;
3079: END IF;
3080:
3081: -- Standard call to get message count and if count is 1, get message info.
3082: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3083:
3084:
3085: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3086: FND_LOG.STRING(G_PROC_LEVEL,

Line 3106: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3102:
3103:
3104: ROLLBACK TO g_merge_review_clauses_GRP;
3105: x_return_status := G_RET_STS_ERROR ;
3106: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3107:
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109:
3110: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN

Line 3123: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3119:
3120: ROLLBACK TO g_merge_review_clauses_GRP;
3121:
3122: x_return_status := G_RET_STS_UNEXP_ERROR ;
3123: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3124:
3125: WHEN OTHERS THEN
3126: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3127: FND_LOG.STRING(G_EXCP_LEVEL,

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

3142: ROLLBACK TO g_merge_review_clauses_GRP;
3143:
3144: x_return_status := G_RET_STS_UNEXP_ERROR ;
3145:
3146: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3148: END IF;
3149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3150: END merge_review_clauses;

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

3143:
3144: x_return_status := G_RET_STS_UNEXP_ERROR ;
3145:
3146: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3148: END IF;
3149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3150: END merge_review_clauses;
3151:

Line 3149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3145:
3146: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3148: END IF;
3149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3150: END merge_review_clauses;
3151:
3152:
3153: END OKC_TERMS_MULTIREC_GRP;