DBA Data[Home] [Help]

APPS.OKC_ALLOWED_TMPL_USAGES_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_ALLOWED_TMPL_USAGES_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_ALLOWED_TMPL_USAGES_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

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

133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: IF (l_debug = 'Y') THEN
137: okc_debug.log('300: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
138: END IF;
139: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
140: x_return_status := G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: IF (l_debug = 'Y') THEN
145: okc_debug.log('400: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
146: END IF;
147: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
148: x_return_status := G_RET_STS_UNEXP_ERROR ;
149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_ERROR THEN
280: IF (l_debug = 'Y') THEN
281: okc_debug.log('800: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
282: END IF;
283: ROLLBACK TO g_Create_Allowed_Usages_GRP;
284: x_return_status := G_RET_STS_ERROR ;
285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
286:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: IF (l_debug = 'Y') THEN
289: okc_debug.log('900: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
290: END IF;
291: ROLLBACK TO g_Create_Allowed_Usages_GRP;
292: x_return_status := G_RET_STS_UNEXP_ERROR ;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: IF (l_debug = 'Y') THEN
369: okc_debug.log('1300: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
370: END IF;
371: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
372: x_return_status := G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: IF (l_debug = 'Y') THEN
377: okc_debug.log('1400: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
378: END IF;
379: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
380: x_return_status := G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: IF (l_debug = 'Y') THEN
508: okc_debug.log('1900: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
509: END IF;
510: ROLLBACK TO g_Update_Allowed_Usages_GRP;
511: x_return_status := G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: IF (l_debug = 'Y') THEN
516: okc_debug.log('2000: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
517: END IF;
518: ROLLBACK TO g_Update_Allowed_Usages_GRP;
519: x_return_status := G_RET_STS_UNEXP_ERROR ;
520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: IF (l_debug = 'Y') THEN
602: okc_debug.log('2400: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
603: END IF;
604: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
605: x_return_status := G_RET_STS_ERROR ;
606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: IF (l_debug = 'Y') THEN
610: okc_debug.log('2500: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
611: END IF;
612: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
613: x_return_status := G_RET_STS_UNEXP_ERROR ;
614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );