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.CS_SR_SECURITY_UTIL dependencies on FND_API

Line 8: -- retrieved from the AOL grants model by invoking a FND API.

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_SR_SECURITY_UTIL';
5:
6: -- This function returns back the where predicate that gets appended to select
7: -- statements on the 'cs_incidents_b_sec' secure view. The where predicate is
8: -- retrieved from the AOL grants model by invoking a FND API.
9: FUNCTION SET_SR_ACCESS (
10: object_schema IN VARCHAR2,
11: object_name IN VARCHAR2 )
12: RETURN VARCHAR2

Line 42: -- if error status is returned from the FND API, clear the message

38: return '1=2';
39: -- return null;
40: END IF ;
41:
42: -- if error status is returned from the FND API, clear the message
43: -- stack.(The FND API pushes a msg. into the stack incase of an error)
44: FND_MESSAGE.CLEAR();
45: end if;
46:

Line 43: -- stack.(The FND API pushes a msg. into the stack incase of an error)

39: -- return null;
40: END IF ;
41:
42: -- if error status is returned from the FND API, clear the message
43: -- stack.(The FND API pushes a msg. into the stack incase of an error)
44: FND_MESSAGE.CLEAR();
45: end if;
46:
47: EXCEPTION

Line 56: -- is retrieved from the AOL grants model by invoking a FND API.

52: END SET_SR_ACCESS ;
53:
54: -- This function returns back the where predicate that gets appended to select
55: -- statements on the 'cs_sr_types_select_b' secure view. The where predicate
56: -- is retrieved from the AOL grants model by invoking a FND API.
57: FUNCTION SET_SR_TYPE_ACCESS (
58: object_schema IN VARCHAR2,
59: object_name IN VARCHAR2 )
60: RETURN VARCHAR2

Line 88: -- if error status is returned from the FND API, clear the message

84: ELSE
85: return null;
86: END IF ;
87:
88: -- if error status is returned from the FND API, clear the message
89: -- stack.(The FND API pushes a msg. into the stack incase of an error)
90: FND_MESSAGE.CLEAR();
91: end if;
92:

Line 89: -- stack.(The FND API pushes a msg. into the stack incase of an error)

85: return null;
86: END IF ;
87:
88: -- if error status is returned from the FND API, clear the message
89: -- stack.(The FND API pushes a msg. into the stack incase of an error)
90: FND_MESSAGE.CLEAR();
91: end if;
92:
93: EXCEPTION

Line 102: -- predicate is retrieved from the AOL grants model by invoking a FND API.

98: END SET_SR_TYPE_ACCESS ;
99:
100: -- This function returns back the where predicate that gets appended to select
101: -- statements on the 'cs_jtf_resource_select_sec' secure view. The where
102: -- predicate is retrieved from the AOL grants model by invoking a FND API.
103: FUNCTION SET_SR_RESOURCE_ACCESS (
104: object_schema IN VARCHAR2,
105: object_name IN VARCHAR2 )
106: RETURN VARCHAR2

Line 134: -- if error status is returned from the FND API, clear the message

130: ELSE
131: return null;
132: END IF ;
133:
134: -- if error status is returned from the FND API, clear the message
135: -- stack.(The FND API pushes a msg. into the stack incase of an error)
136: FND_MESSAGE.CLEAR();
137: end if;
138:

Line 135: -- stack.(The FND API pushes a msg. into the stack incase of an error)

131: return null;
132: END IF ;
133:
134: -- if error status is returned from the FND API, clear the message
135: -- stack.(The FND API pushes a msg. into the stack incase of an error)
136: FND_MESSAGE.CLEAR();
137: end if;
138:
139: EXCEPTION

Line 148: -- retrieved from the AOL grants model by invoking a FND API.

144: END SET_SR_RESOURCE_ACCESS ;
145:
146: -- This function returns back the where predicate that gets appended to select
147: -- statements on the 'cs_sr_access_resp_sec' secure view. The where predicate is
148: -- retrieved from the AOL grants model by invoking a FND API.
149: FUNCTION SET_SR_ACCESS_RESP (
150: object_schema IN VARCHAR2,
151: object_name IN VARCHAR2 )
152: RETURN VARCHAR2

Line 180: -- if error status is returned from the FND API, clear the message

176: ELSE
177: return null;
178: END IF ;
179:
180: -- if error status is returned from the FND API, clear the message
181: -- stack.(The FND API pushes a msg. into the stack incase of an error)
182: FND_MESSAGE.CLEAR();
183: end if;
184:

Line 181: -- stack.(The FND API pushes a msg. into the stack incase of an error)

177: return null;
178: END IF ;
179:
180: -- if error status is returned from the FND API, clear the message
181: -- stack.(The FND API pushes a msg. into the stack incase of an error)
182: FND_MESSAGE.CLEAR();
183: end if;
184:
185: EXCEPTION

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: x_return_status OUT NOCOPY VARCHAR2 )
196: IS
197: l_api_name_full VARCHAR2(40) := g_pkg_name || '.ENABLE_SR_POLICIES';
198: BEGIN
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: dbms_rls.enable_policy(
202: object_schema => 'APPS',
203: object_name => 'CS_INCIDENTS_B_SEC',

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: enable => TRUE );
224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
229: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
230: fnd_msg_pub.ADD;
231:

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: x_return_status OUT NOCOPY VARCHAR2 )
238: IS
239: l_api_name_full VARCHAR2(40) := g_pkg_name || '.DISABLE_SR_POLICIES';
240: BEGIN
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: dbms_rls.enable_policy(
244: object_schema => 'APPS',
245: object_name => 'CS_INCIDENTS_B_SEC',

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: enable => FALSE );
266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
271: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
272: fnd_msg_pub.ADD;
273:

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2) IS
603:
604: BEGIN
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: IF p_security_setting = 'ANONE' THEN
608: DISABLE_SR_POLICIES(x_return_status => x_return_status);
609:

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: END IF;
684:
685: EXCEPTION
686: WHEN others THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: FND_MSG_PUB.Count_And_Get
689: (p_count => x_msg_count,
690: p_data => x_msg_data );
691: