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_MEASURE_SETS_PKG dependencies on PA_DEBUG

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

1: PACKAGE BODY Pji_Mt_Measure_Sets_Pkg AS
2: /* $Header: PJIMTMSB.pls 120.1 2005/05/31 08:01:25 appldev $ */
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_measure_sets_pkg';
5: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
6:
7:
8: /*==================================================================
9: This api locks the row in pji_mt_measure_sets_b before updating

Line 103: Pa_Debug.set_curr_function( p_function => 'validate',

99: x_msg_count := 0;
100: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
101:
102: IF g_debug_mode = 'Y' THEN
103: Pa_Debug.set_curr_function( p_function => 'validate',
104: p_debug_mode => g_debug_mode );
105: END IF;
106:
107: IF g_debug_mode = 'Y' THEN

Line 108: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;

104: p_debug_mode => g_debug_mode );
105: END IF;
106:
107: IF g_debug_mode = 'Y' THEN
108: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;
109: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
110: Pa_Fp_Constants_Pkg.g_debug_level3);
111: END IF;
112:

Line 109: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

105: END IF;
106:
107: IF g_debug_mode = 'Y' THEN
108: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;
109: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
110: Pa_Fp_Constants_Pkg.g_debug_level3);
111: END IF;
112:
113: INSERT INTO pji_mt_measure_sets_B

Line 144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;

140: , X_Measure_Source
141: );
142:
143: IF g_debug_mode = 'Y' THEN
144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;
145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);
146: END IF;
147:
148: INSERT INTO pji_mt_measure_sets_tl

Line 145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);

141: );
142:
143: IF g_debug_mode = 'Y' THEN
144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;
145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);
146: END IF;
147:
148: INSERT INTO pji_mt_measure_sets_tl
149: (

Line 189: Pa_Debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Measure_Set_Code;

185:
186: CLOSE C;
187:
188: IF g_debug_mode = 'Y' THEN
189: Pa_Debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Measure_Set_Code;
190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
191: END IF;
192:
193: RAISE NO_DATA_FOUND;

Line 190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

186: CLOSE C;
187:
188: IF g_debug_mode = 'Y' THEN
189: Pa_Debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Measure_Set_Code;
190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
191: END IF;
192:
193: RAISE NO_DATA_FOUND;
194:

Line 219: Pa_Debug.reset_curr_function;

215: x_msg_count := l_msg_count;
216: END IF;
217:
218: IF g_debug_mode = 'Y' THEN
219: Pa_Debug.reset_curr_function;
220: END IF;
221:
222: RETURN;
223:

Line 236: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

232: ,p_procedure_name => 'Insert Row'
233: ,p_error_text => x_msg_data);
234:
235: IF g_debug_mode = 'Y' THEN
236: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
237: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
238: Pa_Fp_Constants_Pkg.g_debug_level5);
239: Pa_Debug.reset_curr_function;
240: END IF;

Line 237: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

233: ,p_error_text => x_msg_data);
234:
235: IF g_debug_mode = 'Y' THEN
236: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
237: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
238: Pa_Fp_Constants_Pkg.g_debug_level5);
239: Pa_Debug.reset_curr_function;
240: END IF;
241:

Line 239: Pa_Debug.reset_curr_function;

235: IF g_debug_mode = 'Y' THEN
236: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
237: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
238: Pa_Fp_Constants_Pkg.g_debug_level5);
239: Pa_Debug.reset_curr_function;
240: END IF;
241:
242: RAISE;
243:

Line 278: Pa_Debug.set_curr_function( p_function => 'validate',

274: x_msg_count := 0;
275: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
276:
277: IF g_debug_mode = 'Y' THEN
278: Pa_Debug.set_curr_function( p_function => 'validate',
279: p_debug_mode => g_debug_mode );
280: END IF;
281:
282: IF g_debug_mode = 'Y' THEN

Line 283: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_b for '||X_measure_set_code;

279: p_debug_mode => g_debug_mode );
280: END IF;
281:
282: IF g_debug_mode = 'Y' THEN
283: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_b for '||X_measure_set_code;
284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
285: END IF;
286:
287: BEGIN

Line 284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);

280: END IF;
281:
282: IF g_debug_mode = 'Y' THEN
283: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_b for '||X_measure_set_code;
284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
285: END IF;
286:
287: BEGIN
288: SELECT object_version_number

Line 295: Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;

291: WHERE measure_set_code = X_measure_set_code FOR UPDATE;
292: EXCEPTION
293: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
294: IF g_debug_mode = 'Y' THEN
295: Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;
296: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
297: END IF;
298: RAISE;
299: END;

Line 296: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

292: EXCEPTION
293: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
294: IF g_debug_mode = 'Y' THEN
295: Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;
296: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
297: END IF;
298: RAISE;
299: END;
300:

Line 327: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_B '||X_measure_set_code;

323: WHERE measure_set_code = X_measure_set_code;
324:
325: IF (SQL%NOTFOUND) THEN
326: IF g_debug_mode = 'Y' THEN
327: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_B '||X_measure_set_code;
328: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
329: END IF;
330:
331: RAISE NO_DATA_FOUND;

Line 328: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

324:
325: IF (SQL%NOTFOUND) THEN
326: IF g_debug_mode = 'Y' THEN
327: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_B '||X_measure_set_code;
328: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
329: END IF;
330:
331: RAISE NO_DATA_FOUND;
332: END IF;

Line 335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;

331: RAISE NO_DATA_FOUND;
332: END IF;
333:
334: IF g_debug_mode = 'Y' THEN
335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;
336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
337: END IF;
338:
339: UPDATE pji_mt_measure_sets_tl

Line 336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);

332: END IF;
333:
334: IF g_debug_mode = 'Y' THEN
335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;
336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
337: END IF;
338:
339: UPDATE pji_mt_measure_sets_tl
340: SET Name = X_Name,

Line 351: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_T '||X_measure_set_code;

347: AND USERENV('Lang') IN (LANGUAGE, Source_Lang);
348:
349: IF (SQL%NOTFOUND) THEN
350: IF g_debug_mode = 'Y' THEN
351: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_T '||X_measure_set_code;
352: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
353: END IF;
354:
355: RAISE NO_DATA_FOUND;

Line 352: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

348:
349: IF (SQL%NOTFOUND) THEN
350: IF g_debug_mode = 'Y' THEN
351: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_T '||X_measure_set_code;
352: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
353: END IF;
354:
355: RAISE NO_DATA_FOUND;
356: END IF;

Line 379: Pa_Debug.reset_curr_function;

375: x_msg_count := l_msg_count;
376: END IF;
377:
378: IF g_debug_mode = 'Y' THEN
379: Pa_Debug.reset_curr_function;
380: END IF;
381:
382: RAISE NO_DATA_FOUND;
383:

Line 396: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

392: ,p_procedure_name => 'UPDATE_ROW'
393: ,p_error_text => x_msg_data);
394:
395: IF g_debug_mode = 'Y' THEN
396: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
397: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
398: Pa_Fp_Constants_Pkg.g_debug_level5);
399: Pa_Debug.reset_curr_function;
400: END IF;

Line 397: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

393: ,p_error_text => x_msg_data);
394:
395: IF g_debug_mode = 'Y' THEN
396: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
397: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
398: Pa_Fp_Constants_Pkg.g_debug_level5);
399: Pa_Debug.reset_curr_function;
400: END IF;
401:

Line 399: Pa_Debug.reset_curr_function;

395: IF g_debug_mode = 'Y' THEN
396: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
397: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
398: Pa_Fp_Constants_Pkg.g_debug_level5);
399: Pa_Debug.reset_curr_function;
400: END IF;
401:
402:
403: RAISE;

Line 490: Pa_Debug.g_err_stage:= 'Unexpected Error'||l_msg_data;

486: ,p_procedure_name => 'UPDATE_ROW'
487: ,p_error_text => l_msg_data);
488:
489: IF g_debug_mode = 'Y' THEN
490: Pa_Debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
491: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
492: Pa_Fp_Constants_Pkg.g_debug_level5);
493: Pa_Debug.reset_curr_function;
494: END IF;

Line 491: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

487: ,p_error_text => l_msg_data);
488:
489: IF g_debug_mode = 'Y' THEN
490: Pa_Debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
491: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
492: Pa_Fp_Constants_Pkg.g_debug_level5);
493: Pa_Debug.reset_curr_function;
494: END IF;
495:

Line 493: Pa_Debug.reset_curr_function;

489: IF g_debug_mode = 'Y' THEN
490: Pa_Debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
491: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
492: Pa_Fp_Constants_Pkg.g_debug_level5);
493: Pa_Debug.reset_curr_function;
494: END IF;
495:
496:
497: RAISE;