DBA Data[Home] [Help]

APPS.OE_FREIGHT_CHOICES_PVT dependencies on OE_GLOBALS

Line 254: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE

250: LOOP
251: -- We need to set the Message Context for each line.
252:
253: OE_Msg_Pub.Set_Msg_Context
254: ( p_entity_code => OE_GLOBALS.G_ENTITY_LINE
255: ,p_entity_id => c_ship_method.line_id
256: ,p_header_id => p_header_id
257: ,p_line_id => c_ship_method.line_id
258: ,p_order_source_id => c_ship_method.order_source_id

Line 310: ELSIF c_ship_method.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

306: IF l_debug_level > 0 THEN
307: OE_DEBUG_PUB.Add('Line is Shipped/Fulfilled/Closed:'||
308: c_ship_method.line_id ,1);
309: END IF;
310: ELSIF c_ship_method.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
311:
312: -- We are not going to send Config lines to FTE
313: -- We have to store the config lines in the line table.
314: IF l_debug_level > 0 THEN

Line 1331: l_control_rec OE_GLOBALS.Control_Rec_Type;

1327: l_fte_source_line_tab FTE_PROCESS_REQUESTS.Fte_Source_Line_Tab;
1328: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1329: query_line_tbl OE_Order_PUB.Line_Tbl_Type;
1330: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1331: l_control_rec OE_GLOBALS.Control_Rec_Type;
1332: l_line_rec OE_ORDER_PUB.line_rec_type ;
1333: l_bulk_adj_rec OE_Freight_Rating_PVT.Bulk_Line_Adj_Rec_Type;
1334: l_count Number;
1335: l_fte_count Number := 1;

Line 1371: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

1367: ,oe_price_adjustments opa
1368: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
1369: AND list_line_type_code = 'COST' -- For bug 7043225
1370: AND ool.line_id = opa.line_id
1371: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
1372: AND ool.ato_line_id = p_ato_line_id;
1373:
1374: /*CURSOR C_CONFIG_LINE_EXISTS(p_line_id IN NUMBER) IS
1375: SELECT 1 from oe_order_lines_all

Line 1377: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;

1373:
1374: /*CURSOR C_CONFIG_LINE_EXISTS(p_line_id IN NUMBER) IS
1375: SELECT 1 from oe_order_lines_all
1376: WHERE ato_line_id = p_line_id
1377: AND item_type_code = OE_GLOBALS.G_ITEM_CONFIG;
1378: */
1379: BEGIN
1380:
1381: oe_debug_pub.add(' Entering the procedure process freight choices');

Line 1458: query_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

1454:
1455: query_line_tbl(1).freight_carrier_code :=
1456: g_fte_line_rate_tab(M).carrier_freight_code;
1457:
1458: query_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1459:
1460: /* Start Audit Trail */
1461:
1462: query_line_tbl(1).change_reason := 'SYSTEM';

Line 1473: --l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;

1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add('No Changes to save', 4);
1471: END IF;
1472: /* renga-review */
1473: --l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
1474:
1475: query_line_tbl(1).operation := OE_GLOBALS.G_OPR_NONE;
1476:
1477: --x_no_opr_count := x_no_opr_count + 1;

Line 1475: query_line_tbl(1).operation := OE_GLOBALS.G_OPR_NONE;

1471: END IF;
1472: /* renga-review */
1473: --l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
1474:
1475: query_line_tbl(1).operation := OE_GLOBALS.G_OPR_NONE;
1476:
1477: --x_no_opr_count := x_no_opr_count + 1;
1478:
1479: End If;

Line 1514: IF query_line_tbl(1).operation = OE_GLOBALS.G_OPR_UPDATE

1510: IF l_debug_level > 0 THEN
1511: oe_debug_pub.add('cfg line '|| g_line_tbl(l_index).line_id, 3);
1512: END IF;
1513:
1514: IF query_line_tbl(1).operation = OE_GLOBALS.G_OPR_UPDATE
1515: THEN
1516:
1517: g_line_tbl(l_index).shipping_method_code :=
1518: query_line_tbl(1).shipping_method_code;

Line 1562: p_operation => OE_GLOBALS.G_OPR_UPDATE);

1558: oe_debug_pub.add('Register changed line: '||l_line_rec.line_id,1);
1559: OE_LINE_ADJ_UTIL.Register_Changed_Lines
1560: (p_line_id => query_line_tbl(1).line_id,
1561: p_header_id => query_line_tbl(1).header_id,
1562: p_operation => OE_GLOBALS.G_OPR_UPDATE);
1563:
1564:
1565: END IF; -- if deleted_costs...
1566: /* Commented for bug 7043225. We now need to allow charges to get created on ATO Model,

Line 1661: p_operation => OE_GLOBALS.G_OPR_UPDATE);

1657: -- register changed line for config item line.
1658: OE_LINE_ADJ_UTIL.Register_Changed_Lines
1659: (p_line_id => l_line_id,
1660: p_header_id => l_header_id,
1661: p_operation => OE_GLOBALS.G_OPR_UPDATE);
1662:
1663: -- deleting the parents of the config line.
1664: -- these deleted parent lines have been registered in
1665: -- previous loop looping through p_fte_rates_tab, so

Line 1696: AND l_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN

1692: /* J := l_line_tbl.FIRST;
1693: WHILE J IS NOT NULL LOOP
1694: -- delete those non-shippable ATO parent lines
1695: IF l_line_tbl(J).ato_line_id IS NOT NULL
1696: AND l_line_tbl(J).item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1697: l_line_tbl(J).calculate_price_flag := 'N';
1698: oe_debug_pub.add('ATO item price flag set to N :'||l_line_tbl(J).line_id);
1699: END IF;
1700: J := l_line_tbl.NEXT(J);

Line 1720: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;

1716: l_control_rec.controlled_operation := TRUE;
1717: l_control_rec.change_attributes := TRUE;
1718: l_control_rec.validate_entity := TRUE;
1719: l_control_rec.write_to_DB := TRUE;
1720: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
1721:
1722: --l_line_tbl.operation := OE_GLOBALS.G_OPR_UPDATE;
1723:
1724: OE_ORDER_PVT.Lines

Line 1722: --l_line_tbl.operation := OE_GLOBALS.G_OPR_UPDATE;

1718: l_control_rec.validate_entity := TRUE;
1719: l_control_rec.write_to_DB := TRUE;
1720: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_LINE;
1721:
1722: --l_line_tbl.operation := OE_GLOBALS.G_OPR_UPDATE;
1723:
1724: OE_ORDER_PVT.Lines
1725: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1726: ,p_control_rec => l_control_rec

Line 1740: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1736:
1737: l_pricing_event := 'BATCH';
1738:
1739: OE_delayed_requests_Pvt.log_request(
1740: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1741: p_entity_id => p_header_id,
1742: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1743: p_requesting_entity_id => p_header_id,
1744: p_request_unique_key1 => l_pricing_event,

Line 1742: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1738:
1739: OE_delayed_requests_Pvt.log_request(
1740: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1741: p_entity_id => p_header_id,
1742: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1743: p_requesting_entity_id => p_header_id,
1744: p_request_unique_key1 => l_pricing_event,
1745: p_param1 => p_header_id,
1746: p_param2 => l_pricing_event,

Line 1747: p_request_type => OE_GLOBALS.G_PRICE_ORDER,

1743: p_requesting_entity_id => p_header_id,
1744: p_request_unique_key1 => l_pricing_event,
1745: p_param1 => p_header_id,
1746: p_param2 => l_pricing_event,
1747: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
1748: x_return_status => l_return_status);
1749:
1750:
1751: IF l_debug_level > 0 THEN -- bug7433107