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 120: AND pn_variable_amount_pkg.find_if_term_exists(var_rent_inv_id,'FORECASTED') ='N'

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

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

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

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

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

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

255:
256: l_err_flag := 'Y';
257: fnd_message.set_name ('PN', 'PN_MISS_TERM_TEMP_DATA');
258: l_errmsg := fnd_message.get;
259: pn_variable_amount_pkg.put_output(l_errmsg);
260:
261: fnd_message.set_name ('PN','PN_SOI_VRN');
262: fnd_message.set_token ('NUM',l_rent_num);
263: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

266: END IF;
267:
268: IF l_err_flag = 'N' THEN
269:
270: pn_variable_amount_pkg.put_output ('+---------------------------------------------------------------+');
271: fnd_message.set_name ('PN','PN_RICAL_PROC');
272: pnp_debug_pkg.put_log_msg(fnd_message.get||' ...');
273:
274: fnd_message.set_name ('PN','PN_SOI_VRN');

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

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

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

312: 'FORECASTED')='N' THEN
313:
314: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
315: l_errmsg := fnd_message.get;
316: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
317: pn_variable_amount_pkg.put_output(l_errmsg);
318: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
319: errbuf := l_errmsg;
320:

Line 317: pn_variable_amount_pkg.put_output(l_errmsg);

313:
314: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
315: l_errmsg := fnd_message.get;
316: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
317: pn_variable_amount_pkg.put_output(l_errmsg);
318: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
319: errbuf := l_errmsg;
320:
321:

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

314: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
315: l_errmsg := fnd_message.get;
316: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
317: pn_variable_amount_pkg.put_output(l_errmsg);
318: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
319: errbuf := l_errmsg;
320:
321:
322: ELSE

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

328: 'FORECASTED'
329: ) = 'N' THEN
330: fnd_message.set_name('PN','PN_VOL_INV_PRD');
331: l_errmsg := fnd_message.get;
332: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
333: pn_variable_amount_pkg.put_output(l_errmsg);
334: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
335: errbuf := l_errmsg;
336:

Line 333: pn_variable_amount_pkg.put_output(l_errmsg);

329: ) = 'N' THEN
330: fnd_message.set_name('PN','PN_VOL_INV_PRD');
331: l_errmsg := fnd_message.get;
332: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
333: pn_variable_amount_pkg.put_output(l_errmsg);
334: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
335: errbuf := l_errmsg;
336:
337: err_flag := TRUE;

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

330: fnd_message.set_name('PN','PN_VOL_INV_PRD');
331: l_errmsg := fnd_message.get;
332: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
333: pn_variable_amount_pkg.put_output(l_errmsg);
334: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
335: errbuf := l_errmsg;
336:
337: err_flag := TRUE;
338:

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

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

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

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

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

408: 'ACTUAL')='N' THEN
409:
410: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
411: l_errmsg := fnd_message.get;
412: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
413: pn_variable_amount_pkg.put_output(l_errmsg);
414: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
415: errbuf := l_errmsg;
416:

Line 413: pn_variable_amount_pkg.put_output(l_errmsg);

409:
410: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
411: l_errmsg := fnd_message.get;
412: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
413: pn_variable_amount_pkg.put_output(l_errmsg);
414: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
415: errbuf := l_errmsg;
416:
417: ELSE

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

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

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

423: 'ACTUAL'
424: ) = 'N' THEN
425: fnd_message.set_name('PN','PN_VOL_INV_PRD');
426: l_errmsg := fnd_message.get;
427: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
428: pn_variable_amount_pkg.put_output(l_errmsg);
429: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
430: errbuf := l_errmsg;
431:

Line 428: pn_variable_amount_pkg.put_output(l_errmsg);

424: ) = 'N' THEN
425: fnd_message.set_name('PN','PN_VOL_INV_PRD');
426: l_errmsg := fnd_message.get;
427: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
428: pn_variable_amount_pkg.put_output(l_errmsg);
429: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
430: errbuf := l_errmsg;
431:
432: err_flag := TRUE;

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

425: fnd_message.set_name('PN','PN_VOL_INV_PRD');
426: l_errmsg := fnd_message.get;
427: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
428: pn_variable_amount_pkg.put_output(l_errmsg);
429: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
430: errbuf := l_errmsg;
431:
432: err_flag := TRUE;
433:

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

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

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

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

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

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

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

516: rec_act_inv.invoice_date,
517: 'ACTUAL')='N' THEN
518: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
519: l_errmsg := fnd_message.get;
520: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
521: pn_variable_amount_pkg.put_output(l_errmsg);
522: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
523:
524:

Line 521: pn_variable_amount_pkg.put_output(l_errmsg);

517: 'ACTUAL')='N' THEN
518: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
519: l_errmsg := fnd_message.get;
520: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
521: pn_variable_amount_pkg.put_output(l_errmsg);
522: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
523:
524:
525: ELSE

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

518: fnd_message.set_name('PN','PN_VAR_VOL_HIST');
519: l_errmsg := fnd_message.get;
520: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
521: pn_variable_amount_pkg.put_output(l_errmsg);
522: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
523:
524:
525: ELSE
526:

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

530: rec_act_inv.invoice_date
531: ) = 'N' THEN
532: fnd_message.set_name('PN','PN_VOL_INV_PRD');
533: l_errmsg := fnd_message.get;
534: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
535: pn_variable_amount_pkg.put_output(l_errmsg);
536: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
537: errbuf := l_errmsg;
538:

Line 535: pn_variable_amount_pkg.put_output(l_errmsg);

531: ) = 'N' THEN
532: fnd_message.set_name('PN','PN_VOL_INV_PRD');
533: l_errmsg := fnd_message.get;
534: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
535: pn_variable_amount_pkg.put_output(l_errmsg);
536: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
537: errbuf := l_errmsg;
538:
539: err_flag := TRUE;

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

532: fnd_message.set_name('PN','PN_VOL_INV_PRD');
533: l_errmsg := fnd_message.get;
534: pn_variable_amount_pkg.put_output('+-----------------------------------------------------------+');
535: pn_variable_amount_pkg.put_output(l_errmsg);
536: pn_variable_amount_pkg.put_output('+------------------------------------------------------------+');
537: errbuf := l_errmsg;
538:
539: err_flag := TRUE;
540:

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

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

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

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

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

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

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

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

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

749: EXCEPTION
750: WHEN TOO_MANY_ROWS THEN
751: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - TOO_MANY_ROWS');
752: WHEN NO_DATA_FOUND THEN
753: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - NO_DATA_FOUND');
754: WHEN OTHERS THEN
755: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);
756: END;
757:

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

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

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

755: pn_variable_amount_pkg.put_log ('Cannot Get Main Lease Details - Unknown Error:'|| SQLERRM);
756: END;
757:
758:
759: --pn_variable_amount_pkg.put_log ('create_payment_terms - multi_org_flag :'||
760: --mo_utils.get_multi_org_flag);
761: pn_variable_amount_pkg.put_log ('create_payment_terms - Org id :'||p_org_id);
762:
763:

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

757:
758:
759: --pn_variable_amount_pkg.put_log ('create_payment_terms - multi_org_flag :'||
760: --mo_utils.get_multi_org_flag);
761: pn_variable_amount_pkg.put_log ('create_payment_terms - Org id :'||p_org_id);
762:
763:
764: l_context := 'Getting set of books id';
765:

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

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

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

775: ,l_org_id));
776:
777:
778: pn_variable_amount_pkg.put_log ('create_payment_terms - Currency Code :'||g_currency_code);
779: pn_variable_amount_pkg.put_log ('create_payment_terms - Set of books id :'||l_set_of_books_id);
780:
781:
782: l_context := 'opening cursor csr_template';
783:

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

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

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

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

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

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

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

985:
986: FOR rec_distributions in csr_distributions(p_var_rent_id)
987:
988: LOOP
989: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
990: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
991:
992:
993: l_context := 'Inserting into pn_distributions';

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

986: FOR rec_distributions in csr_distributions(p_var_rent_id)
987:
988: LOOP
989: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
990: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
991:
992:
993: l_context := 'Inserting into pn_distributions';
994: pn_distributions_pkg.insert_row (

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

1935: l_distribution_count := 0;
1936:
1937: FOR rec_distributions IN csr_distributions LOOP
1938:
1939: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
1940: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
1941:
1942:
1943: l_context := 'Inserting into pn_distributions';

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

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