The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ecx_error_no_s.nextval
from dual;
update ecx_outbound_logs
set status=i_status,
out_msgid = i_outmsgid,
error_id = i_error_no,
logfile = ecx_utils.g_logfile,
time_stamp = sysdate,
party_type = decode(i_party_type,null,party_type,i_party_type)
where trigger_id=i_trigger_id;
insert into ecx_msg_logs
(
log_id,
trigger_id,
error_id
)
values
(
ecx_msg_logs_s.NEXTVAL,
i_trigger_id,
i_error_no
);
insert into ecx_error_msgs
(
error_id,
message,
message_parameters
)
values (
i_error_no,
i_errmsg,
nvl(i_errparams, ecx_utils.i_errparams)
);
select trigger_id
from ecx_inbound_logs
where process_id = p_process_id;
update ecx_inbound_logs
set status = i_status,
error_id = i_error_no,
logfile = ecx_utils.g_logfile,
time_stamp = sysdate
where process_id = i_process_id;
insert into ecx_msg_logs
(
log_id,
trigger_id,
error_id
)
values
(
ecx_msg_logs_s.NEXTVAL,
i_trigger_id,
i_error_no
);
insert into ecx_error_msgs
(
error_id,
message,
message_parameters
)
values (
i_error_no,
i_errmsg,
nvl(i_errparams, ecx_utils.i_errparams)
);
select ecx_trigger_id_s.NEXTVAL
from dual;
insert into ecx_external_logs
(
external_process_id,
out_msgid,
status,
error_id,
time_stamp
)
values
(
i_trigger_id,
i_outmsgid,
i_status,
i_error_no,
i_timestamp
);
insert into ecx_msg_logs
(
log_id,
trigger_id,
error_id
)
values
(
ecx_msg_logs_s.NEXTVAL,
i_trigger_id,
i_error_no
);
insert into ecx_error_msgs
(
error_id,
message,
message_parameters
)
values (
i_error_no,
i_errmsg,
nvl(i_errparams, ecx_utils.i_errparams)
);
update ecx_external_retry set status= i_status,time_stamp = i_timestamp,error_id=i_error_no where retry_msgid=i_outmsgid;
Select count(*)
into cnt
from ecx_doclogs
where msgid = i_outmsgid;
select msgid
into i_message_id
from ecx_external_retry
where retry_msgid = i_outmsgid;
select cb_event_name, cb_event_key, block_mode,
msgid,message_type,message_standard,
transaction_type, transaction_subtype,
msgid, message_type, message_standard,
document_number,protocol_type,protocol_address,
username,attribute1, attribute2,
attribute3, attribute4, attribute5,
party_type, partyid, party_site_id,
item_type, item_key, activity_id
into i_event_name, i_event_key, i_block_mode,
i_msgid,i_message_type,i_message_standard,
i_transaction_type, i_transaction_subtype,
i_msgid, i_message_type, i_message_standard,
i_document_number,i_protocol_type,i_protocol_address,
i_username,i_attribute1, i_attribute2,
i_attribute3, i_attribute4, i_attribute5,
i_party_type, i_party_id, i_party_site_id,
i_item_type, i_item_key, i_activity_id
from ecx_doclogs
where msgid = i_message_id;
select sysdate from dual;
select sysdate from dual;
select party_type
from ecx_transactions
where transaction_type = i_transaction_type
and transaction_subtype = i_transaction_subtype;
x_last_updated_by => i_l_by,
x_last_update_date => i_l_dt);
insert into ecx_inbound_logs
(
trigger_id,
process_id,
error_id,
msgid,
status,
time_stamp
)
values
(
i_trigger_id,
i_process_id,
i_error_no,
i_msgid,
i_status,
sysdate
);
update ecx_inbound_logs
set process_id = i_process_id,
msgid = i_msgid,
error_id = i_error_no,
status = i_status,
time_stamp = sysdate
where trigger_id = i_trigger_id;
insert into ecx_msg_logs
(
log_id,
trigger_id,
error_id
)
values
(
ecx_msg_logs_s.NEXTVAL,
i_trigger_id,
i_error_no
);
insert into ecx_error_msgs
(
error_id,
message,
message_parameters
)
values (
i_error_no,
i_errmsg,
nvl(i_errparams, ecx_utils.i_errparams)
);
insert into ecx_outbound_logs
(
trigger_id,
transaction_type,
transaction_subtype,
party_id,
party_site_id,
party_type, --bug #2183619
document_number,
error_id,
status,
time_stamp
)
values
(
i_trigger_id,
i_transaction_type,
i_transaction_subtype,
i_party_id,
i_party_site_id,
i_party_type, --bug #2183619
l_document_number,
i_error_no,
i_status,
sysdate
);
update ecx_outbound_logs
set error_id = i_error_no,
status = i_status,
time_stamp = sysdate
where trigger_id = i_trigger_id;
insert into ecx_msg_logs
(
log_id,
trigger_id,
error_id
)
values
(
ecx_msg_logs_s.NEXTVAL,
i_trigger_id,
i_error_no
);
insert into ecx_error_msgs
(
error_id,
message,
message_parameters
)
values (
i_error_no,
i_errmsg,
nvl(i_errparams, ecx_utils.i_errparams)
);
insert into ecx_doclogs
(
msgid,
message_type,
message_standard,
transaction_type,
transaction_subtype,
document_number,
partyid,
party_site_id,
party_type,
protocol_type,
protocol_address,
username,
password,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
payload,
internal_control_number,
status,
direction,
time_stamp,
out_msgid,
logfile,
item_type,
item_key,
activity_id,
event_name,
event_key,
cb_event_name,
cb_event_key,
block_mode
)
values
(
i_msgid,
i_message_type,
i_message_standard,
i_transaction_type,
i_transaction_subtype,
i_document_number,
i_partyid,
i_party_site_id,
l_party_type,
i_protocol_type,
i_protocol_address,
i_username,
i_password,
i_attribute1,
i_attribute2,
i_attribute3,
i_attribute4,
i_attribute5,
l_payload,
i_internal_control_num,
i_status,
i_direction,
sysdate,
i_outmsgid,
i_logfile,
i_item_type,
i_item_key,
i_activity_id,
i_event_name,
i_event_key,
i_cb_event_name,
i_cb_event_key,
i_block_mode
);
procedure update_log_document
(
i_msgid In raw,
i_outmsgid In raw,
i_status In varchar2,
i_logfile In varchar2,
i_update_type In varchar2
)
is
begin
if i_update_type = 'STATUS'
then
update ecx_doclogs
set status = i_status,
time_stamp = sysdate
where msgid = i_msgid;
update ecx_doclogs
set status = i_status,
logfile = i_logfile,
out_msgid = i_outmsgid,
time_stamp = sysdate
where msgid = i_msgid;
end update_log_document;
select 1 msg_count,
message_type,
message_standard,
transaction_type,
transaction_subtype,
document_number,
partyid,
party_site_id,
protocol_type,
protocol_address,
username,
password,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
logfile,
internal_control_number,
status,
time_stamp,
direction
from ecx_doclogs
where msgid = p_msgid;
insert into ecx_external_retry
(
retry_msgid,
msgid,
status,
error_id,
time_stamp
)
values
(
i_resend_msgid,
i_msgid,
i_status,
i_error_no,
i_timestamp
);
insert into ecx_error_msgs
(
error_id,
message
)
values
(
i_error_no,
i_errmsg
);
select ecx_trigger_id_s.NEXTVAL
from dual;
ecx_errorlog.update_log_document
(
l_ecx_msgid,
l_out_msgid, -- OUT MSG ID
'Inbound processing complete.',
l_logfile,
null
);
select ecx_inlstn_s.nextval into i_message_counter from dual ;