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_VAR_RENT_CALC_PKG dependencies on PNP_DEBUG_PKG

Line 602: pnp_debug_pkg.log('++++ get_rent_applicable - START ++++');

598: l_period_num NUMBER := 0;
599:
600: BEGIN
601:
602: pnp_debug_pkg.log('++++ get_rent_applicable - START ++++');
603:
604: IF NVL(p_trx_hdr_rec.invoice_flag, 'Y') = 'N' THEN
605: RETURN;
606: END IF;

Line 650: pnp_debug_pkg.log(l_context||' COMPLETE - net Volume: '||l_net_volume);

646: l_net_volume := (l_trx_hdr_rec.ytd_sales - NVL(l_trx_hdr_rec.ytd_deductions,0));
647:
648: END IF;
649:
650: pnp_debug_pkg.log(l_context||' COMPLETE - net Volume: '||l_net_volume);
651:
652:
653: /* --------------------- GET calculated_rent START --------------------- */
654: /* handling the case of volume not tripping any bkpts */

Line 675: pnp_debug_pkg.log('No volumes tripped.');

671: (g_proration_rule = pn_var_rent_calc_pkg.G_PRORUL_CYNP AND
672: l_net_volume < l_bkpts_t(1).pr_grp_blended_vol_start))
673: THEN
674:
675: pnp_debug_pkg.log('No volumes tripped.');
676: pnp_debug_pkg.log('l_net_volume:'||l_net_volume);
677: pnp_debug_pkg.log
678: ('l_bkpts_t(1).prorated_grp_vol_start:'||l_bkpts_t(1).prorated_grp_vol_start);
679: /* Once no breakpoints are tripped, Macerich consider the rent to be = 0 */

Line 676: pnp_debug_pkg.log('l_net_volume:'||l_net_volume);

672: l_net_volume < l_bkpts_t(1).pr_grp_blended_vol_start))
673: THEN
674:
675: pnp_debug_pkg.log('No volumes tripped.');
676: pnp_debug_pkg.log('l_net_volume:'||l_net_volume);
677: pnp_debug_pkg.log
678: ('l_bkpts_t(1).prorated_grp_vol_start:'||l_bkpts_t(1).prorated_grp_vol_start);
679: /* Once no breakpoints are tripped, Macerich consider the rent to be = 0 */
680: IF (g_proration_rule IN ( pn_var_rent_calc_pkg.G_PRORUL_NP

Line 677: pnp_debug_pkg.log

673: THEN
674:
675: pnp_debug_pkg.log('No volumes tripped.');
676: pnp_debug_pkg.log('l_net_volume:'||l_net_volume);
677: pnp_debug_pkg.log
678: ('l_bkpts_t(1).prorated_grp_vol_start:'||l_bkpts_t(1).prorated_grp_vol_start);
679: /* Once no breakpoints are tripped, Macerich consider the rent to be = 0 */
680: IF (g_proration_rule IN ( pn_var_rent_calc_pkg.G_PRORUL_NP
681: ,pn_var_rent_calc_pkg.G_PRORUL_STD

Line 697: pnp_debug_pkg.log('l_trx_hdr_rec.calculated_rent'||l_trx_hdr_rec.calculated_rent);

693: := (l_net_volume - l_bkpts_t(1).pr_grp_blended_vol_start)
694: * l_bkpts_t(1).bkpt_rate;
695:
696: END IF;
697: pnp_debug_pkg.log('l_trx_hdr_rec.calculated_rent'||l_trx_hdr_rec.calculated_rent);
698:
699:
700: ELSE
701:

Line 857: pnp_debug_pkg.log(l_context||' COMPLETE ');

853: END IF; /* breakpoint type */
854:
855: END IF; /* volume trips breakpoint?? */
856:
857: pnp_debug_pkg.log(l_context||' COMPLETE ');
858:
859: /* ---------------------- GET calculated_rent END ---------------------- */
860:
861: /* at this point, we have the calculated rent

Line 876: pnp_debug_pkg.log('+++ Get Prorated Rent - START +++');

872: l_trx_hdr_rec.prorated_rent_due := 0;
873:
874: IF NVL(l_trx_hdr_rec.invoice_flag, 'Y') = 'I' THEN
875:
876: pnp_debug_pkg.log('+++ Get Prorated Rent - START +++');
877: pnp_debug_pkg.log('Invoice Flag: '||l_trx_hdr_rec.invoice_flag);
878:
879: IF g_proration_rule IN ( pn_var_rent_calc_pkg.G_PRORUL_FY
880: ,pn_var_rent_calc_pkg.G_PRORUL_FLY) AND

Line 877: pnp_debug_pkg.log('Invoice Flag: '||l_trx_hdr_rec.invoice_flag);

873:
874: IF NVL(l_trx_hdr_rec.invoice_flag, 'Y') = 'I' THEN
875:
876: pnp_debug_pkg.log('+++ Get Prorated Rent - START +++');
877: pnp_debug_pkg.log('Invoice Flag: '||l_trx_hdr_rec.invoice_flag);
878:
879: IF g_proration_rule IN ( pn_var_rent_calc_pkg.G_PRORUL_FY
880: ,pn_var_rent_calc_pkg.G_PRORUL_FLY) AND
881: ((ADD_MONTHS(g_vr_commencement_date, 12) - 1) BETWEEN

Line 885: pnp_debug_pkg.log('Get Prorated Rent - FY');

881: ((ADD_MONTHS(g_vr_commencement_date, 12) - 1) BETWEEN
882: l_trx_hdr_rec.calc_prd_start_date AND l_trx_hdr_rec.calc_prd_end_date)
883: THEN
884:
885: pnp_debug_pkg.log('Get Prorated Rent - FY');
886:
887: /* calculate FY prorated rent due */
888: FOR rec IN fy_sales_c
889: ( p_vr_id => l_trx_hdr_rec.var_rent_id

Line 1060: pnp_debug_pkg.log('Get Prorated Rent - LY');

1056: ,pn_var_rent_calc_pkg.G_PRORUL_FLY) AND
1057: g_vr_termination_date = l_trx_hdr_rec.calc_prd_end_date
1058: THEN
1059:
1060: pnp_debug_pkg.log('Get Prorated Rent - LY');
1061:
1062: /* calculate LY prorated rent due */
1063: /* set the calculated rent to 0 */
1064: l_trx_hdr_rec.calculated_rent := 0;

Line 1074: pnp_debug_pkg.log('Sales volume for LY: '||l_net_volume);

1070: LOOP
1071: l_net_volume := rec.sales;
1072: END LOOP;
1073:
1074: pnp_debug_pkg.log('Sales volume for LY: '||l_net_volume);
1075:
1076:
1077:
1078: /* get l_trx_hdr_rec.prorated_rent_due - PRORATED RENT */

Line 1084: pnp_debug_pkg.log('Get bkpt trips for');

1080: THEN
1081:
1082: l_trx_hdr_rec.prorated_rent_due := 0;
1083:
1084: pnp_debug_pkg.log('Get bkpt trips for');
1085: pnp_debug_pkg.log(' VR ID: '||l_trx_hdr_rec.var_rent_id);
1086: pnp_debug_pkg.log(' VR End Date: '|| g_vr_termination_date);
1087: pnp_debug_pkg.log(' Line Grp: '||l_trx_hdr_rec.line_item_group_id);
1088:

Line 1085: pnp_debug_pkg.log(' VR ID: '||l_trx_hdr_rec.var_rent_id);

1081:
1082: l_trx_hdr_rec.prorated_rent_due := 0;
1083:
1084: pnp_debug_pkg.log('Get bkpt trips for');
1085: pnp_debug_pkg.log(' VR ID: '||l_trx_hdr_rec.var_rent_id);
1086: pnp_debug_pkg.log(' VR End Date: '|| g_vr_termination_date);
1087: pnp_debug_pkg.log(' Line Grp: '||l_trx_hdr_rec.line_item_group_id);
1088:
1089: /* loop for all bkpt details */

Line 1086: pnp_debug_pkg.log(' VR End Date: '|| g_vr_termination_date);

1082: l_trx_hdr_rec.prorated_rent_due := 0;
1083:
1084: pnp_debug_pkg.log('Get bkpt trips for');
1085: pnp_debug_pkg.log(' VR ID: '||l_trx_hdr_rec.var_rent_id);
1086: pnp_debug_pkg.log(' VR End Date: '|| g_vr_termination_date);
1087: pnp_debug_pkg.log(' Line Grp: '||l_trx_hdr_rec.line_item_group_id);
1088:
1089: /* loop for all bkpt details */
1090: FOR bkpt_rec IN ly_bkpts_c

Line 1087: pnp_debug_pkg.log(' Line Grp: '||l_trx_hdr_rec.line_item_group_id);

1083:
1084: pnp_debug_pkg.log('Get bkpt trips for');
1085: pnp_debug_pkg.log(' VR ID: '||l_trx_hdr_rec.var_rent_id);
1086: pnp_debug_pkg.log(' VR End Date: '|| g_vr_termination_date);
1087: pnp_debug_pkg.log(' Line Grp: '||l_trx_hdr_rec.line_item_group_id);
1088:
1089: /* loop for all bkpt details */
1090: FOR bkpt_rec IN ly_bkpts_c
1091: ( p_vr_id => l_trx_hdr_rec.var_rent_id

Line 1103: pnp_debug_pkg.log('Bkpt trips - Start: '||l_bkpt_start||' End: '||l_bkpt_end);

1099: IF l_bkpt_end IS NULL OR l_bkpt_end = 0 THEN
1100: l_bkpt_end := NULL;
1101: END IF;
1102:
1103: pnp_debug_pkg.log('Bkpt trips - Start: '||l_bkpt_start||' End: '||l_bkpt_end);
1104:
1105: IF l_net_volume >= l_bkpt_start THEN
1106:
1107: IF l_net_volume <= NVL(l_bkpt_end, l_net_volume) THEN

Line 1121: pnp_debug_pkg.log('Prorated Rent Due: '||l_trx_hdr_rec.prorated_rent_due);

1117: + (l_bkpt_end - l_bkpt_start) * bkpt_rec.bkpt_rate;
1118:
1119: END IF;
1120:
1121: pnp_debug_pkg.log('Prorated Rent Due: '||l_trx_hdr_rec.prorated_rent_due);
1122:
1123: ELSE
1124:
1125: EXIT;

Line 1135: pnp_debug_pkg.log('l_bkpt_type:'||l_bkpt_type);

1131:
1132: ELSIF l_bkpt_type IN ( pn_var_rent_calc_pkg.G_BKPT_TYP_FLAT
1133: ,pn_var_rent_calc_pkg.G_BKPT_TYP_SLIDING)
1134: THEN
1135: pnp_debug_pkg.log('l_bkpt_type:'||l_bkpt_type);
1136: /* loop for all bkpt details */
1137: FOR bkpt_rec IN ly_bkpts_c
1138: ( p_vr_id => l_trx_hdr_rec.var_rent_id
1139: ,p_vr_term_date => g_vr_termination_date

Line 1145: pnp_debug_pkg.log('1:'||bkpt_rec.bkpt_start);

1141: LOOP
1142:
1143: l_bkpt_start := bkpt_rec.bkpt_start;
1144: l_bkpt_end := bkpt_rec.bkpt_end;
1145: pnp_debug_pkg.log('1:'||bkpt_rec.bkpt_start);
1146: pnp_debug_pkg.log('2:'||bkpt_rec.bkpt_end);
1147:
1148: IF l_bkpt_end IS NULL OR l_bkpt_end = 0 THEN
1149: l_bkpt_end := NULL;

Line 1146: pnp_debug_pkg.log('2:'||bkpt_rec.bkpt_end);

1142:
1143: l_bkpt_start := bkpt_rec.bkpt_start;
1144: l_bkpt_end := bkpt_rec.bkpt_end;
1145: pnp_debug_pkg.log('1:'||bkpt_rec.bkpt_start);
1146: pnp_debug_pkg.log('2:'||bkpt_rec.bkpt_end);
1147:
1148: IF l_bkpt_end IS NULL OR l_bkpt_end = 0 THEN
1149: l_bkpt_end := NULL;
1150: END IF;

Line 1245: pnp_debug_pkg.log('+++ Get Prorated Rent - END +++');

1241: END LOOP;
1242: */
1243: END IF; /* calculate FY rent OR LY rent? */
1244:
1245: pnp_debug_pkg.log('+++ Get Prorated Rent - END +++');
1246:
1247: END IF; /* invoice flag = I - means calculate prorated_rent_due */
1248:
1249: pnp_debug_pkg.log(l_context||' COMPLETE ');

Line 1249: pnp_debug_pkg.log(l_context||' COMPLETE ');

1245: pnp_debug_pkg.log('+++ Get Prorated Rent - END +++');
1246:
1247: END IF; /* invoice flag = I - means calculate prorated_rent_due */
1248:
1249: pnp_debug_pkg.log(l_context||' COMPLETE ');
1250:
1251: /* --------------------- GET prorated_rent_due END ---------------------- */
1252:
1253: /* ------------ GET percent_rent_due, ytd_percent_rent START ------------ */

Line 1280: pnp_debug_pkg.log(' get previously billed complete - l_prev_billed: '||l_prev_billed);

1276: ,p_reset_grp_id => l_trx_hdr_rec.reset_group_id);
1277:
1278: END IF;
1279:
1280: pnp_debug_pkg.log(' get previously billed complete - l_prev_billed: '||l_prev_billed);
1281:
1282: IF g_calculation_method IN ( pn_var_rent_calc_pkg.G_CALC_NON_CUMULATIVE
1283: ,pn_var_rent_calc_pkg.G_CALC_TRUE_UP)
1284: THEN

Line 1347: pnp_debug_pkg.log(' ');

1343:
1344: END IF;
1345:
1346:
1347: pnp_debug_pkg.log(' ');
1348: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);
1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);
1351: pnp_debug_pkg.log(' ');

Line 1348: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);

1344: END IF;
1345:
1346:
1347: pnp_debug_pkg.log(' ');
1348: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);
1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);
1351: pnp_debug_pkg.log(' ');
1352:

Line 1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);

1345:
1346:
1347: pnp_debug_pkg.log(' ');
1348: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);
1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);
1351: pnp_debug_pkg.log(' ');
1352:
1353: pnp_debug_pkg.log(l_context||' COMPLETE ');

Line 1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);

1346:
1347: pnp_debug_pkg.log(' ');
1348: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);
1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);
1351: pnp_debug_pkg.log(' ');
1352:
1353: pnp_debug_pkg.log(l_context||' COMPLETE ');
1354:

Line 1351: pnp_debug_pkg.log(' ');

1347: pnp_debug_pkg.log(' ');
1348: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);
1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);
1351: pnp_debug_pkg.log(' ');
1352:
1353: pnp_debug_pkg.log(l_context||' COMPLETE ');
1354:
1355: /* ------------- GET percent_rent_due, ytd_percent_rent END ------------- */

Line 1353: pnp_debug_pkg.log(l_context||' COMPLETE ');

1349: pnp_debug_pkg.log(' percent_rent_due_for: '||l_trx_hdr_rec.percent_rent_due);
1350: pnp_debug_pkg.log(' ytd_percent_rent_for: '||l_trx_hdr_rec.ytd_percent_rent);
1351: pnp_debug_pkg.log(' ');
1352:
1353: pnp_debug_pkg.log(l_context||' COMPLETE ');
1354:
1355: /* ------------- GET percent_rent_due, ytd_percent_rent END ------------- */
1356:
1357: l_trx_hdr_rec.update_flag := 'Y';

Line 1361: pnp_debug_pkg.log('++++ get_rent_applicable - END ++++');

1357: l_trx_hdr_rec.update_flag := 'Y';
1358:
1359: p_trx_hdr_rec := l_trx_hdr_rec;
1360:
1361: pnp_debug_pkg.log('++++ get_rent_applicable - END ++++');
1362:
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: pnp_debug_pkg.log

Line 1365: pnp_debug_pkg.log

1361: pnp_debug_pkg.log('++++ get_rent_applicable - END ++++');
1362:
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: pnp_debug_pkg.log
1366: ('**********************************************************************');
1367: pnp_debug_pkg.log('*** ERROR IN get_rent_applicable ***');
1368: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1369: pnp_debug_pkg.log

Line 1367: pnp_debug_pkg.log('* ERROR IN get_rent_applicable *');

1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: pnp_debug_pkg.log
1366: ('**********************************************************************');
1367: pnp_debug_pkg.log('*** ERROR IN get_rent_applicable ***');
1368: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1369: pnp_debug_pkg.log
1370: ('**********************************************************************');
1371: RAISE;

Line 1368: pnp_debug_pkg.log('* ERROR WHEN: '||l_context||' *');

1364: WHEN OTHERS THEN
1365: pnp_debug_pkg.log
1366: ('**********************************************************************');
1367: pnp_debug_pkg.log('*** ERROR IN get_rent_applicable ***');
1368: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1369: pnp_debug_pkg.log
1370: ('**********************************************************************');
1371: RAISE;
1372:

Line 1369: pnp_debug_pkg.log

1365: pnp_debug_pkg.log
1366: ('**********************************************************************');
1367: pnp_debug_pkg.log('*** ERROR IN get_rent_applicable ***');
1368: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
1369: pnp_debug_pkg.log
1370: ('**********************************************************************');
1371: RAISE;
1372:
1373: END get_rent_applicable;

Line 1455: pnp_debug_pkg.log('post_summary .....(+)');

1451: l_vr_summ_id NUMBER;
1452:
1453: BEGIN
1454:
1455: pnp_debug_pkg.log('post_summary .....(+)');
1456: /* get the invoice date for the group
1457: loops only once
1458: */
1459: FOR grp_rec IN grp_date_c( p_vr_id => p_var_rent_id

Line 1463: pnp_debug_pkg.log('grp_rec.invoice_date...'||grp_rec.invoice_date);

1459: FOR grp_rec IN grp_date_c( p_vr_id => p_var_rent_id
1460: ,p_prd_id => p_period_id
1461: ,p_grp_id => p_grp_date_id)
1462: LOOP
1463: pnp_debug_pkg.log('grp_rec.invoice_date...'||grp_rec.invoice_date);
1464: /* get the sum of rents and sales for
1465: vr -> period -> line item -> group combination
1466: from the trx tables
1467: loops only once

Line 1475: pnp_debug_pkg.log('summ_rec.rent...'||summ_rec.rent);

1471: ,p_line_id => p_line_item_id
1472: ,p_grp_id => p_grp_date_id)
1473: LOOP
1474:
1475: pnp_debug_pkg.log('summ_rec.rent...'||summ_rec.rent);
1476: pnp_debug_pkg.log('summ_rec.sales...'||summ_rec.sales);
1477: l_vr_summ_id := NULL;
1478:
1479: /* chk if VR SUMM record exists for this

Line 1476: pnp_debug_pkg.log('summ_rec.sales...'||summ_rec.sales);

1472: ,p_grp_id => p_grp_date_id)
1473: LOOP
1474:
1475: pnp_debug_pkg.log('summ_rec.rent...'||summ_rec.rent);
1476: pnp_debug_pkg.log('summ_rec.sales...'||summ_rec.sales);
1477: l_vr_summ_id := NULL;
1478:
1479: /* chk if VR SUMM record exists for this
1480: vr -> period -> line item -> group combination */

Line 1489: pnp_debug_pkg.log('l_vr_summ_id...'||l_vr_summ_id);

1485: LOOP
1486: l_vr_summ_id := vr_summ_rec.var_rent_summ_id;
1487: END LOOP;
1488:
1489: pnp_debug_pkg.log('l_vr_summ_id...'||l_vr_summ_id);
1490:
1491: IF l_vr_summ_id IS NULL THEN
1492:
1493: pnp_debug_pkg.log('inserting ...');

Line 1493: pnp_debug_pkg.log('inserting ...');

1489: pnp_debug_pkg.log('l_vr_summ_id...'||l_vr_summ_id);
1490:
1491: IF l_vr_summ_id IS NULL THEN
1492:
1493: pnp_debug_pkg.log('inserting ...');
1494: /* to insert a new summary record */
1495: INSERT INTO
1496: pn_var_rent_summ_all
1497: (var_rent_summ_id

Line 1538: pnp_debug_pkg.log('updating ...');

1534:
1535: ELSIF l_vr_summ_id IS NOT NULL THEN
1536: /* update the summary record */
1537:
1538: pnp_debug_pkg.log('updating ...');
1539: UPDATE
1540: pn_var_rent_summ_all
1541: SET
1542: tot_act_vol = summ_rec.sales

Line 1639: pnp_debug_pkg.log('+++++++++ post_summary_firstyr START +++++++++++');

1635: l_line_item_id NUMBER;
1636:
1637: BEGIN
1638:
1639: pnp_debug_pkg.log('+++++++++ post_summary_firstyr START +++++++++++');
1640:
1641:
1642: FOR first_period_rec IN first_period_cur LOOP
1643: l_period_id := first_period_rec.period_id;

Line 1646: pnp_debug_pkg.log('first year period id... '||l_period_id);

1642: FOR first_period_rec IN first_period_cur LOOP
1643: l_period_id := first_period_rec.period_id;
1644: END LOOP;
1645:
1646: pnp_debug_pkg.log('first year period id... '||l_period_id);
1647: /* get the first year rent for this vr agreement */
1648: FOR vr_summ_fy_rec IN vr_summ_fy_c LOOP
1649:
1650: l_vr_summ_id := NULL;

Line 1740: pnp_debug_pkg.log('+++++++++ post_summary_firstyr END +++++++++++');

1736: EXIT;
1737:
1738: END LOOP;
1739:
1740: pnp_debug_pkg.log('+++++++++ post_summary_firstyr END +++++++++++');
1741:
1742: END post_summary_firstyr;
1743:
1744: --------------------------------------------------------------------------------

Line 1860: pnp_debug_pkg.log('+++++++++ insert_invoice_firstyr START +++++++++++');

1856: l_tot_act_vol NUMBER := 0;
1857: l_precision NUMBER;
1858: BEGIN
1859:
1860: pnp_debug_pkg.log('+++++++++ insert_invoice_firstyr START +++++++++++');
1861:
1862: FOR vr_rec IN org_c(p_vr_id => p_var_rent_id) LOOP
1863: l_org_id := vr_rec.org_id;
1864: l_vr_commencement_date := vr_rec.commencement_date;

Line 1867: pnp_debug_pkg.log('l_precision:'||l_precision);

1863: l_org_id := vr_rec.org_id;
1864: l_vr_commencement_date := vr_rec.commencement_date;
1865: END LOOP;
1866: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(l_org_id),4);
1867: pnp_debug_pkg.log('l_precision:'||l_precision);
1868: FOR first_period_rec IN first_period_cur(p_vr_id => p_var_rent_id) LOOP
1869: l_period_id := first_period_rec.period_id;
1870: END LOOP;
1871:

Line 1872: pnp_debug_pkg.log('first year period id... '||l_period_id);

1868: FOR first_period_rec IN first_period_cur(p_vr_id => p_var_rent_id) LOOP
1869: l_period_id := first_period_rec.period_id;
1870: END LOOP;
1871:
1872: pnp_debug_pkg.log('first year period id... '||l_period_id);
1873:
1874: /* loop for all invoice dates in the period */
1875: FOR inv_rec IN invoice_dates_c( p_vr_id => p_var_rent_id)
1876: LOOP

Line 1919: pnp_debug_pkg.log('l_exists_invoice...');

1915: EXIT;
1916:
1917: END LOOP; /* check if there exists an invoice for this invoice date */
1918:
1919: pnp_debug_pkg.log('l_exists_invoice...');
1920: /* atleast one invoice exists? */
1921: IF NOT l_exists_invoice
1922: AND round(inv_rec.total_actual_rent, l_precision) <> 0 THEN
1923:

Line 1933: pnp_debug_pkg.log('inserting the row ...');

1929: p_period_id => l_period_id,
1930: p_invoice_date => inv_rec.invoice_date,
1931: p_actual_rent => inv_rec.total_actual_rent);
1932:
1933: pnp_debug_pkg.log('inserting the row ...');
1934: /* first time for this invoice date - create invoice */
1935: pn_var_rent_inv_pkg.insert_row
1936: ( x_rowid => l_row_id,
1937: x_var_rent_inv_id => l_var_rent_inv_id,

Line 1998: pnp_debug_pkg.log('l_constr_rent:'||l_constr_rent);

1994: p_invoice_date => inv_rec.invoice_date,
1995: p_actual_rent => inv_rec.total_actual_rent);
1996: /* no invoice to update - create a new one */
1997: IF l_var_rent_inv_id IS NULL THEN
1998: pnp_debug_pkg.log('l_constr_rent:'||l_constr_rent);
1999: pnp_debug_pkg.log('l_constr_rent:'||l_constr_prev_rent);
2000: /* if there a change in rent */
2001: IF round(inv_rec.total_actual_rent, l_precision) <> round(l_prev_inv_rent, l_precision)
2002: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)

Line 1999: pnp_debug_pkg.log('l_constr_rent:'||l_constr_prev_rent);

1995: p_actual_rent => inv_rec.total_actual_rent);
1996: /* no invoice to update - create a new one */
1997: IF l_var_rent_inv_id IS NULL THEN
1998: pnp_debug_pkg.log('l_constr_rent:'||l_constr_rent);
1999: pnp_debug_pkg.log('l_constr_rent:'||l_constr_prev_rent);
2000: /* if there a change in rent */
2001: IF round(inv_rec.total_actual_rent, l_precision) <> round(l_prev_inv_rent, l_precision)
2002: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)
2003: THEN

Line 2091: pnp_debug_pkg.log('+++++++++ insert_invoice END +++++++++++');

2087: END IF; /* IF NOT l_exists_invoice THEN */
2088:
2089: END LOOP; /* loop for all invoice dates in the period */
2090:
2091: pnp_debug_pkg.log('+++++++++ insert_invoice END +++++++++++');
2092:
2093: EXCEPTION
2094: WHEN OTHERS THEN RAISE;
2095:

Line 2234: pnp_debug_pkg.log('+++++++++ insert_invoice START (+) +++++++++++');

2230: l_period_id NUMBER;
2231: l_precision NUMBER;
2232: BEGIN
2233:
2234: pnp_debug_pkg.log('+++++++++ insert_invoice START (+) +++++++++++');
2235:
2236: FOR vr_rec IN org_c(p_vr_id => p_var_rent_id) LOOP
2237: l_org_id := vr_rec.org_id;
2238: l_vr_termination_date := vr_rec.termination_date;

Line 2242: pnp_debug_pkg.log('l_precision:'||l_precision);

2238: l_vr_termination_date := vr_rec.termination_date;
2239: END LOOP;
2240:
2241: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(l_org_id),4);
2242: pnp_debug_pkg.log('l_precision:'||l_precision);
2243:
2244: /* loop for all invoice dates in the period */
2245: FOR inv_rec IN invoice_dates_c( p_vr_id => p_var_rent_id
2246: ,p_prd_id => p_period_id

Line 2249: pnp_debug_pkg.log('inv_rec.invoice_date ...'||inv_rec.invoice_date);

2245: FOR inv_rec IN invoice_dates_c( p_vr_id => p_var_rent_id
2246: ,p_prd_id => p_period_id
2247: ,p_new_termn_date => l_vr_termination_date)
2248: LOOP
2249: pnp_debug_pkg.log('inv_rec.invoice_date ...'||inv_rec.invoice_date);
2250: pnp_debug_pkg.log('inv_rec.total_actual_rent ...'||inv_rec.total_actual_rent);
2251:
2252: l_row_id := NULL;
2253: l_var_rent_inv_id := NULL;

Line 2250: pnp_debug_pkg.log('inv_rec.total_actual_rent ...'||inv_rec.total_actual_rent);

2246: ,p_prd_id => p_period_id
2247: ,p_new_termn_date => l_vr_termination_date)
2248: LOOP
2249: pnp_debug_pkg.log('inv_rec.invoice_date ...'||inv_rec.invoice_date);
2250: pnp_debug_pkg.log('inv_rec.total_actual_rent ...'||inv_rec.total_actual_rent);
2251:
2252: l_row_id := NULL;
2253: l_var_rent_inv_id := NULL;
2254: l_max_adjust_num := 0;

Line 2404: pnp_debug_pkg.log('l_constr_rent:'||l_constr_rent);

2400: p_actual_rent => inv_rec.total_actual_rent);
2401:
2402: /* no invoice to update - create a new one */
2403: IF l_var_rent_inv_id IS NULL THEN
2404: pnp_debug_pkg.log('l_constr_rent:'||l_constr_rent);
2405: pnp_debug_pkg.log('l_constr_rent:'||l_constr_prev_rent);
2406: /* if there a change in rent */
2407: IF round(inv_rec.total_actual_rent, l_precision) <> round(l_prev_inv_rent, l_precision)
2408: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)

Line 2405: pnp_debug_pkg.log('l_constr_rent:'||l_constr_prev_rent);

2401:
2402: /* no invoice to update - create a new one */
2403: IF l_var_rent_inv_id IS NULL THEN
2404: pnp_debug_pkg.log('l_constr_rent:'||l_constr_rent);
2405: pnp_debug_pkg.log('l_constr_rent:'||l_constr_prev_rent);
2406: /* if there a change in rent */
2407: IF round(inv_rec.total_actual_rent, l_precision) <> round(l_prev_inv_rent, l_precision)
2408: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)
2409: THEN

Line 2495: pnp_debug_pkg.log('l_prev_inv_exp_rent:'||l_prev_inv_exp_rent);

2491:
2492: END IF; /* IF l_var_rent_inv_id IS NULL THEN */
2493:
2494: END IF; /* IF NOT l_exists_invoice THEN */
2495: pnp_debug_pkg.log('l_prev_inv_exp_rent:'||l_prev_inv_exp_rent);
2496:
2497: END LOOP; /* loop for all invoice dates in the period */
2498:
2499: pnp_debug_pkg.log('+++++++++ insert_invoice END +++++++++++');

Line 2499: pnp_debug_pkg.log('+++++++++ insert_invoice END +++++++++++');

2495: pnp_debug_pkg.log('l_prev_inv_exp_rent:'||l_prev_inv_exp_rent);
2496:
2497: END LOOP; /* loop for all invoice dates in the period */
2498:
2499: pnp_debug_pkg.log('+++++++++ insert_invoice END +++++++++++');
2500:
2501: EXCEPTION
2502: WHEN OTHERS THEN RAISE;
2503:

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

2538: l_upper_bound NUMBER;
2539: l_constr_act_rent NUMBER;
2540:
2541: BEGIN
2542: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (+) ');
2543:
2544: FOR rec_get_constr in csr_get_constr(p_period_id)
2545: LOOP
2546: IF rec_get_constr.TYPE_code = 'MIN' THEN

Line 2555: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);

2551: END LOOP;
2552:
2553: /* Apply constraints to Actual variable rent */
2554:
2555: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
2556: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
2557: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
2558:
2559: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN

Line 2556: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);

2552:
2553: /* Apply constraints to Actual variable rent */
2554:
2555: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
2556: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
2557: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
2558:
2559: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN
2560: l_constr_act_rent := l_lower_bound;

Line 2557: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);

2553: /* Apply constraints to Actual variable rent */
2554:
2555: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
2556: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
2557: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
2558:
2559: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN
2560: l_constr_act_rent := l_lower_bound;
2561: ELSIF p_actual_rent > NVL(l_upper_bound,p_actual_rent) THEN

Line 2567: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);

2563: ELSE
2564: l_constr_act_rent := p_actual_rent;
2565: END IF;
2566:
2567: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
2568:
2569: RETURN l_constr_act_rent;
2570: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
2571: END apply_constraints;

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

2566:
2567: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
2568:
2569: RETURN l_constr_act_rent;
2570: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
2571: END apply_constraints;
2572:
2573: --------------------------------------------------------------------------------
2574: -- NAME : apply_constraints_fy

Line 2606: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints_fy : (+) ');

2602: l_upper_bound NUMBER;
2603: l_constr_act_rent NUMBER;
2604:
2605: BEGIN
2606: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints_fy : (+) ');
2607: pnp_debug_pkg.log('p_period_id'||p_period_id);
2608: FOR rec_get_constr in csr_get_constr(p_period_id)
2609: LOOP
2610: IF rec_get_constr.TYPE_code = 'MIN' THEN

Line 2607: pnp_debug_pkg.log('p_period_id'||p_period_id);

2603: l_constr_act_rent NUMBER;
2604:
2605: BEGIN
2606: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints_fy : (+) ');
2607: pnp_debug_pkg.log('p_period_id'||p_period_id);
2608: FOR rec_get_constr in csr_get_constr(p_period_id)
2609: LOOP
2610: IF rec_get_constr.TYPE_code = 'MIN' THEN
2611: l_lower_bound := rec_get_constr.amount;

Line 2619: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);

2615: END LOOP;
2616:
2617: /* Apply constraints to Actual variable rent */
2618:
2619: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
2620: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
2621: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
2622:
2623: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN

Line 2620: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);

2616:
2617: /* Apply constraints to Actual variable rent */
2618:
2619: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
2620: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
2621: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
2622:
2623: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN
2624: l_constr_act_rent := l_lower_bound;

Line 2621: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);

2617: /* Apply constraints to Actual variable rent */
2618:
2619: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
2620: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
2621: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
2622:
2623: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN
2624: l_constr_act_rent := l_lower_bound;
2625: ELSIF p_actual_rent > NVL(l_upper_bound,p_actual_rent) THEN

Line 2631: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);

2627: ELSE
2628: l_constr_act_rent := p_actual_rent;
2629: END IF;
2630:
2631: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
2632:
2633: RETURN l_constr_act_rent;
2634: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
2635: END apply_constraints_fy;

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

2630:
2631: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
2632:
2633: RETURN l_constr_act_rent;
2634: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
2635: END apply_constraints_fy;
2636:
2637:
2638: /***************Procedures to apply abatements***********/

Line 2736: pnp_debug_pkg.log('apply_abatements start(+)');

2732: 2. Apply allowances/Abatements.
2733: 3. Apply/Allowances/Abatements.
2734: */
2735: --
2736: pnp_debug_pkg.log('apply_abatements start(+)');
2737: pnp_debug_pkg.log('p_flag:'||p_flag);
2738: FOR rec IN order_c(p_var_rent_id) LOOP
2739: l_abat_order := rec.ORDER_OF_APPL_CODE;
2740: l_vr_termination_date := rec.termination_date;

Line 2737: pnp_debug_pkg.log('p_flag:'||p_flag);

2733: 3. Apply/Allowances/Abatements.
2734: */
2735: --
2736: pnp_debug_pkg.log('apply_abatements start(+)');
2737: pnp_debug_pkg.log('p_flag:'||p_flag);
2738: FOR rec IN order_c(p_var_rent_id) LOOP
2739: l_abat_order := rec.ORDER_OF_APPL_CODE;
2740: l_vr_termination_date := rec.termination_date;
2741: END LOOP;

Line 2744: pnp_debug_pkg.log('called apply_def_neg_rent');

2740: l_vr_termination_date := rec.termination_date;
2741: END LOOP;
2742: --
2743: FOR inv_rec IN inv_c(p_var_rent_id, p_period_id, l_vr_termination_date) LOOP
2744: pnp_debug_pkg.log('called apply_def_neg_rent');
2745: pn_var_rent_calc_pkg.apply_def_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2746: pnp_debug_pkg.log('complete');
2747: IF (l_abat_order = pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2748: pnp_debug_pkg.log('call pnp_debug_pkg.log');

Line 2746: pnp_debug_pkg.log('complete');

2742: --
2743: FOR inv_rec IN inv_c(p_var_rent_id, p_period_id, l_vr_termination_date) LOOP
2744: pnp_debug_pkg.log('called apply_def_neg_rent');
2745: pn_var_rent_calc_pkg.apply_def_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2746: pnp_debug_pkg.log('complete');
2747: IF (l_abat_order = pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2748: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2749: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2750: pnp_debug_pkg.log('complete');

Line 2748: pnp_debug_pkg.log('call pnp_debug_pkg.log');

2744: pnp_debug_pkg.log('called apply_def_neg_rent');
2745: pn_var_rent_calc_pkg.apply_def_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2746: pnp_debug_pkg.log('complete');
2747: IF (l_abat_order = pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2748: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2749: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2750: pnp_debug_pkg.log('complete');
2751: END IF;--Apply allowance.
2752:

Line 2750: pnp_debug_pkg.log('complete');

2746: pnp_debug_pkg.log('complete');
2747: IF (l_abat_order = pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2748: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2749: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2750: pnp_debug_pkg.log('complete');
2751: END IF;--Apply allowance.
2752:
2753: pnp_debug_pkg.log('call populate_abat');
2754: pn_var_rent_calc_pkg.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);

Line 2753: pnp_debug_pkg.log('call populate_abat');

2749: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2750: pnp_debug_pkg.log('complete');
2751: END IF;--Apply allowance.
2752:
2753: pnp_debug_pkg.log('call populate_abat');
2754: pn_var_rent_calc_pkg.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);
2755: pnp_debug_pkg.log('complete');
2756:
2757: pnp_debug_pkg.log('call apply_abat');

Line 2755: pnp_debug_pkg.log('complete');

2751: END IF;--Apply allowance.
2752:
2753: pnp_debug_pkg.log('call populate_abat');
2754: pn_var_rent_calc_pkg.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);
2755: pnp_debug_pkg.log('complete');
2756:
2757: pnp_debug_pkg.log('call apply_abat');
2758: pn_var_rent_calc_pkg.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2759: pnp_debug_pkg.log('complete');

Line 2757: pnp_debug_pkg.log('call apply_abat');

2753: pnp_debug_pkg.log('call populate_abat');
2754: pn_var_rent_calc_pkg.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);
2755: pnp_debug_pkg.log('complete');
2756:
2757: pnp_debug_pkg.log('call apply_abat');
2758: pn_var_rent_calc_pkg.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2759: pnp_debug_pkg.log('complete');
2760:
2761: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN

Line 2759: pnp_debug_pkg.log('complete');

2755: pnp_debug_pkg.log('complete');
2756:
2757: pnp_debug_pkg.log('call apply_abat');
2758: pn_var_rent_calc_pkg.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2759: pnp_debug_pkg.log('complete');
2760:
2761: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2762: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2763: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);

Line 2762: pnp_debug_pkg.log('call pnp_debug_pkg.log');

2758: pn_var_rent_calc_pkg.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2759: pnp_debug_pkg.log('complete');
2760:
2761: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2762: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2763: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2764: pnp_debug_pkg.log('complete');
2765: END IF;--Apply allowance
2766: pnp_debug_pkg.log('called populate_neg_rent');

Line 2764: pnp_debug_pkg.log('complete');

2760:
2761: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
2762: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2763: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2764: pnp_debug_pkg.log('complete');
2765: END IF;--Apply allowance
2766: pnp_debug_pkg.log('called populate_neg_rent');
2767: pn_var_rent_calc_pkg.populate_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2768: pnp_debug_pkg.log('complete');

Line 2766: pnp_debug_pkg.log('called populate_neg_rent');

2762: pnp_debug_pkg.log('call pnp_debug_pkg.log');
2763: pn_var_rent_calc_pkg.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2764: pnp_debug_pkg.log('complete');
2765: END IF;--Apply allowance
2766: pnp_debug_pkg.log('called populate_neg_rent');
2767: pn_var_rent_calc_pkg.populate_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2768: pnp_debug_pkg.log('complete');
2769:
2770:

Line 2768: pnp_debug_pkg.log('complete');

2764: pnp_debug_pkg.log('complete');
2765: END IF;--Apply allowance
2766: pnp_debug_pkg.log('called populate_neg_rent');
2767: pn_var_rent_calc_pkg.populate_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
2768: pnp_debug_pkg.log('complete');
2769:
2770:
2771: --
2772: FOR rec IN prev_invoiced_c(p_var_rent_id, p_period_id, inv_rec.invoice_date) LOOP

Line 2795: pnp_debug_pkg.log('Abatements - updating');

2791: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
2792: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
2793:
2794: -- Update the current invoice
2795: pnp_debug_pkg.log('Abatements - updating');
2796: UPDATE
2797: pn_var_rent_inv_all
2798: SET
2799: actual_invoiced_amount = ROUND((l_abated_rent - l_prev_inv_exp), g_precision)

Line 2812: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);

2808: -- Insert a new invoice. This happens only if your rents changes as a result of
2809: -- applied allowance/abat when you add them after some calc have been done.
2810: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
2811: --This can loop only once
2812: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
2813: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
2814: pnp_debug_pkg.log('Abatements - inserting');
2815: l_row_id := NULL;
2816: l_var_rent_inv_id := NULL;

Line 2813: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

2809: -- applied allowance/abat when you add them after some calc have been done.
2810: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
2811: --This can loop only once
2812: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
2813: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
2814: pnp_debug_pkg.log('Abatements - inserting');
2815: l_row_id := NULL;
2816: l_var_rent_inv_id := NULL;
2817: pn_var_rent_inv_pkg.insert_row

Line 2814: pnp_debug_pkg.log('Abatements - inserting');

2810: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
2811: --This can loop only once
2812: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
2813: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
2814: pnp_debug_pkg.log('Abatements - inserting');
2815: l_row_id := NULL;
2816: l_var_rent_inv_id := NULL;
2817: pn_var_rent_inv_pkg.insert_row
2818: ( x_rowid => l_row_id,

Line 2870: pnp_debug_pkg.log('apply_abatements end1(-)');

2866:
2867:
2868:
2869: END LOOP;--Loop for all required invoices.
2870: pnp_debug_pkg.log('apply_abatements end1(-)');
2871: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
2872:
2873:
2874: EXCEPTION

Line 2871: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);

2867:
2868:
2869: END LOOP;--Loop for all required invoices.
2870: pnp_debug_pkg.log('apply_abatements end1(-)');
2871: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
2872:
2873:
2874: EXCEPTION
2875: WHEN others THEN

Line 2876: pnp_debug_pkg.log('Raised exception');

2872:
2873:
2874: EXCEPTION
2875: WHEN others THEN
2876: pnp_debug_pkg.log('Raised exception');
2877: RAISE;
2878: END;
2879:
2880:

Line 2958: pnp_debug_pkg.log('apply_neg_rent start(+)');

2954: l_abated_rent NUMBER;
2955: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;
2956: l_last_invoice_dt pn_var_grp_dates.invoice_date%TYPE;
2957: BEGIN
2958: pnp_debug_pkg.log('apply_neg_rent start(+)');
2959: -- Get the negative rent flag
2960: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
2961: l_negative_rent_flag := rec.negative_rent;
2962: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

Line 2962: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

2958: pnp_debug_pkg.log('apply_neg_rent start(+)');
2959: -- Get the negative rent flag
2960: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
2961: l_negative_rent_flag := rec.negative_rent;
2962: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);
2963: END LOOP;
2964: -- Get the last invoice_date
2965: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
2966: l_last_invoice_dt := rec.inv_date;

Line 2967: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);

2963: END LOOP;
2964: -- Get the last invoice_date
2965: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
2966: l_last_invoice_dt := rec.inv_date;
2967: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
2968: END LOOP;
2969: -- Loop for all invoices.
2970: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
2971: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

Line 2971: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

2967: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
2968: END LOOP;
2969: -- Loop for all invoices.
2970: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
2971: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2972: l_negative_rent := 0;
2973: l_negative_available := 0;
2974: l_negative_applied := 0;
2975: -- Get available negative rent.

Line 2978: pnp_debug_pkg.log('l_negative_available'||l_negative_available);

2974: l_negative_applied := 0;
2975: -- Get available negative rent.
2976: FOR rec IN csr_neg_avail(p_var_rent_id, inv_rec.invoice_date) LOOP
2977: l_negative_available :=rec.negative_available;
2978: pnp_debug_pkg.log('l_negative_available'||l_negative_available);
2979: END LOOP;
2980: -- Get applied negative rent
2981: FOR rec IN csr_neg_appl (p_var_rent_id, inv_rec.invoice_date) LOOP
2982: l_negative_applied := rec.negative_applied;

Line 2983: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);

2979: END LOOP;
2980: -- Get applied negative rent
2981: FOR rec IN csr_neg_appl (p_var_rent_id, inv_rec.invoice_date) LOOP
2982: l_negative_applied := rec.negative_applied;
2983: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);
2984: END LOOP;
2985: l_negative_remaining := ABS(l_negative_available - l_negative_applied);
2986: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);
2987: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_IGNORE) THEN

Line 2986: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);

2982: l_negative_applied := rec.negative_applied;
2983: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);
2984: END LOOP;
2985: l_negative_remaining := ABS(l_negative_available - l_negative_applied);
2986: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);
2987: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_IGNORE) THEN
2988: l_abated_rent := GREATEST(0, inv_rec.constr_actual_rent);
2989: ELSIF(l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_CREDIT) THEN
2990: l_abated_rent := inv_rec.constr_actual_rent;

Line 3011: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

3007: l_abated_rent := inv_rec.constr_actual_rent - l_negative_remaining;
3008: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
3009: END IF;
3010: END IF;
3011: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3012: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3013: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3014:
3015: UPDATE pn_var_rent_inv_all

Line 3012: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);

3008: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
3009: END IF;
3010: END IF;
3011: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3012: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3013: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3014:
3015: UPDATE pn_var_rent_inv_all
3016: SET abated_rent = l_abated_rent,

Line 3013: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

3009: END IF;
3010: END IF;
3011: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3012: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3013: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3014:
3015: UPDATE pn_var_rent_inv_all
3016: SET abated_rent = l_abated_rent,
3017: negative_rent = L_negative_rent

Line 3020: pnp_debug_pkg.log('apply_neg_rent end(-)');

3016: SET abated_rent = l_abated_rent,
3017: negative_rent = L_negative_rent
3018: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3019: END LOOP;
3020: pnp_debug_pkg.log('apply_neg_rent end(-)');
3021:
3022: EXCEPTION
3023: --
3024: WHEN others THEN

Line 3025: pnp_debug_pkg.log('Raised exception');

3021:
3022: EXCEPTION
3023: --
3024: WHEN others THEN
3025: pnp_debug_pkg.log('Raised exception');
3026: RAISE;
3027: END;
3028: */
3029:

Line 3113: pnp_debug_pkg.log('apply_def_neg_rent start(+)');

3109: l_abated_rent NUMBER;
3110: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;
3111: l_last_invoice_dt pn_var_grp_dates.invoice_date%TYPE;
3112: BEGIN
3113: pnp_debug_pkg.log('apply_def_neg_rent start(+)');
3114: -- Get the negative rent flag
3115: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
3116: l_negative_rent_flag := rec.negative_rent;
3117: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

Line 3117: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

3113: pnp_debug_pkg.log('apply_def_neg_rent start(+)');
3114: -- Get the negative rent flag
3115: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
3116: l_negative_rent_flag := rec.negative_rent;
3117: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);
3118: END LOOP;
3119: -- Get the last invoice_date
3120: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
3121: l_last_invoice_dt := rec.inv_date;

Line 3122: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);

3118: END LOOP;
3119: -- Get the last invoice_date
3120: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
3121: l_last_invoice_dt := rec.inv_date;
3122: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
3123: END LOOP;
3124: -- Loop for all invoices.
3125: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
3126: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

Line 3126: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

3122: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
3123: END LOOP;
3124: -- Loop for all invoices.
3125: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
3126: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3127: l_negative_rent := 0;
3128: l_negative_available := 0;
3129: l_negative_applied := 0;
3130: l_abated_rent :=inv_rec.constr_actual_rent;

Line 3134: pnp_debug_pkg.log('l_negative_available'||l_negative_available);

3130: l_abated_rent :=inv_rec.constr_actual_rent;
3131: -- Get available negative rent.
3132: FOR rec IN csr_neg_avail(p_var_rent_id, inv_rec.invoice_date) LOOP
3133: l_negative_available :=rec.negative_available;
3134: pnp_debug_pkg.log('l_negative_available'||l_negative_available);
3135: END LOOP;
3136: -- Get applied negative rent
3137: FOR rec IN csr_neg_appl (p_var_rent_id, inv_rec.invoice_date) LOOP
3138: l_negative_applied := rec.negative_applied;

Line 3139: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);

3135: END LOOP;
3136: -- Get applied negative rent
3137: FOR rec IN csr_neg_appl (p_var_rent_id, inv_rec.invoice_date) LOOP
3138: l_negative_applied := rec.negative_applied;
3139: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);
3140: END LOOP;
3141: l_negative_remaining := ABS(l_negative_available - l_negative_applied);
3142: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);
3143: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_DEFER) THEN

Line 3142: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);

3138: l_negative_applied := rec.negative_applied;
3139: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);
3140: END LOOP;
3141: l_negative_remaining := ABS(l_negative_available - l_negative_applied);
3142: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);
3143: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_DEFER) THEN
3144: -- Deffered negative rent can be applied only when consT-rent >0
3145: IF (l_last_invoice_dt <> inv_rec.invoice_date AND inv_rec.constr_actual_rent > 0) THEN
3146: --This invoice is not the last invoice

Line 3148: pnp_debug_pkg.log('l_abated_rent1:'||l_abated_rent);

3144: -- Deffered negative rent can be applied only when consT-rent >0
3145: IF (l_last_invoice_dt <> inv_rec.invoice_date AND inv_rec.constr_actual_rent > 0) THEN
3146: --This invoice is not the last invoice
3147: l_abated_rent := GREATEST(0, inv_rec.constr_actual_rent - l_negative_remaining);
3148: pnp_debug_pkg.log('l_abated_rent1:'||l_abated_rent);
3149: IF (inv_rec.constr_actual_rent > l_abated_rent) THEN
3150: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
3151: ELSE
3152: l_negative_rent := 0;

Line 3159: pnp_debug_pkg.log('l_abated_rent2:'||l_abated_rent);

3155:
3156: ELSIF (l_last_invoice_dt = inv_rec.invoice_date) THEN
3157: --This is the last invoice. All deffered negative rent needs to be added
3158: l_abated_rent := inv_rec.constr_actual_rent - l_negative_remaining;
3159: pnp_debug_pkg.log('l_abated_rent2:'||l_abated_rent);
3160: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
3161: END IF;
3162: END IF;
3163: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

Line 3163: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

3159: pnp_debug_pkg.log('l_abated_rent2:'||l_abated_rent);
3160: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
3161: END IF;
3162: END IF;
3163: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3164: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3165: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3166:
3167: UPDATE pn_var_rent_inv_all

Line 3164: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);

3160: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
3161: END IF;
3162: END IF;
3163: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3164: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3165: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3166:
3167: UPDATE pn_var_rent_inv_all
3168: SET negative_rent = ROUND(l_negative_rent, g_precision)

Line 3165: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

3161: END IF;
3162: END IF;
3163: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3164: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3165: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3166:
3167: UPDATE pn_var_rent_inv_all
3168: SET negative_rent = ROUND(l_negative_rent, g_precision)
3169: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;

Line 3172: pnp_debug_pkg.log('apply_def_neg_rent end(-)');

3168: SET negative_rent = ROUND(l_negative_rent, g_precision)
3169: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3170: x_abated_rent := l_abated_rent;
3171: END LOOP;
3172: pnp_debug_pkg.log('apply_def_neg_rent end(-)');
3173:
3174: EXCEPTION
3175: --
3176: WHEN others THEN

Line 3177: pnp_debug_pkg.log('Raised exception');

3173:
3174: EXCEPTION
3175: --
3176: WHEN others THEN
3177: pnp_debug_pkg.log('Raised exception');
3178: RAISE;
3179: END;
3180:
3181: --------------------------------------------------------------------------------

Line 3239: pnp_debug_pkg.log('populate_neg_rent start(+)');

3235: l_abated_rent NUMBER;
3236: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;
3237: l_last_invoice_dt pn_var_grp_dates.invoice_date%TYPE;
3238: BEGIN
3239: pnp_debug_pkg.log('populate_neg_rent start(+)');
3240: -- Get the negative rent flag
3241: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
3242: l_negative_rent_flag := rec.negative_rent;
3243: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

Line 3243: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

3239: pnp_debug_pkg.log('populate_neg_rent start(+)');
3240: -- Get the negative rent flag
3241: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
3242: l_negative_rent_flag := rec.negative_rent;
3243: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);
3244: END LOOP;
3245: -- Get the last invoice_date
3246: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
3247: l_last_invoice_dt := rec.inv_date;

Line 3248: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);

3244: END LOOP;
3245: -- Get the last invoice_date
3246: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
3247: l_last_invoice_dt := rec.inv_date;
3248: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
3249: END LOOP;
3250: -- Loop for all invoices.
3251: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
3252: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_IGNORE) THEN

Line 3266: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

3262: ELSIF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_DEFER
3263: AND inv_rec.invoice_date = l_last_invoice_dt) THEN
3264: l_abated_rent := x_abated_rent;
3265: END IF;
3266: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3267: pnp_debug_pkg.log('l_neg_rent_def*:'||l_neg_rent_def);
3268: UPDATE pn_var_rent_inv_all
3269: SET def_neg_rent = ROUND(l_neg_rent_def, g_precision)
3270: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;

Line 3267: pnp_debug_pkg.log('l_neg_rent_def*:'||l_neg_rent_def);

3263: AND inv_rec.invoice_date = l_last_invoice_dt) THEN
3264: l_abated_rent := x_abated_rent;
3265: END IF;
3266: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3267: pnp_debug_pkg.log('l_neg_rent_def*:'||l_neg_rent_def);
3268: UPDATE pn_var_rent_inv_all
3269: SET def_neg_rent = ROUND(l_neg_rent_def, g_precision)
3270: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3271: x_abated_rent := l_abated_rent;

Line 3273: pnp_debug_pkg.log('populate_neg_rent end(-)');

3269: SET def_neg_rent = ROUND(l_neg_rent_def, g_precision)
3270: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3271: x_abated_rent := l_abated_rent;
3272: END LOOP;
3273: pnp_debug_pkg.log('populate_neg_rent end(-)');
3274:
3275: EXCEPTION
3276: --
3277: WHEN others THEN

Line 3278: pnp_debug_pkg.log('Raised exception');

3274:
3275: EXCEPTION
3276: --
3277: WHEN others THEN
3278: pnp_debug_pkg.log('Raised exception');
3279: RAISE;
3280: END;
3281:
3282: --------------------------------------------------------------------------------

Line 3441: pnp_debug_pkg.log('apply_abat start(+)');

3437: -- Get the proration type
3438: FOR proration_rec IN proration_type_c(p_var_rent_id) LOOP
3439: l_proration_type := proration_rec.proration_rule;
3440: END LOOP;
3441: pnp_debug_pkg.log('apply_abat start(+)');
3442: -- is this in ly first inv? No abatements should be applied to this invoice
3443: FOR ly_inv_rec IN ly_min_inv_c(p_var_rent_id) LOOP
3444: l_ly_max_inv_id := ly_inv_rec.var_rent_inv_id;
3445: l_ly_max_prd_id := ly_inv_rec.period_id;

Line 3447: pnp_debug_pkg.log('l_ly_max_inv_id:'||l_ly_max_inv_id);

3443: FOR ly_inv_rec IN ly_min_inv_c(p_var_rent_id) LOOP
3444: l_ly_max_inv_id := ly_inv_rec.var_rent_inv_id;
3445: l_ly_max_prd_id := ly_inv_rec.period_id;
3446: END LOOP;
3447: pnp_debug_pkg.log('l_ly_max_inv_id:'||l_ly_max_inv_id);
3448: pnp_debug_pkg.log('l_ly_max_prd_id:'||l_ly_max_prd_id);
3449:
3450: --For LY/FLY, if last period and not last invoice,
3451: -- Invoices are dummy. Return immdiately.

Line 3448: pnp_debug_pkg.log('l_ly_max_prd_id:'||l_ly_max_prd_id);

3444: l_ly_max_inv_id := ly_inv_rec.var_rent_inv_id;
3445: l_ly_max_prd_id := ly_inv_rec.period_id;
3446: END LOOP;
3447: pnp_debug_pkg.log('l_ly_max_inv_id:'||l_ly_max_inv_id);
3448: pnp_debug_pkg.log('l_ly_max_prd_id:'||l_ly_max_prd_id);
3449:
3450: --For LY/FLY, if last period and not last invoice,
3451: -- Invoices are dummy. Return immdiately.
3452: IF (p_period_id = l_ly_max_prd_id AND NOT(p_inv_id = l_ly_max_inv_id) AND l_proration_type IN (pn_var_rent_calc_pkg.G_PRORUL_FLY, pn_var_rent_calc_pkg.G_PRORUL_LY) ) THEN

Line 3453: pnp_debug_pkg.log('Ly invoice, not last - return immedietly');

3449:
3450: --For LY/FLY, if last period and not last invoice,
3451: -- Invoices are dummy. Return immdiately.
3452: IF (p_period_id = l_ly_max_prd_id AND NOT(p_inv_id = l_ly_max_inv_id) AND l_proration_type IN (pn_var_rent_calc_pkg.G_PRORUL_FLY, pn_var_rent_calc_pkg.G_PRORUL_LY) ) THEN
3453: pnp_debug_pkg.log('Ly invoice, not last - return immedietly');
3454: RETURN;
3455: END IF;
3456:
3457:

Line 3460: pnp_debug_pkg.log('l_excess_abat:'||l_excess_abat);

3456:
3457:
3458: FOR abat_rec IN EXCESS_ABAT_C(p_var_rent_id) LOOP
3459: l_excess_abat := abat_rec.excess_abat_code;
3460: pnp_debug_pkg.log('l_excess_abat:'||l_excess_abat);
3461: EXIT;
3462: END LOOP;
3463:
3464: --

Line 3495: pnp_debug_pkg.log('FY/LY modified dates');

3491: l_inv_start_date := inv_rec.start_date;
3492: l_inv_end_date := inv_rec.end_date;
3493: END LOOP;
3494: --
3495: pnp_debug_pkg.log('FY/LY modified dates');
3496: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);
3497: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
3498: FOR num_rec IN num_inv_c(p_inv_id) LOOP
3499: l_num_inv := num_rec.num_inv;

Line 3496: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);

3492: l_inv_end_date := inv_rec.end_date;
3493: END LOOP;
3494: --
3495: pnp_debug_pkg.log('FY/LY modified dates');
3496: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);
3497: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
3498: FOR num_rec IN num_inv_c(p_inv_id) LOOP
3499: l_num_inv := num_rec.num_inv;
3500: END LOOP;

Line 3497: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);

3493: END LOOP;
3494: --
3495: pnp_debug_pkg.log('FY/LY modified dates');
3496: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);
3497: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
3498: FOR num_rec IN num_inv_c(p_inv_id) LOOP
3499: l_num_inv := num_rec.num_inv;
3500: END LOOP;
3501: pnp_debug_pkg.log('l_num_inv:'||l_num_inv);

Line 3501: pnp_debug_pkg.log('l_num_inv:'||l_num_inv);

3497: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
3498: FOR num_rec IN num_inv_c(p_inv_id) LOOP
3499: l_num_inv := num_rec.num_inv;
3500: END LOOP;
3501: pnp_debug_pkg.log('l_num_inv:'||l_num_inv);
3502:
3503: END IF;
3504: l_rec_abat := inv_rec.rec_abatement;
3505: l_abat_override := inv_rec.rec_abatement_override;

Line 3506: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);

3502:
3503: END IF;
3504: l_rec_abat := inv_rec.rec_abatement;
3505: l_abat_override := inv_rec.rec_abatement_override;
3506: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);
3507: l_abated_rent := x_abated_rent;
3508: l_unabated_rent := x_abated_rent;
3509: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3510: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);

Line 3509: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

3505: l_abat_override := inv_rec.rec_abatement_override;
3506: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);
3507: l_abated_rent := x_abated_rent;
3508: l_unabated_rent := x_abated_rent;
3509: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3510: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
3511:
3512: IF (l_abat_override IS NOT NULL) THEN
3513: l_total_abat := l_abat_override;

Line 3510: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);

3506: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);
3507: l_abated_rent := x_abated_rent;
3508: l_unabated_rent := x_abated_rent;
3509: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3510: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
3511:
3512: IF (l_abat_override IS NOT NULL) THEN
3513: l_total_abat := l_abat_override;
3514: ELSE

Line 3517: pnp_debug_pkg.log('l_fixed_abat:'||l_fixed_abat);

3513: l_total_abat := l_abat_override;
3514: ELSE
3515: FOR rec IN fixed_abat_c(p_var_rent_id, l_inv_start_date, l_inv_end_date) LOOP
3516: l_fixed_abat := rec.fixed_abat * l_num_inv;
3517: pnp_debug_pkg.log('l_fixed_abat:'||l_fixed_abat);
3518: END LOOP;
3519: l_total_abat := l_fixed_abat + l_rec_abat;
3520: END IF;
3521:

Line 3522: pnp_debug_pkg.log('l_total_abat:'||l_total_abat);

3518: END LOOP;
3519: l_total_abat := l_fixed_abat + l_rec_abat;
3520: END IF;
3521:
3522: pnp_debug_pkg.log('l_total_abat:'||l_total_abat);
3523: IF (l_excess_abat = pn_var_rent_calc_pkg.G_EXC_ABAT_IGNORE
3524: AND x_abated_rent>0 ) THEN
3525: l_abated_rent := GREATEST(0, x_abated_rent - l_total_abat);
3526: ELSIF (l_excess_abat = pn_var_rent_calc_pkg.G_EXC_ABAT_NEG_RENT ) THEN

Line 3530: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

3526: ELSIF (l_excess_abat = pn_var_rent_calc_pkg.G_EXC_ABAT_NEG_RENT ) THEN
3527: l_abated_rent := x_abated_rent - l_total_abat;
3528: END IF;
3529:
3530: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3531: x_abated_rent := l_abated_rent;
3532: l_total_abat := l_unabated_rent - l_abated_rent;
3533: pnp_debug_pkg.log('total_abat_applied:'||l_total_abat);
3534: UPDATE pn_var_rent_inv_all

Line 3533: pnp_debug_pkg.log('total_abat_applied:'||l_total_abat);

3529:
3530: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3531: x_abated_rent := l_abated_rent;
3532: l_total_abat := l_unabated_rent - l_abated_rent;
3533: pnp_debug_pkg.log('total_abat_applied:'||l_total_abat);
3534: UPDATE pn_var_rent_inv_all
3535: SET rec_abatement = ROUND(l_total_abat, g_precision)
3536: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3537:

Line 3539: pnp_debug_pkg.log('apply_abat end(-)');

3535: SET rec_abatement = ROUND(l_total_abat, g_precision)
3536: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3537:
3538: END LOOP;
3539: pnp_debug_pkg.log('apply_abat end(-)');
3540:
3541: EXCEPTION
3542: --
3543: WHEN others THEN

Line 3544: pnp_debug_pkg.log('Exception in apply_abat');

3540:
3541: EXCEPTION
3542: --
3543: WHEN others THEN
3544: pnp_debug_pkg.log('Exception in apply_abat');
3545: RAISE;
3546: END;
3547:
3548: --------------------------------------------------------------------------------

Line 3656: pnp_debug_pkg.log('apply_allow start(+)');

3652: l_first_inv_id NUMBER;
3653: l_last_inv_id NUMBER;
3654:
3655: BEGIN
3656: pnp_debug_pkg.log('apply_allow start(+)');
3657: -- Special cases which need to be handled are
3658: -- FY/FLY first invoice AND LY/FLY last invoice.
3659: -- get first inv
3660: --

Line 3676: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

3672: END LOOP;
3673:
3674:
3675: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
3676: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3677: l_allow_applied_inv := inv_rec.abatement_appl;
3678: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
3679: --
3680: FOR inv_dates_rec IN invoice_dates_c(p_var_rent_id, inv_rec.invoice_date) LOOP

Line 3678: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);

3674:
3675: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
3676: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3677: l_allow_applied_inv := inv_rec.abatement_appl;
3678: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
3679: --
3680: FOR inv_dates_rec IN invoice_dates_c(p_var_rent_id, inv_rec.invoice_date) LOOP
3681: l_inv_start_date := inv_dates_rec.inv_start_date;
3682: l_inv_end_date := inv_dates_rec.inv_end_date;

Line 3700: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);

3696: l_prev_abt_rent := x_abated_rent;
3697: FOR allow_rec IN rolling_allow_c(p_var_rent_id, l_inv_start_date, l_inv_end_date) LOOP
3698: --Allowances can olny be applied if rent is >0
3699: IF (l_cur_abt_rent > 0) THEN
3700: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);
3701: l_allow_remain := allow_rec.rolling_allow -NVL(allow_rec.allow_applied,0);
3702: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
3703: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
3704: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);

Line 3702: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);

3698: --Allowances can olny be applied if rent is >0
3699: IF (l_cur_abt_rent > 0) THEN
3700: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);
3701: l_allow_remain := allow_rec.rolling_allow -NVL(allow_rec.allow_applied,0);
3702: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
3703: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
3704: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
3705: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
3706: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);

Line 3704: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);

3700: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);
3701: l_allow_remain := allow_rec.rolling_allow -NVL(allow_rec.allow_applied,0);
3702: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
3703: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
3704: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
3705: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
3706: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
3707: l_prev_abt_rent := l_cur_abt_rent;
3708: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);

Line 3706: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);

3702: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
3703: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
3704: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
3705: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
3706: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
3707: l_prev_abt_rent := l_cur_abt_rent;
3708: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
3709: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
3710: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);

Line 3708: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);

3704: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
3705: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
3706: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
3707: l_prev_abt_rent := l_cur_abt_rent;
3708: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
3709: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
3710: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
3711: UPDATE pn_var_abat_defaults_all
3712: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied

Line 3710: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);

3706: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
3707: l_prev_abt_rent := l_cur_abt_rent;
3708: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
3709: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
3710: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
3711: UPDATE pn_var_abat_defaults_all
3712: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied
3713: WHERE abatement_id = allow_rec.abatement_id;
3714: END IF;

Line 3716: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);

3712: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied
3713: WHERE abatement_id = allow_rec.abatement_id;
3714: END IF;
3715: END LOOP;
3716: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);
3717: UPDATE pn_var_rent_inv_all
3718: SET abatement_appl = ROUND(l_allow_applied_inv, g_precision)
3719: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3720: x_abated_rent := l_cur_abt_rent;

Line 3721: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

3717: UPDATE pn_var_rent_inv_all
3718: SET abatement_appl = ROUND(l_allow_applied_inv, g_precision)
3719: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3720: x_abated_rent := l_cur_abt_rent;
3721: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3722: END LOOP;
3723: pnp_debug_pkg.log('apply_allow end(-)');
3724: EXCEPTION
3725: WHEN others THEN

Line 3723: pnp_debug_pkg.log('apply_allow end(-)');

3719: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3720: x_abated_rent := l_cur_abt_rent;
3721: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3722: END LOOP;
3723: pnp_debug_pkg.log('apply_allow end(-)');
3724: EXCEPTION
3725: WHEN others THEN
3726: RAISE;
3727: END;

Line 3880: pnp_debug_pkg.log('Reset_abatement start(+)');

3876: --------------------------------------------------------------------------------
3877: PROCEDURE reset_abatements(p_var_rent_id IN NUMBER
3878: ) IS
3879: BEGIN
3880: pnp_debug_pkg.log('Reset_abatement start(+)');
3881: UPDATE pn_var_abat_defaults_all
3882: SET allowance_applied =0
3883: WHERE var_rent_id = p_var_rent_id;
3884: UPDATE pn_var_rent_inv_all

Line 3887: pnp_debug_pkg.log('Reset_abatement end(-)');

3883: WHERE var_rent_id = p_var_rent_id;
3884: UPDATE pn_var_rent_inv_all
3885: SET abatement_appl =0
3886: WHERE var_rent_id = p_var_rent_id;
3887: pnp_debug_pkg.log('Reset_abatement end(-)');
3888:
3889: EXCEPTION
3890: WHEN others THEN
3891: RAISE;

Line 4018: pnp_debug_pkg.log('+++++++++ calculate_rent START +++++++++++');

4014: l_ce_msg_count NUMBER;
4015: l_ce_msg_data VARCHAR2(2000);
4016:
4017: BEGIN
4018: pnp_debug_pkg.log('+++++++++ calculate_rent START +++++++++++');
4019: pnp_debug_pkg.log('');
4020: /* -------------------------------------------------------------------------- */
4021: /* ------------------------------- CODE BEGIN ------------------------------- */
4022: /* -------------------------------------------------------------------------- */

Line 4019: pnp_debug_pkg.log('');

4015: l_ce_msg_data VARCHAR2(2000);
4016:
4017: BEGIN
4018: pnp_debug_pkg.log('+++++++++ calculate_rent START +++++++++++');
4019: pnp_debug_pkg.log('');
4020: /* -------------------------------------------------------------------------- */
4021: /* ------------------------------- CODE BEGIN ------------------------------- */
4022: /* -------------------------------------------------------------------------- */
4023:

Line 4029: pnp_debug_pkg.log(l_context||' COMPLETE');

4025: l_context := 'Call pn_var_rent_calc_pkg.cache_vr_details';
4026:
4027: pn_var_rent_calc_pkg.cache_vr_details(p_var_rent_id => p_var_rent_id);
4028:
4029: pnp_debug_pkg.log(l_context||' COMPLETE');
4030:
4031: /* check if trx tables need to be updated for change in bkts */
4032: l_context := 'Call pn_var_trx_pkg.populate_transactions';
4033:

Line 4036: pnp_debug_pkg.log(l_context||' COMPLETE');

4032: l_context := 'Call pn_var_trx_pkg.populate_transactions';
4033:
4034: pn_var_trx_pkg.populate_transactions(p_var_rent_id => p_var_rent_id);
4035:
4036: pnp_debug_pkg.log(l_context||' COMPLETE');
4037:
4038: /*Do we need to populate actual sales or forecasted sales?*/
4039:
4040: IF(g_invoice_on=G_INV_ON_ACTUAL) THEN

Line 4044: pnp_debug_pkg.log(l_context||' COMPLETE');

4040: IF(g_invoice_on=G_INV_ON_ACTUAL) THEN
4041: /* check if trx tables need to be updated for change in sales volume */
4042: l_context := 'Call pn_var_trx_pkg.populate_sales';
4043: pn_var_trx_pkg.populate_sales(p_var_rent_id => p_var_rent_id);
4044: pnp_debug_pkg.log(l_context||' COMPLETE');
4045: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_CALCULATE) THEN
4046: /* check if trx tables need to be updated for change in forecasted sales volume */
4047: l_context := 'Call pn_var_trx_pkg.populate_sales_for';
4048: pn_var_trx_pkg.populate_sales_for(p_var_rent_id => p_var_rent_id);

Line 4049: pnp_debug_pkg.log(l_context||' COMPLETE');

4045: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_CALCULATE) THEN
4046: /* check if trx tables need to be updated for change in forecasted sales volume */
4047: l_context := 'Call pn_var_trx_pkg.populate_sales_for';
4048: pn_var_trx_pkg.populate_sales_for(p_var_rent_id => p_var_rent_id);
4049: pnp_debug_pkg.log(l_context||' COMPLETE');
4050: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_RECONCILE) THEN
4051: /* check if trx tables need to be updated for change in sales volume */
4052: l_context := 'Call pn_var_trx_pkg.populate_sales';
4053: pn_var_trx_pkg.populate_sales(p_var_rent_id => p_var_rent_id);

Line 4054: pnp_debug_pkg.log(l_context||' COMPLETE');

4050: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_RECONCILE) THEN
4051: /* check if trx tables need to be updated for change in sales volume */
4052: l_context := 'Call pn_var_trx_pkg.populate_sales';
4053: pn_var_trx_pkg.populate_sales(p_var_rent_id => p_var_rent_id);
4054: pnp_debug_pkg.log(l_context||' COMPLETE');
4055:
4056: END IF;
4057:
4058: /* Populate deductions - Only need to do this when actuals are being calculated */

Line 4061: pnp_debug_pkg.log('');

4057:
4058: /* Populate deductions - Only need to do this when actuals are being calculated */
4059: IF(g_invoice_on=G_INV_ON_ACTUAL)
4060: OR (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_RECONCILE) THEN
4061: pnp_debug_pkg.log('');
4062: l_context := 'Call pn_var_trx_pkg.populate_deductions';
4063:
4064: pn_var_trx_pkg.populate_deductions(p_var_rent_id => p_var_rent_id);
4065:

Line 4066: pnp_debug_pkg.log(l_context||' COMPLETE');

4062: l_context := 'Call pn_var_trx_pkg.populate_deductions';
4063:
4064: pn_var_trx_pkg.populate_deductions(p_var_rent_id => p_var_rent_id);
4065:
4066: pnp_debug_pkg.log(l_context||' COMPLETE');
4067:
4068: END IF;
4069:
4070: pnp_debug_pkg.log('');

Line 4070: pnp_debug_pkg.log('');

4066: pnp_debug_pkg.log(l_context||' COMPLETE');
4067:
4068: END IF;
4069:
4070: pnp_debug_pkg.log('');
4071:
4072: /* populate the trx tables with calculated rents */
4073: l_context := 'Get periods to calculate rent for';
4074:

Line 4099: pnp_debug_pkg.log(l_context||' COMPLETE');

4095: CLOSE periods_c;
4096:
4097: END IF;
4098:
4099: pnp_debug_pkg.log(l_context||' COMPLETE');
4100: pnp_debug_pkg.log('');
4101:
4102: l_context := 'Loop for all cached periods. Number of periods: '||l_periods_t.COUNT;
4103: pnp_debug_pkg.log(l_context);

Line 4100: pnp_debug_pkg.log('');

4096:
4097: END IF;
4098:
4099: pnp_debug_pkg.log(l_context||' COMPLETE');
4100: pnp_debug_pkg.log('');
4101:
4102: l_context := 'Loop for all cached periods. Number of periods: '||l_periods_t.COUNT;
4103: pnp_debug_pkg.log(l_context);
4104: pnp_debug_pkg.log('');

Line 4103: pnp_debug_pkg.log(l_context);

4099: pnp_debug_pkg.log(l_context||' COMPLETE');
4100: pnp_debug_pkg.log('');
4101:
4102: l_context := 'Loop for all cached periods. Number of periods: '||l_periods_t.COUNT;
4103: pnp_debug_pkg.log(l_context);
4104: pnp_debug_pkg.log('');
4105:
4106: /* loop for all periods cached and calculate rent */
4107: IF l_periods_t.COUNT > 0 THEN

Line 4104: pnp_debug_pkg.log('');

4100: pnp_debug_pkg.log('');
4101:
4102: l_context := 'Loop for all cached periods. Number of periods: '||l_periods_t.COUNT;
4103: pnp_debug_pkg.log(l_context);
4104: pnp_debug_pkg.log('');
4105:
4106: /* loop for all periods cached and calculate rent */
4107: IF l_periods_t.COUNT > 0 THEN
4108:

Line 4116: pnp_debug_pkg.log(l_context);

4112: := '=== Looping for Period - Start Date: '||l_periods_t(p).start_date||
4113: ' -- End Date: '||l_periods_t(p).end_date||
4114: ' === ';
4115:
4116: pnp_debug_pkg.log(l_context);
4117: pnp_debug_pkg.log('');
4118:
4119: l_context := 'Fetch all trx data for period';
4120:

Line 4117: pnp_debug_pkg.log('');

4113: ' -- End Date: '||l_periods_t(p).end_date||
4114: ' === ';
4115:
4116: pnp_debug_pkg.log(l_context);
4117: pnp_debug_pkg.log('');
4118:
4119: l_context := 'Fetch all trx data for period';
4120:
4121: /*Do we need to populate actual or forecasted rents?*/

Line 4137: pnp_debug_pkg.log(l_context||' COMPLETE');

4133: ,p_prd_id => l_periods_t(p).period_id);
4134: FETCH pn_var_rent_calc_pkg.trx_hdr_c BULK COLLECT INTO l_trx_hrd_t;
4135: CLOSE pn_var_rent_calc_pkg.trx_hdr_c;
4136:
4137: pnp_debug_pkg.log(l_context||' COMPLETE');
4138: pnp_debug_pkg.log('');
4139:
4140: IF l_trx_hrd_t.COUNT > 0 THEN
4141:

Line 4138: pnp_debug_pkg.log('');

4134: FETCH pn_var_rent_calc_pkg.trx_hdr_c BULK COLLECT INTO l_trx_hrd_t;
4135: CLOSE pn_var_rent_calc_pkg.trx_hdr_c;
4136:
4137: pnp_debug_pkg.log(l_context||' COMPLETE');
4138: pnp_debug_pkg.log('');
4139:
4140: IF l_trx_hrd_t.COUNT > 0 THEN
4141:
4142: l_context := 'Loop for all cached transactions. '||

Line 4144: pnp_debug_pkg.log(l_context);

4140: IF l_trx_hrd_t.COUNT > 0 THEN
4141:
4142: l_context := 'Loop for all cached transactions. '||
4143: 'Number of trx: '||l_trx_hrd_t.COUNT;
4144: pnp_debug_pkg.log(l_context);
4145:
4146: FOR t IN l_trx_hrd_t.FIRST..l_trx_hrd_t.LAST LOOP
4147:
4148: l_context

Line 4154: pnp_debug_pkg.log(l_context);

4150: l_trx_hrd_t(t).calc_prd_start_date||
4151: ' -- End Date: '||
4152: l_trx_hrd_t(t).calc_prd_end_date||
4153: ' === ';
4154: pnp_debug_pkg.log(l_context);
4155: pnp_debug_pkg.log('');
4156:
4157: /* if we need to create an invoice for this calc (sub) period
4158: AND if approved sales exist

Line 4155: pnp_debug_pkg.log('');

4151: ' -- End Date: '||
4152: l_trx_hrd_t(t).calc_prd_end_date||
4153: ' === ';
4154: pnp_debug_pkg.log(l_context);
4155: pnp_debug_pkg.log('');
4156:
4157: /* if we need to create an invoice for this calc (sub) period
4158: AND if approved sales exist
4159: */

Line 4170: pnp_debug_pkg.log(l_context||' COMPLETE');

4166: l_trx_hrd_r := l_trx_hrd_t(t);
4167:
4168: l_context := 'Call pn_var_rent_calc_pkg.get_rent_applicable';
4169: pn_var_rent_calc_pkg.get_rent_applicable(l_trx_hrd_r);
4170: pnp_debug_pkg.log(l_context||' COMPLETE');
4171: pnp_debug_pkg.log('');
4172:
4173: /* if rent changed */
4174: IF NVL(l_trx_hrd_t(t).calculated_rent, 0)

Line 4171: pnp_debug_pkg.log('');

4167:
4168: l_context := 'Call pn_var_rent_calc_pkg.get_rent_applicable';
4169: pn_var_rent_calc_pkg.get_rent_applicable(l_trx_hrd_r);
4170: pnp_debug_pkg.log(l_context||' COMPLETE');
4171: pnp_debug_pkg.log('');
4172:
4173: /* if rent changed */
4174: IF NVL(l_trx_hrd_t(t).calculated_rent, 0)
4175: <> NVL(l_trx_hrd_r.calculated_rent, 0) OR

Line 4200: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure');

4196: , x_msg_data => l_ce_msg_data
4197: );
4198:
4199:
4200: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure');
4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);
4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);

Line 4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);

4197: );
4198:
4199:
4200: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure');
4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);
4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);

Line 4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);

4198:
4199:
4200: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure');
4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);
4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4206: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);

Line 4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);

4199:
4200: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure');
4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);
4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4206: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4207:

Line 4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);

4200: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure');
4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);
4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4206: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4207:
4208: --- Bug#10269475

Line 4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);

4201: pnp_debug_pkg.log (' l_trx_hrd_r.trx_header_id : ' || l_trx_hrd_r.trx_header_id);
4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4206: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4207:
4208: --- Bug#10269475
4209:

Line 4206: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);

4202: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4203: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4204: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4205: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4206: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4207:
4208: --- Bug#10269475
4209:
4210: UPDATE

Line 4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');

4219: trx_header_id = l_trx_hrd_r.trx_header_id;
4220:
4221: --- Bug#10269475
4222:
4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');
4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);

Line 4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);

4220:
4221: --- Bug#10269475
4222:
4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');
4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4228: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);

Line 4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);

4221: --- Bug#10269475
4222:
4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');
4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4228: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4229:

Line 4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);

4222:
4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');
4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4228: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4229:
4230: --- Bug#10269475

Line 4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);

4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');
4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4228: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4229:
4230: --- Bug#10269475
4231:

Line 4228: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);

4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);
4228: pnp_debug_pkg.log (' l_trx_hrd_r.first_yr_rent : ' || l_trx_hrd_r.first_yr_rent);
4229:
4230: --- Bug#10269475
4231:
4232: l_trx_hrd_t(t) := l_trx_hrd_r;

Line 4239: pnp_debug_pkg.log(l_context);

4235:
4236: ELSE
4237:
4238: l_context := 'No calculation necessary';
4239: pnp_debug_pkg.log(l_context);
4240: pnp_debug_pkg.log('');
4241:
4242: END IF; /* need to create inv 4 this calc (sub) prd AND appr sales exist */
4243:

Line 4240: pnp_debug_pkg.log('');

4236: ELSE
4237:
4238: l_context := 'No calculation necessary';
4239: pnp_debug_pkg.log(l_context);
4240: pnp_debug_pkg.log('');
4241:
4242: END IF; /* need to create inv 4 this calc (sub) prd AND appr sales exist */
4243:
4244: END LOOP; /* loop for all trx in the period */

Line 4247: pnp_debug_pkg.log(l_context||' COMPLETE');

4243:
4244: END LOOP; /* loop for all trx in the period */
4245:
4246: l_context := 'Loop for all cached transactions.';
4247: pnp_debug_pkg.log(l_context||' COMPLETE');
4248: pnp_debug_pkg.log('');
4249:
4250: END IF;
4251:

Line 4248: pnp_debug_pkg.log('');

4244: END LOOP; /* loop for all trx in the period */
4245:
4246: l_context := 'Loop for all cached transactions.';
4247: pnp_debug_pkg.log(l_context||' COMPLETE');
4248: pnp_debug_pkg.log('');
4249:
4250: END IF;
4251:
4252: ELSIF (g_invoice_on = G_INV_ON_FORECASTED AND g_calc_type = G_CALC_TYPE_CALCULATE) THEN

Line 4265: pnp_debug_pkg.log(l_context||' COMPLETE');

4261: ,p_prd_id => l_periods_t(p).period_id);
4262: FETCH pn_var_rent_calc_pkg.trx_hdr_for_c BULK COLLECT INTO l_trx_hrd_for_t;
4263: CLOSE pn_var_rent_calc_pkg.trx_hdr_for_c;
4264:
4265: pnp_debug_pkg.log(l_context||' COMPLETE');
4266: pnp_debug_pkg.log('');
4267:
4268: IF l_trx_hrd_for_t.COUNT > 0 THEN
4269:

Line 4266: pnp_debug_pkg.log('');

4262: FETCH pn_var_rent_calc_pkg.trx_hdr_for_c BULK COLLECT INTO l_trx_hrd_for_t;
4263: CLOSE pn_var_rent_calc_pkg.trx_hdr_for_c;
4264:
4265: pnp_debug_pkg.log(l_context||' COMPLETE');
4266: pnp_debug_pkg.log('');
4267:
4268: IF l_trx_hrd_for_t.COUNT > 0 THEN
4269:
4270: l_context := 'Loop for all cached transactions. '||

Line 4272: pnp_debug_pkg.log(l_context);

4268: IF l_trx_hrd_for_t.COUNT > 0 THEN
4269:
4270: l_context := 'Loop for all cached transactions. '||
4271: 'Number of trx: '||l_trx_hrd_for_t.COUNT;
4272: pnp_debug_pkg.log(l_context);
4273:
4274: FOR t IN l_trx_hrd_for_t.FIRST..l_trx_hrd_for_t.LAST LOOP
4275:
4276: l_context

Line 4282: pnp_debug_pkg.log(l_context);

4278: l_trx_hrd_for_t(t).calc_prd_start_date||
4279: ' -- End Date: '||
4280: l_trx_hrd_for_t(t).calc_prd_end_date||
4281: ' === ';
4282: pnp_debug_pkg.log(l_context);
4283: pnp_debug_pkg.log('');
4284:
4285: /* if we need to create an invoice for this calc (sub) period
4286: */

Line 4283: pnp_debug_pkg.log('');

4279: ' -- End Date: '||
4280: l_trx_hrd_for_t(t).calc_prd_end_date||
4281: ' === ';
4282: pnp_debug_pkg.log(l_context);
4283: pnp_debug_pkg.log('');
4284:
4285: /* if we need to create an invoice for this calc (sub) period
4286: */
4287: IF NVL(l_trx_hrd_for_t(t).invoice_flag, 'Y') <> 'N'

Line 4299: pnp_debug_pkg.log(l_context||' COMPLETE');

4295: l_trx_hrd_for_r := l_trx_hrd_for_t(t);
4296:
4297: l_context := 'Call pn_var_rent_calc_pkg.get_rent_applicable_for';
4298: pn_var_rent_calc_pkg.get_rent_applicable_for(l_trx_hrd_for_r);
4299: pnp_debug_pkg.log(l_context||' COMPLETE');
4300: pnp_debug_pkg.log('');
4301:
4302: /* if rent changed */
4303: IF NVL(l_trx_hrd_for_t(t).calculated_rent_for, 0)

Line 4300: pnp_debug_pkg.log('');

4296:
4297: l_context := 'Call pn_var_rent_calc_pkg.get_rent_applicable_for';
4298: pn_var_rent_calc_pkg.get_rent_applicable_for(l_trx_hrd_for_r);
4299: pnp_debug_pkg.log(l_context||' COMPLETE');
4300: pnp_debug_pkg.log('');
4301:
4302: /* if rent changed */
4303: IF NVL(l_trx_hrd_for_t(t).calculated_rent_for, 0)
4304: <> NVL(l_trx_hrd_for_r.calculated_rent_for, 0) OR

Line 4310: pnp_debug_pkg.log('updating the trx');

4306: <> NVL(l_trx_hrd_for_r.percent_rent_due_for, 0) OR
4307: NVL(l_trx_hrd_for_t(t).ytd_percent_rent_for, 0)
4308: <> NVL(l_trx_hrd_for_r.ytd_percent_rent_for, 0)
4309: THEN
4310: pnp_debug_pkg.log('updating the trx');
4311: pnp_debug_pkg.log('l_trx_hrd_for_t(t).calculated_rent_for'||l_trx_hrd_for_t(t).calculated_rent_for);
4312: pnp_debug_pkg.log('l_trx_hrd_for_r.calculated_rent_for'||l_trx_hrd_for_r.calculated_rent_for);
4313: pnp_debug_pkg.log('l_trx_hrd_for_r.trx_header_id'||l_trx_hrd_for_r.trx_header_id);
4314:

Line 4311: pnp_debug_pkg.log('l_trx_hrd_for_t(t).calculated_rent_for'||l_trx_hrd_for_t(t).calculated_rent_for);

4307: NVL(l_trx_hrd_for_t(t).ytd_percent_rent_for, 0)
4308: <> NVL(l_trx_hrd_for_r.ytd_percent_rent_for, 0)
4309: THEN
4310: pnp_debug_pkg.log('updating the trx');
4311: pnp_debug_pkg.log('l_trx_hrd_for_t(t).calculated_rent_for'||l_trx_hrd_for_t(t).calculated_rent_for);
4312: pnp_debug_pkg.log('l_trx_hrd_for_r.calculated_rent_for'||l_trx_hrd_for_r.calculated_rent_for);
4313: pnp_debug_pkg.log('l_trx_hrd_for_r.trx_header_id'||l_trx_hrd_for_r.trx_header_id);
4314:
4315: --- Bug#10269475

Line 4312: pnp_debug_pkg.log('l_trx_hrd_for_r.calculated_rent_for'||l_trx_hrd_for_r.calculated_rent_for);

4308: <> NVL(l_trx_hrd_for_r.ytd_percent_rent_for, 0)
4309: THEN
4310: pnp_debug_pkg.log('updating the trx');
4311: pnp_debug_pkg.log('l_trx_hrd_for_t(t).calculated_rent_for'||l_trx_hrd_for_t(t).calculated_rent_for);
4312: pnp_debug_pkg.log('l_trx_hrd_for_r.calculated_rent_for'||l_trx_hrd_for_r.calculated_rent_for);
4313: pnp_debug_pkg.log('l_trx_hrd_for_r.trx_header_id'||l_trx_hrd_for_r.trx_header_id);
4314:
4315: --- Bug#10269475
4316: PN_VRA_CLIENT_EXTN.calculate_override (

Line 4313: pnp_debug_pkg.log('l_trx_hrd_for_r.trx_header_id'||l_trx_hrd_for_r.trx_header_id);

4309: THEN
4310: pnp_debug_pkg.log('updating the trx');
4311: pnp_debug_pkg.log('l_trx_hrd_for_t(t).calculated_rent_for'||l_trx_hrd_for_t(t).calculated_rent_for);
4312: pnp_debug_pkg.log('l_trx_hrd_for_r.calculated_rent_for'||l_trx_hrd_for_r.calculated_rent_for);
4313: pnp_debug_pkg.log('l_trx_hrd_for_r.trx_header_id'||l_trx_hrd_for_r.trx_header_id);
4314:
4315: --- Bug#10269475
4316: PN_VRA_CLIENT_EXTN.calculate_override (
4317: p_var_rent_id => p_var_rent_id

Line 4329: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure - g_invoice_on = G_INV_ON_FORECASTED');

4325: , x_msg_count => l_ce_msg_count
4326: , x_msg_data => l_ce_msg_data
4327: );
4328:
4329: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure - g_invoice_on = G_INV_ON_FORECASTED');
4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);

Line 4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);

4326: , x_msg_data => l_ce_msg_data
4327: );
4328:
4329: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure - g_invoice_on = G_INV_ON_FORECASTED');
4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);

Line 4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);

4327: );
4328:
4329: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure - g_invoice_on = G_INV_ON_FORECASTED');
4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4335: --pnp_debug_pkg.log (' lr_first_yr_rent : ' || lr_first_yr_rent);

Line 4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);

4328:
4329: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure - g_invoice_on = G_INV_ON_FORECASTED');
4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4335: --pnp_debug_pkg.log (' lr_first_yr_rent : ' || lr_first_yr_rent);
4336:

Line 4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);

4329: pnp_debug_pkg.log (' After PN_VRA_CLIENT_EXTN.calculate_override procedure - g_invoice_on = G_INV_ON_FORECASTED');
4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4335: --pnp_debug_pkg.log (' lr_first_yr_rent : ' || lr_first_yr_rent);
4336:
4337: --- Bug#10269475

Line 4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);

4330: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4335: --pnp_debug_pkg.log (' lr_first_yr_rent : ' || lr_first_yr_rent);
4336:
4337: --- Bug#10269475
4338:

Line 4335: --pnp_debug_pkg.log (' lr_first_yr_rent : ' || lr_first_yr_rent);

4331: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4332: --pnp_debug_pkg.log (' lr_prorated_rent_due : ' || lr_prorated_rent_due);
4333: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4334: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4335: --pnp_debug_pkg.log (' lr_first_yr_rent : ' || lr_first_yr_rent);
4336:
4337: --- Bug#10269475
4338:
4339: UPDATE

Line 4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');

4346: trx_header_id = l_trx_hrd_for_r.trx_header_id;
4347:
4348: --- Bug#10269475
4349:
4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');
4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);

Line 4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);

4347:
4348: --- Bug#10269475
4349:
4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');
4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4355:

Line 4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);

4348: --- Bug#10269475
4349:
4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');
4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4355:
4356: --- Bug#10269475

Line 4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);

4349:
4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');
4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4355:
4356: --- Bug#10269475
4357:

Line 4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);

4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');
4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);
4355:
4356: --- Bug#10269475
4357:
4358: l_trx_hrd_t(t) := l_trx_hrd_r;

Line 4365: pnp_debug_pkg.log(l_context);

4361:
4362: ELSE
4363:
4364: l_context := 'No calculation necessary';
4365: pnp_debug_pkg.log(l_context);
4366: pnp_debug_pkg.log('');
4367:
4368: END IF; /* need to create inv 4 this calc (sub) prd AND appr sales exist */
4369:

Line 4366: pnp_debug_pkg.log('');

4362: ELSE
4363:
4364: l_context := 'No calculation necessary';
4365: pnp_debug_pkg.log(l_context);
4366: pnp_debug_pkg.log('');
4367:
4368: END IF; /* need to create inv 4 this calc (sub) prd AND appr sales exist */
4369:
4370: END LOOP; /* loop for all trx in the period */

Line 4373: pnp_debug_pkg.log(l_context||' COMPLETE');

4369:
4370: END LOOP; /* loop for all trx in the period */
4371:
4372: l_context := 'Loop for all cached transactions.';
4373: pnp_debug_pkg.log(l_context||' COMPLETE');
4374: pnp_debug_pkg.log('');
4375:
4376: END IF;
4377:

Line 4374: pnp_debug_pkg.log('');

4370: END LOOP; /* loop for all trx in the period */
4371:
4372: l_context := 'Loop for all cached transactions.';
4373: pnp_debug_pkg.log(l_context||' COMPLETE');
4374: pnp_debug_pkg.log('');
4375:
4376: END IF;
4377:
4378: END IF;/*end g_invoice and g_calc_type*/

Line 4411: pnp_debug_pkg.log('set partial flag');

4407: CLOSE periods_out_c;
4408:
4409: END IF;
4410:
4411: pnp_debug_pkg.log('set partial flag');
4412: -- Set l_partial_prd_id if 1st partial period exists and proration rule is FY/FLY
4413: IF g_proration_rule IN ( pn_var_rent_calc_pkg.G_PRORUL_FY
4414: ,pn_var_rent_calc_pkg.G_PRORUL_FLY) THEN
4415: FOR fst_rec IN check_fst_partial_prd(p_var_rent_id) LOOP

Line 4421: pnp_debug_pkg.log('prior to pop inv date tab');

4417: END LOOP;
4418: END IF;
4419:
4420: g_partial_prd_flag := NULL;
4421: pnp_debug_pkg.log('prior to pop inv date tab');
4422: -- call to populate inv_date_tab for roll fwd
4423: -- IF 1st partial period exists then call pop_inv_date_tab_firstyr ,to populate
4424: -- invoice dates from 2nd annual period
4425: -- ELSE call pop_inv_date_tab

Line 4434: /*pnp_debug_pkg.log('data in inv_date_tab');

4430: pn_var_rent_calc_pkg.pop_inv_date_tab(p_var_rent_id => p_var_rent_id ,
4431: p_status => 'APPROVED');
4432: END IF;
4433:
4434: /*pnp_debug_pkg.log('data in inv_date_tab');
4435: FOR i IN 1..inv_date_tab.COUNT LOOP
4436: pnp_debug_pkg.log(inv_date_tab(i).inv_date||' '||
4437: inv_date_tab(i).period_id||' '||
4438: inv_date_tab(i).inv_flag||'!!');

Line 4436: pnp_debug_pkg.log(inv_date_tab(i).inv_date||' '||

4432: END IF;
4433:
4434: /*pnp_debug_pkg.log('data in inv_date_tab');
4435: FOR i IN 1..inv_date_tab.COUNT LOOP
4436: pnp_debug_pkg.log(inv_date_tab(i).inv_date||' '||
4437: inv_date_tab(i).period_id||' '||
4438: inv_date_tab(i).inv_flag||'!!');
4439: END LOOP;*/
4440:

Line 4464: pnp_debug_pkg.log(l_context||' COMPLETE');

4460: THEN*/
4461: pn_var_rent_calc_pkg.post_summary
4462: ( p_var_rent_id => p_var_rent_id
4463: ,p_period_id => l_periods_t(p).period_id);
4464: pnp_debug_pkg.log(l_context||' COMPLETE');
4465: pnp_debug_pkg.log('');
4466: /*END IF; */
4467:
4468: ELSIF (g_invoice_on=G_INV_ON_FORECASTED AND g_calc_type= G_CALC_TYPE_CALCULATE)

Line 4465: pnp_debug_pkg.log('');

4461: pn_var_rent_calc_pkg.post_summary
4462: ( p_var_rent_id => p_var_rent_id
4463: ,p_period_id => l_periods_t(p).period_id);
4464: pnp_debug_pkg.log(l_context||' COMPLETE');
4465: pnp_debug_pkg.log('');
4466: /*END IF; */
4467:
4468: ELSIF (g_invoice_on=G_INV_ON_FORECASTED AND g_calc_type= G_CALC_TYPE_CALCULATE)
4469: THEN

Line 4474: pnp_debug_pkg.log(l_context||' COMPLETE');

4470: l_context := 'Call pn_var_rent_calc_pkg.post_summary_for';
4471: pn_var_rent_calc_pkg.post_summary_for
4472: ( p_var_rent_id => p_var_rent_id
4473: ,p_period_id => l_periods_t(p).period_id);
4474: pnp_debug_pkg.log(l_context||' COMPLETE');
4475: pnp_debug_pkg.log('');
4476:
4477: END IF;/*End invoice type and calc_type*/
4478:

Line 4475: pnp_debug_pkg.log('');

4471: pn_var_rent_calc_pkg.post_summary_for
4472: ( p_var_rent_id => p_var_rent_id
4473: ,p_period_id => l_periods_t(p).period_id);
4474: pnp_debug_pkg.log(l_context||' COMPLETE');
4475: pnp_debug_pkg.log('');
4476:
4477: END IF;/*End invoice type and calc_type*/
4478:
4479: l_context := 'Call pn_var_rent_calc_pkg.insert_invoice';

Line 4499: pnp_debug_pkg.log(l_context||' COMPLETE');

4495: ,p_period_id => l_periods_t(p).period_id);
4496:
4497: END IF;
4498:
4499: pnp_debug_pkg.log(l_context||' COMPLETE');
4500: pnp_debug_pkg.log('');
4501:
4502: END LOOP;/*End loop for all periods*/
4503:

Line 4500: pnp_debug_pkg.log('');

4496:
4497: END IF;
4498:
4499: pnp_debug_pkg.log(l_context||' COMPLETE');
4500: pnp_debug_pkg.log('');
4501:
4502: END LOOP;/*End loop for all periods*/
4503:
4504: /* Create the invoice for first partial year separately */

Line 4542: pnp_debug_pkg.log('g_calculation_method3:'||g_calculation_method);

4538: g_partial_prd_flag := NULL; -- clearing the roll fwd flag of 1st partial prd
4539:
4540: --Reset abatements for the periods for which we donot re-calculate
4541: pn_var_rent_calc_pkg.reset_abatements(p_var_rent_id);
4542: pnp_debug_pkg.log('g_calculation_method3:'||g_calculation_method);
4543: IF l_periods_out_t.COUNT > 0 THEN
4544: FOR p IN l_periods_out_t.FIRST..l_periods_out_t.LAST --
4545: --
4546: LOOP

Line 4549: pnp_debug_pkg.log('True up');

4545: --
4546: LOOP
4547: IF (g_calculation_method = 'T') THEN
4548: --Take true up invoices into account
4549: pnp_debug_pkg.log('True up');
4550: pn_var_trueup_pkg.set_trueup_flag('C');
4551: pn_var_trueup_pkg.apply_abatements
4552: ( p_var_rent_id => p_var_rent_id
4553: ,p_period_id => l_periods_out_t(p).period_id

Line 4557: pnp_debug_pkg.log('Not true up');

4553: ,p_period_id => l_periods_out_t(p).period_id
4554: ,p_flag => 'RESET');
4555: ELSE
4556: --No need to take trueup invoices into account.
4557: pnp_debug_pkg.log('Not true up');
4558: pn_var_rent_calc_pkg.apply_abatements
4559: ( p_var_rent_id => p_var_rent_id
4560: ,p_period_id => l_periods_out_t(p).period_id
4561: ,p_flag => 'RESET');

Line 4573: pnp_debug_pkg.log('True up');

4569: FOR p IN l_periods_t.FIRST..l_periods_t.LAST --
4570: --
4571: LOOP
4572: IF (g_calculation_method = 'T') THEN
4573: pnp_debug_pkg.log('True up');
4574: NULL;
4575: --Take true up invoices into account
4576: pn_var_trueup_pkg.set_trueup_flag('C');
4577: pn_var_trueup_pkg.apply_abatements

Line 4582: pnp_debug_pkg.log('Not true up');

4578: ( p_var_rent_id => p_var_rent_id
4579: ,p_period_id => l_periods_t(p).period_id
4580: ,p_flag => 'CALCULATE');
4581: ELSE
4582: pnp_debug_pkg.log('Not true up');
4583: --No need to take trueup invoices into account.
4584: pn_var_rent_calc_pkg.apply_abatements
4585: ( p_var_rent_id => p_var_rent_id
4586: ,p_period_id => l_periods_t(p).period_id

Line 4600: pnp_debug_pkg.put_log_msg(fnd_message.get);

4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;
4603: END IF;
4604:

Line 4609: pnp_debug_pkg.log(l_context||' COMPLETE');

4605: /* deletes the draft term for which invoice_date or term template has changed.*/
4606: pn_var_rent_calc_pkg.delete_draft_terms( p_var_rent_id => p_var_rent_id);
4607:
4608: l_context := 'Loop for all cached periods';
4609: pnp_debug_pkg.log(l_context||' COMPLETE');
4610: pnp_debug_pkg.log('');
4611:
4612: /* -------------------------------------------------------------------------- */
4613: /* -------------------------------- CODE END -------------------------------- */

Line 4610: pnp_debug_pkg.log('');

4606: pn_var_rent_calc_pkg.delete_draft_terms( p_var_rent_id => p_var_rent_id);
4607:
4608: l_context := 'Loop for all cached periods';
4609: pnp_debug_pkg.log(l_context||' COMPLETE');
4610: pnp_debug_pkg.log('');
4611:
4612: /* -------------------------------------------------------------------------- */
4613: /* -------------------------------- CODE END -------------------------------- */
4614: /* -------------------------------------------------------------------------- */

Line 4616: pnp_debug_pkg.log('+++++++++ calculate_rent END +++++++++++');

4612: /* -------------------------------------------------------------------------- */
4613: /* -------------------------------- CODE END -------------------------------- */
4614: /* -------------------------------------------------------------------------- */
4615:
4616: pnp_debug_pkg.log('+++++++++ calculate_rent END +++++++++++');
4617: pnp_debug_pkg.log('');
4618:
4619: EXCEPTION
4620: WHEN OTHERS THEN

Line 4617: pnp_debug_pkg.log('');

4613: /* -------------------------------- CODE END -------------------------------- */
4614: /* -------------------------------------------------------------------------- */
4615:
4616: pnp_debug_pkg.log('+++++++++ calculate_rent END +++++++++++');
4617: pnp_debug_pkg.log('');
4618:
4619: EXCEPTION
4620: WHEN OTHERS THEN
4621: pnp_debug_pkg.log

Line 4621: pnp_debug_pkg.log

4617: pnp_debug_pkg.log('');
4618:
4619: EXCEPTION
4620: WHEN OTHERS THEN
4621: pnp_debug_pkg.log
4622: ('**********************************************************************');
4623: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
4624: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
4625: pnp_debug_pkg.log

Line 4623: pnp_debug_pkg.log('* ERROR IN calculate_rent *');

4619: EXCEPTION
4620: WHEN OTHERS THEN
4621: pnp_debug_pkg.log
4622: ('**********************************************************************');
4623: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
4624: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
4625: pnp_debug_pkg.log
4626: ('**********************************************************************');
4627: RAISE;

Line 4624: pnp_debug_pkg.log('* ERROR WHEN: '||l_context||' *');

4620: WHEN OTHERS THEN
4621: pnp_debug_pkg.log
4622: ('**********************************************************************');
4623: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
4624: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
4625: pnp_debug_pkg.log
4626: ('**********************************************************************');
4627: RAISE;
4628:

Line 4625: pnp_debug_pkg.log

4621: pnp_debug_pkg.log
4622: ('**********************************************************************');
4623: pnp_debug_pkg.log('*** ERROR IN calculate_rent ***');
4624: pnp_debug_pkg.log('*** ERROR WHEN: '||l_context||' ***');
4625: pnp_debug_pkg.log
4626: ('**********************************************************************');
4627: RAISE;
4628:
4629: END calculate_rent;

Line 4762: pnp_debug_pkg.log('+++++++++ insert_invoice_for START +++++++++++');

4758: l_exists_invoice BOOLEAN;
4759:
4760: BEGIN
4761:
4762: pnp_debug_pkg.log('+++++++++ insert_invoice_for START +++++++++++');
4763:
4764: FOR vr_rec IN org_c(p_vr_id => p_var_rent_id) LOOP
4765: l_org_id := vr_rec.org_id;
4766: END LOOP;

Line 4769: pnp_debug_pkg.log('l_precision:'||l_precision);

4765: l_org_id := vr_rec.org_id;
4766: END LOOP;
4767:
4768: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(l_org_id),4);
4769: pnp_debug_pkg.log('l_precision:'||l_precision);
4770:
4771: l_calc_type := g_calc_type;
4772: pnp_debug_pkg.log('calc_type:'|| l_calc_type);
4773:

Line 4772: pnp_debug_pkg.log('calc_type:'|| l_calc_type);

4768: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(l_org_id),4);
4769: pnp_debug_pkg.log('l_precision:'||l_precision);
4770:
4771: l_calc_type := g_calc_type;
4772: pnp_debug_pkg.log('calc_type:'|| l_calc_type);
4773:
4774: /* loop for all invoice dates in the period */
4775: FOR inv_rec IN invoice_dates_c( p_vr_id => p_var_rent_id
4776: ,p_prd_id => p_period_id)

Line 4816: pnp_debug_pkg.log('l_var_rent_inv_id:' || l_var_rent_inv_id);

4812: /* we only look at the last invoice */
4813: EXIT;
4814:
4815: END LOOP; /* check if there exists an invoice for this invoice date */
4816: pnp_debug_pkg.log('l_var_rent_inv_id:' || l_var_rent_inv_id);
4817:
4818: /* atleast one invoice exists? */
4819: IF NOT l_exists_invoice
4820: /*AND inv_rec.total_actual_rent <> 0*/ THEN

Line 4836: pnp_debug_pkg.log('inv_rec.total_forecasted_rent'||inv_rec.total_forecasted_rent);

4832: FOR vol_exists_rec IN vol_exists_c( p_var_rent_id,
4833: inv_rec.invoice_date
4834: ) LOOP
4835:
4836: pnp_debug_pkg.log('inv_rec.total_forecasted_rent'||inv_rec.total_forecasted_rent);
4837: pn_var_rent_inv_pkg.insert_row
4838: ( x_rowid => l_row_id,
4839: x_var_rent_inv_id => l_var_rent_inv_id,
4840: x_adjust_num => 0,

Line 4938: pnp_debug_pkg.log('inv_rec.invoice_date'||inv_rec.invoice_date);

4934: l_prev_inv_rent := 0;
4935: l_curr_inv_rent := 0;
4936: l_curr_inv_rent_for := 0;
4937:
4938: pnp_debug_pkg.log('inv_rec.invoice_date'||inv_rec.invoice_date);
4939: pnp_debug_pkg.log('inv_rec.total_actual_rent:'||inv_rec.total_actual_rent);
4940: /* check if there exists an invoice for this invoice date */
4941: FOR inv2upd_rec IN invoice2upd_c( p_vr_id => p_var_rent_id
4942: ,p_prd_id => p_period_id

Line 4939: pnp_debug_pkg.log('inv_rec.total_actual_rent:'||inv_rec.total_actual_rent);

4935: l_curr_inv_rent := 0;
4936: l_curr_inv_rent_for := 0;
4937:
4938: pnp_debug_pkg.log('inv_rec.invoice_date'||inv_rec.invoice_date);
4939: pnp_debug_pkg.log('inv_rec.total_actual_rent:'||inv_rec.total_actual_rent);
4940: /* check if there exists an invoice for this invoice date */
4941: FOR inv2upd_rec IN invoice2upd_c( p_vr_id => p_var_rent_id
4942: ,p_prd_id => p_period_id
4943: ,p_inv_dt => inv_rec.invoice_date)

Line 4966: pnp_debug_pkg.log('inv2upd_rec.variance_exp_code:'||inv2upd_rec.variance_exp_code);

4962: l_curr_inv_rent := 0;
4963: l_curr_inv_rent_for := inv2upd_rec.for_per_rent;
4964:
4965: END IF; /* invoice updateable? */
4966: pnp_debug_pkg.log('inv2upd_rec.variance_exp_code:'||inv2upd_rec.variance_exp_code);
4967: pnp_debug_pkg.log('l_var_rent_inv_id:'||l_var_rent_inv_id);
4968: /* we only look at the last invoice */
4969: EXIT;
4970:

Line 4967: pnp_debug_pkg.log('l_var_rent_inv_id:'||l_var_rent_inv_id);

4963: l_curr_inv_rent_for := inv2upd_rec.for_per_rent;
4964:
4965: END IF; /* invoice updateable? */
4966: pnp_debug_pkg.log('inv2upd_rec.variance_exp_code:'||inv2upd_rec.variance_exp_code);
4967: pnp_debug_pkg.log('l_var_rent_inv_id:'||l_var_rent_inv_id);
4968: /* we only look at the last invoice */
4969: EXIT;
4970:
4971: END LOOP; /* check if there exists an invoice for this invoice date */

Line 5087: pnp_debug_pkg.log('+++++++++ insert_invoice_for END +++++++++++');

5083:
5084:
5085: END LOOP; /* loop for all invoice dates in the period */
5086:
5087: pnp_debug_pkg.log('+++++++++ insert_invoice_for END +++++++++++');
5088:
5089: EXCEPTION
5090: WHEN OTHERS THEN RAISE;
5091:

Line 5191: pnp_debug_pkg.log('++++++ Start get_rent_applicable ++++++');

5187: l_last_partial VARCHAR2(1);
5188: l_period_num NUMBER := 0;
5189:
5190: BEGIN
5191: pnp_debug_pkg.log('++++++ Start get_rent_applicable ++++++');
5192: pnp_debug_pkg.log('p_trx_hdr_rec.invoice_flag:'||p_trx_hdr_rec.invoice_flag);
5193: IF NVL(p_trx_hdr_rec.invoice_flag, 'Y') = 'N' THEN
5194: RETURN;
5195: END IF;

Line 5192: pnp_debug_pkg.log('p_trx_hdr_rec.invoice_flag:'||p_trx_hdr_rec.invoice_flag);

5188: l_period_num NUMBER := 0;
5189:
5190: BEGIN
5191: pnp_debug_pkg.log('++++++ Start get_rent_applicable ++++++');
5192: pnp_debug_pkg.log('p_trx_hdr_rec.invoice_flag:'||p_trx_hdr_rec.invoice_flag);
5193: IF NVL(p_trx_hdr_rec.invoice_flag, 'Y') = 'N' THEN
5194: RETURN;
5195: END IF;
5196:

Line 5222: pnp_debug_pkg.log('Breakpoint Type:'||rec.breakpoint_type);

5218:
5219: /* get the breakpoint type - flat, sliding, stratified */
5220: FOR rec IN bkpt_type_c(p_bkdt_id => l_bkpts_t(1).bkpt_detail_id)
5221: LOOP
5222: pnp_debug_pkg.log('Breakpoint Type:'||rec.breakpoint_type);
5223: l_bkpt_type := rec.breakpoint_type;
5224: END LOOP;
5225:
5226: IF g_calculation_method IN ( pn_var_rent_calc_pkg.G_CALC_NON_CUMULATIVE

Line 5237: pnp_debug_pkg.log('l_net_volume'||l_net_volume);

5233: THEN
5234: l_net_volume := l_trx_hdr_rec.ytd_sales_for;
5235:
5236: END IF;
5237: pnp_debug_pkg.log('l_net_volume'||l_net_volume);
5238: /* handling the case of volume not tripping any bkpts */
5239: /* init the calculated rent to 0 - it will be re-calculated */
5240: l_trx_hdr_rec.calculated_rent_for := 0;
5241: IF g_calculation_method IN ( pn_var_rent_calc_pkg.G_CALC_NON_CUMULATIVE

Line 5256: pnp_debug_pkg.log('Volume doesnot trip breakpoints');

5252: l_trx_hdr_rec.calculated_rent
5253: := (l_net_volume - l_bkpts_t(1).pr_grp_blended_vol_start)
5254: * l_bkpts_t(1).bkpt_rate;
5255: */
5256: pnp_debug_pkg.log('Volume doesnot trip breakpoints');
5257: l_trx_hdr_rec.calculated_rent_for := 0;
5258:
5259: ELSE
5260:

Line 5319: pnp_debug_pkg.log('rent:'||l_trx_hdr_rec.calculated_rent_for);

5315:
5316: l_trx_hdr_rec.calculated_rent_for
5317: := l_trx_hdr_rec.calculated_rent_for
5318: + (l_bkpt_end - l_bkpt_start) * l_bkpts_t(i).bkpt_rate;
5319: pnp_debug_pkg.log('rent:'||l_trx_hdr_rec.calculated_rent_for);
5320:
5321: END IF;
5322:
5323: ELSE

Line 5385: pnp_debug_pkg.log('calculated_rent_for:'||l_trx_hdr_rec.calculated_rent_for);

5381: ELSIF l_bkpt_type = pn_var_rent_calc_pkg.G_BKPT_TYP_FLAT THEN
5382:
5383: l_trx_hdr_rec.calculated_rent_for
5384: := (l_net_volume - l_bkpt_start) * l_bkpts_t(i).bkpt_rate;
5385: pnp_debug_pkg.log('calculated_rent_for:'||l_trx_hdr_rec.calculated_rent_for);
5386: END IF;
5387: EXIT;
5388:
5389: END IF;

Line 5474: pnp_debug_pkg.log(' ');

5470: l_trx_hdr_rec.calculated_rent_for := 0;
5471: END IF; */
5472:
5473:
5474: pnp_debug_pkg.log(' ');
5475: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
5476: pnp_debug_pkg.log(' percent_rent_due: '||l_trx_hdr_rec.percent_rent_due_for);
5477: pnp_debug_pkg.log(' ytd_percent_rent: '||l_trx_hdr_rec.ytd_percent_rent_for);
5478: pnp_debug_pkg.log(' ');

Line 5475: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);

5471: END IF; */
5472:
5473:
5474: pnp_debug_pkg.log(' ');
5475: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
5476: pnp_debug_pkg.log(' percent_rent_due: '||l_trx_hdr_rec.percent_rent_due_for);
5477: pnp_debug_pkg.log(' ytd_percent_rent: '||l_trx_hdr_rec.ytd_percent_rent_for);
5478: pnp_debug_pkg.log(' ');
5479:

Line 5476: pnp_debug_pkg.log(' percent_rent_due: '||l_trx_hdr_rec.percent_rent_due_for);

5472:
5473:
5474: pnp_debug_pkg.log(' ');
5475: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
5476: pnp_debug_pkg.log(' percent_rent_due: '||l_trx_hdr_rec.percent_rent_due_for);
5477: pnp_debug_pkg.log(' ytd_percent_rent: '||l_trx_hdr_rec.ytd_percent_rent_for);
5478: pnp_debug_pkg.log(' ');
5479:
5480:

Line 5477: pnp_debug_pkg.log(' ytd_percent_rent: '||l_trx_hdr_rec.ytd_percent_rent_for);

5473:
5474: pnp_debug_pkg.log(' ');
5475: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
5476: pnp_debug_pkg.log(' percent_rent_due: '||l_trx_hdr_rec.percent_rent_due_for);
5477: pnp_debug_pkg.log(' ytd_percent_rent: '||l_trx_hdr_rec.ytd_percent_rent_for);
5478: pnp_debug_pkg.log(' ');
5479:
5480:
5481: /* ------------- GET percent_rent_due, ytd_percent_rent END ------------- */

Line 5478: pnp_debug_pkg.log(' ');

5474: pnp_debug_pkg.log(' ');
5475: pnp_debug_pkg.log(' calculation_method: '||g_calculation_method);
5476: pnp_debug_pkg.log(' percent_rent_due: '||l_trx_hdr_rec.percent_rent_due_for);
5477: pnp_debug_pkg.log(' ytd_percent_rent: '||l_trx_hdr_rec.ytd_percent_rent_for);
5478: pnp_debug_pkg.log(' ');
5479:
5480:
5481: /* ------------- GET percent_rent_due, ytd_percent_rent END ------------- */
5482:

Line 5484: pnp_debug_pkg.log('percent_rent_due_for:'||l_trx_hdr_rec.percent_rent_due_for);

5480:
5481: /* ------------- GET percent_rent_due, ytd_percent_rent END ------------- */
5482:
5483: END IF; /* volume trips breakpoint?? */
5484: pnp_debug_pkg.log('percent_rent_due_for:'||l_trx_hdr_rec.percent_rent_due_for);
5485: pnp_debug_pkg.log('ytd_rent_for:'||l_trx_hdr_rec.ytd_percent_rent_for);
5486: l_trx_hdr_rec.update_flag := 'Y';
5487: p_trx_hdr_rec := l_trx_hdr_rec;
5488: pnp_debug_pkg.log('------------end get_rent_applicable---------');

Line 5485: pnp_debug_pkg.log('ytd_rent_for:'||l_trx_hdr_rec.ytd_percent_rent_for);

5481: /* ------------- GET percent_rent_due, ytd_percent_rent END ------------- */
5482:
5483: END IF; /* volume trips breakpoint?? */
5484: pnp_debug_pkg.log('percent_rent_due_for:'||l_trx_hdr_rec.percent_rent_due_for);
5485: pnp_debug_pkg.log('ytd_rent_for:'||l_trx_hdr_rec.ytd_percent_rent_for);
5486: l_trx_hdr_rec.update_flag := 'Y';
5487: p_trx_hdr_rec := l_trx_hdr_rec;
5488: pnp_debug_pkg.log('------------end get_rent_applicable---------');
5489:

Line 5488: pnp_debug_pkg.log('------------end get_rent_applicable---------');

5484: pnp_debug_pkg.log('percent_rent_due_for:'||l_trx_hdr_rec.percent_rent_due_for);
5485: pnp_debug_pkg.log('ytd_rent_for:'||l_trx_hdr_rec.ytd_percent_rent_for);
5486: l_trx_hdr_rec.update_flag := 'Y';
5487: p_trx_hdr_rec := l_trx_hdr_rec;
5488: pnp_debug_pkg.log('------------end get_rent_applicable---------');
5489:
5490: EXCEPTION
5491: WHEN OTHERS THEN RAISE;
5492:

Line 6247: pnp_debug_pkg.log('total groups:'||l_grp_t.COUNT);

6243: OPEN grp_date_c( p_vr_id => p_var_rent_id
6244: ,p_prd_id => p_period_id);
6245: FETCH grp_date_c BULK COLLECT INTO l_grp_t;
6246: CLOSE grp_date_c;
6247: pnp_debug_pkg.log('total groups:'||l_grp_t.COUNT);
6248: /* loop for all lines in the annual period */
6249: FOR line_rec IN lines_c( p_vr_id => p_var_rent_id
6250: ,p_prd_id => p_period_id)
6251: LOOP

Line 6252: pnp_debug_pkg.log('looping for line:'||line_rec.line_item_id);

6248: /* loop for all lines in the annual period */
6249: FOR line_rec IN lines_c( p_vr_id => p_var_rent_id
6250: ,p_prd_id => p_period_id)
6251: LOOP
6252: pnp_debug_pkg.log('looping for line:'||line_rec.line_item_id);
6253: /* loop for all calc periods in the annual period */
6254: FOR g IN 1..l_grp_t.COUNT LOOP
6255: pnp_debug_pkg.log('looping for group:'||l_grp_t(g).grp_date_id);
6256: /* get the sum of rents and sales for

Line 6255: pnp_debug_pkg.log('looping for group:'||l_grp_t(g).grp_date_id);

6251: LOOP
6252: pnp_debug_pkg.log('looping for line:'||line_rec.line_item_id);
6253: /* loop for all calc periods in the annual period */
6254: FOR g IN 1..l_grp_t.COUNT LOOP
6255: pnp_debug_pkg.log('looping for group:'||l_grp_t(g).grp_date_id);
6256: /* get the sum of rents and sales for
6257: vr -> period -> line item -> group combination
6258: from the trx tables
6259: -- loops only once --

Line 6268: pnp_debug_pkg.log('rent'||summ_rec.rent);

6264: ,p_grp_id => l_grp_t(g).grp_date_id)
6265: LOOP
6266:
6267: l_vr_summ_id := NULL;
6268: pnp_debug_pkg.log('rent'||summ_rec.rent);
6269: /* chk if VR SUMM record exists for this
6270: vr -> period -> line item -> group combination */
6271: FOR vr_summ_rec IN vr_summ_c( p_vr_id => p_var_rent_id
6272: ,p_prd_id => p_period_id

Line 6282: pnp_debug_pkg.log('sales:'||summ_rec.sales);

6278:
6279: IF NVL(summ_rec.sales,0) <> NVL(vr_summ_rec.tot_for_vol,0) OR
6280: NVL(summ_rec.rent,0) <> NVL(vr_summ_rec.for_var_rent,0)
6281: THEN
6282: pnp_debug_pkg.log('sales:'||summ_rec.sales);
6283: pnp_debug_pkg.log('rent: '||summ_rec.rent);
6284: UPDATE
6285: pn_var_rent_summ_all
6286: SET

Line 6283: pnp_debug_pkg.log('rent: '||summ_rec.rent);

6279: IF NVL(summ_rec.sales,0) <> NVL(vr_summ_rec.tot_for_vol,0) OR
6280: NVL(summ_rec.rent,0) <> NVL(vr_summ_rec.for_var_rent,0)
6281: THEN
6282: pnp_debug_pkg.log('sales:'||summ_rec.sales);
6283: pnp_debug_pkg.log('rent: '||summ_rec.rent);
6284: UPDATE
6285: pn_var_rent_summ_all
6286: SET
6287: tot_for_vol = summ_rec.sales

Line 6302: pnp_debug_pkg.log('Inserting a new record for var_rent_summ table');

6298:
6299: IF l_vr_summ_id IS NULL THEN
6300:
6301: /* to insert a new summary record */
6302: pnp_debug_pkg.log('Inserting a new record for var_rent_summ table');
6303: INSERT INTO
6304: pn_var_rent_summ_all
6305: (var_rent_summ_id
6306: ,var_rent_id

Line 6340: pnp_debug_pkg.log('Inserted rent summ with id: '||l_vr_summ_id);

6336: RETURNING
6337: var_rent_summ_id
6338: INTO
6339: l_vr_summ_id;
6340: pnp_debug_pkg.log('Inserted rent summ with id: '||l_vr_summ_id);
6341: END IF;
6342: UPDATE
6343: pn_var_trx_headers_all hdr
6344: SET

Line 6516: pnp_debug_pkg.log

6512:
6513:
6514: BEGIN
6515:
6516: pnp_debug_pkg.log
6517: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6518: pnp_debug_pkg.log('+++++++++ process_rent_batch START +++++++++++');
6519: pnp_debug_pkg.log(' ');
6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');

Line 6518: pnp_debug_pkg.log('+++++++++ process_rent_batch START +++++++++++');

6514: BEGIN
6515:
6516: pnp_debug_pkg.log
6517: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6518: pnp_debug_pkg.log('+++++++++ process_rent_batch START +++++++++++');
6519: pnp_debug_pkg.log(' ');
6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');
6521: -- g_invoice_on := p_invoice_on;
6522: g_calc_type := p_calc_type;

Line 6519: pnp_debug_pkg.log(' ');

6515:
6516: pnp_debug_pkg.log
6517: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6518: pnp_debug_pkg.log('+++++++++ process_rent_batch START +++++++++++');
6519: pnp_debug_pkg.log(' ');
6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');
6521: -- g_invoice_on := p_invoice_on;
6522: g_calc_type := p_calc_type;
6523: pnp_debug_pkg.log('g_invoice_on:'||g_invoice_on);

Line 6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');

6516: pnp_debug_pkg.log
6517: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6518: pnp_debug_pkg.log('+++++++++ process_rent_batch START +++++++++++');
6519: pnp_debug_pkg.log(' ');
6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');
6521: -- g_invoice_on := p_invoice_on;
6522: g_calc_type := p_calc_type;
6523: pnp_debug_pkg.log('g_invoice_on:'||g_invoice_on);
6524: pnp_debug_pkg.log('g_calc_type'||g_calc_type);

Line 6523: pnp_debug_pkg.log('g_invoice_on:'||g_invoice_on);

6519: pnp_debug_pkg.log(' ');
6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');
6521: -- g_invoice_on := p_invoice_on;
6522: g_calc_type := p_calc_type;
6523: pnp_debug_pkg.log('g_invoice_on:'||g_invoice_on);
6524: pnp_debug_pkg.log('g_calc_type'||g_calc_type);
6525:
6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:

Line 6524: pnp_debug_pkg.log('g_calc_type'||g_calc_type);

6520: pnp_debug_pkg.log('Setting invoice_on and calc_type');
6521: -- g_invoice_on := p_invoice_on;
6522: g_calc_type := p_calc_type;
6523: pnp_debug_pkg.log('g_invoice_on:'||g_invoice_on);
6524: pnp_debug_pkg.log('g_calc_type'||g_calc_type);
6525:
6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:
6528:

Line 6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );

6522: g_calc_type := p_calc_type;
6523: pnp_debug_pkg.log('g_invoice_on:'||g_invoice_on);
6524: pnp_debug_pkg.log('g_calc_type'||g_calc_type);
6525:
6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);

Line 6542: pnp_debug_pkg.put_log_msg(fnd_message.get);

6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6545:
6546: IF p_property_name is not null and p_property_code is null THEN /* 9765197 */

Line 6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);

6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6545:
6546: IF p_property_name is not null and p_property_code is null THEN /* 9765197 */
6547: SELECT PROPERTY_CODE
6548: into l_prop_code

Line 6578: pnp_debug_pkg.log ('process_rent_batch - Inside cur : ' );

6574: IF csr_get_vrent_wprop%ISOPEN THEN
6575:
6576: FETCH csr_get_vrent_wprop INTO l_var_rent_id,l_invoice_on,l_cumulative,l_rent_num,g_org_id;
6577: EXIT WHEN csr_get_vrent_wprop%NOTFOUND;
6578: pnp_debug_pkg.log ('process_rent_batch - Inside cur : ' );
6579: ELSIF csr_get_vrent_wloc%ISOPEN THEN
6580:
6581: FETCH csr_get_vrent_wloc INTO l_var_rent_id,l_invoice_on,l_cumulative,l_rent_num,g_org_id;
6582: EXIT WHEN csr_get_vrent_wloc%NOTFOUND;

Line 6594: pnp_debug_pkg.put_log_msg(fnd_message.get);

6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:

Line 6601: pnp_debug_pkg.put_log_msg(fnd_message.get);

6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6605:

Line 6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);

6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6605:
6606: v_var_id_details_exists :=PN_VAR_RENT_PKG.find_if_volhist_bkpts_exist
6607: ( l_var_rent_id,

Line 6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);

6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6605:
6606: v_var_id_details_exists :=PN_VAR_RENT_PKG.find_if_volhist_bkpts_exist
6607: ( l_var_rent_id,
6608: 'VAR_RENT_ID' );

Line 6617: pnp_debug_pkg.put_log_msg(fnd_message.get);

6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6621:

Line 6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);

6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6621:
6622:
6623:

Line 6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);

6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6621:
6622:
6623:
6624: pn_var_rent_calc_pkg.calculate_rent

Line 6645: pnp_debug_pkg.log(' ');

6641: END IF;
6642:
6643:
6644:
6645: pnp_debug_pkg.log(' ');
6646: pnp_debug_pkg.log('+++++++++ process_rent_batch END +++++++++++');
6647: pnp_debug_pkg.log('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6648:
6649: EXCEPTION

Line 6646: pnp_debug_pkg.log('+++++++++ process_rent_batch END +++++++++++');

6642:
6643:
6644:
6645: pnp_debug_pkg.log(' ');
6646: pnp_debug_pkg.log('+++++++++ process_rent_batch END +++++++++++');
6647: pnp_debug_pkg.log('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6648:
6649: EXCEPTION
6650: WHEN OTHERS THEN

Line 6647: pnp_debug_pkg.log('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

6643:
6644:
6645: pnp_debug_pkg.log(' ');
6646: pnp_debug_pkg.log('+++++++++ process_rent_batch END +++++++++++');
6647: pnp_debug_pkg.log('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6648:
6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: pnp_debug_pkg.log('Error in pn_var_rent_calc_pkg.process_rent_batch :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

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

6647: pnp_debug_pkg.log('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
6648:
6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: pnp_debug_pkg.log('Error in pn_var_rent_calc_pkg.process_rent_batch :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
6652: Errbuf := SQLERRM;
6653: Retcode := 2;
6654: rollback;
6655: raise;

Line 6656: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (-) ');

6652: Errbuf := SQLERRM;
6653: Retcode := 2;
6654: rollback;
6655: raise;
6656: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (-) ');
6657:
6658: END process_rent_batch;
6659:
6660: FUNCTION END_BREAKPOINT(bkpt_start IN NUMBER, bkpt_end IN NUMBER) RETURN NUMBER IS

Line 8862: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB START +++++++++++');

8858: AND gd1.invoice_date=temp.inv_dt(+)
8859: ORDER BY gd1.invoice_date;
8860:
8861: BEGIN
8862: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB START +++++++++++');
8863:
8864: OPEN get_inv_dates_cur(p_var_rent_id,p_status) ;
8865: FETCH get_inv_dates_cur BULK COLLECT INTO inv_date_tab;
8866: CLOSE get_inv_dates_cur;

Line 8868: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB END +++++++++++');

8864: OPEN get_inv_dates_cur(p_var_rent_id,p_status) ;
8865: FETCH get_inv_dates_cur BULK COLLECT INTO inv_date_tab;
8866: CLOSE get_inv_dates_cur;
8867:
8868: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB END +++++++++++');
8869: END pop_inv_date_tab;
8870: --------------------------------------------------------------------------------
8871: -- NAME : POP_INV_DATE_TAB_FIRSTYR
8872: -- DESCRIPTION :

Line 8931: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB_FIRSTYR START +++++++++++');

8927: and gd1.invoice_date=temp.inv_dt(+)
8928: order by gd1.invoice_date;
8929:
8930: BEGIN
8931: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB_FIRSTYR START +++++++++++');
8932:
8933: FOR fst_prd_cur IN get_fst_prd_flag(p_var_rent_id ,p_status) LOOP
8934: g_partial_prd_flag := fst_prd_cur.fst_prd_flag;
8935: END LOOP;

Line 8937: --pnp_debug_pkg.log('g_partial_prd_flag='||g_partial_prd_flag);

8933: FOR fst_prd_cur IN get_fst_prd_flag(p_var_rent_id ,p_status) LOOP
8934: g_partial_prd_flag := fst_prd_cur.fst_prd_flag;
8935: END LOOP;
8936:
8937: --pnp_debug_pkg.log('g_partial_prd_flag='||g_partial_prd_flag);
8938:
8939: OPEN get_partial_prd_inv_dates(p_var_rent_id,p_status) ;
8940: FETCH get_partial_prd_inv_dates BULK COLLECT INTO inv_date_tab;
8941: CLOSE get_partial_prd_inv_dates;

Line 8943: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB_FIRSTYR END +++++++++++');

8939: OPEN get_partial_prd_inv_dates(p_var_rent_id,p_status) ;
8940: FETCH get_partial_prd_inv_dates BULK COLLECT INTO inv_date_tab;
8941: CLOSE get_partial_prd_inv_dates;
8942:
8943: pnp_debug_pkg.log('+++++++++ POP_INV_DATE_TAB_FIRSTYR END +++++++++++');
8944: END POP_INV_DATE_TAB_FIRSTYR;
8945:
8946: --------------------------------------------------------------------------------
8947: -- NAME : ROLL_FWD_PARTIAL_PRD

Line 9041: pnp_debug_pkg.log('+++++++++ ROLL_FWD_PARTIAL_PRD START +++++++++++');

9037: AND adjust_num=0;
9038:
9039:
9040: BEGIN
9041: pnp_debug_pkg.log('+++++++++ ROLL_FWD_PARTIAL_PRD START +++++++++++');
9042:
9043: FOR rec IN org_cur(p_var_rent_id) LOOP
9044: l_org_id := rec.org_id;
9045: END LOOP;

Line 9060: --pnp_debug_pkg.log('prior to update');

9056: FOR abtmt_exists_rec IN get_var_abtmt_id(p_var_rent_id) LOOP
9057: l_min_var_abt_id := abtmt_exists_rec.var_abatement_id;
9058: l_min_pmt_term_id := abtmt_exists_rec.payment_term_id;
9059:
9060: --pnp_debug_pkg.log('prior to update');
9061: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9062: update pn_var_abatements_all
9063: set var_rent_inv_id = l_fst_inv_id
9064: where var_abatement_id = l_min_var_abt_id;

Line 9076: pnp_debug_pkg.log('invoice '||inv_date_tab(i).inv_flag||inv_date_tab(i).inv_date||inv_date_tab(i).period_id);

9072:
9073: l_inv_id:=NULL;
9074: l_prev_inv_id :=NULL;
9075: IF (inv_date_tab(i).inv_flag ='Y') THEN
9076: pnp_debug_pkg.log('invoice '||inv_date_tab(i).inv_flag||inv_date_tab(i).inv_date||inv_date_tab(i).period_id);
9077:
9078: FOR rec IN check_inv_exists(p_var_rent_id ,inv_date_tab(i).inv_date,inv_date_tab(i).period_id) LOOP
9079: l_inv_id:= rec.inv_id;
9080: END LOOP;

Line 9081: pnp_debug_pkg.log('invoice id= '||l_inv_id);

9077:
9078: FOR rec IN check_inv_exists(p_var_rent_id ,inv_date_tab(i).inv_date,inv_date_tab(i).period_id) LOOP
9079: l_inv_id:= rec.inv_id;
9080: END LOOP;
9081: pnp_debug_pkg.log('invoice id= '||l_inv_id);
9082:
9083: IF i=1 THEN
9084: l_prev_inv_id:=l_fst_inv_id;
9085: ELSE

Line 9131: pnp_debug_pkg.log('+++++++++ ROLL_FWD_PARTIAL_PRD END +++++++++++');

9127:
9128: END IF;
9129: END IF;
9130: END LOOP;
9131: pnp_debug_pkg.log('+++++++++ ROLL_FWD_PARTIAL_PRD END +++++++++++');
9132: END ROLL_FWD_PARTIAL_PRD;
9133: --------------------------------------------------------------------------------
9134: -- NAME : ROLL_FWD_LST_PARTIAL_PRD
9135: -- DESCRIPTION : Rolls forward the abatement selections when the last partial

Line 9222: pnp_debug_pkg.log('+++++++++ ROLL_FWD_LST_PARTIAL_PRD START +++++++++++');

9218: l_var_abmt_id NUMBER :=NULL;
9219: l_last_inv_dt DATE :=NULL;
9220: j NUMBER :=NULL;
9221: BEGIN
9222: pnp_debug_pkg.log('+++++++++ ROLL_FWD_LST_PARTIAL_PRD START +++++++++++');
9223:
9224: --1. Get last partial period id
9225: --2. Get invoice date for the last invoice of this partial period whose grp end date is
9226: -- Variable Rent Agreement's termination date

Line 9241: --pnp_debug_pkg.log('last period id= '||l_last_prd_id);

9237: FOR last_prd_rec IN get_last_partial_prd(p_var_rent_id) LOOP
9238: l_last_prd_id := last_prd_rec.period_id;
9239: END LOOP;
9240:
9241: --pnp_debug_pkg.log('last period id= '||l_last_prd_id);
9242:
9243: IF l_last_prd_id IS NOT NULL THEN
9244:
9245: FOR rec IN get_inv_date(p_var_rent_id,l_last_prd_id,g_vr_termination_date) LOOP

Line 9262: --pnp_debug_pkg.log('last invoice id= '||l_last_inv_id);

9258:
9259: FOR last_inv_rec IN get_last_invoice_id(p_var_rent_id,l_last_prd_id,inv_date_tab(j).inv_date) LOOP
9260: l_last_inv_id := last_inv_rec.var_rent_inv_id;
9261: END LOOP;
9262: --pnp_debug_pkg.log('last invoice id= '||l_last_inv_id);
9263:
9264: FOR inv_rec IN get_last_prd_inv(p_var_rent_id,l_last_prd_id,l_last_inv_id) LOOP
9265: l_inv_id := inv_rec.var_rent_inv_id;
9266: --pnp_debug_pkg.log('invoice id = '||l_inv_id);

Line 9266: --pnp_debug_pkg.log('invoice id = '||l_inv_id);

9262: --pnp_debug_pkg.log('last invoice id= '||l_last_inv_id);
9263:
9264: FOR inv_rec IN get_last_prd_inv(p_var_rent_id,l_last_prd_id,l_last_inv_id) LOOP
9265: l_inv_id := inv_rec.var_rent_inv_id;
9266: --pnp_debug_pkg.log('invoice id = '||l_inv_id);
9267:
9268: FOR abtmt_inv_rec IN get_abtmt_terms_inv(l_inv_id) LOOP
9269: l_pmt_term_id := abtmt_inv_rec.payment_term_id;
9270:

Line 9304: pnp_debug_pkg.log('+++++++++ ROLL_FWD_LST_PARTIAL_PRD END +++++++++++');

9300:
9301: END IF;
9302:
9303: END IF;
9304: pnp_debug_pkg.log('+++++++++ ROLL_FWD_LST_PARTIAL_PRD END +++++++++++');
9305: END ROLL_FWD_LST_PARTIAL_PRD;
9306:
9307: --------------------------------------------------------------------------------
9308: -- NAME : ROLL_FWD_SELECNS

Line 9396: pnp_debug_pkg.log('+++++++++ ROLL_FWD_SELECNS START +++++++++++');

9392: WHERE var_rent_id =p_var_rent_id;
9393:
9394: BEGIN
9395: /* Get 1st invoice */
9396: pnp_debug_pkg.log('+++++++++ ROLL_FWD_SELECNS START +++++++++++');
9397:
9398: FOR rec IN org_cur(p_var_rent_id) LOOP
9399: l_org_id := rec.org_id;
9400: END LOOP;

Line 9405: --pnp_debug_pkg.log('1st invoice date= '||l_fst_inv_dt);

9401:
9402: FOR min_inv_rec IN get_min_inv(p_var_rent_id) LOOP
9403: l_fst_inv_dt := min_inv_rec.fst_inv_dt;
9404: END LOOP;
9405: --pnp_debug_pkg.log('1st invoice date= '||l_fst_inv_dt);
9406:
9407: FOR i IN 1..inv_date_tab.COUNT LOOP
9408:
9409: l_inv_id:=NULL;

Line 9413: --pnp_debug_pkg.log('invoice '||inv_date_tab(i).inv_flag||inv_date_tab(i).inv_date||p_var_rent_id);

9409: l_inv_id:=NULL;
9410: l_prev_inv_id :=NULL;
9411:
9412: IF (inv_date_tab(i).inv_flag ='Y') THEN
9413: --pnp_debug_pkg.log('invoice '||inv_date_tab(i).inv_flag||inv_date_tab(i).inv_date||p_var_rent_id);
9414:
9415: FOR rec IN check_inv_exists(p_var_rent_id ,inv_date_tab(i).inv_date,inv_date_tab(i).period_id) LOOP
9416: l_inv_id:= rec.inv_id;
9417: END LOOP;

Line 9418: --pnp_debug_pkg.log('invoice id= '||l_inv_id);

9414:
9415: FOR rec IN check_inv_exists(p_var_rent_id ,inv_date_tab(i).inv_date,inv_date_tab(i).period_id) LOOP
9416: l_inv_id:= rec.inv_id;
9417: END LOOP;
9418: --pnp_debug_pkg.log('invoice id= '||l_inv_id);
9419:
9420: IF (inv_date_tab(i).inv_date=l_fst_inv_dt) THEN
9421: /* updation for 1st invoice */
9422:

Line 9430: --pnp_debug_pkg.log('prior to update');

9426: FOR abtmt_exists_rec IN get_var_abtmt_id(p_var_rent_id) LOOP
9427:
9428: l_min_var_abt_id:= abtmt_exists_rec.var_abatement_id;
9429: l_min_pmt_term_id:= abtmt_exists_rec.payment_term_id;
9430: --pnp_debug_pkg.log('prior to update');
9431:
9432: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9433: UPDATE pn_var_abatements_all
9434: SET var_rent_inv_id=l_inv_id

Line 9489: pnp_debug_pkg.log('+++++++++ ROLL_FWD_SELECNS END +++++++++++');

9485: END IF;
9486: END IF;
9487:
9488: END LOOP;
9489: pnp_debug_pkg.log('+++++++++ ROLL_FWD_SELECNS END +++++++++++');
9490: END ROLL_FWD_SELECNS;
9491: --------------------------------------------------------------------------------
9492: -- NAME : include_increases_firstyr
9493: -- DESCRIPTION : Includes Rent Increase terms to be abated for 1st partial period

Line 9567: pnp_debug_pkg.log('+++++++++ include_increases_firstyr START +++++++++++');

9563: l_var_abmt_id NUMBER := NULL;
9564: l_org_id NUMBER;
9565:
9566: BEGIN
9567: pnp_debug_pkg.log('+++++++++ include_increases_firstyr START +++++++++++');
9568: FOR rec IN org_cur(p_var_rent_id) LOOP
9569: l_org_id := rec.org_id;
9570: END LOOP;
9571: IF g_partial_prd_flag='Y' THEN

Line 9577: --pnp_debug_pkg.log('invoice_id = '||l_inv_id);

9573: FOR fst_inv_rec IN get_fst_inv_id(p_var_rent_id) LOOP
9574: l_inv_id := fst_inv_rec.var_rent_inv_id;
9575: END LOOP;
9576:
9577: --pnp_debug_pkg.log('invoice_id = '||l_inv_id);
9578: FOR parent_rec IN get_abtmt_terms_inv(l_inv_id ,p_var_rent_id ) LOOP
9579:
9580: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);
9581: FOR rent_incr IN get_rent_incr_cur(parent_rec.payment_term_id ,l_inv_id ) LOOP

Line 9580: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);

9576:
9577: --pnp_debug_pkg.log('invoice_id = '||l_inv_id);
9578: FOR parent_rec IN get_abtmt_terms_inv(l_inv_id ,p_var_rent_id ) LOOP
9579:
9580: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);
9581: FOR rent_incr IN get_rent_incr_cur(parent_rec.payment_term_id ,l_inv_id ) LOOP
9582:
9583: --pnp_debug_pkg.log('child_term = '||rent_incr.rent_incr_term_id);
9584: l_abtmt_exists := NULL;

Line 9583: --pnp_debug_pkg.log('child_term = '||rent_incr.rent_incr_term_id);

9579:
9580: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);
9581: FOR rent_incr IN get_rent_incr_cur(parent_rec.payment_term_id ,l_inv_id ) LOOP
9582:
9583: --pnp_debug_pkg.log('child_term = '||rent_incr.rent_incr_term_id);
9584: l_abtmt_exists := NULL;
9585:
9586: OPEN check_abtmt_exists(rent_incr.rent_incr_term_id,l_inv_id);
9587: FETCH check_abtmt_exists INTO l_abtmt_exists ;

Line 9615: pnp_debug_pkg.log('+++++++++ include_increases_firstyr END +++++++++++');

9611: END LOOP;
9612:
9613: END LOOP;
9614: END IF;
9615: pnp_debug_pkg.log('+++++++++ include_increases_firstyr END +++++++++++');
9616: END include_increases_firstyr;
9617: --------------------------------------------------------------------------------
9618: -- NAME : include_increases
9619: -- DESCRIPTION : Includes Rent Increase terms to be abated

Line 9693: pnp_debug_pkg.log('+++++++++ include_increases START +++++++++++');

9689: l_var_abmt_id NUMBER := NULL;
9690: l_org_id NUMBER;
9691: BEGIN
9692:
9693: pnp_debug_pkg.log('+++++++++ include_increases START +++++++++++');
9694: FOR rec IN org_cur(p_var_rent_id) LOOP
9695: l_org_id := rec.org_id;
9696: END LOOP;
9697:

Line 9704: --pnp_debug_pkg.log('invoice_id = '||l_inv_id);

9700: IF (inv_date_tab(i).inv_flag ='Y') THEN
9701: FOR rec IN check_inv_exists(p_var_rent_id ,inv_date_tab(i).inv_date,inv_date_tab(i).period_id) LOOP
9702: l_inv_id:= rec.inv_id;
9703: END LOOP;
9704: --pnp_debug_pkg.log('invoice_id = '||l_inv_id);
9705:
9706: FOR parent_rec IN get_abtmt_terms_inv(l_inv_id ,p_var_rent_id ) LOOP
9707:
9708: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);

Line 9708: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);

9704: --pnp_debug_pkg.log('invoice_id = '||l_inv_id);
9705:
9706: FOR parent_rec IN get_abtmt_terms_inv(l_inv_id ,p_var_rent_id ) LOOP
9707:
9708: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);
9709:
9710: FOR rent_incr IN get_rent_incr_cur(parent_rec.payment_term_id ,l_inv_id ) LOOP
9711:
9712: --pnp_debug_pkg.log('child_term = '||rent_incr.rent_incr_term_id);

Line 9712: --pnp_debug_pkg.log('child_term = '||rent_incr.rent_incr_term_id);

9708: --pnp_debug_pkg.log('parent term = '||parent_rec.payment_term_id);
9709:
9710: FOR rent_incr IN get_rent_incr_cur(parent_rec.payment_term_id ,l_inv_id ) LOOP
9711:
9712: --pnp_debug_pkg.log('child_term = '||rent_incr.rent_incr_term_id);
9713:
9714: l_abtmt_exists := NULL;
9715: OPEN check_abtmt_exists(rent_incr.rent_incr_term_id,l_inv_id);
9716: FETCH check_abtmt_exists INTO l_abtmt_exists ;

Line 9747: pnp_debug_pkg.log('+++++++++ include_increases END +++++++++++');

9743:
9744: END LOOP;
9745: END IF;
9746: END LOOP;
9747: pnp_debug_pkg.log('+++++++++ include_increases END +++++++++++');
9748: END include_increases;
9749:
9750: --------------------------------------------------------------------------------
9751: -- NAME : post_summary - global procedure

Line 9847: pnp_debug_pkg.log('+++++++++ post_summary START +++++++++++');

9843: l_vr_summ_id NUMBER;
9844:
9845: BEGIN
9846:
9847: pnp_debug_pkg.log('+++++++++ post_summary START +++++++++++');
9848:
9849: l_grp_t.DELETE;
9850:
9851: OPEN grp_date_c( p_vr_id => p_var_rent_id

Line 9861: pnp_debug_pkg.log('line_rec.line_item_id...'||line_rec.line_item_id);

9857: FOR line_rec IN lines_c( p_vr_id => p_var_rent_id
9858: ,p_prd_id => p_period_id)
9859: LOOP
9860:
9861: pnp_debug_pkg.log('line_rec.line_item_id...'||line_rec.line_item_id);
9862: /* loop for all calc periods in the annual period */
9863: FOR g IN 1..l_grp_t.COUNT LOOP
9864:
9865: /* get the sum of rents and sales for

Line 9870: pnp_debug_pkg.log('g..'||g);

9866: vr -> period -> line item -> group combination
9867: from the trx tables
9868: -- loops only once --
9869: */
9870: pnp_debug_pkg.log('g..'||g);
9871: FOR summ_rec IN summ_c( p_vr_id => p_var_rent_id
9872: ,p_prd_id => p_period_id
9873: ,p_line_id => line_rec.line_item_id
9874: ,p_grp_id => l_grp_t(g).grp_date_id)

Line 9877: pnp_debug_pkg.log('summ_rec.sales..'||summ_rec.sales);

9873: ,p_line_id => line_rec.line_item_id
9874: ,p_grp_id => l_grp_t(g).grp_date_id)
9875: LOOP
9876:
9877: pnp_debug_pkg.log('summ_rec.sales..'||summ_rec.sales);
9878: pnp_debug_pkg.log('summ_rec.rent..'||summ_rec.rent);
9879: pnp_debug_pkg.log('summ_rec.first_yr_rent..'||summ_rec.first_yr_rent);
9880: l_vr_summ_id := NULL;
9881:

Line 9878: pnp_debug_pkg.log('summ_rec.rent..'||summ_rec.rent);

9874: ,p_grp_id => l_grp_t(g).grp_date_id)
9875: LOOP
9876:
9877: pnp_debug_pkg.log('summ_rec.sales..'||summ_rec.sales);
9878: pnp_debug_pkg.log('summ_rec.rent..'||summ_rec.rent);
9879: pnp_debug_pkg.log('summ_rec.first_yr_rent..'||summ_rec.first_yr_rent);
9880: l_vr_summ_id := NULL;
9881:
9882: /* chk if VR SUMM record exists for this

Line 9879: pnp_debug_pkg.log('summ_rec.first_yr_rent..'||summ_rec.first_yr_rent);

9875: LOOP
9876:
9877: pnp_debug_pkg.log('summ_rec.sales..'||summ_rec.sales);
9878: pnp_debug_pkg.log('summ_rec.rent..'||summ_rec.rent);
9879: pnp_debug_pkg.log('summ_rec.first_yr_rent..'||summ_rec.first_yr_rent);
9880: l_vr_summ_id := NULL;
9881:
9882: /* chk if VR SUMM record exists for this
9883: vr -> period -> line item -> group combination */

Line 9892: pnp_debug_pkg.log('l_vr_summ_id..'||l_vr_summ_id);

9888: LOOP
9889:
9890: l_vr_summ_id := vr_summ_rec.var_rent_summ_id;
9891:
9892: pnp_debug_pkg.log('l_vr_summ_id..'||l_vr_summ_id);
9893:
9894: IF summ_rec.sales <> NVL(vr_summ_rec.tot_act_vol, 0) OR
9895: summ_rec.rent <> NVL(vr_summ_rec.act_var_rent, 0) OR
9896: summ_rec.first_yr_rent <> NVL(vr_summ_rec.first_yr_rent, 0) OR

Line 9900: pnp_debug_pkg.log('before updation ...');

9896: summ_rec.first_yr_rent <> NVL(vr_summ_rec.first_yr_rent, 0) OR
9897: NVL(summ_rec.ded, 0) <> NVL(vr_summ_rec.tot_ded, 0)
9898: THEN
9899:
9900: pnp_debug_pkg.log('before updation ...');
9901: UPDATE
9902: pn_var_rent_summ_all
9903: SET
9904: tot_act_vol = summ_rec.sales

Line 9920: pnp_debug_pkg.log('before insertion ...');

9916: END LOOP; /* chk if VR SUMM exists vr -> prd -> line -> grp combo */
9917:
9918: IF l_vr_summ_id IS NULL THEN
9919:
9920: pnp_debug_pkg.log('before insertion ...');
9921:
9922: /* to insert a new summary record */
9923: INSERT INTO
9924: pn_var_rent_summ_all

Line 9986: pnp_debug_pkg.log('+++++++++ post_summary END +++++++++++');

9982: END LOOP; /* loop for all calc periods in the annual period */
9983:
9984: END LOOP; /* loop for all lines in the annual period */
9985:
9986: pnp_debug_pkg.log('+++++++++ post_summary END +++++++++++');
9987:
9988: EXCEPTION
9989: WHEN OTHERS THEN RAISE;
9990:

Line 10634: pnp_debug_pkg.log('+++++++++ VALIDATE_LY_CALC START +++++++++++');

10630: l_ly_calc NUMBER := NULL;
10631: l_new_term_date DATE;
10632:
10633: BEGIN
10634: pnp_debug_pkg.log('+++++++++ VALIDATE_LY_CALC START +++++++++++');
10635:
10636: FOR vr_length_rec IN vr_length
10637: LOOP
10638:

Line 10668: pnp_debug_pkg.log('+++++++++ VALIDATE_LY_CALC END +++++++++++');

10664: END LOOP;
10665:
10666: return l_ly_calc;
10667:
10668: pnp_debug_pkg.log('+++++++++ VALIDATE_LY_CALC END +++++++++++');
10669:
10670: END VALIDATE_LY_CALC;
10671: --------------------------------------------------------------------------------
10672: -- NAME : full_yr_summary