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_INDEX_AMOUNT_PKG dependencies on PN_INDEX_AMOUNT_PKG

Line 1: PACKAGE BODY pn_index_amount_pkg AS

1: PACKAGE BODY pn_index_amount_pkg AS
2: -- $Header: PNINAMTB.pls 120.39.12010000.2 2008/09/04 12:25:58 mumohan ship $
3: -- +===========================================================================+
4: -- | Copyright (c) 2001 Oracle Corporation
5: -- | Redwood Shores, California, USA

Line 9: -- | pn_index_amount_pkg

Line 1726: put_log ('pn_index_amount_pkg.derive_constrained_rent (+): ');

1722: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;
1723:
1724: BEGIN
1725:
1726: put_log ('pn_index_amount_pkg.derive_constrained_rent (+): ');
1727: put_log('derive_constrained_rent - p_index_lease_id :'||p_index_lease_id);
1728: put_log('derive_constrained_rent - p_current_basis :'||p_current_basis);
1729: put_log('derive_constrained_rent - p_index_period_id :'||p_index_period_id);
1730: put_log('derive_constrained_rent - p_negative_rent_type :'||p_negative_rent_type);

Line 1968: put_log ('pn_index_amount_pkg.derive_constrained_rent (-): ');

1964: put_log ('derive_constrained_rent - op_carry_forward_amount :'||op_carry_forward_amount);
1965: put_log ('derive_constrained_rent - op_constraint_applied_percent :'||op_constraint_applied_percent);
1966: put_log ('derive_constrained_rent - op_carry_forward_percent :'||op_carry_forward_percent);
1967: put_log ('derive_constrained_rent - op_constrained_rent_amount :'||op_constrained_rent_amount);
1968: put_log ('pn_index_amount_pkg.derive_constrained_rent (-): ');
1969:
1970: END derive_constrained_rent;
1971:
1972:

Line 4174: PUT_LOG('Error in pn_index_amount_pkg.create_aggr_payment_terms :'||to_char(sqlcode)||' : '||sqlerrm);

4170: END LOOP;
4171:
4172: EXCEPTION
4173: WHEN OTHERS THEN
4174: PUT_LOG('Error in pn_index_amount_pkg.create_aggr_payment_terms :'||to_char(sqlcode)||' : '||sqlerrm);
4175: RAISE;
4176:
4177: END create_aggr_payment_terms;
4178:

Line 4210: put_log('pn_index_amount_pkg.get_backbill_overlap_amt: (+) ');

4206: l_answer NUMBER;
4207:
4208: BEGIN
4209:
4210: put_log('pn_index_amount_pkg.get_backbill_overlap_amt: (+) ');
4211:
4212: l_answer := 0;
4213:
4214: FOR ans_rec IN get_overlap_sum LOOP

Line 4220: put_log('pn_index_amount_pkg.get_backbill_overlap_amt: (-) : '||l_answer);

4216: END LOOP;
4217:
4218: p_overlap_amt := l_answer;
4219:
4220: put_log('pn_index_amount_pkg.get_backbill_overlap_amt: (-) : '||l_answer);
4221:
4222: END get_backbill_overlap_amt;
4223:
4224: ------------------------------------------------------------------------

Line 4328: put_log('pn_index_amount_pkg.create_payment_terms : (+) ');

4324: l_backbill_normalize VARCHAR2(1);
4325: l_found_atlst_bb NUMBER := 0;
4326:
4327: BEGIN
4328: put_log('pn_index_amount_pkg.create_payment_terms : (+) ');
4329:
4330: v_index_amount := p_index_amount;
4331:
4332:

Line 5185: put_log ('pn_index_amount_pkg.create_payment_term_record (+) :');

5181: FROM pn_index_lease_periods_all
5182: WHERE index_period_id = p_index_period_id);
5183:
5184: BEGIN
5185: put_log ('pn_index_amount_pkg.create_payment_term_record (+) :');
5186:
5187: IF NVL (p_payment_amount, 0) <> 0 THEN
5188:
5189: /* derive payment defaults for this index lease */

Line 5806: put_log ('pn_index_amount_pkg.create_payment_term_record (-) :');

5802: END IF; --v_actual_amount <> 0
5803:
5804: END IF; --p_amount <> 0 then
5805:
5806: put_log ('pn_index_amount_pkg.create_payment_term_record (-) :');
5807:
5808: END create_payment_term_record;
5809:
5810: -------------------------------------------------------------------------------

Line 5830: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (+) Asmt Dt: '||p_assessment_date

5826: l_cut_off_date DATE := NULL;
5827: l_calculate_date DATE;
5828: BEGIN
5829:
5830: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (+) Asmt Dt: '||p_assessment_date
5831: ||', PrdStrDt: '||p_period_str_date||', CutOffDt: '||l_prof_cut_off);
5832:
5833: IF l_prof_cut_off IS NOT NULL THEN
5834: l_cut_off_date := TO_DATE(l_prof_cut_off, 'MM/DD/YYYY');

Line 5845: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (-) Calc Dt: '||l_calculate_date);

5841: ELSE
5842: l_calculate_date := TRUNC(SYSDATE);
5843: END IF;
5844:
5845: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (-) Calc Dt: '||l_calculate_date);
5846:
5847: RETURN l_calculate_date;
5848: END Get_Calculate_Date;
5849:

Line 5869: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (+) Asmt Dt: '||p_assessment_date

5865: l_cut_off_date DATE := NULL;
5866: l_calculate_date DATE;
5867: BEGIN
5868:
5869: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (+) Asmt Dt: '||p_assessment_date
5870: ||', PrdStrDt: '||p_period_str_date||', CutOffDt: '||l_prof_cut_off);
5871:
5872: IF l_prof_cut_off IS NOT NULL THEN
5873: l_cut_off_date := TO_DATE(l_prof_cut_off, 'MM/DD/YYYY');

Line 5884: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (-) Calc Dt: '||l_calculate_date);

5880: ELSE
5881: l_calculate_date := TRUNC(SYSDATE);
5882: END IF;
5883:
5884: put_log('PN_INDEX_AMOUNT_PKG.Get_Calculate_Date (-) Calc Dt: '||l_calculate_date);
5885:
5886: RETURN l_calculate_date;
5887: END Get_Calculate_Date;
5888:

Line 6042: put_log('PN_INDEX_AMOUNT_PKG.calculate_period (+) LeaseId: '||ip_index_lease_id

6038: l_terms_exist BOOLEAN := FALSE;
6039:
6040: BEGIN
6041:
6042: put_log('PN_INDEX_AMOUNT_PKG.calculate_period (+) LeaseId: '||ip_index_lease_id
6043: ||', PrdId: '||ip_index_lease_period_id||', ReCalc: '||ip_recalculate);
6044: v_all_msg := 'PN_INDEX_SUCCESS';
6045: l_pre_index_rent_id := NULL;
6046:

Line 6514: put_log('PN_INDEX_AMOUNT_PKG.calculate_period (-) PrvAmt: '||op_previous_index_amount

6510: op_msg := SUBSTR (v_all_msg, 1, INSTR ( v_all_msg
6511: || ',', ',')
6512: - 1);
6513:
6514: put_log('PN_INDEX_AMOUNT_PKG.calculate_period (-) PrvAmt: '||op_previous_index_amount
6515: ||', ConsAmt: '||op_constraint_applied_amount||', CFAmt: '||op_carry_forward_amount);
6516:
6517: END calculate_period;
6518:

Line 7318: put_log('pn_index_amount_pkg.approve_index_pay_term_batch (+) : ');

7314: where VAR_RENT_ID = l_var_rent_id)
7315: AND BKHD_DEFAULT_ID IS NOT NULL);
7316:
7317: BEGIN
7318: put_log('pn_index_amount_pkg.approve_index_pay_term_batch (+) : ');
7319:
7320: put_log ('ip_index_lease_number_lower '|| ip_index_lease_number_lower);
7321: put_log ('ip_index_lease_number_upper '|| ip_index_lease_number_upper);
7322: put_log ('ip_assessment_date_lower ' || ip_assessment_date_lower);

Line 7494: put_log('pn_index_amount_pkg.approve_index_pay_term_batch (-) : ');

7490: END IF;
7491:
7492:
7493:
7494: put_log('pn_index_amount_pkg.approve_index_pay_term_batch (-) : ');
7495:
7496: END approve_index_pay_term_batch;
7497:
7498:

Line 7533: put_log('Error in pn_index_amount_pkg.process_currency_code :'||to_char(sqlcode)||' : '||sqlerrm);

7529:
7530:
7531: EXCEPTION
7532: when others then
7533: put_log('Error in pn_index_amount_pkg.process_currency_code :'||to_char(sqlcode)||' : '||sqlerrm);
7534: raise;
7535:
7536: END process_currency_code;
7537:

Line 7562: put_log ('pn_index_amount_pkg.derive_cum_carry_forward (+) : ');

7558: AND pilp.assessment_date < p_assessment_date);
7559:
7560: BEGIN
7561:
7562: put_log ('pn_index_amount_pkg.derive_cum_carry_forward (+) : ');
7563:
7564: OPEN csr_cum_carry_for;
7565: FETCH csr_cum_carry_for into op_carry_forward_amount,op_carry_forward_percent;
7566: CLOSE csr_cum_carry_for;

Line 7568: put_log ('pn_index_amount_pkg.derive_cum_carry_forward (-) :');

7564: OPEN csr_cum_carry_for;
7565: FETCH csr_cum_carry_for into op_carry_forward_amount,op_carry_forward_percent;
7566: CLOSE csr_cum_carry_for;
7567:
7568: put_log ('pn_index_amount_pkg.derive_cum_carry_forward (-) :');
7569:
7570: EXCEPTION
7571: WHEN OTHERS then
7572: put_log ('derive_cum_carry_forward : Unable to derive previous periods carry forward amount :'

Line 7605: put_log ('pn_index_amount_pkg.derive_prev_negative_rent (+) : ');

7601: l_previous_negative_rent number := 0;
7602:
7603: BEGIN
7604:
7605: put_log ('pn_index_amount_pkg.derive_prev_negative_rent (+) : ');
7606:
7607: /*
7608:
7609: Note : The previous sum of negative rents can be found out as

Line 7627: put_log ('pn_index_amount_pkg.derive_prev_negative_rent (-) :');

7623: l_previous_negative_rent := nvl(rec_negative_rent.unconstraint_rent_due,0) + l_previous_negative_rent;
7624:
7625: end loop;
7626:
7627: put_log ('pn_index_amount_pkg.derive_prev_negative_rent (-) :');
7628:
7629: RETURN l_previous_negative_rent;
7630:
7631: END derive_prev_negative_rent;

Line 7723: put_log('pn_index_amount_pkg.calculate_subsequent_periods (+) : ');

7719: v_msg VARCHAR2(1000);
7720:
7721: BEGIN
7722:
7723: put_log('pn_index_amount_pkg.calculate_subsequent_periods (+) : ');
7724:
7725: FOR rec_get_periods in csr_get_periods
7726: LOOP
7727:

Line 7740: put_log('pn_index_amount_pkg.calculate_subsequent_periods (-) : ');

7736: put_log('v_msg : '||v_msg);
7737:
7738: END LOOP;
7739:
7740: put_log('pn_index_amount_pkg.calculate_subsequent_periods (-) : ');
7741:
7742: END calculate_subsequent_periods;
7743:
7744:

Line 7745: END pn_index_amount_pkg;

7741:
7742: END calculate_subsequent_periods;
7743:
7744:
7745: END pn_index_amount_pkg;
7746: