18: | |
19: | SCOPE - PRIVATE |
20: | |
21: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | arp_util.debug |
23: | |
24: | ARGUMENTS : IN: |
25: | p_srep_rec |
26: | OUT: |
41:
42:
43: BEGIN
44:
45: arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');
46:
47:
48: arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');
49:
44:
45: arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');
46:
47:
48: arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52:
53: /*---------------------------------------------+
54: | Display parameters and raise the exception |
55: +---------------------------------------------*/
56:
57: arp_util.debug(
58: 'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');
59:
60: arp_util.debug('');
61: arp_util.debug('---------- val_insert_salescredit() ---------');
56:
57: arp_util.debug(
58: 'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');
59:
60: arp_util.debug('');
61: arp_util.debug('---------- val_insert_salescredit() ---------');
62: arp_util.debug('');
63: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
64:
57: arp_util.debug(
58: 'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');
59:
60: arp_util.debug('');
61: arp_util.debug('---------- val_insert_salescredit() ---------');
62: arp_util.debug('');
63: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
64:
65: RAISE;
58: 'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');
59:
60: arp_util.debug('');
61: arp_util.debug('---------- val_insert_salescredit() ---------');
62: arp_util.debug('');
63: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
64:
65: RAISE;
66:
75: | |
76: | SCOPE - PRIVATE |
77: | |
78: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
79: | arp_util.debug |
80: | |
81: | ARGUMENTS : IN: |
82: | p_srep_rec |
83: | OUT: |
97:
98:
99: BEGIN
100:
101: arp_util.debug('arp_process_salescredit.val_update_salescredit()+');
102:
103:
104: arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');
105:
100:
101: arp_util.debug('arp_process_salescredit.val_update_salescredit()+');
102:
103:
104: arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108:
109: /*---------------------------------------------+
110: | Display parameters and raise the exception |
111: +---------------------------------------------*/
112:
113: arp_util.debug(
114: 'EXCEPTION: arp_process_salescredit.val_update_salescredit()');
115:
116:
117: arp_util.debug('');
113: arp_util.debug(
114: 'EXCEPTION: arp_process_salescredit.val_update_salescredit()');
115:
116:
117: arp_util.debug('');
118: arp_util.debug('---------- val_update_salescredit() ---------');
119: arp_util.debug('');
120: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
121:
114: 'EXCEPTION: arp_process_salescredit.val_update_salescredit()');
115:
116:
117: arp_util.debug('');
118: arp_util.debug('---------- val_update_salescredit() ---------');
119: arp_util.debug('');
120: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
121:
122: RAISE;
115:
116:
117: arp_util.debug('');
118: arp_util.debug('---------- val_update_salescredit() ---------');
119: arp_util.debug('');
120: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
121:
122: RAISE;
123:
132: | |
133: | SCOPE - PRIVATE |
134: | |
135: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
136: | arp_util.debug |
137: | |
138: | ARGUMENTS : IN: |
139: | p_srep_rec |
140: | OUT: |
154:
155:
156: BEGIN
157:
158: arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');
159:
160:
161: arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');
162:
157:
158: arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');
159:
160:
161: arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');
162:
163: EXCEPTION
164: WHEN OTHERS THEN
165:
166: /*---------------------------------------------+
167: | Display parameters and raise the exception |
168: +---------------------------------------------*/
169:
170: arp_util.debug(
171: 'EXCEPTION: arp_process_salescredit.val_delete_salescredit()');
172:
173:
174: arp_util.debug('');
170: arp_util.debug(
171: 'EXCEPTION: arp_process_salescredit.val_delete_salescredit()');
172:
173:
174: arp_util.debug('');
175: arp_util.debug('---------- val_update_salescredit() ---------');
176: arp_util.debug('');
177: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
178:
171: 'EXCEPTION: arp_process_salescredit.val_delete_salescredit()');
172:
173:
174: arp_util.debug('');
175: arp_util.debug('---------- val_update_salescredit() ---------');
176: arp_util.debug('');
177: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
178:
179: RAISE;
172:
173:
174: arp_util.debug('');
175: arp_util.debug('---------- val_update_salescredit() ---------');
176: arp_util.debug('');
177: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
178:
179: RAISE;
180:
189: | |
190: | SCOPE - PRIVATE |
191: | |
192: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
193: | arp_util.debug |
194: | |
195: | ARGUMENTS : IN: |
196: | p_cust_trx_line_salesrep_id |
197: | p_new_srep_rec |
237: l_revised_backout_flag boolean;
238:
239: BEGIN
240:
241: arp_util.debug('arp_process_salescredit.set_flags()+');
242:
243: arp_ctls_pkg.fetch_p(l_old_srep_rec,
244: p_cust_trx_line_salesrep_id);
245:
314: p_delete_flag = TRUE
315: )
316: )
317: THEN l_revised_backout_flag := TRUE;
318: arp_util.debug('revised backout flag: TRUE');
319: ELSE
320: IF ( l_default_record_flag = FALSE )
321: THEN l_revised_backout_flag := p_backout_flag;
322: ELSE l_revised_backout_flag := FALSE;
321: THEN l_revised_backout_flag := p_backout_flag;
322: ELSE l_revised_backout_flag := FALSE;
323: END IF;
324:
325: arp_util.debug('revised backout flag: ' ||
326: arp_trx_util.boolean_to_varchar2(l_revised_backout_flag ));
327:
328: END IF;
329:
334: p_rev_amt_percent_changed_flag := l_rev_amt_percent_changed_flag;
335: p_default_record_flag := l_default_record_flag;
336: p_revised_backout_flag := l_revised_backout_flag;
337:
338: arp_util.debug('p_posted_flag = ' ||
339: arp_trx_util.boolean_to_varchar2(l_posted_flag));
340:
341: arp_util.debug('p_salesrep_changed_flag = ' ||
342: arp_trx_util.boolean_to_varchar2( l_salesrep_changed_flag));
337:
338: arp_util.debug('p_posted_flag = ' ||
339: arp_trx_util.boolean_to_varchar2(l_posted_flag));
340:
341: arp_util.debug('p_salesrep_changed_flag = ' ||
342: arp_trx_util.boolean_to_varchar2( l_salesrep_changed_flag));
343:
344: arp_util.debug('p_amount_percent_changed_flag = ' ||
345: arp_trx_util.boolean_to_varchar2(
340:
341: arp_util.debug('p_salesrep_changed_flag = ' ||
342: arp_trx_util.boolean_to_varchar2( l_salesrep_changed_flag));
343:
344: arp_util.debug('p_amount_percent_changed_flag = ' ||
345: arp_trx_util.boolean_to_varchar2(
346: l_amount_percent_changed_flag));
347:
348: arp_util.debug('p_rev_amt_percent_changed_flag = ' ||
344: arp_util.debug('p_amount_percent_changed_flag = ' ||
345: arp_trx_util.boolean_to_varchar2(
346: l_amount_percent_changed_flag));
347:
348: arp_util.debug('p_rev_amt_percent_changed_flag = ' ||
349: arp_trx_util.boolean_to_varchar2(
350: l_rev_amt_percent_changed_flag));
351:
352: arp_util.debug('p_default_record_flag = ' ||
348: arp_util.debug('p_rev_amt_percent_changed_flag = ' ||
349: arp_trx_util.boolean_to_varchar2(
350: l_rev_amt_percent_changed_flag));
351:
352: arp_util.debug('p_default_record_flag = ' ||
353: arp_trx_util.boolean_to_varchar2(
354: l_default_record_flag));
355:
356: arp_util.debug('p_revised_backout_flag = ' ||
352: arp_util.debug('p_default_record_flag = ' ||
353: arp_trx_util.boolean_to_varchar2(
354: l_default_record_flag));
355:
356: arp_util.debug('p_revised_backout_flag = ' ||
357: arp_trx_util.boolean_to_varchar2(
358: l_revised_backout_flag));
359:
360: arp_util.debug('arp_process_salescredit.set_flags()-');
356: arp_util.debug('p_revised_backout_flag = ' ||
357: arp_trx_util.boolean_to_varchar2(
358: l_revised_backout_flag));
359:
360: arp_util.debug('arp_process_salescredit.set_flags()-');
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364:
365: /*---------------------------------------------+
366: | Display parameters and raise the exception |
367: +---------------------------------------------*/
368:
369: arp_util.debug('EXCEPTION: arp_process_salescredit.set_flags()');
370:
371: arp_util.debug('');
372: arp_util.debug('---------- parameters for set_flags() ---------');
373:
367: +---------------------------------------------*/
368:
369: arp_util.debug('EXCEPTION: arp_process_salescredit.set_flags()');
370:
371: arp_util.debug('');
372: arp_util.debug('---------- parameters for set_flags() ---------');
373:
374: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
375: p_cust_trx_line_salesrep_id);
368:
369: arp_util.debug('EXCEPTION: arp_process_salescredit.set_flags()');
370:
371: arp_util.debug('');
372: arp_util.debug('---------- parameters for set_flags() ---------');
373:
374: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
375: p_cust_trx_line_salesrep_id);
376:
370:
371: arp_util.debug('');
372: arp_util.debug('---------- parameters for set_flags() ---------');
373:
374: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
375: p_cust_trx_line_salesrep_id);
376:
377: arp_util.debug('p_backout_flag = ' ||
378: arp_trx_util.boolean_to_varchar2(p_backout_flag));
373:
374: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
375: p_cust_trx_line_salesrep_id);
376:
377: arp_util.debug('p_backout_flag = ' ||
378: arp_trx_util.boolean_to_varchar2(p_backout_flag));
379:
380: arp_util.debug('p_delete_flag = ' ||
381: arp_trx_util.boolean_to_varchar2(p_delete_flag));
376:
377: arp_util.debug('p_backout_flag = ' ||
378: arp_trx_util.boolean_to_varchar2(p_backout_flag));
379:
380: arp_util.debug('p_delete_flag = ' ||
381: arp_trx_util.boolean_to_varchar2(p_delete_flag));
382:
383: arp_util.debug('');
384:
379:
380: arp_util.debug('p_delete_flag = ' ||
381: arp_trx_util.boolean_to_varchar2(p_delete_flag));
382:
383: arp_util.debug('');
384:
385: arp_util.debug('---------- new salescredit record ----------');
386: arp_ctls_pkg.display_salescredit_rec( p_new_srep_rec );
387: arp_util.debug('');
381: arp_trx_util.boolean_to_varchar2(p_delete_flag));
382:
383: arp_util.debug('');
384:
385: arp_util.debug('---------- new salescredit record ----------');
386: arp_ctls_pkg.display_salescredit_rec( p_new_srep_rec );
387: arp_util.debug('');
388:
389: RAISE;
383: arp_util.debug('');
384:
385: arp_util.debug('---------- new salescredit record ----------');
386: arp_ctls_pkg.display_salescredit_rec( p_new_srep_rec );
387: arp_util.debug('');
388:
389: RAISE;
390:
391: END;
399: | |
400: | SCOPE - PRIVATE |
401: | |
402: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
403: | arp_util.debug |
404: | |
405: | ARGUMENTS : IN: |
406: | p_customer_trx_id |
407: | p_customer_trx_line_id |
440: l_dist_count NUMBER;
441:
442: BEGIN
443:
444: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()+');
445:
446: arp_util.debug('p_customer_trx_id = ' ||
447: to_char( p_customer_trx_id ));
448: arp_util.debug('p_customer_trx_line_id = ' ||
442: BEGIN
443:
444: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()+');
445:
446: arp_util.debug('p_customer_trx_id = ' ||
447: to_char( p_customer_trx_id ));
448: arp_util.debug('p_customer_trx_line_id = ' ||
449: to_char( p_customer_trx_line_id ));
450: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
444: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()+');
445:
446: arp_util.debug('p_customer_trx_id = ' ||
447: to_char( p_customer_trx_id ));
448: arp_util.debug('p_customer_trx_line_id = ' ||
449: to_char( p_customer_trx_line_id ));
450: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
451: to_char( p_cust_trx_line_salesrep_id ));
452:
446: arp_util.debug('p_customer_trx_id = ' ||
447: to_char( p_customer_trx_id ));
448: arp_util.debug('p_customer_trx_line_id = ' ||
449: to_char( p_customer_trx_line_id ));
450: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
451: to_char( p_cust_trx_line_salesrep_id ));
452:
453: BEGIN
454:
655: | Raise AutoAccounting exception |
656: +----------------------------------*/
657:
658: IF (l_errorbuf is not null)
659: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
660:
661: FND_MESSAGE.set_name('AR', 'GENERIC_MESSAGE');
662: FND_MESSAGE.set_token( 'GENERIC_TEXT', l_errorbuf);
663: APP_EXCEPTION.raise_exception;
679: pg_trx_header_level_rounding ,
680: 'N',
681: 'N') = 0 -- FALSE
682: THEN
683: arp_util.debug('EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');
684: arp_util.debug(l_error_message);
685: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
686: APP_EXCEPTION.raise_exception;
687: END IF;
680: 'N',
681: 'N') = 0 -- FALSE
682: THEN
683: arp_util.debug('EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');
684: arp_util.debug(l_error_message);
685: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
686: APP_EXCEPTION.raise_exception;
687: END IF;
688:
685: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
686: APP_EXCEPTION.raise_exception;
687: END IF;
688:
689: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()-');
690:
691: EXCEPTION
692: WHEN OTHERS THEN
693:
694: /*---------------------------------------------+
695: | Display parameters and raise the exception |
696: +---------------------------------------------*/
697:
698: arp_util.debug(
699: 'EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');
700:
701: IF (l_errorbuf is not null)
702: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
698: arp_util.debug(
699: 'EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');
700:
701: IF (l_errorbuf is not null)
702: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
703: END IF;
704:
705: arp_util.debug('');
706: arp_util.debug('---------- parameters for run_autoacc_for_scredits () ' ||
701: IF (l_errorbuf is not null)
702: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
703: END IF;
704:
705: arp_util.debug('');
706: arp_util.debug('---------- parameters for run_autoacc_for_scredits () ' ||
707: '---------');
708:
709: arp_util.debug('p_customer_trx_id = ' || TO_CHAR( p_customer_trx_id));
702: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
703: END IF;
704:
705: arp_util.debug('');
706: arp_util.debug('---------- parameters for run_autoacc_for_scredits () ' ||
707: '---------');
708:
709: arp_util.debug('p_customer_trx_id = ' || TO_CHAR( p_customer_trx_id));
710: arp_util.debug('p_customer_trx_line_id = ' ||
705: arp_util.debug('');
706: arp_util.debug('---------- parameters for run_autoacc_for_scredits () ' ||
707: '---------');
708:
709: arp_util.debug('p_customer_trx_id = ' || TO_CHAR( p_customer_trx_id));
710: arp_util.debug('p_customer_trx_line_id = ' ||
711: TO_CHAR( p_customer_trx_line_id));
712: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
713: TO_CHAR( p_cust_trx_line_salesrep_id));
706: arp_util.debug('---------- parameters for run_autoacc_for_scredits () ' ||
707: '---------');
708:
709: arp_util.debug('p_customer_trx_id = ' || TO_CHAR( p_customer_trx_id));
710: arp_util.debug('p_customer_trx_line_id = ' ||
711: TO_CHAR( p_customer_trx_line_id));
712: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
713: TO_CHAR( p_cust_trx_line_salesrep_id));
714:
708:
709: arp_util.debug('p_customer_trx_id = ' || TO_CHAR( p_customer_trx_id));
710: arp_util.debug('p_customer_trx_line_id = ' ||
711: TO_CHAR( p_customer_trx_line_id));
712: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
713: TO_CHAR( p_cust_trx_line_salesrep_id));
714:
715: RAISE;
716:
728: | |
729: | SCOPE - PRIVATE |
730: | |
731: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
732: | arp_util.debug |
733: | |
734: | ARGUMENTS : IN: |
735: | p_old_srep_rec |
736: | p_new_srep_rec |
766: l_status2 varchar2(100);
767:
768: BEGIN
769:
770: arp_util.debug('arp_process_salescredit.backout_salesrep()+');
771:
772: l_old_srep_rec := p_old_srep_rec;
773: l_new_srep_rec := p_new_srep_rec;
774:
829: l_cust_trx_line_salesrep_id,
830: l_status2 );
831: END IF;
832:
833: arp_util.debug('l_status1 = ' || l_status1);
834: arp_util.debug('l_status2 = ' || l_status2);
835:
836: IF ( NVL(l_status1, 'OK') <> 'OK')
837: THEN p_status := l_status1;
830: l_status2 );
831: END IF;
832:
833: arp_util.debug('l_status1 = ' || l_status1);
834: arp_util.debug('l_status2 = ' || l_status2);
835:
836: IF ( NVL(l_status1, 'OK') <> 'OK')
837: THEN p_status := l_status1;
838: ELSE IF ( NVL(l_status2, 'OK') <> 'OK' )
840: ELSE p_status := 'OK';
841: END IF;
842: END IF;
843:
844: arp_util.debug('arp_process_salescredit.backout_salesrep()-');
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_salesrep()');
844: arp_util.debug('arp_process_salescredit.backout_salesrep()-');
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_salesrep()');
849: RAISE;
850:
851: END;
852:
861: | |
862: | SCOPE - PRIVATE |
863: | |
864: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
865: | arp_util.debug |
866: | |
867: | ARGUMENTS : IN: |
868: | p_old_srep_rec |
869: | p_new_srep_rec |
897: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
898:
899: BEGIN
900:
901: arp_util.debug('arp_process_salescredit.backout_amount()+');
902:
903: l_old_srep_rec := p_old_srep_rec;
904: l_new_srep_rec := p_new_srep_rec;
905:
945: l_cust_trx_line_salesrep_id,
946: p_status );
947: END IF;
948:
949: arp_util.debug('arp_process_salescredit.backout_amount()-');
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_amount()');
949: arp_util.debug('arp_process_salescredit.backout_amount()-');
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_amount()');
954: RAISE;
955:
956: END;
957:
972: | |
973: | SCOPE - PRIVATE |
974: | |
975: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
976: | arp_util.debug |
977: | arp_process_tax.validate_tax_enforcement |
978: | |
979: | ARGUMENTS : IN: |
980: | p_customer_trx_id |
1001:
1002: BEGIN
1003:
1004: IF PG_DEBUG in ('Y', 'C') THEN
1005: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()+');
1006: END IF;
1007:
1008: p_status := 'OK';
1009:
1007:
1008: p_status := 'OK';
1009:
1010: IF PG_DEBUG in ('Y', 'C') THEN
1011: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()-');
1012: END IF;
1013:
1014: END val_tax_from_revenue;
1015:
1022: | |
1023: | SCOPE - PUBLIC |
1024: | |
1025: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1026: | arp_util.debug |
1027: | |
1028: | ARGUMENTS : IN: |
1029: | p_form_name |
1030: | p_form_version |
1063: l_status2 VARCHAR2(100);
1064:
1065: BEGIN
1066:
1067: arp_util.debug('arp_process_salescredit.insert_salescredit()+');
1068:
1069: /*----------------------------------------------+
1070: | Check the form version to determine if it |
1071: | is compatible with the entity handler. |
1119: l_status2 );
1120:
1121: END IF;
1122:
1123: arp_util.debug('l_status1 = ' || l_status1);
1124: arp_util.debug('l_status2 = ' || l_status2);
1125:
1126: IF ( NVL(l_status1, 'OK') <> 'OK' )
1127: THEN p_status := l_status1;
1120:
1121: END IF;
1122:
1123: arp_util.debug('l_status1 = ' || l_status1);
1124: arp_util.debug('l_status2 = ' || l_status2);
1125:
1126: IF ( NVL(l_status1, 'OK') <> 'OK' )
1127: THEN p_status := l_status1;
1128: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )
1130: ELSE p_status := 'OK';
1131: END IF;
1132:
1133:
1134: arp_util.debug('arp_process_salescredit.insert_salescredit()-');
1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138:
1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138:
1139: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
1140:
1141: /*---------------------------------------------+
1142: | Display parameters and raise the exception |
1143: +---------------------------------------------*/
1141: /*---------------------------------------------+
1142: | Display parameters and raise the exception |
1143: +---------------------------------------------*/
1144:
1145: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
1146:
1147: arp_util.debug('');
1148: arp_util.debug('---------- insert_salescredit() ---------');
1149:
1143: +---------------------------------------------*/
1144:
1145: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
1146:
1147: arp_util.debug('');
1148: arp_util.debug('---------- insert_salescredit() ---------');
1149:
1150: arp_util.debug('p_form_name = ' || p_form_name);
1151: arp_util.debug('p_form_version = ' || p_form_version);
1144:
1145: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
1146:
1147: arp_util.debug('');
1148: arp_util.debug('---------- insert_salescredit() ---------');
1149:
1150: arp_util.debug('p_form_name = ' || p_form_name);
1151: arp_util.debug('p_form_version = ' || p_form_version);
1152:
1146:
1147: arp_util.debug('');
1148: arp_util.debug('---------- insert_salescredit() ---------');
1149:
1150: arp_util.debug('p_form_name = ' || p_form_name);
1151: arp_util.debug('p_form_version = ' || p_form_version);
1152:
1153: arp_util.debug('p_run_auto_accounting_flag = ' ||
1154: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1147: arp_util.debug('');
1148: arp_util.debug('---------- insert_salescredit() ---------');
1149:
1150: arp_util.debug('p_form_name = ' || p_form_name);
1151: arp_util.debug('p_form_version = ' || p_form_version);
1152:
1153: arp_util.debug('p_run_auto_accounting_flag = ' ||
1154: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1155:
1149:
1150: arp_util.debug('p_form_name = ' || p_form_name);
1151: arp_util.debug('p_form_version = ' || p_form_version);
1152:
1153: arp_util.debug('p_run_auto_accounting_flag = ' ||
1154: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1155:
1156: arp_util.debug('');
1157: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1152:
1153: arp_util.debug('p_run_auto_accounting_flag = ' ||
1154: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1155:
1156: arp_util.debug('');
1157: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1158: arp_util.debug('');
1159:
1160: RAISE;
1154: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1155:
1156: arp_util.debug('');
1157: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1158: arp_util.debug('');
1159:
1160: RAISE;
1161:
1162: END;
1170: | |
1171: | SCOPE - PUBLIC |
1172: | |
1173: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1174: | arp_util.debug |
1175: | |
1176: | ARGUMENTS : IN: |
1177: | p_form_name |
1178: | p_form_version |
1234: l_status4 varchar2(100);
1235:
1236: BEGIN
1237:
1238: arp_util.debug('arp_process_salescredit.update_salescredit()+');
1239:
1240: /*----------------------------------------------+
1241: | Check the form version to determine if it |
1242: | is compatible with the entity handler. |
1285: /*--------------------------------------+
1286: | Do a simple update with no backout. |
1287: +--------------------------------------*/
1288:
1289: arp_util.debug('simple update - case 1');
1290: arp_ctls_pkg.update_p( p_srep_rec,
1291: p_cust_trx_line_salesrep_id);
1292:
1293: ELSE
1328: | Do a simple update with no backout. |
1329: | Nothing of consequence has changed. |
1330: +--------------------------------------*/
1331:
1332: arp_util.debug('simple update - case 2');
1333:
1334: arp_ctls_pkg.update_p(p_srep_rec,
1335: p_cust_trx_line_salesrep_id);
1336: END IF;
1394:
1395: END IF;
1396:
1397:
1398: arp_util.debug('l_status1 = ' || l_status1);
1399: arp_util.debug('l_status2 = ' || l_status2);
1400: arp_util.debug('l_status3 = ' || l_status3);
1401: arp_util.debug('l_status4 = ' || l_status4);
1402:
1395: END IF;
1396:
1397:
1398: arp_util.debug('l_status1 = ' || l_status1);
1399: arp_util.debug('l_status2 = ' || l_status2);
1400: arp_util.debug('l_status3 = ' || l_status3);
1401: arp_util.debug('l_status4 = ' || l_status4);
1402:
1403: IF ( NVL(l_status1, 'OK') <> 'OK' )
1396:
1397:
1398: arp_util.debug('l_status1 = ' || l_status1);
1399: arp_util.debug('l_status2 = ' || l_status2);
1400: arp_util.debug('l_status3 = ' || l_status3);
1401: arp_util.debug('l_status4 = ' || l_status4);
1402:
1403: IF ( NVL(l_status1, 'OK') <> 'OK' )
1404: THEN p_status := l_status1;
1397:
1398: arp_util.debug('l_status1 = ' || l_status1);
1399: arp_util.debug('l_status2 = ' || l_status2);
1400: arp_util.debug('l_status3 = ' || l_status3);
1401: arp_util.debug('l_status4 = ' || l_status4);
1402:
1403: IF ( NVL(l_status1, 'OK') <> 'OK' )
1404: THEN p_status := l_status1;
1405: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )
1410: THEN p_status := l_status4;
1411: ELSE p_status := 'OK';
1412: END IF;
1413:
1414: arp_util.debug('arp_process_salescredit.update_salescredit()-');
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418:
1420: /*---------------------------------------------+
1421: | Display parameters and raise the exception |
1422: +---------------------------------------------*/
1423:
1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
1425: arp_util.debug('');
1426: arp_util.debug('---------- parameters for update_salescredit() ---------');
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);
1421: | Display parameters and raise the exception |
1422: +---------------------------------------------*/
1423:
1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
1425: arp_util.debug('');
1426: arp_util.debug('---------- parameters for update_salescredit() ---------');
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);
1429:
1422: +---------------------------------------------*/
1423:
1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
1425: arp_util.debug('');
1426: arp_util.debug('---------- parameters for update_salescredit() ---------');
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);
1429:
1430:
1423:
1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
1425: arp_util.debug('');
1426: arp_util.debug('---------- parameters for update_salescredit() ---------');
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);
1429:
1430:
1431: arp_util.debug('p_run_auto_accounting_flag = ' ||
1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
1425: arp_util.debug('');
1426: arp_util.debug('---------- parameters for update_salescredit() ---------');
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);
1429:
1430:
1431: arp_util.debug('p_run_auto_accounting_flag = ' ||
1432: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);
1429:
1430:
1431: arp_util.debug('p_run_auto_accounting_flag = ' ||
1432: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1433:
1434: arp_util.debug('p_backout_flag = ' ||
1435: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1430:
1431: arp_util.debug('p_run_auto_accounting_flag = ' ||
1432: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1433:
1434: arp_util.debug('p_backout_flag = ' ||
1435: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1436:
1437: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1438: p_cust_trx_line_salesrep_id);
1433:
1434: arp_util.debug('p_backout_flag = ' ||
1435: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1436:
1437: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1438: p_cust_trx_line_salesrep_id);
1439: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1440: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1441:
1435: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1436:
1437: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1438: p_cust_trx_line_salesrep_id);
1439: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1440: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1441:
1442: arp_util.debug('');
1443: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1436:
1437: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1438: p_cust_trx_line_salesrep_id);
1439: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1440: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1441:
1442: arp_util.debug('');
1443: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1444: arp_util.debug('');
1438: p_cust_trx_line_salesrep_id);
1439: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1440: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1441:
1442: arp_util.debug('');
1443: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1444: arp_util.debug('');
1445:
1446: RAISE;
1440: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1441:
1442: arp_util.debug('');
1443: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1444: arp_util.debug('');
1445:
1446: RAISE;
1447:
1448: END;
1456: | |
1457: | SCOPE - PUBLIC |
1458: | |
1459: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1460: | arp_util.debug |
1461: | |
1462: | ARGUMENTS : IN: |
1463: | p_form_name |
1464: | p_form_version |
1510: l_status3 varchar2(100);
1511:
1512: BEGIN
1513:
1514: arp_util.debug('arp_process_salescredit.delete_salescredit()+');
1515:
1516: /*----------------------------------------------+
1517: | Check the form version to determine if it |
1518: | is compatible with the entity handler. |
1610: l_status3 );
1611:
1612: END IF;
1613:
1614: arp_util.debug('l_status1 = ' || l_status1);
1615: arp_util.debug('l_status2 = ' || l_status2);
1616: arp_util.debug('l_status3 = ' || l_status3);
1617:
1618: IF ( NVL(l_status1, 'OK') <> 'OK' )
1611:
1612: END IF;
1613:
1614: arp_util.debug('l_status1 = ' || l_status1);
1615: arp_util.debug('l_status2 = ' || l_status2);
1616: arp_util.debug('l_status3 = ' || l_status3);
1617:
1618: IF ( NVL(l_status1, 'OK') <> 'OK' )
1619: THEN p_status := l_status1;
1612: END IF;
1613:
1614: arp_util.debug('l_status1 = ' || l_status1);
1615: arp_util.debug('l_status2 = ' || l_status2);
1616: arp_util.debug('l_status3 = ' || l_status3);
1617:
1618: IF ( NVL(l_status1, 'OK') <> 'OK' )
1619: THEN p_status := l_status1;
1620: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )
1623: THEN p_status := l_status3;
1624: ELSE p_status := 'OK';
1625: END IF;
1626:
1627: arp_util.debug('arp_process_salescredit.delete_salescredit()-');
1628:
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631:
1633: /*---------------------------------------------+
1634: | Display parameters and raise the exception |
1635: +---------------------------------------------*/
1636:
1637: arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');
1638:
1639: arp_util.debug('');
1640: arp_util.debug('---------- delete_salescredit() ---------');
1641:
1635: +---------------------------------------------*/
1636:
1637: arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');
1638:
1639: arp_util.debug('');
1640: arp_util.debug('---------- delete_salescredit() ---------');
1641:
1642: arp_util.debug('p_form_name = ' || p_form_name);
1643: arp_util.debug('p_form_version = ' || p_form_version);
1636:
1637: arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');
1638:
1639: arp_util.debug('');
1640: arp_util.debug('---------- delete_salescredit() ---------');
1641:
1642: arp_util.debug('p_form_name = ' || p_form_name);
1643: arp_util.debug('p_form_version = ' || p_form_version);
1644:
1638:
1639: arp_util.debug('');
1640: arp_util.debug('---------- delete_salescredit() ---------');
1641:
1642: arp_util.debug('p_form_name = ' || p_form_name);
1643: arp_util.debug('p_form_version = ' || p_form_version);
1644:
1645: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1646: p_cust_trx_line_salesrep_id);
1639: arp_util.debug('');
1640: arp_util.debug('---------- delete_salescredit() ---------');
1641:
1642: arp_util.debug('p_form_name = ' || p_form_name);
1643: arp_util.debug('p_form_version = ' || p_form_version);
1644:
1645: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1646: p_cust_trx_line_salesrep_id);
1647: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1641:
1642: arp_util.debug('p_form_name = ' || p_form_name);
1643: arp_util.debug('p_form_version = ' || p_form_version);
1644:
1645: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1646: p_cust_trx_line_salesrep_id);
1647: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1648: arp_util.debug('p_customer_trx_line_id = ' ||
1649: p_customer_trx_line_id);
1643: arp_util.debug('p_form_version = ' || p_form_version);
1644:
1645: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1646: p_cust_trx_line_salesrep_id);
1647: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1648: arp_util.debug('p_customer_trx_line_id = ' ||
1649: p_customer_trx_line_id);
1650:
1651: arp_util.debug('p_run_auto_accounting_flag = ' ||
1644:
1645: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1646: p_cust_trx_line_salesrep_id);
1647: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1648: arp_util.debug('p_customer_trx_line_id = ' ||
1649: p_customer_trx_line_id);
1650:
1651: arp_util.debug('p_run_auto_accounting_flag = ' ||
1652: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1647: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1648: arp_util.debug('p_customer_trx_line_id = ' ||
1649: p_customer_trx_line_id);
1650:
1651: arp_util.debug('p_run_auto_accounting_flag = ' ||
1652: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1653:
1654: arp_util.debug('p_backout_flag = ' ||
1655: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1650:
1651: arp_util.debug('p_run_auto_accounting_flag = ' ||
1652: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1653:
1654: arp_util.debug('p_backout_flag = ' ||
1655: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1656:
1657: arp_util.debug('');
1658: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1653:
1654: arp_util.debug('p_backout_flag = ' ||
1655: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1656:
1657: arp_util.debug('');
1658: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1659: arp_util.debug('');
1660:
1661: RAISE;
1655: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1656:
1657: arp_util.debug('');
1658: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1659: arp_util.debug('');
1660:
1661: RAISE;
1662:
1663: END;
1672: | |
1673: | SCOPE - PUBLIC |
1674: | |
1675: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1676: | arp_util.debug |
1677: | |
1678: | ARGUMENTS : IN: |
1679: | p_customer_trx_id |
1680: | p_customer_trx_line_id |
1713: p_salesrep_id ra_customer_trx.primary_salesrep_id%type;
1714:
1715: BEGIN
1716:
1717: arp_util.debug('arp_process_salescredit.create_line_salescredits()+');
1718:
1719: /*-------------------------------------+
1720: |Checking whether its Credit Memo |
1721: +-------------------------------------*/
1817:
1818:
1819: END IF;
1820:
1821: arp_util.debug('l_status1 = ' || l_status1);
1822: arp_util.debug('l_status2 = ' || l_status2);
1823:
1824: IF ( NVL(l_status1, 'OK') <> 'OK' )
1825: THEN p_status := l_status1;
1818:
1819: END IF;
1820:
1821: arp_util.debug('l_status1 = ' || l_status1);
1822: arp_util.debug('l_status2 = ' || l_status2);
1823:
1824: IF ( NVL(l_status1, 'OK') <> 'OK' )
1825: THEN p_status := l_status1;
1826: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )
1827: THEN p_status := l_status2;
1828: ELSE p_status := 'OK';
1829: END IF;
1830:
1831: arp_util.debug('arp_process_salescredit.create_line_salescredits()-');
1832:
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: arp_util.debug(sqlerrm);
1831: arp_util.debug('arp_process_salescredit.create_line_salescredits()-');
1832:
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: arp_util.debug(sqlerrm);
1836: arp_util.debug(
1837: 'EXCEPTION: arp_process_salescredit.create_line_salescredits()');
1838:
1839:
1832:
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: arp_util.debug(sqlerrm);
1836: arp_util.debug(
1837: 'EXCEPTION: arp_process_salescredit.create_line_salescredits()');
1838:
1839:
1840: arp_util.debug('');
1836: arp_util.debug(
1837: 'EXCEPTION: arp_process_salescredit.create_line_salescredits()');
1838:
1839:
1840: arp_util.debug('');
1841: arp_util.debug('---- parameters for create_line_salescredits() -----');
1842:
1843: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1844: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1837: 'EXCEPTION: arp_process_salescredit.create_line_salescredits()');
1838:
1839:
1840: arp_util.debug('');
1841: arp_util.debug('---- parameters for create_line_salescredits() -----');
1842:
1843: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1844: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1845: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1839:
1840: arp_util.debug('');
1841: arp_util.debug('---- parameters for create_line_salescredits() -----');
1842:
1843: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1844: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1845: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1846:
1847:
1840: arp_util.debug('');
1841: arp_util.debug('---- parameters for create_line_salescredits() -----');
1842:
1843: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1844: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1845: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1846:
1847:
1848: RAISE;
1841: arp_util.debug('---- parameters for create_line_salescredits() -----');
1842:
1843: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1844: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1845: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1846:
1847:
1848: RAISE;
1849:
1859: | |
1860: | SCOPE - PUBLIC |
1861: | |
1862: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1863: | arp_util.debug |
1864: | |
1865: | ARGUMENTS : IN: |
1866: | p_form_name |
1867: | p_form_version |
1976: /* bug 3607146 */
1977: l_scredit_count NUMBER;
1978: BEGIN
1979:
1980: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()+');
1981:
1982: /*------------------------------------------------+
1983: | Populate the salescredit record group with |
1984: | the values passed in as parameters. |
2026: /* bug 3607146 */
2027: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,
2028: l_scredit_count);
2029:
2030: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()-');
2031:
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034:
2031:
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034:
2035: arp_util.debug(
2036: 'EXCEPTION: arp_process_salescredit.insert_salescredit_cover()');
2037:
2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
2039: '---------');
2034:
2035: arp_util.debug(
2036: 'EXCEPTION: arp_process_salescredit.insert_salescredit_cover()');
2037:
2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
2039: '---------');
2040: arp_util.debug('p_form_name = ' || p_form_name );
2041: arp_util.debug('p_form_version = ' || p_form_version );
2042: arp_util.debug('p_run_auto_accounting_flag = ' ||
2036: 'EXCEPTION: arp_process_salescredit.insert_salescredit_cover()');
2037:
2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
2039: '---------');
2040: arp_util.debug('p_form_name = ' || p_form_name );
2041: arp_util.debug('p_form_version = ' || p_form_version );
2042: arp_util.debug('p_run_auto_accounting_flag = ' ||
2043: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2037:
2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
2039: '---------');
2040: arp_util.debug('p_form_name = ' || p_form_name );
2041: arp_util.debug('p_form_version = ' || p_form_version );
2042: arp_util.debug('p_run_auto_accounting_flag = ' ||
2043: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2045: arp_util.debug('p_customer_trx_line_id = ' ||
2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
2039: '---------');
2040: arp_util.debug('p_form_name = ' || p_form_name );
2041: arp_util.debug('p_form_version = ' || p_form_version );
2042: arp_util.debug('p_run_auto_accounting_flag = ' ||
2043: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2045: arp_util.debug('p_customer_trx_line_id = ' ||
2046: p_customer_trx_line_id );
2040: arp_util.debug('p_form_name = ' || p_form_name );
2041: arp_util.debug('p_form_version = ' || p_form_version );
2042: arp_util.debug('p_run_auto_accounting_flag = ' ||
2043: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2045: arp_util.debug('p_customer_trx_line_id = ' ||
2046: p_customer_trx_line_id );
2047: arp_util.debug('p_salesrep_id = ' ||
2048: p_salesrep_id );
2041: arp_util.debug('p_form_version = ' || p_form_version );
2042: arp_util.debug('p_run_auto_accounting_flag = ' ||
2043: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2045: arp_util.debug('p_customer_trx_line_id = ' ||
2046: p_customer_trx_line_id );
2047: arp_util.debug('p_salesrep_id = ' ||
2048: p_salesrep_id );
2049: arp_util.debug('p_revenue_amount_split = ' ||
2043: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2045: arp_util.debug('p_customer_trx_line_id = ' ||
2046: p_customer_trx_line_id );
2047: arp_util.debug('p_salesrep_id = ' ||
2048: p_salesrep_id );
2049: arp_util.debug('p_revenue_amount_split = ' ||
2050: p_revenue_amount_split );
2051: arp_util.debug('p_non_revenue_amount_split = ' ||
2045: arp_util.debug('p_customer_trx_line_id = ' ||
2046: p_customer_trx_line_id );
2047: arp_util.debug('p_salesrep_id = ' ||
2048: p_salesrep_id );
2049: arp_util.debug('p_revenue_amount_split = ' ||
2050: p_revenue_amount_split );
2051: arp_util.debug('p_non_revenue_amount_split = ' ||
2052: p_non_revenue_amount_split );
2053: arp_util.debug('p_non_revenue_percent_split = ' ||
2047: arp_util.debug('p_salesrep_id = ' ||
2048: p_salesrep_id );
2049: arp_util.debug('p_revenue_amount_split = ' ||
2050: p_revenue_amount_split );
2051: arp_util.debug('p_non_revenue_amount_split = ' ||
2052: p_non_revenue_amount_split );
2053: arp_util.debug('p_non_revenue_percent_split = ' ||
2054: p_non_revenue_percent_split );
2055: arp_util.debug('p_revenue_percent_split = ' ||
2049: arp_util.debug('p_revenue_amount_split = ' ||
2050: p_revenue_amount_split );
2051: arp_util.debug('p_non_revenue_amount_split = ' ||
2052: p_non_revenue_amount_split );
2053: arp_util.debug('p_non_revenue_percent_split = ' ||
2054: p_non_revenue_percent_split );
2055: arp_util.debug('p_revenue_percent_split = ' ||
2056: p_revenue_percent_split );
2057: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2051: arp_util.debug('p_non_revenue_amount_split = ' ||
2052: p_non_revenue_amount_split );
2053: arp_util.debug('p_non_revenue_percent_split = ' ||
2054: p_non_revenue_percent_split );
2055: arp_util.debug('p_revenue_percent_split = ' ||
2056: p_revenue_percent_split );
2057: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2058: p_prev_cust_trx_line_srep_id );
2059: arp_util.debug('p_attribute_category = ' ||
2053: arp_util.debug('p_non_revenue_percent_split = ' ||
2054: p_non_revenue_percent_split );
2055: arp_util.debug('p_revenue_percent_split = ' ||
2056: p_revenue_percent_split );
2057: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2058: p_prev_cust_trx_line_srep_id );
2059: arp_util.debug('p_attribute_category = ' ||
2060: p_attribute_category );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2055: arp_util.debug('p_revenue_percent_split = ' ||
2056: p_revenue_percent_split );
2057: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2058: p_prev_cust_trx_line_srep_id );
2059: arp_util.debug('p_attribute_category = ' ||
2060: p_attribute_category );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2057: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2058: p_prev_cust_trx_line_srep_id );
2059: arp_util.debug('p_attribute_category = ' ||
2060: p_attribute_category );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2058: p_prev_cust_trx_line_srep_id );
2059: arp_util.debug('p_attribute_category = ' ||
2060: p_attribute_category );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2059: arp_util.debug('p_attribute_category = ' ||
2060: p_attribute_category );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2060: p_attribute_category );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2061: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2062: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2063: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2077: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2077: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2078:
2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2077: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2078:
2079: RAISE;
2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2077: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2078:
2079: RAISE;
2080:
2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2077: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2078:
2079: RAISE;
2080:
2081: END;
2091: | |
2092: | SCOPE - PUBLIC |
2093: | |
2094: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2095: | arp_util.debug |
2096: | |
2097: | ARGUMENTS : IN: |
2098: | p_form_name |
2099: | p_form_version |
2210: l_scredit_count NUMBER;
2211:
2212: BEGIN
2213:
2214: arp_util.debug('arp_process_salescredit.update_salescredit_cover()+');
2215:
2216: /*------------------------------------------------+
2217: | Populate the salescredit record group with |
2218: | the values passed in as parameters. |
2268: /* bug 3607146 */
2269: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,
2270: l_scredit_count);
2271:
2272: arp_util.debug('arp_process_salescredit.update_salescredit_cover()-');
2273:
2274: EXCEPTION
2275: WHEN OTHERS THEN
2276:
2273:
2274: EXCEPTION
2275: WHEN OTHERS THEN
2276:
2277: arp_util.debug(
2278: 'EXCEPTION: arp_process_salescredit.update_salescredit_cover()');
2279:
2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||
2281: '---------');
2276:
2277: arp_util.debug(
2278: 'EXCEPTION: arp_process_salescredit.update_salescredit_cover()');
2279:
2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||
2281: '---------');
2282: arp_util.debug('p_form_name = ' || p_form_name );
2283: arp_util.debug('p_form_version = ' || p_form_version );
2284: arp_util.debug('p_run_auto_accounting_flag = ' ||
2278: 'EXCEPTION: arp_process_salescredit.update_salescredit_cover()');
2279:
2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||
2281: '---------');
2282: arp_util.debug('p_form_name = ' || p_form_name );
2283: arp_util.debug('p_form_version = ' || p_form_version );
2284: arp_util.debug('p_run_auto_accounting_flag = ' ||
2285: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2286: arp_util.debug('p_backout_flag = ' ||
2279:
2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||
2281: '---------');
2282: arp_util.debug('p_form_name = ' || p_form_name );
2283: arp_util.debug('p_form_version = ' || p_form_version );
2284: arp_util.debug('p_run_auto_accounting_flag = ' ||
2285: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2286: arp_util.debug('p_backout_flag = ' ||
2287: arp_trx_util.boolean_to_varchar2(p_backout_flag) );
2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||
2281: '---------');
2282: arp_util.debug('p_form_name = ' || p_form_name );
2283: arp_util.debug('p_form_version = ' || p_form_version );
2284: arp_util.debug('p_run_auto_accounting_flag = ' ||
2285: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2286: arp_util.debug('p_backout_flag = ' ||
2287: arp_trx_util.boolean_to_varchar2(p_backout_flag) );
2288: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2282: arp_util.debug('p_form_name = ' || p_form_name );
2283: arp_util.debug('p_form_version = ' || p_form_version );
2284: arp_util.debug('p_run_auto_accounting_flag = ' ||
2285: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2286: arp_util.debug('p_backout_flag = ' ||
2287: arp_trx_util.boolean_to_varchar2(p_backout_flag) );
2288: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2289: arp_util.debug('p_customer_trx_line_id = ' ||
2290: p_customer_trx_line_id );
2284: arp_util.debug('p_run_auto_accounting_flag = ' ||
2285: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2286: arp_util.debug('p_backout_flag = ' ||
2287: arp_trx_util.boolean_to_varchar2(p_backout_flag) );
2288: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2289: arp_util.debug('p_customer_trx_line_id = ' ||
2290: p_customer_trx_line_id );
2291: arp_util.debug('p_salesrep_id = ' ||
2292: p_salesrep_id );
2285: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2286: arp_util.debug('p_backout_flag = ' ||
2287: arp_trx_util.boolean_to_varchar2(p_backout_flag) );
2288: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2289: arp_util.debug('p_customer_trx_line_id = ' ||
2290: p_customer_trx_line_id );
2291: arp_util.debug('p_salesrep_id = ' ||
2292: p_salesrep_id );
2293: arp_util.debug('p_revenue_amount_split = ' ||
2287: arp_trx_util.boolean_to_varchar2(p_backout_flag) );
2288: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2289: arp_util.debug('p_customer_trx_line_id = ' ||
2290: p_customer_trx_line_id );
2291: arp_util.debug('p_salesrep_id = ' ||
2292: p_salesrep_id );
2293: arp_util.debug('p_revenue_amount_split = ' ||
2294: p_revenue_amount_split );
2295: arp_util.debug('p_non_revenue_amount_split = ' ||
2289: arp_util.debug('p_customer_trx_line_id = ' ||
2290: p_customer_trx_line_id );
2291: arp_util.debug('p_salesrep_id = ' ||
2292: p_salesrep_id );
2293: arp_util.debug('p_revenue_amount_split = ' ||
2294: p_revenue_amount_split );
2295: arp_util.debug('p_non_revenue_amount_split = ' ||
2296: p_non_revenue_amount_split );
2297: arp_util.debug('p_non_revenue_percent_split = ' ||
2291: arp_util.debug('p_salesrep_id = ' ||
2292: p_salesrep_id );
2293: arp_util.debug('p_revenue_amount_split = ' ||
2294: p_revenue_amount_split );
2295: arp_util.debug('p_non_revenue_amount_split = ' ||
2296: p_non_revenue_amount_split );
2297: arp_util.debug('p_non_revenue_percent_split = ' ||
2298: p_non_revenue_percent_split );
2299: arp_util.debug('p_revenue_percent_split = ' ||
2293: arp_util.debug('p_revenue_amount_split = ' ||
2294: p_revenue_amount_split );
2295: arp_util.debug('p_non_revenue_amount_split = ' ||
2296: p_non_revenue_amount_split );
2297: arp_util.debug('p_non_revenue_percent_split = ' ||
2298: p_non_revenue_percent_split );
2299: arp_util.debug('p_revenue_percent_split = ' ||
2300: p_revenue_percent_split );
2301: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2295: arp_util.debug('p_non_revenue_amount_split = ' ||
2296: p_non_revenue_amount_split );
2297: arp_util.debug('p_non_revenue_percent_split = ' ||
2298: p_non_revenue_percent_split );
2299: arp_util.debug('p_revenue_percent_split = ' ||
2300: p_revenue_percent_split );
2301: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2302: p_prev_cust_trx_line_srep_id );
2303: arp_util.debug('p_attribute_category = ' ||
2297: arp_util.debug('p_non_revenue_percent_split = ' ||
2298: p_non_revenue_percent_split );
2299: arp_util.debug('p_revenue_percent_split = ' ||
2300: p_revenue_percent_split );
2301: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2302: p_prev_cust_trx_line_srep_id );
2303: arp_util.debug('p_attribute_category = ' ||
2304: p_attribute_category );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2299: arp_util.debug('p_revenue_percent_split = ' ||
2300: p_revenue_percent_split );
2301: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2302: p_prev_cust_trx_line_srep_id );
2303: arp_util.debug('p_attribute_category = ' ||
2304: p_attribute_category );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2301: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2302: p_prev_cust_trx_line_srep_id );
2303: arp_util.debug('p_attribute_category = ' ||
2304: p_attribute_category );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2302: p_prev_cust_trx_line_srep_id );
2303: arp_util.debug('p_attribute_category = ' ||
2304: p_attribute_category );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2303: arp_util.debug('p_attribute_category = ' ||
2304: p_attribute_category );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2304: p_attribute_category );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2321: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2321: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2322:
2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2321: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2322:
2323: RAISE;
2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2321: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2322:
2323: RAISE;
2324:
2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2321: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2322:
2323: RAISE;
2324:
2325: END;
2335: | |
2336: | SCOPE - PUBLIC |
2337: | |
2338: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2339: | arp_util.debug |
2340: | |
2341: | ARGUMENTS : IN: |
2342: | p_form_name |
2343: | p_form_version |
2454: l_scredit_count NUMBER;
2455:
2456: BEGIN
2457:
2458: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()+');
2459:
2460: /*------------------------------------------------+
2461: | Populate the salescredit record group with |
2462: | the values passed in as parameters. |
2511: /* bug 3607146 */
2512: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,
2513: l_scredit_count);
2514:
2515: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()-');
2516:
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519:
2516:
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519:
2520: arp_util.debug(
2521: 'EXCEPTION: arp_process_salescredit.delete_salescredit_cover()');
2522:
2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
2524: '---------');
2519:
2520: arp_util.debug(
2521: 'EXCEPTION: arp_process_salescredit.delete_salescredit_cover()');
2522:
2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
2524: '---------');
2525: arp_util.debug('p_form_name = ' || p_form_name );
2526: arp_util.debug('p_form_version = ' || p_form_version );
2527: arp_util.debug('p_run_auto_accounting_flag = ' ||
2521: 'EXCEPTION: arp_process_salescredit.delete_salescredit_cover()');
2522:
2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
2524: '---------');
2525: arp_util.debug('p_form_name = ' || p_form_name );
2526: arp_util.debug('p_form_version = ' || p_form_version );
2527: arp_util.debug('p_run_auto_accounting_flag = ' ||
2528: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2529: arp_util.debug('p_backout_flag = ' ||
2522:
2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
2524: '---------');
2525: arp_util.debug('p_form_name = ' || p_form_name );
2526: arp_util.debug('p_form_version = ' || p_form_version );
2527: arp_util.debug('p_run_auto_accounting_flag = ' ||
2528: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2529: arp_util.debug('p_backout_flag = ' ||
2530: arp_trx_util.boolean_to_varchar2(p_backout_flag));
2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
2524: '---------');
2525: arp_util.debug('p_form_name = ' || p_form_name );
2526: arp_util.debug('p_form_version = ' || p_form_version );
2527: arp_util.debug('p_run_auto_accounting_flag = ' ||
2528: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2529: arp_util.debug('p_backout_flag = ' ||
2530: arp_trx_util.boolean_to_varchar2(p_backout_flag));
2531: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2525: arp_util.debug('p_form_name = ' || p_form_name );
2526: arp_util.debug('p_form_version = ' || p_form_version );
2527: arp_util.debug('p_run_auto_accounting_flag = ' ||
2528: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2529: arp_util.debug('p_backout_flag = ' ||
2530: arp_trx_util.boolean_to_varchar2(p_backout_flag));
2531: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2532: arp_util.debug('p_customer_trx_line_id = ' ||
2533: p_customer_trx_line_id );
2527: arp_util.debug('p_run_auto_accounting_flag = ' ||
2528: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2529: arp_util.debug('p_backout_flag = ' ||
2530: arp_trx_util.boolean_to_varchar2(p_backout_flag));
2531: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2532: arp_util.debug('p_customer_trx_line_id = ' ||
2533: p_customer_trx_line_id );
2534: arp_util.debug('p_salesrep_id = ' ||
2535: p_salesrep_id );
2528: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag) );
2529: arp_util.debug('p_backout_flag = ' ||
2530: arp_trx_util.boolean_to_varchar2(p_backout_flag));
2531: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2532: arp_util.debug('p_customer_trx_line_id = ' ||
2533: p_customer_trx_line_id );
2534: arp_util.debug('p_salesrep_id = ' ||
2535: p_salesrep_id );
2536: arp_util.debug('p_revenue_amount_split = ' ||
2530: arp_trx_util.boolean_to_varchar2(p_backout_flag));
2531: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
2532: arp_util.debug('p_customer_trx_line_id = ' ||
2533: p_customer_trx_line_id );
2534: arp_util.debug('p_salesrep_id = ' ||
2535: p_salesrep_id );
2536: arp_util.debug('p_revenue_amount_split = ' ||
2537: p_revenue_amount_split );
2538: arp_util.debug('p_non_revenue_amount_split = ' ||
2532: arp_util.debug('p_customer_trx_line_id = ' ||
2533: p_customer_trx_line_id );
2534: arp_util.debug('p_salesrep_id = ' ||
2535: p_salesrep_id );
2536: arp_util.debug('p_revenue_amount_split = ' ||
2537: p_revenue_amount_split );
2538: arp_util.debug('p_non_revenue_amount_split = ' ||
2539: p_non_revenue_amount_split );
2540: arp_util.debug('p_non_revenue_percent_split = ' ||
2534: arp_util.debug('p_salesrep_id = ' ||
2535: p_salesrep_id );
2536: arp_util.debug('p_revenue_amount_split = ' ||
2537: p_revenue_amount_split );
2538: arp_util.debug('p_non_revenue_amount_split = ' ||
2539: p_non_revenue_amount_split );
2540: arp_util.debug('p_non_revenue_percent_split = ' ||
2541: p_non_revenue_percent_split );
2542: arp_util.debug('p_revenue_percent_split = ' ||
2536: arp_util.debug('p_revenue_amount_split = ' ||
2537: p_revenue_amount_split );
2538: arp_util.debug('p_non_revenue_amount_split = ' ||
2539: p_non_revenue_amount_split );
2540: arp_util.debug('p_non_revenue_percent_split = ' ||
2541: p_non_revenue_percent_split );
2542: arp_util.debug('p_revenue_percent_split = ' ||
2543: p_revenue_percent_split );
2544: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2538: arp_util.debug('p_non_revenue_amount_split = ' ||
2539: p_non_revenue_amount_split );
2540: arp_util.debug('p_non_revenue_percent_split = ' ||
2541: p_non_revenue_percent_split );
2542: arp_util.debug('p_revenue_percent_split = ' ||
2543: p_revenue_percent_split );
2544: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2545: p_prev_cust_trx_line_srep_id );
2546: arp_util.debug('p_attribute_category = ' ||
2540: arp_util.debug('p_non_revenue_percent_split = ' ||
2541: p_non_revenue_percent_split );
2542: arp_util.debug('p_revenue_percent_split = ' ||
2543: p_revenue_percent_split );
2544: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2545: p_prev_cust_trx_line_srep_id );
2546: arp_util.debug('p_attribute_category = ' ||
2547: p_attribute_category );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2542: arp_util.debug('p_revenue_percent_split = ' ||
2543: p_revenue_percent_split );
2544: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2545: p_prev_cust_trx_line_srep_id );
2546: arp_util.debug('p_attribute_category = ' ||
2547: p_attribute_category );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2544: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
2545: p_prev_cust_trx_line_srep_id );
2546: arp_util.debug('p_attribute_category = ' ||
2547: p_attribute_category );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2545: p_prev_cust_trx_line_srep_id );
2546: arp_util.debug('p_attribute_category = ' ||
2547: p_attribute_category );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2546: arp_util.debug('p_attribute_category = ' ||
2547: p_attribute_category );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2547: p_attribute_category );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2564: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2564: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2565:
2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2564: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2565:
2566: RAISE;
2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2564: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2565:
2566: RAISE;
2567:
2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );
2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );
2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );
2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
2564: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
2565:
2566: RAISE;
2567:
2568: END;