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.3 2009/12/24 07:09:51 jsundara ship $
3:
4: -------------------------------------------------------------------------------
5: -- PROCEDURE : create_payment_term_batch

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

200: err_flag BOOLEAN := FALSE;
201: l_trmn_dt DATE; /* 9094493 */
202:
203: BEGIN
204: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_term_batch (+)' );
205:
206: fnd_message.set_name ('PN','PN_VTERM_INP');
207: fnd_message.set_token ('TO_NUM',p_lease_num_to);
208: fnd_message.set_token ('FROM_NUM',p_lease_num_from);

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

325:
326: ELSE
327:
328: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
329: IF pn_variable_term_pkg.find_volume_continuous_for(rec_for_inv.var_rent_id,
330: rec_for_inv.period_id,
331: rec_for_inv.invoice_date,
332: 'FORECASTED'
333: ) = 'N' THEN

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

420:
421: ELSE
422:
423: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
424: IF pn_variable_term_pkg.find_volume_continuous_for(rec_var_inv.var_rent_id,
425: rec_var_inv.period_id,
426: rec_var_inv.invoice_date,
427: 'ACTUAL'
428: ) = 'N' THEN

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

528:
529: ELSE
530:
531: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' and (l_trmn_dt >= rec_act_inv.invoice_date) THEN /* 9094493 */
532: IF pn_variable_term_pkg.find_volume_continuous(rec_act_inv.var_rent_id,
533: rec_act_inv.period_id,
534: rec_act_inv.invoice_date
535: ) = 'N' THEN
536: fnd_message.set_name('PN','PN_VOL_INV_PRD');

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

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

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

623: END IF; -- If l_invoice_on is ACTUAL
624: END IF; -- If l_err_flag = 'N'
625: END LOOP;
626:
627: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_term_batch (-) : ');
628:
629: EXCEPTION
630:
631: When OTHERS Then

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

733:
734:
735: BEGIN
736:
737: pn_variable_amount_pkg.put_log ('pn_variable_term_pkg.create_payment_terms : (+)');
738:
739: l_context := 'Getting lease class code and lease change id';
740:
741: BEGIN

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

1068:
1069: END IF;
1070: END IF;
1071:
1072: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_payment_terms (-) ');
1073:
1074: EXCEPTION
1075:
1076: when others then

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

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

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

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

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

1491: END IF;
1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous (-) : ');
1496: RAISE;
1497:
1498: END find_volume_continuous;
1499:

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

1719: inv_st_dt DATE := NULL;
1720: inv_end_dt DATE := NULL;
1721:
1722: BEGIN
1723: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (+) : ');
1724:
1725: l_invoice_date := p_invoice_date;
1726:
1727: FOR inv_prd_rec IN inv_prd_cur(p_period_id, p_invoice_date) LOOP

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

1793: RETURN 'Y';
1794:
1795: EXCEPTION
1796: WHEN others THEN
1797: pnp_debug_pkg.log('pn_variable_term_pkg.find_volume_continuous_for (-) : ');
1798: RAISE;
1799: END find_volume_continuous_for;
1800:
1801:

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

1834: term_count NUMBER := 0;
1835:
1836: BEGIN
1837:
1838: pn_variable_amount_pkg.put_log ('pn_variable_term_pkg.create_reversal_terms : (+)');
1839:
1840: FOR payment_term_rec IN payment_term_cur LOOP
1841:
1842: pnt_payment_terms_pkg.insert_row (

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

2020: END IF;
2021:
2022: END IF;
2023:
2024: pn_variable_amount_pkg.put_log('pn_variable_term_pkg.create_reversal_terms (-) ');
2025:
2026: EXCEPTION
2027:
2028: when others then

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

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

Line 2056: END pn_variable_term_pkg;

2052: END IF;
2053:
2054: END create_reversal_terms;
2055:
2056: END pn_variable_term_pkg;
2057: