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_DSP_HIERARCHY_QUERY_PVT dependencies on FND_MSG_PUB

Line 126: FND_MSG_PUB.initialize;

122: BEGIN
123:
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean(p_init_msg_list) THEN
126: FND_MSG_PUB.initialize;
127: END IF;
128:
129: -- Initialize API return status to success
130: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

160: EXCEPTION
161:
162: WHEN FND_API.G_EXC_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
165: p_data => x_msg_data,
166: p_encoded => 'F');
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

166: p_encoded => 'F');
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => 'F');
173:
174: WHEN OTHERS THEN

Line 179: FND_MSG_PUB.Add;

175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180:
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

179: FND_MSG_PUB.Add;
180:
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
186: END IF;
187:

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

181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
186: END IF;
187:
188: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
189: p_data => x_msg_data,

Line 188: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

184: THEN
185: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
186: END IF;
187:
188: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
189: p_data => x_msg_data,
190: p_encoded => 'F');
191:
192: END Load_SectionItems_For_Section;

Line 220: FND_MSG_PUB.initialize;

216: BEGIN
217:
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219: IF FND_API.to_Boolean(p_init_msg_list) THEN
220: FND_MSG_PUB.initialize;
221: END IF;
222:
223: -- Initialize API return status to success
224: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 239: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

235: EXCEPTION
236:
237: WHEN FND_API.G_EXC_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
240: p_data => x_msg_data,
241: p_encoded => 'F');
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

241: p_encoded => 'F');
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
246: p_data => x_msg_data,
247: p_encoded => 'F');
248:
249: WHEN OTHERS THEN

Line 254: FND_MSG_PUB.Add;

250: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
251: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
253: FND_MESSAGE.Set_Token('REASON', SQLERRM);
254: FND_MSG_PUB.Add;
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

254: FND_MSG_PUB.Add;
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
259: THEN
260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
261: END IF;
262:

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

256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
259: THEN
260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
261: END IF;
262:
263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
264: p_data => x_msg_data,

Line 263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

259: THEN
260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
261: END IF;
262:
263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
264: p_data => x_msg_data,
265: p_encoded => 'F');
266:
267: END Load_SectionItems_For_Item;

Line 299: FND_MSG_PUB.initialize;

295: BEGIN
296:
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean(p_init_msg_list) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: -- Initialize API return status to success
303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

355: EXCEPTION
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
360: p_data => x_msg_data,
361: p_encoded => 'F');
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 365: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

361: p_encoded => 'F');
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
366: p_data => x_msg_data,
367: p_encoded => 'F');
368:
369: WHEN OTHERS THEN

Line 374: FND_MSG_PUB.Add;

370: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
371: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
374: FND_MSG_PUB.Add;
375:
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:
378: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 378: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

374: FND_MSG_PUB.Add;
375:
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:
378: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
381: END IF;
382:

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

376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:
378: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
381: END IF;
382:
383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data,

Line 383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

379: THEN
380: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
381: END IF;
382:
383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data,
385: p_encoded => 'F');
386:
387: END Load_ChildSections_For_Section;

Line 435: FND_MSG_PUB.initialize;

431: BEGIN
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean(p_init_msg_list) THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:
438: -- Initialize API return status to success
439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 481: FND_MSG_PUB.Add;

477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
481: FND_MSG_PUB.Add;
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: ELSE

Line 507: FND_MSG_PUB.Add;

503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: END IF;

Line 520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

516: EXCEPTION
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
521: p_data => x_msg_data,
522: p_encoded => 'F');
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

522: p_encoded => 'F');
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => 'F');
529:
530: WHEN OTHERS THEN

Line 535: FND_MSG_PUB.Add;

531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538:
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

535: FND_MSG_PUB.Add;
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538:
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
542: END IF;
543:

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

537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538:
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
542: END IF;
543:
544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
545: p_data => x_msg_data,

Line 544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

540: THEN
541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
542: END IF;
543:
544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => 'F');
547:
548: END Load_Children_For_Section;

Line 579: FND_MSG_PUB.initialize;

575: BEGIN
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean(p_init_msg_list) THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Initialize API return status to success
583: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 627: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

623: EXCEPTION
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
628: p_data => x_msg_data,
629: p_encoded => 'F');
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

629: p_encoded => 'F');
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => 'F');
636:
637: WHEN OTHERS THEN

Line 642: FND_MSG_PUB.Add;

638: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
639: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
641: FND_MESSAGE.Set_Token('REASON', SQLERRM);
642: FND_MSG_PUB.Add;
643:
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

642: FND_MSG_PUB.Add;
643:
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
647: THEN
648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
649: END IF;
650:

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

644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
647: THEN
648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
649: END IF;
650:
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,

Line 651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

647: THEN
648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
649: END IF;
650:
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');
654:
655: END Load_Section_For_Basic_Desc;

Line 685: FND_MSG_PUB.initialize;

681: BEGIN
682:
683: -- Initialize message list if p_init_msg_list is set to TRUE.
684: IF FND_API.to_Boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- Initialize API return status to success
689: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

727: EXCEPTION
728:
729: WHEN FND_API.G_EXC_ERROR THEN
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
732: p_data => x_msg_data,
733: p_encoded => 'F');
734:
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 737: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

733: p_encoded => 'F');
734:
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
738: p_data => x_msg_data,
739: p_encoded => 'F');
740:
741: WHEN OTHERS THEN

Line 746: FND_MSG_PUB.Add;

742: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
743: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
745: FND_MESSAGE.Set_Token('REASON', SQLERRM);
746: FND_MSG_PUB.Add;
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

746: FND_MSG_PUB.Add;
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: END IF;
754:

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

748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: END IF;
754:
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data,

Line 755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: END IF;
754:
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data,
757: p_encoded => 'F');
758:
759: END Load_Root_Sct_For_Basic_Desc;

Line 809: FND_MSG_PUB.initialize;

805: END IF;
806:
807: -- Initialize message list if p_init_msg_list is set to TRUE.
808: IF FND_API.to_Boolean(p_init_msg_list) THEN
809: FND_MSG_PUB.initialize;
810: END IF;
811:
812: -- Initialize API return status to success
813: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 907: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

903: COMMIT WORK;
904: END IF;
905:
906: -- Standard call to get message count and if count is 1, get message info.
907: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
908: p_data => x_msg_data,
909: p_encoded => 'F');
910:
911: EXCEPTION

Line 915: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

911: EXCEPTION
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
916: p_data => x_msg_data,
917: p_encoded => 'F');
918:
919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 921: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

917: p_encoded => 'F');
918:
919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => 'F');
924:
925: WHEN OTHERS THEN

Line 930: FND_MSG_PUB.Add;

926: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
927: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
929: FND_MESSAGE.Set_Token('REASON', SQLERRM);
930: FND_MSG_PUB.Add;
931:
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933:
934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

930: FND_MSG_PUB.Add;
931:
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933:
934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
937: END IF;
938:

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

932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933:
934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
937: END IF;
938:
939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
940: p_data => x_msg_data,

Line 939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

935: THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
937: END IF;
938:
939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
940: p_data => x_msg_data,
941: p_encoded => 'F');
942:
943: END Get_Cand_Incl_MSites_For_Sct;

Line 968: FND_MSG_PUB.initialize;

964: BEGIN
965:
966: -- Initialize message list if p_init_msg_list is set to TRUE.
967: IF FND_API.to_Boolean(p_init_msg_list) THEN
968: FND_MSG_PUB.initialize;
969: END IF;
970:
971: -- Initialize API return status to success
972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

986: EXCEPTION
987:
988: WHEN FND_API.G_EXC_ERROR THEN
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
991: p_data => x_msg_data,
992: p_encoded => 'F');
993:
994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

992: p_encoded => 'F');
993:
994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
997: p_data => x_msg_data,
998: p_encoded => 'F');
999:
1000: WHEN OTHERS THEN

Line 1005: FND_MSG_PUB.Add;

1001: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1002: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1005: FND_MSG_PUB.Add;
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1005: FND_MSG_PUB.Add;
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1010: THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;
1013:

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

1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1010: THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;
1013:
1014: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1015: p_data => x_msg_data,

Line 1014: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1010: THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;
1013:
1014: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1015: p_data => x_msg_data,
1016: p_encoded => 'F');
1017:
1018: END Load_Items_For_Basic_Desc;

Line 1061: FND_MSG_PUB.initialize;

1057: END IF;
1058:
1059: -- Initialize message list if p_init_msg_list is set to TRUE.
1060: IF FND_API.to_Boolean(p_init_msg_list) THEN
1061: FND_MSG_PUB.initialize;
1062: END IF;
1063:
1064: -- Initialize API return status to success
1065: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1123: COMMIT WORK;
1124: END IF;
1125:
1126: -- Standard call to get message count and if count is 1, get message info.
1127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1128: p_data => x_msg_data,
1129: p_encoded => 'F');
1130:
1131: EXCEPTION

Line 1135: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1131: EXCEPTION
1132:
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => 'F');
1138:
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1137: p_encoded => 'F');
1138:
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1142: p_data => x_msg_data,
1143: p_encoded => 'F');
1144:
1145: WHEN OTHERS THEN

Line 1150: FND_MSG_PUB.Add;

1146: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1147: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1150: FND_MSG_PUB.Add;
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153:
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1150: FND_MSG_PUB.Add;
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153:
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1157: END IF;
1158:

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

1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153:
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1157: END IF;
1158:
1159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1160: p_data => x_msg_data,

Line 1159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1157: END IF;
1158:
1159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1160: p_data => x_msg_data,
1161: p_encoded => 'F');
1162:
1163: END Get_Cand_Incl_MSites_For_Itm;

Line 1368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1364: EXCEPTION
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1369: p_data => x_msg_data,
1370: p_encoded => 'F');
1371:
1372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1374: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1370: p_encoded => 'F');
1371:
1372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1375: p_data => x_msg_data,
1376: p_encoded => 'F');
1377:
1378: WHEN OTHERS THEN

Line 1383: FND_MSG_PUB.Add;

1379: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1380: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1383: FND_MSG_PUB.Add;
1384:
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386:
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1383: FND_MSG_PUB.Add;
1384:
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386:
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1390: END IF;
1391:

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

1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386:
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1390: END IF;
1391:
1392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1393: p_data => x_msg_data,

Line 1392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1390: END IF;
1391:
1392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1393: p_data => x_msg_data,
1394: p_encoded => 'F');
1395:
1396: END Load_Section_Hierarchy;