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 PN_REC_CALC_PKG

Line 1: package body PN_REC_CALC_PKG as

1: package body PN_REC_CALC_PKG as
2: /* $Header: PNRECALB.pls 120.9.12010000.3 2008/12/30 12:44:32 acprakas ship $ */
3:
4: /*===========================================================================+
5: | PROCEDURE

Line 236: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');

232: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
233:
234: BEGIN
235:
236: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');
237:
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));

Line 291: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(

287: ) THEN
288:
289: l_processed := l_processed + 1;
290:
291: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(
292: p_rec_agreement_id => p_rec_agreement_id
293: ,p_lease_id => p_lease_id
294: ,p_location_id => p_location_id
295: ,p_customer_id => p_customer_id

Line 386: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(

382: l_error := 'Success';
383: l_error_code := null;
384: l_processed := l_processed + 1;
385:
386: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(
387: p_rec_agreement_id => l_rec_agreement_id
388: ,p_lease_id => l_lease_id
389: ,p_location_id => l_location_id
390: ,p_customer_id => l_customer_id

Line 442: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (-) ');

438: pnp_debug_pkg.put_log_msg('Term template '||template_name_tbl(i)||
439: ' has an existing tax code or tax group.A corresponding tax classification will replace it');
440: END LOOP;
441:
442: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (-) ');
443:
444: EXCEPTION
445:
446: When OTHERS Then

Line 447: pnp_debug_pkg.log('Error in PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH :'||to_char(sqlcode)||' : '||sqlerrm);

443:
444: EXCEPTION
445:
446: When OTHERS Then
447: pnp_debug_pkg.log('Error in PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH :'||to_char(sqlcode)||' : '||sqlerrm);
448: Errbuf := SQLERRM;
449: Retcode := 2;
450: rollback;
451: raise;

Line 619: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');

615: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
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);

Line 705: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(

701: THEN
702:
703: l_processed := l_processed + 1;
704:
705: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(
706: p_rec_agreement_id => l_rec_agreement_id
707: ,p_lease_id => l_lease_id
708: ,p_location_id => l_location_id
709: ,p_customer_id => l_customer_id

Line 760: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (-) ');

756: ELSIF calc_rec_amount_woloc%ISOPEN THEN
757: CLOSE calc_rec_amount_woloc;
758: END IF;
759:
760: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (-) ');
761:
762: EXCEPTION
763:
764: When OTHERS Then

Line 765: pnp_debug_pkg.log('Error in PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH :'||to_char(sqlcode)||' : '||sqlerrm);

761:
762: EXCEPTION
763:
764: When OTHERS Then
765: pnp_debug_pkg.log('Error in PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH :'||to_char(sqlcode)||' : '||sqlerrm);
766: Errbuf := SQLERRM;
767: Retcode := 2;
768: rollback;
769: raise;

Line 1038: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT (+) ');

1034: l_org_id NUMBER;
1035:
1036: BEGIN
1037:
1038: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT (+) ');
1039:
1040: /* Get currency code and negative recovery value for the agreement */
1041:
1042: FOR rec IN csr_currency_code LOOP

Line 1146: PN_REC_CALC_PKG.get_line_expenses(

1142: pnp_debug_pkg.log('get_line_expenses - Location id : '||p_location_id);
1143: pnp_debug_pkg.log('get_line_expenses - Start Date : '||p_calc_period_start_date);
1144: pnp_debug_pkg.log('get_line_expenses - End Date : '||p_calc_period_end_date);
1145:
1146: PN_REC_CALC_PKG.get_line_expenses(
1147: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1148: ,p_customer_id => p_customer_id
1149: ,p_lease_id => p_lease_id
1150: ,p_location_id => p_location_id

Line 1168: l_budget_expense := PN_REC_CALC_PKG.get_budget_expenses(

1164: pnp_debug_pkg.log('get_line_expenses - Return Status : '||p_error);
1165: pnp_debug_pkg.log('get_line_expenses - Return Code : '||p_error_code);
1166:
1167: IF p_error_code <> -99 THEN
1168: l_budget_expense := PN_REC_CALC_PKG.get_budget_expenses(
1169: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1170: ,p_customer_id => p_customer_id
1171: ,p_lease_id => p_lease_id
1172: ,p_location_id => p_location_id

Line 1198: l_contr_actual_recovery := PN_REC_CALC_PKG.get_contr_actual_recovery(

1194: pnp_debug_pkg.log('Error Code 1 : '||p_error_code);
1195:
1196: IF p_error_code <> -99 THEN
1197:
1198: l_contr_actual_recovery := PN_REC_CALC_PKG.get_contr_actual_recovery(
1199: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1200: ,p_customer_id => p_customer_id
1201: ,p_lease_id => p_lease_id
1202: ,p_location_id => p_location_id

Line 1310: l_tot_prop_area := PN_REC_CALC_PKG.get_tot_prop_area(

1306: pnp_debug_pkg.log('get_tot_prop_area - Start Date : '||p_calc_period_start_date);
1307: pnp_debug_pkg.log('get_tot_prop_area - End Date : '||p_calc_period_end_date);
1308: pnp_debug_pkg.log('get_tot_prop_area - As of Date : '||p_as_of_date);
1309:
1310: l_tot_prop_area := PN_REC_CALC_PKG.get_tot_prop_area(
1311: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1312: ,p_customer_id => p_customer_id
1313: ,p_lease_id => p_lease_id
1314: ,p_location_id => p_location_id

Line 1379: l_ten_recoverable_area_rec := PN_REC_CALC_PKG.ten_recoverable_area(

1375: pnp_debug_pkg.log('ten_recoverable_area - Start Date : '||p_calc_period_start_date);
1376: pnp_debug_pkg.log('ten_recoverable_area - End Date : '||p_calc_period_end_date);
1377: pnp_debug_pkg.log('ten_recoverable_area - As of Date : '||p_as_of_date);
1378:
1379: l_ten_recoverable_area_rec := PN_REC_CALC_PKG.ten_recoverable_area(
1380: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1381: ,p_customer_id => p_customer_id
1382: ,p_lease_id => p_lease_id
1383: ,p_location_id => p_location_id

Line 1424: l_ten_recoverable_area := PN_REC_CALC_PKG.get_recoverable_area(

1420: -- For fixed rate we have the rate available and since the user puts
1421: -- in the recoverable area occupancy % is 100%
1422:
1423: l_rate := agr_lines_record.fixed_rate;
1424: l_ten_recoverable_area := PN_REC_CALC_PKG.get_recoverable_area(
1425: p_rec_calc_period_id => p_rec_calc_period_id
1426: ,p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1427: );
1428: IF l_ten_recoverable_area = -99 THEN

Line 1524: l_billed_recovery := PN_REC_CALC_PKG.get_billed_recovery(

1520: pnp_debug_pkg.log('get_billed_recovery - Start Date : '||p_calc_period_start_date);
1521: pnp_debug_pkg.log('get_billed_recovery - End Date : '||p_calc_period_end_date);
1522: pnp_debug_pkg.log('get_billed_recovery - Calc Period Id : '||p_rec_calc_period_id);
1523:
1524: l_billed_recovery := PN_REC_CALC_PKG.get_billed_recovery(
1525: p_payment_purpose => agr_lines_record.purpose
1526: ,p_payment_type => agr_lines_record.type
1527: ,p_lease_id => p_lease_id
1528: ,p_location_id => p_location_id -- 110403

Line 1552: line_constr_tbl := PN_REC_CALC_PKG.get_line_constraints(

1548:
1549: pnp_debug_pkg.log('Error Code 21 : '||p_error_code);
1550: IF p_error_code <> -99 THEN
1551:
1552: line_constr_tbl := PN_REC_CALC_PKG.get_line_constraints(
1553: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id ,
1554: p_as_of_date => p_as_of_date
1555: );
1556:

Line 1576: l_prior_period_amount := PN_REC_CALC_PKG.get_prior_period_actual_amount(

1572: pnp_debug_pkg.log('After getting constraints error code:'||p_error_code);
1573: pnp_debug_pkg.log('Error Code 22 : '||p_error_code);
1574: IF p_error_code <> -99 THEN
1575:
1576: l_prior_period_amount := PN_REC_CALC_PKG.get_prior_period_actual_amount(
1577: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1578: ,p_start_date => p_calc_period_start_date
1579: ,p_as_of_date => p_as_of_date
1580: ,p_called_from => 'CALC'

Line 1601: l_prior_period_cap := PN_REC_CALC_PKG.get_prior_period_cap(

1597:
1598: pnp_debug_pkg.log('Error Code 23 : '||p_error_code);
1599: IF p_error_code <> -99 THEN
1600:
1601: l_prior_period_cap := PN_REC_CALC_PKG.get_prior_period_cap(
1602: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1603: ,p_start_date => p_calc_period_start_date
1604: ,p_end_date => p_calc_period_end_date
1605: ,p_as_of_date => p_as_of_date

Line 1627: l_line_abatements := PN_REC_CALC_PKG.get_line_abatements(

1623:
1624: pnp_debug_pkg.log('Error Code 24 : '||p_error_code);
1625: IF p_error_code <> -99 THEN
1626:
1627: l_line_abatements := PN_REC_CALC_PKG.get_line_abatements(
1628: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1629: ,p_as_of_date => p_as_of_date
1630: );
1631:

Line 1949: l_rec_period_lines_id := PN_REC_CALC_PKG.find_if_period_line_exists(

1945: end dates and the as of date.If it has not, then insert a new record into the
1946: PN_REC_PERIOD_LINES_ALL table with the calculated values or else update the
1947: existing record with the values as a result of the re-calculation. */
1948:
1949: l_rec_period_lines_id := PN_REC_CALC_PKG.find_if_period_line_exists(
1950: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1951: ,p_rec_calc_period_id => p_rec_calc_period_id);
1952:
1953: IF l_rec_period_lines_id = -99 THEN

Line 1980: PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW(

1976: ELSE
1977: l_status := 'COMPLETE';
1978: END IF;
1979:
1980: PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW(
1981: X_ROWID => l_rowId
1982: ,X_REC_PERIOD_LINES_ID => l_rec_period_lines_id
1983: ,X_BUDGET_PCT => l_BUDGET_PCT
1984: ,X_OCCUPANCY_PCT => l_ten_occupancy_pct

Line 2041: PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW(

2037: ELSE
2038: l_status := 'COMPLETE';
2039: END IF;
2040:
2041: PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW(
2042: X_REC_PERIOD_LINES_ID => l_rec_period_lines_id
2043: ,X_BUDGET_PCT => l_BUDGET_PCT
2044: ,X_OCCUPANCY_PCT => l_ten_occupancy_pct
2045: ,X_MULTIPLE_PCT => agr_lines_record.MULTIPLE_PCT

Line 2274: PN_REC_CALC_PKG.create_payment_terms(

2270: l_rec_agr_line_id := -1;
2271: pnp_debug_pkg.log('Set Line Id to -1');
2272: END IF;
2273:
2274: PN_REC_CALC_PKG.create_payment_terms(
2275: p_lease_id => p_lease_id
2276: ,p_payment_amount => l_reconciled_amount
2277: ,p_rec_calc_period_id => p_rec_calc_period_id
2278: ,p_calc_period_end_date => l_end_date

Line 2330: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT (-) ');

2326: END LOOP;
2327:
2328: END IF;
2329:
2330: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT (-) ');
2331:
2332: EXCEPTION
2333:
2334: When OTHERS Then

Line 2335: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT '|| to_char(sqlcode));

2331:
2332: EXCEPTION
2333:
2334: When OTHERS Then
2335: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT '|| to_char(sqlcode));
2336:
2337: END CALCULATE_REC_AMOUNT;
2338:
2339: /*===========================================================================+

Line 2379: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_recoverable_area (+) ');

2375: l_recoverable_area pn_rec_period_lines_all.recoverable_area%TYPE;
2376:
2377: BEGIN
2378:
2379: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_recoverable_area (+) ');
2380:
2381: SELECT NVL(plines.recoverable_area,0)
2382: INTO l_recoverable_area
2383: FROM pn_rec_period_lines_all plines

Line 2388: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_recoverable_area (-) ');

2384: WHERE plines.rec_agr_line_id = p_rec_agr_line_id
2385: AND plines.rec_calc_period_id = p_rec_calc_period_id
2386: ;
2387:
2388: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_recoverable_area (-) ');
2389:
2390: RETURN l_recoverable_area;
2391:
2392:

Line 2488: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_tot_prop_area (+) ');

2484: AND area_class_dtl_lines.location_id = p_location_id
2485: ;
2486: BEGIN
2487:
2488: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_tot_prop_area (+) ');
2489:
2490: l_context := 'getting area type';
2491:
2492: open c_area;

Line 2550: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_tot_prop_area (-) ');

2546: l_greater_area := l_net_wgt_avg_area;
2547: end if;
2548: l_tot_prop_area := l_greater_area;
2549:
2550: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_tot_prop_area (-) ');
2551:
2552: RETURN l_tot_prop_area;
2553:
2554: EXCEPTION

Line 2609: pnp_debug_pkg.log('PN_REC_CALC_PKG.ten_recoverable_area (+) ');

2605: l_ten_recoverable_area_rec ten_recoverable_area_rec;
2606:
2607: BEGIN
2608:
2609: pnp_debug_pkg.log('PN_REC_CALC_PKG.ten_recoverable_area (+) ');
2610:
2611: SELECT nvl(area_class_dtl_lines.occupied_area_ovr, area_class_dtl_lines.occupied_area)
2612: ,occupancy_pct
2613: INTO l_ten_recoverable_area_rec

Line 2632: pnp_debug_pkg.log('PN_REC_CALC_PKG.ten_recoverable_area (-) ');

2628: AND area_class_dtl_lines.location_id = p_location_id
2629: AND area_class_dtl_lines.include_flag = 'Y'
2630: ;
2631:
2632: pnp_debug_pkg.log('PN_REC_CALC_PKG.ten_recoverable_area (-) ');
2633:
2634: RETURN l_ten_recoverable_area_rec;
2635:
2636: EXCEPTION

Line 2755: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (+) ');

2751: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;
2752:
2753: BEGIN
2754:
2755: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (+) ');
2756:
2757: -- Fix for bug # 3123283
2758: OPEN csr_get_line;
2759: FETCH csr_get_line into l_line_purpose, l_line_type;

Line 2852: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (-) ');

2848: ELSE
2849: RETURN -99;
2850: END IF;
2851:
2852: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (-) ');
2853:
2854: END get_contr_actual_recovery;
2855:
2856: /*===========================================================================+

Line 2907: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (+) ');

2903: l_fee_after pn_rec_expcl_dtlln_all.cls_line_fee_after_contr_ovr%TYPE;
2904:
2905: BEGIN
2906:
2907: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (+) ');
2908:
2909: SELECT nvl(exp_detail_line.computed_recoverable_amt,0),
2910: nvl(exp_detail_line.cls_line_fee_before_contr_ovr,0),
2911: nvl(exp_detail_hdr.cls_line_fee_after_contr,0)

Line 2951: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (-) ');

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;
2954:
2955: /*===========================================================================+

Line 3002: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (+) ');

2998: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
2999:
3000: BEGIN
3001:
3002: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (+) ');
3003: pnp_debug_pkg.log('Agr line ID: '||p_rec_agr_line_id);
3004: pnp_debug_pkg.log('Cust ID: '||p_customer_id);
3005: pnp_debug_pkg.log('lease ID: '||p_lease_id);
3006: pnp_debug_pkg.log('Location ID: '||p_location_id);

Line 3057: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (-) ');

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 (-) ');
3058:
3059: END get_budget_expenses;
3060:
3061: /*===========================================================================+

Line 3112: PN_REC_CALC_PKG.find_if_period_line_exists(

3108: RETURN pn_rec_period_lines_all.billed_recovery%TYPE IS
3109:
3110: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE;
3111: l_rec_period_lines_id pn_rec_period_lines_all.rec_period_lines_id%TYPE :=
3112: PN_REC_CALC_PKG.find_if_period_line_exists(
3113: p_rec_agr_line_id
3114: ,p_rec_calc_period_id
3115: );
3116:

Line 3119: pnp_debug_pkg.log('PN_REC_CALC_PKG.billed_recovery (+) ');

3115: );
3116:
3117: BEGIN
3118:
3119: pnp_debug_pkg.log('PN_REC_CALC_PKG.billed_recovery (+) ');
3120:
3121:
3122: SELECT nvl(SUM(pitem.actual_amount),0)
3123: INTO l_billed_recovery

Line 3156: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_billed_recovery (-) ');

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:
3158: END get_billed_recovery;
3159:
3160: /*===========================================================================+

Line 3215: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');

3211: i NUMBER :=0;
3212:
3213: BEGIN
3214:
3215: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');
3216: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);
3217: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));
3218:
3219: FOR line_constr_rec in get_line_constr_csr

Line 3216: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);

3212:
3213: BEGIN
3214:
3215: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');
3216: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);
3217: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));
3218:
3219: FOR line_constr_rec in get_line_constr_csr
3220:

Line 3217: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));

3213: BEGIN
3214:
3215: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');
3216: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);
3217: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));
3218:
3219: FOR line_constr_rec in get_line_constr_csr
3220:
3221: LOOP

Line 3234: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_constraints (-) ');

3230: line_constr_tbl(i).base_year := line_constr_rec.base_year;
3231:
3232: END LOOP;
3233:
3234: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_constraints (-) ');
3235: RETURN line_constr_tbl;
3236:
3237: EXCEPTION
3238:

Line 3307: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_abatements (+) ');

3303: OPEN csr_get_abate;
3304: FETCH csr_get_abate into l_line_abatements;
3305: CLOSE csr_get_abate;
3306:
3307: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_abatements (+) ');
3308:
3309:
3310: RETURN l_line_abatements;
3311:

Line 3321: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_abatements (-) ');

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 (-) ');
3322:
3323: END get_line_abatements;
3324:
3325: /*===========================================================================+

Line 3364: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.find_if_period_line_exists (+)');

3360: l_rec_period_lines_id pn_rec_period_lines_all.rec_period_lines_id%TYPE;
3361:
3362: BEGIN
3363:
3364: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.find_if_period_line_exists (+)');
3365:
3366: OPEN csr_chck_exist;
3367: FETCH csr_chck_exist INTO l_rec_period_lines_id;
3368: IF csr_chck_exist%NOTFOUND THEN

Line 3473: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW (+)');

3469: l_org_ID NUMBER;
3470:
3471: BEGIN
3472:
3473: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW (+)');
3474:
3475: -------------------------------------------------------
3476: -- Select the nextval for group date id
3477: -------------------------------------------------------

Line 3578: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW (-)');

3574: raise no_data_found;
3575: end if;
3576: close c;
3577:
3578: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW (-)');
3579:
3580: EXCEPTION
3581: WHEN OTHERS THEN
3582:

Line 3651: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW (+)');

3647: ) is
3648:
3649: BEGIN
3650:
3651: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW (+)');
3652:
3653: update PN_REC_PERIOD_LINES_ALL set
3654: BUDGET_PCT = X_BUDGET_PCT
3655: ,OCCUPANCY_PCT = X_OCCUPANCY_PCT

Line 3693: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW (-)');

3689: if (sql%notfound) then
3690: raise no_data_found;
3691: end if;
3692:
3693: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW (-)');
3694:
3695: EXCEPTION
3696: WHEN OTHERS THEN
3697:

Line 3733: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_LINES_ROW (+)');

3729: ) is
3730:
3731: BEGIN
3732:
3733: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_LINES_ROW (+)');
3734:
3735: delete from PN_REC_PERIOD_LINES_ALL
3736: where REC_PERIOD_LINES_ID = X_REC_PERIOD_LINES_ID;
3737:

Line 3742: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_LINES_ROW (-)');

3738: if (sql%notfound) then
3739: raise no_data_found;
3740: end if;
3741:
3742: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_LINES_ROW (-)');
3743:
3744: end DELETE_PERIOD_LINES_ROW;
3745:
3746: /*===========================================================================+

Line 3795: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_BILLREC_ROW (+)');

3791: l_org_ID NUMBER;
3792:
3793: BEGIN
3794:
3795: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_BILLREC_ROW (+)');
3796:
3797: -------------------------------------------------------
3798: -- Select the nextval for PERIOD_BILLREC_ID
3799: -------------------------------------------------------

Line 3849: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_BILLREC_ROW (-)');

3845: RAISE NO_DATA_FOUND;
3846: END IF;
3847: CLOSE C;
3848:
3849: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_BILLREC_ROW (-)');
3850:
3851: END INSERT_PERIOD_BILLREC_ROW;
3852:
3853: /*===========================================================================+

Line 3889: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (+)');

3885: ) is
3886:
3887: BEGIN
3888:
3889: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (+)');
3890:
3891: update PN_REC_PERIOD_BILL_ALL set
3892: REC_AGR_LINE_ID = X_REC_AGR_LINE_ID
3893: ,REC_AGREEMENT_ID = X_REC_AGREEMENT_ID

Line 3907: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (-)');

3903: if (sql%notfound) then
3904: raise no_data_found;
3905: end if;
3906:
3907: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (-)');
3908:
3909: end UPDATE_PERIOD_BILLREC_ROW;
3910:
3911: /*===========================================================================+

Line 3940: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (+)');

3936: ) is
3937:
3938: BEGIN
3939:
3940: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (+)');
3941:
3942: delete from PN_REC_PERIOD_BILL_ALL
3943: where PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
3944:

Line 3949: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (-)');

3945: if (sql%notfound) then
3946: raise no_data_found;
3947: end if;
3948:
3949: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (-)');
3950:
3951: end DELETE_PERIOD_BILLREC_ROW;
3952:
3953: /*===========================================================================+

Line 4096: pnp_debug_pkg.log ('PN_REC_CALC_PKG.create_payment_terms : (+)');

4092:
4093:
4094: BEGIN
4095:
4096: pnp_debug_pkg.log ('PN_REC_CALC_PKG.create_payment_terms : (+)');
4097:
4098: IF p_org_id IS NULL THEN
4099: FOR rec IN org_cur LOOP
4100: l_org_id := rec.org_id;

Line 4239: l_period_bill_record := PN_REC_CALC_PKG.find_if_rec_payterm_exists(

4235: END IF;
4236:
4237:
4238: l_context := 'Checking term exists ';
4239: l_period_bill_record := PN_REC_CALC_PKG.find_if_rec_payterm_exists(
4240: p_rec_agreement_id
4241: ,p_rec_agr_line_id
4242: ,p_rec_calc_period_id
4243: ,p_consolidate

Line 4266: PN_REC_CALC_PKG.update_period_billrec_row (

4262: l_payment_amount := p_payment_amount - l_payment_amount;
4263:
4264: l_context := 'Updating period_billrec ';
4265:
4266: PN_REC_CALC_PKG.update_period_billrec_row (
4267: X_PERIOD_BILLREC_ID => l_period_billrec_id
4268: ,X_REC_AGREEMENT_ID => p_rec_agreement_id
4269: ,X_REC_AGR_LINE_ID => p_rec_agr_line_id
4270: ,X_REC_CALC_PERIOD_ID => p_rec_calc_period_id

Line 4286: PN_REC_CALC_PKG.insert_period_billrec_row (

4282: pnp_debug_pkg.log ('insert_period_billrec_row - agr id :'||p_rec_agreement_id);
4283: pnp_debug_pkg.log ('insert_period_billrec_row - p_rec_agr_line_id :'||p_rec_agr_line_id);
4284: pnp_debug_pkg.log ('insert_period_billrec_row - p_rec_calc_period_id :'||p_rec_calc_period_id);
4285: pnp_debug_pkg.log ('insert_period_billrec_row - amount :'||l_payment_amount);
4286: PN_REC_CALC_PKG.insert_period_billrec_row (
4287: X_ROWID => l_rowId
4288: ,X_PERIOD_BILLREC_ID => l_period_billrec_id
4289: ,X_REC_AGREEMENT_ID => p_rec_agreement_id
4290: ,X_REC_AGR_LINE_ID => p_rec_agr_line_id

Line 4545: pnp_debug_pkg.log('PN_REC_CALC_PKG.create_payment_terms (-) ');

4541:
4542: END IF;
4543:
4544: END IF;
4545: pnp_debug_pkg.log('PN_REC_CALC_PKG.create_payment_terms (-) ');
4546:
4547: EXCEPTION
4548: when others then
4549: pnp_debug_pkg.log('Error while' || l_context || to_char(sqlcode));

Line 4624: pnp_debug_pkg.log('PN_REC_CALC_PKG.find_if_rec_payterm_exists (+) ');

4620: -- Fix for bug # 3142328
4621:
4622: BEGIN
4623:
4624: pnp_debug_pkg.log('PN_REC_CALC_PKG.find_if_rec_payterm_exists (+) ');
4625:
4626: l_period_bill_record.amount := 0;
4627: l_period_bill_record.period_billrec_id:= 0;
4628: l_distributions_exist := 'N';

Line 4731: pnp_debug_pkg.log('PN_REC_CALC_PKG.find_if_rec_payterm_exists (-) ');

4727:
4728: END IF;
4729:
4730: pnp_debug_pkg.log('find_if_rec_payterm_exists - terms deleted '|| to_char(SQL%ROWCOUNT));
4731: pnp_debug_pkg.log('PN_REC_CALC_PKG.find_if_rec_payterm_exists (-) ');
4732:
4733: RETURN l_period_bill_record;
4734:
4735: EXCEPTION

Line 4792: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_actual_amount (+) ');

4788: AND lineconst.SCOPE = 'OPYA';
4789:
4790: BEGIN
4791:
4792: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_actual_amount (+) ');
4793:
4794: SELECT NVL(period_lines.constrained_actual,0)
4795: INTO l_prior_period_amount
4796: FROM pn_rec_period_lines_all period_lines

Line 4855: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_actual_amount (-) ');

4851: ELSE
4852: return -99;
4853: END IF;
4854:
4855: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_actual_amount (-) ');
4856:
4857: END get_prior_period_actual_amount;
4858:
4859: /*===========================================================================+

Line 4930: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_cap (+) ');

4926: AND lineconst.SCOPE = 'OPYC';
4927:
4928: BEGIN
4929:
4930: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_cap (+) ');
4931:
4932: OPEN csr_get_base_cap;
4933: FETCH csr_get_base_cap into l_cap_amount,l_start_date,l_end_date;
4934:

Line 4994: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_cap (-) ');

4990: close csr_get_curr_percent;
4991:
4992: END IF;
4993:
4994: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_cap (-) ');
4995:
4996: RETURN l_cap_amount;
4997:
4998: EXCEPTION

Line 5156: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (+) ');

5152: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5153:
5154: begin
5155:
5156: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (+) ');
5157:
5158: FOR l_term_rec in c_term
5159: LOOP
5160:

Line 5254: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (-) ');

5250: END IF;
5251:
5252: END LOOP;
5253: commit;
5254: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (-) ');
5255: Exception
5256: when others then
5257: pnp_debug_pkg.log(' error in PN_REC_CALC_PKG.lock_area_exp_cls_dtl :'||to_char(sqlcode)||' : '||sqlerrm);
5258: raise;

Line 5257: pnp_debug_pkg.log(' error in PN_REC_CALC_PKG.lock_area_exp_cls_dtl :'||to_char(sqlcode)||' : '||sqlerrm);

5253: commit;
5254: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (-) ');
5255: Exception
5256: when others then
5257: pnp_debug_pkg.log(' error in PN_REC_CALC_PKG.lock_area_exp_cls_dtl :'||to_char(sqlcode)||' : '||sqlerrm);
5258: raise;
5259:
5260: END lock_area_exp_cls_dtl ;
5261:

Line 5300: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');

5296: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
5297: l_period_count NUMBER;
5298: l_org_id NUMBER;
5299: BEGIN
5300: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');
5301:
5302: SELECT count(1)
5303: INTO l_period_count
5304: FROM pn_rec_calc_periods_all

Line 5350: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');

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:
5352: EXCEPTION
5353: WHEN OTHERS THEN
5354: pnp_debug_pkg.log('error in PN_REC_CALC_PKG.validate_create_calc_period :'||to_char(sqlcode)||' : '||sqlerrm);

Line 5354: pnp_debug_pkg.log('error in PN_REC_CALC_PKG.validate_create_calc_period :'||to_char(sqlcode)||' : '||sqlerrm);

5350: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');
5351:
5352: EXCEPTION
5353: WHEN OTHERS THEN
5354: pnp_debug_pkg.log('error in PN_REC_CALC_PKG.validate_create_calc_period :'||to_char(sqlcode)||' : '||sqlerrm);
5355: raise;
5356: END validate_create_calc_period;
5357:
5358: END PN_REC_CALC_PKG;

Line 5358: END PN_REC_CALC_PKG;

5354: pnp_debug_pkg.log('error in PN_REC_CALC_PKG.validate_create_calc_period :'||to_char(sqlcode)||' : '||sqlerrm);
5355: raise;
5356: END validate_create_calc_period;
5357:
5358: END PN_REC_CALC_PKG;