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

Line 34: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

30: ERROR_CREATING_REQUESTS EXCEPTION;
31:
32: BEGIN
33: -- Standard call to check for call compatibility.
34: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
35: p_api_version_number,
36: l_api_name,
37: G_PKG_NAME)
38: THEN

Line 39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

35: p_api_version_number,
36: l_api_name,
37: G_PKG_NAME)
38: THEN
39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
40: END IF;
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: SAVEPOINT SUBMIT_REQUEST_PVT;
43: -- Create a New Request Id

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: G_PKG_NAME)
38: THEN
39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
40: END IF;
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: SAVEPOINT SUBMIT_REQUEST_PVT;
43: -- Create a New Request Id
44: IF p_message_id.count>0 THEN --There are messages to process
45: select iem_arch_requests_s1.nextval into l_seq_id from dual;

Line 100: x_return_status := FND_API.G_RET_STS_ERROR ;

96: END IF;
97: EXCEPTION
98: WHEN ERROR_CREATING_DTL_REQUESTS THEN
99: rollback to SUBMIT_REQUEST_PVT;
100: x_return_status := FND_API.G_RET_STS_ERROR ;
101: FND_MESSAGE.SET_NAME('IEM','IEM_ARCH_DTL_SUBMIT_REQ_ERROR');
102: FND_MSG_PUB.Add;
103: FND_MSG_PUB.Count_And_Get
104: ( p_count => x_msg_count,

Line 109: x_return_status := FND_API.G_RET_STS_ERROR ;

105: p_data => x_msg_data
106: );
107: WHEN ERROR_CREATING_REQUESTS THEN
108: rollback to SUBMIT_REQUEST_PVT;
109: x_return_status := FND_API.G_RET_STS_ERROR ;
110: FND_MESSAGE.SET_NAME('IEM','IEM_ARCH_REQUEST_ERROR');
111: FND_MSG_PUB.Add;
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,

Line 116: WHEN FND_API.G_EXC_ERROR THEN

112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_ERROR THEN
117: rollback to SUBMIT_REQUEST_PVT;
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count,

Line 118: x_return_status := FND_API.G_RET_STS_ERROR ;

114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_ERROR THEN
117: rollback to SUBMIT_REQUEST_PVT;
118: x_return_status := FND_API.G_RET_STS_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count,
121: p_data => x_msg_data
122: );

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count,
121: p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: rollback to SUBMIT_REQUEST_PVT;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

121: p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: rollback to SUBMIT_REQUEST_PVT;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

128: p_data => x_msg_data
129: );
130: WHEN OTHERS THEN
131: rollback to SUBMIT_REQUEST_PVT;
132: x_return_status := FND_API.G_RET_STS_ERROR;
133: IF FND_MSG_PUB.Check_Msg_Level
134: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg

Line 173: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

169: l_arch_count number;
170: l_milcs_type number;
171: BEGIN
172: -- Standard call to check for call compatibility.
173: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
174: p_api_version_number,
175: l_api_name,
176: G_PKG_NAME)
177: THEN

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: p_api_version_number,
175: l_api_name,
176: G_PKG_NAME)
177: THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: IF p_request_type='P' THEN
182: l_milcs_type:=47;

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

176: G_PKG_NAME)
177: THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: IF p_request_type='P' THEN
182: l_milcs_type:=47;
183: END IF;
184:

Line 216: WHEN FND_API.G_EXC_ERROR THEN

212: IF p_commit='T' THEN
213: COMMIT WORK;
214: END IF;
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_ERROR ;
218: FND_MSG_PUB.Count_And_Get
219: ( p_count => x_msg_count,
220: p_data => x_msg_data

Line 217: x_return_status := FND_API.G_RET_STS_ERROR ;

213: COMMIT WORK;
214: END IF;
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_ERROR ;
218: FND_MSG_PUB.Count_And_Get
219: ( p_count => x_msg_count,
220: p_data => x_msg_data
221: );

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: FND_MSG_PUB.Count_And_Get
219: ( p_count => x_msg_count,
220: p_data => x_msg_data
221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => x_msg_count,
226: p_data => x_msg_data

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

219: ( p_count => x_msg_count,
220: p_data => x_msg_data
221: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => x_msg_count,
226: p_data => x_msg_data
227: );

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: ( p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228: WHEN OTHERS THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level
231: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg

Line 267: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

263: l_req_type iem_arch_requests.request_type%type;
264:
265: BEGIN
266: -- Standard call to check for call compatibility.
267: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
268: p_api_version_number,
269: l_api_name,
270: G_PKG_NAME)
271: THEN

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: p_api_version_number,
269: l_api_name,
270: G_PKG_NAME)
271: THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: delete from IEM_ARCH_REQUESTS
276: where request_id=p_request_id;

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270: G_PKG_NAME)
271: THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: delete from IEM_ARCH_REQUESTS
276: where request_id=p_request_id;
277: delete from IEM_ARCHIVED_DTLS
278: where request_id=p_request_id;

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: EXCEPTION
286: WHEN NO_DATA_FOUND THEN -- Not a Valid Request to cancell Do Nothing
287: null;
288: WHEN ERROR_FOLDER_DELETION THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: FND_MESSAGE.SET_NAME('IEM','IEM_ARCH_OES_FLD_DELETE_ERROR');
291: FND_MESSAGE.Set_Token('CODE',l_oes_ret_code);
292: FND_MSG_PUB.Add;
293: FND_MSG_PUB.Count_And_Get

Line 300: WHEN FND_API.G_EXC_ERROR THEN

296: );
297: FND_MSG_PUB.Count_And_Get
298: ( p_count => x_msg_count,
299: p_data => x_msg_data );
300: WHEN FND_API.G_EXC_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => x_msg_count,
304: p_data => x_msg_data

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297: FND_MSG_PUB.Count_And_Get
298: ( p_count => x_msg_count,
299: p_data => x_msg_data );
300: WHEN FND_API.G_EXC_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => x_msg_count,
304: p_data => x_msg_data
305: );

Line 306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

302: FND_MSG_PUB.Count_And_Get
303: ( p_count => x_msg_count,
304: p_data => x_msg_data
305: );
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR||p_request_id ;
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data

Line 307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR||p_request_id ;

303: ( p_count => x_msg_count,
304: p_data => x_msg_data
305: );
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR||p_request_id ;
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data
311: );

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: ( p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: WHEN ERROR_CANCEL_REQUEST THEN
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: FND_MESSAGE.SET_NAME('IEM','IEM_ARCH_CANCEL_ERROR');
315: FND_MESSAGE.Set_Token('ERROR_STRING',l_oes_ret_code);
316: FND_MSG_PUB.Add;
317: FND_MSG_PUB.Count_And_Get

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: ( p_count => x_msg_count ,
319: p_data => x_msg_data
320: );
321: WHEN OTHERS THEN
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: IF FND_MSG_PUB.Check_Msg_Level
324: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg