[Home] [Help]
PACKAGE BODY: APPS.OE_CNCL_UTIL
Source
1 PACKAGE BODY OE_CNCL_Util AS
2 /* $Header: OEXVCGIB.pls 120.3 2008/01/10 12:41:56 sgoli ship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Util';
7
8
9 PROCEDURE Get_Header_Ids
10 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
11 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
12 )
13 IS
14 l_sold_to_org_id NUMBER;
15 l_ship_to_org_id NUMBER;
16 l_invoice_to_org_id NUMBER;
17 l_deliver_to_org_id NUMBER;
18 --
19 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20 --
21 BEGIN
22 -- aksingh start on 08/07/2000
23 IF l_debug_level > 0 THEN
24 oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.GET_HEADER_IDS' , 1 ) ;
25 END IF;
26
27
28 IF p_header_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
29 THEN
30
31 IF p_x_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
32
33
34 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
35 THEN
36
37 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
38 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
39 OE_MSG_PUB.Add;
40
41 END IF;
42
43 ELSE
44
45 p_x_header_rec.accounting_rule_id :=
46 OE_CNCL_Value_To_Id.accounting_rule
47 ( p_accounting_rule => p_header_val_rec.accounting_rule
48 );
49
50 IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
51 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
52 END IF;
53
54 END IF;
55
56 END IF;
57
58 IF p_header_val_rec.agreement <> FND_API.G_MISS_CHAR
59 THEN
60
61 IF p_x_header_rec.agreement_id <> FND_API.G_MISS_NUM THEN
62
63
64
65 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
66 THEN
67
68 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
69 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
70 OE_MSG_PUB.Add;
71
72 END IF;
73
74 ELSE
75
76 p_x_header_rec.agreement_id := OE_CNCL_Value_To_Id.agreement
77 ( p_agreement => p_header_val_rec.agreement
78 );
79
80 IF p_x_header_rec.agreement_id = FND_API.G_MISS_NUM THEN
81 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
82 END IF;
83
84 END IF;
85
86 END IF;
87
88 IF p_header_val_rec.conversion_type <> FND_API.G_MISS_CHAR
89 THEN
90
91 IF p_x_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR THEN
92
93
94 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
95 THEN
96
97 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
98 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
99 OE_MSG_PUB.Add;
100
101 END IF;
102
103 ELSE
104
105 p_x_header_rec.conversion_type_code :=
106 OE_CNCL_Value_To_Id.conversion_type
107 ( p_conversion_type => p_header_val_rec.conversion_type
108 );
109
110 IF p_x_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN
111 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
112 END IF;
113
114 END IF;
115
116 END IF;
117
118 IF p_header_val_rec.fob_point <> FND_API.G_MISS_CHAR
119 THEN
120
121 IF p_x_header_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
122
123
124 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
125 THEN
126
127 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
128 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
129 OE_MSG_PUB.Add;
130
131 END IF;
132
133 ELSE
134
135 p_x_header_rec.fob_point_code := OE_CNCL_Value_To_Id.fob_point
136 ( p_fob_point => p_header_val_rec.fob_point
137 );
138
139 IF p_x_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN
140 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
141 END IF;
142
143 END IF;
144
145 END IF;
146
147 IF p_header_val_rec.freight_terms <> FND_API.G_MISS_CHAR
148 THEN
149
150 IF p_x_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
151
152
153 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
154 THEN
155
156 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
157 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
158 OE_MSG_PUB.Add;
159
160 END IF;
161
162 ELSE
163
164 p_x_header_rec.freight_terms_code :=
165 OE_CNCL_Value_To_Id.freight_terms
166 ( p_freight_terms => p_header_val_rec.freight_terms
167 );
168
169 IF p_x_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
170 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
171 END IF;
172
173 END IF;
174
175 END IF;
176
177 IF p_header_val_rec.shipping_method <> FND_API.G_MISS_CHAR
178 THEN
179
180 IF p_x_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
181
182
183 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
184 THEN
185
186 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
187 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
188 OE_MSG_PUB.Add;
189
190 END IF;
191
192 ELSE
193
194 p_x_header_rec.shipping_method_code := OE_CNCL_Value_To_Id.ship_method
195 ( p_ship_method => p_header_val_rec.shipping_method
196 );
197
198 IF p_x_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN
199 IF l_debug_level > 0 THEN
200 oe_debug_pub.add( 'SHIP METHOD CONVERSION ERROR' ) ;
201 END IF;
202 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
203 END IF;
204
205 END IF;
206
207 END IF;
208
209
210 IF p_header_val_rec.freight_carrier <> FND_API.G_MISS_CHAR
211 THEN
212
213 IF p_x_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
214
215
216 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
217 THEN
218
219 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
220 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
221 OE_MSG_PUB.Add;
222
223 END IF;
224
225 ELSE
226
227 p_x_header_rec.freight_carrier_code :=
228 OE_CNCL_Value_To_Id.freight_carrier
229 ( p_freight_carrier => p_header_val_rec.freight_carrier
230 , p_ship_from_org_id => p_x_header_rec.ship_from_org_id
231 );
232
233 IF p_x_header_rec.freight_carrier_code = FND_API.G_MISS_CHAR THEN
234 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
235 END IF;
236
237 END IF;
238
239 END IF;
240
241 IF p_header_val_rec.invoicing_rule <> FND_API.G_MISS_CHAR
242 THEN
243
244 IF p_x_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
245
246
247 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
248 THEN
249
250 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
251 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
252 OE_MSG_PUB.Add;
253
254 END IF;
255
256 ELSE
257
258 p_x_header_rec.invoicing_rule_id :=
259 OE_CNCL_Value_To_Id.invoicing_rule
260 ( p_invoicing_rule => p_header_val_rec.invoicing_rule
261 );
262
263 IF p_x_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
264 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
265 END IF;
266
267 END IF;
268
269 END IF;
270
271 IF p_header_val_rec.order_source <> FND_API.G_MISS_CHAR
272 THEN
273
274 IF p_x_header_rec.order_source_id <> FND_API.G_MISS_NUM THEN
275
276
277 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
278 THEN
279
280 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
281 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
282 OE_MSG_PUB.Add;
283
284 END IF;
285
286 ELSE
287
288 p_x_header_rec.order_source_id := OE_CNCL_Value_To_Id.order_source
289 ( p_order_source => p_header_val_rec.order_source
290 );
291
292 IF p_x_header_rec.order_source_id = FND_API.G_MISS_NUM THEN
293 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
294 END IF;
295
296 END IF;
297
298 END IF;
299
300 IF p_header_val_rec.order_type <> FND_API.G_MISS_CHAR
301 THEN
302
303 IF p_x_header_rec.order_type_id <> FND_API.G_MISS_NUM THEN
304
305
306 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
307 THEN
308
309 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
310 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
311 OE_MSG_PUB.Add;
312
313 END IF;
314
315 ELSE
316
317 p_x_header_rec.order_type_id := OE_CNCL_Value_To_Id.order_type
318 ( p_order_type => p_header_val_rec.order_type
319 );
320
321 IF p_x_header_rec.order_type_id = FND_API.G_MISS_NUM THEN
322 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
323 END IF;
324
325 END IF;
326
327 END IF;
328
329 IF p_header_val_rec.payment_term <> FND_API.G_MISS_CHAR
330 THEN
331
332 IF p_x_header_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
333
334
335 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
336 THEN
337
338 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
339 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
340 OE_MSG_PUB.Add;
341
342 END IF;
343
344 ELSE
345
346 p_x_header_rec.payment_term_id := OE_CNCL_Value_To_Id.payment_term
347 ( p_payment_term => p_header_val_rec.payment_term
348 );
349
350 IF p_x_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN
351 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
352 END IF;
353
354 END IF;
355
356 END IF;
357
358 IF p_header_val_rec.price_list <> FND_API.G_MISS_CHAR
359 THEN
360
361 IF p_x_header_rec.price_list_id <> FND_API.G_MISS_NUM THEN
362
363
364 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
365 THEN
366
367 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
368 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
369 OE_MSG_PUB.Add;
370
371 END IF;
372
373 ELSE
374
375 p_x_header_rec.price_list_id := OE_CNCL_Value_To_Id.price_list
376 ( p_price_list => p_header_val_rec.price_list
377 );
378
379 IF p_x_header_rec.price_list_id = FND_API.G_MISS_NUM THEN
380 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
381 END IF;
382
383 END IF;
384
385 END IF;
386
387 IF p_header_val_rec.return_reason <> FND_API.G_MISS_CHAR
388 THEN
389
390 IF p_x_header_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
391
392
393 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
394 THEN
395
396 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
397 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
398 OE_MSG_PUB.Add;
399
400 END IF;
401
402 ELSE
403
404 p_x_header_rec.return_reason_code :=
405 OE_CNCL_Value_To_Id.return_reason
406 ( p_return_reason => p_header_val_rec.return_reason
407 );
408
409 IF p_x_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN
410 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
411 END IF;
412
413 END IF;
414
415 END IF;
416
417 IF p_header_val_rec.salesrep <> FND_API.G_MISS_CHAR
418 THEN
419
420 IF p_x_header_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
421
422
423 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
424 THEN
425
426 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
427 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
428 OE_MSG_PUB.Add;
429
430 END IF;
431
432 ELSE
433
434 p_x_header_rec.salesrep_id := OE_CNCL_Value_To_Id.salesrep
435 ( p_salesrep => p_header_val_rec.salesrep
436 );
437 IF p_x_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN
438 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
439 END IF;
440
441 END IF;
442
443 END IF;
444
445
446 IF p_header_val_rec.sales_channel <> FND_API.G_MISS_CHAR
447 THEN
448
449 IF p_x_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR THEN
450
451
452 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
453 THEN
454
455 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
456 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
457 OE_MSG_PUB.Add;
458
459 END IF;
460
461 ELSE
462
463 p_x_header_rec.sales_channel_code :=
464 OE_CNCL_Value_To_Id.sales_channel
465 ( p_sales_channel => p_header_val_rec.sales_channel
466 );
467 IF p_x_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN
468 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
469 END IF;
470
471 END IF;
472
473 END IF;
474
475
476 IF p_header_val_rec.shipment_priority <> FND_API.G_MISS_CHAR
477 THEN
478
479 IF p_x_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
480
481
482 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
483 THEN
484
485 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
486 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
487 OE_MSG_PUB.Add;
488
489 END IF;
490
491 ELSE
492
493 p_x_header_rec.shipment_priority_code :=
494 OE_CNCL_Value_To_Id.shipment_priority
495 ( p_shipment_priority => p_header_val_rec.shipment_priority
496 );
497
498 IF p_x_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN
499 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
500 END IF;
501
502 END IF;
503
504 END IF;
505
506 -- aksingh This code is not yet build in the value_to_id procedure, I have to
507 -- write it to make it work
508 IF p_header_val_rec.ship_from_address1 <> FND_API.G_MISS_CHAR
509 OR p_header_val_rec.ship_from_address2 <> FND_API.G_MISS_CHAR
510 OR p_header_val_rec.ship_from_address3 <> FND_API.G_MISS_CHAR
511 OR p_header_val_rec.ship_from_address4 <> FND_API.G_MISS_CHAR
512 OR p_header_val_rec.ship_from_location <> FND_API.G_MISS_CHAR
513 OR p_header_val_rec.ship_from_org <> FND_API.G_MISS_CHAR
514 THEN
515
516 IF p_x_header_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
517
518
519 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
520 THEN
521
522 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
523 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
524 OE_MSG_PUB.Add;
525
526 END IF;
527
528 ELSE
529
530 p_x_header_rec.ship_from_org_id := OE_CNCL_Value_To_Id.ship_from_org
531 ( p_ship_from_address1 => p_header_val_rec.ship_from_address1
532 , p_ship_from_address2 => p_header_val_rec.ship_from_address2
533 , p_ship_from_address3 => p_header_val_rec.ship_from_address3
534 , p_ship_from_address4 => p_header_val_rec.ship_from_address4
535 , p_ship_from_location => p_header_val_rec.ship_from_location
536 , p_ship_from_org => p_header_val_rec.ship_from_org
537 );
538
539 IF p_x_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
540 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
541 END IF;
542
543 END IF;
544
545 END IF;
546
547 IF p_header_val_rec.tax_exempt <> FND_API.G_MISS_CHAR
548 THEN
549
550 IF p_x_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
551
552
553 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
554 THEN
555
556 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
557 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
558 OE_MSG_PUB.Add;
559
560 END IF;
561
562 ELSE
563
564 p_x_header_rec.tax_exempt_flag := OE_CNCL_Value_To_Id.tax_exempt
565 ( p_tax_exempt => p_header_val_rec.tax_exempt
566 );
567
568 IF p_x_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN
569 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
570 END IF;
571
572 END IF;
573
574 END IF;
575
576 IF p_header_val_rec.tax_exempt_reason <> FND_API.G_MISS_CHAR
577 THEN
578
579 IF p_x_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
580
581
582 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
583 THEN
584
585 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
586 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
587 OE_MSG_PUB.Add;
588
589 END IF;
590
591 ELSE
592
593 p_x_header_rec.tax_exempt_reason_code :=
594 OE_CNCL_Value_To_Id.tax_exempt_reason
595 ( p_tax_exempt_reason => p_header_val_rec.tax_exempt_reason
596 );
597
598 IF p_x_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN
599 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
600 END IF;
601
602 END IF;
603
604 END IF;
605
606 IF p_header_val_rec.tax_point <> FND_API.G_MISS_CHAR
607 THEN
608
609 IF p_x_header_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
610
611
612 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
613 THEN
614
615 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
616 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
617 OE_MSG_PUB.Add;
618
619 END IF;
620
621 ELSE
622
623 p_x_header_rec.tax_point_code := OE_CNCL_Value_To_Id.tax_point
624 ( p_tax_point => p_header_val_rec.tax_point
625 );
626
627 IF p_x_header_rec.tax_point_code = FND_API.G_MISS_CHAR THEN
628 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
629 END IF;
630
631 END IF;
632
633 END IF;
634
635 IF p_header_val_rec.payment_type <> FND_API.G_MISS_CHAR
636 THEN
637
638 IF p_x_header_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
639
640
641 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
642 THEN
643
644 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
645 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
646 OE_MSG_PUB.Add;
647
648 END IF;
649
650 ELSE
651
652 p_x_header_rec.payment_type_code :=
653 OE_CNCL_Value_To_Id.payment_type
654 ( p_payment_type => p_header_val_rec.payment_type
655 );
656
657 IF p_x_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
658 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
659 END IF;
660
661 END IF;
662
663 END IF;
664
665 IF p_header_val_rec.credit_card <> FND_API.G_MISS_CHAR
666 THEN
667
668 IF p_x_header_rec.credit_card_code <> FND_API.G_MISS_CHAR THEN
669
670
671 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
672 THEN
673
674 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
675 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
676 OE_MSG_PUB.Add;
677
678 END IF;
679
680 ELSE
681
682 p_x_header_rec.credit_card_code := OE_CNCL_Value_To_Id.credit_card
683 ( p_credit_card => p_header_val_rec.credit_card
684 );
685
686 IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
687 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
688 END IF;
689
690 END IF;
691
692 END IF;
693
694 ----------------------------------------------------------------------
695 -- For customer related fields, IDs should be retrieved in the
696 -- following order.
697 ----------------------------------------------------------------------
698
699 IF p_header_val_rec.sold_to_org <> FND_API.G_MISS_CHAR
700 OR p_header_val_rec.customer_number <> FND_API.G_MISS_CHAR
701 THEN
702
703 IF p_x_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
704
705
706 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
707 THEN
708
709 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
710 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
711 OE_MSG_PUB.Add;
712
713 END IF;
714
715 ELSE
716
717 p_x_header_rec.sold_to_org_id := OE_CNCL_Value_To_Id.sold_to_org
718 ( p_sold_to_org => p_header_val_rec.sold_to_org
719 , p_customer_number => p_header_val_rec.customer_number
720 );
721
722 IF p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
723 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
724 END IF;
725
726 END IF;
727
728 END IF;
729
730 -- Below IF is not required for CNCL but not removing for now.
731 -- Retrieve the sold_to_org_id if not passed on the header record. This
732 -- will be needed by the value_to_id functions for related fields.
733 -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
734
735 IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
736 AND p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
737 THEN
738
739 SELECT SOLD_TO_ORG_ID
740 INTO l_sold_to_org_id
741 FROM OE_ORDER_HEADERS
742 WHERE HEADER_ID = p_x_header_rec.header_id;
743
744 ELSE
745
746 l_sold_to_org_id := p_x_header_rec.sold_to_org_id;
747
748 END IF;
749
750 IF p_header_val_rec.sold_to_contact <> FND_API.G_MISS_CHAR
751 THEN
752
753 IF p_x_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM THEN
754
755
756 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
757 THEN
758
759 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
760 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
761 OE_MSG_PUB.Add;
762
763 END IF;
764
765 ELSE
766
767 p_x_header_rec.sold_to_contact_id :=
768 OE_CNCL_Value_To_Id.sold_to_contact
769 ( p_sold_to_contact => p_header_val_rec.sold_to_contact
770 , p_sold_to_org_id => l_sold_to_org_id
771 );
772
773 IF p_x_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN
774 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
775 END IF;
776
777 END IF;
778
779 END IF;
780
781 IF p_header_val_rec.deliver_to_address1 <> FND_API.G_MISS_CHAR
782 OR p_header_val_rec.deliver_to_address2 <> FND_API.G_MISS_CHAR
783 OR p_header_val_rec.deliver_to_address3 <> FND_API.G_MISS_CHAR
784 OR p_header_val_rec.deliver_to_address4 <> FND_API.G_MISS_CHAR
785 OR p_header_val_rec.deliver_to_location <> FND_API.G_MISS_CHAR
786 OR p_header_val_rec.deliver_to_org <> FND_API.G_MISS_CHAR
787 THEN
788
789 IF p_x_header_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
790
791
792 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
793 THEN
794
795 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
796 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
797 OE_MSG_PUB.Add;
798
799 END IF;
800
801 ELSE
802 /*1621182*/
803 p_x_header_rec.deliver_to_org_id :=
804 OE_CNCL_Value_To_Id.deliver_to_org
805 ( p_deliver_to_address1 => p_header_val_rec.deliver_to_address1
806 , p_deliver_to_address2 => p_header_val_rec.deliver_to_address2
807 , p_deliver_to_address3 => p_header_val_rec.deliver_to_address3
808 , p_deliver_to_address4 => p_header_val_rec.deliver_to_address4
809 , p_deliver_to_location => p_header_val_rec.deliver_to_location
810 , p_deliver_to_org => p_header_val_rec.deliver_to_org
811 , p_deliver_to_city => p_header_val_rec.deliver_to_city
812 , p_deliver_to_state => p_header_val_rec.deliver_to_state
813 , p_deliver_to_postal_code => p_header_val_rec.deliver_to_zip
814 , p_deliver_to_country => p_header_val_rec.deliver_to_country
815 , p_sold_to_org_id => l_sold_to_org_id
816 );
817 /*1621182*/
818
819 IF p_x_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN
820 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
821 END IF;
822
823 END IF;
824
825 END IF;
826
827 IF p_header_val_rec.invoice_to_address1 <> FND_API.G_MISS_CHAR
828 OR p_header_val_rec.invoice_to_address2 <> FND_API.G_MISS_CHAR
829 OR p_header_val_rec.invoice_to_address3 <> FND_API.G_MISS_CHAR
830 OR p_header_val_rec.invoice_to_address4 <> FND_API.G_MISS_CHAR
831 OR p_header_val_rec.invoice_to_location <> FND_API.G_MISS_CHAR
832 OR p_header_val_rec.invoice_to_org <> FND_API.G_MISS_CHAR
833 THEN
834
835 IF p_x_header_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
836
837
838 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
839 THEN
840
841 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
842 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
843 OE_MSG_PUB.Add;
844
845 END IF;
846
847 ELSE
848 /*1621182*/
849 p_x_header_rec.invoice_to_org_id :=
850 OE_CNCL_Value_To_Id.invoice_to_org
851 ( p_invoice_to_address1 => p_header_val_rec.invoice_to_address1
852 , p_invoice_to_address2 => p_header_val_rec.invoice_to_address2
853 , p_invoice_to_address3 => p_header_val_rec.invoice_to_address3
854 , p_invoice_to_address4 => p_header_val_rec.invoice_to_address4
855 , p_invoice_to_location => p_header_val_rec.invoice_to_location
856 , p_invoice_to_org => p_header_val_rec.invoice_to_org
857 , p_invoice_to_city => p_header_val_rec.invoice_to_city
858 , p_invoice_to_state => p_header_val_rec.invoice_to_state
859 , p_invoice_to_postal_code => p_header_val_rec.invoice_to_zip
860 , p_invoice_to_country => p_header_val_rec.invoice_to_country
861 , p_sold_to_org_id => l_sold_to_org_id
862 );
863 /*1621182*/
864
865 IF p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
866 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
867 END IF;
868
869 END IF;
870
871 END IF;
872
873 IF p_header_val_rec.ship_to_address1 <> FND_API.G_MISS_CHAR
874 OR p_header_val_rec.ship_to_address2 <> FND_API.G_MISS_CHAR
875 OR p_header_val_rec.ship_to_address3 <> FND_API.G_MISS_CHAR
876 OR p_header_val_rec.ship_to_address4 <> FND_API.G_MISS_CHAR
877 OR p_header_val_rec.ship_to_location <> FND_API.G_MISS_CHAR
878 OR p_header_val_rec.ship_to_org <> FND_API.G_MISS_CHAR
879 THEN
880
881 IF p_x_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
882
883
884 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
885 THEN
886
887 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
888 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
889 OE_MSG_PUB.Add;
890
891 END IF;
892
893 ELSE
894 /*1621182*/
895 p_x_header_rec.ship_to_org_id := OE_CNCL_Value_To_Id.ship_to_org
896 ( p_ship_to_address1 => p_header_val_rec.ship_to_address1
897 , p_ship_to_address2 => p_header_val_rec.ship_to_address2
898 , p_ship_to_address3 => p_header_val_rec.ship_to_address3
899 , p_ship_to_address4 => p_header_val_rec.ship_to_address4
900 , p_ship_to_location => p_header_val_rec.ship_to_location
901 , p_ship_to_org => p_header_val_rec.ship_to_org
902 , p_ship_to_city => p_header_val_rec.ship_to_city
903 , p_ship_to_state => p_header_val_rec.ship_to_state
904 , p_ship_to_postal_code => p_header_val_rec.ship_to_zip
905 , p_ship_to_country => p_header_val_rec.ship_to_country
906 , p_sold_to_org_id => l_sold_to_org_id
907 );
908
909 /*1621182*/
910 IF p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN
911 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
912 END IF;
913
914 END IF;
915
916 END IF;
917
918 IF p_header_val_rec.sold_to_location_address1 <> FND_API.G_MISS_CHAR
919 OR p_header_val_rec.sold_to_location_address2 <> FND_API.G_MISS_CHAR
920 OR p_header_val_rec.sold_to_location_address3 <> FND_API.G_MISS_CHAR
921 OR p_header_val_rec.sold_to_location_address4 <> FND_API.G_MISS_CHAR
922 OR p_header_val_rec.sold_to_location <> FND_API.G_MISS_CHAR
923 THEN
924
925 IF p_x_header_rec.sold_to_site_use_id <> FND_API.G_MISS_NUM THEN
926
927
928 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
929 THEN
930
931 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
932 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_site_use_id');
933 OE_MSG_PUB.Add;
934
935 END IF;
936
937 ELSE
938 p_x_header_rec.sold_to_site_use_id := OE_CNCL_Value_To_Id.Customer_Location
939 ( p_sold_to_location_address1 => p_header_val_rec.sold_to_location_address1
940 , p_sold_to_location_address2 => p_header_val_rec.sold_to_location_address2
941 , p_sold_to_location_address3 => p_header_val_rec.sold_to_location_address3
942 , p_sold_to_location_address4 => p_header_val_rec.sold_to_location_address4
943 , p_sold_to_location => p_header_val_rec.sold_to_location
944 , p_sold_to_location_city => p_header_val_rec.sold_to_location_city
945 , p_sold_to_location_state => p_header_val_rec.sold_to_location_state
946 , p_sold_to_location_postal => p_header_val_rec.sold_to_location_postal
947 , p_sold_to_location_country => p_header_val_rec.sold_to_location_country
948 , p_sold_to_org_id => l_sold_to_org_id
949 );
950
951 IF p_x_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN
952 IF l_debug_level > 0 THEN
953 oe_debug_pub.add( ' customer location error ') ;
954 END IF;
955 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
956 END IF;
957
958 END IF;
959
960 END IF;
961
962 l_sold_to_org_id := p_x_header_rec.sold_to_org_id;
963 l_invoice_to_org_id := p_x_header_rec.invoice_to_org_id;
964 l_deliver_to_org_id := p_x_header_rec.deliver_to_org_id;
965
966 IF p_header_val_rec.deliver_to_contact <> FND_API.G_MISS_CHAR
967 THEN
968
969 IF p_x_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
970
971
972 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
973 THEN
974
975 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
976 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
977 OE_MSG_PUB.Add;
978
979 END IF;
980
981 ELSE
982
983 p_x_header_rec.deliver_to_contact_id :=
984 OE_CNCL_Value_To_Id.deliver_to_contact
985 ( p_deliver_to_contact => p_header_val_rec.deliver_to_contact
986 , p_deliver_to_org_id => l_deliver_to_org_id
987 );
988
989 IF p_x_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN
990 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
991 END IF;
992
993 END IF;
994
995 END IF;
996
997 IF p_header_val_rec.invoice_to_contact <> FND_API.G_MISS_CHAR
998 THEN
999
1000 IF p_x_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
1001
1002
1003 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1004 THEN
1005
1006 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1007 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
1008 OE_MSG_PUB.Add;
1009
1010 END IF;
1011
1012 ELSE
1013
1014 p_x_header_rec.invoice_to_contact_id :=
1015 OE_CNCL_Value_To_Id.invoice_to_contact
1016 ( p_invoice_to_contact => p_header_val_rec.invoice_to_contact
1017 , p_invoice_to_org_id => l_invoice_to_org_id
1018 );
1019
1020 IF p_x_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN
1021 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1022 END IF;
1023
1024 END IF;
1025
1026 END IF;
1027
1028 IF p_header_val_rec.ship_to_contact <> FND_API.G_MISS_CHAR
1029 THEN
1030
1031 IF p_x_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
1032
1033
1034 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1035 THEN
1036
1037 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1038 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
1039 OE_MSG_PUB.Add;
1040
1041 END IF;
1042
1043 ELSE
1044
1045 p_x_header_rec.ship_to_contact_id :=
1046 OE_CNCL_Value_To_Id.ship_to_contact
1047 ( p_ship_to_contact => p_header_val_rec.ship_to_contact
1048 , p_ship_to_org_id => l_ship_to_org_id
1049 );
1050
1051 IF p_x_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN
1052 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1053 END IF;
1054
1055 END IF;
1056
1057 END IF;
1058
1059 --{ added for bug 4240715
1060 IF p_header_val_rec.end_customer_name <> FND_API.G_MISS_CHAR
1061 OR p_header_val_rec.end_customer_number <> FND_API.G_MISS_CHAR
1062 THEN
1063
1064 IF p_x_header_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
1065
1066
1067 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1068 THEN
1069
1070 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1071 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
1072 OE_MSG_PUB.Add;
1073
1074 END IF;
1075
1076 ELSE
1077 oe_Debug_pub.add('attribute procedure');
1078 p_x_header_rec.end_customer_id:=OE_Value_To_Id.end_customer
1079 ( p_end_customer => p_header_val_rec.end_customer_name
1080 ,p_end_customer_number=> p_header_val_rec.end_customer_number
1081 );
1082
1083 IF p_x_header_rec.end_customer_id = FND_API.G_MISS_NUM THEN
1084 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1085 END IF;
1086
1087 END IF;
1088
1089 END IF;
1090
1091 IF p_header_val_rec.end_customer_contact <> FND_API.G_MISS_CHAR
1092 THEN
1093
1094 IF p_x_header_rec.end_customer_id <>FND_API.G_MISS_NUM and
1095 p_x_header_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
1096
1097
1098 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1099 THEN
1100
1101 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1102 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
1103 OE_MSG_PUB.Add;
1104
1105 END IF;
1106
1107 ELSE
1108 oe_debug_pub.add('before calling aend customer contact value to id');
1109 p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
1110 ( p_end_customer_contact => p_header_val_rec.end_customer_contact
1111 ,p_end_customer_id =>p_x_header_rec.end_customer_id
1112 );
1113 oe_debug_pub.add('End customer contact id is '||p_x_header_rec.end_customer_contact_id);
1114
1115 IF p_x_header_rec.end_customer_contact_id = FND_API.G_MISS_NUM THEN
1116 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1117 END IF;
1118
1119 END IF;
1120
1121 END IF;
1122
1123 IF (p_header_val_rec.end_customer_name <> FND_API.G_MISS_CHAR
1124 OR p_header_val_rec.end_customer_number <> FND_API.G_MISS_CHAR)
1125 AND
1126 (p_header_val_rec.end_customer_site_address1 <> FND_API.G_MISS_CHAR
1127 OR p_header_val_rec.end_customer_site_address2 <> FND_API.G_MISS_CHAR
1128 OR p_header_val_rec.end_customer_site_address3 <> FND_API.G_MISS_CHAR
1129 OR p_header_val_rec.end_customer_site_address4 <> FND_API.G_MISS_CHAR
1130 OR p_header_val_rec.end_customer_site_location <> FND_API.G_MISS_CHAR)
1131
1132 THEN
1133
1134 IF p_x_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
1135
1136
1137 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1138 THEN
1139
1140 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1141 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_Location');
1142 OE_MSG_PUB.Add;
1143
1144 END IF;
1145
1146 ELSE
1147 oe_debug_pub.add('Before calling End custoemr site use value to id');
1148 p_x_header_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
1149 ( p_end_customer_site_address1 => p_header_val_rec.end_customer_site_address1
1150 , p_end_customer_site_address2 => p_header_val_rec.end_customer_site_address2
1151 , p_end_customer_site_address3 => p_header_val_rec.end_customer_site_address3
1152 , p_end_customer_site_address4 => p_header_val_rec.end_customer_site_address4
1153 , p_end_customer_site_location => p_header_val_rec.end_customer_site_location
1154 , p_end_customer_site_org => NULL
1155 , p_end_customer_id => p_x_header_rec.end_customer_id
1156 , p_end_customer_site_city => p_header_val_rec.end_customer_site_city
1157 , p_end_customer_site_state => p_header_val_rec.end_customer_site_state
1158 , p_end_customer_site_postalcode => p_header_val_rec.end_customer_site_postal_code
1159 , p_end_customer_site_country => p_header_val_rec.end_customer_site_country
1160 , p_end_customer_site_use_code => NULL
1161 );
1162
1163
1164 oe_debug_pub.add('after hdr sold_to_site_use_id='||p_x_header_rec.end_customer_site_use_id);
1165
1166 IF p_x_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN
1167 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1168 END IF;
1169
1170 END IF;
1171
1172 END IF;
1173
1174 IF p_header_val_rec.ib_owner_dsp <> FND_API.G_MISS_CHAR
1175 THEN
1176 IF p_x_header_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
1177
1178 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1179 THEN
1180
1181 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1182 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
1183 OE_MSG_PUB.Add;
1184
1185 END IF;
1186
1187 ELSE
1188
1189 p_x_header_rec.ib_owner:=OE_Value_To_Id.ib_owner
1190 ( p_ib_owner => p_header_val_rec.ib_owner_dsp
1191 );
1192
1193 IF p_x_header_rec.ib_owner = FND_API.G_MISS_CHAR THEN
1194 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1195 END IF;
1196
1197 END IF;
1198
1199 END IF;
1200
1201 IF p_header_val_rec.ib_installed_at_location_dsp <> FND_API.G_MISS_CHAR
1202 THEN
1203 IF p_x_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
1204
1205 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1206 THEN
1207
1208 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1209 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
1210 OE_MSG_PUB.Add;
1211
1212 END IF;
1213
1214 ELSE
1215
1216 p_x_header_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location
1217 ( p_ib_installed_at_location => p_header_val_rec.ib_installed_at_location_dsp
1218 );
1219
1220 IF p_x_header_rec.ib_installed_at_location = FND_API.G_MISS_CHAR THEN
1221 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1222 END IF;
1223
1224 END IF;
1225
1226 END IF;
1227
1228 IF p_header_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
1229 THEN
1230 IF p_x_header_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
1231
1232 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1233 THEN
1234
1235 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1236 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
1237 OE_MSG_PUB.Add;
1238
1239 END IF;
1240
1241 ELSE
1242
1243 p_x_header_rec.ib_current_location:=OE_Value_To_Id.ib_current_location
1244 ( p_ib_current_location => p_header_val_rec.ib_current_location_dsp
1245 );
1246
1247 IF p_x_header_rec.ib_current_location = FND_API.G_MISS_CHAR THEN
1248 p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1249 END IF;
1250
1251 END IF;
1252
1253 END IF;
1254
1255 --bug 4240715}
1256
1257 ----------------------------------------------------------------------
1258 -- End of get IDs for customer related fields
1259 ----------------------------------------------------------------------
1260
1261 IF l_debug_level > 0 THEN
1262 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.GET_HEADER_IDS' , 1 ) ;
1263 END IF;
1264
1265 END Get_Header_Ids;
1266
1267
1268 PROCEDURE Get_Line_Ids
1269 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1270 , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
1271 )
1272 IS
1273 l_sold_to_org_id NUMBER;
1274 l_deliver_to_org_id NUMBER;
1275 l_invoice_to_org_id NUMBER;
1276 l_ship_to_org_id NUMBER;
1277 --
1278 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1279 --
1280 BEGIN
1281 p_x_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1282
1283 IF p_line_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
1284 THEN
1285
1286 IF p_x_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
1287
1288 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1289 THEN
1290
1291 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1292 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
1293 OE_MSG_PUB.Add;
1294
1295 END IF;
1296
1297 ELSE
1298
1299 p_x_line_rec.accounting_rule_id :=
1300 OE_CNCL_Value_To_Id.accounting_rule
1301 ( p_accounting_rule => p_line_val_rec.accounting_rule
1302 );
1303
1304 IF p_x_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
1305 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1306 END IF;
1307
1308 END IF;
1309
1310 END IF;
1311
1312 IF p_line_val_rec.agreement <> FND_API.G_MISS_CHAR
1313 THEN
1314
1315 IF p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
1316
1317 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1318 THEN
1319
1320 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1321 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
1322 OE_MSG_PUB.Add;
1323
1324 END IF;
1325
1326 ELSE
1327
1328 p_x_line_rec.agreement_id := OE_CNCL_Value_To_Id.agreement
1329 ( p_agreement => p_line_val_rec.agreement
1330 );
1331
1332 IF p_x_line_rec.agreement_id = FND_API.G_MISS_NUM THEN
1333 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1334 END IF;
1335
1336 END IF;
1337
1338 END IF;
1339
1340 IF p_line_val_rec.demand_bucket_type <> FND_API.G_MISS_CHAR
1341 THEN
1342
1343 IF p_x_line_rec.demand_bucket_type_code <> FND_API.G_MISS_CHAR THEN
1344
1345 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1346 THEN
1347
1348 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1349 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
1350 OE_MSG_PUB.Add;
1351
1352 END IF;
1353
1354 ELSE
1355
1356 p_x_line_rec.demand_bucket_type_code :=
1357 OE_CNCL_Value_To_Id.demand_bucket_type
1358 ( p_demand_bucket_type => p_line_val_rec.demand_bucket_type
1359 );
1360
1361 IF p_x_line_rec.demand_bucket_type_code = FND_API.G_MISS_CHAR THEN
1362 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1363 END IF;
1364
1365 END IF;
1366
1367 END IF;
1368
1369 IF p_line_val_rec.fob_point <> FND_API.G_MISS_CHAR
1370 THEN
1371
1372 IF p_x_line_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
1373
1374 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1375 THEN
1376
1377 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1378 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
1379 OE_MSG_PUB.Add;
1380
1381 END IF;
1382
1383 ELSE
1384
1385 p_x_line_rec.fob_point_code := OE_CNCL_Value_To_Id.fob_point
1386 ( p_fob_point => p_line_val_rec.fob_point
1387 );
1388
1389 IF p_x_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN
1390 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1391 END IF;
1392
1393 END IF;
1394
1395 END IF;
1396
1397 IF p_line_val_rec.freight_terms <> FND_API.G_MISS_CHAR
1398 THEN
1399
1400 IF p_x_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
1401
1402 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1403 THEN
1404
1405 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1406 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
1407 OE_MSG_PUB.Add;
1408
1409 END IF;
1410
1411 ELSE
1412
1413 p_x_line_rec.freight_terms_code :=
1414 OE_CNCL_Value_To_Id.freight_terms
1415 ( p_freight_terms => p_line_val_rec.freight_terms
1416 );
1417
1418 IF p_x_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
1419 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1420 END IF;
1421
1422 END IF;
1423
1424 END IF;
1425
1426 IF p_line_val_rec.shipping_method <> FND_API.G_MISS_CHAR
1427 THEN
1428
1429 IF p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
1430
1431 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1432 THEN
1433
1434 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1435 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
1436 OE_MSG_PUB.Add;
1437
1438 END IF;
1439
1440 ELSE
1441
1442 p_x_line_rec.shipping_method_code :=
1443 OE_CNCL_Value_To_Id.ship_method
1444 ( p_ship_method => p_line_val_rec.shipping_method
1445 );
1446
1447 IF p_x_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN
1448 IF l_debug_level > 0 THEN
1449 oe_debug_pub.add( 'SHIP METHOD CONVERSION ERROR' ) ;
1450 END IF;
1451 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1452 END IF;
1453
1454 END IF;
1455
1456 END IF;
1457
1458
1459 IF p_line_val_rec.freight_carrier <> FND_API.G_MISS_CHAR
1460 THEN
1461
1462 IF p_x_line_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
1463
1464 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1465 THEN
1466
1467 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1468 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
1469 OE_MSG_PUB.Add;
1470
1471 END IF;
1472
1473 ELSE
1474
1475 p_x_line_rec.freight_carrier_code :=
1476 OE_CNCL_Value_To_Id.freight_carrier
1477 ( p_freight_carrier => p_line_val_rec.freight_carrier
1478 , p_ship_from_org_id => p_x_line_rec.ship_from_org_id
1479 );
1480
1481 IF p_x_line_rec.freight_carrier_code = FND_API.G_MISS_CHAR THEN
1482 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1483 END IF;
1484
1485 END IF;
1486
1487 END IF;
1488
1489 IF p_line_val_rec.intermed_ship_to_contact <> FND_API.G_MISS_CHAR
1490 THEN
1491
1492 IF p_x_line_rec.intermed_ship_to_contact_id <> FND_API.G_MISS_NUM THEN
1493
1494 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1495 THEN
1496
1497 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1498 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
1499 OE_MSG_PUB.Add;
1500
1501 END IF;
1502
1503 ELSE
1504
1505 p_x_line_rec.intermed_ship_to_contact_id :=
1506 OE_CNCL_Value_To_Id.intermed_ship_to_contact
1507 ( p_intermed_ship_to_contact => p_line_val_rec.intermed_ship_to_contact
1508 , p_intermed_ship_to_org_id => p_x_line_rec.intermed_ship_to_org_id
1509 );
1510
1511 IF p_x_line_rec.intermed_ship_to_contact_id = FND_API.G_MISS_NUM THEN
1512 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1513 END IF;
1514
1515 END IF;
1516
1517 END IF;
1518
1519 IF p_line_val_rec.intermed_ship_to_address1 <> FND_API.G_MISS_CHAR
1520 OR p_line_val_rec.intermed_ship_to_address2 <> FND_API.G_MISS_CHAR
1521 OR p_line_val_rec.intermed_ship_to_address3 <> FND_API.G_MISS_CHAR
1522 OR p_line_val_rec.intermed_ship_to_address4 <> FND_API.G_MISS_CHAR
1523 OR p_line_val_rec.intermed_ship_to_location <> FND_API.G_MISS_CHAR
1524 OR p_line_val_rec.intermed_ship_to_org <> FND_API.G_MISS_CHAR
1525 THEN
1526
1527 IF p_x_line_rec.intermed_ship_to_org_id <> FND_API.G_MISS_NUM THEN
1528
1529 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1530 THEN
1531
1532 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1533 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
1534 OE_MSG_PUB.Add;
1535
1536 END IF;
1537
1538 ELSE
1539 /*1621182*/
1540 p_x_line_rec.intermed_ship_to_org_id := OE_CNCL_Value_To_Id.intermed_ship_to_org
1541 ( p_intermed_ship_to_address1 => p_line_val_rec.intermed_ship_to_address1
1542 , p_intermed_ship_to_address2 => p_line_val_rec.intermed_ship_to_address2
1543 , p_intermed_ship_to_address3 => p_line_val_rec.intermed_ship_to_address3
1544 , p_intermed_ship_to_address4 => p_line_val_rec.intermed_ship_to_address4
1545 , p_intermed_ship_to_location => p_line_val_rec.intermed_ship_to_location
1546 , p_intermed_ship_to_org => p_line_val_rec.intermed_ship_to_org
1547 , p_intermed_ship_to_city => p_line_val_rec.intermed_ship_to_city
1548 , p_intermed_ship_to_state => p_line_val_rec.intermed_ship_to_state
1549 , p_intermed_ship_to_postal_code => p_line_val_rec.intermed_ship_to_zip
1550 , p_intermed_ship_to_country => p_line_val_rec.intermed_ship_to_country
1551 , p_sold_to_org_id => p_x_line_rec.sold_to_org_id
1552 );
1553 /*1621182*/
1554
1555 IF p_x_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM THEN
1556 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1557 END IF;
1558
1559 END IF;
1560
1561 END IF;
1562
1563
1564 IF p_line_val_rec.inventory_item <> FND_API.G_MISS_CHAR
1565 THEN
1566
1567 IF p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
1568
1569 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1570 THEN
1571
1572 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1573 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
1574 OE_MSG_PUB.Add;
1575
1576 END IF;
1577
1578 ELSE
1579
1580 p_x_line_rec.inventory_item_id := OE_CNCL_Value_To_Id.inventory_item
1581 ( p_inventory_item => p_line_val_rec.inventory_item
1582 );
1583
1584 IF p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1585 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1586 END IF;
1587
1588 END IF;
1589
1590 END IF;
1591
1592 IF p_line_val_rec.invoicing_rule <> FND_API.G_MISS_CHAR
1593 THEN
1594
1595 IF p_x_line_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
1596
1597 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1598 THEN
1599
1600 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1601 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
1602 OE_MSG_PUB.Add;
1603
1604 END IF;
1605
1606 ELSE
1607
1608 p_x_line_rec.invoicing_rule_id := OE_CNCL_Value_To_Id.invoicing_rule
1609 ( p_invoicing_rule => p_line_val_rec.invoicing_rule
1610 );
1611
1612 IF p_x_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
1613 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1614 END IF;
1615
1616 END IF;
1617
1618 END IF;
1619
1620 IF p_line_val_rec.item_type <> FND_API.G_MISS_CHAR
1621 THEN
1622
1623 IF p_x_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
1624
1625 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1626 THEN
1627
1628 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1629 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
1630 OE_MSG_PUB.Add;
1631
1632 END IF;
1633
1634 ELSE
1635
1636 p_x_line_rec.item_type_code := OE_CNCL_Value_To_Id.item_type
1637 ( p_item_type => p_line_val_rec.item_type
1638 );
1639
1640 IF p_x_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN
1641 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1642 END IF;
1643
1644 END IF;
1645
1646 END IF;
1647
1648 IF p_line_val_rec.line_type <> FND_API.G_MISS_CHAR
1649 THEN
1650
1651 IF p_x_line_rec.line_type_id <> FND_API.G_MISS_NUM THEN
1652
1653 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1654 THEN
1655
1656 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1657 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
1658 OE_MSG_PUB.Add;
1659
1660 END IF;
1661
1662 ELSE
1663
1664 p_x_line_rec.line_type_id := OE_CNCL_Value_To_Id.line_type
1665 ( p_line_type => p_line_val_rec.line_type
1666 );
1667
1668 IF p_x_line_rec.line_type_id = FND_API.G_MISS_NUM THEN
1669 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1670 END IF;
1671
1672 END IF;
1673
1674 END IF;
1675
1676 IF p_line_val_rec.over_ship_reason <> FND_API.G_MISS_CHAR
1677 THEN
1678
1679 IF p_x_line_rec.over_ship_reason_code <> FND_API.G_MISS_CHAR THEN
1680
1681 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1682 THEN
1683
1684 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1685 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
1686 OE_MSG_PUB.Add;
1687
1688 END IF;
1689
1690 ELSE
1691
1692 p_x_line_rec.over_ship_reason_code :=
1693 OE_CNCL_Value_To_Id.over_ship_reason
1694 ( p_over_ship_reason => p_line_val_rec.over_ship_reason
1695 );
1696
1697 IF p_x_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN
1698 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1699 END IF;
1700
1701 END IF;
1702
1703 END IF;
1704
1705 IF p_line_val_rec.payment_term <> FND_API.G_MISS_CHAR
1706 THEN
1707
1708 IF p_x_line_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
1709
1710 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1711 THEN
1712
1713 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1714 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
1715 OE_MSG_PUB.Add;
1716
1717 END IF;
1718
1719 ELSE
1720
1721 p_x_line_rec.payment_term_id :=
1722 OE_CNCL_Value_To_Id.payment_term
1723 ( p_payment_term => p_line_val_rec.payment_term
1724 );
1725
1726 IF p_x_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN
1727 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1728 END IF;
1729
1730 END IF;
1731
1732 END IF;
1733
1734 IF p_line_val_rec.price_list <> FND_API.G_MISS_CHAR
1735 THEN
1736
1737 IF p_x_line_rec.price_list_id <> FND_API.G_MISS_NUM THEN
1738
1739 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1740 THEN
1741
1742 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1743 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
1744 OE_MSG_PUB.Add;
1745
1746 END IF;
1747
1748 ELSE
1749
1750 p_x_line_rec.price_list_id := OE_CNCL_Value_To_Id.price_list
1751 ( p_price_list => p_line_val_rec.price_list
1752 );
1753
1754 IF p_x_line_rec.price_list_id = FND_API.G_MISS_NUM THEN
1755 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1756 END IF;
1757
1758 END IF;
1759
1760 END IF;
1761
1762 IF p_line_val_rec.project <> FND_API.G_MISS_CHAR
1763 THEN
1764
1765 IF p_x_line_rec.project_id <> FND_API.G_MISS_NUM THEN
1766
1767 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1768 THEN
1769
1770 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1771 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
1772 OE_MSG_PUB.Add;
1773
1774 END IF;
1775
1776 ELSE
1777
1778 p_x_line_rec.project_id := OE_CNCL_Value_To_Id.project
1779 ( p_project => p_line_val_rec.project
1780 );
1781
1782 IF p_x_line_rec.project_id = FND_API.G_MISS_NUM THEN
1783 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1784 END IF;
1785
1786 END IF;
1787
1788 END IF;
1789
1790 IF p_line_val_rec.return_reason <> FND_API.G_MISS_CHAR
1791 THEN
1792
1793 IF p_x_line_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
1794
1795 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1796 THEN
1797
1798 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1799 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
1800 OE_MSG_PUB.Add;
1801
1802 END IF;
1803
1804 ELSE
1805
1806 p_x_line_rec.return_reason_code := OE_CNCL_Value_To_Id.return_reason
1807 ( p_return_reason => p_line_val_rec.return_reason
1808 );
1809
1810 IF p_x_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN
1811 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1812 END IF;
1813
1814 END IF;
1815
1816 END IF;
1817
1818
1819
1820 IF p_line_val_rec.rla_schedule_type <> FND_API.G_MISS_CHAR
1821 THEN
1822
1823 IF p_x_line_rec.rla_schedule_type_code <> FND_API.G_MISS_CHAR THEN
1824
1825 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1826 THEN
1827
1828 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1829 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
1830 OE_MSG_PUB.Add;
1831
1832 END IF;
1833
1834 ELSE
1835
1836 p_x_line_rec.rla_schedule_type_code :=
1837 OE_CNCL_Value_To_Id.rla_schedule_type
1838 ( p_rla_schedule_type => p_line_val_rec.rla_schedule_type
1839 );
1840
1841 IF p_x_line_rec.rla_schedule_type_code = FND_API.G_MISS_CHAR THEN
1842 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1843 END IF;
1844
1845 END IF;
1846
1847 END IF;
1848
1849 IF p_line_val_rec.salesrep <> FND_API.G_MISS_CHAR
1850 THEN
1851
1852 IF p_x_line_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
1853
1854 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1855 THEN
1856
1857 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1858 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
1859 OE_MSG_PUB.Add;
1860
1861 END IF;
1862
1863 ELSE
1864
1865 p_x_line_rec.salesrep_id := OE_CNCL_Value_To_Id.salesrep
1866 ( p_salesrep => p_line_val_rec.salesrep
1867 );
1868
1869 IF p_x_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1870 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1871 END IF;
1872
1873 END IF;
1874
1875 END IF;
1876
1877 IF p_line_val_rec.shipment_priority <> FND_API.G_MISS_CHAR
1878 THEN
1879
1880 IF p_x_line_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
1881
1882 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1883 THEN
1884
1885 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1886 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
1887 OE_MSG_PUB.Add;
1888
1889 END IF;
1890
1891 ELSE
1892
1893 p_x_line_rec.shipment_priority_code :=
1894 OE_CNCL_Value_To_Id.shipment_priority
1895 ( p_shipment_priority => p_line_val_rec.shipment_priority
1896 );
1897
1898 IF p_x_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN
1899 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1900 END IF;
1901
1902 END IF;
1903
1904 END IF;
1905
1906 IF p_line_val_rec.ship_from_address1 <> FND_API.G_MISS_CHAR
1907 OR p_line_val_rec.ship_from_address2 <> FND_API.G_MISS_CHAR
1908 OR p_line_val_rec.ship_from_address3 <> FND_API.G_MISS_CHAR
1909 OR p_line_val_rec.ship_from_address4 <> FND_API.G_MISS_CHAR
1910 OR p_line_val_rec.ship_from_location <> FND_API.G_MISS_CHAR
1911 OR p_line_val_rec.ship_from_org <> FND_API.G_MISS_CHAR
1912 THEN
1913
1914 IF p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
1915
1916 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1917 THEN
1918
1919 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1920 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
1921 OE_MSG_PUB.Add;
1922
1923 END IF;
1924
1925 ELSE
1926
1927 p_x_line_rec.ship_from_org_id := OE_CNCL_Value_To_Id.ship_from_org
1928 ( p_ship_from_address1 => p_line_val_rec.ship_from_address1
1929 , p_ship_from_address2 => p_line_val_rec.ship_from_address2
1930 , p_ship_from_address3 => p_line_val_rec.ship_from_address3
1931 , p_ship_from_address4 => p_line_val_rec.ship_from_address4
1932 , p_ship_from_location => p_line_val_rec.ship_from_location
1933 , p_ship_from_org => p_line_val_rec.ship_from_org
1934 );
1935
1936 IF p_x_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
1937 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1938 END IF;
1939
1940 END IF;
1941
1942 END IF;
1943
1944 IF p_line_val_rec.task <> FND_API.G_MISS_CHAR
1945 THEN
1946
1947 IF p_x_line_rec.task_id <> FND_API.G_MISS_NUM THEN
1948
1949 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1950 THEN
1951
1952 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1953 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
1954 OE_MSG_PUB.Add;
1955
1956 END IF;
1957
1958 ELSE
1959
1960 p_x_line_rec.task_id := OE_CNCL_Value_To_Id.task
1961 ( p_task => p_line_val_rec.task
1962 );
1963
1964 IF p_x_line_rec.task_id = FND_API.G_MISS_NUM THEN
1965 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1966 END IF;
1967
1968 END IF;
1969
1970 END IF;
1971
1972 IF p_line_val_rec.tax_exempt <> FND_API.G_MISS_CHAR
1973 THEN
1974
1975 IF p_x_line_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
1976
1977 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1978 THEN
1979
1980 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
1981 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
1982 OE_MSG_PUB.Add;
1983
1984 END IF;
1985
1986 ELSE
1987
1988 p_x_line_rec.tax_exempt_flag := OE_CNCL_Value_To_Id.tax_exempt
1989 ( p_tax_exempt => p_line_val_rec.tax_exempt
1990 );
1991
1992 IF p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN
1993 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1994 END IF;
1995
1996 END IF;
1997
1998 END IF;
1999
2000 IF p_line_val_rec.tax_exempt_reason <> FND_API.G_MISS_CHAR
2001 THEN
2002
2003 IF p_x_line_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
2004
2005 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2006 THEN
2007
2008 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2009 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
2010 OE_MSG_PUB.Add;
2011
2012 END IF;
2013
2014 ELSE
2015
2016 p_x_line_rec.tax_exempt_reason_code :=
2017 OE_CNCL_Value_To_Id.tax_exempt_reason
2018 ( p_tax_exempt_reason => p_line_val_rec.tax_exempt_reason
2019 );
2020
2021 IF p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN
2022 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2023 END IF;
2024
2025 END IF;
2026
2027 END IF;
2028
2029 IF p_line_val_rec.tax_point <> FND_API.G_MISS_CHAR
2030 THEN
2031
2032 IF p_x_line_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
2033
2034 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2035 THEN
2036
2037 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2038 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
2039 OE_MSG_PUB.Add;
2040
2041 END IF;
2042
2043 ELSE
2044
2045 p_x_line_rec.tax_point_code := OE_CNCL_Value_To_Id.tax_point
2046 ( p_tax_point => p_line_val_rec.tax_point
2047 );
2048
2049 IF p_x_line_rec.tax_point_code = FND_API.G_MISS_CHAR THEN
2050 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2051 END IF;
2052
2053 END IF;
2054
2055 END IF;
2056
2057
2058 IF p_line_val_rec.veh_cus_item_cum_key <> FND_API.G_MISS_CHAR
2059 THEN
2060
2061 IF p_x_line_rec.veh_cus_item_cum_key_id <> FND_API.G_MISS_NUM THEN
2062
2063 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2064 THEN
2065
2066 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2067 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
2068 OE_MSG_PUB.Add;
2069
2070 END IF;
2071
2072 ELSE
2073
2074 p_x_line_rec.veh_cus_item_cum_key_id :=
2075 OE_CNCL_Value_To_Id.veh_cus_item_cum_key
2076 ( p_veh_cus_item_cum_key => p_line_val_rec.veh_cus_item_cum_key
2077 );
2078
2079 IF p_x_line_rec.veh_cus_item_cum_key_id = FND_API.G_MISS_NUM THEN
2080 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2081 END IF;
2082
2083 END IF;
2084
2085 END IF;
2086
2087 -------------------------------------------------------------------
2088 -- For customer related fields, IDs should be retrieved in the
2089 -- following order.
2090 -------------------------------------------------------------------
2091
2092 -- Retrieve the sold_to_org_id if not passed on the line record. This
2093 -- will be needed by the value_to_id functions for related fields.
2094 -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
2095
2096 IF p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM
2097 THEN
2098
2099 IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2100
2101 SELECT SOLD_TO_ORG_ID
2102 INTO l_sold_to_org_id
2103 FROM OE_ORDER_HEADERS
2104 WHERE HEADER_ID = p_x_line_rec.header_id;
2105
2106 ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2107
2108 SELECT SOLD_TO_ORG_ID
2109 INTO l_sold_to_org_id
2110 FROM OE_ORDER_LINES
2111 WHERE LINE_ID = p_x_line_rec.line_id;
2112
2113 END IF;
2114
2115 ELSE
2116
2117 l_sold_to_org_id := p_x_line_rec.sold_to_org_id;
2118
2119 END IF;
2120
2121 IF p_line_val_rec.deliver_to_address1 <> FND_API.G_MISS_CHAR
2122 OR p_line_val_rec.deliver_to_address2 <> FND_API.G_MISS_CHAR
2123 OR p_line_val_rec.deliver_to_address3 <> FND_API.G_MISS_CHAR
2124 OR p_line_val_rec.deliver_to_address4 <> FND_API.G_MISS_CHAR
2125 OR p_line_val_rec.deliver_to_location <> FND_API.G_MISS_CHAR
2126 OR p_line_val_rec.deliver_to_org <> FND_API.G_MISS_CHAR
2127 THEN
2128
2129 IF p_x_line_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
2130
2131
2132 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2133 THEN
2134
2135 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2136 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
2137 OE_MSG_PUB.Add;
2138
2139 END IF;
2140
2141 ELSE
2142 /*1621182*/
2143 p_x_line_rec.deliver_to_org_id :=
2144 OE_CNCL_Value_To_Id.deliver_to_org
2145 ( p_deliver_to_address1 => p_line_val_rec.deliver_to_address1
2146 , p_deliver_to_address2 => p_line_val_rec.deliver_to_address2
2147 , p_deliver_to_address3 => p_line_val_rec.deliver_to_address3
2148 , p_deliver_to_address4 => p_line_val_rec.deliver_to_address4
2149 , p_deliver_to_location => p_line_val_rec.deliver_to_location
2150 , p_deliver_to_org => p_line_val_rec.deliver_to_org
2151 , p_deliver_to_city => p_line_val_rec.deliver_to_city
2152 , p_deliver_to_state => p_line_val_rec.deliver_to_state
2153 , p_deliver_to_postal_code => p_line_val_rec.deliver_to_zip
2154 , p_deliver_to_country => p_line_val_rec.deliver_to_country
2155 , p_sold_to_org_id => l_sold_to_org_id
2156 );
2157
2158 /*1621182*/
2159 IF p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN
2160 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2161 END IF;
2162
2163 END IF;
2164
2165 END IF;
2166
2167 IF p_line_val_rec.invoice_to_address1 <> FND_API.G_MISS_CHAR
2168 OR p_line_val_rec.invoice_to_address2 <> FND_API.G_MISS_CHAR
2169 OR p_line_val_rec.invoice_to_address3 <> FND_API.G_MISS_CHAR
2170 OR p_line_val_rec.invoice_to_address4 <> FND_API.G_MISS_CHAR
2171 OR p_line_val_rec.invoice_to_location <> FND_API.G_MISS_CHAR
2172 OR p_line_val_rec.invoice_to_org <> FND_API.G_MISS_CHAR
2173 THEN
2174
2175 IF p_x_line_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
2176
2177
2178 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2179 THEN
2180
2181 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2182 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
2183 OE_MSG_PUB.Add;
2184
2185 END IF;
2186
2187 ELSE
2188 /*1621182*/
2189 p_x_line_rec.invoice_to_org_id :=
2190 OE_CNCL_Value_To_Id.invoice_to_org
2191 ( p_invoice_to_address1 => p_line_val_rec.invoice_to_address1
2192 , p_invoice_to_address2 => p_line_val_rec.invoice_to_address2
2193 , p_invoice_to_address3 => p_line_val_rec.invoice_to_address3
2194 , p_invoice_to_address4 => p_line_val_rec.invoice_to_address4
2195 , p_invoice_to_location => p_line_val_rec.invoice_to_location
2196 , p_invoice_to_org => p_line_val_rec.invoice_to_org
2197 , p_invoice_to_city => p_line_val_rec.invoice_to_city
2198 , p_invoice_to_state => p_line_val_rec.invoice_to_state
2199 , p_invoice_to_postal_code => p_line_val_rec.invoice_to_zip
2200 , p_invoice_to_country => p_line_val_rec.invoice_to_country
2201 , p_sold_to_org_id => l_sold_to_org_id
2202 );
2203
2204 /*1621182*/
2205 IF p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
2206 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2207 END IF;
2208
2209 END IF;
2210
2211 END IF;
2212
2213 IF p_line_val_rec.ship_to_address1 <> FND_API.G_MISS_CHAR
2214 OR p_line_val_rec.ship_to_address2 <> FND_API.G_MISS_CHAR
2215 OR p_line_val_rec.ship_to_address3 <> FND_API.G_MISS_CHAR
2216 OR p_line_val_rec.ship_to_address4 <> FND_API.G_MISS_CHAR
2217 OR p_line_val_rec.ship_to_location <> FND_API.G_MISS_CHAR
2218 OR p_line_val_rec.ship_to_org <> FND_API.G_MISS_CHAR
2219 THEN
2220
2221 IF p_x_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
2222
2223
2224 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2225 THEN
2226
2227 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2228 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
2229 OE_MSG_PUB.Add;
2230
2231 END IF;
2232
2233 ELSE
2234
2235 /*1621182*/
2236 p_x_line_rec.ship_to_org_id := OE_CNCL_Value_To_Id.ship_to_org
2237 ( p_ship_to_address1 => p_line_val_rec.ship_to_address1
2238 , p_ship_to_address2 => p_line_val_rec.ship_to_address2
2239 , p_ship_to_address3 => p_line_val_rec.ship_to_address3
2240 , p_ship_to_address4 => p_line_val_rec.ship_to_address4
2241 , p_ship_to_location => p_line_val_rec.ship_to_location
2242 , p_ship_to_org => p_line_val_rec.ship_to_org
2243 , p_ship_to_city => p_line_val_rec.ship_to_city
2244 , p_ship_to_state => p_line_val_rec.ship_to_state
2245 , p_ship_to_postal_code => p_line_val_rec.ship_to_zip
2246 , p_ship_to_country => p_line_val_rec.ship_to_country
2247 , p_sold_to_org_id => l_sold_to_org_id
2248 );
2249 /*1621182*/
2250
2251 IF p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN
2252 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2253 END IF;
2254
2255 END IF;
2256
2257 END IF;
2258
2259 -- Retrieve the org_ids if not passed on the line record. These
2260 -- IDs will be needed by the value_to_id functions for CONTACT fields.
2261 -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id
2262
2263 IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2264 AND ( p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM
2265 OR p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM
2266 OR p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM )
2267 THEN
2268
2269 SELECT SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID
2270 INTO l_sold_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
2271 FROM OE_ORDER_LINES
2272 WHERE LINE_ID = p_x_line_rec.line_id;
2273
2274 IF p_x_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
2275 l_ship_to_org_id := p_x_line_rec.ship_to_org_id;
2276 END IF;
2277
2278 IF p_x_line_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
2279 l_invoice_to_org_id := p_x_line_rec.invoice_to_org_id;
2280 END IF;
2281
2282 IF p_x_line_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
2283 l_deliver_to_org_id := p_x_line_rec.deliver_to_org_id;
2284 END IF;
2285
2286 ELSE
2287
2288 l_sold_to_org_id := p_x_line_rec.sold_to_org_id;
2289 l_invoice_to_org_id := p_x_line_rec.invoice_to_org_id;
2290 l_deliver_to_org_id := p_x_line_rec.deliver_to_org_id;
2291
2292 END IF;
2293
2294 IF p_line_val_rec.deliver_to_contact <> FND_API.G_MISS_CHAR
2295 THEN
2296
2297 IF p_x_line_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
2298
2299
2300 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2301 THEN
2302
2303 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2304 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
2305 OE_MSG_PUB.Add;
2306
2307 END IF;
2308
2309 ELSE
2310
2311 p_x_line_rec.deliver_to_contact_id :=
2312 OE_CNCL_Value_To_Id.deliver_to_contact
2313 ( p_deliver_to_contact => p_line_val_rec.deliver_to_contact
2314 , p_deliver_to_org_id => l_deliver_to_org_id
2315 );
2316
2317 IF p_x_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN
2318 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2319 END IF;
2320
2321 END IF;
2322
2323 END IF;
2324
2325 IF p_line_val_rec.invoice_to_contact <> FND_API.G_MISS_CHAR
2326 THEN
2327
2328 IF p_x_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
2329
2330
2331 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2332 THEN
2333
2334 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2335 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
2336 OE_MSG_PUB.Add;
2337
2338 END IF;
2339
2340 ELSE
2341
2342 p_x_line_rec.invoice_to_contact_id :=
2343 OE_CNCL_Value_To_Id.invoice_to_contact
2344 ( p_invoice_to_contact => p_line_val_rec.invoice_to_contact
2345 , p_invoice_to_org_id => l_invoice_to_org_id
2346 );
2347
2348 IF p_x_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN
2349 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2350 END IF;
2351
2352 END IF;
2353
2354 END IF;
2355
2356 IF p_line_val_rec.ship_to_contact <> FND_API.G_MISS_CHAR
2357 THEN
2358
2359 IF p_x_line_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
2360
2361
2362 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2363 THEN
2364
2365 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2366 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
2367 OE_MSG_PUB.Add;
2368
2369 END IF;
2370
2371 ELSE
2372
2373 p_x_line_rec.ship_to_contact_id :=
2374 OE_CNCL_Value_To_Id.ship_to_contact
2375 ( p_ship_to_contact => p_line_val_rec.ship_to_contact
2376 , p_ship_to_org_id => l_ship_to_org_id
2377 );
2378
2379 IF p_x_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN
2380 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2381 END IF;
2382
2383 END IF;
2384
2385 END IF;
2386
2387 --{added for bug 4240715
2388
2389 oe_Debug_pub.add('In get line ids procedure');
2390
2391 IF p_line_val_rec.end_customer_name <> FND_API.G_MISS_CHAR
2392 OR p_line_val_rec.end_customer_number <> FND_API.G_MISS_CHAR
2393 THEN
2394
2395 IF p_x_line_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
2396
2397
2398 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2399 THEN
2400
2401 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2402 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
2403 OE_MSG_PUB.Add;
2404
2405 END IF;
2406
2407 ELSE
2408
2409 p_x_line_rec.end_customer_id:=OE_Value_To_Id.end_customer
2410 ( p_end_customer => p_line_val_rec.end_customer_name
2411 ,p_end_customer_number=> p_line_val_rec.end_customer_number
2412 );
2413
2414 oe_debug_pub.add('after gettting end customer id'||p_x_line_rec.end_customer_id);
2415 IF p_x_line_rec.end_customer_id = FND_API.G_MISS_NUM THEN
2416 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2417 END IF;
2418
2419 END IF;
2420
2421 END IF;
2422
2423 IF p_line_val_rec.end_customer_contact <> FND_API.G_MISS_CHAR
2424 THEN
2425
2426 IF p_x_line_rec.end_customer_id <>FND_API.G_MISS_NUM and
2427 p_x_line_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
2428
2429
2430 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2431 THEN
2432
2433 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2434 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
2435 OE_MSG_PUB.Add;
2436
2437 END IF;
2438
2439 ELSE
2440 oe_debug_pub.add('before calling aend customer contact value to id');
2441 p_x_line_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
2442 ( p_end_customer_contact => p_line_val_rec.end_customer_contact
2443 ,p_end_customer_id =>p_x_line_rec.end_customer_id
2444 );
2445 oe_debug_pub.add('End customer contact id is '||p_x_line_rec.end_customer_contact_id);
2446
2447 IF p_x_line_rec.end_customer_contact_id = FND_API.G_MISS_NUM THEN
2448 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2449 END IF;
2450
2451 END IF;
2452
2453 END IF;
2454
2455 IF (p_line_val_rec.end_customer_name <> FND_API.G_MISS_CHAR
2456 OR p_line_val_rec.end_customer_number <> FND_API.G_MISS_CHAR)
2457 AND
2458 (p_line_val_rec.end_customer_site_address1 <> FND_API.G_MISS_CHAR
2459 OR p_line_val_rec.end_customer_site_address2 <> FND_API.G_MISS_CHAR
2460 OR p_line_val_rec.end_customer_site_address3 <> FND_API.G_MISS_CHAR
2461 OR p_line_val_rec.end_customer_site_address4 <> FND_API.G_MISS_CHAR
2462 OR p_line_val_rec.end_customer_site_location <> FND_API.G_MISS_CHAR)
2463
2464 THEN
2465
2466 IF p_x_line_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
2467
2468
2469 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2470 THEN
2471
2472 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2473 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_Location');
2474 OE_MSG_PUB.Add;
2475
2476 END IF;
2477
2478 ELSE
2479 oe_debug_pub.add('Before calling End custoemr site use value to id');
2480 p_x_line_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
2481 ( p_end_customer_site_address1 => p_line_val_rec.end_customer_site_address1
2482 , p_end_customer_site_address2 => p_line_val_rec.end_customer_site_address2
2483 , p_end_customer_site_address3 => p_line_val_rec.end_customer_site_address3
2484 , p_end_customer_site_address4 => p_line_val_rec.end_customer_site_address4
2485 , p_end_customer_site_location => p_line_val_rec.end_customer_site_location
2486 , p_end_customer_site_org => NULL
2487 , p_end_customer_id => p_x_line_rec.end_customer_id
2488 , p_end_customer_site_city => p_line_val_rec.end_customer_site_city
2489 , p_end_customer_site_state => p_line_val_rec.end_customer_site_state
2490 , p_end_customer_site_postalcode => p_line_val_rec.end_customer_site_postal_code
2491 , p_end_customer_site_country => p_line_val_rec.end_customer_site_country
2492 , p_end_customer_site_use_code => NULL
2493 );
2494
2495
2496 oe_debug_pub.add('after hdr sold_to_site_use_id='||p_x_line_rec.end_customer_site_use_id);
2497
2498 IF p_x_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN
2499 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2500 END IF;
2501
2502 END IF;
2503
2504 END IF;
2505
2506
2507 IF p_line_val_rec.ib_owner_dsp <> FND_API.G_MISS_CHAR
2508 THEN
2509 IF p_x_line_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
2510
2511 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2512 THEN
2513
2514 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2515 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
2516 OE_MSG_PUB.Add;
2517
2518 END IF;
2519
2520 ELSE
2521
2522 p_x_line_rec.ib_owner:=OE_Value_To_Id.ib_owner
2523 ( p_ib_owner => p_line_val_rec.ib_owner_dsp
2524 );
2525
2526 IF p_x_line_rec.ib_owner = FND_API.G_MISS_CHAR THEN
2527 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2528 END IF;
2529
2530 END IF;
2531
2532 END IF;
2533
2534 IF p_line_val_rec.ib_installed_at_location_dsp <> FND_API.G_MISS_CHAR
2535 THEN
2536 IF p_x_line_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
2537
2538 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2539 THEN
2540
2541 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2542 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
2543 OE_MSG_PUB.Add;
2544
2545 END IF;
2546
2547 ELSE
2548
2549 p_x_line_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location
2550 ( p_ib_installed_at_location => p_line_val_rec.ib_installed_at_location_dsp
2551 );
2552
2553 IF p_x_line_rec.ib_installed_at_location = FND_API.G_MISS_CHAR THEN
2554 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2555 END IF;
2556
2557 END IF;
2558
2559 END IF;
2560
2561 IF p_line_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
2562 THEN
2563 IF p_x_line_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
2564
2565 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2566 THEN
2567
2568 fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
2570 OE_MSG_PUB.Add;
2571
2572 END IF;
2573
2574 ELSE
2575
2576 p_x_line_rec.ib_current_location:=OE_Value_To_Id.ib_current_location
2577 ( p_ib_current_location => p_line_val_rec.ib_current_location_dsp
2578 );
2579
2580 IF p_x_line_rec.ib_current_location = FND_API.G_MISS_CHAR THEN
2581 p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2582 END IF;
2583
2584 END IF;
2585
2586 END IF;
2587
2588 --bug 4240715}
2589
2590 -------------------------------------------------------------------
2591 -- End of get IDs for customer related fields
2592 -------------------------------------------------------------------
2593
2594 END Get_Line_Ids;
2595
2596
2597
2598 -- Procedure Get_Header_Scredit_Ids
2599
2600 PROCEDURE Get_Header_Scredit_Ids
2601 ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2602 , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
2603 )
2604 IS
2605
2606 --
2607 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2608 --
2609 BEGIN
2610 -- aksingh working
2611 -- initialize return_status.
2612
2613 p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2614
2615 -- initialize l_Header_Scredit_rec.
2616
2617
2618
2619 IF p_Header_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2620 THEN
2621
2622 IF p_x_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2623
2624
2625
2626 IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2627 THEN
2628
2629 FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2630 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2631 oe_msg_pub.Add;
2632
2633 END IF;
2634
2635 ELSE
2636
2637 p_x_Header_Scredit_rec.salesrep_id := OE_CNCL_Value_To_Id.salesrep
2638 ( p_salesrep => p_Header_Scredit_val_rec.salesrep
2639 );
2640
2641 IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2642 p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2643 END IF;
2644
2645 END IF;
2646
2647 END IF;
2648
2649 IF p_Header_Scredit_val_rec.sales_credit_type <> FND_API.G_MISS_CHAR
2650 THEN
2651
2652 IF p_x_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2653
2654
2655 IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2656 THEN
2657
2658 FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2659 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2660 oe_msg_pub.Add;
2661
2662 END IF;
2663
2664 ELSE
2665
2666 p_x_Header_Scredit_rec.sales_credit_type_id :=
2667 OE_CNCL_Value_To_Id.sales_credit_type
2668 ( p_sales_credit_type => p_Header_Scredit_val_rec.sales_credit_type
2669 );
2670
2671 IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
2672 p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2673 END IF;
2674
2675 END IF;
2676
2677 END IF;
2678
2679
2680
2681
2682 END Get_Header_Scredit_Ids;
2683
2684
2685 PROCEDURE Get_Line_Scredit_Ids
2686 ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
2687 , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2688 )
2689 IS
2690 --
2691 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2692 --
2693 BEGIN
2694
2695 -- initialize return_status.
2696
2697 p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2698
2699 IF p_Line_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2700 THEN
2701
2702 IF p_x_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2703
2704 IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2705 THEN
2706
2707 FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2708 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2709 oe_msg_pub.Add;
2710
2711 END IF;
2712
2713 ELSE
2714
2715 p_x_Line_Scredit_rec.salesrep_id := OE_CNCL_Value_To_Id.salesrep
2716 ( p_salesrep => p_Line_Scredit_val_rec.salesrep
2717 );
2718
2719 IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2720 p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2721 END IF;
2722
2723 END IF;
2724
2725 END IF;
2726
2727 IF p_Line_Scredit_val_rec.sales_credit_type <> FND_API.G_MISS_CHAR
2728 THEN
2729
2730 IF p_x_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2731
2732 IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2733 THEN
2734
2735 FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2736 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2737 oe_msg_pub.Add;
2738
2739 END IF;
2740
2741 ELSE
2742
2743 p_x_Line_Scredit_rec.sales_credit_type_id :=
2744 OE_CNCL_Value_To_Id.sales_credit_type
2745 ( p_sales_credit_type => p_Line_Scredit_val_rec.sales_credit_type
2746 );
2747
2748 IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
2749 p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2750 END IF;
2751
2752 END IF;
2753 END IF;
2754
2755 END Get_Line_Scredit_Ids;
2756
2757
2758
2759
2760
2761
2762
2763 PROCEDURE Get_Header_Adj_Ids
2764 ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2765 , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
2766 )
2767 IS
2768 l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2769 --
2770 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2771 --
2772 BEGIN
2773 -- aksingh completed modification
2774 -- initialize return_status.
2775
2776 l_Header_Adj_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2777
2778 -- initialize l_Header_Adj_rec.
2779
2780 l_Header_Adj_rec := p_x_Header_Adj_rec;
2781
2782 IF p_Header_Adj_val_rec.discount <> FND_API.G_MISS_CHAR
2783 THEN
2784
2785 IF p_x_Header_Adj_rec.discount_id <> FND_API.G_MISS_NUM THEN
2786
2787 l_Header_Adj_rec.discount_id := p_x_Header_Adj_rec.discount_id;
2788
2789 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2790 THEN
2791
2792 FND_MESSAGE.SET_NAME('OE','OE_BOTH_VAL_AND_ID_EXIST');
2793 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
2794 FND_MSG_PUB.Add;
2795
2796 END IF;
2797
2798 ELSE
2799
2800 l_Header_Adj_rec.discount_id := OE_CNCL_Value_To_Id.discount
2801 ( p_discount => p_Header_Adj_val_rec.discount
2802 );
2803
2804 IF l_Header_Adj_rec.discount_id = FND_API.G_MISS_NUM THEN
2805 l_Header_Adj_rec.return_status := FND_API.G_RET_STS_ERROR;
2806 END IF;
2807
2808 END IF;
2809
2810 END IF;
2811
2812 -- RETURN l_Header_Adj_rec;
2813 p_x_Header_Adj_rec := l_Header_Adj_rec;
2814
2815 END Get_Header_Adj_Ids;
2816
2817
2818 PROCEDURE Get_Line_Adj_Ids
2819 ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2820 , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
2821 )
2822 IS
2823 l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2824 --
2825 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2826 --
2827 BEGIN
2828
2829 -- initialize return_status.
2830
2831 l_Line_Adj_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2832
2833 -- initialize l_Line_Adj_rec.
2834
2835 l_Line_Adj_rec := p_x_Line_Adj_rec;
2836
2837 IF p_Line_Adj_val_rec.discount <> FND_API.G_MISS_CHAR
2838 THEN
2839
2840 IF p_x_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM THEN
2841
2842 l_Line_Adj_rec.discount_id := p_x_Line_Adj_rec.discount_id;
2843
2844 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2845 THEN
2846
2847 FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2848 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
2849 FND_MSG_PUB.Add;
2850
2851 END IF;
2852
2853 ELSE
2854
2855 l_Line_Adj_rec.discount_id := OE_CNCL_Value_To_Id.discount
2856 ( p_discount => p_Line_Adj_val_rec.discount
2857 );
2858
2859 IF l_Line_Adj_rec.discount_id = FND_API.G_MISS_NUM THEN
2860 l_Line_Adj_rec.return_status := FND_API.G_RET_STS_ERROR;
2861 END IF;
2862
2863 END IF;
2864
2865 END IF;
2866
2867
2868 -- RETURN l_Line_Adj_rec;
2869 p_x_Line_Adj_rec := l_Line_Adj_rec;
2870
2871 END Get_Line_Adj_Ids;
2872
2873
2874 -- Procedure Convert_Miss_To_Null....FOR HEADER
2875 -- copied from OEXUHDRB.pls 115.204 to fix bug 3576009...added TP_ATTRIBUTE1-15 and TP_CONTEXT for completeness
2876
2877 PROCEDURE Convert_Miss_To_Null
2878 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2879 )
2880 IS
2881 --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
2882 BEGIN
2883
2884 oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);
2885
2886 IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
2887 p_x_header_rec.accounting_rule_id := NULL;
2888 END IF;
2889
2890 IF p_x_header_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN
2891 p_x_header_rec.accounting_rule_duration := NULL;
2892 END IF;
2893
2894 IF p_x_header_rec.agreement_id = FND_API.G_MISS_NUM THEN
2895 p_x_header_rec.agreement_id := NULL;
2896 END IF;
2897
2898 IF p_x_header_rec.blanket_number = FND_API.G_MISS_NUM THEN
2899 p_x_header_rec.blanket_number := NULL;
2900 END IF;
2901
2902 IF p_x_header_rec.booked_flag = FND_API.G_MISS_CHAR THEN
2903 p_x_header_rec.booked_flag := NULL;
2904 END IF;
2905
2906 IF p_x_header_rec.upgraded_flag = FND_API.G_MISS_CHAR THEN
2907 p_x_header_rec.upgraded_flag := NULL;
2908 END IF;
2909
2910 IF p_x_header_rec.booked_date = FND_API.G_MISS_DATE THEN
2911 p_x_header_rec.booked_date := NULL;
2912 END IF;
2913
2914 IF p_x_header_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
2915 p_x_header_rec.cancelled_flag := NULL;
2916 END IF;
2917
2918 IF p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2919 p_x_header_rec.attribute1 := NULL;
2920 END IF;
2921
2922 IF p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2923 p_x_header_rec.attribute10 := NULL;
2924 END IF;
2925
2926 IF p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2927 p_x_header_rec.attribute11 := NULL;
2928 END IF;
2929
2930 IF p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2931 p_x_header_rec.attribute12 := NULL;
2932 END IF;
2933
2934 IF p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2935 p_x_header_rec.attribute13 := NULL;
2936 END IF;
2937
2938 IF p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2939 p_x_header_rec.attribute14 := NULL;
2940 END IF;
2941
2942 IF p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2943 p_x_header_rec.attribute15 := NULL;
2944 END IF;
2945
2946 IF p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN --For bug 2184255
2947 p_x_header_rec.attribute16 := NULL;
2948 END IF;
2949
2950 IF p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
2951 p_x_header_rec.attribute17 := NULL;
2952 END IF;
2953
2954 IF p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
2955 p_x_header_rec.attribute18 := NULL;
2956 END IF;
2957
2958 IF p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
2959 p_x_header_rec.attribute19 := NULL;
2960 END IF;
2961
2962 IF p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2963 p_x_header_rec.attribute2 := NULL;
2964 END IF;
2965
2966 IF p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN --For bug 2184255
2967 p_x_header_rec.attribute20 := NULL;
2968 END IF;
2969
2970 IF p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2971 p_x_header_rec.attribute3 := NULL;
2972 END IF;
2973
2974 IF p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2975 p_x_header_rec.attribute4 := NULL;
2976 END IF;
2977
2978 IF p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2979 p_x_header_rec.attribute5 := NULL;
2980 END IF;
2981
2982 IF p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2983 p_x_header_rec.attribute6 := NULL;
2984 END IF;
2985
2986 IF p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2987 p_x_header_rec.attribute7 := NULL;
2988 END IF;
2989
2990 IF p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2991 p_x_header_rec.attribute8 := NULL;
2992 END IF;
2993
2994 IF p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2995 p_x_header_rec.attribute9 := NULL;
2996 END IF;
2997
2998 IF p_x_header_rec.context = FND_API.G_MISS_CHAR THEN
2999 p_x_header_rec.context := NULL;
3000 END IF;
3001
3002 IF p_x_header_rec.conversion_rate = FND_API.G_MISS_NUM THEN
3003 p_x_header_rec.conversion_rate := NULL;
3004 END IF;
3005
3006 IF p_x_header_rec.conversion_rate_date = FND_API.G_MISS_DATE THEN
3007 p_x_header_rec.conversion_rate_date := NULL;
3008 END IF;
3009
3010 IF p_x_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN
3011 p_x_header_rec.conversion_type_code := NULL;
3012 END IF;
3013
3014 IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE = FND_API.G_MISS_CHAR THEN
3015 p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := NULL;
3016 END IF;
3017
3018 IF p_x_header_rec.created_by = FND_API.G_MISS_NUM THEN
3019 p_x_header_rec.created_by := NULL;
3020 END IF;
3021
3022 IF p_x_header_rec.creation_date = FND_API.G_MISS_DATE THEN
3023 p_x_header_rec.creation_date := NULL;
3024 END IF;
3025
3026 IF p_x_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN
3027 p_x_header_rec.cust_po_number := NULL;
3028 END IF;
3029
3030 IF p_x_header_rec.default_fulfillment_set = FND_API.G_MISS_CHAR THEN
3031 p_x_header_rec.default_fulfillment_set := NULL;
3032 END IF;
3033
3034 IF p_x_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN
3035 p_x_header_rec.deliver_to_contact_id := NULL;
3036 END IF;
3037
3038 IF p_x_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN
3039 p_x_header_rec.deliver_to_org_id := NULL;
3040 END IF;
3041
3042 IF p_x_header_rec.demand_class_code = FND_API.G_MISS_CHAR THEN
3043 p_x_header_rec.demand_class_code := NULL;
3044 END IF;
3045
3046 IF p_x_header_rec.expiration_date = FND_API.G_MISS_DATE THEN
3047 p_x_header_rec.expiration_date := NULL;
3048 END IF;
3049
3050 IF p_x_header_rec.earliest_schedule_limit = FND_API.G_MISS_NUM THEN
3051 p_x_header_rec.earliest_schedule_limit := NULL;
3052 END IF;
3053
3054 IF p_x_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN
3055 p_x_header_rec.fob_point_code := NULL;
3056 END IF;
3057
3058 IF p_x_header_rec.freight_carrier_code = FND_API.G_MISS_CHAR THEN
3059 p_x_header_rec.freight_carrier_code := NULL;
3060 END IF;
3061
3062 IF p_x_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
3063 p_x_header_rec.freight_terms_code := NULL;
3064 END IF;
3065
3066 IF p_x_header_rec.fulfillment_set_name = FND_API.G_MISS_CHAR THEN
3067 p_x_header_rec.fulfillment_set_name := NULL;
3068 END IF;
3069
3070 IF p_x_header_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
3071 p_x_header_rec.global_attribute1 := NULL;
3072 END IF;
3073
3074 IF p_x_header_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
3075 p_x_header_rec.global_attribute10 := NULL;
3076 END IF;
3077
3078 IF p_x_header_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
3079 p_x_header_rec.global_attribute11 := NULL;
3080 END IF;
3081
3082 IF p_x_header_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
3083 p_x_header_rec.global_attribute12 := NULL;
3084 END IF;
3085
3086 IF p_x_header_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
3087 p_x_header_rec.global_attribute13 := NULL;
3088 END IF;
3089
3090 IF p_x_header_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
3091 p_x_header_rec.global_attribute14 := NULL;
3092 END IF;
3093
3094 IF p_x_header_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
3095 p_x_header_rec.global_attribute15 := NULL;
3096 END IF;
3097
3098 IF p_x_header_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
3099 p_x_header_rec.global_attribute16 := NULL;
3100 END IF;
3101
3102 IF p_x_header_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
3103 p_x_header_rec.global_attribute17 := NULL;
3104 END IF;
3105
3106 IF p_x_header_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
3107 p_x_header_rec.global_attribute18 := NULL;
3108 END IF;
3109
3110 IF p_x_header_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
3111 p_x_header_rec.global_attribute19 := NULL;
3112 END IF;
3113
3114 IF p_x_header_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
3115 p_x_header_rec.global_attribute2 := NULL;
3116 END IF;
3117
3118 IF p_x_header_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
3119 p_x_header_rec.global_attribute20 := NULL;
3120 END IF;
3121
3122 IF p_x_header_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
3123 p_x_header_rec.global_attribute3 := NULL;
3124 END IF;
3125
3126 IF p_x_header_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
3127 p_x_header_rec.global_attribute4 := NULL;
3128 END IF;
3129
3130 IF p_x_header_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
3131 p_x_header_rec.global_attribute5 := NULL;
3132 END IF;
3133
3134 IF p_x_header_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
3135 p_x_header_rec.global_attribute6 := NULL;
3136 END IF;
3137
3138 IF p_x_header_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
3139 p_x_header_rec.global_attribute7 := NULL;
3140 END IF;
3141
3142 IF p_x_header_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
3143 p_x_header_rec.global_attribute8 := NULL;
3144 END IF;
3145
3146 IF p_x_header_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
3147 p_x_header_rec.global_attribute9 := NULL;
3148 END IF;
3149
3150 IF p_x_header_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
3151 p_x_header_rec.global_attribute_category := NULL;
3152 END IF;
3153
3154 IF p_x_header_rec.header_id = FND_API.G_MISS_NUM THEN
3155 p_x_header_rec.header_id := NULL;
3156 END IF;
3157
3158 IF p_x_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN
3159 p_x_header_rec.invoice_to_contact_id := NULL;
3160 END IF;
3161
3162 IF p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
3163 p_x_header_rec.invoice_to_org_id := NULL;
3164 END IF;
3165
3166 IF p_x_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
3167 p_x_header_rec.invoicing_rule_id := NULL;
3168 END IF;
3169
3170 IF p_x_header_rec.last_updated_by = FND_API.G_MISS_NUM THEN
3171 p_x_header_rec.last_updated_by := NULL;
3172 END IF;
3173
3174 IF p_x_header_rec.last_update_date = FND_API.G_MISS_DATE THEN
3175 p_x_header_rec.last_update_date := NULL;
3176 END IF;
3177
3178 IF p_x_header_rec.last_update_login = FND_API.G_MISS_NUM THEN
3179 p_x_header_rec.last_update_login := NULL;
3180 END IF;
3181
3182
3183 IF p_x_header_rec.latest_schedule_limit = FND_API.G_MISS_NUM THEN
3184 p_x_header_rec.latest_schedule_limit := NULL;
3185 END IF;
3186
3187 IF p_x_header_rec.line_set_name = FND_API.G_MISS_CHAR THEN
3188 p_x_header_rec.line_set_name := NULL;
3189 END IF;
3190
3191 IF p_x_header_rec.open_flag = FND_API.G_MISS_CHAR THEN
3192 p_x_header_rec.open_flag := NULL;
3193 END IF;
3194
3195 IF p_x_header_rec.ordered_date = FND_API.G_MISS_DATE THEN
3196 p_x_header_rec.ordered_date := NULL;
3197 END IF;
3198
3199 IF p_x_header_rec.order_date_type_code = FND_API.G_MISS_CHAR THEN
3200 p_x_header_rec.order_date_type_code := NULL;
3201 END IF;
3202
3203 IF p_x_header_rec.order_number = FND_API.G_MISS_NUM THEN
3204 p_x_header_rec.order_number := NULL;
3205 END IF;
3206
3207 IF p_x_header_rec.order_source_id = FND_API.G_MISS_NUM THEN
3208 p_x_header_rec.order_source_id := NULL;
3209 END IF;
3210
3211 IF p_x_header_rec.order_type_id = FND_API.G_MISS_NUM THEN
3212 p_x_header_rec.order_type_id := NULL;
3213 END IF;
3214 IF p_x_header_rec.order_category_code = FND_API.G_MISS_CHAR THEN
3215 p_x_header_rec.order_category_code := NULL;
3216 END IF;
3217
3218 IF p_x_header_rec.org_id = FND_API.G_MISS_NUM THEN
3219 p_x_header_rec.org_id := NULL;
3220 END IF;
3221
3222 IF p_x_header_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR THEN
3223 p_x_header_rec.orig_sys_document_ref := NULL;
3224 END IF;
3225
3226 IF p_x_header_rec.partial_shipments_allowed = FND_API.G_MISS_CHAR THEN
3227 p_x_header_rec.partial_shipments_allowed := NULL;
3228 END IF;
3229
3230 IF p_x_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN
3231 p_x_header_rec.payment_term_id := NULL;
3232 END IF;
3233
3234 IF p_x_header_rec.price_list_id = FND_API.G_MISS_NUM THEN
3235 p_x_header_rec.price_list_id := NULL;
3236 END IF;
3237
3238 IF p_x_header_rec.price_request_code = FND_API.G_MISS_CHAR THEN -- PROMOTIONS SEP/01
3239 p_x_header_rec.price_request_code := NULL;
3240 END IF;
3241
3242 IF p_x_header_rec.pricing_date = FND_API.G_MISS_DATE THEN
3243 p_x_header_rec.pricing_date := NULL;
3244 END IF;
3245
3246 IF p_x_header_rec.program_application_id = FND_API.G_MISS_NUM THEN
3247 p_x_header_rec.program_application_id := NULL;
3248 END IF;
3249
3250 IF p_x_header_rec.program_id = FND_API.G_MISS_NUM THEN
3251 p_x_header_rec.program_id := NULL;
3252 END IF;
3253
3254 IF p_x_header_rec.program_update_date = FND_API.G_MISS_DATE THEN
3255 p_x_header_rec.program_update_date := NULL;
3256 END IF;
3257
3258 IF p_x_header_rec.request_date = FND_API.G_MISS_DATE THEN
3259 p_x_header_rec.request_date := NULL;
3260 END IF;
3261
3262 IF p_x_header_rec.request_id = FND_API.G_MISS_NUM THEN
3263 p_x_header_rec.request_id := NULL;
3264 END IF;
3265
3266 IF p_x_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN
3267 p_x_header_rec.return_reason_code := NULL;
3268 END IF;
3269
3270 IF p_x_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN
3271 p_x_header_rec.salesrep_id := NULL;
3272 END IF;
3273
3274 IF p_x_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN
3275 p_x_header_rec.sales_channel_code := NULL;
3276 END IF;
3277
3278 IF p_x_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN
3279 p_x_header_rec.shipment_priority_code := NULL;
3280 END IF;
3281
3282 IF p_x_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN
3283 p_x_header_rec.shipping_method_code := NULL;
3284 END IF;
3285
3286 IF p_x_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
3287 p_x_header_rec.ship_from_org_id := NULL;
3288 END IF;
3289
3290 IF p_x_header_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN
3291 p_x_header_rec.ship_tolerance_above := NULL;
3292 END IF;
3293
3294 IF p_x_header_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN
3295 p_x_header_rec.ship_tolerance_below := NULL;
3296 END IF;
3297
3298 IF p_x_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN
3299 p_x_header_rec.ship_to_contact_id := NULL;
3300 END IF;
3301
3302 IF p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN
3303 p_x_header_rec.ship_to_org_id := NULL;
3304 END IF;
3305
3306 IF p_x_header_rec.sold_from_org_id = FND_API.G_MISS_NUM THEN
3307 p_x_header_rec.sold_from_org_id := NULL;
3308 END IF;
3309
3310 IF p_x_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN
3311 p_x_header_rec.sold_to_contact_id := NULL;
3312 END IF;
3313
3314 IF p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
3315 p_x_header_rec.sold_to_org_id := NULL;
3316 END IF;
3317
3318 IF p_x_header_rec.sold_to_phone_id = FND_API.G_MISS_NUM THEN
3319 p_x_header_rec.sold_to_phone_id := NULL;
3320 END IF;
3321
3322 IF p_x_header_rec.source_document_id = FND_API.G_MISS_NUM THEN
3323 p_x_header_rec.source_document_id := NULL;
3324 END IF;
3325
3326 IF p_x_header_rec.source_document_type_id = FND_API.G_MISS_NUM THEN
3327 p_x_header_rec.source_document_type_id := NULL;
3328 END IF;
3329
3330 IF p_x_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN
3331 p_x_header_rec.tax_exempt_flag := NULL;
3332 END IF;
3333
3334 IF p_x_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN
3335 p_x_header_rec.tax_exempt_number := NULL;
3336 END IF;
3337
3338 IF p_x_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN
3339 p_x_header_rec.tax_exempt_reason_code := NULL;
3340 END IF;
3341
3342 IF p_x_header_rec.tax_point_code = FND_API.G_MISS_CHAR THEN
3343 p_x_header_rec.tax_point_code := NULL;
3344 END IF;
3345
3346
3347 IF p_x_header_rec.TP_ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
3348 p_x_header_rec.TP_ATTRIBUTE1 := NULL;
3349 END IF;
3350
3351 IF p_x_header_rec.TP_ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
3352 p_x_header_rec.TP_ATTRIBUTE10 := NULL;
3353 END IF;
3354
3355 IF p_x_header_rec.TP_ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
3356 p_x_header_rec.TP_ATTRIBUTE11 := NULL;
3357 END IF;
3358
3359 IF p_x_header_rec.TP_ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
3360 p_x_header_rec.TP_ATTRIBUTE12 := NULL;
3361 END IF;
3362
3363 IF p_x_header_rec.TP_ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
3364 p_x_header_rec.TP_ATTRIBUTE13 := NULL;
3365 END IF;
3366
3367 IF p_x_header_rec.TP_ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
3368 p_x_header_rec.TP_ATTRIBUTE14 := NULL;
3369 END IF;
3370
3371 IF p_x_header_rec.TP_ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3372 p_x_header_rec.TP_ATTRIBUTE15 := NULL;
3373 END IF;
3374
3375 IF p_x_header_rec.TP_ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
3376 p_x_header_rec.TP_ATTRIBUTE2 := NULL;
3377 END IF;
3378
3379 IF p_x_header_rec.TP_ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
3380 p_x_header_rec.TP_ATTRIBUTE3 := NULL;
3381 END IF;
3382
3383 IF p_x_header_rec.TP_ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
3384 p_x_header_rec.TP_ATTRIBUTE4 := NULL;
3385 END IF;
3386
3387 IF p_x_header_rec.TP_ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
3388 p_x_header_rec.TP_ATTRIBUTE5 := NULL;
3389 END IF;
3390
3391 IF p_x_header_rec.TP_ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
3392 p_x_header_rec.TP_ATTRIBUTE6 := NULL;
3393 END IF;
3394
3395 IF p_x_header_rec.TP_ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
3396 p_x_header_rec.TP_ATTRIBUTE7 := NULL;
3397 END IF;
3398
3399 IF p_x_header_rec.TP_ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
3400 p_x_header_rec.TP_ATTRIBUTE8 := NULL;
3401 END IF;
3402
3403 IF p_x_header_rec.TP_ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
3404 p_x_header_rec.TP_ATTRIBUTE9 := NULL;
3405 END IF;
3406
3407 IF p_x_header_rec.TP_CONTEXT = FND_API.G_MISS_CHAR THEN
3408 p_x_header_rec.TP_CONTEXT := NULL;
3409 END IF;
3410
3411 IF p_x_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN
3412 p_x_header_rec.transactional_curr_code := NULL;
3413 END IF;
3414
3415 IF p_x_header_rec.version_number = FND_API.G_MISS_NUM THEN
3416 p_x_header_rec.version_number := NULL;
3417 END IF;
3418
3419 IF p_x_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3420 p_x_header_rec.payment_type_code := NULL;
3421 END IF;
3422
3423 IF p_x_header_rec.payment_amount = FND_API.G_MISS_NUM THEN
3424 p_x_header_rec.payment_amount := NULL;
3425 END IF;
3426
3427 IF p_x_header_rec.check_number = FND_API.G_MISS_CHAR THEN
3428 p_x_header_rec.check_number := NULL;
3429 END IF;
3430
3431 IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
3432 p_x_header_rec.credit_card_code := NULL;
3433 END IF;
3434
3435 IF p_x_header_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
3436 p_x_header_rec.credit_card_holder_name := NULL;
3437 END IF;
3438
3439 IF p_x_header_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
3440 p_x_header_rec.credit_card_number := NULL;
3441 END IF;
3442
3443 IF p_x_header_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
3444 p_x_header_rec.credit_card_expiration_date := NULL;
3445 END IF;
3446
3447 IF p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
3448 p_x_header_rec.credit_card_approval_date := NULL;
3449 END IF;
3450
3451 IF p_x_header_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
3452 p_x_header_rec.credit_card_approval_code := NULL;
3453 END IF;
3454
3455 IF p_x_header_rec.first_ack_code = FND_API.G_MISS_CHAR THEN
3456 p_x_header_rec.first_ack_code := NULL;
3457 END IF;
3458
3459 IF p_x_header_rec.first_ack_date = FND_API.G_MISS_DATE THEN
3460 p_x_header_rec.first_ack_date := NULL;
3461 END IF;
3462
3463 IF p_x_header_rec.last_ack_code = FND_API.G_MISS_CHAR THEN
3464 p_x_header_rec.last_ack_code := NULL;
3465 END IF;
3466
3467 IF p_x_header_rec.last_ack_date = FND_API.G_MISS_DATE THEN
3468 p_x_header_rec.last_ack_date := NULL;
3469 END IF;
3470
3471 IF p_x_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN
3472 p_x_header_rec.shipping_instructions := NULL;
3473 END IF;
3474
3475 IF p_x_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN
3476 p_x_header_rec.packing_instructions := NULL;
3477 END IF;
3478
3479 IF p_x_header_rec.flow_status_code = FND_API.G_MISS_CHAR THEN
3480 p_x_header_rec.flow_status_code := NULL;
3481 END IF;
3482
3483 IF p_x_header_rec.marketing_source_code_id = FND_API.G_MISS_NUM THEN
3484 p_x_header_rec.marketing_source_code_id := NULL;
3485 END IF;
3486
3487 IF p_x_header_rec.change_sequence = FND_API.G_MISS_CHAR THEN --2416561
3488 p_x_header_rec.change_sequence := NULL;
3489 END IF;
3490
3491 -- QUOTING changes
3492
3493 IF p_x_header_rec.quote_date = FND_API.G_MISS_DATE THEN
3494 p_x_header_rec.quote_date := NULL;
3495 END IF;
3496
3497 IF p_x_header_rec.quote_number = FND_API.G_MISS_NUM THEN
3498 p_x_header_rec.quote_number := NULL;
3499 END IF;
3500
3501 IF p_x_header_rec.sales_document_name = FND_API.G_MISS_CHAR THEN
3502 p_x_header_rec.sales_document_name := NULL;
3503 END IF;
3504
3505 IF p_x_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN
3506 p_x_header_rec.transaction_phase_code := NULL;
3507 END IF;
3508
3509 IF p_x_header_rec.user_status_code = FND_API.G_MISS_CHAR THEN
3510 p_x_header_rec.user_status_code := NULL;
3511 END IF;
3512
3513 IF p_x_header_rec.draft_submitted_flag = FND_API.G_MISS_CHAR THEN
3514 p_x_header_rec.draft_submitted_flag := NULL;
3515 END IF;
3516
3517 IF p_x_header_rec.source_document_version_number = FND_API.G_MISS_NUM THEN
3518 p_x_header_rec.source_document_version_number := NULL;
3519 END IF;
3520
3521 IF p_x_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN
3522 p_x_header_rec.sold_to_site_use_id := NULL;
3523 END IF;
3524
3525 -- QUOTING changes END
3526
3527 IF p_x_header_rec.Minisite_id = FND_API.G_MISS_NUM THEN
3528 p_x_header_rec.Minisite_id := NULL;
3529 END IF;
3530
3531 IF p_x_header_rec.End_customer_id = FND_API.G_MISS_NUM THEN
3532 p_x_header_rec.End_customer_id := NULL;
3533 END IF;
3534
3535 IF p_x_header_rec.End_customer_contact_id = FND_API.G_MISS_NUM THEN
3536 p_x_header_rec.End_customer_contact_id := NULL;
3537 END IF;
3538
3539 IF p_x_header_rec.End_customer_site_use_id = FND_API.G_MISS_NUM THEN
3540 p_x_header_rec.End_customer_site_use_id := NULL;
3541 END IF;
3542
3543 IF p_x_header_rec.Ib_owner = FND_API.G_MISS_CHAR THEN
3544 p_x_header_rec.Ib_owner := NULL;
3545 END IF;
3546
3547 IF p_x_header_rec.Ib_installed_at_location = FND_API.G_MISS_CHAR THEN
3548 p_x_header_rec.Ib_installed_at_location := NULL;
3549 END IF;
3550
3551 IF p_x_header_rec.Ib_current_location = FND_API.G_MISS_CHAR THEN
3552 p_x_header_rec.Ib_current_location := NULL;
3553 END IF;
3554
3555 IF p_x_header_rec.supplier_signature = FND_API.G_MISS_CHAR THEN
3556 p_x_header_rec.supplier_signature := NULL;
3557 END IF;
3558
3559 IF p_x_header_rec.supplier_signature_date = FND_API.G_MISS_DATE THEN
3560 p_x_header_rec.supplier_signature_date := NULL;
3561 END IF;
3562
3563 IF p_x_header_rec.customer_signature = FND_API.G_MISS_CHAR THEN
3564 p_x_header_rec.customer_signature := NULL;
3565 END IF;
3566
3567 IF p_x_header_rec.customer_signature_date = FND_API.G_MISS_DATE THEN
3568 p_x_header_rec.customer_signature_date := NULL;
3569 END IF;
3570
3571 IF p_x_header_rec.contract_template_id = FND_API.G_MISS_NUM THEN
3572 p_x_header_rec.contract_template_id := NULL;
3573 END IF;
3574
3575 IF p_x_header_rec.contract_source_doc_type_code = FND_API.G_MISS_CHAR THEN
3576 p_x_header_rec.contract_source_doc_type_code := NULL;
3577 END IF;
3578
3579 IF p_x_header_rec.contract_source_document_id = FND_API.G_MISS_NUM THEN
3580 p_x_header_rec.contract_source_document_id := NULL;
3581 END IF;
3582
3583 --key Transaction dates
3584 IF p_x_header_rec.order_firmed_date = FND_API.G_MISS_DATE THEN
3585 p_x_header_rec.order_firmed_date := NULL;
3586 END IF;
3587
3588 oe_debug_pub.add('Exiting OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);
3589
3590
3591 END Convert_Miss_To_Null;
3592
3593
3594 -- Procedure Convert_Miss_To_Null...FOR LINE
3595 -- copied from OEXULINB.pls 115.574 to fix bug 3576009...added CHANGE_SEQUENCE, CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID, and USER_ITEM_DESCRIPTION for completeness
3596
3597
3598 PROCEDURE Convert_Miss_To_Null
3599 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3600 )
3601 IS
3602 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3603 BEGIN
3604
3605 if l_debug_level > 0 then
3606 oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE', 1);
3607
3608 oe_debug_pub.add('outside margin convert miss to null',1);
3609 end if;
3610 --MRG BGN
3611 IF OE_FEATURES_PVT.Is_Margin_Avail Then
3612 if l_debug_level > 0 then
3613 oe_debug_pub.add('inside margin convert miss to null',1);
3614 end if;
3615 IF p_x_line_rec.unit_cost = FND_API.G_MISS_NUM THEN
3616 p_x_line_rec.unit_cost := NULL;
3617 END IF;
3618 END IF;
3619 --MRG END
3620
3621
3622 IF p_x_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
3623 p_x_line_rec.accounting_rule_id := NULL;
3624 END IF;
3625
3626 IF p_x_line_rec.accounting_rule_duration = FND_API.G_MISS_NUM THEN
3627 p_x_line_rec.accounting_rule_duration := NULL;
3628 END IF;
3629
3630 IF p_x_line_rec.actual_arrival_date = FND_API.G_MISS_DATE THEN
3631 p_x_line_rec.actual_arrival_date := NULL;
3632 END IF;
3633
3634 IF p_x_line_rec.actual_shipment_date = FND_API.G_MISS_DATE THEN
3635 p_x_line_rec.actual_shipment_date := NULL;
3636 END IF;
3637
3638 IF p_x_line_rec.agreement_id = FND_API.G_MISS_NUM THEN
3639 p_x_line_rec.agreement_id := NULL;
3640 END IF;
3641 IF p_x_line_rec.arrival_set_id = FND_API.G_MISS_NUM THEN
3642 p_x_line_rec.arrival_set_id := NULL;
3643 END IF;
3644
3645 IF p_x_line_rec.ato_line_id = FND_API.G_MISS_NUM THEN
3646 p_x_line_rec.ato_line_id := NULL;
3647 END IF;
3648 IF p_x_line_rec.upgraded_flag = FND_API.G_MISS_CHAR THEN
3649 p_x_line_rec.upgraded_flag := NULL;
3650 END IF;
3651
3652 IF p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
3653 p_x_line_rec.attribute1 := NULL;
3654 END IF;
3655
3656 IF p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
3657 p_x_line_rec.attribute10 := NULL;
3658 END IF;
3659
3660 IF p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
3661 p_x_line_rec.attribute11 := NULL;
3662 END IF;
3663
3664 IF p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
3665 p_x_line_rec.attribute12 := NULL;
3666 END IF;
3667
3668 IF p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
3669 p_x_line_rec.attribute13 := NULL;
3670 END IF;
3671
3672 IF p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
3673 p_x_line_rec.attribute14 := NULL;
3674 END IF;
3675
3676 IF p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
3677 p_x_line_rec.attribute15 := NULL;
3678 END IF;
3679
3680 IF p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN --For bug 2184255
3681 p_x_line_rec.attribute16 := NULL;
3682 END IF;
3683
3684 IF p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
3685 p_x_line_rec.attribute17 := NULL;
3686 END IF;
3687
3688 IF p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
3689 p_x_line_rec.attribute18 := NULL;
3690 END IF;
3691
3692 IF p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
3693 p_x_line_rec.attribute19 := NULL;
3694 END IF;
3695
3696 IF p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
3697 p_x_line_rec.attribute2 := NULL;
3698 END IF;
3699
3700 IF p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
3701 p_x_line_rec.attribute20 := NULL;
3702 END IF;
3703
3704 IF p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
3705 p_x_line_rec.attribute3 := NULL;
3706 END IF;
3707
3708 IF p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
3709 p_x_line_rec.attribute4 := NULL;
3710 END IF;
3711
3712 IF p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
3713 p_x_line_rec.attribute5 := NULL;
3714 END IF;
3715
3716 IF p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
3717 p_x_line_rec.attribute6 := NULL;
3718 END IF;
3719
3720 IF p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
3721 p_x_line_rec.attribute7 := NULL;
3722 END IF;
3723
3724 IF p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
3725 p_x_line_rec.attribute8 := NULL;
3726 END IF;
3727
3728 IF p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
3729 p_x_line_rec.attribute9 := NULL;
3730 END IF;
3731
3732 IF p_x_line_rec.auto_selected_quantity = FND_API.G_MISS_NUM THEN
3733 p_x_line_rec.auto_selected_quantity := NULL;
3734 END IF;
3735 IF p_x_line_rec.authorized_to_ship_flag = FND_API.G_MISS_CHAR THEN
3736 p_x_line_rec.authorized_to_ship_flag := NULL;
3737 END IF;
3738
3739 IF p_x_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
3740 p_x_line_rec.booked_flag := NULL;
3741 END IF;
3742
3743 IF p_x_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
3744 p_x_line_rec.cancelled_flag := NULL;
3745 END IF;
3746
3747 IF p_x_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN
3748 p_x_line_rec.cancelled_quantity := NULL;
3749 END IF;
3750
3751 IF p_x_line_rec.component_code = FND_API.G_MISS_CHAR THEN
3752 p_x_line_rec.component_code := NULL;
3753 END IF;
3754
3755 IF p_x_line_rec.component_number = FND_API.G_MISS_NUM THEN
3756 p_x_line_rec.component_number := NULL;
3757 END IF;
3758
3759 IF p_x_line_rec.component_sequence_id = FND_API.G_MISS_NUM THEN
3760 p_x_line_rec.component_sequence_id := NULL;
3761 END IF;
3762
3763 IF p_x_line_rec.config_header_id = FND_API.G_MISS_NUM THEN
3764 p_x_line_rec.config_header_id := NULL;
3765 END IF;
3766
3767 IF p_x_line_rec.config_rev_nbr = FND_API.G_MISS_NUM THEN
3768 p_x_line_rec.config_rev_nbr := NULL;
3769 END IF;
3770
3771 IF p_x_line_rec.config_display_sequence = FND_API.G_MISS_NUM THEN
3772 p_x_line_rec.config_display_sequence := NULL;
3773 END IF;
3774
3775 IF p_x_line_rec.configuration_id = FND_API.G_MISS_NUM THEN
3776 p_x_line_rec.configuration_id := NULL;
3777 END IF;
3778
3779 IF p_x_line_rec.context = FND_API.G_MISS_CHAR THEN
3780 p_x_line_rec.context := NULL;
3781 END IF;
3782
3783 --Bug 6661371
3784 --Recurring charges
3785 IF p_x_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR THEN
3786 p_x_line_rec.charge_periodicity_code := NULL;
3787 END IF;
3788
3789 IF p_x_line_rec.created_by = FND_API.G_MISS_NUM THEN
3790 p_x_line_rec.created_by := NULL;
3791 END IF;
3792
3793 IF p_x_line_rec.creation_date = FND_API.G_MISS_DATE THEN
3794 p_x_line_rec.creation_date := NULL;
3795 END IF;
3796
3797 IF p_x_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM THEN
3798 p_x_line_rec.credit_invoice_line_id := NULL;
3799 END IF;
3800
3801 IF p_x_line_rec.customer_dock_code = FND_API.G_MISS_CHAR THEN
3802 p_x_line_rec.customer_dock_code := NULL;
3803 END IF;
3804
3805 IF p_x_line_rec.customer_job = FND_API.G_MISS_CHAR THEN
3806 p_x_line_rec.customer_job := NULL;
3807 END IF;
3808
3809 IF p_x_line_rec.customer_production_line = FND_API.G_MISS_CHAR THEN
3810 p_x_line_rec.customer_production_line := NULL;
3811 END IF;
3812
3813 IF p_x_line_rec.cust_production_seq_num = FND_API.G_MISS_CHAR THEN
3814 p_x_line_rec.cust_production_seq_num := NULL;
3815 END IF;
3816
3817 IF p_x_line_rec.customer_trx_line_id = FND_API.G_MISS_NUM THEN
3818 p_x_line_rec.customer_trx_line_id := NULL;
3819 END IF;
3820
3821 IF p_x_line_rec.cust_model_serial_number = FND_API.G_MISS_CHAR THEN
3822 p_x_line_rec.cust_model_serial_number := NULL;
3823 END IF;
3824
3825 IF p_x_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN
3826 p_x_line_rec.cust_po_number := NULL;
3827 END IF;
3828
3829 IF p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR THEN
3830 p_x_line_rec.customer_line_number := NULL;
3831 END IF;
3832
3833 IF p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR THEN
3834 p_x_line_rec.customer_shipment_number := NULL;
3835 END IF;
3836
3837 IF p_x_line_rec.delivery_lead_time = FND_API.G_MISS_NUM THEN
3838 p_x_line_rec.delivery_lead_time := NULL;
3839 END IF;
3840
3841 IF p_x_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM THEN
3842 p_x_line_rec.deliver_to_contact_id := NULL;
3843 END IF;
3844
3845 IF p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN
3846 p_x_line_rec.deliver_to_org_id := NULL;
3847 END IF;
3848
3849 IF p_x_line_rec.demand_bucket_type_code = FND_API.G_MISS_CHAR THEN
3850 p_x_line_rec.demand_bucket_type_code := NULL;
3851 END IF;
3852
3853 IF p_x_line_rec.demand_class_code = FND_API.G_MISS_CHAR THEN
3854 p_x_line_rec.demand_class_code := NULL;
3855 END IF;
3856
3857 IF p_x_line_rec.dep_plan_required_flag = FND_API.G_MISS_CHAR THEN
3858 p_x_line_rec.dep_plan_required_flag := NULL;
3859 END IF;
3860
3861
3862 IF p_x_line_rec.earliest_acceptable_date = FND_API.G_MISS_DATE THEN
3863 p_x_line_rec.earliest_acceptable_date := NULL;
3864 END IF;
3865
3866 IF p_x_line_rec.explosion_date = FND_API.G_MISS_DATE THEN
3867 p_x_line_rec.explosion_date := NULL;
3868 END IF;
3869
3870 IF p_x_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN
3871 p_x_line_rec.fob_point_code := NULL;
3872 END IF;
3873
3874 IF p_x_line_rec.freight_carrier_code = FND_API.G_MISS_CHAR THEN
3875 p_x_line_rec.freight_carrier_code := NULL;
3876 END IF;
3877
3878 IF p_x_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
3879 p_x_line_rec.freight_terms_code := NULL;
3880 END IF;
3881
3882 IF p_x_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN
3883 p_x_line_rec.fulfilled_quantity := NULL;
3884 END IF;
3885
3886 IF p_x_line_rec.fulfilled_flag = FND_API.G_MISS_CHAR THEN
3887 p_x_line_rec.fulfilled_flag := NULL;
3888 END IF;
3889
3890 IF p_x_line_rec.fulfillment_method_code = FND_API.G_MISS_CHAR THEN
3891 p_x_line_rec.fulfillment_method_code := NULL;
3892 END IF;
3893
3894 IF p_x_line_rec.fulfillment_date = FND_API.G_MISS_DATE THEN
3895 p_x_line_rec.fulfillment_date := NULL;
3896 END IF;
3897
3898 IF p_x_line_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
3899 p_x_line_rec.global_attribute1 := NULL;
3900 END IF;
3901
3902 IF p_x_line_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
3903 p_x_line_rec.global_attribute10 := NULL;
3904 END IF;
3905
3906 IF p_x_line_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
3907 p_x_line_rec.global_attribute11 := NULL;
3908 END IF;
3909
3910 IF p_x_line_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
3911 p_x_line_rec.global_attribute12 := NULL;
3912 END IF;
3913
3914 IF p_x_line_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
3915 p_x_line_rec.global_attribute13 := NULL;
3916 END IF;
3917
3918 IF p_x_line_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
3919 p_x_line_rec.global_attribute14 := NULL;
3920 END IF;
3921
3922 IF p_x_line_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
3923 p_x_line_rec.global_attribute15 := NULL;
3924 END IF;
3925
3926 IF p_x_line_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
3927 p_x_line_rec.global_attribute16 := NULL;
3928 END IF;
3929
3930 IF p_x_line_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
3931 p_x_line_rec.global_attribute17 := NULL;
3932 END IF;
3933
3934 IF p_x_line_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
3935 p_x_line_rec.global_attribute18 := NULL;
3936 END IF;
3937
3938 IF p_x_line_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
3939 p_x_line_rec.global_attribute19 := NULL;
3940 END IF;
3941
3942 IF p_x_line_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
3943 p_x_line_rec.global_attribute2 := NULL;
3944 END IF;
3945
3946 IF p_x_line_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
3947 p_x_line_rec.global_attribute20 := NULL;
3948 END IF;
3949
3950 IF p_x_line_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
3951 p_x_line_rec.global_attribute3 := NULL;
3952 END IF;
3953
3954 IF p_x_line_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
3955 p_x_line_rec.global_attribute4 := NULL;
3956 END IF;
3957
3958 IF p_x_line_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
3959 p_x_line_rec.global_attribute5 := NULL;
3960 END IF;
3961
3962 IF p_x_line_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
3963 p_x_line_rec.global_attribute6 := NULL;
3964 END IF;
3965
3966 IF p_x_line_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
3967 p_x_line_rec.global_attribute7 := NULL;
3968 END IF;
3969
3970 IF p_x_line_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
3971 p_x_line_rec.global_attribute8 := NULL;
3972 END IF;
3973
3974 IF p_x_line_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
3975 p_x_line_rec.global_attribute9 := NULL;
3976 END IF;
3977
3978 IF p_x_line_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
3979 p_x_line_rec.global_attribute_category := NULL;
3980 END IF;
3981
3982 IF p_x_line_rec.header_id = FND_API.G_MISS_NUM THEN
3983 p_x_line_rec.header_id := NULL;
3984 END IF;
3985
3986 IF p_x_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN
3987 p_x_line_rec.industry_attribute1 := NULL;
3988 END IF;
3989
3990 IF p_x_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN
3991 p_x_line_rec.industry_attribute10 := NULL;
3992 END IF;
3993
3994 IF p_x_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN
3995 p_x_line_rec.industry_attribute11 := NULL;
3996 END IF;
3997
3998 IF p_x_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN
3999 p_x_line_rec.industry_attribute12 := NULL;
4000 END IF;
4001
4002 IF p_x_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN
4003 p_x_line_rec.industry_attribute13 := NULL;
4004 END IF;
4005
4006 IF p_x_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN
4007 p_x_line_rec.industry_attribute14 := NULL;
4008 END IF;
4009
4010 IF p_x_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN
4011 p_x_line_rec.industry_attribute15 := NULL;
4012 END IF;
4013
4014 IF p_x_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
4015 p_x_line_rec.industry_attribute16 := NULL;
4016 END IF;
4017 IF p_x_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN
4018 p_x_line_rec.industry_attribute17 := NULL;
4019 END IF;
4020 IF p_x_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN
4021 p_x_line_rec.industry_attribute18 := NULL;
4022 END IF;
4023 IF p_x_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN
4024 p_x_line_rec.industry_attribute19 := NULL;
4025 END IF;
4026 IF p_x_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN
4027 p_x_line_rec.industry_attribute20 := NULL;
4028 END IF;
4029 IF p_x_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN
4030 p_x_line_rec.industry_attribute21 := NULL;
4031 END IF;
4032 IF p_x_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN
4033 p_x_line_rec.industry_attribute22 := NULL;
4034 END IF;
4035 IF p_x_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN
4036 p_x_line_rec.industry_attribute23 := NULL;
4037 END IF;
4038 IF p_x_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN
4039 p_x_line_rec.industry_attribute24 := NULL;
4040 END IF;
4041 IF p_x_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN
4042 p_x_line_rec.industry_attribute25 := NULL;
4043 END IF;
4044 IF p_x_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
4045 p_x_line_rec.industry_attribute26 := NULL;
4046 END IF;
4047 IF p_x_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN
4048 p_x_line_rec.industry_attribute27 := NULL;
4049 END IF;
4050 IF p_x_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN
4051 p_x_line_rec.industry_attribute28 := NULL;
4052 END IF;
4053 IF p_x_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN
4054 p_x_line_rec.industry_attribute29 := NULL;
4055 END IF;
4056 IF p_x_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN
4057 p_x_line_rec.industry_attribute30 := NULL;
4058 END IF;
4059
4060
4061 IF p_x_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN
4062 p_x_line_rec.industry_attribute2 := NULL;
4063 END IF;
4064
4065 IF p_x_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN
4066 p_x_line_rec.industry_attribute3 := NULL;
4067 END IF;
4068
4069 IF p_x_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN
4070 p_x_line_rec.industry_attribute4 := NULL;
4071 END IF;
4072
4073 IF p_x_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN
4074 p_x_line_rec.industry_attribute5 := NULL;
4075 END IF;
4076
4077 IF p_x_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN
4078 p_x_line_rec.industry_attribute6 := NULL;
4079 END IF;
4080
4081 IF p_x_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN
4082 p_x_line_rec.industry_attribute7 := NULL;
4083 END IF;
4084
4085 IF p_x_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN
4086 p_x_line_rec.industry_attribute8 := NULL;
4087 END IF;
4088
4089 IF p_x_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN
4090 p_x_line_rec.industry_attribute9 := NULL;
4091 END IF;
4092
4093 IF p_x_line_rec.industry_context = FND_API.G_MISS_CHAR THEN
4094 p_x_line_rec.industry_context := NULL;
4095 END IF;
4096
4097 /* TP_ATTRIBUTE */
4098 IF p_x_line_rec.tp_context = FND_API.G_MISS_CHAR THEN
4099 p_x_line_rec.tp_context := NULL;
4100 END IF;
4101 IF p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
4102 p_x_line_rec.tp_attribute1 := NULL;
4103 END IF;
4104 IF p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
4105 p_x_line_rec.tp_attribute2 := NULL;
4106 END IF;
4107 IF p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
4108 p_x_line_rec.tp_attribute3 := NULL;
4109 END IF;
4110 IF p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
4111 p_x_line_rec.tp_attribute4 := NULL;
4112 END IF;
4113 IF p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
4114 p_x_line_rec.tp_attribute5 := NULL;
4115 END IF;
4116 IF p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
4117 p_x_line_rec.tp_attribute6 := NULL;
4118 END IF;
4119 IF p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
4120 p_x_line_rec.tp_attribute7 := NULL;
4121 END IF;
4122 IF p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
4123 p_x_line_rec.tp_attribute8 := NULL;
4124 END IF;
4125 IF p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
4126 p_x_line_rec.tp_attribute9 := NULL;
4127 END IF;
4128 IF p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
4129 p_x_line_rec.tp_attribute10 := NULL;
4130 END IF;
4131 IF p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
4132 p_x_line_rec.tp_attribute11 := NULL;
4133 END IF;
4134 IF p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
4135 p_x_line_rec.tp_attribute12 := NULL;
4136 END IF;
4137 IF p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
4138 p_x_line_rec.tp_attribute13 := NULL;
4139 END IF;
4140 IF p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
4141 p_x_line_rec.tp_attribute14 := NULL;
4142 END IF;
4143 IF p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
4144 p_x_line_rec.tp_attribute15 := NULL;
4145 END IF;
4146
4147
4148 IF p_x_line_rec.intermed_ship_to_contact_id = FND_API.G_MISS_NUM THEN
4149 p_x_line_rec.intermed_ship_to_contact_id := NULL;
4150 END IF;
4151
4152 IF p_x_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM THEN
4153 p_x_line_rec.intermed_ship_to_org_id := NULL;
4154 END IF;
4155
4156 IF p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
4157 p_x_line_rec.inventory_item_id := NULL;
4158 END IF;
4159
4160 IF p_x_line_rec.invoice_interface_status_code = FND_API.G_MISS_CHAR THEN
4161 p_x_line_rec.invoice_interface_status_code := NULL;
4162 END IF;
4163
4164
4165
4166 IF p_x_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM THEN
4167 p_x_line_rec.invoice_to_contact_id := NULL;
4168 END IF;
4169
4170 IF p_x_line_rec.invoiced_quantity = FND_API.G_MISS_NUM THEN
4171 p_x_line_rec.invoiced_quantity := NULL;
4172 END IF;
4173
4174 IF p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN
4175 p_x_line_rec.invoice_to_org_id := NULL;
4176 END IF;
4177
4178 IF p_x_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN
4179 p_x_line_rec.invoicing_rule_id := NULL;
4180 END IF;
4181
4182 IF p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM THEN
4183 p_x_line_rec.ordered_item_id := NULL;
4184 END IF;
4185
4186 IF p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN
4187 p_x_line_rec.item_identifier_type := NULL;
4188 END IF;
4189
4190 IF p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR THEN
4191 p_x_line_rec.ordered_item := NULL;
4192 END IF;
4193
4194 IF p_x_line_rec.item_revision = FND_API.G_MISS_CHAR THEN
4195 p_x_line_rec.item_revision := NULL;
4196 END IF;
4197
4198 IF p_x_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN
4199 p_x_line_rec.item_type_code := NULL;
4200 END IF;
4201
4202 IF p_x_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
4203 p_x_line_rec.last_updated_by := NULL;
4204 END IF;
4205
4206 IF p_x_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
4207 p_x_line_rec.last_update_date := NULL;
4208 END IF;
4209
4210 IF p_x_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
4211 p_x_line_rec.last_update_login := NULL;
4212 END IF;
4213
4214 IF p_x_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE THEN
4215 p_x_line_rec.latest_acceptable_date := NULL;
4216 END IF;
4217
4218 IF p_x_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN
4219 p_x_line_rec.line_category_code := NULL;
4220 END IF;
4221
4222 IF p_x_line_rec.line_id = FND_API.G_MISS_NUM THEN
4223 p_x_line_rec.line_id := NULL;
4224 END IF;
4225
4226 IF p_x_line_rec.line_number = FND_API.G_MISS_NUM THEN
4227 p_x_line_rec.line_number := NULL;
4228 END IF;
4229
4230 IF p_x_line_rec.line_type_id = FND_API.G_MISS_NUM THEN
4231 p_x_line_rec.line_type_id := NULL;
4232 END IF;
4233
4234 IF p_x_line_rec.link_to_line_id = FND_API.G_MISS_NUM THEN
4235 p_x_line_rec.link_to_line_id := NULL;
4236 END IF;
4237
4238 IF p_x_line_rec.model_group_number = FND_API.G_MISS_NUM THEN
4239 p_x_line_rec.model_group_number := NULL;
4240 END IF;
4241
4242 IF p_x_line_rec.mfg_component_sequence_id = FND_API.G_MISS_NUM THEN
4243 p_x_line_rec.mfg_component_sequence_id := NULL;
4244 END IF;
4245
4246 IF p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM THEN
4247 p_x_line_rec.mfg_lead_time := NULL;
4248 END IF;
4249
4250 IF p_x_line_rec.open_flag = FND_API.G_MISS_CHAR THEN
4251 p_x_line_rec.open_flag := NULL;
4252 END IF;
4253
4254 IF p_x_line_rec.option_flag = FND_API.G_MISS_CHAR THEN
4255 p_x_line_rec.option_flag := NULL;
4256 END IF;
4257
4258 IF p_x_line_rec.option_number = FND_API.G_MISS_NUM THEN
4259 p_x_line_rec.option_number := NULL;
4260 END IF;
4261
4262 IF p_x_line_rec.ordered_quantity = FND_API.G_MISS_NUM THEN
4263 p_x_line_rec.ordered_quantity := NULL;
4264 END IF;
4265
4266 IF p_x_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN
4267 p_x_line_rec.order_quantity_uom := NULL;
4268 END IF;
4269
4270 -- OPM 02/JUN/00 - Deal with process attributes
4271 -- ============================================
4272 IF p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM THEN
4273 p_x_line_rec.ordered_quantity2 := NULL;
4274 END IF;
4275
4276 IF p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR THEN
4277 p_x_line_rec.ordered_quantity_uom2 := NULL;
4278 END IF;
4279 -- OPM 02/JUN/00 - END
4280 -- ===================
4281
4282 IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4283 p_x_line_rec.org_id := NULL;
4284 END IF;
4285
4286 IF p_x_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR THEN
4287 p_x_line_rec.orig_sys_document_ref := NULL;
4288 END IF;
4289
4290 IF p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR THEN
4291 p_x_line_rec.orig_sys_line_ref := NULL;
4292 END IF;
4293
4294 IF p_x_line_rec.orig_sys_shipment_ref = FND_API.G_MISS_CHAR THEN
4295 p_x_line_rec.orig_sys_shipment_ref := NULL;
4296 END IF;
4297
4298 -- Override List Price
4299 IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4300 IF p_x_line_rec.original_list_price = FND_API.G_MISS_NUM THEN
4301 p_x_line_rec.original_list_price:= NULL;
4302 END IF;
4303 END IF;
4304 -- Override List Price
4305
4306 IF p_x_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN
4307 p_x_line_rec.over_ship_reason_code := NULL;
4308 END IF;
4309 IF p_x_line_rec.over_ship_resolved_flag = FND_API.G_MISS_CHAR THEN
4310 p_x_line_rec.over_ship_resolved_flag := NULL;
4311 END IF;
4312
4313 IF p_x_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN
4314 p_x_line_rec.payment_term_id := NULL;
4315 END IF;
4316
4317 IF p_x_line_rec.planning_priority = FND_API.G_MISS_NUM THEN
4318 p_x_line_rec.planning_priority := NULL;
4319 END IF;
4320
4321 -- OPM 02/JUN/00 - Deal with process attributes
4322 -- ============================================
4323 IF p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR THEN
4324 p_x_line_rec.preferred_grade := NULL;
4325 END IF;
4326 -- OPM 02/JUN/00 - END
4327 -- ===================
4328
4329 IF p_x_line_rec.price_list_id = FND_API.G_MISS_NUM THEN
4330 p_x_line_rec.price_list_id := NULL;
4331 END IF;
4332
4333 IF p_x_line_rec.price_request_code = FND_API.G_MISS_CHAR THEN -- PROMOTIONS SEP/01
4334 p_x_line_rec.price_request_code := NULL;
4335 END IF;
4336
4337 IF p_x_line_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
4338 p_x_line_rec.pricing_attribute1 := NULL;
4339 END IF;
4340
4341 IF p_x_line_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
4342 p_x_line_rec.pricing_attribute10 := NULL;
4343 END IF;
4344
4345 IF p_x_line_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
4346 p_x_line_rec.pricing_attribute2 := NULL;
4347 END IF;
4348
4349 IF p_x_line_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
4350 p_x_line_rec.pricing_attribute3 := NULL;
4351 END IF;
4352
4353 IF p_x_line_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
4354 p_x_line_rec.pricing_attribute4 := NULL;
4355 END IF;
4356
4357 IF p_x_line_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
4358 p_x_line_rec.pricing_attribute5 := NULL;
4359 END IF;
4360
4361 IF p_x_line_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
4362 p_x_line_rec.pricing_attribute6 := NULL;
4363 END IF;
4364
4365 IF p_x_line_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
4366 p_x_line_rec.pricing_attribute7 := NULL;
4367 END IF;
4368
4369 IF p_x_line_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
4370 p_x_line_rec.pricing_attribute8 := NULL;
4371 END IF;
4372
4373 IF p_x_line_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
4374 p_x_line_rec.pricing_attribute9 := NULL;
4375 END IF;
4376
4377 IF p_x_line_rec.pricing_context = FND_API.G_MISS_CHAR THEN
4378 p_x_line_rec.pricing_context := NULL;
4379 END IF;
4380
4381 IF p_x_line_rec.pricing_date = FND_API.G_MISS_DATE THEN
4382 p_x_line_rec.pricing_date := NULL;
4383 END IF;
4384
4385 IF p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN
4386 p_x_line_rec.pricing_quantity := NULL;
4387 END IF;
4388
4389 IF p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR THEN
4390 p_x_line_rec.pricing_quantity_uom := NULL;
4391 END IF;
4392
4393 IF p_x_line_rec.program_application_id = FND_API.G_MISS_NUM THEN
4394 p_x_line_rec.program_application_id := NULL;
4395 END IF;
4396
4397 IF p_x_line_rec.program_id = FND_API.G_MISS_NUM THEN
4398 p_x_line_rec.program_id := NULL;
4399 END IF;
4400
4401 IF p_x_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
4402 p_x_line_rec.program_update_date := NULL;
4403 END IF;
4404
4405 IF p_x_line_rec.project_id = FND_API.G_MISS_NUM THEN
4406 p_x_line_rec.project_id := NULL;
4407 END IF;
4408
4409 IF p_x_line_rec.promise_date = FND_API.G_MISS_DATE THEN
4410 p_x_line_rec.promise_date := NULL;
4411 END IF;
4412
4413 IF p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR THEN
4414 p_x_line_rec.re_source_flag := NULL;
4415 END IF;
4416
4417 IF p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM THEN
4418 p_x_line_rec.reference_customer_trx_line_id := NULL;
4419 END IF;
4420
4421 IF p_x_line_rec.reference_header_id = FND_API.G_MISS_NUM THEN
4422 p_x_line_rec.reference_header_id := NULL;
4423 END IF;
4424
4425 IF p_x_line_rec.reference_line_id = FND_API.G_MISS_NUM THEN
4426 p_x_line_rec.reference_line_id := NULL;
4427 END IF;
4428
4429 IF p_x_line_rec.reference_type = FND_API.G_MISS_CHAR THEN
4430 p_x_line_rec.reference_type := NULL;
4431 END IF;
4432
4433
4434
4435 IF p_x_line_rec.request_date = FND_API.G_MISS_DATE THEN
4436 p_x_line_rec.request_date := NULL;
4437 END IF;
4438
4439 IF p_x_line_rec.request_id = FND_API.G_MISS_NUM THEN
4440 p_x_line_rec.request_id := NULL;
4441 END IF;
4442
4443 IF p_x_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN
4444 p_x_line_rec.return_attribute1 := NULL;
4445 END IF;
4446
4447 IF p_x_line_rec.return_attribute10 = FND_API.G_MISS_CHAR THEN
4448 p_x_line_rec.return_attribute10 := NULL;
4449 END IF;
4450
4451 IF p_x_line_rec.return_attribute11 = FND_API.G_MISS_CHAR THEN
4452 p_x_line_rec.return_attribute11 := NULL;
4453 END IF;
4454
4455 IF p_x_line_rec.return_attribute12 = FND_API.G_MISS_CHAR THEN
4456 p_x_line_rec.return_attribute12 := NULL;
4457 END IF;
4458
4459 IF p_x_line_rec.return_attribute13 = FND_API.G_MISS_CHAR THEN
4460 p_x_line_rec.return_attribute13 := NULL;
4461 END IF;
4462
4463 IF p_x_line_rec.return_attribute14 = FND_API.G_MISS_CHAR THEN
4464 p_x_line_rec.return_attribute14 := NULL;
4465 END IF;
4466
4467 IF p_x_line_rec.return_attribute15 = FND_API.G_MISS_CHAR THEN
4468 p_x_line_rec.return_attribute15 := NULL;
4469 END IF;
4470
4471 IF p_x_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN
4472 p_x_line_rec.return_attribute2 := NULL;
4473 END IF;
4474
4475 IF p_x_line_rec.return_attribute3 = FND_API.G_MISS_CHAR THEN
4476 p_x_line_rec.return_attribute3 := NULL;
4477 END IF;
4478
4479 IF p_x_line_rec.return_attribute4 = FND_API.G_MISS_CHAR THEN
4480 p_x_line_rec.return_attribute4 := NULL;
4481 END IF;
4482
4483 IF p_x_line_rec.return_attribute5 = FND_API.G_MISS_CHAR THEN
4484 p_x_line_rec.return_attribute5 := NULL;
4485 END IF;
4486
4487 IF p_x_line_rec.return_attribute6 = FND_API.G_MISS_CHAR THEN
4488 p_x_line_rec.return_attribute6 := NULL;
4489 END IF;
4490
4491 IF p_x_line_rec.return_attribute7 = FND_API.G_MISS_CHAR THEN
4492 p_x_line_rec.return_attribute7 := NULL;
4493 END IF;
4494
4495 IF p_x_line_rec.return_attribute8 = FND_API.G_MISS_CHAR THEN
4496 p_x_line_rec.return_attribute8 := NULL;
4497 END IF;
4498
4499 IF p_x_line_rec.return_attribute9 = FND_API.G_MISS_CHAR THEN
4500 p_x_line_rec.return_attribute9 := NULL;
4501 END IF;
4502
4503 IF p_x_line_rec.return_context = FND_API.G_MISS_CHAR THEN
4504 p_x_line_rec.return_context := NULL;
4505 END IF;
4506 IF p_x_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN
4507 p_x_line_rec.return_reason_code := NULL;
4508 END IF;
4509 IF p_x_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN
4510 p_x_line_rec.salesrep_id := NULL;
4511 END IF;
4512
4513 IF p_x_line_rec.rla_schedule_type_code = FND_API.G_MISS_CHAR THEN
4514 p_x_line_rec.rla_schedule_type_code := NULL;
4515 END IF;
4516
4517 IF p_x_line_rec.schedule_arrival_date = FND_API.G_MISS_DATE THEN
4518 p_x_line_rec.schedule_arrival_date := NULL;
4519 END IF;
4520
4521 IF p_x_line_rec.schedule_ship_date = FND_API.G_MISS_DATE THEN
4522 p_x_line_rec.schedule_ship_date := NULL;
4523 END IF;
4524
4525 IF p_x_line_rec.schedule_action_code = FND_API.G_MISS_CHAR THEN
4526 p_x_line_rec.schedule_action_code := NULL;
4527 END IF;
4528
4529 IF p_x_line_rec.schedule_status_code = FND_API.G_MISS_CHAR THEN
4530 p_x_line_rec.schedule_status_code := NULL;
4531 END IF;
4532
4533 IF p_x_line_rec.shipment_number = FND_API.G_MISS_NUM THEN
4534 p_x_line_rec.shipment_number := NULL;
4535 END IF;
4536
4537 IF p_x_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN
4538 p_x_line_rec.shipment_priority_code := NULL;
4539 END IF;
4540
4541 IF p_x_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN
4542 p_x_line_rec.shipped_quantity := NULL;
4543 END IF;
4544
4545 IF p_x_line_rec.shipped_quantity2 = FND_API.G_MISS_NUM THEN -- OPM B1661023 04/02/01
4546 p_x_line_rec.shipped_quantity2 := NULL;
4547 END IF;
4548
4549 IF p_x_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN
4550 p_x_line_rec.shipping_method_code := NULL;
4551 END IF;
4552
4553 IF p_x_line_rec.shipping_quantity = FND_API.G_MISS_NUM THEN
4554 p_x_line_rec.shipping_quantity := NULL;
4555 END IF;
4556
4557 IF p_x_line_rec.shipping_quantity2 = FND_API.G_MISS_NUM THEN -- OPM B1661023 04/02/01
4558 p_x_line_rec.shipping_quantity2 := NULL;
4559 END IF;
4560
4561 IF p_x_line_rec.shipping_quantity_uom = FND_API.G_MISS_CHAR THEN
4562 p_x_line_rec.shipping_quantity_uom := NULL;
4563 END IF;
4564
4565 IF p_x_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN
4566 p_x_line_rec.ship_from_org_id := NULL;
4567 END IF;
4568
4569 IF p_x_line_rec.subinventory = FND_API.G_MISS_CHAR THEN
4570 p_x_line_rec.subinventory := NULL;
4571 END IF;
4572
4573 IF p_x_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN
4574 p_x_line_rec.ship_model_complete_flag := NULL;
4575 END IF;
4576 IF p_x_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN
4577 p_x_line_rec.ship_set_id := NULL;
4578 END IF;
4579
4580 IF p_x_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN
4581 p_x_line_rec.ship_tolerance_above := NULL;
4582 END IF;
4583
4584 IF p_x_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN
4585 p_x_line_rec.ship_tolerance_below := NULL;
4586 END IF;
4587
4588 IF p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR THEN
4589 p_x_line_rec.shippable_flag := NULL;
4590 END IF;
4591
4592 IF p_x_line_rec.shipping_interfaced_flag = FND_API.G_MISS_CHAR THEN
4593 p_x_line_rec.shipping_interfaced_flag := NULL;
4594 END IF;
4595
4596 IF p_x_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM THEN
4597 p_x_line_rec.ship_to_contact_id := NULL;
4598 END IF;
4599
4600 IF p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN
4601 p_x_line_rec.ship_to_org_id := NULL;
4602 END IF;
4603
4604 IF p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM THEN
4605 p_x_line_rec.sold_from_org_id := NULL;
4606 END IF;
4607
4608 IF p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
4609 p_x_line_rec.sold_to_org_id := NULL;
4610 END IF;
4611
4612 IF p_x_line_rec.sort_order = FND_API.G_MISS_CHAR THEN
4613 p_x_line_rec.sort_order := NULL;
4614 END IF;
4615
4616 IF p_x_line_rec.source_document_id = FND_API.G_MISS_NUM THEN
4617 p_x_line_rec.source_document_id := NULL;
4618 END IF;
4619
4620 IF p_x_line_rec.source_document_line_id = FND_API.G_MISS_NUM THEN
4621 p_x_line_rec.source_document_line_id := NULL;
4622 END IF;
4623
4624 IF p_x_line_rec.source_document_type_id = FND_API.G_MISS_NUM THEN
4625 p_x_line_rec.source_document_type_id := NULL;
4626 END IF;
4627
4628 IF p_x_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN
4629 p_x_line_rec.source_type_code := NULL;
4630 END IF;
4631 IF p_x_line_rec.split_from_line_id = FND_API.G_MISS_NUM THEN
4632 p_x_line_rec.split_from_line_id := NULL;
4633 END IF;
4634 IF p_x_line_rec.line_set_id = FND_API.G_MISS_NUM THEN
4635 p_x_line_rec.line_set_id := NULL;
4636 END IF;
4637
4638 IF p_x_line_rec.split_by = FND_API.G_MISS_CHAR THEN
4639 p_x_line_rec.split_by := NULL;
4640 END IF;
4641 IF p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN
4642 p_x_line_rec.model_remnant_flag := NULL;
4643 END IF;
4644 IF p_x_line_rec.task_id = FND_API.G_MISS_NUM THEN
4645 p_x_line_rec.task_id := NULL;
4646 END IF;
4647
4648 IF p_x_line_rec.tax_code = FND_API.G_MISS_CHAR THEN
4649 p_x_line_rec.tax_code := NULL;
4650 END IF;
4651
4652 IF p_x_line_rec.tax_date = FND_API.G_MISS_DATE THEN
4653 p_x_line_rec.tax_date := NULL;
4654 END IF;
4655
4656 IF p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN
4657 p_x_line_rec.tax_exempt_flag := NULL;
4658 END IF;
4659
4660 IF p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN
4661 p_x_line_rec.tax_exempt_number := NULL;
4662 END IF;
4663
4664 IF p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN
4665 p_x_line_rec.tax_exempt_reason_code := NULL;
4666 END IF;
4667
4668 IF p_x_line_rec.tax_point_code = FND_API.G_MISS_CHAR THEN
4669 p_x_line_rec.tax_point_code := NULL;
4670 END IF;
4671
4672 IF p_x_line_rec.tax_rate = FND_API.G_MISS_NUM THEN
4673 p_x_line_rec.tax_rate := NULL;
4674 END IF;
4675
4676 IF p_x_line_rec.tax_value = FND_API.G_MISS_NUM THEN
4677 p_x_line_rec.tax_value := NULL;
4678 END IF;
4679
4680 IF p_x_line_rec.top_model_line_id = FND_API.G_MISS_NUM THEN
4681 p_x_line_rec.top_model_line_id := NULL;
4682 END IF;
4683
4684 IF p_x_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN
4685 p_x_line_rec.unit_list_price := NULL;
4686 END IF;
4687
4688 IF p_x_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM THEN
4689 p_x_line_rec.unit_list_price_per_pqty := NULL;
4690 END IF;
4691
4692 IF p_x_line_rec.unit_selling_price = FND_API.G_MISS_NUM THEN
4693 p_x_line_rec.unit_selling_price := NULL;
4694 END IF;
4695
4696 IF p_x_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM THEN
4697 p_x_line_rec.unit_selling_price_per_pqty := NULL;
4698 END IF;
4699
4700
4701 IF p_x_line_rec.visible_demand_flag = FND_API.G_MISS_CHAR THEN
4702 p_x_line_rec.visible_demand_flag := NULL;
4703 END IF;
4704 IF p_x_line_rec.veh_cus_item_cum_key_id = FND_API.G_MISS_NUM THEN
4705 p_x_line_rec.veh_cus_item_cum_key_id := NULL;
4706 END IF;
4707
4708 IF p_x_line_rec.first_ack_code = FND_API.G_MISS_CHAR THEN
4709 p_x_line_rec.first_ack_code := NULL;
4710 END IF;
4711
4712 IF p_x_line_rec.first_ack_date = FND_API.G_MISS_DATE THEN
4713 p_x_line_rec.first_ack_date := NULL;
4714 END IF;
4715
4716 IF p_x_line_rec.last_ack_code = FND_API.G_MISS_CHAR THEN
4717 p_x_line_rec.last_ack_code := NULL;
4718 END IF;
4719
4720 IF p_x_line_rec.last_ack_date = FND_API.G_MISS_DATE THEN
4721 p_x_line_rec.last_ack_date := NULL;
4722 END IF;
4723
4724
4725 IF p_x_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN
4726 p_x_line_rec.end_item_unit_number := NULL;
4727 END IF;
4728
4729 IF p_x_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN
4730 p_x_line_rec.shipping_instructions := NULL;
4731 END IF;
4732
4733 IF p_x_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN
4734 p_x_line_rec.packing_instructions := NULL;
4735 END IF;
4736
4737 -- Service related columns
4738
4739 IF p_x_line_rec.service_txn_reason_code = FND_API.G_MISS_CHAR THEN
4740 p_x_line_rec.service_txn_reason_code := NULL;
4741 END IF;
4742
4743 IF p_x_line_rec.service_txn_comments = FND_API.G_MISS_CHAR THEN
4744 p_x_line_rec.service_txn_comments := NULL;
4745 END IF;
4746
4747 IF p_x_line_rec.service_duration = FND_API.G_MISS_NUM THEN
4748 p_x_line_rec.service_duration := NULL;
4749 END IF;
4750
4751 IF p_x_line_rec.service_period = FND_API.G_MISS_CHAR THEN
4752 p_x_line_rec.service_period := NULL;
4753 END IF;
4754
4755 IF p_x_line_rec.service_start_date = FND_API.G_MISS_DATE THEN
4756 p_x_line_rec.service_start_date := NULL;
4757 END IF;
4758
4759 IF p_x_line_rec.service_end_date = FND_API.G_MISS_DATE THEN
4760 p_x_line_rec.service_end_date := NULL;
4761 END IF;
4762
4763 IF p_x_line_rec.service_coterminate_flag = FND_API.G_MISS_CHAR THEN
4764 p_x_line_rec.service_coterminate_flag := NULL;
4765 END IF;
4766
4767
4768 IF p_x_line_rec.unit_list_percent = FND_API.G_MISS_NUM THEN
4769 p_x_line_rec.unit_list_percent := NULL;
4770 END IF;
4771
4772 IF p_x_line_rec.unit_selling_percent = FND_API.G_MISS_NUM THEN
4773 p_x_line_rec.unit_selling_percent := NULL;
4774 END IF;
4775
4776 IF p_x_line_rec.unit_percent_base_price = FND_API.G_MISS_NUM THEN
4777 p_x_line_rec.unit_percent_base_price := NULL;
4778 END IF;
4779
4780 IF p_x_line_rec.service_number = FND_API.G_MISS_NUM THEN
4781 p_x_line_rec.service_number := NULL;
4782 END IF;
4783
4784 IF p_x_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR THEN
4785 p_x_line_rec.service_reference_type_code := NULL;
4786 END IF;
4787
4788 IF p_x_line_rec.service_reference_line_id = FND_API.G_MISS_NUM THEN
4789 p_x_line_rec.service_reference_line_id := NULL;
4790 END IF;
4791
4792 IF p_x_line_rec.service_reference_system_id = FND_API.G_MISS_NUM THEN
4793 p_x_line_rec.service_reference_system_id := NULL;
4794 END IF;
4795
4796 /* Marketing source code related */
4797
4798 IF p_x_line_rec.marketing_source_code_id = FND_API.G_MISS_NUM THEN
4799 p_x_line_rec.marketing_source_code_id := NULL;
4800 END IF;
4801
4802 /* End of Marketing source code related */
4803
4804 IF p_x_line_rec.order_source_id = FND_API.G_MISS_NUM THEN
4805 if l_debug_level > 0 then
4806 oe_debug_pub.add('OEXVCIGB convert_miss_to_null - order_source_id');
4807 end if;
4808 p_x_line_rec.order_source_id := NULL;
4809 END IF;
4810
4811 IF p_x_line_rec.flow_status_code = FND_API.G_MISS_CHAR THEN
4812 p_x_line_rec.flow_status_code := NULL;
4813 END IF;
4814
4815 -- Commitment related
4816 IF p_x_line_rec.commitment_id = FND_API.G_MISS_NUM THEN
4817 p_x_line_rec.commitment_id := NULL;
4818 END IF;
4819
4820
4821 -- Item Substitution changes.
4822 IF p_x_line_rec.Original_Inventory_Item_Id = FND_API.G_MISS_NUM THEN
4823 p_x_line_rec.Original_Inventory_Item_Id := Null;
4824 END IF;
4825
4826 IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN
4827 p_x_line_rec.Original_item_identifier_Type := Null;
4828 END IF;
4829
4830 IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN
4831 p_x_line_rec.Original_ordered_item_id := Null;
4832 END IF;
4833
4834 IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN
4835 p_x_line_rec.Original_ordered_item := Null;
4836 END IF;
4837
4838 IF p_x_line_rec.item_relationship_type = FND_API.G_MISS_NUM THEN
4839 p_x_line_rec.item_relationship_type := Null;
4840 END IF;
4841
4842 IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN
4843 p_x_line_rec.Item_substitution_type_code := Null;
4844 END IF;
4845
4846 IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN
4847 p_x_line_rec.Late_Demand_Penalty_Factor := Null;
4848 END IF;
4849
4850 IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN
4851 p_x_line_rec.Override_atp_date_code := Null;
4852 END IF;
4853
4854 -- Changes for Blanket Orders
4855
4856 IF p_x_line_rec.Blanket_Number = FND_API.G_MISS_NUM THEN
4857 p_x_line_rec.Blanket_Number := NULL;
4858 END IF;
4859
4860 IF p_x_line_rec.Blanket_Line_Number = FND_API.G_MISS_NUM THEN
4861 p_x_line_rec.Blanket_Line_Number := NULL;
4862 END IF;
4863
4864 IF p_x_line_rec.Blanket_Version_Number = FND_API.G_MISS_NUM THEN
4865 p_x_line_rec.Blanket_Version_Number := NULL;
4866 END IF;
4867
4868 -- QUOTING changes
4869 IF p_x_line_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN
4870 p_x_line_rec.transaction_phase_code := NULL;
4871 END IF;
4872
4873 IF p_x_line_rec.source_document_version_number = FND_API.G_MISS_NUM THEN
4874 p_x_line_rec.source_document_version_number := NULL;
4875 END IF;
4876 -- END QUOTING changes
4877 IF p_x_line_rec.Minisite_id = FND_API.G_MISS_NUM THEN
4878 p_x_line_rec.Minisite_id := NULL;
4879 END IF;
4880
4881 IF p_x_line_rec.End_customer_id = FND_API.G_MISS_NUM THEN
4882 p_x_line_rec.End_customer_id := NULL;
4883 END IF;
4884
4885 IF p_x_line_rec.End_customer_contact_id = FND_API.G_MISS_NUM THEN
4886 p_x_line_rec.End_customer_contact_id := NULL;
4887 END IF;
4888
4889 IF p_x_line_rec.End_customer_site_use_id = FND_API.G_MISS_NUM THEN
4890 p_x_line_rec.End_customer_site_use_id := NULL;
4891 END IF;
4892
4893 IF p_x_line_rec.ib_owner = FND_API.G_MISS_CHAR THEN
4894 p_x_line_rec.ib_owner := NULL;
4895 END IF;
4896
4897 IF p_x_line_rec.ib_installed_at_location = FND_API.G_MISS_CHAR THEN
4898 p_x_line_rec.ib_installed_at_location := NULL;
4899 END IF;
4900
4901 IF p_x_line_rec.ib_current_location = FND_API.G_MISS_CHAR THEN
4902 p_x_line_rec.ib_current_location := NULL;
4903 END IF;
4904
4905 --retro{
4906 IF p_x_line_rec.retrobill_request_id = FND_API.G_MISS_NUM THEN
4907 p_x_line_rec.retrobill_request_id := Null;
4908 END IF;
4909 --retro}
4910
4911 IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN
4912 p_x_line_rec.firm_demand_flag := NULL;
4913 END IF;
4914
4915 --key Transaction Dates
4916 IF p_x_line_rec.order_firmed_date = FND_API.G_MISS_DATE THEN
4917 p_x_line_rec.order_firmed_date := NULL;
4918 END IF;
4919
4920 IF p_x_line_rec.actual_fulfillment_date = FND_API.G_MISS_DATE THEN
4921 p_x_line_rec.actual_fulfillment_date := NULL;
4922 END IF;
4923 --end
4924
4925 /* IF p_x_line_rec.supplier_signature = FND_API.G_MISS_CHAR THEN
4926 p_x_line_rec.supplier_signature := NULL;
4927 END IF;
4928
4929 IF p_x_line_rec.supplier_signature_date = FND_API.G_MISS_DATE THEN
4930 p_x_line_rec.supplier_signature_date := NULL;
4931 END IF;
4932
4933 IF p_x_line_rec.customer_signature = FND_API.G_MISS_CHAR THEN
4934 p_x_line_rec.customer_signature := NULL;
4935 END IF;
4936
4937 IF p_x_line_rec.customer_signature_date = FND_API.G_MISS_CHAR THEN
4938 p_x_line_rec.customer_signature_date := NULL;
4939 END IF;
4940 */
4941
4942
4943 IF p_x_line_rec.CHANGE_SEQUENCE = FND_API.G_MISS_CHAR THEN
4944 p_x_line_rec.CHANGE_SEQUENCE := NULL;
4945 END IF;
4946
4947 IF p_x_line_rec.CUSTOMER_ITEM_NET_PRICE = FND_API.G_MISS_NUM THEN
4948 p_x_line_rec.CUSTOMER_ITEM_NET_PRICE := NULL;
4949 END IF;
4950
4951 IF p_x_line_rec.CUSTOMER_PAYMENT_TERM_ID = FND_API.G_MISS_NUM THEN
4952 p_x_line_rec.CUSTOMER_PAYMENT_TERM_ID := NULL;
4953 END IF;
4954
4955 IF p_x_line_rec.USER_ITEM_DESCRIPTION = FND_API.G_MISS_CHAR THEN
4956 p_x_line_rec.USER_ITEM_DESCRIPTION := NULL;
4957 END IF;
4958
4959 if l_debug_level > 0 then
4960 oe_debug_pub.add('Exiting OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE', 1);
4961 end if;
4962 END Convert_Miss_To_Null;
4963
4964
4965 -- Procedure Convert_Miss_To_Null...FOR HEADER ADJUSTMENT
4966 -- copied from OEXUHADB.pls 115.67 to fix same issue raised by bug 3576009
4967
4968
4969 PROCEDURE Convert_Miss_To_Null
4970 ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4971 )
4972 IS
4973 l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
4974 --
4975 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4976 --
4977 BEGIN
4978
4979 IF l_debug_level > 0 THEN
4980 oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER ADJUSTMENT' , 1 ) ;
4981 END IF;
4982
4983 IF l_Header_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
4984 l_Header_Adj_rec.price_adjustment_id := NULL;
4985 END IF;
4986
4987 IF l_Header_Adj_rec.creation_date = FND_API.G_MISS_DATE THEN
4988 l_Header_Adj_rec.creation_date := NULL;
4989 END IF;
4990
4991 IF l_Header_Adj_rec.created_by = FND_API.G_MISS_NUM THEN
4992 l_Header_Adj_rec.created_by := NULL;
4993 END IF;
4994
4995 IF l_Header_Adj_rec.last_update_date = FND_API.G_MISS_DATE THEN
4996 l_Header_Adj_rec.last_update_date := NULL;
4997 END IF;
4998
4999 IF l_Header_Adj_rec.last_updated_by = FND_API.G_MISS_NUM THEN
5000 l_Header_Adj_rec.last_updated_by := NULL;
5001 END IF;
5002
5003 IF l_Header_Adj_rec.last_update_login = FND_API.G_MISS_NUM THEN
5004 l_Header_Adj_rec.last_update_login := NULL;
5005 END IF;
5006
5007 IF l_Header_Adj_rec.program_application_id = FND_API.G_MISS_NUM THEN
5008 l_Header_Adj_rec.program_application_id := NULL;
5009 END IF;
5010
5011 IF l_Header_Adj_rec.program_id = FND_API.G_MISS_NUM THEN
5012 l_Header_Adj_rec.program_id := NULL;
5013 END IF;
5014
5015 IF l_Header_Adj_rec.program_update_date = FND_API.G_MISS_DATE THEN
5016 l_Header_Adj_rec.program_update_date := NULL;
5017 END IF;
5018
5019 IF l_Header_Adj_rec.request_id = FND_API.G_MISS_NUM THEN
5020 l_Header_Adj_rec.request_id := NULL;
5021 END IF;
5022
5023 IF l_Header_Adj_rec.header_id = FND_API.G_MISS_NUM THEN
5024 l_Header_Adj_rec.header_id := NULL;
5025 END IF;
5026
5027 IF l_Header_Adj_rec.discount_id = FND_API.G_MISS_NUM THEN
5028 l_Header_Adj_rec.discount_id := NULL;
5029 END IF;
5030
5031 IF l_Header_Adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN
5032 l_Header_Adj_rec.discount_line_id := NULL;
5033 END IF;
5034
5035 IF l_Header_Adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
5036 l_Header_Adj_rec.automatic_flag := NULL;
5037 END IF;
5038
5039 IF l_Header_Adj_rec.percent = FND_API.G_MISS_NUM THEN
5040 l_Header_Adj_rec.percent := NULL;
5041 END IF;
5042
5043 IF l_Header_Adj_rec.line_id = FND_API.G_MISS_NUM THEN
5044 l_Header_Adj_rec.line_id := NULL;
5045 END IF;
5046
5047 IF l_Header_Adj_rec.context = FND_API.G_MISS_CHAR THEN
5048 l_Header_Adj_rec.context := NULL;
5049 END IF;
5050
5051 IF l_Header_Adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN
5052 l_Header_Adj_rec.attribute1 := NULL;
5053 END IF;
5054
5055 IF l_Header_Adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN
5056 l_Header_Adj_rec.attribute2 := NULL;
5057 END IF;
5058
5059 IF l_Header_Adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN
5060 l_Header_Adj_rec.attribute3 := NULL;
5061 END IF;
5062
5063 IF l_Header_Adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN
5064 l_Header_Adj_rec.attribute4 := NULL;
5065 END IF;
5066
5067 IF l_Header_Adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN
5068 l_Header_Adj_rec.attribute5 := NULL;
5069 END IF;
5070
5071 IF l_Header_Adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN
5072 l_Header_Adj_rec.attribute6 := NULL;
5073 END IF;
5074
5075 IF l_Header_Adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN
5076 l_Header_Adj_rec.attribute7 := NULL;
5077 END IF;
5078
5079 IF l_Header_Adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN
5080 l_Header_Adj_rec.attribute8 := NULL;
5081 END IF;
5082
5083 IF l_Header_Adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN
5084 l_Header_Adj_rec.attribute9 := NULL;
5085 END IF;
5086
5087 IF l_Header_Adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN
5088 l_Header_Adj_rec.attribute10 := NULL;
5089 END IF;
5090
5091 IF l_Header_Adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN
5092 l_Header_Adj_rec.attribute11 := NULL;
5093 END IF;
5094
5095 IF l_Header_Adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN
5096 l_Header_Adj_rec.attribute12 := NULL;
5097 END IF;
5098
5099 IF l_Header_Adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN
5100 l_Header_Adj_rec.attribute13 := NULL;
5101 END IF;
5102
5103 IF l_Header_Adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN
5104 l_Header_Adj_rec.attribute14 := NULL;
5105 END IF;
5106
5107 IF l_Header_Adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN
5108 l_Header_Adj_rec.attribute15 := NULL;
5109 END IF;
5110
5111 IF l_Header_Adj_rec.adjusted_amount = FND_API.G_MISS_NUM THEN
5112 l_Header_Adj_rec.adjusted_amount := NULL;
5113 END IF;
5114
5115 IF l_Header_Adj_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
5116 l_Header_Adj_rec.pricing_phase_id := NULL;
5117 END IF;
5118
5119 IF l_Header_Adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
5120 l_Header_Adj_rec.list_header_id := NULL;
5121 END IF;
5122
5123 IF l_Header_Adj_rec.list_line_id = FND_API.G_MISS_NUM THEN
5124 l_Header_Adj_rec.list_line_id := NULL;
5125 END IF;
5126 IF l_Header_Adj_rec.modified_from = FND_API.G_MISS_CHAR THEN
5127 l_Header_Adj_rec.modified_from := NULL;
5128 END IF;
5129
5130 IF l_Header_Adj_rec.modified_to = FND_API.G_MISS_CHAR THEN
5131 l_Header_Adj_rec.modified_to := NULL;
5132 END IF;
5133
5134 IF l_Header_Adj_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
5135 l_Header_Adj_rec.list_line_type_code := NULL;
5136 END IF;
5137
5138 IF l_Header_Adj_rec.updated_flag = FND_API.G_MISS_CHAR THEN
5139 l_Header_Adj_rec.updated_flag := NULL;
5140 END IF;
5141
5142 IF l_Header_Adj_rec.update_allowed = FND_API.G_MISS_CHAR THEN
5143 l_Header_Adj_rec.update_allowed := NULL;
5144 END IF;
5145
5146 IF l_Header_Adj_rec.applied_flag = FND_API.G_MISS_CHAR THEN
5147 l_Header_Adj_rec.applied_flag := NULL;
5148 END IF;
5149
5150 IF l_Header_Adj_rec.modifier_mechanism_type_code = FND_API.G_MISS_CHAR THEN
5151 l_Header_Adj_rec.modifier_mechanism_type_code := NULL;
5152 END IF;
5153
5154 IF l_Header_Adj_rec.change_reason_code = FND_API.G_MISS_CHAR THEN
5155 l_Header_Adj_rec.change_reason_code := NULL;
5156 END IF;
5157
5158 IF l_Header_Adj_rec.change_reason_text = FND_API.G_MISS_CHAR THEN
5159 l_Header_Adj_rec.change_reason_text := NULL ;
5160 END IF;
5161
5162 IF l_Header_Adj_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
5163 l_Header_Adj_rec.arithmetic_operator := NULL ;
5164 END IF;
5165
5166 IF l_Header_Adj_rec.operand = FND_API.G_MISS_NUM THEN
5167 l_Header_Adj_rec.operand := NULL ;
5168 END IF;
5169
5170 IF l_Header_Adj_rec.cost_id = FND_API.G_MISS_NUM THEN
5171 l_Header_Adj_rec.cost_id := NULL ;
5172 END IF;
5173
5174 IF l_Header_Adj_rec.tax_code = FND_API.G_MISS_CHAR THEN
5175 l_Header_Adj_rec.tax_code := NULL ;
5176 END IF;
5177
5178 IF l_Header_Adj_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN
5179 l_Header_Adj_rec.tax_exempt_flag := NULL ;
5180 END IF;
5181
5182 IF l_Header_Adj_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN
5183 l_Header_Adj_rec.tax_exempt_number := NULL ;
5184 END IF;
5185
5186 IF l_Header_Adj_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN
5187 l_Header_Adj_rec.tax_exempt_reason_code := NULL ;
5188 END IF;
5189
5190 IF l_Header_Adj_rec.parent_adjustment_id = FND_API.G_MISS_NUM THEN
5191 l_Header_Adj_rec.parent_adjustment_id := NULL ;
5192 END IF;
5193
5194 IF l_Header_Adj_rec.invoiced_flag = FND_API.G_MISS_CHAR THEN
5195 l_Header_Adj_rec.invoiced_flag := NULL ;
5196 END IF;
5197
5198 IF l_Header_Adj_rec.estimated_flag = FND_API.G_MISS_CHAR THEN
5199 l_Header_Adj_rec.estimated_flag := NULL ;
5200 END IF;
5201
5202 IF l_Header_Adj_rec.inc_in_sales_performance = FND_API.G_MISS_CHAR THEN
5203 l_Header_Adj_rec.inc_in_sales_performance := NULL ;
5204 END IF;
5205
5206 IF l_Header_Adj_rec.split_action_code = FND_API.G_MISS_CHAR THEN
5207 l_Header_Adj_rec.split_action_code := NULL ;
5208 END IF;
5209
5210 IF l_Header_Adj_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
5211 l_Header_Adj_rec.charge_type_code := NULL ;
5212 END IF;
5213
5214 IF l_Header_Adj_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
5215 l_Header_Adj_rec.charge_subtype_code := NULL ;
5216 END IF;
5217
5218 IF l_Header_Adj_rec.list_line_no = FND_API.G_MISS_CHAR THEN
5219 l_Header_Adj_rec.list_line_no := NULL ;
5220 END IF;
5221
5222 IF l_Header_Adj_rec.source_system_code = FND_API.G_MISS_CHAR THEN
5223 l_Header_Adj_rec.source_system_code := NULL ;
5224 END IF;
5225
5226 IF l_Header_Adj_rec.benefit_qty = FND_API.G_MISS_NUM THEN
5227 l_Header_Adj_rec.benefit_qty := NULL ;
5228 END IF;
5229
5230 IF l_Header_Adj_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
5231 l_Header_Adj_rec.benefit_uom_code := NULL ;
5232 END IF;
5233
5234 IF l_Header_Adj_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
5235 l_Header_Adj_rec.print_on_invoice_flag := NULL ;
5236 END IF;
5237
5238 IF l_Header_Adj_rec.expiration_date = FND_API.G_MISS_DATE THEN
5239 l_Header_Adj_rec.expiration_date := NULL ;
5240 END IF;
5241
5242 IF l_Header_Adj_rec.rebate_transaction_type_code = FND_API.G_MISS_CHAR THEN
5243 l_Header_Adj_rec.rebate_transaction_type_code := NULL ;
5244 END IF;
5245
5246 IF l_Header_Adj_rec.rebate_transaction_reference = FND_API.G_MISS_CHAR THEN
5247 l_Header_Adj_rec.rebate_transaction_reference := NULL ;
5248 END IF;
5249
5250 IF l_Header_Adj_rec.rebate_payment_system_code = FND_API.G_MISS_CHAR THEN
5251 l_Header_Adj_rec.rebate_payment_system_code := NULL ;
5252 END IF;
5253
5254 IF l_Header_Adj_rec.redeemed_date = FND_API.G_MISS_DATE THEN
5255 l_Header_Adj_rec.redeemed_date := NULL ;
5256 END IF;
5257
5258 IF l_Header_Adj_rec.redeemed_flag = FND_API.G_MISS_CHAR THEN
5259 l_Header_Adj_rec.redeemed_flag := NULL ;
5260 END IF;
5261
5262 IF l_Header_Adj_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
5263 l_Header_Adj_rec.accrual_flag := NULL ;
5264 END IF;
5265
5266 IF l_Header_Adj_rec.range_break_quantity = FND_API.G_MISS_NUM THEN
5267 l_Header_Adj_rec.range_break_quantity := NULL ;
5268 END IF;
5269
5270 IF l_Header_Adj_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
5271 l_Header_Adj_rec.accrual_conversion_rate := NULL ;
5272 END IF;
5273
5274 IF l_Header_Adj_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
5275 l_Header_Adj_rec.pricing_group_sequence := NULL ;
5276 END IF;
5277
5278 IF l_Header_Adj_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
5279 l_Header_Adj_rec.modifier_level_code := NULL ;
5280 END IF;
5281
5282 IF l_Header_Adj_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
5283 l_Header_Adj_rec.price_break_type_code := NULL ;
5284 END IF;
5285
5286 IF l_Header_Adj_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
5287 l_Header_Adj_rec.substitution_attribute := NULL ;
5288 END IF;
5289
5290 IF l_Header_Adj_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
5291 l_Header_Adj_rec.proration_type_code := NULL ;
5292 END IF;
5293
5294 IF l_Header_Adj_rec.credit_or_charge_flag = FND_API.G_MISS_CHAR THEN
5295 l_Header_Adj_rec.credit_or_charge_flag := NULL ;
5296 END IF;
5297
5298 IF l_Header_Adj_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
5299 l_Header_Adj_rec.include_on_returns_flag := NULL ;
5300 END IF;
5301
5302 IF l_Header_Adj_rec.ac_context = FND_API.G_MISS_CHAR THEN
5303 l_Header_Adj_rec.ac_context := NULL;
5304 END IF;
5305
5306 IF l_Header_Adj_rec.ac_attribute1 = FND_API.G_MISS_CHAR THEN
5307 l_Header_Adj_rec.ac_attribute1 := NULL;
5308 END IF;
5309
5310 IF l_Header_Adj_rec.ac_attribute2 = FND_API.G_MISS_CHAR THEN
5311 l_Header_Adj_rec.ac_attribute2 := NULL;
5312 END IF;
5313
5314 IF l_Header_Adj_rec.ac_attribute3 = FND_API.G_MISS_CHAR THEN
5315 l_Header_Adj_rec.ac_attribute3 := NULL;
5316 END IF;
5317
5318 IF l_Header_Adj_rec.ac_attribute4 = FND_API.G_MISS_CHAR THEN
5319 l_Header_Adj_rec.ac_attribute4 := NULL;
5320 END IF;
5321
5322 IF l_Header_Adj_rec.ac_attribute5 = FND_API.G_MISS_CHAR THEN
5323 l_Header_Adj_rec.ac_attribute5 := NULL;
5324 END IF;
5325
5326 IF l_Header_Adj_rec.ac_attribute6 = FND_API.G_MISS_CHAR THEN
5327 l_Header_Adj_rec.ac_attribute6 := NULL;
5328 END IF;
5329
5330 IF l_Header_Adj_rec.ac_attribute7 = FND_API.G_MISS_CHAR THEN
5331 l_Header_Adj_rec.ac_attribute7 := NULL;
5332 END IF;
5333
5334 IF l_Header_Adj_rec.ac_attribute8 = FND_API.G_MISS_CHAR THEN
5335 l_Header_Adj_rec.ac_attribute8 := NULL;
5336 END IF;
5337
5338 IF l_Header_Adj_rec.ac_attribute9 = FND_API.G_MISS_CHAR THEN
5339 l_Header_Adj_rec.ac_attribute9 := NULL;
5340 END IF;
5341
5342 IF l_Header_Adj_rec.ac_attribute10 = FND_API.G_MISS_CHAR THEN
5343 l_Header_Adj_rec.ac_attribute10 := NULL;
5344 END IF;
5345
5346 IF l_Header_Adj_rec.ac_attribute11 = FND_API.G_MISS_CHAR THEN
5347 l_Header_Adj_rec.ac_attribute11 := NULL;
5348 END IF;
5349
5350 IF l_Header_Adj_rec.ac_attribute12 = FND_API.G_MISS_CHAR THEN
5351 l_Header_Adj_rec.ac_attribute12 := NULL;
5352 END IF;
5353
5354 IF l_Header_Adj_rec.ac_attribute13 = FND_API.G_MISS_CHAR THEN
5355 l_Header_Adj_rec.ac_attribute13 := NULL;
5356 END IF;
5357
5358 IF l_Header_Adj_rec.ac_attribute14 = FND_API.G_MISS_CHAR THEN
5359 l_Header_Adj_rec.ac_attribute14 := NULL;
5360 END IF;
5361
5362 IF l_Header_Adj_rec.ac_attribute15 = FND_API.G_MISS_CHAR THEN
5363 l_Header_Adj_rec.ac_attribute15 := NULL;
5364 END IF;
5365 --uom begin
5366 If l_Header_Adj_rec.operand_per_pqty = FND_API.G_MISS_NUM THEN
5367 l_Header_Adj_rec.operand_per_pqty:=NULL;
5368 END IF;
5369
5370 If l_Header_Adj_rec.adjusted_amount_per_pqty = FND_API.G_MISS_NUM THEN
5371 l_Header_Adj_rec.adjusted_amount_per_pqty:=NULL;
5372 END IF;
5373 --uom end
5374
5375 If l_Header_Adj_rec.invoiced_amount = FND_API.G_MISS_NUM THEN
5376 l_Header_Adj_rec.invoiced_amount := NULL;
5377 END IF;
5378
5379
5380 IF l_debug_level > 0 THEN
5381 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER ADJUSTMENT' , 1 ) ;
5382 END IF;
5383
5384 -- RETURN l_Header_Adj_rec;
5385 p_x_Header_Adj_rec := l_Header_Adj_rec;
5386
5387 END Convert_Miss_To_Null;
5388
5389
5390
5391 PROCEDURE Convert_Miss_To_Null
5392 ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
5393 )
5394 IS
5395 --
5396 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5397 --
5398 BEGIN
5399
5400 IF l_debug_level > 0 THEN
5401 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER SCREDIT' , 1 ) ;
5402 END IF;
5403 IF p_x_Header_Scredit_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
5404 p_x_Header_Scredit_rec.ATTRIBUTE1 := NULL;
5405 END IF;
5406
5407 IF p_x_Header_Scredit_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
5408 p_x_Header_Scredit_rec.ATTRIBUTE10 := NULL;
5409 END IF;
5410
5411 IF p_x_Header_Scredit_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
5412 p_x_Header_Scredit_rec.ATTRIBUTE11 := NULL;
5413 END IF;
5414
5415 IF p_x_Header_Scredit_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
5416
5417 p_x_Header_Scredit_rec.ATTRIBUTE12 := NULL;
5418 END IF;
5419
5420 IF p_x_Header_Scredit_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
5421 p_x_Header_Scredit_rec.ATTRIBUTE13 := NULL;
5422 END IF;
5423
5424 IF p_x_Header_Scredit_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
5425 p_x_Header_Scredit_rec.ATTRIBUTE14 := NULL;
5426 END IF;
5427
5428 IF p_x_Header_Scredit_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
5429 p_x_Header_Scredit_rec.ATTRIBUTE15 := NULL;
5430
5431 END IF;
5432
5433 IF p_x_Header_Scredit_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
5434 p_x_Header_Scredit_rec.ATTRIBUTE2 := NULL;
5435 END IF;
5436
5437 IF p_x_Header_Scredit_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
5438 p_x_Header_Scredit_rec.ATTRIBUTE3 := NULL;
5439 END IF;
5440
5441 IF p_x_Header_Scredit_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
5442 p_x_Header_Scredit_rec.ATTRIBUTE4 := NULL;
5443 END IF;
5444
5445
5446 IF p_x_Header_Scredit_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
5447 p_x_Header_Scredit_rec.ATTRIBUTE5 := NULL;
5448 END IF;
5449
5450 IF p_x_Header_Scredit_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
5451 p_x_Header_Scredit_rec.ATTRIBUTE6 := NULL;
5452 END IF;
5453
5454 IF p_x_Header_Scredit_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
5455 p_x_Header_Scredit_rec.ATTRIBUTE7 := NULL;
5456 END IF;
5457
5458
5459 IF p_x_Header_Scredit_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
5460 p_x_Header_Scredit_rec.ATTRIBUTE8 := NULL;
5461 END IF;
5462
5463 IF p_x_Header_Scredit_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
5464 p_x_Header_Scredit_rec.ATTRIBUTE9 := NULL;
5465 END IF;
5466
5467 IF p_x_Header_Scredit_rec.CONTEXT = FND_API.G_MISS_CHAR THEN
5468 p_x_Header_Scredit_rec.CONTEXT := NULL;
5469 END IF;
5470
5471 IF p_x_Header_Scredit_rec.CREATED_BY = FND_API.G_MISS_NUM THEN
5472
5473 p_x_Header_Scredit_rec.CREATED_BY := NULL;
5474 END IF;
5475
5476 IF p_x_Header_Scredit_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
5477
5478 p_x_Header_Scredit_rec.CREATION_DATE := NULL;
5479 END IF;
5480
5481 IF p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG = FND_API.G_MISS_CHAR THEN
5482 p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := NULL;
5483 END IF;
5484
5485
5486 IF p_x_Header_Scredit_rec.HEADER_ID = FND_API.G_MISS_NUM THEN
5487 p_x_Header_Scredit_rec.HEADER_ID := NULL;
5488 END IF;
5489
5490 IF p_x_Header_Scredit_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
5491 p_x_Header_Scredit_rec.LAST_UPDATED_BY := NULL;
5492 END IF;
5493
5494 IF p_x_Header_Scredit_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
5495 p_x_Header_Scredit_rec.LAST_UPDATE_DATE := NULL;
5496 END IF;
5497
5498
5499 IF p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
5500 p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := NULL;
5501 END IF;
5502
5503 IF p_x_Header_Scredit_rec.LINE_ID = FND_API.G_MISS_NUM THEN
5504 p_x_Header_Scredit_rec.LINE_ID := NULL;
5505 END IF;
5506
5507 IF p_x_Header_Scredit_rec.LOCK_CONTROL = FND_API.G_MISS_NUM THEN
5508 p_x_Header_Scredit_rec.LOCK_CONTROL := NULL;
5509 END IF;
5510
5511
5512 IF p_x_Header_Scredit_rec.ORIG_SYS_CREDIT_REF = FND_API.G_MISS_CHAR THEN
5513 p_x_Header_Scredit_rec.ORIG_SYS_CREDIT_REF := NULL;
5514 END IF;
5515
5516 IF p_x_Header_Scredit_rec.PERCENT = FND_API.G_MISS_NUM THEN
5517 p_x_Header_Scredit_rec.PERCENT := NULL;
5518 END IF;
5519
5520 IF p_x_Header_Scredit_rec.SALESREP_ID = FND_API.G_MISS_NUM THEN
5521 p_x_Header_Scredit_rec.SALESREP_ID := NULL;
5522 END IF;
5523
5524
5525 IF p_x_Header_Scredit_rec.SALES_CREDIT_ID = FND_API.G_MISS_NUM THEN
5526 p_x_Header_Scredit_rec.SALES_CREDIT_ID := NULL;
5527 END IF;
5528
5529 IF p_x_Header_Scredit_rec.SALES_CREDIT_TYPE_ID = FND_API.G_MISS_NUM THEN
5530 p_x_Header_Scredit_rec.SALES_CREDIT_TYPE_ID := NULL;
5531 END IF;
5532
5533 IF p_x_Header_Scredit_rec.WH_UPDATE_DATE = FND_API.G_MISS_DATE THEN
5534 p_x_Header_Scredit_rec.WH_UPDATE_DATE := NULL;
5535 END IF;
5536
5537 IF l_debug_level > 0 THEN
5538 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER SCREDIT' , 1 ) ;
5539 END IF;
5540
5541 END Convert_Miss_To_Null;
5542
5543
5544
5545
5546 -- Procedure Convert_Miss_To_Null...FOR LINE ADJUSTMENT
5547 -- copied from OEXULADB.pls 115.117 to fix same issue raised by bug 3576009
5548
5549
5550 PROCEDURE Convert_Miss_To_Null
5551 ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
5552 )
5553 IS
5554 l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
5555 --
5556 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5557 --
5558 BEGIN
5559
5560
5561 IF l_debug_level > 0 THEN
5562 oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE ADJUSTMENT' , 1 ) ;
5563 END IF;
5564
5565 IF l_Line_Adj_rec.adjusted_amount = FND_API.G_MISS_NUM THEN
5566 l_Line_Adj_rec.adjusted_amount := NULL;
5567 END IF;
5568
5569 IF l_Line_Adj_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
5570 l_Line_Adj_rec.pricing_phase_id := NULL;
5571 END IF;
5572
5573 IF l_Line_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
5574 l_Line_Adj_rec.price_adjustment_id := NULL;
5575 END IF;
5576
5577 IF l_Line_Adj_rec.creation_date = FND_API.G_MISS_DATE THEN
5578 l_Line_Adj_rec.creation_date := NULL;
5579 END IF;
5580
5581 IF l_Line_Adj_rec.created_by = FND_API.G_MISS_NUM THEN
5582 l_Line_Adj_rec.created_by := NULL;
5583 END IF;
5584
5585 IF l_Line_Adj_rec.last_update_date = FND_API.G_MISS_DATE THEN
5586 l_Line_Adj_rec.last_update_date := NULL;
5587 END IF;
5588
5589 IF l_Line_Adj_rec.last_updated_by = FND_API.G_MISS_NUM THEN
5590 l_Line_Adj_rec.last_updated_by := NULL;
5591 END IF;
5592
5593 IF l_Line_Adj_rec.last_update_login = FND_API.G_MISS_NUM THEN
5594 l_Line_Adj_rec.last_update_login := NULL;
5595 END IF;
5596
5597 IF l_Line_Adj_rec.program_application_id = FND_API.G_MISS_NUM THEN
5598 l_Line_Adj_rec.program_application_id := NULL;
5599 END IF;
5600
5601 IF l_Line_Adj_rec.program_id = FND_API.G_MISS_NUM THEN
5602 l_Line_Adj_rec.program_id := NULL;
5603 END IF;
5604
5605 IF l_Line_Adj_rec.program_update_date = FND_API.G_MISS_DATE THEN
5606 l_Line_Adj_rec.program_update_date := NULL;
5607 END IF;
5608
5609 IF l_Line_Adj_rec.request_id = FND_API.G_MISS_NUM THEN
5610 l_Line_Adj_rec.request_id := NULL;
5611 END IF;
5612
5613 IF l_Line_Adj_rec.header_id = FND_API.G_MISS_NUM THEN
5614 l_Line_Adj_rec.header_id := NULL;
5615 END IF;
5616
5617 IF l_Line_Adj_rec.discount_id = FND_API.G_MISS_NUM THEN
5618 l_Line_Adj_rec.discount_id := NULL;
5619 END IF;
5620
5621 IF l_Line_Adj_rec.discount_line_id = FND_API.G_MISS_NUM THEN
5622 l_Line_Adj_rec.discount_line_id := NULL;
5623 END IF;
5624
5625 IF l_Line_Adj_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
5626 l_Line_Adj_rec.automatic_flag := NULL;
5627 END IF;
5628
5629 IF l_Line_Adj_rec.percent = FND_API.G_MISS_NUM THEN
5630 l_Line_Adj_rec.percent := NULL;
5631 END IF;
5632
5633 IF l_Line_Adj_rec.line_id = FND_API.G_MISS_NUM THEN
5634 l_Line_Adj_rec.line_id := NULL;
5635 END IF;
5636
5637 IF l_Line_Adj_rec.context = FND_API.G_MISS_CHAR THEN
5638 l_Line_Adj_rec.context := NULL;
5639 END IF;
5640
5641 IF l_Line_Adj_rec.attribute1 = FND_API.G_MISS_CHAR THEN
5642 l_Line_Adj_rec.attribute1 := NULL;
5643 END IF;
5644
5645 IF l_Line_Adj_rec.attribute2 = FND_API.G_MISS_CHAR THEN
5646 l_Line_Adj_rec.attribute2 := NULL;
5647 END IF;
5648
5649 IF l_Line_Adj_rec.attribute3 = FND_API.G_MISS_CHAR THEN
5650 l_Line_Adj_rec.attribute3 := NULL;
5651 END IF;
5652
5653 IF l_Line_Adj_rec.attribute4 = FND_API.G_MISS_CHAR THEN
5654 l_Line_Adj_rec.attribute4 := NULL;
5655 END IF;
5656
5657 IF l_Line_Adj_rec.attribute5 = FND_API.G_MISS_CHAR THEN
5658 l_Line_Adj_rec.attribute5 := NULL;
5659 END IF;
5660
5661 IF l_Line_Adj_rec.attribute6 = FND_API.G_MISS_CHAR THEN
5662 l_Line_Adj_rec.attribute6 := NULL;
5663 END IF;
5664
5665 IF l_Line_Adj_rec.attribute7 = FND_API.G_MISS_CHAR THEN
5666 l_Line_Adj_rec.attribute7 := NULL;
5667 END IF;
5668
5669 IF l_Line_Adj_rec.attribute8 = FND_API.G_MISS_CHAR THEN
5670 l_Line_Adj_rec.attribute8 := NULL;
5671 END IF;
5672
5673 IF l_Line_Adj_rec.attribute9 = FND_API.G_MISS_CHAR THEN
5674 l_Line_Adj_rec.attribute9 := NULL;
5675 END IF;
5676
5677 IF l_Line_Adj_rec.attribute10 = FND_API.G_MISS_CHAR THEN
5678 l_Line_Adj_rec.attribute10 := NULL;
5679 END IF;
5680
5681 IF l_Line_Adj_rec.attribute11 = FND_API.G_MISS_CHAR THEN
5682 l_Line_Adj_rec.attribute11 := NULL;
5683 END IF;
5684
5685 IF l_Line_Adj_rec.attribute12 = FND_API.G_MISS_CHAR THEN
5686 l_Line_Adj_rec.attribute12 := NULL;
5687 END IF;
5688
5689 IF l_Line_Adj_rec.attribute13 = FND_API.G_MISS_CHAR THEN
5690 l_Line_Adj_rec.attribute13 := NULL;
5691 END IF;
5692
5693 IF l_Line_Adj_rec.attribute14 = FND_API.G_MISS_CHAR THEN
5694 l_Line_Adj_rec.attribute14 := NULL;
5695 END IF;
5696
5697 IF l_Line_Adj_rec.attribute15 = FND_API.G_MISS_CHAR THEN
5698 l_Line_Adj_rec.attribute15 := NULL;
5699 END IF;
5700
5701 IF l_Line_Adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
5702 l_Line_Adj_rec.list_header_id := NULL;
5703 END IF;
5704
5705 IF l_Line_Adj_rec.list_line_id = FND_API.G_MISS_NUM THEN
5706 l_Line_Adj_rec.list_line_id := NULL;
5707 END IF;
5708
5709 IF l_Line_Adj_rec.modified_from = FND_API.G_MISS_CHAR THEN
5710 l_Line_Adj_rec.modified_from := NULL;
5711 END IF;
5712 IF l_Line_Adj_rec.modified_to = FND_API.G_MISS_CHAR THEN
5713 l_Line_Adj_rec.modified_to := NULL;
5714 END IF;
5715
5716 IF l_Line_Adj_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
5717 l_Line_Adj_rec.list_line_type_code := NULL;
5718 END IF;
5719
5720 IF l_Line_Adj_rec.updated_flag = FND_API.G_MISS_CHAR THEN
5721 l_Line_Adj_rec.updated_flag := NULL;
5722 END IF;
5723
5724 IF l_Line_Adj_rec.update_allowed = FND_API.G_MISS_CHAR THEN
5725 l_Line_Adj_rec.update_allowed := NULL;
5726 END IF;
5727
5728 IF l_Line_Adj_rec.applied_flag = FND_API.G_MISS_CHAR THEN
5729 l_Line_Adj_rec.applied_flag := NULL;
5730 END IF;
5731
5732 IF l_Line_Adj_rec.modifier_mechanism_type_code = FND_API.G_MISS_CHAR THEN
5733 l_Line_Adj_rec.modifier_mechanism_type_code := NULL;
5734 END IF;
5735
5736 IF l_Line_Adj_rec.change_reason_code = FND_API.G_MISS_CHAR THEN
5737 l_Line_Adj_rec.change_reason_code := NULL;
5738 END IF;
5739
5740 IF l_Line_Adj_rec.change_reason_text = FND_API.G_MISS_CHAR THEN
5741 l_Line_Adj_rec.change_reason_text := NULL ;
5742 END IF;
5743
5744 IF l_Line_Adj_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
5745 l_Line_Adj_rec.arithmetic_operator := NULL ;
5746 END IF;
5747
5748 IF l_Line_Adj_rec.operand = FND_API.G_MISS_NUM THEN
5749 l_Line_Adj_rec.operand := NULL ;
5750 END IF;
5751
5752 IF l_Line_Adj_rec.cost_id = FND_API.G_MISS_NUM THEN
5753 l_Line_Adj_rec.cost_id := NULL ;
5754 END IF;
5755
5756 IF l_Line_Adj_rec.tax_code = FND_API.G_MISS_CHAR THEN
5757 l_Line_Adj_rec.tax_code := NULL ;
5758 END IF;
5759
5760 IF l_Line_Adj_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN
5761 l_Line_Adj_rec.tax_exempt_flag := NULL ;
5762 END IF;
5763
5764 IF l_Line_Adj_rec.tax_exempt_number = FND_API.G_MISS_CHAR THEN
5765 l_Line_Adj_rec.tax_exempt_number := NULL ;
5766 END IF;
5767
5768 IF l_Line_Adj_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN
5769 l_Line_Adj_rec.tax_exempt_reason_code := NULL ;
5770 END IF;
5771
5772 IF l_Line_Adj_rec.parent_adjustment_id = FND_API.G_MISS_NUM THEN
5773 l_Line_Adj_rec.parent_adjustment_id := NULL ;
5774 END IF;
5775
5776 IF l_Line_Adj_rec.invoiced_flag = FND_API.G_MISS_CHAR THEN
5777 l_Line_Adj_rec.invoiced_flag := NULL ;
5778 END IF;
5779
5780 IF l_Line_Adj_rec.estimated_flag = FND_API.G_MISS_CHAR THEN
5781 l_Line_Adj_rec.estimated_flag := NULL ;
5782 END IF;
5783
5784 IF l_Line_Adj_rec.inc_in_sales_performance = FND_API.G_MISS_CHAR THEN
5785 l_Line_Adj_rec.inc_in_sales_performance := NULL ;
5786 END IF;
5787
5788 IF l_Line_Adj_rec.split_action_code = FND_API.G_MISS_CHAR THEN
5789 l_Line_Adj_rec.split_action_code := NULL ;
5790 END IF;
5791
5792 IF l_Line_Adj_rec.charge_type_code = FND_API.G_MISS_CHAR THEN
5793 l_Line_Adj_rec.charge_type_code := NULL ;
5794 END IF;
5795
5796 IF l_Line_Adj_rec.charge_subtype_code = FND_API.G_MISS_CHAR THEN
5797 l_Line_Adj_rec.charge_subtype_code := NULL ;
5798 END IF;
5799
5800 IF l_Line_Adj_rec.list_line_no = FND_API.G_MISS_CHAR THEN
5801 l_Line_Adj_rec.list_line_no := NULL ;
5802 END IF;
5803
5804 IF l_Line_Adj_rec.source_system_code = FND_API.G_MISS_CHAR THEN
5805 l_Line_Adj_rec.source_system_code := NULL ;
5806 END IF;
5807
5808 IF l_Line_Adj_rec.benefit_qty = FND_API.G_MISS_NUM THEN
5809 l_Line_Adj_rec.benefit_qty := NULL ;
5810 END IF;
5811
5812 IF l_Line_Adj_rec.benefit_uom_code = FND_API.G_MISS_CHAR THEN
5813 l_Line_Adj_rec.benefit_uom_code := NULL ;
5814 END IF;
5815
5816 IF l_Line_Adj_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
5817 l_Line_Adj_rec.print_on_invoice_flag := NULL ;
5818 END IF;
5819
5820 IF l_Line_Adj_rec.expiration_date = FND_API.G_MISS_DATE THEN
5821 l_Line_Adj_rec.expiration_date := NULL ;
5822 END IF;
5823
5824 IF l_Line_Adj_rec.rebate_transaction_type_code = FND_API.G_MISS_CHAR THEN
5825 l_Line_Adj_rec.rebate_transaction_type_code := NULL ;
5826 END IF;
5827
5828 IF l_Line_Adj_rec.rebate_transaction_reference = FND_API.G_MISS_CHAR THEN
5829 l_Line_Adj_rec.rebate_transaction_reference := NULL ;
5830 END IF;
5831
5832 IF l_Line_Adj_rec.rebate_payment_system_code = FND_API.G_MISS_CHAR THEN
5833 l_Line_Adj_rec.rebate_payment_system_code := NULL ;
5834 END IF;
5835
5836 IF l_Line_Adj_rec.redeemed_date = FND_API.G_MISS_DATE THEN
5837 l_Line_Adj_rec.redeemed_date := NULL ;
5838 END IF;
5839
5840 IF l_Line_Adj_rec.redeemed_flag = FND_API.G_MISS_CHAR THEN
5841 l_Line_Adj_rec.redeemed_flag := NULL ;
5842 END IF;
5843
5844 IF l_Line_Adj_rec.accrual_flag = FND_API.G_MISS_CHAR THEN
5845 l_Line_Adj_rec.accrual_flag := NULL ;
5846 END IF;
5847
5848 IF l_Line_Adj_rec.range_break_quantity = FND_API.G_MISS_NUM THEN
5849 l_Line_Adj_rec.range_break_quantity := NULL ;
5850 END IF;
5851
5852 IF l_Line_Adj_rec.accrual_conversion_rate = FND_API.G_MISS_NUM THEN
5853 l_Line_Adj_rec.accrual_conversion_rate := NULL ;
5854 END IF;
5855
5856 IF l_Line_Adj_rec.pricing_group_sequence = FND_API.G_MISS_NUM THEN
5857 l_Line_Adj_rec.pricing_group_sequence := NULL ;
5858 END IF;
5859
5860 IF l_Line_Adj_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
5861 l_Line_Adj_rec.modifier_level_code := NULL ;
5862 END IF;
5863
5864 IF l_Line_Adj_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
5865 l_Line_Adj_rec.price_break_type_code := NULL ;
5866 END IF;
5867
5868 IF l_Line_Adj_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
5869 l_Line_Adj_rec.substitution_attribute := NULL ;
5870 END IF;
5871
5872 IF l_Line_Adj_rec.proration_type_code = FND_API.G_MISS_CHAR THEN
5873 l_Line_Adj_rec.proration_type_code := NULL ;
5874 END IF;
5875
5876 IF l_Line_Adj_rec.credit_or_charge_flag = FND_API.G_MISS_CHAR THEN
5877 l_Line_Adj_rec.credit_or_charge_flag := NULL ;
5878 END IF;
5879
5880 IF l_Line_Adj_rec.include_on_returns_flag = FND_API.G_MISS_CHAR THEN
5881 l_Line_Adj_rec.include_on_returns_flag := NULL ;
5882 END IF;
5883
5884 IF l_Line_Adj_rec.ac_context = FND_API.G_MISS_CHAR THEN
5885 l_Line_Adj_rec.ac_context := NULL;
5886 END IF;
5887
5888 IF l_Line_Adj_rec.ac_attribute1 = FND_API.G_MISS_CHAR THEN
5889 l_Line_Adj_rec.ac_attribute1 := NULL;
5890 END IF;
5891
5892 IF l_Line_Adj_rec.ac_attribute2 = FND_API.G_MISS_CHAR THEN
5893 l_Line_Adj_rec.ac_attribute2 := NULL;
5894 END IF;
5895
5896 IF l_Line_Adj_rec.ac_attribute3 = FND_API.G_MISS_CHAR THEN
5897 l_Line_Adj_rec.ac_attribute3 := NULL;
5898 END IF;
5899
5900 IF l_Line_Adj_rec.ac_attribute4 = FND_API.G_MISS_CHAR THEN
5901 l_Line_Adj_rec.ac_attribute4 := NULL;
5902 END IF;
5903
5904 IF l_Line_Adj_rec.ac_attribute5 = FND_API.G_MISS_CHAR THEN
5905 l_Line_Adj_rec.ac_attribute5 := NULL;
5906 END IF;
5907
5908 IF l_Line_Adj_rec.ac_attribute6 = FND_API.G_MISS_CHAR THEN
5909 l_Line_Adj_rec.ac_attribute6 := NULL;
5910 END IF;
5911
5912 IF l_Line_Adj_rec.ac_attribute7 = FND_API.G_MISS_CHAR THEN
5913 l_Line_Adj_rec.ac_attribute7 := NULL;
5914 END IF;
5915
5916 IF l_Line_Adj_rec.ac_attribute8 = FND_API.G_MISS_CHAR THEN
5917 l_Line_Adj_rec.ac_attribute8 := NULL;
5918 END IF;
5919
5920 IF l_Line_Adj_rec.ac_attribute9 = FND_API.G_MISS_CHAR THEN
5921 l_Line_Adj_rec.ac_attribute9 := NULL;
5922 END IF;
5923
5924 IF l_Line_Adj_rec.ac_attribute10 = FND_API.G_MISS_CHAR THEN
5925 l_Line_Adj_rec.ac_attribute10 := NULL;
5926 END IF;
5927
5928 IF l_Line_Adj_rec.ac_attribute11 = FND_API.G_MISS_CHAR THEN
5929 l_Line_Adj_rec.ac_attribute11 := NULL;
5930 END IF;
5931
5932 IF l_Line_Adj_rec.ac_attribute12 = FND_API.G_MISS_CHAR THEN
5933 l_Line_Adj_rec.ac_attribute12 := NULL;
5934 END IF;
5935
5936 IF l_Line_Adj_rec.ac_attribute13 = FND_API.G_MISS_CHAR THEN
5937 l_Line_Adj_rec.ac_attribute13 := NULL;
5938 END IF;
5939
5940 IF l_Line_Adj_rec.ac_attribute14 = FND_API.G_MISS_CHAR THEN
5941 l_Line_Adj_rec.ac_attribute14 := NULL;
5942 END IF;
5943
5944 IF l_Line_Adj_rec.ac_attribute15 = FND_API.G_MISS_CHAR THEN
5945 l_Line_Adj_rec.ac_attribute15 := NULL;
5946 END IF;
5947
5948 --uom begin
5949 IF l_Line_Adj_rec.operand_per_pqty = FND_API.G_MISS_NUM THEN
5950 l_Line_Adj_rec.operand_per_pqty := NULL;
5951 END IF;
5952
5953 IF l_Line_Adj_rec.adjusted_amount_per_pqty = FND_API.G_MISS_NUM THEN
5954 l_Line_Adj_rec.adjusted_amount_per_pqty := NULL;
5955 END IF;
5956
5957 --uom end
5958
5959 IF l_Line_Adj_rec.invoiced_amount = FND_API.G_MISS_NUM THEN
5960 l_Line_Adj_rec.invoiced_amount := NULL ;
5961 END IF;
5962
5963 -- eBTax Changes
5964 If l_line_Adj_rec.tax_rate_id = FND_API.G_MISS_NUM THEN
5965 l_line_Adj_rec.tax_rate_id := NULL;
5966 END IF;
5967
5968 IF l_debug_level > 0 THEN
5969 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE ADJUSTMENT' , 1 ) ;
5970 END IF;
5971
5972 -- RETURN l_Line_Adj_rec;
5973 p_x_Line_Adj_rec := l_Line_Adj_rec;
5974
5975 END Convert_Miss_To_Null;
5976
5977
5978
5979 PROCEDURE Convert_Miss_To_Null
5980 ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
5981 )
5982 IS
5983 --
5984 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5985 --
5986 BEGIN
5987 IF l_debug_level > 0 THEN
5988 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE SCREDIT' , 1 ) ;
5989 END IF;
5990 IF p_x_Line_Scredit_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
5991 p_x_Line_Scredit_rec.ATTRIBUTE1 := NULL;
5992 END IF;
5993
5994 IF p_x_Line_Scredit_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
5995 p_x_Line_Scredit_rec.ATTRIBUTE10 := NULL;
5996 END IF;
5997
5998 IF p_x_Line_Scredit_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
5999 p_x_Line_Scredit_rec.ATTRIBUTE11 := NULL;
6000 END IF;
6001
6002 IF p_x_Line_Scredit_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
6003
6004 p_x_Line_Scredit_rec.ATTRIBUTE12 := NULL;
6005 END IF;
6006
6007 IF p_x_Line_Scredit_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
6008 p_x_Line_Scredit_rec.ATTRIBUTE13 := NULL;
6009 END IF;
6010
6011 IF p_x_Line_Scredit_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
6012 p_x_Line_Scredit_rec.ATTRIBUTE14 := NULL;
6013 END IF;
6014
6015 IF p_x_Line_Scredit_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
6016 p_x_Line_Scredit_rec.ATTRIBUTE15 := NULL;
6017
6018 END IF;
6019
6020 IF p_x_Line_Scredit_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
6021 p_x_Line_Scredit_rec.ATTRIBUTE2 := NULL;
6022 END IF;
6023
6024 IF p_x_Line_Scredit_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
6025 p_x_Line_Scredit_rec.ATTRIBUTE3 := NULL;
6026 END IF;
6027
6028 IF p_x_Line_Scredit_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
6029 p_x_Line_Scredit_rec.ATTRIBUTE4 := NULL;
6030 END IF;
6031
6032
6033 IF p_x_Line_Scredit_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
6034 p_x_Line_Scredit_rec.ATTRIBUTE5 := NULL;
6035 END IF;
6036
6037 IF p_x_Line_Scredit_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
6038 p_x_Line_Scredit_rec.ATTRIBUTE6 := NULL;
6039 END IF;
6040
6041 IF p_x_Line_Scredit_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
6042 p_x_Line_Scredit_rec.ATTRIBUTE7 := NULL;
6043 END IF;
6044
6045
6046 IF p_x_Line_Scredit_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
6047 p_x_Line_Scredit_rec.ATTRIBUTE8 := NULL;
6048 END IF;
6049
6050 IF p_x_Line_Scredit_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
6051 p_x_Line_Scredit_rec.ATTRIBUTE9 := NULL;
6052 END IF;
6053
6054 IF p_x_Line_Scredit_rec.CONTEXT = FND_API.G_MISS_CHAR THEN
6055 p_x_Line_Scredit_rec.CONTEXT := NULL;
6056 END IF;
6057
6058 IF p_x_Line_Scredit_rec.CREATED_BY = FND_API.G_MISS_NUM THEN
6059
6060 p_x_Line_Scredit_rec.CREATED_BY := NULL;
6061 END IF;
6062
6063 IF p_x_Line_Scredit_rec.CREATION_DATE = FND_API.G_MISS_DATE THEN
6064 p_x_Line_Scredit_rec.CREATION_DATE := NULL;
6065 END IF;
6066
6067 IF p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG = FND_API.G_MISS_CHAR THEN
6068 p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := NULL;
6069 END IF;
6070
6071 IF p_x_Line_Scredit_rec.HEADER_ID = FND_API.G_MISS_NUM THEN
6072
6073 p_x_Line_Scredit_rec.HEADER_ID := NULL;
6074 END IF;
6075
6076 IF p_x_Line_Scredit_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
6077
6078 p_x_Line_Scredit_rec.LAST_UPDATED_BY := NULL;
6079 END IF;
6080
6081 IF p_x_Line_Scredit_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
6082 p_x_Line_Scredit_rec.LAST_UPDATE_DATE := NULL;
6083 END IF;
6084
6085
6086 IF p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
6087 p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := NULL;
6088 END IF;
6089
6090 IF p_x_Line_Scredit_rec.LINE_ID = FND_API.G_MISS_NUM THEN
6091 p_x_Line_Scredit_rec.LINE_ID := NULL;
6092 END IF;
6093
6094 IF p_x_Line_Scredit_rec.LOCK_CONTROL = FND_API.G_MISS_NUM THEN
6095 p_x_Line_Scredit_rec.LOCK_CONTROL := NULL;
6096 END IF;
6097
6098
6099 IF p_x_Line_Scredit_rec.ORIG_SYS_CREDIT_REF = FND_API.G_MISS_CHAR THEN
6100 p_x_Line_Scredit_rec.ORIG_SYS_CREDIT_REF := NULL;
6101 END IF;
6102
6103 IF p_x_Line_Scredit_rec.PERCENT = FND_API.G_MISS_NUM THEN
6104 p_x_Line_Scredit_rec.PERCENT := NULL;
6105 END IF;
6106
6107 IF p_x_Line_Scredit_rec.SALESREP_ID = FND_API.G_MISS_NUM THEN
6108 p_x_Line_Scredit_rec.SALESREP_ID := NULL;
6109 END IF;
6110
6111
6112 IF p_x_Line_Scredit_rec.SALES_CREDIT_ID = FND_API.G_MISS_NUM THEN
6113
6114 p_x_Line_Scredit_rec.SALES_CREDIT_ID := NULL;
6115 END IF;
6116
6117 IF p_x_Line_Scredit_rec.SALES_CREDIT_TYPE_ID = FND_API.G_MISS_NUM THEN
6118 p_x_Line_Scredit_rec.SALES_CREDIT_TYPE_ID := NULL;
6119 END IF;
6120
6121 IF p_x_Line_Scredit_rec.WH_UPDATE_DATE = FND_API.G_MISS_DATE THEN
6122
6123 p_x_Line_Scredit_rec.WH_UPDATE_DATE := NULL;
6124
6125 END IF;
6126
6127 IF l_debug_level > 0 THEN
6128 oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE SCREDIT' , 1 ) ;
6129 END IF;
6130 END;
6131
6132
6133 END OE_CNCL_UTIL;