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_MIGRATE_GRP dependencies on FND_MSG_PUB

Line 606: FND_MSG_PUB.initialize;

602: END IF;
603:
604: -- Initialize message list if p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list ) THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Initialize API return status to success
610: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1160: COMMIT WORK;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1165:
1166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving create_contract_terms');
1168: END IF;

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

1188: END IF;
1189:
1190: ROLLBACK TO g_create_contract_terms_grp;
1191: x_return_status := G_RET_STS_ERROR ;
1192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1196: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_contract_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1197: END IF;
1198:
1199: ROLLBACK TO g_create_contract_terms_grp;
1200: x_return_status := G_RET_STS_UNEXP_ERROR ;
1201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1202:
1203: WHEN OTHERS THEN
1204: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving create_contract_terms because of EXCEPTION: '||sqlerrm);

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

1206: END IF;
1207:
1208: ROLLBACK TO g_create_contract_terms_grp;
1209: x_return_status := G_RET_STS_UNEXP_ERROR ;
1210: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1212: END IF;
1213: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1214:

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

1207:
1208: ROLLBACK TO g_create_contract_terms_grp;
1209: x_return_status := G_RET_STS_UNEXP_ERROR ;
1210: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1212: END IF;
1213: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1214:
1215: END Create_Contract_Terms;

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

1209: x_return_status := G_RET_STS_UNEXP_ERROR ;
1210: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1212: END IF;
1213: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1214:
1215: END Create_Contract_Terms;
1216:
1217: Procedure Add_Contract_Doc

Line 1326: FND_MSG_PUB.initialize;

1322: END IF;
1323:
1324: -- Initialize message list if p_init_msg_list is set to TRUE.
1325: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1326: FND_MSG_PUB.initialize;
1327: END IF;
1328:
1329: -- Initialize API return status to success
1330: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1628: COMMIT WORK;
1629: END IF;
1630:
1631: -- Standard call to get message count and if count is 1, get message info.
1632: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1633:
1634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_contract_doc');
1636: END IF;

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

1648: END IF;
1649:
1650: ROLLBACK TO g_add_contract_doc_grp;
1651: x_return_status := G_RET_STS_ERROR ;
1652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1653:
1654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1655: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1656: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_contract_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1657: END IF;
1658:
1659: ROLLBACK TO g_add_contract_doc_grp;
1660: x_return_status := G_RET_STS_UNEXP_ERROR ;
1661: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1662:
1663: WHEN OTHERS THEN
1664: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_contract_doc because of EXCEPTION: '||sqlerrm);

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

1666: END IF;
1667:
1668: ROLLBACK TO g_add_contract_doc_grp;
1669: x_return_status := G_RET_STS_UNEXP_ERROR ;
1670: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1672: END IF;
1673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1674:

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

1667:
1668: ROLLBACK TO g_add_contract_doc_grp;
1669: x_return_status := G_RET_STS_UNEXP_ERROR ;
1670: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1672: END IF;
1673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1674:
1675: END Add_Contract_Doc;

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

1669: x_return_status := G_RET_STS_UNEXP_ERROR ;
1670: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1672: END IF;
1673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1674:
1675: END Add_Contract_Doc;
1676:
1677: Procedure Add_Standard_Clause

Line 1827: FND_MSG_PUB.initialize;

1823: END IF;
1824:
1825: -- Initialize message list if p_init_msg_list is set to TRUE.
1826: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1827: FND_MSG_PUB.initialize;
1828: END IF;
1829:
1830: -- Initialize API return status to success
1831: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2084: COMMIT WORK;
2085: END IF;
2086:
2087: -- Standard call to get message count and if count is 1, get message info.
2088: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2089:
2090: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');
2092: END IF;

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

2113: END IF;
2114:
2115: ROLLBACK TO g_add_standard_clause_grp;
2116: x_return_status := G_RET_STS_ERROR ;
2117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2118:
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2120: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2121: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2122: END IF;
2123:
2124: ROLLBACK TO g_add_standard_clause_grp;
2125: x_return_status := G_RET_STS_UNEXP_ERROR ;
2126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2127:
2128: WHEN OTHERS THEN
2129: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2130: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);

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

2131: END IF;
2132:
2133: ROLLBACK TO g_add_standard_clause_grp;
2134: x_return_status := G_RET_STS_UNEXP_ERROR ;
2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2139:

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

2132:
2133: ROLLBACK TO g_add_standard_clause_grp;
2134: x_return_status := G_RET_STS_UNEXP_ERROR ;
2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2139:
2140:

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

2134: x_return_status := G_RET_STS_UNEXP_ERROR ;
2135: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2139:
2140:
2141: END Add_Standard_Clause;
2142:

Line 2218: FND_MSG_PUB.initialize;

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

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

2363: COMMIT WORK;
2364: END IF;
2365:
2366: -- Standard call to get message count and if count is 1, get message info.
2367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2368:
2369: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2370: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_non_standard_clause');
2371: END IF;

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

2385: END IF;
2386:
2387: ROLLBACK TO g_add_non_standrad_clause_grp;
2388: x_return_status := G_RET_STS_ERROR ;
2389: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2390:
2391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2392: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2393: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_non_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2394: END IF;
2395:
2396: ROLLBACK TO g_add_non_standrad_clause_grp;
2397: x_return_status := G_RET_STS_UNEXP_ERROR ;
2398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2399:
2400: WHEN OTHERS THEN
2401: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_non_standard_clause because of EXCEPTION: '||sqlerrm);

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

2403: END IF;
2404:
2405: ROLLBACK TO g_add_non_standrad_clause_grp;
2406: x_return_status := G_RET_STS_UNEXP_ERROR ;
2407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2409: END IF;
2410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2411:

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

2404:
2405: ROLLBACK TO g_add_non_standrad_clause_grp;
2406: x_return_status := G_RET_STS_UNEXP_ERROR ;
2407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2409: END IF;
2410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2411:
2412: END Add_Non_Standard_Clause;

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

2406: x_return_status := G_RET_STS_UNEXP_ERROR ;
2407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2409: END IF;
2410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2411:
2412: END Add_Non_Standard_Clause;
2413:
2414: Procedure Add_Section

Line 2493: FND_MSG_PUB.initialize;

2489: END IF;
2490:
2491: -- Initialize message list if p_init_msg_list is set to TRUE.
2492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2493: FND_MSG_PUB.initialize;
2494: END IF;
2495:
2496: -- Initialize API return status to success
2497: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2625: COMMIT WORK;
2626: END IF;
2627:
2628: -- Standard call to get message count and if count is 1, get message info.
2629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2630:
2631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2632: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_section');
2633: END IF;

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

2644: END IF;
2645:
2646: ROLLBACK TO g_add_section_grp;
2647: x_return_status := G_RET_STS_ERROR ;
2648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2649:
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2652: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2653: END IF;
2654:
2655: ROLLBACK TO g_add_section_grp;
2656: x_return_status := G_RET_STS_UNEXP_ERROR ;
2657: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2658:
2659: WHEN OTHERS THEN
2660: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2661: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_section because of EXCEPTION: '||sqlerrm);

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

2662: END IF;
2663:
2664: ROLLBACK TO g_add_section_grp;
2665: x_return_status := G_RET_STS_UNEXP_ERROR ;
2666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2668: END IF;
2669: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2670:

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

2663:
2664: ROLLBACK TO g_add_section_grp;
2665: x_return_status := G_RET_STS_UNEXP_ERROR ;
2666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2668: END IF;
2669: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2670:
2671: END Add_Section;

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

2665: x_return_status := G_RET_STS_UNEXP_ERROR ;
2666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2667: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2668: END IF;
2669: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2670:
2671: END Add_Section;
2672:
2673: /*Delete Doc will delete all the template associated to the document, the sections

Line 2937: FND_MSG_PUB.initialize;

2933: END IF;
2934:
2935: -- Initialize message list if p_init_msg_list is set to TRUE.
2936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2937: FND_MSG_PUB.initialize;
2938: END IF;
2939:
2940: -- Initialize API return status to success
2941: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3083: --END IF;
3084:
3085: ROLLBACK TO g_update_variable_values_GRP;
3086: x_return_status := G_RET_STS_ERROR ;
3087: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3088:
3089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3090: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

3092: END IF;
3093:
3094: ROLLBACK TO g_update_variable_values_GRP;
3095: x_return_status := G_RET_STS_UNEXP_ERROR ;
3096: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3097:
3098: WHEN OTHERS THEN
3099: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3100: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving update_variable_values because of EXCEPTION: '||sqlerrm);

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

3101: END IF;
3102:
3103: ROLLBACK TO g_update_variable_values_GRP;
3104: x_return_status := G_RET_STS_UNEXP_ERROR ;
3105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3107: END IF;
3108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3109:

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

3102:
3103: ROLLBACK TO g_update_variable_values_GRP;
3104: x_return_status := G_RET_STS_UNEXP_ERROR ;
3105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3107: END IF;
3108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3109:
3110:

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

3104: x_return_status := G_RET_STS_UNEXP_ERROR ;
3105: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3106: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3107: END IF;
3108: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3109:
3110:
3111: END update_variable_values;
3112:

Line 3254: FND_MSG_PUB.initialize;

3250: END IF;
3251:
3252: -- Initialize message list if p_init_msg_list is set to TRUE.
3253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3254: FND_MSG_PUB.initialize;
3255: END IF;
3256:
3257: -- Initialize API return status to success
3258: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3506: END IF;
3507:
3508: ROLLBACK TO g_create_contract_terms_grp;
3509: x_return_status := G_RET_STS_ERROR ;
3510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

3515: END IF;
3516:
3517: ROLLBACK TO g_create_contract_terms_grp;
3518: x_return_status := G_RET_STS_UNEXP_ERROR ;
3519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3520:
3521: WHEN OTHERS THEN
3522: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3523: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving create_template_usages because of EXCEPTION: '||sqlerrm);

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

3524: END IF;
3525:
3526: ROLLBACK TO g_create_contract_terms_grp;
3527: x_return_status := G_RET_STS_UNEXP_ERROR ;
3528: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3529: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3530: END IF;
3531: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3532:

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

3525:
3526: ROLLBACK TO g_create_contract_terms_grp;
3527: x_return_status := G_RET_STS_UNEXP_ERROR ;
3528: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3529: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3530: END IF;
3531: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3532:
3533: END Create_template_usages;

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

3527: x_return_status := G_RET_STS_UNEXP_ERROR ;
3528: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3529: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3530: END IF;
3531: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3532:
3533: END Create_template_usages;
3534:
3535:

Line 5700: FND_MSG_PUB.initialize;

5696: END IF;
5697:
5698: -- Initialize message list if p_init_msg_list is set to TRUE.
5699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5700: FND_MSG_PUB.initialize;
5701: END IF;
5702:
5703: -- Initialize API return status to success
5704: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6046: END IF;
6047:
6048: ROLLBACK TO g_create_deliverables_GRP;
6049: x_return_status := G_RET_STS_ERROR ;
6050: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6051:
6052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6053: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6054: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_deliverables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

6059: END IF;
6060:
6061: ROLLBACK TO g_create_deliverables_GRP;
6062: x_return_status := G_RET_STS_UNEXP_ERROR ;
6063: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6064:
6065: WHEN OTHERS THEN
6066: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6067: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving create_deliverables because of EXCEPTION: '||sqlerrm);

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

6072: END IF;
6073:
6074: ROLLBACK TO g_create_deliverables_GRP;
6075: x_return_status := G_RET_STS_UNEXP_ERROR ;
6076: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6078: END IF;
6079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6080:

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

6073:
6074: ROLLBACK TO g_create_deliverables_GRP;
6075: x_return_status := G_RET_STS_UNEXP_ERROR ;
6076: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6078: END IF;
6079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6080:
6081: END create_deliverables;

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

6075: x_return_status := G_RET_STS_UNEXP_ERROR ;
6076: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6078: END IF;
6079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6080:
6081: END create_deliverables;
6082:
6083:

Line 6197: FND_MSG_PUB.initialize;

6193: END IF;
6194:
6195: -- Initialize message list if p_init_msg_list is set to TRUE.
6196: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6197: FND_MSG_PUB.initialize;
6198: END IF;
6199:
6200: -- Initialize API return status to success
6201: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6316: COMMIT WORK;
6317: END IF;
6318:
6319: -- Standard call to get message count and if count is 1, get message info.
6320: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6321:
6322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');
6324: END IF;

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

6342: END IF;
6343:
6344: ROLLBACK TO g_remove_std_clause_grp;
6345: x_return_status := G_RET_STS_ERROR ;
6346: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6347:
6348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6349: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6350: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

6351: END IF;
6352:
6353: ROLLBACK TO g_remove_std_clause_grp;
6354: x_return_status := G_RET_STS_UNEXP_ERROR ;
6355: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6356:
6357: WHEN OTHERS THEN
6358: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6359: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);

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

6360: END IF;
6361:
6362: ROLLBACK TO g_remove_std_clause_grp;
6363: x_return_status := G_RET_STS_UNEXP_ERROR ;
6364: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6366: END IF;
6367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6368:

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

6361:
6362: ROLLBACK TO g_remove_std_clause_grp;
6363: x_return_status := G_RET_STS_UNEXP_ERROR ;
6364: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6366: END IF;
6367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6368:
6369: END remove_std_clause_from_doc;

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

6363: x_return_status := G_RET_STS_UNEXP_ERROR ;
6364: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6366: END IF;
6367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6368:
6369: END remove_std_clause_from_doc;
6370:
6371: PROCEDURE remove_clause_id_from_doc(p_api_version IN Number,

Line 6421: FND_MSG_PUB.initialize;

6417: END IF;
6418:
6419: -- Initialize message list if p_init_msg_list is set to TRUE.
6420: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6421: FND_MSG_PUB.initialize;
6422: END IF;
6423:
6424: -- Initialize API return status to success
6425: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6525: COMMIT WORK;
6526: END IF;
6527:
6528: -- Standard call to get message count and if count is 1, get message info.
6529: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6530:
6531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving add_standard_clause');
6533: END IF;

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

6545: END IF;
6546:
6547: ROLLBACK TO g_remove_clause_from_doc_GRP;
6548: x_return_status := G_RET_STS_ERROR ;
6549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6550:
6551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving add_standard_clause: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

6554: END IF;
6555:
6556: ROLLBACK TO g_remove_clause_from_doc_GRP;
6557: x_return_status := G_RET_STS_UNEXP_ERROR ;
6558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6559:
6560: WHEN OTHERS THEN
6561: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6562: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving add_standard_clause because of EXCEPTION: '||sqlerrm);

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

6563: END IF;
6564:
6565: ROLLBACK TO g_remove_clause_from_doc_GRP;
6566: x_return_status := G_RET_STS_UNEXP_ERROR ;
6567: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6569: END IF;
6570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6571:

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

6564:
6565: ROLLBACK TO g_remove_clause_from_doc_GRP;
6566: x_return_status := G_RET_STS_UNEXP_ERROR ;
6567: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6569: END IF;
6570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6571:
6572: END remove_clause_id_from_doc;

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

6566: x_return_status := G_RET_STS_UNEXP_ERROR ;
6567: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6569: END IF;
6570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6571:
6572: END remove_clause_id_from_doc;
6573:
6574: END OKC_TERMS_MIGRATE_GRP;