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

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

328: Fnd_Global.Login_Id);
329:
330: END IF;
331:
332: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
333:
334: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_article_variables '||x_return_status);
336: END IF;

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

345: IF l_get_variables_csr%ISOPEN THEN
346: CLOSE l_get_variables_csr;
347: END IF;
348: x_return_status := G_RET_STS_ERROR;
349: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
350:
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352:
353: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

357: IF l_get_variables_csr%ISOPEN THEN
358: CLOSE l_get_variables_csr;
359: END IF;
360: x_return_status := G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
362:
363: WHEN OTHERS THEN
364:
365: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

375: p_token1_value => sqlcode,
376: p_token2 => G_SQLERRM_TOKEN,
377: p_token2_value => sqlerrm);
378: x_return_status := G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
380:
381: END copy_article_variables;
382:
383:

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

1235: orig_article_id_tbl1(i));
1236:
1237: END IF;
1238:
1239: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1240:
1241: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1242: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_articles '||x_return_status);
1243: END IF;

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

1278: CLOSE l_get_std_csr;
1279: END IF;
1280:
1281: x_return_status := G_RET_STS_ERROR;
1282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1283:
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285:
1286: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1302: CLOSE l_get_org_csr;
1303: END IF;
1304:
1305: x_return_status := G_RET_STS_UNEXP_ERROR;
1306: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1307:
1308: WHEN OTHERS THEN
1309:
1310: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1339: p_token2 => G_SQLERRM_TOKEN,
1340: p_token2_value => sqlerrm);
1341:
1342: x_return_status := G_RET_STS_UNEXP_ERROR;
1343: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1344:
1345: END copy_articles;
1346:
1347: procedure copy_sections(

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

1639: sysdate);
1640:
1641: END IF;
1642:
1643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1644:
1645: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving copy_sections '||x_return_status);
1647: END IF;

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

1658: CLOSE l_get_scn_csr ;
1659: END IF;
1660:
1661: x_return_status := G_RET_STS_ERROR;
1662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665:
1666: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1671: CLOSE l_get_scn_csr ;
1672: END IF;
1673:
1674: x_return_status := G_RET_STS_UNEXP_ERROR;
1675: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1676:
1677: WHEN OTHERS THEN
1678:
1679: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1691: p_token2 => G_SQLERRM_TOKEN,
1692: p_token2_value => sqlerrm);
1693:
1694: x_return_status := G_RET_STS_UNEXP_ERROR;
1695: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1696:
1697: END copy_sections;
1698:
1699:

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

1886: RAISE FND_API.G_EXC_ERROR ;
1887: END IF;
1888: END IF;
1889:
1890: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1891:
1892: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving remove_template_based_articles '||x_return_status);
1894: END IF;

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

1955: CLOSE l_check_unassigned_section_csr ;
1956: END IF;
1957:
1958: x_return_status := G_RET_STS_ERROR;
1959: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1960:
1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1962:
1963: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1988: CLOSE l_check_unassigned_section_csr ;
1989: END IF;
1990:
1991: x_return_status := G_RET_STS_UNEXP_ERROR;
1992: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1993:
1994: WHEN OTHERS THEN
1995:
1996: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2012: p_token2 => G_SQLERRM_TOKEN,
2013: p_token2_value => sqlerrm);
2014:
2015: x_return_status := G_RET_STS_UNEXP_ERROR;
2016: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2017:
2018: END remove_template_based_articles;
2019:
2020: procedure copy_tc(

Line 2136: FND_MSG_PUB.initialize;

2132: END IF;
2133:
2134: -- Initialize message list if p_init_msg_list is set to TRUE.
2135: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2136: FND_MSG_PUB.initialize;
2137: END IF;
2138:
2139: -- Initialize API return status to success
2140: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2808: COMMIT WORK;
2809: END IF;
2810:
2811: -- Standard call to get message count and if count is 1, get message info.
2812: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2813:
2814: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2815: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Leaving copy_tc');
2816: END IF;

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

2889: END IF;
2890:
2891: ROLLBACK TO g_copy_tc_pvt;
2892: x_return_status := G_RET_STS_ERROR ;
2893: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2897: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_tc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2926: END IF;
2927:
2928: ROLLBACK TO g_copy_tc_pvt;
2929: x_return_status := G_RET_STS_UNEXP_ERROR ;
2930: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2931:
2932: WHEN OTHERS THEN
2933: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2934: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving copy_tc because of EXCEPTION: '||sqlerrm);

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

2959: END IF;
2960:
2961: ROLLBACK TO g_copy_tc_pvt;
2962: x_return_status := G_RET_STS_UNEXP_ERROR ;
2963: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2965: END IF;
2966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2967:

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

2960:
2961: ROLLBACK TO g_copy_tc_pvt;
2962: x_return_status := G_RET_STS_UNEXP_ERROR ;
2963: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2965: END IF;
2966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2967:
2968: END copy_tc;

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

2962: x_return_status := G_RET_STS_UNEXP_ERROR ;
2963: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2965: END IF;
2966: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2967:
2968: END copy_tc;
2969:
2970:

Line 3065: FND_MSG_PUB.initialize;

3061: END IF;
3062:
3063: -- Initialize message list if p_init_msg_list is set to TRUE.
3064: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3065: FND_MSG_PUB.initialize;
3066: END IF;
3067:
3068: -- Initialize API return status to success
3069: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3240: COMMIT WORK;
3241: END IF;
3242:
3243: -- Standard call to get message count and if count is 1, get message info.
3244: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3245:
3246: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3247: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Leaving copy_archived_doc');
3248: END IF;

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

3270: END IF;
3271:
3272: ROLLBACK TO g_copy_archived_doc_pvt;
3273: x_return_status := G_RET_STS_ERROR ;
3274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3275:
3276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3277:
3278: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3288: END IF;
3289:
3290: ROLLBACK TO g_copy_archived_doc_pvt;
3291: x_return_status := G_RET_STS_UNEXP_ERROR ;
3292: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3293:
3294: WHEN OTHERS THEN
3295:
3296: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3307:
3308: ROLLBACK TO g_copy_archived_doc_pvt;
3309: x_return_status := G_RET_STS_UNEXP_ERROR ;
3310:
3311: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3313: END IF;
3314:
3315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

3308: ROLLBACK TO g_copy_archived_doc_pvt;
3309: x_return_status := G_RET_STS_UNEXP_ERROR ;
3310:
3311: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3313: END IF;
3314:
3315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3316:

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

3311: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3313: END IF;
3314:
3315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3316:
3317: END copy_archived_doc;
3318:
3319: END OKC_TERMS_COPY_PVT;