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_BULK_VALIDATE dependencies on OE_BULK_ORDER_PVT

Line 1612: -- INVCONV IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

1608: -- same as in OEXVIMSB.pls
1609:
1610:
1611: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1612: -- INVCONV IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
1613: -- PROCESS DUAL HVOP 1
1614: -- check for invalid item/warehouse combo INVCONV
1615:
1616:

Line 1861: -- INVCONV END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

1857: END IF;
1858: END IF;
1859:
1860:
1861: -- INVCONV END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
1862:
1863: -- QUOTING changes - validate trxn phase and version number if >= Pack J
1864: l_msg_text := l_msg_data||
1865: OE_ORDER_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE');

Line 2317: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id

2313: ,message_source_code ,language
2314: ,message_text, transaction_id
2315: )
2316: SELECT
2317: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2318: ,l.order_source_id ,l.orig_sys_document_ref
2319: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2320: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2321: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

Line 2360: OE_BULK_ORDER_PVT.G_REQUEST_ID ,'LINE' ,NULL,NULL ,NULL ,l.line_id

2356: ,message_source_code ,language
2357: ,message_text, transaction_id
2358: )
2359: SELECT
2360: OE_BULK_ORDER_PVT.G_REQUEST_ID ,'LINE' ,NULL,NULL ,NULL ,l.line_id
2361: ,l.order_source_id ,l.orig_sys_document_ref
2362: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2363: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2364: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

Line 2404: OE_BULK_ORDER_PVT.G_REQUEST_ID, 'LINE' ,NULL,NULL ,NULL ,l.line_id

2400: ,message_source_code ,language
2401: ,message_text, transaction_id
2402: )
2403: SELECT
2404: OE_BULK_ORDER_PVT.G_REQUEST_ID, 'LINE' ,NULL,NULL ,NULL ,l.line_id
2405: ,l.order_source_id ,l.orig_sys_document_ref
2406: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2407: ,NULL, sysdate, FND_GLOBAL.USER_ID ,sysdate
2408: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

Line 2448: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id

2444: ,message_source_code ,language
2445: ,message_text, transaction_id
2446: )
2447: SELECT
2448: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2449: ,l.order_source_id ,l.orig_sys_document_ref
2450: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2451: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate
2452: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

Line 2490: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id

2486: ,message_source_code ,language
2487: ,message_text, transaction_id
2488: )
2489: SELECT
2490: OE_BULK_ORDER_PVT.G_REQUEST_ID,'LINE' ,NULL,NULL ,NULL ,l.line_id
2491: ,l.order_source_id ,l.orig_sys_document_ref
2492: ,l.orig_sys_line_ref, l.orig_sys_shipment_ref, NULL
2493: ,NULL, sysdate, FND_GLOBAL.USER_ID , sysdate
2494: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID

Line 2579: AND a.request_id = oe_bulk_order_pvt.g_request_id);

2575: AND a.orig_sys_document_ref=t.orig_sys_document_ref
2576: AND a.order_source_id=t.order_source_id
2577: AND t.orig_sys_line_ref is not NULL
2578: AND nvl(t.lock_control, 0) = -99
2579: AND a.request_id = oe_bulk_order_pvt.g_request_id);
2580: EXCEPTION
2581: WHEN NO_DATA_FOUND THEN
2582: NULL;
2583: END;

Line 2623: AND b.request_id = oe_bulk_order_pvt.g_request_id);

2619: FROM oe_processing_msgs b
2620: WHERE b.original_sys_document_ref = a.orig_sys_document_ref
2621: AND b.original_sys_document_line_ref = a.orig_sys_line_ref
2622: AND b.order_source_id = a.order_source_id
2623: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2624:
2625: BEGIN
2626:
2627: UPDATE oe_lines_iface_all a

Line 2653: AND b.request_id = oe_bulk_order_pvt.g_request_id);

2649: from oe_processing_msgs b
2650: WHERE b.original_sys_document_ref = a.orig_sys_document_ref
2651: AND b.order_source_id = a.order_source_id
2652: and b.original_sys_document_line_ref is NULL
2653: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2654:
2655: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2656: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2657:

Line 2669: AND b.request_id = oe_bulk_order_pvt.g_request_id);

2665: FROM oe_lines_iface_all b
2666: WHERE b.orig_sys_document_ref = a.orig_sys_document_ref
2667: AND b.order_source_id = a.order_source_id
2668: AND nvl(error_flag, 'N') = 'N'
2669: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2670:
2671:
2672: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2673: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

Line 2688: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781

2684: (SELECT original_sys_document_line_ref
2685: FROM OE_PROCESSING_MSGS b
2686: WHERE b.original_sys_document_ref = a.ORIG_SYS_DOCUMENT_REF
2687: AND b.order_source_id = a.order_source_id
2688: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781
2689:
2690:
2691: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2692: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

Line 2705: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID);--Added for bug 6830039

2701: FROM OE_HEADERS_IFACE_ALL a, OE_PROCESSING_MSGS b
2702: WHERE a.batch_id = p_batch_id
2703: AND b.original_sys_document_ref = a.ORIG_SYS_DOCUMENT_REF
2704: AND b.order_source_id = a.order_source_id
2705: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID);--Added for bug 6830039
2706: EXCEPTION
2707: WHEN NO_DATA_FOUND THEN
2708: NULL;
2709: END;