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 12169: from csi_txn_errors cii

12165: PROCEDURE Create_or_Update_Shipping_Inst IS
12166: CURSOR CSI_CUR IS
12167: select cii.transaction_error_id,cii.inv_material_transaction_id,
12168: null,null,null,null,null,null
12169: from csi_txn_errors cii
12170: where cii.processed_flag in ('E', 'R')
12171: and cii.inv_material_transaction_id is not null;
12172: --
12173: CURSOR LOT_CUR(p_txn_id in number) IS

Line 12340: Update CSI_TXN_ERRORS

12336: Raise Process_next;
12337: End;
12338: --
12339: IF NVL(v_nl_trackable,'N') <> 'Y' THEN
12340: Update CSI_TXN_ERRORS
12341: set processed_flag = 'D'
12342: ,error_text = 'COMMS_NL_TRACKABLE_FLAG got switched off'
12343: ,last_update_date = sysdate
12344: where transaction_error_id = txn_error_id_mig(i);

Line 12448: Update CSI_TXN_ERRORS

12444: ,-1
12445: ,1
12446: );
12447: --
12448: Update CSI_TXN_ERRORS
12449: set processed_flag = 'R',
12450: last_update_date = sysdate
12451: where transaction_error_id = txn_error_id_mig(i);
12452: --

Line 12930: Update CSI_TXN_ERRORS

12926: ,-1
12927: ,1
12928: );
12929: --
12930: Update CSI_TXN_ERRORS
12931: set processed_flag = 'R',
12932: last_update_date = sysdate
12933: where transaction_error_id = txn_error_id_mig(i);
12934: --

Line 13326: Update csi_txn_errors

13322: Raise;
13323: End;
13324: END LOOP;
13325: END IF; -- Lot control check
13326: Update csi_txn_errors
13327: set processed_flag = 'R',
13328: last_update_date = sysdate
13329: where transaction_error_id = txn_error_id_mig(i);
13330: --

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

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

Line 13761: from CSI_TXN_ERRORS cii,

13757: l_error_count := 0;
13758: Begin
13759: select count(*)
13760: into l_error_count
13761: from CSI_TXN_ERRORS cii,
13762: MTL_MATERIAL_TRANSACTIONS mmt
13763: where cii.inv_material_transaction_id is not null
13764: and cii.inv_material_transaction_id = mmt.transaction_id
13765: and cii.processed_flag in ('E','R')

Line 14401: FROM csi_txn_errors cii,

14397: mmt.organization_id,
14398: mmt.transaction_action_id,
14399: mmt.transaction_source_type_id,
14400: mmt.transaction_id
14401: FROM csi_txn_errors cii,
14402: mtl_material_transactions mmt
14403: WHERE cii.processed_flag in ('E', 'R')
14404: AND cii.inv_material_transaction_id is not null
14405: AND mmt.transaction_id = cii.inv_material_transaction_id;

Line 14527: UPDATE csi_txn_errors

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

Line 14621: from CSI_TXN_ERRORS cii,

14617: l_error_count := 0;
14618: Begin
14619: select count(*)
14620: into l_error_count
14621: from CSI_TXN_ERRORS cii,
14622: MTL_MATERIAL_TRANSACTIONS mmt
14623: where cii.inv_material_transaction_id is not null
14624: and cii.inv_material_transaction_id = mmt.transaction_id
14625: and cii.processed_flag in ('E','R')

Line 14984: FROM csi_txn_errors cii,

14980: mmt.organization_id,
14981: mmt.transaction_quantity,
14982: mmt.trx_source_line_id,
14983: mmt.revision
14984: FROM csi_txn_errors cii,
14985: mtl_material_transactions mmt
14986: WHERE cii.processed_flag = 'E'
14987: AND cii.inv_material_transaction_id is not null
14988: AND mmt.transaction_id = cii.inv_material_transaction_id

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

15382: oel.sold_to_org_id owner_acct,
15383: oel.ordered_quantity ordered_qty,
15384: oel.order_quantity_uom ordered_uom,
15385: hca.party_id party_id
15386: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15387: WHERE cte.processed_flag in ('E', 'R')
15388: AND cte.transaction_type_id = 53
15389: AND cte.inv_material_transaction_id = mmt.transaction_id
15390: AND msi.inventory_item_id = mmt.inventory_item_id

Line 15592: UPDATE csi_txn_errors

15588:
15589: END IF;
15590:
15591: IF l_processed_flag = 'Y' THEN
15592: UPDATE csi_txn_errors
15593: SET processed_flag = 'R'
15594: WHERE transaction_error_id = l_rma_txn_tbl(i).Txn_error_id;
15595:
15596: l_instance_tbl(j).quantity:=l_instance_tbl(j).quantity-l_rma_txn_tbl(i).ordered_qty;

Line 15647: FROM csi_txn_errors

15643:
15644: CURSOR err_cur IS
15645: SELECT transaction_error_id,
15646: inv_material_transaction_id
15647: FROM csi_txn_errors
15648: WHERE processed_flag in ('E', 'R')
15649: AND inv_material_transaction_id is not null
15650: AND (source_type is null OR transaction_type_id is null);
15651:

Line 15681: UPDATE csi_txn_errors

15677: WHERE exists (
15678: SELECT 'X' FROM csi_transactions
15679: WHERE inv_material_transaction_id = err_rec.inv_material_transaction_id);
15680:
15681: UPDATE csi_txn_errors
15682: SET processed_flag = 'D'
15683: WHERE transaction_error_id = err_rec.transaction_error_id;
15684:
15685: EXCEPTION

Line 15717: UPDATE csi_txn_errors

15713: p_release => l_release,
15714: x_source_type => l_source_type,
15715: x_csi_txn_type_id => l_csi_txn_type_id);
15716:
15717: UPDATE csi_txn_errors
15718: SET source_type = l_source_type,
15719: transaction_type_id = l_csi_txn_type_id
15720: WHERE transaction_error_id = err_rec.transaction_error_id;
15721:

Line 16289: csi_txn_errors cte

16285: cdt.mtl_txn_id,
16286: cdt.mtl_txn_date,
16287: cte.error_text
16288: FROM csi_diagnostics_temp cdt,
16289: csi_txn_errors cte
16290: WHERE cdt.inventory_item_id = p_item_id
16291: AND cdt.serial_number = p_serial_number
16292: AND cte.inv_material_transaction_id = cdt.mtl_txn_id
16293: AND cte.processed_flag in ('E', 'R')