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_AMOUNT_PKG dependencies on PNP_DEBUG_PKG

Line 253: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (+) ');

249: AND lines.line_item_id = NVL(ip_line_item_id,lines.line_item_id);
250:
251: BEGIN
252:
253: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (+) ');
254:
255: pnp_debug_pkg.log('process_variable_rent - Cumulative : '||p_cumulative);
256: pnp_debug_pkg.log('process_variable_rent - Invoice On : '||p_invoice_on);
257:

Line 255: pnp_debug_pkg.log('process_variable_rent - Cumulative : '||p_cumulative);

251: BEGIN
252:
253: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (+) ');
254:
255: pnp_debug_pkg.log('process_variable_rent - Cumulative : '||p_cumulative);
256: pnp_debug_pkg.log('process_variable_rent - Invoice On : '||p_invoice_on);
257:
258: /* intialize the global variables for later use when inserting/updating into
259: pn_var_rent_SUMm */

Line 256: pnp_debug_pkg.log('process_variable_rent - Invoice On : '||p_invoice_on);

252:
253: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (+) ');
254:
255: pnp_debug_pkg.log('process_variable_rent - Cumulative : '||p_cumulative);
256: pnp_debug_pkg.log('process_variable_rent - Invoice On : '||p_invoice_on);
257:
258: /* intialize the global variables for later use when inserting/updating into
259: pn_var_rent_SUMm */
260:

Line 278: pnp_debug_pkg.put_log_msg(fnd_message.get);

274: FOR rec_get_lines in csr_get_lines(p_line_item_id)
275: LOOP
276: fnd_message.set_name ('PN','PN_VRAM_LN_NO');
277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);
278: pnp_debug_pkg.put_log_msg(fnd_message.get);
279:
280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);
281: pnp_debug_pkg.log('process_variable_rent - Line item id : '||rec_get_lines.line_item_id);
282:

Line 280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);

276: fnd_message.set_name ('PN','PN_VRAM_LN_NO');
277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);
278: pnp_debug_pkg.put_log_msg(fnd_message.get);
279:
280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);
281: pnp_debug_pkg.log('process_variable_rent - Line item id : '||rec_get_lines.line_item_id);
282:
283: process_calculate_TYPE(p_line_item_id => rec_get_lines.line_item_id,
284: p_cumulative => p_cumulative,

Line 281: pnp_debug_pkg.log('process_variable_rent - Line item id : '||rec_get_lines.line_item_id);

277: fnd_message.set_token ('NUM',rec_get_lines.line_item_num);
278: pnp_debug_pkg.put_log_msg(fnd_message.get);
279:
280: pnp_debug_pkg.log('process_variable_rent - Period id :'||rec_get_lines.period_id);
281: pnp_debug_pkg.log('process_variable_rent - Line item id : '||rec_get_lines.line_item_id);
282:
283: process_calculate_TYPE(p_line_item_id => rec_get_lines.line_item_id,
284: p_cumulative => p_cumulative,
285: p_calc_TYPE => p_calc_TYPE,

Line 297: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (-) ');

293: p_period_id => p_period_id,
294: p_var_rent_id => p_var_rent_id);
295:
296:
297: pnp_debug_pkg.log('pn_variable_amount_pkg.process_variable_rent (-) ');
298:
299: END process_variable_rent;
300:
301:

Line 355: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (+) ');

351: l_min_grp_date DATE;
352:
353: BEGIN
354:
355: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (+) ');
356:
357:
358: /* get the Breakpoint info. For the line item */
359:

Line 504: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (-) ');

500:
501: END IF;
502:
503:
504: pnp_debug_pkg.log('pn_variable_amount_pkg.process_calculate_TYPE (-) ');
505:
506: END process_calculate_TYPE;
507:
508:

Line 536: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (+) ');

532: j NUMBER := 0;
533:
534: BEGIN
535:
536: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (+) ');
537:
538:
539: /* Get the percent days open for the group date*/
540:

Line 556: pnp_debug_pkg.put_log_msg('===============================================================================');

552:
553: END LOOP;
554:
555:
556: pnp_debug_pkg.put_log_msg('===============================================================================');
557: fnd_message.set_name ('PN','PN_SOI_INV_DT');
558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:

Line 559: pnp_debug_pkg.put_log_msg(fnd_message.get);

555:
556: pnp_debug_pkg.put_log_msg('===============================================================================');
557: fnd_message.set_name ('PN','PN_SOI_INV_DT');
558: fnd_message.set_token ('DATE',g_invoice_date);
559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 563: pnp_debug_pkg.put_log_msg(fnd_message.get);

559: pnp_debug_pkg.put_log_msg(fnd_message.get);
560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);
564: pnp_debug_pkg.put_log_msg('===============================================================================');
565:
566: /* Initialize variables with total volume AND deduction*/
567:

Line 564: pnp_debug_pkg.put_log_msg('===============================================================================');

560:
561: fnd_message.set_name ('PN','PN_VRAM_GRP_DATE');
562: fnd_message.set_token ('DATE',l_group_date);
563: pnp_debug_pkg.put_log_msg(fnd_message.get);
564: pnp_debug_pkg.put_log_msg('===============================================================================');
565:
566: /* Initialize variables with total volume AND deduction*/
567:
568: IF p_cumulative = 'N' THEN

Line 613: pnp_debug_pkg.log('calculate_var_rent : p_cumulative '|| p_cumulative);

609:
610:
611: /* Apply the break points on the volume history AND get the rent applicable */
612:
613: pnp_debug_pkg.log('calculate_var_rent : p_cumulative '|| p_cumulative);
614: pnp_debug_pkg.log('calculate_var_rent : p_net_volume '|| l_net_volume);
615: pnp_debug_pkg.log('calculate_var_rent : p_percent_days_open '|| l_proration_factor);
616:
617: l_variable_rent := get_rent_applicable(

Line 614: pnp_debug_pkg.log('calculate_var_rent : p_net_volume '|| l_net_volume);

610:
611: /* Apply the break points on the volume history AND get the rent applicable */
612:
613: pnp_debug_pkg.log('calculate_var_rent : p_cumulative '|| p_cumulative);
614: pnp_debug_pkg.log('calculate_var_rent : p_net_volume '|| l_net_volume);
615: pnp_debug_pkg.log('calculate_var_rent : p_percent_days_open '|| l_proration_factor);
616:
617: l_variable_rent := get_rent_applicable(
618: p_cumulative => p_cumulative,

Line 615: pnp_debug_pkg.log('calculate_var_rent : p_percent_days_open '|| l_proration_factor);

611: /* Apply the break points on the volume history AND get the rent applicable */
612:
613: pnp_debug_pkg.log('calculate_var_rent : p_cumulative '|| p_cumulative);
614: pnp_debug_pkg.log('calculate_var_rent : p_net_volume '|| l_net_volume);
615: pnp_debug_pkg.log('calculate_var_rent : p_percent_days_open '|| l_proration_factor);
616:
617: l_variable_rent := get_rent_applicable(
618: p_cumulative => p_cumulative,
619: p_net_volume => l_net_volume,

Line 639: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (-) ');

635: P_CUMULATIVE => p_cumulative);
636:
637:
638:
639: pnp_debug_pkg.log('pn_variable_amount_pkg.calculate_var_rent (-) ');
640:
641: END calculate_var_rent;
642:
643:

Line 671: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (+) ');

667: l_rent NUMBER := 0;
668: i NUMBER := 0;
669: BEGIN
670:
671: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (+) ');
672:
673:
674: IF p_cumulative = 'N' AND
675: p_net_volume < (bkpt_range_tbl(1).group_bkpt_vol_start * p_percent_days_open)

Line 713: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);

709: l_rent := l_rent + (p_net_volume - (l_bkpt_vol_start *
710: p_percent_days_open)
711: ) * bkpt_range_tbl(i).bkpt_rate;
712:
713: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
714: pnp_debug_pkg.log('p_net_volume <= l_bkpt_vol_end');
715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *
717: p_percent_days_open)));

Line 714: pnp_debug_pkg.log('p_net_volume <= l_bkpt_vol_end');

710: p_percent_days_open)
711: ) * bkpt_range_tbl(i).bkpt_rate;
712:
713: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
714: pnp_debug_pkg.log('p_net_volume <= l_bkpt_vol_end');
715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *
717: p_percent_days_open)));
718: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

Line 715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);

711: ) * bkpt_range_tbl(i).bkpt_rate;
712:
713: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
714: pnp_debug_pkg.log('p_net_volume <= l_bkpt_vol_end');
715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *
717: p_percent_days_open)));
718: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
719: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);

Line 716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *

712:
713: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
714: pnp_debug_pkg.log('p_net_volume <= l_bkpt_vol_end');
715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *
717: p_percent_days_open)));
718: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
719: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
720:

Line 718: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

714: pnp_debug_pkg.log('p_net_volume <= l_bkpt_vol_end');
715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *
717: p_percent_days_open)));
718: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
719: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
720:
721:
722: ELSE

Line 719: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);

715: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
716: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| (p_net_volume - (l_bkpt_vol_start *
717: p_percent_days_open)));
718: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
719: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
720:
721:
722: ELSE
723: l_rent := l_rent + ((l_bkpt_vol_end * p_percent_days_open)-

Line 727: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);

723: l_rent := l_rent + ((l_bkpt_vol_end * p_percent_days_open)-
724: (l_bkpt_vol_start * p_percent_days_open)
725: ) * bkpt_range_tbl(i).bkpt_rate;
726:
727: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
728: pnp_debug_pkg.log('p_net_volume > l_bkpt_vol_end ');
729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *
731: p_percent_days_open)- (l_bkpt_vol_start * p_percent_days_open)));

Line 728: pnp_debug_pkg.log('p_net_volume > l_bkpt_vol_end ');

724: (l_bkpt_vol_start * p_percent_days_open)
725: ) * bkpt_range_tbl(i).bkpt_rate;
726:
727: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
728: pnp_debug_pkg.log('p_net_volume > l_bkpt_vol_end ');
729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *
731: p_percent_days_open)- (l_bkpt_vol_start * p_percent_days_open)));
732: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

Line 729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);

725: ) * bkpt_range_tbl(i).bkpt_rate;
726:
727: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
728: pnp_debug_pkg.log('p_net_volume > l_bkpt_vol_end ');
729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *
731: p_percent_days_open)- (l_bkpt_vol_start * p_percent_days_open)));
732: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
733: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);

Line 730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *

726:
727: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
728: pnp_debug_pkg.log('p_net_volume > l_bkpt_vol_end ');
729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *
731: p_percent_days_open)- (l_bkpt_vol_start * p_percent_days_open)));
732: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
733: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
734:

Line 732: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

728: pnp_debug_pkg.log('p_net_volume > l_bkpt_vol_end ');
729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *
731: p_percent_days_open)- (l_bkpt_vol_start * p_percent_days_open)));
732: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
733: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
734:
735:
736: END IF;

Line 733: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);

729: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
730: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| ((l_bkpt_vol_end *
731: p_percent_days_open)- (l_bkpt_vol_start * p_percent_days_open)));
732: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
733: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
734:
735:
736: END IF;
737: ELSE

Line 768: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);

764: IF g_breakpoint_TYPE = 'SLIDING' THEN
765:
766: l_rent := p_net_volume * bkpt_range_tbl(i).bkpt_rate;
767:
768: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
769: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
770: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| p_net_volume);
771: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
772: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);

Line 769: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);

765:
766: l_rent := p_net_volume * bkpt_range_tbl(i).bkpt_rate;
767:
768: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
769: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
770: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| p_net_volume);
771: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
772: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
773:

Line 770: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| p_net_volume);

766: l_rent := p_net_volume * bkpt_range_tbl(i).bkpt_rate;
767:
768: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
769: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
770: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| p_net_volume);
771: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
772: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
773:
774:

Line 771: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

767:
768: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
769: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
770: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| p_net_volume);
771: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
772: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
773:
774:
775: ELSIF g_breakpoint_TYPE = 'FLAT' THEN

Line 772: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);

768: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
769: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
770: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'|| p_net_volume);
771: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
772: pnp_debug_pkg.log('get_rent_applicable - rent :'||l_rent);
773:
774:
775: ELSIF g_breakpoint_TYPE = 'FLAT' THEN
776:

Line 780: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);

776:
777: l_rent := (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)) *
778: bkpt_range_tbl(i).bkpt_rate;
779:
780: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
781: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
782: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'||
783: (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)));
784: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

Line 781: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);

777: l_rent := (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)) *
778: bkpt_range_tbl(i).bkpt_rate;
779:
780: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
781: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
782: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'||
783: (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)));
784: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
785: pnp_debug_pkg.log('get_rent_applicable - Rent :'||l_rent);

Line 782: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'||

778: bkpt_range_tbl(i).bkpt_rate;
779:
780: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
781: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
782: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'||
783: (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)));
784: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
785: pnp_debug_pkg.log('get_rent_applicable - Rent :'||l_rent);
786:

Line 784: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);

780: pnp_debug_pkg.log('get_rent_applicable - Breakpoint TYPE :'||g_breakpoint_TYPE);
781: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
782: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'||
783: (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)));
784: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
785: pnp_debug_pkg.log('get_rent_applicable - Rent :'||l_rent);
786:
787:
788:

Line 785: pnp_debug_pkg.log('get_rent_applicable - Rent :'||l_rent);

781: pnp_debug_pkg.log('get_rent_applicable - Net Volume :'|| p_net_volume);
782: pnp_debug_pkg.log('get_rent_applicable - Volume Applicable :'||
783: (p_net_volume - (l_bkpt_vol_start * p_percent_days_open)));
784: pnp_debug_pkg.log('get_rent_applicable - bkpt rate :'||bkpt_range_tbl(i).bkpt_rate);
785: pnp_debug_pkg.log('get_rent_applicable - Rent :'||l_rent);
786:
787:
788:
789: END IF;

Line 799: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (-) ');

795: END IF;
796: END IF;
797: RETURN l_rent;
798:
799: pnp_debug_pkg.log('pn_variable_amount_pkg.get_rent_applicable (-) ');
800:
801: END get_rent_applicable;
802:
803:

Line 849: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (+) ');

845: AND group_date < p_group_date;
846:
847: BEGIN
848:
849: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (+) ');
850:
851: /* insert into PL/SQL table invoice_tbl all the invoices dates
852: for the period for which rent has been calculated. Info
853: needed to update pn_var_Rent_inv table for the new amounts */

Line 897: pnp_debug_pkg.put_log_msg(fnd_message.get);

893: p_grp_date_id => p_grp_date_id);
894: fnd_message.set_name ('PN','PN_VRAM_RENT');
895: fnd_message.set_token ('TYPE',INITCAP(g_rent_TYPE));
896: fnd_message.set_token ('AMT',l_var_rent);
897: pnp_debug_pkg.put_log_msg(fnd_message.get);
898:
899: IF NVL(l_varrent_exists,'N') = 'N' THEN
900:
901: select pn_var_rent_SUMm_s.nextval

Line 975: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (-) ');

971: END IF;
972:
973:
974:
975: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (-) ');
976:
977: EXCEPTION
978: when others then
979: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 979: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

975: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (-) ');
976:
977: EXCEPTION
978: when others then
979: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
980: raise;
981:
982: END process_rent;
983:

Line 1062: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (+) ');

1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;
1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;
1060:
1061: BEGIN
1062: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (+) ');
1063:
1064: if g_invoice_on = 'FORECASTED' AND g_rent_TYPE = 'ACTUAL' then
1065: l_rent_TYPE := 'VARIANCE';
1066: elsif g_invoice_on = 'FORECASTED' AND g_rent_TYPE = 'FORECASTED' then

Line 1145: pnp_debug_pkg.log('Insert_Invoice - inserting into pn_var_rent_inv');

1141: close csr_get_invoice;
1142:
1143: IF l_insert THEN
1144:
1145: pnp_debug_pkg.log('Insert_Invoice - inserting into pn_var_rent_inv');
1146:
1147:
1148: PN_VAR_RENT_INV_PKG.INSERT_ROW (
1149: X_ROWID => l_rowid_out,

Line 1199: pnp_debug_pkg.log('Insert_Invoice - Updating PN_VAR_RENT_INV ');

1195: l_rowid_out := null;
1196:
1197:
1198: ELSE
1199: pnp_debug_pkg.log('Insert_Invoice - Updating PN_VAR_RENT_INV ');
1200:
1201: /* Delete payment terms from pn_payment_terms created
1202: for the combination of var_rent_inv_id AND rent_TYPE
1203: that are in the draft status since we are recalculating

Line 1229: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (-)');

1225:
1226:
1227: END LOOP; -- invoice_tbl
1228:
1229: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (-)');
1230:
1231: EXCEPTION
1232: when others then
1233: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.Insert_invoice :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 1233: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.Insert_invoice :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

1229: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (-)');
1230:
1231: EXCEPTION
1232: when others then
1233: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.Insert_invoice :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
1234: raise;
1235:
1236: END Insert_invoice;
1237:

Line 1352: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (+) :');

1348: l_prev_invoiced_amt NUMBER;
1349: l_rec_abatement NUMBER := 0;
1350:
1351: BEGIN
1352: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (+) :');
1353:
1354:
1355: OPEN csr_get_abt(p_var_rent_id);
1356: FETCH csr_get_abt into l_total_abatement,l_negative_rent_flag;

Line 1397: pnp_debug_pkg.log('apply_abatements - Invoice Date :'||rec_get_inv.invoice_date);

1393: open csr_neg_appl(p_var_rent_id, rec_get_inv.invoice_date);
1394: fetch csr_neg_appl into l_negative_applied;
1395: close csr_neg_appl;
1396:
1397: pnp_debug_pkg.log('apply_abatements - Invoice Date :'||rec_get_inv.invoice_date);
1398: pnp_debug_pkg.log('apply_abatements - Negative Rent Avaiable :'||l_negative_available);
1399: pnp_debug_pkg.log('apply_abatements - Negative Rent Applied :'||l_negative_applied);
1400:
1401: l_negative_available := l_negative_available - l_negative_applied;

Line 1398: pnp_debug_pkg.log('apply_abatements - Negative Rent Avaiable :'||l_negative_available);

1394: fetch csr_neg_appl into l_negative_applied;
1395: close csr_neg_appl;
1396:
1397: pnp_debug_pkg.log('apply_abatements - Invoice Date :'||rec_get_inv.invoice_date);
1398: pnp_debug_pkg.log('apply_abatements - Negative Rent Avaiable :'||l_negative_available);
1399: pnp_debug_pkg.log('apply_abatements - Negative Rent Applied :'||l_negative_applied);
1400:
1401: l_negative_available := l_negative_available - l_negative_applied;
1402:

Line 1399: pnp_debug_pkg.log('apply_abatements - Negative Rent Applied :'||l_negative_applied);

1395: close csr_neg_appl;
1396:
1397: pnp_debug_pkg.log('apply_abatements - Invoice Date :'||rec_get_inv.invoice_date);
1398: pnp_debug_pkg.log('apply_abatements - Negative Rent Avaiable :'||l_negative_available);
1399: pnp_debug_pkg.log('apply_abatements - Negative Rent Applied :'||l_negative_applied);
1400:
1401: l_negative_available := l_negative_available - l_negative_applied;
1402:
1403: END IF;

Line 1461: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);

1457: END IF;
1458:
1459: /* Apply recurring Abatements */
1460:
1461: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1462: pnp_debug_pkg.log('applying recurring Abatements ... ');
1463:
1464: IF rec_get_inv.adjust_num > 0 THEN
1465: l_rec_abatement := NVL(rec_get_inv.rec_abatement_override,rec_get_inv.rec_abatement);

Line 1462: pnp_debug_pkg.log('applying recurring Abatements ... ');

1458:
1459: /* Apply recurring Abatements */
1460:
1461: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1462: pnp_debug_pkg.log('applying recurring Abatements ... ');
1463:
1464: IF rec_get_inv.adjust_num > 0 THEN
1465: l_rec_abatement := NVL(rec_get_inv.rec_abatement_override,rec_get_inv.rec_abatement);
1466: ELSIF l_actual_invoice_amt > 0 THEN

Line 1475: pnp_debug_pkg.log('apply_abatements - l_rec_abatement : '||l_rec_abatement);

1471: END IF;
1472:
1473: l_actual_invoice_amt := l_actual_invoice_amt - NVL(l_rec_abatement,0) ;
1474:
1475: pnp_debug_pkg.log('apply_abatements - l_rec_abatement : '||l_rec_abatement);
1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);
1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);

Line 1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);

1472:
1473: l_actual_invoice_amt := l_actual_invoice_amt - NVL(l_rec_abatement,0) ;
1474:
1475: pnp_debug_pkg.log('apply_abatements - l_rec_abatement : '||l_rec_abatement);
1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);
1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);

Line 1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);

1473: l_actual_invoice_amt := l_actual_invoice_amt - NVL(l_rec_abatement,0) ;
1474:
1475: pnp_debug_pkg.log('apply_abatements - l_rec_abatement : '||l_rec_abatement);
1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);
1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);

Line 1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);

1474:
1475: pnp_debug_pkg.log('apply_abatements - l_rec_abatement : '||l_rec_abatement);
1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);
1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);

Line 1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);

1475: pnp_debug_pkg.log('apply_abatements - l_rec_abatement : '||l_rec_abatement);
1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);
1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);
1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);

Line 1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);

1476: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'|| l_actual_invoice_amt);
1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);
1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1484: pnp_debug_pkg.log('apply_abatements- rec_get_inv.actual_invoiced_amount :'||rec_get_inv. actual_invoiced_amount);

Line 1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);

1477: pnp_debug_pkg.log('apply_abatements - l_negative_rent :'||l_negative_rent);
1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);
1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1484: pnp_debug_pkg.log('apply_abatements- rec_get_inv.actual_invoiced_amount :'||rec_get_inv. actual_invoiced_amount);
1485:

Line 1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);

1478: pnp_debug_pkg.log('apply_abatements - rec_get_inv.negative_rent :'||rec_get_inv.negative_rent);
1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);
1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1484: pnp_debug_pkg.log('apply_abatements- rec_get_inv.actual_invoiced_amount :'||rec_get_inv. actual_invoiced_amount);
1485:
1486: IF l_negative_rent = rec_get_inv.negative_rent AND

Line 1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);

1479: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);
1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1484: pnp_debug_pkg.log('apply_abatements- rec_get_inv.actual_invoiced_amount :'||rec_get_inv. actual_invoiced_amount);
1485:
1486: IF l_negative_rent = rec_get_inv.negative_rent AND
1487: l_abatement_applied = rec_get_inv.abatement_appl AND

Line 1484: pnp_debug_pkg.log('apply_abatements- rec_get_inv.actual_invoiced_amount :'||rec_get_inv. actual_invoiced_amount);

1480: pnp_debug_pkg.log('apply_abatements - rec_get_inv.abatement_appl :'||rec_get_inv.abatement_appl);
1481: pnp_debug_pkg.log('apply_abatements - l_abatement_applied :'||l_abatement_applied);
1482: pnp_debug_pkg.log('recurring abt applied - l_rec_abatement:'||l_rec_abatement);
1483: pnp_debug_pkg.log('apply_abatements - l_actual_invoice_amt :'||l_actual_invoice_amt);
1484: pnp_debug_pkg.log('apply_abatements- rec_get_inv.actual_invoiced_amount :'||rec_get_inv. actual_invoiced_amount);
1485:
1486: IF l_negative_rent = rec_get_inv.negative_rent AND
1487: l_abatement_applied = rec_get_inv.abatement_appl AND
1488: l_actual_invoice_amt = rec_get_inv.actual_invoiced_amount or

Line 1518: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (-):');

1514:
1515:
1516: END LOOP;
1517:
1518: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (-):');
1519:
1520: EXCEPTION
1521: when others then
1522: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.apply_abatements :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 1522: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.apply_abatements :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

1518: pnp_debug_pkg.log('pn_variable_amount_pkg.apply_abatements (-):');
1519:
1520: EXCEPTION
1521: when others then
1522: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.apply_abatements :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
1523: raise;
1524:
1525: END apply_abatements;
1526:

Line 1549: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (+) ');

1545: l_upper_bound NUMBER;
1546: l_constr_act_rent NUMBER;
1547:
1548: BEGIN
1549: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (+) ');
1550:
1551: FOR rec_get_constr in csr_get_constr(p_period_id)
1552: LOOP
1553: IF rec_get_constr.TYPE_code = 'MIN' THEN

Line 1562: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);

1558: END LOOP;
1559:
1560: /* Apply constraints to Actual variable rent */
1561:
1562: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
1563: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
1564: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
1565:
1566: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN

Line 1563: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);

1559:
1560: /* Apply constraints to Actual variable rent */
1561:
1562: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
1563: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
1564: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
1565:
1566: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN
1567: l_constr_act_rent := l_lower_bound;

Line 1564: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);

1560: /* Apply constraints to Actual variable rent */
1561:
1562: pnp_debug_pkg.log('apply_constraints - Lower bound :'|| l_lower_bound);
1563: pnp_debug_pkg.log('apply_constraints - Upper bound :'|| l_upper_bound);
1564: pnp_debug_pkg.log('apply_constraints - Actual Rent :'|| p_actual_rent);
1565:
1566: IF p_actual_rent < NVL(l_lower_bound,p_actual_rent) THEN
1567: l_constr_act_rent := l_lower_bound;
1568: ELSIF p_actual_rent > NVL(l_upper_bound,p_actual_rent) THEN

Line 1574: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);

1570: ELSE
1571: l_constr_act_rent := p_actual_rent;
1572: END IF;
1573:
1574: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
1575:
1576: RETURN l_constr_act_rent;
1577: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
1578: END apply_constraints;

Line 1577: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');

1573:
1574: pnp_debug_pkg.log('apply_constraints - Constrained Actual rent :'||l_constr_act_rent);
1575:
1576: RETURN l_constr_act_rent;
1577: pnp_debug_pkg.log( 'pn_variable_amount_pkg.apply_constraints : (-) ');
1578: END apply_constraints;
1579:
1580: -----------------------------------------------------------------------------
1581: -- FUNCTION : find_varrent_exists

Line 1596: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (+) ');

1592: l_varrent_exists VARCHAR2(1) := 'N';
1593:
1594: BEGIN
1595:
1596: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (+) ');
1597:
1598: SELECT 'Y'
1599: INTO l_varrent_exists
1600: FROM dual

Line 1612: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (-) ');

1608: EXCEPTION
1609: WHEN no_data_found
1610: THEN RETURN 'N';
1611:
1612: pnp_debug_pkg.log('pn_variable_amount_pkg.find_varrent_exists (-) ');
1613:
1614: END find_varrent_exists;
1615:
1616:

Line 1629: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (+) ');

1625: p_forecasted_flag OUT NOCOPY VARCHAR2,
1626: p_variance_flag OUT NOCOPY VARCHAR2)
1627: IS
1628: BEGIN
1629: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (+) ');
1630:
1631: SELECT distinct actual_exp_code,forecasted_exp_code,variance_exp_code
1632: INTO p_actual_flag,p_forecasted_flag,p_variance_flag
1633: FROM pn_var_grp_dates_all

Line 1639: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_transferred_flag :'||

1635: AND invoice_date = p_invoice_date;
1636:
1637: EXCEPTION
1638: WHEN no_data_found then null;
1639: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_transferred_flag :'||
1640: TO_CHAR(sqlcode)||': '||sqlerrm);
1641:
1642: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (-) ');
1643:

Line 1642: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (-) ');

1638: WHEN no_data_found then null;
1639: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_transferred_flag :'||
1640: TO_CHAR(sqlcode)||': '||sqlerrm);
1641:
1642: pnp_debug_pkg.log('pn_variable_amount_pkg.get_transferred_flag (-) ');
1643:
1644: END get_transferred_flag;
1645:
1646:

Line 1665: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (+) ');

1661: l_no_of_days NUMBER;
1662: i NUMBER :=0;
1663:
1664: BEGIN
1665: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (+) ');
1666:
1667: /* Initialize the PL/SQL table */
1668: grd_date_tbl.delete;
1669:

Line 1698: pnp_debug_pkg.log('get_percent_open - group date : '||rec_get_gd.group_date);

1694: grd_date_tbl(i).proration_factor := l_proration_factor;
1695: grd_date_tbl(i).invoice_date := rec_get_gd.invoice_date;
1696: grd_date_tbl(i).group_date := rec_get_gd.group_date;
1697:
1698: pnp_debug_pkg.log('get_percent_open - group date : '||rec_get_gd.group_date);
1699: pnp_debug_pkg.log('get_percent_open - l_no_of_days : '||l_no_of_days);
1700: pnp_debug_pkg.log('get_percent_open - l_proration_factor : '||l_proration_factor);
1701:
1702: END LOOP;

Line 1699: pnp_debug_pkg.log('get_percent_open - l_no_of_days : '||l_no_of_days);

1695: grd_date_tbl(i).invoice_date := rec_get_gd.invoice_date;
1696: grd_date_tbl(i).group_date := rec_get_gd.group_date;
1697:
1698: pnp_debug_pkg.log('get_percent_open - group date : '||rec_get_gd.group_date);
1699: pnp_debug_pkg.log('get_percent_open - l_no_of_days : '||l_no_of_days);
1700: pnp_debug_pkg.log('get_percent_open - l_proration_factor : '||l_proration_factor);
1701:
1702: END LOOP;
1703:

Line 1700: pnp_debug_pkg.log('get_percent_open - l_proration_factor : '||l_proration_factor);

1696: grd_date_tbl(i).group_date := rec_get_gd.group_date;
1697:
1698: pnp_debug_pkg.log('get_percent_open - group date : '||rec_get_gd.group_date);
1699: pnp_debug_pkg.log('get_percent_open - l_no_of_days : '||l_no_of_days);
1700: pnp_debug_pkg.log('get_percent_open - l_proration_factor : '||l_proration_factor);
1701:
1702: END LOOP;
1703:
1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');

Line 1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');

1700: pnp_debug_pkg.log('get_percent_open - l_proration_factor : '||l_proration_factor);
1701:
1702: END LOOP;
1703:
1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');
1705:
1706: EXCEPTION
1707: when others then
1708: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.get_percent_open :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

Line 1708: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.get_percent_open :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

1704: pnp_debug_pkg.log('pn_variable_amount_pkg.get_percent_open (-) ');
1705:
1706: EXCEPTION
1707: when others then
1708: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.get_percent_open :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
1709:
1710: END get_percent_open;
1711:
1712:

Line 1726: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (+) ');

1722: i NUMBER :=0;
1723:
1724: BEGIN
1725:
1726: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (+) ');
1727:
1728: /* Initialize the PL/SQL table */
1729: deduction_tbl.delete;
1730:

Line 1742: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (-) ');

1738: deduction_tbl(i).deduction_amt := rec_get_ded.deduction_amt;
1739:
1740: END LOOP;
1741:
1742: pnp_debug_pkg.log('pn_variable_amount_pkg.get_deductions (-) ');
1743:
1744: END get_deductions;
1745:
1746:

Line 1763: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (+) ');

1759: i NUMBER :=0;
1760:
1761: BEGIN
1762:
1763: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (+) ');
1764:
1765: /* Initialize the PL/SQL table */
1766: bkpt_range_tbl.delete;
1767:

Line 1784: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (-) ');

1780:
1781:
1782: END LOOP;
1783:
1784: pnp_debug_pkg.log('pn_variable_amount_pkg.get_bkp_details (-) ');
1785:
1786: END get_bkp_details;
1787:
1788:

Line 1803: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (+) ');

1799: IS
1800: i NUMBER := 1;
1801: BEGIN
1802:
1803: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (+) ');
1804:
1805: /* Get the existing cumulative actual AND forecasted volume for all the
1806: group date prior to this group date AND put them in the
1807: p_act_cum_vol AND p_for_cum_vol */

Line 1821: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (-) ');

1817:
1818: END IF;
1819: END LOOP;
1820:
1821: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cum_vol_by_grpdt (-) ');
1822:
1823: END;
1824:
1825: ------------------------------------------------------------------------

Line 1846: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (+) ');

1842:
1843:
1844: BEGIN
1845:
1846: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (+) ');
1847:
1848: /* Initialize the PL/SQL table */
1849: cum_vol_tbl.delete;
1850:

Line 1892: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (-) ');

1888: END IF;
1889:
1890: END LOOP;
1891:
1892: pnp_debug_pkg.log('pn_variable_amount_pkg.get_cumulative_volume (-) ');
1893:
1894: END get_cumulative_volume;
1895:
1896:

Line 1910: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (+) ');

1906: p_negative_rent OUT NOCOPY VARCHAR2)
1907: IS
1908: BEGIN
1909:
1910: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (+) ');
1911:
1912: SELECT cumulative_vol,
1913: invoice_on,
1914: negative_rent

Line 1921: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (-) ');

1917: p_negative_rent
1918: FROM pn_var_rents_all
1919: WHERE var_rent_id = p_var_rent_id;
1920:
1921: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (-) ');
1922:
1923: END get_varrent_details;
1924:
1925: ------------------------------------------------------------------------------------

Line 1990: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (+) : ');

1986: IS
1987: l_volume_exists VARCHAR2(1) := 'N';
1988:
1989: BEGIN
1990: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (+) : ');
1991:
1992: SELECT 'Y'
1993: INTO l_volume_exists
1994: FROM dual

Line 2019: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (-) : ');

2015: EXCEPTION
2016: WHEN no_data_found then
2017: RETURN 'N';
2018:
2019: pnp_debug_pkg.log('pn_variable_amount_pkg.find_volume_exists (-) : ');
2020: END find_volume_exists;
2021:
2022: ----------------------------------------------------------------------------
2023: -- FUNCTION : get_prior_transfer_flag

Line 2091: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (+) : ');

2087: l_period_id NUMBER;
2088: l_cur_period_id NUMBER := NULL;
2089:
2090: BEGIN
2091: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (+) : ');
2092:
2093:
2094: FOR rec IN period_cur LOOP
2095: l_period_id := rec.period_id;

Line 2121: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (-) : ');

2117: END IF;
2118:
2119: RETURN l_exists;
2120:
2121: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prior_transfer_flag (-) : ');
2122:
2123: END get_prior_transfer_flag;
2124:
2125: ----------------------------------------------------------------------------

Line 2147: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (+) : ');

2143: l_prev_inv_amt NUMBER := 0;
2144:
2145: BEGIN
2146:
2147: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (+) : ');
2148:
2149: OPEN csr_prev_inv_amt(p_var_rent_id,p_invoice_date,p_adjust_num);
2150: FETCH csr_prev_inv_amt INTO l_prev_inv_amt;
2151: CLOSE csr_prev_inv_amt;

Line 2155: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (-) : ');

2151: CLOSE csr_prev_inv_amt;
2152:
2153: RETURN l_prev_inv_amt;
2154:
2155: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prev_inv_amt (-) : ');
2156:
2157: END get_prev_inv_amt;
2158:
2159: -------------------------------------------------------------------------------------------------

Line 2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );

2388: /* l_global_rec pn_mo_cache_utils.GlobalsRecord; */
2389:
2390:
2391: BEGIN
2392: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (+)' );
2393: g_period_date := NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'));
2394:
2395: fnd_message.set_name ('PN','PN_VRAM_PRM');
2396: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);

Line 2406: pnp_debug_pkg.put_log_msg(fnd_message.get);

2402: fnd_message.set_token ('PRD_FRM', p_period_num_from);
2403: fnd_message.set_token ('PRD_TO', p_period_num_to);
2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
2409:
2410:

Line 2408: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);

2404: fnd_message.set_token ('USR', p_responsible_user);
2405: fnd_message.set_token ('DATE', p_period_date);
2406: pnp_debug_pkg.put_log_msg(fnd_message.get);
2407:
2408: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
2409:
2410:
2411: /* Retrieve operating unit attributes AND store them in the cache */
2412:

Line 2434: pnp_debug_pkg.log('process_rent_batch - currency_code :'||g_currency_code);

2430: CLOSE csr_currency_code;
2431:
2432: fnd_currency.get_info(g_currency_code, g_precision,l_ext_precision, l_min_acct_unit);
2433:
2434: pnp_debug_pkg.log('process_rent_batch - currency_code :'||g_currency_code);
2435: pnp_debug_pkg.log('process_rent_batch - set_of_books_id :'||g_set_of_books_id);
2436: pnp_debug_pkg.log('process_rent_batch - precision :'||g_precision);
2437:
2438: ---- end ----

Line 2435: pnp_debug_pkg.log('process_rent_batch - set_of_books_id :'||g_set_of_books_id);

2431:
2432: fnd_currency.get_info(g_currency_code, g_precision,l_ext_precision, l_min_acct_unit);
2433:
2434: pnp_debug_pkg.log('process_rent_batch - currency_code :'||g_currency_code);
2435: pnp_debug_pkg.log('process_rent_batch - set_of_books_id :'||g_set_of_books_id);
2436: pnp_debug_pkg.log('process_rent_batch - precision :'||g_precision);
2437:
2438: ---- end ----
2439:

Line 2436: pnp_debug_pkg.log('process_rent_batch - precision :'||g_precision);

2432: fnd_currency.get_info(g_currency_code, g_precision,l_ext_precision, l_min_acct_unit);
2433:
2434: pnp_debug_pkg.log('process_rent_batch - currency_code :'||g_currency_code);
2435: pnp_debug_pkg.log('process_rent_batch - set_of_books_id :'||g_set_of_books_id);
2436: pnp_debug_pkg.log('process_rent_batch - precision :'||g_precision);
2437:
2438: ---- end ----
2439:
2440: IF p_location_code_from IS NOT NULL or p_location_code_to IS NOT NULL THEN

Line 2461: pnp_debug_pkg.put_log_msg(fnd_message.get);

2457: END IF;
2458:
2459: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
2460: fnd_message.set_token ('NUM',l_rent_num);
2461: pnp_debug_pkg.put_log_msg(fnd_message.get);
2462:
2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
2464: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
2465:

Line 2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);

2459: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
2460: fnd_message.set_token ('NUM',l_rent_num);
2461: pnp_debug_pkg.put_log_msg(fnd_message.get);
2462:
2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
2464: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
2465:
2466:
2467: /* get the currency code, set of books id AND initialize global variable */

Line 2464: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);

2460: fnd_message.set_token ('NUM',l_rent_num);
2461: pnp_debug_pkg.put_log_msg(fnd_message.get);
2462:
2463: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
2464: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
2465:
2466:
2467: /* get the currency code, set of books id AND initialize global variable */
2468:

Line 2496: pnp_debug_pkg.put_log_msg(fnd_message.get);

2492: LOOP
2493:
2494: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
2495: fnd_message.set_token ('NUM',rec_get_per.period_num);
2496: pnp_debug_pkg.put_log_msg(fnd_message.get);
2497:
2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
2499: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
2500:

Line 2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);

2494: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
2495: fnd_message.set_token ('NUM',rec_get_per.period_num);
2496: pnp_debug_pkg.put_log_msg(fnd_message.get);
2497:
2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
2499: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
2500:
2501: /* get the group date ids AND proration factor for the group dates for the period */
2502:

Line 2499: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);

2495: fnd_message.set_token ('NUM',rec_get_per.period_num);
2496: pnp_debug_pkg.put_log_msg(fnd_message.get);
2497:
2498: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
2499: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
2500:
2501: /* get the group date ids AND proration factor for the group dates for the period */
2502:
2503: get_percent_open(p_period_id => rec_get_per.period_id,

Line 2552: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent_batch :'||TO_CHAR(sqlcode)||' : '||sqlerrm);

2548:
2549: EXCEPTION
2550:
2551: When OTHERS Then
2552: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_rent_batch :'||TO_CHAR(sqlcode)||' : '||sqlerrm);
2553: Errbuf := SQLERRM;
2554: Retcode := 2;
2555: rollback;
2556: raise;

Line 2558: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (-) ');

2554: Retcode := 2;
2555: rollback;
2556: raise;
2557:
2558: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent_batch (-) ');
2559: END process_rent_batch;
2560:
2561:
2562: ----------------------------------------------------------------------------

Line 2638: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (+) ');

2634: l_var_exp_code pn_var_rent_inv.variance_exp_code%TYPE := null;
2635: l_var_rent_inv_id pn_var_rent_inv.var_rent_inv_id%TYPE;
2636:
2637: BEGIN
2638: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (+) ');
2639:
2640: /* Does a row exist in pn_var_rent_SUMm for grp_date_id AND line_item_id */
2641: l_varrent_exists := find_varrent_exists(
2642: p_line_item_id => p_line_item_id,

Line 2710: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_vol_hist : '||TO_CHAR(sqlcode)||' : '||sqlerrm);

2706:
2707: EXCEPTION
2708:
2709: When OTHERS Then
2710: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_vol_hist : '||TO_CHAR(sqlcode)||' : '||sqlerrm);
2711: rollback;
2712: raise;
2713:
2714: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (-) ');

Line 2714: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (-) ');

2710: pnp_debug_pkg.log('Error in pn_variable_amount_pkg.process_vol_hist : '||TO_CHAR(sqlcode)||' : '||sqlerrm);
2711: rollback;
2712: raise;
2713:
2714: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (-) ');
2715:
2716: END process_vol_hist;
2717:
2718: ----------------------------------------------------------------------------

Line 2731: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (+) ');

2727:
2728: l_msg varchar2(200) := null;
2729:
2730: BEGIN
2731: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (+) ');
2732:
2733: IF p_calc is not null THEN
2734: IF p_adj is not null AND p_rec is not null THEN
2735: l_msg := p_calc||', '||p_adj||' AND '||p_rec||' processes';

Line 2757: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (-) ');

2753: END IF;
2754:
2755: RETURN l_msg;
2756:
2757: pnp_debug_pkg.log('pn_variable_amount_pkg.get_msg (-) ');
2758: END get_msg;
2759:
2760: ----------------------------------------------------------------------------
2761: -- FUNCTION : get_prorated_bkpt

Line 2783: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (+) :');

2779: RETURN NUMBER IS
2780: l_pror_bkpt NUMBER := null;
2781: l_no_of_days NUMBER := null;
2782: BEGIN
2783: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (+) :');
2784: IF NVL(p_cumulative,'N') = 'Y' THEN
2785: l_no_of_days := (p_per_end_dt - p_per_st_dt) + 1;
2786: l_pror_bkpt := (l_no_of_days/p_pror_factor) * p_per_bkpt;
2787: ELSE

Line 2791: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (-) :');

2787: ELSE
2788: l_no_of_days := (p_grp_end_dt - p_grp_st_dt) + 1;
2789: l_pror_bkpt := (l_no_of_days/p_pror_factor) * p_grp_bkpt;
2790: END IF;
2791: pnp_debug_pkg.log('pn_variable_amount_pkg.get_prorated_bkpt (-) :');
2792: RETURN l_pror_bkpt;
2793:
2794: END get_prorated_bkpt;
2795:

Line 2812: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (+) :');

2808: l_actual_invoiced_amount pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
2809: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE := 0;
2810:
2811: BEGIN
2812: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (+) :');
2813:
2814: l_constr_actual_rent := p_constr_actual_rent;
2815:
2816: IF (p_constr_actual_rent < 0 AND p_negative_rent_flag in('DEFER','IGNORE')) THEN

Line 2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);

2816: IF (p_constr_actual_rent < 0 AND p_negative_rent_flag in('DEFER','IGNORE')) THEN
2817: l_constr_actual_rent := 0;
2818: END IF;
2819:
2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);
2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);
2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);

Line 2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);

2817: l_constr_actual_rent := 0;
2818: END IF;
2819:
2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);
2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);
2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);
2825:

Line 2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);

2818: END IF;
2819:
2820: pnp_debug_pkg.log('pn_variable_amount_pkg - l_constr_actual_rent :'||l_constr_actual_rent);
2821: pnp_debug_pkg.log('pn_variable_amount_pkg - p_abatement_appl :'||p_abatement_appl);
2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);
2825:
2826: pnp_debug_pkg.log('pn_variable_amount_pkg - l_actual_invoiced_amount '||l_actual_invoiced_amount);

Line 2826: pnp_debug_pkg.log('pn_variable_amount_pkg - l_actual_invoiced_amount '||l_actual_invoiced_amount);

2822: pnp_debug_pkg.log('pn_variable_amount_pkg - p_negative_rent :'||p_negative_rent);
2823:
2824: l_actual_invoiced_amount := l_constr_actual_rent - (p_abatement_appl + p_negative_rent);
2825:
2826: pnp_debug_pkg.log('pn_variable_amount_pkg - l_actual_invoiced_amount '||l_actual_invoiced_amount);
2827:
2828: IF l_actual_invoiced_amount > 0 THEN
2829: l_rec_abatement := NVL(p_rec_abatement_override,
2830: LEAST(l_actual_invoiced_amount,p_rec_abatement));

Line 2835: pnp_debug_pkg.log('pn_variable_amount_pkg - l_rec_abatement '||l_rec_abatement);

2831: ELSE
2832: l_rec_abatement := p_rec_abatement_override;
2833: END IF;
2834:
2835: pnp_debug_pkg.log('pn_variable_amount_pkg - l_rec_abatement '||l_rec_abatement);
2836:
2837: l_actual_invoiced_amount := l_actual_invoiced_amount - NVL(l_rec_abatement,0) ;
2838:
2839: RETURN l_actual_invoiced_amount;

Line 2841: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (-) :');

2837: l_actual_invoiced_amount := l_actual_invoiced_amount - NVL(l_rec_abatement,0) ;
2838:
2839: RETURN l_actual_invoiced_amount;
2840:
2841: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (-) :');
2842:
2843: END derive_actual_invoiced_amt;
2844:
2845: ----------------------------------------------------------------------------

Line 2852: pnp_debug_pkg.log(p_string);

2848: ----------------------------------------------------------------------------
2849: PROCEDURE put_log(p_string VARCHAR2)
2850: IS
2851: BEGIN
2852: pnp_debug_pkg.log(p_string);
2853: END put_log;
2854:
2855: ----------------------------------------------------------------------------
2856: -- PROCEDURE : put_output

Line 2862: pnp_debug_pkg.put_log_msg(p_string);

2858: ----------------------------------------------------------------------------
2859: PROCEDURE put_output(p_string VARCHAR2)
2860: IS
2861: BEGIN
2862: pnp_debug_pkg.put_log_msg(p_string);
2863: END put_output;
2864:
2865: ----------------------------------------------------------------------------
2866: -- PROCEDURE : get_approved_flag

Line 2901: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (+) ');

2897: AND true_up_amt IS NOT NULL -- Bug # 5991106
2898: );
2899:
2900: BEGIN
2901: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (+) ');
2902: IF p_true_up_flag = 'N' THEN
2903: FOR rec IN get_aprvd_cur(p_period_id, p_invoice_date )LOOP
2904: p_actual_flag := rec.actual_exp_code;
2905: p_forecasted_flag := rec.forecasted_exp_code;

Line 2919: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_approved_flag :'||

2915:
2916:
2917:
2918: EXCEPTION
2919: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_approved_flag :'||
2920: TO_CHAR(sqlcode)||': '||sqlerrm);
2921:
2922: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (-) ');
2923:

Line 2922: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (-) ');

2918: EXCEPTION
2919: WHEN others then pnp_debug_pkg.log ('Error in pn_variable_amount_pkg.get_approved_flag :'||
2920: TO_CHAR(sqlcode)||': '||sqlerrm);
2921:
2922: pnp_debug_pkg.log('pn_variable_amount_pkg.get_approved_flag (-) ');
2923:
2924: END get_approved_flag;
2925:
2926: