77: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'30:Leaving OKC_OM_INT_GRP.get_article_variable_values');
79: END IF;
80:
81: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
82:
83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85:
87: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'40: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');
88: END IF;
89:
90: x_return_status := G_RET_STS_ERROR ;
91: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
94: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
95: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'50: Leaving get_article_variable_values: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');
95: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'50: Leaving get_article_variable_values: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');
96: END IF;
97:
98: x_return_status := G_RET_STS_UNEXP_ERROR ;
99: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
100: WHEN OTHERS THEN
101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
102: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'60: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm);
103: END IF;
103: END IF;
104:
105: x_return_status := G_RET_STS_UNEXP_ERROR ;
106:
107: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
108: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
109: END IF;
110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
111:
104:
105: x_return_status := G_RET_STS_UNEXP_ERROR ;
106:
107: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
108: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
109: END IF;
110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
111:
112: END;
106:
107: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
108: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
109: END IF;
110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
111:
112: END;
113:
114:
143: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'70: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception');
144: END IF;
145:
146: x_return_status := G_RET_STS_ERROR ;
147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
151: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'80: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
152: END IF;
153:
154: x_return_status := G_RET_STS_UNEXP_ERROR ;
155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
156: WHEN OTHERS THEN
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'90: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm);
159: END IF;
159: END IF;
160:
161: x_return_status := G_RET_STS_UNEXP_ERROR ;
162:
163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
165: END IF;
166: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
167:
160:
161: x_return_status := G_RET_STS_UNEXP_ERROR ;
162:
163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
165: END IF;
166: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
167:
168: END ok_to_commit;
162:
163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
165: END IF;
166: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
167:
168: END ok_to_commit;
169:
170: Procedure get_item_dtl_for_expert(
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,' ');
257: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'140:Leaving OKC_OM_INT_GRP.get_item_dtl_for_expert');
258: END IF;
259: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263:
265: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'150: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception');
266: END IF;
267:
268: x_return_status := G_RET_STS_ERROR ;
269: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
273: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'160: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');
273: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'160: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPT ION_UNEXPECTED_ERROR Exception');
274: END IF;
275:
276: x_return_status := G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
278: WHEN OTHERS THEN
279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: fnd_log.string(FND_LOG.LEVEL_STATEMENT,l_module,'170: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm);
281: END IF;
281: END IF;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;
284:
285: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
287: END IF;
288: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
289: END get_item_dtl_for_expert;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;
284:
285: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
287: END IF;
288: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
289: END get_item_dtl_for_expert;
290:
284:
285: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
287: END IF;
288: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
289: END get_item_dtl_for_expert;
290:
291: END OKC_OM_INT_GRP;