eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 507: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 758: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1197: FND_MSG_PUB.initialize;

1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: -- Initialize message list if p_init_msg_list is set to TRUE.
1196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1197: FND_MSG_PUB.initialize;
1198: END IF;
1199:
1200: -- Initialize API return status to success
1201: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1766: COMMIT WORK;
1767: END IF;
1768:
1769: -- Standard call to get message count and if count is 1, get message info.
1770: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1771:
1772: /*IF (l_debug = 'Y') THEN
1773: okc_debug.log('200: Leaving sync_doc_with_expert', 2);
1774: END IF;*/

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

1834: END IF;
1835:
1836: ROLLBACK TO g_sync_doc_with_expert_GRP;
1837: x_return_status := G_RET_STS_ERROR ;
1838: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1839:
1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1841: /*IF (l_debug = 'Y') THEN
1842: okc_debug.log('400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1892: END IF;
1893:
1894: ROLLBACK TO g_sync_doc_with_expert_GRP;
1895: x_return_status := G_RET_STS_UNEXP_ERROR ;
1896: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1897:
1898: WHEN OTHERS THEN
1899: /*IF (l_debug = 'Y') THEN
1900: okc_debug.log('500: Leaving sync_doc_with_expert because of EXCEPTION: '||sqlerrm, 2);

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

1959: ROLLBACK TO g_sync_doc_with_expert_GRP;
1960:
1961: x_return_status := G_RET_STS_UNEXP_ERROR ;
1962:
1963: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1965: END IF;
1966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1967:

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

1960:
1961: x_return_status := G_RET_STS_UNEXP_ERROR ;
1962:
1963: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1965: END IF;
1966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1967:
1968: END sync_doc_with_expert;

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

1962:
1963: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1965: END IF;
1966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1967:
1968: END sync_doc_with_expert;
1969:
1970: PROCEDURE refresh_articles(

Line 2044: FND_MSG_PUB.initialize;

2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: END IF;
2042: -- Initialize message list if p_init_msg_list is set to TRUE.
2043: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2044: FND_MSG_PUB.initialize;
2045: END IF;
2046:
2047: -- Initialize API return status to success
2048: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2106: COMMIT WORK;
2107: END IF;
2108:
2109: -- Standard call to get message count and if count is 1, get message info.
2110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2111:
2112: /*IF (l_debug = 'Y') THEN
2113: okc_debug.log('200: Leaving refresh_articles', 2);
2114: END IF;*/

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

2134: END IF;
2135:
2136: ROLLBACK TO g_refresh_articles_GRP;
2137: x_return_status := G_RET_STS_ERROR ;
2138: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2139:
2140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2141: /*IF (l_debug = 'Y') THEN
2142: okc_debug.log('400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

2152: END IF;
2153:
2154: ROLLBACK TO g_refresh_articles_GRP;
2155: x_return_status := G_RET_STS_UNEXP_ERROR ;
2156: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2157:
2158: WHEN OTHERS THEN
2159: /*IF (l_debug = 'Y') THEN
2160: okc_debug.log('500: Leaving refresh_articles because of EXCEPTION: '||sqlerrm, 2);

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

2180: ROLLBACK TO g_refresh_articles_GRP;
2181:
2182: x_return_status := G_RET_STS_UNEXP_ERROR ;
2183:
2184: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2186: END IF;
2187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2188:

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

2181:
2182: x_return_status := G_RET_STS_UNEXP_ERROR ;
2183:
2184: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2186: END IF;
2187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2188:
2189: END refresh_articles;

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

2183:
2184: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2186: END IF;
2187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2188:
2189: END refresh_articles;
2190:
2191: PROCEDURE organize_layout(

Line 2330: FND_MSG_PUB.initialize;

2326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2327: END IF;
2328: -- Initialize message list if p_init_msg_list is set to TRUE.
2329: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2330: FND_MSG_PUB.initialize;
2331: END IF;
2332:
2333: -- Initialize API return status to success
2334: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2710: COMMIT WORK;
2711: END IF;
2712:
2713: -- Standard call to get message count and if count is 1, get message info.
2714: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2715:
2716: /*IF (l_debug = 'Y') THEN
2717: okc_debug.log('1000: Leaving organize_layout', 2);
2718: END IF;*/

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

2754: ROLLBACK TO g_organize_layout_GRP;
2755: END IF;
2756: ROLLBACK TO g_organize_layout_GRP;
2757: x_return_status := G_RET_STS_ERROR ;
2758: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2759:
2760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2761: /*IF (l_debug = 'Y') THEN
2762: okc_debug.log('1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

2788: ROLLBACK TO g_organize_layout_GRP;
2789: END IF;
2790:
2791: x_return_status := G_RET_STS_UNEXP_ERROR ;
2792: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2793:
2794: WHEN OTHERS THEN
2795: /*IF (l_debug = 'Y') THEN
2796: okc_debug.log('1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm, 2);

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

2831: ROLLBACK TO g_organize_layout_GRP;
2832:
2833: x_return_status := G_RET_STS_UNEXP_ERROR ;
2834:
2835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2836: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2837: END IF;
2838: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2839: END organize_layout;

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

2832:
2833: x_return_status := G_RET_STS_UNEXP_ERROR ;
2834:
2835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2836: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2837: END IF;
2838: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2839: END organize_layout;
2840:

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

2834:
2835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2836: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2837: END IF;
2838: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2839: END organize_layout;
2840:
2841:
2842:

Line 2941: FND_MSG_PUB.initialize;

2937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2938: END IF;
2939: -- Initialize message list if p_init_msg_list is set to TRUE.
2940: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2941: FND_MSG_PUB.initialize;
2942: END IF;
2943:
2944: -- Initialize API return status to success
2945: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3191: COMMIT WORK;
3192: END IF;
3193:
3194: -- Standard call to get message count and if count is 1, get message info.
3195: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3196:
3197:
3198: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3199: FND_LOG.STRING(G_PROC_LEVEL,

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

3215:
3216:
3217: ROLLBACK TO g_merge_review_clauses_GRP;
3218: x_return_status := G_RET_STS_ERROR ;
3219: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3220:
3221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3222:
3223: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN

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

3232:
3233: ROLLBACK TO g_merge_review_clauses_GRP;
3234:
3235: x_return_status := G_RET_STS_UNEXP_ERROR ;
3236: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3237:
3238: WHEN OTHERS THEN
3239: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3240: FND_LOG.STRING(G_EXCP_LEVEL,

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

3255: ROLLBACK TO g_merge_review_clauses_GRP;
3256:
3257: x_return_status := G_RET_STS_UNEXP_ERROR ;
3258:
3259: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3261: END IF;
3262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3263: END merge_review_clauses;

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

3256:
3257: x_return_status := G_RET_STS_UNEXP_ERROR ;
3258:
3259: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3261: END IF;
3262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3263: END merge_review_clauses;
3264:

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

3258:
3259: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3260: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3261: END IF;
3262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3263: END merge_review_clauses;
3264:
3265:
3266: PROCEDURE sort_clauses(

Line 3330: FND_MSG_PUB.initialize;

3326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3327: END IF;
3328: -- Initialize message list if p_init_msg_list is set to TRUE.
3329: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3330: FND_MSG_PUB.initialize;
3331: END IF;
3332:
3333: -- Initialize API return status to success
3334: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3467: ROLLBACK TO g_sort_clauses_GRP;
3468:
3469: x_return_status := G_RET_STS_UNEXP_ERROR ;
3470:
3471: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3473: END IF;
3474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3475:

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

3468:
3469: x_return_status := G_RET_STS_UNEXP_ERROR ;
3470:
3471: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3473: END IF;
3474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3475:
3476: END sort_clauses;

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

3470:
3471: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3473: END IF;
3474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3475:
3476: END sort_clauses;
3477:
3478: