DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_DEBUG

Line 418: pa_debug.debug(' -- Performing costing validation for project '||

414:
415: BEGIN
416: l_err_code := 0 ;
417: l_err_stack_old := x_err_stack;
418: pa_debug.debug(' -- Performing costing validation for project '||
419: to_char(p_project_id));
420: -- Check if there are expenditure items that are not Cost
421: -- Distributed
422:

Line 433: pa_debug.debug(' * Uncosted items exists for project '||

429:
430: l_err_stage := 'After open cursor IsCostDistributed' ;
431: l_err_stack := l_err_stack ||
432: ' ->After open cursor IsCostDistributed' ;
433: pa_debug.debug(' * Uncosted items exists for project '||
434: to_char(p_project_id));
435: End If;
436: close IsCostDistributed;
437: l_dummy := NULL;

Line 451: pa_debug.debug(' * Items that are not revenue generated exists for project '||to_char(p_project_id));

447: l_err_code := 10 ;
448:
449: l_err_stage := 'After open cursor IsTransImported' ;
450: l_err_stack := l_err_stack || ' ->After open cursor IsTransImported' ;
451: pa_debug.debug(' * Items that are not revenue generated exists for project '||to_char(p_project_id));
452: End If;
453: close IsTransImported;
454: l_dummy := NULL;
455:

Line 478: pa_debug.debug(' * Not all costs are transferred for the project '||to_char(p_project_id));

474: l_err_code := 10 ;
475:
476: l_err_stage := 'After transfer check' ;
477: l_err_stack := l_err_stack || ' ->After transfer check' ;
478: pa_debug.debug(' * Not all costs are transferred for the project '||to_char(p_project_id));
479: End If;
480: close IsInterfaced;
481:
482: /* Check if there are MRC CDLs that are not accepted in the other

Line 497: pa_debug.debug(' * Not all MRC costs are transferred for the project ' || to_char(p_project_id));

493: fnd_msg_pub.add;
494: l_err_code := 10 ;
495: l_err_stage := 'After transfer check' ;
496: l_err_stack := l_err_stack || ' ->After transfer check' ;
497: pa_debug.debug(' * Not all MRC costs are transferred for the project ' || to_char(p_project_id));
498: End If;
499: close IsMRCInterfaced;
500: */
501:

Line 523: pa_debug.debug(' * Not all costs are accumulated for the project '||to_char(p_project_id));

519: l_err_code := 10 ;
520:
521: l_err_stage := 'After resource accumulation check ' ;
522: l_err_stack := l_err_stack || ' ->After resource accumulation check ' ;
523: pa_debug.debug(' * Not all costs are accumulated for the project '||to_char(p_project_id));
524: End If;
525: close IsResAccumulated;
526: l_dummy := NULL;
527:

Line 540: pa_debug.debug(' * Not all costs are burden distributed for project '||to_char(p_project_id));

536: l_err_code := 10 ;
537:
538: l_err_stage := 'After Burden Cost Dist. check ' ;
539: l_err_stack := l_err_stack || ' ->After Burden Cost Dist. check ' ;
540: pa_debug.debug(' * Not all costs are burden distributed for project '||to_char(p_project_id));
541: End If;
542: close IsBurdenDistributed;
543: l_dummy := NULL;
544: */

Line 557: pa_debug.debug(' * Intercompany transactions exists for the project '||to_char(p_project_id));

553: fnd_msg_pub.add;
554: l_err_code := 10;
555: l_err_stage := 'After intercompany check ';
556: l_err_stack := l_err_stack|| ' -> After intercompany check';
557: pa_debug.debug(' * Intercompany transactions exists for the project '||to_char(p_project_id));
558: End If;
559: Close IsIntercompany;
560: l_dummy := NULL;
561: */

Line 573: pa_debug.debug(' * Eligible Borrowed and Lent EIs are not BL distributed for project '||to_char(p_project_id));

569: fnd_msg_pub.add;
570: l_err_code := 10;
571: l_err_stage := 'After Borrowed and Lent Dist check ';
572: l_err_stack := l_err_stack|| ' -> After Borrwed and Lent Dist Check ';
573: pa_debug.debug(' * Eligible Borrowed and Lent EIs are not BL distributed for project '||to_char(p_project_id));
574: End If;
575: Close IsBorrLentDistributed;
576: l_dummy := NULL;
577:

Line 588: pa_debug.debug(' * Not all BL costs are transferred for the project '||to_char(p_project_id));

584: fnd_msg_pub.add;
585: l_err_code := 10 ;
586: l_err_stage := 'After BL transfer check' ;
587: l_err_stack := l_err_stack || ' ->After BL transfer check' ;
588: pa_debug.debug(' * Not all BL costs are transferred for the project '||to_char(p_project_id));
589: End If;
590: Close IsCCDLInterfaced;
591: l_dummy := NULL;
592:

Line 603: pa_debug.debug(' * The project '||to_char(p_project_id)||' is defined as a destination project in project type check ');

599: fnd_msg_pub.add;
600: l_err_code := 10 ;
601: l_err_stage := 'After destination project in project type check' ;
602: l_err_stack := l_err_stack || ' ->After destination project in project type check' ;
603: pa_debug.debug(' * The project '||to_char(p_project_id)||' is defined as a destination project in project type check ');
604: End If;
605: Close IsDestProjectType;
606: l_dummy := NULL;
607:

Line 628: pa_debug.debug(' * OTL records exists for the project '||to_char(p_project_id));

624: fnd_msg_pub.add;
625: l_err_code := 10;
626: l_err_stage := 'After OTL check' ;
627: l_err_stack := l_err_stack || ' ->After OTL check' ;
628: pa_debug.debug(' * OTL records exists for the project '||to_char(p_project_id));
629: END IF;
630:
631: pa_debug.debug(' -- Performing Allocations validation for project '||
632: to_char(p_project_id));

Line 631: pa_debug.debug(' -- Performing Allocations validation for project '||

627: l_err_stack := l_err_stack || ' ->After OTL check' ;
628: pa_debug.debug(' * OTL records exists for the project '||to_char(p_project_id));
629: END IF;
630:
631: pa_debug.debug(' -- Performing Allocations validation for project '||
632: to_char(p_project_id));
633:
634: pa_purge_validate_costing.Validate_Allocations(p_proj_id => p_project_id,
635: x_source => l_source_project,

Line 646: pa_debug.debug(' * There exists a rule with run status not as RS which contains

642:
643: l_err_stage := 'After checking for source project' ;
644: l_err_stack := l_err_stack ||
645: ' ->After checking for source project' ;
646: pa_debug.debug(' * There exists a rule with run status not as RS which contains
647: the project '||to_char(p_project_id)|| 'as source project');
648: END IF;
649:
650: IF l_target_project = 1 THEN

Line 658: pa_debug.debug(' * There exists a rule with run status not as RS which contains

654:
655: l_err_stage := 'After checking for tartget project' ;
656: l_err_stack := l_err_stack ||
657: ' ->After checking for target project' ;
658: pa_debug.debug(' * There exists a rule with run status not as RS which contains
659: the project '||to_char(p_project_id)|| 'as target project');
660: END IF;
661:
662: IF l_offset_project = 1 THEN

Line 670: pa_debug.debug(' * There exists a rule with run status not as RS which contains

666:
667: l_err_stage := 'After checking for offset project' ;
668: l_err_stack := l_err_stack ||
669: ' ->After checking for offset project' ;
670: pa_debug.debug(' * There exists a rule with run status not as RS which contains
671: the project '||to_char(p_project_id)|| 'as offset project');
672: END IF;
673:
674: /* checking for the project in property manager */

Line 683: pa_debug.debug(' * The project '||to_char(p_project_id)|| 'is in use by Property Manager module');

679:
680: l_err_stage := 'After checking for the project in property manager';
681: l_err_stack := l_err_stack ||
682: ' ->After checking for the project in property manager';
683: pa_debug.debug(' * The project '||to_char(p_project_id)|| 'is in use by Property Manager module');
684: END IF;
685:
686:
687: /* checking for the project in contract commitments */

Line 698: pa_debug.debug(' * The project '||to_char(p_project_id)|| 'is in use by Contract Commitments');

694:
695: l_err_stage := 'After checking for the project in contract commitments';
696: l_err_stack := l_err_stack ||
697: ' ->After checking for the project in contract commitments';
698: pa_debug.debug(' * The project '||to_char(p_project_id)|| 'is in use by Contract Commitments');
699: END IF;
700: */
701:
702: /* checking for the project in contract commitments */

Line 735: pa_debug.debug(' * The project '||to_char(p_project_id)|| 'is in use by Contract Commitments');

731:
732: l_err_stage := 'After checking for the project in contract commitments';
733: l_err_stack := l_err_stack ||
734: ' ->After checking for the project in contract commitments';
735: pa_debug.debug(' * The project '||to_char(p_project_id)|| 'is in use by Contract Commitments');
736: END IF;
737:
738: END IF;
739: -- Check supplier invoices eligible for discounts are fully paid.

Line 749: pa_debug.debug(' * Supplier invoice eligible for discount not fully paid for project '||to_char(p_project_id));

745: fnd_msg_pub.add;
746: l_err_code := 10 ;
747: l_err_stage := 'After VI discount check' ;
748: l_err_stack := l_err_stack || ' ->After VI discount check' ;
749: pa_debug.debug(' * Supplier invoice eligible for discount not fully paid for project '||to_char(p_project_id));
750: End If;
751: Close IsVIPaymentPendg;
752: l_dummy := NULL;
753:

Line 763: pa_debug.debug(' * This is an inter-project receiver project');

759: fnd_msg_pub.add;
760: l_err_code := 10 ;
761: l_err_stage := 'After IP receiver project check' ;
762: l_err_stack := l_err_stack || ' ->After IP receiver project check' ;
763: pa_debug.debug(' * This is an inter-project receiver project');
764: End If;
765: Close ISInterPrjRecvPrj;
766: l_dummy := NULL;
767: */

Line 776: pa_debug.debug(' * Supplier invoice discount lines not interfaced');

772: fnd_msg_pub.add;
773: l_err_code := 10 ;
774: l_err_stage := 'After Vendor invoice discount interface check' ;
775: l_err_stack := l_err_stack || ' ->After Vendor invoice discount interface check' ;
776: pa_debug.debug(' * Supplier invoice discount lines not interfaced');
777: End If;
778: Close ISDistLinesIntfed;
779: l_dummy := NULL;
780:

Line 789: pa_debug.debug(' * This is an organization forecast project');

785: fnd_msg_pub.add;
786: l_err_code := 10 ;
787: l_err_stage := 'After organization forecast project check' ;
788: l_err_stack := l_err_stack || ' ->After organization forecast project check' ;
789: pa_debug.debug(' * This is an organization forecast project');
790: End If;
791: Close ISOrgForecastProject;
792: l_dummy := NULL;
793:

Line 802: pa_debug.debug(' * This is an unassigned time project');

798: fnd_msg_pub.add;
799: l_err_code := 10 ;
800: l_err_stage := 'After Unassigned Time project type check' ;
801: l_err_stack := l_err_stack || ' ->After Unassigned Time project type check' ;
802: pa_debug.debug(' * This is an unassigned time project');
803: End If;
804: Close IsUnassignedTimeType;
805: l_dummy := NULL;
806:

Line 840: pa_debug.debug(' * Project related Iexpense transactions are yet to be imported to projects');

836: fnd_msg_pub.add;
837: l_err_code := 10 ;
838: l_err_stage := 'After Iexpense transactions transfer check' ;
839: l_err_stack := l_err_stack || ' ->After Iexpense transactions transfer check' ;
840: pa_debug.debug(' * Project related Iexpense transactions are yet to be imported to projects');
841: END IF;
842:
843: DBMS_SQL.CLOSE_CURSOR(V_CursorID);
844: END IF;

Line 855: pa_debug.debug(' * Project related Iexpense transactions are yet to be imported to projects');

851: fnd_msg_pub.add;
852: l_err_code := 10 ;
853: l_err_stage := 'After Iexpense transactions transfer check' ;
854: l_err_stack := l_err_stack || ' ->After Iexpense transactions transfer check' ;
855: pa_debug.debug(' * Project related Iexpense transactions are yet to be imported to projects');
856: End If;
857: Close IsIexpenseTxnsPending;
858: l_dummy := NULL;
859:

Line 868: pa_debug.debug(' * Expense reports are yet to be paid for the project '||to_char(p_project_id));

864: fnd_msg_pub.add;
865: l_err_code := 10 ;
866: l_err_stage := 'After ER Payment check' ;
867: l_err_stack := l_err_stack || ' ->After ER Payment check' ;
868: pa_debug.debug(' * Expense reports are yet to be paid for the project '||to_char(p_project_id));
869: End If;
870: Close IsERPaymentPendg;
871: l_dummy := NULL;
872:

Line 883: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );

879: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
880:
881: WHEN OTHERS THEN
882: x_err_stage := l_err_stage ;
883: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
884: pa_debug.debug('Error stage is '||l_err_stage );
885: pa_debug.debug('Error stack is '||l_err_stack );
886: pa_debug.debug(SQLERRM);
887: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

Line 884: pa_debug.debug('Error stage is '||l_err_stage );

880:
881: WHEN OTHERS THEN
882: x_err_stage := l_err_stage ;
883: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
884: pa_debug.debug('Error stage is '||l_err_stage );
885: pa_debug.debug('Error stack is '||l_err_stack );
886: pa_debug.debug(SQLERRM);
887: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
888:

Line 885: pa_debug.debug('Error stack is '||l_err_stack );

881: WHEN OTHERS THEN
882: x_err_stage := l_err_stage ;
883: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
884: pa_debug.debug('Error stage is '||l_err_stage );
885: pa_debug.debug('Error stack is '||l_err_stack );
886: pa_debug.debug(SQLERRM);
887: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
888:
889: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 886: pa_debug.debug(SQLERRM);

882: x_err_stage := l_err_stage ;
883: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_COSTING.VALIDATE_COSTING' );
884: pa_debug.debug('Error stage is '||l_err_stage );
885: pa_debug.debug('Error stack is '||l_err_stack );
886: pa_debug.debug(SQLERRM);
887: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
888:
889: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
890: