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 458: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1293: -- -----------------------------------------------------------------
1294: */
1295: IF l_ack_req_flag = 'N' And
1296: l_header_rec_isnull = 'N' THEN
1297: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
1298: l_old_header_rec.cust_po_number)
1299: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
1300: l_old_header_rec.ship_to_org_id)
1301: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,

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

1295: IF l_ack_req_flag = 'N' And
1296: l_header_rec_isnull = 'N' THEN
1297: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
1298: l_old_header_rec.cust_po_number)
1299: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
1300: l_old_header_rec.ship_to_org_id)
1301: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,
1302: l_old_header_rec.ordered_date))
1303:

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

1297: IF NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
1298: l_old_header_rec.cust_po_number)
1299: AND OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
1300: l_old_header_rec.ship_to_org_id)
1301: AND OE_GLOBALS.Equal(l_header_rec.ordered_date,
1302: l_old_header_rec.ordered_date))
1303:
1304: THEN
1305: l_ack_req_flag := 'H';

Line 2063: If Oe_Globals.G_EC_INSTALLED Is Null Then

2059: Oe_Debug_Pub.Add('Entering New Process Acknowledgment');
2060: End If;
2061:
2062: -- Check if EC is installed
2063: If Oe_Globals.G_EC_INSTALLED Is Null Then
2064: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);
2065: End If;
2066: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2060: End If;
2061:
2062: -- Check if EC is installed
2063: If Oe_Globals.G_EC_INSTALLED Is Null Then
2064: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);
2065: End If;
2066: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068: If l_debug_level > 0 Then

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

2062: -- Check if EC is installed
2063: If Oe_Globals.G_EC_INSTALLED Is Null Then
2064: Oe_Globals.G_EC_INSTALLED := Oe_Globals.Check_Product_Installed(175);
2065: End If;
2066: If Oe_Globals.G_EC_INSTALLED <> 'Y' Then
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068: If l_debug_level > 0 Then
2069: oe_debug_pub.add('EC not installed');
2070: End If;

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

2303: When Others Then
2304: l_line_tbl(I).reserved_quantity := NULL;
2305: END;
2306:
2307: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
2308: l_old_line_tbl(I).inventory_item_id)
2309: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2310: l_old_line_tbl(I).unit_selling_price)
2311: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,

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

2305: END;
2306:
2307: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
2308: l_old_line_tbl(I).inventory_item_id)
2309: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2310: l_old_line_tbl(I).unit_selling_price)
2311: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2312: l_old_line_tbl(I).ordered_quantity)
2313: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,

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

2307: IF NOT (OE_GLOBALS.Equal(l_line_tbl(I).inventory_item_id,
2308: l_old_line_tbl(I).inventory_item_id)
2309: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2310: l_old_line_tbl(I).unit_selling_price)
2311: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2312: l_old_line_tbl(I).ordered_quantity)
2313: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2314: l_old_line_tbl(I).order_quantity_uom)
2315: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,

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

2309: AND OE_GLOBALS.Equal(l_line_tbl(I).unit_selling_price,
2310: l_old_line_tbl(I).unit_selling_price)
2311: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2312: l_old_line_tbl(I).ordered_quantity)
2313: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2314: l_old_line_tbl(I).order_quantity_uom)
2315: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2316: l_old_line_tbl(I).shipped_quantity)
2317: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,

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

2311: AND OE_GLOBALS.Equal(l_line_tbl(I).ordered_quantity,
2312: l_old_line_tbl(I).ordered_quantity)
2313: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2314: l_old_line_tbl(I).order_quantity_uom)
2315: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2316: l_old_line_tbl(I).shipped_quantity)
2317: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
2318: l_old_line_tbl(I).schedule_ship_date)
2319: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,

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

2313: AND OE_GLOBALS.Equal(l_line_tbl(I).order_quantity_uom,
2314: l_old_line_tbl(I).order_quantity_uom)
2315: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2316: l_old_line_tbl(I).shipped_quantity)
2317: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
2318: l_old_line_tbl(I).schedule_ship_date)
2319: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2320: l_old_line_tbl(I).schedule_arrival_date)
2321: ) OR (

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

2315: AND OE_GLOBALS.Equal(l_line_tbl(I).shipped_quantity,
2316: l_old_line_tbl(I).shipped_quantity)
2317: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_ship_date,
2318: l_old_line_tbl(I).schedule_ship_date)
2319: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2320: l_old_line_tbl(I).schedule_arrival_date)
2321: ) OR (
2322: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
2323: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE

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

2318: l_old_line_tbl(I).schedule_ship_date)
2319: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2320: l_old_line_tbl(I).schedule_arrival_date)
2321: ) OR (
2322: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
2323: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE
2324: )
2325: OR ( l_line_tbl(I).first_ack_code is null AND
2326: l_header_rec.first_ack_code is not null )--bug7207426

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

2319: AND OE_GLOBALS.Equal(l_line_tbl(I).schedule_arrival_date,
2320: l_old_line_tbl(I).schedule_arrival_date)
2321: ) OR (
2322: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_INSERT OR
2323: l_old_line_tbl(I).operation = Oe_Globals.G_OPR_CREATE
2324: )
2325: OR ( l_line_tbl(I).first_ack_code is null AND
2326: l_header_rec.first_ack_code is not null )--bug7207426
2327: Then

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

2350: End Loop;
2351:
2352: If l_ack_req_flag = 'N' And
2353: l_header_rec_isnull = 'N' Then
2354: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
2355: l_old_header_rec.cust_po_number)
2356: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
2357: l_old_header_rec.ship_to_org_id)
2358: And OE_GLOBALS.Equal(l_header_rec.ordered_date,

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

2352: If l_ack_req_flag = 'N' And
2353: l_header_rec_isnull = 'N' Then
2354: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
2355: l_old_header_rec.cust_po_number)
2356: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
2357: l_old_header_rec.ship_to_org_id)
2358: And OE_GLOBALS.Equal(l_header_rec.ordered_date,
2359: l_old_header_rec.ordered_date)) Then
2360: l_ack_req_flag := 'H';

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

2354: If NOT (OE_GLOBALS.Equal(l_header_rec.cust_po_number,
2355: l_old_header_rec.cust_po_number)
2356: And OE_GLOBALS.Equal(l_header_rec.ship_to_org_id,
2357: l_old_header_rec.ship_to_org_id)
2358: And OE_GLOBALS.Equal(l_header_rec.ordered_date,
2359: l_old_header_rec.ordered_date)) Then
2360: l_ack_req_flag := 'H';
2361: End If;
2362: End If;