DBA Data[Home] [Help]

APPS.OE_OE_FORM_LOT_SERIAL dependencies on OE_GLOBALS

Line 102: l_control_rec OE_GLOBALS.Control_Rec_Type;

98: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
99: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
100: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
101: l_x_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
102: l_control_rec OE_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: --
105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
106: --

Line 110: OE_GLOBALS.G_UI_FLAG := TRUE;

106: --
107: BEGIN
108:
109: -- Set the UI flag
110: OE_GLOBALS.G_UI_FLAG := TRUE;
111:
112: -- Set control flags.
113:
114: l_control_rec.controlled_operation := TRUE;

Line 159: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;

155: l_x_lot_serial_rec.context := NULL;
156:
157: -- Set Operation to Create
158:
159: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
160:
161: -- Populate Lot_Serial table
162:
163: l_x_Lot_Serial_tbl(1) := l_x_Lot_Serial_rec;

Line 236: OE_GLOBALS.G_UI_FLAG := FALSE;

232: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
233: );
234:
235: -- Re-set the UI flag to FALSE
236: OE_GLOBALS.G_UI_FLAG := FALSE;
237:
238: -- Set return status.
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 257: OE_GLOBALS.G_UI_FLAG := FALSE;

253: EXCEPTION
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256:
257: OE_GLOBALS.G_UI_FLAG := FALSE;
258:
259: x_return_status := FND_API.G_RET_STS_ERROR;
260:
261: -- Get message count and data

Line 270: OE_GLOBALS.G_UI_FLAG := FALSE;

266: );
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269:
270: OE_GLOBALS.G_UI_FLAG := FALSE;
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273:
274: -- Get message count and data

Line 283: OE_GLOBALS.G_UI_FLAG := FALSE;

279: );
280:
281: WHEN OTHERS THEN
282:
283: OE_GLOBALS.G_UI_FLAG := FALSE;
284:
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286:
287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 390: l_control_rec OE_GLOBALS.Control_Rec_Type;

386: IS
387: l_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
388: l_Lot_Serial_val_rec OE_Order_PUB.Lot_Serial_Val_Rec_Type;
389: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
390: l_control_rec OE_GLOBALS.Control_Rec_Type;
391: l_return_status VARCHAR2(1);
392: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
393: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
394: --

Line 403: OE_GLOBALS.G_UI_FLAG := TRUE;

399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LOT_SERIAL.CHANGE_ATTRIBUTES' , 1 ) ;
401: END IF;
402: -- Set the UI flag
403: OE_GLOBALS.G_UI_FLAG := TRUE;
404:
405: -- Set control flags.
406:
407: l_control_rec.controlled_operation := TRUE;

Line 416: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LOT_SERIAL;

412:
413: l_control_rec.validate_entity := FALSE;
414: l_control_rec.write_to_DB := FALSE;
415: l_control_rec.process := FALSE;
416: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LOT_SERIAL;
417:
418: -- Instruct API to retain its caches
419:
420: l_control_rec.clear_api_cache := FALSE;

Line 514: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

510: END IF;
511:
512: -- Set Operation.
513: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN
514: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
515: ELSE
516: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
517: END IF;
518:

Line 516: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;

512: -- Set Operation.
513: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN
514: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
515: ELSE
516: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
517: END IF;
518:
519: -- Populate Lot_Serial table
520: l_x_Lot_Serial_tbl(1) := l_x_Lot_Serial_rec;

Line 599: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute1,

595: oe_debug_pub.add( 'OLD QUANTITY '||TO_CHAR ( L_OLD_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
596: END IF;
597: -- Return changed attributes.
598:
599: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute1,
600: l_old_lot_serial_rec.attribute1)
601: THEN
602: x_attribute1 := l_x_Lot_Serial_rec.attribute1;
603: END IF;

Line 605: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute10,

601: THEN
602: x_attribute1 := l_x_Lot_Serial_rec.attribute1;
603: END IF;
604:
605: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute10,
606: l_old_lot_serial_rec.attribute10)
607: THEN
608: x_attribute10 := l_x_Lot_Serial_rec.attribute10;
609: END IF;

Line 611: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute11,

607: THEN
608: x_attribute10 := l_x_Lot_Serial_rec.attribute10;
609: END IF;
610:
611: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute11,
612: l_old_lot_serial_rec.attribute11)
613: THEN
614: x_attribute11 := l_x_Lot_Serial_rec.attribute11;
615: END IF;

Line 617: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute12,

613: THEN
614: x_attribute11 := l_x_Lot_Serial_rec.attribute11;
615: END IF;
616:
617: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute12,
618: l_old_lot_serial_rec.attribute12)
619: THEN
620: x_attribute12 := l_x_Lot_Serial_rec.attribute12;
621: END IF;

Line 623: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute13,

619: THEN
620: x_attribute12 := l_x_Lot_Serial_rec.attribute12;
621: END IF;
622:
623: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute13,
624: l_old_lot_serial_rec.attribute13)
625: THEN
626: x_attribute13 := l_x_Lot_Serial_rec.attribute13;
627: END IF;

Line 629: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute14,

625: THEN
626: x_attribute13 := l_x_Lot_Serial_rec.attribute13;
627: END IF;
628:
629: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute14,
630: l_old_lot_serial_rec.attribute14)
631: THEN
632: x_attribute14 := l_x_Lot_Serial_rec.attribute14;
633: END IF;

Line 635: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute15,

631: THEN
632: x_attribute14 := l_x_Lot_Serial_rec.attribute14;
633: END IF;
634:
635: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute15,
636: l_old_lot_serial_rec.attribute15)
637: THEN
638: x_attribute15 := l_x_Lot_Serial_rec.attribute15;
639: END IF;

Line 641: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute2,

637: THEN
638: x_attribute15 := l_x_Lot_Serial_rec.attribute15;
639: END IF;
640:
641: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute2,
642: l_old_lot_serial_rec.attribute2)
643: THEN
644: x_attribute2 := l_x_Lot_Serial_rec.attribute2;
645: END IF;

Line 647: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute3,

643: THEN
644: x_attribute2 := l_x_Lot_Serial_rec.attribute2;
645: END IF;
646:
647: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute3,
648: l_old_lot_serial_rec.attribute3)
649: THEN
650: x_attribute3 := l_x_Lot_Serial_rec.attribute3;
651: END IF;

Line 653: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute4,

649: THEN
650: x_attribute3 := l_x_Lot_Serial_rec.attribute3;
651: END IF;
652:
653: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute4,
654: l_old_lot_serial_rec.attribute4)
655: THEN
656: x_attribute4 := l_x_Lot_Serial_rec.attribute4;
657: END IF;

Line 659: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute5,

655: THEN
656: x_attribute4 := l_x_Lot_Serial_rec.attribute4;
657: END IF;
658:
659: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute5,
660: l_old_lot_serial_rec.attribute5)
661: THEN
662: x_attribute5 := l_x_Lot_Serial_rec.attribute5;
663: END IF;

Line 665: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute6,

661: THEN
662: x_attribute5 := l_x_Lot_Serial_rec.attribute5;
663: END IF;
664:
665: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute6,
666: l_old_lot_serial_rec.attribute6)
667: THEN
668: x_attribute6 := l_x_Lot_Serial_rec.attribute6;
669: END IF;

Line 671: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute7,

667: THEN
668: x_attribute6 := l_x_Lot_Serial_rec.attribute6;
669: END IF;
670:
671: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute7,
672: l_old_lot_serial_rec.attribute7)
673: THEN
674: x_attribute7 := l_x_Lot_Serial_rec.attribute7;
675: END IF;

Line 677: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute8,

673: THEN
674: x_attribute7 := l_x_Lot_Serial_rec.attribute7;
675: END IF;
676:
677: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute8,
678: l_old_lot_serial_rec.attribute8)
679: THEN
680: x_attribute8 := l_x_Lot_Serial_rec.attribute8;
681: END IF;

Line 683: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute9,

679: THEN
680: x_attribute8 := l_x_Lot_Serial_rec.attribute8;
681: END IF;
682:
683: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.attribute9,
684: l_old_lot_serial_rec.attribute9)
685: THEN
686: x_attribute9 := l_x_Lot_Serial_rec.attribute9;
687: END IF;

Line 689: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.context,

685: THEN
686: x_attribute9 := l_x_Lot_Serial_rec.attribute9;
687: END IF;
688:
689: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.context,
690: l_old_lot_serial_rec.context)
691: THEN
692: x_context := l_x_Lot_Serial_rec.context;
693: END IF;

Line 695: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.from_serial_number,

691: THEN
692: x_context := l_x_Lot_Serial_rec.context;
693: END IF;
694:
695: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.from_serial_number,
696: l_old_lot_serial_rec.from_serial_number)
697: THEN
698: x_from_serial_number := l_x_Lot_Serial_rec.from_serial_number;
699: END IF;

Line 701: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.line_id,

697: THEN
698: x_from_serial_number := l_x_Lot_Serial_rec.from_serial_number;
699: END IF;
700:
701: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.line_id,
702: l_old_lot_serial_rec.line_id)
703: THEN
704: x_line_id := l_x_Lot_Serial_rec.line_id;
705: x_line := l_Lot_Serial_val_rec.line;

Line 708: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.lot_number,

704: x_line_id := l_x_Lot_Serial_rec.line_id;
705: x_line := l_Lot_Serial_val_rec.line;
706: END IF;
707:
708: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.lot_number,
709: l_old_lot_serial_rec.lot_number)
710: THEN
711: x_lot_number := l_x_Lot_Serial_rec.lot_number;
712: END IF;

Line 717: /*IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.sublot_number, --OPM 2380194 INVCONV

713:
714: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
715: THEN
716:
717: /*IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.sublot_number, --OPM 2380194 INVCONV
718: l_old_lot_serial_rec.sublot_number)
719: THEN
720: x_sublot_number := l_x_Lot_Serial_rec.sublot_number;
721: END IF; */

Line 723: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.quantity2, --OPM 2380194

719: THEN
720: x_sublot_number := l_x_Lot_Serial_rec.sublot_number;
721: END IF; */
722:
723: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.quantity2, --OPM 2380194
724: l_old_lot_serial_rec.quantity2)
725: THEN
726: IF l_debug_level > 0 THEN
727: oe_debug_pub.add('The Quantity2 Has Changed', 1);

Line 735: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.lot_serial_id,

731:
732: END IF;
733:
734:
735: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.lot_serial_id,
736: l_old_lot_serial_rec.lot_serial_id)
737: THEN
738: x_lot_serial_id := l_x_Lot_Serial_rec.lot_serial_id;
739: x_lot_serial := l_Lot_Serial_val_rec.lot_serial;

Line 742: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.quantity,

738: x_lot_serial_id := l_x_Lot_Serial_rec.lot_serial_id;
739: x_lot_serial := l_Lot_Serial_val_rec.lot_serial;
740: END IF;
741:
742: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.quantity,
743: l_old_lot_serial_rec.quantity)
744: THEN
745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( 'THE QUANTITY HAS CHANGED' , 1 ) ;

Line 751: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.to_serial_number,

747: END IF;
748: x_quantity := l_x_Lot_Serial_rec.quantity;
749: END IF;
750:
751: IF NOT OE_GLOBALS.Equal(l_x_Lot_Serial_rec.to_serial_number,
752: l_old_lot_serial_rec.to_serial_number)
753: THEN
754: x_to_serial_number := l_x_Lot_Serial_rec.to_serial_number;
755: END IF;

Line 765: OE_GLOBALS.G_UI_FLAG := FALSE;

761: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
762: );
763:
764: -- Re-set the UI flag to FALSE
765: OE_GLOBALS.G_UI_FLAG := FALSE;
766:
767: -- Set return status.
768:
769: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 786: OE_GLOBALS.G_UI_FLAG := FALSE;

782: EXCEPTION
783:
784: WHEN FND_API.G_EXC_ERROR THEN
785:
786: OE_GLOBALS.G_UI_FLAG := FALSE;
787:
788: x_return_status := FND_API.G_RET_STS_ERROR;
789:
790: -- Get message count and data

Line 799: OE_GLOBALS.G_UI_FLAG := FALSE;

795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798:
799: OE_GLOBALS.G_UI_FLAG := FALSE;
800:
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
802:
803: -- Get message count and data

Line 812: OE_GLOBALS.G_UI_FLAG := FALSE;

808: );
809:
810: WHEN OTHERS THEN
811:
812: OE_GLOBALS.G_UI_FLAG := FALSE;
813:
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815:
816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 860: l_control_rec OE_GLOBALS.Control_Rec_Type;

856: )
857: IS
858: l_x_old_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
859: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
860: l_control_rec OE_GLOBALS.Control_Rec_Type;
861: l_return_status VARCHAR2(1);
862: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
863: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
864: --

Line 873: OE_GLOBALS.G_UI_FLAG := TRUE;

869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LOT_SERIAL.VALIDATE_AND_WRITE' , 1 ) ;
871: END IF;
872: -- Set the UI flag
873: OE_GLOBALS.G_UI_FLAG := TRUE;
874:
875: -- Set control flags.
876:
877: l_control_rec.controlled_operation := TRUE;

Line 886: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LOT_SERIAL;

882: l_control_rec.clear_dependents := FALSE;
883: l_control_rec.default_attributes := FALSE;
884: l_control_rec.change_attributes := FALSE;
885: l_control_rec.process := FALSE;
886: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LOT_SERIAL;
887:
888: -- Instruct API to retain its caches
889:
890: l_control_rec.clear_api_cache := FALSE;

Line 910: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

906:
907: -- Set Operation.
908:
909: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN
910: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
911: ELSE
912: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
913: END IF;
914:

Line 912: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;

908:
909: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN
910: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
911: ELSE
912: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
913: END IF;
914:
915: -- Populate Lot_Serial table
916:

Line 979: OE_GLOBALS.G_UI_FLAG := FALSE;

975: l_x_old_Lot_Serial_rec.operation := l_x_Lot_Serial_rec.operation;
976:
977:
978: -- Re-set the UI flag to FALSE
979: OE_GLOBALS.G_UI_FLAG := FALSE;
980:
981: -- Set return status.
982:
983: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1000: OE_GLOBALS.G_UI_FLAG := FALSE;

996: EXCEPTION
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999:
1000: OE_GLOBALS.G_UI_FLAG := FALSE;
1001:
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003:
1004: -- Get message count and data

Line 1019: OE_GLOBALS.G_UI_FLAG := FALSE;

1015: END IF;
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018:
1019: OE_GLOBALS.G_UI_FLAG := FALSE;
1020:
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1022:
1023: -- Get message count and data

Line 1032: OE_GLOBALS.G_UI_FLAG := FALSE;

1028: );
1029:
1030: WHEN OTHERS THEN
1031:
1032: OE_GLOBALS.G_UI_FLAG := FALSE;
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035:
1036: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1069: l_control_rec OE_GLOBALS.Control_Rec_Type;

1065: IS
1066: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1067: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1068: l_x_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1069: l_control_rec OE_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);
1071: --
1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1073: --

Line 1077: OE_GLOBALS.G_UI_FLAG := TRUE;

1073: --
1074: BEGIN
1075:
1076: -- Set the UI flag
1077: OE_GLOBALS.G_UI_FLAG := TRUE;
1078:
1079: -- Set control flags.
1080:
1081: l_control_rec.controlled_operation := TRUE;

Line 1106: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1102: );
1103:
1104: -- Set Operation.
1105:
1106: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1107:
1108: -- Populate Lot_Serial table
1109:
1110: l_x_Lot_Serial_tbl(1) := l_x_Lot_Serial_rec;

Line 1135: OE_GLOBALS.G_UI_FLAG := FALSE;

1131:
1132: Clear_Lot_Serial;
1133:
1134: -- Re-set the UI flag to FALSE
1135: OE_GLOBALS.G_UI_FLAG := FALSE;
1136:
1137: -- Set return status.
1138:
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1153: OE_GLOBALS.G_UI_FLAG := FALSE;

1149: EXCEPTION
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152:
1153: OE_GLOBALS.G_UI_FLAG := FALSE;
1154:
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156:
1157: -- Get message count and data

Line 1166: OE_GLOBALS.G_UI_FLAG := FALSE;

1162: );
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1165:
1166: OE_GLOBALS.G_UI_FLAG := FALSE;
1167:
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1169:
1170: -- Get message count and data

Line 1179: OE_GLOBALS.G_UI_FLAG := FALSE;

1175: );
1176:
1177: WHEN OTHERS THEN
1178:
1179: OE_GLOBALS.G_UI_FLAG := FALSE;
1180:
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1182:
1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1214: l_control_rec OE_GLOBALS.Control_Rec_Type;

1210: )
1211: IS
1212: l_return_status VARCHAR2(1);
1213: /*l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1214: l_control_rec OE_GLOBALS.Control_Rec_Type;
1215: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1216: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1217: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1218: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 1240: OE_GLOBALS.G_UI_FLAG := TRUE;

1236: --
1237: BEGIN
1238:
1239: -- Set the UI flag
1240: OE_GLOBALS.G_UI_FLAG := TRUE;
1241:
1242: -- Set control flags.
1243: /*
1244: l_control_rec.controlled_operation := TRUE;

Line 1246: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LOT_SERIAL;

1242: -- Set control flags.
1243: /*
1244: l_control_rec.controlled_operation := TRUE;
1245: l_control_rec.process := TRUE;
1246: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LOT_SERIAL;
1247:
1248: l_control_rec.check_security := FALSE;
1249: l_control_rec.clear_dependents := FALSE;
1250: l_control_rec.default_attributes := FALSE;

Line 1301: OE_GLOBALS.G_UI_FLAG := FALSE;

1297: END IF;
1298:
1299:
1300: -- Re-set the UI flag to FALSE
1301: OE_GLOBALS.G_UI_FLAG := FALSE;
1302:
1303: -- Set return status.
1304:
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1319: OE_GLOBALS.G_UI_FLAG := FALSE;

1315: EXCEPTION
1316:
1317: WHEN FND_API.G_EXC_ERROR THEN
1318:
1319: OE_GLOBALS.G_UI_FLAG := FALSE;
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: -- Get message count and data

Line 1332: OE_GLOBALS.G_UI_FLAG := FALSE;

1328: );
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: OE_GLOBALS.G_UI_FLAG := FALSE;
1333:
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1335:
1336: -- Get message count and data

Line 1345: OE_GLOBALS.G_UI_FLAG := FALSE;

1341: );
1342:
1343: WHEN OTHERS THEN
1344:
1345: OE_GLOBALS.G_UI_FLAG := FALSE;
1346:
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1348:
1349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1389: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_LOCK;

1385: BEGIN
1386:
1387: -- Load Lot_Serial record
1388:
1389: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_LOCK;
1390: l_x_Lot_Serial_rec.lot_serial_id := p_lot_serial_id;
1391: l_x_Lot_Serial_rec.lock_control := p_lock_control;
1392:
1393: -- Call OE_Lot_Serial_Util.lock_row instead of OE_Order_PVT.Lock_order