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

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

70: , 'Header_Value_Conversion'
71: );
72: END IF;
73:
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
75: null;
76:
77: END Header_Value_Conversion;
78:

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

136: , 'Line_Value_Conversion'
137: );
138: END IF;
139:
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
141: null;
142: END Line_Value_Conversion;
143:
144: ----------------------------------------------------------

Line 461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

457:
458: oe_debug_pub.add('Return status of validate entity API '
459: ||x_return_status);
460:
461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
462:
463: oe_debug_pub.add('Return status int the IF Expected error API '
464: ||x_return_status);
465: RAISE FND_API.G_EXC_ERROR;

Line 465: RAISE FND_API.G_EXC_ERROR;

461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
462:
463: oe_debug_pub.add('Return status int the IF Expected error API '
464: ||x_return_status);
465: RAISE FND_API.G_EXC_ERROR;
466:
467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
468:
469: oe_debug_pub.add('Return status int the ELSE in the unexpected errorAPI '

Line 467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

463: oe_debug_pub.add('Return status int the IF Expected error API '
464: ||x_return_status);
465: RAISE FND_API.G_EXC_ERROR;
466:
467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
468:
469: oe_debug_pub.add('Return status int the ELSE in the unexpected errorAPI '
470: ||x_return_status);
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
468:
469: oe_debug_pub.add('Return status int the ELSE in the unexpected errorAPI '
470: ||x_return_status);
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472:
473: END IF;
474:
475: oe_debug_pub.add('Before udation of the cache New Blanket MAX number after exp FROM the API '

Line 504: WHEN FND_API.G_EXC_ERROR THEN

500: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Header' ||x_msg_data);
501:
502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505:
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: -- Get message count and data
508:

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505:
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: -- Get message count and data
508:
509: oe_msg_pub.count_and_get
510: ( p_count => x_msg_count

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: ( p_count => x_msg_count
511: , p_data => x_msg_data
512: );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515:
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
517: -- Get message count and data
518: oe_msg_pub.count_and_get

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

512: );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515:
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
517: -- Get message count and data
518: oe_msg_pub.count_and_get
519: ( p_count => x_msg_count
520: , p_data => x_msg_data

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

520: , p_data => x_msg_data
521: );
522:
523: WHEN OTHERS THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525:
526: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
527:
528: OE_MSG_PUB.Add_Exc_Msg

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: BEGIN
556:
557: OE_MSG_PUB.initialize;
558:
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: if p_line_rec.line_id is null then
562:
563: l_old_line_rec := NULL;

Line 577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

573: OE_Blanket_Util.Validate_Entity(p_line_rec,
574: l_old_line_rec,
575: x_return_status);
576:
577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;

Line 578: RAISE FND_API.G_EXC_ERROR;

574: l_old_line_rec,
575: x_return_status);
576:
577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:

Line 579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

575: x_return_status);
576:
577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: Update_Line_Cache(p_line_rec);

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

576:
577: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: Update_Line_Cache(p_line_rec);
584:

Line 598: WHEN FND_API.G_EXC_ERROR THEN

594: oe_debug_pub.add('After Validate Entity of the cache x_msg_data Line' ||x_msg_data);
595:
596: EXCEPTION
597:
598: WHEN FND_API.G_EXC_ERROR THEN
599: oe_debug_pub.add('Return Status is-Exp ' || X_return_status);
600: x_return_status := FND_API.G_RET_STS_ERROR;
601:
602: -- Get message count and data

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596: EXCEPTION
597:
598: WHEN FND_API.G_EXC_ERROR THEN
599: oe_debug_pub.add('Return Status is-Exp ' || X_return_status);
600: x_return_status := FND_API.G_RET_STS_ERROR;
601:
602: -- Get message count and data
603:
604: oe_msg_pub.count_and_get

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

605: ( p_count => x_msg_count
606: , p_data => x_msg_data
607: );
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610:
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612:
613: -- Get message count and data

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

607: );
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610:
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612:
613: -- Get message count and data
614:
615: oe_msg_pub.count_and_get

Line 621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

617: , p_data => x_msg_data
618: );
619:
620: WHEN OTHERS THEN
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
622:
623: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
624:
625: OE_MSG_PUB.Add_Exc_Msg

Line 657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

653: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);
654:
655: OE_Blanket_Util.Insert_Row(p_header_rec,X_RETURN_STATUS);
656:
657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;

Line 658: RAISE FND_API.G_EXC_ERROR;

654:
655: OE_Blanket_Util.Insert_Row(p_header_rec,X_RETURN_STATUS);
656:
657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:

Line 659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

655: OE_Blanket_Util.Insert_Row(p_header_rec,X_RETURN_STATUS);
656:
657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:
663: oe_msg_pub.count_and_get

Line 660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656:
657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:
663: oe_msg_pub.count_and_get
664: ( p_count => x_msg_count

Line 671: WHEN FND_API.G_EXC_ERROR THEN

667: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);
668:
669: EXCEPTION
670:
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673:
674: -- Get message count and data
675:

Line 672: x_return_status := FND_API.G_RET_STS_ERROR;

668:
669: EXCEPTION
670:
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673:
674: -- Get message count and data
675:
676: oe_msg_pub.count_and_get

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: ( p_count => x_msg_count
678: , p_data => x_msg_data
679: );
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684:
685: -- Get message count and data

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

679: );
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682:
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684:
685: -- Get message count and data
686:
687: oe_msg_pub.count_and_get

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

689: , p_data => x_msg_data
690: );
691:
692: WHEN OTHERS THEN
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
694:
695: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: OE_MSG_PUB.Add_Exc_Msg
697: (G_PKG_NAME,

Line 729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

725: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Update_row', 1);
726:
727: OE_Blanket_Util.Update_Row(p_header_rec,X_RETURN_STATUS);
728:
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;

Line 730: RAISE FND_API.G_EXC_ERROR;

726:
727: OE_Blanket_Util.Update_Row(p_header_rec,X_RETURN_STATUS);
728:
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:

Line 731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

727: OE_Blanket_Util.Update_Row(p_header_rec,X_RETURN_STATUS);
728:
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: oe_msg_pub.count_and_get

Line 732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

728:
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: oe_msg_pub.count_and_get
736: ( p_count => x_msg_count

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: oe_debug_pub.add('Existing Header OE_Blanket_Form_Control.Update_row', 1);
740:
741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746:
747: -- Get message count and data

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746:
747: -- Get message count and data
748:
749: oe_msg_pub.count_and_get

Line 754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

750: ( p_count => x_msg_count
751: , p_data => x_msg_data
752: );
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755:
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757:
758: -- Get message count and data

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

752: );
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755:
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757:
758: -- Get message count and data
759:
760: oe_msg_pub.count_and_get

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

762: , p_data => x_msg_data
763: );
764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767:
768: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
769: OE_MSG_PUB.Add_Exc_Msg
770: (G_PKG_NAME,

Line 803: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

799:
800: OE_Blanket_Util.Delete_Row(p_header_id => p_header_id
801: ,X_RETURN_STATUS => x_return_status);
802:
803: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;

Line 804: RAISE FND_API.G_EXC_ERROR;

800: OE_Blanket_Util.Delete_Row(p_header_id => p_header_id
801: ,X_RETURN_STATUS => x_return_status);
802:
803: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:

Line 805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

801: ,X_RETURN_STATUS => x_return_status);
802:
803: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809: oe_msg_pub.count_and_get

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802:
803: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809: oe_msg_pub.count_and_get
810: ( p_count => x_msg_count

Line 817: WHEN FND_API.G_EXC_ERROR THEN

813: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.Delete_row', 1);
814:
815: EXCEPTION
816:
817: WHEN FND_API.G_EXC_ERROR THEN
818: x_return_status := FND_API.G_RET_STS_ERROR;
819:
820: -- Get message count and data
821:

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

814:
815: EXCEPTION
816:
817: WHEN FND_API.G_EXC_ERROR THEN
818: x_return_status := FND_API.G_RET_STS_ERROR;
819:
820: -- Get message count and data
821:
822: oe_msg_pub.count_and_get

Line 827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

823: ( p_count => x_msg_count
824: , p_data => x_msg_data
825: );
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828:
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830:
831: -- Get message count and data

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

825: );
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828:
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830:
831: -- Get message count and data
832:
833: oe_msg_pub.count_and_get

Line 839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

835: , p_data => x_msg_data
836: );
837:
838: WHEN OTHERS THEN
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840:
841: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
842: OE_MSG_PUB.Add_Exc_Msg
843: (G_PKG_NAME,

Line 874: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

870: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Insert_row', 1);
871:
872: OE_Blanket_Util.Insert_Row(p_line_rec,X_RETURN_STATUS);
873:
874: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
875: RAISE FND_API.G_EXC_ERROR;
876: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;

Line 875: RAISE FND_API.G_EXC_ERROR;

871:
872: OE_Blanket_Util.Insert_Row(p_line_rec,X_RETURN_STATUS);
873:
874: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
875: RAISE FND_API.G_EXC_ERROR;
876: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:

Line 876: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

872: OE_Blanket_Util.Insert_Row(p_line_rec,X_RETURN_STATUS);
873:
874: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
875: RAISE FND_API.G_EXC_ERROR;
876: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:
880: oe_msg_pub.count_and_get

Line 877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

873:
874: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
875: RAISE FND_API.G_EXC_ERROR;
876: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:
880: oe_msg_pub.count_and_get
881: ( p_count => x_msg_count

Line 888: WHEN FND_API.G_EXC_ERROR THEN

884: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Insert_row', 1);
885:
886: EXCEPTION
887:
888: WHEN FND_API.G_EXC_ERROR THEN
889: x_return_status := FND_API.G_RET_STS_ERROR;
890:
891: -- Get message count and data
892:

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885:
886: EXCEPTION
887:
888: WHEN FND_API.G_EXC_ERROR THEN
889: x_return_status := FND_API.G_RET_STS_ERROR;
890:
891: -- Get message count and data
892:
893: oe_msg_pub.count_and_get

Line 898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

894: ( p_count => x_msg_count
895: , p_data => x_msg_data
896: );
897:
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899:
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901:
902: -- Get message count and data

Line 900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

896: );
897:
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899:
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901:
902: -- Get message count and data
903:
904: oe_msg_pub.count_and_get

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

906: , p_data => x_msg_data
907: );
908:
909: WHEN OTHERS THEN
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
911:
912: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: OE_MSG_PUB.Add_Exc_Msg
914: (G_PKG_NAME,

Line 944: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

940: OE_MSG_PUB.initialize;
941: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Update_row', 1);
942: OE_Blanket_Util.Update_Row(p_line_rec,X_RETURN_STATUS);
943:
944: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;
946: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
948: END IF;

Line 945: RAISE FND_API.G_EXC_ERROR;

941: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Update_row', 1);
942: OE_Blanket_Util.Update_Row(p_line_rec,X_RETURN_STATUS);
943:
944: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;
946: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
948: END IF;
949:

Line 946: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

942: OE_Blanket_Util.Update_Row(p_line_rec,X_RETURN_STATUS);
943:
944: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;
946: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
948: END IF;
949:
950: oe_msg_pub.count_and_get

Line 947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

943:
944: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;
946: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
948: END IF;
949:
950: oe_msg_pub.count_and_get
951: ( p_count => x_msg_count

Line 958: WHEN FND_API.G_EXC_ERROR THEN

954: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Update_row', 1);
955:
956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: -- Get message count and data
962:

Line 959: x_return_status := FND_API.G_RET_STS_ERROR;

955:
956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: -- Get message count and data
962:
963: oe_msg_pub.count_and_get

Line 968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

964: ( p_count => x_msg_count
965: , p_data => x_msg_data
966: );
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969:
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
971:
972: -- Get message count and data

Line 970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

966: );
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969:
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
971:
972: -- Get message count and data
973:
974: oe_msg_pub.count_and_get

Line 980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

976: , p_data => x_msg_data
977: );
978:
979: WHEN OTHERS THEN
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
981:
982: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
983: OE_MSG_PUB.Add_Exc_Msg
984: (G_PKG_NAME,

Line 1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1012:
1013: OE_Blanket_Util.Delete_Row(p_line_id => p_line_id
1014: ,x_return_status => X_RETURN_STATUS);
1015:
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: OE_Blanket_Util.Delete_Row(p_line_id => p_line_id
1014: ,x_return_status => X_RETURN_STATUS);
1015:
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:

Line 1018: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1014: ,x_return_status => X_RETURN_STATUS);
1015:
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: oe_msg_pub.count_and_get

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015:
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: oe_msg_pub.count_and_get
1023: ( p_count => x_msg_count

Line 1030: WHEN FND_API.G_EXC_ERROR THEN

1026: oe_debug_pub.add('Exiting Lines OE_Blanket_Form_Control.Delete_row', 1);
1027:
1028: EXCEPTION
1029:
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032:
1033: -- Get message count and data
1034:

Line 1031: x_return_status := FND_API.G_RET_STS_ERROR;

1027:
1028: EXCEPTION
1029:
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032:
1033: -- Get message count and data
1034:
1035: oe_msg_pub.count_and_get

Line 1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1036: ( p_count => x_msg_count
1037: , p_data => x_msg_data
1038: );
1039:
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043:
1044: -- Get message count and data

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1038: );
1039:
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043:
1044: -- Get message count and data
1045:
1046: oe_msg_pub.count_and_get

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1048: , p_data => x_msg_data
1049: );
1050:
1051: WHEN OTHERS THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053:
1054: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1055: OE_MSG_PUB.Add_Exc_Msg
1056: (G_PKG_NAME,

Line 1095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1091: --p_x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1092:
1093: OE_Blanket_Util.Default_Attributes (p_x_header_rec,x_return_status);
1094:
1095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092:
1093: OE_Blanket_Util.Default_Attributes (p_x_header_rec,x_return_status);
1094:
1095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100:

Line 1097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1093: OE_Blanket_Util.Default_Attributes (p_x_header_rec,x_return_status);
1094:
1095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100:
1101: oe_msg_pub.count_and_get

Line 1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1094:
1095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100:
1101: oe_msg_pub.count_and_get
1102: ( p_count => x_msg_count

Line 1110: WHEN FND_API.G_EXC_ERROR THEN

1106: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1107: END IF;
1108:
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: -- Get message count and data
1113: oe_msg_pub.count_and_get
1114: ( p_count => x_msg_count

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

1107: END IF;
1108:
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: -- Get message count and data
1113: oe_msg_pub.count_and_get
1114: ( p_count => x_msg_count
1115: , p_data => x_msg_data

Line 1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES expected errors', 1);
1119: END IF;
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122:
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: -- Get message count and data
1125: oe_msg_pub.count_and_get

Line 1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1119: END IF;
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122:
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124: -- Get message count and data
1125: oe_msg_pub.count_and_get
1126: ( p_count => x_msg_count
1127: , p_data => x_msg_data

Line 1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1127: , p_data => x_msg_data
1128: );
1129:
1130: WHEN OTHERS THEN
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132:
1133: IF OE_MSG_PUB.Check_Msg_Level
1134: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1135: THEN

Line 1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1172: --p_x_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1173:
1174: OE_Blanket_Util.Default_Attributes (p_x_line_rec,p_default_from_header,x_return_status);
1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;

Line 1177: RAISE FND_API.G_EXC_ERROR;

1173:
1174: OE_Blanket_Util.Default_Attributes (p_x_line_rec,p_default_from_header,x_return_status);
1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181:

Line 1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1174: OE_Blanket_Util.Default_Attributes (p_x_line_rec,p_default_from_header,x_return_status);
1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181:
1182: -- Defaulting for Line Number

Line 1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181:
1182: -- Defaulting for Line Number
1183:

Line 1198: WHEN FND_API.G_EXC_ERROR THEN

1194:
1195: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: -- Get message count and data
1201: oe_msg_pub.count_and_get
1202: ( p_count => x_msg_count

Line 1199: x_return_status := FND_API.G_RET_STS_ERROR;

1195: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: -- Get message count and data
1201: oe_msg_pub.count_and_get
1202: ( p_count => x_msg_count
1203: , p_data => x_msg_data

Line 1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1202: ( p_count => x_msg_count
1203: , p_data => x_msg_data
1204: );
1205:
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207:
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: -- Get message count and data
1210: oe_msg_pub.count_and_get

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1204: );
1205:
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207:
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: -- Get message count and data
1210: oe_msg_pub.count_and_get
1211: ( p_count => x_msg_count
1212: , p_data => x_msg_data

Line 1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1213: );
1214:
1215: WHEN OTHERS THEN
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: -- Get message count and data
1220: OE_MSG_PUB.Count_And_Get
1221: ( p_count => x_msg_count,

Line 1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1263: p_header_id =>G_header_cache_rec(ctr).header_id,
1264: x_header_rec =>l_dummy_header_Rec,
1265: x_return_status =>l_return_status);
1266:
1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270: END IF;
1271: I := oe_delayed_requests_pvt.g_delayed_requests.first;

Line 1268: RAISE FND_API.G_EXC_ERROR;

1264: x_header_rec =>l_dummy_header_Rec,
1265: x_return_status =>l_return_status);
1266:
1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270: END IF;
1271: I := oe_delayed_requests_pvt.g_delayed_requests.first;
1272: WHILE I IS NOT NULL LOOP

Line 1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1280: OE_Blanket_Util.Validate_Entity(G_header_cache_rec(ctr),
1281: l_dummy_header_rec,
1282: x_return_status);
1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: END IF;

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281: l_dummy_header_rec,
1282: x_return_status);
1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: END IF;
1289: END IF;

Line 1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1282: x_return_status);
1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: END IF;
1289: END IF;
1290: END IF;

Line 1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1283:
1284: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: END IF;
1289: END IF;
1290: END IF;
1291: ctr := ctr + 1;

Line 1318: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1314: OE_Blanket_Util.Validate_Entity(G_line_cache_rec(ctr),
1315: l_dummy_line_rec,
1316: x_return_status);
1317:
1318: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;

Line 1319: RAISE FND_API.G_EXC_ERROR;

1315: l_dummy_line_rec,
1316: x_return_status);
1317:
1318: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323: END IF;

Line 1320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1316: x_return_status);
1317:
1318: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323: END IF;
1324: END IF;

Line 1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1317:
1318: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322: END IF;
1323: END IF;
1324: END IF;
1325: ctr := ctr + 1;

Line 1335: --x_return_status := FND_API.G_RET_STS_SUCCESS;

1331: ----------------------------------------------------------
1332: -- Insert or Update Header Records into the Database
1333: ----------------------------------------------------------
1334:
1335: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1336:
1337: --For bug 3217764. Altered the Exception Logic.
1338: --1. Moved the savepoint out of the loop
1339: --2. Commented out all the exception block and having a common exception block for the fn.

Line 1345: x_return_status := FND_API.G_RET_STS_SUCCESS;

1341: SAVEPOINT Save_Blanket_Changes;
1342:
1343: While ctr <= G_header_Cache_Rec.count loop
1344: oe_debug_pub.add('Operation IS: '||G_header_cache_rec(ctr).operation);
1345: x_return_status := FND_API.G_RET_STS_SUCCESS;
1346:
1347: If G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
1348: oe_debug_pub.add('Operation in Update Condi: '||G_header_cache_rec(ctr).operation);
1349: OE_Blanket_Util.Update_Row(G_header_Cache_Rec(ctr),x_return_status);

Line 1368: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1364: x_return_status => x_return_status);
1365: -- hashraf ... end of pack J
1366: End if;
1367:
1368: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1369: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1370: END IF;
1371:
1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1368: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1369: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1370: END IF;
1371:
1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;

Line 1373: RAISE FND_API.G_EXC_ERROR;

1369: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1370: END IF;
1371:
1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:

Line 1374: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1370: END IF;
1371:
1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378: oe_msg_pub.count_and_get

Line 1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1371:
1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378: oe_msg_pub.count_and_get
1379: ( p_count => x_msg_count

Line 1411: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1407: OE_Blanket_Util.Delete_Row(p_line_id => G_line_Cache_Rec(ctr).line_id, x_return_status => x_return_status);
1408: -- hashraf ... end of pack J
1409: End if;
1410:
1411: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1412: RAISE FND_API.G_EXC_ERROR;
1413: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;

Line 1412: RAISE FND_API.G_EXC_ERROR;

1408: -- hashraf ... end of pack J
1409: End if;
1410:
1411: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1412: RAISE FND_API.G_EXC_ERROR;
1413: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416:

Line 1413: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1409: End if;
1410:
1411: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1412: RAISE FND_API.G_EXC_ERROR;
1413: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416:
1417: oe_msg_pub.count_and_get

Line 1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1410:
1411: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1412: RAISE FND_API.G_EXC_ERROR;
1413: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416:
1417: oe_msg_pub.count_and_get
1418: ( p_count => x_msg_count

Line 1428: if x_return_status = FND_API.G_RET_STS_SUCCESS then

1424: */
1425: ctr := ctr + 1;
1426:
1427: end loop;
1428: if x_return_status = FND_API.G_RET_STS_SUCCESS then
1429: OE_Blanket_Util.Process_Object(x_return_status);
1430: end if;
1431:
1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1428: if x_return_status = FND_API.G_RET_STS_SUCCESS then
1429: OE_Blanket_Util.Process_Object(x_return_status);
1430: end if;
1431:
1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1433: RAISE FND_API.G_EXC_ERROR;
1434: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1433: RAISE FND_API.G_EXC_ERROR;

1429: OE_Blanket_Util.Process_Object(x_return_status);
1430: end if;
1431:
1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1433: RAISE FND_API.G_EXC_ERROR;
1434: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1437: --only delete cache if successfully processed delayed requests

Line 1434: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1430: end if;
1431:
1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1433: RAISE FND_API.G_EXC_ERROR;
1434: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1437: --only delete cache if successfully processed delayed requests
1438: g_header_cache_rec.delete;

Line 1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1431:
1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1433: RAISE FND_API.G_EXC_ERROR;
1434: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1437: --only delete cache if successfully processed delayed requests
1438: g_header_cache_rec.delete;
1439: g_line_cache_rec.delete;

Line 1436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1433: RAISE FND_API.G_EXC_ERROR;
1434: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1437: --only delete cache if successfully processed delayed requests
1438: g_header_cache_rec.delete;
1439: g_line_cache_rec.delete;
1440: END IF;

Line 1451: WHEN FND_API.G_EXC_ERROR THEN

1447: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_data'||x_msg_data);
1448: oe_debug_pub.add('Leaving from the Process Object OE_Blanket_Form_Control.Process_object ', 5);
1449:
1450: EXCEPTION
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453:
1454: -- Get message count and data
1455: oe_msg_pub.count_and_get

Line 1452: x_return_status := FND_API.G_RET_STS_ERROR;

1448: oe_debug_pub.add('Leaving from the Process Object OE_Blanket_Form_Control.Process_object ', 5);
1449:
1450: EXCEPTION
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453:
1454: -- Get message count and data
1455: oe_msg_pub.count_and_get
1456: ( p_count => x_msg_count

Line 1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1459: --for bug 3217764
1460: oe_debug_pub.add('Leaving the Process Object with excepted errors', 5);
1461: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464:
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1466: -- Get message count and data
1467:

Line 1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1461: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464:
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1466: -- Get message count and data
1467:
1468: oe_msg_pub.count_and_get
1469: ( p_count => x_msg_count

Line 1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1473: oe_debug_pub.add('Leaving the Process Object with unexcepted errors', 5);
1474: ROLLBACK TO SAVEPOINT Save_Blanket_Changes;
1475:
1476: WHEN OTHERS THEN
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1478:
1479: IF OE_MSG_PUB.Check_Msg_Level
1480: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1481: THEN

Line 1544: raise fnd_api.g_exc_error;

1540: ,p_record => l_rowtype_rec
1541: ,x_on_operation_action => l_action
1542: );
1543: if l_result = OE_PC_GLOBALS.YES then
1544: raise fnd_api.g_exc_error;
1545: end if;
1546:
1547: -- Check security for all attributes that changed
1548: ELSE

Line 1556: RAISE FND_API.G_EXC_ERROR;

1552: x_result => l_result,
1553: x_return_status => x_return_status);
1554:
1555: IF l_result = OE_PC_GLOBALS.YES THEN
1556: RAISE FND_API.G_EXC_ERROR;
1557: END IF;
1558:
1559: END IF; -- if column name is not null
1560:

Line 1570: WHEN FND_API.G_EXC_ERROR THEN

1566:
1567: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_attr');
1568: EXCEPTION
1569:
1570: WHEN FND_API.G_EXC_ERROR THEN
1571:
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: -- Get message count and data
1574:

Line 1572: x_return_status := FND_API.G_RET_STS_ERROR;

1568: EXCEPTION
1569:
1570: WHEN FND_API.G_EXC_ERROR THEN
1571:
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: -- Get message count and data
1574:
1575: oe_msg_pub.count_and_get
1576: ( p_count => x_msg_count

Line 1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1576: ( p_count => x_msg_count
1577: , p_data => x_msg_data
1578: );
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581:
1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1583: -- Get message count and data
1584: oe_msg_pub.count_and_get

Line 1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1578: );
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581:
1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1583: -- Get message count and data
1584: oe_msg_pub.count_and_get
1585: ( p_count => x_msg_count
1586: , p_data => x_msg_data

Line 1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1586: , p_data => x_msg_data
1587: );
1588:
1589: WHEN OTHERS THEN
1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1591:
1592: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1593:
1594: OE_MSG_PUB.Add_Exc_Msg

Line 1631: RAISE FND_API.G_EXC_ERROR;

1627: x_result => l_result,
1628: x_return_status => x_return_status);
1629:
1630: IF l_result = OE_PC_GLOBALS.YES THEN
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633: END IF;
1634:
1635: oe_msg_pub.count_and_get

Line 1641: WHEN FND_API.G_EXC_ERROR THEN

1637: , p_data => x_msg_data);
1638:
1639: EXCEPTION
1640:
1641: WHEN FND_API.G_EXC_ERROR THEN
1642:
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: -- Get message count and data
1645:

Line 1643: x_return_status := FND_API.G_RET_STS_ERROR;

1639: EXCEPTION
1640:
1641: WHEN FND_API.G_EXC_ERROR THEN
1642:
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: -- Get message count and data
1645:
1646: oe_msg_pub.count_and_get
1647: ( p_count => x_msg_count

Line 1651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1647: ( p_count => x_msg_count
1648: , p_data => x_msg_data
1649: );
1650:
1651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1652:
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1654: -- Get message count and data
1655: oe_msg_pub.count_and_get

Line 1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1649: );
1650:
1651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1652:
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1654: -- Get message count and data
1655: oe_msg_pub.count_and_get
1656: ( p_count => x_msg_count
1657: , p_data => x_msg_data

Line 1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1657: , p_data => x_msg_data
1658: );
1659:
1660: WHEN OTHERS THEN
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1662:
1663: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1664:
1665: OE_MSG_PUB.Add_Exc_Msg

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697: x_result => l_result,
1698: x_return_status => x_return_status);
1699:
1700: IF l_result = OE_PC_GLOBALS.YES THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:
1704: END IF;
1705:

Line 1713: WHEN FND_API.G_EXC_ERROR THEN

1709:
1710: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_Entity');
1711: EXCEPTION
1712:
1713: WHEN FND_API.G_EXC_ERROR THEN
1714:
1715: x_return_status := FND_API.G_RET_STS_ERROR;
1716: -- Get message count and data
1717:

Line 1715: x_return_status := FND_API.G_RET_STS_ERROR;

1711: EXCEPTION
1712:
1713: WHEN FND_API.G_EXC_ERROR THEN
1714:
1715: x_return_status := FND_API.G_RET_STS_ERROR;
1716: -- Get message count and data
1717:
1718: oe_msg_pub.count_and_get
1719: ( p_count => x_msg_count

Line 1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1719: ( p_count => x_msg_count
1720: , p_data => x_msg_data
1721: );
1722:
1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1724:
1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1726: -- Get message count and data
1727: oe_msg_pub.count_and_get

Line 1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1721: );
1722:
1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1724:
1725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1726: -- Get message count and data
1727: oe_msg_pub.count_and_get
1728: ( p_count => x_msg_count
1729: , p_data => x_msg_data

Line 1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1729: , p_data => x_msg_data
1730: );
1731:
1732: WHEN OTHERS THEN
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1734:
1735: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1736:
1737: OE_MSG_PUB.Add_Exc_Msg

Line 1772: RAISE FND_API.G_EXC_ERROR;

1768: x_result => l_result,
1769: x_return_status => x_return_status);
1770:
1771: IF l_result = OE_PC_GLOBALS.YES THEN
1772: RAISE FND_API.G_EXC_ERROR;
1773: END IF;
1774:
1775: END IF;
1776:

Line 1783: WHEN FND_API.G_EXC_ERROR THEN

1779: , p_data => x_msg_data);
1780:
1781: EXCEPTION
1782:
1783: WHEN FND_API.G_EXC_ERROR THEN
1784:
1785: x_return_status := FND_API.G_RET_STS_ERROR;
1786: -- Get message count and data
1787:

Line 1785: x_return_status := FND_API.G_RET_STS_ERROR;

1781: EXCEPTION
1782:
1783: WHEN FND_API.G_EXC_ERROR THEN
1784:
1785: x_return_status := FND_API.G_RET_STS_ERROR;
1786: -- Get message count and data
1787:
1788: oe_msg_pub.count_and_get
1789: ( p_count => x_msg_count

Line 1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1789: ( p_count => x_msg_count
1790: , p_data => x_msg_data
1791: );
1792:
1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1794:
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: -- Get message count and data
1797: oe_msg_pub.count_and_get

Line 1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1791: );
1792:
1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1794:
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: -- Get message count and data
1797: oe_msg_pub.count_and_get
1798: ( p_count => x_msg_count
1799: , p_data => x_msg_data

Line 1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1799: , p_data => x_msg_data
1800: );
1801:
1802: WHEN OTHERS THEN
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1804:
1805: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1806:
1807: OE_MSG_PUB.Add_Exc_Msg

Line 2337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2333: , 'Sales_Order_Type'
2334: );
2335: END IF;
2336:
2337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2338: end Sales_Order_Type;
2339: ----------------------------------------------------------
2340: FUNCTION item_identifier
2341: ----------------------------------------------------------

Line 2623: x_return_status := FND_API.G_RET_STS_SUCCESS;

2619: l_return_status Varchar2(30);
2620: BEGIN
2621: -- hashraf ... start of pack J
2622: OE_MSG_PUB.initialize;
2623: x_return_status := FND_API.G_RET_STS_SUCCESS;
2624:
2625: -- Clear the controller cache
2626: -- Clear_Header;
2627:

Line 2651: x_return_status := FND_API.G_RET_STS_ERROR;

2647: OE_MSG_PUB.Count_And_Get
2648: ( p_count => x_msg_count
2649: , p_data => x_msg_data
2650: );
2651: x_return_status := FND_API.G_RET_STS_ERROR;
2652:
2653: END Clear_Record;
2654:
2655: ----------------------------------------------------------