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_VARIABLE_TERM_PKG dependencies on PN_VARIABLE_TERM_PKG

Line 1: PACKAGE BODY pn_variable_term_pkg AS

1: PACKAGE BODY pn_variable_term_pkg AS
2: -- $Header: PNVTERMB.pls 120.17.12010000.2 2008/09/04 12:27:45 mumohan ship $
3:
4: -------------------------------------------------------------------------------
5: -- PROCEDURE : create_payment_term_batch

Line 200: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_term_batch (+)' );

196: term_count NUMBER;
197: err_flag BOOLEAN := FALSE;
198:
199: BEGIN
200: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_term_batch (+)' );
201:
202: fnd_message.set_name ('PN','PN_VTERM_INP');
203: fnd_message.set_token ('TO_NUM',p_lease_num_to);
204: fnd_message.set_token ('FROM_NUM',p_lease_num_from);

Line 325: IF pn_variable_term_pkg.find_volume_continuous_for(rec_for_inv.var_rent_id,

321:
322: ELSE
323:
324: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
325: IF pn_variable_term_pkg.find_volume_continuous_for(rec_for_inv.var_rent_id,
326: rec_for_inv.period_id,
327: rec_for_inv.invoice_date,
328: 'FORECASTED'
329: ) = 'N' THEN

Line 420: IF pn_variable_term_pkg.find_volume_continuous_for(rec_var_inv.var_rent_id,

416:
417: ELSE
418:
419: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
420: IF pn_variable_term_pkg.find_volume_continuous_for(rec_var_inv.var_rent_id,
421: rec_var_inv.period_id,
422: rec_var_inv.invoice_date,
423: 'ACTUAL'
424: ) = 'N' THEN

Line 528: IF pn_variable_term_pkg.find_volume_continuous(rec_act_inv.var_rent_id,

524:
525: ELSE
526:
527: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
528: IF pn_variable_term_pkg.find_volume_continuous(rec_act_inv.var_rent_id,
529: rec_act_inv.period_id,
530: rec_act_inv.invoice_date
531: ) = 'N' THEN
532: fnd_message.set_name('PN','PN_VOL_INV_PRD');

Line 602: pn_variable_term_pkg.create_reversal_terms(p_payment_term_id => payment_rec.payment_term_id

598: END IF;
599: ELSE
600:
601: FOR payment_rec IN payment_cur(rec_act_inv.invoice_date,rec_act_inv.var_rent_id) LOOP
602: pn_variable_term_pkg.create_reversal_terms(p_payment_term_id => payment_rec.payment_term_id
603: ,p_var_rent_inv_id => rec_act_inv.var_rent_inv_id
604: ,p_var_rent_type => 'ADJUSTMENT');
605: UPDATE pn_var_rent_inv_all
606: SET actual_term_status='Y',

Line 623: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_term_batch (-) : ');

619: END IF; -- If l_invoice_on is ACTUAL
620: END IF; -- If l_err_flag = 'N'
621: END LOOP;
622:
623: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_term_batch (-) : ');
624:
625: EXCEPTION
626:
627: When OTHERS Then

Line 733: pn_variable_amount_pkg.put_log ('pn_variable_term_pkg.create_payment_terms : (+)');

729:
730:
731: BEGIN
732:
733: pn_variable_amount_pkg.put_log ('pn_variable_term_pkg.create_payment_terms : (+)');
734:
735: l_context := 'Getting lease class code and lease change id';
736:
737: BEGIN

Line 1068: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_terms (-) ');

1064:
1065: END IF;
1066: END IF;
1067:
1068: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_terms (-) ');
1069:
1070: EXCEPTION
1071:
1072: when others then

Line 1073: pn_variable_amount_pkg.put_log(substrb('pn_variable_term_pkg.Error in create_payment_terms - ' ||

1069:
1070: EXCEPTION
1071:
1072: when others then
1073: pn_variable_amount_pkg.put_log(substrb('pn_variable_term_pkg.Error in create_payment_terms - ' ||
1074: to_char(sqlcode)||' : '||sqlerrm || ' - '|| l_context,1,244));
1075: rollback to create_terms;
1076:
1077: -- Check if term exists and set actual_term_status accordingly.

Line 1265: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (+) : ');

1261: l_prev_inv_dt DATE;
1262: k NUMBER:= NULL;
1263:
1264: BEGIN
1265: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (+) : ');
1266:
1267: l_invoice_date := p_invoice_date;
1268:
1269: FOR inv_prd_rec IN inv_prd_cur(p_period_id, p_invoice_date) LOOP

Line 1491: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (-) : ');

1487: END IF;
1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (-) : ');
1492: RAISE;
1493:
1494: END find_volume_continuous;
1495:

Line 1719: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (+) : ');

1715: inv_st_dt DATE := NULL;
1716: inv_end_dt DATE := NULL;
1717:
1718: BEGIN
1719: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (+) : ');
1720:
1721: l_invoice_date := p_invoice_date;
1722:
1723: FOR inv_prd_rec IN inv_prd_cur(p_period_id, p_invoice_date) LOOP

Line 1793: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (-) : ');

1789: RETURN 'Y';
1790:
1791: EXCEPTION
1792: WHEN others THEN
1793: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (-) : ');
1794: RAISE;
1795: END find_volume_continuous_for;
1796:
1797:

Line 1834: pn_variable_amount_pkg.put_log ('pn_variable_term_pkg.create_reversal_terms : (+)');

1830: term_count NUMBER := 0;
1831:
1832: BEGIN
1833:
1834: pn_variable_amount_pkg.put_log ('pn_variable_term_pkg.create_reversal_terms : (+)');
1835:
1836: FOR payment_term_rec IN payment_term_cur LOOP
1837:
1838: pnt_payment_terms_pkg.insert_row (

Line 2020: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_reversal_terms (-) ');

2016: END IF;
2017:
2018: END IF;
2019:
2020: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_reversal_terms (-) ');
2021:
2022: EXCEPTION
2023:
2024: when others then

Line 2025: pn_variable_amount_pkg.put_log(substrb('pn_variable_term_pkg.Error in create_reversal_terms - ' ||

2021:
2022: EXCEPTION
2023:
2024: when others then
2025: pn_variable_amount_pkg.put_log(substrb('pn_variable_term_pkg.Error in create_reversal_terms - ' ||
2026: to_char(sqlcode)||' : '||sqlerrm || ' - '|| l_context,1,244));
2027: rollback to create_terms;
2028:
2029: -- Check if term exists and set actual_term_status accordingly.

Line 2052: END pn_variable_term_pkg;

2048: END IF;
2049:
2050: END create_reversal_terms;
2051:
2052: END pn_variable_term_pkg;
2053: