1: PACKAGE BODY ECX_TRANSACTIONS_API AS
2: -- $Header: ECXTXNAB.pls 120.1.12000000.3 2007/07/20 07:39:46 susaha ship $
3:
4: /**
5: This retrieves Transaction from the transaction definition in the ECX_TRANSACTIONS table.
191:
192: --- Make sure that the Transaction entry is existing or not. The Index is not sufficient.
193: --- We will add the check on party_type later on.
194:
195: ecx_transactions_api.retrieve_transaction
196: (
197: x_return_status => x1_return_status,
198: x_msg => x1_msg,
199: x_transaction_id => x1_transaction_id,
456: x_msg := null;
457: x_ext_process_id :=-1;
458: x_transaction_id :=-1;
459:
460: ecx_transactions_api.retrieve_transaction
461: (
462: x_return_status => x_return_status,
463: x_msg => x_msg,
464: x_transaction_id => x_transaction_id,
876: x_return_status := ECX_UTIL_API.G_NO_ERROR;
877: x_msg := null;
878: x_transaction_id :=-1;
879: x_ext_process_id :=-1;
880: ecx_transactions_api.retrieve_transaction
881: (
882: x_return_status => x_return_status,
883: x_msg => x_msg,
884: x_transaction_id => x_transaction_id,
895: then
896: return;
897: end if;
898:
899: ecx_transactions_api.create_external_transaction
900: (
901: x_return_status => x_return_status,
902: x_msg => x_msg,
903: x_ext_process_id => x_ext_process_id,
1108: x_msg := substr(SQLERRM,1,200);
1109: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
1110: end delete_external_transaction;
1111:
1112: END ECX_TRANSACTIONS_API;