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_LOT_SERIAL_UTIL dependencies on OE_LOT_SERIAL_UTIL

Line 1: PACKAGE BODY OE_Lot_Serial_Util AS

1: PACKAGE BODY OE_Lot_Serial_Util AS
2: /* $Header: OEXUSRLB.pls 120.0.12000000.2 2007/07/24 05:29:24 cpati ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lot_Serial_Util';

2: /* $Header: OEXUSRLB.pls 120.0.12000000.2 2007/07/24 05:29:24 cpati ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lot_Serial_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 36: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;

32:
33: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute1,p_old_Lot_Serial_rec.attribute1)
34: THEN
35: l_index := l_index + 1;
36: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;
37: END IF;
38:
39: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)
40: THEN

Line 42: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;

38:
39: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)
40: THEN
41: l_index := l_index + 1;
42: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
43: END IF;
44:
45: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)
46: THEN

Line 48: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;

44:
45: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)
46: THEN
47: l_index := l_index + 1;
48: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
49: END IF;
50:
51: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)
52: THEN

Line 54: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;

50:
51: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)
52: THEN
53: l_index := l_index + 1;
54: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
55: END IF;
56:
57: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)
58: THEN

Line 60: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;

56:
57: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)
58: THEN
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
61: END IF;
62:
63: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)
64: THEN

Line 66: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;

62:
63: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)
64: THEN
65: l_index := l_index + 1;
66: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
67: END IF;
68:
69: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)
70: THEN

Line 72: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;

68:
69: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)
70: THEN
71: l_index := l_index + 1;
72: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
73: END IF;
74:
75: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)
76: THEN

Line 78: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;

74:
75: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)
76: THEN
77: l_index := l_index + 1;
78: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
79: END IF;
80:
81: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)
82: THEN

Line 84: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;

80:
81: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)
82: THEN
83: l_index := l_index + 1;
84: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
85: END IF;
86:
87: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)
88: THEN

Line 90: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;

86:
87: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)
88: THEN
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
91: END IF;
92:
93: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)
94: THEN

Line 96: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;

92:
93: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)
94: THEN
95: l_index := l_index + 1;
96: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
97: END IF;
98:
99: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)
100: THEN

Line 102: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;

98:
99: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)
100: THEN
101: l_index := l_index + 1;
102: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
103: END IF;
104:
105: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)
106: THEN

Line 108: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;

104:
105: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)
106: THEN
107: l_index := l_index + 1;
108: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
109: END IF;
110:
111: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)
112: THEN

Line 114: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;

110:
111: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)
112: THEN
113: l_index := l_index + 1;
114: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
115: END IF;
116:
117: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)
118: THEN

Line 120: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;

116:
117: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)
118: THEN
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
121: END IF;
122:
123: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)
124: THEN

Line 126: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;

122:
123: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)
124: THEN
125: l_index := l_index + 1;
126: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
127: END IF;
128:
129: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)
130: THEN

Line 132: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;

128:
129: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)
130: THEN
131: l_index := l_index + 1;
132: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
133: END IF;
134:
135: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)
136: THEN

Line 138: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;

134:
135: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)
136: THEN
137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
139: END IF;
140:
141: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)
142: THEN

Line 144: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;

140:
141: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
145: END IF;
146:
147: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)
148: THEN

Line 150: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;

146:
147: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)
148: THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
151: END IF;
152:
153: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)
154: THEN

Line 156: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;

152:
153: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)
154: THEN
155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
157: END IF;
158:
159: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)
160: THEN

Line 162: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;

158:
159: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)
160: THEN
161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
163: END IF;
164:
165: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)
166: THEN

Line 168: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;

164:
165: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)
166: THEN
167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
169: END IF;
170:
171: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)
172: THEN

Line 174: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE_SET;

170:
171: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)
172: THEN
173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE_SET;
175: END IF;
176:
177: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)
178: THEN

Line 180: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;

176:
177: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)
178: THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
181: END IF;
182:
183: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' -- INVCONV
184: THEN

Line 188: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;

184: THEN
185: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.sublot_number,p_old_Lot_Serial_rec.sublot_number) -- OPM 2380194 -- INVCONV
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;
189: END IF;
190:
191: END IF; */
192:

Line 196: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;

192:
193: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_serial_id,p_old_Lot_Serial_rec.lot_serial_id)
194: THEN
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;
197: END IF;
198:
199: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)
200: THEN

Line 202: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;

198:
199: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)
200: THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
203: END IF;
204:
205: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
206: THEN

Line 210: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;

206: THEN
207: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity2,p_old_Lot_Serial_rec.quantity2) -- OPM 2380194
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;
211: END IF;
212: END IF;
213: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)
214: THEN

Line 216: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;

212: END IF;
213: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)
214: THEN
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;
217: END IF;
218:
219: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
220: l_index := l_index + 1;

Line 221: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;

217: END IF;
218:
219: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;
222: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
225: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;

220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;
222: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
225: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
228: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;

223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
225: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
228: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
231: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;

226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
228: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
231: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
234: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;

229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
231: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
234: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
237: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;

232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
234: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
237: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
240: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;

235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
237: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
240: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
243: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;

238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
240: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
243: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
246: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;

241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
243: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
246: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
249: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;

244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
246: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
249: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
252: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;

247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
249: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
252: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
255: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;

250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
252: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
255: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
258: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;

253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
255: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
258: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
261: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;

256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
258: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
261: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
264: ELSIF p_attr_id = G_CONTEXT THEN

Line 263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;

259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
261: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
264: ELSIF p_attr_id = G_CONTEXT THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
267: ELSIF p_attr_id = G_CREATED_BY THEN

Line 266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;

262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
264: ELSIF p_attr_id = G_CONTEXT THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
267: ELSIF p_attr_id = G_CREATED_BY THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
270: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;

265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
267: ELSIF p_attr_id = G_CREATED_BY THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
270: ELSIF p_attr_id = G_CREATION_DATE THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
273: ELSIF p_attr_id = G_FROM_SERIAL_NUMBER THEN

Line 272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;

268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
270: ELSIF p_attr_id = G_CREATION_DATE THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
273: ELSIF p_attr_id = G_FROM_SERIAL_NUMBER THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
276: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;

271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
273: ELSIF p_attr_id = G_FROM_SERIAL_NUMBER THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
276: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
279: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;

274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
276: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
279: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
282: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;

277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
279: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
282: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
285: ELSIF p_attr_id = G_LINE THEN

Line 284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;

280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
282: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
285: ELSIF p_attr_id = G_LINE THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
288: ELSIF p_attr_id = G_LOT_NUMBER THEN

Line 287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;

283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
285: ELSIF p_attr_id = G_LINE THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
288: ELSIF p_attr_id = G_LOT_NUMBER THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
291: ELSIF p_attr_id = G_LOT_SERIAL THEN

Line 290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;

286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
288: ELSIF p_attr_id = G_LOT_NUMBER THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
291: ELSIF p_attr_id = G_LOT_SERIAL THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;
294: /*ELSIF p_attr_id = G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV

Line 293: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;

289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
291: ELSIF p_attr_id = G_LOT_SERIAL THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;
294: /*ELSIF p_attr_id = G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
295: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
296: THEN
297: l_index := l_index + 1;

Line 298: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;

294: /*ELSIF p_attr_id = G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
295: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
296: THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;
299: END IF; */
300: ELSIF p_attr_id = G_QUANTITY THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;

Line 302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;

298: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;
299: END IF; */
300: ELSIF p_attr_id = G_QUANTITY THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
303: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
304:
305: ELSIF p_attr_id = G_QUANTITY2 THEN --OPM 2380194
306: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'

Line 303: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;

299: END IF; */
300: ELSIF p_attr_id = G_QUANTITY THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
303: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
304:
305: ELSIF p_attr_id = G_QUANTITY2 THEN --OPM 2380194
306: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
307: THEN

Line 309: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;

305: ELSIF p_attr_id = G_QUANTITY2 THEN --OPM 2380194
306: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;
310: END IF;
311: ELSIF p_attr_id = G_TO_SERIAL_NUMBER THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;

Line 313: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;

309: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;
310: END IF;
311: ELSIF p_attr_id = G_TO_SERIAL_NUMBER THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;
314: END IF;
315:
316: END Clear_Dependent_Attr;
317:

Line 848: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => p_lot_serial_rec.lot_serial_id,

844: --added query_row for notification framework
845: --before update, query lot serial record, this record will be used
846: --to update global picture
847:
848: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
849: x_lot_serial_rec =>l_lot_serial_rec);
850: oe_debug_pub.add('before update, lot_serial_id= '|| l_lot_serial_rec.lot_serial_id, 1);
851: /* jolin end*/
852:

Line 905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);

901: p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
902: x_index => l_index,
903: x_return_status => l_return_status);
904:
905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

Line 909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

Line 912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');

908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:

Line 913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- notification framework end

Line 1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);

1027: p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
1028: x_index => l_index,
1029: x_return_status => l_return_status);
1030:
1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);
1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);

1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);

Line 1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');

1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:

Line 1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);

1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: -- notification framework end

Line 1132: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1128:
1129:
1130: BEGIN
1131:
1132: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1133: IF (p_line_id <> FND_API.G_MISS_NUM)
1134: THEN
1135:
1136: OE_LINE_UTIL.Query_Row(p_line_id=>p_line_id,x_line_rec=>l_line_rec);

Line 1152: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lots.lot_serial_id,

1148: FOR l_lots IN lot_serial
1149: LOOP
1150: --query lot serial record, then call notification framework to update global picture.
1151:
1152: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lots.lot_serial_id,
1153: x_lot_serial_rec =>l_old_lot_serial_rec);
1154:
1155: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_lots.lot_serial_id , 1);
1156:

Line 1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||

1165: p_lot_serial_id => l_lots.lot_serial_id,
1166: x_index => l_index,
1167: x_return_status => l_return_status);
1168:
1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

Line 1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

Line 1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');

1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:

Line 1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:
1182: END LOOP;

Line 1201: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_set.lot_serial_id,

1197: FOR l_set IN line_set
1198: LOOP
1199: --query lot serial record, then call notification framework to update global picture.
1200:
1201: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_set.lot_serial_id,
1202: x_lot_serial_rec =>l_old_lot_serial_rec);
1203:
1204: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_set.lot_serial_id , 1);
1205:

Line 1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||

1214: p_lot_serial_id => l_set.lot_serial_id,
1215: x_index => l_index,
1216: x_return_status => l_return_status);
1217:
1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

Line 1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

Line 1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');

1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:

Line 1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: END LOOP;

Line 1563: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.LOCK_ROW', 1);

1559: l_lot_serial_id NUMBER;
1560: l_lock_control NUMBER;
1561: BEGIN
1562:
1563: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.LOCK_ROW', 1);
1564:
1565: SAVEPOINT Lock_Row;
1566:
1567: l_lock_control := NULL;

Line 1585: OE_Lot_serial_Util.Query_Row

1581: FOR UPDATE NOWAIT;
1582:
1583: oe_debug_pub.add('selected for update', 1);
1584:
1585: OE_Lot_serial_Util.Query_Row
1586: (p_lot_serial_id => l_lot_serial_id
1587: ,x_lot_serial_rec => p_x_lot_serial_rec );
1588:
1589:

Line 1634: oe_debug_pub.add('Exiting OE_Lot_serial_UTIL.LOCK_ROW', 1);

1630: END IF;
1631:
1632: END IF;
1633:
1634: oe_debug_pub.add('Exiting OE_Lot_serial_UTIL.LOCK_ROW', 1);
1635:
1636: EXCEPTION
1637:
1638: WHEN NO_DATA_FOUND THEN

Line 1696: oe_debug_pub.add('entering oe_lot_serial_util.lock_rows', 1);

1692:
1693: l_lot_serial_id NUMBER;
1694: BEGIN
1695:
1696: oe_debug_pub.add('entering oe_lot_serial_util.lock_rows', 1);
1697:
1698: IF (p_lot_serial_id IS NOT NULL AND
1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND
1700: (p_line_id IS NOT NULL AND

Line 1758: OE_Lot_serial_Util.Query_Rows

1754: END;
1755:
1756: -- locked all
1757:
1758: OE_Lot_serial_Util.Query_Rows
1759: (p_lot_serial_id => p_lot_serial_id
1760: ,p_line_id => p_line_id
1761: ,x_lot_serial_tbl => x_lot_serial_tbl
1762: );

Line 1766: oe_debug_pub.add('exiting oe_lot_serial_util.lock_rows', 1);

1762: );
1763:
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: oe_debug_pub.add('exiting oe_lot_serial_util.lock_rows', 1);
1767:
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770:

Line 1835: END OE_Lot_Serial_Util;

1831: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1832:
1833: END Get_Ids;
1834:
1835: END OE_Lot_Serial_Util;