DBA Data[Home] [Help]

APPS.BSC_CALENDAR_PUB dependencies on BSC_PERIODS_UTILITY_PKG

Line 75: , p_Action => BSC_PERIODS_UTILITY_PKG.C_CREATE

71: BSC_CALENDAR_PUB.Validate_Calendar_Action
72: ( p_Api_Version => p_Api_Version
73: , p_Commit => p_Commit
74: , p_Calendar_Record => p_Calendar_Record
75: , p_Action => BSC_PERIODS_UTILITY_PKG.C_CREATE
76: , x_Return_Status => x_Return_Status
77: , x_Msg_Count => x_Msg_Count
78: , x_Msg_Data => x_Msg_Data
79: );

Line 218: , p_Action => BSC_PERIODS_UTILITY_PKG.C_UPDATE

214: BSC_CALENDAR_PUB.Validate_Calendar_Action
215: ( p_Api_Version => p_Api_Version
216: , p_Commit => p_Commit
217: , p_Calendar_Record => p_Calendar_Record
218: , p_Action => BSC_PERIODS_UTILITY_PKG.C_UPDATE
219: , x_Return_Status => x_Return_Status
220: , x_Msg_Count => x_Msg_Count
221: , x_Msg_Data => x_Msg_Data
222: );

Line 375: , p_Action => BSC_PERIODS_UTILITY_PKG.C_DELETE

371: BSC_CALENDAR_PUB.Validate_Calendar_Action
372: ( p_Api_Version => p_Api_Version
373: , p_Commit => p_Commit
374: , p_Calendar_Record => p_Calendar_Record
375: , p_Action => BSC_PERIODS_UTILITY_PKG.C_DELETE
376: , x_Return_Status => x_Return_Status
377: , x_Msg_Count => x_Msg_Count
378: , x_Msg_Data => x_Msg_Data
379: );

Line 535: IF(p_Action = BSC_PERIODS_UTILITY_PKG.C_CREATE OR p_Action = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN

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');
538: FND_MSG_PUB.ADD;
539: RAISE FND_API.G_EXC_ERROR;

Line 548: IF(p_Action = BSC_PERIODS_UTILITY_PKG.C_CREATE ) THEN

544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: END IF;
547:
548: IF(p_Action = BSC_PERIODS_UTILITY_PKG.C_CREATE ) THEN
549: SELECT COUNT(1)
550: INTO l_count
551: FROM bsc_sys_calendars_b
552: WHERE TRIM(calendar_id) = TRIM(p_Calendar_Record.Calendar_Id);

Line 580: ELSIF(p_Action = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN

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

Line 597: ELSIF(p_Action = BSC_PERIODS_UTILITY_PKG.C_DELETE ) 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:
599: l_count := 0;
600: SELECT COUNT(1)
601: INTO l_count

Line 895: x_Calendar_Record.Calendar_Id := BSC_PERIODS_UTILITY_PKG.Get_Next_Calendar_Id;

891:
892: x_Calendar_Record := p_Calendar_Record;
893:
894: IF (p_Calendar_Record.Calendar_Id IS NULL) THEN
895: x_Calendar_Record.Calendar_Id := BSC_PERIODS_UTILITY_PKG.Get_Next_Calendar_Id;
896: ELSE
897: x_Calendar_Record.Calendar_Id := p_Calendar_Record.Calendar_Id;
898: END IF;
899:

Line 913: x_Calendar_Record.Edw_Flag := BSC_PERIODS_UTILITY_PKG.C_CONSTANT_ZERO;

909: x_Calendar_Record.Help := P_Calendar_Record.Help;
910: END IF;
911:
912: IF(p_Calendar_Record.Edw_Flag IS NULL) THEN
913: x_Calendar_Record.Edw_Flag := BSC_PERIODS_UTILITY_PKG.C_CONSTANT_ZERO;
914: ELSE
915: x_Calendar_Record.Edw_Flag := p_Calendar_Record.Edw_Flag;
916: END IF;
917:

Line 933: x_Calendar_Record.Fiscal_Change := BSC_PERIODS_UTILITY_PKG.C_CONSTANT_ZERO;

929: x_Calendar_Record.Fiscal_Year := p_Calendar_Record.Fiscal_Year;
930: END IF;
931:
932: IF(p_Calendar_Record.Fiscal_Change IS NULL) THEN
933: x_Calendar_Record.Fiscal_Change := BSC_PERIODS_UTILITY_PKG.C_CONSTANT_ZERO;
934: ELSE
935: x_Calendar_Record.Fiscal_Change := p_Calendar_Record.Fiscal_Change;
936: END IF;
937:

Line 939: x_Calendar_Record.Range_Yr_Mod := BSC_PERIODS_UTILITY_PKG.C_CONSTANT_ZERO;

935: x_Calendar_Record.Fiscal_Change := p_Calendar_Record.Fiscal_Change;
936: END IF;
937:
938: IF(p_Calendar_Record.Range_Yr_Mod IS NULL) THEN
939: x_Calendar_Record.Range_Yr_Mod := BSC_PERIODS_UTILITY_PKG.C_CONSTANT_ZERO;
940: ELSE
941: x_Calendar_Record.Range_Yr_Mod := p_Calendar_Record.Range_Yr_Mod;
942: END IF;
943:

Line 945: x_Calendar_Record.Start_Month := BSC_PERIODS_UTILITY_PKG.C_DEFAULT_START_MONTH;

941: x_Calendar_Record.Range_Yr_Mod := p_Calendar_Record.Range_Yr_Mod;
942: END IF;
943:
944: IF(p_Calendar_Record.Start_Month IS NULL) THEN
945: x_Calendar_Record.Start_Month := BSC_PERIODS_UTILITY_PKG.C_DEFAULT_START_MONTH;
946: ELSE
947: x_Calendar_Record.Start_Month := p_Calendar_Record.Start_Month;
948: END IF;
949:

Line 951: x_Calendar_Record.Start_Day := BSC_PERIODS_UTILITY_PKG.C_DEFAULT_START_DAY;

947: x_Calendar_Record.Start_Month := p_Calendar_Record.Start_Month;
948: END IF;
949:
950: IF(p_Calendar_Record.Start_Day IS NULL) THEN
951: x_Calendar_Record.Start_Day := BSC_PERIODS_UTILITY_PKG.C_DEFAULT_START_DAY;
952: ELSE
953: x_Calendar_Record.Start_Day := p_Calendar_Record.Start_Day;
954: END IF;
955:

Line 957: x_Calendar_Record.Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Unique_Short_Name();

953: x_Calendar_Record.Start_Day := p_Calendar_Record.Start_Day;
954: END IF;
955:
956: IF(p_Calendar_Record.Dim_Short_Name IS NULL) THEN
957: x_Calendar_Record.Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Unique_Short_Name();
958: ELSE
959: x_Calendar_Record.Dim_Short_Name := p_Calendar_Record.Dim_Short_Name;
960: END IF;
961:

Line 963: x_Calendar_Record.Application_Id := BSC_PERIODS_UTILITY_PKG.C_BSC_APPLICATION_ID;

959: x_Calendar_Record.Dim_Short_Name := p_Calendar_Record.Dim_Short_Name;
960: END IF;
961:
962: IF(p_Calendar_Record.Application_Id IS NULL) THEN
963: x_Calendar_Record.Application_Id := BSC_PERIODS_UTILITY_PKG.C_BSC_APPLICATION_ID;
964: ELSE
965: x_Calendar_Record.Application_Id := p_Calendar_Record.Application_Id;
966: END IF;
967:

Line 1024: WHERE property_code = BSC_PERIODS_UTILITY_PKG.C_SYSTEM_STAGE;

1020:
1021: SELECT property_value
1022: INTO l_System_Stage
1023: from bsc_sys_init
1024: WHERE property_code = BSC_PERIODS_UTILITY_PKG.C_SYSTEM_STAGE;
1025:
1026: IF(l_System_Stage = 2 AND Get_Fiscal_Year() = 1) THEN
1027: BSC_CALENDAR_PVT.Update_Fiscal_Change
1028: ( p_Api_Version => p_Api_Version

Line 1130: IF(BSC_PERIODS_UTILITY_PKG.Check_Error_Message('ActionFlag_Change')) THEN

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

Line 1222: , p_Separator => BSC_PERIODS_UTILITY_PKG.C_COMMA_SEPARATOR

1218:
1219: IF (p_Calendar_Record.Base_Periodicities_Ids IS NOT NULL) THEN
1220: BSC_UTILITY.Parse_String
1221: ( p_List => p_Calendar_Record.Base_Periodicities_Ids
1222: , p_Separator => BSC_PERIODS_UTILITY_PKG.C_COMMA_SEPARATOR
1223: , p_List_Data => l_Periodicity_Ids
1224: , p_List_number => l_Periodicity_Count
1225: );
1226: END IF;

Line 1356: l_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Unique_Short_Name();

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();
1357: ELSE
1358: l_Short_Name := p_Calendar_Record.Dim_Short_Name;
1359: END IF;
1360: