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

Line 110: -- Standard Start of API savepoint

106: FND_LOG.STRING(G_PROC_LEVEL,
107: G_PKG_NAME, '100: Entered create_non_std_article' );
108: END IF;
109:
110: -- Standard Start of API savepoint
111: SAVEPOINT g_create_non_std_article_GRP;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

108: END IF;
109:
110: -- Standard Start of API savepoint
111: SAVEPOINT g_create_non_std_article_GRP;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 176: p_standard_yn =>'N',

172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,
174: p_article_title => p_article_title,
175: p_article_number => l_article_number,
176: p_standard_yn =>'N',
177: p_article_intent => l_intent,
178: p_article_language => USERENV('LANG'),
179: p_article_type => p_article_type,
180: p_orig_system_reference_code => NULL,

Line 326: -- Standard check of p_commit

322:
323: END IF;
324:
325:
326: -- Standard check of p_commit
327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330:

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

327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330:
331: -- Standard call to get message count and if count is 1, get message info.
332: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
333:
334: /*IF (l_debug = 'Y') THEN
335: okc_debug.log('900: Leaving create_non_std_article', 2);

Line 468: -- Standard Start of API savepoint

464: FND_LOG.STRING(G_PROC_LEVEL,
465: G_PKG_NAME, '100: Entered update_non_std_article' );
466: END IF;
467:
468: -- Standard Start of API savepoint
469: SAVEPOINT g_update_non_std_article_GRP;
470: -- Standard call to check for call compatibility.
471: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

466: END IF;
467:
468: -- Standard Start of API savepoint
469: SAVEPOINT g_update_non_std_article_GRP;
470: -- Standard call to check for call compatibility.
471: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 575: p_standard_yn => NULL,

571: x_msg_data => x_msg_data,
572: p_article_id => l_article_id,
573: p_article_title => p_article_title,
574: p_article_number => NULL,
575: p_standard_yn => NULL,
576: p_article_intent => NULL,
577: p_article_language => NULL,
578: p_article_type => p_article_type,
579: p_orig_system_reference_code => NULL,

Line 669: -- Standard check of p_commit

665: END IF;
666: --------------------------------------------
667: END IF; -- IF change_nonstd_yn='Y' THEN
668:
669: -- Standard check of p_commit
670: IF FND_API.To_Boolean( p_commit ) THEN
671: COMMIT WORK;
672: END IF;
673:

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

670: IF FND_API.To_Boolean( p_commit ) THEN
671: COMMIT WORK;
672: END IF;
673:
674: -- Standard call to get message count and if count is 1, get message info.
675: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
676:
677: /*IF (l_debug = 'Y') THEN
678: okc_debug.log('900: Leavingupdate_non_std_article', 2);

Line 749: Procedure revert_to_standard(

745:
746: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
747: END update_non_std_article;
748:
749: Procedure revert_to_standard(
750: p_api_version IN NUMBER,
751: p_init_msg_list IN VARCHAR2 ,
752: p_validate_commit IN VARCHAR2,
753: p_validation_string IN VARCHAR2,

Line 768: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';

764: p_lock_terms_yn IN VARCHAR2
765: ) IS
766:
767: l_api_version CONSTANT NUMBER := 1;
768: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
769: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
770: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
771: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
772: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

Line 815: okc_debug.log('100: Entered revert_to_standard', 2);

811:
812:
813: BEGIN
814: /*IF (l_debug = 'Y') THEN
815: okc_debug.log('100: Entered revert_to_standard', 2);
816: END IF;*/
817:
818: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
819: FND_LOG.STRING(G_PROC_LEVEL,

Line 820: G_PKG_NAME, '100: Entered revert_to_standard' );

816: END IF;*/
817:
818: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
819: FND_LOG.STRING(G_PROC_LEVEL,
820: G_PKG_NAME, '100: Entered revert_to_standard' );
821: END IF;
822:
823: -- Standard Start of API savepoint
824: SAVEPOINT g_revert_to_standard_GRP;

Line 823: -- Standard Start of API savepoint

819: FND_LOG.STRING(G_PROC_LEVEL,
820: G_PKG_NAME, '100: Entered revert_to_standard' );
821: END IF;
822:
823: -- Standard Start of API savepoint
824: SAVEPOINT g_revert_to_standard_GRP;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 824: SAVEPOINT g_revert_to_standard_GRP;

820: G_PKG_NAME, '100: Entered revert_to_standard' );
821: END IF;
822:
823: -- Standard Start of API savepoint
824: SAVEPOINT g_revert_to_standard_GRP;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;

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

821: END IF;
822:
823: -- Standard Start of API savepoint
824: SAVEPOINT g_revert_to_standard_GRP;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: END IF;
829: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 862: okc_debug.log('200: revert_to_standard', 2);

858: -- Initialize API return status to success
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860:
861: /*IF (l_debug = 'Y') THEN
862: okc_debug.log('200: revert_to_standard', 2);
863: END IF;*/
864:
865: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
866: FND_LOG.STRING(G_PROC_LEVEL,

Line 867: G_PKG_NAME, '200: revert_to_standard' );

863: END IF;*/
864:
865: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
866: FND_LOG.STRING(G_PROC_LEVEL,
867: G_PKG_NAME, '200: revert_to_standard' );
868: END IF;
869:
870: OPEN l_get_kart_dtl_csr;
871: FETCH l_get_kart_dtl_csr

Line 992: Delete those variables that are not in the Standard Article Version

988: FND_LOG.STRING(G_PROC_LEVEL,
989: G_PKG_NAME, '700: After invoking OKC_K_ARTICLES_GRP.create_article record x_return_status = ' || x_return_status );
990: END IF;
991: /*
992: Delete those variables that are not in the Standard Article Version
993: to which we are reverting to
994: */
995: for del_var_csr in l_get_delete_var loop
996: OKC_K_ART_VARIABLES_PVT.Delete_Row(

Line 1013: available in the Standard Article Version to which we are reverting to

1009:
1010:
1011: /*
1012: Insert those variables that are not in the Current Clause, but are
1013: available in the Standard Article Version to which we are reverting to
1014: */
1015:
1016:
1017: for ins_var_csr in l_get_insert_var loop

Line 1040: -- Standard check of p_commit

1036:
1037:
1038: end loop;
1039:
1040: -- Standard check of p_commit
1041: IF FND_API.To_Boolean( p_commit ) THEN
1042: COMMIT WORK;
1043: END IF;
1044:

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

1041: IF FND_API.To_Boolean( p_commit ) THEN
1042: COMMIT WORK;
1043: END IF;
1044:
1045: -- Standard call to get message count and if count is 1, get message info.
1046: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1047:
1048: /*IF (l_debug = 'Y') THEN
1049: okc_debug.log('900: Leaving revert_to_standard', 2);

Line 1049: okc_debug.log('900: Leaving revert_to_standard', 2);

1045: -- Standard call to get message count and if count is 1, get message info.
1046: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1047:
1048: /*IF (l_debug = 'Y') THEN
1049: okc_debug.log('900: Leaving revert_to_standard', 2);
1050: END IF;*/
1051:
1052: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1053: FND_LOG.STRING(G_PROC_LEVEL,

Line 1054: G_PKG_NAME, '900: Leaving revert_to_standard' );

1050: END IF;*/
1051:
1052: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1053: FND_LOG.STRING(G_PROC_LEVEL,
1054: G_PKG_NAME, '900: Leaving revert_to_standard' );
1055: END IF;
1056:
1057: EXCEPTION
1058: WHEN FND_API.G_EXC_ERROR THEN

Line 1060: okc_debug.log('300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1056:
1057: EXCEPTION
1058: WHEN FND_API.G_EXC_ERROR THEN
1059: /*IF (l_debug = 'Y') THEN
1060: okc_debug.log('300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1061: END IF;*/
1062:
1063: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1064: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1065: G_PKG_NAME, '300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception' );

1061: END IF;*/
1062:
1063: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1064: FND_LOG.STRING(G_EXCP_LEVEL,
1065: G_PKG_NAME, '300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception' );
1066: END IF;
1067:
1068: IF l_get_kart_dtl_csr%ISOPEN THEN
1069: CLOSE l_get_kart_dtl_csr;

Line 1073: ROLLBACK TO g_revert_to_standard_GRP;

1069: CLOSE l_get_kart_dtl_csr;
1070: END IF;
1071:
1072:
1073: ROLLBACK TO g_revert_to_standard_GRP;
1074: x_return_status := G_RET_STS_ERROR ;
1075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1076:
1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1079: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1075: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1076:
1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1078: /*IF (l_debug = 'Y') THEN
1079: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1080: END IF;*/
1081:
1082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1083: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1084: G_PKG_NAME, '400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

1080: END IF;*/
1081:
1082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1083: FND_LOG.STRING(G_EXCP_LEVEL,
1084: G_PKG_NAME, '400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1085: END IF;
1086:
1087: IF l_get_kart_dtl_csr%ISOPEN THEN
1088: CLOSE l_get_kart_dtl_csr;

Line 1092: ROLLBACK TO g_revert_to_standard_GRP;

1088: CLOSE l_get_kart_dtl_csr;
1089: END IF;
1090:
1091:
1092: ROLLBACK TO g_revert_to_standard_GRP;
1093: x_return_status := G_RET_STS_UNEXP_ERROR ;
1094: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1095:
1096: WHEN OTHERS THEN

Line 1098: okc_debug.log('500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm, 2);

1094: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1095:
1096: WHEN OTHERS THEN
1097: /*IF (l_debug = 'Y') THEN
1098: okc_debug.log('500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm, 2);
1099: END IF;*/
1100:
1101: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1102: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1103: G_PKG_NAME, '500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm );

1099: END IF;*/
1100:
1101: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1102: FND_LOG.STRING(G_EXCP_LEVEL,
1103: G_PKG_NAME, '500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm );
1104: END IF;
1105:
1106: IF l_get_kart_dtl_csr%ISOPEN THEN
1107: CLOSE l_get_kart_dtl_csr;

Line 1111: ROLLBACK TO g_revert_to_standard_GRP;

1107: CLOSE l_get_kart_dtl_csr;
1108: END IF;
1109:
1110:
1111: ROLLBACK TO g_revert_to_standard_GRP;
1112: x_return_status := G_RET_STS_UNEXP_ERROR ;
1113: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1115: END IF;

Line 1118: END revert_to_standard;

1114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1115: END IF;
1116:
1117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1118: END revert_to_standard;
1119:
1120: END OKC_K_NON_STD_ART_GRP;