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

Line 114: pa_debug.init_err_stack('PA_RATE_ATTR_PKG.Rate_Attr_Upgrd');

110: -- FND_MSG_PUB.initialize; /* bug 3800485 */
111:
112: x_msg_count := 0;
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: pa_debug.init_err_stack('PA_RATE_ATTR_PKG.Rate_Attr_Upgrd');
115: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
116: l_debug_mode := NVL(l_debug_mode, 'Y');
117: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
118: IF l_debug_mode = 'Y' THEN

Line 115: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

111:
112: x_msg_count := 0;
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: pa_debug.init_err_stack('PA_RATE_ATTR_PKG.Rate_Attr_Upgrd');
115: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
116: l_debug_mode := NVL(l_debug_mode, 'Y');
117: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
118: IF l_debug_mode = 'Y' THEN
119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';

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

113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: pa_debug.init_err_stack('PA_RATE_ATTR_PKG.Rate_Attr_Upgrd');
115: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
116: l_debug_mode := NVL(l_debug_mode, 'Y');
117: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
118: IF l_debug_mode = 'Y' THEN
119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
121:

Line 119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';

115: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
116: l_debug_mode := NVL(l_debug_mode, 'Y');
117: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
118: IF l_debug_mode = 'Y' THEN
119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
121:
122: pa_debug.g_err_stage := 'Checking for valid parameters';
123: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

116: l_debug_mode := NVL(l_debug_mode, 'Y');
117: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
118: IF l_debug_mode = 'Y' THEN
119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
121:
122: pa_debug.g_err_stage := 'Checking for valid parameters';
123: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
124: END IF;

Line 122: pa_debug.g_err_stage := 'Checking for valid parameters';

118: IF l_debug_mode = 'Y' THEN
119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
121:
122: pa_debug.g_err_stage := 'Checking for valid parameters';
123: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
124: END IF;
125:
126: if (p_budget_ver_tbl.count <= 0 ) then

Line 123: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

119: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
121:
122: pa_debug.g_err_stage := 'Checking for valid parameters';
123: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
124: END IF;
125:
126: if (p_budget_ver_tbl.count <= 0 ) then
127: IF l_debug_mode = 'Y' THEN

Line 128: pa_debug.g_err_stage := 'Budget Version='||to_char(l_budget_version_id);

124: END IF;
125:
126: if (p_budget_ver_tbl.count <= 0 ) then
127: IF l_debug_mode = 'Y' THEN
128: pa_debug.g_err_stage := 'Budget Version='||to_char(l_budget_version_id);
129: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
130: END IF;
131: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
132: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 129: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

125:
126: if (p_budget_ver_tbl.count <= 0 ) then
127: IF l_debug_mode = 'Y' THEN
128: pa_debug.g_err_stage := 'Budget Version='||to_char(l_budget_version_id);
129: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
130: END IF;
131: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
132: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
133: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 236: pa_debug.g_err_stage := 'Entering GET_RESOURCE_DEFAULTS API';

232: EXIT WHEN l_sys_rlm_ids_tbl.count=0;
233:
234: -- Call the following API for getting resource attributes. The first two paramteers are IN and the remaining are OUT parameters.
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage := 'Entering GET_RESOURCE_DEFAULTS API';
237: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
238: end if;
239:
240: if (l_sys_rlm_ids_tbl.count > 0) then

Line 237: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

233:
234: -- Call the following API for getting resource attributes. The first two paramteers are IN and the remaining are OUT parameters.
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage := 'Entering GET_RESOURCE_DEFAULTS API';
237: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
238: end if;
239:
240: if (l_sys_rlm_ids_tbl.count > 0) then
241: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults (

Line 288: pa_debug.g_err_stage := 'Exited GET_RESOURCE_DEFAULTS API';

284: end if;
285:
286:
287: IF l_debug_mode = 'Y' THEN
288: pa_debug.g_err_stage := 'Exited GET_RESOURCE_DEFAULTS API';
289: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
290: END IF;
291:
292: -- Check if the called API returns succes

Line 289: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

285:
286:
287: IF l_debug_mode = 'Y' THEN
288: pa_debug.g_err_stage := 'Exited GET_RESOURCE_DEFAULTS API';
289: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
290: END IF;
291:
292: -- Check if the called API returns succes
293: if (l_return_status = 'S') then

Line 296: pa_debug.g_err_stage := 'Updating pa_resource_assignments table';

292: -- Check if the called API returns succes
293: if (l_return_status = 'S') then
294:
295: IF l_debug_mode = 'Y' THEN
296: pa_debug.g_err_stage := 'Updating pa_resource_assignments table';
297: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
298: END IF;
299:
300:

Line 297: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

293: if (l_return_status = 'S') then
294:
295: IF l_debug_mode = 'Y' THEN
296: pa_debug.g_err_stage := 'Updating pa_resource_assignments table';
297: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
298: END IF;
299:
300:
301: FORALL j IN l_res_assign_id_tbl.FIRST..l_res_assign_id_tbl.LAST

Line 351: pa_debug.g_err_stage := 'Updating pa_resource_list_assignments table';

347: end loop; -- Resource List Assignment Cursor Loop ends here
348: CLOSE get_res_assign_id_csr;
349:
350: IF l_debug_mode = 'Y' THEN
351: pa_debug.g_err_stage := 'Updating pa_resource_list_assignments table';
352: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
353: END IF;
354:
355:

Line 352: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

348: CLOSE get_res_assign_id_csr;
349:
350: IF l_debug_mode = 'Y' THEN
351: pa_debug.g_err_stage := 'Updating pa_resource_list_assignments table';
352: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
353: END IF;
354:
355:
356: end loop;

Line 378: pa_debug.g_err_stage:='Invalid Arguments Passed';

374: x_msg_data := l_msg_data;
375: END IF;
376:
377: IF l_debug_mode = 'Y' THEN
378: pa_debug.g_err_stage:='Invalid Arguments Passed';
379: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
380: END IF;
381: x_return_status:= FND_API.G_RET_STS_ERROR;
382: pa_debug.write_file('RATE_ATTR_UPGRD: Upgrade has failed for the budget_version: '||l_budget_version_id,5);

Line 379: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

375: END IF;
376:
377: IF l_debug_mode = 'Y' THEN
378: pa_debug.g_err_stage:='Invalid Arguments Passed';
379: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
380: END IF;
381: x_return_status:= FND_API.G_RET_STS_ERROR;
382: pa_debug.write_file('RATE_ATTR_UPGRD: Upgrade has failed for the budget_version: '||l_budget_version_id,5);
383: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||x_msg_data,5);

Line 382: pa_debug.write_file('RATE_ATTR_UPGRD: Upgrade has failed for the budget_version: '||l_budget_version_id,5);

378: pa_debug.g_err_stage:='Invalid Arguments Passed';
379: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
380: END IF;
381: x_return_status:= FND_API.G_RET_STS_ERROR;
382: pa_debug.write_file('RATE_ATTR_UPGRD: Upgrade has failed for the budget_version: '||l_budget_version_id,5);
383: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||x_msg_data,5);
384: pa_debug.reset_err_stack;
385: -- ROLLBACK; /* Commented-out rollback to avoid issues the the UPG savepoint */
386: RAISE;

Line 383: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||x_msg_data,5);

379: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
380: END IF;
381: x_return_status:= FND_API.G_RET_STS_ERROR;
382: pa_debug.write_file('RATE_ATTR_UPGRD: Upgrade has failed for the budget_version: '||l_budget_version_id,5);
383: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||x_msg_data,5);
384: pa_debug.reset_err_stack;
385: -- ROLLBACK; /* Commented-out rollback to avoid issues the the UPG savepoint */
386: RAISE;
387: WHEN OTHERS THEN

Line 384: pa_debug.reset_err_stack;

380: END IF;
381: x_return_status:= FND_API.G_RET_STS_ERROR;
382: pa_debug.write_file('RATE_ATTR_UPGRD: Upgrade has failed for the budget_version: '||l_budget_version_id,5);
383: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||x_msg_data,5);
384: pa_debug.reset_err_stack;
385: -- ROLLBACK; /* Commented-out rollback to avoid issues the the UPG savepoint */
386: RAISE;
387: WHEN OTHERS THEN
388: if get_budget_ver_csr%ISOPEN then

Line 400: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

396: x_msg_data := SQLERRM;
397:
398: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_RATE_ATTR_PKG',p_procedure_name => 'RATE_ATTR_UPGRD');
399: IF l_debug_mode = 'Y' THEN
400: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
401: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
402: END IF;
403:
404: pa_debug.write_file('RATE_ATTR_UPGRD : Upgrade has failed for the budget version '||l_budget_version_id,5);

Line 401: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

397:
398: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_RATE_ATTR_PKG',p_procedure_name => 'RATE_ATTR_UPGRD');
399: IF l_debug_mode = 'Y' THEN
400: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
401: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
402: END IF;
403:
404: pa_debug.write_file('RATE_ATTR_UPGRD : Upgrade has failed for the budget version '||l_budget_version_id,5);
405: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||pa_debug.G_Err_Stack,5);

Line 404: pa_debug.write_file('RATE_ATTR_UPGRD : Upgrade has failed for the budget version '||l_budget_version_id,5);

400: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
401: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
402: END IF;
403:
404: pa_debug.write_file('RATE_ATTR_UPGRD : Upgrade has failed for the budget version '||l_budget_version_id,5);
405: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||pa_debug.G_Err_Stack,5);
406: pa_debug.reset_err_stack;
407: -- ROLLBACK; /* Commented-out rollback to avoid issues the the UPG savepoint */
408: RAISE;

Line 405: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||pa_debug.G_Err_Stack,5);

401: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
402: END IF;
403:
404: pa_debug.write_file('RATE_ATTR_UPGRD : Upgrade has failed for the budget version '||l_budget_version_id,5);
405: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||pa_debug.G_Err_Stack,5);
406: pa_debug.reset_err_stack;
407: -- ROLLBACK; /* Commented-out rollback to avoid issues the the UPG savepoint */
408: RAISE;
409: end RATE_ATTR_UPGRD;

Line 406: pa_debug.reset_err_stack;

402: END IF;
403:
404: pa_debug.write_file('RATE_ATTR_UPGRD : Upgrade has failed for the budget version '||l_budget_version_id,5);
405: pa_debug.write_file('RATE_ATTR_UPGRD: Failure Reason:'||pa_debug.G_Err_Stack,5);
406: pa_debug.reset_err_stack;
407: -- ROLLBACK; /* Commented-out rollback to avoid issues the the UPG savepoint */
408: RAISE;
409: end RATE_ATTR_UPGRD;
410: end PA_RATE_ATTR_PKG;