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_ACTUAL_VALIDATE_PVT dependencies on BIS_UTILITIES_PUB

Line 29: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

25: ( p_api_version IN NUMBER
26: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
30: )
31: IS
32: --
33: l_Target_Level_ID NUMBER;

Line 37: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

33: l_Target_Level_ID NUMBER;
34: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
35: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
36: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
37: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
38: --
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:

Line 48: IF( BIS_UTILITIES_PUB.Value_Missing(l_ACTUAL_Rec.TARGET_LEVEL_ID)

44: -- );
45:
46: l_Actual_Rec := p_Actual_Rec;
47: --
48: IF( BIS_UTILITIES_PUB.Value_Missing(l_ACTUAL_Rec.TARGET_LEVEL_ID)
49: = FND_API.G_TRUE
50: ) THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSE

Line 103: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

99: ( p_api_version IN NUMBER
100: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
101: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
102: , x_return_status OUT NOCOPY VARCHAR2
103: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
104: )
105: IS
106: --
107: --l_bisbv_target_levels BISBV_TARGET_LEVELS%ROWTYPE;

Line 115: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.Time_Level_Value_ID)

111: --
112: BEGIN
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: --
115: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.Time_Level_Value_ID)
116: = FND_API.G_TRUE
117: ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE

Line 184: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

180: ( p_api_version IN NUMBER
181: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
182: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
183: , x_return_status OUT NOCOPY VARCHAR2
184: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
185: )
186: IS
187: --
188: --l_bisbv_TARGET_levels BISBV_TARGET_LEVELS%ROWTYPE;

Line 195: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ORG_LEVEL_VALUE_ID)

191: --
192: BEGIN
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: --
195: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ORG_LEVEL_VALUE_ID)
196: = FND_API.G_TRUE
197: ) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: ELSE

Line 263: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

259: ( p_api_version IN NUMBER
260: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
261: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
262: , x_return_status OUT NOCOPY VARCHAR2
263: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
264: )
265: IS
266: --
267: --l_bisbv_TARGET_levels BISBV_TARGET_LEVELS%ROWTYPE;

Line 272: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

268: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
269: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
270: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
271: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
272: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
273: --
274: BEGIN
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: --

Line 340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

336: ( p_api_version IN NUMBER
337: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
338: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
339: , x_return_status OUT NOCOPY VARCHAR2
340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
341: )
342: IS
343: --
344: --l_bisbv_TARGET_levels BISBV_TARGET_LEVELS%ROWTYPE;

Line 349: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

345: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
346: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
347: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
348: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
349: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
350: --
351: BEGIN
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: --

Line 420: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

416: ( p_api_version IN NUMBER
417: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
418: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
419: , x_return_status OUT NOCOPY VARCHAR2
420: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
421: )
422: IS
423: --
424: --l_bisbv_TARGET_levels bisbv_TARGET_LEVELS%ROWTYPE;

Line 429: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

425: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
426: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
427: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
428: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
429: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
430: --
431: BEGIN
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: --

Line 499: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

495: ( p_api_version IN NUMBER
496: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
497: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
498: , x_return_status OUT NOCOPY VARCHAR2
499: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
500: )
501: IS
502: --
503: --l_bisbv_TARGET_levels bisbv_TARGET_LEVELS%ROWTYPE;

Line 508: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

504: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
505: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
506: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
507: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
508: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
509: --
510: BEGIN
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: --

Line 577: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

573: ( p_api_version IN NUMBER
574: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
575: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
576: , x_return_status OUT NOCOPY VARCHAR2
577: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
578: )
579: IS
580: --
581: --l_bisbv_TARGET_levels bisbv_TARGET_LEVELS%ROWTYPE;

Line 586: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

582: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
583: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
584: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
585: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
586: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
587: --
588: BEGIN
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590: --

Line 656: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

652: ( p_api_version IN NUMBER
653: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
654: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
655: , x_return_status OUT NOCOPY VARCHAR2
656: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
657: )
658: IS
659: --
660: --l_bisbv_TARGET_levels bisbv_TARGET_LEVELS%ROWTYPE;

Line 665: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

661: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
662: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
663: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
664: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
665: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
666: --
667: BEGIN
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669: --

Line 735: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

731: ( p_api_version IN NUMBER
732: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
733: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
734: , x_return_status OUT NOCOPY VARCHAR2
735: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
736: )
737: IS
738: --
739: --l_bisbv_TARGET_levels bisbv_TARGET_LEVELS%ROWTYPE;

Line 744: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

740: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
741: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
742: l_bisbv_target_levels_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
743: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
744: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
745: --
746: BEGIN
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748: --

Line 814: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

810: ( p_api_version IN NUMBER
811: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
812: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
813: , x_return_status OUT NOCOPY VARCHAR2
814: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
815: )
816: IS
817: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
818: BEGIN

Line 817: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

813: , x_return_status OUT NOCOPY VARCHAR2
814: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
815: )
816: IS
817: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
818: BEGIN
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: --
821: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ACTUAL)

Line 821: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ACTUAL)

817: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
818: BEGIN
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: --
821: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ACTUAL)
822: = FND_API.G_TRUE
823: ) THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSE

Line 855: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

851: ( p_api_version IN NUMBER
852: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
853: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
854: , x_return_status OUT NOCOPY VARCHAR2
855: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
856: )
857: IS
858: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
859: BEGIN

Line 858: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

854: , x_return_status OUT NOCOPY VARCHAR2
855: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
856: )
857: IS
858: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
859: BEGIN
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861: --
862: -- commented out NOCOPY as they are changed now with the ranges being %

Line 865: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_LOW)

861: --
862: -- commented out NOCOPY as they are changed now with the ranges being %
863: -- dont know exact validations yet
864: /*
865: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_LOW)
866: = FND_API.G_TRUE
867: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_HIGH)
868: = FND_API.G_TRUE
869: AND p_ACTUAL_Rec.RANGE1_LOW > p_ACTUAL_Rec.RANGE1_HIGH

Line 867: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_HIGH)

863: -- dont know exact validations yet
864: /*
865: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_LOW)
866: = FND_API.G_TRUE
867: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_HIGH)
868: = FND_API.G_TRUE
869: AND p_ACTUAL_Rec.RANGE1_LOW > p_ACTUAL_Rec.RANGE1_HIGH
870: ) THEN
871: RAISE FND_API.G_EXC_ERROR;

Line 874: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_LOW)

870: ) THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: --
874: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_LOW)
875: = FND_API.G_TRUE
876: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_HIGH)
877: = FND_API.G_TRUE
878: AND p_ACTUAL_Rec.RANGE2_LOW > p_ACTUAL_Rec.RANGE2_HIGH

Line 876: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_HIGH)

872: END IF;
873: --
874: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_LOW)
875: = FND_API.G_TRUE
876: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_HIGH)
877: = FND_API.G_TRUE
878: AND p_ACTUAL_Rec.RANGE2_LOW > p_ACTUAL_Rec.RANGE2_HIGH
879: ) THEN
880: RAISE FND_API.G_EXC_ERROR;

Line 883: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_LOW)

879: ) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882: --
883: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_LOW)
884: = FND_API.G_TRUE
885: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_HIGH)
886: = FND_API.G_TRUE
887: AND p_ACTUAL_Rec.RANGE3_LOW > p_ACTUAL_Rec.RANGE3_HIGH

Line 885: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_HIGH)

881: END IF;
882: --
883: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_LOW)
884: = FND_API.G_TRUE
885: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_HIGH)
886: = FND_API.G_TRUE
887: AND p_ACTUAL_Rec.RANGE3_LOW > p_ACTUAL_Rec.RANGE3_HIGH
888: ) THEN
889: RAISE FND_API.G_EXC_ERROR;