131:
132: Begin
133: SELECT transaction_type_id
134: INTO v_transaction_type_id
135: FROM csi_txn_types
136: WHERE source_transaction_type = v_source_transaction_type;
137: Exception
138: when no_data_found then
139: v_txn_type_not_found_msg := 'Invalid Transaction Type.';
385: Begin
386: Begin
387: SELECT transaction_type_id
388: INTO v_transaction_type_id
389: FROM csi_txn_types
390: WHERE source_transaction_type = v_source_transaction_type;
391: Exception
392: when no_data_found then
393: v_txn_type_not_found_msg := 'Invalid Transaction Type..';
621:
622: Begin
623: SELECT transaction_type_id
624: INTO v_transaction_type_id
625: FROM csi_txn_types
626: WHERE source_transaction_type = v_source_transaction_type;
627: Exception
628: when no_data_found then
629: v_txn_type_not_found_msg := 'Invalid Transaction Type...';