1 PACKAGE BODY OE_GENESIS_UTIL AS
2 /* $Header: OEXUGNIB.pls 120.1 2007/12/10 10:02:40 sahvivek noship $ */
3
4 -- Funtion source_aia_enabled
5
6 FUNCTION source_aia_enabled(p_source_id VARCHAR2)
7 RETURN BOOLEAN
8 IS
9 CURSOR l_enabled_sources_cur IS
10 SELECT order_source_id
11 FROM oe_order_sources
12 WHERE aia_enabled_flag = 'Y';
13 BEGIN
14 -- If the enabled sources global table is not yet initialized,
15 -- load the same.
16 IF NOT g_sources_loaded THEN
17 FOR enabled_source IN l_enabled_sources_cur
18 LOOP
19 g_enabled_sources_tab(enabled_source.order_source_id).enabled := 'Y';
20 END LOOP;
21 g_sources_loaded := TRUE;
22 END IF;
23
24 -- If the order source is enabled for AIA, it will be found in the
25 -- cached order sources table.
26 RETURN g_enabled_sources_tab.EXISTS(p_source_id);
27
28 END source_aia_enabled;
29
30
31 -- Procedure Convert_hdr_null_to_miss
32
33 PROCEDURE Convert_hdr_null_to_miss
34 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
35 )
36 IS
37 --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
38 BEGIN
39
40 oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
41
42 IF p_x_header_rec.accounting_rule_id IS NULL THEN
43 p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
44 END IF;
45
46 IF p_x_header_rec.accounting_rule_duration IS NULL THEN
47 p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
48 END IF;
49
50 IF p_x_header_rec.agreement_id IS NULL THEN
51 p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
52 END IF;
53
54 IF p_x_header_rec.blanket_number IS NULL THEN
55 p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
56 END IF;
57
58 IF p_x_header_rec.booked_flag IS NULL THEN
59 p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
60 END IF;
61
62 IF p_x_header_rec.upgraded_flag IS NULL THEN
63 p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
64 END IF;
65
66 IF p_x_header_rec.booked_date IS NULL THEN
67 p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
68 END IF;
69
70 IF p_x_header_rec.cancelled_flag IS NULL THEN
71 p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
72 END IF;
73
74 IF p_x_header_rec.attribute1 IS NULL THEN
75 p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
76 END IF;
77
78 IF p_x_header_rec.attribute10 IS NULL THEN
79 p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
80 END IF;
81
82 IF p_x_header_rec.attribute11 IS NULL THEN
83 p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
84 END IF;
85
86 IF p_x_header_rec.attribute12 IS NULL THEN
87 p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
88 END IF;
89
90 IF p_x_header_rec.attribute13 IS NULL THEN
91 p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
92 END IF;
93
94 IF p_x_header_rec.attribute14 IS NULL THEN
95 p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
96 END IF;
97
98 IF p_x_header_rec.attribute15 IS NULL THEN
99 p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
100 END IF;
101
102 IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
103 p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
104 END IF;
105
106 IF p_x_header_rec.attribute17 IS NULL THEN
107 p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
108 END IF;
109
110 IF p_x_header_rec.attribute18 IS NULL THEN
111 p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
112 END IF;
113
114 IF p_x_header_rec.attribute19 IS NULL THEN
115 p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
116 END IF;
117
118 IF p_x_header_rec.attribute2 IS NULL THEN
119 p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
120 END IF;
121
122 IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
123 p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
124 END IF;
125
126 IF p_x_header_rec.attribute3 IS NULL THEN
127 p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
128 END IF;
129
130 IF p_x_header_rec.attribute4 IS NULL THEN
131 p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
132 END IF;
133
134 IF p_x_header_rec.attribute5 IS NULL THEN
135 p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
136 END IF;
137
138 IF p_x_header_rec.attribute6 IS NULL THEN
139 p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
140 END IF;
141
142 IF p_x_header_rec.attribute7 IS NULL THEN
143 p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
144 END IF;
145
146 IF p_x_header_rec.attribute8 IS NULL THEN
147 p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
148 END IF;
149
150 IF p_x_header_rec.attribute9 IS NULL THEN
151 p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
152 END IF;
153
154 IF p_x_header_rec.context IS NULL THEN
155 p_x_header_rec.context := FND_API.G_MISS_CHAR;
156 END IF;
157
158 IF p_x_header_rec.conversion_rate IS NULL THEN
159 p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
160 END IF;
161
162 IF p_x_header_rec.conversion_rate_date IS NULL THEN
163 p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
164 END IF;
165
166 IF p_x_header_rec.conversion_type_code IS NULL THEN
167 p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
168 END IF;
169
170 IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
171 p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
172 END IF;
173
174 IF p_x_header_rec.created_by IS NULL THEN
175 p_x_header_rec.created_by := FND_API.G_MISS_NUM;
176 END IF;
177
178 IF p_x_header_rec.creation_date IS NULL THEN
179 p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
180 END IF;
181
182 IF p_x_header_rec.cust_po_number IS NULL THEN
183 p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
184 END IF;
185
186 IF p_x_header_rec.default_fulfillment_set IS NULL THEN
187 p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
188 END IF;
189
190 IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
191 p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
192 END IF;
193
194 IF p_x_header_rec.deliver_to_org_id IS NULL THEN
195 p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
196 END IF;
197
198 IF p_x_header_rec.demand_class_code IS NULL THEN
199 p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
200 END IF;
201
202 IF p_x_header_rec.expiration_date IS NULL THEN
203 p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
204 END IF;
205
206 IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
207 p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
208 END IF;
209
210 IF p_x_header_rec.fob_point_code IS NULL THEN
211 p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
212 END IF;
213
214 IF p_x_header_rec.freight_carrier_code IS NULL THEN
215 p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
216 END IF;
217
218 IF p_x_header_rec.freight_terms_code IS NULL THEN
219 p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
220 END IF;
221
222 IF p_x_header_rec.fulfillment_set_name IS NULL THEN
223 p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
224 END IF;
225
226 IF p_x_header_rec.global_attribute1 IS NULL THEN
227 p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
228 END IF;
229
230 IF p_x_header_rec.global_attribute10 IS NULL THEN
231 p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
232 END IF;
233
234 IF p_x_header_rec.global_attribute11 IS NULL THEN
235 p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
236 END IF;
237
238 IF p_x_header_rec.global_attribute12 IS NULL THEN
239 p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
240 END IF;
241
242 IF p_x_header_rec.global_attribute13 IS NULL THEN
243 p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
244 END IF;
245
246 IF p_x_header_rec.global_attribute14 IS NULL THEN
247 p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
248 END IF;
249
250 IF p_x_header_rec.global_attribute15 IS NULL THEN
251 p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
252 END IF;
253
254 IF p_x_header_rec.global_attribute16 IS NULL THEN
255 p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
256 END IF;
257
258 IF p_x_header_rec.global_attribute17 IS NULL THEN
259 p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
260 END IF;
261
262 IF p_x_header_rec.global_attribute18 IS NULL THEN
263 p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
264 END IF;
265
266 IF p_x_header_rec.global_attribute19 IS NULL THEN
267 p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
268 END IF;
269
270 IF p_x_header_rec.global_attribute2 IS NULL THEN
271 p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
272 END IF;
273
274 IF p_x_header_rec.global_attribute20 IS NULL THEN
275 p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
276 END IF;
277
278 IF p_x_header_rec.global_attribute3 IS NULL THEN
279 p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
280 END IF;
281
282 IF p_x_header_rec.global_attribute4 IS NULL THEN
283 p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
284 END IF;
285
286 IF p_x_header_rec.global_attribute5 IS NULL THEN
287 p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
288 END IF;
289
290 IF p_x_header_rec.global_attribute6 IS NULL THEN
291 p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
292 END IF;
293
294 IF p_x_header_rec.global_attribute7 IS NULL THEN
295 p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
296 END IF;
297
298 IF p_x_header_rec.global_attribute8 IS NULL THEN
299 p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
300 END IF;
301
302 IF p_x_header_rec.global_attribute9 IS NULL THEN
303 p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
304 END IF;
305
306 IF p_x_header_rec.global_attribute_category IS NULL THEN
307 p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
308 END IF;
309
310 IF p_x_header_rec.header_id IS NULL THEN
311 p_x_header_rec.header_id := FND_API.G_MISS_NUM;
312 END IF;
313
314 IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
315 p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
316 END IF;
317
318 IF p_x_header_rec.invoice_to_org_id IS NULL THEN
319 p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
320 END IF;
321
322 IF p_x_header_rec.invoicing_rule_id IS NULL THEN
323 p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
324 END IF;
325
326 IF p_x_header_rec.last_updated_by IS NULL THEN
327 p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
328 END IF;
329
330 IF p_x_header_rec.last_update_date IS NULL THEN
331 p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
332 END IF;
333
334 IF p_x_header_rec.last_update_login IS NULL THEN
335 p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
336 END IF;
337
338
339 IF p_x_header_rec.latest_schedule_limit IS NULL THEN
340 p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
341 END IF;
342
343 IF p_x_header_rec.line_set_name IS NULL THEN
344 p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
345 END IF;
346
347 IF p_x_header_rec.open_flag IS NULL THEN
348 p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
349 END IF;
350
351 IF p_x_header_rec.ordered_date IS NULL THEN
352 p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
353 END IF;
354
355 IF p_x_header_rec.order_date_type_code IS NULL THEN
356 p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
357 END IF;
358
359 IF p_x_header_rec.order_number IS NULL THEN
360 p_x_header_rec.order_number := FND_API.G_MISS_NUM;
361 END IF;
362
363 IF p_x_header_rec.order_source_id IS NULL THEN
364 p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
365 END IF;
366
367 IF p_x_header_rec.order_type_id IS NULL THEN
368 p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
369 END IF;
370 IF p_x_header_rec.order_category_code IS NULL THEN
371 p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
372 END IF;
373
374 IF p_x_header_rec.org_id IS NULL THEN
375 p_x_header_rec.org_id := FND_API.G_MISS_NUM;
376 END IF;
377
378 IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
379 p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
380 END IF;
381
382 IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
383 p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
384 END IF;
385
386 IF p_x_header_rec.payment_term_id IS NULL THEN
387 p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
388 END IF;
389
390 IF p_x_header_rec.price_list_id IS NULL THEN
391 p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
392 END IF;
393
394 IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
395 p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
396 END IF;
397
398 IF p_x_header_rec.pricing_date IS NULL THEN
399 p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
400 END IF;
401
402 IF p_x_header_rec.program_application_id IS NULL THEN
403 p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
404 END IF;
405
406 IF p_x_header_rec.program_id IS NULL THEN
407 p_x_header_rec.program_id := FND_API.G_MISS_NUM;
408 END IF;
409
410 IF p_x_header_rec.program_update_date IS NULL THEN
411 p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
412 END IF;
413
414 IF p_x_header_rec.request_date IS NULL THEN
415 p_x_header_rec.request_date := FND_API.G_MISS_DATE;
416 END IF;
417
418 IF p_x_header_rec.request_id IS NULL THEN
419 p_x_header_rec.request_id := FND_API.G_MISS_NUM;
420 END IF;
421
422 IF p_x_header_rec.return_reason_code IS NULL THEN
423 p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
424 END IF;
425
426 IF p_x_header_rec.salesrep_id IS NULL THEN
427 p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
428 END IF;
429
430 IF p_x_header_rec.sales_channel_code IS NULL THEN
431 p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
432 END IF;
433
434 IF p_x_header_rec.shipment_priority_code IS NULL THEN
435 p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
436 END IF;
437
438 IF p_x_header_rec.shipping_method_code IS NULL THEN
439 p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
440 END IF;
441
442 IF p_x_header_rec.ship_from_org_id IS NULL THEN
443 p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
444 END IF;
445
446 IF p_x_header_rec.ship_tolerance_above IS NULL THEN
447 p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
448 END IF;
449
450 IF p_x_header_rec.ship_tolerance_below IS NULL THEN
451 p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
452 END IF;
453
454 IF p_x_header_rec.ship_to_contact_id IS NULL THEN
455 p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
456 END IF;
457
458 IF p_x_header_rec.ship_to_org_id IS NULL THEN
459 p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
460 END IF;
461
462 IF p_x_header_rec.sold_from_org_id IS NULL THEN
463 p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
464 END IF;
465
466 IF p_x_header_rec.sold_to_contact_id IS NULL THEN
467 p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
468 END IF;
469
470 IF p_x_header_rec.sold_to_org_id IS NULL THEN
471 p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
472 END IF;
473
474 IF p_x_header_rec.sold_to_phone_id IS NULL THEN
475 p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
476 END IF;
477
478 IF p_x_header_rec.source_document_id IS NULL THEN
479 p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
480 END IF;
481
482 IF p_x_header_rec.source_document_type_id IS NULL THEN
483 p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
484 END IF;
485
486 IF p_x_header_rec.tax_exempt_flag IS NULL THEN
487 p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
488 END IF;
489
490 IF p_x_header_rec.tax_exempt_number IS NULL THEN
491 p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
492 END IF;
493
494 IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
495 p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
496 END IF;
497
498 IF p_x_header_rec.tax_point_code IS NULL THEN
499 p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
500 END IF;
501
502 IF p_x_header_rec.transactional_curr_code IS NULL THEN
503 p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
504 END IF;
505
506 IF p_x_header_rec.version_number IS NULL THEN
507 p_x_header_rec.version_number := FND_API.G_MISS_NUM;
508 END IF;
509
510 IF p_x_header_rec.payment_type_code IS NULL THEN
511 p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
512 END IF;
513
514 IF p_x_header_rec.payment_amount IS NULL THEN
515 p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
516 END IF;
517
518 IF p_x_header_rec.check_number IS NULL THEN
519 p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
520 END IF;
521
522 IF p_x_header_rec.credit_card_code IS NULL THEN
523 p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
524 END IF;
525
526 IF p_x_header_rec.credit_card_holder_name IS NULL THEN
527 p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
528 END IF;
529
530 IF p_x_header_rec.credit_card_number IS NULL THEN
531 p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
532 END IF;
533
534 IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
535 p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
536 END IF;
537
538 IF p_x_header_rec.credit_card_approval_date IS NULL THEN
539 p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
540 END IF;
541
542 IF p_x_header_rec.credit_card_approval_code IS NULL THEN
543 p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
544 END IF;
545
546 IF p_x_header_rec.first_ack_code IS NULL THEN
547 p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
548 END IF;
549
550 IF p_x_header_rec.first_ack_date IS NULL THEN
551 p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
552 END IF;
553
554 IF p_x_header_rec.last_ack_code IS NULL THEN
555 p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
556 END IF;
557
558 IF p_x_header_rec.last_ack_date IS NULL THEN
559 p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
560 END IF;
561
562 IF p_x_header_rec.shipping_instructions IS NULL THEN
563 p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
564 END IF;
565
566 IF p_x_header_rec.packing_instructions IS NULL THEN
567 p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
568 END IF;
569
570 IF p_x_header_rec.flow_status_code IS NULL THEN
571 p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
572 END IF;
573
574 IF p_x_header_rec.marketing_source_code_id IS NULL THEN
575 p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
576 END IF;
577
578 IF p_x_header_rec.change_sequence IS NULL THEN --2416561
579 p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
580 END IF;
581
582 -- QUOTING changes
583
584 IF p_x_header_rec.quote_date IS NULL THEN
585 p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
586 END IF;
587
588 IF p_x_header_rec.quote_number IS NULL THEN
589 p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
590 END IF;
591
592 IF p_x_header_rec.sales_document_name IS NULL THEN
593 p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
594 END IF;
595
596 IF p_x_header_rec.transaction_phase_code IS NULL THEN
597 p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
598 END IF;
599
600 IF p_x_header_rec.user_status_code IS NULL THEN
601 p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
602 END IF;
603
604 IF p_x_header_rec.draft_submitted_flag IS NULL THEN
605 p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
606 END IF;
607
608 IF p_x_header_rec.source_document_version_number IS NULL THEN
609 p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
610 END IF;
611
612 IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
613 p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
614 END IF;
615
616 -- QUOTING changes END
617
618 IF p_x_header_rec.Minisite_id IS NULL THEN
619 p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
620 END IF;
621
622 IF p_x_header_rec.End_customer_id IS NULL THEN
623 p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
624 END IF;
625
626 IF p_x_header_rec.End_customer_contact_id IS NULL THEN
627 p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
628 END IF;
629
630 IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
631 p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
632 END IF;
633
634 IF p_x_header_rec.Ib_owner IS NULL THEN
635 p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
636 END IF;
637
638 IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
639 p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
640 END IF;
641
642 IF p_x_header_rec.Ib_current_location IS NULL THEN
643 p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
644 END IF;
645
646 IF p_x_header_rec.supplier_signature IS NULL THEN
647 p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
648 END IF;
649
650 IF p_x_header_rec.supplier_signature_date IS NULL THEN
651 p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
652 END IF;
653
654 IF p_x_header_rec.customer_signature IS NULL THEN
655 p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
656 END IF;
657
658 IF p_x_header_rec.customer_signature_date IS NULL THEN
659 p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
660 END IF;
661
662 IF p_x_header_rec.contract_template_id IS NULL THEN
663 p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
664 END IF;
665
666 IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
667 p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
668 END IF;
669
670 IF p_x_header_rec.contract_source_document_id IS NULL THEN
671 p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
672 END IF;
673
674 --key Transaction dates
675 IF p_x_header_rec.order_firmed_date IS NULL THEN
676 p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
677 END IF;
678
679 oe_debug_pub.add('Exiting Convert_hdr_null_to_miss', 1);
680
681
682 END Convert_hdr_null_to_miss;
683
684
685
686 -- Procedure Convert_hdr_payment_null_to_miss
687
688 PROCEDURE Convert_hdr_pymnt_null_to_miss
689 ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
690 )
691 IS
692
693 --
694 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
695 --
696 BEGIN
697
698 oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
699
700 IF p_x_Header_Payment_rec.attribute1 IS NULL THEN
701 p_x_Header_Payment_rec.attribute1 := FND_API.G_MISS_CHAR;
702 END IF;
703
704 IF p_x_Header_Payment_rec.attribute2 IS NULL THEN
705 p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
706 END IF;
707
708 IF p_x_Header_Payment_rec.attribute3 IS NULL THEN
709 p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
710 END IF;
711
712 IF p_x_Header_Payment_rec.attribute4 IS NULL THEN
713 p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
714 END IF;
715
716 IF p_x_Header_Payment_rec.attribute5 IS NULL THEN
717 p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
718 END IF;
719
720 IF p_x_Header_Payment_rec.attribute6 IS NULL THEN
721 p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
722 END IF;
723
724 IF p_x_Header_Payment_rec.attribute7 IS NULL THEN
725 p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
726 END IF;
727
728 IF p_x_Header_Payment_rec.attribute8 IS NULL THEN
729 p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
730 END IF;
731
732 IF p_x_Header_Payment_rec.attribute9 IS NULL THEN
733 p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
734 END IF;
735
736 IF p_x_Header_Payment_rec.attribute10 IS NULL THEN
737 p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
738 END IF;
739
740 IF p_x_Header_Payment_rec.attribute11 IS NULL THEN
741 p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
742 END IF;
743
744 IF p_x_Header_Payment_rec.attribute12 IS NULL THEN
745 p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
746 END IF;
747
748 IF p_x_Header_Payment_rec.attribute13 IS NULL THEN
749 p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
750 END IF;
751
752 IF p_x_Header_Payment_rec.attribute14 IS NULL THEN
753 p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
754 END IF;
755
756 IF p_x_Header_Payment_rec.attribute15 IS NULL THEN
757 p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
758 END IF;
759
760 IF p_x_Header_Payment_rec.context IS NULL THEN
761 p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
762 END IF;
763
764 IF p_x_Header_Payment_rec.created_by IS NULL THEN
765 p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
766 END IF;
767
768 IF p_x_Header_Payment_rec.creation_date IS NULL THEN
769 p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
770 END IF;
771
772 IF p_x_Header_Payment_rec.last_updated_by IS NULL THEN
773 p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
774 END IF;
775
776 IF p_x_Header_Payment_rec.last_update_date IS NULL THEN
777 p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
778 END IF;
779
780 IF p_x_Header_Payment_rec.last_update_login IS NULL THEN
781 p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
782 END IF;
783
784 IF p_x_Header_Payment_rec.check_number IS NULL THEN
785 p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
786 END IF;
787
788 IF p_x_Header_Payment_rec.credit_card_approval_code IS NULL THEN
789 p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
790 END IF;
791
792 IF p_x_Header_Payment_rec.credit_card_approval_date IS NULL THEN
793 p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
794 END IF;
795
796 IF p_x_Header_Payment_rec.credit_card_code IS NULL THEN
797 p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
798 END IF;
799
800 IF p_x_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
801 p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
802 END IF;
803
804 IF p_x_Header_Payment_rec.credit_card_holder_name IS NULL THEN
805 p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
806 END IF;
807
808 IF p_x_Header_Payment_rec.credit_card_number IS NULL THEN
809 p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
810 END IF;
811
812 IF p_x_Header_Payment_rec.payment_level_code IS NULL THEN
813 p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
814 END IF;
815
816 IF p_x_Header_Payment_rec.commitment_applied_amount IS NULL THEN
817 p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
818 END IF;
819
820 IF p_x_Header_Payment_rec.commitment_interfaced_amount IS NULL THEN
821 p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
822 END IF;
823
824 IF p_x_Header_Payment_rec.payment_number IS NULL THEN
825 p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
826 END IF;
827
828 IF p_x_Header_Payment_rec.header_id IS NULL THEN
829 p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
830 END IF;
831
832 IF p_x_Header_Payment_rec.line_id IS NULL THEN
833 p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
834 END IF;
835
836 IF p_x_Header_Payment_rec.payment_amount IS NULL THEN
837 p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
838 END IF;
839
840 IF p_x_Header_Payment_rec.payment_collection_event IS NULL THEN
841 p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
842 END IF;
843
844 IF p_x_Header_Payment_rec.defer_payment_processing_flag IS NULL THEN
845 p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
846 END IF;
847
848 IF p_x_Header_Payment_rec.payment_trx_id IS NULL THEN
849 p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
850 END IF;
851
852 IF p_x_Header_Payment_rec.payment_type_code IS NULL THEN
853 p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
854 END IF;
855
856 IF p_x_Header_Payment_rec.payment_set_id IS NULL THEN
857 p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
858 END IF;
859
860 IF p_x_Header_Payment_rec.prepaid_amount IS NULL THEN
861 p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
862 END IF;
863
864 IF p_x_Header_Payment_rec.program_application_id IS NULL THEN
865 p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
866 END IF;
867
868 IF p_x_Header_Payment_rec.program_id IS NULL THEN
869 p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
870 END IF;
871
872 IF p_x_Header_Payment_rec.program_update_date IS NULL THEN
873 p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
874 END IF;
875
876 IF p_x_Header_Payment_rec.receipt_method_id IS NULL THEN
877 p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
878 END IF;
879
880 IF p_x_Header_Payment_rec.request_id IS NULL THEN
881 p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
882 END IF;
883
884 IF p_x_Header_Payment_rec.tangible_id IS NULL THEN
885 p_x_Header_Payment_rec.tangible_id := FND_API.G_MISS_CHAR;
886 END IF;
887
888 oe_debug_pub.add('Exiting OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
889
890 END Convert_hdr_pymnt_null_to_miss;
891
892
893
894
895
896 /*-----------------------------------------------------------
897 PROCEDURE Convert_Line_null_to_miss
898 -----------------------------------------------------------*/
899
900 PROCEDURE Convert_Line_null_to_miss
901 ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
902 )
903 IS
904 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
905 BEGIN
906
907 if l_debug_level > 0 then
908 oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
909 end if;
910
911 IF p_x_line_rec.unit_cost IS NULL THEN
912 p_x_line_rec.unit_cost := FND_API.G_MISS_NUM;
913 END IF;
914
915
916 IF p_x_line_rec.accounting_rule_id IS NULL THEN
917 p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
918 END IF;
919
920 IF p_x_line_rec.accounting_rule_duration IS NULL THEN
921 p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
922 END IF;
923
924 IF p_x_line_rec.actual_arrival_date IS NULL THEN
925 p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
926 END IF;
927
928 IF p_x_line_rec.actual_shipment_date IS NULL THEN
929 p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
930 END IF;
931
932 IF p_x_line_rec.agreement_id IS NULL THEN
933 p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
934 END IF;
935 IF p_x_line_rec.arrival_set_id IS NULL THEN
936 p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
937 END IF;
938
939 IF p_x_line_rec.ato_line_id IS NULL THEN
940 p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
941 END IF;
942 IF p_x_line_rec.upgraded_flag IS NULL THEN
943 p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
944 END IF;
945
946 IF p_x_line_rec.attribute1 IS NULL THEN
947 p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
948 END IF;
949
950 IF p_x_line_rec.attribute10 IS NULL THEN
951 p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
952 END IF;
953
954 IF p_x_line_rec.attribute11 IS NULL THEN
955 p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
956 END IF;
957
958 IF p_x_line_rec.attribute12 IS NULL THEN
959 p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
960 END IF;
961
962 IF p_x_line_rec.attribute13 IS NULL THEN
963 p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
964 END IF;
965
966 IF p_x_line_rec.attribute14 IS NULL THEN
967 p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
968 END IF;
969
970 IF p_x_line_rec.attribute15 IS NULL THEN
971 p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
972 END IF;
973
974 IF p_x_line_rec.attribute16 IS NULL THEN --For bug 2184255
975 p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
976 END IF;
977
978 IF p_x_line_rec.attribute17 IS NULL THEN
979 p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
980 END IF;
981
982 IF p_x_line_rec.attribute18 IS NULL THEN
983 p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
984 END IF;
985
986 IF p_x_line_rec.attribute19 IS NULL THEN
987 p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
988 END IF;
989
990 IF p_x_line_rec.attribute2 IS NULL THEN
991 p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
992 END IF;
993
994 IF p_x_line_rec.attribute20 IS NULL THEN
995 p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
996 END IF;
997
998 IF p_x_line_rec.attribute3 IS NULL THEN
999 p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
1000 END IF;
1001
1002 IF p_x_line_rec.attribute4 IS NULL THEN
1003 p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
1004 END IF;
1005
1006 IF p_x_line_rec.attribute5 IS NULL THEN
1007 p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
1008 END IF;
1009
1010 IF p_x_line_rec.attribute6 IS NULL THEN
1011 p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
1012 END IF;
1013
1014 IF p_x_line_rec.attribute7 IS NULL THEN
1015 p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
1016 END IF;
1017
1018 IF p_x_line_rec.attribute8 IS NULL THEN
1019 p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
1020 END IF;
1021
1022 IF p_x_line_rec.attribute9 IS NULL THEN
1023 p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
1024 END IF;
1025
1026 IF p_x_line_rec.auto_selected_quantity IS NULL THEN
1027 p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
1028 END IF;
1029 IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
1030 p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
1031 END IF;
1032
1033 IF p_x_line_rec.booked_flag IS NULL THEN
1034 p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
1035 END IF;
1036
1037 IF p_x_line_rec.cancelled_flag IS NULL THEN
1038 p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1039 END IF;
1040
1041 IF p_x_line_rec.cancelled_quantity IS NULL THEN
1042 p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1043 END IF;
1044
1045 IF p_x_line_rec.component_code IS NULL THEN
1046 p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
1047 END IF;
1048
1049 IF p_x_line_rec.component_number IS NULL THEN
1050 p_x_line_rec.component_number := FND_API.G_MISS_NUM;
1051 END IF;
1052
1053 IF p_x_line_rec.component_sequence_id IS NULL THEN
1054 p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
1055 END IF;
1056
1057 IF p_x_line_rec.config_header_id IS NULL THEN
1058 p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
1059 END IF;
1060
1061 IF p_x_line_rec.config_rev_nbr IS NULL THEN
1062 p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
1063 END IF;
1064
1065 IF p_x_line_rec.config_display_sequence IS NULL THEN
1066 p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
1067 END IF;
1068
1069 IF p_x_line_rec.configuration_id IS NULL THEN
1070 p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
1071 END IF;
1072
1073 IF p_x_line_rec.context IS NULL THEN
1074 p_x_line_rec.context := FND_API.G_MISS_CHAR;
1075 END IF;
1076
1077
1078
1079
1080
1081 IF p_x_line_rec.created_by IS NULL THEN
1082 p_x_line_rec.created_by := FND_API.G_MISS_NUM;
1083 END IF;
1084
1085 IF p_x_line_rec.creation_date IS NULL THEN
1086 p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
1087 END IF;
1088
1089 IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
1090 p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
1091 END IF;
1092
1093 IF p_x_line_rec.customer_dock_code IS NULL THEN
1094 p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
1095 END IF;
1096
1097 IF p_x_line_rec.customer_job IS NULL THEN
1098 p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
1099 END IF;
1100
1101 IF p_x_line_rec.customer_production_line IS NULL THEN
1102 p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
1103 END IF;
1104
1105 IF p_x_line_rec.cust_production_seq_num IS NULL THEN
1106 p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
1107 END IF;
1108
1109 IF p_x_line_rec.customer_trx_line_id IS NULL THEN
1110 p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
1111 END IF;
1112
1113 IF p_x_line_rec.cust_model_serial_number IS NULL THEN
1114 p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
1115 END IF;
1116
1117 IF p_x_line_rec.cust_po_number IS NULL THEN
1118 p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
1119 END IF;
1120
1121 IF p_x_line_rec.customer_line_number IS NULL THEN
1122 p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
1123 END IF;
1124
1125 IF p_x_line_rec.customer_shipment_number IS NULL THEN
1126 p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
1127 END IF;
1128
1129 IF p_x_line_rec.delivery_lead_time IS NULL THEN
1130 p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
1131 END IF;
1132
1133 IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
1134 p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
1135 END IF;
1136
1137 IF p_x_line_rec.deliver_to_org_id IS NULL THEN
1138 p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
1139 END IF;
1140
1141 IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
1142 p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
1143 END IF;
1144
1145 IF p_x_line_rec.demand_class_code IS NULL THEN
1146 p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
1147 END IF;
1148
1149 IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
1150 p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
1151 END IF;
1152
1153
1154 IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
1155 p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
1156 END IF;
1157
1158 IF p_x_line_rec.explosion_date IS NULL THEN
1159 p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
1160 END IF;
1161
1162 IF p_x_line_rec.fob_point_code IS NULL THEN
1163 p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
1164 END IF;
1165
1166 IF p_x_line_rec.freight_carrier_code IS NULL THEN
1167 p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
1168 END IF;
1169
1170 IF p_x_line_rec.freight_terms_code IS NULL THEN
1171 p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
1172 END IF;
1173
1174 IF p_x_line_rec.fulfilled_quantity IS NULL THEN
1175 p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
1176 END IF;
1177
1178 IF p_x_line_rec.fulfilled_flag IS NULL THEN
1179 p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
1180 END IF;
1181
1182 IF p_x_line_rec.fulfillment_method_code IS NULL THEN
1183 p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
1184 END IF;
1185
1186 IF p_x_line_rec.fulfillment_date IS NULL THEN
1187 p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
1188 END IF;
1189
1190 IF p_x_line_rec.global_attribute1 IS NULL THEN
1191 p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
1192 END IF;
1193
1194 IF p_x_line_rec.global_attribute10 IS NULL THEN
1195 p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
1196 END IF;
1197
1198 IF p_x_line_rec.global_attribute11 IS NULL THEN
1199 p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
1200 END IF;
1201
1202 IF p_x_line_rec.global_attribute12 IS NULL THEN
1203 p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
1204 END IF;
1205
1206 IF p_x_line_rec.global_attribute13 IS NULL THEN
1207 p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
1208 END IF;
1209
1210 IF p_x_line_rec.global_attribute14 IS NULL THEN
1211 p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
1212 END IF;
1213
1214 IF p_x_line_rec.global_attribute15 IS NULL THEN
1215 p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
1216 END IF;
1217
1218 IF p_x_line_rec.global_attribute16 IS NULL THEN
1219 p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
1220 END IF;
1221
1222 IF p_x_line_rec.global_attribute17 IS NULL THEN
1223 p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
1224 END IF;
1225
1226 IF p_x_line_rec.global_attribute18 IS NULL THEN
1227 p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
1228 END IF;
1229
1230 IF p_x_line_rec.global_attribute19 IS NULL THEN
1231 p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
1232 END IF;
1233
1234 IF p_x_line_rec.global_attribute2 IS NULL THEN
1235 p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
1236 END IF;
1237
1238 IF p_x_line_rec.global_attribute20 IS NULL THEN
1239 p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
1240 END IF;
1241
1242 IF p_x_line_rec.global_attribute3 IS NULL THEN
1243 p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
1244 END IF;
1245
1246 IF p_x_line_rec.global_attribute4 IS NULL THEN
1247 p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
1248 END IF;
1249
1250 IF p_x_line_rec.global_attribute5 IS NULL THEN
1251 p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
1252 END IF;
1253
1254 IF p_x_line_rec.global_attribute6 IS NULL THEN
1255 p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
1256 END IF;
1257
1258 IF p_x_line_rec.global_attribute7 IS NULL THEN
1259 p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
1260 END IF;
1261
1262 IF p_x_line_rec.global_attribute8 IS NULL THEN
1263 p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
1264 END IF;
1265
1266 IF p_x_line_rec.global_attribute9 IS NULL THEN
1267 p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
1268 END IF;
1269
1270 IF p_x_line_rec.global_attribute_category IS NULL THEN
1271 p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
1272 END IF;
1273
1274 IF p_x_line_rec.header_id IS NULL THEN
1275 p_x_line_rec.header_id := FND_API.G_MISS_NUM;
1276 END IF;
1277
1278 IF p_x_line_rec.industry_attribute1 IS NULL THEN
1279 p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
1280 END IF;
1281
1282 IF p_x_line_rec.industry_attribute10 IS NULL THEN
1283 p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
1284 END IF;
1285
1286 IF p_x_line_rec.industry_attribute11 IS NULL THEN
1287 p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
1288 END IF;
1289
1290 IF p_x_line_rec.industry_attribute12 IS NULL THEN
1291 p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
1292 END IF;
1293
1294 IF p_x_line_rec.industry_attribute13 IS NULL THEN
1295 p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
1296 END IF;
1297
1298 IF p_x_line_rec.industry_attribute14 IS NULL THEN
1299 p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
1300 END IF;
1301
1302 IF p_x_line_rec.industry_attribute15 IS NULL THEN
1303 p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
1304 END IF;
1305
1306 IF p_x_line_rec.industry_attribute16 IS NULL THEN
1307 p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
1308 END IF;
1309 IF p_x_line_rec.industry_attribute17 IS NULL THEN
1310 p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
1311 END IF;
1312 IF p_x_line_rec.industry_attribute18 IS NULL THEN
1313 p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
1314 END IF;
1315 IF p_x_line_rec.industry_attribute19 IS NULL THEN
1316 p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
1317 END IF;
1318 IF p_x_line_rec.industry_attribute20 IS NULL THEN
1319 p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
1320 END IF;
1321 IF p_x_line_rec.industry_attribute21 IS NULL THEN
1322 p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
1323 END IF;
1324 IF p_x_line_rec.industry_attribute22 IS NULL THEN
1325 p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
1326 END IF;
1327 IF p_x_line_rec.industry_attribute23 IS NULL THEN
1328 p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
1329 END IF;
1330 IF p_x_line_rec.industry_attribute24 IS NULL THEN
1331 p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
1332 END IF;
1333 IF p_x_line_rec.industry_attribute25 IS NULL THEN
1334 p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
1335 END IF;
1336 IF p_x_line_rec.industry_attribute26 IS NULL THEN
1337 p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
1338 END IF;
1339 IF p_x_line_rec.industry_attribute27 IS NULL THEN
1340 p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
1341 END IF;
1342 IF p_x_line_rec.industry_attribute28 IS NULL THEN
1343 p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
1344 END IF;
1345 IF p_x_line_rec.industry_attribute29 IS NULL THEN
1346 p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
1347 END IF;
1348 IF p_x_line_rec.industry_attribute30 IS NULL THEN
1349 p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
1350 END IF;
1351
1352
1353 IF p_x_line_rec.industry_attribute2 IS NULL THEN
1354 p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
1355 END IF;
1356
1357 IF p_x_line_rec.industry_attribute3 IS NULL THEN
1358 p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
1359 END IF;
1360
1361 IF p_x_line_rec.industry_attribute4 IS NULL THEN
1362 p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
1363 END IF;
1364
1365 IF p_x_line_rec.industry_attribute5 IS NULL THEN
1366 p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
1367 END IF;
1368
1369 IF p_x_line_rec.industry_attribute6 IS NULL THEN
1370 p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
1371 END IF;
1372
1373 IF p_x_line_rec.industry_attribute7 IS NULL THEN
1374 p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
1375 END IF;
1376
1377 IF p_x_line_rec.industry_attribute8 IS NULL THEN
1378 p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
1379 END IF;
1380
1381 IF p_x_line_rec.industry_attribute9 IS NULL THEN
1382 p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
1383 END IF;
1384
1385 IF p_x_line_rec.industry_context IS NULL THEN
1386 p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
1387 END IF;
1388
1389 /* TP_ATTRIBUTE */
1390 IF p_x_line_rec.tp_context IS NULL THEN
1391 p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
1392 END IF;
1393 IF p_x_line_rec.tp_attribute1 IS NULL THEN
1394 p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
1395 END IF;
1396 IF p_x_line_rec.tp_attribute2 IS NULL THEN
1397 p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
1398 END IF;
1399 IF p_x_line_rec.tp_attribute3 IS NULL THEN
1400 p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
1401 END IF;
1402 IF p_x_line_rec.tp_attribute4 IS NULL THEN
1403 p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
1404 END IF;
1405 IF p_x_line_rec.tp_attribute5 IS NULL THEN
1406 p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
1407 END IF;
1408 IF p_x_line_rec.tp_attribute6 IS NULL THEN
1409 p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
1410 END IF;
1411 IF p_x_line_rec.tp_attribute7 IS NULL THEN
1412 p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
1413 END IF;
1414 IF p_x_line_rec.tp_attribute8 IS NULL THEN
1415 p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
1416 END IF;
1417 IF p_x_line_rec.tp_attribute9 IS NULL THEN
1418 p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
1419 END IF;
1420 IF p_x_line_rec.tp_attribute10 IS NULL THEN
1421 p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
1422 END IF;
1423 IF p_x_line_rec.tp_attribute11 IS NULL THEN
1424 p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
1425 END IF;
1426 IF p_x_line_rec.tp_attribute12 IS NULL THEN
1427 p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
1428 END IF;
1429 IF p_x_line_rec.tp_attribute13 IS NULL THEN
1430 p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
1431 END IF;
1432 IF p_x_line_rec.tp_attribute14 IS NULL THEN
1433 p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
1434 END IF;
1435 IF p_x_line_rec.tp_attribute15 IS NULL THEN
1436 p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
1437 END IF;
1438
1439
1440 IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
1441 p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
1442 END IF;
1443
1444 IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
1445 p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
1446 END IF;
1447
1448 IF p_x_line_rec.inventory_item_id IS NULL THEN
1449 p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
1450 END IF;
1451
1452 IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
1453 p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
1454 END IF;
1455
1456
1457
1458 IF p_x_line_rec.invoice_to_contact_id IS NULL THEN
1459 p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
1460 END IF;
1461
1462 IF p_x_line_rec.invoiced_quantity IS NULL THEN
1463 p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
1464 END IF;
1465
1466 IF p_x_line_rec.invoice_to_org_id IS NULL THEN
1467 p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1468 END IF;
1469
1470 IF p_x_line_rec.invoicing_rule_id IS NULL THEN
1471 p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
1472 END IF;
1473
1474 IF p_x_line_rec.ordered_item_id IS NULL THEN
1475 p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
1476 END IF;
1477
1478 IF p_x_line_rec.item_identifier_type IS NULL THEN
1479 p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1480 END IF;
1481
1482 IF p_x_line_rec.ordered_item IS NULL THEN
1483 p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
1484 END IF;
1485
1486 IF p_x_line_rec.item_revision IS NULL THEN
1487 p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
1488 END IF;
1489
1490 IF p_x_line_rec.item_type_code IS NULL THEN
1491 p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
1492 END IF;
1493
1494 IF p_x_line_rec.last_updated_by IS NULL THEN
1495 p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
1496 END IF;
1497
1498 IF p_x_line_rec.last_update_date IS NULL THEN
1499 p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
1500 END IF;
1501
1502 IF p_x_line_rec.last_update_login IS NULL THEN
1503 p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
1504 END IF;
1505
1506 IF p_x_line_rec.latest_acceptable_date IS NULL THEN
1507 p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
1508 END IF;
1509
1510 IF p_x_line_rec.line_category_code IS NULL THEN
1511 p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
1512 END IF;
1513
1514 IF p_x_line_rec.line_id IS NULL THEN
1515 p_x_line_rec.line_id := FND_API.G_MISS_NUM;
1516 END IF;
1517
1518 IF p_x_line_rec.line_number IS NULL THEN
1519 p_x_line_rec.line_number := FND_API.G_MISS_NUM;
1520 END IF;
1521
1522 IF p_x_line_rec.line_type_id IS NULL THEN
1523 p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
1524 END IF;
1525
1526 IF p_x_line_rec.link_to_line_id IS NULL THEN
1527 p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
1528 END IF;
1529
1530 IF p_x_line_rec.model_group_number IS NULL THEN
1531 p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
1532 END IF;
1533
1534 IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
1535 p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
1536 END IF;
1537
1538 IF p_x_line_rec.mfg_lead_time IS NULL THEN
1539 p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
1540 END IF;
1541
1542 IF p_x_line_rec.open_flag IS NULL THEN
1543 p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
1544 END IF;
1545
1546 IF p_x_line_rec.option_flag IS NULL THEN
1547 p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
1548 END IF;
1549
1550 IF p_x_line_rec.option_number IS NULL THEN
1551 p_x_line_rec.option_number := FND_API.G_MISS_NUM;
1552 END IF;
1553
1554 IF p_x_line_rec.ordered_quantity IS NULL THEN
1555 p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
1556 END IF;
1557
1558 IF p_x_line_rec.order_quantity_uom IS NULL THEN
1559 p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1560 END IF;
1561
1562 -- OPM 02/JUN/00 - Deal with process attributes
1563 -- IS===========================================
1564 IF p_x_line_rec.ordered_quantity2 IS NULL THEN
1565 p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
1566 END IF;
1567
1568 IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
1569 p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
1570 END IF;
1571 -- OPM 02/JUN/00 - END
1572 -- IS==================
1573
1574 IF p_x_line_rec.org_id IS NULL THEN
1575 p_x_line_rec.org_id := FND_API.G_MISS_NUM;
1576 END IF;
1577
1578 IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
1579 p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
1580 END IF;
1581
1582 IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
1583 p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
1584 END IF;
1585
1586 IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
1587 p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
1588 END IF;
1589
1590 IF p_x_line_rec.original_list_price IS NULL THEN
1591 p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
1592 END IF;
1593
1594 IF p_x_line_rec.over_ship_reason_code IS NULL THEN
1595 p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
1596 END IF;
1597 IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
1598 p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
1599 END IF;
1600
1601 IF p_x_line_rec.payment_term_id IS NULL THEN
1602 p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
1603 END IF;
1604
1605 IF p_x_line_rec.planning_priority IS NULL THEN
1606 p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
1607 END IF;
1608
1609 -- OPM 02/JUN/00 - Deal with process attributes
1610 -- IS===========================================
1611 IF p_x_line_rec.preferred_grade IS NULL THEN
1612 p_x_line_rec.preferred_grade := FND_API.G_MISS_CHAR;
1613 END IF;
1614 -- OPM 02/JUN/00 - END
1615 -- IS==================
1616
1617 IF p_x_line_rec.price_list_id IS NULL THEN
1618 p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
1619 END IF;
1620
1621 IF p_x_line_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
1622 p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
1623 END IF;
1624
1625 IF p_x_line_rec.pricing_attribute1 IS NULL THEN
1626 p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
1627 END IF;
1628
1629 IF p_x_line_rec.pricing_attribute10 IS NULL THEN
1630 p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
1631 END IF;
1632
1633 IF p_x_line_rec.pricing_attribute2 IS NULL THEN
1634 p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
1635 END IF;
1636
1637 IF p_x_line_rec.pricing_attribute3 IS NULL THEN
1638 p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
1639 END IF;
1640
1641 IF p_x_line_rec.pricing_attribute4 IS NULL THEN
1642 p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
1643 END IF;
1644
1645 IF p_x_line_rec.pricing_attribute5 IS NULL THEN
1646 p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
1647 END IF;
1648
1649 IF p_x_line_rec.pricing_attribute6 IS NULL THEN
1650 p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
1651 END IF;
1652
1653 IF p_x_line_rec.pricing_attribute7 IS NULL THEN
1654 p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
1655 END IF;
1656
1657 IF p_x_line_rec.pricing_attribute8 IS NULL THEN
1658 p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
1659 END IF;
1660
1661 IF p_x_line_rec.pricing_attribute9 IS NULL THEN
1662 p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
1663 END IF;
1664
1665 IF p_x_line_rec.pricing_context IS NULL THEN
1666 p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
1667 END IF;
1668
1669 IF p_x_line_rec.pricing_date IS NULL THEN
1670 p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
1671 END IF;
1672
1673 IF p_x_line_rec.pricing_quantity IS NULL THEN
1674 p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
1675 END IF;
1676
1677 IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
1678 p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
1679 END IF;
1680
1681 IF p_x_line_rec.program_application_id IS NULL THEN
1682 p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
1683 END IF;
1684
1685 IF p_x_line_rec.program_id IS NULL THEN
1686 p_x_line_rec.program_id := FND_API.G_MISS_NUM;
1687 END IF;
1688
1689 IF p_x_line_rec.program_update_date IS NULL THEN
1690 p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
1691 END IF;
1692
1693 IF p_x_line_rec.project_id IS NULL THEN
1694 p_x_line_rec.project_id := FND_API.G_MISS_NUM;
1695 END IF;
1696
1697 IF p_x_line_rec.promise_date IS NULL THEN
1698 p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
1699 END IF;
1700
1701 IF p_x_line_rec.re_source_flag IS NULL THEN
1702 p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
1703 END IF;
1704
1705 IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
1706 p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
1707 END IF;
1708
1709 IF p_x_line_rec.reference_header_id IS NULL THEN
1710 p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
1711 END IF;
1712
1713 IF p_x_line_rec.reference_line_id IS NULL THEN
1714 p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
1715 END IF;
1716
1717 IF p_x_line_rec.reference_type IS NULL THEN
1718 p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
1719 END IF;
1720
1721
1722
1723 IF p_x_line_rec.request_date IS NULL THEN
1724 p_x_line_rec.request_date := FND_API.G_MISS_DATE;
1725 END IF;
1726
1727 IF p_x_line_rec.request_id IS NULL THEN
1728 p_x_line_rec.request_id := FND_API.G_MISS_NUM;
1729 END IF;
1730
1731 IF p_x_line_rec.return_attribute1 IS NULL THEN
1732 p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
1733 END IF;
1734
1735 IF p_x_line_rec.return_attribute10 IS NULL THEN
1736 p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
1737 END IF;
1738
1739 IF p_x_line_rec.return_attribute11 IS NULL THEN
1740 p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
1741 END IF;
1742
1743 IF p_x_line_rec.return_attribute12 IS NULL THEN
1744 p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
1745 END IF;
1746
1747 IF p_x_line_rec.return_attribute13 IS NULL THEN
1748 p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
1749 END IF;
1750
1751 IF p_x_line_rec.return_attribute14 IS NULL THEN
1752 p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
1753 END IF;
1754
1755 IF p_x_line_rec.return_attribute15 IS NULL THEN
1756 p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
1757 END IF;
1758
1759 IF p_x_line_rec.return_attribute2 IS NULL THEN
1760 p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
1761 END IF;
1762
1763 IF p_x_line_rec.return_attribute3 IS NULL THEN
1764 p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
1765 END IF;
1766
1767 IF p_x_line_rec.return_attribute4 IS NULL THEN
1768 p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
1769 END IF;
1770
1771 IF p_x_line_rec.return_attribute5 IS NULL THEN
1772 p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
1773 END IF;
1774
1775 IF p_x_line_rec.return_attribute6 IS NULL THEN
1776 p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
1777 END IF;
1778
1779 IF p_x_line_rec.return_attribute7 IS NULL THEN
1780 p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
1781 END IF;
1782
1783 IF p_x_line_rec.return_attribute8 IS NULL THEN
1784 p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
1785 END IF;
1786
1787 IF p_x_line_rec.return_attribute9 IS NULL THEN
1788 p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
1789 END IF;
1790
1791 IF p_x_line_rec.return_context IS NULL THEN
1792 p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
1793 END IF;
1794 IF p_x_line_rec.return_reason_code IS NULL THEN
1795 p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
1796 END IF;
1797 IF p_x_line_rec.salesrep_id IS NULL THEN
1798 p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
1799 END IF;
1800
1801 IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
1802 p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
1803 END IF;
1804
1805 IF p_x_line_rec.schedule_arrival_date IS NULL THEN
1806 p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
1807 END IF;
1808
1809 IF p_x_line_rec.schedule_ship_date IS NULL THEN
1810 p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
1811 END IF;
1812
1813 IF p_x_line_rec.schedule_action_code IS NULL THEN
1814 p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
1815 END IF;
1816
1817 IF p_x_line_rec.schedule_status_code IS NULL THEN
1818 p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
1819 END IF;
1820
1821 IF p_x_line_rec.shipment_number IS NULL THEN
1822 p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
1823 END IF;
1824
1825 IF p_x_line_rec.shipment_priority_code IS NULL THEN
1826 p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
1827 END IF;
1828
1829 IF p_x_line_rec.shipped_quantity IS NULL THEN
1830 p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
1831 END IF;
1832
1833 IF p_x_line_rec.shipped_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
1834 p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1835 END IF;
1836
1837 IF p_x_line_rec.shipping_method_code IS NULL THEN
1838 p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
1839 END IF;
1840
1841 IF p_x_line_rec.shipping_quantity IS NULL THEN
1842 p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
1843 END IF;
1844
1845 IF p_x_line_rec.shipping_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
1846 p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
1847 END IF;
1848
1849 IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
1850 p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
1851 END IF;
1852
1853 IF p_x_line_rec.ship_from_org_id IS NULL THEN
1854 p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1855 END IF;
1856
1857 IF p_x_line_rec.subinventory IS NULL THEN
1858 p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
1859 END IF;
1860
1861 IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
1862 p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
1863 END IF;
1864 IF p_x_line_rec.ship_set_id IS NULL THEN
1865 p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
1866 END IF;
1867
1868 IF p_x_line_rec.ship_tolerance_above IS NULL THEN
1869 p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
1870 END IF;
1871
1872 IF p_x_line_rec.ship_tolerance_below IS NULL THEN
1873 p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
1874 END IF;
1875
1876 IF p_x_line_rec.shippable_flag IS NULL THEN
1877 p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
1878 END IF;
1879
1880 IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
1881 p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
1882 END IF;
1883
1884 IF p_x_line_rec.ship_to_contact_id IS NULL THEN
1885 p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
1886 END IF;
1887
1888 IF p_x_line_rec.ship_to_org_id IS NULL THEN
1889 p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1890 END IF;
1891
1892 IF p_x_line_rec.sold_from_org_id IS NULL THEN
1893 p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
1894 END IF;
1895
1896 IF p_x_line_rec.sold_to_org_id IS NULL THEN
1897 p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
1898 END IF;
1899
1900 IF p_x_line_rec.sort_order IS NULL THEN
1901 p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
1902 END IF;
1903
1904 IF p_x_line_rec.source_document_id IS NULL THEN
1905 p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
1906 END IF;
1907
1908 IF p_x_line_rec.source_document_line_id IS NULL THEN
1909 p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
1910 END IF;
1911
1912 IF p_x_line_rec.source_document_type_id IS NULL THEN
1913 p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
1914 END IF;
1915
1916 IF p_x_line_rec.source_type_code IS NULL THEN
1917 p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
1918 END IF;
1919 IF p_x_line_rec.split_from_line_id IS NULL THEN
1920 p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
1921 END IF;
1922 IF p_x_line_rec.line_set_id IS NULL THEN
1923 p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
1924 END IF;
1925
1926 IF p_x_line_rec.split_by IS NULL THEN
1927 p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
1928 END IF;
1929 IF p_x_line_rec.model_remnant_flag IS NULL THEN
1930 p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
1931 END IF;
1932 IF p_x_line_rec.task_id IS NULL THEN
1933 p_x_line_rec.task_id := FND_API.G_MISS_NUM;
1934 END IF;
1935
1936 IF p_x_line_rec.tax_code IS NULL THEN
1937 p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
1938 END IF;
1939
1940 IF p_x_line_rec.tax_date IS NULL THEN
1941 p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
1942 END IF;
1943
1944 IF p_x_line_rec.tax_exempt_flag IS NULL THEN
1945 p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
1946 END IF;
1947
1948 IF p_x_line_rec.tax_exempt_number IS NULL THEN
1949 p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
1950 END IF;
1951
1952 IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
1953 p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
1954 END IF;
1955
1956 IF p_x_line_rec.tax_point_code IS NULL THEN
1957 p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
1958 END IF;
1959
1960 IF p_x_line_rec.tax_rate IS NULL THEN
1961 p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
1962 END IF;
1963
1964 IF p_x_line_rec.tax_value IS NULL THEN
1965 p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
1966 END IF;
1967
1968 IF p_x_line_rec.top_model_line_id IS NULL THEN
1969 p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
1970 END IF;
1971
1972 IF p_x_line_rec.unit_list_price IS NULL THEN
1973 p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
1974 END IF;
1975
1976 IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
1977 p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
1978 END IF;
1979
1980 IF p_x_line_rec.unit_selling_price IS NULL THEN
1981 p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
1982 END IF;
1983
1984 IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
1985 p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
1986 END IF;
1987
1988
1989 IF p_x_line_rec.visible_demand_flag IS NULL THEN
1990 p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
1991 END IF;
1992 IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
1993 p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
1994 END IF;
1995
1996 IF p_x_line_rec.first_ack_code IS NULL THEN
1997 p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
1998 END IF;
1999
2000 IF p_x_line_rec.first_ack_date IS NULL THEN
2001 p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
2002 END IF;
2003
2004 IF p_x_line_rec.last_ack_code IS NULL THEN
2005 p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
2006 END IF;
2007
2008 IF p_x_line_rec.last_ack_date IS NULL THEN
2009 p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
2010 END IF;
2011
2012
2013 IF p_x_line_rec.end_item_unit_number IS NULL THEN
2014 p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2015 END IF;
2016
2017 IF p_x_line_rec.shipping_instructions IS NULL THEN
2018 p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2019 END IF;
2020
2021 IF p_x_line_rec.packing_instructions IS NULL THEN
2022 p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
2023 END IF;
2024
2025 -- Service related columns
2026
2027 IF p_x_line_rec.service_txn_reason_code IS NULL THEN
2028 p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
2029 END IF;
2030
2031 IF p_x_line_rec.service_txn_comments IS NULL THEN
2032 p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
2033 END IF;
2034
2035 IF p_x_line_rec.service_duration IS NULL THEN
2036 p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
2037 END IF;
2038
2039 IF p_x_line_rec.service_period IS NULL THEN
2040 p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
2041 END IF;
2042
2043 IF p_x_line_rec.service_start_date IS NULL THEN
2044 p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
2045 END IF;
2046
2047 IF p_x_line_rec.service_end_date IS NULL THEN
2048 p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
2049 END IF;
2050
2051 IF p_x_line_rec.service_coterminate_flag IS NULL THEN
2052 p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
2053 END IF;
2054
2055
2056 IF p_x_line_rec.unit_list_percent IS NULL THEN
2057 p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
2058 END IF;
2059
2060 IF p_x_line_rec.unit_selling_percent IS NULL THEN
2061 p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
2062 END IF;
2063
2064 IF p_x_line_rec.unit_percent_base_price IS NULL THEN
2065 p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
2066 END IF;
2067
2068 IF p_x_line_rec.service_number IS NULL THEN
2069 p_x_line_rec.service_number := FND_API.G_MISS_NUM;
2070 END IF;
2071
2072 IF p_x_line_rec.service_reference_type_code IS NULL THEN
2073 p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
2074 END IF;
2075
2076 IF p_x_line_rec.service_reference_line_id IS NULL THEN
2077 p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
2078 END IF;
2079
2080 IF p_x_line_rec.service_reference_system_id IS NULL THEN
2081 p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
2082 END IF;
2083
2084 /* Marketing source code related */
2085
2086 IF p_x_line_rec.marketing_source_code_id IS NULL THEN
2087 p_x_line_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
2088 END IF;
2089
2090 /* End of Marketing source code related */
2091
2092 IF p_x_line_rec.order_source_id IS NULL THEN
2093 p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
2094 END IF;
2095
2096 IF p_x_line_rec.flow_status_code IS NULL THEN
2097 p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
2098 END IF;
2099
2100 -- Commitment related
2101 IF p_x_line_rec.commitment_id IS NULL THEN
2102 p_x_line_rec.commitment_id := FND_API.G_MISS_NUM;
2103 END IF;
2104
2105
2106 -- Item Substitution changes.
2107 IF p_x_line_rec.Original_Inventory_Item_Id IS NULL THEN
2108 p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
2109 END IF;
2110
2111 IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
2112 p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
2113 END IF;
2114
2115 IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
2116 p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
2117 END IF;
2118
2119 IF p_x_line_rec.Original_ordered_item IS NULL THEN
2120 p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
2121 END IF;
2122
2123 IF p_x_line_rec.item_relationship_type IS NULL THEN
2124 p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
2125 END IF;
2126
2127 IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
2128 p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
2129 END IF;
2130
2131 IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
2132 p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
2133 END IF;
2134
2135 IF p_x_line_rec.Override_atp_date_code IS NULL THEN
2136 p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
2137 END IF;
2138
2139 -- Changes for Blanket Orders
2140
2141 IF p_x_line_rec.Blanket_Number IS NULL THEN
2142 p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
2143 END IF;
2144
2145 IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
2146 p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
2147 END IF;
2148
2149 IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
2150 p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
2151 END IF;
2152
2153 -- QUOTING changes
2154 IF p_x_line_rec.transaction_phase_code IS NULL THEN
2155 p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
2156 END IF;
2157
2158 IF p_x_line_rec.source_document_version_number IS NULL THEN
2159 p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
2160 END IF;
2161 -- END QUOTING changes
2162 IF p_x_line_rec.Minisite_id IS NULL THEN
2163 p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
2164 END IF;
2165
2166 IF p_x_line_rec.End_customer_id IS NULL THEN
2167 p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
2168 END IF;
2169
2170 IF p_x_line_rec.End_customer_contact_id IS NULL THEN
2171 p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2172 END IF;
2173
2174 IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
2175 p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2176 END IF;
2177
2178 IF p_x_line_rec.ib_owner IS NULL THEN
2179 p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
2180 END IF;
2181
2182 IF p_x_line_rec.ib_installed_at_location IS NULL THEN
2183 p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
2184 END IF;
2185
2186 IF p_x_line_rec.ib_current_location IS NULL THEN
2187 p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
2188 END IF;
2189
2190 --retro{
2191 IF p_x_line_rec.retrobill_request_id IS NULL THEN
2192 p_x_line_rec.retrobill_request_id := FND_API.G_MISS_NUM;
2193 END IF;
2194 --retro}
2195
2196 IF p_x_line_rec.firm_demand_flag IS NULL THEN
2197 p_x_line_rec.firm_demand_flag := FND_API.G_MISS_CHAR;
2198 END IF;
2199
2200 --key Transaction Dates
2201 IF p_x_line_rec.order_firmed_date IS NULL THEN
2202 p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
2203 END IF;
2204
2205 IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
2206 p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
2207 END IF;
2208 --end
2209
2210 /* IF p_x_line_rec.supplier_signature IS NULL THEN
2211 p_x_line_rec.supplier_signature := FND_API.G_MISS_CHAR;
2212 END IF;
2213
2214 IF p_x_line_rec.supplier_signature_date IS NULL THEN
2215 p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2216 END IF;
2217
2218 IF p_x_line_rec.customer_signature IS NULL THEN
2219 p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
2220 END IF;
2221
2222 IF p_x_line_rec.customer_signature_date IS NULL THEN
2223 p_x_line_rec.customer_signature_date := FND_API.G_MISS_CHAR;
2224 END IF;
2225 */
2226
2227 if l_debug_level > 0 then
2228 oe_debug_pub.add('Exiting OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
2229 end if;
2230 END Convert_Line_null_to_miss;
2231
2232
2233
2234 procedure print_po_payload (
2235 P_HEADER_REC APPS.OE_ORDER_PUB.HEADER_REC_TYPE,
2236 P_HEADER_VAL_REC APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE,
2237 P_HEADER_PAYMENT_TBL APPS.OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE,
2238 P_LINE_TBL APPS.OE_ORDER_PUB.LINE_TBL_TYPE
2239 )
2240 IS
2241
2242 BEGIN
2243 --oe_debug_pub.initialize;
2244 --l_temp_var := oe_debug_pub.set_debug_mode('FILE');
2245 --oe_debug_pub.debug_on;
2246 --oe_debug_pub.add('Inside the cover API');
2247 --oe_debug_pub.add('Line table count is '||p_line_tbl.COUNT);
2248
2249
2250 -- All the parameters that are being passed in
2251 oe_debug_pub.add('P_HEADER_REC.BOOKED_FLAG:' || P_HEADER_REC.BOOKED_FLAG);
2252 oe_debug_pub.add('P_HEADER_REC.CUST_PO_NUMBER:' || P_HEADER_REC.CUST_PO_NUMBER);
2253 oe_debug_pub.add('P_HEADER_REC.FREIGHT_CARRIER_CODE:' || P_HEADER_REC.FREIGHT_CARRIER_CODE);
2254 oe_debug_pub.add('P_HEADER_REC.FREIGHT_TERMS_CODE:' || P_HEADER_REC.FREIGHT_TERMS_CODE);
2255 oe_debug_pub.add('P_HEADER_REC.ORDERED_DATE:' || P_HEADER_REC.ORDERED_DATE);
2256 oe_debug_pub.add('P_HEADER_REC.ORDER_TYPE_ID:' || P_HEADER_REC.ORDER_TYPE_ID);
2257 oe_debug_pub.add('P_HEADER_REC.ORG_ID:' || P_HEADER_REC.ORG_ID);
2258 oe_debug_pub.add('P_HEADER_REC.ORIG_SYS_DOCUMENT_REF:' || P_HEADER_REC.ORIG_SYS_DOCUMENT_REF);
2259 oe_debug_pub.add('P_HEADER_REC.order_source_id:' || P_HEADER_REC.order_source_id);
2260 oe_debug_pub.add('P_HEADER_REC.PAYMENT_TERM_I:' || P_HEADER_REC.PAYMENT_TERM_ID);
2261 oe_debug_pub.add('P_HEADER_REC.PRICE_LIST_ID:' || P_HEADER_REC.PRICE_LIST_ID);
2262 oe_debug_pub.add('P_HEADER_REC.PRICING_DATE:' || P_HEADER_REC.PRICING_DATE);
2263 oe_debug_pub.add('P_HEADER_REC.REQUEST_DATE:' || P_HEADER_REC.REQUEST_DATE);
2264 oe_debug_pub.add('P_HEADER_REC.SHIPPING_METHOD_CODE:' || P_HEADER_REC.SHIPPING_METHOD_CODE);
2265 oe_debug_pub.add('P_HEADER_REC.SHIP_FROM_ORG_ID:' || P_HEADER_REC.SHIP_FROM_ORG_ID);
2266 oe_debug_pub.add('P_HEADER_REC.SHIP_TO_ORG_ID:' || P_HEADER_REC.SHIP_TO_ORG_ID);
2267 oe_debug_pub.add('P_HEADER_REC.SOLD_TO_ORG_ID:' || P_HEADER_REC.SOLD_TO_ORG_ID);
2268 oe_debug_pub.add('P_HEADER_REC.TRANSACTIONAL_CURR_CODE:' || P_HEADER_REC.TRANSACTIONAL_CURR_CODE);
2269 oe_debug_pub.add('P_HEADER_REC.VERSION_NUMBER:' || P_HEADER_REC.VERSION_NUMBER);
2270 oe_debug_pub.add('P_HEADER_REC.OPERATION:' || P_HEADER_REC.OPERATION);
2271
2272 oe_debug_pub.add('P_HEADER_VAL_REC.FREIGHT_TERMS:' || P_HEADER_VAL_REC.FREIGHT_TERMS);
2273 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_ADDRESS1:' || P_HEADER_VAL_REC.INVOICE_TO_ADDRESS1);
2274 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_ADDRESS2:' || P_HEADER_VAL_REC.INVOICE_TO_ADDRESS2);
2275 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_ADDRESS3:' || P_HEADER_VAL_REC.INVOICE_TO_ADDRESS3);
2276 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_ADDRESS4:' || P_HEADER_VAL_REC.INVOICE_TO_ADDRESS4);
2277 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_STATE:' || P_HEADER_VAL_REC.INVOICE_TO_STATE);
2278 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_CITY:' || P_HEADER_VAL_REC.INVOICE_TO_CITY);
2279 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_ZIP:' || P_HEADER_VAL_REC.INVOICE_TO_ZIP);
2280 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_COUNTRY:' || P_HEADER_VAL_REC.INVOICE_TO_COUNTRY);
2281 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_COUNTY:' || P_HEADER_VAL_REC.INVOICE_TO_COUNTY);
2282 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_PROVINCE:' || P_HEADER_VAL_REC.INVOICE_TO_PROVINCE);
2283 oe_debug_pub.add('P_HEADER_VAL_REC.INVOICE_TO_CONTACT:' || P_HEADER_VAL_REC.INVOICE_TO_CONTACT);
2284 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_ADDRESS1:' || P_HEADER_VAL_REC.SHIP_TO_ADDRESS1);
2285 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_ADDRESS2:' || P_HEADER_VAL_REC.SHIP_TO_ADDRESS2);
2286 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_ADDRESS3:' || P_HEADER_VAL_REC.SHIP_TO_ADDRESS3);
2287 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_ADDRESS4:' || P_HEADER_VAL_REC.SHIP_TO_ADDRESS4);
2288 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_STATE:' || P_HEADER_VAL_REC.SHIP_TO_STATE);
2289 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_COUNTRY:' || P_HEADER_VAL_REC.SHIP_TO_COUNTRY);
2290 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_ZIP:' || P_HEADER_VAL_REC.SHIP_TO_ZIP);
2291 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_CITY:' || P_HEADER_VAL_REC.SHIP_TO_CITY);
2292 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_CONTACT:' || P_HEADER_VAL_REC.SHIP_TO_CONTACT);
2293 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_CONTACT_LAST_NAME:' || P_HEADER_VAL_REC.SHIP_TO_CONTACT_LAST_NAME);
2294 oe_debug_pub.add('P_HEADER_VAL_REC.SHIP_TO_CONTACT_FIRST_NAME:' || P_HEADER_VAL_REC.SHIP_TO_CONTACT_FIRST_NAME);
2295
2296 if P_LINE_TBL.COUNT > 0 THEN
2297 for i in P_LINE_TBL.FIRST .. P_LINE_TBL.LAST LOOP
2298 oe_debug_pub.add('P_LINE_TBL(i).CANCELLED_QUANTITY:' || P_LINE_TBL(i).CANCELLED_QUANTITY);
2299 oe_debug_pub.add('P_LINE_TBL(i).CONFIG_HEADER_ID:' || P_LINE_TBL(i).CONFIG_HEADER_ID);
2300 oe_debug_pub.add('P_LINE_TBL(i).CONFIG_REV_NBR:' || P_LINE_TBL(i).CONFIG_REV_NBR);
2301 oe_debug_pub.add('P_LINE_TBL(i).CONFIGURATION_ID:' || P_LINE_TBL(i).CONFIGURATION_ID);
2302 oe_debug_pub.add('P_LINE_TBL(i).item_type_code:' || P_LINE_TBL(i).item_type_code);
2303 oe_debug_pub.add('P_LINE_TBL(i).FREIGHT_CARRIER_CODE:' || P_LINE_TBL(i).FREIGHT_CARRIER_CODE);
2304 oe_debug_pub.add('P_LINE_TBL(i).FREIGHT_TERMS_CODE:' || P_LINE_TBL(i).FREIGHT_TERMS_CODE);
2305 oe_debug_pub.add('P_LINE_TBL(i).INVENTORY_ITEM_ID:' || P_LINE_TBL(i).INVENTORY_ITEM_ID);
2306 oe_debug_pub.add('P_LINE_TBL(i).ORDERED_QUANTITY:' || P_LINE_TBL(i).ORDERED_QUANTITY);
2307 oe_debug_pub.add('P_LINE_TBL(i).ORDER_QUANTITY_UOM:' || P_LINE_TBL(i).ORDER_QUANTITY_UOM);
2308 oe_debug_pub.add('P_LINE_TBL(i).ORIG_SYS_LINE_REF:' || P_LINE_TBL(i).ORIG_SYS_LINE_REF);
2309 oe_debug_pub.add('P_LINE_TBL(i).order_source_id:' || P_LINE_TBL(i).order_source_id);
2310 oe_debug_pub.add('P_LINE_TBL(i).PRICING_DATE:' || P_LINE_TBL(i).PRICING_DATE);
2311 oe_debug_pub.add('P_LINE_TBL(i).REQUEST_DATE:' || P_LINE_TBL(i).REQUEST_DATE);
2312 oe_debug_pub.add('P_LINE_TBL(i).RETURN_REASON_CODE:' || P_LINE_TBL(i).RETURN_REASON_CODE);
2313 oe_debug_pub.add('P_LINE_TBL(i).SHIPPING_METHOD_CODE:' || P_LINE_TBL(i).SHIPPING_METHOD_CODE);
2314 oe_debug_pub.add('P_LINE_TBL(i).SHIP_TO_ORG_ID:' || P_LINE_TBL(i).SHIP_TO_ORG_ID);
2315 oe_debug_pub.add('P_LINE_TBL(i).UNIT_LIST_PRICE:' || P_LINE_TBL(i).UNIT_LIST_PRICE);
2316 oe_debug_pub.add('P_LINE_TBL(i).UNIT_SELLING_PRICE:' || P_LINE_TBL(i).UNIT_SELLING_PRICE);
2317 oe_debug_pub.add('P_LINE_TBL(i).OPERATION:' || P_LINE_TBL(i).OPERATION);
2318
2319 -- oe_debug_pub.add('P_LINE_VAL_TBL(i).SHIP_TO_ADDRESS1:' || P_LINE_VAL_TBL(i).SHIP_TO_ADDRESS1);
2320 -- oe_debug_pub.add('P_LINE_VAL_TBL(i).SHIP_TO_STATE:' || P_LINE_VAL_TBL(i).SHIP_TO_STATE);
2321 -- oe_debug_pub.add('P_LINE_VAL_TBL(i).SHIP_TO_CONTACT:' || P_LINE_VAL_TBL(i).SHIP_TO_CONTACT);
2322
2323 end loop;
2324 END IF;
2325
2326
2327
2328 end print_po_payload;
2329
2330
2331
2332 END OE_GENESIS_UTIL;