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

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: CLOSE cur_res_asgn;
253:
254: PA_DEBUG.Reset_Err_Stack;
255:
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257: EXCEPTION
258: WHEN OTHERS THEN
259: x_msg_count := 1;
260: x_msg_data := sqlerrm;

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: EXCEPTION
258: WHEN OTHERS THEN
259: x_msg_count := 1;
260: x_msg_data := sqlerrm;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.add_exc_msg
263: (p_pkg_name =>
264: 'PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules',
265: p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 388: x_return_status := FND_API.G_RET_STS_SUCCESS;

384: END LOOP;
385:
386: CLOSE cur_asgn_sch;
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389: PA_DEBUG.Reset_Err_Stack;
390: EXCEPTION
391: WHEN OTHERS THEN
392: x_msg_count := 1;

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

390: EXCEPTION
391: WHEN OTHERS THEN
392: x_msg_count := 1;
393: x_msg_data := sqlerrm;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: FND_MSG_PUB.add_exc_msg
396: (p_pkg_name =>
397: 'PA_FORECAST_ITEMS_UTILS.Get_Assignment_Schedule',
398: p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

1235:
1236: BEGIN
1237:
1238: -- 4537865 : Initialize x_return_status to SUCCESS
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240:
1241: PA_DEBUG.Init_err_stack(
1242: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');
1243: -- Selecting columns corresponding to the given org id

Line 1286: x_return_status := FND_API.G_RET_STS_ERROR;

1282: x_nonbill_unassign_proj_id is null OR x_bill_unassign_proj_id is null) THEN
1283: PA_UTILS.Add_Message(
1284: p_app_short_name => 'PA'
1285: ,p_msg_name =>'PA_UNASSIGNED_PROJ_NO_DEFN');
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: x_msg_data := 'PA_UNASSIGNED_PROJ_NO_DEFN';
1288: x_msg_count := FND_MSG_PUB.Count_Msg;
1289:
1290: END IF;

Line 1297: x_return_status := FND_API.G_RET_STS_ERROR;

1293: WHEN NO_DATA_FOUND THEN
1294: PA_UTILS.Add_Message(
1295: p_app_short_name => 'PA'
1296: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: x_msg_data := 'PA_FORECAST_OPTIONS_NOT_SETUP';
1299: x_msg_count := FND_MSG_PUB.Count_Msg;
1300: end;
1301: end if;

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1305: WHEN NO_DATA_FOUND THEN
1306:
1307: x_msg_count := 1;
1308: x_msg_data := sqlerrm;
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:
1311: FND_MSG_PUB.add_exc_msg
1312: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1313: p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316:
1317: WHEN OTHERS THEN
1318: x_msg_count := 1;
1319: x_msg_data := sqlerrm;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321:
1322: FND_MSG_PUB.add_exc_msg
1323: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1324: p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 1398: x_return_status := FND_API.G_RET_STS_SUCCESS;

1394: EXIT WHEN l_week_starting_date > l_end_date; /* Bug#2462076 Changed p_end_date to l_end_date */
1395: li_cnt := li_cnt +1;
1396:
1397: END LOOP;
1398: x_return_status := FND_API.G_RET_STS_SUCCESS;
1399: PA_DEBUG.Reset_Err_Stack;
1400:
1401: EXCEPTION
1402: WHEN OTHERS THEN

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1399: PA_DEBUG.Reset_Err_Stack;
1400:
1401: EXCEPTION
1402: WHEN OTHERS THEN
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: x_msg_count := 1;
1405: x_msg_data := SQLERRM;
1406: FND_MSG_PUB.add_exc_msg
1407: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc',

Line 1443: p_tp_amount_type_code<>FND_API.G_MISS_CHAR THEN

1439:
1440: PA_DEBUG.Init_err_stack(
1441: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType');
1442: IF p_tp_amount_type_code IS NOT NULL AND
1443: p_tp_amount_type_code<>FND_API.G_MISS_CHAR THEN
1444:
1445: IF p_check_id_flag = 'Y' THEN
1446:
1447: lv_error_msg := 'PA_AMOUNT_TYPE_CODE_AMBIGUOUS';

Line 1476: x_return_status := FND_API.G_RET_STS_SUCCESS;

1472: END IF;
1473:
1474: PA_DEBUG.Reset_Err_Stack;
1475:
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: x_msg_data := lv_error_msg;

Line 1479: x_return_status := FND_API.G_RET_STS_ERROR;

1475:
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: x_msg_data := lv_error_msg;
1481:
1482: -- 4537865 : Start
1483: x_tp_amount_type_code := NULL ;

Line 1492: x_return_status := FND_API.G_RET_STS_ERROR;

1488: (p_pkg_name =>
1489: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1490: p_procedure_name => PA_DEBUG.G_Err_Stack);
1491: WHEN TOO_MANY_ROWS THEN
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: x_msg_data := lv_error_msg;
1494:
1495: -- 4537865 : Start
1496: x_tp_amount_type_code := NULL ;

Line 1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1501: (p_pkg_name =>
1502: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1503: p_procedure_name => PA_DEBUG.G_Err_Stack);
1504: WHEN OTHERS THEN
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506:
1507: -- 4537865 : Start
1508: x_tp_amount_type_code := NULL ;
1509: x_tp_amount_type_desc := NULL ;

Line 1566: x_return_status := FND_API.G_RET_STS_SUCCESS;

1562: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1563: )
1564: IS
1565: BEGIN
1566: x_return_status := FND_API.G_RET_STS_SUCCESS;
1567:
1568: Get_Project_Default( p_assignment_type => p_assignment_type,
1569: p_project_id => p_project_id,
1570: x_work_type_id => x_work_type_id,

Line 1589: x_return_status := FND_API.G_RET_STS_ERROR;

1585: x_msg_count => x_msg_count,
1586: x_msg_data => x_msg_data );
1587:
1588: IF FND_MSG_PUB.Count_Msg > 0 THEN
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: x_msg_count := FND_MSG_PUB.Count_Msg;
1591: x_msg_data := NULL;
1592: END IF;
1593:

Line 1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1603: x_carrying_out_organization_id := NULL ;
1604: x_default_assign_exp_type := NULL ;
1605: x_default_assign_exp_type_cls := NULL ;
1606: -- 4537865 : End
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: x_msg_count := 1;
1609: x_msg_data := SQLERRM;
1610: FND_MSG_PUB.add_exc_msg
1611: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_assignment_default',

Line 1632: x_return_status := FND_API.G_RET_STS_SUCCESS;

1628: )
1629: IS
1630:
1631: BEGIN
1632: x_return_status := FND_API.G_RET_STS_SUCCESS;
1633:
1634: SELECT work_type_id,
1635: org_id,
1636: carrying_out_organization_id

Line 1657: x_return_status := FND_API.G_RET_STS_ERROR;

1653: WHEN NO_DATA_FOUND THEN
1654: PA_UTILS.Add_Message(
1655: p_app_short_name => 'PA'
1656: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
1657: x_return_status := FND_API.G_RET_STS_ERROR;
1658: end;
1659:
1660: -- Populate expenditure_organization_id only for requirement
1661: IF p_assignment_type <> 'OPEN_ASSIGNMENT' THEN

Line 1666: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then

1662: x_org_id := NULL;
1663: x_carrying_out_organization_id := NULL;
1664: END IF;
1665:
1666: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1667: Pa_Fp_Org_Fcst_Utils.Get_Tp_Amount_Type(
1668: p_project_id => p_project_id,
1669: p_work_type_id => x_work_type_id,
1670: x_tp_amount_type => x_default_tp_amount_type,

Line 1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1683: x_carrying_out_organization_id := NULL ;
1684: x_default_assign_exp_type := NULL ;
1685: x_default_assign_exp_type_cls := NULL ;
1686: -- 4537865 : End
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1688: x_msg_count := 1;
1689: x_msg_data := SQLERRM;
1690: FND_MSG_PUB.add_exc_msg
1691: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_project_default',

Line 1707: x_return_status := FND_API.G_RET_STS_SUCCESS;

1703: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1704: )
1705: IS
1706: BEGIN
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708:
1709: begin
1710: SELECT b.job_group_id,
1711: a.default_job_id

Line 1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1735: -- 4537865 : Start
1736: x_default_job_group_id := NULL ;
1737: x_default_job_id := NULL ;
1738: -- 4537865 : End
1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1740: x_msg_count := 1;
1741: x_msg_data := SQLERRM;
1742: FND_MSG_PUB.add_exc_msg
1743: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Project_Role_default',