[Home] [Help]
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_PVT';
7: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8233604
8:
9: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;
10: G_MAX_REQUESTS NUMBER := 10000;
11:
229: oe_debug_pub.add('Entering Procedure Process_Request_Pvt ',1);
230: oe_debug_pub.add('Request processed '||G_Delayed_Requests(p_request_ind).processed);
231: END IF;
232:
233: IF NOT oe_globals.g_call_process_req THEN --9354229
234: IF l_debug_level > 0 THEN
235: oe_debug_pub.add( 'EXIT Procedure Process_Request_Pvt' , 1 ) ;
236: END IF;
237: RETURN;
260: END IF;
261: G_Delayed_Requests(p_request_ind).processed := 'I';
262:
263: IF l_debug_level > 0 THEN
264: IF OE_GLOBALS.G_CASCADING_REQUEST_LOGGED THEN
265: oe_debug_pub.add('cascade flag set to true');
266: ELSE
267: oe_debug_pub.add('cascade flag set to false');
268: END IF;
278: -- back to the header for credit card payments.
279: -- 3) Apply Automatic Attachments: never results in an update back to order/lines.
280: -- NOTE: All other delayed requests also need to be evaluated so
281: -- that cascade flag is set in the request and not here.
282: IF OE_GLOBALS.G_PROCESS_OBJECTS_FLAG = TRUE THEN
283:
284: IF l_Request_type NOT IN ('RECORD_HISTORY'
285: ,OE_GLOBALS.G_PRICE_ORDER
286: ,OE_GLOBALS.G_PRICE_ADJ
281: -- that cascade flag is set in the request and not here.
282: IF OE_GLOBALS.G_PROCESS_OBJECTS_FLAG = TRUE THEN
283:
284: IF l_Request_type NOT IN ('RECORD_HISTORY'
285: ,OE_GLOBALS.G_PRICE_ORDER
286: ,OE_GLOBALS.G_PRICE_ADJ
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
282: IF OE_GLOBALS.G_PROCESS_OBJECTS_FLAG = TRUE THEN
283:
284: IF l_Request_type NOT IN ('RECORD_HISTORY'
285: ,OE_GLOBALS.G_PRICE_ORDER
286: ,OE_GLOBALS.G_PRICE_ADJ
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
283:
284: IF l_Request_type NOT IN ('RECORD_HISTORY'
285: ,OE_GLOBALS.G_PRICE_ORDER
286: ,OE_GLOBALS.G_PRICE_ADJ
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
291: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
284: IF l_Request_type NOT IN ('RECORD_HISTORY'
285: ,OE_GLOBALS.G_PRICE_ORDER
286: ,OE_GLOBALS.G_PRICE_ADJ
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
291: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
292: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
285: ,OE_GLOBALS.G_PRICE_ORDER
286: ,OE_GLOBALS.G_PRICE_ADJ
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
291: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
292: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
293: THEN
286: ,OE_GLOBALS.G_PRICE_ADJ
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
291: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
292: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
293: THEN
294: IF l_debug_level > 0 THEN
287: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
291: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
292: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
293: THEN
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add('****** process_obj=>delayed req execution ****', 1);
288: ,OE_GLOBALS.G_VERIFY_PAYMENT
289: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
290: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
291: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
292: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
293: THEN
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add('****** process_obj=>delayed req execution ****', 1);
296: END IF;
293: THEN
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add('****** process_obj=>delayed req execution ****', 1);
296: END IF;
297: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
298: END IF;
299:
300: END IF;
301:
301:
302:
303: IF l_Request_type = 'RECORD_HISTORY' THEN
304: NULL;
305: ELSIF l_request_type = OE_GLOBALS.G_CHECK_PERCENTAGE
306: THEN
307:
308: OE_DELAYED_REQUESTS_UTIL.check_percentage
309: (p_request_rec => l_request_rec,
308: OE_DELAYED_REQUESTS_UTIL.check_percentage
309: (p_request_rec => l_request_rec,
310: x_return_status => l_return_status);
311:
312: ELSIF l_request_type = OE_GLOBALS.G_CHECK_DUPLICATE THEN
313:
314: OE_DELAYED_REQUESTS_UTIL.check_duplicate
315: (p_request_rec => l_request_rec,
316: x_return_status => l_return_status);
314: OE_DELAYED_REQUESTS_UTIL.check_duplicate
315: (p_request_rec => l_request_rec,
316: x_return_status => l_return_status);
317:
318: ELSIF l_request_type = OE_GLOBALS.G_CANCEL_WF THEN
319:
320: OE_SALES_CAN_UTIL.Cancel_Wf
321: (x_request_rec => l_request_rec,
322: x_return_status => l_return_status);
320: OE_SALES_CAN_UTIL.Cancel_Wf
321: (x_request_rec => l_request_rec,
322: x_return_status => l_return_status);
323:
324: ELSIF l_request_type = OE_GLOBALS.G_CHECK_FIXED_PRICE
325: THEN
326:
327: OE_DELAYED_REQUESTS_UTIL.check_fixed_price
328: (p_request_rec => l_request_rec,
327: OE_DELAYED_REQUESTS_UTIL.check_fixed_price
328: (p_request_rec => l_request_rec,
329: x_return_status => l_return_status);
330:
331: ELSIF l_request_type = OE_GLOBALS.G_PRICE_ADJ THEN
332: IF l_debug_level > 0 THEN
333: Oe_Debug_pub.Add('Before Executing Delayed request Price Adjustment for '||l_request_rec.entity_id);
334: END IF;
335: /* 1905650
334: END IF;
335: /* 1905650
336: G_PRICE_ADJ request is now logged against LINE entity
337: */
338: If l_entity_code = OE_GLOBALS.G_ENTITY_LINE Then
339:
340: oe_order_adj_pvt.Price_Adjustments(
341: X_Return_Status => l_Return_Status
342: ,p_Header_id => Null
410: END IF;
411:
412: IF l_current_event >= l_tax_calculation_event_code THEN
413:
414: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN
415: OE_delayed_requests_Pvt.log_request(
416: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
417: p_entity_id => l_request_rec.entity_id,
418: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
412: IF l_current_event >= l_tax_calculation_event_code THEN
413:
414: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN
415: OE_delayed_requests_Pvt.log_request(
416: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
417: p_entity_id => l_request_rec.entity_id,
418: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
419: p_requesting_entity_id => l_request_rec.entity_id,
420: p_request_type => OE_GLOBALS.g_tax_line,
414: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN
415: OE_delayed_requests_Pvt.log_request(
416: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
417: p_entity_id => l_request_rec.entity_id,
418: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
419: p_requesting_entity_id => l_request_rec.entity_id,
420: p_request_type => OE_GLOBALS.g_tax_line,
421: x_return_status => l_return_status);
422: ELSE
416: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
417: p_entity_id => l_request_rec.entity_id,
418: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
419: p_requesting_entity_id => l_request_rec.entity_id,
420: p_request_type => OE_GLOBALS.g_tax_line,
421: x_return_status => l_return_status);
422: ELSE
423: OE_delayed_requests_Pvt.log_request(
424: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
420: p_request_type => OE_GLOBALS.g_tax_line,
421: x_return_status => l_return_status);
422: ELSE
423: OE_delayed_requests_Pvt.log_request(
424: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
425: p_entity_id => l_request_rec.entity_id,
426: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
427: p_requesting_entity_id => l_request_rec.entity_id,
428: p_request_type => OE_GLOBALS.g_tax_line,
422: ELSE
423: OE_delayed_requests_Pvt.log_request(
424: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
425: p_entity_id => l_request_rec.entity_id,
426: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
427: p_requesting_entity_id => l_request_rec.entity_id,
428: p_request_type => OE_GLOBALS.g_tax_line,
429: x_return_status => l_return_status);
430: END IF;
424: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
425: p_entity_id => l_request_rec.entity_id,
426: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
427: p_requesting_entity_id => l_request_rec.entity_id,
428: p_request_type => OE_GLOBALS.g_tax_line,
429: x_return_status => l_return_status);
430: END IF;
431:
432:
441: IF l_debug_level > 0 THEN
442: Oe_Debug_pub.Add('After Executing Delayed request Price Adj for '||l_request_rec.entity_id);
443: END IF;
444: ELSIF l_request_type =
445: OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL then
446: if l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT
447: OR l_entity_code = OE_GLOBALS.G_ENTITY_ALL then -- bug 5746190
448: OE_DELAYED_REQUESTS_UTIL.Validate_HSC_QUOTA_TOTAL
449: ( x_return_status =>l_return_status
442: Oe_Debug_pub.Add('After Executing Delayed request Price Adj for '||l_request_rec.entity_id);
443: END IF;
444: ELSIF l_request_type =
445: OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL then
446: if l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT
447: OR l_entity_code = OE_GLOBALS.G_ENTITY_ALL then -- bug 5746190
448: OE_DELAYED_REQUESTS_UTIL.Validate_HSC_QUOTA_TOTAL
449: ( x_return_status =>l_return_status
450: ,p_header_id =>to_number(l_request_rec.param1)
443: END IF;
444: ELSIF l_request_type =
445: OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL then
446: if l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT
447: OR l_entity_code = OE_GLOBALS.G_ENTITY_ALL then -- bug 5746190
448: OE_DELAYED_REQUESTS_UTIL.Validate_HSC_QUOTA_TOTAL
449: ( x_return_status =>l_return_status
450: ,p_header_id =>to_number(l_request_rec.param1)
451: );
451: );
452: end if;
453:
454: ELSIF l_request_type =
455: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
456: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
457: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
458: ( x_return_status =>l_return_status
459: ,p_line_id =>to_number(l_request_rec.param1)
452: end if;
453:
454: ELSIF l_request_type =
455: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
456: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
457: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
458: ( x_return_status =>l_return_status
459: ,p_line_id =>to_number(l_request_rec.param1)
460: );
460: );
461: end if;
462:
463: ELSIF l_request_type =
464: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
465: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
466: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
467: ( x_return_status =>l_return_status
468: ,p_line_id =>to_number(l_request_rec.param1)
461: end if;
462:
463: ELSIF l_request_type =
464: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
465: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
466: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
467: ( x_return_status =>l_return_status
468: ,p_line_id =>to_number(l_request_rec.param1)
469: );
469: );
470: end if;
471:
472: ELSIF l_request_type =
473: OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT then
474: IF l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT THEN
475: OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit
476: ( x_return_status =>l_return_status
477: ,p_request_rec =>l_request_rec
470: end if;
471:
472: ELSIF l_request_type =
473: OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT then
474: IF l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT THEN
475: OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit
476: ( x_return_status =>l_return_status
477: ,p_request_rec =>l_request_rec
478: );
478: );
479: end if;
480:
481:
482: ELSIF (l_request_type = OE_GLOBALS.G_CREATE_SETS) then
483: OE_DELAYED_REQUESTS_UTIL.Insert_Set
484: (p_request_rec => l_request_rec,
485: x_return_status => l_return_status);
486: ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
482: ELSIF (l_request_type = OE_GLOBALS.G_CREATE_SETS) then
483: OE_DELAYED_REQUESTS_UTIL.Insert_Set
484: (p_request_rec => l_request_rec,
485: x_return_status => l_return_status);
486: ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
487: IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
488: /* Commenting out nocopy per Rupal */
489:
490: null;
483: OE_DELAYED_REQUESTS_UTIL.Insert_Set
484: (p_request_rec => l_request_rec,
485: x_return_status => l_return_status);
486: ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
487: IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
488: /* Commenting out nocopy per Rupal */
489:
490: null;
491: /* OE_Process_Models.Insert_Into_Line_Sets
494: ,p_set_type => 'ALL'
495: ,x_return_status =>l_return_status
496: ); */
497: END IF;
498: ELSIF l_request_type = OE_GLOBALS.G_VALIDATE_LINE_SET then
499: oe_delayed_requests_util.validate_line_set(
500: p_line_set_id => l_request_rec.entity_id,
501: x_return_status => l_return_status);
502: ELSIF l_request_type =
499: oe_delayed_requests_util.validate_line_set(
500: p_line_set_id => l_request_rec.entity_id,
501: x_return_status => l_return_status);
502: ELSIF l_request_type =
503: OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP then
504: OE_DELAYED_REQUESTS_UTIL.DFLT_Hscredit_Primary_Srep
505: ( x_return_status =>l_return_status
506: ,p_header_id =>to_number(l_request_rec.param1)
507: ,p_salesrep_id =>to_number(l_request_rec.param2)
508: );
509:
510:
511: ELSIF l_request_type =
512: OE_GLOBALS.G_VERIFY_PAYMENT then
513: OE_DELAYED_REQUESTS_UTIL.Verify_Payment
514: ( x_return_status =>l_return_status
515: ,p_header_id => l_entity_id
516: );
515: ,p_header_id => l_entity_id
516: );
517:
518: ELSIF l_request_type =
519: OE_GLOBALS.G_INSERT_RMA then
520: OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_SCREDIT_ADJUSTMENT
521: ( x_return_status =>l_return_status
522: ,p_line_id => l_entity_id
523: );
526: ,p_line_id => l_entity_id
527: );
528: -- Do not call INSERT_RMA_LOT_SERIAL for system split.
529: -- Bug 4651421
530: IF NOT((l_request_rec.param1 = OE_GLOBALS.G_OPR_UPDATE and
531: nvl(l_request_rec.param2,'USER') = 'SYSTEM' and
532: NVL(l_request_rec.param3,'X') = 'SPLIT')
533: OR
534: (l_request_rec.param1 = OE_GLOBALS.G_OPR_CREATE AND
530: IF NOT((l_request_rec.param1 = OE_GLOBALS.G_OPR_UPDATE and
531: nvl(l_request_rec.param2,'USER') = 'SYSTEM' and
532: NVL(l_request_rec.param3,'X') = 'SPLIT')
533: OR
534: (l_request_rec.param1 = OE_GLOBALS.G_OPR_CREATE AND
535: l_request_rec.param4 IS NOT NULL AND
536: nvl(l_request_rec.param2, 'USER') = 'SYSTEM'))
537: THEN
538: OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_LOT_SERIAL
539: ( x_return_status =>l_return_status
540: ,p_line_id => l_entity_id
541: );
542: END IF;
543: ELSIF l_request_type = OE_GLOBALS.G_TAX_LINE then
544:
545: -- Renga - changed so that we call Process_Tax
546: IF (OE_GLOBALS.G_UI_FLAG)
547: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
542: END IF;
543: ELSIF l_request_type = OE_GLOBALS.G_TAX_LINE then
544:
545: -- Renga - changed so that we call Process_Tax
546: IF (OE_GLOBALS.G_UI_FLAG)
547: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
548:
549: l_entity_id_tbl(1).entity_id := l_entity_id;
550: -- l_entity_id_tbl(l_count).request_ind := 1;
575: ,x_return_status => l_return_status
576: );
577:
578: END IF; --TaxER
579: ELSIF l_request_type = OE_GLOBALS.G_SPLIT_HOLD then
580: OE_DELAYED_REQUESTS_UTIL.Split_hold
581: ( p_entity_code => l_request_rec.entity_code
582: ,p_entity_id => l_request_rec.entity_id
583: ,p_split_from_line_id => l_request_rec.param1
583: ,p_split_from_line_id => l_request_rec.param1
584: ,x_return_status => l_return_status
585: );
586: ELSIF l_request_type =
587: OE_GLOBALS.G_EVAL_HOLD_SOURCE then
588: OE_DELAYED_REQUESTS_UTIL.Eval_Hold_Source
589: ( x_return_status => l_return_status
590: ,p_entity_code => l_request_rec.entity_code
591: ,p_entity_id => l_request_rec.entity_id
593: ,p_hold_entity_id => l_request_rec.param2
594: );
595:
596: /* 1739574 */
597: ELSIF l_request_type = OE_GLOBALS.G_COMPLETE_ACTIVITY THEN
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.ADD('Calling wf_engine.CompleteActivityInternalName for '||l_request_rec.param1 || '/'||l_request_rec.param2||'/'||l_request_rec.param3 ||'/'||'/'||l_request_rec.param4, 3);
600: END IF;
601: BEGIN --15870313
609: IF l_debug_level > 0 THEN
610: oe_debug_pub.ADD('Returned from wf_engine.CompleteActivityInternalName ',3);
611: END IF;
612: -- Start of bug 10032407
613: ELSIF l_request_type = OE_GLOBALS.G_SKIP_ACTIVITY THEN
614: if l_debug_level > 0 then
615: oe_debug_pub.ADD('Calling wf_engine.CompleteActivityInternalName for '||l_request_rec.param1 || '/'||l_request_rec.param2||'/'||l_request_rec.param3 ||'/'||'/'||l_request_rec.param4, 3);
616: end if;
617: BEGIN
627: oe_debug_pub.ADD('Returned from wf_engine.handleerror ',3);
628: end if;
629: END;
630: -- End of bug 10032407
631: ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_SHIPPING THEN
632:
633: OE_Delayed_Requests_UTIL.Update_Shipping
634: ( p_update_shipping_tbl => g_delayed_requests
635: , p_line_id => l_request_rec.entity_id
636: , p_operation => l_request_rec.request_unique_key1
637: , x_return_status => l_return_status
638: );
639:
640: ELSIF l_request_rec.request_type = OE_GLOBALS.G_SHIP_CONFIRMATION THEN
641:
642: OE_Delayed_Requests_UTIL.Ship_Confirmation
643: ( p_ship_confirmation_tbl => g_delayed_requests
644: , p_line_id => l_request_rec.entity_id
646: , p_process_id => l_request_rec.param1
647: , x_return_status => l_return_status
648: );
649:
650: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRE_EXPLODED_KIT THEN
651:
652: /* Start DOO Pre Exploded Kit ER 9339742 */
653: /* Note: It should be ensured that this delayed request should be executed only
654: after all the lines in p_line_tbl input primer of the Process Order api are
691: -- For details on IR ISO CMS project, please refer to FOL >
692: -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
693:
694:
695: ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
696:
697: IF NVL(l_request_rec.param2,'N') = 'Y' THEN
698: IF l_debug_level > 0 THEN
699: oe_debug_pub.add('Requisition Header Cancellation is TRUE',5);
710: END IF;
711: l_cancel_order := FALSE;
712: END IF;
713:
714: IF l_request_rec.entity_code = OE_Globals.G_Entity_Header THEN
715: l_header_id := l_request_rec.entity_id;
716: l_line_id := NULL;
717: ELSIF l_request_rec.entity_code = OE_Globals.G_Entity_Line THEN
718: l_header_id := l_request_rec.request_unique_key1;
713:
714: IF l_request_rec.entity_code = OE_Globals.G_Entity_Header THEN
715: l_header_id := l_request_rec.entity_id;
716: l_line_id := NULL;
717: ELSIF l_request_rec.entity_code = OE_Globals.G_Entity_Line THEN
718: l_header_id := l_request_rec.request_unique_key1;
719: l_line_id := l_request_rec.entity_id;
720: END IF;
721:
738: /* IR ISO Change Management Ends */
739:
740:
741: ELSIF l_request_type =
742: OE_GLOBALS.G_CASCADE_CHANGES then
743: IF l_debug_level > 0 THEN
744: oe_debug_pub.add('Performing Delayed Req for Cascade Changes',1);
745: END IF;
746:
753: oe_debug_pub.add('done Delayed Req for Cascade Changes',1);
754: END IF;
755:
756: ELSIF l_request_type =
757: OE_GLOBALS.G_CHANGE_CONFIGURATION then
758:
759: oe_debug_pub.add('Performing Delayed Req for Change Config',1);
760:
761: OE_CONFIG_UTIL.CHANGE_CONFIGURATION
766: oe_debug_pub.add('Done Delayed Req for Change Config',1);
767: END IF;
768:
769: ELSIF l_request_type =
770: OE_GLOBALS.G_CREATE_RESERVATIONS then
771: OE_DELAYED_REQUESTS_UTIL.SPLIT_RESERVATIONS
772: ( p_reserved_line_id => l_request_rec.entity_id
773: , p_ordered_quantity => to_number(l_request_rec.param1)
774: , p_reserved_quantity => to_number(l_request_rec.param2)
775: , x_return_status => l_return_status
776: );
777:
778: ELSIF l_request_type =
779: OE_GLOBALS.G_COPY_CONFIGURATION then
780: OE_Config_Pvt.Copy_Config
781: ( p_top_model_line_id => l_request_rec.entity_id ,
782: p_config_hdr_id => l_request_rec.param1 ,
783: p_config_rev_nbr => l_request_rec.param2 ,
786: x_return_status => l_return_status
787: );
788:
789: ELSIF l_request_type =
790: OE_GLOBALS.G_COMPLETE_CONFIGURATION then
791: OE_DELAYED_REQUESTS_UTIL.COMPLETE_CONFIGURATION
792: ( p_top_model_line_id => l_request_rec.entity_id
793: , x_return_status => l_return_status
794: );
794: );
795: -- No Processing here. The processing will be done in
796: -- Process_Delayed_Requests at the Commit Time.
797:
798: ELSIF l_request_type = OE_GLOBALS.G_DROPSHIP_CMS THEN
799: RETURN;
800:
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add('upd: processed with cfg val', 3);
809: END IF;
810: RETURN;
808: oe_debug_pub.add('upd: processed with cfg val', 3);
809: END IF;
810: RETURN;
811:
812: ELSIF l_request_type = OE_GLOBALS.G_DELETE_OPTION THEN
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add('del: processed with cfg val', 3);
815: END IF;
816: RETURN;
815: END IF;
816: RETURN;
817:
818: ELSIF l_request_type =
819: OE_GLOBALS.G_VALIDATE_CONFIGURATION
820: THEN
821:
822: -- Get the delayed requests logged for deletions and updatations
823: -- which needs to be passed to validate_configuration.
828:
829: WHILE K is not null -- while loop safe that tbl.first to last
830: LOOP
831:
832: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
833: G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
834: THEN
835:
836: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
829: WHILE K is not null -- while loop safe that tbl.first to last
830: LOOP
831:
832: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
833: G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
834: THEN
835:
836: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
837: AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
832: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
833: G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
834: THEN
835:
836: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
837: AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
838: THEN
839: l_d_index := l_d_index + 1;
840: l_deleted_options_tbl(l_d_index) :=
840: l_deleted_options_tbl(l_d_index) :=
841: g_delayed_requests(K);
842: END IF;
843:
844: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
845: AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
846: THEN
847: l_u_index := l_u_index + 1;
848: l_updated_options_tbl(l_u_index) :=
874:
875: WHILE K is not null
876: LOOP
877: IF (G_Delayed_Requests(K).request_type =
878: OE_GLOBALS.G_DELETE_OPTION OR
879: G_Delayed_Requests(K).request_type =
880: OE_GLOBALS.G_UPDATE_OPTION ) AND
881: G_Delayed_Requests(K).param1 = l_request_rec.entity_id
882: THEN
876: LOOP
877: IF (G_Delayed_Requests(K).request_type =
878: OE_GLOBALS.G_DELETE_OPTION OR
879: G_Delayed_Requests(K).request_type =
880: OE_GLOBALS.G_UPDATE_OPTION ) AND
881: G_Delayed_Requests(K).param1 = l_request_rec.entity_id
882: THEN
883: G_Delayed_Requests.delete(K);
884: END IF;
888: END LOOP;
889: END IF;
890:
891:
892: ELSIF l_request_type = OE_GLOBALS.G_CTO_CHANGE THEN
893: IF l_debug_level > 0 THEN
894: oe_debug_pub.add('cto: processed with notification', 3);
895: END IF;
896: RETURN;
895: END IF;
896: RETURN;
897:
898: ELSIF l_request_type =
899: OE_GLOBALS.G_CTO_NOTIFICATION then
900: -- loop over and call cto
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('cto notification excecution', 2);
903: END IF;
906:
907: WHILE K is not null
908: LOOP
909: IF G_Delayed_Requests(K).request_type =
910: OE_GLOBALS.G_CTO_CHANGE AND
911: G_Delayed_Requests(K).param3 = l_request_rec.entity_id
912: THEN
913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add(K || 'cto change req ', 3);
1013:
1014: WHILE K is not null
1015: LOOP
1016: IF G_Delayed_Requests(K).request_type =
1017: OE_GLOBALS.G_CTO_CHANGE AND
1018: G_Delayed_Requests(K).param3 = l_request_rec.entity_id
1019: THEN
1020: G_Delayed_Requests.delete(K);
1021: END IF;
1024:
1025: END LOOP;
1026: END IF;
1027: ELSIF l_request_type =
1028: OE_GLOBALS.G_GROUP_SET THEN
1029:
1030:
1031: l_index := 0;
1032: K := G_Delayed_Requests.FIRST;
1034: WHILE K is not null -- while loop safer than tbl.first to last
1035: LOOP
1036:
1037: IF (G_Delayed_Requests(K).request_type =
1038: OE_GLOBALS.G_GROUP_SET)
1039: THEN
1040:
1041: l_index := l_index + 1;
1042: l_sch_set_tbl(l_index) := g_delayed_requests(K);
1060: WHILE K is not null -- while loop safer than tbl.first to last
1061: LOOP
1062:
1063: IF G_Delayed_Requests(K).request_type =
1064: OE_GLOBALS.G_GROUP_SET
1065: THEN
1066: g_delayed_requests(K).processed := 'Y';
1067: END IF;
1068:
1070:
1071: END LOOP;
1072: l_sch_set_tbl.delete;
1073: ELSIF l_request_type =
1074: OE_GLOBALS.G_SPLIT_SCHEDULE THEN
1075:
1076:
1077: l_index := 0;
1078: K := G_Delayed_Requests.FIRST;
1080: WHILE K is not null -- while loop safer than tbl.first to last
1081: LOOP
1082:
1083: IF (G_Delayed_Requests(K).request_type =
1084: OE_GLOBALS.G_SPLIT_SCHEDULE)
1085: THEN
1086:
1087: l_index := l_index + 1;
1088: l_sch_set_tbl(l_index) := g_delayed_requests(K);
1100: WHILE K is not null -- while loop safer than tbl.first to last
1101: LOOP
1102:
1103: IF G_Delayed_Requests(K).request_type =
1104: OE_GLOBALS.G_SPLIT_SCHEDULE
1105: THEN
1106: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
1107: THEN
1108: g_delayed_requests(K).processed := 'Y';
1115:
1116: END LOOP;
1117: l_sch_set_tbl.delete;
1118: ELSIF l_request_type =
1119: OE_GLOBALS.G_INSERT_SERVICE then
1120: OE_DELAYED_REQUESTS_UTIL.INSERT_SERVICE_FOR_OPTIONS
1121: ( x_return_status => l_return_status
1122: , p_serviced_line_id => l_entity_id
1123: );
1122: , p_serviced_line_id => l_entity_id
1123: );
1124:
1125: /* BUG 2013611 - Increment promotional balances in response to cancellations */
1126: ELSIF l_request_rec.request_type = OE_GLOBALS.G_REVERSE_LIMITS THEN
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add('About to PERFORM Delayed Request for Reverse Limits',1);
1129: END IF;
1130:
1143: END IF;
1144: /* BUG 2013611 END */
1145:
1146: -- Freight Rating.
1147: ELSIF l_request_rec.request_type = OE_GLOBALS.G_FREIGHT_RATING THEN
1148: IF l_debug_level > 0 THEN
1149: Oe_Debug_pub.Add('Before Executing Delayed request Freight Rating for header: '||l_request_rec.entity_id, 3);
1150: END IF;
1151: OE_FTE_INTEGRATION_PVT.Process_FTE_Action
1159: ,x_msg_data => l_msg_data
1160: );
1161:
1162:
1163: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_LINE THEN
1164: IF l_debug_level > 0 THEN
1165: Oe_Debug_pub.Add('Before Executing Delayed request Price line for '||l_request_rec.entity_id);
1166: Oe_Debug_pub.Add('The Event is '||l_request_rec.param2);
1167: END IF;
1189: );
1190: IF l_debug_level > 0 THEN
1191: Oe_Debug_pub.Add('After Executing Delayed request Price line for '||l_request_rec.entity_id);
1192: END IF;
1193: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
1194: IF l_debug_level > 0 THEN
1195: Oe_Debug_pub.Add('Before Executing Delayed request Price line for '||l_request_rec.entity_id);
1196: Oe_Debug_pub.Add('Before Header Price');
1197: Oe_Debug_pub.Add('The Event is '||l_request_rec.param2);
1223: Oe_Debug_pub.Add('After Executing Delayed request Price line for '||l_request_rec.entity_id);
1224: END IF;
1225:
1226: /* Customer Acceptance - Start */
1227: ELSIF l_request_rec.request_type = OE_GLOBALS.G_DFLT_CONTINGENCY_ATTRIBUTES THEN
1228: IF l_debug_level > 0 THEN
1229: Oe_Debug_pub.Add('Before Defaulting Contingency Attributes ');
1230: END IF;
1231: OE_ACCEPTANCE_UTIL.Default_contingency_Attributes();
1233: Oe_Debug_pub.Add('After Defaulting Contingency Attributes ');
1234: END IF;
1235: /* Customer Acceptance - End */
1236: --sol_ord_er #16014165 start
1237: ELSIF l_request_rec.request_type = OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL THEN
1238: If l_request_rec.request_unique_key1 = 'LINE' then
1239: IF l_debug_level > 0 THEN
1240: Oe_Debug_pub.Add('Executing G_SERVICE_FIRST_PERIOD_BILL for Line ');
1241: END IF;
1252: p_line_id => NULL ,
1253: x_return_status => l_return_status);
1254: End If;
1255: --sol_ord_er #16014165 end
1256: ELSIF (l_request_type = OE_GLOBALS.G_PROCESS_ADJUSTMENTS) then
1257: if l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add('count is : ' || G_Delayed_Requests.count );
1260: END IF;
1253: x_return_status => l_return_status);
1254: End If;
1255: --sol_ord_er #16014165 end
1256: ELSIF (l_request_type = OE_GLOBALS.G_PROCESS_ADJUSTMENTS) then
1257: if l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add('count is : ' || G_Delayed_Requests.count );
1260: END IF;
1261: l_prc_adj_index := G_Delayed_Requests.first;
1303:
1304: end if; /* entity_code = G_ENTITY_LINE */
1305:
1306: -- Delayed Request to Apply Automatic Attachments
1307: ELSIF l_request_type = OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT THEN
1308:
1309: OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments
1310: ( p_entity_code => l_request_rec.entity_code
1311: , p_entity_id => l_request_rec.entity_id
1312: , p_is_user_action => 'N'
1313: , x_return_status => l_return_status
1314: );
1315:
1316: ELSIF l_request_type = OE_GLOBALS.G_COPY_ATCHMT THEN
1317:
1318: OE_DELAYED_REQUESTS_UTIL.Copy_Attachments
1319: (p_entity_code => l_request_rec.entity_code
1320: ,p_from_entity_id =>
1323: ,p_manual_attachments_only => l_request_rec.param2
1324: ,x_return_status => l_return_status
1325: );
1326:
1327: ELSIF l_request_type = OE_GLOBALS.G_COPY_ADJUSTMENTS THEN
1328:
1329: OE_Line_Adj_Util.copy_adjustment_lines
1330: (p_from_line_id => to_number(l_request_rec.param2)
1331: ,p_to_line_id => l_request_rec.entity_id
1341: ,x_return_status => l_return_status
1342: );
1343:
1344: --bug 16317238
1345: ELSIF l_request_type = OE_GLOBALS.G_COPY_ASSOCIATION THEN
1346:
1347: oe_debug_pub.ADD('Processing copy associations');
1348: OE_Line_Adj_Assocs_Util.copy_assoc_lines
1349: (p_from_line_id => to_number(l_request_rec.param2)
1354: ,p_assoc_list_line_id =>to_number(l_request_rec.param7)
1355: ,x_return_status => l_return_status
1356: );
1357: /* Added for Bug # 1559906 */
1358: ELSIF l_request_type = OE_GLOBALS.G_COPY_FREIGHT_CHARGES THEN
1359:
1360: OE_Header_Adj_Util.copy_freight_charges
1361: ( p_from_header_id => to_number(l_request_rec.param2)
1362: , p_to_header_id => l_request_rec.entity_id
1365: );
1366:
1367:
1368: /* Added the new delayed req for Bug # 2170086 */
1369: ELSIF l_request_type = OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS THEN
1370:
1371: OE_Header_Adj_Util.copy_header_adjustments
1372: ( p_from_header_id => to_number(l_request_rec.param2)
1373: , p_to_header_id => l_request_rec.entity_id
1378:
1379:
1380: /* csheu added for bug #1533658 */
1381:
1382: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_SERVICE THEN
1383: IF l_debug_level > 0 THEN
1384: oe_debug_pub.add('CSH-- Before calls OE_Service_Util.cascade_changes', 1);
1385: END IF;
1386:
1394: END IF;
1395:
1396: /* lchen added for bug #1761154 */
1397:
1398: ELSIF l_request_type = OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE then
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add('lchen-- Before calls OE_DELAYED_REQUESTS_UTIL.CASCADE_SERVICE_FOR_OPTIONS', 1);
1401: END IF;
1402: OE_DELAYED_REQUESTS_UTIL.CASCADE_SERVICE_FOR_OPTIONS
1407: oe_debug_pub.add('lchen-- After calls OE_DELAYED_REQUESTS_UTIL.CASCADE_SERVICE_FOR_OPTIONS', 1);
1408: END IF;
1409:
1410: -- added by lkxu: to copy pricing attributes
1411: ELSIF l_request_type = OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES THEN
1412:
1413: OE_Line_PAttr_Util.copy_pricing_attributes
1414: (p_from_line_id => to_number(l_request_rec.param2)
1415: ,p_to_line_id => l_request_rec.entity_id
1416: ,p_to_Header_id => to_number(l_request_rec.param1)
1417: ,x_return_status => l_return_status
1418: );
1419:
1420: ELSIF l_request_type = OE_GLOBALS.G_COPY_MODEL_PATTR THEN
1421:
1422: /* bug 1857538
1423: copy_model_pattr now takes only the line_id as parameter
1424: Corresponding changes are in OEXULPAS and OEXULPAB
1429: p_to_line_id => to_number(l_request_rec.param1)
1430: ,x_return_status => l_return_status
1431: );
1432:
1433: ELSIF l_request_type = OE_GLOBALS.G_DELETE_CHARGES THEN
1434: OE_Header_Util.cancel_header_charges
1435: (
1436: p_header_id => l_request_rec.entity_id,
1437: --p_x_line_id => to_number(l_request_rec.param1),
1437: --p_x_line_id => to_number(l_request_rec.param1),
1438: x_return_status => l_return_status
1439: );
1440:
1441: ELSIF l_request_type = OE_GLOBALS.G_CASCADE_SCH_ATTRBS THEN
1442:
1443: G_Delayed_Requests(p_request_ind).processed := 'Y';
1444:
1445: ELSIF l_request_type =
1442:
1443: G_Delayed_Requests(p_request_ind).processed := 'Y';
1444:
1445: ELSIF l_request_type =
1446: OE_GLOBALS.G_CASCADE_SHIP_SET_ATTR then
1447:
1448: l_index := 0;
1449: l_set_id := l_request_rec.param2;
1450:
1453: WHILE K is not null
1454: LOOP
1455:
1456: IF (G_Delayed_Requests(K).request_type =
1457: OE_GLOBALS.G_CASCADE_SHIP_SET_ATTR) AND
1458: G_Delayed_Requests(K).param2 = l_set_id AND
1459: K <> p_request_ind
1460: THEN
1461:
1471: ( p_request_rec => l_request_rec
1472: , x_return_status => l_return_status);
1473:
1474: ELSIF l_request_type =
1475: OE_GLOBALS.G_GROUP_SCHEDULE then
1476:
1477: l_index := 0;
1478: l_set_id := l_request_rec.param1;
1479:
1482: WHILE K is not null
1483: LOOP
1484:
1485: IF (G_Delayed_Requests(K).request_type =
1486: OE_GLOBALS.G_GROUP_SCHEDULE) AND
1487: G_Delayed_Requests(K).param1 = l_set_id AND
1488: K <> p_request_ind
1489: THEN
1490:
1510: WHILE l_count is not null
1511: LOOP
1512:
1513: IF G_Delayed_Requests(l_count).request_type =
1514: OE_GLOBALS.G_CASCADE_SCH_ATTRBS AND
1515: G_Delayed_Requests(l_count).param1 = l_set_id
1516: THEN
1517: /* Modified below code for bug 8636027 */
1518:
1572: oe_schedule_util.OESCH_SET_SCHEDULING := 'Y';
1573: END IF;
1574: -- 4026758
1575: ELSIF l_request_type =
1576: OE_GLOBALS.G_DELETE_SET THEN
1577: l_set_id := l_request_rec.param1;
1578:
1579: K := G_Delayed_Requests.FIRST;
1580:
1581: WHILE K is not null
1582: LOOP
1583:
1584: IF (G_Delayed_Requests(K).request_type =
1585: OE_GLOBALS.G_DELETE_SET)
1586: AND G_Delayed_Requests(K).param1 = l_set_id
1587: AND K <> p_request_ind THEN
1588:
1589: g_delayed_requests.delete(K);
1597: oe_set_util.Delete_Set(p_request_rec => l_request_rec
1598: , x_return_status => l_return_status);
1599: oe_debug_pub.add('Delete Set Return Status ' || l_return_status,1);
1600: ELSIF (l_request_type =
1601: OE_GLOBALS.G_SCHEDULE_LINE OR
1602: l_request_type =
1603: OE_GLOBALS.G_RESCHEDULE_LINE) then
1604:
1605: l_index := 0;
1599: oe_debug_pub.add('Delete Set Return Status ' || l_return_status,1);
1600: ELSIF (l_request_type =
1601: OE_GLOBALS.G_SCHEDULE_LINE OR
1602: l_request_type =
1603: OE_GLOBALS.G_RESCHEDULE_LINE) then
1604:
1605: l_index := 0;
1606: l_set := l_request_rec.param1;
1607:
1610: WHILE K is not null -- while loop safer than tbl.first to last
1611: LOOP
1612:
1613: IF (G_Delayed_Requests(K).request_type =
1614: OE_GLOBALS.G_SCHEDULE_LINE OR
1615: G_Delayed_Requests(K).request_type =
1616: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1617: G_Delayed_Requests(K).param1 = l_set
1618: THEN
1612:
1613: IF (G_Delayed_Requests(K).request_type =
1614: OE_GLOBALS.G_SCHEDULE_LINE OR
1615: G_Delayed_Requests(K).request_type =
1616: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1617: G_Delayed_Requests(K).param1 = l_set
1618: THEN
1619:
1620: l_index := l_index + 1;
1645: WHILE K is not null -- while loop safer than tbl.first to last
1646: LOOP
1647:
1648: IF (G_Delayed_Requests(K).request_type =
1649: OE_GLOBALS.G_SCHEDULE_LINE OR
1650: G_Delayed_Requests(K).request_type =
1651: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1652: G_Delayed_Requests(K).param1 = l_set
1653: THEN
1647:
1648: IF (G_Delayed_Requests(K).request_type =
1649: OE_GLOBALS.G_SCHEDULE_LINE OR
1650: G_Delayed_Requests(K).request_type =
1651: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1652: G_Delayed_Requests(K).param1 = l_set
1653: THEN
1654: l_index := l_index + 1;
1655: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
1664:
1665: END LOOP;
1666:
1667: -- bug 1829201, commitment related changes.
1668: ELSIF l_request_type = OE_GLOBALS.G_CALCULATE_COMMITMENT THEN
1669: IF l_debug_level > 0 THEN
1670: oe_debug_pub.add('Calling procedure calculate_commtment!',1);
1671: END IF;
1672:
1675: p_request_rec => l_request_rec
1676: ,x_return_status => l_return_status
1677: );
1678:
1679: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT THEN
1680:
1681: OE_Commitment_Pvt.update_commitment
1682: ( p_line_id => l_request_rec.entity_id
1683: ,x_return_status => l_return_status
1682: ( p_line_id => l_request_rec.entity_id
1683: ,x_return_status => l_return_status
1684: );
1685: -- multiple payments
1686: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED THEN
1687: IF l_debug_level > 0 THEN
1688: oe_debug_pub.add('OEXVREQB param1 is: '||l_request_rec.param1,3);
1689: oe_debug_pub.add('OEXVREQB param2 is: '||l_request_rec.param2,3);
1690: oe_debug_pub.add('OEXVREQB param3 is: '||l_request_rec.param3,3);
1698: );
1699:
1700: -- Included for the Spares Management (ikon) project mshenoy
1701: -- For the delayed request type of Create Internal Req call the procedure
1702: ELSIF l_request_type = OE_GLOBALS.G_CREATE_INTERNAL_REQ THEN
1703: IF l_debug_level > 0 THEN
1704: oe_debug_pub.add(' Calling auto_create_internal_req hdr id '|| l_entity_id,1);
1705: END IF;
1706: OE_DELAYED_REQUESTS_UTIL.auto_create_internal_req
1711: END IF;
1712:
1713: /* Modified the following condition to fix the bug 6663462 */
1714:
1715: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1716: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1717: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1718: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1719: IF l_debug_level > 0 THEN
1712:
1713: /* Modified the following condition to fix the bug 6663462 */
1714:
1715: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1716: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1717: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1718: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1719: IF l_debug_level > 0 THEN
1720: oe_debug_pub.add('calling Process_Scheduling_Request');
1713: /* Modified the following condition to fix the bug 6663462 */
1714:
1715: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1716: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1717: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1718: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1719: IF l_debug_level > 0 THEN
1720: oe_debug_pub.add('calling Process_Scheduling_Request');
1721: END IF;
1714:
1715: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1716: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1717: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1718: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1719: IF l_debug_level > 0 THEN
1720: oe_debug_pub.add('calling Process_Scheduling_Request');
1721: END IF;
1722: Process_Scheduling_Request
1728: END IF;
1729: ---------
1730: -- Added by rsreeniv
1731: ----------
1732: ELSIF l_request_rec.request_type = OE_GLOBALS.G_FREIGHT_FOR_INCLUDED THEN
1733: IF l_debug_level > 0 THEN
1734: Oe_Debug_pub.Add('Before Executing Delayed request Freight for included for '||l_request_rec.entity_id);
1735: Oe_Debug_pub.Add('Before Order Price - Freight');
1736: Oe_Debug_pub.Add('The Event is '||l_request_rec.param2);
1773: Oe_Debug_pub.Add('After Header Price');
1774: Oe_Debug_pub.Add('After Executing Delayed request Price line for '||l_request_rec.entity_id);
1775: END IF;
1776: --MRG BGN
1777: ELSIF l_request_type = OE_GLOBALS.G_MARGIN_HOLD THEN
1778: IF l_debug_level > 0 THEN
1779: oe_debug_pub.add('From delayed request: executing Oe_Margin_Pvt.Margin_Hold');
1780: END IF;
1781: Oe_Margin_Pvt.Margin_Hold(p_header_id => l_request_rec.entity_id);
1785: -------------
1786:
1787:
1788: --MRG BGN
1789: ELSIF l_request_type = OE_GLOBALS.G_GET_COST THEN
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add('From delayed request: executing Oe_Margin_Pvt.Get_Cost');
1792: END IF;
1793: l_unit_cost := Oe_Margin_Pvt.Get_Cost(p_request_rec => l_request_rec);
1793: l_unit_cost := Oe_Margin_Pvt.Get_Cost(p_request_rec => l_request_rec);
1794: --MRG END
1795:
1796:
1797: ELSIF l_request_type = OE_GLOBALS.G_DEL_CHG_LINES Then
1798: IF l_debug_level > 0 THEN
1799: oe_debug_pub.add('Executing Delete_Changed_Lines delayed request');
1800: END IF;
1801:
1803: IF l_debug_level > 0 THEN
1804: oe_debug_pub.add('After Delete_Changed_Lines delayed request');
1805: END IF;
1806:
1807: ELSIF l_request_type = OE_GLOBALS.G_VERSION_AUDIT THEN
1808:
1809: OE_Versioning_Util.Execute_Versioning_Request(p_header_id => l_request_rec.entity_id,
1810: p_document_type => l_request_rec.entity_code,
1811: p_changed_attribute => l_request_rec.param1,
1814: x_return_status => x_return_status);
1815:
1816: -- BLANKETS: Ignore process release related requests here. These
1817: -- will be executed with all requests in process_delayed_requests call.
1818: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_RELEASE THEN
1819: RETURN;
1820: ELSIF l_request_type = OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS THEN
1821: RETURN;
1822:
1816: -- BLANKETS: Ignore process release related requests here. These
1817: -- will be executed with all requests in process_delayed_requests call.
1818: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_RELEASE THEN
1819: RETURN;
1820: ELSIF l_request_type = OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS THEN
1821: RETURN;
1822:
1823: -- Delayed requests logged by blankets business object APIs.
1824: ELSIF l_request_type = 'VALIDATE_BLANKET_LINE_NUMBER' THEN
1834: ELSIF l_request_type = 'ADD_BLANKET_PRICE_LIST_LINE' THEN
1835: OE_BLANKET_UTIL.add_price_list_line( p_req_ind => p_request_ind,
1836: x_return_status => l_return_status);
1837: -- for bug 3309427
1838: ELSIF l_request_type = OE_GLOBALS.G_CLEAR_BLKT_PRICE_LIST_LINE THEN
1839: OE_BLANKET_UTIL.clear_price_list_line( p_req_ind => p_request_ind,
1840: x_return_status => l_return_status);
1841: ELSIF l_request_type = 'RECORD_BLANKET_HISTORY' THEN
1842: OE_BLANKET_UTIL.record_blanket_history(
1846: p_sold_To_org_id => l_request_rec.param1,
1847: x_return_status => l_return_status);
1848: -- End of requests logged by blankets business object APIs.
1849: -- Begin of Multiple Payments
1850: ELSIF l_request_type = OE_GLOBALS.G_SPLIT_PAYMENT then
1851: OE_PrePayment_Pvt.split_payment (
1852: p_line_id => l_request_rec.entity_id
1853: , p_header_id => l_request_rec.param2
1854: , p_split_from_line_id => l_request_rec.param1
1863: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_entity_id,
1864: p_status => 'BOOKED');
1865: -- OIP SUN ER Changes End
1866:
1867: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_HDR_PAYMENT then
1868:
1869: IF l_debug_level > 0 THEN
1870: oe_debug_pub.add('param1 is : ' || l_request_rec.param1);
1871: oe_debug_pub.add('param2 is : ' || l_request_rec.param2);
1872: oe_debug_pub.add('entity id is : ' || l_request_rec.entity_id);
1873: oe_debug_pub.add('entity code is : ' || l_request_rec.entity_code);
1874: END IF;
1875:
1876: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT
1877: AND l_request_rec.param1 = 'UPDATE_LINE' THEN
1878: payment_line_id := l_request_rec.entity_id;
1879: payment_header_id := l_request_rec.param2;
1880:
1896: , x_msg_count => l_msg_count
1897: , x_msg_data => l_msg_data
1898: );
1899:
1900: ELSIF l_request_type = OE_GLOBALS.G_APPLY_PPP_HOLD THEN
1901: --bug3507871 start
1902: IF l_debug_level > 0 THEN
1903: oe_debug_pub.add('Before calling Process_Payments for applying PPP hold');
1904: END IF;
1912: x_msg_count => l_msg_count,
1913: x_return_status => l_return_status);
1914: --bug3507871 end
1915: --bug3625027 start
1916: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_PAYMENT THEN
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add('Request Type: '||l_request_type);
1919: END IF;
1920: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
1916: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_PAYMENT THEN
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add('Request Type: '||l_request_type);
1919: END IF;
1920: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
1921: IF l_debug_level > 0 THEN
1922: oe_debug_pub.add('Before calling Process_Payments Procedure at the header level');
1923: END IF;
1924:
1931: p_process_authorization=>'N',
1932: x_msg_data => l_msg_data,
1933: x_msg_count => l_msg_count,
1934: x_return_status => l_return_status);
1935: ELSIF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1936: IF l_debug_level > 0 THEN
1937: oe_debug_pub.add('Before calling Process_Payments Procedure at the line level');
1938: END IF;
1939:
1950: x_return_status => l_return_status);
1951: END IF;
1952: --bug3625027 end
1953:
1954: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENT_HOLD THEN
1955: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1956: payment_line_id := l_request_rec.entity_id;
1957: payment_header_id := l_request_rec.param2;
1958: ELSE
1951: END IF;
1952: --bug3625027 end
1953:
1954: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENT_HOLD THEN
1955: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1956: payment_line_id := l_request_rec.entity_id;
1957: payment_header_id := l_request_rec.param2;
1958: ELSE
1959: payment_header_id := l_request_rec.entity_id;
1989: OE_BLANKET_PRICING_UTIL.Create_Modifiers(
1990: p_index => p_request_ind,
1991: x_return_status => l_return_status);
1992:
1993: ELSIF l_request_type IN (OE_GLOBALS.G_GENERATE_XML_REQ_HDR, OE_GLOBALS.G_GENERATE_XML_REQ_LN) THEN
1994: -- only do processing on header-level requests
1995:
1996: IF l_request_type = OE_GLOBALS.G_GENERATE_XML_REQ_HDR THEN
1997: OE_DELAYED_REQUESTS_UTIL.process_xml_delayed_request(p_request_ind => p_request_ind,
1992:
1993: ELSIF l_request_type IN (OE_GLOBALS.G_GENERATE_XML_REQ_HDR, OE_GLOBALS.G_GENERATE_XML_REQ_LN) THEN
1994: -- only do processing on header-level requests
1995:
1996: IF l_request_type = OE_GLOBALS.G_GENERATE_XML_REQ_HDR THEN
1997: OE_DELAYED_REQUESTS_UTIL.process_xml_delayed_request(p_request_ind => p_request_ind,
1998: x_return_status => l_return_status);
1999: END IF;
2000: --R12 CC Encryption
1997: OE_DELAYED_REQUESTS_UTIL.process_xml_delayed_request(p_request_ind => p_request_ind,
1998: x_return_status => l_return_status);
1999: END IF;
2000: --R12 CC Encryption
2001: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENTS THEN
2002: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
2003: payment_line_id := l_request_rec.entity_id;
2004: payment_header_id := l_request_rec.param1;
2005: old_invoice_to_org_id := to_number(l_request_rec.param2);
1998: x_return_status => l_return_status);
1999: END IF;
2000: --R12 CC Encryption
2001: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENTS THEN
2002: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
2003: payment_line_id := l_request_rec.entity_id;
2004: payment_header_id := l_request_rec.param1;
2005: old_invoice_to_org_id := to_number(l_request_rec.param2);
2006: ELSE
2025: --R12 CC Encryption
2026: -- End of requests logged by blankets business object APIs.
2027:
2028: --BUG#10052614 Starts
2029: ELSIF l_request_type = OE_GLOBALS.G_DR_COPY_OTM_RECORDS THEN
2030: /* Modified below call to dynamic SQL to avoid dependency on OTM
2031: * patch, since OTM patch mandates a pre-req of R12 RUP6.
2032: l_otm_volume := OZF_VOLUME_CALCULATION_PUB.copy_order_group_details( p_to_order_line_id => l_entity_id
2033: , p_from_order_line_id => l_request_rec.param2
2125: IF (p_delete = FND_API.G_TRUE)
2126: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2127: -- Bug 11811300 starts
2128: IF G_Delayed_Requests(p_request_ind).request_type IN
2129: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
2130: -- Bug 11811300 ends
2131: THEN -- 9714072
2132: G_Delayed_Requests.Delete(p_request_ind);
2133: ELSE -- 9714072
2143: IF (p_delete = FND_API.G_TRUE)
2144: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2145: -- Bug 11811300 starts
2146: IF G_Delayed_Requests(p_request_ind).request_type IN
2147: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
2148: -- Bug 11811300 ends
2149: THEN -- 9714072
2150: G_Delayed_Requests.Delete(p_request_ind);
2151: ELSE -- 9714072
2159: IF (p_delete = FND_API.G_TRUE)
2160: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2161: -- Bug 11811300 starts
2162: IF G_Delayed_Requests(p_request_ind).request_type IN
2163: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
2164: -- Bug 11811300 ends
2165: THEN -- 9714072
2166: G_Delayed_Requests.Delete(p_request_ind);
2167: ELSE -- 9714072
2182: IF (p_delete = FND_API.G_TRUE)
2183: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2184: -- Bug 11811300 starts
2185: IF G_Delayed_Requests(p_request_ind).request_type IN
2186: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
2187: -- Bug 11811300 ends
2188: THEN -- 9714072
2189: G_Delayed_Requests.Delete(p_request_ind);
2190: ELSE -- 9714072
2339:
2340: l_request.processed := 'N';
2341:
2342: -- Added for bug 12673852
2343: IF l_request.request_type = OE_GLOBALS.G_DEL_CHG_LINES THEN
2344: IF oe_mass_change_pvt.Lines_Remaining = 'Y'
2345: THEN
2346: oe_debug_pub.add('Called from Mass Change, line remaining, NOT logging G_DEL_CHG_LINES request');
2347: RETURN;
2350: END IF;
2351: END IF;
2352: -- End of bug 12673852
2353:
2354: IF l_request.request_type = OE_GLOBALS.G_PRICE_ORDER
2355: AND (l_request.request_unique_key1 = 'BATCH'
2356: AND nvl(l_request.request_unique_key2,'N') = 'Y'
2357: OR l_request.request_unique_key1 = 'ORDER'
2358: AND nvl(l_request.request_unique_key2,'N') = 'N'
2393: END IF;
2394:
2395: /* Added the following code to fix the fp bug 3498435 */
2396:
2397: IF l_request.request_type = OE_GLOBALS.G_PRICE_LINE
2398: AND (nvl(l_request.request_unique_key1, l_request.param2) = 'BATCH'
2399: AND nvl(l_request.request_unique_key2,'N') = 'N'
2400: OR nvl(l_request.request_unique_key1,l_request.param2) = 'BATCH,BOOK'
2401: AND nvl(l_request.request_unique_key2,'N') = 'N')
2420: OE_Debug_PUB.ADD('Request replaced');
2421: END IF;
2422:
2423: IF g_delayed_requests(l_request_ind).request_type =
2424: OE_GLOBALS.G_CASCADE_CHANGES THEN
2425: IF l_debug_level > 0 THEN
2426: OE_Debug_PUB.ADD('cascade changes, orig qty '||
2427: g_delayed_requests(l_request_ind).param1, 3);
2428: END IF;
2428: END IF;
2429: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2430:
2431: ELSIF g_delayed_requests(l_request_ind).request_type =
2432: OE_GLOBALS.G_UPDATE_OPTION THEN
2433: IF l_debug_level > 0 THEN
2434: OE_Debug_PUB.ADD('update option, orig qty '||
2435: g_delayed_requests(l_request_ind).param4, 3);
2436: END IF;
2438: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2439:
2440: -- Added 09-DEC-2002
2441: -- BLANKETS: exception for blankets to retain old parameters
2442: ELSIF p_request_type = OE_GLOBALS.G_PROCESS_RELEASE
2443: THEN
2444: IF l_debug_level > 0 THEN
2445: oe_debug_pub.add('Retain parameters for old values');
2446: END IF;
2450: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2451: l_request.param5 := g_delayed_requests(l_request_ind).param5;
2452: l_request.param6 := g_delayed_requests(l_request_ind).param6;
2453:
2454: ELSIF p_request_type = OE_GLOBALS.G_DROPSHIP_CMS
2455: THEN
2456: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2457: l_request.param2 := g_delayed_requests(l_request_ind).param2;
2458: l_request.param3 := g_delayed_requests(l_request_ind).param3;
2463: -- l_request.param7 := g_delayed_requests(l_request_ind).param7;
2464: l_request.date_param1 := g_delayed_requests(l_request_ind).date_param1;
2465: /*****End changes for bug#6918700*********/
2466:
2467: ELSIF p_request_type = OE_GLOBALS.G_GROUP_SCHEDULE
2468: THEN
2469: --2819258 -- Retain the operation
2470: l_request.param14 := g_delayed_requests(l_request_ind).param14;
2471: -- 4052648
2468: THEN
2469: --2819258 -- Retain the operation
2470: l_request.param14 := g_delayed_requests(l_request_ind).param14;
2471: -- 4052648
2472: ELSIF p_request_type = OE_GLOBALS.G_SCHEDULE_ATO
2473: THEN
2474: -- Retain old parameter values.
2475: l_request.param7 := g_delayed_requests(l_request_ind).param7; -- Ship From
2476: l_request.param8 := g_delayed_requests(l_request_ind).param8; -- Demand Class
2480: l_request.param17 := g_delayed_requests(l_request_ind).param17; -- Delivery Lead Time
2481: l_request.date_param4 := g_delayed_requests(l_request_ind).date_param4; -- Req Date
2482: l_request.date_param5 := g_delayed_requests(l_request_ind).date_param5; -- SSD
2483: l_request.date_param6 := g_delayed_requests(l_request_ind).date_param6; -- SAD
2484: ELSIF p_request_type = OE_GLOBALS.G_SCHEDULE_SMC
2485: THEN
2486: -- Retain old parameter values.
2487: l_request.param7 := g_delayed_requests(l_request_ind).param7; -- Ship From
2488: l_request.param8 := g_delayed_requests(l_request_ind).param8; -- Demand Class
2492: l_request.param17 := g_delayed_requests(l_request_ind).param17; -- Delivery Lead Time
2493: l_request.date_param4 := g_delayed_requests(l_request_ind).date_param4; -- Req Date
2494: l_request.date_param5 := g_delayed_requests(l_request_ind).date_param5; -- SSD
2495: l_request.date_param6 := g_delayed_requests(l_request_ind).date_param6; -- SAD
2496: ELSIF p_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC
2497: THEN
2498: -- Retain old parameter values.
2499: l_request.param7 := g_delayed_requests(l_request_ind).param7; -- Ship From
2500: l_request.param8 := g_delayed_requests(l_request_ind).param8; -- Demand Class
2507: l_request.date_param6 := g_delayed_requests(l_request_ind).date_param6; -- SAD
2508:
2509: /* 7576948: IR ISO Change Management project Start */
2510: -- This code is hooked for IR ISO project and specific to
2511: -- OE_GLOBALS.G_UPDATE_REQUISITION delayed request, where if this request
2512: -- is getting replaced then certain parameter values should be retained
2513: -- or manipulated. Following parameters are used for this delayed request
2514: -- Please refer them with their meaning -
2515: --
2513: -- or manipulated. Following parameters are used for this delayed request
2514: -- Please refer them with their meaning -
2515: --
2516: -- P_entity_code Entity for which delayed request has to be logged.
2517: -- In this project it can be OE_Globals.G_Entity_Line
2518: -- or OE_Globals.G_Entity_Header
2519: -- P_entity_id Primary key of the entity record. In this project,
2520: -- it can be Order Line_id or Header_id
2521: -- P_requesting_entity_code Which entity has requested this delayed request to
2514: -- Please refer them with their meaning -
2515: --
2516: -- P_entity_code Entity for which delayed request has to be logged.
2517: -- In this project it can be OE_Globals.G_Entity_Line
2518: -- or OE_Globals.G_Entity_Header
2519: -- P_entity_id Primary key of the entity record. In this project,
2520: -- it can be Order Line_id or Header_id
2521: -- P_requesting_entity_code Which entity has requested this delayed request to
2522: -- be logged! In this project it will be OE_Globals.
2518: -- or OE_Globals.G_Entity_Header
2519: -- P_entity_id Primary key of the entity record. In this project,
2520: -- it can be Order Line_id or Header_id
2521: -- P_requesting_entity_code Which entity has requested this delayed request to
2522: -- be logged! In this project it will be OE_Globals.
2523: -- G_Entity_Line or OE_Globals.G_Entity_Header
2524: -- P_requesting_entity_id Primary key of the requesting entity. In this
2525: -- project, it is Line_id or Header_id
2526: -- P_request_type Indicates which business logic (or which procedure)
2519: -- P_entity_id Primary key of the entity record. In this project,
2520: -- it can be Order Line_id or Header_id
2521: -- P_requesting_entity_code Which entity has requested this delayed request to
2522: -- be logged! In this project it will be OE_Globals.
2523: -- G_Entity_Line or OE_Globals.G_Entity_Header
2524: -- P_requesting_entity_id Primary key of the requesting entity. In this
2525: -- project, it is Line_id or Header_id
2526: -- P_request_type Indicates which business logic (or which procedure)
2527: -- should be executed. In this project, it is OE_Global
2561: -- For details on IR ISO CMS project, please refer to FOL >
2562: -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
2563:
2564:
2565: ELSIF p_request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
2566: IF l_debug_level > 0 THEN
2567: oe_debug_pub.add('Type: G_UPDATE_REQUISITION, retain old parameter values',5);
2568: END IF;
2569:
2667: END IF;
2668: -- l_request_ind := nvl(g_delayed_requests.LAST, 0) + 1;
2669:
2670: -- 11i10 Pricing Changes for blankets
2671: IF p_request_type = OE_GLOBALS.G_PROCESS_RELEASE
2672: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
2673: THEN
2674: OE_Blkt_Release_Util.Cache_Order_Qty_Amt
2675: (p_request_rec => l_request
2981: x_return_status := FND_API.G_RET_STS_SUCCESS;
2982: IF l_debug_level > 0 THEN
2983: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);
2984: END IF;
2985: IF NOT oe_globals.g_call_process_req THEN --9354229
2986: IF l_debug_level > 0 THEN
2987: oe_debug_pub.add( 'EXIT PROCESS_REQUESTS_FOR_ENTITY' , 1 ) ;
2988: END IF;
2989: RETURN;
2991: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2992: p_In_out => 1);
2993:
2994:
2995: IF oe_globals.g_recursion_mode = 'N' THEN
2996:
2997:
2998: l_ind := G_Delayed_Requests.first;
2999:
3083: IF l_debug_level > 0 THEN
3084: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');
3085: END IF;
3086:
3087: IF NOT oe_globals.g_call_process_req THEN --9354229
3088: IF l_debug_level > 0 THEN
3089: oe_debug_pub.add( 'EXIT Process_Request_for_ReqType' , 1 ) ;
3090: END IF;
3091: RETURN;
3093:
3094: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3095: p_In_out => 1);
3096:
3097: --IF oe_globals.g_recursion_mode = 'N' THEN
3098: l_ind := G_Delayed_Requests.first;
3099: l_count := 0;
3100: WHILE l_ind IS NOT NULL LOOP
3101: IF G_Delayed_Requests(l_ind).request_type = p_request_type THEN
3098: l_ind := G_Delayed_Requests.first;
3099: l_count := 0;
3100: WHILE l_ind IS NOT NULL LOOP
3101: IF G_Delayed_Requests(l_ind).request_type = p_request_type THEN
3102: IF p_request_type = OE_GLOBALS.G_TAX_LINE THEN
3103: l_count := l_count + 1;
3104: l_entity_id_tbl(l_count).entity_id := G_Delayed_Requests(l_ind).entity_id;
3105: l_req_entity_ind := G_Requesting_Entities.First;
3106: WHILE l_req_entity_ind IS NOT NULL LOOP
3212: END IF;
3213:
3214: x_return_status := FND_API.G_RET_STS_SUCCESS;
3215:
3216: IF NOT oe_globals.g_call_process_req THEN --9354229
3217: IF l_debug_level > 0 THEN
3218: oe_debug_pub.add( 'EXIT OE_Delayed_Requests_Pvt.Process_Delayed_Requests' , 1 ) ;
3219: END IF;
3220: RETURN;
3224:
3225: -- Process requests as per the dependency
3226: -- Process a request to default header sales credit for
3227: -- primary sales person
3228: IF oe_globals.g_recursion_mode = 'N' THEN
3229:
3230: Process_Request_for_ReqType
3231: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
3232: ,p_delete => FND_API.G_TRUE
3227: -- primary sales person
3228: IF oe_globals.g_recursion_mode = 'N' THEN
3229:
3230: Process_Request_for_ReqType
3231: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
3232: ,p_delete => FND_API.G_TRUE
3233: ,x_return_status => l_return_status
3234: );
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3239: END IF;
3240:
3241: -- Process Header Sales Credits Delayed Requests
3242: Process_Request_for_ReqType
3243: (p_request_type => OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
3244: ,p_delete => FND_API.G_TRUE
3245: ,x_return_status => l_return_status
3246: );
3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3251: END IF;
3252:
3253: -- Process Lines Sales Credits Delayed Requests
3254: Process_Request_for_ReqType
3255: (p_request_type => OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
3256: ,p_delete => FND_API.G_TRUE
3257: ,x_return_status => l_return_status
3258: );
3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3263: END IF;
3264:
3265: /* Bug 12673852 */
3266: Process_Request_for_ReqType
3267: (p_request_type => OE_GLOBALS.G_VERSION_AUDIT
3268: ,p_delete => FND_API.G_TRUE
3269: ,x_return_status => l_return_status
3270: );
3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3276: /* End of Bug 12673852 */
3277:
3278: -- Process CREATE_SETS Requests
3279: Process_Request_for_ReqType
3280: (p_request_type => OE_GLOBALS.G_CREATE_SETS
3281: ,p_delete => FND_API.G_TRUE
3282: ,x_return_status => l_return_status
3283: );
3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3290:
3291:
3292: -- Process CREATE_CONFIG_ITEM Requests
3293: Process_Request_for_ReqType
3294: (p_request_type => OE_GLOBALS.G_CREATE_CONFIG_ITEM
3295: ,p_delete => FND_API.G_TRUE
3296: ,x_return_status => l_return_status
3297: );
3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3302: END IF;
3303:
3304: -- Process INSERT_INTO_SETS Requests
3305: Process_Request_for_ReqType
3306: (p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
3307: ,p_delete => FND_API.G_TRUE
3308: ,x_return_status => l_return_status
3309: );
3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3314: END IF;
3315:
3316: /* Start DOO Pre Exploded Kit ER 9339742 */
3317: Process_Request_for_Reqtype
3318: ( p_request_type => OE_GLOBALS.G_PRE_EXPLODED_KIT
3319: , p_delete => FND_API.G_TRUE
3320: , x_return_status => l_return_status );
3321:
3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3327: /* End DOO Pre Exploded Kit ER 9339742 */
3328:
3329: -- Process INS_INCLUDED_ITEM Requests
3330: Process_Request_for_ReqType
3331: (p_request_type => OE_GLOBALS.G_INS_INCLUDED_ITEMS
3332: ,p_delete => FND_API.G_TRUE
3333: ,x_return_status => l_return_status
3334: );
3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3341:
3342:
3343: -- Process requests for RMA
3344: Process_Request_for_ReqType
3345: (p_request_type => OE_GLOBALS.G_INSERT_RMA
3346: ,p_delete => FND_API.G_TRUE
3347: ,x_return_status => l_return_status
3348: );
3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3353: END IF;
3354:
3355: -- Process requests for Split_hold
3356: Process_Request_for_ReqType
3357: (p_request_type => OE_GLOBALS.G_SPLIT_HOLD
3358: ,p_delete => FND_API.G_TRUE
3359: ,x_return_status => l_return_status
3360: );
3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3365: END IF;
3366:
3367: -- Process requests for Delayed Requests
3368: Process_Request_for_ReqType
3369: (p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE
3370: ,p_delete => FND_API.G_TRUE
3371: ,x_return_status => l_return_status
3372: );
3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3377: END IF;
3378:
3379: -- Process requests for Quantity Cascade
3380: Process_Request_for_ReqType
3381: (p_request_type => OE_GLOBALS.G_CASCADE_QUANTITY
3382: ,p_delete => FND_API.G_TRUE
3383: ,x_return_status => l_return_status
3384: );
3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3390:
3391: /*** we do not need this, confirm with ashwin
3392: -- Process requests for project Cascade
3393: Process_Request_for_ReqType
3394: (p_request_type => OE_GLOBALS.G_CASCADE_PROJECT
3395: ,p_delete => FND_API.G_TRUE
3396: ,x_return_status => l_return_status
3397: );
3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3402: END IF;
3403:
3404: -- Process requests for task Cascade
3405: Process_Request_for_ReqType
3406: (p_request_type => OE_GLOBALS.G_CASCADE_TASK
3407: ,p_delete => FND_API.G_TRUE
3408: ,x_return_status => l_return_status
3409: );
3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3415:
3416: -- Process requests for task Cascade
3417: ***/
3418: Process_Request_for_ReqType
3419: (p_request_type => OE_GLOBALS.G_CASCADE_CHANGES
3420: ,p_delete => FND_API.G_TRUE
3421: ,x_return_status => l_return_status
3422: );
3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3427: END IF;
3428:
3429: -- Process requests to Split Reservations
3430: Process_Request_for_ReqType
3431: (p_request_type => OE_GLOBALS.G_CREATE_RESERVATIONS
3432: ,p_delete => FND_API.G_TRUE
3433: ,x_return_status => l_return_status
3434: );
3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3439: END IF;
3440:
3441: -- Process requests to Complete Configuration
3442: Process_Request_for_ReqType
3443: (p_request_type => OE_GLOBALS.G_COMPLETE_CONFIGURATION
3444: ,p_delete => FND_API.G_TRUE
3445: ,x_return_status => l_return_status
3446: );
3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3451: END IF;
3452:
3453: -- Process requests for Validate Configuration
3454: Process_Request_for_ReqType
3455: (p_request_type => OE_GLOBALS.G_VALIDATE_CONFIGURATION
3456: ,p_delete => FND_API.G_TRUE
3457: ,x_return_status => l_return_status
3458: );
3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3463: END IF;
3464:
3465: -- Process requests for CTO Notification
3466: Process_Request_for_ReqType
3467: (p_request_type => OE_GLOBALS.G_CTO_NOTIFICATION
3468: ,p_delete => FND_API.G_TRUE
3469: ,x_return_status => l_return_status
3470: );
3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3475: END IF;
3476:
3477: -- Process requests for Service
3478: Process_Request_for_ReqType
3479: (p_request_type => OE_GLOBALS.G_INSERT_SERVICE
3480: ,p_delete => FND_API.G_TRUE
3481: ,x_return_status => l_return_status
3482: );
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3487: END IF;
3488:
3489: /* Added the below call for bug 5925600 */
3490: Process_Request_for_ReqType
3491: (p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE
3492: ,p_delete => FND_API.G_TRUE
3493: ,x_return_status => l_return_status
3494: );
3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3498: RAISE FND_API.G_EXC_ERROR;
3499: END IF;
3500: /* Bug 9845427 */
3501: Process_Request_for_ReqType
3502: (p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE
3503: ,p_delete => FND_API.G_TRUE
3504: ,x_return_status => l_return_status
3505: );
3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3510: END IF;
3511: /* End of Bug 9845427 */
3512:
3513: Process_Request_for_ReqType
3514: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
3515: ,p_delete => FND_API.G_TRUE
3516: ,x_return_status => l_return_status
3517: );
3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3523: /* End of changes done for bug 5925600 */
3524:
3525: -- bug 5717671/5736696, need to execute copy header adj
3526: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3527: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3528: ,p_delete => FND_API.G_TRUE
3529: ,x_return_status => l_return_status
3530: );
3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3537:
3538: -- bug 1834260, moved this block of code from after processing
3539: -- for request type G_PRICE_LINE to before it.
3540: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3541: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3542: ,p_delete => FND_API.G_TRUE
3543: ,x_return_status => l_return_status
3544: );
3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3549: END IF;
3550:
3551: -- Process Requests for Freight Rating.
3552: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3553: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3554: ,p_delete => FND_API.G_TRUE
3555: ,x_return_status => l_return_status
3556: );
3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3565: right after copy_adjustments - please do not put any delayed
3566: request in between copy_adjustments and copy_freight_charges */
3567:
3568: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3569: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3570: ,p_delete => FND_API.G_TRUE
3571: ,x_return_status => l_return_status
3572: );
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3578:
3579:
3580: -- Process Requests for Pricing
3581: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3582: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3583: ,p_delete => FND_API.G_TRUE
3584: ,x_return_status => l_return_status
3585: );
3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592:
3593: -- Renga - added freight_for_included items call
3594: -- Process Requests for Freight For included items.
3595: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3596: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3597: ,p_delete => FND_API.G_TRUE
3598: ,x_return_status => l_return_status
3599: );
3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3606: -- Renga - done for freight for included items.
3607:
3608:
3609: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3610: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3611: ,p_delete => FND_API.G_TRUE
3612: ,x_return_status => l_return_status
3613: );
3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;
3619:
3620: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3621: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3622: ,p_delete => FND_API.G_TRUE
3623: ,x_return_status => l_return_status
3624: );
3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3629: END IF;
3630:
3631: -- added by lkxu
3632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3633: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3634: ,p_delete => FND_API.G_TRUE
3635: ,x_return_status => l_return_status
3636: );
3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3640: RAISE FND_API.G_EXC_ERROR;
3641: END IF;
3642:
3643: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3644: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3645: ,p_delete => FND_API.G_TRUE
3646: ,x_return_status => l_return_status
3647: );
3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3652: END IF;
3653:
3654: -- Process Delete Charges Delayed Requests
3655: Process_Request_for_ReqType
3656: (p_request_type => OE_GLOBALS.G_DELETE_CHARGES
3657: ,p_delete => FND_API.G_TRUE
3658: ,x_return_status => l_return_status
3659: );
3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3664: END IF;
3665:
3666: -- Process Tax Delayed Requests
3667: Process_Request_for_ReqType
3668: (p_request_type => OE_GLOBALS.G_TAX_LINE
3669: ,p_delete => FND_API.G_TRUE
3670: ,x_return_status => l_return_status
3671: );
3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3677:
3678:
3679: -- Process Commitment Delayed Requests
3680: Process_Request_for_ReqType
3681: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
3682: ,p_delete => FND_API.G_TRUE
3683: ,x_return_status => l_return_status
3684: );
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3689: END IF;
3690:
3691: -- Process Commitment Delayed Requests
3692: Process_Request_for_ReqType
3693: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
3694: ,p_delete => FND_API.G_TRUE
3695: ,x_return_status => l_return_status
3696: );
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3701: END IF;
3702:
3703: -- for multiple payments
3704: Process_Request_for_ReqType
3705: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
3706: ,p_delete => FND_API.G_TRUE
3707: ,x_return_status => l_return_status
3708: );
3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3713: END IF;
3714:
3715: -- for multiple payments
3716: Process_Request_for_ReqType
3717: (p_request_type => OE_GLOBALS.G_SPLIT_PAYMENT
3718: ,p_delete => FND_API.G_TRUE
3719: ,x_return_status => l_return_status
3720: );
3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;
3726:
3727: Process_Request_for_ReqType
3728: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT
3729: ,p_delete => FND_API.G_TRUE
3730: ,x_return_status => l_return_status
3731: );
3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3736: END IF;
3737:
3738: -- Process requests for Payment Verification
3739: Process_Request_for_ReqType
3740: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
3741: ,p_delete => FND_API.G_TRUE
3742: ,x_return_status => l_return_status
3743: );
3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3747: RAISE FND_API.G_EXC_ERROR;
3748: END IF;
3749:
3750: Process_Request_for_ReqType
3751: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD
3752: ,p_delete => FND_API.G_TRUE
3753: ,x_return_status => l_return_status
3754: );
3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3759: END IF;
3760:
3761: -- Process Request to create automatic attachments
3762: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3763: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3764: ,p_delete => FND_API.G_TRUE
3765: ,x_return_status => l_return_status
3766: );
3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3771: END IF;
3772:
3773: -- Process Request to copy attachments
3774: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3775: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3776: ,p_delete => FND_API.G_TRUE
3777: ,x_return_status => l_return_status
3778: );
3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3787: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');
3788: END IF;
3789:
3790: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3791: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ
3792: ,p_delete => FND_API.G_TRUE
3793: ,x_return_status => l_return_status);
3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3802: END IF;
3803:
3804: -- B2013611 reverse promotional limits
3805: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3806: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3807: ,p_delete => FND_API.G_TRUE
3808: ,x_return_status => l_return_status
3809: );
3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3814: END IF;
3815:
3816: --MRG BGN
3817: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3818: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3819: ,p_delete => FND_API.G_TRUE
3820: ,x_return_status => l_return_status
3821: );
3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3835: IF l_debug_level > 0 THEN
3836: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3837: END IF;
3838: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3839: (p_request_type => OE_GLOBALS.G_GET_COST
3840: ,p_delete => FND_API.G_TRUE
3841: ,x_return_status => l_return_status
3842: );
3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3848: --MRG END
3849:
3850:
3851: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3852: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3853: ,p_delete => FND_API.G_TRUE
3854: ,x_return_status => l_return_status
3855: );
3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3862:
3863: --process delayed requests for xml generation
3864:
3865: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3866: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3867: ,p_delete => FND_API.G_TRUE
3868: ,x_return_status => l_return_status
3869: );
3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3912:
3913:
3914: -- Process Request to Update the Internal Requisition
3915: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3916: ( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
3917: , p_delete => FND_API.G_TRUE
3918: , x_return_status => l_return_status
3919: );
3920:
3930:
3931: --process delayed requests for cancel workflow
3932:
3933: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3934: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3935: ,p_delete => FND_API.G_TRUE
3936: ,x_return_status => l_return_status
3937: );
3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3966: END LOOP;
3967:
3968: -- Process Request to Complete workflow activity
3969: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3970: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3971: ,p_delete => FND_API.G_TRUE
3972: ,x_return_status => l_return_status
3973: );
3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.ADD('Entering OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4058: END IF;
4059:
4060: IF NOT oe_globals.g_call_process_req THEN --9354229
4061: IF l_debug_level > 0 THEN
4062: oe_debug_pub.add( 'EXIT OE_ORDER_PUB.PROCESS_ORDER_ACTIONS' , 1 ) ;
4063: END IF;
4064: RETURN;
4367: ' Request ID:'||l_request_rec.entity_id);
4368: END IF;
4369:
4370: -- Action Request to Apply Automatic Attachments
4371: IF l_request_rec.request_type = OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT THEN
4372:
4373: OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments
4374: ( p_entity_code => l_request_rec.entity_code
4375: , p_entity_id => l_request_rec.entity_id
4376: , p_is_user_action => 'Y'
4377: , x_return_status => l_return_status
4378: );
4379: l_request_rec.processed := 'Y';
4380: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
4381: -- For ER 7243028
4382: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
4383: IF l_debug_level > 0 THEN
4384: oe_debug_pub.add('Before calling Price Order for :' || l_request_rec.entity_id, 5);
4378: );
4379: l_request_rec.processed := 'Y';
4380: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
4381: -- For ER 7243028
4382: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
4383: IF l_debug_level > 0 THEN
4384: oe_debug_pub.add('Before calling Price Order for :' || l_request_rec.entity_id, 5);
4385: END IF;
4386: OE_ORDER_ADJ_PVT.price_action
4393: x_return_status => l_return_status,
4394: x_msg_count => l_msg_count,
4395: x_msg_data => l_msg_data
4396: );
4397: ELSIF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
4398:
4399: l_lines_count :=0;
4400:
4401: for j in i .. p_x_request_tbl.count loop
4398:
4399: l_lines_count :=0;
4400:
4401: for j in i .. p_x_request_tbl.count loop
4402: if p_x_request_tbl(j).request_type = OE_GLOBALS.G_PRICE_ORDER and
4403: p_x_request_tbl(j).entity_code = OE_GLOBALS.G_ENTITY_LINE
4404: then
4405: l_lines_count := l_lines_count + 1;
4406: if l_lines_count = 1 then
4399: l_lines_count :=0;
4400:
4401: for j in i .. p_x_request_tbl.count loop
4402: if p_x_request_tbl(j).request_type = OE_GLOBALS.G_PRICE_ORDER and
4403: p_x_request_tbl(j).entity_code = OE_GLOBALS.G_ENTITY_LINE
4404: then
4405: l_lines_count := l_lines_count + 1;
4406: if l_lines_count = 1 then
4407: l_lines_list := p_x_request_tbl(j).entity_id;
4452: END IF;
4453:
4454: -- End of ER 7243028
4455:
4456: ELSIF l_request_rec.request_type = OE_GLOBALS.G_APPLY_HOLD THEN
4457: IF l_debug_level > 0 THEN
4458: OE_Debug_PUB.ADD('Calling Apply_Hold', 2);
4459: END IF;
4460: OE_Delayed_Requests_UTIL.Apply_Hold
4465: IF l_debug_level > 0 THEN
4466: OE_Debug_PUB.ADD('After Calling Apply_hold', 2);
4467: END IF;
4468:
4469: ELSIF l_request_rec.request_type = OE_GLOBALS.G_RELEASE_HOLD THEN
4470: IF l_debug_level > 0 THEN
4471: OE_Debug_PUB.ADD('Calling Release_Hold', 2);
4472: END IF;
4473: OE_Delayed_Requests_UTIL.Release_Hold
4477: IF l_debug_level > 0 THEN
4478: OE_Debug_PUB.ADD('After Calling Release_hold', 2);
4479: END IF;
4480: --R12 CVV2
4481: ELSIF l_request_rec.request_type = OE_GLOBALS.G_VERIFY_PAYMENT THEN
4482: /*comm rej IF nvl(l_request_rec.param2, 'HOLD') = 'REJECT' THEN
4483: l_reject_on_auth_failure := 'Y';
4484: ELSE
4485: l_reject_on_auth_failure := 'N';
4547: END IF;
4548:
4549: l_request_rec.processed := 'Y';
4550: -- to ensure verify_payment not getting called again during book_order.
4551: OE_GLOBALS.G_PAYMENT_PROCESSED := 'Y';
4552: --R12 CVV2
4553:
4554:
4555: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_BOOK_ORDER
4551: OE_GLOBALS.G_PAYMENT_PROCESSED := 'Y';
4552: --R12 CVV2
4553:
4554:
4555: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_BOOK_ORDER
4556: AND p_process_WF_requests) THEN
4557:
4558: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
4559: IF l_debug_level > 0 THEN
4554:
4555: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_BOOK_ORDER
4556: AND p_process_WF_requests) THEN
4557:
4558: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
4559: IF l_debug_level > 0 THEN
4560: OE_Debug_PUB.ADD('Calling Book Order');
4561: END IF;
4562: OE_Delayed_Requests_UTIL.Book_Order
4566: );
4567: l_request_rec.processed := 'Y';
4568: END IF;
4569:
4570: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD
4571: OR l_request_rec.request_type = OE_GLOBALS.G_GET_FREIGHT_RATES
4572: OR l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES) THEN
4573:
4574: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
4567: l_request_rec.processed := 'Y';
4568: END IF;
4569:
4570: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD
4571: OR l_request_rec.request_type = OE_GLOBALS.G_GET_FREIGHT_RATES
4572: OR l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES) THEN
4573:
4574: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
4575: IF l_debug_level > 0 THEN
4568: END IF;
4569:
4570: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD
4571: OR l_request_rec.request_type = OE_GLOBALS.G_GET_FREIGHT_RATES
4572: OR l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES) THEN
4573:
4574: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
4575: IF l_debug_level > 0 THEN
4576: OE_DEBUG_PUB.Add('Calling Get Ship Method');
4591: l_request_rec.processed := 'Y';
4592:
4593: END IF;
4594:
4595: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR
4596: l_request_rec.request_type = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET ) AND
4597: l_request_rec.param5 IS NOT NULL THEN
4598:
4599: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4592:
4593: END IF;
4594:
4595: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR
4596: l_request_rec.request_type = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET ) AND
4597: l_request_rec.param5 IS NOT NULL THEN
4598:
4599: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4600:
4597: l_request_rec.param5 IS NOT NULL THEN
4598:
4599: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4600:
4601: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
4602: OE_Delayed_Requests_UTIL.Fulfillment_Sets
4603: ( p_entity_code => l_request_rec.entity_code
4604: , p_entity_id => l_request_rec.entity_id
4605: , p_action_code => l_request_rec.request_type
4609: l_request_rec.processed := 'Y';
4610: END IF;
4611: END IF;
4612:
4613: ELSIF l_request_rec.request_type = OE_GLOBALS.G_DELINK_CONFIG
4614: THEN
4615:
4616: OE_Delayed_Requests_UTIL.DELINK_CONFIG
4617: ( p_line_id => l_request_rec.entity_id
4618: , x_return_status => l_request_rec.return_status
4619: );
4620: l_request_rec.processed := 'Y';
4621:
4622: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_MATCH_AND_RESERVE
4623: AND p_process_WF_requests) THEN
4624:
4625: OE_Delayed_Requests_UTIL.MATCH_AND_RESERVE
4626: ( p_line_id => l_request_rec.entity_id
4627: , x_return_status => l_request_rec.return_status
4628: );
4629: l_request_rec.processed := 'Y';
4630:
4631: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_LINK_CONFIG
4632: AND p_process_WF_requests)
4633: THEN
4634: OE_Config_UTIL.LINK_CONFIG
4635: ( p_line_id => l_request_rec.entity_id
4636: , p_config_item_id => to_number(l_request_rec.param1)
4637: , x_return_status => l_request_rec.return_status );
4638: l_request_rec.processed := 'Y';
4639: --Customer Acceptance Project actions
4640: ELSIF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4641: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4642: p_process_WF_requests THEN
4643:
4644: OE_ACCEPTANCE_PVT.Process_Acceptance(p_request_tbl => p_x_request_tbl
4637: , x_return_status => l_request_rec.return_status );
4638: l_request_rec.processed := 'Y';
4639: --Customer Acceptance Project actions
4640: ELSIF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4641: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4642: p_process_WF_requests THEN
4643:
4644: OE_ACCEPTANCE_PVT.Process_Acceptance(p_request_tbl => p_x_request_tbl
4645: ,x_return_status => l_return_status);
4651: /** the WF requests are NOT marked invalid in the first call but **/
4652: /** processed in the second call **/
4653: ELSIF p_process_WF_requests THEN
4654:
4655: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
4656: OE_MSG_PUB.update_msg_context(
4657: p_header_id => l_request_rec.entity_id);
4658:
4659: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4655: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
4656: OE_MSG_PUB.update_msg_context(
4657: p_header_id => l_request_rec.entity_id);
4658:
4659: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4660: OE_MSG_PUB.update_msg_context(
4661: p_line_id => l_request_rec.entity_id);
4662: END IF;
4663: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4673: THEN
4674: RAISE FND_API.G_EXC_ERROR;
4675: END IF;
4676:
4677: IF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4678: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4679: p_process_WF_requests THEN
4680: -- do not override return status set by process acceptance
4681: null;
4674: RAISE FND_API.G_EXC_ERROR;
4675: END IF;
4676:
4677: IF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4678: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4679: p_process_WF_requests THEN
4680: -- do not override return status set by process acceptance
4681: null;
4682: else
4804: G_Delayed_Requests(i).request_type);
4805:
4806: END IF;
4807:
4808: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_VERSION_AUDIT) THEN --Bug # 5206049
4809: version_request_id := i;
4810: END IF;
4811: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_DELETE_OPTION) THEN --Bug # 12316022
4812: config_req_id := i;
4807:
4808: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_VERSION_AUDIT) THEN --Bug # 5206049
4809: version_request_id := i;
4810: END IF;
4811: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_DELETE_OPTION) THEN --Bug # 12316022
4812: config_req_id := i;
4813: END IF;
4814: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_VALIDATE_CONFIGURATION) THEN --Bug # 12316022
4815: del_option_req_id := i;
4810: END IF;
4811: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_DELETE_OPTION) THEN --Bug # 12316022
4812: config_req_id := i;
4813: END IF;
4814: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_VALIDATE_CONFIGURATION) THEN --Bug # 12316022
4815: del_option_req_id := i;
4816: END IF;
4817:
4818:
4907: END IF;
4908: -- Bug 3800577
4909: -- Reset versioning globals if version request is deleted
4910: IF G_Delayed_Requests(req_ind).request_type
4911: = OE_GLOBALS.G_VERSION_AUDIT
4912: THEN
4913: IF l_debug_level > 0 THEN
4914: oe_debug_pub.add('reset versioning globals');
4915: END IF;
4974: END IF;
4975:
4976: x_return_status := FND_API.G_RET_STS_SUCCESS;
4977:
4978: IF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO THEN
4979: IF l_debug_level > 0 THEN
4980: oe_debug_pub.add('.. schedule_ato '|| p_request_rec.entity_id, 1);
4981: END IF;
4982:
4987: END IF;
4988: WHILE K is not null
4989: LOOP
4990: IF G_Delayed_Requests(K).request_type
4991: = OE_GLOBALS.G_SCHEDULE_ATO AND
4992: G_Delayed_Requests(K).param2 = p_request_rec.param2 AND
4993: G_Delayed_Requests(K).param9 = 'Y'
4994: THEN
4995: IF l_debug_level > 0 THEN
5016: ( p_request_rec => p_request_rec
5017: ,x_return_status => x_return_status);
5018: END IF;
5019:
5020: ELSIF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_SMC THEN
5021: IF l_debug_level > 0 THEN
5022: oe_debug_pub.add('calling schedule_smc '|| p_request_rec.param24 , 1);
5023: END IF;
5024:
5025: OE_Config_Schedule_Pvt.Schedule_SMC
5026: ( p_request_rec => p_request_rec
5027: ,x_return_status => x_return_status);
5028:
5029: ELSIF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_NONSMC
5030: THEN
5031: I := 0;
5032: K := p_request_ind;
5033:
5033:
5034: WHILE K is not null
5035: LOOP
5036: IF G_Delayed_Requests(K).request_type
5037: = OE_GLOBALS.G_SCHEDULE_NONSMC AND
5038: G_Delayed_Requests(K).param2 = p_request_rec.param2 AND
5039: G_Delayed_Requests(K).param1 = p_request_rec.param1
5040: THEN
5041:
5076: ( p_request_tbl => l_request_tbl
5077: ,p_res_changes => l_res_changes
5078: ,x_return_status => x_return_status);
5079:
5080: ELSIF p_request_rec.request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
5081: if l_debug_level > 0 then
5082: oe_debug_pub.add('6663462 : calling delayed_schedule ' , 1);
5083: end if;
5084:
5121: BEGIN
5122:
5123: /* Added the following condition to fix the fp bug 3498435 */
5124:
5125: IF p_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
5126:
5127:
5128: IF l_debug_level > 0 THEN
5129: oe_debug_pub.add('Entering check_pricing_request in Oe_Delayed_Request_PVT.',1);
5366: p_request_unique_key1 => 'BATCH',
5367: p_request_unique_key2 => 'Y',
5368: x_return_status => l_return_status);
5369:
5370: log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5371: p_entity_id => p_request_rec.entity_id,
5372: p_requesting_entity_code => p_request_rec.entity_code,
5373: p_requesting_entity_id => p_request_rec.entity_id,
5374: p_request_unique_key1 => 'LINE',
5388: -- delete all other request for G_PRICE_ORDER.
5389: IF l_debug_level > 0 THEN
5390: oe_debug_pub.add('delete all other price_order request.',1);
5391: END IF;
5392: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
5393: p_entity_id => p_request_rec.entity_id,
5394: p_request_type => p_request_rec.request_type,
5395: p_request_unique_key1 => 'ORDER',
5396: x_return_status => l_return_status);
5393: p_entity_id => p_request_rec.entity_id,
5394: p_request_type => p_request_rec.request_type,
5395: p_request_unique_key1 => 'ORDER',
5396: x_return_status => l_return_status);
5397: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
5398: p_entity_id => p_request_rec.entity_id,
5399: p_request_type => p_request_rec.request_type,
5400: p_request_unique_key1 => 'BATCH',
5401: x_return_status => l_return_status);
5401: x_return_status => l_return_status);
5402: IF p_request_rec.request_unique_key1 = 'BATCH,BOOK'
5403: AND nvl(p_request_rec.request_unique_key2,'N') = 'N' THEN
5404: -- event is 'BATCH,BOOK'
5405: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
5406: p_entity_id => p_request_rec.entity_id,
5407: p_request_type => p_request_rec.request_type,
5408: p_request_unique_key1 => 'ORDER,BOOK',
5409: x_return_status => l_return_status);
5406: p_entity_id => p_request_rec.entity_id,
5407: p_request_type => p_request_rec.request_type,
5408: p_request_unique_key1 => 'ORDER,BOOK',
5409: x_return_status => l_return_status);
5410: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
5411: p_entity_id => p_request_rec.entity_id,
5412: p_request_type => p_request_rec.request_type,
5413: p_request_unique_key1 => 'BATCH,BOOK',
5414: x_return_status => l_return_status);
5476: p_request_unique_key1 => 'BATCH,BOOK',
5477: p_request_unique_key2 => 'Y',
5478: x_return_status => l_return_status);
5479:
5480: log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5481: p_entity_id => p_request_rec.entity_id,
5482: p_requesting_entity_code => p_request_rec.entity_code,
5483: p_requesting_entity_id => p_request_rec.entity_id,
5484: p_request_unique_key1 => 'LINE',
5494:
5495: END IF;
5496:
5497: /* New code added to fix the fp bug 3498435 */
5498: ELSIF p_request_rec.request_type = OE_GLOBALS.G_PRICE_LINE THEN
5499: IF l_debug_level > 0 THEN
5500: oe_debug_pub.add('3498435: Entering check_pricing_request '||p_request_rec.request_unique_key1,1);
5501: END IF;
5502: IF p_request_rec.request_unique_key1 = 'LINE' THEN