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

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2: -- $Header: ICXVTREB.pls 115.1 99/07/17 03:30:37 porting ship $
3:
4: PROCEDURE Create_Resp_Excl_Attr
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT VARCHAR2,

Line 7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

3:
4: PROCEDURE Create_Resp_Excl_Attr
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT VARCHAR2,
11: p_msg_count OUT NUMBER,

Line 8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4: PROCEDURE Create_Resp_Excl_Attr
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT VARCHAR2,
11: p_msg_count OUT NUMBER,
12: p_msg_data OUT VARCHAR2,

Line 9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT VARCHAR2,
11: p_msg_count OUT NUMBER,
12: p_msg_data OUT VARCHAR2,
13: -- p_msg_entity OUT VARCHAR2,

Line 38: if NOT FND_API.Compatible_API_Call

34: SAVEPOINT Create_Resp_Excl_Attr_PVT;
35:
36: -- Standard call to check for call compatibility.
37:
38: if NOT FND_API.Compatible_API_Call
39: (
40: l_api_version_number,
41: p_api_version_number,
42: l_api_name,

Line 46: raise FND_API.G_EXC_UNEXPECTED_ERROR;

42: l_api_name,
43: G_PKG_NAME
44: )
45: then
46: raise FND_API.G_EXC_UNEXPECTED_ERROR;
47: end if;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50:

Line 51: if FND_API.to_Boolean( p_init_msg_list)

47: end if;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50:
51: if FND_API.to_Boolean( p_init_msg_list)
52: then
53: FND_MSG_PUB.initialize;
54: end if;
55:

Line 58: p_return_status := FND_API.G_RET_STS_SUCCESS;

54: end if;
55:
56: -- Initialize API return status to success
57:
58: p_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: -- ************************************
61: -- VALIDATION - RESP_EXCL_ATTR
62: -- ************************************

Line 81: raise FND_API.G_EXC_ERROR;

77: -- !!!!Need create message through Rami
78:
79: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
80: fnd_msg_pub.Add;
81: raise FND_API.G_EXC_ERROR;
82: else
83: INSERT into AK_EXCLUDED_ITEMS
84: (
85: RESPONSIBILITY_ID ,

Line 117: raise FND_API.G_EXC_ERROR;

113:
114: fnd_message.set_name('FND','SQL-NO INSERT');
115: fnd_message.set_token('TABLE','FND_WEB_USERS');
116: fnd_msg_pub.Add;
117: raise FND_API.G_EXC_ERROR;
118: end if;
119: */
120: end if;
121:

Line 124: if FND_API.To_Boolean( p_commit)

120: end if;
121:
122: -- Standard check of p_commit;
123:
124: if FND_API.To_Boolean( p_commit)
125: then
126: commit work;
127: end if;
128:

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: );
136:
137: EXCEPTION
138:
139: WHEN FND_API.G_EXC_ERROR THEN
140:
141: Rollback to Create_Resp_Excl_Attr_PVT;
142: p_return_status := FND_API.G_RET_STS_ERROR;
143:

Line 142: p_return_status := FND_API.G_RET_STS_ERROR;

138:
139: WHEN FND_API.G_EXC_ERROR THEN
140:
141: Rollback to Create_Resp_Excl_Attr_PVT;
142: p_return_status := FND_API.G_RET_STS_ERROR;
143:
144: FND_MSG_PUB.Count_And_Get
145: (
146: p_count => p_msg_count,

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: p_count => p_msg_count,
147: p_data => p_msg_data
148: );
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151:
152: Rollback to Create_Resp_Excl_Attr_PVT;
153: p_return_status := FND_API.G_RET_STS_ERROR;
154:

Line 153: p_return_status := FND_API.G_RET_STS_ERROR;

149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151:
152: Rollback to Create_Resp_Excl_Attr_PVT;
153: p_return_status := FND_API.G_RET_STS_ERROR;
154:
155: FND_MSG_PUB.Count_And_Get
156: (
157: p_count => p_msg_count,

Line 164: p_return_status := FND_API.G_RET_STS_ERROR;

160:
161: WHEN OTHERS THEN
162:
163: Rollback to Create_Resp_Excl_Attr_PVT;
164: p_return_status := FND_API.G_RET_STS_ERROR;
165:
166: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
167: then
168: FND_MSG_PUB.Add_Exc_Msg

Line 188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

184:
185:
186: PROCEDURE Delete_Resp_Excl_Attr
187: ( p_api_version_number IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_return_status OUT VARCHAR2,

Line 189: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

185:
186: PROCEDURE Delete_Resp_Excl_Attr
187: ( p_api_version_number IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_return_status OUT VARCHAR2,
193: p_msg_count OUT NUMBER,

Line 190: p_commit IN VARCHAR2 := FND_API.G_FALSE,

186: PROCEDURE Delete_Resp_Excl_Attr
187: ( p_api_version_number IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_return_status OUT VARCHAR2,
193: p_msg_count OUT NUMBER,
194: p_msg_data OUT VARCHAR2,

Line 191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

187: ( p_api_version_number IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_return_status OUT VARCHAR2,
193: p_msg_count OUT NUMBER,
194: p_msg_data OUT VARCHAR2,
195: -- p_msg_entity OUT VARCHAR2,

Line 214: if NOT FND_API.Compatible_API_Call

210: SAVEPOINT Delete_Resp_Excl_Attr_PVT;
211:
212: -- Standard call to check for call compatibility.
213:
214: if NOT FND_API.Compatible_API_Call
215: (
216: l_api_version_number,
217: p_api_version_number,
218: l_api_name,

Line 222: raise FND_API.G_EXC_UNEXPECTED_ERROR;

218: l_api_name,
219: G_PKG_NAME
220: )
221: then
222: raise FND_API.G_EXC_UNEXPECTED_ERROR;
223: end if;
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226:

Line 227: if FND_API.to_Boolean( p_init_msg_list)

223: end if;
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE.
226:
227: if FND_API.to_Boolean( p_init_msg_list)
228: then
229: FND_MSG_PUB.initialize;
230: end if;
231:

Line 234: p_return_status := FND_API.G_RET_STS_SUCCESS;

230: end if;
231:
232: -- Initialize API return status to success
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: Delete from AK_EXCLUDED_ITEMS
237: where resp_application_id = p_application_id
238: and attribute_code = p_attribute_code

Line 251: raise FND_API.G_EXC_ERROR;

247:
248: fnd_message.set_name('FND','SQL-NO DELETE');
249: fnd_message.set_token('TABLE','FND_WEB_USER_RESPONSIBILITY');
250: fnd_msg_pub.Add;
251: raise FND_API.G_EXC_ERROR;
252: end if;
253:
254: -- Standard check of p_commit;
255:

Line 256: if FND_API.To_Boolean( p_commit)

252: end if;
253:
254: -- Standard check of p_commit;
255:
256: if FND_API.To_Boolean( p_commit)
257: then
258: commit work;
259: end if;
260:

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267: );
268:
269: EXCEPTION
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272:
273: Rollback to Delete_Resp_Excl_Attr_PVT;
274: p_return_status := FND_API.G_RET_STS_ERROR;
275:

Line 274: p_return_status := FND_API.G_RET_STS_ERROR;

270:
271: WHEN FND_API.G_EXC_ERROR THEN
272:
273: Rollback to Delete_Resp_Excl_Attr_PVT;
274: p_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MSG_PUB.Count_And_Get
277: (
278: p_count => p_msg_count,

Line 282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

278: p_count => p_msg_count,
279: p_data => p_msg_data
280: );
281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283:
284: Rollback to Delete_Resp_Excl_Attr_PVT;
285: p_return_status := FND_API.G_RET_STS_ERROR;
286:

Line 285: p_return_status := FND_API.G_RET_STS_ERROR;

281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283:
284: Rollback to Delete_Resp_Excl_Attr_PVT;
285: p_return_status := FND_API.G_RET_STS_ERROR;
286:
287: FND_MSG_PUB.Count_And_Get
288: (
289: p_count => p_msg_count,

Line 296: p_return_status := FND_API.G_RET_STS_ERROR;

292:
293: WHEN OTHERS THEN
294:
295: Rollback to Delete_Resp_Excl_Attr_PVT;
296: p_return_status := FND_API.G_RET_STS_ERROR;
297:
298: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: then
300: FND_MSG_PUB.Add_Exc_Msg