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

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

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

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

Line 173: p_standard_yn =>'N',

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

Line 320: -- Standard check of p_commit

316:
317: END IF;
318:
319:
320: -- Standard check of p_commit
321: IF FND_API.To_Boolean( p_commit ) THEN
322: COMMIT WORK;
323: END IF;
324:

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

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

Line 459: -- Standard Start of API savepoint

455: FND_LOG.STRING(G_PROC_LEVEL,
456: G_PKG_NAME, '100: Entered update_non_std_article' );
457: END IF;
458:
459: -- Standard Start of API savepoint
460: SAVEPOINT g_update_non_std_article_GRP;
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

457: END IF;
458:
459: -- Standard Start of API savepoint
460: SAVEPOINT g_update_non_std_article_GRP;
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 563: p_standard_yn => NULL,

559: x_msg_data => x_msg_data,
560: p_article_id => l_article_id,
561: p_article_title => p_article_title,
562: p_article_number => NULL,
563: p_standard_yn => NULL,
564: p_article_intent => NULL,
565: p_article_language => NULL,
566: p_article_type => p_article_type,
567: p_orig_system_reference_code => NULL,

Line 654: -- Standard check of p_commit

650: END IF;
651: --------------------------------------------
652: END IF; -- IF change_nonstd_yn='Y' THEN
653:
654: -- Standard check of p_commit
655: IF FND_API.To_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:

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

655: IF FND_API.To_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:
659: -- Standard call to get message count and if count is 1, get message info.
660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
661:
662: /*IF (l_debug = 'Y') THEN
663: okc_debug.log('900: Leavingupdate_non_std_article', 2);

Line 734: Procedure revert_to_standard(

730:
731: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
732: END update_non_std_article;
733:
734: Procedure revert_to_standard(
735: p_api_version IN NUMBER,
736: p_init_msg_list IN VARCHAR2 ,
737: p_validate_commit IN VARCHAR2,
738: p_validation_string IN VARCHAR2,

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

748: x_article_version_id OUT NOCOPY NUMBER
749: ) IS
750:
751: l_api_version CONSTANT NUMBER := 1;
752: l_api_name CONSTANT VARCHAR2(30) := 'revert_to_standard';
753: l_sav_sae_id OKC_K_ARTICLES_B.sav_sae_id%TYPE;
754: l_scn_id OKC_K_ARTICLES_B.scn_id%TYPE;
755: l_orig_article_id OKC_K_ARTICLES_B.orig_article_id%TYPE;
756: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;

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

795:
796:
797: BEGIN
798: /*IF (l_debug = 'Y') THEN
799: okc_debug.log('100: Entered revert_to_standard', 2);
800: END IF;*/
801:
802: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
803: FND_LOG.STRING(G_PROC_LEVEL,

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

800: END IF;*/
801:
802: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
803: FND_LOG.STRING(G_PROC_LEVEL,
804: G_PKG_NAME, '100: Entered revert_to_standard' );
805: END IF;
806:
807: -- Standard Start of API savepoint
808: SAVEPOINT g_revert_to_standard_GRP;

Line 807: -- Standard Start of API savepoint

803: FND_LOG.STRING(G_PROC_LEVEL,
804: G_PKG_NAME, '100: Entered revert_to_standard' );
805: END IF;
806:
807: -- Standard Start of API savepoint
808: SAVEPOINT g_revert_to_standard_GRP;
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 808: SAVEPOINT g_revert_to_standard_GRP;

804: G_PKG_NAME, '100: Entered revert_to_standard' );
805: END IF;
806:
807: -- Standard Start of API savepoint
808: SAVEPOINT g_revert_to_standard_GRP;
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;

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

805: END IF;
806:
807: -- Standard Start of API savepoint
808: SAVEPOINT g_revert_to_standard_GRP;
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: -- Initialize message list if p_init_msg_list is set to TRUE.

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

842: -- Initialize API return status to success
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844:
845: /*IF (l_debug = 'Y') THEN
846: okc_debug.log('200: revert_to_standard', 2);
847: END IF;*/
848:
849: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
850: FND_LOG.STRING(G_PROC_LEVEL,

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

847: END IF;*/
848:
849: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
850: FND_LOG.STRING(G_PROC_LEVEL,
851: G_PKG_NAME, '200: revert_to_standard' );
852: END IF;
853:
854: OPEN l_get_kart_dtl_csr;
855: FETCH l_get_kart_dtl_csr

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

971: FND_LOG.STRING(G_PROC_LEVEL,
972: G_PKG_NAME, '700: After invoking OKC_K_ARTICLES_GRP.create_article record x_return_status = ' || x_return_status );
973: END IF;
974: /*
975: Delete those variables that are not in the Standard Article Version
976: to which we are reverting to
977: */
978: for del_var_csr in l_get_delete_var loop
979: OKC_K_ART_VARIABLES_PVT.Delete_Row(

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

992:
993:
994: /*
995: Insert those variables that are not in the Current Clause, but are
996: available in the Standard Article Version to which we are reverting to
997: */
998:
999:
1000: for ins_var_csr in l_get_insert_var loop

Line 1023: -- Standard check of p_commit

1019:
1020:
1021: end loop;
1022:
1023: -- Standard check of p_commit
1024: IF FND_API.To_Boolean( p_commit ) THEN
1025: COMMIT WORK;
1026: END IF;
1027:

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

1024: IF FND_API.To_Boolean( p_commit ) THEN
1025: COMMIT WORK;
1026: END IF;
1027:
1028: -- Standard call to get message count and if count is 1, get message info.
1029: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1030:
1031: /*IF (l_debug = 'Y') THEN
1032: okc_debug.log('900: Leaving revert_to_standard', 2);

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

1028: -- Standard call to get message count and if count is 1, get message info.
1029: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1030:
1031: /*IF (l_debug = 'Y') THEN
1032: okc_debug.log('900: Leaving revert_to_standard', 2);
1033: END IF;*/
1034:
1035: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1036: FND_LOG.STRING(G_PROC_LEVEL,

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

1033: END IF;*/
1034:
1035: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1036: FND_LOG.STRING(G_PROC_LEVEL,
1037: G_PKG_NAME, '900: Leaving revert_to_standard' );
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN

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

1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: /*IF (l_debug = 'Y') THEN
1043: okc_debug.log('300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1044: END IF;*/
1045:
1046: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1047: FND_LOG.STRING(G_EXCP_LEVEL,

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

1044: END IF;*/
1045:
1046: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1047: FND_LOG.STRING(G_EXCP_LEVEL,
1048: G_PKG_NAME, '300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception' );
1049: END IF;
1050:
1051: IF l_get_kart_dtl_csr%ISOPEN THEN
1052: CLOSE l_get_kart_dtl_csr;

Line 1056: ROLLBACK TO g_revert_to_standard_GRP;

1052: CLOSE l_get_kart_dtl_csr;
1053: END IF;
1054:
1055:
1056: ROLLBACK TO g_revert_to_standard_GRP;
1057: x_return_status := G_RET_STS_ERROR ;
1058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1059:
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1059:
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: /*IF (l_debug = 'Y') THEN
1062: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1063: END IF;*/
1064:
1065: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1066: FND_LOG.STRING(G_EXCP_LEVEL,

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

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

Line 1075: ROLLBACK TO g_revert_to_standard_GRP;

1071: CLOSE l_get_kart_dtl_csr;
1072: END IF;
1073:
1074:
1075: ROLLBACK TO g_revert_to_standard_GRP;
1076: x_return_status := G_RET_STS_UNEXP_ERROR ;
1077: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1078:
1079: WHEN OTHERS THEN

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

1077: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1078:
1079: WHEN OTHERS THEN
1080: /*IF (l_debug = 'Y') THEN
1081: okc_debug.log('500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm, 2);
1082: END IF;*/
1083:
1084: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1085: FND_LOG.STRING(G_EXCP_LEVEL,

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

1082: END IF;*/
1083:
1084: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1085: FND_LOG.STRING(G_EXCP_LEVEL,
1086: G_PKG_NAME, '500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm );
1087: END IF;
1088:
1089: IF l_get_kart_dtl_csr%ISOPEN THEN
1090: CLOSE l_get_kart_dtl_csr;

Line 1094: ROLLBACK TO g_revert_to_standard_GRP;

1090: CLOSE l_get_kart_dtl_csr;
1091: END IF;
1092:
1093:
1094: ROLLBACK TO g_revert_to_standard_GRP;
1095: x_return_status := G_RET_STS_UNEXP_ERROR ;
1096: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1097: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1098: END IF;

Line 1101: END revert_to_standard;

1097: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1098: END IF;
1099:
1100: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1101: END revert_to_standard;
1102:
1103: END OKC_K_NON_STD_ART_GRP;