DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE dependencies on PA_PROJECT_UTILS2

Line 183: pa_project_utils2.validate_attribute_change(

179: -- Call the validation procedure
180:
181: if l_GetProjectsInBatch_csr.last_project_status_code <> 'PARTIALLY_PURGED' then
182:
183: pa_project_utils2.validate_attribute_change(
184: x_Context => 'ARCHIVE_PURGE'
185: , x_Insert_Update_Mode => NULL
186: , x_Calling_Module => NULL
187: , x_project_id => l_GetProjectsInBatch_csr.project_id

Line 332: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN

328:
329: commit ;
330:
331: EXCEPTION
332: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
333: errbuf := PA_PROJECT_UTILS2.g_sqlerrm ;
334: ret_code := -1 ;
335: WHEN OTHERS THEN
336: errbuf := SQLERRM ;

Line 333: errbuf := PA_PROJECT_UTILS2.g_sqlerrm ;

329: commit ;
330:
331: EXCEPTION
332: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
333: errbuf := PA_PROJECT_UTILS2.g_sqlerrm ;
334: ret_code := -1 ;
335: WHEN OTHERS THEN
336: errbuf := SQLERRM ;
337: ret_code := -1 ;

Line 507: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then

503:
504: x_err_stack := l_err_stack_old ;
505:
506: EXCEPTION
507: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
508: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
509:
510: WHEN OTHERS THEN
511: -- x_err_stage := l_err_stage ;

Line 508: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

504: x_err_stack := l_err_stack_old ;
505:
506: EXCEPTION
507: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
508: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
509:
510: WHEN OTHERS THEN
511: -- x_err_stage := l_err_stage ;
512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );

Line 516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

512: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE.INSERT_ERRORS' );
513: pa_debug.debug('Error stage is '||x_err_stage );
514: pa_debug.debug('Error stack is '||x_err_stack );
515: pa_debug.debug(SQLERRM);
516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
517:
518: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
519:
520: END insert_errors ;

Line 518: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

514: pa_debug.debug('Error stack is '||x_err_stack );
515: pa_debug.debug(SQLERRM);
516: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
517:
518: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
519:
520: END insert_errors ;
521:
522: END pa_purge_validate;