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

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

26: -- p_media_id - Document Content reference.
27:
28: PROCEDURE Add_Attachment(
29: p_api_version_number IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_seq_num IN VARCHAR2
33: ,p_category_id IN VARCHAR2
34: ,p_document_description IN VARCHAR2

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

27:
28: PROCEDURE Add_Attachment(
29: p_api_version_number IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_seq_num IN VARCHAR2
33: ,p_category_id IN VARCHAR2
34: ,p_document_description IN VARCHAR2
35: ,p_datatype_id IN VARCHAR2

Line 53: IF NOT FND_API.Compatible_API_Call (l_api_version

49:
50: -- Standard Start of API savepoint
51: SAVEPOINT Add_ATTACHMENT_PVT;
52:
53: IF NOT FND_API.Compatible_API_Call (l_api_version
54: ,P_Api_Version_Number
55: ,l_api_name
56: ,G_PKG_NAME )
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: ,P_Api_Version_Number
55: ,l_api_name
56: ,G_PKG_NAME )
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 63: IF FND_API.to_Boolean(p_init_msg_list) THEN

59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- Initialize API return status to error, i.e, its not duplicate

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- Initialize API return status to error, i.e, its not duplicate
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: FND_WEBATTCH.Add_Attachment(
71: seq_num => p_seq_num
72: ,category_id => p_category_id

Line 91: IF FND_API.to_Boolean( p_commit )

87: );
88:
89: -- End of API body.
90: -- Standard check of p_commit.
91: IF FND_API.to_Boolean( p_commit )
92: THEN
93: COMMIT WORK;
94: END IF;
95:

Line 105: WHEN FND_API.G_EXC_ERROR THEN

101: p_data => x_msg_data
102: );
103:
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
106: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
107: P_API_NAME => L_API_NAME
108: ,P_PKG_NAME => G_PKG_NAME
109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

113: ,X_MSG_COUNT => X_MSG_COUNT
114: ,X_MSG_DATA => X_MSG_DATA
115: ,X_RETURN_STATUS => X_RETURN_STATUS);
116:
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
119: P_API_NAME => L_API_NAME
120: ,P_PKG_NAME => G_PKG_NAME
121: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 146: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

142:
143:
144: PROCEDURE Copy_Attachments_To_Order(
145: p_api_version_number IN NUMBER
146: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
147: ,p_commit IN VARCHAR2 := FND_API.g_false
148: ,p_quote_header_id IN NUMBER
149: ,p_order_id IN NUMBER
150: ,p_order_line_tbl IN ASO_ORDER_INT.Order_Line_Tbl_Type

Line 147: ,p_commit IN VARCHAR2 := FND_API.g_false

143:
144: PROCEDURE Copy_Attachments_To_Order(
145: p_api_version_number IN NUMBER
146: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
147: ,p_commit IN VARCHAR2 := FND_API.g_false
148: ,p_quote_header_id IN NUMBER
149: ,p_order_id IN NUMBER
150: ,p_order_line_tbl IN ASO_ORDER_INT.Order_Line_Tbl_Type
151: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 170: IF NOT FND_API.Compatible_API_Call (l_api_version

166: BEGIN
167:
168: -- Standard Start of API savepoint
169: SAVEPOINT COPY_ATTACHMENTS_TO_ORDER_PVT;
170: IF NOT FND_API.Compatible_API_Call (l_api_version
171: ,P_Api_Version_Number
172: ,l_api_name
173: ,G_PKG_NAME )
174: THEN

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: ,P_Api_Version_Number
172: ,l_api_name
173: ,G_PKG_NAME )
174: THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 179: IF FND_API.to_Boolean(p_init_msg_list) THEN

175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean(p_init_msg_list) THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182:
183: -- Initialize API return status to error, i.e, its not duplicate

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: FND_MSG_PUB.initialize;
181: END IF;
182:
183: -- Initialize API return status to error, i.e, its not duplicate
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
187: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_header_id: ' || p_quote_header_id, 1, 'N');
188: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_id: ' || p_order_id, 1, 'N');

Line 193: p_init_msg_list => FND_API.G_FALSE,

189: END IF;
190:
191: ASO_ATTACHMENT_INT.Copy_Attachments(
192: p_api_version => l_api_version,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_commit => FND_API.G_FALSE,
195: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',
196: p_new_object_code => 'OE_ORDER_HEADERS',
197: p_old_object_id => p_quote_header_id,

Line 194: p_commit => FND_API.G_FALSE,

190:
191: ASO_ATTACHMENT_INT.Copy_Attachments(
192: p_api_version => l_api_version,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_commit => FND_API.G_FALSE,
195: p_old_object_code => 'ASO_QUOTE_HEADERS_ALL',
196: p_new_object_code => 'OE_ORDER_HEADERS',
197: p_old_object_id => p_quote_header_id,
198: p_new_object_id => p_order_id,

Line 204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

200: x_msg_count => x_msg_count,
201: x_msg_data => x_msg_data
202: );
203:
204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;

Line 205: RAISE FND_API.G_EXC_ERROR;

201: x_msg_data => x_msg_data
202: );
203:
204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:

Line 206: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

202: );
203:
204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203:
204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
211: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: line tbl count: ' || p_order_line_tbl.count, 1, 'N');

Line 227: p_init_msg_list => FND_API.G_FALSE,

223: END IF;
224:
225: ASO_ATTACHMENT_INT.Copy_Attachments(
226: p_api_version => l_api_version,
227: p_init_msg_list => FND_API.G_FALSE,
228: p_commit => FND_API.G_FALSE,
229: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
230: p_new_object_code => 'OE_ORDER_LINES',
231: p_old_object_id => l_quote_line_id,

Line 228: p_commit => FND_API.G_FALSE,

224:
225: ASO_ATTACHMENT_INT.Copy_Attachments(
226: p_api_version => l_api_version,
227: p_init_msg_list => FND_API.G_FALSE,
228: p_commit => FND_API.G_FALSE,
229: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
230: p_new_object_code => 'OE_ORDER_LINES',
231: p_old_object_id => l_quote_line_id,
232: p_new_object_id => p_order_line_tbl(i).ORDER_LINE_ID,

Line 238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data
236: );
237:
238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;

Line 239: RAISE FND_API.G_EXC_ERROR;

235: x_msg_data => x_msg_data
236: );
237:
238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243: END LOOP;

Line 240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

236: );
237:
238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243: END LOOP;
244:

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237:
238: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243: END LOOP;
244:
245: -- Standard check of p_commit.

Line 246: IF FND_API.to_Boolean( p_commit ) THEN

242: END IF;
243: END LOOP;
244:
245: -- Standard check of p_commit.
246: IF FND_API.to_Boolean( p_commit ) THEN
247: COMMIT WORK;
248: END IF;
249:
250: -- Standard call to get message count and if count is 1, get message info.

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: p_data => x_msg_data
254: );
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
259: P_API_NAME => L_API_NAME
260: ,P_PKG_NAME => G_PKG_NAME
261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

265: ,X_MSG_COUNT => X_MSG_COUNT
266: ,X_MSG_DATA => X_MSG_DATA
267: ,X_RETURN_STATUS => X_RETURN_STATUS);
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
271: P_API_NAME => L_API_NAME
272: ,P_PKG_NAME => G_PKG_NAME
273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 299: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

295:
296:
297: PROCEDURE Delete_Attachments(
298: p_api_version_number IN NUMBER
299: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
300: ,p_commit IN VARCHAR2 := FND_API.g_false
301: ,p_quote_header_id IN NUMBER
302: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
303: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 300: ,p_commit IN VARCHAR2 := FND_API.g_false

296:
297: PROCEDURE Delete_Attachments(
298: p_api_version_number IN NUMBER
299: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
300: ,p_commit IN VARCHAR2 := FND_API.g_false
301: ,p_quote_header_id IN NUMBER
302: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
303: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
304: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 337: IF NOT FND_API.Compatible_API_Call (l_api_version

333:
334: -- Standard Start of API savepoint
335: SAVEPOINT DELETE_ATTACHMENTS_PVT;
336:
337: IF NOT FND_API.Compatible_API_Call (l_api_version
338: ,P_Api_Version_Number
339: ,l_api_name
340: ,G_PKG_NAME )
341: THEN

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338: ,P_Api_Version_Number
339: ,l_api_name
340: ,G_PKG_NAME )
341: THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;
344:
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 347: IF FND_API.to_Boolean(p_init_msg_list) THEN

343: END IF;
344:
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean(p_init_msg_list) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350:
351:

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359:
360:
361:
362: -- Initialize API return status to error, i.e, its not duplicate
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: FOR i in 1..p_quote_attachment_ids.COUNT LOOP
366:
367: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 397: RAISE fnd_api.g_exc_error;

393: 'QUOTE_HEADER_ID', FALSE);
394: fnd_msg_pub.ADD;
395: END IF;
396:
397: RAISE fnd_api.g_exc_error;
398: ELSE
399: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
400: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');
401: END IF;

Line 452: IF FND_API.to_Boolean( p_commit )

448: END LOOP;
449:
450: -- End of API body.
451: -- Standard check of p_commit.
452: IF FND_API.to_Boolean( p_commit )
453: THEN
454: COMMIT WORK;
455: END IF;
456:

Line 466: WHEN FND_API.G_EXC_ERROR THEN

462: p_data => x_msg_data
463: );
464:
465: EXCEPTION
466: WHEN FND_API.G_EXC_ERROR THEN
467: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

474: ,X_MSG_COUNT => X_MSG_COUNT
475: ,X_MSG_DATA => X_MSG_DATA
476: ,X_RETURN_STATUS => X_RETURN_STATUS);
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
480: P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 508: * to fnd apis then its in one place instead of calling the fnd apis directly in aso apis

504:
505: /*
506: * The Purpose of this procedure is to build a wrapper around fnd attachment apis
507: * and use this api to copy attachments in all aso apis. So that if there is a change
508: * to fnd apis then its in one place instead of calling the fnd apis directly in aso apis
509: * in multiple places. Thus we have changed the parameter to have come name called object.
510: *
511: * An Object Code refers to the context from which the attachments are to be copied.
512: * For instance if this procedure is called from opportunity to quote then ,

Line 537: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

533: */
534: PROCEDURE Copy_Attachments
535: (
536: p_api_version IN NUMBER ,
537: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_old_object_code IN VARCHAR2 ,
540: p_new_object_code IN VARCHAR2 ,
541: p_old_object_id IN NUMBER ,

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

534: PROCEDURE Copy_Attachments
535: (
536: p_api_version IN NUMBER ,
537: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_old_object_code IN VARCHAR2 ,
540: p_new_object_code IN VARCHAR2 ,
541: p_old_object_id IN NUMBER ,
542: p_new_object_id IN NUMBER ,

Line 559: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,

555: -- Standard Start of API savepoint
556: SAVEPOINT Copy_Attachments_Pvt;
557:
558: -- Standard call to check for call compatibility.
559: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
560: p_api_version,
561: L_API_NAME ,
562: G_PKG_NAME )
563: THEN

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: p_api_version,
561: L_API_NAME ,
562: G_PKG_NAME )
563: THEN
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 568: IF FND_API.To_Boolean(p_init_msg_list) THEN

564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.To_Boolean(p_init_msg_list) THEN
569: FND_Msg_Pub.initialize;
570: END IF;
571:
572: -- Initialize API return status to success

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: FND_Msg_Pub.initialize;
570: END IF;
571:
572: -- Initialize API return status to success
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574: -- API body
575:
576: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
577: aso_debug_pub.add('COPY_ATTACHMENTS: old_object_id: ' || p_old_object_id, 1, 'N');

Line 590: IF FND_API.To_Boolean(p_commit) THEN

586: x_automatically_added_flag => null,
587: x_created_by => G_USER_ID);
588:
589: -- Standard check of p_commit.
590: IF FND_API.To_Boolean(p_commit) THEN
591: COMMIT WORK;
592: END IF;
593:
594: -- Standard call to get message count and if count is 1, get message info.

Line 595: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

591: COMMIT WORK;
592: END IF;
593:
594: -- Standard call to get message count and if count is 1, get message info.
595: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count ,
597: p_data => x_msg_data);
598:
599: EXCEPTION

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: p_count => x_msg_count ,
597: p_data => x_msg_data);
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

608: ,X_MSG_COUNT => X_MSG_COUNT
609: ,X_MSG_DATA => X_MSG_DATA
610: ,X_RETURN_STATUS => X_RETURN_STATUS);
611:
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
614: P_API_NAME => L_API_NAME
615: ,P_PKG_NAME => G_PKG_NAME
616: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR