APPS.RCV_SHIPMENT_OBJECT_SV dependencies on RCV_HEADERS_INTERFACE

Line 99: UPDATE rcv_headers_interface

95:
96: rcv_shipment_header_sv.cancel_shipment(x_header_record);
97:
98: IF x_header_record.error_record.error_status IN('S', 'W') THEN
99: UPDATE rcv_headers_interface
100: SET processing_status_code = 'SUCCESS',
101: validation_flag = 'N',
102: receipt_header_id = x_header_record.header_record.receipt_header_id
103: WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line 124: UPDATE rcv_headers_interface

120: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
121: asn_debug.put_line('ASN could not be cancelled');
122: END IF;
123:
124: UPDATE rcv_headers_interface
125: SET processing_status_code = 'ERROR'
126: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
127:
128: UPDATE rcv_transactions_interface

Line 137: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

133: /* WDK - we've already inserted an error into po_interface_errors. isn't this redundant? */
134: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
135: rcv_error_pkg.set_error_message('RCV_ASN_NOT_ACCEPT', x_header_record.error_record.error_message);
136: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
137: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
138: 'SHIPMENT_NUM',
139: FALSE
140: );
141: END IF;

Line 281: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

277:
278: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
279: rcv_error_pkg.set_error_message('RCV_ASN_NOT_ACCEPT', x_header_record.error_record.error_message);
280: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
281: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
282: 'SHIPMENT_NUM',
283: FALSE
284: );
285:

Line 293: UPDATE rcv_headers_interface

289: DELETE FROM rcv_shipment_headers
290: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;
291: END IF;
292:
293: UPDATE rcv_headers_interface
294: SET processing_status_code = 'ERROR'
295: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
296:
297: UPDATE rcv_transactions_interface

Line 330: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

326:
327: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
328: rcv_error_pkg.set_error_message('RCV_ASN_ACCEPT_W_ERR', x_header_record.error_record.error_message);
329: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
330: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
331: 'SHIPMENT_NUM',
332: FALSE
333: );
334: END IF;

Line 348: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

344:
345: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
346: rcv_error_pkg.set_error_message('RCV_ASBN_NO_AUTO_INVOICE', x_header_record.error_record.error_message);
347: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
348: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
349: 'SHIPMENT_NUM',
350: FALSE
351: );
352:

Line 353: UPDATE rcv_headers_interface

349: 'SHIPMENT_NUM',
350: FALSE
351: );
352:
353: UPDATE rcv_headers_interface
354: SET invoice_status_code = 'RCV_ASBN_NO_AUTO_INVOICE',
355: processing_status_code = 'SUCCESS',
356: validation_flag = 'N',
357: receipt_header_id = x_header_record.header_record.receipt_header_id

Line 366: UPDATE rcv_headers_interface

362: UPDATE rcv_shipment_headers
363: SET invoice_status_code = 'RCV_ASBN_NO_AUTO_INVOICE'
364: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;
365: ELSE
366: UPDATE rcv_headers_interface
367: SET processing_status_code = 'SUCCESS',
368: validation_flag = 'N',
369: receipt_header_id = x_header_record.header_record.receipt_header_id
370: WHERE header_interface_id = x_header_record.header_record.header_interface_id;

Line 386: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

382:
383: x_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
384: rcv_error_pkg.set_error_message('RCV_ASN_NOT_ACCEPT', x_header_record.error_record.error_message);
385: rcv_error_pkg.set_token('SHIPMENT', x_header_record.header_record.shipment_num);
386: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
387: 'SHIPMENT_NUM',
388: FALSE
389: );
390:

Line 395: UPDATE rcv_headers_interface

391: IF (g_asn_debug = 'Y') THEN
392: asn_debug.put_line('The header has failed ' || TO_CHAR(x_header_record.header_record.header_interface_id));
393: END IF;
394:
395: UPDATE rcv_headers_interface
396: SET processing_status_code = 'ERROR'
397: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
398:
399: UPDATE rcv_transactions_interface