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_DIMENSION_SETS_PUB dependencies on BSC_DIMENSION_SETS_PUB

Line 1: package body BSC_DIMENSION_SETS_PUB as

1: package body BSC_DIMENSION_SETS_PUB as
2: /* $Header: BSCPDMSB.pls 120.0.12000000.2 2007/01/30 11:09:18 ashankar ship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 45: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DIMENSION_SETS_PUB';

41: +======================================================================================+
42: */
43:
44:
45: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DIMENSION_SETS_PUB';
46:
47: /*********************************************************************************************
48: This function will return true if passed dimension id is valid and not equal to "UNASSIGNED"
49: *********************************************************************************************/

Line 99: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

95: --: This procedure is part of the Dimension Set API.
96:
97: procedure Create_Dim_Group_In_Dset(
98: p_commit IN varchar2 := FND_API.G_FALSE
99: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
100: ,p_create_Dim_Lev_Grp IN BOOLEAN
101: ,x_return_status OUT NOCOPY varchar2
102: ,x_msg_count OUT NOCOPY number
103: ,x_msg_data OUT NOCOPY varchar2

Line 106: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

102: ,x_msg_count OUT NOCOPY number
103: ,x_msg_data OUT NOCOPY varchar2
104: ) is
105:
106: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
107: l_count NUMBER := 0;
108: begin
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: --Assign the passed record to the local record.

Line 140: (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id))) THEN

136: -- Call private version of the procedure.
137: -- PAJOHRI added if condition.
138: -- if group_id is null, than don't insert into BSC_KPI_DIM_GROUPS
139: IF ((l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NOT NULL) AND
140: (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id))) THEN
141: BSC_DIMENSION_SETS_PVT.Create_Dim_Group_In_Dset( p_commit
142: ,l_Dim_Set_Rec
143: ,x_return_status
144: ,x_msg_count

Line 230: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

226: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
227: WHEN NO_DATA_FOUND THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
231: ELSE
232: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
233: END IF;
234: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 232: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
231: ELSE
232: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
233: END IF;
234: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 238: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

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

Line 240: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF (x_msg_data IS NOT NULL) THEN
238: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
239: ELSE
240: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
241: END IF;
242: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
243: end Create_Dim_Group_In_Dset;
244:

Line 247: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

243: end Create_Dim_Group_In_Dset;
244:
245: procedure Create_Dim_Group_In_Dset(
246: p_commit IN varchar2 := FND_API.G_FALSE
247: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
248: ,x_return_status OUT NOCOPY varchar2
249: ,x_msg_count OUT NOCOPY number
250: ,x_msg_data OUT NOCOPY varchar2
251: ) is

Line 253: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

249: ,x_msg_count OUT NOCOPY number
250: ,x_msg_data OUT NOCOPY varchar2
251: ) is
252:
253: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
254:
255: begin
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257: Create_Dim_Group_In_Dset(

Line 292: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

288: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
289: WHEN NO_DATA_FOUND THEN
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: IF (x_msg_data IS NOT NULL) THEN
292: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
293: ELSE
294: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
295: END IF;
296: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 294: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: IF (x_msg_data IS NOT NULL) THEN
292: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
293: ELSE
294: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
295: END IF;
296: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 300: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

296: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF (x_msg_data IS NOT NULL) THEN
300: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
301: ELSE
302: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
303: END IF;
304: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 302: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';

298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF (x_msg_data IS NOT NULL) THEN
300: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
301: ELSE
302: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset ';
303: END IF;
304: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
305: end Create_Dim_Group_In_Dset;
306:

Line 312: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

308: ************************************************************************************/
309:
310: procedure Retrieve_Dim_Group_In_Dset(
311: p_commit IN varchar2 := FND_API.G_FALSE
312: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
313: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
314: ,x_return_status OUT NOCOPY varchar2
315: ,x_msg_count OUT NOCOPY number
316: ,x_msg_data OUT NOCOPY varchar2

Line 313: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

309:
310: procedure Retrieve_Dim_Group_In_Dset(
311: p_commit IN varchar2 := FND_API.G_FALSE
312: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
313: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
314: ,x_return_status OUT NOCOPY varchar2
315: ,x_msg_count OUT NOCOPY number
316: ,x_msg_data OUT NOCOPY varchar2
317: ) is

Line 379: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';

375: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
376: WHEN NO_DATA_FOUND THEN
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF (x_msg_data IS NOT NULL) THEN
379: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';
380: ELSE
381: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';
382: END IF;
383: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 381: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';

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

Line 387: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';

383: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
384: WHEN OTHERS THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (x_msg_data IS NOT NULL) THEN
387: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';
388: ELSE
389: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';
390: END IF;
391: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 389: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';

385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (x_msg_data IS NOT NULL) THEN
387: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';
388: ELSE
389: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Group_In_Dset ';
390: END IF;
391: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
392: end Retrieve_Dim_Group_In_Dset;
393:

Line 399: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

395: ************************************************************************************/
396:
397: procedure Update_Dim_Group_In_Dset(
398: p_commit IN varchar2 := FND_API.G_FALSE
399: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
400: ,p_create_Dim_Lev_Grp IN BOOLEAN
401: ,x_return_status OUT NOCOPY varchar2
402: ,x_msg_count OUT NOCOPY number
403: ,x_msg_data OUT NOCOPY varchar2

Line 478: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

474: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
475: WHEN NO_DATA_FOUND THEN
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: IF (x_msg_data IS NOT NULL) THEN
478: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
479: ELSE
480: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
481: END IF;
482: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 480: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

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

Line 486: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

482: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF (x_msg_data IS NOT NULL) THEN
486: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
487: ELSE
488: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
489: END IF;
490: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 488: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF (x_msg_data IS NOT NULL) THEN
486: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
487: ELSE
488: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
489: END IF;
490: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
491: end Update_Dim_Group_In_Dset;
492:

Line 495: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

491: end Update_Dim_Group_In_Dset;
492:
493: procedure Update_Dim_Group_In_Dset(
494: p_commit IN varchar2 := FND_API.G_FALSE
495: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
496: ,x_return_status OUT NOCOPY varchar2
497: ,x_msg_count OUT NOCOPY number
498: ,x_msg_data OUT NOCOPY varchar2
499: ) is

Line 538: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

534: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
535: WHEN NO_DATA_FOUND 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_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
539: ELSE
540: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
541: END IF;
542: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 540: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

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_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
539: ELSE
540: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';
541: END IF;
542: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
543: WHEN OTHERS THEN
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 546: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

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

Line 548: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Group_In_Dset ';

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

Line 563: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

559:
560: procedure Delete_Dim_Group_In_Dset
561: (
562: p_commit IN varchar2 := FND_API.G_FALSE
563: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
564: , p_create_Dim_Lev_Grp IN BOOLEAN
565: , x_return_status OUT NOCOPY varchar2
566: , x_msg_count OUT NOCOPY number
567: , x_msg_data OUT NOCOPY varchar2

Line 569: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

565: , x_return_status OUT NOCOPY varchar2
566: , x_msg_count OUT NOCOPY number
567: , x_msg_data OUT NOCOPY varchar2
568: ) is
569: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
570: l_group_id NUMBER;
571: l_level_id NUMBER;
572:
573: CURSOR c_group_id IS

Line 705: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

701: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
702: WHEN NO_DATA_FOUND THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF (x_msg_data IS NOT NULL) THEN
705: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
706: ELSE
707: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
708: END IF;
709: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 707: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF (x_msg_data IS NOT NULL) THEN
705: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
706: ELSE
707: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
708: END IF;
709: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
710: WHEN OTHERS THEN
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 713: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

709: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
710: WHEN OTHERS THEN
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: IF (x_msg_data IS NOT NULL) THEN
713: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
714: ELSE
715: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
716: END IF;
717: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 715: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: IF (x_msg_data IS NOT NULL) THEN
713: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
714: ELSE
715: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
716: END IF;
717: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
718: end Delete_Dim_Group_In_Dset;
719:

Line 723: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

719:
720:
721: procedure Delete_Dim_Group_In_Dset(
722: p_commit IN varchar2 := FND_API.G_FALSE
723: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
724: ,x_return_status OUT NOCOPY varchar2
725: ,x_msg_count OUT NOCOPY number
726: ,x_msg_data OUT NOCOPY varchar2
727: ) is

Line 729: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

725: ,x_msg_count OUT NOCOPY number
726: ,x_msg_data OUT NOCOPY varchar2
727: ) is
728:
729: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
730:
731: begin
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733: Delete_Dim_Group_In_Dset(

Line 768: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

764: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
765: WHEN NO_DATA_FOUND THEN
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF (x_msg_data IS NOT NULL) THEN
768: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
769: ELSE
770: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
771: END IF;
772: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 770: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF (x_msg_data IS NOT NULL) THEN
768: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
769: ELSE
770: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
771: END IF;
772: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
773: WHEN OTHERS THEN
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 776: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

772: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
773: WHEN OTHERS THEN
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: IF (x_msg_data IS NOT NULL) THEN
776: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
777: ELSE
778: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
779: END IF;
780: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 778: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';

774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: IF (x_msg_data IS NOT NULL) THEN
776: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
777: ELSE
778: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset ';
779: END IF;
780: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
781: end Delete_Dim_Group_In_Dset;
782:

Line 791: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

787: --: This procedure belongs to the Dimension Set API.
788:
789: procedure Create_Bsc_Kpi_Dim_Sets_Tl(
790: p_commit IN varchar2 := FND_API.G_FALSE
791: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
792: ,x_return_status OUT NOCOPY varchar2
793: ,x_msg_count OUT NOCOPY number
794: ,x_msg_data OUT NOCOPY varchar2
795: ) is

Line 829: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';

825: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
826: WHEN NO_DATA_FOUND THEN
827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF (x_msg_data IS NOT NULL) THEN
829: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
830: ELSE
831: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
832: END IF;
833: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 831: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';

827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF (x_msg_data IS NOT NULL) THEN
829: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
830: ELSE
831: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
832: END IF;
833: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
834: WHEN OTHERS THEN
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 837: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';

833: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
834: WHEN OTHERS THEN
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: IF (x_msg_data IS NOT NULL) THEN
837: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
838: ELSE
839: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
840: END IF;
841: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 839: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';

835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: IF (x_msg_data IS NOT NULL) THEN
837: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
838: ELSE
839: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl ';
840: END IF;
841: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
842: end Create_Bsc_Kpi_Dim_Sets_Tl;
843:

Line 849: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

845: ************************************************************************************/
846:
847: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
848: p_commit IN varchar2 := FND_API.G_FALSE
849: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
850: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
851: ,x_return_status OUT NOCOPY varchar2
852: ,x_msg_count OUT NOCOPY number
853: ,x_msg_data OUT NOCOPY varchar2

Line 850: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

846:
847: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
848: p_commit IN varchar2 := FND_API.G_FALSE
849: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
850: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
851: ,x_return_status OUT NOCOPY varchar2
852: ,x_msg_count OUT NOCOPY number
853: ,x_msg_data OUT NOCOPY varchar2
854: ) is

Line 888: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

884: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
885: WHEN NO_DATA_FOUND THEN
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: IF (x_msg_data IS NOT NULL) THEN
888: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
889: ELSE
890: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
891: END IF;
892: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 890: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: IF (x_msg_data IS NOT NULL) THEN
888: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
889: ELSE
890: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
891: END IF;
892: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
893: WHEN OTHERS THEN
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 896: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

892: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
893: WHEN OTHERS THEN
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: IF (x_msg_data IS NOT NULL) THEN
896: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
897: ELSE
898: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
899: END IF;
900: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 898: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: IF (x_msg_data IS NOT NULL) THEN
896: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
897: ELSE
898: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
899: END IF;
900: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
901: end Retrieve_Bsc_Kpi_Dim_Sets_Tl;
902:

Line 908: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

904: ************************************************************************************/
905:
906: procedure Update_Bsc_Kpi_Dim_Sets_Tl(
907: p_commit IN varchar2 := FND_API.G_FALSE
908: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
909: ,x_return_status OUT NOCOPY varchar2
910: ,x_msg_count OUT NOCOPY number
911: ,x_msg_data OUT NOCOPY varchar2
912: ) is

Line 946: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';

942: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
943: WHEN NO_DATA_FOUND THEN
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: IF (x_msg_data IS NOT NULL) THEN
946: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
947: ELSE
948: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
949: END IF;
950: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 948: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';

944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: IF (x_msg_data IS NOT NULL) THEN
946: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
947: ELSE
948: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
949: END IF;
950: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
951: WHEN OTHERS THEN
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 954: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';

950: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
951: WHEN OTHERS THEN
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: IF (x_msg_data IS NOT NULL) THEN
954: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
955: ELSE
956: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
957: END IF;
958: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 956: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';

952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: IF (x_msg_data IS NOT NULL) THEN
954: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
955: ELSE
956: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl ';
957: END IF;
958: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
959: end Update_Bsc_Kpi_Dim_Sets_Tl;
960:

Line 966: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

962: ************************************************************************************/
963:
964: procedure Delete_Bsc_Kpi_Dim_Sets_Tl(
965: p_commit IN varchar2 := FND_API.G_FALSE
966: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
967: ,x_return_status OUT NOCOPY varchar2
968: ,x_msg_count OUT NOCOPY number
969: ,x_msg_data OUT NOCOPY varchar2
970: ) is

Line 1006: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';

1002: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1003: WHEN NO_DATA_FOUND THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: IF (x_msg_data IS NOT NULL) THEN
1006: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1007: ELSE
1008: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1009: END IF;
1010: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1008: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';

1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: IF (x_msg_data IS NOT NULL) THEN
1006: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1007: ELSE
1008: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1009: END IF;
1010: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1011: WHEN OTHERS THEN
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1014: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';

1010: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1011: WHEN OTHERS THEN
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: IF (x_msg_data IS NOT NULL) THEN
1014: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1015: ELSE
1016: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1017: END IF;
1018: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1016: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';

1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: IF (x_msg_data IS NOT NULL) THEN
1014: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1015: ELSE
1016: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Bsc_Kpi_Dim_Sets_Tl ';
1017: END IF;
1018: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1019: end Delete_Bsc_Kpi_Dim_Sets_Tl;
1020:

Line 1029: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1025: --: This procedure belongs to the Dimension Set API.
1026:
1027: procedure Create_Dim_Level_Properties(
1028: p_commit IN varchar2 := FND_API.G_FALSE
1029: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1030: ,x_return_status OUT NOCOPY varchar2
1031: ,x_msg_count OUT NOCOPY number
1032: ,x_msg_data OUT NOCOPY varchar2
1033: ) is

Line 1036: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Tbl_Type;

1032: ,x_msg_data OUT NOCOPY varchar2
1033: ) is
1034:
1035: -- Define a Table Record.
1036: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Tbl_Type;
1037:
1038: l_cnt number;
1039:
1040: CURSOR c_Dim_Level_Id IS

Line 1047: IF (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id)) THEN

1043: WHERE DIM_GROUP_ID = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
1044:
1045: begin
1046: x_return_status := FND_API.G_RET_STS_SUCCESS;
1047: IF (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id)) THEN
1048: -- Set the first values of the Table Record equal to the Record passed.
1049: l_Dim_Set_Rec(1).Bsc_Kpi_Id := p_Dim_Set_Rec.Bsc_Kpi_Id;
1050: l_Dim_Set_Rec(1).Bsc_Dim_Set_Id := p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1051: l_Dim_Set_Rec(1).Bsc_Dim_Set_Name := p_Dim_Set_Rec.Bsc_Dim_Set_Name;

Line 1138: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';

1134: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1135: WHEN NO_DATA_FOUND THEN
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: IF (x_msg_data IS NOT NULL) THEN
1138: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1139: ELSE
1140: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1141: END IF;
1142: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1140: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';

1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: IF (x_msg_data IS NOT NULL) THEN
1138: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1139: ELSE
1140: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1141: END IF;
1142: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1143: WHEN OTHERS THEN
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1146: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';

1142: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1143: WHEN OTHERS THEN
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: IF (x_msg_data IS NOT NULL) THEN
1146: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1147: ELSE
1148: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1149: END IF;
1150: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1148: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';

1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: IF (x_msg_data IS NOT NULL) THEN
1146: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1147: ELSE
1148: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties ';
1149: END IF;
1150: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1151: end Create_Dim_Level_Properties;
1152:

Line 1158: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1154: ************************************************************************************/
1155:
1156: procedure Retrieve_Dim_Level_Properties(
1157: p_commit IN varchar2 := FND_API.G_FALSE
1158: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1159: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1160: ,x_return_status OUT NOCOPY varchar2
1161: ,x_msg_count OUT NOCOPY number
1162: ,x_msg_data OUT NOCOPY varchar2

Line 1159: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1155:
1156: procedure Retrieve_Dim_Level_Properties(
1157: p_commit IN varchar2 := FND_API.G_FALSE
1158: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1159: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1160: ,x_return_status OUT NOCOPY varchar2
1161: ,x_msg_count OUT NOCOPY number
1162: ,x_msg_data OUT NOCOPY varchar2
1163: ) is

Line 1198: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';

1194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1195: WHEN NO_DATA_FOUND THEN
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF (x_msg_data IS NOT NULL) THEN
1198: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1199: ELSE
1200: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1201: END IF;
1202: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1200: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';

1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF (x_msg_data IS NOT NULL) THEN
1198: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1199: ELSE
1200: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1201: END IF;
1202: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1206: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';

1202: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: IF (x_msg_data IS NOT NULL) THEN
1206: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1207: ELSE
1208: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1209: END IF;
1210: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1208: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';

1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: IF (x_msg_data IS NOT NULL) THEN
1206: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1207: ELSE
1208: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Level_Properties ';
1209: END IF;
1210: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1211: end Retrieve_Dim_Level_Properties;
1212:

Line 1218: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1214: ************************************************************************************/
1215:
1216: procedure Update_Dim_Level_Properties(
1217: p_commit IN varchar2 := FND_API.G_FALSE
1218: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1219: ,x_return_status OUT NOCOPY varchar2
1220: ,x_msg_count OUT NOCOPY number
1221: ,x_msg_data OUT NOCOPY varchar2
1222: ) is

Line 1256: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';

1252: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1253: WHEN NO_DATA_FOUND THEN
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: IF (x_msg_data IS NOT NULL) THEN
1256: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1257: ELSE
1258: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1259: END IF;
1260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1258: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';

1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: IF (x_msg_data IS NOT NULL) THEN
1256: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1257: ELSE
1258: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1259: END IF;
1260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1261: WHEN OTHERS THEN
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1264: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';

1260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1261: WHEN OTHERS THEN
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: IF (x_msg_data IS NOT NULL) THEN
1264: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1265: ELSE
1266: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1267: END IF;
1268: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1266: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';

1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: IF (x_msg_data IS NOT NULL) THEN
1264: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1265: ELSE
1266: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Level_Properties ';
1267: END IF;
1268: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1269: end Update_Dim_Level_Properties;
1270:

Line 1276: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1272: ************************************************************************************/
1273:
1274: procedure Delete_Dim_Level_Properties(
1275: p_commit IN varchar2 := FND_API.G_FALSE
1276: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1277: ,x_return_status OUT NOCOPY varchar2
1278: ,x_msg_count OUT NOCOPY number
1279: ,x_msg_data OUT NOCOPY varchar2
1280: ) is

Line 1283: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Tbl_Type;

1279: ,x_msg_data OUT NOCOPY varchar2
1280: ) is
1281:
1282: --Define a Table Record.
1283: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Tbl_Type;
1284:
1285: TYPE Recdc_value IS REF CURSOR;
1286: dc_value Recdc_value;
1287:

Line 1368: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';

1364: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1365: WHEN NO_DATA_FOUND THEN
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: IF (x_msg_data IS NOT NULL) THEN
1368: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1369: ELSE
1370: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1371: END IF;
1372: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1370: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';

1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: IF (x_msg_data IS NOT NULL) THEN
1368: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1369: ELSE
1370: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1371: END IF;
1372: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1373: WHEN OTHERS THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1376: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';

1372: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1373: WHEN OTHERS THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: IF (x_msg_data IS NOT NULL) THEN
1376: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1377: ELSE
1378: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1379: END IF;
1380: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1378: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';

1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: IF (x_msg_data IS NOT NULL) THEN
1376: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1377: ELSE
1378: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Level_Properties ';
1379: END IF;
1380: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1381: end Delete_Dim_Level_Properties;
1382:

Line 1392: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1388:
1389: PROCEDURE Reorder_Dim_Levels
1390: (
1391: p_commit IN VARCHAR2 := FND_API.G_FALSE
1392: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1393: , x_return_status OUT NOCOPY VARCHAR2
1394: , x_msg_count OUT NOCOPY NUMBER
1395: , x_msg_data OUT NOCOPY VARCHAR2
1396: ) IS

Line 1475: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';

1471: WHEN NO_DATA_FOUND THEN
1472: ROLLBACK TO ReorderBSCDimLevsPUB;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF (x_msg_data IS NOT NULL) THEN
1475: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1476: ELSE
1477: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1478: END IF;
1479: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1477: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';

1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF (x_msg_data IS NOT NULL) THEN
1475: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1476: ELSE
1477: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1478: END IF;
1479: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1480: WHEN OTHERS THEN
1481: ROLLBACK TO ReorderBSCDimLevsPUB;

Line 1484: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';

1480: WHEN OTHERS THEN
1481: ROLLBACK TO ReorderBSCDimLevsPUB;
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: IF (x_msg_data IS NOT NULL) THEN
1484: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1485: ELSE
1486: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1487: END IF;
1488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1486: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';

1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: IF (x_msg_data IS NOT NULL) THEN
1484: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1485: ELSE
1486: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels ';
1487: END IF;
1488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1489: end Reorder_Dim_Levels;
1490:

Line 1501: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1497:
1498:
1499: PROCEDURE Create_Dim_Levels
1500: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1502: , x_return_status OUT NOCOPY VARCHAR2
1503: , x_msg_count OUT NOCOPY NUMBER
1504: , x_msg_data OUT NOCOPY VARCHAR2
1505: ) IS

Line 1506: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

1502: , x_return_status OUT NOCOPY VARCHAR2
1503: , x_msg_count OUT NOCOPY NUMBER
1504: , x_msg_data OUT NOCOPY VARCHAR2
1505: ) IS
1506: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1507: l_Update_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1508:
1509: l_index_cnt NUMBER := 0;
1510: l_count NUMBER;

Line 1507: l_Update_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

1503: , x_msg_count OUT NOCOPY NUMBER
1504: , x_msg_data OUT NOCOPY VARCHAR2
1505: ) IS
1506: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1507: l_Update_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1508:
1509: l_index_cnt NUMBER := 0;
1510: l_count NUMBER;
1511:

Line 1611: ELSIF (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id)) THEN

1607: , x_return_status => x_return_status
1608: , x_msg_count => x_msg_count
1609: , x_msg_data => x_msg_data
1610: );
1611: ELSIF (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id)) THEN
1612: -- Set the first values of the Table Record equal to the Record passed.
1613: --DBMS_OUTPUT.PUT_LINE(' Step 1');
1614: l_Dim_Set_Rec.Bsc_Kpi_Id := p_Dim_Set_Rec.Bsc_Kpi_Id;
1615: l_Dim_Set_Rec.Bsc_Dim_Set_Id := p_Dim_Set_Rec.Bsc_Dim_Set_Id;

Line 1724: BSC_DIMENSION_SETS_PUB.Update_Dim_Levels

1720: l_Update_Dim_Set_Rec.Bsc_Dset_Parent_Level_Rel := NULL;
1721: l_Update_Dim_Set_Rec.Bsc_Dset_Parent_Level_Index := NULL;
1722: l_Update_Dim_Set_Rec.Bsc_Dset_Table_Relation := NULL;
1723: END IF;
1724: BSC_DIMENSION_SETS_PUB.Update_Dim_Levels
1725: ( p_commit => FND_API.G_FALSE
1726: , p_Dim_Set_Rec => l_Update_Dim_Set_Rec
1727: , x_return_status => x_return_status
1728: , x_msg_count => x_msg_count

Line 1732: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Update_Dim_Levels');

1728: , x_msg_count => x_msg_count
1729: , x_msg_data => x_msg_data
1730: );
1731: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1732: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Update_Dim_Levels');
1733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1734: END IF;
1735: END IF;
1736: END IF;

Line 1759: BSC_DIMENSION_SETS_PUB.Update_Dim_Levels

1755: l_Update_Dim_Set_Rec.Bsc_Level_Name := cd.Level_Table_Name;
1756: l_Update_Dim_Set_Rec.Bsc_Dset_Parent_Level_Rel := cd.Level_Pk_Col;
1757: l_Update_Dim_Set_Rec.Bsc_Dset_Parent_Level_Index := cd.Par_Dim_Level_Index;
1758: l_Update_Dim_Set_Rec.Bsc_Dset_Table_Relation := NULL;
1759: BSC_DIMENSION_SETS_PUB.Update_Dim_Levels
1760: ( p_commit => FND_API.G_FALSE
1761: , p_Dim_Set_Rec => l_Update_Dim_Set_Rec
1762: , x_return_status => x_return_status
1763: , x_msg_count => x_msg_count

Line 1767: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Update_Dim_Levels');

1763: , x_msg_count => x_msg_count
1764: , x_msg_data => x_msg_data
1765: );
1766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1767: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Update_Dim_Levels');
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770: END IF;
1771: END IF;

Line 1778: BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels

1774:
1775: -- Establish relationship if the Dimension Levels are from other Groups.
1776: --DBMS_OUTPUT.PUT_LINE(' Step 2');
1777:
1778: BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels
1779: ( p_commit => FND_API.G_FALSE
1780: , p_Dim_Set_Rec => p_Dim_Set_Rec
1781: , x_return_status => x_return_status
1782: , x_msg_count => x_msg_count

Line 1786: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels');

1782: , x_msg_count => x_msg_count
1783: , x_msg_data => x_msg_data
1784: );
1785: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1786: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels');
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789: -- 09/16 adrao added for bug# 3141813
1790: SELECT COUNT(0) INTO l_count

Line 1864: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';

1860: WHEN NO_DATA_FOUND THEN
1861: ROLLBACK TO CreateBSCDimLevsPUB;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: IF (x_msg_data IS NOT NULL) THEN
1864: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1865: ELSE
1866: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1867: END IF;
1868: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1866: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';

1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: IF (x_msg_data IS NOT NULL) THEN
1864: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1865: ELSE
1866: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1867: END IF;
1868: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1869: WHEN OTHERS THEN
1870: ROLLBACK TO CreateBSCDimLevsPUB;

Line 1873: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';

1869: WHEN OTHERS THEN
1870: ROLLBACK TO CreateBSCDimLevsPUB;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: IF (x_msg_data IS NOT NULL) THEN
1873: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1874: ELSE
1875: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1876: END IF;
1877: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1875: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';

1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: IF (x_msg_data IS NOT NULL) THEN
1873: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1874: ELSE
1875: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels ';
1876: END IF;
1877: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1878: end Create_Dim_Levels;
1879:

Line 1885: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1881: ************************************************************************************/
1882:
1883: procedure Retrieve_Dim_Levels(
1884: p_commit IN varchar2 := FND_API.G_FALSE
1885: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1886: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1887: ,x_return_status OUT NOCOPY varchar2
1888: ,x_msg_count OUT NOCOPY number
1889: ,x_msg_data OUT NOCOPY varchar2

Line 1886: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1882:
1883: procedure Retrieve_Dim_Levels(
1884: p_commit IN varchar2 := FND_API.G_FALSE
1885: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1886: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1887: ,x_return_status OUT NOCOPY varchar2
1888: ,x_msg_count OUT NOCOPY number
1889: ,x_msg_data OUT NOCOPY varchar2
1890: ) is

Line 1925: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';

1921: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1922: WHEN NO_DATA_FOUND THEN
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924: IF (x_msg_data IS NOT NULL) THEN
1925: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1926: ELSE
1927: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1928: END IF;
1929: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1927: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';

1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924: IF (x_msg_data IS NOT NULL) THEN
1925: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1926: ELSE
1927: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1928: END IF;
1929: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1930: WHEN OTHERS THEN
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1933: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';

1929: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1930: WHEN OTHERS THEN
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: IF (x_msg_data IS NOT NULL) THEN
1933: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1934: ELSE
1935: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1936: END IF;
1937: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1935: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';

1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: IF (x_msg_data IS NOT NULL) THEN
1933: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1934: ELSE
1935: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Retrieve_Dim_Levels ';
1936: END IF;
1937: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1938: end Retrieve_Dim_Levels;
1939:

Line 1945: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1941: ************************************************************************************/
1942:
1943: procedure Update_Dim_Levels(
1944: p_commit IN varchar2 := FND_API.G_FALSE
1945: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1946: ,x_return_status OUT NOCOPY varchar2
1947: ,x_msg_count OUT NOCOPY number
1948: ,x_msg_data OUT NOCOPY varchar2
1949: ) is

Line 1960: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels');

1956: ,x_return_status
1957: ,x_msg_count
1958: ,x_msg_data);
1959: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1960: --DBMS_OUTPUT.PUT_LINE('BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels');
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962: END IF;
1963:
1964: -- added to relax checking for mixed type of Dimension Objects within a Dimension

Line 2028: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';

2024: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2025: WHEN NO_DATA_FOUND THEN
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: IF (x_msg_data IS NOT NULL) THEN
2028: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2029: ELSE
2030: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2031: END IF;
2032: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2030: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';

2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: IF (x_msg_data IS NOT NULL) THEN
2028: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2029: ELSE
2030: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2031: END IF;
2032: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2033: WHEN OTHERS THEN
2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2036: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';

2032: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2033: WHEN OTHERS THEN
2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2035: IF (x_msg_data IS NOT NULL) THEN
2036: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2037: ELSE
2038: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2039: END IF;
2040: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2038: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';

2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2035: IF (x_msg_data IS NOT NULL) THEN
2036: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2037: ELSE
2038: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Dim_Levels ';
2039: END IF;
2040: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2041: end Update_Dim_Levels;
2042:

Line 2049: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

2045:
2046: procedure Delete_Dim_Levels
2047: (
2048: p_commit IN VARCHAR2 := FND_API.G_FALSE
2049: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
2050: , x_return_status OUT NOCOPY VARCHAR2
2051: , x_msg_count OUT NOCOPY NUMBER
2052: , x_msg_data OUT NOCOPY VARCHAR2
2053: ) is

Line 2056: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Tbl_Type;

2052: , x_msg_data OUT NOCOPY VARCHAR2
2053: ) is
2054:
2055: -- Define a Table Record.
2056: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Tbl_Type;
2057:
2058: CURSOR c_Delete_Dim_Level IS
2059: SELECT DISTINCT A.DIM_LEVEL_ID
2060: ,B.LEVEL_TABLE_NAME

Line 2145: BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels( p_commit

2141: ,x_msg_count
2142: ,x_msg_data);
2143: END IF;
2144:
2145: BSC_DIMENSION_SETS_PUB.Reorder_Dim_Levels( p_commit
2146: ,p_Dim_Set_Rec
2147: ,x_return_status
2148: ,x_msg_count
2149: ,x_msg_data);

Line 2175: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';

2171: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2172: WHEN NO_DATA_FOUND THEN
2173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2174: IF (x_msg_data IS NOT NULL) THEN
2175: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2176: ELSE
2177: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2178: END IF;
2179: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2177: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';

2173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2174: IF (x_msg_data IS NOT NULL) THEN
2175: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2176: ELSE
2177: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2178: END IF;
2179: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2180: WHEN OTHERS THEN
2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2183: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';

2179: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2180: WHEN OTHERS THEN
2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2182: IF (x_msg_data IS NOT NULL) THEN
2183: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2184: ELSE
2185: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2186: END IF;
2187: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2185: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';

2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2182: IF (x_msg_data IS NOT NULL) THEN
2183: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2184: ELSE
2185: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Delete_Dim_Levels ';
2186: END IF;
2187: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2188: end Delete_Dim_Levels;
2189:

Line 2198: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

2194: --: This procedure is part of the Dimension Set API.
2195:
2196: procedure Update_Kpi_Analysis_Options_B(
2197: p_commit IN varchar2 := FND_API.G_FALSE
2198: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
2199: ,x_return_status OUT NOCOPY varchar2
2200: ,x_msg_count OUT NOCOPY number
2201: ,x_msg_data OUT NOCOPY varchar2
2202: ) is

Line 2236: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';

2232: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2233: WHEN NO_DATA_FOUND THEN
2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2235: IF (x_msg_data IS NOT NULL) THEN
2236: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2237: ELSE
2238: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2239: END IF;
2240: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2238: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';

2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2235: IF (x_msg_data IS NOT NULL) THEN
2236: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2237: ELSE
2238: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2239: END IF;
2240: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2241: WHEN OTHERS THEN
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2244: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';

2240: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2241: WHEN OTHERS THEN
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: IF (x_msg_data IS NOT NULL) THEN
2244: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2245: ELSE
2246: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2247: END IF;
2248: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2246: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';

2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: IF (x_msg_data IS NOT NULL) THEN
2244: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2245: ELSE
2246: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B ';
2247: END IF;
2248: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2249: end Update_Kpi_Analysis_Options_B;
2250:

Line 2255: end BSC_DIMENSION_SETS_PUB;

2251: /************************************************************************************
2252: ************************************************************************************/
2253:
2254:
2255: end BSC_DIMENSION_SETS_PUB;