DBA Data[Home] [Help]

APPS.IEM_ARCH_PVT dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.Add;

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: );

Line 103: FND_MSG_PUB.Count_And_Get

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

Line 111: FND_MSG_PUB.Add;

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: );

Line 112: FND_MSG_PUB.Count_And_Get

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

Line 119: FND_MSG_PUB.Count_And_Get

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

Line 126: FND_MSG_PUB.Count_And_Get

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

Line 133: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 134: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 136: FND_MSG_PUB.Add_Exc_Msg

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;

Line 141: FND_MSG_PUB.Count_And_Get

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:

Line 218: FND_MSG_PUB.Count_And_Get

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

Line 224: FND_MSG_PUB.Count_And_Get

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

Line 230: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 231: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 233: FND_MSG_PUB.Add_Exc_Msg

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;

Line 238: FND_MSG_PUB.Count_And_Get

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:

Line 292: FND_MSG_PUB.Add;

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: );

Line 293: FND_MSG_PUB.Count_And_Get

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

Line 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;

Line 302: 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: );
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 308: FND_MSG_PUB.Count_And_Get

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

Line 316: FND_MSG_PUB.Add;

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: );

Line 317: FND_MSG_PUB.Count_And_Get

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

Line 323: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 324: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 326: FND_MSG_PUB.Add_Exc_Msg

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;

Line 331: FND_MSG_PUB.Count_And_Get

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:

Line 420: FND_MSG_PUB.Add;

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,