DBA Data[Home] [Help]

APPS.PA_PLAN_REVENUE dependencies on PA_COST

Line 589: l_x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

585: WHEN OTHERS THEN
586: /* this will be called since the values of l_raw_cost_rejection_code,l_burden_cost_rejection_code are assigned before any
587: exception occurs in the parent procedure definition */
588: IF l_raw_cost_rejection_code IS NOT NULL OR l_burden_cost_rejection_code IS NOT NULL THEN
589: l_x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);
590: ELSE
591: l_x_msg_data := 'pa_plan_revenue.Get_Plan_Actual_Rev_Rates :' || SUBSTR(SQLERRM,1,250);
592: END IF;
593: l_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);

Line 702: l_x_msg_data := 'PA_COST1.Get_Plan_actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: IF l_raw_cost_rejection_code IS NOT NULL OR l_burden_cost_rejection_code IS NOT NULL THEN
702: l_x_msg_data := 'PA_COST1.Get_Plan_actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);
703: ELSE
704: l_x_msg_data := 'pa_plan_revenue.Get_Plan_plan_Rev_Rates :' || SUBSTR(SQLERRM,1,250);
705: END IF;
706: l_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);

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

1205: END IF;
1206: IF ((p_raw_cost IS NULL OR p_burden_cost IS NULL)
1207: AND p_calculate_mode IN ('COST','COST_REVENUE')) THEN
1208: IF g1_debug_mode = 'Y' THEN
1209: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_Actual_Cost_Rates';
1210: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1211: END IF;
1212:
1213: BEGIN

Line 1214: PA_COST1.Get_Plan_Actual_Cost_Rates

1210: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
1211: END IF;
1212:
1213: BEGIN
1214: PA_COST1.Get_Plan_Actual_Cost_Rates
1215: (p_calling_mode =>'ACTUAL_RATES'
1216: ,p_project_type =>p_project_type
1217: ,p_project_id =>p_project_id
1218: ,p_task_id =>p_task_id

Line 1260: 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;

1256: ,x_return_status =>l_x_return_status
1257: ,x_error_msg_code =>l_cost_msg_data ) ;
1258:
1259: IF g1_debug_mode = 'Y' THEN
1260: 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;
1261: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1262: END IF;
1263: IF g1_debug_mode = 'Y' THEN
1264: 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 1264: 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;

1260: 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;
1261: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1262: END IF;
1263: IF g1_debug_mode = 'Y' THEN
1264: 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;
1265: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1266: END IF;
1267: IF g1_debug_mode = 'Y' THEN
1268: 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 1268: 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;

1264: 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;
1265: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1266: END IF;
1267: IF g1_debug_mode = 'Y' THEN
1268: 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;
1269: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1270: END IF;
1271: EXCEPTION
1272: WHEN OTHERS THEN

Line 1273: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

1269: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
1270: END IF;
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);
1274: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
1275: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
1276: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1277:

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

1275: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
1276: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1277:
1278: IF g1_debug_mode = 'Y' THEN
1279: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';
1280: pa_debug.write('Get_plan_actual_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1281: END IF;
1282: RAISE;
1283: -- RAISE l_Get_plan_actual_Rates; /* Added to handle exception return by costing api */

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

2015: END IF;
2016:
2017: IF l_override_organization_id is NULL and p_resource_class = 'PEOPLE' Then
2018: IF g1_debug_mode = 'Y' THEN
2019: pa_debug.g_err_stage:='Calling pa_cost.Override_exp_organization api';
2020: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2021: end if;
2022: BEGIN
2023: pa_cost.Override_exp_organization

Line 2023: pa_cost.Override_exp_organization

2019: pa_debug.g_err_stage:='Calling pa_cost.Override_exp_organization api';
2020: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2021: end if;
2022: BEGIN
2023: pa_cost.Override_exp_organization
2024: (P_item_date => p_item_date
2025: ,P_person_id => p_person_id
2026: ,P_project_id => p_project_id
2027: ,P_incurred_by_organz_id => p_incurred_by_organz_id

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

2033: );
2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: IF g1_debug_mode = 'Y' THEN
2037: pa_debug.g_err_stage:='pa_cost.Override_exp_organization is throwing When Others'||SUBSTR(SQLERRM,1,250);
2038: pa_debug.write('Get_plan_res_class_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
2039: END IF;
2040: END;
2041:

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

2039: END IF;
2040: END;
2041:
2042: IF g1_debug_mode = 'Y' THEN
2043: pa_debug.g_err_stage:='Return status of pa_cost.Override_exp_organization ['||l_ovr_return_status||
2044: ']msgData['||l_ovr_msg_data||']OverideOrg['||l_override_organization_id||']' ;
2045: pa_debug.write('Get_plan_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,5);
2046: end if;
2047:

Line 2257: and pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) Then

2253: END IF;
2254:
2255: ElsIf ( p_override_burden_cost_rate is NULL and l_burden_cost is NULL
2256: and l_raw_cost is NOT NULL and l_cost_rate is NOT NULL
2257: and pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) Then
2258: l_burd_organization_id := NVL(l_override_organization_id, NVl(p_incurred_by_organz_id ,p_nlr_organization_id));
2259: IF g1_debug_mode = 'Y' THEN
2260: pa_debug.g_err_stage := 'calling pa_cost1.Get_burden_sch_details fro burden cost';
2261: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);

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

2256: and l_raw_cost is NOT NULL and l_cost_rate is NOT NULL
2257: and pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) Then
2258: l_burd_organization_id := NVL(l_override_organization_id, NVl(p_incurred_by_organz_id ,p_nlr_organization_id));
2259: IF g1_debug_mode = 'Y' THEN
2260: pa_debug.g_err_stage := 'calling pa_cost1.Get_burden_sch_details fro burden cost';
2261: pa_debug.write('Get_res_class_rates: ' || g_module_name,pa_debug.g_err_stage,3);
2262: END IF;
2263:
2264: begin

Line 2266: pa_cost1.Get_burden_sch_details

2262: END IF;
2263:
2264: begin
2265:
2266: pa_cost1.Get_burden_sch_details
2267: (p_calling_mode =>l_calling_mode
2268: ,p_exp_item_id => NULL
2269: ,p_trxn_type => NULL
2270: ,p_project_type => p_project_type

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

3310: END IF;
3311: IF ((p_raw_cost IS NULL OR p_burden_cost IS NULL)
3312: AND p_calculate_mode IN ('COST','COST_REVENUE')) THEN
3313: IF g1_debug_mode = 'Y' THEN
3314: pa_debug.g_err_stage:='Before Calling PA_COST1.Get_Plan_actual_Cost_Rates in PLAN mode';
3315: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3316: END IF;
3317:
3318: BEGIN

Line 3319: PA_COST1.Get_Plan_Actual_Cost_Rates

3315: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,2);
3316: END IF;
3317:
3318: BEGIN
3319: PA_COST1.Get_Plan_Actual_Cost_Rates
3320: (p_calling_mode =>'PLAN_RATES'
3321: ,p_project_type =>p_project_type
3322: ,p_project_id =>p_project_id
3323: ,p_task_id =>p_task_id

Line 3364: 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;

3360: ,x_return_status =>l_x_return_status
3361: ,x_error_msg_code =>l_cost_msg_data ) ;
3362:
3363: IF g1_debug_mode = 'Y' THEN
3364: 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;
3365: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
3366: END IF;
3367: EXCEPTION
3368: WHEN OTHERS THEN

Line 3369: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

3365: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,3);
3366: END IF;
3367: EXCEPTION
3368: WHEN OTHERS THEN
3369: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);
3370: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3371: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3372: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3373:

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

3371: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3372: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3373:
3374: IF g1_debug_mode = 'Y' THEN
3375: pa_debug.g_err_stage:=' PA_COST1.Get_Plan_Actual_Cost_Rates is throwing When Others';
3376: pa_debug.write('Get_plan_plan_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
3377: END IF;
3378: RAISE;
3379:

Line 3778: ElsIf ( p_override_burden_cost_rate IS NULL AND l_burden_cost IS NULL AND l_raw_cost IS NOT NULL AND l_cost_rate IS NOT NULL AND pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) THEN

3774: END IF;
3775: IF NVL(l_raw_cost,0) <>0 THEN
3776: l_txn_burden_multiplier := (l_burden_cost/l_raw_cost)-1;
3777: END IF;
3778: ElsIf ( p_override_burden_cost_rate IS NULL AND l_burden_cost IS NULL AND l_raw_cost IS NOT NULL AND l_cost_rate IS NOT NULL AND pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) THEN
3779: l_burd_organization_id := NVL(l_override_organization_id, NVL(p_incurred_by_organz_id ,p_nlr_organization_id));
3780: BEGIN
3781: pa_cost1.Get_burden_sch_details (p_calling_mode =>l_calling_mode
3782: ,p_exp_item_id => NULL

Line 3781: pa_cost1.Get_burden_sch_details (p_calling_mode =>l_calling_mode

3777: END IF;
3778: ElsIf ( p_override_burden_cost_rate IS NULL AND l_burden_cost IS NULL AND l_raw_cost IS NOT NULL AND l_cost_rate IS NOT NULL AND pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) THEN
3779: l_burd_organization_id := NVL(l_override_organization_id, NVL(p_incurred_by_organz_id ,p_nlr_organization_id));
3780: BEGIN
3781: pa_cost1.Get_burden_sch_details (p_calling_mode =>l_calling_mode
3782: ,p_exp_item_id => NULL
3783: ,p_trxn_type => NULL
3784: ,p_project_type => p_project_type
3785: ,p_project_id => p_project_id