DBA Data[Home] [Help]

APPS.PA_FI_AMT_CALC_PKG dependencies on PA_FI_AMT_CALC_PKG

Line 1: PACKAGE BODY Pa_Fi_Amt_Calc_Pkg as

1: PACKAGE BODY Pa_Fi_Amt_Calc_Pkg as
2: /* $Header: PAFICALB.pls 120.5.12010000.3 2009/02/16 10:40:13 amehrotr ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 94: Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts

90: PA_DEBUG.g_err_stage := 'Inside Full or Incremental call or specific Org call';
91: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
92: END IF;
93:
94: Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts
95: (
96: errbuff => l_errbuff,
97: retcode => l_retcode,
98: p_run_mode => p_run_mode,

Line 119: Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts

115: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
116: END IF;
117:
118:
119: Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts
120: (
121: errbuff => l_errbuff,
122: retcode => l_retcode,
123: p_run_mode => p_run_mode,

Line 4253: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Start of populating TP Rate columns', 3);

4249: /* Bug 3051110 - Code added for populating two columns in pa_project_assignments table
4250: TP Enhancement */
4251:
4252: IF p_debug_mode = 'Y' THEN
4253: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Start of populating TP Rate columns', 3);
4254: END IF;
4255:
4256: /* The cursor Cur_Assignments will get all the assignment_ids processed in this particular request */
4257:

Line 4264: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Currently Populating for assignment_id :'||l_assignment_id, 3);

4260: FETCH Cur_Assignments INTO l_assignment_id;
4261: EXIT WHEN Cur_Assignments%NOTFOUND;
4262:
4263: IF p_debug_mode = 'Y' THEN
4264: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Currently Populating for assignment_id :'||l_assignment_id, 3);
4265: END IF;
4266:
4267: /*
4268: Getting the sum of projfunc_transfer_price and item_quantity from pa_forecast_items table for the assignment_id,

Line 4288: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);

4284: l_sum_item_quantity := Null;
4285: END;
4286:
4287: IF p_debug_mode = 'Y' THEN
4288: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);
4289: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);
4290: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);
4291: END IF;
4292:

Line 4289: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);

4285: END;
4286:
4287: IF p_debug_mode = 'Y' THEN
4288: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);
4289: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);
4290: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);
4291: END IF;
4292:
4293: IF l_sum_transfer_price is NULL OR l_sum_item_quantity is NULL OR l_sum_item_quantity = 0 THEN

Line 4290: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);

4286:
4287: IF p_debug_mode = 'Y' THEN
4288: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);
4289: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);
4290: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);
4291: END IF;
4292:
4293: IF l_sum_transfer_price is NULL OR l_sum_item_quantity is NULL OR l_sum_item_quantity = 0 THEN
4294: PA_ASSIGNMENTS_PVT.Update_Transfer_Price

Line 4366: END Pa_Fi_Amt_Calc_Pkg;

4362: PA_DEBUG.Reset_Curr_Function;
4363: END IF;
4364: RAISE;
4365: END;
4366: END Pa_Fi_Amt_Calc_Pkg;