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.BIS_PMF_GET_DIMLEVELS_PVT dependencies on FND_MESSAGE

Line 309: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');

305:
306: OPEN c_dims;
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;

Line 310: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_DimLevelName);

306: OPEN c_dims;
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;

Line 472: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');

468: --THEN
469: OPEN c_dims;
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;

Line 473: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_DimLevelName);

469: OPEN c_dims;
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;

Line 634: FND_MESSAGE.SET_NAME ('BIS','BIS_INVALID_LEVEL_SHORT_NAME');

630: EXECUTE IMMEDIATE l_dim_lvl_sql INTO
631: l_dimshortname, l_dimname,l_dimdesc, l_lvlshortname, l_lvlname, l_lvldesc, l_prefix
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;

Line 635: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);

631: l_dimshortname, l_dimname,l_dimdesc, l_lvlshortname, l_lvlname, l_lvldesc, l_prefix
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))

Line 652: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');

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

Line 653: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

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

Line 657: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_PK_KEY');

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);
659: FND_MSG_PUB.ADD;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;

Line 658: 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);
659: FND_MSG_PUB.ADD;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;
662: FND_MSG_PUB.Count_And_Get

Line 679: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_PK_KEY');

675:
676: EXECUTE IMMEDIATE l_pkkey_sql INTO l_pkkey USING l_lvlshortname_ltc;
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;

Line 680: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);

676: EXECUTE IMMEDIATE l_pkkey_sql INTO l_pkkey USING l_lvlshortname_ltc;
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 ;

Line 692: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');

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

Line 693: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

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

Line 697: FND_MESSAGE.SET_NAME ('BIS', 'BIS_INVALID_EDW_PK_KEY');

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);
699: FND_MSG_PUB.ADD;
700: END IF;
701: RAISE FND_API.G_EXC_ERROR;

Line 698: 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);
699: FND_MSG_PUB.ADD;
700: END IF;
701: RAISE FND_API.G_EXC_ERROR;
702: END;

Line 731: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');

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

Line 732: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

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

Line 736: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_START_DATE');

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);
738: FND_MSG_PUB.ADD;
739: END IF;
740: RAISE FND_API.G_EXC_ERROR;

Line 737: 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);
738: FND_MSG_PUB.ADD;
739: END IF;
740: RAISE FND_API.G_EXC_ERROR;
741: END;

Line 749: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');

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

Line 750: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

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

Line 754: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_EDW_END_DATEY');

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);
756: FND_MSG_PUB.ADD;
757: END IF;
758: RAISE FND_API.G_EXC_ERROR;

Line 755: 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);
756: FND_MSG_PUB.ADD;
757: END IF;
758: RAISE FND_API.G_EXC_ERROR;
759: END;

Line 771: FND_MESSAGE.SET_NAME ('BIS', 'BIS_NO_LTC_TABLE');

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

Line 772: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

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

Line 776: FND_MESSAGE.SET_NAME ('BIS', 'BIS_INVALID_VALUE');

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);
778: FND_MSG_PUB.ADD;
779: END IF;
780: RAISE FND_API.G_EXC_ERROR;

Line 777: 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);
778: FND_MSG_PUB.ADD;
779: END IF;
780: RAISE FND_API.G_EXC_ERROR;
781: END;

Line 897: FND_MESSAGE.SET_NAME('BIS', 'BIS_INVALID_LEVEL_SHORTNAME');

893:
894: OPEN c_dimlvls;
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;

Line 898: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_name);

894: OPEN c_dimlvls;
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;

Line 910: || BIS_UTILITIES_PVT.GET_FND_MESSAGE( 'BIS_ALL_VALUE_ROLLING' )

906: IF ( l_Is_Rolling_Period_Level = 1 ) THEN -- 2408906
907:
908: x_bis_select_string := ' select -1 Id, '
909: || ''''
910: || BIS_UTILITIES_PVT.GET_FND_MESSAGE( 'BIS_ALL_VALUE_ROLLING' )
911: || ''''
912: || ' Value, sysdate start_date, sysdate end_date from dual ' ;
913: -- ' select -1 Id, ' || '''All''' || ' Value from dual ' ;
914: -- ' select id, value, start_date, end_date from BIS_ROLLING_LEVEL_002 ' ;

Line 1050: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');

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

Line 1051: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_short_name);

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

Line 1383: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_REL_COL_NULL');

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;
1386: ELSE -- relationship is found - both BIS and BSC is handled by this API.
1387: get_select_string(

Line 1857: FND_MESSAGE.SET_NAME('BIS','BIS_INAVLID_LEVEL_SHORT_NAME');

1853:
1854: OPEN c_dim_source(cp_DimLevelName => p_dim_level_short_name );
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;

Line 1858: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_short_name);

1854: OPEN c_dim_source(cp_DimLevelName => p_dim_level_short_name );
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;

Line 1951: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');

1947:
1948: OPEN c_bis_levels_source(cp_dimLevel_short_name => p_Dim_Level_Short_Name );
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;

Line 1952: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_Dim_Level_Short_Name);

1948: OPEN c_bis_levels_source(cp_dimLevel_short_name => p_Dim_Level_Short_Name );
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;

Line 1974: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_NULL_DATA_SOURCE');

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

Line 2043: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');

2039:
2040: OPEN c_dim_source(cp_DimLevelName => p_dim_level_short_name );
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;

Line 2044: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', p_dim_level_short_name);

2040: OPEN c_dim_source(cp_DimLevelName => p_dim_level_short_name );
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;

Line 2145: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');

2141:
2142: OPEN c_bsc_level_metadata(l_dimlevel_short_name);
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;

Line 2146: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_dimlevel_short_name);

2142: OPEN c_bsc_level_metadata(l_dimlevel_short_name);
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;

Line 2156: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');

2152: IF (l_parent_dimlevel_short_name IS NOT NULL) THEN
2153: OPEN c_bsc_level_metadata(l_parent_dimlevel_short_name);
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;

Line 2157: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_parent_dimlevel_short_name);

2153: OPEN c_bsc_level_metadata(l_parent_dimlevel_short_name);
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;

Line 2168: FND_MESSAGE.SET_NAME('BIS','BIS_INVALID_LEVEL_SHORTNAME');

2164: IF (l_parent_dimlevel_short_name IS NOT NULL) THEN
2165: OPEN c_bsc_obj_dim_level_metadata(l_parent_dimlevel_short_name,l_indicator);
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;

Line 2169: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME', l_parent_dimlevel_short_name);

2165: OPEN c_bsc_obj_dim_level_metadata(l_parent_dimlevel_short_name,l_indicator);
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;