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_COLOR_RANGES_PUB dependencies on FND_API

Line 41: p_commit IN VARCHAR2 := FND_API.G_FALSE

37:
38: /************************************************************************************
39: ************************************************************************************/
40: PROCEDURE Create_Color_Prop_Ranges(
41: p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_objective_id IN NUMBER
43: ,p_kpi_measure_id IN NUMBER
44: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
45: ,p_threshold_color IN THRESHOLD_ARRAY

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: AND share_flag = 2 -- shared objective.
64: AND prototype_flag <> 2;
65: BEGIN
66: FND_MSG_PUB.Initialize;
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: SAVEPOINT BscColorRangePub_CrtColorRng;
70:
71: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

Line 94: RAISE FND_API.G_EXC_ERROR;

90: ,x_return_status => x_return_status
91: ,x_msg_count => x_msg_count
92: ,x_msg_data => x_msg_data);
93: IF (x_return_status <> 'S') THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: l_user_id := FND_GLOBAL.USER_ID;
98: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

Line 105: RAISE FND_API.G_EXC_ERROR;

101: ,x_return_status => x_return_status
102: ,x_msg_count => x_msg_count
103: ,x_msg_data => x_msg_data);
104: IF (x_return_status <> 'S') THEN
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: IF (p_kpi_measure_id IS NULL) THEN -- Threshold is for objective.
109: FOR c_shared IN c_shared_obj LOOP

Line 122: RAISE FND_API.G_EXC_ERROR;

118: ,x_return_status => x_return_status
119: ,x_msg_count => x_msg_count
120: ,x_msg_data => x_msg_data);
121: IF (x_return_status <> 'S') THEN
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
125: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
126: ,p_user_id => l_user_id

Line 131: RAISE FND_API.G_EXC_ERROR;

127: ,x_return_status => x_return_status
128: ,x_msg_count => x_msg_count
129: ,x_msg_data => x_msg_data);
130: IF (x_return_status <> 'S') THEN
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133: END LOOP;
134: END IF;
135:

Line 136: IF(p_commit = FND_API.G_TRUE) THEN

132: END IF;
133: END LOOP;
134: END IF;
135:
136: IF(p_commit = FND_API.G_TRUE) THEN
137: COMMIT;
138: END IF;
139:
140: EXCEPTION

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: END IF;
139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: ROLLBACK TO BscColorRangePub_CrtColorRng;
144: IF (x_msg_data IS NULL) THEN
145: FND_MSG_PUB.Count_And_Get
146: ( p_encoded => FND_API.G_FALSE

Line 146: ( p_encoded => FND_API.G_FALSE

142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: ROLLBACK TO BscColorRangePub_CrtColorRng;
144: IF (x_msg_data IS NULL) THEN
145: FND_MSG_PUB.Count_And_Get
146: ( p_encoded => FND_API.G_FALSE
147: ,p_count => x_msg_count
148: ,p_data => x_msg_data
149: );
150: END IF;

Line 155: p_commit IN VARCHAR2 := FND_API.G_FALSE

151: END Create_Color_Prop_Ranges;
152:
153:
154: PROCEDURE create_def_clr_prop_clr_mtd (
155: p_commit IN VARCHAR2 := FND_API.G_FALSE
156: , p_objective_id IN NUMBER
157: , p_kpi_measure_id IN NUMBER
158: , p_color_method IN NUMBER
159: , p_property_value IN NUMBER := NULL

Line 191: x_return_status := FND_API.G_RET_STS_SUCCESS;

187:
188: BEGIN
189:
190: FND_MSG_PUB.Initialize;
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: SAVEPOINT BscColorPub_CrtDefClrRngCM;
194:
195: IF (p_kpi_measure_id IS NULL) THEN

Line 198: RAISE FND_API.G_EXC_ERROR;

194:
195: IF (p_kpi_measure_id IS NULL) THEN
196: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
202: INTO l_range_id

Line 211: RAISE FND_API.G_EXC_ERROR;

207: IF (p_color_method IS NULL OR p_color_method > 3) THEN
208: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_METHOD_ISSUE');
209: FND_MESSAGE.SET_TOKEN('BSC_COLOR_METHOD', p_color_method);
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: l_Bsc_Kpi_Color_Range_Rec := Get_Def_Color_Range_Rec(p_color_method);
215:

Line 225: RAISE FND_API.G_EXC_ERROR;

221: ,x_return_status => x_return_status
222: ,x_msg_count => x_msg_count
223: ,x_msg_data => x_msg_data);
224: IF (x_return_status <> 'S') THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: l_user_id := FND_GLOBAL.USER_ID;
229: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

Line 237: RAISE FND_API.G_EXC_ERROR;

233: ,x_msg_count => x_msg_count
234: ,x_msg_data => x_msg_data);
235:
236: IF (x_return_status <> 'S') THEN
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: IF (p_cascade_shared) THEN
241:

Line 277: RAISE FND_API.G_EXC_ERROR;

273: ,x_return_status => x_return_status
274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data);
276: IF (x_return_status <> 'S') THEN
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280: l_user_id := FND_GLOBAL.USER_ID;
281: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

Line 288: RAISE FND_API.G_EXC_ERROR;

284: ,x_return_status => x_return_status
285: ,x_msg_count => x_msg_count
286: ,x_msg_data => x_msg_data);
287: IF (x_return_status <> 'S') THEN
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291: END IF;
292: END LOOP;

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: END IF;
294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: ROLLBACK TO BscColorPub_CrtDefClrRngCM;
299: IF (x_msg_data IS NULL) THEN
300: FND_MSG_PUB.Count_And_Get
301: ( p_encoded => FND_API.G_FALSE

Line 301: ( p_encoded => FND_API.G_FALSE

297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: ROLLBACK TO BscColorPub_CrtDefClrRngCM;
299: IF (x_msg_data IS NULL) THEN
300: FND_MSG_PUB.Count_And_Get
301: ( p_encoded => FND_API.G_FALSE
302: ,p_count => x_msg_count
303: ,p_data => x_msg_data
304: );
305: END IF;

Line 311: p_commit IN VARCHAR2 := FND_API.G_FALSE

307: END create_def_clr_prop_clr_mtd;
308:
309:
310: PROCEDURE create_pl_def_clr_prop_ranges (
311: p_commit IN VARCHAR2 := FND_API.G_FALSE
312: ,p_objective_id IN NUMBER
313: ,p_kpi_measure_id IN NUMBER
314: ,p_cascade_shared IN BOOLEAN
315: ,x_return_status OUT NOCOPY VARCHAR2

Line 332: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

328: , x_return_status => x_return_status
329: , x_msg_count => x_msg_count
330: , x_msg_data => x_msg_data
331: );
332: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335:
336: create_def_clr_prop_clr_mtd (

Line 333: RAISE FND_API.G_EXC_ERROR;

329: , x_msg_count => x_msg_count
330: , x_msg_data => x_msg_data
331: );
332: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335:
336: create_def_clr_prop_clr_mtd (
337: p_commit => p_commit

Line 347: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

343: , x_return_status => x_return_status
344: , x_msg_count => x_msg_count
345: , x_msg_data => x_msg_data
346: );
347: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351:

Line 348: RAISE FND_API.G_EXC_ERROR;

344: , x_msg_count => x_msg_count
345: , x_msg_data => x_msg_data
346: );
347: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351:
352: create_def_clr_prop_clr_mtd (

Line 363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

359: , x_return_status => x_return_status
360: , x_msg_count => x_msg_count
361: , x_msg_data => x_msg_data
362: );
363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: EXCEPTION

Line 364: RAISE FND_API.G_EXC_ERROR;

360: , x_msg_count => x_msg_count
361: , x_msg_data => x_msg_data
362: );
363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: EXCEPTION
368: WHEN OTHERS THEN

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

365: END IF;
366:
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: IF (x_msg_data IS NULL) THEN
371: FND_MSG_PUB.Count_And_Get
372: ( p_encoded => FND_API.G_FALSE
373: ,p_count => x_msg_count

Line 372: ( p_encoded => FND_API.G_FALSE

368: WHEN OTHERS THEN
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: IF (x_msg_data IS NULL) THEN
371: FND_MSG_PUB.Count_And_Get
372: ( p_encoded => FND_API.G_FALSE
373: ,p_count => x_msg_count
374: ,p_data => x_msg_data
375: );
376: END IF;

Line 383: p_commit IN VARCHAR2 := FND_API.G_FALSE

379:
380: /************************************************************************************
381: ************************************************************************************/
382: PROCEDURE Create_Def_Color_Prop_Ranges(
383: p_commit IN VARCHAR2 := FND_API.G_FALSE
384: ,p_objective_id IN NUMBER
385: ,p_kpi_measure_id IN NUMBER
386: ,p_property_value IN NUMBER := NULL
387: ,p_cascade_shared IN BOOLEAN

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: l_color_method NUMBER;
394: BEGIN
395:
396: FND_MSG_PUB.Initialize;
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: IF (p_property_value IS NOT NULL) THEN
400: l_color_method := p_property_value;
401: ELSE

Line 423: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

419: , x_msg_count => x_msg_count
420: , x_msg_data => x_msg_data
421: );
422:
423: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: EXCEPTION

Line 424: RAISE FND_API.G_EXC_ERROR;

420: , x_msg_data => x_msg_data
421: );
422:
423: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: EXCEPTION
428: WHEN OTHERS THEN

Line 429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

425: END IF;
426:
427: EXCEPTION
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: IF (x_msg_data IS NULL) THEN
431: FND_MSG_PUB.Count_And_Get
432: ( p_encoded => FND_API.G_FALSE
433: ,p_count => x_msg_count

Line 432: ( p_encoded => FND_API.G_FALSE

428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: IF (x_msg_data IS NULL) THEN
431: FND_MSG_PUB.Count_And_Get
432: ( p_encoded => FND_API.G_FALSE
433: ,p_count => x_msg_count
434: ,p_data => x_msg_data
435: );
436: END IF;

Line 446: p_commit IN VARCHAR2 := FND_API.G_FALSE

442: ************************************************************************************/
443: -- API to be called from UI and other place,
444: -- it takes care of Create/Update/Default based on the parameters
445: PROCEDURE Save_Color_Prop_Ranges(
446: p_commit IN VARCHAR2 := FND_API.G_FALSE
447: ,p_objective_id IN NUMBER
448: ,p_kpi_measure_id IN NUMBER
449: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
450: ,p_threshold_color IN VARCHAR2

Line 484: p_commit IN VARCHAR2 := FND_API.G_FALSE

480: -- defaulted for create
481: -- If already exists update it.
482: -- This API is called from UI layer.
483: PROCEDURE Save_Color_Prop_Ranges(
484: p_commit IN VARCHAR2 := FND_API.G_FALSE
485: ,p_objective_id IN NUMBER
486: ,p_kpi_measure_id IN NUMBER
487: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
488: ,p_threshold_color IN THRESHOLD_ARRAY

Line 507: x_return_status := FND_API.G_RET_STS_SUCCESS;

503: l_range_count NUMBER;
504:
505: BEGIN
506: FND_MSG_PUB.Initialize;
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: SAVEPOINT BscColorRangePub_SaveColorRng;
510: IF (p_kpi_measure_id IS NULL) THEN
511: SELECT COUNT(1)

Line 544: RAISE FND_API.G_EXC_ERROR;

540: ,x_msg_count => x_msg_count
541: ,x_msg_data => x_msg_data);
542:
543: IF (x_return_status <> 'S') THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: ELSE
547: Create_Color_Prop_Ranges(p_objective_id => p_objective_id
548: ,p_kpi_measure_id => p_kpi_measure_id

Line 557: RAISE FND_API.G_EXC_ERROR;

553: ,x_msg_count => x_msg_count
554: ,x_msg_data => x_msg_data);
555:
556: IF (x_return_status <> 'S') THEN
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559: END IF;
560: ELSE
561: IF (p_threshold_color IS NOT NULL) THEN

Line 572: RAISE FND_API.G_EXC_ERROR;

568: ,x_return_status => x_return_status
569: ,x_msg_count => x_msg_count
570: ,x_msg_data => x_msg_data);
571: IF (x_return_status <> 'S') THEN
572: RAISE FND_API.G_EXC_ERROR;
573: END IF;
574: END IF;
575: END IF;
576:

Line 577: IF(p_commit = FND_API.G_TRUE) THEN

573: END IF;
574: END IF;
575: END IF;
576:
577: IF(p_commit = FND_API.G_TRUE) THEN
578: COMMIT;
579: END IF;
580:
581: EXCEPTION

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: END IF;
580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: ROLLBACK TO BscColorRangePub_SaveColorRng;
585:
586: IF (x_msg_data IS NULL) THEN
587: FND_MSG_PUB.Count_And_Get

Line 588: ( p_encoded => FND_API.G_FALSE

584: ROLLBACK TO BscColorRangePub_SaveColorRng;
585:
586: IF (x_msg_data IS NULL) THEN
587: FND_MSG_PUB.Count_And_Get
588: ( p_encoded => FND_API.G_FALSE
589: ,p_count => x_msg_count
590: ,p_data => x_msg_data
591: );
592: END IF;

Line 818: p_commit IN VARCHAR2 := FND_API.G_FALSE

814: END;
815: /************************************************************************************
816: ************************************************************************************/
817: PROCEDURE Update_Color_Prop_Ranges(
818: p_commit IN VARCHAR2 := FND_API.G_FALSE
819: ,p_objective_id IN NUMBER
820: ,p_kpi_measure_id IN NUMBER
821: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
822: ,p_threshold_color IN THRESHOLD_ARRAY

Line 858: x_return_status := FND_API.G_RET_STS_SUCCESS;

854: AND share_flag = 2 -- shared objective.
855: AND prototype_flag <> 2;
856: BEGIN
857: FND_MSG_PUB.Initialize;
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: SAVEPOINT BscColorRangePub_CrtColorRng;
861:
862: FOR l_loop_count IN 1..p_threshold_color.COUNT LOOP

Line 878: RAISE FND_API.G_EXC_ERROR;

874: IF (p_time_stamp IS NOT NULL AND l_color_range_ids_rec.last_update_date IS NOT NULL
875: AND p_time_stamp <> l_color_range_ids_rec.last_update_date) THEN
876: FND_MESSAGE.SET_NAME('BSC','BSC_UPDATED_KPI_MEASURE');
877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880: IF (p_kpi_measure_id IS NULL) THEN
881: UPDATE bsc_color_type_props
882: SET last_update_date = sysdate

Line 900: RAISE FND_API.G_EXC_ERROR;

896: ,x_return_status => x_return_status
897: ,x_msg_count => x_msg_count
898: ,x_msg_data => x_msg_data);
899: IF (x_return_status <> 'S') THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: l_user_id := FND_GLOBAL.USER_ID;
904:

Line 912: RAISE FND_API.G_EXC_ERROR;

908: ,x_return_status => x_return_status
909: ,x_msg_count => x_msg_count
910: ,x_msg_data => x_msg_data);
911: IF (x_return_status <> 'S') THEN
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: -- ppandey- Get all the shared objectives and cascade the ranges to it.
916: -- This is existing approach also, and it allows us to provide functionality

Line 968: RAISE FND_API.G_EXC_ERROR;

964: ,x_msg_count => x_msg_count
965: ,x_msg_data => x_msg_data);
966:
967: IF (x_return_status <> 'S') THEN
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
971: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
972: ,p_user_id => l_user_id

Line 977: RAISE FND_API.G_EXC_ERROR;

973: ,x_return_status => x_return_status
974: ,x_msg_count => x_msg_count
975: ,x_msg_data => x_msg_data);
976: IF (x_return_status <> 'S') THEN
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: END LOOP;
980:
981: END LOOP;

Line 983: IF(p_commit = FND_API.G_TRUE) THEN

979: END LOOP;
980:
981: END LOOP;
982:
983: IF(p_commit = FND_API.G_TRUE) THEN
984: COMMIT;
985: END IF;
986:
987: EXCEPTION

Line 989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

985: END IF;
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NULL) THEN
991: FND_MSG_PUB.Count_And_Get
992: ( p_encoded => FND_API.G_FALSE
993: ,p_count => x_msg_count

Line 992: ( p_encoded => FND_API.G_FALSE

988: WHEN OTHERS THEN
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NULL) THEN
991: FND_MSG_PUB.Count_And_Get
992: ( p_encoded => FND_API.G_FALSE
993: ,p_count => x_msg_count
994: ,p_data => x_msg_data
995: );
996: END IF;

Line 1003: p_commit IN VARCHAR2 := FND_API.G_FALSE

999:
1000: /************************************************************************************
1001: ************************************************************************************/
1002: PROCEDURE Create_Color_Prop_Ranges(
1003: p_commit IN VARCHAR2 := FND_API.G_FALSE
1004: ,p_objective_id IN NUMBER
1005: ,p_kpi_measure_id IN NUMBER
1006: ,p_color_type IN VARCHAR2 -- PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
1007: ,p_threshold_color IN VARCHAR2

Line 1020: x_return_status := FND_API.G_RET_STS_SUCCESS;

1016: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1017: BEGIN
1018:
1019: FND_MSG_PUB.Initialize;
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021:
1022: SAVEPOINT BscColorRangePub_CrtColorRng;
1023:
1024: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: ,x_msg_count => x_msg_count
1039: ,x_msg_data => x_msg_data);
1040:
1041: IF (x_return_status <> 'S') THEN
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: Create_Color_Ranges(p_color_range_id => l_range_id
1046: ,p_threshold_color => p_threshold_color

Line 1052: RAISE FND_API.G_EXC_ERROR;

1048: ,x_msg_count => x_msg_count
1049: ,x_msg_data => x_msg_data);
1050:
1051: IF (x_return_status <> 'S') THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: IF(p_commit = FND_API.G_TRUE) THEN
1056: COMMIT;

Line 1055: IF(p_commit = FND_API.G_TRUE) THEN

1051: IF (x_return_status <> 'S') THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: IF(p_commit = FND_API.G_TRUE) THEN
1056: COMMIT;
1057: END IF;
1058:
1059: EXCEPTION

Line 1060: WHEN FND_API.G_EXC_ERROR THEN

1056: COMMIT;
1057: END IF;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF (x_msg_data IS NULL) THEN
1062: ROLLBACK TO BscColorRangePub_CrtColorRng;
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_encoded => FND_API.G_FALSE

Line 1064: ( p_encoded => FND_API.G_FALSE

1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF (x_msg_data IS NULL) THEN
1062: ROLLBACK TO BscColorRangePub_CrtColorRng;
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_encoded => FND_API.G_FALSE
1065: , p_count => x_msg_count
1066: , p_data => x_msg_data
1067: );
1068: END IF;

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: , p_count => x_msg_count
1066: , p_data => x_msg_data
1067: );
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: IF (x_msg_data IS NULL) THEN
1072: FND_MSG_PUB.Count_And_Get
1073: ( p_encoded => FND_API.G_FALSE

Line 1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1066: , p_data => x_msg_data
1067: );
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: IF (x_msg_data IS NULL) THEN
1072: FND_MSG_PUB.Count_And_Get
1073: ( p_encoded => FND_API.G_FALSE
1074: , p_count => x_msg_count

Line 1073: ( p_encoded => FND_API.G_FALSE

1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: IF (x_msg_data IS NULL) THEN
1072: FND_MSG_PUB.Count_And_Get
1073: ( p_encoded => FND_API.G_FALSE
1074: , p_count => x_msg_count
1075: , p_data => x_msg_data
1076: );
1077: END IF;

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1074: , p_count => x_msg_count
1075: , p_data => x_msg_data
1076: );
1077: END IF;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: WHEN NO_DATA_FOUND THEN
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF (x_msg_data IS NOT NULL) THEN
1082: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1076: );
1077: END IF;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: WHEN NO_DATA_FOUND THEN
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF (x_msg_data IS NOT NULL) THEN
1082: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1083: ELSE
1084: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1083: ELSE
1084: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1085: END IF;
1086: WHEN OTHERS THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088: IF (x_msg_data IS NOT NULL) THEN
1089: x_msg_data := x_msg_data||' -> BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';
1090: ELSE
1091: x_msg_data := SQLERRM||' at BSC_COLOR_RANGES_PUB.Create_Color_Prop_Ranges';

Line 1126: p_commit IN VARCHAR2 := FND_API.G_FALSE

1122:
1123: /************************************************************************************
1124: ************************************************************************************/
1125: PROCEDURE Create_Color_Ranges(
1126: p_commit IN VARCHAR2 := FND_API.G_FALSE
1127: ,p_color_range_id IN NUMBER
1128: ,p_threshold_color IN VARCHAR2
1129: ,x_return_status OUT NOCOPY VARCHAR2
1130: ,x_msg_count OUT NOCOPY NUMBER

Line 1141: x_return_status := FND_API.G_RET_STS_SUCCESS;

1137: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1138: l_format_issue BOOLEAN:= FALSE;
1139: BEGIN
1140: FND_MSG_PUB.Initialize;
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142:
1143: IF(p_color_range_id IS NULL) THEN
1144: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_RANGE_ID_NULL');
1145: FND_MSG_PUB.ADD;

Line 1146: RAISE FND_API.G_EXC_ERROR;

1142:
1143: IF(p_color_range_id IS NULL) THEN
1144: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_RANGE_ID_NULL');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:
1149: -- p_threshold_color value will be in format -> 1:20:345;2:40:345;3:80:456
1150: l_threshold_color := p_threshold_color;

Line 1178: RAISE FND_API.G_EXC_ERROR;

1174: ,x_return_status => x_return_status
1175: ,x_msg_count => x_msg_count
1176: ,x_msg_data => x_msg_data);
1177: IF (x_return_status <> 'S') THEN
1178: RAISE FND_API.G_EXC_ERROR;
1179: END IF;
1180:
1181: IF(p_commit = FND_API.G_TRUE) THEN
1182: COMMIT;

Line 1181: IF(p_commit = FND_API.G_TRUE) THEN

1177: IF (x_return_status <> 'S') THEN
1178: RAISE FND_API.G_EXC_ERROR;
1179: END IF;
1180:
1181: IF(p_commit = FND_API.G_TRUE) THEN
1182: COMMIT;
1183: END IF;
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181: IF(p_commit = FND_API.G_TRUE) THEN
1182: COMMIT;
1183: END IF;
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: IF (x_msg_data IS NULL) THEN
1187: ROLLBACK TO BscColorRangePub_CrtColorRng;
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_encoded => FND_API.G_FALSE

Line 1189: ( p_encoded => FND_API.G_FALSE

1185: WHEN FND_API.G_EXC_ERROR THEN
1186: IF (x_msg_data IS NULL) THEN
1187: ROLLBACK TO BscColorRangePub_CrtColorRng;
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_encoded => FND_API.G_FALSE
1190: , p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );
1193: END IF;

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: , p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );
1193: END IF;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: IF (x_msg_data IS NULL) THEN
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_encoded => FND_API.G_FALSE

Line 1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1191: , p_data => x_msg_data
1192: );
1193: END IF;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: IF (x_msg_data IS NULL) THEN
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_encoded => FND_API.G_FALSE
1199: , p_count => x_msg_count

Line 1198: ( p_encoded => FND_API.G_FALSE

1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: IF (x_msg_data IS NULL) THEN
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_encoded => FND_API.G_FALSE
1199: , p_count => x_msg_count
1200: , p_data => x_msg_data
1201: );
1202: END IF;

Line 1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1199: , p_count => x_msg_count
1200: , p_data => x_msg_data
1201: );
1202: END IF;
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: WHEN NO_DATA_FOUND THEN
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206: IF (x_msg_data IS NOT NULL) THEN
1207: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color';

Line 1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1201: );
1202: END IF;
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: WHEN NO_DATA_FOUND THEN
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206: IF (x_msg_data IS NOT NULL) THEN
1207: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color';
1208: ELSE
1209: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color';

Line 1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1208: ELSE
1209: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color';
1210: END IF;
1211: WHEN OTHERS THEN
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213: IF (x_msg_data IS NOT NULL) THEN
1214: x_msg_data := x_msg_data||' -> BSC_KPI_PUB.Create_Color';
1215: ELSE
1216: x_msg_data := SQLERRM||' at BSC_KPI_PUB.Create_Color';

Line 1223: p_commit IN VARCHAR2:= FND_API.G_FALSE

1219:
1220: /************************************************************************************
1221: ************************************************************************************/
1222: PROCEDURE Delete_Color_Prop_Ranges (
1223: p_commit IN VARCHAR2:= FND_API.G_FALSE
1224: ,p_objective_id IN NUMBER
1225: ,p_kpi_measure_id IN NUMBER := NULL
1226: ,p_cascade_shared IN BOOLEAN
1227: ,x_return_status OUT NOCOPY VARCHAR2

Line 1260: x_return_status := FND_API.G_RET_STS_SUCCESS;

1256: AND kpi_measure_id = l_kpi_measure_id;
1257:
1258: BEGIN
1259: FND_MSG_PUB.Initialize;
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261:
1262: SAVEPOINT BscColorRangePub_DelColorRng;
1263:
1264: IF(p_objective_id IS NULL) THEN

Line 1267: RAISE FND_API.G_EXC_ERROR;

1263:
1264: IF(p_objective_id IS NULL) THEN
1265: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
1266: FND_MSG_PUB.ADD;
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269: l_objective_id := p_objective_id;
1270: l_kpi_measure_id := p_kpi_measure_id;
1271: -- ppandey get all the shared objectives and cascade the ranges to it.

Line 1284: RAISE FND_API.G_EXC_ERROR;

1280: ,x_return_status => x_return_status
1281: ,x_msg_count => x_msg_count
1282: ,x_msg_data => x_msg_data);
1283: IF (x_return_status <> 'S') THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: END IF;
1286: END LOOP;
1287: ELSE
1288: FOR c_ranges IN c_measure_ranges LOOP

Line 1295: RAISE FND_API.G_EXC_ERROR;

1291: ,x_return_status => x_return_status
1292: ,x_msg_count => x_msg_count
1293: ,x_msg_data => x_msg_data);
1294: IF (x_return_status <> 'S') THEN
1295: RAISE FND_API.G_EXC_ERROR;
1296: END IF;
1297: END LOOP;
1298: END IF;
1299:

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: ,x_return_status => x_return_status
1318: ,x_msg_count => x_msg_count
1319: ,x_msg_data => x_msg_data);
1320: IF (x_return_status <> 'S') THEN
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: END LOOP;
1324: ELSE
1325: SELECT kpi_measure_id

Line 1341: RAISE FND_API.G_EXC_ERROR;

1337: ,x_return_status => x_return_status
1338: ,x_msg_count => x_msg_count
1339: ,x_msg_data => x_msg_data);
1340: IF (x_return_status <> 'S') THEN
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343: END LOOP;
1344: END IF;
1345: END LOOP;

Line 1348: IF(p_commit = FND_API.G_TRUE) THEN

1344: END IF;
1345: END LOOP;
1346:
1347: END IF;
1348: IF(p_commit = FND_API.G_TRUE) THEN
1349: COMMIT;
1350: END IF;
1351: EXCEPTION
1352: WHEN OTHERS THEN

Line 1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1349: COMMIT;
1350: END IF;
1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: ROLLBACK TO BscColorRangePub_DelColorRng;
1355: IF (x_msg_data IS NULL) THEN
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_encoded => FND_API.G_FALSE

Line 1357: ( p_encoded => FND_API.G_FALSE

1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: ROLLBACK TO BscColorRangePub_DelColorRng;
1355: IF (x_msg_data IS NULL) THEN
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_encoded => FND_API.G_FALSE
1358: ,p_count => x_msg_count
1359: ,p_data => x_msg_data
1360: );
1361: END IF;

Line 1369: p_commit IN VARCHAR2:= FND_API.G_FALSE

1365: ************************************************************************************/
1366: -- This functionality not used any where right now, will be used on remove of KPI or delete of Objective.
1367: -- and changing color rollup type from weighted to something else
1368: PROCEDURE Delete_Color_Prop_Ranges (
1369: p_commit IN VARCHAR2:= FND_API.G_FALSE
1370: ,p_color_range_id IN NUMBER
1371: ,x_return_status OUT NOCOPY VARCHAR2
1372: ,x_msg_count OUT NOCOPY NUMBER
1373: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1394: x_return_status := FND_API.G_RET_STS_SUCCESS;

1390: AND prototype_flag <> 2;
1391:
1392: BEGIN
1393: FND_MSG_PUB.Initialize;
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395:
1396: SAVEPOINT BscColorRangePub_DelColorRng;
1397:
1398: IF(p_color_range_id IS NULL) THEN

Line 1401: RAISE FND_API.G_EXC_ERROR;

1397:
1398: IF(p_color_range_id IS NULL) THEN
1399: FND_MESSAGE.SET_NAME('BSC','BSC_RANGE_ID_NULL');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403: -- ppandey get all the shared objectives and cascade the ranges to it.
1404: -- This is existing approach also, and it allows us to provide functionality
1405: -- to support different threashold for shared objective if needed in future.

Line 1414: RAISE FND_API.G_EXC_ERROR;

1410: ,x_return_status => x_return_status
1411: ,x_msg_count => x_msg_count
1412: ,x_msg_data => x_msg_data);
1413: IF (x_return_status <> 'S') THEN
1414: RAISE FND_API.G_EXC_ERROR;
1415: END IF;
1416:
1417: SELECT cprop.indicator, am.analysis_option0,
1418: am.analysis_option1, am.analysis_option2, am.series_id,

Line 1442: RAISE FND_API.G_EXC_ERROR;

1438: ,x_return_status => x_return_status
1439: ,x_msg_count => x_msg_count
1440: ,x_msg_data => x_msg_data);
1441: IF (x_return_status <> 'S') THEN
1442: RAISE FND_API.G_EXC_ERROR;
1443: END IF;
1444: END LOOP;
1445:
1446: IF(p_commit = FND_API.G_TRUE) THEN

Line 1446: IF(p_commit = FND_API.G_TRUE) THEN

1442: RAISE FND_API.G_EXC_ERROR;
1443: END IF;
1444: END LOOP;
1445:
1446: IF(p_commit = FND_API.G_TRUE) THEN
1447: COMMIT;
1448: END IF;
1449: EXCEPTION
1450: WHEN OTHERS THEN

Line 1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1447: COMMIT;
1448: END IF;
1449: EXCEPTION
1450: WHEN OTHERS THEN
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: ROLLBACK TO BscColorRangePub_DelColorRng;
1453: IF (x_msg_data IS NULL) THEN
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_encoded => FND_API.G_FALSE

Line 1455: ( p_encoded => FND_API.G_FALSE

1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: ROLLBACK TO BscColorRangePub_DelColorRng;
1453: IF (x_msg_data IS NULL) THEN
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_encoded => FND_API.G_FALSE
1456: ,p_count => x_msg_count
1457: ,p_data => x_msg_data
1458: );
1459: END IF;