DBA Data[Home] [Help]

APPS.ARP_PROCESS_SALESCREDIT dependencies on ARP_UTIL

Line 22: | arp_util.debug |

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

Line 45: arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');

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:

Line 48: arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');

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:

Line 57: arp_util.debug(

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() ---------');

Line 60: arp_util.debug('');

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:

Line 61: arp_util.debug('---------- val_insert_salescredit() ---------');

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;

Line 62: 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;
66:

Line 79: | arp_util.debug |

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

Line 101: arp_util.debug('arp_process_salescredit.val_update_salescredit()+');

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:

Line 104: arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');

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:

Line 113: arp_util.debug(

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('');

Line 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:

Line 118: arp_util.debug('---------- val_update_salescredit() ---------');

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;

Line 119: arp_util.debug('');

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:

Line 136: | arp_util.debug |

132: | |
133: | SCOPE - PRIVATE |
134: | |
135: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
136: | arp_util.debug |
137: | |
138: | ARGUMENTS : IN: |
139: | p_srep_rec |
140: | OUT: |

Line 158: arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');

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:

Line 161: arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');

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:

Line 170: arp_util.debug(

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('');

Line 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:

Line 175: arp_util.debug('---------- val_update_salescredit() ---------');

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;

Line 176: arp_util.debug('');

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:

Line 193: | arp_util.debug |

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 |

Line 241: arp_util.debug('arp_process_salescredit.set_flags()+');

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:

Line 318: arp_util.debug('revised backout flag: TRUE');

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;

Line 325: arp_util.debug('revised backout flag: ' ||

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:

Line 338: arp_util.debug('p_posted_flag = ' ||

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));

Line 341: arp_util.debug('p_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(

Line 344: arp_util.debug('p_amount_percent_changed_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(
346: l_amount_percent_changed_flag));
347:
348: arp_util.debug('p_rev_amt_percent_changed_flag = ' ||

Line 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 = ' ||

Line 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 = ' ||

Line 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()-');

Line 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:

Line 369: arp_util.debug('EXCEPTION: arp_process_salescredit.set_flags()');

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:

Line 371: arp_util.debug('');

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);

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

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:

Line 374: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||

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));

Line 377: arp_util.debug('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));

Line 380: arp_util.debug('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:

Line 383: arp_util.debug('');

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('');

Line 385: arp_util.debug('---------- new salescredit record ----------');

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;

Line 387: arp_util.debug('');

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;

Line 403: | arp_util.debug |

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 |

Line 444: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()+');

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 = ' ||

Line 446: arp_util.debug('p_customer_trx_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 = ' ||

Line 448: arp_util.debug('p_customer_trx_line_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:

Line 450: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||

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:

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

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;

Line 683: arp_util.debug('EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');

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;

Line 684: arp_util.debug(l_error_message);

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:

Line 689: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()-');

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:

Line 698: arp_util.debug(

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);

Line 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 () ' ||

Line 705: arp_util.debug('');

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));

Line 706: arp_util.debug('---------- parameters for run_autoacc_for_scredits () ' ||

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 = ' ||

Line 709: arp_util.debug('p_customer_trx_id = ' || TO_CHAR( p_customer_trx_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));

Line 710: arp_util.debug('p_customer_trx_line_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:

Line 712: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||

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:

Line 732: | arp_util.debug |

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 |

Line 770: arp_util.debug('arp_process_salescredit.backout_salesrep()+');

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:

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

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;

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

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' )

Line 844: arp_util.debug('arp_process_salescredit.backout_salesrep()-');

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()');

Line 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:

Line 865: | arp_util.debug |

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 |

Line 901: arp_util.debug('arp_process_salescredit.backout_amount()+');

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:

Line 949: arp_util.debug('arp_process_salescredit.backout_amount()-');

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()');

Line 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:

Line 976: | arp_util.debug |

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 |

Line 1005: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()+');

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:

Line 1011: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()-');

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:

Line 1026: | arp_util.debug |

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 |

Line 1067: arp_util.debug('arp_process_salescredit.insert_salescredit()+');

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. |

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

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;

Line 1124: arp_util.debug('l_status2 = ' || 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;
1128: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1134: arp_util.debug('arp_process_salescredit.insert_salescredit()-');

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:

Line 1139: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');

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: +---------------------------------------------*/

Line 1145: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');

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:

Line 1147: arp_util.debug('');

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);

Line 1148: arp_util.debug('---------- insert_salescredit() ---------');

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:

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

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));

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

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:

Line 1153: arp_util.debug('p_run_auto_accounting_flag = ' ||

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 );

Line 1156: arp_util.debug('');

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;

Line 1158: arp_util.debug('');

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;

Line 1174: | arp_util.debug |

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 |

Line 1238: arp_util.debug('arp_process_salescredit.update_salescredit()+');

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. |

Line 1289: arp_util.debug('simple update - case 1');

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

Line 1332: arp_util.debug('simple update - case 2');

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;

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

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:

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

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' )

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

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;

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

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' )

Line 1414: arp_util.debug('arp_process_salescredit.update_salescredit()-');

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:

Line 1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');

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);

Line 1425: arp_util.debug('');

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:

Line 1426: arp_util.debug('---------- parameters for update_salescredit() ---------');

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:

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

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 = ' ||

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

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));

Line 1431: arp_util.debug('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));

Line 1434: arp_util.debug('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);

Line 1437: arp_util.debug('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:

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

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 );

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

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('');

Line 1442: 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;

Line 1444: arp_util.debug('');

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;

Line 1460: | arp_util.debug |

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 |

Line 1514: arp_util.debug('arp_process_salescredit.delete_salescredit()+');

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. |

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

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' )

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

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;

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

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' )

Line 1627: arp_util.debug('arp_process_salescredit.delete_salescredit()-');

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:

Line 1637: arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');

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:

Line 1639: arp_util.debug('');

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);

Line 1640: arp_util.debug('---------- delete_salescredit() ---------');

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:

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

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);

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

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);

Line 1645: arp_util.debug('p_cust_trx_line_salesrep_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);

Line 1647: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_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 = ' ||

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

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));

Line 1651: arp_util.debug('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));

Line 1654: arp_util.debug('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 );

Line 1657: arp_util.debug('');

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;

Line 1659: arp_util.debug('');

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;

Line 1676: | arp_util.debug |

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 |

Line 1717: arp_util.debug('arp_process_salescredit.create_line_salescredits()+');

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: +-------------------------------------*/

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

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;

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

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' )

Line 1831: arp_util.debug('arp_process_salescredit.create_line_salescredits()-');

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);

Line 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:

Line 1836: arp_util.debug(

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('');

Line 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);

Line 1841: arp_util.debug('---- parameters for create_line_salescredits() -----');

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);

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

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:

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

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;

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

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:

Line 1863: | arp_util.debug |

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 |

Line 1980: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()+');

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. |

Line 2030: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()-');

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:

Line 2035: arp_util.debug(

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: '---------');

Line 2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||

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 = ' ||

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

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 );

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

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 = ' ||

Line 2042: arp_util.debug('p_run_auto_accounting_flag = ' ||

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 );

Line 2044: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_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 );

Line 2045: arp_util.debug('p_customer_trx_line_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 = ' ||

Line 2047: arp_util.debug('p_salesrep_id = ' ||

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 = ' ||

Line 2049: arp_util.debug('p_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 = ' ||

Line 2051: arp_util.debug('p_non_revenue_amount_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 = ' ||

Line 2053: arp_util.debug('p_non_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 = ' ||

Line 2055: arp_util.debug('p_revenue_percent_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 = ' ||
2058: p_prev_cust_trx_line_srep_id );
2059: arp_util.debug('p_attribute_category = ' ||

Line 2057: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||

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 );

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

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 );

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

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 );

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

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 );

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

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 );

Line 2064: arp_util.debug('p_attribute4 = ' || p_attribute4 );

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 );

Line 2065: arp_util.debug('p_attribute5 = ' || p_attribute5 );

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 );

Line 2066: arp_util.debug('p_attribute6 = ' || p_attribute6 );

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 );

Line 2067: arp_util.debug('p_attribute7 = ' || p_attribute7 );

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 );

Line 2068: arp_util.debug('p_attribute8 = ' || p_attribute8 );

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 );

Line 2069: arp_util.debug('p_attribute9 = ' || p_attribute9 );

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 );

Line 2070: arp_util.debug('p_attribute10 = ' || p_attribute10 );

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 );

Line 2071: arp_util.debug('p_attribute11 = ' || p_attribute11 );

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 );

Line 2072: arp_util.debug('p_attribute12 = ' || p_attribute12 );

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 );

Line 2073: arp_util.debug('p_attribute13 = ' || p_attribute13 );

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 );

Line 2074: arp_util.debug('p_attribute14 = ' || p_attribute14 );

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:

Line 2075: arp_util.debug('p_attribute15 = ' || p_attribute15 );

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;

Line 2076: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );

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:

Line 2077: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );

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;

Line 2095: | arp_util.debug |

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 |

Line 2214: arp_util.debug('arp_process_salescredit.update_salescredit_cover()+');

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. |

Line 2272: arp_util.debug('arp_process_salescredit.update_salescredit_cover()-');

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:

Line 2277: arp_util.debug(

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: '---------');

Line 2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||

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 = ' ||

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

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 = ' ||

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

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) );

Line 2284: arp_util.debug('p_run_auto_accounting_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 );

Line 2286: arp_util.debug('p_backout_flag = ' ||

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 );

Line 2288: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_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 );

Line 2289: arp_util.debug('p_customer_trx_line_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 = ' ||

Line 2291: arp_util.debug('p_salesrep_id = ' ||

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 = ' ||

Line 2293: arp_util.debug('p_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 = ' ||

Line 2295: arp_util.debug('p_non_revenue_amount_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 = ' ||

Line 2297: arp_util.debug('p_non_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 = ' ||

Line 2299: arp_util.debug('p_revenue_percent_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 = ' ||
2302: p_prev_cust_trx_line_srep_id );
2303: arp_util.debug('p_attribute_category = ' ||

Line 2301: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||

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 );

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

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 );

Line 2305: arp_util.debug('p_attribute1 = ' || p_attribute1 );

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 );

Line 2306: arp_util.debug('p_attribute2 = ' || p_attribute2 );

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 );

Line 2307: arp_util.debug('p_attribute3 = ' || p_attribute3 );

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 );

Line 2308: arp_util.debug('p_attribute4 = ' || p_attribute4 );

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 );

Line 2309: arp_util.debug('p_attribute5 = ' || p_attribute5 );

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 );

Line 2310: arp_util.debug('p_attribute6 = ' || p_attribute6 );

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 );

Line 2311: arp_util.debug('p_attribute7 = ' || p_attribute7 );

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 );

Line 2312: arp_util.debug('p_attribute8 = ' || p_attribute8 );

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 );

Line 2313: arp_util.debug('p_attribute9 = ' || p_attribute9 );

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 );

Line 2314: arp_util.debug('p_attribute10 = ' || p_attribute10 );

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 );

Line 2315: arp_util.debug('p_attribute11 = ' || p_attribute11 );

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 );

Line 2316: arp_util.debug('p_attribute12 = ' || p_attribute12 );

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 );

Line 2317: arp_util.debug('p_attribute13 = ' || p_attribute13 );

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 );

Line 2318: arp_util.debug('p_attribute14 = ' || p_attribute14 );

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:

Line 2319: arp_util.debug('p_attribute15 = ' || p_attribute15 );

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;

Line 2320: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );

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:

Line 2321: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );

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;

Line 2339: | arp_util.debug |

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 |

Line 2458: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()+');

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. |

Line 2515: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()-');

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:

Line 2520: arp_util.debug(

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: '---------');

Line 2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||

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 = ' ||

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

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 = ' ||

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

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));

Line 2527: arp_util.debug('p_run_auto_accounting_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 );

Line 2529: arp_util.debug('p_backout_flag = ' ||

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 );

Line 2531: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_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 );

Line 2532: arp_util.debug('p_customer_trx_line_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 = ' ||

Line 2534: arp_util.debug('p_salesrep_id = ' ||

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 = ' ||

Line 2536: arp_util.debug('p_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 = ' ||

Line 2538: arp_util.debug('p_non_revenue_amount_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 = ' ||

Line 2540: arp_util.debug('p_non_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 = ' ||

Line 2542: arp_util.debug('p_revenue_percent_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 = ' ||
2545: p_prev_cust_trx_line_srep_id );
2546: arp_util.debug('p_attribute_category = ' ||

Line 2544: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||

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 );

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

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 );

Line 2548: arp_util.debug('p_attribute1 = ' || p_attribute1 );

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 );

Line 2549: arp_util.debug('p_attribute2 = ' || p_attribute2 );

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 );

Line 2550: arp_util.debug('p_attribute3 = ' || p_attribute3 );

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 );

Line 2551: arp_util.debug('p_attribute4 = ' || p_attribute4 );

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 );

Line 2552: arp_util.debug('p_attribute5 = ' || p_attribute5 );

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 );

Line 2553: arp_util.debug('p_attribute6 = ' || p_attribute6 );

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 );

Line 2554: arp_util.debug('p_attribute7 = ' || p_attribute7 );

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 );

Line 2555: arp_util.debug('p_attribute8 = ' || p_attribute8 );

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 );

Line 2556: arp_util.debug('p_attribute9 = ' || p_attribute9 );

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 );

Line 2557: arp_util.debug('p_attribute10 = ' || p_attribute10 );

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 );

Line 2558: arp_util.debug('p_attribute11 = ' || p_attribute11 );

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 );

Line 2559: arp_util.debug('p_attribute12 = ' || p_attribute12 );

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 );

Line 2560: arp_util.debug('p_attribute13 = ' || p_attribute13 );

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 );

Line 2561: arp_util.debug('p_attribute14 = ' || p_attribute14 );

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:

Line 2562: arp_util.debug('p_attribute15 = ' || p_attribute15 );

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;

Line 2563: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );

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:

Line 2564: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );

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;