[Home] [Help]
168: PROCEDURE Load_Measure_Extension
169: ( p_api_version IN NUMBER
170: , p_commit IN VARCHAR2 := FND_API.G_FALSE
171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
172: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
175: );
176:
170: , p_commit IN VARCHAR2 := FND_API.G_FALSE
171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
172: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
175: );
176:
177:
178: FUNCTION Get_Measure_Id_From_Short_Name
306: Procedure Create_Indicator_Dimension
307: ( p_Measure_id number
308: , p_dimension_id number
309: , p_sequence_no number
310: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
311: , x_return_status OUT NOCOPY VARCHAR2
312: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
313: )
314: is
308: , p_dimension_id number
309: , p_sequence_no number
310: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
311: , x_return_status OUT NOCOPY VARCHAR2
312: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
313: )
314: is
315: l_user_id number;
316: l_login_id number;
313: )
314: is
315: l_user_id number;
316: l_login_id number;
317: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
318: BEGIN
319:
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: if (BIS_UTILITIES_PUB.Value_Missing(p_dimension_id) = FND_API.G_TRUE) then
317: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
318: BEGIN
319:
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: if (BIS_UTILITIES_PUB.Value_Missing(p_dimension_id) = FND_API.G_TRUE) then
322: return;
323: end if;
324:
325: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
321: if (BIS_UTILITIES_PUB.Value_Missing(p_dimension_id) = FND_API.G_TRUE) then
322: return;
323: end if;
324:
325: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
326:
327: l_login_id := fnd_global.LOGIN_ID;
328:
329: insert into bis_indicator_dimensions
376: end Create_Indicator_Dimension;
377:
378: PROCEDURE Create_Indicator_Dimensions
379: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
380: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
378: PROCEDURE Create_Indicator_Dimensions
379: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
380: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
385: l_id NUMBER := p_Measure_rec.Measure_Id;
386: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
385: l_id NUMBER := p_Measure_rec.Measure_Id;
386: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
387: BEGIN
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
387: BEGIN
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
392: = FND_API.G_FALSE
393: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension1_id)
394: = FND_API.G_FALSE) then
395:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
392: = FND_API.G_FALSE
393: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension1_id)
394: = FND_API.G_FALSE) then
395:
396: Create_Indicator_Dimension( l_id
397: , p_Measure_Rec.Dimension1_Id
400: , x_return_status
401: , x_error_tbl
402: );
403:
404: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
405: = FND_API.G_FALSE
406: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension2_id)
407: = FND_API.G_FALSE) then
408:
402: );
403:
404: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
405: = FND_API.G_FALSE
406: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension2_id)
407: = FND_API.G_FALSE) then
408:
409: Create_Indicator_Dimension( l_id
410: , p_Measure_Rec.Dimension2_Id
413: , x_return_status
414: , x_error_tbl
415: );
416:
417: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
418: = FND_API.G_FALSE
419: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension3_id)
420: = FND_API.G_FALSE) then
421: Create_Indicator_Dimension( l_id
415: );
416:
417: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
418: = FND_API.G_FALSE
419: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension3_id)
420: = FND_API.G_FALSE) then
421: Create_Indicator_Dimension( l_id
422: , p_Measure_Rec.Dimension3_Id
423: , 3
425: , x_return_status
426: , x_error_tbl
427: );
428:
429: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
430: = FND_API.G_FALSE
431: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension4_id)
432: = FND_API.G_FALSE) then
433: Create_Indicator_Dimension( l_id
427: );
428:
429: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
430: = FND_API.G_FALSE
431: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension4_id)
432: = FND_API.G_FALSE) then
433: Create_Indicator_Dimension( l_id
434: , p_Measure_Rec.Dimension4_Id
435: , 4
437: , x_return_status
438: , x_error_tbl
439: );
440:
441: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
442: = FND_API.G_FALSE
443: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension5_id)
444: = FND_API.G_FALSE) then
445: Create_Indicator_Dimension( l_id
439: );
440:
441: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
442: = FND_API.G_FALSE
443: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension5_id)
444: = FND_API.G_FALSE) then
445: Create_Indicator_Dimension( l_id
446: , p_Measure_Rec.Dimension5_Id
447: , 5
449: , x_return_status
450: , x_error_tbl
451: );
452:
453: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
454: = FND_API.G_FALSE
455: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension6_id)
456: = FND_API.G_FALSE) then
457: Create_Indicator_Dimension( l_id
451: );
452:
453: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
454: = FND_API.G_FALSE
455: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension6_id)
456: = FND_API.G_FALSE) then
457: Create_Indicator_Dimension( l_id
458: , p_Measure_Rec.Dimension6_Id
459: , 6
461: , x_return_status
462: , x_error_tbl
463: );
464:
465: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
466: = FND_API.G_FALSE
467: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension7_id)
468: = FND_API.G_FALSE) then
469: Create_Indicator_Dimension( l_id
463: );
464:
465: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
466: = FND_API.G_FALSE
467: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension7_id)
468: = FND_API.G_FALSE) then
469: Create_Indicator_Dimension( l_id
470: , p_Measure_Rec.Dimension7_Id
471: , 7
511: --The latest lct file. The lct file can indirectly call this overloaded procedure
512: --by passing in Org and Time also
513: PROCEDURE Create_Indicator_Dimensions
514: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
515: , p_Org_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
516: , p_Time_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
517: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
518: , x_return_status OUT NOCOPY VARCHAR2
519: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
512: --by passing in Org and Time also
513: PROCEDURE Create_Indicator_Dimensions
514: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
515: , p_Org_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
516: , p_Time_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
517: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
518: , x_return_status OUT NOCOPY VARCHAR2
519: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
520: )
513: PROCEDURE Create_Indicator_Dimensions
514: ( p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
515: , p_Org_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
516: , p_Time_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
517: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
518: , x_return_status OUT NOCOPY VARCHAR2
519: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
520: )
521: IS
515: , p_Org_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
516: , p_Time_Dimension_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
517: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
518: , x_return_status OUT NOCOPY VARCHAR2
519: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
520: )
521: IS
522: l_id NUMBER := p_Measure_rec.Measure_Id;
523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
519: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
520: )
521: IS
522: l_id NUMBER := p_Measure_rec.Measure_Id;
523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
524: BEGIN
525:
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: if(IS_OLD_DATA_MODEL(p_Measure_Rec,p_Org_Dimension_ID,p_Time_Dimension_ID)) THEN
529:
530: if (BIS_UTILITIES_PUB.Value_Missing(p_Org_Dimension_id)
531: = FND_API.G_FALSE
532: AND BIS_UTILITIES_PUB.Value_Null(p_Org_Dimension_id)
533: = FND_API.G_FALSE) then
534:
528: if(IS_OLD_DATA_MODEL(p_Measure_Rec,p_Org_Dimension_ID,p_Time_Dimension_ID)) THEN
529:
530: if (BIS_UTILITIES_PUB.Value_Missing(p_Org_Dimension_id)
531: = FND_API.G_FALSE
532: AND BIS_UTILITIES_PUB.Value_Null(p_Org_Dimension_id)
533: = FND_API.G_FALSE) then
534:
535: Create_Indicator_Dimension( l_id
536: , p_Org_Dimension_Id
538: , p_owner
539: , x_return_status
540: , x_error_tbl
541: );
542: if (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_id)
543: = FND_API.G_FALSE
544: AND BIS_UTILITIES_PUB.Value_Null(p_Time_Dimension_id)
545: = FND_API.G_FALSE) then
546:
540: , x_error_tbl
541: );
542: if (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_id)
543: = FND_API.G_FALSE
544: AND BIS_UTILITIES_PUB.Value_Null(p_Time_Dimension_id)
545: = FND_API.G_FALSE) then
546:
547: Create_Indicator_Dimension( l_id
548: , p_Time_Dimension_Id
551: , x_return_status
552: , x_error_tbl
553: );
554:
555: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
556: = FND_API.G_FALSE
557: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension1_id)
558: = FND_API.G_FALSE) then
559:
553: );
554:
555: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
556: = FND_API.G_FALSE
557: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension1_id)
558: = FND_API.G_FALSE) then
559:
560: Create_Indicator_Dimension( l_id
561: , p_Measure_Rec.Dimension1_Id
564: , x_return_status
565: , x_error_tbl
566: );
567:
568: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
569: = FND_API.G_FALSE
570: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension2_id)
571: = FND_API.G_FALSE) then
572:
566: );
567:
568: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
569: = FND_API.G_FALSE
570: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension2_id)
571: = FND_API.G_FALSE) then
572:
573: Create_Indicator_Dimension( l_id
574: , p_Measure_Rec.Dimension2_Id
577: , x_return_status
578: , x_error_tbl
579: );
580:
581: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
582: = FND_API.G_FALSE
583: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension3_id)
584: = FND_API.G_FALSE) then
585: Create_Indicator_Dimension( l_id
579: );
580:
581: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
582: = FND_API.G_FALSE
583: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension3_id)
584: = FND_API.G_FALSE) then
585: Create_Indicator_Dimension( l_id
586: , p_Measure_Rec.Dimension3_Id
587: , 5
589: , x_return_status
590: , x_error_tbl
591: );
592:
593: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
594: = FND_API.G_FALSE
595: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension4_id)
596: = FND_API.G_FALSE) then
597: Create_Indicator_Dimension( l_id
591: );
592:
593: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
594: = FND_API.G_FALSE
595: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension4_id)
596: = FND_API.G_FALSE) then
597: Create_Indicator_Dimension( l_id
598: , p_Measure_Rec.Dimension4_Id
599: , 6
601: , x_return_status
602: , x_error_tbl
603: );
604:
605: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
606: = FND_API.G_FALSE
607: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension5_id)
608: = FND_API.G_FALSE) then
609: Create_Indicator_Dimension( l_id
603: );
604:
605: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
606: = FND_API.G_FALSE
607: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension5_id)
608: = FND_API.G_FALSE) then
609: Create_Indicator_Dimension( l_id
610: , p_Measure_Rec.Dimension5_Id
611: , 7
622: end if;
623:
624: ELSE
625:
626: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
627: = FND_API.G_FALSE
628: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension1_id)
629: = FND_API.G_FALSE) then
630:
624: ELSE
625:
626: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
627: = FND_API.G_FALSE
628: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension1_id)
629: = FND_API.G_FALSE) then
630:
631: Create_Indicator_Dimension( l_id
632: , p_Measure_Rec.Dimension1_Id
635: , x_return_status
636: , x_error_tbl
637: );
638:
639: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
640: = FND_API.G_FALSE
641: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension2_id)
642: = FND_API.G_FALSE) then
643:
637: );
638:
639: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
640: = FND_API.G_FALSE
641: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension2_id)
642: = FND_API.G_FALSE) then
643:
644: Create_Indicator_Dimension( l_id
645: , p_Measure_Rec.Dimension2_Id
648: , x_return_status
649: , x_error_tbl
650: );
651:
652: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
653: = FND_API.G_FALSE
654: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension3_id)
655: = FND_API.G_FALSE) then
656: Create_Indicator_Dimension( l_id
650: );
651:
652: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
653: = FND_API.G_FALSE
654: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension3_id)
655: = FND_API.G_FALSE) then
656: Create_Indicator_Dimension( l_id
657: , p_Measure_Rec.Dimension3_Id
658: , 3
660: , x_return_status
661: , x_error_tbl
662: );
663:
664: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
665: = FND_API.G_FALSE
666: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension4_id)
667: = FND_API.G_FALSE) then
668: Create_Indicator_Dimension( l_id
662: );
663:
664: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
665: = FND_API.G_FALSE
666: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension4_id)
667: = FND_API.G_FALSE) then
668: Create_Indicator_Dimension( l_id
669: , p_Measure_Rec.Dimension4_Id
670: , 4
672: , x_return_status
673: , x_error_tbl
674: );
675:
676: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
677: = FND_API.G_FALSE
678: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension5_id)
679: = FND_API.G_FALSE) then
680: Create_Indicator_Dimension( l_id
674: );
675:
676: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
677: = FND_API.G_FALSE
678: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension5_id)
679: = FND_API.G_FALSE) then
680: Create_Indicator_Dimension( l_id
681: , p_Measure_Rec.Dimension5_Id
682: , 5
684: , x_return_status
685: , x_error_tbl
686: );
687:
688: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
689: = FND_API.G_FALSE
690: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension6_id)
691: = FND_API.G_FALSE) then
692: Create_Indicator_Dimension( l_id
686: );
687:
688: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
689: = FND_API.G_FALSE
690: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension6_id)
691: = FND_API.G_FALSE) then
692: Create_Indicator_Dimension( l_id
693: , p_Measure_Rec.Dimension6_Id
694: , 6
696: , x_return_status
697: , x_error_tbl
698: );
699:
700: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
701: = FND_API.G_FALSE
702: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension7_id)
703: = FND_API.G_FALSE) then
704: Create_Indicator_Dimension( l_id
698: );
699:
700: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
701: = FND_API.G_FALSE
702: AND BIS_UTILITIES_PUB.Value_Null(p_Measure_Rec.Dimension7_id)
703: = FND_API.G_FALSE) then
704: Create_Indicator_Dimension( l_id
705: , p_Measure_Rec.Dimension7_Id
706: , 7
848: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
849: --, p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
850: --, p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
851: --, x_return_status OUT NOCOPY VARCHAR2
852: --, x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
853: --)
854: --IS
855: --BEGIN
856: --
858: -- ( p_api_version => p_api_version
859: -- , p_commit => p_commit
860: -- , p_validation_level => p_validation_level
861: -- , p_Measure_Rec => p_Measure_Rec
862: -- , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
863: -- , x_return_status => x_return_status
864: -- , x_error_Tbl => x_error_Tbl
865: -- );
866: --
885: ( p_api_version IN NUMBER
886: , p_commit IN VARCHAR2 := FND_API.G_FALSE
887: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
888: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
889: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
890: , x_return_status OUT NOCOPY VARCHAR2
891: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
892: )
893: IS
887: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
888: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
889: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
890: , x_return_status OUT NOCOPY VARCHAR2
891: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
892: )
893: IS
894: l_error_count number;
895: l_user_id number;
898: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
899: l_application_rec BIS_APPLICATION_PVT.Application_rec_type;
900: l_measure_id NUMBER;
901: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
902: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
903: l_Mapped_measure bis_indicators_tl.NAME%TYPE;
904: l_Return_Status VARCHAR2(2000);
905:
906: BEGIN
951: BIS_UTILITIES_PVT.Add_Error_Message
952: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
953: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
954: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
955: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
956: , p_error_table => l_error_tbl
957: , x_error_table => x_error_tbl
958: );
959: RAISE FND_API.G_EXC_ERROR;
966: BIS_UTILITIES_PVT.Add_Error_Message
967: ( p_error_msg_name => 'BIS_PMF_ENABLE_LINK_ERR'
968: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
969: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
970: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
971: , p_error_table => l_error_tbl
972: , x_error_table => x_error_tbl
973: );
974: RAISE FND_API.G_EXC_ERROR;
983: BIS_UTILITIES_PVT.Add_Error_Message
984: ( p_error_msg_name => 'BIS_PMF_SOURCE_MAPPING_ERR'
985: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
986: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
987: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
988: , p_token1 => 'MEASURE'
989: , p_value1 => l_Mapped_measure
990: , p_error_table => l_error_tbl
991: , x_error_table => x_error_tbl
1000: BIS_UTILITIES_PVT.Add_Error_Message
1001: ( p_error_msg_name => 'BIS_PMF_COLUMN_MAPPING_ERR'
1002: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1003: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
1004: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1005: , p_token1 => 'MEASURE'
1006: , p_value1 => l_Mapped_measure
1007: , p_error_table => l_error_tbl
1008: , x_error_table => x_error_tbl
1015: -- ankgoel: bug#3891748 - Created_By will take precedence over Owner.
1016: -- Last_Updated_By can be different from Created_By while creating measures
1017: -- during sync-up
1018: IF (l_Measure_Rec.Created_By IS NULL) THEN
1019: l_Measure_Rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1020: END IF;
1021: IF (l_Measure_Rec.Last_Updated_By IS NULL) THEN
1022: l_Measure_Rec.Last_Updated_By := l_Measure_Rec.Created_By;
1023: END IF;
1191: ( p_api_version IN NUMBER
1192: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1193: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1194: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1195: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1196: , p_Org_Dimension_ID IN NUMBER
1197: , p_Time_Dimension_ID IN NUMBER
1198: , x_return_status OUT NOCOPY VARCHAR2
1199: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1195: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1196: , p_Org_Dimension_ID IN NUMBER
1197: , p_Time_Dimension_ID IN NUMBER
1198: , x_return_status OUT NOCOPY VARCHAR2
1199: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1200: )
1201: IS
1202: l_error_count number;
1203: l_user_id number;
1206: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1207: l_application_rec BIS_APPLICATION_PVT.Application_rec_type;
1208: l_measure_id NUMBER;
1209: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
1210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1211: BEGIN
1212:
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214: SetNULL( p_Measure_Rec, l_Measure_Rec);
1280: BIS_UTILITIES_PVT.Add_Error_Message
1281: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
1282: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1283: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
1284: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1285: , p_error_table => l_error_tbl
1286: , x_error_table => x_error_tbl
1287: );
1288: RAISE FND_API.G_EXC_ERROR;
1292: -- ankgoel: bug#3891748 - Created_By will take precedence over Owner.
1293: -- Last_Updated_By can be different from Created_By while creating measures
1294: -- during sync-up
1295: IF (l_Measure_Rec.Created_By IS NULL) THEN
1296: l_Measure_Rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1297: END IF;
1298: IF (l_Measure_Rec.Last_Updated_By IS NULL) THEN
1299: l_Measure_Rec.Last_Updated_By := l_Measure_Rec.Created_By;
1300: END IF;
1483: ( p_api_version IN NUMBER
1484: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1485: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type
1486: , x_return_status OUT NOCOPY VARCHAR2
1487: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1488: )
1489: IS
1490:
1491: l_measure_rec BIS_Measure_PUB.Measure_Rec_Type;
1496: select measure_id, measure_short_name, measure_name
1497: from bisbv_performance_measures
1498: order by UPPER(MEASURE_NAME);
1499:
1500: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1501: BEGIN
1502:
1503: x_return_status := FND_API.G_RET_STS_SUCCESS;
1504:
1561: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1562: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1563: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
1564: , x_return_status OUT NOCOPY VARCHAR2
1565: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1566: )
1567: IS
1568: l_ID NUMBER;
1569: l_dimension_rec BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1567: IS
1568: l_ID NUMBER;
1569: l_dimension_rec BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1570: l_Dimension_Rec_p BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1571: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1572: BEGIN
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: IF (p_Measure_Rec.Measure_Id IS NOT NULL) THEN
1670: where measure_short_name = p_Measure_Rec.Measure_Short_Name; -- bug fix -- mahesh
1671: END IF;
1672: IF p_all_info = FND_API.G_TRUE THEN
1673:
1674: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension1_Id)
1675: = FND_API.G_TRUE AND
1676: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension1_Id)
1677: = FND_API.G_TRUE) THEN
1678: l_dimension_rec.dimension_id := x_Measure_rec.Dimension1_Id;
1672: IF p_all_info = FND_API.G_TRUE THEN
1673:
1674: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension1_Id)
1675: = FND_API.G_TRUE AND
1676: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension1_Id)
1677: = FND_API.G_TRUE) THEN
1678: l_dimension_rec.dimension_id := x_Measure_rec.Dimension1_Id;
1679: l_Dimension_Rec_p := l_Dimension_Rec;
1680: BIS_DIMENSION_PVT.Retrieve_Dimension
1689: := l_dimension_rec.Dimension_Short_Name;
1690: x_Measure_rec.Dimension1_Name := l_dimension_rec.Dimension_Name;
1691: end if;
1692:
1693: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension2_Id)
1694: = FND_API.G_TRUE AND
1695: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1696: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension2_Id)
1697: = FND_API.G_TRUE) THEN
1692:
1693: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension2_Id)
1694: = FND_API.G_TRUE AND
1695: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1696: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension2_Id)
1697: = FND_API.G_TRUE) THEN
1698:
1699: l_dimension_rec.dimension_id := x_Measure_rec.Dimension2_Id;
1700: l_Dimension_Rec_p := l_Dimension_Rec;
1712: else
1713: return;
1714: end if;
1715:
1716: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension3_Id)
1717: = FND_API.G_TRUE AND
1718: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1719: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension3_Id)
1720: = FND_API.G_TRUE) THEN
1715:
1716: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension3_Id)
1717: = FND_API.G_TRUE AND
1718: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1719: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension3_Id)
1720: = FND_API.G_TRUE) THEN
1721:
1722: l_dimension_rec.dimension_id := x_Measure_rec.Dimension3_Id;
1723: l_Dimension_Rec_p := l_Dimension_Rec;
1735: else
1736: return;
1737: end if;
1738:
1739: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension4_Id)
1740: = FND_API.G_TRUE AND
1741: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1742: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension4_Id)
1743: = FND_API.G_TRUE) THEN
1738:
1739: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension4_Id)
1740: = FND_API.G_TRUE AND
1741: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1742: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension4_Id)
1743: = FND_API.G_TRUE) THEN
1744:
1745: l_dimension_rec.dimension_id := x_Measure_rec.Dimension4_Id;
1746: l_Dimension_Rec_p := l_Dimension_Rec;
1758: else
1759: return;
1760: end if;
1761:
1762: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension5_Id)
1763: = FND_API.G_TRUE AND
1764: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1765: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension5_Id)
1766: = FND_API.G_TRUE) THEN
1761:
1762: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension5_Id)
1763: = FND_API.G_TRUE AND
1764: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1765: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension5_Id)
1766: = FND_API.G_TRUE) THEN
1767:
1768: l_dimension_rec.dimension_id := x_Measure_rec.Dimension5_Id;
1769: l_Dimension_Rec_p := l_Dimension_Rec;
1781: else
1782: return;
1783: end if;
1784:
1785: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension6_Id)
1786: = FND_API.G_TRUE AND
1787: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1788: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension6_Id)
1789: = FND_API.G_TRUE) THEN
1784:
1785: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension6_Id)
1786: = FND_API.G_TRUE AND
1787: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1788: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension6_Id)
1789: = FND_API.G_TRUE) THEN
1790:
1791: l_dimension_rec.dimension_id := x_Measure_rec.Dimension6_Id;
1792: l_Dimension_Rec_p := l_Dimension_Rec;
1804: else
1805: return;
1806: end if;
1807:
1808: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension7_Id)
1809: = FND_API.G_TRUE AND
1810: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1811: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension7_Id)
1812: = FND_API.G_TRUE) THEN
1807:
1808: if (BIS_UTILITIES_PUB.Value_Not_Missing(x_Measure_rec.Dimension7_Id)
1809: = FND_API.G_TRUE AND
1810: x_return_status = FND_API.G_RET_STS_SUCCESS AND
1811: BIS_UTILITIES_PUB.Value_Not_NULL(x_Measure_rec.Dimension7_Id)
1812: = FND_API.G_TRUE) THEN
1813:
1814: l_dimension_rec.dimension_id := x_Measure_rec.Dimension7_Id;
1815: l_Dimension_Rec_p := l_Dimension_Rec;
1838: BIS_UTILITIES_PVT.Add_Error_Message
1839: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
1840: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1841: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure'
1842: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1843: , p_error_table => l_error_tbl
1844: , x_error_table => x_error_tbl
1845: );
1846: -- RAISE FND_API.G_EXC_ERROR;
1868: Procedure Update_Indicator_Dimension
1869: ( p_Measure_id number
1870: , p_dimension_id number
1871: , p_sequence_no number
1872: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1873: , x_return_status OUT NOCOPY VARCHAR2
1874: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1875: )
1876: is
1870: , p_dimension_id number
1871: , p_sequence_no number
1872: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1873: , x_return_status OUT NOCOPY VARCHAR2
1874: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1875: )
1876: is
1877: l_user_id number;
1878: l_login_id number;
1875: )
1876: is
1877: l_user_id number;
1878: l_login_id number;
1879: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1880: BEGIN
1881:
1882: if (BIS_UTILITIES_PUB.Value_Missing(p_dimension_id) = FND_API.G_TRUE) then
1883: return;
1878: l_login_id number;
1879: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1880: BEGIN
1881:
1882: if (BIS_UTILITIES_PUB.Value_Missing(p_dimension_id) = FND_API.G_TRUE) then
1883: return;
1884: end if;
1885:
1886: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1882: if (BIS_UTILITIES_PUB.Value_Missing(p_dimension_id) = FND_API.G_TRUE) then
1883: return;
1884: end if;
1885:
1886: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1887: l_login_id := fnd_global.LOGIN_ID;
1888:
1889: UPDATE bis_indicator_dimensions
1890: set
1928: IS
1929: l_count NUMBER := 2;
1930: BEGIN
1931:
1932: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
1933: = FND_API.G_FALSE
1934: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
1935: = FND_API.G_FALSE) then
1936: l_count := 3;
1930: BEGIN
1931:
1932: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
1933: = FND_API.G_FALSE
1934: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
1935: = FND_API.G_FALSE) then
1936: l_count := 3;
1937: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
1938: = FND_API.G_FALSE
1933: = FND_API.G_FALSE
1934: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
1935: = FND_API.G_FALSE) then
1936: l_count := 3;
1937: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
1938: = FND_API.G_FALSE
1939: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
1940: = FND_API.G_FALSE) then
1941: l_count := 4;
1935: = FND_API.G_FALSE) then
1936: l_count := 3;
1937: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
1938: = FND_API.G_FALSE
1939: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
1940: = FND_API.G_FALSE) then
1941: l_count := 4;
1942: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
1943: = FND_API.G_FALSE
1938: = FND_API.G_FALSE
1939: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
1940: = FND_API.G_FALSE) then
1941: l_count := 4;
1942: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
1943: = FND_API.G_FALSE
1944: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
1945: = FND_API.G_FALSE) then
1946: l_count := 5;
1940: = FND_API.G_FALSE) then
1941: l_count := 4;
1942: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
1943: = FND_API.G_FALSE
1944: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
1945: = FND_API.G_FALSE) then
1946: l_count := 5;
1947: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
1948: = FND_API.G_FALSE
1943: = FND_API.G_FALSE
1944: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
1945: = FND_API.G_FALSE) then
1946: l_count := 5;
1947: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
1948: = FND_API.G_FALSE
1949: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
1950: = FND_API.G_FALSE) then
1951: l_count := 6;
1945: = FND_API.G_FALSE) then
1946: l_count := 5;
1947: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
1948: = FND_API.G_FALSE
1949: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
1950: = FND_API.G_FALSE) then
1951: l_count := 6;
1952: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
1953: = FND_API.G_FALSE
1948: = FND_API.G_FALSE
1949: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
1950: = FND_API.G_FALSE) then
1951: l_count := 6;
1952: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
1953: = FND_API.G_FALSE
1954: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
1955: = FND_API.G_FALSE) then
1956: l_count := 7;
1950: = FND_API.G_FALSE) then
1951: l_count := 6;
1952: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
1953: = FND_API.G_FALSE
1954: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
1955: = FND_API.G_FALSE) then
1956: l_count := 7;
1957: end if;
1958: end if;
1975: l_count NUMBER;
1976: BEGIN
1977:
1978: if(IS_OLD_DATA_MODEL(p_Measure_Rec,p_Org_Dimension_Id,p_Time_Dimension_Id)) then
1979: if (BIS_UTILITIES_PUB.Value_Missing(p_Org_Dimension_id)
1980: = FND_API.G_FALSE
1981: AND BIS_UTILITIES_PUB.Value_Null(p_Org_Dimension_id)
1982: = FND_API.G_FALSE) then
1983: l_count := 1;
1977:
1978: if(IS_OLD_DATA_MODEL(p_Measure_Rec,p_Org_Dimension_Id,p_Time_Dimension_Id)) then
1979: if (BIS_UTILITIES_PUB.Value_Missing(p_Org_Dimension_id)
1980: = FND_API.G_FALSE
1981: AND BIS_UTILITIES_PUB.Value_Null(p_Org_Dimension_id)
1982: = FND_API.G_FALSE) then
1983: l_count := 1;
1984: if (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_id)
1985: = FND_API.G_FALSE
1980: = FND_API.G_FALSE
1981: AND BIS_UTILITIES_PUB.Value_Null(p_Org_Dimension_id)
1982: = FND_API.G_FALSE) then
1983: l_count := 1;
1984: if (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_id)
1985: = FND_API.G_FALSE
1986: AND BIS_UTILITIES_PUB.Value_Null(p_Time_Dimension_id)
1987: = FND_API.G_FALSE) then
1988: l_count := 2;
1982: = FND_API.G_FALSE) then
1983: l_count := 1;
1984: if (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_id)
1985: = FND_API.G_FALSE
1986: AND BIS_UTILITIES_PUB.Value_Null(p_Time_Dimension_id)
1987: = FND_API.G_FALSE) then
1988: l_count := 2;
1989: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
1990: = FND_API.G_FALSE
1985: = FND_API.G_FALSE
1986: AND BIS_UTILITIES_PUB.Value_Null(p_Time_Dimension_id)
1987: = FND_API.G_FALSE) then
1988: l_count := 2;
1989: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
1990: = FND_API.G_FALSE
1991: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
1992: = FND_API.G_FALSE) then
1993: l_count := 3;
1987: = FND_API.G_FALSE) then
1988: l_count := 2;
1989: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
1990: = FND_API.G_FALSE
1991: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
1992: = FND_API.G_FALSE) then
1993: l_count := 3;
1994: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
1995: = FND_API.G_FALSE
1990: = FND_API.G_FALSE
1991: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
1992: = FND_API.G_FALSE) then
1993: l_count := 3;
1994: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
1995: = FND_API.G_FALSE
1996: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
1997: = FND_API.G_FALSE) then
1998: l_count := 4;
1992: = FND_API.G_FALSE) then
1993: l_count := 3;
1994: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
1995: = FND_API.G_FALSE
1996: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
1997: = FND_API.G_FALSE) then
1998: l_count := 4;
1999: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
2000: = FND_API.G_FALSE
1995: = FND_API.G_FALSE
1996: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
1997: = FND_API.G_FALSE) then
1998: l_count := 4;
1999: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
2000: = FND_API.G_FALSE
2001: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
2002: = FND_API.G_FALSE) then
2003: l_count := 5;
1997: = FND_API.G_FALSE) then
1998: l_count := 4;
1999: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
2000: = FND_API.G_FALSE
2001: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
2002: = FND_API.G_FALSE) then
2003: l_count := 5;
2004: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
2005: = FND_API.G_FALSE
2000: = FND_API.G_FALSE
2001: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
2002: = FND_API.G_FALSE) then
2003: l_count := 5;
2004: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
2005: = FND_API.G_FALSE
2006: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
2007: = FND_API.G_FALSE) then
2008: l_count := 6;
2002: = FND_API.G_FALSE) then
2003: l_count := 5;
2004: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
2005: = FND_API.G_FALSE
2006: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
2007: = FND_API.G_FALSE) then
2008: l_count := 6;
2009: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
2010: = FND_API.G_FALSE
2005: = FND_API.G_FALSE
2006: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
2007: = FND_API.G_FALSE) then
2008: l_count := 6;
2009: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
2010: = FND_API.G_FALSE
2011: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
2012: = FND_API.G_FALSE) then
2013: l_count := 7;
2007: = FND_API.G_FALSE) then
2008: l_count := 6;
2009: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
2010: = FND_API.G_FALSE
2011: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
2012: = FND_API.G_FALSE) then
2013: l_count := 7;
2014: end if;
2015: end if;
2019: end if;
2020: end if;
2021:
2022: else
2023: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
2024: = FND_API.G_FALSE
2025: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
2026: = FND_API.G_FALSE) then
2027: l_count := 1;
2021:
2022: else
2023: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension1_id)
2024: = FND_API.G_FALSE
2025: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
2026: = FND_API.G_FALSE) then
2027: l_count := 1;
2028: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
2029: = FND_API.G_FALSE
2024: = FND_API.G_FALSE
2025: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension1_id)
2026: = FND_API.G_FALSE) then
2027: l_count := 1;
2028: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
2029: = FND_API.G_FALSE
2030: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
2031: = FND_API.G_FALSE) then
2032: l_count := 2;
2026: = FND_API.G_FALSE) then
2027: l_count := 1;
2028: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension2_id)
2029: = FND_API.G_FALSE
2030: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
2031: = FND_API.G_FALSE) then
2032: l_count := 2;
2033: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
2034: = FND_API.G_FALSE
2029: = FND_API.G_FALSE
2030: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension2_id)
2031: = FND_API.G_FALSE) then
2032: l_count := 2;
2033: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
2034: = FND_API.G_FALSE
2035: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
2036: = FND_API.G_FALSE) then
2037: l_count := 3;
2031: = FND_API.G_FALSE) then
2032: l_count := 2;
2033: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension3_id)
2034: = FND_API.G_FALSE
2035: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
2036: = FND_API.G_FALSE) then
2037: l_count := 3;
2038: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
2039: = FND_API.G_FALSE
2034: = FND_API.G_FALSE
2035: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension3_id)
2036: = FND_API.G_FALSE) then
2037: l_count := 3;
2038: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
2039: = FND_API.G_FALSE
2040: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
2041: = FND_API.G_FALSE) then
2042: l_count := 4;
2036: = FND_API.G_FALSE) then
2037: l_count := 3;
2038: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension4_id)
2039: = FND_API.G_FALSE
2040: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
2041: = FND_API.G_FALSE) then
2042: l_count := 4;
2043: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
2044: = FND_API.G_FALSE
2039: = FND_API.G_FALSE
2040: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension4_id)
2041: = FND_API.G_FALSE) then
2042: l_count := 4;
2043: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
2044: = FND_API.G_FALSE
2045: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
2046: = FND_API.G_FALSE) then
2047: l_count := 5;
2041: = FND_API.G_FALSE) then
2042: l_count := 4;
2043: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension5_id)
2044: = FND_API.G_FALSE
2045: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
2046: = FND_API.G_FALSE) then
2047: l_count := 5;
2048: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
2049: = FND_API.G_FALSE
2044: = FND_API.G_FALSE
2045: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension5_id)
2046: = FND_API.G_FALSE) then
2047: l_count := 5;
2048: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
2049: = FND_API.G_FALSE
2050: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension6_id)
2051: = FND_API.G_FALSE) then
2052: l_count := 6;
2046: = FND_API.G_FALSE) then
2047: l_count := 5;
2048: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension6_id)
2049: = FND_API.G_FALSE
2050: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension6_id)
2051: = FND_API.G_FALSE) then
2052: l_count := 6;
2053: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
2054: = FND_API.G_FALSE
2049: = FND_API.G_FALSE
2050: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension6_id)
2051: = FND_API.G_FALSE) then
2052: l_count := 6;
2053: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
2054: = FND_API.G_FALSE
2055: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension7_id)
2056: = FND_API.G_FALSE) then
2057: l_count := 7;
2051: = FND_API.G_FALSE) then
2052: l_count := 6;
2053: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Rec.Dimension7_id)
2054: = FND_API.G_FALSE
2055: AND BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Dimension7_id)
2056: = FND_API.G_FALSE) then
2057: l_count := 7;
2058: end if;
2059: end if;
2315: BEGIN
2316:
2317: x_measure_rec := p_Measure_Rec1;
2318:
2319: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Measure_Name);
2320: IF (l_ret = FND_API.G_FALSE) THEN
2321: x_measure_rec.Measure_Name := p_measure_rec.Measure_Name;
2322: END IF;
2323:
2320: IF (l_ret = FND_API.G_FALSE) THEN
2321: x_measure_rec.Measure_Name := p_measure_rec.Measure_Name;
2322: END IF;
2323:
2324: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Description);
2325: IF (l_ret = FND_API.G_FALSE) THEN
2326: x_measure_rec.Description := p_measure_rec.Description;
2327: END IF;
2328:
2326: x_measure_rec.Description := p_measure_rec.Description;
2327: END IF;
2328:
2329: -- Added for P1 2565752
2330: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Unit_Of_Measure_Class);
2331: IF (l_ret = FND_API.G_FALSE) THEN
2332: x_measure_rec.Unit_Of_Measure_Class := p_measure_rec.Unit_Of_Measure_Class;
2333: END IF;
2334:
2331: IF (l_ret = FND_API.G_FALSE) THEN
2332: x_measure_rec.Unit_Of_Measure_Class := p_measure_rec.Unit_Of_Measure_Class;
2333: END IF;
2334:
2335: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.ACTUAL_DATA_SOURCE_TYPE);
2336: IF (l_ret = FND_API.G_FALSE) THEN
2337: x_measure_rec.ACTUAL_DATA_SOURCE_TYPE := p_measure_rec.ACTUAL_DATA_SOURCE_TYPE;
2338: END IF;
2339:
2336: IF (l_ret = FND_API.G_FALSE) THEN
2337: x_measure_rec.ACTUAL_DATA_SOURCE_TYPE := p_measure_rec.ACTUAL_DATA_SOURCE_TYPE;
2338: END IF;
2339:
2340: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.ACTUAL_DATA_SOURCE);
2341: IF (l_ret = FND_API.G_FALSE) THEN
2342: x_measure_rec.ACTUAL_DATA_SOURCE := p_measure_rec.ACTUAL_DATA_SOURCE;
2343: END IF;
2344:
2341: IF (l_ret = FND_API.G_FALSE) THEN
2342: x_measure_rec.ACTUAL_DATA_SOURCE := p_measure_rec.ACTUAL_DATA_SOURCE;
2343: END IF;
2344:
2345: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.FUNCTION_NAME);
2346: IF (l_ret = FND_API.G_FALSE) THEN
2347: x_measure_rec.FUNCTION_NAME := p_measure_rec.FUNCTION_NAME;
2348: END IF;
2349:
2346: IF (l_ret = FND_API.G_FALSE) THEN
2347: x_measure_rec.FUNCTION_NAME := p_measure_rec.FUNCTION_NAME;
2348: END IF;
2349:
2350: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.COMPARISON_SOURCE);
2351: IF (l_ret = FND_API.G_FALSE) THEN
2352: x_measure_rec.COMPARISON_SOURCE := p_measure_rec.COMPARISON_SOURCE;
2353: END IF;
2354:
2352: x_measure_rec.COMPARISON_SOURCE := p_measure_rec.COMPARISON_SOURCE;
2353: END IF;
2354:
2355:
2356: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.INCREASE_IN_MEASURE);
2357: IF (l_ret = FND_API.G_FALSE) THEN
2358: x_measure_rec.INCREASE_IN_MEASURE := p_measure_rec.INCREASE_IN_MEASURE;
2359: END IF;
2360:
2357: IF (l_ret = FND_API.G_FALSE) THEN
2358: x_measure_rec.INCREASE_IN_MEASURE := p_measure_rec.INCREASE_IN_MEASURE;
2359: END IF;
2360:
2361: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.ENABLE_LINK);
2362: IF (l_ret = FND_API.G_FALSE) THEN
2363: x_measure_rec.ENABLE_LINK := p_measure_rec.ENABLE_LINK;
2364: END IF;
2365: -- 3031053
2362: IF (l_ret = FND_API.G_FALSE) THEN
2363: x_measure_rec.ENABLE_LINK := p_measure_rec.ENABLE_LINK;
2364: END IF;
2365: -- 3031053
2366: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.ENABLED);
2367: IF (l_ret = FND_API.G_FALSE) THEN
2368: x_measure_rec.ENABLED := p_measure_rec.ENABLED;
2369: END IF;
2370: --3031053
2367: IF (l_ret = FND_API.G_FALSE) THEN
2368: x_measure_rec.ENABLED := p_measure_rec.ENABLED;
2369: END IF;
2370: --3031053
2371: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Obsolete); --3865711
2372: IF (l_ret = FND_API.G_FALSE) THEN
2373: x_measure_rec.Obsolete := p_measure_rec.Obsolete;
2374: END IF;
2375: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Measure_Type); --3865711
2371: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Obsolete); --3865711
2372: IF (l_ret = FND_API.G_FALSE) THEN
2373: x_measure_rec.Obsolete := p_measure_rec.Obsolete;
2374: END IF;
2375: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Measure_Type); --3865711
2376: IF (l_ret = FND_API.G_FALSE) THEN
2377: x_measure_rec.Measure_Type := p_measure_rec.Measure_Type;
2378: END IF;
2379: --- 2465354
2376: IF (l_ret = FND_API.G_FALSE) THEN
2377: x_measure_rec.Measure_Type := p_measure_rec.Measure_Type;
2378: END IF;
2379: --- 2465354
2380: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_rec.Application_Id);
2381: IF (l_ret = FND_API.G_FALSE) THEN
2382: x_measure_rec.Application_Id := p_measure_rec.Application_Id;
2383: END IF;
2384: --- 2465354
2432: l_is_null VARCHAR2(300);
2433:
2434: BEGIN
2435:
2436: l_is_missing := BIS_UTILITIES_PUB.Value_Missing(p_dim_id);
2437: l_is_null := BIS_UTILITIES_PUB.Value_Null(p_dim_id);
2438:
2439: IF ( (l_is_missing = FND_API.G_TRUE)
2440: OR (l_is_null = FND_API.G_TRUE)
2433:
2434: BEGIN
2435:
2436: l_is_missing := BIS_UTILITIES_PUB.Value_Missing(p_dim_id);
2437: l_is_null := BIS_UTILITIES_PUB.Value_Null(p_dim_id);
2438:
2439: IF ( (l_is_missing = FND_API.G_TRUE)
2440: OR (l_is_null = FND_API.G_TRUE)
2441: ) THEN
2460: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2461: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2462: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2463: , x_return_status OUT NOCOPY VARCHAR2
2464: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2465: )
2466: IS
2467:
2468: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2464: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2465: )
2466: IS
2467:
2468: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2469: BEGIN
2470:
2471: BIS_MEASURE_PVT.Update_Measure
2472: ( p_api_version => p_api_version
2472: ( p_api_version => p_api_version
2473: , p_commit => p_commit
2474: , p_validation_level => p_validation_level
2475: , p_Measure_Rec => p_Measure_Rec
2476: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2477: , x_return_status => x_return_status
2478: , x_error_Tbl => x_error_Tbl
2479: );
2480:
2504: ( p_api_version IN NUMBER
2505: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2506: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2507: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2508: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2509: , x_return_status OUT NOCOPY VARCHAR2
2510: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2511: )
2512: IS
2506: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2507: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2508: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2509: , x_return_status OUT NOCOPY VARCHAR2
2510: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2511: )
2512: IS
2513: l_user_id number;
2514: l_login_id number;
2519: l_count NUMBER := 0;
2520: l_Measure_Id NUMBER;
2521: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354
2522: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
2523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2524: l_Mapped_measure bis_indicators_tl.NAME%TYPE;
2525: l_Return_Status VARCHAR2(2000);
2526:
2527: BEGIN
2555: BIS_UTILITIES_PVT.Add_Error_Message
2556: ( p_error_msg_name => 'BIS_PMF_ENABLE_LINK_ERR'
2557: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2558: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2559: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2560: , p_error_table => l_error_tbl
2561: , x_error_table => x_error_tbl
2562: );
2563: RAISE FND_API.G_EXC_ERROR;
2573: BIS_UTILITIES_PVT.Add_Error_Message
2574: ( p_error_msg_name => 'BIS_PMF_SOURCE_MAPPING_ERR'
2575: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2576: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2577: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2578: , p_token1 => 'MEASURE'
2579: , p_value1 => l_Mapped_measure
2580: , p_error_table => l_error_tbl
2581: , x_error_table => x_error_tbl
2589: BIS_UTILITIES_PVT.Add_Error_Message
2590: ( p_error_msg_name => 'BIS_PMF_COLUMN_MAPPING_ERR'
2591: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2592: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2593: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2594: , p_token1 => 'MEASURE'
2595: , p_value1 => l_Mapped_measure
2596: , p_error_table => l_error_tbl
2597: , x_error_table => x_error_tbl
2612: BIS_UTILITIES_PVT.Add_Error_Message
2613: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
2614: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2615: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2616: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2617: , p_error_table => l_error_tbl
2618: , x_error_table => x_error_tbl
2619: );
2620:
2646: BIS_UTILITIES_PVT.Add_Error_Message
2647: ( p_error_msg_name => 'BIS_NO_DIMENSION_CHANGE'
2648: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2649: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2650: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2651: , p_error_table => l_error_tbl
2652: , x_error_table => x_error_tbl
2653: );
2654:
2681: ( p_Measure_Rec => l_measure_rec1
2682: , x_Measure_Rec => l_measure_rec
2683: ) ;
2684:
2685: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
2686: l_login_id := fnd_global.LOGIN_ID;
2687:
2688: l_Measure_Rec.Last_Updated_By := l_user_id;
2689: l_Measure_Rec.Last_Update_Login := l_login_id;
2809: ( p_api_version IN NUMBER
2810: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2811: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2812: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
2813: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2814: , p_Org_Dimension_ID IN NUMBER
2815: , p_Time_Dimension_ID IN NUMBER
2816: , x_return_status OUT NOCOPY VARCHAR2
2817: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2813: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2814: , p_Org_Dimension_ID IN NUMBER
2815: , p_Time_Dimension_ID IN NUMBER
2816: , x_return_status OUT NOCOPY VARCHAR2
2817: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2818: )
2819: IS
2820: l_user_id number;
2821: l_login_id number;
2824: l_count NUMBER := 0;
2825: l_Measure_Id NUMBER;
2826: l_application_rec BIS_APPLICATION_PVT.Application_rec_type; --2465354
2827: l_own_appl VARCHAR2(100) := FND_API.G_FALSE ; --2465354
2828: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2829: BEGIN
2830: -- l_measure_rec := p_measure_rec;
2831:
2832: Validate_Measure( p_api_version
2885: BIS_UTILITIES_PVT.Add_Error_Message
2886: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
2887: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2888: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2889: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2890: , p_error_table => l_error_tbl
2891: , x_error_table => x_error_tbl
2892: );
2893:
2916: BIS_UTILITIES_PVT.Add_Error_Message
2917: ( p_error_msg_name => 'BIS_NO_DIMENSION_CHANGE'
2918: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2919: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2920: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2921: , p_error_table => l_error_tbl
2922: , x_error_table => x_error_tbl
2923: );
2924:
2934: , x_Measure_Rec => l_Measure_Rec
2935: );
2936:
2937:
2938: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
2939: l_login_id := fnd_global.LOGIN_ID;
2940:
2941: l_Measure_Rec.Last_Update_Date := p_Measure_Rec.Last_Update_Date;
2942: IF (l_Measure_Rec.Last_Update_Date IS NULL) THEN
3044: ( p_api_version IN NUMBER
3045: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3046: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3047: , x_return_status OUT NOCOPY VARCHAR2
3048: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3049: )
3050: IS
3051: l_count number;
3052: l_dcount number;
3049: )
3050: IS
3051: l_count number;
3052: l_dcount number;
3053: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3054: BEGIN
3055:
3056: x_return_status := FND_API.G_RET_STS_SUCCESS;
3057: BIS_Target_Level_PVT.Count_Target_Levels( p_api_version
3066: BIS_UTILITIES_PVT.Add_Error_Message
3067: ( p_error_msg_name => 'BIS_NO_DELETE_MEASURE'
3068: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3069: , p_error_proc_name => G_PKG_NAME||'.Delete_Measure'
3070: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3071: , p_error_table => l_error_tbl
3072: , x_error_table => x_error_tbl
3073: );
3074:
3083: BIS_UTILITIES_PVT.Add_Error_Message
3084: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
3085: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3086: , p_error_proc_name => G_PKG_NAME||'.Delete_Measure'
3087: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3088: , p_error_table => l_error_tbl
3089: , x_error_table => x_error_tbl
3090: );
3091: RAISE FND_API.G_EXC_ERROR;
3146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3147: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3148: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3149: , x_return_status OUT NOCOPY VARCHAR2
3150: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3151: )
3152: IS
3153: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3154: BEGIN
3149: , x_return_status OUT NOCOPY VARCHAR2
3150: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3151: )
3152: IS
3153: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3154: BEGIN
3155:
3156: Translate_Measure
3157: ( p_api_version => p_api_version
3157: ( p_api_version => p_api_version
3158: , p_commit => p_commit
3159: , p_validation_level => p_validation_level
3160: , p_Measure_Rec => p_Measure_Rec
3161: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3162: , x_return_status => x_return_status
3163: , x_error_Tbl => x_error_Tbl
3164: );
3165: --commented RAISE
3184: ( p_api_version IN NUMBER
3185: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3186: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3187: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3188: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3189: , x_return_status OUT NOCOPY VARCHAR2
3190: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3191: )
3192: IS
3186: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3187: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3188: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3189: , x_return_status OUT NOCOPY VARCHAR2
3190: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3191: )
3192: IS
3193: l_user_id NUMBER;
3194: l_login_id NUMBER;
3195: l_count NUMBER := 0;
3196: --l_Measure_Id NUMBER;
3197: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
3198: l_Measure_Rec_Orig BIS_MEASURE_PUB.Measure_Rec_Type;
3199: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3200:
3201: BEGIN
3202:
3203: l_measure_rec := p_measure_rec;
3231: BIS_UTILITIES_PVT.Add_Error_Message
3232: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
3233: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3234: , p_error_proc_name => G_PKG_NAME||'.Translate_Measure'
3235: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3236: , p_error_table => l_error_tbl
3237: , x_error_table => x_error_tbl
3238: );
3239: RAISE FND_API.G_EXC_ERROR;
3248: );
3249: */
3250: --
3251:
3252: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
3253:
3254: l_login_id := fnd_global.LOGIN_ID;
3255: --
3256:
3299: PROCEDURE Validate_Measure
3300: ( p_api_version IN NUMBER
3301: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3302: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3303: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3304: , x_return_status OUT NOCOPY VARCHAR2
3305: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3306: )
3307: IS
3301: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3302: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
3303: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
3304: , x_return_status OUT NOCOPY VARCHAR2
3305: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3306: )
3307: IS
3308: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3309: l_error VARCHAR2(10) := FND_API.G_FALSE;
3304: , x_return_status OUT NOCOPY VARCHAR2
3305: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3306: )
3307: IS
3308: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3309: l_error VARCHAR2(10) := FND_API.G_FALSE;
3310: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
3311: l_region_code varchar2(30);
3312: l_pos number;
3306: )
3307: IS
3308: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3309: l_error VARCHAR2(10) := FND_API.G_FALSE;
3310: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
3311: l_region_code varchar2(30);
3312: l_pos number;
3313: l_source_column varchar2(30);
3314: BEGIN
3499: BIS_UTILITIES_PVT.Add_Error_Message
3500: ( p_error_msg_name => 'BIS_SOURCE_COLUMN_ERR_TXT'
3501: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3502: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
3503: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3504: , p_error_table => l_error_tbl
3505: , x_error_table => x_error_tbl
3506: );
3507: RAISE FND_API.G_EXC_ERROR;
3507: RAISE FND_API.G_EXC_ERROR;
3508: end if;
3509:
3510:
3511: IF p_owner = BIS_UTILITIES_PUB.G_CUSTOM_OWNER THEN --2240105
3512: BEGIN
3513: BIS_MEASURE_VALIDATE_PVT.Val_Actual_Data_Sour_Wrap
3514: ( p_api_version => p_api_version
3515: , p_validation_level => p_validation_level
3709: ( p_api_version IN NUMBER
3710: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
3711: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
3712: , x_return_status OUT NOCOPY VARCHAR2
3713: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3714: )
3715: IS
3716: l_convert VARCHAR2(32000);
3717: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3713: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3714: )
3715: IS
3716: l_convert VARCHAR2(32000);
3717: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3718: BEGIN
3719: x_return_status := FND_API.G_RET_STS_SUCCESS;
3720: x_Measure_Rec := p_Measure_Rec;
3721:
3718: BEGIN
3719: x_return_status := FND_API.G_RET_STS_SUCCESS;
3720: x_Measure_Rec := p_Measure_Rec;
3721:
3722: if (BIS_UTILITIES_PUB.Value_Missing
3723: (x_Measure_Rec.Measure_id) = FND_API.G_TRUE
3724: OR BIS_UTILITIES_PUB.Value_NULL(x_Measure_Rec.Measure_id)
3725: = FND_API.G_TRUE) then
3726: BEGIN
3720: x_Measure_Rec := p_Measure_Rec;
3721:
3722: if (BIS_UTILITIES_PUB.Value_Missing
3723: (x_Measure_Rec.Measure_id) = FND_API.G_TRUE
3724: OR BIS_UTILITIES_PUB.Value_NULL(x_Measure_Rec.Measure_id)
3725: = FND_API.G_TRUE) then
3726: BEGIN
3727: BIS_Measure_PVT.Value_ID_Conversion
3728: ( p_api_version
3949: , p_Measure_Short_Name IN VARCHAR2
3950: , p_Measure_Name IN VARCHAR2
3951: , x_Measure_ID OUT NOCOPY NUMBER
3952: , x_return_status OUT NOCOPY VARCHAR2
3953: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3954: )
3955: IS
3956: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3957: BEGIN
3952: , x_return_status OUT NOCOPY VARCHAR2
3953: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3954: )
3955: IS
3956: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3957: BEGIN
3958: x_return_status := FND_API.G_RET_STS_SUCCESS;
3959:
3960: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Short_Name)
3956: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3957: BEGIN
3958: x_return_status := FND_API.G_RET_STS_SUCCESS;
3959:
3960: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Short_Name)
3961: = FND_API.G_TRUE) then
3962: SELECT Measure_id into x_Measure_ID
3963: FROM bisbv_Performance_Measures
3964: WHERE Measure_short_name = p_Measure_Short_Name;
3961: = FND_API.G_TRUE) then
3962: SELECT Measure_id into x_Measure_ID
3963: FROM bisbv_Performance_Measures
3964: WHERE Measure_short_name = p_Measure_Short_Name;
3965: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Name)
3966: = FND_API.G_TRUE) then
3967: SELECT Measure_id into x_Measure_ID
3968: FROM bisbv_Performance_Measures
3969: WHERE Measure_name = p_Measure_Name;
3974: BIS_UTILITIES_PVT.Add_Error_Message
3975: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
3976: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3977: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3978: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3979: , p_error_table => l_error_tbl
3980: , x_error_table => x_error_tbl
3981: );
3982:
4015: ( p_api_version IN NUMBER
4016: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4017: , x_Measure_Rec OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
4018: , x_return_status OUT NOCOPY VARCHAR2
4019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4020: )
4021: IS
4022: l_convert VARCHAR2(32000);
4023: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4020: )
4021: IS
4022: l_convert VARCHAR2(32000);
4023: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4024: BEGIN
4025: x_return_status := FND_API.G_RET_STS_SUCCESS;
4026: x_Measure_Rec := p_Measure_Rec;
4027:
4024: BEGIN
4025: x_return_status := FND_API.G_RET_STS_SUCCESS;
4026: x_Measure_Rec := p_Measure_Rec;
4027:
4028: if (BIS_UTILITIES_PUB.Value_Missing
4029: (x_Measure_Rec.Measure_id) = FND_API.G_TRUE
4030: OR BIS_UTILITIES_PUB.Value_NULL(x_Measure_Rec.Measure_id)
4031: = FND_API.G_TRUE) then
4032: BEGIN
4026: x_Measure_Rec := p_Measure_Rec;
4027:
4028: if (BIS_UTILITIES_PUB.Value_Missing
4029: (x_Measure_Rec.Measure_id) = FND_API.G_TRUE
4030: OR BIS_UTILITIES_PUB.Value_NULL(x_Measure_Rec.Measure_id)
4031: = FND_API.G_TRUE) then
4032: BEGIN
4033: BIS_Measure_PVT.Value_ID_Conversion
4034: ( p_api_version
4043: BIS_UTILITIES_PVT.Add_Error_Message
4044: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
4045: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4046: , p_error_proc_name => G_PKG_NAME||'.Measure_Value_ID_Conversion'
4047: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4048: , p_error_table => l_error_tbl
4049: , x_error_table => x_error_tbl
4050: );
4051: RAISE FND_API.G_EXC_ERROR;
4084: ( p_api_version IN NUMBER
4085: , p_Measure_Rec IN BIS_Measure_PUB.Measure_Rec_Type
4086: , x_Measure_Rec IN OUT NOCOPY BIS_Measure_PUB.Measure_Rec_Type
4087: , x_return_status OUT NOCOPY VARCHAR2
4088: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4089: )
4090: IS
4091: l_convert VARCHAR2(32000);
4092: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4088: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4089: )
4090: IS
4091: l_convert VARCHAR2(32000);
4092: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4093: BEGIN
4094: x_return_status := FND_API.G_RET_STS_SUCCESS;
4095: x_Measure_Rec := p_Measure_Rec;
4096:
4119: BIS_UTILITIES_PVT.Add_Error_Message
4120: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4121: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4122: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4123: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4124: , p_error_table => l_error_tbl
4125: , x_error_table => x_error_tbl
4126: );
4127: RAISE FND_API.G_EXC_ERROR;
4153: BIS_UTILITIES_PVT.Add_Error_Message
4154: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4155: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4156: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4157: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4158: , p_error_table => l_error_tbl
4159: , x_error_table => x_error_tbl
4160: );
4161: RAISE FND_API.G_EXC_ERROR;
4187: BIS_UTILITIES_PVT.Add_Error_Message
4188: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4189: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4190: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4191: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4192: , p_error_table => l_error_tbl
4193: , x_error_table => x_error_tbl
4194: );
4195: RAISE FND_API.G_EXC_ERROR;
4221: BIS_UTILITIES_PVT.Add_Error_Message
4222: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4223: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4224: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4225: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4226: , p_error_table => l_error_tbl
4227: , x_error_table => x_error_tbl
4228: );
4229: RAISE FND_API.G_EXC_ERROR;
4255: BIS_UTILITIES_PVT.Add_Error_Message
4256: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4257: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4258: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4259: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4260: , p_error_table => l_error_tbl
4261: , x_error_table => x_error_tbl
4262: );
4263: RAISE FND_API.G_EXC_ERROR;
4289: BIS_UTILITIES_PVT.Add_Error_Message
4290: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4291: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4292: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4293: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4294: , p_error_table => l_error_tbl
4295: , x_error_table => x_error_tbl
4296: );
4297: RAISE FND_API.G_EXC_ERROR;
4323: BIS_UTILITIES_PVT.Add_Error_Message
4324: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4325: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4326: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4327: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4328: , p_error_table => l_error_tbl
4329: , x_error_table => x_error_tbl
4330: );
4331: RAISE FND_API.G_EXC_ERROR;
4364: ( p_api_version IN NUMBER
4365: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4366: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
4367: , x_return_status OUT NOCOPY VARCHAR2
4368: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4369: )
4370: IS
4371:
4372: i NUMBER := 0;
4371:
4372: i NUMBER := 0;
4373: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
4374: l_dimension_rec_p BIS_DIMENSION_PUB.Dimension_Rec_Type;
4375: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4376:
4377: cursor ind_dim(p_measure_id number) is
4378: select id.dimension_id
4379: from bis_indicator_dimensions id
4407: BIS_UTILITIES_PVT.Add_Error_Message
4408: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
4409: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4410: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure_Dimensions'
4411: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4412: , p_error_table => l_error_tbl
4413: , x_error_table => x_error_tbl
4414: );
4415: RAISE FND_API.G_EXC_ERROR;
4452: ( p_api_version IN NUMBER
4453: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4454: , x_last_update_date OUT NOCOPY DATE
4455: , x_return_status OUT NOCOPY VARCHAR2
4456: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4457: )
4458: IS
4459: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4460: BEGIN
4455: , x_return_status OUT NOCOPY VARCHAR2
4456: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4457: )
4458: IS
4459: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4460: BEGIN
4461: x_return_status := FND_API.G_RET_STS_SUCCESS;
4462: --
4463: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Rec.Measure_ID)
4459: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4460: BEGIN
4461: x_return_status := FND_API.G_RET_STS_SUCCESS;
4462: --
4463: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Rec.Measure_ID)
4464: = FND_API.G_TRUE
4465: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Measure_Rec.Measure_ID)
4466: = FND_API.G_TRUE
4467: ) THEN
4461: x_return_status := FND_API.G_RET_STS_SUCCESS;
4462: --
4463: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Rec.Measure_ID)
4464: = FND_API.G_TRUE
4465: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Measure_Rec.Measure_ID)
4466: = FND_API.G_TRUE
4467: ) THEN
4468: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
4469: INTO x_last_update_date
4480: BIS_UTILITIES_PVT.Add_Error_Message
4481: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
4482: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4483: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
4484: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
4485: , p_error_table => l_error_tbl
4486: , x_error_table => x_error_tbl
4487: );
4488: x_return_status := FND_API.G_RET_STS_ERROR;
4514: ( p_api_version IN NUMBER
4515: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4516: , p_timestamp IN VARCHAR := NULL
4517: , x_return_status OUT NOCOPY VARCHAR2
4518: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4519: )
4520: IS
4521: --
4522: l_form_date DATE;
4521: --
4522: l_form_date DATE;
4523: l_last_update_date DATE;
4524: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
4525: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4526: --
4527: BEGIN
4528: x_return_status := FND_API.G_RET_STS_SUCCESS;
4529: --
4582: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4583: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4584: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4585: , p_owning_application IN VARCHAR2
4586: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
4587: , x_return_status OUT NOCOPY VARCHAR2
4588: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4589: )
4590: IS
4584: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4585: , p_owning_application IN VARCHAR2
4586: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
4587: , x_return_status OUT NOCOPY VARCHAR2
4588: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4589: )
4590: IS
4591: -- l_error_count number;
4592: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4589: )
4590: IS
4591: -- l_error_count number;
4592: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4593: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4594: BEGIN
4595: x_return_status := FND_API.G_RET_STS_SUCCESS;
4596: l_rec.Measure_id := p_Measure_rec.Measure_id;
4597: l_rec.Application_id := p_application_rec.application_id;
4654: , p_all_info IN VARCHAR2
4655: , x_owning_Application_rec OUT NOCOPY BIS_Application_PVT.Application_Rec_Type
4656: , x_Application_tbl OUT NOCOPY BIS_Application_PVT.Application_Tbl_Type
4657: , x_return_status OUT NOCOPY VARCHAR2
4658: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4659: )
4660: IS
4661: l_tbl BIS_Application_Measure_PVT.Application_Measure_Tbl_Type;
4662: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4658: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4659: )
4660: IS
4661: l_tbl BIS_Application_Measure_PVT.Application_Measure_Tbl_Type;
4662: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4663: BEGIN
4664: x_return_status := FND_API.G_RET_STS_SUCCESS;
4665:
4666: BIS_APPLICATION_MEASURE_PVT.Retrieve_Application_Measures( p_api_version
4713: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4714: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4715: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4716: , p_owning_application IN VARCHAR2
4717: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
4718: , x_return_status OUT NOCOPY VARCHAR2
4719: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4720: )
4721: IS
4715: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4716: , p_owning_application IN VARCHAR2
4717: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
4718: , x_return_status OUT NOCOPY VARCHAR2
4719: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4720: )
4721: IS
4722: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4723: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4719: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4720: )
4721: IS
4722: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4723: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4724: BEGIN
4725: x_return_status := FND_API.G_RET_STS_SUCCESS;
4726:
4727: l_rec.Measure_id := p_Measure_rec.Measure_id;
4767: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4768: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4769: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4770: , x_return_status OUT NOCOPY VARCHAR2
4771: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4772: )
4773: IS
4774: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4775: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4771: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4772: )
4773: IS
4774: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4775: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4776: BEGIN
4777: x_return_status := FND_API.G_RET_STS_SUCCESS;
4778:
4779: l_rec.Measure_id := p_Measure_rec.Measure_id;
4816: ( p_api_version IN NUMBER
4817: , p_commit IN VARCHAR2 := FND_API.G_FALSE
4818: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4819: , x_return_status OUT NOCOPY VARCHAR2
4820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4821: )
4822: IS
4823: l_rec BIS_APPLICATION_PVT.Application_Rec_type;
4824: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4821: )
4822: IS
4823: l_rec BIS_APPLICATION_PVT.Application_Rec_type;
4824: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4825: BEGIN
4826: x_return_status := FND_API.G_RET_STS_SUCCESS;
4827:
4828: -- we should call the delete API on BIS_APPLICATION_MEASURE
4874: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4875: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4876: , p_timestamp IN VARCHAR := NULL
4877: , x_return_status OUT NOCOPY VARCHAR2
4878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4879: )
4880: IS
4881: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4882: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4879: )
4880: IS
4881: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4882: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4883: BEGIN
4884: x_return_status := FND_API.G_RET_STS_SUCCESS;
4885:
4886: l_rec.Measure_id := p_Measure_rec.Measure_id;
4923: , p_Measure_rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4924: , p_application_rec IN BIS_Application_PVT.Application_Rec_Type
4925: , x_last_update_date OUT NOCOPY DATE
4926: , x_return_status OUT NOCOPY VARCHAR2
4927: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4928: )
4929: IS
4930: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4931: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4927: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4928: )
4929: IS
4930: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
4931: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4932: BEGIN
4933: x_return_status := FND_API.G_RET_STS_SUCCESS;
4934:
4935: l_rec.Measure_id := p_Measure_rec.Measure_id;
4981: -- IF either org or time exists then return true here. As it should never
4982: -- happen that, only org got migrated and not time
4983: l_org_time_exists := TRUE;
4984:
4985: IF (BIS_UTILITIES_PUB.Value_Missing(p_Org_Dimension_Id) = FND_API.G_TRUE
4986: OR BIS_UTILITIES_PUB.Value_NULL(p_Org_Dimension_Id) = FND_API.G_TRUE)
4987: THEN
4988: l_org_time_exists := FALSE;
4989: GOTO returnfromproc;
4982: -- happen that, only org got migrated and not time
4983: l_org_time_exists := TRUE;
4984:
4985: IF (BIS_UTILITIES_PUB.Value_Missing(p_Org_Dimension_Id) = FND_API.G_TRUE
4986: OR BIS_UTILITIES_PUB.Value_NULL(p_Org_Dimension_Id) = FND_API.G_TRUE)
4987: THEN
4988: l_org_time_exists := FALSE;
4989: GOTO returnfromproc;
4990: END IF;
4988: l_org_time_exists := FALSE;
4989: GOTO returnfromproc;
4990: END IF;
4991:
4992: IF (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_Id) = FND_API.G_TRUE
4993: OR BIS_UTILITIES_PUB.Value_NULL(p_Time_Dimension_Id) = FND_API.G_TRUE)
4994: THEN
4995: l_org_time_exists := FALSE;
4996: GOTO returnfromproc;
4989: GOTO returnfromproc;
4990: END IF;
4991:
4992: IF (BIS_UTILITIES_PUB.Value_Missing(p_Time_Dimension_Id) = FND_API.G_TRUE
4993: OR BIS_UTILITIES_PUB.Value_NULL(p_Time_Dimension_Id) = FND_API.G_TRUE)
4994: THEN
4995: l_org_time_exists := FALSE;
4996: GOTO returnfromproc;
4997: END IF;
5221: Procedure Translate_Measure_by_lang
5222: ( p_api_version IN NUMBER
5223: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5224: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
5225: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
5226: , p_lang IN VARCHAR2
5227: , p_source_lang IN VARCHAR2
5228: , x_return_status OUT NOCOPY VARCHAR2
5229: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5225: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
5226: , p_lang IN VARCHAR2
5227: , p_source_lang IN VARCHAR2
5228: , x_return_status OUT NOCOPY VARCHAR2
5229: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5230: )
5231: IS
5232: l_user_id NUMBER;
5233: l_login_id NUMBER;
5231: IS
5232: l_user_id NUMBER;
5233: l_login_id NUMBER;
5234: l_count NUMBER := 0;
5235: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
5236:
5237: BEGIN
5238:
5239: SAVEPOINT TransMeasByLangPvt;
5237: BEGIN
5238:
5239: SAVEPOINT TransMeasByLangPvt;
5240:
5241: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
5242:
5243: l_login_id := fnd_global.LOGIN_ID;
5244:
5245: Update bis_INDICATORS_TL
5350: PROCEDURE Load_Measure_Extension
5351: ( p_api_version IN NUMBER
5352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5353: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
5354: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
5355: , x_return_status OUT NOCOPY VARCHAR2
5356: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5357: )
5358: IS
5352: , p_commit IN VARCHAR2 := FND_API.G_FALSE
5353: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
5354: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
5355: , x_return_status OUT NOCOPY VARCHAR2
5356: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5357: )
5358: IS
5359: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
5360: l_Return_Status VARCHAR2(2000);
5355: , x_return_status OUT NOCOPY VARCHAR2
5356: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
5357: )
5358: IS
5359: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
5360: l_Return_Status VARCHAR2(2000);
5361: l_Msg_Count NUMBER;
5362: l_Msg_Data VARCHAR2(2000);
5363: l_Measure_Extension_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
5393: l_Measure_Extension_Rec.Last_Update_Date := p_Measure_Rec.Last_Update_Date;
5394: l_Measure_Extension_Rec.Last_Update_Login := p_Measure_Rec.Last_Update_Login;
5395:
5396: -- From the UI Custom Mode is FORCE but when uploaded through LCT it is NULL
5397: IF ( p_owner IS NOT NULL AND p_owner <> BIS_UTILITIES_PUB.G_CUSTOM_OWNER ) THEN
5398: l_custom_mode := NULL;
5399: ELSE
5400: l_custom_mode := 'FORCE';
5401: END IF;
5414: BIS_UTILITIES_PVT.Add_Error_Message
5415: ( p_error_msg_id => NULL
5416: , p_error_description => l_Msg_Data
5417: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
5418: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
5419: , p_error_table => l_error_tbl
5420: , x_error_table => x_error_tbl
5421: );
5422: RAISE FND_API.G_EXC_ERROR;