DBA Data[Home] [Help]

APPS.OKC_PO_INT_GRP dependencies on FND_MSG_PUB

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

71: --------------------------------------------
72: IF l_debug='Y' THEN
73: okc_util.print_trace(1,' Leaving PO_CONTERMS_UTL_GRP.Get_PO_Attribute_values');
74: END IF;
75: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
76:
77: EXCEPTION
78: WHEN FND_API.G_EXC_ERROR THEN
79:

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

86: G_PKG_NAME, '2400: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_ERROR Exception' );
87: END IF;
88:
89: x_return_status := G_RET_STS_ERROR ;
90: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
91:
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: /*IF (l_debug = 'Y') THEN
94: okc_debug.log('2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

99: G_PKG_NAME, '2500: Leaving get_article_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
100: END IF;
101:
102: x_return_status := G_RET_STS_UNEXP_ERROR ;
103: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
104: WHEN OTHERS THEN
105: /*IF (l_debug = 'Y') THEN
106: okc_debug.log('2600: Leaving get_article_variable_values because of EXCEPTION: '||sqlerrm, 2);
107: END IF;*/

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

112: END IF;
113:
114: x_return_status := G_RET_STS_UNEXP_ERROR ;
115:
116: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
117: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
118: END IF;
119: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
120: END;

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

113:
114: x_return_status := G_RET_STS_UNEXP_ERROR ;
115:
116: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
117: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
118: END IF;
119: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
120: END;
121:

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

115:
116: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
117: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
118: END IF;
119: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
120: END;
121:
122: Procedure get_changed_variables(
123: p_api_version IN Number,

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

157: --------------------------------------------
158: IF l_debug='Y' THEN
159: okc_util.print_trace(1,' Leaving PO_CONTERMS_UTL_GRP.attribute_value_changed');
160: END IF;
161: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_ERROR THEN
165:

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

172: G_PKG_NAME, '2400: Leaving get_changed_variables: OKC_API.G_EXCEPTION_ERROR Exception' );
173: END IF;
174:
175: x_return_status := G_RET_STS_ERROR ;
176: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: /*IF (l_debug = 'Y') THEN
180: okc_debug.log('2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

185: G_PKG_NAME, '2500: Leaving get_changed_variables: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
186: END IF;
187:
188: x_return_status := G_RET_STS_UNEXP_ERROR ;
189: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
190: WHEN OTHERS THEN
191: /*IF (l_debug = 'Y') THEN
192: okc_debug.log('2600: Leaving get_changed_variables because of EXCEPTION: '||sqlerrm, 2);
193: END IF;*/

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

198: END IF;
199:
200: x_return_status := G_RET_STS_UNEXP_ERROR ;
201:
202: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
204: END IF;
205: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
206: END;

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

199:
200: x_return_status := G_RET_STS_UNEXP_ERROR ;
201:
202: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
204: END IF;
205: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
206: END;
207:

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

201:
202: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
204: END IF;
205: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
206: END;
207:
208: Procedure get_item_dtl_for_expert(
209: p_api_version IN Number,

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

252:
253: IF l_debug='Y' THEN
254: okc_util.print_trace(1,' Leaving OKC_PO_INT_GRP.get_item_dtl_for_expert');
255: END IF;
256: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260:

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

267: G_PKG_NAME, '2400: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_ERROR Exception' );
268: END IF;
269:
270: x_return_status := G_RET_STS_ERROR ;
271: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
272:
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: /*IF (l_debug = 'Y') THEN
275: okc_debug.log('2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

280: G_PKG_NAME, '2500: Leaving get_item_dtl_for_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
281: END IF;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;
284: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
285: WHEN OTHERS THEN
286: /*IF (l_debug = 'Y') THEN
287: okc_debug.log('2600: Leaving get_item_dtl_for_expert because of EXCEPTION: '||sqlerrm, 2);
288: END IF;*/

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

293: END IF;
294:
295: x_return_status := G_RET_STS_UNEXP_ERROR ;
296:
297: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
299: END IF;
300: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
301: END get_item_dtl_for_expert;

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

294:
295: x_return_status := G_RET_STS_UNEXP_ERROR ;
296:
297: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
299: END IF;
300: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
301: END get_item_dtl_for_expert;
302:

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

296:
297: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
299: END IF;
300: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
301: END get_item_dtl_for_expert;
302:
303: Function ok_to_commit (
304: p_api_version IN Number,

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

415: END IF;
416: --------------------------------------------
417: END IF;
418:
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
420:
421: IF l_update_allowed='Y' THEN
422: return FND_API.G_TRUE;
423: ELSE

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

435: G_PKG_NAME, '2400: Leaving ok_to_commit: OKC_API.G_EXCEPTION_ERROR Exception' );
436: END IF;
437:
438: x_return_status := G_RET_STS_ERROR ;
439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
440: return FND_API.G_FALSE;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: /*IF (l_debug = 'Y') THEN

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

449: G_PKG_NAME, '2500: Leaving ok_to_commit: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
450: END IF;
451:
452: x_return_status := G_RET_STS_UNEXP_ERROR ;
453: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
454: return FND_API.G_FALSE;
455: WHEN OTHERS THEN
456: /*IF (l_debug = 'Y') THEN
457: okc_debug.log('2600: Leaving ok_to_commit because of EXCEPTION: '||sqlerrm, 2);

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

463: END IF;
464:
465: x_return_status := G_RET_STS_UNEXP_ERROR ;
466:
467: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
469: END IF;
470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
471: return FND_API.G_FALSE;

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

464:
465: x_return_status := G_RET_STS_UNEXP_ERROR ;
466:
467: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
469: END IF;
470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
471: return FND_API.G_FALSE;
472:

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

466:
467: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
469: END IF;
470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
471: return FND_API.G_FALSE;
472:
473:
474: END ok_to_commit;

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

520:
521: IF l_debug='Y' THEN
522: okc_util.print_trace(1,' Leaving OKC_PO_INT_GRP.Get_Last_Signed_Revision');
523: END IF;
524: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
525:
526: EXCEPTION
527: WHEN FND_API.G_EXC_ERROR THEN
528:

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

535: G_PKG_NAME, '2400: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_ERROR Exception' );
536: END IF;
537:
538: x_return_status := G_RET_STS_ERROR ;
539: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: /*IF (l_debug = 'Y') THEN
543: okc_debug.log('2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

548: G_PKG_NAME, '2500: Leaving Get_Last_Signed_Revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
549: END IF;
550:
551: x_return_status := G_RET_STS_UNEXP_ERROR ;
552: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
553: WHEN OTHERS THEN
554: /*IF (l_debug = 'Y') THEN
555: okc_debug.log('2600: Leaving Get_Last_Signed_Revision because of EXCEPTION: '||sqlerrm, 2);
556: END IF;*/

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

561: END IF;
562:
563: x_return_status := G_RET_STS_UNEXP_ERROR ;
564:
565: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
566: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
569: END Get_Last_Signed_Revision;

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

562:
563: x_return_status := G_RET_STS_UNEXP_ERROR ;
564:
565: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
566: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
569: END Get_Last_Signed_Revision;
570:

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

564:
565: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
566: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
569: END Get_Last_Signed_Revision;
570:
571: END OKC_PO_INT_GRP;