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

Line 9: p_commit IN VARCHAR2 := FND_API.G_FALSE

5: /************************************************************************************
6: ************************************************************************************/
7:
8: PROCEDURE Update_Kpi_Color_Properties (
9: p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
11: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25:
26: BEGIN
27:
28: FND_MSG_PUB.Initialize;
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: -- Any Business Logic Validation
32:
33: BSC_KPI_MEASURE_PROPS_PUB.Retrieve_Kpi_Measure_Props

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

38: , x_msg_count => x_msg_count
39: , x_msg_data => x_msg_data
40: );
41:
42: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45:
46: l_kpi_measure_rec.disable_color := p_disable_color;

Line 43: RAISE FND_API.G_EXC_ERROR;

39: , x_msg_data => x_msg_data
40: );
41:
42: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45:
46: l_kpi_measure_rec.disable_color := p_disable_color;
47: l_kpi_measure_rec.disable_trend := p_disable_trend;

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

56: , x_msg_count => x_msg_count
57: , x_msg_data => x_msg_data
58: );
59:
60: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63:
64: IF (p_need_color_recalc = 'Y') THEN

Line 61: RAISE FND_API.G_EXC_ERROR;

57: , x_msg_data => x_msg_data
58: );
59:
60: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63:
64: IF (p_need_color_recalc = 'Y') THEN
65:

Line 81: WHEN FND_API.G_EXC_ERROR THEN

77:
78:
79:
80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82: IF (x_msg_data IS NULL) THEN
83: FND_MSG_PUB.Count_And_Get
84: ( p_encoded => FND_API.G_FALSE
85: , p_count => x_msg_count

Line 84: ( p_encoded => FND_API.G_FALSE

80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82: IF (x_msg_data IS NULL) THEN
83: FND_MSG_PUB.Count_And_Get
84: ( p_encoded => FND_API.G_FALSE
85: , p_count => x_msg_count
86: , p_data => x_msg_data
87: );
88: END IF;

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85: , p_count => x_msg_count
86: , p_data => x_msg_data
87: );
88: END IF;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: IF (x_msg_data IS NULL) THEN
92: FND_MSG_PUB.Count_And_Get
93: ( p_encoded => FND_API.G_FALSE

Line 90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

86: , p_data => x_msg_data
87: );
88: END IF;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: IF (x_msg_data IS NULL) THEN
92: FND_MSG_PUB.Count_And_Get
93: ( p_encoded => FND_API.G_FALSE
94: , p_count => x_msg_count

Line 93: ( p_encoded => FND_API.G_FALSE

89: x_return_status := FND_API.G_RET_STS_ERROR;
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: IF (x_msg_data IS NULL) THEN
92: FND_MSG_PUB.Count_And_Get
93: ( p_encoded => FND_API.G_FALSE
94: , p_count => x_msg_count
95: , p_data => x_msg_data
96: );
97: END IF;

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

94: , p_count => x_msg_count
95: , p_data => x_msg_data
96: );
97: END IF;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: WHEN NO_DATA_FOUND THEN
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: IF (x_msg_data IS NOT NULL) THEN
102: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

96: );
97: END IF;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: WHEN NO_DATA_FOUND THEN
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: IF (x_msg_data IS NOT NULL) THEN
102: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
103: ELSE
104: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line 107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

103: ELSE
104: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
105: END IF;
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: IF (x_msg_data IS NOT NULL) THEN
109: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
110: ELSE
111: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';

Line 122: p_commit IN VARCHAR2 := FND_API.G_FALSE

118: /************************************************************************************
119: ************************************************************************************/
120:
121: PROCEDURE Update_Obj_Color_Properties (
122: p_commit IN VARCHAR2 := FND_API.G_FALSE
123: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
124: , p_obj_prototype_color_id IN BSC_KPIS_B.prototype_color_id%TYPE
125: , p_obj_prototype_trend_id IN BSC_KPIS_B.prototype_trend_id%TYPE
126: , p_color_rollup_type IN BSC_KPIS_B.color_rollup_type%TYPE

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142:
143: BEGIN
144:
145: FND_MSG_PUB.Initialize;
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: -- Any Business Logic Validation
149:
150: l_objective_rec.Bsc_Kpi_Id := p_objective_id;

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

173: , x_msg_count => x_msg_count
174: , x_msg_data => x_msg_data
175: );
176:
177: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: FOR c_shared IN c_shared_obj(p_objective_id) LOOP

Line 178: RAISE FND_API.G_EXC_ERROR;

174: , x_msg_data => x_msg_data
175: );
176:
177: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: FOR c_shared IN c_shared_obj(p_objective_id) LOOP
182: l_objective_rec.Bsc_Kpi_Id := c_shared.indicator;

Line 207: WHEN FND_API.G_EXC_ERROR THEN

203:
204: END IF;
205:
206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN
208: IF (x_msg_data IS NULL) THEN
209: FND_MSG_PUB.Count_And_Get
210: ( p_encoded => FND_API.G_FALSE
211: , p_count => x_msg_count

Line 210: ( p_encoded => FND_API.G_FALSE

206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN
208: IF (x_msg_data IS NULL) THEN
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: );
214: END IF;

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214: END IF;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: IF (x_msg_data IS NULL) THEN
218: FND_MSG_PUB.Count_And_Get
219: ( p_encoded => FND_API.G_FALSE

Line 216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

212: , p_data => x_msg_data
213: );
214: END IF;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: IF (x_msg_data IS NULL) THEN
218: FND_MSG_PUB.Count_And_Get
219: ( p_encoded => FND_API.G_FALSE
220: , p_count => x_msg_count

Line 219: ( p_encoded => FND_API.G_FALSE

215: x_return_status := FND_API.G_RET_STS_ERROR;
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: IF (x_msg_data IS NULL) THEN
218: FND_MSG_PUB.Count_And_Get
219: ( p_encoded => FND_API.G_FALSE
220: , p_count => x_msg_count
221: , p_data => x_msg_data
222: );
223: END IF;

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: , p_count => x_msg_count
221: , p_data => x_msg_data
222: );
223: END IF;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: WHEN NO_DATA_FOUND THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF (x_msg_data IS NOT NULL) THEN
228: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

222: );
223: END IF;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: WHEN NO_DATA_FOUND THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF (x_msg_data IS NOT NULL) THEN
228: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
229: ELSE
230: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229: ELSE
230: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
231: END IF;
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF (x_msg_data IS NOT NULL) THEN
235: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
236: ELSE
237: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';

Line 249: p_commit IN VARCHAR2 := FND_API.G_FALSE

245: /************************************************************************************
246: ************************************************************************************/
247:
248: PROCEDURE Create_Update_Kpi_Mes_Weights (
249: p_commit IN VARCHAR2 := FND_API.G_FALSE
250: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
251: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
252: , p_kpi_weight IN BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
253: , x_return_status OUT NOCOPY VARCHAR2

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
262: BEGIN
263:
264: FND_MSG_PUB.Initialize;
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266:
267: -- Any Business Logic Validation
268:
269: l_kpi_measure_weights_rec.objective_id := p_objective_id;

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

282: , x_msg_count => x_msg_count
283: , x_msg_data => x_msg_data
284: );
285:
286: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289:
290: ELSE

Line 287: RAISE FND_API.G_EXC_ERROR;

283: , x_msg_data => x_msg_data
284: );
285:
286: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289:
290: ELSE
291:

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

297: , x_msg_count => x_msg_count
298: , x_msg_data => x_msg_data
299: );
300:
301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: END IF;

Line 302: RAISE FND_API.G_EXC_ERROR;

298: , x_msg_data => x_msg_data
299: );
300:
301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: END IF;
306:

Line 338: WHEN FND_API.G_EXC_ERROR THEN

334:
335:
336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: IF (x_msg_data IS NULL) THEN
340: FND_MSG_PUB.Count_And_Get
341: ( p_encoded => FND_API.G_FALSE
342: , p_count => x_msg_count

Line 341: ( p_encoded => FND_API.G_FALSE

337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: IF (x_msg_data IS NULL) THEN
340: FND_MSG_PUB.Count_And_Get
341: ( p_encoded => FND_API.G_FALSE
342: , p_count => x_msg_count
343: , p_data => x_msg_data
344: );
345: END IF;

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: , p_count => x_msg_count
343: , p_data => x_msg_data
344: );
345: END IF;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: IF (x_msg_data IS NULL) THEN
349: FND_MSG_PUB.Count_And_Get
350: ( p_encoded => FND_API.G_FALSE

Line 347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

343: , p_data => x_msg_data
344: );
345: END IF;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: IF (x_msg_data IS NULL) THEN
349: FND_MSG_PUB.Count_And_Get
350: ( p_encoded => FND_API.G_FALSE
351: , p_count => x_msg_count

Line 350: ( p_encoded => FND_API.G_FALSE

346: x_return_status := FND_API.G_RET_STS_ERROR;
347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: IF (x_msg_data IS NULL) THEN
349: FND_MSG_PUB.Count_And_Get
350: ( p_encoded => FND_API.G_FALSE
351: , p_count => x_msg_count
352: , p_data => x_msg_data
353: );
354: END IF;

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

351: , p_count => x_msg_count
352: , p_data => x_msg_data
353: );
354: END IF;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: WHEN NO_DATA_FOUND THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN
359: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: );
354: END IF;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: WHEN NO_DATA_FOUND THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN
359: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
360: ELSE
361: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: ELSE
361: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
362: END IF;
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF (x_msg_data IS NOT NULL) THEN
366: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
367: ELSE
368: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS;

392:
393: BEGIN
394:
395: FND_MSG_PUB.Initialize;
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397:
398: -- Any Business Logic Validation
399:
400: BSC_DESIGNER_PVT.ActionFlag_Change_Cascade

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: END LOOP;
414:
415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: IF (x_msg_data IS NULL) THEN
419: FND_MSG_PUB.Count_And_Get
420: ( p_encoded => FND_API.G_FALSE
421: , p_count => x_msg_count

Line 420: ( p_encoded => FND_API.G_FALSE

416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: IF (x_msg_data IS NULL) THEN
419: FND_MSG_PUB.Count_And_Get
420: ( p_encoded => FND_API.G_FALSE
421: , p_count => x_msg_count
422: , p_data => x_msg_data
423: );
424: END IF;

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: , p_count => x_msg_count
422: , p_data => x_msg_data
423: );
424: END IF;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: IF (x_msg_data IS NULL) THEN
428: FND_MSG_PUB.Count_And_Get
429: ( p_encoded => FND_API.G_FALSE

Line 426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

422: , p_data => x_msg_data
423: );
424: END IF;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: IF (x_msg_data IS NULL) THEN
428: FND_MSG_PUB.Count_And_Get
429: ( p_encoded => FND_API.G_FALSE
430: , p_count => x_msg_count

Line 429: ( p_encoded => FND_API.G_FALSE

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

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: , p_count => x_msg_count
431: , p_data => x_msg_data
432: );
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: WHEN NO_DATA_FOUND THEN
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF (x_msg_data IS NOT NULL) THEN
438: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

432: );
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: WHEN NO_DATA_FOUND THEN
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF (x_msg_data IS NOT NULL) THEN
438: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
439: ELSE
440: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: ELSE
440: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
441: END IF;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: IF (x_msg_data IS NOT NULL) THEN
445: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
446: ELSE
447: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

473:
474: BEGIN
475:
476: FND_MSG_PUB.Initialize;
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: -- Any Business Logic Validation
480:
481: BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag

Line 496: RAISE FND_API.G_EXC_ERROR;

492: , p_shared_objective_id => c_shared.indicator
493: );
494:
495: IF l_kpi_measure_id IS NULL THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag
500: ( p_objective_id => c_shared.indicator

Line 510: WHEN FND_API.G_EXC_ERROR THEN

506: END LOOP;
507:
508:
509: EXCEPTION
510: WHEN FND_API.G_EXC_ERROR THEN
511: IF (x_msg_data IS NULL) THEN
512: FND_MSG_PUB.Count_And_Get
513: ( p_encoded => FND_API.G_FALSE
514: , p_count => x_msg_count

Line 513: ( p_encoded => FND_API.G_FALSE

509: EXCEPTION
510: WHEN FND_API.G_EXC_ERROR THEN
511: IF (x_msg_data IS NULL) THEN
512: FND_MSG_PUB.Count_And_Get
513: ( p_encoded => FND_API.G_FALSE
514: , p_count => x_msg_count
515: , p_data => x_msg_data
516: );
517: END IF;

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: , p_count => x_msg_count
515: , p_data => x_msg_data
516: );
517: END IF;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: IF (x_msg_data IS NULL) THEN
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE

Line 519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

515: , p_data => x_msg_data
516: );
517: END IF;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: IF (x_msg_data IS NULL) THEN
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE
523: , p_count => x_msg_count

Line 522: ( p_encoded => FND_API.G_FALSE

518: x_return_status := FND_API.G_RET_STS_ERROR;
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: IF (x_msg_data IS NULL) THEN
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE
523: , p_count => x_msg_count
524: , p_data => x_msg_data
525: );
526: END IF;

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

523: , p_count => x_msg_count
524: , p_data => x_msg_data
525: );
526: END IF;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: WHEN NO_DATA_FOUND THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

525: );
526: END IF;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: WHEN NO_DATA_FOUND THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
534: END IF;
535: WHEN OTHERS THEN
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF (x_msg_data IS NOT NULL) THEN
538: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
539: ELSE
540: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
561: BEGIN
562:
563: FND_MSG_PUB.Initialize;
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: -- Any Business Logic Validation
567:
568: Kpi_Prototype_Flag_Change

Line 608: WHEN FND_API.G_EXC_ERROR THEN

604:
605: END IF;
606:
607: EXCEPTION
608: WHEN FND_API.G_EXC_ERROR THEN
609: IF (x_msg_data IS NULL) THEN
610: FND_MSG_PUB.Count_And_Get
611: ( p_encoded => FND_API.G_FALSE
612: , p_count => x_msg_count

Line 611: ( p_encoded => FND_API.G_FALSE

607: EXCEPTION
608: WHEN FND_API.G_EXC_ERROR THEN
609: IF (x_msg_data IS NULL) THEN
610: FND_MSG_PUB.Count_And_Get
611: ( p_encoded => FND_API.G_FALSE
612: , p_count => x_msg_count
613: , p_data => x_msg_data
614: );
615: END IF;

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612: , p_count => x_msg_count
613: , p_data => x_msg_data
614: );
615: END IF;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get
620: ( p_encoded => FND_API.G_FALSE

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: , p_data => x_msg_data
614: );
615: END IF;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get
620: ( p_encoded => FND_API.G_FALSE
621: , p_count => x_msg_count

Line 620: ( p_encoded => FND_API.G_FALSE

616: x_return_status := FND_API.G_RET_STS_ERROR;
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get
620: ( p_encoded => FND_API.G_FALSE
621: , p_count => x_msg_count
622: , p_data => x_msg_data
623: );
624: END IF;

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: , p_count => x_msg_count
622: , p_data => x_msg_data
623: );
624: END IF;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: WHEN NO_DATA_FOUND THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF (x_msg_data IS NOT NULL) THEN
629: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

623: );
624: END IF;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: WHEN NO_DATA_FOUND THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF (x_msg_data IS NOT NULL) THEN
629: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
630: ELSE
631: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';

Line 634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

630: ELSE
631: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
632: END IF;
633: WHEN OTHERS THEN
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
637: ELSE
638: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';

Line 648: p_commit IN VARCHAR2 := FND_API.G_FALSE

644: /************************************************************************************
645: ************************************************************************************/
646:
647: PROCEDURE Save_Disable_Color_Of_Kpi (
648: p_commit IN VARCHAR2 := FND_API.G_FALSE
649: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
650: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
651: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
652: , p_need_color_recalc IN VARCHAR2 := 'N'

Line 664: x_return_status := FND_API.G_RET_STS_SUCCESS;

660:
661: BEGIN
662:
663: FND_MSG_PUB.Initialize;
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: -- Any Business Logic Validation
667:
668: BSC_KPI_MEASURE_PROPS_PUB.Retrieve_Kpi_Measure_Props

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

673: , x_msg_count => x_msg_count
674: , x_msg_data => x_msg_data
675: );
676:
677: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: l_kpi_measure_rec.disable_color := p_disable_color;

Line 678: RAISE FND_API.G_EXC_ERROR;

674: , x_msg_data => x_msg_data
675: );
676:
677: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: l_kpi_measure_rec.disable_color := p_disable_color;
682:

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

687: , x_msg_count => x_msg_count
688: , x_msg_data => x_msg_data
689: );
690:
691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694:
695: IF (p_need_color_recalc = 'Y') THEN

Line 692: RAISE FND_API.G_EXC_ERROR;

688: , x_msg_data => x_msg_data
689: );
690:
691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694:
695: IF (p_need_color_recalc = 'Y') THEN
696:

Line 712: WHEN FND_API.G_EXC_ERROR THEN

708:
709:
710:
711: EXCEPTION
712: WHEN FND_API.G_EXC_ERROR THEN
713: IF (x_msg_data IS NULL) THEN
714: FND_MSG_PUB.Count_And_Get
715: ( p_encoded => FND_API.G_FALSE
716: , p_count => x_msg_count

Line 715: ( p_encoded => FND_API.G_FALSE

711: EXCEPTION
712: WHEN FND_API.G_EXC_ERROR THEN
713: IF (x_msg_data IS NULL) THEN
714: FND_MSG_PUB.Count_And_Get
715: ( p_encoded => FND_API.G_FALSE
716: , p_count => x_msg_count
717: , p_data => x_msg_data
718: );
719: END IF;

Line 720: x_return_status := FND_API.G_RET_STS_ERROR;

716: , p_count => x_msg_count
717: , p_data => x_msg_data
718: );
719: END IF;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
722: IF (x_msg_data IS NULL) THEN
723: FND_MSG_PUB.Count_And_Get
724: ( p_encoded => FND_API.G_FALSE

Line 721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

717: , p_data => x_msg_data
718: );
719: END IF;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
722: IF (x_msg_data IS NULL) THEN
723: FND_MSG_PUB.Count_And_Get
724: ( p_encoded => FND_API.G_FALSE
725: , p_count => x_msg_count

Line 724: ( p_encoded => FND_API.G_FALSE

720: x_return_status := FND_API.G_RET_STS_ERROR;
721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
722: IF (x_msg_data IS NULL) THEN
723: FND_MSG_PUB.Count_And_Get
724: ( p_encoded => FND_API.G_FALSE
725: , p_count => x_msg_count
726: , p_data => x_msg_data
727: );
728: END IF;

Line 729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

725: , p_count => x_msg_count
726: , p_data => x_msg_data
727: );
728: END IF;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: WHEN NO_DATA_FOUND THEN
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: IF (x_msg_data IS NOT NULL) THEN
733: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';

Line 731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

727: );
728: END IF;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: WHEN NO_DATA_FOUND THEN
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: IF (x_msg_data IS NOT NULL) THEN
733: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
734: ELSE
735: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';

Line 738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

734: ELSE
735: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
736: END IF;
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF (x_msg_data IS NOT NULL) THEN
740: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
741: ELSE
742: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';