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_TRX_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: EXCEPTION
126:
127: WHEN OTHERS THEN

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

175: l_trx_id_tab trx_id_tab_type;
176:
177: BEGIN
178:
179: pnp_debug_pkg.log(' ++++++++++++++ process_vr_upgrade - START +++++++++++++');
180:
181: FOR var_rent_rec IN var_rent_cur
182: LOOP
183:

Line 184: pnp_debug_pkg.log('var rent id ....'||var_rent_rec.var_rent_id);

180:
181: FOR var_rent_rec IN var_rent_cur
182: LOOP
183:
184: pnp_debug_pkg.log('var rent id ....'||var_rent_rec.var_rent_id);
185: pnp_debug_pkg.log('invoice on ....'||var_rent_rec.invoice_on);
186:
187: l_summ_id_tab.DELETE;
188: l_trx_id_tab.DELETE;

Line 185: pnp_debug_pkg.log('invoice on ....'||var_rent_rec.invoice_on);

181: FOR var_rent_rec IN var_rent_cur
182: LOOP
183:
184: pnp_debug_pkg.log('var rent id ....'||var_rent_rec.var_rent_id);
185: pnp_debug_pkg.log('invoice on ....'||var_rent_rec.invoice_on);
186:
187: l_summ_id_tab.DELETE;
188: l_trx_id_tab.DELETE;
189:

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

214: WHERE trx_header_id = l_trx_id_tab(i);
215:
216: END LOOP;
217:
218: pnp_debug_pkg.log(' ++++++++++++++ process_vr_upgrade - END +++++++++++++');
219: EXCEPTION
220:
221: WHEN OTHERS THEN
222: raise_application_error ('-20001','Error ' || to_char(sqlcode)||' error message '||SQLERRM);