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 BIS_UTILITIES_PUB

Line 245: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
245: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
246: )
247: IS
248:
249: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;

Line 284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

280:
281: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;
282: L_COMPARISION_SOURCE VARCHAR2(300);
283: L_ACTUAL_DATA_SOURCE VARCHAR2(300);
284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
286:
287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

281: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;
282: L_COMPARISION_SOURCE VARCHAR2(300);
283: L_ACTUAL_DATA_SOURCE VARCHAR2(300);
284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
286:
287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
289:

Line 287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

283: L_ACTUAL_DATA_SOURCE VARCHAR2(300);
284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
286:
287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
289:
290: L_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
291: l_parameter_tbl_type_p BIS_PMV_ACTUAL_PVT.parameter_tbl_type;

Line 288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
286:
287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
289:
290: L_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
291: l_parameter_tbl_type_p BIS_PMV_ACTUAL_PVT.parameter_tbl_type;
292: L_TIME_PARAMETER_REC_TYPE BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

Line 330: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

326:
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

Line 332: AND (BIS_UTILITIES_PUB.Value_Not_Null

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;
336: l_target_level_rec_p := l_Target_Level_Rec;

Line 352: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START: Dimension Level Values for this target ........... ' ) ;

348: l_actual_rec.target_Level_Id := p_measure_instance.Target_Level_ID;
349: l_actual_rec.Target_Level_short_name := p_measure_instance.Target_Level_short_name;
350: l_actual_rec.Target_Level_name := p_measure_instance.Target_Level_name;
351:
352: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START: Dimension Level Values for this target ........... ' ) ;
353:
354: BIS_UTILITIES_PUB.put_line(p_text => ' Parameters for this actual are ' ) ;
355:
356: for i IN 1..7 loop

Line 354: BIS_UTILITIES_PUB.put_line(p_text => ' Parameters for this actual are ' ) ;

350: l_actual_rec.Target_Level_name := p_measure_instance.Target_Level_name;
351:
352: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START: Dimension Level Values for this target ........... ' ) ;
353:
354: BIS_UTILITIES_PUB.put_line(p_text => ' Parameters for this actual are ' ) ;
355:
356: for i IN 1..7 loop
357:
358: l_count_p := l_count;

Line 389: BIS_UTILITIES_PUB.put_line(p_text => ' time level short name is ... ' || l_Time_Level_short_name ) ;

385: );
386:
387: END loop;
388:
389: BIS_UTILITIES_PUB.put_line(p_text => ' time level short name is ... ' || l_Time_Level_short_name ) ;
390:
391: get_view_by_level (
392: p_Target_Level_Rec => l_Target_Level_Rec
393: , p_Time_Level_short_name => l_Time_Level_short_name -- , P_TIME_PARAMETER_REC_TYPE => l_TIME_PARAMETER_REC_TYPE

Line 399: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END: Dimension Level Values for this target ........... ' ) ;

395: , x_view_by_level_short_name => l_view_by
396: , x_return_status => l_return_status
397: ) ;
398:
399: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END: Dimension Level Values for this target ........... ' ) ;
400:
401:
402: OPEN cr_performance_measures(l_target_level_rec.measure_short_name);
403:

Line 448: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retriving Actual value FROM PMV '||sqlerrm);

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
452: WHEN OTHERS THEN

Line 454: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retriving Actual value FROM PMV '||sqlerrm);

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:
458: BEGIN

Line 478: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retriving Actual value FROM PMV '||sqlerrm);

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:
482:

Line 489: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Actual and report url ........... ' ) ;

485: l_actual_rec.Comparison_actual_value := to_number(l_compare_value);
486: l_actual_rec.Report_URL := l_Rpt_Link;
487:
488:
489: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Actual and report url ........... ' ) ;
490: BIS_UTILITIES_PUB.put_line(p_text => ' Actual Value : ' || l_actual_value );
491: BIS_UTILITIES_PUB.put_line(p_text => ' Compare Value : ' || l_compare_value );
492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );
493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;

Line 490: BIS_UTILITIES_PUB.put_line(p_text => ' Actual Value : ' || l_actual_value );

486: l_actual_rec.Report_URL := l_Rpt_Link;
487:
488:
489: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Actual and report url ........... ' ) ;
490: BIS_UTILITIES_PUB.put_line(p_text => ' Actual Value : ' || l_actual_value );
491: BIS_UTILITIES_PUB.put_line(p_text => ' Compare Value : ' || l_compare_value );
492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );
493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;
494:

Line 491: BIS_UTILITIES_PUB.put_line(p_text => ' Compare Value : ' || l_compare_value );

487:
488:
489: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Actual and report url ........... ' ) ;
490: BIS_UTILITIES_PUB.put_line(p_text => ' Actual Value : ' || l_actual_value );
491: BIS_UTILITIES_PUB.put_line(p_text => ' Compare Value : ' || l_compare_value );
492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );
493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;
494:
495:

Line 492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );

488:
489: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Actual and report url ........... ' ) ;
490: BIS_UTILITIES_PUB.put_line(p_text => ' Actual Value : ' || l_actual_value );
491: BIS_UTILITIES_PUB.put_line(p_text => ' Compare Value : ' || l_compare_value );
492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );
493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;
494:
495:
496: -- BIS_UTILITIES_PUB.put_line(p_text =>'Target Level Passed ' || l_actual_rec.target_Level_Id );

Line 493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;

489: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Actual and report url ........... ' ) ;
490: BIS_UTILITIES_PUB.put_line(p_text => ' Actual Value : ' || l_actual_value );
491: BIS_UTILITIES_PUB.put_line(p_text => ' Compare Value : ' || l_compare_value );
492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );
493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;
494:
495:
496: -- BIS_UTILITIES_PUB.put_line(p_text =>'Target Level Passed ' || l_actual_rec.target_Level_Id );
497:

Line 496: -- BIS_UTILITIES_PUB.put_line(p_text =>'Target Level Passed ' || l_actual_rec.target_Level_Id );

492: BIS_UTILITIES_PUB.put_line(p_text => ' Report Link : ' || l_Rpt_Link );
493: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Actual and report url ........... ' ) ;
494:
495:
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

Line 513: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieve computed actual: '||sqlerrm);

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:
517:

Line 529: BEGIN -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 0000 ' ) ;

525: ) IS
526:
527: l_view_by VARCHAR2(80);
528:
529: BEGIN -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 0000 ' ) ;
530:
531: IF ( p_Time_Level_short_name IS NOT NULL ) THEN
532:
533: l_view_by := p_Time_Level_short_name ;

Line 539: ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 2222 ' ) ;

535: ELSE
536: IF (
537: ( P_PARAMETER_TBL_TYPE.COUNT > 0 ) AND
538: ( P_PARAMETER_TBL_TYPE.EXISTS(1) )
539: ) THEN -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 2222 ' ) ;
540:
541:
542: l_view_by := SUBSTR
543: (

Line 548: END IF; -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 3333 ' ) ;

544: P_PARAMETER_TBL_TYPE(1).parameter_name,
545: (INSTR(P_PARAMETER_TBL_TYPE(1).parameter_name,'+')+1)
546: );
547: END IF;
548: END IF; -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 3333 ' ) ;
549:
550: x_view_by_level_short_name := l_view_by ;
551: x_return_status := 'S' ;
552: BIS_UTILITIES_PUB.put_line(p_text => ' The view by level short name is : ' || x_view_by_level_short_name ) ;

Line 552: BIS_UTILITIES_PUB.put_line(p_text => ' The view by level short name is : ' || x_view_by_level_short_name ) ;

548: END IF; -- BIS_UTILITIES_PUB.put_line(p_text => ' xxxxxxxx 3333 ' ) ;
549:
550: x_view_by_level_short_name := l_view_by ;
551: x_return_status := 'S' ;
552: BIS_UTILITIES_PUB.put_line(p_text => ' The view by level short name is : ' || x_view_by_level_short_name ) ;
553:
554: EXCEPTION
555:
556: WHEN OTHERS THEN

Line 558: BIS_UTILITIES_PUB.put_line(p_text => ' The view by short name could not be found ' ) ;

554: EXCEPTION
555:
556: WHEN OTHERS THEN
557: x_return_status := 'E' ;
558: BIS_UTILITIES_PUB.put_line(p_text => ' The view by short name could not be found ' ) ;
559:
560: END;
561:
562:

Line 578: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
578: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
579: )
580: IS
581:
582: l_object_tbl object_tbl_type;

Line 601: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

597: l_compare_value NUMBER;
598: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
599: l_return_status VARCHAR2(32000);
600:
601: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
602: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;
603: L_COMPARISION_SOURCE VARCHAR2(300);
604: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
605:

Line 604: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

600:
601: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
602: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;
603: L_COMPARISION_SOURCE VARCHAR2(300);
604: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
605:
606:
607: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
608: SELECT comparison_source

Line 615: -- BIS_UTILITIES_PUB.put_line(p_text =>'Computing actual value.');

611:
612:
613: BEGIN
614:
615: -- BIS_UTILITIES_PUB.put_line(p_text =>'Computing actual value.');
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

Line 619: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

615: -- BIS_UTILITIES_PUB.put_line(p_text =>'Computing actual value.');
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

Line 621: AND (BIS_UTILITIES_PUB.Value_Not_Null

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;
625: l_target_level_rec_p := l_Target_Level_Rec;

Line 661: --BIS_UTILITIES_PUB.put_line(p_text =>'measure : '||l_Target_Level_Rec.measure_short_name);

657: END IF;
658:
659: END loop;
660:
661: --BIS_UTILITIES_PUB.put_line(p_text =>'measure : '||l_Target_Level_Rec.measure_short_name);
662:
663: OPEN cr_performance_measures(l_target_level_rec.measure_short_name);
664: FETCH cr_performance_measures INTO L_COMPARISION_SOURCE;
665: IF cr_performance_measures%NOTFOUND THEN

Line 693: -- BIS_UTILITIES_PUB.put_line(p_text =>'data source: '||l_database_object_name);

689: , x_database_object_name => l_database_object_name
690: , x_return_status => l_return_status
691: );
692:
693: -- BIS_UTILITIES_PUB.put_line(p_text =>'data source: '||l_database_object_name);
694:
695: -- Get object attributes;
696: --
697: Get_Object_Attributes

Line 739: -- BIS_UTILITIES_PUB.put_line(p_text =>'select_clause: '||l_select_clause);

735: , x_where_clause => l_where_clause
736: , x_group_by_clause => l_group_by_clause
737: , x_return_status => l_return_status
738: );
739: -- BIS_UTILITIES_PUB.put_line(p_text =>'select_clause: '||l_select_clause);
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:

Line 740: -- BIS_UTILITIES_PUB.put_line(p_text =>'from_clause: '||l_from_clause);

736: , x_group_by_clause => l_group_by_clause
737: , x_return_status => l_return_status
738: );
739: -- BIS_UTILITIES_PUB.put_line(p_text =>'select_clause: '||l_select_clause);
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

Line 741: -- BIS_UTILITIES_PUB.put_line(p_text =>'where_clause: '||l_where_clause);

737: , x_return_status => l_return_status
738: );
739: -- BIS_UTILITIES_PUB.put_line(p_text =>'select_clause: '||l_select_clause);
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

Line 742: -- BIS_UTILITIES_PUB.put_line(p_text =>'group by_clause: '||l_group_by_clause);

738: );
739: -- BIS_UTILITIES_PUB.put_line(p_text =>'select_clause: '||l_select_clause);
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

Line 754: BIS_UTILITIES_PUB.put_line(p_text =>'Finished executing query; status is: '||l_return_status );

750: , x_Actual_value => l_Actual_value
751: , x_compare_value => l_compare_value
752: , x_return_status => l_return_status
753: );
754: BIS_UTILITIES_PUB.put_line(p_text =>'Finished executing query; status is: '||l_return_status );
755:
756: Form_Actual_Rec
757: ( p_Measure_Instance => l_Measure_Instance
758: , p_dim_level_value_tbl => l_dim_level_value_tbl

Line 780: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieve computed actual: '||sqlerrm);

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:
784: -- Code added for 1850860 starts here

Line 794: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

790: )
791: IS
792:
793: l_object_tbl object_tbl_type;
794: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
795: l_actual_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
796: l_actual_data_source VARCHAR2(300);
797: l_actual_region_item ak_region_items.item_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
798:

Line 797: l_actual_region_item ak_region_items.item_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

793: l_object_tbl object_tbl_type;
794: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
795: l_actual_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
796: l_actual_data_source VARCHAR2(300);
797: l_actual_region_item ak_region_items.item_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
798:
799: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
800: SELECT actual_data_source
801: FROM bisbv_performance_measures

Line 825: -- BIS_UTILITIES_PUB.put_line(p_text =>'get related obj. measure: '||p_measure_short_name);

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;
829: --

Line 827: BIS_UTILITIES_PUB.put_line(p_text =>'Perforamance Measure short name ' || p_measure_short_name);

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;
829: --
830: OPEN cr_performance_measures(p_measure_short_name);
831: FETCH cr_performance_measures INTO l_actual_data_source;

Line 834: BIS_UTILITIES_PUB.put_line(p_text =>'Actual Data Source ' || l_actual_data_source);

830: OPEN cr_performance_measures(p_measure_short_name);
831: FETCH cr_performance_measures INTO l_actual_data_source;
832: CLOSE cr_performance_measures;
833:
834: BIS_UTILITIES_PUB.put_line(p_text =>'Actual Data Source ' || l_actual_data_source);
835: l_actual_region_item := SUBSTR(l_actual_data_source, (INSTR(l_actual_data_source,'.')+1));
836: l_actual_region_code := SUBSTR(l_actual_data_source, 1, (INSTR(l_actual_data_source,'.')-1));
837:
838: OPEN cr_region_items (l_actual_region_item, l_actual_region_code);

Line 854: -- BIS_UTILITIES_PUB.put_line(p_text =>'number of objects, status: '||x_object_tbl.count

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
855: -- ||', '||x_return_status);
856:
857: EXCEPTION
858: WHEN OTHERS THEN

Line 860: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Related_Objects: '||sqlerrm);

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:
864: -- Code added for 1850860 ends here

Line 899: -- BIS_UTILITIES_PUB.put_line(p_text =>'get related obj. measure: '||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: --
903: FOR cr_item IN cr_region_item LOOP

Line 904: -- BIS_UTILITIES_PUB.put_line(p_text =>'Region code: '||cr_item.region_code);

900:
901: -- SELECT all objects which reference this measure;
902: --
903: FOR cr_item IN cr_region_item LOOP
904: -- BIS_UTILITIES_PUB.put_line(p_text =>'Region code: '||cr_item.region_code);
905: IF l_region_code <> cr_item.region_code THEN
906: l_region_code := cr_item.region_code;
907: l_region_application_id := cr_item.region_application_id;
908:

Line 924: -- BIS_UTILITIES_PUB.put_line(p_text =>'number of objects, status: '||x_object_tbl.count

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
925: -- ||', '||x_return_status);
926:
927: EXCEPTION
928: WHEN OTHERS THEN

Line 930: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Related_Objects: '||sqlerrm);

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: ***
934: ** Code commented by for 1850860 ends here

Line 944: l_database_object_name VARCHAR2(32000) := BIS_UTILITIES_PUB.G_NULL_CHAR;

940: , x_return_status OUT NOCOPY VARCHAR2
941: )
942: IS
943:
944: l_database_object_name VARCHAR2(32000) := BIS_UTILITIES_PUB.G_NULL_CHAR;
945: l_numobjects NUMBER := 0;
946:
947: BEGIN
948:

Line 959: BIS_UTILITIES_PUB.put_line(p_text =>'AK IS not setup.');

955: l_database_object_name := p_object_tbl(i).DATABASE_OBJECT_NAME;
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

Line 964: BIS_UTILITIES_PUB.put_line(p_text =>'More than one data source found for this measure.');

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.');
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:

Line 965: BIS_UTILITIES_PUB.put_line(p_text =>'The data source that will be used is: '||l_database_object_name);

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.');
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);

Line 969: --BIS_UTILITIES_PUB.put_line(p_text =>'Object name, numObj: '||l_database_object_name||', '||l_numobjects);

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;
971:
972: EXCEPTION
973: WHEN OTHERS THEN

Line 975: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Object_Data_Source: '||sqlerrm);

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:
979: PROCEDURE Get_Object_Attributes

Line 994: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

990: l_object_attribute_tbl object_attribute_tbl_type ;
991: l_dim_level_value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
992: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
993: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
994: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
995:
996: CURSOR cr_attribute
997: ( p_region_code ak_regions.REGION_CODE%TYPE
998: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE

Line 1019: IF (BIS_UTILITIES_PUB.Value_Missing

1015:
1016:
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)

Line 1022: OR (BIS_UTILITIES_PUB.Value_Null

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
1026: l_Dimension_Level_Rec.Dimension_Level_id

Line 1042: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieving dimension level');

1038: l_dim_level_value_Tbl(i).Dimension_Level_short_name
1039: := l_Dimension_Level_Rec.Dimension_Level_short_name;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieving dimension level');
1043: return;
1044: END;
1045: END IF;
1046: END LOOP;

Line 1050: -- BIS_UTILITIES_PUB.put_line(p_text =>'OutSide the Object For loop' );

1046: END LOOP;
1047:
1048: -- get the measure's object attribute
1049: --
1050: -- BIS_UTILITIES_PUB.put_line(p_text =>'OutSide the Object For loop' );
1051:
1052: IF p_object_tbl.COUNT > 0 THEN
1053:
1054: BEGIN

Line 1068: -- BIS_UTILITIES_PUB.put_line(p_text =>'Compare Region : '|| p_compare_region_item);

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);
1069:
1070: BEGIN
1071: Select *
1072: INTO l_object_attribute_tbl(l_object_attribute_tbl.COUNT+1)

Line 1080: BIS_UTILITIES_PUB.put_line(p_text =>'No Comparison Data Source ');

1076: AND ATTRIBUTE1 = 'MEASURE'
1077: AND ATTRIBUTE_CODE = p_compare_region_item;
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:

Line 1087: -- BIS_UTILITIES_PUB.put_line(p_text =>'number of objects, status: '||p_object_tbl.count);

1083: END;
1084:
1085: END IF;
1086:
1087: -- BIS_UTILITIES_PUB.put_line(p_text =>'number of objects, status: '||p_object_tbl.count);
1088:
1089: -- SELECT each object's attributes that match the given dimension levels;
1090: --
1091: FOR i IN 1..p_object_tbl.COUNT LOOP

Line 1093: --BIS_UTILITIES_PUB.put_line(p_text =>'Inside the Object For loop' );

1089: -- SELECT each object's attributes that match the given dimension levels;
1090: --
1091: FOR i IN 1..p_object_tbl.COUNT LOOP
1092:
1093: --BIS_UTILITIES_PUB.put_line(p_text =>'Inside the Object For loop' );
1094: IF l_dim_level_value_Tbl.COUNT = 0 or ( i >=2 )
1095: THEN EXIT; END IF;
1096: -- BIS_UTILITIES_PUB.put_line(p_text =>'retrieving attr for obj: '||p_object_tbl(i).region_code);
1097:

Line 1096: -- BIS_UTILITIES_PUB.put_line(p_text =>'retrieving attr for obj: '||p_object_tbl(i).region_code);

1092:
1093: --BIS_UTILITIES_PUB.put_line(p_text =>'Inside the Object For loop' );
1094: IF l_dim_level_value_Tbl.COUNT = 0 or ( i >=2 )
1095: THEN EXIT; END IF;
1096: -- BIS_UTILITIES_PUB.put_line(p_text =>'retrieving attr for obj: '||p_object_tbl(i).region_code);
1097:
1098: FOR j IN 1..l_dim_level_value_Tbl.COUNT LOOP
1099: --BIS_UTILITIES_PUB.put_line(p_text =>'dimension level value tbl count, j: '
1100: --||l_dim_level_value_Tbl.COUNT||', '||j);

Line 1099: --BIS_UTILITIES_PUB.put_line(p_text =>'dimension level value tbl count, j: '

1095: THEN EXIT; END IF;
1096: -- BIS_UTILITIES_PUB.put_line(p_text =>'retrieving attr for obj: '||p_object_tbl(i).region_code);
1097:
1098: FOR j IN 1..l_dim_level_value_Tbl.COUNT LOOP
1099: --BIS_UTILITIES_PUB.put_line(p_text =>'dimension level value tbl count, j: '
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)

Line 1102: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

1098: FOR j IN 1..l_dim_level_value_Tbl.COUNT LOOP
1099: --BIS_UTILITIES_PUB.put_line(p_text =>'dimension level value tbl count, j: '
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)

Line 1105: AND (BIS_UTILITIES_PUB.Value_Not_Null

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
1109: OPEN cr_attribute

Line 1117: --BIS_UTILITIES_PUB.put_line(p_text =>'dimension level attribute not found: '

1113: );
1114: FETCH cr_attribute
1115: INTO l_object_attribute_tbl(l_object_attribute_tbl.COUNT+1);
1116: IF cr_attribute%NOTFOUND THEN
1117: --BIS_UTILITIES_PUB.put_line(p_text =>'dimension level attribute not found: '
1118: -- ||l_dim_level_value_Tbl(j).dimension_level_short_name);
1119: CLOSE cr_attribute;
1120: ELSE
1121: l_dim_level_value_Tbl.DELETE(j);

Line 1123: BIS_UTILITIES_PUB.put_line(p_text =>'attribute, col: '

1119: CLOSE cr_attribute;
1120: ELSE
1121: l_dim_level_value_Tbl.DELETE(j);
1122: /*
1123: BIS_UTILITIES_PUB.put_line(p_text =>'attribute, col: '
1124: ||l_object_attribute_tbl(l_object_attribute_tbl.COUNT).ATTRIBUTE_CODE
1125: ||', '
1126: ||l_object_attribute_tbl(l_object_attribute_tbl.COUNT).ATTRIBUTE2);
1127: */

Line 1143: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Object_Attributes: '||sqlerrm);

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:
1147: PROCEDURE Get_Obj_Attribute_Data_Source

Line 1156: l_object_attribute_name VARCHAR2(32000) := BIS_UTILITIES_PUB.G_NULL_CHAR;

1152: )
1153: IS
1154:
1155: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
1156: l_object_attribute_name VARCHAR2(32000) := BIS_UTILITIES_PUB.G_NULL_CHAR;
1157: l_count NUMBER := 0;
1158:
1159: BEGIN
1160:

Line 1180: BIS_UTILITIES_PUB.put_line(p_text =>'col name: '

1176: := p_object_attribute_tbl(i).attribute3;
1177: l_Measure_Inst_DB_Obj_tbl(l_count).Database_Obj_Column_Type
1178: := get_dim_level_short_name(p_object_attribute_tbl(i).attribute2);
1179: /*
1180: BIS_UTILITIES_PUB.put_line(p_text =>'col name: '
1181: ||l_Measure_Inst_DB_Obj_tbl(l_count).Database_Obj_Column_Name
1182: ||', col type: '
1183: ||l_Measure_Inst_DB_Obj_tbl(l_count).Database_Obj_Column_Type);
1184: */

Line 1192: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Obj_Attribute_Data_Source: '||sqlerrm);

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:
1196:

Line 1208: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1204: )
1205: IS
1206:
1207: l_dim_level_value_id VARCHAR2(80) := NULL;
1208: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
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

Line 1248: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_dimension_level_value Function: '||sqlerrm);

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:
1252:

Line 1267: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1263: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1264: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1265: l_time_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
1266: l_time_dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
1267: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1268: l_is_time BOOLEAN := FALSE;
1269:
1270: BEGIN
1271: -- BIS_UTILITIES_PUB.put_line(p_text =>'Getting dimension level values');

Line 1271: -- BIS_UTILITIES_PUB.put_line(p_text =>'Getting dimension level values');

1267: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
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

Line 1291: -- BIS_UTILITIES_PUB.put_line(p_text =>'Number of time levels retrieved: '||l_time_Dimension_Level_tbl.count);

1287: , x_return_status => x_return_status
1288: , x_error_Tbl => l_error_tbl
1289: );
1290:
1291: -- BIS_UTILITIES_PUB.put_line(p_text =>'Number of time levels retrieved: '||l_time_Dimension_Level_tbl.count);
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)

Line 1294: IF (BIS_UTILITIES_PUB.Value_Missing

1290:
1291: -- BIS_UTILITIES_PUB.put_line(p_text =>'Number of time levels retrieved: '||l_time_Dimension_Level_tbl.count);
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)

Line 1297: OR (BIS_UTILITIES_PUB.Value_Null

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
1301: l_Dimension_Level_Rec.Dimension_Level_id

Line 1317: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieving dimension level');

1313: l_dim_level_value_Tbl(i).Dimension_Level_short_name
1314: := l_Dimension_Level_Rec.Dimension_Level_short_name;
1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN retrieving dimension level');
1318: return;
1319: END;
1320: END IF;
1321: END LOOP;

Line 1349: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time period column value: '

1345: IF l_is_time THEN
1346: l_Measure_Inst_DB_Obj_tbl(j).Column_value
1347: := get_time_period_name
1348: (l_dim_level_value_Tbl(i).dimension_level_value_id);
1349: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time period column value: '
1350: -- ||l_Measure_Inst_DB_Obj_tbl(j).Column_value);
1351: ELSE
1352: l_Measure_Inst_DB_Obj_tbl(j).Column_value
1353: := l_dim_level_value_Tbl(i).dimension_level_value_id;

Line 1367: -- BIS_UTILITIES_PUB.put_line(p_text =>'measure inst object clolum '

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.'
1370: -- );
1371:

Line 1374: -- BIS_UTILITIES_PUB.put_line(p_text =>'col name: '

1370: -- );
1371:
1372: END IF;
1373:
1374: -- BIS_UTILITIES_PUB.put_line(p_text =>'col name: '
1375: -- ||l_Measure_Inst_DB_Obj_tbl(i).Database_Obj_Column_Name
1376: -- ||', col type: '
1377: -- ||l_Measure_Inst_DB_Obj_tbl(i).Database_Obj_Column_Type
1378: -- ||', col value: '

Line 1389: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_dimension_level_values: '||sqlerrm);

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:
1393:

Line 1470: BIS_UTILITIES_PUB.put_line(p_text =>'select: ' ||l_select_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);
1472: BIS_UTILITIES_PUB.put_line(p_text =>'where: ' ||l_where_clause);
1473: BIS_UTILITIES_PUB.put_line(p_text =>'group by: '||l_group_by_clause);
1474:

Line 1471: BIS_UTILITIES_PUB.put_line(p_text =>'from: ' ||l_from_clause);

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);
1472: BIS_UTILITIES_PUB.put_line(p_text =>'where: ' ||l_where_clause);
1473: BIS_UTILITIES_PUB.put_line(p_text =>'group by: '||l_group_by_clause);
1474:
1475: x_select_clause := l_select_clause;

Line 1472: BIS_UTILITIES_PUB.put_line(p_text =>'where: ' ||l_where_clause);

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);
1472: BIS_UTILITIES_PUB.put_line(p_text =>'where: ' ||l_where_clause);
1473: BIS_UTILITIES_PUB.put_line(p_text =>'group by: '||l_group_by_clause);
1474:
1475: x_select_clause := l_select_clause;
1476: x_from_clause := l_from_clause;

Line 1473: BIS_UTILITIES_PUB.put_line(p_text =>'group by: '||l_group_by_clause);

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);
1472: BIS_UTILITIES_PUB.put_line(p_text =>'where: ' ||l_where_clause);
1473: BIS_UTILITIES_PUB.put_line(p_text =>'group by: '||l_group_by_clause);
1474:
1475: x_select_clause := l_select_clause;
1476: x_from_clause := l_from_clause;
1477: x_where_clause := l_where_clause;

Line 1483: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_Query_Statement: '||sqlerrm);

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:
1487: PROCEDURE Build_select_clause

Line 1504: -- BIS_UTILITIES_PUB.put_line(p_text =>'Inside Select PROCEDURE ');

1500: l_function VARCHAR2(32000) := NULL;
1501:
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

Line 1510: BIS_UTILITIES_PUB.put_line(p_text =>'Inside the For Loop ');

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 ');
1511:
1512: l_function := Get_Aggregate_Function( p_Measure_Instance_Obj_tbl(i));
1513:
1514: IF p_Measure_Instance_Obj_tbl(i).Database_Obj_Column_type

Line 1517: BIS_UTILITIES_PUB.put_line(p_text =>'Inside the First IF');

1513:
1514: IF p_Measure_Instance_Obj_tbl(i).Database_Obj_Column_type
1515: = p_measure_short_name
1516: THEN
1517: BIS_UTILITIES_PUB.put_line(p_text =>'Inside the First IF');
1518: IF l_function IS NOT NULL THEN
1519: l_actual_clause := l_function||'( '
1520: ||p_Measure_Instance_Obj_tbl(i).Database_Obj_Column_Name
1521: ||' ) ';

Line 1532: BIS_UTILITIES_PUB.put_line(p_text =>'Inside the second IF');

1528:
1529: IF p_Measure_Instance_Obj_tbl(i).Attribute_code
1530: = p_compare_region_item
1531: THEN
1532: BIS_UTILITIES_PUB.put_line(p_text =>'Inside the second IF');
1533: IF l_function IS NOT NULL THEN
1534: l_compare_clause
1535: := l_function||'( '
1536: ||p_Measure_Instance_Obj_tbl(i).Database_Obj_Column_Name

Line 1565: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_select_clause: '||sqlerrm);

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:
1569: PROCEDURE Build_from_clause

Line 1594: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_from_clause: '||sqlerrm);

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:
1598: PROCEDURE Build_where_clause

Line 1641: BIS_UTILITIES_PUB.put_line(p_text =>'WHERE clause: '||l_where_clause);

1637: IF l_where_clause IS NOT NULL THEN
1638: l_where_clause := ' WHERE '||l_where_clause;
1639: END IF;
1640:
1641: BIS_UTILITIES_PUB.put_line(p_text =>'WHERE clause: '||l_where_clause);
1642: x_where_clause := l_where_clause;
1643:
1644: EXCEPTION
1645: WHEN OTHERS THEN

Line 1647: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_where_clause: '||sqlerrm);

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:
1651: PROCEDURE Build_group_by_clause

Line 1693: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Build_group_by_clause: '||sqlerrm);

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:
1697: PROCEDURE Execute_Query

Line 1718: BIS_UTILITIES_PUB.put_line(p_text =>'sql statement: '||substr(l_stmt,0,200));

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));
1719: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,200,200));
1720: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,400));
1721:
1722: BEGIN

Line 1719: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,200,200));

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));
1719: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,200,200));
1720: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,400));
1721:
1722: BEGIN
1723: EXECUTE IMMEDIATE l_stmt INTO l_actual_value, l_compare_value;

Line 1720: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,400));

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));
1719: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,200,200));
1720: BIS_UTILITIES_PUB.put_line(p_text =>substr(l_stmt,400));
1721:
1722: BEGIN
1723: EXECUTE IMMEDIATE l_stmt INTO l_actual_value, l_compare_value;
1724: EXCEPTION

Line 1730: BIS_UTILITIES_PUB.put_line(p_text =>'error with exec statement: '||sqlerrm);

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;
1734: x_compare_value := l_compare_value;

Line 1736: BIS_UTILITIES_PUB.put_line(p_text =>'Actual value computed: '||l_actual_value);

1732:
1733: x_actual_value := l_actual_value;
1734: x_compare_value := l_compare_value;
1735:
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 ;

Line 1741: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Execute_Query: '||sqlerrm);

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:
1745: PROCEDURE Save_Report_URL

Line 1760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1756: ) is
1757:
1758:
1759: l_return_status VARCHAR2(32000);
1760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1761: l_target_rec BIS_TARGET_PUB.Target_rec_type;
1762: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1763: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
1764: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;

Line 1816: --BIS_UTILITIES_PUB.put_line(p_text =>'In Save Reprot' );

1812:
1813:
1814: BEGIN
1815:
1816: --BIS_UTILITIES_PUB.put_line(p_text =>'In Save Reprot' );
1817: l_measure_rec.measure_id := p_measure_instance.measure_id;
1818:
1819: l_measure_rec_p := l_measure_rec;
1820: BIS_MEASURE_PUB.Retrieve_Measure

Line 1831: --BIS_UTILITIES_PUB.put_line(p_text =>'Time Level Id ' || p_time_level_id);

1827:
1828: -- 2841680
1829: -- l_actual_region_code := SUBSTR(l_measure_rec.Actual_Data_Source, 1, (INSTR(l_measure_rec.Actual_Data_Source,'.')-1));
1830:
1831: --BIS_UTILITIES_PUB.put_line(p_text =>'Time Level Id ' || p_time_level_id);
1832:
1833: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target
1834: ( p_measure_instance => p_measure_instance
1835: , p_dim_level_value_tbl => p_dim_level_value_tbl

Line 1852: -- BIS_UTILITIES_PUB.put_line(p_text =>' Test Org level value id is: ' || l_Org_Level_Value_ID ) ;

1848:
1849: l_Org_Level_Value_ID := l_Dim_Level_value_Rec_oltp.Dimension_Level_Value_ID;
1850: l_Org_Level_Short_name := l_Dim_Level_value_Rec_oltp.Dimension_Level_short_name;
1851:
1852: -- BIS_UTILITIES_PUB.put_line(p_text =>' Test Org level value id is: ' || l_Org_Level_Value_ID ) ;
1853: -- BIS_UTILITIES_PUB.put_line(p_text =>' Test Org level short name is: ' || l_Org_Level_Short_name ) ;
1854:
1855: -- l_target_level_rec.target_level_id := l_target_rec.target_level_id;
1856: -- l_target_level_rec.measure_id := l_measure_rec.measure_id;

Line 1853: -- BIS_UTILITIES_PUB.put_line(p_text =>' Test Org level short name is: ' || l_Org_Level_Short_name ) ;

1849: l_Org_Level_Value_ID := l_Dim_Level_value_Rec_oltp.Dimension_Level_Value_ID;
1850: l_Org_Level_Short_name := l_Dim_Level_value_Rec_oltp.Dimension_Level_short_name;
1851:
1852: -- BIS_UTILITIES_PUB.put_line(p_text =>' Test Org level value id is: ' || l_Org_Level_Value_ID ) ;
1853: -- BIS_UTILITIES_PUB.put_line(p_text =>' Test Org level short name is: ' || l_Org_Level_Short_name ) ;
1854:
1855: -- l_target_level_rec.target_level_id := l_target_rec.target_level_id;
1856: -- l_target_level_rec.measure_id := l_measure_rec.measure_id;
1857:

Line 1859: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level Id ' || p_time_level_id);

1855: -- l_target_level_rec.target_level_id := l_target_rec.target_level_id;
1856: -- l_target_level_rec.measure_id := l_measure_rec.measure_id;
1857:
1858:
1859: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level Id ' || p_time_level_id);
1860:
1861: l_time_level_short_name :=
1862: SUBSTR(P_TIME_PARAMETER.time_parameter_name,
1863: (INSTR(P_TIME_PARAMETER.time_parameter_name,'+')+1));

Line 1867: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level value ' || l_time_level_value);

1863: (INSTR(P_TIME_PARAMETER.time_parameter_name,'+')+1));
1864:
1865: l_time_level_value := P_TIME_PARAMETER.time_from_value;
1866:
1867: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time Level value ' || l_time_level_value);
1868:
1869:
1870: IF p_time_level_id IS not NULL THEN
1871:

Line 1953: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time To IF no error ' || l_to);

1949:
1950: END IF;
1951:
1952:
1953: -- BIS_UTILITIES_PUB.put_line(p_text =>'Time To IF no error ' || l_to);
1954:
1955: IF P_PARAMETER.exists(1) THEN
1956: l_Parm1Level_short_name :=
1957: SUBSTR(P_PARAMETER(1).parameter_name,

Line 2092: BIS_UTILITIES_PUB.put_line(p_text => x_error_msg ) ;

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;
2096:

Line 2182: BIS_UTILITIES_PUB.put_line(p_text =>'Aggregate function used to compute actual: '||l_function);

2178: FROM ak_region_items
2179: WHERE region_code = p_Measure_Instance_Obj_rec.region_code
2180: AND ATTRIBUTE_CODE = p_Measure_Instance_Obj_rec.attribute_code;
2181:
2182: BIS_UTILITIES_PUB.put_line(p_text =>'Aggregate function used to compute actual: '||l_function);
2183: return l_function;
2184:
2185: EXCEPTION
2186: WHEN OTHERS THEN

Line 2187: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Aggregate_Function: '||sqlerrm);

2183: return l_function;
2184:
2185: EXCEPTION
2186: WHEN OTHERS THEN
2187: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Aggregate_Function: '||sqlerrm);
2188: END;
2189:
2190: PROCEDURE Form_Actual_Rec
2191: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type

Line 2206: --BIS_UTILITIES_PUB.put_line(p_text =>'in form actual rec');

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
2209: ( p_measure_instance => p_measure_instance
2210: , p_dim_level_value_tbl => p_dim_level_value_tbl

Line 2216: -- BIS_UTILITIES_PUB.put_line(p_text =>'Compare Value ' || l_actual_rec.Comparison_actual_value);

2212: );
2213: l_actual_rec.Actual := p_actual_value;
2214: l_actual_rec.Comparison_actual_value := p_compare_value;
2215:
2216: -- BIS_UTILITIES_PUB.put_line(p_text =>'Compare Value ' || l_actual_rec.Comparison_actual_value);
2217:
2218: x_actual_rec := l_actual_rec ;
2219:
2220: --BIS_UTILITIES_PUB.put_line(p_text =>'END form actual rec.');

Line 2220: --BIS_UTILITIES_PUB.put_line(p_text =>'END form actual rec.');

2216: -- BIS_UTILITIES_PUB.put_line(p_text =>'Compare Value ' || l_actual_rec.Comparison_actual_value);
2217:
2218: x_actual_rec := l_actual_rec ;
2219:
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 ;

Line 2225: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Form_Actual_Rec: '||sqlerrm);

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:
2229: PROCEDURE Validate_Computed_Actual

Line 2234: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
2236: IS
2237: --
2238: l_return_status VARCHAR2(10);

Line 2239: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2235: )
2236: IS
2237: --
2238: l_return_status VARCHAR2(10);
2239: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2240: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2241: --
2242: BEGIN
2243:

Line 2240: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

2236: IS
2237: --
2238: l_return_status VARCHAR2(10);
2239: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
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;

Line 2498: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
2500: IS
2501: BEGIN
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2503: -- BIS_UTILITIES_PUB.put_line(p_text =>'In PVT Validate_Required_Fields');

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
2507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2516: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2512: ( p_api_version IN NUMBER
2513: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2514: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
2515: , x_return_status OUT NOCOPY VARCHAR2
2516: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2517: )
2518: IS
2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

Line 2532: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Target_Level_ID)

2528: l_Actual_Rec := p_Actual_Rec;
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

Line 2534: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Target_Level_ID)

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
2538: /*

Line 2539: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. TL is: '

2535: = FND_API.G_TRUE
2536: THEN
2537: BEGIN
2538: /*
2539: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. TL is: '
2540: ||l_actual_rec.Target_Level_id||' - '
2541: ||l_actual_rec.Target_Level_short_name||' - '
2542: ||l_actual_rec.Target_Level_name);
2543: */

Line 2558: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. Retrived TL is: '

2554: l_Target_Level_rec.Target_Level_short_name
2555: := l_actual_rec.Target_Level_short_name;
2556: l_Target_Level_rec.Target_Level_name := l_actual_rec.Target_Level_name;
2557: /*
2558: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. Retrived TL is: '
2559: ||l_target_level_rec.Target_Level_id||' - '
2560: ||l_target_level_rec.Target_Level_short_name||' - '
2561: ||l_target_level_rec.Target_Level_name);
2562:

Line 2572: -- BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. EXEC ERROR');

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
2575: NULL;
2576: -- BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. OTHER');

Line 2576: -- BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. OTHER');

2572: -- BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. EXEC ERROR');
2573:
2574: WHEN OTHERS THEN
2575: NULL;
2576: -- BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. OTHER');
2577:
2578: END;
2579: ELSE
2580: l_target_level_rec.Target_Level_ID := l_actual_rec.Target_Level_ID;

Line 2596: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. EXEC ERROR');

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');
2600:

Line 2599: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. OTHER');

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');
2600:
2601: END;
2602:
2603: /*

Line 2606: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Org_level_value_ID)

2602:
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

Line 2608: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Org_level_value_ID)

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 ');
2612:

Line 2611: BIS_UTILITIES_PUB.put_line(p_text =>'in actual api. Org level missing ');

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
2614: l_Dim_Level_Value_Rec2.Dimension_Level_ID
2615: := l_target_level_rec.org_level_id;

Line 2642: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Time_Level_value_ID)

2638: END IF;
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

Line 2644: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Time_Level_value_ID)

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
2648: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2674: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim1_Level_value_ID)

2670: */
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

Line 2676: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim1_Level_value_ID)

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
2680: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2705: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim2_Level_value_ID)

2701: END IF;
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

Line 2707: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim2_Level_value_ID)

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
2711: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2736: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim3_Level_value_ID)

2732: END IF;
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

Line 2738: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim3_Level_value_ID)

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
2742: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2767: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim4_Level_value_ID)

2763: END IF;
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

Line 2769: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim4_Level_value_ID)

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
2773: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2798: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim5_Level_value_ID)

2794: END IF;
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

Line 2800: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim5_Level_value_ID)

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
2804: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2829: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim6_Level_value_ID)

2825: END IF;
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

Line 2831: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim6_Level_value_ID)

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
2835: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2860: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Dim7_Level_value_ID)

2856: END IF;
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

Line 2862: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Dim7_Level_value_ID)

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
2866: l_Dim_Level_Value_Rec.Dimension_Level_ID

Line 2892: IF BIS_UTILITIES_PUB.Value_Missing(l_actual_rec.Responsibility_ID)

2888:
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

Line 2894: OR BIS_UTILITIES_PUB.Value_Null(l_actual_rec.Responsibility_ID)

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
2898: BIS_Responsibility_PVT.Value_ID_Conversion

Line 2932: --BIS_UTILITIES_PUB.put_line(p_text =>'time_period: '||substr( p_time_level_value_id

2928: FUNCTION get_time_period_name(p_time_level_value_id IN VARCHAR2)
2929: RETURN VARCHAR2
2930: IS
2931: BEGIN
2932: --BIS_UTILITIES_PUB.put_line(p_text =>'time_period: '||substr( p_time_level_value_id
2933: -- , instr(p_time_level_value_id,'+')+1)) ;
2934:
2935: return substr( p_time_level_value_id
2936: , instr(p_time_level_value_id,'+')+1) ;

Line 2970: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN IS_TIME_DIMENSION_LEVEL Function: '||sqlerrm);

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:
2974: --

Line 3042: BIS_UTILITIES_PUB.put_line(p_text => ' Error IN get_Parameters_For_Actual 0100 : Dim level NUMBER should be 1 to 7 ' );

3038: l_dim_level_id := p_target_level_rec.dimension6_level_id;
3039: ELSIF p_dimension_number = 7 THEN
3040: l_dim_level_id := p_target_level_rec.dimension7_level_id;
3041: ELSE
3042: BIS_UTILITIES_PUB.put_line(p_text => ' Error IN get_Parameters_For_Actual 0100 : Dim level NUMBER should be 1 to 7 ' );
3043: END IF;
3044:
3045:
3046: IF l_dim_level_id IS not NULL THEN

Line 3076: BIS_UTILITIES_PUB.put_line(p_text => ' dim short name = ' || l_DimShortName ) ;

3072:
3073: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- 2408906
3074: p_level_short_name => l_DimLevelShortName );
3075:
3076: BIS_UTILITIES_PUB.put_line(p_text => ' dim short name = ' || l_DimShortName ) ;
3077: BIS_UTILITIES_PUB.put_line(p_text => ' l_Is_Rolling_Period_Level = ' || l_Is_Rolling_Period_Level ) ; -- 2408906
3078:
3079: print_to_log_dim_level_info
3080: ( p_dim_level_id => l_dim_level_id,

Line 3077: BIS_UTILITIES_PUB.put_line(p_text => ' l_Is_Rolling_Period_Level = ' || l_Is_Rolling_Period_Level ) ; -- 2408906

3073: l_Is_Rolling_Period_Level := BIS_UTILITIES_PVT.Is_Rolling_Period_Level( -- 2408906
3074: p_level_short_name => l_DimLevelShortName );
3075:
3076: BIS_UTILITIES_PUB.put_line(p_text => ' dim short name = ' || l_DimShortName ) ;
3077: BIS_UTILITIES_PUB.put_line(p_text => ' l_Is_Rolling_Period_Level = ' || l_Is_Rolling_Period_Level ) ; -- 2408906
3078:
3079: print_to_log_dim_level_info
3080: ( p_dim_level_id => l_dim_level_id,
3081: p_dim_level_value_id => l_DimLevelValueId,

Line 3094: BIS_UTILITIES_PUB.put_line(p_text => ' l_time_level_id = ' || l_time_level_id );

3090: l_Time_Level_short_name := l_DimLevelShortName;
3091: l_Time_Level_value_id := l_DimLevelValueId;
3092:
3093: /*
3094: BIS_UTILITIES_PUB.put_line(p_text => ' l_time_level_id = ' || l_time_level_id );
3095: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_short_name ' || l_Time_Level_short_name );
3096: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_value_id ' || l_Time_Level_value_id );
3097: */
3098:

Line 3095: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_short_name ' || l_Time_Level_short_name );

3091: l_Time_Level_value_id := l_DimLevelValueId;
3092:
3093: /*
3094: BIS_UTILITIES_PUB.put_line(p_text => ' l_time_level_id = ' || l_time_level_id );
3095: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_short_name ' || l_Time_Level_short_name );
3096: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_value_id ' || l_Time_Level_value_id );
3097: */
3098:
3099: END IF;

Line 3096: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_value_id ' || l_Time_Level_value_id );

3092:
3093: /*
3094: BIS_UTILITIES_PUB.put_line(p_text => ' l_time_level_id = ' || l_time_level_id );
3095: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_short_name ' || l_Time_Level_short_name );
3096: BIS_UTILITIES_PUB.put_line(p_text => ' l_Time_Level_value_id ' || l_Time_Level_value_id );
3097: */
3098:
3099: END IF;
3100:

Line 3152: BIS_UTILITIES_PUB.put_line(p_text => ' Error IN get_Parameters_For_Actual 0200 : Dim level NUMBER should be 1 to 7 ' );

3148: ELSIF p_dimension_number = 7 THEN
3149: l_actual_rec.Dim7_Level_Value_ID := l_Actual_DimLevelValueId;
3150: l_actual_rec.Dim7_Level_Value_Name := l_Actual_DimLevelValueName;
3151: ELSE
3152: BIS_UTILITIES_PUB.put_line(p_text => ' Error IN get_Parameters_For_Actual 0200 : Dim level NUMBER should be 1 to 7 ' );
3153: END IF;
3154:
3155:
3156: x_PARAMETER_TBL_TYPE := l_PARAMETER_TBL_TYPE;

Line 3167: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN get_Parameters_For_Actual 1000 ' );

3163:
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;

Line 3189: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of parameters table ........... ');

3185: l_print_text VARCHAR2(32000);
3186:
3187: BEGIN
3188:
3189: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of parameters table ........... ');
3190: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Parameter Table for calculating Actual');
3191:
3192: FOR i IN 1..P_PARAMETER_TBL_TYPE.COUNT LOOP
3193:

Line 3190: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Parameter Table for calculating Actual');

3186:
3187: BEGIN
3188:
3189: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of parameters table ........... ');
3190: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Parameter Table for calculating Actual');
3191:
3192: FOR i IN 1..P_PARAMETER_TBL_TYPE.COUNT LOOP
3193:
3194: l_print_text := ' Dimension ' || i ;

Line 3203: BIS_UTILITIES_PUB.put_line(p_text =>l_print_text);

3199: ELSE
3200: l_print_text := l_print_text || ' is not used ' ;
3201: END IF;
3202:
3203: BIS_UTILITIES_PUB.put_line(p_text =>l_print_text);
3204:
3205: END LOOP;
3206:
3207: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of parameters table ........... ');

Line 3207: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of parameters table ........... ');

3203: BIS_UTILITIES_PUB.put_line(p_text =>l_print_text);
3204:
3205: END LOOP;
3206:
3207: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of parameters table ........... ');
3208:
3209: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of time parameter record ........... ');
3210:
3211: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Time Parameter Record for calculating Actual');

Line 3209: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of time parameter record ........... ');

3205: END LOOP;
3206:
3207: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of parameters table ........... ');
3208:
3209: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of time parameter record ........... ');
3210:
3211: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Time Parameter Record for calculating Actual');
3212:
3213: l_print_text := ' Time Dimension Value IS ';

Line 3211: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Time Parameter Record for calculating Actual');

3207: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of parameters table ........... ');
3208:
3209: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Contents of time parameter record ........... ');
3210:
3211: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Time Parameter Record for calculating Actual');
3212:
3213: l_print_text := ' Time Dimension Value IS ';
3214:
3215: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

Line 3215: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

3211: BIS_UTILITIES_PUB.put_line(p_text =>' Contents of Time Parameter Record for calculating Actual');
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

Line 3217: AND (BIS_UTILITIES_PUB.Value_Not_Null

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;
3221: ELSE

Line 3226: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

3222: l_print_text := l_print_text || ' Time parameter value is null. ' ;
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

Line 3228: AND (BIS_UTILITIES_PUB.Value_Not_Null

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;
3232: ELSE

Line 3236: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

3232: ELSE
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

Line 3238: AND (BIS_UTILITIES_PUB.Value_Not_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;
3242: ELSE

Line 3246: BIS_UTILITIES_PUB.put_line(p_text =>l_print_text);

3242: ELSE
3243: l_print_text := l_print_text || ' Time To value is null. ' ;
3244: END IF;
3245:
3246: BIS_UTILITIES_PUB.put_line(p_text =>l_print_text);
3247:
3248: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of time parameter record ........... ');
3249:
3250:

Line 3248: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of time parameter record ........... ');

3244: END IF;
3245:
3246: BIS_UTILITIES_PUB.put_line(p_text =>l_print_text);
3247:
3248: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of time parameter record ........... ');
3249:
3250:
3251: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Report view by level ........... ' ) ;
3252:

Line 3251: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Report view by level ........... ' ) ;

3247:
3248: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Contents of time parameter record ........... ');
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

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 3261: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Report view by level ........... ' ) ;

3257: ELSE
3258: l_print_text := ' View by parameter is null. ' ;
3259: END IF;
3260:
3261: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Report view by level ........... ' ) ;
3262:
3263:
3264: BIS_UTILITIES_PUB.put_line(p_text =>' Region Code : ' || p_actual_region_code);
3265: BIS_UTILITIES_PUB.put_line(p_text =>' p_actual_attribute_code : ' || p_actual_region_item);

Line 3264: BIS_UTILITIES_PUB.put_line(p_text =>' Region Code : ' || p_actual_region_code);

3260:
3261: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Report view by level ........... ' ) ;
3262:
3263:
3264: BIS_UTILITIES_PUB.put_line(p_text =>' Region Code : ' || p_actual_region_code);
3265: BIS_UTILITIES_PUB.put_line(p_text =>' p_actual_attribute_code : ' || p_actual_region_item);
3266: BIS_UTILITIES_PUB.put_line(p_text =>' p_compareto_attribute_code : ' || p_compare_region_item);
3267:
3268:

Line 3265: BIS_UTILITIES_PUB.put_line(p_text =>' p_actual_attribute_code : ' || p_actual_region_item);

3261: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Report view by level ........... ' ) ;
3262:
3263:
3264: BIS_UTILITIES_PUB.put_line(p_text =>' Region Code : ' || p_actual_region_code);
3265: BIS_UTILITIES_PUB.put_line(p_text =>' p_actual_attribute_code : ' || p_actual_region_item);
3266: BIS_UTILITIES_PUB.put_line(p_text =>' p_compareto_attribute_code : ' || p_compare_region_item);
3267:
3268:
3269: EXCEPTION

Line 3266: BIS_UTILITIES_PUB.put_line(p_text =>' p_compareto_attribute_code : ' || p_compare_region_item);

3262:
3263:
3264: BIS_UTILITIES_PUB.put_line(p_text =>' Region Code : ' || p_actual_region_code);
3265: BIS_UTILITIES_PUB.put_line(p_text =>' p_actual_attribute_code : ' || p_actual_region_item);
3266: BIS_UTILITIES_PUB.put_line(p_text =>' p_compareto_attribute_code : ' || p_compare_region_item);
3267:
3268:
3269: EXCEPTION
3270: WHEN OTHERS THEN

Line 3271: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN print_Parameter_Table_Values 1000 ' );

3267:
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;

Line 3306: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Parameters for get report url ........... ' ) ;

3302: ) IS
3303:
3304: BEGIN
3305:
3306: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Parameters for get report url ........... ' ) ;
3307:
3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;
3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;

Line 3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;

3304: BEGIN
3305:
3306: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Parameters for get report url ........... ' ) ;
3307:
3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;
3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;

Line 3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;

3305:
3306: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Parameters for get report url ........... ' ) ;
3307:
3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;
3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;

Line 3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;

3306: BIS_UTILITIES_PUB.put_line(p_text => ' ........... START : Parameters for get report url ........... ' ) ;
3307:
3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;
3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;

Line 3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;

3307:
3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;
3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;

Line 3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;

3308: BIS_UTILITIES_PUB.put_line(p_text => ' Measure id : ' || p_measure_id ) ;
3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;

Line 3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;

3309: BIS_UTILITIES_PUB.put_line(p_text => ' Business plan name: ' || p_bplan_name ) ;
3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;

Line 3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;

3310: BIS_UTILITIES_PUB.put_line(p_text => ' Region code : ' || p_region_code ) ;
3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;

Line 3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;

3311: BIS_UTILITIES_PUB.put_line(p_text => ' Function code : ' || p_function_name ) ;
3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;

Line 3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;

3312: BIS_UTILITIES_PUB.put_line(p_text => ' View by level short name : ' || p_viewby_level_short_name ) ;
3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;

Line 3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;

3313: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level short name : ' || p_Parm1Level_short_name ) ;
3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;

Line 3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;

3314: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 1 Level value name : ' || p_Parm1Value_name ) ;
3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;

Line 3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;

3315: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level short name : ' || p_Parm2Level_short_name ) ;
3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;

Line 3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;

3316: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 2 Level value name : ' || p_Parm2Value_name ) ;
3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;

Line 3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;

3317: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level short name : ' || p_Parm3Level_short_name ) ;
3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;

Line 3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;

3318: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 3 Level value name : ' || p_Parm3Value_name ) ;
3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;

Line 3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;

3319: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level short name : ' || p_Parm4Level_short_name ) ;
3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;

Line 3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;

3320: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 4 Level value name : ' || p_Parm4Value_name ) ;
3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;
3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;

Line 3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;

3321: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level short name : ' || p_Parm5Level_short_name ) ;
3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;
3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;
3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;

Line 3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;

3322: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 5 Level value name : ' || p_Parm5Value_name ) ;
3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;
3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;
3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;
3330:

Line 3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;

3323: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level short name : ' || p_Parm6Level_short_name ) ;
3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;
3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;
3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;
3330:
3331:

Line 3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;

3324: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 6 Level value name : ' || p_Parm6Value_name ) ;
3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;
3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;
3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;
3330:
3331:
3332: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Parameters for get report url ........... ' ) ;

Line 3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;

3325: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level short name : ' || p_Parm7Level_short_name ) ;
3326: BIS_UTILITIES_PUB.put_line(p_text => ' Parameter 7 Level value name : ' || p_Parm7Value_name ) ;
3327: BIS_UTILITIES_PUB.put_line(p_text => ' Time level short name : ' || p_TimeParmLevel_short_name ) ;
3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;
3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;
3330:
3331:
3332: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Parameters for get report url ........... ' ) ;
3333:

Line 3332: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Parameters for get report url ........... ' ) ;

3328: BIS_UTILITIES_PUB.put_line(p_text => ' Time from value name : ' || p_TimeFromParmValue_name ) ;
3329: BIS_UTILITIES_PUB.put_line(p_text => ' Time to value name : ' || p_TimeToParmValue_name ) ;
3330:
3331:
3332: BIS_UTILITIES_PUB.put_line(p_text => ' ........... END : Parameters for get report url ........... ' ) ;
3333:
3334: EXCEPTION
3335:
3336: WHEN OTHERS THEN

Line 3338: BIS_UTILITIES_PUB.put_line(p_text => ' Error in printing report URL: ' || sqlerrm ) ;

3334: EXCEPTION
3335:
3336: WHEN OTHERS THEN
3337:
3338: BIS_UTILITIES_PUB.put_line(p_text => ' Error in printing report URL: ' || sqlerrm ) ;
3339:
3340: END print_report_url_params;
3341:
3342: ----------

Line 3393: BIS_UTILITIES_PUB.put_line(p_text => l_text ) ;

3389: l_text := l_text || ' , Is NOT Total dimension ' ;
3390: END IF;
3391:
3392:
3393: BIS_UTILITIES_PUB.put_line(p_text => l_text ) ;
3394:
3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN print_to_log_dim_level_info ' );

Line 3397: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN print_to_log_dim_level_info ' );

3393: BIS_UTILITIES_PUB.put_line(p_text => l_text ) ;
3394:
3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: BIS_UTILITIES_PUB.put_line(p_text => ' EXCEPTION IN print_to_log_dim_level_info ' );
3398: END print_to_log_dim_level_info;
3399:
3400: --
3401: