APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on FND_API

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS ;

293: ,x_value_name => x_value_name
294: ,x_parent_name => l_parent_name
295: ,x_time_level => x_time_level ) ) THEN
296:
297: x_return_status := FND_API.G_RET_STS_SUCCESS ;
298:
299: RETURN;
300: END IF;
301:

Line 312: RAISE FND_API.G_EXC_ERROR;

308: IF (c_dims%NOTFOUND) THEN
309: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');
310: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_DimLevelName);
311: FND_MSG_PUB.ADD;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314: CLOSE c_dims;
315: --IF (fnd_profile.value('BIS_SOURCE') = 'EDW')
316: IF ((l_source = 'EDW') and

Line 360: WHEN FND_API.G_EXC_ERROR THEN

356: ,p_time_level => x_time_level
357: );
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: );
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );

Line 367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

364: p_data => x_msg_data
365: );
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );

Line 374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373: WHEN OTHERS THEN
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
376: THEN
377: FND_MSG_PUB.Add_Exc_Msg
378: ( G_PKG_NAME,

Line 458: x_return_status := FND_API.G_RET_STS_SUCCESS ;

454: ,x_value_name => x_value_name
455: ,x_parent_name => x_parent_name
456: ,x_time_level => x_time_level ) ) THEN
457:
458: x_return_status := FND_API.G_RET_STS_SUCCESS ;
459:
460: RETURN;
461: END IF;
462:

Line 475: RAISE FND_API.G_EXC_ERROR;

471: IF (c_dims%NOTFOUND) THEN
472: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');
473: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_DimLevelName);
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: CLOSE c_dims;
478: --END IF;
479: --IF (fnd_profile.value('BIS_SOURCE') = 'EDW')

Line 523: WHEN FND_API.G_EXC_ERROR THEN

519: ,p_time_level => x_time_level
520: );
521:
522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: FND_MSG_PUB.Count_And_Get
526: ( p_count => x_msg_count,
527: p_data => x_msg_data

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: );
521:
522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: FND_MSG_PUB.Count_And_Get
526: ( p_count => x_msg_count,
527: p_data => x_msg_data
528: );

Line 530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

526: ( p_count => x_msg_count,
527: p_data => x_msg_data
528: );
529:
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get
533: ( p_count => x_msg_count,
534: p_data => x_msg_data

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: p_data => x_msg_data
528: );
529:
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get
533: ( p_count => x_msg_count,
534: p_data => x_msg_data
535: );

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533: ( p_count => x_msg_count,
534: p_data => x_msg_data
535: );
536: WHEN OTHERS THEN
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME,

Line 637: RAISE FND_API.G_EXC_ERROR;

633: EXCEPTION WHEN NO_DATA_FOUND THEN
634: FND_MESSAGE.SET_NAME ('BIS','BIS_INVALID_LEVEL_SHORT_NAME');
635: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);
636: FND_MSG_PUB.ADD;
637: RAISE FND_API.G_EXC_ERROR;
638: END;
639: IF (BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))
640: THEN
641: l_pkkey := l_prefix||EDW_LVL_FLEX_PK_SUFFIX;

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: BEGIN
647: EXECUTE IMMEDIATE l_sql_string ;
648: EXCEPTION
649: WHEN OTHERS THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF (SQLCODE = -942) THEN
652: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');
653: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
654: FND_MSG_PUB.ADD;

Line 661: RAISE FND_API.G_EXC_ERROR;

657: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_PK_KEY');
658: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);
659: FND_MSG_PUB.ADD;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;
662: FND_MSG_PUB.Count_And_Get
663: (p_count => x_msg_count,
664: p_data => x_msg_data
665: );

Line 682: RAISE FND_API.G_EXC_ERROR;

678: WHEN NO_DATA_FOUND THEN
679: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_PK_KEY');
680: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);
681: FND_MSG_PUB.ADD;
682: RAISE FND_API.G_EXC_ERROR;
683: END;
684: l_tablename := l_lvlshortname || EDW_LVL_TBL_SUFFIX ;
685: l_sql_string := 'SELECT '||l_pkkey||' from '||l_tablename|| ' where rownum < 2';
686: BEGIN

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

686: BEGIN
687: EXECUTE IMMEDIATE l_sql_string ;
688: EXCEPTION
689: WHEN OTHERS THEN
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: IF (SQLCODE = -942) THEN
692: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');
693: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
694: FND_MSG_PUB.ADD;

Line 701: RAISE FND_API.G_EXC_ERROR;

697: FND_MESSAGE.SET_NAME ('BIS', 'BIS_INVALID_EDW_PK_KEY');
698: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
699: FND_MSG_PUB.ADD;
700: END IF;
701: RAISE FND_API.G_EXC_ERROR;
702: END;
703: l_valuename := 'NAME';
704: END IF;
705: IF p_source IS NOT NULL THEN -- 2617369

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725: BEGIN
726: EXECUTE IMMEDIATE l_sql_string ;
727: EXCEPTION
728: WHEN OTHERS THEN
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: IF (SQLCODE = -942) THEN
731: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');
732: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
733: FND_MSG_PUB.ADD;

Line 740: RAISE FND_API.G_EXC_ERROR;

736: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_START_DATE');
737: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);
738: FND_MSG_PUB.ADD;
739: END IF;
740: RAISE FND_API.G_EXC_ERROR;
741: END;
742: l_sql_string := 'SELECT end_date from '||l_tablename||' where rownum < 2';
743: BEGIN
744: EXECUTE IMMEDIATE l_sql_string ;

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: BEGIN
744: EXECUTE IMMEDIATE l_sql_string ;
745: EXCEPTION
746: WHEN OTHERS THEN
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: IF (SQLCODE = -942) THEN
749: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');
750: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
751: FND_MSG_PUB.ADD;

Line 758: RAISE FND_API.G_EXC_ERROR;

754: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_END_DATEY');
755: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);
756: FND_MSG_PUB.ADD;
757: END IF;
758: RAISE FND_API.G_EXC_ERROR;
759: END;
760:
761: ELSE
762: l_time_columns := '';

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: BEGIN
766: EXECUTE IMMEDIATE l_sql_string ;
767: EXCEPTION
768: WHEN OTHERS THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: IF (SQLCODE = -942) THEN
771: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');
772: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
773: FND_MSG_PUB.ADD;

Line 780: RAISE FND_API.G_EXC_ERROR;

776: FND_MESSAGE.SET_NAME ('BIS', 'BIS_INVALID_VALUE');
777: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
778: FND_MSG_PUB.ADD;
779: END IF;
780: RAISE FND_API.G_EXC_ERROR;
781: END;
782:
783: x_edw_select_string := 'select '||l_distinct||' '|| l_pkkey ||' id , ' ||
784: l_valuename ||' value '||l_time_columns|| ' FROM '|| l_tablename;

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: l_valuename ||' value '||l_time_columns|| ' FROM '|| l_tablename;
785: x_table_name := l_tablename;
786: x_id_name := l_pkkey;
787: x_value_name := l_valuename;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: FND_MSG_PUB.Count_And_Get
790: (p_count => x_msg_count,
791: p_data => x_msg_data
792: );

Line 796: WHEN FND_API.G_EXC_ERROR THEN

792: );
793:
794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get
799: ( p_count => x_msg_count,
800: p_data => x_msg_data

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793:
794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: FND_MSG_PUB.Count_And_Get
799: ( p_count => x_msg_count,
800: p_data => x_msg_data
801: );

Line 802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

798: FND_MSG_PUB.Count_And_Get
799: ( p_count => x_msg_count,
800: p_data => x_msg_data
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.Count_And_Get
805: ( p_count => x_msg_count,
806: p_data => x_msg_data

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: ( p_count => x_msg_count,
800: p_data => x_msg_data
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.Count_And_Get
805: ( p_count => x_msg_count,
806: p_data => x_msg_data
807: );

Line 809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

805: ( p_count => x_msg_count,
806: p_data => x_msg_data
807: );
808: WHEN OTHERS THEN
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
811: THEN
812: FND_MSG_PUB.Add_Exc_Msg
813: (G_PKG_NAME,

Line 900: RAISE FND_API.G_EXC_ERROR;

896: IF c_dimlvls%NOTFOUND THEN
897: FND_MESSAGE.SET_NAME('BIS', 'BIS_INVALID_LEVEL_SHORTNAME');
898: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);
899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: CLOSE c_dimlvls;
903: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- 2408906
904: p_level_short_name => l_lvlshortname);

Line 920: x_return_status := FND_API.G_RET_STS_SUCCESS;

916: x_table_name := 'dual'; -- 'BIS_ROLLING_LEVEL_002'; -- 'dual'; --
917: x_id_name := 'ID';
918: x_value_name := 'VALUE';
919: x_time_level := 'Y'; -- rolling period should not be checking if x_time_level is null
920: x_return_status := FND_API.G_RET_STS_SUCCESS;
921:
922:
923: ELSE
924:

Line 934: (BSC_UTILITY.Is_Dim_Object_Periodicity_Type(l_lvlshortname) = FND_API.G_TRUE)) THEN

930: END IF;
931:
932: -- Added condition to check if it is a Periodicity time Dimension Object
933: IF ((l_dimshortname = l_dimshortname_time) OR
934: (BSC_UTILITY.Is_Dim_Object_Periodicity_Type(l_lvlshortname) = FND_API.G_TRUE)) THEN
935: l_time_columns := ' , start_date, end_date ';
936: x_time_level := 'Y';
937: ELSE
938: l_time_columns := '';

Line 977: x_return_status := FND_API.G_RET_STS_SUCCESS;

973: -- l_levelvalueview;
974: x_table_name := l_levelvalueview;
975: x_id_name := l_id;
976: x_value_name := l_value;
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978:
979: FND_MSG_PUB.Count_And_Get
980: (p_count => x_msg_count,
981: p_data => x_msg_data

Line 987: WHEN FND_API.G_EXC_ERROR THEN

983:
984: END IF;
985:
986: EXCEPTION
987: WHEN FND_API.G_EXC_ERROR THEN
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: FND_MSG_PUB.Count_And_Get
990: ( p_count => x_msg_count,
991: p_data => x_msg_data

Line 988: x_return_status := FND_API.G_RET_STS_ERROR;

984: END IF;
985:
986: EXCEPTION
987: WHEN FND_API.G_EXC_ERROR THEN
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: FND_MSG_PUB.Count_And_Get
990: ( p_count => x_msg_count,
991: p_data => x_msg_data
992: );

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

989: FND_MSG_PUB.Count_And_Get
990: ( p_count => x_msg_count,
991: p_data => x_msg_data
992: );
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.Count_And_Get
996: ( p_count => x_msg_count,
997: p_data => x_msg_data

Line 994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990: ( p_count => x_msg_count,
991: p_data => x_msg_data
992: );
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.Count_And_Get
996: ( p_count => x_msg_count,
997: p_data => x_msg_data
998: );

Line 1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

996: ( p_count => x_msg_count,
997: p_data => x_msg_data
998: );
999: WHEN NO_DATA_FOUND THEN
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: FND_MSG_PUB.Count_And_Get
1002: (p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );

Line 1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1002: (p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );
1005: WHEN OTHERS THEN
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1008: THEN
1009: FND_MSG_PUB.Add_Exc_Msg
1010: (G_PKG_NAME,

Line 1053: RAISE FND_API.G_EXC_ERROR;

1049: IF (c_dims%NOTFOUND) THEN
1050: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');
1051: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_short_name);
1052: FND_MSG_PUB.ADD;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: CLOSE c_dims;
1056: --IF (fnd_profile.value('BIS_SOURCE') = 'EDW')
1057: IF ((l_source = 'EDW') AND (l_level_Values_view_name IS NULL))

Line 1089: WHEN FND_API.G_EXC_ERROR THEN

1085: x_level_name := l_level_name;
1086: x_Description := l_description;
1087: x_dimlevel_short_name := l_short_name;
1088: EXCEPTION
1089: WHEN FND_API.G_EXC_ERROR THEN
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get
1092: ( p_count => x_msg_count,
1093: p_data => x_msg_data

Line 1090: x_return_status := FND_API.G_RET_STS_ERROR;

1086: x_Description := l_description;
1087: x_dimlevel_short_name := l_short_name;
1088: EXCEPTION
1089: WHEN FND_API.G_EXC_ERROR THEN
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get
1092: ( p_count => x_msg_count,
1093: p_data => x_msg_data
1094: );

Line 1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1092: ( p_count => x_msg_count,
1093: p_data => x_msg_data
1094: );
1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: FND_MSG_PUB.Count_And_Get
1099: ( p_count => x_msg_count,
1100: p_data => x_msg_data

Line 1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1093: p_data => x_msg_data
1094: );
1095:
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: FND_MSG_PUB.Count_And_Get
1099: ( p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1099: ( p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );
1102: WHEN OTHERS THEN
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1105: THEN
1106: FND_MSG_PUB.Add_Exc_Msg
1107: ( G_PKG_NAME,

Line 1328: x_return_status := FND_API.G_RET_STS_SUCCESS;

1324: l_dim_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1325: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
1326: l_dim_un_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1327: BEGIN
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329: l_bis_source := p_bis_source;
1330: IF (l_bis_source IS NULL) THEN
1331: l_bis_source := get_source(p_dim_level_short_name => l_dim_level_short_name);
1332: END IF;

Line 1346: IF ( (l_is_relationship_found = FND_API.G_FALSE)) THEN

1342: ,x_msg_data => x_msg_data
1343: );
1344:
1345:
1346: IF ( (l_is_relationship_found = FND_API.G_FALSE)) THEN
1347: -- Since relationship data not present in bsc data model, call existing code.
1348: l_is_pmf_bsc_source := get_dim_level_source (p_dimlevel_rec.dimension_level_short_name);
1349: IF (l_is_pmf_bsc_source = 'PMF') THEN
1350: get_dimlevel_select_string(

Line 1381: ELSIF ( (l_is_relationship_found = FND_API.G_TRUE) AND (l_dim_rel_info_rec.relation_col IS NULL) ) THEN

1377: ,x_msg_data => x_msg_data
1378: ,p_region_code => p_region_code
1379: );
1380: END IF;
1381: ELSIF ( (l_is_relationship_found = FND_API.G_TRUE) AND (l_dim_rel_info_rec.relation_col IS NULL) ) THEN
1382: -- throw exception if relation found but relation column is null
1383: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_REL_COL_NULL');
1384: FND_MSG_PUB.ADD;
1385: RAISE FND_API.G_EXC_ERROR;

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: ELSIF ( (l_is_relationship_found = FND_API.G_TRUE) AND (l_dim_rel_info_rec.relation_col IS NULL) ) THEN
1382: -- throw exception if relation found but relation column is null
1383: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_REL_COL_NULL');
1384: FND_MSG_PUB.ADD;
1385: RAISE FND_API.G_EXC_ERROR;
1386: ELSE -- relationship is found - both BIS and BSC is handled by this API.
1387: get_select_string(
1388: p_bis_source => l_bis_source
1389: ,p_is_relation_recursive => x_is_relation_recursive

Line 1408: WHEN FND_API.G_EXC_ERROR THEN

1404:
1405: );
1406: END IF;
1407: EXCEPTION
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1411: ,p_data => x_msg_data);
1412: WHEN OTHERS THEN

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405: );
1406: END IF;
1407: EXCEPTION
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1411: ,p_data => x_msg_data);
1412: WHEN OTHERS THEN
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1411: ,p_data => x_msg_data);
1412: WHEN OTHERS THEN
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1415: ,p_data => x_msg_data);
1416: END get_dimlevel_select_string;
1417:

Line 1452: x_return_status := FND_API.G_RET_STS_SUCCESS;

1448: )
1449: IS
1450: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
1451: BEGIN
1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: l_is_pmf_bsc_source := get_dim_level_source (p_dim_rel_info_rec.dimension_level_short_name);
1455:
1456: IF (l_is_pmf_bsc_source = 'PMF') THEN

Line 1492: IF (p_is_relation_recursive IS NOT NULL AND p_is_relation_recursive = FND_API.G_TRUE) THEN

1488: -- Always use "IN" and not "=", so both multi-select and single select is taken care of.
1489:
1490: IF (p_dim_rel_info_rec.parent_ri_attribute_code IS NOT NULL) THEN
1491: IF (is_append_where_clause(p_dim_rel_info_rec => p_dim_rel_info_rec, p_is_relation_recursive => p_is_relation_recursive)) THEN
1492: IF (p_is_relation_recursive IS NOT NULL AND p_is_relation_recursive = FND_API.G_TRUE) THEN
1493: -- recursive relationship should bring itself, its children and its parent.
1494: x_where_clause := ' AND (( ''ALL'' IN ({' || p_dim_rel_info_rec.parent_ri_attribute_code || '}) OR ' || x_parent_name || ' IN ({' || p_dim_rel_info_rec.parent_ri_attribute_code || '}))' ||
1495: ' OR ( ' || x_id_name || ' IN ({' || p_dim_rel_info_rec.parent_ri_attribute_code || '}))' ||
1496: ' OR ( ' || x_id_name || ' IN (SELECT ' || x_parent_name || ' FROM ' || x_data_source || ' WHERE ' || x_id_name || ' IN ({' || p_dim_rel_info_rec.parent_ri_attribute_code || '}))))';

Line 1503: x_return_status := FND_API.G_RET_STS_SUCCESS;

1499: END IF;
1500: END IF;
1501: END IF;
1502:
1503: x_return_status := FND_API.G_RET_STS_SUCCESS;
1504:
1505: EXCEPTION
1506: WHEN FND_API.G_EXC_ERROR THEN
1507: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1506: WHEN FND_API.G_EXC_ERROR THEN

1502:
1503: x_return_status := FND_API.G_RET_STS_SUCCESS;
1504:
1505: EXCEPTION
1506: WHEN FND_API.G_EXC_ERROR THEN
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1509: ,p_data => x_msg_data);
1510:

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

1503: x_return_status := FND_API.G_RET_STS_SUCCESS;
1504:
1505: EXCEPTION
1506: WHEN FND_API.G_EXC_ERROR THEN
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1509: ,p_data => x_msg_data);
1510:
1511: WHEN OTHERS THEN

Line 1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1508: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1509: ,p_data => x_msg_data);
1510:
1511: WHEN OTHERS THEN
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1514: ,p_data => x_msg_data);
1515: END get_select_string;
1516:

Line 1565: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1561: ,x_msg_count => x_msg_count
1562: ,x_msg_data => x_msg_data
1563: );
1564:
1565: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568:
1569: IF ( needs_time_cols(--check if this is fine for both edw and oltp

Line 1566: RAISE FND_API.G_EXC_ERROR;

1562: ,x_msg_data => x_msg_data
1563: );
1564:
1565: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568:
1569: IF ( needs_time_cols(--check if this is fine for both edw and oltp
1570: p_source => p_bis_source

Line 1576: x_time_level := FND_API.G_TRUE;

1572: ,p_lvlshortname => l_dimlvl_short_name
1573: ,p_dimshortname => l_dim_short_name
1574: )) THEN
1575: l_time_columns := ' ,start_date, end_date ';
1576: x_time_level := FND_API.G_TRUE;
1577: END IF;
1578:
1579: /* Removed code for get_binds() for enh# 4456833 - not needed now - binds etc are not used. No values are passed
1580: into this API but keeping in the original API signature in DimLevelUtil for backward compatibility.

Line 1583: IF (p_is_relation_recursive IS NOT NULL AND p_is_relation_recursive = FND_API.G_TRUE) THEN

1579: /* Removed code for get_binds() for enh# 4456833 - not needed now - binds etc are not used. No values are passed
1580: into this API but keeping in the original API signature in DimLevelUtil for backward compatibility.
1581: */
1582: -- PMV does not need the parent_id column in the select statement unless it is recursive - bug# 4914929.
1583: IF (p_is_relation_recursive IS NOT NULL AND p_is_relation_recursive = FND_API.G_TRUE) THEN
1584: l_relation_col_in_select := ', ' || l_relation_col || ' as parent_id ';
1585: END IF;
1586: x_select_string := 'SELECT '|| x_Id_Name ||' , '|| x_Value_Name || l_relation_col_in_select || l_time_columns || ' FROM '|| l_data_source;
1587: x_data_source := l_data_source ;

Line 1592: WHEN FND_API.G_EXC_ERROR THEN

1588: x_parent_name := l_relation_col; -- 'PARENT_ID'; -- parent_id is the alias always.
1589:
1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1595: ,p_data => x_msg_data);
1596: WHEN OTHERS THEN

Line 1593: x_return_status := FND_API.G_RET_STS_ERROR;

1589:
1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1595: ,p_data => x_msg_data);
1596: WHEN OTHERS THEN
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1595: ,p_data => x_msg_data);
1596: WHEN OTHERS THEN
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1599: ,p_data => x_msg_data);
1600: END get_pmf_data_source;
1601:

Line 1640: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

1636: ,x_return_status => x_return_status
1637: ,x_msg_count => x_msg_count
1638: ,x_msg_data => x_msg_data
1639: );
1640: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;
1643: /* PMV appends "All" based on All enabled/disabled (bsc_sys_dim_levels_by_group.total_flag.
1644: * In PMF views (level_values_view_name), All is not present (or restricted by product team where clause).

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637: ,x_msg_count => x_msg_count
1638: ,x_msg_data => x_msg_data
1639: );
1640: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;
1643: /* PMV appends "All" based on All enabled/disabled (bsc_sys_dim_levels_by_group.total_flag.
1644: * In PMF views (level_values_view_name), All is not present (or restricted by product team where clause).
1645: * In BSC views (level_view_name), All is always present with code as 0. This needs to be filtered out so that

Line 1672: WHEN FND_API.G_EXC_ERROR THEN

1668: x_id_name := G_ID_NAME;
1669: x_value_name := G_VALUE_NAME;
1670:
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1675: ,p_data => x_msg_data);
1676:

Line 1673: x_return_status := FND_API.G_RET_STS_ERROR;

1669: x_value_name := G_VALUE_NAME;
1670:
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1675: ,p_data => x_msg_data);
1676:
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1675: ,p_data => x_msg_data);
1676:
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681:

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1675: ,p_data => x_msg_data);
1676:
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681:
1682: WHEN OTHERS THEN

Line 1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681:
1682: WHEN OTHERS THEN
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1685: ,p_data => x_msg_data);
1686: END get_bsc_data_source;
1687:

Line 1716: x_is_relation_recursive := FND_API.G_FALSE;

1712: l_count NUMBER;
1713: err_msg VARCHAR2(3000);
1714: BEGIN
1715: l_parent_dimlvl_tbl := p_parent_dimlvl_tbl;
1716: x_is_relation_recursive := FND_API.G_FALSE;
1717: x_is_relationship_found := FND_API.G_FALSE;
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;
1719:
1720: -- check for recursive parent-child relationship.

Line 1717: x_is_relationship_found := FND_API.G_FALSE;

1713: err_msg VARCHAR2(3000);
1714: BEGIN
1715: l_parent_dimlvl_tbl := p_parent_dimlvl_tbl;
1716: x_is_relation_recursive := FND_API.G_FALSE;
1717: x_is_relationship_found := FND_API.G_FALSE;
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;
1719:
1720: -- check for recursive parent-child relationship.
1721: -- For this, append the child to the parent table type.

Line 1718: x_return_status := FND_API.G_RET_STS_SUCCESS;

1714: BEGIN
1715: l_parent_dimlvl_tbl := p_parent_dimlvl_tbl;
1716: x_is_relation_recursive := FND_API.G_FALSE;
1717: x_is_relationship_found := FND_API.G_FALSE;
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;
1719:
1720: -- check for recursive parent-child relationship.
1721: -- For this, append the child to the parent table type.
1722: -- Recursive takes precedence and hence it is added as the first.

Line 1737: IF (x_is_relationship_found = FND_API.G_TRUE) THEN

1733: ,x_return_status => x_return_status
1734: ,x_msg_count => x_msg_count
1735: ,x_msg_data => x_msg_data
1736: );
1737: IF (x_is_relationship_found = FND_API.G_TRUE) THEN
1738: x_dim_rel_info_rec.dimension_short_name := p_child_dimlvl_rec.dimension_short_name;
1739: x_dim_rel_info_rec.dimension_level_short_name := l_bsc_dim_rel_info_rec.bsc_level_short_name;
1740: x_dim_rel_info_rec.parent_dimension_short_name := l_parent_dimlvl_tbl(i).dimension_short_name;
1741: x_dim_rel_info_rec.parent_level_short_name := l_bsc_dim_rel_info_rec.bsc_parent_level_short_name;

Line 1775: x_is_relationship_found := FND_API.G_FALSE;

1771: -- l_return_status VARCHAR2(10);
1772: -- l_msg_count NUMBER;
1773: -- l_msg_data VARCHAR2(3000);
1774: BEGIN
1775: x_is_relationship_found := FND_API.G_FALSE;
1776: x_is_relation_recursive := FND_API.G_FALSE;
1777: l_bsc_dim_level_rec.bsc_level_short_name := p_child_dimlvl_rec.dimension_level_short_name;
1778: l_bsc_dim_level_rec.bsc_parent_level_short_name := p_parent_dimlvl_rec.dimension_level_short_name;
1779:

Line 1776: x_is_relation_recursive := FND_API.G_FALSE;

1772: -- l_msg_count NUMBER;
1773: -- l_msg_data VARCHAR2(3000);
1774: BEGIN
1775: x_is_relationship_found := FND_API.G_FALSE;
1776: x_is_relation_recursive := FND_API.G_FALSE;
1777: l_bsc_dim_level_rec.bsc_level_short_name := p_child_dimlvl_rec.dimension_level_short_name;
1778: l_bsc_dim_level_rec.bsc_parent_level_short_name := p_parent_dimlvl_rec.dimension_level_short_name;
1779:
1780: -- check if a direct parent-child relationship exists

Line 1789: IF ( ((x_return_status IS NULL) OR (x_return_status = FND_API.G_RET_STS_SUCCESS)) AND (x_bsc_dim_rel_info_rec.bsc_level_short_name IS NOT NULL) ) THEN -- This shows that relationship exists

1785: ,x_msg_count => x_msg_count
1786: ,x_msg_data => x_msg_data
1787: );
1788:
1789: IF ( ((x_return_status IS NULL) OR (x_return_status = FND_API.G_RET_STS_SUCCESS)) AND (x_bsc_dim_rel_info_rec.bsc_level_short_name IS NOT NULL) ) THEN -- This shows that relationship exists
1790: x_is_relationship_found := FND_API.G_TRUE;
1791: -- if parent child, then check for recursive relationship
1792: IF ( UPPER(p_child_dimlvl_rec.dimension_level_short_name) = UPPER(p_parent_dimlvl_rec.dimension_level_short_name) ) THEN
1793: x_is_relation_recursive := FND_API.G_TRUE;

Line 1790: x_is_relationship_found := FND_API.G_TRUE;

1786: ,x_msg_data => x_msg_data
1787: );
1788:
1789: IF ( ((x_return_status IS NULL) OR (x_return_status = FND_API.G_RET_STS_SUCCESS)) AND (x_bsc_dim_rel_info_rec.bsc_level_short_name IS NOT NULL) ) THEN -- This shows that relationship exists
1790: x_is_relationship_found := FND_API.G_TRUE;
1791: -- if parent child, then check for recursive relationship
1792: IF ( UPPER(p_child_dimlvl_rec.dimension_level_short_name) = UPPER(p_parent_dimlvl_rec.dimension_level_short_name) ) THEN
1793: x_is_relation_recursive := FND_API.G_TRUE;
1794: END IF;

Line 1793: x_is_relation_recursive := FND_API.G_TRUE;

1789: IF ( ((x_return_status IS NULL) OR (x_return_status = FND_API.G_RET_STS_SUCCESS)) AND (x_bsc_dim_rel_info_rec.bsc_level_short_name IS NOT NULL) ) THEN -- This shows that relationship exists
1790: x_is_relationship_found := FND_API.G_TRUE;
1791: -- if parent child, then check for recursive relationship
1792: IF ( UPPER(p_child_dimlvl_rec.dimension_level_short_name) = UPPER(p_parent_dimlvl_rec.dimension_level_short_name) ) THEN
1793: x_is_relation_recursive := FND_API.G_TRUE;
1794: END IF;
1795: END IF;
1796:
1797: EXCEPTION

Line 1817: IF ((p_dim_rel_info_rec.parent_level_short_name IS NOT NULL) AND (p_is_relation_recursive IS NULL OR p_is_relation_recursive = FND_API.G_FALSE)) THEN

1813: l_created_by_parent NUMBER;
1814: BEGIN
1815: SELECT created_by INTO l_created_by FROM bis_levels WHERE short_name = p_dim_rel_info_rec.dimension_level_short_name;
1816:
1817: IF ((p_dim_rel_info_rec.parent_level_short_name IS NOT NULL) AND (p_is_relation_recursive IS NULL OR p_is_relation_recursive = FND_API.G_FALSE)) THEN
1818: SELECT created_by INTO l_created_by_parent FROM bis_levels WHERE short_name = p_dim_rel_info_rec.parent_level_short_name;
1819: ELSE
1820: l_created_by_parent := l_created_by;
1821: END IF;

Line 1860: RAISE FND_API.G_EXC_ERROR;

1856: IF (c_dim_source%NOTFOUND) THEN
1857: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');
1858: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_short_name);
1859: FND_MSG_PUB.ADD;
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862: CLOSE c_dim_source;
1863:
1864: RETURN l_source;

Line 1871: RAISE FND_API.G_EXC_ERROR;

1867: WHEN OTHERS THEN
1868: IF ( c_dim_source%ISOPEN) THEN
1869: CLOSE c_dim_source;
1870: END IF;
1871: RAISE FND_API.G_EXC_ERROR;
1872: END get_source;
1873:
1874: --=================================================================
1875: FUNCTION needs_time_cols (

Line 1939: x_return_status := FND_API.G_RET_STS_SUCCESS;

1935:
1936: /* 3388371- gbhaloti FOR BSC LEVELS */
1937: --l_bsc_source VARCHAR(10);
1938: BEGIN
1939: x_return_status := FND_API.G_RET_STS_SUCCESS;
1940:
1941: /* 3388371- gbhaloti FOR BSC LEVELS */
1942: --l_bsc_source := get_dim_level_source (p_Dim_Level_Short_Name);
1943:

Line 1954: RAISE FND_API.G_EXC_ERROR;

1950: IF (c_bis_levels_source%NOTFOUND) THEN
1951: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');
1952: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_Dim_Level_Short_Name);
1953: FND_MSG_PUB.ADD;
1954: RAISE FND_API.G_EXC_ERROR;
1955: END IF;
1956: CLOSE c_bis_levels_source;
1957:
1958: IF ((p_Source = G_EDW) AND (l_data_source IS NULL)) THEN

Line 1976: RAISE FND_API.G_EXC_ERROR;

1972: ELSE
1973: IF (l_data_source IS NULL) THEN -- check - should use existing API
1974: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_NULL_DATA_SOURCE');
1975: FND_MSG_PUB.ADD;
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;
1978: x_id_name := G_ID_NAME;
1979: x_value_name := G_VALUE_NAME;
1980: x_table_name := l_data_source;

Line 1984: WHEN FND_API.G_EXC_ERROR THEN

1980: x_table_name := l_data_source;
1981: END IF;
1982:
1983: EXCEPTION
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: IF ( c_bis_levels_source%ISOPEN) THEN
1986: CLOSE c_bis_levels_source;
1987: END IF;
1988: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1988: x_return_status := FND_API.G_RET_STS_ERROR;

1984: WHEN FND_API.G_EXC_ERROR THEN
1985: IF ( c_bis_levels_source%ISOPEN) THEN
1986: CLOSE c_bis_levels_source;
1987: END IF;
1988: x_return_status := FND_API.G_RET_STS_ERROR;
1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => x_msg_count,
1991: p_data => x_msg_data
1992: );

Line 1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => x_msg_count,
1991: p_data => x_msg_data
1992: );
1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: IF ( c_bis_levels_source%ISOPEN) THEN
1995: CLOSE c_bis_levels_source;
1996: END IF;
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: IF ( c_bis_levels_source%ISOPEN) THEN
1995: CLOSE c_bis_levels_source;
1996: END IF;
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1998: FND_MSG_PUB.Count_And_Get
1999: ( p_count => x_msg_count,
2000: p_data => x_msg_data
2001: );

Line 2006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2002: WHEN OTHERS THEN
2003: IF ( c_bis_levels_source%ISOPEN) THEN
2004: CLOSE c_bis_levels_source;
2005: END IF;
2006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2007: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2008: FND_MSG_PUB.Add_Exc_Msg
2009: (G_PKG_NAME,
2010: 'GET_OLTP_EDW_COLS'

Line 2046: RAISE FND_API.G_EXC_ERROR;

2042: IF (c_dim_source%NOTFOUND) THEN
2043: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');
2044: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_short_name);
2045: FND_MSG_PUB.ADD;
2046: RAISE FND_API.G_EXC_ERROR;
2047: END IF;
2048: CLOSE c_dim_source;
2049:
2050: RETURN l_source;

Line 2057: RAISE FND_API.G_EXC_ERROR;

2053: WHEN OTHERS THEN
2054: IF ( c_dim_source%ISOPEN) THEN
2055: CLOSE c_dim_source;
2056: END IF;
2057: RAISE FND_API.G_EXC_ERROR;
2058: END get_dim_level_source;
2059:
2060:
2061: PROCEDURE Get_Bsc_Dim_Obj_details

Line 2113: x_return_status := FND_API.G_RET_STS_SUCCESS;

2109: l_count NUMBER :=0;
2110:
2111: BEGIN
2112: FND_MSG_PUB.INITIALIZE;
2113: x_return_status := FND_API.G_RET_STS_SUCCESS;
2114:
2115: l_dimlevel_short_name := p_dim_rel_info_rec.dimension_level_short_name;
2116: l_parent_dimlevel_short_name := p_dim_rel_info_rec.parent_level_short_name;
2117: l_relation_type := p_dim_rel_info_rec.relation_type;

Line 2148: RAISE FND_API.G_EXC_ERROR;

2144: IF (c_bsc_level_metadata%NOTFOUND) THEN
2145: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');
2146: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_dimlevel_short_name);
2147: FND_MSG_PUB.ADD;
2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;
2150: CLOSE c_bsc_level_metadata;
2151:
2152: IF (l_parent_dimlevel_short_name IS NOT NULL) THEN

Line 2159: RAISE FND_API.G_EXC_ERROR;

2155: IF (c_bsc_level_metadata%NOTFOUND) THEN
2156: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');
2157: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_parent_dimlevel_short_name);
2158: FND_MSG_PUB.ADD;
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161: CLOSE c_bsc_level_metadata;
2162: END IF;
2163: ELSE

Line 2171: RAISE FND_API.G_EXC_ERROR;

2167: IF (c_bsc_obj_dim_level_metadata%NOTFOUND) THEN
2168: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');
2169: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_parent_dimlevel_short_name);
2170: FND_MSG_PUB.ADD;
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2173: CLOSE c_bsc_obj_dim_level_metadata;
2174: END IF;
2175: END IF;

Line 2184: WHEN FND_API.G_EXC_ERROR THEN

2180: x_parent_level_view_name:= l_parent_level_view_name;
2181:
2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN
2185: IF (c_bsc_level_metadata%ISOPEN) THEN
2186: CLOSE c_bsc_level_metadata;
2187: END IF;
2188: IF (c_bsc_obj_dim_level_metadata%ISOPEN) THEN

Line 2191: x_return_status := FND_API.G_RET_STS_ERROR;

2187: END IF;
2188: IF (c_bsc_obj_dim_level_metadata%ISOPEN) THEN
2189: CLOSE c_bsc_obj_dim_level_metadata;
2190: END IF;
2191: x_return_status := FND_API.G_RET_STS_ERROR;
2192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2193: ,p_data => x_msg_data);
2194: WHEN OTHERS THEN
2195: IF (c_bsc_level_metadata%ISOPEN) THEN

Line 2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2197: END IF;
2198: IF (c_bsc_obj_dim_level_metadata%ISOPEN) THEN
2199: CLOSE c_bsc_obj_dim_level_metadata;
2200: END IF;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2203: ,p_data => x_msg_data);
2204:
2205: END Get_Bsc_Dim_Obj_details;