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_TIMECARD_DEPOSIT dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_timecard_deposit AS
2: /* $Header: hxctimedp.pkb 120.10.12010000.3 2008/11/13 11:52:46 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Procedure add_transaction_info
7: (p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
8: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type

Line 706: hr_utility.trace(' Entering is_duplicate_block .. ');

702: isDuplicate boolean := false;
703:
704: Begin
705:
706: hr_utility.trace(' Entering is_duplicate_block .. ');
707: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);
708: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);
709:
710: l_index := p_blocks.first;

Line 707: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);

703:
704: Begin
705:
706: hr_utility.trace(' Entering is_duplicate_block .. ');
707: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);
708: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);
709:
710: l_index := p_blocks.first;
711:

Line 708: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);

704: Begin
705:
706: hr_utility.trace(' Entering is_duplicate_block .. ');
707: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);
708: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);
709:
710: l_index := p_blocks.first;
711:
712: LOOP

Line 715: hr_utility.trace(' l_index is : ' || l_index);

711:
712: LOOP
713: EXIT WHEN not p_blocks.exists(l_index) or isDuplicate;
714:
715: hr_utility.trace(' l_index is : ' || l_index);
716:
717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);

Line 717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);

713: EXIT WHEN not p_blocks.exists(l_index) or isDuplicate;
714:
715: hr_utility.trace(' l_index is : ' || l_index);
716:
717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);

Line 718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);

714:
715: hr_utility.trace(' l_index is : ' || l_index);
716:
717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
722: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);

Line 719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);

715: hr_utility.trace(' l_index is : ' || l_index);
716:
717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
722: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
723:

Line 720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);

716:
717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
722: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
723:
724: if(p_blocks(l_index).scope = 'DETAIL'

Line 721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);

717: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
722: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
723:
724: if(p_blocks(l_index).scope = 'DETAIL'
725: AND p_blocks(l_index).time_building_block_id <> p_block_new.time_building_block_id

Line 722: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);

718: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
719: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
720: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
721: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
722: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
723:
724: if(p_blocks(l_index).scope = 'DETAIL'
725: AND p_blocks(l_index).time_building_block_id <> p_block_new.time_building_block_id
726: AND p_blocks(l_index).date_to = fnd_date.date_to_canonical(hr_general.end_of_time)

Line 734: hr_utility.trace(' DUPLICATE is TRUE ');

730: AND p_block_new.translation_display_key is NOT NULL
731: AND p_blocks(l_index).translation_display_key = p_block_new.translation_display_key
732: )
733: then
734: hr_utility.trace(' DUPLICATE is TRUE ');
735: isDuplicate := true;
736: end if;
737:
738: l_index := p_blocks.next(l_index);

Line 742: hr_utility.trace(' DUPLICATE is FALSE ');

738: l_index := p_blocks.next(l_index);
739: END LOOP;
740:
741: if(NOT isDuplicate) then
742: hr_utility.trace(' DUPLICATE is FALSE ');
743: end if;
744:
745: return isDuplicate;
746:

Line 782: hr_utility.trace(' DUPLICATE BLOCK is TRUE ');

778:
779: l_block := p_blocks(p_detail_blocks(l_index));
780:
781: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then
782: hr_utility.trace(' DUPLICATE BLOCK is TRUE ');
783: l_duplicate_block := true;
784: end if;
785:
786: l_index := p_detail_blocks.next(l_index);

Line 792: hr_utility.trace(' Adding error to table for block : ' || l_block.time_building_block_id);

788: END LOOP;
789:
790: IF(l_duplicate_block) THEN
791:
792: hr_utility.trace(' Adding error to table for block : ' || l_block.time_building_block_id);
793: hxc_timecard_message_helper.addErrorToCollection
794: (p_messages
795: ,'HXC_DUP_TIME_BUILDING_BLOCKS'
796: ,hxc_timecard.c_error

Line 1218: hr_utility.trace(p_transaction_info(l_index).time_building_block_id||'-'||p_transaction_info(l_index).data_set_id);

1214:
1215: While l_index is not null loop
1216: p_transaction_info(l_index).data_set_id := l_data_set_id;
1217: if g_debug then
1218: hr_utility.trace(p_transaction_info(l_index).time_building_block_id||'-'||p_transaction_info(l_index).data_set_id);
1219: end if;
1220: l_index := p_transaction_info.next(l_index);
1221: End loop;
1222:

Line 1257: g_debug := hr_utility.debug_enabled;

1253:
1254:
1255: Begin
1256:
1257: g_debug := hr_utility.debug_enabled;
1258:
1259: -- A new Savepoint has been introduced to makesure we rollback the
1260: -- block transaction incase of any exception being thrown.
1261: savepoint deposit_timecard;

Line 1264: hr_utility.trace('*InvalidSecurityContext Trace Start**************');

1260: -- block transaction incase of any exception being thrown.
1261: savepoint deposit_timecard;
1262:
1263:
1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);

Line 1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));

1261: savepoint deposit_timecard;
1262:
1263:
1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:

Line 1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));

1262:
1263:
1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,

Line 1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);

1263:
1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));

Line 1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);

1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1272: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;

Line 1275: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);

1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1272: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1273: close c_check_bussiness_group_id;
1274:
1275: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);
1276: hr_utility.trace('InvalidSecurityContext > ORG_ID of the person : '||l_organization_id);
1277:
1278: IF l_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') THEN
1279:

Line 1276: hr_utility.trace('InvalidSecurityContext > ORG_ID of the person : '||l_organization_id);

1272: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1273: close c_check_bussiness_group_id;
1274:
1275: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);
1276: hr_utility.trace('InvalidSecurityContext > ORG_ID of the person : '||l_organization_id);
1277:
1278: IF l_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') THEN
1279:
1280: hxc_timecard_message_helper.addErrorToCollection

Line 1292: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');

1288: ,null
1289: ,null
1290: ,null
1291: );
1292: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');
1293:
1294: ELSE
1295: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');
1296: l_deleted_blocks.delete;

Line 1295: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');

1291: );
1292: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');
1293:
1294: ELSE
1295: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');
1296: l_deleted_blocks.delete;
1297: -- Blocks have to be in order, to ensure
1298: -- self referential integrity
1299:

Line 1317: hr_utility.trace('*InvalidSecurityContext Trace End*****************');

1313: -- Maintain the timecard summary structures
1314: populate_transaction_data_set(p_transaction_info);
1315:
1316: END IF;
1317: hr_utility.trace('*********************InvalidSecurityContext Trace End*************************************');
1318:
1319:
1320: Exception
1321: When Others then