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.

[Home] [Help]

APPS.BIS_ACTUAL_PVT dependencies on BIS_UTILITIES_PVT

Line 363: BIS_UTILITIES_PVT.Add_Error_Message

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

Line 516: BIS_UTILITIES_PVT.Add_Error_Message

512: , l_actual_rec.Report_Url; -- 1850860
513: IF cr_bv_actual%NOTFOUND THEN
514: CLOSE cr_bv_actual;
515: l_error_tbl := x_error_tbl;
516: BIS_UTILITIES_PVT.Add_Error_Message
517: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
518: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
519: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Actual'
520: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 552: BIS_UTILITIES_PVT.Add_Error_Message

548: IF cr_fv_actual%NOTFOUND THEN
549:
550: CLOSE cr_fv_actual;
551: l_error_tbl := x_error_tbl;
552: BIS_UTILITIES_PVT.Add_Error_Message
553: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
554: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
555: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Actual'
556: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 595: BIS_UTILITIES_PVT.Add_Error_Message

591: IF cr_bv_actual%ISOPEN THEN CLOSE cr_bv_actual; END IF;
592: IF cr_fv_actual%ISOPEN THEN CLOSE cr_fv_actual; END IF;
593: --added last two params
594: l_error_tbl := x_error_tbl;
595: BIS_UTILITIES_PVT.Add_Error_Message
596: ( p_error_msg_id => SQLCODE
597: , p_error_description => SQLERRM
598: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Actual'
599: , p_error_table => l_error_tbl

Line 712: BIS_UTILITIES_PVT.concatenateErrorTables

708: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
709: l_error := FND_API.G_TRUE;
710: x_return_status:= FND_API.G_RET_STS_ERROR;
711: l_error_tbl_p := x_error_Tbl;
712: BIS_UTILITIES_PVT.concatenateErrorTables
713: ( p_error_Tbl1 => l_error_Tbl_p
714: , p_error_Tbl2 => l_error_Tbl
715: , x_error_Tbl => x_error_Tbl
716: );

Line 736: BIS_UTILITIES_PVT.concatenateErrorTables

732: --added this
733: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
734: l_error := FND_API.G_TRUE;
735: x_return_status:= FND_API.G_RET_STS_ERROR;
736: BIS_UTILITIES_PVT.concatenateErrorTables
737: ( p_error_Tbl1 => x_error_Tbl
738: , p_error_Tbl2 => l_error_Tbl
739: , x_error_Tbl => x_error_Tbl
740: );

Line 761: BIS_UTILITIES_PVT.concatenateErrorTables

757: --added this
758: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
759: l_error := FND_API.G_TRUE;
760: x_return_status:= FND_API.G_RET_STS_ERROR;
761: BIS_UTILITIES_PVT.concatenateErrorTables
762: ( p_error_Tbl1 => x_error_Tbl
763: , p_error_Tbl2 => l_error_Tbl
764: , x_error_Tbl => x_error_Tbl
765: );

Line 788: BIS_UTILITIES_PVT.concatenateErrorTables

784: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
785: l_error := FND_API.G_TRUE;
786: x_return_status:= FND_API.G_RET_STS_ERROR;
787: l_error_tbl_p := x_error_Tbl;
788: BIS_UTILITIES_PVT.concatenateErrorTables
789: ( p_error_Tbl1 => l_error_Tbl_p
790: , p_error_Tbl2 => l_error_Tbl
791: , x_error_Tbl => x_error_Tbl
792: );

Line 814: BIS_UTILITIES_PVT.concatenateErrorTables

810: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
811: l_error := FND_API.G_TRUE;
812: x_return_status:= FND_API.G_RET_STS_ERROR;
813: l_error_tbl_p := x_error_Tbl;
814: BIS_UTILITIES_PVT.concatenateErrorTables
815: ( p_error_Tbl1 => l_error_Tbl_p
816: , p_error_Tbl2 => l_error_Tbl
817: , x_error_Tbl => x_error_Tbl
818: );

Line 840: BIS_UTILITIES_PVT.concatenateErrorTables

836: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
837: l_error := FND_API.G_TRUE;
838: x_return_status:= FND_API.G_RET_STS_ERROR;
839: l_error_tbl_p := x_error_Tbl;
840: BIS_UTILITIES_PVT.concatenateErrorTables
841: ( p_error_Tbl1 => l_error_Tbl_p
842: , p_error_Tbl2 => l_error_Tbl
843: , x_error_Tbl => x_error_Tbl
844: );

Line 866: BIS_UTILITIES_PVT.concatenateErrorTables

862: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
863: l_error := FND_API.G_TRUE;
864: x_return_status:= FND_API.G_RET_STS_ERROR;
865: l_error_tbl_p := x_error_Tbl;
866: BIS_UTILITIES_PVT.concatenateErrorTables
867: ( p_error_Tbl1 => l_error_Tbl_p
868: , p_error_Tbl2 => l_error_Tbl
869: , x_error_Tbl => x_error_Tbl
870: );

Line 892: BIS_UTILITIES_PVT.concatenateErrorTables

888: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
889: l_error := FND_API.G_TRUE;
890: x_return_status:= FND_API.G_RET_STS_ERROR;
891: l_error_tbl_p := x_error_Tbl;
892: BIS_UTILITIES_PVT.concatenateErrorTables
893: ( p_error_Tbl1 => l_error_Tbl_p
894: , p_error_Tbl2 => l_error_Tbl
895: , x_error_Tbl => x_error_Tbl
896: );

Line 918: BIS_UTILITIES_PVT.concatenateErrorTables

914: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
915: l_error := FND_API.G_TRUE;
916: x_return_status:= FND_API.G_RET_STS_ERROR;
917: l_error_tbl_p := x_error_Tbl;
918: BIS_UTILITIES_PVT.concatenateErrorTables
919: ( p_error_Tbl1 => l_error_Tbl_p
920: , p_error_Tbl2 => l_error_Tbl
921: , x_error_Tbl => x_error_Tbl
922: );

Line 944: BIS_UTILITIES_PVT.concatenateErrorTables

940: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
941: l_error := FND_API.G_TRUE;
942: x_return_status:= FND_API.G_RET_STS_ERROR;
943: l_error_tbl_p := x_error_Tbl;
944: BIS_UTILITIES_PVT.concatenateErrorTables
945: ( p_error_Tbl1 => l_error_Tbl_p
946: , p_error_Tbl2 => l_error_Tbl
947: , x_error_Tbl => x_error_Tbl
948: );

Line 970: BIS_UTILITIES_PVT.concatenateErrorTables

966: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
967: l_error := FND_API.G_TRUE;
968: x_return_status:= FND_API.G_RET_STS_ERROR;
969: l_error_tbl_p := x_error_Tbl;
970: BIS_UTILITIES_PVT.concatenateErrorTables
971: ( p_error_Tbl1 => l_error_Tbl_p
972: , p_error_Tbl2 => l_error_Tbl
973: , x_error_Tbl => x_error_Tbl
974: );

Line 996: BIS_UTILITIES_PVT.concatenateErrorTables

992: --added this
993: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
994: l_error := FND_API.G_TRUE;
995: x_return_status:= FND_API.G_RET_STS_ERROR;
996: BIS_UTILITIES_PVT.concatenateErrorTables
997:
998: ( p_error_Tbl1 => x_error_Tbl
999: , p_error_Tbl2 => l_error_Tbl
1000: , x_error_Tbl => x_error_Tbl

Line 1024: BIS_UTILITIES_PVT.concatenateErrorTables

1020: --added this
1021: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1022: l_error := FND_API.G_TRUE;
1023: x_return_status:= FND_API.G_RET_STS_ERROR;
1024: BIS_UTILITIES_PVT.concatenateErrorTables
1025:
1026: ( p_error_Tbl1 => x_error_Tbl
1027: , p_error_Tbl2 => l_error_Tbl
1028: , x_error_Tbl => x_error_Tbl

Line 1051: BIS_UTILITIES_PVT.concatenateErrorTables

1047: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1048: l_error := FND_API.G_TRUE;
1049: x_return_status:= FND_API.G_RET_STS_ERROR;
1050: l_error_tbl_p := x_error_Tbl;
1051: BIS_UTILITIES_PVT.concatenateErrorTables
1052: ( p_error_Tbl1 => l_error_Tbl_p
1053: , p_error_Tbl2 => l_error_Tbl
1054: , x_error_Tbl => x_error_Tbl
1055: );

Line 1081: BIS_UTILITIES_PVT.Add_Error_Message

1077: WHEN OTHERS THEN
1078: -- dbms_output.put_line('In PVT Actual 12 Exception');
1079: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1080: l_error_tbl_p := x_error_Tbl;
1081: BIS_UTILITIES_PVT.Add_Error_Message
1082: ( p_error_table => l_error_Tbl_p
1083: , p_error_msg_id => SQLCODE
1084: , p_error_description => SQLERRM
1085: , x_error_table => x_error_Tbl

Line 1454: BIS_UTILITIES_PVT.Value_Missing_Or_Null

1450: BEGIN
1451:
1452: IF (
1453: (
1454: BIS_UTILITIES_PVT.Value_Missing_Or_Null
1455: (p_value => p_level_value ) = FND_API.G_TRUE
1456: )
1457: AND
1458: (

Line 1459: BIS_UTILITIES_PVT.Value_Not_Missing_Not_Null

1455: (p_value => p_level_value ) = FND_API.G_TRUE
1456: )
1457: AND
1458: (
1459: BIS_UTILITIES_PVT.Value_Not_Missing_Not_Null
1460: (p_value => p_level_id ) = FND_API.G_TRUE
1461: )
1462: ) THEN
1463: RETURN FND_API.G_TRUE;