34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35: l_exist_dependency := FND_API.G_FALSE;
36:
37: IF (p_tab_id IS NULL) THEN
38: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
39: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
40: FND_MSG_PUB.ADD;
41: RAISE FND_API.G_EXC_ERROR;
42: END IF;
35: l_exist_dependency := FND_API.G_FALSE;
36:
37: IF (p_tab_id IS NULL) THEN
38: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
39: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
40: FND_MSG_PUB.ADD;
41: RAISE FND_API.G_EXC_ERROR;
42: END IF;
43:
41: RAISE FND_API.G_EXC_ERROR;
42: END IF;
43:
44: IF (p_tab_view_id IS NULL) THEN
45: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
46: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_VIEW_ID'), TRUE);
47: FND_MSG_PUB.ADD;
48: RAISE FND_API.G_EXC_ERROR;
49: END IF;
42: END IF;
43:
44: IF (p_tab_view_id IS NULL) THEN
45: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
46: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_VIEW_ID'), TRUE);
47: FND_MSG_PUB.ADD;
48: RAISE FND_API.G_EXC_ERROR;
49: END IF;
50:
55: -- do the validation that the tab_view_id cannot be -1,-2, 0 and 1
56: -- if yes then throw the exception that these views cannot be deleted.
57:
58: IF((l_CustView_Rec.Bsc_Tab_View_Id IS NOT NULL) AND (l_CustView_Rec.Bsc_Tab_View_Id<2)) THEN
59: FND_MESSAGE.SET_NAME('BSC','BSC_RES_VIEW_NOT_DELETE');
60: FND_MSG_PUB.ADD;
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63:
77: END IF;
78:
79: IF (l_exist_dependency IS NOT NULL) AND (l_exist_dependency = FND_API.G_TRUE) THEN
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_CUSTOMVIEW_ERR');
82: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
78:
79: IF (l_exist_dependency IS NOT NULL) AND (l_exist_dependency = FND_API.G_TRUE) THEN
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_CUSTOMVIEW_ERR');
82: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86:
173: FND_MSG_PUB.Initialize;
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: IF (p_tab_id IS NULL) THEN
177: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_VIEW_ID');
178: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
179: FND_MSG_PUB.ADD;
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: IF (p_tab_id IS NULL) THEN
177: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_VIEW_ID');
178: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
179: FND_MSG_PUB.ADD;
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
275: FND_MSG_PUB.Initialize;
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: IF (p_tab_id IS NULL) THEN
279: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_VIEW_ID');
280: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: IF (p_tab_id IS NULL) THEN
279: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_VIEW_ID');
280: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: IF (p_assign_views IS NOT NULL) THEN
365: FND_MSG_PUB.Initialize;
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:
368: IF (p_tab_id IS NULL) THEN
369: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_VIEW_ID');
370: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:
368: IF (p_tab_id IS NULL) THEN
369: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_VIEW_ID');
370: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: