DBA Data[Home] [Help]

APPS.OE_OE_MULTI_HEADER_SCREDIT dependencies on FND_API

Line 19: (p_start_with_first Varchar2 default FND_API.G_TRUE

15:
16: -- Forward declaration of procedures maintaining entity record cache.
17:
18: Function Get_Multi_Errors
19: (p_start_with_first Varchar2 default FND_API.G_TRUE
20: ) Return Varchar2 IS
21: --
22: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
23: --

Line 25: if p_start_with_first = FND_API.G_TRUE

21: --
22: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
23: --
24: Begin
25: if p_start_with_first = FND_API.G_TRUE
26: then G_MULTI_MSG_INDEX := 1;
27: else
28: G_MULTI_MSG_INDEX := G_Multi_MSG_Index + 1;
29: end if;

Line 70: oe_msg_pub.get(I,FND_API.G_FALSE),

66: -- add_multi_errors(l_order_number);
67: /*
68: for I in 1..p_msg_count loop
69: oe_msg_pub.add_with_context(
70: oe_msg_pub.get(I,FND_API.G_FALSE),
71:
72: OE_GLOBALS.g_entity_header,to_char(p_header_id));
73: end loop;
74: */

Line 85: x_delim Varchar2(1) := FND_API.G_MISS_CHAR;

81: , Sub_string IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82: ) IS
83: Pos1 NUMBER;
84: Temp_sub_string VARCHAR2(200) := NULL;
85: x_delim Varchar2(1) := FND_API.G_MISS_CHAR;
86: --
87: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
88: --
89: BEGIN

Line 201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

197: , p_x_header_Scredit_rec => l_Header_Scredit_rec
198: , x_return_status => l_return_status
199: );
200:
201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198: , x_return_status => l_return_status
199: );
200:
201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: -- Set Operation.

Line 203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

199: );
200:
201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: -- Set Operation.
207:

Line 204: RAISE FND_API.G_EXC_ERROR;

200:
201: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: -- Set Operation.
207:
208: l_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_LOCK;

Line 224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

220: , p_x_header_Scredit_rec => l_Header_Scredit_rec
221: , x_return_status => l_return_status
222: );
223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;

Line 225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

221: , x_return_status => l_return_status
222: );
223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: -- Set Operation.

Line 226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

222: );
223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: -- Set Operation.
230:

Line 227: RAISE FND_API.G_EXC_ERROR;

223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: -- Set Operation.
230:
231: l_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_LOCK;

Line 247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

243: , p_x_header_Scredit_rec => l_Header_Scredit_rec
244: , x_return_status => l_return_status
245: );
246:
247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;

Line 248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

244: , x_return_status => l_return_status
245: );
246:
247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: -- Set Operation.

Line 249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

245: );
246:
247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: -- Set Operation.
253:

Line 250: RAISE FND_API.G_EXC_ERROR;

246:
247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: -- Set Operation.
253:
254: l_Header_Scredit_rec.operation := OE_GLOBALS.G_OPR_LOCK;

Line 270: , p_init_msg_list => FND_API.G_TRUE

266:
267: -- Call OE_Order_PVT.Process_order
268: OE_Order_PVT.Process_order
269: ( p_api_version_number => 1.0
270: , p_init_msg_list => FND_API.G_TRUE
271: , x_return_status => l_return_status
272: , x_msg_count => p_msg_count
273: , x_msg_data => p_msg_data
274: , p_control_rec => l_control_rec

Line 298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

294: , p_x_Line_Adj_Assoc_tbl => l_x_Line_Adj_Assoc_tbl
295:
296: );
297:
298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295:
296: );
297:
298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:

Line 300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

296: );
297:
298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: -- Set return status.

Line 301: RAISE FND_API.G_EXC_ERROR;

297:
298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: -- Set return status.
305:

Line 306: p_return_status := FND_API.G_RET_STS_SUCCESS;

302: END IF;
303:
304: -- Set return status.
305:
306: p_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: l_x_Header_Scredit_tbl.delete;
309: l_Old_Header_Scredit_tbl.delete;
310: -- Set control flags.

Line 366: , p_init_msg_list => FND_API.G_FALSE

362: OE_DELAYED_REQUESTS_PVT.Clear_Request(x_return_status => l_return_status);
363:
364: OE_Order_PVT.Process_order
365: ( p_api_version_number => 1.0
366: , p_init_msg_list => FND_API.G_FALSE
367: , x_return_status => l_return_status
368: , x_msg_count => p_msg_count
369: , x_msg_data => p_msg_data
370: , p_control_rec => l_control_rec

Line 395: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

391: , p_x_Line_Adj_Assoc_tbl => l_x_Line_Adj_Assoc_tbl
392:
393: );
394:
395: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;

Line 396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

392:
393: );
394:
395: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:

Line 397: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

393: );
394:
395: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: OE_OE_Form_Header_Scredit.Process_Entity

Line 398: RAISE FND_API.G_EXC_ERROR;

394:
395: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: OE_OE_Form_Header_Scredit.Process_Entity
402: (x_return_status =>l_return_status

Line 407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

403: ,x_msg_count => p_msg_count
404: ,x_msg_data => p_msg_data
405: );
406:
407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404: ,x_msg_data => p_msg_data
405: );
406:
407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:

Line 409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

405: );
406:
407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 410: RAISE FND_API.G_EXC_ERROR;

406:
407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: p_return_status := FND_API.G_RET_STS_SUCCESS;
414:

Line 413: p_return_status := FND_API.G_RET_STS_SUCCESS;

409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: p_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: p_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: p_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 419: p_return_status := FND_API.G_RET_STS_ERROR;

415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: p_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: p_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424:
425: WHEN OTHERS THEN

Line 423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

419: p_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424:
425: WHEN OTHERS THEN
426:
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

423: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424:
425: WHEN OTHERS THEN
426:
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428:
429: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: oe_msg_pub.Add_Exc_Msg

Line 440: (p_init IN Varchar2 Default FND_API.G_FALSE

436:
437: END Replace_Header_Scredit;
438:
439: Procedure Add_Multi_Header_Scredit_Req
440: (p_init IN Varchar2 Default FND_API.G_FALSE
441: ,p_salesrep_id IN Number
442: ,p_sales_Credit_type_id IN Number
443: ,p_percent IN Number
444: -- changes start for bug 3742335

Line 476: p_return_status := FND_API.G_RET_STS_SUCCESS;

472: --
473: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
474: --
475: BEGIN
476: p_return_status := FND_API.G_RET_STS_SUCCESS;
477: if p_init = FND_API.G_TRUE then
478: -- Initialize message list.
479: oe_msg_pub.initialize;
480: g_Header_Multi_Scredit_Count := 0;

Line 477: if p_init = FND_API.G_TRUE then

473: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
474: --
475: BEGIN
476: p_return_status := FND_API.G_RET_STS_SUCCESS;
477: if p_init = FND_API.G_TRUE then
478: -- Initialize message list.
479: oe_msg_pub.initialize;
480: g_Header_Multi_Scredit_Count := 0;
481: g_Header_Multi_Scredit_Tbl.delete;

Line 515: WHEN FND_API.G_EXC_ERROR THEN

511: , p_data => p_msg_data
512: );
513: EXCEPTION
514:
515: WHEN FND_API.G_EXC_ERROR THEN
516:
517: p_return_status := FND_API.G_RET_STS_ERROR;
518:
519: -- Get message count and data

Line 517: p_return_status := FND_API.G_RET_STS_ERROR;

513: EXCEPTION
514:
515: WHEN FND_API.G_EXC_ERROR THEN
516:
517: p_return_status := FND_API.G_RET_STS_ERROR;
518:
519: -- Get message count and data
520:
521: oe_msg_pub.Count_And_Get

Line 526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

522: ( p_count => p_msg_count
523: , p_data => p_msg_data
524: );
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527:
528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529:
530: -- Get message count and data

Line 528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

524: );
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527:
528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529:
530: -- Get message count and data
531:
532: oe_msg_pub.Count_And_Get

Line 539: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

535: );
536:
537: WHEN OTHERS THEN
538:
539: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
540:
541: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: oe_msg_pub.Add_Exc_Msg

Line 560: p_cont_on_error IN Varchar2 Default FND_API.G_TRUE

556: END Add_Multi_Header_Scredit_Req;
557:
558: Procedure Replace_Multi_Header_Scredit
559: (
560: p_cont_on_error IN Varchar2 Default FND_API.G_TRUE
561: ,p_header_id_list IN Oe_Globals.Selected_Record_Tbl --MOAC PI
562: ,p_replace_credit_type IN Varchar2
563: ,p_Return_Status OUT NOCOPY Varchar2
564:

Line 587: p_return_status := FND_API.G_RET_STS_SUCCESS;

583:
584: OE_MSG_PUB.initialize;
585: g_Multi_MSG_Tbl.Delete;
586: g_Multi_MSG_count := 0;
587: p_return_status := FND_API.G_RET_STS_SUCCESS;
588: --MOAC PI
589: i := p_header_id_list.first;
590: while i is not null loop
591: SAVEPOINT Header_Salescredit;

Line 607: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

603: ,p_replace_credit_type
604: ,l_return_status
605: ,l_msg_count
606: ,p_msg_data);
607: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
608: Copy_Errors_Multi_Msg(l_x_header_id,
609: l_msg_count);
610: p_return_status := l_return_status;
611: rollback to Header_Salescredit;

Line 612: if p_cont_on_error = FND_API.G_TRUE then

608: Copy_Errors_Multi_Msg(l_x_header_id,
609: l_msg_count);
610: p_return_status := l_return_status;
611: rollback to Header_Salescredit;
612: if p_cont_on_error = FND_API.G_TRUE then
613: null;
614: else
615: EXIT;
616: end if;

Line 620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

616: end if;
617: end if;
618: i := p_header_id_list.next(i); --MOAC PI
619: END LOOP;
620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: oe_msg_pub.Count_And_Get
624: ( p_count => p_msg_count

Line 621: RAISE FND_API.G_EXC_ERROR;

617: end if;
618: i := p_header_id_list.next(i); --MOAC PI
619: END LOOP;
620: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: oe_msg_pub.Count_And_Get
624: ( p_count => p_msg_count
625: , p_data => p_msg_data

Line 629: WHEN FND_API.G_EXC_ERROR THEN

625: , p_data => p_msg_data
626: );
627: EXCEPTION
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630:
631: p_return_status := FND_API.G_RET_STS_ERROR;
632:
633: -- Get message count and data

Line 631: p_return_status := FND_API.G_RET_STS_ERROR;

627: EXCEPTION
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630:
631: p_return_status := FND_API.G_RET_STS_ERROR;
632:
633: -- Get message count and data
634:
635: oe_msg_pub.Count_And_Get

Line 640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

636: ( p_count => p_msg_count
637: , p_data => p_msg_data
638: );
639:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641:
642: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
643:
644: -- Get message count and data

Line 642: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

638: );
639:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641:
642: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
643:
644: -- Get message count and data
645:
646: oe_msg_pub.Count_And_Get

Line 653: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

649: );
650:
651: WHEN OTHERS THEN
652:
653: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
654:
655: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
656: THEN
657: oe_msg_pub.Add_Exc_Msg