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 243: fnd_message.set_name ('PN','PN_RECALC_AGR_BATCH_INP_PARAM');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

432: END IF;
433:
434: END LOOP;
435:
436: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
437: fnd_message.set_token ('NUM', l_processed);
438: pnp_debug_pkg.put_log_msg(fnd_message.get);
439:
440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');

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

433:
434: END LOOP;
435:
436: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
437: fnd_message.set_token ('NUM', l_processed);
438: pnp_debug_pkg.put_log_msg(fnd_message.get);
439:
440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
441: fnd_message.set_token ('NUM', l_success_count);

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

434: END LOOP;
435:
436: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
437: fnd_message.set_token ('NUM', l_processed);
438: pnp_debug_pkg.put_log_msg(fnd_message.get);
439:
440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
441: fnd_message.set_token ('NUM', l_success_count);
442: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

436: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
437: fnd_message.set_token ('NUM', l_processed);
438: pnp_debug_pkg.put_log_msg(fnd_message.get);
439:
440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
441: fnd_message.set_token ('NUM', l_success_count);
442: pnp_debug_pkg.put_log_msg(fnd_message.get);
443:
444: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');

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

437: fnd_message.set_token ('NUM', l_processed);
438: pnp_debug_pkg.put_log_msg(fnd_message.get);
439:
440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
441: fnd_message.set_token ('NUM', l_success_count);
442: pnp_debug_pkg.put_log_msg(fnd_message.get);
443:
444: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
445: fnd_message.set_token ('NUM', l_fail_count);

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

438: pnp_debug_pkg.put_log_msg(fnd_message.get);
439:
440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
441: fnd_message.set_token ('NUM', l_success_count);
442: pnp_debug_pkg.put_log_msg(fnd_message.get);
443:
444: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
445: fnd_message.set_token ('NUM', l_fail_count);
446: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

440: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
441: fnd_message.set_token ('NUM', l_success_count);
442: pnp_debug_pkg.put_log_msg(fnd_message.get);
443:
444: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
445: fnd_message.set_token ('NUM', l_fail_count);
446: pnp_debug_pkg.put_log_msg(fnd_message.get);
447:
448: IF calc_rec_amount_wloc_prop%ISOPEN THEN

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

441: fnd_message.set_token ('NUM', l_success_count);
442: pnp_debug_pkg.put_log_msg(fnd_message.get);
443:
444: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
445: fnd_message.set_token ('NUM', l_fail_count);
446: pnp_debug_pkg.put_log_msg(fnd_message.get);
447:
448: IF calc_rec_amount_wloc_prop%ISOPEN THEN
449: CLOSE calc_rec_amount_wloc_prop;

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

442: pnp_debug_pkg.put_log_msg(fnd_message.get);
443:
444: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
445: fnd_message.set_token ('NUM', l_fail_count);
446: pnp_debug_pkg.put_log_msg(fnd_message.get);
447:
448: IF calc_rec_amount_wloc_prop%ISOPEN THEN
449: CLOSE calc_rec_amount_wloc_prop;
450: ELSIF calc_rec_amount_wloc%ISOPEN THEN

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

641:
642: BEGIN
643:
644: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
645: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
646: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);

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

642: BEGIN
643:
644: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
645: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
646: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);

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

643:
644: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
645: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
646: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);

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

644: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
645: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
646: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);

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

645: fnd_message.set_name ('PN','PN_RECALC_AGR_INP_PARAM');
646: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);

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

646: fnd_message.set_token ('LEASE_FRM',p_lease_num_from);
647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);

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

647: fnd_message.set_token ('LEASE_TO',p_lease_num_to);
648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);
655: fnd_message.set_token ('PRD_END',l_calc_period_ending);

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

648: fnd_message.set_token ('LOC_CODE_FRM',p_location_code_from);
649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);
655: fnd_message.set_token ('PRD_END',l_calc_period_ending);
656:

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

649: fnd_message.set_token ('LOC_CODE_TO',p_location_code_to);
650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);
655: fnd_message.set_token ('PRD_END',l_calc_period_ending);
656:
657: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

650: fnd_message.set_token ('REC_FRM',p_rec_agr_num_from);
651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);
655: fnd_message.set_token ('PRD_END',l_calc_period_ending);
656:
657: pnp_debug_pkg.put_log_msg(fnd_message.get);
658:

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

651: fnd_message.set_token ('REC_TO',p_rec_agr_num_to);
652: fnd_message.set_token ('PROP_NAME',p_property_name);
653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);
655: fnd_message.set_token ('PRD_END',l_calc_period_ending);
656:
657: pnp_debug_pkg.put_log_msg(fnd_message.get);
658:
659: /* if p_org_ID is not null, then set.

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

653: fnd_message.set_token ('CUST_NAME',p_customer_name);
654: fnd_message.set_token ('CUST_SITE',p_customer_site);
655: fnd_message.set_token ('PRD_END',l_calc_period_ending);
656:
657: pnp_debug_pkg.put_log_msg(fnd_message.get);
658:
659: /* if p_org_ID is not null, then set.
660: else if in R12, current org is already set
661: */

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

756:
757: pnp_debug_pkg.put_log_msg('
758: ===============================================================================');
759:
760: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
761: fnd_message.set_token ('NUM', l_processed);
762: pnp_debug_pkg.put_log_msg(fnd_message.get);
763:
764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');

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

757: pnp_debug_pkg.put_log_msg('
758: ===============================================================================');
759:
760: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
761: fnd_message.set_token ('NUM', l_processed);
762: pnp_debug_pkg.put_log_msg(fnd_message.get);
763:
764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
765: fnd_message.set_token ('NUM', l_success_count);

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

758: ===============================================================================');
759:
760: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
761: fnd_message.set_token ('NUM', l_processed);
762: pnp_debug_pkg.put_log_msg(fnd_message.get);
763:
764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
765: fnd_message.set_token ('NUM', l_success_count);
766: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

760: fnd_message.set_name ('PN','PN_RECALC_AGR_PROC');
761: fnd_message.set_token ('NUM', l_processed);
762: pnp_debug_pkg.put_log_msg(fnd_message.get);
763:
764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
765: fnd_message.set_token ('NUM', l_success_count);
766: pnp_debug_pkg.put_log_msg(fnd_message.get);
767:
768: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');

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

761: fnd_message.set_token ('NUM', l_processed);
762: pnp_debug_pkg.put_log_msg(fnd_message.get);
763:
764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
765: fnd_message.set_token ('NUM', l_success_count);
766: pnp_debug_pkg.put_log_msg(fnd_message.get);
767:
768: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
769: fnd_message.set_token ('NUM', l_fail_count);

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

762: pnp_debug_pkg.put_log_msg(fnd_message.get);
763:
764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
765: fnd_message.set_token ('NUM', l_success_count);
766: pnp_debug_pkg.put_log_msg(fnd_message.get);
767:
768: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
769: fnd_message.set_token ('NUM', l_fail_count);
770: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

764: fnd_message.set_name ('PN','PN_RECALC_AGR_SUC');
765: fnd_message.set_token ('NUM', l_success_count);
766: pnp_debug_pkg.put_log_msg(fnd_message.get);
767:
768: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
769: fnd_message.set_token ('NUM', l_fail_count);
770: pnp_debug_pkg.put_log_msg(fnd_message.get);
771:
772: pnp_debug_pkg.put_log_msg('

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

765: fnd_message.set_token ('NUM', l_success_count);
766: pnp_debug_pkg.put_log_msg(fnd_message.get);
767:
768: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
769: fnd_message.set_token ('NUM', l_fail_count);
770: pnp_debug_pkg.put_log_msg(fnd_message.get);
771:
772: pnp_debug_pkg.put_log_msg('
773: ===============================================================================');

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

766: pnp_debug_pkg.put_log_msg(fnd_message.get);
767:
768: fnd_message.set_name ('PN','PN_RECALC_AGR_FAIL');
769: fnd_message.set_token ('NUM', l_fail_count);
770: pnp_debug_pkg.put_log_msg(fnd_message.get);
771:
772: pnp_debug_pkg.put_log_msg('
773: ===============================================================================');
774:

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

1074:
1075: l_consolidate := NVL(pn_mo_cache_utils.get_profile_value('PN_REC_CONSOLIDATE_TERMS', l_org_id), 'N');
1076:
1077: pnp_debug_pkg.put_log_msg(' ');
1078: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1079: fnd_message.set_token ('NAME', l_rec_agr_name);
1080: pnp_debug_pkg.put_log_msg(fnd_message.get);
1081:
1082: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');

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

1075: l_consolidate := NVL(pn_mo_cache_utils.get_profile_value('PN_REC_CONSOLIDATE_TERMS', l_org_id), 'N');
1076:
1077: pnp_debug_pkg.put_log_msg(' ');
1078: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1079: fnd_message.set_token ('NAME', l_rec_agr_name);
1080: pnp_debug_pkg.put_log_msg(fnd_message.get);
1081:
1082: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1083: fnd_message.set_token ('NUM', l_rec_agr_num);

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

1076:
1077: pnp_debug_pkg.put_log_msg(' ');
1078: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1079: fnd_message.set_token ('NAME', l_rec_agr_name);
1080: pnp_debug_pkg.put_log_msg(fnd_message.get);
1081:
1082: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1083: fnd_message.set_token ('NUM', l_rec_agr_num);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

1078: fnd_message.set_name ('PN','PN_RECALC_AGR_NAME');
1079: fnd_message.set_token ('NAME', l_rec_agr_name);
1080: pnp_debug_pkg.put_log_msg(fnd_message.get);
1081:
1082: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1083: fnd_message.set_token ('NUM', l_rec_agr_num);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get);
1085:
1086: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);

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

1079: fnd_message.set_token ('NAME', l_rec_agr_name);
1080: pnp_debug_pkg.put_log_msg(fnd_message.get);
1081:
1082: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1083: fnd_message.set_token ('NUM', l_rec_agr_num);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get);
1085:
1086: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);
1087: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);

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

1080: pnp_debug_pkg.put_log_msg(fnd_message.get);
1081:
1082: fnd_message.set_name ('PN','PN_RECALC_AGR_NUMBER');
1083: fnd_message.set_token ('NUM', l_rec_agr_num);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get);
1085:
1086: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);
1087: pnp_debug_pkg.log('calculate_rec_amount - agreement id : '||p_rec_agreement_id);
1088: pnp_debug_pkg.log('calculate_rec_amount - currency code : '||g_currency_code);

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

1308: pnp_debug_pkg.log('Error Code 5 : '||p_error_code);
1309: l_ten_actual_recovery := 0;
1310: l_status := 'ERROR';
1311:
1312: fnd_message.set_name ('PN','PN_RECALC_PCT_NOT');
1313: pnp_debug_pkg.put_log_msg(fnd_message.get);
1314:
1315: p_error := 'Percentage not specified for Fixed Percentage calc. method';
1316: p_error_code := -99;

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

1309: l_ten_actual_recovery := 0;
1310: l_status := 'ERROR';
1311:
1312: fnd_message.set_name ('PN','PN_RECALC_PCT_NOT');
1313: pnp_debug_pkg.put_log_msg(fnd_message.get);
1314:
1315: p_error := 'Percentage not specified for Fixed Percentage calc. method';
1316: p_error_code := -99;
1317:

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

1343: );
1344:
1345: IF l_tot_prop_area = -99 THEN
1346:
1347: fnd_message.set_name ('PN','PN_RECALB_TOT_AR');
1348: pnp_debug_pkg.put_log_msg(fnd_message.get);
1349:
1350: p_error := 'Error while getting Total Property Area ';
1351: p_error_code := -99;

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

1344:
1345: IF l_tot_prop_area = -99 THEN
1346:
1347: fnd_message.set_name ('PN','PN_RECALB_TOT_AR');
1348: pnp_debug_pkg.put_log_msg(fnd_message.get);
1349:
1350: p_error := 'Error while getting Total Property Area ';
1351: p_error_code := -99;
1352: l_tot_prop_area := 0;

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

1812: year cap is entered */
1813:
1814: IF l_opya_exists and l_opyc_exists THEN
1815:
1816: fnd_message.set_name ('PN','PN_RECALC_CAP_EXT');
1817: pnp_debug_pkg.put_log_msg(fnd_message.get);
1818:
1819: p_error := 'Both cumulative and non-cumulative caps exists.';
1820: p_error_code := -99;

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

1813:
1814: IF l_opya_exists and l_opyc_exists THEN
1815:
1816: fnd_message.set_name ('PN','PN_RECALC_CAP_EXT');
1817: pnp_debug_pkg.put_log_msg(fnd_message.get);
1818:
1819: p_error := 'Both cumulative and non-cumulative caps exists.';
1820: p_error_code := -99;
1821:

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

2123:
2124: pnp_debug_pkg.put_log_msg(' ');
2125: pnp_debug_pkg.put_log_msg('===============================================================================');
2126:
2127: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2128: fnd_message.set_token ('NUM', l_total_lines);
2129: pnp_debug_pkg.put_log_msg(fnd_message.get);
2130:
2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');

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

2124: pnp_debug_pkg.put_log_msg(' ');
2125: pnp_debug_pkg.put_log_msg('===============================================================================');
2126:
2127: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2128: fnd_message.set_token ('NUM', l_total_lines);
2129: pnp_debug_pkg.put_log_msg(fnd_message.get);
2130:
2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2132: fnd_message.set_token ('NUM', l_success_lines);

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

2125: pnp_debug_pkg.put_log_msg('===============================================================================');
2126:
2127: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2128: fnd_message.set_token ('NUM', l_total_lines);
2129: pnp_debug_pkg.put_log_msg(fnd_message.get);
2130:
2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2132: fnd_message.set_token ('NUM', l_success_lines);
2133: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2127: fnd_message.set_name ('PN','PN_RECALC_LINE_PROC');
2128: fnd_message.set_token ('NUM', l_total_lines);
2129: pnp_debug_pkg.put_log_msg(fnd_message.get);
2130:
2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2132: fnd_message.set_token ('NUM', l_success_lines);
2133: pnp_debug_pkg.put_log_msg(fnd_message.get);
2134:
2135: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');

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

2128: fnd_message.set_token ('NUM', l_total_lines);
2129: pnp_debug_pkg.put_log_msg(fnd_message.get);
2130:
2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2132: fnd_message.set_token ('NUM', l_success_lines);
2133: pnp_debug_pkg.put_log_msg(fnd_message.get);
2134:
2135: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2136: fnd_message.set_token ('NUM', l_error_lines);

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

2129: pnp_debug_pkg.put_log_msg(fnd_message.get);
2130:
2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2132: fnd_message.set_token ('NUM', l_success_lines);
2133: pnp_debug_pkg.put_log_msg(fnd_message.get);
2134:
2135: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2136: fnd_message.set_token ('NUM', l_error_lines);
2137: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2131: fnd_message.set_name ('PN','PN_RECALC_LINE_SUC');
2132: fnd_message.set_token ('NUM', l_success_lines);
2133: pnp_debug_pkg.put_log_msg(fnd_message.get);
2134:
2135: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2136: fnd_message.set_token ('NUM', l_error_lines);
2137: pnp_debug_pkg.put_log_msg(fnd_message.get);
2138:
2139: pnp_debug_pkg.put_log_msg('===============================================================================');

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

2132: fnd_message.set_token ('NUM', l_success_lines);
2133: pnp_debug_pkg.put_log_msg(fnd_message.get);
2134:
2135: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2136: fnd_message.set_token ('NUM', l_error_lines);
2137: pnp_debug_pkg.put_log_msg(fnd_message.get);
2138:
2139: pnp_debug_pkg.put_log_msg('===============================================================================');
2140:

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

2133: pnp_debug_pkg.put_log_msg(fnd_message.get);
2134:
2135: fnd_message.set_name ('PN','PN_RECALC_LINE_FAIL');
2136: fnd_message.set_token ('NUM', l_error_lines);
2137: pnp_debug_pkg.put_log_msg(fnd_message.get);
2138:
2139: pnp_debug_pkg.put_log_msg('===============================================================================');
2140:
2141: IF agr_lines_all%ISOPEN THEN

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

2176:
2177: IF l_consolidate = 'Y' and
2178: (l_open_exists = 'Y' OR l_no_prd_line = 'Y') THEN
2179:
2180: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2184: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2177: IF l_consolidate = 'Y' and
2178: (l_open_exists = 'Y' OR l_no_prd_line = 'Y') THEN
2179:
2180: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2184: pnp_debug_pkg.put_log_msg(fnd_message.get);
2185:

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

2179:
2180: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2184: pnp_debug_pkg.put_log_msg(fnd_message.get);
2185:
2186: p_error := 'Calculation not successful for all lines';
2187: p_error_code := -99;

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

2180: fnd_message.set_name ('PN','PN_RECALC_LN_INCOM');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name ('PN','PN_RECALC_BT_NOT_CRTD');
2184: pnp_debug_pkg.put_log_msg(fnd_message.get);
2185:
2186: p_error := 'Calculation not successful for all lines';
2187: p_error_code := -99;
2188:

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

2423: EXCEPTION
2424:
2425: WHEN OTHERS
2426: THEN
2427: fnd_message.set_name ('PN','PN_RECALB_TNT_AR');
2428: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
2429: RETURN -99;
2430:
2431:

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

2424:
2425: WHEN OTHERS
2426: THEN
2427: fnd_message.set_name ('PN','PN_RECALB_TNT_AR');
2428: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
2429: RETURN -99;
2430:
2431:
2432: END get_recoverable_area;

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

2529: l_area_class_dtl_id;
2530: if c_area%NotFound then
2531: l_tot_prop_area := -99;
2532: close c_area;
2533: fnd_message.set_name ('PN','PN_RECALB_AR_NF');
2534: pnp_debug_pkg.put_log_msg(fnd_message.get);
2535: RETURN l_tot_prop_area;
2536: end if;
2537:

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

2530: if c_area%NotFound then
2531: l_tot_prop_area := -99;
2532: close c_area;
2533: fnd_message.set_name ('PN','PN_RECALB_AR_NF');
2534: pnp_debug_pkg.put_log_msg(fnd_message.get);
2535: RETURN l_tot_prop_area;
2536: end if;
2537:
2538: l_context := 'getting contributors';

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

2873:
2874: WHEN OTHERS
2875: THEN
2876:
2877: fnd_message.set_name ('PN','PN_RECALC_CAL_NOT_CONTRB');
2878: pnp_debug_pkg.put_log_msg(fnd_message.get);
2879: pnp_debug_pkg.put_log_msg(TO_CHAR(sqlcode));
2880: IF p_called_from = 'CALCUI' THEN
2881: RETURN 0;

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

2874: WHEN OTHERS
2875: THEN
2876:
2877: fnd_message.set_name ('PN','PN_RECALC_CAL_NOT_CONTRB');
2878: pnp_debug_pkg.put_log_msg(fnd_message.get);
2879: pnp_debug_pkg.put_log_msg(TO_CHAR(sqlcode));
2880: IF p_called_from = 'CALCUI' THEN
2881: RETURN 0;
2882: ELSE

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

3029: p_fee_after_contr := 0;
3030: p_error := 'Error getting line expenses' || to_char(sqlcode);
3031: p_error_code := -99;
3032:
3033: fnd_message.set_name ('PN','PN_RECALB_LNEXP_NF');
3034: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3035:
3036: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (-) ');
3037:

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

3030: p_error := 'Error getting line expenses' || to_char(sqlcode);
3031: p_error_code := -99;
3032:
3033: fnd_message.set_name ('PN','PN_RECALB_LNEXP_NF');
3034: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3035:
3036: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (-) ');
3037:
3038: END get_line_expenses;

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

3133: EXCEPTION
3134:
3135: WHEN OTHERS
3136: THEN
3137: fnd_message.set_name ('PN','PN_RECALB_BDEXP_NF');
3138: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3139:
3140: RETURN -99;
3141:

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

3134:
3135: WHEN OTHERS
3136: THEN
3137: fnd_message.set_name ('PN','PN_RECALB_BDEXP_NF');
3138: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3139:
3140: RETURN -99;
3141:
3142: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (-) ');

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

3233: EXCEPTION
3234:
3235: WHEN OTHERS
3236: THEN
3237: fnd_message.set_name ('PN','PN_RECALB_BLREC_NF');
3238: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3239: RETURN -99;
3240:
3241: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_billed_recovery (-) ');

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

3234:
3235: WHEN OTHERS
3236: THEN
3237: fnd_message.set_name ('PN','PN_RECALB_BLREC_NF');
3238: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3239: RETURN -99;
3240:
3241: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_billed_recovery (-) ');
3242:

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

3322: EXCEPTION
3323:
3324: WHEN OTHERS
3325: THEN
3326: fnd_message.set_name ('PN','PN_RECALB_CONST_NF');
3327: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3328:
3329: line_constr_tbl(1).constr_order := -99;
3330: line_constr_tbl(1).scope := null;

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

3323:
3324: WHEN OTHERS
3325: THEN
3326: fnd_message.set_name ('PN','PN_RECALB_CONST_NF');
3327: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3328:
3329: line_constr_tbl(1).constr_order := -99;
3330: line_constr_tbl(1).scope := null;
3331: line_constr_tbl(1).relation := null;

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

3397: EXCEPTION
3398:
3399: WHEN OTHERS THEN
3400:
3401: fnd_message.set_name ('PN','PN_RECALB_ABAT_NF');
3402: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3403:
3404: RETURN -99;
3405:

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

3398:
3399: WHEN OTHERS THEN
3400:
3401: fnd_message.set_name ('PN','PN_RECALB_ABAT_NF');
3402: pnp_debug_pkg.put_log_msg(fnd_message.get||' '|| to_char(sqlcode));
3403:
3404: RETURN -99;
3405:
3406: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_abatements (-) ');

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

3463:
3464: WHEN TOO_MANY_ROWS
3465: THEN
3466:
3467: fnd_message.set_name ('PN','PN_RECALB_PRDLN');
3468: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3469: return -99;
3470:
3471: WHEN OTHERS

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

3464: WHEN TOO_MANY_ROWS
3465: THEN
3466:
3467: fnd_message.set_name ('PN','PN_RECALB_PRDLN');
3468: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3469: return -99;
3470:
3471: WHEN OTHERS
3472: THEN

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

3469: return -99;
3470:
3471: WHEN OTHERS
3472: THEN
3473: fnd_message.set_name ('PN','PN_RECALB_CHK_PRDLN');
3474: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3475: RETURN -99;
3476:
3477:

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

3470:
3471: WHEN OTHERS
3472: THEN
3473: fnd_message.set_name ('PN','PN_RECALB_CHK_PRDLN');
3474: pnp_debug_pkg.put_log_msg(fnd_message.get||' '||to_char(sqlcode));
3475: RETURN -99;
3476:
3477:
3478: END find_if_period_line_exists;

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

5427: l_org_id
5428: );
5429: return l_rec_calc_period_id;
5430: ELSE
5431: fnd_message.set_name ('PN','PN_REC_AGRMNT_PERIOD_EXIST');
5432: pnp_debug_pkg.put_log_msg(fnd_message.get);
5433: return -1;
5434: END IF;
5435: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');

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

5428: );
5429: return l_rec_calc_period_id;
5430: ELSE
5431: fnd_message.set_name ('PN','PN_REC_AGRMNT_PERIOD_EXIST');
5432: pnp_debug_pkg.put_log_msg(fnd_message.get);
5433: return -1;
5434: END IF;
5435: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');
5436: