78: end loop;
79: */
80:
81: if p_Bsc_Pmf_Ui_Rec.Kpi_Id is null then
82: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
83: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Pmf_Ui_Rec.Kpi_Id);
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_ERROR;
86: end if;
79: */
80:
81: if p_Bsc_Pmf_Ui_Rec.Kpi_Id is null then
82: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
83: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Pmf_Ui_Rec.Kpi_Id);
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_ERROR;
86: end if;
87:
189:
190: begin
191:
192: if p_Bsc_Pmf_Ui_Rec.Measure_Short_Name is null then
193: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SHORT_NAME');
194: FND_MESSAGE.SET_TOKEN('BSC_SHORT_NAME', p_Bsc_Pmf_Ui_Rec.Measure_Short_Name);
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: end if;
190: begin
191:
192: if p_Bsc_Pmf_Ui_Rec.Measure_Short_Name is null then
193: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SHORT_NAME');
194: FND_MESSAGE.SET_TOKEN('BSC_SHORT_NAME', p_Bsc_Pmf_Ui_Rec.Measure_Short_Name);
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: end if;
198:
511: raise;
512: WHEN OTHERS THEN
513: rollback;
514: if g_invalid_level is not null then
515: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');
516: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', g_invalid_level);
517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: else
512: WHEN OTHERS THEN
513: rollback;
514: if g_invalid_level is not null then
515: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');
516: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', g_invalid_level);
517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: else
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: --DBMS_OUTPUT.PUT_LINE('Populate_Bsc_Pmf_Dim_Rec XX x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name = ' || x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name );
1323:
1324: -- Included to fixed bug 2382059
1325: IF (NOT BSC_UTILITY.is_Table_View_Exists(x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name)) THEN
1326: FND_MESSAGE.SET_NAME('BSC','BSC_PMF_LEVEL_NOT_EXISTS');
1327: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name);
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1323:
1324: -- Included to fixed bug 2382059
1325: IF (NOT BSC_UTILITY.is_Table_View_Exists(x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name)) THEN
1326: FND_MESSAGE.SET_NAME('BSC','BSC_PMF_LEVEL_NOT_EXISTS');
1327: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name);
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1331: -- Included to fixed bug 2382059