DBA Data[Home] [Help]

APPS.BIS_MEASURE_SECURITY_PVT dependencies on BIS_UTILITIES_PVT

Line 113: BIS_UTILITIES_PVT.Add_Error_Message

109: --added this
110: WHEN DUPLICATE_DIMENSION_VALUE THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: l_error_tbl := x_error_tbl;
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

Line 134: BIS_UTILITIES_PVT.Add_Error_Message

130: when others then
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: --added last two params
133: l_error_tbl := x_error_tbl;
134: BIS_UTILITIES_PVT.Add_Error_Message
135: ( p_error_msg_id => SQLCODE
136: , p_error_description => SQLERRM
137: , p_error_proc_name => G_PKG_NAME||'.Create_Measure_Security'
138: , p_error_table => l_error_tbl

Line 252: BIS_UTILITIES_PVT.Add_Error_Message

248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
249: IF sec_cursor%ISOPEN THEN CLOSE sec_cursor; END IF;
250: --added last two params
251: l_error_tbl := x_error_tbl;
252: BIS_UTILITIES_PVT.Add_Error_Message
253: ( p_error_msg_id => SQLCODE
254: , p_error_description => SQLERRM
255: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure_Securities'
256: , p_error_table => l_error_tbl

Line 361: BIS_UTILITIES_PVT.Add_Error_Message

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: IF sec_cursor%ISOPEN THEN CLOSE sec_cursor; END IF;
359: --added last two params
360: l_error_tbl := x_error_tbl;
361: BIS_UTILITIES_PVT.Add_Error_Message
362: ( p_error_msg_id => SQLCODE
363: , p_error_description => SQLERRM
364: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure_Securities'
365: , p_error_table => l_error_tbl

Line 405: BIS_UTILITIES_PVT.Add_Error_Message

401: when others then
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: --added last two params
404: l_error_tbl := x_error_tbl;
405: BIS_UTILITIES_PVT.Add_Error_Message
406: ( p_error_msg_id => SQLCODE
407: , p_error_description => SQLERRM
408: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure_Security'
409: , p_error_table => l_error_tbl

Line 459: BIS_UTILITIES_PVT.Add_Error_Message

455: when others then
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: --added last two params
458: l_error_tbl := x_error_tbl;
459: BIS_UTILITIES_PVT.Add_Error_Message
460: ( p_error_msg_id => SQLCODE
461: , p_error_description => SQLERRM
462: , p_error_proc_name => G_PKG_NAME||'.Update_Measure_Security'
463: , p_error_table => l_error_tbl

Line 547: BIS_UTILITIES_PVT.Add_Error_Message

543: when others then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: --added last two params
546: l_error_tbl := x_error_tbl;
547: BIS_UTILITIES_PVT.Add_Error_Message
548: ( p_error_msg_id => SQLCODE
549: , p_error_description => SQLERRM
550: , p_error_proc_name => G_PKG_NAME||'.Delete_Measure_Security'
551: , p_error_table => l_error_tbl

Line 586: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

582: -- when FND_API.G_EXC_ERROR then
583: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
584: l_error := FND_API.G_TRUE;
585: l_error_Tbl_p := x_error_Tbl;
586: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
587: , l_error_Tbl
588: , x_error_tbl
589: );
590: x_return_status := FND_API.G_RET_STS_ERROR;

Line 607: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

603: -- when FND_API.G_EXC_ERROR then
604: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
605: l_error := FND_API.G_TRUE;
606: l_error_Tbl_p := x_error_Tbl;
607: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
608: , l_error_Tbl
609: , x_error_tbl
610: );
611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 627: BIS_UTILITIES_PVT.concatenateErrorTables( x_error_Tbl

623:
624: --changed this
625: /*
626: if (x_error_tbl.count > 0) then
627: BIS_UTILITIES_PVT.concatenateErrorTables( x_error_Tbl
628: , l_error_Tbl
629: , x_error_tbl
630: );
631: RAISE FND_API.G_EXC_ERROR;

Line 638: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

634: --added this
635: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
636: l_error := FND_API.G_TRUE;
637: l_error_Tbl_p := x_error_Tbl;
638: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
639: , l_error_Tbl
640: , x_error_tbl
641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 666: BIS_UTILITIES_PVT.Add_Error_Message

662: when others then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: --added last two params
665: l_error_tbl := x_error_tbl;
666: BIS_UTILITIES_PVT.Add_Error_Message
667: ( p_error_msg_id => SQLCODE
668: , p_error_description => SQLERRM
669: , p_error_proc_name => G_PKG_NAME||'.Validate_Measure_Security'
670: , p_error_table => l_error_tbl

Line 733: BIS_UTILITIES_PVT.Add_Error_Message

729: when others then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
731: --added last two params
732: l_error_tbl := x_error_tbl;
733: BIS_UTILITIES_PVT.Add_Error_Message
734: ( p_error_msg_id => SQLCODE
735: , p_error_description => SQLERRM
736: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
737: , p_error_table => l_error_tbl

Line 855: BIS_UTILITIES_PVT.Add_Error_Message

851: end loop;
852: ELSE
853: --added message
854: l_error_tbl := x_error_tbl;
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

Line 871: BIS_UTILITIES_PVT.Add_Error_Message

867: --added this
868: if(l_flag =0) then
869: --added message
870: l_error_tbl := x_error_tbl;
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

Line 903: BIS_UTILITIES_PVT.Add_Error_Message

899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900: IF ind_res_name%ISOPEN THEN CLOSE ind_res_name; END IF;
901: --added last two params
902: l_error_tbl := x_error_tbl;
903: BIS_UTILITIES_PVT.Add_Error_Message
904: ( p_error_msg_id => SQLCODE
905: , p_error_description => SQLERRM
906: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Tar_Level_User_Resps'
907: , p_error_table => l_error_tbl

Line 954: BIS_UTILITIES_PVT.Add_Error_Message

950: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
951: l_error := FND_API.G_TRUE;
952:
953: l_error_tbl := x_error_tbl;
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

Line 981: BIS_UTILITIES_PVT.Add_Error_Message

977: END LOOP;
978: END LOOP;
979: IF (l_dlc_sec = 'N') THEN
980: l_error_tbl := x_error_tbl;
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

Line 1017: BIS_UTILITIES_PVT.Add_Error_Message

1013: when others then
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: --added last two params
1016: l_error_tbl := x_error_tbl;
1017: BIS_UTILITIES_PVT.Add_Error_Message
1018: ( p_error_msg_id => SQLCODE
1019: , p_error_description => SQLERRM
1020: , p_error_proc_name => G_PKG_NAME||'.Validate_Measure_Security'
1021: , p_error_table => l_error_tbl

Line 1061: BIS_UTILITIES_PVT.Add_Error_Message

1057: WHEN NO_DATA_FOUND THEN
1058: ROLLBACK TO delete_resps;
1059: x_return_status := FND_API.G_RET_STS_ERROR ;
1060: l_error_tbl := x_error_tbl;
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

Line 1079: BIS_UTILITIES_PVT.Add_Error_Message

1075: WHEN OTHERS THEN
1076: ROLLBACK TO delete_resps;
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078: l_error_tbl := x_error_tbl;
1079: BIS_UTILITIES_PVT.Add_Error_Message
1080: ( p_error_msg_id => SQLCODE
1081: , p_error_description => SQLERRM
1082: , p_error_proc_name => G_PKG_NAME||'.Delete_TargetLevel_Resp'
1083: , p_error_table => l_error_tbl