287: END LOOP;
288:
289:
290: pnp_debug_pkg.log('+------------------------------------------------------------+');
291: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_SELECTED') ||' '||tenancy_id_tbl.COUNT);
292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);
293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);
294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);
295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);
288:
289:
290: pnp_debug_pkg.log('+------------------------------------------------------------+');
291: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_SELECTED') ||' '||tenancy_id_tbl.COUNT);
292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);
293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);
294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);
295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);
296: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_FIN_OBLIG_DT')||' '||l_count_fin_end_dt);
289:
290: pnp_debug_pkg.log('+------------------------------------------------------------+');
291: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_SELECTED') ||' '||tenancy_id_tbl.COUNT);
292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);
293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);
294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);
295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);
296: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_FIN_OBLIG_DT')||' '||l_count_fin_end_dt);
297: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (-)' );
290: pnp_debug_pkg.log('+------------------------------------------------------------+');
291: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_SELECTED') ||' '||tenancy_id_tbl.COUNT);
292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);
293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);
294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);
295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);
296: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_FIN_OBLIG_DT')||' '||l_count_fin_end_dt);
297: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (-)' );
298:
291: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_SELECTED') ||' '||tenancy_id_tbl.COUNT);
292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);
293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);
294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);
295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);
296: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_FIN_OBLIG_DT')||' '||l_count_fin_end_dt);
297: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (-)' );
298:
299: EXCEPTION
292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);
293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);
294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);
295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);
296: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_FIN_OBLIG_DT')||' '||l_count_fin_end_dt);
297: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (-)' );
298:
299: EXCEPTION
300: when others THEN