69: --------------------------------------------
70: IF l_debug='Y' THEN
71: okc_util.print_trace(1,' Leaving PO_CONTERMS_UTL_GRP.Get_PO_Attribute_values');
72: END IF;
73: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
74:
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN
77:
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 ;
88: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: /*IF (l_debug = 'Y') THEN
92: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
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 ;
101: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
102: WHEN OTHERS THEN
103: /*IF (l_debug = 'Y') THEN
104: okc_debug.log('2600: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm, 2);
105: END IF;*/
110: END IF;
111:
112: x_return_status := G_RET_STS_UNEXP_ERROR ;
113:
114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
116: END IF;
117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
118: END;
111:
112: x_return_status := G_RET_STS_UNEXP_ERROR ;
113:
114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
116: END IF;
117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
118: END;
119:
113:
114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
116: END IF;
117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
118: END;
119:
120: Procedure get_changed_variables(
121: p_api_version IN Number,
153: --------------------------------------------
154: IF l_debug='Y' THEN
155: okc_util.print_trace(1,' Leaving PO_CONTERMS_UTL_GRP.attribute_value_changed');
156: END IF;
157: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
158:
159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161:
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 ;
172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: /*IF (l_debug = 'Y') THEN
176: okc_debug.log('2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
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 ;
185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
186: WHEN OTHERS THEN
187: /*IF (l_debug = 'Y') THEN
188: okc_debug.log('2600: Leaving get_changed_variables because of EXCEPTION: '||sqlerrm, 2);
189: END IF;*/
194: END IF;
195:
196: x_return_status := G_RET_STS_UNEXP_ERROR ;
197:
198: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
199: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
200: END IF;
201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
202: END;
195:
196: x_return_status := G_RET_STS_UNEXP_ERROR ;
197:
198: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
199: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
200: END IF;
201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
202: END;
203:
197:
198: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
199: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
200: END IF;
201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
202: END;
203:
204: Procedure get_item_dtl_for_expert(
205: p_api_version IN Number,
246:
247: IF l_debug='Y' THEN
248: okc_util.print_trace(1,' Leaving OKC_PO_INT_GRP.get_item_dtl_for_expert');
249: END IF;
250: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
251:
252: EXCEPTION
253: WHEN FND_API.G_EXC_ERROR THEN
254:
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 ;
265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: /*IF (l_debug = 'Y') THEN
269: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
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 ;
278: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
279: WHEN OTHERS THEN
280: /*IF (l_debug = 'Y') THEN
281: okc_debug.log('2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm, 2);
282: END IF;*/
287: END IF;
288:
289: x_return_status := G_RET_STS_UNEXP_ERROR ;
290:
291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
293: END IF;
294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
295: END get_item_dtl_for_expert;
288:
289: x_return_status := G_RET_STS_UNEXP_ERROR ;
290:
291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
293: END IF;
294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
295: END get_item_dtl_for_expert;
296:
290:
291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
293: END IF;
294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
295: END get_item_dtl_for_expert;
296:
297: Function ok_to_commit (
298: p_api_version IN Number,
352: END IF;
353: --------------------------------------------
354: END IF;
355:
356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
357:
358: IF l_update_allowed='Y' THEN
359: return FND_API.G_TRUE;
360: ELSE
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 ;
376: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
377: return FND_API.G_FALSE;
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: /*IF (l_debug = 'Y') THEN
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 ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391: return FND_API.G_FALSE;
392: WHEN OTHERS THEN
393: /*IF (l_debug = 'Y') THEN
394: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);
400: END IF;
401:
402: x_return_status := G_RET_STS_UNEXP_ERROR ;
403:
404: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
408: return FND_API.G_FALSE;
401:
402: x_return_status := G_RET_STS_UNEXP_ERROR ;
403:
404: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
408: return FND_API.G_FALSE;
409:
403:
404: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
408: return FND_API.G_FALSE;
409:
410:
411: END ok_to_commit;
455:
456: IF l_debug='Y' THEN
457: okc_util.print_trace(1,' Leaving OKC_PO_INT_GRP.Get_Last_Signed_Revision');
458: END IF;
459: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463:
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 ;
474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
475:
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: /*IF (l_debug = 'Y') THEN
478: okc_debug.log('2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
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 ;
487: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
488: WHEN OTHERS THEN
489: /*IF (l_debug = 'Y') THEN
490: okc_debug.log('2600: Leaving Get_Last_Signed_Revision because of EXCEPTION: '||sqlerrm, 2);
491: END IF;*/
496: END IF;
497:
498: x_return_status := G_RET_STS_UNEXP_ERROR ;
499:
500: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
502: END IF;
503: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
504: END Get_Last_Signed_Revision;
497:
498: x_return_status := G_RET_STS_UNEXP_ERROR ;
499:
500: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
502: END IF;
503: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
504: END Get_Last_Signed_Revision;
505:
499:
500: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
502: END IF;
503: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
504: END Get_Last_Signed_Revision;
505:
506: END OKC_PO_INT_GRP;