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 81: okc_debug.log('2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260:
261: /*IF (l_debug = 'Y') THEN
262: okc_debug.log('2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
263: END IF;*/
264:
265: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
266: FND_LOG.STRING(G_EXCP_LEVEL,

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

263: END IF;*/
264:
265: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
266: FND_LOG.STRING(G_EXCP_LEVEL,
267: G_PKG_NAME, '2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception' );
268: END IF;
269:
270: x_return_status := G_RET_STS_ERROR ;
271: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

271: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
272:
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: /*IF (l_debug = 'Y') THEN
275: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
276: END IF;*/
277:
278: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
279: FND_LOG.STRING(G_EXCP_LEVEL,

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

276: END IF;*/
277:
278: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
279: FND_LOG.STRING(G_EXCP_LEVEL,
280: G_PKG_NAME, '2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
281: END IF;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;
284: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

426:
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: /*IF (l_debug = 'Y') THEN
430: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
431: END IF;*/
432:
433: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
434: FND_LOG.STRING(G_EXCP_LEVEL,

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

431: END IF;*/
432:
433: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
434: FND_LOG.STRING(G_EXCP_LEVEL,
435: G_PKG_NAME, '2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception' );
436: END IF;
437:
438: x_return_status := G_RET_STS_ERROR ;
439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

440: return FND_API.G_FALSE;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: /*IF (l_debug = 'Y') THEN
444: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
445: END IF;*/
446:
447: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
448: FND_LOG.STRING(G_EXCP_LEVEL,

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

445: END IF;*/
446:
447: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
448: FND_LOG.STRING(G_EXCP_LEVEL,
449: G_PKG_NAME, '2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
450: END IF;
451:
452: x_return_status := G_RET_STS_UNEXP_ERROR ;
453: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

526: EXCEPTION
527: WHEN FND_API.G_EXC_ERROR THEN
528:
529: /*IF (l_debug = 'Y') THEN
530: okc_debug.log('2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception', 2);
531: END IF;*/
532:
533: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
534: FND_LOG.STRING(G_EXCP_LEVEL,

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

531: END IF;*/
532:
533: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
534: FND_LOG.STRING(G_EXCP_LEVEL,
535: G_PKG_NAME, '2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception' );
536: END IF;
537:
538: x_return_status := G_RET_STS_ERROR ;
539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: /*IF (l_debug = 'Y') THEN
543: okc_debug.log('2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
544: END IF;*/
545:
546: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
547: FND_LOG.STRING(G_EXCP_LEVEL,

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

544: END IF;*/
545:
546: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
547: FND_LOG.STRING(G_EXCP_LEVEL,
548: G_PKG_NAME, '2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
549: END IF;
550:
551: x_return_status := G_RET_STS_UNEXP_ERROR ;
552: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );