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

Line 36: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER --2465354

32: ( p_api_version IN NUMBER
33: , p_commit IN VARCHAR2 := FND_API.G_FALSE
34: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
35: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
36: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER --2465354
37: , x_return_status OUT NOCOPY VARCHAR2
38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39: )
40: IS

Line 38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

34: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
35: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
36: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER --2465354
37: , x_return_status OUT NOCOPY VARCHAR2
38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39: )
40: IS
41: l_user_id number;
42: l_login_id number;

Line 44: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

40: IS
41: l_user_id number;
42: l_login_id number;
43: l_id number;
44: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
45:
46: --added this
47: DUPLICATE_DIMENSION_VALUE EXCEPTION;
48: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);

Line 65: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63:
64: --2465354
65: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
66: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
67: ELSE
68: l_user_id := fnd_global.USER_ID;
69: END IF;

Line 66: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

62: END IF;
63:
64: --2465354
65: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
66: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
67: ELSE
68: l_user_id := fnd_global.USER_ID;
69: END IF;
70: --2465354

Line 117: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

113: BIS_UTILITIES_PVT.Add_Error_Message
114: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
115: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
116: , p_error_proc_name => G_PKG_NAME||'.Create_Measure_Security'
117: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
118: , p_error_table => l_error_tbl
119: , x_error_table => x_error_tbl
120: );
121: WHEN NO_DATA_FOUND THEN

Line 157: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

153: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
154: , x_Measure_Security_tbl
155: OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
156: , x_return_status OUT NOCOPY VARCHAR2
157: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
158: )
159: IS
160: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
161: l_resp_rec BIS_Responsibility_PVT.Responsibility_rec_Type;

Line 170: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

166: from bis_indicator_resps
167: where TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id;
168:
169: l_flag number := 0;
170: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
171: BEGIN
172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174: -- htp.p('in Retrieve_Measure_Securities ');

Line 277: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

273: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
274: , x_Measure_Security_tbl
275: OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
276: , x_return_status OUT NOCOPY VARCHAR2
277: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
278: )
279: IS
280: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
281: l_resp_rec BIS_Responsibility_PVT.Responsibility_rec_Type;

Line 295: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

291: and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID and b.TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id
292: order by RESPONSIBILITY_NAME;
293:
294: l_flag number := 0;
295: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
296: BEGIN
297:
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:

Line 382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

378: ( p_api_version IN NUMBER
379: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
380: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: BEGIN

Line 385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: BEGIN
387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388: NULL;
389:

Line 426: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

422: , p_commit IN VARCHAR2 := FND_API.G_FALSE
423: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
424: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
425: , x_return_status OUT NOCOPY VARCHAR2
426: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
427: )
428: IS
429: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
430: BEGIN

Line 429: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

425: , x_return_status OUT NOCOPY VARCHAR2
426: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
427: )
428: IS
429: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
430: BEGIN
431:
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: Validate_Measure_Security

Line 478: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

474: ( p_api_version IN NUMBER
475: , p_commit IN VARCHAR2 := FND_API.G_FALSE
476: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
477: , x_return_status OUT NOCOPY VARCHAR2
478: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
479: )
480: is
481: begin
482:

Line 506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

502: ( p_api_version IN NUMBER
503: , p_commit IN VARCHAR2 := FND_API.G_FALSE
504: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
505: , x_return_status OUT NOCOPY VARCHAR2
506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
507: )
508: IS
509: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
510: BEGIN

Line 509: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

505: , x_return_status OUT NOCOPY VARCHAR2
506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
507: )
508: IS
509: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
510: BEGIN
511:
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513: Validate_Measure_Security

Line 564: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

560: ( p_api_version IN NUMBER
561: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
562: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
563: , x_return_status OUT NOCOPY VARCHAR2
564: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
565: )
566: IS
567: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
568: l_error VARCHAR2(10) := FND_API.G_FALSE;

Line 567: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

563: , x_return_status OUT NOCOPY VARCHAR2
564: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
565: )
566: IS
567: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
568: l_error VARCHAR2(10) := FND_API.G_FALSE;
569: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
570: BEGIN
571:

Line 569: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

565: )
566: IS
567: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
568: l_error VARCHAR2(10) := FND_API.G_FALSE;
569: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
570: BEGIN
571:
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573: BEGIN

Line 683: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

679: ( p_api_version IN NUMBER
680: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
681: , x_Measure_Security_Rec OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
682: , x_return_status OUT NOCOPY VARCHAR2
683: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
684: )
685: IS
686: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
687: BEGIN

Line 686: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

682: , x_return_status OUT NOCOPY VARCHAR2
683: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
684: )
685: IS
686: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
687: BEGIN
688:
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690: x_Measure_Security_Rec := p_Measure_Security_Rec;

Line 692: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Security_Rec.Target_Level_id)=

688:
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690: x_Measure_Security_Rec := p_Measure_Security_Rec;
691:
692: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Security_Rec.Target_Level_id)=
693: FND_API.G_TRUE
694: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Security_Rec.Target_Level_id)=
695: FND_API.G_TRUE) THEN
696: BIS_Target_Level_PVT.Value_ID_Conversion

Line 694: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Security_Rec.Target_Level_id)=

690: x_Measure_Security_Rec := p_Measure_Security_Rec;
691:
692: if (BIS_UTILITIES_PUB.Value_Missing(p_Measure_Security_Rec.Target_Level_id)=
693: FND_API.G_TRUE
694: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Security_Rec.Target_Level_id)=
695: FND_API.G_TRUE) THEN
696: BIS_Target_Level_PVT.Value_ID_Conversion
697: ( p_api_version => 1.0
698: , p_Target_Level_Short_Name =>

Line 750: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

746: , p_user_id IN NUMBER
747: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
748: , x_Measure_security_Tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
749: , x_return_status OUT NOCOPY VARCHAR2
750: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
751: )
752: is
753:
754: CURSOR ind_res_id IS

Line 807: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

803: and il.target_level_name = p_target_level_rec.target_level_name;
804:
805: l_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
806: l_flag number := 0;
807: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
808: BEGIN
809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_Rec.Target_Level_id)=

Line 811: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_Rec.Target_Level_id)=

807: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
808: BEGIN
809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_Rec.Target_Level_id)=
812: FND_API.G_TRUE)
813: THEN
814: for cr in ind_res_id loop
815: l_flag := 1;

Line 825: ELSIF (BIS_UTILITIES_PUB.Value_Not_Missing

821: l_rec.Responsibility_Name := cr.RESPONSIBILITY_NAME ;
822: x_Measure_security_Tbl(x_Measure_security_Tbl.count+1) := l_rec;
823: end loop;
824:
825: ELSIF (BIS_UTILITIES_PUB.Value_Not_Missing
826: (p_target_level_Rec.Target_Level_short_name)=FND_API.G_TRUE)
827: THEN
828: for cr in ind_res_short_name loop
829: l_flag := 1;

Line 839: ELSIF (BIS_UTILITIES_PUB.Value_Not_Missing

835: l_rec.Responsibility_Name := cr.RESPONSIBILITY_NAME ;
836: x_Measure_security_Tbl(x_Measure_security_Tbl.count+1) := l_rec;
837: end loop;
838:
839: ELSIF (BIS_UTILITIES_PUB.Value_Not_Missing
840: (p_target_level_Rec.Target_Level_name)=FND_API.G_TRUE)
841: THEN
842: for cr in ind_res_name loop
843: l_flag := 1;

Line 859: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

855: BIS_UTILITIES_PVT.Add_Error_Message
856: ( p_error_msg_name => 'BIS_INVALID_MSR_SECURITY_VALUE'
857: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
858: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level_User_Resps'
859: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
860: , p_error_table => l_error_tbl
861: , x_error_table => x_error_tbl
862: );
863: RAISE FND_API.G_EXC_ERROR;

Line 875: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

871: BIS_UTILITIES_PVT.Add_Error_Message
872: ( p_error_msg_name => 'BIS_INVALID_MSR_SECURITY_VALUE'
873: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
874: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level_User_Resps'
875: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
876: , p_error_table => l_error_tbl
877: , x_error_table => x_error_tbl
878: );
879: RAISE FND_API.G_EXC_ERROR;

Line 922: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

918: , p_user_id IN NUMBER
919: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
920: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
921: , x_return_status OUT NOCOPY VARCHAR2
922: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
923: )
924: IS
925: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
926: l_error VARCHAR2(10) := FND_API.G_FALSE;

Line 925: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

921: , x_return_status OUT NOCOPY VARCHAR2
922: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
923: )
924: IS
925: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
926: l_error VARCHAR2(10) := FND_API.G_FALSE;
927: l_dlc_sec VARCHAR2(1);
928: CURSOR c_resp IS
929: SELECT responsibility_id

Line 958: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

954: BIS_UTILITIES_PVT.Add_Error_Message
955: ( p_error_msg_name => 'BIS_INVALID_MSR_SECURITY_VALUE'
956: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
957: , p_error_proc_name => G_PKG_NAME||'.Validate_Measure_Security'
958: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
959: , p_error_table => l_error_tbl
960: , x_error_table => x_error_tbl
961: );
962: x_return_status := FND_API.G_RET_STS_ERROR;

Line 985: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

981: BIS_UTILITIES_PVT.Add_Error_Message
982: ( p_error_msg_name => 'BIS_INVALID_MSR_SECUIRTY_VALUE'
983: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
984: , p_error_proc_name => G_PKG_NAME||'.Validate_Measure_Security'
985: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
986: , p_error_table => l_error_tbl
987: , x_error_table => x_error_tbl
988: );
989: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1034: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1030: PROCEDURE Delete_TargetLevel_Resp
1031: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1032: , p_measure_short_name IN VARCHAR2
1033: , x_return_status OUT NOCOPY VARCHAR2
1034: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1035: )
1036: IS
1037: l_indicator_id NUMBER;
1038: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1038: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1034: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1035: )
1036: IS
1037: l_indicator_id NUMBER;
1038: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1039: CURSOR target_level_cursor(cp_indicator_id IN NUMBER) IS
1040: SELECT target_level_id FROM bis_target_levels
1041: WHERE indicator_id = cp_indicator_id;
1042:

Line 1065: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1061: BIS_UTILITIES_PVT.Add_Error_Message
1062: ( p_error_msg_name => 'BIS_INVALID_MEASURE_SHORT_NAME'
1063: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1064: , p_error_proc_name => G_PKG_NAME||'.Delete_TargetLevel_Resp'
1065: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1066: , p_error_table => l_error_tbl
1067: , x_error_table => x_error_tbl
1068: );
1069: WHEN FND_API.G_EXC_ERROR THEN