52: EXCEPTION
53: WHEN FND_API.G_EXC_ERROR THEN
54:
55: IF (l_debug = 'Y') THEN
56: okc_debug.log('2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception', 2);
57: END IF;
58:
59: x_return_status := G_RET_STS_ERROR ;
60: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
60: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: IF (l_debug = 'Y') THEN
64: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
65: END IF;
66:
67: x_return_status := G_RET_STS_UNEXP_ERROR ;
68: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
67: x_return_status := G_RET_STS_UNEXP_ERROR ;
68: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
69: WHEN OTHERS THEN
70: IF (l_debug = 'Y') THEN
71: okc_debug.log('2600: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm, 2);
72: END IF;
73:
74: x_return_status := G_RET_STS_UNEXP_ERROR ;
75:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110:
111: IF (l_debug = 'Y') THEN
112: okc_debug.log('2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
113: END IF;
114:
115: x_return_status := G_RET_STS_ERROR ;
116: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
116: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119: IF (l_debug = 'Y') THEN
120: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
121: END IF;
122:
123: x_return_status := G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
123: x_return_status := G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
125: WHEN OTHERS THEN
126: IF (l_debug = 'Y') THEN
127: okc_debug.log('2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm, 2);
128: END IF;
129:
130: x_return_status := G_RET_STS_UNEXP_ERROR ;
131:
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: IF (l_debug = 'Y') THEN
187: okc_debug.log('2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception', 2);
188: END IF;
189:
190: x_return_status := G_RET_STS_ERROR ;
191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
192: return FND_API.G_FALSE;
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: IF (l_debug = 'Y') THEN
196: okc_debug.log('2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
197: END IF;
198:
199: x_return_status := G_RET_STS_UNEXP_ERROR ;
200: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
200: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
201: return FND_API.G_FALSE;
202: WHEN OTHERS THEN
203: IF (l_debug = 'Y') THEN
204: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
205: END IF;
206:
207: x_return_status := G_RET_STS_UNEXP_ERROR ;
208: