309:
310: X_err_stack := l_old_err_stack;
311:
312: Exception
313: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
314: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
315:
316: WHEN OTHERS THEN
317: pa_debug.debug('Error Procedure Name := PA_PURGE.PURGE_PROJECT' );
310: X_err_stack := l_old_err_stack;
311:
312: Exception
313: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
314: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
315:
316: WHEN OTHERS THEN
317: pa_debug.debug('Error Procedure Name := PA_PURGE.PURGE_PROJECT' );
318: pa_debug.debug('Error stage is '||x_err_stage );
317: pa_debug.debug('Error Procedure Name := PA_PURGE.PURGE_PROJECT' );
318: pa_debug.debug('Error stage is '||x_err_stage );
319: pa_debug.debug('Error stack is '||x_err_stack );
320: pa_debug.debug(SQLERRM);
321: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
322:
323: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
324:
325: End purge_project;
319: pa_debug.debug('Error stack is '||x_err_stack );
320: pa_debug.debug(SQLERRM);
321: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
322:
323: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
324:
325: End purge_project;
326:
327: -- Start of comments
505:
506:
507: Exception
508:
509: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
510: errbuf := PA_PROJECT_UTILS2.g_sqlerrm ;
511: ret_code := -1 ;
512: WHEN OTHERS THEN
513: errbuf := SQLERRM ;
506:
507: Exception
508:
509: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error THEN
510: errbuf := PA_PROJECT_UTILS2.g_sqlerrm ;
511: ret_code := -1 ;
512: WHEN OTHERS THEN
513: errbuf := SQLERRM ;
514: ret_code := -1 ;
726:
727: x_err_stack := l_old_err_stack;
728:
729: Exception
730: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
731: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
732:
733: WHEN OTHERS THEN
734: pa_debug.debug('Error Procedure Name := PA_PURGE.CommitProcess' );
727: x_err_stack := l_old_err_stack;
728:
729: Exception
730: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
731: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
732:
733: WHEN OTHERS THEN
734: pa_debug.debug('Error Procedure Name := PA_PURGE.CommitProcess' );
735: pa_debug.debug('Error stage is '||x_err_stage );
734: pa_debug.debug('Error Procedure Name := PA_PURGE.CommitProcess' );
735: pa_debug.debug('Error stage is '||x_err_stage );
736: pa_debug.debug('Error stack is '||x_err_stack );
737: pa_debug.debug(SQLERRM);
738: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
739:
740: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
741: end CommitProcess;
742:
736: pa_debug.debug('Error stack is '||x_err_stack );
737: pa_debug.debug(SQLERRM);
738: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
739:
740: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
741: end CommitProcess;
742:
743: -- Start of comments
744: -- API name : get_post_purge_status
855:
856: END IF;
857:
858: exception
859: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
860: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
861:
862: WHEN OTHERS THEN
863: pa_debug.debug('Error functio Name := PA_PURGE.get_post_purge_status ' );
856: END IF;
857:
858: exception
859: WHEN PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error then
860: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
861:
862: WHEN OTHERS THEN
863: pa_debug.debug('Error functio Name := PA_PURGE.get_post_purge_status ' );
864: pa_debug.debug(SQLERRM);
861:
862: WHEN OTHERS THEN
863: pa_debug.debug('Error functio Name := PA_PURGE.get_post_purge_status ' );
864: pa_debug.debug(SQLERRM);
865: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
866:
867: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
868:
869: end get_post_purge_status ;
863: pa_debug.debug('Error functio Name := PA_PURGE.get_post_purge_status ' );
864: pa_debug.debug(SQLERRM);
865: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
866:
867: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
868:
869: end get_post_purge_status ;
870:
871: end pa_purge ; /*Package Body*/