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

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: BEGIN
183: --dbms_output.put_line('in sum test test1');
184:
185: L_FuncProc := 'Get_Summary_Info';
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: pa_debug.g_err_stage:='Beginning of ' || L_FuncProc;
189: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
190:

Line 882: x_return_status := FND_API.G_RET_STS_SUCCESS;

878:
879: BEGIN
880:
881: L_FuncProc := 'Compute_Hierarchy';
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: pa_debug.g_err_stage:='Beginning of ' || L_FuncProc;
885: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
886:

Line 1456: x_return_status := FND_API.G_RET_STS_SUCCESS;

1452:
1453: l_user_id := FND_GLOBAL.USER_ID;
1454:
1455: L_FuncProc := 'Adjust_Planning_Transactions';
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457:
1458: pa_debug.g_err_stage:='Beginning of ' || L_FuncProc;
1459: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1460:

Line 1550: x_return_status := FND_API.G_RET_STS_ERROR;

1546: --PA_UTILS.ADD_MESSAGE
1547: -- (p_app_short_name => 'PA',
1548: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
1549: -- );
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: RETURN;
1552: ELSE
1553: l_locked_by_user_flag := 'Y';
1554: END IF;

Line 1573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1569:
1570: pa_debug.g_err_stage:= L_FuncProc || ' x_return_status: ' || x_return_status;
1571: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1572:
1573: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1574: pa_debug.g_err_stage:='Rasing API_EXCEPTION 1';
1575: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1576: RAISE api_exception;
1577: END IF;

Line 1588: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1584: x_return_status => x_return_status,
1585: x_msg_count => x_msg_count,
1586: x_msg_data => x_msg_data);
1587:
1588: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1589: pa_debug.g_err_stage:='Rasing API_EXCEPTION 2';
1590: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1591: RAISE api_exception;
1592: END IF;

Line 1607: x_return_status := FND_API.G_RET_STS_ERROR;

1603: (p_app_short_name => 'PA',
1604: p_msg_name => 'PA_NO_ACCESS_TO_UPDATE');
1605:
1606: pa_debug.reset_err_stack;
1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608: RETURN;
1609: ELSIF nvl(P_rev_budget_version_id, -1) <> -1 THEN
1610: -- No access to update for the cost version in terms of
1611: -- cost rate or burdened rate which applies to cost version only..

Line 1620: x_return_status := FND_API.G_RET_STS_ERROR;

1616: PA_UTILS.ADD_MESSAGE
1617: (p_app_short_name => 'PA',
1618: p_msg_name => 'PA_NO_ACCESS_TO_UPDATE');
1619: pa_debug.reset_err_stack;
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: RETURN;
1622: END IF;
1623:
1624: IF p_adjustment_type IN ( 'BILL_RATE', 'QUANTITY', 'REVENUE_QUANTITY','REVENUE') THEN

Line 1635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1631: x_return_status => x_return_status,
1632: x_msg_count => x_msg_count,
1633: x_msg_data => x_msg_data);
1634:
1635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1636: pa_debug.g_err_stage:='Rasing API_EXCEPTION 3';
1637: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1638: RAISE api_exception;
1639: END IF;

Line 1650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1646: x_return_status => x_return_status,
1647: x_msg_count => x_msg_count,
1648: x_msg_data => x_msg_data);
1649:
1650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1651: pa_debug.g_err_stage:='Rasing API_EXCEPTION 4';
1652: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1653: RAISE api_exception;
1654: END IF;

Line 1668: x_return_status := FND_API.G_RET_STS_ERROR;

1664: (p_app_short_name => 'PA',
1665: p_msg_name => 'PA_UPDATE_PUB_VER_ERR');
1666:
1667: pa_debug.reset_err_stack;
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669: RETURN;
1670: ELSIF p_adjustment_type IN ('QUANTITY', 'REVENUE_QUANTITY') AND
1671: (r_locked_by_user_flag <> 'Y' OR r_editable_flag <> 'Y' OR
1672: l_locked_by_user_flag <> 'Y' OR l_editable_flag <> 'Y') THEN

Line 1679: x_return_status := FND_API.G_RET_STS_ERROR;

1675: (p_app_short_name => 'PA',
1676: p_msg_name => 'PA_UPDATE_PUB_VER_ERR');
1677:
1678: pa_debug.reset_err_stack;
1679: x_return_status := FND_API.G_RET_STS_ERROR;
1680: RETURN;
1681: END IF;
1682: END IF; -- IF p_adjustment_type IN ( 'BILL_RATE', 'QUANTITY') THEN
1683: END IF; --IF P_rev_budget_version_id IS NULL AND

Line 1713: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1709: X_rev_res_assignment_id_tbl => L_rev_res_assignment_id_tbl,
1710: X_rev_txn_currency_code_tbl => L_rev_txn_curr_code_tbl,
1711: X_return_status => x_return_status);
1712:
1713: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1714: pa_debug.g_err_stage:='Rasing API_EXCEPTION 5';
1715: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1716: RAISE api_exception;
1717: END IF;

Line 1757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1753: l_rev_txn_curr_code_tbl := p_txn_currency_code_tbl;
1754: END IF;
1755: END IF;
1756:
1757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1758: pa_debug.g_err_stage:='Rasing API_EXCEPTION 7';
1759: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1760: RAISE api_exception;
1761: END IF;

Line 1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1796: x_return_status => x_return_status,
1797: x_msg_count => x_msg_count,
1798: x_msg_data => x_msg_data);
1799:
1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: pa_debug.g_err_stage:='Rasing API_EXCEPTION 8';
1802: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1803: RAISE api_exception;
1804: ELSE

Line 1898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1894: x_return_status => x_return_status,
1895: x_msg_count => x_msg_count,
1896: x_msg_data => x_msg_data);
1897:
1898: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1899: pa_debug.g_err_stage:='Rasing API_EXCEPTION 9';
1900: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
1901: RAISE api_exception;
1902: ELSE

Line 2017: x_return_status := FND_API.G_RET_STS_ERROR;

2013: IF l_res_assignment_id_tbl.COUNT = 0 AND l_rev_res_assignment_id_tbl.COUNT = 0 THEN
2014: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2015: ,p_msg_name => 'PA_PL_ADJUST_NO_DATA');
2016: x_msg_data := 'PA_PL_ADJUST_NO_DATA';
2017: x_return_status := FND_API.G_RET_STS_ERROR;
2018: RAISE FND_API.G_EXC_ERROR;
2019: ELSE
2020: IF nvl(p_cost_budget_version_id, -1) <> -1 AND
2021: ((p_adjustment_type IN ('COST_RATE', 'BURDENED_RATE', 'QUANTITY', 'COST_QUANTITY','RAW_COST','BURDENED_COST')) OR

Line 2018: RAISE FND_API.G_EXC_ERROR;

2014: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2015: ,p_msg_name => 'PA_PL_ADJUST_NO_DATA');
2016: x_msg_data := 'PA_PL_ADJUST_NO_DATA';
2017: x_return_status := FND_API.G_RET_STS_ERROR;
2018: RAISE FND_API.G_EXC_ERROR;
2019: ELSE
2020: IF nvl(p_cost_budget_version_id, -1) <> -1 AND
2021: ((p_adjustment_type IN ('COST_RATE', 'BURDENED_RATE', 'QUANTITY', 'COST_QUANTITY','RAW_COST','BURDENED_COST')) OR
2022: (p_cost_plan_setup = 'COST_AND_REV_SAME' AND p_adjustment_type in ('BILL_RATE','REVENUE'))) AND

Line 2045: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2041: ,p_txn_currency_code_tab => l_txn_curr_code_tbl
2042: ,x_return_status => x_return_status
2043: ,x_msg_count => x_msg_count
2044: ,x_msg_data => x_msg_data);
2045: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2046: pa_debug.g_err_stage:='Rasing API_EXCEPTION 10';
2047: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2048: RAISE api_exception;
2049: END IF;

Line 2059: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2055: p_fp_version_ids => l_target_budget_version_id_tbl,
2056: x_return_status => x_return_status,
2057: x_msg_code => x_msg_data);
2058:
2059: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2060: pa_debug.g_err_stage:='Rasing API_EXCEPTION 11';
2061: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2062: RAISE api_exception;
2063: END IF;

Line 2084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2080: ,p_txn_currency_code_tab => l_txn_curr_code_tbl
2081: ,x_return_status => x_return_status
2082: ,x_msg_count => x_msg_count
2083: ,x_msg_data => x_msg_data);
2084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2085: pa_debug.g_err_stage:='Rasing API_EXCEPTION 12';
2086: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2087: RAISE api_exception;
2088: END IF;

Line 2117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2113: ,p_txn_currency_code_tab => l_rev_txn_curr_code_tbl
2114: ,x_return_status => x_return_status
2115: ,x_msg_count => x_msg_count
2116: ,x_msg_data => x_msg_data);
2117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2118: pa_debug.g_err_stage:='Rasing API_EXCEPTION 13';
2119: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2120: RAISE api_exception;
2121: END IF;

Line 2131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2127: p_fp_version_ids => l_target_rev_version_id_tbl,
2128: x_return_status => x_return_status,
2129: x_msg_code => x_msg_data);
2130:
2131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2132: pa_debug.g_err_stage:='Rasing API_EXCEPTION 14';
2133: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2134: RAISE api_exception;
2135: END IF;

Line 2156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2152: ,p_txn_currency_code_tab => l_rev_txn_curr_code_tbl
2153: ,x_return_status => x_return_status
2154: ,x_msg_count => x_msg_count
2155: ,x_msg_data => x_msg_data);
2156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2157: pa_debug.g_err_stage:='Rasing API_EXCEPTION 15';
2158: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2159: RAISE api_exception;
2160: END IF;

Line 2164: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2160: END IF;
2161: END IF;
2162: END IF;
2163:
2164: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2165: COMMIT;
2166: END IF;
2167: END IF;
2168:

Line 2172: WHEN FND_API.G_EXC_ERROR THEN

2168:
2169: pa_debug.g_err_stage:='End of ' || L_FuncProc;
2170: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2171: EXCEPTION
2172: WHEN FND_API.G_EXC_ERROR THEN
2173: x_return_status := FND_API.G_RET_STS_ERROR;
2174: x_msg_count := Fnd_Msg_Pub.count_msg;
2175: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2176: PA_DEBUG.write_log (x_module => L_Module

Line 2173: x_return_status := FND_API.G_RET_STS_ERROR;

2169: pa_debug.g_err_stage:='End of ' || L_FuncProc;
2170: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
2171: EXCEPTION
2172: WHEN FND_API.G_EXC_ERROR THEN
2173: x_return_status := FND_API.G_RET_STS_ERROR;
2174: x_msg_count := Fnd_Msg_Pub.count_msg;
2175: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2176: PA_DEBUG.write_log (x_module => L_Module
2177: ,x_msg => 'Error: ' || L_FuncProc || ' ' || SQLERRM