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.BIS_WEIGHTED_MEASURE_PUB dependencies on BIS_WEIGHTED_MEASURE_PUB

Line 1: PACKAGE BODY BIS_WEIGHTED_MEASURE_PUB AS

1: PACKAGE BODY BIS_WEIGHTED_MEASURE_PUB AS
2: /* $Header: BISPWMEB.pls 120.3.12000000.3 2007/02/01 11:09:34 akoduri ship $ */
3: /*======================================================================================+
4: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
5: | All rights reserved. |

Line 121: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';

117: WHEN OTHERS THEN
118: ROLLBACK TO BisDeleteBulkWeightsScores;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: IF (x_msg_data IS NOT NULL) THEN
121: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';
122: ELSE
123: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';
124: END IF;
125: raise;

Line 123: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';

119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: IF (x_msg_data IS NOT NULL) THEN
121: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';
122: ELSE
123: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Bulk_Weights_Scores ';
124: END IF;
125: raise;
126: END Delete_Bulk_Weights_Scores;
127:

Line 228: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';

224: WHEN OTHERS THEN
225: ROLLBACK TO BisDeleteCascadeWMParameters;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF (x_msg_data IS NOT NULL) THEN
228: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';
229: ELSE
230: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';
231: END IF;
232: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 230: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';

226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF (x_msg_data IS NOT NULL) THEN
228: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';
229: ELSE
230: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Cascade_WM_Parameters ';
231: END IF;
232: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
233: raise;
234: END Delete_Cascade_WM_Parameters;

Line 266: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

262: /*******************************************************************
263: *******************************************************************/
264: PROCEDURE Create_WM_Dependency(
265: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
266: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
267: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
268: ,x_return_status OUT NOCOPY VARCHAR2
269: ,x_msg_count OUT NOCOPY NUMBER
270: ,x_msg_data OUT NOCOPY VARCHAR2

Line 267: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

263: *******************************************************************/
264: PROCEDURE Create_WM_Dependency(
265: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
266: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
267: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
268: ,x_return_status OUT NOCOPY VARCHAR2
269: ,x_msg_count OUT NOCOPY NUMBER
270: ,x_msg_data OUT NOCOPY VARCHAR2
271: ) IS

Line 272: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

268: ,x_return_status OUT NOCOPY VARCHAR2
269: ,x_msg_count OUT NOCOPY NUMBER
270: ,x_msg_data OUT NOCOPY VARCHAR2
271: ) IS
272: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
273: BEGIN
274: SAVEPOINT CreateWMDependencyPUB;
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: l_Bis_WM_Rec :=p_Bis_WM_Rec;

Line 348: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';

344: WHEN OTHERS THEN
345: ROLLBACK TO CreateWMDependencyPUB;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: IF (x_msg_data IS NOT NULL) THEN
348: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
349: ELSE
350: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
351: END IF;
352: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 350: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';

346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: IF (x_msg_data IS NOT NULL) THEN
348: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
349: ELSE
350: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
351: END IF;
352: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
353: raise;
354:

Line 361: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

357: /*******************************************************************
358: *******************************************************************/
359: PROCEDURE Retrieve_WM_Dependency(
360: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
361: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
362: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2

Line 362: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

358: *******************************************************************/
359: PROCEDURE Retrieve_WM_Dependency(
360: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
361: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
362: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2
366: ) IS

Line 367: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2
366: ) IS
367: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
368: BEGIN
369: SAVEPOINT Retrieve_WM_Dependency_pub;
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371:

Line 410: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency ';

406: WHEN OTHERS THEN
407: ROLLBACK TO Retrieve_WM_Dependency_pub;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF (x_msg_data IS NOT NULL) THEN
410: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency ';
411: ELSE
412: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency ';
413: END IF;
414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 412: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency ';

408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF (x_msg_data IS NOT NULL) THEN
410: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency ';
411: ELSE
412: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency ';
413: END IF;
414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
415: raise;
416:

Line 423: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

419: /*******************************************************************
420: *******************************************************************/
421: PROCEDURE Update_WM_Dependency(
422: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
423: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
424: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
425: ,x_return_status OUT NOCOPY VARCHAR2
426: ,x_msg_count OUT NOCOPY NUMBER
427: ,x_msg_data OUT NOCOPY VARCHAR2

Line 424: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

420: *******************************************************************/
421: PROCEDURE Update_WM_Dependency(
422: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
423: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
424: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
425: ,x_return_status OUT NOCOPY VARCHAR2
426: ,x_msg_count OUT NOCOPY NUMBER
427: ,x_msg_data OUT NOCOPY VARCHAR2
428: ) IS

Line 429: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

425: ,x_return_status OUT NOCOPY VARCHAR2
426: ,x_msg_count OUT NOCOPY NUMBER
427: ,x_msg_data OUT NOCOPY VARCHAR2
428: ) IS
429: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
430: BEGIN
431: SAVEPOINT bis_Update_WM_Dependency_pub;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:

Line 434: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency(

430: BEGIN
431: SAVEPOINT bis_Update_WM_Dependency_pub;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:
434: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Dependency(
435: p_commit => p_commit
436: ,p_Bis_WM_Rec => p_Bis_WM_Rec
437: ,x_Bis_WM_Rec => l_Bis_WM_Rec
438: ,x_return_status => x_return_status

Line 487: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Dependency ';

483: WHEN OTHERS THEN
484: ROLLBACK TO bis_Update_WM_Dependency_pub;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: IF (x_msg_data IS NOT NULL) THEN
487: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Dependency ';
488: ELSE
489: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Dependency ';
490: END IF;
491: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 489: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Dependency ';

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

Line 499: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

495: /*******************************************************************
496: *******************************************************************/
497: PROCEDURE Delete_WM_Dependency(
498: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
499: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
500: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2

Line 500: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

496: *******************************************************************/
497: PROCEDURE Delete_WM_Dependency(
498: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
499: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
500: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
504: ) IS

Line 505: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
504: ) IS
505: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
506: l_measure_name BIS_DISPLAY_MEASURES_V.name%TYPE;
507:
508: CURSOR c_measure_name IS
509: SELECT V.name

Line 522: ,p_Bis_WM_Rec.dependent_measure_id ) = BIS_WEIGHTED_MEASURE_PUB.G_POSITIVE_WEIGHTS THEN

518:
519: -- Ckeck that Dependent_Measure_id has not Weights Defined
520:
521: IF get_Defined_Weights_Status( p_Bis_WM_Rec.weighted_measure_id
522: ,p_Bis_WM_Rec.dependent_measure_id ) = BIS_WEIGHTED_MEASURE_PUB.G_POSITIVE_WEIGHTS THEN
523:
524: IF(c_measure_name%ISOPEN)THEN
525: CLOSE c_measure_name;
526: END IF;

Line 589: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

585:
586: ROLLBACK TO Delete_WM_Dependency_pub;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF (x_msg_data IS NOT NULL) THEN
589: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
590: ELSE
591: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
592: END IF;
593: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 591: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF (x_msg_data IS NOT NULL) THEN
589: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
590: ELSE
591: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
592: END IF;
593: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
594: raise;
595: END Delete_WM_Dependency;

Line 604: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

600: *******************************************************************/
601:
602: PROCEDURE Create_WM_Definition(
603: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
604: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
605: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
606: ,x_return_status OUT NOCOPY VARCHAR2
607: ,x_msg_count OUT NOCOPY NUMBER
608: ,x_msg_data OUT NOCOPY VARCHAR2

Line 605: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

601:
602: PROCEDURE Create_WM_Definition(
603: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
604: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
605: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
606: ,x_return_status OUT NOCOPY VARCHAR2
607: ,x_msg_count OUT NOCOPY NUMBER
608: ,x_msg_data OUT NOCOPY VARCHAR2
609: ) IS

Line 610: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

606: ,x_return_status OUT NOCOPY VARCHAR2
607: ,x_msg_count OUT NOCOPY NUMBER
608: ,x_msg_data OUT NOCOPY VARCHAR2
609: ) IS
610: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
611: BEGIN
612: SAVEPOINT CreateWMDefinitionPUB;
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614: l_Bis_WM_Rec :=p_Bis_WM_Rec;

Line 661: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;

657: );
658:
659: -- Create tbe Default Paramerer for the definition
660: l_Bis_WM_Rec.weighted_definition_id := x_Bis_WM_Rec.weighted_definition_id;
661: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;
662: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;
663: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
664: p_commit => p_commit
665: ,p_Bis_WM_Rec => l_Bis_WM_Rec

Line 662: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;

658:
659: -- Create tbe Default Paramerer for the definition
660: l_Bis_WM_Rec.weighted_definition_id := x_Bis_WM_Rec.weighted_definition_id;
661: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;
662: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;
663: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
664: p_commit => p_commit
665: ,p_Bis_WM_Rec => l_Bis_WM_Rec
666: ,x_Bis_WM_Rec => x_Bis_WM_Rec

Line 663: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(

659: -- Create tbe Default Paramerer for the definition
660: l_Bis_WM_Rec.weighted_definition_id := x_Bis_WM_Rec.weighted_definition_id;
661: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;
662: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;
663: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
664: p_commit => p_commit
665: ,p_Bis_WM_Rec => l_Bis_WM_Rec
666: ,x_Bis_WM_Rec => x_Bis_WM_Rec
667: ,x_return_status => x_return_status

Line 701: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';

697: WHEN OTHERS THEN
698: ROLLBACK TO CreateWMDefinitionPUB;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF (x_msg_data IS NOT NULL) THEN
701: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
702: ELSE
703: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
704: END IF;
705: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 703: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';

699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF (x_msg_data IS NOT NULL) THEN
701: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
702: ELSE
703: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
704: END IF;
705: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
706: raise;
707: END Create_WM_Definition;

Line 713: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

709: /*******************************************************************
710: *******************************************************************/
711: PROCEDURE Retrieve_WM_Definition(
712: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
713: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
714: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
715: ,x_return_status OUT NOCOPY VARCHAR2
716: ,x_msg_count OUT NOCOPY NUMBER
717: ,x_msg_data OUT NOCOPY VARCHAR2

Line 714: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

710: *******************************************************************/
711: PROCEDURE Retrieve_WM_Definition(
712: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
713: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
714: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
715: ,x_return_status OUT NOCOPY VARCHAR2
716: ,x_msg_count OUT NOCOPY NUMBER
717: ,x_msg_data OUT NOCOPY VARCHAR2
718: ) IS

Line 719: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

715: ,x_return_status OUT NOCOPY VARCHAR2
716: ,x_msg_count OUT NOCOPY NUMBER
717: ,x_msg_data OUT NOCOPY VARCHAR2
718: ) IS
719: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
720: BEGIN
721: SAVEPOINT Retrieve_WM_Definition_pub;
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723:

Line 762: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';

758: WHEN OTHERS THEN
759: ROLLBACK TO Retrieve_WM_Definition_pub;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: IF (x_msg_data IS NOT NULL) THEN
762: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
763: ELSE
764: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
765: END IF;
766: raise;

Line 764: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';

760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: IF (x_msg_data IS NOT NULL) THEN
762: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
763: ELSE
764: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
765: END IF;
766: raise;
767: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
768: END Retrieve_WM_Definition;

Line 774: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

770: /*******************************************************************
771: *******************************************************************/
772: PROCEDURE Update_WM_Definition(
773: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
774: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
775: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
776: ,x_return_status OUT NOCOPY VARCHAR2
777: ,x_msg_count OUT NOCOPY NUMBER
778: ,x_msg_data OUT NOCOPY VARCHAR2

Line 775: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

771: *******************************************************************/
772: PROCEDURE Update_WM_Definition(
773: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
774: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
775: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
776: ,x_return_status OUT NOCOPY VARCHAR2
777: ,x_msg_count OUT NOCOPY NUMBER
778: ,x_msg_data OUT NOCOPY VARCHAR2
779: ) IS

Line 780: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

776: ,x_return_status OUT NOCOPY VARCHAR2
777: ,x_msg_count OUT NOCOPY NUMBER
778: ,x_msg_data OUT NOCOPY VARCHAR2
779: ) IS
780: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
781: l_cascade_delete_flag boolean ;
782:
783: BEGIN
784: SAVEPOINT bis_Update_WM_Definition_pub;

Line 796: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition(

792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: end if;
795:
796: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition(
797: p_commit => p_commit
798: ,p_Bis_WM_Rec => p_Bis_WM_Rec
799: ,x_Bis_WM_Rec => l_Bis_WM_Rec
800: ,x_return_status => x_return_status

Line 870: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;

866: );
867:
868: IF l_cascade_delete_flag = TRUE THEN
869: -- Create tbe Default Parameter Again
870: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;
871: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;
872: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
873: p_commit => p_commit
874: ,p_Bis_WM_Rec => l_Bis_WM_Rec

Line 871: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;

867:
868: IF l_cascade_delete_flag = TRUE THEN
869: -- Create tbe Default Parameter Again
870: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;
871: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;
872: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
873: p_commit => p_commit
874: ,p_Bis_WM_Rec => l_Bis_WM_Rec
875: ,x_Bis_WM_Rec => x_Bis_WM_Rec

Line 872: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(

868: IF l_cascade_delete_flag = TRUE THEN
869: -- Create tbe Default Parameter Again
870: l_Bis_WM_Rec.time_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_TIME_LEVEL_VALUE;
871: l_Bis_WM_Rec.filter_level_value_id := BIS_WEIGHTED_MEASURE_PUB.DEFAULT_FILTER_LEVEL_VALUE;
872: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
873: p_commit => p_commit
874: ,p_Bis_WM_Rec => l_Bis_WM_Rec
875: ,x_Bis_WM_Rec => x_Bis_WM_Rec
876: ,x_return_status => x_return_status

Line 911: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

907: WHEN OTHERS THEN
908: ROLLBACK TO bis_Update_WM_Definition_pub;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: IF (x_msg_data IS NOT NULL) THEN
911: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
912: ELSE
913: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
914: END IF;
915: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 913: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: IF (x_msg_data IS NOT NULL) THEN
911: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
912: ELSE
913: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
914: END IF;
915: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
916: raise;
917: END Update_WM_Definition;

Line 923: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

919: /*******************************************************************
920: *******************************************************************/
921: PROCEDURE Delete_WM_Definition(
922: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
923: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
924: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY NUMBER
927: ,x_msg_data OUT NOCOPY VARCHAR2

Line 924: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

920: *******************************************************************/
921: PROCEDURE Delete_WM_Definition(
922: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
923: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
924: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY NUMBER
927: ,x_msg_data OUT NOCOPY VARCHAR2
928: ) IS

Line 929: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY NUMBER
927: ,x_msg_data OUT NOCOPY VARCHAR2
928: ) IS
929: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
930:
931: BEGIN
932: SAVEPOINT Delete_WM_Definition_pub;
933: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 983: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

979: WHEN OTHERS THEN
980: ROLLBACK TO Delete_WM_Definition_pub;
981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: IF (x_msg_data IS NOT NULL) THEN
983: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
984: ELSE
985: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
986: END IF;
987: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 985: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: IF (x_msg_data IS NOT NULL) THEN
983: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
984: ELSE
985: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
986: END IF;
987: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
988: raise;
989: END Delete_WM_Definition;

Line 997: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

993: /*******************************************************************
994: *******************************************************************/
995: PROCEDURE Create_WM_Parameter(
996: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
997: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
998: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
999: ,x_return_status OUT NOCOPY VARCHAR2
1000: ,x_msg_count OUT NOCOPY NUMBER
1001: ,x_msg_data OUT NOCOPY VARCHAR2

Line 998: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

994: *******************************************************************/
995: PROCEDURE Create_WM_Parameter(
996: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
997: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
998: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
999: ,x_return_status OUT NOCOPY VARCHAR2
1000: ,x_msg_count OUT NOCOPY NUMBER
1001: ,x_msg_data OUT NOCOPY VARCHAR2
1002: ) IS

Line 1003: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

999: ,x_return_status OUT NOCOPY VARCHAR2
1000: ,x_msg_count OUT NOCOPY NUMBER
1001: ,x_msg_data OUT NOCOPY VARCHAR2
1002: ) IS
1003: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1004: l_count NUMBER;
1005: BEGIN
1006: SAVEPOINT CreateWMParameterPUB;
1007: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1080: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';

1076: WHEN OTHERS THEN
1077: ROLLBACK TO CreateWMParameterPUB;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: IF (x_msg_data IS NOT NULL) THEN
1080: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
1081: ELSE
1082: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
1083: END IF;
1084: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1082: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';

1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: IF (x_msg_data IS NOT NULL) THEN
1080: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
1081: ELSE
1082: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
1083: END IF;
1084: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1085: raise;
1086: END Create_WM_Parameter;

Line 1092: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1088: /*******************************************************************
1089: *******************************************************************/
1090: PROCEDURE Retrieve_WM_Parameter(
1091: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1092: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1093: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1094: ,x_return_status OUT NOCOPY VARCHAR2
1095: ,x_msg_count OUT NOCOPY NUMBER
1096: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1093: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1089: *******************************************************************/
1090: PROCEDURE Retrieve_WM_Parameter(
1091: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1092: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1093: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1094: ,x_return_status OUT NOCOPY VARCHAR2
1095: ,x_msg_count OUT NOCOPY NUMBER
1096: ,x_msg_data OUT NOCOPY VARCHAR2
1097: ) IS

Line 1098: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1094: ,x_return_status OUT NOCOPY VARCHAR2
1095: ,x_msg_count OUT NOCOPY NUMBER
1096: ,x_msg_data OUT NOCOPY VARCHAR2
1097: ) IS
1098: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1099: BEGIN
1100: SAVEPOINT Retrieve_WM_Parameter_pub;
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102: BIS_WEIGHTED_MEASURE_PVT.Retrieve_WM_Parameter(

Line 1140: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Parameter ';

1136: WHEN OTHERS THEN
1137: ROLLBACK TO Retrieve_WM_Parameter_pub;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: IF (x_msg_data IS NOT NULL) THEN
1140: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Parameter ';
1141: ELSE
1142: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Parameter ';
1143: END IF;
1144: raise;

Line 1142: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Parameter ';

1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: IF (x_msg_data IS NOT NULL) THEN
1140: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Parameter ';
1141: ELSE
1142: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Parameter ';
1143: END IF;
1144: raise;
1145: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1146: END Retrieve_WM_Parameter;

Line 1152: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1148: /*******************************************************************
1149: *******************************************************************/
1150: PROCEDURE Update_WM_Parameter(
1151: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1152: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1153: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1154: ,x_return_status OUT NOCOPY VARCHAR2
1155: ,x_msg_count OUT NOCOPY NUMBER
1156: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1153: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1149: *******************************************************************/
1150: PROCEDURE Update_WM_Parameter(
1151: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1152: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1153: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1154: ,x_return_status OUT NOCOPY VARCHAR2
1155: ,x_msg_count OUT NOCOPY NUMBER
1156: ,x_msg_data OUT NOCOPY VARCHAR2
1157: ) IS

Line 1158: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1154: ,x_return_status OUT NOCOPY VARCHAR2
1155: ,x_msg_count OUT NOCOPY NUMBER
1156: ,x_msg_data OUT NOCOPY VARCHAR2
1157: ) IS
1158: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1159: BEGIN
1160: SAVEPOINT bis_Update_WM_Parameter_pub;
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162: l_Bis_WM_Rec :=p_Bis_WM_Rec;

Line 1221: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';

1217: WHEN OTHERS THEN
1218: ROLLBACK TO bis_Update_WM_Parameter_pub;
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: IF (x_msg_data IS NOT NULL) THEN
1221: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';
1222: ELSE
1223: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';
1224: END IF;
1225: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1223: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';

1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: IF (x_msg_data IS NOT NULL) THEN
1221: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';
1222: ELSE
1223: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Parameter ';
1224: END IF;
1225: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1226: raise;
1227: END Update_WM_Parameter;

Line 1233: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1229: /*******************************************************************
1230: *******************************************************************/
1231: PROCEDURE Delete_WM_Parameter(
1232: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1233: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1234: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1235: ,x_return_status OUT NOCOPY VARCHAR2
1236: ,x_msg_count OUT NOCOPY NUMBER
1237: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1234: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1230: *******************************************************************/
1231: PROCEDURE Delete_WM_Parameter(
1232: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1233: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1234: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1235: ,x_return_status OUT NOCOPY VARCHAR2
1236: ,x_msg_count OUT NOCOPY NUMBER
1237: ,x_msg_data OUT NOCOPY VARCHAR2
1238: ) IS

Line 1240: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1236: ,x_msg_count OUT NOCOPY NUMBER
1237: ,x_msg_data OUT NOCOPY VARCHAR2
1238: ) IS
1239:
1240: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1241:
1242: -- Cursor to get the Weights associated to the Parameter
1243: CURSOR c_Weights IS
1244: SELECT WEIGHT_ID

Line 1254: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight(

1250:
1251: -- Weights Cascading delete when a Parameter is deleted
1252: FOR CD IN c_Weights LOOP
1253: l_Bis_WM_Rec.weight_id := CD.WEIGHT_ID;
1254: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight(
1255: p_commit => p_commit
1256: ,p_Bis_WM_Rec => l_Bis_WM_Rec
1257: ,x_Bis_WM_Rec => x_Bis_WM_Rec
1258: ,x_return_status => x_return_status

Line 1303: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

1299: WHEN OTHERS THEN
1300: ROLLBACK TO Delete_WM_Parameter_pub;
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: IF (x_msg_data IS NOT NULL) THEN
1303: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
1304: ELSE
1305: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
1306: END IF;
1307: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1305: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: IF (x_msg_data IS NOT NULL) THEN
1303: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
1304: ELSE
1305: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
1306: END IF;
1307: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1308: raise;
1309: END Delete_WM_Parameter;

Line 1317: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1313: /*******************************************************************
1314: *******************************************************************/
1315: PROCEDURE Create_WM_Weight(
1316: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1317: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1318: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1319: ,x_return_status OUT NOCOPY VARCHAR2
1320: ,x_msg_count OUT NOCOPY NUMBER
1321: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1318: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1314: *******************************************************************/
1315: PROCEDURE Create_WM_Weight(
1316: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1317: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1318: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1319: ,x_return_status OUT NOCOPY VARCHAR2
1320: ,x_msg_count OUT NOCOPY NUMBER
1321: ,x_msg_data OUT NOCOPY VARCHAR2
1322: ) IS

Line 1323: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1319: ,x_return_status OUT NOCOPY VARCHAR2
1320: ,x_msg_count OUT NOCOPY NUMBER
1321: ,x_msg_data OUT NOCOPY VARCHAR2
1322: ) IS
1323: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1324: l_count NUMBER;
1325: BEGIN
1326: SAVEPOINT Create_WM_Weight_PUB;
1327: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1403: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';

1399: WHEN OTHERS THEN
1400: ROLLBACK TO Create_WM_Weight_PUB;
1401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1402: IF (x_msg_data IS NOT NULL) THEN
1403: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';
1404: ELSE
1405: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';
1406: END IF;
1407: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1405: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';

1401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1402: IF (x_msg_data IS NOT NULL) THEN
1403: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';
1404: ELSE
1405: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';
1406: END IF;
1407: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1408: raise;
1409: END Create_WM_Weight;

Line 1415: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1411: /*******************************************************************
1412: *******************************************************************/
1413: PROCEDURE Retrieve_WM_Weight(
1414: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1415: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1416: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1417: ,x_return_status OUT NOCOPY VARCHAR2
1418: ,x_msg_count OUT NOCOPY NUMBER
1419: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1416: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1412: *******************************************************************/
1413: PROCEDURE Retrieve_WM_Weight(
1414: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1415: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1416: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1417: ,x_return_status OUT NOCOPY VARCHAR2
1418: ,x_msg_count OUT NOCOPY NUMBER
1419: ,x_msg_data OUT NOCOPY VARCHAR2
1420: ) IS

Line 1421: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1417: ,x_return_status OUT NOCOPY VARCHAR2
1418: ,x_msg_count OUT NOCOPY NUMBER
1419: ,x_msg_data OUT NOCOPY VARCHAR2
1420: ) IS
1421: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1422: BEGIN
1423: SAVEPOINT bis_Retrieve_WM_Weight_pub;
1424: x_return_status := FND_API.G_RET_STS_SUCCESS;
1425: BIS_WEIGHTED_MEASURE_PVT.Retrieve_WM_Weight(

Line 1463: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight ';

1459: WHEN OTHERS THEN
1460: ROLLBACK TO bis_Retrieve_WM_Weight_pub;
1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1462: IF (x_msg_data IS NOT NULL) THEN
1463: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight ';
1464: ELSE
1465: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight ';
1466: END IF;
1467: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1465: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight ';

1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1462: IF (x_msg_data IS NOT NULL) THEN
1463: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight ';
1464: ELSE
1465: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight ';
1466: END IF;
1467: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1468: raise;
1469: END Retrieve_WM_Weight;

Line 1475: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1471: /*******************************************************************
1472: *******************************************************************/
1473: PROCEDURE Update_WM_Weight(
1474: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1475: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1476: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1477: ,x_return_status OUT NOCOPY VARCHAR2
1478: ,x_msg_count OUT NOCOPY NUMBER
1479: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1476: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1472: *******************************************************************/
1473: PROCEDURE Update_WM_Weight(
1474: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1475: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1476: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1477: ,x_return_status OUT NOCOPY VARCHAR2
1478: ,x_msg_count OUT NOCOPY NUMBER
1479: ,x_msg_data OUT NOCOPY VARCHAR2
1480: ) IS

Line 1481: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1477: ,x_return_status OUT NOCOPY VARCHAR2
1478: ,x_msg_count OUT NOCOPY NUMBER
1479: ,x_msg_data OUT NOCOPY VARCHAR2
1480: ) IS
1481: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1482: BEGIN
1483:
1484: SAVEPOINT bis_Update_WM_Weight_pub;
1485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1487: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight(

1483:
1484: SAVEPOINT bis_Update_WM_Weight_pub;
1485: x_return_status := FND_API.G_RET_STS_SUCCESS;
1486:
1487: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Weight(
1488: p_commit => p_commit
1489: ,p_Bis_WM_Rec => p_Bis_WM_Rec
1490: ,x_Bis_WM_Rec => l_Bis_WM_Rec
1491: ,x_return_status => x_return_status

Line 1551: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

1547: WHEN OTHERS THEN
1548: ROLLBACK TO bis_Update_WM_Weight_pub;
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: IF (x_msg_data IS NOT NULL) THEN
1551: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
1552: ELSE
1553: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
1554: END IF;
1555: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1553: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: IF (x_msg_data IS NOT NULL) THEN
1551: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
1552: ELSE
1553: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
1554: END IF;
1555: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1556: raise;
1557: END Update_WM_Weight;

Line 1563: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1559: /*******************************************************************
1560: *******************************************************************/
1561: PROCEDURE Delete_WM_Weight(
1562: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1563: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1564: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1565: ,x_return_status OUT NOCOPY VARCHAR2
1566: ,x_msg_count OUT NOCOPY NUMBER
1567: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1564: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1560: *******************************************************************/
1561: PROCEDURE Delete_WM_Weight(
1562: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1563: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1564: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1565: ,x_return_status OUT NOCOPY VARCHAR2
1566: ,x_msg_count OUT NOCOPY NUMBER
1567: ,x_msg_data OUT NOCOPY VARCHAR2
1568: ) IS

Line 1569: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1565: ,x_return_status OUT NOCOPY VARCHAR2
1566: ,x_msg_count OUT NOCOPY NUMBER
1567: ,x_msg_data OUT NOCOPY VARCHAR2
1568: ) IS
1569: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1570: BEGIN
1571: SAVEPOINT Delete_WM_Weight_pub;
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:

Line 1579: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score(

1575: l_Bis_WM_Rec.weight_id := p_Bis_WM_Rec.weight_id;
1576: l_Bis_WM_Rec.low_range := null;
1577: l_Bis_WM_Rec.high_range := null;
1578:
1579: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score(
1580: p_commit => p_commit
1581: ,p_Bis_WM_Rec => l_Bis_WM_Rec
1582: ,x_Bis_WM_Rec => x_Bis_WM_Rec
1583: ,x_return_status => x_return_status

Line 1628: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

1624: WHEN OTHERS THEN
1625: ROLLBACK TO Delete_WM_Weight_pub;
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: IF (x_msg_data IS NOT NULL) THEN
1628: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
1629: ELSE
1630: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
1631: END IF;
1632: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1630: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: IF (x_msg_data IS NOT NULL) THEN
1628: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
1629: ELSE
1630: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
1631: END IF;
1632: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1633: raise;
1634: END Delete_WM_Weight;

Line 1641: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1637: /*******************************************************************
1638: *******************************************************************/
1639: PROCEDURE Create_WM_Score(
1640: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1641: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1642: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1643: ,x_return_status OUT NOCOPY VARCHAR2
1644: ,x_msg_count OUT NOCOPY NUMBER
1645: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1642: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1638: *******************************************************************/
1639: PROCEDURE Create_WM_Score(
1640: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1641: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1642: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1643: ,x_return_status OUT NOCOPY VARCHAR2
1644: ,x_msg_count OUT NOCOPY NUMBER
1645: ,x_msg_data OUT NOCOPY VARCHAR2
1646: ) IS

Line 1647: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1643: ,x_return_status OUT NOCOPY VARCHAR2
1644: ,x_msg_count OUT NOCOPY NUMBER
1645: ,x_msg_data OUT NOCOPY VARCHAR2
1646: ) IS
1647: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1648: l_count NUMBER;
1649: BEGIN
1650: SAVEPOINT Create_WM_Score_PUB;
1651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1713: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';

1709: WHEN OTHERS THEN
1710: ROLLBACK TO Create_WM_Score_PUB;
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1712: IF (x_msg_data IS NOT NULL) THEN
1713: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
1714: ELSE
1715: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
1716: END IF;
1717: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1715: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';

1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1712: IF (x_msg_data IS NOT NULL) THEN
1713: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
1714: ELSE
1715: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
1716: END IF;
1717: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1718: raise;
1719: END Create_WM_Score;

Line 1725: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1721: /*******************************************************************
1722: *******************************************************************/
1723: PROCEDURE Retrieve_WM_Score(
1724: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1725: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1726: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1727: ,x_return_status OUT NOCOPY VARCHAR2
1728: ,x_msg_count OUT NOCOPY NUMBER
1729: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1726: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1722: *******************************************************************/
1723: PROCEDURE Retrieve_WM_Score(
1724: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1725: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1726: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1727: ,x_return_status OUT NOCOPY VARCHAR2
1728: ,x_msg_count OUT NOCOPY NUMBER
1729: ,x_msg_data OUT NOCOPY VARCHAR2
1730: ) IS

Line 1731: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1727: ,x_return_status OUT NOCOPY VARCHAR2
1728: ,x_msg_count OUT NOCOPY NUMBER
1729: ,x_msg_data OUT NOCOPY VARCHAR2
1730: ) IS
1731: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1732: BEGIN
1733: SAVEPOINT bis_Retrieve_WM_Score_pub;
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735: BIS_WEIGHTED_MEASURE_PVT.Retrieve_WM_Score(

Line 1773: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score ';

1769: WHEN OTHERS THEN
1770: ROLLBACK TO bis_Retrieve_WM_Score_pub;
1771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1772: IF (x_msg_data IS NOT NULL) THEN
1773: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score ';
1774: ELSE
1775: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score ';
1776: END IF;
1777: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1775: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score ';

1771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1772: IF (x_msg_data IS NOT NULL) THEN
1773: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score ';
1774: ELSE
1775: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score ';
1776: END IF;
1777: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1778: raise;
1779: END Retrieve_WM_Score;

Line 1785: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1781: /*******************************************************************
1782: *******************************************************************/
1783: PROCEDURE Update_WM_Score(
1784: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1785: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1786: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1787: ,x_return_status OUT NOCOPY VARCHAR2
1788: ,x_msg_count OUT NOCOPY NUMBER
1789: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1786: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1782: *******************************************************************/
1783: PROCEDURE Update_WM_Score(
1784: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1785: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1786: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1787: ,x_return_status OUT NOCOPY VARCHAR2
1788: ,x_msg_count OUT NOCOPY NUMBER
1789: ,x_msg_data OUT NOCOPY VARCHAR2
1790: ) IS

Line 1791: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1787: ,x_return_status OUT NOCOPY VARCHAR2
1788: ,x_msg_count OUT NOCOPY NUMBER
1789: ,x_msg_data OUT NOCOPY VARCHAR2
1790: ) IS
1791: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1792: BEGIN
1793: SAVEPOINT bis_Update_WM_Score_pub;
1794: x_return_status := FND_API.G_RET_STS_SUCCESS;
1795: l_Bis_WM_Rec :=p_Bis_WM_Rec;

Line 1797: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score(

1793: SAVEPOINT bis_Update_WM_Score_pub;
1794: x_return_status := FND_API.G_RET_STS_SUCCESS;
1795: l_Bis_WM_Rec :=p_Bis_WM_Rec;
1796:
1797: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Score(
1798: p_commit => p_commit
1799: ,p_Bis_WM_Rec => p_Bis_WM_Rec
1800: ,x_Bis_WM_Rec => l_Bis_WM_Rec
1801: ,x_return_status => x_return_status

Line 1860: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';

1856: WHEN OTHERS THEN
1857: ROLLBACK TO bis_Update_WM_Score_pub;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859: IF (x_msg_data IS NOT NULL) THEN
1860: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';
1861: ELSE
1862: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';
1863: END IF;
1864: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1862: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';

1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859: IF (x_msg_data IS NOT NULL) THEN
1860: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';
1861: ELSE
1862: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Score ';
1863: END IF;
1864: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1865: raise;
1866: END Update_WM_Score;

Line 1872: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1868: /*******************************************************************
1869: *******************************************************************/
1870: PROCEDURE Delete_WM_Score(
1871: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1872: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1873: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1874: ,x_return_status OUT NOCOPY VARCHAR2
1875: ,x_msg_count OUT NOCOPY NUMBER
1876: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1873: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec

1869: *******************************************************************/
1870: PROCEDURE Delete_WM_Score(
1871: p_commit IN VARCHAR2 --:= FND_API.G_FALSE
1872: ,p_Bis_WM_Rec IN BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1873: ,x_Bis_WM_Rec OUT NOCOPY BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec
1874: ,x_return_status OUT NOCOPY VARCHAR2
1875: ,x_msg_count OUT NOCOPY NUMBER
1876: ,x_msg_data OUT NOCOPY VARCHAR2
1877: ) IS

Line 1878: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1874: ,x_return_status OUT NOCOPY VARCHAR2
1875: ,x_msg_count OUT NOCOPY NUMBER
1876: ,x_msg_data OUT NOCOPY VARCHAR2
1877: ) IS
1878: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1879: BEGIN
1880: SAVEPOINT Delete_WM_Score_pub;
1881: x_return_status := FND_API.G_RET_STS_SUCCESS;
1882: BIS_WEIGHTED_MEASURE_PVT.Delete_WM_Score(

Line 1920: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

1916: WHEN OTHERS THEN
1917: ROLLBACK TO Delete_WM_Score_pub;
1918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1919: IF (x_msg_data IS NOT NULL) THEN
1920: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
1921: ELSE
1922: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
1923: END IF;
1924: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1922: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

1918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1919: IF (x_msg_data IS NOT NULL) THEN
1920: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
1921: ELSE
1922: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
1923: END IF;
1924: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1925: raise;
1926: END Delete_WM_Score;

Line 1948: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1944: ,x_return_status OUT NOCOPY VARCHAR2
1945: ,x_msg_count OUT NOCOPY NUMBER
1946: ,x_msg_data OUT NOCOPY VARCHAR2
1947: ) IS
1948: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1949: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1950:
1951: BEGIN
1952: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE

Line 1949: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

1945: ,x_msg_count OUT NOCOPY NUMBER
1946: ,x_msg_data OUT NOCOPY VARCHAR2
1947: ) IS
1948: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1949: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
1950:
1951: BEGIN
1952: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE
1953: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1965: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition(

1961: l_Bis_WM_Rec.time_dimension_short_name := p_time_dimension_sn;
1962: l_Bis_WM_Rec.time_dim_level_short_name := p_time_dim_level_sn;
1963:
1964: -- Create Definition
1965: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition(
1966: p_commit => p_commit
1967: ,p_Bis_WM_Rec => l_Bis_WM_Rec
1968: ,x_Bis_WM_Rec => x_Bis_WM_Rec
1969: ,x_return_status => x_return_status

Line 1999: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';

1995: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1996: WHEN OTHERS THEN
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1998: IF (x_msg_data IS NOT NULL) THEN
1999: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
2000: ELSE
2001: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
2002: END IF;
2003: END Create_WM_Definition;

Line 2001: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';

1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1998: IF (x_msg_data IS NOT NULL) THEN
1999: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
2000: ELSE
2001: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition ';
2002: END IF;
2003: END Create_WM_Definition;
2004:
2005: /*******************************************************************

Line 2020: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2016: ,x_return_status OUT NOCOPY VARCHAR2
2017: ,x_msg_count OUT NOCOPY NUMBER
2018: ,x_msg_data OUT NOCOPY VARCHAR2
2019: ) IS
2020: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2021: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2022: BEGIN
2023: x_return_status := FND_API.G_RET_STS_SUCCESS;
2024:

Line 2021: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2017: ,x_msg_count OUT NOCOPY NUMBER
2018: ,x_msg_data OUT NOCOPY VARCHAR2
2019: ) IS
2020: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2021: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2022: BEGIN
2023: x_return_status := FND_API.G_RET_STS_SUCCESS;
2024:
2025: l_Bis_WM_Rec.weighted_definition_id := p_weighted_definition_id;

Line 2027: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition(

2023: x_return_status := FND_API.G_RET_STS_SUCCESS;
2024:
2025: l_Bis_WM_Rec.weighted_definition_id := p_weighted_definition_id;
2026:
2027: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition(
2028: p_commit => NULL
2029: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2030: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2031: ,x_return_status => x_return_status

Line 2068: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';

2064: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2065: WHEN OTHERS THEN
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: IF (x_msg_data IS NOT NULL) THEN
2068: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
2069: ELSE
2070: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
2071: END IF;
2072: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2070: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';

2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: IF (x_msg_data IS NOT NULL) THEN
2068: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
2069: ELSE
2070: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition ';
2071: END IF;
2072: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2073: END Retrieve_WM_Definition;
2074:

Line 2092: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2088: ,x_msg_count OUT NOCOPY NUMBER
2089: ,x_msg_data OUT NOCOPY VARCHAR2
2090:
2091: ) IS
2092: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2093: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2094:
2095: BEGIN
2096: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2093: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2089: ,x_msg_data OUT NOCOPY VARCHAR2
2090:
2091: ) IS
2092: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2093: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2094:
2095: BEGIN
2096: x_return_status := FND_API.G_RET_STS_SUCCESS;
2097:

Line 2108: BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition(

2104: l_Bis_WM_Rec.time_dimension_short_name := p_time_dimension_sn;
2105: l_Bis_WM_Rec.time_dim_level_short_name := p_time_dim_level_sn;
2106:
2107: -- Update the Weighted Measure Definition
2108: BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition(
2109: p_commit => p_commit
2110: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2111: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2112: ,x_return_status => x_return_status

Line 2146: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

2142: WHEN OTHERS THEN
2143: ROLLBACK TO bis_Update_WM_Definition_pub;
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: IF (x_msg_data IS NOT NULL) THEN
2146: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
2147: ELSE
2148: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
2149: END IF;
2150: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2148: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';

2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: IF (x_msg_data IS NOT NULL) THEN
2146: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
2147: ELSE
2148: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Definition ';
2149: END IF;
2150: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2151: raise;
2152: END Update_WM_Definition;

Line 2163: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2159: ,x_return_status OUT NOCOPY VARCHAR2
2160: ,x_msg_count OUT NOCOPY NUMBER
2161: ,x_msg_data OUT NOCOPY VARCHAR2
2162: ) IS
2163: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2164: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2165:
2166: BEGIN
2167: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE

Line 2164: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2160: ,x_msg_count OUT NOCOPY NUMBER
2161: ,x_msg_data OUT NOCOPY VARCHAR2
2162: ) IS
2163: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2164: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2165:
2166: BEGIN
2167: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE
2168: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2172: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition(

2168: x_return_status := FND_API.G_RET_STS_SUCCESS;
2169:
2170: l_Bis_WM_Rec.weighted_definition_id := p_weighted_definition_id;
2171:
2172: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition(
2173: p_commit => p_commit
2174: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2175: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2176: ,x_return_status => x_return_status

Line 2205: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

2201: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2202: WHEN OTHERS THEN
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2204: IF (x_msg_data IS NOT NULL) THEN
2205: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
2206: ELSE
2207: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
2208: END IF;
2209: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2207: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';

2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2204: IF (x_msg_data IS NOT NULL) THEN
2205: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
2206: ELSE
2207: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition ';
2208: END IF;
2209: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2210: END Delete_WM_Definition;
2211:

Line 2223: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2219: ,x_return_status OUT NOCOPY VARCHAR2
2220: ,x_msg_count OUT NOCOPY NUMBER
2221: ,x_msg_data OUT NOCOPY VARCHAR2
2222: ) IS
2223: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2224: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2225: BEGIN
2226: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE
2227:

Line 2224: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2220: ,x_msg_count OUT NOCOPY NUMBER
2221: ,x_msg_data OUT NOCOPY VARCHAR2
2222: ) IS
2223: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2224: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2225: BEGIN
2226: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE
2227:
2228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2233: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency(

2229:
2230: l_Bis_WM_Rec.weighted_measure_id := p_weighted_measure_id;
2231: l_Bis_WM_Rec.dependent_measure_id := p_dependent_measure_id;
2232:
2233: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency(
2234: p_commit => p_commit
2235: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2236: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2237: ,x_return_status => x_return_status

Line 2266: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';

2262: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2263: WHEN OTHERS THEN
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: IF (x_msg_data IS NOT NULL) THEN
2266: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
2267: ELSE
2268: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
2269: END IF;
2270: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2268: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';

2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: IF (x_msg_data IS NOT NULL) THEN
2266: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
2267: ELSE
2268: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency ';
2269: END IF;
2270: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2271:
2272: END Create_WM_Dependency;

Line 2285: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2281: ,x_return_status OUT NOCOPY VARCHAR2
2282: ,x_msg_count OUT NOCOPY NUMBER
2283: ,x_msg_data OUT NOCOPY VARCHAR2
2284: ) IS
2285: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2286: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2287: BEGIN
2288: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE
2289: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2286: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2282: ,x_msg_count OUT NOCOPY NUMBER
2283: ,x_msg_data OUT NOCOPY VARCHAR2
2284: ) IS
2285: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2286: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2287: BEGIN
2288: -- THIS IS JUST A WRAPPER PLEASE DO NOT ADD ANY BUSINESS LOGIC TO THIS PROCEDURE
2289: x_return_status := FND_API.G_RET_STS_SUCCESS;
2290: l_Bis_WM_Rec.weighted_measure_id := p_weighted_measure_id;

Line 2294: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency(

2290: l_Bis_WM_Rec.weighted_measure_id := p_weighted_measure_id;
2291: l_Bis_WM_Rec.dependent_measure_id := p_dependent_measure_id;
2292:
2293: -- Delete the Dependent Measure
2294: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency(
2295: p_commit => p_commit
2296: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2297: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2298: ,x_return_status => x_return_status

Line 2327: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

2323: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2324: WHEN OTHERS THEN
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2326: IF (x_msg_data IS NOT NULL) THEN
2327: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
2328: ELSE
2329: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
2330: END IF;
2331: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2329: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';

2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2326: IF (x_msg_data IS NOT NULL) THEN
2327: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
2328: ELSE
2329: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency ';
2330: END IF;
2331: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2332: END Delete_WM_Dependency;
2333:

Line 2345: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2341: ,x_return_status OUT NOCOPY VARCHAR2
2342: ,x_msg_count OUT NOCOPY NUMBER
2343: ,x_msg_data OUT NOCOPY VARCHAR2
2344: ) IS
2345: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2346: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2347: BEGIN
2348: SAVEPOINT CreateWMParameterPUB;
2349: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2346: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2342: ,x_msg_count OUT NOCOPY NUMBER
2343: ,x_msg_data OUT NOCOPY VARCHAR2
2344: ) IS
2345: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2346: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2347: BEGIN
2348: SAVEPOINT CreateWMParameterPUB;
2349: x_return_status := FND_API.G_RET_STS_SUCCESS;
2350:

Line 2356: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(

2352: l_Bis_WM_Rec.weighted_definition_id := p_weighted_definition_id;
2353: l_Bis_WM_Rec.time_level_value_id := p_time_level_value_id;
2354: l_Bis_WM_Rec.filter_level_value_id := p_filter_level_value_id;
2355:
2356: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter(
2357: p_commit => p_commit
2358: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2359: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2360: ,x_return_status => x_return_status

Line 2391: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';

2387: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF (x_msg_data IS NOT NULL) THEN
2391: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
2392: ELSE
2393: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
2394: END IF;
2395: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2393: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';

2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF (x_msg_data IS NOT NULL) THEN
2391: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
2392: ELSE
2393: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Parameter ';
2394: END IF;
2395: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2396: END Create_WM_Parameter;
2397:

Line 2408: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2404: ,x_msg_count OUT NOCOPY NUMBER
2405: ,x_msg_data OUT NOCOPY VARCHAR2
2406: ) IS
2407:
2408: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2409: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2410:
2411: BEGIN
2412: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2409: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2405: ,x_msg_data OUT NOCOPY VARCHAR2
2406: ) IS
2407:
2408: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2409: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2410:
2411: BEGIN
2412: x_return_status := FND_API.G_RET_STS_SUCCESS;
2413:

Line 2417: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter(

2413:
2414: l_Bis_WM_Rec.weighted_parameter_id := p_weighted_parameter_id;
2415:
2416: -- Delete the Parameter
2417: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter(
2418: p_commit => p_commit
2419: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2420: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2421: ,x_return_status => x_return_status

Line 2455: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

2451: WHEN OTHERS THEN
2452: ROLLBACK TO Delete_WM_Parameter_pub;
2453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2454: IF (x_msg_data IS NOT NULL) THEN
2455: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
2456: ELSE
2457: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
2458: END IF;
2459: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2457: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';

2453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2454: IF (x_msg_data IS NOT NULL) THEN
2455: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
2456: ELSE
2457: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Parameter ';
2458: END IF;
2459: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2460: raise;
2461: END Delete_WM_Parameter;

Line 2478: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2474: ,x_return_status OUT NOCOPY VARCHAR2
2475: ,x_msg_count OUT NOCOPY NUMBER
2476: ,x_msg_data OUT NOCOPY VARCHAR2
2477: ) IS
2478: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2479: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2480: BEGIN
2481: x_return_status := FND_API.G_RET_STS_SUCCESS;
2482:

Line 2479: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2475: ,x_msg_count OUT NOCOPY NUMBER
2476: ,x_msg_data OUT NOCOPY VARCHAR2
2477: ) IS
2478: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2479: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2480: BEGIN
2481: x_return_status := FND_API.G_RET_STS_SUCCESS;
2482:
2483: l_Bis_WM_Rec.weight_id := p_weight_id;

Line 2488: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight(

2484: l_Bis_WM_Rec.weighted_parameter_id := p_weighted_parameter_id;
2485: l_Bis_WM_Rec.dependent_measure_id := p_dependent_measure_id;
2486: l_Bis_WM_Rec.weight := p_weight;
2487:
2488: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight(
2489: p_commit => p_commit
2490: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2491: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2492: ,x_return_status => x_return_status

Line 2523: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';

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

Line 2525: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';

2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2522: IF (x_msg_data IS NOT NULL) THEN
2523: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';
2524: ELSE
2525: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Weight ';
2526: END IF;
2527: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2528: END Create_WM_Weight;
2529:

Line 2540: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2536: ,x_return_status OUT NOCOPY VARCHAR2
2537: ,x_msg_count OUT NOCOPY NUMBER
2538: ,x_msg_data OUT NOCOPY VARCHAR2
2539: ) IS
2540: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2541: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2542: BEGIN
2543: x_return_status := FND_API.G_RET_STS_SUCCESS;
2544:

Line 2541: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2537: ,x_msg_count OUT NOCOPY NUMBER
2538: ,x_msg_data OUT NOCOPY VARCHAR2
2539: ) IS
2540: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2541: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2542: BEGIN
2543: x_return_status := FND_API.G_RET_STS_SUCCESS;
2544:
2545: l_Bis_WM_Rec.weight_id := p_weight_id;

Line 2548: BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight(

2544:
2545: l_Bis_WM_Rec.weight_id := p_weight_id;
2546: l_Bis_WM_Rec.weight := p_weight;
2547:
2548: BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight(
2549: p_commit => p_commit
2550: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2551: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2552: ,x_return_status => x_return_status

Line 2586: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

2582: WHEN OTHERS THEN
2583: ROLLBACK TO bis_Update_WM_Weight_pub;
2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2585: IF (x_msg_data IS NOT NULL) THEN
2586: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
2587: ELSE
2588: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
2589: END IF;
2590: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2588: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';

2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2585: IF (x_msg_data IS NOT NULL) THEN
2586: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
2587: ELSE
2588: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Weight ';
2589: END IF;
2590: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2591: raise;
2592: END Update_WM_Weight;

Line 2603: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2599: ,x_return_status OUT NOCOPY VARCHAR2
2600: ,x_msg_count OUT NOCOPY NUMBER
2601: ,x_msg_data OUT NOCOPY VARCHAR2
2602: ) IS
2603: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2604: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2605: BEGIN
2606: SAVEPOINT Delete_WM_Weight_pub;
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2604: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2600: ,x_msg_count OUT NOCOPY NUMBER
2601: ,x_msg_data OUT NOCOPY VARCHAR2
2602: ) IS
2603: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2604: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2605: BEGIN
2606: SAVEPOINT Delete_WM_Weight_pub;
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608:

Line 2611: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight(

2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608:
2609: l_Bis_WM_Rec.weight_id := p_weight_id;
2610: -- Delete the Weight
2611: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight(
2612: p_commit => p_commit
2613: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2614: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2615: ,x_return_status => x_return_status

Line 2644: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

2640: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2641: WHEN OTHERS THEN
2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2643: IF (x_msg_data IS NOT NULL) THEN
2644: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
2645: ELSE
2646: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
2647: END IF;
2648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2646: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';

2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2643: IF (x_msg_data IS NOT NULL) THEN
2644: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
2645: ELSE
2646: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Weight ';
2647: END IF;
2648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2649: END Delete_WM_Weight;
2650:

Line 2661: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2657: ,x_return_status OUT NOCOPY VARCHAR2
2658: ,x_msg_count OUT NOCOPY NUMBER
2659: ,x_msg_data OUT NOCOPY VARCHAR2
2660: ) IS
2661: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2662: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2663: BEGIN
2664: SAVEPOINT Create_WM_Score_PUB;
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2662: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2658: ,x_msg_count OUT NOCOPY NUMBER
2659: ,x_msg_data OUT NOCOPY VARCHAR2
2660: ) IS
2661: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2662: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2663: BEGIN
2664: SAVEPOINT Create_WM_Score_PUB;
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;
2666:

Line 2672: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score(

2668: l_Bis_WM_Rec.low_range := p_low_range;
2669: l_Bis_WM_Rec.high_range := p_high_range;
2670: l_Bis_WM_Rec.score := p_score;
2671:
2672: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score(
2673: p_commit => p_commit
2674: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2675: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2676: ,x_return_status => x_return_status

Line 2705: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';

2701: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2702: WHEN OTHERS THEN
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2704: IF (x_msg_data IS NOT NULL) THEN
2705: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
2706: ELSE
2707: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
2708: END IF;
2709: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2707: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';

2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2704: IF (x_msg_data IS NOT NULL) THEN
2705: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
2706: ELSE
2707: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_WM_Score ';
2708: END IF;
2709: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2710: END Create_WM_Score;
2711:

Line 2721: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2717: ,x_return_status OUT NOCOPY VARCHAR2
2718: ,x_msg_count OUT NOCOPY NUMBER
2719: ,x_msg_data OUT NOCOPY VARCHAR2
2720: ) IS
2721: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2722: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2723: BEGIN
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725:

Line 2722: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2718: ,x_msg_count OUT NOCOPY NUMBER
2719: ,x_msg_data OUT NOCOPY VARCHAR2
2720: ) IS
2721: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2722: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2723: BEGIN
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725:
2726: l_Bis_WM_Rec.weight_id := p_weight_id;

Line 2728: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score(

2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725:
2726: l_Bis_WM_Rec.weight_id := p_weight_id;
2727:
2728: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score(
2729: p_commit => p_commit
2730: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2731: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2732: ,x_return_status => x_return_status

Line 2761: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

2757: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2758: WHEN OTHERS THEN
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: IF (x_msg_data IS NOT NULL) THEN
2761: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
2762: ELSE
2763: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
2764: END IF;
2765: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2763: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';

2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: IF (x_msg_data IS NOT NULL) THEN
2761: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
2762: ELSE
2763: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Score ';
2764: END IF;
2765: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2766: END Delete_WM_Score;
2767:

Line 2900: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2896: ,x_return_status OUT NOCOPY VARCHAR2
2897: ,x_msg_count OUT NOCOPY NUMBER
2898: ,x_msg_data OUT NOCOPY VARCHAR2
2899: ) IS
2900: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2901: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2902:
2903: -- Cursor to get the Weighted Parameters associated to the Weighted Definition
2904: CURSOR c_WM_Definitions IS

Line 2901: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

2897: ,x_msg_count OUT NOCOPY NUMBER
2898: ,x_msg_data OUT NOCOPY VARCHAR2
2899: ) IS
2900: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2901: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
2902:
2903: -- Cursor to get the Weighted Parameters associated to the Weighted Definition
2904: CURSOR c_WM_Definitions IS
2905: SELECT WEIGHTED_DEFINITION_ID

Line 2922: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency(

2918: -- Dependent Measures Cascading delete when the Weighted Measure is deleted
2919: FOR CD IN c_WM_Dependent LOOP
2920: l_Bis_WM_Rec.weighted_measure_id := p_weighted_measure_id;
2921: l_Bis_WM_Rec.dependent_measure_id := CD.DEPENDENT_MEASURE_ID;
2922: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Dependency(
2923: p_commit => FND_API.G_FALSE
2924: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2925: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2926: ,x_return_status => x_return_status

Line 2936: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition(

2932: -- Definitions Cascading delete when the Weighted Measure is deleted
2933: FOR CD IN c_WM_Definitions LOOP
2934: l_Bis_WM_Rec.weighted_measure_id := p_weighted_measure_id;
2935: l_Bis_WM_Rec.weighted_definition_id := CD.WEIGHTED_DEFINITION_ID;
2936: BIS_WEIGHTED_MEASURE_PUB.Delete_WM_Definition(
2937: p_commit => FND_API.G_FALSE
2938: ,p_Bis_WM_Rec => l_Bis_WM_Rec
2939: ,x_Bis_WM_Rec => x_Bis_WM_Rec
2940: ,x_return_status => x_return_status

Line 2979: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';

2975: WHEN OTHERS THEN
2976: ROLLBACK TO Delete_WM_Definition_pub;
2977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2978: IF (x_msg_data IS NOT NULL) THEN
2979: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';
2980: ELSE
2981: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';
2982: END IF;
2983: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2981: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';

2977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2978: IF (x_msg_data IS NOT NULL) THEN
2979: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';
2980: ELSE
2981: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Weighted_Measure_data ';
2982: END IF;
2983: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2984: -- raise;
2985: END Delete_Weighted_Measure_data;

Line 3004: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

3000: ,x_msg_count OUT NOCOPY NUMBER
3001: ,x_msg_data OUT NOCOPY VARCHAR2
3002: ) IS
3003:
3004: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
3005: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
3006:
3007: l_dependent_measure_ids VARCHAR2(3000);
3008: l_dependent_measure_id NUMBER;

Line 3005: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;

3001: ,x_msg_data OUT NOCOPY VARCHAR2
3002: ) IS
3003:
3004: l_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
3005: x_Bis_WM_Rec BIS_WEIGHTED_MEASURE_PUB.Bis_WM_Rec;
3006:
3007: l_dependent_measure_ids VARCHAR2(3000);
3008: l_dependent_measure_id NUMBER;
3009: l_time_dim_level_short_names VARCHAR2 (6000);

Line 3050: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition(

3046: --DBMS_OUTPUT.PUT_LINE('l_Bis_WM_Rec.filter_dim_level_sn = ' || l_Bis_WM_Rec.filter_dim_level_sn);
3047: --DBMS_OUTPUT.PUT_LINE('l_Bis_WM_Rec.time_dimension_short_name = ' || l_Bis_WM_Rec.time_dimension_short_name);
3048: --DBMS_OUTPUT.PUT_LINE('l_Bis_WM_Rec.time_dim_level_short_name = ' || l_Bis_WM_Rec.time_dim_level_short_name);
3049:
3050: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Definition(
3051: p_commit => FND_API.G_FALSE
3052: ,p_Bis_WM_Rec => l_Bis_WM_Rec
3053: ,x_Bis_WM_Rec => x_Bis_WM_Rec
3054: ,x_return_status => x_return_status

Line 3071: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency(

3067:
3068: --DBMS_OUTPUT.PUT_LINE('l_Bis_WM_Rec.weighted_measure_id' || l_Bis_WM_Rec.weighted_measure_id);
3069: --DBMS_OUTPUT.PUT_LINE('l_dependent_measure_id = '||l_dependent_measure_id);
3070:
3071: BIS_WEIGHTED_MEASURE_PUB.Create_WM_Dependency(
3072: p_commit => FND_API.G_FALSE
3073: ,p_Bis_WM_Rec => l_Bis_WM_Rec
3074: ,x_Bis_WM_Rec => x_Bis_WM_Rec
3075: ,x_return_status => x_return_status

Line 3139: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_Weighted_Measure_data ';

3135: WHEN OTHERS THEN
3136: ROLLBACK TO BisCreateWeightedMeasure;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: IF (x_msg_data IS NOT NULL) THEN
3139: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_Weighted_Measure_data ';
3140: ELSE
3141: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_Weighted_Measure_data ';
3142: END IF;
3143: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3141: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_Weighted_Measure_data ';

3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: IF (x_msg_data IS NOT NULL) THEN
3139: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Create_Weighted_Measure_data ';
3140: ELSE
3141: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Create_Weighted_Measure_data ';
3142: END IF;
3143: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3144: -- raise;
3145: END Create_Weighted_Measure_data;

Line 3334: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Set_Weight_Data ';

3330: WHEN OTHERS THEN
3331: ROLLBACK TO BisSetWeightDataPUB1;
3332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3333: IF (x_msg_data IS NOT NULL) THEN
3334: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Set_Weight_Data ';
3335: ELSE
3336: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Set_Weight_Data ';
3337: END IF;
3338: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3336: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Set_Weight_Data ';

3332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3333: IF (x_msg_data IS NOT NULL) THEN
3334: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Set_Weight_Data ';
3335: ELSE
3336: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Set_Weight_Data ';
3337: END IF;
3338: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3339: -- raise;
3340: END Set_Weight_Data;

Line 3375: BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info(

3371: x_msg_data => x_msg_data);
3372:
3373: END LOOP;
3374:
3375: BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info(
3376: p_commit => p_commit
3377: ,p_Weighted_Measure_Id => p_weighted_measure_id
3378: ,x_return_status => x_return_status
3379: ,x_msg_count => x_msg_count

Line 3489: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';

3485: WHEN OTHERS THEN
3486: ROLLBACK TO Update_WM_LU_Info_pub;
3487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3488: IF (x_msg_data IS NOT NULL) THEN
3489: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';
3490: ELSE
3491: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';
3492: END IF;
3493: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3491: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';

3487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3488: IF (x_msg_data IS NOT NULL) THEN
3489: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';
3490: ELSE
3491: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Update_WM_Last_Update_Info ';
3492: END IF;
3493: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3494: raise;
3495: END Update_WM_Last_Update_Info;

Line 3579: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';

3575: WHEN OTHERS THEN
3576: ROLLBACK TO Bis_Delete_Mass_Update_Data;
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578: IF (x_msg_data IS NOT NULL) THEN
3579: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';
3580: ELSE
3581: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';
3582: END IF;
3583: END Delete_Mass_Update_Data;

Line 3581: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';

3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578: IF (x_msg_data IS NOT NULL) THEN
3579: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';
3580: ELSE
3581: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Delete_Mass_Update_Data ';
3582: END IF;
3583: END Delete_Mass_Update_Data;
3584:
3585: /************************************************************************************

Line 3793: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data ';

3789: WHEN OTHERS THEN
3790: ROLLBACK TO SAVE_Insert_Mass_Update_Data;
3791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3792: IF (x_msg_data IS NOT NULL) THEN
3793: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data ';
3794: ELSE
3795: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data';
3796: END IF;
3797: END Insert_Mass_Update_Data;

Line 3795: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data';

3791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3792: IF (x_msg_data IS NOT NULL) THEN
3793: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data ';
3794: ELSE
3795: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Insert_Mass_Update_Data';
3796: END IF;
3797: END Insert_Mass_Update_Data;
3798:
3799: /************************************************************************************

Line 3895: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';

3891: WHEN OTHERS THEN
3892: ROLLBACK TO BisSave_Mass_Update_Values_Pub;
3893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3894: IF (x_msg_data IS NOT NULL) THEN
3895: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';
3896: ELSE
3897: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';
3898: END IF;
3899: END Save_Mass_Update_Values;

Line 3897: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';

3893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3894: IF (x_msg_data IS NOT NULL) THEN
3895: x_msg_data := x_msg_data||' -> BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';
3896: ELSE
3897: x_msg_data := SQLERRM||' at BIS_WEIGHTED_MEASURE_PUB.Save_Mass_Update_Values ';
3898: END IF;
3899: END Save_Mass_Update_Values;
3900:
3901: /************************************************************************************

Line 3963: END BIS_WEIGHTED_MEASURE_PUB;

3959: WHEN OTHERS THEN
3960: x_Param_Count := 0;
3961: END Validate_Overwrite_Scores;
3962:
3963: END BIS_WEIGHTED_MEASURE_PUB;