DBA Data[Home] [Help]

APPS.PA_PLAN_MATRIX dependencies on PA_PLAN_MATRIX

Line 1: PACKAGE BODY Pa_Plan_Matrix AS

1: PACKAGE BODY Pa_Plan_Matrix AS
2: /* $Header: PARPLMXB.pls 120.2 2005/09/27 12:41:29 rnamburi noship $ */
3:
4: -- Bug Fix: 4569365. Removed MRC code.
5: -- g_mrc_exception EXCEPTION; /* FPB2 */

Line 116: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'

112: RETURN;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN
115: FND_MSG_PUB.add_exc_msg
116: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
117: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
118: IF P_PA_DEBUG_MODE = 'Y' THEN
119: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
120: 'start date, end date and period name from GL_periods for PD-GL';

Line 160: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'

156: RETURN;
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: FND_MSG_PUB.add_exc_msg
160: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
161: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
162: IF P_PA_DEBUG_MODE = 'Y' THEN
163: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
164: 'start date, end date and period name from GL_periods for PD-PA';

Line 202: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'

198: RETURN;
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: FND_MSG_PUB.add_exc_msg
202: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
203: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
204: IF P_PA_DEBUG_MODE = 'Y' THEN
205: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
206: 'start date, end date and period name from GL_periods for SD-GL';

Line 240: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'

236: RETURN;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: FND_MSG_PUB.add_exc_msg
240: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
241: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
242: IF P_PA_DEBUG_MODE = 'Y' THEN
243: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
244: 'start date, end date and period name from GL_periods for SD-PA';

Line 257: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'

253: END IF;
254: EXCEPTION
255: WHEN OTHERS THEN
256: FND_MSG_PUB.add_exc_msg
257: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
258: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
259: IF P_PA_DEBUG_MODE = 'Y' THEN
260: PA_DEBUG.g_err_stage := 'Unexpected error in Get_Period_Info ';
261: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 678: ( p_pkg_name => 'PA_PLAN_MATRIX.Populate_Budget_Lines'

674: END IF;
675: EXCEPTION
676: WHEN OTHERS THEN
677: FND_MSG_PUB.add_exc_msg
678: ( p_pkg_name => 'PA_PLAN_MATRIX.Populate_Budget_Lines'
679: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
680: IF P_PA_DEBUG_MODE = 'Y' THEN
681: PA_DEBUG.g_err_stage := 'EXCEPTION while trying to insert ' ||
682: 'PD data in budget lines table';

Line 978: ( p_pkg_name => 'PA_PLAN_MATRIX.Populate_Budget_Lines'

974: END IF;
975: EXCEPTION
976: WHEN OTHERS THEN
977: FND_MSG_PUB.add_exc_msg
978: ( p_pkg_name => 'PA_PLAN_MATRIX.Populate_Budget_Lines'
979: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
980: IF P_PA_DEBUG_MODE = 'Y' THEN
981: PA_DEBUG.g_err_stage := 'Exception while trying to insert ' ||
982: 'SD data in budget lines table';

Line 1008: ( p_pkg_name => 'PA_PLAN_MATRIX.Populate_Budget_Lines'

1004: END LOOP;
1005: EXCEPTION
1006: WHEN OTHERS THEN
1007: FND_MSG_PUB.add_exc_msg
1008: ( p_pkg_name => 'PA_PLAN_MATRIX.Populate_Budget_Lines'
1009: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
1010: IF P_PA_DEBUG_MODE = 'Y' THEN
1011: PA_DEBUG.g_err_stage := 'Unexpected error in Populate_Budget_Lines ';
1012: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1020: p_amount_type_tab IN pa_plan_matrix.amount_type_tabtyp,

1016: RAISE;
1017: END Populate_Budget_Lines;
1018:
1019: PROCEDURE Maintain_Plan_Matrix(
1020: p_amount_type_tab IN pa_plan_matrix.amount_type_tabtyp,
1021: p_period_profile_id IN NUMBER,
1022: p_prior_period_flag IN VARCHAR2,
1023: p_commit_flag IN VARCHAR2,
1024: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3701: ( p_pkg_name => 'PA_PLAN_MATRIX.maintain_plan_matrix'

3697: /* End if for the IF in zero row counts in update */
3698: EXCEPTION
3699: WHEN OTHERS THEN
3700: FND_MSG_PUB.add_exc_msg
3701: ( p_pkg_name => 'PA_PLAN_MATRIX.maintain_plan_matrix'
3702: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3703: IF P_PA_DEBUG_MODE = 'Y' THEN
3704: PA_DEBUG.g_err_stage := 'Exception while trying to insert ' ||
3705: 'data in proj denorm table';

Line 3900: ( p_pkg_name => 'PA_PLAN_MATRIX.maintain_plan_matrix'

3896: RETURN;
3897: EXCEPTION
3898: WHEN OTHERS THEN
3899: FND_MSG_PUB.add_exc_msg
3900: ( p_pkg_name => 'PA_PLAN_MATRIX.maintain_plan_matrix'
3901: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3902: IF P_PA_DEBUG_MODE = 'Y' THEN
3903: PA_DEBUG.g_err_stage := 'Unexpected error in maintain plan matrix ' ||
3904: 'PD-Txn data from budget lines table';

Line 3917: END PA_PLAN_MATRIX;

3913: PA_DEBUG.Reset_Curr_Function;
3914: RAISE;
3915: END Maintain_Plan_Matrix;
3916:
3917: END PA_PLAN_MATRIX;