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.15.12020000.2 2012/07/18 10:00:02 admarath 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: l_rec_calc_period_id := p_rec_calc_period_id;
238:
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));

Line 301: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(

297: IF l_rec_calc_period_id <> -1 THEN
298:
299: l_processed := l_processed + 1;
300:
301: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(
302: p_rec_agreement_id => p_rec_agreement_id
303: ,p_lease_id => p_lease_id
304: ,p_location_id => p_location_id
305: ,p_customer_id => p_customer_id

Line 409: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(

405: IF l_rec_calc_period_id <> -1 THEN
406:
407: l_processed := l_processed + 1;
408:
409: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(
410: p_rec_agreement_id => l_rec_agreement_id
411: ,p_lease_id => l_lease_id
412: ,p_location_id => l_location_id
413: ,p_customer_id => l_customer_id

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

463: pnp_debug_pkg.put_log_msg('Term template '||template_name_tbl(i)||
464: ' has an existing tax code or tax group.A corresponding tax classification will replace it');
465: END LOOP;
466:
467: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (-) ');
468:
469: EXCEPTION
470:
471: When OTHERS Then

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

468:
469: EXCEPTION
470:
471: When OTHERS Then
472: pnp_debug_pkg.log('Error in PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH :'||to_char(sqlcode)||' : '||sqlerrm);
473: Errbuf := SQLERRM;
474: Retcode := 2;
475: rollback;
476: raise;

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

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

Line 730: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(

726: THEN
727:
728: l_processed := l_processed + 1;
729:
730: PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT(
731: p_rec_agreement_id => l_rec_agreement_id
732: ,p_lease_id => l_lease_id
733: ,p_location_id => l_location_id
734: ,p_customer_id => l_customer_id

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

781: ELSIF calc_rec_amount_woloc%ISOPEN THEN
782: CLOSE calc_rec_amount_woloc;
783: END IF;
784:
785: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (-) ');
786:
787: EXCEPTION
788:
789: When OTHERS Then

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

786:
787: EXCEPTION
788:
789: When OTHERS Then
790: pnp_debug_pkg.log('Error in PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH :'||to_char(sqlcode)||' : '||sqlerrm);
791: Errbuf := SQLERRM;
792: Retcode := 2;
793: rollback;
794: raise;

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

1059: l_org_id NUMBER;
1060:
1061: BEGIN
1062:
1063: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT (+) ');
1064:
1065: /* Get currency code and negative recovery value for the agreement */
1066:
1067: FOR rec IN csr_currency_code LOOP

Line 1171: PN_REC_CALC_PKG.get_line_expenses(

1167: pnp_debug_pkg.log('get_line_expenses - Location id : '||p_location_id);
1168: pnp_debug_pkg.log('get_line_expenses - Start Date : '||p_calc_period_start_date);
1169: pnp_debug_pkg.log('get_line_expenses - End Date : '||p_calc_period_end_date);
1170:
1171: PN_REC_CALC_PKG.get_line_expenses(
1172: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1173: ,p_customer_id => p_customer_id
1174: ,p_lease_id => p_lease_id
1175: ,p_location_id => p_location_id

Line 1193: l_budget_expense := PN_REC_CALC_PKG.get_budget_expenses(

1189: pnp_debug_pkg.log('get_line_expenses - Return Status : '||p_error);
1190: pnp_debug_pkg.log('get_line_expenses - Return Code : '||p_error_code);
1191:
1192: IF p_error_code <> -99 THEN
1193: l_budget_expense := PN_REC_CALC_PKG.get_budget_expenses(
1194: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1195: ,p_customer_id => p_customer_id
1196: ,p_lease_id => p_lease_id
1197: ,p_location_id => p_location_id

Line 1223: l_contr_actual_recovery := PN_REC_CALC_PKG.get_contr_actual_recovery(

1219: pnp_debug_pkg.log('Error Code 1 : '||p_error_code);
1220:
1221: IF p_error_code <> -99 THEN
1222:
1223: l_contr_actual_recovery := PN_REC_CALC_PKG.get_contr_actual_recovery(
1224: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1225: ,p_customer_id => p_customer_id
1226: ,p_lease_id => p_lease_id
1227: ,p_location_id => p_location_id

Line 1335: l_tot_prop_area := PN_REC_CALC_PKG.get_tot_prop_area(

1331: pnp_debug_pkg.log('get_tot_prop_area - Start Date : '||p_calc_period_start_date);
1332: pnp_debug_pkg.log('get_tot_prop_area - End Date : '||p_calc_period_end_date);
1333: pnp_debug_pkg.log('get_tot_prop_area - As of Date : '||p_as_of_date);
1334:
1335: l_tot_prop_area := PN_REC_CALC_PKG.get_tot_prop_area(
1336: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1337: ,p_customer_id => p_customer_id
1338: ,p_lease_id => p_lease_id
1339: ,p_location_id => p_location_id

Line 1404: l_ten_recoverable_area_rec := PN_REC_CALC_PKG.ten_recoverable_area(

1400: pnp_debug_pkg.log('ten_recoverable_area - Start Date : '||p_calc_period_start_date);
1401: pnp_debug_pkg.log('ten_recoverable_area - End Date : '||p_calc_period_end_date);
1402: pnp_debug_pkg.log('ten_recoverable_area - As of Date : '||p_as_of_date);
1403:
1404: l_ten_recoverable_area_rec := PN_REC_CALC_PKG.ten_recoverable_area(
1405: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1406: ,p_customer_id => p_customer_id
1407: ,p_lease_id => p_lease_id
1408: ,p_location_id => p_location_id

Line 1449: l_ten_recoverable_area := PN_REC_CALC_PKG.get_recoverable_area(

1445: -- For fixed rate we have the rate available and since the user puts
1446: -- in the recoverable area occupancy % is 100%
1447:
1448: l_rate := agr_lines_record.fixed_rate;
1449: l_ten_recoverable_area := PN_REC_CALC_PKG.get_recoverable_area(
1450: p_rec_calc_period_id => p_rec_calc_period_id
1451: ,p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1452: );
1453: IF l_ten_recoverable_area = -99 THEN

Line 1549: l_billed_recovery := PN_REC_CALC_PKG.get_billed_recovery(

1545: pnp_debug_pkg.log('get_billed_recovery - Start Date : '||p_calc_period_start_date);
1546: pnp_debug_pkg.log('get_billed_recovery - End Date : '||p_calc_period_end_date);
1547: pnp_debug_pkg.log('get_billed_recovery - Calc Period Id : '||p_rec_calc_period_id);
1548:
1549: l_billed_recovery := PN_REC_CALC_PKG.get_billed_recovery(
1550: p_payment_purpose => agr_lines_record.purpose
1551: ,p_payment_type => agr_lines_record.type
1552: ,p_lease_id => p_lease_id
1553: ,p_location_id => p_location_id -- 110403

Line 1577: line_constr_tbl := PN_REC_CALC_PKG.get_line_constraints(

1573:
1574: pnp_debug_pkg.log('Error Code 21 : '||p_error_code);
1575: IF p_error_code <> -99 THEN
1576:
1577: line_constr_tbl := PN_REC_CALC_PKG.get_line_constraints(
1578: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id ,
1579: p_as_of_date => p_as_of_date
1580: );
1581:

Line 1601: l_prior_period_amount := PN_REC_CALC_PKG.get_prior_period_actual_amount(

1597: pnp_debug_pkg.log('After getting constraints error code:'||p_error_code);
1598: pnp_debug_pkg.log('Error Code 22 : '||p_error_code);
1599: IF p_error_code <> -99 THEN
1600:
1601: l_prior_period_amount := PN_REC_CALC_PKG.get_prior_period_actual_amount(
1602: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1603: ,p_start_date => p_calc_period_start_date
1604: ,p_as_of_date => p_as_of_date
1605: ,p_called_from => 'CALC'

Line 1626: l_prior_period_cap := PN_REC_CALC_PKG.get_prior_period_cap(

1622:
1623: pnp_debug_pkg.log('Error Code 23 : '||p_error_code);
1624: IF p_error_code <> -99 THEN
1625:
1626: l_prior_period_cap := PN_REC_CALC_PKG.get_prior_period_cap(
1627: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1628: ,p_start_date => p_calc_period_start_date
1629: ,p_end_date => p_calc_period_end_date
1630: ,p_as_of_date => p_as_of_date

Line 1652: l_line_abatements := PN_REC_CALC_PKG.get_line_abatements(

1648:
1649: pnp_debug_pkg.log('Error Code 24 : '||p_error_code);
1650: IF p_error_code <> -99 THEN
1651:
1652: l_line_abatements := PN_REC_CALC_PKG.get_line_abatements(
1653: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1654: ,p_as_of_date => p_as_of_date
1655: );
1656:

Line 1974: l_rec_period_lines_id := PN_REC_CALC_PKG.find_if_period_line_exists(

1970: end dates and the as of date.If it has not, then insert a new record into the
1971: PN_REC_PERIOD_LINES_ALL table with the calculated values or else update the
1972: existing record with the values as a result of the re-calculation. */
1973:
1974: l_rec_period_lines_id := PN_REC_CALC_PKG.find_if_period_line_exists(
1975: p_rec_agr_line_id => agr_lines_record.rec_agr_line_id
1976: ,p_rec_calc_period_id => p_rec_calc_period_id);
1977:
1978: IF l_rec_period_lines_id = -99 THEN

Line 2005: PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW(

2001: ELSE
2002: l_status := 'COMPLETE';
2003: END IF;
2004:
2005: PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW(
2006: X_ROWID => l_rowId
2007: ,X_REC_PERIOD_LINES_ID => l_rec_period_lines_id
2008: ,X_BUDGET_PCT => l_BUDGET_PCT
2009: ,X_OCCUPANCY_PCT => l_ten_occupancy_pct

Line 2066: PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW(

2062: ELSE
2063: l_status := 'COMPLETE';
2064: END IF;
2065:
2066: PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW(
2067: X_REC_PERIOD_LINES_ID => l_rec_period_lines_id
2068: ,X_BUDGET_PCT => l_BUDGET_PCT
2069: ,X_OCCUPANCY_PCT => l_ten_occupancy_pct
2070: ,X_MULTIPLE_PCT => agr_lines_record.MULTIPLE_PCT

Line 2299: pnp_debug_pkg.log('Before calling PN_REC_CALC_PKG.create_payment_terms '|| p_error_code);

2295: l_rec_agr_line_id := -1;
2296: pnp_debug_pkg.log('Set Line Id to -1');
2297: END IF;
2298:
2299: pnp_debug_pkg.log('Before calling PN_REC_CALC_PKG.create_payment_terms '|| p_error_code);
2300: p_error_code := 0; --Initialize p_error_code Fix for bug#9091777
2301:
2302: PN_REC_CALC_PKG.create_payment_terms(
2303: p_lease_id => p_lease_id

Line 2302: PN_REC_CALC_PKG.create_payment_terms(

2298:
2299: pnp_debug_pkg.log('Before calling PN_REC_CALC_PKG.create_payment_terms '|| p_error_code);
2300: p_error_code := 0; --Initialize p_error_code Fix for bug#9091777
2301:
2302: PN_REC_CALC_PKG.create_payment_terms(
2303: p_lease_id => p_lease_id
2304: ,p_payment_amount => l_reconciled_amount
2305: ,p_rec_calc_period_id => p_rec_calc_period_id
2306: ,p_calc_period_end_date => l_end_date

Line 2320: pnp_debug_pkg.log('After calling PN_REC_CALC_PKG.create_payment_terms '|| p_error_code);

2316: ,p_consolidate => l_consolidate
2317: ,p_error => p_error
2318: ,p_error_code => p_error_code
2319: );
2320: pnp_debug_pkg.log('After calling PN_REC_CALC_PKG.create_payment_terms '|| p_error_code);
2321:
2322: IF p_error_code = -99 THEN
2323: IF l_consolidate = 'Y' AND l_calculate_all THEN
2324: pnp_debug_pkg.log('Rolling Back Lines for l_consolidate = Y and l_calculate_all');

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

2356: END LOOP;
2357:
2358: END IF;
2359:
2360: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT (-) ');
2361:
2362: EXCEPTION
2363:
2364: When OTHERS Then

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

2361:
2362: EXCEPTION
2363:
2364: When OTHERS Then
2365: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT '|| to_char(sqlcode));
2366:
2367: END CALCULATE_REC_AMOUNT;
2368:
2369: /*===========================================================================+

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

2405: l_recoverable_area pn_rec_period_lines_all.recoverable_area%TYPE;
2406:
2407: BEGIN
2408:
2409: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_recoverable_area (+) ');
2410:
2411: SELECT NVL(plines.recoverable_area,0)
2412: INTO l_recoverable_area
2413: FROM pn_rec_period_lines_all plines

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

2414: WHERE plines.rec_agr_line_id = p_rec_agr_line_id
2415: AND plines.rec_calc_period_id = p_rec_calc_period_id
2416: ;
2417:
2418: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_recoverable_area (-) ');
2419:
2420: RETURN l_recoverable_area;
2421:
2422:

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

2515: AND area_class_dtl_lines.location_id = p_location_id
2516: ;
2517: BEGIN
2518:
2519: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_tot_prop_area (+) ');
2520:
2521: l_context := 'getting area type';
2522:
2523: open c_area;

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

2580: l_greater_area := l_net_wgt_avg_area;
2581: end if;
2582: l_tot_prop_area := l_greater_area;
2583:
2584: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_tot_prop_area (-) ');
2585:
2586: RETURN l_tot_prop_area;
2587:
2588: EXCEPTION

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

2639: l_ten_recoverable_area_rec ten_recoverable_area_rec;
2640:
2641: BEGIN
2642:
2643: pnp_debug_pkg.log('PN_REC_CALC_PKG.ten_recoverable_area (+) ');
2644:
2645: SELECT nvl(area_class_dtl_lines.occupied_area_ovr, area_class_dtl_lines.occupied_area)
2646: ,occupancy_pct
2647: INTO l_ten_recoverable_area_rec

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

2662: AND area_class_dtl_lines.location_id = p_location_id
2663: AND area_class_dtl_lines.include_flag = 'Y'
2664: ;
2665:
2666: pnp_debug_pkg.log('PN_REC_CALC_PKG.ten_recoverable_area (-) ');
2667:
2668: RETURN l_ten_recoverable_area_rec;
2669:
2670: EXCEPTION

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

2785: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;
2786:
2787: BEGIN
2788:
2789: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (+) ');
2790:
2791: -- Fix for bug # 3123283
2792: OPEN csr_get_line;
2793: FETCH csr_get_line into l_line_purpose, l_line_type;

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

2882: ELSE
2883: RETURN -99;
2884: END IF;
2885:
2886: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (-) ');
2887:
2888: END get_contr_actual_recovery;
2889:
2890: /*===========================================================================+

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

2941: l_expense_type_count Number := 0;
2942:
2943: BEGIN
2944:
2945: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_expenses (+) ');
2946:
2947: --Added expense_class_id in the Select clause which will be used to check expense types
2948: SELECT distinct nvl(exp_detail_line.computed_recoverable_amt,0),
2949: nvl(exp_detail_line.cls_line_fee_before_contr_ovr,0),

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

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;
3039:
3040: /*===========================================================================+

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

3083: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
3084:
3085: BEGIN
3086:
3087: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_budget_expenses (+) ');
3088: pnp_debug_pkg.log('Agr line ID: '||p_rec_agr_line_id);
3089: pnp_debug_pkg.log('Cust ID: '||p_customer_id);
3090: pnp_debug_pkg.log('lease ID: '||p_lease_id);
3091: pnp_debug_pkg.log('Location ID: '||p_location_id);

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

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 (-) ');
3143:
3144: END get_budget_expenses;
3145:
3146: /*===========================================================================+

Line 3197: PN_REC_CALC_PKG.find_if_period_line_exists(

3193: RETURN pn_rec_period_lines_all.billed_recovery%TYPE IS
3194:
3195: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE;
3196: l_rec_period_lines_id pn_rec_period_lines_all.rec_period_lines_id%TYPE :=
3197: PN_REC_CALC_PKG.find_if_period_line_exists(
3198: p_rec_agr_line_id
3199: ,p_rec_calc_period_id
3200: );
3201:

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

3200: );
3201:
3202: BEGIN
3203:
3204: pnp_debug_pkg.log('PN_REC_CALC_PKG.billed_recovery (+) ');
3205:
3206:
3207: SELECT nvl(SUM(pitem.actual_amount),0)
3208: INTO l_billed_recovery

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

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:
3243: END get_billed_recovery;
3244:
3245: /*===========================================================================+

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

3296: i NUMBER :=0;
3297:
3298: BEGIN
3299:
3300: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');
3301: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);
3302: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));
3303:
3304: FOR line_constr_rec in get_line_constr_csr

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

3297:
3298: BEGIN
3299:
3300: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');
3301: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);
3302: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));
3303:
3304: FOR line_constr_rec in get_line_constr_csr
3305:

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

3298: BEGIN
3299:
3300: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints (+) ');
3301: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -line id'|| p_rec_agr_line_id);
3302: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_constraints -as of date '|| to_char(p_as_of_date));
3303:
3304: FOR line_constr_rec in get_line_constr_csr
3305:
3306: LOOP

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

3315: line_constr_tbl(i).base_year := line_constr_rec.base_year;
3316:
3317: END LOOP;
3318:
3319: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_line_constraints (-) ');
3320: RETURN line_constr_tbl;
3321:
3322: EXCEPTION
3323:

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

3388: OPEN csr_get_abate;
3389: FETCH csr_get_abate into l_line_abatements;
3390: CLOSE csr_get_abate;
3391:
3392: pnp_debug_pkg.log('PN_REC_CALC_PKG.line_abatements (+) ');
3393:
3394:
3395: RETURN l_line_abatements;
3396:

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

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 (-) ');
3407:
3408: END get_line_abatements;
3409:
3410: /*===========================================================================+

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

3445: l_rec_period_lines_id pn_rec_period_lines_all.rec_period_lines_id%TYPE;
3446:
3447: BEGIN
3448:
3449: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.find_if_period_line_exists (+)');
3450:
3451: OPEN csr_chck_exist;
3452: FETCH csr_chck_exist INTO l_rec_period_lines_id;
3453: IF csr_chck_exist%NOTFOUND THEN

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

3554: l_org_ID NUMBER;
3555:
3556: BEGIN
3557:
3558: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW (+)');
3559:
3560: -------------------------------------------------------
3561: -- Select the nextval for group date id
3562: -------------------------------------------------------

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

3659: raise no_data_found;
3660: end if;
3661: close c;
3662:
3663: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_LINES_ROW (-)');
3664:
3665: EXCEPTION
3666: WHEN OTHERS THEN
3667:

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

3732: ) is
3733:
3734: BEGIN
3735:
3736: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW (+)');
3737:
3738: update PN_REC_PERIOD_LINES_ALL set
3739: BUDGET_PCT = X_BUDGET_PCT
3740: ,OCCUPANCY_PCT = X_OCCUPANCY_PCT

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

3774: if (sql%notfound) then
3775: raise no_data_found;
3776: end if;
3777:
3778: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_LINES_ROW (-)');
3779:
3780: EXCEPTION
3781: WHEN OTHERS THEN
3782:

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

3814: ) is
3815:
3816: BEGIN
3817:
3818: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_LINES_ROW (+)');
3819:
3820: delete from PN_REC_PERIOD_LINES_ALL
3821: where REC_PERIOD_LINES_ID = X_REC_PERIOD_LINES_ID;
3822:

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

3823: if (sql%notfound) then
3824: raise no_data_found;
3825: end if;
3826:
3827: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_LINES_ROW (-)');
3828:
3829: end DELETE_PERIOD_LINES_ROW;
3830:
3831: /*===========================================================================+

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

3876: l_org_ID NUMBER;
3877:
3878: BEGIN
3879:
3880: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_BILLREC_ROW (+)');
3881:
3882: -------------------------------------------------------
3883: -- Select the nextval for PERIOD_BILLREC_ID
3884: -------------------------------------------------------

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

3930: RAISE NO_DATA_FOUND;
3931: END IF;
3932: CLOSE C;
3933:
3934: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.INSERT_PERIOD_BILLREC_ROW (-)');
3935:
3936: END INSERT_PERIOD_BILLREC_ROW;
3937:
3938: /*===========================================================================+

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

3970: ) is
3971:
3972: BEGIN
3973:
3974: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (+)');
3975:
3976: update PN_REC_PERIOD_BILL_ALL set
3977: REC_AGR_LINE_ID = X_REC_AGR_LINE_ID
3978: ,REC_AGREEMENT_ID = X_REC_AGREEMENT_ID

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

3988: if (sql%notfound) then
3989: raise no_data_found;
3990: end if;
3991:
3992: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.UPDATE_PERIOD_BILLREC_ROW (-)');
3993:
3994: end UPDATE_PERIOD_BILLREC_ROW;
3995:
3996: /*===========================================================================+

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

4021: ) is
4022:
4023: BEGIN
4024:
4025: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (+)');
4026:
4027: delete from PN_REC_PERIOD_BILL_ALL
4028: where PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
4029:

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

4030: if (sql%notfound) then
4031: raise no_data_found;
4032: end if;
4033:
4034: PNP_DEBUG_PKG.log ('PN_REC_CALC_PKG.DELETE_PERIOD_BILLREC_ROW (-)');
4035:
4036: end DELETE_PERIOD_BILLREC_ROW;
4037:
4038: /*===========================================================================+

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

4177:
4178:
4179: BEGIN
4180:
4181: pnp_debug_pkg.log ('PN_REC_CALC_PKG.create_payment_terms : (+)');
4182:
4183: IF p_org_id IS NULL THEN
4184: FOR rec IN org_cur LOOP
4185: l_org_id := rec.org_id;

Line 4324: l_period_bill_record := PN_REC_CALC_PKG.find_if_rec_payterm_exists(

4320: END IF;
4321:
4322:
4323: l_context := 'Checking term exists ';
4324: l_period_bill_record := PN_REC_CALC_PKG.find_if_rec_payterm_exists(
4325: p_rec_agreement_id
4326: ,p_rec_agr_line_id
4327: ,p_rec_calc_period_id
4328: ,p_consolidate

Line 4351: PN_REC_CALC_PKG.update_period_billrec_row (

4347: l_payment_amount := p_payment_amount - l_payment_amount;
4348:
4349: l_context := 'Updating period_billrec ';
4350:
4351: PN_REC_CALC_PKG.update_period_billrec_row (
4352: X_PERIOD_BILLREC_ID => l_period_billrec_id
4353: ,X_REC_AGREEMENT_ID => p_rec_agreement_id
4354: ,X_REC_AGR_LINE_ID => p_rec_agr_line_id
4355: ,X_REC_CALC_PERIOD_ID => p_rec_calc_period_id

Line 4371: PN_REC_CALC_PKG.insert_period_billrec_row (

4367: pnp_debug_pkg.log ('insert_period_billrec_row - agr id :'||p_rec_agreement_id);
4368: pnp_debug_pkg.log ('insert_period_billrec_row - p_rec_agr_line_id :'||p_rec_agr_line_id);
4369: pnp_debug_pkg.log ('insert_period_billrec_row - p_rec_calc_period_id :'||p_rec_calc_period_id);
4370: pnp_debug_pkg.log ('insert_period_billrec_row - amount :'||l_payment_amount);
4371: PN_REC_CALC_PKG.insert_period_billrec_row (
4372: X_ROWID => l_rowId
4373: ,X_PERIOD_BILLREC_ID => l_period_billrec_id
4374: ,X_REC_AGREEMENT_ID => p_rec_agreement_id
4375: ,X_REC_AGR_LINE_ID => p_rec_agr_line_id

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

4626:
4627: END IF;
4628:
4629: END IF;
4630: pnp_debug_pkg.log('PN_REC_CALC_PKG.create_payment_terms (-) ');
4631:
4632: EXCEPTION
4633: when others then
4634: pnp_debug_pkg.log('Error while' || l_context || to_char(sqlcode));

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

4705: -- Fix for bug # 3142328
4706:
4707: BEGIN
4708:
4709: pnp_debug_pkg.log('PN_REC_CALC_PKG.find_if_rec_payterm_exists (+) ');
4710:
4711: l_period_bill_record.amount := 0;
4712: l_period_bill_record.period_billrec_id:= 0;
4713: l_distributions_exist := 'N';

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

4812:
4813: END IF;
4814:
4815: pnp_debug_pkg.log('find_if_rec_payterm_exists - terms deleted '|| to_char(SQL%ROWCOUNT));
4816: pnp_debug_pkg.log('PN_REC_CALC_PKG.find_if_rec_payterm_exists (-) ');
4817:
4818: RETURN l_period_bill_record;
4819:
4820: EXCEPTION

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

4873: AND lineconst.SCOPE = 'OPYA';
4874:
4875: BEGIN
4876:
4877: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_actual_amount (+) ');
4878:
4879: SELECT NVL(period_lines.constrained_actual,0)
4880: INTO l_prior_period_amount
4881: FROM pn_rec_period_lines_all period_lines

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

4936: ELSE
4937: return -99;
4938: END IF;
4939:
4940: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_actual_amount (-) ');
4941:
4942: END get_prior_period_actual_amount;
4943:
4944: /*===========================================================================+

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

5011: AND lineconst.SCOPE = 'OPYC';
5012:
5013: BEGIN
5014:
5015: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_cap (+) ');
5016:
5017: OPEN csr_get_base_cap;
5018: FETCH csr_get_base_cap into l_cap_amount,l_start_date,l_end_date;
5019:

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

5075: close csr_get_curr_percent;
5076:
5077: END IF;
5078:
5079: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_prior_period_cap (-) ');
5080:
5081: RETURN l_cap_amount;
5082:
5083: EXCEPTION

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

5237: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5238:
5239: begin
5240:
5241: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (+) ');
5242:
5243: FOR l_term_rec in c_term
5244: LOOP
5245:

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

5335: END IF;
5336:
5337: END LOOP;
5338: commit;
5339: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (-) ');
5340: Exception
5341: when others then
5342: pnp_debug_pkg.log(' error in PN_REC_CALC_PKG.lock_area_exp_cls_dtl :'||to_char(sqlcode)||' : '||sqlerrm);
5343: raise;

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

5338: commit;
5339: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (-) ');
5340: Exception
5341: when others then
5342: pnp_debug_pkg.log(' error in PN_REC_CALC_PKG.lock_area_exp_cls_dtl :'||to_char(sqlcode)||' : '||sqlerrm);
5343: raise;
5344:
5345: END lock_area_exp_cls_dtl ;
5346:

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

5381: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
5382: l_period_count NUMBER;
5383: l_org_id NUMBER;
5384: BEGIN
5385: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');
5386:
5387: SELECT count(1)
5388: INTO l_period_count
5389: FROM pn_rec_calc_periods_all

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

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

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

5435: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calculation_period (-) ');
5436:
5437: EXCEPTION
5438: WHEN OTHERS THEN
5439: pnp_debug_pkg.log('error in PN_REC_CALC_PKG.validate_create_calc_period :'||to_char(sqlcode)||' : '||sqlerrm);
5440: raise;
5441: END validate_create_calc_period;
5442:
5443: END PN_REC_CALC_PKG;

Line 5443: END PN_REC_CALC_PKG;

5439: pnp_debug_pkg.log('error in PN_REC_CALC_PKG.validate_create_calc_period :'||to_char(sqlcode)||' : '||sqlerrm);
5440: raise;
5441: END validate_create_calc_period;
5442:
5443: END PN_REC_CALC_PKG;