[Home] [Help]
313: ard.ref_account_class,
314: ard.ref_customer_trx_line_id) amt_tab
315: WHERE ctl.customer_trx_line_id = amt_tab.ref_customer_trx_line_id);
316: BEGIN
317: arp_standard.debug(' get_trx_db_app +');
318: OPEN c_trx_db;
319: FETCH c_trx_db INTO x_line_app ,
320: x_tax_app ,
321: x_frt_app ,
342: x_frt_uned := 0;
343: x_chrg_uned:= 0;
344: END IF;
345: CLOSE c_trx_db;
346: arp_standard.debug(' x_line_app '||x_line_app);
347: arp_standard.debug(' x_tax_app '||x_tax_app);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
343: x_chrg_uned:= 0;
344: END IF;
345: CLOSE c_trx_db;
346: arp_standard.debug(' x_line_app '||x_line_app);
347: arp_standard.debug(' x_tax_app '||x_tax_app);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
344: END IF;
345: CLOSE c_trx_db;
346: arp_standard.debug(' x_line_app '||x_line_app);
347: arp_standard.debug(' x_tax_app '||x_tax_app);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
345: CLOSE c_trx_db;
346: arp_standard.debug(' x_line_app '||x_line_app);
347: arp_standard.debug(' x_tax_app '||x_tax_app);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
346: arp_standard.debug(' x_line_app '||x_line_app);
347: arp_standard.debug(' x_tax_app '||x_tax_app);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
347: arp_standard.debug(' x_tax_app '||x_tax_app);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
348: arp_standard.debug(' x_frt_app '||x_frt_app);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
349: arp_standard.debug(' x_chrg_app '||x_chrg_app);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
357: arp_standard.debug(' x_chrg_uned '||x_chrg_uned);
350: arp_standard.debug(' x_line_ed '||x_line_ed);
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
357: arp_standard.debug(' x_chrg_uned '||x_chrg_uned);
358: arp_standard.debug(' get_trx_db_app -');
351: arp_standard.debug(' x_tax_ed '||x_tax_ed);
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
357: arp_standard.debug(' x_chrg_uned '||x_chrg_uned);
358: arp_standard.debug(' get_trx_db_app -');
359: END;
352: arp_standard.debug(' x_frt_ed '||x_frt_ed);
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
357: arp_standard.debug(' x_chrg_uned '||x_chrg_uned);
358: arp_standard.debug(' get_trx_db_app -');
359: END;
360:
353: arp_standard.debug(' x_chrg_ed '||x_chrg_ed);
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
357: arp_standard.debug(' x_chrg_uned '||x_chrg_uned);
358: arp_standard.debug(' get_trx_db_app -');
359: END;
360:
361: PROCEDURE get_group_db_app
354: arp_standard.debug(' x_line_uned '||x_line_uned);
355: arp_standard.debug(' x_tax_uned '||x_tax_uned);
356: arp_standard.debug(' x_frt_uned '||x_frt_uned);
357: arp_standard.debug(' x_chrg_uned '||x_chrg_uned);
358: arp_standard.debug(' get_trx_db_app -');
359: END;
360:
361: PROCEDURE get_group_db_app
362: (p_source_data_key1 IN VARCHAR2,
418: AND ctl.source_data_key3 = NVL(p_source_data_key3,'00')
419: AND ctl.source_data_key4 = NVL(p_source_data_key4,'00')
420: AND ctl.source_data_key5 = NVL(p_source_data_key5,'00'));
421: BEGIN
422: arp_standard.debug(' get_group_db_app +');
423: arp_standard.debug(' p_source_data_key1 '||p_source_data_key1);
424: arp_standard.debug(' p_source_data_key2 '||p_source_data_key2);
425: arp_standard.debug(' p_source_data_key3 '||p_source_data_key3);
426: arp_standard.debug(' p_source_data_key4 '||p_source_data_key4);
419: AND ctl.source_data_key4 = NVL(p_source_data_key4,'00')
420: AND ctl.source_data_key5 = NVL(p_source_data_key5,'00'));
421: BEGIN
422: arp_standard.debug(' get_group_db_app +');
423: arp_standard.debug(' p_source_data_key1 '||p_source_data_key1);
424: arp_standard.debug(' p_source_data_key2 '||p_source_data_key2);
425: arp_standard.debug(' p_source_data_key3 '||p_source_data_key3);
426: arp_standard.debug(' p_source_data_key4 '||p_source_data_key4);
427: arp_standard.debug(' p_source_data_key5 '||p_source_data_key5);
420: AND ctl.source_data_key5 = NVL(p_source_data_key5,'00'));
421: BEGIN
422: arp_standard.debug(' get_group_db_app +');
423: arp_standard.debug(' p_source_data_key1 '||p_source_data_key1);
424: arp_standard.debug(' p_source_data_key2 '||p_source_data_key2);
425: arp_standard.debug(' p_source_data_key3 '||p_source_data_key3);
426: arp_standard.debug(' p_source_data_key4 '||p_source_data_key4);
427: arp_standard.debug(' p_source_data_key5 '||p_source_data_key5);
428: OPEN c_group_db
421: BEGIN
422: arp_standard.debug(' get_group_db_app +');
423: arp_standard.debug(' p_source_data_key1 '||p_source_data_key1);
424: arp_standard.debug(' p_source_data_key2 '||p_source_data_key2);
425: arp_standard.debug(' p_source_data_key3 '||p_source_data_key3);
426: arp_standard.debug(' p_source_data_key4 '||p_source_data_key4);
427: arp_standard.debug(' p_source_data_key5 '||p_source_data_key5);
428: OPEN c_group_db
429: (p_source_data_key1 => p_source_data_key1,
422: arp_standard.debug(' get_group_db_app +');
423: arp_standard.debug(' p_source_data_key1 '||p_source_data_key1);
424: arp_standard.debug(' p_source_data_key2 '||p_source_data_key2);
425: arp_standard.debug(' p_source_data_key3 '||p_source_data_key3);
426: arp_standard.debug(' p_source_data_key4 '||p_source_data_key4);
427: arp_standard.debug(' p_source_data_key5 '||p_source_data_key5);
428: OPEN c_group_db
429: (p_source_data_key1 => p_source_data_key1,
430: p_source_data_key2 => p_source_data_key2,
423: arp_standard.debug(' p_source_data_key1 '||p_source_data_key1);
424: arp_standard.debug(' p_source_data_key2 '||p_source_data_key2);
425: arp_standard.debug(' p_source_data_key3 '||p_source_data_key3);
426: arp_standard.debug(' p_source_data_key4 '||p_source_data_key4);
427: arp_standard.debug(' p_source_data_key5 '||p_source_data_key5);
428: OPEN c_group_db
429: (p_source_data_key1 => p_source_data_key1,
430: p_source_data_key2 => p_source_data_key2,
431: p_source_data_key3 => p_source_data_key3,
445: x_line_uned := 0;
446: x_tax_uned := 0;
447: END IF;
448: CLOSE c_group_db;
449: arp_standard.debug(' x_line_app '||x_line_app);
450: arp_standard.debug(' x_tax_app '||x_tax_app);
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
446: x_tax_uned := 0;
447: END IF;
448: CLOSE c_group_db;
449: arp_standard.debug(' x_line_app '||x_line_app);
450: arp_standard.debug(' x_tax_app '||x_tax_app);
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
454: arp_standard.debug(' x_tax_uned '||x_tax_uned);
447: END IF;
448: CLOSE c_group_db;
449: arp_standard.debug(' x_line_app '||x_line_app);
450: arp_standard.debug(' x_tax_app '||x_tax_app);
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
454: arp_standard.debug(' x_tax_uned '||x_tax_uned);
455: arp_standard.debug(' get_group_db_app -');
448: CLOSE c_group_db;
449: arp_standard.debug(' x_line_app '||x_line_app);
450: arp_standard.debug(' x_tax_app '||x_tax_app);
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
454: arp_standard.debug(' x_tax_uned '||x_tax_uned);
455: arp_standard.debug(' get_group_db_app -');
456: END;
449: arp_standard.debug(' x_line_app '||x_line_app);
450: arp_standard.debug(' x_tax_app '||x_tax_app);
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
454: arp_standard.debug(' x_tax_uned '||x_tax_uned);
455: arp_standard.debug(' get_group_db_app -');
456: END;
457:
450: arp_standard.debug(' x_tax_app '||x_tax_app);
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
454: arp_standard.debug(' x_tax_uned '||x_tax_uned);
455: arp_standard.debug(' get_group_db_app -');
456: END;
457:
458: PROCEDURE get_log_line_db_app
451: arp_standard.debug(' x_line_ed '||x_line_ed);
452: arp_standard.debug(' x_tax_ed '||x_tax_ed);
453: arp_standard.debug(' x_line_uned '||x_line_uned);
454: arp_standard.debug(' x_tax_uned '||x_tax_uned);
455: arp_standard.debug(' get_group_db_app -');
456: END;
457:
458: PROCEDURE get_log_line_db_app
459: (p_log_line_id IN NUMBER,
509: WHERE ctl.customer_trx_line_id = amt_tab.ref_customer_trx_line_id )
510: GROUP BY log_line_id)) log_line_tab
511: WHERE log_line_tab.log_line_id = p_log_line_id;
512: BEGIN
513: arp_standard.debug(' get_log_line_db_app +');
514: arp_standard.debug(' p_log_line_id '||p_log_line_id);
515: OPEN c_log_line(p_log_line_id => p_log_line_id);
516: FETCH c_log_line INTO x_line_app ,
517: x_tax_app ,
510: GROUP BY log_line_id)) log_line_tab
511: WHERE log_line_tab.log_line_id = p_log_line_id;
512: BEGIN
513: arp_standard.debug(' get_log_line_db_app +');
514: arp_standard.debug(' p_log_line_id '||p_log_line_id);
515: OPEN c_log_line(p_log_line_id => p_log_line_id);
516: FETCH c_log_line INTO x_line_app ,
517: x_tax_app ,
518: x_line_ed ,
527: x_line_uned := 0;
528: x_tax_uned := 0;
529: END IF;
530: CLOSE c_log_line;
531: arp_standard.debug(' x_line_app '||x_line_app);
532: arp_standard.debug(' x_tax_app '||x_tax_app);
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
528: x_tax_uned := 0;
529: END IF;
530: CLOSE c_log_line;
531: arp_standard.debug(' x_line_app '||x_line_app);
532: arp_standard.debug(' x_tax_app '||x_tax_app);
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
536: arp_standard.debug(' x_tax_uned '||x_tax_uned);
529: END IF;
530: CLOSE c_log_line;
531: arp_standard.debug(' x_line_app '||x_line_app);
532: arp_standard.debug(' x_tax_app '||x_tax_app);
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
536: arp_standard.debug(' x_tax_uned '||x_tax_uned);
537: arp_standard.debug(' get_log_line_db_app -');
530: CLOSE c_log_line;
531: arp_standard.debug(' x_line_app '||x_line_app);
532: arp_standard.debug(' x_tax_app '||x_tax_app);
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
536: arp_standard.debug(' x_tax_uned '||x_tax_uned);
537: arp_standard.debug(' get_log_line_db_app -');
538: END;
531: arp_standard.debug(' x_line_app '||x_line_app);
532: arp_standard.debug(' x_tax_app '||x_tax_app);
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
536: arp_standard.debug(' x_tax_uned '||x_tax_uned);
537: arp_standard.debug(' get_log_line_db_app -');
538: END;
539:
532: arp_standard.debug(' x_tax_app '||x_tax_app);
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
536: arp_standard.debug(' x_tax_uned '||x_tax_uned);
537: arp_standard.debug(' get_log_line_db_app -');
538: END;
539:
540:
533: arp_standard.debug(' x_line_ed '||x_line_ed);
534: arp_standard.debug(' x_tax_ed '||x_tax_ed);
535: arp_standard.debug(' x_line_uned '||x_line_uned);
536: arp_standard.debug(' x_tax_uned '||x_tax_uned);
537: arp_standard.debug(' get_log_line_db_app -');
538: END;
539:
540:
541: -- procedures and functions Body
542:
543: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE)
544: IS
545: BEGIN
546: arp_standard.debug('p_ps_rec.amount_applied :'||p_ps_rec.amount_applied);
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
543: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE)
544: IS
545: BEGIN
546: arp_standard.debug('p_ps_rec.amount_applied :'||p_ps_rec.amount_applied);
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
544: IS
545: BEGIN
546: arp_standard.debug('p_ps_rec.amount_applied :'||p_ps_rec.amount_applied);
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
552: arp_standard.debug('p_ps_rec.tax_remaining :'||p_ps_rec.tax_remaining);
545: BEGIN
546: arp_standard.debug('p_ps_rec.amount_applied :'||p_ps_rec.amount_applied);
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
552: arp_standard.debug('p_ps_rec.tax_remaining :'||p_ps_rec.tax_remaining);
553: arp_standard.debug('p_ps_rec.freight_remaining :'||p_ps_rec.freight_remaining);
546: arp_standard.debug('p_ps_rec.amount_applied :'||p_ps_rec.amount_applied);
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
552: arp_standard.debug('p_ps_rec.tax_remaining :'||p_ps_rec.tax_remaining);
553: arp_standard.debug('p_ps_rec.freight_remaining :'||p_ps_rec.freight_remaining);
554: END dump_payschedule;
547: arp_standard.debug('p_ps_rec.discount_taken_earned :'||p_ps_rec.discount_taken_earned);
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
552: arp_standard.debug('p_ps_rec.tax_remaining :'||p_ps_rec.tax_remaining);
553: arp_standard.debug('p_ps_rec.freight_remaining :'||p_ps_rec.freight_remaining);
554: END dump_payschedule;
555:
548: arp_standard.debug('p_ps_rec.discount_taken_unearned :'||p_ps_rec.discount_taken_unearned);
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
552: arp_standard.debug('p_ps_rec.tax_remaining :'||p_ps_rec.tax_remaining);
553: arp_standard.debug('p_ps_rec.freight_remaining :'||p_ps_rec.freight_remaining);
554: END dump_payschedule;
555:
556: PROCEDURE dump_sys_param
549: arp_standard.debug('p_ps_rec.discount_remaining :'||p_ps_rec.discount_remaining);
550: arp_standard.debug('p_ps_rec.amount_line_items_remaining :'||p_ps_rec.amount_line_items_remaining);
551: arp_standard.debug('p_ps_rec.receivables_charges_remaining:'||p_ps_rec.receivables_charges_remaining);
552: arp_standard.debug('p_ps_rec.tax_remaining :'||p_ps_rec.tax_remaining);
553: arp_standard.debug('p_ps_rec.freight_remaining :'||p_ps_rec.freight_remaining);
554: END dump_payschedule;
555:
556: PROCEDURE dump_sys_param
557: IS
555:
556: PROCEDURE dump_sys_param
557: IS
558: BEGIN
559: arp_standard.debug('g_ae_sys_rec.set_of_books_id :'||g_ae_sys_rec.set_of_books_id);
560: arp_standard.debug('g_ae_sys_rec.coa_id :'||g_ae_sys_rec.coa_id);
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
556: PROCEDURE dump_sys_param
557: IS
558: BEGIN
559: arp_standard.debug('g_ae_sys_rec.set_of_books_id :'||g_ae_sys_rec.set_of_books_id);
560: arp_standard.debug('g_ae_sys_rec.coa_id :'||g_ae_sys_rec.coa_id);
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
557: IS
558: BEGIN
559: arp_standard.debug('g_ae_sys_rec.set_of_books_id :'||g_ae_sys_rec.set_of_books_id);
560: arp_standard.debug('g_ae_sys_rec.coa_id :'||g_ae_sys_rec.coa_id);
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
558: BEGIN
559: arp_standard.debug('g_ae_sys_rec.set_of_books_id :'||g_ae_sys_rec.set_of_books_id);
560: arp_standard.debug('g_ae_sys_rec.coa_id :'||g_ae_sys_rec.coa_id);
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
566: arp_standard.debug('g_ae_sys_rec.round_cc_id :'||g_ae_sys_rec.round_cc_id);
559: arp_standard.debug('g_ae_sys_rec.set_of_books_id :'||g_ae_sys_rec.set_of_books_id);
560: arp_standard.debug('g_ae_sys_rec.coa_id :'||g_ae_sys_rec.coa_id);
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
566: arp_standard.debug('g_ae_sys_rec.round_cc_id :'||g_ae_sys_rec.round_cc_id);
567: arp_standard.debug('g_ae_sys_rec.SOB_TYPE :'||g_ae_sys_rec.SOB_TYPE);
560: arp_standard.debug('g_ae_sys_rec.coa_id :'||g_ae_sys_rec.coa_id);
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
566: arp_standard.debug('g_ae_sys_rec.round_cc_id :'||g_ae_sys_rec.round_cc_id);
567: arp_standard.debug('g_ae_sys_rec.SOB_TYPE :'||g_ae_sys_rec.SOB_TYPE);
568: END dump_sys_param;
561: arp_standard.debug('g_ae_sys_rec.base_currency :'||g_ae_sys_rec.base_currency);
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
566: arp_standard.debug('g_ae_sys_rec.round_cc_id :'||g_ae_sys_rec.round_cc_id);
567: arp_standard.debug('g_ae_sys_rec.SOB_TYPE :'||g_ae_sys_rec.SOB_TYPE);
568: END dump_sys_param;
569:
562: arp_standard.debug('g_ae_sys_rec.base_precision :'||g_ae_sys_rec.base_precision);
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
566: arp_standard.debug('g_ae_sys_rec.round_cc_id :'||g_ae_sys_rec.round_cc_id);
567: arp_standard.debug('g_ae_sys_rec.SOB_TYPE :'||g_ae_sys_rec.SOB_TYPE);
568: END dump_sys_param;
569:
570: /*-----------------------------------------------------------------------------+
563: arp_standard.debug('g_ae_sys_rec.base_min_acc_unit:'||g_ae_sys_rec.base_min_acc_unit);
564: arp_standard.debug('g_ae_sys_rec.gain_cc_id :'||g_ae_sys_rec.gain_cc_id);
565: arp_standard.debug('g_ae_sys_rec.loss_cc_id :'||g_ae_sys_rec.loss_cc_id);
566: arp_standard.debug('g_ae_sys_rec.round_cc_id :'||g_ae_sys_rec.round_cc_id);
567: arp_standard.debug('g_ae_sys_rec.SOB_TYPE :'||g_ae_sys_rec.SOB_TYPE);
568: END dump_sys_param;
569:
570: /*-----------------------------------------------------------------------------+
571: | Procedure get_inv_ps |
587: no_installed_inv_allowed EXCEPTION;
588: no_op_trx_pay_schedule EXCEPTION;
589: no_customer_trx_cache EXCEPTION;
590: BEGIN
591: arp_standard.debug('get_inv_ps +');
592: arp_standard.debug(' g_customer_trx.customer_trx_id :'||g_customer_trx.customer_trx_id);
593: IF g_customer_trx.customer_trx_id IS NULL THEN
594: RAISE no_customer_trx_cache;
595: END IF;
588: no_op_trx_pay_schedule EXCEPTION;
589: no_customer_trx_cache EXCEPTION;
590: BEGIN
591: arp_standard.debug('get_inv_ps +');
592: arp_standard.debug(' g_customer_trx.customer_trx_id :'||g_customer_trx.customer_trx_id);
593: IF g_customer_trx.customer_trx_id IS NULL THEN
594: RAISE no_customer_trx_cache;
595: END IF;
596: OPEN c_ps;
609: ELSE
610: g_payschedule_trx := l_inv_ps;
611: END IF;
612: -- dump_payschedule(g_payschedule_trx);
613: arp_standard.debug('get_inv_ps -');
614: EXCEPTION
615: WHEN no_customer_trx_cache THEN
616: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
617: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_customer_trx_cache
617: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_customer_trx_cache
618: Please verify if initialization has been successfully' );
619: FND_MSG_PUB.ADD;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: arp_standard.debug
622: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
623: WHEN no_installed_inv_allowed THEN
624: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
625: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_installed_inv_allowed customer_trx_id:'
625: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_installed_inv_allowed customer_trx_id:'
626: ||g_customer_trx.customer_trx_id);
627: FND_MSG_PUB.ADD;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: arp_standard.debug
630: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
631: WHEN no_op_trx_pay_schedule THEN
632: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
633: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_open_trx_pay_schedule customer_trx_id:'
633: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_open_trx_pay_schedule customer_trx_id:'
634: ||g_customer_trx.customer_trx_id);
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: arp_standard.debug
638: ('EXCEPTION get_inv_ps no_op_trx_pay_schedule customer_trx_id '||g_customer_trx.customer_trx_id);
639: WHEN OTHERS THEN
640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
641: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-'||SQLERRM);
640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
641: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-'||SQLERRM);
642: FND_MSG_PUB.ADD;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: arp_standard.debug('EXCEPTION get_inv_ps OTHERS '||SQLERRM);
645: END get_inv_ps;
646:
647:
648: /*-----------------------------------------------------------------------------+
664: l_cpt NUMBER := 0;
665: l_rec_ps ar_payment_schedules%ROWTYPE;
666: no_op_rec_pay_schedule EXCEPTION;
667: BEGIN
668: arp_standard.debug('get_rec_ps +');
669: arp_standard.debug(' p_cr_id :'||p_cr_id);
670: OPEN c_ps;
671: FETCH c_ps INTO l_rec_ps;
672: IF c_ps%NOTFOUND THEN
665: l_rec_ps ar_payment_schedules%ROWTYPE;
666: no_op_rec_pay_schedule EXCEPTION;
667: BEGIN
668: arp_standard.debug('get_rec_ps +');
669: arp_standard.debug(' p_cr_id :'||p_cr_id);
670: OPEN c_ps;
671: FETCH c_ps INTO l_rec_ps;
672: IF c_ps%NOTFOUND THEN
673: RAISE no_op_rec_pay_schedule;
674: ELSE
675: g_payschedule_rec := l_rec_ps;
676: END IF;
677: CLOSE c_ps;
678: arp_standard.debug('get_rec_ps -');
679: EXCEPTION
680: WHEN no_op_rec_pay_schedule THEN
681: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
682: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps no_open_rec_pay_schedule' );
681: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
682: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps no_open_rec_pay_schedule' );
683: FND_MSG_PUB.ADD;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: arp_standard.debug
686: ('EXCEPTION get_rec_ps no_op_rec_pay_schedule p_cr_id '||p_cr_id);
687: WHEN OTHERS THEN
688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
689: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps:'||SQLERRM );
688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
689: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps:'||SQLERRM );
690: FND_MSG_PUB.ADD;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: arp_standard.debug
693: ('EXCEPTION get_rec_ps OTHERS '||SQLERRM);
694: END get_rec_ps;
695:
696:
817: l_charges_applied := NVL(p_charges_applied ,0);
818: --
819: -- Non negative amount allowed
820: --
821: arp_standard.debug(' is_bucket_concern(+)' );
822: arp_standard.debug(' amount_line_items_original : '||p_bc_ps_rec.amount_line_items_original);
823: arp_standard.debug(' tax_original : '||p_bc_ps_rec.tax_original);
824: arp_standard.debug(' freight_applied : '||p_bc_ps_rec.freight_original);
825: arp_standard.debug(' charges_applied : '||p_bc_ps_rec.RECEIVABLES_CHARGES_CHARGED);
818: --
819: -- Non negative amount allowed
820: --
821: arp_standard.debug(' is_bucket_concern(+)' );
822: arp_standard.debug(' amount_line_items_original : '||p_bc_ps_rec.amount_line_items_original);
823: arp_standard.debug(' tax_original : '||p_bc_ps_rec.tax_original);
824: arp_standard.debug(' freight_applied : '||p_bc_ps_rec.freight_original);
825: arp_standard.debug(' charges_applied : '||p_bc_ps_rec.RECEIVABLES_CHARGES_CHARGED);
826:
819: -- Non negative amount allowed
820: --
821: arp_standard.debug(' is_bucket_concern(+)' );
822: arp_standard.debug(' amount_line_items_original : '||p_bc_ps_rec.amount_line_items_original);
823: arp_standard.debug(' tax_original : '||p_bc_ps_rec.tax_original);
824: arp_standard.debug(' freight_applied : '||p_bc_ps_rec.freight_original);
825: arp_standard.debug(' charges_applied : '||p_bc_ps_rec.RECEIVABLES_CHARGES_CHARGED);
826:
827: If p_ctl_id IS NOT NULL
820: --
821: arp_standard.debug(' is_bucket_concern(+)' );
822: arp_standard.debug(' amount_line_items_original : '||p_bc_ps_rec.amount_line_items_original);
823: arp_standard.debug(' tax_original : '||p_bc_ps_rec.tax_original);
824: arp_standard.debug(' freight_applied : '||p_bc_ps_rec.freight_original);
825: arp_standard.debug(' charges_applied : '||p_bc_ps_rec.RECEIVABLES_CHARGES_CHARGED);
826:
827: If p_ctl_id IS NOT NULL
828: Then
821: arp_standard.debug(' is_bucket_concern(+)' );
822: arp_standard.debug(' amount_line_items_original : '||p_bc_ps_rec.amount_line_items_original);
823: arp_standard.debug(' tax_original : '||p_bc_ps_rec.tax_original);
824: arp_standard.debug(' freight_applied : '||p_bc_ps_rec.freight_original);
825: arp_standard.debug(' charges_applied : '||p_bc_ps_rec.RECEIVABLES_CHARGES_CHARGED);
826:
827: If p_ctl_id IS NOT NULL
828: Then
829: /* Due to rounding issues with the proration some of the lines may end up with
882: RETURN 'Y';
883: END IF;
884: END is_bucket_concern;
885: BEGIN
886: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
887: arp_standard.debug(' p_line_applied :'||p_line_applied);
888: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
883: END IF;
884: END is_bucket_concern;
885: BEGIN
886: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
887: arp_standard.debug(' p_line_applied :'||p_line_applied);
888: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
884: END is_bucket_concern;
885: BEGIN
886: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
887: arp_standard.debug(' p_line_applied :'||p_line_applied);
888: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
885: BEGIN
886: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
887: arp_standard.debug(' p_line_applied :'||p_line_applied);
888: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
886: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
887: arp_standard.debug(' p_line_applied :'||p_line_applied);
888: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
888: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
889: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
890: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
891: --
892: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
899: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
893: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
899: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
900: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
901: --
894: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
899: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
900: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
901: --
902: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
895: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
899: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
900: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
901: --
902: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
903: l_ps_rec := g_payschedule_trx;
896: --
897: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
899: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
900: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
901: --
902: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
903: l_ps_rec := g_payschedule_trx;
904: l_applied_concern := is_bucket_concern(p_line_applied => p_line_applied,
898: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
899: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
900: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
901: --
902: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
903: l_ps_rec := g_payschedule_trx;
904: l_applied_concern := is_bucket_concern(p_line_applied => p_line_applied,
905: p_tax_applied => p_tax_applied,
906: p_freight_applied => p_freight_applied,
1052: l_apps_rec.STATUS := 'APP';
1053: insert_rapps_p(p_app_rec => l_apps_rec,
1054: x_return_status => x_return_status);
1055: x_app_rec := l_apps_rec;
1056: arp_standard.debug( 'arp_process_det_pkg.upd_inv_ps-' );
1057: EXCEPTION
1058: WHEN neg_app_amt THEN
1059: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1060: IF l_earned_concern = 'PBLINENEG' THEN
1107: PROCEDURE disp_app_rec
1108: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1109: IS
1110: BEGIN
1111: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1112: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1108: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1109: IS
1110: BEGIN
1111: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1112: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1109: IS
1110: BEGIN
1111: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1112: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1110: BEGIN
1111: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1112: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1111: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1112: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1112: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1113: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1114: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1115: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1116: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1117: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1118: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1119: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1120: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1121: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1122: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1123: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1124: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1125: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1126: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1127: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1128: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1129: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1130: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1131: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1132: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1133: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1134: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1135: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1136: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1137: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1138: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1139: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1140: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1148: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1141: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1148: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1149: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1142: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1148: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1149: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1150: END disp_app_rec;
1143: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1148: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1149: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1150: END disp_app_rec;
1151:
1144: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1148: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1149: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1150: END disp_app_rec;
1151:
1152:
1145: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1146: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1148: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1149: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1150: END disp_app_rec;
1151:
1152:
1153: /*-----------------------------------------------------------------------------+
1162: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1163: x_return_status IN OUT NOCOPY VARCHAR2)
1164: IS
1165: BEGIN
1166: arp_standard.debug('insert_rapps_p +');
1167: disp_app_rec(p_app_rec);
1168: INSERT INTO ar_receivable_apps_gt
1169: (GT_ID
1170: ,app_level
1251: ,p_app_rec.LINE_UEDISCOUNTED
1252: ,p_app_rec.TAX_UEDISCOUNTED
1253: ,p_app_rec.FREIGHT_UEDISCOUNTED
1254: ,p_app_rec.CHARGES_UEDISCOUNTED);
1255: arp_standard.debug('insert_rapps_p -');
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1259: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1254: ,p_app_rec.CHARGES_UEDISCOUNTED);
1255: arp_standard.debug('insert_rapps_p -');
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1259: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1260: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS insert_rapps_p:'||SQLERRM );
1261: FND_MSG_PUB.ADD;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1354: l_last_fetch BOOLEAN := FALSE;
1355: BEGIN
1356: arp_standard.debug('res_ctl_rem_amt_for_app +');
1357: disp_app_rec(p_app_rec);
1358: OPEN c_app(p_app_rec);
1359: LOOP
1360: FETCH c_app BULK COLLECT INTO l_rev_amt_rem_tab,
1375: l_last_fetch := TRUE;
1376: END IF;
1377:
1378: IF (l_ctl_id_tab.COUNT = 0) AND (l_last_fetch) THEN
1379: arp_standard.debug('COUNT = 0 and LAST FETCH ');
1380: EXIT;
1381: END IF;
1382:
1383: FORALL i IN l_ctl_id_tab.FIRST .. l_ctl_id_tab.LAST
1404: CHRG_ACCTD_AMOUNT_REMAINING + l_chrg_adj_acctd_amt_rem_tab(i)
1405: WHERE customer_trx_line_id = l_ctl_id_tab(i);
1406: END LOOP;
1407: CLOSE c_app;
1408: arp_standard.debug('res_ctl_rem_amt_for_app -');
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1412: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1407: CLOSE c_app;
1408: arp_standard.debug('res_ctl_rem_amt_for_app -');
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1412: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1413: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_ctl_rem_amt_for_app:'||SQLERRM );
1414: FND_MSG_PUB.ADD;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: l_charges_discounted NUMBER;
1435: l_discount_taken_total NUMBER;
1436: l_freight_discounted NUMBER;
1437: BEGIN
1438: arp_standard.debug('res_inv_ps +');
1439: disp_app_rec(p_app_rec);
1440: l_ps_rec := g_payschedule_trx;
1441:
1442: l_ps_rec.amount_applied := NVL(l_ps_rec.amount_applied,0)
1471: l_ps_rec.freight_remaining := NVL( l_ps_rec.freight_remaining, 0 ) +
1472: ( NVL( p_app_rec.FREIGHT_APPLIED, 0 ) +
1473: NVL( l_freight_discounted, 0 ) );
1474: g_payschedule_trx := l_ps_rec;
1475: arp_standard.debug('res_inv_ps -');
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1479: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1474: g_payschedule_trx := l_ps_rec;
1475: arp_standard.debug('res_inv_ps -');
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1479: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1480: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_inv_ps:'||SQLERRM );
1481: FND_MSG_PUB.ADD;
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1500: x_return_status IN OUT NOCOPY VARCHAR2)
1501: IS
1502: BEGIN
1503: arp_standard.debug('delete_application +');
1504: -- 1 restore ps inv
1505: res_inv_ps(p_app_rec => p_app_rec,
1506: x_return_status => x_return_status);
1507:
1518: DELETE FROM AR_LINE_APP_DETAIL_GT
1519: WHERE gt_id = p_app_rec.gt_id
1520: AND app_level = p_app_rec.app_level;
1521:
1522: arp_standard.debug('delete_application -');
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1526: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1521:
1522: arp_standard.debug('delete_application -');
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1526: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1527: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS delete_application:'||SQLERRM );
1528: FND_MSG_PUB.ADD;
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
1536: x_return_status IN OUT NOCOPY VARCHAR2)
1537: IS
1538: BEGIN
1539: arp_standard.debug('copy_app_rec +');
1540: disp_app_rec(p_app_rec);
1541: x_ra_rec.RECEIVABLE_APPLICATION_ID := p_app_rec.RECEIVABLE_APPLICATION_ID;
1542: x_ra_rec.AMOUNT_APPLIED := p_app_rec.AMOUNT_APPLIED;
1543: x_ra_rec.CODE_COMBINATION_ID := p_app_rec.CODE_COMBINATION_ID;
1574: x_ra_rec.FREIGHT_UEDISCOUNTED := p_app_rec.FREIGHT_UEDISCOUNTED;
1575: x_ra_rec.CHARGES_UEDISCOUNTED := p_app_rec.CHARGES_UEDISCOUNTED;
1576: x_ra_rec.STATUS := p_app_rec.STATUS;
1577:
1578: arp_standard.debug(' x_ra_rec.LINE_APPLIED:'||x_ra_rec.LINE_APPLIED);
1579: arp_standard.debug(' x_ra_rec.TAX_APPLIED:'||x_ra_rec.TAX_APPLIED);
1580:
1581: arp_standard.debug('copy_app_rec -');
1582: EXCEPTION
1575: x_ra_rec.CHARGES_UEDISCOUNTED := p_app_rec.CHARGES_UEDISCOUNTED;
1576: x_ra_rec.STATUS := p_app_rec.STATUS;
1577:
1578: arp_standard.debug(' x_ra_rec.LINE_APPLIED:'||x_ra_rec.LINE_APPLIED);
1579: arp_standard.debug(' x_ra_rec.TAX_APPLIED:'||x_ra_rec.TAX_APPLIED);
1580:
1581: arp_standard.debug('copy_app_rec -');
1582: EXCEPTION
1583: WHEN OTHERS THEN
1577:
1578: arp_standard.debug(' x_ra_rec.LINE_APPLIED:'||x_ra_rec.LINE_APPLIED);
1579: arp_standard.debug(' x_ra_rec.TAX_APPLIED:'||x_ra_rec.TAX_APPLIED);
1580:
1581: arp_standard.debug('copy_app_rec -');
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1585: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1580:
1581: arp_standard.debug('copy_app_rec -');
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1585: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1586: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS copy_app_rec:'||SQLERRM );
1587: FND_MSG_PUB.ADD;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1606: x_return_status IN OUT NOCOPY VARCHAR2)
1607: IS
1608: l_ra_rec ar_receivable_applications%ROWTYPE;
1609: BEGIN
1610: arp_standard.debug('do_apply +');
1611: copy_app_rec(p_app_rec => p_app_rec,
1612: x_ra_rec => l_ra_rec,
1613: x_return_status => x_return_status);
1614:
1638: p_gt_id => p_gt_id);
1639:
1640: ELSIF p_app_rec.app_level = 'LINE' THEN
1641:
1642: arp_standard.debug(' HYU l_ra_rec.LINE_APPLIED:'||l_ra_rec.LINE_APPLIED);
1643: arp_standard.debug(' HYU l_ra_rec.TAX_APPLIED:'||l_ra_rec.TAX_APPLIED);
1644:
1645: ARP_DET_DIST_PKG.Trx_line_level_cash_apply
1646: (p_customer_trx => g_customer_trx,
1639:
1640: ELSIF p_app_rec.app_level = 'LINE' THEN
1641:
1642: arp_standard.debug(' HYU l_ra_rec.LINE_APPLIED:'||l_ra_rec.LINE_APPLIED);
1643: arp_standard.debug(' HYU l_ra_rec.TAX_APPLIED:'||l_ra_rec.TAX_APPLIED);
1644:
1645: ARP_DET_DIST_PKG.Trx_line_level_cash_apply
1646: (p_customer_trx => g_customer_trx,
1647: p_customer_trx_line_id => p_app_rec.ctl_id,
1650: p_ae_sys_rec => g_ae_sys_rec,
1651: p_gt_id => p_gt_id);
1652:
1653: END IF;
1654: arp_standard.debug('do_apply -');
1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1658: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1653: END IF;
1654: arp_standard.debug('do_apply -');
1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1658: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1659: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS do_apply:'||SQLERRM );
1660: FND_MSG_PUB.ADD;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: x_return_status IN OUT NOCOPY VARCHAR2)
1721: IS
1722: l_app_rec ar_receivable_apps_gt%ROWTYPE;
1723: BEGIN
1724: arp_standard.debug('apply +');
1725:
1726: arp_standard.debug(' Calling upd_inv_ps +');
1727:
1728: upd_inv_ps(
1722: l_app_rec ar_receivable_apps_gt%ROWTYPE;
1723: BEGIN
1724: arp_standard.debug('apply +');
1725:
1726: arp_standard.debug(' Calling upd_inv_ps +');
1727:
1728: upd_inv_ps(
1729: p_app_level => p_app_level,
1730: --
1754: --
1755: x_app_rec => l_app_rec,
1756: x_return_status => x_return_status);
1757:
1758: arp_standard.debug(' x_return_status :'|| x_return_status);
1759:
1760: arp_standard.debug(' Calling upd_inv_ps -');
1761:
1762: do_apply
1756: x_return_status => x_return_status);
1757:
1758: arp_standard.debug(' x_return_status :'|| x_return_status);
1759:
1760: arp_standard.debug(' Calling upd_inv_ps -');
1761:
1762: do_apply
1763: (p_app_rec => l_app_rec,
1764: p_gt_id => l_app_rec.gt_id,
1762: do_apply
1763: (p_app_rec => l_app_rec,
1764: p_gt_id => l_app_rec.gt_id,
1765: x_return_status=> x_return_status);
1766: arp_standard.debug('apply -');
1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1770: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1765: x_return_status=> x_return_status);
1766: arp_standard.debug('apply -');
1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1770: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1771: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS apply:'||SQLERRM );
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775:
1776: PROCEDURE dump_ccid
1777: IS
1778: BEGIN
1779: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1780: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1776: PROCEDURE dump_ccid
1777: IS
1778: BEGIN
1779: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1780: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1777: IS
1778: BEGIN
1779: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1780: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1778: BEGIN
1779: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1780: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1779: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1780: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1787: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1780: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1787: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1788: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1781: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1787: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1788: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1789: END dump_ccid;
1782: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1787: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1788: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1789: END dump_ccid;
1790:
1783: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1787: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1788: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1789: END dump_ccid;
1790:
1791: /*-----------------------------------------------------------------------------+
1784: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1785: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1786: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1787: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1788: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1789: END dump_ccid;
1790:
1791: /*-----------------------------------------------------------------------------+
1792: | Procedure initialization |
1884: no_sys_param EXCEPTION;
1885: not_valid_cr EXCEPTION;
1886: rev_rec_error EXCEPTION;
1887: BEGIN
1888: arp_standard.debug('initialization +');
1889: SAVEPOINT initialization;
1890: x_return_status := fnd_api.g_ret_sts_success;
1891: OPEN c;
1892: FETCH c INTO g_customer_trx;
1933: ,g_inv_rec_ccid;
1934: CLOSE c_acct;
1935: dump_ccid;
1936:
1937: arp_standard.debug(' Check whether Rev Recognition is to be Run');
1938: OPEN c1;
1939: FETCH c1 INTO l_dummy;
1940: IF c1%NOTFOUND THEN
1941: arp_standard.debug(' No need to run rev rec for trx_id :' || p_customer_trx_id);
1937: arp_standard.debug(' Check whether Rev Recognition is to be Run');
1938: OPEN c1;
1939: FETCH c1 INTO l_dummy;
1940: IF c1%NOTFOUND THEN
1941: arp_standard.debug(' No need to run rev rec for trx_id :' || p_customer_trx_id);
1942: l_rev_rec_req := FALSE;
1943: ELSE
1944: arp_standard.debug(' Need to run rev rec for trx_id :' || p_customer_trx_id);
1945: l_rev_rec_req := TRUE;
1940: IF c1%NOTFOUND THEN
1941: arp_standard.debug(' No need to run rev rec for trx_id :' || p_customer_trx_id);
1942: l_rev_rec_req := FALSE;
1943: ELSE
1944: arp_standard.debug(' Need to run rev rec for trx_id :' || p_customer_trx_id);
1945: l_rev_rec_req := TRUE;
1946: END IF;
1947: CLOSE c1;
1948:
1946: END IF;
1947: CLOSE c1;
1948:
1949: IF l_rev_rec_req THEN
1950: arp_standard.debug(' Executing Rev Rec - calling ARP_AUTO_RULE.create_distributions');
1951: l_sum_dist := ARP_AUTO_RULE.create_distributions
1952: ( p_commit => 'N',
1953: p_debug => 'N',
1954: p_trx_id => p_customer_trx_id);
1955:
1956: IF l_sum_dist < 0 THEN
1957: RAISE rev_rec_error;
1958: END IF;
1959: arp_standard.debug(' Completed running revenue recognition for Transaction');
1960: END IF;
1961:
1962:
1963: ARP_DET_DIST_PKG.set_original_rem_amt
1979: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1980: RAISE FND_API.G_EXC_ERROR;
1981: END IF;
1982:
1983: arp_standard.debug('initialization -');
1984: EXCEPTION
1985: WHEN no_sys_param THEN
1986: ROLLBACK TO initialization;
1987: arp_standard.debug('EXCEPTION initialization no_sys_param');
1983: arp_standard.debug('initialization -');
1984: EXCEPTION
1985: WHEN no_sys_param THEN
1986: ROLLBACK TO initialization;
1987: arp_standard.debug('EXCEPTION initialization no_sys_param');
1988: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' );
1989: FND_MSG_PUB.ADD;
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1992: p_count => x_msg_count,
1993: p_data => x_msg_data);
1994: WHEN not_valid_trx THEN
1995: ROLLBACK TO initialization;
1996: arp_standard.debug('EXCEPTION initialization not_valid_trx');
1997: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1998: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||
1999: p_customer_trx_id );
2000: FND_MSG_PUB.ADD;
2003: p_count => x_msg_count,
2004: p_data => x_msg_data);
2005: WHEN not_valid_cr THEN
2006: ROLLBACK TO initialization;
2007: arp_standard.debug('EXCEPTION initialization not_valid_cr');
2008: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2009: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||
2010: p_cash_receipt_id );
2011: FND_MSG_PUB.ADD;
2023: ROLLBACK TO initialization;
2024: OPEN c_trx_number(p_customer_trx_id);
2025: FETCH c_trx_number INTO l_trx_number;
2026: CLOSE c_trx_number;
2027: arp_standard.debug('Error in Rev Rec - ARP_AUTO_RULE.create_distributions for trx_id :'||p_customer_trx_id);
2028: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTORULE_ERROR' );
2029: FND_MESSAGE.SET_TOKEN( 'TRX_NUMBER', l_trx_number );
2030: FND_MSG_PUB.ADD;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2034: p_data => x_msg_data);
2035:
2036: WHEN OTHERS THEN
2037: ROLLBACK TO initialization;
2038: arp_standard.debug('EXCEPTION initialization OTHERS:'||SQLERRM);
2039: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2040: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );
2041: FND_MSG_PUB.ADD;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: WHERE app_level = 'LINE'
2097: AND ctl_id = p_ctl_id;
2098: l_res VARCHAR2(30);
2099: BEGIN
2100: arp_standard.debug('cur_app_gt_id +');
2101: arp_standard.debug(' p_app_level :'||p_app_level);
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2097: AND ctl_id = p_ctl_id;
2098: l_res VARCHAR2(30);
2099: BEGIN
2100: arp_standard.debug('cur_app_gt_id +');
2101: arp_standard.debug(' p_app_level :'||p_app_level);
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2098: l_res VARCHAR2(30);
2099: BEGIN
2100: arp_standard.debug('cur_app_gt_id +');
2101: arp_standard.debug(' p_app_level :'||p_app_level);
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2106: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2099: BEGIN
2100: arp_standard.debug('cur_app_gt_id +');
2101: arp_standard.debug(' p_app_level :'||p_app_level);
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2106: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2107: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2100: arp_standard.debug('cur_app_gt_id +');
2101: arp_standard.debug(' p_app_level :'||p_app_level);
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2106: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2107: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2108: IF p_app_level = 'TRANSACTION' THEN
2101: arp_standard.debug(' p_app_level :'||p_app_level);
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2106: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2107: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2108: IF p_app_level = 'TRANSACTION' THEN
2109: OPEN c_trx;
2102: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2106: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2107: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2108: IF p_app_level = 'TRANSACTION' THEN
2109: OPEN c_trx;
2110: FETCH c_trx INTO x_app_rec;
2103: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2104: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2105: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2106: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2107: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2108: IF p_app_level = 'TRANSACTION' THEN
2109: OPEN c_trx;
2110: FETCH c_trx INTO x_app_rec;
2111: IF c_trx%NOTFOUND THEN
2134: CLOSE c_ctl;
2135: ELSE
2136: l_res := 'X';
2137: END IF;
2138: arp_standard.debug(' l_res :'||l_res);
2139: arp_standard.debug('cur_app_gt_id -');
2140: RETURN l_res;
2141: EXCEPTION
2142: WHEN OTHERS THEN
2135: ELSE
2136: l_res := 'X';
2137: END IF;
2138: arp_standard.debug(' l_res :'||l_res);
2139: arp_standard.debug('cur_app_gt_id -');
2140: RETURN l_res;
2141: EXCEPTION
2142: WHEN OTHERS THEN
2143: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2139: arp_standard.debug('cur_app_gt_id -');
2140: RETURN l_res;
2141: EXCEPTION
2142: WHEN OTHERS THEN
2143: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2144: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2145: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS cur_app_gt_id:'||SQLERRM );
2146: FND_MSG_PUB.ADD;
2147: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2209: cur_gt_id VARCHAR2(30);
2210: l_app_rec ar_receivable_apps_gt%ROWTYPE;
2211: unexpected_error EXCEPTION;
2212: BEGIN
2213: arp_standard.debug('application_execute +');
2214: SAVEPOINT first_delete_then_apply;
2215:
2216: x_return_status := fnd_api.g_ret_sts_success;
2217:
2267: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2268: RAISE FND_API.G_EXC_ERROR;
2269: END IF;
2270:
2271: arp_standard.debug('application_execute -');
2272: EXCEPTION
2273: WHEN FND_API.G_EXC_ERROR THEN
2274: ROLLBACK TO first_delete_then_apply;
2275: x_return_status := FND_API.G_RET_STS_ERROR;
2277: p_count => x_msg_count,
2278: p_data => x_msg_data);
2279: WHEN unexpected_error THEN
2280: ROLLBACK TO first_delete_then_apply;
2281: arp_standard.debug('EXCEPTION first_delete_then_apply unexpected_error - p_app_level:'
2282: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2283: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2284: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'
2285: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2289: p_count => x_msg_count,
2290: p_data => x_msg_data);
2291: WHEN OTHERS THEN
2292: ROLLBACK TO first_delete_then_apply;
2293: arp_standard.debug('EXCEPTION first_delete_then_apply OTHERS:'||SQLERRM);
2294: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2295: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );
2296: FND_MSG_PUB.ADD;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2454: l_app_from NUMBER;
2455: l_tx_rate NUMBER;
2456:
2457: BEGIN
2458: arp_standard.debug('final_commit +');
2459: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2460:
2461: savepoint final_commit;
2462:
2455: l_tx_rate NUMBER;
2456:
2457: BEGIN
2458: arp_standard.debug('final_commit +');
2459: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2460:
2461: savepoint final_commit;
2462:
2463: x_return_status := fnd_api.g_ret_sts_success;
2523: END IF;
2524:
2525: END IF;
2526:
2527: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2528: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2529: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2530: arp_standard.debug(' l_app_from :'||l_app_from);
2531:
2524:
2525: END IF;
2526:
2527: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2528: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2529: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2530: arp_standard.debug(' l_app_from :'||l_app_from);
2531:
2532:
2525: END IF;
2526:
2527: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2528: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2529: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2530: arp_standard.debug(' l_app_from :'||l_app_from);
2531:
2532:
2533: IF NVL(p_trans_to_receipt_rate,0) <> 0 THEN
2526:
2527: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2528: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2529: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2530: arp_standard.debug(' l_app_from :'||l_app_from);
2531:
2532:
2533: IF NVL(p_trans_to_receipt_rate,0) <> 0 THEN
2534: l_tx_rate := p_trans_to_receipt_rate;
2653:
2654:
2655: END IF;
2656:
2657: arp_standard.debug('final_commit -');
2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: ROLLBACK TO final_commit;
2661: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2657: arp_standard.debug('final_commit -');
2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: ROLLBACK TO final_commit;
2661: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2662: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2663: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.final_commit-'||SQLERRM );
2664: FND_MSG_PUB.ADD;
2665: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2735: AND source_data_key3 = NVL(p_source_data_key3,'00')
2736: AND source_data_key4 = NVL(p_source_data_key4,'00')
2737: AND source_data_key5 = NVL(p_source_data_key5,'00');
2738: BEGIN
2739: arp_standard.debug('get_latest_amount_remaining +');
2740: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2741: arp_standard.debug(' p_app_level :'||p_app_level);
2742: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2743: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2736: AND source_data_key4 = NVL(p_source_data_key4,'00')
2737: AND source_data_key5 = NVL(p_source_data_key5,'00');
2738: BEGIN
2739: arp_standard.debug('get_latest_amount_remaining +');
2740: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2741: arp_standard.debug(' p_app_level :'||p_app_level);
2742: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2743: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2744: IF p_app_level = 'TRANSACTION' THEN
2737: AND source_data_key5 = NVL(p_source_data_key5,'00');
2738: BEGIN
2739: arp_standard.debug('get_latest_amount_remaining +');
2740: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2741: arp_standard.debug(' p_app_level :'||p_app_level);
2742: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2743: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2744: IF p_app_level = 'TRANSACTION' THEN
2745: OPEN c_trx;
2738: BEGIN
2739: arp_standard.debug('get_latest_amount_remaining +');
2740: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2741: arp_standard.debug(' p_app_level :'||p_app_level);
2742: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2743: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2744: IF p_app_level = 'TRANSACTION' THEN
2745: OPEN c_trx;
2746: FETCH c_trx INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2739: arp_standard.debug('get_latest_amount_remaining +');
2740: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2741: arp_standard.debug(' p_app_level :'||p_app_level);
2742: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2743: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2744: IF p_app_level = 'TRANSACTION' THEN
2745: OPEN c_trx;
2746: FETCH c_trx INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2747: CLOSE c_trx;
2753: OPEN c_line;
2754: FETCH c_line INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2755: CLOSE c_line;
2756: END IF;
2757: arp_standard.debug(' x_line_rem :'||x_line_rem);
2758: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2759: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2760: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2761: arp_standard.debug('get_latest_amount_remaining -');
2754: FETCH c_line INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2755: CLOSE c_line;
2756: END IF;
2757: arp_standard.debug(' x_line_rem :'||x_line_rem);
2758: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2759: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2760: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2761: arp_standard.debug('get_latest_amount_remaining -');
2762: EXCEPTION
2755: CLOSE c_line;
2756: END IF;
2757: arp_standard.debug(' x_line_rem :'||x_line_rem);
2758: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2759: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2760: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2761: arp_standard.debug('get_latest_amount_remaining -');
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2756: END IF;
2757: arp_standard.debug(' x_line_rem :'||x_line_rem);
2758: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2759: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2760: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2761: arp_standard.debug('get_latest_amount_remaining -');
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2757: arp_standard.debug(' x_line_rem :'||x_line_rem);
2758: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2759: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2760: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2761: arp_standard.debug('get_latest_amount_remaining -');
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2765: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2760: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2761: arp_standard.debug('get_latest_amount_remaining -');
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2765: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2766: FND_MESSAGE.SET_TOKEN( 'TEXT', 'get_latest_amount_remaining NO_DATA_FOUND
2767: customer_trx_id :'||g_customer_trx.customer_trx_id||'
2768: p_app_level :'||p_app_level||'
2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774: x_return_status := FND_API.G_RET_STS_SUCCESS;
2775: WHEN OTHERS THEN
2776: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_remaining:'||SQLERRM);
2777: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2778: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );
2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2910: l_res VARCHAR2(30);
2911: not_a_valid_inv_line EXCEPTION;
2912: not_a_line_type_inv_line EXCEPTION;
2913: BEGIN
2914: arp_standard.debug('get_latest_amount_applied +');
2915: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2916: arp_standard.debug(' p_app_level :'||p_app_level);
2917: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2918: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2911: not_a_valid_inv_line EXCEPTION;
2912: not_a_line_type_inv_line EXCEPTION;
2913: BEGIN
2914: arp_standard.debug('get_latest_amount_applied +');
2915: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2916: arp_standard.debug(' p_app_level :'||p_app_level);
2917: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2918: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2919:
2912: not_a_line_type_inv_line EXCEPTION;
2913: BEGIN
2914: arp_standard.debug('get_latest_amount_applied +');
2915: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2916: arp_standard.debug(' p_app_level :'||p_app_level);
2917: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2918: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2919:
2920: x_line_app := l_line_app;
2913: BEGIN
2914: arp_standard.debug('get_latest_amount_applied +');
2915: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2916: arp_standard.debug(' p_app_level :'||p_app_level);
2917: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2918: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2919:
2920: x_line_app := l_line_app;
2921: x_tax_app := l_tax_app;
2914: arp_standard.debug('get_latest_amount_applied +');
2915: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2916: arp_standard.debug(' p_app_level :'||p_app_level);
2917: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2918: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2919:
2920: x_line_app := l_line_app;
2921: x_tax_app := l_tax_app;
2922: x_freight_app := l_frt_app;
3095: END IF;
3096: CLOSE c_log_inv_line;
3097:
3098: END IF;
3099: arp_standard.debug(' x_line_app :'||x_line_app);
3100: arp_standard.debug(' x_tax_app :'||x_tax_app);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3096: CLOSE c_log_inv_line;
3097:
3098: END IF;
3099: arp_standard.debug(' x_line_app :'||x_line_app);
3100: arp_standard.debug(' x_tax_app :'||x_tax_app);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3097:
3098: END IF;
3099: arp_standard.debug(' x_line_app :'||x_line_app);
3100: arp_standard.debug(' x_tax_app :'||x_tax_app);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3098: END IF;
3099: arp_standard.debug(' x_line_app :'||x_line_app);
3100: arp_standard.debug(' x_tax_app :'||x_tax_app);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3099: arp_standard.debug(' x_line_app :'||x_line_app);
3100: arp_standard.debug(' x_tax_app :'||x_tax_app);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3100: arp_standard.debug(' x_tax_app :'||x_tax_app);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3101: arp_standard.debug(' x_freight_app :'||x_freight_app);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3102: arp_standard.debug(' x_charges_app :'||x_charges_app);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3103: arp_standard.debug(' x_line_ed :'||x_line_ed);
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3111: arp_standard.debug('get_latest_amount_applied -');
3104: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3111: arp_standard.debug('get_latest_amount_applied -');
3112: EXCEPTION
3105: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3111: arp_standard.debug('get_latest_amount_applied -');
3112: EXCEPTION
3113: WHEN OTHERS THEN
3106: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3111: arp_standard.debug('get_latest_amount_applied -');
3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3107: arp_standard.debug(' x_line_uned :'||x_line_uned);
3108: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3109: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3111: arp_standard.debug('get_latest_amount_applied -');
3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3115: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3110: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3111: arp_standard.debug('get_latest_amount_applied -');
3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3115: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3116: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_applied-'||SQLERRM );
3117: FND_MSG_PUB.ADD;
3118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3208: l_sum_uned_line NUMBER;
3209: l_sum_uned_tax NUMBER;
3210: i NUMBER := 0;
3211: BEGIN
3212: arp_standard.debug('verif_int_adj_line_tax +');
3213: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3214: arp_standard.debug(' p_line_flag :'||p_line_flag);
3215: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3216:
3209: l_sum_uned_tax NUMBER;
3210: i NUMBER := 0;
3211: BEGIN
3212: arp_standard.debug('verif_int_adj_line_tax +');
3213: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3214: arp_standard.debug(' p_line_flag :'||p_line_flag);
3215: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3216:
3217: IF p_gt_id IS NULL THEN
3210: i NUMBER := 0;
3211: BEGIN
3212: arp_standard.debug('verif_int_adj_line_tax +');
3213: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3214: arp_standard.debug(' p_line_flag :'||p_line_flag);
3215: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3216:
3217: IF p_gt_id IS NULL THEN
3218: x_return_status := fnd_api.g_ret_sts_error;
3211: BEGIN
3212: arp_standard.debug('verif_int_adj_line_tax +');
3213: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3214: arp_standard.debug(' p_line_flag :'||p_line_flag);
3215: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3216:
3217: IF p_gt_id IS NULL THEN
3218: x_return_status := fnd_api.g_ret_sts_error;
3219: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3215: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3216:
3217: IF p_gt_id IS NULL THEN
3218: x_return_status := fnd_api.g_ret_sts_error;
3219: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3220: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3221: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3222: FND_MSG_PUB.ADD;
3223: ELSE
3226: OR
3227: ((p_adj_rec.amount = 0 ) AND (p_adj_rec.acctd_amount = 0 ))
3228: THEN
3229: x_return_status := fnd_api.g_ret_sts_error;
3230: arp_standard.debug(' Adjustment record amount and accounted amount causes no need to execute');
3231: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3232: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record amount and accounted amount causes no need to execute');
3233: FND_MSG_PUB.ADD;
3234: ELSIF ((p_adj_rec.amount IS NULL) AND (p_adj_rec.acctd_amount IS NOT NULL))
3238: ((p_adj_rec.amount <> p_adj_rec.acctd_amount) AND
3239: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: arp_standard.debug(' Adjustment record combination causes an invalid combination');
3243: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3244: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record combination causes an invalid combination');
3245: FND_MSG_PUB.ADD;
3246: END IF;
3249: FETCH verif_amt INTO l_sum_line ,
3250: l_sum_tax ;
3251: CLOSE verif_amt;
3252:
3253: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3254: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3255:
3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN
3250: l_sum_tax ;
3251: CLOSE verif_amt;
3252:
3253: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3254: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3255:
3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN
3258: x_return_status := fnd_api.g_ret_sts_error;
3255:
3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN
3258: x_return_status := fnd_api.g_ret_sts_error;
3259: arp_standard.debug(' There is no line amount and tax amount in the interface table for this adjustment');
3260: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3261: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount and tax amount in the interface table for adjustment -'||
3262: ' adjustment_id : ' || p_adj_rec.adjustment_id);
3263: END IF;
3264:
3265:
3266: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3267: x_return_status := fnd_api.g_ret_sts_error;
3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3271: FND_MSG_PUB.ADD;
3272: END IF;
3272: END IF;
3273:
3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3279: FND_MSG_PUB.ADD;
3280: END IF;
3279: FND_MSG_PUB.ADD;
3280: END IF;
3281:
3282: END IF;
3283: arp_standard.debug('verif_int_adj_line_tax -');
3284: END;
3285:
3286:
3287: PROCEDURE verif_int_app_line_tax
3317: l_sum_uned_line NUMBER;
3318: l_sum_uned_tax NUMBER;
3319: i NUMBER := 0;
3320: BEGIN
3321: arp_standard.debug('verif_int_app_line_tax +');
3322: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3318: l_sum_uned_tax NUMBER;
3319: i NUMBER := 0;
3320: BEGIN
3321: arp_standard.debug('verif_int_app_line_tax +');
3322: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3319: i NUMBER := 0;
3320: BEGIN
3321: arp_standard.debug('verif_int_app_line_tax +');
3322: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3320: BEGIN
3321: arp_standard.debug('verif_int_app_line_tax +');
3322: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3321: arp_standard.debug('verif_int_app_line_tax +');
3322: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3322: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3323: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3324: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3325: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3333:
3326: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3333:
3334: IF p_gt_id IS NULL THEN
3327: arp_standard.debug(' p_line_flag :'||p_line_flag);
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3333:
3334: IF p_gt_id IS NULL THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3328: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3329: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3330: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3333:
3334: IF p_gt_id IS NULL THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3336: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3333:
3334: IF p_gt_id IS NULL THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3336: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3337: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3338: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3339: FND_MSG_PUB.ADD;
3340: ELSE
3343: OR
3344: ((p_app_rec.amount_applied = 0 ) AND (p_app_rec.acctd_amount_applied_to = 0 ))
3345: THEN
3346: x_return_status := fnd_api.g_ret_sts_error;
3347: arp_standard.debug(' Application record amount and accounted amount to causes no need to execute'||
3348: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3349: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3350: FND_MESSAGE.SET_TOKEN('TEXT',' Application record amount and accounted amount to causes no need to execute'||
3351: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3357: ((p_app_rec.amount_applied <> p_app_rec.acctd_amount_applied_to) AND
3358: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3359: THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: arp_standard.debug(' Application record combination causes an invalid combination on amount bucket');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: FND_MESSAGE.SET_TOKEN('TEXT',' Application record combination causes an invalid combination');
3364: FND_MSG_PUB.ADD;
3365: END IF;
3372: l_sum_uned_line ,
3373: l_sum_uned_tax ;
3374: CLOSE verif_amt;
3375:
3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3373: l_sum_uned_tax ;
3374: CLOSE verif_amt;
3375:
3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3374: CLOSE verif_amt;
3375:
3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3375:
3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3381: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3389: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3382: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3389: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3390: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3383:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3389: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3390: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3391:
3384: arp_standard.debug('RECORD p_app_rec ');
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3389: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3390: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3391:
3392:
3385: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3389: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3390: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3391:
3392:
3393: IF (l_sum_line = NULL) AND (l_sum_tax = NULL ) AND
3386: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3387: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3388: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3389: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3390: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3391:
3392:
3393: IF (l_sum_line = NULL) AND (l_sum_tax = NULL ) AND
3394: (l_sum_ed_line = NULL) AND (l_sum_ed_tax = NULL ) AND
3394: (l_sum_ed_line = NULL) AND (l_sum_ed_tax = NULL ) AND
3395: (l_sum_uned_line = NULL) AND (l_sum_uned_tax = NULL )
3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_error;
3398: arp_standard.debug(' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application');
3399: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3400: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application'||
3401: ' receivable_application_id : ' || p_app_rec.receivable_application_id);
3402: END IF;
3403:
3404:
3405: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3406: x_return_status := fnd_api.g_ret_sts_error;
3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3410: FND_MSG_PUB.ADD;
3411: END IF;
3411: END IF;
3412:
3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3414: x_return_status := fnd_api.g_ret_sts_error;
3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3418: FND_MSG_PUB.ADD;
3419: END IF;
3419: END IF;
3420:
3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3426: FND_MSG_PUB.ADD;
3427: END IF;
3427: END IF;
3428:
3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3430: x_return_status := fnd_api.g_ret_sts_error;
3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3434: FND_MSG_PUB.ADD;
3435: END IF;
3435: END IF;
3436:
3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3438: x_return_status := fnd_api.g_ret_sts_error;
3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3442: FND_MSG_PUB.ADD;
3443: END IF;
3443: END IF;
3444:
3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3446: x_return_status := fnd_api.g_ret_sts_error;
3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3450: FND_MSG_PUB.ADD;
3451: END IF;
3450: FND_MSG_PUB.ADD;
3451: END IF;
3452:
3453: END IF;
3454: arp_standard.debug('verif_int_app_line_tax -');
3455: END;
3456:
3457:
3458:
3477: IS
3478: l_denom number;
3479: begin
3480:
3481: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3482: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3483: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3484: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3485: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3478: l_denom number;
3479: begin
3480:
3481: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3482: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3483: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3484: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3485: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3486:
3479: begin
3480:
3481: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3482: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3483: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3484: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3485: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3486:
3487: l_denom := tot_earned_discount_in + tot_unearned_discount_in;
3480:
3481: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3482: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3483: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3484: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3485: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3486:
3487: l_denom := tot_earned_discount_in + tot_unearned_discount_in;
3488:
3481: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3482: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3483: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3484: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3485: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3486:
3487: l_denom := tot_earned_discount_in + tot_unearned_discount_in;
3488:
3489: if l_denom <> 0 then
3496: ed_frt_out := (frt_discount_in / l_denom) * tot_earned_discount_in;
3497: ued_frt_out := frt_discount_in - ed_frt_out;
3498:
3499: end if;
3500: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3501: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3502: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3503: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3504: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3497: ued_frt_out := frt_discount_in - ed_frt_out;
3498:
3499: end if;
3500: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3501: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3502: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3503: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3504: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3505: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3498:
3499: end if;
3500: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3501: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3502: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3503: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3504: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3505: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3506:
3499: end if;
3500: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3501: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3502: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3503: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3504: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3505: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3506:
3507: END breakup_discounts;
3500: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3501: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3502: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3503: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3504: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3505: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3506:
3507: END breakup_discounts;
3508:
3501: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3502: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3503: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3504: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3505: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3506:
3507: END breakup_discounts;
3508:
3509: