eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_CREDIT dependencies on ARP_UTIL

Line 35: | arp_util.debug |

31: | |
32: | SCOPE - PRIVATE |
33: | |
34: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
35: | arp_util.debug |
36: | arp_ctls_pkg.insert_f_cm_ct_ctl_id |
37: | |
38: | ARGUMENTS : IN: |
39: | p_customer_trx_id |

Line 67: arp_util.debug('arp_process_credit.create_salescredits()+');

63: IS
64: l_line_salesrep_flag NUMBER := 0;
65: BEGIN
66:
67: arp_util.debug('arp_process_credit.create_salescredits()+');
68:
69: --Bug 12376682
70: SELECT count(*)
71: INTO l_line_salesrep_flag

Line 123: arp_util.debug('arp_process_credit.create_salescredits()-');

119: p_currency_code);
120: END IF;
121: END IF;
122:
123: arp_util.debug('arp_process_credit.create_salescredits()-');
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

Line 127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

123: arp_util.debug('arp_process_credit.create_salescredits()-');
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);

Line 128: arp_util.debug('');

124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);

Line 129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);

125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
133: arp_util.debug('p_currency_code = '||p_currency_code);

Line 130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);

126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
133: arp_util.debug('p_currency_code = '||p_currency_code);
134:

Line 131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);

127: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
133: arp_util.debug('p_currency_code = '||p_currency_code);
134:
135: RAISE;

Line 132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);

128: arp_util.debug('');
129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
133: arp_util.debug('p_currency_code = '||p_currency_code);
134:
135: RAISE;
136: END;

Line 133: arp_util.debug('p_currency_code = '||p_currency_code);

129: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
130: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
131: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
132: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
133: arp_util.debug('p_currency_code = '||p_currency_code);
134:
135: RAISE;
136: END;
137:

Line 148: | arp_util.debug |

144: | |
145: | SCOPE - PRIVATE |
146: | |
147: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
148: | arp_util.debug |
149: | |
150: | ARGUMENTS : IN: |
151: | p_form_name |
152: | p_form_version |

Line 192: arp_util.debug('arp_process_credit.credit_freight()+');

188: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
189: l_frt_rec ra_customer_trx_lines%rowtype;
190: BEGIN
191:
192: arp_util.debug('arp_process_credit.credit_freight()+');
193:
194: IF ( p_prev_ct_id IS NULL)
195: OR
196: ( p_prev_ct_id IS NOT NULL

Line 317: arp_util.debug('arp_process_credit.credit_freight()-');

313: 'FREIGHT');
314: END IF;
315: END IF;
316:
317: arp_util.debug('arp_process_credit.credit_freight()-');
318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

Line 321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

317: arp_util.debug('arp_process_credit.credit_freight()-');
318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);

Line 322: arp_util.debug('');

318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);

Line 323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);

319: EXCEPTION
320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);

Line 324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);

320: WHEN OTHERS THEN
321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);

Line 325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);

321: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);

Line 326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);

322: arp_util.debug('');
323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);

Line 327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);

323: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);

Line 328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);

324: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);
332: arp_util.debug('p_gl_date : '||p_gl_date);

Line 329: arp_util.debug('p_freight_type : '||p_freight_type);

325: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);
332: arp_util.debug('p_gl_date : '||p_gl_date);
333: arp_util.debug('p_currency_code : '||p_currency_code);

Line 330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);

326: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);
332: arp_util.debug('p_gl_date : '||p_gl_date);
333: arp_util.debug('p_currency_code : '||p_currency_code);
334:

Line 331: arp_util.debug('p_mode : '||p_mode);

327: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);
332: arp_util.debug('p_gl_date : '||p_gl_date);
333: arp_util.debug('p_currency_code : '||p_currency_code);
334:
335: RAISE;

Line 332: arp_util.debug('p_gl_date : '||p_gl_date);

328: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);
332: arp_util.debug('p_gl_date : '||p_gl_date);
333: arp_util.debug('p_currency_code : '||p_currency_code);
334:
335: RAISE;
336: END;

Line 333: arp_util.debug('p_currency_code : '||p_currency_code);

329: arp_util.debug('p_freight_type : '||p_freight_type);
330: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
331: arp_util.debug('p_mode : '||p_mode);
332: arp_util.debug('p_gl_date : '||p_gl_date);
333: arp_util.debug('p_currency_code : '||p_currency_code);
334:
335: RAISE;
336: END;
337:

Line 347: | arp_util.debug |

343: | |
344: | SCOPE - PRIVATE |
345: | |
346: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
347: | arp_util.debug |
348: | |
349: | ARGUMENTS : IN: |
350: | OUT: |
351: | IN/ OUT: |

Line 371: arp_util.debug('arp_process_credit.default_credit_header()+');

367: IS
368: l_cr_txn_rec ra_customer_trx%rowtype;
369: BEGIN
370:
371: arp_util.debug('arp_process_credit.default_credit_header()+');
372:
373: p_new_cm_rec := p_cm_rec;
374: p_new_cm_rec.previous_customer_trx_id := p_prev_customer_trx_id;
375: p_new_cm_rec.complete_flag := 'N';

Line 420: arp_util.debug('arp_process_credit.default_credit_header()-');

416: WHERE ctt.cust_trx_type_id = p_new_cm_rec.cust_trx_type_id;
417:
418: END IF;
419:
420: arp_util.debug('arp_process_credit.default_credit_header()-');
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

Line 424: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

420: arp_util.debug('arp_process_credit.default_credit_header()-');
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');
425: RAISE;
426: END;
427:
428: /*===========================================================================+

Line 437: | arp_util.debug |

433: | |
434: | SCOPE - PRIVATE |
435: | |
436: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
437: | arp_util.debug |
438: | |
439: | ARGUMENTS : IN: |
440: | OUT: |
441: | IN/ OUT: |

Line 454: arp_util.debug('arp_process_credit.validate_insert_header()+');

450: +===========================================================================*/
451: PROCEDURE validate_insert_header
452: IS
453: BEGIN
454: arp_util.debug('arp_process_credit.validate_insert_header()+');
455:
456: arp_util.debug('arp_process_credit.validate_insert_header()-');
457:
458: EXCEPTION

Line 456: arp_util.debug('arp_process_credit.validate_insert_header()-');

452: IS
453: BEGIN
454: arp_util.debug('arp_process_credit.validate_insert_header()+');
455:
456: arp_util.debug('arp_process_credit.validate_insert_header()-');
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

Line 460: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

456: arp_util.debug('arp_process_credit.validate_insert_header()-');
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');
461: RAISE;
462:
463: END;
464:

Line 475: | arp_util.debug |

471: | |
472: | SCOPE - PRIVATE |
473: | |
474: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
475: | arp_util.debug |
476: | |
477: | ARGUMENTS : IN: |
478: | OUT: |
479: | IN/ OUT: |

Line 492: arp_util.debug('arp_process_credit.validate_update_header()+');

488: +===========================================================================*/
489: PROCEDURE validate_update_header
490: IS
491: BEGIN
492: arp_util.debug('arp_process_credit.validate_update_header()+');
493:
494: arp_util.debug('arp_process_credit.validate_update_header()-');
495:
496: EXCEPTION

Line 494: arp_util.debug('arp_process_credit.validate_update_header()-');

490: IS
491: BEGIN
492: arp_util.debug('arp_process_credit.validate_update_header()+');
493:
494: arp_util.debug('arp_process_credit.validate_update_header()-');
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

Line 498: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

494: arp_util.debug('arp_process_credit.validate_update_header()-');
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');
499: RAISE;
500:
501: END;
502:

Line 512: | arp_util.debug |

508: | |
509: | SCOPE - PRIVATE |
510: | |
511: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
512: | arp_util.debug |
513: | |
514: | ARGUMENTS : IN: |
515: | OUT: |
516: | IN/ OUT: |

Line 533: arp_util.debug('arp_process_credit.validate_insert_line()+');

529: PROCEDURE validate_insert_line(
530: p_line_rec IN ra_customer_trx_lines%rowtype)
531: IS
532: BEGIN
533: arp_util.debug('arp_process_credit.validate_insert_line()+');
534:
535: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
536: p_line_rec.customer_trx_id,
537: p_line_rec.customer_trx_line_id);

Line 539: arp_util.debug('arp_process_credit.validate_insert_line()-');

535: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
536: p_line_rec.customer_trx_id,
537: p_line_rec.customer_trx_line_id);
538:
539: arp_util.debug('arp_process_credit.validate_insert_line()-');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

Line 543: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

539: arp_util.debug('arp_process_credit.validate_insert_line()-');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');
544: RAISE;
545:
546: END;
547:

Line 557: | arp_util.debug |

553: | |
554: | SCOPE - PRIVATE |
555: | |
556: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
557: | arp_util.debug |
558: | |
559: | ARGUMENTS : IN: |
560: | OUT: |
561: | IN/ OUT: |

Line 574: arp_util.debug('arp_process_credit.validate_update_line()+');

570: +===========================================================================*/
571: PROCEDURE validate_update_line
572: IS
573: BEGIN
574: arp_util.debug('arp_process_credit.validate_update_line()+');
575:
576: arp_util.debug('arp_process_credit.validate_update_line()-');
577:
578: EXCEPTION

Line 576: arp_util.debug('arp_process_credit.validate_update_line()-');

572: IS
573: BEGIN
574: arp_util.debug('arp_process_credit.validate_update_line()+');
575:
576: arp_util.debug('arp_process_credit.validate_update_line()-');
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

Line 580: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

576: arp_util.debug('arp_process_credit.validate_update_line()-');
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');
581: RAISE;
582:
583: END;
584:

Line 595: | arp_util.debug |

591: | |
592: | SCOPE - PRIVATE |
593: | |
594: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
595: | arp_util.debug |
596: | |
597: | ARGUMENTS : IN: |
598: | OUT: |
599: | IN/ OUT: |

Line 628: arp_util.debug('arp_process_credit.default_credit_line()+');

624: l_trx_rec ra_customer_trx%rowtype;
625: l_calc_unit_price VARCHAR2(1); --2880106
626: BEGIN
627:
628: arp_util.debug('arp_process_credit.default_credit_line()+');
629:
630: p_new_cm_line := p_cm_line;
631: p_new_cm_line.customer_trx_id := p_customer_trx_id;
632: p_new_cm_line.extended_amount := p_line_amount;

Line 796: arp_util.debug('arp_process_credit.default_credit_line()-');

792: p_new_cm_line.ship_to_contact_id := l_cr_txn_line.ship_to_contact_id;
793:
794: END IF;
795:
796: arp_util.debug('arp_process_credit.default_credit_line()-');
797:
798: EXCEPTION
799: WHEN OTHERS THEN
800: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

Line 800: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

796: arp_util.debug('arp_process_credit.default_credit_line()-');
797:
798: EXCEPTION
799: WHEN OTHERS THEN
800: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');
801: RAISE;
802:
803: END;
804:

Line 828: arp_util.debug('arp_process_credit.get_cm_amounts()+');

824: l_freight_line_count number;
825:
826: BEGIN
827:
828: arp_util.debug('arp_process_credit.get_cm_amounts()+');
829:
830: IF (p_customer_trx_id IS NOT NULL)
831: THEN
832:

Line 895: arp_util.debug('arp_process_credit.get_cm_amounts()-');

891: END IF;
892:
893: END IF;
894:
895: arp_util.debug('arp_process_credit.get_cm_amounts()-');
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

Line 899: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

895: arp_util.debug('arp_process_credit.get_cm_amounts()-');
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');
900:
901: RAISE;
902:
903: END;

Line 915: | arp_util.debug |

911: | |
912: | SCOPE - PRIVATE |
913: | |
914: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
915: | arp_util.debug |
916: | |
917: | ARGUMENTS : IN: |
918: | OUT: |
919: | IN/ OUT: |

Line 955: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');

951: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
952:
953: BEGIN
954:
955: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');
956:
957: SELECT sum(nra.net_amount),
958: count(nra.customer_trx_line_id),
959: max(decode(p_prev_ctl_id,

Line 1026: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');

1022: p_freight_type := l_freight_type;
1023: p_freight_ctl_id := l_freight_ctl_id;
1024: END IF;
1025:
1026: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

Line 1030: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

1026: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');
1031: RAISE;
1032: END;
1033:
1034:

Line 1044: | arp_util.debug |

1040: | |
1041: | SCOPE - PRIVATE |
1042: | |
1043: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1044: | arp_util.debug |
1045: | |
1046: | ARGUMENTS : IN: |
1047: | OUT: |
1048: | IN/ OUT: |

Line 1081: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');

1077: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1078: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1079: BEGIN
1080:
1081: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');
1082:
1083: SELECT sum(decode(
1084: decode(nra.line_type,
1085: 'CB', 'LINE',

Line 1163: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');

1159: l_freight_balance_due;
1160: END IF;
1161: END IF;
1162:
1163: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1164:
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

Line 1167: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

1163: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1164:
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');
1168: arp_util.debug('');
1169:
1170: RAISE;
1171:

Line 1168: arp_util.debug('');

1164:
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');
1168: arp_util.debug('');
1169:
1170: RAISE;
1171:
1172: END;

Line 1183: | arp_util.debug |

1179: | |
1180: | SCOPE - PRIVATE |
1181: | |
1182: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1183: | arp_util.debug |
1184: | |
1185: | ARGUMENTS : IN: |
1186: | OUT: |
1187: | IN/ OUT: |

Line 1258: arp_util.debug('arp_process_credit.derive_credit_information()+');

1254: l_tax_status varchar2(30) := 'OK';
1255: l_frt_status varchar2(30) := 'OK';
1256: BEGIN
1257:
1258: arp_util.debug('arp_process_credit.derive_credit_information()+');
1259:
1260: IF (nvl(pg_num_credit_lines, 0) > 0)
1261: THEN
1262:

Line 1321: arp_util.debug('derive_credit_information() : get_uncredit_amounts');

1317: END LOOP;
1318:
1319: ELSE
1320:
1321: arp_util.debug('derive_credit_information() : get_uncredit_amounts');
1322:
1323: get_uncredit_amounts(p_customer_trx_id,
1324: null,
1325: p_prev_customer_trx_id,

Line 1335: arp_util.debug('Freight type : '||l_freight_type);

1331: l_memo_line_type,
1332: l_freight_type,
1333: l_freight_ctl_id);
1334:
1335: arp_util.debug('Freight type : '||l_freight_type);
1336: arp_util.debug('Freight ctlid : '||l_freight_ctl_id);
1337:
1338: l_credit_line_amount := p_credit_line_amount;
1339: l_credit_tax_amount := p_credit_tax_amount;

Line 1336: arp_util.debug('Freight ctlid : '||l_freight_ctl_id);

1332: l_freight_type,
1333: l_freight_ctl_id);
1334:
1335: arp_util.debug('Freight type : '||l_freight_type);
1336: arp_util.debug('Freight ctlid : '||l_freight_ctl_id);
1337:
1338: l_credit_line_amount := p_credit_line_amount;
1339: l_credit_tax_amount := p_credit_tax_amount;
1340: l_credit_freight_amount := p_credit_freight_amount;

Line 1393: arp_util.debug('derive_credit_information() : credit_freight');

1389: THEN
1390: /*------------------------------------+
1391: | create credit memo FREIGHT lines |
1392: +------------------------------------*/
1393: arp_util.debug('derive_credit_information() : credit_freight');
1394: credit_freight(
1395: p_form_name,
1396: p_form_version,
1397: p_customer_trx_id,

Line 1421: arp_util.debug('derive_credit_information() : '||

1417: IF (l_credit_line_amount IS NOT NULL AND
1418: p_submit_cm_dist = 'N')
1419: THEN
1420: BEGIN
1421: arp_util.debug('derive_credit_information() : '||
1422: 'credit_transactions');
1423:
1424: arp_credit_memo_module.credit_transactions(
1425: p_customer_trx_id,

Line 1433: arp_util.debug('credit memo module exception : no_ccid');

1429: null,
1430: l_failure_count);
1431: EXCEPTION
1432: WHEN arp_credit_memo_module.no_ccid THEN
1433: arp_util.debug('credit memo module exception : no_ccid');
1434: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
1435: WHEN NO_DATA_FOUND THEN
1436: arp_util.debug('credit memo module exception : no_data_found');
1437: null;

Line 1436: arp_util.debug('credit memo module exception : no_data_found');

1432: WHEN arp_credit_memo_module.no_ccid THEN
1433: arp_util.debug('credit memo module exception : no_ccid');
1434: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
1435: WHEN NO_DATA_FOUND THEN
1436: arp_util.debug('credit memo module exception : no_data_found');
1437: null;
1438: WHEN app_exception.application_exception THEN
1439: arp_util.debug('credit memo module exception : app_exception ');
1440: RAISE;

Line 1439: arp_util.debug('credit memo module exception : app_exception ');

1435: WHEN NO_DATA_FOUND THEN
1436: arp_util.debug('credit memo module exception : no_data_found');
1437: null;
1438: WHEN app_exception.application_exception THEN
1439: arp_util.debug('credit memo module exception : app_exception ');
1440: RAISE;
1441: WHEN OTHERS THEN
1442: RAISE;
1443: END;

Line 1453: arp_util.debug('l_all_line_status : '||l_all_line_status);

1449: PREVIOUS_CUSTOMER_TRX_ID = ":INVOICE.CUSTOMER_TRX_ID" */
1450:
1451: END IF;
1452:
1453: arp_util.debug('l_all_line_status : '||l_all_line_status);
1454: arp_util.debug('l_tax_status : '||l_tax_status);
1455: arp_util.debug('l_frt_status : '||l_frt_status);
1456: arp_util.debug('l_cmm_status : '||l_cmm_status);
1457:

Line 1454: arp_util.debug('l_tax_status : '||l_tax_status);

1450:
1451: END IF;
1452:
1453: arp_util.debug('l_all_line_status : '||l_all_line_status);
1454: arp_util.debug('l_tax_status : '||l_tax_status);
1455: arp_util.debug('l_frt_status : '||l_frt_status);
1456: arp_util.debug('l_cmm_status : '||l_cmm_status);
1457:
1458: IF (NVL(l_all_line_status, 'OK') <> 'OK') THEN

Line 1455: arp_util.debug('l_frt_status : '||l_frt_status);

1451: END IF;
1452:
1453: arp_util.debug('l_all_line_status : '||l_all_line_status);
1454: arp_util.debug('l_tax_status : '||l_tax_status);
1455: arp_util.debug('l_frt_status : '||l_frt_status);
1456: arp_util.debug('l_cmm_status : '||l_cmm_status);
1457:
1458: IF (NVL(l_all_line_status, 'OK') <> 'OK') THEN
1459: p_status := l_all_line_status;

Line 1456: arp_util.debug('l_cmm_status : '||l_cmm_status);

1452:
1453: arp_util.debug('l_all_line_status : '||l_all_line_status);
1454: arp_util.debug('l_tax_status : '||l_tax_status);
1455: arp_util.debug('l_frt_status : '||l_frt_status);
1456: arp_util.debug('l_cmm_status : '||l_cmm_status);
1457:
1458: IF (NVL(l_all_line_status, 'OK') <> 'OK') THEN
1459: p_status := l_all_line_status;
1460: ELSIF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 1468: arp_util.debug('arp_process_credit.derive_credit_information()-');

1464: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
1465: p_status := l_cmm_status;
1466: END IF;
1467:
1468: arp_util.debug('arp_process_credit.derive_credit_information()-');
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: arp_util.debug('EXCEPTION: derive_credit_information');

Line 1472: arp_util.debug('EXCEPTION: derive_credit_information');

1468: arp_util.debug('arp_process_credit.derive_credit_information()-');
1469:
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: arp_util.debug('EXCEPTION: derive_credit_information');
1473: RAISE;
1474: END;
1475:
1476:

Line 1487: | arp_util.debug |

1483: | |
1484: | SCOPE - PRIVATE |
1485: | |
1486: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1487: | arp_util.debug |
1488: | |
1489: | ARGUMENTS : IN: |
1490: | p_form_name |
1491: | p_form_version |

Line 1556: arp_util.debug('arp_process_credit.insert_header()+');

1552: l_ev_rec arp_xla_events.xla_events_type;
1553:
1554: BEGIN
1555:
1556: arp_util.debug('arp_process_credit.insert_header()+');
1557:
1558: /*--------------------------------------------------------------+
1559: | check form version to determine IF it is compatible with the |
1560: | entity handler. |

Line 1666: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);

1662: l_derive_status,
1663: p_submit_cm_dist);
1664: END IF;
1665:
1666: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1667: arp_util.debug('l_derive_status : '||l_derive_status);
1668:
1669: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1670: p_status := l_rec_aa_status;

Line 1667: arp_util.debug('l_derive_status : '||l_derive_status);

1663: p_submit_cm_dist);
1664: END IF;
1665:
1666: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1667: arp_util.debug('l_derive_status : '||l_derive_status);
1668:
1669: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1670: p_status := l_rec_aa_status;
1671: ELSIF (NVL(l_derive_status, 'OK') <> 'OK') THEN

Line 1679: arp_util.debug('arp_process_credit.insert_header()-');

1675: IF l_df_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1676: p_status := 'eTAX_ERROR';
1677: END IF;
1678:
1679: arp_util.debug('arp_process_credit.insert_header()-');
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

Line 1683: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

1679: arp_util.debug('arp_process_credit.insert_header()-');
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');
1684: RAISE;
1685: END;
1686:
1687: /*===========================================================================+

Line 1697: | arp_util.debug |

1693: | |
1694: | SCOPE - PRIVATE |
1695: | |
1696: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1697: | arp_util.debug |
1698: | |
1699: | ARGUMENTS : IN: |
1700: | p_customer_trx_id |
1701: | p_trx_number_change_flag |

Line 1722: arp_util.debug('arp_process_credit.delete_cm_records()+');

1718: p_trx_number_change_flag IN boolean)
1719: IS
1720: BEGIN
1721:
1722: arp_util.debug('arp_process_credit.delete_cm_records()+');
1723:
1724: /*-----------------------+
1725: | delete sales credits |
1726: +-----------------------*/

Line 1755: arp_util.debug('arp_process_credit.delete_cm_records()-');

1751: | delete line records |
1752: +---------------------*/
1753: arp_ctl_pkg.delete_f_ct_id(p_customer_trx_id);
1754:
1755: arp_util.debug('arp_process_credit.delete_cm_records()-');
1756:
1757: EXCEPTION
1758:
1759: WHEN OTHERS THEN

Line 1760: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');

1756:
1757: EXCEPTION
1758:
1759: WHEN OTHERS THEN
1760: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1761: arp_util.debug('');
1762: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1763:
1764: RAISE;

Line 1761: arp_util.debug('');

1757: EXCEPTION
1758:
1759: WHEN OTHERS THEN
1760: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1761: arp_util.debug('');
1762: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1763:
1764: RAISE;
1765: END;

Line 1762: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);

1758:
1759: WHEN OTHERS THEN
1760: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1761: arp_util.debug('');
1762: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1763:
1764: RAISE;
1765: END;
1766:

Line 1784: arp_util.debug('arp_process_credit.line_rerun_aa()+');

1780:
1781: l_rec_aa_status varchar2(30) := 'OK';
1782: l_other_aa_status varchar2(30) := 'OK';
1783: BEGIN
1784: arp_util.debug('arp_process_credit.line_rerun_aa()+');
1785:
1786: IF p_customer_trx_line_id IS NULL
1787: THEN
1788: BEGIN

Line 1848: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);

1844: WHEN OTHERS THEN
1845: RAISE;
1846: END;
1847:
1848: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1849: arp_util.debug('l_other_aa_status : '||l_other_aa_status);
1850:
1851: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1852: p_status := l_rec_aa_status;

Line 1849: arp_util.debug('l_other_aa_status : '||l_other_aa_status);

1845: RAISE;
1846: END;
1847:
1848: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1849: arp_util.debug('l_other_aa_status : '||l_other_aa_status);
1850:
1851: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1852: p_status := l_rec_aa_status;
1853: ELSIF (NVL(l_other_aa_status, 'OK') <> 'OK') THEN

Line 1857: arp_util.debug('arp_process_credit.line_rerun_aa()-');

1853: ELSIF (NVL(l_other_aa_status, 'OK') <> 'OK') THEN
1854: p_status := l_other_aa_status;
1855: END IF;
1856:
1857: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

Line 1861: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

1857: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');
1862: RAISE;
1863: END;
1864:
1865: /* Bug 3619804 */

Line 1877: | arp_util.debug |

1873: | |
1874: | SCOPE - PRIVATE |
1875: | |
1876: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1877: | arp_util.debug |
1878: | ARGUMENTS : |
1879: | IN : p_customer_trx_id |
1880: | OUT: |
1881: | IN/ OUT: |

Line 1900: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');

1896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1897:
1898: BEGIN
1899:
1900: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');
1901:
1902: arp_ctl_pkg.set_to_dummy( l_line_rec );
1903: l_line_rec.autorule_complete_flag := 'N';
1904: l_line_rec.autorule_duration_processed := NULL;

Line 1912: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||

1908: p_customer_trx_id,
1909: 'LINE');
1910: EXCEPTION
1911: WHEN NO_DATA_FOUND THEN
1912: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1913: 'no child lines to update.');
1914: WHEN OTHERS THEN
1915: arp_util.debug('EXCEPTION: '||
1916: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1915: arp_util.debug('EXCEPTION: '||

1911: WHEN NO_DATA_FOUND THEN
1912: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1913: 'no child lines to update.');
1914: WHEN OTHERS THEN
1915: arp_util.debug('EXCEPTION: '||
1916: 'arp_process_credit.reverse_revrec_effect_cm()');
1917: RAISE;
1918: END;
1919:

Line 1931: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||

1927: 'N',
1928: NULL);
1929: EXCEPTION
1930: WHEN NO_DATA_FOUND THEN
1931: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1932: 'no dists to delete.');
1933: WHEN OTHERS THEN
1934: arp_util.debug('EXCEPTION: '||
1935: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1934: arp_util.debug('EXCEPTION: '||

1930: WHEN NO_DATA_FOUND THEN
1931: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1932: 'no dists to delete.');
1933: WHEN OTHERS THEN
1934: arp_util.debug('EXCEPTION: '||
1935: 'arp_process_credit.reverse_revrec_effect_cm()');
1936: RAISE;
1937: END;
1938:

Line 1948: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||

1944: 'Y',
1945: 'REC');
1946: EXCEPTION
1947: WHEN NO_DATA_FOUND THEN
1948: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1949: 'no dists to update.');
1950: WHEN OTHERS THEN
1951: arp_util.debug('EXCEPTION: '||
1952: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1951: arp_util.debug('EXCEPTION: '||

1947: WHEN NO_DATA_FOUND THEN
1948: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1949: 'no dists to update.');
1950: WHEN OTHERS THEN
1951: arp_util.debug('EXCEPTION: '||
1952: 'arp_process_credit.reverse_revrec_effect_cm()');
1953: RAISE;
1954: END;
1955: EXCEPTION

Line 1957: arp_util.debug('EXCEPTION: '||

1953: RAISE;
1954: END;
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: arp_util.debug('EXCEPTION: '||
1958: 'arp_process_credit.reverse_revrec_effect_cm()');
1959: RAISE;
1960: END ;
1961:

Line 1975: | arp_util.debug |

1971: | |
1972: | SCOPE - PRIVATE |
1973: | |
1974: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1975: | arp_util.debug |
1976: | |
1977: | ARGUMENTS : IN: |
1978: | p_customer_trx_id |
1979: | p_new_trx_rec |

Line 2005: arp_util.debug('arp_process_credit.set_header_flags()+');

2001: IS
2002: l_old_trx_rec ra_customer_trx%rowtype;
2003: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
2004: BEGIN
2005: arp_util.debug('arp_process_credit.set_header_flags()+');
2006:
2007: arp_ct_pkg.fetch_p(l_old_trx_rec, p_customer_trx_id);
2008:
2009: p_old_trx_rec := l_old_trx_rec;

Line 2044: arp_util.debug('arp_process_credit.set_header_flags()-');

2040: ELSE
2041: p_complete_changed_flag := FALSE;
2042: END IF;
2043:
2044: arp_util.debug('arp_process_credit.set_header_flags()-');
2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

Line 2048: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

2044: arp_util.debug('arp_process_credit.set_header_flags()-');
2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');
2049: arp_util.debug('');
2050: RAISE;
2051: END;
2052:

Line 2049: arp_util.debug('');

2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');
2049: arp_util.debug('');
2050: RAISE;
2051: END;
2052:
2053: /*===========================================================================+

Line 2063: | arp_util.debug |

2059: | |
2060: | SCOPE - PRIVATE |
2061: | |
2062: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2063: | arp_util.debug |
2064: | |
2065: | ARGUMENTS : IN: |
2066: | p_form_name |
2067: | p_form_version |

Line 2172: arp_util.debug('arp_process_credit.update_header()+');

2168: trx.customer_trx_id,
2169: trx.org_id;
2170:
2171: BEGIN
2172: arp_util.debug('arp_process_credit.update_header()+');
2173:
2174: /*--------------------------------------------------------------+
2175: | check form version to determine IF it is compatible with the |
2176: | entity handler. |

Line 2195: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);

2191: | If Yes, this is identified as Tax Event for Vendors and Vendor data |
2192: | is synchronized with the new transaction number. |
2193: | This is not a Tax Event for GTE. |
2194: +----------------------------------------------------------------------*/
2195: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2196: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2197: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2198: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2199: l_trx_number_change_flag := FALSE;

Line 2196: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);

2192: | is synchronized with the new transaction number. |
2193: | This is not a Tax Event for GTE. |
2194: +----------------------------------------------------------------------*/
2195: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2196: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2197: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2198: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2199: l_trx_number_change_flag := FALSE;
2200:

Line 2197: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);

2193: | This is not a Tax Event for GTE. |
2194: +----------------------------------------------------------------------*/
2195: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2196: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2197: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2198: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2199: l_trx_number_change_flag := FALSE;
2200:
2201:

Line 2198: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);

2194: +----------------------------------------------------------------------*/
2195: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2196: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2197: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2198: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2199: l_trx_number_change_flag := FALSE;
2200:
2201:
2202: IF ( p_trx_rec.old_trx_number is not null )

Line 2211: arp_util.debug( 'orig_trx_number : ' || orig_trx_number);

2207: INTO orig_trx_number
2208: FROM ra_customer_trx
2209: WHERE customer_trx_id = p_customer_trx_id;
2210:
2211: arp_util.debug( 'orig_trx_number : ' || orig_trx_number);
2212:
2213: IF p_trx_rec.trx_number <> orig_trx_number
2214: THEN
2215: l_trx_number_change_flag := TRUE;

Line 2229: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

2225:
2226: END IF;
2227:
2228: --Bug2109490
2229: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2230: --
2231: -- call Tax engine, checking if tax needs to be recalculated
2232: --
2233: l_action := arp_etax_services_pkg.Get_tax_Action(p_customer_trx_id);

Line 2314: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||

2310: arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_ret_status);
2311:
2312: IF l_ret_status > 0
2313: THEN
2314: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
2315: l_ret_status);
2316: arp_util.debug('Please review the plsql debug log for additional details.');
2317: p_status := 'SYNCH_DOC_SEQ_ERROR';
2318: END IF;

Line 2316: arp_util.debug('Please review the plsql debug log for additional details.');

2312: IF l_ret_status > 0
2313: THEN
2314: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
2315: l_ret_status);
2316: arp_util.debug('Please review the plsql debug log for additional details.');
2317: p_status := 'SYNCH_DOC_SEQ_ERROR';
2318: END IF;
2319: END IF;
2320:

Line 2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));

2378: null);
2379: END IF;
2380:
2381: --Bug2109490
2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

Line 2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);

2379: END IF;
2380:
2381: --Bug2109490
2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2387:

Line 2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));

2380:
2381: --Bug2109490
2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2387:
2388: IF (( p_prev_customer_trx_id IS NOT NULL)

Line 2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);

2381: --Bug2109490
2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2387:
2388: IF (( p_prev_customer_trx_id IS NOT NULL)
2389: AND

Line 2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2387:
2388: IF (( p_prev_customer_trx_id IS NOT NULL)
2389: AND
2390: nvl(p_rederive_credit_info, 'N') = 'Y' )

Line 2397: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));

2393: -- if rederive credit memo info is set, then delete all records
2394: -- and rederive info if any of the amounts are not null
2395: --
2396:
2397: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2398: arp_util.debug( 'p_customer_trx_id : ' || to_char( p_customer_trx_id ));
2399: delete_cm_records(p_customer_trx_id, l_trx_number_change_flag);
2400: /*Bug 8974913*/
2401: IF ( p_compute_tax = 'Y' AND p_tax_amount <> 0)

Line 2398: arp_util.debug( 'p_customer_trx_id : ' || to_char( p_customer_trx_id ));

2394: -- and rederive info if any of the amounts are not null
2395: --
2396:
2397: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2398: arp_util.debug( 'p_customer_trx_id : ' || to_char( p_customer_trx_id ));
2399: delete_cm_records(p_customer_trx_id, l_trx_number_change_flag);
2400: /*Bug 8974913*/
2401: IF ( p_compute_tax = 'Y' AND p_tax_amount <> 0)
2402: THEN

Line 2472: arp_util.debug('arp_process_credit.update_header: '||

2468: null);
2469: END IF;
2470: EXCEPTION
2471: WHEN NO_DATA_FOUND THEN
2472: arp_util.debug('arp_process_credit.update_header: '||
2473: 'no distributions to update');
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2476: arp_util.debug(' update gl_date');

Line 2475: arp_util.debug('EXCEPTION : arp_process_credit.update_header');

2471: WHEN NO_DATA_FOUND THEN
2472: arp_util.debug('arp_process_credit.update_header: '||
2473: 'no distributions to update');
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2476: arp_util.debug(' update gl_date');
2477: RAISE;
2478: END;
2479: END IF;

Line 2476: arp_util.debug(' update gl_date');

2472: arp_util.debug('arp_process_credit.update_header: '||
2473: 'no distributions to update');
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2476: arp_util.debug(' update gl_date');
2477: RAISE;
2478: END;
2479: END IF;
2480:

Line 2486: arp_util.debug('update_header() : credit_transactions');

2482: AND
2483: nvl(p_rederive_credit_info, 'N') = 'N')
2484: THEN
2485: BEGIN
2486: arp_util.debug('update_header() : credit_transactions');
2487:
2488: arp_credit_memo_module.credit_transactions(
2489: p_customer_trx_id,
2490: null,

Line 2498: arp_util.debug('credit memo module exception : no_ccid');

2494: l_failure_count,
2495: 'U');
2496: EXCEPTION
2497: WHEN arp_credit_memo_module.no_ccid THEN
2498: arp_util.debug('credit memo module exception : no_ccid');
2499: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
2500: WHEN NO_DATA_FOUND THEN
2501: arp_util.debug('credit memo module exception : no_data_found');
2502: null;

Line 2501: arp_util.debug('credit memo module exception : no_data_found');

2497: WHEN arp_credit_memo_module.no_ccid THEN
2498: arp_util.debug('credit memo module exception : no_ccid');
2499: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
2500: WHEN NO_DATA_FOUND THEN
2501: arp_util.debug('credit memo module exception : no_data_found');
2502: null;
2503: WHEN app_exception.application_exception THEN
2504: arp_util.debug('credit memo module exception : app_exception ');
2505: RAISE;

Line 2504: arp_util.debug('credit memo module exception : app_exception ');

2500: WHEN NO_DATA_FOUND THEN
2501: arp_util.debug('credit memo module exception : no_data_found');
2502: null;
2503: WHEN app_exception.application_exception THEN
2504: arp_util.debug('credit memo module exception : app_exception ');
2505: RAISE;
2506: WHEN OTHERS THEN
2507: RAISE;
2508: END;

Line 2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));

2508: END;
2509:
2510: END IF;
2511: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2516: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));

Line 2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);

2509:
2510: END IF;
2511: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2516: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2517:

Line 2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );

2510: END IF;
2511: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2516: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2517:
2518: IF l_complete_changed_flag AND p_trx_rec.complete_flag = 'N'

Line 2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );

2511: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2516: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2517:
2518: IF l_complete_changed_flag AND p_trx_rec.complete_flag = 'N'
2519: THEN

Line 2516: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));

2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2516: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2517:
2518: IF l_complete_changed_flag AND p_trx_rec.complete_flag = 'N'
2519: THEN
2520: IF p_cr_txn_invoicing_rule_id IS NOT NULL

Line 2531: arp_util.debug('l_tax_status : '|| l_tax_status);

2527: END IF;
2528: END IF; /* IF l_complete_flag_changed */
2529:
2530:
2531: arp_util.debug('l_tax_status : '|| l_tax_status);
2532: arp_util.debug('l_derive_status : '|| l_derive_status);
2533: arp_util.debug('l_cmm_status : '|| l_cmm_status);
2534:
2535: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 2532: arp_util.debug('l_derive_status : '|| l_derive_status);

2528: END IF; /* IF l_complete_flag_changed */
2529:
2530:
2531: arp_util.debug('l_tax_status : '|| l_tax_status);
2532: arp_util.debug('l_derive_status : '|| l_derive_status);
2533: arp_util.debug('l_cmm_status : '|| l_cmm_status);
2534:
2535: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2536: p_status := l_tax_status;

Line 2533: arp_util.debug('l_cmm_status : '|| l_cmm_status);

2529:
2530:
2531: arp_util.debug('l_tax_status : '|| l_tax_status);
2532: arp_util.debug('l_derive_status : '|| l_derive_status);
2533: arp_util.debug('l_cmm_status : '|| l_cmm_status);
2534:
2535: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2536: p_status := l_tax_status;
2537: ELSIF (NVL(l_derive_status, 'OK') <> 'OK' ) THEN

Line 2583: arp_util.debug('arp_process_credit.update_header()-');

2579: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
2580:
2581: END IF;
2582: END IF; --bug 7193337
2583: arp_util.debug('arp_process_credit.update_header()-');
2584:
2585: EXCEPTION
2586:
2587: WHEN OTHERS THEN

Line 2588: arp_util.debug('EXCEPTION : arp_process_credit.update_header');

2584:
2585: EXCEPTION
2586:
2587: WHEN OTHERS THEN
2588: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2589:
2590: RAISE;
2591: END;
2592:

Line 2603: | arp_util.debug |

2599: | |
2600: | SCOPE - PRIVATE |
2601: | |
2602: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2603: | arp_util.debug |
2604: | |
2605: | ARGUMENTS : IN: |
2606: | p_form_name |
2607: | p_form_version |

Line 2688: arp_util.debug('arp_process_credit.insert_line()+');

2684: l_mode varchar2(30);
2685:
2686: BEGIN
2687:
2688: arp_util.debug('arp_process_credit.insert_line()+');
2689:
2690: /*--------------------------------------------------------------+
2691: | check form version to determine IF it is compatible with the |
2692: | entity handler. |

Line 2947: arp_util.debug('l_tax_status : '||l_tax_status);

2943: END;
2944:
2945: END IF;
2946:
2947: arp_util.debug('l_tax_status : '||l_tax_status);
2948: arp_util.debug('l_frt_status : '||l_frt_status);
2949: arp_util.debug('l_aa_status : '||l_aa_status);
2950: arp_util.debug('l_cmm_status : '||l_cmm_status);
2951:

Line 2948: arp_util.debug('l_frt_status : '||l_frt_status);

2944:
2945: END IF;
2946:
2947: arp_util.debug('l_tax_status : '||l_tax_status);
2948: arp_util.debug('l_frt_status : '||l_frt_status);
2949: arp_util.debug('l_aa_status : '||l_aa_status);
2950: arp_util.debug('l_cmm_status : '||l_cmm_status);
2951:
2952: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 2949: arp_util.debug('l_aa_status : '||l_aa_status);

2945: END IF;
2946:
2947: arp_util.debug('l_tax_status : '||l_tax_status);
2948: arp_util.debug('l_frt_status : '||l_frt_status);
2949: arp_util.debug('l_aa_status : '||l_aa_status);
2950: arp_util.debug('l_cmm_status : '||l_cmm_status);
2951:
2952: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2953: p_status := l_tax_status;

Line 2950: arp_util.debug('l_cmm_status : '||l_cmm_status);

2946:
2947: arp_util.debug('l_tax_status : '||l_tax_status);
2948: arp_util.debug('l_frt_status : '||l_frt_status);
2949: arp_util.debug('l_aa_status : '||l_aa_status);
2950: arp_util.debug('l_cmm_status : '||l_cmm_status);
2951:
2952: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2953: p_status := l_tax_status;
2954: ELSIF (NVL(l_frt_status, 'OK') <> 'OK') THEN

Line 2962: arp_util.debug('arp_process_credit.insert_line()-');

2958: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
2959: p_status := l_cmm_status;
2960: END IF;
2961:
2962: arp_util.debug('arp_process_credit.insert_line()-');
2963:
2964: EXCEPTION
2965: when OTHERS THEN
2966: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

Line 2966: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

2962: arp_util.debug('arp_process_credit.insert_line()-');
2963:
2964: EXCEPTION
2965: when OTHERS THEN
2966: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');
2967: arp_ctl_pkg.display_line_rec(l_credit_rec);
2968: RAISE;
2969: END;
2970:

Line 2982: | arp_util.debug |

2978: | |
2979: | SCOPE - PRIVATE |
2980: | |
2981: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2982: | arp_util.debug |
2983: | |
2984: | ARGUMENTS : IN: |
2985: | p_customer_trx_line_id |
2986: | p_new_trx_rec |

Line 3041: arp_util.debug('arp_process_credit.set_line_flags()+');

3037:
3038:
3039: BEGIN
3040:
3041: arp_util.debug('arp_process_credit.set_line_flags()+');
3042:
3043: arp_ctl_pkg.fetch_p(l_old_line_rec, p_customer_trx_line_id);
3044:
3045: arp_process_credit.get_cm_amounts(

Line 3116: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);

3112: p_frt_mode := l_frt_mode;
3113: p_frt_ctlid := l_frt_ctlid;
3114: p_cm_complete_flag := l_cm_complete_flag;
3115:
3116: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));

Line 3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);

3113: p_frt_ctlid := l_frt_ctlid;
3114: p_cm_complete_flag := l_cm_complete_flag;
3115:
3116: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||

Line 3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );

3114: p_cm_complete_flag := l_cm_complete_flag;
3115:
3116: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));

Line 3119: arp_util.debug('p_line_amt_chng_flag : '||

3115:
3116: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||

Line 3121: arp_util.debug('p_tax_amt_chng_flag : '||

3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);

Line 3123: arp_util.debug('p_frt_amt_chng_flag : '||

3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);

Line 3125: arp_util.debug('p_tax_mode : '||l_tax_mode);

3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3129:

Line 3126: arp_util.debug('p_frt_mode : '||l_frt_mode);

3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3129:
3130: arp_util.debug('arp_process_credit.set_line_flags()-');

Line 3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);

3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3129:
3130: arp_util.debug('arp_process_credit.set_line_flags()-');
3131:

Line 3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);

3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3129:
3130: arp_util.debug('arp_process_credit.set_line_flags()-');
3131:
3132: EXCEPTION

Line 3130: arp_util.debug('arp_process_credit.set_line_flags()-');

3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3129:
3130: arp_util.debug('arp_process_credit.set_line_flags()-');
3131:
3132: EXCEPTION
3133: WHEN OTHERS THEN
3134: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

Line 3134: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

3130: arp_util.debug('arp_process_credit.set_line_flags()-');
3131:
3132: EXCEPTION
3133: WHEN OTHERS THEN
3134: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');
3135: RAISE;
3136: END;
3137:
3138: /*===========================================================================+

Line 3148: | arp_util.debug |

3144: | |
3145: | SCOPE - PRIVATE |
3146: | |
3147: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3148: | arp_util.debug |
3149: | |
3150: | ARGUMENTS : IN: |
3151: | p_form_name |
3152: | p_form_version |

Line 3232: arp_util.debug('arp_process_credit.update_line()+');

3228: l_frt_status varchar2(30) := 'OK';
3229: l_recalculate_tax_flag BOOLEAN;
3230:
3231: BEGIN
3232: arp_util.debug('arp_process_credit.update_line()+');
3233:
3234: /*--------------------------------------------------------------+
3235: | check form version to determine IF it is compatible with the |
3236: | entity handler. |

Line 3271: arp_util.debug(

3267:
3268: EXCEPTION
3269: WHEN OTHERS THEN
3270:
3271: arp_util.debug(
3272: 'arp_etax_services_pkg.before_update_line raised exception');
3273: RAISE;
3274: END;
3275:

Line 3399: arp_util.debug('arp_process_credit.update_line '||

3395: pg_base_precision,
3396: pg_base_min_acc_unit);
3397: EXCEPTION
3398: WHEN NO_DATA_FOUND THEN
3399: arp_util.debug('arp_process_credit.update_line '||
3400: 'no distributions updated');
3401: WHEN OTHERS THEN
3402: RAISE;
3403: END;

Line 3407: arp_util.debug('l_tax_status : '||l_tax_status);

3403: END;
3404: END IF;
3405: END IF;
3406:
3407: arp_util.debug('l_tax_status : '||l_tax_status);
3408: arp_util.debug('l_frt_status : '||l_frt_status);
3409: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);
3410:
3411: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 3408: arp_util.debug('l_frt_status : '||l_frt_status);

3404: END IF;
3405: END IF;
3406:
3407: arp_util.debug('l_tax_status : '||l_tax_status);
3408: arp_util.debug('l_frt_status : '||l_frt_status);
3409: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);
3410:
3411: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
3412: p_status := l_tax_status;

Line 3409: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);

3405: END IF;
3406:
3407: arp_util.debug('l_tax_status : '||l_tax_status);
3408: arp_util.debug('l_frt_status : '||l_frt_status);
3409: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);
3410:
3411: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
3412: p_status := l_tax_status;
3413: ELSIF (NVL(l_frt_status, 'OK') <> 'OK') THEN

Line 3419: arp_util.debug('arp_process_credit.update_line()-');

3415: ELSIF (NVL(l_rerun_aa_status, 'OK') <> 'OK') THEN
3416: p_status := l_rerun_aa_status;
3417: END IF;
3418:
3419: arp_util.debug('arp_process_credit.update_line()-');
3420:
3421: EXCEPTION
3422: WHEN OTHERS THEN
3423: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

Line 3423: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

3419: arp_util.debug('arp_process_credit.update_line()-');
3420:
3421: EXCEPTION
3422: WHEN OTHERS THEN
3423: arp_util.debug('EXCEPTION: arp_process_credit.update_line');
3424: RAISE;
3425: END;
3426: /*===========================================================================+
3427: | PROCEDURE |

Line 3436: | arp_util.debug |

3432: | |
3433: | SCOPE - PRIVATE |
3434: | |
3435: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3436: | arp_util.debug |
3437: | |
3438: | ARGUMENTS : IN: |
3439: | OUT: |
3440: | IN/ OUT: |

Line 3465: arp_util.debug('arp_process_credit.freight_post_update()+');

3461: l_rows_processed number;
3462: l_errorbuf varchar2(200);
3463: l_result number;
3464: BEGIN
3465: arp_util.debug('arp_process_credit.freight_post_update()+');
3466:
3467: -- replace this with the call to the CREDIT MEMO procedure
3468: -- update the distribution record
3469:

Line 3498: arp_util.debug('arp_process_credit.freight_post_update()-');

3494: RAISE;
3495: END;
3496:
3497:
3498: arp_util.debug('arp_process_credit.freight_post_update()-');
3499:
3500: EXCEPTION
3501:
3502: WHEN OTHERS THEN

Line 3503: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');

3499:
3500: EXCEPTION
3501:
3502: WHEN OTHERS THEN
3503: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3504:
3505: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3506: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3507: arp_util.debug('p_gl_date : '||p_gl_date);

Line 3505: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);

3501:
3502: WHEN OTHERS THEN
3503: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3504:
3505: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3506: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3507: arp_util.debug('p_gl_date : '||p_gl_date);
3508:
3509: END;

Line 3506: arp_util.debug('p_frt_ccid : '||p_frt_ccid);

3502: WHEN OTHERS THEN
3503: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3504:
3505: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3506: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3507: arp_util.debug('p_gl_date : '||p_gl_date);
3508:
3509: END;
3510:

Line 3507: arp_util.debug('p_gl_date : '||p_gl_date);

3503: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3504:
3505: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3506: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3507: arp_util.debug('p_gl_date : '||p_gl_date);
3508:
3509: END;
3510:
3511:

Line 3530: arp_util.debug('EXCEPTION: arp_process_credit.initialization');

3526: arp_trx_global.system_info.system_parameters.salesrep_required_flag;
3527:
3528: EXCEPTION
3529: WHEN OTHERS THEN
3530: arp_util.debug('EXCEPTION: arp_process_credit.initialization');
3531: RAISE;
3532: END init;
3533:
3534: BEGIN