43:
44: begin
45:
46: arp_util.debug('ARP_APP_CALC_PKG: GET_RULE_SET_ID()+');
47: select nvl(rule_set_id,nvl(arp_standard.sysparm.rule_set_id,-1))
48: into l_rule_set_id
49: from ra_cust_trx_types
50: where cust_trx_type_id = p_trx_type_id ;
51:
225:
226: begin
227:
228: IF PG_DEBUG in ('Y', 'C') THEN
229: arp_standard.debug('ARP_APP_CALC_PKG.extract_taxes()+');
230: END IF;
231:
232: if amt < (line_remaining + tax_remaining) then
233:
231:
232: if amt < (line_remaining + tax_remaining) then
233:
234: IF PG_DEBUG in ('Y', 'C') THEN
235: arp_standard.debug('extract_taxes: ' || 'partial');
236: END IF;
237:
238: if tax_treatment = 'PRORATE' then
239: if ((tax_remaining+line_remaining) <> 0) then
240: l_tax_applied := arpcurr.currround((tax_remaining*amt/(tax_remaining+line_remaining)),currency);
241: end if;
242: line_applied := amt - l_tax_applied;
243: IF PG_DEBUG in ('Y', 'C') THEN
244: arp_standard.debug('extract_taxes: ' || '.. PRORATE : line_applied = ' || to_char(line_applied));
245: arp_standard.debug('extract_taxes: ' || ' l_tax_applied = ' || to_char(l_tax_applied));
246: END IF;
247:
248: elsif tax_treatment = 'BEFORE' then
241: end if;
242: line_applied := amt - l_tax_applied;
243: IF PG_DEBUG in ('Y', 'C') THEN
244: arp_standard.debug('extract_taxes: ' || '.. PRORATE : line_applied = ' || to_char(line_applied));
245: arp_standard.debug('extract_taxes: ' || ' l_tax_applied = ' || to_char(l_tax_applied));
246: END IF;
247:
248: elsif tax_treatment = 'BEFORE' then
249: if (amt > tax_remaining) then
286:
287: tax_applied := l_tax_applied;
288:
289: IF PG_DEBUG in ('Y', 'C') THEN
290: arp_standard.debug('ARP_APP_CALC_PKG.extract_taxes()-');
291: END IF;
292:
293: EXCEPTION
294: WHEN OTHERS THEN
405:
406: begin
407:
408: IF PG_DEBUG in ('Y', 'C') THEN
409: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining()+ ');
410: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
406: begin
407:
408: IF PG_DEBUG in ('Y', 'C') THEN
409: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining()+ ');
410: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
414: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_applied '||to_char(l_line_applied));
407:
408: IF PG_DEBUG in ('Y', 'C') THEN
409: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining()+ ');
410: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
414: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_applied '||to_char(l_line_applied));
415: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_tax_applied '||to_char(l_line_tax_applied));
408: IF PG_DEBUG in ('Y', 'C') THEN
409: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining()+ ');
410: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
414: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_applied '||to_char(l_line_applied));
415: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_tax_applied '||to_char(l_line_tax_applied));
416: END IF;
409: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining()+ ');
410: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
414: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_applied '||to_char(l_line_applied));
415: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_tax_applied '||to_char(l_line_tax_applied));
416: END IF;
417:
410: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
414: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_applied '||to_char(l_line_applied));
415: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_tax_applied '||to_char(l_line_tax_applied));
416: END IF;
417:
418: -- Checking for negative values.
411: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
412: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
413: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
414: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_applied '||to_char(l_line_applied));
415: arp_standard.debug('calc_applied_and_remaining: ' || ' ..l_line_tax_applied '||to_char(l_line_tax_applied));
416: END IF;
417:
418: -- Checking for negative values.
419: -- Rule source only expects +ve values , so values will have to be
618: charges_tax_applied := sign(amt) * abs(l_charges_tax_applied);
619:
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('done with ARP_APP_CALC_PKG.calc_applied_and_remaining()-');
623: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
619:
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('done with ARP_APP_CALC_PKG.calc_applied_and_remaining()-');
623: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
627: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_applied '||to_char(line_applied));
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('done with ARP_APP_CALC_PKG.calc_applied_and_remaining()-');
623: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
627: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_applied '||to_char(line_applied));
628: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_applied '||to_char(line_tax_applied));
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('done with ARP_APP_CALC_PKG.calc_applied_and_remaining()-');
623: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
627: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_applied '||to_char(line_applied));
628: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_applied '||to_char(line_tax_applied));
629: END IF;
622: arp_standard.debug('done with ARP_APP_CALC_PKG.calc_applied_and_remaining()-');
623: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
627: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_applied '||to_char(line_applied));
628: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_applied '||to_char(line_tax_applied));
629: END IF;
630:
623: arp_standard.debug('calc_applied_and_remaining: ' || ' ..amount applied '||to_char(amt));
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
627: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_applied '||to_char(line_applied));
628: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_applied '||to_char(line_tax_applied));
629: END IF;
630:
631: EXCEPTION
624: arp_standard.debug('calc_applied_and_remaining: ' || ' ..currency '||currency);
625: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_remaining '||to_char(line_remaining));
626: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_remaining '||to_char(line_tax_remaining));
627: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_applied '||to_char(line_applied));
628: arp_standard.debug('calc_applied_and_remaining: ' || ' ..line_tax_applied '||to_char(line_tax_applied));
629: END IF;
630:
631: EXCEPTION
632: WHEN OTHERS THEN
774: l_freight_tax_applied number:=0;
775: l_charges_tax_applied number:=0;
776:
777: BEGIN
778: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining() Wrapper +');
779:
780: /*
781: * gjayanth: Bug 772847: When CM is applied to CB, payment
782: * schedule's line_remaining was not getting updated correctly.
786: p_line_tax_remaining := nvl(p_line_tax_remaining, 0);
787: p_freight_remaining := nvl(p_freight_remaining, 0);
788: p_charges_remaining := nvl(p_charges_remaining, 0);
789:
790: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
791: arp_standard.debug(' .. p_created_from = ' || p_created_from);
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
787: p_freight_remaining := nvl(p_freight_remaining, 0);
788: p_charges_remaining := nvl(p_charges_remaining, 0);
789:
790: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
791: arp_standard.debug(' .. p_created_from = ' || p_created_from);
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
795: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
788: p_charges_remaining := nvl(p_charges_remaining, 0);
789:
790: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
791: arp_standard.debug(' .. p_created_from = ' || p_created_from);
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
795: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
796: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
789:
790: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
791: arp_standard.debug(' .. p_created_from = ' || p_created_from);
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
795: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
796: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
797:
790: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
791: arp_standard.debug(' .. p_created_from = ' || p_created_from);
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
795: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
796: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
797:
798: /* Save original values */
791: arp_standard.debug(' .. p_created_from = ' || p_created_from);
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
795: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
796: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
797:
798: /* Save original values */
799: l_org_line_remaining := p_line_remaining;
792: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
793: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
794: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
795: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
796: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
797:
798: /* Save original values */
799: l_org_line_remaining := p_line_remaining;
800: l_org_line_tax_remaining := p_line_tax_remaining;
906: l_mixed_sign_count := l_ms_use_line + l_ms_use_line_tax +
907: l_ms_use_freight + l_ms_use_freight_tax +
908: l_ms_use_charges + l_ms_use_charges_tax;
909:
910: arp_standard.debug(' l_mixed_sign_count = ' || to_char(l_mixed_sign_count));
911: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
912: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
913: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
914: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
907: l_ms_use_freight + l_ms_use_freight_tax +
908: l_ms_use_charges + l_ms_use_charges_tax;
909:
910: arp_standard.debug(' l_mixed_sign_count = ' || to_char(l_mixed_sign_count));
911: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
912: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
913: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
914: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
915: arp_standard.debug(' l_ms_use_charges = ' || to_char(l_ms_use_charges) ||
909:
910: arp_standard.debug(' l_mixed_sign_count = ' || to_char(l_mixed_sign_count));
911: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
912: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
913: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
914: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
915: arp_standard.debug(' l_ms_use_charges = ' || to_char(l_ms_use_charges) ||
916: ' l_ms_use_charges_tax = ' || to_char(l_ms_use_charges_tax));
917:
911: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
912: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
913: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
914: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
915: arp_standard.debug(' l_ms_use_charges = ' || to_char(l_ms_use_charges) ||
916: ' l_ms_use_charges_tax = ' || to_char(l_ms_use_charges_tax));
917:
918: /*
919: * If all amounts had sign same as p_amt, l_mixed_sign_count = 6.
1063: l_freight_tax_applied := l_ms_applied_freight_tax + l_nonms_applied_freight_tax ;
1064: p_charges_applied := l_ms_applied_charges + l_nonms_applied_charges ;
1065: l_charges_tax_applied := l_ms_applied_charges_tax + l_nonms_applied_charges_tax ;
1066:
1067: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1068: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1064: p_charges_applied := l_ms_applied_charges + l_nonms_applied_charges ;
1065: l_charges_tax_applied := l_ms_applied_charges_tax + l_nonms_applied_charges_tax ;
1066:
1067: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1068: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1065: l_charges_tax_applied := l_ms_applied_charges_tax + l_nonms_applied_charges_tax ;
1066:
1067: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1068: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1073: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1066:
1067: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1068: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1073: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1074:
1067: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1068: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1073: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1074:
1075: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1068: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1073: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1074:
1075: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1076:
1069: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1070: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1073: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1074:
1075: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1076:
1077: EXCEPTION
1071: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1072: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1073: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1074:
1075: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1076:
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: arp_util.debug('EXCEPTION: ARP_APP_CALC_PKG.calc_applied_and_remaining: Wrapper: '||SQLERRM);