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

Line 279: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

275: -- Validate level id exists.
276: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
277: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
278: if l_count = 0 then
279: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
280: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: end if;

Line 280: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

276: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
277: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
278: if l_count = 0 then
279: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
280: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: end if;
284: else

Line 285: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: end if;
284: else
285: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
286: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: end if;

Line 286: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

282: RAISE FND_API.G_EXC_ERROR;
283: end if;
284: else
285: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
286: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: end if;
290: IF ((l_Dim_Level_Rec.Bsc_Level_Name IS NOT NULL) OR

Line 454: FND_MESSAGE.SET_NAME('BSC','BSC_LEVEL_ID_EXISTS');

450: -- Validate Level Id not exists.
451: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
452: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
453: if l_count <> 0 then
454: FND_MESSAGE.SET_NAME('BSC','BSC_LEVEL_ID_EXISTS');
455: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
456: FND_MSG_PUB.ADD;
457: RAISE FND_API.G_EXC_ERROR;
458: end if;

Line 455: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

451: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
452: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
453: if l_count <> 0 then
454: FND_MESSAGE.SET_NAME('BSC','BSC_LEVEL_ID_EXISTS');
455: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
456: FND_MSG_PUB.ADD;
457: RAISE FND_API.G_EXC_ERROR;
458: end if;
459: else

Line 460: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

456: FND_MSG_PUB.ADD;
457: RAISE FND_API.G_EXC_ERROR;
458: end if;
459: else
460: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
461: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: end if;

Line 461: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

457: RAISE FND_API.G_EXC_ERROR;
458: end if;
459: else
460: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
461: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: end if;
465:

Line 581: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

577: RAISE;
578: WHEN OTHERS THEN
579: ROLLBACK TO CreateBSCDimLevMdPVT;
580: if (SQLCODE = -01400) then
581: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
582: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: end if;

Line 582: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);

578: WHEN OTHERS THEN
579: ROLLBACK TO CreateBSCDimLevMdPVT;
580: if (SQLCODE = -01400) then
581: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
582: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: end if;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 729: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

725: -- Check that valid level id was entered.
726: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
727: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
728: if l_count = 0 then
729: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
730: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
731: FND_MSG_PUB.ADD;
732: RAISE FND_API.G_EXC_ERROR;
733: end if;

Line 730: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

726: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
727: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
728: if l_count = 0 then
729: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
730: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
731: FND_MSG_PUB.ADD;
732: RAISE FND_API.G_EXC_ERROR;
733: end if;
734: else

Line 735: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

731: FND_MSG_PUB.ADD;
732: RAISE FND_API.G_EXC_ERROR;
733: end if;
734: else
735: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
736: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
737: FND_MSG_PUB.ADD;
738: RAISE FND_API.G_EXC_ERROR;
739: end if;

Line 736: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

732: RAISE FND_API.G_EXC_ERROR;
733: end if;
734: else
735: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
736: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
737: FND_MSG_PUB.ADD;
738: RAISE FND_API.G_EXC_ERROR;
739: end if;
740:

Line 1005: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

1001: -- Validate Level Id exists.
1002: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
1003: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
1004: if l_count <> 1 then
1005: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1006: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1007: FND_MSG_PUB.ADD;
1008: RAISE FND_API.G_EXC_ERROR;
1009: end if;

Line 1006: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

1002: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
1003: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
1004: if l_count <> 1 then
1005: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1006: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1007: FND_MSG_PUB.ADD;
1008: RAISE FND_API.G_EXC_ERROR;
1009: end if;
1010: else

Line 1011: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

1007: FND_MSG_PUB.ADD;
1008: RAISE FND_API.G_EXC_ERROR;
1009: end if;
1010: else
1011: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1012: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;

Line 1012: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

1008: RAISE FND_API.G_EXC_ERROR;
1009: end if;
1010: else
1011: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1012: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;
1016:

Line 1066: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

1062: WHEN OTHERS THEN
1063: ROLLBACK TO CreateBSCSysDimLevColsPVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: if (SQLCODE = -01400) then
1066: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1067: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: end if;

Line 1067: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);

1063: ROLLBACK TO CreateBSCSysDimLevColsPVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: if (SQLCODE = -01400) then
1066: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1067: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: end if;
1071: IF (x_msg_data IS NOT NULL) THEN

Line 1168: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

1164: -- Check that valid level id was entered.
1165: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
1166: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
1167: if l_count <> 1 then
1168: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1169: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1170: FND_MSG_PUB.ADD;
1171: RAISE FND_API.G_EXC_ERROR;
1172: end if;

Line 1169: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

1165: if p_Dim_Level_Rec.Bsc_Level_Id is not null then
1166: l_count := validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
1167: if l_count <> 1 then
1168: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1169: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1170: FND_MSG_PUB.ADD;
1171: RAISE FND_API.G_EXC_ERROR;
1172: end if;
1173: else

Line 1174: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

1170: FND_MSG_PUB.ADD;
1171: RAISE FND_API.G_EXC_ERROR;
1172: end if;
1173: else
1174: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1175: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1176: FND_MSG_PUB.ADD;
1177: RAISE FND_API.G_EXC_ERROR;
1178: end if;

Line 1175: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

1171: RAISE FND_API.G_EXC_ERROR;
1172: end if;
1173: else
1174: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1175: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1176: FND_MSG_PUB.ADD;
1177: RAISE FND_API.G_EXC_ERROR;
1178: end if;
1179:

Line 1182: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_COL_TYPE');

1178: end if;
1179:
1180: -- Level Column Type must be entered, if not raise error.
1181: if l_Dim_Level_Rec.Bsc_Level_Column_Type not in ('A', 'D', 'F', 'P', 'U') then
1182: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_COL_TYPE');
1183: FND_MESSAGE.SET_TOKEN('BSC_COL_TYPE', l_Dim_Level_Rec.Bsc_Level_Column_Type);
1184: FND_MSG_PUB.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: end if;

Line 1183: FND_MESSAGE.SET_TOKEN('BSC_COL_TYPE', l_Dim_Level_Rec.Bsc_Level_Column_Type);

1179:
1180: -- Level Column Type must be entered, if not raise error.
1181: if l_Dim_Level_Rec.Bsc_Level_Column_Type not in ('A', 'D', 'F', 'P', 'U') then
1182: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_COL_TYPE');
1183: FND_MESSAGE.SET_TOKEN('BSC_COL_TYPE', l_Dim_Level_Rec.Bsc_Level_Column_Type);
1184: FND_MSG_PUB.ADD;
1185: RAISE FND_API.G_EXC_ERROR;
1186: end if;
1187:

Line 1781: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

1777: IF ((p_Dim_Level_Rec.Bsc_Level_Id IS NOT NULL) AND (p_Dim_Level_Rec.Bsc_Parent_Level_Id IS NOT NULL)) THEN
1778:
1779: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1780: IF (l_count = 0) THEN
1781: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;

Line 1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

1778:
1779: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1780: IF (l_count = 0) THEN
1781: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;
1786:

Line 1789: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

1785: END IF;
1786:
1787: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1788: IF (l_count = 0) THEN
1789: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1790: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;

Line 1790: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);

1786:
1787: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1788: IF (l_count = 0) THEN
1789: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1790: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;
1794:

Line 1898: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

1894:
1895: END IF;
1896:
1897: ELSE
1898: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1899: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);
1900: FND_MSG_PUB.ADD;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;

Line 1899: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);

1895: END IF;
1896:
1897: ELSE
1898: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1899: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);
1900: FND_MSG_PUB.ADD;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903:

Line 2277: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

2273: -- Validate level id exists.
2274: IF ((p_Dim_Level_Rec.Bsc_Level_Id IS NOT NULL) AND (p_Dim_Level_Rec.Bsc_Parent_Level_Id IS NOT NULL)) THEN
2275: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
2276: IF (l_count = 0) THEN
2277: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2278: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
2279: FND_MSG_PUB.ADD;
2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;

Line 2278: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

2274: IF ((p_Dim_Level_Rec.Bsc_Level_Id IS NOT NULL) AND (p_Dim_Level_Rec.Bsc_Parent_Level_Id IS NOT NULL)) THEN
2275: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Level_Id);
2276: IF (l_count = 0) THEN
2277: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2278: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
2279: FND_MSG_PUB.ADD;
2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;
2282: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Parent_Level_Id);

Line 2284: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

2280: RAISE FND_API.G_EXC_ERROR;
2281: END IF;
2282: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2283: IF (l_count = 0) THEN
2284: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2285: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2286: FND_MSG_PUB.ADD;
2287: RAISE FND_API.G_EXC_ERROR;
2288: END IF;

Line 2285: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);

2281: END IF;
2282: l_count := BSC_DIMENSION_LEVELS_PVT.validate_dim_level_id(p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2283: IF (l_count = 0) THEN
2284: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2285: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
2286: FND_MSG_PUB.ADD;
2287: RAISE FND_API.G_EXC_ERROR;
2288: END IF;
2289: IF (cr_getId_rels%ISOPEN) THEN

Line 2312: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');

2308: FROM BSC_SYS_DIM_LEVELS_B
2309: WHERE short_name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
2310:
2311: IF (l_count = 0) THEN
2312: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
2313: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Level_Short_Name);
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;
2316: END IF;

Line 2313: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Level_Short_Name);

2309: WHERE short_name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
2310:
2311: IF (l_count = 0) THEN
2312: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
2313: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Level_Short_Name);
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;
2316: END IF;
2317:

Line 2325: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');

2321: FROM BSC_SYS_DIM_LEVELS_B
2322: WHERE short_name = p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
2323:
2324: IF (l_count = 0) THEN
2325: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
2326: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
2327: FND_MSG_PUB.ADD;
2328: RAISE FND_API.G_EXC_ERROR;
2329: END IF;

Line 2326: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);

2322: WHERE short_name = p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
2323:
2324: IF (l_count = 0) THEN
2325: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
2326: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
2327: FND_MSG_PUB.ADD;
2328: RAISE FND_API.G_EXC_ERROR;
2329: END IF;
2330: END IF;

Line 2350: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

2346: , x_Dim_Level_Rec.Bsc_Data_Source
2347: , x_Dim_Level_Rec.Bsc_Relation_Type;
2348: CLOSE cr_getName_rels;
2349: ELSE
2350: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
2351: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);
2352: FND_MSG_PUB.ADD;
2353: RAISE FND_API.G_EXC_ERROR;
2354: END IF;

Line 2351: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);

2347: , x_Dim_Level_Rec.Bsc_Relation_Type;
2348: CLOSE cr_getName_rels;
2349: ELSE
2350: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
2351: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', P_DIM_LEVEL_REC.BSC_LEVEL_ID);
2352: FND_MSG_PUB.ADD;
2353: RAISE FND_API.G_EXC_ERROR;
2354: END IF;
2355: EXCEPTION

Line 2470: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

2466: IF ((p_Child_level_Id IS NOT NULL) AND (p_Parent_level_Id IS NOT NULL)) THEN
2467:
2468: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Child_level_Id);
2469: IF (l_count = 0) THEN
2470: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2471: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2472: FND_MSG_PUB.ADD;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;

Line 2471: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);

2467:
2468: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Child_level_Id);
2469: IF (l_count = 0) THEN
2470: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2471: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2472: FND_MSG_PUB.ADD;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475:

Line 2478: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

2474: END IF;
2475:
2476: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Parent_level_Id);
2477: IF (l_count = 0) THEN
2478: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2479: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Parent_level_Id);
2480: FND_MSG_PUB.ADD;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;

Line 2479: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Parent_level_Id);

2475:
2476: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Parent_level_Id);
2477: IF (l_count = 0) THEN
2478: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2479: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Parent_level_Id);
2480: FND_MSG_PUB.ADD;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF;
2483:

Line 2535: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

2531: END IF;
2532: END IF;
2533:
2534: ELSE
2535: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
2536: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2537: FND_MSG_PUB.ADD;
2538: RAISE FND_API.G_EXC_ERROR;
2539: END IF;

Line 2536: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);

2532: END IF;
2533:
2534: ELSE
2535: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
2536: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2537: FND_MSG_PUB.ADD;
2538: RAISE FND_API.G_EXC_ERROR;
2539: END IF;
2540: