3620: -- For eligible row: Commit work to insure this activity
3621: -- thread doesn't interfere with others.
3622: -- For non-eligible row: Commit to release the lock.
3623: commit;
3624: Fnd_Concurrent.Set_Preferred_RBS;
3625:
3626: end loop;
3627:
3628: exception
3836: -- Commit work to insure this activity thread doesn't interfere
3837: -- with others.
3838: commit;
3839:
3840: Fnd_Concurrent.Set_Preferred_RBS;
3841:
3842: end if;
3843: end loop;
3844:
6371: end if;
6372:
6373: if (docommit) then
6374: commit;
6375: Fnd_Concurrent.Set_Preferred_RBS;
6376: end if;
6377: end loop outer_handle;
6378:
6379: if (docommit) then
6377: end loop outer_handle;
6378:
6379: if (docommit) then
6380: commit;
6381: Fnd_Concurrent.Set_Preferred_RBS;
6382: end if;
6383:
6384: if (actc%ISOPEN) then
6385: close actc;
7383: result => '');
7384:
7385: if (l_docommit and c_err_acts%rowcount = wf_engine.commit_frequency) then
7386: commit;
7387: Fnd_Concurrent.Set_Preferred_RBS;
7388: end if;
7389: l_count := c_err_acts%rowcount;
7390: end loop;
7391:
7392: Fnd_File.Put_Line(Fnd_File.Log, 'Items Processed - '||l_count);
7393:
7394: if (l_docommit) then
7395: commit;
7396: Fnd_Concurrent.Set_Preferred_RBS;
7397: end if;
7398:
7399: -- Successful completion
7400: p_errbuf := '';