DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_DEBUG

Line 252: pa_debug.debug('-- Performing Billing validation for project '||to_char(p_project_id));

248: BEGIN
249: l_err_code := 0 ;
250: l_err_stage := x_err_stage;
251: l_err_stack := x_err_stack;
252: pa_debug.debug('-- Performing Billing validation for project '||to_char(p_project_id));
253:
254: -- Open cursor
255: -- If cursor returns one or more rows , indicates that
256: -- project is not valid for purge as far as billing is concerned

Line 265: pa_debug.debug('-- After Open cursor IsBillingValid');

261: WHERE je_source_name='Project Accounting';
262:
263: Open IsBillingValid(l_user_source_name) ;
264:
265: pa_debug.debug('-- After Open cursor IsBillingValid');
266:
267: LOOP
268:
269: -- Fetch a row for each validation that failed

Line 277: pa_debug.debug(' * ' || l_dummy|| ' for ' || to_char(p_project_id));

273: Exit When IsBillingValid%Notfound;
274: fnd_message.set_name('PA',l_msg_name );
275: fnd_msg_pub.add;
276: l_err_stack := l_err_stack || ' ->After open cursor ' ||l_dummy ;
277: pa_debug.debug(' * ' || l_dummy|| ' for ' || to_char(p_project_id));
278:
279:
280: END LOOP;
281:

Line 286: pa_debug.debug('-- Before call to check usage by OKE');

282: close IsBillingValid;
283:
284: --Check to see if any projects are in use by contract integration system.
285:
286: pa_debug.debug('-- Before call to check usage by OKE');
287:
288: l_used_by_oke := OKE_DTS_PA_PKG.Project_Exist(p_project_id);
289:
290: IF l_used_by_oke

Line 296: pa_debug.debug(' * This project '||to_char(p_project_id)||' is in use by OKE ');

292: fnd_message.set_name('PA','PA_ARPR_PROJ_INUSE_CNTRCT_INT');
293: fnd_msg_pub.add;
294: l_err_stage := 'After OKE check';
295: l_err_stack := l_err_stack || ' ->After OKE check' ;
296: pa_debug.debug(' * This project '||to_char(p_project_id)||' is in use by OKE ');
297: END IF;
298:
299: pa_debug.debug('-- After call to check usage by OKE');
300:

Line 299: pa_debug.debug('-- After call to check usage by OKE');

295: l_err_stack := l_err_stack || ' ->After OKE check' ;
296: pa_debug.debug(' * This project '||to_char(p_project_id)||' is in use by OKE ');
297: END IF;
298:
299: pa_debug.debug('-- After call to check usage by OKE');
300:
301: x_err_stage := l_err_stage ;
302: x_err_stack := l_err_stack ;
303:

Line 316: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_BILLING.VALIDATE_BILLING' );

312:
313: x_err_stack := l_err_stack;
314:
315:
316: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_BILLING.VALIDATE_BILLING' );
317: pa_debug.debug('Error stage is '||l_err_stage );
318: pa_debug.debug('Error stack is '||l_err_stack );
319: pa_debug.debug(SQLERRM);
320: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;

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

313: x_err_stack := l_err_stack;
314:
315:
316: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_BILLING.VALIDATE_BILLING' );
317: pa_debug.debug('Error stage is '||l_err_stage );
318: pa_debug.debug('Error stack is '||l_err_stack );
319: pa_debug.debug(SQLERRM);
320: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
321:

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

314:
315:
316: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_BILLING.VALIDATE_BILLING' );
317: pa_debug.debug('Error stage is '||l_err_stage );
318: pa_debug.debug('Error stack is '||l_err_stack );
319: pa_debug.debug(SQLERRM);
320: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
321:
322: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;

Line 319: pa_debug.debug(SQLERRM);

315:
316: pa_debug.debug('Error Procedure Name := PA_PURGE_VALIDATE_BILLING.VALIDATE_BILLING' );
317: pa_debug.debug('Error stage is '||l_err_stage );
318: pa_debug.debug('Error stack is '||l_err_stack );
319: pa_debug.debug(SQLERRM);
320: PA_PROJECT_UTILS2.g_sqlerrm := SQLERRM ;
321:
322: RAISE PA_PROJECT_UTILS2.PA_Arch_Pur_Subroutine_Error ;
323: