DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_DEBUG

Line 208: pa_debug.debug('-- Performing Capital validation for the project '||to_char(p_project_id));

204: l_err_code := 0;
205: l_err_stage := p_err_stage;
206: l_err_stack := p_err_stack;
207:
208: pa_debug.debug('-- Performing Capital validation for the project '||to_char(p_project_id));
209:
210: /* Bug#2429757 Commented out this cursor as this is generating a similar validation
211: error message like the cursor IsCommitmentExist */
212:

Line 236: pa_debug.debug(' *Pending vendor invoices exist for project '||to_char(p_project_id));

232: l_err_code := 10;
233:
234: l_err_stage := 'After Open Cursor IsVenInvPending';
235: l_err_stack := l_err_stack||'->After Open Cursor IsVenInvPending';
236: pa_debug.debug(' *Pending vendor invoices exist for project '||to_char(p_project_id));
237:
238: End IF;
239:
240: l_exc_err_stage := 'Closing Cursor IsVenInvPending';

Line 245: pa_debug.debug('Capital validation -- After Cursor IsVenInvPending');

241:
242: Close IsVenInvPending;
243: l_dummy := NULL;
244:
245: pa_debug.debug('Capital validation -- After Cursor IsVenInvPending');
246:
247: -- Check if there are any Expenditure items for this project which are not Capitalized
248:
249: if pa_purge_validate.g_project_type_class_code = 'CAPITAL' then /* Bug#2387342 */

Line 268: pa_debug.debug(' *UnCapitalized Expenditure Items exist for project '||to_char(p_project_id));

264: l_err_code := 10;
265:
266: l_err_stage := 'After Open Cursor IsEiNotCapitalized';
267: l_err_stack := l_err_stack||'->After Open Cursor IsEiNotCapitalized';
268: pa_debug.debug(' *UnCapitalized Expenditure Items exist for project '||to_char(p_project_id));
269:
270: End IF;
271:
272: l_exc_err_stage := 'Closing Cursor IsEiNotCapitalized';

Line 277: pa_debug.debug('Capital validation -- After Cursor IsEiNotCapitalized');

273:
274: Close IsEiNotCapitalized;
275: l_dummy := NULL;
276:
277: pa_debug.debug('Capital validation -- After Cursor IsEiNotCapitalized');
278:
279: end if;
280:
281: -- Check if there are any Adjustments for this project which are not Transferred to AP

Line 299: pa_debug.debug(' *Pending vendor invoice adjustments exist for project '||to_char(p_project_id));

295: l_err_code := 10;
296:
297: l_err_stage := 'After Open Cursor IsAdjNotXferToAP';
298: l_err_stack := l_err_stack||'->After Open Cursor IsAdjNotXferToAP';
299: pa_debug.debug(' *Pending vendor invoice adjustments exist for project '||to_char(p_project_id));
300:
301: End IF;
302:
303: l_exc_err_stage := 'Closing Cursor IsAdjNotXferToAP';

Line 308: pa_debug.debug('Capital validation -- After Cursor IsAdjNotXferToAP');

304:
305: Close IsAdjNotXferToAP;
306: l_dummy := NULL;
307:
308: pa_debug.debug('Capital validation -- After Cursor IsAdjNotXferToAP');
309:
310: -- Check if there are any Expenditure items for this project which are not Costed
311:
312: /******************************

Line 329: pa_debug.debug(' *Uncosted Expenditure items exist for project '||to_char(p_project_id));

325: l_err_code := 10;
326:
327: l_err_stage := 'After Open Cursor IsEiNotCosted';
328: l_err_stack := l_err_stack||'->After Open Cursor IsEiNotCosted';
329: pa_debug.debug(' *Uncosted Expenditure items exist for project '||to_char(p_project_id));
330:
331: End IF;
332:
333: l_exc_err_stage := 'Closing Cursor IsEiNotCosted';

Line 338: pa_debug.debug('Capital validation -- After Cursor IsEiNotCosted');

334:
335: Close IsEiNotCosted;
336: l_dummy := NULL;
337:
338: pa_debug.debug('Capital validation -- After Cursor IsEiNotCosted');
339:
340: ********************************/
341: /* IF ( (g_purge_capital_flag = 'Y') AND Commented for Bug 2786753 */
342:

Line 363: pa_debug.debug(' *Unamortized Asset Lines exist for project '||to_char(p_project_id));

359: l_err_code := 10;
360:
361: l_err_stage := 'After Open Cursor IsAstLinNotXferred';
362: l_err_stack := l_err_stack||'->After Open Cursor IsAstLinNotXferred';
363: pa_debug.debug(' *Unamortized Asset Lines exist for project '||to_char(p_project_id));
364:
365: End IF;
366:
367: l_exc_err_stage := 'Closing Cursor IsAstLinNotXferred';

Line 372: pa_debug.debug('Capital validation -- After Cursor IsAstLinNotXferred');

368:
369: Close IsAstLinNotXferred;
370: l_dummy := NULL;
371:
372: pa_debug.debug('Capital validation -- After Cursor IsAstLinNotXferred');
373:
374: End IF;
375:
376: Open IsCommitmentExist;

Line 391: pa_debug.debug(' *Commitments exist for project '||to_char(p_project_id));

387: l_err_code := 10;
388:
389: l_err_stage := 'After Open Cursor IsCommitmentExist';
390: l_err_stack := l_err_stack||'->After Open Cursor IsCommitmentExist';
391: pa_debug.debug(' *Commitments exist for project '||to_char(p_project_id));
392:
393: End IF;
394:
395: l_exc_err_stage := 'Closing Cursor IsCommitmentExist';

Line 400: pa_debug.debug('Capital validation -- After Cursor IsCommitmentExist');

396:
397: Close IsCommitmentExist;
398: l_dummy := NULL;
399:
400: pa_debug.debug('Capital validation -- After Cursor IsCommitmentExist');
401:
402: p_err_code := l_err_code;
403: p_err_stage := l_err_stage;
404: p_err_stack := l_err_stack;