443: END IF;
444:
445: pa_debug.debug('Calling validate process for costing for project '||to_char(X_project_id));
446: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
447: pa_purge_validate_costing.validate_costing(p_project_id => X_project_id,
448: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
449: p_active_flag => pa_purge_validate.g_active_flag,
450: x_err_code => x_err_code,
451: x_err_stack => x_err_stack,
444:
445: pa_debug.debug('Calling validate process for costing for project '||to_char(X_project_id));
446: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
447: pa_purge_validate_costing.validate_costing(p_project_id => X_project_id,
448: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
449: p_active_flag => pa_purge_validate.g_active_flag,
450: x_err_code => x_err_code,
451: x_err_stack => x_err_stack,
452: x_err_stage => x_err_stage
445: pa_debug.debug('Calling validate process for costing for project '||to_char(X_project_id));
446: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
447: pa_purge_validate_costing.validate_costing(p_project_id => X_project_id,
448: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
449: p_active_flag => pa_purge_validate.g_active_flag,
450: x_err_code => x_err_code,
451: x_err_stack => x_err_stack,
452: x_err_stage => x_err_stage
453: );
451: x_err_stack => x_err_stack,
452: x_err_stage => x_err_stage
453: );
454:
455: if pa_purge_validate.g_project_type_class_code = 'CONTRACT' then
456:
457: pa_debug.debug('Calling validate process for billing for project '||to_char(X_project_id));
458: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
459: pa_purge_validate_billing.validate_billing(p_project_id => X_project_id,
455: if pa_purge_validate.g_project_type_class_code = 'CONTRACT' then
456:
457: pa_debug.debug('Calling validate process for billing for project '||to_char(X_project_id));
458: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
459: pa_purge_validate_billing.validate_billing(p_project_id => X_project_id,
460: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
461: p_active_flag => pa_purge_validate.g_active_flag,
462: x_err_code => x_err_code,
463: x_err_stack => x_err_stack,
456:
457: pa_debug.debug('Calling validate process for billing for project '||to_char(X_project_id));
458: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
459: pa_purge_validate_billing.validate_billing(p_project_id => X_project_id,
460: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
461: p_active_flag => pa_purge_validate.g_active_flag,
462: x_err_code => x_err_code,
463: x_err_stack => x_err_stack,
464: x_err_stage => x_err_stage
457: pa_debug.debug('Calling validate process for billing for project '||to_char(X_project_id));
458: x_err_stage := 'Calling validate process for billing for project '||to_char(X_project_id);
459: pa_purge_validate_billing.validate_billing(p_project_id => X_project_id,
460: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
461: p_active_flag => pa_purge_validate.g_active_flag,
462: x_err_code => x_err_code,
463: x_err_stack => x_err_stack,
464: x_err_stage => x_err_stage
465: );
467:
468: pa_debug.debug('Calling validate process for capital for project '||to_char(X_project_id));
469:
470: x_err_stage := 'Calling validate process for capital for project '||to_char(X_project_id);
471: pa_purge_validate_capital.validate_capital( p_project_id => X_project_id,
472: p_purge_to_date => pa_purge_validate.g_txn_to_date ,
473: p_active_flag => pa_purge_validate.g_active_flag,
474: p_err_code => x_err_code,
475: p_err_stack => x_err_stack,
468: pa_debug.debug('Calling validate process for capital for project '||to_char(X_project_id));
469:
470: x_err_stage := 'Calling validate process for capital for project '||to_char(X_project_id);
471: pa_purge_validate_capital.validate_capital( p_project_id => X_project_id,
472: p_purge_to_date => pa_purge_validate.g_txn_to_date ,
473: p_active_flag => pa_purge_validate.g_active_flag,
474: p_err_code => x_err_code,
475: p_err_stack => x_err_stack,
476: p_err_stage => x_err_stage
469:
470: x_err_stage := 'Calling validate process for capital for project '||to_char(X_project_id);
471: pa_purge_validate_capital.validate_capital( p_project_id => X_project_id,
472: p_purge_to_date => pa_purge_validate.g_txn_to_date ,
473: p_active_flag => pa_purge_validate.g_active_flag,
474: p_err_code => x_err_code,
475: p_err_stack => x_err_stack,
476: p_err_stage => x_err_stage
477: );
479: pa_debug.debug('Calling validate process for PJRM for project '||to_char(X_project_id));
480:
481: x_err_stage := 'Calling validate process for PJRM for project '||to_char(X_project_id);
482:
483: pa_purge_validate_pjrm.validate_requirement (p_project_id => X_project_id,
484: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
485: p_active_flag => pa_purge_validate.g_active_flag,
486: x_err_code => x_err_code,
487: x_err_stack => x_err_stack,
480:
481: x_err_stage := 'Calling validate process for PJRM for project '||to_char(X_project_id);
482:
483: pa_purge_validate_pjrm.validate_requirement (p_project_id => X_project_id,
484: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
485: p_active_flag => pa_purge_validate.g_active_flag,
486: x_err_code => x_err_code,
487: x_err_stack => x_err_stack,
488: x_err_stage => x_err_stage
481: x_err_stage := 'Calling validate process for PJRM for project '||to_char(X_project_id);
482:
483: pa_purge_validate_pjrm.validate_requirement (p_project_id => X_project_id,
484: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
485: p_active_flag => pa_purge_validate.g_active_flag,
486: x_err_code => x_err_code,
487: x_err_stack => x_err_stack,
488: x_err_stage => x_err_stage
489: );
487: x_err_stack => x_err_stack,
488: x_err_stage => x_err_stage
489: );
490:
491: pa_purge_validate_pjrm.validate_assignment (p_project_id => X_project_id,
492: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
493: p_active_flag => pa_purge_validate.g_active_flag,
494: x_err_code => x_err_code,
495: x_err_stack => x_err_stack,
488: x_err_stage => x_err_stage
489: );
490:
491: pa_purge_validate_pjrm.validate_assignment (p_project_id => X_project_id,
492: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
493: p_active_flag => pa_purge_validate.g_active_flag,
494: x_err_code => x_err_code,
495: x_err_stack => x_err_stack,
496: x_err_stage => x_err_stage
489: );
490:
491: pa_purge_validate_pjrm.validate_assignment (p_project_id => X_project_id,
492: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
493: p_active_flag => pa_purge_validate.g_active_flag,
494: x_err_code => x_err_code,
495: x_err_stack => x_err_stack,
496: x_err_stage => x_err_stage
497: );
499: /* Bug#2416385 Code added for phase III of archive and Purge, starts here */
500:
501: pa_debug.debug('Calling validate process for IC and IP Billing for project '||to_char(X_project_id));
502: x_err_stage := 'Calling validate process for IC and IP Billing for project '||to_char(X_project_id);
503: pa_purge_validate_icip.validate_IC_IP(p_project_id => X_project_id,
504: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
505: p_active_flag => pa_purge_validate.g_active_flag,
506: x_err_code => x_err_code,
507: x_err_stack => x_err_stack,
500:
501: pa_debug.debug('Calling validate process for IC and IP Billing for project '||to_char(X_project_id));
502: x_err_stage := 'Calling validate process for IC and IP Billing for project '||to_char(X_project_id);
503: pa_purge_validate_icip.validate_IC_IP(p_project_id => X_project_id,
504: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
505: p_active_flag => pa_purge_validate.g_active_flag,
506: x_err_code => x_err_code,
507: x_err_stack => x_err_stack,
508: x_err_stage => x_err_stage
501: pa_debug.debug('Calling validate process for IC and IP Billing for project '||to_char(X_project_id));
502: x_err_stage := 'Calling validate process for IC and IP Billing for project '||to_char(X_project_id);
503: pa_purge_validate_icip.validate_IC_IP(p_project_id => X_project_id,
504: p_txn_to_date => pa_purge_validate.g_txn_to_date ,
505: p_active_flag => pa_purge_validate.g_active_flag,
506: x_err_code => x_err_code,
507: x_err_stack => x_err_stack,
508: x_err_stage => x_err_stage
509: );
510:
511: /* Bug#2416385 Code added for phase III of archive and Purge, ends here */
512:
513: /* Code changes for Bug 2962582 starts here */
514: pa_purge_validate_pjrm.Validate_PJI(p_project_id => x_project_id,
515: p_project_end_date => x_project_end_date,
516: x_err_code => x_err_code,
517: x_err_stack => x_err_stack,
518: x_err_stage => x_err_stage
521: /* Code changes for Bug 2962582 ends here */
522:
523:
524: /* Code changes for Bug 4255353 starts here */
525: pa_purge_validate_pjrm.Validate_Perf_reporting(p_project_id => x_project_id,
526: x_err_code => x_err_code,
527: x_err_stack => x_err_stack,
528: x_err_stage => x_err_stage
529: );
535: pa_debug.debug('Calling validate process for client extn for project '||to_char(X_project_id));
536:
537: x_err_stage := 'Calling validate process for client extn for project '||to_char(X_project_id);
538: pa_purge_extn_validate.validate_extn( p_project_id => X_project_id,
539: p_txn_through_date => pa_purge_validate.g_txn_to_date ,
540: p_active_flag => pa_purge_validate.g_active_flag,
541: x_err_code => x_err_code,
542: x_err_stack => x_err_stack,
543: x_err_stage => x_err_stage
536:
537: x_err_stage := 'Calling validate process for client extn for project '||to_char(X_project_id);
538: pa_purge_extn_validate.validate_extn( p_project_id => X_project_id,
539: p_txn_through_date => pa_purge_validate.g_txn_to_date ,
540: p_active_flag => pa_purge_validate.g_active_flag,
541: x_err_code => x_err_code,
542: x_err_stack => x_err_stack,
543: x_err_stage => x_err_stage
544: );