eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_ADJ_PVT dependencies on OE_DELAYED_REQUESTS_PVT

Line 193: OE_Delayed_Requests_Pvt.Log_Request

189: OE_Order_Cache.Load_Order_Header(update_line.header_id);
190: --for bug 3108881.Log the request for Orders only
191: IF nvl(update_line.transaction_phase_code,'F') = 'F' THEN
192:
193: OE_Delayed_Requests_Pvt.Log_Request
194: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
195: ,p_entity_id => update_line.line_id
196: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
197: ,p_requesting_entity_id => update_line.line_id

Line 228: OE_Delayed_Requests_Pvt.Log_Request

224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: IF update_line.line_set_id IS NOT NULL THEN
228: OE_Delayed_Requests_Pvt.Log_Request
229: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL
230: ,p_entity_id => update_line.line_set_id
231: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE
232: ,p_requesting_entity_id => update_line.line_id

Line 255: OE_Delayed_Requests_Pvt.Log_Request(

251: IF update_line.commitment_id IS NOT NULL
252: AND OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
253:
254: oe_debug_pub.add('Logging delayed request for Commitment.', 2);
255: OE_Delayed_Requests_Pvt.Log_Request(
256: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
257: p_entity_id => update_line.line_id,
258: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
259: p_requesting_entity_id => update_line.line_id,

Line 724: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

720: l_header_adj_rec.list_line_type_code NOT IN ('COST','TAX')
721: then
722:
723: adj_debug('Log header level PRICE_ADJ');
724: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
725: p_entity_id => l_header_adj_rec.Header_id,
726: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
727: p_requesting_entity_id => l_header_adj_rec.HEader_id,
728: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

Line 820: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,

816: p_x_header_adj_tbl(I) := l_Header_Adj_rec;
817: p_x_old_Header_Adj_tbl(I) := l_old_Header_Adj_rec;
818: OE_Header_Adj_Security.g_check_all_cols_constraint := 'Y';
819: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
820: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
821: p_entity_id => l_header_adj_rec.Price_adjustment_id,
822: p_request_type => NULL,
823: x_return_status => l_return_status);
824: IF l_control_rec.Process_Partial THEN

Line 838: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,

834: p_x_header_adj_tbl(I) := l_Header_Adj_rec;
835: p_x_old_Header_Adj_tbl(I) := l_old_Header_Adj_rec;
836: OE_Header_Adj_Security.g_check_all_cols_constraint := 'Y';
837: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
838: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
839: p_entity_id => l_header_adj_rec.Price_adjustment_id,
840: p_request_type => NULL,
841: x_return_status => l_return_status);
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 850: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,

846: l_Header_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: p_x_header_adj_tbl(I) := l_Header_Adj_rec;
848: p_x_old_Header_Adj_tbl(I) := l_old_Header_Adj_rec;
849: OE_Header_Adj_Security.g_check_all_cols_constraint := 'Y';
850: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
851: p_entity_id => l_header_adj_rec.Price_adjustment_id,
852: p_request_type => NULL,
853: x_return_status => l_return_status);
854:

Line 1418: oe_delayed_requests_pvt.log_request(

1414: 1503357 - Minor change to handle header level adjustments
1415: */
1416:
1417: if (l_line_adj_rec.line_id is NULL) Then
1418: oe_delayed_requests_pvt.log_request(
1419: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1420: p_entity_id => l_Line_adj_rec.header_id,
1421: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1422: p_requesting_entity_id => l_Line_adj_rec.header_id,

Line 1427: oe_delayed_requests_pvt.log_request(

1423: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1424: x_return_status => l_return_status);
1425: else
1426: If OE_GLOBALS.G_UI_FLAG and nvl(l_Line_adj_rec.automatic_flag,'Y') = 'N' Then
1427: oe_delayed_requests_pvt.log_request(
1428: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1429: p_entity_id => l_Line_adj_rec.Line_id,
1430: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1431: p_requesting_entity_id => l_Line_adj_rec.Line_id,

Line 1437: oe_delayed_requests_pvt.log_request(

1433: p_param1 => 'UI',
1434: x_return_status => l_return_status);
1435:
1436: else
1437: oe_delayed_requests_pvt.log_request(
1438: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1439: p_entity_id => l_Line_adj_rec.Line_id,
1440: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1441: p_requesting_entity_id => l_Line_adj_rec.Line_id,

Line 1547: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,

1543: p_x_Line_Adj_tbl(I) := l_Line_Adj_rec;
1544: p_x_old_Line_Adj_tbl(I) := l_old_Line_Adj_rec;
1545: OE_Line_Adj_Security.g_check_all_cols_constraint := 'Y';
1546: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
1547: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
1548: p_entity_id => l_line_adj_rec.Price_adjustment_id,
1549: p_request_type => NULL,
1550: x_return_status => l_return_status);
1551: IF l_control_rec.Process_Partial THEN

Line 1564: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,

1560: p_x_Line_Adj_tbl(I) := l_Line_Adj_rec;
1561: p_x_old_Line_Adj_tbl(I) := l_old_Line_Adj_rec;
1562: OE_Line_Adj_Security.g_check_all_cols_constraint := 'Y';
1563: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
1564: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
1565: p_entity_id => l_line_adj_rec.Price_adjustment_id,
1566: p_request_type => NULL,
1567: x_return_status => l_return_status);
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1576: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,

1572: l_Line_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: p_x_Line_Adj_tbl(I) := l_Line_Adj_rec;
1574: p_x_old_Line_Adj_tbl(I) := l_old_Line_Adj_rec;
1575: OE_Line_Adj_Security.g_check_all_cols_constraint := 'Y';
1576: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
1577: p_entity_id => l_line_adj_rec.Price_adjustment_id,
1578: p_request_type => NULL,
1579: x_return_status => l_return_status);
1580:

Line 1970: /* OE_delayed_requests_Pvt.log_request(

1966: -- Log a delayed request to cause repricing due to deleted
1967: -- record
1968: --2442012
1969:
1970: /* OE_delayed_requests_Pvt.log_request(
1971: p_entity_code => OE_GLOBALS.G_ENTITY_HEader_Price_Att,
1972: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
1973: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEader_Price_Att,
1974: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 1980: OE_delayed_requests_Pvt.log_request(

1976: p_param2 => 'LINE',
1977: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
1978: x_return_status => l_return_status);
1979:
1980: OE_delayed_requests_Pvt.log_request(
1981: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1982: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
1983: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1984: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2013: /* OE_delayed_requests_Pvt.log_request(

2009: End;
2010:
2011: If l_booked_flag='Y' Then
2012: l_pricing_event := 'BATCH,BOOK,SHIP';
2013: /* OE_delayed_requests_Pvt.log_request(
2014: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2015: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
2016: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2017: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2027: OE_delayed_requests_Pvt.log_request(

2023: Else
2024: l_pricing_event := 'BATCH';
2025: End If;
2026:
2027: OE_delayed_requests_Pvt.log_request(
2028: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2029: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
2030: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2031: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2102: oe_delayed_requests_pvt.delete_request

2098: p_x_old_Header_Price_Att_tbl(I) := l_old_Header_Price_Att_rec;
2099: /*
2100: OE_Header_PAttr_Security.g_check_all_cols_constraint := 'Y';
2101: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
2102: oe_delayed_requests_pvt.delete_request
2103: (p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
2104: p_entity_id => l_header_Price_Att_rec.order_price_attrib_id,
2105: p_request_type => NULL,
2106: x_return_status => l_return_status);

Line 2123: oe_delayed_requests_pvt.delete_request

2119: p_x_old_Header_Price_Att_tbl(I) := l_old_Header_Price_Att_rec;
2120: /*
2121: OE_Header_PAttr_Security.g_check_all_cols_constraint := 'Y';
2122: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
2123: oe_delayed_requests_pvt.delete_request
2124: (p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
2125: p_entity_id => l_header_Price_Att_rec.order_price_attrib_id,
2126: p_request_type => NULL,
2127: x_return_status => l_return_status);

Line 3114: /* OE_delayed_requests_Pvt.log_request(

3110: OE_Line_Pattr_Util.Delete_Row
3111: ( p_order_price_attrib_id => l_Line_price_att_rec.order_price_attrib_id
3112: );
3113: --2442012
3114: /* OE_delayed_requests_Pvt.log_request(
3115: p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att,
3116: p_entity_id => l_Line_Price_Att_rec.line_id,
3117: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att,
3118: p_requesting_entity_id => l_Line_Price_Att_rec.line_id,

Line 3124: OE_delayed_requests_Pvt.log_request(

3120: p_param2 => 'LINE',
3121: p_request_type => OE_GLOBALS.G_PRICE_LINE,
3122: x_return_status => l_return_status);
3123:
3124: OE_delayed_requests_Pvt.log_request(
3125: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3126: p_entity_id => l_Line_Price_Att_rec.Header_Id,
3127: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3128: p_requesting_entity_id => l_Line_Price_Att_rec.Header_Id,

Line 3148: OE_delayed_requests_Pvt.log_request(

3144: l_pricing_event := 'ORDER,BOOK';
3145: Else
3146: l_pricing_event := 'ORDER';
3147: End If;
3148: OE_delayed_requests_Pvt.log_request(
3149: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3150: p_entity_id => l_Line_Price_Att_rec.Header_Id,
3151: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3152: p_requesting_entity_id => l_Line_Price_Att_rec.Header_Id,

Line 3165: OE_delayed_requests_Pvt.log_request(

3161: l_pricing_event := 'LINE,SHIP';
3162: Else
3163: l_pricing_event := 'LINE';
3164: End if;
3165: OE_delayed_requests_Pvt.log_request(
3166: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3167: p_entity_id => l_Line_Price_Att_rec.Line_Id,
3168: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3169: p_requesting_entity_id => l_Line_Price_Att_rec.Line_Id,

Line 8932: /* OE_delayed_requests_Pvt.log_request(

8928: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
8929: l_line_rec.calculate_price_flag := 'Y';
8930: adj_debug('logging delayed request to price line');
8931: l_pricing_event := 'BATCH'; --2442012
8932: /* OE_delayed_requests_Pvt.log_request(
8933: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8934: p_entity_id => l_line_rec.line_id,
8935: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8936: p_requesting_entity_id => l_line_rec.line_id,

Line 8947: OE_delayed_requests_Pvt.log_request(

8943: if (l_match_phase_id) Then
8944: -- modifier in BOOK phase
8945: l_pricing_event := 'BATCH,BOOK';
8946: end if;
8947: OE_delayed_requests_Pvt.log_request(
8948: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
8949: p_entity_id => l_line_rec.line_Id,
8950: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
8951: p_requesting_entity_id => l_line_rec.line_Id,

Line 10348: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(

10344: -- Need to log a delayed request to apply this header level adjustment
10345: -- to all lines on this order if not all lines were passed to pricing engine.
10346:
10347: adj_debug('Logging request to update all lines for header level adjustment.', 1);
10348: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
10349: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
10350: p_entity_id => l_Line_adj_tbl(i).header_id,
10351: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
10352: p_requesting_entity_id => l_Line_adj_tbl(i).header_id,

Line 10696: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

10692:
10693: G_STMT_NO := 'process_adjustments#140';
10694: /*
10695: -- Process Requests for Pricing line (for new line created for PRG)
10696: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
10697: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
10698: ,p_delete => FND_API.G_TRUE
10699: ,x_return_status => x_return_status
10700: );