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 FND_API

Line 18: g_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

14: l_invalid_currency_bill EXCEPTION;
15: l_Get_planning_Rates_api EXCEPTION;
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();

Line 19: g_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

15: l_Get_planning_Rates_api EXCEPTION;
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();

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

141: x_rate :=NULL;
142: x_markup_percentage :=NULL;
143: x_uom :=NULL;
144: x_rate_currency_code :=NULL;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: x_msg_count := 1;
147: x_msg_data := 'PA_FCST_INSUFFICIENT_PARA';
148: WHEN l_no_rate THEN
149: x_rate :=NULL;

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

161: x_rate :=NULL;
162: x_markup_percentage :=NULL;
163: x_uom :=NULL;
164: x_rate_currency_code :=NULL;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: x_msg_count := 1;
167: x_msg_data := SUBSTR(SQLERRM,1,250);
168: RAISE;
169: END Get_Res_Class_Hierarchy_Rate;

Line 1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1020: IF g1_debug_mode = 'Y' THEN
1021: 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;
1022: pa_debug.write('Get_planning_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1023: END IF;
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: x_msg_count := 1;
1026: x_msg_data := l_x_msg_data ;
1027: x_revenue_rejection_code := l_revenue_rejection_code;
1028: x_raw_cost_rejection_code := l_raw_cost_rejection_code;

Line 1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1041: IF g1_debug_mode = 'Y' THEN
1042: 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;
1043: pa_debug.write('Get_planing_Rates : ' || g_module_name,pa_debug.g_err_stage,1);
1044: END IF;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: x_msg_count := 1;
1047: x_msg_data := 'Get_Planning_Rates'||SUBSTR(SQLERRM,1,250);
1048: x_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
1049: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);

Line 1276: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

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:
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);

Line 2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2171:
2172: EXCEPTION
2173: WHEN l_more_than_one_row_excep THEN
2174: x_raw_cost:= NULL;
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176: x_msg_count := 1;
2177: x_msg_data := 'TOO_MANY_ROWS';
2178: x_raw_cost_rejection_code :='TOO_MANY_ROWS';
2179: IF g1_debug_mode = 'Y' THEN

Line 2201: l_inter_return_status := FND_API.G_RET_STS_ERROR;

2197:
2198: EXCEPTION
2199: WHEN l_no_cost THEN
2200: x_raw_cost:= NULL;
2201: l_inter_return_status := FND_API.G_RET_STS_ERROR;
2202: x_msg_data:= 'PA_FCST_NO_COST_RATE';
2203: x_raw_cost_rejection_code := 'PA_FCST_NO_COST_RATE';
2204: x_msg_count := 1;
2205: IF g1_debug_mode = 'Y' THEN

Line 2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2208: END IF;
2209:
2210: WHEN OTHERS THEN
2211: x_raw_cost:= NULL;
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: x_msg_count := 1;
2214: x_msg_data := SUBSTR(SQLERRM,1,30);
2215: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2216:

Line 2531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2527: END IF;
2528: EXCEPTION
2529: WHEN l_more_than_one_row_excep THEN
2530: x_raw_revenue:= NULL;
2531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2532: x_msg_count := 1;
2533: x_msg_data := 'TOO_MANY_ROWS';
2534: x_revenue_rejection_code := 'TOO_MANY_ROWS';
2535:

Line 2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2655: x_raw_revenue := NULL;
2656: x_raw_cost := NULL;
2657: x_bill_rate := NULL;
2658: x_cost_rate := NULL;
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: x_msg_count := 1;
2661: x_msg_data := SUBSTR(SQLERRM,1,30);
2662: x_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
2663: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);

Line 2964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2960: END IF;
2961: EXCEPTION
2962: WHEN l_more_than_one_row_excep THEN
2963: x_raw_revenue:= NULL;
2964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2965: x_msg_count := 1;
2966: x_msg_data := 'TOO_MANY_ROWS';
2967:
2968:

Line 3044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3040: END IF;
3041: EXCEPTION
3042: WHEN l_more_than_one_row_excep THEN
3043: x_raw_revenue:= NULL;
3044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3045: x_msg_count := 1;
3046: x_msg_data := 'TOO_MANY_ROWS';
3047:
3048:

Line 3088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3084: END IF;
3085: EXCEPTION
3086: WHEN l_more_than_one_row_excep THEN
3087: x_raw_revenue:= NULL;
3088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3089: x_msg_count := 1;
3090: x_msg_data := 'TOO_MANY_ROWS';
3091:
3092:

Line 3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3125: END IF;
3126: EXCEPTION
3127: WHEN l_more_than_one_row_excep THEN
3128: x_raw_revenue:= NULL;
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3130: x_msg_count := 1;
3131: x_msg_data := 'TOO_MANY_ROWS';
3132:
3133:

Line 3372: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

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:
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);

Line 3731: l_inter_return_status := FND_API.G_RET_STS_ERROR;

3727: END IF;
3728: EXCEPTION
3729: WHEN l_no_cost THEN
3730: x_raw_cost := NULL;
3731: l_inter_return_status := FND_API.G_RET_STS_ERROR;
3732: x_msg_data := 'PA_FCST_NO_COST_RATE';
3733: x_raw_cost_rejection_code := 'PA_FCST_NO_COST_RATE';
3734: x_msg_count := 1;
3735: IF g1_debug_mode = 'Y' THEN

Line 3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3737: pa_debug.write('Get_plan_default_rates: ' || g_module_name,pa_debug.g_err_stage,5);
3738: END IF;
3739: WHEN OTHERS THEN
3740: x_raw_cost := NULL;
3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3742: x_msg_count := 1;
3743: x_msg_data := SUBSTR(SQLERRM,1,30);
3744: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
3745: IF g1_debug_mode = 'Y' THEN

Line 4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4032: x_raw_revenue := NULL;
4033: x_raw_cost := NULL;
4034: x_bill_rate := NULL;
4035: x_cost_rate := NULL;
4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4037: x_msg_count := 1;
4038: x_msg_data := SUBSTR(SQLERRM,1,30);
4039: x_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
4040: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);