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

Line 79: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');

75: l_abt_amt NUMBER;
76: l_true_up_amt NUMBER;
77:
78: BEGIN
79: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');
80: --
81: FOR tu_rec IN is_inv_tu_c(p_var_rent_inv_id) LOOP
82: l_true_up_amt := tu_rec.true_up_amt;
83: pnp_debug_pkg.log('l_true_up_amt'||l_true_up_amt);

Line 83: pnp_debug_pkg.log('l_true_up_amt'||l_true_up_amt);

79: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');
80: --
81: FOR tu_rec IN is_inv_tu_c(p_var_rent_inv_id) LOOP
82: l_true_up_amt := tu_rec.true_up_amt;
83: pnp_debug_pkg.log('l_true_up_amt'||l_true_up_amt);
84: END LOOP;
85:
86: IF l_true_up_amt IS NULL THEN
87: -- This is non true up amt

Line 88: pnp_debug_pkg.log('Non true up inv');

84: END LOOP;
85:
86: IF l_true_up_amt IS NULL THEN
87: -- This is non true up amt
88: pnp_debug_pkg.log('Non true up inv');
89: OPEN csr_get_amt;
90: FETCH csr_get_amt INTO l_abt_amt;
91: CLOSE csr_get_amt;
92: ELSE

Line 94: pnp_debug_pkg.log('true up inv');

90: FETCH csr_get_amt INTO l_abt_amt;
91: CLOSE csr_get_amt;
92: ELSE
93: -- This is true up amt
94: pnp_debug_pkg.log('true up inv');
95: OPEN csr_get_tu_amt;
96: FETCH csr_get_tu_amt INTO l_abt_amt;
97: CLOSE csr_get_tu_amt;
98: END IF;

Line 99: pnp_debug_pkg.log('Amount:'||l_abt_amt);

95: OPEN csr_get_tu_amt;
96: FETCH csr_get_tu_amt INTO l_abt_amt;
97: CLOSE csr_get_tu_amt;
98: END IF;
99: pnp_debug_pkg.log('Amount:'||l_abt_amt);
100: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');
101: RETURN l_abt_amt;
102: EXCEPTION
103: WHEN no_data_found THEN

Line 100: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');

96: FETCH csr_get_tu_amt INTO l_abt_amt;
97: CLOSE csr_get_tu_amt;
98: END IF;
99: pnp_debug_pkg.log('Amount:'||l_abt_amt);
100: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');
101: RETURN l_abt_amt;
102: EXCEPTION
103: WHEN no_data_found THEN
104: return 0;

Line 106: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

102: EXCEPTION
103: WHEN no_data_found THEN
104: return 0;
105: WHEN others THEN
106: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);
107: RAISE;
108:
109: END calc_abatement;
110:

Line 230: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');

226: l_min_prd_id NUMBER;
227:
228: BEGIN
229: l_true_up_amt := 0;
230: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (+) :');
231: --
232: FOR rec IN proration_type_c(p_var_rent_id) LOOP
233: l_proration_type := rec.proration_rule;
234: END LOOP;

Line 245: pnp_debug_pkg.log('l_true_up_amt'||l_true_up_amt);

241:
242: --
243: FOR tu_rec IN is_inv_tu_c(p_var_rent_inv_id) LOOP
244: l_true_up_amt := tu_rec.true_up_amt;
245: pnp_debug_pkg.log('l_true_up_amt'||l_true_up_amt);
246: END LOOP;
247:
248: IF l_true_up_amt IS NULL THEN
249: -- This is non true up amt

Line 250: pnp_debug_pkg.log('Non true up inv');

246: END LOOP;
247:
248: IF l_true_up_amt IS NULL THEN
249: -- This is non true up amt
250: pnp_debug_pkg.log('Non true up inv');
251: OPEN csr_get_amt(p_var_rent_inv_id, p_min_grp_dt, p_max_grp_dt);
252: FETCH csr_get_amt INTO l_abt_amt;
253: CLOSE csr_get_amt;
254: ELSE

Line 256: pnp_debug_pkg.log('true up inv');

252: FETCH csr_get_amt INTO l_abt_amt;
253: CLOSE csr_get_amt;
254: ELSE
255: -- This is true up amt
256: pnp_debug_pkg.log('true up inv');
257: --
258: l_abt_amt := 0;
259: FOR inv_in_prd_rec IN get_inv_in_prd(p_period_id) LOOP
260: --

Line 261: pnp_debug_pkg.log('inv_in_prd_rec.var_rent_inv_id:'||inv_in_prd_rec.var_rent_inv_id);

257: --
258: l_abt_amt := 0;
259: FOR inv_in_prd_rec IN get_inv_in_prd(p_period_id) LOOP
260: --
261: pnp_debug_pkg.log('inv_in_prd_rec.var_rent_inv_id:'||inv_in_prd_rec.var_rent_inv_id);
262: FOR inv_date_rec IN get_inv_date(inv_in_prd_rec.var_rent_inv_id) LOOP
263: l_inv_date := inv_date_rec.invoice_date;
264: END LOOP;
265: pnp_debug_pkg.log('l_inv_date:'||l_inv_date);

Line 265: pnp_debug_pkg.log('l_inv_date:'||l_inv_date);

261: pnp_debug_pkg.log('inv_in_prd_rec.var_rent_inv_id:'||inv_in_prd_rec.var_rent_inv_id);
262: FOR inv_date_rec IN get_inv_date(inv_in_prd_rec.var_rent_inv_id) LOOP
263: l_inv_date := inv_date_rec.invoice_date;
264: END LOOP;
265: pnp_debug_pkg.log('l_inv_date:'||l_inv_date);
266: l_min_grp_date := get_group_dt(l_inv_date, p_period_id, 'MIN');
267: l_max_grp_date := get_group_dt(l_inv_date, p_period_id, 'MAX');
268: IF (l_proration_type IN ('FY', 'FLY') AND p_period_id = l_min_prd_id) THEN
269: --

Line 278: pnp_debug_pkg.log('l_min_grp_date:'||l_min_grp_date);

274:
275:
276: END IF;
277:
278: pnp_debug_pkg.log('l_min_grp_date:'||l_min_grp_date);
279: pnp_debug_pkg.log('l_max_grp_date:'||l_max_grp_date);
280: --
281: FOR amt_rec IN csr_get_amt(inv_in_prd_rec.var_rent_inv_id, l_min_grp_date, l_max_grp_date) LOOP
282: l_abt_amt := l_abt_amt + amt_rec.amount;

Line 279: pnp_debug_pkg.log('l_max_grp_date:'||l_max_grp_date);

275:
276: END IF;
277:
278: pnp_debug_pkg.log('l_min_grp_date:'||l_min_grp_date);
279: pnp_debug_pkg.log('l_max_grp_date:'||l_max_grp_date);
280: --
281: FOR amt_rec IN csr_get_amt(inv_in_prd_rec.var_rent_inv_id, l_min_grp_date, l_max_grp_date) LOOP
282: l_abt_amt := l_abt_amt + amt_rec.amount;
283: END LOOP;

Line 284: pnp_debug_pkg.log('l_abt_amt:'||l_abt_amt);

280: --
281: FOR amt_rec IN csr_get_amt(inv_in_prd_rec.var_rent_inv_id, l_min_grp_date, l_max_grp_date) LOOP
282: l_abt_amt := l_abt_amt + amt_rec.amount;
283: END LOOP;
284: pnp_debug_pkg.log('l_abt_amt:'||l_abt_amt);
285:
286: END LOOP;
287:
288: END IF;

Line 289: pnp_debug_pkg.log('Amount:'||l_abt_amt);

285:
286: END LOOP;
287:
288: END IF;
289: pnp_debug_pkg.log('Amount:'||l_abt_amt);
290: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');
291: RETURN l_abt_amt;
292: EXCEPTION
293: WHEN no_data_found THEN

Line 290: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');

286: END LOOP;
287:
288: END IF;
289: pnp_debug_pkg.log('Amount:'||l_abt_amt);
290: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.calc_abatement (-) :');
291: RETURN l_abt_amt;
292: EXCEPTION
293: WHEN no_data_found THEN
294: return 0;

Line 296: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

292: EXCEPTION
293: WHEN no_data_found THEN
294: return 0;
295: WHEN others THEN
296: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.calc_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);
297: RAISE;
298:
299: END calc_abatement;
300:

Line 323: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (+) :');

319: IS
320: l_abt_amt NUMBER := 0;
321: l_exported NUMBER := null;
322: BEGIN
323: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (+) :');
324:
325: /* Calculate the recurring abatement amount */
326:
327: --Fix for bug # 2722191

Line 364: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (-) :');

360:
361: END IF;
362:
363:
364: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (-) :');
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.process_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

Line 368: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.process_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);

364: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.process_abatement (-) :');
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: pnp_debug_pkg.log('Error IN pn_var_abatement_amount_pkg.process_abatement -'||TO_CHAR(sqlcode)||' - '||sqlerrm);
369: raise;
370:
371: END process_abatement;
372:

Line 402: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');

398: l_grp_date DATE;
399:
400: BEGIN
401:
402: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');
403:
404: IF p_date_type ='MIN' THEN
405: OPEN csr_min_gd;
406: FETCH csr_min_gd INTO l_grp_date;

Line 416: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');

412: END IF;
413:
414: RETURN l_grp_date;
415:
416: pnp_debug_pkg.log('pn_var_abatement_amount_pkg.get_group_dt (-) :');
417:
418: END get_group_dt;
419:
420: ---------------------------------------------------------------------------------------------------------------