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_ROWSET_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_ROWSET_PKG AS
2: /* $Header: PJIMTRSB.pls 120.1 2005/05/31 08:01:44 appldev $ */
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_rowset_pkg';
5: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6:
7: /*==================================================================
8: This api locks the row in pji_mt_rowset_b before updating
9: ==================================================================*/

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

94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96:
97: IF g_debug_mode = 'Y' THEN
98: pa_debug.set_curr_function( p_function => 'validate',
99: p_debug_mode => g_debug_mode );
100: END IF;
101:
102: IF g_debug_mode = 'Y' THEN

Line 103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_B '||X_Rowset_Code;

99: p_debug_mode => g_debug_mode );
100: END IF;
101:
102: IF g_debug_mode = 'Y' THEN
103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_B '||X_Rowset_Code;
104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
105: pa_fp_constants_pkg.g_debug_level3);
106: END IF;
107:

Line 104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,

100: END IF;
101:
102: IF g_debug_mode = 'Y' THEN
103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_B '||X_Rowset_Code;
104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
105: pa_fp_constants_pkg.g_debug_level3);
106: END IF;
107:
108: INSERT INTO pji_mt_rowset_B

Line 129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;

125: , X_Last_Update_Login
126: );
127:
128: IF g_debug_mode = 'Y' THEN
129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;
130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
131: END IF;
132:
133: INSERT INTO pji_mt_rowset_tl

Line 130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);

126: );
127:
128: IF g_debug_mode = 'Y' THEN
129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;
130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
131: END IF;
132:
133: INSERT INTO pji_mt_rowset_tl
134: (

Line 170: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Rowset_Code;

166: IF (C%NOTFOUND) THEN
167:
168: CLOSE C;
169: IF g_debug_mode = 'Y' THEN
170: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Rowset_Code;
171: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
172: END IF;
173: RAISE NO_DATA_FOUND;
174:

Line 171: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

167:
168: CLOSE C;
169: IF g_debug_mode = 'Y' THEN
170: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Rowset_Code;
171: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
172: END IF;
173: RAISE NO_DATA_FOUND;
174:
175: END IF;

Line 199: pa_debug.reset_curr_function;

195: x_msg_count := l_msg_count;
196: END IF;
197:
198: IF g_debug_mode = 'Y' THEN
199: pa_debug.reset_curr_function;
200: END IF;
201:
202: RETURN;
203:

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

212: ,p_procedure_name => 'Insert Row'
213: ,p_error_text => x_msg_data);
214:
215: IF g_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
217: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
218: pa_fp_constants_pkg.g_debug_level5);
219: pa_debug.reset_curr_function;
220: END IF;

Line 217: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,

213: ,p_error_text => x_msg_data);
214:
215: IF g_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
217: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
218: pa_fp_constants_pkg.g_debug_level5);
219: pa_debug.reset_curr_function;
220: END IF;
221:

Line 219: pa_debug.reset_curr_function;

215: IF g_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
217: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
218: pa_fp_constants_pkg.g_debug_level5);
219: pa_debug.reset_curr_function;
220: END IF;
221:
222: RAISE;
223:

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

252: x_msg_count := 0;
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: IF g_debug_mode = 'Y' THEN
256: pa_debug.set_curr_function( p_function => 'validate',
257: p_debug_mode => g_debug_mode );
258: END IF;
259:
260: IF g_debug_mode = 'Y' THEN

Line 261: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_b for'||X_Rowset_Code;

257: p_debug_mode => g_debug_mode );
258: END IF;
259:
260: IF g_debug_mode = 'Y' THEN
261: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_b for'||X_Rowset_Code;
262: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
263: END IF;
264:
265: -- The lock row procedure need not be called when the update_row is called

Line 262: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

258: END IF;
259:
260: IF g_debug_mode = 'Y' THEN
261: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_b for'||X_Rowset_Code;
262: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
263: END IF;
264:
265: -- The lock row procedure need not be called when the update_row is called
266: -- from the lct. It should be called when update row is called from the

Line 286: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_B '||X_Rowset_Code;

282: WHERE rowset_code = X_rowset_code;
283:
284: IF (SQL%NOTFOUND) THEN
285: IF g_debug_mode = 'Y' THEN
286: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_B '||X_Rowset_Code;
287: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
288: END IF;
289: RAISE NO_DATA_FOUND;
290: END IF;

Line 287: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

283:
284: IF (SQL%NOTFOUND) THEN
285: IF g_debug_mode = 'Y' THEN
286: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_B '||X_Rowset_Code;
287: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
288: END IF;
289: RAISE NO_DATA_FOUND;
290: END IF;
291:

Line 293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;

289: RAISE NO_DATA_FOUND;
290: END IF;
291:
292: IF g_debug_mode = 'Y' THEN
293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;
294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
295: END IF;
296:
297: UPDATE pji_mt_rowset_tl

Line 294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

290: END IF;
291:
292: IF g_debug_mode = 'Y' THEN
293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;
294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
295: END IF;
296:
297: UPDATE pji_mt_rowset_tl
298: SET Name = X_Name,

Line 309: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_T '||X_Rowset_Code;

305: AND USERENV('Lang') IN (LANGUAGE, Source_Lang);
306:
307: IF (SQL%NOTFOUND) THEN
308: IF g_debug_mode = 'Y' THEN
309: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_T '||X_Rowset_Code;
310: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
311: END IF;
312: RAISE NO_DATA_FOUND;
313: END IF;

Line 310: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

306:
307: IF (SQL%NOTFOUND) THEN
308: IF g_debug_mode = 'Y' THEN
309: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_T '||X_Rowset_Code;
310: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
311: END IF;
312: RAISE NO_DATA_FOUND;
313: END IF;
314:

Line 336: pa_debug.reset_curr_function;

332: x_msg_count := l_msg_count;
333: END IF;
334:
335: IF g_debug_mode = 'Y' THEN
336: pa_debug.reset_curr_function;
337: END IF;
338:
339: RAISE NO_DATA_FOUND;
340:

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

349: ,p_procedure_name => 'UPDATE_ROW'
350: ,p_error_text => x_msg_data);
351:
352: IF g_debug_mode = 'Y' THEN
353: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
354: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
355: pa_fp_constants_pkg.g_debug_level5);
356: pa_debug.reset_curr_function;
357: END IF;

Line 354: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,

350: ,p_error_text => x_msg_data);
351:
352: IF g_debug_mode = 'Y' THEN
353: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
354: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
355: pa_fp_constants_pkg.g_debug_level5);
356: pa_debug.reset_curr_function;
357: END IF;
358:

Line 356: pa_debug.reset_curr_function;

352: IF g_debug_mode = 'Y' THEN
353: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
354: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
355: pa_fp_constants_pkg.g_debug_level5);
356: pa_debug.reset_curr_function;
357: END IF;
358:
359: RAISE;
360: END Update_Row;

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

431: ,p_procedure_name => 'UPDATE_ROW'
432: ,p_error_text => l_msg_data);
433:
434: IF g_debug_mode = 'Y' THEN
435: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
436: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
437: pa_fp_constants_pkg.g_debug_level5);
438: pa_debug.reset_curr_function;
439: END IF;

Line 436: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,

432: ,p_error_text => l_msg_data);
433:
434: IF g_debug_mode = 'Y' THEN
435: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
436: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
437: pa_fp_constants_pkg.g_debug_level5);
438: pa_debug.reset_curr_function;
439: END IF;
440:

Line 438: pa_debug.reset_curr_function;

434: IF g_debug_mode = 'Y' THEN
435: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
436: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
437: pa_fp_constants_pkg.g_debug_level5);
438: pa_debug.reset_curr_function;
439: END IF;
440:
441: RAISE;
442: END Load_Row;