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_CALENDAR_PUB dependencies on FND_MSG_PUB

Line 68: FND_MSG_PUB.Initialize;

64: )IS
65: l_Calendar_Record BSC_CALENDAR_PUB.Calendar_Type_Record;
66: BEGIN
67: SAVEPOINT CreateCalendarPubSP;
68: FND_MSG_PUB.Initialize;
69: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
70:
71: BSC_CALENDAR_PUB.Validate_Calendar_Action
72: ( p_Api_Version => p_Api_Version

Line 141: FND_MSG_PUB.Count_And_Get

137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO CreateCalendarPubSP;
140: IF (x_msg_data IS NULL) THEN
141: FND_MSG_PUB.Count_And_Get
142: ( p_encoded => FND_API.G_FALSE
143: , p_count => x_msg_count
144: , p_data => x_msg_data
145: );

Line 151: FND_MSG_PUB.Count_And_Get

147: x_return_status := FND_API.G_RET_STS_ERROR;
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: ROLLBACK TO CreateCalendarPubSP;
150: IF (x_msg_data IS NULL) THEN
151: FND_MSG_PUB.Count_And_Get
152: ( p_encoded => FND_API.G_FALSE
153: , p_count => x_msg_count
154: , p_data => x_msg_data
155: );

Line 193: FND_MSG_PUB.Initialize;

189: l_Start_Day BSC_SYS_CALENDARS_B.START_DAY%TYPE;
190: l_Calendar_Old_Name BSC_SYS_CALENDARS_TL.NAME%TYPE;
191: BEGIN
192: SAVEPOINT UpdateCalendarPubSP;
193: FND_MSG_PUB.Initialize;
194: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
195:
196: SELECT fiscal_year
197: ,start_month

Line 296: FND_MSG_PUB.Count_And_Get

292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: ROLLBACK TO UpdateCalendarPubSP;
295: IF (x_msg_data IS NULL) THEN
296: FND_MSG_PUB.Count_And_Get
297: ( p_encoded => FND_API.G_FALSE
298: , p_count => x_msg_count
299: , p_data => x_msg_data
300: );

Line 306: FND_MSG_PUB.Count_And_Get

302: x_return_status := FND_API.G_RET_STS_ERROR;
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO UpdateCalendarPubSP;
305: IF (x_msg_data IS NULL) THEN
306: FND_MSG_PUB.Count_And_Get
307: ( p_encoded => FND_API.G_FALSE
308: , p_count => x_msg_count
309: , p_data => x_msg_data
310: );

Line 368: FND_MSG_PUB.Initialize;

364: l_count NUMBER;
365:
366: BEGIN
367: SAVEPOINT DeleteCalendarPubSP;
368: FND_MSG_PUB.Initialize;
369: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
370:
371: BSC_CALENDAR_PUB.Validate_Calendar_Action
372: ( p_Api_Version => p_Api_Version

Line 475: FND_MSG_PUB.Count_And_Get

471: EXCEPTION
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO DeleteCalendarPubSP;
474: IF (x_msg_data IS NULL) THEN
475: FND_MSG_PUB.Count_And_Get
476: ( p_encoded => FND_API.G_FALSE
477: , p_count => x_msg_count
478: , p_data => x_msg_data
479: );

Line 485: FND_MSG_PUB.Count_And_Get

481: x_return_status := FND_API.G_RET_STS_ERROR;
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO DeleteCalendarPubSP;
484: IF (x_msg_data IS NULL) THEN
485: FND_MSG_PUB.Count_And_Get
486: ( p_encoded => FND_API.G_FALSE
487: , p_count => x_msg_count
488: , p_data => x_msg_data
489: );

Line 533: FND_MSG_PUB.Initialize;

529:
530:
531: BEGIN
532:
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');

Line 538: FND_MSG_PUB.ADD;

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
542: FND_MESSAGE.SET_NAME('BSC','BSC_CAL_SHORT_NAME_NULL');

Line 543: 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;
547:

Line 555: FND_MSG_PUB.ADD;

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:
559: SELECT COUNT(1)

Line 566: FND_MSG_PUB.ADD;

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:
570: SELECT COUNT(1)

Line 576: FND_MSG_PUB.ADD;

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:
580: ELSIF(p_Action = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN

Line 583: FND_MSG_PUB.ADD;

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:
587: SELECT COUNT(1)

Line 594: FND_MSG_PUB.ADD;

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

Line 607: FND_MSG_PUB.ADD;

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:
611: l_count := 0;

Line 635: FND_MSG_PUB.ADD;

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

Line 648: FND_MSG_PUB.Count_And_Get

644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: IF (x_msg_data IS NULL) THEN
648: FND_MSG_PUB.Count_And_Get
649: ( p_encoded => FND_API.G_FALSE
650: , p_count => x_msg_count
651: , p_data => x_msg_data
652: );

Line 657: FND_MSG_PUB.Count_And_Get

653: END IF;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: IF (x_msg_data IS NULL) THEN
657: FND_MSG_PUB.Count_And_Get
658: ( p_encoded => FND_API.G_FALSE
659: , p_count => x_msg_count
660: , p_data => x_msg_data
661: );

Line 693: FND_MSG_PUB.Initialize;

689: , x_Msg_Data OUT NOCOPY VARCHAR2
690: )IS
691:
692: BEGIN
693: FND_MSG_PUB.Initialize;
694: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
695:
696: SELECT calendar_id
697: , edw_flag

Line 810: FND_MSG_PUB.Initialize;

806: )IS
807:
808: BEGIN
809: SAVEPOINT CreateCalendarPostActionSP;
810: FND_MSG_PUB.Initialize;
811: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
812:
813: BSC_CALENDAR_PUB.Create_Periodicities_Calendar
814: ( p_Api_Version => p_Api_Version

Line 840: FND_MSG_PUB.Count_And_Get

836: EXCEPTION
837: WHEN FND_API.G_EXC_ERROR THEN
838: ROLLBACK TO CreateCalendarPostActionSP;
839: IF (x_msg_data IS NULL) THEN
840: FND_MSG_PUB.Count_And_Get
841: ( p_encoded => FND_API.G_FALSE
842: , p_count => x_msg_count
843: , p_data => x_msg_data
844: );

Line 850: FND_MSG_PUB.Count_And_Get

846: x_return_status := FND_API.G_RET_STS_ERROR;
847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
848: ROLLBACK TO CreateCalendarPostActionSP;
849: IF (x_msg_data IS NULL) THEN
850: FND_MSG_PUB.Count_And_Get
851: ( p_encoded => FND_API.G_FALSE
852: , p_count => x_msg_count
853: , p_data => x_msg_data
854: );

Line 889: FND_MSG_PUB.Initialize;

885: , x_Msg_Data OUT NOCOPY VARCHAR2
886: )IS
887:
888: BEGIN
889: FND_MSG_PUB.Initialize;
890: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
891:
892: x_Calendar_Record := p_Calendar_Record;
893:

Line 972: FND_MSG_PUB.Count_And_Get

968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: IF (x_msg_data IS NULL) THEN
972: FND_MSG_PUB.Count_And_Get
973: ( p_encoded => FND_API.G_FALSE
974: , p_count => x_msg_count
975: , p_data => x_msg_data
976: );

Line 981: FND_MSG_PUB.Count_And_Get

977: END IF;
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: IF (x_msg_data IS NULL) THEN
981: FND_MSG_PUB.Count_And_Get
982: ( p_encoded => FND_API.G_FALSE
983: , p_count => x_msg_count
984: , p_data => x_msg_data
985: );

Line 1018: FND_MSG_PUB.Initialize;

1014: l_System_Stage bsc_sys_init.property_value%TYPE;
1015:
1016: BEGIN
1017: SAVEPOINT UpdateCalendarPostActionSP;
1018: FND_MSG_PUB.Initialize;
1019: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1020:
1021: SELECT property_value
1022: INTO l_System_Stage

Line 1069: FND_MSG_PUB.Count_And_Get

1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: ROLLBACK TO UpdateCalendarPostActionSP;
1068: IF (x_msg_data IS NULL) THEN
1069: FND_MSG_PUB.Count_And_Get
1070: ( p_encoded => FND_API.G_FALSE
1071: , p_count => x_msg_count
1072: , p_data => x_msg_data
1073: );

Line 1079: FND_MSG_PUB.Count_And_Get

1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1077: ROLLBACK TO UpdateCalendarPostActionSP;
1078: IF (x_msg_data IS NULL) THEN
1079: FND_MSG_PUB.Count_And_Get
1080: ( p_encoded => FND_API.G_FALSE
1081: , p_count => x_msg_count
1082: , p_data => x_msg_data
1083: );

Line 1124: FND_MSG_PUB.Initialize;

1120: WHERE S.periodicity_id = K.periodicity_id
1121: AND S.calendar_id = p_Calendar_Id;
1122:
1123: BEGIN
1124: FND_MSG_PUB.Initialize;
1125: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1126:
1127: FOR CD IN C_FLAG_OBJECTIVES LOOP
1128: BSC_DESIGNER_PVT.ActionFlag_Change(CD.indicator,BSC_DESIGNER_PVT.G_ActionFlag.Update_Update);

Line 1132: FND_MSG_PUB.ADD;

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:
1136: END LOOP;

Line 1141: FND_MSG_PUB.Count_And_Get

1137:
1138: EXCEPTION
1139: WHEN FND_API.G_EXC_ERROR THEN
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 1150: FND_MSG_PUB.Count_And_Get

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

Line 1214: FND_MSG_PUB.Initialize;

1210: WHERE CALENDAR_ID = p_calendar_id
1211: AND PERIODICITY_TYPE = p_periodicity_type;
1212:
1213: BEGIN
1214: FND_MSG_PUB.Initialize;
1215: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1216: BSC_APPS.Init_Bsc_Apps;
1217: l_Count := 1;
1218:

Line 1310: FND_MSG_PUB.Count_And_Get

1306:
1307: EXCEPTION
1308: WHEN FND_API.G_EXC_ERROR THEN
1309: IF (x_msg_data IS NULL) THEN
1310: FND_MSG_PUB.Count_And_Get
1311: ( p_encoded => FND_API.G_FALSE
1312: , p_count => x_msg_count
1313: , p_data => x_msg_data
1314: );

Line 1319: FND_MSG_PUB.Count_And_Get

1315: END IF;
1316: x_return_status := FND_API.G_RET_STS_ERROR;
1317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1318: IF (x_msg_data IS NULL) THEN
1319: FND_MSG_PUB.Count_And_Get
1320: ( p_encoded => FND_API.G_FALSE
1321: , p_count => x_msg_count
1322: , p_data => x_msg_data
1323: );

Line 1352: FND_MSG_PUB.Initialize;

1348: , x_Msg_Data OUT NOCOPY VARCHAR2
1349: )IS
1350: l_Short_Name bsc_sys_calendars_b.short_name%TYPE;
1351: BEGIN
1352: FND_MSG_PUB.Initialize;
1353: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1354:
1355: IF(p_Calendar_Record.Dim_Short_Name IS NULL) THEN
1356: l_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Unique_Short_Name();

Line 1385: FND_MSG_PUB.Count_And_Get

1381:
1382: EXCEPTION
1383: WHEN FND_API.G_EXC_ERROR THEN
1384: IF (x_msg_data IS NULL) THEN
1385: FND_MSG_PUB.Count_And_Get
1386: ( p_encoded => FND_API.G_FALSE
1387: , p_count => x_msg_count
1388: , p_data => x_msg_data
1389: );

Line 1394: FND_MSG_PUB.Count_And_Get

1390: END IF;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: IF (x_msg_data IS NULL) THEN
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_encoded => FND_API.G_FALSE
1396: , p_count => x_msg_count
1397: , p_data => x_msg_data
1398: );

Line 1434: FND_MSG_PUB.Initialize;

1430:
1431: l_Short_Name bsc_sys_calendars_b.short_name%TYPE;
1432: l_dim_obj_shortNames VARCHAR2(32000);
1433: BEGIN
1434: FND_MSG_PUB.Initialize;
1435: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1436:
1437: FOR CD IN C_comma_objNames LOOP
1438: IF(l_dim_obj_shortNames IS NULL) THEN

Line 1467: FND_MSG_PUB.Count_And_Get

1463:
1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: IF (x_msg_data IS NULL) THEN
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_encoded => FND_API.G_FALSE
1469: , p_count => x_msg_count
1470: , p_data => x_msg_data
1471: );

Line 1476: FND_MSG_PUB.Count_And_Get

1472: END IF;
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: IF (x_msg_data IS NULL) THEN
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_encoded => FND_API.G_FALSE
1478: , p_count => x_msg_count
1479: , p_data => x_msg_data
1480: );