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 315: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: IF (l_debug = 'Y') THEN
315: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
316: END IF;
317:
318: IF l_article_var_csr%ISOPEN THEN
319: CLOSE l_article_var_csr;

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

324: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: IF (l_debug = 'Y') THEN
328: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
329: END IF;
330:
331: IF l_article_var_csr%ISOPEN THEN
332: CLOSE l_article_var_csr;

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

489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: IF (l_debug = 'Y') THEN
493: okc_debug.log('300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
494: END IF;
495: ROLLBACK TO g_validate_row_GRP;
496: x_return_status := G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: IF (l_debug = 'Y') THEN
501: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
502: END IF;
503: ROLLBACK TO g_validate_row_GRP;
504: x_return_status := G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: IF (l_debug = 'Y') THEN
580: okc_debug.log('1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
581: END IF;
582: ROLLBACK TO g_lock_row_GRP;
583: x_return_status := G_RET_STS_ERROR ;
584: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

584: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: IF (l_debug = 'Y') THEN
588: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
589: END IF;
590: ROLLBACK TO g_lock_row_GRP;
591: x_return_status := G_RET_STS_UNEXP_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1037:
1038: EXCEPTION
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: IF (l_debug = 'Y') THEN
1041: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1042: END IF;
1043:
1044: IF l_document_id_csr%ISOPEN THEN
1045: CLOSE l_document_id_csr;

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

1066: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (l_debug = 'Y') THEN
1070: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1071: END IF;
1072:
1073: IF l_document_id_csr%ISOPEN THEN
1074: CLOSE l_document_id_csr;

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

1205: CLOSE l_document_id_csr;
1206:
1207: IF l_mandatory_yn='Y' and l_document_type<>'TEMPLATE' and p_super_user_yn='N' and p_mandatory_clause_delete='N' THEN
1208:
1209: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1210: p_msg_name => 'OKC_DEL_MAND_ARTICLE');
1211:
1212: raise FND_API.G_EXC_ERROR;
1213:

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

1215:
1216: -- if user does NOT have non-std access, don't allow delete of non-std articles
1217: IF (NOT fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N')) AND
1218: l_standard_yn ='N' THEN
1219: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1220: p_msg_name => 'OKC_DEL_NON_STD_ARTICLE');
1221:
1222: raise FND_API.G_EXC_ERROR;
1223: END IF;

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

1383:
1384: EXCEPTION
1385: WHEN FND_API.G_EXC_ERROR THEN
1386: IF (l_debug = 'Y') THEN
1387: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1388: END IF;
1389:
1390: IF l_document_id_csr%ISOPEN THEN
1391: CLOSE l_document_id_csr;

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

1397: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1398:
1399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1400: IF (l_debug = 'Y') THEN
1401: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1402: END IF;
1403:
1404: IF l_document_id_csr%ISOPEN THEN
1405: CLOSE l_document_id_csr;