DBA Data[Home] [Help]

APPS.PN_VARIABLE_TERM_PKG dependencies on PNP_DEBUG_PKG

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

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

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

259: pn_variable_amount_pkg.put_output(l_errmsg);
260:
261: fnd_message.set_name ('PN','PN_SOI_VRN');
262: fnd_message.set_token ('NUM',l_rent_num);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);
264:
265: END IF;
266: END IF;
267:

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

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

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

272: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
273:
274: fnd_message.set_name ('PN','PN_SOI_VRN');
275: fnd_message.set_token ('NUM',l_rent_num);
276: pnp_debug_pkg.put_log_msg(fnd_message.get);
277:
278: fnd_message.set_name ('PN','PN_VTERM_PRD_NUM');
279: fnd_message.set_token ('NUM',l_period_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_VTERM_PRD_NUM');
279: fnd_message.set_token ('NUM',l_period_num);
280: pnp_debug_pkg.put_log_msg(fnd_message.get);
281:
282: IF l_invoice_on = 'FORECASTED' THEN
283:
284: l_context := 'opening csr_for_inv';

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

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

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

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

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

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

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

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

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

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

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

500: l_context :='opening csr_act_inv';
501: FOR rec_act_inv in csr_act_inv(l_period_id) LOOP
502:
503: fnd_message.set_name ('PN','PN_VTERM_AFORC_TRM');
504: pnp_debug_pkg.put_log_msg(fnd_message.get);
505:
506: err_flag := FALSE;
507:
508: 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 511: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

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

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

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

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

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

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

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

1487: END IF;
1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (-) : ');
1492: RAISE;
1493:
1494: END find_volume_continuous;
1495:

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

1715: inv_st_dt DATE := NULL;
1716: inv_end_dt DATE := NULL;
1717:
1718: BEGIN
1719: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (+) : ');
1720:
1721: l_invoice_date := p_invoice_date;
1722:
1723: FOR inv_prd_rec IN inv_prd_cur(p_period_id, p_invoice_date) LOOP

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

1789: RETURN 'Y';
1790:
1791: EXCEPTION
1792: WHEN others THEN
1793: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (-) : ');
1794: RAISE;
1795: END find_volume_continuous_for;
1796:
1797:

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

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

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

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