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

Line 141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );

137: l_rec_space_std_code pn_tenancies_all.recovery_space_std_code%type;
138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;
139:
140: BEGIN
141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );
142: pnp_debug_pkg.log('Parameters ' );
143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);

Line 142: pnp_debug_pkg.log('Parameters ' );

138: l_fin_oblig_end_date pn_tenancies_all.fin_oblig_end_date%type;
139:
140: BEGIN
141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );
142: pnp_debug_pkg.log('Parameters ' );
143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);

Line 143: pnp_debug_pkg.log('-------------------------------------------' );

139:
140: BEGIN
141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );
142: pnp_debug_pkg.log('Parameters ' );
143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);

Line 144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);

140: BEGIN
141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );
142: pnp_debug_pkg.log('Parameters ' );
143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);
148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);

Line 145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);

141: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (+)' );
142: pnp_debug_pkg.log('Parameters ' );
143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);
148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);
149: pnp_debug_pkg.log('Update Financial Obligation End Date : ' || p_upd_fin_oblg_end_dt);

Line 146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);

142: pnp_debug_pkg.log('Parameters ' );
143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);
148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);
149: pnp_debug_pkg.log('Update Financial Obligation End Date : ' || p_upd_fin_oblg_end_dt);
150:

Line 147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);

143: pnp_debug_pkg.log('-------------------------------------------' );
144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);
148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);
149: pnp_debug_pkg.log('Update Financial Obligation End Date : ' || p_upd_fin_oblg_end_dt);
150:
151: tenancy_id_tbl.delete;

Line 148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);

144: pnp_debug_pkg.log('Lease Num. From : ' || p_lease_num_from);
145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);
148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);
149: pnp_debug_pkg.log('Update Financial Obligation End Date : ' || p_upd_fin_oblg_end_dt);
150:
151: tenancy_id_tbl.delete;
152: cust_id_tbl.delete;

Line 149: pnp_debug_pkg.log('Update Financial Obligation End Date : ' || p_upd_fin_oblg_end_dt);

145: pnp_debug_pkg.log('Lease Num. To : ' || p_lease_num_to);
146: pnp_debug_pkg.log('Space Standard Code : ' || p_rec_space_std_code);
147: pnp_debug_pkg.log('Recovery Type Code : ' || p_rec_type_code);
148: pnp_debug_pkg.log('Update Customer : ' || p_upd_customer);
149: pnp_debug_pkg.log('Update Financial Obligation End Date : ' || p_upd_fin_oblg_end_dt);
150:
151: tenancy_id_tbl.delete;
152: cust_id_tbl.delete;
153: cust_site_use_id_tbl.delete;

Line 182: pnp_debug_pkg.log('Processed Bulk Collect. Nof records found: '||tenancy_id_tbl.COUNT);

178: location_id_tbl,
179: org_id_tbl;
180: CLOSE c_mass_tenancies;
181:
182: pnp_debug_pkg.log('Processed Bulk Collect. Nof records found: '||tenancy_id_tbl.COUNT);
183:
184: FOR i IN 1..tenancy_id_tbl.COUNT
185: LOOP
186: pnp_debug_pkg.log('Processing record# '||i||', Tenancy_id : '||tenancy_id_tbl(i)||

Line 186: pnp_debug_pkg.log('Processing record# '||i||', Tenancy_id : '||tenancy_id_tbl(i)||

182: pnp_debug_pkg.log('Processed Bulk Collect. Nof records found: '||tenancy_id_tbl.COUNT);
183:
184: FOR i IN 1..tenancy_id_tbl.COUNT
185: LOOP
186: pnp_debug_pkg.log('Processing record# '||i||', Tenancy_id : '||tenancy_id_tbl(i)||
187: ', Location_Id: '||location_id_tbl(i));
188: l_context := 'Looping through pl/sql tables';
189: l_cust_id := NULL;
190: l_cust_site_id := NULL;

Line 204: pnp_debug_pkg.log('Processed c_cust_info. Cust_id : '||l_cust_id);

200: OPEN c_cust_info(lease_id_tbl(i));
201: FETCH c_cust_info into l_cust_id, l_cust_site_id;
202: CLOSE c_cust_info;
203: END IF;
204: pnp_debug_pkg.log('Processed c_cust_info. Cust_id : '||l_cust_id);
205:
206: IF NVL(p_upd_fin_oblg_end_dt,'N')='Y' AND fin_oblig_end_date_tbl(i) IS NULL THEN
207: l_date := exp_date_tbl(i);
208: END IF;

Line 238: pnp_debug_pkg.log('Updated pn_tenancies.');

234: l_customer_site_id,
235: l_rec_type_code,
236: l_rec_space_std_code,
237: l_fin_oblig_end_date;
238: pnp_debug_pkg.log('Updated pn_tenancies.');
239:
240: IF l_customer_id IS NOT NULL AND
241: NOT(cust_space_assign_exists(tenancy_id_tbl(i))) THEN
242:

Line 290: pnp_debug_pkg.log('+------------------------------------------------------------+');

286:
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);

Line 291: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_SELECTED') ||' '||tenancy_id_tbl.COUNT);

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);

Line 292: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_LEASE_PROC') ||' '||l_total_count);

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);

Line 293: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_SPC_STD') ||' '||l_count_spc_std);

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 (-)' );

Line 294: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_RECOV_TYPE') ||' '||l_count_rec_type);

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:

Line 295: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_CUST') ||' '||l_count_cust);

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

Line 296: pnp_debug_pkg.put_log_msg(fnd_message.get_string('PN','PN_REC_UPG_NO_FIN_OBLIG_DT')||' '||l_count_fin_end_dt);

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

Line 297: pnp_debug_pkg.log('pn_recovery_tenancy_upg_pkg.tenancy_upgrade_batch (-)' );

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
301: raise_application_error ('-20001','Error ' || TO_CHAR(sqlcode) || '- while ' || l_context );