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_NORMALIZE_DATA_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 7: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

3:
4: g_fail_if_one_line_fails VARCHAR2(1) := nvl(fnd_profile.VALUE('RCV_FAIL_IF_LINE_FAILS'),'N'); /* lcm changes */
5:
6: PROCEDURE handle_error(
7: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
8: ) IS
9: BEGIN
10: p_rti_row.processing_status_code := 'ERROR';
11: p_rti_row.processing_request_id := g_request_id;

Line 15: UPDATE rcv_transactions_interface

11: p_rti_row.processing_request_id := g_request_id;
12:
13: IF (g_fail_all = 'Y') THEN
14: /* Update statement called in update_rti_error
15: UPDATE rcv_transactions_interface
16: SET processing_status_code = 'ERROR',
17: processing_request_id = g_request_id
18: WHERE header_interface_id = p_rti_row.header_interface_id
19: AND processing_status_code IN('PENDING', 'RUNNING')

Line 60: FROM rcv_transactions_interface

56: proc_code rcv_headers_interface.processing_status_code%TYPE;
57: BEGIN
58: SELECT count(*)
59: INTO x_rti_count
60: FROM rcv_transactions_interface
61: WHERE header_interface_id = p_rhi_row.header_interface_id
62: AND processing_status_code in ('PENDING','RUNNING')
63: AND transaction_status_code = 'PENDING';
64:

Line 94: UPDATE rcv_transactions_interface

90: WHEN OTHERS THEN
91: p_rhi_row.processing_status_code := 'ERROR';
92: p_rhi_row.processing_request_id := g_request_id;
93:
94: UPDATE rcv_transactions_interface
95: SET processing_status_code = 'ERROR',
96: processing_request_id = g_request_id
97: WHERE header_interface_id = p_rhi_row.header_interface_id
98: AND processing_status_code IN('PENDING', 'RUNNING')

Line 106: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

102: rcv_table_functions.update_rhi_row(p_rhi_row);
103: END prepare_pending_rhi;
104:
105: PROCEDURE prepare_pending_rti(
106: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
107: ) IS
108: BEGIN --this is the update block
109: BEGIN --this is the exception catching block
110: IF (p_rti_row.GROUP_ID IS NULL) THEN

Line 126: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

122: rcv_table_functions.update_rti_row(p_rti_row);
123: END prepare_pending_rti;
124:
125: PROCEDURE process_orphan_rti(
126: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
127: ) IS
128: BEGIN
129: rcv_error_pkg.set_error_message('RCV_IS_ORPHAN');
130: rcv_error_pkg.log_interface_error('PARENT_INTERFACE_TXN_ID');

Line 139: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

135: rcv_table_functions.update_rti_row(p_rti_row);
136: END;
137:
138: PROCEDURE process_row(
139: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE
140: ) IS
141: x_rhi_row rcv_headers_interface%ROWTYPE;
142:
143: -- Following 4 variables are added for BugFix 5078706

Line 250: from rcv_transactions_interface rti

246: need to set the non-lcm line to 'WLC_PENDING' as these should be processed together. */
247: IF (p_rti_row.lpn_group_id IS NOT NULL) THEN
248: select count(1)
249: into l_lpn_group_rti_count
250: from rcv_transactions_interface rti
251: where rti.group_id = p_rti_row.group_id
252: and rti.lpn_group_id is not null
253: and rti.lpn_group_id = p_rti_row.lpn_group_id
254: and rti.source_document_code = 'PO'

Line 269: from rcv_transactions_interface rti

265: AND g_fail_if_one_line_fails = 'Y'
266: AND l_lpn_group_rti_count = 0) THEN
267: select count(1)
268: into l_lpn_group_rti_count
269: from rcv_transactions_interface rti
270: where rti.group_id = x_rhi_row.group_id
271: and rti.header_interface_id = x_rhi_row.header_interface_id
272: and rti.source_document_code = 'PO'
273: and exists (select 'LCM Shipment' from po_line_locations_all pll

Line 331: UPDATE rcv_transactions_interface

327: l_msg_data VARCHAR2(100);
328: BEGIN
329: asn_debug.put_line('in explode_all_lpn');
330:
331: UPDATE rcv_transactions_interface
332: SET processing_status_code = 'RUNNING',
333: processing_request_id = g_request_id
334: WHERE processing_status_code = 'PENDING'
335: AND ( processing_request_id = g_request_id

Line 354: UPDATE rcv_transactions_interface

350: NULL,
351: g_request_id
352: );
353:
354: UPDATE rcv_transactions_interface
355: SET processing_status_code = 'PENDING'
356: WHERE processing_status_code = 'RUNNING'
357: AND processing_request_id = g_request_id;
358:

Line 372: UPDATE rcv_transactions_interface

368: l_msg_data VARCHAR2(100);
369: BEGIN
370: asn_debug.put_line('in explode_lpn');
371:
372: UPDATE rcv_transactions_interface
373: SET processing_status_code = 'RUNNING',
374: processing_request_id = g_request_id,
375: GROUP_ID = g_group_id
376: WHERE processing_status_code = 'PENDING'

Line 395: UPDATE rcv_transactions_interface

391: g_group_id,
392: g_request_id
393: );
394:
395: UPDATE rcv_transactions_interface
396: SET processing_status_code = 'PENDING'
397: WHERE processing_status_code = 'RUNNING'
398: AND processing_request_id = g_request_id
399: AND GROUP_ID = g_group_id;

Line 437: FROM rcv_transactions_interface

433: /* error out the orphans */
434: /* WDK - ADD INDEX ON PARENT_INTERFACE_TXN_ID */
435: CURSOR c_get_all_pending_rti_row IS
436: SELECT *
437: FROM rcv_transactions_interface
438: WHERE processing_status_code = 'PENDING'
439: AND processing_mode_code = g_processing_mode -- Bug 6311798
440: AND ( mo_global.check_access(org_id) = 'Y'
441: OR org_id IS NULL)

Line 448: FROM rcv_transactions_interface

444: ORDER BY GROUP_ID;
445:
446: CURSOR c_get_pending_rti_row IS
447: SELECT *
448: FROM rcv_transactions_interface
449: WHERE processing_status_code = 'PENDING'
450: AND processing_mode_code = g_processing_mode -- Bug 6311798
451: AND GROUP_ID = g_group_id
452: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id

Line 460: * rcv_transactions_interface table. In that case inner query will

456: /* of not processing 'orphan' children. these children need to be errored out */
457:
458: /** Bug: 5473673
459: * There is possibility to have more than 1 orphan record exist in
460: * rcv_transactions_interface table. In that case inner query will
461: * multiple rows, but we are having the condition "=" in
462: * the clause "START WITH". So, we have to replace the contition
463: * "=" with "IN"
464: */

Line 468: FROM rcv_transactions_interface

464: */
465:
466: CURSOR c_get_all_orphan_rti_row IS
467: SELECT *
468: FROM rcv_transactions_interface
469: WHERE processing_status_code = 'PENDING'
470: AND processing_mode_code = g_processing_mode -- Bug 6311798
471: AND ( mo_global.check_access(org_id) = 'Y'
472: OR org_id IS NULL)

Line 475: FROM rcv_transactions_interface

471: AND ( mo_global.check_access(org_id) = 'Y'
472: OR org_id IS NULL)
473: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id
474: START WITH interface_transaction_id IN (SELECT interface_transaction_id --Bug:5473673
475: FROM rcv_transactions_interface
476: WHERE parent_interface_txn_id NOT IN(SELECT interface_transaction_id
477: FROM rcv_transactions_interface));
478:
479: CURSOR c_get_orphan_rti_row IS

Line 477: FROM rcv_transactions_interface));

473: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id
474: START WITH interface_transaction_id IN (SELECT interface_transaction_id --Bug:5473673
475: FROM rcv_transactions_interface
476: WHERE parent_interface_txn_id NOT IN(SELECT interface_transaction_id
477: FROM rcv_transactions_interface));
478:
479: CURSOR c_get_orphan_rti_row IS
480: SELECT *
481: FROM rcv_transactions_interface

Line 481: FROM rcv_transactions_interface

477: FROM rcv_transactions_interface));
478:
479: CURSOR c_get_orphan_rti_row IS
480: SELECT *
481: FROM rcv_transactions_interface
482: WHERE processing_status_code = 'PENDING'
483: AND processing_mode_code = g_processing_mode -- Bug 6311798
484: AND GROUP_ID = g_group_id
485: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id

Line 487: FROM rcv_transactions_interface

483: AND processing_mode_code = g_processing_mode -- Bug 6311798
484: AND GROUP_ID = g_group_id
485: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id
486: START WITH interface_transaction_id IN (SELECT interface_transaction_id --Bug: 5473673
487: FROM rcv_transactions_interface
488: WHERE parent_interface_txn_id NOT IN(SELECT interface_transaction_id
489: FROM rcv_transactions_interface));
490:
491: BEGIN

Line 489: FROM rcv_transactions_interface));

485: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id
486: START WITH interface_transaction_id IN (SELECT interface_transaction_id --Bug: 5473673
487: FROM rcv_transactions_interface
488: WHERE parent_interface_txn_id NOT IN(SELECT interface_transaction_id
489: FROM rcv_transactions_interface));
490:
491: BEGIN
492: IF p_processing_mode = 'BATCH' THEN
493: IF p_group_id IS NULL