59: l_result varchar2(100);
60: l_proc varchar2(72) := g_package||'processNewUserTransaction';
61: begin
62:
63: hr_utility.set_location('Entering:'|| l_proc, 5);
64:
65: open csr_person;
66: fetch csr_person into l_newUserPersonId;
67:
68: -- if the person Id is not in the database then a dummy person was created and rolled back in the database.
69: -- need to recreat the person again.
70:
71: if csr_person%notfound then
72: hr_utility.set_location('Ranjan in side if csr_person%notfound :'|| l_proc, 5);
73: /*
74: hr_transaction_web.commit_transaction
75: (itemtype=>WfItemType,
76: itemkey=>WfItemKey,
121: end if;
122: -- close the cursor
123: close csr_person;
124:
125: hr_utility.set_location('Leaving:'|| l_proc, 10);
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: PersonId := null;
208: (p_transaction_step_id => csr_sel.transaction_step_id
209: ,p_api_name => csr_sel.api_name
210: ,p_validate => p_validate);
211: exception
212: when hr_utility.hr_error then
213: -- an application error has been raised. set the error flag
214: -- to indicate an application error
215: -- the error message should of been set already
216: hr_message.provide_error;
307: l_warning_error := true;
308: end if;
309: end if;
310: exception
311: when hr_utility.hr_error then
312: -- an application error has been raised. set the error flag
313: -- to indicate an application error
314: -- the error message should of been set already
315: hr_message.provide_error;
367:
368: -- check to see if any application errors where raised
369: if l_obj_fatal_error then
370: fnd_message.set_name('PER','HR_FATAL_OBJECT_ERROR');
371: raise hr_utility.hr_error;
372: elsif l_object_version_error then
373: fnd_message.set_name('PER','HR_7155_OBJECT_INVALID');
374: raise hr_utility.hr_error;
375: elsif l_application_error or l_warning_error then
370: fnd_message.set_name('PER','HR_FATAL_OBJECT_ERROR');
371: raise hr_utility.hr_error;
372: elsif l_object_version_error then
373: fnd_message.set_name('PER','HR_7155_OBJECT_INVALID');
374: raise hr_utility.hr_error;
375: elsif l_application_error or l_warning_error then
376: raise hr_utility.hr_error;
377: end if;
378:
372: elsif l_object_version_error then
373: fnd_message.set_name('PER','HR_7155_OBJECT_INVALID');
374: raise hr_utility.hr_error;
375: elsif l_application_error or l_warning_error then
376: raise hr_utility.hr_error;
377: end if;
378:
379: exception
380: when others then