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

Line 91: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

87: P_Res_Assignment_Id => null,
88: X_Resource_Displayed => l_element_name,
89: X_Return_Status => l_return_status,
90: X_Msg_Data => l_msg_data );
91: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
92: l_element_name := NULL;
93: END IF;
94: END IF;
95:

Line 115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

111: P_Res_Assignment_Id => null,
112: X_Resource_Displayed => l_element_name,
113: X_Return_Status => l_return_status,
114: X_Msg_Data => l_msg_data );
115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
116: l_element_name := NULL;
117: END IF;
118: END IF;
119:

Line 157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

153: P_Res_Assignment_Id => null,
154: X_Resource_Displayed => l_element_name,
155: X_Return_Status => l_return_status,
156: X_Msg_Data => l_msg_data );
157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
158: l_element_name := NULL;
159: END IF;
160: END IF;
161:

Line 181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

177: P_Res_Assignment_Id => null,
178: X_Resource_Displayed => l_element_name,
179: X_Return_Status => l_return_status,
180: X_Msg_Data => l_msg_data );
181: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182: l_element_name := NULL;
183: END IF;
184: END IF;
185:

Line 205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

201: P_Res_Assignment_Id => null,
202: X_Resource_Displayed => l_element_name,
203: X_Return_Status => l_return_status,
204: X_Msg_Data => l_msg_data );
205: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
206: l_element_name := NULL;
207: END IF;
208: END IF;
209:

Line 229: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

225: P_Res_Assignment_Id => null,
226: X_Resource_Displayed => l_element_name,
227: X_Return_Status => l_return_status,
228: X_Msg_Data => l_msg_data );
229: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: l_element_name := NULL;
231: END IF;
232: END IF;
233:

Line 268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

264: P_Res_Assignment_Id => null,
265: X_Resource_Displayed => l_element_name,
266: X_Return_Status => l_return_status,
267: X_Msg_Data => l_msg_data );
268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
269: l_element_name := NULL;
270: END IF;
271: END IF;
272:

Line 465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

461: -- FROM Pa_rbs_element_names_b
462: -- where RESOURCE_TYPE_ID = p_resource_type_id);
463: EXCEPTION
464: WHEN OTHERS THEN
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: RETURN;
467: END Insert_elements;
468:
469: /******************************************************

Line 1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1029: END IF;--SUPPLIER
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: RETURN;
1035: END Insert_non_tl_names;
1036:
1037: /******************************************************

Line 1279: x_return_status := FND_API.G_RET_STS_SUCCESS;

1275: l_last_analyzed all_tables.last_analyzed%TYPE;
1276: l_pa_schema VARCHAR2(30);
1277: BEGIN
1278: --Initialize the x_return_status.
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280:
1281: --For bug 4026456, 4887312
1282:
1283: /*

Line 1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1331: l_resource_type_id);
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: x_rbs_element_name_id := Null;
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: RETURN;
1337: END;
1338: END IF;
1339: /*************************************************

Line 1400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1396: *****************************************************/
1397: Insert_elements
1398: (p_resource_type_id => l_res_type,
1399: x_return_status => l_return_status);
1400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1401: Rollback to Savepoint insert_for_call_flag_AB;
1402: x_rbs_element_name_id := NULL;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: RETURN;

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1399: x_return_status => l_return_status);
1400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1401: Rollback to Savepoint insert_for_call_flag_AB;
1402: x_rbs_element_name_id := NULL;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: RETURN;
1405: END IF;--Return Status
1406:
1407: IF l_res_type_code NOT IN

Line 1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1414: /**************************************************
1415: * Rollback changes and pass UNEXP error
1416: * and rbs_element_name_id as NULL and return.
1417: *************************************************/
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: Rollback to Savepoint insert_for_call_flag_AB;
1420: x_rbs_element_name_id := NULL;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: RETURN;

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1417: *************************************************/
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: Rollback to Savepoint insert_for_call_flag_AB;
1420: x_rbs_element_name_id := NULL;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: RETURN;
1423: END IF;--Return Status
1424: END IF;--Res_type_code
1425:

Line 1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1433: /**************************************************
1434: * Rollback changes and pass UNEXP error
1435: * and rbs_element_name_id as NULL and return.
1436: *************************************************/
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: Rollback to Savepoint insert_for_call_flag_AB;
1439: x_rbs_element_name_id := NULL;
1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441: RETURN;

Line 1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1436: *************************************************/
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: Rollback to Savepoint insert_for_call_flag_AB;
1439: x_rbs_element_name_id := NULL;
1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441: RETURN;
1442: END IF;--Return Status
1443: END IF;--Res_type_code
1444:

Line 1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1457: AND resource_type_id = l_resource_type_id;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: x_rbs_element_name_id := NULL;
1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1462: RETURN;
1463: END;
1464: END IF;
1465:

Line 1489: x_return_status := FND_API.G_RET_STS_SUCCESS;

1485:
1486: BEGIN
1487:
1488: --Initialize return status
1489: x_return_status := FND_API.G_RET_STS_SUCCESS;
1490:
1491: --Call to RBS handler API
1492: PA_RBS_VERSIONS_PVT.SET_REPORTING_FLAG (
1493: p_rbs_version_id => p_new_rbs_version_id,

Line 1496: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1492: PA_RBS_VERSIONS_PVT.SET_REPORTING_FLAG (
1493: p_rbs_version_id => p_new_rbs_version_id,
1494: x_return_status => x_return_status );
1495:
1496: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1497: pa_debug.log_message ('Error in API PA_RBS_VERSIONS_PVT.SET_REPORTING_FLAG' || SQLERRM);
1498: --RETURN;
1499: END IF;
1500:

Line 1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1504: p_rbs_version_id => p_new_rbs_version_id,
1505: x_return_status => x_return_status,
1506: x_error_code => x_msg_data );
1507:
1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: pa_debug.log_message ('Error in API PA_ALLOC_UTILS.ASSOCIATE_RBS_TO_ALLOC_RULE' || SQLERRM);
1510: --RETURN;
1511: END IF;
1512:

Line 1522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1518: x_return_status => x_return_status,
1519: x_msg_count => x_msg_count,
1520: x_msg_data => x_msg_data );
1521:
1522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1523: pa_debug.log_message ('Error in API PA_RLMI_RBS_MAP_PUB.PUSH_RBS_VERSION' || SQLERRM);
1524: --RETURN;
1525: END IF;
1526:

Line 1530: x_return_status := FND_API.G_RET_STS_ERROR;

1526:
1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531: x_msg_data := SQLERRM;
1532: END;
1533:
1534:

Line 2617: x_return_status := FND_API.G_RET_STS_SUCCESS;

2613:
2614: --dbms_output.put_line('START UPGRADE');
2615: -- Upgrade Resource List
2616:
2617: x_return_status := FND_API.G_RET_STS_SUCCESS;
2618: x_msg_data := NULL;
2619: x_msg_count := 0;
2620:
2621: --For bug 4045542, 4887312

Line 2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2637:
2638: OPEN get_list_info(p_resource_list_id);
2639: FETCH get_list_info into l_list;
2640: IF get_list_info%NOTFOUND THEN
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: CLOSE get_list_info;
2643: RETURN;
2644: END IF;
2645: CLOSE get_list_info;

Line 2984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2980: -- select count(*) into l_name_count from pa_rbs_element_names_b;
2981: --dbms_output.put_line('l_name_count after Populate_RBS_Element_Name is ' || l_name_count);
2982: --dbms_output.put_line('error after Populate_RBS_Element_Name is ' || sqlerrm);
2983:
2984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2985: --dbms_output.put_line('Populate_RBS_Element_Name Error');
2986: rollback to l_resource_list_savepoint;
2987: ELSE
2988: --dbms_output.put_line('Populate_RBS_Element_Name Success');

Line 3514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3510: x_return_status => x_return_status,
3511: x_msg_count => x_msg_count,
3512: x_msg_data => x_msg_data);
3513:
3514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3515: --dbms_output.put_line('create_mapping_rules ERROR');
3516: rollback to l_resource_list_savepoint;
3517: END IF;
3518:

Line 3526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3522: x_return_status => x_return_status,
3523: x_msg_count => x_msg_count,
3524: x_msg_data => x_msg_data);
3525:
3526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3527: --dbms_output.put_line('POPULATE_RBS_DENORM_UPGRADE ERROR');
3528: rollback to l_resource_list_savepoint;
3529: END IF;
3530:

Line 3591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3587: P_PROJECT_ID => l_project_id,
3588: X_RETURN_STATUS => x_return_status,
3589: X_MSG_CODE => x_msg_data);
3590:
3591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3592: --dbms_output.put_line('Even Log ERROR');
3593: rollback to l_resource_list_savepoint;
3594: END IF;
3595:

Line 3795: If x_return_status = Fnd_Api.G_Ret_Sts_Success Then

3791: P_Resource_Type_Id => -1,
3792: X_Rbs_Element_Name_Id => l_new_element_name_id,
3793: X_Return_Status => x_return_status);
3794:
3795: If x_return_status = Fnd_Api.G_Ret_Sts_Success Then
3796:
3797: Update Pa_Rbs_Elements
3798: Set Rbs_Element_Name_Id = l_New_Element_Name_Id,
3799: Resource_Source_Id = l_rbs_version_id

Line 3813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3809: EXCEPTION
3810: WHEN OTHERS THEN
3811: --dbms_output.put_line('IN WHEN OTHERS ERROR');
3812: --dbms_output.put_line('SQLERRM IS : ' || sqlerrm);
3813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3814: --rollback;
3815:
3816: END UPGRADE_LIST_TO_RBS;
3817:

Line 3829: x_return_status := FND_API.G_RET_STS_SUCCESS;

3825: x_return_status OUT NOCOPY VARCHAR2,
3826: x_msg_count OUT NOCOPY NUMBER)
3827: IS
3828: BEGIN
3829: x_return_status := FND_API.G_RET_STS_SUCCESS;
3830: x_msg_count := 0;
3831: DELETE FROM pa_rbs_prj_assignments
3832: WHERE project_id = p_project_id;
3833: EXCEPTION

Line 3839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3835: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
3836: 'Pa_RBS_Utils.Delete_Proj_Specific_RBS'
3837: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3838: x_msg_count := x_msg_count+1;
3839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3840: END Delete_Proj_Specific_RBS;
3841:
3842: procedure ADD_LANGUAGE
3843: is