[Home] [Help]
26:
27: -- Clear_Dependents
28:
29: PROCEDURE Clear_Dependents
30: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
31: ,p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
32: ,p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
33: ,p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
34: ,p_x_instrument_id IN NUMBER DEFAULT NULL
33: ,p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
34: ,p_x_instrument_id IN NUMBER DEFAULT NULL
35: ,p_old_instrument_id IN NUMBER DEFAULT NULL)
36: IS
37: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
38:
39: PROCEDURE ACCOUNTING_RULE
40: IS
41: BEGIN
39: PROCEDURE ACCOUNTING_RULE
40: IS
41: BEGIN
42: IF (p_initial_header_rec.accounting_rule_id = FND_API.G_MISS_NUM
43: OR (OE_GLOBALS.Equal(p_initial_header_rec.accounting_rule_id, p_old_header_rec.accounting_rule_id)
44: AND (p_old_header_rec.header_id IS NOT NULL OR
45: p_initial_header_rec.accounting_rule_id IS NOT NULL))
46: ) -- AND condition added to fix 3098878
47: THEN
52: PROCEDURE ACCOUNTING_RULE_DURATION
53: IS
54: BEGIN
55: IF (p_initial_header_rec.accounting_rule_duration = FND_API.G_MISS_NUM
56: OR (OE_GLOBALS.Equal(p_initial_header_rec.accounting_rule_duration, p_old_header_rec.accounting_rule_duration)
57: AND (p_old_header_rec.header_id IS NOT NULL OR
58: p_initial_header_rec.accounting_rule_duration IS NOT NULL))
59: ) -- AND condition added to fix 3098878
60: THEN
64:
65: PROCEDURE AGREEMENT IS
66: BEGIN
67: IF (p_initial_header_rec.agreement_id = FND_API.G_MISS_NUM
68: OR (OE_GLOBALS.Equal(p_initial_header_rec.agreement_id, p_old_header_rec.agreement_id)
69: AND (p_old_header_rec.header_id IS NOT NULL OR
70: p_initial_header_rec.agreement_id IS NOT NULL))
71: ) -- AND condition added to fix 3098878
72: THEN
76:
77: PROCEDURE CONVERSION_RATE IS
78: BEGIN
79: IF (p_initial_header_rec.conversion_rate = FND_API.G_MISS_NUM
80: OR (OE_GLOBALS.Equal(p_initial_header_rec.conversion_rate, p_old_header_rec.conversion_rate)
81: AND (p_old_header_rec.header_id IS NOT NULL OR
82: p_initial_header_rec.conversion_rate IS NOT NULL))
83: ) -- AND condition added to fix 3098878
84: THEN
88:
89: PROCEDURE CONVERSION_RATE_DATE IS
90: BEGIN
91: IF (p_initial_header_rec.conversion_rate_date = FND_API.G_MISS_DATE
92: OR (OE_GLOBALS.Equal(p_initial_header_rec.conversion_rate_date, p_old_header_rec.conversion_rate_date)
93: AND (p_old_header_rec.header_id IS NOT NULL OR
94: p_initial_header_rec.conversion_rate_date IS NOT NULL))
95: ) -- AND condition added to fix 3098878
96: THEN
100:
101: PROCEDURE CONVERSION_TYPE IS
102: BEGIN
103: IF (p_initial_header_rec.conversion_type_code = FND_API.G_MISS_CHAR
104: OR (OE_GLOBALS.Equal(p_initial_header_rec.conversion_type_code, p_old_header_rec.conversion_type_code)
105: AND (p_old_header_rec.header_id IS NOT NULL OR
106: p_initial_header_rec.conversion_type_code IS NOT NULL))
107: ) -- AND condition added to fix 3098878
108: THEN
112:
113: PROCEDURE CREDIT_CARD_EXPIRATION_DATE IS
114: BEGIN
115: IF (p_initial_header_rec.credit_card_expiration_date = FND_API.G_MISS_DATE
116: OR (OE_GLOBALS.Equal(p_initial_header_rec.credit_card_expiration_date, p_old_header_rec.credit_card_expiration_date)
117: AND (p_old_header_rec.header_id IS NOT NULL OR
118: p_initial_header_rec.credit_card_expiration_date IS NOT NULL)
119: AND nvl(g_is_cc_selected_from_LOV,'N') <> 'Y') --bug 5083663
120: ) -- AND condition added to fix 3098878
125:
126: PROCEDURE CREDIT_CARD_HOLDER_NAME IS
127: BEGIN
128: IF (p_initial_header_rec.credit_card_holder_name = FND_API.G_MISS_CHAR
129: OR (OE_GLOBALS.Equal(p_initial_header_rec.credit_card_holder_name, p_old_header_rec.credit_card_holder_name)
130: AND (p_old_header_rec.header_id IS NOT NULL OR
131: p_initial_header_rec.credit_card_holder_name IS NOT NULL)
132: AND nvl(g_is_cc_selected_from_LOV,'N') <> 'Y') --bug 5083663
133: ) -- AND condition added to fix 3098878
138:
139: PROCEDURE CREDIT_CARD_NUMBER IS
140: BEGIN
141: IF (p_initial_header_rec.credit_card_number = FND_API.G_MISS_CHAR
142: OR (OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_initial_header_rec.credit_card_number,
143: p_old_instrument_id,p_x_instrument_id)
144: AND (p_old_header_rec.header_id IS NOT NULL OR
145: p_initial_header_rec.credit_card_number IS NOT NULL))
146: ) -- AND condition added to fix 3098878
154: /* Fix Bug # 2297053: Added to clear Credit Card Type */
155: PROCEDURE CREDIT_CARD IS
156: BEGIN
157: IF (p_initial_header_rec.credit_card_code = FND_API.G_MISS_CHAR
158: OR (OE_GLOBALS.Equal(p_initial_header_rec.credit_card_code, p_old_header_rec.credit_card_code)
159: AND (p_old_header_rec.header_id IS NOT NULL OR
160: p_initial_header_rec.credit_card_code IS NOT NULL))
161: ) -- AND condition added to fix 3098878
162: THEN
166:
167: PROCEDURE CHECK_NUMBER IS --For bug 2692314
168: BEGIN
169: IF (p_initial_header_rec.check_number = FND_API.G_MISS_CHAR
170: OR (OE_GLOBALS.Equal(p_initial_header_rec.check_number, p_old_header_rec.check_number)
171: AND (p_old_header_rec.header_id IS NOT NULL OR
172: p_initial_header_rec.check_number IS NOT NULL))
173: ) -- AND condition added to fix 3098878
174: THEN
178:
179: PROCEDURE CUST_PO_NUMBER IS
180: BEGIN
181: IF (p_initial_header_rec.cust_po_number = FND_API.G_MISS_CHAR
182: OR (OE_GLOBALS.Equal(p_initial_header_rec.cust_po_number, p_old_header_rec.cust_po_number)
183: AND (p_old_header_rec.header_id IS NOT NULL OR
184: p_initial_header_rec.cust_po_number IS NOT NULL))
185: ) -- AND condition added to fix 3098878
186: THEN
190:
191: PROCEDURE CUSTOMER_PREFERENCE_SET_CODE IS
192: BEGIN
193: IF (p_initial_header_rec.Customer_Preference_Set_Code = FND_API.G_MISS_CHAR
194: OR (OE_GLOBALS.Equal(p_initial_header_rec.Customer_Preference_Set_Code, p_old_header_rec.Customer_Preference_Set_Code)
195: AND (p_old_header_rec.header_id IS NOT NULL OR
196: p_initial_header_rec.Customer_Preference_Set_Code IS NOT NULL))
197: ) -- AND condition added to fix 3098878
198: THEN
202:
203: PROCEDURE DEFAULT_FULFILLMENT_SET IS
204: BEGIN
205: IF (p_initial_header_rec.Default_Fulfillment_Set = FND_API.G_MISS_CHAR
206: OR (OE_GLOBALS.Equal(p_initial_header_rec.Default_Fulfillment_Set, p_old_header_rec.Default_Fulfillment_Set)
207: AND (p_old_header_rec.header_id IS NOT NULL OR
208: p_initial_header_rec.Default_Fulfillment_Set IS NOT NULL))
209: ) -- AND condition added to fix 3098878
210: THEN
214:
215: PROCEDURE DELIVER_TO_CONTACT IS
216: BEGIN
217: IF (p_initial_header_rec.deliver_to_contact_id = FND_API.G_MISS_NUM
218: OR (OE_GLOBALS.Equal(p_initial_header_rec.deliver_to_contact_id, p_old_header_rec.deliver_to_contact_id)
219: AND (p_old_header_rec.header_id IS NOT NULL OR
220: p_initial_header_rec.deliver_to_contact_id IS NOT NULL))
221: ) -- AND condition added to fix 3098878
222: THEN
226:
227: PROCEDURE DELIVER_TO_ORG IS
228: BEGIN
229: IF (p_initial_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM
230: OR (OE_GLOBALS.Equal(p_initial_header_rec.deliver_to_org_id, p_old_header_rec.deliver_to_org_id)
231: AND (p_old_header_rec.header_id IS NOT NULL OR
232: p_initial_header_rec.deliver_to_org_id IS NOT NULL))
233: ) -- AND condition added to fix 3098878
234: THEN
238:
239: PROCEDURE DEMAND_CLASS IS
240: BEGIN
241: IF (p_initial_header_rec.demand_class_code = FND_API.G_MISS_CHAR
242: OR (OE_GLOBALS.Equal(p_initial_header_rec.demand_class_code, p_old_header_rec.demand_class_code)
243: AND (p_old_header_rec.header_id IS NOT NULL OR
244: p_initial_header_rec.demand_class_code IS NOT NULL))
245: ) -- AND condition added to fix 3098878
246: THEN
250:
251: PROCEDURE FOB_POINT IS
252: BEGIN
253: IF (p_initial_header_rec.fob_point_code = FND_API.G_MISS_CHAR
254: OR (OE_GLOBALS.Equal(p_initial_header_rec.fob_point_code, p_old_header_rec.fob_point_code)
255: AND (p_old_header_rec.header_id IS NOT NULL OR
256: p_initial_header_rec.fob_point_code IS NOT NULL))
257: ) -- AND condition added to fix 3098878
258: THEN
262:
263: PROCEDURE FREIGHT_TERMS IS
264: BEGIN
265: IF (p_initial_header_rec.freight_terms_code = FND_API.G_MISS_CHAR
266: OR (OE_GLOBALS.Equal(p_initial_header_rec.freight_terms_code, p_old_header_rec.freight_terms_code)
267: AND (p_old_header_rec.header_id IS NOT NULL OR
268: p_initial_header_rec.freight_terms_code IS NOT NULL))
269: ) -- AND condition added to fix 3098878
270: THEN
274:
275: PROCEDURE FULFILLMENT_SET_NAME IS
276: BEGIN
277: IF (p_initial_header_rec.Fulfillment_Set_name = FND_API.G_MISS_CHAR
278: OR (OE_GLOBALS.Equal(p_initial_header_rec.Fulfillment_Set_name, p_old_header_rec.Fulfillment_Set_name)
279: AND (p_old_header_rec.header_id IS NOT NULL OR
280: p_initial_header_rec.Fulfillment_Set_name IS NOT NULL))
281: ) -- AND condition added to fix 3098878
282: THEN
286:
287: PROCEDURE INVOICE_TO_CONTACT IS
288: BEGIN
289: IF (p_initial_header_rec.invoice_to_contact_id = FND_API.G_MISS_NUM
290: OR (OE_GLOBALS.Equal(p_initial_header_rec.invoice_to_contact_id, p_old_header_rec.invoice_to_contact_id)
291: AND (p_old_header_rec.header_id IS NOT NULL OR
292: p_initial_header_rec.invoice_to_contact_id IS NOT NULL))
293: ) -- AND condition added to fix 3098878
294: THEN
298:
299: PROCEDURE INVOICE_TO_ORG IS
300: BEGIN
301: IF (p_initial_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM
302: OR (OE_GLOBALS.Equal(p_initial_header_rec.invoice_to_org_id, p_old_header_rec.invoice_to_org_id)
303: AND (p_old_header_rec.header_id IS NOT NULL OR
304: p_initial_header_rec.invoice_to_org_id IS NOT NULL))
305: ) -- AND condition added to fix 3098878
306: THEN
310:
311: PROCEDURE INVOICING_RULE IS
312: BEGIN
313: IF (p_initial_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM
314: OR (OE_GLOBALS.Equal(p_initial_header_rec.invoicing_rule_id, p_old_header_rec.invoicing_rule_id)
315: AND (p_old_header_rec.header_id IS NOT NULL OR
316: p_initial_header_rec.invoicing_rule_id IS NOT NULL))
317: ) -- AND condition added to fix 3098878
318: THEN
322:
323: PROCEDURE LINE_SET_NAME IS
324: BEGIN
325: IF (p_initial_header_rec.Line_Set_name = FND_API.G_MISS_CHAR
326: OR (OE_GLOBALS.Equal(p_initial_header_rec.Line_Set_name, p_old_header_rec.Line_Set_name)
327: AND (p_old_header_rec.header_id IS NOT NULL OR
328: p_initial_header_rec.Line_Set_name IS NOT NULL))
329: ) -- AND condition added to fix 3098878
330: THEN
334:
335: PROCEDURE ORDER_CATEGORY IS
336: BEGIN
337: IF (p_initial_header_rec.order_category_code = FND_API.G_MISS_CHAR
338: OR (OE_GLOBALS.Equal(p_initial_header_rec.order_category_code, p_old_header_rec.order_category_code)
339: AND (p_old_header_rec.header_id IS NOT NULL OR
340: p_initial_header_rec.order_category_code IS NOT NULL))
341: ) -- AND condition added to fix 3098878
342: THEN
347: PROCEDURE ORDER_DATE_TYPE IS
348: BEGIN
349:
350: IF (p_initial_header_rec.order_date_type_code = FND_API.G_MISS_CHAR
351: OR (OE_GLOBALS.Equal(p_initial_header_rec.order_date_type_code, p_old_header_rec.order_date_type_code)
352: AND (p_old_header_rec.header_id IS NOT NULL OR
353: p_initial_header_rec.order_date_type_code IS NOT NULL))
354: ) -- AND condition added to fix 3098878
355: THEN
359:
360: PROCEDURE ORDER_TYPE IS
361: BEGIN
362: IF (p_initial_header_rec.order_type_id = FND_API.G_MISS_NUM
363: OR (OE_GLOBALS.Equal(p_initial_header_rec.order_type_id, p_old_header_rec.order_type_id)
364: AND (p_old_header_rec.header_id IS NOT NULL OR
365: p_initial_header_rec.order_type_id IS NOT NULL))
366: ) -- AND condition added to fix 3098878
367: THEN
372: --Bug 4360599 Added this method to clear the payment Amount
373: PROCEDURE PAYMENT_AMOUNT IS
374: BEGIN
375: IF (p_initial_header_rec.PAYMENT_AMOUNT = FND_API.G_MISS_NUM
376: OR (OE_GLOBALS.Equal(p_initial_header_rec.PAYMENT_AMOUNT, p_old_header_rec.PAYMENT_AMOUNT)
377: AND (p_old_header_rec.header_id IS NOT NULL OR
378: p_initial_header_rec.PAYMENT_AMOUNT IS NOT NULL))
379: ) -- AND condition added to fix 3098878
380: THEN
384:
385: PROCEDURE PAYMENT_TERM IS
386: BEGIN
387: IF (p_initial_header_rec.payment_term_id = FND_API.G_MISS_NUM
388: OR (OE_GLOBALS.Equal(p_initial_header_rec.payment_term_id, p_old_header_rec.payment_term_id)
389: AND (p_old_header_rec.header_id IS NOT NULL OR
390: p_initial_header_rec.payment_term_id IS NOT NULL))
391: ) -- AND condition added to fix 3098878
392: THEN
396:
397: PROCEDURE PRICE_LIST IS
398: BEGIN
399: IF (p_initial_header_rec.price_list_id = FND_API.G_MISS_NUM
400: OR (OE_GLOBALS.Equal(p_initial_header_rec.price_list_id, p_old_header_rec.price_list_id)
401: AND (p_old_header_rec.header_id IS NOT NULL OR
402: p_initial_header_rec.price_list_id IS NOT NULL))
403: ) -- AND condition added to fix 3098878
404: THEN
408:
409: PROCEDURE PRICE_REQUEST_CODE IS -- PROMOTIONS SEP/01 BEGIN
410: BEGIN
411: IF (p_initial_header_rec.price_request_code = FND_API.G_MISS_CHAR
412: OR (OE_GLOBALS.Equal(p_initial_header_rec.price_request_code, p_old_header_rec.price_request_code)
413: AND (p_old_header_rec.header_id IS NOT NULL OR
414: p_initial_header_rec.price_request_code IS NOT NULL))
415: ) -- AND condition added to fix 3098878
416: THEN
420:
421: PROCEDURE REQUEST_DATE IS
422: BEGIN
423: IF (p_initial_header_rec.request_date = FND_API.G_MISS_DATE
424: OR (OE_GLOBALS.Equal(p_initial_header_rec.request_date, p_old_header_rec.request_date)
425: AND (p_old_header_rec.header_id IS NOT NULL OR
426: p_initial_header_rec.request_date IS NOT NULL))
427: ) -- AND condition added to fix 3098878
428: THEN
432:
433: PROCEDURE SALESREP IS
434: BEGIN
435: IF (p_initial_header_rec.salesrep_id = FND_API.G_MISS_NUM
436: OR (OE_GLOBALS.Equal(p_initial_header_rec.salesrep_id, p_old_header_rec.salesrep_id)
437: AND (p_old_header_rec.header_id IS NOT NULL OR
438: p_initial_header_rec.salesrep_id IS NOT NULL))
439: ) -- AND condition added to fix 3098878
440: THEN
444:
445: PROCEDURE SALES_CHANNEL IS
446: BEGIN
447: IF (p_initial_header_rec.sales_channel_code = FND_API.G_MISS_CHAR
448: OR (OE_GLOBALS.Equal(p_initial_header_rec.sales_channel_code, p_old_header_rec.sales_channel_code)
449: AND (p_old_header_rec.header_id IS NOT NULL OR
450: p_initial_header_rec.sales_channel_code IS NOT NULL))
451: ) -- AND condition added to fix 3098878
452: THEN
456:
457: PROCEDURE SHIPMENT_PRIORITY IS
458: BEGIN
459: IF (p_initial_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR
460: OR (OE_GLOBALS.Equal(p_initial_header_rec.shipment_priority_code, p_old_header_rec.shipment_priority_code)
461: AND (p_old_header_rec.header_id IS NOT NULL OR
462: p_initial_header_rec.shipment_priority_code IS NOT NULL))
463: ) -- AND condition added to fix 3098878
464: THEN
468:
469: PROCEDURE SHIPPING_METHOD IS
470: BEGIN
471: IF (p_initial_header_rec.shipping_method_code = FND_API.G_MISS_CHAR
472: OR (OE_GLOBALS.Equal(p_initial_header_rec.shipping_method_code, p_old_header_rec.shipping_method_code)
473: AND (p_old_header_rec.header_id IS NOT NULL OR
474: p_initial_header_rec.shipping_method_code IS NOT NULL))
475: ) -- AND condition added to fix 3098878
476: THEN
480:
481: PROCEDURE SHIP_FROM_ORG IS
482: BEGIN
483: IF (p_initial_header_rec.ship_from_org_id = FND_API.G_MISS_NUM
484: OR (OE_GLOBALS.Equal(p_initial_header_rec.ship_from_org_id, p_old_header_rec.ship_from_org_id)
485: AND (p_old_header_rec.header_id IS NOT NULL OR
486: p_initial_header_rec.ship_from_org_id IS NOT NULL))
487: ) -- AND condition added to fix 3098878
488: THEN
492:
493: PROCEDURE SHIP_TOLERANCE_ABOVE IS
494: BEGIN
495: IF (p_initial_header_rec.ship_tolerance_above = FND_API.G_MISS_NUM
496: OR (OE_GLOBALS.Equal(p_initial_header_rec.ship_tolerance_above, p_old_header_rec.ship_tolerance_above)
497: AND (p_old_header_rec.header_id IS NOT NULL OR
498: p_initial_header_rec.ship_tolerance_above IS NOT NULL))
499: ) -- AND condition added to fix 3098878
500: THEN
504:
505: PROCEDURE SHIP_TOLERANCE_BELOW IS
506: BEGIN
507: IF (p_initial_header_rec.ship_tolerance_below = FND_API.G_MISS_NUM
508: OR (OE_GLOBALS.Equal(p_initial_header_rec.ship_tolerance_below, p_old_header_rec.ship_tolerance_below)
509: AND (p_old_header_rec.header_id IS NOT NULL OR
510: p_initial_header_rec.ship_tolerance_below IS NOT NULL))
511: ) -- AND condition added to fix 3098878
512: THEN
516:
517: PROCEDURE SHIP_TO_CONTACT IS
518: BEGIN
519: IF (p_initial_header_rec.ship_to_contact_id = FND_API.G_MISS_NUM
520: OR (OE_GLOBALS.Equal(p_initial_header_rec.ship_to_contact_id, p_old_header_rec.ship_to_contact_id)
521: AND (p_old_header_rec.header_id IS NOT NULL OR
522: p_initial_header_rec.ship_to_contact_id IS NOT NULL))
523: ) -- AND condition added to fix 3098878
524: THEN
528:
529: PROCEDURE SHIP_TO_ORG IS
530: BEGIN
531: IF (p_initial_header_rec.ship_to_org_id = FND_API.G_MISS_NUM
532: OR (OE_GLOBALS.Equal(p_initial_header_rec.ship_to_org_id, p_old_header_rec.ship_to_org_id)
533: AND (p_old_header_rec.header_id IS NOT NULL OR
534: p_initial_header_rec.ship_to_org_id IS NOT NULL))
535: ) -- AND condition added to fix 3098878
536: THEN
541: -- Fix bug 1753101: sold to contact dependency code added
542: PROCEDURE SOLD_TO_CONTACT IS
543: BEGIN
544: IF (p_initial_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM
545: OR (OE_GLOBALS.Equal(p_initial_header_rec.sold_to_contact_id, p_old_header_rec.sold_to_contact_id)
546: AND (p_old_header_rec.header_id IS NOT NULL OR
547: p_initial_header_rec.sold_to_contact_id IS NOT NULL))
548: ) -- AND condition added to fix 3098878
549: THEN
553:
554: PROCEDURE SOLD_TO_ORG IS
555: BEGIN
556: IF (p_initial_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
557: OR (OE_GLOBALS.Equal(p_initial_header_rec.sold_to_org_id, p_old_header_rec.sold_to_org_id)
558: AND (p_old_header_rec.header_id IS NOT NULL OR
559: p_initial_header_rec.sold_to_org_id IS NOT NULL))
560: ) -- AND condition added to fix 3098878
561: THEN
565:
566: PROCEDURE SOLD_TO_PHONE IS
567: BEGIN
568: IF (p_initial_header_rec.sold_to_phone_id = FND_API.G_MISS_NUM
569: OR (OE_GLOBALS.Equal(p_initial_header_rec.sold_to_phone_id, p_old_header_rec.sold_to_phone_id)
570: AND (p_old_header_rec.header_id IS NOT NULL OR
571: p_initial_header_rec.sold_to_phone_id IS NOT NULL))
572: ) -- AND condition added to fix 3098878
573: THEN
577: --Start of bug# 14589391
578: PROCEDURE TAX_EXEMPT IS
579: BEGIN
580: IF (p_initial_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR
581: OR (OE_GLOBALS.Equal(p_initial_header_rec.tax_exempt_flag, p_old_header_rec.tax_exempt_flag)
582: AND (p_old_header_rec.header_id IS NOT NULL OR
583: p_initial_header_rec.tax_exempt_flag IS NOT NULL))
584: )
585: THEN
589:
590: PROCEDURE TAX_EXEMPT_NUMBER IS
591: BEGIN
592: IF (p_initial_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR
593: OR (OE_GLOBALS.Equal(p_initial_header_rec.tax_exempt_number, p_old_header_rec.tax_exempt_number)
594: AND (p_old_header_rec.header_id IS NOT NULL OR
595: p_initial_header_rec.tax_exempt_number IS NOT NULL))
596: ) -- AND condition added to fix 3098878
597: THEN
601:
602: PROCEDURE TAX_EXEMPT_REASON IS
603: BEGIN
604: IF (p_initial_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR
605: OR (OE_GLOBALS.Equal(p_initial_header_rec.tax_exempt_reason_code, p_old_header_rec.tax_exempt_reason_code)
606: AND (p_old_header_rec.header_id IS NOT NULL OR
607: p_initial_header_rec.tax_exempt_reason_code IS NOT NULL))
608: ) -- AND condition added to fix 3098878
609: THEN
607: p_initial_header_rec.tax_exempt_reason_code IS NOT NULL))
608: ) -- AND condition added to fix 3098878
609: THEN
610: -- If condition for bug #2892094
611: IF OE_GLOBALS.G_UI_FLAG THEN
612: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
613: END IF;
614: END IF;
615: END TAX_EXEMPT_REASON;
616:
617: PROCEDURE TRANSACTIONAL_CURR IS
618: BEGIN
619: IF (p_initial_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR
620: OR (OE_GLOBALS.Equal(p_initial_header_rec.transactional_curr_code, p_old_header_rec.transactional_curr_code)
621: AND (p_old_header_rec.header_id IS NOT NULL OR
622: p_initial_header_rec.transactional_curr_code IS NOT NULL))
623: ) -- AND condition added to fix 3098878
624: THEN
628:
629: PROCEDURE LATEST_SCHEDULE_LIMIT IS
630: BEGIN
631: IF (p_initial_header_rec.latest_schedule_limit = FND_API.G_MISS_NUM
632: OR (OE_GLOBALS.Equal(p_initial_header_rec.latest_schedule_limit, p_old_header_rec.latest_schedule_limit)
633: AND (p_old_header_rec.header_id IS NOT NULL OR
634: p_initial_header_rec.latest_schedule_limit IS NOT NULL))
635: ) -- AND condition added to fix 3098878
636: THEN
640:
641: PROCEDURE PACKING_INSTRUCTIONS IS -- added for 2665264
642: BEGIN
643: IF (p_initial_header_rec.packing_instructions = FND_API.G_MISS_CHAR
644: OR (OE_GLOBALS.Equal(p_initial_header_rec.packing_instructions, p_old_header_rec.packing_instructions)
645: AND (p_old_header_rec.header_id IS NOT NULL OR
646: p_initial_header_rec.packing_instructions IS NOT NULL))
647: ) -- AND condition added to fix 3098878
648: THEN
652:
653: PROCEDURE SHIPPING_INSTRUCTIONS IS -- added for 2766005
654: BEGIN
655: IF (p_initial_header_rec.shipping_instructions = FND_API.G_MISS_CHAR
656: OR (OE_GLOBALS.Equal(p_initial_header_rec.shipping_instructions, p_old_header_rec.shipping_instructions)
657: AND (p_old_header_rec.header_id IS NOT NULL OR
658: p_initial_header_rec.shipping_instructions IS NOT NULL))
659: ) -- AND condition added to fix 3098878
660: THEN
666:
667: PROCEDURE TRANSACTION_PHASE IS
668: BEGIN
669: -- Transaction phase can only be cleared during CREATE operation
670: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
671: AND (p_initial_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR
672: OR (OE_GLOBALS.Equal(p_initial_header_rec.transaction_phase_code, p_old_header_rec.transaction_phase_code)
673: AND (p_old_header_rec.header_id IS NOT NULL OR
674: p_initial_header_rec.transaction_phase_code IS NOT NULL))
668: BEGIN
669: -- Transaction phase can only be cleared during CREATE operation
670: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
671: AND (p_initial_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR
672: OR (OE_GLOBALS.Equal(p_initial_header_rec.transaction_phase_code, p_old_header_rec.transaction_phase_code)
673: AND (p_old_header_rec.header_id IS NOT NULL OR
674: p_initial_header_rec.transaction_phase_code IS NOT NULL))
675: ) -- 2nd AND condition added to fix 3098878
676: THEN
680:
681: PROCEDURE SOLD_TO_SITE_USE IS
682: BEGIN
683: IF (p_initial_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM
684: OR (OE_GLOBALS.Equal(p_initial_header_rec.sold_to_site_use_id, p_old_header_rec.sold_to_site_use_id)
685: AND (p_old_header_rec.header_id IS NOT NULL OR
686: p_initial_header_rec.sold_to_site_use_id IS NOT NULL))
687: ) -- AND condition added to fix 3098878
688: THEN
692:
693: PROCEDURE QUOTE_DATE IS
694: BEGIN
695: IF (p_initial_header_rec.quote_date = FND_API.G_MISS_DATE
696: OR (OE_GLOBALS.Equal(p_initial_header_rec.quote_date, p_old_header_rec.quote_date)
697: AND (p_old_header_rec.header_id IS NOT NULL OR
698: p_initial_header_rec.quote_date IS NOT NULL))
699: ) -- AND condition added to fix 3098878
700: AND OE_Quote_Util.G_COMPLETE_NEG = 'N'
707:
708: PROCEDURE ORDERED_DATE IS
709: BEGIN
710: IF (p_initial_header_rec.ordered_date = FND_API.G_MISS_DATE
711: OR (OE_GLOBALS.Equal(p_initial_header_rec.ordered_date, p_old_header_rec.ordered_date)
712: AND (p_old_header_rec.header_id IS NOT NULL OR
713: p_initial_header_rec.ordered_date IS NOT NULL))
714: -- bug 3854887
715: AND (p_x_header_rec.transaction_phase_code IS NULL OR
726: --distributed orders
727: PROCEDURE end_customer IS
728: BEGIN
729: IF (p_initial_header_rec.end_customer_id = FND_API.G_MISS_NUM
730: OR OE_GLOBALS.Equal(p_initial_header_rec.end_customer_id
731: , p_old_header_rec.end_customer_id ))
732: THEN
733: p_x_header_rec.end_customer_id := FND_API.G_MISS_NUM;
734: END IF;
736:
737: PROCEDURE end_customer_contact IS
738: BEGIN
739: IF (p_initial_header_rec.end_customer_contact_id = FND_API.G_MISS_NUM
740: OR OE_GLOBALS.Equal(p_initial_header_rec.end_customer_contact_id
741: , p_old_header_rec.end_customer_contact_id ))
742: THEN
743: p_x_header_rec.end_customer_contact_id := FND_API.G_MISS_NUM;
744: END IF;
746:
747: PROCEDURE end_customer_site_use IS
748: BEGIN
749: IF (p_initial_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM
750: OR OE_GLOBALS.Equal(p_initial_header_rec.end_customer_site_use_id ,
751: p_old_header_rec.end_customer_site_use_id ))
752: THEN
753: p_x_header_rec.end_customer_site_use_id := FND_API.G_MISS_NUM;
754: END IF;
758: PROCEDURE order_firmed_date IS
759: BEGIN
760: IF (p_initial_header_rec.order_firmed_date = FND_API.G_MISS_DATE
761: OR
762: (OE_GLOBALS.equal(p_initial_header_rec.order_firmed_date ,p_old_header_rec.order_firmed_date)
763: AND (p_initial_header_rec.order_firmed_date IS NOT NULL OR p_old_header_rec.order_firmed_date IS NOT NULL))
764: ) THEN
765: p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
766: END IF ;
769: -----START bug 8517526
770: PROCEDURE BLANKET_NUMBER IS
771: BEGIN
772: IF (p_initial_header_rec.blanket_number = FND_API.G_MISS_NUM OR
773: (OE_GLOBAlS.Equal(p_initial_header_rec.blanket_number, p_old_header_rec.blanket_number)
774: AND
775: (p_old_header_rec.header_id IS NOT NULL OR p_initial_header_rec.blanket_number IS NOT NULL))
776: )
777: THEN
788: oe_debug_pub.add('Entering OE_HEADER_UTIL.Clear_Dependent',1);
789: IF p_src_attr_tbl.COUNT <> 0 THEN
790:
791: OE_Dependencies.Mark_Dependent
792: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
793: p_source_attr_tbl => p_src_attr_tbl,
794: p_dep_attr_tbl => l_dep_attr_tbl);
795:
796: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1543: , p_old_instrument_id IN NUMBER DEFAULT NULL
1544: )
1545: IS
1546: l_index NUMBER :=0;
1547: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
1548: BEGIN
1549:
1550: oe_debug_pub.add('Entering OE_HEADER_UTIL.CLEAR_DEPENDENT_ATTR', 1);
1551:
1558: -- every changed attribute clear its dependent fields.
1559:
1560: ELSE
1561:
1562: IF NOT OE_GLOBALS.Equal(p_x_header_rec.agreement_id,p_old_header_rec.agreement_id)
1563: THEN
1564: l_index := l_index + 1.0;
1565: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_AGREEMENT;
1566: END IF;
1564: l_index := l_index + 1.0;
1565: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_AGREEMENT;
1566: END IF;
1567:
1568: IF NOT OE_GLOBALS.Equal(p_x_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id)
1569: THEN
1570: l_index := l_index + 1.0;
1571: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
1572: END IF;
1570: l_index := l_index + 1.0;
1571: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
1572: END IF;
1573:
1574: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_contact_id,p_old_header_rec.invoice_to_contact_id)
1575: THEN
1576: l_index := l_index + 1.0;
1577: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
1578: END IF;
1576: l_index := l_index + 1.0;
1577: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
1578: END IF;
1579:
1580: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1581: THEN
1582: l_index := l_index + 1.0;
1583: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
1584: END IF;
1582: l_index := l_index + 1.0;
1583: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
1584: END IF;
1585:
1586: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ordered_date,p_old_header_rec.ordered_date)
1587: THEN
1588: l_index := l_index + 1.0;
1589: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDERED_DATE;
1590: END IF;
1588: l_index := l_index + 1.0;
1589: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDERED_DATE;
1590: END IF;
1591:
1592: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
1593: THEN
1594: l_index := l_index + 1.0;
1595: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDER_TYPE;
1596: END IF;
1594: l_index := l_index + 1.0;
1595: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_ORDER_TYPE;
1596: END IF;
1597:
1598: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
1599: THEN
1600: l_index := l_index + 1.0;
1601: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PAYMENT_TYPE;
1602: END IF;
1601: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PAYMENT_TYPE;
1602: END IF;
1603:
1604: /* Fix Bug # 2297053: Clear attributes dependent on Credit Card Number */
1605: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_x_header_rec.credit_card_number,
1606: p_old_instrument_id,p_x_instrument_id)
1607: THEN
1608: l_index := l_index + 1.0;
1609: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
1608: l_index := l_index + 1.0;
1609: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
1610: END IF;
1611:
1612: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
1613: THEN
1614: l_index := l_index + 1.0;
1615: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PRICE_LIST;
1616: END IF;
1614: l_index := l_index + 1.0;
1615: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_PRICE_LIST;
1616: END IF;
1617:
1618: IF NOT OE_GLOBALS.Equal(p_x_header_rec.request_date,p_old_header_rec.request_date)
1619: THEN
1620: l_index := l_index + 1.0;
1621: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_REQUEST_DATE;
1622: END IF;
1620: l_index := l_index + 1.0;
1621: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_REQUEST_DATE;
1622: END IF;
1623:
1624: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id)
1625: THEN
1626: l_index := l_index + 1.0;
1627: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
1628: END IF;
1626: l_index := l_index + 1.0;
1627: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
1628: END IF;
1629:
1630: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_contact_id,p_old_header_rec.ship_to_contact_id)
1631: THEN
1632: l_index := l_index + 1.0;
1633: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
1634: END IF;
1632: l_index := l_index + 1.0;
1633: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
1634: END IF;
1635:
1636: IF NOT OE_GLOBALS.Equal(p_x_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id)
1637: THEN
1638: l_index := l_index + 1.0;
1639: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_ORG;
1640: END IF;
1638: l_index := l_index + 1.0;
1639: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SHIP_TO_ORG;
1640: END IF;
1641:
1642: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
1643: THEN
1644: l_index := l_index + 1.0;
1645: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_ORG;
1646: END IF;
1644: l_index := l_index + 1.0;
1645: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_ORG;
1646: END IF;
1647:
1648: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_phone_id,p_old_header_rec.sold_to_phone_id)
1649: THEN
1650: l_index := l_index + 1.0;
1651: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
1652: END IF;
1650: l_index := l_index + 1.0;
1651: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
1652: END IF;
1653:
1654: IF NOT OE_GLOBALS.Equal(p_x_header_rec.tax_exempt_flag,p_old_header_rec.tax_exempt_flag)
1655: THEN
1656: l_index := l_index + 1.0;
1657: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TAX_EXEMPT;
1658: END IF;
1656: l_index := l_index + 1.0;
1657: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TAX_EXEMPT;
1658: END IF;
1659:
1660: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
1661: THEN
1662: l_index := l_index + 1.0;
1663: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
1664: END IF;
1662: l_index := l_index + 1.0;
1663: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
1664: END IF;
1665:
1666: IF NOT OE_GLOBALS.Equal(p_x_header_rec.blanket_number,p_old_header_rec.blanket_number)
1667: THEN
1668: l_index := l_index + 1.0;
1669: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_BLANKET_NUMBER;
1670: END IF;
1669: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_BLANKET_NUMBER;
1670: END IF;
1671:
1672: -- QUOTING changes
1673: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code)
1674: THEN
1675: l_index := l_index + 1.0;
1676: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
1677: END IF;
1677: END IF;
1678: -- QUOTING changes END
1679:
1680: --distributed order @
1681: IF NOT OE_GLOBALS.Equal(p_x_header_rec.end_customer_id,p_old_header_rec.end_customer_id)
1682: THEN
1683: l_index := l_index + 1.0;
1684: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_END_CUSTOMER;
1685: END IF;
1684: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_END_CUSTOMER;
1685: END IF;
1686:
1687: -- bug 5127922
1688: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_site_use_id,p_old_header_rec.sold_to_site_use_id)
1689: THEN
1690: l_index := l_index + 1.0;
1691: l_src_attr_tbl(l_index) := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
1692: END IF;
1805: oe_debug_pub.add('Entering OE_HEADER_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
1806:
1807: -- Load out record
1808:
1809: IF NOT OE_GLOBALS.Equal(p_x_header_rec.booked_flag,p_old_header_rec.booked_flag)
1810: THEN
1811: IF p_x_header_rec.booked_flag = 'Y' THEN
1812: p_x_header_rec.flow_status_code := 'BOOKED';
1813: END IF;
1812: p_x_header_rec.flow_status_code := 'BOOKED';
1813: END IF;
1814: END IF;
1815:
1816: IF NOT OE_GLOBALS.Equal(p_x_header_rec.cancelled_flag,p_old_header_rec.cancelled_flag)
1817: THEN
1818: IF p_x_header_rec.cancelled_flag = 'Y' THEN
1819:
1820: Oe_Sales_Can_Util.Check_Constraints(p_x_header_rec,
1840: oe_debug_pub.add('payment type--'||nvl(p_x_header_rec.payment_type_code,'xxx'));
1841: oe_debug_pub.add('Old inv to ...'||p_x_header_rec.invoice_to_org_id);
1842: oe_debug_pub.add('New inv to...'||p_old_header_rec.invoice_to_org_id);
1843:
1844: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1845: THEN
1846: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1847: --R12 CC Encryption
1848: --Delayed request for deleting the payments when
1842: oe_debug_pub.add('New inv to...'||p_old_header_rec.invoice_to_org_id);
1843:
1844: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
1845: THEN
1846: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1847: --R12 CC Encryption
1848: --Delayed request for deleting the payments when
1849: --invoice to changes
1850: IF p_x_header_rec.payment_type_code in ('ACH','DIRECT_DEBIT','CREDIT_CARD') OR
1860: oe_debug_pub.add('Delete Payment Count count'||l_delete_payment_count);
1861: oe_debug_pub.add('Log delete payment req Flag'||l_log_delete_payment_req);
1862: IF l_log_delete_payment_req = 'Y' THEN
1863: OE_delayed_requests_Pvt.log_request
1864: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1865: p_entity_id => p_x_Header_rec.header_id,
1866: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1867: p_requesting_entity_id => p_x_Header_rec.header_id,
1868: p_request_type => OE_GLOBALS.G_DELETE_PAYMENTS,
1862: IF l_log_delete_payment_req = 'Y' THEN
1863: OE_delayed_requests_Pvt.log_request
1864: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1865: p_entity_id => p_x_Header_rec.header_id,
1866: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1867: p_requesting_entity_id => p_x_Header_rec.header_id,
1868: p_request_type => OE_GLOBALS.G_DELETE_PAYMENTS,
1869: p_param1 => to_char(p_old_header_rec.invoice_to_org_id),
1870: x_return_status => l_return_status);
1864: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1865: p_entity_id => p_x_Header_rec.header_id,
1866: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1867: p_requesting_entity_id => p_x_Header_rec.header_id,
1868: p_request_type => OE_GLOBALS.G_DELETE_PAYMENTS,
1869: p_param1 => to_char(p_old_header_rec.invoice_to_org_id),
1870: x_return_status => l_return_status);
1871:
1872: END IF;--Log delayed req.
1912: oe_debug_pub.add('p_x_header_rec.open_flag:'||p_x_header_rec.open_flag);
1913: oe_debug_pub.add('p_old_header_rec.open_flag:'||p_old_header_rec.open_flag);
1914:
1915:
1916: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.open_flag,
1917: p_old_header_rec.open_flag)) OR
1918: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
1919: p_x_header_rec.open_flag IS NOT NULL)
1920: --OR cnd for bug 5060064
1914:
1915:
1916: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.open_flag,
1917: p_old_header_rec.open_flag)) OR
1918: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
1919: p_x_header_rec.open_flag IS NOT NULL)
1920: --OR cnd for bug 5060064
1921: THEN
1922: IF p_x_header_rec.open_flag = 'N' THEN
1928: END IF;
1929:
1930: END IF;
1931:
1932: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
1933: THEN
1934:
1935: -- If the Order Type has changed, we need to sync up the
1936: -- MTL_SALES_ORDERS table.
1933: THEN
1934:
1935: -- If the Order Type has changed, we need to sync up the
1936: -- MTL_SALES_ORDERS table.
1937: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1938:
1939:
1940: IF p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
1941:
1960: END IF;
1961: END IF;
1962: END IF;
1963:
1964: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.salesrep_id,
1965: p_old_header_rec.salesrep_id)) OR
1966: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
1967: p_x_header_rec.salesrep_id IS NOT NULL )
1968: --OR condition added for bug 5060064
1962: END IF;
1963:
1964: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.salesrep_id,
1965: p_old_header_rec.salesrep_id)) OR
1966: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
1967: p_x_header_rec.salesrep_id IS NOT NULL )
1968: --OR condition added for bug 5060064
1969: THEN
1970:
1968: --OR condition added for bug 5060064
1969: THEN
1970:
1971: IF NOT (nvl(p_x_header_rec.source_document_type_id,-99) = 2 AND
1972: p_x_header_rec.operation = oe_globals.g_opr_create)THEN
1973: IF p_x_header_rec.salesrep_id IS NOT NULL THEN
1974: IF OE_Validate_Header_Scredit.G_Create_Auto_Sales_Credit = 'Y' THEN
1975: OE_delayed_requests_Pvt.log_request
1976: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1972: p_x_header_rec.operation = oe_globals.g_opr_create)THEN
1973: IF p_x_header_rec.salesrep_id IS NOT NULL THEN
1974: IF OE_Validate_Header_Scredit.G_Create_Auto_Sales_Credit = 'Y' THEN
1975: OE_delayed_requests_Pvt.log_request
1976: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1977: p_entity_id => p_x_header_rec.header_id,
1978: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1979: p_requesting_entity_id => p_x_header_rec.header_id,
1980: p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
1974: IF OE_Validate_Header_Scredit.G_Create_Auto_Sales_Credit = 'Y' THEN
1975: OE_delayed_requests_Pvt.log_request
1976: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1977: p_entity_id => p_x_header_rec.header_id,
1978: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1979: p_requesting_entity_id => p_x_header_rec.header_id,
1980: p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
1981: p_param1 => p_x_header_rec.header_id,
1982: p_param2 => p_x_header_rec.salesrep_id,
1976: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1977: p_entity_id => p_x_header_rec.header_id,
1978: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1979: p_requesting_entity_id => p_x_header_rec.header_id,
1980: p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
1981: p_param1 => p_x_header_rec.header_id,
1982: p_param2 => p_x_header_rec.salesrep_id,
1983: x_return_status => l_return_status);
1984: END IF;
1987: ELSE
1988: IF OE_Validate_Header_Scredit.G_Create_Auto_Sales_Credit = 'Y' THEN
1989: OE_DELAYED_REQUESTS_PVT.Delete_Request
1990: (
1991: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1992: p_entity_id => p_x_header_rec.header_id,
1993: p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
1994: x_return_status => l_return_status
1995: );
1989: OE_DELAYED_REQUESTS_PVT.Delete_Request
1990: (
1991: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1992: p_entity_id => p_x_header_rec.header_id,
1993: p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
1994: x_return_status => l_return_status
1995: );
1996: END IF;
1997: /* End of bug 4139105 */
2003: NULL;
2004: END IF;
2005: oe_debug_pub.add('Raj3', 1);
2006:
2007: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
2008: THEN
2009: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2010: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2011:
2005: oe_debug_pub.add('Raj3', 1);
2006:
2007: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id)
2008: THEN
2009: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2010: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2011:
2012: -- Set Flag to Log a request for Verify Payment
2013: oe_debug_pub.add('Log Verify Payment Delayed Request in Sold To',3);
2014: --
2015: l_verify_payment_flag := 'Y';
2016: END IF;
2017:
2018: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2019: -- Log request to evaluate Holds.
2020: oe_debug_pub.ADD('Customer update: logging request for eval_hold_source',1);
2021: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2022: 'Entity ID:' || to_char(p_x_header_rec.sold_to_org_id),1);
2020: oe_debug_pub.ADD('Customer update: logging request for eval_hold_source',1);
2021: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2022: 'Entity ID:' || to_char(p_x_header_rec.sold_to_org_id),1);
2023: OE_delayed_requests_Pvt.log_request
2024: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2025: p_entity_id => p_x_header_rec.header_id,
2026: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2027: p_requesting_entity_id => p_x_header_rec.header_id,
2028: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2022: 'Entity ID:' || to_char(p_x_header_rec.sold_to_org_id),1);
2023: OE_delayed_requests_Pvt.log_request
2024: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2025: p_entity_id => p_x_header_rec.header_id,
2026: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2027: p_requesting_entity_id => p_x_header_rec.header_id,
2028: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2029: p_request_unique_key1 => 'CUSTOMER',
2030: p_param1 => 'C',
2024: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2025: p_entity_id => p_x_header_rec.header_id,
2026: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2027: p_requesting_entity_id => p_x_header_rec.header_id,
2028: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2029: p_request_unique_key1 => 'CUSTOMER',
2030: p_param1 => 'C',
2031: p_param2 => p_x_header_rec.sold_to_org_id,
2032: x_return_status => l_return_status);
2037: END IF;
2038:
2039: -- ER#3667551 start
2040:
2041: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
2042: THEN
2043: -- only if system parameter is set to BTH then processing for BTH case needs to be done
2044: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND l_credithold_cust ='BTH' THEN
2045: -- Log request to evaluate Holds.
2040:
2041: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
2042: THEN
2043: -- only if system parameter is set to BTH then processing for BTH case needs to be done
2044: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND l_credithold_cust ='BTH' THEN
2045: -- Log request to evaluate Holds.
2046: oe_debug_pub.ADD('Bill to Customer update: logging request for eval_hold_source',1);
2047: l_bill_to_cust_id := OE_Bulk_Holds_PVT.CustAcctID_func
2048: (p_in_site_id => p_x_header_rec.invoice_to_org_id,
2052: 'Entity ID:' || to_char(l_bill_to_cust_id),1);
2053:
2054:
2055: OE_delayed_requests_Pvt.log_request
2056: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2057: p_entity_id => p_x_header_rec.header_id,
2058: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2059: p_requesting_entity_id => p_x_header_rec.header_id,
2060: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2054:
2055: OE_delayed_requests_Pvt.log_request
2056: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2057: p_entity_id => p_x_header_rec.header_id,
2058: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2059: p_requesting_entity_id => p_x_header_rec.header_id,
2060: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2061: p_request_unique_key1 => 'BILL_TO_CUSTOMER',
2062: p_param1 => 'BTH',
2056: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2057: p_entity_id => p_x_header_rec.header_id,
2058: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2059: p_requesting_entity_id => p_x_header_rec.header_id,
2060: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2061: p_request_unique_key1 => 'BILL_TO_CUSTOMER',
2062: p_param1 => 'BTH',
2063: p_param2 => l_bill_to_cust_id,
2064: x_return_status => l_return_status);
2068:
2069: END IF;
2070: -- ER#3667551 end
2071:
2072: IF NOT OE_GLOBALS.Equal(p_x_header_rec.tax_point_code,p_old_header_rec.tax_point_code)
2073: THEN
2074: NULL;
2075: END IF;
2076:
2073: THEN
2074: NULL;
2075: END IF;
2076:
2077: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
2078: THEN
2079: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2080: THEN
2081:
2075: END IF;
2076:
2077: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
2078: THEN
2079: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2080: THEN
2081:
2082: IF p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2083:
2098: END IF;
2099: END IF;
2100: END IF;
2101:
2102: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
2103: THEN
2104: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2105: --R12 CC Encryption
2106: --Credit card processing would
2100: END IF;
2101:
2102: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
2103: THEN
2104: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2105: --R12 CC Encryption
2106: --Credit card processing would
2107: --now be handled in pre_write_process procedure
2108: IF p_x_header_rec.payment_type_code IS NOT NULL
2116:
2117: --R12 CC Encryption
2118: END IF;
2119: END IF;
2120: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_amount,p_old_header_rec.payment_amount)
2121: THEN
2122: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2123: AND p_x_header_rec.payment_type_code in ('CASH', 'CHECK')
2124: THEN
2118: END IF;
2119: END IF;
2120: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_amount,p_old_header_rec.payment_amount)
2121: THEN
2122: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2123: AND p_x_header_rec.payment_type_code in ('CASH', 'CHECK')
2124: THEN
2125:
2126: -- Set Flag to Log a request for Verify Payment
2132:
2133: END IF;
2134: END IF;
2135:
2136: IF NOT OE_GLOBALS.Equal(p_x_header_rec.check_number,p_old_header_rec.check_number)
2137: THEN
2138: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2139: AND p_x_header_rec.payment_type_code = 'CHECK'
2140: THEN
2134: END IF;
2135:
2136: IF NOT OE_GLOBALS.Equal(p_x_header_rec.check_number,p_old_header_rec.check_number)
2137: THEN
2138: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2139: AND p_x_header_rec.payment_type_code = 'CHECK'
2140: THEN
2141:
2142: -- Set Flag to Log a request for Verify Payment
2149: END IF;
2150: END IF;
2151:
2152:
2153: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_holder_name,p_old_header_rec.credit_card_holder_name)
2154: THEN
2155: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2156: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2157:
2151:
2152:
2153: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_holder_name,p_old_header_rec.credit_card_holder_name)
2154: THEN
2155: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2156: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2157:
2158: -- Set Flag to Log a request for Verify Payment
2159: oe_debug_pub.add('Log Verify Payment Delayed Request in CC Holder',3);
2167:
2168: END IF;
2169: END IF;
2170:
2171: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,
2172: p_x_header_rec.credit_card_number,
2173: p_old_header_rec.cc_instrument_id,
2174: p_x_header_rec.cc_instrument_id)
2175: THEN
2172: p_x_header_rec.credit_card_number,
2173: p_old_header_rec.cc_instrument_id,
2174: p_x_header_rec.cc_instrument_id)
2175: THEN
2176: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2177: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2178:
2179: -- Set Flag to Log a request for Verify Payment
2180: oe_debug_pub.add('Log Verify Payment Delayed Request in CC Number',3);
2189: END IF;
2190: END IF;
2191: oe_debug_pub.add('Raj4', 1);
2192:
2193: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_expiration_date,p_old_header_rec.credit_card_expiration_date)
2194: THEN
2195: /* Fix Bug # 3686048(FP 3659342): Set the Exp Date as the Last Day of the Month */
2196: select last_day(p_x_header_rec.credit_card_expiration_date)
2197: into p_x_header_rec.credit_card_expiration_date from dual;
2195: /* Fix Bug # 3686048(FP 3659342): Set the Exp Date as the Last Day of the Month */
2196: select last_day(p_x_header_rec.credit_card_expiration_date)
2197: into p_x_header_rec.credit_card_expiration_date from dual;
2198:
2199: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2200: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2201:
2202: -- Set Flag to Log a request for Verify Payment
2203: oe_debug_pub.add('Log Verify Payment Delayed Request in CC Exp Date',3);
2211:
2212: END IF;
2213: END IF;
2214:
2215: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_approval_code,p_old_header_rec.credit_card_approval_code)
2216: THEN
2217: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2218: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2219:
2213: END IF;
2214:
2215: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_approval_code,p_old_header_rec.credit_card_approval_code)
2216: THEN
2217: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2218: AND p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2219:
2220: -- Set Flag to Log a request for Verify Payment
2221: oe_debug_pub.add('Log Verify Payment Delayed Request in CC Approval',3);
2232:
2233:
2234: /* Fix for 1559906: New Procedure to Copy Freight Charges */
2235:
2236: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.source_document_type_id,
2237: p_old_header_rec.source_document_type_id)) OR
2238: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2239: AND p_x_header_rec.source_document_type_id = 2)
2240: --OR condition added for bug 5060064
2234: /* Fix for 1559906: New Procedure to Copy Freight Charges */
2235:
2236: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.source_document_type_id,
2237: p_old_header_rec.source_document_type_id)) OR
2238: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2239: AND p_x_header_rec.source_document_type_id = 2)
2240: --OR condition added for bug 5060064
2241: THEN
2242: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2238: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2239: AND p_x_header_rec.source_document_type_id = 2)
2240: --OR condition added for bug 5060064
2241: THEN
2242: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2243: AND p_x_header_rec.source_document_type_id = 2 THEN
2244:
2245: -- Added IF condition for bug 6697401
2246: IF OE_ORDER_COPY_UTIL.G_COPY_REC.line_price_mode =
2251: -- Log a request to copy Freight Charges to the copied order.
2252: oe_debug_pub.add('Log Delayed Request To Copy Charges in SRC Doc Type Id',3);
2253:
2254: OE_delayed_requests_Pvt.log_request(
2255: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2256: p_entity_id => p_x_header_rec.header_id,
2257: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2258: p_requesting_entity_id => p_x_header_rec.header_id,
2259: p_param1 => p_x_header_rec.order_category_code,
2253:
2254: OE_delayed_requests_Pvt.log_request(
2255: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2256: p_entity_id => p_x_header_rec.header_id,
2257: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2258: p_requesting_entity_id => p_x_header_rec.header_id,
2259: p_param1 => p_x_header_rec.order_category_code,
2260: p_param2 => p_x_header_rec.source_document_id,
2261: p_request_type => OE_GLOBALS.G_COPY_FREIGHT_CHARGES,
2257: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2258: p_requesting_entity_id => p_x_header_rec.header_id,
2259: p_param1 => p_x_header_rec.order_category_code,
2260: p_param2 => p_x_header_rec.source_document_id,
2261: p_request_type => OE_GLOBALS.G_COPY_FREIGHT_CHARGES,
2262: x_return_status => l_return_status);
2263: END IF; -- bug 6697401
2264: END IF;
2265: END IF;
2264: END IF;
2265: END IF;
2266:
2267: /* Added the following code to fix the bug 2170086 */
2268: IF NOT OE_GLOBALS.Equal(p_x_header_rec.source_document_type_id,p_old_header_rec.source_document_type_id) OR
2269: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2270: AND p_x_header_rec.source_document_type_id = 2 )
2271: --OR condition added for bug 5060064
2272: THEN
2265: END IF;
2266:
2267: /* Added the following code to fix the bug 2170086 */
2268: IF NOT OE_GLOBALS.Equal(p_x_header_rec.source_document_type_id,p_old_header_rec.source_document_type_id) OR
2269: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2270: AND p_x_header_rec.source_document_type_id = 2 )
2271: --OR condition added for bug 5060064
2272: THEN
2273: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2269: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2270: AND p_x_header_rec.source_document_type_id = 2 )
2271: --OR condition added for bug 5060064
2272: THEN
2273: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2274: AND p_x_header_rec.source_document_type_id = 2 THEN
2275:
2276: -- Log a request to copy header adjustments to the copied order.
2277: oe_debug_pub.add('Log Delayed Request To Copy header adjustments ',3);
2279:
2280: IF OE_ORDER_COPY_UTIL.G_COPY_REC.line_price_mode IN (OE_ORDER_COPY_UTIL.G_CPY_ORIG_PRICE,OE_ORDER_COPY_UTIL.G_CPY_REPRICE_PARTIAL) THEN
2281: oe_debug_pub.add(' Copy as original price');
2282: OE_delayed_requests_Pvt.log_request(
2283: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2284: p_entity_id => p_x_header_rec.header_id,
2285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2286: p_requesting_entity_id => p_x_header_rec.header_id,
2287: p_param1 => p_x_header_rec.order_category_code,
2281: oe_debug_pub.add(' Copy as original price');
2282: OE_delayed_requests_Pvt.log_request(
2283: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2284: p_entity_id => p_x_header_rec.header_id,
2285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2286: p_requesting_entity_id => p_x_header_rec.header_id,
2287: p_param1 => p_x_header_rec.order_category_code,
2288: p_param2 => p_x_header_rec.source_document_id,
2289: p_request_type => OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS ,
2285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2286: p_requesting_entity_id => p_x_header_rec.header_id,
2287: p_param1 => p_x_header_rec.order_category_code,
2288: p_param2 => p_x_header_rec.source_document_id,
2289: p_request_type => OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS ,
2290: x_return_status => l_return_status);
2291: END IF;
2292: END IF;
2293: END IF;
2293: END IF;
2294:
2295: /* End of the code added to fix the bug 2170086 */
2296: -- Bug 2619506
2297: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)) OR
2298: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
2299: p_x_header_rec.transactional_curr_code IS NOT NULL)
2300: -- OR condition added for bug 5060064
2301: THEN
2294:
2295: /* End of the code added to fix the bug 2170086 */
2296: -- Bug 2619506
2297: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)) OR
2298: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
2299: p_x_header_rec.transactional_curr_code IS NOT NULL)
2300: -- OR condition added for bug 5060064
2301: THEN
2302: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2298: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
2299: p_x_header_rec.transactional_curr_code IS NOT NULL)
2300: -- OR condition added for bug 5060064
2301: THEN
2302: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2303: THEN
2304: If nvl(p_x_header_rec.booked_flag, 'N') <> 'Y' Then
2305: OE_delayed_requests_Pvt.log_request(
2306: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2302: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2303: THEN
2304: If nvl(p_x_header_rec.booked_flag, 'N') <> 'Y' Then
2305: OE_delayed_requests_Pvt.log_request(
2306: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2307: p_entity_id => p_x_header_rec.header_id,
2308: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2309: p_requesting_entity_id => p_x_header_rec.header_id,
2310: p_param1 => p_x_header_rec.header_id,
2304: If nvl(p_x_header_rec.booked_flag, 'N') <> 'Y' Then
2305: OE_delayed_requests_Pvt.log_request(
2306: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2307: p_entity_id => p_x_header_rec.header_id,
2308: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2309: p_requesting_entity_id => p_x_header_rec.header_id,
2310: p_param1 => p_x_header_rec.header_id,
2311: p_param2 => 'BATCH',
2312: p_request_unique_key1 => 'BATCH',
2310: p_param1 => p_x_header_rec.header_id,
2311: p_param2 => 'BATCH',
2312: p_request_unique_key1 => 'BATCH',
2313: p_param3 => 'PRICE_ORDER',
2314: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
2315: x_return_status => l_return_status);
2316: Else
2317: OE_delayed_requests_Pvt.log_request(
2318: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2314: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
2315: x_return_status => l_return_status);
2316: Else
2317: OE_delayed_requests_Pvt.log_request(
2318: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2319: p_entity_id => p_x_header_rec.header_id,
2320: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2321: p_requesting_entity_id => p_x_header_rec.header_id,
2322: p_param1 => p_x_header_rec.header_id,
2316: Else
2317: OE_delayed_requests_Pvt.log_request(
2318: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2319: p_entity_id => p_x_header_rec.header_id,
2320: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2321: p_requesting_entity_id => p_x_header_rec.header_id,
2322: p_param1 => p_x_header_rec.header_id,
2323: p_param2 => 'BATCH,BOOK',
2324: p_request_unique_key1 => 'BATCH,BOOK',
2322: p_param1 => p_x_header_rec.header_id,
2323: p_param2 => 'BATCH,BOOK',
2324: p_request_unique_key1 => 'BATCH,BOOK',
2325: p_param3 => 'PRICE_ORDER',
2326: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
2327: x_return_status => l_return_status);
2328: End If;
2329: -- sol_ord_er #16014165 start
2330: oe_delayed_requests_pvt.log_request(
2327: x_return_status => l_return_status);
2328: End If;
2329: -- sol_ord_er #16014165 start
2330: oe_delayed_requests_pvt.log_request(
2331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2332: p_entity_id => p_x_header_rec.Header_Id,
2333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2334: p_requesting_entity_id => p_x_header_rec.Header_Id,
2335: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
2329: -- sol_ord_er #16014165 start
2330: oe_delayed_requests_pvt.log_request(
2331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2332: p_entity_id => p_x_header_rec.Header_Id,
2333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2334: p_requesting_entity_id => p_x_header_rec.Header_Id,
2335: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
2336: p_request_unique_key1 => 'ORDER',
2337: p_param1 => p_x_header_rec.Header_Id,
2331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2332: p_entity_id => p_x_header_rec.Header_Id,
2333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2334: p_requesting_entity_id => p_x_header_rec.Header_Id,
2335: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
2336: p_request_unique_key1 => 'ORDER',
2337: p_param1 => p_x_header_rec.Header_Id,
2338: x_return_status => l_return_status);
2339: -- sol_ord_er #16014165 end
2345:
2346: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
2347: oe_debug_pub.add( 'before oe_delayed_requests_pvt.log_request call',5 ) ;
2348: oe_delayed_requests_pvt.log_request(
2349: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2350: p_entity_id => i.line_id,
2351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2352: p_requesting_entity_id => p_x_header_rec.header_id,
2353: p_request_type => 'GET_COST',
2347: oe_debug_pub.add( 'before oe_delayed_requests_pvt.log_request call',5 ) ;
2348: oe_delayed_requests_pvt.log_request(
2349: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2350: p_entity_id => i.line_id,
2351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2352: p_requesting_entity_id => p_x_header_rec.header_id,
2353: p_request_type => 'GET_COST',
2354: x_return_status => l_return_status);
2355: oe_debug_pub.add( 'After OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL '||l_return_status ,5) ;
2359: End If;
2360: End If;
2361:
2362: --ER#7479609 start
2363: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
2364: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2365: THEN
2366: OE_Holds_PUB.G_PAYMENT_HOLD_APPLIED := 'N';
2367: OE_Holds_PUB.G_HDR_PAYMENT := 'Y';
2360: End If;
2361:
2362: --ER#7479609 start
2363: IF NOT OE_GLOBALS.Equal(p_x_header_rec.payment_type_code,p_old_header_rec.payment_type_code)
2364: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2365: THEN
2366: OE_Holds_PUB.G_PAYMENT_HOLD_APPLIED := 'N';
2367: OE_Holds_PUB.G_HDR_PAYMENT := 'Y';
2368: oe_debug_pub.ADD('payment type update: logging request for eval_hold_source',1);
2368: oe_debug_pub.ADD('payment type update: logging request for eval_hold_source',1);
2369: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2370: 'Entity ID:' || to_char(p_x_header_rec.payment_type_code),1);
2371: OE_delayed_requests_Pvt.log_request
2372: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2373: p_entity_id => p_x_header_rec.header_id,
2374: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2375: p_requesting_entity_id => p_x_header_rec.header_id,
2376: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2370: 'Entity ID:' || to_char(p_x_header_rec.payment_type_code),1);
2371: OE_delayed_requests_Pvt.log_request
2372: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2373: p_entity_id => p_x_header_rec.header_id,
2374: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2375: p_requesting_entity_id => p_x_header_rec.header_id,
2376: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2377: p_request_unique_key1 => 'PAYMENT_TYPE',
2378: p_param1 => 'P',
2372: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2373: p_entity_id => p_x_header_rec.header_id,
2374: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2375: p_requesting_entity_id => p_x_header_rec.header_id,
2376: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2377: p_request_unique_key1 => 'PAYMENT_TYPE',
2378: p_param1 => 'P',
2379: p_param2 => p_x_header_rec.payment_type_code,
2380: x_return_status => l_return_status);
2381: oe_debug_pub.ADD('after call to log_request: l_return_status: '||l_return_status , 1);
2382:
2383: END IF;
2384:
2385: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
2386: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2387: THEN
2388: oe_debug_pub.ADD('Currency update: logging request for eval_hold_source',1);
2389: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2382:
2383: END IF;
2384:
2385: IF NOT OE_GLOBALS.Equal(p_x_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code)
2386: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2387: THEN
2388: oe_debug_pub.ADD('Currency update: logging request for eval_hold_source',1);
2389: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2390: 'Entity ID:' || to_char(p_x_header_rec.transactional_curr_code),1);
2388: oe_debug_pub.ADD('Currency update: logging request for eval_hold_source',1);
2389: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2390: 'Entity ID:' || to_char(p_x_header_rec.transactional_curr_code),1);
2391: OE_delayed_requests_Pvt.log_request
2392: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2393: p_entity_id => p_x_header_rec.header_id,
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2395: p_requesting_entity_id => p_x_header_rec.header_id,
2396: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2390: 'Entity ID:' || to_char(p_x_header_rec.transactional_curr_code),1);
2391: OE_delayed_requests_Pvt.log_request
2392: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2393: p_entity_id => p_x_header_rec.header_id,
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2395: p_requesting_entity_id => p_x_header_rec.header_id,
2396: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2397: p_request_unique_key1 => 'CURRENCY',
2398: p_param1 => 'TC',
2392: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2393: p_entity_id => p_x_header_rec.header_id,
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2395: p_requesting_entity_id => p_x_header_rec.header_id,
2396: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2397: p_request_unique_key1 => 'CURRENCY',
2398: p_param1 => 'TC',
2399: p_param2 => p_x_header_rec.transactional_curr_code,
2400: x_return_status => l_return_status);
2401: oe_debug_pub.ADD('after call to log_request: l_return_status: '||l_return_status , 1);
2402:
2403: END IF;
2404:
2405: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code)
2406: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2407: THEN
2408: oe_debug_pub.ADD('sales channel update: logging request for eval_hold_source',1);
2409: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2402:
2403: END IF;
2404:
2405: IF NOT OE_GLOBALS.Equal(p_x_header_rec.sales_channel_code,p_old_header_rec.sales_channel_code)
2406: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2407: THEN
2408: oe_debug_pub.ADD('sales channel update: logging request for eval_hold_source',1);
2409: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2410: 'Entity ID:' || to_char(p_x_header_rec.sales_channel_code),1);
2408: oe_debug_pub.ADD('sales channel update: logging request for eval_hold_source',1);
2409: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2410: 'Entity ID:' || to_char(p_x_header_rec.sales_channel_code),1);
2411: OE_delayed_requests_Pvt.log_request
2412: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2413: p_entity_id => p_x_header_rec.header_id,
2414: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2415: p_requesting_entity_id => p_x_header_rec.header_id,
2416: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2410: 'Entity ID:' || to_char(p_x_header_rec.sales_channel_code),1);
2411: OE_delayed_requests_Pvt.log_request
2412: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2413: p_entity_id => p_x_header_rec.header_id,
2414: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2415: p_requesting_entity_id => p_x_header_rec.header_id,
2416: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2417: p_request_unique_key1 => 'SALES_CHANNEL',
2418: p_param1 => 'SC',
2412: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2413: p_entity_id => p_x_header_rec.header_id,
2414: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2415: p_requesting_entity_id => p_x_header_rec.header_id,
2416: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2417: p_request_unique_key1 => 'SALES_CHANNEL',
2418: p_param1 => 'SC',
2419: p_param2 => p_x_header_rec.sales_channel_code,
2420: x_return_status => l_return_status);
2421: oe_debug_pub.ADD('after call to log_request: l_return_status: '||l_return_status , 1);
2422:
2423: END IF;
2424:
2425: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
2426: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2427: THEN
2428: oe_debug_pub.ADD('price list update: logging request for eval_hold_source',1);
2429: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2422:
2423: END IF;
2424:
2425: IF NOT OE_GLOBALS.Equal(p_x_header_rec.price_list_id,p_old_header_rec.price_list_id)
2426: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2427: THEN
2428: oe_debug_pub.ADD('price list update: logging request for eval_hold_source',1);
2429: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2430: 'Entity ID:' || to_char(p_x_header_rec.price_list_id),1);
2428: oe_debug_pub.ADD('price list update: logging request for eval_hold_source',1);
2429: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2430: 'Entity ID:' || to_char(p_x_header_rec.price_list_id),1);
2431: OE_delayed_requests_Pvt.log_request
2432: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2433: p_entity_id => p_x_header_rec.header_id,
2434: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2435: p_requesting_entity_id => p_x_header_rec.header_id,
2436: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2430: 'Entity ID:' || to_char(p_x_header_rec.price_list_id),1);
2431: OE_delayed_requests_Pvt.log_request
2432: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2433: p_entity_id => p_x_header_rec.header_id,
2434: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2435: p_requesting_entity_id => p_x_header_rec.header_id,
2436: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2437: p_request_unique_key1 => 'PRICE_LIST',
2438: p_param1 => 'PL',
2432: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2433: p_entity_id => p_x_header_rec.header_id,
2434: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2435: p_requesting_entity_id => p_x_header_rec.header_id,
2436: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2437: p_request_unique_key1 => 'PRICE_LIST',
2438: p_param1 => 'PL',
2439: p_param2 => p_x_header_rec.price_list_id,
2440: x_return_status => l_return_status);
2441: oe_debug_pub.ADD('after call to log_request: l_return_status: '||l_return_status , 1);
2442:
2443: END IF;
2444:
2445: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
2446: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2447: THEN
2448: oe_debug_pub.ADD('Order type update: logging request for eval_hold_source',1);
2449: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2442:
2443: END IF;
2444:
2445: IF NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id,p_old_header_rec.order_type_id)
2446: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2447: THEN
2448: oe_debug_pub.ADD('Order type update: logging request for eval_hold_source',1);
2449: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2450: 'Entity ID:' || to_char(p_x_header_rec.order_type_id),1);
2448: oe_debug_pub.ADD('Order type update: logging request for eval_hold_source',1);
2449: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2450: 'Entity ID:' || to_char(p_x_header_rec.order_type_id),1);
2451: OE_delayed_requests_Pvt.log_request
2452: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2453: p_entity_id => p_x_header_rec.header_id,
2454: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2455: p_requesting_entity_id => p_x_header_rec.header_id,
2456: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2450: 'Entity ID:' || to_char(p_x_header_rec.order_type_id),1);
2451: OE_delayed_requests_Pvt.log_request
2452: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2453: p_entity_id => p_x_header_rec.header_id,
2454: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2455: p_requesting_entity_id => p_x_header_rec.header_id,
2456: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2457: p_request_unique_key1 => 'ORDER_TYPE',
2458: p_param1 => 'OT',
2452: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2453: p_entity_id => p_x_header_rec.header_id,
2454: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2455: p_requesting_entity_id => p_x_header_rec.header_id,
2456: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
2457: p_request_unique_key1 => 'ORDER_TYPE',
2458: p_param1 => 'OT',
2459: p_param2 => p_x_header_rec.order_type_id,
2460: x_return_status => l_return_status);
2468: -- Log a request for Verify Payment
2469: oe_debug_pub.add('Logging Delayed Request for Verify Payment',3);
2470: --
2471: OE_delayed_requests_Pvt.log_request
2472: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2473: p_entity_id => p_x_header_rec.header_id,
2474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2475: p_requesting_entity_id => p_x_header_rec.header_id,
2476: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
2470: --
2471: OE_delayed_requests_Pvt.log_request
2472: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2473: p_entity_id => p_x_header_rec.header_id,
2474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2475: p_requesting_entity_id => p_x_header_rec.header_id,
2476: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
2477: x_return_status => l_return_status);
2478:
2472: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2473: p_entity_id => p_x_header_rec.header_id,
2474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2475: p_requesting_entity_id => p_x_header_rec.header_id,
2476: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
2477: x_return_status => l_return_status);
2478:
2479: END IF;
2480:
2500:
2501: oe_debug_pub.add('logging synch payment delayed request', 1);
2502:
2503: OE_delayed_requests_Pvt.log_request
2504: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2505: p_entity_id => p_x_header_rec.header_id,
2506: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2507: p_requesting_entity_id => p_x_header_rec.header_id,
2508: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
2502:
2503: OE_delayed_requests_Pvt.log_request
2504: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2505: p_entity_id => p_x_header_rec.header_id,
2506: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2507: p_requesting_entity_id => p_x_header_rec.header_id,
2508: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
2509: p_param1 => 'UPDATE_PAYMENT',
2510: x_return_status => l_return_status);
2504: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2505: p_entity_id => p_x_header_rec.header_id,
2506: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2507: p_requesting_entity_id => p_x_header_rec.header_id,
2508: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
2509: p_param1 => 'UPDATE_PAYMENT',
2510: x_return_status => l_return_status);
2511:
2512: END IF; -- if multiple payments enabled and l_payments_upd_flag = 'Y'
2512: END IF; -- if multiple payments enabled and l_payments_upd_flag = 'Y'
2513: -- and l_payment_count = 1
2514: /*-- 3288805
2515: Store the new order_date_type_code--*/
2516: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.order_date_type_code, p_old_header_rec.order_date_type_code)) OR
2517: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
2518: p_x_header_rec.order_date_type_code IS NOT NULL)
2519: --OR cnd added for bug 5060064
2520: THEN
2513: -- and l_payment_count = 1
2514: /*-- 3288805
2515: Store the new order_date_type_code--*/
2516: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.order_date_type_code, p_old_header_rec.order_date_type_code)) OR
2517: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
2518: p_x_header_rec.order_date_type_code IS NOT NULL)
2519: --OR cnd added for bug 5060064
2520: THEN
2521: IF ( nvl(OE_Schedule_Util.G_HEADER_ID, 0) = p_x_header_rec.header_id )
3954: BEGIN
3955:
3956: oe_debug_pub.add('Entering OE_HEADER_UTIL.UPDATE_ROW', 1);
3957: --Commented for MOAC start
3958: /*l_org_id := OE_GLOBALS.G_ORG_ID;
3959:
3960: IF l_org_id IS NULL THEN
3961: OE_GLOBALS.Set_Context;
3962: l_org_id := OE_GLOBALS.G_ORG_ID;
3957: --Commented for MOAC start
3958: /*l_org_id := OE_GLOBALS.G_ORG_ID;
3959:
3960: IF l_org_id IS NULL THEN
3961: OE_GLOBALS.Set_Context;
3962: l_org_id := OE_GLOBALS.G_ORG_ID;
3963: END IF;*/
3964: --Commented for MOAC end
3965: -- we need to increment lock_control by 1,
3958: /*l_org_id := OE_GLOBALS.G_ORG_ID;
3959:
3960: IF l_org_id IS NULL THEN
3961: OE_GLOBALS.Set_Context;
3962: l_org_id := OE_GLOBALS.G_ORG_ID;
3963: END IF;*/
3964: --Commented for MOAC end
3965: -- we need to increment lock_control by 1,
3966: -- everytime there is an update on the record.
4228:
4229: oe_debug_pub.add('Entering OE_HEADER_UTIL.INSERT_ROW', 1);
4230:
4231: --MOAC change
4232: OE_GLOBALS.Set_Context;
4233: l_org_id := OE_GLOBALS.G_ORG_ID;
4234: IF l_org_id IS NULL THEN
4235: -- org_id is null, don't do insert. raise an error
4236: If l_debug_level > 0 Then
4229: oe_debug_pub.add('Entering OE_HEADER_UTIL.INSERT_ROW', 1);
4230:
4231: --MOAC change
4232: OE_GLOBALS.Set_Context;
4233: l_org_id := OE_GLOBALS.G_ORG_ID;
4234: IF l_org_id IS NULL THEN
4235: -- org_id is null, don't do insert. raise an error
4236: If l_debug_level > 0 Then
4237: oe_debug_pub.add('Org_Id is NULL',1);
4613: -- aksingh update the operation to NULL and update the cache with
4614: -- record
4615: oe_order_cache.g_header_rec := p_header_rec;
4616: oe_order_cache.g_header_rec.operation := null;
4617: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4618:
4619: -- calling notification framework to update global picture
4620: -- check code release level first. Notification framework is at Pack H level
4621: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4677: BEGIN
4678:
4679: oe_debug_pub.add('Entering OE_HEADER_UTIL.DELETE_ROW', 1);
4680: --Commented for MOAC start
4681: /*l_org_id := OE_GLOBALS.G_ORG_ID;
4682: IF l_org_id IS NULL THEN
4683: OE_GLOBALS.Set_Context;
4684: l_org_id := OE_GLOBALS.G_ORG_ID;
4685: END IF;*/
4679: oe_debug_pub.add('Entering OE_HEADER_UTIL.DELETE_ROW', 1);
4680: --Commented for MOAC start
4681: /*l_org_id := OE_GLOBALS.G_ORG_ID;
4682: IF l_org_id IS NULL THEN
4683: OE_GLOBALS.Set_Context;
4684: l_org_id := OE_GLOBALS.G_ORG_ID;
4685: END IF;*/
4686: --Commented for MOAC end
4687: -- added for notification framework
4680: --Commented for MOAC start
4681: /*l_org_id := OE_GLOBALS.G_ORG_ID;
4682: IF l_org_id IS NULL THEN
4683: OE_GLOBALS.Set_Context;
4684: l_org_id := OE_GLOBALS.G_ORG_ID;
4685: END IF;*/
4686: --Commented for MOAC end
4687: -- added for notification framework
4688: --check code release level first. Notification framework is at Pack H level
4687: -- added for notification framework
4688: --check code release level first. Notification framework is at Pack H level
4689: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4690: /* Set the operation on the record so that globals are updated as well */
4691: l_new_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4692: l_new_header_rec.header_id := p_header_id;
4693: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
4694: p_Header_rec =>l_new_header_rec,
4695: p_header_id => p_header_id,
4742: RAISE FND_API.G_EXC_ERROR;
4743: END IF;
4744: -- BUG 2670775 Reverse Limits End
4745: OE_Atchmt_Util.Delete_Attachments
4746: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
4747: , p_entity_id => p_header_id
4748: , x_return_status => l_return_status
4749: );
4750: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4766: END IF;
4767: OE_Holds_PUB.Delete_Holds(p_header_id => p_header_id);
4768:
4769: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
4770: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4771: p_entity_id => p_header_id,
4772: x_return_status => l_return_status
4773: );
4774: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5008: if l_debug_level > 0 then
5009: oe_debug_pub.add('Entering OE_HEADER_UTIL.QUERY_ROW', 1);
5010: end if;
5011: --Commented for MOAC start
5012: /*l_org_id := OE_GLOBALS.G_ORG_ID;
5013: IF l_org_id IS NULL THEN
5014: OE_GLOBALS.Set_Context;
5015: l_org_id := OE_GLOBALS.G_ORG_ID;
5016: END IF;*/
5010: end if;
5011: --Commented for MOAC start
5012: /*l_org_id := OE_GLOBALS.G_ORG_ID;
5013: IF l_org_id IS NULL THEN
5014: OE_GLOBALS.Set_Context;
5015: l_org_id := OE_GLOBALS.G_ORG_ID;
5016: END IF;*/
5017: --Commented for MOAC end
5018: -- aksingh use global record if exists for header_id
5011: --Commented for MOAC start
5012: /*l_org_id := OE_GLOBALS.G_ORG_ID;
5013: IF l_org_id IS NULL THEN
5014: OE_GLOBALS.Set_Context;
5015: l_org_id := OE_GLOBALS.G_ORG_ID;
5016: END IF;*/
5017: --Commented for MOAC end
5018: -- aksingh use global record if exists for header_id
5019: IF oe_order_cache.g_header_rec.header_id = p_header_id
5531: -- following constants are used to debug lock_order,
5532: -- please do not use them for any other purpose.
5533: -- set G_LOCK_TEST := 'Y', for debugging.
5534:
5535: OE_GLOBALS.G_LOCK_CONST := 0;
5536: --OE_GLOBALS.G_LOCK_TEST := 'Y';
5537: OE_GLOBALS.G_LOCK_TEST := 'N';
5538:
5539: IF OE_GLOBALS.Equal(p_x_header_rec.lock_control,
5532: -- please do not use them for any other purpose.
5533: -- set G_LOCK_TEST := 'Y', for debugging.
5534:
5535: OE_GLOBALS.G_LOCK_CONST := 0;
5536: --OE_GLOBALS.G_LOCK_TEST := 'Y';
5537: OE_GLOBALS.G_LOCK_TEST := 'N';
5538:
5539: IF OE_GLOBALS.Equal(p_x_header_rec.lock_control,
5540: l_lock_control)
5533: -- set G_LOCK_TEST := 'Y', for debugging.
5534:
5535: OE_GLOBALS.G_LOCK_CONST := 0;
5536: --OE_GLOBALS.G_LOCK_TEST := 'Y';
5537: OE_GLOBALS.G_LOCK_TEST := 'N';
5538:
5539: IF OE_GLOBALS.Equal(p_x_header_rec.lock_control,
5540: l_lock_control)
5541: THEN
5535: OE_GLOBALS.G_LOCK_CONST := 0;
5536: --OE_GLOBALS.G_LOCK_TEST := 'Y';
5537: OE_GLOBALS.G_LOCK_TEST := 'N';
5538:
5539: IF OE_GLOBALS.Equal(p_x_header_rec.lock_control,
5540: l_lock_control)
5541: THEN
5542:
5543: oe_debug_pub.add('done comparison, success', 1);
5571: END IF;
5572:
5573: oe_debug_pub.add('Exiting OE_HEADER_UTIL.LOCK_ROW', 1);
5574:
5575: OE_GLOBALS.G_LOCK_TEST := 'N';
5576: EXCEPTION
5577:
5578: WHEN NO_DATA_FOUND THEN
5579:
5589: OE_MSG_PUB.Add;
5590:
5591: END IF;
5592:
5593: OE_GLOBALS.G_LOCK_TEST := 'N';
5594:
5595: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
5596:
5597: x_return_status := FND_API.G_RET_STS_ERROR;
5605: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5606: OE_MSG_PUB.Add;
5607:
5608: END IF;
5609: OE_GLOBALS.G_LOCK_TEST := 'N';
5610: WHEN OTHERS THEN
5611:
5612: oe_debug_pub.add('others in lock_header', 1);
5613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5619: ( G_PKG_NAME
5620: , 'Lock_Row'
5621: );
5622: END IF;
5623: OE_GLOBALS.G_LOCK_TEST := 'N';
5624: END Lock_Row;
5625:
5626: -- Function Get_Values
5627:
5643: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;
5644:
5645: IF (p_header_rec.accounting_rule_id IS NULL OR
5646: p_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM) AND
5647: NOT OE_GLOBALS.Equal(p_header_rec.accounting_rule_id,
5648: p_old_header_rec.accounting_rule_id)
5649: THEN
5650: l_header_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule
5651: ( p_accounting_rule_id => p_header_rec.accounting_rule_id
5653: END IF;
5654:
5655: IF (p_header_rec.agreement_id IS NULL OR
5656: p_header_rec.agreement_id <> FND_API.G_MISS_NUM) AND
5657: NOT OE_GLOBALS.Equal(p_header_rec.agreement_id,
5658: p_old_header_rec.agreement_id)
5659: THEN
5660: l_header_val_rec.agreement := OE_Id_To_Value.Agreement
5661: ( p_agreement_id => p_header_rec.agreement_id
5663: END IF;
5664:
5665: IF (p_header_rec.conversion_type_code IS NULL OR
5666: p_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR) AND
5667: NOT OE_GLOBALS.Equal(p_header_rec.conversion_type_code,
5668: p_old_header_rec.conversion_type_code)
5669: THEN
5670: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
5671: ( p_conversion_type_code => p_header_rec.conversion_type_code
5673: END IF;
5674:
5675: IF (p_header_rec.deliver_to_contact_id IS NULL OR
5676: p_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM) AND
5677: NOT OE_GLOBALS.Equal(p_header_rec.deliver_to_contact_id,
5678: p_old_header_rec.deliver_to_contact_id)
5679: THEN
5680: l_header_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact
5681: ( p_deliver_to_contact_id => p_header_rec.deliver_to_contact_id
5683: END IF;
5684:
5685: IF (p_header_rec.deliver_to_org_id IS NULL OR
5686: p_header_rec.deliver_to_org_id <> FND_API.G_MISS_NUM) AND
5687: NOT OE_GLOBALS.Equal(p_header_rec.deliver_to_org_id,
5688: p_old_header_rec.deliver_to_org_id)
5689: THEN
5690: get_customer_details
5691: ( p_org_id => p_header_rec.deliver_to_org_id
5708: END IF;
5709:
5710: IF (p_header_rec.fob_point_code IS NULL OR
5711: p_header_rec.fob_point_code <> FND_API.G_MISS_CHAR) AND
5712: NOT OE_GLOBALS.Equal(p_header_rec.fob_point_code,
5713: p_old_header_rec.fob_point_code)
5714: THEN
5715: l_header_val_rec.fob_point := OE_Id_To_Value.Fob_Point
5716: ( p_fob_point_code => p_header_rec.fob_point_code
5718: END IF;
5719:
5720: IF (p_header_rec.freight_terms_code IS NULL OR
5721: p_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR) AND
5722: NOT OE_GLOBALS.Equal(p_header_rec.freight_terms_code,
5723: p_old_header_rec.freight_terms_code)
5724: THEN
5725: l_header_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms
5726: ( p_freight_terms_code => p_header_rec.freight_terms_code
5728: END IF;
5729:
5730: IF (p_header_rec.freight_carrier_code IS NULL OR
5731: p_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR) AND
5732: NOT OE_GLOBALS.Equal(p_header_rec.freight_carrier_code,
5733: p_old_header_rec.freight_carrier_code)
5734: THEN
5735: l_header_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier
5736: ( p_freight_carrier_code => p_header_rec.freight_carrier_code
5738: );
5739: END IF;
5740: IF (p_header_rec.shipping_method_code IS NULL OR
5741: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
5742: NOT OE_GLOBALS.Equal(p_header_rec.shipping_method_code,
5743: p_old_header_rec.shipping_method_code)
5744: THEN
5745: l_header_val_rec.shipping_method := OE_Id_To_Value.ship_method
5746: ( p_ship_method_code => p_header_rec.shipping_method_code
5748: END IF;
5749:
5750: IF (p_header_rec.invoice_to_contact_id IS NULL OR
5751: p_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM) AND
5752: NOT OE_GLOBALS.Equal(p_header_rec.invoice_to_contact_id,
5753: p_old_header_rec.invoice_to_contact_id)
5754: THEN
5755: l_header_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact
5756: ( p_invoice_to_contact_id => p_header_rec.invoice_to_contact_id
5758: END IF;
5759:
5760: IF (p_header_rec.invoice_to_org_id IS NULL OR
5761: p_header_rec.invoice_to_org_id <> FND_API.G_MISS_NUM) AND
5762: NOT OE_GLOBALS.Equal(p_header_rec.invoice_to_org_id,
5763: p_old_header_rec.invoice_to_org_id)
5764: THEN
5765:
5766: get_customer_details
5784: END IF;
5785:
5786: IF (p_header_rec.invoicing_rule_id IS NULL OR
5787: p_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM) AND
5788: NOT OE_GLOBALS.Equal(p_header_rec.invoicing_rule_id,
5789: p_old_header_rec.invoicing_rule_id)
5790: THEN
5791: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
5792: ( p_invoicing_rule_id => p_header_rec.invoicing_rule_id
5794: END IF;
5795:
5796: IF (p_header_rec.order_source_id IS NULL OR
5797: p_header_rec.order_source_id <> FND_API.G_MISS_NUM) AND
5798: NOT OE_GLOBALS.Equal(p_header_rec.order_source_id,
5799: p_old_header_rec.order_source_id)
5800: THEN
5801: l_header_val_rec.order_source := OE_Id_To_Value.Order_Source
5802: ( p_order_source_id => p_header_rec.order_source_id
5804: END IF;
5805:
5806: IF (p_header_rec.order_date_type_code IS NULL OR
5807: p_header_rec.order_date_type_code <> FND_API.G_MISS_CHAR) AND
5808: NOT OE_GLOBALS.Equal(p_header_rec.order_date_type_code,
5809: p_old_header_rec.order_date_type_code)
5810: THEN
5811: l_header_val_rec.order_date_type := OE_Id_To_Value.Order_Date_Type
5812: ( p_order_date_type_code => p_header_rec.order_date_type_code
5814: END IF;
5815:
5816: IF (p_header_rec.order_type_id IS NULL OR
5817: p_header_rec.order_type_id <> FND_API.G_MISS_NUM) AND
5818: NOT OE_GLOBALS.Equal(p_header_rec.order_type_id,
5819: p_old_header_rec.order_type_id)
5820: THEN
5821: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type
5822: ( p_order_type_id => p_header_rec.order_type_id
5824: END IF;
5825:
5826: IF (p_header_rec.payment_term_id IS NULL OR
5827: p_header_rec.payment_term_id <> FND_API.G_MISS_NUM) AND
5828: NOT OE_GLOBALS.Equal(p_header_rec.payment_term_id,
5829: p_old_header_rec.payment_term_id)
5830: THEN
5831: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term
5832: ( p_payment_term_id => p_header_rec.payment_term_id
5834: END IF;
5835:
5836: IF (p_header_rec.price_list_id IS NULL OR
5837: p_header_rec.price_list_id <> FND_API.G_MISS_NUM) AND
5838: NOT OE_GLOBALS.Equal(p_header_rec.price_list_id,
5839: p_old_header_rec.price_list_id)
5840: THEN
5841: l_header_val_rec.price_list := OE_Id_To_Value.Price_List
5842: ( p_price_list_id => p_header_rec.price_list_id
5844: END IF;
5845:
5846: IF (p_header_rec.return_reason_code IS NULL OR
5847: p_header_rec.return_reason_code <> FND_API.G_MISS_CHAR) AND
5848: NOT OE_GLOBALS.Equal(p_header_rec.return_reason_code,
5849: p_old_header_rec.return_reason_code)
5850: THEN
5851: l_header_val_rec.return_reason := OE_Id_To_Value.return_reason
5852: ( p_return_reason_code => p_header_rec.return_reason_code
5854: END IF;
5855:
5856: IF (p_header_rec.salesrep_id IS NULL OR
5857: p_header_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
5858: NOT OE_GLOBALS.Equal(p_header_rec.salesrep_id,
5859: p_old_header_rec.salesrep_id)
5860: THEN
5861: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
5862: ( p_salesrep_id => p_header_rec.salesrep_id
5864: END IF;
5865:
5866: IF (p_header_rec.sales_channel_code IS NULL OR
5867: p_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR) AND
5868: NOT OE_GLOBALS.Equal(p_header_rec.sales_channel_code,
5869: p_old_header_rec.sales_channel_code)
5870: THEN
5871: l_header_val_rec.sales_channel:= OE_Id_To_Value.sales_channel
5872: ( p_sales_channel_code => p_header_rec.sales_channel_code
5874: END IF;
5875:
5876: IF (p_header_rec.shipment_priority_code IS NULL OR
5877: p_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR) AND
5878: NOT OE_GLOBALS.Equal(p_header_rec.shipment_priority_code,
5879: p_old_header_rec.shipment_priority_code)
5880: THEN
5881: l_header_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority
5882: ( p_shipment_priority_code => p_header_rec.shipment_priority_code
5884: END IF;
5885:
5886: IF (p_header_rec.demand_class_code IS NULL OR
5887: p_header_rec.demand_class_code <> FND_API.G_MISS_CHAR) AND
5888: NOT OE_GLOBALS.Equal(p_header_rec.demand_class_code,
5889: p_old_header_rec.demand_class_code)
5890: THEN
5891: l_header_val_rec.Demand_Class := OE_Id_To_Value.Demand_Class
5892: ( p_demand_class_code => p_header_rec.demand_class_code
5894: END IF;
5895:
5896: IF (p_header_rec.ship_from_org_id IS NULL OR
5897: p_header_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND
5898: NOT OE_GLOBALS.Equal(p_header_rec.ship_from_org_id,
5899: p_old_header_rec.ship_from_org_id)
5900: THEN
5901: OE_Id_To_Value.Ship_From_Org
5902: ( p_ship_from_org_id => p_header_rec.ship_from_org_id
5910: END IF;
5911:
5912: IF (p_header_rec.ship_to_contact_id IS NULL OR
5913: p_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM) AND
5914: NOT OE_GLOBALS.Equal(p_header_rec.ship_to_contact_id,
5915: p_old_header_rec.ship_to_contact_id)
5916: THEN
5917: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact
5918: ( p_ship_to_contact_id => p_header_rec.ship_to_contact_id
5920: END IF;
5921:
5922: IF (p_header_rec.ship_to_org_id IS NULL OR
5923: p_header_rec.ship_to_org_id <> FND_API.G_MISS_NUM) AND
5924: NOT OE_GLOBALS.Equal(p_header_rec.ship_to_org_id,
5925: p_old_header_rec.ship_to_org_id)
5926: THEN
5927: get_customer_details
5928: ( p_org_id => p_header_rec.ship_to_org_id
5946:
5947:
5948: IF (p_header_rec.sold_to_contact_id IS NULL OR
5949: p_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM) AND
5950: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_contact_id,
5951: p_old_header_rec.sold_to_contact_id)
5952: THEN
5953: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
5954: ( p_sold_to_contact_id => p_header_rec.sold_to_contact_id
5956: END IF;
5957:
5958: IF (p_header_rec.sold_to_org_id IS NULL OR
5959: p_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM) AND
5960: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,
5961: p_old_header_rec.sold_to_org_id)
5962: THEN
5963: OE_Id_To_Value.Sold_To_Org
5964: ( p_sold_to_org_id => p_header_rec.sold_to_org_id
5971: END IF;
5972:
5973: IF (p_header_rec.tax_exempt_flag IS NULL OR
5974: p_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR) AND
5975: NOT OE_GLOBALS.Equal(p_header_rec.tax_exempt_flag,
5976: p_old_header_rec.tax_exempt_flag)
5977: THEN
5978: l_header_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt
5979: ( p_tax_exempt_flag => p_header_rec.tax_exempt_flag
5981: END IF;
5982:
5983: IF (p_header_rec.tax_exempt_reason_code IS NULL OR
5984: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) AND
5985: NOT OE_GLOBALS.Equal(p_header_rec.tax_exempt_reason_code,
5986: p_old_header_rec.tax_exempt_reason_code)
5987: THEN
5988: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
5989: ( p_tax_exempt_reason_code => p_header_rec.tax_exempt_reason_code
5991: END IF;
5992:
5993: IF (p_header_rec.tax_point_code IS NULL OR
5994: p_header_rec.tax_point_code <> FND_API.G_MISS_CHAR) AND
5995: NOT OE_GLOBALS.Equal(p_header_rec.tax_point_code,
5996: p_old_header_rec.tax_point_code)
5997: THEN
5998: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
5999: ( p_tax_point_code => p_header_rec.tax_point_code
6001: END IF;
6002:
6003: IF (p_header_rec.payment_type_code IS NULL OR
6004: p_header_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
6005: NOT OE_GLOBALS.Equal(p_header_rec.payment_type_code,
6006: p_old_header_rec.payment_type_code)
6007: THEN
6008: l_header_val_rec.payment_type := OE_Id_To_Value.Payment_Type
6009: ( p_payment_type_code => p_header_rec.payment_type_code
6011: END IF;
6012: --R12 CC Encryption
6013: IF (p_header_rec.credit_card_code IS NULL OR
6014: p_header_rec.credit_card_code <> FND_API.G_MISS_CHAR) AND
6015: NOT OE_GLOBALS.Equal(p_header_rec.credit_card_code,
6016: p_old_header_rec.credit_card_code)
6017: THEN
6018: l_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card
6019: ( p_credit_card_code => p_header_rec.credit_card_code
6022: -- QUOTING changes
6023:
6024: IF (p_header_rec.sold_to_site_use_id IS NULL OR
6025: p_header_rec.sold_to_site_use_id <> FND_API.G_MISS_NUM) AND
6026: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_site_use_id,
6027: p_old_header_rec.sold_to_site_use_id)
6028: THEN
6029:
6030: OE_ID_TO_VALUE.CUSTOMER_LOCATION
6043: END IF;
6044:
6045: IF (p_header_rec.transaction_phase_code IS NULL OR
6046: p_header_rec.transaction_phase_code <> FND_API.G_MISS_CHAR) AND
6047: NOT OE_GLOBALS.Equal(p_header_rec.transaction_phase_code,
6048: p_old_header_rec.transaction_phase_code)
6049: THEN
6050: l_header_val_rec.transaction_phase := OE_Id_To_Value.Transaction_Phase
6051: ( p_transaction_phase_code => p_header_rec.transaction_phase_code
6053: END IF;
6054:
6055: IF (p_header_rec.user_status_code IS NULL OR
6056: p_header_rec.user_status_code <> FND_API.G_MISS_CHAR) AND
6057: NOT OE_GLOBALS.Equal(p_header_rec.user_status_code,
6058: p_old_header_rec.user_status_code)
6059: THEN
6060: l_header_val_rec.user_status := OE_Id_To_Value.User_Status
6061: ( p_user_status_code => p_header_rec.user_status_code
6108: -- END BSA pricing
6109:
6110: IF (p_header_rec.ib_owner IS NULL OR
6111: p_header_rec.ib_owner <> FND_API.G_MISS_CHAR) AND
6112: NOT OE_GLOBALS.Equal(p_header_rec.ib_owner,
6113: p_old_header_rec.ib_owner)
6114: THEN
6115: l_header_val_rec.ib_owner_dsp := OE_Id_To_Value.ib_owner
6116: ( p_ib_owner => p_header_rec.ib_owner
6118: END IF;
6119:
6120: IF (p_header_rec.ib_current_location IS NULL OR
6121: p_header_rec.ib_current_location <> FND_API.G_MISS_CHAR) AND
6122: NOT OE_GLOBALS.Equal(p_header_rec.ib_current_location,
6123: p_old_header_rec.ib_current_location)
6124: THEN
6125: l_header_val_rec.ib_current_location_dsp := OE_Id_To_Value.ib_current_location(
6126: p_ib_current_location=>p_header_rec.ib_current_location
6128: END IF;
6129:
6130: IF (p_header_rec.ib_installed_at_location IS NULL OR
6131: p_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR) AND
6132: NOT OE_GLOBALS.Equal(p_header_rec.ib_installed_at_location,
6133: p_old_header_rec.ib_installed_at_location)
6134: THEN
6135: l_header_val_rec.ib_installed_at_location_dsp := OE_Id_To_Value.ib_installed_at_location(
6136: p_ib_installed_at_location=>p_header_rec.ib_installed_at_location
6981: -- Retrieve the sold_to_org_id if not passed on the header record. This
6982: -- will be needed by the value_to_id functions for related fields.
6983: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
6984:
6985: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
6986: AND p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
6987: THEN
6988:
6989: SELECT SOLD_TO_ORG_ID
7215: -- Retrieve the org_ids if not passed on the header record. These
7216: -- IDs will be needed by the value_to_id functions for CONTACT fields.
7217: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id
7218:
7219: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
7220: AND ( p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM
7221: OR p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM
7222: OR p_x_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM )
7223: THEN
7778: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7779: oe_debug_pub.add('Entering OE_HEADER_UTIL.Get_Order_Number',1);
7780: -- Check if Order Number can be updated or not???? bug 4146258
7781: -- Fixed by Srini
7782: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_number,
7783: p_old_header_rec.order_number)
7784: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
7785: AND p_old_header_rec.order_number is not null
7786: AND p_old_header_rec.order_number <> FND_API.G_MISS_NUM
7780: -- Check if Order Number can be updated or not???? bug 4146258
7781: -- Fixed by Srini
7782: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_number,
7783: p_old_header_rec.order_number)
7784: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
7785: AND p_old_header_rec.order_number is not null
7786: AND p_old_header_rec.order_number <> FND_API.G_MISS_NUM
7787: THEN
7788: if p_x_header_rec.booked_flag = 'Y' and
7814: X_Prd_Tbl_Name,
7815: X_Aud_Tbl_Name,
7816: X_Msg_Flag);
7817:
7818: if p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
7819: x_doc_sequence_type = 'A'
7820: then
7821: FND_MESSAGE.SET_NAME('ONT','ONT_ORD_NUM_MISMATCH');
7822: OE_MSG_PUB.Add;
7825:
7826: END IF;
7827:
7828: -- QUOTING changes
7829: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_type_id,
7830: p_old_header_rec.order_type_id)
7831: OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
7832: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transaction_phase_code,
7833: p_old_header_rec.transaction_phase_code)
7828: -- QUOTING changes
7829: IF NOT OE_GLOBALS.EQUAL(p_x_header_rec.order_type_id,
7830: p_old_header_rec.order_type_id)
7831: OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
7832: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transaction_phase_code,
7833: p_old_header_rec.transaction_phase_code)
7834: )
7835: THEN
7836:
7983: p_old_header_rec.order_number <> FND_API.G_MISS_NUM) AND
7984: OE_Quote_Util.G_COMPLETE_NEG = 'N' THEN
7985: oe_debug_pub.add('Ord_Num Changed, Calling Set_Header_User_Key and WF_ENGINE.SetItemUserKey',1);
7986: OE_Order_WF_Util.Set_Header_User_Key(p_x_header_rec);
7987: WF_ENGINE.SetItemUserKey(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7988: substrb(fnd_message.get, 1, 240));
7989:
7990: WF_ENGINE.SetItemAttrNumber(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7991: 'ORDER_NUMBER', p_x_header_rec.order_number); -- Bug 3589688
7986: OE_Order_WF_Util.Set_Header_User_Key(p_x_header_rec);
7987: WF_ENGINE.SetItemUserKey(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7988: substrb(fnd_message.get, 1, 240));
7989:
7990: WF_ENGINE.SetItemAttrNumber(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7991: 'ORDER_NUMBER', p_x_header_rec.order_number); -- Bug 3589688
7992: END IF;
7993:
7994: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
8020: (p_header_id => p_x_header_rec.header_id
8021: ,p_sales_document_type_code => 'O'
8022: ,p_transaction_number => p_x_header_rec.quote_number
8023: );
8024: WF_ENGINE.SetItemAttrNumber(OE_GLOBALS.G_WFI_NGO, to_char(p_x_header_rec.header_id),
8025: 'TRANSACTION_NUMBER', p_x_header_rec.quote_number); -- Bug 3589688
8026: END IF;
8027:
8028:
8140:
8141: l_return_status VARCHAR2(30);
8142: l_count NUMBER;
8143: /* Variables to call process order */
8144: l_control_rec OE_GLOBALS.Control_Rec_Type;
8145: p_x_old_header_rec OE_ORDER_PUB.Header_Rec_Type:= p_old_header_rec ;
8146: l_msg_count NUMBER;
8147: l_msg_data VARCHAR2(2000);
8148: l_new_order_type varchar2(80);
8186: -- Setting the global for IR ISO Tracking bug 7667702
8187:
8188: /* Start AuditTrail */
8189:
8190: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
8191:
8192: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
8193: OE_DEBUG_PUB.add('OEXUHDRB: Audit check requires reason', 5);
8194:
8188: /* Start AuditTrail */
8189:
8190: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
8191:
8192: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
8193: OE_DEBUG_PUB.add('OEXUHDRB: Audit check requires reason', 5);
8194:
8195: IF (p_x_header_rec.change_reason IS NULL
8196: OR p_x_header_rec.change_reason = FND_API.G_MISS_CHAR
8200: IF OE_Versioning_Util.Captured_Reason IS NULL THEN
8201: OE_Versioning_Util.Get_Reason_Info(l_reason_code, l_reason_comments);
8202: IF l_reason_code IS NULL THEN
8203: -- bug 3636884, defaulting reason from group API
8204: IF OE_GLOBALS.G_DEFAULT_REASON THEN
8205: oe_debug_pub.add('Defaulting Audit Reason for Order Header', 1);
8206: p_x_header_rec.change_reason := 'SYSTEM';
8207: ELSE
8208: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8225: END IF;
8226:
8227: /* START PREPAYMENT */
8228: IF (p_x_header_rec.payment_term_id IS NOT NULL AND --Bug 4207730
8229: NOT OE_GLOBALS.Equal(p_x_header_rec.payment_term_id,p_old_header_rec.payment_term_id))
8230: THEN
8231: IF OE_PREPAYMENT_UTIL.Is_Prepaid_Order(p_x_header_rec) = 'Y' THEN
8232: FND_MESSAGE.SET_NAME('ONT', 'ONT_USE_HDR_TERMS_FOR_INVOICE');
8233: OE_MSG_PUB.Add;
8235: END IF;
8236: /* END PREPAYMENT */
8237: -- Included to fix bug 1589196 Begin
8238:
8239: IF NOT OE_GLOBALS.Equal(p_x_header_rec.salesrep_id,p_old_header_rec.salesrep_id)
8240: then
8241: IF p_x_header_rec.operation <> OE_GLOBALS.G_OPR_CREATE THEN
8242: OPEN C_HSC_COUNT(p_x_header_rec.header_id);
8243: FETCH C_HSC_COUNT INTO l_sales_crd_cnt, l_sales_crd_id;
8237: -- Included to fix bug 1589196 Begin
8238:
8239: IF NOT OE_GLOBALS.Equal(p_x_header_rec.salesrep_id,p_old_header_rec.salesrep_id)
8240: then
8241: IF p_x_header_rec.operation <> OE_GLOBALS.G_OPR_CREATE THEN
8242: OPEN C_HSC_COUNT(p_x_header_rec.header_id);
8243: FETCH C_HSC_COUNT INTO l_sales_crd_cnt, l_sales_crd_id;
8244: CLOSE C_HSC_COUNT;
8245: if l_sales_crd_cnt > 1 then
8261: IF (p_x_header_rec.cancelled_flag = 'Y')AND
8262: (p_x_header_rec.cancelled_flag <> NVL(p_old_header_rec.cancelled_flag,'N')) THEN -- Bug 9241924
8263:
8264: /* Fix Bug # 3241831: Set Global before Order Cancellation Starts */
8265: IF OE_GLOBALS.G_UI_FLAG = FALSE THEN
8266: oe_debug_pub.add('SET G_ORD_LVL_CAN TO TRUE FOR NON UI ORDER CANCEL');
8267: OE_OE_FORM_CANCEL_LINE.g_ord_lvl_can := TRUE;
8268: END IF;
8269:
8303: -- Please refer to following delayed request params with their meaning
8304: -- useful while logging the delayed request -
8305: --
8306: -- P_entity_code Entity for which delayed request has to be logged.
8307: -- In this project it can be OE_Globals.G_Entity_Line
8308: -- or OE_Globals.G_Entity_Header
8309: -- P_entity_id Primary key of the entity record. In this project,
8310: -- it can be Order Line_id or Header_id
8311: -- P_requesting_entity_code Which entity has requested this delayed request to
8304: -- useful while logging the delayed request -
8305: --
8306: -- P_entity_code Entity for which delayed request has to be logged.
8307: -- In this project it can be OE_Globals.G_Entity_Line
8308: -- or OE_Globals.G_Entity_Header
8309: -- P_entity_id Primary key of the entity record. In this project,
8310: -- it can be Order Line_id or Header_id
8311: -- P_requesting_entity_code Which entity has requested this delayed request to
8312: -- be logged! In this project it will be OE_Globals.
8308: -- or OE_Globals.G_Entity_Header
8309: -- P_entity_id Primary key of the entity record. In this project,
8310: -- it can be Order Line_id or Header_id
8311: -- P_requesting_entity_code Which entity has requested this delayed request to
8312: -- be logged! In this project it will be OE_Globals.
8313: -- G_Entity_Line or OE_Globals.G_Entity_Header
8314: -- P_requesting_entity_id Primary key of the requesting entity. In this
8315: -- project, it is Line_id or Header_id
8316: -- P_request_type Indicates which business logic (or which procedure)
8309: -- P_entity_id Primary key of the entity record. In this project,
8310: -- it can be Order Line_id or Header_id
8311: -- P_requesting_entity_code Which entity has requested this delayed request to
8312: -- be logged! In this project it will be OE_Globals.
8313: -- G_Entity_Line or OE_Globals.G_Entity_Header
8314: -- P_requesting_entity_id Primary key of the requesting entity. In this
8315: -- project, it is Line_id or Header_id
8316: -- P_request_type Indicates which business logic (or which procedure)
8317: -- should be executed. In this project, it is OE_Global
8387: oe_debug_pub.add(' Header level cancellation. Log the IR ISO update delayed request',5);
8388: END IF;
8389:
8390: OE_delayed_requests_Pvt.log_request
8391: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8392: , p_entity_id => p_x_header_rec.header_id
8393: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8394: , p_requesting_entity_id => p_x_header_rec.header_id
8395: , p_request_unique_key2 => p_x_header_rec.source_document_id -- Req Hdr_id
8389:
8390: OE_delayed_requests_Pvt.log_request
8391: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8392: , p_entity_id => p_x_header_rec.header_id
8393: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8394: , p_requesting_entity_id => p_x_header_rec.header_id
8395: , p_request_unique_key2 => p_x_header_rec.source_document_id -- Req Hdr_id
8396: , p_param2 => 'Y'
8397: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
8393: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8394: , p_requesting_entity_id => p_x_header_rec.header_id
8395: , p_request_unique_key2 => p_x_header_rec.source_document_id -- Req Hdr_id
8396: , p_param2 => 'Y'
8397: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
8398: , x_return_status => l_return_status
8399: );
8400:
8401: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8419: -- freight carrier field.
8420:
8421: IF (p_x_header_rec.order_category_code <> 'RETURN') THEN
8422:
8423: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,
8424: p_old_header_rec.ship_from_org_id) OR
8425: NOT OE_GLOBALS.Equal(p_x_header_rec.shipping_method_code,
8426: p_old_header_rec.shipping_method_code)) THEN
8427:
8421: IF (p_x_header_rec.order_category_code <> 'RETURN') THEN
8422:
8423: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.ship_from_org_id,
8424: p_old_header_rec.ship_from_org_id) OR
8425: NOT OE_GLOBALS.Equal(p_x_header_rec.shipping_method_code,
8426: p_old_header_rec.shipping_method_code)) THEN
8427:
8428: IF p_x_header_rec.shipping_method_code IS NOT NULL AND
8429: p_x_header_rec.ship_from_org_id IS NOT NULL THEN
8534: l_line_tbl(j).shipping_method_code := NULL;
8535: ELSE
8536: l_line_tbl(j).shipping_method_code := l_modified_from;
8537: END IF;
8538: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
8539: End If;
8540: end loop;
8541: IF l_line_tbl.count > 0 THEN
8542: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
8538: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
8539: End If;
8540: end loop;
8541: IF l_line_tbl.count > 0 THEN
8542: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
8543: l_control_rec.controlled_operation := TRUE;
8544: l_control_rec.check_security := TRUE;
8545: l_control_rec.clear_dependents := FALSE;
8546: l_control_rec.default_attributes := FALSE;
8561: RAISE FND_API.G_EXC_ERROR;
8562: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8564: END IF;
8565: OE_GLOBALS.G_PRICING_RECURSION := 'N';
8566: END IF;
8567: --bug 4190357
8568:
8569: END IF;
8575:
8576:
8577: -- Log delayed request to create automatic attachments
8578: /*6896311
8579: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
8580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) AND --5893276
8581: 6896311*/
8582: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND --6896311
8583: l_apply_automatic_atchmt = 'Y' THEN
8576:
8577: -- Log delayed request to create automatic attachments
8578: /*6896311
8579: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
8580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) AND --5893276
8581: 6896311*/
8582: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND --6896311
8583: l_apply_automatic_atchmt = 'Y' THEN
8584: oe_debug_pub.add('log request to apply atcmt');
8578: /*6896311
8579: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
8580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) AND --5893276
8581: 6896311*/
8582: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND --6896311
8583: l_apply_automatic_atchmt = 'Y' THEN
8584: oe_debug_pub.add('log request to apply atcmt');
8585: OE_DELAYED_REQUESTS_PVT.Log_Request
8586: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8582: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND --6896311
8583: l_apply_automatic_atchmt = 'Y' THEN
8584: oe_debug_pub.add('log request to apply atcmt');
8585: OE_DELAYED_REQUESTS_PVT.Log_Request
8586: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8587: p_entity_id => p_x_header_rec.header_id,
8588: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8589: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8590: p_requesting_entity_id => p_x_header_rec.header_id,
8584: oe_debug_pub.add('log request to apply atcmt');
8585: OE_DELAYED_REQUESTS_PVT.Log_Request
8586: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8587: p_entity_id => p_x_header_rec.header_id,
8588: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8589: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8590: p_requesting_entity_id => p_x_header_rec.header_id,
8591: x_return_status => l_return_status
8592: );
8585: OE_DELAYED_REQUESTS_PVT.Log_Request
8586: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8587: p_entity_id => p_x_header_rec.header_id,
8588: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8589: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8590: p_requesting_entity_id => p_x_header_rec.header_id,
8591: x_return_status => l_return_status
8592: );
8593: END IF;
8592: );
8593: END IF;
8594:
8595: --6896311
8596: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE ) AND
8597: l_apply_automatic_atchmt = 'Y'
8598: THEN
8599: oe_debug_pub.add('log request to update atcmt');
8600:
8601: --7688372 start
8602: Load_attachment_rules;
8603: --7688372 end
8604:
8605: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.CUST_PO_NUMBER
8606: ,p_old_header_rec.CUST_PO_NUMBER) AND g_attachment_rule_count_tab.exists('CUST_PO_NUMBER')) --7688372
8607: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.INVOICE_TO_ORG_ID
8608: ,p_old_header_rec.INVOICE_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('INVOICE_TO_ORG_ID')) --7688372
8609: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_TYPE_ID
8603: --7688372 end
8604:
8605: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.CUST_PO_NUMBER
8606: ,p_old_header_rec.CUST_PO_NUMBER) AND g_attachment_rule_count_tab.exists('CUST_PO_NUMBER')) --7688372
8607: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.INVOICE_TO_ORG_ID
8608: ,p_old_header_rec.INVOICE_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('INVOICE_TO_ORG_ID')) --7688372
8609: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_TYPE_ID
8610: ,p_old_header_rec.ORDER_TYPE_ID) AND g_attachment_rule_count_tab.exists('ORDER_TYPE_ID')) --7688372
8611: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SHIP_TO_ORG_ID
8605: IF (NOT OE_GLOBALS.Equal(p_x_header_rec.CUST_PO_NUMBER
8606: ,p_old_header_rec.CUST_PO_NUMBER) AND g_attachment_rule_count_tab.exists('CUST_PO_NUMBER')) --7688372
8607: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.INVOICE_TO_ORG_ID
8608: ,p_old_header_rec.INVOICE_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('INVOICE_TO_ORG_ID')) --7688372
8609: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_TYPE_ID
8610: ,p_old_header_rec.ORDER_TYPE_ID) AND g_attachment_rule_count_tab.exists('ORDER_TYPE_ID')) --7688372
8611: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SHIP_TO_ORG_ID
8612: ,p_old_header_rec.SHIP_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SHIP_TO_ORG_ID')) --7688372
8613: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SOLD_TO_ORG_ID
8607: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.INVOICE_TO_ORG_ID
8608: ,p_old_header_rec.INVOICE_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('INVOICE_TO_ORG_ID')) --7688372
8609: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_TYPE_ID
8610: ,p_old_header_rec.ORDER_TYPE_ID) AND g_attachment_rule_count_tab.exists('ORDER_TYPE_ID')) --7688372
8611: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SHIP_TO_ORG_ID
8612: ,p_old_header_rec.SHIP_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SHIP_TO_ORG_ID')) --7688372
8613: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SOLD_TO_ORG_ID
8614: ,p_old_header_rec.SOLD_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SOLD_TO_ORG_ID')) --7688372
8615: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_CATEGORY_CODE
8609: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_TYPE_ID
8610: ,p_old_header_rec.ORDER_TYPE_ID) AND g_attachment_rule_count_tab.exists('ORDER_TYPE_ID')) --7688372
8611: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SHIP_TO_ORG_ID
8612: ,p_old_header_rec.SHIP_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SHIP_TO_ORG_ID')) --7688372
8613: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SOLD_TO_ORG_ID
8614: ,p_old_header_rec.SOLD_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SOLD_TO_ORG_ID')) --7688372
8615: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_CATEGORY_CODE
8616: ,p_old_header_rec.ORDER_CATEGORY_CODE) AND g_attachment_rule_count_tab.exists('ORDER_CATEGORY_CODE')) --7688372
8617: THEN
8611: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SHIP_TO_ORG_ID
8612: ,p_old_header_rec.SHIP_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SHIP_TO_ORG_ID')) --7688372
8613: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.SOLD_TO_ORG_ID
8614: ,p_old_header_rec.SOLD_TO_ORG_ID) AND g_attachment_rule_count_tab.exists('SOLD_TO_ORG_ID')) --7688372
8615: OR (NOT OE_GLOBALS.Equal(p_x_header_rec.ORDER_CATEGORY_CODE
8616: ,p_old_header_rec.ORDER_CATEGORY_CODE) AND g_attachment_rule_count_tab.exists('ORDER_CATEGORY_CODE')) --7688372
8617: THEN
8618:
8619: l_attr_attach_change := TRUE;
8621: END IF;
8622:
8623: IF l_attr_attach_change THEN
8624: OE_delayed_requests_Pvt.Log_Request
8625: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8626: p_entity_id => p_x_header_rec.header_id,
8627: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8628: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8629: p_requesting_entity_id => p_x_header_rec.header_id,
8623: IF l_attr_attach_change THEN
8624: OE_delayed_requests_Pvt.Log_Request
8625: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8626: p_entity_id => p_x_header_rec.header_id,
8627: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8628: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8629: p_requesting_entity_id => p_x_header_rec.header_id,
8630: x_return_status => l_return_status
8631: );
8624: OE_delayed_requests_Pvt.Log_Request
8625: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8626: p_entity_id => p_x_header_rec.header_id,
8627: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8628: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8629: p_requesting_entity_id => p_x_header_rec.header_id,
8630: x_return_status => l_return_status
8631: );
8632: END IF;
8635:
8636:
8637: -- QUOTING changes
8638: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F'
8639: AND NOT OE_GLOBALS.Equal(p_x_header_rec.order_type_id
8640: ,p_old_header_rec.order_type_id)
8641: THEN
8642:
8643: -- If the Order Type has changed, we need to sync up the
8641: THEN
8642:
8643: -- If the Order Type has changed, we need to sync up the
8644: -- MTL_SALES_ORDERS table.
8645: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
8646:
8647: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
8648: -- 3817802 : New api Get_Base_Order_Type is used to get order type based on base lang
8649: l_new_order_type := Get_Base_Order_Type(p_x_header_rec.order_type_id);
8670: END IF;
8671: --included for the create internal requisition Spares Management (Ikon) project mshenoy
8672: -- For all Internal Sales Orders (Source Document Type ID = 10 ) and Create ISO Operations
8673: -- log a Delayed Request for the create Internal Requisition
8674: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
8675: p_x_header_rec.Source_Document_Type_id = 10 AND
8676: p_x_header_rec.Source_Document_id is null AND
8677: p_x_header_rec.Orig_sys_document_ref is null THEN
8678: oe_debug_pub.add('log request to create internal Req for ISO');
8676: p_x_header_rec.Source_Document_id is null AND
8677: p_x_header_rec.Orig_sys_document_ref is null THEN
8678: oe_debug_pub.add('log request to create internal Req for ISO');
8679: OE_delayed_requests_Pvt.Log_Request
8680: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8681: p_entity_id => p_x_header_rec.header_id,
8682: p_request_type => OE_GLOBALS.G_CREATE_INTERNAL_REQ,
8683: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8684: p_requesting_entity_id => p_x_header_rec.header_id,
8678: oe_debug_pub.add('log request to create internal Req for ISO');
8679: OE_delayed_requests_Pvt.Log_Request
8680: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8681: p_entity_id => p_x_header_rec.header_id,
8682: p_request_type => OE_GLOBALS.G_CREATE_INTERNAL_REQ,
8683: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8684: p_requesting_entity_id => p_x_header_rec.header_id,
8685: x_return_status => l_return_status );
8686: oe_debug_pub.add(' Return Status log_request Delayed Requests for Int req ' || l_return_status);
8679: OE_delayed_requests_Pvt.Log_Request
8680: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8681: p_entity_id => p_x_header_rec.header_id,
8682: p_request_type => OE_GLOBALS.G_CREATE_INTERNAL_REQ,
8683: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8684: p_requesting_entity_id => p_x_header_rec.header_id,
8685: x_return_status => l_return_status );
8686: oe_debug_pub.add(' Return Status log_request Delayed Requests for Int req ' || l_return_status);
8687:
8690: -- Fix for bug1167537
8691: -- Clear the header record cached by defaulting APIs so that the
8692: -- default values on the line record are obtained from the
8693: -- updated header record
8694: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
8695: ONT_HEADER_Def_Util.Clear_HEADER_Cache;
8696: END IF;
8697:
8698: -- R12 CC encryption
8695: ONT_HEADER_Def_Util.Clear_HEADER_Cache;
8696: END IF;
8697:
8698: -- R12 CC encryption
8699: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8700: AND (p_x_header_rec.payment_type_code = 'CREDIT_CARD'
8701: OR p_old_header_rec.payment_type_code = 'CREDIT_CARD') THEN
8702:
8703: IF (NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,
8699: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8700: AND (p_x_header_rec.payment_type_code = 'CREDIT_CARD'
8701: OR p_old_header_rec.payment_type_code = 'CREDIT_CARD') THEN
8702:
8703: IF (NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,
8704: p_x_header_rec.credit_card_number,
8705: p_old_header_rec.cc_instrument_id,
8706: p_x_header_rec.cc_instrument_id))
8707: OR
8704: p_x_header_rec.credit_card_number,
8705: p_old_header_rec.cc_instrument_id,
8706: p_x_header_rec.cc_instrument_id))
8707: OR
8708: (p_x_header_rec.payment_type_code IS NULL AND NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_rec.credit_card_number,p_x_header_rec.credit_card_number,p_old_header_rec.cc_instrument_id, NULL))
8709: THEN
8710:
8711: l_changed_attribute := l_changed_attribute||',' ||'CREDIT_CARD_NUMBER';
8712:
8719: **/
8720:
8721: END IF;
8722:
8723: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_code,p_old_header_rec.credit_card_code)
8724: THEN
8725:
8726: l_changed_attribute := l_changed_attribute||',' ||'CREDIT_CARD_CODE';
8727:
8734: **/
8735:
8736: END IF;
8737:
8738: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_holder_name,p_old_header_rec.credit_card_holder_name)
8739: THEN
8740: l_changed_attribute := l_changed_attribute||',' ||'CREDIT_CARD_HOLDER_NAME';
8741:
8742: END IF;
8740: l_changed_attribute := l_changed_attribute||',' ||'CREDIT_CARD_HOLDER_NAME';
8741:
8742: END IF;
8743:
8744: IF NOT OE_GLOBALS.Equal(p_x_header_rec.credit_card_expiration_date,p_old_header_rec.credit_card_expiration_date)
8745: THEN
8746: l_changed_attribute := l_changed_attribute||',' ||'CREDIT_CARD_EXPIRATION_DATE';
8747:
8748: END IF;
8755: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
8756:
8757: --11.5.10 Versioning/Audit Trail updates
8758: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
8759: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
8760: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8763: OE_GLOBALS.G_REASON_CODE := p_x_header_rec.change_reason;
8756:
8757: --11.5.10 Versioning/Audit Trail updates
8758: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
8759: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
8760: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8763: OE_GLOBALS.G_REASON_CODE := p_x_header_rec.change_reason;
8764: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_rec.change_comments;
8757: --11.5.10 Versioning/Audit Trail updates
8758: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
8759: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
8760: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8763: OE_GLOBALS.G_REASON_CODE := p_x_header_rec.change_reason;
8764: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_rec.change_comments;
8765: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
8759: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
8760: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8763: OE_GLOBALS.G_REASON_CODE := p_x_header_rec.change_reason;
8764: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_rec.change_comments;
8765: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
8766: ELSE
8767: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
8760: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8763: OE_GLOBALS.G_REASON_CODE := p_x_header_rec.change_reason;
8764: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_rec.change_comments;
8765: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
8766: ELSE
8767: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
8768: if OE_GLOBALS.G_UI_FLAG THEN
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8763: OE_GLOBALS.G_REASON_CODE := p_x_header_rec.change_reason;
8764: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_rec.change_comments;
8765: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
8766: ELSE
8767: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
8768: if OE_GLOBALS.G_UI_FLAG THEN
8769: raise FND_API.G_EXC_ERROR;
8764: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_rec.change_comments;
8765: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
8766: ELSE
8767: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
8768: if OE_GLOBALS.G_UI_FLAG THEN
8769: raise FND_API.G_EXC_ERROR;
8770: end if;
8771: END IF;
8772: END IF;
8772: END IF;
8773:
8774: --log delayed request
8775: oe_debug_pub.add('log versioning request',1);
8776: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8777: p_entity_id => p_x_header_rec.header_id,
8778: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8779: p_requesting_entity_id => p_x_header_rec.header_id,
8780: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8774: --log delayed request
8775: oe_debug_pub.add('log versioning request',1);
8776: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8777: p_entity_id => p_x_header_rec.header_id,
8778: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8779: p_requesting_entity_id => p_x_header_rec.header_id,
8780: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8781: p_param1 => l_changed_attribute,
8782: x_return_status => l_return_status);
8776: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8777: p_entity_id => p_x_header_rec.header_id,
8778: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8779: p_requesting_entity_id => p_x_header_rec.header_id,
8780: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8781: p_param1 => l_changed_attribute,
8782: x_return_status => l_return_status);
8783: END IF;
8784:
8781: p_param1 => l_changed_attribute,
8782: x_return_status => l_return_status);
8783: END IF;
8784:
8785: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
8786: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
8787: OE_DEBUG_PUB.add('Call oe_order_chg_pvt to record Header Audit History',5);
8788:
8789: --11.5.10 Versioning/Audit Trail updates
8782: x_return_status => l_return_status);
8783: END IF;
8784:
8785: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
8786: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
8787: OE_DEBUG_PUB.add('Call oe_order_chg_pvt to record Header Audit History',5);
8788:
8789: --11.5.10 Versioning/Audit Trail updates
8790: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8787: OE_DEBUG_PUB.add('Call oe_order_chg_pvt to record Header Audit History',5);
8788:
8789: --11.5.10 Versioning/Audit Trail updates
8790: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8791: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8792: p_entity_id => p_x_header_rec.header_id,
8793: p_hist_type_code => 'UPDATE');
8794: --log delayed request
8795: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8791: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8792: p_entity_id => p_x_header_rec.header_id,
8793: p_hist_type_code => 'UPDATE');
8794: --log delayed request
8795: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8796: p_entity_id => p_x_header_rec.header_id,
8797: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8798: p_requesting_entity_id => p_x_header_rec.header_id,
8799: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8793: p_hist_type_code => 'UPDATE');
8794: --log delayed request
8795: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8796: p_entity_id => p_x_header_rec.header_id,
8797: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8798: p_requesting_entity_id => p_x_header_rec.header_id,
8799: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8800: p_param1 => l_changed_attribute,
8801: x_return_status => l_return_status);
8795: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8796: p_entity_id => p_x_header_rec.header_id,
8797: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8798: p_requesting_entity_id => p_x_header_rec.header_id,
8799: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8800: p_param1 => l_changed_attribute,
8801: x_return_status => l_return_status);
8802: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
8803: ELSE
8798: p_requesting_entity_id => p_x_header_rec.header_id,
8799: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
8800: p_param1 => l_changed_attribute,
8801: x_return_status => l_return_status);
8802: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
8803: ELSE
8804: OE_CHG_ORDER_PVT.RecordHeaderHist
8805: ( p_header_id => p_x_header_rec.header_id,
8806: p_header_rec => null,
8824: END IF;
8825:
8826: -- QUOTING changes
8827: -- Initialize flow status to DRAFT or ENTERED dependening on transaction phase
8828: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
8829:
8830: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
8831: /*
8832: ** Fix Bug # 3484862: iStore will be sending flow status as WORKING
8848: --Log request for deletes AND for update of currency
8849:
8850: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
8851: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
8852: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
8853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8854: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
8855: ,p_old_header_rec.transactional_curr_code)))
8856: THEN
8849:
8850: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
8851: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
8852: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
8853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8854: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
8855: ,p_old_header_rec.transactional_curr_code)))
8856: THEN
8857: Blkt_Req_For_Curr_Upd_And_Del(p_x_header_rec,p_old_header_rec);
8850: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
8851: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
8852: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
8853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8854: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
8855: ,p_old_header_rec.transactional_curr_code)))
8856: THEN
8857: Blkt_Req_For_Curr_Upd_And_Del(p_x_header_rec,p_old_header_rec);
8858: END IF;
8896: l_return_status VARCHAR2(30);
8897: l_msg_count NUMBER;
8898: l_msg_data VARCHAR2(2000);
8899:
8900: l_control_rec OE_GLOBALS.Control_Rec_Type;
8901: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8902: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8903: l_recursion_mode VARCHAR2(1);
8904: l_operation VARCHAR2(30);
8933: -- later as holds should be applied only to orders in fulfillment phase.
8934:
8935: --Fix bug 1649402
8936: OE_DELAYED_REQUESTS_PVT.Process_Request_for_ReqType
8937: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
8938: ,p_delete => FND_API.G_TRUE
8939: ,x_return_status=> l_return_status
8940: );
8941: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8948: -- later as mtl_sales_order records should be created only for
8949: -- orders in fulfillment phase.
8950:
8951: -- QUOTING changes
8952: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
8953: OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
8954: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transaction_phase_code,
8955: p_old_header_rec.transaction_phase_code)
8956: )
8950:
8951: -- QUOTING changes
8952: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
8953: OR (OE_Quote_Util.G_COMPLETE_NEG = 'Y'
8954: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transaction_phase_code,
8955: p_old_header_rec.transaction_phase_code)
8956: )
8957: THEN
8958:
8967: /*ER#7479609
8968: oe_debug_pub.add('Before calling eval_post_write_header in HEADER Post Write',1);
8969:
8970: OE_HOLDS_PUB.eval_post_write_header
8971: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8972: ,p_entity_id => p_x_header_rec.header_id
8973: ,p_hold_entity_code => 'C'
8974: ,p_hold_entity_id => p_x_header_rec.sold_to_org_id
8975: ,x_return_status => l_return_status
8991: if l_debug_level > 0 then
8992: oe_debug_pub.add('Call evaluate_holds_post_write for CREATE');
8993: end if;
8994: OE_Holds_PUB.evaluate_holds_post_write
8995: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8996: ,p_entity_id => p_x_header_rec.header_id
8997: ,x_msg_count => l_msg_count
8998: ,x_msg_data => l_msg_data
8999: ,x_return_status => l_return_status
9046: THEN
9047: l_operation := p_x_header_rec.operation;
9048: p_x_header_rec := OE_Order_Cache.g_header_rec;
9049: p_x_header_rec.operation := l_operation;
9050: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
9051: END IF;
9052:
9053: END IF; -- END for check if CREATE operation
9054: -- QUOTING changes END
9054: -- QUOTING changes END
9055:
9056: -- Close the order if its a complet cancellation at the line and
9057: -- is indeed a cancellation (by constraints)
9058: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
9059: IF oe_sales_can_util.g_order_cancel AND
9060: p_x_header_rec.cancelled_flag = 'Y' AND -- (p_old_header_rec.cancelled_flag <> 'Y') --7142748
9061: p_x_header_rec.cancelled_flag <> NVL(p_old_header_rec.cancelled_flag,'N') THEN -- Bug 9241924
9062: -- Bug 1895144: set recursion mode so that close does
9061: p_x_header_rec.cancelled_flag <> NVL(p_old_header_rec.cancelled_flag,'N') THEN -- Bug 9241924
9062: -- Bug 1895144: set recursion mode so that close does
9063: -- not execute any delayed requests
9064: BEGIN
9065: l_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
9066: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
9067:
9068: -- Log a request to cancel the workflow.
9069: /*
9062: -- Bug 1895144: set recursion mode so that close does
9063: -- not execute any delayed requests
9064: BEGIN
9065: l_recursion_mode := OE_GLOBALS.G_RECURSION_MODE;
9066: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
9067:
9068: -- Log a request to cancel the workflow.
9069: /*
9070: -- commented to take care of P1 issues in configuration
9069: /*
9070: -- commented to take care of P1 issues in configuration
9071:
9072: OE_delayed_requests_Pvt.log_request
9073: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9074: p_entity_id => p_x_header_rec.header_id,
9075: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9076: p_requesting_entity_id => p_x_header_rec.header_id,
9077: p_request_type => OE_GLOBALS.G_CANCEL_WF,
9071:
9072: OE_delayed_requests_Pvt.log_request
9073: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9074: p_entity_id => p_x_header_rec.header_id,
9075: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9076: p_requesting_entity_id => p_x_header_rec.header_id,
9077: p_request_type => OE_GLOBALS.G_CANCEL_WF,
9078: p_param1 => OE_GLOBALS.G_ENTITY_HEADER,
9079: x_return_status => l_return_status);
9073: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9074: p_entity_id => p_x_header_rec.header_id,
9075: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9076: p_requesting_entity_id => p_x_header_rec.header_id,
9077: p_request_type => OE_GLOBALS.G_CANCEL_WF,
9078: p_param1 => OE_GLOBALS.G_ENTITY_HEADER,
9079: x_return_status => l_return_status);
9080: */
9081:
9074: p_entity_id => p_x_header_rec.header_id,
9075: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9076: p_requesting_entity_id => p_x_header_rec.header_id,
9077: p_request_type => OE_GLOBALS.G_CANCEL_WF,
9078: p_param1 => OE_GLOBALS.G_ENTITY_HEADER,
9079: x_return_status => l_return_status);
9080: */
9081:
9082: -- Commented the code to move the logic to delayed request
9080: */
9081:
9082: -- Commented the code to move the logic to delayed request
9083: -- Uncommented to take care of P1 configuration issues
9084: wf_engine.handleerror(OE_Globals.G_WFI_HDR
9085: ,to_char(p_x_header_rec.header_id)
9086: ,'CLOSE_HEADER',
9087: 'RETRY','CANCEL');
9088:
9085: ,to_char(p_x_header_rec.header_id)
9086: ,'CLOSE_HEADER',
9087: 'RETRY','CANCEL');
9088:
9089: -- OE_GLOBALS.G_RECURSION_MODE := l_recursion_mode;
9090: -- BUG 2013611 - Increment promotional balance in response to cancellation
9091: oe_debug_pub.add('log request to Reverse_Limits for CANCEL in HEADER Post Write',1);
9092: OE_delayed_requests_Pvt.log_request(
9093: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9089: -- OE_GLOBALS.G_RECURSION_MODE := l_recursion_mode;
9090: -- BUG 2013611 - Increment promotional balance in response to cancellation
9091: oe_debug_pub.add('log request to Reverse_Limits for CANCEL in HEADER Post Write',1);
9092: OE_delayed_requests_Pvt.log_request(
9093: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9094: p_entity_id => p_x_header_rec.header_id,
9095: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9096: p_requesting_entity_id => p_x_header_rec.header_id,
9097: p_request_unique_key1 => 'HEADER',
9091: oe_debug_pub.add('log request to Reverse_Limits for CANCEL in HEADER Post Write',1);
9092: OE_delayed_requests_Pvt.log_request(
9093: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9094: p_entity_id => p_x_header_rec.header_id,
9095: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9096: p_requesting_entity_id => p_x_header_rec.header_id,
9097: p_request_unique_key1 => 'HEADER',
9098: p_param1 => 'CANCEL',
9099: p_param2 => p_x_header_rec.price_request_code,
9100: p_param3 => NULL,
9101: p_param4 => NULL,
9102: p_param5 => NULL,
9103: p_param6 => NULL,
9104: p_request_type => OE_GLOBALS.G_REVERSE_LIMITS,
9105: x_return_status => l_return_status);
9106: oe_debug_pub.add('Request to Reverse_Limits in HEADER Post Write is done',1);
9107: -- BUG 2013611 End
9108: EXCEPTION
9106: oe_debug_pub.add('Request to Reverse_Limits in HEADER Post Write is done',1);
9107: -- BUG 2013611 End
9108: EXCEPTION
9109: WHEN OTHERS THEN
9110: -- OE_GLOBALS.G_RECURSION_MODE := l_recursion_mode;
9111: RAISE;
9112: END;
9113: END IF;
9114: END IF;
9118: ----------------------------------------------------------------
9119: -- Update the customer on the order lines if changed on the
9120: -- order header
9121: ----------------------------------------------------------------
9122: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9123: AND NOT OE_GLOBALS.EQUAL( p_x_header_rec.sold_to_org_id,
9124: p_old_header_rec.sold_to_org_id )
9125: THEN
9126:
9119: -- Update the customer on the order lines if changed on the
9120: -- order header
9121: ----------------------------------------------------------------
9122: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9123: AND NOT OE_GLOBALS.EQUAL( p_x_header_rec.sold_to_org_id,
9124: p_old_header_rec.sold_to_org_id )
9125: THEN
9126:
9127: OE_Line_Util.Query_Rows
9137: oe_debug_pub.ADD('14763723 Rasing the XML Event for Header before line processing');
9138: END IF;
9139:
9140: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
9141: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
9142: ,p_delete => FND_API.G_TRUE
9143: ,x_return_status => l_return_status
9144: );
9145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9153: FOR I IN 1..l_line_tbl.COUNT LOOP
9154: -- IF condition added for bug 5471580
9155: IF nvl(l_line_tbl(I).cancelled_flag, 'N') = 'N' THEN
9156: l_line_tbl(I).sold_to_org_id := p_x_header_rec.sold_to_org_id;
9157: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
9158: ELSE
9159: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
9160: END IF;
9161: END LOOP;
9155: IF nvl(l_line_tbl(I).cancelled_flag, 'N') = 'N' THEN
9156: l_line_tbl(I).sold_to_org_id := p_x_header_rec.sold_to_org_id;
9157: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_UPDATE;
9158: ELSE
9159: l_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
9160: END IF;
9161: END LOOP;
9162:
9163: l_control_rec.controlled_operation := TRUE;
9168: l_control_rec.validate_entity := TRUE;
9169: l_control_rec.write_to_db := TRUE;
9170: l_control_rec.process := FALSE;
9171:
9172: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
9173: -- SAVEPOINT added for Bug 12759791
9174: SAVEPOINT LINES_IN_HPOST_WRITE ;
9175: OE_HEADER_UTIL.g_rollback_done := 'N';
9176:
9181: , p_x_old_line_tbl => l_old_line_tbl
9182: , x_return_status => l_return_status
9183: );
9184:
9185: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
9186:
9187: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9188: ROLLBACK TO SAVEPOINT LINES_IN_HPOST_WRITE; -- Bug 12759791
9189: OE_HEADER_UTIL.g_rollback_done := 'Y'; -- Bug 12759791
9206: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9208: END IF;
9209: */
9210: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
9211:
9212: END IF;
9213:
9214: --For bug 3563983. Commented this code and moved this logic to pre-write process.
9213:
9214: --For bug 3563983. Commented this code and moved this logic to pre-write process.
9215: --Line data will not be available for delete operation and this stage.
9216: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
9217: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9218: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
9219: ,p_old_header_rec.transactional_curr_code)
9220: -- QUOTING changes
9221: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
9214: --For bug 3563983. Commented this code and moved this logic to pre-write process.
9215: --Line data will not be available for delete operation and this stage.
9216: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
9217: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9218: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
9219: ,p_old_header_rec.transactional_curr_code)
9220: -- QUOTING changes
9221: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
9222: THEN
9225:
9226: END IF;*/
9227:
9228: -- QUOTING changes
9229: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9230: AND p_x_header_rec.transaction_phase_code = 'N'
9231: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.expiration_date
9232: ,p_old_header_rec.expiration_date)
9233: THEN
9227:
9228: -- QUOTING changes
9229: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9230: AND p_x_header_rec.transaction_phase_code = 'N'
9231: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.expiration_date
9232: ,p_old_header_rec.expiration_date)
9233: THEN
9234:
9235: -- Call WF API to re-set expiration date timer
9249: -- Sales Contract changes.
9250: -- Instantiate the contract template for the sales order for create
9251: -- operation.
9252:
9253: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
9254: OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' AND
9255: -- Do not instantiate for copied orders
9256: nvl(p_x_header_rec.source_document_type_id,-1) <> 2 AND
9257: (p_x_header_rec.contract_template_id IS NOT NULL OR
9300: --If Bill to site is changed, then the payment record would
9301: --be deleted through the delayed request. So not calling
9302: --the process order if bill to site has changed.
9303: --bug 4885313
9304: IF NOT OE_GLOBALS.Equal(p_x_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id)
9305: THEN
9306: --If the user has modified the bill to site and has entered a new
9307: --credit card before saving the record, then the global flag need
9308: --to be set to Y so that the current trxn extension id would be
9308: --to be set to Y so that the current trxn extension id would be
9309: --deleted and a new one created (as the context has changed).
9310: oe_debug_pub.add('Old invoice to'||p_x_header_rec.invoice_to_org_id);
9311: oe_debug_pub.add('New invoice to'||p_old_header_rec.invoice_to_org_id);
9312: IF NOT OE_GLOBALS.Equal(p_old_header_rec.invoice_to_org_id,FND_API.G_MISS_NUM)
9313: AND p_old_header_rec.invoice_to_org_id IS NOT NULL AND
9314: p_x_header_rec.payment_type_code = 'CREDIT_CARD' THEN
9315: OE_Payment_Trxn_Util.g_old_bill_to_site := p_old_header_rec.invoice_to_org_id;
9316: END IF;
9325: --Moreover, when the old payment type code is credit card, then need
9326: --to delete the trxn extension id created for this creditcard
9327: --When the old payment type is not null and the new one is null then
9328: --need to delete the payment record from oe_payments.
9329: IF( ( OE_GLOBALS.Equal(p_x_header_rec.payment_type_code, 'CREDIT_CARD') AND
9330: p_x_header_rec.credit_card_number is not null
9331: )
9332: OR (
9333: OE_GLOBALS.Equal(p_old_header_rec.payment_type_code,'CREDIT_CARD')
9329: IF( ( OE_GLOBALS.Equal(p_x_header_rec.payment_type_code, 'CREDIT_CARD') AND
9330: p_x_header_rec.credit_card_number is not null
9331: )
9332: OR (
9333: OE_GLOBALS.Equal(p_old_header_rec.payment_type_code,'CREDIT_CARD')
9334: )
9335: OR ( p_old_header_rec.payment_type_code IS NOT NULL AND
9336: p_x_header_rec.payment_type_code IS NULL
9337: ))
9339: ( --as the payment record would be inserted from oe_header_payment_util package.
9340: nvl(p_x_header_rec.source_document_type_id,-99) <> 2 OR
9341: ( --To create or update credit cards on copied orders
9342: nvl(p_x_header_rec.source_document_type_id,-99)=2 AND
9343: p_x_header_rec.operation=OE_GLOBALS.G_OPR_UPDATE
9344: )
9345: )
9346: AND p_x_header_rec.operation <> OE_GLOBALS.G_OPR_DELETE --10113279
9347:
9342: nvl(p_x_header_rec.source_document_type_id,-99)=2 AND
9343: p_x_header_rec.operation=OE_GLOBALS.G_OPR_UPDATE
9344: )
9345: )
9346: AND p_x_header_rec.operation <> OE_GLOBALS.G_OPR_DELETE --10113279
9347:
9348: THEN
9349: BEGIN
9350: --For update operation, payment number needs to be set in
9394: l_x_Header_Payment_tbl(1).check_number := p_x_header_rec.check_number;
9395: oe_debug_pub.add('Old payment type'||l_old_payment_type_code);
9396: oe_debug_pub.add('New payment type'||p_x_header_rec.payment_type_code);
9397: oe_debug_pub.add('Header_id'||p_x_header_rec.header_id);
9398: /*IF NOT OE_GLOBALS.Equal(l_old_payment_type_code,p_x_header_rec.payment_type_code) THEN
9399: oe_debug_pub.add('ksurendr: Receipt method id in uhdrb post write'||l_x_Header_Payment_tbl(1).receipt_method_id);
9400: l_x_Header_Payment_tbl(1).receipt_method_id := FND_API.G_MISS_NUM;
9401: END IF;*/
9402:
9406: --is null, then the payment record has been cleared by the user from the
9407: --Others tab and hence it is required to delete this record from oe_payments.
9408: IF l_old_payment_type_code IS NOT NULL
9409: AND p_x_header_rec.payment_type_code IS NULL THEN
9410: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
9411: -- bug 5035651
9412: ELSIF nvl(p_x_header_rec.cancelled_flag, 'N') <> 'Y' THEN
9413: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
9414: ELSE
9409: AND p_x_header_rec.payment_type_code IS NULL THEN
9410: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;
9411: -- bug 5035651
9412: ELSIF nvl(p_x_header_rec.cancelled_flag, 'N') <> 'Y' THEN
9413: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
9414: ELSE
9415: l_x_Header_Payment_tbl(1).operation := NULL;
9416: END IF;
9417:
9416: END IF;
9417:
9418: /*
9419: ELSE
9420: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
9421: END IF;
9422: */
9423: ELSE
9424: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
9420: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
9421: END IF;
9422: */
9423: ELSE
9424: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
9425:
9426: --bug 5258767
9427: --Only credit card payment types have the pre-payment records inserted
9428: --from this procedure. The other payment types are taken care by the
9426: --bug 5258767
9427: --Only credit card payment types have the pre-payment records inserted
9428: --from this procedure. The other payment types are taken care by the
9429: --procedure Update_Hdr_Payment in Oe_Prepayment_Pvt.
9430: IF OE_GLOBALS.Equal(p_x_header_rec.payment_type_code, 'CREDIT_CARD') THEN
9431: --Need to check if the payment term present in the header
9432: --has the prepayment check box checked so as to insert the
9433: --prepayment record as well if the other conditions are
9434: --satisfied.
9541: oe_debug_pub.add('Inside prepayment type'||l_old_payment_type_code);
9542: oe_debug_pub.add('New prepayment type'||p_x_header_rec.payment_type_code);
9543: oe_debug_pub.add('Header_id'||p_x_header_rec.header_id);
9544: END IF;
9545: l_x_Header_Payment_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
9546: END IF;
9547: END IF;
9548: END IF;
9549: --bug 5258767
9797: FOR c IN lines LOOP
9798:
9799: -- Request to decrement amounts based on old currency code
9800: OE_Delayed_Requests_Pvt.Log_Request
9801: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9802: ,p_entity_id => c.line_id
9803: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9804: ,p_requesting_entity_id => p_header_rec.header_id
9805: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
9799: -- Request to decrement amounts based on old currency code
9800: OE_Delayed_Requests_Pvt.Log_Request
9801: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9802: ,p_entity_id => c.line_id
9803: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9804: ,p_requesting_entity_id => p_header_rec.header_id
9805: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
9806: -- Old values
9807: ,p_param1 => c.blanket_number
9801: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9802: ,p_entity_id => c.line_id
9803: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9804: ,p_requesting_entity_id => p_header_rec.header_id
9805: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
9806: -- Old values
9807: ,p_param1 => c.blanket_number
9808: ,p_param2 => c.blanket_line_number
9809: ,p_param3 => c.ordered_quantity
9827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9828: END IF;
9829:
9830: --For bug 3563983
9831: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9832: THEN
9833: -- Request to increment amounts based on new currency code
9834: OE_Delayed_Requests_Pvt.Log_Request
9835: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9831: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9832: THEN
9833: -- Request to increment amounts based on new currency code
9834: OE_Delayed_Requests_Pvt.Log_Request
9835: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9836: ,p_entity_id => c.line_id
9837: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9838: ,p_requesting_entity_id => p_header_rec.header_id
9839: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
9833: -- Request to increment amounts based on new currency code
9834: OE_Delayed_Requests_Pvt.Log_Request
9835: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9836: ,p_entity_id => c.line_id
9837: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9838: ,p_requesting_entity_id => p_header_rec.header_id
9839: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
9840: -- Old values
9841: ,p_param1 => null
9835: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9836: ,p_entity_id => c.line_id
9837: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9838: ,p_requesting_entity_id => p_header_rec.header_id
9839: ,p_request_type => OE_GLOBALS.G_PROCESS_RELEASE
9840: -- Old values
9841: ,p_param1 => null
9842: ,p_param2 => null
9843: ,p_param3 => 0
9868: -- within release min/max limits set on blanket line
9869: IF c.line_set_id IS NOT NULL THEN
9870:
9871: OE_Delayed_Requests_Pvt.Log_Request
9872: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9873: ,p_entity_id => c.line_set_id
9874: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
9875: ,p_requesting_entity_id => c.line_id
9876: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
9870:
9871: OE_Delayed_Requests_Pvt.Log_Request
9872: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9873: ,p_entity_id => c.line_set_id
9874: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
9875: ,p_requesting_entity_id => c.line_id
9876: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
9877: ,p_request_unique_key1 => c.blanket_number
9878: ,p_request_unique_key2 => c.blanket_line_number
9872: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9873: ,p_entity_id => c.line_set_id
9874: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
9875: ,p_requesting_entity_id => c.line_id
9876: ,p_request_type => OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS
9877: ,p_request_unique_key1 => c.blanket_number
9878: ,p_request_unique_key2 => c.blanket_line_number
9879: ,p_param1 =>
9880: p_header_rec.transactional_curr_code
9998: ,p_source_document_line_id => null
9999: ,p_order_source_id => l_order_source_id
10000: ,p_source_document_type_id => l_source_document_type_id);
10001:
10002: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
10003: p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
10004:
10005: IF l_debug_level > 0 THEN
10006: oe_debug_pub.add('Selecting sold_to_org_id in case of update');