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.PNRX_RENT_LES dependencies on PNP_DEBUG_PKG

Line 214: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_where_cond_set(+)');

210: ppi.transferred_to_ar_flag = 'Y') ; -- Bug # 1671866
211:
212: BEGIN
213:
214: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_where_cond_set(+)');
215:
216: --Initialise status parameters...
217: retcode:=0;
218: errbuf:='';

Line 297: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_where_cond_set(-)');

293: lease_class_where_clause := 'AND les.lease_class_code = :l_lease_class';
294: ELSE lease_class_where_clause := ' AND 7=7 ';
295: END IF;
296:
297: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_where_cond_set(-)');
298: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_lease_pn(+)');
299:
300:
301: -- Adding to where clause in pn_locations in order to select

Line 298: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_lease_pn(+)');

294: ELSE lease_class_where_clause := ' AND 7=7 ';
295: END IF;
296:
297: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_where_cond_set(-)');
298: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_lease_pn(+)');
299:
300:
301: -- Adding to where clause in pn_locations in order to select
302: -- the location that is active

Line 383: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_lease_pn(-)');

379: ||lease_class_where_clause
380: ||'ORDER BY les.lease_class_code';
381:
382:
383: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_lease_pn(-)');
384:
385: dbms_sql.parse(l_cursor,l_statement,dbms_sql.native);
386:
387: --lease responsible user conditions....

Line 483: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(+)');

479: l_rows := dbms_sql.execute(l_cursor);
480:
481:
482:
483: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(+)');
484: LOOP --start lease loop....
485:
486: l_count := dbms_sql.fetch_rows( l_cursor );
487:

Line 529: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(+)');

525: dbms_sql.column_value (l_cursor,36,V_CREATION_DATE);
526: dbms_sql.column_value (l_cursor,37,V_CREATED_BY);
527: dbms_sql.column_value (l_cursor,38,V_PRORATION_RULE);
528:
529: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(+)');
530: OPEN c_loc_pn FOR
531: SELECT
532: distinct
533: loc.location_id LOCATION_ID,

Line 570: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(-)');

566: AND fnd1.lookup_code(+) = loc.location_type_lookup_code
567: AND fnd1.lookup_type(+) = 'PN_LOCATION_TYPE'
568: AND loc.location_id = V_LOCATION_ID_1;
569:
570: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(-)');
571: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(+)');
572: LOOP --start location loop
573: FETCH c_loc_pn INTO V_LOCATION_ID ,
574: V_ACTIVE_START_DATE ,

Line 571: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(+)');

567: AND fnd1.lookup_type(+) = 'PN_LOCATION_TYPE'
568: AND loc.location_id = V_LOCATION_ID_1;
569:
570: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_open_c_loc_pn(-)');
571: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(+)');
572: LOOP --start location loop
573: FETCH c_loc_pn INTO V_LOCATION_ID ,
574: V_ACTIVE_START_DATE ,
575: V_LOCATION_TYPE ,

Line 591: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_payment_term_loop(+)');

587: V_GROSS_AREA ,
588: V_TENURE ;
589: EXIT WHEN c_loc_pn%notfound;
590:
591: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_payment_term_loop(+)');
592:
593: --bug#2099864
594: /* This IF condition eliminates the need for the earlier existing 2 loops -
595: one for 'DIRECT' leases and the other for not 'DIRECT'.

Line 649: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_payment_term_loop(-)');

645: END LOOP; -- END Payment Term Loop
646:
647: END IF;
648:
649: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_payment_term_loop(-)');
650:
651: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(+)');
652:
653:

Line 651: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(+)');

647: END IF;
648:
649: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_payment_term_loop(-)');
650:
651: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(+)');
652:
653:
654: FOR w IN pitem(V_LEASE_ID)
655: LOOP

Line 727: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(-)');

723: V_ANNUAL_RENT_PER_RENT_AREA := NULL;
724: END IF;
725:
726: v_code_data :=pnp_util_func.get_location_name(V_LOCATION_ID, V_ACTIVE_START_DATE);
727: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(-)');
728: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(+)');
729:
730:
731: INSERT INTO pn_rent_roll_lease_exp_itf

Line 728: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(+)');

724: END IF;
725:
726: v_code_data :=pnp_util_func.get_location_name(V_LOCATION_ID, V_ACTIVE_START_DATE);
727: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_pop_vari(-)');
728: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(+)');
729:
730:
731: INSERT INTO pn_rent_roll_lease_exp_itf
732: (LEASE_ID ,

Line 870: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(-)');

866: V_CREATION_DATE ,
867: V_CREATED_BY ,
868: l_request_id );
869:
870: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(-)');
871: END LOOP; --END location loop...
872:
873: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(-)');
874: END LOOP; --END lease loop...

Line 873: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(-)');

869:
870: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_insert1(-)');
871: END LOOP; --END location loop...
872:
873: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(-)');
874: END LOOP; --END lease loop...
875: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(-)');
876:
877: IF dbms_sql.is_open (l_cursor) THEN

Line 875: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(-)');

871: END LOOP; --END location loop...
872:
873: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_loc_pn_loop(-)');
874: END LOOP; --END lease loop...
875: PNP_DEBUG_PKG.put_log_msg('pn_rentroll_c_lease_pn_loop(-)');
876:
877: IF dbms_sql.is_open (l_cursor) THEN
878: dbms_sql.close_cursor (l_cursor);
879: END IF;