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

Line 79: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

75: l_count NUMBER;
76: BEGIN
77: x_msg_count := 0;
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
80: IF l_debug_mode = 'Y' THEN
81:
82: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');
83: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 82: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');

78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
80: IF l_debug_mode = 'Y' THEN
81:
82: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');
83: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
84:
85: END IF;
86:

Line 83: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

79: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
80: IF l_debug_mode = 'Y' THEN
81:
82: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK');
83: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
84:
85: END IF;
86:
87: IF l_debug_mode = 'Y' THEN

Line 88: pa_debug.g_err_stage := ':In PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK p_res_assignment_id_tbl.last = ' || p_res_assignment_id_tbl.last;

84:
85: END IF;
86:
87: IF l_debug_mode = 'Y' THEN
88: pa_debug.g_err_stage := ':In PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK p_res_assignment_id_tbl.last = ' || p_res_assignment_id_tbl.last;
89: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
90: END IF;
91:
92: IF nvl(p_res_assignment_id_tbl.LAST,0) > 0 THEN

Line 89: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

85: END IF;
86:
87: IF l_debug_mode = 'Y' THEN
88: pa_debug.g_err_stage := ':In PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_BULK p_res_assignment_id_tbl.last = ' || p_res_assignment_id_tbl.last;
89: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
90: END IF;
91:
92: IF nvl(p_res_assignment_id_tbl.LAST,0) > 0 THEN
93:

Line 231: pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;

227: );
228: END IF;
229: IF l_debug_mode = 'Y' THEN
230: l_count := sql%rowcount;
231: pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;
232: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
233: END IF;
234:
235: IF l_debug_mode = 'Y' THEN

Line 232: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

228: END IF;
229: IF l_debug_mode = 'Y' THEN
230: l_count := sql%rowcount;
231: pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;
232: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
233: END IF;
234:
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_BULK';

Line 236: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_BULK';

232: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
233: END IF;
234:
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_BULK';
237: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
238: pa_debug.reset_err_stack;
239: END IF;
240:

Line 237: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

233: END IF;
234:
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_BULK';
237: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
238: pa_debug.reset_err_stack;
239: END IF;
240:
241: EXCEPTION

Line 238: pa_debug.reset_err_stack;

234:
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_BULK';
237: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
238: pa_debug.reset_err_stack;
239: END IF;
240:
241: EXCEPTION
242: WHEN OTHERS THEN

Line 250: pa_debug.write('POPULATE_IN_BULK' || g_module_name,SQLERRM,4);

246: FND_MSG_PUB.add_exc_msg
247: ( p_pkg_name => 'PA_FP_WEBADI_PKG'
248: ,p_procedure_name => 'POPULATE_IN_BULK' );
249: IF l_debug_mode = 'Y' THEN
250: pa_debug.write('POPULATE_IN_BULK' || g_module_name,SQLERRM,4);
251: pa_debug.write('POPULATE_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
252: END IF;
253:
254: pa_debug.reset_err_stack;

Line 251: pa_debug.write('POPULATE_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);

247: ( p_pkg_name => 'PA_FP_WEBADI_PKG'
248: ,p_procedure_name => 'POPULATE_IN_BULK' );
249: IF l_debug_mode = 'Y' THEN
250: pa_debug.write('POPULATE_IN_BULK' || g_module_name,SQLERRM,4);
251: pa_debug.write('POPULATE_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
252: END IF;
253:
254: pa_debug.reset_err_stack;
255:

Line 254: pa_debug.reset_err_stack;

250: pa_debug.write('POPULATE_IN_BULK' || g_module_name,SQLERRM,4);
251: pa_debug.write('POPULATE_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
252: END IF;
253:
254: pa_debug.reset_err_stack;
255:
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
257:
258: END POPULATE_IN_BULK ;

Line 327: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

323: l_count NUMBER;
324: BEGIN
325: x_msg_count := 0;
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
328:
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');
331: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 330: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');

326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
328:
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');
331: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
332: END IF;
333:
334: IF l_debug_mode = 'Y' THEN

Line 331: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

327: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
328:
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.set_err_stack('PA_FP_ROLLUP_TMP_PKG.POPULATE_IN_MATRIX');
331: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
332: END IF;
333:
334: IF l_debug_mode = 'Y' THEN
335: pa_debug.g_err_stage:= 'in populate_in_matrix p_period_name_tbl.LAST = ' || p_period_name_tbl.LAST;

Line 335: pa_debug.g_err_stage:= 'in populate_in_matrix p_period_name_tbl.LAST = ' || p_period_name_tbl.LAST;

331: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
332: END IF;
333:
334: IF l_debug_mode = 'Y' THEN
335: pa_debug.g_err_stage:= 'in populate_in_matrix p_period_name_tbl.LAST = ' || p_period_name_tbl.LAST;
336: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
337: END IF;
338:
339: IF nvl(p_period_name_tbl.LAST,0) > 0 THEN

Line 336: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

332: END IF;
333:
334: IF l_debug_mode = 'Y' THEN
335: pa_debug.g_err_stage:= 'in populate_in_matrix p_period_name_tbl.LAST = ' || p_period_name_tbl.LAST;
336: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
337: END IF;
338:
339: IF nvl(p_period_name_tbl.LAST,0) > 0 THEN
340:

Line 458: pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;

454: WHERE p_start_date_tbl(i) is not null );
455: END IF;
456: IF l_debug_mode = 'Y' THEN
457: l_count := sql%rowcount;
458: pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;
459: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
460: END IF;
461:
462: IF l_debug_mode = 'Y' THEN

Line 459: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

455: END IF;
456: IF l_debug_mode = 'Y' THEN
457: l_count := sql%rowcount;
458: pa_debug.g_err_stage:= 'inserted records l_count = ' || l_count;
459: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
460: END IF;
461:
462: IF l_debug_mode = 'Y' THEN
463: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_MATRIX';

Line 463: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_MATRIX';

459: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
460: END IF;
461:
462: IF l_debug_mode = 'Y' THEN
463: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_MATRIX';
464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
465: pa_debug.reset_err_stack;
466: END IF;
467:

Line 464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

460: END IF;
461:
462: IF l_debug_mode = 'Y' THEN
463: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_MATRIX';
464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
465: pa_debug.reset_err_stack;
466: END IF;
467:
468: EXCEPTION

Line 465: pa_debug.reset_err_stack;

461:
462: IF l_debug_mode = 'Y' THEN
463: pa_debug.g_err_stage:= 'Exiting POPULATE_IN_MATRIX';
464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
465: pa_debug.reset_err_stack;
466: END IF;
467:
468: EXCEPTION
469: WHEN OTHERS THEN

Line 477: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,SQLERRM,4);

473: FND_MSG_PUB.add_exc_msg
474: ( p_pkg_name => 'PA_FP_ROLLUP_TMP_PKG'
475: ,p_procedure_name => 'POPULATE_IN_MATRIX' );
476: IF l_debug_mode = 'Y' THEN
477: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,SQLERRM,4);
478: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,pa_debug.G_Err_Stack,4);
479: END IF;
480: pa_debug.reset_err_stack;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 478: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,pa_debug.G_Err_Stack,4);

474: ( p_pkg_name => 'PA_FP_ROLLUP_TMP_PKG'
475: ,p_procedure_name => 'POPULATE_IN_MATRIX' );
476: IF l_debug_mode = 'Y' THEN
477: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,SQLERRM,4);
478: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,pa_debug.G_Err_Stack,4);
479: END IF;
480: pa_debug.reset_err_stack;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
482:

Line 480: pa_debug.reset_err_stack;

476: IF l_debug_mode = 'Y' THEN
477: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,SQLERRM,4);
478: pa_debug.write('POPULATE_IN_MATRIX' || g_module_name,pa_debug.G_Err_Stack,4);
479: END IF;
480: pa_debug.reset_err_stack;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
482:
483: END POPULATE_IN_MATRIX ;
484: END PA_FP_ROLLUP_TMP_PKG;