[Home] [Help]
1247: RAISE FND_API.G_EXC_ERROR;
1248: END IF;
1249:
1250: --added this call to validate Org Dimension
1251: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension_Id
1252: ( p_api_version => p_api_version
1253: , p_dimension_id => p_Org_Dimension_ID
1254: , p_dimension_short_name => FND_API.G_MISS_CHAR
1255: , x_return_status => x_return_status
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261:
1262: --added this call to validate Time Dimension
1263: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension_Id
1264: ( p_api_version => p_api_version
1265: , p_dimension_id => p_Time_Dimension_ID
1266: , p_dimension_short_name => FND_API.G_MISS_CHAR
1267: , x_return_status => x_return_status
2841: RAISE FND_API.G_EXC_ERROR;
2842: END IF;
2843:
2844: --added this call to validate Org Dimension
2845: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension_Id
2846: ( p_api_version => p_api_version
2847: , p_dimension_id => p_Org_Dimension_ID
2848: , p_dimension_short_name => FND_API.G_MISS_CHAR
2849: , x_return_status => x_return_status
2853: RAISE FND_API.G_EXC_ERROR;
2854: END IF;
2855:
2856: --added this call to validate Time Dimension
2857: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension_Id
2858: ( p_api_version => p_api_version
2859: , p_dimension_id => p_Time_Dimension_ID
2860: , p_dimension_short_name => FND_API.G_MISS_CHAR
2861: , x_return_status => x_return_status
3313: l_source_column varchar2(30);
3314: BEGIN
3315:
3316: BEGIN
3317: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension1_Id
3318: ( p_api_version => p_api_version
3319: , p_validation_level => p_validation_level
3320: , p_MEASURE_Rec => p_MEASURE_Rec
3321: , x_return_status => x_return_status
3334: END IF;
3335: END;
3336:
3337: BEGIN
3338: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension2_Id
3339: ( p_api_version => p_api_version
3340: , p_validation_level => p_validation_level
3341: , p_MEASURE_Rec => p_MEASURE_Rec
3342: , x_return_status => x_return_status
3355: END IF;
3356: END;
3357:
3358: BEGIN
3359: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension3_Id
3360: ( p_api_version => p_api_version
3361: , p_validation_level => p_validation_level
3362: , p_MEASURE_Rec => p_MEASURE_Rec
3363: , x_return_status => x_return_status
3376: END IF;
3377: END;
3378:
3379: BEGIN
3380: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension4_Id
3381: ( p_api_version => p_api_version
3382: , p_validation_level => p_validation_level
3383: , p_MEASURE_Rec => p_MEASURE_Rec
3384: , x_return_status => x_return_status
3398: END;
3399:
3400:
3401: BEGIN
3402: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension5_Id
3403: ( p_api_version => p_api_version
3404: , p_validation_level => p_validation_level
3405: , p_MEASURE_Rec => p_MEASURE_Rec
3406: , x_return_status => x_return_status
3419: END IF;
3420: END;
3421:
3422: BEGIN
3423: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension6_Id
3424: ( p_api_version => p_api_version
3425: , p_validation_level => p_validation_level
3426: , p_MEASURE_Rec => p_MEASURE_Rec
3427: , x_return_status => x_return_status
3440: END IF;
3441: END;
3442:
3443: BEGIN
3444: BIS_MEASURE_VALIDATE_PVT.Validate_Dimension7_Id
3445: ( p_api_version => p_api_version
3446: , p_validation_level => p_validation_level
3447: , p_MEASURE_Rec => p_MEASURE_Rec
3448: , x_return_status => x_return_status
3462: END;
3463:
3464: -- Fix for 1850860 starts here
3465: BEGIN
3466: BIS_MEASURE_VALIDATE_PVT.Val_Actual_Data_Sour_Type_Wrap
3467: ( p_api_version => p_api_version
3468: , p_validation_level => p_validation_level
3469: , p_MEASURE_Rec => p_MEASURE_Rec
3470: , x_return_status => x_return_status
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
3516: , p_MEASURE_Rec => p_MEASURE_Rec
3517: , x_return_status => x_return_status
3530: END IF;
3531: END;
3532: --
3533: BEGIN
3534: BIS_MEASURE_VALIDATE_PVT.Val_Func_Name_Wrap
3535: ( p_api_version => p_api_version
3536: , p_validation_level => p_validation_level
3537: , p_MEASURE_Rec => p_MEASURE_Rec
3538: , x_return_status => x_return_status
3551: END IF;
3552: END;
3553: --
3554: BEGIN
3555: BIS_MEASURE_VALIDATE_PVT.Val_Comparison_Source_Wrap
3556: ( p_api_version => p_api_version
3557: , p_validation_level => p_validation_level
3558: , p_MEASURE_Rec => p_MEASURE_Rec
3559: , x_return_status => x_return_status
3573: END;
3574: --
3575: END IF; -- 2240105
3576: BEGIN
3577: BIS_MEASURE_VALIDATE_PVT.Val_Incr_In_Measure_Wrap
3578: ( p_api_version => p_api_version
3579: , p_validation_level => p_validation_level
3580: , p_MEASURE_Rec => p_MEASURE_Rec
3581: , x_return_status => x_return_status
3595: END;
3596: -- Fix for 1850860 ends here
3597: -- 2440739
3598: BEGIN
3599: BIS_MEASURE_VALIDATE_PVT.Val_Enable_Link_Wrap
3600: ( p_api_version => p_api_version
3601: , p_validation_level => p_validation_level
3602: , p_MEASURE_Rec => p_MEASURE_Rec
3603: , x_return_status => x_return_status
3617:
3618: -- Need to add for ENABLED Column ?
3619: -- 3031053
3620: BEGIN
3621: BIS_MEASURE_VALIDATE_PVT.Val_Enabled_Wrap
3622: ( p_api_version => p_api_version
3623: , p_validation_level => p_validation_level
3624: , p_MEASURE_Rec => p_MEASURE_Rec
3625: , x_return_status => x_return_status
3636: END IF;
3637: END;
3638: -- 3031053
3639: BEGIN --3865711
3640: BIS_MEASURE_VALIDATE_PVT.Val_Obsolete_Wrap
3641: ( p_api_version => p_api_version
3642: , p_validation_level => p_validation_level
3643: , p_MEASURE_Rec => p_MEASURE_Rec
3644: , x_return_status => x_return_status
3655: END IF;
3656: END;
3657:
3658: BEGIN
3659: BIS_MEASURE_VALIDATE_PVT.Val_Measure_Type_Wrap
3660: ( p_api_version => p_api_version
3661: , p_validation_level => p_validation_level
3662: , p_MEASURE_Rec => p_MEASURE_Rec
3663: , x_return_status => x_return_status