DBA Data[Home] [Help]

APPS.OKC_K_ART_VARIABLES_GRP dependencies on OKC_API

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

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

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

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

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

175:
176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: IF (l_debug = 'Y') THEN
179: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
180: END IF;
181:
182: IF l_get_art_var_csr%ISOPEN THEN
183: CLOSE l_get_art_var_csr;

Line 192: okc_debug.log('400: Leavingupdate_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

188: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: IF (l_debug = 'Y') THEN
192: okc_debug.log('400: Leavingupdate_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
193: END IF;
194:
195: IF l_get_art_var_csr%ISOPEN THEN
196: CLOSE l_get_art_var_csr;

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

369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: IF (l_debug = 'Y') THEN
373: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
374: END IF;
375:
376: IF l_get_cat_id_csr%ISOPEN THEN
377: CLOSE l_get_cat_id_csr;

Line 386: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

382: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: IF (l_debug = 'Y') THEN
386: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
387: );
388: END IF;
389:
390: IF l_get_cat_id_csr%ISOPEN THEN

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

556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: IF (l_debug = 'Y') THEN
560: okc_debug.log('300: Leaving update_article_var_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
561: END IF;
562:
563: ROLLBACK TO g_upd_article_var_values_GRP;
564: x_return_status := G_RET_STS_ERROR ;

Line 569: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2

565: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: IF (l_debug = 'Y') THEN
569: okc_debug.log('400: Leaving update_article_var_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2
570: );
571: END IF;
572:
573: