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

Line 2053: FND_MSG_PUB.initialize;

2049: END IF;
2050:
2051: -- Initialize message list if p_init_msg_list is set to TRUE.
2052: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2053: FND_MSG_PUB.initialize;
2054: END IF;
2055:
2056: -- Initialize API return status to success
2057: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2698: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2699: END IF;
2700: ROLLBACK TO g_accept_changes;
2701: x_return_status := G_RET_STS_ERROR ;
2702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2703:
2704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2705: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 2710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2707: END IF;
2708: ROLLBACK TO g_accept_Changes;
2709: x_return_status := G_RET_STS_UNEXP_ERROR ;
2710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2711:
2712: WHEN OTHERS THEN
2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);

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

2715: END IF;
2716:
2717: ROLLBACK TO g_accept_changes;
2718: x_return_status := G_RET_STS_UNEXP_ERROR ;
2719: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2720: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2721: END IF;
2722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2723: END Accept_Changes;

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

2716:
2717: ROLLBACK TO g_accept_changes;
2718: x_return_status := G_RET_STS_UNEXP_ERROR ;
2719: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2720: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2721: END IF;
2722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2723: END Accept_Changes;
2724:

Line 2722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2718: x_return_status := G_RET_STS_UNEXP_ERROR ;
2719: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2720: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2721: END IF;
2722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2723: END Accept_Changes;
2724:
2725: PROCEDURE Reject_Changes (
2726: p_api_version IN NUMBER,

Line 2754: FND_MSG_PUB.initialize;

2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2754: FND_MSG_PUB.initialize;
2755: END IF;
2756: -- Initialize API return status to success
2757: x_return_status := FND_API.G_RET_STS_SUCCESS;
2758:

Line 2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2786: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_reject_changes;
2789: x_return_status := G_RET_STS_ERROR ;
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2791:
2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2793: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 2798: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_reject_Changes;
2797: x_return_status := G_RET_STS_UNEXP_ERROR ;
2798: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2799:
2800: WHEN OTHERS THEN
2801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2802: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);

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

2803: END IF;
2804:
2805: ROLLBACK TO g_reject_changes;
2806: x_return_status := G_RET_STS_UNEXP_ERROR ;
2807: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2809: END IF;
2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2811:

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

2804:
2805: ROLLBACK TO g_reject_changes;
2806: x_return_status := G_RET_STS_UNEXP_ERROR ;
2807: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2809: END IF;
2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2811:
2812: END Reject_Changes;

Line 2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2806: x_return_status := G_RET_STS_UNEXP_ERROR ;
2807: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2809: END IF;
2810: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2811:
2812: END Reject_Changes;
2813:
2814:

Line 2844: FND_MSG_PUB.initialize;

2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842: -- Initialize message list if p_init_msg_list is set to TRUE.
2843: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2844: FND_MSG_PUB.initialize;
2845: END IF;
2846: -- Initialize API return status to success
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:

Line 2899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2895: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2896: END IF;
2897: ROLLBACK TO g_delete_uploaded_terms;
2898: x_return_status := G_RET_STS_ERROR ;
2899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2900:
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 2907: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2904: END IF;
2905: ROLLBACK TO g_delete_uploaded_terms;
2906: x_return_status := G_RET_STS_UNEXP_ERROR ;
2907: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2908:
2909: WHEN OTHERS THEN
2910: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2911: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving delete_uploaded_Terms because of EXCEPTION: '||sqlerrm);

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

2912: END IF;
2913:
2914: ROLLBACK TO g_delete_uploaded_terms;
2915: x_return_status := G_RET_STS_UNEXP_ERROR ;
2916: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2918: END IF;
2919: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2920:

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

2913:
2914: ROLLBACK TO g_delete_uploaded_terms;
2915: x_return_status := G_RET_STS_UNEXP_ERROR ;
2916: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2918: END IF;
2919: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2920:
2921: END delete_uploaded_terms;

Line 2919: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2915: x_return_status := G_RET_STS_UNEXP_ERROR ;
2916: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2918: END IF;
2919: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2920:
2921: END delete_uploaded_terms;
2922:
2923:

Line 3304: FND_MSG_PUB.initialize;

3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302: -- Initialize message list if p_init_msg_list is set to TRUE.
3303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3304: FND_MSG_PUB.initialize;
3305: END IF;
3306: -- Initialize API return status to success
3307: x_return_status := FND_API.G_RET_STS_SUCCESS;
3308: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_STD','N') THEN

Line 4235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

4231: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4232: END IF;
4233: ROLLBACK TO g_reject_changes;
4234: x_return_status := G_RET_STS_ERROR ;
4235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4236:
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 4243: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

4239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4240: END IF;
4241: ROLLBACK TO g_reject_Changes;
4242: x_return_status := G_RET_STS_UNEXP_ERROR ;
4243: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4244:
4245: WHEN OTHERS THEN
4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);

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

4248: END IF;
4249:
4250: ROLLBACK TO g_reject_changes;
4251: x_return_status := G_RET_STS_UNEXP_ERROR ;
4252: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4254: END IF;
4255: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4256: END Sync_Review_Tables;

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

4249:
4250: ROLLBACK TO g_reject_changes;
4251: x_return_status := G_RET_STS_UNEXP_ERROR ;
4252: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4254: END IF;
4255: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4256: END Sync_Review_Tables;
4257:

Line 4255: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

4251: x_return_status := G_RET_STS_UNEXP_ERROR ;
4252: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4254: END IF;
4255: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4256: END Sync_Review_Tables;
4257:
4258: /*
4259: -- PROCEDURE Create_Unassigned_Section

Line 4302: FND_MSG_PUB.initialize;

4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4302: FND_MSG_PUB.initialize;
4303: END IF;
4304: -- Initialize API return status to success
4305: x_return_status := G_RET_STS_SUCCESS;
4306:

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

4394: IF FND_API.To_Boolean( p_commit ) THEN
4395: COMMIT WORK;
4396: END IF;
4397: -- Standard call to get message count and if count is 1, get message info.
4398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4401: END IF;
4402: EXCEPTION

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

4410: CLOSE l_get_max_seq_csr;
4411: END IF;
4412:
4413: x_return_status := G_RET_STS_ERROR ;
4414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4415:
4416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4417: ROLLBACK TO g_Create_Unassigned_Section;
4418: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4423: CLOSE l_get_max_seq_csr;
4424: END IF;
4425:
4426: x_return_status := G_RET_STS_UNEXP_ERROR ;
4427: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4428:
4429: WHEN OTHERS THEN
4430: ROLLBACK TO g_Create_Unassigned_Section;
4431: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4436: CLOSE l_get_max_seq_csr;
4437: END IF;
4438:
4439: x_return_status := G_RET_STS_UNEXP_ERROR ;
4440: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4442: END IF;
4443: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4444: END Create_Unassigned_Section ;

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

4437: END IF;
4438:
4439: x_return_status := G_RET_STS_UNEXP_ERROR ;
4440: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4442: END IF;
4443: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4444: END Create_Unassigned_Section ;
4445:

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

4439: x_return_status := G_RET_STS_UNEXP_ERROR ;
4440: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4442: END IF;
4443: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4444: END Create_Unassigned_Section ;
4445:
4446:
4447: END OKC_REVIEW_UPLD_TERMS_PVT;