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 83: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 96: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 108: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 167: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 180: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 192: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 260: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 273: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 285: FND_LOG.STRING(G_EXCP_LEVEL,

281: okc_debug.log('2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm, 2);
282: END IF;*/
283:
284: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
285: FND_LOG.STRING(G_EXCP_LEVEL,
286: G_PKG_NAME, '2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm );
287: END IF;
288:
289: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 371: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 385: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 398: FND_LOG.STRING(G_EXCP_LEVEL,

394: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
395: END IF;*/
396:
397: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
398: FND_LOG.STRING(G_EXCP_LEVEL,
399: G_PKG_NAME, '2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm );
400: END IF;
401:
402: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 469: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 482: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 494: FND_LOG.STRING(G_EXCP_LEVEL,

490: okc_debug.log('2600: Leaving Get_Last_Signed_Revision because of EXCEPTION: '||sqlerrm, 2);
491: END IF;*/
492:
493: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
494: FND_LOG.STRING(G_EXCP_LEVEL,
495: G_PKG_NAME, '2600: Leaving Get_Last_Signed_Revision because of EXCEPTION: '||sqlerrm );
496: END IF;
497:
498: x_return_status := G_RET_STS_UNEXP_ERROR ;