DBA Data[Home] [Help]

APPS.PN_VARIABLE_TERM_PKG dependencies on PNP_DEBUG_PKG

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

212: fnd_message.set_token ('VRN_TO',p_vrent_num_to);
213: fnd_message.set_token ('PRD_FROM',p_period_num_from);
214: fnd_message.set_token ('PRD_TO',p_period_num_to);
215: fnd_message.set_token ('USR',p_responsible_user);
216: pnp_debug_pkg.put_log_msg(fnd_message.get);
217:
218:
219: /* Retrieve operating unit attributes and stores them in the cache */
220: l_context := 'Retreiving operating unit attributes';

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

263: pn_variable_amount_pkg.put_output(l_errmsg);
264:
265: fnd_message.set_name ('PN','PN_SOI_VRN');
266: fnd_message.set_token ('NUM',l_rent_num);
267: pnp_debug_pkg.put_log_msg(fnd_message.get);
268:
269: END IF;
270: END IF;
271:

Line 276: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');

272: IF l_err_flag = 'N' THEN
273:
274: pn_variable_amount_pkg.put_output ('+---------------------------------------------------------------+');
275: fnd_message.set_name ('PN','PN_RICAL_PROC');
276: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
277:
278: fnd_message.set_name ('PN','PN_SOI_VRN');
279: fnd_message.set_token ('NUM',l_rent_num);
280: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

276: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
277:
278: fnd_message.set_name ('PN','PN_SOI_VRN');
279: fnd_message.set_token ('NUM',l_rent_num);
280: pnp_debug_pkg.put_log_msg(fnd_message.get);
281:
282: fnd_message.set_name ('PN','PN_VTERM_PRD_NUM');
283: fnd_message.set_token ('NUM',l_period_num);
284: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

280: pnp_debug_pkg.put_log_msg(fnd_message.get);
281:
282: fnd_message.set_name ('PN','PN_VTERM_PRD_NUM');
283: fnd_message.set_token ('NUM',l_period_num);
284: pnp_debug_pkg.put_log_msg(fnd_message.get);
285:
286: IF l_invoice_on = 'FORECASTED' THEN
287:
288: l_context := 'opening csr_for_inv';

Line 293: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');

289:
290: FOR rec_for_inv in csr_for_inv(l_period_id) LOOP
291:
292: fnd_message.set_name ('PN','PN_VTERM_FORC_TRM');
293: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
294:
295: err_flag := FALSE;
296:
297: /*l_inv_start_date := pn_var_rent_calc_pkg.inv_start_date

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

301:
302: l_inv_sch_date := pn_var_rent_calc_pkg.inv_sch_date(rec_for_inv.invoice_date,l_var_rent_id,l_period_id);
303: fnd_message.set_name ('PN','PN_SOI_INV_DT');
304: fnd_message.set_token ('DATE',l_inv_sch_date);
305: pnp_debug_pkg.put_log_msg(fnd_message.get);
306:
307: fnd_message.set_name ('PN','PN_VTERM_FORC_RENT');
308: fnd_message.set_token ('RENT',round(rec_for_inv.for_per_rent,2));
309: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

305: pnp_debug_pkg.put_log_msg(fnd_message.get);
306:
307: fnd_message.set_name ('PN','PN_VTERM_FORC_RENT');
308: fnd_message.set_token ('RENT',round(rec_for_inv.for_per_rent,2));
309: pnp_debug_pkg.put_log_msg(fnd_message.get);
310:
311:
312: l_context := 'Checking if volume exists for all group dates and line items';
313:

Line 395: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');

391: l_context :='opening csr_var_inv';
392:
393: FOR rec_var_inv in csr_var_inv(l_period_id) LOOP
394: fnd_message.set_name ('PN','PN_VTERM_FORC_TRM');
395: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
396:
397: err_flag := FALSE;
398: /*l_inv_start_date := pn_var_rent_calc_pkg.inv_start_date
399: (inv_start_date => rec_var_inv.invoice_date

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

402:
403: l_inv_sch_date := pn_var_rent_calc_pkg.inv_sch_date(rec_var_inv.invoice_date,l_var_rent_id,l_period_id);
404: fnd_message.set_name ('PN','PN_SOI_INV_DT');
405: fnd_message.set_token ('DATE',l_inv_sch_date);
406: pnp_debug_pkg.put_log_msg(fnd_message.get);
407:
408: l_context := 'Checking if volume exists for all group dates and line items';
409:
410: IF pn_variable_amount_pkg.find_volume_exists(rec_var_inv.period_id,

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

504: l_context :='opening csr_act_inv';
505: FOR rec_act_inv in csr_act_inv(l_period_id) LOOP
506:
507: fnd_message.set_name ('PN','PN_VTERM_AFORC_TRM');
508: pnp_debug_pkg.put_log_msg(fnd_message.get);
509:
510: err_flag := FALSE;
511:
512: l_inv_sch_date := pn_var_rent_calc_pkg.inv_sch_date(rec_act_inv.invoice_date,l_var_rent_id,l_period_id);

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

511:
512: l_inv_sch_date := pn_var_rent_calc_pkg.inv_sch_date(rec_act_inv.invoice_date,l_var_rent_id,l_period_id);
513: fnd_message.set_name ('PN','PN_SOI_INV_DT');
514: fnd_message.set_token ('DATE',l_inv_sch_date);
515: pnp_debug_pkg.put_log_msg(fnd_message.get);
516:
517: l_context := 'Checking if volume exists for all group dates and line items';
518:
519: IF pn_variable_amount_pkg.find_volume_exists(rec_act_inv.period_id,

Line 1049: pnp_debug_pkg.debug('setting actual term status ...');

1045: WHERE var_rent_inv_id = p_var_rent_inv_id
1046: AND var_rent_type = 'ACTUAL';
1047:
1048: IF term_count > 0 THEN
1049: pnp_debug_pkg.debug('setting actual term status ...');
1050: UPDATE pn_var_rent_inv_all
1051: SET actual_term_status='Y'
1052: WHERE var_rent_inv_id = p_var_rent_inv_id;
1053:

Line 1091: pnp_debug_pkg.debug('setting actual term status ...');

1087: WHERE var_rent_inv_id = p_var_rent_inv_id
1088: AND var_rent_type = 'ACTUAL';
1089:
1090: IF term_count > 0 THEN
1091: pnp_debug_pkg.debug('setting actual term status ...');
1092: UPDATE pn_var_rent_inv_all
1093: SET actual_term_status='Y'
1094: WHERE var_rent_inv_id = p_var_rent_inv_id;
1095: ELSE

Line 1269: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (+) : ');

1265: l_prev_inv_dt DATE;
1266: k NUMBER:= NULL;
1267:
1268: BEGIN
1269: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (+) : ');
1270:
1271: l_invoice_date := p_invoice_date;
1272:
1273: FOR inv_prd_rec IN inv_prd_cur(p_period_id, p_invoice_date) LOOP

Line 1495: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (-) : ');

1491: END IF;
1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (-) : ');
1496: RAISE;
1497:
1498: END find_volume_continuous;
1499:

Line 1723: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (+) : ');

1719: inv_st_dt DATE := NULL;
1720: inv_end_dt DATE := NULL;
1721:
1722: BEGIN
1723: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (+) : ');
1724:
1725: l_invoice_date := p_invoice_date;
1726:
1727: FOR inv_prd_rec IN inv_prd_cur(p_period_id, p_invoice_date) LOOP

Line 1797: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (-) : ');

1793: RETURN 'Y';
1794:
1795: EXCEPTION
1796: WHEN others THEN
1797: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (-) : ');
1798: RAISE;
1799: END find_volume_continuous_for;
1800:
1801:

Line 2000: pnp_debug_pkg.debug('setting actual term status ...');

1996: WHERE var_rent_inv_id = p_var_rent_inv_id
1997: AND var_rent_type = 'ACTUAL';
1998:
1999: IF term_count > 0 THEN
2000: pnp_debug_pkg.debug('setting actual term status ...');
2001: UPDATE pn_var_rent_inv_all
2002: SET actual_term_status='Y'
2003: WHERE var_rent_inv_id = p_var_rent_inv_id;
2004:

Line 2043: pnp_debug_pkg.debug('setting actual term status ...');

2039: WHERE var_rent_inv_id = p_var_rent_inv_id
2040: AND var_rent_type = 'ACTUAL';
2041:
2042: IF term_count > 0 THEN
2043: pnp_debug_pkg.debug('setting actual term status ...');
2044: UPDATE pn_var_rent_inv_all
2045: SET actual_term_status='Y'
2046: WHERE var_rent_inv_id = p_var_rent_inv_id;
2047: ELSE