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 BSC_PERIODS_UTILITY_PKG

Line 71: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

67: l_Dim_Enabled := FND_API.G_TRUE;
68: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
69:
70: BSC_PERIODICITIES_PUB.Populate_Periodicity_Record (
71: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
72: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
73: ,x_Periodicities_Rec_Type => l_Periodicities_Rec_Type
74: ,x_Return_Status => x_Return_Status
75: ,x_Msg_Count => x_Msg_Count

Line 83: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: BSC_PERIODICITIES_PUB.Validate_Periodicity (
83: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
84: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
85: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE
86: ,x_Return_Status => x_Return_Status
87: ,x_Msg_Count => x_Msg_Count

Line 85: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE

81:
82: BSC_PERIODICITIES_PUB.Validate_Periodicity (
83: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
84: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
85: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE
86: ,x_Return_Status => x_Return_Status
87: ,x_Msg_Count => x_Msg_Count
88: ,x_Msg_Data => x_Msg_Data
89: );

Line 95: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: BSC_PERIODICITIES_PVT.Create_Periodicity (
95: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
96: ,p_Commit => p_Commit
97: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
98: ,x_Return_Status => x_Return_Status
99: ,x_Msg_Count => x_Msg_Count

Line 107: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
107: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
108: ,p_Commit => p_Commit
109: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE
110: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
111: ,p_disable_period_val_flag => p_disable_period_val_flag

Line 109: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE

105:
106: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
107: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
108: ,p_Commit => p_Commit
109: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_CREATE
110: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
111: ,p_disable_period_val_flag => p_disable_period_val_flag
112: ,x_Return_Status => x_Return_Status
113: ,x_Msg_Count => x_Msg_Count

Line 148: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);

144: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
145: l_Dim_Enabled := FND_API.G_FALSE;
146: END IF;
147:
148: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);
149: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period
150: ( p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id
151: , p_Periodicity_Name => l_Periodicities_Rec_Type.Name
152: );

Line 149: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period

145: l_Dim_Enabled := FND_API.G_FALSE;
146: END IF;
147:
148: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);
149: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period
150: ( p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id
151: , p_Periodicity_Name => l_Periodicities_Rec_Type.Name
152: );
153: -- passed p_Dim_Obj_Enabled = 'T' for Dimension Objects, Bug#4655119

Line 161: , p_data_source => BSC_PERIODS_UTILITY_PKG.C_PMF_DO_TYPE

157: , p_dim_obj_short_name => l_Periodicities_Rec_Type.Short_Name
158: , p_display_name => l_Dimobj_Name
159: , p_application_id => l_Periodicities_Rec_Type.Application_id
160: , p_description => l_Periodicities_Rec_Type.Description
161: , p_data_source => BSC_PERIODS_UTILITY_PKG.C_PMF_DO_TYPE
162: , p_source_table => l_Periodicity_View_Name
163: , p_where_clause => NULL
164: , p_comparison_label_code => NULL
165: , p_table_column => NULL

Line 166: , p_source_type => BSC_PERIODS_UTILITY_PKG.C_OLTP_DO_TYPE

162: , p_source_table => l_Periodicity_View_Name
163: , p_where_clause => NULL
164: , p_comparison_label_code => NULL
165: , p_table_column => NULL
166: , p_source_type => BSC_PERIODS_UTILITY_PKG.C_OLTP_DO_TYPE
167: , p_maximum_code_size => NULL
168: , p_maximum_name_size => NULL
169: , p_all_item_text => NULL
170: , p_comparison_item_text => NULL

Line 267: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

263:
264: l_Structural_Flag := FND_API.G_FALSE;
265:
266: BSC_PERIODICITIES_PUB.Validate_Periodicity (
267: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
268: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
269: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE
270: ,x_Return_Status => x_Return_Status
271: ,x_Msg_Count => x_Msg_Count

Line 269: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE

265:
266: BSC_PERIODICITIES_PUB.Validate_Periodicity (
267: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
268: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
269: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE
270: ,x_Return_Status => x_Return_Status
271: ,x_Msg_Count => x_Msg_Count
272: ,x_Msg_Data => x_Msg_Data
273: );

Line 290: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

286: ,x_Objective_List => l_Objective_List
287: );
288:
289: BSC_PERIODICITIES_PVT.Update_Periodicity (
290: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
291: ,p_Commit => p_Commit
292: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
293: ,x_Structural_Flag => l_Structural_Flag
294: ,x_Return_Status => x_Return_Status

Line 307: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

303: l_Structural_Flag := FND_API.G_TRUE;
304: END IF ;
305:
306: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
307: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
308: ,p_Commit => p_Commit
309: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE
310: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
311: ,p_disable_period_val_flag => p_disable_period_val_flag

Line 309: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE

305:
306: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
307: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
308: ,p_Commit => p_Commit
309: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_UPDATE
310: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type
311: ,p_disable_period_val_flag => p_disable_period_val_flag
312: ,x_Return_Status => x_Return_Status
313: ,x_Msg_Count => x_Msg_Count

Line 351: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);

347: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
348: l_Dim_Enabled := FND_API.G_FALSE;
349: END IF;
350:
351: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);
352: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period
353: ( p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id
354: , p_Periodicity_Name => l_Periodicities_Rec_Type.Name
355: );

Line 352: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period

348: l_Dim_Enabled := FND_API.G_FALSE;
349: END IF;
350:
351: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);
352: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period
353: ( p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id
354: , p_Periodicity_Name => l_Periodicities_Rec_Type.Name
355: );
356: -- passed p_Dim_Obj_Enabled = 'T' for Dimension Objects, Bug#4655119

Line 364: , p_Data_Source => BSC_PERIODS_UTILITY_PKG.C_PMF_DO_TYPE

360: , p_Dim_Obj_Short_Name => l_Periodicities_Rec_Type.Short_Name
361: , p_Display_Name => l_Dimobj_Name
362: , p_Application_Id => l_Periodicities_Rec_Type.Application_id
363: , p_Description => l_Periodicities_Rec_Type.Description
364: , p_Data_Source => BSC_PERIODS_UTILITY_PKG.C_PMF_DO_TYPE
365: , p_Source_Table => l_Periodicity_View_Name
366: , p_Where_Clause => NULL
367: , p_Comparison_Label_Code => NULL
368: , p_Table_Column => NULL

Line 369: , p_Source_Type => BSC_PERIODS_UTILITY_PKG.C_OLTP_DO_TYPE

365: , p_Source_Table => l_Periodicity_View_Name
366: , p_Where_Clause => NULL
367: , p_Comparison_Label_Code => NULL
368: , p_Table_Column => NULL
369: , p_Source_Type => BSC_PERIODS_UTILITY_PKG.C_OLTP_DO_TYPE
370: , p_Maximum_Code_Size => NULL
371: , p_Maximum_Name_Size => NULL
372: , p_All_Item_Text => NULL
373: , p_Comparison_Item_Text => NULL

Line 493: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

489: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Calendar_Id - ' ||p_Periodicities_Rec_Type.Calendar_Id);
490:
491:
492: BSC_PERIODICITIES_PUB.Validate_Periodicity (
493: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
494: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
495: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_DELETE
496: ,x_Return_Status => x_Return_Status
497: ,x_Msg_Count => x_Msg_Count

Line 495: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_DELETE

491:
492: BSC_PERIODICITIES_PUB.Validate_Periodicity (
493: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
494: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
495: ,p_Action_Type => BSC_PERIODS_UTILITY_PKG.C_DELETE
496: ,x_Return_Status => x_Return_Status
497: ,x_Msg_Count => x_Msg_Count
498: ,x_Msg_Data => x_Msg_Data
499: );

Line 504: l_Dim_Object_SN := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Short_Name(p_Periodicities_Rec_Type.Periodicity_Id);

500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: l_Dim_Object_SN := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Short_Name(p_Periodicities_Rec_Type.Periodicity_Id);
505: l_Dimension_SN := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(p_Periodicities_Rec_Type.Calendar_Id);
506: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_Dimension_SN||'+'||l_Dim_Object_SN);
507: IF(l_regions IS NOT NULL) THEN
508:

Line 505: l_Dimension_SN := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(p_Periodicities_Rec_Type.Calendar_Id);

501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: l_Dim_Object_SN := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Short_Name(p_Periodicities_Rec_Type.Periodicity_Id);
505: l_Dimension_SN := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(p_Periodicities_Rec_Type.Calendar_Id);
506: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_Dimension_SN||'+'||l_Dim_Object_SN);
507: IF(l_regions IS NOT NULL) THEN
508:
509: SELECT c.name

Line 528: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: BSC_PERIODICITIES_PVT.Delete_Periodicity (
528: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
529: ,p_Commit => p_Commit
530: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
531: ,x_Return_Status => x_Return_Status
532: ,x_Msg_Count => x_Msg_Count

Line 698: IF ((p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) OR (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE)) THEN

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

Line 706: IF (p_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_BASE_PERIODICITY_TYPE) THEN

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

Line 720: l_Is_Name_Unique := BSC_PERIODS_UTILITY_PKG.Is_Period_Name_Unique (

716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: END IF;
719:
720: l_Is_Name_Unique := BSC_PERIODS_UTILITY_PKG.Is_Period_Name_Unique (
721: p_Periodicities_Rec_Type.Calendar_Id
722: , p_Periodicities_Rec_Type.Name
723: );
724:

Line 734: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) THEN

730: END IF;
731:
732:
733:
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');

Line 741: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(

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: );
745: FND_MSG_PUB.ADD;

Line 762: l_Max_Periodicities := BSC_PERIODS_UTILITY_PKG.Get_Cust_Per_Cnt_By_Calendar(

758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: -- Validation#2:
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');

Line 765: IF(l_Max_Periodicities = BSC_PERIODS_UTILITY_PKG.C_MAX_CUSTOM_PERIODICITIES) THEN

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

Line 768: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(

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: );
772: FND_MSG_PUB.ADD;

Line 777: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN

773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775: END IF;
776:
777: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
778:
779: SELECT COUNT(1) INTO l_Count
780: FROM BSC_SYS_PERIODICITIES_VL P
781: WHERE P.NAME = p_Periodicities_Rec_Type.Name

Line 789: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(

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: );
793: FND_MSG_PUB.ADD;

Line 823: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_DELETE) THEN

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
824:
825: -- You cannot delete a BASE Periodicity
826: SELECT COUNT(1) INTO l_Count
827: FROM BSC_SYS_PERIODICITIES B

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 942: x_Periodicities_Rec_Type.Periodicity_Id := BSC_PERIODS_UTILITY_PKG.Get_Next_Periodicity_Id;

938: l_Base_Periodicity_Source := NULL;
939:
940: -- Get the next periodicity_id from sequence
941: IF (x_Periodicities_Rec_Type.Periodicity_Id IS NULL) THEN
942: x_Periodicities_Rec_Type.Periodicity_Id := BSC_PERIODS_UTILITY_PKG.Get_Next_Periodicity_Id;
943: END IF;
944:
945: IF (x_Periodicities_Rec_Type.Custom_Code IS NULL) THEN
946: x_Periodicities_Rec_Type.Custom_Code := BSC_PERIODS_UTILITY_PKG.C_CUSTOM_PERIODICITY_CODE;

Line 946: x_Periodicities_Rec_Type.Custom_Code := BSC_PERIODS_UTILITY_PKG.C_CUSTOM_PERIODICITY_CODE;

942: x_Periodicities_Rec_Type.Periodicity_Id := BSC_PERIODS_UTILITY_PKG.Get_Next_Periodicity_Id;
943: END IF;
944:
945: IF (x_Periodicities_Rec_Type.Custom_Code IS NULL) THEN
946: x_Periodicities_Rec_Type.Custom_Code := BSC_PERIODS_UTILITY_PKG.C_CUSTOM_PERIODICITY_CODE;
947: END IF;
948:
949: -- If the periodicity_type is Custom then differnt defaults needs to populated differently
950:

Line 951: IF (x_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_NON_CUSTOM_PERIODICITY_CODE) THEN

947: END IF;
948:
949: -- If the periodicity_type is Custom then differnt defaults needs to populated differently
950:
951: IF (x_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_NON_CUSTOM_PERIODICITY_CODE) THEN
952:
953: -- Populate the BSC_SYS_PERIODICITY.SOURCE column
954: IF (x_Periodicities_Rec_Type.Base_Periodicity_Id IS NOT NULL) THEN
955: /*l_Base_Periodicity_Source := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Source (

Line 955: /*l_Base_Periodicity_Source := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Source (

951: IF (x_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_NON_CUSTOM_PERIODICITY_CODE) THEN
952:
953: -- Populate the BSC_SYS_PERIODICITY.SOURCE column
954: IF (x_Periodicities_Rec_Type.Base_Periodicity_Id IS NOT NULL) THEN
955: /*l_Base_Periodicity_Source := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Source (
956: x_Periodicities_Rec_Type.Base_Periodicity_Id
957: );
958: IF (l_Base_Periodicity_Source IS NOT NULL) THEN
959: l_Base_Periodicity_Source := l_Base_Periodicity_Source ||

Line 973: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;

969: END IF;
970:
971: x_Periodicities_Rec_Type.Source := l_Base_Periodicity_Source;
972:
973: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;
974: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;
975: x_Periodicities_Rec_Type.Subperiod_Col_Name := NULL;
976: x_Periodicities_Rec_Type.Yearly_Flag := BSC_PERIODS_UTILITY_PKG.C_PERIODICITY_YEARLY_FLAG;
977: x_Periodicities_Rec_Type.Edw_Flag := 0; -- not used anymore

Line 974: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;

970:
971: x_Periodicities_Rec_Type.Source := l_Base_Periodicity_Source;
972:
973: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;
974: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;
975: x_Periodicities_Rec_Type.Subperiod_Col_Name := NULL;
976: x_Periodicities_Rec_Type.Yearly_Flag := BSC_PERIODS_UTILITY_PKG.C_PERIODICITY_YEARLY_FLAG;
977: x_Periodicities_Rec_Type.Edw_Flag := 0; -- not used anymore
978: x_Periodicities_Rec_Type.Edw_Periodicity_Id := NULL; -- not used anymore

Line 976: x_Periodicities_Rec_Type.Yearly_Flag := BSC_PERIODS_UTILITY_PKG.C_PERIODICITY_YEARLY_FLAG;

972:
973: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;
974: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;
975: x_Periodicities_Rec_Type.Subperiod_Col_Name := NULL;
976: x_Periodicities_Rec_Type.Yearly_Flag := BSC_PERIODS_UTILITY_PKG.C_PERIODICITY_YEARLY_FLAG;
977: x_Periodicities_Rec_Type.Edw_Flag := 0; -- not used anymore
978: x_Periodicities_Rec_Type.Edw_Periodicity_Id := NULL; -- not used anymore
979:
980: IF(x_Periodicities_Rec_Type.Db_Column_Name IS NULL) THEN

Line 981: x_Periodicities_Rec_Type.Db_Column_Name := BSC_PERIODS_UTILITY_PKG.Get_Next_Cust_Period_DB_Column (

977: x_Periodicities_Rec_Type.Edw_Flag := 0; -- not used anymore
978: x_Periodicities_Rec_Type.Edw_Periodicity_Id := NULL; -- not used anymore
979:
980: IF(x_Periodicities_Rec_Type.Db_Column_Name IS NULL) THEN
981: x_Periodicities_Rec_Type.Db_Column_Name := BSC_PERIODS_UTILITY_PKG.Get_Next_Cust_Period_DB_Column (
982: l_Calendar_Id
983: );
984: END IF;
985:

Line 986: x_Periodicities_Rec_Type.Periodicity_Type := BSC_PERIODS_UTILITY_PKG.C_CUST_PERIODICITY_TYPE;

982: l_Calendar_Id
983: );
984: END IF;
985:
986: x_Periodicities_Rec_Type.Periodicity_Type := BSC_PERIODS_UTILITY_PKG.C_CUST_PERIODICITY_TYPE;
987: x_Periodicities_Rec_Type.Period_Type_Id := NULL;
988: x_Periodicities_Rec_Type.Record_Type_Id := NULL;
989: x_Periodicities_Rec_Type.Xtd_Pattern := NULL;
990:

Line 992: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;

988: x_Periodicities_Rec_Type.Record_Type_Id := NULL;
989: x_Periodicities_Rec_Type.Xtd_Pattern := NULL;
990:
991: ELSE -- else these periodicities are of BSC type
992: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;
993:
994: IF (x_Periodicities_Rec_Type.Period_Col_Name IS NULL) THEN
995: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;
996: END IF;

Line 995: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;

991: ELSE -- else these periodicities are of BSC type
992: x_Periodicities_Rec_Type.Num_Of_Subperiods := BSC_PERIODS_UTILITY_PKG.C_CUST_NUM_OF_SUBPERIODS;
993:
994: IF (x_Periodicities_Rec_Type.Period_Col_Name IS NULL) THEN
995: x_Periodicities_Rec_Type.Period_Col_Name := BSC_PERIODS_UTILITY_PKG.C_DFLT_PERIOD_COL_NAME;
996: END IF;
997:
998: x_Periodicities_Rec_Type.Subperiod_Col_Name := NULL;
999:

Line 1001: x_Periodicities_Rec_Type.Yearly_Flag := BSC_PERIODS_UTILITY_PKG.C_PERIODICITY_YEARLY_FLAG;

997:
998: x_Periodicities_Rec_Type.Subperiod_Col_Name := NULL;
999:
1000: IF (x_Periodicities_Rec_Type.Yearly_Flag IS NULL) THEN
1001: x_Periodicities_Rec_Type.Yearly_Flag := BSC_PERIODS_UTILITY_PKG.C_PERIODICITY_YEARLY_FLAG;
1002: END IF;
1003:
1004: x_Periodicities_Rec_Type.Edw_Flag := 0; -- not used anymore
1005: x_Periodicities_Rec_Type.Edw_Periodicity_Id := NULL; -- not used anymore

Line 1014: x_Periodicities_Rec_Type.Short_Name := BSC_PERIODS_UTILITY_PKG.generate_Period_Short_Name

1010:
1011: END IF;
1012:
1013: IF (x_Periodicities_Rec_Type.Short_Name IS NULL) THEN
1014: x_Periodicities_Rec_Type.Short_Name := BSC_PERIODS_UTILITY_PKG.generate_Period_Short_Name
1015: ( l_Calendar_Id
1016: , x_Periodicities_Rec_Type.Periodicity_Id
1017: );
1018: END IF;

Line 1022: x_Periodicities_Rec_Type.Application_Id := BSC_PERIODS_UTILITY_PKG.C_BSC_APPLICATION_ID;

1018: END IF;
1019:
1020:
1021: IF (x_Periodicities_Rec_Type.Application_Id IS NULL) THEN
1022: x_Periodicities_Rec_Type.Application_Id := BSC_PERIODS_UTILITY_PKG.C_BSC_APPLICATION_ID;
1023: END IF;
1024:
1025: IF (x_Periodicities_Rec_Type.Created_By IS NULL) THEN
1026: x_Periodicities_Rec_Type.Created_By := FND_GLOBAL.USER_ID;

Line 1103: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) THEN

1099: IF (l_Period_Record.Last_Update_Login IS NULL) THEN
1100: l_Period_Record.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1101: END IF;
1102:
1103: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) THEN
1104: BSC_PERIODS_PUB.Create_Periods
1105: (
1106: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1107: , p_Commit => p_Commit

Line 1106: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

1102:
1103: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) THEN
1104: BSC_PERIODS_PUB.Create_Periods
1105: (
1106: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1107: , p_Commit => p_Commit
1108: , p_Period_Record => l_Period_Record
1109: , p_disable_period_val_flag => p_disable_period_val_flag
1110: , x_Return_Status => x_Return_Status

Line 1117: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN

1113: );
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
1118: BSC_PERIODS_PUB.Update_Periods
1119: (
1120: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1121: , p_Commit => p_Commit

Line 1120: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

1116: END IF;
1117: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
1118: BSC_PERIODS_PUB.Update_Periods
1119: (
1120: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1121: , p_Commit => p_Commit
1122: , p_Period_Record => l_Period_Record
1123: , x_Structual_Change => l_Struct_Flag
1124: , p_disable_period_val_flag => p_disable_period_val_flag

Line 1190: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

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
1191: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
1192: ,x_Periodicities_Rec_Type => x_Periodicities_Rec_Type
1193: ,x_Return_Status => x_Return_Status
1194: ,x_Msg_Count => x_Msg_Count

Line 1253: IF(BSC_PERIODS_UTILITY_PKG.Check_Error_Message('BSC_UPDATE_UTIL.UpdAnualPeriodicitySrc')) THEN

1249: , x_periodicity_id => p_Periodicity_Id
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;

Line 1328: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

1324: l1_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_Id;
1325: l_Structural_Flag := FND_API.G_FALSE;
1326:
1327: BSC_PERIODICITIES_PUB.Retrieve_Periodicity (
1328: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1329: ,p_Periodicities_Rec_Type => l1_Periodicities_Rec_Type
1330: ,x_Periodicities_Rec_Type => l2_Periodicities_Rec_Type
1331: ,x_Return_Status => l_Return_Status
1332: ,x_Msg_Count => l_Msg_Count