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

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXC_LOCK_UTIL AS
2: /* $Header: hxclockutil.pkb 120.3 2005/09/23 05:19:29 nissharm noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: -- ----------------------------------------------------------------------------
7: -- |---------------------------< check_parameters > ----------------------|
8: -- ----------------------------------------------------------------------------

Line 349: g_debug := hr_utility.debug_enabled;

345: l_result BOOLEAN := FALSE;
346:
347: BEGIN
348: /*
349: g_debug := hr_utility.debug_enabled;
350:
351: if g_debug then
352:
353: hr_utility.trace('p_lock_session_id '||p_lock_session_id);

Line 353: hr_utility.trace('p_lock_session_id '||p_lock_session_id);

349: g_debug := hr_utility.debug_enabled;
350:
351: if g_debug then
352:
353: hr_utility.trace('p_lock_session_id '||p_lock_session_id);
354: hr_utility.trace('p_current_session_id '||p_current_session_id);
355: hr_utility.trace('p_current_user_id '||p_current_user_id);
356: hr_utility.trace('p_lock_user_id '||p_lock_user_id);
357: end if;

Line 354: hr_utility.trace('p_current_session_id '||p_current_session_id);

350:
351: if g_debug then
352:
353: hr_utility.trace('p_lock_session_id '||p_lock_session_id);
354: hr_utility.trace('p_current_session_id '||p_current_session_id);
355: hr_utility.trace('p_current_user_id '||p_current_user_id);
356: hr_utility.trace('p_lock_user_id '||p_lock_user_id);
357: end if;
358: */

Line 355: hr_utility.trace('p_current_user_id '||p_current_user_id);

351: if g_debug then
352:
353: hr_utility.trace('p_lock_session_id '||p_lock_session_id);
354: hr_utility.trace('p_current_session_id '||p_current_session_id);
355: hr_utility.trace('p_current_user_id '||p_current_user_id);
356: hr_utility.trace('p_lock_user_id '||p_lock_user_id);
357: end if;
358: */
359: IF (p_current_resource_id = p_lock_resource_id and

Line 356: hr_utility.trace('p_lock_user_id '||p_lock_user_id);

352:
353: hr_utility.trace('p_lock_session_id '||p_lock_session_id);
354: hr_utility.trace('p_current_session_id '||p_current_session_id);
355: hr_utility.trace('p_current_user_id '||p_current_user_id);
356: hr_utility.trace('p_lock_user_id '||p_lock_user_id);
357: end if;
358: */
359: IF (p_current_resource_id = p_lock_resource_id and
360: p_current_user_id = p_lock_user_id) THEN

Line 439: g_debug := hr_utility.debug_enabled;

435: PRAGMA AUTONOMOUS_TRANSACTION;
436:
437: BEGIN
438:
439: g_debug := hr_utility.debug_enabled;
440:
441: --dbms_output.put_line('JOEL - insert_lock 1 p_start_time '||p_start_time);
442: --dbms_output.put_line('JOEL - insert_lock 1 p_stop_time '||p_stop_time);
443:

Line 445: hr_utility.trace('JOEL - insert_lock 1 p_start_time '||p_start_time);

441: --dbms_output.put_line('JOEL - insert_lock 1 p_start_time '||p_start_time);
442: --dbms_output.put_line('JOEL - insert_lock 1 p_stop_time '||p_stop_time);
443:
444: if g_debug then
445: hr_utility.trace('JOEL - insert_lock 1 p_start_time '||p_start_time);
446: end if;
447:
448: insert into hxc_locks
449: (LOCKER_TYPE_ID

Line 508: g_debug := hr_utility.debug_enabled;

504: l_locker_type_id NUMBER;
505:
506: BEGIN
507:
508: g_debug := hr_utility.debug_enabled;
509:
510: -- we need to check what is the scope of the rowid
511: -- and following the scope then we might need
512: -- to delete some parents

Line 517: hr_utility.trace('JOEL - delete_lock 0 ');

513:
514:
515:
516: if g_debug then
517: hr_utility.trace('JOEL - delete_lock 0 ');
518: end if;
519:
520:
521: OPEN c_rowid_info;

Line 526: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);

522: FETCH c_rowid_info INTO l_scope,l_app_period_id,l_locker_type_id;
523: CLOSE c_rowid_info;
524:
525: if g_debug then
526: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);
527: hr_utility.trace('JOEL - delete_lock 1 '||l_scope);
528:
529: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);
530: end if;

Line 527: hr_utility.trace('JOEL - delete_lock 1 '||l_scope);

523: CLOSE c_rowid_info;
524:
525: if g_debug then
526: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);
527: hr_utility.trace('JOEL - delete_lock 1 '||l_scope);
528:
529: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);
530: end if;
531:

Line 529: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);

525: if g_debug then
526: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);
527: hr_utility.trace('JOEL - delete_lock 1 '||l_scope);
528:
529: hr_utility.trace('JOEL - delete_lock 1 '||l_app_period_id);
530: end if;
531:
532: IF l_scope = 'APPLICATION_PERIOD' THEN
533: -- we need to delete the childs

Line 546: hr_utility.trace('JOEL - delete_lock 2 '||l_locker_type_id);

542: END IF;
543: END IF;
544:
545: if g_debug then
546: hr_utility.trace('JOEL - delete_lock 2 '||l_locker_type_id);
547: end if;
548:
549: FOR crs_app_period_detail in c_app_period_detail(l_app_period_id)
550: LOOP

Line 553: hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_id);

549: FOR crs_app_period_detail in c_app_period_detail(l_app_period_id)
550: LOOP
551:
552: if g_debug then
553: hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_id);
554: hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_ovn);
555: end if;
556:
557: -- if we arrive here that means we did not find a detail

Line 554: hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_ovn);

550: LOOP
551:
552: if g_debug then
553: hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_id);
554: hr_utility.trace('JOEL - delete_lock 3 '||crs_app_period_detail.time_building_block_ovn);
555: end if;
556:
557: -- if we arrive here that means we did not find a detail
558: -- locked and then we can insert a new lock

Line 748: g_debug := hr_utility.debug_enabled;

744: l_locked_same_user_session BOOLEAN := FALSE;
745:
746: BEGIN
747:
748: g_debug := hr_utility.debug_enabled;
749:
750: --dbms_output.put_line('JOEL - check_row_lock 0: '||p_time_building_block_id);
751: --dbms_output.put_line('JOEL - check_row_lock 0: '||p_time_building_block_ovn);
752:

Line 754: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_id);

750: --dbms_output.put_line('JOEL - check_row_lock 0: '||p_time_building_block_id);
751: --dbms_output.put_line('JOEL - check_row_lock 0: '||p_time_building_block_ovn);
752:
753: if g_debug then
754: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_id);
755: end if;
756:
757: FOR csr_lock in c_lock(p_time_building_block_id,p_time_building_block_ovn) LOOP
758:

Line 764: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_id);

760: --dbms_output.put_line('JOEL - check_row_lock 1: l_lock_date '||csr_lock.lock_date);
761: --dbms_output.put_line('JOEL - check_row_lock 1: l_lock_rowid '||csr_lock.rowid);
762: -- we found the lock
763: if g_debug then
764: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_id);
765: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_ovn);
766: end if;
767:
768: --dbms_output.put_line('JOEL - check_row_lock 2 ');

Line 765: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_ovn);

761: --dbms_output.put_line('JOEL - check_row_lock 1: l_lock_rowid '||csr_lock.rowid);
762: -- we found the lock
763: if g_debug then
764: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_id);
765: hr_utility.trace('JOEL - check_row_lock 0: '||p_time_building_block_ovn);
766: end if;
767:
768: --dbms_output.put_line('JOEL - check_row_lock 2 ');
769:

Line 798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);

794: END IF;
795: /*
796:
797: if g_debug then
798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));
801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);
802: end if;

Line 799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);

795: /*
796:
797: if g_debug then
798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));
801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);
802: end if;
803:

Line 800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));

796:
797: if g_debug then
798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));
801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);
802: end if;
803:
804: IF (l_locked_same_user_session) THEN

Line 801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);

797: if g_debug then
798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));
801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);
802: end if;
803:
804: IF (l_locked_same_user_session) THEN
805: if g_debug then

Line 806: hr_utility.trace('l_locked_same_user_session is true');

802: end if;
803:
804: IF (l_locked_same_user_session) THEN
805: if g_debug then
806: hr_utility.trace('l_locked_same_user_session is true');
807: end if;
808: END IF;
809:
810:

Line 824: hr_utility.trace('JOEL - check_row_lock 3 '||l_grant);

820: ,p_grant_lock => l_grant
821: );
822:
823: if g_debug then
824: hr_utility.trace('JOEL - check_row_lock 3 '||l_grant);
825: end if;
826:
827: IF l_grant = 'N' THEN
828:

Line 857: hr_utility.trace('JOEL - check_row_lock 4 ');

853: ELSE
854: -- we need to remove the row just found
855: -- and insert the new lock
856: if g_debug then
857: hr_utility.trace('JOEL - check_row_lock 4 ');
858: hr_utility.trace('JOEL - delete_lock 1 ');
859: end if;
860:
861: hxc_lock_util.delete_lock

Line 858: hr_utility.trace('JOEL - delete_lock 1 ');

854: -- we need to remove the row just found
855: -- and insert the new lock
856: if g_debug then
857: hr_utility.trace('JOEL - check_row_lock 4 ');
858: hr_utility.trace('JOEL - delete_lock 1 ');
859: end if;
860:
861: hxc_lock_util.delete_lock
862: (p_rowid => csr_lock.rowid

Line 871: hr_utility.trace('JOEL - check_row_lock 5 ');

867: END IF;
868: ELSE
869:
870: if g_debug then
871: hr_utility.trace('JOEL - check_row_lock 5 ');
872: end if;
873:
874: -- we need to remove the row just found
875: -- and insert the new lock

Line 877: hr_utility.trace('JOEL - delete_lock 2 ');

873:
874: -- we need to remove the row just found
875: -- and insert the new lock
876: if g_debug then
877: hr_utility.trace('JOEL - delete_lock 2 ');
878: end if;
879: hxc_lock_util.delete_lock
880: (p_rowid => csr_lock.rowid
881: ,p_locker_type_id => csr_lock.locker_type_id

Line 931: g_debug := hr_utility.debug_enabled;

927: l_locked_same_user_session BOOLEAN := FALSE;
928:
929: BEGIN
930:
931: g_debug := hr_utility.debug_enabled;
932:
933: if g_debug then
934: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_requestor_id '||p_locker_type_requestor_id);
935: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_owner_id '||p_locker_type_owner_id);

Line 934: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_requestor_id '||p_locker_type_requestor_id);

930:
931: g_debug := hr_utility.debug_enabled;
932:
933: if g_debug then
934: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_requestor_id '||p_locker_type_requestor_id);
935: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_owner_id '||p_locker_type_owner_id);
936: hr_utility.trace('JOEL - check_date_lock 1: p_lock_date '||p_lock_date);
937: end if;
938: -- we found the lock

Line 935: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_owner_id '||p_locker_type_owner_id);

931: g_debug := hr_utility.debug_enabled;
932:
933: if g_debug then
934: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_requestor_id '||p_locker_type_requestor_id);
935: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_owner_id '||p_locker_type_owner_id);
936: hr_utility.trace('JOEL - check_date_lock 1: p_lock_date '||p_lock_date);
937: end if;
938: -- we found the lock
939:

Line 936: hr_utility.trace('JOEL - check_date_lock 1: p_lock_date '||p_lock_date);

932:
933: if g_debug then
934: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_requestor_id '||p_locker_type_requestor_id);
935: hr_utility.trace('JOEL - check_date_lock 1: p_locker_type_owner_id '||p_locker_type_owner_id);
936: hr_utility.trace('JOEL - check_date_lock 1: p_lock_date '||p_lock_date);
937: end if;
938: -- we found the lock
939:
940: -- this procedure check if the lock is not expire

Line 967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);

963: END IF;
964: /*
965:
966: if g_debug then
967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));
970: hr_utility.trace('p_lock_user_id '||p_process_id);
971: end if;

Line 968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);

964: /*
965:
966: if g_debug then
967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));
970: hr_utility.trace('p_lock_user_id '||p_process_id);
971: end if;
972:

Line 969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));

965:
966: if g_debug then
967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));
970: hr_utility.trace('p_lock_user_id '||p_process_id);
971: end if;
972:
973: IF (l_locked_same_user_session) THEN

Line 970: hr_utility.trace('p_lock_user_id '||p_process_id);

966: if g_debug then
967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));
970: hr_utility.trace('p_lock_user_id '||p_process_id);
971: end if;
972:
973: IF (l_locked_same_user_session) THEN
974: if g_debug then

Line 975: hr_utility.trace('l_locked_same_user_session is true');

971: end if;
972:
973: IF (l_locked_same_user_session) THEN
974: if g_debug then
975: hr_utility.trace('l_locked_same_user_session is true');
976: end if;
977: END IF;
978: */
979:

Line 993: hr_utility.trace('JOEL - check_date_lock 3 '||l_grant);

989: ,p_grant_lock => l_grant
990: );
991:
992: if g_debug then
993: hr_utility.trace('JOEL - check_date_lock 3 '||l_grant);
994: end if;
995:
996:
997: IF l_grant = 'N' THEN

Line 1000: hr_utility.trace('JOEL - check_date_lock 4 ');

996:
997: IF l_grant = 'N' THEN
998:
999: if g_debug then
1000: hr_utility.trace('JOEL - check_date_lock 4 ');
1001:
1002: hr_utility.trace('JOEL - check_date_lock 5: p_lock_start_time '||p_lock_start_time);
1003: hr_utility.trace('JOEL - check_date_lock 5: p_lock_stop_time '||p_lock_stop_time);
1004: hr_utility.trace('JOEL - check_date_lock 5: p_start_time '||p_start_time);

Line 1002: hr_utility.trace('JOEL - check_date_lock 5: p_lock_start_time '||p_lock_start_time);

998:
999: if g_debug then
1000: hr_utility.trace('JOEL - check_date_lock 4 ');
1001:
1002: hr_utility.trace('JOEL - check_date_lock 5: p_lock_start_time '||p_lock_start_time);
1003: hr_utility.trace('JOEL - check_date_lock 5: p_lock_stop_time '||p_lock_stop_time);
1004: hr_utility.trace('JOEL - check_date_lock 5: p_start_time '||p_start_time);
1005: hr_utility.trace('JOEL - check_date_lock 5: p_stop_time '||p_stop_time);
1006: end if;

Line 1003: hr_utility.trace('JOEL - check_date_lock 5: p_lock_stop_time '||p_lock_stop_time);

999: if g_debug then
1000: hr_utility.trace('JOEL - check_date_lock 4 ');
1001:
1002: hr_utility.trace('JOEL - check_date_lock 5: p_lock_start_time '||p_lock_start_time);
1003: hr_utility.trace('JOEL - check_date_lock 5: p_lock_stop_time '||p_lock_stop_time);
1004: hr_utility.trace('JOEL - check_date_lock 5: p_start_time '||p_start_time);
1005: hr_utility.trace('JOEL - check_date_lock 5: p_stop_time '||p_stop_time);
1006: end if;
1007:

Line 1004: hr_utility.trace('JOEL - check_date_lock 5: p_start_time '||p_start_time);

1000: hr_utility.trace('JOEL - check_date_lock 4 ');
1001:
1002: hr_utility.trace('JOEL - check_date_lock 5: p_lock_start_time '||p_lock_start_time);
1003: hr_utility.trace('JOEL - check_date_lock 5: p_lock_stop_time '||p_lock_stop_time);
1004: hr_utility.trace('JOEL - check_date_lock 5: p_start_time '||p_start_time);
1005: hr_utility.trace('JOEL - check_date_lock 5: p_stop_time '||p_stop_time);
1006: end if;
1007:
1008: -- bug 3097592.

Line 1005: hr_utility.trace('JOEL - check_date_lock 5: p_stop_time '||p_stop_time);

1001:
1002: hr_utility.trace('JOEL - check_date_lock 5: p_lock_start_time '||p_lock_start_time);
1003: hr_utility.trace('JOEL - check_date_lock 5: p_lock_stop_time '||p_lock_stop_time);
1004: hr_utility.trace('JOEL - check_date_lock 5: p_start_time '||p_start_time);
1005: hr_utility.trace('JOEL - check_date_lock 5: p_stop_time '||p_stop_time);
1006: end if;
1007:
1008: -- bug 3097592.
1009:

Line 1022: hr_utility.trace('JOEL - check_date_lock 6 ');

1018: THEN
1019: -- bug 3097592.
1020:
1021: if g_debug then
1022: hr_utility.trace('JOEL - check_date_lock 6 ');
1023: end if;
1024:
1025: p_row_locked := TRUE;
1026:

Line 1053: hr_utility.trace('JOEL - delete_lock 4 ');

1049: ELSE
1050: -- we need to remove the row just found
1051: -- and insert the new lock
1052: if g_debug then
1053: hr_utility.trace('JOEL - delete_lock 4 ');
1054: end if;
1055: hxc_lock_util.delete_lock
1056: (p_rowid => p_rowid
1057: ,p_locker_type_id => p_locker_type_owner_id

Line 1071: hr_utility.trace('JOEL - delete_lock 5 ');

1067:
1068: -- we need to remove the row just found
1069: -- and insert the new lock
1070: if g_debug then
1071: hr_utility.trace('JOEL - delete_lock 5 ');
1072: end if;
1073: hxc_lock_util.delete_lock
1074: (p_rowid => p_rowid
1075: ,p_locker_type_id => p_locker_type_owner_id