DBA Data[Home] [Help]

APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_COPY_INDICATOR_PUB

Line 1: PACKAGE BODY BSC_COPY_INDICATOR_PUB AS

1: PACKAGE BODY BSC_COPY_INDICATOR_PUB AS
2: /* $Header: BSCPCINB.pls 120.7.12000000.1 2007/07/17 07:43:41 appldev noship $ */
3: /*=======================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 197: x_msg_data := x_msg_data || ' ->BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';

193: WHEN NO_DATA_FOUND THEN
194: ROLLBACK TO BscAssignIndGroupTab;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: IF (x_msg_data IS NOT NULL) THEN
197: x_msg_data := x_msg_data || ' ->BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
198: ELSE
199: x_msg_data := SQLERRM || 'at BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
200: END IF;
201: WHEN OTHERS THEN

Line 199: x_msg_data := SQLERRM || 'at BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';

195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: IF (x_msg_data IS NOT NULL) THEN
197: x_msg_data := x_msg_data || ' ->BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
198: ELSE
199: x_msg_data := SQLERRM || 'at BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
200: END IF;
201: WHEN OTHERS THEN
202: ROLLBACK TO BscAssignIndGroupTab;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 205: x_msg_data := x_msg_data || ' ->BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';

201: WHEN OTHERS THEN
202: ROLLBACK TO BscAssignIndGroupTab;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: IF (x_msg_data IS NOT NULL) THEN
205: x_msg_data := x_msg_data || ' ->BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
206: ELSE
207: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
208: END IF;
209: END Assign_Ind_Group_To_Tab;

Line 207: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';

203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: IF (x_msg_data IS NOT NULL) THEN
205: x_msg_data := x_msg_data || ' ->BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
206: ELSE
207: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Assign_Ind_Group_To_Tab ';
208: END IF;
209: END Assign_Ind_Group_To_Tab;
210:
211: /************************************************************************************

Line 260: IF l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type = BSC_COPY_INDICATOR_PUB.INDICATOR_BELOW_NAME

256: ind_group_id = p_New_Indicator_Group
257: AND prototype_flag <> -2
258: AND share_flag <> 2;
259:
260: IF l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type = BSC_COPY_INDICATOR_PUB.INDICATOR_BELOW_NAME
261: AND l_Kpi_Count >= 1 THEN
262: l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type := BSC_COPY_INDICATOR_PUB.INDICATOR_BESIDE_NAME;
263: END IF;
264:

Line 262: l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type := BSC_COPY_INDICATOR_PUB.INDICATOR_BESIDE_NAME;

258: AND share_flag <> 2;
259:
260: IF l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type = BSC_COPY_INDICATOR_PUB.INDICATOR_BELOW_NAME
261: AND l_Kpi_Count >= 1 THEN
262: l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Type := BSC_COPY_INDICATOR_PUB.INDICATOR_BESIDE_NAME;
263: END IF;
264:
265: BSC_KPI_GROUP_PUB.Update_Kpi_Group(
266: p_commit => FND_API.G_FALSE

Line 304: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';

300: WHEN NO_DATA_FOUND THEN
301: ROLLBACK TO BscUpdateKpiGroupProperties;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: IF (x_msg_data IS NOT NULL) THEN
304: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
305: ELSE
306: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
307: END IF;
308: WHEN OTHERS THEN

Line 306: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';

302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: IF (x_msg_data IS NOT NULL) THEN
304: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
305: ELSE
306: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
307: END IF;
308: WHEN OTHERS THEN
309: ROLLBACK TO BscUpdateKpiGroupProperties;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 312: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';

308: WHEN OTHERS THEN
309: ROLLBACK TO BscUpdateKpiGroupProperties;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF (x_msg_data IS NOT NULL) THEN
312: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
313: ELSE
314: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
315: END IF;
316: END Update_Kpi_Group_Properties;

Line 314: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF (x_msg_data IS NOT NULL) THEN
312: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
313: ELSE
314: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Update_Kpi_Group_Properties ';
315: END IF;
316: END Update_Kpi_Group_Properties;
317: /************************************************************************************
318: -- API name : Move_Indicator

Line 416: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator ';

412: WHEN NO_DATA_FOUND THEN
413: ROLLBACK TO BscMovIndicatorSavePnt;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF (x_msg_data IS NOT NULL) THEN
416: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator ';
417: ELSE
418: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator ';
419: END IF;
420: WHEN OTHERS THEN

Line 418: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator ';

414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF (x_msg_data IS NOT NULL) THEN
416: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator ';
417: ELSE
418: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator ';
419: END IF;
420: WHEN OTHERS THEN
421: ROLLBACK TO BscMovIndicatorSavePnt;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 424: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator ';

420: WHEN OTHERS THEN
421: ROLLBACK TO BscMovIndicatorSavePnt;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF (x_msg_data IS NOT NULL) THEN
424: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator ';
425: ELSE
426: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator ';
427: END IF;
428: END Move_Indicator;

Line 426: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator ';

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF (x_msg_data IS NOT NULL) THEN
424: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator ';
425: ELSE
426: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator ';
427: END IF;
428: END Move_Indicator;
429:
430: /************************************************************************************

Line 574: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';

570: WHEN NO_DATA_FOUND THEN
571: ROLLBACK TO BscRepositionIndicatorSavePnt;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: IF (x_msg_data IS NOT NULL) THEN
574: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
575: ELSE
576: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
577: END IF;
578: WHEN OTHERS THEN

Line 576: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';

572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: IF (x_msg_data IS NOT NULL) THEN
574: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
575: ELSE
576: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
577: END IF;
578: WHEN OTHERS THEN
579: ROLLBACK TO BscRepositionIndicatorSavePnt;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 582: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';

578: WHEN OTHERS THEN
579: ROLLBACK TO BscRepositionIndicatorSavePnt;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF (x_msg_data IS NOT NULL) THEN
582: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
583: ELSE
584: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
585: END IF;
586: END Reposition_Indicator;

Line 584: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';

580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF (x_msg_data IS NOT NULL) THEN
582: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
583: ELSE
584: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Reposition_Indicator ';
585: END IF;
586: END Reposition_Indicator;
587:
588: /************************************************************************************

Line 743: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';

739: WHEN NO_DATA_FOUND THEN
740: ROLLBACK TO BscMovIndicatorUIWrap;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: IF (x_msg_data IS NOT NULL) THEN
743: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
744: ELSE
745: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
746: END IF;
747: WHEN OTHERS THEN

Line 745: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';

741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: IF (x_msg_data IS NOT NULL) THEN
743: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
744: ELSE
745: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
746: END IF;
747: WHEN OTHERS THEN
748: ROLLBACK TO BscMovIndicatorUIWrap;
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 751: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';

747: WHEN OTHERS THEN
748: ROLLBACK TO BscMovIndicatorUIWrap;
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: IF (x_msg_data IS NOT NULL) THEN
751: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
752: ELSE
753: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
754: END IF;
755: END Move_Indicator_UI_Wrap;

Line 753: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';

749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: IF (x_msg_data IS NOT NULL) THEN
751: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
752: ELSE
753: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Move_Indicator_UI_Wrap ';
754: END IF;
755: END Move_Indicator_UI_Wrap;
756:
757:

Line 849: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';

845: WHEN NO_DATA_FOUND THEN
846: ROLLBACK TO BscValIndCopyUIWrap;
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: IF (x_msg_data IS NOT NULL) THEN
849: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
850: ELSE
851: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
852: END IF;
853: WHEN OTHERS THEN

Line 851: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';

847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: IF (x_msg_data IS NOT NULL) THEN
849: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
850: ELSE
851: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
852: END IF;
853: WHEN OTHERS THEN
854: ROLLBACK TO BscValIndCopyUIWrap;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 857: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';

853: WHEN OTHERS THEN
854: ROLLBACK TO BscValIndCopyUIWrap;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: IF (x_msg_data IS NOT NULL) THEN
857: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
858: ELSE
859: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
860: END IF;
861: END Validate_Indicator_Copy;

Line 859: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';

855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: IF (x_msg_data IS NOT NULL) THEN
857: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
858: ELSE
859: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Validate_Indicator_Copy ';
860: END IF;
861: END Validate_Indicator_Copy;
862:
863: /************************************************************************************

Line 955: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Lock_Target_Entities ';

951: EXCEPTION
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: IF (x_msg_data IS NOT NULL) THEN
955: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Lock_Target_Entities ';
956: ELSE
957: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Lock_Target_Entities ';
958: END IF;
959: END Lock_Target_Entities;

Line 957: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Lock_Target_Entities ';

953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: IF (x_msg_data IS NOT NULL) THEN
955: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.Lock_Target_Entities ';
956: ELSE
957: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.Lock_Target_Entities ';
958: END IF;
959: END Lock_Target_Entities;
960:
961: /************************************************************************************

Line 1022: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';

1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: WHEN NO_DATA_FOUND THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: IF (x_msg_data IS NOT NULL) THEN
1022: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1023: ELSE
1024: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1025: END IF;
1026: WHEN OTHERS THEN

Line 1024: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';

1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: IF (x_msg_data IS NOT NULL) THEN
1022: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1023: ELSE
1024: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1025: END IF;
1026: WHEN OTHERS THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: IF (x_msg_data IS NOT NULL) THEN

Line 1029: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';

1025: END IF;
1026: WHEN OTHERS THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: IF (x_msg_data IS NOT NULL) THEN
1029: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1030: ELSE
1031: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1032: END IF;
1033: END Create_Kpi_Access_Wrap;

Line 1031: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';

1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: IF (x_msg_data IS NOT NULL) THEN
1029: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1030: ELSE
1031: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Create_Kpi_Access_Wrap ';
1032: END IF;
1033: END Create_Kpi_Access_Wrap;
1034:
1035:

Line 1134: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';

1130: WHEN NO_DATA_FOUND THEN
1131: ROLLBACK TO BscCopyIndicAnaMeasPub;
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1133: IF (x_msg_data IS NOT NULL) THEN
1134: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1135: ELSE
1136: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1137: END IF;
1138: WHEN OTHERS THEN

Line 1136: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';

1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1133: IF (x_msg_data IS NOT NULL) THEN
1134: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1135: ELSE
1136: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1137: END IF;
1138: WHEN OTHERS THEN
1139: ROLLBACK TO BscCopyIndicAnaMeasPub;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1142: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';

1138: WHEN OTHERS THEN
1139: ROLLBACK TO BscCopyIndicAnaMeasPub;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141: IF (x_msg_data IS NOT NULL) THEN
1142: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1143: ELSE
1144: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1145: END IF;
1146: END Copy_Analysis_Measures;

Line 1144: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';

1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141: IF (x_msg_data IS NOT NULL) THEN
1142: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1143: ELSE
1144: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Analysis_Measures ';
1145: END IF;
1146: END Copy_Analysis_Measures;
1147:
1148: /************************************************************************************

Line 1223: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';

1219: WHEN NO_DATA_FOUND THEN
1220: ROLLBACK TO BscUpdAnnCurPeriod;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: IF (x_msg_data IS NOT NULL) THEN
1223: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1224: ELSE
1225: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1226: END IF;
1227: WHEN OTHERS THEN

Line 1225: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';

1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: IF (x_msg_data IS NOT NULL) THEN
1223: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1224: ELSE
1225: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1226: END IF;
1227: WHEN OTHERS THEN
1228: ROLLBACK TO BscUpdAnnCurPeriod;
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1231: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';

1227: WHEN OTHERS THEN
1228: ROLLBACK TO BscUpdAnnCurPeriod;
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230: IF (x_msg_data IS NOT NULL) THEN
1231: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1232: ELSE
1233: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1234: END IF;
1235: END Update_Annual_Current_Period;

Line 1233: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';

1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230: IF (x_msg_data IS NOT NULL) THEN
1231: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1232: ELSE
1233: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Update_Annual_Current_Period ';
1234: END IF;
1235: END Update_Annual_Current_Period;
1236:
1237: /************************************************************************************

Line 1453: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';

1449: WHEN NO_DATA_FOUND THEN
1450: ROLLBACK TO BscCopyIndicPeriodsPub;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: IF (x_msg_data IS NOT NULL) THEN
1453: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1454: ELSE
1455: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1456: END IF;
1457: WHEN OTHERS THEN

Line 1455: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';

1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: IF (x_msg_data IS NOT NULL) THEN
1453: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1454: ELSE
1455: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1456: END IF;
1457: WHEN OTHERS THEN
1458: ROLLBACK TO BscCopyIndicPeriodsPub;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1461: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';

1457: WHEN OTHERS THEN
1458: ROLLBACK TO BscCopyIndicPeriodsPub;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: IF (x_msg_data IS NOT NULL) THEN
1461: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1462: ELSE
1463: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1464: END IF;
1465: END Copy_Periodicities;

Line 1463: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';

1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: IF (x_msg_data IS NOT NULL) THEN
1461: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1462: ELSE
1463: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Periodicities ';
1464: END IF;
1465: END Copy_Periodicities;
1466:
1467:

Line 1550: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';

1546: WHEN NO_DATA_FOUND THEN
1547: ROLLBACK TO BscCopyUpdKpiProps;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: IF (x_msg_data IS NOT NULL) THEN
1550: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1551: ELSE
1552: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1553: END IF;
1554: WHEN OTHERS THEN

Line 1552: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';

1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: IF (x_msg_data IS NOT NULL) THEN
1550: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1551: ELSE
1552: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1553: END IF;
1554: WHEN OTHERS THEN
1555: ROLLBACK TO BscCopyUpdKpiProps;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1558: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';

1554: WHEN OTHERS THEN
1555: ROLLBACK TO BscCopyUpdKpiProps;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF (x_msg_data IS NOT NULL) THEN
1558: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1559: ELSE
1560: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1561: END IF;
1562: END Update_Bsc_Kpi_Props;

Line 1560: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';

1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF (x_msg_data IS NOT NULL) THEN
1558: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1559: ELSE
1560: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Update_Bsc_Kpi_Props ';
1561: END IF;
1562: END Update_Bsc_Kpi_Props;
1563:
1564: /************************************************************************************

Line 1726: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';

1722: WHEN NO_DATA_FOUND THEN
1723: ROLLBACK TO BscCopyDimLevProps;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: IF (x_msg_data IS NOT NULL) THEN
1726: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1727: ELSE
1728: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1729: END IF;
1730: WHEN OTHERS THEN

Line 1728: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';

1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: IF (x_msg_data IS NOT NULL) THEN
1726: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1727: ELSE
1728: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1729: END IF;
1730: WHEN OTHERS THEN
1731: ROLLBACK TO BscCopyDimLevProps;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1734: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';

1730: WHEN OTHERS THEN
1731: ROLLBACK TO BscCopyDimLevProps;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1733: IF (x_msg_data IS NOT NULL) THEN
1734: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1735: ELSE
1736: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1737: END IF;
1738: END Copy_Dim_Level_Props;

Line 1736: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';

1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1733: IF (x_msg_data IS NOT NULL) THEN
1734: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1735: ELSE
1736: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Copy_Dim_Level_Props ';
1737: END IF;
1738: END Copy_Dim_Level_Props;
1739:
1740: /************************************************************************************

Line 1954: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';

1950: WHEN NO_DATA_FOUND THEN
1951: ROLLBACK TO BscChkKeyItemProps;
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: IF (x_msg_data IS NOT NULL) THEN
1954: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1955: ELSE
1956: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1957: END IF;
1958: WHEN OTHERS THEN

Line 1956: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';

1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: IF (x_msg_data IS NOT NULL) THEN
1954: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1955: ELSE
1956: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1957: END IF;
1958: WHEN OTHERS THEN
1959: ROLLBACK TO BscChkKeyItemProps;
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1962: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';

1958: WHEN OTHERS THEN
1959: ROLLBACK TO BscChkKeyItemProps;
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961: IF (x_msg_data IS NOT NULL) THEN
1962: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1963: ELSE
1964: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1965: END IF;
1966: END Check_Key_Item_Props;

Line 1964: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';

1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961: IF (x_msg_data IS NOT NULL) THEN
1962: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1963: ELSE
1964: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Key_Item_Props ';
1965: END IF;
1966: END Check_Key_Item_Props;
1967:
1968:

Line 2066: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';

2062: WHEN NO_DATA_FOUND THEN
2063: ROLLBACK TO BscChkColorByTotal;
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: IF (x_msg_data IS NOT NULL) THEN
2066: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2067: ELSE
2068: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2069: END IF;
2070: WHEN OTHERS THEN

Line 2068: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';

2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: IF (x_msg_data IS NOT NULL) THEN
2066: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2067: ELSE
2068: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2069: END IF;
2070: WHEN OTHERS THEN
2071: ROLLBACK TO BscChkColorByTotal;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2074: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';

2070: WHEN OTHERS THEN
2071: ROLLBACK TO BscChkColorByTotal;
2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: IF (x_msg_data IS NOT NULL) THEN
2074: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2075: ELSE
2076: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2077: END IF;
2078: END Check_Color_By_Total_Props;

Line 2076: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';

2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: IF (x_msg_data IS NOT NULL) THEN
2074: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2075: ELSE
2076: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Color_By_Total_Props ';
2077: END IF;
2078: END Check_Color_By_Total_Props;
2079:
2080: /************************************************************************************

Line 2178: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';

2174: WHEN NO_DATA_FOUND THEN
2175: ROLLBACK TO BscCopyIndicPLUpd;
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: IF (x_msg_data IS NOT NULL) THEN
2178: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2179: ELSE
2180: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2181: END IF;
2182: WHEN OTHERS THEN

Line 2180: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';

2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: IF (x_msg_data IS NOT NULL) THEN
2178: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2179: ELSE
2180: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2181: END IF;
2182: WHEN OTHERS THEN
2183: ROLLBACK TO BscCopyIndicPLUpd;
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2186: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';

2182: WHEN OTHERS THEN
2183: ROLLBACK TO BscCopyIndicPLUpd;
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: IF (x_msg_data IS NOT NULL) THEN
2186: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2187: ELSE
2188: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2189: END IF;
2190: END Check_Profit_Loss_Properties;

Line 2188: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';

2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: IF (x_msg_data IS NOT NULL) THEN
2186: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2187: ELSE
2188: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Profit_Loss_Properties ';
2189: END IF;
2190: END Check_Profit_Loss_Properties;
2191:
2192: /************************************************************************************

Line 2276: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';

2272: WHEN NO_DATA_FOUND THEN
2273: ROLLBACK TO BscCopyDfltDataTbl;
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: IF (x_msg_data IS NOT NULL) THEN
2276: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2277: ELSE
2278: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2279: END IF;
2280: WHEN OTHERS THEN

Line 2278: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';

2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: IF (x_msg_data IS NOT NULL) THEN
2276: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2277: ELSE
2278: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2279: END IF;
2280: WHEN OTHERS THEN
2281: ROLLBACK TO BscCopyDfltDataTbl;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2284: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';

2280: WHEN OTHERS THEN
2281: ROLLBACK TO BscCopyDfltDataTbl;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2283: IF (x_msg_data IS NOT NULL) THEN
2284: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2285: ELSE
2286: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2287: END IF;
2288: END Check_Default_Record_Data_Tbls;

Line 2286: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';

2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2283: IF (x_msg_data IS NOT NULL) THEN
2284: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2285: ELSE
2286: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_Default_Record_Data_Tbls ';
2287: END IF;
2288: END Check_Default_Record_Data_Tbls;
2289:
2290: /************************************************************************************

Line 2396: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';

2392: WHEN NO_DATA_FOUND THEN
2393: ROLLBACK TO BscCopyIndicChkKpiName;
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: IF (x_msg_data IS NOT NULL) THEN
2396: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2397: ELSE
2398: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2399: END IF;
2400: WHEN OTHERS THEN

Line 2398: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';

2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: IF (x_msg_data IS NOT NULL) THEN
2396: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2397: ELSE
2398: x_msg_data := SQLERRM||' at BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2399: END IF;
2400: WHEN OTHERS THEN
2401: ROLLBACK TO BscCopyIndicChkKpiName;
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2404: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';

2400: WHEN OTHERS THEN
2401: ROLLBACK TO BscCopyIndicChkKpiName;
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: IF (x_msg_data IS NOT NULL) THEN
2404: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2405: ELSE
2406: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2407: END IF;
2408: END Check_KPI_Name;

Line 2406: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';

2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: IF (x_msg_data IS NOT NULL) THEN
2404: x_msg_data := x_msg_data||' -> BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2405: ELSE
2406: x_msg_data := SQLERRM||' AT BSC_COPY_INDICATOR_PUB.Check_KPI_Name ';
2407: END IF;
2408: END Check_KPI_Name;
2409:
2410: /************************************************************************************

Line 2765: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';

2761: WHEN NO_DATA_FOUND THEN
2762: ROLLBACK TO BscCopyIndicatorUIWrap;
2763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2764: IF (x_msg_data IS NOT NULL) THEN
2765: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2766: ELSE
2767: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2768: END IF;
2769: WHEN OTHERS THEN

Line 2767: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';

2763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2764: IF (x_msg_data IS NOT NULL) THEN
2765: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2766: ELSE
2767: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2768: END IF;
2769: WHEN OTHERS THEN
2770: ROLLBACK TO BscCopyIndicatorUIWrap;
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2773: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';

2769: WHEN OTHERS THEN
2770: ROLLBACK TO BscCopyIndicatorUIWrap;
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: IF (x_msg_data IS NOT NULL) THEN
2773: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2774: ELSE
2775: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2776: END IF;
2777: END CopyNew_Indicator_UI_Wrap;

Line 2775: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';

2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: IF (x_msg_data IS NOT NULL) THEN
2773: x_msg_data := x_msg_data || ' -> BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2774: ELSE
2775: x_msg_data := SQLERRM || ' at BSC_COPY_INDICATOR_PUB.CopyNew_Indicator_UI_Wrap ';
2776: END IF;
2777: END CopyNew_Indicator_UI_Wrap;
2778:
2779:

Line 2780: END BSC_COPY_INDICATOR_PUB;

2776: END IF;
2777: END CopyNew_Indicator_UI_Wrap;
2778:
2779:
2780: END BSC_COPY_INDICATOR_PUB;