21: WHEN OTHERS THEN
22:
23: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
24:
25: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
26: THEN
27: FND_MSG_PUB.Add_Exc_Msg
28: ( G_PKG_NAME
29: , 'Get_level_name'
23: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
24:
25: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
26: THEN
27: FND_MSG_PUB.Add_Exc_Msg
28: ( G_PKG_NAME
29: , 'Get_level_name'
30: );
31: END IF;
31: END IF;
32:
33: -- Get message count and data
34:
35: FND_MSG_PUB.Count_And_Get
36: ( p_count => x_msg_count
37: , p_data => x_msg_data
38: );
39: end Get_Level_name;
91: l_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: -- Initialize message list.
94: if p_msg_init = FND_API.G_TRUE then
95: FND_MSG_PUB.initialize;
96: end if;
97:
98: BIS_debug_pub.add('Selecting row from BIS_target_levels for : '
99: || p_ind_level_name);
330: BIS_debug_pub.add('The view creation sql execution result is :'
331: || to_char(l_sql_result));
332:
333: if nvl(l_sql_result,-1) <> 0 then
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( G_PKG_NAME
338: , 'Create_Ind_Level_View'
332:
333: if nvl(l_sql_result,-1) <> 0 then
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( G_PKG_NAME
338: , 'Create_Ind_Level_View'
339: );
340: END IF;
344: /* fnd_message.set_name('_','IND_LEVEL_VIEW_CREATED');
345: fnd_message.set_token('VIEW_NAME','BIS_'
346: || substr(replace(p_ind_level_name,' ','_'),1,24)|| '_v');
347: fnd_message.set_token('FOR_LEVEL',p_ind_level_name);
348: fnd_msg_pub.add;
349: */
350: null;
351: end if;
352: FND_MSG_PUB.Count_And_Get
348: fnd_msg_pub.add;
349: */
350: null;
351: end if;
352: FND_MSG_PUB.Count_And_Get
353: ( p_count => x_msg_count
354: , p_data => x_msg_data
355: );
356: x_return_status := l_return_status;
362: x_return_status := FND_API.G_RET_STS_ERROR;
363:
364: -- Get message count and data
365:
366: FND_MSG_PUB.Count_And_Get
367: ( p_count => x_msg_count
368: , p_data => x_msg_data
369: );
370:
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374:
375: -- Get message count and data
376:
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count
379: , p_data => x_msg_data
380: );
381:
382: WHEN OTHERS THEN
383:
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385:
386: FND_MSG_PUB.Add_Exc_Msg
387: ( G_PKG_NAME
388: , 'Create_Ind_Level_View'
389: );
390:
389: );
390:
391: -- Get message count and data
392:
393: FND_MSG_PUB.Count_And_Get
394: ( p_count => x_msg_count
395: , p_data => x_msg_data
396: );
397:
417: l_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: -- Initialize message list.
420: if p_msg_init = FND_API.G_TRUE then
421: FND_MSG_PUB.initialize;
422: end if;
423:
424: for r1 in c_levels(p_indicator_name) loop
425: BIS_debug_pub.add('Calling Create Level force View for Level:'
445: x_return_status := FND_API.G_RET_STS_ERROR;
446:
447: -- Get message count and data
448:
449: FND_MSG_PUB.Count_And_Get
450: ( p_count => x_msg_count
451: , p_data => x_msg_data
452: );
453:
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457:
458: -- Get message count and data
459:
460: FND_MSG_PUB.Count_And_Get
461: ( p_count => x_msg_count
462: , p_data => x_msg_data
463: );
464:
465: WHEN OTHERS THEN
466:
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
468:
469: FND_MSG_PUB.Add_Exc_Msg
470: ( G_PKG_NAME
471: , 'Create_Indicator_views'
472: );
473:
472: );
473:
474: -- Get message count and data
475:
476: FND_MSG_PUB.Count_And_Get
477: ( p_count => x_msg_count
478: , p_data => x_msg_data
479: );
480:
495: l_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: -- Initialize message list.
498: if p_msg_init = FND_API.G_TRUE then
499: FND_MSG_PUB.initialize;
500: end if;
501:
502: for r1 in c_indicator loop
503: BIS_debug_pub.add('Calling Create BIS force View for Indicator:'
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: -- Get message count and data
526:
527: FND_MSG_PUB.Count_And_Get
528: ( p_count => x_msg_count
529: , p_data => x_msg_data
530: );
531:
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535:
536: -- Get message count and data
537:
538: FND_MSG_PUB.Count_And_Get
539: ( p_count => x_msg_count
540: , p_data => x_msg_data
541: );
542:
543: WHEN OTHERS THEN
544:
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
546:
547: FND_MSG_PUB.Add_Exc_Msg
548: ( G_PKG_NAME
549: , 'Create_BIS_views'
550: );
551:
550: );
551:
552: -- Get message count and data
553:
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count
556: , p_data => x_msg_data
557: );
558:
598: WHEN OTHERS THEN
599:
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: FND_MSG_PUB.Add_Exc_Msg
605: (G_PKG_NAME
606: ,'Drop_Ind_Level_View');
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: FND_MSG_PUB.Add_Exc_Msg
605: (G_PKG_NAME
606: ,'Drop_Ind_Level_View');
607: END IF;
608:
606: ,'Drop_Ind_Level_View');
607: END IF;
608:
609: -- get message count and data
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count
612: ,p_data => x_msg_data
613: );
614:
658: WHEN OTHERS THEN
659:
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg
665: (G_PKG_NAME
666: ,'Get_Dimension_Display_Value');
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg
665: (G_PKG_NAME
666: ,'Get_Dimension_Display_Value');
667: END IF;
668:
666: ,'Get_Dimension_Display_Value');
667: END IF;
668:
669: -- get message count and data
670: FND_MSG_PUB.Count_And_Get
671: (p_count => x_msg_count
672: ,p_data => x_msg_data
673: );
674: end Get_Dimension_Display_Value;
743: WHEN OTHERS THEN
744:
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
748: THEN
749: FND_MSG_PUB.Add_Exc_Msg
750: (G_PKG_NAME
751: ,'Validate_Resp_Org');
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
748: THEN
749: FND_MSG_PUB.Add_Exc_Msg
750: (G_PKG_NAME
751: ,'Validate_Resp_Org');
752: END IF;
753:
751: ,'Validate_Resp_Org');
752: END IF;
753:
754: -- get message count and data
755: FND_MSG_PUB.Count_And_Get
756: (p_count => x_msg_count
757: ,p_data => x_msg_data
758: );
759: