DBA Data[Home] [Help]

APPS.PA_PLAN_REVENUE dependencies on PA_COST1

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 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 1128: 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
1129: (p_calling_mode =>'ACTUAL_RATES'
1130: ,p_project_type =>p_project_type
1131: ,p_project_id =>p_project_id
1132: ,p_task_id =>p_task_id

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 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 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 1186: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

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);
1187: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
1188: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
1189: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1190:

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 2170: and pa_cost1.check_proj_burdened(p_project_type,p_project_id) = 'Y' ) Then

2166: END IF;
2167:
2168: ElsIf ( p_override_burden_cost_rate is NULL and l_burden_cost is NULL
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);

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 2179: pa_cost1.Get_burden_sch_details

2175: END IF;
2176:
2177: begin
2178:
2179: pa_cost1.Get_burden_sch_details
2180: (p_calling_mode =>l_calling_mode
2181: ,p_exp_item_id => NULL
2182: ,p_trxn_type => NULL
2183: ,p_project_type => p_project_type

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 3184: PA_COST1.Get_Plan_Actual_Cost_Rates

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
3185: (p_calling_mode =>'PLAN_RATES'
3186: ,p_project_type =>p_project_type
3187: ,p_project_id =>p_project_id
3188: ,p_task_id =>p_task_id

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 3234: x_msg_data := 'PA_COST1.Get_Plan_Actual_Cost_Rates:' || SUBSTR(SQLERRM,1,250);

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);
3235: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3236: x_burden_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3237: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3238:

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: