APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on FND_MSG_PUB

Line 287: FND_MSG_PUB.initialize;

283: /* 3388371- gbhaloti FOR BSC LEVELS */
284: -- l_bsc_source VARCHAR(10);
285:
286: BEGIN
287: FND_MSG_PUB.initialize;
288: -- Reuse the value from the global record if it is the same dimension level
289: IF (IS_DIM_LVL_INFO_CACHED (p_DimLevelSName => p_DimLevelName
290: ,x_Select_String => x_Select_String
291: ,x_table_name => x_table_name

Line 311: FND_MSG_PUB.ADD;

307: FETCH c_dims INTO l_Source, l_level_Values_view_name;
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')

Line 362: FND_MSG_PUB.Count_And_Get

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: );
366:

Line 369: FND_MSG_PUB.Count_And_Get

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: );
373: WHEN OTHERS THEN

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

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,
379: l_api_name

Line 377: FND_MSG_PUB.Add_Exc_Msg

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,
379: l_api_name
380: );
381: END IF;

Line 382: FND_MSG_PUB.Count_And_Get

378: ( G_PKG_NAME,
379: l_api_name
380: );
381: END IF;
382: FND_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count,
384: p_data => x_msg_data
385: );
386: END;

Line 448: FND_MSG_PUB.initialize;

444:
445: /* 3388371- gbhaloti FOR BSC LEVELS */
446: -- l_bsc_source VARCHAR(10);
447: BEGIN
448: FND_MSG_PUB.initialize;
449: -- Reuse the value from the global record if it is the same dimension level
450: IF (IS_DIM_LVL_INFO_CACHED (p_DimLevelSName => p_DimLevelName
451: ,x_Select_String => x_Select_String
452: ,x_table_name => x_table_name

Line 474: FND_MSG_PUB.ADD;

470: FETCH c_dims INTO l_Source, l_level_values_view_name;
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;

Line 525: FND_MSG_PUB.Count_And_Get

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: );
529:

Line 532: FND_MSG_PUB.Count_And_Get

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: );
536: WHEN OTHERS THEN

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

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,
542: l_api_name

Line 540: FND_MSG_PUB.Add_Exc_Msg

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,
542: l_api_name
543: );
544: END IF;

Line 545: FND_MSG_PUB.Count_And_Get

541: ( G_PKG_NAME,
542: l_api_name
543: );
544: END IF;
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: END;

Line 636: FND_MSG_PUB.ADD;

632: USING p_dim_level_name;
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

Line 654: FND_MSG_PUB.ADD;

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;
655: END IF;
656: IF (SQLCODE= -904) THEN
657: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_PK_KEY');
658: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);

Line 659: FND_MSG_PUB.ADD;

655: END IF;
656: IF (SQLCODE= -904) THEN
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,

Line 662: FND_MSG_PUB.Count_And_Get

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: );
666: END;

Line 681: FND_MSG_PUB.ADD;

677: EXCEPTION
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';

Line 694: FND_MSG_PUB.ADD;

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;
695: END IF;
696: IF (SQLCODE= -904) THEN
697: FND_MESSAGE.SET_NAME ('BIS', 'BIS_INVALID_EDW_PK_KEY');
698: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

Line 699: FND_MSG_PUB.ADD;

695: END IF;
696: IF (SQLCODE= -904) THEN
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';

Line 733: FND_MSG_PUB.ADD;

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;
734: END IF;
735: IF (SQLCODE= -904) THEN
736: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_START_DATE');
737: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);

Line 738: FND_MSG_PUB.ADD;

734: END IF;
735: IF (SQLCODE= -904) THEN
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';

Line 751: FND_MSG_PUB.ADD;

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;
752: END IF;
753: IF (SQLCODE= -904) THEN
754: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_END_DATEY');
755: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);

Line 756: FND_MSG_PUB.ADD;

752: END IF;
753: IF (SQLCODE= -904) THEN
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:

Line 773: FND_MSG_PUB.ADD;

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;
774: END IF;
775: IF (SQLCODE= -904) THEN
776: FND_MESSAGE.SET_NAME ('BIS', 'BIS_INVALID_VALUE');
777: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

Line 778: FND_MSG_PUB.ADD;

774: END IF;
775: IF (SQLCODE= -904) THEN
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:

Line 789: FND_MSG_PUB.Count_And_Get

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: );
793:

Line 798: FND_MSG_PUB.Count_And_Get

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: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 804: FND_MSG_PUB.Count_And_Get

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: );
808: WHEN OTHERS THEN

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

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,
814: l_api_name

Line 812: FND_MSG_PUB.Add_Exc_Msg

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,
814: l_api_name
815: );
816: END IF;

Line 817: FND_MSG_PUB.Count_And_Get

813: (G_PKG_NAME,
814: l_api_name
815: );
816: END IF;
817: FND_MSG_PUB.Count_And_Get
818: (p_count => x_msg_count,
819: p_data => x_msg_data
820: );
821: END;

Line 899: FND_MSG_PUB.ADD;

895: FETCH c_dimlvls INTO l_lvlshortname, l_dimshortname, l_levelvalueview, l_pmfBscSource, l_bscLevelViewName;
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

Line 979: FND_MSG_PUB.Count_And_Get

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
982: );
983:

Line 989: FND_MSG_PUB.Count_And_Get

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: );
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 995: FND_MSG_PUB.Count_And_Get

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: );
999: WHEN NO_DATA_FOUND THEN

Line 1001: FND_MSG_PUB.Count_And_Get

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: );
1005: WHEN OTHERS THEN

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

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,
1011: l_api_name

Line 1009: FND_MSG_PUB.Add_Exc_Msg

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,
1011: l_api_name
1012: );
1013: END IF;

Line 1014: FND_MSG_PUB.Count_And_Get

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

Line 1046: FND_MSG_PUB.initialize;

1042: l_description BIS_LEVELS_VL.DESCRIPTION%TYPE;
1043: l_time_level VARCHAR2(2001);
1044: l_level_values_view_name VARCHAR2(32000);
1045: BEGIN
1046: FND_MSG_PUB.initialize;
1047: OPEN c_dims;
1048: FETCH c_dims INTO l_Source,l_level_name, l_description,l_short_name,l_level_values_view_name;
1049: IF (c_dims%NOTFOUND) THEN
1050: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');

Line 1052: FND_MSG_PUB.ADD;

1048: FETCH c_dims INTO l_Source,l_level_name, l_description,l_short_name,l_level_values_view_name;
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')

Line 1091: FND_MSG_PUB.Count_And_Get

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: );
1095:

Line 1098: FND_MSG_PUB.Count_And_Get

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: );
1102: WHEN OTHERS THEN

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

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,
1108: l_api_name

Line 1106: FND_MSG_PUB.Add_Exc_Msg

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,
1108: l_api_name
1109: );
1110: END IF;

Line 1111: FND_MSG_PUB.Count_And_Get

1107: ( G_PKG_NAME,
1108: l_api_name
1109: );
1110: END IF;
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115: END;

Line 1384: FND_MSG_PUB.ADD;

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;
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

Line 1410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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;
1414: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1414: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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:
1418: --==================================================================

Line 1508: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1513: 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:
1517: --================================================================

Line 1594: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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;
1598: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1598: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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:
1602: --================================================================

Line 1674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1679: 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
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1684: 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:
1688: --===================================================================

Line 1859: FND_MSG_PUB.ADD;

1855: FETCH c_dim_source INTO l_source ;
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:

Line 1953: FND_MSG_PUB.ADD;

1949: FETCH c_bis_levels_source INTO l_data_source ;
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:

Line 1975: FND_MSG_PUB.ADD;

1971:
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;

Line 1989: FND_MSG_PUB.Count_And_Get

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: );
1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1998: FND_MSG_PUB.Count_And_Get

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: );
2002: WHEN OTHERS THEN

Line 2007: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) 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'
2011: );

Line 2008: FND_MSG_PUB.Add_Exc_Msg

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'
2011: );
2012: END IF;

Line 2013: FND_MSG_PUB.Count_And_Get

2009: (G_PKG_NAME,
2010: 'GET_OLTP_EDW_COLS'
2011: );
2012: END IF;
2013: FND_MSG_PUB.Count_And_Get
2014: (p_count => x_msg_count,
2015: p_data => x_msg_data
2016: );
2017: END get_oltp_edw_cols;

Line 2045: FND_MSG_PUB.ADD;

2041: FETCH c_dim_source INTO l_source ;
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:

Line 2112: FND_MSG_PUB.INITIALIZE;

2108: l_indicator bsc_kpis_b.indicator%TYPE;
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;

Line 2147: FND_MSG_PUB.ADD;

2143: FETCH c_bsc_level_metadata INTO l_child_level_pk_col, l_child_level_view_name;
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:

Line 2158: FND_MSG_PUB.ADD;

2154: FETCH c_bsc_level_metadata INTO l_parent_level_pk_col, l_parent_level_view_name;
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;

Line 2170: FND_MSG_PUB.ADD;

2166: FETCH c_bsc_obj_dim_level_metadata INTO l_parent_level_pk_col, l_parent_level_view_name;
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;

Line 2192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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
2196: CLOSE c_bsc_level_metadata;

Line 2202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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;
2206: