1566: if (l_process_id is null) then
1567: l_process_id := l_msgid;
1568: begin
1569: select trigger_id into l_trigger_id
1570: from ecx_inbound_logs
1571: where msgid = l_msgid;
1572: if (l_trigger_id is null) then
1573: raise null_trigger_id;
1574: end if;
1587: isTPCheck := true;
1588: if l_trigger_id is null then
1589: begin
1590: select max(trigger_id) into l_trigger_id
1591: from ecx_inbound_logs
1592: where msgid = l_msgid;
1593: exception
1594: when others then
1595: open c_ecx_trigger_id;