[Home] [Help]
59: IS
60: l_ind PLS_INTEGER;
61: l_max_ind PLS_INTEGER;
62: --
63: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
64: --
65: BEGIN
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: x_result := FND_API.G_FALSE;
65: BEGIN
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: x_result := FND_API.G_FALSE;
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_Requests_Pvt');
70: END IF;
71: -- l_ind to l_max_ind is the range of index positions that can
72: -- hold requests for this entity id - for e.g. if entity_id is
73: -- 2341 and G_MAX_REQUESTS is 10000 then the range would be:
75:
76: l_ind := (mod(p_entity_id,100000) * G_MAX_REQUESTS)+1;
77: l_max_ind := l_ind + G_MAX_REQUESTS - 1;
78:
79: --oe_debug_pub.add('Max Ind :'||l_max_ind);
80:
81: -- Starting from l_ind, search for the first index position
82: -- with a request. This is required as requests can be
83: -- deleted later which will result in indexes without any
93: AND l_ind <= l_max_ind LOOP
94:
95: x_request_ind := l_ind+1;
96:
97: --oe_debug_pub.add('Index :'||l_ind);
98: --oe_debug_pub.add('Entity :'||G_Delayed_Requests(l_ind).Entity_code);
99: --oe_debug_pub.add('Entity ID:'||G_Delayed_Requests(l_ind).entity_id);
100: --oe_debug_pub.add('Request:'||G_Delayed_Requests(l_ind).request_type);
101:
94:
95: x_request_ind := l_ind+1;
96:
97: --oe_debug_pub.add('Index :'||l_ind);
98: --oe_debug_pub.add('Entity :'||G_Delayed_Requests(l_ind).Entity_code);
99: --oe_debug_pub.add('Entity ID:'||G_Delayed_Requests(l_ind).entity_id);
100: --oe_debug_pub.add('Request:'||G_Delayed_Requests(l_ind).request_type);
101:
102: IF G_Delayed_Requests(l_ind).Entity_code = p_entity_code
95: x_request_ind := l_ind+1;
96:
97: --oe_debug_pub.add('Index :'||l_ind);
98: --oe_debug_pub.add('Entity :'||G_Delayed_Requests(l_ind).Entity_code);
99: --oe_debug_pub.add('Entity ID:'||G_Delayed_Requests(l_ind).entity_id);
100: --oe_debug_pub.add('Request:'||G_Delayed_Requests(l_ind).request_type);
101:
102: IF G_Delayed_Requests(l_ind).Entity_code = p_entity_code
103: AND
96:
97: --oe_debug_pub.add('Index :'||l_ind);
98: --oe_debug_pub.add('Entity :'||G_Delayed_Requests(l_ind).Entity_code);
99: --oe_debug_pub.add('Entity ID:'||G_Delayed_Requests(l_ind).entity_id);
100: --oe_debug_pub.add('Request:'||G_Delayed_Requests(l_ind).request_type);
101:
102: IF G_Delayed_Requests(l_ind).Entity_code = p_entity_code
103: AND
104: G_Delayed_Requests(l_ind).Entity_id = p_entity_id
209: l_header_id NUMBER; -- For IR ISO CMS Project
210: l_line_id NUMBER; -- For IR ISO CMS Project
211: l_cancel_order BOOLEAN := FALSE; -- For IR ISO CMS Project
212: --
213: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
214: --
215: l_mod_entity_id number; -- Bug 8636027
216:
217: l_otm_volume NUMBER; --BUG#10052614
225:
226:
227: BEGIN
228: IF l_debug_level > 0 THEN
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
226:
227: BEGIN
228: IF l_debug_level > 0 THEN
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
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;
238: END IF;
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
251: l_entity_code := l_request_rec.entity_code;
252: l_entity_Id := l_request_rec.entity_Id;
253: l_request_type := l_request_rec.request_type;
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add('Request type '||l_request_type,1);
256: oe_debug_pub.add('Entity id '||l_entity_id, 5);
257: oe_debug_pub.add('param1 '||l_request_rec.param1, 5);
258: oe_debug_pub.add('param2 '||l_request_rec.param2, 5);
259: oe_debug_pub.add('param3 '||l_request_rec.param3, 5);
252: l_entity_Id := l_request_rec.entity_Id;
253: l_request_type := l_request_rec.request_type;
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add('Request type '||l_request_type,1);
256: oe_debug_pub.add('Entity id '||l_entity_id, 5);
257: oe_debug_pub.add('param1 '||l_request_rec.param1, 5);
258: oe_debug_pub.add('param2 '||l_request_rec.param2, 5);
259: oe_debug_pub.add('param3 '||l_request_rec.param3, 5);
260: END IF;
253: l_request_type := l_request_rec.request_type;
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add('Request type '||l_request_type,1);
256: oe_debug_pub.add('Entity id '||l_entity_id, 5);
257: oe_debug_pub.add('param1 '||l_request_rec.param1, 5);
258: oe_debug_pub.add('param2 '||l_request_rec.param2, 5);
259: oe_debug_pub.add('param3 '||l_request_rec.param3, 5);
260: END IF;
261: G_Delayed_Requests(p_request_ind).processed := 'I';
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add('Request type '||l_request_type,1);
256: oe_debug_pub.add('Entity id '||l_entity_id, 5);
257: oe_debug_pub.add('param1 '||l_request_rec.param1, 5);
258: oe_debug_pub.add('param2 '||l_request_rec.param2, 5);
259: oe_debug_pub.add('param3 '||l_request_rec.param3, 5);
260: END IF;
261: G_Delayed_Requests(p_request_ind).processed := 'I';
262:
255: oe_debug_pub.add('Request type '||l_request_type,1);
256: oe_debug_pub.add('Entity id '||l_entity_id, 5);
257: oe_debug_pub.add('param1 '||l_request_rec.param1, 5);
258: oe_debug_pub.add('param2 '||l_request_rec.param2, 5);
259: oe_debug_pub.add('param3 '||l_request_rec.param3, 5);
260: END IF;
261: G_Delayed_Requests(p_request_ind).processed := 'I';
262:
263: IF l_debug_level > 0 THEN
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;
269: END IF;
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;
269: END IF;
270: -- Fix Bug 2062937: Do not set the cascade flag blindly for certain
271: -- delayed requests.
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;
297: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
298: END IF;
299:
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
336: G_PRICE_ADJ request is now logged against LINE entity
337: */
391: WHEN NO_DATA_FOUND THEN
392: l_tax_calculation_event_code := 0;
393: WHEN OTHERS THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add('OEXVREQB:Failed while trying to query up tax_calcualtion_event for order_type_id ');
396: END IF;
397:
398: RAISE;
399: END;
404: l_current_event := 1; /* current event is booking or higher */
405: END IF;
406:
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add('OEXVREQB:Tax Event Code :'||l_tax_calculation_event_code);
409: oe_debug_pub.add('OEXVREQB:Current Event :'||l_current_event);
410: END IF;
411:
412: IF l_current_event >= l_tax_calculation_event_code THEN
405: END IF;
406:
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add('OEXVREQB:Tax Event Code :'||l_tax_calculation_event_code);
409: oe_debug_pub.add('OEXVREQB:Current Event :'||l_current_event);
410: END IF;
411:
412: IF l_current_event >= l_tax_calculation_event_code THEN
413:
438:
439:
440: End if;
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
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
602: wf_engine.CompleteActivityInternalName(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,l_request_rec.param4,true);
603: exception
601: BEGIN --15870313
602: wf_engine.CompleteActivityInternalName(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,l_request_rec.param4,true);
603: exception
604: WHEN OTHERS THEN
605: oe_debug_pub.add('Workflow complete activity failed. Raising');
606: RAISE ;
607: END ;
608:
609: IF l_debug_level > 0 THEN
606: RAISE ;
607: END ;
608:
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
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
618: wf_engine.CompleteActivityInternalName(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,l_request_rec.param4,TRUE );--15870313
619: EXCEPTION
618: wf_engine.CompleteActivityInternalName(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,l_request_rec.param4,TRUE );--15870313
619: EXCEPTION
620: WHEN OTHERS THEN
621: IF l_debug_level > 0 THEN
622: oe_debug_pub.ADD('Calling wf_engine.handleerror for '||l_request_rec.param1 || '/'||l_request_rec.param2||'/'||l_request_rec.param3 ||'/'||'/'||l_request_rec.param4, 3);
623: END IF;
624: OE_SHIPPING_WF.G_DEV_SKIP := 'Y';
625: wf_engine.handleerror(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,'SKIP',l_request_rec.param4);
626: if l_debug_level > 0 then
623: END IF;
624: OE_SHIPPING_WF.G_DEV_SKIP := 'Y';
625: wf_engine.handleerror(l_request_rec.param1,l_request_rec.param2,l_request_rec.param3,'SKIP',l_request_rec.param4);
626: if l_debug_level > 0 then
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
666: and Process_Delayed_Request procedures
667: */
668:
669: If l_debug_level > 0 then
670: oe_debug_pub.add(' Processing DOO Pre Exploded ER');
671: End if;
672:
673: OE_Delayed_Requests_UTIL.Process_Pre_Exploded_Kits
674: ( p_top_model_line_id => l_request_rec.entity_id
675: , p_explosion_date => l_request_rec.date_param1
676: , x_return_status => l_return_status);
677:
678: If l_debug_level > 0 then
679: oe_debug_pub.add(' Processed DOO Pre Exploded ER');
680: End if;
681:
682: /* End DOO Pre Exploded Kit ER 9339742 */
683:
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);
700: END IF;
701: l_cancel_order := TRUE;
702:
703: -- For Requisition Header Cancellation, following information is not needed -
705: l_request_rec.param4 := NULL; --bug 14211120
706: l_request_rec.date_param1 := NULL;
707: ELSE
708: IF l_debug_level > 0 THEN
709: oe_debug_pub.add('Requisition Header Cancellation is FALSE',5);
710: END IF;
711: l_cancel_order := FALSE;
712: END IF;
713:
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:
747: OE_CONFIG_UTIL.CASCADE_CHANGES
748: ( p_parent_line_id => l_request_rec.entity_id
749: , p_request_rec => l_request_rec
750: , x_return_status => l_return_status
751: );
752: IF l_debug_level > 0 THEN
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
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
762: ( p_request_rec => l_request_rec
763: , x_return_status => l_return_status
762: ( p_request_rec => l_request_rec
763: , x_return_status => l_return_status
764: );
765: IF l_debug_level > 0 THEN
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
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;
811:
812: ELSIF l_request_type = OE_GLOBALS.G_DELETE_OPTION THEN
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;
817:
818: ELSIF l_request_type =
854: END IF;
855: K := G_Delayed_Requests.NEXT(K);
856: END LOOP;
857: IF l_debug_level > 0 THEN
858: oe_debug_pub.add('out of loop for upd/del options table', 1);
859: END IF;
860:
861: OE_DELAYED_REQUESTS_UTIL.VALIDATE_CONFIGURATION
862: ( p_top_model_line_id => l_request_rec.entity_id
864: , p_updated_options_tbl => l_updated_options_tbl
865: , x_return_status => l_return_status
866: );
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add('ret sts: '|| x_return_status, 4);
869: END IF;
870:
871: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
872: oe_debug_pub.add('deleteing after success ', 3);
868: oe_debug_pub.add('ret sts: '|| x_return_status, 4);
869: END IF;
870:
871: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
872: oe_debug_pub.add('deleteing after success ', 3);
873: K := G_Delayed_Requests.FIRST;
874:
875: WHILE K is not null
876: LOOP
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;
897:
898: ELSIF l_request_type =
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;
904:
905: K := G_Delayed_Requests.FIRST;
906:
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);
915: END IF;
916: IF G_Delayed_Requests(K).request_unique_key1 = 'Quantity'
917: THEN
918: l_cto_request_rec.param1 := G_Delayed_Requests(K).param1;
962: ELSIF G_Delayed_Requests(K).request_unique_key1 =
963: 'Config Chg pto_ato'
964: THEN
965: IF l_debug_level > 0 THEN
966: oe_debug_pub.add('ptoato '|| G_Delayed_Requests(K).param4, 1);
967: END IF;
968: l_cto_request_tbl(K).param1 := G_Delayed_Requests(K).param4;
969: l_cto_request_tbl(K).param2 := G_Delayed_Requests(K).param5;
970:
971: ELSIF G_Delayed_Requests(K).request_unique_key1 =
972: 'Decimal Chg'
973: THEN
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('for decimal '||G_Delayed_Requests(K).entity_id, 1);
976: END IF;
977: l_cto_decimal_tbl(K) := G_Delayed_Requests(K);
978:
979: ELSIF G_Delayed_Requests(K).request_unique_key1 =
979: ELSIF G_Delayed_Requests(K).request_unique_key1 =
980: 'Split Create'
981: THEN
982: IF l_debug_level > 0 THEN
983: oe_debug_pub.add('split '|| G_Delayed_Requests(K).param4, 1);
984: END IF;
985: l_cto_split_tbl(K) := G_Delayed_Requests(K);
986: END IF;
987: IF l_debug_level > 0 THEN
984: END IF;
985: l_cto_split_tbl(K) := G_Delayed_Requests(K);
986: END IF;
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add(G_Delayed_Requests(K).request_unique_key1, 4);
989: END IF;
990: --G_Delayed_Requests.delete(K);
991: END IF;
992:
990: --G_Delayed_Requests.delete(K);
991: END IF;
992:
993: IF l_debug_level > 0 THEN
994: oe_debug_pub.add('cto looping', 4);
995: END IF;
996:
997: K := G_Delayed_Requests.NEXT(K);
998: END LOOP;
1006: , x_return_status => l_return_status);
1007:
1008: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add('deleteing after success ', 3);
1011: END IF;
1012: K := G_Delayed_Requests.FIRST;
1013:
1014: WHILE K is not null
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:
1131: OE_DELAYED_REQUESTS_UTIL.REVERSE_LIMITS
1132: ( x_return_status => l_return_status
1138: , p_returned_qty => to_number(l_request_rec.param6)
1139: , p_line_id => l_request_rec.entity_id
1140: );
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Call Issued to OE_DELAYED_REQUESTS_UTIL.Reverse_Limits',1);
1143: END IF;
1144: /* BUG 2013611 END */
1145:
1146: -- Freight Rating.
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
1152: ( p_header_id => l_request_rec.entity_id
1153: ,p_line_id => null
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;
1168: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
1169: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
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;
1168: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
1169: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1170: l_Price_Control_Rec.Simulation_Flag := 'N';
1175: l_price_control_rec.source_order_amount_flag := 'Y';
1176: End If;
1177: --RT}
1178: IF l_debug_level > 0 THEN
1179: Oe_Debug_pub.Add('Before Line Price');
1180: END IF;
1181: oe_order_adj_pvt.Price_line(
1182: X_Return_Status => l_Return_Status
1183: ,p_Line_id => l_request_rec.entity_id
1187: ,p_request_rec => l_request_rec
1188: ,x_line_Tbl => l_Line_Tbl
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);
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);
1198: Oe_Debug_pub.Add('The Action is '||l_request_rec.param3);
1199: Oe_Debug_pub.Add('The get freight flag is: '||l_request_rec.request_unique_key2, 3);
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);
1198: Oe_Debug_pub.Add('The Action is '||l_request_rec.param3);
1199: Oe_Debug_pub.Add('The get freight flag is: '||l_request_rec.request_unique_key2, 3);
1200: 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);
1198: Oe_Debug_pub.Add('The Action is '||l_request_rec.param3);
1199: Oe_Debug_pub.Add('The get freight flag is: '||l_request_rec.request_unique_key2, 3);
1200: END IF;
1201: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
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);
1198: Oe_Debug_pub.Add('The Action is '||l_request_rec.param3);
1199: Oe_Debug_pub.Add('The get freight flag is: '||l_request_rec.request_unique_key2, 3);
1200: END IF;
1201: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
1202: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
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);
1198: Oe_Debug_pub.Add('The Action is '||l_request_rec.param3);
1199: Oe_Debug_pub.Add('The get freight flag is: '||l_request_rec.request_unique_key2, 3);
1200: END IF;
1201: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
1202: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1203: l_Price_Control_Rec.Simulation_Flag := 'N';
1218: ,x_line_Tbl => l_Line_Tbl
1219: ,p_action_code => l_request_rec.param3
1220: );
1221: IF l_debug_level > 0 THEN
1222: Oe_Debug_pub.Add('After Header Price');
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 */
1219: ,p_action_code => l_request_rec.param3
1220: );
1221: IF l_debug_level > 0 THEN
1222: Oe_Debug_pub.Add('After Header Price');
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
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();
1232: IF l_debug_level > 0 THEN
1233: Oe_Debug_pub.Add('After Defaulting Contingency Attributes ');
1229: Oe_Debug_pub.Add('Before Defaulting Contingency Attributes ');
1230: END IF;
1231: OE_ACCEPTANCE_UTIL.Default_contingency_Attributes();
1232: IF l_debug_level > 0 THEN
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
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;
1242: OE_DELAYED_REQUESTS_UTIL.FIRST_PERIOD_BILL_AMT
1243: (p_header_id => NULL,
1244: p_line_id => l_request_rec.param1,
1244: p_line_id => l_request_rec.param1,
1245: x_return_status => l_return_status);
1246: Elsif l_request_rec.request_unique_key1 = 'ORDER' then
1247: IF l_debug_level > 0 THEN
1248: Oe_Debug_pub.Add('Executing G_SERVICE_FIRST_PERIOD_BILL for Order ');
1249: END IF;
1250: OE_DELAYED_REQUESTS_UTIL.FIRST_PERIOD_BILL_AMT
1251: (p_header_id => l_request_rec.param1,
1252: p_line_id => NULL ,
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;
1262:
1263: WHILE l_prc_adj_index is NOT NULL LOOP
1261: l_prc_adj_index := G_Delayed_Requests.first;
1262:
1263: WHILE l_prc_adj_index is NOT NULL LOOP
1264: IF l_debug_level > 0 THEN
1265: oe_debug_pub.add('Ren 0: Param1 :' || l_request_rec.param1);
1266: END IF;
1267: IF G_Delayed_Requests(l_prc_adj_index).request_type = l_request_type THEN
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add('REN: SUCCESS - FOUND THE REQUEST');
1265: oe_debug_pub.add('Ren 0: Param1 :' || l_request_rec.param1);
1266: END IF;
1267: IF G_Delayed_Requests(l_prc_adj_index).request_type = l_request_type THEN
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add('REN: SUCCESS - FOUND THE REQUEST');
1270:
1271: oe_debug_pub.add('Ren 1: Param2 :' || g_delayed_requests(l_prc_adj_index).param2);
1272: END IF;
1273:
1267: IF G_Delayed_Requests(l_prc_adj_index).request_type = l_request_type THEN
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add('REN: SUCCESS - FOUND THE REQUEST');
1270:
1271: oe_debug_pub.add('Ren 1: Param2 :' || g_delayed_requests(l_prc_adj_index).param2);
1272: END IF;
1273:
1274: l_prc_adj_request(I) := g_delayed_requests(l_prc_adj_index);
1275: oe_debug_pub.add('Ren 2: Param2 :' || l_prc_adj_request(I).param2);
1271: oe_debug_pub.add('Ren 1: Param2 :' || g_delayed_requests(l_prc_adj_index).param2);
1272: END IF;
1273:
1274: l_prc_adj_request(I) := g_delayed_requests(l_prc_adj_index);
1275: oe_debug_pub.add('Ren 2: Param2 :' || l_prc_adj_request(I).param2);
1276: g_delayed_requests.delete(l_prc_adj_index);
1277: IF l_debug_level > 0 THEN
1278: oe_debug_pub.add('Ren 3: Param2 :' || l_prc_adj_request(I).param2);
1279: END IF;
1274: l_prc_adj_request(I) := g_delayed_requests(l_prc_adj_index);
1275: oe_debug_pub.add('Ren 2: Param2 :' || l_prc_adj_request(I).param2);
1276: g_delayed_requests.delete(l_prc_adj_index);
1277: IF l_debug_level > 0 THEN
1278: oe_debug_pub.add('Ren 3: Param2 :' || l_prc_adj_request(I).param2);
1279: END IF;
1280: I := I + 1;
1281:
1282: ELSE
1280: I := I + 1;
1281:
1282: ELSE
1283: IF l_debug_level > 0 THEN
1284: oe_debug_pub.add('Ren: Req not found ' || l_prc_adj_index);
1285: END IF;
1286:
1287: END IF;
1288:
1291: END LOOP;
1292:
1293: IF l_prc_adj_request.count > 0 THEN
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.add('before calling process_adjustments ');
1296: END IF;
1297:
1298: OE_DELAYED_REQUESTS_UTIL.Process_Adjustments
1299: (p_adjust_tbl => l_prc_adj_request,
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)
1350: ,p_to_line_id => l_request_rec.entity_id
1351: ,p_from_pr_adjustment_id =>to_number(l_request_rec.param4)
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:
1387: OE_Service_Util.cascade_changes
1388: ( p_parent_line_id => l_request_rec.entity_id
1389: ,p_request_rec => l_request_rec
1390: ,x_return_status => l_return_status
1391: );
1392: IF l_debug_level > 0 THEN
1393: oe_debug_pub.add('CSH-- After calls OE_Service_Util.cascade_changes', 1);
1394: END IF;
1395:
1396: /* lchen added for bug #1761154 */
1397:
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
1403: ( x_return_status => l_return_status
1404: , p_option_line_id => l_entity_id
1403: ( x_return_status => l_return_status
1404: , p_option_line_id => l_entity_id
1405: );
1406: IF l_debug_level > 0 THEN
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
1559: ( p_request_rec => l_request_rec
1560: , x_return_status => l_return_status);
1561:
1562: IF l_debug_level > 0 THEN
1563: oe_debug_pub.add('Group Schedule Return Status ' || l_return_status,1);
1564: END IF;
1565: --11825106
1566: IF nvl(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS'),'Y') = 'N'
1567: AND l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1595: END LOOP;
1596:
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
1624:
1625: K := G_Delayed_Requests.NEXT(K);
1626: END LOOP;
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add('Calling Sch_Line with '|| l_sch_set_tbl.count,1);
1629: END IF;
1630:
1631: -- Commented out the below code -Bug4504362
1632: OE_GROUP_SCH_UTIL.Schedule_Set_lines
1634: , x_return_status => l_return_status);
1635:
1636:
1637: IF l_debug_level > 0 THEN
1638: oe_debug_pub.add('After Calling Sch_Line: '|| l_return_status,1);
1639: END IF;
1640:
1641: -- If Schedule_Line is success for all the lines, mark
1642: -- the request for others lines as processed.
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:
1673: --bug 3560198
1674: OE_Commitment_Pvt.calculate_commitment(
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);
1691: END IF;
1692: OE_Commitment_Pvt.update_commitment_applied
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);
1691: END IF;
1692: OE_Commitment_Pvt.update_commitment_applied
1693: ( p_line_id => l_request_rec.entity_id
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);
1691: END IF;
1692: OE_Commitment_Pvt.update_commitment_applied
1693: ( p_line_id => l_request_rec.entity_id
1694: ,p_amount => l_request_rec.param1
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
1707: ( p_ord_header_id => l_entity_id
1708: ,x_return_status => l_return_status);
1706: OE_DELAYED_REQUESTS_UTIL.auto_create_internal_req
1707: ( p_ord_header_id => l_entity_id
1708: ,x_return_status => l_return_status);
1709: IF l_debug_level > 0 THEN
1710: oe_debug_pub.add('After Calling auto_create_internal_req ret_status : '|| l_return_status,1);
1711: END IF;
1712:
1713: /* Modified the following condition to fix the bug 6663462 */
1714:
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
1723: ( p_request_ind => p_request_ind
1724: ,p_request_rec => l_request_rec
1723: ( p_request_ind => p_request_ind
1724: ,p_request_rec => l_request_rec
1725: ,x_return_status => l_return_status);
1726: IF l_debug_level > 0 THEN
1727: oe_debug_pub.add('Scheduling_Request '|| l_return_status);
1728: END IF;
1729: ---------
1730: -- Added by rsreeniv
1731: ----------
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);
1737: END IF;
1738: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
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);
1737: END IF;
1738: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
1739: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
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);
1737: END IF;
1738: l_Price_Control_Rec.pricing_event := l_request_rec.param2;
1739: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1740: l_Price_Control_Rec.Simulation_Flag := 'N';
1769: ,p_request_rec => l_request_rec
1770: ,x_line_Tbl => l_Line_Tbl
1771: );
1772: IF l_debug_level > 0 THEN
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
1770: ,x_line_Tbl => l_Line_Tbl
1771: );
1772: IF l_debug_level > 0 THEN
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
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);
1782: --MRG END
1783: -------------
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);
1794: --MRG END
1795:
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:
1802: Oe_Line_Adj_Util.Delete_Changed_Lines_Tbl;
1803: IF l_debug_level > 0 THEN
1800: END IF;
1801:
1802: Oe_Line_Adj_Util.Delete_Changed_Lines_Tbl;
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:
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;
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:
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
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
1883: payment_line_id := NULL;
1884: END IF;
1885:
1886: IF l_debug_level > 0 THEN
1887: oe_debug_pub.add('header id for update_hdr_payment is : ' || payment_header_id,3);
1888: oe_debug_pub.add('line id for update_hdr_payment is : ' || payment_line_id,3);
1889: END IF;
1890:
1891: OE_PrePayment_Pvt.Update_Hdr_Payment (
1884: END IF;
1885:
1886: IF l_debug_level > 0 THEN
1887: oe_debug_pub.add('header id for update_hdr_payment is : ' || payment_header_id,3);
1888: oe_debug_pub.add('line id for update_hdr_payment is : ' || payment_line_id,3);
1889: END IF;
1890:
1891: OE_PrePayment_Pvt.Update_Hdr_Payment (
1892: p_header_id => payment_header_id
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;
1905:
1906: OE_PREPAYMENT_PVT.Process_Payments(
1907: p_header_id => l_request_rec.entity_id,
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
1921: IF l_debug_level > 0 THEN
1922: oe_debug_pub.add('Before calling Process_Payments Procedure at the header level');
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:
1925: OE_PREPAYMENT_PVT.Process_Payments(
1926: p_header_id => l_request_rec.entity_id,
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:
1940: OE_PREPAYMENT_PVT.Process_Payments(
1941: p_header_id => l_request_rec.entity_id,
1960: payment_line_id := NULL;
1961: END IF;
1962:
1963: IF l_debug_level > 0 THEN
1964: oe_debug_pub.add('header id for delete_payment_hold is : ' || payment_header_id,3);
1965: oe_debug_pub.add('line id for delete_payment_hold is : ' || payment_line_id,3);
1966: END IF;
1967:
1968: OE_PrePayment_Pvt.Delete_Payment_Hold
1961: END IF;
1962:
1963: IF l_debug_level > 0 THEN
1964: oe_debug_pub.add('header id for delete_payment_hold is : ' || payment_header_id,3);
1965: oe_debug_pub.add('line id for delete_payment_hold is : ' || payment_line_id,3);
1966: END IF;
1967:
1968: OE_PrePayment_Pvt.Delete_Payment_Hold
1969: ( p_line_id => payment_line_id
2009: old_invoice_to_org_id := to_number(l_request_rec.param1);
2010: END IF;
2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add('header id for delete_payments is : ' || payment_header_id,3);
2014: oe_debug_pub.add('line id for delete_payments is : ' || payment_line_id,3);
2015: END IF;
2016:
2017: OE_PrePayment_Pvt.Delete_Payments
2010: END IF;
2011:
2012: IF l_debug_level > 0 THEN
2013: oe_debug_pub.add('header id for delete_payments is : ' || payment_header_id,3);
2014: oe_debug_pub.add('line id for delete_payments is : ' || payment_line_id,3);
2015: END IF;
2016:
2017: OE_PrePayment_Pvt.Delete_Payments
2018: ( p_line_id => payment_line_id
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
2034: );
2035: */
2036: oe_debug_pub.add(' OEXVREQB.pls : Building dynamic call string for calling OZF_VOLUME_CALCULATION_PUB.copy_order_group_details', 3);
2037: l_dynamic_call := 'declare ' ||
2038: 'begin ' ||
2039: ':return_value := OZF_VOLUME_CALCULATION_PUB.copy_order_group_details' ||
2040: '( p_to_order_line_id => :l_to_order_line_id, ' ||
2039: ':return_value := OZF_VOLUME_CALCULATION_PUB.copy_order_group_details' ||
2040: '( p_to_order_line_id => :l_to_order_line_id, ' ||
2041: ' p_from_order_line_id => :l_from_order_line_id ); ' ||
2042: 'end;';
2043: oe_debug_pub.add(' OEXVREQB.pls : dynamics sql : ' || l_dynamic_call, 3);
2044:
2045: Begin
2046: EXECUTE IMMEDIATE l_dynamic_call USING OUT l_otm_volume, IN l_entity_id, IN l_request_rec.param2;
2047:
2044:
2045: Begin
2046: EXECUTE IMMEDIATE l_dynamic_call USING OUT l_otm_volume, IN l_entity_id, IN l_request_rec.param2;
2047:
2048: oe_debug_pub.add('Return from OTM after executing delayed request : ' || l_otm_volume,3);
2049:
2050: Exception When OTHERS Then
2051: oe_debug_pub.add('Erroring calling OTM API, please check if the dependent OTM patch is applied and if OZF_VOLUME_CALCULATION_PUB.copy_order_group_details API existis in the DB', 1);
2052: End;
2047:
2048: oe_debug_pub.add('Return from OTM after executing delayed request : ' || l_otm_volume,3);
2049:
2050: Exception When OTHERS Then
2051: oe_debug_pub.add('Erroring calling OTM API, please check if the dependent OTM patch is applied and if OZF_VOLUME_CALCULATION_PUB.copy_order_group_details API existis in the DB', 1);
2052: End;
2053: --BUG#10052614 Ends
2054:
2055: ELSE
2108: --ELSE
2109: -- G_Delayed_Requests(p_request_ind).processed := 'Y';
2110: --END IF;
2111: IF l_debug_level > 0 THEN
2112: oe_debug_pub.add('leaving Process_Request_Pvt', 1);
2113: END IF;
2114: EXCEPTION
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2113: END IF;
2114: EXCEPTION
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117: oe_debug_pub.add('exe error Process_Request_Pvt', 1);
2118: /* commented the fowwoing 2 debug messages to fix the bug 13256519 */
2119: /*
2120: oe_debug_pub.add
2121: ('1 type----- '|| G_Delayed_Requests(p_request_ind).request_type, 1);
2116: WHEN FND_API.G_EXC_ERROR THEN
2117: oe_debug_pub.add('exe error Process_Request_Pvt', 1);
2118: /* commented the fowwoing 2 debug messages to fix the bug 13256519 */
2119: /*
2120: oe_debug_pub.add
2121: ('1 type----- '|| G_Delayed_Requests(p_request_ind).request_type, 1);
2122: oe_debug_pub.add
2123: ('1 ind----- '|| p_request_ind, 1);
2124: */
2118: /* commented the fowwoing 2 debug messages to fix the bug 13256519 */
2119: /*
2120: oe_debug_pub.add
2121: ('1 type----- '|| G_Delayed_Requests(p_request_ind).request_type, 1);
2122: oe_debug_pub.add
2123: ('1 ind----- '|| p_request_ind, 1);
2124: */
2125: IF (p_delete = FND_API.G_TRUE)
2126: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2136: END IF;
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
2141: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);
2142:
2143: IF (p_delete = FND_API.G_TRUE)
2144: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
2141: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);
2142:
2143: IF (p_delete = FND_API.G_TRUE)
2144: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2145: -- Bug 11811300 starts
2154: END IF;
2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2156:
2157: WHEN NO_DATA_FOUND THEN
2158: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
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
2177: );
2178: END IF;
2179:
2180: WHEN OTHERS THEN
2181: oe_debug_pub.add('SQL ERROR MESSAGE FOR WHEN OTHRES:'||SQLERRM);
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
2200: , 'Process_Request_Pvt'
2201: );
2202: END IF;
2203:
2204: oe_debug_pub.add('Exiting Process_Request_Pvt with others exception ');
2205:
2206:
2207: End Process_Request_Pvt;
2208:
2264: l_req_entity_ind NUMBER;
2265: l_request OE_Order_PUB.REQUEST_REC_TYPE;
2266: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
2267: l_log_request VARCHAR2(1);
2268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2269: BEGIN
2270:
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add('Entering Procedure Log_Request in Package OE_Delayed_Requests_Pvt, entity id: '||p_entity_id||', request type:'||p_request_type);
2268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2269: BEGIN
2270:
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add('Entering Procedure Log_Request in Package OE_Delayed_Requests_Pvt, entity id: '||p_entity_id||', request type:'||p_request_type);
2273: END IF;
2274:
2275: -- Initialize the request_record
2276: l_request.request_type := p_request_type;
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;
2348: ELSE
2349: oe_debug_pub.add('Called from Mass Change, last line reached, logging G_DEL_CHG_LINES request');
2350: END IF;
2345: THEN
2346: oe_debug_pub.add('Called from Mass Change, line remaining, NOT logging G_DEL_CHG_LINES request');
2347: RETURN;
2348: ELSE
2349: oe_debug_pub.add('Called from Mass Change, last line reached, logging G_DEL_CHG_LINES request');
2350: END IF;
2351: END IF;
2352: -- End of bug 12673852
2353:
2366: AND nvl(l_request.request_unique_key2,'N') = 'N')
2367: AND l_request_search_rslt = FND_API.g_false THEN
2368:
2369: IF l_debug_level > 0 THEN
2370: oe_debug_pub.add('In log_request, calling check_pricing_request.',3);
2371: oe_debug_pub.add('request_unique_key1 is: '||l_request.request_unique_key1,3);
2372: oe_debug_pub.add('request_unique_key2 is: '||l_request.request_unique_key2,3);
2373: END IF;
2374: Check_Pricing_Request
2367: AND l_request_search_rslt = FND_API.g_false THEN
2368:
2369: IF l_debug_level > 0 THEN
2370: oe_debug_pub.add('In log_request, calling check_pricing_request.',3);
2371: oe_debug_pub.add('request_unique_key1 is: '||l_request.request_unique_key1,3);
2372: oe_debug_pub.add('request_unique_key2 is: '||l_request.request_unique_key2,3);
2373: END IF;
2374: Check_Pricing_Request
2375: ( p_request_ind => l_request_ind
2368:
2369: IF l_debug_level > 0 THEN
2370: oe_debug_pub.add('In log_request, calling check_pricing_request.',3);
2371: oe_debug_pub.add('request_unique_key1 is: '||l_request.request_unique_key1,3);
2372: oe_debug_pub.add('request_unique_key2 is: '||l_request.request_unique_key2,3);
2373: END IF;
2374: Check_Pricing_Request
2375: ( p_request_ind => l_request_ind
2376: ,p_request_rec => l_request
2383:
2384: --Bug 7566697
2385: IF oe_mass_change_pvt.Lines_Remaining = 'Y'
2386: THEN
2387: oe_debug_pub.add('Called from Mass Change, line remaining, NOT logging pricing request');
2388: RETURN;
2389: ELSE
2390: oe_debug_pub.add('Called from Mass Change, last line reached, logging pricing request');
2391: END IF;
2386: THEN
2387: oe_debug_pub.add('Called from Mass Change, line remaining, NOT logging pricing request');
2388: RETURN;
2389: ELSE
2390: oe_debug_pub.add('Called from Mass Change, last line reached, logging pricing request');
2391: END IF;
2392:
2393: END IF;
2394:
2416:
2417: IF l_request_search_rslt = FND_API.g_true -- replace the request
2418: THEN
2419: IF l_debug_level > 0 THEN
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
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;
2429: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2430:
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;
2437:
2438: l_request.param4 := g_delayed_requests(l_request_ind).param4;
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;
2447: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2448: l_request.param2 := g_delayed_requests(l_request_ind).param2;
2449: l_request.param3 := g_delayed_requests(l_request_ind).param3;
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:
2570: IF g_delayed_requests(l_request_ind).param1 IS NOT NULL
2571: AND l_request.param1 IS NULL THEN
2569:
2570: IF g_delayed_requests(l_request_ind).param1 IS NOT NULL
2571: AND l_request.param1 IS NULL THEN
2572: IF l_debug_level > 0 THEN
2573: oe_debug_pub.add(' Retaining Delta Quantity change for index '||l_request_ind,5);
2574: oe_debug_pub.add(' Old Delta Quantity change is '||g_delayed_requests(l_request_ind).param1,5);
2575: oe_debug_pub.add(' New Delta Quantity change is NULL',5);
2576: END IF;
2577: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2570: IF g_delayed_requests(l_request_ind).param1 IS NOT NULL
2571: AND l_request.param1 IS NULL THEN
2572: IF l_debug_level > 0 THEN
2573: oe_debug_pub.add(' Retaining Delta Quantity change for index '||l_request_ind,5);
2574: oe_debug_pub.add(' Old Delta Quantity change is '||g_delayed_requests(l_request_ind).param1,5);
2575: oe_debug_pub.add(' New Delta Quantity change is NULL',5);
2576: END IF;
2577: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2578: -- Retaining the delta quantity change value if the new delta change is null, which could
2571: AND l_request.param1 IS NULL THEN
2572: IF l_debug_level > 0 THEN
2573: oe_debug_pub.add(' Retaining Delta Quantity change for index '||l_request_ind,5);
2574: oe_debug_pub.add(' Old Delta Quantity change is '||g_delayed_requests(l_request_ind).param1,5);
2575: oe_debug_pub.add(' New Delta Quantity change is NULL',5);
2576: END IF;
2577: l_request.param1 := g_delayed_requests(l_request_ind).param1;
2578: -- Retaining the delta quantity change value if the new delta change is null, which could
2579: -- be typically a case when user will change the order quantity first, and then the
2585: END IF;
2586:
2587: IF NVL(g_delayed_requests(l_request_ind).param2,'N') = 'Y' THEN
2588: IF l_debug_level > 0 THEN
2589: oe_debug_pub.add(' Retaining Header Level Cancellation Flag for index '||l_request_ind,5);
2590: oe_debug_pub.add(' Old Header Level Cancelation flag is '||g_delayed_requests(l_request_ind).param2,5);
2591: oe_debug_pub.add(' New Header Level Cancelation flag is '||l_request.param2,5);
2592: END IF;
2593: l_request.param2 := g_delayed_requests(l_request_ind).param2;
2586:
2587: IF NVL(g_delayed_requests(l_request_ind).param2,'N') = 'Y' THEN
2588: IF l_debug_level > 0 THEN
2589: oe_debug_pub.add(' Retaining Header Level Cancellation Flag for index '||l_request_ind,5);
2590: oe_debug_pub.add(' Old Header Level Cancelation flag is '||g_delayed_requests(l_request_ind).param2,5);
2591: oe_debug_pub.add(' New Header Level Cancelation flag is '||l_request.param2,5);
2592: END IF;
2593: l_request.param2 := g_delayed_requests(l_request_ind).param2;
2594: -- Order Header is requested for cancellation
2587: IF NVL(g_delayed_requests(l_request_ind).param2,'N') = 'Y' THEN
2588: IF l_debug_level > 0 THEN
2589: oe_debug_pub.add(' Retaining Header Level Cancellation Flag for index '||l_request_ind,5);
2590: oe_debug_pub.add(' Old Header Level Cancelation flag is '||g_delayed_requests(l_request_ind).param2,5);
2591: oe_debug_pub.add(' New Header Level Cancelation flag is '||l_request.param2,5);
2592: END IF;
2593: l_request.param2 := g_delayed_requests(l_request_ind).param2;
2594: -- Order Header is requested for cancellation
2595: END IF;
2595: END IF;
2596:
2597: IF g_delayed_requests(l_request_ind).param3 IS NOT NULL THEN
2598: IF l_debug_level > 0 THEN
2599: oe_debug_pub.add(' Incrementing the counter for lines to be cancelled for index '||l_request_ind,5);
2600: oe_debug_pub.add(' Old counter value is '||g_delayed_requests(l_request_ind).param3,5);
2601: END IF;
2602: l_request.param3 := nvl(l_request.param3,0) + g_delayed_requests(l_request_ind).param3;
2603: IF l_debug_level > 0 THEN
2596:
2597: IF g_delayed_requests(l_request_ind).param3 IS NOT NULL THEN
2598: IF l_debug_level > 0 THEN
2599: oe_debug_pub.add(' Incrementing the counter for lines to be cancelled for index '||l_request_ind,5);
2600: oe_debug_pub.add(' Old counter value is '||g_delayed_requests(l_request_ind).param3,5);
2601: END IF;
2602: l_request.param3 := nvl(l_request.param3,0) + g_delayed_requests(l_request_ind).param3;
2603: IF l_debug_level > 0 THEN
2604: oe_debug_pub.add(' New counter value is '||l_request.param3,5);
2600: oe_debug_pub.add(' Old counter value is '||g_delayed_requests(l_request_ind).param3,5);
2601: END IF;
2602: l_request.param3 := nvl(l_request.param3,0) + g_delayed_requests(l_request_ind).param3;
2603: IF l_debug_level > 0 THEN
2604: oe_debug_pub.add(' New counter value is '||l_request.param3,5);
2605: END IF;
2606: -- Counter maintaining number of order line records cancelled during
2607: -- the order header level (Full/Partial) cancellation request
2608: END IF;
2609:
2610: IF l_request.long_param1 IS NOT NULL THEN
2611: IF g_delayed_requests(l_request_ind).long_param1 IS NOT NULL THEN
2612: IF l_debug_level > 0 THEN
2613: oe_debug_pub.add(' Line_ids to be cancelled for index '||l_request_ind,5);
2614: oe_debug_pub.add(' Old Line_ids are '||g_delayed_requests(l_request_ind).long_param1,5);
2615: END IF;
2616: l_request.long_param1 := g_delayed_requests(l_request_ind).long_param1||','|| l_request.long_param1;
2617: IF l_debug_level > 0 THEN
2610: IF l_request.long_param1 IS NOT NULL THEN
2611: IF g_delayed_requests(l_request_ind).long_param1 IS NOT NULL THEN
2612: IF l_debug_level > 0 THEN
2613: oe_debug_pub.add(' Line_ids to be cancelled for index '||l_request_ind,5);
2614: oe_debug_pub.add(' Old Line_ids are '||g_delayed_requests(l_request_ind).long_param1,5);
2615: END IF;
2616: l_request.long_param1 := g_delayed_requests(l_request_ind).long_param1||','|| l_request.long_param1;
2617: IF l_debug_level > 0 THEN
2618: oe_debug_pub.add(' New Line_ids are '||l_request.long_param1,5);
2614: oe_debug_pub.add(' Old Line_ids are '||g_delayed_requests(l_request_ind).long_param1,5);
2615: END IF;
2616: l_request.long_param1 := g_delayed_requests(l_request_ind).long_param1||','|| l_request.long_param1;
2617: IF l_debug_level > 0 THEN
2618: oe_debug_pub.add(' New Line_ids are '||l_request.long_param1,5);
2619: END IF;
2620: -- A string variable containing line_ids, which are cancelled during
2621: -- the Order Header level (Full/Partial) cancellation request
2622: -- In this string, the Line_ids will be separated by a delimiter comma ','
2623: END IF;
2624: ELSE
2625: l_request.long_param1 := g_delayed_requests(l_request_ind).long_param1;
2626: IF l_debug_level > 0 THEN
2627: oe_debug_pub.add(' Only old Line_ids are retained '||l_request.long_param1,5);
2628: END IF;
2629: -- Since this request has not passed the line_id, just retain the global
2630: END IF;
2631:
2631:
2632: IF g_delayed_requests(l_request_ind).date_param1 IS NOT NULL
2633: AND l_request.date_param1 IS NULL THEN
2634: IF l_debug_level > 0 THEN
2635: oe_debug_pub.add(' Retain Old date_param1 : '||g_delayed_requests(l_request_ind).date_param1,5);
2636: END IF;
2637: l_request.date_param1 := g_delayed_requests(l_request_ind).date_param1;
2638: END IF;
2639:
2640: --Bug 14211120 Start
2641: IF g_delayed_requests(l_request_ind).param4 IS NOT NULL
2642: AND l_request.param4 IS NULL THEN
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add(' Secondary: Retaining Delta Quantity change for index '||l_request_ind,5);
2645: oe_debug_pub.add(' Secondary: Old Delta Quantity change is'||g_delayed_requests(l_request_ind).param4,5);
2646: oe_debug_pub.add(' Secondary: New Delta Quantity change is NULL',5);
2647: END IF;
2648: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2641: IF g_delayed_requests(l_request_ind).param4 IS NOT NULL
2642: AND l_request.param4 IS NULL THEN
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add(' Secondary: Retaining Delta Quantity change for index '||l_request_ind,5);
2645: oe_debug_pub.add(' Secondary: Old Delta Quantity change is'||g_delayed_requests(l_request_ind).param4,5);
2646: oe_debug_pub.add(' Secondary: New Delta Quantity change is NULL',5);
2647: END IF;
2648: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2649: elsif g_delayed_requests(l_request_ind).param4 IS NOT NULL
2642: AND l_request.param4 IS NULL THEN
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add(' Secondary: Retaining Delta Quantity change for index '||l_request_ind,5);
2645: oe_debug_pub.add(' Secondary: Old Delta Quantity change is'||g_delayed_requests(l_request_ind).param4,5);
2646: oe_debug_pub.add(' Secondary: New Delta Quantity change is NULL',5);
2647: END IF;
2648: l_request.param4 := g_delayed_requests(l_request_ind).param4;
2649: elsif g_delayed_requests(l_request_ind).param4 IS NOT NULL
2650: and l_request.param4 IS NOT NULL THEN
2662: g_delayed_requests(l_request_ind) := l_request;
2663:
2664: ELSE -- insert the new request
2665: IF l_debug_level > 0 THEN
2666: OE_Debug_PUB.ADD('New request inserted');
2667: END IF;
2668: -- l_request_ind := nvl(g_delayed_requests.LAST, 0) + 1;
2669:
2670: -- 11i10 Pricing Changes for blankets
2695:
2696: -- Insert into the requesting entities table
2697: g_requesting_entities(l_req_entity_ind) := l_req_entity;
2698: IF l_debug_level > 0 THEN
2699: oe_debug_pub.add('!!!!!!! index '|| l_request_ind, 5);
2700: END IF;
2701: EXCEPTION
2702:
2703: WHEN FND_API.G_EXC_ERROR THEN
2771: l_return_status Varchar2(1);
2772: l_request_ind number;
2773: l_req_entity_ind number;
2774: --
2775: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2776: --
2777: BEGIN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
2775: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2776: --
2777: BEGIN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
2780: END IF;
2781: x_return_status := FND_API.G_RET_STS_SUCCESS;
2782:
2783: Check_for_Request( p_entity_code => p_entity_code
2846: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)
2847:
2848: IS
2849: --
2850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2851: --
2852: BEGIN
2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');
2850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2851: --
2852: BEGIN
2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');
2855: END IF;
2856:
2857: x_return_status := FND_API.G_RET_STS_SUCCESS;
2858:
2903: l_request_ind Number;
2904: l_request_search_rslt Varchar2(30);
2905: l_return_status Varchar2(30);
2906: --
2907: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2908: --
2909: Begin
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911: IF l_debug_level > 0 THEN
2908: --
2909: Begin
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911: IF l_debug_level > 0 THEN
2912: oe_debug_pub.add('Entering Procedure Process_Request in Package OE_Delayed_Requests_Pvt');
2913: END IF;
2914: Check_for_Request( p_entity_code => p_entity_code
2915: ,p_entity_id => p_entity_id
2916: ,p_request_type => p_request_type
2974:
2975: l_return_status Varchar2(30);
2976: l_ind Number;
2977: --
2978: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2979: --
2980: Begin
2981: x_return_status := FND_API.G_RET_STS_SUCCESS;
2982: IF l_debug_level > 0 THEN
2979: --
2980: Begin
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 ) ;
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;
2990: END IF;
2991: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3008: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add('Expected error in Process_Request_for_Entity ');
3013: /* Commented the following 2 debug messages to fix the bug 13513618 */
3014: /*
3015: *
3016: oe_debug_pub.add
3012: oe_debug_pub.add('Expected error in Process_Request_for_Entity ');
3013: /* Commented the following 2 debug messages to fix the bug 13513618 */
3014: /*
3015: *
3016: oe_debug_pub.add
3017: ('2 type----- '|| G_Delayed_Requests(l_ind).request_type, 1);
3018: oe_debug_pub.add
3019: ('2 ind----- '|| l_ind, 1);
3020: */
3014: /*
3015: *
3016: oe_debug_pub.add
3017: ('2 type----- '|| G_Delayed_Requests(l_ind).request_type, 1);
3018: oe_debug_pub.add
3019: ('2 ind----- '|| l_ind, 1);
3020: */
3021: END IF;
3022: RAISE FND_API.G_EXC_ERROR;
3026: END LOOP;
3027: END IF; -- Recursion mode
3028:
3029: IF l_debug_level > 0 THEN
3030: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
3031: END IF;
3032:
3033: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3034: p_In_out => 0);
3056: , 'Process_Request_for_Entity'
3057: );
3058: END IF;
3059: IF l_debug_level > 0 THEN
3060: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
3061: END IF;
3062:
3063: End Process_Request_for_Entity;
3064:
3075: l_req_entity_ind Number;
3076:
3077: l_entity_id_tbl Entity_Id_Tbl_Type;
3078: --
3079: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3080: --
3081: BEGIN
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;
3083: IF l_debug_level > 0 THEN
3080: --
3081: BEGIN
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
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;
3092: END IF;
3093:
3164: --END IF ; -- Recursion mode
3165: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3166: p_In_out => 0);
3167: IF l_debug_level > 0 THEN
3168: oe_debug_pub.add('leaving process_requenst_for_reqtype', 1);
3169: END IF;
3170: EXCEPTION
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3174: p_In_out => 0);
3175: oe_debug_pub.add('execution error', 1);
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177:
3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3177:
3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3180: p_In_out => 0);
3181: oe_debug_pub.add('unexp error', 1);
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3183:
3184: WHEN OTHERS THEN
3185: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3183:
3184: WHEN OTHERS THEN
3185: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3186: p_In_out => 0);
3187: oe_debug_pub.add('others error', 1);
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189:
3190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3191: THEN
3203: ) IS
3204: l_ind NUMBER; /* 1739574 */
3205: l_return_status Varchar2(30);
3206: --
3207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3208: --
3209: Begin
3210: IF l_debug_level > 0 THEN
3211: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Delayed_Requests');
3207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3208: --
3209: Begin
3210: IF l_debug_level > 0 THEN
3211: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Delayed_Requests');
3212: END IF;
3213:
3214: x_return_status := FND_API.G_RET_STS_SUCCESS;
3215:
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;
3221: END IF;
3222: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3783: END IF;
3784:
3785: --added by MShenoy for Spares Management ikon project - Create internal req.
3786: IF l_debug_level > 0 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
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
3796: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3797: END IF;
3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3832: ----------
3833:
3834: --MRG BGN
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
3945: /* Please do not put execution of any delayed request beyond this point */
3946: l_ind := G_Delayed_Requests.first;
3947:
3948: IF l_debug_level > 0 THEN
3949: oe_debug_pub.add('Global Request count-PDR-E'||G_Delayed_Requests.count,1);
3950: oe_debug_pub.add('*****l_ind :' || l_ind, 1);
3951: END IF;
3952:
3953: WHILE l_ind IS NOT NULL LOOP
3946: l_ind := G_Delayed_Requests.first;
3947:
3948: IF l_debug_level > 0 THEN
3949: oe_debug_pub.add('Global Request count-PDR-E'||G_Delayed_Requests.count,1);
3950: oe_debug_pub.add('*****l_ind :' || l_ind, 1);
3951: END IF;
3952:
3953: WHILE l_ind IS NOT NULL LOOP
3954: Process_Request_Pvt
3976: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;
3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add('Global Request count-PDR-AL'||G_Delayed_Requests.count,1);
3981: END IF;
3982:
3983: -- clear the delayed request cache
3984: Clear_Request(x_return_status);
4026: IS
4027: l_request_rec OE_Order_PUB.request_rec_type;
4028: l_return_status VARCHAR2(1);
4029: --
4030: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4031: --
4032: l_header_id NUMBER;
4033: l_line_id NUMBER;
4034: l_order_source_id NUMBER;
4053: l_lines_list VARCHAR2(4000);
4054:
4055: BEGIN
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
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;
4065: END IF;
4066:
4073:
4074: FOR i IN 1..p_x_request_tbl.COUNT LOOP
4075: BEGIN
4076: IF l_debug_level > 0 THEN
4077: oe_debug_pub.ADD('Processing delayed requests # = '
4078: || To_char(i), 2);
4079: END IF;
4080:
4081: -- If request is already processed then loop around.
4085: END IF;
4086:
4087: l_request_rec := p_x_request_tbl(i);
4088: IF l_debug_level > 0 THEN
4089: oe_debug_pub.ADD('Request Type = '
4090: || l_request_rec.request_type, 2);
4091: END IF;
4092: IF l_request_rec.entity_code = 'HEADER' THEN
4093: l_header_id := l_request_rec.entity_id;
4093: l_header_id := l_request_rec.entity_id;
4094: IF l_request_rec.entity_id IS NOT NULL THEN
4095: BEGIN
4096: IF l_debug_level > 0 THEN
4097: oe_debug_pub.add('Getting reference data for header_id:'||l_header_id);
4098: END IF;
4099: SELECT order_source_id, orig_sys_document_ref, change_sequence,
4100: source_document_type_id, source_document_id
4101: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4121: l_line_id := l_request_rec.entity_id;
4122: IF l_request_rec.entity_id IS NOT NULL THEN
4123: BEGIN
4124: IF l_debug_level > 0 THEN
4125: oe_debug_pub.add('Getting reference data for line_id:'||l_request_rec.entity_id);
4126: END IF;
4127: SELECT order_source_id, orig_sys_document_ref, change_sequence,
4128: source_document_type_id, source_document_id, orig_sys_line_ref,
4129: source_document_line_id, orig_sys_shipment_ref, header_id
4158: ELSIF l_request_rec.entity_code = 'HEADER_ADJ' THEN
4159: IF l_request_rec.entity_id IS NOT NULL THEN
4160: BEGIN
4161: IF l_debug_level > 0 THEN
4162: oe_debug_pub.add('Getting header_id of the header adjustment:'||l_request_rec.entity_id);
4163: END IF;
4164: SELECT header_id
4165: INTO l_header_id
4166: FROM oe_price_adjustments
4174: END IF;
4175: IF l_header_id IS NOT NULL THEN
4176: BEGIN
4177: IF l_debug_level > 0 THEN
4178: oe_debug_pub.add('Getting reference data for header_id:'||l_header_id);
4179: END IF;
4180: SELECT order_source_id, orig_sys_document_ref, change_sequence,
4181: source_document_type_id, source_document_id
4182: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4201: ELSIF l_request_rec.entity_code = 'LINE_ADJ' THEN
4202: IF l_request_rec.entity_id IS NOT NULL THEN
4203: BEGIN
4204: IF l_debug_level > 0 THEN
4205: oe_debug_pub.add('Getting line_id of the line adjustment:'||l_request_rec.entity_id);
4206: END IF;
4207: SELECT line_id
4208: INTO l_line_id
4209: FROM oe_price_adjustments
4217: END IF;
4218: IF l_line_id IS NOT NULL THEN
4219: BEGIN
4220: IF l_debug_level > 0 THEN
4221: oe_debug_pub.add('Getting reference data for line_id:'||l_line_id);
4222: END IF;
4223: SELECT order_source_id, orig_sys_document_ref, change_sequence,
4224: source_document_type_id, source_document_id, orig_sys_line_ref,
4225: source_document_line_id, orig_sys_shipment_ref, header_id
4254: ELSIF l_request_rec.entity_code = 'HEADER_SCREDIT' THEN
4255: IF l_request_rec.entity_id IS NOT NULL THEN
4256: BEGIN
4257: IF l_debug_level > 0 THEN
4258: oe_debug_pub.add('Getting header_id of the header scredit:'||l_request_rec.entity_id);
4259: END IF;
4260: SELECT header_id
4261: INTO l_header_id
4262: FROM oe_sales_credits
4270: END IF;
4271: IF l_header_id IS NOT NULL THEN
4272: BEGIN
4273: IF l_debug_level > 0 THEN
4274: oe_debug_pub.add('Getting reference data for header_id:'||l_header_id);
4275: END IF;
4276: SELECT order_source_id, orig_sys_document_ref, change_sequence,
4277: source_document_type_id, source_document_id
4278: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4297: ELSIF l_request_rec.entity_code = 'LINE_SCREDIT' THEN
4298: IF l_request_rec.entity_id IS NOT NULL THEN
4299: BEGIN
4300: IF l_debug_level > 0 THEN
4301: oe_debug_pub.add('Getting line_id of the line scredit:'||l_request_rec.entity_id);
4302: END IF;
4303: SELECT line_id
4304: INTO l_line_id
4305: FROM oe_sales_credits
4313: END IF;
4314: IF l_line_id IS NOT NULL THEN
4315: BEGIN
4316: IF l_debug_level > 0 THEN
4317: oe_debug_pub.add('Getting reference data for line_id:'||l_line_id);
4318: END IF;
4319: SELECT order_source_id, orig_sys_document_ref, change_sequence,
4320: source_document_type_id, source_document_id, orig_sys_line_ref,
4321: source_document_line_id, orig_sys_shipment_ref, header_id
4362: ,p_source_document_type_id => l_source_document_type_id
4363: ,p_source_document_id => l_source_document_id
4364: ,p_source_document_line_id => l_source_document_line_id );
4365: IF l_debug_level > 0 THEN
4366: oe_debug_pub.add('Request Entity:'||l_request_rec.entity_code||
4367: ' Request ID:'||l_request_rec.entity_id);
4368: END IF;
4369:
4370: -- Action Request to Apply Automatic Attachments
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
4387: (
4388: p_header_count => 1,
4412: end if;
4413: end loop;
4414:
4415: IF l_debug_level > 0 THEN
4416: oe_debug_pub.add('Before calling Price Line for count :' || l_lines_count || '; List : ' || l_lines_list, 5);
4417: END IF;
4418: OE_ORDER_ADJ_PVT.price_action
4419: (
4420: p_header_count => 0,
4427: x_msg_data => l_msg_data
4428: );
4429: ELSE
4430: IF l_debug_level > 0 THEN
4431: oe_debug_pub.add('Invalid entity given for Price Order Action. Entity has to be Header or Line', 5);
4432: END IF;
4433:
4434: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4435: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4440: END IF;
4441:
4442: IF l_debug_level > 0 THEN
4443: oe_debug_pub.add('After Price Order, Status : ' || l_return_status, 5);
4444: END IF;
4445:
4446: l_request_rec.processed := 'Y';
4447:
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
4461: (p_validation_level => p_validation_level,
4462: x_request_rec => l_request_rec);
4462: x_request_rec => l_request_rec);
4463:
4464: l_request_rec.processed := 'Y';
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
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
4474: (p_validation_level => p_validation_level,
4475: x_request_rec => l_request_rec);
4474: (p_validation_level => p_validation_level,
4475: x_request_rec => l_request_rec);
4476: l_request_rec.processed := 'Y';
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
4506: l_request_rec.return_status := l_return_status;
4507: */
4508:
4509: IF l_debug_level > 0 THEN
4510: oe_debug_pub.add('Before call to Authrize Payment header_id is: ' || l_header_id);
4511: oe_debug_pub.add('Before call to Authrize Payment line_id is: ' || l_line_id);
4512: --comm rej oe_debug_pub.add('reject on auth is: ' || l_reject_on_auth_failure);
4513: --comm rej oe_debug_pub.add('reject on risk is: ' || l_reject_on_risk_failure);
4514: oe_debug_pub.add('risk eval flag is: ' || l_request_rec.param1);
4507: */
4508:
4509: IF l_debug_level > 0 THEN
4510: oe_debug_pub.add('Before call to Authrize Payment header_id is: ' || l_header_id);
4511: oe_debug_pub.add('Before call to Authrize Payment line_id is: ' || l_line_id);
4512: --comm rej oe_debug_pub.add('reject on auth is: ' || l_reject_on_auth_failure);
4513: --comm rej oe_debug_pub.add('reject on risk is: ' || l_reject_on_risk_failure);
4514: oe_debug_pub.add('risk eval flag is: ' || l_request_rec.param1);
4515: END IF;
4508:
4509: IF l_debug_level > 0 THEN
4510: oe_debug_pub.add('Before call to Authrize Payment header_id is: ' || l_header_id);
4511: oe_debug_pub.add('Before call to Authrize Payment line_id is: ' || l_line_id);
4512: --comm rej oe_debug_pub.add('reject on auth is: ' || l_reject_on_auth_failure);
4513: --comm rej oe_debug_pub.add('reject on risk is: ' || l_reject_on_risk_failure);
4514: oe_debug_pub.add('risk eval flag is: ' || l_request_rec.param1);
4515: END IF;
4516:
4509: IF l_debug_level > 0 THEN
4510: oe_debug_pub.add('Before call to Authrize Payment header_id is: ' || l_header_id);
4511: oe_debug_pub.add('Before call to Authrize Payment line_id is: ' || l_line_id);
4512: --comm rej oe_debug_pub.add('reject on auth is: ' || l_reject_on_auth_failure);
4513: --comm rej oe_debug_pub.add('reject on risk is: ' || l_reject_on_risk_failure);
4514: oe_debug_pub.add('risk eval flag is: ' || l_request_rec.param1);
4515: END IF;
4516:
4517: OE_Header_UTIL.Query_Row
4510: oe_debug_pub.add('Before call to Authrize Payment header_id is: ' || l_header_id);
4511: oe_debug_pub.add('Before call to Authrize Payment line_id is: ' || l_line_id);
4512: --comm rej oe_debug_pub.add('reject on auth is: ' || l_reject_on_auth_failure);
4513: --comm rej oe_debug_pub.add('reject on risk is: ' || l_reject_on_risk_failure);
4514: oe_debug_pub.add('risk eval flag is: ' || l_request_rec.param1);
4515: END IF;
4516:
4517: OE_Header_UTIL.Query_Row
4518: (p_header_id => l_header_id
4536:
4537: l_request_rec.return_status := l_return_status;
4538:
4539: IF l_debug_level > 0 THEN
4540: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);
4541: END IF;
4542:
4543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4544: RAISE FND_API.G_EXC_ERROR;
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
4563: ( p_validation_level => p_validation_level
4564: , p_header_id => l_request_rec.entity_id
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');
4577: END IF;
4578:
4579: -- Get_Ship_Method API not only gets ship method
4580: -- from FTE, but also can get freight rates
4727: oe_order_pvt.set_recursion_mode(p_Entity_Code => 10,
4728: p_In_out => 0);
4729: END IF;
4730: IF l_debug_level > 0 THEN
4731: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4732: END IF;
4733: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4734:
4735: EXCEPTION
4777: del_option_req_id number := 0; -- Bug 12316022
4778:
4779:
4780: --
4781: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4782: --
4783: BEGIN
4784:
4785:
4785:
4786:
4787: x_return_status := FND_API.G_RET_STS_SUCCESS;
4788: IF l_debug_level > 0 THEN
4789: oe_debug_pub.add('In Delete_Reqs_for_Deleted_Entity');
4790: oe_debug_pub.add('p_entity_code/p_entity_id' ||
4791: p_entity_code || '/' || p_entity_id);
4792: END IF;
4793:
4786:
4787: x_return_status := FND_API.G_RET_STS_SUCCESS;
4788: IF l_debug_level > 0 THEN
4789: oe_debug_pub.add('In Delete_Reqs_for_Deleted_Entity');
4790: oe_debug_pub.add('p_entity_code/p_entity_id' ||
4791: p_entity_code || '/' || p_entity_id);
4792: END IF;
4793:
4794: -- DELETING REQUESTS LOGGED AGAINST THIS ENTITY
4796: i := G_Delayed_Requests.first;
4797:
4798: WHILE i IS NOT NULL LOOP
4799: IF l_debug_level > 0 THEN
4800: oe_debug_pub.add('G_Delayed_Requests.entity_code/entity_id' ||
4801: G_Delayed_Requests(i).entity_code || '/' ||
4802: G_Delayed_Requests(i).entity_id);
4803: oe_debug_pub.add('G_Delayed_Requests.request_type' ||
4804: G_Delayed_Requests(i).request_type);
4799: IF l_debug_level > 0 THEN
4800: oe_debug_pub.add('G_Delayed_Requests.entity_code/entity_id' ||
4801: G_Delayed_Requests(i).entity_code || '/' ||
4802: G_Delayed_Requests(i).entity_id);
4803: oe_debug_pub.add('G_Delayed_Requests.request_type' ||
4804: G_Delayed_Requests(i).request_type);
4805:
4806: END IF;
4807:
4821: G_Delayed_Requests(i).entity_id = p_entity_id)
4822: )
4823: THEN
4824: IF l_debug_level > 0 THEN
4825: oe_debug_pub.add('Delete above request');
4826: END IF;
4827:
4828: -- delete records in requesting entity tables with this request
4829: j := G_Requesting_Entities.first;
4849: -- against the given entity.
4850:
4851: IF NOT p_delete_against THEN
4852: IF l_debug_level > 0 THEN
4853: oe_debug_pub.add('Delete against is FALSE');
4854: END IF;
4855:
4856:
4857: i := G_Requesting_Entities.first;
4897: -- deleting the delayed request
4898: IF request_delete
4899: AND G_Delayed_Requests.Exists(req_ind) THEN
4900: IF l_debug_level > 0 THEN
4901: oe_debug_pub.add('Delete following request =>');
4902: oe_debug_pub.add('G_Delayed_Requests.entity_code/entity_id' ||
4903: G_Delayed_Requests(req_ind).entity_code || '/' ||
4904: G_Delayed_Requests(req_ind).entity_id);
4905: oe_debug_pub.add('G_Delayed_Requests.request_type' ||
4898: IF request_delete
4899: AND G_Delayed_Requests.Exists(req_ind) THEN
4900: IF l_debug_level > 0 THEN
4901: oe_debug_pub.add('Delete following request =>');
4902: oe_debug_pub.add('G_Delayed_Requests.entity_code/entity_id' ||
4903: G_Delayed_Requests(req_ind).entity_code || '/' ||
4904: G_Delayed_Requests(req_ind).entity_id);
4905: oe_debug_pub.add('G_Delayed_Requests.request_type' ||
4906: G_Delayed_Requests(req_ind).request_type);
4901: oe_debug_pub.add('Delete following request =>');
4902: oe_debug_pub.add('G_Delayed_Requests.entity_code/entity_id' ||
4903: G_Delayed_Requests(req_ind).entity_code || '/' ||
4904: G_Delayed_Requests(req_ind).entity_id);
4905: oe_debug_pub.add('G_Delayed_Requests.request_type' ||
4906: G_Delayed_Requests(req_ind).request_type);
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;
4916: IF (NOT OE_Versioning_Util.Reset_Globals) THEN
4917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4918: END IF;
4965: l_ato_line_id NUMBER;
4966: l_res_changes VARCHAR2(1);
4967: l_request_tbl OE_Order_PUB.request_tbl_type;
4968: --
4969: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4970: --
4971: BEGIN
4972: IF l_debug_level > 0 THEN
4973: oe_debug_pub.add('sch request '|| p_request_rec.request_type, 1);
4969: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4970: --
4971: BEGIN
4972: IF l_debug_level > 0 THEN
4973: oe_debug_pub.add('sch request '|| p_request_rec.request_type, 1);
4974: END IF;
4975:
4976: x_return_status := FND_API.G_RET_STS_SUCCESS;
4977:
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:
4983: IF p_request_rec.param9 = 'Y' THEN
4984: K := p_request_ind;
4982:
4983: IF p_request_rec.param9 = 'Y' THEN
4984: K := p_request_ind;
4985: IF l_debug_level > 0 THEN
4986: oe_debug_pub.add('searh for duplicates '|| K, 3);
4987: END IF;
4988: WHILE K is not null
4989: LOOP
4990: IF G_Delayed_Requests(K).request_type
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
4996: oe_debug_pub.add('another req for same top model', 2);
4997: END IF;
4998: SELECT ato_line_id
4999: INTO l_ato_line_id
5000: FROM oe_order_lines
5001: WHERE line_id = G_Delayed_Requests(K).entity_id;
5002:
5003: IF nvl(l_ato_line_id, -1) <> G_Delayed_Requests(K).entity_id THEN
5004: IF l_debug_level > 0 THEN
5005: oe_debug_pub.add('2 incorrect sch_ato req ', 3);
5006: END IF;
5007: G_Delayed_Requests.DELETE(K);
5008: END IF;
5009: END IF;
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
5049: END IF;
5050:
5051: IF l_ato_line_id is NULL THEN
5052: IF l_debug_level > 0 THEN
5053: oe_debug_pub.add('req for same model, same action', 2);
5054: END IF;
5055: I := I + 1;
5056: l_request_tbl(I) := G_Delayed_Requests(K);
5057:
5059: l_res_changes := 'Y';
5060: END IF;
5061: ELSE
5062: IF l_debug_level > 0 THEN
5063: oe_debug_pub.add('part of ato '|| l_ato_line_id , 3);
5064: END IF;
5065: END IF;
5066:
5067: G_Delayed_Requests.DELETE(K);
5069: END IF;
5070: K := G_Delayed_Requests.NEXT(K);
5071: END LOOP;
5072: IF l_debug_level > 0 THEN
5073: oe_debug_pub.add('calling schedule_nonsmc '||l_res_changes , 1);
5074: END IF;
5075: OE_Config_Schedule_Pvt.Schedule_NONSMC
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:
5085: OE_SCHEDULE_UTIL.DELAYED_SCHEDULE_LINES
5086: (x_return_status => x_return_status);
5086: (x_return_status => x_return_status);
5087:
5088: END IF;
5089: IF l_debug_level > 0 THEN
5090: oe_debug_pub.add('type----- '|| p_request_rec.request_type, 4);
5091: oe_debug_pub.add('leaving sch reqs '|| x_return_status, 1);
5092: END IF;
5093: EXCEPTION
5094: WHEN OTHERS THEN
5087:
5088: END IF;
5089: IF l_debug_level > 0 THEN
5090: oe_debug_pub.add('type----- '|| p_request_rec.request_type, 4);
5091: oe_debug_pub.add('leaving sch reqs '|| x_return_status, 1);
5092: END IF;
5093: EXCEPTION
5094: WHEN OTHERS THEN
5095: oe_debug_pub.add('Process_Scheduling_Request error '|| sqlerrm, 1);
5091: oe_debug_pub.add('leaving sch reqs '|| x_return_status, 1);
5092: END IF;
5093: EXCEPTION
5094: WHEN OTHERS THEN
5095: oe_debug_pub.add('Process_Scheduling_Request error '|| sqlerrm, 1);
5096: RAISE;
5097: END Process_Scheduling_Request;
5098:
5099: /*---------------------------------------------------------------
5115: l_request_ind NUMBER;
5116: l_req_entity_ind NUMBER;
5117: l_request OE_Order_PUB.REQUEST_REC_TYPE;
5118: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
5119: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5120:
5121: BEGIN
5122:
5123: /* Added the following condition to fix the fp bug 3498435 */
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);
5130: END IF;
5131: IF (p_request_rec.request_unique_key1 = 'BATCH'
5132: OR p_request_rec.request_unique_key1 = 'BATCH,BOOK')
5133: AND nvl(p_request_rec.request_unique_key2,'N') = 'Y' THEN
5186: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5187: -- no need to log request with BATCH and Y if BATCH
5188: -- and N already exists.
5189: IF l_debug_level > 0 THEN
5190: oe_debug_pub.add('there already exists BATCH + N so no need to log pricing request.', 3);
5191: END IF;
5192: x_log_request := 'N';
5193:
5194: ELSE
5232: -- check if there already exists request with
5233: -- pricing event 'LINE' with get_freight_flag = 'Y'.
5234: -- If exists, do nothing.
5235: IF l_debug_level > 0 THEN
5236: oe_debug_pub.add('there already exists request with ORDER + N.',3);
5237: END IF;
5238: Check_For_Request(p_request_rec.entity_code,
5239: p_request_rec.entity_id,
5240: p_request_rec.request_type,
5255: IF l_request_search_rslt3 = FND_API.G_TRUE THEN
5256: -- If not exists, replace BATCH event with LINE event
5257: -- since request with 'ORDER' event already exists.
5258: IF l_debug_level > 0 THEN
5259: oe_debug_pub.add('there exists LINE + Y and ORDER + N so no need to log request for BATCH + Y.', 3);
5260: END IF;
5261: x_log_request := 'N';
5262: ELSE
5263: -- if l_request_search_rslt3 = FND_API.G_FALSE THEN
5282:
5283: IF l_request_search_rslt4 = FND_API.G_TRUE THEN
5284: -- if already exists request with LINE and N.
5285: IF l_debug_level > 0 THEN
5286: oe_debug_pub.add('there exists LINE + N and ORDER + N so no need to log request for BATCH + Y.', 3);
5287: END IF;
5288: x_log_request := 'N';
5289:
5290: ELSE
5290: ELSE
5291: -- p_request_rec.request_unique_key1 := 'LINE';
5292: -- replace event BATCH with LINE.
5293: IF l_debug_level > 0 THEN
5294: oe_debug_pub.add('replace BATCH event with LINE + Y and ORDER + N.', 3);
5295: END IF;
5296: p_request_rec.param2 := 'LINE';
5297: p_request_rec.request_unique_key1 := 'LINE';
5298: p_request_rec.request_unique_key2 := 'Y';
5327: -- if l_request_search_rslt1 = FND_API.G_TRUE
5328: -- request with event 'BATCH' and get_freight_flag ='N'
5329: -- exists, don't need to log request.
5330: IF l_debug_level > 0 THEN
5331: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5332: END IF;
5333: x_log_request := 'N';
5334: ELSE
5335: -- if l_request_search_rslt1 = FND_API.G_FALSE
5357: -- there exists request with BATCH+Y already.
5358: -- need to delete BATCH+Y, log the current request which is
5359: -- ORDER+N and log an additional request LINE+Y.
5360: IF l_debug_level > 0 THEN
5361: oe_debug_pub.add('need to have two separate requests ORDER + N and LINE + Y',3);
5362: END IF;
5363: delete_request(p_entity_code => p_request_rec.entity_code,
5364: p_entity_id => p_request_rec.entity_id,
5365: p_request_type => p_request_rec.request_type,
5386: OR p_request_rec.request_unique_key1 = 'BATCH,BOOK'
5387: AND nvl(p_request_rec.request_unique_key2,'N') = 'N' THEN
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,
5437: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5438: -- request with event 'BATCH' and get_freight_flag ='N'
5439: -- already exists, no need to log request.
5440: IF l_debug_level > 0 THEN
5441: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5442: END IF;
5443: x_log_request := 'N';
5444: ELSE
5445: -- l_request_search_rslt1 = FND_API.G_FALSE
5467: -- there exists request with BATCH,BOOK+Y already.
5468: -- need to delete BATCH,BOOK+Y, log the current request which is
5469: -- ORDER,BOOK+N and log an additional request LINE+Y.
5470: IF l_debug_level > 0 THEN
5471: oe_debug_pub.add('need to have two separate requests ORDER,BOOK + N and LINE + Y and delete BATCH,BOOK + Y',1);
5472: END IF;
5473: delete_request(p_entity_code => p_request_rec.entity_code,
5474: p_entity_id => p_request_rec.entity_id,
5475: p_request_type => p_request_rec.request_type,
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
5503: Check_For_Request(p_request_rec.entity_code,
5504: p_request_rec.entity_id,
5518: END IF;
5519:
5520: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5521: IF l_debug_level > 0 THEN
5522: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5523: END IF;
5524: x_log_request := 'N';
5525: ELSE
5526: IF l_debug_level > 0 THEN
5523: END IF;
5524: x_log_request := 'N';
5525: ELSE
5526: IF l_debug_level > 0 THEN
5527: oe_debug_pub.add('3498435: Search result is false ',1);
5528: END IF;
5529: Check_For_Request(p_request_rec.entity_code,
5530: p_request_rec.entity_id,
5531: p_request_rec.request_type,
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5546: IF l_debug_level > 0 THEN
5547: oe_debug_pub.add('there exists BATCH,BOOK + N so no need to log request.', 3);
5548: END IF;
5549: x_log_request := 'N';
5550: END IF; --l_request_search_rslt2
5551: END IF; --l_request_search_rslt1
5551: END IF; --l_request_search_rslt1
5552: ELSIF (nvl(p_request_rec.request_unique_key1,p_request_rec.param2) = 'BATCH'
5553: OR nvl(p_request_rec.request_unique_key1,p_request_rec.param2) = 'BATCH,BOOK') THEN
5554: IF l_debug_level > 0 THEN
5555: oe_debug_pub.add('Delete Line',3);
5556: END IF;
5557: delete_request(p_entity_code => p_request_rec.entity_code,
5558: p_entity_id => p_request_rec.entity_id,
5559: p_request_type => p_request_rec.request_type,
5567: /* End of New code added to fix the fp bug 3498435 */
5568:
5569:
5570: IF l_debug_level > 0 THEN
5571: oe_debug_pub.add('Exiting procedure OE_Delayed_Requests_Pvt.Check_Pricing_Request', 1);
5572: END IF;
5573:
5574: END Check_Pricing_Request;
5575: