1068:
1069:
1070: Begin
1071:
1072: IF (nvl(fnd_profile.value('HXC_DEBUG_CHECK_ENABLED'), 'N') = 'Y') THEN -- 8888138
1073:
1074: -- Checking for duplicate records for detail blocks
1075: l_index := p_detail_blocks.first;
1076:
1094: END IF;
1095:
1096: l_wrong_line := check_for_wrong_line(p_blocks,p_attributes);
1097:
1098: END IF; -- end of IF (nvl(fnd_profile.value('HXC_DEBUG_CHECK_ENABLED'), 'N') = 'Y') THEN
1099:
1100: -- Added for Bug 14478207
1101: IF l_wrong_line THEN
1102:
1622: savepoint deposit_timecard;
1623:
1624:
1625: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1623:
1624:
1625: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1635:
1636: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);
1637: hr_utility.trace('InvalidSecurityContext > ORG_ID of the person : '||l_organization_id);
1638:
1639: IF l_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') THEN
1640:
1641: hxc_timecard_message_helper.addErrorToCollection
1642: (p_messages
1643: ,'HXC_366551_INVALID_SEC_CONTEXT' -- You cannot submit this timecard because of invalid security context. Please logout and try again or contact your system administrator.
1649: ,null
1650: ,null
1651: ,null
1652: );
1653: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');
1654:
1655: ELSE
1656: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');
1657: l_deleted_blocks.delete;
1652: );
1653: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');
1654:
1655: ELSE
1656: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');
1657: l_deleted_blocks.delete;
1658:
1659: -- OTL - ABS Integration
1660: IF hxc_retrieve_absences.g_detail_trans_tab.COUNT > 0