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_FP_CONSTANTS_PKG

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 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 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 133: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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;
134: end if;
135:
136: l_sys_rlm_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
137: l_resource_class_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

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 281: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

277: x_msg_count => l_msg_count,
278: x_return_status => l_return_status);
279:
280: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
281: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
282: END IF;
283:
284: end if;
285:

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 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 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 360: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc then

356: end loop;
357: -- Budget Version Cursor loop ends here.
358: end loop; -- parameter table loop
359: EXCEPTION
360: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc then
361: l_msg_count := FND_MSG_PUB.count_msg;
362: IF l_msg_count = 1 THEN
363: PA_INTERFACE_UTILS_PUB.get_messages
364: (p_encoded => FND_API.G_TRUE

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 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);