255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256:
257: -- Get message count and data
258:
259: oe_msg_pub.count_and_get
260: ( p_count => x_msg_count
261: , p_data => x_msg_data
262: );
263:
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: -- Get message count and data
277:
278: oe_msg_pub.count_and_get
279: ( p_count => x_msg_count
280: , p_data => x_msg_data
281: );
282:
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288:
289: -- Get message count and data
290:
291: oe_msg_pub.count_and_get
292: ( p_count => x_msg_count
293: , p_data => x_msg_data
294: );
295:
298: OE_GLOBALS.G_UI_FLAG := FALSE;
299:
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301:
302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: oe_msg_pub.Add_Exc_Msg
305: ( G_PKG_NAME
306: , 'Default_Attributes' || l_error
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301:
302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: oe_msg_pub.Add_Exc_Msg
305: ( G_PKG_NAME
306: , 'Default_Attributes' || l_error
307: );
308: END IF;
308: END IF;
309:
310: -- Get message count and data
311:
312: oe_msg_pub.count_and_get
313: ( p_count => x_msg_count
314: , p_data => x_msg_data
315: );
316:
464: x_line_rec:=x_line_tbl(1);
465: x_old_line_rec:=x_old_line_tbl(1);
466: x_line_val_rec:=x_line_val_tbl(1);
467:
468: oe_msg_pub.count_and_get
469: ( p_count => x_msg_count
470: , p_data => x_msg_data
471: );
472:
483: x_return_status := FND_API.G_RET_STS_ERROR;
484:
485: -- Get message count and data
486:
487: oe_msg_pub.count_and_get
488: ( p_count => x_msg_count
489: , p_data => x_msg_data
490: );
491:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497:
498: -- Get message count and data
499:
500: oe_msg_pub.count_and_get
501: ( p_count => x_msg_count
502: , p_data => x_msg_data
503: );
504:
507: OE_GLOBALS.G_UI_FLAG := FALSE;
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
510:
511: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: oe_msg_pub.Add_Exc_Msg
514: ( G_PKG_NAME
515: , 'Change_Attribute'
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
510:
511: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: oe_msg_pub.Add_Exc_Msg
514: ( G_PKG_NAME
515: , 'Change_Attribute'
516: );
517: END IF;
517: END IF;
518:
519: -- Get message count and data
520:
521: oe_msg_pub.count_and_get
522: ( p_count => x_msg_count
523: , p_data => x_msg_data
524: );
525:
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: -- Get message count and data
616:
617: oe_msg_pub.count_and_get
618: ( p_count => x_msg_count
619: , p_data => x_msg_data
620: );
621:
632: x_return_status := FND_API.G_RET_STS_ERROR;
633:
634: -- Get message count and data
635:
636: oe_msg_pub.count_and_get
637: ( p_count => x_msg_count
638: , p_data => x_msg_data
639: );
640:
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647:
648: -- Get message count and data
649:
650: oe_msg_pub.count_and_get
651: ( p_count => x_msg_count
652: , p_data => x_msg_data
653: );
654:
658: OE_GLOBALS.G_UI_FLAG := FALSE;
659:
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: oe_msg_pub.Add_Exc_Msg
665: ( G_PKG_NAME
666: , 'Delete_Row'
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: oe_msg_pub.Add_Exc_Msg
665: ( G_PKG_NAME
666: , 'Delete_Row'
667: );
668: END IF;
668: END IF;
669:
670: -- Get message count and data
671:
672: oe_msg_pub.count_and_get
673: ( p_count => x_msg_count
674: , p_data => x_msg_data
675: );
676:
709: --Bug 3025978
710: OE_GLOBALS.G_UI_FLAG := TRUE;
711:
712: -- Call OE_Line_Util.Lock_Row instead of Oe_Order_Pvt.Lock_order
713: OE_MSG_PUB.initialize;
714: OE_Line_Util.Lock_Row
715: ( x_return_status => l_return_status
716: , p_x_line_rec => l_x_line_rec
717: , p_line_id => p_line_id);
738: END IF;
739:
740: -- Get message count and data
741:
742: oe_msg_pub.count_and_get
743: ( p_count => x_msg_count
744: , p_data => x_msg_data
745: );
746:
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: -- Get message count and data
759:
760: oe_msg_pub.count_and_get
761: ( p_count => x_msg_count
762: , p_data => x_msg_data
763: );
764:
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
770:
771: -- Get message count and data
772:
773: oe_msg_pub.count_and_get
774: ( p_count => x_msg_count
775: , p_data => x_msg_data
776: );
777:
776: );
777:
778: WHEN OTHERS THEN
779:
780: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
781: THEN
782: oe_msg_pub.Add_Exc_Msg
783: ( G_PKG_NAME
784: , 'Lock_Row'
778: WHEN OTHERS THEN
779:
780: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
781: THEN
782: oe_msg_pub.Add_Exc_Msg
783: ( G_PKG_NAME
784: , 'Lock_Row'
785: );
786: END IF;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: -- Get message count and data
791:
792: oe_msg_pub.count_and_get
793: ( p_count => x_msg_count
794: , p_data => x_msg_data
795: );
796:
815: l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
816: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
817: l_index NUMBER; --3445778
818: BEGIN
819: OE_MSG_PUB.initialize;
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821:
822: OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
823: p_entity_code => OE_GLOBALS.G_ENTITY_LINE
840: x_return_status => l_return_status);
841:
842: -- End of 3445778
843:
844: OE_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count
846: , p_data => x_msg_data
847: );
848:
851:
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: OE_MSG_PUB.Add_Exc_Msg
858: ( G_PKG_NAME
859: , 'Clear_Record'
853: EXCEPTION
854: WHEN OTHERS THEN
855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
856: THEN
857: OE_MSG_PUB.Add_Exc_Msg
858: ( G_PKG_NAME
859: , 'Clear_Record'
860: );
861: END IF;
859: , 'Clear_Record'
860: );
861: END IF;
862: -- Get message count and data
863: OE_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count
865: , p_data => x_msg_data
866: );
867: x_return_status := FND_API.G_RET_STS_ERROR;