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.RCV_ROI_PREPROCESSOR dependencies on RCV_HEADERS_INTERFACE

Line 161: FROM rcv_headers_interface rsh,

157: DECODE(NVL(poll.outsourced_assembly, get_oe_osa_flag(rti.oe_order_line_id)),
158: 1, 1,
159: NULL
160: ) osa_flag
161: FROM rcv_headers_interface rsh,
162: rcv_transactions_interface rti,
163: po_line_locations_all poll
164: WHERE rsh.asn_type = 'ASBN'
165: AND rsh.header_interface_id = rti.header_interface_id

Line 177: FROM rcv_headers_interface

173: * * records in RHI*/
174: /* Moved this cursor as well as its for loop to the rcv_dcp_pvt package */
175: /* CURSOR headers_cur_dcp(x_request_id NUMBER, x_group_id NUMBER) IS
176: SELECT *
177: FROM rcv_headers_interface
178: WHERE NVL(asn_type, 'STD') IN('ASN', 'ASBN', 'STD', 'WC')
179: AND processing_status_code IN('RUNNING', 'SUCCESS','ERROR','PENDING')
180: AND(NVL(validation_flag, 'N') = 'Y'
181: OR processing_status_code = 'SUCCESS') -- include success row for multi-line asn

Line 298: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

294: FOR bad_shikyu IN get_bad_asbn_shikyu LOOP --Shikyu project
295: BEGIN
296: rcv_error_pkg.set_error_message('RCV_BAD_ASBN_SHIKYU');
297: rcv_error_pkg.set_token('HEADER_INTERFACE_ID', bad_shikyu.header_interface_id);
298: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
299: 'HEADER_INTERFACE_ID',
300: x_group_id,
301: bad_shikyu.header_interface_id,
302: NULL,

Line 306: UPDATE rcv_headers_interface

302: NULL,
303: FALSE
304: );
305:
306: UPDATE rcv_headers_interface
307: SET processing_status_code = 'ERROR'
308: WHERE header_interface_id = bad_shikyu.header_interface_id;
309:
310: UPDATE rcv_transactions_interface

Line 587: UPDATE rcv_headers_interface

583: -- header errored out
584: -- 1) update rhi
585: -- x_header_record.header_record might still be null in this case
586: -- if no row found in RHI, a no_data_found exception will be raised
587: UPDATE rcv_headers_interface
588: SET processing_status_code = 'ERROR'
589: WHERE header_interface_id = x_cascaded_table(n).header_interface_id;
590:
591: x_header_record.header_record.processing_status_code := 'ERROR';

Line 594: /* Bug 4344351: Log a message indicating an error in RCV_HEADERS_INTERFACE table.*/

590:
591: x_header_record.header_record.processing_status_code := 'ERROR';
592: x_header_record.error_record.error_status := 'E';
593:
594: /* Bug 4344351: Log a message indicating an error in RCV_HEADERS_INTERFACE table.*/
595: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE','',FALSE);
596:
597: -- 2) update rti
598: IF (g_asn_debug = 'Y') THEN

Line 595: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE','',FALSE);

591: x_header_record.header_record.processing_status_code := 'ERROR';
592: x_header_record.error_record.error_status := 'E';
593:
594: /* Bug 4344351: Log a message indicating an error in RCV_HEADERS_INTERFACE table.*/
595: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE','',FALSE);
596:
597: -- 2) update rti
598: IF (g_asn_debug = 'Y') THEN
599: asn_debug.put_line('update_rti_error after rhi error ');

Line 622: UPDATE rcv_headers_interface

618:
619: x_cascaded_table(n).error_status := 'P';
620: x_cascaded_table(n).processing_status_code := 'PENDING';
621: ELSE -- }{ the header was processed successfully
622: UPDATE rcv_headers_interface
623: SET processing_status_code = 'SUCCESS',
624: validation_flag = 'N',
625: receipt_header_id = x_header_record.header_record.receipt_header_id
626: WHERE header_interface_id = x_header_record.header_record.header_interface_id

Line 782: from rcv_headers_interface

778: UPDATE rcv_shipment_headers
779: SET asn_status = null
780: WHERE (shipment_header_id = x_cascaded_table(n).shipment_header_id
781: OR shipment_num = (select shipment_num
782: from rcv_headers_interface
783: where header_interface_id =
784: x_cascaded_table(n).header_interface_id)
785: OR shipment_header_id = (select receipt_header_id
786: from rcv_headers_interface

Line 786: from rcv_headers_interface

782: from rcv_headers_interface
783: where header_interface_id =
784: x_cascaded_table(n).header_interface_id)
785: OR shipment_header_id = (select receipt_header_id
786: from rcv_headers_interface
787: where header_interface_id =
788: x_cascaded_table(n).header_interface_id))
789: AND asn_status = 'NEW_SHIP';
790:

Line 900: UPDATE rcv_headers_interface

896: IF (g_asn_debug = 'Y') THEN
897: asn_debug.put_line('error out rhi for a fail all ASN transaction ');
898: END IF;
899:
900: UPDATE rcv_headers_interface
901: SET processing_status_code = 'ERROR',
902: validation_flag = 'Y',
903: receipt_header_id = NULL
904: WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line 926: UPDATE rcv_headers_interface rhi

922: asn_debug.put_line('update rhi for non fail-all-ASN transaction ');
923: END IF;
924:
925: IF x_cascaded_table(n).header_interface_id IS NOT NULL THEN --{
926: UPDATE rcv_headers_interface rhi
927: SET rhi.processing_status_code = 'ERROR',
928: rhi.validation_flag = 'Y',
929: rhi.receipt_header_id = NULL
930: WHERE header_interface_id = x_cascaded_table(n).header_interface_id

Line 955: rcv_headers_interface rhi

951: WHERE shipment_header_id = l_ship_header_id
952: AND asn_status = 'NEW_SHIP'
953: AND NOT EXISTS ( SELECT rti.interface_transaction_id
954: FROM rcv_transactions_interface rti,
955: rcv_headers_interface rhi
956: WHERE rhi.header_interface_id = rti.header_interface_id
957: AND rti.processing_status_code in ('RUNNING', 'PENDING')
958: AND rhi.receipt_header_id = l_ship_header_id );
959:

Line 990: from rcv_headers_interface

986: begin
987: select 1
988: into l_count
989: from dual where exists (select 'Errored RHI'
990: from rcv_headers_interface
991: where asn_type in ('ASN','ASBN')
992: and processing_status_code = 'ERROR'
993: and header_interface_id = x_header_record.header_record.header_interface_id);
994: exception

Line 1542: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,

1538:
1539: PROCEDURE process_line(
1540: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1541: n IN OUT NOCOPY BINARY_INTEGER,
1542: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
1543: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1544: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1545: ) IS
1546: x_parent_id NUMBER;

Line 1543: x_asn_type IN rcv_headers_interface.asn_type%TYPE,

1539: PROCEDURE process_line(
1540: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1541: n IN OUT NOCOPY BINARY_INTEGER,
1542: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
1543: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1544: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1545: ) IS
1546: x_parent_id NUMBER;
1547: x_progress VARCHAR2(3);

Line 2080: UPDATE rcv_headers_interface

2076: IF (g_asn_debug = 'Y') THEN
2077: asn_debug.put_line('update all rti rows to error');
2078: END IF;
2079:
2080: UPDATE rcv_headers_interface
2081: SET processing_status_code = 'ERROR'
2082: WHERE GROUP_ID = p_group_id;
2083:
2084: UPDATE rcv_transactions_interface