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 1246: x_return_status := FND_API.G_RET_STS_SUCCESS;

1242:
1243: BEGIN
1244:
1245: -- 4537865 : Initialize x_return_status to SUCCESS
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247:
1248: PA_DEBUG.Init_err_stack(
1249: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');
1250: -- Selecting columns corresponding to the given org id

Line 1293: x_return_status := FND_API.G_RET_STS_ERROR;

1289: x_nonbill_unassign_proj_id is null OR x_bill_unassign_proj_id is null) THEN
1290: PA_UTILS.Add_Message(
1291: p_app_short_name => 'PA'
1292: ,p_msg_name =>'PA_UNASSIGNED_PROJ_NO_DEFN');
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: x_msg_data := 'PA_UNASSIGNED_PROJ_NO_DEFN';
1295: x_msg_count := FND_MSG_PUB.Count_Msg;
1296:
1297: END IF;

Line 1304: x_return_status := FND_API.G_RET_STS_ERROR;

1300: WHEN NO_DATA_FOUND THEN
1301: PA_UTILS.Add_Message(
1302: p_app_short_name => 'PA'
1303: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
1304: x_return_status := FND_API.G_RET_STS_ERROR;
1305: x_msg_data := 'PA_FORECAST_OPTIONS_NOT_SETUP';
1306: x_msg_count := FND_MSG_PUB.Count_Msg;
1307: end;
1308: end if;

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1312: WHEN NO_DATA_FOUND THEN
1313:
1314: x_msg_count := 1;
1315: x_msg_data := sqlerrm;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: FND_MSG_PUB.add_exc_msg
1319: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1320: p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1323:
1324: WHEN OTHERS THEN
1325: x_msg_count := 1;
1326: x_msg_data := sqlerrm;
1327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1328:
1329: FND_MSG_PUB.add_exc_msg
1330: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions',
1331: p_procedure_name => PA_DEBUG.G_Err_Stack);

Line 1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

1401: EXIT WHEN l_week_starting_date > l_end_date; /* Bug#2462076 Changed p_end_date to l_end_date */
1402: li_cnt := li_cnt +1;
1403:
1404: END LOOP;
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406: PA_DEBUG.Reset_Err_Stack;
1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN

Line 1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1406: PA_DEBUG.Reset_Err_Stack;
1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1411: x_msg_count := 1;
1412: x_msg_data := SQLERRM;
1413: FND_MSG_PUB.add_exc_msg
1414: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Week_Dates_Range_Fc',

Line 1450: p_tp_amount_type_code<>FND_API.G_MISS_CHAR THEN

1446:
1447: PA_DEBUG.Init_err_stack(
1448: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType');
1449: IF p_tp_amount_type_code IS NOT NULL AND
1450: p_tp_amount_type_code<>FND_API.G_MISS_CHAR THEN
1451:
1452: IF p_check_id_flag = 'Y' THEN
1453:
1454: lv_error_msg := 'PA_AMOUNT_TYPE_CODE_AMBIGUOUS';

Line 1483: x_return_status := FND_API.G_RET_STS_SUCCESS;

1479: END IF;
1480:
1481: PA_DEBUG.Reset_Err_Stack;
1482:
1483: x_return_status := FND_API.G_RET_STS_SUCCESS;
1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN
1486: x_return_status := FND_API.G_RET_STS_ERROR;
1487: x_msg_data := lv_error_msg;

Line 1486: x_return_status := FND_API.G_RET_STS_ERROR;

1482:
1483: x_return_status := FND_API.G_RET_STS_SUCCESS;
1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN
1486: x_return_status := FND_API.G_RET_STS_ERROR;
1487: x_msg_data := lv_error_msg;
1488:
1489: -- 4537865 : Start
1490: x_tp_amount_type_code := NULL ;

Line 1499: x_return_status := FND_API.G_RET_STS_ERROR;

1495: (p_pkg_name =>
1496: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1497: p_procedure_name => PA_DEBUG.G_Err_Stack);
1498: WHEN TOO_MANY_ROWS THEN
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: x_msg_data := lv_error_msg;
1501:
1502: -- 4537865 : Start
1503: x_tp_amount_type_code := NULL ;

Line 1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1508: (p_pkg_name =>
1509: 'PA_FORECAST_ITEMS_UTILS.Check_TPAmountType',
1510: p_procedure_name => PA_DEBUG.G_Err_Stack);
1511: WHEN OTHERS THEN
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513:
1514: -- 4537865 : Start
1515: x_tp_amount_type_code := NULL ;
1516: x_tp_amount_type_desc := NULL ;

Line 1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

1569: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1570: )
1571: IS
1572: BEGIN
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: Get_Project_Default( p_assignment_type => p_assignment_type,
1576: p_project_id => p_project_id,
1577: x_work_type_id => x_work_type_id,

Line 1596: x_return_status := FND_API.G_RET_STS_ERROR;

1592: x_msg_count => x_msg_count,
1593: x_msg_data => x_msg_data );
1594:
1595: IF FND_MSG_PUB.Count_Msg > 0 THEN
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: x_msg_count := FND_MSG_PUB.Count_Msg;
1598: x_msg_data := NULL;
1599: END IF;
1600:

Line 1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1610: x_carrying_out_organization_id := NULL ;
1611: x_default_assign_exp_type := NULL ;
1612: x_default_assign_exp_type_cls := NULL ;
1613: -- 4537865 : End
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: x_msg_count := 1;
1616: x_msg_data := SQLERRM;
1617: FND_MSG_PUB.add_exc_msg
1618: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_assignment_default',

Line 1639: x_return_status := FND_API.G_RET_STS_SUCCESS;

1635: )
1636: IS
1637:
1638: BEGIN
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641: SELECT work_type_id,
1642: org_id,
1643: carrying_out_organization_id

Line 1664: x_return_status := FND_API.G_RET_STS_ERROR;

1660: WHEN NO_DATA_FOUND THEN
1661: PA_UTILS.Add_Message(
1662: p_app_short_name => 'PA'
1663: ,p_msg_name =>'PA_FORECAST_OPTIONS_NOT_SETUP');
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: end;
1666:
1667: -- Populate expenditure_organization_id only for requirement
1668: IF p_assignment_type <> 'OPEN_ASSIGNMENT' THEN

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

1669: x_org_id := NULL;
1670: x_carrying_out_organization_id := NULL;
1671: END IF;
1672:
1673: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1674: Pa_Fp_Org_Fcst_Utils.Get_Tp_Amount_Type(
1675: p_project_id => p_project_id,
1676: p_work_type_id => x_work_type_id,
1677: x_tp_amount_type => x_default_tp_amount_type,

Line 1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1690: x_carrying_out_organization_id := NULL ;
1691: x_default_assign_exp_type := NULL ;
1692: x_default_assign_exp_type_cls := NULL ;
1693: -- 4537865 : End
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: x_msg_count := 1;
1696: x_msg_data := SQLERRM;
1697: FND_MSG_PUB.add_exc_msg
1698: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_project_default',

Line 1714: x_return_status := FND_API.G_RET_STS_SUCCESS;

1710: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1711: )
1712: IS
1713: BEGIN
1714: x_return_status := FND_API.G_RET_STS_SUCCESS;
1715:
1716: begin
1717: SELECT b.job_group_id,
1718: a.default_job_id

Line 1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1742: -- 4537865 : Start
1743: x_default_job_group_id := NULL ;
1744: x_default_job_id := NULL ;
1745: -- 4537865 : End
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: x_msg_count := 1;
1748: x_msg_data := SQLERRM;
1749: FND_MSG_PUB.add_exc_msg
1750: (p_pkg_name => 'PA_FORECAST_ITEMS_UTILS.Get_Project_Role_default',