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_DATASETS_PUB dependencies on BSC_DATASETS_PUB

Line 1: package body BSC_DATASETS_PUB as

1: package body BSC_DATASETS_PUB as
2: /* $Header: BSCPDTSB.pls 120.2 2007/02/08 13:31:27 akoduri ship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DATASETS_PUB';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DATASETS_PUB';

1: package body BSC_DATASETS_PUB as
2: /* $Header: BSCPDTSB.pls 120.2 2007/02/08 13:31:27 akoduri ship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DATASETS_PUB';
5:
6: --: This procedure creates a BSC measure. This is the entry point for the
7: --: Data Set API.
8: --: This procedure is part of the Data Set API.

Line 12: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

8: --: This procedure is part of the Data Set API.
9: -- mdamle 03/12/2003 - PMD - Measure Definer - Added x_dataset_id
10: procedure Create_Measures (
11: p_commit IN varchar2 := FND_API.G_FALSE
12: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
13: ,x_Dataset_Id OUT NOCOPY number
14: ,x_return_status OUT NOCOPY varchar2
15: ,x_msg_count OUT NOCOPY number
16: ,x_msg_data OUT NOCOPY varchar2

Line 19: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

15: ,x_msg_count OUT NOCOPY number
16: ,x_msg_data OUT NOCOPY varchar2
17: ) is
18:
19: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
20: l_measure_col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
21:
22: begin
23: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 142: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';

138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: WHEN NO_DATA_FOUND THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (x_msg_data IS NOT NULL) THEN
142: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
143: ELSE
144: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
145: END IF;
146: WHEN OTHERS THEN

Line 144: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';

140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (x_msg_data IS NOT NULL) THEN
142: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
143: ELSE
144: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
145: END IF;
146: WHEN OTHERS THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (x_msg_data IS NOT NULL) THEN

Line 149: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';

145: END IF;
146: WHEN OTHERS THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (x_msg_data IS NOT NULL) THEN
149: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
150: ELSE
151: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
152: END IF;
153: end Create_Measures;

Line 151: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';

147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (x_msg_data IS NOT NULL) THEN
149: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
150: ELSE
151: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
152: END IF;
153: end Create_Measures;
154:
155: /************************************************************************************

Line 161: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

157:
158: -- ADRAO : Overloaded for iBuilder
159: procedure Create_Measures (
160: p_commit IN varchar2 := FND_API.G_FALSE
161: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
162: ,x_return_status OUT NOCOPY varchar2
163: ,x_msg_count OUT NOCOPY number
164: ,x_msg_data OUT NOCOPY varchar2
165: ) is

Line 167: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

163: ,x_msg_count OUT NOCOPY number
164: ,x_msg_data OUT NOCOPY varchar2
165: ) is
166:
167: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
168: l_measure_col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
169:
170: begin
171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 287: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';

283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: WHEN NO_DATA_FOUND THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF (x_msg_data IS NOT NULL) THEN
287: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
288: ELSE
289: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
290: END IF;
291: WHEN OTHERS THEN

Line 289: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';

285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF (x_msg_data IS NOT NULL) THEN
287: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
288: ELSE
289: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
290: END IF;
291: WHEN OTHERS THEN
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: IF (x_msg_data IS NOT NULL) THEN

Line 294: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';

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

Line 296: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';

292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: IF (x_msg_data IS NOT NULL) THEN
294: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Measures ';
295: ELSE
296: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Measures ';
297: END IF;
298:
299: end Create_Measures;
300:

Line 307: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

303: -- ADRAO : Overloaded for iBuilder
304:
305: procedure Retrieve_Measures(
306: p_commit IN varchar2 := FND_API.G_FALSE
307: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
308: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
309: ,x_return_status OUT NOCOPY varchar2
310: ,x_msg_count OUT NOCOPY number
311: ,x_msg_data OUT NOCOPY varchar2

Line 308: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

304:
305: procedure Retrieve_Measures(
306: p_commit IN varchar2 := FND_API.G_FALSE
307: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
308: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
309: ,x_return_status OUT NOCOPY varchar2
310: ,x_msg_count OUT NOCOPY number
311: ,x_msg_data OUT NOCOPY varchar2
312: ) is

Line 352: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Measures ';

348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: WHEN NO_DATA_FOUND THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: IF (x_msg_data IS NOT NULL) THEN
352: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Measures ';
353: ELSE
354: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Measures ';
355: END IF;
356: WHEN OTHERS THEN

Line 354: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Measures ';

350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: IF (x_msg_data IS NOT NULL) THEN
352: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Measures ';
353: ELSE
354: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Measures ';
355: END IF;
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN

Line 359: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Measures ';

355: END IF;
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN
359: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Measures ';
360: ELSE
361: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Measures ';
362: END IF;
363: end Retrieve_Measures;

Line 361: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Measures ';

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN
359: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Measures ';
360: ELSE
361: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Measures ';
362: END IF;
363: end Retrieve_Measures;
364:
365: /************************************************************************************

Line 370: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

366: ************************************************************************************/
367:
368: procedure Update_Measures(
369: p_commit IN varchar2 := FND_API.G_FALSE
370: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
371: ,x_return_status OUT NOCOPY varchar2
372: ,x_msg_count OUT NOCOPY number
373: ,x_msg_data OUT NOCOPY varchar2
374: ) is

Line 412: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: WHEN NO_DATA_FOUND THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF (x_msg_data IS NOT NULL) THEN
412: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
413: ELSE
414: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
415: END IF;
416: WHEN OTHERS THEN

Line 414: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF (x_msg_data IS NOT NULL) THEN
412: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
413: ELSE
414: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
415: END IF;
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN

Line 419: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

415: END IF;
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
420: ELSE
421: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
422: END IF;
423: end Update_Measures;

Line 421: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
420: ELSE
421: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
422: END IF;
423: end Update_Measures;
424:
425: /************************************************************************************

Line 431: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

427:
428: -- mdamle 04/23/2003 - PMD - Measure Definer - Added p_update_dset_calc
429: procedure Update_Measures(
430: p_commit IN varchar2 := FND_API.G_FALSE
431: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
432: ,p_update_dset_calc IN BOOLEAN
433: ,x_return_status OUT NOCOPY varchar2
434: ,x_msg_count OUT NOCOPY number
435: ,x_msg_data OUT NOCOPY varchar2

Line 475: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: WHEN NO_DATA_FOUND THEN
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: IF (x_msg_data IS NOT NULL) THEN
475: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
476: ELSE
477: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
478: END IF;
479: WHEN OTHERS THEN

Line 477: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: IF (x_msg_data IS NOT NULL) THEN
475: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
476: ELSE
477: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
478: END IF;
479: WHEN OTHERS THEN
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF (x_msg_data IS NOT NULL) THEN

Line 482: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';

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

Line 484: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF (x_msg_data IS NOT NULL) THEN
482: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Measures ';
483: ELSE
484: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Measures ';
485: END IF;
486: end Update_Measures;
487:
488: /************************************************************************************

Line 493: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

489: ************************************************************************************/
490:
491: procedure Delete_Measures(
492: p_commit IN varchar2 := FND_API.G_FALSE
493: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
494: ,x_return_status OUT NOCOPY varchar2
495: ,x_msg_count OUT NOCOPY number
496: ,x_msg_data OUT NOCOPY varchar2
497: ) is

Line 537: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Measures ';

533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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_DATASETS_PUB.Delete_Measures ';
538: ELSE
539: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';
540: END IF;
541: WHEN OTHERS THEN

Line 539: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';

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_DATASETS_PUB.Delete_Measures ';
538: ELSE
539: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';
540: END IF;
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: IF (x_msg_data IS NOT NULL) THEN

Line 544: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Measures ';

540: END IF;
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: IF (x_msg_data IS NOT NULL) THEN
544: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Measures ';
545: ELSE
546: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';
547: END IF;
548: end Delete_Measures;

Line 546: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: IF (x_msg_data IS NOT NULL) THEN
544: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Measures ';
545: ELSE
546: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Measures ';
547: END IF;
548: end Delete_Measures;
549:
550: /************************************************************************************

Line 556: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

552: /*
553:
554: procedure Create_Formats(
555: p_commit IN varchar2 := FND_API.G_FALSE
556: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
557: ,x_return_status OUT NOCOPY varchar2
558: ,x_msg_count OUT NOCOPY number
559: ,x_msg_data OUT NOCOPY varchar2
560: ) is

Line 586: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Formats ';

582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583: WHEN NO_DATA_FOUND THEN
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: IF (x_msg_data IS NOT NULL) THEN
586: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Formats ';
587: ELSE
588: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Formats ';
589: END IF;
590: WHEN OTHERS THEN

Line 588: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Formats ';

584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: IF (x_msg_data IS NOT NULL) THEN
586: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Formats ';
587: ELSE
588: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Formats ';
589: END IF;
590: WHEN OTHERS THEN
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: IF (x_msg_data IS NOT NULL) THEN

Line 593: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Formats ';

589: END IF;
590: WHEN OTHERS THEN
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: IF (x_msg_data IS NOT NULL) THEN
593: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Formats ';
594: ELSE
595: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Formats ';
596: END IF;
597: end Create_Formats;

Line 595: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Formats ';

591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: IF (x_msg_data IS NOT NULL) THEN
593: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Formats ';
594: ELSE
595: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Formats ';
596: END IF;
597: end Create_Formats;
598: */
599:

Line 606: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

602: /*
603:
604: procedure Delete_Formats(
605: p_commit IN varchar2 := FND_API.G_FALSE
606: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
607: ,x_return_status OUT NOCOPY varchar2
608: ,x_msg_count OUT NOCOPY number
609: ,x_msg_data OUT NOCOPY varchar2
610: ) is

Line 636: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';

632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: WHEN NO_DATA_FOUND THEN
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';
637: ELSE
638: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';
639: END IF;
640: WHEN OTHERS THEN

Line 638: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';

634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';
637: ELSE
638: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';
639: END IF;
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: IF (x_msg_data IS NOT NULL) THEN

Line 643: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';

639: END IF;
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: IF (x_msg_data IS NOT NULL) THEN
643: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';
644: ELSE
645: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';
646: END IF;
647: end Delete_Formats;

Line 645: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';

641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: IF (x_msg_data IS NOT NULL) THEN
643: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Formats ';
644: ELSE
645: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Formats ';
646: END IF;
647: end Delete_Formats;
648: */
649:

Line 658: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

654: --: This procedure is part of the Data Set API.
655: -- mdamle 04/23/2003 - PMD - Measure Definer - Added x_dataset_id
656: procedure Create_Dataset(
657: p_commit IN varchar2 := FND_API.G_FALSE
658: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
659: ,x_Dataset_Id OUT NOCOPY number
660: ,x_return_status OUT NOCOPY varchar2
661: ,x_msg_count OUT NOCOPY number
662: ,x_msg_data OUT NOCOPY varchar2

Line 665: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

661: ,x_msg_count OUT NOCOPY number
662: ,x_msg_data OUT NOCOPY varchar2
663: ) is
664:
665: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
666:
667: l_count number;
668:
669: begin

Line 761: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';

757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: WHEN NO_DATA_FOUND THEN
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: IF (x_msg_data IS NOT NULL) THEN
761: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';
762: ELSE
763: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
764: END IF;
765: WHEN OTHERS THEN

Line 763: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';

759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: IF (x_msg_data IS NOT NULL) THEN
761: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';
762: ELSE
763: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
764: END IF;
765: WHEN OTHERS THEN
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF (x_msg_data IS NOT NULL) THEN

Line 768: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';

764: END IF;
765: WHEN OTHERS 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_DATASETS_PUB.Create_Dataset ';
769: ELSE
770: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
771: END IF;
772: end Create_Dataset;

Line 770: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';

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_DATASETS_PUB.Create_Dataset ';
769: ELSE
770: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
771: END IF;
772: end Create_Dataset;
773:
774: /************************************************************************************

Line 779: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

775: ************************************************************************************/
776: -- ADRAO : Overloaded for iBuilder
777: procedure Create_Dataset(
778: p_commit IN varchar2 := FND_API.G_FALSE
779: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
780: ,x_return_status OUT NOCOPY varchar2
781: ,x_msg_count OUT NOCOPY number
782: ,x_msg_data OUT NOCOPY varchar2
783: ) is

Line 785: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

781: ,x_msg_count OUT NOCOPY number
782: ,x_msg_data OUT NOCOPY varchar2
783: ) is
784:
785: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
786:
787: l_count number;
788:
789: begin

Line 876: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';

872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: WHEN NO_DATA_FOUND THEN
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF (x_msg_data IS NOT NULL) THEN
876: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';
877: ELSE
878: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
879: END IF;
880: WHEN OTHERS THEN

Line 878: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';

874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF (x_msg_data IS NOT NULL) THEN
876: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';
877: ELSE
878: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
879: END IF;
880: WHEN OTHERS THEN
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: IF (x_msg_data IS NOT NULL) THEN

Line 883: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset ';

879: END IF;
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_DATASETS_PUB.Create_Dataset ';
884: ELSE
885: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
886: END IF;
887: end Create_Dataset;

Line 885: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';

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_DATASETS_PUB.Create_Dataset ';
884: ELSE
885: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset ';
886: END IF;
887: end Create_Dataset;
888:
889: -- ADRAO : Overloaded for iBuilder

Line 897: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

893:
894:
895: procedure Retrieve_Dataset(
896: p_commit IN varchar2 := FND_API.G_FALSE
897: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
898: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
899: ,x_return_status OUT NOCOPY varchar2
900: ,x_msg_count OUT NOCOPY number
901: ,x_msg_data OUT NOCOPY varchar2

Line 898: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

894:
895: procedure Retrieve_Dataset(
896: p_commit IN varchar2 := FND_API.G_FALSE
897: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
898: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_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 942: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset ';

938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: WHEN NO_DATA_FOUND THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: IF (x_msg_data IS NOT NULL) THEN
942: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset ';
943: ELSE
944: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset ';
945: END IF;
946: WHEN OTHERS THEN

Line 944: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset ';

940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: IF (x_msg_data IS NOT NULL) THEN
942: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset ';
943: ELSE
944: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset ';
945: END IF;
946: WHEN OTHERS THEN
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: IF (x_msg_data IS NOT NULL) THEN

Line 949: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset ';

945: END IF;
946: WHEN OTHERS THEN
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: IF (x_msg_data IS NOT NULL) THEN
949: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset ';
950: ELSE
951: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset ';
952: END IF;
953: end Retrieve_Dataset;

Line 951: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset ';

947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: IF (x_msg_data IS NOT NULL) THEN
949: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset ';
950: ELSE
951: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset ';
952: END IF;
953: end Retrieve_Dataset;
954:
955: /************************************************************************************

Line 960: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

956: ************************************************************************************/
957: /*
958: procedure Update_Dataset(
959: p_commit IN varchar2 := FND_API.G_FALSE
960: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
961: ,x_return_status OUT NOCOPY varchar2
962: ,x_msg_count OUT NOCOPY number
963: ,x_msg_data OUT NOCOPY varchar2
964: ) is

Line 1002: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: WHEN NO_DATA_FOUND THEN
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: IF (x_msg_data IS NOT NULL) THEN
1002: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1003: ELSE
1004: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1005: END IF;
1006: WHEN OTHERS THEN

Line 1004: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: IF (x_msg_data IS NOT NULL) THEN
1002: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1003: ELSE
1004: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1005: END IF;
1006: WHEN OTHERS THEN
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: IF (x_msg_data IS NOT NULL) THEN

Line 1009: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

1005: END IF;
1006: WHEN OTHERS THEN
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: IF (x_msg_data IS NOT NULL) THEN
1009: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1010: ELSE
1011: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1012: END IF;
1013: end Update_Dataset; */

Line 1011: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: IF (x_msg_data IS NOT NULL) THEN
1009: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1010: ELSE
1011: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1012: END IF;
1013: end Update_Dataset; */
1014:
1015: procedure Update_Dataset(

Line 1017: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1013: end Update_Dataset; */
1014:
1015: procedure Update_Dataset(
1016: p_commit IN varchar2 := FND_API.G_FALSE
1017: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1018: ,p_update_dset_calc IN BOOLEAN
1019: ,x_return_status OUT NOCOPY varchar2
1020: ,x_msg_count OUT NOCOPY number
1021: ,x_msg_data OUT NOCOPY varchar2

Line 1061: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: WHEN NO_DATA_FOUND THEN
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: IF (x_msg_data IS NOT NULL) THEN
1061: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1062: ELSE
1063: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1064: END IF;
1065: WHEN OTHERS THEN

Line 1063: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: IF (x_msg_data IS NOT NULL) THEN
1061: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1062: ELSE
1063: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1064: END IF;
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: IF (x_msg_data IS NOT NULL) THEN

Line 1068: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

1064: END IF;
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: IF (x_msg_data IS NOT NULL) THEN
1068: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1069: ELSE
1070: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1071: END IF;
1072: end Update_Dataset;

Line 1070: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: IF (x_msg_data IS NOT NULL) THEN
1068: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1069: ELSE
1070: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1071: END IF;
1072: end Update_Dataset;
1073:
1074:

Line 1079: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1075:
1076: /****************************/
1077: procedure Update_Dataset(
1078: p_commit IN varchar2 := FND_API.G_FALSE
1079: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1080: ,x_return_status OUT NOCOPY varchar2
1081: ,x_msg_count OUT NOCOPY number
1082: ,x_msg_data OUT NOCOPY varchar2
1083: ) is

Line 1118: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: WHEN NO_DATA_FOUND THEN
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: IF (x_msg_data IS NOT NULL) THEN
1118: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1119: ELSE
1120: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1121: END IF;
1122: WHEN OTHERS THEN

Line 1120: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: IF (x_msg_data IS NOT NULL) THEN
1118: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1119: ELSE
1120: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1121: END IF;
1122: WHEN OTHERS THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: IF (x_msg_data IS NOT NULL) THEN

Line 1125: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';

1121: END IF;
1122: WHEN OTHERS THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: IF (x_msg_data IS NOT NULL) THEN
1125: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1126: ELSE
1127: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1128: END IF;
1129: end Update_Dataset;

Line 1127: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';

1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: IF (x_msg_data IS NOT NULL) THEN
1125: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset ';
1126: ELSE
1127: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset ';
1128: END IF;
1129: end Update_Dataset;
1130:
1131:

Line 1137: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1133: ************************************************************************************/
1134:
1135: procedure Delete_Dataset(
1136: p_commit IN varchar2 := FND_API.G_FALSE
1137: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1138: ,x_return_status OUT NOCOPY varchar2
1139: ,x_msg_count OUT NOCOPY number
1140: ,x_msg_data OUT NOCOPY varchar2
1141: ) is

Line 1183: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';

1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: WHEN NO_DATA_FOUND THEN
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: IF (x_msg_data IS NOT NULL) THEN
1183: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';
1184: ELSE
1185: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';
1186: END IF;
1187: WHEN OTHERS THEN

Line 1185: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';

1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: IF (x_msg_data IS NOT NULL) THEN
1183: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';
1184: ELSE
1185: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';
1186: END IF;
1187: WHEN OTHERS THEN
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF (x_msg_data IS NOT NULL) THEN

Line 1190: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';

1186: END IF;
1187: WHEN OTHERS THEN
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF (x_msg_data IS NOT NULL) THEN
1190: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';
1191: ELSE
1192: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';
1193: END IF;
1194: end Delete_Dataset;

Line 1192: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';

1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189: IF (x_msg_data IS NOT NULL) THEN
1190: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset ';
1191: ELSE
1192: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset ';
1193: END IF;
1194: end Delete_Dataset;
1195:
1196: /************************************************************************************

Line 1205: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1201: --: This procedure is part of the Data Set API.
1202:
1203: procedure Create_Dataset_Calc(
1204: p_commit IN varchar2 := FND_API.G_FALSE
1205: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1206: ,x_return_status OUT NOCOPY varchar2
1207: ,x_msg_count OUT NOCOPY number
1208: ,x_msg_data OUT NOCOPY varchar2
1209: ) is

Line 1211: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

1207: ,x_msg_count OUT NOCOPY number
1208: ,x_msg_data OUT NOCOPY varchar2
1209: ) is
1210:
1211: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1212:
1213: begin
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215: -- Assign all values in the passed "Record" parameter to the locally defined

Line 1256: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset_Calc ';

1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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_DATASETS_PUB.Create_Dataset_Calc ';
1257: ELSE
1258: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset_Calc ';
1259: END IF;
1260: WHEN OTHERS THEN

Line 1258: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset_Calc ';

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_DATASETS_PUB.Create_Dataset_Calc ';
1257: ELSE
1258: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset_Calc ';
1259: END IF;
1260: WHEN OTHERS THEN
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: IF (x_msg_data IS NOT NULL) THEN

Line 1263: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset_Calc ';

1259: END IF;
1260: WHEN OTHERS THEN
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: IF (x_msg_data IS NOT NULL) THEN
1263: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset_Calc ';
1264: ELSE
1265: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset_Calc ';
1266: END IF;
1267: end Create_Dataset_Calc;

Line 1265: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset_Calc ';

1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: IF (x_msg_data IS NOT NULL) THEN
1263: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Create_Dataset_Calc ';
1264: ELSE
1265: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Create_Dataset_Calc ';
1266: END IF;
1267: end Create_Dataset_Calc;
1268:
1269: /************************************************************************************

Line 1274: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1270: ************************************************************************************/
1271:
1272: procedure Retrieve_Dataset_Calc(
1273: p_commit IN varchar2 := FND_API.G_FALSE
1274: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1275: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1276: ,x_return_status OUT NOCOPY varchar2
1277: ,x_msg_count OUT NOCOPY number
1278: ,x_msg_data OUT NOCOPY varchar2

Line 1275: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1271:
1272: procedure Retrieve_Dataset_Calc(
1273: p_commit IN varchar2 := FND_API.G_FALSE
1274: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1275: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1276: ,x_return_status OUT NOCOPY varchar2
1277: ,x_msg_count OUT NOCOPY number
1278: ,x_msg_data OUT NOCOPY varchar2
1279: ) is

Line 1312: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';

1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: WHEN NO_DATA_FOUND THEN
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: IF (x_msg_data IS NOT NULL) THEN
1312: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1313: ELSE
1314: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1315: END IF;
1316: WHEN OTHERS THEN

Line 1314: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';

1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: IF (x_msg_data IS NOT NULL) THEN
1312: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1313: ELSE
1314: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1315: END IF;
1316: WHEN OTHERS THEN
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: IF (x_msg_data IS NOT NULL) THEN

Line 1319: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';

1315: END IF;
1316: WHEN OTHERS THEN
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: IF (x_msg_data IS NOT NULL) THEN
1319: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1320: ELSE
1321: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1322: END IF;
1323: end Retrieve_Dataset_Calc;

Line 1321: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';

1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: IF (x_msg_data IS NOT NULL) THEN
1319: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1320: ELSE
1321: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Retrieve_Dataset_Calc ';
1322: END IF;
1323: end Retrieve_Dataset_Calc;
1324:
1325: /************************************************************************************

Line 1330: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1326: ************************************************************************************/
1327:
1328: procedure Update_Dataset_Calc(
1329: p_commit IN varchar2 := FND_API.G_FALSE
1330: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1331: ,x_return_status OUT NOCOPY varchar2
1332: ,x_msg_count OUT NOCOPY number
1333: ,x_msg_data OUT NOCOPY varchar2
1334: ) is

Line 1366: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';

1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363: WHEN NO_DATA_FOUND THEN
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: IF (x_msg_data IS NOT NULL) THEN
1366: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';
1367: ELSE
1368: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';
1369: END IF;
1370: WHEN OTHERS THEN

Line 1368: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';

1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: IF (x_msg_data IS NOT NULL) THEN
1366: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';
1367: ELSE
1368: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';
1369: END IF;
1370: WHEN OTHERS THEN
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372: IF (x_msg_data IS NOT NULL) THEN

Line 1373: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';

1369: END IF;
1370: WHEN OTHERS THEN
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372: IF (x_msg_data IS NOT NULL) THEN
1373: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';
1374: ELSE
1375: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';
1376: END IF;
1377: end Update_Dataset_Calc;

Line 1375: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';

1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372: IF (x_msg_data IS NOT NULL) THEN
1373: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Update_Dataset_Calc ';
1374: ELSE
1375: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Update_Dataset_Calc ';
1376: END IF;
1377: end Update_Dataset_Calc;
1378:
1379: /************************************************************************************

Line 1384: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1380: ************************************************************************************/
1381:
1382: procedure Delete_Dataset_Calc(
1383: p_commit IN varchar2 := FND_API.G_FALSE
1384: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1385: ,x_return_status OUT NOCOPY varchar2
1386: ,x_msg_count OUT NOCOPY number
1387: ,x_msg_data OUT NOCOPY varchar2
1388: ) is

Line 1420: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';

1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: WHEN NO_DATA_FOUND THEN
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: IF (x_msg_data IS NOT NULL) THEN
1420: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1421: ELSE
1422: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1423: END IF;
1424: WHEN OTHERS THEN

Line 1422: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';

1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: IF (x_msg_data IS NOT NULL) THEN
1420: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1421: ELSE
1422: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1423: END IF;
1424: WHEN OTHERS THEN
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: IF (x_msg_data IS NOT NULL) THEN

Line 1427: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';

1423: END IF;
1424: WHEN OTHERS THEN
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: IF (x_msg_data IS NOT NULL) THEN
1427: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1428: ELSE
1429: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1430: END IF;
1431: end Delete_Dataset_Calc;

Line 1429: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';

1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: IF (x_msg_data IS NOT NULL) THEN
1427: x_msg_data := x_msg_data||' -> BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1428: ELSE
1429: x_msg_data := SQLERRM||' at BSC_DATASETS_PUB.Delete_Dataset_Calc ';
1430: END IF;
1431: end Delete_Dataset_Calc;
1432:
1433: /************************************************************************************

Line 1440: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1436: --=============================================================================
1437: PROCEDURE Translate_Measure
1438: ( p_commit IN VARCHAR2
1439: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1440: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1441: , x_return_status OUT NOCOPY VARCHAR2
1442: , x_msg_count OUT NOCOPY NUMBER
1443: , x_msg_data OUT NOCOPY VARCHAR2
1444: ) IS

Line 1484: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

1480:
1481: -- mdamle 09/25/2003 - Sync up measures for all installed languages
1482: PROCEDURE Translate_Measure_By_Lang
1483: ( p_commit IN VARCHAR2
1484: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1485: , p_lang IN VARCHAR2
1486: , p_source_lang IN VARCHAR2
1487: , x_return_status OUT NOCOPY VARCHAR2
1488: , x_msg_count OUT NOCOPY NUMBER

Line 1619: end BSC_DATASETS_PUB;

1615: WHEN OTHERS THEN
1616: RETURN NULL;
1617: END Get_DataSet_Full_Name;
1618:
1619: end BSC_DATASETS_PUB;