DBA Data[Home] [Help]

APPS.OKC_PON_INT_GRP dependencies on FND_LOG

Line 28: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 29: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 30: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

Line 82: FND_LOG.STRING(G_EXCP_LEVEL,

78: okc_debug.log('2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
79: END IF;*/
80:
81: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
82: FND_LOG.STRING(G_EXCP_LEVEL,
83: G_PKG_NAME, '2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception' );
84: END IF;
85:
86: x_return_status := G_RET_STS_ERROR ;

Line 95: FND_LOG.STRING(G_EXCP_LEVEL,

91: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
92: END IF;*/
93:
94: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
95: FND_LOG.STRING(G_EXCP_LEVEL,
96: G_PKG_NAME, '2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
97: END IF;
98:
99: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 107: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 168: FND_LOG.STRING(G_EXCP_LEVEL,

164: okc_debug.log('2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception', 2);
165: END IF;*/
166:
167: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
168: FND_LOG.STRING(G_EXCP_LEVEL,
169: G_PKG_NAME, '2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception' );
170: END IF;
171:
172: x_return_status := G_RET_STS_ERROR ;

Line 181: FND_LOG.STRING(G_EXCP_LEVEL,

177: okc_debug.log('2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
178: END IF;*/
179:
180: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
181: FND_LOG.STRING(G_EXCP_LEVEL,
182: G_PKG_NAME, '2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
183: END IF;
184:
185: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 193: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 256: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 269: FND_LOG.STRING(G_EXCP_LEVEL,

265: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
266: END IF;*/
267:
268: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
269: FND_LOG.STRING(G_EXCP_LEVEL,
270: G_PKG_NAME, '2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
271: END IF;
272:
273: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 281: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 340: FND_LOG.STRING(G_EXCP_LEVEL,

336: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
337: END IF;*/
338:
339: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
340: FND_LOG.STRING(G_EXCP_LEVEL,
341: G_PKG_NAME, '2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception' );
342: END IF;
343:
344: x_return_status := G_RET_STS_ERROR ;

Line 354: FND_LOG.STRING(G_EXCP_LEVEL,

350: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
351: END IF;*/
352:
353: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
354: FND_LOG.STRING(G_EXCP_LEVEL,
355: G_PKG_NAME, '2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
356: END IF;
357:
358: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 367: FND_LOG.STRING(G_EXCP_LEVEL,

363: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
364: END IF;*/
365:
366: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
367: FND_LOG.STRING(G_EXCP_LEVEL,
368: G_PKG_NAME, '2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm );
369: END IF;
370:
371: x_return_status := G_RET_STS_UNEXP_ERROR ;