[Home] [Help]
240: END IF;
241: G_Delayed_Requests(p_request_ind).processed := 'I';
242:
243: IF l_debug_level > 0 THEN
244: IF OE_GLOBALS.G_CASCADING_REQUEST_LOGGED THEN
245: oe_debug_pub.add('cascade flag set to true');
246: ELSE
247: oe_debug_pub.add('cascade flag set to false');
248: END IF;
258: -- back to the header for credit card payments.
259: -- 3) Apply Automatic Attachments: never results in an update back to order/lines.
260: -- NOTE: All other delayed requests also need to be evaluated so
261: -- that cascade flag is set in the request and not here.
262: IF OE_GLOBALS.G_PROCESS_OBJECTS_FLAG = TRUE THEN
263:
264: IF l_Request_type NOT IN ('RECORD_HISTORY'
265: ,OE_GLOBALS.G_PRICE_ORDER
266: ,OE_GLOBALS.G_PRICE_ADJ
261: -- that cascade flag is set in the request and not here.
262: IF OE_GLOBALS.G_PROCESS_OBJECTS_FLAG = TRUE THEN
263:
264: IF l_Request_type NOT IN ('RECORD_HISTORY'
265: ,OE_GLOBALS.G_PRICE_ORDER
266: ,OE_GLOBALS.G_PRICE_ADJ
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
262: IF OE_GLOBALS.G_PROCESS_OBJECTS_FLAG = TRUE THEN
263:
264: IF l_Request_type NOT IN ('RECORD_HISTORY'
265: ,OE_GLOBALS.G_PRICE_ORDER
266: ,OE_GLOBALS.G_PRICE_ADJ
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
263:
264: IF l_Request_type NOT IN ('RECORD_HISTORY'
265: ,OE_GLOBALS.G_PRICE_ORDER
266: ,OE_GLOBALS.G_PRICE_ADJ
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
271: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
264: IF l_Request_type NOT IN ('RECORD_HISTORY'
265: ,OE_GLOBALS.G_PRICE_ORDER
266: ,OE_GLOBALS.G_PRICE_ADJ
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
271: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
272: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
265: ,OE_GLOBALS.G_PRICE_ORDER
266: ,OE_GLOBALS.G_PRICE_ADJ
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
271: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
272: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
273: THEN
266: ,OE_GLOBALS.G_PRICE_ADJ
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
271: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
272: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
273: THEN
274: IF l_debug_level > 0 THEN
267: ,OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
271: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
272: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
273: THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('****** process_obj=>delayed req execution ****', 1);
268: ,OE_GLOBALS.G_VERIFY_PAYMENT
269: ,OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
270: ,OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
271: ,OE_GLOBALS.G_GENERATE_XML_REQ_HDR
272: ,OE_GLOBALS.G_GENERATE_XML_REQ_LN)
273: THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('****** process_obj=>delayed req execution ****', 1);
276: END IF;
273: THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('****** process_obj=>delayed req execution ****', 1);
276: END IF;
277: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
278: END IF;
279:
280: END IF;
281:
281:
282:
283: IF l_Request_type = 'RECORD_HISTORY' THEN
284: NULL;
285: ELSIF l_request_type = OE_GLOBALS.G_CHECK_PERCENTAGE
286: THEN
287:
288: OE_DELAYED_REQUESTS_UTIL.check_percentage
289: (p_request_rec => l_request_rec,
288: OE_DELAYED_REQUESTS_UTIL.check_percentage
289: (p_request_rec => l_request_rec,
290: x_return_status => l_return_status);
291:
292: ELSIF l_request_type = OE_GLOBALS.G_CHECK_DUPLICATE THEN
293:
294: OE_DELAYED_REQUESTS_UTIL.check_duplicate
295: (p_request_rec => l_request_rec,
296: x_return_status => l_return_status);
294: OE_DELAYED_REQUESTS_UTIL.check_duplicate
295: (p_request_rec => l_request_rec,
296: x_return_status => l_return_status);
297:
298: ELSIF l_request_type = OE_GLOBALS.G_CANCEL_WF THEN
299:
300: OE_SALES_CAN_UTIL.Cancel_Wf
301: (x_request_rec => l_request_rec,
302: x_return_status => l_return_status);
300: OE_SALES_CAN_UTIL.Cancel_Wf
301: (x_request_rec => l_request_rec,
302: x_return_status => l_return_status);
303:
304: ELSIF l_request_type = OE_GLOBALS.G_CHECK_FIXED_PRICE
305: THEN
306:
307: OE_DELAYED_REQUESTS_UTIL.check_fixed_price
308: (p_request_rec => l_request_rec,
307: OE_DELAYED_REQUESTS_UTIL.check_fixed_price
308: (p_request_rec => l_request_rec,
309: x_return_status => l_return_status);
310:
311: ELSIF l_request_type = OE_GLOBALS.G_PRICE_ADJ THEN
312: IF l_debug_level > 0 THEN
313: Oe_Debug_pub.Add('Before Executing Delayed request Price Adjustment for '||l_request_rec.entity_id);
314: END IF;
315: /* 1905650
314: END IF;
315: /* 1905650
316: G_PRICE_ADJ request is now logged against LINE entity
317: */
318: If l_entity_code = OE_GLOBALS.G_ENTITY_LINE Then
319:
320: oe_order_adj_pvt.Price_Adjustments(
321: X_Return_Status => l_Return_Status
322: ,p_Header_id => Null
336: IF l_debug_level > 0 THEN
337: Oe_Debug_pub.Add('After Executing Delayed request Price Adj for '||l_request_rec.entity_id);
338: END IF;
339: ELSIF l_request_type =
340: OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL then
341: if l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT
342: OR l_entity_code = OE_GLOBALS.G_ENTITY_ALL then -- bug 5746190
343: OE_DELAYED_REQUESTS_UTIL.Validate_HSC_QUOTA_TOTAL
344: ( x_return_status =>l_return_status
337: Oe_Debug_pub.Add('After Executing Delayed request Price Adj for '||l_request_rec.entity_id);
338: END IF;
339: ELSIF l_request_type =
340: OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL then
341: if l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT
342: OR l_entity_code = OE_GLOBALS.G_ENTITY_ALL then -- bug 5746190
343: OE_DELAYED_REQUESTS_UTIL.Validate_HSC_QUOTA_TOTAL
344: ( x_return_status =>l_return_status
345: ,p_header_id =>to_number(l_request_rec.param1)
338: END IF;
339: ELSIF l_request_type =
340: OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL then
341: if l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT
342: OR l_entity_code = OE_GLOBALS.G_ENTITY_ALL then -- bug 5746190
343: OE_DELAYED_REQUESTS_UTIL.Validate_HSC_QUOTA_TOTAL
344: ( x_return_status =>l_return_status
345: ,p_header_id =>to_number(l_request_rec.param1)
346: );
346: );
347: end if;
348:
349: ELSIF l_request_type =
350: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
351: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
352: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
353: ( x_return_status =>l_return_status
354: ,p_line_id =>to_number(l_request_rec.param1)
347: end if;
348:
349: ELSIF l_request_type =
350: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
351: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
352: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
353: ( x_return_status =>l_return_status
354: ,p_line_id =>to_number(l_request_rec.param1)
355: );
355: );
356: end if;
357:
358: ELSIF l_request_type =
359: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
360: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
361: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
362: ( x_return_status =>l_return_status
363: ,p_line_id =>to_number(l_request_rec.param1)
356: end if;
357:
358: ELSIF l_request_type =
359: OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL then
360: if l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT then
361: OE_DELAYED_REQUESTS_UTIL.Validate_LSC_QUOTA_TOTAL
362: ( x_return_status =>l_return_status
363: ,p_line_id =>to_number(l_request_rec.param1)
364: );
364: );
365: end if;
366:
367: ELSIF l_request_type =
368: OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT then
369: IF l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT THEN
370: OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit
371: ( x_return_status =>l_return_status
372: ,p_request_rec =>l_request_rec
365: end if;
366:
367: ELSIF l_request_type =
368: OE_GLOBALS.G_CASCADE_SERVICE_SCREDIT then
369: IF l_entity_code = OE_GLOBALS.G_ENTITY_Line_SCREDIT THEN
370: OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit
371: ( x_return_status =>l_return_status
372: ,p_request_rec =>l_request_rec
373: );
373: );
374: end if;
375:
376:
377: ELSIF (l_request_type = OE_GLOBALS.G_CREATE_SETS) then
378: OE_DELAYED_REQUESTS_UTIL.Insert_Set
379: (p_request_rec => l_request_rec,
380: x_return_status => l_return_status);
381: ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
377: ELSIF (l_request_type = OE_GLOBALS.G_CREATE_SETS) then
378: OE_DELAYED_REQUESTS_UTIL.Insert_Set
379: (p_request_rec => l_request_rec,
380: x_return_status => l_return_status);
381: ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
382: IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
383: /* Commenting out nocopy per Rupal */
384:
385: null;
378: OE_DELAYED_REQUESTS_UTIL.Insert_Set
379: (p_request_rec => l_request_rec,
380: x_return_status => l_return_status);
381: ELSIF l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
382: IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
383: /* Commenting out nocopy per Rupal */
384:
385: null;
386: /* OE_Process_Models.Insert_Into_Line_Sets
389: ,p_set_type => 'ALL'
390: ,x_return_status =>l_return_status
391: ); */
392: END IF;
393: ELSIF l_request_type = OE_GLOBALS.G_VALIDATE_LINE_SET then
394: oe_delayed_requests_util.validate_line_set(
395: p_line_set_id => l_request_rec.entity_id,
396: x_return_status => l_return_status);
397: ELSIF l_request_type =
394: oe_delayed_requests_util.validate_line_set(
395: p_line_set_id => l_request_rec.entity_id,
396: x_return_status => l_return_status);
397: ELSIF l_request_type =
398: OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP then
399: OE_DELAYED_REQUESTS_UTIL.DFLT_Hscredit_Primary_Srep
400: ( x_return_status =>l_return_status
401: ,p_header_id =>to_number(l_request_rec.param1)
402: ,p_salesrep_id =>to_number(l_request_rec.param2)
403: );
404:
405:
406: ELSIF l_request_type =
407: OE_GLOBALS.G_VERIFY_PAYMENT then
408: OE_DELAYED_REQUESTS_UTIL.Verify_Payment
409: ( x_return_status =>l_return_status
410: ,p_header_id => l_entity_id
411: );
410: ,p_header_id => l_entity_id
411: );
412:
413: ELSIF l_request_type =
414: OE_GLOBALS.G_INSERT_RMA then
415: OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_SCREDIT_ADJUSTMENT
416: ( x_return_status =>l_return_status
417: ,p_line_id => l_entity_id
418: );
421: ,p_line_id => l_entity_id
422: );
423: -- Do not call INSERT_RMA_LOT_SERIAL for system split.
424: -- Bug 4651421
425: IF NOT((l_request_rec.param1 = OE_GLOBALS.G_OPR_UPDATE and
426: nvl(l_request_rec.param2,'USER') = 'SYSTEM' and
427: NVL(l_request_rec.param3,'X') = 'SPLIT')
428: OR
429: (l_request_rec.param1 = OE_GLOBALS.G_OPR_CREATE AND
425: IF NOT((l_request_rec.param1 = OE_GLOBALS.G_OPR_UPDATE and
426: nvl(l_request_rec.param2,'USER') = 'SYSTEM' and
427: NVL(l_request_rec.param3,'X') = 'SPLIT')
428: OR
429: (l_request_rec.param1 = OE_GLOBALS.G_OPR_CREATE AND
430: l_request_rec.param4 IS NOT NULL AND
431: nvl(l_request_rec.param2, 'USER') = 'SYSTEM'))
432: THEN
433: OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_LOT_SERIAL
434: ( x_return_status =>l_return_status
435: ,p_line_id => l_entity_id
436: );
437: END IF;
438: ELSIF l_request_type = OE_GLOBALS.G_TAX_LINE then
439:
440: -- Renga - changed so that we call Process_Tax
441: l_entity_id_tbl(1).entity_id := l_entity_id;
442: -- l_entity_id_tbl(l_count).request_ind := 1;
454: (p_Entity_id_tbl => l_entity_id_tbl
455: ,x_return_status => l_return_status
456: );
457:
458: ELSIF l_request_type = OE_GLOBALS.G_SPLIT_HOLD then
459: OE_DELAYED_REQUESTS_UTIL.Split_hold
460: ( p_entity_code => l_request_rec.entity_code
461: ,p_entity_id => l_request_rec.entity_id
462: ,p_split_from_line_id => l_request_rec.param1
462: ,p_split_from_line_id => l_request_rec.param1
463: ,x_return_status => l_return_status
464: );
465: ELSIF l_request_type =
466: OE_GLOBALS.G_EVAL_HOLD_SOURCE then
467: OE_DELAYED_REQUESTS_UTIL.Eval_Hold_Source
468: ( x_return_status => l_return_status
469: ,p_entity_code => l_request_rec.entity_code
470: ,p_entity_id => l_request_rec.entity_id
472: ,p_hold_entity_id => l_request_rec.param2
473: );
474:
475: /* 1739574 */
476: ELSIF l_request_type = OE_GLOBALS.G_COMPLETE_ACTIVITY THEN
477: IF l_debug_level > 0 THEN
478: 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);
479: END IF;
480: wf_engine.CompleteActivityInternalName(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,l_request_rec.param4);
480: wf_engine.CompleteActivityInternalName(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,l_request_rec.param4);
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.ADD('Returned from wf_engine.CompleteActivityInternalName ',3);
483: END IF;
484: ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_SHIPPING THEN
485:
486: OE_Delayed_Requests_UTIL.Update_Shipping
487: ( p_update_shipping_tbl => g_delayed_requests
488: , p_line_id => l_request_rec.entity_id
489: , p_operation => l_request_rec.request_unique_key1
490: , x_return_status => l_return_status
491: );
492:
493: ELSIF l_request_rec.request_type = OE_GLOBALS.G_SHIP_CONFIRMATION THEN
494:
495: OE_Delayed_Requests_UTIL.Ship_Confirmation
496: ( p_ship_confirmation_tbl => g_delayed_requests
497: , p_line_id => l_request_rec.entity_id
511: -- For details on IR ISO CMS project, please refer to FOL >
512: -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
513:
514:
515: ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
516:
517: IF NVL(l_request_rec.param2,'N') = 'Y' THEN
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add('Requisition Header Cancellation is TRUE',5);
529: END IF;
530: l_cancel_order := FALSE;
531: END IF;
532:
533: IF l_request_rec.entity_code = OE_Globals.G_Entity_Header THEN
534: l_header_id := l_request_rec.entity_id;
535: l_line_id := NULL;
536: ELSIF l_request_rec.entity_code = OE_Globals.G_Entity_Line THEN
537: l_header_id := l_request_rec.request_unique_key1;
532:
533: IF l_request_rec.entity_code = OE_Globals.G_Entity_Header THEN
534: l_header_id := l_request_rec.entity_id;
535: l_line_id := NULL;
536: ELSIF l_request_rec.entity_code = OE_Globals.G_Entity_Line THEN
537: l_header_id := l_request_rec.request_unique_key1;
538: l_line_id := l_request_rec.entity_id;
539: END IF;
540:
556: /* IR ISO Change Management Ends */
557:
558:
559: ELSIF l_request_type =
560: OE_GLOBALS.G_CASCADE_CHANGES then
561: IF l_debug_level > 0 THEN
562: oe_debug_pub.add('Performing Delayed Req for Cascade Changes',1);
563: END IF;
564:
571: oe_debug_pub.add('done Delayed Req for Cascade Changes',1);
572: END IF;
573:
574: ELSIF l_request_type =
575: OE_GLOBALS.G_CHANGE_CONFIGURATION then
576:
577: oe_debug_pub.add('Performing Delayed Req for Change Config',1);
578:
579: OE_CONFIG_UTIL.CHANGE_CONFIGURATION
584: oe_debug_pub.add('Done Delayed Req for Change Config',1);
585: END IF;
586:
587: ELSIF l_request_type =
588: OE_GLOBALS.G_CREATE_RESERVATIONS then
589: OE_DELAYED_REQUESTS_UTIL.SPLIT_RESERVATIONS
590: ( p_reserved_line_id => l_request_rec.entity_id
591: , p_ordered_quantity => to_number(l_request_rec.param1)
592: , p_reserved_quantity => to_number(l_request_rec.param2)
593: , x_return_status => l_return_status
594: );
595:
596: ELSIF l_request_type =
597: OE_GLOBALS.G_COPY_CONFIGURATION then
598: OE_Config_Pvt.Copy_Config
599: ( p_top_model_line_id => l_request_rec.entity_id ,
600: p_config_hdr_id => l_request_rec.param1 ,
601: p_config_rev_nbr => l_request_rec.param2 ,
604: x_return_status => l_return_status
605: );
606:
607: ELSIF l_request_type =
608: OE_GLOBALS.G_COMPLETE_CONFIGURATION then
609: OE_DELAYED_REQUESTS_UTIL.COMPLETE_CONFIGURATION
610: ( p_top_model_line_id => l_request_rec.entity_id
611: , x_return_status => l_return_status
612: );
612: );
613: -- No Processing here. The processing will be done in
614: -- Process_Delayed_Requests at the Commit Time.
615:
616: ELSIF l_request_type = OE_GLOBALS.G_DROPSHIP_CMS THEN
617: RETURN;
618:
619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
625: IF l_debug_level > 0 THEN
626: oe_debug_pub.add('upd: processed with cfg val', 3);
627: END IF;
628: RETURN;
626: oe_debug_pub.add('upd: processed with cfg val', 3);
627: END IF;
628: RETURN;
629:
630: ELSIF l_request_type = OE_GLOBALS.G_DELETE_OPTION THEN
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add('del: processed with cfg val', 3);
633: END IF;
634: RETURN;
633: END IF;
634: RETURN;
635:
636: ELSIF l_request_type =
637: OE_GLOBALS.G_VALIDATE_CONFIGURATION
638: THEN
639:
640: -- Get the delayed requests logged for deletions and updatations
641: -- which needs to be passed to validate_configuration.
646:
647: WHILE K is not null -- while loop safe that tbl.first to last
648: LOOP
649:
650: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
651: G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
652: THEN
653:
654: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
647: WHILE K is not null -- while loop safe that tbl.first to last
648: LOOP
649:
650: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
651: G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
652: THEN
653:
654: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
655: AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
650: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION OR
651: G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
652: THEN
653:
654: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
655: AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
656: THEN
657: l_d_index := l_d_index + 1;
658: l_deleted_options_tbl(l_d_index) :=
658: l_deleted_options_tbl(l_d_index) :=
659: g_delayed_requests(K);
660: END IF;
661:
662: IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
663: AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
664: THEN
665: l_u_index := l_u_index + 1;
666: l_updated_options_tbl(l_u_index) :=
692:
693: WHILE K is not null
694: LOOP
695: IF (G_Delayed_Requests(K).request_type =
696: OE_GLOBALS.G_DELETE_OPTION OR
697: G_Delayed_Requests(K).request_type =
698: OE_GLOBALS.G_UPDATE_OPTION ) AND
699: G_Delayed_Requests(K).param1 = l_request_rec.entity_id
700: THEN
694: LOOP
695: IF (G_Delayed_Requests(K).request_type =
696: OE_GLOBALS.G_DELETE_OPTION OR
697: G_Delayed_Requests(K).request_type =
698: OE_GLOBALS.G_UPDATE_OPTION ) AND
699: G_Delayed_Requests(K).param1 = l_request_rec.entity_id
700: THEN
701: G_Delayed_Requests.delete(K);
702: END IF;
706: END LOOP;
707: END IF;
708:
709:
710: ELSIF l_request_type = OE_GLOBALS.G_CTO_CHANGE THEN
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add('cto: processed with notification', 3);
713: END IF;
714: RETURN;
713: END IF;
714: RETURN;
715:
716: ELSIF l_request_type =
717: OE_GLOBALS.G_CTO_NOTIFICATION then
718: -- loop over and call cto
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add('cto notification excecution', 2);
721: END IF;
724:
725: WHILE K is not null
726: LOOP
727: IF G_Delayed_Requests(K).request_type =
728: OE_GLOBALS.G_CTO_CHANGE AND
729: G_Delayed_Requests(K).param3 = l_request_rec.entity_id
730: THEN
731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add(K || 'cto change req ', 3);
831:
832: WHILE K is not null
833: LOOP
834: IF G_Delayed_Requests(K).request_type =
835: OE_GLOBALS.G_CTO_CHANGE AND
836: G_Delayed_Requests(K).param3 = l_request_rec.entity_id
837: THEN
838: G_Delayed_Requests.delete(K);
839: END IF;
842:
843: END LOOP;
844: END IF;
845: ELSIF l_request_type =
846: OE_GLOBALS.G_GROUP_SET THEN
847:
848:
849: l_index := 0;
850: K := G_Delayed_Requests.FIRST;
852: WHILE K is not null -- while loop safer than tbl.first to last
853: LOOP
854:
855: IF (G_Delayed_Requests(K).request_type =
856: OE_GLOBALS.G_GROUP_SET)
857: THEN
858:
859: l_index := l_index + 1;
860: l_sch_set_tbl(l_index) := g_delayed_requests(K);
878: WHILE K is not null -- while loop safer than tbl.first to last
879: LOOP
880:
881: IF G_Delayed_Requests(K).request_type =
882: OE_GLOBALS.G_GROUP_SET
883: THEN
884: g_delayed_requests(K).processed := 'Y';
885: END IF;
886:
888:
889: END LOOP;
890: l_sch_set_tbl.delete;
891: ELSIF l_request_type =
892: OE_GLOBALS.G_SPLIT_SCHEDULE THEN
893:
894:
895: l_index := 0;
896: K := G_Delayed_Requests.FIRST;
898: WHILE K is not null -- while loop safer than tbl.first to last
899: LOOP
900:
901: IF (G_Delayed_Requests(K).request_type =
902: OE_GLOBALS.G_SPLIT_SCHEDULE)
903: THEN
904:
905: l_index := l_index + 1;
906: l_sch_set_tbl(l_index) := g_delayed_requests(K);
918: WHILE K is not null -- while loop safer than tbl.first to last
919: LOOP
920:
921: IF G_Delayed_Requests(K).request_type =
922: OE_GLOBALS.G_SPLIT_SCHEDULE
923: THEN
924: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
925: THEN
926: g_delayed_requests(K).processed := 'Y';
933:
934: END LOOP;
935: l_sch_set_tbl.delete;
936: ELSIF l_request_type =
937: OE_GLOBALS.G_INSERT_SERVICE then
938: OE_DELAYED_REQUESTS_UTIL.INSERT_SERVICE_FOR_OPTIONS
939: ( x_return_status => l_return_status
940: , p_serviced_line_id => l_entity_id
941: );
940: , p_serviced_line_id => l_entity_id
941: );
942:
943: /* BUG 2013611 - Increment promotional balances in response to cancellations */
944: ELSIF l_request_rec.request_type = OE_GLOBALS.G_REVERSE_LIMITS THEN
945: IF l_debug_level > 0 THEN
946: oe_debug_pub.add('About to PERFORM Delayed Request for Reverse Limits',1);
947: END IF;
948:
961: END IF;
962: /* BUG 2013611 END */
963:
964: -- Freight Rating.
965: ELSIF l_request_rec.request_type = OE_GLOBALS.G_FREIGHT_RATING THEN
966: IF l_debug_level > 0 THEN
967: Oe_Debug_pub.Add('Before Executing Delayed request Freight Rating for header: '||l_request_rec.entity_id, 3);
968: END IF;
969: OE_FTE_INTEGRATION_PVT.Process_FTE_Action
977: ,x_msg_data => l_msg_data
978: );
979:
980:
981: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_LINE THEN
982: IF l_debug_level > 0 THEN
983: Oe_Debug_pub.Add('Before Executing Delayed request Price line for '||l_request_rec.entity_id);
984: Oe_Debug_pub.Add('The Event is '||l_request_rec.param2);
985: END IF;
1007: );
1008: IF l_debug_level > 0 THEN
1009: Oe_Debug_pub.Add('After Executing Delayed request Price line for '||l_request_rec.entity_id);
1010: END IF;
1011: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
1012: IF l_debug_level > 0 THEN
1013: Oe_Debug_pub.Add('Before Executing Delayed request Price line for '||l_request_rec.entity_id);
1014: Oe_Debug_pub.Add('Before Header Price');
1015: Oe_Debug_pub.Add('The Event is '||l_request_rec.param2);
1041: Oe_Debug_pub.Add('After Executing Delayed request Price line for '||l_request_rec.entity_id);
1042: END IF;
1043:
1044: /* Customer Acceptance - Start */
1045: ELSIF l_request_rec.request_type = OE_GLOBALS.G_DFLT_CONTINGENCY_ATTRIBUTES THEN
1046: IF l_debug_level > 0 THEN
1047: Oe_Debug_pub.Add('Before Defaulting Contingency Attributes ');
1048: END IF;
1049: OE_ACCEPTANCE_UTIL.Default_contingency_Attributes();
1051: Oe_Debug_pub.Add('After Defaulting Contingency Attributes ');
1052: END IF;
1053: /* Customer Acceptance - End */
1054:
1055: ELSIF (l_request_type = OE_GLOBALS.G_PROCESS_ADJUSTMENTS) then
1056: if l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
1057: IF l_debug_level > 0 THEN
1058: oe_debug_pub.add('count is : ' || G_Delayed_Requests.count );
1059: END IF;
1052: END IF;
1053: /* Customer Acceptance - End */
1054:
1055: ELSIF (l_request_type = OE_GLOBALS.G_PROCESS_ADJUSTMENTS) then
1056: if l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
1057: IF l_debug_level > 0 THEN
1058: oe_debug_pub.add('count is : ' || G_Delayed_Requests.count );
1059: END IF;
1060: l_prc_adj_index := G_Delayed_Requests.first;
1102:
1103: end if; /* entity_code = G_ENTITY_LINE */
1104:
1105: -- Delayed Request to Apply Automatic Attachments
1106: ELSIF l_request_type = OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT THEN
1107:
1108: OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments
1109: ( p_entity_code => l_request_rec.entity_code
1110: , p_entity_id => l_request_rec.entity_id
1111: , p_is_user_action => 'N'
1112: , x_return_status => l_return_status
1113: );
1114:
1115: ELSIF l_request_type = OE_GLOBALS.G_COPY_ATCHMT THEN
1116:
1117: OE_DELAYED_REQUESTS_UTIL.Copy_Attachments
1118: (p_entity_code => l_request_rec.entity_code
1119: ,p_from_entity_id =>
1122: ,p_manual_attachments_only => l_request_rec.param2
1123: ,x_return_status => l_return_status
1124: );
1125:
1126: ELSIF l_request_type = OE_GLOBALS.G_COPY_ADJUSTMENTS THEN
1127:
1128: OE_Line_Adj_Util.copy_adjustment_lines
1129: (p_from_line_id => to_number(l_request_rec.param2)
1130: ,p_to_line_id => l_request_rec.entity_id
1139: --RT}
1140: ,x_return_status => l_return_status
1141: );
1142: /* Added for Bug # 1559906 */
1143: ELSIF l_request_type = OE_GLOBALS.G_COPY_FREIGHT_CHARGES THEN
1144:
1145: OE_Header_Adj_Util.copy_freight_charges
1146: ( p_from_header_id => to_number(l_request_rec.param2)
1147: , p_to_header_id => l_request_rec.entity_id
1150: );
1151:
1152:
1153: /* Added the new delayed req for Bug # 2170086 */
1154: ELSIF l_request_type = OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS THEN
1155:
1156: OE_Header_Adj_Util.copy_header_adjustments
1157: ( p_from_header_id => to_number(l_request_rec.param2)
1158: , p_to_header_id => l_request_rec.entity_id
1163:
1164:
1165: /* csheu added for bug #1533658 */
1166:
1167: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_SERVICE THEN
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add('CSH-- Before calls OE_Service_Util.cascade_changes', 1);
1170: END IF;
1171:
1179: END IF;
1180:
1181: /* lchen added for bug #1761154 */
1182:
1183: ELSIF l_request_type = OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE then
1184: IF l_debug_level > 0 THEN
1185: oe_debug_pub.add('lchen-- Before calls OE_DELAYED_REQUESTS_UTIL.CASCADE_SERVICE_FOR_OPTIONS', 1);
1186: END IF;
1187: OE_DELAYED_REQUESTS_UTIL.CASCADE_SERVICE_FOR_OPTIONS
1192: oe_debug_pub.add('lchen-- After calls OE_DELAYED_REQUESTS_UTIL.CASCADE_SERVICE_FOR_OPTIONS', 1);
1193: END IF;
1194:
1195: -- added by lkxu: to copy pricing attributes
1196: ELSIF l_request_type = OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES THEN
1197:
1198: OE_Line_PAttr_Util.copy_pricing_attributes
1199: (p_from_line_id => to_number(l_request_rec.param2)
1200: ,p_to_line_id => l_request_rec.entity_id
1201: ,p_to_Header_id => to_number(l_request_rec.param1)
1202: ,x_return_status => l_return_status
1203: );
1204:
1205: ELSIF l_request_type = OE_GLOBALS.G_COPY_MODEL_PATTR THEN
1206:
1207: /* bug 1857538
1208: copy_model_pattr now takes only the line_id as parameter
1209: Corresponding changes are in OEXULPAS and OEXULPAB
1214: p_to_line_id => to_number(l_request_rec.param1)
1215: ,x_return_status => l_return_status
1216: );
1217:
1218: ELSIF l_request_type = OE_GLOBALS.G_DELETE_CHARGES THEN
1219: OE_Header_Util.cancel_header_charges
1220: (
1221: p_header_id => l_request_rec.entity_id,
1222: --p_x_line_id => to_number(l_request_rec.param1),
1222: --p_x_line_id => to_number(l_request_rec.param1),
1223: x_return_status => l_return_status
1224: );
1225:
1226: ELSIF l_request_type = OE_GLOBALS.G_CASCADE_SCH_ATTRBS THEN
1227:
1228: G_Delayed_Requests(p_request_ind).processed := 'Y';
1229:
1230: ELSIF l_request_type =
1227:
1228: G_Delayed_Requests(p_request_ind).processed := 'Y';
1229:
1230: ELSIF l_request_type =
1231: OE_GLOBALS.G_CASCADE_SHIP_SET_ATTR then
1232:
1233: l_index := 0;
1234: l_set_id := l_request_rec.param2;
1235:
1238: WHILE K is not null
1239: LOOP
1240:
1241: IF (G_Delayed_Requests(K).request_type =
1242: OE_GLOBALS.G_CASCADE_SHIP_SET_ATTR) AND
1243: G_Delayed_Requests(K).param2 = l_set_id AND
1244: K <> p_request_ind
1245: THEN
1246:
1256: ( p_request_rec => l_request_rec
1257: , x_return_status => l_return_status);
1258:
1259: ELSIF l_request_type =
1260: OE_GLOBALS.G_GROUP_SCHEDULE then
1261:
1262: l_index := 0;
1263: l_set_id := l_request_rec.param1;
1264:
1267: WHILE K is not null
1268: LOOP
1269:
1270: IF (G_Delayed_Requests(K).request_type =
1271: OE_GLOBALS.G_GROUP_SCHEDULE) AND
1272: G_Delayed_Requests(K).param1 = l_set_id AND
1273: K <> p_request_ind
1274: THEN
1275:
1295: WHILE l_count is not null
1296: LOOP
1297:
1298: IF G_Delayed_Requests(l_count).request_type =
1299: OE_GLOBALS.G_CASCADE_SCH_ATTRBS AND
1300: G_Delayed_Requests(l_count).param1 = l_set_id
1301: THEN
1302: oe_schedule_util.OE_sch_Attrb_Tbl
1303: (G_Delayed_Requests(l_count).entity_id).set_id :=
1328: oe_debug_pub.add('Group Schedule Return Status ' || l_return_status,1);
1329: END IF;
1330: -- 4026758
1331: ELSIF l_request_type =
1332: OE_GLOBALS.G_DELETE_SET THEN
1333: l_set_id := l_request_rec.param1;
1334:
1335: K := G_Delayed_Requests.FIRST;
1336:
1337: WHILE K is not null
1338: LOOP
1339:
1340: IF (G_Delayed_Requests(K).request_type =
1341: OE_GLOBALS.G_DELETE_SET)
1342: AND G_Delayed_Requests(K).param1 = l_set_id
1343: AND K <> p_request_ind THEN
1344:
1345: g_delayed_requests.delete(K);
1353: oe_set_util.Delete_Set(p_request_rec => l_request_rec
1354: , x_return_status => l_return_status);
1355: oe_debug_pub.add('Delete Set Return Status ' || l_return_status,1);
1356: ELSIF (l_request_type =
1357: OE_GLOBALS.G_SCHEDULE_LINE OR
1358: l_request_type =
1359: OE_GLOBALS.G_RESCHEDULE_LINE) then
1360:
1361: l_index := 0;
1355: oe_debug_pub.add('Delete Set Return Status ' || l_return_status,1);
1356: ELSIF (l_request_type =
1357: OE_GLOBALS.G_SCHEDULE_LINE OR
1358: l_request_type =
1359: OE_GLOBALS.G_RESCHEDULE_LINE) then
1360:
1361: l_index := 0;
1362: l_set := l_request_rec.param1;
1363:
1366: WHILE K is not null -- while loop safer than tbl.first to last
1367: LOOP
1368:
1369: IF (G_Delayed_Requests(K).request_type =
1370: OE_GLOBALS.G_SCHEDULE_LINE OR
1371: G_Delayed_Requests(K).request_type =
1372: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1373: G_Delayed_Requests(K).param1 = l_set
1374: THEN
1368:
1369: IF (G_Delayed_Requests(K).request_type =
1370: OE_GLOBALS.G_SCHEDULE_LINE OR
1371: G_Delayed_Requests(K).request_type =
1372: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1373: G_Delayed_Requests(K).param1 = l_set
1374: THEN
1375:
1376: l_index := l_index + 1;
1401: WHILE K is not null -- while loop safer than tbl.first to last
1402: LOOP
1403:
1404: IF (G_Delayed_Requests(K).request_type =
1405: OE_GLOBALS.G_SCHEDULE_LINE OR
1406: G_Delayed_Requests(K).request_type =
1407: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1408: G_Delayed_Requests(K).param1 = l_set
1409: THEN
1403:
1404: IF (G_Delayed_Requests(K).request_type =
1405: OE_GLOBALS.G_SCHEDULE_LINE OR
1406: G_Delayed_Requests(K).request_type =
1407: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1408: G_Delayed_Requests(K).param1 = l_set
1409: THEN
1410: l_index := l_index + 1;
1411: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
1420:
1421: END LOOP;
1422:
1423: -- bug 1829201, commitment related changes.
1424: ELSIF l_request_type = OE_GLOBALS.G_CALCULATE_COMMITMENT THEN
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add('Calling procedure calculate_commtment!',1);
1427: END IF;
1428:
1431: p_request_rec => l_request_rec
1432: ,x_return_status => l_return_status
1433: );
1434:
1435: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT THEN
1436:
1437: OE_Commitment_Pvt.update_commitment
1438: ( p_line_id => l_request_rec.entity_id
1439: ,x_return_status => l_return_status
1438: ( p_line_id => l_request_rec.entity_id
1439: ,x_return_status => l_return_status
1440: );
1441: -- multiple payments
1442: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED THEN
1443: IF l_debug_level > 0 THEN
1444: oe_debug_pub.add('OEXVREQB param1 is: '||l_request_rec.param1,3);
1445: oe_debug_pub.add('OEXVREQB param2 is: '||l_request_rec.param2,3);
1446: oe_debug_pub.add('OEXVREQB param3 is: '||l_request_rec.param3,3);
1454: );
1455:
1456: -- Included for the Spares Management (ikon) project mshenoy
1457: -- For the delayed request type of Create Internal Req call the procedure
1458: ELSIF l_request_type = OE_GLOBALS.G_CREATE_INTERNAL_REQ THEN
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add(' Calling auto_create_internal_req hdr id '|| l_entity_id,1);
1461: END IF;
1462: OE_DELAYED_REQUESTS_UTIL.auto_create_internal_req
1467: END IF;
1468:
1469: /* Modified the following condition to fix the bug 6663462 */
1470:
1471: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1472: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1473: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1474: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1475: IF l_debug_level > 0 THEN
1468:
1469: /* Modified the following condition to fix the bug 6663462 */
1470:
1471: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1472: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1473: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1474: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add('calling Process_Scheduling_Request');
1469: /* Modified the following condition to fix the bug 6663462 */
1470:
1471: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1472: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1473: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1474: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add('calling Process_Scheduling_Request');
1477: END IF;
1470:
1471: ELSIF l_request_type = OE_GLOBALS.G_SCHEDULE_ATO OR
1472: l_request_type = OE_GLOBALS.G_SCHEDULE_SMC OR
1473: l_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC OR
1474: l_request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add('calling Process_Scheduling_Request');
1477: END IF;
1478: Process_Scheduling_Request
1484: END IF;
1485: ---------
1486: -- Added by rsreeniv
1487: ----------
1488: ELSIF l_request_rec.request_type = OE_GLOBALS.G_FREIGHT_FOR_INCLUDED THEN
1489: IF l_debug_level > 0 THEN
1490: Oe_Debug_pub.Add('Before Executing Delayed request Freight for included for '||l_request_rec.entity_id);
1491: Oe_Debug_pub.Add('Before Order Price - Freight');
1492: Oe_Debug_pub.Add('The Event is '||l_request_rec.param2);
1529: Oe_Debug_pub.Add('After Header Price');
1530: Oe_Debug_pub.Add('After Executing Delayed request Price line for '||l_request_rec.entity_id);
1531: END IF;
1532: --MRG BGN
1533: ELSIF l_request_type = OE_GLOBALS.G_MARGIN_HOLD THEN
1534: IF l_debug_level > 0 THEN
1535: oe_debug_pub.add('From delayed request: executing Oe_Margin_Pvt.Margin_Hold');
1536: END IF;
1537: Oe_Margin_Pvt.Margin_Hold(p_header_id => l_request_rec.entity_id);
1541: -------------
1542:
1543:
1544: --MRG BGN
1545: ELSIF l_request_type = OE_GLOBALS.G_GET_COST THEN
1546: IF l_debug_level > 0 THEN
1547: oe_debug_pub.add('From delayed request: executing Oe_Margin_Pvt.Get_Cost');
1548: END IF;
1549: l_unit_cost := Oe_Margin_Pvt.Get_Cost(p_request_rec => l_request_rec);
1549: l_unit_cost := Oe_Margin_Pvt.Get_Cost(p_request_rec => l_request_rec);
1550: --MRG END
1551:
1552:
1553: ELSIF l_request_type = OE_GLOBALS.G_DEL_CHG_LINES Then
1554: IF l_debug_level > 0 THEN
1555: oe_debug_pub.add('Executing Delete_Changed_Lines delayed request');
1556: END IF;
1557:
1559: IF l_debug_level > 0 THEN
1560: oe_debug_pub.add('After Delete_Changed_Lines delayed request');
1561: END IF;
1562:
1563: ELSIF l_request_type = OE_GLOBALS.G_VERSION_AUDIT THEN
1564:
1565: OE_Versioning_Util.Execute_Versioning_Request(p_header_id => l_request_rec.entity_id,
1566: p_document_type => l_request_rec.entity_code,
1567: p_changed_attribute => l_request_rec.param1,
1570: x_return_status => x_return_status);
1571:
1572: -- BLANKETS: Ignore process release related requests here. These
1573: -- will be executed with all requests in process_delayed_requests call.
1574: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_RELEASE THEN
1575: RETURN;
1576: ELSIF l_request_type = OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS THEN
1577: RETURN;
1578:
1572: -- BLANKETS: Ignore process release related requests here. These
1573: -- will be executed with all requests in process_delayed_requests call.
1574: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_RELEASE THEN
1575: RETURN;
1576: ELSIF l_request_type = OE_GLOBALS.G_VALIDATE_RELEASE_SHIPMENTS THEN
1577: RETURN;
1578:
1579: -- Delayed requests logged by blankets business object APIs.
1580: ELSIF l_request_type = 'VALIDATE_BLANKET_LINE_NUMBER' THEN
1590: ELSIF l_request_type = 'ADD_BLANKET_PRICE_LIST_LINE' THEN
1591: OE_BLANKET_UTIL.add_price_list_line( p_req_ind => p_request_ind,
1592: x_return_status => l_return_status);
1593: -- for bug 3309427
1594: ELSIF l_request_type = OE_GLOBALS.G_CLEAR_BLKT_PRICE_LIST_LINE THEN
1595: OE_BLANKET_UTIL.clear_price_list_line( p_req_ind => p_request_ind,
1596: x_return_status => l_return_status);
1597: ELSIF l_request_type = 'RECORD_BLANKET_HISTORY' THEN
1598: OE_BLANKET_UTIL.record_blanket_history(
1602: p_sold_To_org_id => l_request_rec.param1,
1603: x_return_status => l_return_status);
1604: -- End of requests logged by blankets business object APIs.
1605: -- Begin of Multiple Payments
1606: ELSIF l_request_type = OE_GLOBALS.G_SPLIT_PAYMENT then
1607: OE_PrePayment_Pvt.split_payment (
1608: p_line_id => l_request_rec.entity_id
1609: , p_header_id => l_request_rec.param2
1610: , p_split_from_line_id => l_request_rec.param1
1613: , x_msg_data => l_msg_data
1614: );
1615: -- End of Multiple Payments
1616:
1617: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_HDR_PAYMENT then
1618:
1619: IF l_debug_level > 0 THEN
1620: oe_debug_pub.add('param1 is : ' || l_request_rec.param1);
1621: oe_debug_pub.add('param2 is : ' || l_request_rec.param2);
1622: oe_debug_pub.add('entity id is : ' || l_request_rec.entity_id);
1623: oe_debug_pub.add('entity code is : ' || l_request_rec.entity_code);
1624: END IF;
1625:
1626: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT
1627: AND l_request_rec.param1 = 'UPDATE_LINE' THEN
1628: payment_line_id := l_request_rec.entity_id;
1629: payment_header_id := l_request_rec.param2;
1630:
1646: , x_msg_count => l_msg_count
1647: , x_msg_data => l_msg_data
1648: );
1649:
1650: ELSIF l_request_type = OE_GLOBALS.G_APPLY_PPP_HOLD THEN
1651: --bug3507871 start
1652: IF l_debug_level > 0 THEN
1653: oe_debug_pub.add('Before calling Process_Payments for applying PPP hold');
1654: END IF;
1662: x_msg_count => l_msg_count,
1663: x_return_status => l_return_status);
1664: --bug3507871 end
1665: --bug3625027 start
1666: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_PAYMENT THEN
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('Request Type: '||l_request_type);
1669: END IF;
1670: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
1666: ELSIF l_request_type = OE_GLOBALS.G_PROCESS_PAYMENT THEN
1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add('Request Type: '||l_request_type);
1669: END IF;
1670: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
1671: IF l_debug_level > 0 THEN
1672: oe_debug_pub.add('Before calling Process_Payments Procedure at the header level');
1673: END IF;
1674:
1681: p_process_authorization=>'N',
1682: x_msg_data => l_msg_data,
1683: x_msg_count => l_msg_count,
1684: x_return_status => l_return_status);
1685: ELSIF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1686: IF l_debug_level > 0 THEN
1687: oe_debug_pub.add('Before calling Process_Payments Procedure at the line level');
1688: END IF;
1689:
1700: x_return_status => l_return_status);
1701: END IF;
1702: --bug3625027 end
1703:
1704: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENT_HOLD THEN
1705: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1706: payment_line_id := l_request_rec.entity_id;
1707: payment_header_id := l_request_rec.param2;
1708: ELSE
1701: END IF;
1702: --bug3625027 end
1703:
1704: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENT_HOLD THEN
1705: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1706: payment_line_id := l_request_rec.entity_id;
1707: payment_header_id := l_request_rec.param2;
1708: ELSE
1709: payment_header_id := l_request_rec.entity_id;
1739: OE_BLANKET_PRICING_UTIL.Create_Modifiers(
1740: p_index => p_request_ind,
1741: x_return_status => l_return_status);
1742:
1743: ELSIF l_request_type IN (OE_GLOBALS.G_GENERATE_XML_REQ_HDR, OE_GLOBALS.G_GENERATE_XML_REQ_LN) THEN
1744: -- only do processing on header-level requests
1745:
1746: IF l_request_type = OE_GLOBALS.G_GENERATE_XML_REQ_HDR THEN
1747: OE_DELAYED_REQUESTS_UTIL.process_xml_delayed_request(p_request_ind => p_request_ind,
1742:
1743: ELSIF l_request_type IN (OE_GLOBALS.G_GENERATE_XML_REQ_HDR, OE_GLOBALS.G_GENERATE_XML_REQ_LN) THEN
1744: -- only do processing on header-level requests
1745:
1746: IF l_request_type = OE_GLOBALS.G_GENERATE_XML_REQ_HDR THEN
1747: OE_DELAYED_REQUESTS_UTIL.process_xml_delayed_request(p_request_ind => p_request_ind,
1748: x_return_status => l_return_status);
1749: END IF;
1750: --R12 CC Encryption
1747: OE_DELAYED_REQUESTS_UTIL.process_xml_delayed_request(p_request_ind => p_request_ind,
1748: x_return_status => l_return_status);
1749: END IF;
1750: --R12 CC Encryption
1751: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENTS THEN
1752: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1753: payment_line_id := l_request_rec.entity_id;
1754: payment_header_id := l_request_rec.param1;
1755: old_invoice_to_org_id := to_number(l_request_rec.param2);
1748: x_return_status => l_return_status);
1749: END IF;
1750: --R12 CC Encryption
1751: ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENTS THEN
1752: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
1753: payment_line_id := l_request_rec.entity_id;
1754: payment_header_id := l_request_rec.param1;
1755: old_invoice_to_org_id := to_number(l_request_rec.param2);
1756: ELSE
2014: END IF;
2015:
2016: l_request.processed := 'N';
2017:
2018: IF l_request.request_type = OE_GLOBALS.G_PRICE_ORDER
2019: AND (l_request.request_unique_key1 = 'BATCH'
2020: AND nvl(l_request.request_unique_key2,'N') = 'Y'
2021: OR l_request.request_unique_key1 = 'ORDER'
2022: AND nvl(l_request.request_unique_key2,'N') = 'N'
2057: END IF;
2058:
2059: /* Added the following code to fix the fp bug 3498435 */
2060:
2061: IF l_request.request_type = OE_GLOBALS.G_PRICE_LINE
2062: AND (nvl(l_request.request_unique_key1, l_request.param2) = 'BATCH'
2063: AND nvl(l_request.request_unique_key2,'N') = 'N'
2064: OR nvl(l_request.request_unique_key1,l_request.param2) = 'BATCH,BOOK'
2065: AND nvl(l_request.request_unique_key2,'N') = 'N')
2084: OE_Debug_PUB.ADD('Request replaced');
2085: END IF;
2086:
2087: IF g_delayed_requests(l_request_ind).request_type =
2088: OE_GLOBALS.G_CASCADE_CHANGES THEN
2089: IF l_debug_level > 0 THEN
2090: OE_Debug_PUB.ADD('cascade changes, orig qty '||
2091: g_delayed_requests(l_request_ind).param1, 3);
2092: END IF;
2092: END IF;
2093: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2094:
2095: ELSIF g_delayed_requests(l_request_ind).request_type =
2096: OE_GLOBALS.G_UPDATE_OPTION THEN
2097: IF l_debug_level > 0 THEN
2098: OE_Debug_PUB.ADD('update option, orig qty '||
2099: g_delayed_requests(l_request_ind).param4, 3);
2100: END IF;
2102: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2103:
2104: -- Added 09-DEC-2002
2105: -- BLANKETS: exception for blankets to retain old parameters
2106: ELSIF p_request_type = OE_GLOBALS.G_PROCESS_RELEASE
2107: THEN
2108: IF l_debug_level > 0 THEN
2109: oe_debug_pub.add('Retain parameters for old values');
2110: END IF;
2114: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2115: l_request.param5 := g_delayed_requests(l_request_ind).param5;
2116: l_request.param6 := g_delayed_requests(l_request_ind).param6;
2117:
2118: ELSIF p_request_type = OE_GLOBALS.G_DROPSHIP_CMS
2119: THEN
2120: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2121: l_request.param2 := g_delayed_requests(l_request_ind).param2;
2122: l_request.param3 := g_delayed_requests(l_request_ind).param3;
2127: -- l_request.param7 := g_delayed_requests(l_request_ind).param7;
2128: l_request.date_param1 := g_delayed_requests(l_request_ind).date_param1;
2129: /*****End changes for bug#6918700*********/
2130:
2131: ELSIF p_request_type = OE_GLOBALS.G_GROUP_SCHEDULE
2132: THEN
2133: --2819258 -- Retain the operation
2134: l_request.param14 := g_delayed_requests(l_request_ind).param14;
2135: -- 4052648
2132: THEN
2133: --2819258 -- Retain the operation
2134: l_request.param14 := g_delayed_requests(l_request_ind).param14;
2135: -- 4052648
2136: ELSIF p_request_type = OE_GLOBALS.G_SCHEDULE_ATO
2137: THEN
2138: -- Retain old parameter values.
2139: l_request.param7 := g_delayed_requests(l_request_ind).param7; -- Ship From
2140: l_request.param8 := g_delayed_requests(l_request_ind).param8; -- Demand Class
2144: l_request.param17 := g_delayed_requests(l_request_ind).param17; -- Delivery Lead Time
2145: l_request.date_param4 := g_delayed_requests(l_request_ind).date_param4; -- Req Date
2146: l_request.date_param5 := g_delayed_requests(l_request_ind).date_param5; -- SSD
2147: l_request.date_param6 := g_delayed_requests(l_request_ind).date_param6; -- SAD
2148: ELSIF p_request_type = OE_GLOBALS.G_SCHEDULE_SMC
2149: THEN
2150: -- Retain old parameter values.
2151: l_request.param7 := g_delayed_requests(l_request_ind).param7; -- Ship From
2152: l_request.param8 := g_delayed_requests(l_request_ind).param8; -- Demand Class
2156: l_request.param17 := g_delayed_requests(l_request_ind).param17; -- Delivery Lead Time
2157: l_request.date_param4 := g_delayed_requests(l_request_ind).date_param4; -- Req Date
2158: l_request.date_param5 := g_delayed_requests(l_request_ind).date_param5; -- SSD
2159: l_request.date_param6 := g_delayed_requests(l_request_ind).date_param6; -- SAD
2160: ELSIF p_request_type = OE_GLOBALS.G_SCHEDULE_NONSMC
2161: THEN
2162: -- Retain old parameter values.
2163: l_request.param7 := g_delayed_requests(l_request_ind).param7; -- Ship From
2164: l_request.param8 := g_delayed_requests(l_request_ind).param8; -- Demand Class
2171: l_request.date_param6 := g_delayed_requests(l_request_ind).date_param6; -- SAD
2172:
2173: /* 7576948: IR ISO Change Management project Start */
2174: -- This code is hooked for IR ISO project and specific to
2175: -- OE_GLOBALS.G_UPDATE_REQUISITION delayed request, where if this request
2176: -- is getting replaced then certain parameter values should be retained
2177: -- or manipulated. Following parameters are used for this delayed request
2178: -- Please refer them with their meaning -
2179: --
2177: -- or manipulated. Following parameters are used for this delayed request
2178: -- Please refer them with their meaning -
2179: --
2180: -- P_entity_code Entity for which delayed request has to be logged.
2181: -- In this project it can be OE_Globals.G_Entity_Line
2182: -- or OE_Globals.G_Entity_Header
2183: -- P_entity_id Primary key of the entity record. In this project,
2184: -- it can be Order Line_id or Header_id
2185: -- P_requesting_entity_code Which entity has requested this delayed request to
2178: -- Please refer them with their meaning -
2179: --
2180: -- P_entity_code Entity for which delayed request has to be logged.
2181: -- In this project it can be OE_Globals.G_Entity_Line
2182: -- or OE_Globals.G_Entity_Header
2183: -- P_entity_id Primary key of the entity record. In this project,
2184: -- it can be Order Line_id or Header_id
2185: -- P_requesting_entity_code Which entity has requested this delayed request to
2186: -- be logged! In this project it will be OE_Globals.
2182: -- or OE_Globals.G_Entity_Header
2183: -- P_entity_id Primary key of the entity record. In this project,
2184: -- it can be Order Line_id or Header_id
2185: -- P_requesting_entity_code Which entity has requested this delayed request to
2186: -- be logged! In this project it will be OE_Globals.
2187: -- G_Entity_Line or OE_Globals.G_Entity_Header
2188: -- P_requesting_entity_id Primary key of the requesting entity. In this
2189: -- project, it is Line_id or Header_id
2190: -- P_request_type Indicates which business logic (or which procedure)
2183: -- P_entity_id Primary key of the entity record. In this project,
2184: -- it can be Order Line_id or Header_id
2185: -- P_requesting_entity_code Which entity has requested this delayed request to
2186: -- be logged! In this project it will be OE_Globals.
2187: -- G_Entity_Line or OE_Globals.G_Entity_Header
2188: -- P_requesting_entity_id Primary key of the requesting entity. In this
2189: -- project, it is Line_id or Header_id
2190: -- P_request_type Indicates which business logic (or which procedure)
2191: -- should be executed. In this project, it is OE_Global
2225: -- For details on IR ISO CMS project, please refer to FOL >
2226: -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
2227:
2228:
2229: ELSIF p_request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add('Type: G_UPDATE_REQUISITION, retain old parameter values',5);
2232: END IF;
2233:
2312: END IF;
2313: -- l_request_ind := nvl(g_delayed_requests.LAST, 0) + 1;
2314:
2315: -- 11i10 Pricing Changes for blankets
2316: IF p_request_type = OE_GLOBALS.G_PROCESS_RELEASE
2317: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
2318: THEN
2319: OE_Blkt_Release_Util.Cache_Order_Qty_Amt
2320: (p_request_rec => l_request
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);
2632: END IF;
2633: IF oe_globals.g_recursion_mode = 'N' THEN
2634:
2635:
2636: l_ind := G_Delayed_Requests.first;
2637:
2717: p_In_out => 1);
2718: IF l_debug_level > 0 THEN
2719: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');
2720: END IF;
2721: --IF oe_globals.g_recursion_mode = 'N' THEN
2722: l_ind := G_Delayed_Requests.first;
2723: l_count := 0;
2724: WHILE l_ind IS NOT NULL LOOP
2725: IF G_Delayed_Requests(l_ind).request_type = p_request_type THEN
2722: l_ind := G_Delayed_Requests.first;
2723: l_count := 0;
2724: WHILE l_ind IS NOT NULL LOOP
2725: IF G_Delayed_Requests(l_ind).request_type = p_request_type THEN
2726: IF p_request_type = OE_GLOBALS.G_TAX_LINE THEN
2727: l_count := l_count + 1;
2728: l_entity_id_tbl(l_count).entity_id := G_Delayed_Requests(l_ind).entity_id;
2729: l_entity_id_tbl(l_count).request_ind := l_ind;
2730: ELSE
2831:
2832: -- Process requests as per the dependency
2833: -- Process a request to default header sales credit for
2834: -- primary sales person
2835: IF oe_globals.g_recursion_mode = 'N' THEN
2836:
2837: Process_Request_for_ReqType
2838: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
2839: ,p_delete => FND_API.G_TRUE
2834: -- primary sales person
2835: IF oe_globals.g_recursion_mode = 'N' THEN
2836:
2837: Process_Request_for_ReqType
2838: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
2839: ,p_delete => FND_API.G_TRUE
2840: ,x_return_status => l_return_status
2841: );
2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2846: END IF;
2847:
2848: -- Process Header Sales Credits Delayed Requests
2849: Process_Request_for_ReqType
2850: (p_request_type => OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
2851: ,p_delete => FND_API.G_TRUE
2852: ,x_return_status => l_return_status
2853: );
2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2858: END IF;
2859:
2860: -- Process Lines Sales Credits Delayed Requests
2861: Process_Request_for_ReqType
2862: (p_request_type => OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
2863: ,p_delete => FND_API.G_TRUE
2864: ,x_return_status => l_return_status
2865: );
2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2870: END IF;
2871:
2872: -- Process CREATE_SETS Requests
2873: Process_Request_for_ReqType
2874: (p_request_type => OE_GLOBALS.G_CREATE_SETS
2875: ,p_delete => FND_API.G_TRUE
2876: ,x_return_status => l_return_status
2877: );
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2884:
2885:
2886: -- Process CREATE_CONFIG_ITEM Requests
2887: Process_Request_for_ReqType
2888: (p_request_type => OE_GLOBALS.G_CREATE_CONFIG_ITEM
2889: ,p_delete => FND_API.G_TRUE
2890: ,x_return_status => l_return_status
2891: );
2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2896: END IF;
2897:
2898: -- Process INSERT_INTO_SETS Requests
2899: Process_Request_for_ReqType
2900: (p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
2901: ,p_delete => FND_API.G_TRUE
2902: ,x_return_status => l_return_status
2903: );
2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2908: END IF;
2909:
2910: -- Process INS_INCLUDED_ITEM Requests
2911: Process_Request_for_ReqType
2912: (p_request_type => OE_GLOBALS.G_INS_INCLUDED_ITEMS
2913: ,p_delete => FND_API.G_TRUE
2914: ,x_return_status => l_return_status
2915: );
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2922:
2923:
2924: -- Process requests for RMA
2925: Process_Request_for_ReqType
2926: (p_request_type => OE_GLOBALS.G_INSERT_RMA
2927: ,p_delete => FND_API.G_TRUE
2928: ,x_return_status => l_return_status
2929: );
2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: END IF;
2935:
2936: -- Process requests for Split_hold
2937: Process_Request_for_ReqType
2938: (p_request_type => OE_GLOBALS.G_SPLIT_HOLD
2939: ,p_delete => FND_API.G_TRUE
2940: ,x_return_status => l_return_status
2941: );
2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2946: END IF;
2947:
2948: -- Process requests for Delayed Requests
2949: Process_Request_for_ReqType
2950: (p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE
2951: ,p_delete => FND_API.G_TRUE
2952: ,x_return_status => l_return_status
2953: );
2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: END IF;
2959:
2960: -- Process requests for Quantity Cascade
2961: Process_Request_for_ReqType
2962: (p_request_type => OE_GLOBALS.G_CASCADE_QUANTITY
2963: ,p_delete => FND_API.G_TRUE
2964: ,x_return_status => l_return_status
2965: );
2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2971:
2972: /*** we do not need this, confirm with ashwin
2973: -- Process requests for project Cascade
2974: Process_Request_for_ReqType
2975: (p_request_type => OE_GLOBALS.G_CASCADE_PROJECT
2976: ,p_delete => FND_API.G_TRUE
2977: ,x_return_status => l_return_status
2978: );
2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2983: END IF;
2984:
2985: -- Process requests for task Cascade
2986: Process_Request_for_ReqType
2987: (p_request_type => OE_GLOBALS.G_CASCADE_TASK
2988: ,p_delete => FND_API.G_TRUE
2989: ,x_return_status => l_return_status
2990: );
2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2996:
2997: -- Process requests for task Cascade
2998: ***/
2999: Process_Request_for_ReqType
3000: (p_request_type => OE_GLOBALS.G_CASCADE_CHANGES
3001: ,p_delete => FND_API.G_TRUE
3002: ,x_return_status => l_return_status
3003: );
3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3008: END IF;
3009:
3010: -- Process requests to Split Reservations
3011: Process_Request_for_ReqType
3012: (p_request_type => OE_GLOBALS.G_CREATE_RESERVATIONS
3013: ,p_delete => FND_API.G_TRUE
3014: ,x_return_status => l_return_status
3015: );
3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3020: END IF;
3021:
3022: -- Process requests to Complete Configuration
3023: Process_Request_for_ReqType
3024: (p_request_type => OE_GLOBALS.G_COMPLETE_CONFIGURATION
3025: ,p_delete => FND_API.G_TRUE
3026: ,x_return_status => l_return_status
3027: );
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3032: END IF;
3033:
3034: -- Process requests for Validate Configuration
3035: Process_Request_for_ReqType
3036: (p_request_type => OE_GLOBALS.G_VALIDATE_CONFIGURATION
3037: ,p_delete => FND_API.G_TRUE
3038: ,x_return_status => l_return_status
3039: );
3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3044: END IF;
3045:
3046: -- Process requests for CTO Notification
3047: Process_Request_for_ReqType
3048: (p_request_type => OE_GLOBALS.G_CTO_NOTIFICATION
3049: ,p_delete => FND_API.G_TRUE
3050: ,x_return_status => l_return_status
3051: );
3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3056: END IF;
3057:
3058: -- Process requests for Service
3059: Process_Request_for_ReqType
3060: (p_request_type => OE_GLOBALS.G_INSERT_SERVICE
3061: ,p_delete => FND_API.G_TRUE
3062: ,x_return_status => l_return_status
3063: );
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3068: END IF;
3069:
3070: /* Added the below call for bug 5925600 */
3071: Process_Request_for_ReqType
3072: (p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE
3073: ,p_delete => FND_API.G_TRUE
3074: ,x_return_status => l_return_status
3075: );
3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:
3082: Process_Request_for_ReqType
3083: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
3084: ,p_delete => FND_API.G_TRUE
3085: ,x_return_status => l_return_status
3086: );
3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3092: /* End of changes done for bug 5925600 */
3093:
3094: -- bug 5717671/5736696, need to execute copy header adj
3095: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3096: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3097: ,p_delete => FND_API.G_TRUE
3098: ,x_return_status => l_return_status
3099: );
3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3106:
3107: -- bug 1834260, moved this block of code from after processing
3108: -- for request type G_PRICE_LINE to before it.
3109: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3110: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3111: ,p_delete => FND_API.G_TRUE
3112: ,x_return_status => l_return_status
3113: );
3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3118: END IF;
3119:
3120: -- Process Requests for Freight Rating.
3121: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3122: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3123: ,p_delete => FND_API.G_TRUE
3124: ,x_return_status => l_return_status
3125: );
3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3134: right after copy_adjustments - please do not put any delayed
3135: request in between copy_adjustments and copy_freight_charges */
3136:
3137: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3138: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3139: ,p_delete => FND_API.G_TRUE
3140: ,x_return_status => l_return_status
3141: );
3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3147:
3148:
3149: -- Process Requests for Pricing
3150: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3151: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3152: ,p_delete => FND_API.G_TRUE
3153: ,x_return_status => l_return_status
3154: );
3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3161:
3162: -- Renga - added freight_for_included items call
3163: -- Process Requests for Freight For included items.
3164: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3165: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3166: ,p_delete => FND_API.G_TRUE
3167: ,x_return_status => l_return_status
3168: );
3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3175: -- Renga - done for freight for included items.
3176:
3177:
3178: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3179: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3180: ,p_delete => FND_API.G_TRUE
3181: ,x_return_status => l_return_status
3182: );
3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188:
3189: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3190: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3191: ,p_delete => FND_API.G_TRUE
3192: ,x_return_status => l_return_status
3193: );
3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3198: END IF;
3199:
3200: -- added by lkxu
3201: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3202: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3203: ,p_delete => FND_API.G_TRUE
3204: ,x_return_status => l_return_status
3205: );
3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3209: RAISE FND_API.G_EXC_ERROR;
3210: END IF;
3211:
3212: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3213: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3214: ,p_delete => FND_API.G_TRUE
3215: ,x_return_status => l_return_status
3216: );
3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3221: END IF;
3222:
3223: -- Process Delete Charges Delayed Requests
3224: Process_Request_for_ReqType
3225: (p_request_type => OE_GLOBALS.G_DELETE_CHARGES
3226: ,p_delete => FND_API.G_TRUE
3227: ,x_return_status => l_return_status
3228: );
3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3233: END IF;
3234:
3235: -- Process Tax Delayed Requests
3236: Process_Request_for_ReqType
3237: (p_request_type => OE_GLOBALS.G_TAX_LINE
3238: ,p_delete => FND_API.G_TRUE
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3246:
3247:
3248: -- Process Commitment Delayed Requests
3249: Process_Request_for_ReqType
3250: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
3251: ,p_delete => FND_API.G_TRUE
3252: ,x_return_status => l_return_status
3253: );
3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3258: END IF;
3259:
3260: -- Process Commitment Delayed Requests
3261: Process_Request_for_ReqType
3262: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
3263: ,p_delete => FND_API.G_TRUE
3264: ,x_return_status => l_return_status
3265: );
3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3270: END IF;
3271:
3272: -- for multiple payments
3273: Process_Request_for_ReqType
3274: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
3275: ,p_delete => FND_API.G_TRUE
3276: ,x_return_status => l_return_status
3277: );
3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3282: END IF;
3283:
3284: -- for multiple payments
3285: Process_Request_for_ReqType
3286: (p_request_type => OE_GLOBALS.G_SPLIT_PAYMENT
3287: ,p_delete => FND_API.G_TRUE
3288: ,x_return_status => l_return_status
3289: );
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:
3296: Process_Request_for_ReqType
3297: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT
3298: ,p_delete => FND_API.G_TRUE
3299: ,x_return_status => l_return_status
3300: );
3301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3305: END IF;
3306:
3307: -- Process requests for Payment Verification
3308: Process_Request_for_ReqType
3309: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
3310: ,p_delete => FND_API.G_TRUE
3311: ,x_return_status => l_return_status
3312: );
3313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;
3318:
3319: Process_Request_for_ReqType
3320: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD
3321: ,p_delete => FND_API.G_TRUE
3322: ,x_return_status => l_return_status
3323: );
3324: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3328: END IF;
3329:
3330: -- Process Request to create automatic attachments
3331: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3332: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3333: ,p_delete => FND_API.G_TRUE
3334: ,x_return_status => l_return_status
3335: );
3336: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3340: END IF;
3341:
3342: -- Process Request to copy attachments
3343: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3344: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3345: ,p_delete => FND_API.G_TRUE
3346: ,x_return_status => l_return_status
3347: );
3348: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3356: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');
3357: END IF;
3358:
3359: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3360: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ
3361: ,p_delete => FND_API.G_TRUE
3362: ,x_return_status => l_return_status);
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3371: END IF;
3372:
3373: -- B2013611 reverse promotional limits
3374: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3375: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3376: ,p_delete => FND_API.G_TRUE
3377: ,x_return_status => l_return_status
3378: );
3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3383: END IF;
3384:
3385: --MRG BGN
3386: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3387: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3388: ,p_delete => FND_API.G_TRUE
3389: ,x_return_status => l_return_status
3390: );
3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3406: END IF;
3407: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3408: (p_request_type => OE_GLOBALS.G_GET_COST
3409: ,p_delete => FND_API.G_TRUE
3410: ,x_return_status => l_return_status
3411: );
3412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3417: --MRG END
3418:
3419:
3420: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3421: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3422: ,p_delete => FND_API.G_TRUE
3423: ,x_return_status => l_return_status
3424: );
3425: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3431:
3432: --process delayed requests for xml generation
3433:
3434: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3435: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3436: ,p_delete => FND_API.G_TRUE
3437: ,x_return_status => l_return_status
3438: );
3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3481:
3482:
3483: -- Process Request to Update the Internal Requisition
3484: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3485: ( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
3486: , p_delete => FND_API.G_TRUE
3487: , x_return_status => l_return_status
3488: );
3489:
3499:
3500: --process delayed requests for cancel workflow
3501:
3502: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3503: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3504: ,p_delete => FND_API.G_TRUE
3505: ,x_return_status => l_return_status
3506: );
3507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3535: END LOOP;
3536:
3537: -- Process Request to Complete workflow activity
3538: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3539: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3540: ,p_delete => FND_API.G_TRUE
3541: ,x_return_status => l_return_status
3542: );
3543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3929: ' Request ID:'||l_request_rec.entity_id);
3930: END IF;
3931:
3932: -- Action Request to Apply Automatic Attachments
3933: IF l_request_rec.request_type = OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT THEN
3934:
3935: OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments
3936: ( p_entity_code => l_request_rec.entity_code
3937: , p_entity_id => l_request_rec.entity_id
3938: , p_is_user_action => 'Y'
3939: , x_return_status => l_return_status
3940: );
3941: l_request_rec.processed := 'Y';
3942: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
3943: -- For ER 7243028
3944: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
3945: IF l_debug_level > 0 THEN
3946: oe_debug_pub.add('Before calling Price Order for :' || l_request_rec.entity_id, 5);
3940: );
3941: l_request_rec.processed := 'Y';
3942: ELSIF l_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
3943: -- For ER 7243028
3944: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
3945: IF l_debug_level > 0 THEN
3946: oe_debug_pub.add('Before calling Price Order for :' || l_request_rec.entity_id, 5);
3947: END IF;
3948: OE_ORDER_ADJ_PVT.price_action
3955: x_return_status => l_return_status,
3956: x_msg_count => l_msg_count,
3957: x_msg_data => l_msg_data
3958: );
3959: ELSIF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
3960:
3961: l_lines_count :=0;
3962:
3963: for j in i .. p_x_request_tbl.count loop
3960:
3961: l_lines_count :=0;
3962:
3963: for j in i .. p_x_request_tbl.count loop
3964: if p_x_request_tbl(j).request_type = OE_GLOBALS.G_PRICE_ORDER and
3965: p_x_request_tbl(j).entity_code = OE_GLOBALS.G_ENTITY_LINE
3966: then
3967: l_lines_count := l_lines_count + 1;
3968: if l_lines_count = 1 then
3961: l_lines_count :=0;
3962:
3963: for j in i .. p_x_request_tbl.count loop
3964: if p_x_request_tbl(j).request_type = OE_GLOBALS.G_PRICE_ORDER and
3965: p_x_request_tbl(j).entity_code = OE_GLOBALS.G_ENTITY_LINE
3966: then
3967: l_lines_count := l_lines_count + 1;
3968: if l_lines_count = 1 then
3969: l_lines_list := p_x_request_tbl(j).entity_id;
4014: END IF;
4015:
4016: -- End of ER 7243028
4017:
4018: ELSIF l_request_rec.request_type = OE_GLOBALS.G_APPLY_HOLD THEN
4019: IF l_debug_level > 0 THEN
4020: OE_Debug_PUB.ADD('Calling Apply_Hold', 2);
4021: END IF;
4022: OE_Delayed_Requests_UTIL.Apply_Hold
4027: IF l_debug_level > 0 THEN
4028: OE_Debug_PUB.ADD('After Calling Apply_hold', 2);
4029: END IF;
4030:
4031: ELSIF l_request_rec.request_type = OE_GLOBALS.G_RELEASE_HOLD THEN
4032: IF l_debug_level > 0 THEN
4033: OE_Debug_PUB.ADD('Calling Release_Hold', 2);
4034: END IF;
4035: OE_Delayed_Requests_UTIL.Release_Hold
4039: IF l_debug_level > 0 THEN
4040: OE_Debug_PUB.ADD('After Calling Release_hold', 2);
4041: END IF;
4042: --R12 CVV2
4043: ELSIF l_request_rec.request_type = OE_GLOBALS.G_VERIFY_PAYMENT THEN
4044: /*comm rej IF nvl(l_request_rec.param2, 'HOLD') = 'REJECT' THEN
4045: l_reject_on_auth_failure := 'Y';
4046: ELSE
4047: l_reject_on_auth_failure := 'N';
4109: END IF;
4110:
4111: l_request_rec.processed := 'Y';
4112: -- to ensure verify_payment not getting called again during book_order.
4113: OE_GLOBALS.G_PAYMENT_PROCESSED := 'Y';
4114: --R12 CVV2
4115:
4116:
4117: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_BOOK_ORDER
4113: OE_GLOBALS.G_PAYMENT_PROCESSED := 'Y';
4114: --R12 CVV2
4115:
4116:
4117: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_BOOK_ORDER
4118: AND p_process_WF_requests) THEN
4119:
4120: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
4121: IF l_debug_level > 0 THEN
4116:
4117: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_BOOK_ORDER
4118: AND p_process_WF_requests) THEN
4119:
4120: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
4121: IF l_debug_level > 0 THEN
4122: OE_Debug_PUB.ADD('Calling Book Order');
4123: END IF;
4124: OE_Delayed_Requests_UTIL.Book_Order
4128: );
4129: l_request_rec.processed := 'Y';
4130: END IF;
4131:
4132: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD
4133: OR l_request_rec.request_type = OE_GLOBALS.G_GET_FREIGHT_RATES
4134: OR l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES) THEN
4135:
4136: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
4129: l_request_rec.processed := 'Y';
4130: END IF;
4131:
4132: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD
4133: OR l_request_rec.request_type = OE_GLOBALS.G_GET_FREIGHT_RATES
4134: OR l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES) THEN
4135:
4136: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
4137: IF l_debug_level > 0 THEN
4130: END IF;
4131:
4132: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD
4133: OR l_request_rec.request_type = OE_GLOBALS.G_GET_FREIGHT_RATES
4134: OR l_request_rec.request_type = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES) THEN
4135:
4136: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
4137: IF l_debug_level > 0 THEN
4138: OE_DEBUG_PUB.Add('Calling Get Ship Method');
4153: l_request_rec.processed := 'Y';
4154:
4155: END IF;
4156:
4157: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR
4158: l_request_rec.request_type = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET ) AND
4159: l_request_rec.param5 IS NOT NULL THEN
4160:
4161: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4154:
4155: END IF;
4156:
4157: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR
4158: l_request_rec.request_type = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET ) AND
4159: l_request_rec.param5 IS NOT NULL THEN
4160:
4161: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4162:
4159: l_request_rec.param5 IS NOT NULL THEN
4160:
4161: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4162:
4163: IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
4164: OE_Delayed_Requests_UTIL.Fulfillment_Sets
4165: ( p_entity_code => l_request_rec.entity_code
4166: , p_entity_id => l_request_rec.entity_id
4167: , p_action_code => l_request_rec.request_type
4171: l_request_rec.processed := 'Y';
4172: END IF;
4173: END IF;
4174:
4175: ELSIF l_request_rec.request_type = OE_GLOBALS.G_DELINK_CONFIG
4176: THEN
4177:
4178: OE_Delayed_Requests_UTIL.DELINK_CONFIG
4179: ( p_line_id => l_request_rec.entity_id
4180: , x_return_status => l_request_rec.return_status
4181: );
4182: l_request_rec.processed := 'Y';
4183:
4184: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_MATCH_AND_RESERVE
4185: AND p_process_WF_requests) THEN
4186:
4187: OE_Delayed_Requests_UTIL.MATCH_AND_RESERVE
4188: ( p_line_id => l_request_rec.entity_id
4189: , x_return_status => l_request_rec.return_status
4190: );
4191: l_request_rec.processed := 'Y';
4192:
4193: ELSIF (l_request_rec.request_type = OE_GLOBALS.G_LINK_CONFIG
4194: AND p_process_WF_requests)
4195: THEN
4196: OE_Config_UTIL.LINK_CONFIG
4197: ( p_line_id => l_request_rec.entity_id
4198: , p_config_item_id => to_number(l_request_rec.param1)
4199: , x_return_status => l_request_rec.return_status );
4200: l_request_rec.processed := 'Y';
4201: --Customer Acceptance Project actions
4202: ELSIF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4203: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4204: p_process_WF_requests THEN
4205:
4206: OE_ACCEPTANCE_PVT.Process_Acceptance(p_request_tbl => p_x_request_tbl
4199: , x_return_status => l_request_rec.return_status );
4200: l_request_rec.processed := 'Y';
4201: --Customer Acceptance Project actions
4202: ELSIF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4203: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4204: p_process_WF_requests THEN
4205:
4206: OE_ACCEPTANCE_PVT.Process_Acceptance(p_request_tbl => p_x_request_tbl
4207: ,x_return_status => l_return_status);
4213: /** the WF requests are NOT marked invalid in the first call but **/
4214: /** processed in the second call **/
4215: ELSIF p_process_WF_requests THEN
4216:
4217: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
4218: OE_MSG_PUB.update_msg_context(
4219: p_header_id => l_request_rec.entity_id);
4220:
4221: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4217: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
4218: OE_MSG_PUB.update_msg_context(
4219: p_header_id => l_request_rec.entity_id);
4220:
4221: ELSIF l_request_rec.entity_code = OE_Globals.G_ENTITY_LINE THEN
4222: OE_MSG_PUB.update_msg_context(
4223: p_line_id => l_request_rec.entity_id);
4224: END IF;
4225: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4235: THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: END IF;
4238:
4239: IF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4240: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4241: p_process_WF_requests THEN
4242: -- do not override return status set by process acceptance
4243: null;
4236: RAISE FND_API.G_EXC_ERROR;
4237: END IF;
4238:
4239: IF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4240: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND
4241: p_process_WF_requests THEN
4242: -- do not override return status set by process acceptance
4243: null;
4244: else
4362: G_Delayed_Requests(i).request_type);
4363:
4364: END IF;
4365:
4366: IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_VERSION_AUDIT) THEN --Bug # 5206049
4367: version_request_id := i;
4368: END IF;
4369:
4370: IF (G_Delayed_Requests(i).entity_code = p_entity_code
4455: END IF;
4456: -- Bug 3800577
4457: -- Reset versioning globals if version request is deleted
4458: IF G_Delayed_Requests(req_ind).request_type
4459: = OE_GLOBALS.G_VERSION_AUDIT
4460: THEN
4461: IF l_debug_level > 0 THEN
4462: oe_debug_pub.add('reset versioning globals');
4463: END IF;
4522: END IF;
4523:
4524: x_return_status := FND_API.G_RET_STS_SUCCESS;
4525:
4526: IF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO THEN
4527: IF l_debug_level > 0 THEN
4528: oe_debug_pub.add('.. schedule_ato '|| p_request_rec.entity_id, 1);
4529: END IF;
4530:
4535: END IF;
4536: WHILE K is not null
4537: LOOP
4538: IF G_Delayed_Requests(K).request_type
4539: = OE_GLOBALS.G_SCHEDULE_ATO AND
4540: G_Delayed_Requests(K).param2 = p_request_rec.param2 AND
4541: G_Delayed_Requests(K).param9 = 'Y'
4542: THEN
4543: IF l_debug_level > 0 THEN
4564: ( p_request_rec => p_request_rec
4565: ,x_return_status => x_return_status);
4566: END IF;
4567:
4568: ELSIF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_SMC THEN
4569: IF l_debug_level > 0 THEN
4570: oe_debug_pub.add('calling schedule_smc '|| p_request_rec.param24 , 1);
4571: END IF;
4572:
4573: OE_Config_Schedule_Pvt.Schedule_SMC
4574: ( p_request_rec => p_request_rec
4575: ,x_return_status => x_return_status);
4576:
4577: ELSIF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_NONSMC
4578: THEN
4579: I := 0;
4580: K := p_request_ind;
4581:
4581:
4582: WHILE K is not null
4583: LOOP
4584: IF G_Delayed_Requests(K).request_type
4585: = OE_GLOBALS.G_SCHEDULE_NONSMC AND
4586: G_Delayed_Requests(K).param2 = p_request_rec.param2 AND
4587: G_Delayed_Requests(K).param1 = p_request_rec.param1
4588: THEN
4589:
4624: ( p_request_tbl => l_request_tbl
4625: ,p_res_changes => l_res_changes
4626: ,x_return_status => x_return_status);
4627:
4628: ELSIF p_request_rec.request_type = OE_GLOBALS.G_DELAYED_SCHEDULE THEN
4629: if l_debug_level > 0 then
4630: oe_debug_pub.add('6663462 : calling delayed_schedule ' , 1);
4631: end if;
4632:
4669: BEGIN
4670:
4671: /* Added the following condition to fix the fp bug 3498435 */
4672:
4673: IF p_request_rec.request_type = OE_GLOBALS.G_PRICE_ORDER THEN
4674:
4675:
4676: IF l_debug_level > 0 THEN
4677: oe_debug_pub.add('Entering check_pricing_request in Oe_Delayed_Request_PVT.',1);
4914: p_request_unique_key1 => 'BATCH',
4915: p_request_unique_key2 => 'Y',
4916: x_return_status => l_return_status);
4917:
4918: log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4919: p_entity_id => p_request_rec.entity_id,
4920: p_requesting_entity_code => p_request_rec.entity_code,
4921: p_requesting_entity_id => p_request_rec.entity_id,
4922: p_request_unique_key1 => 'LINE',
4936: -- delete all other request for G_PRICE_ORDER.
4937: IF l_debug_level > 0 THEN
4938: oe_debug_pub.add('delete all other price_order request.',1);
4939: END IF;
4940: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
4941: p_entity_id => p_request_rec.entity_id,
4942: p_request_type => p_request_rec.request_type,
4943: p_request_unique_key1 => 'ORDER',
4944: x_return_status => l_return_status);
4941: p_entity_id => p_request_rec.entity_id,
4942: p_request_type => p_request_rec.request_type,
4943: p_request_unique_key1 => 'ORDER',
4944: x_return_status => l_return_status);
4945: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
4946: p_entity_id => p_request_rec.entity_id,
4947: p_request_type => p_request_rec.request_type,
4948: p_request_unique_key1 => 'BATCH',
4949: x_return_status => l_return_status);
4949: x_return_status => l_return_status);
4950: IF p_request_rec.request_unique_key1 = 'BATCH,BOOK'
4951: AND nvl(p_request_rec.request_unique_key2,'N') = 'N' THEN
4952: -- event is 'BATCH,BOOK'
4953: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
4954: p_entity_id => p_request_rec.entity_id,
4955: p_request_type => p_request_rec.request_type,
4956: p_request_unique_key1 => 'ORDER,BOOK',
4957: x_return_status => l_return_status);
4954: p_entity_id => p_request_rec.entity_id,
4955: p_request_type => p_request_rec.request_type,
4956: p_request_unique_key1 => 'ORDER,BOOK',
4957: x_return_status => l_return_status);
4958: delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
4959: p_entity_id => p_request_rec.entity_id,
4960: p_request_type => p_request_rec.request_type,
4961: p_request_unique_key1 => 'BATCH,BOOK',
4962: x_return_status => l_return_status);
5024: p_request_unique_key1 => 'BATCH,BOOK',
5025: p_request_unique_key2 => 'Y',
5026: x_return_status => l_return_status);
5027:
5028: log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5029: p_entity_id => p_request_rec.entity_id,
5030: p_requesting_entity_code => p_request_rec.entity_code,
5031: p_requesting_entity_id => p_request_rec.entity_id,
5032: p_request_unique_key1 => 'LINE',
5042:
5043: END IF;
5044:
5045: /* New code added to fix the fp bug 3498435 */
5046: ELSIF p_request_rec.request_type = OE_GLOBALS.G_PRICE_LINE THEN
5047: IF l_debug_level > 0 THEN
5048: oe_debug_pub.add('3498435: Entering check_pricing_request '||p_request_rec.request_unique_key1,1);
5049: END IF;
5050: IF p_request_rec.request_unique_key1 = 'LINE' THEN