DBA Data[Home] [Help]

APPS.PA_PM_FUNCTION_SECURITY_PUB dependencies on FND_API

Line 37: p_return_status := FND_API.G_RET_STS_SUCCESS;

33:
34: BEGIN
35: -- The caching logic for checking the function security would not let the
36: -- initialisation of x_return_status happen. Hence moved this up
37: p_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: -- Included call to Check_Global_Vars, to check for global variables and
40: -- see if check_function_security procedure has already been called once.
41: -- This way, we are avoiding multiple calls to this procedure

Line 52: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,

48: IF G_found_or_not = 'N' THEN
49:
50:
51: -- Standard Api compatibility call
52: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
53: p_api_version_number ,
54: l_api_name ,
55: G_PKG_NAME )
56: THEN

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: p_api_version_number ,
54: l_api_name ,
55: G_PKG_NAME )
56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60: --p_return_status := FND_API.G_RET_STS_SUCCESS; Moved this above
61:

Line 60: --p_return_status := FND_API.G_RET_STS_SUCCESS; Moved this above

56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60: --p_return_status := FND_API.G_RET_STS_SUCCESS; Moved this above
61:
62: -- function security is enforced in Applications by excluding
63: -- a function from a given responsibility. Hence, if we get a
64: -- row for the cursor , then the function is not allowed

Line 137: WHEN FND_API.G_EXC_ERROR

133: -- dbms_output.put_line('x return status is '||p_return_status);
134:
135: EXCEPTION
136:
137: WHEN FND_API.G_EXC_ERROR
138: THEN
139:
140: p_return_status := FND_API.G_RET_STS_ERROR;
141:

Line 140: p_return_status := FND_API.G_RET_STS_ERROR;

136:
137: WHEN FND_API.G_EXC_ERROR
138: THEN
139:
140: p_return_status := FND_API.G_RET_STS_ERROR;
141:
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => p_msg_count ,
144: p_data => p_msg_data );

Line 146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

142: FND_MSG_PUB.Count_And_Get
143: ( p_count => p_msg_count ,
144: p_data => p_msg_data );
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
147: THEN
148: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149:
150: FND_MSG_PUB.Count_And_Get

Line 148: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: p_data => p_msg_data );
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
147: THEN
148: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149:
150: FND_MSG_PUB.Count_And_Get
151: ( p_count => p_msg_count ,
152: p_data => p_msg_data );

Line 157: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153:
154: WHEN OTHERS
155: THEN
156:
157: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158:
159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.add_exc_msg

Line 911: x_return_status := FND_API.G_RET_STS_SUCCESS;

907: l_function_name VARCHAR2(2000);
908:
909: BEGIN
910: /* Set module name and other standard things like setting error stack etc. */
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912:
913: l_module_name := g_module_name;
914: p_pa_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
915:

Line 1024: RAISE FND_API.G_EXC_ERROR;

1020: pa_utils.add_message(
1021: p_app_short_name => 'PA',
1022: p_msg_name => 'PA_PR_SECURITY_ENFORCED_AMG');
1023:
1024: RAISE FND_API.G_EXC_ERROR;
1025: ELSIF pa_security.allow_update (x_project_id => p_project_id ) = 'N' THEN
1026: IF p_pa_debug_mode = 'Y' THEN
1027: pa_debug.g_err_stage := 'Update Permission does not exist for project id '||p_project_id;
1028: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031: pa_utils.add_message(
1032: p_app_short_name => 'PA',
1033: p_msg_name => 'PA_PR_SECURITY_ENFORCED_AMG');
1034:
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038: IF p_pa_debug_mode = 'Y' THEN
1039: pa_debug.g_err_stage := 'Checking Function Securrity for '||p_function_name||

Line 1066: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1062: -- dbms_output.put_line('after checking for PA_PM_CREATE_DRAFT_BUDGET');
1063: -- dbms_output.put_line('x_return_status is '||x_return_status);
1064: -- dbms_output.put_line('l_ret_code is '||l_ret_code);
1065:
1066: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1067: l_ret_code = l_function_is_allowed THEN
1068: x_ret_code := l_function_is_allowed;
1069: ELSE
1070: x_ret_code := l_function_not_allowed;

Line 1100: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1096: p_msg_data => l_msg_data,
1097: p_return_status => x_return_status,
1098: p_function_allowed => l_ret_code);
1099:
1100: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1101: l_ret_code = l_function_is_allowed THEN
1102:
1103: x_ret_code := l_function_is_allowed;
1104:

Line 1137: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1133: p_msg_data => l_msg_data,
1134: p_return_status => x_return_status,
1135: p_function_allowed => l_ret_code);
1136:
1137: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1138: l_ret_code = l_function_is_allowed THEN
1139:
1140: x_ret_code := l_function_is_allowed;
1141: ELSE

Line 1172: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1168: p_msg_data => l_msg_data,
1169: p_return_status => x_return_status,
1170: p_function_allowed => l_ret_code);
1171:
1172: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1173: l_ret_code = l_function_is_allowed THEN
1174: x_ret_code := l_function_is_allowed;
1175: ELSE
1176: x_ret_code := l_function_not_allowed;

Line 1207: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1203: p_msg_data => l_msg_data,
1204: p_return_status => x_return_status,
1205: p_function_allowed => l_ret_code);
1206:
1207: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1208: l_ret_code = l_function_is_allowed THEN
1209:
1210: x_ret_code := l_function_is_allowed;
1211: ELSE

Line 1242: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1238: p_msg_data => l_msg_data,
1239: p_return_status => x_return_status,
1240: p_function_allowed => l_ret_code);
1241:
1242: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1243: l_ret_code = l_function_is_allowed THEN
1244: x_ret_code := l_function_is_allowed;
1245: ELSE
1246: x_ret_code := l_function_not_allowed;

Line 1276: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed

1272: p_msg_data => l_msg_data,
1273: p_return_status => x_return_status,
1274: p_function_allowed => l_ret_code);
1275:
1276: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed
1277: THEN
1278: x_ret_code := l_function_is_allowed;
1279: ELSE
1280: x_ret_code := l_function_not_allowed;

Line 1310: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed

1306: p_msg_data => l_msg_data,
1307: p_return_status => x_return_status,
1308: p_function_allowed => l_ret_code);
1309:
1310: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed
1311: THEN
1312: x_ret_code := l_function_is_allowed;
1313: ELSE
1314: x_ret_code := l_function_not_allowed;

Line 1347: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed

1343: p_msg_data => l_msg_data,
1344: p_return_status => x_return_status,
1345: p_function_allowed => l_ret_code);
1346:
1347: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed
1348: THEN
1349: x_ret_code := l_function_is_allowed;
1350: ELSE
1351: x_ret_code := l_function_not_allowed;

Line 1379: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed

1375: p_msg_data => l_msg_data,
1376: p_return_status => x_return_status,
1377: p_function_allowed => l_ret_code);
1378:
1379: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ret_code = l_function_is_allowed
1380: THEN
1381: x_ret_code := l_function_is_allowed;
1382: ELSE
1383: x_ret_code := l_function_not_allowed;

Line 1484: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1480: p_msg_data => l_msg_data,
1481: p_return_status => x_return_status,
1482: p_function_allowed => l_ret_code);
1483:
1484: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1485: l_ret_code = l_function_is_allowed THEN
1486: l_cost_ret_status := l_function_is_allowed;
1487: x_ret_code := l_function_is_allowed;
1488: ELSE

Line 1542: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1538: p_msg_data => l_msg_data,
1539: p_return_status => x_return_status,
1540: p_function_allowed => l_ret_code);
1541:
1542: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1543: l_ret_code = l_function_is_allowed THEN
1544: l_rev_ret_status := l_function_is_allowed;
1545: x_ret_code := l_function_is_allowed;
1546: ELSE

Line 1618: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1614: p_msg_data => l_msg_data,
1615: p_return_status => x_return_status,
1616: p_function_allowed => l_ret_code);
1617:
1618: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1619: l_ret_code = l_function_is_allowed THEN
1620: l_cost_ret_status := l_function_is_allowed;
1621: x_ret_code := l_function_is_allowed;
1622: ELSE

Line 1673: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1669: p_msg_data => l_msg_data,
1670: p_return_status => x_return_status,
1671: p_function_allowed => l_ret_code);
1672:
1673: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1674: l_ret_code = l_function_is_allowed THEN
1675: l_rev_ret_status := l_function_is_allowed;
1676: x_ret_code := l_function_is_allowed;
1677: ELSE

Line 1744: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1740: p_msg_data => l_msg_data,
1741: p_return_status => x_return_status,
1742: p_function_allowed => l_ret_code);
1743:
1744: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1745: l_ret_code = l_function_is_allowed THEN
1746: l_ret_code := l_function_is_allowed;
1747: x_ret_code := l_function_is_allowed;
1748: ELSE

Line 1796: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1792: p_msg_data => l_msg_data,
1793: p_return_status => x_return_status,
1794: p_function_allowed => l_ret_code);
1795:
1796: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1797: l_ret_code = l_function_is_allowed THEN
1798: l_ret_code := l_function_is_allowed;
1799: x_ret_code := l_function_is_allowed;
1800: ELSE

Line 1831: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1827: p_msg_data => l_msg_data,
1828: p_return_status => x_return_status,
1829: p_function_allowed => l_ret_code);
1830:
1831: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1832: l_ret_code = l_function_is_allowed THEN
1833: l_cost_ret_status := l_function_is_allowed;
1834: x_ret_code := l_function_is_allowed;
1835: ELSE

Line 1861: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1857: p_msg_data => l_msg_data,
1858: p_return_status => x_return_status,
1859: p_function_allowed => l_ret_code);
1860:
1861: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1862: l_ret_code = l_function_is_allowed THEN
1863: l_rev_ret_status := l_function_is_allowed;
1864: x_ret_code := l_function_is_allowed;
1865: ELSE

Line 1934: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1930: p_msg_data => l_msg_data,
1931: p_return_status => x_return_status,
1932: p_function_allowed => l_ret_code);
1933:
1934: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1935: l_ret_code = l_function_is_allowed THEN
1936: l_cost_ret_status := l_function_is_allowed;
1937: x_ret_code := l_function_is_allowed;
1938: ELSE

Line 1989: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

1985: p_msg_data => l_msg_data,
1986: p_return_status => x_return_status,
1987: p_function_allowed => l_ret_code);
1988:
1989: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
1990: l_ret_code = l_function_is_allowed THEN
1991: l_rev_ret_status := l_function_is_allowed;
1992: x_ret_code := l_function_is_allowed;
1993: ELSE

Line 2066: x_return_status := FND_API.G_RET_STS_ERROR;

2062: EXCEPTION
2063: WHEN PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC THEN
2064: l_ret_code :=l_function_not_allowed;
2065: x_ret_code := l_function_not_allowed;
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067:
2068: --Changes for bug 3182963
2069: IF p_pa_debug_mode = 'Y' THEN
2070: pa_debug.reset_curr_function;

Line 2075: WHEN FND_API.G_EXC_ERROR THEN

2071: END IF;
2072:
2073: RETURN;
2074:
2075: WHEN FND_API.G_EXC_ERROR THEN
2076: l_ret_code :=l_function_not_allowed;
2077: x_ret_code := l_function_not_allowed;
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079:

Line 2078: x_return_status := FND_API.G_RET_STS_ERROR;

2074:
2075: WHEN FND_API.G_EXC_ERROR THEN
2076: l_ret_code :=l_function_not_allowed;
2077: x_ret_code := l_function_not_allowed;
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079:
2080: --Changes for bug 3182963
2081: IF p_pa_debug_mode = 'Y' THEN
2082: pa_debug.reset_curr_function;

Line 2090: x_return_status := FND_API.G_RET_STS_ERROR;

2086:
2087: WHEN OTHERS THEN
2088: l_ret_code :=l_function_not_allowed;
2089: x_ret_code := l_function_not_allowed;
2090: x_return_status := FND_API.G_RET_STS_ERROR;
2091: IF p_pa_debug_mode = 'Y' THEN
2092: pa_debug.g_err_stage := 'Unexpected Exception: '||sqlerrm;
2093: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2094: END IF;

Line 2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2097: IF p_pa_debug_mode = 'Y' THEN
2098: pa_debug.reset_curr_function;
2099: END IF;
2100:
2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2102:
2103: END CHECK_BUDGET_SECURITY;
2104:
2105: END PA_PM_FUNCTION_SECURITY_PUB;