[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
880: RETURN 'Y';
881: END IF;
882: END is_bucket_concern;
883: BEGIN
884: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
885: arp_standard.debug(' p_line_applied :'||p_line_applied);
886: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
881: END IF;
882: END is_bucket_concern;
883: BEGIN
884: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
885: arp_standard.debug(' p_line_applied :'||p_line_applied);
886: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
882: END is_bucket_concern;
883: BEGIN
884: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
885: arp_standard.debug(' p_line_applied :'||p_line_applied);
886: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
883: BEGIN
884: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
885: arp_standard.debug(' p_line_applied :'||p_line_applied);
886: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
884: arp_standard.debug('arp_process_det_pkg.upd_inv_ps+' );
885: arp_standard.debug(' p_line_applied :'||p_line_applied);
886: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
886: arp_standard.debug(' p_tax_applied :'||p_tax_applied);
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
887: arp_standard.debug(' p_freight_applied :'||p_freight_applied);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
888: arp_standard.debug(' p_charges_applied :'||p_charges_applied);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
889: --
890: arp_standard.debug(' p_line_ediscounted :'||p_line_ediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
897: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
891: arp_standard.debug(' p_tax_ediscounted :'||p_tax_ediscounted);
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
897: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
898: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
899: --
892: arp_standard.debug(' p_freight_ediscounted :'||p_freight_ediscounted);
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
897: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
898: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
899: --
900: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
893: arp_standard.debug(' p_charges_ediscounted :'||p_charges_ediscounted);
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
897: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
898: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
899: --
900: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
901: l_ps_rec := g_payschedule_trx;
894: --
895: arp_standard.debug(' p_line_uediscounted :'||p_line_uediscounted);
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
897: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
898: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
899: --
900: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
901: l_ps_rec := g_payschedule_trx;
902: l_applied_concern := is_bucket_concern(p_line_applied => p_line_applied,
896: arp_standard.debug(' p_tax_uediscounted :'||p_tax_uediscounted);
897: arp_standard.debug(' p_freight_uediscounted :'||p_freight_uediscounted);
898: arp_standard.debug(' p_charges_uediscounted :'||p_charges_uediscounted);
899: --
900: arp_standard.debug(' payment_schedule_id : '||g_payschedule_trx.payment_schedule_id );
901: l_ps_rec := g_payschedule_trx;
902: l_applied_concern := is_bucket_concern(p_line_applied => p_line_applied,
903: p_tax_applied => p_tax_applied,
904: p_freight_applied => p_freight_applied,
1050: l_apps_rec.STATUS := 'APP';
1051: insert_rapps_p(p_app_rec => l_apps_rec,
1052: x_return_status => x_return_status);
1053: x_app_rec := l_apps_rec;
1054: arp_standard.debug( 'arp_process_det_pkg.upd_inv_ps-' );
1055: EXCEPTION
1056: WHEN neg_app_amt THEN
1057: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1058: IF l_earned_concern = 'PBLINENEG' THEN
1105: PROCEDURE disp_app_rec
1106: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1107: IS
1108: BEGIN
1109: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1106: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1107: IS
1108: BEGIN
1109: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1107: IS
1108: BEGIN
1109: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1108: BEGIN
1109: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1109: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1111: arp_standard.debug('p_app_rec.group_id :'||p_app_rec.group_id);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1112: arp_standard.debug('p_app_rec.ctl_id :'||p_app_rec.ctl_id);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1113: arp_standard.debug('p_app_rec.RECEIVABLE_APPLICATION_ID :'||p_app_rec.RECEIVABLE_APPLICATION_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1114: arp_standard.debug('p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1115: arp_standard.debug('p_app_rec.CODE_COMBINATION_ID :'||p_app_rec.CODE_COMBINATION_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1116: arp_standard.debug('p_app_rec.SET_OF_BOOKS_ID :'||p_app_rec.SET_OF_BOOKS_ID);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1117: arp_standard.debug('p_app_rec.APPLICATION_TYPE :'||p_app_rec.APPLICATION_TYPE);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1118: arp_standard.debug('p_app_rec.PAYMENT_SCHEDULE_ID :'||p_app_rec.PAYMENT_SCHEDULE_ID);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1119: arp_standard.debug('p_app_rec.CASH_RECEIPT_ID :'||p_app_rec.CASH_RECEIPT_ID);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1120: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_ID);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1121: arp_standard.debug('p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID :'||p_app_rec.APPLIED_CUSTOMER_TRX_LINE_ID);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1122: arp_standard.debug('p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID :'||p_app_rec.APPLIED_PAYMENT_SCHEDULE_ID);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1123: arp_standard.debug('p_app_rec.CUSTOMER_TRX_ID :'||p_app_rec.CUSTOMER_TRX_ID);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1124: arp_standard.debug('p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1125: arp_standard.debug('p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1126: arp_standard.debug('p_app_rec.FREIGHT_APPLIED :'||p_app_rec.freight_APPLIED);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1127: arp_standard.debug('p_app_rec.RECEIVABLES_CHARGES_APPLIED :'||p_app_rec.RECEIVABLES_CHARGES_APPLIED);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1128: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_TAKEN :'||p_app_rec.EARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1129: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.UNEARNED_DISCOUNT_TAKEN);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1130: arp_standard.debug('p_app_rec.APPLICATION_RULE :'||p_app_rec.APPLICATION_RULE);
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1131: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1132: arp_standard.debug('p_app_rec.ACCTD_AMOUNT_APPLIED_TO :'||p_app_rec.ACCTD_AMOUNT_APPLIED_TO);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1133: arp_standard.debug('p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_EARNED_DISCOUNT_TAKEN);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1134: arp_standard.debug('p_app_rec.EARNED_DISCOUNT_CCID :'||p_app_rec.EARNED_DISCOUNT_CCID);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1135: arp_standard.debug('p_app_rec.UNEARNED_DISCOUNT_CCID :'||p_app_rec.UNEARNED_DISCOUNT_CCID);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1136: arp_standard.debug('p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN :'||p_app_rec.ACCTD_UNEARNED_DISCOUNT_TAKEN);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1137: arp_standard.debug('p_app_rec.ORG_ID :'||p_app_rec.ORG_ID);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1138: arp_standard.debug('p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1146: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1139: arp_standard.debug('p_app_rec.RULE_SET_ID :'||p_app_rec.RULE_SET_ID);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1146: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1140: arp_standard.debug('p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1146: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1148: END disp_app_rec;
1141: arp_standard.debug('p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1146: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1148: END disp_app_rec;
1149:
1142: arp_standard.debug('p_app_rec.FREIGHT_EDISCOUNTED :'||p_app_rec.FREIGHT_EDISCOUNTED);
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1146: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1148: END disp_app_rec;
1149:
1150:
1143: arp_standard.debug('p_app_rec.CHARGES_EDISCOUNTED :'||p_app_rec.CHARGES_EDISCOUNTED);
1144: arp_standard.debug('p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
1145: arp_standard.debug('p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
1146: arp_standard.debug('p_app_rec.FREIGHT_UEDISCOUNTED :'||p_app_rec.FREIGHT_UEDISCOUNTED);
1147: arp_standard.debug('p_app_rec.CHARGES_UEDISCOUNTED :'||p_app_rec.CHARGES_UEDISCOUNTED);
1148: END disp_app_rec;
1149:
1150:
1151: /*-----------------------------------------------------------------------------+
1160: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1161: x_return_status IN OUT NOCOPY VARCHAR2)
1162: IS
1163: BEGIN
1164: arp_standard.debug('insert_rapps_p +');
1165: disp_app_rec(p_app_rec);
1166: INSERT INTO ar_receivable_apps_gt
1167: (GT_ID
1168: ,app_level
1249: ,p_app_rec.LINE_UEDISCOUNTED
1250: ,p_app_rec.TAX_UEDISCOUNTED
1251: ,p_app_rec.FREIGHT_UEDISCOUNTED
1252: ,p_app_rec.CHARGES_UEDISCOUNTED);
1253: arp_standard.debug('insert_rapps_p -');
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1257: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1252: ,p_app_rec.CHARGES_UEDISCOUNTED);
1253: arp_standard.debug('insert_rapps_p -');
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1257: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1258: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS insert_rapps_p:'||SQLERRM );
1259: FND_MSG_PUB.ADD;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1352: l_last_fetch BOOLEAN := FALSE;
1353: BEGIN
1354: arp_standard.debug('res_ctl_rem_amt_for_app +');
1355: disp_app_rec(p_app_rec);
1356: OPEN c_app(p_app_rec);
1357: LOOP
1358: FETCH c_app BULK COLLECT INTO l_rev_amt_rem_tab,
1373: l_last_fetch := TRUE;
1374: END IF;
1375:
1376: IF (l_ctl_id_tab.COUNT = 0) AND (l_last_fetch) THEN
1377: arp_standard.debug('COUNT = 0 and LAST FETCH ');
1378: EXIT;
1379: END IF;
1380:
1381: FORALL i IN l_ctl_id_tab.FIRST .. l_ctl_id_tab.LAST
1402: CHRG_ACCTD_AMOUNT_REMAINING + l_chrg_adj_acctd_amt_rem_tab(i)
1403: WHERE customer_trx_line_id = l_ctl_id_tab(i);
1404: END LOOP;
1405: CLOSE c_app;
1406: arp_standard.debug('res_ctl_rem_amt_for_app -');
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1410: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1405: CLOSE c_app;
1406: arp_standard.debug('res_ctl_rem_amt_for_app -');
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1410: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1411: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_ctl_rem_amt_for_app:'||SQLERRM );
1412: FND_MSG_PUB.ADD;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: l_charges_discounted NUMBER;
1433: l_discount_taken_total NUMBER;
1434: l_freight_discounted NUMBER;
1435: BEGIN
1436: arp_standard.debug('res_inv_ps +');
1437: disp_app_rec(p_app_rec);
1438: l_ps_rec := g_payschedule_trx;
1439:
1440: l_ps_rec.amount_applied := NVL(l_ps_rec.amount_applied,0)
1469: l_ps_rec.freight_remaining := NVL( l_ps_rec.freight_remaining, 0 ) +
1470: ( NVL( p_app_rec.FREIGHT_APPLIED, 0 ) +
1471: NVL( l_freight_discounted, 0 ) );
1472: g_payschedule_trx := l_ps_rec;
1473: arp_standard.debug('res_inv_ps -');
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1477: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1472: g_payschedule_trx := l_ps_rec;
1473: arp_standard.debug('res_inv_ps -');
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1477: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1478: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_inv_ps:'||SQLERRM );
1479: FND_MSG_PUB.ADD;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1498: x_return_status IN OUT NOCOPY VARCHAR2)
1499: IS
1500: BEGIN
1501: arp_standard.debug('delete_application +');
1502: -- 1 restore ps inv
1503: res_inv_ps(p_app_rec => p_app_rec,
1504: x_return_status => x_return_status);
1505:
1516: DELETE FROM AR_LINE_APP_DETAIL_GT
1517: WHERE gt_id = p_app_rec.gt_id
1518: AND app_level = p_app_rec.app_level;
1519:
1520: arp_standard.debug('delete_application -');
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1524: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1519:
1520: arp_standard.debug('delete_application -');
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1524: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1525: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS delete_application:'||SQLERRM );
1526: FND_MSG_PUB.ADD;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1533: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
1534: x_return_status IN OUT NOCOPY VARCHAR2)
1535: IS
1536: BEGIN
1537: arp_standard.debug('copy_app_rec +');
1538: disp_app_rec(p_app_rec);
1539: x_ra_rec.RECEIVABLE_APPLICATION_ID := p_app_rec.RECEIVABLE_APPLICATION_ID;
1540: x_ra_rec.AMOUNT_APPLIED := p_app_rec.AMOUNT_APPLIED;
1541: x_ra_rec.CODE_COMBINATION_ID := p_app_rec.CODE_COMBINATION_ID;
1572: x_ra_rec.FREIGHT_UEDISCOUNTED := p_app_rec.FREIGHT_UEDISCOUNTED;
1573: x_ra_rec.CHARGES_UEDISCOUNTED := p_app_rec.CHARGES_UEDISCOUNTED;
1574: x_ra_rec.STATUS := p_app_rec.STATUS;
1575:
1576: arp_standard.debug(' x_ra_rec.LINE_APPLIED:'||x_ra_rec.LINE_APPLIED);
1577: arp_standard.debug(' x_ra_rec.TAX_APPLIED:'||x_ra_rec.TAX_APPLIED);
1578:
1579: arp_standard.debug('copy_app_rec -');
1580: EXCEPTION
1573: x_ra_rec.CHARGES_UEDISCOUNTED := p_app_rec.CHARGES_UEDISCOUNTED;
1574: x_ra_rec.STATUS := p_app_rec.STATUS;
1575:
1576: arp_standard.debug(' x_ra_rec.LINE_APPLIED:'||x_ra_rec.LINE_APPLIED);
1577: arp_standard.debug(' x_ra_rec.TAX_APPLIED:'||x_ra_rec.TAX_APPLIED);
1578:
1579: arp_standard.debug('copy_app_rec -');
1580: EXCEPTION
1581: WHEN OTHERS THEN
1575:
1576: arp_standard.debug(' x_ra_rec.LINE_APPLIED:'||x_ra_rec.LINE_APPLIED);
1577: arp_standard.debug(' x_ra_rec.TAX_APPLIED:'||x_ra_rec.TAX_APPLIED);
1578:
1579: arp_standard.debug('copy_app_rec -');
1580: EXCEPTION
1581: WHEN OTHERS THEN
1582: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1583: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1578:
1579: arp_standard.debug('copy_app_rec -');
1580: EXCEPTION
1581: WHEN OTHERS THEN
1582: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1583: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1584: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS copy_app_rec:'||SQLERRM );
1585: FND_MSG_PUB.ADD;
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: x_return_status IN OUT NOCOPY VARCHAR2)
1605: IS
1606: l_ra_rec ar_receivable_applications%ROWTYPE;
1607: BEGIN
1608: arp_standard.debug('do_apply +');
1609: copy_app_rec(p_app_rec => p_app_rec,
1610: x_ra_rec => l_ra_rec,
1611: x_return_status => x_return_status);
1612:
1636: p_gt_id => p_gt_id);
1637:
1638: ELSIF p_app_rec.app_level = 'LINE' THEN
1639:
1640: arp_standard.debug(' HYU l_ra_rec.LINE_APPLIED:'||l_ra_rec.LINE_APPLIED);
1641: arp_standard.debug(' HYU l_ra_rec.TAX_APPLIED:'||l_ra_rec.TAX_APPLIED);
1642:
1643: ARP_DET_DIST_PKG.Trx_line_level_cash_apply
1644: (p_customer_trx => g_customer_trx,
1637:
1638: ELSIF p_app_rec.app_level = 'LINE' THEN
1639:
1640: arp_standard.debug(' HYU l_ra_rec.LINE_APPLIED:'||l_ra_rec.LINE_APPLIED);
1641: arp_standard.debug(' HYU l_ra_rec.TAX_APPLIED:'||l_ra_rec.TAX_APPLIED);
1642:
1643: ARP_DET_DIST_PKG.Trx_line_level_cash_apply
1644: (p_customer_trx => g_customer_trx,
1645: p_customer_trx_line_id => p_app_rec.ctl_id,
1648: p_ae_sys_rec => g_ae_sys_rec,
1649: p_gt_id => p_gt_id);
1650:
1651: END IF;
1652: arp_standard.debug('do_apply -');
1653: EXCEPTION
1654: WHEN OTHERS THEN
1655: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1656: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1651: END IF;
1652: arp_standard.debug('do_apply -');
1653: EXCEPTION
1654: WHEN OTHERS THEN
1655: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1656: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1657: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS do_apply:'||SQLERRM );
1658: FND_MSG_PUB.ADD;
1659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1718: x_return_status IN OUT NOCOPY VARCHAR2)
1719: IS
1720: l_app_rec ar_receivable_apps_gt%ROWTYPE;
1721: BEGIN
1722: arp_standard.debug('apply +');
1723:
1724: arp_standard.debug(' Calling upd_inv_ps +');
1725:
1726: upd_inv_ps(
1720: l_app_rec ar_receivable_apps_gt%ROWTYPE;
1721: BEGIN
1722: arp_standard.debug('apply +');
1723:
1724: arp_standard.debug(' Calling upd_inv_ps +');
1725:
1726: upd_inv_ps(
1727: p_app_level => p_app_level,
1728: --
1752: --
1753: x_app_rec => l_app_rec,
1754: x_return_status => x_return_status);
1755:
1756: arp_standard.debug(' x_return_status :'|| x_return_status);
1757:
1758: arp_standard.debug(' Calling upd_inv_ps -');
1759:
1760: do_apply
1754: x_return_status => x_return_status);
1755:
1756: arp_standard.debug(' x_return_status :'|| x_return_status);
1757:
1758: arp_standard.debug(' Calling upd_inv_ps -');
1759:
1760: do_apply
1761: (p_app_rec => l_app_rec,
1762: p_gt_id => l_app_rec.gt_id,
1760: do_apply
1761: (p_app_rec => l_app_rec,
1762: p_gt_id => l_app_rec.gt_id,
1763: x_return_status=> x_return_status);
1764: arp_standard.debug('apply -');
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1768: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1763: x_return_status=> x_return_status);
1764: arp_standard.debug('apply -');
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1768: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1769: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS apply:'||SQLERRM );
1770: FND_MSG_PUB.ADD;
1771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773:
1774: PROCEDURE dump_ccid
1775: IS
1776: BEGIN
1777: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1778: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1774: PROCEDURE dump_ccid
1775: IS
1776: BEGIN
1777: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1778: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1775: IS
1776: BEGIN
1777: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1778: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1776: BEGIN
1777: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1778: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1777: arp_standard.debug('g_unapplied_ccid :'||g_unapplied_ccid);
1778: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1785: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1778: arp_standard.debug('g_ed_ccid :'||g_ed_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1785: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1786: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1779: arp_standard.debug('g_uned_ccid :'||g_uned_ccid);
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1785: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1786: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1787: END dump_ccid;
1780: arp_standard.debug('g_unidentified_ccid :'||g_unidentified_ccid);
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1785: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1786: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1787: END dump_ccid;
1788:
1781: arp_standard.debug('g_clearing_ccid :'||g_clearing_ccid);
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1785: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1786: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1787: END dump_ccid;
1788:
1789: /*-----------------------------------------------------------------------------+
1782: arp_standard.debug('g_remittance_ccid :'||g_remittance_ccid);
1783: arp_standard.debug('g_cash_ccid :'||g_cash_ccid);
1784: arp_standard.debug('g_on_account_ccid :'||g_on_account_ccid);
1785: arp_standard.debug('g_factor_ccid :'||g_factor_ccid);
1786: arp_standard.debug('g_inv_rec_ccid :'||g_inv_rec_ccid);
1787: END dump_ccid;
1788:
1789: /*-----------------------------------------------------------------------------+
1790: | Procedure initialization |
1865: not_valid_trx EXCEPTION;
1866: no_sys_param EXCEPTION;
1867: not_valid_cr EXCEPTION;
1868: BEGIN
1869: arp_standard.debug('initialization +');
1870: SAVEPOINT initialization;
1871: x_return_status := fnd_api.g_ret_sts_success;
1872: OPEN c;
1873: FETCH c INTO g_customer_trx;
1934: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1935: RAISE FND_API.G_EXC_ERROR;
1936: END IF;
1937:
1938: arp_standard.debug('initialization -');
1939: EXCEPTION
1940: WHEN no_sys_param THEN
1941: ROLLBACK TO initialization;
1942: arp_standard.debug('EXCEPTION initialization no_sys_param');
1938: arp_standard.debug('initialization -');
1939: EXCEPTION
1940: WHEN no_sys_param THEN
1941: ROLLBACK TO initialization;
1942: arp_standard.debug('EXCEPTION initialization no_sys_param');
1943: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' );
1944: FND_MSG_PUB.ADD;
1945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1947: p_count => x_msg_count,
1948: p_data => x_msg_data);
1949: WHEN not_valid_trx THEN
1950: ROLLBACK TO initialization;
1951: arp_standard.debug('EXCEPTION initialization not_valid_trx');
1952: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1953: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||
1954: p_customer_trx_id );
1955: FND_MSG_PUB.ADD;
1958: p_count => x_msg_count,
1959: p_data => x_msg_data);
1960: WHEN not_valid_cr THEN
1961: ROLLBACK TO initialization;
1962: arp_standard.debug('EXCEPTION initialization not_valid_cr');
1963: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1964: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||
1965: p_cash_receipt_id );
1966: FND_MSG_PUB.ADD;
1975: p_count => x_msg_count,
1976: p_data => x_msg_data);
1977: WHEN OTHERS THEN
1978: ROLLBACK TO initialization;
1979: arp_standard.debug('EXCEPTION initialization OTHERS:'||SQLERRM);
1980: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1981: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );
1982: FND_MSG_PUB.ADD;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2036: WHERE app_level = 'LINE'
2037: AND ctl_id = p_ctl_id;
2038: l_res VARCHAR2(30);
2039: BEGIN
2040: arp_standard.debug('cur_app_gt_id +');
2041: arp_standard.debug(' p_app_level :'||p_app_level);
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2037: AND ctl_id = p_ctl_id;
2038: l_res VARCHAR2(30);
2039: BEGIN
2040: arp_standard.debug('cur_app_gt_id +');
2041: arp_standard.debug(' p_app_level :'||p_app_level);
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2038: l_res VARCHAR2(30);
2039: BEGIN
2040: arp_standard.debug('cur_app_gt_id +');
2041: arp_standard.debug(' p_app_level :'||p_app_level);
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2046: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2039: BEGIN
2040: arp_standard.debug('cur_app_gt_id +');
2041: arp_standard.debug(' p_app_level :'||p_app_level);
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2046: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2047: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2040: arp_standard.debug('cur_app_gt_id +');
2041: arp_standard.debug(' p_app_level :'||p_app_level);
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2046: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2047: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2048: IF p_app_level = 'TRANSACTION' THEN
2041: arp_standard.debug(' p_app_level :'||p_app_level);
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2046: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2047: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2048: IF p_app_level = 'TRANSACTION' THEN
2049: OPEN c_trx;
2042: arp_standard.debug(' p_source_data_key1 :'||p_source_data_key1);
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2046: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2047: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2048: IF p_app_level = 'TRANSACTION' THEN
2049: OPEN c_trx;
2050: FETCH c_trx INTO x_app_rec;
2043: arp_standard.debug(' p_source_data_key2 :'||p_source_data_key2);
2044: arp_standard.debug(' p_source_data_key3 :'||p_source_data_key3);
2045: arp_standard.debug(' p_source_data_key4 :'||p_source_data_key4);
2046: arp_standard.debug(' p_source_data_key5 :'||p_source_data_key5);
2047: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2048: IF p_app_level = 'TRANSACTION' THEN
2049: OPEN c_trx;
2050: FETCH c_trx INTO x_app_rec;
2051: IF c_trx%NOTFOUND THEN
2074: CLOSE c_ctl;
2075: ELSE
2076: l_res := 'X';
2077: END IF;
2078: arp_standard.debug(' l_res :'||l_res);
2079: arp_standard.debug('cur_app_gt_id -');
2080: RETURN l_res;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2075: ELSE
2076: l_res := 'X';
2077: END IF;
2078: arp_standard.debug(' l_res :'||l_res);
2079: arp_standard.debug('cur_app_gt_id -');
2080: RETURN l_res;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2079: arp_standard.debug('cur_app_gt_id -');
2080: RETURN l_res;
2081: EXCEPTION
2082: WHEN OTHERS THEN
2083: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2084: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2085: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS cur_app_gt_id:'||SQLERRM );
2086: FND_MSG_PUB.ADD;
2087: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2149: cur_gt_id VARCHAR2(30);
2150: l_app_rec ar_receivable_apps_gt%ROWTYPE;
2151: unexpected_error EXCEPTION;
2152: BEGIN
2153: arp_standard.debug('application_execute +');
2154: SAVEPOINT first_delete_then_apply;
2155:
2156: x_return_status := fnd_api.g_ret_sts_success;
2157:
2207: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2208: RAISE FND_API.G_EXC_ERROR;
2209: END IF;
2210:
2211: arp_standard.debug('application_execute -');
2212: EXCEPTION
2213: WHEN FND_API.G_EXC_ERROR THEN
2214: ROLLBACK TO first_delete_then_apply;
2215: x_return_status := FND_API.G_RET_STS_ERROR;
2217: p_count => x_msg_count,
2218: p_data => x_msg_data);
2219: WHEN unexpected_error THEN
2220: ROLLBACK TO first_delete_then_apply;
2221: arp_standard.debug('EXCEPTION first_delete_then_apply unexpected_error - p_app_level:'
2222: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2223: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2224: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'
2225: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2229: p_count => x_msg_count,
2230: p_data => x_msg_data);
2231: WHEN OTHERS THEN
2232: ROLLBACK TO first_delete_then_apply;
2233: arp_standard.debug('EXCEPTION first_delete_then_apply OTHERS:'||SQLERRM);
2234: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2235: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );
2236: FND_MSG_PUB.ADD;
2237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393: l_app_from NUMBER;
2394: l_tx_rate NUMBER;
2395:
2396: BEGIN
2397: arp_standard.debug('final_commit +');
2398: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2399:
2400: savepoint final_commit;
2401:
2394: l_tx_rate NUMBER;
2395:
2396: BEGIN
2397: arp_standard.debug('final_commit +');
2398: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2399:
2400: savepoint final_commit;
2401:
2402: x_return_status := fnd_api.g_ret_sts_success;
2462: END IF;
2463:
2464: END IF;
2465:
2466: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2467: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2468: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2469: arp_standard.debug(' l_app_from :'||l_app_from);
2470:
2463:
2464: END IF;
2465:
2466: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2467: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2468: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2469: arp_standard.debug(' l_app_from :'||l_app_from);
2470:
2471:
2464: END IF;
2465:
2466: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2467: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2468: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2469: arp_standard.debug(' l_app_from :'||l_app_from);
2470:
2471:
2472: IF NVL(p_trans_to_receipt_rate,0) <> 0 THEN
2465:
2466: arp_standard.debug(' x_ra_rec.amount_applied:'||x_ra_rec.amount_applied);
2467: arp_standard.debug(' p_amount_applied_from :'||p_amount_applied_from);
2468: arp_standard.debug(' x_ra_rec.amount_applied_from:'||x_ra_rec.amount_applied_from);
2469: arp_standard.debug(' l_app_from :'||l_app_from);
2470:
2471:
2472: IF NVL(p_trans_to_receipt_rate,0) <> 0 THEN
2473: l_tx_rate := p_trans_to_receipt_rate;
2591:
2592:
2593: END IF;
2594:
2595: arp_standard.debug('final_commit -');
2596: EXCEPTION
2597: WHEN OTHERS THEN
2598: ROLLBACK TO final_commit;
2599: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2595: arp_standard.debug('final_commit -');
2596: EXCEPTION
2597: WHEN OTHERS THEN
2598: ROLLBACK TO final_commit;
2599: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2600: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2601: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.final_commit-'||SQLERRM );
2602: FND_MSG_PUB.ADD;
2603: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2673: AND source_data_key3 = NVL(p_source_data_key3,'00')
2674: AND source_data_key4 = NVL(p_source_data_key4,'00')
2675: AND source_data_key5 = NVL(p_source_data_key5,'00');
2676: BEGIN
2677: arp_standard.debug('get_latest_amount_remaining +');
2678: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2679: arp_standard.debug(' p_app_level :'||p_app_level);
2680: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2681: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2674: AND source_data_key4 = NVL(p_source_data_key4,'00')
2675: AND source_data_key5 = NVL(p_source_data_key5,'00');
2676: BEGIN
2677: arp_standard.debug('get_latest_amount_remaining +');
2678: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2679: arp_standard.debug(' p_app_level :'||p_app_level);
2680: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2681: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2682: IF p_app_level = 'TRANSACTION' THEN
2675: AND source_data_key5 = NVL(p_source_data_key5,'00');
2676: BEGIN
2677: arp_standard.debug('get_latest_amount_remaining +');
2678: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2679: arp_standard.debug(' p_app_level :'||p_app_level);
2680: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2681: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2682: IF p_app_level = 'TRANSACTION' THEN
2683: OPEN c_trx;
2676: BEGIN
2677: arp_standard.debug('get_latest_amount_remaining +');
2678: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2679: arp_standard.debug(' p_app_level :'||p_app_level);
2680: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2681: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2682: IF p_app_level = 'TRANSACTION' THEN
2683: OPEN c_trx;
2684: FETCH c_trx INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2677: arp_standard.debug('get_latest_amount_remaining +');
2678: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2679: arp_standard.debug(' p_app_level :'||p_app_level);
2680: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2681: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2682: IF p_app_level = 'TRANSACTION' THEN
2683: OPEN c_trx;
2684: FETCH c_trx INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2685: CLOSE c_trx;
2691: OPEN c_line;
2692: FETCH c_line INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2693: CLOSE c_line;
2694: END IF;
2695: arp_standard.debug(' x_line_rem :'||x_line_rem);
2696: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2697: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2698: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2699: arp_standard.debug('get_latest_amount_remaining -');
2692: FETCH c_line INTO x_line_rem, x_tax_rem, x_charges_rem, x_freight_rem;
2693: CLOSE c_line;
2694: END IF;
2695: arp_standard.debug(' x_line_rem :'||x_line_rem);
2696: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2697: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2698: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2699: arp_standard.debug('get_latest_amount_remaining -');
2700: EXCEPTION
2693: CLOSE c_line;
2694: END IF;
2695: arp_standard.debug(' x_line_rem :'||x_line_rem);
2696: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2697: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2698: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2699: arp_standard.debug('get_latest_amount_remaining -');
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2694: END IF;
2695: arp_standard.debug(' x_line_rem :'||x_line_rem);
2696: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2697: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2698: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2699: arp_standard.debug('get_latest_amount_remaining -');
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2702: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2695: arp_standard.debug(' x_line_rem :'||x_line_rem);
2696: arp_standard.debug(' x_tax_rem :'||x_tax_rem);
2697: arp_standard.debug(' x_freight_rem :'||x_freight_rem);
2698: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2699: arp_standard.debug('get_latest_amount_remaining -');
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2702: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2703: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2698: arp_standard.debug(' x_charges_rem :'||x_charges_rem);
2699: arp_standard.debug('get_latest_amount_remaining -');
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2702: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2703: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2704: FND_MESSAGE.SET_TOKEN( 'TEXT', 'get_latest_amount_remaining NO_DATA_FOUND
2705: customer_trx_id :'||g_customer_trx.customer_trx_id||'
2706: p_app_level :'||p_app_level||'
2710: p_count => x_msg_count,
2711: p_data => x_msg_data);
2712: x_return_status := FND_API.G_RET_STS_SUCCESS;
2713: WHEN OTHERS THEN
2714: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_remaining:'||SQLERRM);
2715: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2716: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );
2717: FND_MSG_PUB.ADD;
2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2848: l_res VARCHAR2(30);
2849: not_a_valid_inv_line EXCEPTION;
2850: not_a_line_type_inv_line EXCEPTION;
2851: BEGIN
2852: arp_standard.debug('get_latest_amount_applied +');
2853: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2854: arp_standard.debug(' p_app_level :'||p_app_level);
2855: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2856: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2849: not_a_valid_inv_line EXCEPTION;
2850: not_a_line_type_inv_line EXCEPTION;
2851: BEGIN
2852: arp_standard.debug('get_latest_amount_applied +');
2853: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2854: arp_standard.debug(' p_app_level :'||p_app_level);
2855: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2856: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2857:
2850: not_a_line_type_inv_line EXCEPTION;
2851: BEGIN
2852: arp_standard.debug('get_latest_amount_applied +');
2853: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2854: arp_standard.debug(' p_app_level :'||p_app_level);
2855: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2856: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2857:
2858: x_line_app := l_line_app;
2851: BEGIN
2852: arp_standard.debug('get_latest_amount_applied +');
2853: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2854: arp_standard.debug(' p_app_level :'||p_app_level);
2855: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2856: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2857:
2858: x_line_app := l_line_app;
2859: x_tax_app := l_tax_app;
2852: arp_standard.debug('get_latest_amount_applied +');
2853: arp_standard.debug(' p_customer_trx_id :'||g_customer_trx.customer_trx_id);
2854: arp_standard.debug(' p_app_level :'||p_app_level);
2855: arp_standard.debug(' p_source_data_key1:'||p_source_data_key1);
2856: arp_standard.debug(' p_ctl_id :'||p_ctl_id);
2857:
2858: x_line_app := l_line_app;
2859: x_tax_app := l_tax_app;
2860: x_freight_app := l_frt_app;
3033: END IF;
3034: CLOSE c_log_inv_line;
3035:
3036: END IF;
3037: arp_standard.debug(' x_line_app :'||x_line_app);
3038: arp_standard.debug(' x_tax_app :'||x_tax_app);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3034: CLOSE c_log_inv_line;
3035:
3036: END IF;
3037: arp_standard.debug(' x_line_app :'||x_line_app);
3038: arp_standard.debug(' x_tax_app :'||x_tax_app);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3035:
3036: END IF;
3037: arp_standard.debug(' x_line_app :'||x_line_app);
3038: arp_standard.debug(' x_tax_app :'||x_tax_app);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3036: END IF;
3037: arp_standard.debug(' x_line_app :'||x_line_app);
3038: arp_standard.debug(' x_tax_app :'||x_tax_app);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3037: arp_standard.debug(' x_line_app :'||x_line_app);
3038: arp_standard.debug(' x_tax_app :'||x_tax_app);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3038: arp_standard.debug(' x_tax_app :'||x_tax_app);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3039: arp_standard.debug(' x_freight_app :'||x_freight_app);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3040: arp_standard.debug(' x_charges_app :'||x_charges_app);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3041: arp_standard.debug(' x_line_ed :'||x_line_ed);
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3049: arp_standard.debug('get_latest_amount_applied -');
3042: arp_standard.debug(' x_tax_ed :'||x_tax_ed);
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3049: arp_standard.debug('get_latest_amount_applied -');
3050: EXCEPTION
3043: arp_standard.debug(' x_freight_ed :'||x_freight_ed);
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3049: arp_standard.debug('get_latest_amount_applied -');
3050: EXCEPTION
3051: WHEN OTHERS THEN
3044: arp_standard.debug(' x_charges_ed :'||x_charges_ed);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3049: arp_standard.debug('get_latest_amount_applied -');
3050: EXCEPTION
3051: WHEN OTHERS THEN
3052: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3045: arp_standard.debug(' x_line_uned :'||x_line_uned);
3046: arp_standard.debug(' x_tax_uned :'||x_tax_uned);
3047: arp_standard.debug(' x_freight_uned :'||x_freight_uned);
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3049: arp_standard.debug('get_latest_amount_applied -');
3050: EXCEPTION
3051: WHEN OTHERS THEN
3052: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3053: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3048: arp_standard.debug(' x_charges_uned :'||x_charges_uned);
3049: arp_standard.debug('get_latest_amount_applied -');
3050: EXCEPTION
3051: WHEN OTHERS THEN
3052: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3053: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3054: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_applied-'||SQLERRM );
3055: FND_MSG_PUB.ADD;
3056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3146: l_sum_uned_line NUMBER;
3147: l_sum_uned_tax NUMBER;
3148: i NUMBER := 0;
3149: BEGIN
3150: arp_standard.debug('verif_int_adj_line_tax +');
3151: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3152: arp_standard.debug(' p_line_flag :'||p_line_flag);
3153: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3154:
3147: l_sum_uned_tax NUMBER;
3148: i NUMBER := 0;
3149: BEGIN
3150: arp_standard.debug('verif_int_adj_line_tax +');
3151: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3152: arp_standard.debug(' p_line_flag :'||p_line_flag);
3153: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3154:
3155: IF p_gt_id IS NULL THEN
3148: i NUMBER := 0;
3149: BEGIN
3150: arp_standard.debug('verif_int_adj_line_tax +');
3151: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3152: arp_standard.debug(' p_line_flag :'||p_line_flag);
3153: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3154:
3155: IF p_gt_id IS NULL THEN
3156: x_return_status := fnd_api.g_ret_sts_error;
3149: BEGIN
3150: arp_standard.debug('verif_int_adj_line_tax +');
3151: arp_standard.debug(' adjustment_id :'||p_adj_rec.adjustment_id);
3152: arp_standard.debug(' p_line_flag :'||p_line_flag);
3153: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3154:
3155: IF p_gt_id IS NULL THEN
3156: x_return_status := fnd_api.g_ret_sts_error;
3157: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3153: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3154:
3155: IF p_gt_id IS NULL THEN
3156: x_return_status := fnd_api.g_ret_sts_error;
3157: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3158: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3159: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3160: FND_MSG_PUB.ADD;
3161: ELSE
3164: OR
3165: ((p_adj_rec.amount = 0 ) AND (p_adj_rec.acctd_amount = 0 ))
3166: THEN
3167: x_return_status := fnd_api.g_ret_sts_error;
3168: arp_standard.debug(' Adjustment record amount and accounted amount causes no need to execute');
3169: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3170: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record amount and accounted amount causes no need to execute');
3171: FND_MSG_PUB.ADD;
3172: ELSIF ((p_adj_rec.amount IS NULL) AND (p_adj_rec.acctd_amount IS NOT NULL))
3176: ((p_adj_rec.amount <> p_adj_rec.acctd_amount) AND
3177: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3178: THEN
3179: x_return_status := fnd_api.g_ret_sts_error;
3180: arp_standard.debug(' Adjustment record combination causes an invalid combination');
3181: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3182: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record combination causes an invalid combination');
3183: FND_MSG_PUB.ADD;
3184: END IF;
3187: FETCH verif_amt INTO l_sum_line ,
3188: l_sum_tax ;
3189: CLOSE verif_amt;
3190:
3191: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3192: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3193:
3194: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3195: THEN
3188: l_sum_tax ;
3189: CLOSE verif_amt;
3190:
3191: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3192: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3193:
3194: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3195: THEN
3196: x_return_status := fnd_api.g_ret_sts_error;
3193:
3194: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3195: THEN
3196: x_return_status := fnd_api.g_ret_sts_error;
3197: arp_standard.debug(' There is no line amount and tax amount in the interface table for this adjustment');
3198: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3199: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount and tax amount in the interface table for adjustment -'||
3200: ' adjustment_id : ' || p_adj_rec.adjustment_id);
3201: END IF;
3202:
3203:
3204: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3205: x_return_status := fnd_api.g_ret_sts_error;
3206: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3207: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3208: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3209: FND_MSG_PUB.ADD;
3210: END IF;
3210: END IF;
3211:
3212: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3213: x_return_status := fnd_api.g_ret_sts_error;
3214: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3215: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3216: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3217: FND_MSG_PUB.ADD;
3218: END IF;
3217: FND_MSG_PUB.ADD;
3218: END IF;
3219:
3220: END IF;
3221: arp_standard.debug('verif_int_adj_line_tax -');
3222: END;
3223:
3224:
3225: PROCEDURE verif_int_app_line_tax
3255: l_sum_uned_line NUMBER;
3256: l_sum_uned_tax NUMBER;
3257: i NUMBER := 0;
3258: BEGIN
3259: arp_standard.debug('verif_int_app_line_tax +');
3260: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3256: l_sum_uned_tax NUMBER;
3257: i NUMBER := 0;
3258: BEGIN
3259: arp_standard.debug('verif_int_app_line_tax +');
3260: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3257: i NUMBER := 0;
3258: BEGIN
3259: arp_standard.debug('verif_int_app_line_tax +');
3260: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3258: BEGIN
3259: arp_standard.debug('verif_int_app_line_tax +');
3260: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3259: arp_standard.debug('verif_int_app_line_tax +');
3260: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3260: arp_standard.debug(' receivable_application_id :'||p_app_rec.receivable_application_id);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3261: arp_standard.debug(' p_app_rec.amount_applied :'||p_app_rec.amount_applied);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3269: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3262: arp_standard.debug(' p_app_rec.acctd_amount_applied_to :'||p_app_rec.acctd_amount_applied_to);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3269: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3270: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3263: arp_standard.debug(' p_customer_trx.invoice_currency_code:'||p_customer_trx.invoice_currency_code);
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3269: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3270: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3271:
3264: arp_standard.debug(' p_ae_sys_rec.base_currency :'||p_ae_sys_rec.base_currency);
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3269: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3270: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3271:
3272: IF p_gt_id IS NULL THEN
3265: arp_standard.debug(' p_line_flag :'||p_line_flag);
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3269: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3270: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3271:
3272: IF p_gt_id IS NULL THEN
3273: x_return_status := fnd_api.g_ret_sts_error;
3266: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3267: arp_standard.debug(' p_ed_line_flag :'||p_ed_line_flag);
3268: arp_standard.debug(' p_ed_tax_flag :'||p_ed_tax_flag);
3269: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3270: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3271:
3272: IF p_gt_id IS NULL THEN
3273: x_return_status := fnd_api.g_ret_sts_error;
3274: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3270: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3271:
3272: IF p_gt_id IS NULL THEN
3273: x_return_status := fnd_api.g_ret_sts_error;
3274: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3275: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3276: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3277: FND_MSG_PUB.ADD;
3278: ELSE
3281: OR
3282: ((p_app_rec.amount_applied = 0 ) AND (p_app_rec.acctd_amount_applied_to = 0 ))
3283: THEN
3284: x_return_status := fnd_api.g_ret_sts_error;
3285: arp_standard.debug(' Application record amount and accounted amount to causes no need to execute'||
3286: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3287: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3288: FND_MESSAGE.SET_TOKEN('TEXT',' Application record amount and accounted amount to causes no need to execute'||
3289: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3295: ((p_app_rec.amount_applied <> p_app_rec.acctd_amount_applied_to) AND
3296: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3297: THEN
3298: x_return_status := fnd_api.g_ret_sts_error;
3299: arp_standard.debug(' Application record combination causes an invalid combination on amount bucket');
3300: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3301: FND_MESSAGE.SET_TOKEN('TEXT',' Application record combination causes an invalid combination');
3302: FND_MSG_PUB.ADD;
3303: END IF;
3310: l_sum_uned_line ,
3311: l_sum_uned_tax ;
3312: CLOSE verif_amt;
3313:
3314: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3311: l_sum_uned_tax ;
3312: CLOSE verif_amt;
3313:
3314: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3312: CLOSE verif_amt;
3313:
3314: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3313:
3314: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3314: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3319: arp_standard.debug(' l_sum_uned_line :'||l_sum_uned_line);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3327: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3320: arp_standard.debug(' l_sum_uned_tax :'||l_sum_uned_tax);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3327: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3328: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3321:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3327: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3328: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3329:
3322: arp_standard.debug('RECORD p_app_rec ');
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3327: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3328: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3329:
3330:
3323: arp_standard.debug(' p_app_rec.line_applied :'||p_app_rec.line_applied);
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3327: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3328: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3329:
3330:
3331: IF (l_sum_line = NULL) AND (l_sum_tax = NULL ) AND
3324: arp_standard.debug(' p_app_rec.tax_applied :'||p_app_rec.tax_applied);
3325: arp_standard.debug(' p_app_rec.LINE_EDISCOUNTED :'||p_app_rec.LINE_EDISCOUNTED);
3326: arp_standard.debug(' p_app_rec.TAX_EDISCOUNTED :'||p_app_rec.TAX_EDISCOUNTED);
3327: arp_standard.debug(' p_app_rec.LINE_UEDISCOUNTED :'||p_app_rec.LINE_UEDISCOUNTED);
3328: arp_standard.debug(' p_app_rec.TAX_UEDISCOUNTED :'||p_app_rec.TAX_UEDISCOUNTED);
3329:
3330:
3331: IF (l_sum_line = NULL) AND (l_sum_tax = NULL ) AND
3332: (l_sum_ed_line = NULL) AND (l_sum_ed_tax = NULL ) AND
3332: (l_sum_ed_line = NULL) AND (l_sum_ed_tax = NULL ) AND
3333: (l_sum_uned_line = NULL) AND (l_sum_uned_tax = NULL )
3334: THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3336: arp_standard.debug(' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application');
3337: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3338: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application'||
3339: ' receivable_application_id : ' || p_app_rec.receivable_application_id);
3340: END IF;
3341:
3342:
3343: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3344: x_return_status := fnd_api.g_ret_sts_error;
3345: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3346: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3347: 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');
3348: FND_MSG_PUB.ADD;
3349: END IF;
3349: END IF;
3350:
3351: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3352: x_return_status := fnd_api.g_ret_sts_error;
3353: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3354: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3355: 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');
3356: FND_MSG_PUB.ADD;
3357: END IF;
3357: END IF;
3358:
3359: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: 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');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: 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');
3364: FND_MSG_PUB.ADD;
3365: END IF;
3365: END IF;
3366:
3367: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3368: x_return_status := fnd_api.g_ret_sts_error;
3369: 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');
3370: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3371: 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');
3372: FND_MSG_PUB.ADD;
3373: END IF;
3373: END IF;
3374:
3375: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3376: x_return_status := fnd_api.g_ret_sts_error;
3377: 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');
3378: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3379: 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');
3380: FND_MSG_PUB.ADD;
3381: END IF;
3381: END IF;
3382:
3383: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3384: x_return_status := fnd_api.g_ret_sts_error;
3385: 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');
3386: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3387: 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');
3388: FND_MSG_PUB.ADD;
3389: END IF;
3388: FND_MSG_PUB.ADD;
3389: END IF;
3390:
3391: END IF;
3392: arp_standard.debug('verif_int_app_line_tax -');
3393: END;
3394:
3395:
3396:
3415: IS
3416: l_denom number;
3417: begin
3418:
3419: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3420: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3421: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3422: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3423: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3416: l_denom number;
3417: begin
3418:
3419: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3420: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3421: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3422: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3423: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3424:
3417: begin
3418:
3419: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3420: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3421: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3422: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3423: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3424:
3425: l_denom := tot_earned_discount_in + tot_unearned_discount_in;
3418:
3419: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3420: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3421: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3422: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3423: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3424:
3425: l_denom := tot_earned_discount_in + tot_unearned_discount_in;
3426:
3419: arp_standard.debug ('llc brk dsc lin in= ' || lin_discount_in);
3420: arp_standard.debug ('llc brk dsc tax in= ' || tax_discount_in);
3421: arp_standard.debug ('llc brk dsc frt in= ' || frt_discount_in);
3422: arp_standard.debug ('llc brk dsc ed in= ' || tot_earned_discount_in);
3423: arp_standard.debug ('llc brk dsc ued in= ' || tot_unearned_discount_in);
3424:
3425: l_denom := tot_earned_discount_in + tot_unearned_discount_in;
3426:
3427: if l_denom <> 0 then
3434: ed_frt_out := (frt_discount_in / l_denom) * tot_earned_discount_in;
3435: ued_frt_out := frt_discount_in - ed_frt_out;
3436:
3437: end if;
3438: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3439: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3440: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3441: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3442: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3435: ued_frt_out := frt_discount_in - ed_frt_out;
3436:
3437: end if;
3438: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3439: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3440: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3441: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3442: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3443: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3436:
3437: end if;
3438: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3439: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3440: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3441: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3442: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3443: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3444:
3437: end if;
3438: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3439: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3440: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3441: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3442: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3443: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3444:
3445: END breakup_discounts;
3438: arp_standard.debug ('llc ed_lin_out '||ed_lin_out );
3439: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3440: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3441: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3442: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3443: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3444:
3445: END breakup_discounts;
3446:
3439: arp_standard.debug ('llc ued_lin_out '||ued_lin_out );
3440: arp_standard.debug ('llc ed_tax_out '||ed_tax_out );
3441: arp_standard.debug ('llc ued_tax_out '||ued_tax_out );
3442: arp_standard.debug ('llc ed_frt_out '||ed_frt_out );
3443: arp_standard.debug ('llc ued_frt_out '||ued_frt_out );
3444:
3445: END breakup_discounts;
3446:
3447: