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_DELAYED_REQUESTS_UTIL dependencies on OE_DELAYED_REQUESTS_PVT

Line 2586: OE_Delayed_Requests_PVT.Delete_Request

2582:
2583: oe_debug_pub.add
2584: ('deleting req '|| p_update_shipping_tbl(l_update_shipping_index).entity_id);
2585:
2586: OE_Delayed_Requests_PVT.Delete_Request
2587: (p_entity_code => p_update_shipping_tbl(l_update_shipping_index).entity_code
2588: ,p_entity_id => p_update_shipping_tbl(l_update_shipping_index).entity_id
2589: ,p_request_Type => p_update_shipping_tbl(l_update_shipping_index).request_type
2590: ,p_request_unique_key1

Line 2654: OE_Delayed_Requests_PVT.Delete_Request

2650: oe_debug_pub.add('RUnique 1 : '||p_ship_confirmation_tbl(l_shipping_index).request_unique_key1,2);
2651: oe_debug_pub.add('Entity Id : '||to_char(p_ship_confirmation_tbl(l_shipping_index).entity_id),2);
2652: IF p_line_id <> p_ship_confirmation_tbl(l_shipping_index).entity_id THEN
2653:
2654: OE_Delayed_Requests_PVT.Delete_Request
2655: (p_entity_code => p_ship_confirmation_tbl(l_shipping_index).entity_code
2656: ,p_entity_id => p_ship_confirmation_tbl(l_shipping_index).entity_id
2657: ,p_request_Type => p_ship_confirmation_tbl(l_shipping_index).request_type
2658: ,p_request_unique_key1 => p_ship_confirmation_tbl(l_shipping_index).request_unique_key1

Line 4981: ( p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type

4977:
4978: END Schedule_Line;
4979:
4980: PROCEDURE Process_Tax
4981: ( p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type
4982: , x_return_status OUT NOCOPY VARCHAR2)
4983:
4984: IS
4985: l_return_status Varchar2(30):= FND_API.G_RET_STS_SUCCESS;

Line 5224: oe_debug_pub.add( 'value count '|| OE_Delayed_Requests_PVT.G_Delayed_Requests.count);

5220: -- l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id);
5221:
5222: l_request_ind := p_entity_id_tbl(l_index).request_ind;
5223: IF l_debug_level > 0 THEN
5224: oe_debug_pub.add( 'value count '|| OE_Delayed_Requests_PVT.G_Delayed_Requests.count);
5225: END IF;
5226:
5227: /* Bug # 3337661: Corrected IF stmt by using OE_GLOBALS.G_TAX_LINE */
5228: -- Front Ported for bug 3397062

Line 5229: if OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) and OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE then

5225: END IF;
5226:
5227: /* Bug # 3337661: Corrected IF stmt by using OE_GLOBALS.G_TAX_LINE */
5228: -- Front Ported for bug 3397062
5229: if OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) and OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE then
5230:
5231: l_call_credit_checking := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).param1;
5232:
5233: end if;

Line 5231: l_call_credit_checking := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).param1;

5227: /* Bug # 3337661: Corrected IF stmt by using OE_GLOBALS.G_TAX_LINE */
5228: -- Front Ported for bug 3397062
5229: if OE_Delayed_Requests_PVT.G_Delayed_Requests.exists(l_request_ind) and OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).request_type = OE_GLOBALS.G_TAX_LINE then
5230:
5231: l_call_credit_checking := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_request_ind).param1;
5232:
5233: end if;
5234:
5235: IF l_debug_level > 0 THEN

Line 5291: OE_Delayed_Requests_Pvt.Log_Request(

5287: AND l_commitment_id IS NOT NULL THEN
5288: IF l_debug_level > 0 THEN
5289: oe_debug_pub.add('Logging delayed request for Commitment when tax value changes.', 2);
5290: END IF;
5291: OE_Delayed_Requests_Pvt.Log_Request(
5292: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5293: p_entity_id => l_line_id,
5294: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5295: p_requesting_entity_id => l_line_id,

Line 5319: OE_delayed_requests_Pvt.log_request

5315: AND l_shipped_quantity IS NULL) THEN
5316: IF l_debug_level > 0 THEN
5317: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);
5318: END IF;
5319: OE_delayed_requests_Pvt.log_request
5320: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5321: p_entity_id => l_header_id,
5322: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5323: p_requesting_entity_id => l_line_id,

Line 5340: OE_delayed_requests_Pvt.log_request

5336: AND l_shipped_quantity IS NULL THEN
5337: IF l_debug_level > 0 THEN
5338: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value for prepaid order',2);
5339: END IF;
5340: OE_delayed_requests_Pvt.log_request
5341: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5342: p_entity_id => l_header_id,
5343: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5344: p_requesting_entity_id => l_line_id,

Line 5363: OE_delayed_requests_Pvt.log_request

5359: IF NVL(new_tax_value, 0) > NVL(l_tax_value, 0) THEN
5360:
5361: oe_debug_pub.ADD('Logging delayed request for Verify Payment for change in tax value',2);
5362:
5363: OE_delayed_requests_Pvt.log_request
5364: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5365: p_entity_id => l_header_id,
5366: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5367: p_requesting_entity_id => l_line_id,

Line 5392: OE_delayed_requests_Pvt.log_request

5388: IF ( l_hold_result = FND_API.G_TRUE ) THEN
5389:
5390: oe_debug_pub.add('Logging delayed request for verify payment for change in tax value and hold exist') ;
5391:
5392: OE_delayed_requests_Pvt.log_request
5393: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5394: p_entity_id => l_header_id,
5395: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5396: p_requesting_entity_id => l_line_id,

Line 6050: l_request_rec := OE_Delayed_Requests_PVT.G_Delayed_Requests(p_request_ind);

6046:
6047: Begin
6048:
6049:
6050: l_request_rec := OE_Delayed_Requests_PVT.G_Delayed_Requests(p_request_ind);
6051: l_header_id := l_request_rec.entity_id;
6052:
6053: IF l_debug_level > 0 THEN
6054: oe_debug_pub.add( 'retrieving key information from base table') ;

Line 6207: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.first;

6203: END IF;
6204: END IF; -- end of check for customer ack request
6205:
6206:
6207: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.first;
6208:
6209: --find and insert lines for that header
6210: WHILE l_count IS NOT NULL LOOP
6211:

Line 6213: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN

6209: --find and insert lines for that header
6210: WHILE l_count IS NOT NULL LOOP
6211:
6212: --Check to see if this is a line-level xml request for the same transaction type and header id
6213: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN
6214: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id
6215: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6216:
6217: -- add this line to the lines table for insertion

Line 6214: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id

6210: WHILE l_count IS NOT NULL LOOP
6211:
6212: --Check to see if this is a line-level xml request for the same transaction type and header id
6213: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN
6214: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id
6215: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6216:
6217: -- add this line to the lines table for insertion
6218: IF l_debug_level > 0 THEN

Line 6215: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN

6211:
6212: --Check to see if this is a line-level xml request for the same transaction type and header id
6213: IF OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).request_type = OE_GLOBALS.G_GENERATE_XML_REQ_LN
6214: AND OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param1 = l_header_id
6215: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6216:
6217: -- add this line to the lines table for insertion
6218: IF l_debug_level > 0 THEN
6219: oe_debug_pub.add( 'LINE_ID FOR ACKNOWLEDGMENT => ' || OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id ) ;

Line 6219: oe_debug_pub.add( 'LINE_ID FOR ACKNOWLEDGMENT => ' || OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id ) ;

6215: AND nvl(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param7, 'INT') = nvl(l_acknowledgment_type, 'INT') THEN
6216:
6217: -- add this line to the lines table for insertion
6218: IF l_debug_level > 0 THEN
6219: oe_debug_pub.add( 'LINE_ID FOR ACKNOWLEDGMENT => ' || OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id ) ;
6220: END IF;
6221:
6222: If l_line_found = 'N' then
6223: --set flag to show that a line has been found

Line 6240: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;

6236: l_bulk_line_rec.sold_to_org_id.extend;
6237: l_bulk_line_rec.change_sequence.extend;
6238:
6239: l_bulk_line_rec.header_id(i) := l_header_id;
6240: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6241: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6242: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6243: l_bulk_line_rec.request_id(i) := l_itemkey;
6244: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);

Line 6242: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;

6238:
6239: l_bulk_line_rec.header_id(i) := l_header_id;
6240: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6241: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6242: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6243: l_bulk_line_rec.request_id(i) := l_itemkey;
6244: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);
6245: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;
6246:

Line 6244: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);

6240: l_bulk_line_rec.line_id(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6241: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6242: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6243: l_bulk_line_rec.request_id(i) := l_itemkey;
6244: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);
6245: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;
6246:
6247: IF l_debug_level > 0 THEN
6248: oe_debug_pub.add( 'after assignment to bulk record') ;

Line 6245: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;

6241: l_bulk_line_rec.xml_transaction_type_code(i) := l_acknowledgment_type;
6242: l_bulk_line_rec.last_ack_code(i) := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param8;
6243: l_bulk_line_rec.request_id(i) := l_itemkey;
6244: l_bulk_line_rec.sold_to_org_id(i) := to_number(OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).param4);
6245: l_bulk_line_rec.change_sequence(i) :=OE_Delayed_Requests_PVT. G_Delayed_Requests(l_count).param5;
6246:
6247: IF l_debug_level > 0 THEN
6248: oe_debug_pub.add( 'after assignment to bulk record') ;
6249: end if;

Line 6258: l_line_id_tbl(i).line_id := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;

6254: -- 5738023
6255: IF l_debug_level > 0 THEN
6256: oe_debug_pub.add( 'Assigning entity id to line table', 3);
6257: END IF;
6258: l_line_id_tbl(i).line_id := OE_Delayed_Requests_PVT.G_Delayed_Requests(l_count).entity_id;
6259: END IF;
6260:
6261: i := i + 1;
6262:

Line 6265: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);

6261: i := i + 1;
6262:
6263:
6264: l_count_old := l_count;
6265: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6266:
6267: -- Processing has been done, so delete line-level request now
6268: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);
6269:

Line 6268: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);

6264: l_count_old := l_count;
6265: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6266:
6267: -- Processing has been done, so delete line-level request now
6268: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);
6269:
6270: ELSE
6271: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6272: END IF;

Line 6271: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);

6267: -- Processing has been done, so delete line-level request now
6268: OE_Delayed_Requests_PVT.G_Delayed_Requests.Delete(l_count_old);
6269:
6270: ELSE
6271: l_count := OE_Delayed_Requests_PVT.G_Delayed_Requests.Next(l_count);
6272: END IF;
6273:
6274: END LOOP;
6275: