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

Line 182: pnp_debug_pkg.log('post_summary_trueup (+) .... ');

178: l_second_yr_id NUMBER;
179:
180: BEGIN
181:
182: pnp_debug_pkg.log('post_summary_trueup (+) .... ');
183:
184: FOR trueup_rec IN trueup_rent_c( p_vr_id => p_var_rent_id
185: ,p_prd_id => p_period_id)
186: LOOP

Line 189: pnp_debug_pkg.log('l_billed_rent:'||l_billed_rent);

185: ,p_prd_id => p_period_id)
186: LOOP
187:
188: l_billed_rent := trueup_rec.billed_rent;
189: pnp_debug_pkg.log('l_billed_rent:'||l_billed_rent);
190: /* Note:
191: Handling to take the rent for first year in account
192: while calculating the true up for second year in CYNP
193: and CYP */

Line 214: pnp_debug_pkg.log('l_billed_rent:'||l_billed_rent);

210: END IF;
211:
212: END IF;
213:
214: pnp_debug_pkg.log('l_billed_rent:'||l_billed_rent);
215: pnp_debug_pkg.log('trup_rent:'||trueup_rec.trueup_rent);
216:
217: UPDATE
218: pn_var_rent_summ_all

Line 215: pnp_debug_pkg.log('trup_rent:'||trueup_rec.trueup_rent);

211:
212: END IF;
213:
214: pnp_debug_pkg.log('l_billed_rent:'||l_billed_rent);
215: pnp_debug_pkg.log('trup_rent:'||trueup_rec.trueup_rent);
216:
217: UPDATE
218: pn_var_rent_summ_all
219: SET

Line 363: pnp_debug_pkg.log('+++++++Insert_invoice_trueup++++++++');

359: l_tot_period_rent NUMBER := NULL;
360: l_vr_termination_date DATE;
361:
362: BEGIN
363: pnp_debug_pkg.log('+++++++Insert_invoice_trueup++++++++');
364: FOR vr_rec IN org_c(p_vr_id => p_var_rent_id) LOOP
365: l_org_id := vr_rec.org_id;
366: l_vr_termination_date := vr_rec.termination_date;
367: END LOOP;

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

366: l_vr_termination_date := vr_rec.termination_date;
367: END LOOP;
368:
369: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(l_org_id),4);
370: pnp_debug_pkg.log('l_precision:'||l_precision);
371: FOR i IN 1..G_ABATED_RENT.COUNT LOOP
372: IF G_ABATED_RENT(i).period_id = p_period_id THEN
373: l_total_period_rent := G_ABATED_RENT(i).AMOUNT;
374: EXIT;

Line 401: pnp_debug_pkg.log('s** l_total_period_rent'||l_total_period_rent);

397: EXIT;
398: END IF;
399: END LOOP;
400:
401: pnp_debug_pkg.log('s** l_total_period_rent'||l_total_period_rent);
402: /* FOR summ_rec IN period_rent_c ( p_vr_id => p_var_rent_id
403: ,p_prd_id => p_period_id)
404: LOOP
405: l_total_period_rent

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

858: 1. Apply deffered negative rents.
859: 2. Apply allowances/Abatements.
860: 3. Apply/Allowances/Abatements.
861: */
862: pnp_debug_pkg.log('*apply_abatements start(+)*');
863: pnp_debug_pkg.log('p_flag:'||p_flag);
864: FOR rec IN order_c(p_var_rent_id) LOOP
865: l_abat_order := rec.ORDER_OF_APPL_CODE;
866: l_vr_termination_date := rec.termination_date;

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

859: 2. Apply allowances/Abatements.
860: 3. Apply/Allowances/Abatements.
861: */
862: pnp_debug_pkg.log('*apply_abatements start(+)*');
863: pnp_debug_pkg.log('p_flag:'||p_flag);
864: FOR rec IN order_c(p_var_rent_id) LOOP
865: l_abat_order := rec.ORDER_OF_APPL_CODE;
866: l_vr_termination_date := rec.termination_date;
867: l_org_id := rec.org_id;

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

892: G_UNABATED_RENT(G_UNABATED_RENT.COUNT).amount := l_abated_rent;
893: END IF;
894:
895: IF (l_abat_order = pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
896: pnp_debug_pkg.log('call pnp_debug_pkg.log');
897: PN_VAR_TRUEUP_PKG.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_allow_t, l_allow_tu_t, l_abated_rent);
898: pnp_debug_pkg.log('complete');
899: END IF;--Apply allowance.
900:

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

894:
895: IF (l_abat_order = pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
896: pnp_debug_pkg.log('call pnp_debug_pkg.log');
897: PN_VAR_TRUEUP_PKG.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_allow_t, l_allow_tu_t, l_abated_rent);
898: pnp_debug_pkg.log('complete');
899: END IF;--Apply allowance.
900:
901:
902: pnp_debug_pkg.log('call populate_abat');

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

898: pnp_debug_pkg.log('complete');
899: END IF;--Apply allowance.
900:
901:
902: pnp_debug_pkg.log('call populate_abat');
903: PN_VAR_TRUEUP_PKG.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);
904: pnp_debug_pkg.log('complete');
905:
906:

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

900:
901:
902: pnp_debug_pkg.log('call populate_abat');
903: PN_VAR_TRUEUP_PKG.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);
904: pnp_debug_pkg.log('complete');
905:
906:
907: pnp_debug_pkg.log('call apply_abat');
908: PN_VAR_TRUEUP_PKG.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);

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

903: PN_VAR_TRUEUP_PKG.populate_abat(p_var_rent_id , p_period_id, inv_rec.var_rent_inv_id);
904: pnp_debug_pkg.log('complete');
905:
906:
907: pnp_debug_pkg.log('call apply_abat');
908: PN_VAR_TRUEUP_PKG.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
909: pnp_debug_pkg.log('complete');
910:
911:

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

905:
906:
907: pnp_debug_pkg.log('call apply_abat');
908: PN_VAR_TRUEUP_PKG.apply_abat(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
909: pnp_debug_pkg.log('complete');
910:
911:
912: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
913: pnp_debug_pkg.log('call pnp_debug_pkg.log');

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

909: pnp_debug_pkg.log('complete');
910:
911:
912: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
913: pnp_debug_pkg.log('call pnp_debug_pkg.log');
914: PN_VAR_TRUEUP_PKG.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_allow_t, l_allow_tu_t, l_abated_rent);
915: pnp_debug_pkg.log('complete');
916: END IF;--Apply allowance
917:

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

911:
912: IF(l_abat_order <> pn_var_rent_calc_pkg.G_ALLOWANCE_FIRST) THEN
913: pnp_debug_pkg.log('call pnp_debug_pkg.log');
914: PN_VAR_TRUEUP_PKG.apply_allow(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_allow_t, l_allow_tu_t, l_abated_rent);
915: pnp_debug_pkg.log('complete');
916: END IF;--Apply allowance
917:
918:
919: pnp_debug_pkg.log('called populate_neg_rent');

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

915: pnp_debug_pkg.log('complete');
916: END IF;--Apply allowance
917:
918:
919: pnp_debug_pkg.log('called populate_neg_rent');
920: IF (inv_rec.true_up_amt IS NULL) THEN
921: PN_VAR_TRUEUP_PKG.populate_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
922: END IF;
923: pnp_debug_pkg.log('complete');

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

919: pnp_debug_pkg.log('called populate_neg_rent');
920: IF (inv_rec.true_up_amt IS NULL) THEN
921: PN_VAR_TRUEUP_PKG.populate_neg_rent(p_var_rent_id, p_period_id, inv_rec.var_rent_inv_id, l_abated_rent);
922: END IF;
923: pnp_debug_pkg.log('complete');
924:
925:
926: /* update the invoice */
927: IF (p_flag = 'CALCULATE') THEN

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

945: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
946: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
947:
948: -- Update the current invoice
949: pnp_debug_pkg.log('Abatements - updating');
950: UPDATE
951: pn_var_rent_inv_all
952: SET
953: actual_invoiced_amount = (round(l_abated_rent,l_precision) - round(l_prev_inv_exp,l_precision))

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

961: -- Insert a new invoice. This happens only if your rents changes as a result of
962: -- applied allowance/abat when you add them after some calc have been done.
963: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
964: --This can loop only once
965: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
966: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
967: pnp_debug_pkg.log('Abatements - inserting');
968: l_row_id := NULL;
969: l_var_rent_inv_id := NULL;

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

962: -- applied allowance/abat when you add them after some calc have been done.
963: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
964: --This can loop only once
965: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
966: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
967: pnp_debug_pkg.log('Abatements - inserting');
968: l_row_id := NULL;
969: l_var_rent_inv_id := NULL;
970: pn_var_rent_inv_pkg.insert_row

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

963: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
964: --This can loop only once
965: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
966: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
967: pnp_debug_pkg.log('Abatements - inserting');
968: l_row_id := NULL;
969: l_var_rent_inv_id := NULL;
970: pn_var_rent_inv_pkg.insert_row
971: ( x_rowid => l_row_id,

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

1042: ELSIF ((l_abated_rent - l_prev_inv_exp)<>0) THEN
1043: -- Last invoice has been exported and an non zero adjustment terms needs to be created
1044: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
1045: --This can loop only once
1046: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
1047: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1048: pnp_debug_pkg.log('Abatements - inserting');
1049: l_row_id := NULL;
1050: l_var_rent_inv_id := NULL;

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

1043: -- Last invoice has been exported and an non zero adjustment terms needs to be created
1044: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
1045: --This can loop only once
1046: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
1047: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1048: pnp_debug_pkg.log('Abatements - inserting');
1049: l_row_id := NULL;
1050: l_var_rent_inv_id := NULL;
1051: pn_var_rent_inv_pkg.insert_row

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

1044: FOR inv_all_rec IN inv_all_c(inv_rec.var_rent_inv_id) LOOP
1045: --This can loop only once
1046: pnp_debug_pkg.log('l_prev_inv_exp:'||l_prev_inv_exp);
1047: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1048: pnp_debug_pkg.log('Abatements - inserting');
1049: l_row_id := NULL;
1050: l_var_rent_inv_id := NULL;
1051: pn_var_rent_inv_pkg.insert_row
1052: ( x_rowid => l_row_id,

Line 1104: pnp_debug_pkg.log('apply_abatements end(-)');

1100: END IF;
1101:
1102: END IF;
1103: END LOOP;--Loop for all required invoices.
1104: pnp_debug_pkg.log('apply_abatements end(-)');
1105:
1106: EXCEPTION
1107: WHEN others THEN
1108: pnp_debug_pkg.log('Raised exception');

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

1104: pnp_debug_pkg.log('apply_abatements end(-)');
1105:
1106: EXCEPTION
1107: WHEN others THEN
1108: pnp_debug_pkg.log('Raised exception');
1109: RAISE;
1110: END;
1111:
1112:

Line 1137: pnp_debug_pkg.log('get_dated_allow start (+)');

1133: l_count NUMBER := 1;
1134: empty_rec ALLOW_REC;
1135: BEGIN
1136: --
1137: pnp_debug_pkg.log('get_dated_allow start (+)');
1138: IF (p_allow_t.COUNT > 0) THEN
1139: --
1140: FOR i IN 1..p_allow_t.COUNT LOOP
1141: pnp_debug_pkg.log('get_dated_allow 1');

Line 1141: pnp_debug_pkg.log('get_dated_allow 1');

1137: pnp_debug_pkg.log('get_dated_allow start (+)');
1138: IF (p_allow_t.COUNT > 0) THEN
1139: --
1140: FOR i IN 1..p_allow_t.COUNT LOOP
1141: pnp_debug_pkg.log('get_dated_allow 1');
1142: IF(p_allow_t(i).start_date <= p_end_date
1143: AND NVL(p_allow_t(i).end_date, p_end_date) >= p_start_date) THEN
1144: l_allow_t(l_count) := p_allow_t(i);
1145: l_count := l_count + 1;

Line 1147: pnp_debug_pkg.log('get_dated_allow 2');

1143: AND NVL(p_allow_t(i).end_date, p_end_date) >= p_start_date) THEN
1144: l_allow_t(l_count) := p_allow_t(i);
1145: l_count := l_count + 1;
1146: END IF;
1147: pnp_debug_pkg.log('get_dated_allow 2');
1148: END LOOP;
1149: END IF;
1150: pnp_debug_pkg.log('get_dated_allow 3');
1151: IF (l_allow_t.COUNT >0) THEN

Line 1150: pnp_debug_pkg.log('get_dated_allow 3');

1146: END IF;
1147: pnp_debug_pkg.log('get_dated_allow 2');
1148: END LOOP;
1149: END IF;
1150: pnp_debug_pkg.log('get_dated_allow 3');
1151: IF (l_allow_t.COUNT >0) THEN
1152: RETURN l_allow_t;
1153: ELSE
1154: --

Line 1160: pnp_debug_pkg.log('get_dated_allow raised exception');

1156: RETURN l_allow_t;
1157: END IF;
1158: EXCEPTION
1159: WHEN others THEN
1160: pnp_debug_pkg.log('get_dated_allow raised exception');
1161: RAISE;
1162: END;
1163:
1164: --------------------------------------------------------------------------------

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

1246: l_abated_rent NUMBER;
1247: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;
1248: l_last_invoice_dt pn_var_grp_dates.invoice_date%TYPE;
1249: BEGIN
1250: pnp_debug_pkg.log('apply_def_neg_rent start(+)');
1251: -- Get the negative rent flag
1252: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
1253: l_negative_rent_flag := rec.negative_rent;
1254: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

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

1250: pnp_debug_pkg.log('apply_def_neg_rent start(+)');
1251: -- Get the negative rent flag
1252: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
1253: l_negative_rent_flag := rec.negative_rent;
1254: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);
1255: END LOOP;
1256: -- Get the last invoice_date
1257: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
1258: l_last_invoice_dt := rec.inv_date;

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

1255: END LOOP;
1256: -- Get the last invoice_date
1257: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
1258: l_last_invoice_dt := rec.inv_date;
1259: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
1260: END LOOP;
1261:
1262: PNP_DEBUG_PKg.log('p_period_id:'||p_period_id);
1263: PNP_DEBUG_PKG.log('p_var_rent_id:'||p_var_rent_id);

Line 1262: PNP_DEBUG_PKg.log('p_period_id:'||p_period_id);

1258: l_last_invoice_dt := rec.inv_date;
1259: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
1260: END LOOP;
1261:
1262: PNP_DEBUG_PKg.log('p_period_id:'||p_period_id);
1263: PNP_DEBUG_PKG.log('p_var_rent_id:'||p_var_rent_id);
1264:
1265: -- Loop for all invoices.
1266: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP

Line 1263: PNP_DEBUG_PKG.log('p_var_rent_id:'||p_var_rent_id);

1259: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
1260: END LOOP;
1261:
1262: PNP_DEBUG_PKg.log('p_period_id:'||p_period_id);
1263: PNP_DEBUG_PKG.log('p_var_rent_id:'||p_var_rent_id);
1264:
1265: -- Loop for all invoices.
1266: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
1267: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

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

1263: PNP_DEBUG_PKG.log('p_var_rent_id:'||p_var_rent_id);
1264:
1265: -- Loop for all invoices.
1266: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
1267: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
1268: l_negative_rent := 0;
1269: l_negative_available := 0;
1270: l_negative_applied := 0;
1271: l_abated_rent :=inv_rec.constr_actual_rent;

Line 1274: PNP_DEBUG_PKG.log('inv_rec.invoice_date:'||inv_rec.invoice_date);

1270: l_negative_applied := 0;
1271: l_abated_rent :=inv_rec.constr_actual_rent;
1272:
1273:
1274: PNP_DEBUG_PKG.log('inv_rec.invoice_date:'||inv_rec.invoice_date);
1275: -- Get available negative rent.
1276: FOR rec IN csr_neg_avail(p_var_rent_id, inv_rec.invoice_date) LOOP
1277: l_negative_available :=rec.negative_available;
1278: pnp_debug_pkg.log('l_negative_available'||l_negative_available);

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

1274: PNP_DEBUG_PKG.log('inv_rec.invoice_date:'||inv_rec.invoice_date);
1275: -- Get available negative rent.
1276: FOR rec IN csr_neg_avail(p_var_rent_id, inv_rec.invoice_date) LOOP
1277: l_negative_available :=rec.negative_available;
1278: pnp_debug_pkg.log('l_negative_available'||l_negative_available);
1279: END LOOP;
1280:
1281: -- Get applied negative rent
1282: FOR rec IN csr_neg_appl (p_var_rent_id, inv_rec.invoice_date) LOOP

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

1280:
1281: -- Get applied negative rent
1282: FOR rec IN csr_neg_appl (p_var_rent_id, inv_rec.invoice_date) LOOP
1283: l_negative_applied := rec.negative_applied;
1284: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);
1285: END LOOP;
1286:
1287: l_negative_remaining := ABS(l_negative_available - l_negative_applied);
1288: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);

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

1284: pnp_debug_pkg.log('l_negative_applied:'||l_negative_applied);
1285: END LOOP;
1286:
1287: l_negative_remaining := ABS(l_negative_available - l_negative_applied);
1288: pnp_debug_pkg.log('l_negative_remaining:'||l_negative_remaining);
1289: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_DEFER) THEN
1290: -- Deffered negative rent can be applied only when consT-rent >0
1291: IF (l_last_invoice_dt <> inv_rec.invoice_date AND inv_rec.constr_actual_rent > 0) THEN
1292: --This invoice is not the last invoice

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

1290: -- Deffered negative rent can be applied only when consT-rent >0
1291: IF (l_last_invoice_dt <> inv_rec.invoice_date AND inv_rec.constr_actual_rent > 0) THEN
1292: --This invoice is not the last invoice
1293: l_abated_rent := GREATEST(0, inv_rec.constr_actual_rent - l_negative_remaining);
1294: pnp_debug_pkg.log('l_abated_rent1:'||l_abated_rent);
1295: IF (inv_rec.constr_actual_rent > l_abated_rent) THEN
1296: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
1297: ELSE
1298: l_negative_rent := 0;

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

1301:
1302: ELSIF (l_last_invoice_dt = inv_rec.invoice_date) THEN
1303: --This is the last invoice. All deffered negative rent needs to be added
1304: l_abated_rent := inv_rec.constr_actual_rent - l_negative_remaining;
1305: pnp_debug_pkg.log('l_abated_rent2:'||l_abated_rent);
1306: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
1307: END IF;
1308: END IF;
1309: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

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

1305: pnp_debug_pkg.log('l_abated_rent2:'||l_abated_rent);
1306: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
1307: END IF;
1308: END IF;
1309: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1310: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
1311: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
1312:
1313: UPDATE pn_var_rent_inv_all

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

1306: l_negative_rent := inv_rec.constr_actual_rent - l_abated_rent;
1307: END IF;
1308: END IF;
1309: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1310: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
1311: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
1312:
1313: UPDATE pn_var_rent_inv_all
1314: SET negative_rent = l_negative_rent

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

1307: END IF;
1308: END IF;
1309: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1310: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
1311: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
1312:
1313: UPDATE pn_var_rent_inv_all
1314: SET negative_rent = l_negative_rent
1315: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;

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

1314: SET negative_rent = l_negative_rent
1315: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
1316: x_abated_rent := l_abated_rent;
1317: END LOOP;
1318: pnp_debug_pkg.log('apply_def_neg_rent end(-)');
1319:
1320: EXCEPTION
1321: --
1322: WHEN others THEN

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

1319:
1320: EXCEPTION
1321: --
1322: WHEN others THEN
1323: pnp_debug_pkg.log('Raised exception');
1324: RAISE;
1325: END;
1326:
1327:

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

1384: l_abated_rent NUMBER;
1385: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;
1386: l_last_invoice_dt pn_var_grp_dates.invoice_date%TYPE;
1387: BEGIN
1388: pnp_debug_pkg.log('populate_neg_rent start(+)');
1389: -- Get the negative rent flag
1390: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
1391: l_negative_rent_flag := rec.negative_rent;
1392: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);

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

1388: pnp_debug_pkg.log('populate_neg_rent start(+)');
1389: -- Get the negative rent flag
1390: FOR rec IN csr_get_abt(p_var_rent_id) LOOP
1391: l_negative_rent_flag := rec.negative_rent;
1392: pnp_debug_pkg.log('l_negative_rent_flag:'||l_negative_rent_flag);
1393: END LOOP;
1394: -- Get the last invoice_date
1395: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
1396: l_last_invoice_dt := rec.inv_date;

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

1393: END LOOP;
1394: -- Get the last invoice_date
1395: FOR rec IN csr_last_inv(p_var_rent_id) LOOP
1396: l_last_invoice_dt := rec.inv_date;
1397: pnp_debug_pkg.log('l_last_invoice_dt:'||l_last_invoice_dt);
1398: END LOOP;
1399: -- Loop for all invoices.
1400: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
1401: IF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_IGNORE) THEN

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

1411: ELSIF (l_negative_rent_flag = pn_var_rent_calc_pkg.G_NEG_RENT_DEFER
1412: AND inv_rec.invoice_date = l_last_invoice_dt) THEN
1413: l_abated_rent := x_abated_rent;
1414: END IF;
1415: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1416: pnp_debug_pkg.log('l_neg_rent_def*:'||l_neg_rent_def);
1417: UPDATE pn_var_rent_inv_all
1418: SET def_neg_rent = l_neg_rent_def
1419: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;

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

1412: AND inv_rec.invoice_date = l_last_invoice_dt) THEN
1413: l_abated_rent := x_abated_rent;
1414: END IF;
1415: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1416: pnp_debug_pkg.log('l_neg_rent_def*:'||l_neg_rent_def);
1417: UPDATE pn_var_rent_inv_all
1418: SET def_neg_rent = l_neg_rent_def
1419: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
1420: x_abated_rent := l_abated_rent;

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

1418: SET def_neg_rent = l_neg_rent_def
1419: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
1420: x_abated_rent := l_abated_rent;
1421: END LOOP;
1422: pnp_debug_pkg.log('populate_neg_rent end(-)');
1423:
1424: EXCEPTION
1425: --
1426: WHEN others THEN

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

1423:
1424: EXCEPTION
1425: --
1426: WHEN others THEN
1427: pnp_debug_pkg.log('Raised exception');
1428: RAISE;
1429: END;
1430: --------------------------------------------------------------------------------
1431: -- NAME : apply_abat

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

1668: l_ly_max_prd_id NUMBER;
1669:
1670: BEGIN
1671: --
1672: pnp_debug_pkg.log('apply_abat start(+)');
1673: --The special cases this needs to handle are
1674: -- FY: The FY invoice would have invoice_date of next period.
1675: -- LY: Non last invoices are dummy, last invoice corresponds to the whole period.
1676: -- FLY: Both LY and FLY

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

1677: -- Get the proration type
1678: FOR proration_rec IN proration_type_c(p_var_rent_id) LOOP
1679: l_proration_type := proration_rec.proration_rule;
1680: END LOOP;
1681: pnp_debug_pkg.log('apply_abat start(+)');
1682: -- is this in ly first inv? No abatements should be applied to this invoice
1683: FOR ly_inv_rec IN ly_min_inv_c(p_var_rent_id) LOOP
1684: l_ly_max_inv_id := ly_inv_rec.var_rent_inv_id;
1685: l_ly_max_prd_id := ly_inv_rec.period_id;

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

1683: FOR ly_inv_rec IN ly_min_inv_c(p_var_rent_id) LOOP
1684: l_ly_max_inv_id := ly_inv_rec.var_rent_inv_id;
1685: l_ly_max_prd_id := ly_inv_rec.period_id;
1686: END LOOP;
1687: pnp_debug_pkg.log('l_ly_max_inv_id:'||l_ly_max_inv_id);
1688: pnp_debug_pkg.log('l_ly_max_prd_id:'||l_ly_max_prd_id);
1689:
1690:
1691:

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

1684: l_ly_max_inv_id := ly_inv_rec.var_rent_inv_id;
1685: l_ly_max_prd_id := ly_inv_rec.period_id;
1686: END LOOP;
1687: pnp_debug_pkg.log('l_ly_max_inv_id:'||l_ly_max_inv_id);
1688: pnp_debug_pkg.log('l_ly_max_prd_id:'||l_ly_max_prd_id);
1689:
1690:
1691:
1692: --For LY/FLY, if last period and not last invoice,

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

1691:
1692: --For LY/FLY, if last period and not last invoice,
1693: -- Invoices are dummy. Return immdiately.
1694: 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
1695: pnp_debug_pkg.log('Ly invoice, not last - return immedietly');
1696: RETURN;
1697: END IF;
1698: FOR abat_rec IN EXCESS_ABAT_C(p_var_rent_id) LOOP
1699: l_excess_abat := abat_rec.excess_abat_code;

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

1696: RETURN;
1697: END IF;
1698: FOR abat_rec IN EXCESS_ABAT_C(p_var_rent_id) LOOP
1699: l_excess_abat := abat_rec.excess_abat_code;
1700: pnp_debug_pkg.log('l_excess_abat:'||l_excess_abat);
1701: EXIT;
1702: END LOOP;
1703:
1704: -- Get the number of invoices in this period

Line 1707: pnp_debug_pkg.log('l_grp_in_prd:'||l_grp_in_prd);

1703:
1704: -- Get the number of invoices in this period
1705: FOR inv_in_prd_rec IN inv_in_prd_c(p_var_rent_id, p_period_id) LOOP
1706: l_grp_in_prd := inv_in_prd_rec.num_inv;
1707: pnp_debug_pkg.log('l_grp_in_prd:'||l_grp_in_prd);
1708: END LOOP;
1709: --
1710: FOR neg_rec IN neg_rent_c(p_var_rent_id) LOOP
1711: l_neg_rent := neg_rec.negative_rent;

Line 1712: pnp_debug_pkg.log('l_neg_rent:'||l_neg_rent);

1708: END LOOP;
1709: --
1710: FOR neg_rec IN neg_rent_c(p_var_rent_id) LOOP
1711: l_neg_rent := neg_rec.negative_rent;
1712: pnp_debug_pkg.log('l_neg_rent:'||l_neg_rent);
1713: END LOOP;
1714:
1715: --
1716: FOR fy_rec IN get_fy_inv_c(p_var_rent_id) LOOP

Line 1723: pnp_debug_pkg.log('l_last_inv_id:'||l_last_inv_id);

1719:
1720: --
1721: FOR ly_rec IN get_ly_inv_c(p_var_rent_id) LOOP
1722: l_last_inv_id := ly_rec.var_rent_inv_id;
1723: pnp_debug_pkg.log('l_last_inv_id:'||l_last_inv_id);
1724: END LOOP;
1725:
1726: FOR inv_rec IN invoices_c(p_var_rent_id , p_period_id, p_inv_id) LOOP
1727: -- update rec abatements.

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

1731: l_inv_end_date := inv_dates_rec.inv_end_date;
1732: END LOOP;
1733:
1734:
1735: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
1736:
1737: -- The special handling is if this is FL/LY special invoice and non true up.
1738: IF ((l_proration_type IN (pn_var_rent_calc_pkg.G_PRORUL_FY, pn_var_rent_calc_pkg.G_PRORUL_FLY) AND p_inv_id = l_first_inv_id)
1739: OR (l_proration_type IN (pn_var_rent_calc_pkg.G_PRORUL_LY, pn_var_rent_calc_pkg.G_PRORUL_FLY) AND p_inv_id = l_last_inv_id) ) THEN

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

1742: l_inv_start_date := inv_rec.start_date;
1743: l_inv_end_date := inv_rec.end_date;
1744: END LOOP;
1745: --
1746: pnp_debug_pkg.log('FY/LY modified dates');
1747: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);
1748: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
1749: FOR num_rec IN num_inv_c(p_inv_id) LOOP
1750: l_num_inv := num_rec.num_inv;

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

1743: l_inv_end_date := inv_rec.end_date;
1744: END LOOP;
1745: --
1746: pnp_debug_pkg.log('FY/LY modified dates');
1747: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);
1748: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
1749: FOR num_rec IN num_inv_c(p_inv_id) LOOP
1750: l_num_inv := num_rec.num_inv;
1751: END LOOP;

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

1744: END LOOP;
1745: --
1746: pnp_debug_pkg.log('FY/LY modified dates');
1747: pnp_debug_pkg.log('l_inv_start_date:'||l_inv_start_date);
1748: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
1749: FOR num_rec IN num_inv_c(p_inv_id) LOOP
1750: l_num_inv := num_rec.num_inv;
1751: END LOOP;
1752: pnp_debug_pkg.log('l_num_inv:'||l_num_inv);

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

1748: pnp_debug_pkg.log('l_inv_end_date:'||l_inv_end_date);
1749: FOR num_rec IN num_inv_c(p_inv_id) LOOP
1750: l_num_inv := num_rec.num_inv;
1751: END LOOP;
1752: pnp_debug_pkg.log('l_num_inv:'||l_num_inv);
1753:
1754: END IF;
1755: ELSIF (inv_rec.true_up_amt IS NOT NULL) THEN
1756: --

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

1760: END LOOP;
1761: END IF;
1762:
1763: l_rec_abat := inv_rec.rec_abatement;
1764: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
1765:
1766: IF (inv_rec.true_up_amt IS NOT NULL) THEN
1767: pnp_debug_pkg.log('zxc:');
1768: --

Line 1767: pnp_debug_pkg.log('zxc:');

1763: l_rec_abat := inv_rec.rec_abatement;
1764: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
1765:
1766: IF (inv_rec.true_up_amt IS NOT NULL) THEN
1767: pnp_debug_pkg.log('zxc:');
1768: --
1769: FOR i IN 1..G_ABATEMENT_APPLIED.COUNT LOOP
1770: IF G_ABATEMENT_APPLIED(i).PERIOD_ID = p_period_id THEN
1771: l_rec_abat := NVL(G_ABATEMENT_APPLIED(i).AMOUNT, 0);

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

1768: --
1769: FOR i IN 1..G_ABATEMENT_APPLIED.COUNT LOOP
1770: IF G_ABATEMENT_APPLIED(i).PERIOD_ID = p_period_id THEN
1771: l_rec_abat := NVL(G_ABATEMENT_APPLIED(i).AMOUNT, 0);
1772: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
1773: END IF;
1774:
1775: END LOOP;
1776:

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

1788: END LOOP;
1789:
1790: END IF;
1791:
1792: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);
1793: l_abated_rent := x_abated_rent;
1794: l_unabated_rent := x_abated_rent;
1795: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1796: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);

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

1791:
1792: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);
1793: l_abated_rent := x_abated_rent;
1794: l_unabated_rent := x_abated_rent;
1795: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1796: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
1797: FOR rec IN fixed_abat_c(p_var_rent_id, l_inv_start_date, l_inv_end_date) LOOP
1798: IF (inv_rec.true_up_amt IS NULL) THEN
1799: --Fixed abatement is same sum of fixed abatement.

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

1792: pnp_debug_pkg.log('l_abat_override:'||l_abat_override);
1793: l_abated_rent := x_abated_rent;
1794: l_unabated_rent := x_abated_rent;
1795: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1796: pnp_debug_pkg.log('l_rec_abat:'||l_rec_abat);
1797: FOR rec IN fixed_abat_c(p_var_rent_id, l_inv_start_date, l_inv_end_date) LOOP
1798: IF (inv_rec.true_up_amt IS NULL) THEN
1799: --Fixed abatement is same sum of fixed abatement.
1800: l_fixed_abat := rec.fixed_abat * l_num_inv;

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

1802: --Fixed abatement is total * number of invoices
1803: l_fixed_abat := rec.fixed_abat * l_grp_in_prd;
1804:
1805: END IF;
1806: pnp_debug_pkg.log('l_fixed_abat:'||l_fixed_abat);
1807: END LOOP;
1808: l_total_abat := l_fixed_abat + l_rec_abat;
1809: IF (l_abat_override IS NOT NULL) THEN
1810: l_total_abat := l_abat_override;

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

1809: IF (l_abat_override IS NOT NULL) THEN
1810: l_total_abat := l_abat_override;
1811: END IF;
1812:
1813: pnp_debug_pkg.log('l_total_abat:'||l_total_abat);
1814: IF (l_excess_abat = pn_var_rent_calc_pkg.G_EXC_ABAT_IGNORE
1815: AND x_abated_rent>0 ) THEN
1816: l_abated_rent := GREATEST(0, x_abated_rent - l_total_abat);
1817: ELSIF (l_excess_abat = pn_var_rent_calc_pkg.G_EXC_ABAT_NEG_RENT ) THEN

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

1817: ELSIF (l_excess_abat = pn_var_rent_calc_pkg.G_EXC_ABAT_NEG_RENT ) THEN
1818: l_abated_rent := x_abated_rent - l_total_abat;
1819: END IF;
1820: l_total_abat := l_unabated_rent - l_abated_rent;
1821: pnp_debug_pkg.log('total_abat_applied:'||l_total_abat);
1822: UPDATE pn_var_rent_inv_all
1823: SET rec_abatement = l_total_abat
1824: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
1825: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);

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

1821: pnp_debug_pkg.log('total_abat_applied:'||l_total_abat);
1822: UPDATE pn_var_rent_inv_all
1823: SET rec_abatement = l_total_abat
1824: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
1825: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
1826: x_abated_rent := l_abated_rent;
1827: IF inv_rec.var_rent_inv_id IS NULL THEN
1828: G_TOT_ABATEMENT(G_TOT_ABATEMENT.COUNT+1).period_id := p_period_id;
1829: G_TOT_ABATEMENT(G_TOT_ABATEMENT.COUNT).amount := l_total_abat;

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

1830:
1831: END IF;
1832:
1833: END LOOP;
1834: pnp_debug_pkg.log('apply_abat end(-)');
1835:
1836: EXCEPTION
1837: --
1838: WHEN others THEN

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

1835:
1836: EXCEPTION
1837: --
1838: WHEN others THEN
1839: pnp_debug_pkg.log('apply_abat end(-)');
1840: RAISE;
1841: END;
1842: --------------------------------------------------------------------------------
1843: -- NAME : apply_allow

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

1983: l_last_inv_id NUMBER;
1984:
1985:
1986: BEGIN
1987: pnp_debug_pkg.log('apply_allow start(+)');
1988:
1989: -- Special cases which need to be handled are
1990: -- FY/FLY first invoice AND LY/FLY last invoice.
1991: -- get first inv

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

2003: l_proration_type := vr_rec.proration_rule;
2004: END LOOP;
2005:
2006: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
2007: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2008: l_allow_applied_inv := inv_rec.abatement_appl;
2009: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2010: --
2011: IF (inv_rec.true_up_amt IS NULL) THEN

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

2005:
2006: FOR inv_rec IN invoices_c(p_var_rent_id, p_period_id, p_inv_id) LOOP
2007: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2008: l_allow_applied_inv := inv_rec.abatement_appl;
2009: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2010: --
2011: IF (inv_rec.true_up_amt IS NULL) THEN
2012: -- Apply allowance to non cumm rents
2013: pnp_debug_pkg.log('Non true up invoice');

Line 2013: pnp_debug_pkg.log('Non true up invoice');

2009: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2010: --
2011: IF (inv_rec.true_up_amt IS NULL) THEN
2012: -- Apply allowance to non cumm rents
2013: pnp_debug_pkg.log('Non true up invoice');
2014: FOR inv_dates_rec IN invoice_dates_c(p_var_rent_id, inv_rec.invoice_date) LOOP
2015: l_inv_start_date := inv_dates_rec.inv_start_date;
2016: l_inv_end_date := inv_dates_rec.inv_end_date;
2017: END LOOP;

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

2030: l_prev_abt_rent := x_abated_rent;
2031: FOR allow_rec IN rolling_allow_c(p_var_rent_id, l_inv_start_date, l_inv_end_date) LOOP
2032: --Allowances can only be applied if rent is >0
2033: IF (l_cur_abt_rent > 0) THEN
2034: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);
2035: l_allow_remain := allow_rec.rolling_allow -NVL(allow_rec.allow_applied,0);
2036: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2037: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2038: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);

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

2032: --Allowances can only be applied if rent is >0
2033: IF (l_cur_abt_rent > 0) THEN
2034: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);
2035: l_allow_remain := allow_rec.rolling_allow -NVL(allow_rec.allow_applied,0);
2036: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2037: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2038: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2039: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2040: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);

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

2034: pnp_debug_pkg.log('allow_rec.abatement_id'||allow_rec.abatement_id);
2035: l_allow_remain := allow_rec.rolling_allow -NVL(allow_rec.allow_applied,0);
2036: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2037: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2038: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2039: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2040: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2041: l_prev_abt_rent := l_cur_abt_rent;
2042: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);

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

2036: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2037: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2038: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2039: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2040: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2041: l_prev_abt_rent := l_cur_abt_rent;
2042: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2043: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2044: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);

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

2038: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2039: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2040: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2041: l_prev_abt_rent := l_cur_abt_rent;
2042: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2043: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2044: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2045: UPDATE pn_var_abat_defaults_all
2046: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied

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

2040: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2041: l_prev_abt_rent := l_cur_abt_rent;
2042: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2043: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2044: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2045: UPDATE pn_var_abat_defaults_all
2046: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied
2047: WHERE abatement_id = allow_rec.abatement_id;
2048: END IF;

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

2046: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied
2047: WHERE abatement_id = allow_rec.abatement_id;
2048: END IF;
2049: END LOOP;
2050: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);
2051: UPDATE pn_var_rent_inv_all
2052: SET abatement_appl = l_allow_applied_inv
2053: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
2054: x_abated_rent := l_cur_abt_rent;

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

2051: UPDATE pn_var_rent_inv_all
2052: SET abatement_appl = l_allow_applied_inv
2053: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
2054: x_abated_rent := l_cur_abt_rent;
2055: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2056:
2057: ELSIF (inv_rec.true_up_amt IS NOT NULL) THEN
2058: pnp_debug_pkg.log('true up invoice');
2059: -- Apply allowance to true up rents

Line 2058: pnp_debug_pkg.log('true up invoice');

2054: x_abated_rent := l_cur_abt_rent;
2055: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2056:
2057: ELSIF (inv_rec.true_up_amt IS NOT NULL) THEN
2058: pnp_debug_pkg.log('true up invoice');
2059: -- Apply allowance to true up rents
2060: FOR inv_dates_rec IN invoice_dates_tu_c(p_var_rent_id, p_period_id) LOOP
2061: l_inv_start_date := inv_dates_rec.inv_start_date;
2062: l_inv_end_date := inv_dates_rec.inv_end_date;

Line 2070: pnp_debug_pkg.log('No allowances for this invoice. Exit');

2066: l_allow_tu_t := get_dated_allow(p_allow_tu_t, l_inv_start_date, l_inv_end_date);
2067: IF (l_allow_tu_t(1).abatement_id IS NULL) THEN
2068: --This will happen when there are now allowances. In this case we can skip
2069: --processing for this invoice.
2070: pnp_debug_pkg.log('No allowances for this invoice. Exit');
2071: RETURN;
2072: END IF;
2073:
2074: FOR i IN l_allow_tu_t.FIRST..l_allow_tu_t.LAST LOOP

Line 2078: pnp_debug_pkg.log('l_allow_rec.abatement_id'||l_allow_rec.abatement_id);

2074: FOR i IN l_allow_tu_t.FIRST..l_allow_tu_t.LAST LOOP
2075: --Allowances can only be applied if rent is >0
2076: l_allow_rec := l_allow_tu_t(i);
2077: IF (l_cur_abt_rent > 0) THEN
2078: pnp_debug_pkg.log('l_allow_rec.abatement_id'||l_allow_rec.abatement_id);
2079: l_allow_remain := l_allow_rec.rolling_allow -NVL(l_allow_rec.allow_applied,0);
2080: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2081: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2082: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);

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

2076: l_allow_rec := l_allow_tu_t(i);
2077: IF (l_cur_abt_rent > 0) THEN
2078: pnp_debug_pkg.log('l_allow_rec.abatement_id'||l_allow_rec.abatement_id);
2079: l_allow_remain := l_allow_rec.rolling_allow -NVL(l_allow_rec.allow_applied,0);
2080: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2081: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2082: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2083: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2084: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);

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

2078: pnp_debug_pkg.log('l_allow_rec.abatement_id'||l_allow_rec.abatement_id);
2079: l_allow_remain := l_allow_rec.rolling_allow -NVL(l_allow_rec.allow_applied,0);
2080: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2081: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2082: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2083: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2084: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2085: l_prev_abt_rent := l_cur_abt_rent;
2086: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);

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

2080: pnp_debug_pkg.log('l_allow_remain:'||l_allow_remain);
2081: l_cur_abt_rent := GREATEST(0,l_prev_abt_rent - l_allow_remain);
2082: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2083: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2084: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2085: l_prev_abt_rent := l_cur_abt_rent;
2086: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2087: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2088: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);

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

2082: pnp_debug_pkg.log('l_cur_abated_rent:'||l_cur_abt_rent);
2083: l_allow_applied := l_prev_abt_rent - l_cur_abt_rent;
2084: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2085: l_prev_abt_rent := l_cur_abt_rent;
2086: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2087: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2088: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2089: l_allow_tu_t(i).allow_applied := NVL(l_allow_tu_t(i).allow_applied,0)+l_allow_applied;
2090: END IF;

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

2084: pnp_debug_pkg.log('l_allow_applied'||l_allow_applied);
2085: l_prev_abt_rent := l_cur_abt_rent;
2086: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2087: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2088: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2089: l_allow_tu_t(i).allow_applied := NVL(l_allow_tu_t(i).allow_applied,0)+l_allow_applied;
2090: END IF;
2091: END LOOP;
2092: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);

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

2088: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2089: l_allow_tu_t(i).allow_applied := NVL(l_allow_tu_t(i).allow_applied,0)+l_allow_applied;
2090: END IF;
2091: END LOOP;
2092: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);
2093: G_ALLOWANCE_APPLIED(G_ALLOWANCE_APPLIED.COUNT+1).period_id := p_period_id;
2094: G_ALLOWANCE_APPLIED(G_ALLOWANCE_APPLIED.COUNT).amount := l_allow_applied_inv;
2095: pnp_debug_pkg.log('***l_allow_applied_inv:'||l_allow_applied_inv);
2096:

Line 2095: pnp_debug_pkg.log('***l_allow_applied_inv:'||l_allow_applied_inv);

2091: END LOOP;
2092: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);
2093: G_ALLOWANCE_APPLIED(G_ALLOWANCE_APPLIED.COUNT+1).period_id := p_period_id;
2094: G_ALLOWANCE_APPLIED(G_ALLOWANCE_APPLIED.COUNT).amount := l_allow_applied_inv;
2095: pnp_debug_pkg.log('***l_allow_applied_inv:'||l_allow_applied_inv);
2096:
2097:
2098: x_abated_rent := l_cur_abt_rent;
2099: --Whenever we have true up invoice, we need to reset allowances.

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

2103: SET allowance_applied = l_allow_tu_t(i).allow_applied
2104: WHERE abatement_id = l_allow_tu_t(i).abatement_id;
2105: END LOOP;
2106:
2107: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2108: END IF;
2109:
2110: END LOOP;
2111: pnp_debug_pkg.log('apply_allow end(-)');

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

2107: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
2108: END IF;
2109:
2110: END LOOP;
2111: pnp_debug_pkg.log('apply_allow end(-)');
2112: EXCEPTION
2113: WHEN others THEN
2114: RAISE;
2115: END;

Line 2209: pnp_debug_pkg.log('l_tu_inv_id:'||l_tu_inv_id);

2205:
2206: --
2207: FOR rec IN get_first_tu_c(p_period_id) LOOP
2208: l_tu_inv_id := rec.var_rent_inv_id;
2209: pnp_debug_pkg.log('l_tu_inv_id:'||l_tu_inv_id);
2210:
2211: END LOOP;
2212:
2213: --Populate for TU

Line 2230: pnp_debug_pkg.log('G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).period_id'||G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).period_id);

2226: ,l_max_grp_date
2227: ,'Y');
2228: G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT+1).period_id := p_period_id;
2229: G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount := l_rec_abatement;
2230: pnp_debug_pkg.log('G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).period_id'||G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).period_id);
2231: pnp_debug_pkg.log('G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount'||G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount);
2232:
2233: --
2234: /* FOR i IN 1..G_REC_ABATEMENT.COUNT LOOP

Line 2231: pnp_debug_pkg.log('G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount'||G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount);

2227: ,'Y');
2228: G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT+1).period_id := p_period_id;
2229: G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount := l_rec_abatement;
2230: pnp_debug_pkg.log('G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).period_id'||G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).period_id);
2231: pnp_debug_pkg.log('G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount'||G_ABATEMENT_APPLIED(G_ABATEMENT_APPLIED.COUNT).amount);
2232:
2233: --
2234: /* FOR i IN 1..G_REC_ABATEMENT.COUNT LOOP
2235: IF G_REC_ABATEMENT(i).PERIOD_ID = p_period_id THEN

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

2275: --------------------------------------------------------------------------------
2276: PROCEDURE reset_abatements(p_var_rent_id IN NUMBER
2277: ) IS
2278: BEGIN
2279: pnp_debug_pkg.log('Reset_abatement start(+)');
2280: UPDATE pn_var_abat_defaults_all
2281: SET allowance_applied =0
2282: WHERE var_rent_id = p_var_rent_id;
2283: UPDATE pn_var_rent_inv_all

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

2282: WHERE var_rent_id = p_var_rent_id;
2283: UPDATE pn_var_rent_inv_all
2284: SET abatement_appl =0
2285: WHERE var_rent_id = p_var_rent_id;
2286: pnp_debug_pkg.log('Reset_abatement end(-)');
2287:
2288: EXCEPTION
2289: WHEN others THEN
2290: RAISE;

Line 2467: pnp_debug_pkg.log('+++++ calculate_trueup - START +++++');

2463: l_neg_rent_flag VARCHAR2(30);
2464:
2465: BEGIN
2466:
2467: pnp_debug_pkg.log('+++++ calculate_trueup - START +++++');
2468: pnp_debug_pkg.log(' ');
2469:
2470: FOR vr_rec IN vr_c(p_vr_id => p_var_rent_id) LOOP
2471:

Line 2468: pnp_debug_pkg.log(' ');

2464:
2465: BEGIN
2466:
2467: pnp_debug_pkg.log('+++++ calculate_trueup - START +++++');
2468: pnp_debug_pkg.log(' ');
2469:
2470: FOR vr_rec IN vr_c(p_vr_id => p_var_rent_id) LOOP
2471:
2472: l_proration_rule := vr_rec.proration_rule;

Line 2492: pnp_debug_pkg.log('Period Details: ');

2488: LOOP
2489:
2490: l_prd_counter := l_prd_counter + 1;
2491:
2492: pnp_debug_pkg.log('Period Details: ');
2493: pnp_debug_pkg.log(' Period # : '||l_prd_counter);
2494: pnp_debug_pkg.log(' Period Start: '||prd_rec.start_date);
2495: pnp_debug_pkg.log(' Period End : '||prd_rec.end_date);
2496: pnp_debug_pkg.log(' ');

Line 2493: pnp_debug_pkg.log(' Period # : '||l_prd_counter);

2489:
2490: l_prd_counter := l_prd_counter + 1;
2491:
2492: pnp_debug_pkg.log('Period Details: ');
2493: pnp_debug_pkg.log(' Period # : '||l_prd_counter);
2494: pnp_debug_pkg.log(' Period Start: '||prd_rec.start_date);
2495: pnp_debug_pkg.log(' Period End : '||prd_rec.end_date);
2496: pnp_debug_pkg.log(' ');
2497:

Line 2494: pnp_debug_pkg.log(' Period Start: '||prd_rec.start_date);

2490: l_prd_counter := l_prd_counter + 1;
2491:
2492: pnp_debug_pkg.log('Period Details: ');
2493: pnp_debug_pkg.log(' Period # : '||l_prd_counter);
2494: pnp_debug_pkg.log(' Period Start: '||prd_rec.start_date);
2495: pnp_debug_pkg.log(' Period End : '||prd_rec.end_date);
2496: pnp_debug_pkg.log(' ');
2497:
2498: /* init the trueup rent for the period */

Line 2495: pnp_debug_pkg.log(' Period End : '||prd_rec.end_date);

2491:
2492: pnp_debug_pkg.log('Period Details: ');
2493: pnp_debug_pkg.log(' Period # : '||l_prd_counter);
2494: pnp_debug_pkg.log(' Period Start: '||prd_rec.start_date);
2495: pnp_debug_pkg.log(' Period End : '||prd_rec.end_date);
2496: pnp_debug_pkg.log(' ');
2497:
2498: /* init the trueup rent for the period */
2499: l_tot_trueup_rent := 0;

Line 2496: pnp_debug_pkg.log(' ');

2492: pnp_debug_pkg.log('Period Details: ');
2493: pnp_debug_pkg.log(' Period # : '||l_prd_counter);
2494: pnp_debug_pkg.log(' Period Start: '||prd_rec.start_date);
2495: pnp_debug_pkg.log(' Period End : '||prd_rec.end_date);
2496: pnp_debug_pkg.log(' ');
2497:
2498: /* init the trueup rent for the period */
2499: l_tot_trueup_rent := 0;
2500: --TODO

Line 2712: pnp_debug_pkg.log('');

2708: END IF; /* IF trueup_bkpt_t.COUNT > 0 THEN */
2709:
2710: END IF; /* IF l_net_trueup_volume <> 0 THEN */
2711:
2712: pnp_debug_pkg.log('');
2713: /* update the line trueup rent */
2714: l_line_trueup_rent := l_line_trueup_rent + l_part_trueup_rent;
2715:
2716: pnp_debug_pkg.log(' part_trueup_rent: '||l_part_trueup_rent);

Line 2716: pnp_debug_pkg.log(' part_trueup_rent: '||l_part_trueup_rent);

2712: pnp_debug_pkg.log('');
2713: /* update the line trueup rent */
2714: l_line_trueup_rent := l_line_trueup_rent + l_part_trueup_rent;
2715:
2716: pnp_debug_pkg.log(' part_trueup_rent: '||l_part_trueup_rent);
2717: pnp_debug_pkg.log(' ');
2718:
2719: END LOOP; /* loop for all resets for a line */
2720:

Line 2717: pnp_debug_pkg.log(' ');

2713: /* update the line trueup rent */
2714: l_line_trueup_rent := l_line_trueup_rent + l_part_trueup_rent;
2715:
2716: pnp_debug_pkg.log(' part_trueup_rent: '||l_part_trueup_rent);
2717: pnp_debug_pkg.log(' ');
2718:
2719: END LOOP; /* loop for all resets for a line */
2720:
2721: l_tot_trueup_rent := l_tot_trueup_rent + l_line_trueup_rent;

Line 2733: pnp_debug_pkg.log(' line_trueup_rent: '||l_line_trueup_rent);

2729: period_id = prd_rec.period_id AND
2730: line_item_id = line_rec.line_item_id AND
2731: calc_prd_end_date = prd_rec.end_date;
2732:
2733: pnp_debug_pkg.log(' line_trueup_rent: '||l_line_trueup_rent);
2734: pnp_debug_pkg.log(' ');
2735:
2736: END LOOP; /* loop for all lines in the period */
2737:

Line 2734: pnp_debug_pkg.log(' ');

2730: line_item_id = line_rec.line_item_id AND
2731: calc_prd_end_date = prd_rec.end_date;
2732:
2733: pnp_debug_pkg.log(' line_trueup_rent: '||l_line_trueup_rent);
2734: pnp_debug_pkg.log(' ');
2735:
2736: END LOOP; /* loop for all lines in the period */
2737:
2738: pnp_debug_pkg.log(' tot_trueup_rent for Period : '||l_tot_trueup_rent);

Line 2738: pnp_debug_pkg.log(' tot_trueup_rent for Period : '||l_tot_trueup_rent);

2734: pnp_debug_pkg.log(' ');
2735:
2736: END LOOP; /* loop for all lines in the period */
2737:
2738: pnp_debug_pkg.log(' tot_trueup_rent for Period : '||l_tot_trueup_rent);
2739: pnp_debug_pkg.log(' ');
2740: pn_var_trueup_pkg.post_summary_trueup
2741: ( p_var_rent_id => p_var_rent_id
2742: ,p_period_id => prd_rec.period_id

Line 2739: pnp_debug_pkg.log(' ');

2735:
2736: END LOOP; /* loop for all lines in the period */
2737:
2738: pnp_debug_pkg.log(' tot_trueup_rent for Period : '||l_tot_trueup_rent);
2739: pnp_debug_pkg.log(' ');
2740: pn_var_trueup_pkg.post_summary_trueup
2741: ( p_var_rent_id => p_var_rent_id
2742: ,p_period_id => prd_rec.period_id
2743: ,p_proration_rule => l_proration_rule);

Line 2858: pnp_debug_pkg.log('+++process_trueup_batch++++++');

2854: loc.property_id = prop.property_id AND
2855: prop.property_code = p_prop_code;
2856:
2857: BEGIN
2858: pnp_debug_pkg.log('+++*process_trueup_batch*++++++');
2859: /* init */
2860: IF p_lease_num_low IS NOT NULL THEN
2861: l_lease_num_low := p_lease_num_low;
2862: ELSE