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 OE_MSG_PUB

Line 30: OE_MSG_PUB.initialize;

26: l_header_rec OE_Order_PUB.Header_Rec_Type;
27: l_order_type varchar2(240);
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: BEGIN
30: OE_MSG_PUB.initialize;
31: l_header_rec.accounting_rule_id := p_header_rec.accounting_rule_id;
32: l_header_rec.agreement_id := p_header_rec.agreement_id;
33: l_header_rec.price_list_id := p_header_rec.price_list_id;
34: l_header_rec.deliver_to_org_id := p_header_rec.deliver_to_org_id;

Line 53: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

49: EXCEPTION
50:
51: WHEN NO_DATA_FOUND THEN
52:
53: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
54: THEN
55:
56: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
57: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header_Value_Conversion');

Line 58: OE_MSG_PUB.Add;

54: THEN
55:
56: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
57: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header_Value_Conversion');
58: OE_MSG_PUB.Add;
59:
60: END IF; */
61: null;
62:

Line 66: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

62:
63:
64: WHEN OTHERS THEN
65:
66: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
67: THEN
68: OE_MSG_PUB.Add_Exc_Msg
69: ( G_PKG_NAME
70: , 'Header_Value_Conversion'

Line 68: OE_MSG_PUB.Add_Exc_Msg

64: WHEN OTHERS THEN
65:
66: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
67: THEN
68: OE_MSG_PUB.Add_Exc_Msg
69: ( G_PKG_NAME
70: , 'Header_Value_Conversion'
71: );
72: END IF;

Line 91: OE_MSG_PUB.initialize;

87: l_line_rec OE_Order_PUB.Line_Rec_Type;
88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
89: BEGIN
90:
91: OE_MSG_PUB.initialize;
92: l_line_rec.invoice_to_org_id := p_line_rec.invoice_to_org_id;
93: l_line_rec.ship_to_org_id := p_line_rec.ship_to_org_id;
94: l_line_rec.deliver_to_org_id := p_line_rec.deliver_to_org_id;
95: l_line_rec.accounting_rule_id := p_line_rec.accounting_rule_id;

Line 119: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

115: EXCEPTION
116:
117: WHEN NO_DATA_FOUND THEN
118:
119: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
120: THEN
121:
122: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Value_Conversion');

Line 124: OE_MSG_PUB.Add;

120: THEN
121:
122: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Value_Conversion');
124: OE_MSG_PUB.Add;
125:
126: END IF; */
127: null;
128:

Line 132: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

128:
129:
130: WHEN OTHERS THEN
131:
132: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: OE_MSG_PUB.Add_Exc_Msg
135: ( G_PKG_NAME
136: , 'Line_Value_Conversion'

Line 134: OE_MSG_PUB.Add_Exc_Msg

130: WHEN OTHERS THEN
131:
132: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: OE_MSG_PUB.Add_Exc_Msg
135: ( G_PKG_NAME
136: , 'Line_Value_Conversion'
137: );
138: END IF;

Line 154: OE_MSG_PUB.initialize;

150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
151:
152: BEGIN
153:
154: OE_MSG_PUB.initialize;
155:
156: OE_ID_TO_VALUE.Ship_From_Org(
157: p_ship_from_org_id => p_header_rec.ship_from_org_id
158: ,x_ship_from_address1 => p_header_val_rec.ship_from_address1

Line 296: OE_MSG_PUB.initialize;

292: )IS
293: BEGIN
294: oe_debug_pub.add('enter Populate_Line_Values_ID');
295:
296: OE_MSG_PUB.initialize;
297: OE_ID_TO_VALUE.Ship_From_Org(
298: p_ship_from_org_id => p_line_rec.ship_from_org_id
299: ,x_ship_from_address1 => p_line_val_rec.ship_from_address1
300: ,x_ship_from_address2 => p_line_val_rec.ship_from_address2

Line 421: OE_MSG_PUB.initialize;

417: l_old_blanket_number number;
418: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Entity';
419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
420: BEGIN
421: OE_MSG_PUB.initialize;
422:
423:
424: l_old_blanket_number := p_header_rec.order_number;
425:

Line 495: oe_msg_pub.count_and_get

491: ||p_header_rec.blanket_min_amount);
492: oe_debug_pub.add('After udation of the cache OLd Blanket MIN number after exp FROM the API '
493: ||l_old_header_rec.blanket_min_amount);
494:
495: oe_msg_pub.count_and_get
496: ( p_count => x_msg_count
497: , p_data => x_msg_data);
498:
499: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Header' ||x_msg_count);

Line 509: oe_msg_pub.count_and_get

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
511: , p_data => x_msg_data
512: );
513:

Line 518: oe_msg_pub.count_and_get

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

Line 526: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
529: (G_PKG_NAME,
530: l_api_name);

Line 528: OE_MSG_PUB.Add_Exc_Msg

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
529: (G_PKG_NAME,
530: l_api_name);
531:
532: END IF;

Line 536: OE_MSG_PUB.Count_And_Get

532: END IF;
533:
534: -- Get message count and data
535:
536: OE_MSG_PUB.Count_And_Get
537: ( p_count => x_msg_count,
538: p_data => x_msg_data);
539:
540: END Validate_Entity;

Line 557: OE_MSG_PUB.initialize;

553: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Entity';
554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
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

Line 589: oe_msg_pub.count_and_get

585: if nvl(G_Blanket_Line_Number,0) < nvl(p_line_rec.line_number,0) then
586: G_Blanket_Line_Number := p_line_rec.line_Number;
587: end if;
588:
589: oe_msg_pub.count_and_get
590: ( p_count => x_msg_count
591: , p_data => x_msg_data);
592:
593: oe_debug_pub.add('After Validate Entity of the cache x_msg_count Line' ||x_msg_count);

Line 604: oe_msg_pub.count_and_get

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
605: ( p_count => x_msg_count
606: , p_data => x_msg_data
607: );
608:

Line 615: oe_msg_pub.count_and_get

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
616: ( p_count => x_msg_count
617: , p_data => x_msg_data
618: );
619:

Line 623: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
626: (G_PKG_NAME,
627: l_api_name);

Line 625: OE_MSG_PUB.Add_Exc_Msg

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
626: (G_PKG_NAME,
627: l_api_name);
628:
629: END IF;

Line 633: OE_MSG_PUB.Count_And_Get

629: END IF;
630:
631: -- Get message count and data
632:
633: OE_MSG_PUB.Count_And_Get
634: ( p_count => x_msg_count,
635: p_data => x_msg_data);
636:
637: END Validate_Entity;

Line 652: OE_MSG_PUB.initialize;

648: IS
649: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: BEGIN
652: OE_MSG_PUB.initialize;
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:

Line 663: oe_msg_pub.count_and_get

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
665: , p_data => x_msg_data);
666:
667: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);

Line 676: oe_msg_pub.count_and_get

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
677: ( p_count => x_msg_count
678: , p_data => x_msg_data
679: );
680:

Line 687: oe_msg_pub.count_and_get

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
688: ( p_count => x_msg_count
689: , p_data => x_msg_data
690: );
691:

Line 695: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
698: l_api_name
699: );

Line 696: OE_MSG_PUB.Add_Exc_Msg

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,
698: l_api_name
699: );
700: END IF;

Line 704: OE_MSG_PUB.Count_And_Get

700: END IF;
701:
702: -- Get message count and data
703:
704: OE_MSG_PUB.Count_And_Get
705: ( p_count => x_msg_count,
706: p_data => x_msg_data);
707:
708: End Insert_Row;

Line 724: OE_MSG_PUB.initialize;

720: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
721: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
722:
723: BEGIN
724: OE_MSG_PUB.initialize;
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:

Line 735: oe_msg_pub.count_and_get

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
737: , p_data => x_msg_data);
738:
739: oe_debug_pub.add('Existing Header OE_Blanket_Form_Control.Update_row', 1);

Line 749: oe_msg_pub.count_and_get

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
750: ( p_count => x_msg_count
751: , p_data => x_msg_data
752: );
753:

Line 760: oe_msg_pub.count_and_get

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
761: ( p_count => x_msg_count
762: , p_data => x_msg_data
763: );
764:

Line 768: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
771: l_api_name
772: );

Line 769: OE_MSG_PUB.Add_Exc_Msg

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,
771: l_api_name
772: );
773: END IF;

Line 777: OE_MSG_PUB.Count_And_Get

773: END IF;
774:
775: -- Get message count and data
776:
777: OE_MSG_PUB.Count_And_Get
778: ( p_count => x_msg_count,
779: p_data => x_msg_data);
780:
781: End Update_Row;

Line 797: OE_MSG_PUB.initialize;

793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
794: BEGIN
795: -- hashraf ... start of pack J
796:
797: OE_MSG_PUB.initialize;
798: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Delete_row', 1);
799:
800: OE_Blanket_Util.Delete_Row(p_header_id => p_header_id
801: ,X_RETURN_STATUS => x_return_status);

Line 809: oe_msg_pub.count_and_get

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
811: , p_data => x_msg_data);
812:
813: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.Delete_row', 1);

Line 822: oe_msg_pub.count_and_get

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
823: ( p_count => x_msg_count
824: , p_data => x_msg_data
825: );
826:

Line 833: oe_msg_pub.count_and_get

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
834: ( p_count => x_msg_count
835: , p_data => x_msg_data
836: );
837:

Line 841: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
844: l_api_name
845: );

Line 842: OE_MSG_PUB.Add_Exc_Msg

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,
844: l_api_name
845: );
846: END IF;

Line 850: OE_MSG_PUB.Count_And_Get

846: END IF;
847:
848: -- Get message count and data
849:
850: OE_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count,
852: p_data => x_msg_data);
853:
854: End Delete_Row;

Line 869: OE_MSG_PUB.initialize;

865: IS
866: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
867: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
868: BEGIN
869: OE_MSG_PUB.initialize;
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:

Line 880: oe_msg_pub.count_and_get

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
882: , p_data => x_msg_data);
883:
884: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Insert_row', 1);

Line 893: oe_msg_pub.count_and_get

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
894: ( p_count => x_msg_count
895: , p_data => x_msg_data
896: );
897:

Line 904: oe_msg_pub.count_and_get

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
905: ( p_count => x_msg_count
906: , p_data => x_msg_data
907: );
908:

Line 912: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
915: l_api_name
916: );

Line 913: OE_MSG_PUB.Add_Exc_Msg

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,
915: l_api_name
916: );
917: END IF;

Line 921: OE_MSG_PUB.Count_And_Get

917: END IF;
918:
919: -- Get message count and data
920:
921: OE_MSG_PUB.Count_And_Get
922: ( p_count => x_msg_count,
923: p_data => x_msg_data);
924:
925: End Insert_Row;

Line 940: OE_MSG_PUB.initialize;

936: IS
937: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
939: BEGIN
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

Line 950: oe_msg_pub.count_and_get

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
952: , p_data => x_msg_data);
953:
954: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Update_row', 1);

Line 963: oe_msg_pub.count_and_get

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
964: ( p_count => x_msg_count
965: , p_data => x_msg_data
966: );
967:

Line 974: oe_msg_pub.count_and_get

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
975: ( p_count => x_msg_count
976: , p_data => x_msg_data
977: );
978:

Line 982: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
985: l_api_name
986: );

Line 983: OE_MSG_PUB.Add_Exc_Msg

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,
985: l_api_name
986: );
987: END IF;

Line 991: OE_MSG_PUB.Count_And_Get

987: END IF;
988:
989: -- Get message count and data
990:
991: OE_MSG_PUB.Count_And_Get
992: ( p_count => x_msg_count,
993: p_data => x_msg_data);
994:
995: End Update_Row;

Line 1010: OE_MSG_PUB.initialize;

1006: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1008: BEGIN
1009: -- hashraf ... start of pack J
1010: OE_MSG_PUB.initialize;
1011: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Delete_row', 1);
1012:
1013: OE_Blanket_Util.Delete_Row(p_line_id => p_line_id
1014: ,x_return_status => X_RETURN_STATUS);

Line 1022: oe_msg_pub.count_and_get

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
1024: , p_data => x_msg_data);
1025:
1026: oe_debug_pub.add('Exiting Lines OE_Blanket_Form_Control.Delete_row', 1);

Line 1035: oe_msg_pub.count_and_get

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
1036: ( p_count => x_msg_count
1037: , p_data => x_msg_data
1038: );
1039:

Line 1046: oe_msg_pub.count_and_get

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
1047: ( p_count => x_msg_count
1048: , p_data => x_msg_data
1049: );
1050:

Line 1054: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
1057: l_api_name
1058: );

Line 1055: OE_MSG_PUB.Add_Exc_Msg

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,
1057: l_api_name
1058: );
1059: END IF;

Line 1063: OE_MSG_PUB.Count_And_Get

1059: END IF;
1060:
1061: -- Get message count and data
1062:
1063: OE_MSG_PUB.Count_And_Get
1064: ( p_count => x_msg_count,
1065: p_data => x_msg_data);
1066:
1067: End Delete_Row;

Line 1086: OE_MSG_PUB.initialize;

1082: BEGIN
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1085: END IF;
1086: OE_MSG_PUB.initialize;
1087: --Clearing the line cache Bug#4878846.
1088: g_line_cache_rec.delete;
1089: l_error := 1;
1090:

Line 1101: oe_msg_pub.count_and_get

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
1103: , p_data => x_msg_data);
1104:
1105: IF l_debug_level > 0 THEN

Line 1113: oe_msg_pub.count_and_get

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
1116: );
1117: IF l_debug_level > 0 THEN

Line 1125: oe_msg_pub.count_and_get

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

Line 1133: IF OE_MSG_PUB.Check_Msg_Level

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
1136: OE_MSG_PUB.Add_Exc_Msg
1137: (G_PKG_NAME,

Line 1134: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1136: OE_MSG_PUB.Add_Exc_Msg
1137: (G_PKG_NAME,
1138: l_api_name

Line 1136: OE_MSG_PUB.Add_Exc_Msg

1132:
1133: IF OE_MSG_PUB.Check_Msg_Level
1134: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1135: THEN
1136: OE_MSG_PUB.Add_Exc_Msg
1137: (G_PKG_NAME,
1138: l_api_name
1139: );
1140: END IF;

Line 1146: OE_MSG_PUB.Count_And_Get

1142: oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES unexpected errors', 1);
1143: END IF;
1144:
1145: -- Get message count and data
1146: OE_MSG_PUB.Count_And_Get
1147: ( p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:
1150: END Default_Attributes;

Line 1166: OE_MSG_PUB.initialize;

1162: l_old_blanket_line_number number;
1163: l_error NUMBER;
1164: p_default_from_header BOOLEAN := TRUE;
1165: BEGIN
1166: OE_MSG_PUB.initialize;
1167: oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);
1168:
1169: l_error := 1;
1170: l_old_blanket_line_number := p_x_line_rec.line_number;

Line 1191: oe_msg_pub.count_and_get

1187: else
1188: p_x_line_rec.line_number := l_old_blanket_line_number;
1189: end if;
1190:
1191: oe_msg_pub.count_and_get
1192: ( p_count => x_msg_count
1193: , p_data => x_msg_data);
1194:
1195: oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.DEFAULT_ATTRIBUTES', 1);

Line 1201: oe_msg_pub.count_and_get

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

Line 1210: oe_msg_pub.count_and_get

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

Line 1220: OE_MSG_PUB.Count_And_Get

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,
1222: p_data => x_msg_data);
1223:
1224: END Default_Attributes;

Line 1247: OE_MSG_PUB.initialize;

1243: l_return_status varchar2(30);
1244: BEGIN
1245:
1246:
1247: OE_MSG_PUB.initialize;
1248:
1249:
1250: oe_debug_pub.add('Entering OE_Blanket_Form_Control.Process_object', 0);
1251: --bug#4691643

Line 1378: oe_msg_pub.count_and_get

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
1380: , p_data => x_msg_data);
1381:
1382: --for bug 3217764, the exception block was removed

Line 1417: oe_msg_pub.count_and_get

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
1419: , p_data => x_msg_data);
1420:
1421: --for bug 3217764, the exception block code has been removed.

Line 1442: oe_msg_pub.count_and_get

1438: g_header_cache_rec.delete;
1439: g_line_cache_rec.delete;
1440: END IF;
1441:
1442: oe_msg_pub.count_and_get
1443: ( p_count => x_msg_count
1444: , p_data => x_msg_data);
1445:
1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);

Line 1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);

1442: oe_msg_pub.count_and_get
1443: ( p_count => x_msg_count
1444: , p_data => x_msg_data);
1445:
1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);
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

Line 1447: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_data'||x_msg_data);

1443: ( p_count => x_msg_count
1444: , p_data => x_msg_data);
1445:
1446: oe_debug_pub.add(' oe_msg_pub.count_and_get x_msg_count'||x_msg_count);
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

Line 1455: oe_msg_pub.count_and_get

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
1457: , p_data => x_msg_data
1458: );
1459: --for bug 3217764

Line 1468: oe_msg_pub.count_and_get

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
1470: , p_data => x_msg_data
1471: );
1472: --for bug 3217764

Line 1479: IF OE_MSG_PUB.Check_Msg_Level

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
1482: OE_MSG_PUB.Add_Exc_Msg
1483: (G_PKG_NAME,

Line 1480: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1482: OE_MSG_PUB.Add_Exc_Msg
1483: (G_PKG_NAME,
1484: l_api_name

Line 1482: OE_MSG_PUB.Add_Exc_Msg

1478:
1479: IF OE_MSG_PUB.Check_Msg_Level
1480: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1481: THEN
1482: OE_MSG_PUB.Add_Exc_Msg
1483: (G_PKG_NAME,
1484: l_api_name
1485: );
1486: END IF;

Line 1489: OE_MSG_PUB.Count_And_Get

1485: );
1486: END IF;
1487:
1488: -- Get message count and data
1489: OE_MSG_PUB.Count_And_Get
1490: ( p_count => x_msg_count,
1491: p_data => x_msg_data);
1492: --for bug 3217764
1493: oe_debug_pub.add('Leaving the Process Object with other errors', 5);

Line 1517: OE_MSG_PUB.initialize;

1513: l_rowtype_rec oe_ak_blanket_headers_v%rowtype;
1514: l_api_name CONSTANT VARCHAR2(30) := 'Check_Sec_Header_Attr';
1515: BEGIN
1516: oe_debug_pub.add('Entering oe_blanket_form_control.check_sec_header_attr');
1517: OE_MSG_PUB.initialize;
1518:
1519:
1520: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1521:

Line 1563: oe_msg_pub.count_and_get

1559: END IF; -- if column name is not null
1560:
1561: END IF; -- if code release level >= 11i10
1562:
1563: oe_msg_pub.count_and_get
1564: ( p_count => x_msg_count
1565: , p_data => x_msg_data);
1566:
1567: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_attr');

Line 1575: oe_msg_pub.count_and_get

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
1577: , p_data => x_msg_data
1578: );
1579:

Line 1584: oe_msg_pub.count_and_get

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

Line 1592: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1595: (G_PKG_NAME,
1596: l_api_name);

Line 1594: OE_MSG_PUB.Add_Exc_Msg

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
1595: (G_PKG_NAME,
1596: l_api_name);
1597:
1598: END IF;

Line 1602: OE_MSG_PUB.Count_And_Get

1598: END IF;
1599:
1600: -- Get message count and data
1601:
1602: OE_MSG_PUB.Count_And_Get
1603: ( p_count => x_msg_count,
1604: p_data => x_msg_data);
1605:
1606: END Check_Sec_Header_Attr;

Line 1621: OE_MSG_PUB.initialize;

1617: l_result NUMBER;
1618: l_api_name CONSTANT VARCHAR2(30) := 'Check_Sec_Line_Attr';
1619:
1620: BEGIN
1621: OE_MSG_PUB.initialize;
1622:
1623: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1624:
1625: OE_Blanket_Line_Security.Attributes(p_line_rec => p_line_rec,

Line 1635: oe_msg_pub.count_and_get

1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633: END IF;
1634:
1635: oe_msg_pub.count_and_get
1636: ( p_count => x_msg_count
1637: , p_data => x_msg_data);
1638:
1639: EXCEPTION

Line 1646: oe_msg_pub.count_and_get

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
1648: , p_data => x_msg_data
1649: );
1650:

Line 1655: oe_msg_pub.count_and_get

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

Line 1663: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1666: (G_PKG_NAME,
1667: l_api_name);

Line 1665: OE_MSG_PUB.Add_Exc_Msg

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
1666: (G_PKG_NAME,
1667: l_api_name);
1668:
1669: END IF;

Line 1673: OE_MSG_PUB.Count_And_Get

1669: END IF;
1670:
1671: -- Get message count and data
1672:
1673: OE_MSG_PUB.Count_And_Get
1674: ( p_count => x_msg_count,
1675: p_data => x_msg_data);
1676:
1677: END Check_Sec_Line_Attr;

Line 1692: OE_MSG_PUB.initialize;

1688: l_api_name CONSTANT VARCHAR2(30) := 'Check_Sec_Header_Entity';
1689:
1690: BEGIN
1691: oe_debug_pub.add('Entering oe_blanket_form_control.check_sec_header_Entity');
1692: OE_MSG_PUB.initialize;
1693:
1694: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1695:
1696: OE_Blanket_Header_Security.Entity(p_header_rec => p_header_rec,

Line 1706: oe_msg_pub.count_and_get

1702: END IF;
1703:
1704: END IF;
1705:
1706: oe_msg_pub.count_and_get
1707: ( p_count => x_msg_count
1708: , p_data => x_msg_data);
1709:
1710: oe_debug_pub.add('Exiting oe_blanket_form_control.check_sec_header_Entity');

Line 1718: oe_msg_pub.count_and_get

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
1720: , p_data => x_msg_data
1721: );
1722:

Line 1727: oe_msg_pub.count_and_get

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

Line 1735: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1738: (G_PKG_NAME,
1739: l_api_name);

Line 1737: OE_MSG_PUB.Add_Exc_Msg

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
1738: (G_PKG_NAME,
1739: l_api_name);
1740:
1741: END IF;

Line 1745: OE_MSG_PUB.Count_And_Get

1741: END IF;
1742:
1743: -- Get message count and data
1744:
1745: OE_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count,
1747: p_data => x_msg_data);
1748:
1749: END Check_Sec_Header_Entity;

Line 1763: OE_MSG_PUB.initialize;

1759: l_result NUMBER;
1760: l_api_name CONSTANT VARCHAR2(30) := 'Check_Sec_Line_Entity';
1761:
1762: BEGIN
1763: OE_MSG_PUB.initialize;
1764:
1765: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1766:
1767: OE_Blanket_Line_Security.Entity(p_line_rec => p_line_rec,

Line 1777: oe_msg_pub.count_and_get

1773: END IF;
1774:
1775: END IF;
1776:
1777: oe_msg_pub.count_and_get
1778: ( p_count => x_msg_count
1779: , p_data => x_msg_data);
1780:
1781: EXCEPTION

Line 1788: oe_msg_pub.count_and_get

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
1790: , p_data => x_msg_data
1791: );
1792:

Line 1797: oe_msg_pub.count_and_get

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

Line 1805: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1808: (G_PKG_NAME,
1809: l_api_name);

Line 1807: OE_MSG_PUB.Add_Exc_Msg

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
1808: (G_PKG_NAME,
1809: l_api_name);
1810:
1811: END IF;

Line 1815: OE_MSG_PUB.Count_And_Get

1811: END IF;
1812:
1813: -- Get message count and data
1814:
1815: OE_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count,
1817: p_data => x_msg_data);
1818:
1819: END Check_Sec_Line_Entity;

Line 1995: OE_MSG_PUB.initialize;

1991: ctr number := 1;
1992: found_flag varchar2(1) := 'N';
1993: l_x_return_status varchar2(30);
1994: BEGIN
1995: OE_MSG_PUB.initialize;
1996:
1997: while ctr <= G_header_Cache_Rec.count loop
1998:
1999: if g_header_cache_rec(ctr).header_id = p_x_header_rec.header_id then

Line 2016: OE_MSG_PUB.initialize;

2012:
2013: if found_flag = 'N' then
2014:
2015: Begin
2016: OE_MSG_PUB.initialize;
2017:
2018: OE_Blanket_Util.Query_Header
2019: (p_header_id => p_x_header_rec.header_id,
2020: x_header_rec => p_x_old_header_rec,

Line 2314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add('IN NO_DATA_FOUND OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);
2312: END IF;
2313:
2314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2315: THEN
2316: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sales_Order_Type');
2318: OE_MSG_PUB.Add;

Line 2318: OE_MSG_PUB.Add;

2314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2315: THEN
2316: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
2317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sales_Order_Type');
2318: OE_MSG_PUB.Add;
2319:
2320: END IF;
2321:
2322: RETURN NULL;

Line 2329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2325: IF l_debug_level > 0 THEN
2326: oe_debug_pub.add('IN OTEHRS OE_Blanket_Form_Control.Sales_Order_Type for order type ID: '||p_order_type_id);
2327: END IF;
2328:
2329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2330: THEN
2331: OE_MSG_PUB.Add_Exc_Msg
2332: ( G_PKG_NAME
2333: , 'Sales_Order_Type'

Line 2331: OE_MSG_PUB.Add_Exc_Msg

2327: END IF;
2328:
2329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2330: THEN
2331: OE_MSG_PUB.Add_Exc_Msg
2332: ( G_PKG_NAME
2333: , 'Sales_Order_Type'
2334: );
2335: END IF;

Line 2472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2468:
2469: WHEN OTHERS THEN
2470:
2471: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2473: THEN
2474: OE_MSG_PUB.Add_Exc_Msg
2475: ( G_PKG_NAME
2476: , 'chk_for_header_release'

Line 2474: OE_MSG_PUB.Add_Exc_Msg

2470:
2471: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2473: THEN
2474: OE_MSG_PUB.Add_Exc_Msg
2475: ( G_PKG_NAME
2476: , 'chk_for_header_release'
2477: );
2478: END IF;

Line 2525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2521:
2522: WHEN OTHERS THEN
2523:
2524: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN OTEHRS');
2525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2526: THEN
2527: OE_MSG_PUB.Add_Exc_Msg
2528: ( G_PKG_NAME
2529: , 'chk_for_header_release'

Line 2527: OE_MSG_PUB.Add_Exc_Msg

2523:
2524: oe_debug_pub.add( 'IN OE_Blanket_Form_Control.chk_for_line_release WHEN OTEHRS');
2525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2526: THEN
2527: OE_MSG_PUB.Add_Exc_Msg
2528: ( G_PKG_NAME
2529: , 'chk_for_header_release'
2530: );
2531: END IF;

Line 2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2595:
2596: WHEN OTHERS THEN
2597:
2598: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN OTEHRS');
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME
2603: , 'chk_active_revision'

Line 2601: OE_MSG_PUB.Add_Exc_Msg

2597:
2598: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_active_revision WHEN OTEHRS');
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME
2603: , 'chk_active_revision'
2604: );
2605: END IF;

Line 2622: OE_MSG_PUB.initialize;

2618: IS
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;

Line 2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2635: end if;
2636:
2637: EXCEPTION
2638: WHEN OTHERS THEN
2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641: OE_MSG_PUB.Add_Exc_Msg
2642: ( G_PKG_NAME
2643: , 'Clear_Record'

Line 2641: OE_MSG_PUB.Add_Exc_Msg

2637: EXCEPTION
2638: WHEN OTHERS THEN
2639: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2640: THEN
2641: OE_MSG_PUB.Add_Exc_Msg
2642: ( G_PKG_NAME
2643: , 'Clear_Record'
2644: );
2645: END IF;

Line 2647: OE_MSG_PUB.Count_And_Get

2643: , 'Clear_Record'
2644: );
2645: END IF;
2646: -- Get message count and data
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;

Line 2702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2698:
2699: WHEN OTHERS THEN
2700:
2701: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2703: THEN
2704: OE_MSG_PUB.Add_Exc_Msg
2705: ( G_PKG_NAME
2706: , 'get_trxt_phase_from_order_type'

Line 2704: OE_MSG_PUB.Add_Exc_Msg

2700:
2701: oe_debug_pub.add('IN OE_Blanket_Form_Control.chk_for_header_release WHEN OTEHRS');
2702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2703: THEN
2704: OE_MSG_PUB.Add_Exc_Msg
2705: ( G_PKG_NAME
2706: , 'get_trxt_phase_from_order_type'
2707: );
2708: END IF;