DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_DELAYED_REQUESTS_PVT

Line 194: OE_Delayed_Requests_Pvt.Log_Request

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

Line 229: OE_Delayed_Requests_Pvt.Log_Request

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

Line 256: OE_Delayed_Requests_Pvt.Log_Request(

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

Line 725: OE_delayed_requests_Pvt.log_request

721: l_header_adj_rec.list_line_type_code NOT IN ('COST','TAX')
722: then
723: --CC Reversal ER#16014135 Start
724: IF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(l_header_adj_rec.Header_id) IS NOT NULL THEN
725: OE_delayed_requests_Pvt.log_request
726: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
727: p_entity_id => l_header_adj_rec.Header_id,
728: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
729: p_requesting_entity_id =>l_header_adj_rec.Header_id,

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

738: END IF;
739: --CC Reversal ER#16014135 End
740:
741: adj_debug('Log header level PRICE_ADJ');
742: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
743: p_entity_id => l_header_adj_rec.Header_id,
744: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
745: p_requesting_entity_id => l_header_adj_rec.HEader_id,
746: p_request_type => OE_GLOBALS.G_PRICE_ADJ,

Line 755: oe_delayed_requests_pvt.log_request(

751: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754: -- If a manual Header Adjustment gets cascaded
755: oe_delayed_requests_pvt.log_request(
756: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
757: p_entity_id => l_header_adj_rec.Header_Id,
758: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
759: p_requesting_entity_id => l_header_adj_rec.Header_Id,

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

851: p_x_header_adj_tbl(I) := l_Header_Adj_rec;
852: p_x_old_Header_Adj_tbl(I) := l_old_Header_Adj_rec;
853: OE_Header_Adj_Security.g_check_all_cols_constraint := 'Y';
854: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
855: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
856: p_entity_id => l_header_adj_rec.Price_adjustment_id,
857: p_request_type => NULL,
858: x_return_status => l_return_status);
859: IF l_control_rec.Process_Partial THEN

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

869: p_x_header_adj_tbl(I) := l_Header_Adj_rec;
870: p_x_old_Header_Adj_tbl(I) := l_old_Header_Adj_rec;
871: OE_Header_Adj_Security.g_check_all_cols_constraint := 'Y';
872: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
873: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
874: p_entity_id => l_header_adj_rec.Price_adjustment_id,
875: p_request_type => NULL,
876: x_return_status => l_return_status);
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

881: l_Header_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: p_x_header_adj_tbl(I) := l_Header_Adj_rec;
883: p_x_old_Header_Adj_tbl(I) := l_old_Header_Adj_rec;
884: OE_Header_Adj_Security.g_check_all_cols_constraint := 'Y';
885: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
886: p_entity_id => l_header_adj_rec.Price_adjustment_id,
887: p_request_type => NULL,
888: x_return_status => l_return_status);
889:

Line 1453: OE_delayed_requests_Pvt.log_request

1449: 1503357 - Minor change to handle header level adjustments
1450: */
1451: --CC Reversal ER#16014135 Start
1452: IF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(l_Line_adj_rec.header_id) IS NOT NULL THEN
1453: OE_delayed_requests_Pvt.log_request
1454: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1455: p_entity_id => l_Line_adj_rec.header_id,
1456: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1457: p_requesting_entity_id =>l_Line_adj_rec.header_id,

Line 1469: oe_delayed_requests_pvt.log_request(

1465: END IF;
1466: --CC Reversal ER#16014135 End
1467:
1468: if (l_line_adj_rec.line_id is NULL) Then
1469: oe_delayed_requests_pvt.log_request(
1470: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1471: p_entity_id => l_Line_adj_rec.header_id,
1472: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1473: p_requesting_entity_id => l_Line_adj_rec.header_id,

Line 1482: oe_delayed_requests_pvt.log_request(

1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1480: RAISE FND_API.G_EXC_ERROR;
1481: END IF;
1482: oe_delayed_requests_pvt.log_request(
1483: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1484: p_entity_id => l_Line_adj_rec.Header_Id,
1485: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1486: p_requesting_entity_id => l_Line_adj_rec.Header_Id,

Line 1494: oe_delayed_requests_pvt.log_request(

1490: x_return_status => l_return_status);
1491: -- sol_ord_er #16014165 end
1492: else
1493: If OE_GLOBALS.G_UI_FLAG and nvl(l_Line_adj_rec.automatic_flag,'Y') = 'N' Then
1494: oe_delayed_requests_pvt.log_request(
1495: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1496: p_entity_id => l_Line_adj_rec.Line_id,
1497: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1498: p_requesting_entity_id => l_Line_adj_rec.Line_id,

Line 1504: oe_delayed_requests_pvt.log_request(

1500: p_param1 => 'UI',
1501: x_return_status => l_return_status);
1502:
1503: else
1504: oe_delayed_requests_pvt.log_request(
1505: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1506: p_entity_id => l_Line_adj_rec.Line_id,
1507: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1508: p_requesting_entity_id => l_Line_adj_rec.Line_id,

Line 1518: oe_delayed_requests_pvt.log_request(

1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518: oe_delayed_requests_pvt.log_request(
1519: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1520: p_entity_id => l_Line_adj_rec.line_id,
1521: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1522: p_requesting_entity_id => l_Line_adj_rec.line_id,

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

1626: p_x_Line_Adj_tbl(I) := l_Line_Adj_rec;
1627: p_x_old_Line_Adj_tbl(I) := l_old_Line_Adj_rec;
1628: OE_Line_Adj_Security.g_check_all_cols_constraint := 'Y';
1629: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
1630: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
1631: p_entity_id => l_line_adj_rec.Price_adjustment_id,
1632: p_request_type => NULL,
1633: x_return_status => l_return_status);
1634: IF l_control_rec.Process_Partial THEN

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

1643: p_x_Line_Adj_tbl(I) := l_Line_Adj_rec;
1644: p_x_old_Line_Adj_tbl(I) := l_old_Line_Adj_rec;
1645: OE_Line_Adj_Security.g_check_all_cols_constraint := 'Y';
1646: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
1647: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
1648: p_entity_id => l_line_adj_rec.Price_adjustment_id,
1649: p_request_type => NULL,
1650: x_return_status => l_return_status);
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1655: l_Line_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1656: p_x_Line_Adj_tbl(I) := l_Line_Adj_rec;
1657: p_x_old_Line_Adj_tbl(I) := l_old_Line_Adj_rec;
1658: OE_Line_Adj_Security.g_check_all_cols_constraint := 'Y';
1659: oe_delayed_requests_pvt.delete_request(p_entity_code =>OE_GLOBALS.G_ENTITY_LINE_ADJ,
1660: p_entity_id => l_line_adj_rec.Price_adjustment_id,
1661: p_request_type => NULL,
1662: x_return_status => l_return_status);
1663:

Line 2053: /* OE_delayed_requests_Pvt.log_request(

2049: -- Log a delayed request to cause repricing due to deleted
2050: -- record
2051: --2442012
2052:
2053: /* OE_delayed_requests_Pvt.log_request(
2054: p_entity_code => OE_GLOBALS.G_ENTITY_HEader_Price_Att,
2055: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
2056: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEader_Price_Att,
2057: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2063: OE_delayed_requests_Pvt.log_request(

2059: p_param2 => 'LINE',
2060: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
2061: x_return_status => l_return_status);
2062:
2063: OE_delayed_requests_Pvt.log_request(
2064: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2065: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
2066: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2067: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2096: /* OE_delayed_requests_Pvt.log_request(

2092: End;
2093:
2094: If l_booked_flag='Y' Then
2095: l_pricing_event := 'BATCH,BOOK,SHIP';
2096: /* OE_delayed_requests_Pvt.log_request(
2097: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2098: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
2099: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2100: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2110: OE_delayed_requests_Pvt.log_request(

2106: Else
2107: l_pricing_event := 'BATCH';
2108: End If;
2109:
2110: OE_delayed_requests_Pvt.log_request(
2111: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2112: p_entity_id => l_Header_Price_Att_Rec.Header_Id,
2113: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2114: p_requesting_entity_id => l_Header_Price_Att_Rec.Header_Id,

Line 2185: oe_delayed_requests_pvt.delete_request

2181: p_x_old_Header_Price_Att_tbl(I) := l_old_Header_Price_Att_rec;
2182: /*
2183: OE_Header_PAttr_Security.g_check_all_cols_constraint := 'Y';
2184: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
2185: oe_delayed_requests_pvt.delete_request
2186: (p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
2187: p_entity_id => l_header_Price_Att_rec.order_price_attrib_id,
2188: p_request_type => NULL,
2189: x_return_status => l_return_status);

Line 2206: oe_delayed_requests_pvt.delete_request

2202: p_x_old_Header_Price_Att_tbl(I) := l_old_Header_Price_Att_rec;
2203: /*
2204: OE_Header_PAttr_Security.g_check_all_cols_constraint := 'Y';
2205: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
2206: oe_delayed_requests_pvt.delete_request
2207: (p_entity_code =>OE_GLOBALS.G_ENTITY_HEADER_ADJ,
2208: p_entity_id => l_header_Price_Att_rec.order_price_attrib_id,
2209: p_request_type => NULL,
2210: x_return_status => l_return_status);

Line 3197: /* OE_delayed_requests_Pvt.log_request(

3193: OE_Line_Pattr_Util.Delete_Row
3194: ( p_order_price_attrib_id => l_Line_price_att_rec.order_price_attrib_id
3195: );
3196: --2442012
3197: /* OE_delayed_requests_Pvt.log_request(
3198: p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att,
3199: p_entity_id => l_Line_Price_Att_rec.line_id,
3200: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att,
3201: p_requesting_entity_id => l_Line_Price_Att_rec.line_id,

Line 3207: OE_delayed_requests_Pvt.log_request(

3203: p_param2 => 'LINE',
3204: p_request_type => OE_GLOBALS.G_PRICE_LINE,
3205: x_return_status => l_return_status);
3206:
3207: OE_delayed_requests_Pvt.log_request(
3208: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3209: p_entity_id => l_Line_Price_Att_rec.Header_Id,
3210: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3211: p_requesting_entity_id => l_Line_Price_Att_rec.Header_Id,

Line 3231: OE_delayed_requests_Pvt.log_request(

3227: l_pricing_event := 'ORDER,BOOK';
3228: Else
3229: l_pricing_event := 'ORDER';
3230: End If;
3231: OE_delayed_requests_Pvt.log_request(
3232: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3233: p_entity_id => l_Line_Price_Att_rec.Header_Id,
3234: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3235: p_requesting_entity_id => l_Line_Price_Att_rec.Header_Id,

Line 3248: OE_delayed_requests_Pvt.log_request(

3244: l_pricing_event := 'LINE,SHIP';
3245: Else
3246: l_pricing_event := 'LINE';
3247: End if;
3248: OE_delayed_requests_Pvt.log_request(
3249: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3250: p_entity_id => l_Line_Price_Att_rec.Line_Id,
3251: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3252: p_requesting_entity_id => l_Line_Price_Att_rec.Line_Id,

Line 9024: /* OE_delayed_requests_Pvt.log_request(

9020: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
9021: l_line_rec.calculate_price_flag := 'Y';
9022: adj_debug('logging delayed request to price line');
9023: l_pricing_event := 'BATCH'; --2442012
9024: /* OE_delayed_requests_Pvt.log_request(
9025: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9026: p_entity_id => l_line_rec.line_id,
9027: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9028: p_requesting_entity_id => l_line_rec.line_id,

Line 9039: OE_delayed_requests_Pvt.log_request(

9035: if (l_match_phase_id) Then
9036: -- modifier in BOOK phase
9037: l_pricing_event := 'BATCH,BOOK';
9038: end if;
9039: OE_delayed_requests_Pvt.log_request(
9040: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
9041: p_entity_id => l_line_rec.line_Id,
9042: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
9043: p_requesting_entity_id => l_line_rec.line_Id,

Line 10439: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(

10435: -- Need to log a delayed request to apply this header level adjustment
10436: -- to all lines on this order if not all lines were passed to pricing engine.
10437:
10438: adj_debug('Logging request to update all lines for header level adjustment.', 1);
10439: OE_DELAYED_REQUESTS_PVT.LOG_REQUEST(
10440: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
10441: p_entity_id => l_Line_adj_tbl(i).header_id,
10442: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
10443: p_requesting_entity_id => l_Line_adj_tbl(i).header_id,

Line 10448: oe_delayed_requests_pvt.log_request(

10444: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
10445: x_return_status => l_return_status);
10446: -- sol_ord_er #16014165
10447: -- If a manual Header Adjustment gets cascaded
10448: oe_delayed_requests_pvt.log_request(
10449: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
10450: p_entity_id => l_Line_adj_tbl(i).Header_Id,
10451: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
10452: p_requesting_entity_id => l_Line_adj_tbl(i).Header_Id,

Line 10804: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

10800:
10801: G_STMT_NO := 'process_adjustments#140';
10802: /*
10803: -- Process Requests for Pricing line (for new line created for PRG)
10804: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
10805: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
10806: ,p_delete => FND_API.G_TRUE
10807: ,x_return_status => x_return_status
10808: );