eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VARIABLE_AMOUNT_PKG

Line 1: PACKAGE BODY pn_variable_amount_pkg AS

1: PACKAGE BODY pn_variable_amount_pkg AS
2: -- $Header: PNVRAMTB.pls 120.13.12010000.2 2009/05/28 07:20:29 jsundara ship $
3:
4: /* Declare all the appropriate cursors to get actual/forecasted volume
5: history */

Line 253: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (+) ');

249: AND lines.line_item_id = NVL(ip_line_item_id,lines.line_item_id);
250:
251: BEGIN
252:
253: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (+) ');
254:
255: pnp_debug_pkg.log('process_variable_rent - Cumulative : '||p_cumulative);
256: pnp_debug_pkg.log('process_variable_rent - Invoice On : '||p_invoice_on);
257:

Line 297: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (-) ');

293: p_period_id => p_period_id,
294: p_var_rent_id => p_var_rent_id);
295:
296:
297: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (-) ');
298:
299: END process_variable_rent;
300:
301:

Line 355: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (+) ');

351: l_min_grp_date DATE;
352:
353: BEGIN
354:
355: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (+) ');
356:
357:
358: /* get the Breakpoint info. For the line item */
359:

Line 504: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (-) ');

500:
501: END IF;
502:
503:
504: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (-) ');
505:
506: END process_calculate_TYPE;
507:
508:

Line 536: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (+) ');

532: j NUMBER := 0;
533:
534: BEGIN
535:
536: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (+) ');
537:
538:
539: /* Get the percent days open for the group date*/
540:

Line 639: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (-) ');

635: P_CUMULATIVE => p_cumulative);
636:
637:
638:
639: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (-) ');
640:
641: END calculate_var_rent;
642:
643:

Line 671: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (+) ');

667: l_rent NUMBER := 0;
668: i NUMBER := 0;
669: BEGIN
670:
671: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (+) ');
672:
673:
674: IF p_cumulative = 'N' AND
675: p_net_volume < (bkpt_range_tbl(1).group_bkpt_vol_start * p_percent_days_open)

Line 799: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (-) ');

795: END IF;
796: END IF;
797: RETURN l_rent;
798:
799: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (-) ');
800:
801: END get_rent_applicable;
802:
803:

Line 849: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (+) ');

845: AND group_date < p_group_date;
846:
847: BEGIN
848:
849: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (+) ');
850:
851: /* insert into PL/SQL table invoice_tbl all the invoices dates
852: for the period for which rent has been calculated. Info
853: needed to update pn_var_Rent_inv table for the new amounts */

Line 975: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (-) ');

971: END IF;
972:
973:
974:
975: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (-) ');
976:
977: EXCEPTION
978: when others then
979: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 979: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

975: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (-) ');
976:
977: EXCEPTION
978: when others then
979: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
980: raise;
981:
982: END process_rent;
983:

Line 1062: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (+) ');

1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;
1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;
1060:
1061: BEGIN
1062: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (+) ');
1063:
1064: if g_invoice_on = 'FORECASTED' AND g_rent_TYPE = 'ACTUAL' then
1065: l_rent_TYPE := 'VARIANCE';
1066: elsif g_invoice_on = 'FORECASTED' AND g_rent_TYPE = 'FORECASTED' then

Line 1229: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (-)');

1225:
1226:
1227: END LOOP; -- invoice_tbl
1228:
1229: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (-)');
1230:
1231: EXCEPTION
1232: when others then
1233: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.Insert_invoice :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 1233: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.Insert_invoice :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

1229: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (-)');
1230:
1231: EXCEPTION
1232: when others then
1233: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.Insert_invoice :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
1234: raise;
1235:
1236: END Insert_invoice;
1237:

Line 1352: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (+) :');

1348: l_prev_invoiced_amt NUMBER;
1349: l_rec_abatement NUMBER := 0;
1350:
1351: BEGIN
1352: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (+) :');
1353:
1354:
1355: OPEN csr_get_abt(p_var_rent_id);
1356: FETCH csr_get_abt into l_total_abatement,l_negative_rent_flag;

Line 1518: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (-):');

1514:
1515:
1516: END LOOP;
1517:
1518: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (-):');
1519:
1520: EXCEPTION
1521: when others then
1522: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.apply_abatements :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 1522: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.apply_abatements :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

1518: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (-):');
1519:
1520: EXCEPTION
1521: when others then
1522: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.apply_abatements :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
1523: raise;
1524:
1525: END apply_abatements;
1526:

Line 1549: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (+) ');

1545: l_upper_bound NUMBER;
1546: l_constr_act_rent NUMBER;
1547:
1548: BEGIN
1549: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (+) ');
1550:
1551: FOR rec_get_constr in csr_get_constr(p_period_id)
1552: LOOP
1553: IF rec_get_constr.TYPE_code = 'MIN' THEN

Line 1577: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');

1573:
1574: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
1575:
1576: RETURN l_constr_act_rent;
1577: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
1578: END apply_constraints;
1579:
1580: -----------------------------------------------------------------------------
1581: -- FUNCTION : find_varrent_exists

Line 1596: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (+) ');

1592: l_varrent_exists VARCHAR2(1) := 'N';
1593:
1594: BEGIN
1595:
1596: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (+) ');
1597:
1598: SELECT 'Y'
1599: INTO l_varrent_exists
1600: FROM dual

Line 1612: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (-) ');

1608: EXCEPTION
1609: WHEN no_data_found
1610: THEN RETURN 'N';
1611:
1612: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (-) ');
1613:
1614: END find_varrent_exists;
1615:
1616:

Line 1629: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (+) ');

1625: p_forecasted_flag OUT NOCOPY VARCHAR2,
1626: p_variance_flag OUT NOCOPY VARCHAR2)
1627: IS
1628: BEGIN
1629: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (+) ');
1630:
1631: SELECT distinct actual_exp_code,forecasted_exp_code,variance_exp_code
1632: INTO p_actual_flag,p_forecasted_flag,p_variance_flag
1633: FROM pn_var_grp_dates_all

Line 1639: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_transferred_flag :'||

1635: AND invoice_date = p_invoice_date;
1636:
1637: EXCEPTION
1638: WHEN no_data_found then null;
1639: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_transferred_flag :'||
1640: TO_CHAR(sqlcode)||': '||sqlerrm);
1641:
1642: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (-) ');
1643:

Line 1642: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (-) ');

1638: WHEN no_data_found then null;
1639: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_transferred_flag :'||
1640: TO_CHAR(sqlcode)||': '||sqlerrm);
1641:
1642: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (-) ');
1643:
1644: END get_transferred_flag;
1645:
1646:

Line 1665: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (+) ');

1661: l_no_of_days NUMBER;
1662: i NUMBER :=0;
1663:
1664: BEGIN
1665: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (+) ');
1666:
1667: /* Initialize the PL/SQL table */
1668: grd_date_tbl.delete;
1669:

Line 1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');

1700: pnp_debug_pkg.log('get_percent_open - l_proration_factor : '||l_proration_factor);
1701:
1702: END LOOP;
1703:
1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');
1705:
1706: EXCEPTION
1707: when others then
1708: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.get_percent_open :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 1708: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.get_percent_open :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');
1705:
1706: EXCEPTION
1707: when others then
1708: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.get_percent_open :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
1709:
1710: END get_percent_open;
1711:
1712:

Line 1726: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (+) ');

1722: i NUMBER :=0;
1723:
1724: BEGIN
1725:
1726: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (+) ');
1727:
1728: /* Initialize the PL/SQL table */
1729: deduction_tbl.delete;
1730:

Line 1742: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (-) ');

1738: deduction_tbl(i).deduction_amt := rec_get_ded.deduction_amt;
1739:
1740: END LOOP;
1741:
1742: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (-) ');
1743:
1744: END get_deductions;
1745:
1746:

Line 1763: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (+) ');

1759: i NUMBER :=0;
1760:
1761: BEGIN
1762:
1763: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (+) ');
1764:
1765: /* Initialize the PL/SQL table */
1766: bkpt_range_tbl.delete;
1767:

Line 1784: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (-) ');

1780:
1781:
1782: END LOOP;
1783:
1784: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (-) ');
1785:
1786: END get_bkp_details;
1787:
1788:

Line 1803: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (+) ');

1799: IS
1800: i NUMBER := 1;
1801: BEGIN
1802:
1803: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (+) ');
1804:
1805: /* Get the existing cumulative actual AND forecasted volume for all the
1806: group date prior to this group date AND put them in the
1807: p_act_cum_vol AND p_for_cum_vol */

Line 1821: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (-) ');

1817:
1818: END IF;
1819: END LOOP;
1820:
1821: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (-) ');
1822:
1823: END;
1824:
1825: ------------------------------------------------------------------------

Line 1846: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (+) ');

1842:
1843:
1844: BEGIN
1845:
1846: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (+) ');
1847:
1848: /* Initialize the PL/SQL table */
1849: cum_vol_tbl.delete;
1850:

Line 1892: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (-) ');

1888: END IF;
1889:
1890: END LOOP;
1891:
1892: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (-) ');
1893:
1894: END get_cumulative_volume;
1895:
1896:

Line 1910: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (+) ');

1906: p_negative_rent OUT NOCOPY VARCHAR2)
1907: IS
1908: BEGIN
1909:
1910: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (+) ');
1911:
1912: SELECT cumulative_vol,
1913: invoice_on,
1914: negative_rent

Line 1921: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (-) ');

1917: p_negative_rent
1918: FROM pn_var_rents_all
1919: WHERE var_rent_id = p_var_rent_id;
1920:
1921: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (-) ');
1922:
1923: END get_varrent_details;
1924:
1925: ------------------------------------------------------------------------------------

Line 1938: put_log( 'pn_variable_amount_pkg.find_if_term_exists (+): ');

1934: IS
1935: l_term_exists VARCHAR2(1) := 'N';
1936: BEGIN
1937:
1938: put_log( 'pn_variable_amount_pkg.find_if_term_exists (+): ');
1939:
1940: /* pinky - codev */
1941: IF p_var_rent_type IN ('ADJUSTMENT') THEN
1942:

Line 1969: put_log( 'pn_variable_amount_pkg.find_if_term_exists (-): ');

1965: EXCEPTION
1966: WHEN no_data_found then
1967: RETURN 'N';
1968:
1969: put_log( 'pn_variable_amount_pkg.find_if_term_exists (-): ');
1970:
1971: END find_if_term_exists;
1972:
1973:

Line 1990: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (+) : ');

1986: IS
1987: l_volume_exists VARCHAR2(1) := 'N';
1988:
1989: BEGIN
1990: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (+) : ');
1991:
1992: SELECT 'Y'
1993: INTO l_volume_exists
1994: FROM dual

Line 2019: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (-) : ');

2015: EXCEPTION
2016: WHEN no_data_found then
2017: RETURN 'N';
2018:
2019: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (-) : ');
2020: END find_volume_exists;
2021:
2022: ----------------------------------------------------------------------------
2023: -- FUNCTION : get_prior_transfer_flag

Line 2091: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (+) : ');

2087: l_period_id NUMBER;
2088: l_cur_period_id NUMBER := NULL;
2089:
2090: BEGIN
2091: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (+) : ');
2092:
2093:
2094: FOR rec IN period_cur LOOP
2095: l_period_id := rec.period_id;

Line 2121: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (-) : ');

2117: END IF;
2118:
2119: RETURN l_exists;
2120:
2121: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (-) : ');
2122:
2123: END get_prior_transfer_flag;
2124:
2125: ----------------------------------------------------------------------------

Line 2147: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (+) : ');

2143: l_prev_inv_amt NUMBER := 0;
2144:
2145: BEGIN
2146:
2147: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (+) : ');
2148:
2149: OPEN csr_prev_inv_amt(p_var_rent_id,p_invoice_date,p_adjust_num);
2150: FETCH csr_prev_inv_amt INTO l_prev_inv_amt;
2151: CLOSE csr_prev_inv_amt;

Line 2155: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (-) : ');

2151: CLOSE csr_prev_inv_amt;
2152:
2153: RETURN l_prev_inv_amt;
2154:
2155: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (-) : ');
2156:
2157: END get_prev_inv_amt;
2158:
2159: -------------------------------------------------------------------------------------------------

Line 2204: put_log('pn_variable_amount_pkg.get_vol_ded (+) : ');

2200: l_ret_val NUMBER ;
2201:
2202: BEGIN
2203:
2204: put_log('pn_variable_amount_pkg.get_vol_ded (+) : ');
2205: OPEN csr_vol(p_line_item_id,p_group_date);
2206: FETCH csr_vol into l_tot_act_vol,l_tot_for_vol,l_tot_ded,l_cumulative_vol;
2207: IF csr_vol%NOTFOUND THEN
2208: RETURN 0;

Line 2244: put_log('pn_variable_amount_pkg.get_vol_ded (-) : ');

2240: END IF;
2241:
2242: RETURN NVL(l_ret_val,0);
2243:
2244: put_log('pn_variable_amount_pkg.get_vol_ded (-) : ');
2245:
2246: EXCEPTION
2247: when others then
2248: put_log('Error in pn_variable_amount_pkg.get_vol_ded :'||to_char(sqlcode)||' : '||sqlerrm);

Line 2248: put_log('Error in pn_variable_amount_pkg.get_vol_ded :'||to_char(sqlcode)||' : '||sqlerrm);

2244: put_log('pn_variable_amount_pkg.get_vol_ded (-) : ');
2245:
2246: EXCEPTION
2247: when others then
2248: put_log('Error in pn_variable_amount_pkg.get_vol_ded :'||to_char(sqlcode)||' : '||sqlerrm);
2249:
2250: END get_vol_ded;
2251:
2252: -------------------------------------------------------------------------------

Line 2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );

2388: /* l_global_rec pn_mo_cache_utils.GlobalsRecord; */
2389:
2390:
2391: BEGIN
2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );
2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));
2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);

Line 2552: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent_batch :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

2548:
2549: EXCEPTION
2550:
2551: When OTHERS Then
2552: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent_batch :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
2553: Errbuf := SQLERRM;
2554: Retcode := 2;
2555: rollback;
2556: raise;

Line 2558: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (-) ');

2554: Retcode := 2;
2555: rollback;
2556: raise;
2557:
2558: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (-) ');
2559: END process_rent_batch;
2560:
2561:
2562: ----------------------------------------------------------------------------

Line 2638: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (+) ');

2634: l_var_exp_code pn_var_rent_inv.variance_exp_code%TYPE := null;
2635: l_var_rent_inv_id pn_var_rent_inv.var_rent_inv_id%TYPE;
2636:
2637: BEGIN
2638: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (+) ');
2639:
2640: /* Does a row exist in pn_var_rent_SUMm for grp_date_id AND line_item_id */
2641: l_varrent_exists := find_varrent_exists(
2642: p_line_item_id => p_line_item_id,

Line 2710: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_vol_hist : '||TO_CHAR(sqlcode)||' : '||sqlerrm);

2706:
2707: EXCEPTION
2708:
2709: When OTHERS Then
2710: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_vol_hist : '||TO_CHAR(sqlcode)||' : '||sqlerrm);
2711: rollback;
2712: raise;
2713:
2714: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (-) ');

Line 2714: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (-) ');

2710: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_vol_hist : '||TO_CHAR(sqlcode)||' : '||sqlerrm);
2711: rollback;
2712: raise;
2713:
2714: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (-) ');
2715:
2716: END process_vol_hist;
2717:
2718: ----------------------------------------------------------------------------

Line 2731: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (+) ');

2727:
2728: l_msg varchar2(200) := null;
2729:
2730: BEGIN
2731: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (+) ');
2732:
2733: IF p_calc is not null THEN
2734: IF p_adj is not null AND p_rec is not null THEN
2735: l_msg := p_calc||', '||p_adj||' AND '||p_rec||' processes';

Line 2757: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (-) ');

2753: END IF;
2754:
2755: RETURN l_msg;
2756:
2757: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (-) ');
2758: END get_msg;
2759:
2760: ----------------------------------------------------------------------------
2761: -- FUNCTION : get_prorated_bkpt

Line 2783: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (+) :');

2779: RETURN NUMBER IS
2780: l_pror_bkpt NUMBER := null;
2781: l_no_of_days NUMBER := null;
2782: BEGIN
2783: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (+) :');
2784: IF NVL(p_cumulative,'N') = 'Y' THEN
2785: l_no_of_days := (p_per_end_dt - p_per_st_dt) + 1;
2786: l_pror_bkpt := (l_no_of_days/p_pror_factor) * p_per_bkpt;
2787: ELSE

Line 2791: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (-) :');

2787: ELSE
2788: l_no_of_days := (p_grp_end_dt - p_grp_st_dt) + 1;
2789: l_pror_bkpt := (l_no_of_days/p_pror_factor) * p_grp_bkpt;
2790: END IF;
2791: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (-) :');
2792: RETURN l_pror_bkpt;
2793:
2794: END get_prorated_bkpt;
2795:

Line 2812: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (+) :');

2808: l_actual_invoiced_amount pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
2809: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE := 0;
2810:
2811: BEGIN
2812: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (+) :');
2813:
2814: l_constr_actual_rent := p_constr_actual_rent;
2815:
2816: IF (p_constr_actual_rent < 0 AND p_negative_rent_flag in('DEFER','IGNORE')) THEN

Line 2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);

2816: IF (p_constr_actual_rent < 0 AND p_negative_rent_flag in('DEFER','IGNORE')) THEN
2817: l_constr_actual_rent := 0;
2818: END IF;
2819:
2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);
2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);
2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);

Line 2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);

2817: l_constr_actual_rent := 0;
2818: END IF;
2819:
2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);
2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);
2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);
2825:

Line 2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);

2818: END IF;
2819:
2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);
2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);
2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);
2825:
2826: pnp_debug_pkg.log('pn_variable_amount_pkg - l_actual_invoiced_amount '||l_actual_invoiced_amount);

Line 2826: pnp_debug_pkg.log('pn_variable_amount_pkg - l_actual_invoiced_amount '||l_actual_invoiced_amount);

2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);
2825:
2826: pnp_debug_pkg.log('pn_variable_amount_pkg - l_actual_invoiced_amount '||l_actual_invoiced_amount);
2827:
2828: IF l_actual_invoiced_amount > 0 THEN
2829: l_rec_abatement := NVL(p_rec_abatement_override,p_rec_abatement); /* 8285964 */
2830: --LEAST(l_actual_invoiced_amount,p_rec_abatement));

Line 2835: pnp_debug_pkg.log('pn_variable_amount_pkg - l_rec_abatement '||l_rec_abatement);

2831: ELSE
2832: l_rec_abatement := p_rec_abatement_override;
2833: END IF;
2834:
2835: pnp_debug_pkg.log('pn_variable_amount_pkg - l_rec_abatement '||l_rec_abatement);
2836:
2837: l_actual_invoiced_amount := l_actual_invoiced_amount - NVL(l_rec_abatement,0) ;
2838:
2839: RETURN l_actual_invoiced_amount;

Line 2841: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (-) :');

2837: l_actual_invoiced_amount := l_actual_invoiced_amount - NVL(l_rec_abatement,0) ;
2838:
2839: RETURN l_actual_invoiced_amount;
2840:
2841: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (-) :');
2842:
2843: END derive_actual_invoiced_amt;
2844:
2845: ----------------------------------------------------------------------------

Line 2901: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (+) ');

2897: AND true_up_amt IS NOT NULL -- Bug # 5991106
2898: );
2899:
2900: BEGIN
2901: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (+) ');
2902: IF p_true_up_flag = 'N' THEN
2903: FOR rec IN get_aprvd_cur(p_period_id, p_invoice_date )LOOP
2904: p_actual_flag := rec.actual_exp_code;
2905: p_forecasted_flag := rec.forecasted_exp_code;

Line 2919: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_approved_flag :'||

2915:
2916:
2917:
2918: EXCEPTION
2919: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_approved_flag :'||
2920: TO_CHAR(sqlcode)||': '||sqlerrm);
2921:
2922: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (-) ');
2923:

Line 2922: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (-) ');

2918: EXCEPTION
2919: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_approved_flag :'||
2920: TO_CHAR(sqlcode)||': '||sqlerrm);
2921:
2922: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (-) ');
2923:
2924: END get_approved_flag;
2925:
2926:

Line 2927: END pn_variable_amount_pkg;

2923:
2924: END get_approved_flag;
2925:
2926:
2927: END pn_variable_amount_pkg;
2928: