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 710: -- Standard Start of API savepoint

706: BEGIN
707: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
708: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4400: Entered Mark_Amendment');
709: END IF;
710: -- Standard Start of API savepoint
711: SAVEPOINT g_Mark_Amendment;
712: -- Standard call to check for call compatibility.
713: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

708: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4400: Entered Mark_Amendment');
709: END IF;
710: -- Standard Start of API savepoint
711: SAVEPOINT g_Mark_Amendment;
712: -- Standard call to check for call compatibility.
713: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716: -- Initialize message list if p_init_msg_list is set to TRUE.

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

746: END IF;
747: --------------------------------------------
748: END LOOP;
749:
750: -- Standard call to get message count and if count is 1, get message info.
751: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
752: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Mark_Amendment');
754: END IF;

Line 837: -- Standard Start of API savepoint

833: BEGIN
834: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Entered Merge_Template_Working_Copy');
836: END IF;
837: -- Standard Start of API savepoint
838: SAVEPOINT g_Merge_Template_Working_Copy;
839: -- Standard call to check for call compatibility.
840: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Entered Merge_Template_Working_Copy');
836: END IF;
837: -- Standard Start of API savepoint
838: SAVEPOINT g_Merge_Template_Working_Copy;
839: -- Standard call to check for call compatibility.
840: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1134: g_parent_template_id := l_base_template_id;
1135:
1136: -- ================ Actual Procedure Code end =======================
1137:
1138: -- Standard call to get message count and if count is 1, get message info.
1139: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6100: Leaving Merge_Template_Working_Copy');
1142: END IF;

Line 1217: -- Standard Start of API savepoint

1213: BEGIN
1214: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6500: Entered Get_System_Variables');
1216: END IF;
1217: -- Standard Start of API savepoint
1218: SAVEPOINT g_Get_System_Variables;
1219: -- Standard call to check for call compatibility.
1220: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6500: Entered Get_System_Variables');
1216: END IF;
1217: -- Standard Start of API savepoint
1218: SAVEPOINT g_Get_System_Variables;
1219: -- Standard call to check for call compatibility.
1220: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1222: END IF;
1223: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1342: ELSE
1343: NULL;
1344: END IF;
1345:
1346: -- Standard call to get message count and if count is 1, get message info.
1347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1348: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1349: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6600: Leaving Get_System_Variables');
1350: END IF;

Line 1422: -- Standard Start of API savepoint

1418: BEGIN
1419: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Substitute_Var_Value_Globally');
1421: END IF;
1422: -- Standard Start of API savepoint
1423: SAVEPOINT g_Subst_Var_Value_Globally;
1424: -- Standard call to check for call compatibility.
1425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7000: Entered Substitute_Var_Value_Globally');
1421: END IF;
1422: -- Standard Start of API savepoint
1423: SAVEPOINT g_Subst_Var_Value_Globally;
1424: -- Standard call to check for call compatibility.
1425: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: END IF;
1428: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1508: --------------------------------------------
1509: END LOOP;
1510: END IF;
1511:
1512: -- Standard call to get message count and if count is 1, get message info.
1513: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1514: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7100: Leaving Substitute_Var_Value_Globally');
1516: END IF;

Line 1580: -- Standard Start of API savepoint

1576: BEGIN
1577: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
1579: END IF;
1580: -- Standard Start of API savepoint
1581: SAVEPOINT g_Create_Unassigned_Section;
1582: -- Standard call to check for call compatibility.
1583: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
1579: END IF;
1580: -- Standard Start of API savepoint
1581: SAVEPOINT g_Create_Unassigned_Section;
1582: -- Standard call to check for call compatibility.
1583: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;
1586: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1639:
1640: IF FND_API.To_Boolean( p_commit ) THEN
1641: COMMIT WORK;
1642: END IF;
1643: -- Standard call to get message count and if count is 1, get message info.
1644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
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,'7700: Leaving Create_Unassigned_Section');
1647: END IF;

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

3129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3130: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered get_template_details');
3131: END IF;
3132:
3133: -- Standard call to check for call compatibility.
3134: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3136: END IF;
3137: -- Initialize message list if p_init_msg_list is set to TRUE.

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

3235:
3236: IF FND_API.To_Boolean( p_commit ) THEN
3237: COMMIT WORK;
3238: END IF;
3239: -- Standard call to get message count and if count is 1, get message info.
3240: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3241: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3242: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving get_template_details');
3243: END IF;

Line 3854: AND oaa.standard_yn = 'Y'

3850: okc_articles_all oaa
3851: WHERE oav.article_id = oaa.article_id
3852: AND oaa.org_id = cp_org_id
3853: AND oav.article_status IN ('DRAFT','REJECTED')
3854: AND oaa.standard_yn = 'Y'
3855: AND oav.start_date <= cp_effective_date
3856: AND nvl(oav.end_date, nvl(cp_effective_date,sysdate) +1) >= nvl(cp_effective_date,sysdate)
3857: AND oaa.article_id in
3858: (SELECT sav_sae_id from okc_k_articles_b oka

Line 4256: -- Standard Start of API savepoint

4252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4253: 'Entered OKC_TERMS_UTIL_PVT.update_contract_admin');
4254: END IF;
4255:
4256: -- Standard Start of API savepoint
4257: SAVEPOINT update_contract_admin;
4258:
4259: -- Standard call to check for call compatibility.
4260: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

4255:
4256: -- Standard Start of API savepoint
4257: SAVEPOINT update_contract_admin;
4258:
4259: -- Standard call to check for call compatibility.
4260: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4262: END IF;
4263:

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

4661: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4662: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8000: Entered get_default_contract_admin');
4663: END IF;
4664:
4665: -- Standard call to check for call compatibility.
4666: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4668: END IF;
4669:

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

4682: x_def_contract_admin_name := get_contract_admin_name(x_def_contract_admin_id);
4683: end if;
4684:
4685:
4686: -- Standard call to get message count and if count is 1, get message info.
4687: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4688:
4689: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4690: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: get_default_contract_admin');

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

4840: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4841: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8000: Entered lock_contract');
4842: END IF;
4843:
4844: -- Standard call to check for call compatibility.
4845: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: END IF;
4848:

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

4865: p_lock_terms_flag => 'Y',
4866: p_locked_by_user_id => FND_GLOBAL.user_id);
4867:
4868:
4869: -- Standard call to get message count and if count is 1, get message info.
4870: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4871:
4872: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4873: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');

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

4905: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4906: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8000: Entered lock_contract');
4907: END IF;
4908:
4909: -- Standard call to check for call compatibility.
4910: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4912: END IF;
4913:

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

4929: p_document_id => p_document_id,
4930: p_lock_terms_flag => 'N');
4931:
4932:
4933: -- Standard call to get message count and if count is 1, get message info.
4934: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4935:
4936: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4937: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8100: Leaving lock_contract');

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

5065: /*
5066: Function Name : get_revert_art_version_id
5067: Purpose : This function returns the latest article_version_id of the ref_article_id queried using id
5068: of OKC_K_ARTICLES_B.
5069: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id
5070: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).
5071: */
5072:
5073: FUNCTION get_revert_art_version_id(

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

5169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_type:'||p_document_type);
5170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: p_document_id:'||p_document_id);
5171: END IF;
5172:
5173: /* Standard call to check for call compatibility */
5174: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5176: END IF;
5177: