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 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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 ;
941: x_revenue_rejection_code := l_revenue_rejection_code;
942: x_raw_cost_rejection_code := l_raw_cost_rejection_code;

Line 959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
962: x_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
963: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);

Line 1189: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2084:
2085: EXCEPTION
2086: WHEN l_more_than_one_row_excep THEN
2087: x_raw_cost:= NULL;
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 2114: l_inter_return_status := FND_API.G_RET_STS_ERROR;

2110:
2111: EXCEPTION
2112: WHEN l_no_cost THEN
2113: x_raw_cost:= NULL;
2114: l_inter_return_status := FND_API.G_RET_STS_ERROR;
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

Line 2125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2121: END IF;
2122:
2123: WHEN OTHERS THEN
2124: x_raw_cost:= NULL;
2125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126: x_msg_count := 1;
2127: x_msg_data := SUBSTR(SQLERRM,1,30);
2128: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);
2129:

Line 2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2437: END IF;
2438: EXCEPTION
2439: WHEN l_more_than_one_row_excep THEN
2440: x_raw_revenue:= NULL;
2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2442: x_msg_count := 1;
2443: x_msg_data := 'TOO_MANY_ROWS';
2444: x_revenue_rejection_code := 'TOO_MANY_ROWS';
2445:

Line 2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2565: x_raw_revenue := NULL;
2566: x_raw_cost := NULL;
2567: x_bill_rate := NULL;
2568: x_cost_rate := NULL;
2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2570: x_msg_count := 1;
2571: x_msg_data := SUBSTR(SQLERRM,1,30);
2572: x_revenue_rejection_code := SUBSTR(SQLERRM,1,30);
2573: x_raw_cost_rejection_code := SUBSTR(SQLERRM,1,30);

Line 2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2839: END IF;
2840: EXCEPTION
2841: WHEN l_more_than_one_row_excep THEN
2842: x_raw_revenue:= NULL;
2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2844: x_msg_count := 1;
2845: x_msg_data := 'TOO_MANY_ROWS';
2846:
2847:

Line 2909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2905: END IF;
2906: EXCEPTION
2907: WHEN l_more_than_one_row_excep THEN
2908: x_raw_revenue:= NULL;
2909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2910: x_msg_count := 1;
2911: x_msg_data := 'TOO_MANY_ROWS';
2912:
2913:

Line 2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2949: END IF;
2950: EXCEPTION
2951: WHEN l_more_than_one_row_excep THEN
2952: x_raw_revenue:= NULL;
2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2954: x_msg_count := 1;
2955: x_msg_data := 'TOO_MANY_ROWS';
2956:
2957:

Line 2994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2990: END IF;
2991: EXCEPTION
2992: WHEN l_more_than_one_row_excep THEN
2993: x_raw_revenue:= NULL;
2994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2995: x_msg_count := 1;
2996: x_msg_data := 'TOO_MANY_ROWS';
2997:
2998:

Line 3237: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

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