APPS.PA_RATE_ATTR_PKG dependencies on PA_RATE_ATTR_PKG

Line 1: package body PA_RATE_ATTR_PKG AS

1: package body PA_RATE_ATTR_PKG AS
2: /* $Header: PARATTRB.pls 120.4 2007/02/06 09:46:22 dthakker noship $ */
3: procedure RATE_ATTR_UPGRD(
4: P_BUDGET_VER_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
5: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 101: l_module_name VARCHAR2(100):= 'pa.plsql.PA_RATE_ATTR_PKG';

97: l_budget_version_id pa_budget_versions.budget_version_id%type;
98:
99:
100: l_debug_mode varchar2(30);
101: l_module_name VARCHAR2(100):= 'pa.plsql.PA_RATE_ATTR_PKG';
102: l_msg_index_out NUMBER;
103: l_data VARCHAR2(2000);
104:
105: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE; -- Bug 3988345

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 398: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_RATE_ATTR_PKG',p_procedure_name => 'RATE_ATTR_UPGRD');

394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: x_msg_count := 1;
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;

Line 410: end PA_RATE_ATTR_PKG;

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;