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
772: l_freight_tax_applied number:=0;
773: l_charges_tax_applied number:=0;
774:
775: BEGIN
776: arp_standard.debug('ARP_APP_CALC_PKG.calc_applied_and_remaining() Wrapper +');
777:
778: /*
779: * gjayanth: Bug 772847: When CM is applied to CB, payment
780: * schedule's line_remaining was not getting updated correctly.
784: p_line_tax_remaining := nvl(p_line_tax_remaining, 0);
785: p_freight_remaining := nvl(p_freight_remaining, 0);
786: p_charges_remaining := nvl(p_charges_remaining, 0);
787:
788: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
789: arp_standard.debug(' .. p_created_from = ' || p_created_from);
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
785: p_freight_remaining := nvl(p_freight_remaining, 0);
786: p_charges_remaining := nvl(p_charges_remaining, 0);
787:
788: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
789: arp_standard.debug(' .. p_created_from = ' || p_created_from);
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
793: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
786: p_charges_remaining := nvl(p_charges_remaining, 0);
787:
788: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
789: arp_standard.debug(' .. p_created_from = ' || p_created_from);
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
793: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
794: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
787:
788: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
789: arp_standard.debug(' .. p_created_from = ' || p_created_from);
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
793: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
794: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
795:
788: arp_standard.debug('in calc_applied_and_remaining Wrapper, debug');
789: arp_standard.debug(' .. p_created_from = ' || p_created_from);
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
793: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
794: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
795:
796: /* Save original values */
789: arp_standard.debug(' .. p_created_from = ' || p_created_from);
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
793: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
794: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
795:
796: /* Save original values */
797: l_org_line_remaining := p_line_remaining;
790: arp_standard.debug(' .. p_line_remaining = ' || to_char(p_line_remaining));
791: arp_standard.debug(' .. p_line_tax_remaining = ' || to_char(p_line_tax_remaining));
792: arp_standard.debug(' .. p_freight_remaining = ' || to_char(p_freight_remaining));
793: arp_standard.debug(' .. p_charges_remaining = ' || to_char(p_charges_remaining));
794: arp_standard.debug(' .. p_amt = ' || to_char(p_amt));
795:
796: /* Save original values */
797: l_org_line_remaining := p_line_remaining;
798: l_org_line_tax_remaining := p_line_tax_remaining;
902: l_mixed_sign_count := l_ms_use_line + l_ms_use_line_tax +
903: l_ms_use_freight + l_ms_use_freight_tax +
904: l_ms_use_charges + l_ms_use_charges_tax;
905:
906: arp_standard.debug(' l_mixed_sign_count = ' || to_char(l_mixed_sign_count));
907: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
908: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
909: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
910: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
903: l_ms_use_freight + l_ms_use_freight_tax +
904: l_ms_use_charges + l_ms_use_charges_tax;
905:
906: arp_standard.debug(' l_mixed_sign_count = ' || to_char(l_mixed_sign_count));
907: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
908: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
909: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
910: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
911: arp_standard.debug(' l_ms_use_charges = ' || to_char(l_ms_use_charges) ||
905:
906: arp_standard.debug(' l_mixed_sign_count = ' || to_char(l_mixed_sign_count));
907: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
908: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
909: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
910: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
911: arp_standard.debug(' l_ms_use_charges = ' || to_char(l_ms_use_charges) ||
912: ' l_ms_use_charges_tax = ' || to_char(l_ms_use_charges_tax));
913:
907: arp_standard.debug(' l_ms_use_line = ' || to_char(l_ms_use_line) ||
908: ' l_ms_use_line_tax = ' || to_char(l_ms_use_line_tax));
909: arp_standard.debug(' l_ms_use_freight = ' || to_char(l_ms_use_freight) ||
910: ' l_ms_use_freight_tax = ' || to_char(l_ms_use_freight_tax));
911: arp_standard.debug(' l_ms_use_charges = ' || to_char(l_ms_use_charges) ||
912: ' l_ms_use_charges_tax = ' || to_char(l_ms_use_charges_tax));
913:
914: /*
915: * If all amounts had sign same as p_amt, l_mixed_sign_count = 6.
1053: l_freight_tax_applied := l_ms_applied_freight_tax + l_nonms_applied_freight_tax ;
1054: p_charges_applied := l_ms_applied_charges + l_nonms_applied_charges ;
1055: l_charges_tax_applied := l_ms_applied_charges_tax + l_nonms_applied_charges_tax ;
1056:
1057: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1058: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1054: p_charges_applied := l_ms_applied_charges + l_nonms_applied_charges ;
1055: l_charges_tax_applied := l_ms_applied_charges_tax + l_nonms_applied_charges_tax ;
1056:
1057: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1058: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1055: l_charges_tax_applied := l_ms_applied_charges_tax + l_nonms_applied_charges_tax ;
1056:
1057: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1058: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1063: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1056:
1057: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1058: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1063: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1064:
1057: arp_standard.debug('done calc_applied_and_remaining Wrapper, debug');
1058: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1063: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1064:
1065: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1058: arp_standard.debug(' .. p_line_applied = ' || to_char(l_ms_applied_line + l_nonms_applied_line));
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1063: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1064:
1065: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1066:
1059: arp_standard.debug(' .. p_line_tax_applied = ' || to_char(l_ms_applied_line_tax + l_nonms_applied_line_tax));
1060: arp_standard.debug(' .. p_freight_applied = ' || to_char(l_ms_applied_freight + l_nonms_applied_freight));
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1063: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1064:
1065: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1066:
1067: EXCEPTION
1061: arp_standard.debug(' .. l_freight_tax_applied = ' || to_char(l_ms_applied_freight_tax + l_nonms_applied_freight_tax));
1062: arp_standard.debug(' .. p_charges_applied = ' || to_char(l_ms_applied_charges + l_nonms_applied_charges));
1063: arp_standard.debug(' .. l_charges_tax_applied = ' || to_char(l_ms_applied_charges_tax + l_nonms_applied_charges_tax));
1064:
1065: arp_standard.debug('calc_applied_and_remaining() Wrapper -');
1066:
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: arp_util.debug('EXCEPTION: ARP_APP_CALC_PKG.calc_applied_and_remaining: Wrapper: '||SQLERRM);
1283:
1284: begin
1285:
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_standard.debug('ARP_APP_CALC_PKG.COMPILE_RULE()+');
1288: END IF;
1289:
1290: for rulerec in rules loop
1291: l_doc_source := '/* Rule Set Name : ' || rulerec.rule_set_name ||'
1710:
1711: end if;
1712:
1713: IF PG_DEBUG in ('Y', 'C') THEN
1714: arp_standard.debug('ARP_APP_CALC_PKG.COMPILE_RULE()-');
1715: END IF;
1716:
1717: EXCEPTION
1718: WHEN OTHERS THEN