DBA Data[Home] [Help]

APPS.ARP_PROCESS_MISC_RECEIPTS2 dependencies on ARP_STANDARD

Line 120: arp_standard.debug('arp_process_misc_receipts2.lock_misc_receipt()+');

116:
117: BEGIN
118:
119: IF PG_DEBUG in ('Y', 'C') THEN
120: arp_standard.debug('arp_process_misc_receipts2.lock_misc_receipt()+');
121: END IF;
122:
123: arp_cash_receipts_pkg.set_to_dummy(l_cr_rec);
124:

Line 251: arp_standard.debug('arp_process_misc_receipts2.delete_misc_receipt()+');

247: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
248: l_dist_cnt NUMBER; --bug5655154
249: BEGIN
250: IF PG_DEBUG in ('Y', 'C') THEN
251: arp_standard.debug('arp_process_misc_receipts2.delete_misc_receipt()+');
252: END IF;
253:
254: -- lock receipt record to make sure no one else has it locked
255:

Line 260: select arp_standard.sysparm.accounting_method into l_accounting_method from dual;

256: arp_cash_receipts_pkg.lock_p(p_cash_receipt_id);
257:
258: -- Bug 2189383
259: -- Get the accounting method
260: select arp_standard.sysparm.accounting_method into l_accounting_method from dual;
261:
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_standard.debug('delete_misc_receipt: ' || 'Acconting Method = '|| l_accounting_method);
264: END IF;

Line 263: arp_standard.debug('delete_misc_receipt: ' || 'Acconting Method = '|| l_accounting_method);

259: -- Get the accounting method
260: select arp_standard.sysparm.accounting_method into l_accounting_method from dual;
261:
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_standard.debug('delete_misc_receipt: ' || 'Acconting Method = '|| l_accounting_method);
264: END IF;
265:
266: -- VAT: AR_DISTRIBUTION accounting entry records needs to be deleted
267: -- before deleting AR_CASH_RECEIPTS row

Line 270: arp_standard.debug('delete_misc_receipt: ' || ' =====> BEGIN <=====');

266: -- VAT: AR_DISTRIBUTION accounting entry records needs to be deleted
267: -- before deleting AR_CASH_RECEIPTS row
268:
269: IF PG_DEBUG in ('Y', 'C') THEN
270: arp_standard.debug('delete_misc_receipt: ' || ' =====> BEGIN <=====');
271: END IF;
272:
273: /************* begin bug5655154, commented and replaced with below code
274: -- Bug 2189383

Line 323: arp_standard.debug('delete_misc_receipt: ' || ' l_count ' || TO_CHAR(l_count));

319: END IF ;
320: -- end bug5655154
321:
322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug('delete_misc_receipt: ' || ' l_count ' || TO_CHAR(l_count));
324: arp_standard.debug('delete_misc_receipt: ' || 'Delete Misc Cash Receipt start () +');
325: END IF;
326: --
327: IF (l_dist_cnt > 0) THEN -- bug5655154, replaced l_count with l_dist_cnt

Line 324: arp_standard.debug('delete_misc_receipt: ' || 'Delete Misc Cash Receipt start () +');

320: -- end bug5655154
321:
322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug('delete_misc_receipt: ' || ' l_count ' || TO_CHAR(l_count));
324: arp_standard.debug('delete_misc_receipt: ' || 'Delete Misc Cash Receipt start () +');
325: END IF;
326: --
327: IF (l_dist_cnt > 0) THEN -- bug5655154, replaced l_count with l_dist_cnt
328: l_ae_doc_rec.document_type := 'RECEIPT';

Line 337: arp_standard.debug('delete_misc_receipt: ' || 'Delete Misc Cash Receipt start () -');

333:
334: -- Call the delete routine
335: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
336: IF PG_DEBUG in ('Y', 'C') THEN
337: arp_standard.debug('delete_misc_receipt: ' || 'Delete Misc Cash Receipt start () -');
338: END IF;
339: END IF;
340:
341: -- delete AR_CASH_RECEIPTS receipt record:

Line 354: arp_standard.debug('delete_misc_receipt: ' || ' l_count ' || TO_CHAR(l_count));

350: -- ie. when receipt amount is 0, no records for MCD
351: -- and ARD, hence no deletion is required
352:
353: IF PG_DEBUG in ('Y', 'C') THEN
354: arp_standard.debug('delete_misc_receipt: ' || ' l_count ' || TO_CHAR(l_count));
355: END IF;
356:
357: IF (l_count > 0) THEN
358: IF PG_DEBUG in ('Y', 'C') THEN

Line 359: arp_standard.debug('delete_misc_receipt: ' || ' Delete AR_DISTRIBUTION');

355: END IF;
356:
357: IF (l_count > 0) THEN
358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_standard.debug('delete_misc_receipt: ' || ' Delete AR_DISTRIBUTION');
360: END IF;
361:
362: DELETE AR_DISTRIBUTIONS
363: WHERE source_table = 'CRH'

Line 385: arp_standard.debug('delete_misc_receipt: ' || ' Delete MISC_CASH_DISTRIBUTION');

381:
382: -- delete all AR_MISC_CASH distributions records created for
383: -- this receipt:
384: IF PG_DEBUG in ('Y', 'C') THEN
385: arp_standard.debug('delete_misc_receipt: ' || ' Delete MISC_CASH_DISTRIBUTION');
386: END IF;
387:
388: /*--------------------------------+
389: | Added Bulk collect of the the |

Line 434: arp_standard.debug('arp_process_receipts.delete_misc_receipt()-');

430: p_batch_id);
431: END IF;
432:
433: IF PG_DEBUG in ('Y', 'C') THEN
434: arp_standard.debug('arp_process_receipts.delete_misc_receipt()-');
435: END IF;
436:
437: EXCEPTION
438: WHEN OTHERS THEN

Line 440: arp_standard.debug('EXCEPTION: arp_process_misc_receipts2.delete_misc_receipts');

436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: IF PG_DEBUG in ('Y', 'C') THEN
440: arp_standard.debug('EXCEPTION: arp_process_misc_receipts2.delete_misc_receipts');
441: END IF;
442: RAISE;
443:
444: END delete_misc_receipt;