[Home] [Help]
PACKAGE BODY: APPS.OE_LINE_ACK_UTIL
Source
1 PACKAGE BODY OE_Line_Ack_Util AS
2 /* $Header: OEXULAKB.pls 120.9.12000000.2 2007/04/03 10:46:30 smmathew ship $ */
3
4
5 -- Global constant holding the package name
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_LINE_ACK_UTIL';
8
9 -- {aksingh 3a4 Start
10 -- { Start GET_ACK_CODE
11 FUNCTION GET_ACK_CODE (p_order_source_id NUMBER := 6,
12 p_reject_order VARCHAR2 := 'N',
13 p_transaction_type VARCHAR2 := NULL,
14 p_booked_flag VARCHAR2 := NULL)
15 RETURN VARCHAR
16 IS
17 l_ack_code Varchar2(30);
18 BEGIN
19
20 If p_reject_order = 'N' Then
21 If p_order_source_id = 20 Then
22 If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
23 If nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' Then
24 Return '0';
25 Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI Then
26 oe_debug_pub.add('return Pending');
27 Return '3'; -- pending
28 Else
29 oe_debug_pub.add('return Accepted - code is 0, post-110510');
30 Return '0';
31 End If;
32 Else
33 oe_debug_pub.add('return Accepted - code is 0, pre-110510');
34 Return '0';
35 End If;
36 Else
37 Return 'IA'; --Changed AT to IA for bug 4137350
38 End If;
39 Elsif p_reject_order = 'Y' Then
40 If p_order_source_id = 20 Then
41 oe_debug_pub.add('return Rejected - code is 2');
42 Return '2';
43 Else
44 Return 'RJ';
45 End If;
46 Else
47 Return Null;
48 End If;
49 END GET_ACK_CODE;
50 -- End GET_ACK_CODE }
51 -- End aksingh 3a4 }
52
53 PROCEDURE Update_Header_Ack_Code
54 ( p_header_id IN NUMBER,
55 p_first_ack_code IN VARCHAR2,
56 p_last_ack_code IN VARCHAR2
57 )
58 IS
59 BEGIN
60 oe_debug_pub.add ('Entering Update_Header_Ack_Code with params: header id ' ||
61 p_header_id || ', first_ack_code ' || p_first_ack_code
62 || ', last_ack_code ' || p_last_ack_code || '.');
63 IF p_first_ack_code IS NOT NULL THEN
64 UPDATE oe_header_acks
65 SET first_ack_code = p_first_ack_code
66 WHERE header_id = p_header_id;
67 oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
68 ELSIF p_last_ack_code IS NOT NULL THEN
69 UPDATE oe_header_acks
70 SET last_ack_code = p_last_ack_code
71 WHERE header_id = p_header_id;
72 oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
73 ELSE
74 oe_debug_pub.add ('Bad args passed to update_header_ack_code, no header records updated');
75 END IF;
76 EXCEPTION
77 WHEN OTHERS THEN
78 oe_debug_pub.add ('When Others in Update_Header_Ack_Code');
79 END Update_Header_Ack_Code;
80
81
82 PROCEDURE Insert_Row
83 ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
84 , p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
85 , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
86 , p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
87 , p_buyer_seller_flag IN VARCHAR2
88 , p_reject_order IN VARCHAR2
89 , p_ack_type IN VARCHAR2 := NULL
90 , x_return_status OUT NOCOPY VARCHAR2
91 )
92 IS
93 l_line_rec OE_Order_Pub.Line_Rec_Type;
94 l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
95
96 l_count NUMBER;
97 I BINARY_INTEGER;
98 l_error_flag Varchar2(1);
99 BEGIN
100
101 l_count := p_line_tbl.COUNT;
102 l_count := p_line_val_tbl.COUNT;
103 I := p_line_tbl.FIRST;
104 WHILE I IS NOT NULL LOOP
105 --FOR I IN 1..p_line_tbl.COUNT LOOP
106
107 IF p_reject_order = 'N' THEN
108 l_line_rec := p_line_tbl(I);
109 OE_Line_Util.Convert_Miss_To_Null (l_line_rec);
110 -- {Start of 3A4 change for the reject = 'N'
111 If l_line_rec.order_source_id = 20 Then
112 If l_line_rec.First_Ack_Code IS NULL Then
113 If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then
114 l_line_rec.FIRST_ACK_CODE :=
115 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
116 p_reject_order => p_reject_order);
117 Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then
118 l_line_rec.FIRST_ACK_CODE :=
119 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
120 p_reject_order => p_reject_order);
121 -- 3A6 related
122 Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO then
123 If l_line_rec.last_ack_code IS NULL Then
124 l_line_rec.FIRST_ACK_CODE := 'OPEN';
125 Else
126 l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;
127 End if;
128 Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO then
129 If l_line_rec.last_ack_code IS NULL Then
130 l_line_rec.FIRST_ACK_CODE := 'OPEN';
131 Else
132 l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;
133 End if;
134 -- 3A4 related
135 Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then
136 l_line_rec.FIRST_ACK_CODE :=
137 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
138 p_reject_order => p_reject_order,
139 p_booked_flag => l_line_rec.booked_flag,
140 p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI);
141 Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then
142 l_line_rec.FIRST_ACK_CODE :=
143 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
144 p_reject_order => p_reject_order);
145
146 End if;
147 l_line_rec.FIRST_ACK_DATE := '';
148 l_line_rec.LAST_ACK_CODE := '';
149 l_line_rec.LAST_ACK_DATE := '';
150 Else
151 l_line_rec.LAST_ACK_CODE :=
152 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
153 p_reject_order => p_reject_order);
154 l_line_rec.LAST_ACK_DATE := '';
155 End If;
156 Else
157 l_line_val_rec := p_line_val_tbl(I);
158
159 -- Following Check will determine if this is a 855 or 865
160 oe_debug_pub.add('l_line_rec.SCHEDULE_SHIP_DATE :' || l_line_rec.SCHEDULE_SHIP_DATE,1);
161 oe_debug_pub.add('l_line_rec.REQUEST_DATE :' || l_line_rec.REQUEST_DATE, 1);
162
163 IF (nvl(l_line_rec.FIRST_ACK_CODE, ' ')= ' ' OR
164 l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR) THEN -- It is 855
165 oe_debug_pub.add('trans is 855 with first_ack_code ' ||nvl(l_line_rec.FIRST_ACK_CODE, 'NULL' ));
166 IF l_line_rec.SCHEDULE_SHIP_DATE is NULL THEN
167 oe_debug_pub.add('ack code: schedule ship date is null');
168 l_line_rec.FIRST_ACK_CODE := 'SP';
169 END IF;
170 IF l_line_rec.SCHEDULE_SHIP_DATE is NOT NULL
171 AND trunc(l_line_rec.SCHEDULE_SHIP_DATE) <> nvl(trunc(l_line_rec.REQUEST_DATE), FND_API.G_MISS_DATE)
172 THEN
173 oe_debug_pub.add('ack code: date rescheduled');
174 l_line_rec.FIRST_ACK_CODE := 'DR';
175 END IF;
176
177 --Added for bug 4771523+bug 4454400 start
178 If nvl(l_line_rec.unit_selling_price, FND_API.G_MISS_NUM) <> nvl(p_old_line_tbl(I).unit_selling_price, FND_API.G_MISS_NUM)
179 THEN
180 l_line_rec.FIRST_ACK_CODE := 'IP';
181 oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);
182 oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
183 oe_debug_pub.add('ack code: price changed');
184 END IF;
185 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
186 AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
187
188 oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
189 oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
190
191 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
192 l_line_rec.FIRST_ACK_CODE := 'IP';
193 oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
194 END IF;
195 oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);
196 oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
197 END IF;
198 --Added for bug 4771523+bug 4454400 end
199
200
201 IF l_line_rec.ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY
202 THEN
203 IF l_line_rec.FIRST_ACK_CODE IS NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
204 l_line_rec.FIRST_ACK_CODE := 'IQ';
205 ELSE
206 l_line_rec.FIRST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
207 END IF;
208 END IF;
209 -- Add Below Code for Price Change - IP - once New fields are added
210
211 -- ack code changes introduced to support item relationships
212 -- we change the ack code for automatic/manual substitution
213 -- as well as upsell or superseded items or promotional upgrades
214 -- For the remaining relationships, only the header ack code
215 -- is changed since the IS (meaning substitution) ack code is not appropriate
216 -- as new lines were added rather than substituting item on the orig line
217
218 IF l_line_rec.ORIGINAL_INVENTORY_ITEM_ID is NOT NULL THEN
219 IF (l_line_rec.ITEM_RELATIONSHIP_TYPE is NULL
220 OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 2
221 OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 4
222 OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 8
223 OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 14) THEN
224 IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
225 l_line_rec.FIRST_ACK_CODE := 'IS';
226 ELSE l_line_rec.FIRST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
227 END IF;
228 ELSE
229 IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
230 l_line_rec.FIRST_ACK_CODE := 'IA';
231 END IF;
232 END IF;
233 END IF;
234
235 IF l_line_rec.SPLIT_FROM_LINE_ID is not NULL AND
236 l_line_rec.split_by = 'SYSTEM' THEN
237 l_line_rec.FIRST_ACK_CODE := 'IB';
238 END IF;
239
240 /* added the following if condition to fix the bug 2878987 */
241 IF l_line_rec.OPEN_FLAG = 'N' THEN
242 l_line_rec.FIRST_ACK_CODE := 'ID';
243 END IF;
244
245
246 -- If Everything Accepted as it is
247 IF l_line_rec.FIRST_ACK_CODE is NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR THEN
248 l_line_rec.FIRST_ACK_CODE := 'IA';
249 ELSIF l_line_rec.FIRST_ACK_CODE is NOT NULL THEN
250 -- the ack code was modified, we should update the header ack code
251 Update_Header_Ack_Code (l_line_rec.header_id, 'AC', NULL);
252
253 END IF;
254
255 l_line_rec.FIRST_ACK_DATE := '';
256 l_line_rec.LAST_ACK_CODE := '';
257 l_line_rec.LAST_ACK_DATE := '';
258
259 ELSE -- it is 865
260
261 IF l_line_rec.changed_lines_pocao = 'N' THEN
262 GOTO nextline;
263 END IF;
264
265 l_line_rec.FIRST_ACK_DATE := p_old_line_tbl(I).FIRST_ACK_DATE;
266
267 IF l_line_rec.SCHEDULE_SHIP_DATE is NULL THEN
268 l_line_rec.LAST_ACK_CODE := 'SP';
269 END IF;
270 IF l_line_rec.SCHEDULE_SHIP_DATE is NOT NULL
271 AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(p_old_line_tbl(I).SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE)
272 AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(l_line_rec.REQUEST_DATE, FND_API.G_MISS_DATE)
273 THEN
274 l_line_rec.LAST_ACK_CODE := 'DR';
275 END IF;
276 -- Added for bug 4771523 + bug 4454400 start
277 If nvl(l_line_rec.unit_selling_price, FND_API.G_MISS_NUM) <> nvl(p_old_line_tbl(I).unit_selling_price, FND_API.G_MISS_NUM)
278 THEN
279 l_line_rec.LAST_ACK_CODE := 'IP';
280 oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);
281 oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
282 oe_debug_pub.add('ack code: price changed');
283 END IF;
284
285 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
286 AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
287
288 oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
289 oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
290
291 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
292 l_line_rec.LAST_ACK_CODE := 'IP';
293 oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
294 END IF;
295 oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);
296 oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
297 END IF;
298 -- Added for bug 4771523 + bug 4454400 end
299
300 IF l_line_rec.ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY
301 THEN
302 IF l_line_rec.LAST_ACK_CODE IS NULL or l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR Then
303 l_line_rec.LAST_ACK_CODE := 'IQ';
304 ELSE
305 l_line_rec.LAST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
306 END IF;
307 END IF;
308 -- Add Below Code for Price Change - IP - once New fields are added
309
310
311 IF l_line_rec.SPLIT_FROM_LINE_ID is not NULL AND
312 l_line_rec.split_by = 'SYSTEM' THEN
313 l_line_rec.LAST_ACK_CODE := 'IB';
314 END IF;
315
316 /* added the following if condition to fix the bug 2878987 */
317 IF l_line_rec.OPEN_FLAG = 'N' THEN
318 l_line_rec.LAST_ACK_CODE := 'ID';
319 END IF;
320
321 -- If Everything Accepted as it is
322 IF l_line_rec.LAST_ACK_CODE is NULL OR l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR THEN
323 l_line_rec.LAST_ACK_CODE := 'IA';
324 END IF;
325 -- in the case of 865, the header last ack code defaults to AC, so we don't need to change it here
326 -- (unlike 855)
327
328 l_line_rec.LAST_ACK_DATE := '';
329
330 END IF;
331 END IF;
332 -- End of 3A4 for reject = 'N' }
333 ELSE -- p_reject_order = 'Y'
334
335 l_line_rec := p_old_line_tbl(I);
336 l_error_flag := 'Y';
337 OE_Line_Util.Convert_Miss_To_Null (l_line_rec);
338 -- {Start of 3A4 change for the reject = 'Y'
339 If l_line_rec.order_source_id = 20 Then
340 If l_line_rec.First_Ack_Code IS NULL Then
341 l_line_rec.FIRST_ACK_CODE :=
342 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
343 p_reject_order => p_reject_order);
344 l_line_rec.FIRST_ACK_DATE := '';
345 l_line_rec.LAST_ACK_CODE := '';
346 l_line_rec.LAST_ACK_DATE := '';
347 Else
348 l_line_rec.LAST_ACK_CODE :=
349 Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
350 p_reject_order => p_reject_order);
351 l_line_rec.LAST_ACK_DATE := '';
352 End If;
353
354 Else
355 IF nvl(l_line_rec.FIRST_ACK_CODE,' ')=' ' THEN -- It is 855
356 l_line_rec.FIRST_ACK_CODE := 'IR';
357 oe_debug_pub.add('855 nulling first_ack_date');
358 l_line_rec.FIRST_ACK_DATE := '';
359 l_line_rec.LAST_ACK_CODE := '';
360 l_line_rec.LAST_ACK_DATE := '';
361 ELSE
362 l_line_rec.LAST_ACK_CODE := 'IR';
363 l_line_rec.LAST_ACK_DATE := '';
364 END IF;
365
366 END IF;
367 -- End of 3A4 for reject = 'Y' }
368
369 --Value record is not required as record is rejected
370 --The above statement is not valid as the rejected record can
371 --have the value (when customer send the value data).
372 --so, we need to check if the record exists then populate for
373 --acknowledgment
374
375 if p_old_line_val_tbl.EXISTS(I) then
376 -- uncommented following line, because of the mentioned reason above
377 -- bug3429670
378 l_line_val_rec := p_old_line_val_tbl(I);
379 end if;
380 END IF;
381
382 BEGIN
383
384 if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
385 Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
386 then
387
388 SELECT count(*) INTO l_count
389 FROM OE_LINE_ACKS
390 WHERE header_id = l_line_rec.header_id
391 AND line_id = l_line_rec.line_id
392 AND acknowledgment_flag Is Null
393 -- Change this condition once ack type is ins for POAO/POCAO
394 AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
395 AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
396 = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
397 AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
398 = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
399 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
400 = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)
401 AND request_id = l_line_rec.request_id;
402
403
404 else
405 SELECT count(*) INTO l_count
406 FROM OE_LINE_ACKS
407 WHERE header_id = l_line_rec.header_id
408 AND line_id = l_line_rec.line_id
409 AND acknowledgment_flag Is Null
410 -- Change this condition once ack type is ins for POAO/POCAO
411 AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
412 AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
413 = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
414 AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
415 = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
416 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
417 = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
418 end if;
419 IF l_count > 0 THEN
420 oe_debug_pub.add('l_count > 0, Calling Delete_Row');
421 OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,
422 p_ack_type => p_ack_type,
423 p_sold_to_org_id => l_line_rec.sold_to_org_id,
424 p_sold_to_org => l_line_val_rec.sold_to_org,
425 p_change_sequence => l_line_rec.change_sequence,
426 p_request_id => l_line_rec.request_id,
427 p_header_id => l_line_rec.header_id);
428
429 ELSE
430 oe_debug_pub.add('l_count <= 0 for line_id, attempting delete by doc ref, line ref and ship ref');
431 OE_Line_Ack_Util.Delete_Row (p_line_id => NULL,
432 p_ack_type => p_ack_type,
433 p_orig_sys_document_ref => l_line_rec.orig_sys_document_ref,
434 p_orig_sys_line_ref => l_line_rec.orig_sys_line_ref,
435 p_orig_sys_shipment_ref => l_line_rec.orig_sys_shipment_ref,
436 p_sold_to_org_id => l_line_rec.sold_to_org_id,
437 p_sold_to_org => l_line_val_rec.sold_to_org,
438 p_change_sequence => l_line_rec.change_sequence,
439 p_request_id => l_line_rec.request_id,
440 p_header_id => NULL
441 );
442 END IF;
443
444
445 EXCEPTION WHEN OTHERS THEN NULL;
446 END;
447
448
449
450 IF l_line_rec.order_source_id <> FND_API.G_MISS_NUM
451 -- Changed the following condition to compare -1 instead of 0
452 -- as 0 is valid order_source_id
453 AND nvl(l_line_rec.order_source_id,-1) <> -1
454 AND l_line_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
455 AND nvl(l_line_rec.orig_sys_document_ref,' ') <> ' '
456 AND l_line_rec.orig_sys_line_ref <> FND_API.G_MISS_CHAR
457 AND nvl(l_line_rec.orig_sys_line_ref,' ') <> ' '
458 -- Commenting the next 2 lines for the bug 2922709 fix
459 -- As for the rejected lines line_id can be null
460 -- OR (l_line_rec.line_id <> FND_API.G_MISS_NUM
461 -- AND nvl(l_line_rec.line_id,0) <> 0)
462
463 THEN
464
465 oe_debug_pub.add('inserting line ack record for'||
466 ' source id: ' ||to_char(l_line_rec.order_source_id)||
467 ', order ref: ' ||l_line_rec.orig_sys_document_ref||
468 ', line ref: ' ||l_line_rec.orig_sys_line_ref||
469 ', line id: ' ||to_char(l_line_rec.line_id)||
470 ', line no: ' ||to_char(l_line_rec.line_number)||
471 ', shipment no: '||to_char(l_line_rec.shipment_number)||
472 ', option no: ' ||to_char(l_line_rec.option_number));
473
474 oe_debug_pub.add('item id = '||l_line_rec.inventory_item_id);
475 oe_debug_pub.add('item nm = '||l_line_val_rec.inventory_item);
476 oe_debug_pub.add('first_ack_date = '||l_line_rec.first_ack_date);
477
478 IF l_line_rec.split_from_line_id IS NOT NULL
479 AND l_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
480 THEN
481 --bsadri get the split reference
482 oe_debug_pub.add('bsadri get the reference for split id :' ||
483 l_line_rec.split_from_line_id);
484 BEGIN
485 SELECT orig_sys_line_ref, orig_sys_shipment_ref
486 INTO l_line_rec.split_from_line_ref, l_line_rec.split_from_shipment_ref
487 FROM OE_ORDER_LINES
488 WHERE line_id = l_line_rec.split_from_line_id;
489 EXCEPTION
490 WHEN OTHERS THEN
491 oe_debug_pub.add('bsadri failed to get the refernce for split line');
492 END;
493 END IF;
494 --added end customer fields for bug 4034441
495 INSERT INTO OE_LINE_ACKS
496 (
497 ACCOUNTING_RULE
498 ,ACCOUNTING_RULE_ID
499 ,ACCOUNTING_RULE_DURATION
500 ,ACKNOWLEDGMENT_FLAG
501 ,ACTUAL_ARRIVAL_DATE
502 ,ACTUAL_SHIPMENT_DATE
503 ,AGREEMENT
504 ,AGREEMENT_ID
505 ,ARRIVAL_SET_ID
506 -- ,ARRIVAL_SET_NAME
507 ,ATO_LINE_ID
508 ,ATTRIBUTE1
509 ,ATTRIBUTE10
510 ,ATTRIBUTE11
511 ,ATTRIBUTE12
512 ,ATTRIBUTE13
513 ,ATTRIBUTE14
514 ,ATTRIBUTE15
515 ,ATTRIBUTE16 --For bug 2184255
516 ,ATTRIBUTE17
517 ,ATTRIBUTE18
518 ,ATTRIBUTE19
519 ,ATTRIBUTE2
520 ,ATTRIBUTE20
521 ,ATTRIBUTE3
522 ,ATTRIBUTE4
523 ,ATTRIBUTE5
524 ,ATTRIBUTE6
525 ,ATTRIBUTE7
526 ,ATTRIBUTE8
527 ,ATTRIBUTE9
528 ,AUTHORIZED_TO_SHIP_FLAG
529 ,BUYER_SELLER_FLAG
530 ,BOOKED_FLAG
531 -- ,CALCULATE_PRICE_FLAG
532 ,CANCELLED_FLAG
533 ,CANCELLED_QUANTITY
534 ,CHANGE_DATE
535 ,CHANGE_SEQUENCE
536 -- ,CLOSED_FLAG
537 ,COMPONENT_CODE
538 ,COMPONENT_NUMBER
539 ,COMPONENT_SEQUENCE_ID
540 ,CONFIG_DISPLAY_SEQUENCE
541 -- ,CONFIG_LINE_REF
542 ,CONFIGURATION_ID
543 ,TOP_MODEL_LINE_ID
544 ,CONTEXT
545 ,CREATED_BY
546 ,CREATION_DATE
547 ,CUST_MODEL_SERIAL_NUMBER
548 ,CUST_PO_NUMBER
549 ,CUST_PRODUCTION_SEQ_NUM
550 ,CUSTOMER_DOCK_CODE
551 ,CUSTOMER_ITEM
552 ,CUSTOMER_ITEM_ID -- 11/03
553 -- ,CUSTOMER_ITEM_REVISION 11/03
554 , CUSTOMER_JOB
555 ,CUSTOMER_PRODUCTION_LINE
556 ,CUSTOMER_TRX_LINE_ID
557 -- ,DELIVER_TO_CONTACT
558 ,DELIVER_TO_CONTACT_ID
559 ,DELIVER_TO_ORG
560 ,DELIVER_TO_ORG_ID
561 ,DELIVERY_LEAD_TIME
562 ,DEMAND_BUCKET_TYPE
563 ,DEMAND_BUCKET_TYPE_CODE
564 -- ,DEMAND_CLASS
565 ,DEMAND_CLASS_CODE
566 -- ,DEMAND_STREAM
567 ,DEP_PLAN_REQUIRED_FLAG
568 -- ,DPW_ASSIGNED_FLAG
569 ,EARLIEST_ACCEPTABLE_DATE
570 ,EXPLOSION_DATE
571 ,FIRST_ACK_CODE
572 ,FIRST_ACK_DATE
573 ,FOB_POINT
574 ,FOB_POINT_CODE
575 ,FREIGHT_CARRIER_CODE
576 ,FREIGHT_TERMS
577 ,FREIGHT_TERMS_CODE
578 ,FULFILLED_QUANTITY
579 -- ,FULFILLMENT_SET_ID
580 -- ,FULFILLMENT_SET_NAME
581 ,GLOBAL_ATTRIBUTE_CATEGORY
582 ,GLOBAL_ATTRIBUTE1
583 ,GLOBAL_ATTRIBUTE10
584 ,GLOBAL_ATTRIBUTE11
585 ,GLOBAL_ATTRIBUTE12
586 ,GLOBAL_ATTRIBUTE13
587 ,GLOBAL_ATTRIBUTE14
588 ,GLOBAL_ATTRIBUTE15
589 ,GLOBAL_ATTRIBUTE16
590 ,GLOBAL_ATTRIBUTE17
591 ,GLOBAL_ATTRIBUTE18
592 ,GLOBAL_ATTRIBUTE19
593 ,GLOBAL_ATTRIBUTE2
594 ,GLOBAL_ATTRIBUTE20
595 ,GLOBAL_ATTRIBUTE3
596 ,GLOBAL_ATTRIBUTE4
597 ,GLOBAL_ATTRIBUTE5
598 ,GLOBAL_ATTRIBUTE6
599 ,GLOBAL_ATTRIBUTE7
600 ,GLOBAL_ATTRIBUTE8
601 ,GLOBAL_ATTRIBUTE9
602 ,HEADER_ID
603 ,INDUSTRY_ATTRIBUTE1
604 ,INDUSTRY_ATTRIBUTE10
605 ,INDUSTRY_ATTRIBUTE11
606 ,INDUSTRY_ATTRIBUTE12
607 ,INDUSTRY_ATTRIBUTE13
608 ,INDUSTRY_ATTRIBUTE14
609 ,INDUSTRY_ATTRIBUTE15
610 ,INDUSTRY_ATTRIBUTE16
611 ,INDUSTRY_ATTRIBUTE17
612 ,INDUSTRY_ATTRIBUTE18
613 ,INDUSTRY_ATTRIBUTE19
614 ,INDUSTRY_ATTRIBUTE2
615 ,INDUSTRY_ATTRIBUTE20
616 ,INDUSTRY_ATTRIBUTE21
617 ,INDUSTRY_ATTRIBUTE22
618 ,INDUSTRY_ATTRIBUTE23
619 ,INDUSTRY_ATTRIBUTE24
620 ,INDUSTRY_ATTRIBUTE25
621 ,INDUSTRY_ATTRIBUTE26
622 ,INDUSTRY_ATTRIBUTE27
623 ,INDUSTRY_ATTRIBUTE28
624 ,INDUSTRY_ATTRIBUTE29
625 ,INDUSTRY_ATTRIBUTE3
626 ,INDUSTRY_ATTRIBUTE30
627 ,INDUSTRY_ATTRIBUTE4
628 ,INDUSTRY_ATTRIBUTE5
629 ,INDUSTRY_ATTRIBUTE6
630 ,INDUSTRY_ATTRIBUTE7
631 ,INDUSTRY_ATTRIBUTE8
632 ,INDUSTRY_ATTRIBUTE9
633 ,INDUSTRY_CONTEXT
634 ,TP_CONTEXT
635 ,TP_ATTRIBUTE1
636 ,TP_ATTRIBUTE2
637 ,TP_ATTRIBUTE3
638 ,TP_ATTRIBUTE4
639 ,TP_ATTRIBUTE5
640 ,TP_ATTRIBUTE6
641 ,TP_ATTRIBUTE7
642 ,TP_ATTRIBUTE8
643 ,TP_ATTRIBUTE9
644 ,TP_ATTRIBUTE10
645 ,TP_ATTRIBUTE11
646 ,TP_ATTRIBUTE12
647 ,TP_ATTRIBUTE13
648 ,TP_ATTRIBUTE14
649 ,TP_ATTRIBUTE15
650 ,INTMED_SHIP_TO_CONTACT_ID
651 ,INTMED_SHIP_TO_ORG_ID
652 ,INVENTORY_ITEM
653 ,INVENTORY_ITEM_ID
654 -- ,INVOICE_COMPLETE_FLAG 11/03
655 -- ,INVOICE_SET_ID
656 -- ,INVOICE_SET_NAME
657 -- ,INVOICE_NUMBER
658 ,INVOICE_TO_CONTACT
659 ,INVOICE_TO_CONTACT_ID
660 ,INVOICE_TO_ORG
661 ,INVOICE_TO_ORG_ID
662 -- ,INVOICE_TOLERANCE_ABOVE
663 -- ,INVOICE_TOLERANCE_BELOW
664 ,INVOICING_RULE
665 ,INVOICING_RULE_ID
666 ,ITEM_INPUT
667 ,ITEM_REVISION
668 ,ITEM_TYPE_CODE
669 ,LAST_ACK_CODE
670 ,LAST_ACK_DATE
671 ,LAST_UPDATE_DATE
672 ,LAST_UPDATE_LOGIN
673 ,LAST_UPDATED_BY
674 ,LATEST_ACCEPTABLE_DATE
675 ,LINE_CATEGORY_CODE
676 ,LINE_ID
677 ,LINE_NUMBER
678 -- ,LINE_PO_CONTEXT
679 ,LINE_TYPE
680 ,LINE_TYPE_ID
681 ,LINK_TO_LINE_ID
682 -- ,LINK_TO_LINE_REF
683 -- ,LOT
684 ,MODEL_GROUP_NUMBER
685 ,OPEN_FLAG
686 ,OPERATION_CODE
687 ,OPTION_FLAG
688 ,OPTION_NUMBER
689 ,ORDER_QUANTITY_UOM
690 ,ORDER_SOURCE_ID
691 ,ORDERED_QUANTITY
692 ,ORG_ID
693 ,ORIG_SYS_DOCUMENT_REF
694 ,ORIG_SYS_LINE_REF
695 ,ORIG_SYS_SHIPMENT_REF
696 ,OVER_SHIP_REASON_CODE
697 ,OVER_SHIP_RESOLVED_FLAG
698 ,PAYMENT_TERM
699 ,PAYMENT_TERM_ID
700 ,PRICE_LIST
701 ,PRICE_LIST_ID
702 ,PRICING_ATTRIBUTE1
703 ,PRICING_ATTRIBUTE10
704 ,PRICING_ATTRIBUTE2
705 ,PRICING_ATTRIBUTE3
706 ,PRICING_ATTRIBUTE4
707 ,PRICING_ATTRIBUTE5
708 ,PRICING_ATTRIBUTE6
709 ,PRICING_ATTRIBUTE7
710 ,PRICING_ATTRIBUTE8
711 ,PRICING_ATTRIBUTE9
712 ,PRICING_CONTEXT
713 ,PRICING_DATE
714 ,PRICING_QUANTITY
715 ,PRICING_QUANTITY_UOM
716 -- ,PROGRAM
717 -- ,PROGRAM_APPLICATION
718 ,PROGRAM_APPLICATION_ID
719 ,PROGRAM_ID
720 ,PROGRAM_UPDATE_DATE
721 ,PROJECT
722 ,PROJECT_ID
723 ,PROMISE_DATE
724 -- ,REFERENCE_HEADER
725 ,REFERENCE_HEADER_ID
726 -- ,REFERENCE_LINE
727 ,REFERENCE_LINE_ID
728 ,REFERENCE_TYPE
729 -- ,RELATED_PO_NUMBER
730 ,REQUEST_DATE
731 ,REQUEST_ID
732 ,RESERVED_QUANTITY
733 ,RETURN_ATTRIBUTE1
734 ,RETURN_ATTRIBUTE10
735 ,RETURN_ATTRIBUTE11
736 ,RETURN_ATTRIBUTE12
737 ,RETURN_ATTRIBUTE13
738 ,RETURN_ATTRIBUTE14
739 ,RETURN_ATTRIBUTE15
740 ,RETURN_ATTRIBUTE2
741 ,RETURN_ATTRIBUTE3
742 ,RETURN_ATTRIBUTE4
743 ,RETURN_ATTRIBUTE5
744 ,RETURN_ATTRIBUTE6
745 ,RETURN_ATTRIBUTE7
746 ,RETURN_ATTRIBUTE8
747 ,RETURN_ATTRIBUTE9
748 ,RETURN_CONTEXT
749 ,RETURN_REASON_CODE
750 ,RLA_SCHEDULE_TYPE_CODE
751 ,SALESREP_ID
752 ,SALESREP
753 ,SCHEDULE_ARRIVAL_DATE
754 ,SCHEDULE_SHIP_DATE
755 -- ,SCHEDULE_ITEM_DETAIL
756 ,SCHEDULE_STATUS_CODE
757 ,SHIP_FROM_ORG
758 ,SHIP_FROM_ORG_ID
759 ,SHIP_MODEL_COMPLETE_FLAG
760 ,SHIP_SET_ID
761 -- ,SHIP_SET_NAME
762 ,SHIP_TO_ADDRESS1
763 ,SHIP_TO_ADDRESS2
764 ,SHIP_TO_ADDRESS3
765 ,SHIP_TO_ADDRESS4
766 ,SHIP_TO_CITY
767 ,SHIP_TO_CONTACT
768 -- ,SHIP_TO_CONTACT_AREA_CODE1
769 -- ,SHIP_TO_CONTACT_AREA_CODE2
770 -- ,SHIP_TO_CONTACT_AREA_CODE3
771 ,SHIP_TO_CONTACT_FIRST_NAME
772 ,SHIP_TO_CONTACT_ID
773 -- ,SHIP_TO_CONTACT_JOB_TITLE
774 ,SHIP_TO_CONTACT_LAST_NAME
775 ,SHIP_TO_COUNTRY
776 ,SHIP_TO_COUNTY
777 ,SHIP_TO_ORG
778 ,SHIP_TO_ORG_ID
779 ,SHIP_TO_POSTAL_CODE
780 ,SHIP_TO_STATE
781 ,SHIP_TOLERANCE_ABOVE
782 ,SHIP_TOLERANCE_BELOW
783 ,SHIPMENT_NUMBER
784 ,SHIPMENT_PRIORITY
785 ,SHIPMENT_PRIORITY_CODE
786 ,SHIPPED_QUANTITY
787 -- ,SHIPPING_METHOD
788 ,SHIPPING_METHOD_CODE
789 ,SHIPPING_QUANTITY
790 ,SHIPPING_QUANTITY_UOM
791 -- ,SOLD_FROM_ORG
792 -- ,SOLD_FROM_ORG_ID
793 ,SOLD_TO_ORG
794 ,SOLD_TO_ORG_ID
795 ,SORT_ORDER
796 ,SOURCE_DOCUMENT_ID
797 ,SOURCE_DOCUMENT_LINE_ID
798 ,SOURCE_DOCUMENT_TYPE_ID
799 ,SOURCE_TYPE_CODE
800 ,SPLIT_FROM_LINE_ID
801 -- ,SUBINVENTORY
802 -- ,SUBMISSION_DATETIME
803 ,TASK
804 ,TASK_ID
805 -- ,TAX
806 ,TAX_CODE
807 ,TAX_DATE
808 ,TAX_EXEMPT_FLAG
809 ,TAX_EXEMPT_NUMBER
810 ,TAX_EXEMPT_REASON
811 ,TAX_EXEMPT_REASON_CODE
812 ,TAX_POINT
813 ,TAX_POINT_CODE
814 ,TAX_RATE
815 ,TAX_VALUE
816 ,UNIT_LIST_PRICE
817 ,UNIT_SELLING_PRICE
818 ,VEH_CUS_ITEM_CUM_KEY_ID
819 ,VISIBLE_DEMAND_FLAG
820 ,split_from_line_ref
821 ,split_from_shipment_ref
822 ,SHIP_TO_EDI_LOCATION_CODE
823 ,Service_Txn_Reason_Code
824 ,Service_Txn_Comments
825 ,Service_Duration
826 ,Service_Start_Date
827 ,Service_End_Date
828 ,Service_Coterminate_Flag
829 ,Service_Number
830 ,Service_Period
831 ,Service_Reference_Type_Code
832 ,Service_Reference_Line_Id
833 ,Service_Reference_System_Id
834 ,Credit_Invoice_Line_Id
835 ,Ship_to_Province
836 ,Invoice_Province
837 ,Bill_to_Edi_Location_Code
838 ,Invoice_City
839 ,ship_from_edi_location_code
840 ,SHIP_FROM_ADDRESS_1
841 ,SHIP_FROM_ADDRESS_2
842 ,SHIP_FROM_ADDRESS_3
843 ,SHIP_FROM_CITY
844 ,SHIP_FROM_POSTAL_CODE
845 ,SHIP_FROM_COUNTRY
846 ,SHIP_FROM_REGION1
847 ,SHIP_FROM_REGION2
848 ,SHIP_FROM_REGION3
849 ,SHIP_FROM_ADDRESS_ID
850 ,SHIP_TO_ADDRESS_ID
851 ,SHIP_TO_ADDRESS_CODE
852 ,service_reference_line
853 ,service_reference_order
854 ,service_reference_system
855 -- ,order_source
856 ,customer_line_number
857 ,CUSTOMER_ITEM_NET_PRICE --bug#5733732
858 ,user_item_description
859 ,acknowledgment_type
860 ,blanket_number
861 ,blanket_line_number
862 ,original_inventory_item_id
863 ,original_ordered_item_id
864 ,original_ordered_item
865 ,original_item_identifier_type
866 ,item_relationship_type
867 ,error_flag
868 ,customer_shipment_number
869 -- { Distributer Order related change
870 ,end_customer_id
871 ,end_customer_contact_id
872 ,end_customer_site_use_id
873 ,ib_owner
874 ,ib_current_location
875 ,ib_installed_at_location
876 -- Distributer Order related change }
877 ,charge_periodicity_code
878 ,end_customer_name
879 ,end_customer_number
880 ,end_customer_contact
881 ,end_customer_address1
882 ,end_customer_address2
883 ,end_customer_address3
884 ,end_customer_address4
885 ,end_customer_city
886 ,end_customer_state
887 ,end_customer_postal_code
888 ,end_customer_country
889 )
890 VALUES
891 (
892 l_line_val_rec.ACCOUNTING_RULE
893 , l_line_rec.ACCOUNTING_RULE_ID
894 , l_line_rec.ACCOUNTING_RULE_DURATION
895 , '' -- ACKNOWLEDGMENT_FLAG
896 , l_line_rec.ACTUAL_ARRIVAL_DATE
897 , l_line_rec.ACTUAL_SHIPMENT_DATE
898 , l_line_val_rec.AGREEMENT
899 , l_line_rec.AGREEMENT_ID
900 , l_line_rec.ARRIVAL_SET_ID
901 -- , l_line_rec.ARRIVAL_SET_NAME
902 , l_line_rec.ATO_LINE_ID
903 , l_line_rec.ATTRIBUTE1
904 , l_line_rec.ATTRIBUTE10
905 , l_line_rec.ATTRIBUTE11
906 , l_line_rec.ATTRIBUTE12
907 , l_line_rec.ATTRIBUTE13
908 , l_line_rec.ATTRIBUTE14
909 , l_line_rec.ATTRIBUTE15
910 , l_line_rec.ATTRIBUTE16 --For bug 2184255
911 , l_line_rec.ATTRIBUTE17
912 , l_line_rec.ATTRIBUTE18
913 , l_line_rec.ATTRIBUTE19
914 , l_line_rec.ATTRIBUTE2
915 , l_line_rec.ATTRIBUTE20
916 , l_line_rec.ATTRIBUTE3
917 , l_line_rec.ATTRIBUTE4
918 , l_line_rec.ATTRIBUTE5
919 , l_line_rec.ATTRIBUTE6
920 , l_line_rec.ATTRIBUTE7
921 , l_line_rec.ATTRIBUTE8
922 , l_line_rec.ATTRIBUTE9
923 , l_line_rec.AUTHORIZED_TO_SHIP_FLAG
924 , p_buyer_seller_flag
925 , l_line_rec.BOOKED_FLAG
926 -- , l_line_rec.CALCULATE_PRICE_FLAG
927 , l_line_rec.CANCELLED_FLAG
928 , l_line_rec.CANCELLED_QUANTITY
929 , '' -- CHANGE_DATE
930 , l_line_rec.CHANGE_SEQUENCE
931 -- , l_line_rec.CLOSED_FLAG
932 , l_line_rec.COMPONENT_CODE
933 , l_line_rec.COMPONENT_NUMBER
934 , l_line_rec.COMPONENT_SEQUENCE_ID
935 , l_line_rec.CONFIG_DISPLAY_SEQUENCE
936 -- , l_line_rec.CONFIG_LINE_REF
937 , l_line_rec.CONFIGURATION_ID
938 , l_line_rec.TOP_MODEL_LINE_ID
939 , l_line_rec.CONTEXT
940 , l_line_rec.CREATED_BY
941 , l_line_rec.CREATION_DATE
942 , l_line_rec.CUST_MODEL_SERIAL_NUMBER
943 , l_line_rec.CUST_PO_NUMBER
944 , l_line_rec.CUST_PRODUCTION_SEQ_NUM
945 , l_line_rec.CUSTOMER_DOCK_CODE
946 , l_line_rec.ORDERED_ITEM
947 , l_line_rec.ORDERED_ITEM_ID
948 -- , l_line_rec.CUSTOMER_ITEM_REVISION
949 , l_line_rec.CUSTOMER_JOB
950 , l_line_rec.CUSTOMER_PRODUCTION_LINE
951 , l_line_rec.CUSTOMER_TRX_LINE_ID
952 -- , l_line_rec.DELIVER_TO_CONTACT
953 , l_line_rec.DELIVER_TO_CONTACT_ID
954 , l_line_val_rec.DELIVER_TO_ORG
955 , l_line_rec.DELIVER_TO_ORG_ID
956 , l_line_rec.DELIVERY_LEAD_TIME
957 , l_line_val_rec.DEMAND_BUCKET_TYPE
958 , l_line_rec.DEMAND_BUCKET_TYPE_CODE
959 -- , l_line_rec.DEMAND_CLASS
960 , l_line_rec.DEMAND_CLASS_CODE
961 -- , l_line_rec.DEMAND_STREAM
962 , l_line_rec.DEP_PLAN_REQUIRED_FLAG
963 , l_line_rec.EARLIEST_ACCEPTABLE_DATE
964 , l_line_rec.EXPLOSION_DATE
965 , l_line_rec.FIRST_ACK_CODE
966 , l_line_rec.FIRST_ACK_DATE
967 , l_line_val_rec.FOB_POINT
968 , l_line_rec.FOB_POINT_CODE
969 , l_line_rec.FREIGHT_CARRIER_CODE
970 , l_line_val_rec.FREIGHT_TERMS
971 , l_line_rec.FREIGHT_TERMS_CODE
972 , l_line_rec.FULFILLED_QUANTITY
973 -- , l_line_rec.FULFILLMENT_SET_ID
974 -- , l_line_rec.FULFILLMENT_SET_NAME
975 , l_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
976 , l_line_rec.GLOBAL_ATTRIBUTE1
977 , l_line_rec.GLOBAL_ATTRIBUTE10
978 , l_line_rec.GLOBAL_ATTRIBUTE11
979 , l_line_rec.GLOBAL_ATTRIBUTE12
980 , l_line_rec.GLOBAL_ATTRIBUTE13
981 , l_line_rec.GLOBAL_ATTRIBUTE14
982 , l_line_rec.GLOBAL_ATTRIBUTE15
983 , l_line_rec.GLOBAL_ATTRIBUTE16
984 , l_line_rec.GLOBAL_ATTRIBUTE17
985 , l_line_rec.GLOBAL_ATTRIBUTE18
986 , l_line_rec.GLOBAL_ATTRIBUTE19
987 , l_line_rec.GLOBAL_ATTRIBUTE2
988 , l_line_rec.GLOBAL_ATTRIBUTE20
989 , l_line_rec.GLOBAL_ATTRIBUTE3
990 , l_line_rec.GLOBAL_ATTRIBUTE4
991 , l_line_rec.GLOBAL_ATTRIBUTE5
992 , l_line_rec.GLOBAL_ATTRIBUTE6
993 , l_line_rec.GLOBAL_ATTRIBUTE7
994 , l_line_rec.GLOBAL_ATTRIBUTE8
995 , l_line_rec.GLOBAL_ATTRIBUTE9
996 , l_line_rec.HEADER_ID
997 , l_line_rec.INDUSTRY_ATTRIBUTE1
998 , l_line_rec.INDUSTRY_ATTRIBUTE10
999 , l_line_rec.INDUSTRY_ATTRIBUTE11
1000 , l_line_rec.INDUSTRY_ATTRIBUTE12
1001 , l_line_rec.INDUSTRY_ATTRIBUTE13
1002 , l_line_rec.INDUSTRY_ATTRIBUTE14
1003 , l_line_rec.INDUSTRY_ATTRIBUTE15
1004 , l_line_rec.INDUSTRY_ATTRIBUTE16
1005 , l_line_rec.INDUSTRY_ATTRIBUTE17
1006 , l_line_rec.INDUSTRY_ATTRIBUTE18
1007 , l_line_rec.INDUSTRY_ATTRIBUTE19
1008 , l_line_rec.INDUSTRY_ATTRIBUTE2
1009 , l_line_rec.INDUSTRY_ATTRIBUTE20
1010 , l_line_rec.INDUSTRY_ATTRIBUTE21
1011 , l_line_rec.INDUSTRY_ATTRIBUTE22
1012 , l_line_rec.INDUSTRY_ATTRIBUTE23
1013 , l_line_rec.INDUSTRY_ATTRIBUTE24
1014 , l_line_rec.INDUSTRY_ATTRIBUTE25
1015 , l_line_rec.INDUSTRY_ATTRIBUTE26
1016 , l_line_rec.INDUSTRY_ATTRIBUTE27
1017 , l_line_rec.INDUSTRY_ATTRIBUTE28
1018 , l_line_rec.INDUSTRY_ATTRIBUTE29
1019 , l_line_rec.INDUSTRY_ATTRIBUTE3
1020 , l_line_rec.INDUSTRY_ATTRIBUTE30
1021 , l_line_rec.INDUSTRY_ATTRIBUTE4
1022 , l_line_rec.INDUSTRY_ATTRIBUTE5
1023 , l_line_rec.INDUSTRY_ATTRIBUTE6
1024 , l_line_rec.INDUSTRY_ATTRIBUTE7
1025 , l_line_rec.INDUSTRY_ATTRIBUTE8
1026 , l_line_rec.INDUSTRY_ATTRIBUTE9
1027 , l_line_rec.INDUSTRY_CONTEXT
1028 , l_line_rec.TP_CONTEXT
1029 , l_line_rec.TP_ATTRIBUTE1
1030 , l_line_rec.TP_ATTRIBUTE2
1031 , l_line_rec.TP_ATTRIBUTE3
1032 , l_line_rec.TP_ATTRIBUTE4
1033 , l_line_rec.TP_ATTRIBUTE5
1034 , l_line_rec.TP_ATTRIBUTE6
1035 , l_line_rec.TP_ATTRIBUTE7
1036 , l_line_rec.TP_ATTRIBUTE8
1037 , l_line_rec.TP_ATTRIBUTE9
1038 , l_line_rec.TP_ATTRIBUTE10
1039 , l_line_rec.TP_ATTRIBUTE11
1040 , l_line_rec.TP_ATTRIBUTE12
1041 , l_line_rec.TP_ATTRIBUTE13
1042 , l_line_rec.TP_ATTRIBUTE14
1043 , l_line_rec.TP_ATTRIBUTE15
1044 , l_line_rec.INTERMED_SHIP_TO_CONTACT_ID
1045 , l_line_rec.INTERMED_SHIP_TO_ORG_ID
1046 , l_line_val_rec.INVENTORY_ITEM
1047 , l_line_rec.INVENTORY_ITEM_ID
1048 -- , l_line_rec.INVOICE_COMPLETE_FLAG 11/03
1049 -- , l_line_rec.INVOICE_SET_ID
1050 -- , l_line_rec.INVOICE_SET_NAME
1051 -- , l_line_rec.INVOICE_NUMBER
1052 , l_line_val_rec.INVOICE_TO_CONTACT
1053 , l_line_rec.INVOICE_TO_CONTACT_ID
1054 , l_line_val_rec.INVOICE_TO_ORG
1055 , l_line_rec.INVOICE_TO_ORG_ID
1056 -- , ???().INVOICE_TOLERANCE_ABOVE
1057 -- , ???().INVOICE_TOLERANCE_BELOW
1058 , l_line_val_rec.INVOICING_RULE
1059 , l_line_rec.INVOICING_RULE_ID
1060 , l_line_rec.ORDERED_ITEM
1061 , l_line_rec.ITEM_REVISION
1062 , l_line_rec.item_identifier_type --ITEM_TYPE_CODE
1063 , l_line_rec.LAST_ACK_CODE
1064 , l_line_rec.LAST_ACK_DATE
1065 , l_line_rec.LAST_UPDATE_DATE
1066 , l_line_rec.LAST_UPDATE_LOGIN
1067 , l_line_rec.LAST_UPDATED_BY
1068 , l_line_rec.LATEST_ACCEPTABLE_DATE
1069 , l_line_rec.LINE_CATEGORY_CODE
1070 , l_line_rec.LINE_ID
1071 , l_line_rec.LINE_NUMBER
1072 -- , l_line_rec.LINE_PO_CONTEXT
1073 , l_line_val_rec.LINE_TYPE
1074 , l_line_rec.LINE_TYPE_ID
1075 , l_line_rec.LINK_TO_LINE_ID
1076 -- , l_line_rec.LINK_TO_LINE_REF
1077 -- , ???().LOT
1078 , l_line_rec.MODEL_GROUP_NUMBER
1079 , l_line_rec.OPEN_FLAG
1080 , l_line_rec.OPERATION
1081 , l_line_rec.OPTION_FLAG
1082 , l_line_rec.OPTION_NUMBER
1083 , l_line_rec.ORDER_QUANTITY_UOM
1084 , l_line_rec.ORDER_SOURCE_ID
1085 , l_line_rec.ORDERED_QUANTITY
1086 , l_line_rec.ORG_ID
1087 , l_line_rec.ORIG_SYS_DOCUMENT_REF
1088 , l_line_rec.ORIG_SYS_LINE_REF
1089 , l_line_rec.ORIG_SYS_SHIPMENT_REF
1090 , l_line_rec.OVER_SHIP_REASON_CODE
1091 , l_line_rec.OVER_SHIP_RESOLVED_FLAG
1092 , l_line_val_rec.PAYMENT_TERM
1093 , l_line_rec.PAYMENT_TERM_ID
1094 , l_line_val_rec.PRICE_LIST
1095 , l_line_rec.PRICE_LIST_ID
1096 , l_line_rec.PRICING_ATTRIBUTE1
1097 , l_line_rec.PRICING_ATTRIBUTE10
1098 , l_line_rec.PRICING_ATTRIBUTE2
1099 , l_line_rec.PRICING_ATTRIBUTE3
1100 , l_line_rec.PRICING_ATTRIBUTE4
1101 , l_line_rec.PRICING_ATTRIBUTE5
1102 , l_line_rec.PRICING_ATTRIBUTE6
1103 , l_line_rec.PRICING_ATTRIBUTE7
1104 , l_line_rec.PRICING_ATTRIBUTE8
1105 , l_line_rec.PRICING_ATTRIBUTE9
1106 , l_line_rec.PRICING_CONTEXT
1107 , l_line_rec.PRICING_DATE
1108 , l_line_rec.PRICING_QUANTITY
1109 , l_line_rec.PRICING_QUANTITY_UOM
1110 -- , ???().PROGRAM
1111 -- , ???().PROGRAM_APPLICATION
1112 , l_line_rec.PROGRAM_APPLICATION_ID
1113 , l_line_rec.PROGRAM_ID
1114 , l_line_rec.PROGRAM_UPDATE_DATE
1115 , l_line_val_rec.PROJECT
1116 , l_line_rec.PROJECT_ID
1117 , l_line_rec.PROMISE_DATE
1118 -- , l_line_rec.REFERENCE_HEADER
1119 , l_line_rec.REFERENCE_HEADER_ID
1120 -- , l_line_rec.REFERENCE_LINE
1121 , l_line_rec.REFERENCE_LINE_ID
1122 , l_line_rec.REFERENCE_TYPE
1123 , l_line_rec.REQUEST_DATE
1124 , l_line_rec.REQUEST_ID
1125 , l_line_rec.RESERVED_QUANTITY
1126 , l_line_rec.RETURN_ATTRIBUTE1
1127 , l_line_rec.RETURN_ATTRIBUTE10
1128 , l_line_rec.RETURN_ATTRIBUTE11
1129 , l_line_rec.RETURN_ATTRIBUTE12
1130 , l_line_rec.RETURN_ATTRIBUTE13
1131 , l_line_rec.RETURN_ATTRIBUTE14
1132 , l_line_rec.RETURN_ATTRIBUTE15
1133 , l_line_rec.RETURN_ATTRIBUTE2
1134 , l_line_rec.RETURN_ATTRIBUTE3
1135 , l_line_rec.RETURN_ATTRIBUTE4
1136 , l_line_rec.RETURN_ATTRIBUTE5
1137 , l_line_rec.RETURN_ATTRIBUTE6
1138 , l_line_rec.RETURN_ATTRIBUTE7
1139 , l_line_rec.RETURN_ATTRIBUTE8
1140 , l_line_rec.RETURN_ATTRIBUTE9
1141 , l_line_rec.RETURN_CONTEXT
1142 , l_line_rec.RETURN_REASON_CODE
1143 , l_line_rec.RLA_SCHEDULE_TYPE_CODE
1144 , l_line_rec.SALESREP_ID
1145 , l_line_val_rec.SALESREP
1146 , l_line_rec.SCHEDULE_ARRIVAL_DATE
1147 , l_line_rec.SCHEDULE_SHIP_DATE
1148 -- , l_line_rec.SCHEDULE_ITEM_DETAIL
1149 , l_line_rec.SCHEDULE_STATUS_CODE
1150 , l_line_val_rec.SHIP_FROM_ORG
1151 , l_line_rec.SHIP_FROM_ORG_ID
1152 , l_line_rec.SHIP_MODEL_COMPLETE_FLAG
1153 , l_line_rec.SHIP_SET_ID
1154 -- , l_line_rec.SHIP_SET_NAME
1155 , l_line_val_rec.SHIP_TO_ADDRESS1
1156 , l_line_val_rec.SHIP_TO_ADDRESS2
1157 , l_line_val_rec.SHIP_TO_ADDRESS3
1158 , l_line_val_rec.SHIP_TO_ADDRESS4
1159 , l_line_val_rec.SHIP_TO_CITY
1160 , l_line_val_rec.SHIP_TO_CONTACT
1161 -- , l_line_rec.SHIP_TO_CONTACT_AREA_CODE1
1162 -- , l_line_rec.SHIP_TO_CONTACT_AREA_CODE2
1163 -- , l_line_rec.SHIP_TO_CONTACT_AREA_CODE3
1164 , l_line_val_rec.SHIP_TO_CONTACT_FIRST_NAME
1165 , l_line_rec.SHIP_TO_CONTACT_ID
1166 -- , l_line_rec.SHIP_TO_CONTACT_JOB_TITLE
1167 , l_line_val_rec.SHIP_TO_CONTACT_LAST_NAME
1168 , l_line_val_rec.SHIP_TO_COUNTRY
1169 , l_line_val_rec.SHIP_TO_COUNTY
1170 , l_line_val_rec.SHIP_TO_ORG
1171 , l_line_rec.SHIP_TO_ORG_ID
1172 , l_line_val_rec.SHIP_TO_zip
1173 , l_line_val_rec.SHIP_TO_STATE
1174 , l_line_rec.SHIP_TOLERANCE_ABOVE
1175 , l_line_rec.SHIP_TOLERANCE_BELOW
1176 , l_line_rec.SHIPMENT_NUMBER
1177 , l_line_val_rec.SHIPMENT_PRIORITY
1178 , l_line_rec.SHIPMENT_PRIORITY_CODE
1179 , l_line_rec.SHIPPED_QUANTITY
1180 -- , l_line_rec.SHIPPING_METHOD
1181 , l_line_rec.SHIPPING_METHOD_CODE
1182 , l_line_rec.SHIPPING_QUANTITY
1183 , l_line_rec.SHIPPING_QUANTITY_UOM
1184 -- , ???().SOLD_FROM_ORG
1185 -- , ???().SOLD_FROM_ORG_ID
1186 , l_line_val_rec.SOLD_TO_ORG
1187 , l_line_rec.SOLD_TO_ORG_ID
1188 , l_line_rec.SORT_ORDER
1189 , l_line_rec.SOURCE_DOCUMENT_ID
1190 , l_line_rec.SOURCE_DOCUMENT_LINE_ID
1191 , l_line_rec.SOURCE_DOCUMENT_TYPE_ID
1192 , l_line_rec.SOURCE_TYPE_CODE
1193 , l_line_rec.SPLIT_FROM_LINE_ID
1194 -- , ???.SUBINVENTORY
1195 -- , ???.SUBMISSION_DATETIME
1196 , l_line_val_rec.TASK
1197 , l_line_rec.TASK_ID
1198 -- , l_line_rec.TAX
1199 , l_line_rec.TAX_CODE
1200 , l_line_rec.TAX_DATE
1201 , l_line_rec.TAX_EXEMPT_FLAG
1202 , l_line_rec.TAX_EXEMPT_NUMBER
1203 , l_line_val_rec.TAX_EXEMPT_REASON
1204 , l_line_rec.TAX_EXEMPT_REASON_CODE
1205 , l_line_val_rec.TAX_POINT
1206 , l_line_rec.TAX_POINT_CODE
1207 , l_line_rec.TAX_RATE
1208 , l_line_rec.TAX_VALUE
1209 , l_line_rec.UNIT_LIST_PRICE
1210 , l_line_rec.UNIT_SELLING_PRICE
1211 , l_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
1212 , l_line_rec.VISIBLE_DEMAND_FLAG
1213 , l_line_rec.split_from_line_ref
1214 , l_line_rec.split_from_shipment_ref
1215 , l_line_rec.SHIP_TO_EDI_LOCATION_CODE
1216 , l_line_rec.Service_Txn_Reason_Code
1217 , l_line_rec.Service_Txn_Comments
1218 , l_line_rec.Service_Duration
1219 , l_line_rec.Service_Start_Date
1220 , l_line_rec.Service_End_Date
1221 , l_line_rec.Service_Coterminate_Flag
1222 , l_line_rec.Service_Number
1223 , l_line_rec.Service_Period
1224 , l_line_rec.Service_Reference_Type_Code
1225 , l_line_rec.Service_Reference_Line_Id
1226 , l_line_rec.Service_Reference_System_Id
1227 , l_line_rec.Credit_Invoice_Line_Id
1228 , l_line_val_rec.Ship_to_Province
1229 , l_line_val_rec.Invoice_to_Province
1230 , l_line_rec.Bill_to_Edi_Location_Code
1231 , l_line_val_rec.Invoice_To_City
1232 , l_line_rec.ship_from_edi_location_code
1233 , l_line_val_rec.SHIP_FROM_ADDRESS1
1234 , l_line_val_rec.SHIP_FROM_ADDRESS2
1235 , l_line_val_rec.SHIP_FROM_ADDRESS3
1236 , l_line_val_rec.SHIP_FROM_CITY
1237 , l_line_val_rec.SHIP_FROM_POSTAL_CODE
1238 , l_line_val_rec.SHIP_FROM_COUNTRY
1239 , l_line_val_rec.SHIP_FROM_REGION1
1240 , l_line_val_rec.SHIP_FROM_REGION2
1241 , l_line_val_rec.SHIP_FROM_REGION3
1242 , l_line_rec.SHIP_FROM_ADDRESS_ID
1243 , l_line_rec.SHIP_TO_ADDRESS_ID
1244 , l_line_val_rec.SHIP_TO_LOCATION
1245 , l_line_rec.service_reference_line
1246 , l_line_rec.service_reference_order
1247 , l_line_rec.service_reference_system
1248 -- , l_line_val_rec.order_source
1249 , l_line_rec.customer_line_number
1250 , l_line_rec.CUSTOMER_ITEM_NET_PRICE --bug#5733732
1251 , l_line_rec.user_item_description
1252 , p_ack_type
1253 , l_line_rec.blanket_number
1254 , l_line_rec.blanket_line_number
1255 , l_line_rec.original_inventory_item_id
1256 , l_line_rec.original_ordered_item_id
1257 , l_line_rec.original_ordered_item
1258 , l_line_rec.original_item_identifier_type
1259 , l_line_rec.item_relationship_type
1260 , l_error_flag
1261 , l_line_rec.customer_shipment_number
1262 -- { Distributer Order related change
1263 , l_line_rec.end_customer_id
1264 , l_line_rec.end_customer_contact_id
1265 , l_line_rec.end_customer_site_use_id
1266 , l_line_rec.ib_owner
1267 , l_line_rec.ib_current_location
1268 , l_line_rec.ib_installed_at_location
1269 -- Distributer Order related change }
1270 , l_line_rec.charge_periodicity_code
1271 ,l_line_val_rec.end_customer_name
1272 ,l_line_val_rec.end_customer_number
1273 ,l_line_val_rec.end_customer_contact
1274 ,l_line_val_rec.end_customer_site_address1
1275 ,l_line_val_rec.end_customer_site_address2
1276 ,l_line_val_rec.end_customer_site_address3
1277 ,l_line_val_rec.end_customer_site_address4
1278 ,l_line_val_rec.end_customer_site_city
1279 ,l_line_val_rec.end_customer_site_state
1280 ,l_line_val_rec.end_customer_site_postal_code
1281 ,l_line_val_rec.end_customer_site_country
1282 );
1283 ELSE
1284 oe_debug_pub.add('Incomplete data for inserting line ack rec');
1285 END IF;
1286 <<nextline>>
1287 I := p_line_tbl.NEXT(I);
1288 END LOOP;
1289
1290 EXCEPTION
1291
1292 WHEN OTHERS THEN
1293
1294 oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);
1295
1296 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1297 THEN
1298 FND_MSG_PUB.Add_Exc_Msg
1299 ( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'
1300 );
1301 END IF;
1302
1303 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304
1305 END Insert_Row;
1306
1307
1308 Procedure Extend_Line_Rec
1309 (p_line_rec In Out Nocopy OE_Update_Ack_Util.Line_Rec_Type,
1310 p_count In Number)
1311
1312 Is
1313
1314 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1315
1316 Begin
1317 oe_debug_pub.add('Entering Extend_Line_Rec');
1318
1319 p_line_rec.line_id.extend(p_count);
1320 p_line_rec.header_id.extend(p_count);
1321 p_line_rec.ship_to_org_id.extend(p_count);
1322 p_line_rec.invoice_to_org_id.extend(p_count);
1323 p_line_rec.invoice_to_contact_id.extend(p_count);
1324 p_line_rec.ship_from_org_id.extend(p_count);
1325 p_line_rec.agreement_id.extend(p_count);
1326 p_line_rec.price_list_id.extend(p_count);
1327 p_line_rec.arrival_set_id.extend(p_count);
1328 p_line_rec.accounting_rule_id.extend(p_count);
1329 p_line_rec.fulfillment_set_id.extend(p_count);
1330 p_line_rec.inventory_item.extend(p_count); --added for bug4309609
1331 p_line_rec.inventory_item_id.extend(p_count);
1332 p_line_rec.invoicing_rule_id.extend(p_count);
1333 p_line_rec.line_type_id.extend(p_count);
1334 p_line_rec.order_source_id.extend(p_count);
1335 p_line_rec.payment_term_id.extend(p_count);
1336 p_line_rec.project_id.extend(p_count);
1337 p_line_rec.salesrep_id.extend(p_count);
1338 p_line_rec.ship_set_id.extend(p_count);
1339 p_line_rec.ship_to_contact_id.extend(p_count);
1340 p_line_rec.task_id.extend(p_count);
1341 p_line_rec.fob_point_code.extend(p_count);
1342 p_line_rec.freight_terms_code.extend(p_count);
1343 p_line_rec.shipping_method_code.extend(p_count);
1344 p_line_rec.tax_code.extend(p_count);
1345 p_line_rec.tax_point_code.extend(p_count);
1346 p_line_rec.tax_exempt_reason_code.extend(p_count);
1347 p_line_rec.first_ack_code.extend(p_count);
1348
1349 p_line_rec.accounting_rule_duration.extend(p_count);
1350 p_line_rec.actual_arrival_date.extend(p_count);
1351 p_line_rec.actual_shipment_date.extend(p_count);
1352 p_line_rec.ato_line_id.extend(p_count);
1353 p_line_rec.authorized_to_ship_flag.extend(p_count);
1354 p_line_rec.booked_flag.extend(p_count);
1355 p_line_rec.cancelled_flag.extend(p_count);
1356 p_line_rec.cancelled_quantity.extend(p_count);
1357 p_line_rec.change_sequence.extend(p_count);
1358 p_line_rec.component_code.extend(p_count);
1359 p_line_rec.component_number.extend(p_count);
1360 p_line_rec.component_sequence_id.extend(p_count);
1361 p_line_rec.config_display_sequence.extend(p_count);
1362 p_line_rec.configuration_id.extend(p_count);
1363 p_line_rec.top_model_line_id.extend(p_count);
1364 p_line_rec.created_by.extend(p_count);
1365 p_line_rec.creation_date.extend(p_count);
1366 p_line_rec.cust_model_serial_number.extend(p_count);
1367 p_line_rec.cust_po_number.extend(p_count);
1368 p_line_rec.cust_production_seq_num.extend(p_count);
1369 p_line_rec.customer_dock_code.extend(p_count);
1370 p_line_rec.ordered_item.extend(p_count);
1371 p_line_rec.ordered_item_id.extend(p_count); /* Bug # 4761560 */
1372 p_line_rec.customer_job.extend(p_count);
1373 p_line_rec.customer_production_line.extend(p_count);
1374 p_line_rec.customer_trx_line_id.extend(p_count);
1375 p_line_rec.deliver_to_contact_id.extend(p_count);
1376 p_line_rec.deliver_to_org_id.extend(p_count);
1377 p_line_rec.delivery_lead_time.extend(p_count);
1378 p_line_rec.demand_bucket_type_code.extend(p_count);
1379 p_line_rec.demand_class_code.extend(p_count);
1380 p_line_rec.dep_plan_required_flag.extend(p_count);
1381 p_line_rec.earliest_acceptable_date.extend(p_count);
1382 p_line_rec.explosion_date.extend(p_count);
1383 p_line_rec.freight_carrier_code.extend(p_count);
1384 p_line_rec.fulfilled_quantity.extend(p_count);
1385 p_line_rec.item_revision.extend(p_count);
1386 p_line_rec.item_identifier_type.extend(p_count);
1387 p_line_rec.context.extend(p_count);
1388 p_line_rec.first_ack_date.extend(p_count);
1389 p_line_rec.last_ack_code.extend(p_count);
1390 p_line_rec.last_ack_date.extend(p_count);
1391
1392 p_line_rec.last_update_date.extend(p_count);
1393 p_line_rec.last_update_login.extend(p_count);
1394 p_line_rec.last_updated_by.extend(p_count);
1395 p_line_rec.latest_acceptable_date.extend(p_count);
1396 p_line_rec.line_category_code.extend(p_count);
1397 p_line_rec.line_number.extend(p_count);
1398 p_line_rec.link_to_line_id.extend(p_count);
1399 p_line_rec.model_group_number.extend(p_count);
1400 p_line_rec.open_flag.extend(p_count);
1401 p_line_rec.operation_code.extend(p_count);
1402 p_line_rec.option_flag.extend(p_count);
1403 p_line_rec.option_number.extend(p_count);
1404 p_line_rec.order_quantity_uom.extend(p_count);
1405 p_line_rec.ordered_quantity.extend(p_count);
1406 p_line_rec.org_id.extend(p_count);
1407 p_line_rec.orig_sys_document_ref.extend(p_count);
1408 p_line_rec.orig_sys_line_ref.extend(p_count);
1409 p_line_rec.orig_sys_shipment_ref.extend(p_count);
1410 p_line_rec.over_ship_reason_code.extend(p_count);
1411 p_line_rec.over_ship_resolved_flag.extend(p_count);
1412 p_line_rec.pricing_date.extend(p_count);
1413 p_line_rec.pricing_quantity.extend(p_count);
1414 p_line_rec.pricing_quantity_uom.extend(p_count);
1415 p_line_rec.program_application_id.extend(p_count);
1416 p_line_rec.program_id.extend(p_count);
1417 p_line_rec.program_update_date.extend(p_count);
1418 p_line_rec.promise_date.extend(p_count);
1419 p_line_rec.reference_header_id.extend(p_count);
1420 p_line_rec.reference_line_id.extend(p_count);
1421 p_line_rec.reference_type.extend(p_count);
1422 p_line_rec.request_date.extend(p_count);
1423 p_line_rec.request_id.extend(p_count);
1424 p_line_rec.reserved_quantity.extend(p_count);
1425 p_line_rec.return_reason_code.extend(p_count);
1426 p_line_rec.rla_schedule_type_code.extend(p_count);
1427 p_line_rec.schedule_arrival_date.extend(p_count);
1428 p_line_rec.schedule_ship_date.extend(p_count);
1429 p_line_rec.schedule_status_code.extend(p_count);
1430 p_line_rec.ship_model_complete_flag.extend(p_count);
1431 p_line_rec.ship_tolerance_above.extend(p_count);
1432 p_line_rec.ship_tolerance_below.extend(p_count);
1433 p_line_rec.shipment_number.extend(p_count);
1434 p_line_rec.shipment_priority_code.extend(p_count);
1435 p_line_rec.shipped_quantity.extend(p_count);
1436 p_line_rec.SHIPPING_METHOD_CODE.extend(p_count);
1437 p_line_rec.SHIPPING_QUANTITY.extend(p_count);
1438 p_line_rec.SHIPPING_QUANTITY_UOM.extend(p_count);
1439 p_line_rec.SOLD_TO_ORG_ID.extend(p_count);
1440 p_line_rec.SORT_ORDER.extend(p_count);
1441 p_line_rec.SOURCE_DOCUMENT_ID.extend(p_count);
1442 p_line_rec.SOURCE_DOCUMENT_LINE_ID.extend(p_count);
1443 p_line_rec.SOURCE_DOCUMENT_TYPE_ID.extend(p_count);
1444 p_line_rec.SOURCE_TYPE_CODE.extend(p_count);
1445 p_line_rec.SPLIT_FROM_LINE_ID.extend(p_count);
1446 p_line_rec.TAX_CODE.extend(p_count);
1447 p_line_rec.TAX_DATE.extend(p_count);
1448 p_line_rec.TAX_EXEMPT_FLAG.extend(p_count);
1449 p_line_rec.TAX_EXEMPT_NUMBER.extend(p_count);
1450 p_line_rec.TAX_EXEMPT_REASON_CODE.extend(p_count);
1451 p_line_rec.TAX_POINT_CODE.extend(p_count);
1452 p_line_rec.TAX_RATE.extend(p_count);
1453 p_line_rec.TAX_VALUE.extend(p_count);
1454 p_line_rec.UNIT_LIST_PRICE.extend(p_count);
1455 p_line_rec.UNIT_SELLING_PRICE.extend(p_count);
1456 p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID.extend(p_count);
1457 p_line_rec.VISIBLE_DEMAND_FLAG.extend(p_count);
1458 p_line_rec.split_from_line_ref.extend(p_count);
1459 p_line_rec.split_from_shipment_ref.extend(p_count);
1460 p_line_rec.Service_Txn_Reason_Code.extend(p_count);
1461 p_line_rec.Service_Txn_Comments.extend(p_count);
1462 p_line_rec.Service_Duration.extend(p_count);
1463 p_line_rec.Service_Start_Date.extend(p_count);
1464 p_line_rec.Service_End_Date.extend(p_count);
1465 p_line_rec.Service_Coterminate_Flag.extend(p_count);
1466 p_line_rec.Service_Number.extend(p_count);
1467 p_line_rec.Service_Period.extend(p_count);
1468 p_line_rec.Service_Reference_Type_Code.extend(p_count);
1469 p_line_rec.service_Reference_Line_Id.extend(p_count);
1470 p_line_rec.Service_Reference_System_Id.extend(p_count);
1471 p_line_rec.Credit_Invoice_Line_Id.extend(p_count);
1472 p_line_rec.service_reference_line.extend(p_count);
1473 p_line_rec.service_reference_order.extend(p_count);
1474 p_line_rec.service_reference_system.extend(p_count);
1475 p_line_rec.customer_line_number.extend(p_count);
1476 p_line_rec.user_item_description.extend(p_count);
1477 p_line_rec.acknowledgment_type.extend(p_count);
1478 p_line_rec.blanket_number.extend(p_count);
1479 p_line_rec.blanket_line_number.extend(p_count);
1480 p_line_rec.original_inventory_item_id.extend(p_count);
1481 p_line_rec.original_ordered_item_id.extend(p_count);
1482 p_line_rec.original_ordered_item.extend(p_count);
1483 p_line_rec.original_item_identifier_type.extend(p_count);
1484 p_line_rec.item_relationship_type.extend(p_count);
1485 p_line_rec.attribute1.extend(p_count);
1486 p_line_rec.attribute10.extend(p_count);
1487 p_line_rec.attribute11.extend(p_count);
1488 p_line_rec.attribute12.extend(p_count);
1489 p_line_rec.attribute13.extend(p_count);
1490 p_line_rec.attribute14.extend(p_count);
1491 p_line_rec.attribute15.extend(p_count);
1492 p_line_rec.attribute16.extend(p_count);
1493 p_line_rec.attribute17.extend(p_count);
1494 p_line_rec.attribute18.extend(p_count);
1495 p_line_rec.attribute19.extend(p_count);
1496 p_line_rec.attribute2.extend(p_count);
1497 p_line_rec.attribute20.extend(p_count);
1498 p_line_rec.attribute3.extend(p_count);
1499 p_line_rec.attribute4.extend(p_count);
1500 p_line_rec.attribute5.extend(p_count);
1501 p_line_rec.attribute6.extend(p_count);
1502 p_line_rec.attribute7.extend(p_count);
1503 p_line_rec.attribute8.extend(p_count);
1504 p_line_rec.attribute9.extend(p_count);
1505 p_line_rec.global_attribute1.extend(p_count);
1506 p_line_rec.global_attribute10.extend(p_count);
1507 p_line_rec.global_attribute11.extend(p_count);
1508 p_line_rec.global_attribute12.extend(p_count);
1509 p_line_rec.global_attribute13.extend(p_count);
1510 p_line_rec.global_attribute14.extend(p_count);
1511 p_line_rec.global_attribute15.extend(p_count);
1512 p_line_rec.global_attribute16.extend(p_count);
1513 p_line_rec.global_attribute17.extend(p_count);
1514 p_line_rec.global_attribute18.extend(p_count);
1515 p_line_rec.global_attribute19.extend(p_count);
1516 p_line_rec.global_attribute2.extend(p_count);
1517 p_line_rec.global_attribute20.extend(p_count);
1518 p_line_rec.global_attribute3.extend(p_count);
1519 p_line_rec.global_attribute4.extend(p_count);
1520 p_line_rec.global_attribute5.extend(p_count);
1521 p_line_rec.global_attribute6.extend(p_count);
1522 p_line_rec.global_attribute7.extend(p_count);
1523 p_line_rec.global_attribute8.extend(p_count);
1524 p_line_rec.global_attribute9.extend(p_count);
1525 p_line_rec.global_attribute_category.extend(p_count);
1526 p_line_rec.industry_attribute1.extend(p_count);
1527 p_line_rec.industry_attribute10.extend(p_count);
1528 p_line_rec.industry_attribute11.extend(p_count);
1529 p_line_rec.industry_attribute12.extend(p_count);
1530 p_line_rec.industry_attribute13.extend(p_count);
1531 p_line_rec.industry_attribute14.extend(p_count);
1532 p_line_rec.industry_attribute15.extend(p_count);
1533 p_line_rec.industry_attribute16.extend(p_count);
1534 p_line_rec.industry_attribute17.extend(p_count);
1535 p_line_rec.industry_attribute18.extend(p_count);
1536 p_line_rec.industry_attribute19.extend(p_count);
1537 p_line_rec.industry_attribute20.extend(p_count);
1538 p_line_rec.industry_attribute21.extend(p_count);
1539 p_line_rec.industry_attribute22.extend(p_count);
1540 p_line_rec.industry_attribute23.extend(p_count);
1541 p_line_rec.industry_attribute24.extend(p_count);
1542 p_line_rec.industry_attribute25.extend(p_count);
1543 p_line_rec.industry_attribute26.extend(p_count);
1544 p_line_rec.industry_attribute27.extend(p_count);
1545 p_line_rec.industry_attribute28.extend(p_count);
1546 p_line_rec.industry_attribute29.extend(p_count);
1547 p_line_rec.industry_attribute30.extend(p_count);
1548 p_line_rec.industry_attribute2.extend(p_count);
1549 p_line_rec.industry_attribute3.extend(p_count);
1550 p_line_rec.industry_attribute4.extend(p_count);
1551 p_line_rec.industry_attribute5.extend(p_count);
1552 p_line_rec.industry_attribute6.extend(p_count);
1553 p_line_rec.industry_attribute7.extend(p_count);
1554 p_line_rec.industry_attribute8.extend(p_count);
1555 p_line_rec.industry_attribute9.extend(p_count);
1556 p_line_rec.industry_context.extend(p_count);
1557 p_line_rec.TP_CONTEXT.extend(p_count);
1558 p_line_rec.TP_ATTRIBUTE1.extend(p_count);
1559 p_line_rec.TP_ATTRIBUTE2.extend(p_count);
1560 p_line_rec.TP_ATTRIBUTE3.extend(p_count);
1561 p_line_rec.TP_ATTRIBUTE4.extend(p_count);
1562 p_line_rec.TP_ATTRIBUTE5.extend(p_count);
1563 p_line_rec.TP_ATTRIBUTE6.extend(p_count);
1564 p_line_rec.TP_ATTRIBUTE7.extend(p_count);
1565 p_line_rec.TP_ATTRIBUTE8.extend(p_count);
1566 p_line_rec.TP_ATTRIBUTE9.extend(p_count);
1567 p_line_rec.TP_ATTRIBUTE10.extend(p_count);
1568 p_line_rec.TP_ATTRIBUTE11.extend(p_count);
1569 p_line_rec.TP_ATTRIBUTE12.extend(p_count);
1570 p_line_rec.TP_ATTRIBUTE13.extend(p_count);
1571 p_line_rec.TP_ATTRIBUTE14.extend(p_count);
1572 p_line_rec.TP_ATTRIBUTE15.extend(p_count);
1573 p_line_rec.pricing_attribute1.extend(p_count);
1574 p_line_rec.pricing_attribute10.extend(p_count);
1575 p_line_rec.pricing_attribute2.extend(p_count);
1576 p_line_rec.pricing_attribute3.extend(p_count);
1577 p_line_rec.pricing_attribute4.extend(p_count);
1578 p_line_rec.pricing_attribute5.extend(p_count);
1579 p_line_rec.pricing_attribute6.extend(p_count);
1580 p_line_rec.pricing_attribute7.extend(p_count);
1581 p_line_rec.pricing_attribute8.extend(p_count);
1582 p_line_rec.pricing_attribute9.extend(p_count);
1583 p_line_rec.pricing_context.extend(p_count);
1584 p_line_rec.return_attribute1.extend(p_count);
1585 p_line_rec.return_attribute10.extend(p_count);
1586 p_line_rec.return_attribute11.extend(p_count);
1587 p_line_rec.return_attribute12.extend(p_count);
1588 p_line_rec.return_attribute13.extend(p_count);
1589 p_line_rec.return_attribute14.extend(p_count);
1590 p_line_rec.return_attribute15.extend(p_count);
1591 p_line_rec.return_attribute2.extend(p_count);
1592 p_line_rec.return_attribute3.extend(p_count);
1593 p_line_rec.return_attribute4.extend(p_count);
1594 p_line_rec.return_attribute5.extend(p_count);
1595 p_line_rec.return_attribute6.extend(p_count);
1596 p_line_rec.return_attribute7.extend(p_count);
1597 p_line_rec.return_attribute8.extend(p_count);
1598 p_line_rec.return_attribute9.extend(p_count);
1599 p_line_rec.return_context.extend(p_count);
1600 p_line_rec.customer_shipment_number.extend(p_count);
1601 -- { Distributer Order related change
1602 p_line_rec.end_customer_id.extend(p_count);
1603 p_line_rec.end_customer_contact_id.extend(p_count);
1604 p_line_rec.end_customer_site_use_id.extend(p_count);
1605 p_line_rec.ib_owner.extend(p_count);
1606 p_line_rec.ib_current_location.extend(p_count);
1607 p_line_rec.ib_installed_at_location.extend(p_count);
1608 -- Distributer Order related change }
1609 p_line_rec.charge_periodicity_code.extend(p_count);
1610
1611 oe_debug_pub.add('Exiting Extend_Line_Rec');
1612
1613 Exception
1614 When Others Then
1615 If l_debug_level > 0 Then
1616 Oe_Debug_Pub.Add('When Others in Extend_Line_Rec');
1617 Oe_Debug_Pub.Add('Error: '||sqlerrm);
1618 End If;
1619
1620 End Extend_Line_Rec;
1621
1622
1623 Procedure Insert_Row
1624 ( p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
1625 p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
1626 x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
1627 )
1628
1629 Is
1630
1631 l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;
1632 l_line_acks_rec OE_Update_Ack_Util.Line_Rec_Type;
1633 l_count Number;
1634 i Pls_Integer;
1635 k Pls_Integer := 0;
1636 l_ack_type Varchar2(30);
1637 l_validation_org_id number; -- bug 4309609
1638 Begin
1639
1640 l_count := l_line_tbl.Count;
1641 i := l_line_tbl.First;
1642
1643 While i Is Not Null Loop
1644 If (nvl(l_line_tbl(i).FIRST_ACK_CODE, ' ')= ' ' OR
1645 l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR) Then
1646 -- Trans is 855
1647 --l_ack_type := '855'; for bug4730258
1648 If l_line_tbl(i).schedule_ship_date Is Null Then
1649 l_line_tbl(i).first_ack_code := 'SP';
1650 End If;
1651 If l_line_tbl(i).schedule_ship_date Is Not Null And
1652 trunc (l_line_tbl(i).schedule_ship_date) <> nvl(trunc (l_line_tbl(i).Request_date),FND_API.G_MISS_DATE) Then
1653 l_line_tbl(i).first_ack_code := 'DR';
1654 End If;
1655 If l_line_tbl(i).ordered_quantity <> p_old_line_tbl(i).ordered_quantity Then
1656 If l_line_tbl(i).first_ack_code Is Null Or
1657 l_line_tbl(i).first_ack_code = FND_API.G_MISS_CHAR Then
1658 l_line_tbl(i).first_ack_code := 'IQ';
1659 Else
1660 l_line_tbl(i).first_ack_code := 'IC';
1661 End If;
1662 End If;
1663 -- Added for bug 4771523 start
1664 If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1665 l_line_tbl(i).first_ack_code := 'IP';
1666 End If;
1667 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1668 AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1669 oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1670 oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1671 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1672 l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1673 oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1674 END IF;
1675 oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_price,5);
1676 oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1677 END IF;
1678 -- Added for bug 4771523 end
1679
1680
1681 If l_line_tbl(i).ORIGINAL_INVENTORY_ITEM_ID is NOT NULL Then
1682 If (l_line_tbl(i).ITEM_RELATIONSHIP_TYPE Is Null
1683 OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 2
1684 OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 4
1685 OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 8
1686 OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 14) Then
1687 If l_line_tbl(i).FIRST_ACK_CODE Is Null Or
1688 l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
1689 l_line_tbl(i).FIRST_ACK_CODE := 'IS';
1690 Else
1691 l_line_tbl(i).FIRST_ACK_CODE := 'IC';
1692 End If;
1693 Else
1694 If l_line_tbl(i).FIRST_ACK_CODE Is Null Or
1695 l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
1696 l_line_tbl(i).FIRST_ACK_CODE := 'IA';
1697 End If;
1698 End If;
1699 End If;
1700
1701 If l_line_tbl(i).SPLIT_FROM_LINE_ID Is Not Null And
1702 l_line_tbl(i).split_by = 'SYSTEM' Then
1703 l_line_tbl(i).FIRST_ACK_CODE := 'IB';
1704 End If;
1705
1706 If l_line_tbl(i).OPEN_FLAG = 'N' Then
1707 l_line_tbl(i).FIRST_ACK_CODE := 'ID';
1708 End If;
1709
1710 If l_line_tbl(i).FIRST_ACK_CODE Is Null Or
1711 l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
1712 l_line_tbl(i).FIRST_ACK_CODE := 'IA';
1713 Elsif l_line_tbl(i).FIRST_ACK_CODE Is Not Null Then
1714 Update_Header_Ack_Code (l_line_tbl(i).header_id, 'AC', NULL);
1715 End If;
1716 l_line_tbl(i).FIRST_ACK_DATE := '';
1717 l_line_tbl(i).LAST_ACK_CODE := '';
1718 l_line_tbl(i).LAST_ACK_DATE := '';
1719
1720 Else -- 865
1721 IF l_line_tbl(i).changed_lines_pocao = 'N' THEN
1722 GOTO nextline;
1723 End If;
1724 --l_ack_type := '865'; for bug4730258
1725 l_line_tbl(i).FIRST_ACK_DATE := p_old_line_tbl(I).FIRST_ACK_DATE;
1726 If l_line_tbl(i).SCHEDULE_SHIP_DATE Is Null Then
1727 l_line_tbl(i).LAST_ACK_CODE := 'SP';
1728 End If;
1729 If l_line_tbl(i).SCHEDULE_SHIP_DATE Is Not Null And
1730 l_line_tbl(i).schedule_ship_date <> nvl(p_old_line_tbl(I).schedule_ship_date,FND_API.G_MISS_DATE) And
1731 l_line_tbl(i).schedule_ship_date <> nvl(l_line_tbl(i).REQUEST_DATE, FND_API.G_MISS_DATE) Then
1732 l_line_tbl(i).LAST_ACK_CODE := 'DR';
1733 End If;
1734
1735 -- Added for bug 4771523
1736 If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1737 l_line_tbl(i).LAST_ACK_CODE := 'IP';
1738 End If;
1739 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1740 AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1741 oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1742 oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1743 IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1744 l_line_tbl(i).LAST_ACK_CODE := 'IP';
1745 oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1746 END IF;
1747 oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_price,5);
1748 oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1749 END IF;
1750 -- Added for bug 4771523
1751
1752 If l_line_tbl(i).ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY Then
1753 If l_line_tbl(i).LAST_ACK_CODE Is Null Or
1754 l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then
1755 l_line_tbl(i).LAST_ACK_CODE := 'IQ';
1756 Else
1757 l_line_tbl(i).LAST_ACK_CODE := 'IC';
1758 End If;
1759 End If;
1760 If l_line_tbl(i).SPLIT_FROM_LINE_ID Is Not Null And
1761 l_line_tbl(i).split_by = 'SYSTEM' Then
1762 l_line_tbl(i).LAST_ACK_CODE := 'IB';
1763 End If;
1764 If l_line_tbl(i).OPEN_FLAG = 'N' Then
1765 l_line_tbl(i).LAST_ACK_CODE := 'ID';
1766 End If;
1767
1768 If l_line_tbl(i).LAST_ACK_CODE Is Null Or
1769 l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then
1770 l_line_tbl(i).LAST_ACK_CODE := 'IA';
1771 End If;
1772
1773 l_line_tbl(i).LAST_ACK_DATE := '';
1774
1775 End If;
1776
1777 If l_line_tbl(i).split_from_line_id Is Not Null And
1778 l_line_tbl(i).split_from_line_id <> FND_API.G_MISS_NUM Then
1779 --bsadri get the split reference
1780 Begin
1781 Select orig_sys_line_ref, orig_sys_shipment_ref
1782 Into l_line_tbl(i).split_from_line_ref, l_line_tbl(i).split_from_shipment_ref
1783 From OE_ORDER_LINES
1784 Where line_id = l_line_tbl(i).split_from_line_id;
1785 Exception
1786 When Others Then
1787 Null;
1788 End;
1789 End If;
1790
1791 -- Assign to collection
1792 Extend_Line_Rec
1793 (p_line_rec => l_line_acks_rec,
1794 p_count => 1);
1795
1796 k := k +1;
1797 l_line_acks_rec.line_id(k) := l_line_tbl(i).line_id;
1798 l_line_acks_rec.header_id(k) := l_line_tbl(i).header_id;
1799
1800 l_line_acks_rec.ship_to_org_id(k) := l_line_tbl(i).ship_to_org_id;
1801 l_line_acks_rec.invoice_to_org_id(k) := l_line_tbl(i).invoice_to_org_id;
1802 l_line_acks_rec.invoice_to_contact_id(k) := l_line_tbl(i).invoice_to_contact_id;
1803 l_line_acks_rec.ship_from_org_id(k) := l_line_tbl(i).ship_from_org_id;
1804 l_line_acks_rec.agreement_id(k) := l_line_tbl(i).agreement_id;
1805 l_line_acks_rec.price_list_id(k) := l_line_tbl(i).price_list_id;
1806 l_line_acks_rec.arrival_set_id(k) := l_line_tbl(i).arrival_set_id;
1807 l_line_acks_rec.accounting_rule_id(k) := l_line_tbl(i).accounting_rule_id;
1808 l_line_acks_rec.fulfillment_set_id(k) := l_line_tbl(i).fulfillment_set_id;
1809 --Added for bug 4309609 start
1810 begin
1811 l_validation_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',l_line_tbl(i).org_id);
1812 SELECT concatenated_segments
1813 INTO l_line_acks_rec.inventory_item(k)
1814 FROM mtl_system_items_vl
1815 WHERE inventory_item_id = l_line_tbl(i).inventory_item_id
1816 AND organization_id = l_validation_org_id;
1817 exception
1818 when others then
1819 null;
1820 end ;
1821 --Added for bug 4309609 end
1822 l_line_acks_rec.inventory_item_id(k) := l_line_tbl(i).inventory_item_id;
1823 l_line_acks_rec.invoicing_rule_id(k) := l_line_tbl(i).invoicing_rule_id;
1824 l_line_acks_rec.line_type_id(k) := l_line_tbl(i).line_type_id;
1825 l_line_acks_rec.order_source_id(k) := l_line_tbl(i).order_source_id;
1826 l_line_acks_rec.payment_term_id(k) := l_line_tbl(i).payment_term_id;
1827 l_line_acks_rec.project_id(k) := l_line_tbl(i).project_id;
1828 l_line_acks_rec.salesrep_id(k) := l_line_tbl(i).salesrep_id;
1829 l_line_acks_rec.ship_set_id(k) := l_line_tbl(i).ship_set_id;
1830 l_line_acks_rec.ship_to_contact_id(k) := l_line_tbl(i).ship_to_contact_id;
1831 l_line_acks_rec.task_id(k) := l_line_tbl(i).task_id;
1832 l_line_acks_rec.fob_point_code(k) := l_line_tbl(i).fob_point_code;
1833 l_line_acks_rec.freight_terms_code(k) := l_line_tbl(i).freight_terms_code;
1834 l_line_acks_rec.shipping_method_code(k) := l_line_tbl(i).shipping_method_code;
1835 l_line_acks_rec.tax_code(k) := l_line_tbl(i).tax_code;
1836 l_line_acks_rec.tax_point_code(k) := l_line_tbl(i).tax_point_code;
1837 l_line_acks_rec.tax_exempt_reason_code(k) := l_line_tbl(i).tax_exempt_reason_code;
1838 l_line_acks_rec.first_ack_code(k) := l_line_tbl(i).first_ack_code;
1839
1840 l_line_acks_rec.accounting_rule_duration(k) := l_line_tbl(i).accounting_rule_duration;
1841 l_line_acks_rec.actual_arrival_date(k) := l_line_tbl(i).actual_arrival_date;
1842 --
1843 l_line_acks_rec.actual_shipment_date(k) := l_line_tbl(i).actual_shipment_date;
1844 l_line_acks_rec.ato_line_id(k) := l_line_tbl(i).ato_line_id;
1845 l_line_acks_rec.authorized_to_ship_flag(k) := l_line_tbl(i).authorized_to_ship_flag;
1846 l_line_acks_rec.booked_flag(k) := l_line_tbl(i).booked_flag;
1847 l_line_acks_rec.cancelled_flag(k) := l_line_tbl(i).cancelled_flag;
1848 l_line_acks_rec.cancelled_quantity(k) := l_line_tbl(i).cancelled_quantity;
1849 l_line_acks_rec.change_sequence(k) := l_line_tbl(i).change_sequence;
1850 l_line_acks_rec.component_code(k) := l_line_tbl(i).component_code;
1851 l_line_acks_rec.component_number(k) := l_line_tbl(i).component_number;
1852 l_line_acks_rec.component_sequence_id(k) := l_line_tbl(i).component_sequence_id;
1853 l_line_acks_rec.config_display_sequence(k) := l_line_tbl(i).config_display_sequence;
1854 l_line_acks_rec.configuration_id(k) := l_line_tbl(i).configuration_id;
1855 l_line_acks_rec.top_model_line_id(k) := l_line_tbl(i).top_model_line_id;
1856 l_line_acks_rec.created_by(k) := l_line_tbl(i).created_by;
1857 l_line_acks_rec.creation_date(k) := l_line_tbl(i).creation_date;
1858 l_line_acks_rec.cust_model_serial_number(k) := l_line_tbl(i).cust_model_serial_number;
1859 l_line_acks_rec.cust_po_number(k) := l_line_tbl(i).cust_po_number;
1860 l_line_acks_rec.cust_production_seq_num(k) := l_line_tbl(i).cust_production_seq_num;
1861 l_line_acks_rec.customer_dock_code(k) := l_line_tbl(i).customer_dock_code;
1862 l_line_acks_rec.ordered_item(k) := l_line_tbl(i).ordered_item;
1863 l_line_acks_rec.ordered_item_id(k) := l_line_tbl(i).ordered_item_id; /* Bug # 4761560 */
1864 l_line_acks_rec.customer_job(k) := l_line_tbl(i).customer_job;
1865 --
1866 l_line_acks_rec.customer_production_line(k) := l_line_tbl(i).customer_production_line;
1867 l_line_acks_rec.customer_trx_line_id(k) := l_line_tbl(i).customer_trx_line_id;
1868 l_line_acks_rec.deliver_to_contact_id(k) := l_line_tbl(i).deliver_to_contact_id;
1869 l_line_acks_rec.deliver_to_org_id(k) := l_line_tbl(i).deliver_to_org_id;
1870 l_line_acks_rec.delivery_lead_time(k) := l_line_tbl(i).delivery_lead_time;
1871 l_line_acks_rec.demand_bucket_type_code(k) := l_line_tbl(i).demand_bucket_type_code;
1872 l_line_acks_rec.demand_class_code(k) := l_line_tbl(i).demand_class_code;
1873 l_line_acks_rec.dep_plan_required_flag(k) := l_line_tbl(i).dep_plan_required_flag;
1874 l_line_acks_rec.earliest_acceptable_date(k) := l_line_tbl(i).earliest_acceptable_date;
1875 l_line_acks_rec.explosion_date(k) := l_line_tbl(i).explosion_date;
1876 l_line_acks_rec.freight_carrier_code(k) := l_line_tbl(i).freight_carrier_code;
1877 l_line_acks_rec.fulfilled_quantity(k) := l_line_tbl(i).fulfilled_quantity;
1878 l_line_acks_rec.item_revision(k) := l_line_tbl(i).item_revision;
1879 l_line_acks_rec.item_identifier_type(k) := l_line_tbl(i).item_identifier_type;
1880 l_line_acks_rec.context(k) := l_line_tbl(i).context;
1881 l_line_acks_rec.first_ack_date(k) := l_line_tbl(i).first_ack_date;
1882 l_line_acks_rec.last_ack_code(k) := l_line_tbl(i).last_ack_code;
1883 l_line_acks_rec.last_ack_date(k) := l_line_tbl(i).last_ack_date;
1884
1885 l_line_acks_rec.last_update_date(k) := l_line_tbl(i).last_update_date;
1886 l_line_acks_rec.last_update_login(k) := l_line_tbl(i).last_update_login;
1887 l_line_acks_rec.last_updated_by(k) := l_line_tbl(i).last_updated_by;
1888 l_line_acks_rec.latest_acceptable_date(k) := l_line_tbl(i).latest_acceptable_date;
1889 l_line_acks_rec.line_category_code(k) := l_line_tbl(i).line_category_code;
1890 l_line_acks_rec.line_number(k) := l_line_tbl(i).line_number;
1891 l_line_acks_rec.link_to_line_id(k) := l_line_tbl(i).link_to_line_id;
1892 l_line_acks_rec.model_group_number(k) := l_line_tbl(i).model_group_number;
1893 l_line_acks_rec.open_flag(k) := l_line_tbl(i).open_flag;
1894 l_line_acks_rec.operation_code(k) := l_line_tbl(i).operation;
1895 l_line_acks_rec.option_flag(k) := l_line_tbl(i).option_flag;
1896 l_line_acks_rec.option_number(k) := l_line_tbl(i).option_number;
1897 l_line_acks_rec.order_quantity_uom(k) := l_line_tbl(i).order_quantity_uom;
1898 l_line_acks_rec.ordered_quantity(k) := l_line_tbl(i).ordered_quantity;
1899 l_line_acks_rec.org_id(k) := l_line_tbl(i).org_id;
1900 l_line_acks_rec.orig_sys_document_ref(k) := l_line_tbl(i).orig_sys_document_ref;
1901 l_line_acks_rec.orig_sys_line_ref(k) := l_line_tbl(i).orig_sys_line_ref;
1902 l_line_acks_rec.orig_sys_shipment_ref(k) := l_line_tbl(i).orig_sys_shipment_ref;
1903 --
1904 l_line_acks_rec.over_ship_reason_code(k) := l_line_tbl(i).over_ship_reason_code;
1905 l_line_acks_rec.over_ship_resolved_flag(k) := l_line_tbl(i).over_ship_resolved_flag;
1906 l_line_acks_rec.pricing_date(k) := l_line_tbl(i).pricing_date;
1907 l_line_acks_rec.pricing_quantity(k) := l_line_tbl(i).pricing_quantity;
1908 l_line_acks_rec.pricing_quantity_uom(k) := l_line_tbl(i).pricing_quantity_uom;
1909 l_line_acks_rec.program_application_id(k) := l_line_tbl(i).program_application_id;
1910 l_line_acks_rec.program_id(k) := l_line_tbl(i).program_id;
1911 l_line_acks_rec.program_update_date(k) := l_line_tbl(i).program_update_date;
1912 l_line_acks_rec.promise_date(k) := l_line_tbl(i).promise_date;
1913 l_line_acks_rec.reference_header_id(k) := l_line_tbl(i).reference_header_id;
1914 l_line_acks_rec.reference_line_id(k) := l_line_tbl(i).reference_line_id;
1915 l_line_acks_rec.reference_type(k) := l_line_tbl(i).reference_type;
1916 l_line_acks_rec.request_date(k) := l_line_tbl(i).request_date;
1917 l_line_acks_rec.request_id(k) := l_line_tbl(i).request_id;
1918 l_line_acks_rec.reserved_quantity(k) := l_line_tbl(i).reserved_quantity;
1919 l_line_acks_rec.return_reason_code(k) := l_line_tbl(i).return_reason_code;
1920 l_line_acks_rec.rla_schedule_type_code(k) := l_line_tbl(i).rla_schedule_type_code;
1921 l_line_acks_rec.schedule_arrival_date(k) := l_line_tbl(i).schedule_arrival_date;
1922 l_line_acks_rec.schedule_ship_date(k) := l_line_tbl(i).schedule_ship_date;
1923 l_line_acks_rec.schedule_status_code(k) := l_line_tbl(i).schedule_status_code;
1924 l_line_acks_rec.ship_model_complete_flag(k) := l_line_tbl(i).ship_model_complete_flag;
1925 l_line_acks_rec.ship_tolerance_above(k) := l_line_tbl(i).ship_tolerance_above;
1926 l_line_acks_rec.ship_tolerance_below(k) := l_line_tbl(i).ship_tolerance_below;
1927 --
1928 l_line_acks_rec.shipment_number(k) := l_line_tbl(i).shipment_number;
1929 l_line_acks_rec.shipment_priority_code(k) := l_line_tbl(i).shipment_priority_code;
1930 l_line_acks_rec.shipped_quantity(k) := l_line_tbl(i).shipped_quantity;
1931 l_line_acks_rec.SHIPPING_METHOD_CODE(k) := l_line_tbl(i).SHIPPING_METHOD_CODE;
1932 l_line_acks_rec.SHIPPING_QUANTITY(k) := l_line_tbl(i).SHIPPING_QUANTITY;
1933 l_line_acks_rec.SHIPPING_QUANTITY_UOM(k) := l_line_tbl(i).SHIPPING_QUANTITY_UOM;
1934 l_line_acks_rec.SOLD_TO_ORG_ID(k) := l_line_tbl(i).SOLD_TO_ORG_ID;
1935 l_line_acks_rec.SORT_ORDER(k) := l_line_tbl(i).SORT_ORDER;
1936 l_line_acks_rec.SOURCE_DOCUMENT_ID(k) := l_line_tbl(i).SOURCE_DOCUMENT_ID;
1937 l_line_acks_rec.SOURCE_DOCUMENT_LINE_ID(k) := l_line_tbl(i).SOURCE_DOCUMENT_LINE_ID;
1938 l_line_acks_rec.SOURCE_DOCUMENT_TYPE_ID(k) := l_line_tbl(i).SOURCE_DOCUMENT_TYPE_ID;
1939 l_line_acks_rec.SOURCE_TYPE_CODE(k) := l_line_tbl(i).SOURCE_TYPE_CODE;
1940 l_line_acks_rec.SPLIT_FROM_LINE_ID(k) := l_line_tbl(i).SPLIT_FROM_LINE_ID;
1941 l_line_acks_rec.TAX_CODE(k) := l_line_tbl(i).TAX_CODE;
1942 l_line_acks_rec.TAX_DATE(k) := l_line_tbl(i).TAX_DATE;
1943 l_line_acks_rec.TAX_EXEMPT_FLAG(k) := l_line_tbl(i).TAX_EXEMPT_FLAG;
1944 l_line_acks_rec.TAX_EXEMPT_NUMBER(k) := l_line_tbl(i).TAX_EXEMPT_NUMBER;
1945 l_line_acks_rec.TAX_EXEMPT_REASON_CODE(k) := l_line_tbl(i).TAX_EXEMPT_REASON_CODE;
1946 l_line_acks_rec.TAX_POINT_CODE(k) := l_line_tbl(i).TAX_POINT_CODE;
1947 l_line_acks_rec.TAX_RATE(k) := l_line_tbl(i).TAX_RATE;
1948 l_line_acks_rec.TAX_VALUE(k) := l_line_tbl(i).TAX_VALUE;
1949 l_line_acks_rec.UNIT_LIST_PRICE(k) := l_line_tbl(i).UNIT_LIST_PRICE;
1950 l_line_acks_rec.UNIT_SELLING_PRICE(k) := l_line_tbl(i).UNIT_SELLING_PRICE;
1951 l_line_acks_rec.VEH_CUS_ITEM_CUM_KEY_ID(k) := l_line_tbl(i).VEH_CUS_ITEM_CUM_KEY_ID;
1952 l_line_acks_rec.VISIBLE_DEMAND_FLAG(k) := l_line_tbl(i).VISIBLE_DEMAND_FLAG;
1953 l_line_acks_rec.split_from_line_ref(k) := l_line_tbl(i).split_from_line_ref;
1954 l_line_acks_rec.split_from_shipment_ref(k) := l_line_tbl(i).split_from_shipment_ref;
1955 l_line_acks_rec.Service_Txn_Reason_Code(k) := l_line_tbl(i).Service_Txn_Reason_Code;
1956 l_line_acks_rec.Service_Txn_Comments(k) := l_line_tbl(i).Service_Txn_Comments;
1957 l_line_acks_rec.Service_Duration(k) := l_line_tbl(i).Service_Duration;
1958 l_line_acks_rec.Service_Start_Date(k) := l_line_tbl(i).Service_Start_Date;
1959 l_line_acks_rec.Service_End_Date(k) := l_line_tbl(i).Service_End_Date;
1960 l_line_acks_rec.Service_Coterminate_Flag(k) := l_line_tbl(i).Service_Coterminate_Flag;
1961 l_line_acks_rec.Service_Number(k) := l_line_tbl(i).Service_Number;
1962 l_line_acks_rec.Service_Period(k) := l_line_tbl(i).Service_Period;
1963 l_line_acks_rec.Service_Reference_Type_Code(k) := l_line_tbl(i).Service_Reference_Type_Code;
1964 l_line_acks_rec.service_Reference_Line_Id(k) := l_line_tbl(i).service_Reference_Line_Id;
1965 l_line_acks_rec.Service_Reference_System_Id(k) := l_line_tbl(i).Service_Reference_System_Id;
1966 l_line_acks_rec.Credit_Invoice_Line_Id(k) := l_line_tbl(i).Credit_Invoice_Line_Id;
1967 l_line_acks_rec.service_reference_line(k) := l_line_tbl(i).service_reference_line;
1968 l_line_acks_rec.service_reference_order(k) := l_line_tbl(i).service_reference_order;
1969 l_line_acks_rec.service_reference_system(k) := l_line_tbl(i).service_reference_system;
1970 l_line_acks_rec.customer_line_number(k) := l_line_tbl(i).customer_line_number;
1971
1972 l_line_acks_rec.user_item_description(k) := l_line_tbl(i).user_item_description;
1973 --l_line_acks_rec.acknowledgment_type(k) := l_line_tbl(i).acknowledgment_type;
1974 l_line_acks_rec.blanket_number(k) := l_line_tbl(i).blanket_number;
1975 l_line_acks_rec.blanket_line_number(k) := l_line_tbl(i).blanket_line_number;
1976 l_line_acks_rec.original_inventory_item_id(k) := l_line_tbl(i).original_inventory_item_id;
1977 l_line_acks_rec.original_ordered_item_id(k) := l_line_tbl(i).original_ordered_item_id;
1978 l_line_acks_rec.original_ordered_item(k) := l_line_tbl(i).original_ordered_item;
1979 l_line_acks_rec.original_item_identifier_type(k) := l_line_tbl(i).original_item_identifier_type;
1980 l_line_acks_rec.item_relationship_type(k) := l_line_tbl(i).item_relationship_type;
1981 l_line_acks_rec.attribute1(k) := l_line_tbl(i).attribute1;
1982 l_line_acks_rec.attribute10(k) := l_line_tbl(i).attribute10;
1983 l_line_acks_rec.attribute11(k) := l_line_tbl(i).attribute11;
1984 l_line_acks_rec.attribute12(k) := l_line_tbl(i).attribute12;
1985 l_line_acks_rec.attribute13(k) := l_line_tbl(i).attribute13;
1986 l_line_acks_rec.attribute14(k) := l_line_tbl(i).attribute14;
1987 l_line_acks_rec.attribute15(k) := l_line_tbl(i).attribute15;
1988 l_line_acks_rec.attribute16(k) := l_line_tbl(i).attribute16;
1989 l_line_acks_rec.attribute17(k) := l_line_tbl(i).attribute17;
1990 l_line_acks_rec.attribute18(k) := l_line_tbl(i).attribute18;
1991 l_line_acks_rec.attribute19(k) := l_line_tbl(i).attribute19;
1992 l_line_acks_rec.attribute2(k) := l_line_tbl(i).attribute2;
1993 l_line_acks_rec.attribute20(k) := l_line_tbl(i).attribute20;
1994 l_line_acks_rec.attribute3(k) := l_line_tbl(i).attribute3;
1995 l_line_acks_rec.attribute4(k) := l_line_tbl(i).attribute4;
1996 l_line_acks_rec.attribute5(k) := l_line_tbl(i).attribute5;
1997 l_line_acks_rec.attribute6(k) := l_line_tbl(i).attribute6;
1998 l_line_acks_rec.attribute7(k) := l_line_tbl(i).attribute7;
1999 l_line_acks_rec.attribute8(k) := l_line_tbl(i).attribute8;
2000 l_line_acks_rec.attribute9(k) := l_line_tbl(i).attribute9;
2001 l_line_acks_rec.global_attribute1(k) := l_line_tbl(i).global_attribute1;
2002 l_line_acks_rec.global_attribute10(k) := l_line_tbl(i).global_attribute10;
2003 l_line_acks_rec.global_attribute11(k) := l_line_tbl(i).global_attribute11;
2004 l_line_acks_rec.global_attribute12(k) := l_line_tbl(i).global_attribute12;
2005 l_line_acks_rec.global_attribute13(k) := l_line_tbl(i).global_attribute13;
2006 l_line_acks_rec.global_attribute14(k) := l_line_tbl(i).global_attribute14;
2007 l_line_acks_rec.global_attribute15(k) := l_line_tbl(i).global_attribute15;
2008 l_line_acks_rec.global_attribute16(k) := l_line_tbl(i).global_attribute16;
2009 l_line_acks_rec.global_attribute17(k) := l_line_tbl(i).global_attribute17;
2010 l_line_acks_rec.global_attribute18(k) := l_line_tbl(i).global_attribute18;
2011 l_line_acks_rec.global_attribute19(k) := l_line_tbl(i).global_attribute19;
2012 l_line_acks_rec.global_attribute2(k) := l_line_tbl(i).global_attribute2;
2013 l_line_acks_rec.global_attribute20(k) := l_line_tbl(i).global_attribute20;
2014 l_line_acks_rec.global_attribute3(k) := l_line_tbl(i).global_attribute3;
2015 l_line_acks_rec.global_attribute4(k) := l_line_tbl(i).global_attribute4;
2016 l_line_acks_rec.global_attribute5(k) := l_line_tbl(i).global_attribute5;
2017 l_line_acks_rec.global_attribute6(k) := l_line_tbl(i).global_attribute6;
2018 l_line_acks_rec.global_attribute7(k) := l_line_tbl(i).global_attribute7;
2019 l_line_acks_rec.global_attribute8(k) := l_line_tbl(i).global_attribute8;
2020 l_line_acks_rec.global_attribute9(k) := l_line_tbl(i).global_attribute9;
2021 l_line_acks_rec.global_attribute_category(k) := l_line_tbl(i).global_attribute_category;
2022
2023 l_line_acks_rec.industry_attribute1(k) := l_line_tbl(i).industry_attribute1;
2024 l_line_acks_rec.industry_attribute10(k) := l_line_tbl(i).industry_attribute10;
2025 l_line_acks_rec.industry_attribute11(k) := l_line_tbl(i).industry_attribute11;
2026 l_line_acks_rec.industry_attribute12(k) := l_line_tbl(i).industry_attribute12;
2027 l_line_acks_rec.industry_attribute13(k) := l_line_tbl(i).industry_attribute13;
2028 l_line_acks_rec.industry_attribute14(k) := l_line_tbl(i).industry_attribute14;
2029 l_line_acks_rec.industry_attribute15(k) := l_line_tbl(i).industry_attribute15;
2030 l_line_acks_rec.industry_attribute16(k) := l_line_tbl(i).industry_attribute16;
2031 l_line_acks_rec.industry_attribute17(k) := l_line_tbl(i).industry_attribute17;
2032 l_line_acks_rec.industry_attribute18(k) := l_line_tbl(i).industry_attribute18;
2033 l_line_acks_rec.industry_attribute19(k) := l_line_tbl(i).industry_attribute19;
2034 l_line_acks_rec.industry_attribute20(k) := l_line_tbl(i).industry_attribute20;
2035 l_line_acks_rec.industry_attribute21(k) := l_line_tbl(i).industry_attribute21;
2036 l_line_acks_rec.industry_attribute22(k) := l_line_tbl(i).industry_attribute22;
2037 l_line_acks_rec.industry_attribute23(k) := l_line_tbl(i).industry_attribute23;
2038 l_line_acks_rec.industry_attribute24(k) := l_line_tbl(i).industry_attribute24;
2039 l_line_acks_rec.industry_attribute25(k) := l_line_tbl(i).industry_attribute25;
2040 l_line_acks_rec.industry_attribute26(k) := l_line_tbl(i).industry_attribute26;
2041 l_line_acks_rec.industry_attribute27(k) := l_line_tbl(i).industry_attribute27;
2042 l_line_acks_rec.industry_attribute28(k) := l_line_tbl(i).industry_attribute28;
2043 l_line_acks_rec.industry_attribute29(k) := l_line_tbl(i).industry_attribute29;
2044 l_line_acks_rec.industry_attribute30(k) := l_line_tbl(i).industry_attribute30;
2045 l_line_acks_rec.industry_attribute2(k) := l_line_tbl(i).industry_attribute2;
2046 l_line_acks_rec.industry_attribute3(k) := l_line_tbl(i).industry_attribute3;
2047 l_line_acks_rec.industry_attribute4(k) := l_line_tbl(i).industry_attribute4;
2048 l_line_acks_rec.industry_attribute5(k) := l_line_tbl(i).industry_attribute5;
2049 l_line_acks_rec.industry_attribute6(k) := l_line_tbl(i).industry_attribute6;
2050 l_line_acks_rec.industry_attribute7(k) := l_line_tbl(i).industry_attribute7;
2051 l_line_acks_rec.industry_attribute8(k) := l_line_tbl(i).industry_attribute8;
2052 l_line_acks_rec.industry_attribute9(k) := l_line_tbl(i).industry_attribute9;
2053 l_line_acks_rec.industry_context(k) := l_line_tbl(i).industry_context;
2054 l_line_acks_rec.TP_CONTEXT(k) := l_line_tbl(i).TP_CONTEXT;
2055 l_line_acks_rec.TP_ATTRIBUTE1(k) := l_line_tbl(i).TP_ATTRIBUTE1;
2056 l_line_acks_rec.TP_ATTRIBUTE2(k) := l_line_tbl(i).TP_ATTRIBUTE2;
2057 l_line_acks_rec.TP_ATTRIBUTE3(k) := l_line_tbl(i).TP_ATTRIBUTE3;
2058 l_line_acks_rec.TP_ATTRIBUTE4(k) := l_line_tbl(i).TP_ATTRIBUTE4;
2059 l_line_acks_rec.TP_ATTRIBUTE5(k) := l_line_tbl(i).TP_ATTRIBUTE5;
2060 l_line_acks_rec.TP_ATTRIBUTE6(k) := l_line_tbl(i).TP_ATTRIBUTE6;
2061 l_line_acks_rec.TP_ATTRIBUTE7(k) := l_line_tbl(i).TP_ATTRIBUTE7;
2062 l_line_acks_rec.TP_ATTRIBUTE8(k) := l_line_tbl(i).TP_ATTRIBUTE8;
2063 l_line_acks_rec.TP_ATTRIBUTE9(k) := l_line_tbl(i).TP_ATTRIBUTE9;
2064 l_line_acks_rec.TP_ATTRIBUTE10(k) := l_line_tbl(i).TP_ATTRIBUTE10;
2065 l_line_acks_rec.TP_ATTRIBUTE11(k) := l_line_tbl(i).TP_ATTRIBUTE11;
2066 l_line_acks_rec.TP_ATTRIBUTE12(k) := l_line_tbl(i).TP_ATTRIBUTE12;
2067 l_line_acks_rec.TP_ATTRIBUTE13(k) := l_line_tbl(i).TP_ATTRIBUTE13;
2068 l_line_acks_rec.TP_ATTRIBUTE14(k) := l_line_tbl(i).TP_ATTRIBUTE14;
2069 l_line_acks_rec.TP_ATTRIBUTE15(k) := l_line_tbl(i).TP_ATTRIBUTE15;
2070 l_line_acks_rec.pricing_attribute1(k) := l_line_tbl(i).pricing_attribute1;
2071 l_line_acks_rec.pricing_attribute10(k) := l_line_tbl(i).pricing_attribute10;
2072 l_line_acks_rec.pricing_attribute2(k) := l_line_tbl(i).pricing_attribute2;
2073 l_line_acks_rec.pricing_attribute3(k) := l_line_tbl(i).pricing_attribute3;
2074 l_line_acks_rec.pricing_attribute4(k) := l_line_tbl(i).pricing_attribute4;
2075 l_line_acks_rec.pricing_attribute5(k) := l_line_tbl(i).pricing_attribute5;
2076 l_line_acks_rec.pricing_attribute6(k) := l_line_tbl(i).pricing_attribute6;
2077 l_line_acks_rec.pricing_attribute7(k) := l_line_tbl(i).pricing_attribute7;
2078 l_line_acks_rec.pricing_attribute8(k) := l_line_tbl(i).pricing_attribute8;
2079 l_line_acks_rec.pricing_attribute9(k) := l_line_tbl(i).pricing_attribute9;
2080 l_line_acks_rec.pricing_context(k) := l_line_tbl(i).pricing_context;
2081 l_line_acks_rec.return_attribute1(k) := l_line_tbl(i).return_attribute1;
2082 l_line_acks_rec.return_attribute10(k) := l_line_tbl(i).return_attribute10;
2083 l_line_acks_rec.return_attribute11(k) := l_line_tbl(i).return_attribute11;
2084 l_line_acks_rec.return_attribute12(k) := l_line_tbl(i).return_attribute12;
2085 l_line_acks_rec.return_attribute13(k) := l_line_tbl(i).return_attribute13;
2086 l_line_acks_rec.return_attribute14(k) := l_line_tbl(i).return_attribute14;
2087 l_line_acks_rec.return_attribute15(k) := l_line_tbl(i).return_attribute15;
2088 l_line_acks_rec.return_attribute2(k) := l_line_tbl(i).return_attribute2;
2089 l_line_acks_rec.return_attribute3(k) := l_line_tbl(i).return_attribute3;
2090 l_line_acks_rec.return_attribute4(k) := l_line_tbl(i).return_attribute4;
2091 l_line_acks_rec.return_attribute5(k) := l_line_tbl(i).return_attribute5;
2092 l_line_acks_rec.return_attribute6(k) := l_line_tbl(i).return_attribute6;
2093 l_line_acks_rec.return_attribute7(k) := l_line_tbl(i).return_attribute7;
2094 l_line_acks_rec.return_attribute8(k) := l_line_tbl(i).return_attribute8;
2095 l_line_acks_rec.return_attribute9(k) := l_line_tbl(i).return_attribute9;
2096 l_line_acks_rec.return_context(k) := l_line_tbl(i).return_context;
2097 l_line_acks_rec.customer_shipment_number(k) := l_line_tbl(i).customer_shipment_number;
2098 -- { Distributer Order related change
2099 l_line_acks_rec.end_customer_id(k) := l_line_tbl(i).end_customer_id;
2100 l_line_acks_rec.end_customer_contact_id(k) := l_line_tbl(i).end_customer_contact_id;
2101 l_line_acks_rec.end_customer_site_use_id(k) := l_line_tbl(i).end_customer_site_use_id;
2102 l_line_acks_rec.ib_owner(k) := l_line_tbl(i).ib_owner;
2103 l_line_acks_rec.ib_current_location(k) := l_line_tbl(i).ib_current_location;
2104 l_line_acks_rec.ib_installed_at_location(k) := l_line_tbl(i).ib_installed_at_location;
2105 -- Distributer Order related change }
2106 l_line_acks_rec.charge_periodicity_code(k) := l_line_tbl(i).charge_periodicity_code;
2107
2108 <<nextline>>
2109 Exit When i = l_line_tbl.count;
2110 i := l_line_tbl.Next(i);
2111
2112 End Loop;
2113
2114 If l_count > 0 Then
2115 --Added for bug4730258 start
2116 FORALL y in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2117 DELETE FROM OE_LINE_ACKS
2118 WHERE HEADER_ID = l_line_acks_rec.header_id(y)
2119 AND LINE_ID = l_line_acks_rec.line_id(y)
2120 AND ACKNOWLEDGMENT_FLAG is null
2121 -- Change this condition once a type is inserted for POAO/POCAO
2122 AND nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
2123 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2124 = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;
2125 --Added for bug4730258 end
2126 FORALL j in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2127 Insert Into Oe_Line_Acks
2128 (
2129 ACCOUNTING_RULE_ID
2130 ,ACCOUNTING_RULE_DURATION
2131 ,ACKNOWLEDGMENT_FLAG
2132 ,ACTUAL_ARRIVAL_DATE
2133 ,ACTUAL_SHIPMENT_DATE
2134 ,AGREEMENT_ID
2135 ,ARRIVAL_SET_ID
2136 /*
2137 ,ATO_LINE_ID
2138 */
2139 ,ATTRIBUTE1
2140 ,ATTRIBUTE10
2141 ,ATTRIBUTE11
2142 ,ATTRIBUTE12
2143 ,ATTRIBUTE13
2144 ,ATTRIBUTE14
2145 ,ATTRIBUTE15
2146 ,ATTRIBUTE16 --For bug 2184255
2147 ,ATTRIBUTE17
2148 ,ATTRIBUTE18
2149 ,ATTRIBUTE19
2150 ,ATTRIBUTE2
2151 ,ATTRIBUTE20
2152 ,ATTRIBUTE3
2153 ,ATTRIBUTE4
2154 ,ATTRIBUTE5
2155 ,ATTRIBUTE6
2156 ,ATTRIBUTE7
2157 ,ATTRIBUTE8
2158 ,ATTRIBUTE9
2159 /*
2160 ,AUTHORIZED_TO_SHIP_FLAG
2161 ,BUYER_SELLER_FLAG
2162 */
2163 ,BOOKED_FLAG
2164 ,CANCELLED_FLAG
2165 ,CANCELLED_QUANTITY
2166 ,CHANGE_DATE
2167 ,CHANGE_SEQUENCE
2168 ,COMPONENT_CODE
2169 ,COMPONENT_NUMBER
2170 ,COMPONENT_SEQUENCE_ID
2171 ,CONFIG_DISPLAY_SEQUENCE
2172 ,CONFIGURATION_ID
2173 ,TOP_MODEL_LINE_ID
2174 ,CONTEXT
2175 ,CREATED_BY
2176 ,CREATION_DATE
2177 ,CUST_MODEL_SERIAL_NUMBER
2178 ,CUST_PO_NUMBER
2179 ,CUST_PRODUCTION_SEQ_NUM
2180 ,CUSTOMER_DOCK_CODE
2181 ,CUSTOMER_ITEM
2182 ,CUSTOMER_ITEM_ID /* Bug # 4761560 */
2183 ,CUSTOMER_JOB
2184 ,CUSTOMER_PRODUCTION_LINE
2185 ,CUSTOMER_TRX_LINE_ID
2186 ,DELIVER_TO_CONTACT_ID
2187 ,DELIVER_TO_ORG_ID
2188 ,DELIVERY_LEAD_TIME
2189 ,DEMAND_BUCKET_TYPE_CODE
2190 ,DEMAND_CLASS_CODE
2191 ,DEP_PLAN_REQUIRED_FLAG
2192 ,EARLIEST_ACCEPTABLE_DATE
2193 ,EXPLOSION_DATE
2194 ,FIRST_ACK_CODE
2195 ,FIRST_ACK_DATE
2196 ,FOB_POINT_CODE
2197 ,FREIGHT_CARRIER_CODE
2198 ,FREIGHT_TERMS_CODE
2199 ,FULFILLED_QUANTITY
2200 ,GLOBAL_ATTRIBUTE_CATEGORY
2201 ,GLOBAL_ATTRIBUTE1
2202 ,GLOBAL_ATTRIBUTE10
2203 ,GLOBAL_ATTRIBUTE11
2204 ,GLOBAL_ATTRIBUTE12
2205 ,GLOBAL_ATTRIBUTE13
2206 ,GLOBAL_ATTRIBUTE14
2207 ,GLOBAL_ATTRIBUTE15
2208 ,GLOBAL_ATTRIBUTE16
2209 ,GLOBAL_ATTRIBUTE17
2210 ,GLOBAL_ATTRIBUTE18
2211 ,GLOBAL_ATTRIBUTE19
2212 ,GLOBAL_ATTRIBUTE2
2213 ,GLOBAL_ATTRIBUTE20
2214 ,GLOBAL_ATTRIBUTE3
2215 ,GLOBAL_ATTRIBUTE4
2216 ,GLOBAL_ATTRIBUTE5
2217 ,GLOBAL_ATTRIBUTE6
2218 ,GLOBAL_ATTRIBUTE7
2219 ,GLOBAL_ATTRIBUTE8
2220 ,GLOBAL_ATTRIBUTE9
2221 ,HEADER_ID
2222 ,INDUSTRY_ATTRIBUTE1
2223 ,INDUSTRY_ATTRIBUTE10
2224 ,INDUSTRY_ATTRIBUTE11
2225 ,INDUSTRY_ATTRIBUTE12
2226 ,INDUSTRY_ATTRIBUTE13
2227 ,INDUSTRY_ATTRIBUTE14
2228 ,INDUSTRY_ATTRIBUTE15
2229 ,INDUSTRY_ATTRIBUTE16
2230 ,INDUSTRY_ATTRIBUTE17
2231 ,INDUSTRY_ATTRIBUTE18
2232 ,INDUSTRY_ATTRIBUTE19
2233 ,INDUSTRY_ATTRIBUTE2
2234 ,INDUSTRY_ATTRIBUTE20
2235 ,INDUSTRY_ATTRIBUTE21
2236 ,INDUSTRY_ATTRIBUTE22
2237 ,INDUSTRY_ATTRIBUTE23
2238 ,INDUSTRY_ATTRIBUTE24
2239 ,INDUSTRY_ATTRIBUTE25
2240 ,INDUSTRY_ATTRIBUTE26
2241 ,INDUSTRY_ATTRIBUTE27
2242 ,INDUSTRY_ATTRIBUTE28
2243 ,INDUSTRY_ATTRIBUTE29
2244 ,INDUSTRY_ATTRIBUTE3
2245 ,INDUSTRY_ATTRIBUTE30
2246 ,INDUSTRY_ATTRIBUTE4
2247 ,INDUSTRY_ATTRIBUTE5
2248 ,INDUSTRY_ATTRIBUTE6
2249 ,INDUSTRY_ATTRIBUTE7
2250 ,INDUSTRY_ATTRIBUTE8
2251 ,INDUSTRY_ATTRIBUTE9
2252 ,INDUSTRY_CONTEXT
2253 ,TP_CONTEXT
2254 ,TP_ATTRIBUTE1
2255 ,TP_ATTRIBUTE2
2256 ,TP_ATTRIBUTE3
2257 ,TP_ATTRIBUTE4
2258 ,TP_ATTRIBUTE5
2259 ,TP_ATTRIBUTE6
2260 ,TP_ATTRIBUTE7
2261 ,TP_ATTRIBUTE8
2262 ,TP_ATTRIBUTE9
2263 ,TP_ATTRIBUTE10
2264 ,TP_ATTRIBUTE11
2265 ,TP_ATTRIBUTE12
2266 ,TP_ATTRIBUTE13
2267 ,TP_ATTRIBUTE14
2268 ,TP_ATTRIBUTE15
2269 ,INVENTORY_ITEM --added for bug 4309609
2270 ,INVENTORY_ITEM_ID
2271 ,INVOICE_TO_CONTACT_ID
2272 ,INVOICE_TO_ORG_ID
2273 ,INVOICING_RULE_ID
2274 ,ITEM_INPUT
2275 ,ITEM_REVISION
2276 ,ITEM_TYPE_CODE
2277 ,LAST_ACK_CODE
2278 ,LAST_ACK_DATE
2279 ,LAST_UPDATE_DATE
2280 ,LAST_UPDATE_LOGIN
2281 ,LAST_UPDATED_BY
2282 ,LATEST_ACCEPTABLE_DATE
2283 ,LINE_CATEGORY_CODE
2284 ,LINE_ID
2285 ,LINE_NUMBER
2286 ,LINE_TYPE_ID
2287 ,LINK_TO_LINE_ID
2288 ,MODEL_GROUP_NUMBER
2289 ,OPEN_FLAG
2290 ,OPERATION_CODE
2291 ,OPTION_FLAG
2292 ,OPTION_NUMBER
2293 ,ORDER_QUANTITY_UOM
2294 ,ORDER_SOURCE_ID
2295 ,ORDERED_QUANTITY
2296 ,ORG_ID
2297 ,ORIG_SYS_DOCUMENT_REF
2298 ,ORIG_SYS_LINE_REF
2299 ,ORIG_SYS_SHIPMENT_REF
2300 ,OVER_SHIP_REASON_CODE
2301 ,OVER_SHIP_RESOLVED_FLAG
2302 ,PAYMENT_TERM_ID
2303 ,PRICE_LIST_ID
2304 ,PRICING_ATTRIBUTE1
2305 ,PRICING_ATTRIBUTE10
2306 ,PRICING_ATTRIBUTE2
2307 ,PRICING_ATTRIBUTE3
2308 ,PRICING_ATTRIBUTE4
2309 ,PRICING_ATTRIBUTE5
2310 ,PRICING_ATTRIBUTE6
2311 ,PRICING_ATTRIBUTE7
2312 ,PRICING_ATTRIBUTE8
2313 ,PRICING_ATTRIBUTE9
2314 ,PRICING_CONTEXT
2315 ,PRICING_DATE
2316 ,PRICING_QUANTITY
2317 ,PRICING_QUANTITY_UOM
2318 ,PROGRAM_APPLICATION_ID
2319 ,PROGRAM_ID
2320 ,PROGRAM_UPDATE_DATE
2321 ,PROJECT_ID
2322 ,PROMISE_DATE
2323 ,REFERENCE_HEADER_ID
2324 ,REFERENCE_LINE_ID
2325 ,REFERENCE_TYPE
2326 ,REQUEST_DATE
2327 ,REQUEST_ID
2328 ,RESERVED_QUANTITY
2329 ,RETURN_ATTRIBUTE1
2330 ,RETURN_ATTRIBUTE10
2331 ,RETURN_ATTRIBUTE11
2332 ,RETURN_ATTRIBUTE12
2333 ,RETURN_ATTRIBUTE13
2334 ,RETURN_ATTRIBUTE14
2335 ,RETURN_ATTRIBUTE15
2336 ,RETURN_ATTRIBUTE2
2337 ,RETURN_ATTRIBUTE3
2338 ,RETURN_ATTRIBUTE4
2339 ,RETURN_ATTRIBUTE5
2340 ,RETURN_ATTRIBUTE6
2341 ,RETURN_ATTRIBUTE7
2342 ,RETURN_ATTRIBUTE8
2343 ,RETURN_ATTRIBUTE9
2344 ,RETURN_CONTEXT
2345 ,RETURN_REASON_CODE
2346 ,RLA_SCHEDULE_TYPE_CODE
2347 ,SALESREP_ID
2348 ,SCHEDULE_ARRIVAL_DATE
2349 ,SCHEDULE_SHIP_DATE
2350 ,SCHEDULE_STATUS_CODE
2351 ,SHIP_FROM_ORG_ID
2352 ,SHIP_MODEL_COMPLETE_FLAG
2353 ,SHIP_SET_ID
2354 ,SHIP_TO_CONTACT_ID
2355 ,SHIP_TO_ORG_ID
2356 ,SHIP_TOLERANCE_ABOVE
2357 ,SHIP_TOLERANCE_BELOW
2358 ,SHIPMENT_NUMBER
2359 ,SHIPMENT_PRIORITY_CODE
2360 ,SHIPPED_QUANTITY
2361 ,SHIPPING_METHOD_CODE
2362 ,SHIPPING_QUANTITY
2363 ,SHIPPING_QUANTITY_UOM
2364 ,SOLD_TO_ORG_ID
2365 ,SORT_ORDER
2366 ,SOURCE_DOCUMENT_ID
2367 ,SOURCE_DOCUMENT_LINE_ID
2368 ,SOURCE_DOCUMENT_TYPE_ID
2369 ,SOURCE_TYPE_CODE
2370 ,SPLIT_FROM_LINE_ID
2371 ,TASK_ID
2372 ,TAX_CODE
2373 ,TAX_DATE
2374 ,TAX_EXEMPT_FLAG
2375 ,TAX_EXEMPT_NUMBER
2376 ,TAX_EXEMPT_REASON_CODE
2377 ,TAX_POINT_CODE
2378 ,TAX_RATE
2379 ,TAX_VALUE
2380 ,UNIT_LIST_PRICE
2381 ,UNIT_SELLING_PRICE
2382 ,VEH_CUS_ITEM_CUM_KEY_ID
2383 ,VISIBLE_DEMAND_FLAG
2384 ,split_from_line_ref
2385 ,split_from_shipment_ref
2386 ,Service_Txn_Reason_Code
2387 ,Service_Txn_Comments
2388 ,Service_Duration
2389 ,Service_Start_Date
2390 ,Service_End_Date
2391 ,Service_Coterminate_Flag
2392 ,Service_Number
2393 ,Service_Period
2394 ,Service_Reference_Type_Code
2395 ,Service_Reference_Line_Id
2396 ,Service_Reference_System_Id
2397 ,Credit_Invoice_Line_Id
2398 ,service_reference_line
2399 ,service_reference_order
2400 ,service_reference_system
2401 ,customer_line_number
2402 ,user_item_description
2403 ,acknowledgment_type
2404 ,blanket_number
2405 ,blanket_line_number
2406 ,original_inventory_item_id
2407 ,original_ordered_item_id
2408 ,original_ordered_item
2409 ,original_item_identifier_type
2410 ,item_relationship_type
2411 ,customer_shipment_number
2412 -- { Distributer Order related change
2413 ,end_customer_id
2414 ,end_customer_contact_id
2415 ,end_customer_site_use_id
2416 ,ib_owner
2417 ,ib_current_location
2418 ,ib_installed_at_location
2419 -- Distributer Order related change }
2420 ,charge_periodicity_code
2421 )
2422 Values
2423 (
2424 l_line_acks_rec.ACCOUNTING_RULE_ID(j)
2425 , l_line_acks_rec.ACCOUNTING_RULE_DURATION(j)
2426 , '' -- ACKNOWLEDGMENT_FLAG
2427 , l_line_acks_rec.ACTUAL_ARRIVAL_DATE(j)
2428 , l_line_acks_rec.ACTUAL_SHIPMENT_DATE(j)
2429 , l_line_acks_rec.AGREEMENT_ID(j)
2430 , l_line_acks_rec.ARRIVAL_SET_ID(j)
2431 /*
2432 , l_line_acks_rec.ATO_LINE_ID
2433 */
2434 , l_line_acks_rec.ATTRIBUTE1(j)
2435 , l_line_acks_rec.ATTRIBUTE10(j)
2436 , l_line_acks_rec.ATTRIBUTE11(j)
2437 , l_line_acks_rec.ATTRIBUTE12(j)
2438 , l_line_acks_rec.ATTRIBUTE13(j)
2439 , l_line_acks_rec.ATTRIBUTE14(j)
2440 , l_line_acks_rec.ATTRIBUTE15(j)
2441 , l_line_acks_rec.ATTRIBUTE16(j) --For bug 2184255
2442 , l_line_acks_rec.ATTRIBUTE17(j)
2443 , l_line_acks_rec.ATTRIBUTE18(j)
2444 , l_line_acks_rec.ATTRIBUTE19(j)
2445 , l_line_acks_rec.ATTRIBUTE2(j)
2446 , l_line_acks_rec.ATTRIBUTE20(j)
2447 , l_line_acks_rec.ATTRIBUTE3(j)
2448 , l_line_acks_rec.ATTRIBUTE4(j)
2449 , l_line_acks_rec.ATTRIBUTE5(j)
2450 , l_line_acks_rec.ATTRIBUTE6(j)
2451 , l_line_acks_rec.ATTRIBUTE7(j)
2452 , l_line_acks_rec.ATTRIBUTE8(j)
2453 , l_line_acks_rec.ATTRIBUTE9(j)
2454 /*
2455 , l_line_acks_rec.AUTHORIZED_TO_SHIP_FLAG
2456 , p_buyer_seller_flag
2457 */
2458 , l_line_acks_rec.BOOKED_FLAG(j)
2459 , l_line_acks_rec.CANCELLED_FLAG(j)
2460 , l_line_acks_rec.CANCELLED_QUANTITY(j)
2461 , '' -- CHANGE_DATE
2462 , l_line_acks_rec.CHANGE_SEQUENCE(j)
2463 , l_line_acks_rec.COMPONENT_CODE(j)
2464 , l_line_acks_rec.COMPONENT_NUMBER(j)
2465 , l_line_acks_rec.COMPONENT_SEQUENCE_ID(j)
2466 , l_line_acks_rec.CONFIG_DISPLAY_SEQUENCE(j)
2467 , l_line_acks_rec.CONFIGURATION_ID(j)
2468 , l_line_acks_rec.TOP_MODEL_LINE_ID(j)
2469 , l_line_acks_rec.CONTEXT(j)
2470 , l_line_acks_rec.CREATED_BY(j)
2471 , l_line_acks_rec.CREATION_DATE(j)
2472 , l_line_acks_rec.CUST_MODEL_SERIAL_NUMBER(j)
2473 , l_line_acks_rec.CUST_PO_NUMBER(j)
2474 , l_line_acks_rec.CUST_PRODUCTION_SEQ_NUM(j)
2475 , l_line_acks_rec.CUSTOMER_DOCK_CODE(j)
2476 , l_line_acks_rec.ORDERED_ITEM(j)
2477 , l_line_acks_rec.ORDERED_ITEM_ID(j) /* Bug # 4761560 */
2478 , l_line_acks_rec.CUSTOMER_JOB(j)
2479 , l_line_acks_rec.CUSTOMER_PRODUCTION_LINE(j)
2480 , l_line_acks_rec.CUSTOMER_TRX_LINE_ID(j)
2481 , l_line_acks_rec.DELIVER_TO_CONTACT_ID(j)
2482 , l_line_acks_rec.DELIVER_TO_ORG_ID(j)
2483 , l_line_acks_rec.DELIVERY_LEAD_TIME(j)
2484 , l_line_acks_rec.DEMAND_BUCKET_TYPE_CODE(j)
2485 , l_line_acks_rec.DEMAND_CLASS_CODE(j)
2486 , l_line_acks_rec.DEP_PLAN_REQUIRED_FLAG(j)
2487 , l_line_acks_rec.EARLIEST_ACCEPTABLE_DATE(j)
2488 , l_line_acks_rec.EXPLOSION_DATE(j)
2489 , l_line_acks_rec.FIRST_ACK_CODE(j)
2490 , l_line_acks_rec.FIRST_ACK_DATE(j)
2491 , l_line_acks_rec.FOB_POINT_CODE(j)
2492 , l_line_acks_rec.FREIGHT_CARRIER_CODE(j)
2493 , l_line_acks_rec.FREIGHT_TERMS_CODE(j)
2494 , l_line_acks_rec.FULFILLED_QUANTITY(j)
2495 , l_line_acks_rec.GLOBAL_ATTRIBUTE_CATEGORY(j)
2496 , l_line_acks_rec.GLOBAL_ATTRIBUTE1(j)
2497 , l_line_acks_rec.GLOBAL_ATTRIBUTE10(j)
2498 , l_line_acks_rec.GLOBAL_ATTRIBUTE11(j)
2499 , l_line_acks_rec.GLOBAL_ATTRIBUTE12(j)
2500 , l_line_acks_rec.GLOBAL_ATTRIBUTE13(j)
2501 , l_line_acks_rec.GLOBAL_ATTRIBUTE14(j)
2502 , l_line_acks_rec.GLOBAL_ATTRIBUTE15(j)
2503 , l_line_acks_rec.GLOBAL_ATTRIBUTE16(j)
2504 , l_line_acks_rec.GLOBAL_ATTRIBUTE17(j)
2505 , l_line_acks_rec.GLOBAL_ATTRIBUTE18(j)
2506 , l_line_acks_rec.GLOBAL_ATTRIBUTE19(j)
2507 , l_line_acks_rec.GLOBAL_ATTRIBUTE2(j)
2508 , l_line_acks_rec.GLOBAL_ATTRIBUTE20(j)
2509 , l_line_acks_rec.GLOBAL_ATTRIBUTE3(j)
2510 , l_line_acks_rec.GLOBAL_ATTRIBUTE4(j)
2511 , l_line_acks_rec.GLOBAL_ATTRIBUTE5(j)
2512 , l_line_acks_rec.GLOBAL_ATTRIBUTE6(j)
2513 , l_line_acks_rec.GLOBAL_ATTRIBUTE7(j)
2514 , l_line_acks_rec.GLOBAL_ATTRIBUTE8(j)
2515 , l_line_acks_rec.GLOBAL_ATTRIBUTE9(j)
2516 , l_line_acks_rec.HEADER_ID(j)
2517 , l_line_acks_rec.INDUSTRY_ATTRIBUTE1(j)
2518 , l_line_acks_rec.INDUSTRY_ATTRIBUTE10(j)
2519 , l_line_acks_rec.INDUSTRY_ATTRIBUTE11(j)
2520 , l_line_acks_rec.INDUSTRY_ATTRIBUTE12(j)
2521 , l_line_acks_rec.INDUSTRY_ATTRIBUTE13(j)
2522 , l_line_acks_rec.INDUSTRY_ATTRIBUTE14(j)
2523 , l_line_acks_rec.INDUSTRY_ATTRIBUTE15(j)
2524 , l_line_acks_rec.INDUSTRY_ATTRIBUTE16(j)
2525 , l_line_acks_rec.INDUSTRY_ATTRIBUTE17(j)
2526 , l_line_acks_rec.INDUSTRY_ATTRIBUTE18(j)
2527 , l_line_acks_rec.INDUSTRY_ATTRIBUTE19(j)
2528 , l_line_acks_rec.INDUSTRY_ATTRIBUTE2(j)
2529 , l_line_acks_rec.INDUSTRY_ATTRIBUTE20(j)
2530 , l_line_acks_rec.INDUSTRY_ATTRIBUTE21(j)
2531 , l_line_acks_rec.INDUSTRY_ATTRIBUTE22(j)
2532 , l_line_acks_rec.INDUSTRY_ATTRIBUTE23(j)
2533 , l_line_acks_rec.INDUSTRY_ATTRIBUTE24(j)
2534 , l_line_acks_rec.INDUSTRY_ATTRIBUTE25(j)
2535 , l_line_acks_rec.INDUSTRY_ATTRIBUTE26(j)
2536 , l_line_acks_rec.INDUSTRY_ATTRIBUTE27(j)
2537 , l_line_acks_rec.INDUSTRY_ATTRIBUTE28(j)
2538 , l_line_acks_rec.INDUSTRY_ATTRIBUTE29(j)
2539 , l_line_acks_rec.INDUSTRY_ATTRIBUTE3(j)
2540 , l_line_acks_rec.INDUSTRY_ATTRIBUTE30(j)
2541 , l_line_acks_rec.INDUSTRY_ATTRIBUTE4(j)
2542 , l_line_acks_rec.INDUSTRY_ATTRIBUTE5(j)
2543 , l_line_acks_rec.INDUSTRY_ATTRIBUTE6(j)
2544 , l_line_acks_rec.INDUSTRY_ATTRIBUTE7(j)
2545 , l_line_acks_rec.INDUSTRY_ATTRIBUTE8(j)
2546 , l_line_acks_rec.INDUSTRY_ATTRIBUTE9(j)
2547 , l_line_acks_rec.INDUSTRY_CONTEXT(j)
2548 , l_line_acks_rec.TP_CONTEXT(j)
2549 , l_line_acks_rec.TP_ATTRIBUTE1(j)
2550 , l_line_acks_rec.TP_ATTRIBUTE2(j)
2551 , l_line_acks_rec.TP_ATTRIBUTE3(j)
2552 , l_line_acks_rec.TP_ATTRIBUTE4(j)
2553 , l_line_acks_rec.TP_ATTRIBUTE5(j)
2554 , l_line_acks_rec.TP_ATTRIBUTE6(j)
2555 , l_line_acks_rec.TP_ATTRIBUTE7(j)
2556 , l_line_acks_rec.TP_ATTRIBUTE8(j)
2557 , l_line_acks_rec.TP_ATTRIBUTE9(j)
2558 , l_line_acks_rec.TP_ATTRIBUTE10(j)
2559 , l_line_acks_rec.TP_ATTRIBUTE11(j)
2560 , l_line_acks_rec.TP_ATTRIBUTE12(j)
2561 , l_line_acks_rec.TP_ATTRIBUTE13(j)
2562 , l_line_acks_rec.TP_ATTRIBUTE14(j)
2563 , l_line_acks_rec.TP_ATTRIBUTE15(j)
2564 , l_line_acks_rec.inventory_item(j) --added for bug4309609
2565 , l_line_acks_rec.INVENTORY_ITEM_ID(j)
2566 , l_line_acks_rec.INVOICE_TO_CONTACT_ID(j)
2567 , l_line_acks_rec.INVOICE_TO_ORG_ID(j)
2568 , l_line_acks_rec.INVOICING_RULE_ID(j)
2569 , l_line_acks_rec.ORDERED_ITEM(j)
2570 , l_line_acks_rec.ITEM_REVISION(j)
2571 , l_line_acks_rec.item_identifier_type(j)
2572 , l_line_acks_rec.LAST_ACK_CODE(j)
2573 , l_line_acks_rec.LAST_ACK_DATE(j)
2574 , l_line_acks_rec.LAST_UPDATE_DATE(j)
2575 , l_line_acks_rec.LAST_UPDATE_LOGIN(j)
2576 , l_line_acks_rec.LAST_UPDATED_BY(j)
2577 , l_line_acks_rec.LATEST_ACCEPTABLE_DATE(j)
2578 , l_line_acks_rec.LINE_CATEGORY_CODE(j)
2579 , l_line_acks_rec.LINE_ID(j)
2580 , l_line_acks_rec.LINE_NUMBER(j)
2581 , l_line_acks_rec.LINE_TYPE_ID(j)
2582 , l_line_acks_rec.LINK_TO_LINE_ID(j)
2583 , l_line_acks_rec.MODEL_GROUP_NUMBER(j)
2584 , l_line_acks_rec.OPEN_FLAG(j)
2585 , l_line_acks_rec.OPERATION_CODE(j)
2586 , l_line_acks_rec.OPTION_FLAG(j)
2587 , l_line_acks_rec.OPTION_NUMBER(j)
2588 , l_line_acks_rec.ORDER_QUANTITY_UOM(j)
2589 , l_line_acks_rec.ORDER_SOURCE_ID(j)
2590 , l_line_acks_rec.ORDERED_QUANTITY(j)
2591 , l_line_acks_rec.ORG_ID(j)
2592 , l_line_acks_rec.ORIG_SYS_DOCUMENT_REF(j)
2593 , l_line_acks_rec.ORIG_SYS_LINE_REF(j)
2594 , l_line_acks_rec.ORIG_SYS_SHIPMENT_REF(j)
2595 , l_line_acks_rec.OVER_SHIP_REASON_CODE(j)
2596 , l_line_acks_rec.OVER_SHIP_RESOLVED_FLAG(j)
2597 , l_line_acks_rec.PAYMENT_TERM_ID(j)
2598 , l_line_acks_rec.PRICE_LIST_ID(j)
2599 , l_line_acks_rec.PRICING_ATTRIBUTE1(j)
2600 , l_line_acks_rec.PRICING_ATTRIBUTE10(j)
2601 , l_line_acks_rec.PRICING_ATTRIBUTE2(j)
2602 , l_line_acks_rec.PRICING_ATTRIBUTE3(j)
2603 , l_line_acks_rec.PRICING_ATTRIBUTE4(j)
2604 , l_line_acks_rec.PRICING_ATTRIBUTE5(j)
2605 , l_line_acks_rec.PRICING_ATTRIBUTE6(j)
2606 , l_line_acks_rec.PRICING_ATTRIBUTE7(j)
2607 , l_line_acks_rec.PRICING_ATTRIBUTE8(j)
2608 , l_line_acks_rec.PRICING_ATTRIBUTE9(j)
2609 , l_line_acks_rec.PRICING_CONTEXT(j)
2610 , l_line_acks_rec.PRICING_DATE(j)
2611 , l_line_acks_rec.PRICING_QUANTITY(j)
2612 , l_line_acks_rec.PRICING_QUANTITY_UOM(j)
2613 , l_line_acks_rec.PROGRAM_APPLICATION_ID(j)
2614 , l_line_acks_rec.PROGRAM_ID(j)
2615 , l_line_acks_rec.PROGRAM_UPDATE_DATE(j)
2616 , l_line_acks_rec.PROJECT_ID(j)
2617 , l_line_acks_rec.PROMISE_DATE(j)
2618 , l_line_acks_rec.REFERENCE_HEADER_ID(j)
2619 , l_line_acks_rec.REFERENCE_LINE_ID(j)
2620 , l_line_acks_rec.REFERENCE_TYPE(j)
2621 , l_line_acks_rec.REQUEST_DATE(j)
2622 , l_line_acks_rec.REQUEST_ID(j)
2623 , l_line_acks_rec.RESERVED_QUANTITY(j)
2624 , l_line_acks_rec.RETURN_ATTRIBUTE1(j)
2625 , l_line_acks_rec.RETURN_ATTRIBUTE10(j)
2626 , l_line_acks_rec.RETURN_ATTRIBUTE11(j)
2627 , l_line_acks_rec.RETURN_ATTRIBUTE12(j)
2628 , l_line_acks_rec.RETURN_ATTRIBUTE13(j)
2629 , l_line_acks_rec.RETURN_ATTRIBUTE14(j)
2630 , l_line_acks_rec.RETURN_ATTRIBUTE15(j)
2631 , l_line_acks_rec.RETURN_ATTRIBUTE2(j)
2632 , l_line_acks_rec.RETURN_ATTRIBUTE3(j)
2633 , l_line_acks_rec.RETURN_ATTRIBUTE4(j)
2634 , l_line_acks_rec.RETURN_ATTRIBUTE5(j)
2635 , l_line_acks_rec.RETURN_ATTRIBUTE6(j)
2636 , l_line_acks_rec.RETURN_ATTRIBUTE7(j)
2637 , l_line_acks_rec.RETURN_ATTRIBUTE8(j)
2638 , l_line_acks_rec.RETURN_ATTRIBUTE9(j)
2639 , l_line_acks_rec.RETURN_CONTEXT(j)
2640 , l_line_acks_rec.RETURN_REASON_CODE(j)
2641 , l_line_acks_rec.RLA_SCHEDULE_TYPE_CODE(j)
2642 , l_line_acks_rec.SALESREP_ID(j)
2643 , l_line_acks_rec.SCHEDULE_ARRIVAL_DATE(j)
2644 , l_line_acks_rec.SCHEDULE_SHIP_DATE(j)
2645 , l_line_acks_rec.SCHEDULE_STATUS_CODE(j)
2646 , l_line_acks_rec.SHIP_FROM_ORG_ID(j)
2647 , l_line_acks_rec.SHIP_MODEL_COMPLETE_FLAG(j)
2648 , l_line_acks_rec.SHIP_SET_ID(j)
2649 , l_line_acks_rec.SHIP_TO_CONTACT_ID(j)
2650 , l_line_acks_rec.SHIP_TO_ORG_ID(j)
2651 , l_line_acks_rec.SHIP_TOLERANCE_ABOVE(j)
2652 , l_line_acks_rec.SHIP_TOLERANCE_BELOW(j)
2653 , l_line_acks_rec.SHIPMENT_NUMBER(j)
2654 , l_line_acks_rec.SHIPMENT_PRIORITY_CODE(j)
2655 , l_line_acks_rec.SHIPPED_QUANTITY(j)
2656 , l_line_acks_rec.SHIPPING_METHOD_CODE(j)
2657 , l_line_acks_rec.SHIPPING_QUANTITY(j)
2658 , l_line_acks_rec.SHIPPING_QUANTITY_UOM(j)
2659 , l_line_acks_rec.SOLD_TO_ORG_ID(j)
2660 , l_line_acks_rec.SORT_ORDER(j)
2661 , l_line_acks_rec.SOURCE_DOCUMENT_ID(j)
2662 , l_line_acks_rec.SOURCE_DOCUMENT_LINE_ID(j)
2663 , l_line_acks_rec.SOURCE_DOCUMENT_TYPE_ID(j)
2664 , l_line_acks_rec.SOURCE_TYPE_CODE(j)
2665 , l_line_acks_rec.SPLIT_FROM_LINE_ID(j)
2666 , l_line_acks_rec.TASK_ID(j)
2667 , l_line_acks_rec.TAX_CODE(j)
2668 , l_line_acks_rec.TAX_DATE(j)
2669 , l_line_acks_rec.TAX_EXEMPT_FLAG(j)
2670 , l_line_acks_rec.TAX_EXEMPT_NUMBER(j)
2671 , l_line_acks_rec.TAX_EXEMPT_REASON_CODE(j)
2672 , l_line_acks_rec.TAX_POINT_CODE(j)
2673 , l_line_acks_rec.TAX_RATE(j)
2674 , l_line_acks_rec.TAX_VALUE(j)
2675 , l_line_acks_rec.UNIT_LIST_PRICE(j)
2676 , l_line_acks_rec.UNIT_SELLING_PRICE(j)
2677 , l_line_acks_rec.VEH_CUS_ITEM_CUM_KEY_ID(j)
2678 , l_line_acks_rec.VISIBLE_DEMAND_FLAG(j)
2679 , l_line_acks_rec.split_from_line_ref(j)
2680 , l_line_acks_rec.split_from_shipment_ref(j)
2681 , l_line_acks_rec.Service_Txn_Reason_Code(j)
2682 , l_line_acks_rec.Service_Txn_Comments(j)
2683 , l_line_acks_rec.Service_Duration(j)
2684 , l_line_acks_rec.Service_Start_Date(j)
2685 , l_line_acks_rec.Service_End_Date(j)
2686 , l_line_acks_rec.Service_Coterminate_Flag(j)
2687 , l_line_acks_rec.Service_Number(j)
2688 , l_line_acks_rec.Service_Period(j)
2689 , l_line_acks_rec.Service_Reference_Type_Code(j)
2690 , l_line_acks_rec.Service_Reference_Line_Id(j)
2691 , l_line_acks_rec.Service_Reference_System_Id(j)
2692 , l_line_acks_rec.Credit_Invoice_Line_Id(j)
2693 , l_line_acks_rec.service_reference_line(j)
2694 , l_line_acks_rec.service_reference_order(j)
2695 , l_line_acks_rec.service_reference_system(j)
2696 , l_line_acks_rec.customer_line_number(j)
2697 , l_line_acks_rec.user_item_description(j)
2698 , l_ack_type
2699 , l_line_acks_rec.blanket_number(j)
2700 , l_line_acks_rec.blanket_line_number(j)
2701 , l_line_acks_rec.original_inventory_item_id(j)
2702 , l_line_acks_rec.original_ordered_item_id(j)
2703 , l_line_acks_rec.original_ordered_item(j)
2704 , l_line_acks_rec.original_item_identifier_type(j)
2705 , l_line_acks_rec.item_relationship_type(j)
2706 , l_line_acks_rec.customer_shipment_number(j)
2707 -- { Distributer Order related change
2708 , l_line_acks_rec.end_customer_id(j)
2709 , l_line_acks_rec.end_customer_contact_id(j)
2710 , l_line_acks_rec.end_customer_site_use_id(j)
2711 , l_line_acks_rec.ib_owner(j)
2712 , l_line_acks_rec.ib_current_location(j)
2713 , l_line_acks_rec.ib_installed_at_location(j)
2714 -- Distributer Order related change }
2715 , l_line_acks_rec.charge_periodicity_code(j)
2716 );
2717 End If;
2718
2719
2720 Exception
2721
2722 When Others Then
2723 If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
2724 FND_MSG_PUB.Add_Exc_Msg
2725 (G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row');
2726 End If;
2727
2728 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2729
2730
2731 End Insert_Row;
2732
2733
2734 PROCEDURE Delete_Row
2735 ( p_line_id IN NUMBER,
2736 p_ack_type IN Varchar2,
2737 p_orig_sys_document_ref In Varchar2,
2738 p_orig_sys_line_ref In Varchar2,
2739 p_orig_sys_shipment_ref In Varchar2,
2740 p_sold_to_org_id In NUMBER,
2741 p_sold_to_org In Varchar2,
2742 p_change_sequence In Varchar2,
2743 p_request_id In NUMBER,
2744 p_header_id In NUMBER
2745 )
2746 IS
2747 BEGIN
2748
2749 oe_debug_pub.add('Input Header ID: '|| p_header_id);
2750 oe_debug_pub.add('Input Line ID: '|| p_line_id);
2751 oe_debug_pub.add('Input Orig Sys Document Ref: '|| p_orig_sys_document_ref);
2752
2753 If (p_header_id is not null AND
2754 p_line_id is not null) Then
2755
2756 --request id is only used in where clause for 3a6
2757
2758 if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2759 Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2760 then
2761 DELETE FROM OE_LINE_ACKS
2762 WHERE HEADER_ID = p_header_id
2763 AND LINE_ID = p_line_id
2764 AND ACKNOWLEDGMENT_FLAG is null
2765 -- Change this condition once a type is inserted for POAO/POCAO
2766 AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2767 AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2768 = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2769 AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2770 = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2771 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2772 = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2773 AND request_id = p_request_id;
2774
2775 else
2776 DELETE FROM OE_LINE_ACKS
2777 WHERE HEADER_ID = p_header_id
2778 AND LINE_ID = p_line_id
2779 AND ACKNOWLEDGMENT_FLAG is null
2780 -- Change this condition once a type is inserted for POAO/POCAO
2781 AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2782 AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2783 = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2784 AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2785 = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2786 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2787 = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2788 end if;
2789 if sql%rowcount > 0 then
2790 oe_debug_pub.add('Row Deleted from the oe_line_Acks table');
2791 end If;
2792 Elsif (p_orig_sys_document_ref is not null) Then
2793 oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2794
2795 if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2796 Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2797 then
2798
2799 DELETE FROM OE_LINE_ACKS
2800 WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2801 AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2802 AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2803 AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2804 AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2805 = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2806 AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2807 = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2808 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2809 = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2810 AND REQUEST_ID = p_request_id;
2811
2812 else
2813
2814 DELETE FROM OE_LINE_ACKS
2815 WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2816 AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2817 AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2818 AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2819 AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2820 = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2821 AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2822 = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2823 AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2824 = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2825
2826
2827 end if;
2828
2829 if sql%rowcount > 0 then
2830 oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2831 end If;
2832 Else
2833 oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2834
2835 End If;
2836
2837
2838 EXCEPTION
2839
2840 WHEN OTHERS THEN
2841
2842 oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);
2843
2844 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845 THEN
2846 FND_MSG_PUB.Add_Exc_Msg
2847 (G_PKG_NAME, 'OE_Line_Ack_Util.Delete_Row');
2848 END IF;
2849
2850 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2851
2852 END Delete_Row;
2853
2854
2855
2856
2857
2858 END OE_Line_Ack_Util;