DBA Data[Home] [Help]

APPS.OKC_PO_INT_GRP dependencies on FND_LOG

Line 31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

27: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
28: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
29: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
30:
31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35:

Line 32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

28: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
29: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
30:
31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35:
36: Procedure get_article_variable_values(

Line 33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

29: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
30:
31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35:
36: Procedure get_article_variable_values(
37: p_api_version IN Number,

Line 85: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 98: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 110: FND_LOG.STRING(G_EXCP_LEVEL,

106: okc_debug.log('2600: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm, 2);
107: END IF;*/
108:
109: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
110: FND_LOG.STRING(G_EXCP_LEVEL,
111: G_PKG_NAME, '2600: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm );
112: END IF;
113:
114: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 171: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 184: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 196: FND_LOG.STRING(G_EXCP_LEVEL,

192: okc_debug.log('2600: Leaving get_changed_variables because of EXCEPTION: '||sqlerrm, 2);
193: END IF;*/
194:
195: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
196: FND_LOG.STRING(G_EXCP_LEVEL,
197: G_PKG_NAME, '2600: Leaving get_changed_variables because of EXCEPTION: '||sqlerrm );
198: END IF;
199:
200: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 266: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 279: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 291: FND_LOG.STRING(G_EXCP_LEVEL,

287: okc_debug.log('2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm, 2);
288: END IF;*/
289:
290: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
291: FND_LOG.STRING(G_EXCP_LEVEL,
292: G_PKG_NAME, '2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm );
293: END IF;
294:
295: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 434: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 448: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 461: FND_LOG.STRING(G_EXCP_LEVEL,

457: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
458: END IF;*/
459:
460: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
461: FND_LOG.STRING(G_EXCP_LEVEL,
462: G_PKG_NAME, '2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm );
463: END IF;
464:
465: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 534: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 547: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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 ;

Line 559: FND_LOG.STRING(G_EXCP_LEVEL,

555: okc_debug.log('2600: Leaving Get_Last_Signed_Revision because of EXCEPTION: '||sqlerrm, 2);
556: END IF;*/
557:
558: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
559: FND_LOG.STRING(G_EXCP_LEVEL,
560: G_PKG_NAME, '2600: Leaving Get_Last_Signed_Revision because of EXCEPTION: '||sqlerrm );
561: END IF;
562:
563: x_return_status := G_RET_STS_UNEXP_ERROR ;