DBA Data[Home] [Help]

APPS.OKC_K_ARTICLES_GRP dependencies on OKC_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ARTICLES_GRP';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ARTICLES_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

Line 284: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

280:
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: IF (l_debug = 'Y') THEN
284: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
285: END IF;
286:
287: IF l_article_var_csr%ISOPEN THEN
288: CLOSE l_article_var_csr;

Line 297: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

293: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF (l_debug = 'Y') THEN
297: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
298: END IF;
299:
300: IF l_article_var_csr%ISOPEN THEN
301: CLOSE l_article_var_csr;

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

456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: IF (l_debug = 'Y') THEN
460: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
461: END IF;
462: ROLLBACK TO g_validate_row_GRP;
463: x_return_status := G_RET_STS_ERROR ;
464: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

464: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: IF (l_debug = 'Y') THEN
468: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
469: END IF;
470: ROLLBACK TO g_validate_row_GRP;
471: x_return_status := G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 547: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);

543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: IF (l_debug = 'Y') THEN
547: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
548: END IF;
549: ROLLBACK TO g_lock_row_GRP;
550: x_return_status := G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 555: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

551: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: IF (l_debug = 'Y') THEN
555: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
556: END IF;
557: ROLLBACK TO g_lock_row_GRP;
558: x_return_status := G_RET_STS_UNEXP_ERROR ;
559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 935: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: IF (l_debug = 'Y') THEN
935: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
936: END IF;
937:
938: IF l_document_id_csr%ISOPEN THEN
939: CLOSE l_document_id_csr;

Line 964: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

960: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
961:
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
963: IF (l_debug = 'Y') THEN
964: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
965: END IF;
966:
967: IF l_document_id_csr%ISOPEN THEN
968: CLOSE l_document_id_csr;

Line 1101: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1097: CLOSE l_document_id_csr;
1098:
1099: IF l_mandatory_yn='Y' and l_document_type<>'TEMPLATE' and p_super_user_yn='N' and p_mandatory_clause_delete='N' THEN
1100:
1101: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1102: p_msg_name => 'OKC_DEL_MAND_ARTICLE');
1103:
1104: raise FND_API.G_EXC_ERROR;
1105:

Line 1111: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1107:
1108: -- if user does NOT have non-std access, don't allow delete of non-std articles
1109: IF (NOT fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N')) AND
1110: l_standard_yn ='N' THEN
1111: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1112: p_msg_name => 'OKC_DEL_NON_STD_ARTICLE');
1113:
1114: raise FND_API.G_EXC_ERROR;
1115: END IF;

Line 1225: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: IF (l_debug = 'Y') THEN
1225: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1226: END IF;
1227:
1228: IF l_document_id_csr%ISOPEN THEN
1229: CLOSE l_document_id_csr;

Line 1239: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: IF (l_debug = 'Y') THEN
1239: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1240: END IF;
1241:
1242: IF l_document_id_csr%ISOPEN THEN
1243: CLOSE l_document_id_csr;