DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on FND_MESSAGE

Line 1091: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');

1087: and a.tab_id = d.tab_id
1088: and b.name = c.name
1089: and c.indicator = p_kpi_id;
1090:
1091: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
1092: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);
1093: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);
1094: FND_MSG_PUB.ADD;
1095: RAISE FND_API.G_EXC_ERROR;

Line 1092: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);

1088: and b.name = c.name
1089: and c.indicator = p_kpi_id;
1090:
1091: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
1092: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);
1093: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);
1094: FND_MSG_PUB.ADD;
1095: RAISE FND_API.G_EXC_ERROR;
1096: end if;

Line 1093: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);

1089: and c.indicator = p_kpi_id;
1090:
1091: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
1092: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);
1093: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);
1094: FND_MSG_PUB.ADD;
1095: RAISE FND_API.G_EXC_ERROR;
1096: end if;
1097:

Line 1573: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

1569: OPEN c_Tab_Name;
1570: FETCH c_Tab_Name INTO l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name;
1571: CLOSE c_Tab_Name;
1572: IF (l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name IS NULL) THEN
1573: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1574: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);
1575: FND_MSG_PUB.ADD;
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;

Line 1574: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);

1570: FETCH c_Tab_Name INTO l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name;
1571: CLOSE c_Tab_Name;
1572: IF (l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name IS NULL) THEN
1573: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1574: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);
1575: FND_MSG_PUB.ADD;
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578: IF ((p_tab_name IS NOT NULL) AND (l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name <> p_tab_name)) THEN

Line 1586: FND_MESSAGE.SET_NAME('BSC', 'BSC_TAB_NAME_EXISTS');

1582: FROM BSC_TABS_VL
1583: WHERE Tab_Id <> l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
1584: AND UPPER(Name) = UPPER(l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
1585: IF (l_Count <> 0) THEN
1586: FND_MESSAGE.SET_NAME('BSC', 'BSC_TAB_NAME_EXISTS');
1587: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
1588: FND_MSG_PUB.ADD;
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;

Line 1587: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);

1583: WHERE Tab_Id <> l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
1584: AND UPPER(Name) = UPPER(l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
1585: IF (l_Count <> 0) THEN
1586: FND_MESSAGE.SET_NAME('BSC', 'BSC_TAB_NAME_EXISTS');
1587: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
1588: FND_MSG_PUB.ADD;
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591: END IF;

Line 2503: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');

2499: from BSC_KPIS_TL
2500: where upper(name) = upper(l_kpi_name));
2501: -- if there are kpis in this tab which have the same name it throws an error.
2502: if l_same_name <> 0 then
2503: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
2504: FND_MESSAGE.SET_TOKEN('Indicator name: ', l_kpi_name);
2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: end if;

Line 2504: FND_MESSAGE.SET_TOKEN('Indicator name: ', l_kpi_name);

2500: where upper(name) = upper(l_kpi_name));
2501: -- if there are kpis in this tab which have the same name it throws an error.
2502: if l_same_name <> 0 then
2503: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
2504: FND_MESSAGE.SET_TOKEN('Indicator name: ', l_kpi_name);
2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: end if;
2508:

Line 2886: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_PROD_UNASSIGN');

2882: -- if l_kpi_count is one then
2883: -- Check The Production Flag for The Master KPI
2884: IF (l_is_obj_in_production) THEN
2885: l_unassiged := 0;
2886: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_PROD_UNASSIGN');
2887: FND_MSG_PUB.ADD;
2888: RAISE FND_API.G_EXC_ERROR;
2889: ELSE
2890: IF (l_Simulation_Tree_flag = 0) THEN

Line 2959: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MASTER_DELETE');

2955: END IF;
2956: ELSE
2957: -- If there is more than one Share KPI user can not unassign the Master KPI from de Tab
2958: l_unassiged := 0;
2959: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MASTER_DELETE');
2960: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2961: FND_MSG_PUB.ADD;
2962: RAISE FND_API.G_EXC_ERROR;
2963: end if;

Line 2960: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2956: ELSE
2957: -- If there is more than one Share KPI user can not unassign the Master KPI from de Tab
2958: l_unassiged := 0;
2959: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MASTER_DELETE');
2960: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2961: FND_MSG_PUB.ADD;
2962: RAISE FND_API.G_EXC_ERROR;
2963: end if;
2964: end if;

Line 3289: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_CHANGED');

3285:
3286: IF p_time_stamp_to_check IS NOT NULL then
3287: l_time_stamp := get_KPI_Time_Stamp(p_kpi_id);
3288: IF l_time_stamp IS NULL or l_time_stamp <> p_time_stamp_to_check then
3289: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_CHANGED');
3290: FND_MSG_PUB.ADD;
3291: RAISE FND_API.G_EXC_ERROR;
3292: END if;
3293: ELSE

Line 3388: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_CHANGED');

3384:
3385: IF p_time_stamp_to_check IS NOT NULL then
3386: l_time_stamp := get_KPI_Time_Stamp(p_kpi_id);
3387: IF l_time_stamp IS NULL or l_time_stamp <> p_time_stamp_to_check then
3388: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_CHANGED');
3389: FND_MSG_PUB.ADD;
3390: RAISE FND_API.G_EXC_ERROR;
3391: END if;
3392: ELSE

Line 3625: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');

3621: if l_count = 0 then
3622: -- l_count = 0 means the option does not exist
3623: --DBMS_OUTPUT.PUT_LINE('--BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec - BSC_NO_VALUE_FOUND ');
3624: FND_MSG_PUB.Initialize;
3625: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3626: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', 'Populate_Option_Dependency_Rec');
3627: FND_MSG_PUB.ADD;
3628: RAISE FND_API.G_EXC_ERROR;
3629: end if;

Line 3626: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', 'Populate_Option_Dependency_Rec');

3622: -- l_count = 0 means the option does not exist
3623: --DBMS_OUTPUT.PUT_LINE('--BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec - BSC_NO_VALUE_FOUND ');
3624: FND_MSG_PUB.Initialize;
3625: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3626: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', 'Populate_Option_Dependency_Rec');
3627: FND_MSG_PUB.ADD;
3628: RAISE FND_API.G_EXC_ERROR;
3629: end if;
3630:

Line 3743: FND_MESSAGE.SET_NAME('BSC',p_new_msg_name);

3739: if instr(x_msg_data, p_msg_name) <> 0 then
3740: if p_initialize_flag = 'Y' then
3741: FND_MSG_PUB.Initialize;
3742: end if;
3743: FND_MESSAGE.SET_NAME('BSC',p_new_msg_name);
3744: IF p_token1 is not null then
3745: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);
3746: end if;
3747: IF p_token2 is not null then

Line 3745: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);

3741: FND_MSG_PUB.Initialize;
3742: end if;
3743: FND_MESSAGE.SET_NAME('BSC',p_new_msg_name);
3744: IF p_token1 is not null then
3745: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);
3746: end if;
3747: IF p_token2 is not null then
3748: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);
3749: end if;

Line 3748: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);

3744: IF p_token1 is not null then
3745: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);
3746: end if;
3747: IF p_token2 is not null then
3748: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);
3749: end if;
3750: FND_MSG_PUB.ADD;
3751: if p_sys_admin_flag = 'Y' then
3752: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');

Line 3752: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');

3748: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);
3749: end if;
3750: FND_MSG_PUB.ADD;
3751: if p_sys_admin_flag = 'Y' then
3752: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');
3753: FND_MSG_PUB.ADD;
3754: end if;
3755: RAISE FND_API.G_EXC_ERROR;
3756: end if;

Line 3761: FND_MESSAGE.SET_NAME('BSC', p_new_msg_name);

3757: elsif p_new_msg_name is not null then
3758: if p_initialize_flag = 'Y' then
3759: FND_MSG_PUB.Initialize;
3760: end if;
3761: FND_MESSAGE.SET_NAME('BSC', p_new_msg_name);
3762: IF p_token1 is not null then
3763: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);
3764: end if;
3765: IF p_token2 is not null then

Line 3763: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);

3759: FND_MSG_PUB.Initialize;
3760: end if;
3761: FND_MESSAGE.SET_NAME('BSC', p_new_msg_name);
3762: IF p_token1 is not null then
3763: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);
3764: end if;
3765: IF p_token2 is not null then
3766: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);
3767: end if;

Line 3766: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);

3762: IF p_token1 is not null then
3763: FND_MESSAGE.SET_TOKEN(p_token1, p_token1_value);
3764: end if;
3765: IF p_token2 is not null then
3766: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);
3767: end if;
3768: FND_MSG_PUB.ADD;
3769: if p_sys_admin_flag = 'Y' then
3770: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');

Line 3770: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');

3766: FND_MESSAGE.SET_TOKEN(p_token2, p_token2_value);
3767: end if;
3768: FND_MSG_PUB.ADD;
3769: if p_sys_admin_flag = 'Y' then
3770: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');
3771: FND_MSG_PUB.ADD;
3772: end if;
3773: if x_return_status = FND_API.G_RET_STS_ERROR then
3774: RAISE FND_API.G_EXC_ERROR;

Line 3782: FND_MESSAGE.SET_NAME('BSC','BSC_WARNING_DIMREL_IMPORTERR');

3778: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3779: if p_initialize_flag = 'Y' then
3780: FND_MSG_PUB.Initialize;
3781: end if;
3782: FND_MESSAGE.SET_NAME('BSC','BSC_WARNING_DIMREL_IMPORTERR');
3783: FND_MESSAGE.SET_TOKEN('RETURN_STATUS', x_return_status);
3784: FND_MESSAGE.SET_TOKEN('RETURN_MESSAGE', x_msg_data);
3785: FND_MSG_PUB.ADD;
3786: if p_sys_admin_flag = 'Y' then

Line 3783: FND_MESSAGE.SET_TOKEN('RETURN_STATUS', x_return_status);

3779: if p_initialize_flag = 'Y' then
3780: FND_MSG_PUB.Initialize;
3781: end if;
3782: FND_MESSAGE.SET_NAME('BSC','BSC_WARNING_DIMREL_IMPORTERR');
3783: FND_MESSAGE.SET_TOKEN('RETURN_STATUS', x_return_status);
3784: FND_MESSAGE.SET_TOKEN('RETURN_MESSAGE', x_msg_data);
3785: FND_MSG_PUB.ADD;
3786: if p_sys_admin_flag = 'Y' then
3787: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');

Line 3784: FND_MESSAGE.SET_TOKEN('RETURN_MESSAGE', x_msg_data);

3780: FND_MSG_PUB.Initialize;
3781: end if;
3782: FND_MESSAGE.SET_NAME('BSC','BSC_WARNING_DIMREL_IMPORTERR');
3783: FND_MESSAGE.SET_TOKEN('RETURN_STATUS', x_return_status);
3784: FND_MESSAGE.SET_TOKEN('RETURN_MESSAGE', x_msg_data);
3785: FND_MSG_PUB.ADD;
3786: if p_sys_admin_flag = 'Y' then
3787: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');
3788: FND_MSG_PUB.ADD;

Line 3787: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');

3783: FND_MESSAGE.SET_TOKEN('RETURN_STATUS', x_return_status);
3784: FND_MESSAGE.SET_TOKEN('RETURN_MESSAGE', x_msg_data);
3785: FND_MSG_PUB.ADD;
3786: if p_sys_admin_flag = 'Y' then
3787: FND_MESSAGE.SET_NAME('BSC','BSC_CONTACT_SYS_AD');
3788: FND_MSG_PUB.ADD;
3789: end if;
3790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3791: end if;

Line 4399: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARENT_TAB');

4395: if x_return_status = 'D' then
4396: -- set the rollback flag so as not to do a rollback.
4397: -- this will eventually be removed.
4398: l_rollback := 1;
4399: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARENT_TAB');
4400: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_parent_tab_id);
4401: FND_MSG_PUB.ADD;
4402: RAISE FND_API.G_EXC_ERROR;
4403: end if;

Line 4400: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_parent_tab_id);

4396: -- set the rollback flag so as not to do a rollback.
4397: -- this will eventually be removed.
4398: l_rollback := 1;
4399: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARENT_TAB');
4400: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_parent_tab_id);
4401: FND_MSG_PUB.ADD;
4402: RAISE FND_API.G_EXC_ERROR;
4403: end if;
4404:

Line 4414: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_SELF_REL');

4410: if p_tab_id = p_parent_tab_id then
4411: --get tab name to display error.
4412: select name into l_tab_name
4413: from BSC_TABS_VL where tab_id = p_tab_id;
4414: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_SELF_REL');
4415: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4416: FND_MSG_PUB.ADD;
4417: RAISE FND_API.G_EXC_ERROR;
4418: else

Line 4415: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);

4411: --get tab name to display error.
4412: select name into l_tab_name
4413: from BSC_TABS_VL where tab_id = p_tab_id;
4414: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_SELF_REL');
4415: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4416: FND_MSG_PUB.ADD;
4417: RAISE FND_API.G_EXC_ERROR;
4418: else
4419: --Evaluate circular parent reference to fixs bug 2406652--

Line 4423: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_CIRCULAR_REL');

4419: --Evaluate circular parent reference to fixs bug 2406652--
4420: l_return_value := BSC_SCORECARD_PUB.is_child_tab_of( p_parent_tab_id, p_tab_id );
4421: if l_return_value = FND_API.G_TRUE then
4422: --DBMS_OUTPUT.PUT_LINE(' Update_Tab_Parent l_return_value = ' || l_return_value );
4423: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_CIRCULAR_REL');
4424: select name into l_tab_name
4425: from BSC_TABS_VL where tab_id = p_tab_id;
4426: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4427: select name into l_tab_name

Line 4426: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);

4422: --DBMS_OUTPUT.PUT_LINE(' Update_Tab_Parent l_return_value = ' || l_return_value );
4423: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_CIRCULAR_REL');
4424: select name into l_tab_name
4425: from BSC_TABS_VL where tab_id = p_tab_id;
4426: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4427: select name into l_tab_name
4428: from BSC_TABS_VL where tab_id = p_parent_tab_id;
4429: FND_MESSAGE.SET_TOKEN('BSC_TABCHILD', l_tab_name);
4430: FND_MSG_PUB.ADD;

Line 4429: FND_MESSAGE.SET_TOKEN('BSC_TABCHILD', l_tab_name);

4425: from BSC_TABS_VL where tab_id = p_tab_id;
4426: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_tab_name);
4427: select name into l_tab_name
4428: from BSC_TABS_VL where tab_id = p_parent_tab_id;
4429: FND_MESSAGE.SET_TOKEN('BSC_TABCHILD', l_tab_name);
4430: FND_MSG_PUB.ADD;
4431: RAISE FND_API.G_EXC_ERROR;
4432: end if;
4433:

Line 5526: /*FND_MESSAGE.SET_NAME('BSC','BSC_D_KPI_AT_LEAST_1_PERIOD');

5522:
5523: IF(l_periodicity_ids IS NULL )THEN
5524: RETURN;
5525: -- It should give a message, but needs to be verified that it has no impact on Report Designer.
5526: /*FND_MESSAGE.SET_NAME('BSC','BSC_D_KPI_AT_LEAST_1_PERIOD');
5527: FND_MSG_PUB.ADD;
5528: RAISE FND_API.G_EXC_ERROR;*/
5529: END IF;
5530:

Line 5555: FND_MESSAGE.SET_NAME('BSC','BSC_D_ONE_PERIOD_IN_SIM_TREE');

5551:
5552: EXECUTE IMMEDIATE l_sql INTO l_count USING p_calendar_id;
5553:
5554: IF(l_count > 1) THEN
5555: FND_MESSAGE.SET_NAME('BSC','BSC_D_ONE_PERIOD_IN_SIM_TREE');
5556: FND_MSG_PUB.ADD;
5557: RAISE FND_API.G_EXC_ERROR;
5558: END IF;
5559: END IF;*/

Line 5967: FND_MESSAGE.SET_NAME('BIS',l_msg_data);

5963: , x_msg_data => l_msg_data);
5964:
5965: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
5966: FND_MSG_PUB.Initialize;
5967: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
5968: FND_MSG_PUB.ADD;
5969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5970: END IF;
5971:

Line 5973: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_VIEW_ERR');

5969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5970: END IF;
5971:
5972: IF (l_exist_dependency = FND_API.G_TRUE) THEN
5973: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_VIEW_ERR');
5974: FND_MESSAGE.SET_TOKEN('SCR_NAME', l_scr_name);
5975: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);
5976: FND_MSG_PUB.ADD;
5977: FND_MSG_PUB.Count_And_Get(

Line 5974: FND_MESSAGE.SET_TOKEN('SCR_NAME', l_scr_name);

5970: END IF;
5971:
5972: IF (l_exist_dependency = FND_API.G_TRUE) THEN
5973: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_VIEW_ERR');
5974: FND_MESSAGE.SET_TOKEN('SCR_NAME', l_scr_name);
5975: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);
5976: FND_MSG_PUB.ADD;
5977: FND_MSG_PUB.Count_And_Get(
5978: p_encoded => FND_API.G_FALSE

Line 5975: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);

5971:
5972: IF (l_exist_dependency = FND_API.G_TRUE) THEN
5973: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_VIEW_ERR');
5974: FND_MESSAGE.SET_TOKEN('SCR_NAME', l_scr_name);
5975: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);
5976: FND_MSG_PUB.ADD;
5977: FND_MSG_PUB.Count_And_Get(
5978: p_encoded => FND_API.G_FALSE
5979: , p_count => x_msg_count

Line 5993: FND_MESSAGE.SET_NAME('BSC','BSC_AG_SCORECARD_DELETE');

5989:
5990: IF (l_Is_Ag_Type_Scorecard = FND_API.G_TRUE) THEN
5991: -- The scorecard, Report, Objective and Objective Group have the same name in
5992: -- an AG Report scenario.
5993: FND_MESSAGE.SET_NAME('BSC','BSC_AG_SCORECARD_DELETE');
5994: FND_MESSAGE.SET_TOKEN('SNAME', l_scr_name);
5995: FND_MESSAGE.SET_TOKEN('RNAME', l_scr_name);
5996: FND_MSG_PUB.ADD;
5997: ELSE

Line 5994: FND_MESSAGE.SET_TOKEN('SNAME', l_scr_name);

5990: IF (l_Is_Ag_Type_Scorecard = FND_API.G_TRUE) THEN
5991: -- The scorecard, Report, Objective and Objective Group have the same name in
5992: -- an AG Report scenario.
5993: FND_MESSAGE.SET_NAME('BSC','BSC_AG_SCORECARD_DELETE');
5994: FND_MESSAGE.SET_TOKEN('SNAME', l_scr_name);
5995: FND_MESSAGE.SET_TOKEN('RNAME', l_scr_name);
5996: FND_MSG_PUB.ADD;
5997: ELSE
5998: FOR cd_kpi_function IN c_Kpi_function LOOP

Line 5995: FND_MESSAGE.SET_TOKEN('RNAME', l_scr_name);

5991: -- The scorecard, Report, Objective and Objective Group have the same name in
5992: -- an AG Report scenario.
5993: FND_MESSAGE.SET_NAME('BSC','BSC_AG_SCORECARD_DELETE');
5994: FND_MESSAGE.SET_TOKEN('SNAME', l_scr_name);
5995: FND_MESSAGE.SET_TOKEN('RNAME', l_scr_name);
5996: FND_MSG_PUB.ADD;
5997: ELSE
5998: FOR cd_kpi_function IN c_Kpi_function LOOP
5999: -- call the procedure to get the parent objects for each KPI

Line 6005: FND_MESSAGE.SET_NAME('BIS',l_msg_data);

6001: l_objective_name := cd_kpi_function.name;
6002: l_parent_obj_table := BIS_RSG_PUB_API_PKG.GetParentObjects(l_dep_obj_name,'REPORT','PORTLET',l_ret_status,l_msg_data);
6003: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
6004: FND_MSG_PUB.Initialize;
6005: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
6006: FND_MSG_PUB.ADD;
6007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6008: ELSE
6009: IF (l_parent_obj_table.COUNT > 0) THEN

Line 6012: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DEP_OBJ');

6008: ELSE
6009: IF (l_parent_obj_table.COUNT > 0) THEN
6010: l_index := l_parent_obj_table.first;
6011: LOOP
6012: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DEP_OBJ');
6013: FND_MESSAGE.SET_TOKEN('OBJECTIVE',l_objective_name);
6014: FND_MESSAGE.SET_TOKEN('KPI_REGION',l_parent_obj_table(l_index).user_object_name);
6015: l_dep_obj_message := FND_MESSAGE.GET;
6016: IF l_index = l_parent_obj_table.first THEN

Line 6013: FND_MESSAGE.SET_TOKEN('OBJECTIVE',l_objective_name);

6009: IF (l_parent_obj_table.COUNT > 0) THEN
6010: l_index := l_parent_obj_table.first;
6011: LOOP
6012: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DEP_OBJ');
6013: FND_MESSAGE.SET_TOKEN('OBJECTIVE',l_objective_name);
6014: FND_MESSAGE.SET_TOKEN('KPI_REGION',l_parent_obj_table(l_index).user_object_name);
6015: l_dep_obj_message := FND_MESSAGE.GET;
6016: IF l_index = l_parent_obj_table.first THEN
6017: l_dep_obj_list := '

';
6025: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE');
6026: FND_MESSAGE.SET_TOKEN('SCR_NAME', l_scr_name);
6027: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST',l_dep_obj_list);
6028: FND_MSG_PUB.ADD;
6029: END IF;
6030: END IF;
6031: END LOOP;

Line 6133: FND_MESSAGE.SET_NAME('BIS',l_msg_data);

6129: ,x_msg_data => l_msg_data);
6130:
6131: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
6132: FND_MSG_PUB.Initialize;
6133: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
6134: FND_MSG_PUB.ADD;
6135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6136: END IF;
6137:

Line 6209: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

6205: ,x_msg_count => x_msg_count
6206: ,x_msg_data => x_msg_data);
6207: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
6208: FND_MSG_PUB.Initialize;
6209: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
6210: FND_MSG_PUB.ADD;
6211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6212: END IF;
6213: