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_AMOUNT_PKG

Line 123: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'FORECASTED') ='N'

119: AND adjust_num = 0
120: AND nvl(for_per_rent,0) <> 0
121: AND forecasted_exp_code = 'N'
122: AND forecasted_term_status = decode(p_period_id,null,'N','Y')
123: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'FORECASTED') ='N'
124: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
125: ORDER BY invoice_date;
126:
127: /* Get the actual rent amounts */

Line 143: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'ACTUAL') ='N'

139: WHERE period_id = ip_period_id
140: AND actual_exp_code = 'N'
141: AND nvl(actual_invoiced_amount,0) <> 0
142: AND actual_term_status = decode(p_period_id,null,'N','Y')
143: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'ACTUAL') ='N'
144: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
145: ORDER BY invoice_date;
146:
147: /* get the actual-forecasted rent amounts */

Line 170: AND pn_variable_amount_pkg.find_if_term_exists(inv.var_rent_inv_id,'VARIANCE') = 'N'

166: WHERE gd.invoice_date = inv.invoice_date
167: AND gd.period_id = inv.period_id
168: AND gd.var_rent_id = inv.var_rent_id
169: AND nvl(gd.forecasted_exp_code,'N') = 'N')
170: AND pn_variable_amount_pkg.find_if_term_exists(inv.var_rent_inv_id,'VARIANCE') = 'N'
171: AND invoice_date <= nvl(fnd_date.canonical_to_date(p_period_date),to_date('12/31/4712','mm/dd/yyyy'))
172: ORDER BY inv.invoice_date;
173:
174: CURSOR payment_cur(p_invoice_date DATE,p_var_rent_id NUMBER) IS

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 263: pn_variable_amount_pkg.put_output(l_errmsg);

259:
260: l_err_flag := 'Y';
261: fnd_message.set_name ('PN', 'PN_MISS_TERM_TEMP_DATA');
262: l_errmsg := fnd_message.get;
263: pn_variable_amount_pkg.put_output(l_errmsg);
264:
265: fnd_message.set_name ('PN','PN_SOI_VRN');
266: fnd_message.set_token ('NUM',l_rent_num);
267: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 274: pn_variable_amount_pkg.put_output ('+---------------------------------------------------------------+');

270: END IF;
271:
272: IF l_err_flag = 'N' THEN
273:
274: pn_variable_amount_pkg.put_output ('+---------------------------------------------------------------+');
275: fnd_message.set_name ('PN','PN_RICAL_PROC');
276: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
277:
278: fnd_message.set_name ('PN','PN_SOI_VRN');

Line 314: IF pn_variable_amount_pkg.find_volume_exists(rec_for_inv.period_id,

310:
311:
312: l_context := 'Checking if volume exists for all group dates and line items';
313:
314: IF pn_variable_amount_pkg.find_volume_exists(rec_for_inv.period_id,
315: rec_for_inv.invoice_date,
316: 'FORECASTED')='N' THEN
317:
318: fnd_message.set_name('PN','PN_VAR_VOL_HIST');

Line 320: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');

316: 'FORECASTED')='N' THEN
317:
318: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
319: l_errmsg := fnd_message.get;
320: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
321: pn_variable_amount_pkg.put_output(l_errmsg);
322: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
323: errbuf := l_errmsg;
324:

Line 321: pn_variable_amount_pkg.put_output(l_errmsg);

317:
318: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
319: l_errmsg := fnd_message.get;
320: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
321: pn_variable_amount_pkg.put_output(l_errmsg);
322: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
323: errbuf := l_errmsg;
324:
325:

Line 322: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');

318: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
319: l_errmsg := fnd_message.get;
320: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
321: pn_variable_amount_pkg.put_output(l_errmsg);
322: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
323: errbuf := l_errmsg;
324:
325:
326: ELSE

Line 336: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');

332: 'FORECASTED'
333: ) = 'N' THEN
334: fnd_message.set_name('PN','PN_VOL_INV_PRD');
335: l_errmsg := fnd_message.get;
336: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
337: pn_variable_amount_pkg.put_output(l_errmsg);
338: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
339: errbuf := l_errmsg;
340:

Line 337: pn_variable_amount_pkg.put_output(l_errmsg);

333: ) = 'N' THEN
334: fnd_message.set_name('PN','PN_VOL_INV_PRD');
335: l_errmsg := fnd_message.get;
336: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
337: pn_variable_amount_pkg.put_output(l_errmsg);
338: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
339: errbuf := l_errmsg;
340:
341: err_flag := TRUE;

Line 338: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');

334: fnd_message.set_name('PN','PN_VOL_INV_PRD');
335: l_errmsg := fnd_message.get;
336: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
337: pn_variable_amount_pkg.put_output(l_errmsg);
338: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
339: errbuf := l_errmsg;
340:
341: err_flag := TRUE;
342:

Line 377: pn_variable_amount_pkg.put_log('term not found ...');

373: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
374: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
375: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id;
376: ELSE
377: pn_variable_amount_pkg.put_log('term not found ...');
378: UPDATE pn_var_rent_inv_all
379: SET forecasted_term_status='N',
380: last_update_date = SYSDATE,
381: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

Line 410: IF pn_variable_amount_pkg.find_volume_exists(rec_var_inv.period_id,

406: pnp_debug_pkg.put_log_msg(fnd_message.get);
407:
408: l_context := 'Checking if volume exists for all group dates and line items';
409:
410: IF pn_variable_amount_pkg.find_volume_exists(rec_var_inv.period_id,
411: rec_var_inv.invoice_date,
412: 'ACTUAL')='N' THEN
413:
414: fnd_message.set_name('PN','PN_VAR_VOL_HIST');

Line 416: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');

412: 'ACTUAL')='N' THEN
413:
414: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
415: l_errmsg := fnd_message.get;
416: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
417: pn_variable_amount_pkg.put_output(l_errmsg);
418: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
419: errbuf := l_errmsg;
420:

Line 417: pn_variable_amount_pkg.put_output(l_errmsg);

413:
414: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
415: l_errmsg := fnd_message.get;
416: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
417: pn_variable_amount_pkg.put_output(l_errmsg);
418: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
419: errbuf := l_errmsg;
420:
421: ELSE

Line 418: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');

414: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
415: l_errmsg := fnd_message.get;
416: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
417: pn_variable_amount_pkg.put_output(l_errmsg);
418: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
419: errbuf := l_errmsg;
420:
421: ELSE
422:

Line 431: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');

427: 'ACTUAL'
428: ) = 'N' THEN
429: fnd_message.set_name('PN','PN_VOL_INV_PRD');
430: l_errmsg := fnd_message.get;
431: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
432: pn_variable_amount_pkg.put_output(l_errmsg);
433: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
434: errbuf := l_errmsg;
435:

Line 432: pn_variable_amount_pkg.put_output(l_errmsg);

428: ) = 'N' THEN
429: fnd_message.set_name('PN','PN_VOL_INV_PRD');
430: l_errmsg := fnd_message.get;
431: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
432: pn_variable_amount_pkg.put_output(l_errmsg);
433: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
434: errbuf := l_errmsg;
435:
436: err_flag := TRUE;

Line 433: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');

429: fnd_message.set_name('PN','PN_VOL_INV_PRD');
430: l_errmsg := fnd_message.get;
431: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
432: pn_variable_amount_pkg.put_output(l_errmsg);
433: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
434: errbuf := l_errmsg;
435:
436: err_flag := TRUE;
437:

Line 443: pn_variable_amount_pkg.put_output('Actual-Forecasted Amount :'||round(rec_var_inv.act_for_amt,2));

439: END IF;
440:
441: IF (NOT err_flag) THEN
442:
443: pn_variable_amount_pkg.put_output('Actual-Forecasted Amount :'||round(rec_var_inv.act_for_amt,2));
444: l_context :='Creating Variance Payment term';
445:
446: savepoint create_terms;
447:

Line 481: pn_variable_amount_pkg.put_log('term not found ...');

477: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
478: AND true_up_status IS NOT NULL;
479:
480: ELSE
481: pn_variable_amount_pkg.put_log('term not found ...');
482: UPDATE pn_var_rent_inv_all
483: SET variance_term_status='N',
484: last_update_date = SYSDATE,
485: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

Line 519: IF pn_variable_amount_pkg.find_volume_exists(rec_act_inv.period_id,

515: pnp_debug_pkg.put_log_msg(fnd_message.get);
516:
517: l_context := 'Checking if volume exists for all group dates and line items';
518:
519: IF pn_variable_amount_pkg.find_volume_exists(rec_act_inv.period_id,
520: rec_act_inv.invoice_date,
521: 'ACTUAL')='N' THEN
522: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
523: l_errmsg := fnd_message.get;

Line 524: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');

520: rec_act_inv.invoice_date,
521: 'ACTUAL')='N' THEN
522: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
523: l_errmsg := fnd_message.get;
524: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
525: pn_variable_amount_pkg.put_output(l_errmsg);
526: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
527:
528:

Line 525: pn_variable_amount_pkg.put_output(l_errmsg);

521: 'ACTUAL')='N' THEN
522: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
523: l_errmsg := fnd_message.get;
524: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
525: pn_variable_amount_pkg.put_output(l_errmsg);
526: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
527:
528:
529: ELSE

Line 526: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');

522: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
523: l_errmsg := fnd_message.get;
524: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
525: pn_variable_amount_pkg.put_output(l_errmsg);
526: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
527:
528:
529: ELSE
530:

Line 538: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');

534: rec_act_inv.invoice_date
535: ) = 'N' THEN
536: fnd_message.set_name('PN','PN_VOL_INV_PRD');
537: l_errmsg := fnd_message.get;
538: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
539: pn_variable_amount_pkg.put_output(l_errmsg);
540: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
541: errbuf := l_errmsg;
542:

Line 539: pn_variable_amount_pkg.put_output(l_errmsg);

535: ) = 'N' THEN
536: fnd_message.set_name('PN','PN_VOL_INV_PRD');
537: l_errmsg := fnd_message.get;
538: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
539: pn_variable_amount_pkg.put_output(l_errmsg);
540: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
541: errbuf := l_errmsg;
542:
543: err_flag := TRUE;

Line 540: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');

536: fnd_message.set_name('PN','PN_VOL_INV_PRD');
537: l_errmsg := fnd_message.get;
538: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
539: pn_variable_amount_pkg.put_output(l_errmsg);
540: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
541: errbuf := l_errmsg;
542:
543: err_flag := TRUE;
544:

Line 550: pn_variable_amount_pkg.put_output('Actual Amount :'|| round(rec_act_inv.actual_invoiced_amount,2));

546: END IF;
547:
548: IF (NOT err_flag) THEN
549:
550: pn_variable_amount_pkg.put_output('Actual Amount :'|| round(rec_act_inv.actual_invoiced_amount,2));
551: l_context :='Creating Actual Payment term';
552:
553: savepoint create_terms;
554:

Line 590: pn_variable_amount_pkg.put_log('term not found ...');

586: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
587: AND true_up_status IS NOT NULL;
588:
589: ELSE
590: pn_variable_amount_pkg.put_log('term not found ...');
591: UPDATE pn_var_rent_inv_all
592: SET actual_term_status='N',
593: last_update_date = SYSDATE,
594: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

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 632: pn_variable_amount_pkg.put_log(substrb('Error in create_payment_term_batch - ' || to_char(sqlcode)

628:
629: EXCEPTION
630:
631: When OTHERS Then
632: pn_variable_amount_pkg.put_log(substrb('Error in create_payment_term_batch - ' || to_char(sqlcode)
633: ||' : ' ||sqlerrm|| ' - '|| l_context,1,244));
634: Errbuf := SQLERRM;
635: Retcode := 2;
636: rollback;

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 755: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - TOO_MANY_ROWS');

751: AND pld.lease_id = p_lease_id;
752:
753: EXCEPTION
754: WHEN TOO_MANY_ROWS THEN
755: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - TOO_MANY_ROWS');
756: WHEN NO_DATA_FOUND THEN
757: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - NO_DATA_FOUND');
758: WHEN OTHERS THEN
759: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);

Line 757: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - NO_DATA_FOUND');

753: EXCEPTION
754: WHEN TOO_MANY_ROWS THEN
755: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - TOO_MANY_ROWS');
756: WHEN NO_DATA_FOUND THEN
757: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - NO_DATA_FOUND');
758: WHEN OTHERS THEN
759: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);
760: END;
761:

Line 759: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);

755: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - TOO_MANY_ROWS');
756: WHEN NO_DATA_FOUND THEN
757: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - NO_DATA_FOUND');
758: WHEN OTHERS THEN
759: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);
760: END;
761:
762:
763: --pn_variable_amount_pkg.put_log ('create_payment_terms - multi_org_flag :'||

Line 763: --pn_variable_amount_pkg.put_log ('create_payment_terms - multi_org_flag :'||

759: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);
760: END;
761:
762:
763: --pn_variable_amount_pkg.put_log ('create_payment_terms - multi_org_flag :'||
764: --mo_utils.get_multi_org_flag);
765: pn_variable_amount_pkg.put_log ('create_payment_terms - Org id :'||p_org_id);
766:
767:

Line 765: pn_variable_amount_pkg.put_log ('create_payment_terms - Org id :'||p_org_id);

761:
762:
763: --pn_variable_amount_pkg.put_log ('create_payment_terms - multi_org_flag :'||
764: --mo_utils.get_multi_org_flag);
765: pn_variable_amount_pkg.put_log ('create_payment_terms - Org id :'||p_org_id);
766:
767:
768: l_context := 'Getting set of books id';
769:

Line 782: pn_variable_amount_pkg.put_log ('create_payment_terms - Currency Code :'||g_currency_code);

778: l_set_of_books_id := to_number(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID'
779: ,l_org_id));
780:
781:
782: pn_variable_amount_pkg.put_log ('create_payment_terms - Currency Code :'||g_currency_code);
783: pn_variable_amount_pkg.put_log ('create_payment_terms - Set of books id :'||l_set_of_books_id);
784:
785:
786: l_context := 'opening cursor csr_template';

Line 783: pn_variable_amount_pkg.put_log ('create_payment_terms - Set of books id :'||l_set_of_books_id);

779: ,l_org_id));
780:
781:
782: pn_variable_amount_pkg.put_log ('create_payment_terms - Currency Code :'||g_currency_code);
783: pn_variable_amount_pkg.put_log ('create_payment_terms - Set of books id :'||l_set_of_books_id);
784:
785:
786: l_context := 'opening cursor csr_template';
787:

Line 853: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- TOO_MANY_ROWS');

849: -- END LOOP;
850:
851: EXCEPTION
852: WHEN TOO_MANY_ROWS THEN
853: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- TOO_MANY_ROWS');
854: WHEN NO_DATA_FOUND THEN
855: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- NO_DATA_FOUND');
856: WHEN OTHERS THEN
857: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- Unknown Error:'|| SQLERRM);

Line 855: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- NO_DATA_FOUND');

851: EXCEPTION
852: WHEN TOO_MANY_ROWS THEN
853: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- TOO_MANY_ROWS');
854: WHEN NO_DATA_FOUND THEN
855: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- NO_DATA_FOUND');
856: WHEN OTHERS THEN
857: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- Unknown Error:'|| SQLERRM);
858: END;
859:

Line 857: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- Unknown Error:'|| SQLERRM);

853: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- TOO_MANY_ROWS');
854: WHEN NO_DATA_FOUND THEN
855: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- NO_DATA_FOUND');
856: WHEN OTHERS THEN
857: pn_variable_amount_pkg.put_log('Cannot Get Payment term start date- Unknown Error:'|| SQLERRM);
858: END;
859:
860:
861:

Line 993: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);

989:
990: FOR rec_distributions in csr_distributions(p_var_rent_id)
991:
992: LOOP
993: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
994: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
995:
996:
997: l_context := 'Inserting into pn_distributions';

Line 994: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);

990: FOR rec_distributions in csr_distributions(p_var_rent_id)
991:
992: LOOP
993: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
994: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
995:
996:
997: l_context := 'Inserting into pn_distributions';
998: pn_distributions_pkg.insert_row (

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 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 1943: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);

1939: l_distribution_count := 0;
1940:
1941: FOR rec_distributions IN csr_distributions LOOP
1942:
1943: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
1944: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
1945:
1946:
1947: l_context := 'Inserting into pn_distributions';

Line 1944: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);

1940:
1941: FOR rec_distributions IN csr_distributions LOOP
1942:
1943: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
1944: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
1945:
1946:
1947: l_context := 'Inserting into pn_distributions';
1948: pn_distributions_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.