94: -- archived, 'N' if actuals are not being archived
95: -- The value can be changed before calling the
96: --
97: --
98: -- pa_debug.debug('*-> About to purge Extn data ') ;
99: -- pa_purge_extn.
100: -- p_project_id => p_project_id,
101: -- p_txn_through_date => p_txn_through_date,
102: -- p_purge_release => p_purge_release,
112: -- Call the procedure to purge the respective tables one after the
113: -- other. This section of the code is called after all the main
114: -- tables are purged in the current run.
115: --
116: -- pa_debug.debug('*-> About to purge extn data ') ;
117: -- pa_purge_extn.
118: -- p_project_id => p_project_id,
119: -- p_txn_through_date => p_txn_through_date,
120: -- p_purge_release => p_purge_release,
136: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
137:
138: WHEN OTHERS THEN
139: x_err_stage := l_err_stage ;
140: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_PURGE_CLIENT_EXTN' );
141: pa_debug.debug('Error stage is '||l_err_stage );
142: pa_debug.debug('Error stack is '||l_err_stack );
143: pa_debug.debug(SQLERRM);
144: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
137:
138: WHEN OTHERS THEN
139: x_err_stage := l_err_stage ;
140: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_PURGE_CLIENT_EXTN' );
141: pa_debug.debug('Error stage is '||l_err_stage );
142: pa_debug.debug('Error stack is '||l_err_stack );
143: pa_debug.debug(SQLERRM);
144: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
145:
138: WHEN OTHERS THEN
139: x_err_stage := l_err_stage ;
140: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_PURGE_CLIENT_EXTN' );
141: pa_debug.debug('Error stage is '||l_err_stage );
142: pa_debug.debug('Error stack is '||l_err_stack );
143: pa_debug.debug(SQLERRM);
144: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
145:
146: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
139: x_err_stage := l_err_stage ;
140: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_PURGE_CLIENT_EXTN' );
141: pa_debug.debug('Error stage is '||l_err_stage );
142: pa_debug.debug('Error stack is '||l_err_stack );
143: pa_debug.debug(SQLERRM);
144: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
145:
146: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
147:
323: -- RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
324: --
325: -- WHEN OTHERS THEN
326: -- x_err_stage := l_err_stage ;
327: -- pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.
329: -- pa_debug.debug('Error stack is '||l_err_stack );
330: -- pa_debug.debug(SQLERRM);
331: -- PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
324: --
325: -- WHEN OTHERS THEN
326: -- x_err_stage := l_err_stage ;
327: -- pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.
328: -- pa_debug.debug('Error stage is '||l_err_stage );
329: -- pa_debug.debug('Error stack is '||l_err_stack );
330: -- pa_debug.debug(SQLERRM);
331: -- PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
332: --
325: -- WHEN OTHERS THEN
326: -- x_err_stage := l_err_stage ;
327: -- pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.
328: -- pa_debug.debug('Error stage is '||l_err_stage );
329: -- pa_debug.debug('Error stack is '||l_err_stack );
330: -- pa_debug.debug(SQLERRM);
331: -- PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
332: --
333: -- RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
326: -- x_err_stage := l_err_stage ;
327: -- pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.
328: -- pa_debug.debug('Error stage is '||l_err_stage );
329: -- pa_debug.debug('Error stack is '||l_err_stack );
330: -- pa_debug.debug(SQLERRM);
331: -- PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
332: --
333: -- RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
334: --