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_MATRIX dependencies on FND_API

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: l_st_dt_4_end_pd := p_st_dt_4_end_pd;
63: l_bucketing_period_code := p_bucketing_period_code;
64: l_transaction_currency_code := p_transaction_currency_code;
65:
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: -- Get the minimum of start date and maximum of end date for this
69: -- resource assignment id from the budget line table:
70:

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
120: 'start date, end date and period name from GL_periods for PD-GL';
121: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
122: END IF;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';
125: PA_DEBUG.Reset_Curr_Function;
126: RAISE;
127: END;

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
164: 'start date, end date and period name from GL_periods for PD-PA';
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
166: END IF;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';
169: PA_DEBUG.Reset_Curr_Function;
170: RAISE;
171: END;

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
206: 'start date, end date and period name from GL_periods for SD-GL';
207: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
208: END IF;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';
211: PA_DEBUG.Reset_Curr_Function;
212: RAISE;
213: END;

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
244: 'start date, end date and period name from GL_periods for SD-PA';
245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
246: END IF;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';
249: PA_DEBUG.Reset_Curr_Function;
250: RAISE;
251: END;

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: IF P_PA_DEBUG_MODE = 'Y' THEN
260: PA_DEBUG.g_err_stage := 'Unexpected error in Get_Period_Info ';
261: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
262: END IF;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: PA_DEBUG.Reset_Curr_Function;
265: RAISE;
266: END Get_Period_Info;
267:

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: l_succ_proj_burdened_cost := NULL;
395: l_succ_proj_revenue := NULL;
396: l_succ_proj_curr_code := NULL;
397:
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:
400: SELECT NVL(version_type,'ALL') INTO
401: l_version_type FROM pa_budget_versions
402: where budget_version_id = p_budget_version_id;

Line 475: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

471: x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data
473: );
474:
475: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
476: --DBMS_OUTPUT.PUT_LINE('Error in call to Get Period Info');
477: RETURN;
478: END IF;
479: -- Selecting the revenue and cost values from the temporary

Line 669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

665: x_msg_count => x_msg_count,
666: x_msg_data => x_msg_data);
667: END IF;
668:
669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
670: RAISE g_mrc_exception;
671: END IF;
672: */
673:

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

683: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
684: END IF;
685: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
686: p_msg_name => 'PA_FP_UNEX_ERR_INS_BDGT_LNS');
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: x_msg_data := 'PA_FP_UNEX_ERR_INS_BDGT_LNS';
689: PA_DEBUG.Reset_Curr_Function;
690: RAISE;
691: END;

Line 747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

743: x_msg_count => x_msg_count,
744: x_msg_data => x_msg_data
745: );
746:
747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
748: --DBMS_OUTPUT.PUT_LINE('Error in call to Get Period Info');
749: PA_DEBUG.Reset_Curr_Function;
750: RETURN;
751: END IF;

Line 878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

874: x_msg_count => x_msg_count,
875: x_msg_data => x_msg_data);
876: END IF;
877:
878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
879: RAISE g_mrc_exception;
880: END IF;
881: */
882: ELSE

Line 969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

965: x_msg_count => x_msg_count,
966: x_msg_data => x_msg_data);
967: END IF;
968:
969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
970: RAISE g_mrc_exception;
971: END IF;
972: */
973:

Line 987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

983: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
984: END IF;
985: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
986: p_msg_name => 'PA_FP_UNEX_ERR_INS_BDGT_LNS');
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: x_msg_data := 'PA_FP_UNEX_ERR_INS_BDGT_LNS';
989: PA_DEBUG.Reset_Curr_Function;
990: RAISE;
991: END;

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1010: IF P_PA_DEBUG_MODE = 'Y' THEN
1011: PA_DEBUG.g_err_stage := 'Unexpected error in Populate_Budget_Lines ';
1012: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1013: END IF;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: PA_DEBUG.Reset_Curr_Function;
1016: RAISE;
1017: END Populate_Budget_Lines;
1018:

Line 1504: x_return_status := FND_API.G_RET_STS_SUCCESS;

1500: /* the following logic can be easily coded by using Dynamic SQL. But for checking 52 columns
1501: , it will be 52 DB hits. And also if this process is called multiple times from
1502: conc mgr process for a range of projects, there will be more DB hits.
1503: So the logic is coded as a single select and using multiple IFs - SManivannan */
1504: x_return_status := FND_API.G_RET_STS_SUCCESS;
1505:
1506: IF P_PA_DEBUG_MODE = 'Y' THEN
1507: PA_DEBUG.g_err_stage := 'Entering Main Plan Matrix and selecting prj profile';
1508: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1732: x_return_status := FND_API.G_RET_STS_ERROR;

1728: IF P_PA_DEBUG_MODE = 'Y' THEN
1729: PA_DEBUG.g_err_stage := 'Prj profile not found returning';
1730: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1731: END IF;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: IF p_add_msg_in_stack = 'Y' THEN
1734: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1735: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
1736: ELSE

Line 2230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2226: x_msg_count => x_msg_count ,
2227: x_msg_data => x_msg_data
2228: );
2229:
2230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2231: --DBMS_OUTPUT.PUT_LINE('Error in call to Populate Budget Lines');
2232: RETURN;
2233: END IF;
2234: ELSE

Line 2260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2256: x_msg_count => x_msg_count ,
2257: x_msg_data => x_msg_data
2258: );
2259:
2260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2261: --DBMS_OUTPUT.PUT_LINE('Error in call to Populate Budget Lines');
2262: PA_DEBUG.Reset_Curr_Function;
2263: RETURN;
2264: END IF;

Line 2286: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2282: x_return_status => x_return_status,
2283: x_msg_count => x_msg_count ,
2284: x_msg_data => x_msg_data
2285: );
2286: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2287: --DBMS_OUTPUT.PUT_LINE('Error in call to Populate Budget Lines');
2288: PA_DEBUG.Reset_Curr_Function;
2289: RETURN;
2290: END IF;

Line 2317: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2313: x_msg_count => x_msg_count ,
2314: x_msg_data => x_msg_data
2315: );
2316:
2317: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2318: --DBMS_OUTPUT.PUT_LINE('Error in call to Populate Budget Lines');
2319: PA_DEBUG.Reset_Curr_Function;
2320: RETURN;
2321: END IF;

Line 2771: x_return_status := FND_API.G_RET_STS_ERROR;

2767: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2768: PA_DEBUG.g_err_stage := 'Invalid Amt Sub Type:'||l_amt_subtype_code;
2769: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2770: END IF;
2771: x_return_status := FND_API.G_RET_STS_ERROR;
2772: IF p_add_msg_in_stack = 'Y' THEN
2773: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2774: p_msg_name => 'PA_FP_INVALID_AMT_TYPE');
2775: ELSE

Line 3712: x_return_status := FND_API.G_RET_STS_ERROR;

3708: IF p_add_msg_in_stack = 'Y' THEN
3709: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
3710: p_msg_name => 'PA_FP_UNEX_ERR_DENORM_IN');
3711: END IF;
3712: x_return_status := FND_API.G_RET_STS_ERROR;
3713: x_msg_data := 'PA_FP_UNEX_ERR_DENORM_IN';
3714: PA_DEBUG.Reset_Curr_Function;
3715: RAISE;
3716: END;

Line 3911: x_return_status := FND_API.G_RET_STS_ERROR;

3907: IF p_add_msg_in_stack = 'Y' THEN
3908: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
3909: p_msg_name => 'PA_FP_UNEX_ERR_DENORM_IN');
3910: END IF;
3911: x_return_status := FND_API.G_RET_STS_ERROR;
3912: x_msg_data := 'PA_FP_UNEX_ERR_DENORM_IN';
3913: PA_DEBUG.Reset_Curr_Function;
3914: RAISE;
3915: END Maintain_Plan_Matrix;