18: p_transaction_id IN NUMBER,
19: x_return_status OUT NOCOPY VARCHAR2)
20: IS
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(2000);
19: x_return_status OUT NOCOPY VARCHAR2)
20: IS
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(2000);
27: l_txn_error_id NUMBER;
20: IS
21: l_api_version NUMBER := 1.0;
22: l_commit VARCHAR2(1) := FND_API.G_FALSE;
23: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
24: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(2000);
27: l_txn_error_id NUMBER;
28: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
37: l_return_status VARCHAR2(30);
38: l_ds_return_status VARCHAR2(30);
39: l_xml_string VARCHAR2(2000);
40: l_type_id NUMBER;
41: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
42: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
43: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
44: l_csi_txn_name csi_txn_types.source_transaction_type%type := NULL;
45: l_source_type VARCHAR2(50):= NULL;
38: l_ds_return_status VARCHAR2(30);
39: l_xml_string VARCHAR2(2000);
40: l_type_id NUMBER;
41: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
42: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
43: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
44: l_csi_txn_name csi_txn_types.source_transaction_type%type := NULL;
45: l_source_type VARCHAR2(50):= NULL;
46: hook_error EXCEPTION;
39: l_xml_string VARCHAR2(2000);
40: l_type_id NUMBER;
41: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
42: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
43: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
44: l_csi_txn_name csi_txn_types.source_transaction_type%type := NULL;
45: l_source_type VARCHAR2(50):= NULL;
46: hook_error EXCEPTION;
47: bypass_error EXCEPTION;