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.CSI_DIAGNOSTICS_PKG dependencies on CSI_TXN_ERRORS

Line 11: FROM csi_txn_errors cte

7: CURSOR error_cur is
8: SELECT /*+ parallel(cte) */
9: cte.inv_material_transaction_id mtl_txn_id,
10: cte.transaction_error_id txn_error_id
11: FROM csi_txn_errors cte
12: WHERE cte.processed_flag in ('E', 'R')
13: AND cte.inv_material_transaction_id is not null;
14:
15: -- this CURSOR returns the serial numbers that are in the transaction

Line 1103: FROM csi_txn_errors

1099: IF all_txn.mtl_creation_date < fs_rec.mtl_txn_creation_date THEN
1100: BEGIN
1101: SELECT 'Y'
1102: INTO l_error_exists
1103: FROM csi_txn_errors
1104: WHERE processed_flag in ('E','R')
1105: AND inv_material_transaction_id = all_txn.mtl_txn_id
1106: AND rownum < 2;
1107: EXIT;

Line 3463: SELECT '1' FROM csi_txn_errors

3459: BEGIN
3460: SELECT 'Y' INTO l_txn_error_flag
3461: FROM sys.dual
3462: WHERE EXISTS (
3463: SELECT '1' FROM csi_txn_errors
3464: WHERE inv_material_transaction_id = wip_txn_rec.mtl_txn_id
3465: AND processed_flag in ('E', 'R'));
3466: l_in_error := true;
3467: EXCEPTION

Line 3612: SELECT '1' FROM csi_txn_errors

3608: IF all_txn_rec.mtl_action_id in (2,3,28) THEN
3609: SELECT 'Y' INTO l_txn_error_flag
3610: FROM sys.dual
3611: WHERE EXISTS (
3612: SELECT '1' FROM csi_txn_errors
3613: WHERE (inv_material_transaction_id = all_txn_rec.mtl_txn_id
3614: OR
3615: inv_material_transaction_id = all_txn_rec.mtl_xfer_txn_id)
3616: AND processed_flag in ('E', 'R'));

Line 3621: SELECT '1' FROM csi_txn_errors

3617: ELSE
3618: SELECT 'Y' INTO l_txn_error_flag
3619: FROM sys.dual
3620: WHERE EXISTS (
3621: SELECT '1' FROM csi_txn_errors
3622: WHERE inv_material_transaction_id = all_txn_rec.mtl_txn_id
3623: AND processed_flag in ('E', 'R'));
3624: END IF;
3625: l_in_error := true;

Line 3937: log(' bad csi_txn_errors.mtl_txn_id : '||l_mtl_txn_id_tab(ind));

3933:
3934:
3935: EXCEPTION
3936: WHEN skip_error THEN
3937: log(' bad csi_txn_errors.mtl_txn_id : '||l_mtl_txn_id_tab(ind));
3938: END;
3939: END LOOP;
3940:
3941: EXIT when error_cur%NOTFOUND;

Line 3962: FROM csi_txn_errors cte

3958:
3959: CURSOR single_error_cur(pc_mtl_txn_id IN number) is
3960: SELECT cte.inv_material_transaction_id mtl_txn_id,
3961: cte.transaction_error_id txn_error_id
3962: FROM csi_txn_errors cte
3963: WHERE cte.inv_material_transaction_id = pc_mtl_txn_id
3964: AND cte.processed_flag in ('E', 'R');
3965:
3966: TYPE NumTabType is varray(10000) of number;

Line 4116: UPDATE csi_txn_errors

4112: END;
4113:
4114: IF l_err_txn_date < l_freeze_date THEN
4115:
4116: UPDATE csi_txn_errors
4117: SET processed_flag = 'D',
4118: error_text = 'Transaction prior to freeze_date in install parameter',
4119: last_update_login = fnd_global.login_id,
4120: last_update_date = sysdate,

Line 4273: FROM csi_txn_errors cte

4269: SELECT cte.transaction_type_id,
4270: cte.error_text
4271: INTO l_csi_txn_type_id,
4272: l_error
4273: FROM csi_txn_errors cte
4274: WHERE (cte.inv_material_transaction_id = txn_rec.mtl_txn_id
4275: OR
4276: cte.inv_material_transaction_id = txn_rec.mtl_xfer_txn_id)
4277: AND cte.processed_flag in ('E', 'R')

Line 4284: FROM csi_txn_errors cte

4280: SELECT cte.transaction_type_id,
4281: cte.error_text
4282: INTO l_csi_txn_type_id,
4283: l_error
4284: FROM csi_txn_errors cte
4285: WHERE cte.inv_material_transaction_id = txn_rec.mtl_txn_id
4286: AND cte.processed_flag in ('E', 'R')
4287: AND rownum = 1;
4288: END IF;

Line 4509: UPDATE csi_txn_errors

4505: END IF;
4506: END IF;
4507:
4508: IF l_knock_err_txn THEN
4509: UPDATE csi_txn_errors
4510: SET processed_flag = 'D',
4511: error_text = 'Serial control is now inappropriate for this txn. Knocking this',
4512: last_update_date = sysdate,
4513: last_update_login = fnd_global.login_id,

Line 4550: log(' bad csi_txn_errors.mtl_txn_id : '||l_mtl_txn_id_tab(ind));

4546: END IF;
4547:
4548: EXCEPTION
4549: WHEN skip_error THEN
4550: log(' bad csi_txn_errors.mtl_txn_id : '||l_mtl_txn_id_tab(ind));
4551: END;
4552: END LOOP; -- error txn loop
4553:
4554: IF p_single_error_flag = 'Y' THEN

Line 6021: UPDATE csi_txn_errors

6017:
6018: BEGIN
6019: FOR knock_rec in knock_cur
6020: LOOP
6021: UPDATE csi_txn_errors
6022: SET processed_flag = 'D',
6023: error_text = 'A future transaction is processed. So not processing this.',
6024: last_update_date = sysdate,
6025: last_update_login = fnd_global.login_id,

Line 6747: UPDATE csi_txn_errors

6743: SET process_flag = 'P',
6744: temporary_message = 'Sales order issue instance staged.'
6745: WHERE mtl_txn_id = txn_rec.mtl_txn_id;
6746:
6747: UPDATE csi_txn_errors
6748: SET processed_flag = 'R',
6749: last_update_date = sysdate,
6750: last_update_login = fnd_global.login_id,
6751: last_updated_by = fnd_global.user_id

Line 8603: UPDATE csi_txn_errors

8599: UPDATE csi_diagnostics_temp
8600: SET process_flag = 'P'
8601: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;
8602:
8603: UPDATE csi_txn_errors
8604: SET processed_flag = 'R',
8605: last_update_date = sysdate,
8606: last_update_login = fnd_global.login_id,
8607: last_updated_by = fnd_global.user_id

Line 8686: update csi_txn_errors

8682: END LOOP;
8683:
8684: FOR reprocess_rec in reprocess_cur
8685: LOOP
8686: update csi_txn_errors
8687: SET processed_flag = 'R',
8688: last_update_date = sysdate,
8689: last_update_login = fnd_global.login_id,
8690: last_updated_by = fnd_global.user_id

Line 9032: also check if there is any errors in csi_txn_errors. if found then skip

9028:
9029: /* loop thru all the material transactions after freeze date and check if
9030: there is any pending in xnp_msgs.
9031:
9032: also check if there is any errors in csi_txn_errors. if found then skip
9033: the serial.
9034: */
9035:
9036: l_latest_txn := TRUE;

Line 9103: FROM csi_txn_errors

9099: SELECT 'Y' INTO l_pending_err_found
9100: FROM sys.dual
9101: WHERE exists (
9102: SELECT '1'
9103: FROM csi_txn_errors
9104: WHERE (inv_material_transaction_id = all_txn_rec.mtl_txn_id
9105: OR
9106: inv_material_transaction_id = all_txn_rec.mtl_txn_id)
9107: AND processed_flag in ('E', 'R'));

Line 9115: FROM csi_txn_errors

9111: SELECT 'Y' INTO l_pending_err_found
9112: FROM sys.dual
9113: WHERE exists (
9114: SELECT '1'
9115: FROM csi_txn_errors
9116: WHERE inv_material_transaction_id = all_txn_rec.mtl_txn_id
9117: AND processed_flag in ('E', 'R'));
9118:
9119: END IF;

Line 9120: l_skip_error := ' Pending Error in CSI_TXN_ERRORS for MTL_TXN_ID: '||

9116: WHERE inv_material_transaction_id = all_txn_rec.mtl_txn_id
9117: AND processed_flag in ('E', 'R'));
9118:
9119: END IF;
9120: l_skip_error := ' Pending Error in CSI_TXN_ERRORS for MTL_TXN_ID: '||
9121: all_txn_rec.mtl_txn_id;
9122: RAISE skip_serial;
9123:
9124: EXCEPTION

Line 11249: from CSI_TXN_ERRORS cii,

11245: --
11246: CURSOR CSI_MAT_ERROR IS
11247: select cii.transaction_error_id,
11248: mmt.inventory_item_id,mmt.organization_id
11249: from CSI_TXN_ERRORS cii,
11250: MTL_MATERIAL_TRANSACTIONS mmt
11251: where cii.processed_flag in ('E', 'R')
11252: and cii.inv_material_transaction_id is not null
11253: and mmt.transaction_id = cii.inv_material_transaction_id;

Line 11257: from CSI_TXN_ERRORS cii

11253: and mmt.transaction_id = cii.inv_material_transaction_id;
11254: --
11255: CURSOR CSI_NON_MAT_ERROR IS
11256: select transaction_error_id,source_id
11257: from CSI_TXN_ERRORS cii
11258: where cii.inv_material_transaction_id is null
11259: and cii.source_id is not null
11260: and cii.processed_flag in ('E', 'R');
11261: --

Line 11578: UPDATE csi_txn_errors

11574: --
11575: -- Perform a Bulk Update
11576: IF l_upd_txn_tbl.count > 0 THEN
11577: FORALL i in l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST
11578: UPDATE csi_txn_errors
11579: SET processed_flag = 'D',
11580: error_text = 'COMMS_NL_TRACKABLE_FLAG got switched off',
11581: last_update_date = sysdate
11582: WHERE transaction_error_id = l_upd_txn_tbl(i);

Line 11641: UPDATE CSI_TXN_ERRORS

11637: CLOSE CSI_NON_MAT_ERROR;
11638: -- Perform a Bulk Update
11639: IF l_upd_txn_tbl.count > 0 THEN
11640: FORALL i in l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST
11641: UPDATE CSI_TXN_ERRORS
11642: set processed_flag = 'D',
11643: error_text = 'COMMS_NL_TRACKABLE_FLAG got switched off',
11644: last_update_date = sysdate
11645: where transaction_error_id = l_upd_txn_tbl(i);

Line 12174: from csi_txn_errors cii

12170: PROCEDURE Create_or_Update_Shipping_Inst IS
12171: CURSOR CSI_CUR IS
12172: select cii.transaction_error_id,cii.inv_material_transaction_id,
12173: null,null,null,null,null,null
12174: from csi_txn_errors cii
12175: where cii.processed_flag in ('E', 'R')
12176: and cii.inv_material_transaction_id is not null;
12177: --
12178: CURSOR LOT_CUR(p_txn_id in number) IS

Line 12345: Update CSI_TXN_ERRORS

12341: Raise Process_next;
12342: End;
12343: --
12344: IF NVL(v_nl_trackable,'N') <> 'Y' THEN
12345: Update CSI_TXN_ERRORS
12346: set processed_flag = 'D'
12347: ,error_text = 'COMMS_NL_TRACKABLE_FLAG got switched off'
12348: ,last_update_date = sysdate
12349: where transaction_error_id = txn_error_id_mig(i);

Line 12453: Update CSI_TXN_ERRORS

12449: ,-1
12450: ,1
12451: );
12452: --
12453: Update CSI_TXN_ERRORS
12454: set processed_flag = 'R',
12455: last_update_date = sysdate
12456: where transaction_error_id = txn_error_id_mig(i);
12457: --

Line 12935: Update CSI_TXN_ERRORS

12931: ,-1
12932: ,1
12933: );
12934: --
12935: Update CSI_TXN_ERRORS
12936: set processed_flag = 'R',
12937: last_update_date = sysdate
12938: where transaction_error_id = txn_error_id_mig(i);
12939: --

Line 13331: Update csi_txn_errors

13327: Raise;
13328: End;
13329: END LOOP;
13330: END IF; -- Lot control check
13331: Update csi_txn_errors
13332: set processed_flag = 'R',
13333: last_update_date = sysdate
13334: where transaction_error_id = txn_error_id_mig(i);
13335: --

Line 13761: -- Check if there are any errors in CSI_TXN_ERRORS

13757: IF NVL(v_nl_trackable,'N') <> 'Y' THEN
13758: Raise Process_next;
13759: END IF; -- nl_trackable check
13760: --
13761: -- Check if there are any errors in CSI_TXN_ERRORS
13762: l_error_count := 0;
13763: Begin
13764: select count(*)
13765: into l_error_count

Line 13766: from CSI_TXN_ERRORS cii,

13762: l_error_count := 0;
13763: Begin
13764: select count(*)
13765: into l_error_count
13766: from CSI_TXN_ERRORS cii,
13767: MTL_MATERIAL_TRANSACTIONS mmt
13768: where cii.inv_material_transaction_id is not null
13769: and cii.inv_material_transaction_id = mmt.transaction_id
13770: and cii.processed_flag in ('E','R')

Line 14406: FROM csi_txn_errors cii,

14402: mmt.organization_id,
14403: mmt.transaction_action_id,
14404: mmt.transaction_source_type_id,
14405: mmt.transaction_id
14406: FROM csi_txn_errors cii,
14407: mtl_material_transactions mmt
14408: WHERE cii.processed_flag in ('E', 'R')
14409: AND cii.inv_material_transaction_id is not null
14410: AND mmt.transaction_id = cii.inv_material_transaction_id;

Line 14532: UPDATE csi_txn_errors

14528: CLOSE csi_cur;
14529: --
14530: IF l_upd_txn_tbl.count > 0 THEN
14531: FORALL i in l_upd_txn_tbl.FIRST .. l_upd_txn_tbl.LAST
14532: UPDATE csi_txn_errors
14533: SET processed_flag = 'D',
14534: error_text = 'Data fix done - mark_error_transactions',
14535: last_update_date = sysdate
14536: WHERE transaction_error_id = l_upd_txn_tbl(i);

Line 14626: from CSI_TXN_ERRORS cii,

14622: l_error_count := 0;
14623: Begin
14624: select count(*)
14625: into l_error_count
14626: from CSI_TXN_ERRORS cii,
14627: MTL_MATERIAL_TRANSACTIONS mmt
14628: where cii.inv_material_transaction_id is not null
14629: and cii.inv_material_transaction_id = mmt.transaction_id
14630: and cii.processed_flag in ('E','R')

Line 14995: FROM csi_txn_errors cii,

14991: mmt.organization_id,
14992: mmt.transaction_quantity,
14993: mmt.trx_source_line_id,
14994: mmt.revision
14995: FROM csi_txn_errors cii,
14996: mtl_material_transactions mmt
14997: WHERE cii.processed_flag = 'E'
14998: AND cii.inv_material_transaction_id is not null
14999: AND mmt.transaction_id = cii.inv_material_transaction_id

Line 15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca

15393: oel.sold_to_org_id owner_acct,
15394: oel.ordered_quantity ordered_qty,
15395: oel.order_quantity_uom ordered_uom,
15396: hca.party_id party_id
15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15398: WHERE cte.processed_flag in ('E', 'R')
15399: AND cte.transaction_type_id = 53
15400: AND cte.inv_material_transaction_id = mmt.transaction_id
15401: AND msi.inventory_item_id = mmt.inventory_item_id

Line 15603: UPDATE csi_txn_errors

15599:
15600: END IF;
15601:
15602: IF l_processed_flag = 'Y' THEN
15603: UPDATE csi_txn_errors
15604: SET processed_flag = 'R'
15605: WHERE transaction_error_id = l_rma_txn_tbl(i).Txn_error_id;
15606:
15607: l_instance_tbl(j).quantity:=l_instance_tbl(j).quantity-l_rma_txn_tbl(i).ordered_qty;

Line 15658: FROM csi_txn_errors

15654:
15655: CURSOR err_cur IS
15656: SELECT transaction_error_id,
15657: inv_material_transaction_id
15658: FROM csi_txn_errors
15659: WHERE processed_flag in ('E', 'R')
15660: AND inv_material_transaction_id is not null
15661: AND (source_type is null OR transaction_type_id is null);
15662:

Line 15692: UPDATE csi_txn_errors

15688: WHERE exists (
15689: SELECT 'X' FROM csi_transactions
15690: WHERE inv_material_transaction_id = err_rec.inv_material_transaction_id);
15691:
15692: UPDATE csi_txn_errors
15693: SET processed_flag = 'D'
15694: WHERE transaction_error_id = err_rec.transaction_error_id;
15695:
15696: EXCEPTION

Line 15728: UPDATE csi_txn_errors

15724: p_release => l_release,
15725: x_source_type => l_source_type,
15726: x_csi_txn_type_id => l_csi_txn_type_id);
15727:
15728: UPDATE csi_txn_errors
15729: SET source_type = l_source_type,
15730: transaction_type_id = l_csi_txn_type_id
15731: WHERE transaction_error_id = err_rec.transaction_error_id;
15732:

Line 16300: csi_txn_errors cte

16296: cdt.mtl_txn_id,
16297: cdt.mtl_txn_date,
16298: cte.error_text
16299: FROM csi_diagnostics_temp cdt,
16300: csi_txn_errors cte
16301: WHERE cdt.inventory_item_id = p_item_id
16302: AND cdt.serial_number = p_serial_number
16303: AND cte.inv_material_transaction_id = cdt.mtl_txn_id
16304: AND cte.processed_flag in ('E', 'R')