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,
105: p_data => x_msg_data
106: );
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,
105: p_data => x_msg_data
106: );
107: WHEN ERROR_CREATING_REQUESTS THEN
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,
114: p_data => x_msg_data
115: );
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,
114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_ERROR THEN
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: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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: );
130: WHEN OTHERS THEN
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
137: ( G_PKG_NAME ,
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
137: ( G_PKG_NAME ,
138: l_api_name
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
137: ( G_PKG_NAME ,
138: l_api_name
139: );
140: END IF;
137: ( G_PKG_NAME ,
138: l_api_name
139: );
140: END IF;
141: FND_MSG_PUB.Count_And_Get
142: ( p_count => x_msg_count ,
143: p_data => x_msg_data
144: );
145:
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: );
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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: );
228: WHEN OTHERS THEN
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
234: ( G_PKG_NAME ,
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
234: ( G_PKG_NAME ,
235: l_api_name
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
234: ( G_PKG_NAME ,
235: l_api_name
236: );
237: END IF;
234: ( G_PKG_NAME ,
235: l_api_name
236: );
237: END IF;
238: FND_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count ,
240: p_data => x_msg_data
241: );
242:
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
294: ( p_count => x_msg_count,
295: p_data => x_msg_data
296: );
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
294: ( p_count => x_msg_count,
295: p_data => x_msg_data
296: );
297: FND_MSG_PUB.Count_And_Get
293: FND_MSG_PUB.Count_And_Get
294: ( p_count => x_msg_count,
295: p_data => x_msg_data
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;
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: );
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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: );
312: WHEN ERROR_CANCEL_REQUEST THEN
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
318: ( p_count => x_msg_count ,
319: p_data => x_msg_data
320: );
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
318: ( p_count => x_msg_count ,
319: p_data => x_msg_data
320: );
321: WHEN OTHERS THEN
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
327: ( G_PKG_NAME ,
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
327: ( G_PKG_NAME ,
328: l_api_name
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
327: ( G_PKG_NAME ,
328: l_api_name
329: );
330: END IF;
327: ( G_PKG_NAME ,
328: l_api_name
329: );
330: END IF;
331: FND_MSG_PUB.Count_And_Get
332: ( p_count => x_msg_count ,
333: p_data => x_msg_data
334: );
335:
416: x_ret_status:='S';
417: EXCEPTION WHEN OTHERS THEN
418: x_ret_status:='E';
419: FND_MESSAGE.SET_NAME('IEM','IEM_ARCH_ORACLE_ERROR');
420: FND_MSG_PUB.Add;
421: END get_folder_dtl;
422:
423: PROCEDURE PROC_REQUESTS(ERRBUF OUT NOCOPY VARCHAR2,
424: ERRRET OUT NOCOPY VARCHAR2,