eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_PROD_RELATION_PVT dependencies on FND_MSG_PUB

Line 41: FND_MSG_PUB.initialize;

37: END IF;
38:
39: -- Initialize message list if p_init_msg_list is set to TRUE.
40: IF FND_API.to_Boolean( p_init_msg_list ) THEN
41: FND_MSG_PUB.initialize;
42: END IF;
43:
44: -- Initialize API return status to success
45: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 95: FND_MSG_PUB.Add;

91: IF (l_debug = 'Y') THEN
92: IBE_UTIL.debug('Insert statement failed.');
93: END IF;
94: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');
95: FND_MSG_PUB.Add;
96: RAISE FND_API.G_EXC_ERROR;
97: WHEN OTHERS THEN
98: IF (l_debug = 'Y') THEN
99: IBE_UTIL.debug('Insert statement failed.');

Line 105: FND_MSG_PUB.Add;

101: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
102: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
103: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;
106:
107: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');
108: FND_MSG_PUB.Add;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 108: FND_MSG_PUB.Add;

104: FND_MESSAGE.Set_Token('REASON', SQLERRM);
105: FND_MSG_PUB.Add;
106:
107: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_CREATED');
108: FND_MSG_PUB.Add;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END;
111:
112: -- End of API body.

Line 123: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

119: COMMIT WORK;
120: END IF;
121:
122: -- Standard call to get message count and if count is 1, get message info.
123: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
124: p_count => x_msg_count ,
125: p_data => x_msg_data );
126:
127: EXCEPTION

Line 131: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: ROLLBACK TO Insert_Relationship_PVT;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
132: p_count => x_msg_count ,
133: p_data => x_msg_data );
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 138: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: ROLLBACK TO Insert_Relationship_PVT;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count ,
140: p_data => x_msg_data );
141:
142: WHEN OTHERS THEN

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

142: WHEN OTHERS THEN
143: ROLLBACK TO Insert_Relationship_PVT;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145:
146: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
148: L_API_NAME );
149: END IF;
150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

143: ROLLBACK TO Insert_Relationship_PVT;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145:
146: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
148: L_API_NAME );
149: END IF;
150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count ,

Line 150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

146: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
147: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
148: L_API_NAME );
149: END IF;
150: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count ,
152: p_data => x_msg_data );
153: END Insert_Relationship;
154:

Line 192: FND_MSG_PUB.initialize;

188: END IF;
189:
190: -- Initialize message list if p_init_msg_list is set to TRUE.
191: IF FND_API.to_Boolean( p_init_msg_list ) THEN
192: FND_MSG_PUB.initialize;
193: END IF;
194:
195: -- Initialize API return status to success
196: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 241: FND_MSG_PUB.Add;

237: IF (l_debug = 'Y') THEN
238: IBE_UTIL.debug('Update statement failed.');
239: END IF;
240: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_ERROR;
243: WHEN OTHERS THEN
244: IF (l_debug = 'Y') THEN
245: IBE_UTIL.debug('Update statement failed.');

Line 251: FND_MSG_PUB.Add;

247: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
248: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
249: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;
252:
253: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
254: FND_MSG_PUB.Add;
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 254: FND_MSG_PUB.Add;

250: FND_MESSAGE.Set_Token('REASON', SQLERRM);
251: FND_MSG_PUB.Add;
252:
253: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
254: FND_MSG_PUB.Add;
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256: END;
257:
258: -- End of API body.

Line 269: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

265: COMMIT WORK;
266: END IF;
267:
268: -- Standard call to get message count and if count is 1, get message info.
269: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count ,
271: p_data => x_msg_data );
272: EXCEPTION
273: WHEN FND_API.G_EXC_ERROR THEN

Line 276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

272: EXCEPTION
273: WHEN FND_API.G_EXC_ERROR THEN
274: ROLLBACK TO Update_Relationship_PVT;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count ,
278: p_data => x_msg_data );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO Update_Relationship_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count ,
285: p_data => x_msg_data );
286:
287: WHEN OTHERS THEN

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

287: WHEN OTHERS THEN
288: ROLLBACK TO Update_Relationship_PVT;
289: x_return_status := FND_API.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,
293: L_API_NAME );
294: END IF;
295:

Line 292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

288: ROLLBACK TO Update_Relationship_PVT;
289: x_return_status := FND_API.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,
293: L_API_NAME );
294: END IF;
295:
296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
293: L_API_NAME );
294: END IF;
295:
296: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
297: p_count => x_msg_count ,
298: p_data => x_msg_data );
299: END Update_Relationship;
300:

Line 339: FND_MSG_PUB.initialize;

335: END IF;
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.
338: IF FND_API.to_Boolean( p_init_msg_list ) THEN
339: FND_MSG_PUB.initialize;
340: END IF;
341:
342: -- Initialize API return status to success
343: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 388: FND_MSG_PUB.Add;

384: IF (l_debug = 'Y') THEN
385: IBE_UTIL.debug('Update statement failed.');
386: END IF;
387: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
388: FND_MSG_PUB.Add;
389: RAISE FND_API.G_EXC_ERROR;
390: WHEN OTHERS THEN
391: IF (l_debug = 'Y') THEN
392: IBE_UTIL.debug('Update statement failed.');

Line 398: FND_MSG_PUB.Add;

394: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
395: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
396: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;
399:
400: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 401: FND_MSG_PUB.Add;

397: FND_MESSAGE.Set_Token('REASON', SQLERRM);
398: FND_MSG_PUB.Add;
399:
400: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
401: FND_MSG_PUB.Add;
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END;
404:
405: -- End of API body.

Line 416: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

412: COMMIT WORK;
413: END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.
416: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
417: p_count => x_msg_count ,
418: p_data => x_msg_data );
419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN

Line 423: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO Update_Relationship_Detail_PVT;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
424: p_count => x_msg_count ,
425: p_data => x_msg_data );
426:
427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

426:
427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
428: ROLLBACK TO Update_Relationship_Detail_PVT;
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count ,
432: p_data => x_msg_data );
433:
434: WHEN OTHERS THEN

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

434: WHEN OTHERS THEN
435: ROLLBACK TO Update_Relationship_Detail_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437:
438: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
440: L_API_NAME );
441: END IF;
442:

Line 439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

435: ROLLBACK TO Update_Relationship_Detail_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437:
438: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
440: L_API_NAME );
441: END IF;
442:
443: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 443: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
440: L_API_NAME );
441: END IF;
442:
443: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count ,
445: p_data => x_msg_data );
446: END Update_Relationship_Detail;
447:

Line 481: FND_MSG_PUB.initialize;

477: END IF;
478:
479: -- Initialize message list if p_init_msg_list is set to TRUE.
480: IF FND_API.to_Boolean( p_init_msg_list ) THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:
484: -- Initialize API return status to success
485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 511: FND_MSG_PUB.Add;

507: IF (l_debug = 'Y') THEN
508: IBE_UTIL.debug('Delete statement failed.');
509: END IF;
510: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
511: FND_MSG_PUB.Add;
512: RAISE FND_API.G_EXC_ERROR;
513: WHEN OTHERS THEN
514: IF (l_debug = 'Y') THEN
515: IBE_UTIL.debug('Delete statement failed.');

Line 521: FND_MSG_PUB.Add;

517: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
518: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
519: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;
522:
523: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 524: FND_MSG_PUB.Add;

520: FND_MESSAGE.Set_Token('REASON', SQLERRM);
521: FND_MSG_PUB.Add;
522:
523: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_EXIST');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END;
527:
528: END LOOP;

Line 564: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

560: COMMIT WORK;
561: END IF;
562:
563: -- Standard call to get message count and if count is 1, get message info.
564: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
565: p_count => x_msg_count ,
566: p_data => x_msg_data );
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN

Line 571: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: ROLLBACK TO Delete_Relationship_PVT;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
572: p_count => x_msg_count ,
573: p_data => x_msg_data );
574:
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 578: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

574:
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: ROLLBACK TO Delete_Relationship_PVT;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count ,
580: p_data => x_msg_data );
581:
582: WHEN OTHERS THEN

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

582: WHEN OTHERS THEN
583: ROLLBACK TO Delete_Relationship_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585:
586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
588: L_API_NAME );
589: END IF;
590:

Line 587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

583: ROLLBACK TO Delete_Relationship_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585:
586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
588: L_API_NAME );
589: END IF;
590:
591: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 591: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
588: L_API_NAME );
589: END IF;
590:
591: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count ,
593: p_data => x_msg_data );
594: END Delete_Relationships;
595:

Line 631: FND_MSG_PUB.initialize;

627: END IF;
628:
629: -- Initialize message list if p_init_msg_list is set to TRUE.
630: IF FND_API.to_Boolean( p_init_msg_list ) THEN
631: FND_MSG_PUB.initialize;
632: END IF;
633:
634: -- Initialize API return status to success
635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

659: COMMIT WORK;
660: END IF;
661:
662: -- Standard call to get message count and if count is 1, get message info.
663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
664: p_count => x_msg_count ,
665: p_data => x_msg_data );
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN

Line 670: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: ROLLBACK TO Exclude_Related_Items_PVT;
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
671: p_count => x_msg_count ,
672: p_data => x_msg_data );
673:
674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 677: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

673:
674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
675: ROLLBACK TO Exclude_Related_Items_PVT;
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count ,
679: p_data => x_msg_data );
680:
681: WHEN OTHERS THEN

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

681: WHEN OTHERS THEN
682: ROLLBACK TO Exclude_Related_Items_PVT;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684:
685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
687: L_API_NAME );
688: END IF;
689:

Line 686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

682: ROLLBACK TO Exclude_Related_Items_PVT;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684:
685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
687: L_API_NAME );
688: END IF;
689:
690: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 690: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
687: L_API_NAME );
688: END IF;
689:
690: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count ,
692: p_data => x_msg_data );
693: END Exclude_Related_Items;
694:

Line 730: FND_MSG_PUB.initialize;

726: END IF;
727:
728: -- Initialize message list if p_init_msg_list is set to TRUE.
729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
730: FND_MSG_PUB.initialize;
731: END IF;
732:
733: -- Initialize API return status to success
734: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

754: COMMIT WORK;
755: END IF;
756:
757: -- Standard call to get message count and if count is 1, get message info.
758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count ,
760: p_data => x_msg_data );
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN

Line 765: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO Include_Related_Items_PVT;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count ,
767: p_data => x_msg_data );
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO Include_Related_Items_PVT;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
773: p_count => x_msg_count ,
774: p_data => x_msg_data );
775:
776: WHEN OTHERS THEN

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

776: WHEN OTHERS THEN
777: ROLLBACK TO Include_Related_Items_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779:
780: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
781: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
782: L_API_NAME );
783: END IF;
784:

Line 781: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

777: ROLLBACK TO Include_Related_Items_PVT;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779:
780: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
781: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
782: L_API_NAME );
783: END IF;
784:
785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

781: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
782: L_API_NAME );
783: END IF;
784:
785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
786: p_count => x_msg_count ,
787: p_data => x_msg_data );
788: END Include_Related_Items;
789: