DBA Data[Home] [Help]

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on FND_MSG_PUB

Line 29: FND_MSG_PUB.Initialize;

25: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
26:
27:
28: BEGIN
29: FND_MSG_PUB.Initialize;
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: SAVEPOINT BSCCheDimLevsPUB;
32: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels' );
33: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels p_Tab_Id = ' || p_Tab_Id );

Line 123: FND_MSG_PUB.Count_And_Get

119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO BSCCheDimLevsPUB;
123: FND_MSG_PUB.Count_And_Get
124: ( p_encoded => FND_API.G_FALSE
125: , p_count => x_msg_count
126: , p_data => x_msg_data
127: );

Line 133: FND_MSG_PUB.Count_And_Get

129: x_return_status := FND_API.G_RET_STS_ERROR;
130: RAISE;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO BSCCheDimLevsPUB;
133: FND_MSG_PUB.Count_And_Get
134: ( p_encoded => FND_API.G_FALSE
135: , p_count => x_msg_count
136: , p_data => x_msg_data
137: );

Line 184: FND_MSG_PUB.Initialize;

180:
181: l_tab_id number;
182:
183: BEGIN
184: FND_MSG_PUB.Initialize;
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186: SAVEPOINT BSCCheDimLevsDL_PUB;
187: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels_DL' );
188: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels_DL p_Dim_Level_Id = ' || p_Dim_Level_Id );

Line 209: FND_MSG_PUB.Count_And_Get

205: if c_tabs_to_check%isopen then
206: close c_tabs_to_check;
207: end if;
208: ROLLBACK TO BSCCheDimLevsDL_PUB;
209: FND_MSG_PUB.Count_And_Get
210: ( p_encoded => FND_API.G_FALSE
211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );

Line 222: FND_MSG_PUB.Count_And_Get

218: if c_tabs_to_check%isopen then
219: close c_tabs_to_check;
220: end if;
221: ROLLBACK TO BSCCheDimLevsDL_PUB;
222: FND_MSG_PUB.Count_And_Get
223: ( p_encoded => FND_API.G_FALSE
224: , p_count => x_msg_count
225: , p_data => x_msg_data
226: );

Line 268: FND_MSG_PUB.Initialize;

264:
265: l_tab_id number;
266:
267: BEGIN
268: FND_MSG_PUB.Initialize;
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: SAVEPOINT BSCCheckCDimByDim;
271: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels_by_Dim' );
272: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels_by_Dim p_Dimension_Id = ' || p_Dimension_Id );

Line 293: FND_MSG_PUB.Count_And_Get

289: if c_tabs_to_check%isopen then
290: close c_tabs_to_check;
291: end if;
292: ROLLBACK TO BSCCheckCDimByDim;
293: FND_MSG_PUB.Count_And_Get
294: ( p_encoded => FND_API.G_FALSE
295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );

Line 306: FND_MSG_PUB.Count_And_Get

302: if c_tabs_to_check%isopen then
303: close c_tabs_to_check;
304: end if;
305: ROLLBACK TO BSCCheckCDimByDim;
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 407: FND_MSG_PUB.Initialize;

403: l_Last_Dim_Set_Id NUMBER;
404: l_Firt_Dim_Family_Flag BOOLEAN;
405:
406: BEGIN
407: FND_MSG_PUB.Initialize;
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: --DBMS_OUTPUT.PUT_LINE('Begin Find_Common_Dim_Levels');
410:
411: --Evaluate that not KPI in the tab has PMF Measures as Default One

Line 545: FND_MSG_PUB.Count_And_Get

541: commit;
542: */
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => FND_API.G_FALSE
547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );

Line 554: FND_MSG_PUB.Count_And_Get

550: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: RAISE;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: FND_MSG_PUB.Count_And_Get
555: ( p_encoded => FND_API.G_FALSE
556: , p_count => x_msg_count
557: , p_data => x_msg_data
558: );

Line 616: FND_MSG_PUB.Initialize;

612: AND SL.DIM_LEVEL_ID (+) = CL.DIM_LEVEL_ID
613: ORDER BY CL.DIM_LEVEL_INDEX;
614:
615: BEGIN
616: FND_MSG_PUB.Initialize;
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: --DBMS_OUTPUT.PUT_LINE('Begin Retrieve_Common_Dim_Levels');
619:
620: v_Index := 0;

Line 643: FND_MSG_PUB.Count_And_Get

639: --DBMS_OUTPUT.PUT_LINE('End Retrieve_Common_Dim_Levels');
640:
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: FND_MSG_PUB.Count_And_Get
644: ( p_encoded => FND_API.G_FALSE
645: , p_count => x_msg_count
646: , p_data => x_msg_data
647: );

Line 652: FND_MSG_PUB.Count_And_Get

648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: RAISE;
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data
656: );

Line 702: FND_MSG_PUB.Initialize;

698: FROM BSC_TAB_INDICATORS
699: WHERE TAB_ID = p_Tab_Id;
700:
701: BEGIN
702: FND_MSG_PUB.Initialize;
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704: SAVEPOINT BSCChkDimLevDefPUB;
705:
706: --DBMS_OUTPUT.PUT_LINE('Begin Check_Dim_Level_Default_Value');

Line 741: FND_MSG_PUB.Count_And_Get

737:
738: EXCEPTION
739: WHEN FND_API.G_EXC_ERROR THEN
740: ROLLBACK TO BSCChkDimLevDefPUB;
741: FND_MSG_PUB.Count_And_Get
742: ( p_encoded => FND_API.G_FALSE
743: , p_count => x_msg_count
744: , p_data => x_msg_data
745: );

Line 751: FND_MSG_PUB.Count_And_Get

747: x_return_status := FND_API.G_RET_STS_ERROR;
748: RAISE;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO BSCChkDimLevDefPUB;
751: FND_MSG_PUB.Count_And_Get
752: ( p_encoded => FND_API.G_FALSE
753: , p_count => x_msg_count
754: , p_data => x_msg_data
755: );

Line 830: FND_MSG_PUB.Initialize;

826: FROM BSC_TAB_INDICATORS
827: WHERE indicator = l_Kpi_Id;
828:
829: BEGIN
830: FND_MSG_PUB.Initialize;
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: IF(p_Kpi_Id IS NOT NULL) THEN
834: l_Kpi_Id := p_Kpi_Id;

Line 893: FND_MSG_PUB.Count_And_Get

889: END IF;
890:
891: EXCEPTION
892: WHEN FND_API.G_EXC_ERROR THEN
893: FND_MSG_PUB.Count_And_Get
894: ( p_encoded => FND_API.G_FALSE
895: , p_count => x_msg_count
896: , p_data => x_msg_data
897: );

Line 902: FND_MSG_PUB.Count_And_Get

898: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: RAISE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: FND_MSG_PUB.Count_And_Get
903: ( p_encoded => FND_API.G_FALSE
904: , p_count => x_msg_count
905: , p_data => x_msg_data
906: );