DBA Data[Home] [Help]

APPS.PA_FP_AUTO_BASELINE_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 84: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

80: -- Check for business rules violations
81:
82: pa_debug.g_err_stage:= 'Validating input parameters';
83: IF P_PA_DEBUG_MODE = 'Y' THEN
84: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
85: END IF;
86:
87: --Check if project id or plan type id or plan level code
88: --is null

Line 91: or p_funding_level_code not in (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT,

87: --Check if project id or plan type id or plan level code
88: --is null
89:
90: IF (p_project_id is null or p_fin_plan_type_id is null or p_version_name is null
91: or p_funding_level_code not in (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT,
92: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP))
93: THEN
94:
95: pa_debug.g_err_stage:= 'project id = '|| p_project_id ;

Line 92: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP))

88: --is null
89:
90: IF (p_project_id is null or p_fin_plan_type_id is null or p_version_name is null
91: or p_funding_level_code not in (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT,
92: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP))
93: THEN
94:
95: pa_debug.g_err_stage:= 'project id = '|| p_project_id ;
96: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 97: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

93: THEN
94:
95: pa_debug.g_err_stage:= 'project id = '|| p_project_id ;
96: IF P_PA_DEBUG_MODE = 'Y' THEN
97: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
98: END IF;
99:
100: pa_debug.g_err_stage:= 'plan type id = '|| p_fin_plan_type_id;
101: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 102: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

98: END IF;
99:
100: pa_debug.g_err_stage:= 'plan type id = '|| p_fin_plan_type_id;
101: IF P_PA_DEBUG_MODE = 'Y' THEN
102: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
103: END IF;
104:
105: pa_debug.g_err_stage:= 'finplan level code = '|| p_funding_level_code;
106: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 107: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

103: END IF;
104:
105: pa_debug.g_err_stage:= 'finplan level code = '|| p_funding_level_code;
106: IF P_PA_DEBUG_MODE = 'Y' THEN
107: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
108: END IF;
109:
110: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
111: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 113: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

109:
110: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
111: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
112:
113: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
114:
115: END IF;
116:
117: pa_debug.g_err_stage:= 'Input parameters validated';

Line 119: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

115: END IF;
116:
117: pa_debug.g_err_stage:= 'Input parameters validated';
118: IF P_PA_DEBUG_MODE = 'Y' THEN
119: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
120: END IF;
121:
122: l_calling_context := PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE; /* Bug# 2674353 */
123:

Line 122: l_calling_context := PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE; /* Bug# 2674353 */

118: IF P_PA_DEBUG_MODE = 'Y' THEN
119: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
120: END IF;
121:
122: l_calling_context := PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE; /* Bug# 2674353 */
123:
124: pa_debug.g_err_stage:= 'Get the uncategorized resource list id';
125: IF P_PA_DEBUG_MODE = 'Y' THEN
126: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 126: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

122: l_calling_context := PA_FP_CONSTANTS_PKG.G_AUTOMATIC_BASELINE; /* Bug# 2674353 */
123:
124: pa_debug.g_err_stage:= 'Get the uncategorized resource list id';
125: IF P_PA_DEBUG_MODE = 'Y' THEN
126: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
127: END IF;
128:
129: PA_GET_RESOURCE.Get_Uncateg_Resource_Info( p_resource_list_id => l_uncateg_resource_list_id
130: ,p_resource_list_member_id => l_uncateg_rlm_id

Line 139: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

135: ,p_err_stack => PA_DEBUG.G_Err_Stack);
136:
137: pa_debug.g_err_stage:= 'uncategorized resource list id ' || l_uncateg_resource_list_id;
138: IF P_PA_DEBUG_MODE = 'Y' THEN
139: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
140: END IF;
141:
142: pa_debug.g_err_stage:= 'Determine the MC flag';
143: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 144: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

140: END IF;
141:
142: pa_debug.g_err_stage:= 'Determine the MC flag';
143: IF P_PA_DEBUG_MODE = 'Y' THEN
144: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
145: END IF;
146:
147: pa_budget_utils.Get_Project_Currency_Info
148: (

Line 161: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

157:
158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
159: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
160: IF P_PA_DEBUG_MODE = 'Y' THEN
161: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
162: END IF;
163: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
164: END IF;
165:

Line 163: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

159: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
160: IF P_PA_DEBUG_MODE = 'Y' THEN
161: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
162: END IF;
163: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
164: END IF;
165:
166:
167: IF ( l_projfunc_currency_code <> l_project_currency_code) THEN

Line 175: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

171: END IF;
172:
173: pa_debug.g_err_stage:= 'MC flag -> ' || l_plan_in_mc_flag;
174: IF P_PA_DEBUG_MODE = 'Y' THEN
175: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
176: END IF;
177:
178:
179: pa_debug.g_err_stage:= 'Get the currency attributes from the plan type';

Line 181: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

177:
178:
179: pa_debug.g_err_stage:= 'Get the currency attributes from the plan type';
180: IF P_PA_DEBUG_MODE = 'Y' THEN
181: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
182: END IF;
183:
184: l_fp_options_id := pa_proj_fp_options_pub.get_fp_option_id( p_project_id => p_project_id
185: ,p_plan_type_id => p_fin_plan_type_id

Line 190: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

186: ,p_plan_version_id => NULL );
187:
188: pa_debug.g_err_stage:= 'plan type option id is ' || l_fp_options_id;
189: IF P_PA_DEBUG_MODE = 'Y' THEN
190: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
191: END IF;
192:
193: l_fp_mc_cols := pa_proj_fp_options_pub.Get_FP_Proj_Mc_Options(p_proj_fp_options_id => l_fp_options_id);
194:

Line 198: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

194:
195:
196: pa_debug.g_err_stage:= 'Prepare the budget lines tab from funding lines tab';
197: IF P_PA_DEBUG_MODE = 'Y' THEN
198: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
199: END IF;
200:
201:
202:

Line 211: IF(p_funding_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN

207: system_reference5 -> track_as_labor_flag
208: */
209: IF nvl(p_funding_bl_tab.last,0) > 0 THEN
210: FOR i IN p_funding_bl_tab.first..p_funding_bl_tab.last LOOP
211: IF(p_funding_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN
212: l_budget_lines_tab(i).system_reference1 := 0;
213: ELSE
214: l_budget_lines_tab(i).system_reference1 := p_funding_bl_tab(i).task_id;
215: END IF;

Line 221: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

217: l_budget_lines_tab(i).description := p_funding_bl_tab(i).description;
218: IF(p_funding_bl_tab(i).start_date IS NULL) THEN
219: pa_debug.g_err_stage:= 'start date is null';
220: IF P_PA_DEBUG_MODE = 'Y' THEN
221: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
222: END IF;
223: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
224: ELSE
225: l_budget_lines_tab(i).start_date := p_funding_bl_tab(i).start_date;

Line 223: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

219: pa_debug.g_err_stage:= 'start date is null';
220: IF P_PA_DEBUG_MODE = 'Y' THEN
221: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
222: END IF;
223: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
224: ELSE
225: l_budget_lines_tab(i).start_date := p_funding_bl_tab(i).start_date;
226: END IF;
227:

Line 234: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

230: the following validation */
231: IF(p_funding_bl_tab(i).end_date IS NULL) THEN --Included after UT.
232: pa_debug.g_err_stage:= 'end date is null';
233: IF P_PA_DEBUG_MODE = 'Y' THEN
234: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
235: END IF;
236: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
237: ELSE
238: l_budget_lines_tab(i).end_date := p_funding_bl_tab(i).end_date;

Line 236: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

232: pa_debug.g_err_stage:= 'end date is null';
233: IF P_PA_DEBUG_MODE = 'Y' THEN
234: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
235: END IF;
236: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
237: ELSE
238: l_budget_lines_tab(i).end_date := p_funding_bl_tab(i).end_date;
239: END IF;
240:

Line 293: l_budget_lines_tab(i).quantity_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;

289: l_budget_lines_tab(i).PROJECT_REV_RATE_DATE := l_fp_mc_cols.project_rev_rate_date;
290: l_budget_lines_tab(i).PROJECT_REV_EXCHANGE_RATE := NULL;
291: l_budget_lines_tab(i).pm_product_code := NULL;
292: l_budget_lines_tab(i).pm_budget_line_reference := NULL;
293: l_budget_lines_tab(i).quantity_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
294: l_budget_lines_tab(i).raw_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
295: l_budget_lines_tab(i).burdened_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
296: l_budget_lines_tab(i).revenue_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
297: l_budget_lines_tab(i).resource_assignment_id := -1;

Line 294: l_budget_lines_tab(i).raw_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;

290: l_budget_lines_tab(i).PROJECT_REV_EXCHANGE_RATE := NULL;
291: l_budget_lines_tab(i).pm_product_code := NULL;
292: l_budget_lines_tab(i).pm_budget_line_reference := NULL;
293: l_budget_lines_tab(i).quantity_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
294: l_budget_lines_tab(i).raw_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
295: l_budget_lines_tab(i).burdened_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
296: l_budget_lines_tab(i).revenue_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
297: l_budget_lines_tab(i).resource_assignment_id := -1;
298: END LOOP;

Line 295: l_budget_lines_tab(i).burdened_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;

291: l_budget_lines_tab(i).pm_product_code := NULL;
292: l_budget_lines_tab(i).pm_budget_line_reference := NULL;
293: l_budget_lines_tab(i).quantity_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
294: l_budget_lines_tab(i).raw_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
295: l_budget_lines_tab(i).burdened_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
296: l_budget_lines_tab(i).revenue_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
297: l_budget_lines_tab(i).resource_assignment_id := -1;
298: END LOOP;
299: END IF;

Line 296: l_budget_lines_tab(i).revenue_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;

292: l_budget_lines_tab(i).pm_budget_line_reference := NULL;
293: l_budget_lines_tab(i).quantity_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
294: l_budget_lines_tab(i).raw_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
295: l_budget_lines_tab(i).burdened_cost_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
296: l_budget_lines_tab(i).revenue_source := PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_MANUAL_M;
297: l_budget_lines_tab(i).resource_assignment_id := -1;
298: END LOOP;
299: END IF;
300:

Line 303: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

299: END IF;
300:
301: pa_debug.g_err_stage:= 'Calling pa_fin_plan_pvt.create_draft';
302: IF P_PA_DEBUG_MODE = 'Y' THEN
303: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
304: END IF;
305:
306: pa_fin_plan_pvt.create_draft
307: ( p_project_id => p_project_id

Line 309: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

305:
306: pa_fin_plan_pvt.create_draft
307: ( p_project_id => p_project_id
308: ,p_fin_plan_type_id => p_fin_plan_type_id
309: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
310: ,p_calling_context => l_calling_context
311: ,p_time_phased_code => PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N
312: ,p_resource_list_id => l_uncateg_resource_list_id
313: ,p_fin_plan_level_code => p_funding_level_code

Line 311: ,p_time_phased_code => PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N

307: ( p_project_id => p_project_id
308: ,p_fin_plan_type_id => p_fin_plan_type_id
309: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
310: ,p_calling_context => l_calling_context
311: ,p_time_phased_code => PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N
312: ,p_resource_list_id => l_uncateg_resource_list_id
313: ,p_fin_plan_level_code => p_funding_level_code
314: ,p_plan_in_mc_flag => l_plan_in_mc_flag
315: ,p_version_name => p_version_name

Line 379: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

375:
376: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: pa_debug.g_err_stage:= 'Error Calling Create_Draft';
378: IF P_PA_DEBUG_MODE = 'Y' THEN
379: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
380: END IF;
381: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
382: ELSE
383: x_budget_version_id := l_created_version_id;

Line 381: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

377: pa_debug.g_err_stage:= 'Error Calling Create_Draft';
378: IF P_PA_DEBUG_MODE = 'Y' THEN
379: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
380: END IF;
381: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
382: ELSE
383: x_budget_version_id := l_created_version_id;
384: pa_debug.g_err_stage:= 'successful call of Create_Draft. Created Version id : ' || l_created_version_id;
385: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 386: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

382: ELSE
383: x_budget_version_id := l_created_version_id;
384: pa_debug.g_err_stage:= 'successful call of Create_Draft. Created Version id : ' || l_created_version_id;
385: IF P_PA_DEBUG_MODE = 'Y' THEN
386: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
387: END IF;
388: END IF;
389:
390: /* Review Comment */

Line 398: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

394: /* The version needs to be baselined only if the ci_id is null - Bug 2672654 */
395: IF (p_ci_id is null) THEN
396: pa_debug.g_err_stage:= 'This is not a control item version - Going ahead to baseline';
397: IF P_PA_DEBUG_MODE = 'Y' THEN
398: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
399: END IF;
400:
401: pa_debug.g_err_stage:= 'Get details of the existing baselined version';
402: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 403: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

399: END IF;
400:
401: pa_debug.g_err_stage:= 'Get details of the existing baselined version';
402: IF P_PA_DEBUG_MODE = 'Y' THEN
403: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
404: END IF;
405:
406: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
407: p_project_id => p_project_id

Line 409: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

405:
406: PA_FIN_PLAN_UTILS.Get_Baselined_Version_Info(
407: p_project_id => p_project_id
408: ,p_fin_plan_type_id => p_fin_plan_type_id
409: ,p_version_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
410: ,x_fp_options_id => l_fp_options_id
411: ,x_fin_plan_version_id => l_baselined_version_id
412: ,x_return_status => x_return_status
413: ,x_msg_count => x_msg_count

Line 419: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

415:
416: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
417: pa_debug.g_err_stage:= 'Error Getting current baselined version info';
418: IF P_PA_DEBUG_MODE = 'Y' THEN
419: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
420: END IF;
421: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
422: END IF;
423:

Line 421: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

417: pa_debug.g_err_stage:= 'Error Getting current baselined version info';
418: IF P_PA_DEBUG_MODE = 'Y' THEN
419: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
420: END IF;
421: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
422: END IF;
423:
424: pa_debug.g_err_stage:= 'current baselined version id -> ' || l_baselined_version_id;
425: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 426: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

422: END IF;
423:
424: pa_debug.g_err_stage:= 'current baselined version id -> ' || l_baselined_version_id;
425: IF P_PA_DEBUG_MODE = 'Y' THEN
426: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
427: END IF;
428:
429:
430:

Line 457: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

453:
454: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
455: pa_debug.g_err_stage:= 'Error baselining version - Version id->' || l_created_version_id;
456: IF P_PA_DEBUG_MODE = 'Y' THEN
457: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
458: END IF;
459: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
460: END IF;
461:

Line 459: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

455: pa_debug.g_err_stage:= 'Error baselining version - Version id->' || l_created_version_id;
456: IF P_PA_DEBUG_MODE = 'Y' THEN
457: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
458: END IF;
459: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
460: END IF;
461:
462: ELSE
463: pa_debug.g_err_stage:= 'This is a control item version - Skipped baseline';

Line 465: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

461:
462: ELSE
463: pa_debug.g_err_stage:= 'This is a control item version - Skipped baseline';
464: IF P_PA_DEBUG_MODE = 'Y' THEN
465: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
466: END IF;
467: END IF;
468:
469: pa_debug.g_err_stage:= 'Exiting CREATE_AUTO_BASELINE_VERSION';

Line 471: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

467: END IF;
468:
469: pa_debug.g_err_stage:= 'Exiting CREATE_AUTO_BASELINE_VERSION';
470: IF P_PA_DEBUG_MODE = 'Y' THEN
471: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
472: END IF;
473: pa_debug.reset_err_stack;
474:
475: EXCEPTION

Line 477: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

473: pa_debug.reset_err_stack;
474:
475: EXCEPTION
476:
477: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
478: x_budget_version_id := NULL; --NOCOPY
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: -- Bug Fix: 4569365. Removed MRC code.
481: -- PA_MRC_FINPLAN.G_CALLING_MODULE := null; /* Bug 2881994 */

Line 499: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

495: END IF;
496:
497: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
498: IF P_PA_DEBUG_MODE = 'Y' THEN
499: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
500: END IF;
501: pa_debug.reset_err_stack;
502: RAISE;
503:

Line 516: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

512: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_AUTO_BASELINE_PKG'
513: ,p_procedure_name => 'CREATE_BASELINED_VERSION');
514: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
515: IF P_PA_DEBUG_MODE = 'Y' THEN
516: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
517: END IF;
518: pa_debug.reset_err_stack;
519: RAISE;
520: