DBA Data[Home] [Help]

APPS.BSC_PERIODICITIES_PUB dependencies on FND_MESSAGE

Line 519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');

515: INTO l_dim_obj_name
516: FROM bsc_sys_periodicities_vl c
517: WHERE c.short_name = l_Dim_Object_SN;
518:
519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);
521: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_name);
522: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
523: FND_MSG_PUB.ADD;

Line 520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);

516: FROM bsc_sys_periodicities_vl c
517: WHERE c.short_name = l_Dim_Object_SN;
518:
519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);
521: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_name);
522: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;

Line 521: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_name);

517: WHERE c.short_name = l_Dim_Object_SN;
518:
519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);
521: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_name);
522: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;

Line 522: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);

518:
519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);
521: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_name);
522: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:

Line 701: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_ID_NULL');

697:
698: IF ((p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) OR (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE)) THEN
699:
700: IF (p_Periodicities_Rec_Type.Calendar_Id IS NULL) THEN
701: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_ID_NULL');
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END IF;
705:

Line 708: FND_MESSAGE.SET_NAME('BSC','BSC_BASE_PERIODICITY_NULL');

704: END IF;
705:
706: IF (p_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_BASE_PERIODICITY_TYPE) THEN
707: IF (p_Periodicities_Rec_Type.Base_Periodicity_Id IS NULL) THEN
708: FND_MESSAGE.SET_NAME('BSC','BSC_BASE_PERIODICITY_NULL');
709: FND_MSG_PUB.ADD;
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:

Line 714: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_IDS_NULL');

710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
713: IF (p_Periodicities_Rec_Type.Period_IDs IS NULL) THEN
714: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_IDS_NULL');
715: FND_MSG_PUB.ADD;
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: END IF;

Line 727: FND_MESSAGE.SET_NAME('BSC','BSC_NUM_PERIODS_CANNOT_NULL');

723: );
724:
725: -- Validation#3
726: IF (p_Periodicities_Rec_Type.Num_Of_Periods IS NULL) THEN
727: FND_MESSAGE.SET_NAME('BSC','BSC_NUM_PERIODS_CANNOT_NULL');
728: FND_MSG_PUB.ADD;
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:

Line 738: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');

734: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) THEN
735:
736: -- Validation#1:
737: IF(l_Is_Name_Unique = FND_API.G_FALSE) THEN
738: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
739: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
740: FND_MESSAGE.SET_TOKEN('CALENDAR',
741: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
742: p_Periodicities_Rec_Type.Calendar_Id

Line 739: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);

735:
736: -- Validation#1:
737: IF(l_Is_Name_Unique = FND_API.G_FALSE) THEN
738: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
739: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
740: FND_MESSAGE.SET_TOKEN('CALENDAR',
741: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
742: p_Periodicities_Rec_Type.Calendar_Id
743: )

Line 740: FND_MESSAGE.SET_TOKEN('CALENDAR',

736: -- Validation#1:
737: IF(l_Is_Name_Unique = FND_API.G_FALSE) THEN
738: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
739: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
740: FND_MESSAGE.SET_TOKEN('CALENDAR',
741: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
742: p_Periodicities_Rec_Type.Calendar_Id
743: )
744: );

Line 755: FND_MESSAGE.SET_NAME('BSC','BSC_PERIODICITY_ID_UNIQUE');

751: FROM BSC_SYS_PERIODICITIES P
752: WHERE P.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_id;
753:
754: IF (l_Count <> 0) THEN
755: FND_MESSAGE.SET_NAME('BSC','BSC_PERIODICITY_ID_UNIQUE');
756: FND_MESSAGE.SET_TOKEN('PERIODICITY_ID', p_Periodicities_Rec_Type.Periodicity_id);
757: FND_MSG_PUB.ADD;
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;

Line 756: FND_MESSAGE.SET_TOKEN('PERIODICITY_ID', p_Periodicities_Rec_Type.Periodicity_id);

752: WHERE P.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_id;
753:
754: IF (l_Count <> 0) THEN
755: FND_MESSAGE.SET_NAME('BSC','BSC_PERIODICITY_ID_UNIQUE');
756: FND_MESSAGE.SET_TOKEN('PERIODICITY_ID', p_Periodicities_Rec_Type.Periodicity_id);
757: FND_MSG_PUB.ADD;
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:

Line 766: FND_MESSAGE.SET_NAME('BSC','BSC_PER_CAL_EXCEEDS_LIMIT');

762: l_Max_Periodicities := BSC_PERIODS_UTILITY_PKG.Get_Cust_Per_Cnt_By_Calendar(
763: p_Periodicities_Rec_Type.Calendar_Id
764: );
765: IF(l_Max_Periodicities = BSC_PERIODS_UTILITY_PKG.C_MAX_CUSTOM_PERIODICITIES) THEN
766: FND_MESSAGE.SET_NAME('BSC','BSC_PER_CAL_EXCEEDS_LIMIT');
767: FND_MESSAGE.SET_TOKEN('CALENDAR',
768: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
769: p_Periodicities_Rec_Type.Calendar_Id
770: )

Line 767: FND_MESSAGE.SET_TOKEN('CALENDAR',

763: p_Periodicities_Rec_Type.Calendar_Id
764: );
765: IF(l_Max_Periodicities = BSC_PERIODS_UTILITY_PKG.C_MAX_CUSTOM_PERIODICITIES) THEN
766: FND_MESSAGE.SET_NAME('BSC','BSC_PER_CAL_EXCEEDS_LIMIT');
767: FND_MESSAGE.SET_TOKEN('CALENDAR',
768: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
769: p_Periodicities_Rec_Type.Calendar_Id
770: )
771: );

Line 786: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');

782: AND P.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
783: AND P.PERIODICITY_ID <> p_Periodicities_Rec_Type.Periodicity_id;
784:
785: IF (l_Count <> 0) THEN
786: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
787: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
788: FND_MESSAGE.SET_TOKEN('CALENDAR',
789: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
790: p_Periodicities_Rec_Type.Calendar_Id

Line 787: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);

783: AND P.PERIODICITY_ID <> p_Periodicities_Rec_Type.Periodicity_id;
784:
785: IF (l_Count <> 0) THEN
786: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
787: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
788: FND_MESSAGE.SET_TOKEN('CALENDAR',
789: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
790: p_Periodicities_Rec_Type.Calendar_Id
791: )

Line 788: FND_MESSAGE.SET_TOKEN('CALENDAR',

784:
785: IF (l_Count <> 0) THEN
786: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
787: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
788: FND_MESSAGE.SET_TOKEN('CALENDAR',
789: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
790: p_Periodicities_Rec_Type.Calendar_Id
791: )
792: );

Line 806: FND_MESSAGE.SET_NAME('BSC','BSC_NO_UPT_BASE_PERIODICITIES');

802: AND B.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
803: AND B.PERIODICITY_TYPE <> 0;
804:
805: IF (l_Count <> 0) THEN
806: FND_MESSAGE.SET_NAME('BSC','BSC_NO_UPT_BASE_PERIODICITIES');
807: FND_MSG_PUB.ADD;
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:

Line 818: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_NO_CIRCULAR_REF');

814: , p_Periodicities_Rec_Type.Periodicity_id
815: );
816:
817: IF (l_Is_Circular = BSC_BIS_KPI_MEAS_PUB.CIR_REF_EXISTS) THEN
818: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_NO_CIRCULAR_REF');
819: FND_MSG_PUB.ADD;
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822: END IF;

Line 833: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_BASE_PERIODICITIES');

829: AND B.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
830: AND B.PERIODICITY_TYPE <> 0;
831:
832: IF (l_Count <> 0) THEN
833: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_BASE_PERIODICITIES');
834: FND_MSG_PUB.ADD;
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:

Line 848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_IS_BASE_PER');

844: FROM BSC_SYS_PERIODICITIES B
845: WHERE TRIM(B.SOURCE) = TO_CHAR(p_Periodicities_Rec_Type.Periodicity_id);
846:
847: IF (l_Count <> 0) THEN
848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_IS_BASE_PER');
849: FND_MSG_PUB.ADD;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;

Line 871: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_USED_IN_OBJECTIVE');

867: END IF;
868: END LOOP;
869:
870: -- fixed for Bug#4574115
871: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_USED_IN_OBJECTIVE');
872: FND_MESSAGE.SET_TOKEN('PERIODICITY', BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Name(p_Periodicities_Rec_Type.Periodicity_id));
873: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 872: FND_MESSAGE.SET_TOKEN('PERIODICITY', BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Name(p_Periodicities_Rec_Type.Periodicity_id));

868: END LOOP;
869:
870: -- fixed for Bug#4574115
871: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_USED_IN_OBJECTIVE');
872: FND_MESSAGE.SET_TOKEN('PERIODICITY', BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Name(p_Periodicities_Rec_Type.Periodicity_id));
873: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END IF;

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

869:
870: -- fixed for Bug#4574115
871: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_USED_IN_OBJECTIVE');
872: FND_MESSAGE.SET_TOKEN('PERIODICITY', BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Name(p_Periodicities_Rec_Type.Periodicity_id));
873: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END IF;
877:

Line 1254: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_UPDATE_ANUAL_SOURCE');

1250: , x_action => p_Action
1251: );
1252:
1253: IF(BSC_PERIODS_UTILITY_PKG.Check_Error_Message('BSC_UPDATE_UTIL.UpdAnualPeriodicitySrc')) THEN
1254: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_UPDATE_ANUAL_SOURCE');
1255: FND_MSG_PUB.ADD;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258: