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_COMPUTED_ACTUAL_PVT dependencies on FND_API

Line 240: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE

236:
237:
238: PROCEDURE Retrieve_Actual_from_PMV
239: ( p_api_version IN NUMBER
240: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
241: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
242: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
243: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
244: , x_return_status OUT NOCOPY VARCHAR2

Line 331: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE)

327: l_Measure_Instance := p_Measure_Instance;
328: l_dim_level_value_tbl := p_dim_level_value_tbl;
329:
330: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
331: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE)
332: AND (BIS_UTILITIES_PUB.Value_Not_Null
333: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE))
334: THEN
335: l_Target_Level_Rec.target_level_ID := p_Measure_Instance.target_level_ID;

Line 333: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE))

329:
330: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
331: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE)
332: AND (BIS_UTILITIES_PUB.Value_Not_Null
333: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE))
334: THEN
335: l_Target_Level_Rec.target_level_ID := p_Measure_Instance.target_level_ID;
336: l_target_level_rec_p := l_Target_Level_Rec;
337: BIS_Target_Level_PVT.Retrieve_Target_Level

Line 340: , p_all_info => FND_API.G_TRUE

336: l_target_level_rec_p := l_Target_Level_Rec;
337: BIS_Target_Level_PVT.Retrieve_Target_Level
338: ( p_api_version => p_api_version
339: , p_Target_Level_Rec => l_target_level_rec_p
340: , p_all_info => FND_API.G_TRUE
341: , x_Target_Level_Rec => l_Target_Level_Rec
342: , x_return_status => x_return_status
343: , x_error_Tbl => x_error_Tbl
344: );

Line 447: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN

443: ,x_return_status => x_return_status
444: ,x_msg_count => l_msg_count
445: ,x_msg_data => l_msg_data);
446:
447: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
448: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retriving Actual value FROM PMV '||sqlerrm);
449: END IF;
450:
451: EXCEPTION

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

449: END IF;
450:
451: EXCEPTION
452: WHEN OTHERS THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retriving Actual value FROM PMV '||sqlerrm);
455: End;
456:
457:

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

473:
474: EXCEPTION
475:
476: WHEN OTHERS THEN
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
478: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retriving Actual value FROM PMV '||sqlerrm);
479:
480: End;
481:

Line 500: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

496: -- BIS_UTILITIES_PUB.put_line(p_text =>'Target Level Passed ' || l_actual_rec.target_Level_Id );
497:
498: x_actual_rec := l_actual_rec;
499:
500: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: l_actual_rec := NULL;
503: END IF;
504:

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497:
498: x_actual_rec := l_actual_rec;
499:
500: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: l_actual_rec := NULL;
503: END IF;
504:
505:

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: END IF;
504:
505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: RAISE;
510:
511: WHEN OTHERS THEN

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504:
505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: RAISE;
510:
511: WHEN OTHERS THEN
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: RAISE;
510:
511: WHEN OTHERS THEN
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieve computed actual: '||sqlerrm);
514:
515: END Retrieve_Actual_from_PMV;
516:

Line 573: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE

569: -- to FALSE.
570: --
571: PROCEDURE Retrieve_Computed_Actual
572: ( p_api_version IN NUMBER
573: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
574: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
575: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
576: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
577: , x_return_status OUT NOCOPY VARCHAR2

Line 620: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE)

616: l_Measure_Instance := p_Measure_Instance;
617: l_dim_level_value_tbl := p_dim_level_value_tbl;
618:
619: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
620: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE)
621: AND (BIS_UTILITIES_PUB.Value_Not_Null
622: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE))
623: THEN
624: l_Target_Level_Rec.target_level_ID := p_Measure_Instance.target_level_ID;

Line 622: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE))

618:
619: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
620: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE)
621: AND (BIS_UTILITIES_PUB.Value_Not_Null
622: (l_Measure_Instance.target_level_ID) = FND_API.G_TRUE))
623: THEN
624: l_Target_Level_Rec.target_level_ID := p_Measure_Instance.target_level_ID;
625: l_target_level_rec_p := l_Target_Level_Rec;
626: BIS_Target_Level_PVT.Retrieve_Target_Level

Line 629: , p_all_info => FND_API.G_TRUE

625: l_target_level_rec_p := l_Target_Level_Rec;
626: BIS_Target_Level_PVT.Retrieve_Target_Level
627: ( p_api_version => p_api_version
628: , p_Target_Level_Rec => l_target_level_rec_p
629: , p_all_info => FND_API.G_TRUE
630: , x_Target_Level_Rec => l_Target_Level_Rec
631: , x_return_status => x_return_status
632: , x_error_Tbl => x_error_Tbl
633: );

Line 744: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

740: -- BIS_UTILITIES_PUB.put_line(p_text =>'from_clause: '||l_from_clause);
741: -- BIS_UTILITIES_PUB.put_line(p_text =>'where_clause: '||l_where_clause);
742: -- BIS_UTILITIES_PUB.put_line(p_text =>'group by_clause: '||l_group_by_clause);
743:
744: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
745: Execute_Query
746: ( p_select_clause => l_select_clause
747: , p_from_clause => l_from_clause
748: , p_where_clause => l_where_clause

Line 766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

762: , x_return_status => l_return_status
763: );
764: END IF;
765:
766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: l_actual_rec := NULL;
769: END IF;
770:

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: );
764: END IF;
765:
766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: l_actual_rec := NULL;
769: END IF;
770:
771: x_actual_rec := l_actual_rec;

Line 774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

770:
771: x_actual_rec := l_actual_rec;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: RAISE;
777:
778: WHEN OTHERS THEN

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

771: x_actual_rec := l_actual_rec;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: RAISE;
777:
778: WHEN OTHERS THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: RAISE;
777:
778: WHEN OTHERS THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieve computed actual: '||sqlerrm);
781:
782: END Retrieve_Computed_Actual;
783:

Line 824: x_return_status := FND_API.G_RET_STS_SUCCESS;

820:
821: BEGIN
822:
823:
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825: -- BIS_UTILITIES_PUB.put_line(p_text =>'get related obj. measure: '||p_measure_short_name);
826:
827: BIS_UTILITIES_PUB.put_line(p_text =>'Perforamance Measure short name ' || p_measure_short_name);
828: -- SELECT all objects which reference this measure;

Line 850: x_return_status := FND_API.G_RET_STS_ERROR;

846: END IF;
847: CLOSE cr_region_objects;
848:
849: IF l_object_tbl.COUNT < 1 THEN
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: END IF;
852:
853: x_object_tbl := l_object_tbl;
854: -- BIS_UTILITIES_PUB.put_line(p_text =>'number of objects, status: '||x_object_tbl.count

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

855: -- ||', '||x_return_status);
856:
857: EXCEPTION
858: WHEN OTHERS THEN
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Related_Objects: '||sqlerrm);
861:
862: END Get_Related_Objects;
863:

Line 876: l_region_code ak_regions.REGION_CODE%TYPE := FND_API.G_MISS_CHAR;

872: )
873: IS
874:
875: l_object_tbl object_tbl_type;
876: l_region_code ak_regions.REGION_CODE%TYPE := FND_API.G_MISS_CHAR;
877: l_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
878:
879: CURSOR cr_region_objects
880: ( p_region_code ak_regions.REGION_CODE%TYPE

Line 898: x_return_status := FND_API.G_RET_STS_SUCCESS;

894: AND i.ATTRIBUTE2 = p_measure_short_name;
895:
896: BEGIN
897:
898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899: -- BIS_UTILITIES_PUB.put_line(p_text =>'get related obj. measure: '||p_measure_short_name);
900:
901: -- SELECT all objects which reference this measure;
902: --

Line 920: x_return_status := FND_API.G_RET_STS_ERROR;

916: END IF;
917: END LOOP;
918:
919: IF l_object_tbl.COUNT < 1 THEN
920: x_return_status := FND_API.G_RET_STS_ERROR;
921: END IF;
922:
923: x_object_tbl := l_object_tbl;
924: -- BIS_UTILITIES_PUB.put_line(p_text =>'number of objects, status: '||x_object_tbl.count

Line 929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

925: -- ||', '||x_return_status);
926:
927: EXCEPTION
928: WHEN OTHERS THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
930: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Related_Objects: '||sqlerrm);
931:
932: END Get_Related_Objects;
933: ***

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

956: END LOOP;
957:
958: IF l_numobjects = 0 THEN
959: BIS_UTILITIES_PUB.put_line(p_text =>'AK IS not setup.');
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: END IF;
962:
963: IF l_numobjects > 1 THEN
964: BIS_UTILITIES_PUB.put_line(p_text =>'More than one data source found for this measure.');

Line 966: x_return_status := FND_API.G_RET_STS_ERROR;

962:
963: IF l_numobjects > 1 THEN
964: BIS_UTILITIES_PUB.put_line(p_text =>'More than one data source found for this measure.');
965: BIS_UTILITIES_PUB.put_line(p_text =>'The data source that will be used is: '||l_database_object_name);
966: x_return_status := FND_API.G_RET_STS_ERROR;
967: END IF;
968:
969: --BIS_UTILITIES_PUB.put_line(p_text =>'Object name, numObj: '||l_database_object_name||', '||l_numobjects);
970: x_database_object_name := l_database_object_name;

Line 974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

970: x_database_object_name := l_database_object_name;
971:
972: EXCEPTION
973: WHEN OTHERS THEN
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
975: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Object_Data_Source: '||sqlerrm);
976:
977: END Get_Object_Data_Source;
978:

Line 1013: x_return_status := FND_API.G_RET_STS_SUCCESS;

1009: = p_dimension_level_short_name;
1010:
1011: BEGIN
1012:
1013: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014: l_dim_level_value_Tbl := p_dim_level_value_Tbl;
1015:
1016:
1017:

Line 1021: = FND_API.G_TRUE)

1017:
1018: FOR i IN 1..l_dim_level_value_Tbl.COUNT LOOP
1019: IF (BIS_UTILITIES_PUB.Value_Missing
1020: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1021: = FND_API.G_TRUE)
1022: OR (BIS_UTILITIES_PUB.Value_Null
1023: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1024: = FND_API.G_TRUE)
1025: THEN

Line 1024: = FND_API.G_TRUE)

1020: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1021: = FND_API.G_TRUE)
1022: OR (BIS_UTILITIES_PUB.Value_Null
1023: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1024: = FND_API.G_TRUE)
1025: THEN
1026: l_Dimension_Level_Rec.Dimension_Level_id
1027: := l_dim_level_value_Tbl(i).Dimension_Level_id;
1028:

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060: AND ATTRIBUTE1 = 'MEASURE'
1061: AND ATTRIBUTE2 = p_measure_short_name;
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: return;
1066: END;
1067:
1068: -- BIS_UTILITIES_PUB.put_line(p_text =>'Compare Region : '|| p_compare_region_item);

Line 1082: x_return_status := FND_API.G_RET_STS_ERROR;

1078: EXCEPTION
1079: WHEN NO_DATA_FOUND THEN
1080: BIS_UTILITIES_PUB.put_line(p_text =>'No Comparison Data Source ');
1081: WHEN OTHERS THEN
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: END;
1084:
1085: END IF;
1086:

Line 1104: = FND_API.G_TRUE)

1100: --||l_dim_level_value_Tbl.COUNT||', '||j);
1101:
1102: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1103: (l_dim_level_value_Tbl(j).dimension_level_short_name)
1104: = FND_API.G_TRUE)
1105: AND (BIS_UTILITIES_PUB.Value_Not_Null
1106: (l_dim_level_value_Tbl(j).dimension_level_short_name)
1107: = FND_API.G_TRUE))
1108: THEN

Line 1107: = FND_API.G_TRUE))

1103: (l_dim_level_value_Tbl(j).dimension_level_short_name)
1104: = FND_API.G_TRUE)
1105: AND (BIS_UTILITIES_PUB.Value_Not_Null
1106: (l_dim_level_value_Tbl(j).dimension_level_short_name)
1107: = FND_API.G_TRUE))
1108: THEN
1109: OPEN cr_attribute
1110: ( p_object_tbl(i).region_code
1111: , p_object_tbl(i).region_application_id

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: END LOOP;
1132: END LOOP;
1133:
1134: IF l_object_attribute_tbl.COUNT <> p_dim_level_value_Tbl.COUNT THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: END IF;
1137:
1138: x_object_attribute_tbl := l_object_attribute_tbl;
1139:

Line 1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1138: x_object_attribute_tbl := l_object_attribute_tbl;
1139:
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1143: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Object_Attributes: '||sqlerrm);
1144:
1145: END Get_Object_Attributes;
1146:

Line 1161: x_return_status := FND_API.G_RET_STS_SUCCESS;

1157: l_count NUMBER := 0;
1158:
1159: BEGIN
1160:
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162:
1163: -- pick out NOCOPY each dimension level attribute's database column;
1164: -- IF there IS > 1 database column for each dimension level item,
1165: -- THEN error;

Line 1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1187: x_Measure_Inst_DB_Obj_tbl := l_Measure_Inst_DB_Obj_tbl;
1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1192: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Obj_Attribute_Data_Source: '||sqlerrm);
1193:
1194: END Get_Obj_Attribute_Data_Source;
1195:

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1210: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1211:
1212: BEGIN
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: FOR i IN 1..p_dim_level_value_Tbl.COUNT LOOP
1216:
1217: --- IF p_dim_level_value_Tbl(i).Dimension_level_Id = p_dim_level_id THEN

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1243: x_dimension_level_value_NAME := l_dim_level_value_rec.dimension_level_value_name;
1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_dimension_level_value Function: '||sqlerrm);
1249:
1250: END Get_dimension_level_value;
1251:

Line 1272: x_return_status := FND_API.G_RET_STS_SUCCESS;

1268: l_is_time BOOLEAN := FALSE;
1269:
1270: BEGIN
1271: -- BIS_UTILITIES_PUB.put_line(p_text =>'Getting dimension level values');
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273: l_Measure_Inst_DB_Obj_tbl := p_Measure_Inst_DB_Obj_tbl ;
1274: l_dim_level_value_Tbl := p_dim_level_value_Tbl;
1275: FOR i IN 1..p_dim_level_value_Tbl.COUNT LOOP
1276: -- Need more fixes here with total time issue fix

Line 1296: = FND_API.G_TRUE)

1292:
1293: FOR i IN 1..l_dim_level_value_Tbl.COUNT LOOP
1294: IF (BIS_UTILITIES_PUB.Value_Missing
1295: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1296: = FND_API.G_TRUE)
1297: OR (BIS_UTILITIES_PUB.Value_Null
1298: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1299: = FND_API.G_TRUE)
1300: THEN

Line 1299: = FND_API.G_TRUE)

1295: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1296: = FND_API.G_TRUE)
1297: OR (BIS_UTILITIES_PUB.Value_Null
1298: (l_dim_level_value_Tbl(i).dimension_level_short_name)
1299: = FND_API.G_TRUE)
1300: THEN
1301: l_Dimension_Level_Rec.Dimension_Level_id
1302: := l_dim_level_value_Tbl(i).Dimension_Level_id;
1303:

Line 1365: x_return_status := FND_API.G_RET_STS_ERROR ;

1361: IF l_Measure_Inst_DB_Obj_tbl(i).Database_Obj_Column_Name IS NOT NULL
1362: AND l_Measure_Inst_DB_Obj_tbl(i).Database_Obj_Column_Type IS NOT NULL
1363: AND l_Measure_Inst_DB_Obj_tbl(i).Column_value IS NULL
1364: THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR ;
1366:
1367: -- BIS_UTILITIES_PUB.put_line(p_text =>'measure inst object clolum '
1368: -- ||l_Measure_Inst_DB_Obj_tbl(i).Database_Obj_Column_Name
1369: -- ||' missing column value.'

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1384: x_Measure_Inst_DB_Obj_tbl := l_Measure_Inst_DB_Obj_tbl;
1385:
1386: EXCEPTION
1387: WHEN OTHERS THEN
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1389: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_dimension_level_values: '||sqlerrm);
1390:
1391: END Get_dimension_level_values;
1392:

Line 1415: x_return_status := FND_API.G_RET_STS_SUCCESS;

1411: l_return_status VARCHAR2(32000);
1412:
1413: BEGIN
1414:
1415: x_return_status := FND_API.G_RET_STS_SUCCESS;
1416:
1417: Build_select_clause
1418: ( p_Measure_Instance_Obj_tbl => p_Measure_Instance_Obj_tbl
1419: , p_measure_short_name => p_measure_short_name

Line 1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1422: , x_select_clause => l_select_clause
1423: , x_return_status => l_return_status
1424: );
1425:
1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1427: l_select_clause := G_ERROR_CLAUSE;
1428: END IF;
1429:
1430: Build_from_clause

Line 1436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1432: , x_from_clause => l_from_clause
1433: , x_return_status => l_return_status
1434: );
1435:
1436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1437: l_from_clause := G_ERROR_CLAUSE;
1438: END IF;
1439:
1440: Build_where_clause

Line 1447: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1443: , x_where_clause => l_where_clause
1444: , x_return_status => l_return_status
1445: );
1446:
1447: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1448: l_where_clause := G_ERROR_CLAUSE;
1449: END IF;
1450:
1451: Build_group_by_clause

Line 1458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1454: , x_group_by_clause => l_group_by_clause
1455: , x_return_status => l_return_status
1456: );
1457:
1458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1459: l_group_by_clause := G_ERROR_CLAUSE;
1460: END IF;
1461:
1462: IF l_select_clause = G_ERROR_CLAUSE

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR;

1463: OR l_from_clause = G_ERROR_CLAUSE
1464: OR l_where_clause = G_ERROR_CLAUSE
1465: OR l_group_by_clause = G_ERROR_CLAUSE
1466: THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: END IF;
1469:
1470: BIS_UTILITIES_PUB.put_line(p_text =>'select: ' ||l_select_clause);
1471: BIS_UTILITIES_PUB.put_line(p_text =>'from: ' ||l_from_clause);

Line 1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1478: x_group_by_clause := l_group_by_clause;
1479:
1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1483: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_Query_Statement: '||sqlerrm);
1484:
1485: END Build_Query_Statement;
1486:

Line 1506: x_return_status := FND_API.G_RET_STS_SUCCESS;

1502: BEGIN
1503:
1504: -- BIS_UTILITIES_PUB.put_line(p_text =>'Inside Select PROCEDURE ');
1505:
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: FOR i IN 1..p_Measure_Instance_Obj_tbl.COUNT LOOP
1509:
1510: BIS_UTILITIES_PUB.put_line(p_text =>'Inside the For Loop ');

Line 1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1560: x_select_clause := l_select_clause;
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1565: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_select_clause: '||sqlerrm);
1566:
1567: END Build_select_clause;
1568:

Line 1580: x_return_status := FND_API.G_RET_STS_SUCCESS;

1576: l_from_clause VARCHAR2(32000) := NULL;
1577:
1578: BEGIN
1579:
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1581:
1582: IF p_Measure_Instance_Obj_tbl.COUNT > 0 THEN
1583: l_from_clause := ' FROM '
1584: ||p_Measure_Instance_Obj_tbl(1).database_object_name;

Line 1586: x_return_status := FND_API.G_RET_STS_ERROR ;

1582: IF p_Measure_Instance_Obj_tbl.COUNT > 0 THEN
1583: l_from_clause := ' FROM '
1584: ||p_Measure_Instance_Obj_tbl(1).database_object_name;
1585: ELSE
1586: x_return_status := FND_API.G_RET_STS_ERROR ;
1587: END IF;
1588:
1589: x_from_clause := l_from_clause;
1590:

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1589: x_from_clause := l_from_clause;
1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_from_clause: '||sqlerrm);
1595:
1596: END Build_from_clause;
1597:

Line 1611: x_return_status := FND_API.G_RET_STS_SUCCESS;

1607: l_count NUMBER := 0;
1608:
1609: BEGIN
1610:
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613: -- constraint on dimension level values only
1614: -- measure column has the actual value
1615: --

Line 1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1642: x_where_clause := l_where_clause;
1643:
1644: EXCEPTION
1645: WHEN OTHERS THEN
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1647: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_where_clause: '||sqlerrm);
1648:
1649: END Build_where_clause;
1650:

Line 1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

1660: l_count NUMBER := 0;
1661:
1662: BEGIN
1663:
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: FOR i IN 1..p_Measure_Instance_Obj_tbl.COUNT LOOP
1667: IF p_Measure_Instance_Obj_tbl(i).Database_Obj_Column_Name IS NOT NULL
1668: AND p_Measure_Instance_Obj_tbl(i).Database_Obj_Column_type

Line 1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1688: x_group_by_clause := l_group_by_clause;
1689:
1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1693: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_group_by_clause: '||sqlerrm);
1694:
1695: END Build_group_by_clause;
1696:

Line 1714: x_return_status := FND_API.G_RET_STS_SUCCESS;

1710: l_compare_value NUMBER;
1711:
1712: BEGIN
1713:
1714: x_return_status := FND_API.G_RET_STS_SUCCESS;
1715:
1716: l_stmt := p_select_clause||' '||p_from_clause||' '|| p_where_clause||' '||p_group_by_clause;
1717:
1718: BIS_UTILITIES_PUB.put_line(p_text =>'sql statement: '||substr(l_stmt,0,200));

Line 1729: x_return_status := FND_API.G_RET_STS_ERROR ;

1725: WHEN NO_DATA_FOUND THEN
1726: l_actual_value := NULL;
1727: l_compare_value := NULL;
1728: WHEN OTHERS THEN
1729: x_return_status := FND_API.G_RET_STS_ERROR ;
1730: BIS_UTILITIES_PUB.put_line(p_text =>'error with exec statement: '||sqlerrm);
1731: END;
1732:
1733: x_actual_value := l_actual_value;

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1736: BIS_UTILITIES_PUB.put_line(p_text =>'Actual value computed: '||l_actual_value);
1737:
1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1741: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Execute_Query: '||sqlerrm);
1742:
1743: END Execute_Query;
1744:

Line 2087: WHEN FND_API.G_EXC_ERROR THEN -- 2841680

2083:
2084:
2085: EXCEPTION
2086:
2087: WHEN FND_API.G_EXC_ERROR THEN -- 2841680
2088: x_error_msg := ' There is no region code in the parameters for this function name '
2089: || nvl ( l_measure_rec.Function_Name, 'Null')
2090: || '. There will be no report in this notification. ';
2091: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 2091: x_return_status:= FND_API.G_RET_STS_ERROR;

2087: WHEN FND_API.G_EXC_ERROR THEN -- 2841680
2088: x_error_msg := ' There is no region code in the parameters for this function name '
2089: || nvl ( l_measure_rec.Function_Name, 'Null')
2090: || '. There will be no report in this notification. ';
2091: x_return_status:= FND_API.G_RET_STS_ERROR;
2092: BIS_UTILITIES_PUB.put_line(p_text => x_error_msg ) ;
2093:
2094: WHEN OTHERS THEN
2095: NULL;

Line 2136: x_return_status := FND_API.G_RET_STS_SUCCESS;

2132: END IF;
2133:
2134: -- dbms_output.put_line ( 'Region code 1 is ' || nvl(l_report_region_code, 'XXX1')) ;
2135:
2136: x_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: ELSIF (UPPER(l_web_html_call) LIKE c_region_in_webhtmlcall||'%' ) THEN
2139:
2140: l_num1 := INSTR(l_web_html_call, '''' , 1, 1);

Line 2147: x_return_status := FND_API.G_RET_STS_SUCCESS;

2143:
2144: x_Region_code := SUBSTR ( l_web_html_call , l_num1 + 1 , ( l_num2 - l_num1 -1 ) ) ;
2145: -- dbms_output.put_line ( 'Region code 2 is ' || nvl(l_report_region_code , 'XXX2') ) ;
2146:
2147: x_return_status := FND_API.G_RET_STS_SUCCESS;
2148:
2149: ELSE
2150:
2151: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2151: x_return_status := FND_API.G_RET_STS_ERROR ;

2147: x_return_status := FND_API.G_RET_STS_SUCCESS;
2148:
2149: ELSE
2150:
2151: x_return_status := FND_API.G_RET_STS_ERROR ;
2152: x_error_msg := 'A region code is not defined for this form function.';
2153: -- dbms_output.put_line ( 'Region code 3 is ' || nvl(l_report_region_code , 'XXX3') ) ;
2154:
2155: END IF;

Line 2160: x_return_status := FND_API.G_RET_STS_ERROR ;

2156:
2157: EXCEPTION
2158:
2159: WHEN NO_DATA_FOUND THEN
2160: x_return_status := FND_API.G_RET_STS_ERROR ;
2161: x_error_msg := 'A region code is not defined for this form function.';
2162: WHEN OTHERS THEN
2163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2164: x_error_msg := 'Unknown error in get_Region_Using_Function.';

Line 2163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2159: WHEN NO_DATA_FOUND THEN
2160: x_return_status := FND_API.G_RET_STS_ERROR ;
2161: x_error_msg := 'A region code is not defined for this form function.';
2162: WHEN OTHERS THEN
2163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2164: x_error_msg := 'Unknown error in get_Region_Using_Function.';
2165: END;
2166:
2167:

Line 2204: x_return_status := FND_API.G_RET_STS_SUCCESS;

2200: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
2201:
2202: BEGIN
2203:
2204: x_return_status := FND_API.G_RET_STS_SUCCESS;
2205:
2206: --BIS_UTILITIES_PUB.put_line(p_text =>'in form actual rec');
2207:
2208: BIS_PMF_DATA_SOURCE_PVT.Form_Actual_rec

Line 2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2220: --BIS_UTILITIES_PUB.put_line(p_text =>'END form actual rec.');
2221:
2222: EXCEPTION
2223: WHEN OTHERS THEN
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2225: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Form_Actual_Rec: '||sqlerrm);
2226:
2227: END Form_Actual_Rec;
2228:

Line 2231: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2227: END Form_Actual_Rec;
2228:
2229: PROCEDURE Validate_Computed_Actual
2230: ( p_api_version IN NUMBER
2231: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2232: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2233: , x_return_status OUT NOCOPY VARCHAR2
2234: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2235: )

Line 2244: x_return_status := FND_API.G_RET_STS_SUCCESS;

2240: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2241: --
2242: BEGIN
2243:
2244: x_return_status := FND_API.G_RET_STS_SUCCESS;
2245: --
2246: BEGIN
2247: BIS_ACTUAL_VALIDATE_PVT.Validate_Target_Level_ID
2248: ( p_api_version => p_api_version

Line 2256: WHEN FND_API.G_EXC_ERROR THEN

2252: );
2253: --
2254:
2255: EXCEPTION
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: x_return_status:= FND_API.G_RET_STS_ERROR;
2258: END;
2259: --
2260: /* Don't need to validate time

Line 2257: x_return_status:= FND_API.G_RET_STS_ERROR;

2253: --
2254:
2255: EXCEPTION
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: x_return_status:= FND_API.G_RET_STS_ERROR;
2258: END;
2259: --
2260: /* Don't need to validate time
2261: BEGIN

Line 2270: WHEN FND_API.G_EXC_ERROR THEN

2266: , x_error_Tbl => l_error_Tbl
2267: );
2268: --
2269: EXCEPTION
2270: WHEN FND_API.G_EXC_ERROR THEN
2271: x_return_status:= FND_API.G_RET_STS_ERROR;
2272: BIS_UTILITIES_PVT.concatenateErrorTables
2273: ( p_error_Tbl1 => x_error_Tbl
2274: , p_error_Tbl2 => l_error_Tbl

Line 2271: x_return_status:= FND_API.G_RET_STS_ERROR;

2267: );
2268: --
2269: EXCEPTION
2270: WHEN FND_API.G_EXC_ERROR THEN
2271: x_return_status:= FND_API.G_RET_STS_ERROR;
2272: BIS_UTILITIES_PVT.concatenateErrorTables
2273: ( p_error_Tbl1 => x_error_Tbl
2274: , p_error_Tbl2 => l_error_Tbl
2275: , x_error_Tbl => x_error_Tbl

Line 2290: WHEN FND_API.G_EXC_ERROR THEN

2286: , x_error_Tbl => l_error_Tbl
2287: );
2288: --
2289: EXCEPTION
2290: WHEN FND_API.G_EXC_ERROR THEN
2291: x_return_status:= FND_API.G_RET_STS_ERROR;
2292: BIS_UTILITIES_PVT.concatenateErrorTables
2293: ( p_error_Tbl1 => x_error_Tbl
2294: , p_error_Tbl2 => l_error_Tbl

Line 2291: x_return_status:= FND_API.G_RET_STS_ERROR;

2287: );
2288: --
2289: EXCEPTION
2290: WHEN FND_API.G_EXC_ERROR THEN
2291: x_return_status:= FND_API.G_RET_STS_ERROR;
2292: BIS_UTILITIES_PVT.concatenateErrorTables
2293: ( p_error_Tbl1 => x_error_Tbl
2294: , p_error_Tbl2 => l_error_Tbl
2295: , x_error_Tbl => x_error_Tbl

Line 2309: WHEN FND_API.G_EXC_ERROR THEN

2305: , x_error_Tbl => l_error_Tbl
2306: );
2307: --
2308: EXCEPTION
2309: WHEN FND_API.G_EXC_ERROR THEN
2310: x_return_status:= FND_API.G_RET_STS_ERROR;
2311: l_error_tbl_p := x_error_Tbl;
2312: BIS_UTILITIES_PVT.concatenateErrorTables
2313: ( p_error_Tbl1 => l_error_tbl_p

Line 2310: x_return_status:= FND_API.G_RET_STS_ERROR;

2306: );
2307: --
2308: EXCEPTION
2309: WHEN FND_API.G_EXC_ERROR THEN
2310: x_return_status:= FND_API.G_RET_STS_ERROR;
2311: l_error_tbl_p := x_error_Tbl;
2312: BIS_UTILITIES_PVT.concatenateErrorTables
2313: ( p_error_Tbl1 => l_error_tbl_p
2314: , p_error_Tbl2 => l_error_Tbl

Line 2328: WHEN FND_API.G_EXC_ERROR THEN

2324: , x_error_Tbl => l_error_Tbl
2325: );
2326: --
2327: EXCEPTION
2328: WHEN FND_API.G_EXC_ERROR THEN
2329: x_return_status:= FND_API.G_RET_STS_ERROR;
2330: l_error_tbl_p := x_error_Tbl;
2331: BIS_UTILITIES_PVT.concatenateErrorTables
2332: ( p_error_Tbl1 => l_error_tbl_p

Line 2329: x_return_status:= FND_API.G_RET_STS_ERROR;

2325: );
2326: --
2327: EXCEPTION
2328: WHEN FND_API.G_EXC_ERROR THEN
2329: x_return_status:= FND_API.G_RET_STS_ERROR;
2330: l_error_tbl_p := x_error_Tbl;
2331: BIS_UTILITIES_PVT.concatenateErrorTables
2332: ( p_error_Tbl1 => l_error_tbl_p
2333: , p_error_Tbl2 => l_error_Tbl

Line 2347: WHEN FND_API.G_EXC_ERROR THEN

2343: , x_error_Tbl => l_error_Tbl
2344: );
2345: --
2346: EXCEPTION
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: x_return_status:= FND_API.G_RET_STS_ERROR;
2349: l_error_tbl_p := x_error_Tbl;
2350: BIS_UTILITIES_PVT.concatenateErrorTables
2351: ( p_error_Tbl1 => l_error_tbl_p

Line 2348: x_return_status:= FND_API.G_RET_STS_ERROR;

2344: );
2345: --
2346: EXCEPTION
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: x_return_status:= FND_API.G_RET_STS_ERROR;
2349: l_error_tbl_p := x_error_Tbl;
2350: BIS_UTILITIES_PVT.concatenateErrorTables
2351: ( p_error_Tbl1 => l_error_tbl_p
2352: , p_error_Tbl2 => l_error_Tbl

Line 2366: WHEN FND_API.G_EXC_ERROR THEN

2362: , x_error_Tbl => l_error_Tbl
2363: );
2364: --
2365: EXCEPTION
2366: WHEN FND_API.G_EXC_ERROR THEN
2367: x_return_status:= FND_API.G_RET_STS_ERROR;
2368: l_error_tbl_p := x_error_Tbl;
2369: BIS_UTILITIES_PVT.concatenateErrorTables
2370: ( p_error_Tbl1 => l_error_tbl_p

Line 2367: x_return_status:= FND_API.G_RET_STS_ERROR;

2363: );
2364: --
2365: EXCEPTION
2366: WHEN FND_API.G_EXC_ERROR THEN
2367: x_return_status:= FND_API.G_RET_STS_ERROR;
2368: l_error_tbl_p := x_error_Tbl;
2369: BIS_UTILITIES_PVT.concatenateErrorTables
2370: ( p_error_Tbl1 => l_error_tbl_p
2371: , p_error_Tbl2 => l_error_Tbl

Line 2385: WHEN FND_API.G_EXC_ERROR THEN

2381: , x_error_Tbl => l_error_Tbl
2382: );
2383: --
2384: EXCEPTION
2385: WHEN FND_API.G_EXC_ERROR THEN
2386: x_return_status:= FND_API.G_RET_STS_ERROR;
2387: l_error_tbl_p := x_error_Tbl;
2388: BIS_UTILITIES_PVT.concatenateErrorTables
2389: ( p_error_Tbl1 => l_error_tbl_p

Line 2386: x_return_status:= FND_API.G_RET_STS_ERROR;

2382: );
2383: --
2384: EXCEPTION
2385: WHEN FND_API.G_EXC_ERROR THEN
2386: x_return_status:= FND_API.G_RET_STS_ERROR;
2387: l_error_tbl_p := x_error_Tbl;
2388: BIS_UTILITIES_PVT.concatenateErrorTables
2389: ( p_error_Tbl1 => l_error_tbl_p
2390: , p_error_Tbl2 => l_error_Tbl

Line 2404: WHEN FND_API.G_EXC_ERROR THEN

2400: , x_error_Tbl => l_error_Tbl
2401: );
2402: --
2403: EXCEPTION
2404: WHEN FND_API.G_EXC_ERROR THEN
2405: x_return_status:= FND_API.G_RET_STS_ERROR;
2406: l_error_tbl_p := x_error_Tbl;
2407: BIS_UTILITIES_PVT.concatenateErrorTables
2408: ( p_error_Tbl1 => l_error_tbl_p

Line 2405: x_return_status:= FND_API.G_RET_STS_ERROR;

2401: );
2402: --
2403: EXCEPTION
2404: WHEN FND_API.G_EXC_ERROR THEN
2405: x_return_status:= FND_API.G_RET_STS_ERROR;
2406: l_error_tbl_p := x_error_Tbl;
2407: BIS_UTILITIES_PVT.concatenateErrorTables
2408: ( p_error_Tbl1 => l_error_tbl_p
2409: , p_error_Tbl2 => l_error_Tbl

Line 2423: WHEN FND_API.G_EXC_ERROR THEN

2419: , x_error_Tbl => l_error_Tbl
2420: );
2421: --
2422: EXCEPTION
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status:= FND_API.G_RET_STS_ERROR;
2425: l_error_tbl_p := x_error_Tbl;
2426: BIS_UTILITIES_PVT.concatenateErrorTables
2427: ( p_error_Tbl1 => l_error_tbl_p

Line 2424: x_return_status:= FND_API.G_RET_STS_ERROR;

2420: );
2421: --
2422: EXCEPTION
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status:= FND_API.G_RET_STS_ERROR;
2425: l_error_tbl_p := x_error_Tbl;
2426: BIS_UTILITIES_PVT.concatenateErrorTables
2427: ( p_error_Tbl1 => l_error_tbl_p
2428: , p_error_Tbl2 => l_error_Tbl

Line 2442: WHEN FND_API.G_EXC_ERROR THEN

2438: , x_error_Tbl => l_error_Tbl
2439: );
2440: --
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443: x_return_status:= FND_API.G_RET_STS_ERROR;
2444: l_error_tbl_p := x_error_Tbl;
2445: BIS_UTILITIES_PVT.concatenateErrorTables
2446: ( p_error_Tbl1 => l_error_tbl_p

Line 2443: x_return_status:= FND_API.G_RET_STS_ERROR;

2439: );
2440: --
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443: x_return_status:= FND_API.G_RET_STS_ERROR;
2444: l_error_tbl_p := x_error_Tbl;
2445: BIS_UTILITIES_PVT.concatenateErrorTables
2446: ( p_error_Tbl1 => l_error_tbl_p
2447: , p_error_Tbl2 => l_error_Tbl

Line 2461: WHEN FND_API.G_EXC_ERROR THEN

2457: , x_error_Tbl => l_error_Tbl
2458: );
2459: --
2460: EXCEPTION
2461: WHEN FND_API.G_EXC_ERROR THEN
2462: x_return_status:= FND_API.G_RET_STS_ERROR;
2463: l_error_tbl_p := x_error_Tbl;
2464: BIS_UTILITIES_PVT.concatenateErrorTables
2465: ( p_error_Tbl1 => l_error_tbl_p

Line 2462: x_return_status:= FND_API.G_RET_STS_ERROR;

2458: );
2459: --
2460: EXCEPTION
2461: WHEN FND_API.G_EXC_ERROR THEN
2462: x_return_status:= FND_API.G_RET_STS_ERROR;
2463: l_error_tbl_p := x_error_Tbl;
2464: BIS_UTILITIES_PVT.concatenateErrorTables
2465: ( p_error_Tbl1 => l_error_tbl_p
2466: , p_error_Tbl2 => l_error_Tbl

Line 2472: WHEN FND_API.G_EXC_ERROR THEN

2468: );
2469: END;
2470: --
2471: EXCEPTION
2472: WHEN FND_API.G_EXC_ERROR THEN
2473: x_return_status:= FND_API.G_RET_STS_ERROR;
2474: RAISE;
2475:
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2473: x_return_status:= FND_API.G_RET_STS_ERROR;

2469: END;
2470: --
2471: EXCEPTION
2472: WHEN FND_API.G_EXC_ERROR THEN
2473: x_return_status:= FND_API.G_RET_STS_ERROR;
2474: RAISE;
2475:
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2472: WHEN FND_API.G_EXC_ERROR THEN
2473: x_return_status:= FND_API.G_RET_STS_ERROR;
2474: RAISE;
2475:
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: RAISE;
2479:
2480: WHEN OTHERS THEN

Line 2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2473: x_return_status:= FND_API.G_RET_STS_ERROR;
2474: RAISE;
2475:
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: RAISE;
2479:
2480: WHEN OTHERS THEN
2481: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2481: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: RAISE;
2479:
2480: WHEN OTHERS THEN
2481: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2482: l_error_tbl_p := x_error_Tbl;
2483: BIS_UTILITIES_PVT.Add_Error_Message
2484: ( p_error_table => l_error_tbl_p
2485: , p_error_msg_id => SQLCODE

Line 2489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2485: , p_error_msg_id => SQLCODE
2486: , p_error_description => SQLERRM
2487: , x_error_table => x_error_Tbl
2488: );
2489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2490:
2491: END Validate_Computed_Actual;
2492:
2493: PROCEDURE Validate_Required_Fields

Line 2495: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2491: END Validate_Computed_Actual;
2492:
2493: PROCEDURE Validate_Required_Fields
2494: ( p_api_version IN NUMBER
2495: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2496: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2497: , x_return_status OUT NOCOPY VARCHAR2
2498: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2499: )

Line 2502: x_return_status := FND_API.G_RET_STS_SUCCESS;

2498: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2499: )
2500: IS
2501: BEGIN
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503: -- BIS_UTILITIES_PUB.put_line(p_text =>'In PVT Validate_Required_Fields');
2504:
2505: EXCEPTION
2506: WHEN OTHERS THEN

Line 2507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2503: -- BIS_UTILITIES_PUB.put_line(p_text =>'In PVT Validate_Required_Fields');
2504:
2505: EXCEPTION
2506: WHEN OTHERS THEN
2507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2508:
2509: END Validate_Required_Fields;
2510:
2511: PROCEDURE Value_ID_Conversion

Line 2527: x_return_status := FND_API.G_RET_STS_SUCCESS;

2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
2524: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
2525: BEGIN
2526:
2527: x_return_status := FND_API.G_RET_STS_SUCCESS;
2528: l_Actual_Rec := p_Actual_Rec;
2529:
2530: -- convert Target Level
2531: --

Line 2533: = FND_API.G_TRUE

2529:
2530: -- convert Target Level
2531: --
2532: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Target_Level_ID)
2533: = FND_API.G_TRUE
2534: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Target_Level_ID)
2535: = FND_API.G_TRUE
2536: THEN
2537: BEGIN

Line 2535: = FND_API.G_TRUE

2531: --
2532: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Target_Level_ID)
2533: = FND_API.G_TRUE
2534: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Target_Level_ID)
2535: = FND_API.G_TRUE
2536: THEN
2537: BEGIN
2538: /*
2539: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. TL is: '

Line 2570: WHEN FND_API.G_EXC_ERROR THEN

2566: l_Actual_rec.Target_Level_name := l_Target_Level_rec.Target_Level_name;
2567: */
2568:
2569: EXCEPTION
2570: WHEN FND_API.G_EXC_ERROR THEN
2571: NULL;
2572: -- BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. EXEC ERROR');
2573:
2574: WHEN OTHERS THEN

Line 2589: , p_all_info => FND_API.G_FALSE

2585: l_target_level_rec_p := l_Target_Level_rec;
2586: BIS_Target_Level_PVT.Retrieve_Target_Level
2587: ( p_api_version => p_api_version
2588: , p_Target_Level_rec => l_target_level_rec_p
2589: , p_all_info => FND_API.G_FALSE
2590: , x_Target_Level_rec => l_Target_Level_rec
2591: , x_return_status => x_return_status
2592: , x_error_Tbl => x_error_Tbl
2593: );

Line 2595: WHEN FND_API.G_EXC_ERROR THEN

2591: , x_return_status => x_return_status
2592: , x_error_Tbl => x_error_Tbl
2593: );
2594: EXCEPTION
2595: WHEN FND_API.G_EXC_ERROR THEN
2596: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. EXEC ERROR');
2597:
2598: WHEN OTHERS THEN
2599: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. OTHER');

Line 2607: = FND_API.G_TRUE

2603: /*
2604: -- Convert org_level_value
2605: --
2606: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Org_level_value_ID)
2607: = FND_API.G_TRUE
2608: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Org_level_value_ID)
2609: = FND_API.G_TRUE
2610: THEN
2611: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. Org level missing ');

Line 2609: = FND_API.G_TRUE

2605: --
2606: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Org_level_value_ID)
2607: = FND_API.G_TRUE
2608: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Org_level_value_ID)
2609: = FND_API.G_TRUE
2610: THEN
2611: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. Org level missing ');
2612:
2613: BEGIN

Line 2631: WHEN FND_API.G_EXC_ERROR THEN

2627: l_actual_rec.Org_level_value_ID
2628: := l_dim_level_value_Rec2.dimension_level_value_id;
2629:
2630: EXCEPTION
2631: WHEN FND_API.G_EXC_ERROR THEN
2632: NULL;
2633: END;
2634: ELSE
2635: l_Dim_Level_Value_Rec2.Dimension_Level_Value_id

Line 2643: = FND_API.G_TRUE

2639:
2640: -- Convert time_level_value
2641: --
2642: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Time_Level_value_ID)
2643: = FND_API.G_TRUE
2644: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Time_Level_value_ID)
2645: = FND_API.G_TRUE
2646: THEN
2647: BEGIN

Line 2645: = FND_API.G_TRUE

2641: --
2642: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Time_Level_value_ID)
2643: = FND_API.G_TRUE
2644: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Time_Level_value_ID)
2645: = FND_API.G_TRUE
2646: THEN
2647: BEGIN
2648: l_Dim_Level_Value_Rec.Dimension_Level_ID
2649: := l_target_level_rec.time_level_id;

Line 2666: WHEN FND_API.G_EXC_ERROR THEN

2662: l_actual_rec.Time_level_value_ID
2663: := l_dim_level_value_Rec.dimension_level_value_id;
2664:
2665: EXCEPTION
2666: WHEN FND_API.G_EXC_ERROR THEN
2667: NULL;
2668: END;
2669: END IF;
2670: */

Line 2675: = FND_API.G_TRUE

2671:
2672: -- Convert dim1_level_value
2673: --
2674: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim1_Level_value_ID)
2675: = FND_API.G_TRUE
2676: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim1_Level_value_ID)
2677: = FND_API.G_TRUE
2678: THEN
2679: BEGIN

Line 2677: = FND_API.G_TRUE

2673: --
2674: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim1_Level_value_ID)
2675: = FND_API.G_TRUE
2676: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim1_Level_value_ID)
2677: = FND_API.G_TRUE
2678: THEN
2679: BEGIN
2680: l_Dim_Level_Value_Rec.Dimension_Level_ID
2681: := l_target_level_rec.Dimension1_level_id;

Line 2698: WHEN FND_API.G_EXC_ERROR THEN

2694: l_actual_rec.Dim1_level_value_ID
2695: := l_dim_level_value_Rec.dimension_level_value_id;
2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: NULL;
2700: END;
2701: END IF;
2702:

Line 2706: = FND_API.G_TRUE

2702:
2703: -- Convert dim2_level_value
2704: --
2705: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim2_Level_value_ID)
2706: = FND_API.G_TRUE
2707: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim2_Level_value_ID)
2708: = FND_API.G_TRUE
2709: THEN
2710: BEGIN

Line 2708: = FND_API.G_TRUE

2704: --
2705: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim2_Level_value_ID)
2706: = FND_API.G_TRUE
2707: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim2_Level_value_ID)
2708: = FND_API.G_TRUE
2709: THEN
2710: BEGIN
2711: l_Dim_Level_Value_Rec.Dimension_Level_ID
2712: := l_target_level_rec.Dimension2_level_id;

Line 2729: WHEN FND_API.G_EXC_ERROR THEN

2725: l_actual_rec.Dim2_level_value_ID
2726: := l_dim_level_value_Rec.dimension_level_value_id;
2727:
2728: EXCEPTION
2729: WHEN FND_API.G_EXC_ERROR THEN
2730: NULL;
2731: END;
2732: END IF;
2733:

Line 2737: = FND_API.G_TRUE

2733:
2734: -- Convert dim3_level_value
2735: --
2736: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim3_Level_value_ID)
2737: = FND_API.G_TRUE
2738: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim3_Level_value_ID)
2739: = FND_API.G_TRUE
2740: THEN
2741: BEGIN

Line 2739: = FND_API.G_TRUE

2735: --
2736: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim3_Level_value_ID)
2737: = FND_API.G_TRUE
2738: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim3_Level_value_ID)
2739: = FND_API.G_TRUE
2740: THEN
2741: BEGIN
2742: l_Dim_Level_Value_Rec.Dimension_Level_ID
2743: := l_target_level_rec.Dimension3_level_id;

Line 2760: WHEN FND_API.G_EXC_ERROR THEN

2756: l_actual_rec.Dim3_level_value_ID
2757: := l_dim_level_value_Rec.dimension_level_value_id;
2758:
2759: EXCEPTION
2760: WHEN FND_API.G_EXC_ERROR THEN
2761: NULL;
2762: END;
2763: END IF;
2764:

Line 2768: = FND_API.G_TRUE

2764:
2765: -- Convert dim4_level_value
2766: --
2767: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim4_Level_value_ID)
2768: = FND_API.G_TRUE
2769: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim4_Level_value_ID)
2770: = FND_API.G_TRUE
2771: THEN
2772: BEGIN

Line 2770: = FND_API.G_TRUE

2766: --
2767: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim4_Level_value_ID)
2768: = FND_API.G_TRUE
2769: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim4_Level_value_ID)
2770: = FND_API.G_TRUE
2771: THEN
2772: BEGIN
2773: l_Dim_Level_Value_Rec.Dimension_Level_ID
2774: := l_target_level_rec.Dimension4_level_id;

Line 2791: WHEN FND_API.G_EXC_ERROR THEN

2787: l_actual_rec.Dim4_level_value_ID
2788: := l_dim_level_value_Rec.dimension_level_value_id;
2789:
2790: EXCEPTION
2791: WHEN FND_API.G_EXC_ERROR THEN
2792: NULL;
2793: END;
2794: END IF;
2795:

Line 2799: = FND_API.G_TRUE

2795:
2796: -- Convert dim5_level_value
2797: --
2798: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim5_Level_value_ID)
2799: = FND_API.G_TRUE
2800: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim5_Level_value_ID)
2801: = FND_API.G_TRUE
2802: THEN
2803: BEGIN

Line 2801: = FND_API.G_TRUE

2797: --
2798: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim5_Level_value_ID)
2799: = FND_API.G_TRUE
2800: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim5_Level_value_ID)
2801: = FND_API.G_TRUE
2802: THEN
2803: BEGIN
2804: l_Dim_Level_Value_Rec.Dimension_Level_ID
2805: := l_target_level_rec.Dimension5_level_id;

Line 2822: WHEN FND_API.G_EXC_ERROR THEN

2818: l_actual_rec.Dim5_level_value_ID
2819: := l_dim_level_value_Rec.dimension_level_value_id;
2820:
2821: EXCEPTION
2822: WHEN FND_API.G_EXC_ERROR THEN
2823: NULL;
2824: END;
2825: END IF;
2826:

Line 2830: = FND_API.G_TRUE

2826:
2827: -- Convert dim6_level_value
2828: --
2829: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim6_Level_value_ID)
2830: = FND_API.G_TRUE
2831: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim6_Level_value_ID)
2832: = FND_API.G_TRUE
2833: THEN
2834: BEGIN

Line 2832: = FND_API.G_TRUE

2828: --
2829: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim6_Level_value_ID)
2830: = FND_API.G_TRUE
2831: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim6_Level_value_ID)
2832: = FND_API.G_TRUE
2833: THEN
2834: BEGIN
2835: l_Dim_Level_Value_Rec.Dimension_Level_ID
2836: := l_target_level_rec.Dimension6_level_id;

Line 2853: WHEN FND_API.G_EXC_ERROR THEN

2849: l_actual_rec.Dim6_level_value_ID
2850: := l_dim_level_value_Rec.dimension_level_value_id;
2851:
2852: EXCEPTION
2853: WHEN FND_API.G_EXC_ERROR THEN
2854: NULL;
2855: END;
2856: END IF;
2857:

Line 2861: = FND_API.G_TRUE

2857:
2858: -- Convert dim7_level_value
2859: --
2860: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim7_Level_value_ID)
2861: = FND_API.G_TRUE
2862: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim7_Level_value_ID)
2863: = FND_API.G_TRUE
2864: THEN
2865: BEGIN

Line 2863: = FND_API.G_TRUE

2859: --
2860: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim7_Level_value_ID)
2861: = FND_API.G_TRUE
2862: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim7_Level_value_ID)
2863: = FND_API.G_TRUE
2864: THEN
2865: BEGIN
2866: l_Dim_Level_Value_Rec.Dimension_Level_ID
2867: := l_target_level_rec.Dimension7_level_id;

Line 2884: WHEN FND_API.G_EXC_ERROR THEN

2880: l_actual_rec.Dim7_level_value_ID
2881: := l_dim_level_value_Rec.dimension_level_value_id;
2882:
2883: EXCEPTION
2884: WHEN FND_API.G_EXC_ERROR THEN
2885: NULL;
2886: END;
2887: END IF;
2888:

Line 2893: = FND_API.G_TRUE

2889: /*
2890: -- Convert responsibility
2891: --
2892: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Responsibility_ID)
2893: = FND_API.G_TRUE
2894: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Responsibility_ID)
2895: = FND_API.G_TRUE
2896: THEN
2897: BEGIN

Line 2895: = FND_API.G_TRUE

2891: --
2892: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Responsibility_ID)
2893: = FND_API.G_TRUE
2894: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Responsibility_ID)
2895: = FND_API.G_TRUE
2896: THEN
2897: BEGIN
2898: BIS_Responsibility_PVT.Value_ID_Conversion
2899: ( p_api_version => p_api_version

Line 2907: WHEN FND_API.G_EXC_ERROR THEN

2903: , x_return_status => x_return_status
2904: , x_error_Tbl => x_error_Tbl
2905: );
2906: EXCEPTION
2907: WHEN FND_API.G_EXC_ERROR THEN
2908: NULL;
2909: END;
2910: END IF;
2911: */

Line 2917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2913: x_Actual_Rec := l_Actual_Rec;
2914:
2915: EXCEPTION
2916: WHEN OTHERS THEN
2917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2918:
2919: END Value_ID_Conversion;
2920:
2921: FUNCTION get_dim_level_short_name(p_attribute IN VARCHAR2)

Line 2954: x_return_status := FND_API.G_RET_STS_SUCCESS;

2950: WHERE DIMENSION_LEVEL_ID = p_DimLevelId ;
2951:
2952: BEGIN
2953:
2954: x_return_status := FND_API.G_RET_STS_SUCCESS;
2955:
2956:
2957: OPEN c_dim_id;
2958: FETCH c_dim_id INTO p_DimShortName, p_DimLevelShortName;

Line 2969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2965: RETURN FALSE;
2966: END IF;
2967: EXCEPTION
2968: WHEN OTHERS THEN
2969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2970: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN IS_TIME_DIMENSION_LEVEL Function: '||sqlerrm);
2971:
2972: END IS_TIME_DIMENSION_LEVEL;
2973:

Line 3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3164:
3165: EXCEPTION
3166: WHEN OTHERS THEN
3167: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN get_Parameters_For_Actual 1000 ' );
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3169: RAISE;
3170:
3171: END get_Parameters_For_Actual;
3172:

Line 3216: (p_TIME_PARAMETER_REC_TYPE.time_parameter_name) = FND_API.G_TRUE)

3212:
3213: l_print_text := ' Time Dimension Value IS ';
3214:
3215: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
3216: (p_TIME_PARAMETER_REC_TYPE.time_parameter_name) = FND_API.G_TRUE)
3217: AND (BIS_UTILITIES_PUB.Value_Not_Null
3218: (p_TIME_PARAMETER_REC_TYPE.time_parameter_name) = FND_API.G_TRUE))
3219: THEN
3220: l_print_text := l_print_text || p_TIME_PARAMETER_REC_TYPE.time_parameter_name;

Line 3218: (p_TIME_PARAMETER_REC_TYPE.time_parameter_name) = FND_API.G_TRUE))

3214:
3215: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
3216: (p_TIME_PARAMETER_REC_TYPE.time_parameter_name) = FND_API.G_TRUE)
3217: AND (BIS_UTILITIES_PUB.Value_Not_Null
3218: (p_TIME_PARAMETER_REC_TYPE.time_parameter_name) = FND_API.G_TRUE))
3219: THEN
3220: l_print_text := l_print_text || p_TIME_PARAMETER_REC_TYPE.time_parameter_name;
3221: ELSE
3222: l_print_text := l_print_text || ' Time parameter value is null. ' ;

Line 3227: (p_TIME_PARAMETER_REC_TYPE.time_from_value) = FND_API.G_TRUE)

3223: END IF;
3224:
3225:
3226: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
3227: (p_TIME_PARAMETER_REC_TYPE.time_from_value) = FND_API.G_TRUE)
3228: AND (BIS_UTILITIES_PUB.Value_Not_Null
3229: (p_TIME_PARAMETER_REC_TYPE.time_from_value) = FND_API.G_TRUE))
3230: THEN
3231: l_print_text := l_print_text || ' , Time From = ' || p_TIME_PARAMETER_REC_TYPE.time_from_value;

Line 3229: (p_TIME_PARAMETER_REC_TYPE.time_from_value) = FND_API.G_TRUE))

3225:
3226: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
3227: (p_TIME_PARAMETER_REC_TYPE.time_from_value) = FND_API.G_TRUE)
3228: AND (BIS_UTILITIES_PUB.Value_Not_Null
3229: (p_TIME_PARAMETER_REC_TYPE.time_from_value) = FND_API.G_TRUE))
3230: THEN
3231: l_print_text := l_print_text || ' , Time From = ' || p_TIME_PARAMETER_REC_TYPE.time_from_value;
3232: ELSE
3233: l_print_text := l_print_text || ' Time From value is null. ' ;

Line 3237: (p_TIME_PARAMETER_REC_TYPE.time_to_value) = FND_API.G_TRUE)

3233: l_print_text := l_print_text || ' Time From value is null. ' ;
3234: END IF;
3235:
3236: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
3237: (p_TIME_PARAMETER_REC_TYPE.time_to_value) = FND_API.G_TRUE)
3238: AND (BIS_UTILITIES_PUB.Value_Not_Null
3239: (p_TIME_PARAMETER_REC_TYPE.time_to_value) = FND_API.G_TRUE))
3240: THEN
3241: l_print_text := l_print_text || ' , Time To = ' || p_TIME_PARAMETER_REC_TYPE.time_to_value;

Line 3239: (p_TIME_PARAMETER_REC_TYPE.time_to_value) = FND_API.G_TRUE))

3235:
3236: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
3237: (p_TIME_PARAMETER_REC_TYPE.time_to_value) = FND_API.G_TRUE)
3238: AND (BIS_UTILITIES_PUB.Value_Not_Null
3239: (p_TIME_PARAMETER_REC_TYPE.time_to_value) = FND_API.G_TRUE))
3240: THEN
3241: l_print_text := l_print_text || ' , Time To = ' || p_TIME_PARAMETER_REC_TYPE.time_to_value;
3242: ELSE
3243: l_print_text := l_print_text || ' Time To value is null. ' ;

Line 3253: IF ( ( BIS_UTILITIES_PUB.Value_Not_Missing ( p_view_by_lvl_sht_name ) = FND_API.G_TRUE )

3249:
3250:
3251: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Report view by level ........... ' ) ;
3252:
3253: IF ( ( BIS_UTILITIES_PUB.Value_Not_Missing ( p_view_by_lvl_sht_name ) = FND_API.G_TRUE )
3254: AND ( BIS_UTILITIES_PUB.Value_Not_Null ( p_view_by_lvl_sht_name ) = FND_API.G_TRUE )
3255: ) THEN
3256: l_print_text := ' View by parameter is : ' || p_TIME_PARAMETER_REC_TYPE.time_to_value;
3257: ELSE

Line 3254: AND ( BIS_UTILITIES_PUB.Value_Not_Null ( p_view_by_lvl_sht_name ) = FND_API.G_TRUE )

3250:
3251: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Report view by level ........... ' ) ;
3252:
3253: IF ( ( BIS_UTILITIES_PUB.Value_Not_Missing ( p_view_by_lvl_sht_name ) = FND_API.G_TRUE )
3254: AND ( BIS_UTILITIES_PUB.Value_Not_Null ( p_view_by_lvl_sht_name ) = FND_API.G_TRUE )
3255: ) THEN
3256: l_print_text := ' View by parameter is : ' || p_TIME_PARAMETER_REC_TYPE.time_to_value;
3257: ELSE
3258: l_print_text := ' View by parameter is null. ' ;

Line 3272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3268:
3269: EXCEPTION
3270: WHEN OTHERS THEN
3271: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN print_Parameter_Table_Values 1000 ' );
3272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3273: RAISE;
3274:
3275: END print_Parameter_Table_Values;
3276:

Line 3360: bis_utilities_pvt.value_not_null ( p_dim_level_id ) = FND_API.G_TRUE AND

3356:
3357: l_text := ' i = ' || p_dim_level_number;
3358:
3359: IF (
3360: bis_utilities_pvt.value_not_null ( p_dim_level_id ) = FND_API.G_TRUE AND
3361: bis_utilities_pvt.value_not_missing ( p_dim_level_id ) = FND_API.G_TRUE
3362: ) THEN
3363: l_text := l_text || ' Level id = ' || p_dim_level_id ;
3364: ELSE

Line 3361: bis_utilities_pvt.value_not_missing ( p_dim_level_id ) = FND_API.G_TRUE

3357: l_text := ' i = ' || p_dim_level_number;
3358:
3359: IF (
3360: bis_utilities_pvt.value_not_null ( p_dim_level_id ) = FND_API.G_TRUE AND
3361: bis_utilities_pvt.value_not_missing ( p_dim_level_id ) = FND_API.G_TRUE
3362: ) THEN
3363: l_text := l_text || ' Level id = ' || p_dim_level_id ;
3364: ELSE
3365: l_text := l_text || ' Level id IS NULL/missing ' ;

Line 3370: bis_utilities_pvt.value_not_null ( p_dim_level_value_id ) = FND_API.G_TRUE AND

3366: END IF;
3367:
3368:
3369: IF (
3370: bis_utilities_pvt.value_not_null ( p_dim_level_value_id ) = FND_API.G_TRUE AND
3371: bis_utilities_pvt.value_not_missing ( p_dim_level_value_id ) = FND_API.G_TRUE
3372: ) THEN
3373: l_text := l_text || ' , Level value ID = ' || p_dim_level_value_id ;
3374: ELSE

Line 3371: bis_utilities_pvt.value_not_missing ( p_dim_level_value_id ) = FND_API.G_TRUE

3367:
3368:
3369: IF (
3370: bis_utilities_pvt.value_not_null ( p_dim_level_value_id ) = FND_API.G_TRUE AND
3371: bis_utilities_pvt.value_not_missing ( p_dim_level_value_id ) = FND_API.G_TRUE
3372: ) THEN
3373: l_text := l_text || ' , Level value ID = ' || p_dim_level_value_id ;
3374: ELSE
3375: l_text := l_text || ' , Dimension ' || p_dim_level_number || ' Level value id IS NULL/missing ' ;