eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLAN_REVENUE dependencies on PA_DEBUG

Line 20: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

16: l_Get_plan_actual_Rates EXCEPTION; /* Added to handel when others in Get_plan_actual_Rates proc. */
17:
18: g_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: g_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
21: g_module_name VARCHAR2(100) := 'pa.plsql.PA_PLAN_REVENUE';
22: g_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
23: g_uom_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
24: g_count_init NUMBER:=0;

Line 90: pa_debug.g_err_stage := 'p_res_class_rate_sch_id:'||p_res_class_rate_sch_id||'p_res_class_org_id :'||p_res_class_org_id||'p_org_id:'||p_org_id ;

86: BEGIN
87: /*Checking all the mandatory Parameters */
88:
89: IF g1_debug_mode = 'Y' THEN
90: pa_debug.g_err_stage := 'p_res_class_rate_sch_id:'||p_res_class_rate_sch_id||'p_res_class_org_id :'||p_res_class_org_id||'p_org_id:'||p_org_id ;
91: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);
92: END IF;
93: IF g1_debug_mode = 'Y' THEN
94: pa_debug.g_err_stage := 'p_resource_class_code:'||p_resource_class_code||'p_item_date :'||p_item_date ;

Line 91: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);

87: /*Checking all the mandatory Parameters */
88:
89: IF g1_debug_mode = 'Y' THEN
90: pa_debug.g_err_stage := 'p_res_class_rate_sch_id:'||p_res_class_rate_sch_id||'p_res_class_org_id :'||p_res_class_org_id||'p_org_id:'||p_org_id ;
91: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);
92: END IF;
93: IF g1_debug_mode = 'Y' THEN
94: pa_debug.g_err_stage := 'p_resource_class_code:'||p_resource_class_code||'p_item_date :'||p_item_date ;
95: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);

Line 94: pa_debug.g_err_stage := 'p_resource_class_code:'||p_resource_class_code||'p_item_date :'||p_item_date ;

90: pa_debug.g_err_stage := 'p_res_class_rate_sch_id:'||p_res_class_rate_sch_id||'p_res_class_org_id :'||p_res_class_org_id||'p_org_id:'||p_org_id ;
91: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);
92: END IF;
93: IF g1_debug_mode = 'Y' THEN
94: pa_debug.g_err_stage := 'p_resource_class_code:'||p_resource_class_code||'p_item_date :'||p_item_date ;
95: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);
96: END IF;
97:
98: IF p_res_class_rate_sch_id IS NULL OR p_item_date IS NULL

Line 95: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);

91: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);
92: END IF;
93: IF g1_debug_mode = 'Y' THEN
94: pa_debug.g_err_stage := 'p_resource_class_code:'||p_resource_class_code||'p_item_date :'||p_item_date ;
95: pa_debug.write('PA_PLAN_REVENUE.Get_Res_Class_Hierarchy_Rate: ' || g_module_name,pa_debug.g_err_stage,3);
96: END IF;
97:
98: IF p_res_class_rate_sch_id IS NULL OR p_item_date IS NULL
99: OR p_resource_class_code IS NULL THEN

Line 189: pa_debug.g_err_stage:='Before count of g_count_init'|| g_count_init||'g_expenditure_type_tbl.COUNT'||g_expenditure_type_tbl.COUNT;

185:
186: g_count_init:= g_count_init+1;
187:
188: IF g1_debug_mode = 'Y' THEN
189: pa_debug.g_err_stage:='Before count of g_count_init'|| g_count_init||'g_expenditure_type_tbl.COUNT'||g_expenditure_type_tbl.COUNT;
190: pa_debug.write('Get_exp_type_uom: ' || g_module_name,pa_debug.g_err_stage,2);
191: END IF;
192: END;
193:

Line 190: pa_debug.write('Get_exp_type_uom: ' || g_module_name,pa_debug.g_err_stage,2);

186: g_count_init:= g_count_init+1;
187:
188: IF g1_debug_mode = 'Y' THEN
189: pa_debug.g_err_stage:='Before count of g_count_init'|| g_count_init||'g_expenditure_type_tbl.COUNT'||g_expenditure_type_tbl.COUNT;
190: pa_debug.write('Get_exp_type_uom: ' || g_module_name,pa_debug.g_err_stage,2);
191: END IF;
192: END;
193:
194: -- This procedure will calculate the raw revenue and bill amount from one of the 12 criterias on the basis

Line 339: PA_DEBUG.init_err_stack( 'PA_PLAN_REVENUE.Get_planning_rates');

335:
336: -- Initializing return status with success so that if some unexpected error comes
337: -- , we change its status from succes to error so that we can take necessary step to rectify the problem
338: l_x_return_status := g_success;
339: PA_DEBUG.init_err_stack( 'PA_PLAN_REVENUE.Get_planning_rates');
340: IF g1_debug_mode = 'Y' THEN
341: pa_debug.g_err_stage:='Input parameters:-> p_project_id :'||p_project_id ||'p_task_id :'||p_task_id;
342: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
343: END IF;

Line 341: pa_debug.g_err_stage:='Input parameters:-> p_project_id :'||p_project_id ||'p_task_id :'||p_task_id;

337: -- , we change its status from succes to error so that we can take necessary step to rectify the problem
338: l_x_return_status := g_success;
339: PA_DEBUG.init_err_stack( 'PA_PLAN_REVENUE.Get_planning_rates');
340: IF g1_debug_mode = 'Y' THEN
341: pa_debug.g_err_stage:='Input parameters:-> p_project_id :'||p_project_id ||'p_task_id :'||p_task_id;
342: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
343: END IF;
344:
345: IF g1_debug_mode = 'Y' THEN

Line 342: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

338: l_x_return_status := g_success;
339: PA_DEBUG.init_err_stack( 'PA_PLAN_REVENUE.Get_planning_rates');
340: IF g1_debug_mode = 'Y' THEN
341: pa_debug.g_err_stage:='Input parameters:-> p_project_id :'||p_project_id ||'p_task_id :'||p_task_id;
342: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
343: END IF;
344:
345: IF g1_debug_mode = 'Y' THEN
346: pa_debug.g_err_stage:='Input parameters:-> p_person_id :'||p_person_id||'p_job_id :'||p_job_id;

Line 346: pa_debug.g_err_stage:='Input parameters:-> p_person_id :'||p_person_id||'p_job_id :'||p_job_id;

342: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
343: END IF;
344:
345: IF g1_debug_mode = 'Y' THEN
346: pa_debug.g_err_stage:='Input parameters:-> p_person_id :'||p_person_id||'p_job_id :'||p_job_id;
347: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
348: END IF;
349: IF g1_debug_mode = 'Y' THEN
350: pa_debug.g_err_stage:='Input parameters:-> p_resource_class :'||p_resource_class ||'p_use_planning_rates_flag :'||p_use_planning_rates_flag;

Line 347: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

343: END IF;
344:
345: IF g1_debug_mode = 'Y' THEN
346: pa_debug.g_err_stage:='Input parameters:-> p_person_id :'||p_person_id||'p_job_id :'||p_job_id;
347: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
348: END IF;
349: IF g1_debug_mode = 'Y' THEN
350: pa_debug.g_err_stage:='Input parameters:-> p_resource_class :'||p_resource_class ||'p_use_planning_rates_flag :'||p_use_planning_rates_flag;
351: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 350: pa_debug.g_err_stage:='Input parameters:-> p_resource_class :'||p_resource_class ||'p_use_planning_rates_flag :'||p_use_planning_rates_flag;

346: pa_debug.g_err_stage:='Input parameters:-> p_person_id :'||p_person_id||'p_job_id :'||p_job_id;
347: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
348: END IF;
349: IF g1_debug_mode = 'Y' THEN
350: pa_debug.g_err_stage:='Input parameters:-> p_resource_class :'||p_resource_class ||'p_use_planning_rates_flag :'||p_use_planning_rates_flag;
351: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
352: END IF;
353: IF g1_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:='Input parameters:-> p_rate_based_flag:'||p_rate_based_flag||'p_uom :'||p_uom;

Line 351: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

347: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
348: END IF;
349: IF g1_debug_mode = 'Y' THEN
350: pa_debug.g_err_stage:='Input parameters:-> p_resource_class :'||p_resource_class ||'p_use_planning_rates_flag :'||p_use_planning_rates_flag;
351: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
352: END IF;
353: IF g1_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:='Input parameters:-> p_rate_based_flag:'||p_rate_based_flag||'p_uom :'||p_uom;
355: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 354: pa_debug.g_err_stage:='Input parameters:-> p_rate_based_flag:'||p_rate_based_flag||'p_uom :'||p_uom;

350: pa_debug.g_err_stage:='Input parameters:-> p_resource_class :'||p_resource_class ||'p_use_planning_rates_flag :'||p_use_planning_rates_flag;
351: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
352: END IF;
353: IF g1_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:='Input parameters:-> p_rate_based_flag:'||p_rate_based_flag||'p_uom :'||p_uom;
355: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
356: END IF;
357:
358: IF g1_debug_mode = 'Y' THEN

Line 355: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

351: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
352: END IF;
353: IF g1_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:='Input parameters:-> p_rate_based_flag:'||p_rate_based_flag||'p_uom :'||p_uom;
355: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
356: END IF;
357:
358: IF g1_debug_mode = 'Y' THEN
359: pa_debug.g_err_stage:='Input parameters:-> p_rev_res_class_rate_sch_id :'||p_rev_res_class_rate_sch_id ||'p_cost_res_class_rate_sch_id :'||p_cost_res_class_rate_sch_id;

Line 359: pa_debug.g_err_stage:='Input parameters:-> p_rev_res_class_rate_sch_id :'||p_rev_res_class_rate_sch_id ||'p_cost_res_class_rate_sch_id :'||p_cost_res_class_rate_sch_id;

355: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
356: END IF;
357:
358: IF g1_debug_mode = 'Y' THEN
359: pa_debug.g_err_stage:='Input parameters:-> p_rev_res_class_rate_sch_id :'||p_rev_res_class_rate_sch_id ||'p_cost_res_class_rate_sch_id :'||p_cost_res_class_rate_sch_id;
360: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
361: END IF;
362:
363: IF g1_debug_mode = 'Y' THEN

Line 360: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

356: END IF;
357:
358: IF g1_debug_mode = 'Y' THEN
359: pa_debug.g_err_stage:='Input parameters:-> p_rev_res_class_rate_sch_id :'||p_rev_res_class_rate_sch_id ||'p_cost_res_class_rate_sch_id :'||p_cost_res_class_rate_sch_id;
360: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
361: END IF;
362:
363: IF g1_debug_mode = 'Y' THEN
364: pa_debug.g_err_stage:='Input parameters:-> p_rev_task_nl_rate_sch_id :'||p_rev_task_nl_rate_sch_id||'p_rev_proj_nl_rate_sch_id :'||p_rev_proj_nl_rate_sch_id;

Line 364: pa_debug.g_err_stage:='Input parameters:-> p_rev_task_nl_rate_sch_id :'||p_rev_task_nl_rate_sch_id||'p_rev_proj_nl_rate_sch_id :'||p_rev_proj_nl_rate_sch_id;

360: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
361: END IF;
362:
363: IF g1_debug_mode = 'Y' THEN
364: pa_debug.g_err_stage:='Input parameters:-> p_rev_task_nl_rate_sch_id :'||p_rev_task_nl_rate_sch_id||'p_rev_proj_nl_rate_sch_id :'||p_rev_proj_nl_rate_sch_id;
365: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
366: END IF;
367:
368: IF g1_debug_mode = 'Y' THEN

Line 365: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

361: END IF;
362:
363: IF g1_debug_mode = 'Y' THEN
364: pa_debug.g_err_stage:='Input parameters:-> p_rev_task_nl_rate_sch_id :'||p_rev_task_nl_rate_sch_id||'p_rev_proj_nl_rate_sch_id :'||p_rev_proj_nl_rate_sch_id;
365: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
366: END IF;
367:
368: IF g1_debug_mode = 'Y' THEN
369: pa_debug.g_err_stage:='Input parameters:-> p_rev_job_rate_sch_id :'||p_rev_job_rate_sch_id ||'p_rev_emp_rate_sch_id :'||p_rev_emp_rate_sch_id;

Line 369: pa_debug.g_err_stage:='Input parameters:-> p_rev_job_rate_sch_id :'||p_rev_job_rate_sch_id ||'p_rev_emp_rate_sch_id :'||p_rev_emp_rate_sch_id;

365: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
366: END IF;
367:
368: IF g1_debug_mode = 'Y' THEN
369: pa_debug.g_err_stage:='Input parameters:-> p_rev_job_rate_sch_id :'||p_rev_job_rate_sch_id ||'p_rev_emp_rate_sch_id :'||p_rev_emp_rate_sch_id;
370: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
371: END IF;
372:
373: IF g1_debug_mode = 'Y' THEN

Line 370: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

366: END IF;
367:
368: IF g1_debug_mode = 'Y' THEN
369: pa_debug.g_err_stage:='Input parameters:-> p_rev_job_rate_sch_id :'||p_rev_job_rate_sch_id ||'p_rev_emp_rate_sch_id :'||p_rev_emp_rate_sch_id;
370: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
371: END IF;
372:
373: IF g1_debug_mode = 'Y' THEN
374: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_job_rate_sch_id :'||p_plan_rev_job_rate_sch_id||'p_plan_cost_job_rate_sch_id :'||p_plan_cost_job_rate_sch_id;

Line 374: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_job_rate_sch_id :'||p_plan_rev_job_rate_sch_id||'p_plan_cost_job_rate_sch_id :'||p_plan_cost_job_rate_sch_id;

370: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
371: END IF;
372:
373: IF g1_debug_mode = 'Y' THEN
374: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_job_rate_sch_id :'||p_plan_rev_job_rate_sch_id||'p_plan_cost_job_rate_sch_id :'||p_plan_cost_job_rate_sch_id;
375: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
376: END IF;
377:
378: IF g1_debug_mode = 'Y' THEN

Line 375: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

371: END IF;
372:
373: IF g1_debug_mode = 'Y' THEN
374: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_job_rate_sch_id :'||p_plan_rev_job_rate_sch_id||'p_plan_cost_job_rate_sch_id :'||p_plan_cost_job_rate_sch_id;
375: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
376: END IF;
377:
378: IF g1_debug_mode = 'Y' THEN
379: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_nlr_rate_sch_id :'||p_plan_rev_nlr_rate_sch_id ||'p_plan_cost_nlr_rate_sch_id :'||p_plan_cost_nlr_rate_sch_id;

Line 379: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_nlr_rate_sch_id :'||p_plan_rev_nlr_rate_sch_id ||'p_plan_cost_nlr_rate_sch_id :'||p_plan_cost_nlr_rate_sch_id;

375: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
376: END IF;
377:
378: IF g1_debug_mode = 'Y' THEN
379: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_nlr_rate_sch_id :'||p_plan_rev_nlr_rate_sch_id ||'p_plan_cost_nlr_rate_sch_id :'||p_plan_cost_nlr_rate_sch_id;
380: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
381: END IF;
382:
383: IF g1_debug_mode = 'Y' THEN

Line 380: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

376: END IF;
377:
378: IF g1_debug_mode = 'Y' THEN
379: pa_debug.g_err_stage:='Input parameters:-> p_plan_rev_nlr_rate_sch_id :'||p_plan_rev_nlr_rate_sch_id ||'p_plan_cost_nlr_rate_sch_id :'||p_plan_cost_nlr_rate_sch_id;
380: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
381: END IF;
382:
383: IF g1_debug_mode = 'Y' THEN
384: pa_debug.g_err_stage:='Input parameters:-> p_plan_burden_cost_sch_id :'||p_plan_burden_cost_sch_id ||'p_calculate_mode :'||p_calculate_mode;

Line 384: pa_debug.g_err_stage:='Input parameters:-> p_plan_burden_cost_sch_id :'||p_plan_burden_cost_sch_id ||'p_calculate_mode :'||p_calculate_mode;

380: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
381: END IF;
382:
383: IF g1_debug_mode = 'Y' THEN
384: pa_debug.g_err_stage:='Input parameters:-> p_plan_burden_cost_sch_id :'||p_plan_burden_cost_sch_id ||'p_calculate_mode :'||p_calculate_mode;
385: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
386: END IF;
387:
388: IF g1_debug_mode = 'Y' THEN

Line 385: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

381: END IF;
382:
383: IF g1_debug_mode = 'Y' THEN
384: pa_debug.g_err_stage:='Input parameters:-> p_plan_burden_cost_sch_id :'||p_plan_burden_cost_sch_id ||'p_calculate_mode :'||p_calculate_mode;
385: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
386: END IF;
387:
388: IF g1_debug_mode = 'Y' THEN
389: pa_debug.g_err_stage:='Input parameters:-> p_quantity :'||p_quantity ||'p_labor_sch_type :'||p_labor_sch_type;

Line 389: pa_debug.g_err_stage:='Input parameters:-> p_quantity :'||p_quantity ||'p_labor_sch_type :'||p_labor_sch_type;

385: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
386: END IF;
387:
388: IF g1_debug_mode = 'Y' THEN
389: pa_debug.g_err_stage:='Input parameters:-> p_quantity :'||p_quantity ||'p_labor_sch_type :'||p_labor_sch_type;
390: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
391: END IF;
392:
393: IF g1_debug_mode = 'Y' THEN

Line 390: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

386: END IF;
387:
388: IF g1_debug_mode = 'Y' THEN
389: pa_debug.g_err_stage:='Input parameters:-> p_quantity :'||p_quantity ||'p_labor_sch_type :'||p_labor_sch_type;
390: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
391: END IF;
392:
393: IF g1_debug_mode = 'Y' THEN
394: pa_debug.g_err_stage:='Input parameters:-> p_non_labor_sch_type :'||p_non_labor_sch_type ||'p_expenditure_type :'||p_expenditure_type;

Line 394: pa_debug.g_err_stage:='Input parameters:-> p_non_labor_sch_type :'||p_non_labor_sch_type ||'p_expenditure_type :'||p_expenditure_type;

390: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
391: END IF;
392:
393: IF g1_debug_mode = 'Y' THEN
394: pa_debug.g_err_stage:='Input parameters:-> p_non_labor_sch_type :'||p_non_labor_sch_type ||'p_expenditure_type :'||p_expenditure_type;
395: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
396: END IF;
397:
398:

Line 395: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

391: END IF;
392:
393: IF g1_debug_mode = 'Y' THEN
394: pa_debug.g_err_stage:='Input parameters:-> p_non_labor_sch_type :'||p_non_labor_sch_type ||'p_expenditure_type :'||p_expenditure_type;
395: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
396: END IF;
397:
398:
399: IF g1_debug_mode = 'Y' THEN

Line 400: pa_debug.g_err_stage:='Input parameters:-> p_cost_override_rate :'||p_cost_override_rate ||'p_raw_cost :'||p_raw_cost;

396: END IF;
397:
398:
399: IF g1_debug_mode = 'Y' THEN
400: pa_debug.g_err_stage:='Input parameters:-> p_cost_override_rate :'||p_cost_override_rate ||'p_raw_cost :'||p_raw_cost;
401: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
402: END IF;
403:
404: IF g1_debug_mode = 'Y' THEN

Line 401: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

397:
398:
399: IF g1_debug_mode = 'Y' THEN
400: pa_debug.g_err_stage:='Input parameters:-> p_cost_override_rate :'||p_cost_override_rate ||'p_raw_cost :'||p_raw_cost;
401: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
402: END IF;
403:
404: IF g1_debug_mode = 'Y' THEN
405: pa_debug.g_err_stage:='Input parameters:-> p_revenue_override_rate :'||p_revenue_override_rate ||'p_override_currency_code :'||p_override_currency_code;

Line 405: pa_debug.g_err_stage:='Input parameters:-> p_revenue_override_rate :'||p_revenue_override_rate ||'p_override_currency_code :'||p_override_currency_code;

401: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
402: END IF;
403:
404: IF g1_debug_mode = 'Y' THEN
405: pa_debug.g_err_stage:='Input parameters:-> p_revenue_override_rate :'||p_revenue_override_rate ||'p_override_currency_code :'||p_override_currency_code;
406: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
407: END IF;
408:
409: IF g1_debug_mode = 'Y' THEN

Line 406: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

402: END IF;
403:
404: IF g1_debug_mode = 'Y' THEN
405: pa_debug.g_err_stage:='Input parameters:-> p_revenue_override_rate :'||p_revenue_override_rate ||'p_override_currency_code :'||p_override_currency_code;
406: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
407: END IF;
408:
409: IF g1_debug_mode = 'Y' THEN
410: pa_debug.g_err_stage:='Input parameters:-> p_burden_cost :'||p_burden_cost ||'p_raw_revenue :'||p_raw_revenue ;

Line 410: pa_debug.g_err_stage:='Input parameters:-> p_burden_cost :'||p_burden_cost ||'p_raw_revenue :'||p_raw_revenue ;

406: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
407: END IF;
408:
409: IF g1_debug_mode = 'Y' THEN
410: pa_debug.g_err_stage:='Input parameters:-> p_burden_cost :'||p_burden_cost ||'p_raw_revenue :'||p_raw_revenue ;
411: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
412: END IF;
413:
414:

Line 411: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

407: END IF;
408:
409: IF g1_debug_mode = 'Y' THEN
410: pa_debug.g_err_stage:='Input parameters:-> p_burden_cost :'||p_burden_cost ||'p_raw_revenue :'||p_raw_revenue ;
411: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
412: END IF;
413:
414:
415: IF g1_debug_mode = 'Y' THEN

Line 416: pa_debug.g_err_stage:='Validating input parameters';

412: END IF;
413:
414:
415: IF g1_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:='Validating input parameters';
417: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
418: END IF;
419:
420:

Line 417: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

413:
414:
415: IF g1_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:='Validating input parameters';
417: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
418: END IF;
419:
420:
421: /* Change to honour billability flag */

Line 437: pa_debug.g_err_stage:='Validating Get_planning_rates :pass p_override_currency_code for Override amounts';

433: the API should pass the same value as it is without any further calculation */
434: IF p_raw_cost IS NOT NULL AND p_burden_cost IS NOT NULL AND p_raw_revenue IS NOT NULL THEN
435: IF p_override_currency_code IS NULL THEN
436: IF g1_debug_mode = 'Y' THEN
437: pa_debug.g_err_stage:='Validating Get_planning_rates :pass p_override_currency_code for Override amounts';
438: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
439: END IF;
440: RAISE l_invalid_currency ;
441: ELSE

Line 438: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

434: IF p_raw_cost IS NOT NULL AND p_burden_cost IS NOT NULL AND p_raw_revenue IS NOT NULL THEN
435: IF p_override_currency_code IS NULL THEN
436: IF g1_debug_mode = 'Y' THEN
437: pa_debug.g_err_stage:='Validating Get_planning_rates :pass p_override_currency_code for Override amounts';
438: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
439: END IF;
440: RAISE l_invalid_currency ;
441: ELSE
442: l_txn_raw_cost :=p_raw_cost;

Line 469: pa_debug.g_err_stage:='Validating Get_planning_rates :p_override_currency_code cannot be null,if p_raw_cost,p_raw_revenue,p_cost_override_rate,p_revenue_override_rate is passed';

465: IF ((p_raw_cost IS NOT NULL OR p_raw_revenue IS NOT NULL)
466: OR (p_cost_override_rate IS NOT NULL OR p_revenue_override_rate IS NOT NULL)) THEN
467: IF p_override_currency_code IS NULL THEN
468: IF g1_debug_mode = 'Y' THEN
469: pa_debug.g_err_stage:='Validating Get_planning_rates :p_override_currency_code cannot be null,if p_raw_cost,p_raw_revenue,p_cost_override_rate,p_revenue_override_rate is passed';
470: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
471: END IF;
472: RAISE l_invalid_currency;
473: END IF;

Line 470: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

466: OR (p_cost_override_rate IS NOT NULL OR p_revenue_override_rate IS NOT NULL)) THEN
467: IF p_override_currency_code IS NULL THEN
468: IF g1_debug_mode = 'Y' THEN
469: pa_debug.g_err_stage:='Validating Get_planning_rates :p_override_currency_code cannot be null,if p_raw_cost,p_raw_revenue,p_cost_override_rate,p_revenue_override_rate is passed';
470: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
471: END IF;
472: RAISE l_invalid_currency;
473: END IF;
474: END IF;

Line 479: pa_debug.g_err_stage:='Calling the Get_plan_actual_Rates ';

475:
476: /* Check for using Actual Calculation Flow for Planning Transactions */
477: IF p_use_planning_rates_flag = 'N' THEN
478: IF g1_debug_mode = 'Y' THEN
479: pa_debug.g_err_stage:='Calling the Get_plan_actual_Rates ';
480: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
481: END IF;
482: BEGIN
483: /* Calling the internal Api to get the actual Rates , this API is one to one mapped with the main API for Actuals*/

Line 480: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

476: /* Check for using Actual Calculation Flow for Planning Transactions */
477: IF p_use_planning_rates_flag = 'N' THEN
478: IF g1_debug_mode = 'Y' THEN
479: pa_debug.g_err_stage:='Calling the Get_plan_actual_Rates ';
480: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
481: END IF;
482: BEGIN
483: /* Calling the internal Api to get the actual Rates , this API is one to one mapped with the main API for Actuals*/
484:

Line 568: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;

564:
565:
566:
567: IF g1_debug_mode = 'Y' THEN
568: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;
569: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
570: END IF;
571: IF g1_debug_mode = 'Y' THEN
572: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_burd_cost_rate'||l_txn_burden_cost_rate||'l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code ;

Line 569: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

565:
566:
567: IF g1_debug_mode = 'Y' THEN
568: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;
569: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
570: END IF;
571: IF g1_debug_mode = 'Y' THEN
572: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_burd_cost_rate'||l_txn_burden_cost_rate||'l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code ;
573: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 572: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_burd_cost_rate'||l_txn_burden_cost_rate||'l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code ;

568: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;
569: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
570: END IF;
571: IF g1_debug_mode = 'Y' THEN
572: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_burd_cost_rate'||l_txn_burden_cost_rate||'l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code ;
573: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
574: END IF;
575: IF g1_debug_mode = 'Y' THEN
576: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup ;

Line 573: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

569: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
570: END IF;
571: IF g1_debug_mode = 'Y' THEN
572: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_burd_cost_rate'||l_txn_burden_cost_rate||'l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code ;
573: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
574: END IF;
575: IF g1_debug_mode = 'Y' THEN
576: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup ;
577: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 576: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup ;

572: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_burd_cost_rate'||l_txn_burden_cost_rate||'l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code ;
573: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
574: END IF;
575: IF g1_debug_mode = 'Y' THEN
576: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup ;
577: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
578: END IF;
579: IF g1_debug_mode = 'Y' THEN
580: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'curr_code'||l_rev_txn_curr_code ;

Line 577: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

573: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
574: END IF;
575: IF g1_debug_mode = 'Y' THEN
576: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup ;
577: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
578: END IF;
579: IF g1_debug_mode = 'Y' THEN
580: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'curr_code'||l_rev_txn_curr_code ;
581: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 580: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'curr_code'||l_rev_txn_curr_code ;

576: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup ;
577: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
578: END IF;
579: IF g1_debug_mode = 'Y' THEN
580: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'curr_code'||l_rev_txn_curr_code ;
581: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
582: END IF;
583:
584: EXCEPTION

Line 581: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

577: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
578: END IF;
579: IF g1_debug_mode = 'Y' THEN
580: pa_debug.g_err_stage:='Called the Get_plan_actual_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'curr_code'||l_rev_txn_curr_code ;
581: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
582: END IF;
583:
584: EXCEPTION
585: WHEN OTHERS THEN

Line 597: pa_debug.g_err_stage:=' Get_plan_actual_Rates_api is throwing When Others';

593: l_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
594: l_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
595: l_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
596: IF g1_debug_mode = 'Y' THEN
597: pa_debug.g_err_stage:=' Get_plan_actual_Rates_api is throwing When Others';
598: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
599: END IF;
600: RAISE l_Get_planning_Rates_api;
601: END;

Line 598: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

594: l_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
595: l_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
596: IF g1_debug_mode = 'Y' THEN
597: pa_debug.g_err_stage:=' Get_plan_actual_Rates_api is throwing When Others';
598: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
599: END IF;
600: RAISE l_Get_planning_Rates_api;
601: END;
602: ELSE

Line 607: pa_debug.g_err_stage:='Before Calling the Get_plan_plan_Rates:p_use_planning_rates_flag '||p_use_planning_rates_flag ;

603:
604: -- Call pa_plan_revenue.Get_plan_plan_rates (parameters);
605:
606: IF g1_debug_mode = 'Y' THEN
607: pa_debug.g_err_stage:='Before Calling the Get_plan_plan_Rates:p_use_planning_rates_flag '||p_use_planning_rates_flag ;
608: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
609: END IF;
610: BEGIN
611: Get_plan_plan_Rates (

Line 608: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

604: -- Call pa_plan_revenue.Get_plan_plan_rates (parameters);
605:
606: IF g1_debug_mode = 'Y' THEN
607: pa_debug.g_err_stage:='Before Calling the Get_plan_plan_Rates:p_use_planning_rates_flag '||p_use_planning_rates_flag ;
608: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
609: END IF;
610: BEGIN
611: Get_plan_plan_Rates (
612: p_project_id =>p_project_id ,

Line 678: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data;

674: x_msg_count =>l_x_msg_count
675: );
676:
677: IF g1_debug_mode = 'Y' THEN
678: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data;
679: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
680: END IF;
681: IF g1_debug_mode = 'Y' THEN
682: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:x_cost_rej_code'||l_raw_cost_rejection_code||'l_burden_cost_rate'||l_txn_burden_cost_rate;

Line 679: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

675: );
676:
677: IF g1_debug_mode = 'Y' THEN
678: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data;
679: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
680: END IF;
681: IF g1_debug_mode = 'Y' THEN
682: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:x_cost_rej_code'||l_raw_cost_rejection_code||'l_burden_cost_rate'||l_txn_burden_cost_rate;
683: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 682: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:x_cost_rej_code'||l_raw_cost_rejection_code||'l_burden_cost_rate'||l_txn_burden_cost_rate;

678: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_return_status'||l_x_return_status||'x_msg_data'||l_x_msg_data;
679: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
680: END IF;
681: IF g1_debug_mode = 'Y' THEN
682: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:x_cost_rej_code'||l_raw_cost_rejection_code||'l_burden_cost_rate'||l_txn_burden_cost_rate;
683: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
684: END IF;
685: IF g1_debug_mode = 'Y' THEN
686: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code;

Line 683: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

679: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
680: END IF;
681: IF g1_debug_mode = 'Y' THEN
682: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:x_cost_rej_code'||l_raw_cost_rejection_code||'l_burden_cost_rate'||l_txn_burden_cost_rate;
683: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
684: END IF;
685: IF g1_debug_mode = 'Y' THEN
686: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code;
687: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 686: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code;

682: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:x_cost_rej_code'||l_raw_cost_rejection_code||'l_burden_cost_rate'||l_txn_burden_cost_rate;
683: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
684: END IF;
685: IF g1_debug_mode = 'Y' THEN
686: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code;
687: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
688: END IF;
689: IF g1_debug_mode = 'Y' THEN
690: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup||'l_txn_bill_rate'||l_txn_bill_rate;

Line 687: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

683: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
684: END IF;
685: IF g1_debug_mode = 'Y' THEN
686: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code;
687: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
688: END IF;
689: IF g1_debug_mode = 'Y' THEN
690: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup||'l_txn_bill_rate'||l_txn_bill_rate;
691: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 690: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup||'l_txn_bill_rate'||l_txn_bill_rate;

686: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_cost'||l_raw_cost||'l_cost_rate'||l_txn_cost_rate||'l_cost_curr_code'||l_cost_txn_curr_code;
687: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
688: END IF;
689: IF g1_debug_mode = 'Y' THEN
690: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup||'l_txn_bill_rate'||l_txn_bill_rate;
691: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
692: END IF;
693: IF g1_debug_mode = 'Y' THEN
694: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'revcurr_code'||l_rev_txn_curr_code;

Line 691: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

687: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
688: END IF;
689: IF g1_debug_mode = 'Y' THEN
690: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup||'l_txn_bill_rate'||l_txn_bill_rate;
691: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
692: END IF;
693: IF g1_debug_mode = 'Y' THEN
694: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'revcurr_code'||l_rev_txn_curr_code;
695: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 694: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'revcurr_code'||l_rev_txn_curr_code;

690: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_txn_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_bill_markup||'l_txn_bill_rate'||l_txn_bill_rate;
691: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
692: END IF;
693: IF g1_debug_mode = 'Y' THEN
694: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'revcurr_code'||l_rev_txn_curr_code;
695: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
696: END IF;
697:
698:

Line 695: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

691: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
692: END IF;
693: IF g1_debug_mode = 'Y' THEN
694: pa_debug.g_err_stage:='Called the Get_plan_plan_Rates:l_raw_revenue'||l_raw_revenue ||'rev_rej_code'||l_revenue_rejection_code||'revcurr_code'||l_rev_txn_curr_code;
695: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
696: END IF;
697:
698:
699: EXCEPTION

Line 710: pa_debug.g_err_stage:=' Get_plan_plan_Rates_api is throwing When Others';

706: l_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
707: l_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
708: l_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
709: IF g1_debug_mode = 'Y' THEN
710: pa_debug.g_err_stage:=' Get_plan_plan_Rates_api is throwing When Others';
711: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
712: END IF;
713: RAISE l_Get_planning_Rates_api;
714: END;

Line 711: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

707: l_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
708: l_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
709: IF g1_debug_mode = 'Y' THEN
710: pa_debug.g_err_stage:=' Get_plan_plan_Rates_api is throwing When Others';
711: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
712: END IF;
713: RAISE l_Get_planning_Rates_api;
714: END;
715:

Line 719: pa_debug.g_err_stage:='validating for Calling the Get_plan_res_class_rates ';

715:
716: END IF;/* End of check for calling for Actual or Planning rates Flow */
717:
718: IF g1_debug_mode = 'Y' THEN
719: pa_debug.g_err_stage:='validating for Calling the Get_plan_res_class_rates ';
720: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
721: END IF;
722: /* Calling the Resource Class Schedule if Rate is not computed based on the Actual Enginee */
723: /* here the l_schedule type is set based on l_raw_cost IS NULL OR l_raw_revenue IS NULL and also based

Line 720: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

716: END IF;/* End of check for calling for Actual or Planning rates Flow */
717:
718: IF g1_debug_mode = 'Y' THEN
719: pa_debug.g_err_stage:='validating for Calling the Get_plan_res_class_rates ';
720: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
721: END IF;
722: /* Calling the Resource Class Schedule if Rate is not computed based on the Actual Enginee */
723: /* here the l_schedule type is set based on l_raw_cost IS NULL OR l_raw_revenue IS NULL and also based
724: on the p_calculate_mode also its decided whether to call the ressource class code to get the cost and revenue */

Line 747: pa_debug.g_err_stage:='Before Calling the Get_plan_res_class_rates:->l_schedule_type'||l_schedule_type||' l_raw_revenue'|| l_raw_revenue||'l_raw_cost'||l_raw_cost;

743: l_schedule_type:='COST';
744: END IF;
745: END IF;
746: IF g1_debug_mode = 'Y' THEN
747: pa_debug.g_err_stage:='Before Calling the Get_plan_res_class_rates:->l_schedule_type'||l_schedule_type||' l_raw_revenue'|| l_raw_revenue||'l_raw_cost'||l_raw_cost;
748: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
749: END IF;
750:
751: /* don't remove the NVLs, the idea is to pass the override rate or any derive rates to the output of the main api call */

Line 748: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

744: END IF;
745: END IF;
746: IF g1_debug_mode = 'Y' THEN
747: pa_debug.g_err_stage:='Before Calling the Get_plan_res_class_rates:->l_schedule_type'||l_schedule_type||' l_raw_revenue'|| l_raw_revenue||'l_raw_cost'||l_raw_cost;
748: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
749: END IF;
750:
751: /* don't remove the NVLs, the idea is to pass the override rate or any derive rates to the output of the main api call */
752: /* The overrides should be otherway round, If the overrides present use the overrides else rates present

Line 767: pa_debug.g_err_stage:='Now Calling the Get_plan_res_class_rates:->l_schedule_type'||l_schedule_type||' l_raw_revenue'|| l_raw_revenue||'l_raw_cost'||l_raw_cost;

763: IF ( (l_schedule_type='COST' and l_raw_cost IS NULL )
764: OR (l_schedule_type='REVENUE' and l_raw_revenue IS NULL )
765: OR l_schedule_type IS NULL ) THEN
766: IF g1_debug_mode = 'Y' THEN
767: pa_debug.g_err_stage:='Now Calling the Get_plan_res_class_rates:->l_schedule_type'||l_schedule_type||' l_raw_revenue'|| l_raw_revenue||'l_raw_cost'||l_raw_cost;
768: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
769: END IF;
770: BEGIN
771: Get_plan_res_class_rates (

Line 768: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

764: OR (l_schedule_type='REVENUE' and l_raw_revenue IS NULL )
765: OR l_schedule_type IS NULL ) THEN
766: IF g1_debug_mode = 'Y' THEN
767: pa_debug.g_err_stage:='Now Calling the Get_plan_res_class_rates:->l_schedule_type'||l_schedule_type||' l_raw_revenue'|| l_raw_revenue||'l_raw_cost'||l_raw_cost;
768: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
769: END IF;
770: BEGIN
771: Get_plan_res_class_rates (
772: p_project_type =>p_project_type

Line 832: pa_debug.g_err_stage:=' Get_plan_res_class_rates_api is throwing When Others';

828: l_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
829: l_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
830: l_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
831: IF g1_debug_mode = 'Y' THEN
832: pa_debug.g_err_stage:=' Get_plan_res_class_rates_api is throwing When Others';
833: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
834: END IF;
835: RAISE l_Get_planning_Rates_api;
836: END;

Line 833: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

829: l_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
830: l_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
831: IF g1_debug_mode = 'Y' THEN
832: pa_debug.g_err_stage:=' Get_plan_res_class_rates_api is throwing When Others';
833: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
834: END IF;
835: RAISE l_Get_planning_Rates_api;
836: END;
837: /*++++++++++++++++++++++++++++++++++++++++++++++++++*/

Line 839: pa_debug.g_err_stage:='after Get_plan_res_class_rates :return_status'||l_x_return_status||'msgdata'||l_x_msg_data||'rawcost_rej_code'||l_raw_cost_rejection_code;

835: RAISE l_Get_planning_Rates_api;
836: END;
837: /*++++++++++++++++++++++++++++++++++++++++++++++++++*/
838: IF g1_debug_mode = 'Y' THEN
839: pa_debug.g_err_stage:='after Get_plan_res_class_rates :return_status'||l_x_return_status||'msgdata'||l_x_msg_data||'rawcost_rej_code'||l_raw_cost_rejection_code;
840: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
841: END IF;
842: IF g1_debug_mode = 'Y' THEN
843: pa_debug.g_err_stage:='after Get_plan_res_class_rates :x_revenue_rejection_code'||l_revenue_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;

Line 840: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

836: END;
837: /*++++++++++++++++++++++++++++++++++++++++++++++++++*/
838: IF g1_debug_mode = 'Y' THEN
839: pa_debug.g_err_stage:='after Get_plan_res_class_rates :return_status'||l_x_return_status||'msgdata'||l_x_msg_data||'rawcost_rej_code'||l_raw_cost_rejection_code;
840: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
841: END IF;
842: IF g1_debug_mode = 'Y' THEN
843: pa_debug.g_err_stage:='after Get_plan_res_class_rates :x_revenue_rejection_code'||l_revenue_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
844: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 843: pa_debug.g_err_stage:='after Get_plan_res_class_rates :x_revenue_rejection_code'||l_revenue_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;

839: pa_debug.g_err_stage:='after Get_plan_res_class_rates :return_status'||l_x_return_status||'msgdata'||l_x_msg_data||'rawcost_rej_code'||l_raw_cost_rejection_code;
840: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
841: END IF;
842: IF g1_debug_mode = 'Y' THEN
843: pa_debug.g_err_stage:='after Get_plan_res_class_rates :x_revenue_rejection_code'||l_revenue_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
844: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
845: END IF;
846: IF g1_debug_mode = 'Y' THEN
847: pa_debug.g_err_stage:='after Get_plan_res_class_rates :l_txn_burden_cost'||l_txn_burden_cost||'l_txn_raw_revenue'||l_txn_raw_revenue;

Line 844: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

840: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
841: END IF;
842: IF g1_debug_mode = 'Y' THEN
843: pa_debug.g_err_stage:='after Get_plan_res_class_rates :x_revenue_rejection_code'||l_revenue_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
844: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
845: END IF;
846: IF g1_debug_mode = 'Y' THEN
847: pa_debug.g_err_stage:='after Get_plan_res_class_rates :l_txn_burden_cost'||l_txn_burden_cost||'l_txn_raw_revenue'||l_txn_raw_revenue;
848: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 847: pa_debug.g_err_stage:='after Get_plan_res_class_rates :l_txn_burden_cost'||l_txn_burden_cost||'l_txn_raw_revenue'||l_txn_raw_revenue;

843: pa_debug.g_err_stage:='after Get_plan_res_class_rates :x_revenue_rejection_code'||l_revenue_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
844: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
845: END IF;
846: IF g1_debug_mode = 'Y' THEN
847: pa_debug.g_err_stage:='after Get_plan_res_class_rates :l_txn_burden_cost'||l_txn_burden_cost||'l_txn_raw_revenue'||l_txn_raw_revenue;
848: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
849: END IF;
850: ELSE
851: l_txn_raw_cost := l_raw_cost;

Line 848: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

844: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
845: END IF;
846: IF g1_debug_mode = 'Y' THEN
847: pa_debug.g_err_stage:='after Get_plan_res_class_rates :l_txn_burden_cost'||l_txn_burden_cost||'l_txn_raw_revenue'||l_txn_raw_revenue;
848: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
849: END IF;
850: ELSE
851: l_txn_raw_cost := l_raw_cost;
852: l_txn_burden_cost := l_burden_cost ;

Line 870: pa_debug.g_err_stage:='Setting all the out parameters for thr procedure';

866: END IF;/* IF p_raw_cost IS NOT NULL AND p_burden_cost IS NOT NULL AND p_raw_revenue IS NOT NULL THEN */
867: /* Assigning All the out parameters for the procedure */
868:
869: IF g1_debug_mode = 'Y' THEN
870: pa_debug.g_err_stage:='Setting all the out parameters for thr procedure';
871: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
872: END IF;
873:
874: x_bill_rate :=NVL(l_i_txn_bill_rate,l_txn_bill_rate);--4108291

Line 871: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);

867: /* Assigning All the out parameters for the procedure */
868:
869: IF g1_debug_mode = 'Y' THEN
870: pa_debug.g_err_stage:='Setting all the out parameters for thr procedure';
871: pa_debug.write('Get_planning_rates: ' || g_module_name,pa_debug.g_err_stage,3);
872: END IF;
873:
874: x_bill_rate :=NVL(l_i_txn_bill_rate,l_txn_bill_rate);--4108291
875: x_cost_rate :=NVL(l_i_txn_cost_rate,l_txn_cost_rate) ;--4108291

Line 895: PA_DEBUG.reset_err_stack;

891: x_cost_ind_compiled_set_id :=l_cost_ind_compiled_set_id ;
892: x_return_status :=l_x_return_status;
893: x_msg_data :=l_x_msg_data;
894: x_msg_count :=l_x_msg_count;
895: PA_DEBUG.reset_err_stack;
896: EXCEPTION
897: WHEN l_rate_based_no_quantity THEN
898: IF g1_debug_mode = 'Y' THEN
899: pa_debug.g_err_stage:='Quantity is required for a rate based transaction ';

Line 899: pa_debug.g_err_stage:='Quantity is required for a rate based transaction ';

895: PA_DEBUG.reset_err_stack;
896: EXCEPTION
897: WHEN l_rate_based_no_quantity THEN
898: IF g1_debug_mode = 'Y' THEN
899: pa_debug.g_err_stage:='Quantity is required for a rate based transaction ';
900: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
901: END IF;
902: x_return_status := g_ERROR;
903: x_msg_count := 1;

Line 900: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

896: EXCEPTION
897: WHEN l_rate_based_no_quantity THEN
898: IF g1_debug_mode = 'Y' THEN
899: pa_debug.g_err_stage:='Quantity is required for a rate based transaction ';
900: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
901: END IF;
902: x_return_status := g_ERROR;
903: x_msg_count := 1;
904: x_msg_data := 'PA_EX_QTY_EXIST';

Line 914: PA_DEBUG.reset_err_stack;

910: x_cost_rate := NULL;
911: x_cost_txn_curr_code := NULL ;
912: x_rev_txn_curr_code := NULL ;
913:
914: PA_DEBUG.reset_err_stack;
915: WHEN l_invalid_currency THEN
916: IF g1_debug_mode = 'Y' THEN
917: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered';
918: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

Line 917: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered';

913:
914: PA_DEBUG.reset_err_stack;
915: WHEN l_invalid_currency THEN
916: IF g1_debug_mode = 'Y' THEN
917: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered';
918: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
919: END IF;
920: x_return_status := g_ERROR;
921: x_msg_count := 1;

Line 918: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

914: PA_DEBUG.reset_err_stack;
915: WHEN l_invalid_currency THEN
916: IF g1_debug_mode = 'Y' THEN
917: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered';
918: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
919: END IF;
920: x_return_status := g_ERROR;
921: x_msg_count := 1;
922: x_msg_data := 'PA_INVALID_DENOM_CURRENCY';

Line 932: PA_DEBUG.reset_err_stack;

928: x_cost_rate := NULL ;
929: x_cost_txn_curr_code := NULL ;
930: x_rev_txn_curr_code := NULL ;
931:
932: PA_DEBUG.reset_err_stack;
933: WHEN l_Get_planning_Rates_api THEN
934: IF g1_debug_mode = 'Y' THEN
935: pa_debug.g_err_stage:='plan_actual_Rates r Plan_plan_rates r res_class_rates throwing When Others:p_project_id'||p_project_id||'p_task_id'||p_task_id;
936: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

Line 935: pa_debug.g_err_stage:='plan_actual_Rates r Plan_plan_rates r res_class_rates throwing When Others:p_project_id'||p_project_id||'p_task_id'||p_task_id;

931:
932: PA_DEBUG.reset_err_stack;
933: WHEN l_Get_planning_Rates_api THEN
934: IF g1_debug_mode = 'Y' THEN
935: pa_debug.g_err_stage:='plan_actual_Rates r Plan_plan_rates r res_class_rates throwing When Others:p_project_id'||p_project_id||'p_task_id'||p_task_id;
936: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
937: END IF;
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: x_msg_count := 1;

Line 936: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

932: PA_DEBUG.reset_err_stack;
933: WHEN l_Get_planning_Rates_api THEN
934: IF g1_debug_mode = 'Y' THEN
935: pa_debug.g_err_stage:='plan_actual_Rates r Plan_plan_rates r res_class_rates throwing When Others:p_project_id'||p_project_id||'p_task_id'||p_task_id;
936: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
937: END IF;
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: x_msg_count := 1;
940: x_msg_data := l_x_msg_data ;

Line 952: PA_DEBUG.reset_err_stack;

948: x_cost_txn_curr_code := NULL;
949: x_rev_txn_curr_code := NULL;
950: x_bill_markup_percentage := NULL;
951:
952: PA_DEBUG.reset_err_stack;
953:
954: WHEN OTHERS THEN
955: IF g1_debug_mode = 'Y' THEN
956: pa_debug.g_err_stage:='In the when others of Get_Planning_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id;

Line 956: pa_debug.g_err_stage:='In the when others of Get_Planning_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id;

952: PA_DEBUG.reset_err_stack;
953:
954: WHEN OTHERS THEN
955: IF g1_debug_mode = 'Y' THEN
956: pa_debug.g_err_stage:='In the when others of Get_Planning_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id;
957: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
958: END IF;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: x_msg_count := 1;

Line 957: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

953:
954: WHEN OTHERS THEN
955: IF g1_debug_mode = 'Y' THEN
956: pa_debug.g_err_stage:='In the when others of Get_Planning_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id;
957: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
958: END IF;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: x_msg_count := 1;
961: x_msg_data := 'Get_Planning_Rates'||SUBSTR(SQLERRM,1,250);

Line 973: PA_DEBUG.reset_err_stack;

969: x_cost_txn_curr_code := NULL;
970: x_rev_txn_curr_code := NULL;
971: x_bill_markup_percentage := NULL;
972:
973: PA_DEBUG.reset_err_stack;
974:
975: END Get_Planning_Rates;
976:
977:

Line 1123: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_Actual_Cost_Rates';

1119: END IF;
1120: IF ((p_raw_cost IS NULL OR p_burden_cost IS NULL)
1121: AND p_calculate_mode IN ('COST','COST_REVENUE')) THEN
1122: IF g1_debug_mode = 'Y' THEN
1123: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_Actual_Cost_Rates';
1124: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1125: END IF;
1126:
1127: BEGIN

Line 1124: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1120: IF ((p_raw_cost IS NULL OR p_burden_cost IS NULL)
1121: AND p_calculate_mode IN ('COST','COST_REVENUE')) THEN
1122: IF g1_debug_mode = 'Y' THEN
1123: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_Actual_Cost_Rates';
1124: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1125: END IF;
1126:
1127: BEGIN
1128: PA_COST1.Get_Plan_Actual_Cost_Rates

Line 1173: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_x_return_status'||l_x_return_status||'l_msg_data'||l_cost_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;

1169: ,x_return_status =>l_x_return_status
1170: ,x_error_msg_code =>l_cost_msg_data ) ;
1171:
1172: IF g1_debug_mode = 'Y' THEN
1173: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_x_return_status'||l_x_return_status||'l_msg_data'||l_cost_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;
1174: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1175: END IF;
1176: IF g1_debug_mode = 'Y' THEN
1177: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_burden_rej_code'||l_burden_cost_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;

Line 1174: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

1170: ,x_error_msg_code =>l_cost_msg_data ) ;
1171:
1172: IF g1_debug_mode = 'Y' THEN
1173: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_x_return_status'||l_x_return_status||'l_msg_data'||l_cost_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;
1174: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1175: END IF;
1176: IF g1_debug_mode = 'Y' THEN
1177: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_burden_rej_code'||l_burden_cost_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
1178: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

Line 1177: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_burden_rej_code'||l_burden_cost_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;

1173: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_x_return_status'||l_x_return_status||'l_msg_data'||l_cost_msg_data||'x_cost_rej_code'||l_raw_cost_rejection_code;
1174: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1175: END IF;
1176: IF g1_debug_mode = 'Y' THEN
1177: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_burden_rej_code'||l_burden_cost_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
1178: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1179: END IF;
1180: IF g1_debug_mode = 'Y' THEN
1181: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_txn_cost_rate'||l_txn_cost_rate||'l_trxn_curr_code'||l_trxn_curr_code;

Line 1178: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

1174: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1175: END IF;
1176: IF g1_debug_mode = 'Y' THEN
1177: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_burden_rej_code'||l_burden_cost_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
1178: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1179: END IF;
1180: IF g1_debug_mode = 'Y' THEN
1181: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_txn_cost_rate'||l_txn_cost_rate||'l_trxn_curr_code'||l_trxn_curr_code;
1182: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

Line 1181: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_txn_cost_rate'||l_txn_cost_rate||'l_trxn_curr_code'||l_trxn_curr_code;

1177: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_burden_rej_code'||l_burden_cost_rejection_code||'l_txn_raw_cost'||l_txn_raw_cost;
1178: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1179: END IF;
1180: IF g1_debug_mode = 'Y' THEN
1181: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_txn_cost_rate'||l_txn_cost_rate||'l_trxn_curr_code'||l_trxn_curr_code;
1182: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1183: END IF;
1184: EXCEPTION
1185: WHEN OTHERS THEN

Line 1182: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

1178: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1179: END IF;
1180: IF g1_debug_mode = 'Y' THEN
1181: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:l_txn_cost_rate'||l_txn_cost_rate||'l_trxn_curr_code'||l_trxn_curr_code;
1182: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1183: END IF;
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

Line 1192: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';

1188: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
1189: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1190:
1191: IF g1_debug_mode = 'Y' THEN
1192: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';
1193: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1194: END IF;
1195: RAISE;
1196: -- RAISE l_Get_plan_actual_Rates; /* Added to handle exception return by costing api */

Line 1193: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

1189: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1190:
1191: IF g1_debug_mode = 'Y' THEN
1192: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';
1193: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1194: END IF;
1195: RAISE;
1196: -- RAISE l_Get_plan_actual_Rates; /* Added to handle exception return by costing api */
1197: END;

Line 1253: pa_debug.g_err_stage:='Calling Get_Plan_Actual_Rev_Rates';

1249: END IF;
1250: END IF;
1251:
1252: IF g1_debug_mode = 'Y' THEN
1253: pa_debug.g_err_stage:='Calling Get_Plan_Actual_Rev_Rates';
1254: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1255: END IF;
1256:
1257: Get_Plan_Actual_Rev_Rates (

Line 1254: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1250: END IF;
1251:
1252: IF g1_debug_mode = 'Y' THEN
1253: pa_debug.g_err_stage:='Calling Get_Plan_Actual_Rev_Rates';
1254: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1255: END IF;
1256:
1257: Get_Plan_Actual_Rev_Rates (
1258: p_project_id => p_project_id ,

Line 1315: pa_debug.g_err_stage:='OUT of Get_Plan_Actual_Rev_Rates:l_x_return_status'||l_x_return_status||'l_bill_msg_data'||l_bill_msg_data||'l_txn_raw_revenue'||l_txn_raw_revenue;

1311: x_msg_data => l_bill_msg_data,
1312: x_msg_count => l_bill_msg_count
1313: );
1314: IF g1_debug_mode = 'Y' THEN
1315: pa_debug.g_err_stage:='OUT of Get_Plan_Actual_Rev_Rates:l_x_return_status'||l_x_return_status||'l_bill_msg_data'||l_bill_msg_data||'l_txn_raw_revenue'||l_txn_raw_revenue;
1316: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1317: END IF;
1318:
1319: /* Raising the Billing Exception to pass the error values to the Main Api */

Line 1316: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1312: x_msg_count => l_bill_msg_count
1313: );
1314: IF g1_debug_mode = 'Y' THEN
1315: pa_debug.g_err_stage:='OUT of Get_Plan_Actual_Rev_Rates:l_x_return_status'||l_x_return_status||'l_bill_msg_data'||l_bill_msg_data||'l_txn_raw_revenue'||l_txn_raw_revenue;
1316: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1317: END IF;
1318:
1319: /* Raising the Billing Exception to pass the error values to the Main Api */
1320: IF l_x_return_status <> g_success THEN

Line 1348: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered:p_project_id'||p_project_id||'p_task_id'||p_task_id;

1344: EXCEPTION
1345: WHEN l_invalid_currency THEN
1346:
1347: IF g1_debug_mode = 'Y' THEN
1348: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered:p_project_id'||p_project_id||'p_task_id'||p_task_id;
1349: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1350: END IF;
1351: x_return_status := g_ERROR;
1352: x_msg_count := 1;

Line 1349: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1345: WHEN l_invalid_currency THEN
1346:
1347: IF g1_debug_mode = 'Y' THEN
1348: pa_debug.g_err_stage:='Currecny Override is not entered for the ammounts entered:p_project_id'||p_project_id||'p_task_id'||p_task_id;
1349: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1350: END IF;
1351: x_return_status := g_ERROR;
1352: x_msg_count := 1;
1353: x_msg_data := 'PA_INVALID_DENOM_CURRENCY';

Line 1373: pa_debug.g_err_stage:='No Cost exist for the tranascation:p_project_id'||p_project_id||'p_task_id'||p_task_id;

1369: x_msg_count := 1;
1370:
1371:
1372: IF g1_debug_mode = 'Y' THEN
1373: pa_debug.g_err_stage:='No Cost exist for the tranascation:p_project_id'||p_project_id||'p_task_id'||p_task_id;
1374: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1375: END IF;
1376: WHEN l_bill_api THEN
1377: x_raw_revenue := NULL;

Line 1374: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1370:
1371:
1372: IF g1_debug_mode = 'Y' THEN
1373: pa_debug.g_err_stage:='No Cost exist for the tranascation:p_project_id'||p_project_id||'p_task_id'||p_task_id;
1374: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1375: END IF;
1376: WHEN l_bill_api THEN
1377: x_raw_revenue := NULL;
1378: x_bill_rate := NULL;

Line 1387: pa_debug.g_err_stage:='Billing api is throwing error';

1383: x_msg_data := l_bill_msg_data;
1384: x_msg_count := l_bill_msg_count;
1385:
1386: IF g1_debug_mode = 'Y' THEN
1387: pa_debug.g_err_stage:='Billing api is throwing error';
1388: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1389: END IF;
1390:
1391:

Line 1388: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1384: x_msg_count := l_bill_msg_count;
1385:
1386: IF g1_debug_mode = 'Y' THEN
1387: pa_debug.g_err_stage:='Billing api is throwing error';
1388: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1389: END IF;
1390:
1391:
1392: END Get_plan_actual_Rates;

Line 1493: pa_debug.g_err_stage:='Validating all the input parameters';

1489: l_quantity NUMBER:=NULL; --bug#4284806
1490:
1491: BEGIN
1492: IF g1_debug_mode = 'Y' THEN
1493: pa_debug.g_err_stage:='Validating all the input parameters';
1494: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1495: END IF;
1496:
1497:

Line 1494: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1490:
1491: BEGIN
1492: IF g1_debug_mode = 'Y' THEN
1493: pa_debug.g_err_stage:='Validating all the input parameters';
1494: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1495: END IF;
1496:
1497:
1498: IF p_system_linkage='BTC' THEN

Line 1508: pa_debug.g_err_stage:='Validating Get_plan_actual_rev_Rates:p_override_currency_code is required if passing any overrides';

1504: END IF;
1505:
1506: IF p_revenue_override_rate IS NOT NULL AND p_override_currency_code IS NULL THEN
1507: IF g1_debug_mode = 'Y' THEN
1508: pa_debug.g_err_stage:='Validating Get_plan_actual_rev_Rates:p_override_currency_code is required if passing any overrides';
1509: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1510: END IF;
1511: RAISE l_invalid_currency;
1512: END IF;

Line 1509: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1505:
1506: IF p_revenue_override_rate IS NOT NULL AND p_override_currency_code IS NULL THEN
1507: IF g1_debug_mode = 'Y' THEN
1508: pa_debug.g_err_stage:='Validating Get_plan_actual_rev_Rates:p_override_currency_code is required if passing any overrides';
1509: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1510: END IF;
1511: RAISE l_invalid_currency;
1512: END IF;
1513: IF p_rate_based_flag ='Y' AND p_quantity IS NULL

Line 1516: pa_debug.g_err_stage:='Validating Get_plan_actual_rev_Rates:p_quantity is required for rate based';

1512: END IF;
1513: IF p_rate_based_flag ='Y' AND p_quantity IS NULL
1514: AND NVL(l_override_cost,0)=0 THEN
1515: IF g1_debug_mode = 'Y' THEN
1516: pa_debug.g_err_stage:='Validating Get_plan_actual_rev_Rates:p_quantity is required for rate based';
1517: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1518: END IF;
1519: RAISE l_rate_based_no_quantity;
1520: END IF;

Line 1517: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1513: IF p_rate_based_flag ='Y' AND p_quantity IS NULL
1514: AND NVL(l_override_cost,0)=0 THEN
1515: IF g1_debug_mode = 'Y' THEN
1516: pa_debug.g_err_stage:='Validating Get_plan_actual_rev_Rates:p_quantity is required for rate based';
1517: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1518: END IF;
1519: RAISE l_rate_based_no_quantity;
1520: END IF;
1521: /* If revenue Override rate is not null compute the raw_revenue based on the override rate and the p_quantity or rawCost */

Line 1556: pa_debug.g_err_stage:='Calling PA_REVENUE.Assignment_Rev_Amt';

1552:
1553: /* Going to Call the Core Billing API for Revenue Calculation based on the Resource Class */
1554: IF p_resource_class='PEOPLE' THEN
1555: IF g1_debug_mode = 'Y' THEN
1556: pa_debug.g_err_stage:='Calling PA_REVENUE.Assignment_Rev_Amt';
1557: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1558: END IF;
1559:
1560: PA_REVENUE.Assignment_Rev_Amt(

Line 1557: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1553: /* Going to Call the Core Billing API for Revenue Calculation based on the Resource Class */
1554: IF p_resource_class='PEOPLE' THEN
1555: IF g1_debug_mode = 'Y' THEN
1556: pa_debug.g_err_stage:='Calling PA_REVENUE.Assignment_Rev_Amt';
1557: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1558: END IF;
1559:
1560: PA_REVENUE.Assignment_Rev_Amt(
1561: p_project_id => p_project_id ,

Line 1607: pa_debug.g_err_stage:='assignment_Rev_amount :l_return_status'||l_x_return_status||'l_msg_data'||l_msg_data||'l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_txn_bill_markup;

1603: x_return_status => l_x_return_status ,
1604: x_msg_count => l_msg_count ,
1605: x_msg_data => l_msg_data );
1606: IF g1_debug_mode = 'Y' THEN
1607: pa_debug.g_err_stage:='assignment_Rev_amount :l_return_status'||l_x_return_status||'l_msg_data'||l_msg_data||'l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_txn_bill_markup;
1608: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1609: END IF;
1610:
1611:

Line 1608: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1604: x_msg_count => l_msg_count ,
1605: x_msg_data => l_msg_data );
1606: IF g1_debug_mode = 'Y' THEN
1607: pa_debug.g_err_stage:='assignment_Rev_amount :l_return_status'||l_x_return_status||'l_msg_data'||l_msg_data||'l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_txn_bill_markup;
1608: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1609: END IF;
1610:
1611:
1612: if NVL(p_rate_based_flag,'N') = 'N' then

Line 1625: pa_debug.g_err_stage:='========g_expenditure_type_tbl.COUNT'||g_expenditure_type_tbl.COUNT;

1621: ELSE
1622:
1623: /* Expenditure Type is checked for UOM determination and to calculate p_uom_flag */
1624: IF g1_debug_mode = 'Y' THEN
1625: pa_debug.g_err_stage:='========g_expenditure_type_tbl.COUNT'||g_expenditure_type_tbl.COUNT;
1626: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1627: END IF;
1628:
1629: FOR i IN g_expenditure_type_tbl.FIRST .. g_expenditure_type_tbl.LAST LOOP

Line 1626: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1622:
1623: /* Expenditure Type is checked for UOM determination and to calculate p_uom_flag */
1624: IF g1_debug_mode = 'Y' THEN
1625: pa_debug.g_err_stage:='========g_expenditure_type_tbl.COUNT'||g_expenditure_type_tbl.COUNT;
1626: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1627: END IF;
1628:
1629: FOR i IN g_expenditure_type_tbl.FIRST .. g_expenditure_type_tbl.LAST LOOP
1630: IF p_expenditure_type =g_expenditure_type_tbl(i) THEN

Line 1632: pa_debug.g_err_stage:='expendirure Type is::::'|| g_expenditure_type_tbl(i) ;

1628:
1629: FOR i IN g_expenditure_type_tbl.FIRST .. g_expenditure_type_tbl.LAST LOOP
1630: IF p_expenditure_type =g_expenditure_type_tbl(i) THEN
1631: IF g1_debug_mode = 'Y' THEN
1632: pa_debug.g_err_stage:='expendirure Type is::::'|| g_expenditure_type_tbl(i) ;
1633: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1634: END IF;
1635: IF g_uom_tbl.EXISTS(i) THEN
1636: l_uom := g_uom_tbl(i);

Line 1633: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1629: FOR i IN g_expenditure_type_tbl.FIRST .. g_expenditure_type_tbl.LAST LOOP
1630: IF p_expenditure_type =g_expenditure_type_tbl(i) THEN
1631: IF g1_debug_mode = 'Y' THEN
1632: pa_debug.g_err_stage:='expendirure Type is::::'|| g_expenditure_type_tbl(i) ;
1633: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1634: END IF;
1635: IF g_uom_tbl.EXISTS(i) THEN
1636: l_uom := g_uom_tbl(i);
1637: END IF;

Line 1648: pa_debug.g_err_stage:='l_uom is::::::'|| l_uom||'p_uom '||p_uom||'l_uom_flag'||l_uom_flag ;

1644: ELSE
1645: l_uom_flag:=1 ;
1646: END IF;
1647: IF g1_debug_mode = 'Y' THEN
1648: pa_debug.g_err_stage:='l_uom is::::::'|| l_uom||'p_uom '||p_uom||'l_uom_flag'||l_uom_flag ;
1649: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1650: END IF;
1651:
1652:

Line 1649: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1645: l_uom_flag:=1 ;
1646: END IF;
1647: IF g1_debug_mode = 'Y' THEN
1648: pa_debug.g_err_stage:='l_uom is::::::'|| l_uom||'p_uom '||p_uom||'l_uom_flag'||l_uom_flag ;
1649: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1650: END IF;
1651:
1652:
1653: IF g1_debug_mode = 'Y' THEN

Line 1654: pa_debug.g_err_stage:='Before Calling pa_revenue.Non_Labor_Rev_amount';

1650: END IF;
1651:
1652:
1653: IF g1_debug_mode = 'Y' THEN
1654: pa_debug.g_err_stage:='Before Calling pa_revenue.Non_Labor_Rev_amount';
1655: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1656: END IF;
1657:
1658: pa_revenue.Non_Labor_Rev_amount(

Line 1655: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1651:
1652:
1653: IF g1_debug_mode = 'Y' THEN
1654: pa_debug.g_err_stage:='Before Calling pa_revenue.Non_Labor_Rev_amount';
1655: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1656: END IF;
1657:
1658: pa_revenue.Non_Labor_Rev_amount(
1659: p_called_process =>l_called_process ,

Line 1702: pa_debug.g_err_stage:='Non_Labor_Rev_amount :l_return_status'||l_x_return_status||'l_msg_data'||l_msg_data||'l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_txn_bill_markup;

1698: x_return_status => l_x_return_status,
1699: x_msg_count => l_msg_count,
1700: x_msg_data => l_msg_data);
1701: IF g1_debug_mode = 'Y' THEN
1702: pa_debug.g_err_stage:='Non_Labor_Rev_amount :l_return_status'||l_x_return_status||'l_msg_data'||l_msg_data||'l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_txn_bill_markup;
1703: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1704: END IF;
1705: if NVL(p_rate_based_flag,'N') = 'N' then
1706: l_txn_bill_rate := NULL;

Line 1703: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1699: x_msg_count => l_msg_count,
1700: x_msg_data => l_msg_data);
1701: IF g1_debug_mode = 'Y' THEN
1702: pa_debug.g_err_stage:='Non_Labor_Rev_amount :l_return_status'||l_x_return_status||'l_msg_data'||l_msg_data||'l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate'||l_txn_bill_rate||'l_bill_markup'||l_txn_bill_markup;
1703: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1704: END IF;
1705: if NVL(p_rate_based_flag,'N') = 'N' then
1706: l_txn_bill_rate := NULL;
1707: l_txn_adjusted_bill_rate:=NULL;

Line 1718: pa_debug.g_err_stage:='Get_Plan_Actual_Rev_Rates :l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate:'||l_txn_bill_rate||'l_bill_markup:'||l_txn_bill_markup||'l_txn_adjusted_bill_rate:'||l_txn_adjusted_bill_rate;

1714: END IF;/*IF p_resource_class='PEOPLE' THEN */
1715: END IF;/* End if of l_raw_revenue IS NULL THEN*/
1716:
1717: IF g1_debug_mode = 'Y' THEN
1718: pa_debug.g_err_stage:='Get_Plan_Actual_Rev_Rates :l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate:'||l_txn_bill_rate||'l_bill_markup:'||l_txn_bill_markup||'l_txn_adjusted_bill_rate:'||l_txn_adjusted_bill_rate;
1719: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1720: END IF;
1721: x_raw_revenue :=l_txn_raw_revenue;
1722: x_bill_rate :=NVL(l_txn_adjusted_bill_rate,l_txn_bill_rate) ;--4038485

Line 1719: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1715: END IF;/* End if of l_raw_revenue IS NULL THEN*/
1716:
1717: IF g1_debug_mode = 'Y' THEN
1718: pa_debug.g_err_stage:='Get_Plan_Actual_Rev_Rates :l_raw_revenue'||l_txn_raw_revenue||'l_bill_rate:'||l_txn_bill_rate||'l_bill_markup:'||l_txn_bill_markup||'l_txn_adjusted_bill_rate:'||l_txn_adjusted_bill_rate;
1719: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1720: END IF;
1721: x_raw_revenue :=l_txn_raw_revenue;
1722: x_bill_rate :=NVL(l_txn_adjusted_bill_rate,l_txn_bill_rate) ;--4038485
1723: x_bill_markup_percentage :=l_txn_bill_markup;

Line 1738: pa_debug.g_err_stage:='Billing api is throwing error :p_project_id'||p_project_id||'p_task_id'||p_task_id;

1734: x_msg_data := l_msg_data;
1735: x_msg_count := l_msg_count;
1736:
1737: IF g1_debug_mode = 'Y' THEN
1738: pa_debug.g_err_stage:='Billing api is throwing error :p_project_id'||p_project_id||'p_task_id'||p_task_id;
1739: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1740: END IF;
1741:
1742: WHEN l_rate_based_no_quantity THEN

Line 1739: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1735: x_msg_count := l_msg_count;
1736:
1737: IF g1_debug_mode = 'Y' THEN
1738: pa_debug.g_err_stage:='Billing api is throwing error :p_project_id'||p_project_id||'p_task_id'||p_task_id;
1739: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1740: END IF;
1741:
1742: WHEN l_rate_based_no_quantity THEN
1743: x_raw_revenue :=NULL;

Line 1752: pa_debug.g_err_stage:='Quantity is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';

1748: x_msg_data := 'PA_EX_QTY_EXIST';
1749: x_msg_count := 1;
1750:
1751: IF g1_debug_mode = 'Y' THEN
1752: pa_debug.g_err_stage:='Quantity is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
1753: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1754: END IF;
1755: WHEN l_invalid_currency THEN
1756: x_raw_revenue :=NULL;

Line 1753: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1749: x_msg_count := 1;
1750:
1751: IF g1_debug_mode = 'Y' THEN
1752: pa_debug.g_err_stage:='Quantity is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
1753: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1754: END IF;
1755: WHEN l_invalid_currency THEN
1756: x_raw_revenue :=NULL;
1757: x_bill_rate :=NULL;

Line 1765: pa_debug.g_err_stage:='Override Currency is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';

1761: x_msg_data := 'PA_INVALID_DENOM_CURRENCY';
1762: x_msg_count := 1;
1763:
1764: IF g1_debug_mode = 'Y' THEN
1765: pa_debug.g_err_stage:='Override Currency is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
1766: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1767: END IF;
1768:
1769:

Line 1766: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

1762: x_msg_count := 1;
1763:
1764: IF g1_debug_mode = 'Y' THEN
1765: pa_debug.g_err_stage:='Override Currency is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
1766: pa_debug.write('Get_plan_actual_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1767: END IF;
1768:
1769:
1770: END Get_Plan_Actual_Rev_Rates;

Line 1877: pa_debug.init_err_stack('PA_PLAN_REVENUE.Get_plan_res_class_rates');

1873: l_ovr_msg_data VARCHAR2(1000);
1874:
1875: BEGIN
1876:
1877: pa_debug.init_err_stack('PA_PLAN_REVENUE.Get_plan_res_class_rates');
1878:
1879: IF g1_debug_mode = 'Y' THEN
1880: pa_debug.g_err_stage:='Validating input parameters:->p_schedule_type'||p_schedule_type||'p_rate_based_flag'||p_rate_based_flag||'p_uom'||p_uom||'p_raw_cost'||p_raw_cost||'p_raw_revenue'||p_raw_revenue;
1881: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 1880: pa_debug.g_err_stage:='Validating input parameters:->p_schedule_type'||p_schedule_type||'p_rate_based_flag'||p_rate_based_flag||'p_uom'||p_uom||'p_raw_cost'||p_raw_cost||'p_raw_revenue'||p_raw_revenue;

1876:
1877: pa_debug.init_err_stack('PA_PLAN_REVENUE.Get_plan_res_class_rates');
1878:
1879: IF g1_debug_mode = 'Y' THEN
1880: pa_debug.g_err_stage:='Validating input parameters:->p_schedule_type'||p_schedule_type||'p_rate_based_flag'||p_rate_based_flag||'p_uom'||p_uom||'p_raw_cost'||p_raw_cost||'p_raw_revenue'||p_raw_revenue;
1881: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1882: END IF;
1883: IF g1_debug_mode = 'Y' THEN
1884: pa_debug.g_err_stage:='Validating input parameters:->p_use_planning_rates_flag '||p_use_planning_rates_flag ||'p_plan_burden_cost_sch_id '||p_plan_burden_cost_sch_id ;

Line 1881: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

1877: pa_debug.init_err_stack('PA_PLAN_REVENUE.Get_plan_res_class_rates');
1878:
1879: IF g1_debug_mode = 'Y' THEN
1880: pa_debug.g_err_stage:='Validating input parameters:->p_schedule_type'||p_schedule_type||'p_rate_based_flag'||p_rate_based_flag||'p_uom'||p_uom||'p_raw_cost'||p_raw_cost||'p_raw_revenue'||p_raw_revenue;
1881: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1882: END IF;
1883: IF g1_debug_mode = 'Y' THEN
1884: pa_debug.g_err_stage:='Validating input parameters:->p_use_planning_rates_flag '||p_use_planning_rates_flag ||'p_plan_burden_cost_sch_id '||p_plan_burden_cost_sch_id ;
1885: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 1884: pa_debug.g_err_stage:='Validating input parameters:->p_use_planning_rates_flag '||p_use_planning_rates_flag ||'p_plan_burden_cost_sch_id '||p_plan_burden_cost_sch_id ;

1880: pa_debug.g_err_stage:='Validating input parameters:->p_schedule_type'||p_schedule_type||'p_rate_based_flag'||p_rate_based_flag||'p_uom'||p_uom||'p_raw_cost'||p_raw_cost||'p_raw_revenue'||p_raw_revenue;
1881: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1882: END IF;
1883: IF g1_debug_mode = 'Y' THEN
1884: pa_debug.g_err_stage:='Validating input parameters:->p_use_planning_rates_flag '||p_use_planning_rates_flag ||'p_plan_burden_cost_sch_id '||p_plan_burden_cost_sch_id ;
1885: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1886: END IF;
1887: IF g1_debug_mode = 'Y' THEN
1888: pa_debug.g_err_stage:='Validating input parameters:->p_nlr_organization_id '||p_nlr_organization_id ||'p_expenditure_org_id '||p_expenditure_org_id ||'p_override_to_organz_id '||p_override_to_organz_id;

Line 1885: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

1881: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1882: END IF;
1883: IF g1_debug_mode = 'Y' THEN
1884: pa_debug.g_err_stage:='Validating input parameters:->p_use_planning_rates_flag '||p_use_planning_rates_flag ||'p_plan_burden_cost_sch_id '||p_plan_burden_cost_sch_id ;
1885: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1886: END IF;
1887: IF g1_debug_mode = 'Y' THEN
1888: pa_debug.g_err_stage:='Validating input parameters:->p_nlr_organization_id '||p_nlr_organization_id ||'p_expenditure_org_id '||p_expenditure_org_id ||'p_override_to_organz_id '||p_override_to_organz_id;
1889: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

Line 1888: pa_debug.g_err_stage:='Validating input parameters:->p_nlr_organization_id '||p_nlr_organization_id ||'p_expenditure_org_id '||p_expenditure_org_id ||'p_override_to_organz_id '||p_override_to_organz_id;

1884: pa_debug.g_err_stage:='Validating input parameters:->p_use_planning_rates_flag '||p_use_planning_rates_flag ||'p_plan_burden_cost_sch_id '||p_plan_burden_cost_sch_id ;
1885: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1886: END IF;
1887: IF g1_debug_mode = 'Y' THEN
1888: pa_debug.g_err_stage:='Validating input parameters:->p_nlr_organization_id '||p_nlr_organization_id ||'p_expenditure_org_id '||p_expenditure_org_id ||'p_override_to_organz_id '||p_override_to_organz_id;
1889: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1890: END IF;
1891:
1892: IF g1_debug_mode = 'Y' THEN

Line 1889: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

1885: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1886: END IF;
1887: IF g1_debug_mode = 'Y' THEN
1888: pa_debug.g_err_stage:='Validating input parameters:->p_nlr_organization_id '||p_nlr_organization_id ||'p_expenditure_org_id '||p_expenditure_org_id ||'p_override_to_organz_id '||p_override_to_organz_id;
1889: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1890: END IF;
1891:
1892: IF g1_debug_mode = 'Y' THEN
1893: pa_debug.g_err_stage:='Validating input parameters:->p_rev_res_class_rate_sch_id '||p_rev_res_class_rate_sch_id ||'p_incurred_by_organz_id'||p_incurred_by_organz_id ;

Line 1893: pa_debug.g_err_stage:='Validating input parameters:->p_rev_res_class_rate_sch_id '||p_rev_res_class_rate_sch_id ||'p_incurred_by_organz_id'||p_incurred_by_organz_id ;

1889: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1890: END IF;
1891:
1892: IF g1_debug_mode = 'Y' THEN
1893: pa_debug.g_err_stage:='Validating input parameters:->p_rev_res_class_rate_sch_id '||p_rev_res_class_rate_sch_id ||'p_incurred_by_organz_id'||p_incurred_by_organz_id ;
1894: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1895: END IF;
1896: /* Assigning the parameters to local variables */
1897: l_burden_cost :=p_burden_cost;

Line 1894: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

1890: END IF;
1891:
1892: IF g1_debug_mode = 'Y' THEN
1893: pa_debug.g_err_stage:='Validating input parameters:->p_rev_res_class_rate_sch_id '||p_rev_res_class_rate_sch_id ||'p_incurred_by_organz_id'||p_incurred_by_organz_id ;
1894: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
1895: END IF;
1896: /* Assigning the parameters to local variables */
1897: l_burden_cost :=p_burden_cost;
1898: l_raw_cost := p_raw_cost;

Line 1914: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: either p_resource_class or p_item_date or p_uom is null ';

1910: /* Validating all the required Parameters */
1911: IF p_resource_class IS NULL OR p_item_date IS NULL
1912: OR p_uom IS NULL THEN
1913: IF g1_debug_mode = 'Y' THEN
1914: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: either p_resource_class or p_item_date or p_uom is null ';
1915: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1916: END IF;
1917: RAISE l_insufficeient_param;
1918: ELSE

Line 1915: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

1911: IF p_resource_class IS NULL OR p_item_date IS NULL
1912: OR p_uom IS NULL THEN
1913: IF g1_debug_mode = 'Y' THEN
1914: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: either p_resource_class or p_item_date or p_uom is null ';
1915: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1916: END IF;
1917: RAISE l_insufficeient_param;
1918: ELSE
1919: null;

Line 1926: pa_debug.g_err_stage:='Calculating Costing data';

1922: /* First computing the raw_cost if p_schedule_type is passed COST or NULL
1923: If COST is passed then it'll compute only Costing but if passed nll it'll
1924: compute both Costing as well as Revenue */
1925: IF g1_debug_mode = 'Y' THEN
1926: pa_debug.g_err_stage:='Calculating Costing data';
1927: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1928: END IF;
1929:
1930: IF l_override_organization_id is NULL and p_resource_class = 'PEOPLE' Then

Line 1927: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

1923: If COST is passed then it'll compute only Costing but if passed nll it'll
1924: compute both Costing as well as Revenue */
1925: IF g1_debug_mode = 'Y' THEN
1926: pa_debug.g_err_stage:='Calculating Costing data';
1927: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1928: END IF;
1929:
1930: IF l_override_organization_id is NULL and p_resource_class = 'PEOPLE' Then
1931: IF g1_debug_mode = 'Y' THEN

Line 1932: pa_debug.g_err_stage:='Calling pa_cost.Override_exp_organization api';

1928: END IF;
1929:
1930: IF l_override_organization_id is NULL and p_resource_class = 'PEOPLE' Then
1931: IF g1_debug_mode = 'Y' THEN
1932: pa_debug.g_err_stage:='Calling pa_cost.Override_exp_organization api';
1933: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1934: end if;
1935: BEGIN
1936: pa_cost.Override_exp_organization

Line 1933: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

1929:
1930: IF l_override_organization_id is NULL and p_resource_class = 'PEOPLE' Then
1931: IF g1_debug_mode = 'Y' THEN
1932: pa_debug.g_err_stage:='Calling pa_cost.Override_exp_organization api';
1933: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1934: end if;
1935: BEGIN
1936: pa_cost.Override_exp_organization
1937: (P_item_date => p_item_date

Line 1950: pa_debug.g_err_stage:='pa_cost.Override_exp_organization is throwing When Others'||SUBSTR(SQLERRM,1,250);

1946: );
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: IF g1_debug_mode = 'Y' THEN
1950: pa_debug.g_err_stage:='pa_cost.Override_exp_organization is throwing When Others'||SUBSTR(SQLERRM,1,250);
1951: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1952: END IF;
1953: END;
1954:

Line 1951: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: IF g1_debug_mode = 'Y' THEN
1950: pa_debug.g_err_stage:='pa_cost.Override_exp_organization is throwing When Others'||SUBSTR(SQLERRM,1,250);
1951: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1952: END IF;
1953: END;
1954:
1955: IF g1_debug_mode = 'Y' THEN

Line 1956: pa_debug.g_err_stage:='Return status of pa_cost.Override_exp_organization ['||l_ovr_return_status||

1952: END IF;
1953: END;
1954:
1955: IF g1_debug_mode = 'Y' THEN
1956: pa_debug.g_err_stage:='Return status of pa_cost.Override_exp_organization ['||l_ovr_return_status||
1957: ']msgData['||l_ovr_msg_data||']OverideOrg['||l_override_organization_id||']' ;
1958: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1959: end if;
1960:

Line 1958: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

1954:
1955: IF g1_debug_mode = 'Y' THEN
1956: pa_debug.g_err_stage:='Return status of pa_cost.Override_exp_organization ['||l_ovr_return_status||
1957: ']msgData['||l_ovr_msg_data||']OverideOrg['||l_override_organization_id||']' ;
1958: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1959: end if;
1960:
1961: End If;
1962:

Line 1975: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: p_quantity is required for rate based ';

1971: IF l_raw_cost IS NULL THEN
1972: IF p_rate_based_flag ='Y' THEN
1973: IF p_quantity IS NULL THEN
1974: IF g1_debug_mode = 'Y' THEN
1975: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: p_quantity is required for rate based ';
1976: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1977: END IF;
1978: RAISE l_rate_based_no_quantity;
1979: END IF;

Line 1976: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

1972: IF p_rate_based_flag ='Y' THEN
1973: IF p_quantity IS NULL THEN
1974: IF g1_debug_mode = 'Y' THEN
1975: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: p_quantity is required for rate based ';
1976: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1977: END IF;
1978: RAISE l_rate_based_no_quantity;
1979: END IF;
1980: END IF;

Line 1994: pa_debug.g_err_stage:='Callling Get_Res_Class_Hierarchy_Rate:p_project_id'||p_project_id||'p_task_id'||p_task_id;

1990: l_item_date DATE := p_item_date;
1991: l_res_class_org_id NUMBER := NVL (l_override_organization_id ,NVL(p_incurred_by_organz_id,p_project_organz_id));
1992: BEGIN
1993: IF g1_debug_mode = 'Y' THEN
1994: pa_debug.g_err_stage:='Callling Get_Res_Class_Hierarchy_Rate:p_project_id'||p_project_id||'p_task_id'||p_task_id;
1995: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1996: END IF;
1997: Get_Res_Class_Hierarchy_Rate( p_res_class_rate_sch_id => p_cost_res_class_rate_sch_id,
1998: p_item_date => l_item_date,

Line 1995: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

1991: l_res_class_org_id NUMBER := NVL (l_override_organization_id ,NVL(p_incurred_by_organz_id,p_project_organz_id));
1992: BEGIN
1993: IF g1_debug_mode = 'Y' THEN
1994: pa_debug.g_err_stage:='Callling Get_Res_Class_Hierarchy_Rate:p_project_id'||p_project_id||'p_task_id'||p_task_id;
1995: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
1996: END IF;
1997: Get_Res_Class_Hierarchy_Rate( p_res_class_rate_sch_id => p_cost_res_class_rate_sch_id,
1998: p_item_date => l_item_date,
1999: p_org_id => p_project_org_id ,

Line 2033: pa_debug.g_err_stage:='1002 cost rate : ' || l_cost_rate || 'Raw Cost : '

2029: FETCH C_std_res_class_sch_cost INTO l_cost_rate,l_raw_cost,l_txn_curr_code;
2030: CLOSE C_std_res_class_sch_cost ;
2031:
2032: IF g1_debug_mode = 'Y' THEN
2033: pa_debug.g_err_stage:='1002 cost rate : ' || l_cost_rate || 'Raw Cost : '
2034: || l_raw_cost || 'currency_code : ' || l_txn_curr_code;
2035: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2036: END IF;
2037: END;/*End of declare of cursor declaration for res_class_org_id*/

Line 2035: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

2031:
2032: IF g1_debug_mode = 'Y' THEN
2033: pa_debug.g_err_stage:='1002 cost rate : ' || l_cost_rate || 'Raw Cost : '
2034: || l_raw_cost || 'currency_code : ' || l_txn_curr_code;
2035: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2036: END IF;
2037: END;/*End of declare of cursor declaration for res_class_org_id*/
2038: END IF;/* End of Status check of Hierarcy Rate Procedure */
2039: END;/* End of proceduer call BEGIN */

Line 2080: pa_debug.g_err_stage:='1002 cost rate : ' || l_cost_rate || 'Raw Cost : '

2076: l_raw_cost := Rec_std_res_class_sch_cost.r_cost;
2077: l_txn_curr_code := Rec_std_res_class_sch_cost.rate_currency_code;
2078: END LOOP;
2079: IF g1_debug_mode = 'Y' THEN
2080: pa_debug.g_err_stage:='1002 cost rate : ' || l_cost_rate || 'Raw Cost : '
2081: || l_raw_cost || 'currency_code : ' || l_txn_curr_code;
2082: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2083: END IF;
2084:

Line 2082: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2078: END LOOP;
2079: IF g1_debug_mode = 'Y' THEN
2080: pa_debug.g_err_stage:='1002 cost rate : ' || l_cost_rate || 'Raw Cost : '
2081: || l_raw_cost || 'currency_code : ' || l_txn_curr_code;
2082: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2083: END IF;
2084:
2085: EXCEPTION
2086: WHEN l_more_than_one_row_excep THEN

Line 2093: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

2089: x_msg_count := 1;
2090: x_msg_data := 'TOO_MANY_ROWS';
2091: x_raw_cost_rejection_code :='TOO_MANY_ROWS';
2092: IF g1_debug_mode = 'Y' THEN
2093: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2094: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2095: END IF;
2096: RAISE;
2097: END;/*End of decalre cursor*/

Line 2094: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2090: x_msg_data := 'TOO_MANY_ROWS';
2091: x_raw_cost_rejection_code :='TOO_MANY_ROWS';
2092: IF g1_debug_mode = 'Y' THEN
2093: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2094: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2095: END IF;
2096: RAISE;
2097: END;/*End of decalre cursor*/
2098:

Line 2104: pa_debug.g_err_stage:='9999 l_cost_rate: ' || l_cost_rate||

2100: RAISE l_no_cost;
2101: END IF;
2102:
2103: IF g1_debug_mode = 'Y' THEN
2104: pa_debug.g_err_stage:='9999 l_cost_rate: ' || l_cost_rate||
2105: 'raw_cost : ' ||l_raw_cost || 'currency_code : ' || l_txn_curr_code;
2106: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2107: END IF;
2108:

Line 2106: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2102:
2103: IF g1_debug_mode = 'Y' THEN
2104: pa_debug.g_err_stage:='9999 l_cost_rate: ' || l_cost_rate||
2105: 'raw_cost : ' ||l_raw_cost || 'currency_code : ' || l_txn_curr_code;
2106: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2107: END IF;
2108:
2109: END IF;/* End of IF l_raw_cost */
2110:

Line 2119: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;

2115: x_msg_data:= 'PA_FCST_NO_COST_RATE';
2116: x_raw_cost_rejection_code := 'PA_FCST_NO_COST_RATE';
2117: x_msg_count := 1;
2118: IF g1_debug_mode = 'Y' THEN
2119: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2120: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2121: END IF;
2122:
2123: WHEN OTHERS THEN

Line 2120: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

2116: x_raw_cost_rejection_code := 'PA_FCST_NO_COST_RATE';
2117: x_msg_count := 1;
2118: IF g1_debug_mode = 'Y' THEN
2119: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2120: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2121: END IF;
2122:
2123: WHEN OTHERS THEN
2124: x_raw_cost:= NULL;

Line 2131: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

2127: x_msg_data := SUBSTR(SQLERRM,1,30);
2128: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2129:
2130: IF g1_debug_mode = 'Y' THEN
2131: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2132: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2133: END IF;
2134:
2135: RAISE;

Line 2132: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2128: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2129:
2130: IF g1_debug_mode = 'Y' THEN
2131: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2132: pa_debug.write('Get_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2133: END IF;
2134:
2135: RAISE;
2136:

Line 2157: pa_debug.g_err_stage := 'Assignging override burden cost values to out params';

2153: IF l_burden_cost is NOT NULL Then
2154:
2155: --assigning override burden cost/or derived burden cost from Actual
2156: IF g1_debug_mode = 'Y' THEN
2157: pa_debug.g_err_stage := 'Assignging override burden cost values to out params';
2158: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2159: END IF;
2160: l_txn_burden_cost :=l_burden_cost;
2161: IF (p_quantity <> 0 ) THEN

Line 2158: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2154:
2155: --assigning override burden cost/or derived burden cost from Actual
2156: IF g1_debug_mode = 'Y' THEN
2157: pa_debug.g_err_stage := 'Assignging override burden cost values to out params';
2158: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2159: END IF;
2160: l_txn_burden_cost :=l_burden_cost;
2161: IF (p_quantity <> 0 ) THEN
2162: l_txn_burden_cost_rate := l_burden_cost / NVL(p_quantity,1) ;

Line 2173: pa_debug.g_err_stage := 'calling pa_cost1.Get_burden_sch_details fro burden cost';

2169: and l_raw_cost is NOT NULL and l_cost_rate is NOT NULL
2170: and pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) Then
2171: l_burd_organization_id := NVL(l_override_organization_id, NVl(p_incurred_by_organz_id ,p_nlr_organization_id));
2172: IF g1_debug_mode = 'Y' THEN
2173: pa_debug.g_err_stage := 'calling pa_cost1.Get_burden_sch_details fro burden cost';
2174: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2175: END IF;
2176:
2177: begin

Line 2174: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2170: and pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) Then
2171: l_burd_organization_id := NVL(l_override_organization_id, NVl(p_incurred_by_organz_id ,p_nlr_organization_id));
2172: IF g1_debug_mode = 'Y' THEN
2173: pa_debug.g_err_stage := 'calling pa_cost1.Get_burden_sch_details fro burden cost';
2174: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2175: END IF;
2176:
2177: begin
2178:

Line 2211: pa_debug.g_err_stage := 'Error while Calculating burden costs';

2207: l_cost_msg_data := 'GET_BURDEN_DETAILS: '||substr(sqlerrm,1,30);
2208: end;
2209: If ( l_cost_return_status <> g_success OR l_txn_burden_multiplier is NULL ) Then
2210: IF g1_debug_mode = 'Y' THEN
2211: pa_debug.g_err_stage := 'Error while Calculating burden costs';
2212: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2213: END IF;
2214: l_burden_cost_rejection_code := l_cost_msg_data;
2215:

Line 2212: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2208: end;
2209: If ( l_cost_return_status <> g_success OR l_txn_burden_multiplier is NULL ) Then
2210: IF g1_debug_mode = 'Y' THEN
2211: pa_debug.g_err_stage := 'Error while Calculating burden costs';
2212: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2213: END IF;
2214: l_burden_cost_rejection_code := l_cost_msg_data;
2215:
2216: -------------------------------------------------------

Line 2236: pa_debug.g_err_stage := 'Calculating burden cost based on override burden multiplier ';

2232: End if;
2233: end if;
2234: Elsif p_override_burden_cost_rate is NOT NULL and l_burden_cost is NULL Then
2235: IF g1_debug_mode = 'Y' THEN
2236: pa_debug.g_err_stage := 'Calculating burden cost based on override burden multiplier ';
2237: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2238: END IF;
2239:
2240: l_txn_burden_cost := p_quantity * p_override_burden_cost_rate;

Line 2237: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2233: end if;
2234: Elsif p_override_burden_cost_rate is NOT NULL and l_burden_cost is NULL Then
2235: IF g1_debug_mode = 'Y' THEN
2236: pa_debug.g_err_stage := 'Calculating burden cost based on override burden multiplier ';
2237: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2238: END IF;
2239:
2240: l_txn_burden_cost := p_quantity * p_override_burden_cost_rate;
2241: l_txn_burden_cost_rate := p_override_burden_cost_rate;

Line 2249: pa_debug.g_err_stage := 'Copying raw costs to burden costs';

2245:
2246: ElsIF l_raw_cost IS NOT NULL THEN
2247: --copy the raw cost to the burden costs
2248: IF g1_debug_mode = 'Y' THEN
2249: pa_debug.g_err_stage := 'Copying raw costs to burden costs';
2250: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2251: END IF;
2252: l_txn_burden_cost := l_raw_cost;
2253: l_txn_burden_cost_rate := l_cost_rate;

Line 2250: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2246: ElsIF l_raw_cost IS NOT NULL THEN
2247: --copy the raw cost to the burden costs
2248: IF g1_debug_mode = 'Y' THEN
2249: pa_debug.g_err_stage := 'Copying raw costs to burden costs';
2250: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2251: END IF;
2252: l_txn_burden_cost := l_raw_cost;
2253: l_txn_burden_cost_rate := l_cost_rate;
2254: l_txn_burden_multiplier := 0;

Line 2274: pa_debug.g_err_stage := 'Going to calculate revenue:->p_schedule_type'||p_schedule_type||'l_raw_revenue'||l_raw_revenue||'l_raw_cost'||l_raw_cost||'l_txn_burden_cost'||l_txn_burden_cost;

2270: x_burden_cost_rejection_code:= l_burden_cost_rejection_code;
2271:
2272: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
2273: IF g1_debug_mode = 'Y' THEN
2274: pa_debug.g_err_stage := 'Going to calculate revenue:->p_schedule_type'||p_schedule_type||'l_raw_revenue'||l_raw_revenue||'l_raw_cost'||l_raw_cost||'l_txn_burden_cost'||l_txn_burden_cost;
2275: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2276: END IF;
2277:
2278: IF NVL(p_schedule_type,'REVENUE')='REVENUE' THEN

Line 2275: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2271:
2272: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
2273: IF g1_debug_mode = 'Y' THEN
2274: pa_debug.g_err_stage := 'Going to calculate revenue:->p_schedule_type'||p_schedule_type||'l_raw_revenue'||l_raw_revenue||'l_raw_cost'||l_raw_cost||'l_txn_burden_cost'||l_txn_burden_cost;
2275: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2276: END IF;
2277:
2278: IF NVL(p_schedule_type,'REVENUE')='REVENUE' THEN
2279: IF p_system_linkage='BTC' THEN

Line 2292: pa_debug.g_err_stage := 'p_quanity is directly getting converted to l_raw_cost for only REVENUE mode:l_raw_cost'||l_raw_cost;

2288: IF NVL(p_rate_based_flag,'N') ='N' THEN
2289: l_raw_cost:=p_quantity;
2290: END IF;
2291: IF g1_debug_mode = 'Y' THEN
2292: pa_debug.g_err_stage := 'p_quanity is directly getting converted to l_raw_cost for only REVENUE mode:l_raw_cost'||l_raw_cost;
2293: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2294: END IF;
2295: END IF;
2296:

Line 2293: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

2289: l_raw_cost:=p_quantity;
2290: END IF;
2291: IF g1_debug_mode = 'Y' THEN
2292: pa_debug.g_err_stage := 'p_quanity is directly getting converted to l_raw_cost for only REVENUE mode:l_raw_cost'||l_raw_cost;
2293: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2294: END IF;
2295: END IF;
2296:
2297: IF l_raw_revenue IS NULL THEN

Line 2305: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: p_quantity is required for rate based ';

2301: END IF;
2302: IF p_rate_based_flag ='Y' THEN
2303: IF p_quantity IS NULL THEN
2304: IF g1_debug_mode = 'Y' THEN
2305: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: p_quantity is required for rate based ';
2306: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2307: END IF;
2308: RAISE l_rate_based_no_quantity;
2309: END IF;

Line 2306: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

2302: IF p_rate_based_flag ='Y' THEN
2303: IF p_quantity IS NULL THEN
2304: IF g1_debug_mode = 'Y' THEN
2305: pa_debug.g_err_stage:='validating Get_plan_res_class_rates: p_quantity is required for rate based ';
2306: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2307: END IF;
2308: RAISE l_rate_based_no_quantity;
2309: END IF;
2310: END IF;

Line 2372: pa_debug.g_err_stage:='1002 bill rate : ' || l_bill_rate || 'Revenue : '

2368: FETCH C_std_res_class_sch_rev INTO l_bill_rate ,l_raw_revenue ,l_bill_txn_curr_code,l_markup ;
2369: CLOSE C_std_res_class_sch_rev;
2370:
2371: IF g1_debug_mode = 'Y' THEN
2372: pa_debug.g_err_stage:='1002 bill rate : ' || l_bill_rate || 'Revenue : '
2373: || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2374: pa_debug.write('Get_plan_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2375: END IF;
2376:

Line 2374: pa_debug.write('Get_plan_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2370:
2371: IF g1_debug_mode = 'Y' THEN
2372: pa_debug.g_err_stage:='1002 bill rate : ' || l_bill_rate || 'Revenue : '
2373: || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2374: pa_debug.write('Get_plan_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2375: END IF;
2376:
2377: END;/*End of declare of cursor declaration for C_std_res_class_sch_rev*/
2378:

Line 2434: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||

2430:
2431: END LOOP;
2432:
2433: IF g1_debug_mode = 'Y' THEN
2434: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2435: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2436: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2437: END IF;
2438: EXCEPTION

Line 2436: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2432:
2433: IF g1_debug_mode = 'Y' THEN
2434: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2435: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2436: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2437: END IF;
2438: EXCEPTION
2439: WHEN l_more_than_one_row_excep THEN
2440: x_raw_revenue:= NULL;

Line 2447: pa_debug.g_err_stage:='Too many Rows';

2443: x_msg_data := 'TOO_MANY_ROWS';
2444: x_revenue_rejection_code := 'TOO_MANY_ROWS';
2445:
2446: IF g1_debug_mode = 'Y' THEN
2447: pa_debug.g_err_stage:='Too many Rows';
2448: pa_debug.write('Get_plan_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2449: END IF;
2450:
2451: RAISE;

Line 2448: pa_debug.write('Get_plan_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2444: x_revenue_rejection_code := 'TOO_MANY_ROWS';
2445:
2446: IF g1_debug_mode = 'Y' THEN
2447: pa_debug.g_err_stage:='Too many Rows';
2448: pa_debug.write('Get_plan_Res_Class_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2449: END IF;
2450:
2451: RAISE;
2452:

Line 2470: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||

2466: x_rev_txn_curr_code := l_bill_txn_curr_code ;
2467: x_return_status := l_x_return_status;
2468:
2469: IF g1_debug_mode = 'Y' THEN
2470: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2471: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2472: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2473: END IF;
2474:

Line 2472: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2468:
2469: IF g1_debug_mode = 'Y' THEN
2470: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2471: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2472: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2473: END IF;
2474:
2475: EXCEPTION
2476: WHEN l_no_revenue THEN

Line 2497: pa_debug.reset_err_stack;

2493: x_bill_markup_percentage := l_markup ;
2494: x_rev_txn_curr_code := NVL(l_bill_txn_curr_code,p_override_txn_currency_code) ;
2495: x_return_status := l_x_return_status;
2496:
2497: pa_debug.reset_err_stack;
2498: EXCEPTION
2499: WHEN l_insufficeient_param THEN
2500: IF g1_debug_mode = 'Y' THEN
2501: pa_debug.g_err_stage:='All the Required parameters are not passes to Resource Schedule';

Line 2501: pa_debug.g_err_stage:='All the Required parameters are not passes to Resource Schedule';

2497: pa_debug.reset_err_stack;
2498: EXCEPTION
2499: WHEN l_insufficeient_param THEN
2500: IF g1_debug_mode = 'Y' THEN
2501: pa_debug.g_err_stage:='All the Required parameters are not passes to Resource Schedule';
2502: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
2503: END IF;
2504: x_return_status := g_ERROR;
2505: x_msg_count := 1;

Line 2502: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

2498: EXCEPTION
2499: WHEN l_insufficeient_param THEN
2500: IF g1_debug_mode = 'Y' THEN
2501: pa_debug.g_err_stage:='All the Required parameters are not passes to Resource Schedule';
2502: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
2503: END IF;
2504: x_return_status := g_ERROR;
2505: x_msg_count := 1;
2506: x_msg_data := 'PA_FCST_INSUFFICIENT_PARA';

Line 2515: pa_debug.reset_err_stack;

2511: x_raw_cost := NULL;
2512: x_bill_rate := NULL;
2513: x_cost_rate := NULL;
2514:
2515: pa_debug.reset_err_stack;
2516:
2517: WHEN l_rate_based_no_quantity THEN
2518: IF g1_debug_mode = 'Y' THEN
2519: pa_debug.g_err_stage:='Quantity is required for a rate based transaction';

Line 2519: pa_debug.g_err_stage:='Quantity is required for a rate based transaction';

2515: pa_debug.reset_err_stack;
2516:
2517: WHEN l_rate_based_no_quantity THEN
2518: IF g1_debug_mode = 'Y' THEN
2519: pa_debug.g_err_stage:='Quantity is required for a rate based transaction';
2520: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
2521: END IF;
2522: x_return_status := g_ERROR;
2523: x_msg_count := 1;

Line 2520: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

2516:
2517: WHEN l_rate_based_no_quantity THEN
2518: IF g1_debug_mode = 'Y' THEN
2519: pa_debug.g_err_stage:='Quantity is required for a rate based transaction';
2520: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
2521: END IF;
2522: x_return_status := g_ERROR;
2523: x_msg_count := 1;
2524: x_msg_data := 'PA_EX_QTY_EXIST';

Line 2532: pa_debug.reset_err_stack;

2528: x_raw_cost := NULL;
2529: x_bill_rate := NULL;
2530: x_cost_rate := NULL;
2531:
2532: pa_debug.reset_err_stack;
2533: WHEN l_no_cost THEN
2534: x_raw_revenue := NULL;
2535: x_raw_cost := NULL;
2536: x_bill_rate := NULL;

Line 2545: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;

2541: x_burden_cost_rejection_code := 'PA_FCST_NO_COST_RATE';
2542: x_revenue_rejection_code := 'PA_FCST_NO_COST_RATE';
2543: x_msg_count := 1;
2544: IF g1_debug_mode = 'Y' THEN
2545: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2546: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2547: END IF;
2548:
2549: pa_debug.reset_err_stack;

Line 2546: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

2542: x_revenue_rejection_code := 'PA_FCST_NO_COST_RATE';
2543: x_msg_count := 1;
2544: IF g1_debug_mode = 'Y' THEN
2545: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2546: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2547: END IF;
2548:
2549: pa_debug.reset_err_stack;
2550: WHEN l_no_revenue THEN

Line 2549: pa_debug.reset_err_stack;

2545: pa_debug.g_err_stage:='No Cost Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2546: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2547: END IF;
2548:
2549: pa_debug.reset_err_stack;
2550: WHEN l_no_revenue THEN
2551: x_raw_revenue := NULL;
2552: x_bill_rate := NULL;
2553: x_return_status := NVL(l_inter_return_status,g_ERROR);

Line 2558: pa_debug.g_err_stage:='No Bill Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;

2554: x_msg_data := 'PA_FCST_NO_BILL_RATE';
2555: x_revenue_rejection_code := 'PA_FCST_NO_BILL_RATE';
2556: x_msg_count := 1;
2557: IF g1_debug_mode = 'Y' THEN
2558: pa_debug.g_err_stage:='No Bill Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2559: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2560: END IF;
2561:
2562: pa_debug.reset_err_stack;

Line 2559: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);

2555: x_revenue_rejection_code := 'PA_FCST_NO_BILL_RATE';
2556: x_msg_count := 1;
2557: IF g1_debug_mode = 'Y' THEN
2558: pa_debug.g_err_stage:='No Bill Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2559: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2560: END IF;
2561:
2562: pa_debug.reset_err_stack;
2563:

Line 2562: pa_debug.reset_err_stack;

2558: pa_debug.g_err_stage:='No Bill Rate Exists:p_project_id'||p_project_id||'p_task_id'||p_task_id;
2559: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2560: END IF;
2561:
2562: pa_debug.reset_err_stack;
2563:
2564: WHEN OTHERS THEN
2565: x_raw_revenue := NULL;
2566: x_raw_cost := NULL;

Line 2577: pa_debug.g_err_stage:='SQLERROR ' || SQLCODE;

2573: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2574: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2575:
2576: IF g1_debug_mode = 'Y' THEN
2577: pa_debug.g_err_stage:='SQLERROR ' || SQLCODE;
2578: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,5);
2579: END IF;
2580:
2581: pa_debug.reset_err_stack;

Line 2578: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,5);

2574: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2575:
2576: IF g1_debug_mode = 'Y' THEN
2577: pa_debug.g_err_stage:='SQLERROR ' || SQLCODE;
2578: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,5);
2579: END IF;
2580:
2581: pa_debug.reset_err_stack;
2582: RAISE;

Line 2581: pa_debug.reset_err_stack;

2577: pa_debug.g_err_stage:='SQLERROR ' || SQLCODE;
2578: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,5);
2579: END IF;
2580:
2581: pa_debug.reset_err_stack;
2582: RAISE;
2583:
2584:
2585:

Line 2767: pa_debug.g_err_stage:='Validating all the input parameters';

2763:
2764:
2765: BEGIN
2766: IF g1_debug_mode = 'Y' THEN
2767: pa_debug.g_err_stage:='Validating all the input parameters';
2768: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2769: END IF;
2770:
2771: IF p_system_linkage='BTC' THEN

Line 2768: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2764:
2765: BEGIN
2766: IF g1_debug_mode = 'Y' THEN
2767: pa_debug.g_err_stage:='Validating all the input parameters';
2768: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2769: END IF;
2770:
2771: IF p_system_linkage='BTC' THEN
2772: l_override_cost := p_burden_cost;

Line 2781: pa_debug.g_err_stage:='Validating Get_plan_plan_rev_Rates:p_quantity is required for rate based';

2777: l_raw_cost := p_raw_cost; -- Added for bug 5039918
2778:
2779: IF p_rate_based_flag ='Y' AND p_quantity IS NULL AND NVL(l_override_cost,0)=0 THEN
2780: IF g1_debug_mode = 'Y' THEN
2781: pa_debug.g_err_stage:='Validating Get_plan_plan_rev_Rates:p_quantity is required for rate based';
2782: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2783: END IF;
2784: RAISE l_rate_based_no_quantity;
2785: END IF;

Line 2782: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2778:
2779: IF p_rate_based_flag ='Y' AND p_quantity IS NULL AND NVL(l_override_cost,0)=0 THEN
2780: IF g1_debug_mode = 'Y' THEN
2781: pa_debug.g_err_stage:='Validating Get_plan_plan_rev_Rates:p_quantity is required for rate based';
2782: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2783: END IF;
2784: RAISE l_rate_based_no_quantity;
2785: END IF;
2786: IF p_revenue_override_rate IS NOT NULL AND p_override_currency_code IS NULL THEN

Line 2788: pa_debug.g_err_stage:='Validating Get_plan_plan_rev_Rates:p_override_currency_code is required if passing any overrides';

2784: RAISE l_rate_based_no_quantity;
2785: END IF;
2786: IF p_revenue_override_rate IS NOT NULL AND p_override_currency_code IS NULL THEN
2787: IF g1_debug_mode = 'Y' THEN
2788: pa_debug.g_err_stage:='Validating Get_plan_plan_rev_Rates:p_override_currency_code is required if passing any overrides';
2789: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2790: END IF;
2791: RAISE l_invalid_currency;
2792: END IF;

Line 2789: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2785: END IF;
2786: IF p_revenue_override_rate IS NOT NULL AND p_override_currency_code IS NULL THEN
2787: IF g1_debug_mode = 'Y' THEN
2788: pa_debug.g_err_stage:='Validating Get_plan_plan_rev_Rates:p_override_currency_code is required if passing any overrides';
2789: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2790: END IF;
2791: RAISE l_invalid_currency;
2792: END IF;
2793: /* If revenue Override rate is not null compute the raw_revenue based on the override rate and the p_quantity or rawCost */

Line 2813: pa_debug.g_err_stage:='Deriving Planning rates based on planning rate schedules for emp and job';

2809: IF l_txn_raw_revenue IS NULL THEN
2810: /* Deriving Planning rates based on planning rate schedules for emp n job and non labor*/
2811: IF p_resource_class='PEOPLE' THEN
2812: IF g1_debug_mode = 'Y' THEN
2813: pa_debug.g_err_stage:='Deriving Planning rates based on planning rate schedules for emp and job';
2814: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2815: END IF;
2816: /* Checking for Employee based Rates*/
2817: BEGIN

Line 2814: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2810: /* Deriving Planning rates based on planning rate schedules for emp n job and non labor*/
2811: IF p_resource_class='PEOPLE' THEN
2812: IF g1_debug_mode = 'Y' THEN
2813: pa_debug.g_err_stage:='Deriving Planning rates based on planning rate schedules for emp and job';
2814: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2815: END IF;
2816: /* Checking for Employee based Rates*/
2817: BEGIN
2818: -- Opening cursor and fetching row

Line 2836: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||

2832: l_markup := Rec_std_emp_sch_rev.markup;
2833:
2834: END LOOP;
2835: IF g1_debug_mode = 'Y' THEN
2836: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2837: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2838: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,2);
2839: END IF;
2840: EXCEPTION

Line 2838: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,2);

2834: END LOOP;
2835: IF g1_debug_mode = 'Y' THEN
2836: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2837: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2838: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,2);
2839: END IF;
2840: EXCEPTION
2841: WHEN l_more_than_one_row_excep THEN
2842: x_raw_revenue:= NULL;

Line 2849: pa_debug.g_err_stage:='Too many Rows';

2845: x_msg_data := 'TOO_MANY_ROWS';
2846:
2847:
2848: IF g1_debug_mode = 'Y' THEN
2849: pa_debug.g_err_stage:='Too many Rows';
2850: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2851: END IF;
2852:
2853: RAISE;

Line 2850: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2846:
2847:
2848: IF g1_debug_mode = 'Y' THEN
2849: pa_debug.g_err_stage:='Too many Rows';
2850: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2851: END IF;
2852:
2853: RAISE;
2854: END;/*End of decalre cursor*/

Line 2902: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||

2898: l_markup := Rec_std_job_sch_rev.markup;
2899:
2900: END LOOP;
2901: IF g1_debug_mode = 'Y' THEN
2902: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2903: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2904: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2905: END IF;
2906: EXCEPTION

Line 2904: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2900: END LOOP;
2901: IF g1_debug_mode = 'Y' THEN
2902: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2903: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2904: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2905: END IF;
2906: EXCEPTION
2907: WHEN l_more_than_one_row_excep THEN
2908: x_raw_revenue:= NULL;

Line 2915: pa_debug.g_err_stage:='Too many Rows';

2911: x_msg_data := 'TOO_MANY_ROWS';
2912:
2913:
2914: IF g1_debug_mode = 'Y' THEN
2915: pa_debug.g_err_stage:='Too many Rows';
2916: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2917: END IF;
2918:
2919: RAISE;

Line 2916: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2912:
2913:
2914: IF g1_debug_mode = 'Y' THEN
2915: pa_debug.g_err_stage:='Too many Rows';
2916: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2917: END IF;
2918:
2919: RAISE;
2920: END;/*End of decalre cursor*/

Line 2946: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||

2942: l_markup := Rec_std_nl_sch_rev.markup;
2943:
2944: END LOOP;
2945: IF g1_debug_mode = 'Y' THEN
2946: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2947: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2948: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2949: END IF;
2950: EXCEPTION

Line 2948: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2944: END LOOP;
2945: IF g1_debug_mode = 'Y' THEN
2946: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2947: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2948: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2949: END IF;
2950: EXCEPTION
2951: WHEN l_more_than_one_row_excep THEN
2952: x_raw_revenue:= NULL;

Line 2959: pa_debug.g_err_stage:='Too many Rows in non labor based on Non Labor Resources';

2955: x_msg_data := 'TOO_MANY_ROWS';
2956:
2957:
2958: IF g1_debug_mode = 'Y' THEN
2959: pa_debug.g_err_stage:='Too many Rows in non labor based on Non Labor Resources';
2960: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2961: END IF;
2962:
2963: RAISE;

Line 2960: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2956:
2957:
2958: IF g1_debug_mode = 'Y' THEN
2959: pa_debug.g_err_stage:='Too many Rows in non labor based on Non Labor Resources';
2960: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
2961: END IF;
2962:
2963: RAISE;
2964: END;/*End of decalre cursor*/

Line 2987: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||

2983: l_markup := Rec_std_nl_sch_rev.markup;
2984:
2985: END LOOP;
2986: IF g1_debug_mode = 'Y' THEN
2987: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2988: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2989: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2990: END IF;
2991: EXCEPTION

Line 2989: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

2985: END LOOP;
2986: IF g1_debug_mode = 'Y' THEN
2987: pa_debug.g_err_stage:='l_bill_rate: ' || l_bill_rate ||
2988: 'Revenue : ' || l_raw_revenue || 'currency_code : ' || l_bill_txn_curr_code;
2989: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
2990: END IF;
2991: EXCEPTION
2992: WHEN l_more_than_one_row_excep THEN
2993: x_raw_revenue:= NULL;

Line 3000: pa_debug.g_err_stage:='Too many Rows in non labor based on expenditure Type';

2996: x_msg_data := 'TOO_MANY_ROWS';
2997:
2998:
2999: IF g1_debug_mode = 'Y' THEN
3000: pa_debug.g_err_stage:='Too many Rows in non labor based on expenditure Type';
3001: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
3002: END IF;
3003:
3004: RAISE;

Line 3001: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);

2997:
2998:
2999: IF g1_debug_mode = 'Y' THEN
3000: pa_debug.g_err_stage:='Too many Rows in non labor based on expenditure Type';
3001: pa_debug.write('Get_plan_plan_rev_Rates: ' || g_module_name,pa_debug.g_err_stage,5);
3002: END IF;
3003:
3004: RAISE;
3005: END;/*End of decalre cursor*/

Line 3011: pa_debug.g_err_stage:='Deriving Planning rates based on planning rate schedules for Non Labor';

3007: END IF;/* If l_raw_revenue IS NULL */
3008:
3009:
3010: IF g1_debug_mode = 'Y' THEN
3011: pa_debug.g_err_stage:='Deriving Planning rates based on planning rate schedules for Non Labor';
3012: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3013: END IF;
3014: END IF;
3015: END IF ;/* End of l_txn_raw_revenue IS NULL */

Line 3012: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3008:
3009:
3010: IF g1_debug_mode = 'Y' THEN
3011: pa_debug.g_err_stage:='Deriving Planning rates based on planning rate schedules for Non Labor';
3012: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3013: END IF;
3014: END IF;
3015: END IF ;/* End of l_txn_raw_revenue IS NULL */
3016:

Line 3036: pa_debug.g_err_stage:='Override Currency is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';

3032: x_msg_data := 'PA_INVALID_DENOM_CURRENCY';
3033: x_msg_count := 1;
3034:
3035: IF g1_debug_mode = 'Y' THEN
3036: pa_debug.g_err_stage:='Override Currency is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
3037: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3038: END IF;
3039: WHEN l_rate_based_no_quantity THEN
3040: x_raw_revenue :=NULL;

Line 3037: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3033: x_msg_count := 1;
3034:
3035: IF g1_debug_mode = 'Y' THEN
3036: pa_debug.g_err_stage:='Override Currency is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
3037: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3038: END IF;
3039: WHEN l_rate_based_no_quantity THEN
3040: x_raw_revenue :=NULL;
3041: x_bill_rate :=NULL;

Line 3049: pa_debug.g_err_stage:='Quantity is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';

3045: x_msg_data := 'PA_EX_QTY_EXIST';
3046: x_msg_count := 1;
3047:
3048: IF g1_debug_mode = 'Y' THEN
3049: pa_debug.g_err_stage:='Quantity is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
3050: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3051: END IF;
3052:
3053: END Get_Plan_plan_Rev_Rates;

Line 3050: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3046: x_msg_count := 1;
3047:
3048: IF g1_debug_mode = 'Y' THEN
3049: pa_debug.g_err_stage:='Quantity is not passed to a rate based tranaction to the Get_Plan_Actual_Rev_Rates call';
3050: pa_debug.write('Get_plan_plan_rev_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3051: END IF;
3052:
3053: END Get_Plan_plan_Rev_Rates;
3054:

Line 3179: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_actual_Cost_Rates in PLAN mode';

3175: END IF;
3176: IF ((p_raw_cost IS NULL OR p_burden_cost IS NULL)
3177: AND p_calculate_mode IN ('COST','COST_REVENUE')) THEN
3178: IF g1_debug_mode = 'Y' THEN
3179: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_actual_Cost_Rates in PLAN mode';
3180: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3181: END IF;
3182:
3183: BEGIN

Line 3180: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3176: IF ((p_raw_cost IS NULL OR p_burden_cost IS NULL)
3177: AND p_calculate_mode IN ('COST','COST_REVENUE')) THEN
3178: IF g1_debug_mode = 'Y' THEN
3179: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_actual_Cost_Rates in PLAN mode';
3180: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3181: END IF;
3182:
3183: BEGIN
3184: PA_COST1.Get_Plan_Actual_Cost_Rates

Line 3229: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_raw_cost_rejection_code'||l_raw_cost_rejection_code||'x_burden_cost_rejection_code'||l_burden_cost_rejection_code;

3225: ,x_return_status =>l_x_return_status
3226: ,x_error_msg_code =>l_cost_msg_data ) ;
3227:
3228: IF g1_debug_mode = 'Y' THEN
3229: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_raw_cost_rejection_code'||l_raw_cost_rejection_code||'x_burden_cost_rejection_code'||l_burden_cost_rejection_code;
3230: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
3231: END IF;
3232: EXCEPTION
3233: WHEN OTHERS THEN

Line 3230: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,3);

3226: ,x_error_msg_code =>l_cost_msg_data ) ;
3227:
3228: IF g1_debug_mode = 'Y' THEN
3229: pa_debug.g_err_stage:='Called PA_COST1.Get_Plan_Actual_Cost_Rates:x_raw_cost_rejection_code'||l_raw_cost_rejection_code||'x_burden_cost_rejection_code'||l_burden_cost_rejection_code;
3230: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
3231: END IF;
3232: EXCEPTION
3233: WHEN OTHERS THEN
3234: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

Line 3240: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';

3236: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3237: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: IF g1_debug_mode = 'Y' THEN
3240: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';
3241: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
3242: END IF;
3243: RAISE;
3244:

Line 3241: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,1);

3237: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: IF g1_debug_mode = 'Y' THEN
3240: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';
3241: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
3242: END IF;
3243: RAISE;
3244:
3245: END;

Line 3302: pa_debug.g_err_stage:='Calling Get_Plan_plan_Rev_Rates';

3298: END IF;
3299: END IF;
3300: END IF;
3301: IF g1_debug_mode = 'Y' THEN
3302: pa_debug.g_err_stage:='Calling Get_Plan_plan_Rev_Rates';
3303: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3304: END IF;
3305:
3306: Get_Plan_plan_Rev_Rates (

Line 3303: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3299: END IF;
3300: END IF;
3301: IF g1_debug_mode = 'Y' THEN
3302: pa_debug.g_err_stage:='Calling Get_Plan_plan_Rev_Rates';
3303: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3304: END IF;
3305:
3306: Get_Plan_plan_Rev_Rates (
3307: p_project_id => p_project_id ,

Line 3374: pa_debug.g_err_stage:='OUT of Get_plan_plan_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id||'l_txn_raw_revenue'||l_txn_raw_revenue||'l_txn_bill_rate'||l_txn_bill_rate||'l_rev_txn_curr_code'||l_rev_txn_curr_code;

3370: x_rev_txn_curr_code :=l_rev_txn_curr_code;
3371: x_revenue_rejection_code :=NULL;
3372: x_return_status :=l_x_return_status;
3373: IF g1_debug_mode = 'Y' THEN
3374: pa_debug.g_err_stage:='OUT of Get_plan_plan_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id||'l_txn_raw_revenue'||l_txn_raw_revenue||'l_txn_bill_rate'||l_txn_bill_rate||'l_rev_txn_curr_code'||l_rev_txn_curr_code;
3375: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3376: END IF;
3377: EXCEPTION
3378:

Line 3375: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3371: x_revenue_rejection_code :=NULL;
3372: x_return_status :=l_x_return_status;
3373: IF g1_debug_mode = 'Y' THEN
3374: pa_debug.g_err_stage:='OUT of Get_plan_plan_Rates:p_project_id'||p_project_id||'p_task_id'||p_task_id||'l_txn_raw_revenue'||l_txn_raw_revenue||'l_txn_bill_rate'||l_txn_bill_rate||'l_rev_txn_curr_code'||l_rev_txn_curr_code;
3375: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3376: END IF;
3377: EXCEPTION
3378:
3379: WHEN l_no_cost THEN

Line 3391: pa_debug.g_err_stage:='No Cost exist for the tranascation:p_project_id'||p_project_id||'p_task_id'||p_task_id;

3387: x_msg_count := 1;
3388:
3389:
3390: IF g1_debug_mode = 'Y' THEN
3391: pa_debug.g_err_stage:='No Cost exist for the tranascation:p_project_id'||p_project_id||'p_task_id'||p_task_id;
3392: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3393: END IF;
3394: WHEN l_bill_api THEN
3395: x_raw_revenue := NULL;

Line 3392: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3388:
3389:
3390: IF g1_debug_mode = 'Y' THEN
3391: pa_debug.g_err_stage:='No Cost exist for the tranascation:p_project_id'||p_project_id||'p_task_id'||p_task_id;
3392: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3393: END IF;
3394: WHEN l_bill_api THEN
3395: x_raw_revenue := NULL;
3396: x_bill_rate := NULL;

Line 3405: pa_debug.g_err_stage:='Billing api is throwing error';

3401: x_msg_data := l_bill_msg_data;
3402: x_msg_count := l_bill_msg_count;
3403:
3404: IF g1_debug_mode = 'Y' THEN
3405: pa_debug.g_err_stage:='Billing api is throwing error';
3406: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3407: END IF;
3408:
3409:

Line 3406: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);

3402: x_msg_count := l_bill_msg_count;
3403:
3404: IF g1_debug_mode = 'Y' THEN
3405: pa_debug.g_err_stage:='Billing api is throwing error';
3406: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3407: END IF;
3408:
3409:
3410: END Get_plan_plan_Rates;