APPS.ECX_ERRORLOG dependencies on ECX_DOCLOGS

Line 328: from ecx_doclogs

324:
325: Begin
326: Select count(*)
327: into cnt
328: from ecx_doclogs
329: where msgid = i_outmsgid;
330: Exception
331: When others then
332: Null;

Line 336: -- since the msgid is not in ecx_doclogs it is possible that this was a resend of the

332: Null;
333: End;
334:
335: if cnt = 0 then
336: -- since the msgid is not in ecx_doclogs it is possible that this was a resend of the
337: -- original msgid. So, check if it exists in ecx_external_retry and get the original
338: -- msgid
339: begin
340: select msgid

Line 351: -- msgid found in ecx_doclogs

347: when others then
348: raise;
349: end;
350: else
351: -- msgid found in ecx_doclogs
352: i_message_id := i_outmsgid;
353: end if;
354:
355: if (i_message_id is not null) then

Line 376: from ecx_doclogs

372: i_username,i_attribute1, i_attribute2,
373: i_attribute3, i_attribute4, i_attribute5,
374: i_party_type, i_party_id, i_party_site_id,
375: i_item_type, i_item_key, i_activity_id
376: from ecx_doclogs
377: where msgid = i_message_id;
378: exception
379: when others then
380: raise;

Line 1142: insert into ecx_doclogs

1138: end if;
1139:
1140: ecx_utils.convertPartyTypeToCode(i_party_type, l_party_type);
1141:
1142: insert into ecx_doclogs
1143: (
1144: msgid,
1145: message_type,
1146: message_standard,

Line 1223: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_EXISTS','p_msgid',i_msgid);

1219:
1220: exception
1221: when dup_val_on_index then
1222: o_retcode := 1;
1223: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_EXISTS','p_msgid',i_msgid);
1224: ecx_debug.setErrorInfo(2, 30, 'ECX_DOCLOGS_EXISTS', 'p_msgid', i_msgid);
1225:
1226: when others then
1227: o_retcode := 2;

Line 1224: ecx_debug.setErrorInfo(2, 30, 'ECX_DOCLOGS_EXISTS', 'p_msgid', i_msgid);

1220: exception
1221: when dup_val_on_index then
1222: o_retcode := 1;
1223: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_EXISTS','p_msgid',i_msgid);
1224: ecx_debug.setErrorInfo(2, 30, 'ECX_DOCLOGS_EXISTS', 'p_msgid', i_msgid);
1225:
1226: when others then
1227: o_retcode := 2;
1228: o_retmsg := SQLERRM;

Line 1246: update ecx_doclogs

1242:
1243: begin
1244: if i_update_type = 'STATUS'
1245: then
1246: update ecx_doclogs
1247: set status = i_status,
1248: time_stamp = sysdate
1249: where msgid = i_msgid;
1250: else

Line 1251: update ecx_doclogs

1247: set status = i_status,
1248: time_stamp = sysdate
1249: where msgid = i_msgid;
1250: else
1251: update ecx_doclogs
1252: set status = i_status,
1253: logfile = i_logfile,
1254: out_msgid = i_outmsgid,
1255: time_stamp = sysdate

Line 1319: from ecx_doclogs

1315: internal_control_number,
1316: status,
1317: time_stamp,
1318: direction
1319: from ecx_doclogs
1320: where msgid = p_msgid;
1321:
1322: i_msg_count number :=0;
1323:

Line 1361: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_NOT_EXISTS', 'p_msgid', i_msgid);

1357: o_retmsg := 'SUCCESS';
1358: exception
1359: when no_data_found then
1360: o_retcode := 2;
1361: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_NOT_EXISTS', 'p_msgid', i_msgid);
1362: ecx_utils.i_ret_code := o_retcode;
1363: ecx_utils.i_errbuf := o_retmsg;
1364: when others then
1365: o_retcode := 2;

Line 1701: -- logging resend and doesn't need to log to ecx_doclogs and outbound_logs

1697: x_int_party_site_id => l_int_party_site_id,
1698: x_resend => l_resend
1699: );
1700:
1701: -- logging resend and doesn't need to log to ecx_doclogs and outbound_logs
1702: if l_resend then
1703: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1704: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1705: 'Logged resend for outbound.');