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

Line 87: pnp_debug_pkg.log

83: l_var_rent_id NUMBER;
84:
85: BEGIN
86:
87: pnp_debug_pkg.log
88: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');
90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );

Line 89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');

85: BEGIN
86:
87: pnp_debug_pkg.log
88: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');
90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );

Line 90: pnp_debug_pkg.log(' ');

86:
87: pnp_debug_pkg.log
88: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');
90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );

Line 91: pnp_debug_pkg.log('p_property_code '||p_property_code );

87: pnp_debug_pkg.log
88: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');
90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );

Line 92: pnp_debug_pkg.log('p_property_name '||p_property_name );

88: ('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');
90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );

Line 93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );

89: pnp_debug_pkg.log('+++++++++ vr_upgrade_batch_process START +++++++++++');
90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );
97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );

Line 94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );

90: pnp_debug_pkg.log(' ');
91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );
97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );
98: pnp_debug_pkg.log('p_vrent_num_to '||p_vrent_num_to );

Line 95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );

91: pnp_debug_pkg.log('p_property_code '||p_property_code );
92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );
97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );
98: pnp_debug_pkg.log('p_vrent_num_to '||p_vrent_num_to );
99:

Line 96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );

92: pnp_debug_pkg.log('p_property_name '||p_property_name );
93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );
97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );
98: pnp_debug_pkg.log('p_vrent_num_to '||p_vrent_num_to );
99:
100: IF p_property_code IS NOT NULL OR p_property_name IS NOT NULL THEN

Line 97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );

93: pnp_debug_pkg.log('p_lease_num_from '||p_lease_num_from );
94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );
97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );
98: pnp_debug_pkg.log('p_vrent_num_to '||p_vrent_num_to );
99:
100: IF p_property_code IS NOT NULL OR p_property_name IS NOT NULL THEN
101:

Line 98: pnp_debug_pkg.log('p_vrent_num_to '||p_vrent_num_to );

94: pnp_debug_pkg.log('p_lease_num_to '||p_lease_num_to );
95: pnp_debug_pkg.log('p_location_code_from'||p_location_code_from );
96: pnp_debug_pkg.log('p_location_code_to '||p_location_code_to );
97: pnp_debug_pkg.log('p_vrent_num_from '||p_vrent_num_from );
98: pnp_debug_pkg.log('p_vrent_num_to '||p_vrent_num_to );
99:
100: IF p_property_code IS NOT NULL OR p_property_name IS NOT NULL THEN
101:
102: FOR rec IN csr_get_vrent_wprop LOOP

Line 123: pnp_debug_pkg.log(' ++++++++++++++ vr_upgrade_batch_process - END

119: END LOOP;
120:
121: END IF;
122:
123: pnp_debug_pkg.log(' ++++++++++++++ vr_upgrade_batch_process - END
124: +++++++++++++');
125:
126: EXCEPTION
127:

Line 158: pnp_debug_pkg.log(' ++++++++++++++ process_vr_upgrade - START +++++++++++++');

154: WHERE var_rent_id = p_var_rent_id;
155:
156: BEGIN
157:
158: pnp_debug_pkg.log(' ++++++++++++++ process_vr_upgrade - START +++++++++++++');
159:
160: FOR rec IN csr_get_period LOOP
161:
162: UPDATE PN_VAR_VOL_HIST_ALL vol

Line 168: pnp_debug_pkg.log(' ++++++++++++++ process_vr_upgrade - END +++++++++++++');

164: WHERE period_id = rec.period_id;
165:
166: END LOOP;
167:
168: pnp_debug_pkg.log(' ++++++++++++++ process_vr_upgrade - END +++++++++++++');
169:
170: EXCEPTION
171:
172: WHEN OTHERS THEN