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_ACKNOWLEDGMENT_PVT dependencies on OE_GLOBALS

Line 457: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

453: ***/
454:
455: -- lkxu, for bug 1701377
456: -- to check if EC is installed
457: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
458: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
459: END IF;
460:
461: IF OE_GLOBALS.G_EC_INSTALLED <> 'Y' THEN

Line 458: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

454:
455: -- lkxu, for bug 1701377
456: -- to check if EC is installed
457: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
458: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
459: END IF;
460:
461: IF OE_GLOBALS.G_EC_INSTALLED <> 'Y' THEN
462: IF l_debug_level > 0 THEN

Line 461: IF OE_GLOBALS.G_EC_INSTALLED <> 'Y' THEN

457: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
458: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
459: END IF;
460:
461: IF OE_GLOBALS.G_EC_INSTALLED <> 'Y' THEN
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add( 'EC NOT INSTALLED - NO ACK REQUIRED' , 1 ) ;
464: END IF;
465: IF l_debug_level > 0 THEN

Line 857: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,

853: -- FOR I IN l_line_tbl.first..l_line_tbl.last LOOP
854:
855: -- modified the following condition to fix 2380911 to take care of INSERT
856: -- operation if the Acknowledgment is already extracted.
857: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
858: l_old_line_tbl(I).inventory_item_id)
859: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
860: l_old_line_tbl(I).unit_selling_price)
861: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,

Line 859: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,

855: -- modified the following condition to fix 2380911 to take care of INSERT
856: -- operation if the Acknowledgment is already extracted.
857: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
858: l_old_line_tbl(I).inventory_item_id)
859: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
860: l_old_line_tbl(I).unit_selling_price)
861: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
862: l_old_line_tbl(I).ordered_quantity)
863: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,

Line 861: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,

857: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
858: l_old_line_tbl(I).inventory_item_id)
859: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
860: l_old_line_tbl(I).unit_selling_price)
861: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
862: l_old_line_tbl(I).ordered_quantity)
863: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
864: l_old_line_tbl(I).order_quantity_uom)
865: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,

Line 863: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,

859: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
860: l_old_line_tbl(I).unit_selling_price)
861: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
862: l_old_line_tbl(I).ordered_quantity)
863: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
864: l_old_line_tbl(I).order_quantity_uom)
865: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
866: l_old_line_tbl(I).shipped_quantity)
867: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,

Line 865: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,

861: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
862: l_old_line_tbl(I).ordered_quantity)
863: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
864: l_old_line_tbl(I).order_quantity_uom)
865: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
866: l_old_line_tbl(I).shipped_quantity)
867: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
868: l_old_line_tbl(I).schedule_ship_date)
869: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,

Line 867: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,

863: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
864: l_old_line_tbl(I).order_quantity_uom)
865: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
866: l_old_line_tbl(I).shipped_quantity)
867: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
868: l_old_line_tbl(I).schedule_ship_date)
869: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
870: l_old_line_tbl(I).schedule_arrival_date)
871: ) OR (

Line 869: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,

865: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
866: l_old_line_tbl(I).shipped_quantity)
867: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
868: l_old_line_tbl(I).schedule_ship_date)
869: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
870: l_old_line_tbl(I).schedule_arrival_date)
871: ) OR (
872: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
873: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE

Line 872: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR

868: l_old_line_tbl(I).schedule_ship_date)
869: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
870: l_old_line_tbl(I).schedule_arrival_date)
871: ) OR (
872: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
873: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE
874: )
875: OR ( l_line_tbl(I).first_ack_code is null AND
876: l_header_rec.first_ack_code is not null )--bug7207426

Line 873: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE

869: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
870: l_old_line_tbl(I).schedule_arrival_date)
871: ) OR (
872: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
873: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE
874: )
875: OR ( l_line_tbl(I).first_ack_code is null AND
876: l_header_rec.first_ack_code is not null )--bug7207426
877: THEN

Line 1270: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,

1266: -- -----------------------------------------------------------------
1267: */
1268: IF l_ack_req_flag = 'N' And
1269: l_header_rec_isnull = 'N' THEN
1270: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
1271: l_old_header_rec.cust_po_number)
1272: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
1273: l_old_header_rec.ship_to_org_id)
1274: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,

Line 1272: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,

1268: IF l_ack_req_flag = 'N' And
1269: l_header_rec_isnull = 'N' THEN
1270: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
1271: l_old_header_rec.cust_po_number)
1272: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
1273: l_old_header_rec.ship_to_org_id)
1274: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,
1275: l_old_header_rec.ordered_date))
1276:

Line 1274: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,

1270: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
1271: l_old_header_rec.cust_po_number)
1272: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
1273: l_old_header_rec.ship_to_org_id)
1274: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,
1275: l_old_header_rec.ordered_date))
1276:
1277: THEN
1278: l_ack_req_flag := 'H';

Line 2033: If Oe_Globals.G_EC_INSTALLED Is Null Then

2029: Oe_Debug_Pub.Add('Entering New Process Acknowledgment');
2030: End If;
2031:
2032: -- Check if EC is installed
2033: If Oe_Globals.G_EC_INSTALLED Is Null Then
2034: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);
2035: End If;
2036: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then
2037: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2034: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);

2030: End If;
2031:
2032: -- Check if EC is installed
2033: If Oe_Globals.G_EC_INSTALLED Is Null Then
2034: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);
2035: End If;
2036: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then
2037: x_return_status := FND_API.G_RET_STS_SUCCESS;
2038: If l_debug_level > 0 Then

Line 2036: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then

2032: -- Check if EC is installed
2033: If Oe_Globals.G_EC_INSTALLED Is Null Then
2034: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);
2035: End If;
2036: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then
2037: x_return_status := FND_API.G_RET_STS_SUCCESS;
2038: If l_debug_level > 0 Then
2039: oe_debug_pub.add('EC not installed');
2040: End If;

Line 2277: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,

2273: When Others Then
2274: l_line_tbl(I).reserved_quantity := NULL;
2275: END;
2276:
2277: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
2278: l_old_line_tbl(I).inventory_item_id)
2279: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2280: l_old_line_tbl(I).unit_selling_price)
2281: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,

Line 2279: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,

2275: END;
2276:
2277: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
2278: l_old_line_tbl(I).inventory_item_id)
2279: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2280: l_old_line_tbl(I).unit_selling_price)
2281: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2282: l_old_line_tbl(I).ordered_quantity)
2283: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,

Line 2281: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,

2277: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
2278: l_old_line_tbl(I).inventory_item_id)
2279: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2280: l_old_line_tbl(I).unit_selling_price)
2281: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2282: l_old_line_tbl(I).ordered_quantity)
2283: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2284: l_old_line_tbl(I).order_quantity_uom)
2285: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,

Line 2283: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,

2279: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2280: l_old_line_tbl(I).unit_selling_price)
2281: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2282: l_old_line_tbl(I).ordered_quantity)
2283: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2284: l_old_line_tbl(I).order_quantity_uom)
2285: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2286: l_old_line_tbl(I).shipped_quantity)
2287: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,

Line 2285: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,

2281: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2282: l_old_line_tbl(I).ordered_quantity)
2283: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2284: l_old_line_tbl(I).order_quantity_uom)
2285: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2286: l_old_line_tbl(I).shipped_quantity)
2287: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
2288: l_old_line_tbl(I).schedule_ship_date)
2289: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,

Line 2287: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,

2283: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2284: l_old_line_tbl(I).order_quantity_uom)
2285: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2286: l_old_line_tbl(I).shipped_quantity)
2287: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
2288: l_old_line_tbl(I).schedule_ship_date)
2289: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2290: l_old_line_tbl(I).schedule_arrival_date)
2291: ) OR (

Line 2289: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,

2285: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2286: l_old_line_tbl(I).shipped_quantity)
2287: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
2288: l_old_line_tbl(I).schedule_ship_date)
2289: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2290: l_old_line_tbl(I).schedule_arrival_date)
2291: ) OR (
2292: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
2293: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE

Line 2292: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR

2288: l_old_line_tbl(I).schedule_ship_date)
2289: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2290: l_old_line_tbl(I).schedule_arrival_date)
2291: ) OR (
2292: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
2293: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE
2294: )
2295: OR ( l_line_tbl(I).first_ack_code is null AND
2296: l_header_rec.first_ack_code is not null )--bug7207426

Line 2293: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE

2289: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2290: l_old_line_tbl(I).schedule_arrival_date)
2291: ) OR (
2292: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
2293: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE
2294: )
2295: OR ( l_line_tbl(I).first_ack_code is null AND
2296: l_header_rec.first_ack_code is not null )--bug7207426
2297: Then

Line 2324: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,

2320: End Loop;
2321:
2322: If l_ack_req_flag = 'N' And
2323: l_header_rec_isnull = 'N' Then
2324: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
2325: l_old_header_rec.cust_po_number)
2326: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
2327: l_old_header_rec.ship_to_org_id)
2328: And OE_GLOBALS.Equal(l_header_rec.ordered_date,

Line 2326: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,

2322: If l_ack_req_flag = 'N' And
2323: l_header_rec_isnull = 'N' Then
2324: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
2325: l_old_header_rec.cust_po_number)
2326: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
2327: l_old_header_rec.ship_to_org_id)
2328: And OE_GLOBALS.Equal(l_header_rec.ordered_date,
2329: l_old_header_rec.ordered_date)) Then
2330: l_ack_req_flag := 'H';

Line 2328: And OE_GLOBALS.Equal(l_header_rec.ordered_date,

2324: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
2325: l_old_header_rec.cust_po_number)
2326: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
2327: l_old_header_rec.ship_to_org_id)
2328: And OE_GLOBALS.Equal(l_header_rec.ordered_date,
2329: l_old_header_rec.ordered_date)) Then
2330: l_ack_req_flag := 'H';
2331: End If;
2332: End If;