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

Line 31: | arp_util.debug |

27: | |
28: | SCOPE - PRIVATE |
29: | |
30: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
31: | arp_util.debug |
32: | |
33: | ARGUMENTS : IN: l_trx_rec |
34: | OUT: l_status |
35: | IN/ OUT: |

Line 54: arp_util.debug('arp_process_header.validate_insert_header()+');

50: l_status OUT NOCOPY varchar2 ) IS
51:
52: BEGIN
53:
54: arp_util.debug('arp_process_header.validate_insert_header()+');
55: if l_trx_rec.complete_flag is null then
56: arp_util.debug('Complete flag cannot be null,Valid values are Y or N');
57: l_status := 'E';
58: return;

Line 56: arp_util.debug('Complete flag cannot be null,Valid values are Y or N');

52: BEGIN
53:
54: arp_util.debug('arp_process_header.validate_insert_header()+');
55: if l_trx_rec.complete_flag is null then
56: arp_util.debug('Complete flag cannot be null,Valid values are Y or N');
57: l_status := 'E';
58: return;
59: end if;
60: arp_util.debug('arp_process_header.validate_insert_header()-');

Line 60: arp_util.debug('arp_process_header.validate_insert_header()-');

56: arp_util.debug('Complete flag cannot be null,Valid values are Y or N');
57: l_status := 'E';
58: return;
59: end if;
60: arp_util.debug('arp_process_header.validate_insert_header()-');
61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: arp_util.debug('EXCEPTION: arp_process_header.validate_insert_header()');

Line 64: arp_util.debug('EXCEPTION: arp_process_header.validate_insert_header()');

60: arp_util.debug('arp_process_header.validate_insert_header()-');
61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: arp_util.debug('EXCEPTION: arp_process_header.validate_insert_header()');
65: RAISE;
66:
67: END;
68:

Line 80: | arp_util.debug |

76: | |
77: | SCOPE - PRIVATE |
78: | |
79: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
80: | arp_util.debug |
81: | |
82: | ARGUMENTS : IN: |
83: | OUT: |
84: | IN/ OUT: |

Line 99: arp_util.debug('arp_process_header.validate_update_header()+');

95: PROCEDURE validate_update_header IS
96:
97: BEGIN
98:
99: arp_util.debug('arp_process_header.validate_update_header()+');
100:
101: arp_util.debug('arp_process_header.validate_update_header()-');
102:
103: EXCEPTION

Line 101: arp_util.debug('arp_process_header.validate_update_header()-');

97: BEGIN
98:
99: arp_util.debug('arp_process_header.validate_update_header()+');
100:
101: arp_util.debug('arp_process_header.validate_update_header()-');
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: arp_util.debug('EXCEPTION: arp_process_header.validate_update_header()');

Line 105: arp_util.debug('EXCEPTION: arp_process_header.validate_update_header()');

101: arp_util.debug('arp_process_header.validate_update_header()-');
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: arp_util.debug('EXCEPTION: arp_process_header.validate_update_header()');
106: RAISE;
107:
108: END;
109:

Line 120: | arp_util.debug |

116: | |
117: | SCOPE - PRIVATE |
118: | |
119: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
120: | arp_util.debug |
121: | |
122: | ARGUMENTS : IN: |
123: | OUT: |
124: | IN/ OUT: |

Line 139: arp_util.debug('arp_process_header.validate_delete_header()+');

135: PROCEDURE validate_delete_header IS
136:
137: BEGIN
138:
139: arp_util.debug('arp_process_header.validate_delete_header()+');
140:
141: arp_util.debug('arp_process_header.validate_delete_header()-');
142:
143: EXCEPTION

Line 141: arp_util.debug('arp_process_header.validate_delete_header()-');

137: BEGIN
138:
139: arp_util.debug('arp_process_header.validate_delete_header()+');
140:
141: arp_util.debug('arp_process_header.validate_delete_header()-');
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: arp_util.debug('EXCEPTION: arp_process_header.validate_delete_header()');

Line 145: arp_util.debug('EXCEPTION: arp_process_header.validate_delete_header()');

141: arp_util.debug('arp_process_header.validate_delete_header()-');
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: arp_util.debug('EXCEPTION: arp_process_header.validate_delete_header()');
146: RAISE;
147:
148: END;
149:

Line 160: | arp_util.debug |

156: | |
157: | SCOPE - PRIVATE |
158: | |
159: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
160: | arp_util.debug |
161: | |
162: | ARGUMENTS : IN: |
163: | p_customer_trx_id |
164: | p_new_trx_rec |

Line 220: arp_util.debug('arp_process_header.set_flags()+');

216: ld_old_dispute_date DATE;
217:
218: BEGIN
219:
220: arp_util.debug('arp_process_header.set_flags()+');
221:
222: arp_ct_pkg.fetch_p(l_old_trx_rec,
223: p_customer_trx_id);
224:

Line 339: arp_util.debug('arp_process_header.set_flags()-');

335: ELSE
336: p_cust_trx_type_changed_flag := FALSE;
337: END IF;
338:
339: arp_util.debug('arp_process_header.set_flags()-');
340:
341:
342: EXCEPTION
343: WHEN OTHERS THEN

Line 349: arp_util.debug('EXCEPTION: arp_process_header.set_flags()');

345: /*---------------------------------------------+
346: | Display parameters and raise the exception |
347: +---------------------------------------------*/
348:
349: arp_util.debug('EXCEPTION: arp_process_header.set_flags()');
350:
351: arp_util.debug('');
352: arp_util.debug('---------- parameters for set_flags() ---------');
353:

Line 351: arp_util.debug('');

347: +---------------------------------------------*/
348:
349: arp_util.debug('EXCEPTION: arp_process_header.set_flags()');
350:
351: arp_util.debug('');
352: arp_util.debug('---------- parameters for set_flags() ---------');
353:
354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);

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

348:
349: arp_util.debug('EXCEPTION: arp_process_header.set_flags()');
350:
351: arp_util.debug('');
352: arp_util.debug('---------- parameters for set_flags() ---------');
353:
354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);
356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);

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

350:
351: arp_util.debug('');
352: arp_util.debug('---------- parameters for set_flags() ---------');
353:
354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);
356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);
357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));
358: arp_util.debug('');

Line 355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);

351: arp_util.debug('');
352: arp_util.debug('---------- parameters for set_flags() ---------');
353:
354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);
356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);
357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));
358: arp_util.debug('');
359:

Line 356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);

352: arp_util.debug('---------- parameters for set_flags() ---------');
353:
354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);
356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);
357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));
358: arp_util.debug('');
359:
360: arp_util.debug('---------- new transaction record ----------');

Line 357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));

353:
354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);
356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);
357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));
358: arp_util.debug('');
359:
360: arp_util.debug('---------- new transaction record ----------');
361: arp_ct_pkg.display_header_rec( p_new_trx_rec );

Line 358: arp_util.debug('');

354: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
355: arp_util.debug('p_new_gl_date = ' || p_new_gl_date);
356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);
357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));
358: arp_util.debug('');
359:
360: arp_util.debug('---------- new transaction record ----------');
361: arp_ct_pkg.display_header_rec( p_new_trx_rec );
362: arp_util.debug('');

Line 360: arp_util.debug('---------- new transaction record ----------');

356: arp_util.debug('p_new_open_rec_flag = ' || p_new_open_rec_flag);
357: arp_util.debug('p_ps_dispute_amount = ' || TO_CHAR(p_ps_dispute_amount));
358: arp_util.debug('');
359:
360: arp_util.debug('---------- new transaction record ----------');
361: arp_ct_pkg.display_header_rec( p_new_trx_rec );
362: arp_util.debug('');
363:
364: RAISE;

Line 362: arp_util.debug('');

358: arp_util.debug('');
359:
360: arp_util.debug('---------- new transaction record ----------');
361: arp_ct_pkg.display_header_rec( p_new_trx_rec );
362: arp_util.debug('');
363:
364: RAISE;
365:
366: END;

Line 378: | arp_util.debug |

374: | |
375: | SCOPE - PRIVATE |
376: | |
377: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
378: | arp_util.debug |
379: | |
380: | ARGUMENTS : IN: |
381: | OUT: |
382: | IN/ OUT: |

Line 415: arp_util.debug('arp_process_header.header_rerun_aa()+');

411: l_status7 varchar2(100);
412:
413: BEGIN
414:
415: arp_util.debug('arp_process_header.header_rerun_aa()+');
416:
417: BEGIN
418: arp_auto_accounting.do_autoaccounting(
419: 'U',

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

627: WHEN OTHERS THEN
628: RAISE;
629: END;
630:
631: arp_util.debug('l_status1 = ' || l_status1);
632: arp_util.debug('l_status2 = ' || l_status2);
633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);

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

628: RAISE;
629: END;
630:
631: arp_util.debug('l_status1 = ' || l_status1);
632: arp_util.debug('l_status2 = ' || l_status2);
633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);
636: arp_util.debug('l_status6 = ' || l_status6);

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

629: END;
630:
631: arp_util.debug('l_status1 = ' || l_status1);
632: arp_util.debug('l_status2 = ' || l_status2);
633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);
636: arp_util.debug('l_status6 = ' || l_status6);
637: arp_util.debug('l_status7 = ' || l_status7);

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

630:
631: arp_util.debug('l_status1 = ' || l_status1);
632: arp_util.debug('l_status2 = ' || l_status2);
633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);
636: arp_util.debug('l_status6 = ' || l_status6);
637: arp_util.debug('l_status7 = ' || l_status7);
638:

Line 635: arp_util.debug('l_status5 = ' || l_status5);

631: arp_util.debug('l_status1 = ' || l_status1);
632: arp_util.debug('l_status2 = ' || l_status2);
633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);
636: arp_util.debug('l_status6 = ' || l_status6);
637: arp_util.debug('l_status7 = ' || l_status7);
638:
639: IF ( NVL(l_status1, 'OK') <> 'OK' )

Line 636: arp_util.debug('l_status6 = ' || l_status6);

632: arp_util.debug('l_status2 = ' || l_status2);
633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);
636: arp_util.debug('l_status6 = ' || l_status6);
637: arp_util.debug('l_status7 = ' || l_status7);
638:
639: IF ( NVL(l_status1, 'OK') <> 'OK' )
640: THEN p_status := l_status1;

Line 637: arp_util.debug('l_status7 = ' || l_status7);

633: arp_util.debug('l_status3 = ' || l_status3);
634: arp_util.debug('l_status4 = ' || l_status4);
635: arp_util.debug('l_status5 = ' || l_status5);
636: arp_util.debug('l_status6 = ' || l_status6);
637: arp_util.debug('l_status7 = ' || l_status7);
638:
639: IF ( NVL(l_status1, 'OK') <> 'OK' )
640: THEN p_status := l_status1;
641: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 656: arp_util.debug('arp_process_header.header_rerun_aa()-');

652: THEN p_status := l_status7;
653: ELSE p_status := 'OK';
654: END IF;
655:
656: arp_util.debug('arp_process_header.header_rerun_aa()-');
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');

Line 660: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');

656: arp_util.debug('arp_process_header.header_rerun_aa()-');
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');
661: RAISE;
662:
663: END;
664:

Line 677: | arp_util.debug |

673: | |
674: | SCOPE - PRIVATE |
675: | |
676: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
677: | arp_util.debug |
678: | ARGUMENTS : |
679: | IN : p_customer_trx_id |
680: | OUT: |
681: | IN/ OUT: |

Line 700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');

696: l_line_rec ra_customer_trx_lines%rowtype;
697: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
698: BEGIN
699:
700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');
701:
702: arp_ctl_pkg.set_to_dummy( l_line_rec );
703:
704: l_line_rec.autorule_complete_flag := 'N';

Line 713: arp_util.debug('arp_process_header..reverse_revrec_effect: '||

709: p_customer_trx_id,
710: 'LINE');
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
714: 'no child lines to update.');
715: WHEN OTHERS THEN
716: arp_util.debug('EXCEPTION: '||
717: 'arp_process_header..reverse_revrec_effect()');

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

712: WHEN NO_DATA_FOUND THEN
713: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
714: 'no child lines to update.');
715: WHEN OTHERS THEN
716: arp_util.debug('EXCEPTION: '||
717: 'arp_process_header..reverse_revrec_effect()');
718: RAISE;
719: END;
720:

Line 732: arp_util.debug('arp_process_header.reverse_revrec_effect: '||

728: 'N',
729: NULL);
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
733: 'no dists to delete.');
734: WHEN OTHERS THEN
735: arp_util.debug('EXCEPTION: '||
736: 'arp_process_header.reverse_revrec_effect()');

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

731: WHEN NO_DATA_FOUND THEN
732: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
733: 'no dists to delete.');
734: WHEN OTHERS THEN
735: arp_util.debug('EXCEPTION: '||
736: 'arp_process_header.reverse_revrec_effect()');
737: RAISE;
738: END;
739:

Line 749: arp_util.debug('arp_process_header.reverse_revrec_effect: '||

745: 'Y',
746: 'REC');
747: EXCEPTION
748: WHEN NO_DATA_FOUND THEN
749: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
750: 'no dists to update.');
751: WHEN OTHERS THEN
752: arp_util.debug('EXCEPTION: '||
753: 'arp_process_header.reverse_revrec_effect()');

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

748: WHEN NO_DATA_FOUND THEN
749: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
750: 'no dists to update.');
751: WHEN OTHERS THEN
752: arp_util.debug('EXCEPTION: '||
753: 'arp_process_header.reverse_revrec_effect()');
754: RAISE;
755: END;
756: EXCEPTION

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

754: RAISE;
755: END;
756: EXCEPTION
757: WHEN OTHERS THEN
758: arp_util.debug('EXCEPTION: '||
759: 'arp_process_header.reverse_revrec_effect()');
760: RAISE;
761: END ;
762: /*===========================================================================+

Line 772: | arp_util.debug |

768: | |
769: | SCOPE - PUBLIC |
770: | |
771: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
772: | arp_util.debug |
773: | |
774: | ARGUMENTS : IN: |
775: | p_form_name |
776: | p_form_version |

Line 837: arp_util.debug('arp_process_header.insert_header()+');

833: l_dist_count NUMBER;
834:
835: BEGIN
836:
837: arp_util.debug('arp_process_header.insert_header()+');
838:
839: p_trx_number := '';
840: p_customer_trx_id := '';
841: l_trx_rec := p_trx_rec;

Line 851: arp_util.debug('Failed in validate insert header');

847: -- do validation
848: p_status := 'S';
849: validate_insert_header(p_trx_rec,p_status);
850: if p_status = 'E' then
851: arp_util.debug('Failed in validate insert header');
852: return;
853: end if;
854:
855: /*--------------------+

Line 984: arp_util.debug('EXCEPTION: Insert_Header');

980: pg_trx_header_level_rounding ,
981: 'N',
982: 'N') = 0 -- FALSE
983: THEN
984: arp_util.debug('EXCEPTION: Insert_Header');
985: arp_util.debug(l_error_message);
986: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
987: APP_EXCEPTION.raise_exception;
988: END IF;

Line 985: arp_util.debug(l_error_message);

981: 'N',
982: 'N') = 0 -- FALSE
983: THEN
984: arp_util.debug('EXCEPTION: Insert_Header');
985: arp_util.debug(l_error_message);
986: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
987: APP_EXCEPTION.raise_exception;
988: END IF;
989:

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

1004: p_form_version,
1005: l_trx_rec.term_id,
1006: p_term_in_use_flag);
1007:
1008: arp_util.debug('l_status1 = ' || l_status1);
1009: arp_util.debug('l_status2 = ' || l_status2);
1010:
1011: IF ( NVL(l_status1, 'OK') <> 'OK' )
1012: THEN p_status := l_status1;

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

1005: l_trx_rec.term_id,
1006: p_term_in_use_flag);
1007:
1008: arp_util.debug('l_status1 = ' || l_status1);
1009: arp_util.debug('l_status2 = ' || l_status2);
1010:
1011: IF ( NVL(l_status1, 'OK') <> 'OK' )
1012: THEN p_status := l_status1;
1013: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1034: arp_util.debug('arp_process_header.insert_header()-');

1030: l_ev_rec.xla_call := 'B';
1031: l_ev_rec.xla_fetch_size := 999;
1032: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1033:
1034: arp_util.debug('arp_process_header.insert_header()-');
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');

Line 1038: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');

1034: arp_util.debug('arp_process_header.insert_header()-');
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');
1039: RAISE;
1040:
1041: END;
1042:

Line 1053: | arp_util.debug |

1049: | |
1050: | SCOPE - PUBLIC |
1051: | |
1052: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1053: | arp_util.debug |
1054: | |
1055: | ARGUMENTS : IN: |
1056: | OUT: |
1057: | IN/ OUT: |

Line 1143: arp_util.debug('arp_process_header.update_header()+');

1139: l_post_to_gl varchar2(100);
1140: l_event_status_code varchar2(100);
1141: BEGIN
1142:
1143: arp_util.debug('arp_process_header.update_header()+');
1144:
1145: -- check form version to determine if it is compatible with the
1146: -- entity handler.
1147: arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

Line 1161: arp_util.debug('EXCEPTION: arp_trx_util.delete_lock()');

1157: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1158: FND_MESSAGE.SET_NAME('AR','AR_TW_RECORD_LOCKED');
1159: app_exception.raise_exception;
1160: WHEN OTHERS THEN
1161: arp_util.debug('EXCEPTION: arp_trx_util.delete_lock()');
1162: Raise;
1163: END;
1164:
1165: /*--------------------+

Line 1345: arp_util.debug('Clearing Lines and dist Rule Info ()+');

1341: p_trx_rec.invoicing_rule_id IS NULL AND
1342: l_old_trx_rec.invoicing_rule_id is not NULL
1343: )
1344: THEN
1345: arp_util.debug('Clearing Lines and dist Rule Info ()+');
1346: BEGIN
1347: Select 'X' INTO l_dummy_flag
1348: FROM ra_customer_trx_lines
1349: WHERE customer_trx_id = p_customer_trx_id

Line 1364: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||

1360: p_customer_trx_id,
1361: 'LINE');
1362: EXCEPTION
1363: WHEN NO_DATA_FOUND THEN
1364: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1365: 'no child lines to update.');
1366: WHEN OTHERS THEN
1367: arp_util.debug('EXCEPTION: '||
1368: 'arp_process_header..Clearing Lines Rule Info()');

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

1363: WHEN NO_DATA_FOUND THEN
1364: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1365: 'no child lines to update.');
1366: WHEN OTHERS THEN
1367: arp_util.debug('EXCEPTION: '||
1368: 'arp_process_header..Clearing Lines Rule Info()');
1369: RAISE;
1370: END;
1371: EXCEPTION

Line 1373: arp_util.debug('EXCEPTION: arp_process_header.update_header: '||

1369: RAISE;
1370: END;
1371: EXCEPTION
1372: WHEN NO_DATA_FOUND THEN
1373: arp_util.debug('EXCEPTION: arp_process_header.update_header: '||
1374: 'no child lines to clear rule info.');
1375: END;
1376: BEGIN
1377: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,

Line 1383: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||

1379: NULL);
1380: l_rerun_autoacc_flag := TRUE;
1381: EXCEPTION
1382: WHEN NO_DATA_FOUND THEN
1383: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1384: 'no dists to delete.');
1385: WHEN OTHERS THEN
1386: arp_util.debug('EXCEPTION: '||
1387: 'arp_process_header.Clearing GL Dist Rule Info ()');

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

1382: WHEN NO_DATA_FOUND THEN
1383: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1384: 'no dists to delete.');
1385: WHEN OTHERS THEN
1386: arp_util.debug('EXCEPTION: '||
1387: 'arp_process_header.Clearing GL Dist Rule Info ()');
1388: RAISE;
1389: END;
1390: arp_util.debug('Clearing Lines and dist Rule Info ()-');

Line 1390: arp_util.debug('Clearing Lines and dist Rule Info ()-');

1386: arp_util.debug('EXCEPTION: '||
1387: 'arp_process_header.Clearing GL Dist Rule Info ()');
1388: RAISE;
1389: END;
1390: arp_util.debug('Clearing Lines and dist Rule Info ()-');
1391: END IF;
1392:
1393:
1394: /*------------------------------------------------------------+

Line 1439: arp_util.debug('arp_process_header.update_header: '||

1435: null);
1436:
1437: EXCEPTION
1438: WHEN NO_DATA_FOUND THEN
1439: arp_util.debug('arp_process_header.update_header: '||
1440: 'no dists to update.');
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: '||
1443: 'arp_process_header.update_header()');

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

1438: WHEN NO_DATA_FOUND THEN
1439: arp_util.debug('arp_process_header.update_header: '||
1440: 'no dists to update.');
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: '||
1443: 'arp_process_header.update_header()');
1444: RAISE;
1445:
1446: END;

Line 1474: arp_util.debug( 'Before Update TAX P'|| pg_tax_flag);

1470:
1471: IF l_recalc_tax
1472: THEN
1473: pg_tax_flag := arp_trx_validate2.pg_tax_flag;
1474: arp_util.debug( 'Before Update TAX P'|| pg_tax_flag);
1475:
1476: /*------------------------------------------------------------------+
1477: | Do not update line tax codes when the Complete Flag is changed |
1478: | to 'Y' and the system option Enforce from Revenue Account is 'Y'.|

Line 1553: arp_util.debug('arp_process_header.update_header: '||

1549: 'LINE');
1550:
1551: EXCEPTION
1552: WHEN NO_DATA_FOUND THEN
1553: arp_util.debug('arp_process_header.update_header: '||
1554: 'no child lines to update.');
1555: WHEN OTHERS THEN
1556: arp_util.debug('EXCEPTION: '||
1557: 'arp_process_header.update_header()');

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

1552: WHEN NO_DATA_FOUND THEN
1553: arp_util.debug('arp_process_header.update_header: '||
1554: 'no child lines to update.');
1555: WHEN OTHERS THEN
1556: arp_util.debug('EXCEPTION: '||
1557: 'arp_process_header.update_header()');
1558: RAISE;
1559: END;
1560: END IF;

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

1623: p_trx_rec.term_id,
1624: p_term_in_use_flag);
1625: END IF;
1626:
1627: arp_util.debug('l_status1 = ' || l_status1);
1628: arp_util.debug('l_status2 = ' || l_status2);
1629: arp_util.debug('l_status3 = ' || l_status3);
1630:
1631: IF ( NVL(l_status1, 'OK') <> 'OK' )

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

1624: p_term_in_use_flag);
1625: END IF;
1626:
1627: arp_util.debug('l_status1 = ' || l_status1);
1628: arp_util.debug('l_status2 = ' || l_status2);
1629: arp_util.debug('l_status3 = ' || l_status3);
1630:
1631: IF ( NVL(l_status1, 'OK') <> 'OK' )
1632: THEN p_status := l_status1;

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

1625: END IF;
1626:
1627: arp_util.debug('l_status1 = ' || l_status1);
1628: arp_util.debug('l_status2 = ' || l_status2);
1629: arp_util.debug('l_status3 = ' || l_status3);
1630:
1631: IF ( NVL(l_status1, 'OK') <> 'OK' )
1632: THEN p_status := l_status1;
1633: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1697: arp_util.debug('Unable to get the XLA Entites Data ' ||

1693:
1694: END IF;
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: arp_util.debug('Unable to get the XLA Entites Data ' ||
1698: 'EXCEPTION: arp_process_header.update_header()' );
1699: --RAISE;
1700: END;
1701: END IF;

Line 1722: arp_util.debug('arp_process_header.update_header()-');

1718:
1719: END IF;
1720: CLOSE cpost;
1721:
1722: arp_util.debug('arp_process_header.update_header()-');
1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: arp_util.debug('EXCEPTION: arp_process_header.update_header()');

Line 1726: arp_util.debug('EXCEPTION: arp_process_header.update_header()');

1722: arp_util.debug('arp_process_header.update_header()-');
1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: arp_util.debug('EXCEPTION: arp_process_header.update_header()');
1727: RAISE;
1728:
1729: END;
1730:

Line 1742: | arp_util.debug |

1738: | |
1739: | SCOPE - PRIVATE |
1740: | |
1741: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1742: | arp_util.debug |
1743: | |
1744: | ARGUMENTS : IN: p_customer_trx_id | |
1745: | OUT: |
1746: | IN/ OUT: |

Line 1777: arp_util.debug('arp_process_header.delete_cont_defer_data+');

1773: FOR UPDATE OF customer_trx_id NOWAIT;
1774:
1775:
1776: BEGIN
1777: arp_util.debug('arp_process_header.delete_cont_defer_data+');
1778:
1779: FOR l_cont_rec IN cont_cursor LOOP
1780: delete from ar_line_conts
1781: where customer_trx_line_id = l_cont_rec.customer_trx_line_id;

Line 1789: arp_util.debug('arp_process_header.delete_cont_defer_data-');

1785: delete from ar_deferred_lines
1786: WHERE customer_trx_id = l_deferred_rec.customer_trx_id;
1787: END LOOP;
1788:
1789: arp_util.debug('arp_process_header.delete_cont_defer_data-');
1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN
1792: null;
1793: WHEN OTHERS THEN

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

1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN
1792: null;
1793: WHEN OTHERS THEN
1794: arp_util.debug('EXCEPTION : '||
1795: 'arp_process_header.delete_cont_defer_data()-');
1796: END;
1797:
1798:

Line 1809: | arp_util.debug |

1805: | |
1806: | SCOPE - PUBLIC |
1807: | |
1808: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1809: | arp_util.debug |
1810: | |
1811: | ARGUMENTS : IN: |
1812: | OUT: |
1813: | IN/ OUT: |

Line 1838: arp_util.debug('arp_process_header.delete_header()+');

1834: l_new_tax_amount NUMBER;
1835:
1836: BEGIN
1837:
1838: arp_util.debug('arp_process_header.delete_header()+');
1839:
1840: p_status := 'OK';
1841:
1842: -- check form version to determine if it is compatible with the

Line 1887: arp_util.debug('arp_process_header.delete_header()-');

1883:
1884:
1885:
1886:
1887: arp_util.debug('arp_process_header.delete_header()-');
1888:
1889: EXCEPTION
1890: WHEN OTHERS THEN
1891: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');

Line 1891: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');

1887: arp_util.debug('arp_process_header.delete_header()-');
1888:
1889: EXCEPTION
1890: WHEN OTHERS THEN
1891: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');
1892: RAISE;
1893:
1894: END;
1895:

Line 1907: | arp_util.debug |

1903: | |
1904: | SCOPE - PUBLIC |
1905: | |
1906: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1907: | arp_util.debug |
1908: | arp_maintain_ps.maintain_payment_schedules |
1909: | |
1910: | ARGUMENTS : IN: |
1911: | OUT: |

Line 1979: | arp_util.debug |

1975: | |
1976: | SCOPE - PUBLIC |
1977: | |
1978: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1979: | arp_util.debug |
1980: | |
1981: | ARGUMENTS : IN: |
1982: | p_form_name |
1983: | p_form_version |

Line 2024: arp_util.debug('arp_process_header.update_header_freight_cover()+');

2020: l_dummy varchar2(80);
2021:
2022: BEGIN
2023:
2024: arp_util.debug('arp_process_header.update_header_freight_cover()+');
2025:
2026: arp_ct_pkg.set_to_dummy(l_trx_rec);
2027:
2028: l_trx_rec.ship_via := p_ship_via;

Line 2051: arp_util.debug('arp_process_header.update_header_freight_cover()-');

2047: null,
2048: null,
2049: p_status);
2050:
2051: arp_util.debug('arp_process_header.update_header_freight_cover()-');
2052:
2053: EXCEPTION
2054: WHEN OTHERS THEN
2055: arp_util.debug('EXCEPTION : '||

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

2051: arp_util.debug('arp_process_header.update_header_freight_cover()-');
2052:
2053: EXCEPTION
2054: WHEN OTHERS THEN
2055: arp_util.debug('EXCEPTION : '||
2056: 'arp_process_header.update_header_freight_cover()-');
2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);

Line 2057: arp_util.debug('------- parameters for update_header_freight_cover ----');

2053: EXCEPTION
2054: WHEN OTHERS THEN
2055: arp_util.debug('EXCEPTION : '||
2056: 'arp_process_header.update_header_freight_cover()-');
2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);

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

2054: WHEN OTHERS THEN
2055: arp_util.debug('EXCEPTION : '||
2056: 'arp_process_header.update_header_freight_cover()-');
2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2062: arp_util.debug('p_waybill_number = '||p_waybill_number);

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

2055: arp_util.debug('EXCEPTION : '||
2056: 'arp_process_header.update_header_freight_cover()-');
2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2062: arp_util.debug('p_waybill_number = '||p_waybill_number);
2063: arp_util.debug('p_fob_point = '||p_fob_point);

Line 2060: arp_util.debug('p_ship_via = '||p_ship_via);

2056: 'arp_process_header.update_header_freight_cover()-');
2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2062: arp_util.debug('p_waybill_number = '||p_waybill_number);
2063: arp_util.debug('p_fob_point = '||p_fob_point);
2064:

Line 2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);

2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2062: arp_util.debug('p_waybill_number = '||p_waybill_number);
2063: arp_util.debug('p_fob_point = '||p_fob_point);
2064:
2065: RAISE;

Line 2062: arp_util.debug('p_waybill_number = '||p_waybill_number);

2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2062: arp_util.debug('p_waybill_number = '||p_waybill_number);
2063: arp_util.debug('p_fob_point = '||p_fob_point);
2064:
2065: RAISE;
2066: END;

Line 2063: arp_util.debug('p_fob_point = '||p_fob_point);

2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);
2061: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2062: arp_util.debug('p_waybill_number = '||p_waybill_number);
2063: arp_util.debug('p_fob_point = '||p_fob_point);
2064:
2065: RAISE;
2066: END;
2067:

Line 2087: | arp_util.debug |

2083: | |
2084: | SCOPE - PUBLIC |
2085: | |
2086: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2087: | arp_util.debug |
2088: | |
2089: | ARGUMENTS : IN: |
2090: | p_ct_rowid |
2091: | p_customer_trx_id |

Line 2372: arp_util.debug('arp_process_header.post_query()+');

2368: l_commit_memo_line_desc ar_memo_lines.description%type;
2369:
2370: BEGIN
2371:
2372: arp_util.debug('arp_process_header.post_query()+');
2373:
2374: /*-----------------------------------------+
2375: | Initialize the OUT NOCOPY parameters to NULL |
2376: +-----------------------------------------*/

Line 2766: arp_util.debug('');

2762: /*-----------------------------------------+
2763: | Print the results to the debug stream |
2764: +-----------------------------------------*/
2765:
2766: arp_util.debug('');
2767: arp_util.debug('======= results from post_query() =======');
2768: arp_util.debug('p_ct_commitment_trx_date = ' ||
2769: l_ct_commitment_trx_date);
2770: arp_util.debug('p_ct_commitment_number = ' ||

Line 2767: arp_util.debug('======= results from post_query() =======');

2763: | Print the results to the debug stream |
2764: +-----------------------------------------*/
2765:
2766: arp_util.debug('');
2767: arp_util.debug('======= results from post_query() =======');
2768: arp_util.debug('p_ct_commitment_trx_date = ' ||
2769: l_ct_commitment_trx_date);
2770: arp_util.debug('p_ct_commitment_number = ' ||
2771: l_ct_commitment_number);

Line 2768: arp_util.debug('p_ct_commitment_trx_date = ' ||

2764: +-----------------------------------------*/
2765:
2766: arp_util.debug('');
2767: arp_util.debug('======= results from post_query() =======');
2768: arp_util.debug('p_ct_commitment_trx_date = ' ||
2769: l_ct_commitment_trx_date);
2770: arp_util.debug('p_ct_commitment_number = ' ||
2771: l_ct_commitment_number);
2772: arp_util.debug('p_gd_commitment_gl_date = ' ||

Line 2770: arp_util.debug('p_ct_commitment_number = ' ||

2766: arp_util.debug('');
2767: arp_util.debug('======= results from post_query() =======');
2768: arp_util.debug('p_ct_commitment_trx_date = ' ||
2769: l_ct_commitment_trx_date);
2770: arp_util.debug('p_ct_commitment_number = ' ||
2771: l_ct_commitment_number);
2772: arp_util.debug('p_gd_commitment_gl_date = ' ||
2773: l_gd_commitment_gl_date);
2774: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||

Line 2772: arp_util.debug('p_gd_commitment_gl_date = ' ||

2768: arp_util.debug('p_ct_commitment_trx_date = ' ||
2769: l_ct_commitment_trx_date);
2770: arp_util.debug('p_ct_commitment_number = ' ||
2771: l_ct_commitment_number);
2772: arp_util.debug('p_gd_commitment_gl_date = ' ||
2773: l_gd_commitment_gl_date);
2774: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2775: l_ctl_commit_cust_trx_line_id);
2776: arp_util.debug('p_ctl_commitment_amount = ' ||

Line 2774: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||

2770: arp_util.debug('p_ct_commitment_number = ' ||
2771: l_ct_commitment_number);
2772: arp_util.debug('p_gd_commitment_gl_date = ' ||
2773: l_gd_commitment_gl_date);
2774: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2775: l_ctl_commit_cust_trx_line_id);
2776: arp_util.debug('p_ctl_commitment_amount = ' ||
2777: l_ctl_commitment_amount);
2778: arp_util.debug('p_ctl_commitment_text = ' ||

Line 2776: arp_util.debug('p_ctl_commitment_amount = ' ||

2772: arp_util.debug('p_gd_commitment_gl_date = ' ||
2773: l_gd_commitment_gl_date);
2774: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2775: l_ctl_commit_cust_trx_line_id);
2776: arp_util.debug('p_ctl_commitment_amount = ' ||
2777: l_ctl_commitment_amount);
2778: arp_util.debug('p_ctl_commitment_text = ' ||
2779: l_ctl_commitment_text);
2780: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||

Line 2778: arp_util.debug('p_ctl_commitment_text = ' ||

2774: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2775: l_ctl_commit_cust_trx_line_id);
2776: arp_util.debug('p_ctl_commitment_amount = ' ||
2777: l_ctl_commitment_amount);
2778: arp_util.debug('p_ctl_commitment_text = ' ||
2779: l_ctl_commitment_text);
2780: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2781: l_ctl_commitment_inv_item_id);
2782: arp_util.debug('p_interface_line_context = ' ||

Line 2780: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||

2776: arp_util.debug('p_ctl_commitment_amount = ' ||
2777: l_ctl_commitment_amount);
2778: arp_util.debug('p_ctl_commitment_text = ' ||
2779: l_ctl_commitment_text);
2780: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2781: l_ctl_commitment_inv_item_id);
2782: arp_util.debug('p_interface_line_context = ' ||
2783: l_interface_line_context);
2784: arp_util.debug('p_interface_line_attribute1 = ' ||

Line 2782: arp_util.debug('p_interface_line_context = ' ||

2778: arp_util.debug('p_ctl_commitment_text = ' ||
2779: l_ctl_commitment_text);
2780: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2781: l_ctl_commitment_inv_item_id);
2782: arp_util.debug('p_interface_line_context = ' ||
2783: l_interface_line_context);
2784: arp_util.debug('p_interface_line_attribute1 = ' ||
2785: l_interface_line_attribute1);
2786: arp_util.debug('p_interface_line_attribute2 = ' ||

Line 2784: arp_util.debug('p_interface_line_attribute1 = ' ||

2780: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2781: l_ctl_commitment_inv_item_id);
2782: arp_util.debug('p_interface_line_context = ' ||
2783: l_interface_line_context);
2784: arp_util.debug('p_interface_line_attribute1 = ' ||
2785: l_interface_line_attribute1);
2786: arp_util.debug('p_interface_line_attribute2 = ' ||
2787: l_interface_line_attribute2);
2788: arp_util.debug('p_interface_line_attribute3 = ' ||

Line 2786: arp_util.debug('p_interface_line_attribute2 = ' ||

2782: arp_util.debug('p_interface_line_context = ' ||
2783: l_interface_line_context);
2784: arp_util.debug('p_interface_line_attribute1 = ' ||
2785: l_interface_line_attribute1);
2786: arp_util.debug('p_interface_line_attribute2 = ' ||
2787: l_interface_line_attribute2);
2788: arp_util.debug('p_interface_line_attribute3 = ' ||
2789: l_interface_line_attribute3);
2790: arp_util.debug('p_interface_line_attribute4 = ' ||

Line 2788: arp_util.debug('p_interface_line_attribute3 = ' ||

2784: arp_util.debug('p_interface_line_attribute1 = ' ||
2785: l_interface_line_attribute1);
2786: arp_util.debug('p_interface_line_attribute2 = ' ||
2787: l_interface_line_attribute2);
2788: arp_util.debug('p_interface_line_attribute3 = ' ||
2789: l_interface_line_attribute3);
2790: arp_util.debug('p_interface_line_attribute4 = ' ||
2791: l_interface_line_attribute4);
2792: arp_util.debug('p_interface_line_attribute5 = ' ||

Line 2790: arp_util.debug('p_interface_line_attribute4 = ' ||

2786: arp_util.debug('p_interface_line_attribute2 = ' ||
2787: l_interface_line_attribute2);
2788: arp_util.debug('p_interface_line_attribute3 = ' ||
2789: l_interface_line_attribute3);
2790: arp_util.debug('p_interface_line_attribute4 = ' ||
2791: l_interface_line_attribute4);
2792: arp_util.debug('p_interface_line_attribute5 = ' ||
2793: l_interface_line_attribute5);
2794: arp_util.debug('p_interface_line_attribute6 = ' ||

Line 2792: arp_util.debug('p_interface_line_attribute5 = ' ||

2788: arp_util.debug('p_interface_line_attribute3 = ' ||
2789: l_interface_line_attribute3);
2790: arp_util.debug('p_interface_line_attribute4 = ' ||
2791: l_interface_line_attribute4);
2792: arp_util.debug('p_interface_line_attribute5 = ' ||
2793: l_interface_line_attribute5);
2794: arp_util.debug('p_interface_line_attribute6 = ' ||
2795: l_interface_line_attribute6);
2796: arp_util.debug('p_interface_line_attribute7 = ' ||

Line 2794: arp_util.debug('p_interface_line_attribute6 = ' ||

2790: arp_util.debug('p_interface_line_attribute4 = ' ||
2791: l_interface_line_attribute4);
2792: arp_util.debug('p_interface_line_attribute5 = ' ||
2793: l_interface_line_attribute5);
2794: arp_util.debug('p_interface_line_attribute6 = ' ||
2795: l_interface_line_attribute6);
2796: arp_util.debug('p_interface_line_attribute7 = ' ||
2797: l_interface_line_attribute7);
2798: arp_util.debug('p_interface_line_attribute8 = ' ||

Line 2796: arp_util.debug('p_interface_line_attribute7 = ' ||

2792: arp_util.debug('p_interface_line_attribute5 = ' ||
2793: l_interface_line_attribute5);
2794: arp_util.debug('p_interface_line_attribute6 = ' ||
2795: l_interface_line_attribute6);
2796: arp_util.debug('p_interface_line_attribute7 = ' ||
2797: l_interface_line_attribute7);
2798: arp_util.debug('p_interface_line_attribute8 = ' ||
2799: l_interface_line_attribute8);
2800: arp_util.debug('p_interface_line_attribute9 = ' ||

Line 2798: arp_util.debug('p_interface_line_attribute8 = ' ||

2794: arp_util.debug('p_interface_line_attribute6 = ' ||
2795: l_interface_line_attribute6);
2796: arp_util.debug('p_interface_line_attribute7 = ' ||
2797: l_interface_line_attribute7);
2798: arp_util.debug('p_interface_line_attribute8 = ' ||
2799: l_interface_line_attribute8);
2800: arp_util.debug('p_interface_line_attribute9 = ' ||
2801: l_interface_line_attribute9);
2802: arp_util.debug('p_interface_line_attribute10 = ' ||

Line 2800: arp_util.debug('p_interface_line_attribute9 = ' ||

2796: arp_util.debug('p_interface_line_attribute7 = ' ||
2797: l_interface_line_attribute7);
2798: arp_util.debug('p_interface_line_attribute8 = ' ||
2799: l_interface_line_attribute8);
2800: arp_util.debug('p_interface_line_attribute9 = ' ||
2801: l_interface_line_attribute9);
2802: arp_util.debug('p_interface_line_attribute10 = ' ||
2803: l_interface_line_attribute10);
2804: arp_util.debug('p_interface_line_attribute11 = ' ||

Line 2802: arp_util.debug('p_interface_line_attribute10 = ' ||

2798: arp_util.debug('p_interface_line_attribute8 = ' ||
2799: l_interface_line_attribute8);
2800: arp_util.debug('p_interface_line_attribute9 = ' ||
2801: l_interface_line_attribute9);
2802: arp_util.debug('p_interface_line_attribute10 = ' ||
2803: l_interface_line_attribute10);
2804: arp_util.debug('p_interface_line_attribute11 = ' ||
2805: l_interface_line_attribute11);
2806: arp_util.debug('p_interface_line_attribute12 = ' ||

Line 2804: arp_util.debug('p_interface_line_attribute11 = ' ||

2800: arp_util.debug('p_interface_line_attribute9 = ' ||
2801: l_interface_line_attribute9);
2802: arp_util.debug('p_interface_line_attribute10 = ' ||
2803: l_interface_line_attribute10);
2804: arp_util.debug('p_interface_line_attribute11 = ' ||
2805: l_interface_line_attribute11);
2806: arp_util.debug('p_interface_line_attribute12 = ' ||
2807: l_interface_line_attribute12);
2808: arp_util.debug('p_interface_line_attribute13 = ' ||

Line 2806: arp_util.debug('p_interface_line_attribute12 = ' ||

2802: arp_util.debug('p_interface_line_attribute10 = ' ||
2803: l_interface_line_attribute10);
2804: arp_util.debug('p_interface_line_attribute11 = ' ||
2805: l_interface_line_attribute11);
2806: arp_util.debug('p_interface_line_attribute12 = ' ||
2807: l_interface_line_attribute12);
2808: arp_util.debug('p_interface_line_attribute13 = ' ||
2809: l_interface_line_attribute13);
2810: arp_util.debug('p_interface_line_attribute14 = ' ||

Line 2808: arp_util.debug('p_interface_line_attribute13 = ' ||

2804: arp_util.debug('p_interface_line_attribute11 = ' ||
2805: l_interface_line_attribute11);
2806: arp_util.debug('p_interface_line_attribute12 = ' ||
2807: l_interface_line_attribute12);
2808: arp_util.debug('p_interface_line_attribute13 = ' ||
2809: l_interface_line_attribute13);
2810: arp_util.debug('p_interface_line_attribute14 = ' ||
2811: l_interface_line_attribute14);
2812: arp_util.debug('p_interface_line_attribute15 = ' ||

Line 2810: arp_util.debug('p_interface_line_attribute14 = ' ||

2806: arp_util.debug('p_interface_line_attribute12 = ' ||
2807: l_interface_line_attribute12);
2808: arp_util.debug('p_interface_line_attribute13 = ' ||
2809: l_interface_line_attribute13);
2810: arp_util.debug('p_interface_line_attribute14 = ' ||
2811: l_interface_line_attribute14);
2812: arp_util.debug('p_interface_line_attribute15 = ' ||
2813: l_interface_line_attribute15);
2814: arp_util.debug('p_attribute_category = ' ||

Line 2812: arp_util.debug('p_interface_line_attribute15 = ' ||

2808: arp_util.debug('p_interface_line_attribute13 = ' ||
2809: l_interface_line_attribute13);
2810: arp_util.debug('p_interface_line_attribute14 = ' ||
2811: l_interface_line_attribute14);
2812: arp_util.debug('p_interface_line_attribute15 = ' ||
2813: l_interface_line_attribute15);
2814: arp_util.debug('p_attribute_category = ' ||
2815: l_attribute_category);
2816: arp_util.debug('p_attribute1 = ' ||

Line 2814: arp_util.debug('p_attribute_category = ' ||

2810: arp_util.debug('p_interface_line_attribute14 = ' ||
2811: l_interface_line_attribute14);
2812: arp_util.debug('p_interface_line_attribute15 = ' ||
2813: l_interface_line_attribute15);
2814: arp_util.debug('p_attribute_category = ' ||
2815: l_attribute_category);
2816: arp_util.debug('p_attribute1 = ' ||
2817: l_attribute1);
2818: arp_util.debug('p_attribute2 = ' ||

Line 2816: arp_util.debug('p_attribute1 = ' ||

2812: arp_util.debug('p_interface_line_attribute15 = ' ||
2813: l_interface_line_attribute15);
2814: arp_util.debug('p_attribute_category = ' ||
2815: l_attribute_category);
2816: arp_util.debug('p_attribute1 = ' ||
2817: l_attribute1);
2818: arp_util.debug('p_attribute2 = ' ||
2819: l_attribute2);
2820: arp_util.debug('p_attribute3 = ' ||

Line 2818: arp_util.debug('p_attribute2 = ' ||

2814: arp_util.debug('p_attribute_category = ' ||
2815: l_attribute_category);
2816: arp_util.debug('p_attribute1 = ' ||
2817: l_attribute1);
2818: arp_util.debug('p_attribute2 = ' ||
2819: l_attribute2);
2820: arp_util.debug('p_attribute3 = ' ||
2821: l_attribute3);
2822: arp_util.debug('p_attribute4 = ' ||

Line 2820: arp_util.debug('p_attribute3 = ' ||

2816: arp_util.debug('p_attribute1 = ' ||
2817: l_attribute1);
2818: arp_util.debug('p_attribute2 = ' ||
2819: l_attribute2);
2820: arp_util.debug('p_attribute3 = ' ||
2821: l_attribute3);
2822: arp_util.debug('p_attribute4 = ' ||
2823: l_attribute4);
2824: arp_util.debug('p_attribute5 = ' ||

Line 2822: arp_util.debug('p_attribute4 = ' ||

2818: arp_util.debug('p_attribute2 = ' ||
2819: l_attribute2);
2820: arp_util.debug('p_attribute3 = ' ||
2821: l_attribute3);
2822: arp_util.debug('p_attribute4 = ' ||
2823: l_attribute4);
2824: arp_util.debug('p_attribute5 = ' ||
2825: l_attribute5);
2826: arp_util.debug('p_attribute6 = ' ||

Line 2824: arp_util.debug('p_attribute5 = ' ||

2820: arp_util.debug('p_attribute3 = ' ||
2821: l_attribute3);
2822: arp_util.debug('p_attribute4 = ' ||
2823: l_attribute4);
2824: arp_util.debug('p_attribute5 = ' ||
2825: l_attribute5);
2826: arp_util.debug('p_attribute6 = ' ||
2827: l_attribute6);
2828: arp_util.debug('p_attribute7 = ' ||

Line 2826: arp_util.debug('p_attribute6 = ' ||

2822: arp_util.debug('p_attribute4 = ' ||
2823: l_attribute4);
2824: arp_util.debug('p_attribute5 = ' ||
2825: l_attribute5);
2826: arp_util.debug('p_attribute6 = ' ||
2827: l_attribute6);
2828: arp_util.debug('p_attribute7 = ' ||
2829: l_attribute7);
2830: arp_util.debug('p_attribute8 = ' ||

Line 2828: arp_util.debug('p_attribute7 = ' ||

2824: arp_util.debug('p_attribute5 = ' ||
2825: l_attribute5);
2826: arp_util.debug('p_attribute6 = ' ||
2827: l_attribute6);
2828: arp_util.debug('p_attribute7 = ' ||
2829: l_attribute7);
2830: arp_util.debug('p_attribute8 = ' ||
2831: l_attribute8);
2832: arp_util.debug('p_attribute9 = ' ||

Line 2830: arp_util.debug('p_attribute8 = ' ||

2826: arp_util.debug('p_attribute6 = ' ||
2827: l_attribute6);
2828: arp_util.debug('p_attribute7 = ' ||
2829: l_attribute7);
2830: arp_util.debug('p_attribute8 = ' ||
2831: l_attribute8);
2832: arp_util.debug('p_attribute9 = ' ||
2833: l_attribute9);
2834: arp_util.debug('p_attribute10 = ' ||

Line 2832: arp_util.debug('p_attribute9 = ' ||

2828: arp_util.debug('p_attribute7 = ' ||
2829: l_attribute7);
2830: arp_util.debug('p_attribute8 = ' ||
2831: l_attribute8);
2832: arp_util.debug('p_attribute9 = ' ||
2833: l_attribute9);
2834: arp_util.debug('p_attribute10 = ' ||
2835: l_attribute10);
2836: arp_util.debug('p_attribute11 = ' ||

Line 2834: arp_util.debug('p_attribute10 = ' ||

2830: arp_util.debug('p_attribute8 = ' ||
2831: l_attribute8);
2832: arp_util.debug('p_attribute9 = ' ||
2833: l_attribute9);
2834: arp_util.debug('p_attribute10 = ' ||
2835: l_attribute10);
2836: arp_util.debug('p_attribute11 = ' ||
2837: l_attribute11);
2838: arp_util.debug('p_attribute12 = ' ||

Line 2836: arp_util.debug('p_attribute11 = ' ||

2832: arp_util.debug('p_attribute9 = ' ||
2833: l_attribute9);
2834: arp_util.debug('p_attribute10 = ' ||
2835: l_attribute10);
2836: arp_util.debug('p_attribute11 = ' ||
2837: l_attribute11);
2838: arp_util.debug('p_attribute12 = ' ||
2839: l_attribute12);
2840: arp_util.debug('p_attribute13 = ' ||

Line 2838: arp_util.debug('p_attribute12 = ' ||

2834: arp_util.debug('p_attribute10 = ' ||
2835: l_attribute10);
2836: arp_util.debug('p_attribute11 = ' ||
2837: l_attribute11);
2838: arp_util.debug('p_attribute12 = ' ||
2839: l_attribute12);
2840: arp_util.debug('p_attribute13 = ' ||
2841: l_attribute13);
2842: arp_util.debug('p_attribute14 = ' ||

Line 2840: arp_util.debug('p_attribute13 = ' ||

2836: arp_util.debug('p_attribute11 = ' ||
2837: l_attribute11);
2838: arp_util.debug('p_attribute12 = ' ||
2839: l_attribute12);
2840: arp_util.debug('p_attribute13 = ' ||
2841: l_attribute13);
2842: arp_util.debug('p_attribute14 = ' ||
2843: l_attribute14);
2844: arp_util.debug('p_attribute15 = ' ||

Line 2842: arp_util.debug('p_attribute14 = ' ||

2838: arp_util.debug('p_attribute12 = ' ||
2839: l_attribute12);
2840: arp_util.debug('p_attribute13 = ' ||
2841: l_attribute13);
2842: arp_util.debug('p_attribute14 = ' ||
2843: l_attribute14);
2844: arp_util.debug('p_attribute15 = ' ||
2845: l_attribute15);
2846: arp_util.debug('p_default_ussgl_trx_code = ' ||

Line 2844: arp_util.debug('p_attribute15 = ' ||

2840: arp_util.debug('p_attribute13 = ' ||
2841: l_attribute13);
2842: arp_util.debug('p_attribute14 = ' ||
2843: l_attribute14);
2844: arp_util.debug('p_attribute15 = ' ||
2845: l_attribute15);
2846: arp_util.debug('p_default_ussgl_trx_code = ' ||
2847: l_default_ussgl_trx_code);
2848: arp_util.debug('p_ct_prev_trx_number = ' ||

Line 2846: arp_util.debug('p_default_ussgl_trx_code = ' ||

2842: arp_util.debug('p_attribute14 = ' ||
2843: l_attribute14);
2844: arp_util.debug('p_attribute15 = ' ||
2845: l_attribute15);
2846: arp_util.debug('p_default_ussgl_trx_code = ' ||
2847: l_default_ussgl_trx_code);
2848: arp_util.debug('p_ct_prev_trx_number = ' ||
2849: l_ct_prev_trx_number);
2850: arp_util.debug('p_ct_prev_trx_reference = ' ||

Line 2848: arp_util.debug('p_ct_prev_trx_number = ' ||

2844: arp_util.debug('p_attribute15 = ' ||
2845: l_attribute15);
2846: arp_util.debug('p_default_ussgl_trx_code = ' ||
2847: l_default_ussgl_trx_code);
2848: arp_util.debug('p_ct_prev_trx_number = ' ||
2849: l_ct_prev_trx_number);
2850: arp_util.debug('p_ct_prev_trx_reference = ' ||
2851: l_ct_prev_trx_reference);
2852: arp_util.debug('p_ct_prev_inv_currency_code = ' ||

Line 2850: arp_util.debug('p_ct_prev_trx_reference = ' ||

2846: arp_util.debug('p_default_ussgl_trx_code = ' ||
2847: l_default_ussgl_trx_code);
2848: arp_util.debug('p_ct_prev_trx_number = ' ||
2849: l_ct_prev_trx_number);
2850: arp_util.debug('p_ct_prev_trx_reference = ' ||
2851: l_ct_prev_trx_reference);
2852: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2853: l_ct_prev_inv_currency_code);
2854: arp_util.debug('p_ct_prev_trx_date = ' ||

Line 2852: arp_util.debug('p_ct_prev_inv_currency_code = ' ||

2848: arp_util.debug('p_ct_prev_trx_number = ' ||
2849: l_ct_prev_trx_number);
2850: arp_util.debug('p_ct_prev_trx_reference = ' ||
2851: l_ct_prev_trx_reference);
2852: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2853: l_ct_prev_inv_currency_code);
2854: arp_util.debug('p_ct_prev_trx_date = ' ||
2855: l_ct_prev_trx_date);
2856: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||

Line 2854: arp_util.debug('p_ct_prev_trx_date = ' ||

2850: arp_util.debug('p_ct_prev_trx_reference = ' ||
2851: l_ct_prev_trx_reference);
2852: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2853: l_ct_prev_inv_currency_code);
2854: arp_util.debug('p_ct_prev_trx_date = ' ||
2855: l_ct_prev_trx_date);
2856: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2857: l_ct_prev_bill_to_customer_id);
2858: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||

Line 2856: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||

2852: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2853: l_ct_prev_inv_currency_code);
2854: arp_util.debug('p_ct_prev_trx_date = ' ||
2855: l_ct_prev_trx_date);
2856: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2857: l_ct_prev_bill_to_customer_id);
2858: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2859: l_ct_prev_ship_to_customer_id);
2860: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||

Line 2858: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||

2854: arp_util.debug('p_ct_prev_trx_date = ' ||
2855: l_ct_prev_trx_date);
2856: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2857: l_ct_prev_bill_to_customer_id);
2858: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2859: l_ct_prev_ship_to_customer_id);
2860: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2861: l_ct_prev_sold_to_customer_id);
2862: arp_util.debug('p_ct_prev_paying_customer_id = ' ||

Line 2860: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||

2856: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2857: l_ct_prev_bill_to_customer_id);
2858: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2859: l_ct_prev_ship_to_customer_id);
2860: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2861: l_ct_prev_sold_to_customer_id);
2862: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2863: l_ct_prev_paying_customer_id);
2864: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||

Line 2862: arp_util.debug('p_ct_prev_paying_customer_id = ' ||

2858: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2859: l_ct_prev_ship_to_customer_id);
2860: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2861: l_ct_prev_sold_to_customer_id);
2862: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2863: l_ct_prev_paying_customer_id);
2864: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2865: l_ct_prev_bill_to_site_use_id);
2866: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||

Line 2864: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||

2860: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2861: l_ct_prev_sold_to_customer_id);
2862: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2863: l_ct_prev_paying_customer_id);
2864: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2865: l_ct_prev_bill_to_site_use_id);
2866: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2867: l_ct_prev_ship_to_site_use_id);
2868: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||

Line 2866: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||

2862: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2863: l_ct_prev_paying_customer_id);
2864: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2865: l_ct_prev_bill_to_site_use_id);
2866: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2867: l_ct_prev_ship_to_site_use_id);
2868: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2869: l_ct_prev_paying_site_use_id);
2870: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||

Line 2868: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||

2864: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2865: l_ct_prev_bill_to_site_use_id);
2866: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2867: l_ct_prev_ship_to_site_use_id);
2868: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2869: l_ct_prev_paying_site_use_id);
2870: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2871: l_ct_prev_bill_to_contact_id);
2872: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||

Line 2870: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||

2866: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2867: l_ct_prev_ship_to_site_use_id);
2868: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2869: l_ct_prev_paying_site_use_id);
2870: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2871: l_ct_prev_bill_to_contact_id);
2872: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2873: l_ct_prev_ship_to_contact_id);
2874: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||

Line 2872: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||

2868: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2869: l_ct_prev_paying_site_use_id);
2870: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2871: l_ct_prev_bill_to_contact_id);
2872: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2873: l_ct_prev_ship_to_contact_id);
2874: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2875: l_ct_prev_initial_cust_trx_id);
2876: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||

Line 2874: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||

2870: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2871: l_ct_prev_bill_to_contact_id);
2872: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2873: l_ct_prev_ship_to_contact_id);
2874: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2875: l_ct_prev_initial_cust_trx_id);
2876: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2877: l_ct_prev_primary_salesrep_id);
2878: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||

Line 2876: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||

2872: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2873: l_ct_prev_ship_to_contact_id);
2874: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2875: l_ct_prev_initial_cust_trx_id);
2876: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2877: l_ct_prev_primary_salesrep_id);
2878: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2879: l_ct_prev_invoicing_rule_id);
2880: arp_util.debug('p_gd_prev_gl_date = ' ||

Line 2878: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||

2874: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2875: l_ct_prev_initial_cust_trx_id);
2876: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2877: l_ct_prev_primary_salesrep_id);
2878: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2879: l_ct_prev_invoicing_rule_id);
2880: arp_util.debug('p_gd_prev_gl_date = ' ||
2881: l_gd_prev_gl_date);
2882: arp_util.debug('p_prev_trx_original = ' ||

Line 2880: arp_util.debug('p_gd_prev_gl_date = ' ||

2876: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2877: l_ct_prev_primary_salesrep_id);
2878: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2879: l_ct_prev_invoicing_rule_id);
2880: arp_util.debug('p_gd_prev_gl_date = ' ||
2881: l_gd_prev_gl_date);
2882: arp_util.debug('p_prev_trx_original = ' ||
2883: l_prev_trx_original);
2884: arp_util.debug('p_prev_trx_balance = ' ||

Line 2882: arp_util.debug('p_prev_trx_original = ' ||

2878: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2879: l_ct_prev_invoicing_rule_id);
2880: arp_util.debug('p_gd_prev_gl_date = ' ||
2881: l_gd_prev_gl_date);
2882: arp_util.debug('p_prev_trx_original = ' ||
2883: l_prev_trx_original);
2884: arp_util.debug('p_prev_trx_balance = ' ||
2885: l_prev_trx_balance);
2886: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||

Line 2884: arp_util.debug('p_prev_trx_balance = ' ||

2880: arp_util.debug('p_gd_prev_gl_date = ' ||
2881: l_gd_prev_gl_date);
2882: arp_util.debug('p_prev_trx_original = ' ||
2883: l_prev_trx_original);
2884: arp_util.debug('p_prev_trx_balance = ' ||
2885: l_prev_trx_balance);
2886: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2887: l_rac_prev_bill_to_cust_name);
2888: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||

Line 2886: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||

2882: arp_util.debug('p_prev_trx_original = ' ||
2883: l_prev_trx_original);
2884: arp_util.debug('p_prev_trx_balance = ' ||
2885: l_prev_trx_balance);
2886: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2887: l_rac_prev_bill_to_cust_name);
2888: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2889: l_rac_prev_bill_to_cust_num);
2890: arp_util.debug('p_bs_prev_source_name = ' ||

Line 2888: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||

2884: arp_util.debug('p_prev_trx_balance = ' ||
2885: l_prev_trx_balance);
2886: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2887: l_rac_prev_bill_to_cust_name);
2888: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2889: l_rac_prev_bill_to_cust_num);
2890: arp_util.debug('p_bs_prev_source_name = ' ||
2891: l_bs_prev_source_name);
2892: arp_util.debug('p_ctt_prev_class = ' ||

Line 2890: arp_util.debug('p_bs_prev_source_name = ' ||

2886: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2887: l_rac_prev_bill_to_cust_name);
2888: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2889: l_rac_prev_bill_to_cust_num);
2890: arp_util.debug('p_bs_prev_source_name = ' ||
2891: l_bs_prev_source_name);
2892: arp_util.debug('p_ctt_prev_class = ' ||
2893: l_ctt_prev_class);
2894: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||

Line 2892: arp_util.debug('p_ctt_prev_class = ' ||

2888: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2889: l_rac_prev_bill_to_cust_num);
2890: arp_util.debug('p_bs_prev_source_name = ' ||
2891: l_bs_prev_source_name);
2892: arp_util.debug('p_ctt_prev_class = ' ||
2893: l_ctt_prev_class);
2894: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2895: l_ctt_prev_allow_overapp_flag);
2896: arp_util.debug('p_ctt_prev_natural_app_only = ' ||

Line 2894: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||

2890: arp_util.debug('p_bs_prev_source_name = ' ||
2891: l_bs_prev_source_name);
2892: arp_util.debug('p_ctt_prev_class = ' ||
2893: l_ctt_prev_class);
2894: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2895: l_ctt_prev_allow_overapp_flag);
2896: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2897: l_ctt_prev_natural_app_only);
2898: arp_util.debug('p_ct_prev_open_receivables = ' ||

Line 2896: arp_util.debug('p_ctt_prev_natural_app_only = ' ||

2892: arp_util.debug('p_ctt_prev_class = ' ||
2893: l_ctt_prev_class);
2894: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2895: l_ctt_prev_allow_overapp_flag);
2896: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2897: l_ctt_prev_natural_app_only);
2898: arp_util.debug('p_ct_prev_open_receivables = ' ||
2899: l_ct_prev_open_receivables);
2900: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||

Line 2898: arp_util.debug('p_ct_prev_open_receivables = ' ||

2894: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2895: l_ctt_prev_allow_overapp_flag);
2896: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2897: l_ctt_prev_natural_app_only);
2898: arp_util.debug('p_ct_prev_open_receivables = ' ||
2899: l_ct_prev_open_receivables);
2900: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||
2901: l_ct_prev_post_to_gl_flag );
2902: arp_util.debug('p_al_cm_reason_meaning = ' ||

Line 2900: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||

2896: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2897: l_ctt_prev_natural_app_only);
2898: arp_util.debug('p_ct_prev_open_receivables = ' ||
2899: l_ct_prev_open_receivables);
2900: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||
2901: l_ct_prev_post_to_gl_flag );
2902: arp_util.debug('p_al_cm_reason_meaning = ' ||
2903: l_al_cm_reason_meaning);
2904:

Line 2902: arp_util.debug('p_al_cm_reason_meaning = ' ||

2898: arp_util.debug('p_ct_prev_open_receivables = ' ||
2899: l_ct_prev_open_receivables);
2900: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||
2901: l_ct_prev_post_to_gl_flag );
2902: arp_util.debug('p_al_cm_reason_meaning = ' ||
2903: l_al_cm_reason_meaning);
2904:
2905: arp_util.debug('arp_process_header.post_query()-');
2906:

Line 2905: arp_util.debug('arp_process_header.post_query()-');

2901: l_ct_prev_post_to_gl_flag );
2902: arp_util.debug('p_al_cm_reason_meaning = ' ||
2903: l_al_cm_reason_meaning);
2904:
2905: arp_util.debug('arp_process_header.post_query()-');
2906:
2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: arp_util.debug('EXCEPTION : '||

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

2905: arp_util.debug('arp_process_header.post_query()-');
2906:
2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: arp_util.debug('EXCEPTION : '||
2910: 'arp_process_header.post_query()-');
2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);

Line 2911: arp_util.debug('------- parameters for post_query ----');

2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: arp_util.debug('EXCEPTION : '||
2910: 'arp_process_header.post_query()-');
2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2915: arp_util.debug('p_initial_customer_trx_id = ' ||

Line 2912: arp_util.debug('p_class = ' || p_class);

2908: WHEN OTHERS THEN
2909: arp_util.debug('EXCEPTION : '||
2910: 'arp_process_header.post_query()-');
2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2915: arp_util.debug('p_initial_customer_trx_id = ' ||
2916: p_initial_customer_trx_id);

Line 2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);

2909: arp_util.debug('EXCEPTION : '||
2910: 'arp_process_header.post_query()-');
2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2915: arp_util.debug('p_initial_customer_trx_id = ' ||
2916: p_initial_customer_trx_id);
2917: arp_util.debug('p_previous_customer_trx_id = ' ||

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

2910: 'arp_process_header.post_query()-');
2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2915: arp_util.debug('p_initial_customer_trx_id = ' ||
2916: p_initial_customer_trx_id);
2917: arp_util.debug('p_previous_customer_trx_id = ' ||
2918: p_previous_customer_trx_id);

Line 2915: arp_util.debug('p_initial_customer_trx_id = ' ||

2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2915: arp_util.debug('p_initial_customer_trx_id = ' ||
2916: p_initial_customer_trx_id);
2917: arp_util.debug('p_previous_customer_trx_id = ' ||
2918: p_previous_customer_trx_id);
2919:

Line 2917: arp_util.debug('p_previous_customer_trx_id = ' ||

2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2915: arp_util.debug('p_initial_customer_trx_id = ' ||
2916: p_initial_customer_trx_id);
2917: arp_util.debug('p_previous_customer_trx_id = ' ||
2918: p_previous_customer_trx_id);
2919:
2920: RAISE;
2921: END;