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.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_DEBUG

Line 545: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

541: l_module_name VARCHAR2(100) := 'partially_impl_cos_exist:' || g_module_name;
542:
543: BEGIN
544:
545: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
546:
547: IF l_debug_mode = 'Y' THEN
548: pa_debug.set_curr_function( p_function => 'partially_impl_cos_exist',
549: p_debug_mode => l_debug_mode );

Line 548: pa_debug.set_curr_function( p_function => 'partially_impl_cos_exist',

544:
545: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
546:
547: IF l_debug_mode = 'Y' THEN
548: pa_debug.set_curr_function( p_function => 'partially_impl_cos_exist',
549: p_debug_mode => l_debug_mode );
550: END IF;
551:
552: IF l_debug_mode = 'Y' THEN

Line 553: pa_debug.g_err_stage:= 'Entering PARTIALLY_IMPL_COS_ESIST';

549: p_debug_mode => l_debug_mode );
550: END IF;
551:
552: IF l_debug_mode = 'Y' THEN
553: pa_debug.g_err_stage:= 'Entering PARTIALLY_IMPL_COS_ESIST';
554: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
555: END IF;
556:
557: IF l_debug_mode = 'Y' THEN

Line 554: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

550: END IF;
551:
552: IF l_debug_mode = 'Y' THEN
553: pa_debug.g_err_stage:= 'Entering PARTIALLY_IMPL_COS_ESIST';
554: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
555: END IF;
556:
557: IF l_debug_mode = 'Y' THEN
558: pa_debug.g_err_stage:= 'The plan type Id : ' || p_fin_plan_type_id;

Line 558: pa_debug.g_err_stage:= 'The plan type Id : ' || p_fin_plan_type_id;

554: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
555: END IF;
556:
557: IF l_debug_mode = 'Y' THEN
558: pa_debug.g_err_stage:= 'The plan type Id : ' || p_fin_plan_type_id;
559: pa_debug.write(l_module_name,pa_debug.g_err_stage,
560: l_debug_level3);
561: END IF;
562:

Line 559: pa_debug.write(l_module_name,pa_debug.g_err_stage,

555: END IF;
556:
557: IF l_debug_mode = 'Y' THEN
558: pa_debug.g_err_stage:= 'The plan type Id : ' || p_fin_plan_type_id;
559: pa_debug.write(l_module_name,pa_debug.g_err_stage,
560: l_debug_level3);
561: END IF;
562:
563: IF p_fin_plan_type_id IS NULL THEN

Line 564: pa_debug.reset_curr_function;

560: l_debug_level3);
561: END IF;
562:
563: IF p_fin_plan_type_id IS NULL THEN
564: pa_debug.reset_curr_function;
565: RETURN 'N';
566:
567: ELSIF p_ci_type_id IS NOT NULL THEN
568:

Line 586: pa_debug.reset_curr_function;

582: EXCEPTION
583: WHEN NO_DATA_FOUND THEN
584: l_return_flag := 'N';
585:
586: pa_debug.reset_curr_function;
587: RETURN l_return_flag;
588: END;
589:
590: IF l_partial_cos_exist IS NULL THEN

Line 592: pa_debug.reset_curr_function;

588: END;
589:
590: IF l_partial_cos_exist IS NULL THEN
591: IF l_debug_mode= 'Y' THEN
592: pa_debug.reset_curr_function;
593: END IF;
594:
595: RETURN 'N';
596: ELSE

Line 598: pa_debug.reset_curr_function;

594:
595: RETURN 'N';
596: ELSE
597: IF l_debug_mode='Y' THEN
598: pa_debug.reset_curr_function;
599: END IF;
600:
601: RETURN 'Y' ;
602: END IF;

Line 616: pa_debug.reset_curr_function;

612: AND ci_id is not null
613: AND ROWNUM = 1;
614:
615: IF l_debug_mode= 'Y' THEN
616: pa_debug.reset_curr_function;
617: END IF;
618:
619: RETURN l_return_flag;
620:

Line 626: pa_debug.reset_curr_function;

622: WHEN NO_DATA_FOUND THEN
623: l_return_flag := 'N';
624:
625: IF l_debug_mode= 'Y' THEN
626: pa_debug.reset_curr_function;
627: END IF;
628:
629: RETURN l_return_flag;
630: END;

Line 634: pa_debug.reset_curr_function;

630: END;
631: END IF;
632:
633: IF l_debug_mode= 'Y' THEN
634: pa_debug.reset_curr_function;
635: END IF;
636:
637: IF l_debug_mode= 'Y' THEN
638: pa_debug.g_err_stage:= 'Leaving PARTIALLY_IMPL_COS_EXIST' ;

Line 638: pa_debug.g_err_stage:= 'Leaving PARTIALLY_IMPL_COS_EXIST' ;

634: pa_debug.reset_curr_function;
635: END IF;
636:
637: IF l_debug_mode= 'Y' THEN
638: pa_debug.g_err_stage:= 'Leaving PARTIALLY_IMPL_COS_EXIST' ;
639: pa_debug.write(l_module_name,pa_debug.g_err_stage,
640: l_debug_level3);
641: END IF;
642:

Line 639: pa_debug.write(l_module_name,pa_debug.g_err_stage,

635: END IF;
636:
637: IF l_debug_mode= 'Y' THEN
638: pa_debug.g_err_stage:= 'Leaving PARTIALLY_IMPL_COS_EXIST' ;
639: pa_debug.write(l_module_name,pa_debug.g_err_stage,
640: l_debug_level3);
641: END IF;
642:
643: END partially_impl_cos_exist;

Line 675: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

671: c_status_rec c_status_csr%ROWTYPE;
672:
673: BEGIN
674:
675: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
676:
677: IF l_debug_mode = 'Y' THEN
678: pa_debug.set_curr_function( p_function => 'get_concat_statuses',
679: p_debug_mode => l_debug_mode );

Line 678: pa_debug.set_curr_function( p_function => 'get_concat_statuses',

674:
675: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
676:
677: IF l_debug_mode = 'Y' THEN
678: pa_debug.set_curr_function( p_function => 'get_concat_statuses',
679: p_debug_mode => l_debug_mode );
680: END IF;
681:
682: IF l_debug_mode = 'Y' THEN

Line 683: pa_debug.g_err_stage:= 'Entering GET_CONCAT_STATUSES';

679: p_debug_mode => l_debug_mode );
680: END IF;
681:
682: IF l_debug_mode = 'Y' THEN
683: pa_debug.g_err_stage:= 'Entering GET_CONCAT_STATUSES';
684: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
685: END IF;
686:
687: OPEN c_status_csr(p_impact_type_code);

Line 684: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

680: END IF;
681:
682: IF l_debug_mode = 'Y' THEN
683: pa_debug.g_err_stage:= 'Entering GET_CONCAT_STATUSES';
684: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
685: END IF;
686:
687: OPEN c_status_csr(p_impact_type_code);
688:

Line 701: pa_debug.g_err_stage:= 'The concatened status : ' || l_concat_status;

697: l_concat_status := l_concat_status || c_status_rec.project_status_name;
698: END LOOP;
699:
700: IF l_debug_mode = 'Y' THEN
701: pa_debug.g_err_stage:= 'The concatened status : ' || l_concat_status;
702: pa_debug.write(l_module_name,pa_debug.g_err_stage,
703: l_debug_level3);
704: END IF;
705:

Line 702: pa_debug.write(l_module_name,pa_debug.g_err_stage,

698: END LOOP;
699:
700: IF l_debug_mode = 'Y' THEN
701: pa_debug.g_err_stage:= 'The concatened status : ' || l_concat_status;
702: pa_debug.write(l_module_name,pa_debug.g_err_stage,
703: l_debug_level3);
704: END IF;
705:
706: CLOSE c_status_csr;

Line 709: pa_debug.reset_curr_function;

705:
706: CLOSE c_status_csr;
707:
708: IF l_debug_mode = 'Y' THEN
709: pa_debug.reset_curr_function;
710: END IF;
711:
712: RETURN l_concat_status;
713:

Line 717: pa_debug.reset_curr_function;

713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: IF l_debug_mode = 'Y' THEN
717: pa_debug.reset_curr_function;
718: END IF;
719:
720: FND_MSG_PUB.add_exc_msg( p_pkg_name
721: => 'PA_FIN_PLAN_TYPES_UTILS'

Line 727: pa_debug.g_err_stage:= 'Leaving GET_CONCAT_STATUSES';

723: => 'Get_concate_statuses');
724: RAISE;
725:
726: IF l_debug_mode = 'Y' THEN
727: pa_debug.g_err_stage:= 'Leaving GET_CONCAT_STATUSES';
728: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
729: END IF;
730:
731: END GET_CONCAT_STATUSES;

Line 728: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

724: RAISE;
725:
726: IF l_debug_mode = 'Y' THEN
727: pa_debug.g_err_stage:= 'Leaving GET_CONCAT_STATUSES';
728: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
729: END IF;
730:
731: END GET_CONCAT_STATUSES;
732:

Line 747: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

743: l_module_name VARCHAR2(100) := 'GET_WORKPLAN_PT_DETAILS' || g_module_name;
744:
745: BEGIN
746:
747: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
748:
749: IF l_debug_mode = 'Y' THEN
750: pa_debug.set_curr_function( p_function => 'get_workplan_pt_details',
751: p_debug_mode => l_debug_mode );

Line 750: pa_debug.set_curr_function( p_function => 'get_workplan_pt_details',

746:
747: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
748:
749: IF l_debug_mode = 'Y' THEN
750: pa_debug.set_curr_function( p_function => 'get_workplan_pt_details',
751: p_debug_mode => l_debug_mode );
752: END IF;
753:
754: IF l_debug_mode = 'Y' THEN

Line 755: pa_debug.g_err_stage:= 'Entering GET_WORKPLAN_PT_DETAILS';

751: p_debug_mode => l_debug_mode );
752: END IF;
753:
754: IF l_debug_mode = 'Y' THEN
755: pa_debug.g_err_stage:= 'Entering GET_WORKPLAN_PT_DETAILS';
756: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
757: END IF;
758:
759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 756: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

752: END IF;
753:
754: IF l_debug_mode = 'Y' THEN
755: pa_debug.g_err_stage:= 'Entering GET_WORKPLAN_PT_DETAILS';
756: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
757: END IF;
758:
759: x_return_status := FND_API.G_RET_STS_SUCCESS;
760:

Line 793: pa_debug.g_err_stage:= 'Leaving GET_WORKPLAN_PT_DETAILS';

789: END IF;
790:
791:
792: IF l_debug_mode = 'Y' THEN
793: pa_debug.g_err_stage:= 'Leaving GET_WORKPLAN_PT_DETAILS';
794: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
795: pa_debug.reset_curr_function;
796: END IF;
797:

Line 794: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

790:
791:
792: IF l_debug_mode = 'Y' THEN
793: pa_debug.g_err_stage:= 'Leaving GET_WORKPLAN_PT_DETAILS';
794: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
795: pa_debug.reset_curr_function;
796: END IF;
797:
798:

Line 795: pa_debug.reset_curr_function;

791:
792: IF l_debug_mode = 'Y' THEN
793: pa_debug.g_err_stage:= 'Leaving GET_WORKPLAN_PT_DETAILS';
794: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
795: pa_debug.reset_curr_function;
796: END IF;
797:
798:
799: EXCEPTION

Line 828: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

824: l_module_name VARCHAR2(100) := 'Is_Rev_Impl_Partially';
825:
826: BEGIN
827:
828: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
829:
830: pa_debug.set_curr_function( p_function => 'Is_Rev_Impl_Partially',
831: p_debug_mode => l_debug_mode );
832:

Line 830: pa_debug.set_curr_function( p_function => 'Is_Rev_Impl_Partially',

826: BEGIN
827:
828: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
829:
830: pa_debug.set_curr_function( p_function => 'Is_Rev_Impl_Partially',
831: p_debug_mode => l_debug_mode );
832:
833: IF l_debug_mode = 'Y' THEN
834: pa_debug.g_err_stage:= 'Entering Is_Rev_Impl_Partially';

Line 834: pa_debug.g_err_stage:= 'Entering Is_Rev_Impl_Partially';

830: pa_debug.set_curr_function( p_function => 'Is_Rev_Impl_Partially',
831: p_debug_mode => l_debug_mode );
832:
833: IF l_debug_mode = 'Y' THEN
834: pa_debug.g_err_stage:= 'Entering Is_Rev_Impl_Partially';
835: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
836: END IF;
837:
838: IF l_debug_mode = 'Y' THEN

Line 835: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

831: p_debug_mode => l_debug_mode );
832:
833: IF l_debug_mode = 'Y' THEN
834: pa_debug.g_err_stage:= 'Entering Is_Rev_Impl_Partially';
835: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
836: END IF;
837:
838: IF l_debug_mode = 'Y' THEN
839: pa_debug.g_err_stage:= 'The input Ci Id : ' || p_ci_id;

Line 839: pa_debug.g_err_stage:= 'The input Ci Id : ' || p_ci_id;

835: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
836: END IF;
837:
838: IF l_debug_mode = 'Y' THEN
839: pa_debug.g_err_stage:= 'The input Ci Id : ' || p_ci_id;
840: pa_debug.write(l_module_name,pa_debug.g_err_stage,
841: l_debug_level3);
842: END IF;
843: IF l_debug_mode = 'Y' THEN

Line 840: pa_debug.write(l_module_name,pa_debug.g_err_stage,

836: END IF;
837:
838: IF l_debug_mode = 'Y' THEN
839: pa_debug.g_err_stage:= 'The input Ci Id : ' || p_ci_id;
840: pa_debug.write(l_module_name,pa_debug.g_err_stage,
841: l_debug_level3);
842: END IF;
843: IF l_debug_mode = 'Y' THEN
844: pa_debug.g_err_stage:= 'The input Project Id : ' || p_project_id;

Line 844: pa_debug.g_err_stage:= 'The input Project Id : ' || p_project_id;

840: pa_debug.write(l_module_name,pa_debug.g_err_stage,
841: l_debug_level3);
842: END IF;
843: IF l_debug_mode = 'Y' THEN
844: pa_debug.g_err_stage:= 'The input Project Id : ' || p_project_id;
845: pa_debug.write(l_module_name,pa_debug.g_err_stage,
846: l_debug_level3);
847: END IF;
848:

Line 845: pa_debug.write(l_module_name,pa_debug.g_err_stage,

841: l_debug_level3);
842: END IF;
843: IF l_debug_mode = 'Y' THEN
844: pa_debug.g_err_stage:= 'The input Project Id : ' || p_project_id;
845: pa_debug.write(l_module_name,pa_debug.g_err_stage,
846: l_debug_level3);
847: END IF;
848:
849: BEGIN

Line 861: pa_debug.g_err_stage:= 'No Impact exists';

857: EXCEPTION
858: WHEN NO_DATA_FOUND THEN
859: l_rev_partial_impl_flag := 'N';
860: IF l_debug_mode = 'Y' THEN
861: pa_debug.g_err_stage:= 'No Impact exists';
862: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
863: END IF;
864:
865: pa_debug.reset_curr_function;

Line 862: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

858: WHEN NO_DATA_FOUND THEN
859: l_rev_partial_impl_flag := 'N';
860: IF l_debug_mode = 'Y' THEN
861: pa_debug.g_err_stage:= 'No Impact exists';
862: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
863: END IF;
864:
865: pa_debug.reset_curr_function;
866: RETURN l_rev_partial_impl_flag;

Line 865: pa_debug.reset_curr_function;

861: pa_debug.g_err_stage:= 'No Impact exists';
862: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
863: END IF;
864:
865: pa_debug.reset_curr_function;
866: RETURN l_rev_partial_impl_flag;
867: END;
868:
869: IF l_debug_mode = 'Y' THEN

Line 870: pa_debug.g_err_stage:= 'l_rev_partial_impl_flag is: ' || l_rev_partial_impl_flag;

866: RETURN l_rev_partial_impl_flag;
867: END;
868:
869: IF l_debug_mode = 'Y' THEN
870: pa_debug.g_err_stage:= 'l_rev_partial_impl_flag is: ' || l_rev_partial_impl_flag;
871: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
872: END IF;
873:
874: IF l_debug_mode = 'Y' THEN

Line 871: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

867: END;
868:
869: IF l_debug_mode = 'Y' THEN
870: pa_debug.g_err_stage:= 'l_rev_partial_impl_flag is: ' || l_rev_partial_impl_flag;
871: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
872: END IF;
873:
874: IF l_debug_mode = 'Y' THEN
875: pa_debug.g_err_stage:= 'Leaving Is_Rev_Impl_Partially';

Line 875: pa_debug.g_err_stage:= 'Leaving Is_Rev_Impl_Partially';

871: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
872: END IF;
873:
874: IF l_debug_mode = 'Y' THEN
875: pa_debug.g_err_stage:= 'Leaving Is_Rev_Impl_Partially';
876: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
877: END IF;
878: pa_debug.reset_curr_function;
879: RETURN l_rev_partial_impl_flag;

Line 876: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

872: END IF;
873:
874: IF l_debug_mode = 'Y' THEN
875: pa_debug.g_err_stage:= 'Leaving Is_Rev_Impl_Partially';
876: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
877: END IF;
878: pa_debug.reset_curr_function;
879: RETURN l_rev_partial_impl_flag;
880:

Line 878: pa_debug.reset_curr_function;

874: IF l_debug_mode = 'Y' THEN
875: pa_debug.g_err_stage:= 'Leaving Is_Rev_Impl_Partially';
876: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
877: END IF;
878: pa_debug.reset_curr_function;
879: RETURN l_rev_partial_impl_flag;
880:
881: EXCEPTION
882: WHEN OTHERS THEN

Line 884: pa_debug.g_err_stage:= 'Unexpected Error' || SQLERRM;

880:
881: EXCEPTION
882: WHEN OTHERS THEN
883: IF l_debug_mode = 'Y' THEN
884: pa_debug.g_err_stage:= 'Unexpected Error' || SQLERRM;
885: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
886: END IF;
887: pa_debug.reset_curr_function;
888: RAISE;

Line 885: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

881: EXCEPTION
882: WHEN OTHERS THEN
883: IF l_debug_mode = 'Y' THEN
884: pa_debug.g_err_stage:= 'Unexpected Error' || SQLERRM;
885: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
886: END IF;
887: pa_debug.reset_curr_function;
888: RAISE;
889:

Line 887: pa_debug.reset_curr_function;

883: IF l_debug_mode = 'Y' THEN
884: pa_debug.g_err_stage:= 'Unexpected Error' || SQLERRM;
885: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
886: END IF;
887: pa_debug.reset_curr_function;
888: RAISE;
889:
890:
891: END Is_Rev_Impl_Partially;