DBA Data[Home] [Help]

APPS.BSC_CALENDAR_PUB dependencies on FND_MESSAGE

Line 537: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_NAME_NULL');

533: FND_MSG_PUB.Initialize;
534: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
535: IF(p_Action = BSC_PERIODS_UTILITY_PKG.C_CREATE OR p_Action = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
536: IF(BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Calendar_Record.Name) = FND_API.G_TRUE) THEN
537: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_NAME_NULL');
538: FND_MSG_PUB.ADD;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: IF(BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Calendar_Record.Dim_Short_Name) = FND_API.G_TRUE) THEN

Line 542: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_NULL');

538: FND_MSG_PUB.ADD;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: IF(BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Calendar_Record.Dim_Short_Name) = FND_API.G_TRUE) THEN
542: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_NULL');
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: END IF;

Line 554: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_ID_EXISTS');

550: INTO l_count
551: FROM bsc_sys_calendars_b
552: WHERE TRIM(calendar_id) = TRIM(p_Calendar_Record.Calendar_Id);
553: IF(l_count > 0)THEN
554: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_ID_EXISTS');
555: FND_MSG_PUB.ADD;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558:

Line 564: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_EXISTS');

560: INTO l_count
561: FROM bsc_sys_calendars_vl
562: WHERE TRIM(NAME) = TRIM(p_Calendar_Record.Name);
563: IF(l_count > 0)THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_EXISTS');
565: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME',TRIM(p_Calendar_Record.Name));
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;

Line 565: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME',TRIM(p_Calendar_Record.Name));

561: FROM bsc_sys_calendars_vl
562: WHERE TRIM(NAME) = TRIM(p_Calendar_Record.Name);
563: IF(l_count > 0)THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_EXISTS');
565: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME',TRIM(p_Calendar_Record.Name));
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569:

Line 575: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_UNIQUE');

571: INTO l_count
572: FROM bsc_sys_calendars_b
573: WHERE TRIM(short_name) = TRIM(p_Calendar_Record.Dim_Short_Name);
574: IF( l_count > 0 ) THEN
575: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_UNIQUE');
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:

Line 582: FND_MESSAGE.SET_NAME('BSC','BSC_FISCAL_YEAR_NULL');

578: END IF;
579:
580: ELSIF(p_Action = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
581: IF(p_Calendar_Record.Fiscal_Year IS NULL) THEN
582: FND_MESSAGE.SET_NAME('BSC','BSC_FISCAL_YEAR_NULL');
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:

Line 593: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_UNIQUE');

589: FROM BSC_SYS_CALENDARS_B
590: WHERE CALENDAR_ID <> p_Calendar_Record.Calendar_Id
591: AND TRIM(short_name) = TRIM(p_Calendar_Record.Dim_Short_Name);
592: IF( l_count > 0 ) THEN
593: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_UNIQUE');
594: FND_MSG_PUB.ADD;
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597: ELSIF(p_Action = BSC_PERIODS_UTILITY_PKG.C_DELETE ) THEN

Line 606: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_DEL_ALREADY');

602: FROM bsc_sys_calendars_b
603: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
604: --first check if the calendar passed exists or not
605: IF(l_count = 0 ) THEN
606: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_DEL_ALREADY');
607: FND_MSG_PUB.ADD;
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: END IF;
610:

Line 632: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_USED_IN_OBJECTIVE');

628: ELSE
629: l_Objective_Names := l_Objective_Names || ',' || cObj.name;
630: END IF;
631: END LOOP;
632: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_USED_IN_OBJECTIVE');
633: FND_MESSAGE.SET_TOKEN('CALENDAR', l_Calendar_Name);
634: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
635: FND_MSG_PUB.ADD;
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 633: FND_MESSAGE.SET_TOKEN('CALENDAR', l_Calendar_Name);

629: l_Objective_Names := l_Objective_Names || ',' || cObj.name;
630: END IF;
631: END LOOP;
632: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_USED_IN_OBJECTIVE');
633: FND_MESSAGE.SET_TOKEN('CALENDAR', l_Calendar_Name);
634: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
635: FND_MSG_PUB.ADD;
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;

Line 634: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);

630: END IF;
631: END LOOP;
632: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_USED_IN_OBJECTIVE');
633: FND_MESSAGE.SET_TOKEN('CALENDAR', l_Calendar_Name);
634: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
635: FND_MSG_PUB.ADD;
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:

Line 1131: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_ACTION_FLAG_CHANGE');

1127: FOR CD IN C_FLAG_OBJECTIVES LOOP
1128: BSC_DESIGNER_PVT.ActionFlag_Change(CD.indicator,BSC_DESIGNER_PVT.G_ActionFlag.Update_Update);
1129:
1130: IF(BSC_PERIODS_UTILITY_PKG.Check_Error_Message('ActionFlag_Change')) THEN
1131: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_ACTION_FLAG_CHANGE');
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: