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

Line 182: WHEN FND_API.G_EXC_ERROR THEN

178: x_dimension_level_rec.source
179: := BIS_UTILITIES_PUB.G_NULL_CHAR;
180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: RAISE
184: ;
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: RAISE;

Line 185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: RAISE
184: ;
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: RAISE;
187: WHEN OTHERS THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189:

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: ;
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: RAISE;
187: WHEN OTHERS THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189:
190: END SetNULL;
191: PROCEDURE Set_NULL
192: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

Line 381: = FND_API.G_TRUE) then

377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
378:
379: BEGIN
380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)
381: = FND_API.G_TRUE) then
382: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Measure_Short_Name)
383: = FND_API.G_TRUE) then
384:
385: l_Measure_Rec.Measure_Short_Name := p_target_level_rec.Measure_Short_Name;

Line 383: = FND_API.G_TRUE) then

379: BEGIN
380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)
381: = FND_API.G_TRUE) then
382: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Measure_Short_Name)
383: = FND_API.G_TRUE) then
384:
385: l_Measure_Rec.Measure_Short_Name := p_target_level_rec.Measure_Short_Name;
386:
387: l_Measure_Rec_p := l_Measure_Rec;

Line 395: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

391: , x_Measure_Rec => l_Measure_Rec
392: , x_return_status => l_return_status
393: , x_error_Tbl => l_error_Tbl
394: );
395: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
396: l_target_level_rec.Measure_ID := l_Measure_Rec.Measure_ID;
397:
398: end if;
399: end if;

Line 405: = FND_API.G_TRUE) then

401: l_target_level_rec.Measure_ID := p_target_level_rec.Measure_ID;
402: end if;
403:
404: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Org_Level_ID)
405: = FND_API.G_TRUE) then
406: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Org_Level_Short_Name)
407: = FND_API.G_TRUE) then
408: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Org_Level_Short_Name;
409:

Line 407: = FND_API.G_TRUE) then

403:
404: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Org_Level_ID)
405: = FND_API.G_TRUE) then
406: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Org_Level_Short_Name)
407: = FND_API.G_TRUE) then
408: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Org_Level_Short_Name;
409:
410: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
411: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 418: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

414: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
415: , x_return_status => l_return_status
416: , x_error_Tbl => l_error_tbl
417: );
418: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
419: l_target_level_rec.Org_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
420:
421: end if;
422: end if;

Line 431: = FND_API.G_TRUE) then

427: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
428: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
429:
430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)
431: = FND_API.G_TRUE) then
432: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Time_Level_Short_Name)
433: = FND_API.G_TRUE) then
434: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Time_Level_Short_Name;
435:

Line 433: = FND_API.G_TRUE) then

429:
430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)
431: = FND_API.G_TRUE) then
432: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Time_Level_Short_Name)
433: = FND_API.G_TRUE) then
434: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Time_Level_Short_Name;
435:
436: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
437: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 444: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

440: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
441: , x_return_status => l_return_status
442: , x_error_Tbl => l_error_tbl
443: );
444: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
445: l_target_level_rec.Time_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
446:
447: end if;
448: end if;

Line 458: = FND_API.G_TRUE) then

454: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
455:
456:
457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)
458: = FND_API.G_TRUE) then
459: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension1_Level_Short_Name)
460: = FND_API.G_TRUE) then
461: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension1_Level_Short_Name;
462:

Line 460: = FND_API.G_TRUE) then

456:
457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)
458: = FND_API.G_TRUE) then
459: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension1_Level_Short_Name)
460: = FND_API.G_TRUE) then
461: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension1_Level_Short_Name;
462:
463: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
464: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 471: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

467: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
468: , x_return_status => l_return_status
469: , x_error_Tbl => l_error_tbl
470: );
471: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
472: l_target_level_rec.Dimension1_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
473:
474: end if;
475: end if;

Line 485: = FND_API.G_TRUE) then

481: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
482:
483:
484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)
485: = FND_API.G_TRUE) then
486: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension2_Level_Short_Name)
487: = FND_API.G_TRUE) then
488: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension2_Level_Short_Name;
489:

Line 487: = FND_API.G_TRUE) then

483:
484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)
485: = FND_API.G_TRUE) then
486: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension2_Level_Short_Name)
487: = FND_API.G_TRUE) then
488: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension2_Level_Short_Name;
489:
490: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
491: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 498: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

494: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
495: , x_return_status => l_return_status
496: , x_error_Tbl => l_error_tbl
497: );
498: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
499: l_target_level_rec.Dimension2_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
500:
501: end if;
502: end if;

Line 511: = FND_API.G_TRUE) then

507: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
508: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
509:
510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)
511: = FND_API.G_TRUE) then
512: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension3_Level_Short_Name)
513: = FND_API.G_TRUE) then
514: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension3_Level_Short_Name;
515:

Line 513: = FND_API.G_TRUE) then

509:
510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)
511: = FND_API.G_TRUE) then
512: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension3_Level_Short_Name)
513: = FND_API.G_TRUE) then
514: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension3_Level_Short_Name;
515:
516: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
517: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 524: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

520: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
521: , x_return_status => l_return_status
522: , x_error_Tbl => l_error_tbl
523: );
524: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
525: l_target_level_rec.Dimension3_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
526:
527: end if;
528: end if;

Line 538: = FND_API.G_TRUE) then

534: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
535:
536:
537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)
538: = FND_API.G_TRUE) then
539: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension4_Level_Short_Name)
540: = FND_API.G_TRUE) then
541: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension4_Level_Short_Name;
542:

Line 540: = FND_API.G_TRUE) then

536:
537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)
538: = FND_API.G_TRUE) then
539: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension4_Level_Short_Name)
540: = FND_API.G_TRUE) then
541: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension4_Level_Short_Name;
542:
543: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
544: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 551: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

547: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
548: , x_return_status => l_return_status
549: , x_error_Tbl => l_error_tbl
550: );
551: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
552: l_target_level_rec.Dimension4_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
553:
554: end if;
555: end if;

Line 564: = FND_API.G_TRUE) then

560: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
561: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
562:
563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)
564: = FND_API.G_TRUE) then
565: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension5_Level_Short_Name)
566: = FND_API.G_TRUE) then
567: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension5_Level_Short_Name;
568: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 566: = FND_API.G_TRUE) then

562:
563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)
564: = FND_API.G_TRUE) then
565: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension5_Level_Short_Name)
566: = FND_API.G_TRUE) then
567: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension5_Level_Short_Name;
568: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
569: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
570: ( p_api_version => 1.0

Line 576: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

572: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
573: , x_return_status => l_return_status
574: , x_error_Tbl => l_error_tbl
575: );
576: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
577: l_target_level_rec.Dimension5_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
578: end if;
579: end if;
580: else

Line 587: = FND_API.G_TRUE) then

583: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
584: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
585:
586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)
587: = FND_API.G_TRUE) then
588: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension6_Level_Short_Name)
589: = FND_API.G_TRUE) then
590: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension6_Level_Short_Name;
591: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 589: = FND_API.G_TRUE) then

585:
586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)
587: = FND_API.G_TRUE) then
588: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension6_Level_Short_Name)
589: = FND_API.G_TRUE) then
590: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension6_Level_Short_Name;
591: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
592: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
593: ( p_api_version => 1.0

Line 599: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

595: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
596: , x_return_status => l_return_status
597: , x_error_Tbl => l_error_tbl
598: );
599: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
600: l_target_level_rec.Dimension6_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
601: end if;
602: end if;
603: else

Line 610: = FND_API.G_TRUE) then

606: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
607: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
608:
609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)
610: = FND_API.G_TRUE) then
611: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension7_Level_Short_Name)
612: = FND_API.G_TRUE) then
613: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension7_Level_Short_Name;
614: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 612: = FND_API.G_TRUE) then

608:
609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)
610: = FND_API.G_TRUE) then
611: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension7_Level_Short_Name)
612: = FND_API.G_TRUE) then
613: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension7_Level_Short_Name;
614: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
615: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
616: ( p_api_version => 1.0

Line 622: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

618: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
619: , x_return_status => l_return_status
620: , x_error_Tbl => l_error_tbl
621: );
622: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
623: l_target_level_rec.Dimension7_Level_ID := l_Dimension_Level_Rec.Dimension_Level_Id;
624: end if;
625: end if;
626: else

Line 643: , p_commit IN VARCHAR2 := FND_API.G_FALSE

639:
640: -- creates one Indicator Level
641: PROCEDURE Create_Target_Level
642: ( p_api_version IN NUMBER
643: , p_commit IN VARCHAR2 := FND_API.G_FALSE
644: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
645: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
646: , x_return_status OUT NOCOPY VARCHAR2
647: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 644: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

640: -- creates one Indicator Level
641: PROCEDURE Create_Target_Level
642: ( p_api_version IN NUMBER
643: , p_commit IN VARCHAR2 := FND_API.G_FALSE
644: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
645: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
646: , x_return_status OUT NOCOPY VARCHAR2
647: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
648: )

Line 666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

662:
663: --commented RAISE
664: EXCEPTION
665: when others then
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667: --Added last two parameters
668: l_error_tbl := x_error_tbl;
669: BIS_UTILITIES_PVT.Add_Error_Message
670: ( p_error_msg_id => SQLCODE

Line 676: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

672: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
673: , p_error_table => l_error_tbl
674: , x_error_table => x_error_tbl
675: );
676: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
677:
678: END Create_Target_Level;
679: --
680: -- creates one Indicator Level for the given owner

Line 683: , p_commit IN VARCHAR2 := FND_API.G_FALSE

679: --
680: -- creates one Indicator Level for the given owner
681: PROCEDURE Create_Target_Level
682: ( p_api_version IN NUMBER
683: , p_commit IN VARCHAR2 := FND_API.G_FALSE
684: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
685: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
686: , p_owner IN VARCHAR2
687: , x_return_status OUT NOCOPY VARCHAR2

Line 684: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

680: -- creates one Indicator Level for the given owner
681: PROCEDURE Create_Target_Level
682: ( p_api_version IN NUMBER
683: , p_commit IN VARCHAR2 := FND_API.G_FALSE
684: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
685: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
686: , p_owner IN VARCHAR2
687: , x_return_status OUT NOCOPY VARCHAR2
688: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 715: x_return_status := FND_API.G_RET_STS_SUCCESS;

711: l_msg := ' The Summary level ' || nvl( p_Target_Level_Rec.target_level_name , ' ' ) ;
712: l_msg := l_msg || ' could not be created/updated.';
713: */
714:
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717: Set_NULL( p_Target_Level_Rec => p_Target_Level_Rec
718: , x_Target_Level_Rec => l_Target_Level_Rec);
719:

Line 731: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

727: );
728:
729:
730: --
731: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734: --
735: l_target_level_Id := Get_Level_Id_From_Short_Name(p_target_level_rec);

Line 732: RAISE FND_API.G_EXC_ERROR;

728:
729:
730: --
731: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734: --
735: l_target_level_Id := Get_Level_Id_From_Short_Name(p_target_level_rec);
736: if (l_target_level_id is NOT NULL) then

Line 747: RAISE FND_API.G_EXC_ERROR;

743: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
744: , p_error_table => l_error_tbl
745: , x_error_table => x_error_tbl
746: );
747: RAISE FND_API.G_EXC_ERROR;
748: end if;
749:
750: l_target_level_Id := Get_Level_Id_From_dimlevels(p_target_level_rec);
751:

Line 763: RAISE FND_API.G_EXC_ERROR;

759: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
760: , p_error_table => l_error_tbl
761: , x_error_table => x_error_tbl
762: );
763: RAISE FND_API.G_EXC_ERROR;
764: end if;
765:
766: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
767: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

Line 774: = FND_API.G_TRUE)

770: END IF;
771: l_login_id := fnd_global.LOGIN_ID;
772:
773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)
774: = FND_API.G_TRUE)
775: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.system_flag)
776: = FND_API.G_TRUE)
777: THEN
778: l_Target_Level_Rec.system_flag := 'N';

Line 776: = FND_API.G_TRUE)

772:
773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)
774: = FND_API.G_TRUE)
775: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.system_flag)
776: = FND_API.G_TRUE)
777: THEN
778: l_Target_Level_Rec.system_flag := 'N';
779: END IF;
780:

Line 877: if (p_commit = FND_API.G_TRUE) then

873: from bis_TARGET_LEVELS_TL T
874: where T.TARGET_LEVEL_ID = l_id
875: and T.LANGUAGE = L.LANGUAGE_CODE);
876:
877: if (p_commit = FND_API.G_TRUE) then
878: COMMIT;
879: end if;
880:
881: --commented RAISE

Line 885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

881: --commented RAISE
882: EXCEPTION
883: --added this
884: WHEN DUPLICATE_DIMENSION_VALUE THEN
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
886: l_error_tbl := x_error_tbl;
887: BIS_UTILITIES_PVT.Add_Error_Message
888: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
889: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 897: when FND_API.G_EXC_ERROR then

893: , x_error_table => x_error_tbl
894: );
895: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
896:
897: when FND_API.G_EXC_ERROR then
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 898: x_return_status := FND_API.G_RET_STS_ERROR ;

894: );
895: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
896:
897: when FND_API.G_EXC_ERROR then
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 901: when FND_API.G_EXC_UNEXPECTED_ERROR then

897: when FND_API.G_EXC_ERROR then
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
904:
905: when others then

Line 902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
904:
905: when others then
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
904:
905: when others then
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
908:
909: l_error_tbl := x_error_tbl;
910: BIS_UTILITIES_PVT.Add_Error_Message

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927: IS
928: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
929: BEGIN
930:
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932: select count(1) into x_count
933: from bis_target_levels
934: where indicator_id = p_Measure_Rec.Measure_id;
935:

Line 938: when FND_API.G_EXC_ERROR then

934: where indicator_id = p_Measure_Rec.Measure_id;
935:
936: --commented RAISE
937: EXCEPTION
938: when FND_API.G_EXC_ERROR then
939: x_return_status := FND_API.G_RET_STS_ERROR ;
940: --RAISE FND_API.G_EXC_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 939: x_return_status := FND_API.G_RET_STS_ERROR ;

935:
936: --commented RAISE
937: EXCEPTION
938: when FND_API.G_EXC_ERROR then
939: x_return_status := FND_API.G_RET_STS_ERROR ;
940: --RAISE FND_API.G_EXC_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 940: --RAISE FND_API.G_EXC_ERROR;

936: --commented RAISE
937: EXCEPTION
938: when FND_API.G_EXC_ERROR then
939: x_return_status := FND_API.G_RET_STS_ERROR ;
940: --RAISE FND_API.G_EXC_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: when others then

Line 941: when FND_API.G_EXC_UNEXPECTED_ERROR then

937: EXCEPTION
938: when FND_API.G_EXC_ERROR then
939: x_return_status := FND_API.G_RET_STS_ERROR ;
940: --RAISE FND_API.G_EXC_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: when others then
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

938: when FND_API.G_EXC_ERROR then
939: x_return_status := FND_API.G_RET_STS_ERROR ;
940: --RAISE FND_API.G_EXC_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: when others then
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: --added last two params

Line 943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939: x_return_status := FND_API.G_RET_STS_ERROR ;
940: --RAISE FND_API.G_EXC_ERROR;
941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: when others then
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: --added last two params
947: l_error_tbl := x_error_tbl;

Line 945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

941: when FND_API.G_EXC_UNEXPECTED_ERROR then
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: when others then
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: --added last two params
947: l_error_tbl := x_error_tbl;
948: BIS_UTILITIES_PVT.Add_Error_Message
949: ( p_error_msg_id => SQLCODE

Line 955: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

951: , p_error_proc_name => G_PKG_NAME||'.Count_Target_Levels'
952: , p_error_table => l_error_tbl
953: , x_error_table => x_error_tbl
954: );
955: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
956:
957: END Count_Target_Levels;
958: --
959: -- Gets All Indicator Levels

Line 964: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

960: -- If information about the dimensions are not required, set all_info to
961: -- FALSE
962: PROCEDURE Retrieve_Target_Levels
963: ( p_api_version IN NUMBER
964: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
965: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
966: , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type
967: , x_return_status OUT NOCOPY VARCHAR2
968: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1057: x_return_status := FND_API.G_RET_STS_SUCCESS;

1053: from bisfv_target_levels
1054: where measure_id = l_Measure_id;
1055:
1056: BEGIN
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: l_measure_id := p_Measure_Rec.Measure_id;
1060:
1061: if (p_all_info = FND_API.G_FALSE) then

Line 1061: if (p_all_info = FND_API.G_FALSE) then

1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: l_measure_id := p_Measure_Rec.Measure_id;
1060:
1061: if (p_all_info = FND_API.G_FALSE) then
1062: FOR cr in tar_level_bv LOOP
1063: i := i+1;
1064:
1065: l_Target_Level_rec.measure_id := cr.measure_id;

Line 1181: RAISE FND_API.G_EXC_ERROR;

1177: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1178: , p_error_table => l_error_tbl
1179: , x_error_table => x_error_tbl
1180: );
1181: RAISE FND_API.G_EXC_ERROR;
1182: end if;
1183: --commented RAISE
1184: EXCEPTION
1185: when FND_API.G_EXC_ERROR then

Line 1185: when FND_API.G_EXC_ERROR then

1181: RAISE FND_API.G_EXC_ERROR;
1182: end if;
1183: --commented RAISE
1184: EXCEPTION
1185: when FND_API.G_EXC_ERROR then
1186: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1187: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1188: x_return_status := FND_API.G_RET_STS_ERROR ;
1189: -- RAISE FND_API.G_EXC_ERROR;

Line 1188: x_return_status := FND_API.G_RET_STS_ERROR ;

1184: EXCEPTION
1185: when FND_API.G_EXC_ERROR then
1186: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1187: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1188: x_return_status := FND_API.G_RET_STS_ERROR ;
1189: -- RAISE FND_API.G_EXC_ERROR;
1190: when FND_API.G_EXC_UNEXPECTED_ERROR then
1191: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1192: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;

Line 1189: -- RAISE FND_API.G_EXC_ERROR;

1185: when FND_API.G_EXC_ERROR then
1186: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1187: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1188: x_return_status := FND_API.G_RET_STS_ERROR ;
1189: -- RAISE FND_API.G_EXC_ERROR;
1190: when FND_API.G_EXC_UNEXPECTED_ERROR then
1191: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1192: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1190: when FND_API.G_EXC_UNEXPECTED_ERROR then

1186: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1187: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1188: x_return_status := FND_API.G_RET_STS_ERROR ;
1189: -- RAISE FND_API.G_EXC_ERROR;
1190: when FND_API.G_EXC_UNEXPECTED_ERROR then
1191: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1192: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1194: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1189: -- RAISE FND_API.G_EXC_ERROR;
1190: when FND_API.G_EXC_UNEXPECTED_ERROR then
1191: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1192: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1194: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: when others then
1196: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1197: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;

Line 1194: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1190: when FND_API.G_EXC_UNEXPECTED_ERROR then
1191: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1192: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1194: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: when others then
1196: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1197: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1194: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: when others then
1196: IF tar_level_fv%ISOPEN THEN CLOSE tar_level_fv; END IF;
1197: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: --added last two params
1200: l_error_tbl := x_error_tbl;
1201: BIS_UTILITIES_PVT.Add_Error_Message
1202: ( p_error_msg_id => SQLCODE

Line 1208: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1204: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Levels'
1205: , p_error_table => l_error_tbl
1206: , x_error_table => x_error_tbl
1207: );
1208: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209:
1210: END Retrieve_Target_Levels;
1211: --
1212: --

Line 1218: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

1214: -- If information about the dimension are not required, set all_info to FALSE.
1215: PROCEDURE Retrieve_Target_Level
1216: ( p_api_version IN NUMBER
1217: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1218: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1219: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1220: , x_return_status OUT NOCOPY VARCHAR2
1221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1222: )

Line 1235: x_return_status := FND_API.G_RET_STS_SUCCESS;

1231: l_Def_Notify_Resp_ID NUMBER;
1232: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1233: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1234: BEGIN
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: l_Target_Level_rec := x_Target_Level_rec;
1238:
1239: if (p_all_info = FND_API.G_FALSE) then

Line 1239: if (p_all_info = FND_API.G_FALSE) then

1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: l_Target_Level_rec := x_Target_Level_rec;
1238:
1239: if (p_all_info = FND_API.G_FALSE) then
1240: Select measure_id
1241: , TARGET_LEVEL_ID
1242: , TARGET_LEVEL_SHORT_NAME
1243: , TARGET_LEVEL_NAME

Line 1431: x_return_status := FND_API.G_RET_STS_ERROR ;

1427: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1428: , p_error_table => l_error_tbl
1429: , x_error_table => x_error_tbl
1430: );
1431: x_return_status := FND_API.G_RET_STS_ERROR ;
1432: when FND_API.G_EXC_ERROR then
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1432: when FND_API.G_EXC_ERROR then

1428: , p_error_table => l_error_tbl
1429: , x_error_table => x_error_tbl
1430: );
1431: x_return_status := FND_API.G_RET_STS_ERROR ;
1432: when FND_API.G_EXC_ERROR then
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR ;

1429: , x_error_table => x_error_tbl
1430: );
1431: x_return_status := FND_API.G_RET_STS_ERROR ;
1432: when FND_API.G_EXC_ERROR then
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1434: --RAISE FND_API.G_EXC_ERROR;

1430: );
1431: x_return_status := FND_API.G_RET_STS_ERROR ;
1432: when FND_API.G_EXC_ERROR then
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: when others then

Line 1435: when FND_API.G_EXC_UNEXPECTED_ERROR then

1431: x_return_status := FND_API.G_RET_STS_ERROR ;
1432: when FND_API.G_EXC_ERROR then
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: when others then
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1432: when FND_API.G_EXC_ERROR then
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: when others then
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1440: --added last two params

Line 1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: --RAISE FND_API.G_EXC_ERROR;
1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: when others then
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1440: --added last two params
1441: l_error_tbl := x_error_tbl;

Line 1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1435: when FND_API.G_EXC_UNEXPECTED_ERROR then
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1437: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: when others then
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1440: --added last two params
1441: l_error_tbl := x_error_tbl;
1442: BIS_UTILITIES_PVT.Add_Error_Message
1443: ( p_error_msg_id => SQLCODE

Line 1449: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1445: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level'
1446: , p_error_table => l_error_tbl
1447: , x_error_table => x_error_tbl
1448: );
1449: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450:
1451: END Retrieve_Target_Level;
1452: --
1453:

Line 1463: ,p_all_info IN VARCHAR2 := FND_API.G_TRUE

1459: -- As of now, the input table structure into this should start from 1 incremented by 1
1460: PROCEDURE retrieve_mult_targ_levels(
1461: p_api_version IN NUMBER
1462: ,p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1463: ,p_all_info IN VARCHAR2 := FND_API.G_TRUE
1464: ,x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1465: ,x_return_status OUT NOCOPY VARCHAR2
1466: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1467: )

Line 1482: x_return_status := FND_API.G_RET_STS_SUCCESS;

1478: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1479:
1480: BEGIN
1481:
1482: x_return_status := FND_API.G_RET_STS_SUCCESS;
1483:
1484: IF (p_target_level_tbl.COUNT = 0) THEN
1485: RETURN;
1486: END IF;

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1535: IF (c_targ_level_details%ISOPEN) THEN
1536: CLOSE c_targ_level_details;
1537: END IF;
1538:
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1540:
1541: l_error_tbl := x_error_tbl;
1542: BIS_UTILITIES_PVT.Add_Error_Message(
1543: p_error_msg_id => SQLCODE

Line 1623: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE

1619:
1620: Procedure Check_Changed
1621: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1622: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1623: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1624: , x_changed OUT NOCOPY VARCHAR2
1625: )
1626: IS
1627: a BIS_Target_Level_PUB.Target_Level_Rec_Type;

Line 1675: IF p_up_loaded = FND_API.G_TRUE THEN

1671: AND NVL(a.dimension7_Level_Id,-999) = NVL(b.dimension7_Level_Id,-999)
1672: AND NVL(a.Unit_Of_Measure, 'NULL') = NVL(b.Unit_Of_Measure,'NULL')
1673: THEN
1674:
1675: IF p_up_loaded = FND_API.G_TRUE THEN
1676: x_changed := FND_API.G_FALSE;
1677:
1678: ELSE
1679:

Line 1676: x_changed := FND_API.G_FALSE;

1672: AND NVL(a.Unit_Of_Measure, 'NULL') = NVL(b.Unit_Of_Measure,'NULL')
1673: THEN
1674:
1675: IF p_up_loaded = FND_API.G_TRUE THEN
1676: x_changed := FND_API.G_FALSE;
1677:
1678: ELSE
1679:
1680: IF NVL(a.Workflow_Process_Short_Name,'NULL')

Line 1689: x_changed := FND_API.G_FALSE;

1685: AND NVL(a.Computing_Function_ID,-999)
1686: = NVL(b.Computing_Function_ID,-999)
1687: AND NVL(a.Description,'NULL') = NVL(b.Description,'NULL')
1688: THEN
1689: x_changed := FND_API.G_FALSE;
1690: ELSE
1691: x_changed := FND_API.G_TRUE;
1692: END IF;
1693: END IF;

Line 1691: x_changed := FND_API.G_TRUE;

1687: AND NVL(a.Description,'NULL') = NVL(b.Description,'NULL')
1688: THEN
1689: x_changed := FND_API.G_FALSE;
1690: ELSE
1691: x_changed := FND_API.G_TRUE;
1692: END IF;
1693: END IF;
1694:
1695: ELSE

Line 1696: x_changed := FND_API.G_TRUE;

1692: END IF;
1693: END IF;
1694:
1695: ELSE
1696: x_changed := FND_API.G_TRUE;
1697: END IF;
1698:
1699: EXCEPTION
1700: WHEN OTHERS THEN

Line 1707: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE

1703: --
1704: PROCEDURE Update_Target_Level_Rec
1705: ( p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1706: , p_Target_Level_Rec1 IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1707: , p_up_loaded IN VARCHAR2 := FND_API.G_TRUE
1708: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1709: , x_changed OUT NOCOPY VARCHAR2
1710: )
1711: IS

Line 1738: (p_Target_Level_Rec.Target_Level_Short_Name) = FND_API.G_FALSE) THEN

1734:
1735: -- If input record changed, then update record
1736: --
1737: IF (BIS_UTILITIES_PUB.Value_Missing
1738: (p_Target_Level_Rec.Target_Level_Short_Name) = FND_API.G_FALSE) THEN
1739: x_target_level_rec.Target_Level_Short_Name :=
1740: p_target_level_rec.Target_Level_Short_Name;
1741: -- x_changed := FND_API.G_TRUE;
1742: END IF;

Line 1741: -- x_changed := FND_API.G_TRUE;

1737: IF (BIS_UTILITIES_PUB.Value_Missing
1738: (p_Target_Level_Rec.Target_Level_Short_Name) = FND_API.G_FALSE) THEN
1739: x_target_level_rec.Target_Level_Short_Name :=
1740: p_target_level_rec.Target_Level_Short_Name;
1741: -- x_changed := FND_API.G_TRUE;
1742: END IF;
1743:
1744: IF (BIS_UTILITIES_PUB.Value_Missing
1745: (p_Target_Level_Rec.Target_Level_Name) = FND_API.G_FALSE) THEN

Line 1745: (p_Target_Level_Rec.Target_Level_Name) = FND_API.G_FALSE) THEN

1741: -- x_changed := FND_API.G_TRUE;
1742: END IF;
1743:
1744: IF (BIS_UTILITIES_PUB.Value_Missing
1745: (p_Target_Level_Rec.Target_Level_Name) = FND_API.G_FALSE) THEN
1746: x_target_level_rec.Target_Level_Name :=
1747: p_target_level_rec.Target_Level_Name;
1748: -- x_changed := FND_API.G_TRUE;
1749: END IF;

Line 1748: -- x_changed := FND_API.G_TRUE;

1744: IF (BIS_UTILITIES_PUB.Value_Missing
1745: (p_Target_Level_Rec.Target_Level_Name) = FND_API.G_FALSE) THEN
1746: x_target_level_rec.Target_Level_Name :=
1747: p_target_level_rec.Target_Level_Name;
1748: -- x_changed := FND_API.G_TRUE;
1749: END IF;
1750:
1751: IF (BIS_UTILITIES_PUB.Value_Missing
1752: (p_Target_Level_Rec.Description) = FND_API.G_FALSE) THEN

Line 1752: (p_Target_Level_Rec.Description) = FND_API.G_FALSE) THEN

1748: -- x_changed := FND_API.G_TRUE;
1749: END IF;
1750:
1751: IF (BIS_UTILITIES_PUB.Value_Missing
1752: (p_Target_Level_Rec.Description) = FND_API.G_FALSE) THEN
1753: x_target_level_rec.Description := p_target_level_rec.Description;
1754: -- x_changed := FND_API.G_TRUE;
1755: END IF;
1756:

Line 1754: -- x_changed := FND_API.G_TRUE;

1750:
1751: IF (BIS_UTILITIES_PUB.Value_Missing
1752: (p_Target_Level_Rec.Description) = FND_API.G_FALSE) THEN
1753: x_target_level_rec.Description := p_target_level_rec.Description;
1754: -- x_changed := FND_API.G_TRUE;
1755: END IF;
1756:
1757: IF (BIS_UTILITIES_PUB.Value_Missing
1758: (p_Target_Level_Rec.org_Level_ID) = FND_API.G_FALSE) THEN

Line 1758: (p_Target_Level_Rec.org_Level_ID) = FND_API.G_FALSE) THEN

1754: -- x_changed := FND_API.G_TRUE;
1755: END IF;
1756:
1757: IF (BIS_UTILITIES_PUB.Value_Missing
1758: (p_Target_Level_Rec.org_Level_ID) = FND_API.G_FALSE) THEN
1759: x_target_level_rec.org_Level_ID :=
1760: p_target_level_rec.org_Level_ID;
1761: -- x_changed := FND_API.G_TRUE;
1762: END IF;

Line 1761: -- x_changed := FND_API.G_TRUE;

1757: IF (BIS_UTILITIES_PUB.Value_Missing
1758: (p_Target_Level_Rec.org_Level_ID) = FND_API.G_FALSE) THEN
1759: x_target_level_rec.org_Level_ID :=
1760: p_target_level_rec.org_Level_ID;
1761: -- x_changed := FND_API.G_TRUE;
1762: END IF;
1763:
1764: IF (BIS_UTILITIES_PUB.Value_Missing
1765: (p_Target_Level_Rec.time_Level_ID) = FND_API.G_FALSE) THEN

Line 1765: (p_Target_Level_Rec.time_Level_ID) = FND_API.G_FALSE) THEN

1761: -- x_changed := FND_API.G_TRUE;
1762: END IF;
1763:
1764: IF (BIS_UTILITIES_PUB.Value_Missing
1765: (p_Target_Level_Rec.time_Level_ID) = FND_API.G_FALSE) THEN
1766: x_target_level_rec.time_Level_ID :=
1767: p_target_level_rec.time_Level_ID;
1768: -- x_changed := FND_API.G_TRUE;
1769: END IF;

Line 1768: -- x_changed := FND_API.G_TRUE;

1764: IF (BIS_UTILITIES_PUB.Value_Missing
1765: (p_Target_Level_Rec.time_Level_ID) = FND_API.G_FALSE) THEN
1766: x_target_level_rec.time_Level_ID :=
1767: p_target_level_rec.time_Level_ID;
1768: -- x_changed := FND_API.G_TRUE;
1769: END IF;
1770:
1771: IF (BIS_UTILITIES_PUB.Value_Missing
1772: (p_Target_Level_Rec.Dimension1_Level_ID) = FND_API.G_FALSE) THEN

Line 1772: (p_Target_Level_Rec.Dimension1_Level_ID) = FND_API.G_FALSE) THEN

1768: -- x_changed := FND_API.G_TRUE;
1769: END IF;
1770:
1771: IF (BIS_UTILITIES_PUB.Value_Missing
1772: (p_Target_Level_Rec.Dimension1_Level_ID) = FND_API.G_FALSE) THEN
1773: x_target_level_rec.Dimension1_Level_ID :=
1774: p_target_level_rec.Dimension1_Level_ID;
1775: -- x_changed := FND_API.G_TRUE;
1776: END IF;

Line 1775: -- x_changed := FND_API.G_TRUE;

1771: IF (BIS_UTILITIES_PUB.Value_Missing
1772: (p_Target_Level_Rec.Dimension1_Level_ID) = FND_API.G_FALSE) THEN
1773: x_target_level_rec.Dimension1_Level_ID :=
1774: p_target_level_rec.Dimension1_Level_ID;
1775: -- x_changed := FND_API.G_TRUE;
1776: END IF;
1777:
1778: IF (BIS_UTILITIES_PUB.Value_Missing
1779: (p_Target_Level_Rec.Dimension2_Level_ID) = FND_API.G_FALSE) THEN

Line 1779: (p_Target_Level_Rec.Dimension2_Level_ID) = FND_API.G_FALSE) THEN

1775: -- x_changed := FND_API.G_TRUE;
1776: END IF;
1777:
1778: IF (BIS_UTILITIES_PUB.Value_Missing
1779: (p_Target_Level_Rec.Dimension2_Level_ID) = FND_API.G_FALSE) THEN
1780: x_target_level_rec.Dimension2_Level_ID :=
1781: p_target_level_rec.Dimension2_Level_ID;
1782: -- x_changed := FND_API.G_TRUE;
1783: END IF;

Line 1782: -- x_changed := FND_API.G_TRUE;

1778: IF (BIS_UTILITIES_PUB.Value_Missing
1779: (p_Target_Level_Rec.Dimension2_Level_ID) = FND_API.G_FALSE) THEN
1780: x_target_level_rec.Dimension2_Level_ID :=
1781: p_target_level_rec.Dimension2_Level_ID;
1782: -- x_changed := FND_API.G_TRUE;
1783: END IF;
1784:
1785: IF (BIS_UTILITIES_PUB.Value_Missing
1786: (p_Target_Level_Rec.Dimension3_Level_ID) = FND_API.G_FALSE) THEN

Line 1786: (p_Target_Level_Rec.Dimension3_Level_ID) = FND_API.G_FALSE) THEN

1782: -- x_changed := FND_API.G_TRUE;
1783: END IF;
1784:
1785: IF (BIS_UTILITIES_PUB.Value_Missing
1786: (p_Target_Level_Rec.Dimension3_Level_ID) = FND_API.G_FALSE) THEN
1787: x_target_level_rec.Dimension3_Level_ID :=
1788: p_target_level_rec.Dimension3_Level_ID;
1789: -- x_changed := FND_API.G_TRUE;
1790: END IF;

Line 1789: -- x_changed := FND_API.G_TRUE;

1785: IF (BIS_UTILITIES_PUB.Value_Missing
1786: (p_Target_Level_Rec.Dimension3_Level_ID) = FND_API.G_FALSE) THEN
1787: x_target_level_rec.Dimension3_Level_ID :=
1788: p_target_level_rec.Dimension3_Level_ID;
1789: -- x_changed := FND_API.G_TRUE;
1790: END IF;
1791:
1792: IF (BIS_UTILITIES_PUB.Value_Missing
1793: (p_Target_Level_Rec.Dimension4_Level_ID) = FND_API.G_FALSE) THEN

Line 1793: (p_Target_Level_Rec.Dimension4_Level_ID) = FND_API.G_FALSE) THEN

1789: -- x_changed := FND_API.G_TRUE;
1790: END IF;
1791:
1792: IF (BIS_UTILITIES_PUB.Value_Missing
1793: (p_Target_Level_Rec.Dimension4_Level_ID) = FND_API.G_FALSE) THEN
1794: x_target_level_rec.Dimension4_Level_ID :=
1795: p_target_level_rec.Dimension4_Level_ID;
1796: -- x_changed := FND_API.G_TRUE;
1797: END IF;

Line 1796: -- x_changed := FND_API.G_TRUE;

1792: IF (BIS_UTILITIES_PUB.Value_Missing
1793: (p_Target_Level_Rec.Dimension4_Level_ID) = FND_API.G_FALSE) THEN
1794: x_target_level_rec.Dimension4_Level_ID :=
1795: p_target_level_rec.Dimension4_Level_ID;
1796: -- x_changed := FND_API.G_TRUE;
1797: END IF;
1798:
1799: IF (BIS_UTILITIES_PUB.Value_Missing
1800: (p_Target_Level_Rec.Dimension5_Level_ID) = FND_API.G_FALSE) THEN

Line 1800: (p_Target_Level_Rec.Dimension5_Level_ID) = FND_API.G_FALSE) THEN

1796: -- x_changed := FND_API.G_TRUE;
1797: END IF;
1798:
1799: IF (BIS_UTILITIES_PUB.Value_Missing
1800: (p_Target_Level_Rec.Dimension5_Level_ID) = FND_API.G_FALSE) THEN
1801: x_target_level_rec.Dimension5_Level_ID :=
1802: p_target_level_rec.Dimension5_Level_ID;
1803: -- x_changed := FND_API.G_TRUE;
1804: END IF;

Line 1803: -- x_changed := FND_API.G_TRUE;

1799: IF (BIS_UTILITIES_PUB.Value_Missing
1800: (p_Target_Level_Rec.Dimension5_Level_ID) = FND_API.G_FALSE) THEN
1801: x_target_level_rec.Dimension5_Level_ID :=
1802: p_target_level_rec.Dimension5_Level_ID;
1803: -- x_changed := FND_API.G_TRUE;
1804: END IF;
1805:
1806: IF (BIS_UTILITIES_PUB.Value_Missing
1807: (p_Target_Level_Rec.Dimension6_Level_ID) = FND_API.G_FALSE) THEN

Line 1807: (p_Target_Level_Rec.Dimension6_Level_ID) = FND_API.G_FALSE) THEN

1803: -- x_changed := FND_API.G_TRUE;
1804: END IF;
1805:
1806: IF (BIS_UTILITIES_PUB.Value_Missing
1807: (p_Target_Level_Rec.Dimension6_Level_ID) = FND_API.G_FALSE) THEN
1808: x_target_level_rec.Dimension6_Level_ID :=
1809: p_target_level_rec.Dimension6_Level_ID;
1810: -- x_changed := FND_API.G_TRUE;
1811: END IF;

Line 1810: -- x_changed := FND_API.G_TRUE;

1806: IF (BIS_UTILITIES_PUB.Value_Missing
1807: (p_Target_Level_Rec.Dimension6_Level_ID) = FND_API.G_FALSE) THEN
1808: x_target_level_rec.Dimension6_Level_ID :=
1809: p_target_level_rec.Dimension6_Level_ID;
1810: -- x_changed := FND_API.G_TRUE;
1811: END IF;
1812:
1813: IF (BIS_UTILITIES_PUB.Value_Missing
1814: (p_Target_Level_Rec.Dimension7_Level_ID) = FND_API.G_FALSE) THEN

Line 1814: (p_Target_Level_Rec.Dimension7_Level_ID) = FND_API.G_FALSE) THEN

1810: -- x_changed := FND_API.G_TRUE;
1811: END IF;
1812:
1813: IF (BIS_UTILITIES_PUB.Value_Missing
1814: (p_Target_Level_Rec.Dimension7_Level_ID) = FND_API.G_FALSE) THEN
1815: x_target_level_rec.Dimension7_Level_ID :=
1816: p_target_level_rec.Dimension7_Level_ID;
1817: -- x_changed := FND_API.G_TRUE;
1818: END IF;

Line 1817: -- x_changed := FND_API.G_TRUE;

1813: IF (BIS_UTILITIES_PUB.Value_Missing
1814: (p_Target_Level_Rec.Dimension7_Level_ID) = FND_API.G_FALSE) THEN
1815: x_target_level_rec.Dimension7_Level_ID :=
1816: p_target_level_rec.Dimension7_Level_ID;
1817: -- x_changed := FND_API.G_TRUE;
1818: END IF;
1819:
1820: IF (BIS_UTILITIES_PUB.Value_Missing
1821: (p_Target_Level_Rec.Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN

Line 1821: (p_Target_Level_Rec.Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN

1817: -- x_changed := FND_API.G_TRUE;
1818: END IF;
1819:
1820: IF (BIS_UTILITIES_PUB.Value_Missing
1821: (p_Target_Level_Rec.Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN
1822: -- bug# 3735203
1823: IF(p_Target_Level_Rec.Workflow_Process_Short_Name <> '-1') THEN
1824: x_target_level_rec.Workflow_Process_Short_Name :=
1825: p_target_level_rec.Workflow_Process_Short_Name;

Line 1829: -- x_changed := FND_API.G_TRUE;

1825: p_target_level_rec.Workflow_Process_Short_Name;
1826: ELSE
1827: x_target_level_rec.Workflow_Process_Short_Name := NULL;
1828: END IF;
1829: -- x_changed := FND_API.G_TRUE;
1830: END IF;
1831:
1832: IF (BIS_UTILITIES_PUB.Value_Missing
1833: (p_Target_Level_Rec.Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN

Line 1833: (p_Target_Level_Rec.Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN

1829: -- x_changed := FND_API.G_TRUE;
1830: END IF;
1831:
1832: IF (BIS_UTILITIES_PUB.Value_Missing
1833: (p_Target_Level_Rec.Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN
1834: x_target_level_rec.Default_Notify_Resp_ID :=
1835: p_target_level_rec.Default_Notify_Resp_ID;
1836: END IF;
1837:

Line 1839: (p_Target_Level_Rec.Default_Notify_Resp_short_name)=FND_API.G_FALSE) THEN

1835: p_target_level_rec.Default_Notify_Resp_ID;
1836: END IF;
1837:
1838: IF (BIS_UTILITIES_PUB.Value_Missing
1839: (p_Target_Level_Rec.Default_Notify_Resp_short_name)=FND_API.G_FALSE) THEN
1840: x_target_level_rec.Default_Notify_Resp_short_name :=
1841: p_target_level_rec.Default_Notify_Resp_short_name;
1842: END IF;
1843:

Line 1846: (p_Target_Level_Rec.Computing_function_ID) = FND_API.G_FALSE) THEN

1842: END IF;
1843:
1844:
1845: IF (BIS_UTILITIES_PUB.Value_Missing
1846: (p_Target_Level_Rec.Computing_function_ID) = FND_API.G_FALSE) THEN
1847: -- bug# 3735203
1848: IF (p_Target_Level_Rec.Computing_function_ID <> -1) THEN
1849: x_target_level_rec.Computing_function_ID :=
1850: p_target_level_rec.Computing_function_ID;

Line 1854: -- x_changed := FND_API.G_TRUE;

1850: p_target_level_rec.Computing_function_ID;
1851: ELSE
1852: x_target_level_rec.Computing_function_ID := NULL;
1853: END IF;
1854: -- x_changed := FND_API.G_TRUE;
1855: END IF;
1856:
1857: IF (BIS_UTILITIES_PUB.Value_Missing
1858: (p_Target_Level_Rec.Workflow_Item_Type) = FND_API.G_FALSE) THEN

Line 1858: (p_Target_Level_Rec.Workflow_Item_Type) = FND_API.G_FALSE) THEN

1854: -- x_changed := FND_API.G_TRUE;
1855: END IF;
1856:
1857: IF (BIS_UTILITIES_PUB.Value_Missing
1858: (p_Target_Level_Rec.Workflow_Item_Type) = FND_API.G_FALSE) THEN
1859: -- bug# 3735203
1860: IF( p_Target_Level_Rec.Workflow_Item_Type <> '-1') THEN
1861: x_target_level_rec.Workflow_Item_Type :=
1862: p_target_level_rec.Workflow_Item_Type;

Line 1866: -- x_changed := FND_API.G_TRUE;

1862: p_target_level_rec.Workflow_Item_Type;
1863: ELSE
1864: x_target_level_rec.Workflow_Item_Type := NULL;
1865: END IF;
1866: -- x_changed := FND_API.G_TRUE;
1867: END IF;
1868:
1869: IF (BIS_UTILITIES_PUB.Value_Missing
1870: (p_Target_Level_Rec.Report_Function_ID) = FND_API.G_FALSE) THEN

Line 1870: (p_Target_Level_Rec.Report_Function_ID) = FND_API.G_FALSE) THEN

1866: -- x_changed := FND_API.G_TRUE;
1867: END IF;
1868:
1869: IF (BIS_UTILITIES_PUB.Value_Missing
1870: (p_Target_Level_Rec.Report_Function_ID) = FND_API.G_FALSE) THEN
1871: x_target_level_rec.Report_Function_ID :=
1872: p_target_level_rec.Report_Function_ID;
1873: -- x_changed := FND_API.G_TRUE;
1874: END IF;

Line 1873: -- x_changed := FND_API.G_TRUE;

1869: IF (BIS_UTILITIES_PUB.Value_Missing
1870: (p_Target_Level_Rec.Report_Function_ID) = FND_API.G_FALSE) THEN
1871: x_target_level_rec.Report_Function_ID :=
1872: p_target_level_rec.Report_Function_ID;
1873: -- x_changed := FND_API.G_TRUE;
1874: END IF;
1875:
1876: IF (BIS_UTILITIES_PUB.Value_Missing
1877: (p_Target_Level_Rec.Unit_Of_Measure) = FND_API.G_FALSE) THEN

Line 1877: (p_Target_Level_Rec.Unit_Of_Measure) = FND_API.G_FALSE) THEN

1873: -- x_changed := FND_API.G_TRUE;
1874: END IF;
1875:
1876: IF (BIS_UTILITIES_PUB.Value_Missing
1877: (p_Target_Level_Rec.Unit_Of_Measure) = FND_API.G_FALSE) THEN
1878: x_target_level_rec.Unit_Of_Measure :=
1879: p_target_level_rec.Unit_Of_Measure;
1880: -- x_changed := FND_API.G_TRUE;
1881: END IF;

Line 1880: -- x_changed := FND_API.G_TRUE;

1876: IF (BIS_UTILITIES_PUB.Value_Missing
1877: (p_Target_Level_Rec.Unit_Of_Measure) = FND_API.G_FALSE) THEN
1878: x_target_level_rec.Unit_Of_Measure :=
1879: p_target_level_rec.Unit_Of_Measure;
1880: -- x_changed := FND_API.G_TRUE;
1881: END IF;
1882:
1883: IF (BIS_UTILITIES_PUB.Value_Missing
1884: (p_Target_Level_Rec.System_Flag) = FND_API.G_FALSE) THEN

Line 1884: (p_Target_Level_Rec.System_Flag) = FND_API.G_FALSE) THEN

1880: -- x_changed := FND_API.G_TRUE;
1881: END IF;
1882:
1883: IF (BIS_UTILITIES_PUB.Value_Missing
1884: (p_Target_Level_Rec.System_Flag) = FND_API.G_FALSE) THEN
1885: x_target_level_rec.System_Flag :=
1886: p_target_level_rec.System_Flag;
1887: -- x_changed := FND_API.G_TRUE;
1888: END IF;

Line 1887: -- x_changed := FND_API.G_TRUE;

1883: IF (BIS_UTILITIES_PUB.Value_Missing
1884: (p_Target_Level_Rec.System_Flag) = FND_API.G_FALSE) THEN
1885: x_target_level_rec.System_Flag :=
1886: p_target_level_rec.System_Flag;
1887: -- x_changed := FND_API.G_TRUE;
1888: END IF;
1889:
1890: IF (BIS_UTILITIES_PUB.Value_Missing
1891: (p_Target_Level_Rec.Source) = FND_API.G_FALSE) THEN

Line 1891: (p_Target_Level_Rec.Source) = FND_API.G_FALSE) THEN

1887: -- x_changed := FND_API.G_TRUE;
1888: END IF;
1889:
1890: IF (BIS_UTILITIES_PUB.Value_Missing
1891: (p_Target_Level_Rec.Source) = FND_API.G_FALSE) THEN
1892: x_target_level_rec.Source :=
1893: p_target_level_rec.Source;
1894: -- x_changed := FND_API.G_TRUE;
1895: END IF;

Line 1894: -- x_changed := FND_API.G_TRUE;

1890: IF (BIS_UTILITIES_PUB.Value_Missing
1891: (p_Target_Level_Rec.Source) = FND_API.G_FALSE) THEN
1892: x_target_level_rec.Source :=
1893: p_target_level_rec.Source;
1894: -- x_changed := FND_API.G_TRUE;
1895: END IF;
1896:
1897: EXCEPTION
1898: WHEN OTHERS THEN

Line 1905: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1901: --
1902: -- Update_Target_Levels
1903: PROCEDURE Update_Target_Level
1904: ( p_api_version IN NUMBER
1905: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1906: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1907: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1908: , x_return_status OUT NOCOPY VARCHAR2
1909: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1906: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1902: -- Update_Target_Levels
1903: PROCEDURE Update_Target_Level
1904: ( p_api_version IN NUMBER
1905: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1906: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1907: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1908: , x_return_status OUT NOCOPY VARCHAR2
1909: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1910: )

Line 1921: , p_up_loaded => FND_API.G_FALSE

1917: , p_commit => p_commit
1918: , p_validation_level => p_validation_level
1919: , p_Target_Level_Rec => p_Target_Level_Rec
1920: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1921: , p_up_loaded => FND_API.G_FALSE
1922: , x_return_status => x_return_status
1923: , x_error_Tbl => x_error_Tbl
1924: );
1925:

Line 1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1925:
1926: --commented RAISE
1927: EXCEPTION
1928: when others then
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1930: --added last two params
1931: l_error_tbl := x_error_tbl;
1932: BIS_UTILITIES_PVT.Add_Error_Message
1933: ( p_error_msg_id => SQLCODE

Line 1939: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1935: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
1936: , p_error_table => l_error_tbl
1937: , x_error_table => x_error_tbl
1938: );
1939: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1940:
1941: END Update_Target_Level;
1942: --
1943: -- Update_Target_Levels

Line 1946: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1942: --
1943: -- Update_Target_Levels
1944: PROCEDURE Update_Target_Level
1945: ( p_api_version IN NUMBER
1946: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1947: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1948: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1949: , p_owner IN VARCHAR2
1950: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE

Line 1947: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1943: -- Update_Target_Levels
1944: PROCEDURE Update_Target_Level
1945: ( p_api_version IN NUMBER
1946: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1947: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1948: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1949: , p_owner IN VARCHAR2
1950: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE
1951: , x_return_status OUT NOCOPY VARCHAR2

Line 1950: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE

1946: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1947: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1948: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1949: , p_owner IN VARCHAR2
1950: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE
1951: , x_return_status OUT NOCOPY VARCHAR2
1952: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1953: )
1954: IS

Line 1959: l_changed VARCHAR2(10) := FND_API.G_FALSE;

1955: l_user_id NUMBER;
1956: l_login_id NUMBER;
1957: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
1958: l_Target_Level_orig BIS_Target_Level_PUB.Target_Level_Rec_Type;
1959: l_changed VARCHAR2(10) := FND_API.G_FALSE;
1960: l_target_level_id NUMBER;
1961: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;
1962: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1963:

Line 1978: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1974: , x_return_status => x_return_status
1975: , x_error_Tbl => x_error_Tbl
1976: );
1977:
1978: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1979: RAISE FND_API.G_EXC_ERROR;
1980: END IF;
1981:
1982: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level

Line 1979: RAISE FND_API.G_EXC_ERROR;

1975: , x_error_Tbl => x_error_Tbl
1976: );
1977:
1978: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1979: RAISE FND_API.G_EXC_ERROR;
1980: END IF;
1981:
1982: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
1983: ( p_api_version => 1.0

Line 1985: , p_all_info => FND_API.G_FALSE

1981:
1982: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
1983: ( p_api_version => 1.0
1984: , p_Target_Level_Rec => p_Target_Level_Rec
1985: , p_all_info => FND_API.G_FALSE
1986: , x_Target_Level_Rec => l_target_level_orig
1987: , x_return_status => x_return_status
1988: , x_error_Tbl => x_error_tbl
1989: );

Line 1992: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1988: , x_error_Tbl => x_error_tbl
1989: );
1990:
1991: --added this check
1992: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1993: l_error_tbl := x_error_tbl;
1994: BIS_UTILITIES_PVT.Add_Error_Message
1995: ( p_error_msg_name => 'BIS_INVALID_TAR_LEVEL_ID'
1996: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2002: RAISE FND_API.G_EXC_ERROR;

1998: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1999: , p_error_table => l_error_tbl
2000: , x_error_table => x_error_tbl
2001: );
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005:
2006:

Line 2015: IF ( l_changed = FND_API.G_TRUE

2011: , x_target_level_rec => l_target_level_rec
2012: , x_changed => l_changed
2013: );
2014:
2015: IF ( l_changed = FND_API.G_TRUE
2016: AND l_target_level_orig.System_Flag = 'Y')
2017: THEN
2018:
2019: -- ADD error message

Line 2031: RAISE FND_API.G_EXC_ERROR;

2027: , p_error_table => l_error_tbl
2028: , x_error_table => x_error_tbl
2029: );
2030:
2031: RAISE FND_API.G_EXC_ERROR;
2032: end if;
2033:
2034: l_target_level_Id := Get_Level_Id_From_Short_Name(p_target_level_rec);
2035:

Line 2049: RAISE FND_API.G_EXC_ERROR;

2045: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2046: , p_error_table => l_error_tbl
2047: , x_error_table => x_error_tbl
2048: );
2049: RAISE FND_API.G_EXC_ERROR;
2050: end if;
2051: end if;
2052:
2053: BIS_TARGET_PVT.Retrieve_Targets( p_api_version

Line 2055: , FND_API.G_FALSE

2051: end if;
2052:
2053: BIS_TARGET_PVT.Retrieve_Targets( p_api_version
2054: , p_Target_Level_Rec
2055: , FND_API.G_FALSE
2056: , l_Target_Tbl
2057: , x_return_status
2058: , x_error_Tbl
2059: );

Line 2075: RAISE FND_API.G_EXC_ERROR;

2071: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2072: , p_error_table => l_error_tbl
2073: , x_error_table => x_error_tbl
2074: );
2075: RAISE FND_API.G_EXC_ERROR;
2076: end if;
2077: end if;
2078:
2079: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

Line 2090: = FND_API.G_TRUE)

2086: /*
2087: ----------------
2088: --Adding this for the source column
2089: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.source)
2090: = FND_API.G_TRUE)
2091: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.source)
2092: = FND_API.G_TRUE)
2093: THEN
2094: l_Target_Level_Rec.source := FND_PROFILE.value('BIS_SOURCE');

Line 2092: = FND_API.G_TRUE)

2088: --Adding this for the source column
2089: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.source)
2090: = FND_API.G_TRUE)
2091: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.source)
2092: = FND_API.G_TRUE)
2093: THEN
2094: l_Target_Level_Rec.source := FND_PROFILE.value('BIS_SOURCE');
2095: END IF;
2096: ------------------

Line 2139: if (p_commit = FND_API.G_TRUE) then

2135: , x_return_status => x_return_status
2136: , x_error_Tbl => x_error_Tbl
2137: );
2138:
2139: if (p_commit = FND_API.G_TRUE) then
2140: COMMIT;
2141: end if;
2142:
2143: --commented RAISE

Line 2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2143: --commented RAISE
2144: EXCEPTION
2145: --added this
2146: WHEN DUPLICATE_DIMENSION_VALUE THEN
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2148: l_error_tbl := x_error_tbl;
2149: BIS_UTILITIES_PVT.Add_Error_Message
2150: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
2151: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2157: when FND_API.G_EXC_ERROR then

2153: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2154: , p_error_table => l_error_tbl
2155: , x_error_table => x_error_tbl
2156: );
2157: when FND_API.G_EXC_ERROR then
2158: x_return_status := FND_API.G_RET_STS_ERROR ;
2159: --RAISE FND_API.G_EXC_ERROR;
2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2158: x_return_status := FND_API.G_RET_STS_ERROR ;

2154: , p_error_table => l_error_tbl
2155: , x_error_table => x_error_tbl
2156: );
2157: when FND_API.G_EXC_ERROR then
2158: x_return_status := FND_API.G_RET_STS_ERROR ;
2159: --RAISE FND_API.G_EXC_ERROR;
2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2159: --RAISE FND_API.G_EXC_ERROR;

2155: , x_error_table => x_error_tbl
2156: );
2157: when FND_API.G_EXC_ERROR then
2158: x_return_status := FND_API.G_RET_STS_ERROR ;
2159: --RAISE FND_API.G_EXC_ERROR;
2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: when others then

Line 2160: when FND_API.G_EXC_UNEXPECTED_ERROR then

2156: );
2157: when FND_API.G_EXC_ERROR then
2158: x_return_status := FND_API.G_RET_STS_ERROR ;
2159: --RAISE FND_API.G_EXC_ERROR;
2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: when others then
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2157: when FND_API.G_EXC_ERROR then
2158: x_return_status := FND_API.G_RET_STS_ERROR ;
2159: --RAISE FND_API.G_EXC_ERROR;
2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: when others then
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2165: --added last two params

Line 2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2158: x_return_status := FND_API.G_RET_STS_ERROR ;
2159: --RAISE FND_API.G_EXC_ERROR;
2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: when others then
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2165: --added last two params
2166: l_error_tbl := x_error_tbl;

Line 2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2160: when FND_API.G_EXC_UNEXPECTED_ERROR then
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: when others then
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2165: --added last two params
2166: l_error_tbl := x_error_tbl;
2167: BIS_UTILITIES_PVT.Add_Error_Message
2168: ( p_error_msg_id => SQLCODE

Line 2174: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2170: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2171: , p_error_table => l_error_tbl
2172: , x_error_table => x_error_tbl
2173: );
2174: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2175:
2176: END Update_Target_Level;
2177: --
2178: --

Line 2181: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2177: --
2178: --
2179: Procedure Translate_Target_Level
2180: ( p_api_version IN NUMBER
2181: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2182: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2183: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2184: , x_return_status OUT NOCOPY VARCHAR2
2185: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 2182: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2178: --
2179: Procedure Translate_Target_Level
2180: ( p_api_version IN NUMBER
2181: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2182: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2183: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2184: , x_return_status OUT NOCOPY VARCHAR2
2185: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2186: )

Line 2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2200:
2201: --commented RAISE
2202: EXCEPTION
2203: when others then
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2205: --added last two params
2206: l_error_tbl := x_error_tbl;
2207: BIS_UTILITIES_PVT.Add_Error_Message
2208: ( p_error_msg_id => SQLCODE

Line 2214: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2210: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
2211: , p_error_table => l_error_tbl
2212: , x_error_table => x_error_tbl
2213: );
2214: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215:
2216: END Translate_Target_Level;
2217: --
2218: Procedure Translate_Target_Level

Line 2220: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2216: END Translate_Target_Level;
2217: --
2218: Procedure Translate_Target_Level
2219: ( p_api_version IN NUMBER
2220: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2221: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2222: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2223: , p_owner IN VARCHAR2
2224: , x_return_status OUT NOCOPY VARCHAR2

Line 2221: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2217: --
2218: Procedure Translate_Target_Level
2219: ( p_api_version IN NUMBER
2220: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2221: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2222: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2223: , p_owner IN VARCHAR2
2224: , x_return_status OUT NOCOPY VARCHAR2
2225: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 2231: l_changed VARCHAR2(10) := FND_API.G_FALSE;

2227: IS
2228: l_user_id NUMBER;
2229: l_login_id NUMBER;
2230: l_count NUMBER := 0;
2231: l_changed VARCHAR2(10) := FND_API.G_FALSE;
2232: l_Target_Level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2233: l_Target_Level_orig BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2235:

Line 2243: , p_all_info => FND_API.G_FALSE

2239:
2240: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
2241: ( p_api_version => 1.0
2242: , p_Target_Level_Rec => l_Target_Level_Rec
2243: , p_all_info => FND_API.G_FALSE
2244: , x_Target_Level_Rec => l_target_level_orig
2245: , x_return_status => x_return_status
2246: , x_error_Tbl => x_error_tbl
2247: );

Line 2257: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2253: , x_return_status => x_return_status
2254: , x_error_Tbl => x_error_Tbl
2255: );
2256: --
2257: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;
2260: --
2261:

Line 2258: RAISE FND_API.G_EXC_ERROR;

2254: , x_error_Tbl => x_error_Tbl
2255: );
2256: --
2257: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;
2260: --
2261:
2262: /*

Line 2276: RAISE FND_API.G_EXC_ERROR;

2272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2273: , p_error_table => l_error_tbl
2274: , x_error_table => x_error_tbl
2275: );
2276: RAISE FND_API.G_EXC_ERROR;
2277: end if;
2278: end if;
2279:
2280: Update_Target_Level_Rec

Line 2311: if (p_commit = FND_API.G_TRUE) then

2307: , SOURCE_LANG = userenv('LANG')
2308: where TARGET_LEVEL_ID = l_Target_Level_Rec.Target_Level_Id
2309: and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
2310:
2311: if (p_commit = FND_API.G_TRUE) then
2312: COMMIT;
2313: end if;
2314:
2315: --commented RAISE

Line 2318: x_return_status := FND_API.G_RET_STS_ERROR ;

2314:
2315: --commented RAISE
2316: EXCEPTION
2317: WHEN NO_DATA_FOUND THEN
2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: -- RAISE FND_API.G_EXC_ERROR;
2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;

Line 2319: -- RAISE FND_API.G_EXC_ERROR;

2315: --commented RAISE
2316: EXCEPTION
2317: WHEN NO_DATA_FOUND THEN
2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: -- RAISE FND_API.G_EXC_ERROR;
2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2320: when FND_API.G_EXC_ERROR then

2316: EXCEPTION
2317: WHEN NO_DATA_FOUND THEN
2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: -- RAISE FND_API.G_EXC_ERROR;
2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2321: x_return_status := FND_API.G_RET_STS_ERROR ;

2317: WHEN NO_DATA_FOUND THEN
2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: -- RAISE FND_API.G_EXC_ERROR;
2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2322: -- RAISE FND_API.G_EXC_ERROR;

2318: x_return_status := FND_API.G_RET_STS_ERROR ;
2319: -- RAISE FND_API.G_EXC_ERROR;
2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2326: when others then

Line 2323: when FND_API.G_EXC_UNEXPECTED_ERROR then

2319: -- RAISE FND_API.G_EXC_ERROR;
2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2326: when others then
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2320: when FND_API.G_EXC_ERROR then
2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2326: when others then
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2328: --added last two params

Line 2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2321: x_return_status := FND_API.G_RET_STS_ERROR ;
2322: -- RAISE FND_API.G_EXC_ERROR;
2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2326: when others then
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2328: --added last two params
2329: l_error_tbl := x_error_tbl;

Line 2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2323: when FND_API.G_EXC_UNEXPECTED_ERROR then
2324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2325: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2326: when others then
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2328: --added last two params
2329: l_error_tbl := x_error_tbl;
2330: BIS_UTILITIES_PVT.Add_Error_Message
2331: ( p_error_msg_id => SQLCODE

Line 2337: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2333: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
2334: , p_error_table => l_error_tbl
2335: , x_error_table => x_error_tbl
2336: );
2337: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2338:
2339: END Translate_Target_Level;
2340: --
2341: -- deletes one Target_Level

Line 2345: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2341: -- deletes one Target_Level
2342: PROCEDURE Delete_Target_Level
2343: ( p_api_version IN NUMBER
2344: , p_force_delete IN NUMBER := 0--gbhaloti #3148615
2345: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2346: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2347: , x_return_status OUT NOCOPY VARCHAR2
2348: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2349: )

Line 2355: x_return_status := FND_API.G_RET_STS_SUCCESS;

2351: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;
2352: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2353: BEGIN
2354:
2355: x_return_status := FND_API.G_RET_STS_SUCCESS;
2356: BIS_TARGET_PVT.Retrieve_Targets( p_api_version
2357: , p_Target_Level_Rec
2358: , FND_API.G_FALSE
2359: , l_Target_Tbl

Line 2358: , FND_API.G_FALSE

2354:
2355: x_return_status := FND_API.G_RET_STS_SUCCESS;
2356: BIS_TARGET_PVT.Retrieve_Targets( p_api_version
2357: , p_Target_Level_Rec
2358: , FND_API.G_FALSE
2359: , l_Target_Tbl
2360: , x_return_status
2361: , x_error_Tbl
2362: );

Line 2366: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2362: );
2363:
2364: /*
2365: --added this check and message and RAISE
2366: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2367: RAISE FND_API.G_EXC_ERROR;
2368: end if;
2369: */
2370: if (l_Target_Tbl.COUNT > 0 AND p_force_delete = 0) then

Line 2367: RAISE FND_API.G_EXC_ERROR;

2363:
2364: /*
2365: --added this check and message and RAISE
2366: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2367: RAISE FND_API.G_EXC_ERROR;
2368: end if;
2369: */
2370: if (l_Target_Tbl.COUNT > 0 AND p_force_delete = 0) then
2371: --added last two params

Line 2383: RAISE FND_API.G_EXC_ERROR;

2379: , x_error_table => x_error_tbl
2380: );
2381:
2382:
2383: RAISE FND_API.G_EXC_ERROR;
2384: end if;
2385:
2386: delete from bis_TARGET_LEVELS
2387: where TARGET_LEVEL_ID = p_Target_Level_Rec.Target_Level_Id;

Line 2402: if (p_commit = FND_API.G_TRUE) then

2398:
2399: delete from bis_indicator_resps
2400: where target_level_id = p_Target_Level_Rec.Target_Level_Id;
2401:
2402: if (p_commit = FND_API.G_TRUE) then
2403: COMMIT;
2404: end if;
2405:
2406: --commented RAISE

Line 2408: when FND_API.G_EXC_ERROR then

2404: end if;
2405:
2406: --commented RAISE
2407: EXCEPTION
2408: when FND_API.G_EXC_ERROR then
2409: x_return_status := FND_API.G_RET_STS_ERROR ;
2410: -- RAISE FND_API.G_EXC_ERROR;
2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2409: x_return_status := FND_API.G_RET_STS_ERROR ;

2405:
2406: --commented RAISE
2407: EXCEPTION
2408: when FND_API.G_EXC_ERROR then
2409: x_return_status := FND_API.G_RET_STS_ERROR ;
2410: -- RAISE FND_API.G_EXC_ERROR;
2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2410: -- RAISE FND_API.G_EXC_ERROR;

2406: --commented RAISE
2407: EXCEPTION
2408: when FND_API.G_EXC_ERROR then
2409: x_return_status := FND_API.G_RET_STS_ERROR ;
2410: -- RAISE FND_API.G_EXC_ERROR;
2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: when others then

Line 2411: when FND_API.G_EXC_UNEXPECTED_ERROR then

2407: EXCEPTION
2408: when FND_API.G_EXC_ERROR then
2409: x_return_status := FND_API.G_RET_STS_ERROR ;
2410: -- RAISE FND_API.G_EXC_ERROR;
2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: when others then
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2408: when FND_API.G_EXC_ERROR then
2409: x_return_status := FND_API.G_RET_STS_ERROR ;
2410: -- RAISE FND_API.G_EXC_ERROR;
2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: when others then
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2416: --added last two params

Line 2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2409: x_return_status := FND_API.G_RET_STS_ERROR ;
2410: -- RAISE FND_API.G_EXC_ERROR;
2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: when others then
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2416: --added last two params
2417: l_error_tbl := x_error_tbl;

Line 2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2411: when FND_API.G_EXC_UNEXPECTED_ERROR then
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2413: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: when others then
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2416: --added last two params
2417: l_error_tbl := x_error_tbl;
2418: BIS_UTILITIES_PVT.Add_Error_Message
2419: ( p_error_msg_id => SQLCODE

Line 2425: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2421: , p_error_proc_name => G_PKG_NAME||'.Delete_Target_Level'
2422: , p_error_table => l_error_tbl
2423: , x_error_table => x_error_tbl
2424: );
2425: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426:
2427: END Delete_Target_Level;
2428: --
2429: -- Validates measure

Line 2433: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2429: -- Validates measure
2430: --PROCEDURE @Target_Level
2431: PROCEDURE Validate_Target_Level
2432: ( p_api_version IN NUMBER
2433: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2434: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2435: , x_return_status OUT NOCOPY VARCHAR2
2436: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2437: )

Line 2440: l_error VARCHAR2(10) := FND_API.G_FALSE;

2436: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2437: )
2438: IS
2439: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2440: l_error VARCHAR2(10) := FND_API.G_FALSE;
2441: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2442: BEGIN
2443:
2444: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2444: x_return_status := FND_API.G_RET_STS_SUCCESS;

2440: l_error VARCHAR2(10) := FND_API.G_FALSE;
2441: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2442: BEGIN
2443:
2444: x_return_status := FND_API.G_RET_STS_SUCCESS;
2445:
2446: BEGIN
2447: BIS_TARGET_LEVEL_VALIDATE_PVT.Validate_org_Level_Id
2448: ( p_api_version => p_api_version

Line 2455: --when FND_API.G_EXC_ERROR then

2451: , x_return_status => x_return_status
2452: , x_error_Tbl => l_error_Tbl
2453: );
2454: --EXCEPTION
2455: --when FND_API.G_EXC_ERROR then
2456: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2457: l_error := FND_API.G_TRUE;
2458: l_error_Tbl_p := x_error_Tbl;
2459: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2456: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2452: , x_error_Tbl => l_error_Tbl
2453: );
2454: --EXCEPTION
2455: --when FND_API.G_EXC_ERROR then
2456: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2457: l_error := FND_API.G_TRUE;
2458: l_error_Tbl_p := x_error_Tbl;
2459: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2460: , l_error_Tbl

Line 2457: l_error := FND_API.G_TRUE;

2453: );
2454: --EXCEPTION
2455: --when FND_API.G_EXC_ERROR then
2456: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2457: l_error := FND_API.G_TRUE;
2458: l_error_Tbl_p := x_error_Tbl;
2459: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2460: , l_error_Tbl
2461: , x_error_tbl

Line 2463: x_return_status := FND_API.G_RET_STS_ERROR;

2459: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2460: , l_error_Tbl
2461: , x_error_tbl
2462: );
2463: x_return_status := FND_API.G_RET_STS_ERROR;
2464: END IF;
2465: END;
2466:
2467: BEGIN

Line 2476: --when FND_API.G_EXC_ERROR then

2472: , x_return_status => x_return_status
2473: , x_error_Tbl => l_error_Tbl
2474: );
2475: --EXCEPTION
2476: --when FND_API.G_EXC_ERROR then
2477: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2478: l_error := FND_API.G_TRUE;
2479: l_error_Tbl_p := x_error_Tbl;
2480: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2477: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2473: , x_error_Tbl => l_error_Tbl
2474: );
2475: --EXCEPTION
2476: --when FND_API.G_EXC_ERROR then
2477: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2478: l_error := FND_API.G_TRUE;
2479: l_error_Tbl_p := x_error_Tbl;
2480: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2481: , l_error_Tbl

Line 2478: l_error := FND_API.G_TRUE;

2474: );
2475: --EXCEPTION
2476: --when FND_API.G_EXC_ERROR then
2477: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2478: l_error := FND_API.G_TRUE;
2479: l_error_Tbl_p := x_error_Tbl;
2480: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2481: , l_error_Tbl
2482: , x_error_tbl

Line 2484: x_return_status := FND_API.G_RET_STS_ERROR;

2480: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2481: , l_error_Tbl
2482: , x_error_tbl
2483: );
2484: x_return_status := FND_API.G_RET_STS_ERROR;
2485: END IF;
2486: END;
2487:
2488: BEGIN

Line 2497: --when FND_API.G_EXC_ERROR then

2493: , x_return_status => x_return_status
2494: , x_error_Tbl => l_error_Tbl
2495: );
2496: --EXCEPTION
2497: --when FND_API.G_EXC_ERROR then
2498: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2499: l_error := FND_API.G_TRUE;
2500: l_error_Tbl_p := x_error_Tbl;
2501: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2498: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2494: , x_error_Tbl => l_error_Tbl
2495: );
2496: --EXCEPTION
2497: --when FND_API.G_EXC_ERROR then
2498: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2499: l_error := FND_API.G_TRUE;
2500: l_error_Tbl_p := x_error_Tbl;
2501: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2502: , l_error_Tbl

Line 2499: l_error := FND_API.G_TRUE;

2495: );
2496: --EXCEPTION
2497: --when FND_API.G_EXC_ERROR then
2498: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2499: l_error := FND_API.G_TRUE;
2500: l_error_Tbl_p := x_error_Tbl;
2501: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2502: , l_error_Tbl
2503: , x_error_tbl

Line 2505: x_return_status := FND_API.G_RET_STS_ERROR;

2501: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2502: , l_error_Tbl
2503: , x_error_tbl
2504: );
2505: x_return_status := FND_API.G_RET_STS_ERROR;
2506: END IF;
2507: END;
2508:
2509: BEGIN

Line 2518: --when FND_API.G_EXC_ERROR then

2514: , x_return_status => x_return_status
2515: , x_error_Tbl => l_error_Tbl
2516: );
2517: --EXCEPTION
2518: --when FND_API.G_EXC_ERROR then
2519: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2520: l_error := FND_API.G_TRUE;
2521: l_error_Tbl_p := x_error_Tbl;
2522: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2519: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2515: , x_error_Tbl => l_error_Tbl
2516: );
2517: --EXCEPTION
2518: --when FND_API.G_EXC_ERROR then
2519: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2520: l_error := FND_API.G_TRUE;
2521: l_error_Tbl_p := x_error_Tbl;
2522: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2523: , l_error_Tbl

Line 2520: l_error := FND_API.G_TRUE;

2516: );
2517: --EXCEPTION
2518: --when FND_API.G_EXC_ERROR then
2519: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2520: l_error := FND_API.G_TRUE;
2521: l_error_Tbl_p := x_error_Tbl;
2522: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2523: , l_error_Tbl
2524: , x_error_tbl

Line 2526: x_return_status := FND_API.G_RET_STS_ERROR;

2522: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2523: , l_error_Tbl
2524: , x_error_tbl
2525: );
2526: x_return_status := FND_API.G_RET_STS_ERROR;
2527: END IF;
2528: END;
2529:
2530: BEGIN

Line 2539: --when FND_API.G_EXC_ERROR then

2535: , x_return_status => x_return_status
2536: , x_error_Tbl => l_error_Tbl
2537: );
2538: --EXCEPTION
2539: --when FND_API.G_EXC_ERROR then
2540: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2541: l_error := FND_API.G_TRUE;
2542: l_error_Tbl_p := x_error_Tbl;
2543: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2540: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2536: , x_error_Tbl => l_error_Tbl
2537: );
2538: --EXCEPTION
2539: --when FND_API.G_EXC_ERROR then
2540: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2541: l_error := FND_API.G_TRUE;
2542: l_error_Tbl_p := x_error_Tbl;
2543: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2544: , l_error_Tbl

Line 2541: l_error := FND_API.G_TRUE;

2537: );
2538: --EXCEPTION
2539: --when FND_API.G_EXC_ERROR then
2540: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2541: l_error := FND_API.G_TRUE;
2542: l_error_Tbl_p := x_error_Tbl;
2543: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2544: , l_error_Tbl
2545: , x_error_tbl

Line 2547: x_return_status := FND_API.G_RET_STS_ERROR;

2543: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2544: , l_error_Tbl
2545: , x_error_tbl
2546: );
2547: x_return_status := FND_API.G_RET_STS_ERROR;
2548: END IF;
2549: END;
2550:
2551: BEGIN

Line 2560: --when FND_API.G_EXC_ERROR then

2556: , x_return_status => x_return_status
2557: , x_error_Tbl => l_error_Tbl
2558: );
2559: -- EXCEPTION
2560: --when FND_API.G_EXC_ERROR then
2561: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2562: l_error := FND_API.G_TRUE;
2563: l_error_Tbl_p := x_error_Tbl;
2564: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2561: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2557: , x_error_Tbl => l_error_Tbl
2558: );
2559: -- EXCEPTION
2560: --when FND_API.G_EXC_ERROR then
2561: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2562: l_error := FND_API.G_TRUE;
2563: l_error_Tbl_p := x_error_Tbl;
2564: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2565: , l_error_Tbl

Line 2562: l_error := FND_API.G_TRUE;

2558: );
2559: -- EXCEPTION
2560: --when FND_API.G_EXC_ERROR then
2561: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2562: l_error := FND_API.G_TRUE;
2563: l_error_Tbl_p := x_error_Tbl;
2564: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2565: , l_error_Tbl
2566: , x_error_tbl

Line 2568: x_return_status := FND_API.G_RET_STS_ERROR;

2564: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2565: , l_error_Tbl
2566: , x_error_tbl
2567: );
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: END IF;
2570: END;
2571:
2572: BEGIN

Line 2581: --when FND_API.G_EXC_ERROR then

2577: , x_return_status => x_return_status
2578: , x_error_Tbl => l_error_Tbl
2579: );
2580: --EXCEPTION
2581: --when FND_API.G_EXC_ERROR then
2582: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2583: l_error := FND_API.G_TRUE;
2584: l_error_Tbl_p := x_error_Tbl;
2585: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2582: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2578: , x_error_Tbl => l_error_Tbl
2579: );
2580: --EXCEPTION
2581: --when FND_API.G_EXC_ERROR then
2582: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2583: l_error := FND_API.G_TRUE;
2584: l_error_Tbl_p := x_error_Tbl;
2585: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2586: , l_error_Tbl

Line 2583: l_error := FND_API.G_TRUE;

2579: );
2580: --EXCEPTION
2581: --when FND_API.G_EXC_ERROR then
2582: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2583: l_error := FND_API.G_TRUE;
2584: l_error_Tbl_p := x_error_Tbl;
2585: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2586: , l_error_Tbl
2587: , x_error_tbl

Line 2589: x_return_status := FND_API.G_RET_STS_ERROR;

2585: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2586: , l_error_Tbl
2587: , x_error_tbl
2588: );
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: END IF;
2591: END;
2592:
2593: BEGIN

Line 2602: -- when FND_API.G_EXC_ERROR then

2598: , x_return_status => x_return_status
2599: , x_error_Tbl => l_error_Tbl
2600: );
2601: -- EXCEPTION
2602: -- when FND_API.G_EXC_ERROR then
2603: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2604: l_error := FND_API.G_TRUE;
2605: l_error_Tbl_p := x_error_Tbl;
2606: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2603: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2599: , x_error_Tbl => l_error_Tbl
2600: );
2601: -- EXCEPTION
2602: -- when FND_API.G_EXC_ERROR then
2603: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2604: l_error := FND_API.G_TRUE;
2605: l_error_Tbl_p := x_error_Tbl;
2606: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2607: , l_error_Tbl

Line 2604: l_error := FND_API.G_TRUE;

2600: );
2601: -- EXCEPTION
2602: -- when FND_API.G_EXC_ERROR then
2603: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2604: l_error := FND_API.G_TRUE;
2605: l_error_Tbl_p := x_error_Tbl;
2606: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2607: , l_error_Tbl
2608: , x_error_tbl

Line 2610: x_return_status := FND_API.G_RET_STS_ERROR;

2606: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2607: , l_error_Tbl
2608: , x_error_tbl
2609: );
2610: x_return_status := FND_API.G_RET_STS_ERROR;
2611: END IF;
2612: END;
2613:
2614: BEGIN

Line 2623: -- when FND_API.G_EXC_ERROR then

2619: , x_return_status => x_return_status
2620: , x_error_Tbl => l_error_Tbl
2621: );
2622: -- EXCEPTION
2623: -- when FND_API.G_EXC_ERROR then
2624: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2625: l_error := FND_API.G_TRUE;
2626: l_error_Tbl_p := x_error_Tbl;
2627: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2624: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2620: , x_error_Tbl => l_error_Tbl
2621: );
2622: -- EXCEPTION
2623: -- when FND_API.G_EXC_ERROR then
2624: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2625: l_error := FND_API.G_TRUE;
2626: l_error_Tbl_p := x_error_Tbl;
2627: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2628: , l_error_Tbl

Line 2625: l_error := FND_API.G_TRUE;

2621: );
2622: -- EXCEPTION
2623: -- when FND_API.G_EXC_ERROR then
2624: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2625: l_error := FND_API.G_TRUE;
2626: l_error_Tbl_p := x_error_Tbl;
2627: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2628: , l_error_Tbl
2629: , x_error_tbl

Line 2631: x_return_status := FND_API.G_RET_STS_ERROR;

2627: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2628: , l_error_Tbl
2629: , x_error_tbl
2630: );
2631: x_return_status := FND_API.G_RET_STS_ERROR;
2632: END IF;
2633: END;
2634:
2635: BEGIN

Line 2637: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Workflow_Process_Short_Name) =FND_API.G_TRUE ) THEN

2633: END;
2634:
2635: BEGIN
2636: -- bug# 3735203
2637: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Workflow_Process_Short_Name) =FND_API.G_TRUE ) THEN
2638: IF(p_Target_Level_Rec.Workflow_Process_Short_Name <> '-1') THEN
2639: BIS_TARGET_LEVEL_VALIDATE_PVT.Validate_WF_Process_Short_Name
2640: ( p_api_version => p_api_version
2641: , p_validation_level => p_validation_level

Line 2650: -- when FND_API.G_EXC_ERROR then

2646: END IF;
2647: END IF;
2648:
2649: -- EXCEPTION
2650: -- when FND_API.G_EXC_ERROR then
2651: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2652: l_error := FND_API.G_TRUE;
2653: l_error_Tbl_p := x_error_Tbl;
2654: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2651: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2647: END IF;
2648:
2649: -- EXCEPTION
2650: -- when FND_API.G_EXC_ERROR then
2651: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2652: l_error := FND_API.G_TRUE;
2653: l_error_Tbl_p := x_error_Tbl;
2654: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2655: , l_error_Tbl

Line 2652: l_error := FND_API.G_TRUE;

2648:
2649: -- EXCEPTION
2650: -- when FND_API.G_EXC_ERROR then
2651: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2652: l_error := FND_API.G_TRUE;
2653: l_error_Tbl_p := x_error_Tbl;
2654: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2655: , l_error_Tbl
2656: , x_error_tbl

Line 2658: x_return_status := FND_API.G_RET_STS_ERROR;

2654: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2655: , l_error_Tbl
2656: , x_error_tbl
2657: );
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: END IF;
2660: END;
2661:
2662: BEGIN

Line 2672: -- when FND_API.G_EXC_ERROR then

2668: , x_error_Tbl => l_error_Tbl
2669: );
2670:
2671: -- EXCEPTION
2672: -- when FND_API.G_EXC_ERROR then
2673: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2674: l_error := FND_API.G_TRUE;
2675: l_error_Tbl_p := x_error_Tbl;
2676: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2673: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2669: );
2670:
2671: -- EXCEPTION
2672: -- when FND_API.G_EXC_ERROR then
2673: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2674: l_error := FND_API.G_TRUE;
2675: l_error_Tbl_p := x_error_Tbl;
2676: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2677: , l_error_Tbl

Line 2674: l_error := FND_API.G_TRUE;

2670:
2671: -- EXCEPTION
2672: -- when FND_API.G_EXC_ERROR then
2673: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2674: l_error := FND_API.G_TRUE;
2675: l_error_Tbl_p := x_error_Tbl;
2676: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2677: , l_error_Tbl
2678: , x_error_tbl

Line 2680: x_return_status := FND_API.G_RET_STS_ERROR;

2676: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2677: , l_error_Tbl
2678: , x_error_tbl
2679: );
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: END IF;
2682: END;
2683:
2684: BEGIN

Line 2686: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Computing_function_ID) =FND_API.G_TRUE ) THEN

2682: END;
2683:
2684: BEGIN
2685: -- bug# 3735203
2686: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Computing_function_ID) =FND_API.G_TRUE ) THEN
2687: IF(p_Target_Level_Rec.Computing_function_ID <> -1) THEN
2688: BIS_TARGET_LEVEL_VALIDATE_PVT.Validate_Df_computed_target_Id
2689: ( p_api_version => p_api_version
2690: , p_validation_level => p_validation_level

Line 2699: -- when FND_API.G_EXC_ERROR then

2695: END IF;
2696: END IF;
2697:
2698: -- EXCEPTION
2699: -- when FND_API.G_EXC_ERROR then
2700: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2701: l_error := FND_API.G_TRUE;
2702: l_error_Tbl_p := x_error_Tbl;
2703: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

Line 2700: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2696: END IF;
2697:
2698: -- EXCEPTION
2699: -- when FND_API.G_EXC_ERROR then
2700: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2701: l_error := FND_API.G_TRUE;
2702: l_error_Tbl_p := x_error_Tbl;
2703: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2704: , l_error_Tbl

Line 2701: l_error := FND_API.G_TRUE;

2697:
2698: -- EXCEPTION
2699: -- when FND_API.G_EXC_ERROR then
2700: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2701: l_error := FND_API.G_TRUE;
2702: l_error_Tbl_p := x_error_Tbl;
2703: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2704: , l_error_Tbl
2705: , x_error_tbl

Line 2707: x_return_status := FND_API.G_RET_STS_ERROR;

2703: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2704: , l_error_Tbl
2705: , x_error_tbl
2706: );
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: END IF;
2709: END;
2710:
2711: if (l_error = FND_API.G_TRUE) then

Line 2711: if (l_error = FND_API.G_TRUE) then

2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: END IF;
2709: END;
2710:
2711: if (l_error = FND_API.G_TRUE) then
2712: RAISE FND_API.G_EXC_ERROR;
2713: end if;
2714:
2715: --added this

Line 2712: RAISE FND_API.G_EXC_ERROR;

2708: END IF;
2709: END;
2710:
2711: if (l_error = FND_API.G_TRUE) then
2712: RAISE FND_API.G_EXC_ERROR;
2713: end if;
2714:
2715: --added this
2716: -- x_error_tbl := l_error_tbl;

Line 2719: when FND_API.G_EXC_ERROR then

2715: --added this
2716: -- x_error_tbl := l_error_tbl;
2717: --commented RAISE
2718: EXCEPTION
2719: when FND_API.G_EXC_ERROR then
2720: x_return_status := FND_API.G_RET_STS_ERROR ;
2721: -- RAISE FND_API.G_EXC_ERROR;
2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2720: x_return_status := FND_API.G_RET_STS_ERROR ;

2716: -- x_error_tbl := l_error_tbl;
2717: --commented RAISE
2718: EXCEPTION
2719: when FND_API.G_EXC_ERROR then
2720: x_return_status := FND_API.G_RET_STS_ERROR ;
2721: -- RAISE FND_API.G_EXC_ERROR;
2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2721: -- RAISE FND_API.G_EXC_ERROR;

2717: --commented RAISE
2718: EXCEPTION
2719: when FND_API.G_EXC_ERROR then
2720: x_return_status := FND_API.G_RET_STS_ERROR ;
2721: -- RAISE FND_API.G_EXC_ERROR;
2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: when others then

Line 2722: when FND_API.G_EXC_UNEXPECTED_ERROR then

2718: EXCEPTION
2719: when FND_API.G_EXC_ERROR then
2720: x_return_status := FND_API.G_RET_STS_ERROR ;
2721: -- RAISE FND_API.G_EXC_ERROR;
2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: when others then
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2719: when FND_API.G_EXC_ERROR then
2720: x_return_status := FND_API.G_RET_STS_ERROR ;
2721: -- RAISE FND_API.G_EXC_ERROR;
2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: when others then
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2727: --added last two params

Line 2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2720: x_return_status := FND_API.G_RET_STS_ERROR ;
2721: -- RAISE FND_API.G_EXC_ERROR;
2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: when others then
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2727: --added last two params
2728: l_error_tbl := x_error_tbl;

Line 2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2722: when FND_API.G_EXC_UNEXPECTED_ERROR then
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2724: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2725: when others then
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2727: --added last two params
2728: l_error_tbl := x_error_tbl;
2729: BIS_UTILITIES_PVT.Add_Error_Message
2730: ( p_error_msg_id => SQLCODE

Line 2736: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2732: , p_error_proc_name => G_PKG_NAME||'.Validate_Target_Level'
2733: , p_error_table => l_error_tbl
2734: , x_error_table => x_error_tbl
2735: );
2736: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737:
2738: END Validate_Target_Level;
2739: --
2740: PROCEDURE Check_Value_id_Conversion

Line 2753: x_return_status := FND_API.G_RET_STS_SUCCESS;

2749: l_convert VARCHAR2(10);
2750:
2751: BEGIN
2752:
2753: x_return_status := FND_API.G_RET_STS_SUCCESS;
2754:
2755: l_convert := BIS_UTILITIES_PVT.Convert_to_ID( p_dim_level_id
2756: , p_Dim_level_short_name
2757: , p_Dime_Level_NAME

Line 2760: if (l_convert = FND_API.G_TRUE) then

2756: , p_Dim_level_short_name
2757: , p_Dime_Level_NAME
2758: );
2759:
2760: if (l_convert = FND_API.G_TRUE) then
2761: BEGIN
2762: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
2763: ( 1.0
2764: , p_Dim_level_short_name

Line 2771: WHEN FND_API.G_EXC_ERROR then

2767: , x_return_status
2768: , x_error_Tbl
2769: );
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR then
2772: NULL;
2773: END;
2774: else
2775: x_dim_level_id := p_dim_level_id;

Line 2793: x_return_status := FND_API.G_RET_STS_SUCCESS;

2789: l_convert VARCHAR2(10);
2790: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2791: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2792: BEGIN
2793: x_return_status := FND_API.G_RET_STS_SUCCESS;
2794: x_Target_Level_Rec := p_Target_Level_Rec;
2795:
2796: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
2797: ( x_Target_Level_Rec.Target_Level_id

Line 2802: if (l_convert = FND_API.G_TRUE) then

2798: , x_Target_Level_Rec.Target_Level_Short_Name
2799: , x_Target_Level_Rec.Target_Level_Name
2800: );
2801:
2802: if (l_convert = FND_API.G_TRUE) then
2803: BEGIN
2804: BIS_Target_Level_PVT.Value_ID_Conversion
2805: ( p_api_version
2806: , x_Target_Level_Rec.Target_Level_Short_Name

Line 2813: WHEN FND_API.G_EXC_ERROR then

2809: , x_return_status
2810: , x_error_Tbl
2811: );
2812: EXCEPTION
2813: WHEN FND_API.G_EXC_ERROR then
2814: NULL;
2815: END;
2816: end if;
2817:

Line 2823: if (l_convert = FND_API.G_TRUE) then

2819: ( x_Target_Level_Rec.Measure_id
2820: , x_Target_Level_Rec.Measure_Short_Name
2821: , x_Target_Level_Rec.Measure_Name
2822: );
2823: if (l_convert = FND_API.G_TRUE) then
2824: BEGIN
2825: BIS_MEASURE_PVT.Value_ID_Conversion
2826: ( p_api_version
2827: , x_Target_Level_Rec.Measure_Short_Name

Line 2834: WHEN FND_API.G_EXC_ERROR then

2830: , x_return_status
2831: , x_error_Tbl
2832: );
2833: EXCEPTION
2834: WHEN FND_API.G_EXC_ERROR then
2835: NULL;
2836: END;
2837: end if;
2838:

Line 2935: if (l_convert = FND_API.G_TRUE) then

2931: , x_Target_Level_Rec.Default_Notify_Resp_Short_Name
2932: , x_Target_Level_Rec.Default_Notify_Resp_Name
2933: );
2934:
2935: if (l_convert = FND_API.G_TRUE) then
2936: BEGIN
2937: BIS_RESPONSIBILITY_PVT.DFR_Value_ID_Conversion
2938: ( p_api_version
2939: , x_Target_Level_Rec.Default_Notify_Resp_Short_Name

Line 2946: WHEN FND_API.G_EXC_ERROR then

2942: , x_return_status
2943: , x_error_Tbl
2944: );
2945: EXCEPTION
2946: WHEN FND_API.G_EXC_ERROR then
2947: NULL;
2948: END;
2949: end if;
2950:

Line 2957: if (l_convert = FND_API.G_TRUE) then

2953: , x_Target_Level_Rec.Computing_Function_Name
2954: , x_Target_Level_Rec.Computing_user_Function_Name
2955: );
2956:
2957: if (l_convert = FND_API.G_TRUE) then
2958:
2959: -- if (BIS_UTILITIES_PUB.Value_Missing
2960: -- (x_Target_Level_Rec.Computing_Function_ID) = FND_API.G_TRUE) then
2961: BEGIN

Line 2960: -- (x_Target_Level_Rec.Computing_Function_ID) = FND_API.G_TRUE) then

2956:
2957: if (l_convert = FND_API.G_TRUE) then
2958:
2959: -- if (BIS_UTILITIES_PUB.Value_Missing
2960: -- (x_Target_Level_Rec.Computing_Function_ID) = FND_API.G_TRUE) then
2961: BEGIN
2962: BIS_COMPUTED_TARGET_PVT.Value_ID_Conversion
2963: ( p_api_version => p_api_version
2964: , p_Computed_Target_Short_Name

Line 2975: WHEN FND_API.G_EXC_ERROR then

2971: , x_error_Tbl => x_error_Tbl
2972: );
2973:
2974: EXCEPTION
2975: WHEN FND_API.G_EXC_ERROR then
2976: NULL;
2977: END;
2978: end if;
2979:

Line 2986: when FND_API.G_EXC_ERROR then

2982: -- NOT done
2983:
2984: --commented RAISE
2985: EXCEPTION
2986: when FND_API.G_EXC_ERROR then
2987: x_return_status := FND_API.G_RET_STS_ERROR ;
2988: -- RAISE FND_API.G_EXC_ERROR;
2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2987: x_return_status := FND_API.G_RET_STS_ERROR ;

2983:
2984: --commented RAISE
2985: EXCEPTION
2986: when FND_API.G_EXC_ERROR then
2987: x_return_status := FND_API.G_RET_STS_ERROR ;
2988: -- RAISE FND_API.G_EXC_ERROR;
2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2988: -- RAISE FND_API.G_EXC_ERROR;

2984: --commented RAISE
2985: EXCEPTION
2986: when FND_API.G_EXC_ERROR then
2987: x_return_status := FND_API.G_RET_STS_ERROR ;
2988: -- RAISE FND_API.G_EXC_ERROR;
2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: when others then

Line 2989: when FND_API.G_EXC_UNEXPECTED_ERROR then

2985: EXCEPTION
2986: when FND_API.G_EXC_ERROR then
2987: x_return_status := FND_API.G_RET_STS_ERROR ;
2988: -- RAISE FND_API.G_EXC_ERROR;
2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: when others then
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2986: when FND_API.G_EXC_ERROR then
2987: x_return_status := FND_API.G_RET_STS_ERROR ;
2988: -- RAISE FND_API.G_EXC_ERROR;
2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: when others then
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2994: --added last two params

Line 2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2987: x_return_status := FND_API.G_RET_STS_ERROR ;
2988: -- RAISE FND_API.G_EXC_ERROR;
2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: when others then
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2994: --added last two params
2995: l_error_tbl := x_error_tbl;

Line 2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2989: when FND_API.G_EXC_UNEXPECTED_ERROR then
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2991: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2992: when others then
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2994: --added last two params
2995: l_error_tbl := x_error_tbl;
2996: BIS_UTILITIES_PVT.Add_Error_Message
2997: ( p_error_msg_id => SQLCODE

Line 3003: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2999: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3000: , p_error_table => l_error_tbl
3001: , x_error_table => x_error_tbl
3002: );
3003: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004:
3005: END Value_ID_Conversion;
3006: --
3007: PROCEDURE Value_ID_Conversion

Line 3019: x_return_status := FND_API.G_RET_STS_SUCCESS;

3015: IS
3016: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3017: BEGIN
3018:
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;
3020:
3021: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Short_Name)
3022: = FND_API.G_TRUE) then
3023: SELECT Target_Level_id into x_Target_Level_ID

Line 3022: = FND_API.G_TRUE) then

3018:
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;
3020:
3021: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Short_Name)
3022: = FND_API.G_TRUE) then
3023: SELECT Target_Level_id into x_Target_Level_ID
3024: FROM bisbv_Target_Levels
3025: WHERE target_level_short_name = p_Target_Level_Short_Name;
3026: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Name)

Line 3027: = FND_API.G_TRUE) then

3023: SELECT Target_Level_id into x_Target_Level_ID
3024: FROM bisbv_Target_Levels
3025: WHERE target_level_short_name = p_Target_Level_Short_Name;
3026: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Name)
3027: = FND_API.G_TRUE) then
3028: SELECT Target_Level_id into x_Target_Level_ID
3029: FROM bisbv_Target_Levels
3030: WHERE target_level_name = p_Target_Level_Name;
3031: else

Line 3044: RAISE FND_API.G_EXC_ERROR;

3040: , p_error_table => l_error_tbl
3041: , x_error_table => x_error_tbl
3042: );
3043:
3044: RAISE FND_API.G_EXC_ERROR;
3045: end if;
3046:
3047: --commented RAISE
3048: EXCEPTION

Line 3050: x_return_status := FND_API.G_RET_STS_ERROR ;

3046:
3047: --commented RAISE
3048: EXCEPTION
3049: WHEN NO_DATA_FOUND THEN
3050: x_return_status := FND_API.G_RET_STS_ERROR ;
3051: -- RAISE FND_API.G_EXC_ERROR;
3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;

Line 3051: -- RAISE FND_API.G_EXC_ERROR;

3047: --commented RAISE
3048: EXCEPTION
3049: WHEN NO_DATA_FOUND THEN
3050: x_return_status := FND_API.G_RET_STS_ERROR ;
3051: -- RAISE FND_API.G_EXC_ERROR;
3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3052: when FND_API.G_EXC_ERROR then

3048: EXCEPTION
3049: WHEN NO_DATA_FOUND THEN
3050: x_return_status := FND_API.G_RET_STS_ERROR ;
3051: -- RAISE FND_API.G_EXC_ERROR;
3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3053: x_return_status := FND_API.G_RET_STS_ERROR ;

3049: WHEN NO_DATA_FOUND THEN
3050: x_return_status := FND_API.G_RET_STS_ERROR ;
3051: -- RAISE FND_API.G_EXC_ERROR;
3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3054: -- RAISE FND_API.G_EXC_ERROR;

3050: x_return_status := FND_API.G_RET_STS_ERROR ;
3051: -- RAISE FND_API.G_EXC_ERROR;
3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: when others then

Line 3055: when FND_API.G_EXC_UNEXPECTED_ERROR then

3051: -- RAISE FND_API.G_EXC_ERROR;
3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: when others then
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3052: when FND_API.G_EXC_ERROR then
3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: when others then
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3060: --added last two params

Line 3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3053: x_return_status := FND_API.G_RET_STS_ERROR ;
3054: -- RAISE FND_API.G_EXC_ERROR;
3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: when others then
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3060: --added last two params
3061: l_error_tbl := x_error_tbl;

Line 3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3055: when FND_API.G_EXC_UNEXPECTED_ERROR then
3056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3057: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3058: when others then
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3060: --added last two params
3061: l_error_tbl := x_error_tbl;
3062: BIS_UTILITIES_PVT.Add_Error_Message
3063: ( p_error_msg_id => SQLCODE

Line 3069: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3065: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3066: , p_error_table => l_error_tbl
3067: , x_error_table => x_error_tbl
3068: );
3069: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3070:
3071: END Value_ID_Conversion;
3072: --
3073: Procedure Retrieve_User_Target_Levels

Line 3076: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

3072: --
3073: Procedure Retrieve_User_Target_Levels
3074: ( p_api_version IN NUMBER
3075: , p_user_id IN NUMBER
3076: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
3077: , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type
3078: , x_return_status OUT NOCOPY VARCHAR2
3079: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3080: )

Line 3133: RAISE FND_API.G_EXC_ERROR;

3129: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3130: , p_error_table => l_error_tbl
3131: , x_error_table => x_error_tbl
3132: );
3133: RAISE FND_API.G_EXC_ERROR;
3134: end if;
3135:
3136: --commented RAISE
3137: EXCEPTION

Line 3138: when FND_API.G_EXC_ERROR then

3134: end if;
3135:
3136: --commented RAISE
3137: EXCEPTION
3138: when FND_API.G_EXC_ERROR then
3139: if ind_res%isopen then close ind_res; end if;
3140: x_return_status := FND_API.G_RET_STS_ERROR ;
3141: -- RAISE FND_API.G_EXC_ERROR;
3142: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3140: x_return_status := FND_API.G_RET_STS_ERROR ;

3136: --commented RAISE
3137: EXCEPTION
3138: when FND_API.G_EXC_ERROR then
3139: if ind_res%isopen then close ind_res; end if;
3140: x_return_status := FND_API.G_RET_STS_ERROR ;
3141: -- RAISE FND_API.G_EXC_ERROR;
3142: when FND_API.G_EXC_UNEXPECTED_ERROR then
3143: if ind_res%isopen then close ind_res; end if;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3141: -- RAISE FND_API.G_EXC_ERROR;

3137: EXCEPTION
3138: when FND_API.G_EXC_ERROR then
3139: if ind_res%isopen then close ind_res; end if;
3140: x_return_status := FND_API.G_RET_STS_ERROR ;
3141: -- RAISE FND_API.G_EXC_ERROR;
3142: when FND_API.G_EXC_UNEXPECTED_ERROR then
3143: if ind_res%isopen then close ind_res; end if;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3142: when FND_API.G_EXC_UNEXPECTED_ERROR then

3138: when FND_API.G_EXC_ERROR then
3139: if ind_res%isopen then close ind_res; end if;
3140: x_return_status := FND_API.G_RET_STS_ERROR ;
3141: -- RAISE FND_API.G_EXC_ERROR;
3142: when FND_API.G_EXC_UNEXPECTED_ERROR then
3143: if ind_res%isopen then close ind_res; end if;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: when others then

Line 3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3140: x_return_status := FND_API.G_RET_STS_ERROR ;
3141: -- RAISE FND_API.G_EXC_ERROR;
3142: when FND_API.G_EXC_UNEXPECTED_ERROR then
3143: if ind_res%isopen then close ind_res; end if;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: when others then
3147: if ind_res%isopen then close ind_res; end if;
3148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3145: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3141: -- RAISE FND_API.G_EXC_ERROR;
3142: when FND_API.G_EXC_UNEXPECTED_ERROR then
3143: if ind_res%isopen then close ind_res; end if;
3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: when others then
3147: if ind_res%isopen then close ind_res; end if;
3148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3149: --added last two params

Line 3148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3145: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: when others then
3147: if ind_res%isopen then close ind_res; end if;
3148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3149: --added last two params
3150: l_error_tbl := x_error_tbl;
3151: BIS_UTILITIES_PVT.Add_Error_Message
3152: ( p_error_msg_id => SQLCODE

Line 3158: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3154: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Target_Levels'
3155: , p_error_table => l_error_tbl
3156: , x_error_table => x_error_tbl
3157: );
3158: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3159:
3160: END Retrieve_User_Target_Levels;
3161:
3162: --

Line 3176: x_return_status := FND_API.G_RET_STS_SUCCESS;

3172: l_date_char VARCHAR2(32000);
3173: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3174:
3175: BEGIN
3176: x_return_status := FND_API.G_RET_STS_SUCCESS;
3177: --
3178: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Target_Level_ID)
3179: = FND_API.G_TRUE
3180: ) THEN

Line 3179: = FND_API.G_TRUE

3175: BEGIN
3176: x_return_status := FND_API.G_RET_STS_SUCCESS;
3177: --
3178: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Target_Level_ID)
3179: = FND_API.G_TRUE
3180: ) THEN
3181: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
3182: INTO x_last_update_date
3183: FROM BIS_TARGET_LEVELS

Line 3201: x_return_status := FND_API.G_RET_STS_ERROR;

3197: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3198: , p_error_table => l_error_tbl
3199: , x_error_table => x_error_tbl
3200: );
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: -- RAISE FND_API.G_EXC_ERROR;
3203: WHEN FND_API.G_EXC_ERROR THEN
3204: x_return_status:= FND_API.G_RET_STS_ERROR;
3205: -- RAISE;

Line 3202: -- RAISE FND_API.G_EXC_ERROR;

3198: , p_error_table => l_error_tbl
3199: , x_error_table => x_error_tbl
3200: );
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: -- RAISE FND_API.G_EXC_ERROR;
3203: WHEN FND_API.G_EXC_ERROR THEN
3204: x_return_status:= FND_API.G_RET_STS_ERROR;
3205: -- RAISE;
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3203: WHEN FND_API.G_EXC_ERROR THEN

3199: , x_error_table => x_error_tbl
3200: );
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: -- RAISE FND_API.G_EXC_ERROR;
3203: WHEN FND_API.G_EXC_ERROR THEN
3204: x_return_status:= FND_API.G_RET_STS_ERROR;
3205: -- RAISE;
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3207: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 3204: x_return_status:= FND_API.G_RET_STS_ERROR;

3200: );
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: -- RAISE FND_API.G_EXC_ERROR;
3203: WHEN FND_API.G_EXC_ERROR THEN
3204: x_return_status:= FND_API.G_RET_STS_ERROR;
3205: -- RAISE;
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3207: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3208: -- RAISE;

Line 3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3202: -- RAISE FND_API.G_EXC_ERROR;
3203: WHEN FND_API.G_EXC_ERROR THEN
3204: x_return_status:= FND_API.G_RET_STS_ERROR;
3205: -- RAISE;
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3207: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3208: -- RAISE;
3209: WHEN OTHERS THEN
3210: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 3207: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3203: WHEN FND_API.G_EXC_ERROR THEN
3204: x_return_status:= FND_API.G_RET_STS_ERROR;
3205: -- RAISE;
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3207: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3208: -- RAISE;
3209: WHEN OTHERS THEN
3210: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3211: --added last two params

Line 3210: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3207: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3208: -- RAISE;
3209: WHEN OTHERS THEN
3210: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3211: --added last two params
3212: l_error_tbl := x_error_tbl;
3213: BIS_UTILITIES_PVT.Add_Error_Message
3214: ( p_error_msg_id => SQLCODE

Line 3220: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3216: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
3217: , p_error_table => l_error_tbl
3218: , x_error_table => x_error_tbl
3219: );
3220: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: --
3222: END Retrieve_Last_Update_Date;
3223: --
3224: --

Line 3240: x_return_status := FND_API.G_RET_STS_SUCCESS;

3236: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3237: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3238: --
3239: BEGIN
3240: x_return_status := FND_API.G_RET_STS_SUCCESS;
3241: --
3242: l_Target_Level_Rec.Target_Level_Id := p_Target_Level_Rec.Target_Level_Id;
3243: BIS_Target_Level_PVT.Retrieve_Last_Update_Date
3244: ( p_api_version => 1.0

Line 3254: x_return_status := FND_API.G_TRUE;

3250: IF(p_timestamp IS NOT NULL) THEN
3251: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
3252:
3253: IF(l_form_date = l_last_update_date) THEN
3254: x_return_status := FND_API.G_TRUE;
3255: ELSE
3256: x_return_status := FND_API.G_FALSE;
3257: END IF;
3258: ELSE

Line 3256: x_return_status := FND_API.G_FALSE;

3252:
3253: IF(l_form_date = l_last_update_date) THEN
3254: x_return_status := FND_API.G_TRUE;
3255: ELSE
3256: x_return_status := FND_API.G_FALSE;
3257: END IF;
3258: ELSE
3259: x_return_status := FND_API.G_FALSE;
3260: END IF;

Line 3259: x_return_status := FND_API.G_FALSE;

3255: ELSE
3256: x_return_status := FND_API.G_FALSE;
3257: END IF;
3258: ELSE
3259: x_return_status := FND_API.G_FALSE;
3260: END IF;
3261: --
3262: --commented RAISE
3263: EXCEPTION

Line 3264: WHEN FND_API.G_EXC_ERROR THEN

3260: END IF;
3261: --
3262: --commented RAISE
3263: EXCEPTION
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: x_return_status:= FND_API.G_RET_STS_ERROR;
3266: -- RAISE;
3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 3265: x_return_status:= FND_API.G_RET_STS_ERROR;

3261: --
3262: --commented RAISE
3263: EXCEPTION
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: x_return_status:= FND_API.G_RET_STS_ERROR;
3266: -- RAISE;
3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3269: -- RAISE;

Line 3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3263: EXCEPTION
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: x_return_status:= FND_API.G_RET_STS_ERROR;
3266: -- RAISE;
3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3269: -- RAISE;
3270: WHEN OTHERS THEN
3271: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 3268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3264: WHEN FND_API.G_EXC_ERROR THEN
3265: x_return_status:= FND_API.G_RET_STS_ERROR;
3266: -- RAISE;
3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3269: -- RAISE;
3270: WHEN OTHERS THEN
3271: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3272: --added last two params

Line 3271: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3269: -- RAISE;
3270: WHEN OTHERS THEN
3271: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3272: --added last two params
3273: l_error_tbl := x_error_tbl;
3274: BIS_UTILITIES_PVT.Add_Error_Message
3275: ( p_error_msg_id => SQLCODE

Line 3281: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3277: , p_error_proc_name => G_PKG_NAME||'.BIS_Target_Level_PVT'
3278: , p_error_table => l_error_tbl
3279: , x_error_table => x_error_tbl
3280: );
3281: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3282: --
3283: END Lock_Record;
3284: --
3285:

Line 3331: = FND_API.G_TRUE)

3327:
3328: BEGIN
3329:
3330: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3331: = FND_API.G_TRUE)
3332: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3333: = FND_API.G_TRUE)
3334: THEN
3335: OPEN cr_tl_id_dim_level(p_Target_Level_Rec.target_level_id);

Line 3333: = FND_API.G_TRUE)

3329:
3330: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3331: = FND_API.G_TRUE)
3332: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3333: = FND_API.G_TRUE)
3334: THEN
3335: OPEN cr_tl_id_dim_level(p_Target_Level_Rec.target_level_id);
3336: FETCH cr_tl_id_dim_level INTO
3337: l_dimension_level_tbl(1).dimension_level_id,

Line 3357: x_return_status := FND_API.G_RET_STS_ERROR;

3353: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3354: , p_error_table => l_error_tbl
3355: , x_error_table => x_error_tbl
3356: );
3357: x_return_status := FND_API.G_RET_STS_ERROR;
3358: RAISE FND_API.G_EXC_ERROR;
3359: end if;
3360:
3361: CLOSE cr_tl_id_dim_level;

Line 3358: RAISE FND_API.G_EXC_ERROR;

3354: , p_error_table => l_error_tbl
3355: , x_error_table => x_error_tbl
3356: );
3357: x_return_status := FND_API.G_RET_STS_ERROR;
3358: RAISE FND_API.G_EXC_ERROR;
3359: end if;
3360:
3361: CLOSE cr_tl_id_dim_level;
3362: --------

Line 3393: x_return_status := FND_API.G_RET_STS_ERROR;

3389: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3390: , p_error_table => l_error_tbl
3391: , x_error_table => x_error_tbl
3392: );
3393: x_return_status := FND_API.G_RET_STS_ERROR;
3394: RAISE FND_API.G_EXC_ERROR;
3395: end if;
3396:
3397: CLOSE cr_tl_sn_dim_level;

Line 3394: RAISE FND_API.G_EXC_ERROR;

3390: , p_error_table => l_error_tbl
3391: , x_error_table => x_error_tbl
3392: );
3393: x_return_status := FND_API.G_RET_STS_ERROR;
3394: RAISE FND_API.G_EXC_ERROR;
3395: end if;
3396:
3397: CLOSE cr_tl_sn_dim_level;
3398: --------

Line 3444: WHEN FND_API.G_EXC_ERROR THEN

3440:
3441: EXCEPTION
3442:
3443: --added this
3444: WHEN FND_API.G_EXC_ERROR THEN
3445: x_return_status := FND_API.G_RET_STS_ERROR;
3446: IF cr_tl_sn_dim_level%ISOPEN THEN CLOSE cr_tl_sn_dim_level; END IF;
3447: IF cr_tl_id_dim_level%ISOPEN THEN CLOSE cr_tl_id_dim_level; END IF;
3448: WHEN OTHERS THEN

Line 3445: x_return_status := FND_API.G_RET_STS_ERROR;

3441: EXCEPTION
3442:
3443: --added this
3444: WHEN FND_API.G_EXC_ERROR THEN
3445: x_return_status := FND_API.G_RET_STS_ERROR;
3446: IF cr_tl_sn_dim_level%ISOPEN THEN CLOSE cr_tl_sn_dim_level; END IF;
3447: IF cr_tl_id_dim_level%ISOPEN THEN CLOSE cr_tl_id_dim_level; END IF;
3448: WHEN OTHERS THEN
3449: --dbms_output('Error while getting time level: '||SQLERRM);

Line 3452: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3448: WHEN OTHERS THEN
3449: --dbms_output('Error while getting time level: '||SQLERRM);
3450: IF cr_tl_sn_dim_level%ISOPEN THEN CLOSE cr_tl_sn_dim_level; END IF;
3451: IF cr_tl_id_dim_level%ISOPEN THEN CLOSE cr_tl_id_dim_level; END IF;
3452: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3453: l_error_Tbl := x_error_Tbl;
3454: BIS_UTILITIES_PVT.Add_Error_Message
3455: ( p_error_table => l_error_Tbl
3456: , p_error_msg_id => SQLCODE

Line 3557: = FND_API.G_TRUE)

3553:
3554: l_err_track := 100;
3555:
3556: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3557: = FND_API.G_TRUE)
3558: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3559: = FND_API.G_TRUE)
3560: THEN
3561:

Line 3559: = FND_API.G_TRUE)

3555:
3556: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3557: = FND_API.G_TRUE)
3558: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3559: = FND_API.G_TRUE)
3560: THEN
3561:
3562: l_err_track := 200;
3563:

Line 3586: x_return_status := FND_API.G_RET_STS_ERROR;

3582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3583: , p_error_table => l_error_tbl
3584: , x_error_table => x_error_tbl
3585: );
3586: x_return_status := FND_API.G_RET_STS_ERROR;
3587: RAISE FND_API.G_EXC_ERROR;
3588: end if;
3589:
3590: l_err_track := 300;

Line 3587: RAISE FND_API.G_EXC_ERROR;

3583: , p_error_table => l_error_tbl
3584: , x_error_table => x_error_tbl
3585: );
3586: x_return_status := FND_API.G_RET_STS_ERROR;
3587: RAISE FND_API.G_EXC_ERROR;
3588: end if;
3589:
3590: l_err_track := 300;
3591:

Line 3642: x_return_status := FND_API.G_RET_STS_ERROR;

3638: , p_error_table => l_error_tbl
3639: , x_error_table => x_error_tbl
3640: );
3641:
3642: x_return_status := FND_API.G_RET_STS_ERROR;
3643: RAISE FND_API.G_EXC_ERROR;
3644:
3645: end if;
3646:

Line 3643: RAISE FND_API.G_EXC_ERROR;

3639: , x_error_table => x_error_tbl
3640: );
3641:
3642: x_return_status := FND_API.G_RET_STS_ERROR;
3643: RAISE FND_API.G_EXC_ERROR;
3644:
3645: end if;
3646:
3647: CLOSE cr_ol_sn_dim_level;

Line 3696: WHEN FND_API.G_EXC_ERROR THEN

3692:
3693: EXCEPTION
3694:
3695:
3696: WHEN FND_API.G_EXC_ERROR THEN
3697: x_return_status := FND_API.G_RET_STS_ERROR;
3698: IF cr_ol_sn_dim_level%ISOPEN THEN CLOSE cr_ol_sn_dim_level; END IF;
3699: IF cr_ol_id_dim_level%ISOPEN THEN CLOSE cr_ol_id_dim_level; END IF;
3700: WHEN OTHERS THEN

Line 3697: x_return_status := FND_API.G_RET_STS_ERROR;

3693: EXCEPTION
3694:
3695:
3696: WHEN FND_API.G_EXC_ERROR THEN
3697: x_return_status := FND_API.G_RET_STS_ERROR;
3698: IF cr_ol_sn_dim_level%ISOPEN THEN CLOSE cr_ol_sn_dim_level; END IF;
3699: IF cr_ol_id_dim_level%ISOPEN THEN CLOSE cr_ol_id_dim_level; END IF;
3700: WHEN OTHERS THEN
3701: BIS_UTILITIES_PUB.put_line(p_text =>'Error while getting org level: bisvtalb ' || l_err_track || SQLERRM);

Line 3704: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

3700: WHEN OTHERS THEN
3701: BIS_UTILITIES_PUB.put_line(p_text =>'Error while getting org level: bisvtalb ' || l_err_track || SQLERRM);
3702: IF cr_ol_sn_dim_level%ISOPEN THEN CLOSE cr_ol_sn_dim_level; END IF;
3703: IF cr_ol_id_dim_level%ISOPEN THEN CLOSE cr_ol_id_dim_level; END IF;
3704: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3705: l_error_Tbl := x_error_Tbl;
3706: BIS_UTILITIES_PVT.Add_Error_Message
3707: ( p_error_table => l_error_Tbl
3708: , p_error_msg_id => SQLCODE

Line 3777: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_short_name) = FND_API.G_TRUE) THEN

3773: BEGIN
3774:
3775:
3776: IF (p_target_level_rec.measure_short_name IS NOT NULL
3777: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_short_name) = FND_API.G_TRUE) THEN
3778: l_measure_rec.measure_short_name := p_target_level_rec.measure_short_name;
3779: END IF;
3780: IF (p_target_level_rec.measure_id IS NOT NULL
3781: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_id) = FND_API.G_TRUE) THEN

Line 3781: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_id) = FND_API.G_TRUE) THEN

3777: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_short_name) = FND_API.G_TRUE) THEN
3778: l_measure_rec.measure_short_name := p_target_level_rec.measure_short_name;
3779: END IF;
3780: IF (p_target_level_rec.measure_id IS NOT NULL
3781: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_id) = FND_API.G_TRUE) THEN
3782: l_measure_rec.measure_id := p_target_level_rec.measure_id;
3783: END IF;
3784: --Populate the measure record with all the relevant values
3785: l_measure_rec_p := l_measure_rec;

Line 3788: ,p_all_info =>FND_API.G_TRUE

3784: --Populate the measure record with all the relevant values
3785: l_measure_rec_p := l_measure_rec;
3786: BIS_MEASURE_PUB.RETRIEVE_MEASURE( p_api_version => p_api_version
3787: ,p_measure_rec => l_measure_rec_p
3788: ,p_all_info =>FND_API.G_TRUE
3789: ,x_measure_rec => l_measure_rec
3790: ,x_return_status => x_return_status
3791: ,x_error_tbl => x_error_tbl
3792: );

Line 3796: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension1_level_short_name) = FND_API.G_TRUE) THEN

3792: );
3793:
3794:
3795: IF (p_target_level_rec.dimension1_level_short_name IS NOT NULL
3796: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension1_level_short_name) = FND_API.G_TRUE) THEN
3797: OPEN c_dim_lvl(p_target_level_rec.dimension1_level_short_name);
3798: FETCH c_dim_lvl INTO x_target_level_rec.dimension1_level_id,x_target_level_rec.dimension1_level_name;
3799: CLOSE c_dim_lvl;
3800: END IF;

Line 3802: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension2_level_short_name)= FND_API.G_TRUE) THEN

3798: FETCH c_dim_lvl INTO x_target_level_rec.dimension1_level_id,x_target_level_rec.dimension1_level_name;
3799: CLOSE c_dim_lvl;
3800: END IF;
3801: IF (p_target_level_rec.dimension2_level_short_name IS NOT NULL
3802: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension2_level_short_name)= FND_API.G_TRUE) THEN
3803: OPEN c_dim_lvl(p_target_level_rec.dimension2_level_short_name);
3804: FETCH c_dim_lvl INTO x_target_level_rec.dimension2_level_id,x_target_level_rec.dimension2_level_name;
3805: CLOSE c_dim_lvl;
3806: END IF;

Line 3808: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension3_level_short_name)= FND_API.G_TRUE) THEN

3804: FETCH c_dim_lvl INTO x_target_level_rec.dimension2_level_id,x_target_level_rec.dimension2_level_name;
3805: CLOSE c_dim_lvl;
3806: END IF;
3807: IF (p_target_level_rec.dimension3_level_short_name IS NOT NULL
3808: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension3_level_short_name)= FND_API.G_TRUE) THEN
3809: OPEN c_dim_lvl(p_target_level_rec.dimension3_level_short_name);
3810: FETCH c_dim_lvl INTO x_target_level_rec.dimension3_level_id,x_target_level_rec.dimension3_level_name;
3811: CLOSE c_dim_lvl;
3812: END IF;

Line 3814: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension4_level_short_name)= FND_API.G_TRUE) THEN

3810: FETCH c_dim_lvl INTO x_target_level_rec.dimension3_level_id,x_target_level_rec.dimension3_level_name;
3811: CLOSE c_dim_lvl;
3812: END IF;
3813: IF (p_target_level_rec.dimension4_level_short_name IS NOT NULL
3814: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension4_level_short_name)= FND_API.G_TRUE) THEN
3815: OPEN c_dim_lvl(p_target_level_rec.dimension4_level_short_name);
3816: FETCH c_dim_lvl INTO x_target_level_rec.dimension4_level_id,x_target_level_rec.dimension4_level_name;
3817: CLOSE c_dim_lvl;
3818: END IF;

Line 3820: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension5_level_short_name)= FND_API.G_TRUE) THEN

3816: FETCH c_dim_lvl INTO x_target_level_rec.dimension4_level_id,x_target_level_rec.dimension4_level_name;
3817: CLOSE c_dim_lvl;
3818: END IF;
3819: IF (p_target_level_rec.dimension5_level_short_name IS NOT NULL
3820: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension5_level_short_name)= FND_API.G_TRUE) THEN
3821: OPEN c_dim_lvl(p_target_level_rec.dimension5_level_short_name);
3822: FETCH c_dim_lvl INTO x_target_level_rec.dimension5_level_id,x_target_level_rec.dimension5_level_name;
3823: CLOSE c_dim_lvl;
3824: END IF;

Line 3826: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension6_level_short_name)= FND_API.G_TRUE) THEN

3822: FETCH c_dim_lvl INTO x_target_level_rec.dimension5_level_id,x_target_level_rec.dimension5_level_name;
3823: CLOSE c_dim_lvl;
3824: END IF;
3825: IF (p_target_level_rec.dimension6_level_short_name IS NOT NULL
3826: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension6_level_short_name)= FND_API.G_TRUE) THEN
3827: OPEN c_dim_lvl(p_target_level_rec.dimension6_level_short_name);
3828: FETCH c_dim_lvl INTO x_target_level_rec.dimension6_level_id,x_target_level_rec.dimension6_level_name;
3829: CLOSE c_dim_lvl;
3830: END IF;

Line 3832: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension7_level_short_name)= FND_API.G_TRUE) THEN

3828: FETCH c_dim_lvl INTO x_target_level_rec.dimension6_level_id,x_target_level_rec.dimension6_level_name;
3829: CLOSE c_dim_lvl;
3830: END IF;
3831: IF (p_target_level_rec.dimension7_level_short_name IS NOT NULL
3832: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension7_level_short_name)= FND_API.G_TRUE) THEN
3833: OPEN c_dim_lvl(p_target_level_rec.dimension7_level_short_name);
3834: FETCH c_dim_lvl INTO x_target_level_rec.dimension7_level_id,x_target_level_rec.dimension7_level_name;
3835: CLOSE c_dim_lvl;
3836: END IF;

Line 3843: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension1_level_id)= FND_API.G_TRUE) THEN

3839:
3840: --Get the dimension ids for all the dimension level ids. This will be later used to
3841: --sequence the dimension levels
3842: IF (x_target_level_rec.dimension1_level_id IS NOT NULL
3843: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension1_level_id)= FND_API.G_TRUE) THEN
3844: SetNULL(l_dim_level_rec,l_dim_level_rec);
3845: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension1_level_id;
3846: l_dim_level_rec_p := l_dim_level_rec;
3847: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3857: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN

3853: l_dim1_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3854: END IF;
3855:
3856: IF (x_target_level_rec.dimension2_level_id IS NOT NULL
3857: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN
3858: SetNULL(l_dim_level_rec,l_dim_level_rec);
3859: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension2_level_id;
3860: l_dim_level_rec_p := l_dim_level_rec;
3861: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3871: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN

3867: l_dim2_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3868: END IF;
3869:
3870: IF (x_target_level_rec.dimension3_level_id IS NOT NULL
3871: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN
3872: SetNULL(l_dim_level_rec,l_dim_level_rec);
3873: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension3_level_id;
3874: l_dim_level_rec_p := l_dim_level_rec;
3875: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3885: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN

3881: l_dim3_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3882: END IF;
3883:
3884: IF (x_target_level_rec.dimension4_level_id IS NOT NULL
3885: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN
3886: SetNULL(l_dim_level_rec,l_dim_level_rec);
3887: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension4_level_id;
3888: l_dim_level_rec_p := l_dim_level_rec;
3889: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3899: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN

3895: l_dim4_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3896: END IF;
3897:
3898: IF (x_target_level_rec.dimension5_level_id IS NOT NULL
3899: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN
3900: SetNULL(l_dim_level_rec,l_dim_level_rec);
3901: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension5_level_id;
3902: l_dim_level_rec_p := l_dim_level_rec;
3903: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3913: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN

3909: l_dim5_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3910: END IF;
3911:
3912: IF (x_target_level_rec.dimension6_level_id IS NOT NULL
3913: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN
3914: SetNULL(l_dim_level_rec,l_dim_level_rec);
3915: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension6_level_id;
3916: l_dim_level_rec_p := l_dim_level_rec;
3917: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3927: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN

3923: l_dim6_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3924: END IF;
3925:
3926: IF (x_target_level_rec.dimension7_level_id IS NOT NULL
3927: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN
3928: SetNULL(l_dim_level_rec,l_dim_level_rec);
3929: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension7_level_id;
3930: l_dim_level_rec_p := l_dim_level_rec;
3931: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 4221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4218:
4219: EXCEPTION
4220: when others then
4221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4222: --Added last two parameters
4223: l_error_tbl := x_error_tbl;
4224: BIS_UTILITIES_PVT.Add_Error_Message
4225: ( p_error_msg_id => SQLCODE

Line 4231: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4227: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
4228: , p_error_table => l_error_tbl
4229: , x_error_table => x_error_tbl
4230: );
4231: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232:
4233: END Retrieve_TL_From_DimLvlShNms;
4234: --------------------------------
4235:

Line 4251: x_return_status := FND_API.G_RET_STS_SUCCESS;

4247: l_pm_count NUMBER := 0;
4248:
4249: BEGIN
4250:
4251: x_return_status := FND_API.G_RET_STS_SUCCESS;
4252:
4253: FOR i IN c_updt1 LOOP
4254:
4255: l_pm_count := l_pm_count + 1;

Line 4271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4267:
4268: END LOOP;
4269:
4270: if l_pm_count = 0 then
4271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4272: end if;
4273:
4274: EXCEPTION
4275: WHEN OTHERS THEN

Line 4277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4273:
4274: EXCEPTION
4275: WHEN OTHERS THEN
4276:
4277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4278:
4279: IF c_updt1%ISOPEN THEN
4280: CLOSE c_updt1;
4281: END IF;

Line 4315: , p_all_info => FND_API.G_TRUE

4311: l_measure_rec_p := l_measure_rec;
4312: BIS_MEASURE_PVT.Retrieve_Measure
4313: ( p_api_version => 1.0
4314: , p_Measure_Rec => l_measure_rec_p
4315: , p_all_info => FND_API.G_TRUE
4316: , x_Measure_Rec => l_measure_rec
4317: , x_return_status => l_return_status
4318: , x_error_Tbl => l_error_Tbl
4319: );

Line 4321: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

4317: , x_return_status => l_return_status
4318: , x_error_Tbl => l_error_Tbl
4319: );
4320:
4321: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
4322: RAISE FND_API.G_EXC_ERROR;
4323: END IF;
4324:
4325: Level_Correspond_To_Dim

Line 4322: RAISE FND_API.G_EXC_ERROR;

4318: , x_error_Tbl => l_error_Tbl
4319: );
4320:
4321: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
4322: RAISE FND_API.G_EXC_ERROR;
4323: END IF;
4324:
4325: Level_Correspond_To_Dim
4326: (

Line 4336: RAISE FND_API.G_EXC_ERROR;

4332:
4333: x_return_status := l_return_status ;
4334:
4335: IF (l_return_status = 'E') THEN
4336: RAISE FND_API.G_EXC_ERROR;
4337: END IF;
4338:
4339: EXCEPTION
4340: WHEN NO_DATA_FOUND THEN

Line 4414: RAISE FND_API.G_EXC_ERROR;

4410: OR (l_return_status2 = 'E')
4411: OR (NOT(l_unique_levels))
4412: OR (NOT(l_unique_dims)) ) THEN
4413:
4414: RAISE FND_API.G_EXC_ERROR;
4415:
4416: END IF;
4417:
4418: COMPARE_LEVELS_DIMS

Line 4428: RAISE FND_API.G_EXC_ERROR;

4424: , x_return_msg => l_return_msg
4425: );
4426:
4427: IF (l_return_status1 = 'E') THEN
4428: RAISE FND_API.G_EXC_ERROR;
4429: END IF;
4430:
4431: x_return_status := 'S';
4432:

Line 4476: RAISE FND_API.G_EXC_ERROR;

4472: l_dim_id := GET_DIM_ID_FRM_LVL_SHTNM
4473: ( p_level_shtnm => l_lvl_short_name);
4474:
4475: IF NOT(IS_NOT_NULL_MISSING_NUM(l_dim_id)) THEN
4476: RAISE FND_API.G_EXC_ERROR;
4477: END IF;
4478:
4479: FOR j IN 1..p_dim_tbl_type.COUNT LOOP
4480: IF (l_dim_id = p_dim_tbl_type(j)) THEN

Line 4500: RAISE FND_API.G_EXC_ERROR;

4496:
4497: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
4498: */
4499:
4500: RAISE FND_API.G_EXC_ERROR;
4501:
4502: END IF;
4503:
4504: END LOOP;

Line 4542: RAISE FND_API.G_EXC_ERROR;

4538: || '. Upload of this Summary Level is therefore aborted.';
4539: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
4540: */
4541:
4542: RAISE FND_API.G_EXC_ERROR;
4543: END IF;
4544:
4545: END LOOP;
4546:

Line 4626: RAISE FND_API.G_EXC_ERROR;

4622: x_num_dims := l_num_dims;
4623: x_return_status := 'S';
4624:
4625: ELSE
4626: RAISE FND_API.G_EXC_ERROR;
4627: END IF;
4628:
4629: EXCEPTION
4630: WHEN OTHERS THEN

Line 4701: RAISE FND_API.G_EXC_ERROR;

4697: IF ( IS_NOT_NULL_MISSING_NUM(l_num_levels) ) THEN
4698: IF ( (l_num_levels>0) AND (l_num_levels<10)) THEN
4699: x_num_lvls := l_num_levels;
4700: ELSE
4701: RAISE FND_API.G_EXC_ERROR;
4702: END IF;
4703: ELSE
4704: RAISE FND_API.G_EXC_ERROR;
4705: END IF;

Line 4704: RAISE FND_API.G_EXC_ERROR;

4700: ELSE
4701: RAISE FND_API.G_EXC_ERROR;
4702: END IF;
4703: ELSE
4704: RAISE FND_API.G_EXC_ERROR;
4705: END IF;
4706:
4707: x_lvl_tbl_type := l_lvl_tbl_type;
4708: x_return_status := 'S';

Line 4734: RAISE FND_API.G_EXC_ERROR;

4730:
4731: l_num_dims := p_dim_tbl_type.COUNT;
4732:
4733: IF NOT(IS_NOT_NULL_MISSING_NUM(l_num_dims)) THEN
4734: RAISE FND_API.G_EXC_ERROR;
4735: END IF;
4736:
4737: FOR i IN 1..l_num_dims LOOP
4738: FOR j IN (i+1)..l_num_dims LOOP

Line 4748: RAISE FND_API.G_EXC_ERROR;

4744: WHERE dimension_id = p_dim_tbl_type(i);
4745:
4746: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension ' || nvl(l_dim_short_name, ' ') || ' is not unique. ' ); -- 2515991
4747:
4748: RAISE FND_API.G_EXC_ERROR;
4749:
4750: END IF;
4751: END LOOP;
4752: END LOOP;

Line 4797: RAISE FND_API.G_EXC_ERROR;

4793:
4794: l_num_levels := p_lvl_tbl_type.COUNT;
4795:
4796: IF NOT(IS_NOT_NULL_MISSING_NUM(l_num_levels)) THEN
4797: RAISE FND_API.G_EXC_ERROR;
4798: END IF;
4799:
4800: FOR i IN 1..l_num_levels LOOP
4801:

Line 4810: RAISE FND_API.G_EXC_ERROR;

4806: IF (IS_ORG_OR_TIME_LEVEL(p_lvl_tbl_type(i))) THEN
4807: l_count := l_count + 1;
4808: ELSE
4809: -- BIS_UTILITIES_PUB.put_line(p_text =>'The level ' || nvl(p_lvl_tbl_type(i), ' ') || ' is not unique. ' ); -- 2515991
4810: RAISE FND_API.G_EXC_ERROR;
4811: END IF;
4812: END IF;
4813: END LOOP;
4814:

Line 4820: RAISE FND_API.G_EXC_ERROR;

4816:
4817: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension level corresponding to Organization or Time dimension appears -- 2515991
4818: -- more than twice in the definition of this Summary Level.' );
4819:
4820: RAISE FND_API.G_EXC_ERROR;
4821: END IF;
4822:
4823: END LOOP;
4824:

Line 4873: (BIS_UTILITIES_PVT.Value_Not_Missing(p_string) = FND_API.G_TRUE)

4869: (p_string IN VARCHAR2)
4870: RETURN BOOLEAN IS
4871: BEGIN
4872: IF (
4873: (BIS_UTILITIES_PVT.Value_Not_Missing(p_string) = FND_API.G_TRUE)
4874: AND
4875: (BIS_UTILITIES_PVT.Value_Not_Null(p_string) = FND_API.G_TRUE)
4876: ) THEN
4877: RETURN TRUE;

Line 4875: (BIS_UTILITIES_PVT.Value_Not_Null(p_string) = FND_API.G_TRUE)

4871: BEGIN
4872: IF (
4873: (BIS_UTILITIES_PVT.Value_Not_Missing(p_string) = FND_API.G_TRUE)
4874: AND
4875: (BIS_UTILITIES_PVT.Value_Not_Null(p_string) = FND_API.G_TRUE)
4876: ) THEN
4877: RETURN TRUE;
4878: ELSE
4879: RETURN FALSE;

Line 4892: (BIS_UTILITIES_PVT.Value_Not_Missing(p_number) = FND_API.G_TRUE)

4888: (p_number IN NUMBER)
4889: RETURN BOOLEAN IS
4890: BEGIN
4891: IF (
4892: (BIS_UTILITIES_PVT.Value_Not_Missing(p_number) = FND_API.G_TRUE)
4893: AND
4894: (BIS_UTILITIES_PVT.Value_Not_Null(p_number) = FND_API.G_TRUE)
4895: ) THEN
4896: RETURN TRUE;

Line 4894: (BIS_UTILITIES_PVT.Value_Not_Null(p_number) = FND_API.G_TRUE)

4890: BEGIN
4891: IF (
4892: (BIS_UTILITIES_PVT.Value_Not_Missing(p_number) = FND_API.G_TRUE)
4893: AND
4894: (BIS_UTILITIES_PVT.Value_Not_Null(p_number) = FND_API.G_TRUE)
4895: ) THEN
4896: RETURN TRUE;
4897: ELSE
4898: RETURN FALSE;