4593: from pn_var_rent_inv_all
4594: where period_id = l_periods_t(p).period_id
4595: and var_rent_id = p_var_rent_id;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4594: where period_id = l_periods_t(p).period_id
4595: and var_rent_id = p_var_rent_id;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;
4595: and var_rent_id = p_var_rent_id;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;
4603: END IF;
4596:
4597: fnd_message.set_name ('PN','PN_VRAM_RENT');
4598: fnd_message.set_token ('TYPE','ACTUAL');
4599: fnd_message.set_token ('AMT',l_actual_amount);
4600: pnp_debug_pkg.put_log_msg(fnd_message.get);
4601:
4602: END LOOP;
4603: END IF;
4604:
6525:
6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6526: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6527:
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6528:
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6529: fnd_message.set_name ('PN','PN_VRAM_PRM');
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6530: fnd_message.set_token ('PT_NAME', p_property_name);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6531: fnd_message.set_token ('PT_CODE', p_property_code);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6532: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6533: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6534: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6535: fnd_message.set_token ('LOC_TO', p_location_code_to);
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6536: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6537: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6545:
6538: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6539: fnd_message.set_token ('PRD_TO', p_period_num_to);
6540: fnd_message.set_token ('USR', p_responsible_user);
6541: fnd_message.set_token ('DATE', p_period_date);
6542: pnp_debug_pkg.put_log_msg(fnd_message.get);
6543:
6544: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6545:
6546: IF p_property_name is not null and p_property_code is null THEN /* 9765197 */
6588:
6589: END IF;
6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6589: END IF;
6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6590:
6591: IF l_cumulative = 'M' THEN
6592: fnd_message.set_name ('PN','PN_VAR_MANUAL_NOCALC');
6593: fnd_message.set_token ('VR_NUM',l_rent_num);
6594: pnp_debug_pkg.put_log_msg(fnd_message.get);
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6595: ELSE
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6596: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6597: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6598:
6599: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6600: fnd_message.set_token ('NUM',l_rent_num);
6601: pnp_debug_pkg.put_log_msg(fnd_message.get);
6602:
6603: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6604: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6605:
6611:
6612: FOR rec_get_per in csr_get_per(l_var_rent_id)
6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6612: FOR rec_get_per in csr_get_per(l_var_rent_id)
6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6613: LOOP
6614:
6615: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6616: fnd_message.set_token ('NUM',rec_get_per.period_num);
6617: pnp_debug_pkg.put_log_msg(fnd_message.get);
6618:
6619: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6620: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6621: