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_LINE dependencies on ARP_UTIL

Line 23: | arp_util.debug |

19: | |
20: | SCOPE - PRIVATE |
21: | |
22: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
23: | arp_util.debug |
24: | |
25: | ARGUMENTS : IN: |
26: | p_customer_trx_id |
27: | OUT: |

Line 50: arp_util.debug('arp_process_line.make_incomplete()+');

46:
47: BEGIN
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_util.debug('arp_process_line.make_incomplete()+');
51: END IF;
52:
53: arp_ct_pkg.set_to_dummy( l_trx_rec );
54:

Line 61: arp_util.debug('arp_process_line.make_incomplete()-');

57: arp_ct_pkg.update_p( l_trx_rec,
58: p_customer_trx_id );
59:
60: IF PG_DEBUG in ('Y', 'C') THEN
61: arp_util.debug('arp_process_line.make_incomplete()-');
62: END IF;
63:
64: EXCEPTION
65: WHEN OTHERS THEN

Line 67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');

63:
64: EXCEPTION
65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;

Line 68: arp_util.debug('make_incomplete: ' || '');

64: EXCEPTION
65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;
72:

Line 69: arp_util.debug('---------- parameters for make_incomplete() ---------');

65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;
72:
73: RAISE;

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

66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;
72:
73: RAISE;
74:

Line 87: | arp_util.debug |

83: | |
84: | SCOPE - PRIVATE |
85: | |
86: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
87: | arp_util.debug |
88: | |
89: | ARGUMENTS : IN: |
90: | p_customer_trx_id |
91: | OUT: |

Line 110: arp_util.debug('arp_process_line.get_commitment_line_id()+');

106: IS
107: BEGIN
108:
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_util.debug('arp_process_line.get_commitment_line_id()+');
111: END IF;
112:
113: BEGIN
114:

Line 129: arp_util.debug('arp_process_line.get_commitment_line_id()-');

125: RAISE;
126: END;
127:
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('arp_process_line.get_commitment_line_id()-');
130: END IF;
131:
132: EXCEPTION
133: WHEN OTHERS THEN

Line 135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');

131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:

Line 136: arp_util.debug('------ parameters for get_commitment_line_id() -----');

132: EXCEPTION
133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:
140: RAISE;

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

133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:
140: RAISE;
141:

Line 155: | arp_util.debug |

151: | |
152: | SCOPE - PRIVATE |
153: | |
154: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
155: | arp_util.debug |
156: | |
157: | ARGUMENTS : IN: |
158: | p_line_rec |
159: | p_customer_trx_line_id |

Line 200: arp_util.debug('arp_process_line.set_flags()+');

196: l_last_period_changed_flag boolean;
197:
198: BEGIN
199:
200: arp_util.debug('arp_process_line.set_flags()+');
201:
202:
203: /*--------------------------------+
204: | Set the flags appropriately |

Line 268: arp_util.debug('l_derive_gl_date_flag = ' ||

264: /*------------------------+
265: | Print out NOCOPY the results |
266: +------------------------*/
267:
268: arp_util.debug('l_derive_gl_date_flag = ' ||
269: arp_trx_util.boolean_to_varchar2( l_derive_gl_date_flag ));
270: arp_util.debug('l_amount_changed_flag = ' ||
271: arp_trx_util.boolean_to_varchar2( l_amount_changed_flag ));
272: arp_util.debug('l_last_period_changed_flag = ' ||

Line 270: arp_util.debug('l_amount_changed_flag = ' ||

266: +------------------------*/
267:
268: arp_util.debug('l_derive_gl_date_flag = ' ||
269: arp_trx_util.boolean_to_varchar2( l_derive_gl_date_flag ));
270: arp_util.debug('l_amount_changed_flag = ' ||
271: arp_trx_util.boolean_to_varchar2( l_amount_changed_flag ));
272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));

Line 272: arp_util.debug('l_last_period_changed_flag = ' ||

268: arp_util.debug('l_derive_gl_date_flag = ' ||
269: arp_trx_util.boolean_to_varchar2( l_derive_gl_date_flag ));
270: arp_util.debug('l_amount_changed_flag = ' ||
271: arp_trx_util.boolean_to_varchar2( l_amount_changed_flag ));
272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));
275:
276: arp_util.debug('arp_process_line.set_flags()-');

Line 276: arp_util.debug('arp_process_line.set_flags()-');

272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));
275:
276: arp_util.debug('arp_process_line.set_flags()-');
277:
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');

282: /*---------------------------------------------+
283: | Display parameters and raise the exception |
284: +---------------------------------------------*/
285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:

Line 288: arp_util.debug('');

284: +---------------------------------------------*/
285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);

Line 289: arp_util.debug('---------- parameters for set_flags() ---------');

285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);
293:

Line 291: arp_util.debug('p_customer_trx_line_id = ' ||

287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);
293:
294: arp_util.debug('');
295:

Line 294: arp_util.debug('');

290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);
293:
294: arp_util.debug('');
295:
296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');

Line 296: arp_util.debug('---------- old line record ----------');

292: p_customer_trx_line_id);
293:
294: arp_util.debug('');
295:
296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');

Line 298: arp_util.debug('');

294: arp_util.debug('');
295:
296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');
301: arp_ctl_pkg.display_line_rec( p_line_rec );
302: arp_util.debug('');

Line 300: arp_util.debug('---------- new line record ----------');

296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');
301: arp_ctl_pkg.display_line_rec( p_line_rec );
302: arp_util.debug('');
303:
304: RAISE;

Line 302: arp_util.debug('');

298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');
301: arp_ctl_pkg.display_line_rec( p_line_rec );
302: arp_util.debug('');
303:
304: RAISE;
305:
306: END;

Line 318: | arp_util.debug |

314: | |
315: | SCOPE - PRIVATE |
316: | |
317: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
318: | arp_util.debug |
319: | |
320: | ARGUMENTS : IN: |
321: | p_customer_trx_id |
322: | p_customer_trx_line_id |

Line 350: arp_util.debug('arp_process_line.line_rerun_aa()+');

346: l_num_failed_dist_rows binary_integer;
347:
348: BEGIN
349:
350: arp_util.debug('arp_process_line.line_rerun_aa()+');
351:
352: BEGIN
353: arp_auto_accounting.do_autoaccounting
354: (

Line 380: arp_util.debug('arp_process_line.line_rerun_aa()-');

376: WHEN OTHERS THEN
377: RAISE;
378: END;
379:
380: arp_util.debug('arp_process_line.line_rerun_aa()-');
381:
382: EXCEPTION
383: WHEN OTHERS THEN
384:

Line 385: arp_util.debug('EXCEPTION: arp_process_line.line_rerun_aa()');

381:
382: EXCEPTION
383: WHEN OTHERS THEN
384:
385: arp_util.debug('EXCEPTION: arp_process_line.line_rerun_aa()');
386:
387:
388: /*---------------------------------------------+
389: | Display parameters and raise the exception |

Line 392: arp_util.debug('');

388: /*---------------------------------------------+
389: | Display parameters and raise the exception |
390: +---------------------------------------------*/
391:
392: arp_util.debug('');
393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');
394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);

Line 393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');

389: | Display parameters and raise the exception |
390: +---------------------------------------------*/
391:
392: arp_util.debug('');
393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');
394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);
397:

Line 395: arp_util.debug('p_customer_trx_id = ' ||

391:
392: arp_util.debug('');
393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');
394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);
397:
398: arp_util.debug('p_customer_trx_line_id = ' ||
399: p_customer_trx_line_id);

Line 398: arp_util.debug('p_customer_trx_line_id = ' ||

394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);
397:
398: arp_util.debug('p_customer_trx_line_id = ' ||
399: p_customer_trx_line_id);
400:
401: arp_util.debug('');
402:

Line 401: arp_util.debug('');

397:
398: arp_util.debug('p_customer_trx_line_id = ' ||
399: p_customer_trx_line_id);
400:
401: arp_util.debug('');
402:
403: RAISE;
404:
405: END;

Line 421: | arp_util.debug |

417: | |
418: | SCOPE - PRIVATE |
419: | |
420: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
421: | arp_util.debug |
422: | |
423: | ARGUMENTS : IN: |
424: | p_customer_trx_id |
425: | p_trx_amount |

Line 457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');

453: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
454:
455: BEGIN
456:
457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');
458:
459: IF (arp_trx_util.detect_freight_only_rules_case( p_customer_trx_id ) = TRUE)
460: THEN
461:

Line 509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');

505: null);
506:
507: END IF;
508:
509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: arp_util.debug(

Line 513: arp_util.debug(

509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');

Line 516: arp_util.debug('');

512: WHEN OTHERS THEN
513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);

Line 517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');

513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

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

515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:

Line 520: arp_util.debug('p_trx_amount = ' || p_trx_amount);

516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:
524: RAISE;

Line 521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:
524: RAISE;
525:

Line 522: arp_util.debug('p_gl_date = ' || p_gl_date);

518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:
524: RAISE;
525:
526: END;

Line 538: | arp_util.debug |

534: | |
535: | SCOPE - PRIVATE |
536: | |
537: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
538: | arp_util.debug |
539: | |
540: | ARGUMENTS : IN: |
541: | p_line_rec |
542: | OUT: |

Line 567: arp_util.debug('arp_process_line.val_insert_line()+');

563:
564:
565: BEGIN
566:
567: arp_util.debug('arp_process_line.val_insert_line()+');
568:
569: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
570: p_line_rec.customer_trx_id,
571: null);

Line 588: arp_util.debug('arp_process_line.val_insert_line()-');

584: p_line_rec.rule_start_date,
585: arp_global.set_of_books_id );
586: END IF;
587:
588: arp_util.debug('arp_process_line.val_insert_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');

Line 592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');

588: arp_util.debug('arp_process_line.val_insert_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:

Line 594: arp_util.debug('');

590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:
597: arp_ctl_pkg.display_line_rec(p_line_rec);
598:

Line 595: arp_util.debug('------ parameters for val_insert_line() -------');

591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:
597: arp_ctl_pkg.display_line_rec(p_line_rec);
598:
599: RAISE;

Line 613: | arp_util.debug |

609: | |
610: | SCOPE - PRIVATE |
611: | |
612: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
613: | arp_util.debug |
614: | |
615: | ARGUMENTS : IN: |
616: | p_line_rec - The line rec with the changed colums |
617: | p_db_line_rec - The old line record |

Line 648: arp_util.debug('arp_process_line.val_update_line()+');

644: l_line_rec ra_customer_trx_lines%rowtype;
645:
646: BEGIN
647:
648: arp_util.debug('arp_process_line.val_update_line()+');
649:
650:
651: arp_ctl_pkg.merge_line_recs( p_db_line_rec,
652: p_line_rec,

Line 663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');

659: +------------------------------------------*/
660:
661: IF (l_line_rec.line_type not in ('LINE', 'CHARGES', 'CB') )
662: THEN
663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
664: arp_util.debug(
665: 'The specified line is not of type LINE, CHARGES or CB');
666: fnd_message.set_name('AR', 'C-1647');
667: app_exception.raise_exception;

Line 664: arp_util.debug(

660:
661: IF (l_line_rec.line_type not in ('LINE', 'CHARGES', 'CB') )
662: THEN
663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
664: arp_util.debug(
665: 'The specified line is not of type LINE, CHARGES or CB');
666: fnd_message.set_name('AR', 'C-1647');
667: app_exception.raise_exception;
668: END IF;

Line 689: arp_util.debug('arp_process_line.val_update_line()-');

685: l_line_rec.rule_start_date,
686: arp_global.set_of_books_id );
687: END IF;
688:
689: arp_util.debug('arp_process_line.val_update_line()-');
690:
691:
692: EXCEPTION
693: WHEN OTHERS THEN

Line 694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');

690:
691:
692: EXCEPTION
693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:

Line 696: arp_util.debug('');

692: EXCEPTION
693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');

Line 697: arp_util.debug('------ parameters for val_update_line() -------');

693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);

Line 699: arp_util.debug('');

695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');

Line 700: arp_util.debug('------ new line record -------');

696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');

Line 703: arp_util.debug('');

699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');

Line 704: arp_util.debug('------ old line record -------');

700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');
708: arp_util.debug('------ merged line record -------');

Line 707: arp_util.debug('');

703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');
708: arp_util.debug('------ merged line record -------');
709: arp_ctl_pkg.display_line_rec(l_line_rec);
710:
711: RAISE;

Line 708: arp_util.debug('------ merged line record -------');

704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');
708: arp_util.debug('------ merged line record -------');
709: arp_ctl_pkg.display_line_rec(l_line_rec);
710:
711: RAISE;
712:

Line 725: | arp_util.debug |

721: | |
722: | SCOPE - PRIVATE |
723: | |
724: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
725: | arp_util.debug |
726: | |
727: | ARGUMENTS : IN: |
728: | p_line_rec |
729: | p_complete_flag |

Line 750: arp_util.debug('arp_process_line.val_delete_line()+');

746:
747:
748: BEGIN
749:
750: arp_util.debug('arp_process_line.val_delete_line()+');
751:
752: IF ( p_complete_flag = 'Y' )
753: THEN arp_trx_validate.check_has_one_line( p_line_rec.customer_trx_id );
754: END IF;

Line 757: arp_util.debug('arp_process_line.val_delete_line()-');

753: THEN arp_trx_validate.check_has_one_line( p_line_rec.customer_trx_id );
754: END IF;
755:
756:
757: arp_util.debug('arp_process_line.val_delete_line()-');
758:
759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');

Line 761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');

757: arp_util.debug('arp_process_line.val_delete_line()-');
758:
759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:

Line 763: arp_util.debug('');

759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:
766: arp_util.debug('p_complete_flag = ' || p_complete_flag);
767:

Line 764: arp_util.debug('------ parameters for val_delete_line() -------');

760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:
766: arp_util.debug('p_complete_flag = ' || p_complete_flag);
767:
768: arp_ctl_pkg.display_line_rec(p_line_rec);

Line 766: arp_util.debug('p_complete_flag = ' || p_complete_flag);

762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:
766: arp_util.debug('p_complete_flag = ' || p_complete_flag);
767:
768: arp_ctl_pkg.display_line_rec(p_line_rec);
769:
770: RAISE;

Line 784: | arp_util.debug |

780: | |
781: | SCOPE - PUBLIC |
782: | |
783: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
784: | arp_util.debug |
785: | |
786: | ARGUMENTS : IN: |
787: | p_form_name |
788: | p_form_version |

Line 912: arp_util.debug('arp_process_line.insert_line()+');

908:
909: l_mode VARCHAR2(50);
910: BEGIN
911:
912: arp_util.debug('arp_process_line.insert_line()+');
913:
914: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);
915:
916: p_rule_start_date := p_line_rec.rule_start_date;

Line 914: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);

910: BEGIN
911:
912: arp_util.debug('arp_process_line.insert_line()+');
913:
914: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);
915:
916: p_rule_start_date := p_line_rec.rule_start_date;
917: p_accounting_rule_duration := p_line_rec.accounting_rule_duration;
918:

Line 951: arp_util.debug('ARTECTLB: l_line_rec.amount_includes_tax_flag = ' || l_line_rec.amount_includes_tax_flag);

947: /*----------------------------------------------+
948: | Call the table handler to insert the line |
949: +----------------------------------------------*/
950:
951: arp_util.debug('ARTECTLB: l_line_rec.amount_includes_tax_flag = ' || l_line_rec.amount_includes_tax_flag);
952:
953: arp_ctl_pkg.insert_p( l_line_rec,
954: l_customer_trx_line_id);
955:

Line 1010: arp_util.debug(

1006: +-----------------------------------------------------------------*/
1007:
1008: BEGIN
1009:
1010: arp_util.debug(
1011: 'arp_process_line.insert_line before create_tax_f_ctl_id');
1012:
1013: -- Rel. 11: call to new tax engine procedure
1014: -- to handle tax-inclusive case:

Line 1019: arp_util.debug(' Before calling Calculate TAX ');

1015:
1016: l_extended_amount := p_line_rec.extended_amount;
1017: l_unit_selling_price := p_line_rec.unit_selling_price;
1018:
1019: arp_util.debug('**** Before calling Calculate TAX ****');
1020: arp_util.debug(' Parameters:');
1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);

Line 1020: arp_util.debug(' Parameters:');

1016: l_extended_amount := p_line_rec.extended_amount;
1017: l_unit_selling_price := p_line_rec.unit_selling_price;
1018:
1019: arp_util.debug('**** Before calling Calculate TAX ****');
1020: arp_util.debug(' Parameters:');
1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);

Line 1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);

1017: l_unit_selling_price := p_line_rec.unit_selling_price;
1018:
1019: arp_util.debug('**** Before calling Calculate TAX ****');
1020: arp_util.debug(' Parameters:');
1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1025: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);

Line 1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);

1018:
1019: arp_util.debug('**** Before calling Calculate TAX ****');
1020: arp_util.debug(' Parameters:');
1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1025: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1026:

Line 1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);

1019: arp_util.debug('**** Before calling Calculate TAX ****');
1020: arp_util.debug(' Parameters:');
1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1025: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1026:
1027:

Line 1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);

1020: arp_util.debug(' Parameters:');
1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1025: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1026:
1027:
1028: /* 5197390 - Handle tax-type memo lines */

Line 1025: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);

1021: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1022: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1023: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1024: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1025: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1026:
1027:
1028: /* 5197390 - Handle tax-type memo lines */
1029: IF p_memo_line_type = 'TAX'

Line 1032: arp_util.debug('Overridding mode to INSERT_NO_TAX');

1028: /* 5197390 - Handle tax-type memo lines */
1029: IF p_memo_line_type = 'TAX'
1030: THEN
1031: l_mode := 'INSERT_NO_TAX';
1032: arp_util.debug('Overridding mode to INSERT_NO_TAX');
1033: ELSE
1034: l_mode := 'INSERT';
1035: END IF;
1036:

Line 1058: arp_util.debug(

1054: l_line_rec.gross_unit_selling_price := l_gross_unit_selling_price;
1055:
1056: ****************************************************************************/
1057:
1058: arp_util.debug(
1059: 'arp_process_line.insert_line after create_tax_f_ctl_id');
1060:
1061: EXCEPTION
1062: WHEN OTHERS THEN

Line 1100: arp_util.debug(

1096: BEGIN
1097:
1098: -- arp_global.msg_level := 99;
1099:
1100: arp_util.debug(
1101: 'arp_process_line.insert_line before credit_transactions');
1102:
1103: arp_credit_memo_module.credit_transactions(
1104: p_line_rec.customer_trx_id,

Line 1115: arp_util.debug(

1111: l_accounting_rule_duration,
1112: p_run_autoaccounting_flag =>
1113: (p_run_autoacc_flag = 'Y'));
1114:
1115: arp_util.debug(
1116: 'arp_process_line.insert_line after credit_transactions');
1117:
1118: p_rule_start_date := l_rule_start_date;
1119: p_accounting_rule_duration := l_accounting_rule_duration;

Line 1170: arp_util.debug('l_status1 = ' || l_status1);

1166: END IF;
1167:
1168: END IF;
1169:
1170: arp_util.debug('l_status1 = ' || l_status1);
1171: arp_util.debug('l_status2 = ' || l_status2);
1172: arp_util.debug('l_status3 = ' || l_status3);
1173: arp_util.debug('l_status4 = ' || l_status4);
1174:

Line 1171: arp_util.debug('l_status2 = ' || l_status2);

1167:
1168: END IF;
1169:
1170: arp_util.debug('l_status1 = ' || l_status1);
1171: arp_util.debug('l_status2 = ' || l_status2);
1172: arp_util.debug('l_status3 = ' || l_status3);
1173: arp_util.debug('l_status4 = ' || l_status4);
1174:
1175: IF ( NVL(l_status1, 'OK') <> 'OK' )

Line 1172: arp_util.debug('l_status3 = ' || l_status3);

1168: END IF;
1169:
1170: arp_util.debug('l_status1 = ' || l_status1);
1171: arp_util.debug('l_status2 = ' || l_status2);
1172: arp_util.debug('l_status3 = ' || l_status3);
1173: arp_util.debug('l_status4 = ' || l_status4);
1174:
1175: IF ( NVL(l_status1, 'OK') <> 'OK' )
1176: THEN p_status := l_status1;

Line 1173: arp_util.debug('l_status4 = ' || l_status4);

1169:
1170: arp_util.debug('l_status1 = ' || l_status1);
1171: arp_util.debug('l_status2 = ' || l_status2);
1172: arp_util.debug('l_status3 = ' || l_status3);
1173: arp_util.debug('l_status4 = ' || l_status4);
1174:
1175: IF ( NVL(l_status1, 'OK') <> 'OK' )
1176: THEN p_status := l_status1;
1177: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1206: arp_util.debug('Stamping distributions with the transaction code when entered at line level');

1202:
1203: IF ( p_line_rec.previous_customer_trx_id IS NOT NULL AND l_dist_line IS NOT NULL)
1204:
1205: THEN
1206: arp_util.debug('Stamping distributions with the transaction code when entered at line level');
1207: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1208: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1209: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1210:

Line 1231: arp_util.debug('Completed stamping distributions with the transaction code when entered at line level');

1227: EXCEPTION
1228: when NO_DATA_FOUND then
1229: null;
1230: END;
1231: arp_util.debug('Completed stamping distributions with the transaction code when entered at line level');
1232: END IF;
1233:
1234:
1235: --Bug#2750340

Line 1247: arp_util.debug('arp_process_line.insert_line()-');

1243: l_ev_rec.xla_call := 'B';
1244: l_ev_rec.xla_fetch_size := 999;
1245: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1246:
1247: arp_util.debug('arp_process_line.insert_line()-');
1248:
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251:

Line 1253: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);

1249: EXCEPTION
1250: WHEN OTHERS THEN
1251:
1252: IF (l_errorbuf is not null)
1253: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
1254: END IF;
1255:
1256: /*---------------------------------------------+
1257: | Display parameters and raise the exception |

Line 1260: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');

1256: /*---------------------------------------------+
1257: | Display parameters and raise the exception |
1258: +---------------------------------------------*/
1259:
1260: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1261:
1262: arp_util.debug('');
1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:

Line 1262: arp_util.debug('');

1258: +---------------------------------------------*/
1259:
1260: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1261:
1262: arp_util.debug('');
1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:
1265: arp_util.debug('p_form_name = ' || p_form_name );
1266: arp_util.debug('p_form_version = ' || p_form_version);

Line 1263: arp_util.debug('---------- parameters for insert_line() ---------');

1259:
1260: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1261:
1262: arp_util.debug('');
1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:
1265: arp_util.debug('p_form_name = ' || p_form_name );
1266: arp_util.debug('p_form_version = ' || p_form_version);
1267: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);

Line 1265: arp_util.debug('p_form_name = ' || p_form_name );

1261:
1262: arp_util.debug('');
1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:
1265: arp_util.debug('p_form_name = ' || p_form_name );
1266: arp_util.debug('p_form_version = ' || p_form_version);
1267: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1268: arp_util.debug('');
1269:

Line 1266: arp_util.debug('p_form_version = ' || p_form_version);

1262: arp_util.debug('');
1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:
1265: arp_util.debug('p_form_name = ' || p_form_name );
1266: arp_util.debug('p_form_version = ' || p_form_version);
1267: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1268: arp_util.debug('');
1269:
1270: arp_ctl_pkg.display_line_rec(p_line_rec);

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

1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:
1265: arp_util.debug('p_form_name = ' || p_form_name );
1266: arp_util.debug('p_form_version = ' || p_form_version);
1267: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1268: arp_util.debug('');
1269:
1270: arp_ctl_pkg.display_line_rec(p_line_rec);
1271:

Line 1268: arp_util.debug('');

1264:
1265: arp_util.debug('p_form_name = ' || p_form_name );
1266: arp_util.debug('p_form_version = ' || p_form_version);
1267: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1268: arp_util.debug('');
1269:
1270: arp_ctl_pkg.display_line_rec(p_line_rec);
1271:
1272: RAISE;

Line 1287: | arp_util.debug |

1283: | |
1284: | SCOPE - PUBLIC |
1285: | |
1286: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1287: | arp_util.debug |
1288: | |
1289: | ARGUMENTS : IN: |
1290: | p_form_name |
1291: | p_form_version |

Line 1404: arp_util.debug('arp_process_line.update_line()+');

1400: l_test VARCHAR2(1);
1401: --}
1402: BEGIN
1403:
1404: arp_util.debug('arp_process_line.update_line()+');
1405:
1406: p_rule_start_date := p_line_rec.rule_start_date;
1407: p_accounting_rule_duration := p_line_rec.accounting_rule_duration;
1408:

Line 1476: arp_util.debug(

1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN
1475:
1476: arp_util.debug(
1477: 'arp_etax_services_pkg.before_update_line raised exception');
1478: RAISE;
1479: END;
1480:

Line 1568: arp_util.debug('ERROR COMPUTING TAX ');

1564: p_action => 'UPDATE',
1565: p_line_level_action => 'UPDATE');
1566:
1567: IF (NOT l_tax_computed) THEN
1568: arp_util.debug('ERROR COMPUTING TAX ');
1569: app_exception.raise_exception;
1570: END IF;
1571: *****************************************************************/
1572:

Line 1678: arp_util.debug('l_status1 = ' || l_status1);

1674: pg_base_precision,
1675: pg_base_min_acct_unit );
1676: END IF;
1677:
1678: arp_util.debug('l_status1 = ' || l_status1);
1679: arp_util.debug('l_status2 = ' || l_status2);
1680: arp_util.debug('l_status3 = ' || l_status3);
1681: arp_util.debug('l_status4 = ' || l_status4);
1682:

Line 1679: arp_util.debug('l_status2 = ' || l_status2);

1675: pg_base_min_acct_unit );
1676: END IF;
1677:
1678: arp_util.debug('l_status1 = ' || l_status1);
1679: arp_util.debug('l_status2 = ' || l_status2);
1680: arp_util.debug('l_status3 = ' || l_status3);
1681: arp_util.debug('l_status4 = ' || l_status4);
1682:
1683: IF ( NVL(l_status1, 'OK') <> 'OK' )

Line 1680: arp_util.debug('l_status3 = ' || l_status3);

1676: END IF;
1677:
1678: arp_util.debug('l_status1 = ' || l_status1);
1679: arp_util.debug('l_status2 = ' || l_status2);
1680: arp_util.debug('l_status3 = ' || l_status3);
1681: arp_util.debug('l_status4 = ' || l_status4);
1682:
1683: IF ( NVL(l_status1, 'OK') <> 'OK' )
1684: THEN p_status := l_status1;

Line 1681: arp_util.debug('l_status4 = ' || l_status4);

1677:
1678: arp_util.debug('l_status1 = ' || l_status1);
1679: arp_util.debug('l_status2 = ' || l_status2);
1680: arp_util.debug('l_status3 = ' || l_status3);
1681: arp_util.debug('l_status4 = ' || l_status4);
1682:
1683: IF ( NVL(l_status1, 'OK') <> 'OK' )
1684: THEN p_status := l_status1;
1685: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1716: arp_util.debug('Updating distributions with the transaction code when changed at line level');

1712: THEN
1713: IF nvl(l_db_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0) <> nvl(p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0)
1714: THEN
1715:
1716: arp_util.debug('Updating distributions with the transaction code when changed at line level');
1717: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1718: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1719: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1720:

Line 1742: arp_util.debug('Completed updating distributions with the transaction code when changed at line level');

1738: EXCEPTION
1739: when NO_DATA_FOUND then
1740: null;
1741: END;
1742: arp_util.debug('Completed updating distributions with the transaction code when changed at line level');
1743: END IF;
1744: END IF;
1745:
1746: OPEN cpost;

Line 1763: arp_util.debug('arp_process_line.update_line()-');

1759: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1760: END IF;
1761: CLOSE cpost;
1762:
1763: arp_util.debug('arp_process_line.update_line()-');
1764:
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767:

Line 1768: arp_util.debug('EXCEPTION: arp_process_line.update_line()');

1764:
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767:
1768: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1769:
1770: arp_util.debug('');
1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:

Line 1770: arp_util.debug('');

1766: WHEN OTHERS THEN
1767:
1768: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1769:
1770: arp_util.debug('');
1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:
1773: arp_util.debug('p_form_name = ' || p_form_name );
1774: arp_util.debug('p_form_version = ' || p_form_version);

Line 1771: arp_util.debug('---------- parameters for update_line() ---------');

1767:
1768: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1769:
1770: arp_util.debug('');
1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:
1773: arp_util.debug('p_form_name = ' || p_form_name );
1774: arp_util.debug('p_form_version = ' || p_form_version);
1775: arp_util.debug('p_customer_trx_line_id = ' ||

Line 1773: arp_util.debug('p_form_name = ' || p_form_name );

1769:
1770: arp_util.debug('');
1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:
1773: arp_util.debug('p_form_name = ' || p_form_name );
1774: arp_util.debug('p_form_version = ' || p_form_version);
1775: arp_util.debug('p_customer_trx_line_id = ' ||
1776: p_customer_trx_line_id);
1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);

Line 1774: arp_util.debug('p_form_version = ' || p_form_version);

1770: arp_util.debug('');
1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:
1773: arp_util.debug('p_form_name = ' || p_form_name );
1774: arp_util.debug('p_form_version = ' || p_form_version);
1775: arp_util.debug('p_customer_trx_line_id = ' ||
1776: p_customer_trx_line_id);
1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

Line 1775: arp_util.debug('p_customer_trx_line_id = ' ||

1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:
1773: arp_util.debug('p_form_name = ' || p_form_name );
1774: arp_util.debug('p_form_version = ' || p_form_version);
1775: arp_util.debug('p_customer_trx_line_id = ' ||
1776: p_customer_trx_line_id);
1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1779: arp_util.debug('p_recalculate_tax_flag = ' ||

Line 1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);

1773: arp_util.debug('p_form_name = ' || p_form_name );
1774: arp_util.debug('p_form_version = ' || p_form_version);
1775: arp_util.debug('p_customer_trx_line_id = ' ||
1776: p_customer_trx_line_id);
1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1779: arp_util.debug('p_recalculate_tax_flag = ' ||
1780: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1781: arp_util.debug('p_rerun_autoacc_flag = ' ||

Line 1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

1774: arp_util.debug('p_form_version = ' || p_form_version);
1775: arp_util.debug('p_customer_trx_line_id = ' ||
1776: p_customer_trx_line_id);
1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1779: arp_util.debug('p_recalculate_tax_flag = ' ||
1780: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1781: arp_util.debug('p_rerun_autoacc_flag = ' ||
1782: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));

Line 1779: arp_util.debug('p_recalculate_tax_flag = ' ||

1775: arp_util.debug('p_customer_trx_line_id = ' ||
1776: p_customer_trx_line_id);
1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1779: arp_util.debug('p_recalculate_tax_flag = ' ||
1780: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1781: arp_util.debug('p_rerun_autoacc_flag = ' ||
1782: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));
1783:

Line 1781: arp_util.debug('p_rerun_autoacc_flag = ' ||

1777: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1778: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1779: arp_util.debug('p_recalculate_tax_flag = ' ||
1780: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1781: arp_util.debug('p_rerun_autoacc_flag = ' ||
1782: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));
1783:
1784: arp_util.debug('');
1785:

Line 1784: arp_util.debug('');

1780: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1781: arp_util.debug('p_rerun_autoacc_flag = ' ||
1782: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));
1783:
1784: arp_util.debug('');
1785:
1786: arp_ctl_pkg.display_line_rec(p_line_rec);
1787:
1788: RAISE;

Line 1802: | arp_util.debug |

1798: | |
1799: | SCOPE - PUBLIC |
1800: | |
1801: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1802: | arp_util.debug |
1803: | |
1804: | ARGUMENTS : IN: |
1805: | p_form_name |
1806: | p_form_version |

Line 1877: arp_util.debug('arp_process_line.delete_line()+');

1873: where customer_trx_line_id = p_customer_trx_line_id
1874: FOR UPDATE OF customer_trx_line_id NOWAIT;
1875: BEGIN
1876:
1877: arp_util.debug('arp_process_line.delete_line()+');
1878:
1879: p_status := 'OK';
1880:
1881: /*----------------------------------------------+

Line 2025: arp_util.debug('arp_process_line.delete_line()-');

2021: -- (the tax may not be valid for the new trx_date)
2022: null;
2023: END IF;
2024:
2025: arp_util.debug('arp_process_line.delete_line()-');
2026:
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029:

Line 2034: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');

2030: /*---------------------------------------------+
2031: | Display parameters and raise the exception |
2032: +---------------------------------------------*/
2033:
2034: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2035:
2036: arp_util.debug('');
2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:

Line 2036: arp_util.debug('');

2032: +---------------------------------------------*/
2033:
2034: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2035:
2036: arp_util.debug('');
2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:
2039: arp_util.debug('p_form_name = ' || p_form_name );
2040: arp_util.debug('p_form_version = ' || p_form_version);

Line 2037: arp_util.debug('---------- parameters for delete_line() ---------');

2033:
2034: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2035:
2036: arp_util.debug('');
2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:
2039: arp_util.debug('p_form_name = ' || p_form_name );
2040: arp_util.debug('p_form_version = ' || p_form_version);
2041: arp_util.debug('p_customer_trx_line_id = ' ||

Line 2039: arp_util.debug('p_form_name = ' || p_form_name );

2035:
2036: arp_util.debug('');
2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:
2039: arp_util.debug('p_form_name = ' || p_form_name );
2040: arp_util.debug('p_form_version = ' || p_form_version);
2041: arp_util.debug('p_customer_trx_line_id = ' ||
2042: p_customer_trx_line_id);
2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);

Line 2040: arp_util.debug('p_form_version = ' || p_form_version);

2036: arp_util.debug('');
2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:
2039: arp_util.debug('p_form_name = ' || p_form_name );
2040: arp_util.debug('p_form_version = ' || p_form_version);
2041: arp_util.debug('p_customer_trx_line_id = ' ||
2042: p_customer_trx_line_id);
2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2044: arp_util.debug('p_recalculate_tax_flag = ' ||

Line 2041: arp_util.debug('p_customer_trx_line_id = ' ||

2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:
2039: arp_util.debug('p_form_name = ' || p_form_name );
2040: arp_util.debug('p_form_version = ' || p_form_version);
2041: arp_util.debug('p_customer_trx_line_id = ' ||
2042: p_customer_trx_line_id);
2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2044: arp_util.debug('p_recalculate_tax_flag = ' ||
2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));

Line 2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);

2039: arp_util.debug('p_form_name = ' || p_form_name );
2040: arp_util.debug('p_form_version = ' || p_form_version);
2041: arp_util.debug('p_customer_trx_line_id = ' ||
2042: p_customer_trx_line_id);
2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2044: arp_util.debug('p_recalculate_tax_flag = ' ||
2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

Line 2044: arp_util.debug('p_recalculate_tax_flag = ' ||

2040: arp_util.debug('p_form_version = ' || p_form_version);
2041: arp_util.debug('p_customer_trx_line_id = ' ||
2042: p_customer_trx_line_id);
2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2044: arp_util.debug('p_recalculate_tax_flag = ' ||
2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2048: arp_util.debug('p_gl_date = ' || p_gl_date);

Line 2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);

2042: p_customer_trx_line_id);
2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2044: arp_util.debug('p_recalculate_tax_flag = ' ||
2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2048: arp_util.debug('p_gl_date = ' || p_gl_date);
2049: arp_util.debug('p_trx_date = ' || p_trx_date);
2050: arp_util.debug('');

Line 2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

2043: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2044: arp_util.debug('p_recalculate_tax_flag = ' ||
2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2048: arp_util.debug('p_gl_date = ' || p_gl_date);
2049: arp_util.debug('p_trx_date = ' || p_trx_date);
2050: arp_util.debug('');
2051:

Line 2048: arp_util.debug('p_gl_date = ' || p_gl_date);

2044: arp_util.debug('p_recalculate_tax_flag = ' ||
2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2048: arp_util.debug('p_gl_date = ' || p_gl_date);
2049: arp_util.debug('p_trx_date = ' || p_trx_date);
2050: arp_util.debug('');
2051:
2052: arp_ctl_pkg.display_line_rec(p_line_rec);

Line 2049: arp_util.debug('p_trx_date = ' || p_trx_date);

2045: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2048: arp_util.debug('p_gl_date = ' || p_gl_date);
2049: arp_util.debug('p_trx_date = ' || p_trx_date);
2050: arp_util.debug('');
2051:
2052: arp_ctl_pkg.display_line_rec(p_line_rec);
2053:

Line 2050: arp_util.debug('');

2046: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2047: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2048: arp_util.debug('p_gl_date = ' || p_gl_date);
2049: arp_util.debug('p_trx_date = ' || p_trx_date);
2050: arp_util.debug('');
2051:
2052: arp_ctl_pkg.display_line_rec(p_line_rec);
2053:
2054: RAISE;

Line 2072: arp_util.debug('EXCEPTION: arp_process_line.initialization');

2068: pg_earliest_date := to_date('01/01/1901', 'DD/MM/YYYY');
2069:
2070: EXCEPTION
2071: WHEN OTHERS THEN
2072: arp_util.debug('EXCEPTION: arp_process_line.initialization');
2073: RAISE;
2074:
2075:
2076: END ARP_PROCESS_LINE;