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 441: arp_util.debug('arp_process_header.header_rerun_aa()+');

437:
438:
439: BEGIN
440:
441: arp_util.debug('arp_process_header.header_rerun_aa()+');
442:
443:
444: -- Bug9005547
445: -- Delete the existing event_id that has been latched to the GLD rows:

Line 447: arp_util.debug('header_rerun_a: Deleting existing events');

443:
444: -- Bug9005547
445: -- Delete the existing event_id that has been latched to the GLD rows:
446: BEGIN
447: arp_util.debug('header_rerun_a: Deleting existing events');
448:
449: FOR c IN c_ct loop
450:
451: l_event_id := c.event_id;

Line 467: arp_util.debug('header_rerun_a: Completed deleting existing events');

463: p_security_context => l_security);
464:
465: END loop;
466:
467: arp_util.debug('header_rerun_a: Completed deleting existing events');
468: EXCEPTION
469: WHEN OTHERS THEN
470: arp_util.debug('EXCEPTION: header_rerun_aa : delete events'||SQLERRM);
471: RAISE;

Line 470: arp_util.debug('EXCEPTION: header_rerun_aa : delete events'||SQLERRM);

466:
467: arp_util.debug('header_rerun_a: Completed deleting existing events');
468: EXCEPTION
469: WHEN OTHERS THEN
470: arp_util.debug('EXCEPTION: header_rerun_aa : delete events'||SQLERRM);
471: RAISE;
472: END;
473:
474: BEGIN

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

684: WHEN OTHERS THEN
685: RAISE;
686: END;
687:
688: arp_util.debug('l_status1 = ' || l_status1);
689: arp_util.debug('l_status2 = ' || l_status2);
690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);

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

685: RAISE;
686: END;
687:
688: arp_util.debug('l_status1 = ' || l_status1);
689: arp_util.debug('l_status2 = ' || l_status2);
690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);
693: arp_util.debug('l_status6 = ' || l_status6);

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

686: END;
687:
688: arp_util.debug('l_status1 = ' || l_status1);
689: arp_util.debug('l_status2 = ' || l_status2);
690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);
693: arp_util.debug('l_status6 = ' || l_status6);
694: arp_util.debug('l_status7 = ' || l_status7);

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

687:
688: arp_util.debug('l_status1 = ' || l_status1);
689: arp_util.debug('l_status2 = ' || l_status2);
690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);
693: arp_util.debug('l_status6 = ' || l_status6);
694: arp_util.debug('l_status7 = ' || l_status7);
695:

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

688: arp_util.debug('l_status1 = ' || l_status1);
689: arp_util.debug('l_status2 = ' || l_status2);
690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);
693: arp_util.debug('l_status6 = ' || l_status6);
694: arp_util.debug('l_status7 = ' || l_status7);
695:
696: IF ( NVL(l_status1, 'OK') <> 'OK' )

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

689: arp_util.debug('l_status2 = ' || l_status2);
690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);
693: arp_util.debug('l_status6 = ' || l_status6);
694: arp_util.debug('l_status7 = ' || l_status7);
695:
696: IF ( NVL(l_status1, 'OK') <> 'OK' )
697: THEN p_status := l_status1;

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

690: arp_util.debug('l_status3 = ' || l_status3);
691: arp_util.debug('l_status4 = ' || l_status4);
692: arp_util.debug('l_status5 = ' || l_status5);
693: arp_util.debug('l_status6 = ' || l_status6);
694: arp_util.debug('l_status7 = ' || l_status7);
695:
696: IF ( NVL(l_status1, 'OK') <> 'OK' )
697: THEN p_status := l_status1;
698: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

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

709: THEN p_status := l_status7;
710: ELSE p_status := 'OK';
711: END IF;
712:
713: arp_util.debug('arp_process_header.header_rerun_aa()-');
714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');

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

713: arp_util.debug('arp_process_header.header_rerun_aa()-');
714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');
718: RAISE;
719:
720: END;
721:

Line 734: | arp_util.debug |

730: | |
731: | SCOPE - PRIVATE |
732: | |
733: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
734: | arp_util.debug |
735: | ARGUMENTS : |
736: | IN : p_customer_trx_id |
737: | OUT: |
738: | IN/ OUT: |

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

753: l_line_rec ra_customer_trx_lines%rowtype;
754: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
755: BEGIN
756:
757: arp_util.debug('arp_process_header.reverse_revrec_effect()+');
758:
759: arp_ctl_pkg.set_to_dummy( l_line_rec );
760:
761: l_line_rec.autorule_complete_flag := 'N';

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

766: p_customer_trx_id,
767: 'LINE');
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
771: 'no child lines to update.');
772: WHEN OTHERS THEN
773: arp_util.debug('EXCEPTION: '||
774: 'arp_process_header..reverse_revrec_effect()');

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

769: WHEN NO_DATA_FOUND THEN
770: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
771: 'no child lines to update.');
772: WHEN OTHERS THEN
773: arp_util.debug('EXCEPTION: '||
774: 'arp_process_header..reverse_revrec_effect()');
775: RAISE;
776: END;
777:

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

785: 'N',
786: NULL);
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
790: 'no dists to delete.');
791: WHEN OTHERS THEN
792: arp_util.debug('EXCEPTION: '||
793: 'arp_process_header.reverse_revrec_effect()');

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

788: WHEN NO_DATA_FOUND THEN
789: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
790: 'no dists to delete.');
791: WHEN OTHERS THEN
792: arp_util.debug('EXCEPTION: '||
793: 'arp_process_header.reverse_revrec_effect()');
794: RAISE;
795: END;
796:

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

802: 'Y',
803: 'REC');
804: EXCEPTION
805: WHEN NO_DATA_FOUND THEN
806: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
807: 'no dists to update.');
808: WHEN OTHERS THEN
809: arp_util.debug('EXCEPTION: '||
810: 'arp_process_header.reverse_revrec_effect()');

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

805: WHEN NO_DATA_FOUND THEN
806: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
807: 'no dists to update.');
808: WHEN OTHERS THEN
809: arp_util.debug('EXCEPTION: '||
810: 'arp_process_header.reverse_revrec_effect()');
811: RAISE;
812: END;
813: EXCEPTION

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

811: RAISE;
812: END;
813: EXCEPTION
814: WHEN OTHERS THEN
815: arp_util.debug('EXCEPTION: '||
816: 'arp_process_header.reverse_revrec_effect()');
817: RAISE;
818: END ;
819: /*===========================================================================+

Line 829: | arp_util.debug |

825: | |
826: | SCOPE - PUBLIC |
827: | |
828: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
829: | arp_util.debug |
830: | |
831: | ARGUMENTS : IN: |
832: | p_form_name |
833: | p_form_version |

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

890: l_dist_count NUMBER;
891:
892: BEGIN
893:
894: arp_util.debug('arp_process_header.insert_header()+');
895:
896: p_trx_number := '';
897: p_customer_trx_id := '';
898: l_trx_rec := p_trx_rec;

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

904: -- do validation
905: p_status := 'S';
906: validate_insert_header(p_trx_rec,p_status);
907: if p_status = 'E' then
908: arp_util.debug('Failed in validate insert header');
909: return;
910: end if;
911:
912: /*--------------------+

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

1037: pg_trx_header_level_rounding ,
1038: 'N',
1039: 'N') = 0 -- FALSE
1040: THEN
1041: arp_util.debug('EXCEPTION: Insert_Header');
1042: arp_util.debug(l_error_message);
1043: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
1044: APP_EXCEPTION.raise_exception;
1045: END IF;

Line 1042: arp_util.debug(l_error_message);

1038: 'N',
1039: 'N') = 0 -- FALSE
1040: THEN
1041: arp_util.debug('EXCEPTION: Insert_Header');
1042: arp_util.debug(l_error_message);
1043: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
1044: APP_EXCEPTION.raise_exception;
1045: END IF;
1046:

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

1061: p_form_version,
1062: l_trx_rec.term_id,
1063: p_term_in_use_flag);
1064:
1065: arp_util.debug('l_status1 = ' || l_status1);
1066: arp_util.debug('l_status2 = ' || l_status2);
1067:
1068: IF ( NVL(l_status1, 'OK') <> 'OK' )
1069: THEN p_status := l_status1;

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

1062: l_trx_rec.term_id,
1063: p_term_in_use_flag);
1064:
1065: arp_util.debug('l_status1 = ' || l_status1);
1066: arp_util.debug('l_status2 = ' || l_status2);
1067:
1068: IF ( NVL(l_status1, 'OK') <> 'OK' )
1069: THEN p_status := l_status1;
1070: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

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

1087: l_ev_rec.xla_call := 'B';
1088: l_ev_rec.xla_fetch_size := 999;
1089: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1090:
1091: arp_util.debug('arp_process_header.insert_header()-');
1092:
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');

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

1091: arp_util.debug('arp_process_header.insert_header()-');
1092:
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');
1096: RAISE;
1097:
1098: END;
1099:

Line 1110: | arp_util.debug |

1106: | |
1107: | SCOPE - PUBLIC |
1108: | |
1109: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1110: | arp_util.debug |
1111: | |
1112: | ARGUMENTS : IN: |
1113: | OUT: |
1114: | IN/ OUT: |

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

1196: l_post_to_gl varchar2(100);
1197: l_event_status_code varchar2(100);
1198: BEGIN
1199:
1200: arp_util.debug('arp_process_header.update_header()+');
1201:
1202: -- check form version to determine if it is compatible with the
1203: -- entity handler.
1204: arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

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

1214: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1215: FND_MESSAGE.SET_NAME('AR','AR_TW_RECORD_LOCKED');
1216: app_exception.raise_exception;
1217: WHEN OTHERS THEN
1218: arp_util.debug('EXCEPTION: arp_trx_util.delete_lock()');
1219: Raise;
1220: END;
1221:
1222: /*--------------------+

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

1398: p_trx_rec.invoicing_rule_id IS NULL AND
1399: l_old_trx_rec.invoicing_rule_id is not NULL
1400: )
1401: THEN
1402: arp_util.debug('Clearing Lines and dist Rule Info ()+');
1403: BEGIN
1404: Select 'X' INTO l_dummy_flag
1405: FROM ra_customer_trx_lines
1406: WHERE customer_trx_id = p_customer_trx_id

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

1417: p_customer_trx_id,
1418: 'LINE');
1419: EXCEPTION
1420: WHEN NO_DATA_FOUND THEN
1421: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1422: 'no child lines to update.');
1423: WHEN OTHERS THEN
1424: arp_util.debug('EXCEPTION: '||
1425: 'arp_process_header..Clearing Lines Rule Info()');

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

1420: WHEN NO_DATA_FOUND THEN
1421: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1422: 'no child lines to update.');
1423: WHEN OTHERS THEN
1424: arp_util.debug('EXCEPTION: '||
1425: 'arp_process_header..Clearing Lines Rule Info()');
1426: RAISE;
1427: END;
1428: EXCEPTION

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

1426: RAISE;
1427: END;
1428: EXCEPTION
1429: WHEN NO_DATA_FOUND THEN
1430: arp_util.debug('EXCEPTION: arp_process_header.update_header: '||
1431: 'no child lines to clear rule info.');
1432: END;
1433: BEGIN
1434: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,

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

1436: NULL);
1437: l_rerun_autoacc_flag := TRUE;
1438: EXCEPTION
1439: WHEN NO_DATA_FOUND THEN
1440: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1441: 'no dists to delete.');
1442: WHEN OTHERS THEN
1443: arp_util.debug('EXCEPTION: '||
1444: 'arp_process_header.Clearing GL Dist Rule Info ()');

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

1439: WHEN NO_DATA_FOUND THEN
1440: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1441: 'no dists to delete.');
1442: WHEN OTHERS THEN
1443: arp_util.debug('EXCEPTION: '||
1444: 'arp_process_header.Clearing GL Dist Rule Info ()');
1445: RAISE;
1446: END;
1447: arp_util.debug('Clearing Lines and dist Rule Info ()-');

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

1443: arp_util.debug('EXCEPTION: '||
1444: 'arp_process_header.Clearing GL Dist Rule Info ()');
1445: RAISE;
1446: END;
1447: arp_util.debug('Clearing Lines and dist Rule Info ()-');
1448: END IF;
1449:
1450:
1451: /*------------------------------------------------------------+

Line 1489: arp_util.debug('Calling reverse_revrec_effect to delete non modal row +');

1485: arpt_sql_func_util.get_nonmodal_row_exist_flag(
1486: p_trx_rec.Customer_trx_id,
1487: p_trx_rec.invoicing_rule_id) = 'Y')
1488: THEN
1489: arp_util.debug('Calling reverse_revrec_effect to delete non modal row +');
1490: reverse_revrec_effect(p_customer_trx_id);
1491: arp_util.debug('Calling reverse_revrec_effect to delete non modal row -');
1492: END IF;
1493:

Line 1491: arp_util.debug('Calling reverse_revrec_effect to delete non modal row -');

1487: p_trx_rec.invoicing_rule_id) = 'Y')
1488: THEN
1489: arp_util.debug('Calling reverse_revrec_effect to delete non modal row +');
1490: reverse_revrec_effect(p_customer_trx_id);
1491: arp_util.debug('Calling reverse_revrec_effect to delete non modal row -');
1492: END IF;
1493:
1494:
1495:

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

1515: null);
1516:
1517: EXCEPTION
1518: WHEN NO_DATA_FOUND THEN
1519: arp_util.debug('arp_process_header.update_header: '||
1520: 'no dists to update.');
1521: WHEN OTHERS THEN
1522: arp_util.debug('EXCEPTION: '||
1523: 'arp_process_header.update_header()');

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

1518: WHEN NO_DATA_FOUND THEN
1519: arp_util.debug('arp_process_header.update_header: '||
1520: 'no dists to update.');
1521: WHEN OTHERS THEN
1522: arp_util.debug('EXCEPTION: '||
1523: 'arp_process_header.update_header()');
1524: RAISE;
1525:
1526: END;

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

1550:
1551: IF l_recalc_tax
1552: THEN
1553: pg_tax_flag := arp_trx_validate2.pg_tax_flag;
1554: arp_util.debug( 'Before Update TAX P'|| pg_tax_flag);
1555:
1556: /*------------------------------------------------------------------+
1557: | Do not update line tax codes when the Complete Flag is changed |
1558: | to 'Y' and the system option Enforce from Revenue Account is 'Y'.|

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

1629: 'LINE');
1630:
1631: EXCEPTION
1632: WHEN NO_DATA_FOUND THEN
1633: arp_util.debug('arp_process_header.update_header: '||
1634: 'no child lines to update.');
1635: WHEN OTHERS THEN
1636: arp_util.debug('EXCEPTION: '||
1637: 'arp_process_header.update_header()');

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

1632: WHEN NO_DATA_FOUND THEN
1633: arp_util.debug('arp_process_header.update_header: '||
1634: 'no child lines to update.');
1635: WHEN OTHERS THEN
1636: arp_util.debug('EXCEPTION: '||
1637: 'arp_process_header.update_header()');
1638: RAISE;
1639: END;
1640: END IF;

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

1703: p_trx_rec.term_id,
1704: p_term_in_use_flag);
1705: END IF;
1706:
1707: arp_util.debug('l_status1 = ' || l_status1);
1708: arp_util.debug('l_status2 = ' || l_status2);
1709: arp_util.debug('l_status3 = ' || l_status3);
1710:
1711: IF ( NVL(l_status1, 'OK') <> 'OK' )

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

1704: p_term_in_use_flag);
1705: END IF;
1706:
1707: arp_util.debug('l_status1 = ' || l_status1);
1708: arp_util.debug('l_status2 = ' || l_status2);
1709: arp_util.debug('l_status3 = ' || l_status3);
1710:
1711: IF ( NVL(l_status1, 'OK') <> 'OK' )
1712: THEN p_status := l_status1;

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

1705: END IF;
1706:
1707: arp_util.debug('l_status1 = ' || l_status1);
1708: arp_util.debug('l_status2 = ' || l_status2);
1709: arp_util.debug('l_status3 = ' || l_status3);
1710:
1711: IF ( NVL(l_status1, 'OK') <> 'OK' )
1712: THEN p_status := l_status1;
1713: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

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

1773:
1774: END IF;
1775: EXCEPTION
1776: WHEN OTHERS THEN
1777: arp_util.debug('Unable to get the XLA Entites Data ' ||
1778: 'EXCEPTION: arp_process_header.update_header()' );
1779: --RAISE;
1780: END;
1781: END IF;

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

1798:
1799: END IF;
1800: CLOSE cpost;
1801:
1802: arp_util.debug('arp_process_header.update_header()-');
1803:
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: arp_util.debug('EXCEPTION: arp_process_header.update_header()');

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

1802: arp_util.debug('arp_process_header.update_header()-');
1803:
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: arp_util.debug('EXCEPTION: arp_process_header.update_header()');
1807: RAISE;
1808:
1809: END;
1810:

Line 1822: | arp_util.debug |

1818: | |
1819: | SCOPE - PRIVATE |
1820: | |
1821: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1822: | arp_util.debug |
1823: | |
1824: | ARGUMENTS : IN: p_customer_trx_id | |
1825: | OUT: |
1826: | IN/ OUT: |

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

1853: FOR UPDATE OF customer_trx_id NOWAIT;
1854:
1855:
1856: BEGIN
1857: arp_util.debug('arp_process_header.delete_cont_defer_data+');
1858:
1859: FOR l_cont_rec IN cont_cursor LOOP
1860: delete from ar_line_conts
1861: where customer_trx_line_id = l_cont_rec.customer_trx_line_id;

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

1865: delete from ar_deferred_lines
1866: WHERE customer_trx_id = l_deferred_rec.customer_trx_id;
1867: END LOOP;
1868:
1869: arp_util.debug('arp_process_header.delete_cont_defer_data-');
1870: EXCEPTION
1871: WHEN NO_DATA_FOUND THEN
1872: null;
1873: WHEN OTHERS THEN

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

1870: EXCEPTION
1871: WHEN NO_DATA_FOUND THEN
1872: null;
1873: WHEN OTHERS THEN
1874: arp_util.debug('EXCEPTION : '||
1875: 'arp_process_header.delete_cont_defer_data()-');
1876: END;
1877:
1878:

Line 1889: | arp_util.debug |

1885: | |
1886: | SCOPE - PUBLIC |
1887: | |
1888: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1889: | arp_util.debug |
1890: | |
1891: | ARGUMENTS : IN: |
1892: | OUT: |
1893: | IN/ OUT: |

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

1914: l_new_tax_amount NUMBER;
1915:
1916: BEGIN
1917:
1918: arp_util.debug('arp_process_header.delete_header()+');
1919:
1920: p_status := 'OK';
1921:
1922: -- check form version to determine if it is compatible with the

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

1963:
1964:
1965:
1966:
1967: arp_util.debug('arp_process_header.delete_header()-');
1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');

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

1967: arp_util.debug('arp_process_header.delete_header()-');
1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');
1972: RAISE;
1973:
1974: END;
1975:

Line 1987: | arp_util.debug |

1983: | |
1984: | SCOPE - PUBLIC |
1985: | |
1986: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1987: | arp_util.debug |
1988: | arp_maintain_ps.maintain_payment_schedules |
1989: | |
1990: | ARGUMENTS : IN: |
1991: | OUT: |

Line 2059: | arp_util.debug |

2055: | |
2056: | SCOPE - PUBLIC |
2057: | |
2058: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2059: | arp_util.debug |
2060: | |
2061: | ARGUMENTS : IN: |
2062: | p_form_name |
2063: | p_form_version |

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

2100: l_dummy varchar2(80);
2101:
2102: BEGIN
2103:
2104: arp_util.debug('arp_process_header.update_header_freight_cover()+');
2105:
2106: arp_ct_pkg.set_to_dummy(l_trx_rec);
2107:
2108: l_trx_rec.ship_via := p_ship_via;

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

2127: null,
2128: null,
2129: p_status);
2130:
2131: arp_util.debug('arp_process_header.update_header_freight_cover()-');
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: arp_util.debug('EXCEPTION : '||

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

2131: arp_util.debug('arp_process_header.update_header_freight_cover()-');
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: arp_util.debug('EXCEPTION : '||
2136: 'arp_process_header.update_header_freight_cover()-');
2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);

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

2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: arp_util.debug('EXCEPTION : '||
2136: 'arp_process_header.update_header_freight_cover()-');
2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);

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

2134: WHEN OTHERS THEN
2135: arp_util.debug('EXCEPTION : '||
2136: 'arp_process_header.update_header_freight_cover()-');
2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2142: arp_util.debug('p_waybill_number = '||p_waybill_number);

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

2135: arp_util.debug('EXCEPTION : '||
2136: 'arp_process_header.update_header_freight_cover()-');
2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2142: arp_util.debug('p_waybill_number = '||p_waybill_number);
2143: arp_util.debug('p_fob_point = '||p_fob_point);

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

2136: 'arp_process_header.update_header_freight_cover()-');
2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2142: arp_util.debug('p_waybill_number = '||p_waybill_number);
2143: arp_util.debug('p_fob_point = '||p_fob_point);
2144:

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

2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2142: arp_util.debug('p_waybill_number = '||p_waybill_number);
2143: arp_util.debug('p_fob_point = '||p_fob_point);
2144:
2145: RAISE;

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

2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2142: arp_util.debug('p_waybill_number = '||p_waybill_number);
2143: arp_util.debug('p_fob_point = '||p_fob_point);
2144:
2145: RAISE;
2146: END;

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

2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);
2141: arp_util.debug('p_ship_date_actual = '||p_ship_date_actual);
2142: arp_util.debug('p_waybill_number = '||p_waybill_number);
2143: arp_util.debug('p_fob_point = '||p_fob_point);
2144:
2145: RAISE;
2146: END;
2147:

Line 2167: | arp_util.debug |

2163: | |
2164: | SCOPE - PUBLIC |
2165: | |
2166: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2167: | arp_util.debug |
2168: | |
2169: | ARGUMENTS : IN: |
2170: | p_ct_rowid |
2171: | p_customer_trx_id |

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

2448: l_commit_memo_line_desc ar_memo_lines.description%type;
2449:
2450: BEGIN
2451:
2452: arp_util.debug('arp_process_header.post_query()+');
2453:
2454: /*-----------------------------------------+
2455: | Initialize the OUT NOCOPY parameters to NULL |
2456: +-----------------------------------------*/

Line 2846: arp_util.debug('');

2842: /*-----------------------------------------+
2843: | Print the results to the debug stream |
2844: +-----------------------------------------*/
2845:
2846: arp_util.debug('');
2847: arp_util.debug('======= results from post_query() =======');
2848: arp_util.debug('p_ct_commitment_trx_date = ' ||
2849: l_ct_commitment_trx_date);
2850: arp_util.debug('p_ct_commitment_number = ' ||

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

2843: | Print the results to the debug stream |
2844: +-----------------------------------------*/
2845:
2846: arp_util.debug('');
2847: arp_util.debug('======= results from post_query() =======');
2848: arp_util.debug('p_ct_commitment_trx_date = ' ||
2849: l_ct_commitment_trx_date);
2850: arp_util.debug('p_ct_commitment_number = ' ||
2851: l_ct_commitment_number);

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

2844: +-----------------------------------------*/
2845:
2846: arp_util.debug('');
2847: arp_util.debug('======= results from post_query() =======');
2848: arp_util.debug('p_ct_commitment_trx_date = ' ||
2849: l_ct_commitment_trx_date);
2850: arp_util.debug('p_ct_commitment_number = ' ||
2851: l_ct_commitment_number);
2852: arp_util.debug('p_gd_commitment_gl_date = ' ||

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

2846: arp_util.debug('');
2847: arp_util.debug('======= results from post_query() =======');
2848: arp_util.debug('p_ct_commitment_trx_date = ' ||
2849: l_ct_commitment_trx_date);
2850: arp_util.debug('p_ct_commitment_number = ' ||
2851: l_ct_commitment_number);
2852: arp_util.debug('p_gd_commitment_gl_date = ' ||
2853: l_gd_commitment_gl_date);
2854: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||

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

2848: arp_util.debug('p_ct_commitment_trx_date = ' ||
2849: l_ct_commitment_trx_date);
2850: arp_util.debug('p_ct_commitment_number = ' ||
2851: l_ct_commitment_number);
2852: arp_util.debug('p_gd_commitment_gl_date = ' ||
2853: l_gd_commitment_gl_date);
2854: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2855: l_ctl_commit_cust_trx_line_id);
2856: arp_util.debug('p_ctl_commitment_amount = ' ||

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

2850: arp_util.debug('p_ct_commitment_number = ' ||
2851: l_ct_commitment_number);
2852: arp_util.debug('p_gd_commitment_gl_date = ' ||
2853: l_gd_commitment_gl_date);
2854: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2855: l_ctl_commit_cust_trx_line_id);
2856: arp_util.debug('p_ctl_commitment_amount = ' ||
2857: l_ctl_commitment_amount);
2858: arp_util.debug('p_ctl_commitment_text = ' ||

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

2852: arp_util.debug('p_gd_commitment_gl_date = ' ||
2853: l_gd_commitment_gl_date);
2854: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2855: l_ctl_commit_cust_trx_line_id);
2856: arp_util.debug('p_ctl_commitment_amount = ' ||
2857: l_ctl_commitment_amount);
2858: arp_util.debug('p_ctl_commitment_text = ' ||
2859: l_ctl_commitment_text);
2860: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||

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

2854: arp_util.debug('p_ctl_commit_cust_trx_line_id = ' ||
2855: l_ctl_commit_cust_trx_line_id);
2856: arp_util.debug('p_ctl_commitment_amount = ' ||
2857: l_ctl_commitment_amount);
2858: arp_util.debug('p_ctl_commitment_text = ' ||
2859: l_ctl_commitment_text);
2860: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2861: l_ctl_commitment_inv_item_id);
2862: arp_util.debug('p_interface_line_context = ' ||

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

2856: arp_util.debug('p_ctl_commitment_amount = ' ||
2857: l_ctl_commitment_amount);
2858: arp_util.debug('p_ctl_commitment_text = ' ||
2859: l_ctl_commitment_text);
2860: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2861: l_ctl_commitment_inv_item_id);
2862: arp_util.debug('p_interface_line_context = ' ||
2863: l_interface_line_context);
2864: arp_util.debug('p_interface_line_attribute1 = ' ||

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

2858: arp_util.debug('p_ctl_commitment_text = ' ||
2859: l_ctl_commitment_text);
2860: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2861: l_ctl_commitment_inv_item_id);
2862: arp_util.debug('p_interface_line_context = ' ||
2863: l_interface_line_context);
2864: arp_util.debug('p_interface_line_attribute1 = ' ||
2865: l_interface_line_attribute1);
2866: arp_util.debug('p_interface_line_attribute2 = ' ||

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

2860: arp_util.debug('p_ctl_commitment_inv_item_id = ' ||
2861: l_ctl_commitment_inv_item_id);
2862: arp_util.debug('p_interface_line_context = ' ||
2863: l_interface_line_context);
2864: arp_util.debug('p_interface_line_attribute1 = ' ||
2865: l_interface_line_attribute1);
2866: arp_util.debug('p_interface_line_attribute2 = ' ||
2867: l_interface_line_attribute2);
2868: arp_util.debug('p_interface_line_attribute3 = ' ||

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

2862: arp_util.debug('p_interface_line_context = ' ||
2863: l_interface_line_context);
2864: arp_util.debug('p_interface_line_attribute1 = ' ||
2865: l_interface_line_attribute1);
2866: arp_util.debug('p_interface_line_attribute2 = ' ||
2867: l_interface_line_attribute2);
2868: arp_util.debug('p_interface_line_attribute3 = ' ||
2869: l_interface_line_attribute3);
2870: arp_util.debug('p_interface_line_attribute4 = ' ||

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

2864: arp_util.debug('p_interface_line_attribute1 = ' ||
2865: l_interface_line_attribute1);
2866: arp_util.debug('p_interface_line_attribute2 = ' ||
2867: l_interface_line_attribute2);
2868: arp_util.debug('p_interface_line_attribute3 = ' ||
2869: l_interface_line_attribute3);
2870: arp_util.debug('p_interface_line_attribute4 = ' ||
2871: l_interface_line_attribute4);
2872: arp_util.debug('p_interface_line_attribute5 = ' ||

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

2866: arp_util.debug('p_interface_line_attribute2 = ' ||
2867: l_interface_line_attribute2);
2868: arp_util.debug('p_interface_line_attribute3 = ' ||
2869: l_interface_line_attribute3);
2870: arp_util.debug('p_interface_line_attribute4 = ' ||
2871: l_interface_line_attribute4);
2872: arp_util.debug('p_interface_line_attribute5 = ' ||
2873: l_interface_line_attribute5);
2874: arp_util.debug('p_interface_line_attribute6 = ' ||

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

2868: arp_util.debug('p_interface_line_attribute3 = ' ||
2869: l_interface_line_attribute3);
2870: arp_util.debug('p_interface_line_attribute4 = ' ||
2871: l_interface_line_attribute4);
2872: arp_util.debug('p_interface_line_attribute5 = ' ||
2873: l_interface_line_attribute5);
2874: arp_util.debug('p_interface_line_attribute6 = ' ||
2875: l_interface_line_attribute6);
2876: arp_util.debug('p_interface_line_attribute7 = ' ||

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

2870: arp_util.debug('p_interface_line_attribute4 = ' ||
2871: l_interface_line_attribute4);
2872: arp_util.debug('p_interface_line_attribute5 = ' ||
2873: l_interface_line_attribute5);
2874: arp_util.debug('p_interface_line_attribute6 = ' ||
2875: l_interface_line_attribute6);
2876: arp_util.debug('p_interface_line_attribute7 = ' ||
2877: l_interface_line_attribute7);
2878: arp_util.debug('p_interface_line_attribute8 = ' ||

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

2872: arp_util.debug('p_interface_line_attribute5 = ' ||
2873: l_interface_line_attribute5);
2874: arp_util.debug('p_interface_line_attribute6 = ' ||
2875: l_interface_line_attribute6);
2876: arp_util.debug('p_interface_line_attribute7 = ' ||
2877: l_interface_line_attribute7);
2878: arp_util.debug('p_interface_line_attribute8 = ' ||
2879: l_interface_line_attribute8);
2880: arp_util.debug('p_interface_line_attribute9 = ' ||

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

2874: arp_util.debug('p_interface_line_attribute6 = ' ||
2875: l_interface_line_attribute6);
2876: arp_util.debug('p_interface_line_attribute7 = ' ||
2877: l_interface_line_attribute7);
2878: arp_util.debug('p_interface_line_attribute8 = ' ||
2879: l_interface_line_attribute8);
2880: arp_util.debug('p_interface_line_attribute9 = ' ||
2881: l_interface_line_attribute9);
2882: arp_util.debug('p_interface_line_attribute10 = ' ||

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

2876: arp_util.debug('p_interface_line_attribute7 = ' ||
2877: l_interface_line_attribute7);
2878: arp_util.debug('p_interface_line_attribute8 = ' ||
2879: l_interface_line_attribute8);
2880: arp_util.debug('p_interface_line_attribute9 = ' ||
2881: l_interface_line_attribute9);
2882: arp_util.debug('p_interface_line_attribute10 = ' ||
2883: l_interface_line_attribute10);
2884: arp_util.debug('p_interface_line_attribute11 = ' ||

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

2878: arp_util.debug('p_interface_line_attribute8 = ' ||
2879: l_interface_line_attribute8);
2880: arp_util.debug('p_interface_line_attribute9 = ' ||
2881: l_interface_line_attribute9);
2882: arp_util.debug('p_interface_line_attribute10 = ' ||
2883: l_interface_line_attribute10);
2884: arp_util.debug('p_interface_line_attribute11 = ' ||
2885: l_interface_line_attribute11);
2886: arp_util.debug('p_interface_line_attribute12 = ' ||

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

2880: arp_util.debug('p_interface_line_attribute9 = ' ||
2881: l_interface_line_attribute9);
2882: arp_util.debug('p_interface_line_attribute10 = ' ||
2883: l_interface_line_attribute10);
2884: arp_util.debug('p_interface_line_attribute11 = ' ||
2885: l_interface_line_attribute11);
2886: arp_util.debug('p_interface_line_attribute12 = ' ||
2887: l_interface_line_attribute12);
2888: arp_util.debug('p_interface_line_attribute13 = ' ||

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

2882: arp_util.debug('p_interface_line_attribute10 = ' ||
2883: l_interface_line_attribute10);
2884: arp_util.debug('p_interface_line_attribute11 = ' ||
2885: l_interface_line_attribute11);
2886: arp_util.debug('p_interface_line_attribute12 = ' ||
2887: l_interface_line_attribute12);
2888: arp_util.debug('p_interface_line_attribute13 = ' ||
2889: l_interface_line_attribute13);
2890: arp_util.debug('p_interface_line_attribute14 = ' ||

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

2884: arp_util.debug('p_interface_line_attribute11 = ' ||
2885: l_interface_line_attribute11);
2886: arp_util.debug('p_interface_line_attribute12 = ' ||
2887: l_interface_line_attribute12);
2888: arp_util.debug('p_interface_line_attribute13 = ' ||
2889: l_interface_line_attribute13);
2890: arp_util.debug('p_interface_line_attribute14 = ' ||
2891: l_interface_line_attribute14);
2892: arp_util.debug('p_interface_line_attribute15 = ' ||

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

2886: arp_util.debug('p_interface_line_attribute12 = ' ||
2887: l_interface_line_attribute12);
2888: arp_util.debug('p_interface_line_attribute13 = ' ||
2889: l_interface_line_attribute13);
2890: arp_util.debug('p_interface_line_attribute14 = ' ||
2891: l_interface_line_attribute14);
2892: arp_util.debug('p_interface_line_attribute15 = ' ||
2893: l_interface_line_attribute15);
2894: arp_util.debug('p_attribute_category = ' ||

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

2888: arp_util.debug('p_interface_line_attribute13 = ' ||
2889: l_interface_line_attribute13);
2890: arp_util.debug('p_interface_line_attribute14 = ' ||
2891: l_interface_line_attribute14);
2892: arp_util.debug('p_interface_line_attribute15 = ' ||
2893: l_interface_line_attribute15);
2894: arp_util.debug('p_attribute_category = ' ||
2895: l_attribute_category);
2896: arp_util.debug('p_attribute1 = ' ||

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

2890: arp_util.debug('p_interface_line_attribute14 = ' ||
2891: l_interface_line_attribute14);
2892: arp_util.debug('p_interface_line_attribute15 = ' ||
2893: l_interface_line_attribute15);
2894: arp_util.debug('p_attribute_category = ' ||
2895: l_attribute_category);
2896: arp_util.debug('p_attribute1 = ' ||
2897: l_attribute1);
2898: arp_util.debug('p_attribute2 = ' ||

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

2892: arp_util.debug('p_interface_line_attribute15 = ' ||
2893: l_interface_line_attribute15);
2894: arp_util.debug('p_attribute_category = ' ||
2895: l_attribute_category);
2896: arp_util.debug('p_attribute1 = ' ||
2897: l_attribute1);
2898: arp_util.debug('p_attribute2 = ' ||
2899: l_attribute2);
2900: arp_util.debug('p_attribute3 = ' ||

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

2894: arp_util.debug('p_attribute_category = ' ||
2895: l_attribute_category);
2896: arp_util.debug('p_attribute1 = ' ||
2897: l_attribute1);
2898: arp_util.debug('p_attribute2 = ' ||
2899: l_attribute2);
2900: arp_util.debug('p_attribute3 = ' ||
2901: l_attribute3);
2902: arp_util.debug('p_attribute4 = ' ||

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

2896: arp_util.debug('p_attribute1 = ' ||
2897: l_attribute1);
2898: arp_util.debug('p_attribute2 = ' ||
2899: l_attribute2);
2900: arp_util.debug('p_attribute3 = ' ||
2901: l_attribute3);
2902: arp_util.debug('p_attribute4 = ' ||
2903: l_attribute4);
2904: arp_util.debug('p_attribute5 = ' ||

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

2898: arp_util.debug('p_attribute2 = ' ||
2899: l_attribute2);
2900: arp_util.debug('p_attribute3 = ' ||
2901: l_attribute3);
2902: arp_util.debug('p_attribute4 = ' ||
2903: l_attribute4);
2904: arp_util.debug('p_attribute5 = ' ||
2905: l_attribute5);
2906: arp_util.debug('p_attribute6 = ' ||

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

2900: arp_util.debug('p_attribute3 = ' ||
2901: l_attribute3);
2902: arp_util.debug('p_attribute4 = ' ||
2903: l_attribute4);
2904: arp_util.debug('p_attribute5 = ' ||
2905: l_attribute5);
2906: arp_util.debug('p_attribute6 = ' ||
2907: l_attribute6);
2908: arp_util.debug('p_attribute7 = ' ||

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

2902: arp_util.debug('p_attribute4 = ' ||
2903: l_attribute4);
2904: arp_util.debug('p_attribute5 = ' ||
2905: l_attribute5);
2906: arp_util.debug('p_attribute6 = ' ||
2907: l_attribute6);
2908: arp_util.debug('p_attribute7 = ' ||
2909: l_attribute7);
2910: arp_util.debug('p_attribute8 = ' ||

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

2904: arp_util.debug('p_attribute5 = ' ||
2905: l_attribute5);
2906: arp_util.debug('p_attribute6 = ' ||
2907: l_attribute6);
2908: arp_util.debug('p_attribute7 = ' ||
2909: l_attribute7);
2910: arp_util.debug('p_attribute8 = ' ||
2911: l_attribute8);
2912: arp_util.debug('p_attribute9 = ' ||

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

2906: arp_util.debug('p_attribute6 = ' ||
2907: l_attribute6);
2908: arp_util.debug('p_attribute7 = ' ||
2909: l_attribute7);
2910: arp_util.debug('p_attribute8 = ' ||
2911: l_attribute8);
2912: arp_util.debug('p_attribute9 = ' ||
2913: l_attribute9);
2914: arp_util.debug('p_attribute10 = ' ||

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

2908: arp_util.debug('p_attribute7 = ' ||
2909: l_attribute7);
2910: arp_util.debug('p_attribute8 = ' ||
2911: l_attribute8);
2912: arp_util.debug('p_attribute9 = ' ||
2913: l_attribute9);
2914: arp_util.debug('p_attribute10 = ' ||
2915: l_attribute10);
2916: arp_util.debug('p_attribute11 = ' ||

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

2910: arp_util.debug('p_attribute8 = ' ||
2911: l_attribute8);
2912: arp_util.debug('p_attribute9 = ' ||
2913: l_attribute9);
2914: arp_util.debug('p_attribute10 = ' ||
2915: l_attribute10);
2916: arp_util.debug('p_attribute11 = ' ||
2917: l_attribute11);
2918: arp_util.debug('p_attribute12 = ' ||

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

2912: arp_util.debug('p_attribute9 = ' ||
2913: l_attribute9);
2914: arp_util.debug('p_attribute10 = ' ||
2915: l_attribute10);
2916: arp_util.debug('p_attribute11 = ' ||
2917: l_attribute11);
2918: arp_util.debug('p_attribute12 = ' ||
2919: l_attribute12);
2920: arp_util.debug('p_attribute13 = ' ||

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

2914: arp_util.debug('p_attribute10 = ' ||
2915: l_attribute10);
2916: arp_util.debug('p_attribute11 = ' ||
2917: l_attribute11);
2918: arp_util.debug('p_attribute12 = ' ||
2919: l_attribute12);
2920: arp_util.debug('p_attribute13 = ' ||
2921: l_attribute13);
2922: arp_util.debug('p_attribute14 = ' ||

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

2916: arp_util.debug('p_attribute11 = ' ||
2917: l_attribute11);
2918: arp_util.debug('p_attribute12 = ' ||
2919: l_attribute12);
2920: arp_util.debug('p_attribute13 = ' ||
2921: l_attribute13);
2922: arp_util.debug('p_attribute14 = ' ||
2923: l_attribute14);
2924: arp_util.debug('p_attribute15 = ' ||

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

2918: arp_util.debug('p_attribute12 = ' ||
2919: l_attribute12);
2920: arp_util.debug('p_attribute13 = ' ||
2921: l_attribute13);
2922: arp_util.debug('p_attribute14 = ' ||
2923: l_attribute14);
2924: arp_util.debug('p_attribute15 = ' ||
2925: l_attribute15);
2926: arp_util.debug('p_default_ussgl_trx_code = ' ||

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

2920: arp_util.debug('p_attribute13 = ' ||
2921: l_attribute13);
2922: arp_util.debug('p_attribute14 = ' ||
2923: l_attribute14);
2924: arp_util.debug('p_attribute15 = ' ||
2925: l_attribute15);
2926: arp_util.debug('p_default_ussgl_trx_code = ' ||
2927: l_default_ussgl_trx_code);
2928: arp_util.debug('p_ct_prev_trx_number = ' ||

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

2922: arp_util.debug('p_attribute14 = ' ||
2923: l_attribute14);
2924: arp_util.debug('p_attribute15 = ' ||
2925: l_attribute15);
2926: arp_util.debug('p_default_ussgl_trx_code = ' ||
2927: l_default_ussgl_trx_code);
2928: arp_util.debug('p_ct_prev_trx_number = ' ||
2929: l_ct_prev_trx_number);
2930: arp_util.debug('p_ct_prev_trx_reference = ' ||

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

2924: arp_util.debug('p_attribute15 = ' ||
2925: l_attribute15);
2926: arp_util.debug('p_default_ussgl_trx_code = ' ||
2927: l_default_ussgl_trx_code);
2928: arp_util.debug('p_ct_prev_trx_number = ' ||
2929: l_ct_prev_trx_number);
2930: arp_util.debug('p_ct_prev_trx_reference = ' ||
2931: l_ct_prev_trx_reference);
2932: arp_util.debug('p_ct_prev_inv_currency_code = ' ||

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

2926: arp_util.debug('p_default_ussgl_trx_code = ' ||
2927: l_default_ussgl_trx_code);
2928: arp_util.debug('p_ct_prev_trx_number = ' ||
2929: l_ct_prev_trx_number);
2930: arp_util.debug('p_ct_prev_trx_reference = ' ||
2931: l_ct_prev_trx_reference);
2932: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2933: l_ct_prev_inv_currency_code);
2934: arp_util.debug('p_ct_prev_trx_date = ' ||

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

2928: arp_util.debug('p_ct_prev_trx_number = ' ||
2929: l_ct_prev_trx_number);
2930: arp_util.debug('p_ct_prev_trx_reference = ' ||
2931: l_ct_prev_trx_reference);
2932: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2933: l_ct_prev_inv_currency_code);
2934: arp_util.debug('p_ct_prev_trx_date = ' ||
2935: l_ct_prev_trx_date);
2936: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||

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

2930: arp_util.debug('p_ct_prev_trx_reference = ' ||
2931: l_ct_prev_trx_reference);
2932: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2933: l_ct_prev_inv_currency_code);
2934: arp_util.debug('p_ct_prev_trx_date = ' ||
2935: l_ct_prev_trx_date);
2936: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2937: l_ct_prev_bill_to_customer_id);
2938: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||

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

2932: arp_util.debug('p_ct_prev_inv_currency_code = ' ||
2933: l_ct_prev_inv_currency_code);
2934: arp_util.debug('p_ct_prev_trx_date = ' ||
2935: l_ct_prev_trx_date);
2936: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2937: l_ct_prev_bill_to_customer_id);
2938: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2939: l_ct_prev_ship_to_customer_id);
2940: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||

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

2934: arp_util.debug('p_ct_prev_trx_date = ' ||
2935: l_ct_prev_trx_date);
2936: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2937: l_ct_prev_bill_to_customer_id);
2938: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2939: l_ct_prev_ship_to_customer_id);
2940: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2941: l_ct_prev_sold_to_customer_id);
2942: arp_util.debug('p_ct_prev_paying_customer_id = ' ||

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

2936: arp_util.debug('p_ct_prev_bill_to_customer_id = ' ||
2937: l_ct_prev_bill_to_customer_id);
2938: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2939: l_ct_prev_ship_to_customer_id);
2940: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2941: l_ct_prev_sold_to_customer_id);
2942: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2943: l_ct_prev_paying_customer_id);
2944: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||

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

2938: arp_util.debug('p_ct_prev_ship_to_customer_id = ' ||
2939: l_ct_prev_ship_to_customer_id);
2940: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2941: l_ct_prev_sold_to_customer_id);
2942: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2943: l_ct_prev_paying_customer_id);
2944: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2945: l_ct_prev_bill_to_site_use_id);
2946: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||

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

2940: arp_util.debug('p_ct_prev_sold_to_customer_id = ' ||
2941: l_ct_prev_sold_to_customer_id);
2942: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2943: l_ct_prev_paying_customer_id);
2944: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2945: l_ct_prev_bill_to_site_use_id);
2946: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2947: l_ct_prev_ship_to_site_use_id);
2948: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||

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

2942: arp_util.debug('p_ct_prev_paying_customer_id = ' ||
2943: l_ct_prev_paying_customer_id);
2944: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2945: l_ct_prev_bill_to_site_use_id);
2946: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2947: l_ct_prev_ship_to_site_use_id);
2948: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2949: l_ct_prev_paying_site_use_id);
2950: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||

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

2944: arp_util.debug('p_ct_prev_bill_to_site_use_id = ' ||
2945: l_ct_prev_bill_to_site_use_id);
2946: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2947: l_ct_prev_ship_to_site_use_id);
2948: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2949: l_ct_prev_paying_site_use_id);
2950: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2951: l_ct_prev_bill_to_contact_id);
2952: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||

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

2946: arp_util.debug('p_ct_prev_ship_to_site_use_id = ' ||
2947: l_ct_prev_ship_to_site_use_id);
2948: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2949: l_ct_prev_paying_site_use_id);
2950: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2951: l_ct_prev_bill_to_contact_id);
2952: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2953: l_ct_prev_ship_to_contact_id);
2954: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||

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

2948: arp_util.debug('p_ct_prev_paying_site_use_id = ' ||
2949: l_ct_prev_paying_site_use_id);
2950: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2951: l_ct_prev_bill_to_contact_id);
2952: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2953: l_ct_prev_ship_to_contact_id);
2954: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2955: l_ct_prev_initial_cust_trx_id);
2956: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||

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

2950: arp_util.debug('p_ct_prev_bill_to_contact_id = ' ||
2951: l_ct_prev_bill_to_contact_id);
2952: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2953: l_ct_prev_ship_to_contact_id);
2954: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2955: l_ct_prev_initial_cust_trx_id);
2956: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2957: l_ct_prev_primary_salesrep_id);
2958: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||

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

2952: arp_util.debug('p_ct_prev_ship_to_contact_id = ' ||
2953: l_ct_prev_ship_to_contact_id);
2954: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2955: l_ct_prev_initial_cust_trx_id);
2956: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2957: l_ct_prev_primary_salesrep_id);
2958: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2959: l_ct_prev_invoicing_rule_id);
2960: arp_util.debug('p_gd_prev_gl_date = ' ||

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

2954: arp_util.debug('p_ct_prev_initial_cust_trx_id = ' ||
2955: l_ct_prev_initial_cust_trx_id);
2956: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2957: l_ct_prev_primary_salesrep_id);
2958: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2959: l_ct_prev_invoicing_rule_id);
2960: arp_util.debug('p_gd_prev_gl_date = ' ||
2961: l_gd_prev_gl_date);
2962: arp_util.debug('p_prev_trx_original = ' ||

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

2956: arp_util.debug('p_ct_prev_primary_salesrep_id = ' ||
2957: l_ct_prev_primary_salesrep_id);
2958: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2959: l_ct_prev_invoicing_rule_id);
2960: arp_util.debug('p_gd_prev_gl_date = ' ||
2961: l_gd_prev_gl_date);
2962: arp_util.debug('p_prev_trx_original = ' ||
2963: l_prev_trx_original);
2964: arp_util.debug('p_prev_trx_balance = ' ||

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

2958: arp_util.debug('p_ct_prev_invoicing_rule_id = ' ||
2959: l_ct_prev_invoicing_rule_id);
2960: arp_util.debug('p_gd_prev_gl_date = ' ||
2961: l_gd_prev_gl_date);
2962: arp_util.debug('p_prev_trx_original = ' ||
2963: l_prev_trx_original);
2964: arp_util.debug('p_prev_trx_balance = ' ||
2965: l_prev_trx_balance);
2966: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||

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

2960: arp_util.debug('p_gd_prev_gl_date = ' ||
2961: l_gd_prev_gl_date);
2962: arp_util.debug('p_prev_trx_original = ' ||
2963: l_prev_trx_original);
2964: arp_util.debug('p_prev_trx_balance = ' ||
2965: l_prev_trx_balance);
2966: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2967: l_rac_prev_bill_to_cust_name);
2968: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||

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

2962: arp_util.debug('p_prev_trx_original = ' ||
2963: l_prev_trx_original);
2964: arp_util.debug('p_prev_trx_balance = ' ||
2965: l_prev_trx_balance);
2966: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2967: l_rac_prev_bill_to_cust_name);
2968: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2969: l_rac_prev_bill_to_cust_num);
2970: arp_util.debug('p_bs_prev_source_name = ' ||

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

2964: arp_util.debug('p_prev_trx_balance = ' ||
2965: l_prev_trx_balance);
2966: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2967: l_rac_prev_bill_to_cust_name);
2968: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2969: l_rac_prev_bill_to_cust_num);
2970: arp_util.debug('p_bs_prev_source_name = ' ||
2971: l_bs_prev_source_name);
2972: arp_util.debug('p_ctt_prev_class = ' ||

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

2966: arp_util.debug('p_rac_prev_bill_to_cust_name = ' ||
2967: l_rac_prev_bill_to_cust_name);
2968: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2969: l_rac_prev_bill_to_cust_num);
2970: arp_util.debug('p_bs_prev_source_name = ' ||
2971: l_bs_prev_source_name);
2972: arp_util.debug('p_ctt_prev_class = ' ||
2973: l_ctt_prev_class);
2974: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||

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

2968: arp_util.debug('p_rac_prev_bill_to_cust_num = ' ||
2969: l_rac_prev_bill_to_cust_num);
2970: arp_util.debug('p_bs_prev_source_name = ' ||
2971: l_bs_prev_source_name);
2972: arp_util.debug('p_ctt_prev_class = ' ||
2973: l_ctt_prev_class);
2974: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2975: l_ctt_prev_allow_overapp_flag);
2976: arp_util.debug('p_ctt_prev_natural_app_only = ' ||

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

2970: arp_util.debug('p_bs_prev_source_name = ' ||
2971: l_bs_prev_source_name);
2972: arp_util.debug('p_ctt_prev_class = ' ||
2973: l_ctt_prev_class);
2974: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2975: l_ctt_prev_allow_overapp_flag);
2976: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2977: l_ctt_prev_natural_app_only);
2978: arp_util.debug('p_ct_prev_open_receivables = ' ||

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

2972: arp_util.debug('p_ctt_prev_class = ' ||
2973: l_ctt_prev_class);
2974: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2975: l_ctt_prev_allow_overapp_flag);
2976: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2977: l_ctt_prev_natural_app_only);
2978: arp_util.debug('p_ct_prev_open_receivables = ' ||
2979: l_ct_prev_open_receivables);
2980: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||

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

2974: arp_util.debug('p_ctt_prev_allow_overapp_flag = ' ||
2975: l_ctt_prev_allow_overapp_flag);
2976: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2977: l_ctt_prev_natural_app_only);
2978: arp_util.debug('p_ct_prev_open_receivables = ' ||
2979: l_ct_prev_open_receivables);
2980: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||
2981: l_ct_prev_post_to_gl_flag );
2982: arp_util.debug('p_al_cm_reason_meaning = ' ||

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

2976: arp_util.debug('p_ctt_prev_natural_app_only = ' ||
2977: l_ctt_prev_natural_app_only);
2978: arp_util.debug('p_ct_prev_open_receivables = ' ||
2979: l_ct_prev_open_receivables);
2980: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||
2981: l_ct_prev_post_to_gl_flag );
2982: arp_util.debug('p_al_cm_reason_meaning = ' ||
2983: l_al_cm_reason_meaning);
2984:

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

2978: arp_util.debug('p_ct_prev_open_receivables = ' ||
2979: l_ct_prev_open_receivables);
2980: arp_util.debug('p_ct_prev_post_to_gl_flag = ' ||
2981: l_ct_prev_post_to_gl_flag );
2982: arp_util.debug('p_al_cm_reason_meaning = ' ||
2983: l_al_cm_reason_meaning);
2984:
2985: arp_util.debug('arp_process_header.post_query()-');
2986:

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

2981: l_ct_prev_post_to_gl_flag );
2982: arp_util.debug('p_al_cm_reason_meaning = ' ||
2983: l_al_cm_reason_meaning);
2984:
2985: arp_util.debug('arp_process_header.post_query()-');
2986:
2987: EXCEPTION
2988: WHEN OTHERS THEN
2989: arp_util.debug('EXCEPTION : '||

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

2985: arp_util.debug('arp_process_header.post_query()-');
2986:
2987: EXCEPTION
2988: WHEN OTHERS THEN
2989: arp_util.debug('EXCEPTION : '||
2990: 'arp_process_header.post_query()-');
2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);

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

2987: EXCEPTION
2988: WHEN OTHERS THEN
2989: arp_util.debug('EXCEPTION : '||
2990: 'arp_process_header.post_query()-');
2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2995: arp_util.debug('p_initial_customer_trx_id = ' ||

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

2988: WHEN OTHERS THEN
2989: arp_util.debug('EXCEPTION : '||
2990: 'arp_process_header.post_query()-');
2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2995: arp_util.debug('p_initial_customer_trx_id = ' ||
2996: p_initial_customer_trx_id);

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

2989: arp_util.debug('EXCEPTION : '||
2990: 'arp_process_header.post_query()-');
2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2995: arp_util.debug('p_initial_customer_trx_id = ' ||
2996: p_initial_customer_trx_id);
2997: arp_util.debug('p_previous_customer_trx_id = ' ||

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

2990: 'arp_process_header.post_query()-');
2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2995: arp_util.debug('p_initial_customer_trx_id = ' ||
2996: p_initial_customer_trx_id);
2997: arp_util.debug('p_previous_customer_trx_id = ' ||
2998: p_previous_customer_trx_id);

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

2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2995: arp_util.debug('p_initial_customer_trx_id = ' ||
2996: p_initial_customer_trx_id);
2997: arp_util.debug('p_previous_customer_trx_id = ' ||
2998: p_previous_customer_trx_id);
2999:

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

2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2995: arp_util.debug('p_initial_customer_trx_id = ' ||
2996: p_initial_customer_trx_id);
2997: arp_util.debug('p_previous_customer_trx_id = ' ||
2998: p_previous_customer_trx_id);
2999:
3000: RAISE;
3001: END;