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_UTIL_PVT dependencies on STANDARD

Line 751: -- Standard Start of API savepoint

747: BEGIN
748: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
749: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4400: Entered Mark_Amendment');
750: END IF;
751: -- Standard Start of API savepoint
752: SAVEPOINT g_Mark_Amendment;
753: -- Standard call to check for call compatibility.
754: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 753: -- Standard call to check for call compatibility.

749: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4400: Entered Mark_Amendment');
750: END IF;
751: -- Standard Start of API savepoint
752: SAVEPOINT g_Mark_Amendment;
753: -- Standard call to check for call compatibility.
754: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 791: -- Standard call to get message count and if count is 1, get message info.

787: END IF;
788: --------------------------------------------
789: END LOOP;
790:
791: -- Standard call to get message count and if count is 1, get message info.
792: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
793: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Mark_Amendment');
795: END IF;

Line 878: -- Standard Start of API savepoint

874: BEGIN
875: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
876: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Entered Merge_Template_Working_Copy');
877: END IF;
878: -- Standard Start of API savepoint
879: SAVEPOINT g_Merge_Template_Working_Copy;
880: -- Standard call to check for call compatibility.
881: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 880: -- Standard call to check for call compatibility.

876: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Entered Merge_Template_Working_Copy');
877: END IF;
878: -- Standard Start of API savepoint
879: SAVEPOINT g_Merge_Template_Working_Copy;
880: -- Standard call to check for call compatibility.
881: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1179: -- Standard call to get message count and if count is 1, get message info.

1175: g_parent_template_id := l_base_template_id;
1176:
1177: -- ================ Actual Procedure Code end =======================
1178:
1179: -- Standard call to get message count and if count is 1, get message info.
1180: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1181: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6100: Leaving Merge_Template_Working_Copy');
1183: END IF;

Line 1258: -- Standard Start of API savepoint

1254: BEGIN
1255: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6500: Entered Get_System_Variables');
1257: END IF;
1258: -- Standard Start of API savepoint
1259: SAVEPOINT g_Get_System_Variables;
1260: -- Standard call to check for call compatibility.
1261: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1260: -- Standard call to check for call compatibility.

1256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6500: Entered Get_System_Variables');
1257: END IF;
1258: -- Standard Start of API savepoint
1259: SAVEPOINT g_Get_System_Variables;
1260: -- Standard call to check for call compatibility.
1261: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1388: -- Standard call to get message count and if count is 1, get message info.

1384: ELSE
1385: NULL;
1386: END IF;
1387:
1388: -- Standard call to get message count and if count is 1, get message info.
1389: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1390: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6600: Leaving Get_System_Variables');
1392: END IF;

Line 1464: -- Standard Start of API savepoint

1460: BEGIN
1461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Substitute_Var_Value_Globally');
1463: END IF;
1464: -- Standard Start of API savepoint
1465: SAVEPOINT g_Subst_Var_Value_Globally;
1466: -- Standard call to check for call compatibility.
1467: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1466: -- Standard call to check for call compatibility.

1462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Substitute_Var_Value_Globally');
1463: END IF;
1464: -- Standard Start of API savepoint
1465: SAVEPOINT g_Subst_Var_Value_Globally;
1466: -- Standard call to check for call compatibility.
1467: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1554: -- Standard call to get message count and if count is 1, get message info.

1550: --------------------------------------------
1551: END LOOP;
1552: END IF;
1553:
1554: -- Standard call to get message count and if count is 1, get message info.
1555: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Substitute_Var_Value_Globally');
1558: END IF;

Line 1622: -- Standard Start of API savepoint

1618: BEGIN
1619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
1621: END IF;
1622: -- Standard Start of API savepoint
1623: SAVEPOINT g_Create_Unassigned_Section;
1624: -- Standard call to check for call compatibility.
1625: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1624: -- Standard call to check for call compatibility.

1620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
1621: END IF;
1622: -- Standard Start of API savepoint
1623: SAVEPOINT g_Create_Unassigned_Section;
1624: -- Standard call to check for call compatibility.
1625: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: END IF;
1628: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1685: -- Standard call to get message count and if count is 1, get message info.

1681:
1682: IF FND_API.To_Boolean( p_commit ) THEN
1683: COMMIT WORK;
1684: END IF;
1685: -- Standard call to get message count and if count is 1, get message info.
1686: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1687: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1688: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
1689: END IF;

Line 3175: -- Standard call to check for call compatibility.

3171: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3172: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered get_template_details');
3173: END IF;
3174:
3175: -- Standard call to check for call compatibility.
3176: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END IF;
3179: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3281: -- Standard call to get message count and if count is 1, get message info.

3277:
3278: IF FND_API.To_Boolean( p_commit ) THEN
3279: COMMIT WORK;
3280: END IF;
3281: -- Standard call to get message count and if count is 1, get message info.
3282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3283: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3284: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving get_template_details');
3285: END IF;

Line 3903: AND oaa.standard_yn = 'Y'

3899: okc_articles_all oaa
3900: WHERE oav.article_id = oaa.article_id
3901: AND oaa.org_id = cp_org_id
3902: AND oav.article_status IN ('DRAFT','REJECTED')
3903: AND oaa.standard_yn = 'Y'
3904: AND oav.start_date <= cp_effective_date
3905: AND nvl(oav.end_date, nvl(cp_effective_date,sysdate) +1) >= nvl(cp_effective_date,sysdate)
3906: AND oaa.article_id in
3907: (SELECT sav_sae_id from okc_k_articles_b oka

Line 4305: -- Standard Start of API savepoint

4301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4302: 'Entered OKC_TERMS_UTIL_PVT.update_contract_admin');
4303: END IF;
4304:
4305: -- Standard Start of API savepoint
4306: SAVEPOINT update_contract_admin;
4307:
4308: -- Standard call to check for call compatibility.
4309: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 4308: -- Standard call to check for call compatibility.

4304:
4305: -- Standard Start of API savepoint
4306: SAVEPOINT update_contract_admin;
4307:
4308: -- Standard call to check for call compatibility.
4309: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4311: END IF;
4312:

Line 4714: -- Standard call to check for call compatibility.

4710: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4711: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8000: Entered get_default_contract_admin');
4712: END IF;
4713:
4714: -- Standard call to check for call compatibility.
4715: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END IF;
4718:

Line 4735: -- Standard call to get message count and if count is 1, get message info.

4731: x_def_contract_admin_name := get_contract_admin_name(x_def_contract_admin_id);
4732: end if;
4733:
4734:
4735: -- Standard call to get message count and if count is 1, get message info.
4736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4737:
4738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4739: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: get_default_contract_admin');

Line 4893: -- Standard call to check for call compatibility.

4889: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4890: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8000: Entered lock_contract');
4891: END IF;
4892:
4893: -- Standard call to check for call compatibility.
4894: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: END IF;
4897:

Line 4918: -- Standard call to get message count and if count is 1, get message info.

4914: p_lock_terms_flag => 'Y',
4915: p_locked_by_user_id => FND_GLOBAL.user_id);
4916:
4917:
4918: -- Standard call to get message count and if count is 1, get message info.
4919: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4920:
4921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');

Line 4958: -- Standard call to check for call compatibility.

4954: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4955: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8000: Entered lock_contract');
4956: END IF;
4957:
4958: -- Standard call to check for call compatibility.
4959: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END IF;
4962:

Line 4982: -- Standard call to get message count and if count is 1, get message info.

4978: p_document_id => p_document_id,
4979: p_lock_terms_flag => 'N');
4980:
4981:
4982: -- Standard call to get message count and if count is 1, get message info.
4983: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4984:
4985: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4986: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');

Line 5118: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id

5114: /*
5115: Function Name : get_revert_art_version_id
5116: Purpose : This function returns the latest article_version_id of the ref_article_id queried using id
5117: of OKC_K_ARTICLES_B.
5118: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id
5119: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).
5120: */
5121:
5122: FUNCTION get_revert_art_version_id(

Line 5222: /* Standard call to check for call compatibility */

5218: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);
5219: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
5220: END IF;
5221:
5222: /* Standard call to check for call compatibility */
5223: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5225: END IF;
5226: