DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_DELAYED_REQUESTS_PVT

Line 1863: OE_delayed_requests_Pvt.log_request

1859: oe_debug_pub.add('Payment_type code in invoice to '||p_x_header_rec.payment_type_code);
1860: oe_debug_pub.add('Delete Payment Count count'||l_delete_payment_count);
1861: oe_debug_pub.add('Log delete payment req Flag'||l_log_delete_payment_req);
1862: IF l_log_delete_payment_req = 'Y' THEN
1863: OE_delayed_requests_Pvt.log_request
1864: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1865: p_entity_id => p_x_Header_rec.header_id,
1866: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1867: p_requesting_entity_id => p_x_Header_rec.header_id,

Line 1975: OE_delayed_requests_Pvt.log_request

1971: IF NOT (nvl(p_x_header_rec.source_document_type_id,-99) = 2 AND
1972: p_x_header_rec.operation = oe_globals.g_opr_create)THEN
1973: IF p_x_header_rec.salesrep_id IS NOT NULL THEN
1974: IF OE_Validate_Header_Scredit.G_Create_Auto_Sales_Credit = 'Y' THEN
1975: OE_delayed_requests_Pvt.log_request
1976: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1977: p_entity_id => p_x_header_rec.header_id,
1978: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1979: p_requesting_entity_id => p_x_header_rec.header_id,

Line 1989: OE_DELAYED_REQUESTS_PVT.Delete_Request

1985:
1986: /* Else added for bug 4139105 */
1987: ELSE
1988: IF OE_Validate_Header_Scredit.G_Create_Auto_Sales_Credit = 'Y' THEN
1989: OE_DELAYED_REQUESTS_PVT.Delete_Request
1990: (
1991: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1992: p_entity_id => p_x_header_rec.header_id,
1993: p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,

Line 2023: OE_delayed_requests_Pvt.log_request

2019: -- Log request to evaluate Holds.
2020: oe_debug_pub.ADD('Customer update: logging request for eval_hold_source',1);
2021: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2022: 'Entity ID:' || to_char(p_x_header_rec.sold_to_org_id),1);
2023: OE_delayed_requests_Pvt.log_request
2024: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2025: p_entity_id => p_x_header_rec.header_id,
2026: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2027: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2055: OE_delayed_requests_Pvt.log_request

2051: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2052: 'Entity ID:' || to_char(l_bill_to_cust_id),1);
2053:
2054:
2055: OE_delayed_requests_Pvt.log_request
2056: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2057: p_entity_id => p_x_header_rec.header_id,
2058: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2059: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2254: OE_delayed_requests_Pvt.log_request(

2250: -- bug 6697401
2251: -- Log a request to copy Freight Charges to the copied order.
2252: oe_debug_pub.add('Log Delayed Request To Copy Charges in SRC Doc Type Id',3);
2253:
2254: OE_delayed_requests_Pvt.log_request(
2255: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2256: p_entity_id => p_x_header_rec.header_id,
2257: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2258: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2282: OE_delayed_requests_Pvt.log_request(

2278: --
2279:
2280: IF OE_ORDER_COPY_UTIL.G_COPY_REC.line_price_mode IN (OE_ORDER_COPY_UTIL.G_CPY_ORIG_PRICE,OE_ORDER_COPY_UTIL.G_CPY_REPRICE_PARTIAL) THEN
2281: oe_debug_pub.add(' Copy as original price');
2282: OE_delayed_requests_Pvt.log_request(
2283: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2284: p_entity_id => p_x_header_rec.header_id,
2285: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2286: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2305: OE_delayed_requests_Pvt.log_request(

2301: THEN
2302: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
2303: THEN
2304: If nvl(p_x_header_rec.booked_flag, 'N') <> 'Y' Then
2305: OE_delayed_requests_Pvt.log_request(
2306: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2307: p_entity_id => p_x_header_rec.header_id,
2308: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2309: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2317: OE_delayed_requests_Pvt.log_request(

2313: p_param3 => 'PRICE_ORDER',
2314: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
2315: x_return_status => l_return_status);
2316: Else
2317: OE_delayed_requests_Pvt.log_request(
2318: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2319: p_entity_id => p_x_header_rec.header_id,
2320: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2321: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2330: oe_delayed_requests_pvt.log_request(

2326: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
2327: x_return_status => l_return_status);
2328: End If;
2329: -- sol_ord_er #16014165 start
2330: oe_delayed_requests_pvt.log_request(
2331: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2332: p_entity_id => p_x_header_rec.Header_Id,
2333: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2334: p_requesting_entity_id => p_x_header_rec.Header_Id,

Line 2347: oe_debug_pub.add( 'before oe_delayed_requests_pvt.log_request call',5 ) ;

2343: FOR i in lines_cur LOOP
2344: oe_debug_pub.add('Fetching line_id :' || i.line_id ,0);
2345:
2346: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
2347: oe_debug_pub.add( 'before oe_delayed_requests_pvt.log_request call',5 ) ;
2348: oe_delayed_requests_pvt.log_request(
2349: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2350: p_entity_id => i.line_id,
2351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 2348: oe_delayed_requests_pvt.log_request(

2344: oe_debug_pub.add('Fetching line_id :' || i.line_id ,0);
2345:
2346: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
2347: oe_debug_pub.add( 'before oe_delayed_requests_pvt.log_request call',5 ) ;
2348: oe_delayed_requests_pvt.log_request(
2349: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2350: p_entity_id => i.line_id,
2351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2352: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2355: oe_debug_pub.add( 'After OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL '||l_return_status ,5) ;

2351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2352: p_requesting_entity_id => p_x_header_rec.header_id,
2353: p_request_type => 'GET_COST',
2354: x_return_status => l_return_status);
2355: oe_debug_pub.add( 'After OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL '||l_return_status ,5) ;
2356: END IF;
2357: END LOOP;
2358: -- Bug 10194125 : End
2359: End If;

Line 2371: OE_delayed_requests_Pvt.log_request

2367: OE_Holds_PUB.G_HDR_PAYMENT := 'Y';
2368: oe_debug_pub.ADD('payment type update: logging request for eval_hold_source',1);
2369: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2370: 'Entity ID:' || to_char(p_x_header_rec.payment_type_code),1);
2371: OE_delayed_requests_Pvt.log_request
2372: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2373: p_entity_id => p_x_header_rec.header_id,
2374: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2375: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2391: OE_delayed_requests_Pvt.log_request

2387: THEN
2388: oe_debug_pub.ADD('Currency update: logging request for eval_hold_source',1);
2389: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2390: 'Entity ID:' || to_char(p_x_header_rec.transactional_curr_code),1);
2391: OE_delayed_requests_Pvt.log_request
2392: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2393: p_entity_id => p_x_header_rec.header_id,
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2395: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2411: OE_delayed_requests_Pvt.log_request

2407: THEN
2408: oe_debug_pub.ADD('sales channel update: logging request for eval_hold_source',1);
2409: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2410: 'Entity ID:' || to_char(p_x_header_rec.sales_channel_code),1);
2411: OE_delayed_requests_Pvt.log_request
2412: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2413: p_entity_id => p_x_header_rec.header_id,
2414: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2415: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2431: OE_delayed_requests_Pvt.log_request

2427: THEN
2428: oe_debug_pub.ADD('price list update: logging request for eval_hold_source',1);
2429: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2430: 'Entity ID:' || to_char(p_x_header_rec.price_list_id),1);
2431: OE_delayed_requests_Pvt.log_request
2432: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2433: p_entity_id => p_x_header_rec.header_id,
2434: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2435: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2451: OE_delayed_requests_Pvt.log_request

2447: THEN
2448: oe_debug_pub.ADD('Order type update: logging request for eval_hold_source',1);
2449: oe_debug_pub.ADD('Header ID:' || to_char(p_x_header_rec.header_id) ||
2450: 'Entity ID:' || to_char(p_x_header_rec.order_type_id),1);
2451: OE_delayed_requests_Pvt.log_request
2452: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2453: p_entity_id => p_x_header_rec.header_id,
2454: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2455: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2471: OE_delayed_requests_Pvt.log_request

2467:
2468: -- Log a request for Verify Payment
2469: oe_debug_pub.add('Logging Delayed Request for Verify Payment',3);
2470: --
2471: OE_delayed_requests_Pvt.log_request
2472: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2473: p_entity_id => p_x_header_rec.header_id,
2474: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2475: p_requesting_entity_id => p_x_header_rec.header_id,

Line 2503: OE_delayed_requests_Pvt.log_request

2499: and l_payment_count > 0 then --modified for bug 3733877
2500:
2501: oe_debug_pub.add('logging synch payment delayed request', 1);
2502:
2503: OE_delayed_requests_Pvt.log_request
2504: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2505: p_entity_id => p_x_header_rec.header_id,
2506: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
2507: p_requesting_entity_id => p_x_header_rec.header_id,

Line 4769: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(

4765: OE_Order_WF_Util.delete_row(p_type=>'NEGOTIATE', p_id => p_header_id);
4766: END IF;
4767: OE_Holds_PUB.Delete_Holds(p_header_id => p_header_id);
4768:
4769: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
4770: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4771: p_entity_id => p_header_id,
4772: x_return_status => l_return_status
4773: );

Line 8390: OE_delayed_requests_Pvt.log_request

8386: IF l_debug_level > 0 THEN
8387: oe_debug_pub.add(' Header level cancellation. Log the IR ISO update delayed request',5);
8388: END IF;
8389:
8390: OE_delayed_requests_Pvt.log_request
8391: ( p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8392: , p_entity_id => p_x_header_rec.header_id
8393: , p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
8394: , p_requesting_entity_id => p_x_header_rec.header_id

Line 8585: OE_DELAYED_REQUESTS_PVT.Log_Request

8581: 6896311*/
8582: IF (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND --6896311
8583: l_apply_automatic_atchmt = 'Y' THEN
8584: oe_debug_pub.add('log request to apply atcmt');
8585: OE_DELAYED_REQUESTS_PVT.Log_Request
8586: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8587: p_entity_id => p_x_header_rec.header_id,
8588: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8589: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 8624: OE_delayed_requests_Pvt.Log_Request

8620:
8621: END IF;
8622:
8623: IF l_attr_attach_change THEN
8624: OE_delayed_requests_Pvt.Log_Request
8625: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8626: p_entity_id => p_x_header_rec.header_id,
8627: p_request_type => OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT,
8628: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 8679: OE_delayed_requests_Pvt.Log_Request

8675: p_x_header_rec.Source_Document_Type_id = 10 AND
8676: p_x_header_rec.Source_Document_id is null AND
8677: p_x_header_rec.Orig_sys_document_ref is null THEN
8678: oe_debug_pub.add('log request to create internal Req for ISO');
8679: OE_delayed_requests_Pvt.Log_Request
8680: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8681: p_entity_id => p_x_header_rec.header_id,
8682: p_request_type => OE_GLOBALS.G_CREATE_INTERNAL_REQ,
8683: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

Line 8776: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8772: END IF;
8773:
8774: --log delayed request
8775: oe_debug_pub.add('log versioning request',1);
8776: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8777: p_entity_id => p_x_header_rec.header_id,
8778: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8779: p_requesting_entity_id => p_x_header_rec.header_id,
8780: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 8795: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

8791: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8792: p_entity_id => p_x_header_rec.header_id,
8793: p_hist_type_code => 'UPDATE');
8794: --log delayed request
8795: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8796: p_entity_id => p_x_header_rec.header_id,
8797: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8798: p_requesting_entity_id => p_x_header_rec.header_id,
8799: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,

Line 8936: OE_DELAYED_REQUESTS_PVT.Process_Request_for_ReqType

8932: -- QUOTING changes - moved this call within another create loop
8933: -- later as holds should be applied only to orders in fulfillment phase.
8934:
8935: --Fix bug 1649402
8936: OE_DELAYED_REQUESTS_PVT.Process_Request_for_ReqType
8937: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
8938: ,p_delete => FND_API.G_TRUE
8939: ,x_return_status=> l_return_status
8940: );

Line 9072: OE_delayed_requests_Pvt.log_request

9068: -- Log a request to cancel the workflow.
9069: /*
9070: -- commented to take care of P1 issues in configuration
9071:
9072: OE_delayed_requests_Pvt.log_request
9073: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9074: p_entity_id => p_x_header_rec.header_id,
9075: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9076: p_requesting_entity_id => p_x_header_rec.header_id,

Line 9092: OE_delayed_requests_Pvt.log_request(

9088:
9089: -- OE_GLOBALS.G_RECURSION_MODE := l_recursion_mode;
9090: -- BUG 2013611 - Increment promotional balance in response to cancellation
9091: oe_debug_pub.add('log request to Reverse_Limits for CANCEL in HEADER Post Write',1);
9092: OE_delayed_requests_Pvt.log_request(
9093: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9094: p_entity_id => p_x_header_rec.header_id,
9095: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
9096: p_requesting_entity_id => p_x_header_rec.header_id,

Line 9140: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

9136: IF(l_debug_level>0) THEN
9137: oe_debug_pub.ADD('14763723 Rasing the XML Event for Header before line processing');
9138: END IF;
9139:
9140: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
9141: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
9142: ,p_delete => FND_API.G_TRUE
9143: ,x_return_status => l_return_status
9144: );

Line 9800: OE_Delayed_Requests_Pvt.Log_Request

9796: -- , log delayed requests to update amounts based on the new currency
9797: FOR c IN lines LOOP
9798:
9799: -- Request to decrement amounts based on old currency code
9800: OE_Delayed_Requests_Pvt.Log_Request
9801: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9802: ,p_entity_id => c.line_id
9803: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9804: ,p_requesting_entity_id => p_header_rec.header_id

Line 9834: OE_Delayed_Requests_Pvt.Log_Request

9830: --For bug 3563983
9831: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9832: THEN
9833: -- Request to increment amounts based on new currency code
9834: OE_Delayed_Requests_Pvt.Log_Request
9835: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9836: ,p_entity_id => c.line_id
9837: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER
9838: ,p_requesting_entity_id => p_header_rec.header_id

Line 9871: OE_Delayed_Requests_Pvt.Log_Request

9867: -- sum of amounts across all shipments in the line set are
9868: -- within release min/max limits set on blanket line
9869: IF c.line_set_id IS NOT NULL THEN
9870:
9871: OE_Delayed_Requests_Pvt.Log_Request
9872: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
9873: ,p_entity_id => c.line_set_id
9874: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
9875: ,p_requesting_entity_id => c.line_id