DBA Data[Home] [Help]

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

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

75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN
77:
78: /*IF (l_debug = 'Y') THEN
79: okc_debug.log('2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
80: END IF;*/
81:
82: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
83: FND_LOG.STRING(G_EXCP_LEVEL,

Line 84: G_PKG_NAME, '2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception' );

80: END IF;*/
81:
82: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
83: FND_LOG.STRING(G_EXCP_LEVEL,
84: G_PKG_NAME, '2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception' );
85: END IF;
86:
87: x_return_status := G_RET_STS_ERROR ;
88: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

88: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: /*IF (l_debug = 'Y') THEN
92: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
93: END IF;*/
94:
95: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
96: FND_LOG.STRING(G_EXCP_LEVEL,

Line 97: G_PKG_NAME, '2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

93: END IF;*/
94:
95: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
96: FND_LOG.STRING(G_EXCP_LEVEL,
97: G_PKG_NAME, '2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
98: END IF;
99:
100: x_return_status := G_RET_STS_UNEXP_ERROR ;
101: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161:
162: /*IF (l_debug = 'Y') THEN
163: okc_debug.log('2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception', 2);
164: END IF;*/
165:
166: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
167: FND_LOG.STRING(G_EXCP_LEVEL,

Line 168: G_PKG_NAME, '2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception' );

164: END IF;*/
165:
166: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
167: FND_LOG.STRING(G_EXCP_LEVEL,
168: G_PKG_NAME, '2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception' );
169: END IF;
170:
171: x_return_status := G_RET_STS_ERROR ;
172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: /*IF (l_debug = 'Y') THEN
176: okc_debug.log('2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
177: END IF;*/
178:
179: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
180: FND_LOG.STRING(G_EXCP_LEVEL,

Line 181: G_PKG_NAME, '2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

177: END IF;*/
178:
179: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
180: FND_LOG.STRING(G_EXCP_LEVEL,
181: G_PKG_NAME, '2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
182: END IF;
183:
184: x_return_status := G_RET_STS_UNEXP_ERROR ;
185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

252: EXCEPTION
253: WHEN FND_API.G_EXC_ERROR THEN
254:
255: /*IF (l_debug = 'Y') THEN
256: okc_debug.log('2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
257: END IF;*/
258:
259: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
260: FND_LOG.STRING(G_EXCP_LEVEL,

Line 261: G_PKG_NAME, '2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception' );

257: END IF;*/
258:
259: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
260: FND_LOG.STRING(G_EXCP_LEVEL,
261: G_PKG_NAME, '2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception' );
262: END IF;
263:
264: x_return_status := G_RET_STS_ERROR ;
265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: /*IF (l_debug = 'Y') THEN
269: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
270: END IF;*/
271:
272: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
273: FND_LOG.STRING(G_EXCP_LEVEL,

Line 274: G_PKG_NAME, '2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

270: END IF;*/
271:
272: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
273: FND_LOG.STRING(G_EXCP_LEVEL,
274: G_PKG_NAME, '2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
275: END IF;
276:
277: x_return_status := G_RET_STS_UNEXP_ERROR ;
278: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: /*IF (l_debug = 'Y') THEN
367: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
368: END IF;*/
369:
370: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
371: FND_LOG.STRING(G_EXCP_LEVEL,

Line 372: G_PKG_NAME, '2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception' );

368: END IF;*/
369:
370: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
371: FND_LOG.STRING(G_EXCP_LEVEL,
372: G_PKG_NAME, '2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception' );
373: END IF;
374:
375: x_return_status := G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

377: return FND_API.G_FALSE;
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: /*IF (l_debug = 'Y') THEN
381: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
382: END IF;*/
383:
384: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
385: FND_LOG.STRING(G_EXCP_LEVEL,

Line 386: G_PKG_NAME, '2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

382: END IF;*/
383:
384: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
385: FND_LOG.STRING(G_EXCP_LEVEL,
386: G_PKG_NAME, '2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
387: END IF;
388:
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463:
464: /*IF (l_debug = 'Y') THEN
465: okc_debug.log('2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception', 2);
466: END IF;*/
467:
468: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
469: FND_LOG.STRING(G_EXCP_LEVEL,

Line 470: G_PKG_NAME, '2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception' );

466: END IF;*/
467:
468: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
469: FND_LOG.STRING(G_EXCP_LEVEL,
470: G_PKG_NAME, '2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception' );
471: END IF;
472:
473: x_return_status := G_RET_STS_ERROR ;
474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
475:
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: /*IF (l_debug = 'Y') THEN
478: okc_debug.log('2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
479: END IF;*/
480:
481: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
482: FND_LOG.STRING(G_EXCP_LEVEL,

Line 483: G_PKG_NAME, '2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

479: END IF;*/
480:
481: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
482: FND_LOG.STRING(G_EXCP_LEVEL,
483: G_PKG_NAME, '2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
484: END IF;
485:
486: x_return_status := G_RET_STS_UNEXP_ERROR ;
487: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );