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

Line 273: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

269: AND trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
270: trunc(nvl(end_date_active, sysdate));
271:
272: -- Check if the ASO and EC are installed products
273: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
274: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
275: END IF;
276:
277: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

Line 274: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

270: trunc(nvl(end_date_active, sysdate));
271:
272: -- Check if the ASO and EC are installed products
273: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
274: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
275: END IF;
276:
277: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
278: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

Line 277: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

273: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
274: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
275: END IF;
276:
277: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
278: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
279: END IF;
280:
281: -- We need to call the Query_Rows only if Pricing is called and ASO/EC are

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

274: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
275: END IF;
276:
277: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
278: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
279: END IF;
280:
281: -- We need to call the Query_Rows only if Pricing is called and ASO/EC are
282: -- Installed products.

Line 285: (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

281: -- We need to call the Query_Rows only if Pricing is called and ASO/EC are
282: -- Installed products.
283:
284: IF ( (NVL(l_active_phase_count,0) > 0) OR
285: (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
286: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
287: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
288: THEN
289: -- Set up the lines table of records

Line 286: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR

282: -- Installed products.
283:
284: IF ( (NVL(l_active_phase_count,0) > 0) OR
285: (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
286: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
287: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
288: THEN
289: -- Set up the lines table of records
290:

Line 372: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;

368: x_freeze_inc_items := TRUE;
369: END IF;
370:
371: l_return_status := FND_API.G_RET_STS_SUCCESS;
372: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
373: l_line_tbl(l_index).booked_flag := 'Y';
374: l_line_tbl(l_index).flow_status_code := 'BOOKED';
375: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;
376: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 418: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

414:
415: IF l_line_tbl(l_index).item_type_code not in ('INCLUDED', 'CONFIG') THEN
416:
417: OE_delayed_requests_Pvt.log_request(
418: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
419: p_entity_id => l_line_tbl(l_index).line_id,
420: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
421: p_requesting_entity_id => l_line_tbl(l_index).line_id,
422: p_request_type => OE_GLOBALS.g_tax_line,

Line 420: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

416:
417: OE_delayed_requests_Pvt.log_request(
418: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
419: p_entity_id => l_line_tbl(l_index).line_id,
420: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
421: p_requesting_entity_id => l_line_tbl(l_index).line_id,
422: p_request_type => OE_GLOBALS.g_tax_line,
423: x_return_status => l_return_status);
424:

Line 422: p_request_type => OE_GLOBALS.g_tax_line,

418: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
419: p_entity_id => l_line_tbl(l_index).line_id,
420: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
421: p_requesting_entity_id => l_line_tbl(l_index).line_id,
422: p_request_type => OE_GLOBALS.g_tax_line,
423: x_return_status => l_return_status);
424:
425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;

Line 467: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

463: IF l_hdr_chg_count > 0 THEN
464:
465:
466: OE_delayed_requests_Pvt.log_request(
467: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
468: p_entity_id => l_header_rec.header_id,
469: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
470: p_requesting_entity_id => l_header_rec.header_id,
471: p_request_type => OE_GLOBALS.g_tax_line,

Line 469: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

465:
466: OE_delayed_requests_Pvt.log_request(
467: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
468: p_entity_id => l_header_rec.header_id,
469: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
470: p_requesting_entity_id => l_header_rec.header_id,
471: p_request_type => OE_GLOBALS.g_tax_line,
472: p_param1 => NULL,
473: x_return_status => x_return_status);

Line 471: p_request_type => OE_GLOBALS.g_tax_line,

467: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
468: p_entity_id => l_header_rec.header_id,
469: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
470: p_requesting_entity_id => l_header_rec.header_id,
471: p_request_type => OE_GLOBALS.g_tax_line,
472: p_param1 => NULL,
473: x_return_status => x_return_status);
474:
475: END IF;

Line 524: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

520:
521: --OIP SUN ER changes
522: IF (NVL(FND_PROFILE.VALUE('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'),'N') ='Y') THEN
523: OE_delayed_requests_Pvt.log_request
524: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
525: p_entity_id => l_header_rec.header_id,
526: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
527: p_requesting_entity_id => l_header_rec.header_id,
528: p_request_type => 'OE_ORDER_BOOKED', --OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,

Line 526: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

522: IF (NVL(FND_PROFILE.VALUE('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'),'N') ='Y') THEN
523: OE_delayed_requests_Pvt.log_request
524: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
525: p_entity_id => l_header_rec.header_id,
526: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
527: p_requesting_entity_id => l_header_rec.header_id,
528: p_request_type => 'OE_ORDER_BOOKED', --OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
529: x_return_status => l_return_status);
530:

Line 528: p_request_type => 'OE_ORDER_BOOKED', --OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,

524: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
525: p_entity_id => l_header_rec.header_id,
526: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
527: p_requesting_entity_id => l_header_rec.header_id,
528: p_request_type => 'OE_ORDER_BOOKED', --OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP,
529: x_return_status => l_return_status);
530:
531: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;

Line 563: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

559: -- renga - change for tax calculation event enhancement
560:
561: l_notify := FALSE;
562:
563: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
564: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
565: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
566: THEN
567: l_notify := TRUE;

Line 564: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR

560:
561: l_notify := FALSE;
562:
563: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
564: (OE_GLOBALS.G_EC_INSTALLED = 'Y' ) OR
565: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
566: THEN
567: l_notify := TRUE;
568:

Line 592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;

588: -- loop to populate the operation in the global table
589: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.FIRST;
590:
591: while l_in_loop_index is not null loop
592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
593: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
594: END LOOP;
595:
596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);

Line 751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;

747: , x_index => l_notify_index
748: , x_return_status => l_return_status);
749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:
755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);

Line 1253: OE_GLOBALS.G_IIFM_BOOKING )

1249:
1250: -- Freeze included items, if any, for this order
1251: IF (l_freeze_inc_items
1252: AND FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') =
1253: OE_GLOBALS.G_IIFM_BOOKING )
1254: THEN
1255: -- Added debug for bug 13435459
1256: IF l_debug_level > 0 THEN
1257: oe_debug_pub.add( 'BEFORE FREEZE INC', 0.5) ;

Line 1364: IF NOT OE_GLOBALS.G_ORDER_IMPORT_CALL THEN -- Bug 7367433

1360:
1361: -- From Order Import we will make a call to Verfify Payment, only after committing the data.
1362: -- The call to Verify Payment from Booking code is suppressed for Order Import flow.
1363: -- This change is only for Verify Payment call that is triggered as part of Booking.
1364: IF NOT OE_GLOBALS.G_ORDER_IMPORT_CALL THEN -- Bug 7367433
1365:
1366: -- Payment Verification is done at the end of booking
1367: -- because it is an expensive operation.
1368:

Line 1370: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN

1366: -- Payment Verification is done at the end of booking
1367: -- because it is an expensive operation.
1368:
1369: --R12 CVV2
1370: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1371: -- Added debug for bug 13435459
1372: IF l_debug_level > 0 THEN
1373: oe_debug_pub.add( 'BEFORE VERIFY PAYMENT', 0.5) ;
1374: END IF;

Line 1390: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN

1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388: END IF;
1389: ELSE
1390: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1391: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';
1392: END IF;
1393: END IF; -- Bug 7367433
1394:

Line 1391: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';

1387: END IF;
1388: END IF;
1389: ELSE
1390: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1391: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';
1392: END IF;
1393: END IF; -- Bug 7367433
1394:
1395: OE_MSG_PUB.Count_And_Get

Line 1795: ,p_header_id_list IN OE_GLOBALS.Selected_Record_Tbl

1791: ---------------------------------------------------------------------
1792: PROCEDURE Book_Multiple_Orders
1793: (p_api_version_number IN NUMBER
1794: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1795: ,p_header_id_list IN OE_GLOBALS.Selected_Record_Tbl
1796: ,p_header_count IN NUMBER
1797: ,x_error_count OUT NOCOPY NUMBER
1798:
1799: ,x_return_status OUT NOCOPY VARCHAR2