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.44.12020000.2 2012/08/06 05:44:20 pcheruvu ship $
3: -- +===========================================================================+
4: -- | Copyright (c) 2001 Oracle Corporation
5: -- | Redwood Shores, California, USA

Line 9: -- | pn_index_amount_pkg

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 7747: END pn_index_amount_pkg;

7743:
7744: END calculate_subsequent_periods;
7745:
7746:
7747: END pn_index_amount_pkg;
7748: