6483:
6484: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6485:
6486:
6487: fnd_message.set_name ('PN','PN_VRAM_PRM');
6488: fnd_message.set_token ('PT_NAME', p_property_name);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6484: pnp_debug_pkg.log('pn_var_rent_calc_pkg.process_rent_batch (+)' );
6485:
6486:
6487: fnd_message.set_name ('PN','PN_VRAM_PRM');
6488: fnd_message.set_token ('PT_NAME', p_property_name);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6485:
6486:
6487: fnd_message.set_name ('PN','PN_VRAM_PRM');
6488: fnd_message.set_token ('PT_NAME', p_property_name);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6486:
6487: fnd_message.set_name ('PN','PN_VRAM_PRM');
6488: fnd_message.set_token ('PT_NAME', p_property_name);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6487: fnd_message.set_name ('PN','PN_VRAM_PRM');
6488: fnd_message.set_token ('PT_NAME', p_property_name);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6488: fnd_message.set_token ('PT_NAME', p_property_name);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6489: fnd_message.set_token ('PT_CODE', p_property_code);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6490: fnd_message.set_token ('LSNO_FRM', p_lease_num_from);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6491: fnd_message.set_token ('LSNO_TO', p_lease_num_to);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6499: fnd_message.set_token ('DATE', p_period_date);
6492: fnd_message.set_token ('LOC_FRM', p_location_code_from);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6499: fnd_message.set_token ('DATE', p_period_date);
6500: pnp_debug_pkg.put_log_msg(fnd_message.get);
6493: fnd_message.set_token ('LOC_TO', p_location_code_to);
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6499: fnd_message.set_token ('DATE', p_period_date);
6500: pnp_debug_pkg.put_log_msg(fnd_message.get);
6501:
6494: fnd_message.set_token ('VR_FRM', p_vrent_num_from);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6499: fnd_message.set_token ('DATE', p_period_date);
6500: pnp_debug_pkg.put_log_msg(fnd_message.get);
6501:
6502: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6495: fnd_message.set_token ('VR_TO', p_vrent_num_to);
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6499: fnd_message.set_token ('DATE', p_period_date);
6500: pnp_debug_pkg.put_log_msg(fnd_message.get);
6501:
6502: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6503:
6496: fnd_message.set_token ('PRD_FRM', p_period_num_from);
6497: fnd_message.set_token ('PRD_TO', p_period_num_to);
6498: fnd_message.set_token ('USR', p_responsible_user);
6499: fnd_message.set_token ('DATE', p_period_date);
6500: pnp_debug_pkg.put_log_msg(fnd_message.get);
6501:
6502: pnp_debug_pkg.log ('process_rent_batch - Calculation TYPE : ' || p_calc_TYPE);
6503:
6504: IF p_property_code IS NOT NULL OR p_property_name IS NOT NULL THEN
6540:
6541: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6542: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6543:
6544: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6545: fnd_message.set_token ('NUM',l_rent_num);
6546: pnp_debug_pkg.put_log_msg(fnd_message.get);
6547:
6548: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6541: g_invoice_on := NVL(p_invoice_on,l_invoice_on);
6542: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6543:
6544: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6545: fnd_message.set_token ('NUM',l_rent_num);
6546: pnp_debug_pkg.put_log_msg(fnd_message.get);
6547:
6548: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6549: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6542: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
6543:
6544: fnd_message.set_name ('PN','PN_VRAM_VRN_PROC');
6545: fnd_message.set_token ('NUM',l_rent_num);
6546: pnp_debug_pkg.put_log_msg(fnd_message.get);
6547:
6548: pnp_debug_pkg.log ('process_rent_batch - Variable Rent id :'||l_var_rent_id);
6549: pnp_debug_pkg.log ('process_rent_batch - org_id :'||g_org_id);
6550:
6556:
6557: FOR rec_get_per in csr_get_per(l_var_rent_id)
6558: LOOP
6559:
6560: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6561: fnd_message.set_token ('NUM',rec_get_per.period_num);
6562: pnp_debug_pkg.put_log_msg(fnd_message.get);
6563:
6564: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6557: FOR rec_get_per in csr_get_per(l_var_rent_id)
6558: LOOP
6559:
6560: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6561: fnd_message.set_token ('NUM',rec_get_per.period_num);
6562: pnp_debug_pkg.put_log_msg(fnd_message.get);
6563:
6564: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6565: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6558: LOOP
6559:
6560: fnd_message.set_name ('PN','PN_VRAM_PRD_PROC');
6561: fnd_message.set_token ('NUM',rec_get_per.period_num);
6562: pnp_debug_pkg.put_log_msg(fnd_message.get);
6563:
6564: pnp_debug_pkg.log ('process_rent_batch - period st date : '||rec_get_per.start_date);
6565: pnp_debug_pkg.log ('process_rent_batch - period end date: '||rec_get_per.end_date);
6566: