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