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

2011: END IF;
2012:
2013: -- Initialize message list if p_init_msg_list is set to TRUE.
2014: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2015: FND_MSG_PUB.initialize;
2016: END IF;
2017:
2018: -- Initialize API return status to success
2019: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2593: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2594: END IF;
2595: ROLLBACK TO g_accept_changes;
2596: x_return_status := G_RET_STS_ERROR ;
2597: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2598:
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2602: END IF;
2603: ROLLBACK TO g_accept_Changes;
2604: x_return_status := G_RET_STS_UNEXP_ERROR ;
2605: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2606:
2607: WHEN OTHERS THEN
2608: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2609: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);

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

2610: END IF;
2611:
2612: ROLLBACK TO g_accept_changes;
2613: x_return_status := G_RET_STS_UNEXP_ERROR ;
2614: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2618: END Accept_Changes;

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

2611:
2612: ROLLBACK TO g_accept_changes;
2613: x_return_status := G_RET_STS_UNEXP_ERROR ;
2614: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2618: END Accept_Changes;
2619:

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

2613: x_return_status := G_RET_STS_UNEXP_ERROR ;
2614: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2616: END IF;
2617: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2618: END Accept_Changes;
2619:
2620: PROCEDURE Reject_Changes (
2621: p_api_version IN NUMBER,

Line 2649: FND_MSG_PUB.initialize;

2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END IF;
2647: -- Initialize message list if p_init_msg_list is set to TRUE.
2648: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2649: FND_MSG_PUB.initialize;
2650: END IF;
2651: -- Initialize API return status to success
2652: x_return_status := FND_API.G_RET_STS_SUCCESS;
2653:

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

2677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2678: END IF;
2679: ROLLBACK TO g_reject_changes;
2680: x_return_status := G_RET_STS_ERROR ;
2681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2682:
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2685: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2685: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2686: END IF;
2687: ROLLBACK TO g_reject_Changes;
2688: x_return_status := G_RET_STS_UNEXP_ERROR ;
2689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2690:
2691: WHEN OTHERS THEN
2692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);

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

2694: END IF;
2695:
2696: ROLLBACK TO g_reject_changes;
2697: x_return_status := G_RET_STS_UNEXP_ERROR ;
2698: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2700: END IF;
2701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2702:

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

2695:
2696: ROLLBACK TO g_reject_changes;
2697: x_return_status := G_RET_STS_UNEXP_ERROR ;
2698: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2700: END IF;
2701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2702:
2703: END Reject_Changes;

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

2697: x_return_status := G_RET_STS_UNEXP_ERROR ;
2698: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2700: END IF;
2701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2702:
2703: END Reject_Changes;
2704:
2705:

Line 2735: FND_MSG_PUB.initialize;

2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: END IF;
2733: -- Initialize message list if p_init_msg_list is set to TRUE.
2734: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2735: FND_MSG_PUB.initialize;
2736: END IF;
2737: -- Initialize API return status to success
2738: x_return_status := FND_API.G_RET_STS_SUCCESS;
2739:

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 Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_delete_uploaded_terms;
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 Delete_Uploaded_terms: 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 Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_delete_uploaded_terms;
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 delete_uploaded_Terms 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_delete_uploaded_terms;
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_delete_uploaded_terms;
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 delete_uploaded_terms;

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 delete_uploaded_terms;
2813:
2814:

Line 3193: FND_MSG_PUB.initialize;

3189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3190: END IF;
3191: -- Initialize message list if p_init_msg_list is set to TRUE.
3192: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3193: FND_MSG_PUB.initialize;
3194: END IF;
3195: -- Initialize API return status to success
3196: x_return_status := FND_API.G_RET_STS_SUCCESS;
3197: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_STD','N') THEN

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

4070: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4071: END IF;
4072: ROLLBACK TO g_reject_changes;
4073: x_return_status := G_RET_STS_ERROR ;
4074: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4075:
4076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4077: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4078: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

4078: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4079: END IF;
4080: ROLLBACK TO g_reject_Changes;
4081: x_return_status := G_RET_STS_UNEXP_ERROR ;
4082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4083:
4084: WHEN OTHERS THEN
4085: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4086: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);

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

4087: END IF;
4088:
4089: ROLLBACK TO g_reject_changes;
4090: x_return_status := G_RET_STS_UNEXP_ERROR ;
4091: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4092: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4093: END IF;
4094: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4095: END Sync_Review_Tables;

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

4088:
4089: ROLLBACK TO g_reject_changes;
4090: x_return_status := G_RET_STS_UNEXP_ERROR ;
4091: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4092: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4093: END IF;
4094: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4095: END Sync_Review_Tables;
4096:

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

4090: x_return_status := G_RET_STS_UNEXP_ERROR ;
4091: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4092: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4093: END IF;
4094: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4095: END Sync_Review_Tables;
4096:
4097: /*
4098: -- PROCEDURE Create_Unassigned_Section

Line 4141: FND_MSG_PUB.initialize;

4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4138: END IF;
4139: -- Initialize message list if p_init_msg_list is set to TRUE.
4140: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4141: FND_MSG_PUB.initialize;
4142: END IF;
4143: -- Initialize API return status to success
4144: x_return_status := G_RET_STS_SUCCESS;
4145:

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

4233: IF FND_API.To_Boolean( p_commit ) THEN
4234: COMMIT WORK;
4235: END IF;
4236: -- Standard call to get message count and if count is 1, get message info.
4237: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4240: END IF;
4241: EXCEPTION

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

4249: CLOSE l_get_max_seq_csr;
4250: END IF;
4251:
4252: x_return_status := G_RET_STS_ERROR ;
4253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4254:
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: ROLLBACK TO g_Create_Unassigned_Section;
4257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4262: CLOSE l_get_max_seq_csr;
4263: END IF;
4264:
4265: x_return_status := G_RET_STS_UNEXP_ERROR ;
4266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4267:
4268: WHEN OTHERS THEN
4269: ROLLBACK TO g_Create_Unassigned_Section;
4270: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4275: CLOSE l_get_max_seq_csr;
4276: END IF;
4277:
4278: x_return_status := G_RET_STS_UNEXP_ERROR ;
4279: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4281: END IF;
4282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4283: END Create_Unassigned_Section ;

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

4276: END IF;
4277:
4278: x_return_status := G_RET_STS_UNEXP_ERROR ;
4279: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4281: END IF;
4282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4283: END Create_Unassigned_Section ;
4284:

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

4278: x_return_status := G_RET_STS_UNEXP_ERROR ;
4279: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4281: END IF;
4282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4283: END Create_Unassigned_Section ;
4284:
4285:
4286: END OKC_REVIEW_UPLD_TERMS_PVT;