eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_ASG_STATUS_API dependencies on HR_UTILITY

Line 47: hr_utility.set_location('Entering:'|| l_proc, 10);

43: l_status_change_comments irc_assignment_statuses.status_change_comments%type;
44: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
45: l_proc varchar2(72) := g_package||'dt_update_irc_asg_status';
46: begin
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: if p_datetrack_mode = 'UPDATE_OVERRIDE' then
49: for c_rec in csr_after_date loop
50: delete_irc_asg_status
51: (p_assignment_status_id => c_rec.assignment_status_id,

Line 94: hr_utility.set_location(' Leaving:'||l_proc, 20);

90: --+
91: end if;
92: end if;
93: -- Handle exception and set the out parameters to null and reraise the exception
94: hr_utility.set_location(' Leaving:'||l_proc, 20);
95: exception
96: when others then
97: p_assignment_status_id := null;
98: p_object_version_number := null;

Line 248: hr_utility.set_location('Entering:'|| l_proc, 10);

244: null;
245: end UPDATE_INTERVIEW;
246: --
247: begin
248: hr_utility.set_location('Entering:'|| l_proc, 10);
249: --
250: -- Issue a savepoint
251: --
252: savepoint create_irc_asg_status;

Line 273: hr_utility.set_location('opening cursor c_status_type:'|| l_proc, 11);

269: else
270: l_status_change_date := p_status_change_date;
271: end if;
272: --
273: hr_utility.set_location('opening cursor c_status_type:'|| l_proc, 11);
274: --
275: open c_status_type;
276: fetch c_status_type into l_per_system_status;
277: close c_status_type;

Line 279: hr_utility.set_location('value of the status_type: '||l_per_system_status||', '|| l_proc, 12);

275: open c_status_type;
276: fetch c_status_type into l_per_system_status;
277: close c_status_type;
278: --
279: hr_utility.set_location('value of the status_type: '||l_per_system_status||', '|| l_proc, 12);
280: --
281: if (l_per_system_status='TERM_APL') then
282: --
283: l_status_change_by := get_status_change_by(l_status_change_date,p_assignment_id);

Line 314: hr_utility.set_location('Entering block to call copy_candidate_details:'|| l_proc, 100);

310: );
311: end;
312: --
313: begin
314: hr_utility.set_location('Entering block to call copy_candidate_details:'|| l_proc, 100);
315: if l_per_system_status='ACCEPTED' then
316: hr_utility.set_location('calling irc_utilities_pkg.copy_candidate_details :'|| l_proc, 110);
317: irc_utilities_pkg.copy_candidate_details(p_assignment_id);
318: hr_utility.set_location('After executing irc_utilities_pkg.copy_candidate_details :'|| l_proc, 120);

Line 316: hr_utility.set_location('calling irc_utilities_pkg.copy_candidate_details :'|| l_proc, 110);

312: --
313: begin
314: hr_utility.set_location('Entering block to call copy_candidate_details:'|| l_proc, 100);
315: if l_per_system_status='ACCEPTED' then
316: hr_utility.set_location('calling irc_utilities_pkg.copy_candidate_details :'|| l_proc, 110);
317: irc_utilities_pkg.copy_candidate_details(p_assignment_id);
318: hr_utility.set_location('After executing irc_utilities_pkg.copy_candidate_details :'|| l_proc, 120);
319: end if;
320: hr_utility.set_location('Leaving block to call copy_candidate_details:'|| l_proc, 130);

Line 318: hr_utility.set_location('After executing irc_utilities_pkg.copy_candidate_details :'|| l_proc, 120);

314: hr_utility.set_location('Entering block to call copy_candidate_details:'|| l_proc, 100);
315: if l_per_system_status='ACCEPTED' then
316: hr_utility.set_location('calling irc_utilities_pkg.copy_candidate_details :'|| l_proc, 110);
317: irc_utilities_pkg.copy_candidate_details(p_assignment_id);
318: hr_utility.set_location('After executing irc_utilities_pkg.copy_candidate_details :'|| l_proc, 120);
319: end if;
320: hr_utility.set_location('Leaving block to call copy_candidate_details:'|| l_proc, 130);
321: exception
322: when others then

Line 320: hr_utility.set_location('Leaving block to call copy_candidate_details:'|| l_proc, 130);

316: hr_utility.set_location('calling irc_utilities_pkg.copy_candidate_details :'|| l_proc, 110);
317: irc_utilities_pkg.copy_candidate_details(p_assignment_id);
318: hr_utility.set_location('After executing irc_utilities_pkg.copy_candidate_details :'|| l_proc, 120);
319: end if;
320: hr_utility.set_location('Leaving block to call copy_candidate_details:'|| l_proc, 130);
321: exception
322: when others then
323: hr_utility.set_location(' Exception occured: ' || l_proc, 140);
324: raise;

Line 323: hr_utility.set_location(' Exception occured: ' || l_proc, 140);

319: end if;
320: hr_utility.set_location('Leaving block to call copy_candidate_details:'|| l_proc, 130);
321: exception
322: when others then
323: hr_utility.set_location(' Exception occured: ' || l_proc, 140);
324: raise;
325: end;
326: --
327: -- Process Logic

Line 382: hr_utility.set_location(' Leaving:'||l_proc, 70);

378: --
379: p_assignment_status_id := l_assignment_status_id;
380: p_object_version_number := l_object_version_number;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 70);
383: exception
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised

Line 401: hr_utility.set_location(' Leaving:'||l_proc, 80);

397: -- when validation only mode is being used.)
398: --
399: p_assignment_status_id := null;
400: p_object_version_number := null;
401: hr_utility.set_location(' Leaving:'||l_proc, 80);
402: when others then
403: --
404: -- A validation or unexpected error has occured
405: --

Line 412: hr_utility.set_location(' Leaving:'||l_proc, 90);

408: --
409: p_assignment_status_id := null;
410: p_object_version_number := null;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 90);
413: raise;
414: end create_irc_asg_status;
415: --
416: -- ----------------------------------------------------------------------------

Line 438: hr_utility.set_location('Entering:'|| l_proc, 10);

434: l_status_change_date irc_assignment_statuses.status_change_date%type;
435: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
436: --
437: begin
438: hr_utility.set_location('Entering:'|| l_proc, 10);
439: --
440: -- Issue a savepoint
441: --
442: savepoint update_irc_asg_status;

Line 519: hr_utility.set_location(' Leaving:'||l_proc, 70);

515: -- Set all output arguments
516: --
517: p_object_version_number := l_object_version_number;
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 70);
520: --
521: exception
522: when hr_api.validate_enabled then
523: --

Line 535: hr_utility.set_location(' Leaving:'||l_proc, 80);

531: -- Only set output warning arguments
532: -- (Any key or derived arguments must be set to null
533: -- when validation only mode is being used.)
534: --
535: hr_utility.set_location(' Leaving:'||l_proc, 80);
536: when others then
537: --
538: -- A validation or unexpected error has occured
539: --

Line 544: hr_utility.set_location(' Leaving:'||l_proc, 90);

540: rollback to update_irc_asg_status;
541: -- Reset IN OUT parameters and set OUT paramters
542: p_object_version_number := l_object_version_number;
543: --
544: hr_utility.set_location(' Leaving:'||l_proc, 90);
545: raise;
546: end update_irc_asg_status;
547: --
548: -- ----------------------------------------------------------------------------

Line 563: hr_utility.set_location('Entering:'|| l_proc, 10);

559: --
560: l_proc varchar2(72) := g_package||'delete_irc_asg_status';
561: --
562: begin
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: --
565: -- Issue a savepoint
566: --
567: savepoint delete_irc_asg_status;

Line 616: hr_utility.set_location(' Leaving:'||l_proc, 70);

612: end if;
613: --
614: -- Set all output arguments
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: exception
618: when hr_api.validate_enabled then
619: --
620: -- As the Validate_Enabled exception has been raised

Line 629: hr_utility.set_location(' Leaving:'||l_proc, 80);

625: -- Only set output warning arguments
626: -- (Any key or derived arguments must be set to null
627: -- when validation only mode is being used.)
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 80);
630: when others then
631: --
632: -- A validation or unexpected error has occured
633: --

Line 635: hr_utility.set_location(' Leaving:'||l_proc, 90);

631: --
632: -- A validation or unexpected error has occured
633: --
634: rollback to delete_irc_asg_status;
635: hr_utility.set_location(' Leaving:'||l_proc, 90);
636: raise;
637: end delete_irc_asg_status;
638: --
639: --

Line 679: hr_utility.set_location(' Entering: '|| l_proc, 10);

675: and usr.user_id = fnd_global.user_id;
676: --
677: begin
678: --
679: hr_utility.set_location(' Entering: '|| l_proc, 10);
680: --
681: OPEN csr_applicant_userid
682: (p_assignment_id => p_assignment_id
683: ,p_effective_date => trunc(p_effective_date)

Line 692: hr_utility.set_location('l_user_id: '||l_user_id,20);

688: l_manager_terminates:='Y';
689: END IF;
690: CLOSE csr_applicant_userid;
691: --
692: hr_utility.set_location('l_user_id: '||l_user_id,20);
693: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);
694: --
695: if l_user_id=fnd_global.user_id then
696: l_manager_terminates:='N';

Line 693: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);

689: END IF;
690: CLOSE csr_applicant_userid;
691: --
692: hr_utility.set_location('l_user_id: '||l_user_id,20);
693: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);
694: --
695: if l_user_id=fnd_global.user_id then
696: l_manager_terminates:='N';
697: else

Line 711: hr_utility.set_location(' l_status_change_by: '||l_status_change_by,40);

707: else
708: l_status_change_by := 'CANDIDATE';
709: end if;
710: --
711: hr_utility.set_location(' l_status_change_by: '||l_status_change_by,40);
712: hr_utility.set_location(' Leaving: '|| l_proc, 50);
713: --
714: RETURN l_status_change_by;
715: end get_status_change_by;

Line 712: hr_utility.set_location(' Leaving: '|| l_proc, 50);

708: l_status_change_by := 'CANDIDATE';
709: end if;
710: --
711: hr_utility.set_location(' l_status_change_by: '||l_status_change_by,40);
712: hr_utility.set_location(' Leaving: '|| l_proc, 50);
713: --
714: RETURN l_status_change_by;
715: end get_status_change_by;
716: --