24: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
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:
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
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
95: , p_data => x_msg_data
96: );
141: AND prototype_flag <> 2;
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:
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
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
221: , p_data => x_msg_data
222: );
260: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
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:
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
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
352: , p_data => x_msg_data
353: );
391: AND prototype_flag <> 2;
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:
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
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
431: , p_data => x_msg_data
432: );
472: AND prototype_flag <> 2;
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:
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
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
524: , p_data => x_msg_data
525: );
559: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
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:
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
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
622: , p_data => x_msg_data
623: );
659: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
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:
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
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
726: , p_data => x_msg_data
727: );