eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_PERIODICITIES_PUB dependencies on FND_MSG_PUB

Line 64: FND_MSG_PUB.Initialize;

60: l_Dimobj_Name BIS_LEVELS_TL.NAME%TYPE;
61: l_Dim_Enabled VARCHAR2(10);
62: BEGIN
63: SAVEPOINT CreatePeriodicityPUB;
64: FND_MSG_PUB.Initialize;
65:
66: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
67: l_Dim_Enabled := FND_API.G_TRUE;
68: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;

Line 203: FND_MSG_PUB.Count_And_Get

199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO CreatePeriodicityPUB;
202: IF (x_msg_data IS NULL) THEN
203: FND_MSG_PUB.Count_And_Get
204: ( p_encoded => FND_API.G_FALSE
205: , p_count => x_msg_count
206: , p_data => x_msg_data
207: );

Line 213: FND_MSG_PUB.Count_And_Get

209: x_Return_Status := FND_API.G_RET_STS_ERROR;
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO CreatePeriodicityPUB;
212: IF (x_msg_data IS NULL) THEN
213: FND_MSG_PUB.Count_And_Get
214: ( p_encoded => FND_API.G_FALSE
215: , p_count => x_msg_count
216: , p_data => x_msg_data
217: );

Line 258: FND_MSG_PUB.Initialize;

254: l_Dim_Short_Name BSC_SYS_DIM_GROUPS_TL.SHORT_NAME%TYPE;
255: l_Dim_Enabled VARCHAR2(10);
256: BEGIN
257: SAVEPOINT UpdatePeriodicityPUB;
258: FND_MSG_PUB.Initialize;
259: l_Dim_Enabled := FND_API.G_TRUE;
260: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
261:
262: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;

Line 425: FND_MSG_PUB.Count_And_Get

421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO UpdatePeriodicityPUB;
424: IF (x_msg_data IS NULL) THEN
425: FND_MSG_PUB.Count_And_Get
426: ( p_encoded => FND_API.G_FALSE
427: , p_count => x_msg_count
428: , p_data => x_msg_data
429: );

Line 435: FND_MSG_PUB.Count_And_Get

431: x_Return_Status := FND_API.G_RET_STS_ERROR;
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO UpdatePeriodicityPUB;
434: IF (x_msg_data IS NULL) THEN
435: FND_MSG_PUB.Count_And_Get
436: ( p_encoded => FND_API.G_FALSE
437: , p_count => x_msg_count
438: , p_data => x_msg_data
439: );

Line 485: FND_MSG_PUB.Initialize;

481: WHERE L.SHORT_NAME = l_Dim_Object_SN
482: AND L.LEVEL_VALUES_VIEW_NAME IS NOT NULL;
483: BEGIN
484: SAVEPOINT DeletePeriodicityPUB;
485: FND_MSG_PUB.Initialize;
486:
487: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
488: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Periodicity_Id - ' ||p_Periodicities_Rec_Type.Periodicity_Id);
489: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Calendar_Id - ' ||p_Periodicities_Rec_Type.Calendar_Id);

Line 523: FND_MSG_PUB.ADD;

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:
527: BSC_PERIODICITIES_PVT.Delete_Periodicity (

Line 609: FND_MSG_PUB.Count_And_Get

605: EXCEPTION
606: WHEN FND_API.G_EXC_ERROR THEN
607: ROLLBACK TO DeletePeriodicityPUB;
608: IF (x_msg_data IS NULL) THEN
609: FND_MSG_PUB.Count_And_Get
610: ( p_encoded => FND_API.G_FALSE
611: , p_count => x_msg_count
612: , p_data => x_msg_data
613: );

Line 619: FND_MSG_PUB.Count_And_Get

615: x_Return_Status := FND_API.G_RET_STS_ERROR;
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO DeletePeriodicityPUB;
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get
620: ( p_encoded => FND_API.G_FALSE
621: , p_count => x_msg_count
622: , p_data => x_msg_data
623: );

Line 694: FND_MSG_PUB.Initialize;

690: l_Objective_Names VARCHAR2(2000);
691: BEGIN
692: SAVEPOINT ValidatePeriodicityPUB;
693:
694: FND_MSG_PUB.Initialize;
695: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
696:
697:
698: IF ((p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) OR (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE)) THEN

Line 702: FND_MSG_PUB.ADD;

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:
706: IF (p_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_BASE_PERIODICITY_TYPE) THEN

Line 709: FND_MSG_PUB.ADD;

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:
713: IF (p_Periodicities_Rec_Type.Period_IDs IS NULL) THEN

Line 715: FND_MSG_PUB.ADD;

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;
719:

Line 728: FND_MSG_PUB.ADD;

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:
732:

Line 745: FND_MSG_PUB.ADD;

741: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
742: p_Periodicities_Rec_Type.Calendar_Id
743: )
744: );
745: FND_MSG_PUB.ADD;
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: -- Validation#2

Line 757: FND_MSG_PUB.ADD;

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:
761: -- Validation#2:

Line 772: FND_MSG_PUB.ADD;

768: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
769: p_Periodicities_Rec_Type.Calendar_Id
770: )
771: );
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775: END IF;
776:

Line 793: FND_MSG_PUB.ADD;

789: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(
790: p_Periodicities_Rec_Type.Calendar_Id
791: )
792: );
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: -- Do not allow update of Base Periodicities .

Line 807: FND_MSG_PUB.ADD;

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:
811: -- Check for circular dependency

Line 819: FND_MSG_PUB.ADD;

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;
823: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_DELETE) THEN

Line 834: FND_MSG_PUB.ADD;

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:
838: -- You cannot delete a custom periodicity, which is the base

Line 849: FND_MSG_PUB.ADD;

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;
853:

Line 874: FND_MSG_PUB.ADD;

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:
878: END IF;

Line 884: FND_MSG_PUB.Count_And_Get

880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: ROLLBACK TO ValidatePeriodicityPUB;
883: IF (x_msg_data IS NULL) THEN
884: FND_MSG_PUB.Count_And_Get
885: ( p_encoded => FND_API.G_FALSE
886: , p_count => x_msg_count
887: , p_data => x_msg_data
888: );

Line 894: FND_MSG_PUB.Count_And_Get

890: x_Return_Status := FND_API.G_RET_STS_ERROR;
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO ValidatePeriodicityPUB;
893: IF (x_msg_data IS NULL) THEN
894: FND_MSG_PUB.Count_And_Get
895: ( p_encoded => FND_API.G_FALSE
896: , p_count => x_msg_count
897: , p_data => x_msg_data
898: );

Line 933: FND_MSG_PUB.Initialize;

929:
930: l_Calendar_Id BSC_SYS_CALENDARS_B.CALENDAR_ID%TYPE;
931: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;
932: BEGIN
933: FND_MSG_PUB.Initialize;
934: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
935: x_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
936:
937: l_Calendar_Id := p_Periodicities_Rec_Type.Calendar_Id;

Line 1049: FND_MSG_PUB.Count_And_Get

1045:
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: IF (x_msg_data IS NULL) THEN
1049: FND_MSG_PUB.Count_And_Get
1050: ( p_encoded => FND_API.G_FALSE
1051: , p_count => x_msg_count
1052: , p_data => x_msg_data
1053: );

Line 1074: FND_MSG_PUB.Initialize;

1070: l_Period_Record BSC_PERIODS_PUB.Period_Record;
1071: l_Struct_Flag BOOLEAN;
1072: BEGIN
1073: SAVEPOINT PopulatePeriodsPUB;
1074: FND_MSG_PUB.Initialize;
1075: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1076:
1077: l_Period_Record.Periodicity_Id := p_Periodicities_Rec_Type.Periodicity_Id;
1078: l_Period_Record.Base_Periodicity_Id := p_Periodicities_Rec_Type.Base_Periodicity_Id;

Line 1141: FND_MSG_PUB.Count_And_Get

1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: ROLLBACK TO PopulatePeriodsPUB;
1140: IF (x_msg_data IS NULL) THEN
1141: FND_MSG_PUB.Count_And_Get
1142: ( p_encoded => FND_API.G_FALSE
1143: , p_count => x_msg_count
1144: , p_data => x_msg_data
1145: );

Line 1151: FND_MSG_PUB.Count_And_Get

1147: x_Return_Status := FND_API.G_RET_STS_ERROR;
1148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1149: ROLLBACK TO PopulatePeriodsPUB;
1150: IF (x_msg_data IS NULL) THEN
1151: FND_MSG_PUB.Count_And_Get
1152: ( p_encoded => FND_API.G_FALSE
1153: , p_count => x_msg_count
1154: , p_data => x_msg_data
1155: );

Line 1186: FND_MSG_PUB.Initialize;

1182: ,x_Msg_Count OUT NOCOPY NUMBER
1183: ,x_Msg_Data OUT NOCOPY VARCHAR2
1184: ) IS
1185: BEGIN
1186: FND_MSG_PUB.Initialize;
1187: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1188:
1189: BSC_PERIODICITIES_PVT.Retrieve_Periodicity (
1190: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 1204: FND_MSG_PUB.Count_And_Get

1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: IF (x_msg_data IS NULL) THEN
1204: FND_MSG_PUB.Count_And_Get
1205: ( p_encoded => FND_API.G_FALSE
1206: , p_count => x_msg_count
1207: , p_data => x_msg_data
1208: );

Line 1213: FND_MSG_PUB.Count_And_Get

1209: END IF;
1210: x_Return_Status := FND_API.G_RET_STS_ERROR;
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: IF (x_msg_data IS NULL) THEN
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE
1215: , p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );

Line 1245: FND_MSG_PUB.Initialize;

1241: , x_Msg_Count OUT NOCOPY NUMBER
1242: , x_Msg_Data OUT NOCOPY VARCHAR2
1243: )IS
1244: BEGIN
1245: FND_MSG_PUB.Initialize;
1246: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1247: BSC_UPDATE_UTIL.Update_AnualPeriodicity_Src
1248: ( x_calendar_id => p_Calendar_Id
1249: , x_periodicity_id => p_Periodicity_Id

Line 1255: FND_MSG_PUB.ADD;

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:
1259: EXCEPTION

Line 1262: FND_MSG_PUB.Count_And_Get

1258:
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: IF (x_msg_data IS NULL) THEN
1262: FND_MSG_PUB.Count_And_Get
1263: ( p_encoded => FND_API.G_FALSE
1264: , p_count => x_msg_count
1265: , p_data => x_msg_data
1266: );

Line 1271: FND_MSG_PUB.Count_And_Get

1267: END IF;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: IF (x_msg_data IS NULL) THEN
1271: FND_MSG_PUB.Count_And_Get
1272: ( p_encoded => FND_API.G_FALSE
1273: , p_count => x_msg_count
1274: , p_data => x_msg_data
1275: );