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.HR_UTIL_MISC_SS dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HR_UTIL_MISC_SS AS
2: /* $Header: hrutlmss.pkb 120.41.12020000.11 2013/03/07 09:19:52 pathota ship $ */
3:
4: g_package VARCHAR2(30) := 'HR_UTIL_MISC_SS.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: PROCEDURE initLoginPrsnCtx(p_eff_date IN DATE) IS
8: l_proc constant varchar2(100) := g_package || ' initLoginPrsnCtx';
9: CURSOR c_bg IS

Line 17: hr_utility.set_location('Entering: '|| l_proc,5);

13: AND ppf.business_group_id = oi.organization_id
14: AND oi.org_information_context = 'Business Group Information'
15: AND g_eff_date between ppf.effective_start_date and ppf.effective_end_date;
16: BEGIN
17: hr_utility.set_location('Entering: '|| l_proc,5);
18: OPEN c_bg;
19: hr_utility.trace('Going into Fetch after ( OPEN c_bg ): '|| l_proc);
20: FETCH c_bg INTO g_loginPrsnBGId, g_loginPrsnCurrencyCode;
21: CLOSE c_bg;

Line 19: hr_utility.trace('Going into Fetch after ( OPEN c_bg ): '|| l_proc);

15: AND g_eff_date between ppf.effective_start_date and ppf.effective_end_date;
16: BEGIN
17: hr_utility.set_location('Entering: '|| l_proc,5);
18: OPEN c_bg;
19: hr_utility.trace('Going into Fetch after ( OPEN c_bg ): '|| l_proc);
20: FETCH c_bg INTO g_loginPrsnBGId, g_loginPrsnCurrencyCode;
21: CLOSE c_bg;
22: g_rate_type := hr_currency_pkg.get_rate_type (
23: p_business_group_id => g_loginPrsnBGId

Line 27: hr_utility.set_location('Leaving: '|| l_proc,15);

23: p_business_group_id => g_loginPrsnBGId
24: ,p_conversion_date => p_eff_date
25: ,p_processing_type => 'R');
26:
27: hr_utility.set_location('Leaving: '|| l_proc,15);
28: END initLoginPrsnCtx;
29:
30: /*
31: Currency conversion function to return converted amount as a number.

Line 262: hr_utility.set_location('Entering: '|| l_proc, 5);

258: l_asg_security VARCHAR2(10) := hr_general2.supervisor_assignments_in_use;
259: BEGIN
260:
261: IF g_debug then
262: hr_utility.set_location('Entering: '|| l_proc, 5);
263: END IF;
264:
265: --
266: -- Commented and added as a part of bug#13116989 Starts.

Line 284: hr_utility.trace('In ( IF (l_status = T AND p_person_id <> -1 ) ): '|| l_proc);

280: -- Commented and added as a part of bug#13116989 Ends.
281: --
282:
283: IF (l_status = 'T' AND p_person_id <> '-1' ) THEN
284: hr_utility.trace('In ( IF (l_status = T AND p_person_id <> -1 ) ): '|| l_proc);
285: IF g_debug then
286: hr_utility.set_location('Entering: '|| 'fnd_data_security.check_function', 10);
287: END IF;
288:

Line 286: hr_utility.set_location('Entering: '|| 'fnd_data_security.check_function', 10);

282:
283: IF (l_status = 'T' AND p_person_id <> '-1' ) THEN
284: hr_utility.trace('In ( IF (l_status = T AND p_person_id <> -1 ) ): '|| l_proc);
285: IF g_debug then
286: hr_utility.set_location('Entering: '|| 'fnd_data_security.check_function', 10);
287: END IF;
288:
289: l_status := fnd_data_security.check_function(
290: p_api_version => p_api_version

Line 296: hr_utility.trace('Error in fnd_data_security.check_function l_status is: '||l_status||'. Error is: '|| replace(fnd_message.get_encoded(), chr(0), ' '));

292: ,p_object_name => p_object_name
293: ,p_instance_pk1_value => p_person_id
294: ,p_instance_pk2_value => p_instance_pk2_value);
295: IF l_status = 'E' OR l_status = 'U' THEN
296: hr_utility.trace('Error in fnd_data_security.check_function l_status is: '||l_status||'. Error is: '|| replace(fnd_message.get_encoded(), chr(0), ' '));
297: l_status := 'F';
298: END IF;
299:
300: IF g_debug then

Line 301: hr_utility.set_location('Leaving: '|| 'fnd_data_security.check_function', 15);

297: l_status := 'F';
298: END IF;
299:
300: IF g_debug then
301: hr_utility.set_location('Leaving: '|| 'fnd_data_security.check_function', 15);
302: END IF;
303: END IF;
304:
305: IF (l_status = 'T' AND p_person_id <> '-1' ) THEN

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

309: p_eff_date => p_eff_date);
310: END IF;
311:
312: IF g_debug then
313: hr_utility.set_location('Leaving: '||l_proc, 20);
314: END IF;
315:
316: RETURN l_status;
317: END validate_selected_function;

Line 368: hr_utility.set_location('Entering: '|| l_proc,5);

364: l_smarker INTEGER;
365: l_emarker INTEGER;
366: l_proc constant varchar2(100) := g_package || ' get_parameter_value';
367: BEGIN
368: hr_utility.set_location('Entering: '|| l_proc,5);
369: l_smarker := instr(p_parameter_list, p_parameter);
370:
371: if (l_smarker = 0) THEN
372: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 372: hr_utility.set_location('Leaving: '|| l_proc,10);

368: hr_utility.set_location('Entering: '|| l_proc,5);
369: l_smarker := instr(p_parameter_list, p_parameter);
370:
371: if (l_smarker = 0) THEN
372: hr_utility.set_location('Leaving: '|| l_proc,10);
373: RETURN NULL;
374:
375: END IF;
376:

Line 383: hr_utility.set_location('Leaving: '|| l_proc,15);

379:
380: IF (l_emarker <= 0) THEN
381: l_emarker := LENGTH(p_parameter_list)+1;
382: END IF;
383: hr_utility.set_location('Leaving: '|| l_proc,15);
384:
385: RETURN SUBSTR(p_parameter_list, l_smarker, l_emarker - l_smarker);
386: EXCEPTION
387: WHEN OTHERS THEN

Line 388: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

384:
385: RETURN SUBSTR(p_parameter_list, l_smarker, l_emarker - l_smarker);
386: EXCEPTION
387: WHEN OTHERS THEN
388: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
389: RETURN NULL;
390: END get_parameter_value;
391:
392:

Line 453: hr_utility.set_location('Entering: '|| l_proc, 5);

449:
450: l_func_details csr_fnd_func_details%ROWTYPE;
451: BEGIN
452: IF g_debug then
453: hr_utility.set_location('Entering: '|| l_proc, 5);
454: END IF;
455:
456: OPEN csr_fnd_func_details (p_function);
457: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (p_function)): '|| l_proc);

Line 457: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (p_function)): '|| l_proc);

453: hr_utility.set_location('Entering: '|| l_proc, 5);
454: END IF;
455:
456: OPEN csr_fnd_func_details (p_function);
457: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (p_function)): '|| l_proc);
458: FETCH csr_fnd_func_details INTO l_func_details;
459: CLOSE csr_fnd_func_details;
460: -- Overriding p_function value depending on pCalledFrom value
461: l_function_name := nvl(get_parameter_value(l_func_details.parameters,

Line 466: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);

462: 'pCalledFrom'),p_function);
463:
464: IF l_function_name <> p_function THEN
465: OPEN csr_fnd_func_details (l_function_name);
466: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);
467: FETCH csr_fnd_func_details INTO l_func_details;
468: CLOSE csr_fnd_func_details;
469: END IF;
470:

Line 473: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);

469: END IF;
470:
471: -- Checks whether this function is workflow based
472: IF (INSTR(l_func_details.parameters, 'pProcessName') <> 0) THEN
473: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);
474: l_temp := get_parameter_value(l_func_details.parameters,
475: 'pProcessName');
476:
477: IF (l_temp is not null) THEN

Line 478: hr_utility.trace('In( IF (l_temp is not null)): '|| l_proc);

474: l_temp := get_parameter_value(l_func_details.parameters,
475: 'pProcessName');
476:
477: IF (l_temp is not null) THEN
478: hr_utility.trace('In( IF (l_temp is not null)): '|| l_proc);
479: l_item_type := get_parameter_value(l_func_details.parameters,
480: 'pItemType');
481: OPEN csr_wf_process (l_temp, l_item_type);
482: hr_utility.trace('Going into Fetch after( OPEN csr_wf_process (l_temp, l_item_type))): '|| l_proc);

Line 482: hr_utility.trace('Going into Fetch after( OPEN csr_wf_process (l_temp, l_item_type))): '|| l_proc);

478: hr_utility.trace('In( IF (l_temp is not null)): '|| l_proc);
479: l_item_type := get_parameter_value(l_func_details.parameters,
480: 'pItemType');
481: OPEN csr_wf_process (l_temp, l_item_type);
482: hr_utility.trace('Going into Fetch after( OPEN csr_wf_process (l_temp, l_item_type))): '|| l_proc);
483: FETCH csr_wf_process INTO l_status;
484: IF csr_wf_process%NOTFOUND THEN
485: l_status := 'T';
486: ELSE

Line 493: hr_utility.trace('In else of (IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);

489: CLOSE csr_wf_process;
490:
491: END IF;
492: ELSE
493: hr_utility.trace('In else of (IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);
494: l_status := 'T';
495: END IF;
496:
497: IF g_debug then

Line 498: hr_utility.set_location('Leaving: '||l_proc, 30);

494: l_status := 'T';
495: END IF;
496:
497: IF g_debug then
498: hr_utility.set_location('Leaving: '||l_proc, 30);
499: END IF;
500:
501: RETURN l_status; -- if status is N then it is no term access
502:

Line 505: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

501: RETURN l_status; -- if status is N then it is no term access
502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
506: RETURN 'N';
507: END check_term_access;
508:
509: /**

Line 534: hr_utility.set_location('Entering: '|| l_proc, 5);

530:
531: l_proc varchar2(72) := g_package||'check_primary_access';
532: BEGIN
533: IF g_debug then
534: hr_utility.set_location('Entering: '|| l_proc, 5);
535: END IF;
536:
537: OPEN fetch_asg (p_selected_person_id, p_effective_date);
538: hr_utility.trace('Going into Fetch after (OPEN fetch_asg (p_selected_person_id, p_effective_date) ): '|| l_proc);

Line 538: hr_utility.trace('Going into Fetch after (OPEN fetch_asg (p_selected_person_id, p_effective_date) ): '|| l_proc);

534: hr_utility.set_location('Entering: '|| l_proc, 5);
535: END IF;
536:
537: OPEN fetch_asg (p_selected_person_id, p_effective_date);
538: hr_utility.trace('Going into Fetch after (OPEN fetch_asg (p_selected_person_id, p_effective_date) ): '|| l_proc);
539: FETCH fetch_asg INTO l_status;
540:
541: IF fetch_asg%NOTFOUND THEN
542: l_status := 'N';

Line 548: hr_utility.set_location('Leaving: '||l_proc, 10);

544:
545: CLOSE fetch_asg;
546:
547: IF g_debug then
548: hr_utility.set_location('Leaving: '||l_proc, 10);
549: END IF;
550:
551: RETURN l_status;
552:

Line 595: hr_utility.set_location('Entering: '|| l_proc,5);

591: 'HR_LOA_SUMMARY_TOP_SS'
592: );
593:
594: BEGIN
595: hr_utility.set_location('Entering: '|| l_proc,5);
596: OPEN csr_akregion_list;
597: hr_utility.trace('Going into Fetch after ( OPEN csr_akregion_list ): '|| l_proc);
598: FETCH csr_akregion_list INTO l_status;
599: IF csr_akregion_list%NOTFOUND

Line 597: hr_utility.trace('Going into Fetch after ( OPEN csr_akregion_list ): '|| l_proc);

593:
594: BEGIN
595: hr_utility.set_location('Entering: '|| l_proc,5);
596: OPEN csr_akregion_list;
597: hr_utility.trace('Going into Fetch after ( OPEN csr_akregion_list ): '|| l_proc);
598: FETCH csr_akregion_list INTO l_status;
599: IF csr_akregion_list%NOTFOUND
600: THEN
601: l_status := 'T';

Line 606: hr_utility.set_location('Leaving: '|| l_proc,15);

602: END IF;
603: CLOSE csr_akregion_list;
604:
605: RETURN l_status;
606: hr_utility.set_location('Leaving: '|| l_proc,15);
607: END check_akregion_code;
608:
609: /**
610: * Checks for the CWK access of the function returns a C or T

Line 662: hr_utility.set_location('Entering: '|| l_proc, 5);

658:
659: l_func_details csr_fnd_func_details%ROWTYPE;
660: BEGIN
661: IF g_debug then
662: hr_utility.set_location('Entering: '|| l_proc, 5);
663: END IF;
664:
665: OPEN csr_per_npw_flag;
666: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);

Line 666: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);

662: hr_utility.set_location('Entering: '|| l_proc, 5);
663: END IF;
664:
665: OPEN csr_per_npw_flag;
666: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);
667: FETCH csr_per_npw_flag INTO l_npw_status;
668: IF csr_per_npw_flag%NOTFOUND THEN
669: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
670: hr_utility.raise_error;

Line 669: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');

665: OPEN csr_per_npw_flag;
666: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);
667: FETCH csr_per_npw_flag INTO l_npw_status;
668: IF csr_per_npw_flag%NOTFOUND THEN
669: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
670: hr_utility.raise_error;
671: END IF;
672: CLOSE csr_per_npw_flag;
673: IF (l_npw_status <> 'Y') THEN

Line 670: hr_utility.raise_error;

666: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);
667: FETCH csr_per_npw_flag INTO l_npw_status;
668: IF csr_per_npw_flag%NOTFOUND THEN
669: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
670: hr_utility.raise_error;
671: END IF;
672: CLOSE csr_per_npw_flag;
673: IF (l_npw_status <> 'Y') THEN
674: hr_utility.set_location('Leaving: '|| l_proc,15);

Line 674: hr_utility.set_location('Leaving: '|| l_proc,15);

670: hr_utility.raise_error;
671: END IF;
672: CLOSE csr_per_npw_flag;
673: IF (l_npw_status <> 'Y') THEN
674: hr_utility.set_location('Leaving: '|| l_proc,15);
675: RETURN 'T';
676: END IF;
677:
678: OPEN csr_fnd_func_details (p_function);

Line 679: hr_utility.trace('Going into Fetch after ( OPEN csr_fnd_func_details (p_function)): '|| l_proc);

675: RETURN 'T';
676: END IF;
677:
678: OPEN csr_fnd_func_details (p_function);
679: hr_utility.trace('Going into Fetch after ( OPEN csr_fnd_func_details (p_function)): '|| l_proc);
680: FETCH csr_fnd_func_details INTO l_func_details;
681: CLOSE csr_fnd_func_details;
682: -- Overriding p_function value depending on pCalledFrom value
683: l_function_name := nvl(get_parameter_value(l_func_details.parameters,

Line 687: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);

683: l_function_name := nvl(get_parameter_value(l_func_details.parameters,
684: 'pCalledFrom'),p_function);
685: IF l_function_name <> p_function THEN
686: OPEN csr_fnd_func_details (l_function_name);
687: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);
688: FETCH csr_fnd_func_details INTO l_func_details;
689: CLOSE csr_fnd_func_details;
690: END IF;
691:

Line 694: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);

690: END IF;
691:
692: -- Checks whether this function is workflow based
693: IF (INSTR(l_func_details.parameters, 'pProcessName') <> 0) THEN
694: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);
695: l_temp := get_parameter_value(l_func_details.parameters,
696: 'pProcessName');
697: IF (l_temp is not null) THEN
698: l_item_type := get_parameter_value(l_func_details.parameters,

Line 701: hr_utility.trace('Going into Fetch after (OPEN csr_wf_process (l_temp, l_item_type)): '|| l_proc);

697: IF (l_temp is not null) THEN
698: l_item_type := get_parameter_value(l_func_details.parameters,
699: 'pItemType');
700: OPEN csr_wf_process (l_temp, l_item_type);
701: hr_utility.trace('Going into Fetch after (OPEN csr_wf_process (l_temp, l_item_type)): '|| l_proc);
702: FETCH csr_wf_process INTO l_status;
703: IF csr_wf_process%NOTFOUND THEN
704: l_status := 'T';
705: END IF;

Line 711: hr_utility.trace('In else of ( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);

707:
708: END IF;
709:
710: ELSE
711: hr_utility.trace('In else of ( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);
712:
713: l_temp := nvl(get_parameter_value(l_func_details.web_html_call,
714: 'akRegionCode'),
715: get_parameter_value(l_func_details.web_html_call,

Line 722: hr_utility.set_location('Leaving: '||l_proc, 40);

718: l_status := check_akregion_code(l_temp);
719: END IF;
720:
721: IF g_debug then
722: hr_utility.set_location('Leaving: '||l_proc, 40);
723: END IF;
724:
725: RETURN l_status;
726: EXCEPTION

Line 729: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

725: RETURN l_status;
726: EXCEPTION
727: WHEN OTHERS THEN
728:
729: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
730: RETURN 'C';
731: END check_cwk_access;
732:
733: PROCEDURE clear_cache

Line 738: hr_utility.set_location('Entering: '|| l_proc,5);

734: IS
735: --local variable
736: l_proc constant varchar2(100) := g_package || ' clear_cache';
737: BEGIN
738: hr_utility.set_location('Entering: '|| l_proc,5);
739: g_entity_list.delete;
740: -- g_entitydetail_list.delete;
741: hr_utility.set_location('Leaving: '|| l_proc,10);
742: END clear_cache;

Line 741: hr_utility.set_location('Leaving: '|| l_proc,10);

737: BEGIN
738: hr_utility.set_location('Entering: '|| l_proc,5);
739: g_entity_list.delete;
740: -- g_entitydetail_list.delete;
741: hr_utility.set_location('Leaving: '|| l_proc,10);
742: END clear_cache;
743:
744: FUNCTION entity_exists (
745: p_entity_id IN NUMBER

Line 752: hr_utility.set_location('Entering: '|| l_proc,5);

748: IS
749: --local variable
750: l_proc constant varchar2(100) := g_package || ' entity_exists';
751: BEGIN
752: hr_utility.set_location('Entering: '|| l_proc,5);
753: IF g_entity_list.exists(p_entity_id) THEN
754: hr_utility.set_location('Leaving: '|| l_proc,10);
755: RETURN 'T';
756: END IF;

Line 754: hr_utility.set_location('Leaving: '|| l_proc,10);

750: l_proc constant varchar2(100) := g_package || ' entity_exists';
751: BEGIN
752: hr_utility.set_location('Entering: '|| l_proc,5);
753: IF g_entity_list.exists(p_entity_id) THEN
754: hr_utility.set_location('Leaving: '|| l_proc,10);
755: RETURN 'T';
756: END IF;
757: hr_utility.set_location('Leaving: '|| l_proc,15);
758: RETURN 'F';

Line 757: hr_utility.set_location('Leaving: '|| l_proc,15);

753: IF g_entity_list.exists(p_entity_id) THEN
754: hr_utility.set_location('Leaving: '|| l_proc,10);
755: RETURN 'T';
756: END IF;
757: hr_utility.set_location('Leaving: '|| l_proc,15);
758: RETURN 'F';
759: EXCEPTION
760: WHEN others THEN
761: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 761: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

757: hr_utility.set_location('Leaving: '|| l_proc,15);
758: RETURN 'F';
759: EXCEPTION
760: WHEN others THEN
761: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
762: RETURN 'F';
763: END entity_exists;
764:
765: PROCEDURE populate_entity_list (

Line 773: hr_utility.set_location('Entering: '|| l_proc,5);

769: IS
770: --local variable
771: l_proc constant varchar2(100) := g_package || ' populate_entity_list';
772: BEGIN
773: hr_utility.set_location('Entering: '|| l_proc,5);
774: if p_retain_cache = 'N'
775: then
776: clear_cache();
777: end if;

Line 781: hr_utility.set_location('Leaving: '|| l_proc,10);

777: end if;
778: FOR I IN 1 ..p_elist.count LOOP
779: g_entity_list(p_elist(i)) := p_elist(i);
780: END LOOP;
781: hr_utility.set_location('Leaving: '|| l_proc,10);
782: END populate_entity_list;
783:
784: PROCEDURE check_ota_installed (appl_id number, status out nocopy varchar2) is
785: l_status VARCHAR2(1);

Line 791: hr_utility.set_location('Entering: '|| l_proc,5);

787: l_flag boolean;
788: --local variable
789: l_proc constant varchar2(100) := g_package || ' check_ota_installed';
790: begin
791: hr_utility.set_location('Entering: '|| l_proc,5);
792: l_flag := fnd_installation.get(appl_id => appl_id,
793: dep_appl_id => appl_id,
794: status => l_status,
795: industry => l_industry );

Line 802: hr_utility.set_location('Leaving: '|| l_proc,10);

798: status := 'Y';
799: else
800: status := 'N';
801: end if;
802: hr_utility.set_location('Leaving: '|| l_proc,10);
803: end check_ota_installed;
804:
805: FUNCTION get_employee_salary(
806: p_assignment_id IN NUMBER

Line 897: hr_utility.set_location('Entering: '|| l_proc,5);

893: AND WAAV.NAME = name;
894:
895: BEGIN
896:
897: hr_utility.set_location('Entering: '|| l_proc,5);
898:
899: l_number_value := wf_engine.GetItemAttrNumber (
900: itemtype => itemtype,
901: itemkey => itemkey,

Line 929: hr_utility.set_location('Leaving: '|| l_proc,10);

925: else
926: resultout := 'COMPLETE:'|| 'N';
927: end if;
928: --
929: hr_utility.set_location('Leaving: '|| l_proc,10);
930:
931: EXCEPTION
932: WHEN OTHERS THEN
933:

Line 934: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

930:
931: EXCEPTION
932: WHEN OTHERS THEN
933:
934: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
935: WF_CORE.CONTEXT (
936: g_package,
937: 'is_voluntary_termination',
938: itemtype,

Line 960: hr_utility.set_location('Entering: '|| l_proc,5);

956: dummy varchar2(2);
957:
958: BEGIN
959:
960: hr_utility.set_location('Entering: '|| l_proc,5);
961:
962: hr_approval_ss.create_item_attrib_if_notexist(itemtype => itemtype
963: ,itemkey => itemkey
964: ,aname => 'HR_TERM_SEC_ASG'

Line 991: hr_utility.set_location('Leaving: '|| l_proc,10);

987: else
988: resultout := 'COMPLETE:'|| 'N';
989: end if;
990: --
991: hr_utility.set_location('Leaving: '|| l_proc,10);
992:
993: EXCEPTION
994: WHEN OTHERS THEN
995:

Line 996: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

992:
993: EXCEPTION
994: WHEN OTHERS THEN
995:
996: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
997: WF_CORE.CONTEXT (
998: g_package,
999: 'branch_on_approval_flag',
1000: itemtype,

Line 1041: hr_utility.set_location('Entering: '|| l_proc,5);

1037: l_text_value wf_activity_attr_values.text_value%type;
1038: --local variable
1039: l_proc constant varchar2(100) := g_package || ' is_employee_check';
1040: BEGIN
1041: hr_utility.set_location('Entering: '|| l_proc,5);
1042: --
1043: l_text_value := wf_engine.GetItemAttrText (
1044: itemtype => itemtype,
1045: itemkey => itemkey,

Line 1054: hr_utility.set_location('Leaving: '|| l_proc,10);

1050: else
1051: resultout := 'COMPLETE:'|| 'Y';
1052: end if;
1053: --
1054: hr_utility.set_location('Leaving: '|| l_proc,10);
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057:
1058: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 1058: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1054: hr_utility.set_location('Leaving: '|| l_proc,10);
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057:
1058: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1059: WF_CORE.CONTEXT (
1060: g_package,
1061: 'branch_on_approval_flag',
1062: itemtype,

Line 1076: hr_utility.set_location('Entering: '|| l_proc,5);

1072: IS
1073: --local variable
1074: l_proc constant varchar2(100) := g_package || ' populateInterimPersonList';
1075: BEGIN
1076: hr_utility.set_location('Entering: '|| l_proc,5);
1077: -- This commit is issued here to remove the Data from the Temp table.
1078: -- This can be replaced by truncate.
1079: --COMMIT;
1080: DELETE PER_INTERIM_PERSON_LIST;

Line 1085: hr_utility.set_location('Leaving: '|| l_proc,10);

1081: FOR i in 1.. person_data.count LOOP
1082: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1083: values (person_data(i).person_id, person_data(i).assignment_id, person_data(i).in_my_list);
1084: END LOOP;
1085: hr_utility.set_location('Leaving: '|| l_proc,10);
1086: EXCEPTION
1087: WHEN others THEN
1088: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1089: RAISE;

Line 1088: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1084: END LOOP;
1085: hr_utility.set_location('Leaving: '|| l_proc,10);
1086: EXCEPTION
1087: WHEN others THEN
1088: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1089: RAISE;
1090: END populateInterimPersonList;
1091:
1092: PROCEDURE populateInterimListFromMyList (

Line 1099: hr_utility.set_location('Entering: '|| l_proc,5);

1095: IS
1096: --local variable
1097: l_proc constant varchar2(100) := g_package || ' populateInterimListFromMyList';
1098: BEGIN
1099: hr_utility.set_location('Entering: '|| l_proc,5);
1100: --COMMIT;
1101: DELETE PER_INTERIM_PERSON_LIST;
1102: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1103: SELECT selected_person_id, selected_assignment_id, 'Y'

Line 1106: hr_utility.set_location('Leaving: '|| l_proc,10);

1102: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1103: SELECT selected_person_id, selected_assignment_id, 'Y'
1104: FROM hr_working_person_lists
1105: WHERE owning_person_id = person_id;
1106: hr_utility.set_location('Leaving: '|| l_proc,10);
1107: EXCEPTION
1108: WHEN others THEN
1109: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1110: RAISE;

Line 1109: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1105: WHERE owning_person_id = person_id;
1106: hr_utility.set_location('Leaving: '|| l_proc,10);
1107: EXCEPTION
1108: WHEN others THEN
1109: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1110: RAISE;
1111: END populateInterimListFromMyList;
1112:
1113: PROCEDURE addToMyListFromInterimList (

Line 1120: hr_utility.set_location('Entering: '|| l_proc,5);

1116: IS
1117: --local variable
1118: l_proc constant varchar2(100) := g_package || ' addToMyListFromInterimList';
1119: BEGIN
1120: hr_utility.set_location('Entering: '|| l_proc,5);
1121: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,
1122: selected_person_id, current_selection, multiple_selection, selected_assignment_id)
1123: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,
1124: prsn_id,

Line 1130: hr_utility.set_location('Leaving: '|| l_proc,10);

1126: NULL,
1127: NULL,
1128: list.assignment_id
1129: FROM PER_INTERIM_PERSON_LIST list;
1130: hr_utility.set_location('Leaving: '|| l_proc,10);
1131: EXCEPTION
1132: WHEN others THEN
1133: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1134: RAISE;

Line 1133: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1129: FROM PER_INTERIM_PERSON_LIST list;
1130: hr_utility.set_location('Leaving: '|| l_proc,10);
1131: EXCEPTION
1132: WHEN others THEN
1133: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1134: RAISE;
1135: END addToMyListFromInterimList;
1136:
1137: PROCEDURE setEffectiveDate

Line 1146: hr_utility.set_location('Entering: '|| l_proc,5);

1142: --
1143: --local variable
1144: l_proc constant varchar2(100) := g_package || ' setEffectiveDate';
1145: BEGIN
1146: hr_utility.set_location('Entering: '|| l_proc,5);
1147: --
1148: g_eff_date := trunc(p_effective_date);
1149: --bug 5765957 start
1150: begin

Line 1154: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);

1150: begin
1151: dt_fndate.set_effective_date(g_eff_date);
1152: exception
1153: when DUP_VAL_ON_INDEX then
1154: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);
1155: when others then
1156: hr_utility.set_location('change for others : ' || l_proc ,998);
1157: end;
1158: --bug 5765957 end

Line 1156: hr_utility.set_location('change for others : ' || l_proc ,998);

1152: exception
1153: when DUP_VAL_ON_INDEX then
1154: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);
1155: when others then
1156: hr_utility.set_location('change for others : ' || l_proc ,998);
1157: end;
1158: --bug 5765957 end
1159: initLoginPrsnCtx(g_eff_date);
1160: g_year_start := to_date('01/01/'||to_char(g_eff_date,'RRRR'),'DD/MM/RRRR');

Line 1164: hr_utility.set_location('Leaving: '|| l_proc,10);

1160: g_year_start := to_date('01/01/'||to_char(g_eff_date,'RRRR'),'DD/MM/RRRR');
1161: --
1162: commit;
1163: --
1164: hr_utility.set_location('Leaving: '|| l_proc,10);
1165: EXCEPTION
1166: WHEN others THEN
1167: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1168: rollback;

Line 1167: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1163: --
1164: hr_utility.set_location('Leaving: '|| l_proc,10);
1165: EXCEPTION
1166: WHEN others THEN
1167: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1168: rollback;
1169: raise;
1170: END setEffectiveDate;
1171:

Line 1183: hr_utility.set_location('Entering: '|| l_proc,5);

1179: IS
1180: --local variable
1181: l_proc constant varchar2(100) := g_package || ' getObjectName';
1182: BEGIN
1183: hr_utility.set_location('Entering: '|| l_proc,5);
1184: IF PER_WORK_STRUCTURE_OVERRIDE_SS.isOverrideEnabled(p_object) THEN
1185: return nvl(PER_WORK_STRUCTURE_OVERRIDE_SS.getObjectName(p_object
1186: , p_object_id, p_bg_id, p_value) ,p_value);
1187: END IF;

Line 1188: hr_utility.set_location('Leaving: '|| l_proc,10);

1184: IF PER_WORK_STRUCTURE_OVERRIDE_SS.isOverrideEnabled(p_object) THEN
1185: return nvl(PER_WORK_STRUCTURE_OVERRIDE_SS.getObjectName(p_object
1186: , p_object_id, p_bg_id, p_value) ,p_value);
1187: END IF;
1188: hr_utility.set_location('Leaving: '|| l_proc,10);
1189: return p_value;
1190: END getObjectName;
1191:
1192: PROCEDURE initialize_am IS

Line 1199: g_debug := hr_utility.debug_enabled;

1195:
1196: -- If g_debug is only set at package level
1197: -- logging will not work consistently
1198: --
1199: g_debug := hr_utility.debug_enabled;
1200:
1201: IF g_debug then
1202: hr_utility.set_location('Entering: '|| l_proc, 5);
1203: END IF;

Line 1202: hr_utility.set_location('Entering: '|| l_proc, 5);

1198: --
1199: g_debug := hr_utility.debug_enabled;
1200:
1201: IF g_debug then
1202: hr_utility.set_location('Entering: '|| l_proc, 5);
1203: END IF;
1204:
1205:
1206: -- 3952978

Line 1291: hr_utility.set_location('Entering: '|| l_proc,5);

1287: IS
1288: --local variable
1289: l_proc constant varchar2(100) := g_package || ' populateInterimEntityList';
1290: BEGIN
1291: hr_utility.set_location('Entering: '|| l_proc,5);
1292: if p_retain_cache = 'N'
1293: then
1294: DELETE PER_INTERIM_ENTITY_LIST;
1295: end if;

Line 1300: hr_utility.set_location('Leaving: '|| l_proc,10);

1296: FOR i in 1.. entity_data.count LOOP
1297: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)
1298: values (entity_data(i).entity_name, entity_data(i).state,entity_data(i).pk1,entity_data(i).pk2,entity_data(i).pk3,entity_data(i).pk4,entity_data(i).pk5);
1299: END LOOP;
1300: hr_utility.set_location('Leaving: '|| l_proc,10);
1301: EXCEPTION
1302: WHEN others THEN
1303: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1304: RAISE;

Line 1303: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1299: END LOOP;
1300: hr_utility.set_location('Leaving: '|| l_proc,10);
1301: EXCEPTION
1302: WHEN others THEN
1303: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1304: RAISE;
1305: END populateInterimEntityList;
1306:
1307: PROCEDURE clearInterimEntityList

Line 1311: hr_utility.set_location('Entering: '|| l_proc,5);

1307: PROCEDURE clearInterimEntityList
1308: IS
1309: l_proc constant varchar2(100) := g_package || 'clearInterimEntityList';
1310: BEGIN
1311: hr_utility.set_location('Entering: '|| l_proc,5);
1312: DELETE PER_INTERIM_ENTITY_LIST;
1313: END clearInterimEntityList;
1314:
1315: procedure isPersonTerminated (

Line 1325: hr_utility.set_location('Entering: '|| l_proc,5);

1321: l_proc constant varchar2(100) := g_package || ' isPersonTerminated';
1322: assi_id varchar2(200) := null ;
1323:
1324: begin
1325: hr_utility.set_location('Entering: '|| l_proc,5);
1326:
1327: select assignment_id
1328: into assi_id
1329: from per_people_f ppf, per_assignments_f paf

Line 1349: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1345: when no_data_found then
1346: result := 'FALSE';
1347: null;
1348: WHEN others THEN
1349: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1350: result := 'TRUE';
1351: END isPersonTerminated;
1352:
1353: procedure getDeploymentPersonID (person_id in number, result out nocopy number )

Line 1396: hr_utility.set_location('Entering: '|| l_proc,5);

1392:
1393: l_func_details csr_fnd_func_details%ROWTYPE;
1394:
1395: BEGIN
1396: hr_utility.set_location('Entering: '|| l_proc,5);
1397: l_bg_id := p_bg_id;
1398: OPEN csr_fnd_func_details;
1399: FETCH csr_fnd_func_details INTO l_func_details;
1400:

Line 1430: hr_utility.set_location('Leaving getBusinessGroup with result (BusinesGroupID): ' || l_bg_id,5);

1426: end;
1427: END IF; -- end of IF (l_func_name <> l_param_name) OR (l_appr_index > 0 )THEN
1428: end if; -- end of if csr_fnd_func_details%found then
1429: CLOSE csr_fnd_func_details;
1430: hr_utility.set_location('Leaving getBusinessGroup with result (BusinesGroupID): ' || l_bg_id,5);
1431: return l_bg_id;
1432: END getBusinessGroup;
1433:
1434:

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

1459: l_attached_doc_pre_upd csr_get_attached_doc%rowtype;
1460: l_doc_pre_upd csr_get_doc%rowtype;
1461: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
1462: Begin
1463: hr_utility.set_location(' Entering:' || l_proc,10);
1464: select userenv('LANG') into l_language from dual;
1465: Open csr_get_attached_doc;
1466: fetch csr_get_attached_doc into l_attached_doc_pre_upd;
1467: IF csr_get_attached_doc%NOTFOUND THEN

Line 1487: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);

1483: close csr_get_doc_tl;
1484: raise data_error;
1485: END IF;
1486:
1487: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
1488: fnd_attached_documents_pkg.lock_row
1489: (x_rowid => p_rowid
1490: ,x_attached_document_id =>
1491: l_attached_doc_pre_upd.attached_document_id

Line 1556: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);

1552: ,x_title => l_doc_tl_pre_upd.title
1553: );
1554:
1555:
1556: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1557: fnd_attached_documents_pkg.update_row
1558: (x_rowid => p_rowid
1559: ,x_attached_document_id =>
1560: l_attached_doc_pre_upd.attached_document_id

Line 1627: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);

1623: ,x_url => l_doc_pre_upd.url
1624: ,x_title => l_doc_tl_pre_upd.title
1625: );
1626:
1627: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1628: hr_utility.set_location(' Leaving:' || l_proc,50);
1629:
1630: EXCEPTION
1631: when others then

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

1624: ,x_title => l_doc_tl_pre_upd.title
1625: );
1626:
1627: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1628: hr_utility.set_location(' Leaving:' || l_proc,50);
1629:
1630: EXCEPTION
1631: when others then
1632: hr_utility.set_location(' Error in :' || l_proc,60);

Line 1632: hr_utility.set_location(' Error in :' || l_proc,60);

1628: hr_utility.set_location(' Leaving:' || l_proc,50);
1629:
1630: EXCEPTION
1631: when others then
1632: hr_utility.set_location(' Error in :' || l_proc,60);
1633: raise;
1634: End update_attachment;
1635:
1636: procedure merge_attachments (

Line 1715: hr_utility.set_location('Exception when fetching person_id and irc_doc_id ', 10);

1711: AND hatv2.transaction_step_id = hatv1.transaction_step_id
1712: AND hatv2.name = 'P_IRC_DOC_ID'||substr(hatv1.name,-1,length(hatv1.name));
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: hr_utility.set_location('Exception when fetching person_id and irc_doc_id ', 10);
1716: l_person_id := null;
1717: l_irc_doc_id := null;
1718: END;
1719: hr_utility.set_location('l_person_id: '||l_person_id, 10);

Line 1719: hr_utility.set_location('l_person_id: '||l_person_id, 10);

1715: hr_utility.set_location('Exception when fetching person_id and irc_doc_id ', 10);
1716: l_person_id := null;
1717: l_irc_doc_id := null;
1718: END;
1719: hr_utility.set_location('l_person_id: '||l_person_id, 10);
1720: hr_utility.set_location('l_irc_doc_id: '||l_irc_doc_id, 10);
1721:
1722: IF l_person_id = p_dest_pk1_value
1723: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'

Line 1720: hr_utility.set_location('l_irc_doc_id: '||l_irc_doc_id, 10);

1716: l_person_id := null;
1717: l_irc_doc_id := null;
1718: END;
1719: hr_utility.set_location('l_person_id: '||l_person_id, 10);
1720: hr_utility.set_location('l_irc_doc_id: '||l_irc_doc_id, 10);
1721:
1722: IF l_person_id = p_dest_pk1_value
1723: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
1724: THEN

Line 1725: hr_utility.set_location('Entering: IF l_person_id <> null ', 10);

1721:
1722: IF l_person_id = p_dest_pk1_value
1723: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
1724: THEN
1725: hr_utility.set_location('Entering: IF l_person_id <> null ', 10);
1726: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id ))
1727: THEN
1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1729:

Line 1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);

1724: THEN
1725: hr_utility.set_location('Entering: IF l_person_id <> null ', 10);
1726: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id ))
1727: THEN
1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1729:
1730: /*start - added for bug 14277455*/
1731: per_fnd_attachment_pkg.update_on_link_table(l_irc_doc_id,l_person_id, attached_documents_rec);
1732: /*end - added for bug 14277455*/

Line 1736: hr_utility.set_location('Entering: ELSE OF IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);

1732: /*end - added for bug 14277455*/
1733:
1734:
1735: ELSE
1736: hr_utility.set_location('Entering: ELSE OF IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1737: update_attachment
1738: (p_entity_name=>p_dest_entity_name
1739: ,p_pk1_value=> p_dest_pk1_value
1740: ,p_rowid=>l_rowid);

Line 1743: hr_utility.set_location('Entering: ELSE OF IF l_person_id <> null ', 20);

1739: ,p_pk1_value=> p_dest_pk1_value
1740: ,p_rowid=>l_rowid);
1741: END IF;
1742: ELSE
1743: hr_utility.set_location('Entering: ELSE OF IF l_person_id <> null ', 20);
1744: update_attachment
1745: (p_entity_name=>p_dest_entity_name
1746: ,p_pk1_value=> p_dest_pk1_value
1747: ,p_rowid=>l_rowid);

Line 1800: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

1796:
1797: begin
1798:
1799: if g_debug then
1800: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1801: end if;
1802:
1803: if(p_transaction_id is not null) then
1804:

Line 1815: hr_utility.set_location('Transaction not found',5);

1811: open csr_trans_rec;
1812: fetch csr_trans_rec into lr_hr_api_transaction_rec;
1813: if (csr_trans_rec%NOTFOUND) then
1814: CLOSE csr_trans_rec;
1815: hr_utility.set_location('Transaction not found',5);
1816: return false;
1817: end if;
1818: close csr_trans_rec;
1819:

Line 1853: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

1849:
1850: return l_save_attach;
1851:
1852: if (g_debug ) then
1853: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1854: end if;
1855: end if;
1856:
1857: exception

Line 1918: hr_utility.set_location('In saveAttachment', 1);

1914: /*Added following cursor as a part of ER#9879782 Ends*/
1915:
1916:
1917: begin
1918: hr_utility.set_location('In saveAttachment', 1);
1919: if(p_transaction_id is not null) then
1920:
1921: hr_utility.set_location('p_transaction_id :' || p_transaction_id, 1);
1922:

Line 1921: hr_utility.set_location('p_transaction_id :' || p_transaction_id, 1);

1917: begin
1918: hr_utility.set_location('In saveAttachment', 1);
1919: if(p_transaction_id is not null) then
1920:
1921: hr_utility.set_location('p_transaction_id :' || p_transaction_id, 1);
1922:
1923: if (getAttachToEntity(p_transaction_id)) then
1924: hr_utility.set_location('In getAttachToEntity true', 1);
1925:

Line 1924: hr_utility.set_location('In getAttachToEntity true', 1);

1920:
1921: hr_utility.set_location('p_transaction_id :' || p_transaction_id, 1);
1922:
1923: if (getAttachToEntity(p_transaction_id)) then
1924: hr_utility.set_location('In getAttachToEntity true', 1);
1925:
1926: OPEN csr_hat;
1927: FETCH csr_hat INTO trans_row ;
1928: CLOSE csr_hat;

Line 1936: hr_utility.set_location('l_api_name :' || l_api_name, 1);

1932: CLOSE csr_hat_steps;
1933:
1934: l_api_name := step_row.api_name;
1935:
1936: hr_utility.set_location('l_api_name :' || l_api_name, 1);
1937:
1938: if(l_api_name = 'HR_LOA_SS.PROCESS_API' OR
1939: l_api_name = 'HR_PERSON_ABSENCE_SWI.PROCESS_API') then
1940:

Line 1973: hr_utility.set_location('l_pk_value is null' , 1);

1969: l_pk_value := trans_row.selected_person_id;
1970:
1971:
1972: if( l_pk_value is null) then
1973: hr_utility.set_location('l_pk_value is null' , 1);
1974:
1975: l_pk_value := hr_process_person_ss.g_person_id;
1976: end if;
1977:

Line 2000: hr_utility.set_location('l_pk_value :' || l_pk_value, 1);

1996: l_pk_value := l_period_of_serv_id;
1997:
1998: end if;
1999:
2000: hr_utility.set_location('l_pk_value :' || l_pk_value, 1);
2001:
2002:
2003: merge_attachments (p_dest_entity_name => l_entity_name
2004: ,p_source_pk1_value => trans_row.transaction_id

Line 2104: g_debug := hr_utility.debug_enabled;

2100: IS
2101: c_proc constant varchar2(30) := 'getUpgradeCheck';
2102: lv_is_upgrade hr_api_transaction_steps.Information30%type;
2103: begin
2104: g_debug := hr_utility.debug_enabled;
2105: if g_debug then
2106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2107: end if;
2108:

Line 2106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

2102: lv_is_upgrade hr_api_transaction_steps.Information30%type;
2103: begin
2104: g_debug := hr_utility.debug_enabled;
2105: if g_debug then
2106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2107: end if;
2108:
2109: if(p_transaction_id is not null) then
2110: begin

Line 2124: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

2120: end;
2121: end if;
2122:
2123: if g_debug then
2124: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2125: end if;
2126:
2127: return lv_is_upgrade;
2128:

Line 2131: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

2127: return lv_is_upgrade;
2128:
2129: exception
2130: when others then
2131: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2132: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2133: -- raise;
2134: return null;
2135: end getUpgradeCheck;

Line 2254: hr_utility.set_location('Entering: '|| l_proc,5);

2250: where DESCRIPTIVE_FLEXFIELD_NAME = 'Extra Person Info DDF'
2251: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US_ETHNIC_ORIGIN';
2252:
2253: BEGIN
2254: hr_utility.set_location('Entering: '|| l_proc,5);
2255:
2256: OPEN ethnic_dff;
2257: FETCH ethnic_dff INTO l_eth_dff_exists;
2258:

Line 2266: hr_utility.set_location('l_person_id: '|| l_person_id,5);

2262: itemtype => itemtype,
2263: itemkey => itemkey,
2264: aname => 'CURRENT_PERSON_ID');
2265:
2266: hr_utility.set_location('l_person_id: '|| l_person_id,5);
2267:
2268: if l_person_id is null then
2269:
2270: hr_utility.set_location('l_person_id: is not null',5);

Line 2270: hr_utility.set_location('l_person_id: is not null',5);

2266: hr_utility.set_location('l_person_id: '|| l_person_id,5);
2267:
2268: if l_person_id is null then
2269:
2270: hr_utility.set_location('l_person_id: is not null',5);
2271: open csr_txn_step_id;
2272: fetch csr_txn_step_id into l_transaction_step_id;
2273: close csr_txn_step_id;
2274:

Line 2279: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,5);

2275: l_business_grp_Id :=hr_transaction_api.get_number_value
2276: (p_transaction_step_id => l_transaction_step_id
2277: ,p_name => 'P_BUSINESS_GROUP_ID');
2278:
2279: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,5);
2280:
2281: else
2282:
2283: select BUSINESS_GROUP_ID into l_business_grp_id from per_all_people_f where

Line 2286: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,6);

2282:
2283: select BUSINESS_GROUP_ID into l_business_grp_id from per_all_people_f where
2284: person_id = l_person_id and trunc(sysdate) between effective_start_date and effective_end_date;
2285:
2286: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,6);
2287: end if;
2288:
2289:
2290: l_leg_code := hr_api.return_legislation_code(l_business_grp_id);

Line 2292: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);

2288:
2289:
2290: l_leg_code := hr_api.return_legislation_code(l_business_grp_id);
2291:
2292: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);
2293:
2294:
2295: if l_leg_code = 'US'
2296: then

Line 2306: hr_utility.set_location('Leaving: '|| l_proc,10);

2302: ELSE
2303: resultout := 'COMPLETE:'|| 'N';
2304: END IF;
2305: --
2306: hr_utility.set_location('Leaving: '|| l_proc,10);
2307:
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310:

Line 2311: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2307:
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310:
2311: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2312: WF_CORE.CONTEXT (
2313: g_package,
2314: 'is_us_emp_check',
2315: itemtype,

Line 2333: hr_utility.set_location('Entering: '|| l_proc,5);

2329:
2330: l_proc constant varchar2(100) := g_package || ' is_basic_det_chg';
2331:
2332: BEGIN
2333: hr_utility.set_location('Entering: '|| l_proc,5);
2334:
2335:
2336:
2337: select BUSINESS_GROUP_ID into l_business_group_id from per_all_people_f where

Line 2340: hr_utility.set_location('l_business_group_id: ' || l_business_group_id,6);

2336:
2337: select BUSINESS_GROUP_ID into l_business_group_id from per_all_people_f where
2338: person_id = p_person_id and trunc(sysdate) between effective_start_date and effective_end_date;
2339:
2340: hr_utility.set_location('l_business_group_id: ' || l_business_group_id,6);
2341:
2342: l_leg_code := hr_api.return_legislation_code(l_business_group_id);
2343:
2344: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);

Line 2344: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);

2340: hr_utility.set_location('l_business_group_id: ' || l_business_group_id,6);
2341:
2342: l_leg_code := hr_api.return_legislation_code(l_business_group_id);
2343:
2344: hr_utility.set_location('l_leg_code: ' || l_leg_code,5);
2345:
2346:
2347: if l_leg_code = 'US'
2348: then

Line 2354: hr_utility.set_location('Leaving: '|| l_proc,10);

2350: else
2351: return 'N';
2352: end if;
2353: --
2354: hr_utility.set_location('Leaving: '|| l_proc,10);
2355:
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358:

Line 2359: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

2355:
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358:
2359: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
2360: RAISE;
2361: END is_basic_det_chg;
2362:
2363:

Line 2376: -- hr_utility.trace_on(null,'ORCL');

2372: l_asg_id number(10);
2373: --l_job_name varchar2(100) := null;
2374: l_job_name per_jobs_tl.name%type := ''; --14592612
2375: begin
2376: -- hr_utility.trace_on(null,'ORCL');
2377: hr_utility.set_location('Entering: getJobNameNew', 30);
2378: hr_utility.set_location(' p_rptg_grp_id' ||p_rptg_grp_id, 30);
2379: -- if rptg_grp_id is null
2380:

Line 2377: hr_utility.set_location('Entering: getJobNameNew', 30);

2373: --l_job_name varchar2(100) := null;
2374: l_job_name per_jobs_tl.name%type := ''; --14592612
2375: begin
2376: -- hr_utility.trace_on(null,'ORCL');
2377: hr_utility.set_location('Entering: getJobNameNew', 30);
2378: hr_utility.set_location(' p_rptg_grp_id' ||p_rptg_grp_id, 30);
2379: -- if rptg_grp_id is null
2380:
2381: if(p_rptg_grp_id is not null and p_plan_id is null) then

Line 2378: hr_utility.set_location(' p_rptg_grp_id' ||p_rptg_grp_id, 30);

2374: l_job_name per_jobs_tl.name%type := ''; --14592612
2375: begin
2376: -- hr_utility.trace_on(null,'ORCL');
2377: hr_utility.set_location('Entering: getJobNameNew', 30);
2378: hr_utility.set_location(' p_rptg_grp_id' ||p_rptg_grp_id, 30);
2379: -- if rptg_grp_id is null
2380:
2381: if(p_rptg_grp_id is not null and p_plan_id is null) then
2382: begin

Line 2383: hr_utility.set_location('Before selecting job_id from paf', 30);

2379: -- if rptg_grp_id is null
2380:
2381: if(p_rptg_grp_id is not null and p_plan_id is null) then
2382: begin
2383: hr_utility.set_location('Before selecting job_id from paf', 30);
2384: select job_id into l_job_id from per_all_assignments_f paf
2385: where assignment_id = p_rptg_grp_id
2386: and sysdate between paf.effective_start_date and paf.effective_end_date;
2387: exception

Line 2389: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);

2385: where assignment_id = p_rptg_grp_id
2386: and sysdate between paf.effective_start_date and paf.effective_end_date;
2387: exception
2388: when others then
2389: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);
2390:
2391: end;
2392: if(l_job_id is not null) then
2393: hr_utility.set_location('before calling jobname the second time', 30);

Line 2393: hr_utility.set_location('before calling jobname the second time', 30);

2389: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);
2390:
2391: end;
2392: if(l_job_id is not null) then
2393: hr_utility.set_location('before calling jobname the second time', 30);
2394: l_job_name := getJobName(l_job_id, p_bg_id);
2395: hr_utility.set_location('After getJob name 2 l_job_name:'|| l_job_name, 30);
2396: end if;
2397:

Line 2395: hr_utility.set_location('After getJob name 2 l_job_name:'|| l_job_name, 30);

2391: end;
2392: if(l_job_id is not null) then
2393: hr_utility.set_location('before calling jobname the second time', 30);
2394: l_job_name := getJobName(l_job_id, p_bg_id);
2395: hr_utility.set_location('After getJob name 2 l_job_name:'|| l_job_name, 30);
2396: end if;
2397:
2398:
2399: else

Line 2437: hr_utility.set_location('E2 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);

2433: and sysdate between paf.effective_start_date and paf.effective_end_date;
2434:
2435: exception
2436: when others then
2437: hr_utility.set_location('E2 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);
2438:
2439: end;
2440: if(l_position_id is not null) then
2441: l_position_name := getPositionName(l_position_id, p_bg_id);

Line 2473: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);

2469: and sysdate between paf.effective_start_date and paf.effective_end_date;
2470:
2471: exception
2472: when others then
2473: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);
2474:
2475: end;
2476: if(l_grade_id is not null) then
2477: l_grade_name := getGradeName(l_grade_id, p_bg_id);

Line 2510: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);

2506: and sysdate between paf.effective_start_date and paf.effective_end_date;
2507:
2508: exception
2509: when others then
2510: hr_utility.set_location('E2 :'|| 'An error was encountered -'||SQLCODE||' -ERROR- '||SQLERRM, 30);
2511:
2512: end;
2513: if(l_org_id is not null) then
2514: l_org_name := getOrgName(l_org_id, p_bg_id);

Line 2536: -- hr_utility.trace_on(null,'ORCL');

2532: l_loc_id per_all_assignments_f.Location_ID%type := -1; --14592612
2533: --l_loc_name varchar2(100) := null;
2534: l_loc_name hr_locations_all_tl.location_code%type := ''; --14592612
2535: begin
2536: -- hr_utility.trace_on(null,'ORCL');
2537: if(p_rptg_grp_id is not null and p_plan_id is null) then
2538: begin
2539:
2540: select Location_ID into l_loc_id from per_all_assignments_f paf

Line 2546: hr_utility.set_location('E2 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);

2542: and sysdate between paf.effective_start_date and paf.effective_end_date;
2543:
2544: exception
2545: when others then
2546: hr_utility.set_location('E2 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);
2547:
2548: end;
2549: if(l_loc_id is not null) then
2550: l_loc_name := getLocName(l_loc_id, p_bg_id);

Line 2580: hr_utility.set_location('E2 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);

2576: and sysdate between paf.effective_start_date and paf.effective_end_date;
2577:
2578: exception
2579: when others then
2580: hr_utility.set_location('E2 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);
2581:
2582: end;
2583:
2584: else

Line 2592: hr_utility.set_location('E3 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);

2588: and sysdate between paf.effective_start_date and paf.effective_end_date;
2589:
2590: exception
2591: when others then
2592: hr_utility.set_location('E3 :'|| 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM, 30);
2593:
2594: end;
2595: end if;
2596:

Line 2623: g_debug := hr_utility.debug_enabled;

2619: lv_item_key wf_item_activity_statuses.item_key%type;
2620: lv_activity_id wf_item_activity_statuses.process_activity%type;
2621: dummy varchar2(10) := null;
2622: begin
2623: g_debug := hr_utility.debug_enabled;
2624: if g_debug then
2625: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2626: end if;
2627:

Line 2625: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

2621: dummy varchar2(10) := null;
2622: begin
2623: g_debug := hr_utility.debug_enabled;
2624: if g_debug then
2625: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2626: end if;
2627:
2628: -- get the itemtype and item key for the notification id
2629: begin

Line 2663: hr_utility.set_location('hr_util_misc_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

2659: p_itemKey := lv_item_key;
2660:
2661: exception
2662: when others then
2663: hr_utility.set_location('hr_util_misc_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2664: Wf_Core.Context('hr_util_misc_ss', 'get_item_type_and_key', p_transaction_id);
2665: raise;
2666: end get_item_type_and_key;
2667:

Line 2685: g_debug := hr_utility.debug_enabled;

2681: l_transaction_ref_table VARCHAR2(50);
2682: l_transaction_ref_id NUMBER;
2683: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2684: begin
2685: g_debug := hr_utility.debug_enabled;
2686:
2687: if g_debug then
2688: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2689: end if;

Line 2688: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

2684: begin
2685: g_debug := hr_utility.debug_enabled;
2686:
2687: if g_debug then
2688: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2689: end if;
2690: begin
2691: select text_value
2692: into lv_result_code

Line 2705: hr_utility.trace('txn_ref_table: '||l_transaction_ref_table);

2701: c_transaction_id := wf_engine.getitemattrnumber(p_item_type,p_item_key,'TRANSACTION_ID');
2702: OPEN csr_txn(c_transaction_id);
2703: FETCH csr_txn INTO l_transaction_ref_table,l_transaction_ref_id;
2704: CLOSE csr_txn;
2705: hr_utility.trace('txn_ref_table: '||l_transaction_ref_table);
2706: IF NVL(l_transaction_ref_table,'XXX') = 'PER_APPRAISALS' and lv_result_code = 'DEL' THEN
2707: hr_utility.trace('returning with resubmit as we donot want SFL deletion for appraisal');
2708: result := 'COMPLETE:XYZ'; --so that this takes the default option in the WF
2709: RETURN;

Line 2707: hr_utility.trace('returning with resubmit as we donot want SFL deletion for appraisal');

2703: FETCH csr_txn INTO l_transaction_ref_table,l_transaction_ref_id;
2704: CLOSE csr_txn;
2705: hr_utility.trace('txn_ref_table: '||l_transaction_ref_table);
2706: IF NVL(l_transaction_ref_table,'XXX') = 'PER_APPRAISALS' and lv_result_code = 'DEL' THEN
2707: hr_utility.trace('returning with resubmit as we donot want SFL deletion for appraisal');
2708: result := 'COMPLETE:XYZ'; --so that this takes the default option in the WF
2709: RETURN;
2710: END IF;
2711: if g_debug then

Line 2712: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

2708: result := 'COMPLETE:XYZ'; --so that this takes the default option in the WF
2709: RETURN;
2710: END IF;
2711: if g_debug then
2712: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2713: end if;
2714: ---END Changes by KMG
2715: end setApprSFLResponseContext;
2716:

Line 2795: hr_utility.set_location('ENTERING get_bprv', 10);

2791: l_item_value varchar2(200);
2792:
2793: BEGIN
2794:
2795: hr_utility.set_location('ENTERING get_bprv', 10);
2796: IF (funcmode='RUN') THEN
2797: l_item_value := wf_engine.getItemAttrText(itemtype => itemtype
2798: ,itemkey => itemkey
2799: , aname => 'BYPASS_REVIEW');

Line 2806: hr_utility.trace('l_resultout' || resultout);

2802: resultout:='COMPLETE:N';
2803: else
2804: resultout:='COMPLETE:Y';
2805: end if;
2806: hr_utility.trace('l_resultout' || resultout);
2807:
2808:
2809: RETURN;
2810: END IF; --RUN

Line 2818: hr_utility.set_location('ENTERING exception get_bprv', 10);

2814: RETURN;
2815: END IF;
2816: Exception
2817: when others then
2818: hr_utility.set_location('ENTERING exception get_bprv', 10);
2819:
2820:
2821: end get_wf_bprv;
2822: