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.4.12000000.3 2007/03/22 06:19:37 kvuyyuru 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 4229: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Start of populating TP Rate columns', 3);

4225: /* Bug 3051110 - Code added for populating two columns in pa_project_assignments table
4226: TP Enhancement */
4227:
4228: IF p_debug_mode = 'Y' THEN
4229: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Start of populating TP Rate columns', 3);
4230: END IF;
4231:
4232: /* The cursor Cur_Assignments will get all the assignment_ids processed in this particular request */
4233:

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

4236: FETCH Cur_Assignments INTO l_assignment_id;
4237: EXIT WHEN Cur_Assignments%NOTFOUND;
4238:
4239: IF p_debug_mode = 'Y' THEN
4240: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Currently Populating for assignment_id :'||l_assignment_id, 3);
4241: END IF;
4242:
4243: /*
4244: Getting the sum of projfunc_transfer_price and item_quantity from pa_forecast_items table for the assignment_id,

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

4260: l_sum_item_quantity := Null;
4261: END;
4262:
4263: IF p_debug_mode = 'Y' THEN
4264: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);
4265: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);
4266: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);
4267: END IF;
4268:

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

4261: END;
4262:
4263: IF p_debug_mode = 'Y' THEN
4264: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);
4265: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);
4266: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);
4267: END IF;
4268:
4269: IF l_sum_transfer_price is NULL OR l_sum_item_quantity is NULL OR l_sum_item_quantity = 0 THEN

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

4262:
4263: IF p_debug_mode = 'Y' THEN
4264: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'TP rate for assignment:'||l_sum_transfer_price, 3);
4265: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Item Quantity for assignment:'||l_sum_item_quantity, 3);
4266: pa_debug.write('Pa_Fi_Amt_Calc_Pkg.Calculate_Fcst_Amounts', 'Proj Func Curency:'||l_prjfunc_curr_code, 3);
4267: END IF;
4268:
4269: IF l_sum_transfer_price is NULL OR l_sum_item_quantity is NULL OR l_sum_item_quantity = 0 THEN
4270: PA_ASSIGNMENTS_PVT.Update_Transfer_Price

Line 4341: END Pa_Fi_Amt_Calc_Pkg;

4337: PA_DEBUG.Reset_Curr_Function;
4338: END IF;
4339: RAISE;
4340: END;
4341: END Pa_Fi_Amt_Calc_Pkg;