APPS.CSI_INV_DISCREPANCY_PKG dependencies on CSI_TXN_ERRORS

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

295: When No_Data_Found Then
296: Raise Process_next;
297: End;
298: --
299: -- Check if there are any errors in CSI_TXN_ERRORS
300: --
301: l_error_count := 0;
302: Begin
303: Select Count(*)

Line 305: From CSI_TXN_ERRORS csi,

301: l_error_count := 0;
302: Begin
303: Select Count(*)
304: Into l_error_count
305: From CSI_TXN_ERRORS csi,
306: MTL_MATERIAL_TRANSACTIONS mmt
307: Where csi.inv_material_transaction_id Is Not Null
308: And csi.inv_material_transaction_id = mmt.transaction_id
309: And csi.processed_flag IN ('E','R')

Line 316: ' Under Organization '||to_char(organization_id_mig(i))||'pending in CSI_TXN_ERRORS';

312: End;
313: --
314: IF nvl(l_error_count,0) > 0 THEN
315: v_err_msg := 'Unable to Synch Item ID '||to_char(inventory_item_id_mig(i))||
316: ' Under Organization '||to_char(organization_id_mig(i))||'pending in CSI_TXN_ERRORS';
317: --debug(v_err_msg);
318: Raise Process_next;
319: End If;
320: --

Line 878: -- Check for any inv material transactions in csi_txn_errors with status of ('E','R')

874: FROM CSI_ITEM_INSTANCES
875: WHERE instance_id = l_instance_rec.instance_id;
876: END IF;
877:
878: -- Check for any inv material transactions in csi_txn_errors with status of ('E','R')
879: FOR all_txn IN ALL_TXN_CUR(srl_rec.serial_number,
880: srl_rec.inventory_item_id,
881: srl_rec.lot_code)
882: LOOP

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

881: srl_rec.lot_code)
882: LOOP
883: --dbms_output.put_line(substr('Value of all_txn.mtl_txn_id='||all_txn.mtl_txn_id,1,255));
884: l_error_count := 0;
885: -- Check if there are any errors in CSI_TXN_ERRORS
886: BEGIN
887: SELECT COUNT(*)
888: INTO l_error_count
889: FROM CSI_TXN_ERRORS csi

Line 889: FROM CSI_TXN_ERRORS csi

885: -- Check if there are any errors in CSI_TXN_ERRORS
886: BEGIN
887: SELECT COUNT(*)
888: INTO l_error_count
889: FROM CSI_TXN_ERRORS csi
890: WHERE csi.inv_material_transaction_id IS NOT NULL
891: AND csi.inv_material_transaction_id = all_txn.mtl_txn_id
892: AND csi.processed_flag IN ('E','R');
893: END;

Line 901: debug('there are no error txns in csi_txn_errors');

897: END IF;
898:
899: -- Check whether there are any pending transactions in SFM Queue
900: IF l_error_count = 0 THEN
901: debug('there are no error txns in csi_txn_errors');
902: l_count := 0;
903: BEGIN
904: SELECT COUNT(*)
905: INTO l_error_count