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_REC_CALC_PKG dependencies on FND_MESSAGE

Line 242: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');

238: l_start_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_startdate));
239: l_end_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_enddate));
240: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));
241:
242: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);

Line 243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);

239: l_end_date := TRUNC(fnd_date.canonical_to_date(p_calc_period_enddate));
240: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));
241:
242: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);

Line 244: fnd_message.set_token ('LEASE_ID',l_lease_id);

240: l_as_of_date := TRUNC(fnd_date.canonical_to_date(p_as_ofdate));
241:
242: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);

Line 245: fnd_message.set_token ('LOC_ID',p_location_id);

241:
242: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);

Line 246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);

242: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');
243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);

Line 247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);

243: fnd_message.set_token ('AGR_ID',p_rec_agreement_id);
244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);

Line 248: fnd_message.set_token ('CUST_ID',p_customer_id);

244: fnd_message.set_token ('LEASE_ID',l_lease_id);
245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);

Line 249: fnd_message.set_token ('SITE_ID',p_cust_site_id);

245: fnd_message.set_token ('LOC_ID',p_location_id);
246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);

Line 250: fnd_message.set_token ('ST_DATE',l_start_date);

246: fnd_message.set_token ('LINE_ID',p_rec_agr_line_id);
247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);

Line 251: fnd_message.set_token ('END_DT',l_end_date);

247: fnd_message.set_token ('PRD_ID',p_rec_calc_period_id);
248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);

Line 252: fnd_message.set_token ('AS_DATE',l_as_of_date);

248: fnd_message.set_token ('CUST_ID',p_customer_id);
249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);

Line 253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);

249: fnd_message.set_token ('SITE_ID',p_cust_site_id);
250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);

Line 254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);

250: fnd_message.set_token ('ST_DATE',l_start_date);
251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);

Line 255: fnd_message.set_token ('LOC_FRM',p_location_code_from);

251: fnd_message.set_token ('END_DT',l_end_date);
252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);

Line 256: fnd_message.set_token ('LOC_TO',p_location_code_to);

252: fnd_message.set_token ('AS_DATE',l_as_of_date);
253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);

Line 257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);

253: fnd_message.set_token ('LSNO_FRM',p_lease_num_from);
254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);

Line 258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);

254: fnd_message.set_token ('LSNO_TO',p_lease_num_to);
255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);
262: fnd_message.set_token ('PRD_END',l_calc_period_ending);

Line 259: fnd_message.set_token ('PROP_NAME',p_property_name);

255: fnd_message.set_token ('LOC_FRM',p_location_code_from);
256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);
262: fnd_message.set_token ('PRD_END',l_calc_period_ending);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 260: fnd_message.set_token ('CUST_NAME',p_customer_name);

256: fnd_message.set_token ('LOC_TO',p_location_code_to);
257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);
262: fnd_message.set_token ('PRD_END',l_calc_period_ending);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);
264:

Line 261: fnd_message.set_token ('CUST_SITE',p_customer_site);

257: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);
262: fnd_message.set_token ('PRD_END',l_calc_period_ending);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);
264:
265: /* PL/SQL Tables to cache term templates which are lazy upgraded for E-Tax*/

Line 262: fnd_message.set_token ('PRD_END',l_calc_period_ending);

258: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);
262: fnd_message.set_token ('PRD_END',l_calc_period_ending);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);
264:
265: /* PL/SQL Tables to cache term templates which are lazy upgraded for E-Tax*/
266: template_name_tbl.DELETE;

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

259: fnd_message.set_token ('PROP_NAME',p_property_name);
260: fnd_message.set_token ('CUST_NAME',p_customer_name);
261: fnd_message.set_token ('CUST_SITE',p_customer_site);
262: fnd_message.set_token ('PRD_END',l_calc_period_ending);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);
264:
265: /* PL/SQL Tables to cache term templates which are lazy upgraded for E-Tax*/
266: template_name_tbl.DELETE;
267: template_id_tbl.DELETE;

Line 411: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');

407: END IF;
408:
409: END LOOP;
410:
411: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
412: fnd_message.set_token ('NUM', l_processed);
413: pnp_debug_pkg.put_log_msg(fnd_message.get);
414:
415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');

Line 412: fnd_message.set_token ('NUM', l_processed);

408:
409: END LOOP;
410:
411: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
412: fnd_message.set_token ('NUM', l_processed);
413: pnp_debug_pkg.put_log_msg(fnd_message.get);
414:
415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
416: fnd_message.set_token ('NUM', l_success_count);

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

409: END LOOP;
410:
411: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
412: fnd_message.set_token ('NUM', l_processed);
413: pnp_debug_pkg.put_log_msg(fnd_message.get);
414:
415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
416: fnd_message.set_token ('NUM', l_success_count);
417: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');

411: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
412: fnd_message.set_token ('NUM', l_processed);
413: pnp_debug_pkg.put_log_msg(fnd_message.get);
414:
415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
416: fnd_message.set_token ('NUM', l_success_count);
417: pnp_debug_pkg.put_log_msg(fnd_message.get);
418:
419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');

Line 416: fnd_message.set_token ('NUM', l_success_count);

412: fnd_message.set_token ('NUM', l_processed);
413: pnp_debug_pkg.put_log_msg(fnd_message.get);
414:
415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
416: fnd_message.set_token ('NUM', l_success_count);
417: pnp_debug_pkg.put_log_msg(fnd_message.get);
418:
419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
420: fnd_message.set_token ('NUM', l_fail_count);

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

413: pnp_debug_pkg.put_log_msg(fnd_message.get);
414:
415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
416: fnd_message.set_token ('NUM', l_success_count);
417: pnp_debug_pkg.put_log_msg(fnd_message.get);
418:
419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
420: fnd_message.set_token ('NUM', l_fail_count);
421: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');

415: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
416: fnd_message.set_token ('NUM', l_success_count);
417: pnp_debug_pkg.put_log_msg(fnd_message.get);
418:
419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
420: fnd_message.set_token ('NUM', l_fail_count);
421: pnp_debug_pkg.put_log_msg(fnd_message.get);
422:
423: IF calc_rec_amount_wloc_prop%ISOPEN THEN

Line 420: fnd_message.set_token ('NUM', l_fail_count);

416: fnd_message.set_token ('NUM', l_success_count);
417: pnp_debug_pkg.put_log_msg(fnd_message.get);
418:
419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
420: fnd_message.set_token ('NUM', l_fail_count);
421: pnp_debug_pkg.put_log_msg(fnd_message.get);
422:
423: IF calc_rec_amount_wloc_prop%ISOPEN THEN
424: CLOSE calc_rec_amount_wloc_prop;

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

417: pnp_debug_pkg.put_log_msg(fnd_message.get);
418:
419: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
420: fnd_message.set_token ('NUM', l_fail_count);
421: pnp_debug_pkg.put_log_msg(fnd_message.get);
422:
423: IF calc_rec_amount_wloc_prop%ISOPEN THEN
424: CLOSE calc_rec_amount_wloc_prop;
425: ELSIF calc_rec_amount_wloc%ISOPEN THEN

Line 620: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');

616:
617: BEGIN
618:
619: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
620: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);

Line 621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);

617: BEGIN
618:
619: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
620: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);

Line 622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);

618:
619: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
620: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);

Line 623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);

619: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
620: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);

Line 624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);

620: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);

Line 625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);

621: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);

Line 626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);

622: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);
630: fnd_message.set_token ('PRD_END',l_calc_period_ending);

Line 627: fnd_message.set_token ('PROP_NAME',p_property_name);

623: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);
630: fnd_message.set_token ('PRD_END',l_calc_period_ending);
631:

Line 628: fnd_message.set_token ('CUST_NAME',p_customer_name);

624: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);
630: fnd_message.set_token ('PRD_END',l_calc_period_ending);
631:
632: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 629: fnd_message.set_token ('CUST_SITE',p_customer_site);

625: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);
630: fnd_message.set_token ('PRD_END',l_calc_period_ending);
631:
632: pnp_debug_pkg.put_log_msg(fnd_message.get);
633:

Line 630: fnd_message.set_token ('PRD_END',l_calc_period_ending);

626: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
627: fnd_message.set_token ('PROP_NAME',p_property_name);
628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);
630: fnd_message.set_token ('PRD_END',l_calc_period_ending);
631:
632: pnp_debug_pkg.put_log_msg(fnd_message.get);
633:
634: /* if p_org_ID is not null, then set.

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

628: fnd_message.set_token ('CUST_NAME',p_customer_name);
629: fnd_message.set_token ('CUST_SITE',p_customer_site);
630: fnd_message.set_token ('PRD_END',l_calc_period_ending);
631:
632: pnp_debug_pkg.put_log_msg(fnd_message.get);
633:
634: /* if p_org_ID is not null, then set.
635: else if in R12, current org is already set
636: */

Line 735: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');

731:
732: pnp_debug_pkg.put_log_msg('
733: ===============================================================================');
734:
735: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
736: fnd_message.set_token ('NUM', l_processed);
737: pnp_debug_pkg.put_log_msg(fnd_message.get);
738:
739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');

Line 736: fnd_message.set_token ('NUM', l_processed);

732: pnp_debug_pkg.put_log_msg('
733: ===============================================================================');
734:
735: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
736: fnd_message.set_token ('NUM', l_processed);
737: pnp_debug_pkg.put_log_msg(fnd_message.get);
738:
739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
740: fnd_message.set_token ('NUM', l_success_count);

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

733: ===============================================================================');
734:
735: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
736: fnd_message.set_token ('NUM', l_processed);
737: pnp_debug_pkg.put_log_msg(fnd_message.get);
738:
739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
740: fnd_message.set_token ('NUM', l_success_count);
741: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');

735: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
736: fnd_message.set_token ('NUM', l_processed);
737: pnp_debug_pkg.put_log_msg(fnd_message.get);
738:
739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
740: fnd_message.set_token ('NUM', l_success_count);
741: pnp_debug_pkg.put_log_msg(fnd_message.get);
742:
743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');

Line 740: fnd_message.set_token ('NUM', l_success_count);

736: fnd_message.set_token ('NUM', l_processed);
737: pnp_debug_pkg.put_log_msg(fnd_message.get);
738:
739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
740: fnd_message.set_token ('NUM', l_success_count);
741: pnp_debug_pkg.put_log_msg(fnd_message.get);
742:
743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
744: fnd_message.set_token ('NUM', l_fail_count);

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

737: pnp_debug_pkg.put_log_msg(fnd_message.get);
738:
739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
740: fnd_message.set_token ('NUM', l_success_count);
741: pnp_debug_pkg.put_log_msg(fnd_message.get);
742:
743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
744: fnd_message.set_token ('NUM', l_fail_count);
745: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');

739: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
740: fnd_message.set_token ('NUM', l_success_count);
741: pnp_debug_pkg.put_log_msg(fnd_message.get);
742:
743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
744: fnd_message.set_token ('NUM', l_fail_count);
745: pnp_debug_pkg.put_log_msg(fnd_message.get);
746:
747: pnp_debug_pkg.put_log_msg('

Line 744: fnd_message.set_token ('NUM', l_fail_count);

740: fnd_message.set_token ('NUM', l_success_count);
741: pnp_debug_pkg.put_log_msg(fnd_message.get);
742:
743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
744: fnd_message.set_token ('NUM', l_fail_count);
745: pnp_debug_pkg.put_log_msg(fnd_message.get);
746:
747: pnp_debug_pkg.put_log_msg('
748: ===============================================================================');

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

741: pnp_debug_pkg.put_log_msg(fnd_message.get);
742:
743: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
744: fnd_message.set_token ('NUM', l_fail_count);
745: pnp_debug_pkg.put_log_msg(fnd_message.get);
746:
747: pnp_debug_pkg.put_log_msg('
748: ===============================================================================');
749:

Line 1053: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');

1049:
1050: l_consolidate := NVL(pn_mo_cache_utils.get_profile_value('PN_REC_CONSOLIDATE_TERMS', l_org_id), 'N');
1051:
1052: pnp_debug_pkg.put_log_msg(' ');
1053: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1054: fnd_message.set_token ('NAME', l_rec_agr_name);
1055: pnp_debug_pkg.put_log_msg(fnd_message.get);
1056:
1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');

Line 1054: fnd_message.set_token ('NAME', l_rec_agr_name);

1050: l_consolidate := NVL(pn_mo_cache_utils.get_profile_value('PN_REC_CONSOLIDATE_TERMS', l_org_id), 'N');
1051:
1052: pnp_debug_pkg.put_log_msg(' ');
1053: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1054: fnd_message.set_token ('NAME', l_rec_agr_name);
1055: pnp_debug_pkg.put_log_msg(fnd_message.get);
1056:
1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1058: fnd_message.set_token ('NUM', l_rec_agr_num);

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

1051:
1052: pnp_debug_pkg.put_log_msg(' ');
1053: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1054: fnd_message.set_token ('NAME', l_rec_agr_name);
1055: pnp_debug_pkg.put_log_msg(fnd_message.get);
1056:
1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1058: fnd_message.set_token ('NUM', l_rec_agr_num);
1059: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');

1053: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1054: fnd_message.set_token ('NAME', l_rec_agr_name);
1055: pnp_debug_pkg.put_log_msg(fnd_message.get);
1056:
1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1058: fnd_message.set_token ('NUM', l_rec_agr_num);
1059: pnp_debug_pkg.put_log_msg(fnd_message.get);
1060:
1061: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);

Line 1058: fnd_message.set_token ('NUM', l_rec_agr_num);

1054: fnd_message.set_token ('NAME', l_rec_agr_name);
1055: pnp_debug_pkg.put_log_msg(fnd_message.get);
1056:
1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1058: fnd_message.set_token ('NUM', l_rec_agr_num);
1059: pnp_debug_pkg.put_log_msg(fnd_message.get);
1060:
1061: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);
1062: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);

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

1055: pnp_debug_pkg.put_log_msg(fnd_message.get);
1056:
1057: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1058: fnd_message.set_token ('NUM', l_rec_agr_num);
1059: pnp_debug_pkg.put_log_msg(fnd_message.get);
1060:
1061: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);
1062: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);
1063: pnp_debug_pkg.log('calculate_rec_amount - currency code : '||g_currency_code);

Line 1287: fnd_message.set_name ('PN','PN_RECALC_PCT_NOT');

1283: pnp_debug_pkg.log('Error Code 5 : '||p_error_code);
1284: l_ten_actual_recovery := 0;
1285: l_status := 'ERROR';
1286:
1287: fnd_message.set_name ('PN','PN_RECALC_PCT_NOT');
1288: pnp_debug_pkg.put_log_msg(fnd_message.get);
1289:
1290: p_error := 'Percentage not specified for Fixed Percentage calc. method';
1291: p_error_code := -99;

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

1284: l_ten_actual_recovery := 0;
1285: l_status := 'ERROR';
1286:
1287: fnd_message.set_name ('PN','PN_RECALC_PCT_NOT');
1288: pnp_debug_pkg.put_log_msg(fnd_message.get);
1289:
1290: p_error := 'Percentage not specified for Fixed Percentage calc. method';
1291: p_error_code := -99;
1292:

Line 1322: fnd_message.set_name ('PN','PN_RECALB_TOT_AR');

1318: );
1319:
1320: IF l_tot_prop_area = -99 THEN
1321:
1322: fnd_message.set_name ('PN','PN_RECALB_TOT_AR');
1323: pnp_debug_pkg.put_log_msg(fnd_message.get);
1324:
1325: p_error := 'Error while getting Total Property Area ';
1326: p_error_code := -99;

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

1319:
1320: IF l_tot_prop_area = -99 THEN
1321:
1322: fnd_message.set_name ('PN','PN_RECALB_TOT_AR');
1323: pnp_debug_pkg.put_log_msg(fnd_message.get);
1324:
1325: p_error := 'Error while getting Total Property Area ';
1326: p_error_code := -99;
1327: l_tot_prop_area := 0;

Line 1791: fnd_message.set_name ('PN','PN_RECALC_CAP_EXT');

1787: year cap is entered */
1788:
1789: IF l_opya_exists and l_opyc_exists THEN
1790:
1791: fnd_message.set_name ('PN','PN_RECALC_CAP_EXT');
1792: pnp_debug_pkg.put_log_msg(fnd_message.get);
1793:
1794: p_error := 'Both cumulative and non-cumulative caps exists.';
1795: p_error_code := -99;

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

1788:
1789: IF l_opya_exists and l_opyc_exists THEN
1790:
1791: fnd_message.set_name ('PN','PN_RECALC_CAP_EXT');
1792: pnp_debug_pkg.put_log_msg(fnd_message.get);
1793:
1794: p_error := 'Both cumulative and non-cumulative caps exists.';
1795: p_error_code := -99;
1796:

Line 2102: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');

2098:
2099: pnp_debug_pkg.put_log_msg(' ');
2100: pnp_debug_pkg.put_log_msg('===============================================================================');
2101:
2102: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2103: fnd_message.set_token ('NUM', l_total_lines);
2104: pnp_debug_pkg.put_log_msg(fnd_message.get);
2105:
2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');

Line 2103: fnd_message.set_token ('NUM', l_total_lines);

2099: pnp_debug_pkg.put_log_msg(' ');
2100: pnp_debug_pkg.put_log_msg('===============================================================================');
2101:
2102: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2103: fnd_message.set_token ('NUM', l_total_lines);
2104: pnp_debug_pkg.put_log_msg(fnd_message.get);
2105:
2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2107: fnd_message.set_token ('NUM', l_success_lines);

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

2100: pnp_debug_pkg.put_log_msg('===============================================================================');
2101:
2102: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2103: fnd_message.set_token ('NUM', l_total_lines);
2104: pnp_debug_pkg.put_log_msg(fnd_message.get);
2105:
2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2107: fnd_message.set_token ('NUM', l_success_lines);
2108: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');

2102: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2103: fnd_message.set_token ('NUM', l_total_lines);
2104: pnp_debug_pkg.put_log_msg(fnd_message.get);
2105:
2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2107: fnd_message.set_token ('NUM', l_success_lines);
2108: pnp_debug_pkg.put_log_msg(fnd_message.get);
2109:
2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');

Line 2107: fnd_message.set_token ('NUM', l_success_lines);

2103: fnd_message.set_token ('NUM', l_total_lines);
2104: pnp_debug_pkg.put_log_msg(fnd_message.get);
2105:
2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2107: fnd_message.set_token ('NUM', l_success_lines);
2108: pnp_debug_pkg.put_log_msg(fnd_message.get);
2109:
2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2111: fnd_message.set_token ('NUM', l_error_lines);

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

2104: pnp_debug_pkg.put_log_msg(fnd_message.get);
2105:
2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2107: fnd_message.set_token ('NUM', l_success_lines);
2108: pnp_debug_pkg.put_log_msg(fnd_message.get);
2109:
2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2111: fnd_message.set_token ('NUM', l_error_lines);
2112: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');

2106: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2107: fnd_message.set_token ('NUM', l_success_lines);
2108: pnp_debug_pkg.put_log_msg(fnd_message.get);
2109:
2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2111: fnd_message.set_token ('NUM', l_error_lines);
2112: pnp_debug_pkg.put_log_msg(fnd_message.get);
2113:
2114: pnp_debug_pkg.put_log_msg('===============================================================================');

Line 2111: fnd_message.set_token ('NUM', l_error_lines);

2107: fnd_message.set_token ('NUM', l_success_lines);
2108: pnp_debug_pkg.put_log_msg(fnd_message.get);
2109:
2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2111: fnd_message.set_token ('NUM', l_error_lines);
2112: pnp_debug_pkg.put_log_msg(fnd_message.get);
2113:
2114: pnp_debug_pkg.put_log_msg('===============================================================================');
2115:

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

2108: pnp_debug_pkg.put_log_msg(fnd_message.get);
2109:
2110: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2111: fnd_message.set_token ('NUM', l_error_lines);
2112: pnp_debug_pkg.put_log_msg(fnd_message.get);
2113:
2114: pnp_debug_pkg.put_log_msg('===============================================================================');
2115:
2116: IF agr_lines_all%ISOPEN THEN

Line 2155: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');

2151:
2152: IF l_consolidate = 'Y' and
2153: (l_open_exists = 'Y' OR l_no_prd_line = 'Y') THEN
2154:
2155: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2156: pnp_debug_pkg.put_log_msg(fnd_message.get);
2157:
2158: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2159: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2152: IF l_consolidate = 'Y' and
2153: (l_open_exists = 'Y' OR l_no_prd_line = 'Y') THEN
2154:
2155: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2156: pnp_debug_pkg.put_log_msg(fnd_message.get);
2157:
2158: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2159: pnp_debug_pkg.put_log_msg(fnd_message.get);
2160:

Line 2158: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');

2154:
2155: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2156: pnp_debug_pkg.put_log_msg(fnd_message.get);
2157:
2158: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2159: pnp_debug_pkg.put_log_msg(fnd_message.get);
2160:
2161: p_error := 'Calculation not successful for all lines';
2162: p_error_code := -99;

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

2155: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2156: pnp_debug_pkg.put_log_msg(fnd_message.get);
2157:
2158: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2159: pnp_debug_pkg.put_log_msg(fnd_message.get);
2160:
2161: p_error := 'Calculation not successful for all lines';
2162: p_error_code := -99;
2163:

Line 2397: fnd_message.set_name ('PN','PN_RECALB_TNT_AR');

2393: EXCEPTION
2394:
2395: WHEN OTHERS
2396: THEN
2397: fnd_message.set_name ('PN','PN_RECALB_TNT_AR');
2398: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
2399: RETURN -99;
2400:
2401:

Line 2398: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));

2394:
2395: WHEN OTHERS
2396: THEN
2397: fnd_message.set_name ('PN','PN_RECALB_TNT_AR');
2398: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
2399: RETURN -99;
2400:
2401:
2402: END get_recoverable_area;

Line 2502: fnd_message.set_name ('PN','PN_RECALB_AR_NF');

2498: l_area_class_dtl_id;
2499: if c_area%NotFound then
2500: l_tot_prop_area := -99;
2501: close c_area;
2502: fnd_message.set_name ('PN','PN_RECALB_AR_NF');
2503: pnp_debug_pkg.put_log_msg(fnd_message.get);
2504: RETURN l_tot_prop_area;
2505: end if;
2506:

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

2499: if c_area%NotFound then
2500: l_tot_prop_area := -99;
2501: close c_area;
2502: fnd_message.set_name ('PN','PN_RECALB_AR_NF');
2503: pnp_debug_pkg.put_log_msg(fnd_message.get);
2504: RETURN l_tot_prop_area;
2505: end if;
2506:
2507: l_context := 'getting contributors';

Line 2843: fnd_message.set_name ('PN','PN_RECALC_CAL_NOT_CONTRB');

2839:
2840: WHEN OTHERS
2841: THEN
2842:
2843: fnd_message.set_name ('PN','PN_RECALC_CAL_NOT_CONTRB');
2844: pnp_debug_pkg.put_log_msg(fnd_message.get);
2845: pnp_debug_pkg.put_log_msg(TO_CHAR(sqlcode));
2846: IF p_called_from = 'CALCUI' THEN
2847: RETURN 0;

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

2840: WHEN OTHERS
2841: THEN
2842:
2843: fnd_message.set_name ('PN','PN_RECALC_CAL_NOT_CONTRB');
2844: pnp_debug_pkg.put_log_msg(fnd_message.get);
2845: pnp_debug_pkg.put_log_msg(TO_CHAR(sqlcode));
2846: IF p_called_from = 'CALCUI' THEN
2847: RETURN 0;
2848: ELSE

Line 2948: fnd_message.set_name ('PN','PN_RECALB_LNEXP_NF');

2944: p_fee_after_contr := 0;
2945: p_error := 'Error getting line expenses' || to_char(sqlcode);
2946: p_error_code := -99;
2947:
2948: fnd_message.set_name ('PN','PN_RECALB_LNEXP_NF');
2949: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
2950:
2951: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (-) ');
2952:

Line 2949: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));

2945: p_error := 'Error getting line expenses' || to_char(sqlcode);
2946: p_error_code := -99;
2947:
2948: fnd_message.set_name ('PN','PN_RECALB_LNEXP_NF');
2949: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
2950:
2951: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (-) ');
2952:
2953: END get_line_expenses;

Line 3052: fnd_message.set_name ('PN','PN_RECALB_BDEXP_NF');

3048: EXCEPTION
3049:
3050: WHEN OTHERS
3051: THEN
3052: fnd_message.set_name ('PN','PN_RECALB_BDEXP_NF');
3053: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3054:
3055: RETURN -99;
3056:

Line 3053: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));

3049:
3050: WHEN OTHERS
3051: THEN
3052: fnd_message.set_name ('PN','PN_RECALB_BDEXP_NF');
3053: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3054:
3055: RETURN -99;
3056:
3057: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (-) ');

Line 3152: fnd_message.set_name ('PN','PN_RECALB_BLREC_NF');

3148: EXCEPTION
3149:
3150: WHEN OTHERS
3151: THEN
3152: fnd_message.set_name ('PN','PN_RECALB_BLREC_NF');
3153: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3154: RETURN -99;
3155:
3156: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_billed_recovery (-) ');

Line 3153: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));

3149:
3150: WHEN OTHERS
3151: THEN
3152: fnd_message.set_name ('PN','PN_RECALB_BLREC_NF');
3153: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3154: RETURN -99;
3155:
3156: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_billed_recovery (-) ');
3157:

Line 3241: fnd_message.set_name ('PN','PN_RECALB_CONST_NF');

3237: EXCEPTION
3238:
3239: WHEN OTHERS
3240: THEN
3241: fnd_message.set_name ('PN','PN_RECALB_CONST_NF');
3242: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3243:
3244: line_constr_tbl(1).constr_order := -99;
3245: line_constr_tbl(1).scope := null;

Line 3242: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));

3238:
3239: WHEN OTHERS
3240: THEN
3241: fnd_message.set_name ('PN','PN_RECALB_CONST_NF');
3242: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3243:
3244: line_constr_tbl(1).constr_order := -99;
3245: line_constr_tbl(1).scope := null;
3246: line_constr_tbl(1).relation := null;

Line 3316: fnd_message.set_name ('PN','PN_RECALB_ABAT_NF');

3312: EXCEPTION
3313:
3314: WHEN OTHERS THEN
3315:
3316: fnd_message.set_name ('PN','PN_RECALB_ABAT_NF');
3317: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3318:
3319: RETURN -99;
3320:

Line 3317: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));

3313:
3314: WHEN OTHERS THEN
3315:
3316: fnd_message.set_name ('PN','PN_RECALB_ABAT_NF');
3317: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3318:
3319: RETURN -99;
3320:
3321: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_abatements (-) ');

Line 3382: fnd_message.set_name ('PN','PN_RECALB_PRDLN');

3378:
3379: WHEN TOO_MANY_ROWS
3380: THEN
3381:
3382: fnd_message.set_name ('PN','PN_RECALB_PRDLN');
3383: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3384: return -99;
3385:
3386: WHEN OTHERS

Line 3383: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));

3379: WHEN TOO_MANY_ROWS
3380: THEN
3381:
3382: fnd_message.set_name ('PN','PN_RECALB_PRDLN');
3383: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3384: return -99;
3385:
3386: WHEN OTHERS
3387: THEN

Line 3388: fnd_message.set_name ('PN','PN_RECALB_CHK_PRDLN');

3384: return -99;
3385:
3386: WHEN OTHERS
3387: THEN
3388: fnd_message.set_name ('PN','PN_RECALB_CHK_PRDLN');
3389: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3390: RETURN -99;
3391:
3392:

Line 3389: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));

3385:
3386: WHEN OTHERS
3387: THEN
3388: fnd_message.set_name ('PN','PN_RECALB_CHK_PRDLN');
3389: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3390: RETURN -99;
3391:
3392:
3393: END find_if_period_line_exists;

Line 5346: fnd_message.set_name ('PN','PN_REC_AGRMNT_PERIOD_EXIST');

5342: l_org_id
5343: );
5344: return l_rec_calc_period_id;
5345: ELSE
5346: fnd_message.set_name ('PN','PN_REC_AGRMNT_PERIOD_EXIST');
5347: pnp_debug_pkg.put_log_msg(fnd_message.get);
5348: return -1;
5349: END IF;
5350: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');

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

5343: );
5344: return l_rec_calc_period_id;
5345: ELSE
5346: fnd_message.set_name ('PN','PN_REC_AGRMNT_PERIOD_EXIST');
5347: pnp_debug_pkg.put_log_msg(fnd_message.get);
5348: return -1;
5349: END IF;
5350: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');
5351: