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.PJI_MT_MEASURES_PKG dependencies on PA_DEBUG

Line 9: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5: -- -----------------------------------------------------------------------
6: -- -----------------------------------------------------------------------
7:
8: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_measures_pkg';
9: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10:
11: -- -----------------------------------------------------------------------
12: -- This api locks the row in Pji_Mt_Measures_B before updating
13: -- -----------------------------------------------------------------------

Line 123: pa_debug.set_curr_function( p_function => 'validate',

119: x_msg_count := 0;
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: IF g_debug_mode = 'Y' THEN
123: pa_debug.set_curr_function( p_function => 'validate',
124: p_debug_mode => g_debug_mode );
125: END IF;
126:
127: select nvl(X_MEASURE_ID,PJI_MT_MEASURES_S.nextval)

Line 132: pa_debug.g_err_stage:= 'Inserting record in pji_mt_measures_b'||to_char(l_measure_id);

128: into l_measure_id
129: from dual;
130:
131: IF g_debug_mode = 'Y' THEN
132: pa_debug.g_err_stage:= 'Inserting record in pji_mt_measures_b'||to_char(l_measure_id);
133: pa_debug.write(g_module_name,pa_debug.g_err_stage,
134: pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:

Line 133: pa_debug.write(g_module_name,pa_debug.g_err_stage,

129: from dual;
130:
131: IF g_debug_mode = 'Y' THEN
132: pa_debug.g_err_stage:= 'Inserting record in pji_mt_measures_b'||to_char(l_measure_id);
133: pa_debug.write(g_module_name,pa_debug.g_err_stage,
134: pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:
137: INSERT INTO Pji_Mt_Measures_B

Line 170: pa_debug.g_err_stage:= 'Inserting record in pji_mt_Measures_tl'||to_char(l_measure_id);

166: );
167:
168:
169: IF g_debug_mode = 'Y' THEN
170: pa_debug.g_err_stage:= 'Inserting record in pji_mt_Measures_tl'||to_char(l_measure_id);
171: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
172:
173: END IF;
174:

Line 171: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);

167:
168:
169: IF g_debug_mode = 'Y' THEN
170: pa_debug.g_err_stage:= 'Inserting record in pji_mt_Measures_tl'||to_char(l_measure_id);
171: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
172:
173: END IF;
174:
175: INSERT INTO pji_mt_measures_tl

Line 219: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for'||to_char(l_measure_id);

215: IF (C%NOTFOUND) THEN
216:
217: CLOSE C;
218: IF g_debug_mode = 'Y' THEN
219: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for'||to_char(l_measure_id);
220: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
221: END IF;
222: RAISE NO_DATA_FOUND;
223:

Line 220: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

216:
217: CLOSE C;
218: IF g_debug_mode = 'Y' THEN
219: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for'||to_char(l_measure_id);
220: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
221: END IF;
222: RAISE NO_DATA_FOUND;
223:
224: END IF;

Line 248: pa_debug.reset_curr_function;

244: x_msg_count := l_msg_count;
245: END IF;
246:
247: IF g_debug_mode = 'Y' THEN
248: pa_debug.reset_curr_function;
249: END IF;
250:
251: RETURN;
252:

Line 265: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

261: ,p_procedure_name => 'Insert Row'
262: ,p_error_text => x_msg_data);
263:
264: IF g_debug_mode = 'Y' THEN
265: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
266: pa_debug.write(g_module_name,pa_debug.g_err_stage,
267: pa_fp_constants_pkg.g_debug_level5);
268: pa_debug.reset_curr_function;
269: END IF;

Line 266: pa_debug.write(g_module_name,pa_debug.g_err_stage,

262: ,p_error_text => x_msg_data);
263:
264: IF g_debug_mode = 'Y' THEN
265: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
266: pa_debug.write(g_module_name,pa_debug.g_err_stage,
267: pa_fp_constants_pkg.g_debug_level5);
268: pa_debug.reset_curr_function;
269: END IF;
270:

Line 268: pa_debug.reset_curr_function;

264: IF g_debug_mode = 'Y' THEN
265: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
266: pa_debug.write(g_module_name,pa_debug.g_err_stage,
267: pa_fp_constants_pkg.g_debug_level5);
268: pa_debug.reset_curr_function;
269: END IF;
270:
271: RAISE;
272:

Line 314: pa_debug.set_curr_function( p_function => 'validate',

310: x_msg_count := 0;
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: IF g_debug_mode = 'Y' THEN
314: pa_debug.set_curr_function( p_function => 'validate',
315: p_debug_mode => g_debug_mode );
316: END IF;
317:
318: IF g_debug_mode = 'Y' THEN

Line 319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);

315: p_debug_mode => g_debug_mode );
316: END IF;
317:
318: IF g_debug_mode = 'Y' THEN
319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);
320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
321: END IF;
322:
323: UPDATE Pji_Mt_Measures_B

Line 320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

316: END IF;
317:
318: IF g_debug_mode = 'Y' THEN
319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);
320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
321: END IF;
322:
323: UPDATE Pji_Mt_Measures_B
324: SET

Line 336: pa_debug.g_err_stage:= 'NDF while updating Pji_Mt_Measures_B'||to_char(X_measure_id);

332: where Measure_Id = X_Measure_Id;
333:
334: IF (SQL%NOTFOUND) THEN
335: IF g_debug_mode = 'Y' THEN
336: pa_debug.g_err_stage:= 'NDF while updating Pji_Mt_Measures_B'||to_char(X_measure_id);
337: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
338: END IF;
339: RAISE NO_DATA_FOUND;
340: END IF;

Line 337: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

333:
334: IF (SQL%NOTFOUND) THEN
335: IF g_debug_mode = 'Y' THEN
336: pa_debug.g_err_stage:= 'NDF while updating Pji_Mt_Measures_B'||to_char(X_measure_id);
337: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
338: END IF;
339: RAISE NO_DATA_FOUND;
340: END IF;
341:

Line 343: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_Tl for'||to_char(X_measure_id);

339: RAISE NO_DATA_FOUND;
340: END IF;
341:
342: IF g_debug_mode = 'Y' THEN
343: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_Tl for'||to_char(X_measure_id);
344: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
345: END IF;
346:
347: UPDATE Pji_Mt_Measures_Tl

Line 344: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

340: END IF;
341:
342: IF g_debug_mode = 'Y' THEN
343: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_Tl for'||to_char(X_measure_id);
344: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
345: END IF;
346:
347: UPDATE Pji_Mt_Measures_Tl
348: SET

Line 360: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_T'||to_char(X_measure_id);

356: AND Userenv('Lang') In (Language, Source_Lang);
357:
358: IF (SQL%NOTFOUND) THEN
359: IF g_debug_mode = 'Y' THEN
360: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_T'||to_char(X_measure_id);
361: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
362: END IF;
363: RAISE NO_DATA_FOUND;
364: END IF;

Line 361: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

357:
358: IF (SQL%NOTFOUND) THEN
359: IF g_debug_mode = 'Y' THEN
360: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_T'||to_char(X_measure_id);
361: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
362: END IF;
363: RAISE NO_DATA_FOUND;
364: END IF;
365:

Line 387: pa_debug.reset_curr_function;

383: x_msg_count := l_msg_count;
384: END IF;
385:
386: IF g_debug_mode = 'Y' THEN
387: pa_debug.reset_curr_function;
388: END IF;
389:
390: RAISE NO_DATA_FOUND;
391:

Line 404: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

400: ,p_procedure_name => 'UPDATE_ROW'
401: ,p_error_text => x_msg_data);
402:
403: IF g_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
405: pa_debug.write(g_module_name,pa_debug.g_err_stage,
406: pa_fp_constants_pkg.g_debug_level5);
407: pa_debug.reset_curr_function;
408: END IF;

Line 405: pa_debug.write(g_module_name,pa_debug.g_err_stage,

401: ,p_error_text => x_msg_data);
402:
403: IF g_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
405: pa_debug.write(g_module_name,pa_debug.g_err_stage,
406: pa_fp_constants_pkg.g_debug_level5);
407: pa_debug.reset_curr_function;
408: END IF;
409:

Line 407: pa_debug.reset_curr_function;

403: IF g_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
405: pa_debug.write(g_module_name,pa_debug.g_err_stage,
406: pa_fp_constants_pkg.g_debug_level5);
407: pa_debug.reset_curr_function;
408: END IF;
409:
410: RAISE;
411:

Line 518: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;

514: ,p_procedure_name => 'UPDATE_ROW'
515: ,p_error_text => l_msg_data);
516:
517: IF g_debug_mode = 'Y' THEN
518: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
519: pa_debug.write(g_module_name,pa_debug.g_err_stage,
520: pa_fp_constants_pkg.g_debug_level5);
521: pa_debug.reset_curr_function;
522: END IF;

Line 519: pa_debug.write(g_module_name,pa_debug.g_err_stage,

515: ,p_error_text => l_msg_data);
516:
517: IF g_debug_mode = 'Y' THEN
518: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
519: pa_debug.write(g_module_name,pa_debug.g_err_stage,
520: pa_fp_constants_pkg.g_debug_level5);
521: pa_debug.reset_curr_function;
522: END IF;
523:

Line 521: pa_debug.reset_curr_function;

517: IF g_debug_mode = 'Y' THEN
518: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
519: pa_debug.write(g_module_name,pa_debug.g_err_stage,
520: pa_fp_constants_pkg.g_debug_level5);
521: pa_debug.reset_curr_function;
522: END IF;
523:
524: RAISE;
525: