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_ANALYSIS_OPTION_PUB dependencies on BSC_ANALYSIS_OPTION_PUB

Line 1: PACKAGE BODY BSC_ANALYSIS_OPTION_PUB as

1: PACKAGE BODY BSC_ANALYSIS_OPTION_PUB as
2: /* $Header: BSCPANOB.pls 120.12 2007/02/08 14:00:00 akoduri ship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 57: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

53: --: This procedure is part of the Analysis Option API.
54:
55: PROCEDURE Create_Analysis_Options
56: ( p_commit IN varchar2 -- := FND_API.G_FALSE
57: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
58: , x_return_status OUT NOCOPY VARCHAR2
59: , x_msg_count OUT NOCOPY NUMBER
60: , x_msg_data OUT NOCOPY VARCHAR2
61: ) IS

Line 62: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

58: , x_return_status OUT NOCOPY VARCHAR2
59: , x_msg_count OUT NOCOPY NUMBER
60: , x_msg_data OUT NOCOPY VARCHAR2
61: ) IS
62: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
63: l_share_flag NUMBER;
64: l_count NUMBER;
65:
66: --get shared indicators

Line 239: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';

235: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
236: WHEN NO_DATA_FOUND THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: IF (x_msg_data IS NOT NULL) THEN
239: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
240: ELSE
241: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
242: END IF;
243: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 241: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';

237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: IF (x_msg_data IS NOT NULL) THEN
239: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
240: ELSE
241: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
242: END IF;
243: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 247: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';

243: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF (x_msg_data IS NOT NULL) THEN
247: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
248: ELSE
249: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
250: END IF;
251: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 249: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';

245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: IF (x_msg_data IS NOT NULL) THEN
247: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
248: ELSE
249: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options ';
250: END IF;
251: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
252: end Create_Analysis_Options;
253:

Line 259: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

255: /************************************************************************************
256: ************************************************************************************/
257: procedure Retrieve_Analysis_Options(
258: p_commit IN varchar2 -- := FND_API.G_FALSE
259: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
260: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
261: ,x_return_status OUT NOCOPY varchar2
262: ,x_msg_count OUT NOCOPY number
263: ,x_msg_data OUT NOCOPY varchar2

Line 260: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

256: ************************************************************************************/
257: procedure Retrieve_Analysis_Options(
258: p_commit IN varchar2 -- := FND_API.G_FALSE
259: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
260: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
261: ,x_return_status OUT NOCOPY varchar2
262: ,x_msg_count OUT NOCOPY number
263: ,x_msg_data OUT NOCOPY varchar2
264: ) is

Line 305: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

301: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
302: WHEN NO_DATA_FOUND THEN
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: IF (x_msg_data IS NOT NULL) THEN
305: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
306: ELSE
307: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
308: END IF;
309: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 307: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: IF (x_msg_data IS NOT NULL) THEN
305: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
306: ELSE
307: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
308: END IF;
309: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
310: WHEN OTHERS THEN
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 313: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

309: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
310: WHEN OTHERS THEN
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: IF (x_msg_data IS NOT NULL) THEN
313: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
314: ELSE
315: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
316: END IF;
317: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 315: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: IF (x_msg_data IS NOT NULL) THEN
313: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
314: ELSE
315: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
316: END IF;
317: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
318:
319: end Retrieve_Analysis_Options;

Line 326: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

322: ************************************************************************************/
323:
324: procedure Retrieve_Analysis_Options(
325: p_commit IN varchar2 -- := FND_API.G_FALSE
326: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
327: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
328: ,p_data_source IN VARCHAR2
329: ,x_return_status OUT NOCOPY varchar2
330: ,x_msg_count OUT NOCOPY number

Line 327: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

323:
324: procedure Retrieve_Analysis_Options(
325: p_commit IN varchar2 -- := FND_API.G_FALSE
326: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
327: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
328: ,p_data_source IN VARCHAR2
329: ,x_return_status OUT NOCOPY varchar2
330: ,x_msg_count OUT NOCOPY number
331: ,x_msg_data OUT NOCOPY varchar2

Line 375: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

371: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
372: WHEN NO_DATA_FOUND THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: IF (x_msg_data IS NOT NULL) THEN
375: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
376: ELSE
377: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
378: END IF;
379: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 377: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: IF (x_msg_data IS NOT NULL) THEN
375: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
376: ELSE
377: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
378: END IF;
379: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
380: WHEN OTHERS THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 383: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

379: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
380: WHEN OTHERS THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF (x_msg_data IS NOT NULL) THEN
383: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
384: ELSE
385: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
386: END IF;
387: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 385: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';

381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF (x_msg_data IS NOT NULL) THEN
383: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
384: ELSE
385: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Options ';
386: END IF;
387: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
388: end Retrieve_Analysis_Options;
389: /************************************************************************************

Line 394: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

390: ************************************************************************************/
391:
392: procedure Update_Analysis_Options
393: ( p_commit IN varchar2 -- := FND_API.G_FALSE
394: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
395: , p_data_Source IN VARCHAR2
396: , x_return_status OUT NOCOPY VARCHAR2
397: , x_msg_count OUT NOCOPY NUMBER
398: , x_msg_data OUT NOCOPY VARCHAR2

Line 400: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

396: , x_return_status OUT NOCOPY VARCHAR2
397: , x_msg_count OUT NOCOPY NUMBER
398: , x_msg_data OUT NOCOPY VARCHAR2
399: ) IS
400: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
401: l_count NUMBER;
402:
403: --get shared indicators
404: CURSOR c_kpi_ids IS

Line 472: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

468: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
469: WHEN NO_DATA_FOUND THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: IF (x_msg_data IS NOT NULL) THEN
472: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
473: ELSE
474: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
475: END IF;
476: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 474: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: IF (x_msg_data IS NOT NULL) THEN
472: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
473: ELSE
474: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
475: END IF;
476: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
477: WHEN OTHERS THEN
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 480: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

476: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
477: WHEN OTHERS THEN
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF (x_msg_data IS NOT NULL) THEN
480: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
481: ELSE
482: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
483: END IF;
484: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 482: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF (x_msg_data IS NOT NULL) THEN
480: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
481: ELSE
482: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
483: END IF;
484: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
485: end Update_Analysis_Options;
486:

Line 492: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

488: ************************************************************************************/
489:
490: procedure Update_Analysis_Options(
491: p_commit IN varchar2 -- := FND_API.G_FALSE
492: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
493: ,x_return_status OUT NOCOPY varchar2
494: ,x_msg_count OUT NOCOPY number
495: ,x_msg_data OUT NOCOPY varchar2
496: ) is

Line 537: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

533: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
534: WHEN NO_DATA_FOUND THEN
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: IF (x_msg_data IS NOT NULL) THEN
537: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
538: ELSE
539: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
540: END IF;
541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 539: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: IF (x_msg_data IS NOT NULL) THEN
537: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
538: ELSE
539: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
540: END IF;
541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
542: WHEN OTHERS THEN
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 545: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
542: WHEN OTHERS THEN
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: IF (x_msg_data IS NOT NULL) THEN
545: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
546: ELSE
547: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
548: END IF;
549: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 547: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';

543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: IF (x_msg_data IS NOT NULL) THEN
545: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
546: ELSE
547: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options ';
548: END IF;
549: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
550: end Update_Analysis_Options;
551:

Line 558: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

554:
555:
556: procedure Delete_Analysis_Options(
557: p_commit IN varchar2 -- := FND_API.G_FALSE
558: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
559: ,x_return_status OUT NOCOPY varchar2
560: ,x_msg_count OUT NOCOPY number
561: ,x_msg_data OUT NOCOPY varchar2
562: ) is

Line 596: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';

592: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
593: WHEN NO_DATA_FOUND THEN
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: IF (x_msg_data IS NOT NULL) THEN
596: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
597: ELSE
598: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
599: END IF;
600: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 598: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';

594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: IF (x_msg_data IS NOT NULL) THEN
596: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
597: ELSE
598: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
599: END IF;
600: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
601: WHEN OTHERS THEN
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 604: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';

600: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
601: WHEN OTHERS THEN
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF (x_msg_data IS NOT NULL) THEN
604: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
605: ELSE
606: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
607: END IF;
608: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 606: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';

602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF (x_msg_data IS NOT NULL) THEN
604: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
605: ELSE
606: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options ';
607: END IF;
608: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
609: end Delete_Analysis_Options;
610:

Line 619: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

615: --: This procedure is part of the Analysis Option API.
616:
617: procedure Create_Analysis_Measures(
618: p_commit IN VARCHAR2 -- := FND_API.G_FALSE
619: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
620: ,x_return_status OUT NOCOPY varchar2
621: ,x_msg_count OUT NOCOPY number
622: ,x_msg_data OUT NOCOPY varchar2
623: ) is

Line 625: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

621: ,x_msg_count OUT NOCOPY number
622: ,x_msg_data OUT NOCOPY varchar2
623: ) is
624:
625: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
626: l_Kpi_Measure_Id bsc_kpi_analysis_measures_b.Kpi_Measure_Id%TYPE;
627: l_Default_Value NUMBER;
628: l_commit VARCHAR2(2) := FND_API.G_FALSE;
629: begin

Line 733: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';

729: WHEN NO_DATA_FOUND THEN
730: ROLLBACK TO Create_Analysis_Measures_PUB;
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_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
734: ELSE
735: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
736: END IF;
737: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 735: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';

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_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
734: ELSE
735: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
736: END IF;
737: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
738: WHEN OTHERS THEN
739: ROLLBACK TO Create_Analysis_Measures_PUB;

Line 742: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';

738: WHEN OTHERS THEN
739: ROLLBACK TO Create_Analysis_Measures_PUB;
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: IF (x_msg_data IS NOT NULL) THEN
742: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
743: ELSE
744: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
745: END IF;
746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 744: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';

740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: IF (x_msg_data IS NOT NULL) THEN
742: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
743: ELSE
744: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Measures ';
745: END IF;
746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
747: end Create_Analysis_Measures;
748:

Line 754: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

750: ************************************************************************************/
751:
752: procedure Retrieve_Analysis_Measures(
753: p_commit IN varchar2 -- := FND_API.G_FALSE
754: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
755: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
756: ,x_return_status OUT NOCOPY varchar2
757: ,x_msg_count OUT NOCOPY number
758: ,x_msg_data OUT NOCOPY varchar2

Line 755: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

751:
752: procedure Retrieve_Analysis_Measures(
753: p_commit IN varchar2 -- := FND_API.G_FALSE
754: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
755: ,x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
756: ,x_return_status OUT NOCOPY varchar2
757: ,x_msg_count OUT NOCOPY number
758: ,x_msg_data OUT NOCOPY varchar2
759: ) is

Line 794: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';

790: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
791: WHEN NO_DATA_FOUND THEN
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: IF (x_msg_data IS NOT NULL) THEN
794: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
795: ELSE
796: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
797: END IF;
798: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 796: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';

792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: IF (x_msg_data IS NOT NULL) THEN
794: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
795: ELSE
796: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
797: END IF;
798: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
799: WHEN OTHERS THEN
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 802: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';

798: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
799: WHEN OTHERS THEN
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: IF (x_msg_data IS NOT NULL) THEN
802: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
803: ELSE
804: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
805: END IF;
806: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 804: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';

800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: IF (x_msg_data IS NOT NULL) THEN
802: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
803: ELSE
804: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Retrieve_Analysis_Measures ';
805: END IF;
806: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
807: end Retrieve_Analysis_Measures;
808:

Line 814: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

810: ************************************************************************************/
811:
812: procedure Update_Analysis_Measures(
813: p_commit IN varchar2 -- := FND_API.G_FALSE
814: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
815: ,x_return_status OUT NOCOPY varchar2
816: ,x_msg_count OUT NOCOPY number
817: ,x_msg_data OUT NOCOPY varchar2
818: ) is

Line 820: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

816: ,x_msg_count OUT NOCOPY number
817: ,x_msg_data OUT NOCOPY varchar2
818: ) is
819:
820: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
821: l_Default_Value NUMBER;
822:
823: begin
824: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 875: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';

871: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
872: WHEN NO_DATA_FOUND THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF (x_msg_data IS NOT NULL) THEN
875: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
876: ELSE
877: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
878: END IF;
879: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 877: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';

873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF (x_msg_data IS NOT NULL) THEN
875: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
876: ELSE
877: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
878: END IF;
879: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
880: WHEN OTHERS THEN
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 883: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';

879: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
880: WHEN OTHERS THEN
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: IF (x_msg_data IS NOT NULL) THEN
883: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
884: ELSE
885: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
886: END IF;
887: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 885: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';

881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: IF (x_msg_data IS NOT NULL) THEN
883: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
884: ELSE
885: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures ';
886: END IF;
887: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
888: end Update_Analysis_Measures;
889:

Line 898: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

894: ************************************************************************************/
895:
896: PROCEDURE Cascade_Deletion_Color_Props (
897: p_commit IN VARCHAR2 := FND_API.G_FALSE
898: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
899: ,x_return_status OUT NOCOPY varchar2
900: ,x_msg_count OUT NOCOPY number
901: ,x_msg_data OUT NOCOPY varchar2
902: ) IS

Line 986: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

982: ************************************************************************************/
983:
984: procedure Delete_Analysis_Measures(
985: p_commit IN varchar2 -- := FND_API.G_FALSE
986: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
987: ,x_return_status OUT NOCOPY varchar2
988: ,x_msg_count OUT NOCOPY number
989: ,x_msg_data OUT NOCOPY varchar2
990: ) is

Line 1042: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';

1038: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1039: WHEN NO_DATA_FOUND THEN
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: IF (x_msg_data IS NOT NULL) THEN
1042: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1043: ELSE
1044: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1045: END IF;
1046: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1044: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';

1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: IF (x_msg_data IS NOT NULL) THEN
1042: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1043: ELSE
1044: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1045: END IF;
1046: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1047: WHEN OTHERS THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1050: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';

1046: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1047: WHEN OTHERS THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: IF (x_msg_data IS NOT NULL) THEN
1050: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1051: ELSE
1052: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1053: END IF;
1054: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1052: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';

1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: IF (x_msg_data IS NOT NULL) THEN
1050: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1051: ELSE
1052: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures ';
1053: END IF;
1054: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1055: end Delete_Analysis_Measures;
1056:

Line 1062: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

1058: ************************************************************************************/
1059: PROCEDURE Delete_Ana_Opt_Mult_Groups
1060: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
1061: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
1062: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1063: , p_max_group_count IN NUMBER
1064: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
1065: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1066: , x_return_status OUT NOCOPY VARCHAR2

Line 1064: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

1060: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
1061: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
1062: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1063: , p_max_group_count IN NUMBER
1064: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
1065: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1066: , x_return_status OUT NOCOPY VARCHAR2
1067: , x_msg_count OUT NOCOPY NUMBER
1068: , x_msg_data OUT NOCOPY VARCHAR2

Line 1065: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1061: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
1062: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1063: , p_max_group_count IN NUMBER
1064: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
1065: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1066: , x_return_status OUT NOCOPY VARCHAR2
1067: , x_msg_count OUT NOCOPY NUMBER
1068: , x_msg_data OUT NOCOPY VARCHAR2
1069: )IS

Line 1107: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1103: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1104: WHEN NO_DATA_FOUND THEN
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF (x_msg_data IS NOT NULL) THEN
1107: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1108: ELSE
1109: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1110: END IF;
1111: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1109: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF (x_msg_data IS NOT NULL) THEN
1107: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1108: ELSE
1109: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1110: END IF;
1111: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1112: WHEN OTHERS THEN
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1115: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1111: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1112: WHEN OTHERS THEN
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114: IF (x_msg_data IS NOT NULL) THEN
1115: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1116: ELSE
1117: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1118: END IF;
1119: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1117: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114: IF (x_msg_data IS NOT NULL) THEN
1115: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1116: ELSE
1117: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1118: END IF;
1119: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1120: END Delete_Ana_Opt_Mult_Groups;
1121: /************************************************************************************

Line 1128: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

1124: PROCEDURE Synch_Kpi_Anal_Group
1125: (
1126: p_commit IN VARCHAR2:=FND_API.G_FALSE
1127: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
1128: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1129: , x_return_status OUT NOCOPY VARCHAR2
1130: , x_msg_count OUT NOCOPY NUMBER
1131: , x_msg_data OUT NOCOPY VARCHAR2
1132: )IS

Line 1169: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';

1165: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1166: WHEN NO_DATA_FOUND THEN
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1168: IF (x_msg_data IS NOT NULL) THEN
1169: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1170: ELSE
1171: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1172: END IF;
1173: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1171: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';

1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1168: IF (x_msg_data IS NOT NULL) THEN
1169: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1170: ELSE
1171: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1172: END IF;
1173: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1174: WHEN OTHERS THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1177: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';

1173: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1174: WHEN OTHERS THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: IF (x_msg_data IS NOT NULL) THEN
1177: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1178: ELSE
1179: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1180: END IF;
1181: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1179: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';

1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: IF (x_msg_data IS NOT NULL) THEN
1177: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1178: ELSE
1179: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group ';
1180: END IF;
1181: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1182: END Synch_Kpi_Anal_Group;
1183:

Line 1189: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

1185:
1186:
1187: PROCEDURE store_anal_opt_grp_count
1188: ( p_kpi_id IN NUMBER
1189: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1190: ) IS
1191: BEGIN
1192:
1193: BSC_ANALYSIS_OPTION_PVT.store_anal_opt_grp_count

Line 1286: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1283: WHEN NO_DATA_FOUND THEN
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1285: IF (x_msg_data IS NOT NULL) THEN
1286: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1287: ELSE
1288: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1289: END IF;
1290: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1288: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1285: IF (x_msg_data IS NOT NULL) THEN
1286: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1287: ELSE
1288: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1289: END IF;
1290: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1291: WHEN OTHERS THEN
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1294: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1290: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1291: WHEN OTHERS THEN
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: IF (x_msg_data IS NOT NULL) THEN
1294: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1295: ELSE
1296: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1297: END IF;
1298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1296: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: IF (x_msg_data IS NOT NULL) THEN
1294: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1295: ELSE
1296: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1297: END IF;
1298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1299: END Validate_Custom_Measure;
1300: /************************************************************************************

Line 1304: p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1300: /************************************************************************************
1301: ************************************************************************************/
1302:
1303: PROCEDURE delete_extra_series(
1304: p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1305: , x_return_status OUT NOCOPY VARCHAR2
1306: , x_msg_count OUT NOCOPY NUMBER
1307: , x_msg_data OUT NOCOPY VARCHAR2
1308: ) IS

Line 1348: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1344: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1345: WHEN NO_DATA_FOUND THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: IF (x_msg_data IS NOT NULL) THEN
1348: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1349: ELSE
1350: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1351: END IF;
1352: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1350: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: IF (x_msg_data IS NOT NULL) THEN
1348: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1349: ELSE
1350: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1351: END IF;
1352: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1353: WHEN OTHERS THEN
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1356: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1352: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1353: WHEN OTHERS THEN
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF (x_msg_data IS NOT NULL) THEN
1356: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1357: ELSE
1358: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1359: END IF;
1360: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1358: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF (x_msg_data IS NOT NULL) THEN
1356: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1357: ELSE
1358: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
1359: END IF;
1360: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1361: END delete_extra_series;
1362:

Line 1367: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1363: --------------------------------------------------------------------------------
1364:
1365: PROCEDURE Create_Data_Series
1366: ( p_commit IN VARCHAR2 -- FND_API.G_FALSE
1367: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1368: , x_Anal_Opt_Rec OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1369: , x_return_status OUT NOCOPY VARCHAR2
1370: , x_msg_count OUT NOCOPY NUMBER
1371: , x_msg_data OUT NOCOPY VARCHAR2

Line 1368: , x_Anal_Opt_Rec OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1364:
1365: PROCEDURE Create_Data_Series
1366: ( p_commit IN VARCHAR2 -- FND_API.G_FALSE
1367: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1368: , x_Anal_Opt_Rec OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1369: , x_return_status OUT NOCOPY VARCHAR2
1370: , x_msg_count OUT NOCOPY NUMBER
1371: , x_msg_data OUT NOCOPY VARCHAR2
1372: ) IS

Line 1373: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1369: , x_return_status OUT NOCOPY VARCHAR2
1370: , x_msg_count OUT NOCOPY NUMBER
1371: , x_msg_data OUT NOCOPY VARCHAR2
1372: ) IS
1373: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1374: l_share_flag NUMBER;
1375: l_count NUMBER;
1376: l_series_color NUMBER;
1377: l_BM_color NUMBER;

Line 1633: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';

1629: CLOSE c_Series_color;
1630: END IF;
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632: IF (x_msg_data IS NOT NULL) THEN
1633: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1634: ELSE
1635: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1636: END IF;
1637: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1635: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';

1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632: IF (x_msg_data IS NOT NULL) THEN
1633: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1634: ELSE
1635: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1636: END IF;
1637: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1638: WHEN OTHERS THEN
1639: IF (c_Series_color%ISOPEN) THEN

Line 1644: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';

1640: CLOSE c_Series_color;
1641: END IF;
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: IF (x_msg_data IS NOT NULL) THEN
1644: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1645: ELSE
1646: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1647: END IF;
1648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1646: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';

1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: IF (x_msg_data IS NOT NULL) THEN
1644: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1645: ELSE
1646: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Create_Data_Series ';
1647: END IF;
1648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1649: end Create_Data_Series;
1650:

Line 1654: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1650:
1651:
1652: procedure Update_Data_Series
1653: ( p_commit IN VARCHAR2 -- FND_API.G_FALSE
1654: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1655: , x_return_status OUT NOCOPY VARCHAR2
1656: , x_msg_count OUT NOCOPY NUMBER
1657: , x_msg_data OUT NOCOPY VARCHAR2
1658: ) IS

Line 1659: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1655: , x_return_status OUT NOCOPY VARCHAR2
1656: , x_msg_count OUT NOCOPY NUMBER
1657: , x_msg_data OUT NOCOPY VARCHAR2
1658: ) IS
1659: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1660: l_count NUMBER;
1661: l_share_flag number;
1662:
1663: --get shared indicators

Line 1720: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE

1716: l_Anal_Opt_Rec.Bsc_Dataset_Series_Id := 0;
1717: -- THROUGH ERROR
1718: end if;
1719:
1720: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE
1721: ,l_Anal_Opt_Rec
1722: ,x_return_status
1723: ,x_msg_count
1724: ,x_msg_data);

Line 1732: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE

1728:
1729: -- if there are any shared KPIs update those also.
1730: FOR cd IN c_kpi_ids LOOP
1731: l_Anal_Opt_Rec.Bsc_Kpi_Id := cd.Indicator;
1732: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Measures( FND_API.G_FALSE
1733: ,l_Anal_Opt_Rec
1734: ,x_return_status
1735: ,x_msg_count
1736: ,x_msg_data);

Line 1770: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';

1766: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1767: WHEN NO_DATA_FOUND THEN
1768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1769: IF (x_msg_data IS NOT NULL) THEN
1770: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1771: ELSE
1772: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1773: END IF;
1774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1772: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';

1768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1769: IF (x_msg_data IS NOT NULL) THEN
1770: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1771: ELSE
1772: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1773: END IF;
1774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1775: WHEN OTHERS THEN
1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1778: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';

1774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1775: WHEN OTHERS THEN
1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1777: IF (x_msg_data IS NOT NULL) THEN
1778: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1779: ELSE
1780: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1781: END IF;
1782: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1780: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';

1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1777: IF (x_msg_data IS NOT NULL) THEN
1778: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1779: ELSE
1780: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Update_Data_Series ';
1781: END IF;
1782: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1783: end Update_Data_Series;
1784:

Line 1787: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1783: end Update_Data_Series;
1784:
1785: procedure Delete_Data_Series(
1786: p_commit IN varchar2 -- := FND_API.G_FALSE
1787: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1788: ,x_return_status OUT NOCOPY varchar2
1789: ,x_msg_count OUT NOCOPY number
1790: ,x_msg_data OUT NOCOPY varchar2
1791: ) is

Line 1795: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1791: ) is
1792:
1793: l_Num_Series NUMBER;
1794: l_count NUMBER;
1795: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1796: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1797: l_share_flag number;
1798:
1799: --get shared indicators

Line 1796: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1792:
1793: l_Num_Series NUMBER;
1794: l_count NUMBER;
1795: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1796: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1797: l_share_flag number;
1798:
1799: --get shared indicators
1800: CURSOR c_kpi_ids IS

Line 1980: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';

1976: WHEN OTHERS THEN
1977: ROLLBACK TO DeleteBSCDataSeriesPUB;
1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1979: IF (x_msg_data IS NOT NULL) THEN
1980: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
1981: ELSE
1982: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
1983: END IF;
1984: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1982: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';

1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1979: IF (x_msg_data IS NOT NULL) THEN
1980: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
1981: ELSE
1982: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Data_Series ';
1983: END IF;
1984: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1985: RAISE;
1986:

Line 2027: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

2023: p_Anal_Opt_Rec.Bsc_Dataset_New_Series_Id;
2024: ----------------------------------------------------------------------------*/
2025: procedure Swap_Data_Series_Id(
2026: p_commit IN varchar2 -- := FND_API.G_FALSE
2027: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
2028: ,x_return_status OUT NOCOPY varchar2
2029: ,x_msg_count OUT NOCOPY number
2030: ,x_msg_data OUT NOCOPY varchar2
2031: ) is

Line 2033: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

2029: ,x_msg_count OUT NOCOPY number
2030: ,x_msg_data OUT NOCOPY varchar2
2031: ) is
2032:
2033: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2034: --get shared indicators
2035: CURSOR c_kpi_ids IS
2036: SELECT indicator
2037: FROM BSC_KPIS_B

Line 2098: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';

2094: , p_data => x_msg_data
2095: );
2096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2097: IF (x_msg_data IS NOT NULL) THEN
2098: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2099: ELSE
2100: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2101: END IF;
2102: RAISE;

Line 2100: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';

2096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2097: IF (x_msg_data IS NOT NULL) THEN
2098: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2099: ELSE
2100: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2101: END IF;
2102: RAISE;
2103: WHEN OTHERS THEN
2104: IF (c_kpi_ids%ISOPEN) THEN

Line 2110: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';

2106: END IF;
2107: ROLLBACK TO SwapDataSeriesPUB;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: IF (x_msg_data IS NOT NULL) THEN
2110: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2111: ELSE
2112: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2113: END IF;
2114: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2112: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';

2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: IF (x_msg_data IS NOT NULL) THEN
2110: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2111: ELSE
2112: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Swap_Data_Series_Id ';
2113: END IF;
2114: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2115: RAISE;
2116:

Line 2142: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

2138: ) is
2139:
2140: l_short_name VARCHAR2(100);
2141: l_short_names VARCHAR2(3000);
2142: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2143: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2144: l_attribute_code VARCHAR2(100);
2145: l_count NUMBER;
2146:

Line 2143: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

2139:
2140: l_short_name VARCHAR2(100);
2141: l_short_names VARCHAR2(3000);
2142: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2143: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2144: l_attribute_code VARCHAR2(100);
2145: l_count NUMBER;
2146:
2147: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

Line 2305: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series ';

2301: END IF;
2302: ROLLBACK TO RearrangeDataSeriesPVT;
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: IF (x_msg_data IS NOT NULL) THEN
2305: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series ';
2306: ELSE
2307: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series ';
2308: END IF;
2309: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2307: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series ';

2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: IF (x_msg_data IS NOT NULL) THEN
2305: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series ';
2306: ELSE
2307: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Rearrange_Data_Series ';
2308: END IF;
2309: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2310: RAISE;
2311:

Line 2353: p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

2349: /**********************************************************/
2350:
2351: FUNCTION Get_Analysis_Group_Id
2352: (
2353: p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2354: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
2355: ) RETURN NUMBER IS
2356:
2357: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

Line 2357: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

2353: p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2354: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
2355: ) RETURN NUMBER IS
2356:
2357: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
2358: l_Anal_Grp_Id NUMBER;
2359: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;
2360: l_count NUMBER;
2361: l_option_count NUMBER;

Line 2359: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;

2355: ) RETURN NUMBER IS
2356:
2357: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
2358: l_Anal_Grp_Id NUMBER;
2359: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;
2360: l_count NUMBER;
2361: l_option_count NUMBER;
2362: l_max_group_count NUMBER;
2363:

Line 2374: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2370: IF(l_max_group_count>1) THEN
2371: BSC_BIS_KPI_MEAS_PUB.store_kpi_anal_group(p_obj_id, l_Anal_Opt_Tbl);
2372:
2373: IF(BSC_ANALYSIS_OPTION_PVT.Validate_If_single_Anal_Opt(l_Anal_Opt_Tbl)) THEN
2374: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2375: RETURN l_Anal_Grp_Id;
2376: END IF;
2377:
2378: BSC_ANALYSIS_OPTION_PVT.Initialize_Anal_Opt_Tbl

Line 2391: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2387: l_count := l_Anal_Det_Opt_Tbl.COUNT - 1 ;
2388: IF(l_count=1)THEN
2389: IF((l_Anal_Det_Opt_Tbl(l_count).Bsc_dependency_flag = 1)) THEN
2390: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-1))AND(l_Anal_Det_Opt_Tbl(l_count-1).No_of_child=1)) THEN
2391: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2392: ELSE
2393: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2394: END IF;
2395: ELSE

Line 2393: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;

2389: IF((l_Anal_Det_Opt_Tbl(l_count).Bsc_dependency_flag = 1)) THEN
2390: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-1))AND(l_Anal_Det_Opt_Tbl(l_count-1).No_of_child=1)) THEN
2391: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2392: ELSE
2393: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2394: END IF;
2395: ELSE
2396: l_option_count := Get_Num_Analysis_options
2397: (

Line 2399: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1

2395: ELSE
2396: l_option_count := Get_Num_Analysis_options
2397: (
2398: p_obj_id => p_obj_id
2399: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1
2400: );
2401: IF(l_option_count >1) THEN
2402: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2403: ELSE

Line 2402: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;

2398: p_obj_id => p_obj_id
2399: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1
2400: );
2401: IF(l_option_count >1) THEN
2402: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2403: ELSE
2404: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2405: END IF;
2406: END IF;

Line 2404: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2400: );
2401: IF(l_option_count >1) THEN
2402: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2403: ELSE
2404: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2405: END IF;
2406: END IF;
2407: ELSE
2408: IF((l_Anal_Det_Opt_Tbl(l_count).Bsc_dependency_flag = 1)) THEN

Line 2412: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2408: IF((l_Anal_Det_Opt_Tbl(l_count).Bsc_dependency_flag = 1)) THEN
2409: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-1))AND(l_Anal_Det_Opt_Tbl(l_count-1).No_of_child=1)) THEN
2410: IF((l_Anal_Det_Opt_Tbl(l_count-1).Bsc_dependency_flag = 1)) THEN
2411: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child=1)) THEN
2412: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2413: ELSE
2414: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2415: END IF;
2416: ELSE

Line 2414: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;

2410: IF((l_Anal_Det_Opt_Tbl(l_count-1).Bsc_dependency_flag = 1)) THEN
2411: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child=1)) THEN
2412: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2413: ELSE
2414: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2415: END IF;
2416: ELSE
2417: l_option_count := Get_Num_Analysis_options
2418: (

Line 2420: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1

2416: ELSE
2417: l_option_count := Get_Num_Analysis_options
2418: (
2419: p_obj_id => p_obj_id
2420: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1
2421: );
2422: IF(l_option_count >1) THEN
2423: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2424: ELSE

Line 2423: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;

2419: p_obj_id => p_obj_id
2420: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1
2421: );
2422: IF(l_option_count >1) THEN
2423: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2424: ELSE
2425: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2426: END IF;
2427: END IF;

Line 2425: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2421: );
2422: IF(l_option_count >1) THEN
2423: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2424: ELSE
2425: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2426: END IF;
2427: END IF;
2428:
2429: ELSE

Line 2430: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2;

2426: END IF;
2427: END IF;
2428:
2429: ELSE
2430: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2;
2431: END IF;
2432: ELSE
2433: l_option_count := Get_Num_Analysis_options
2434: (

Line 2436: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2

2432: ELSE
2433: l_option_count := Get_Num_Analysis_options
2434: (
2435: p_obj_id => p_obj_id
2436: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2
2437: );
2438: IF(l_option_count >1) THEN
2439: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2;
2440: ELSE

Line 2439: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2;

2435: p_obj_id => p_obj_id
2436: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2
2437: );
2438: IF(l_option_count >1) THEN
2439: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2;
2440: ELSE
2441: IF((l_Anal_Det_Opt_Tbl(l_count-1).Bsc_dependency_flag = 1)) THEN
2442: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child=1)) THEN
2443: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

Line 2443: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2439: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP2;
2440: ELSE
2441: IF((l_Anal_Det_Opt_Tbl(l_count-1).Bsc_dependency_flag = 1)) THEN
2442: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child=1)) THEN
2443: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2444: ELSE
2445: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2446: END IF;
2447: ELSE

Line 2445: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;

2441: IF((l_Anal_Det_Opt_Tbl(l_count-1).Bsc_dependency_flag = 1)) THEN
2442: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child=1)) THEN
2443: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2444: ELSE
2445: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2446: END IF;
2447: ELSE
2448: l_option_count := Get_Num_Analysis_options
2449: (

Line 2451: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1

2447: ELSE
2448: l_option_count := Get_Num_Analysis_options
2449: (
2450: p_obj_id => p_obj_id
2451: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1
2452: );
2453: IF(l_option_count >1) THEN
2454: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2455: ELSE

Line 2454: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;

2450: p_obj_id => p_obj_id
2451: , p_anal_grp_Id => BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1
2452: );
2453: IF(l_option_count >1) THEN
2454: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2455: ELSE
2456: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2457: END IF;
2458: END IF;

Line 2456: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2452: );
2453: IF(l_option_count >1) THEN
2454: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP1;
2455: ELSE
2456: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2457: END IF;
2458: END IF;
2459: END IF;
2460: END IF;

Line 2463: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;

2459: END IF;
2460: END IF;
2461: END IF;
2462: ELSE
2463: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2464: END IF;
2465: RETURN l_Anal_Grp_Id;
2466: END Get_Analysis_Group_Id;
2467:

Line 2481: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

2477: PROCEDURE Set_Default_Analysis_Option
2478: (
2479: p_commit IN VARCHAR
2480: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
2481: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2482: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
2483: , x_return_status OUT NOCOPY VARCHAR2
2484: , x_msg_count OUT NOCOPY NUMBER
2485: , x_msg_data OUT NOCOPY VARCHAR2

Line 2521: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Set_Default_Analysis_Option ';

2517: RAISE;
2518: WHEN OTHERS THEN
2519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2520: IF (x_msg_data IS NOT NULL) THEN
2521: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Set_Default_Analysis_Option ';
2522: ELSE
2523: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Set_Default_Analysis_Option ';
2524: END IF;
2525: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2523: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Set_Default_Analysis_Option ';

2519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2520: IF (x_msg_data IS NOT NULL) THEN
2521: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Set_Default_Analysis_Option ';
2522: ELSE
2523: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Set_Default_Analysis_Option ';
2524: END IF;
2525: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2526: RAISE;
2527: END Set_Default_Analysis_Option;

Line 2542: p_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

2538: Created BY : ashankar For bug 4220400
2539: /**********************************************************/
2540: FUNCTION Default_Anal_Option_Changed
2541: (
2542: p_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2543: , p_Old_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2544: )RETURN BOOLEAN IS
2545: l_return BOOLEAN;
2546: l_count NUMBER;

Line 2543: , p_Old_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

2539: /**********************************************************/
2540: FUNCTION Default_Anal_Option_Changed
2541: (
2542: p_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2543: , p_Old_Anal_Num_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2544: )RETURN BOOLEAN IS
2545: l_return BOOLEAN;
2546: l_count NUMBER;
2547: BEGIN

Line 2564: end BSC_ANALYSIS_OPTION_PUB;

2560: END Default_Anal_Option_Changed;
2561:
2562:
2563:
2564: end BSC_ANALYSIS_OPTION_PUB;