DBA Data[Home] [Help]

APPS.OKC_PO_INT_GRP dependencies on FND_MSG_PUB

Line 73: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 88: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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);

Line 101: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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;*/

Line 114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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:

Line 117: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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,

Line 157: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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);

Line 185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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;*/

Line 198: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 199: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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:

Line 201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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,

Line 250: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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);

Line 278: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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;*/

Line 291: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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:

Line 294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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,

Line 356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 376: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

Line 390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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);

Line 404: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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:

Line 407: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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;

Line 459: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 474: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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);

Line 487: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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;*/

Line 500: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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:

Line 503: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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;