eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_ACK_UTIL dependencies on FND_API

Line 164: l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR) THEN -- It is 855

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';

Line 171: AND trunc(l_line_rec.SCHEDULE_SHIP_DATE) <> nvl(trunc(l_line_rec.REQUEST_DATE), FND_API.G_MISS_DATE)

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;

Line 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)

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);

Line 186: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

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:

Line 203: IF l_line_rec.FIRST_ACK_CODE IS NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

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;

Line 224: IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

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

Line 229: 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;

Line 247: IF l_line_rec.FIRST_ACK_CODE is NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR THEN

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);

Line 271: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(p_old_line_tbl(I).SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE)

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;

Line 272: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(l_line_rec.REQUEST_DATE, FND_API.G_MISS_DATE)

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

Line 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)

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);

Line 286: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

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:

Line 302: IF l_line_rec.LAST_ACK_CODE IS NULL or l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR Then

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;

Line 322: IF l_line_rec.LAST_ACK_CODE is NULL OR l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR 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)

Line 395: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 396: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 397: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

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;

Line 398: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)

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:

Line 399: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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:

Line 400: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)

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

Line 412: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 413: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)

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);

Line 414: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

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;

Line 415: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)

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

Line 416: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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');

Line 417: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);

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,

Line 450: IF l_line_rec.order_source_id <> FND_API.G_MISS_NUM

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

Line 454: AND l_line_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR

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

Line 456: AND l_line_rec.orig_sys_line_ref <> FND_API.G_MISS_CHAR

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

Line 460: -- OR (l_line_rec.line_id <> FND_API.G_MISS_NUM

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:

Line 479: AND l_line_rec.split_from_line_id <> FND_API.G_MISS_NUM

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);

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1645: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR) Then

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';

Line 1652: trunc (l_line_tbl(i).schedule_ship_date) <> nvl(trunc (l_line_tbl(i).Request_date),FND_API.G_MISS_DATE) Then

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

Line 1657: l_line_tbl(i).first_ack_code = FND_API.G_MISS_CHAR 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;

Line 1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

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';

Line 1688: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

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;

Line 1695: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

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;

Line 1711: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR 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;

Line 1730: l_line_tbl(i).schedule_ship_date <> nvl(p_old_line_tbl(I).schedule_ship_date,FND_API.G_MISS_DATE) And

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:

Line 1731: l_line_tbl(i).schedule_ship_date <> nvl(l_line_tbl(i).REQUEST_DATE, FND_API.G_MISS_DATE) 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

Line 1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

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';

Line 1754: l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then

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;

Line 1769: l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR 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 := '';

Line 1778: l_line_tbl(i).split_from_line_id <> FND_API.G_MISS_NUM Then

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

Line 2123: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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

Line 2124: = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;

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: (

Line 2728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 2767: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 2768: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 2769: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

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;

Line 2770: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

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:

Line 2771: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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

Line 2772: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

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

Line 2782: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 2783: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

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);

Line 2784: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

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;

Line 2785: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

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

Line 2786: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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');

Line 2787: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

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;

Line 2804: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 2805: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 2806: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

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;

Line 2807: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

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:

Line 2808: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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

Line 2809: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

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:

Line 2819: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

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)

Line 2820: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

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);

Line 2821: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

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:

Line 2822: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

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:

Line 2823: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

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;

Line 2824: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

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:

Line 2850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: