DBA Data[Home] [Help]

APPS.PA_PURGE_EXTN dependencies on PA_DEBUG

Line 98: -- pa_debug.debug('*-> About to purge Extn data ') ;

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.(p_purge_batch_id => p_purge_batch_id,
100: -- p_project_id => p_project_id,
101: -- p_txn_through_date => p_txn_through_date,
102: -- p_purge_release => p_purge_release,

Line 116: -- pa_debug.debug('*-> About to purge extn data ') ;

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.(p_purge_batch_id => p_purge_batch_id,
118: -- p_project_id => p_project_id,
119: -- p_txn_through_date => p_txn_through_date,
120: -- p_purge_release => p_purge_release,

Line 140: pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.PA_PURGE_CLIENT_EXTN' );

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 ;

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

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:

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

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 ;

Line 143: pa_debug.debug(SQLERRM);

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:

Line 327: -- pa_debug.debug('Error Procedure Name := PA_PURGE_EXTN.' );

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.' );
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 ;

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

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: --

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

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 ;

Line 330: -- pa_debug.debug(SQLERRM);

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: --