1615: l_detailovn_right := NULL;
1616:
1617: -- End new code for Bug 2889097
1618:
1619: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1621: 'Number of BBs '||p_time_building_blocks.count);
1622: end if;
1623:
1616:
1617: -- End new code for Bug 2889097
1618:
1619: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1621: 'Number of BBs '||p_time_building_blocks.count);
1622: end if;
1623:
1624: l_cnt := p_time_building_blocks.first ;
1640: l_start_day_period := l_start_time;
1641: l_end_day_period := l_stop_time;
1642: END IF;
1643:
1644: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1646: 'Outer Loop BB_ID '||l_bb_id);
1647: end if;
1648: --
1641: l_end_day_period := l_stop_time;
1642: END IF;
1643:
1644: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1646: 'Outer Loop BB_ID '||l_bb_id);
1647: end if;
1648: --
1649: -- Check for Overlap Time for DETAIL blocks of type RANGE and start_time
1653: l_start_time is NOT NULL AND l_stop_time is NOT NULL AND
1654: l_date_to = hr_general.end_of_time ) THEN
1655:
1656: --
1657: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1659: 'Outer is a DETAIL RANGE');
1660: end if;
1661:
1654: l_date_to = hr_general.end_of_time ) THEN
1655:
1656: --
1657: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1659: 'Outer is a DETAIL RANGE');
1660: end if;
1661:
1662: -- Keep track of earliest / latest building block start / stop times
1698: l_scope_detail := p_time_building_blocks(l_detail).SCOPE;
1699: l_date_to_detail := p_time_building_blocks(l_detail).DATE_TO;
1700: l_detail_ovn := p_time_building_blocks(l_detail).OBJECT_VERSION_NUMBER; --added for bug 2796204
1701:
1702: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1704: 'Inner Loop BB_ID '||l_bb_id_detail);
1705: end if;
1706: --
1699: l_date_to_detail := p_time_building_blocks(l_detail).DATE_TO;
1700: l_detail_ovn := p_time_building_blocks(l_detail).OBJECT_VERSION_NUMBER; --added for bug 2796204
1701:
1702: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1704: 'Inner Loop BB_ID '||l_bb_id_detail);
1705: end if;
1706: --
1707: IF (l_scope_detail = 'DETAIL' AND l_type_detail = 'RANGE'
1707: IF (l_scope_detail = 'DETAIL' AND l_type_detail = 'RANGE'
1708: AND l_start_detail is NOT NULL AND l_stop_detail is NOT NULL AND
1709: l_date_to_detail = hr_general.end_of_time ) THEN
1710: --
1711: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1713: 'Inner is a DETAIL RANGE');
1714: end if;
1715:
1708: AND l_start_detail is NOT NULL AND l_stop_detail is NOT NULL AND
1709: l_date_to_detail = hr_general.end_of_time ) THEN
1710: --
1711: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1713: 'Inner is a DETAIL RANGE');
1714: end if;
1715:
1716: IF (l_stop_time > l_start_detail AND
1716: IF (l_stop_time > l_start_detail AND
1717: l_start_time < l_stop_detail AND
1718: l_bb_id <> l_bb_id_detail)
1719: THEN
1720: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1721: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1722: 'Overlap Detected');
1723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1724: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1717: l_start_time < l_stop_detail AND
1718: l_bb_id <> l_bb_id_detail)
1719: THEN
1720: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1721: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1722: 'Overlap Detected');
1723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1724: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1725: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1719: THEN
1720: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1721: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1722: 'Overlap Detected');
1723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1724: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1725: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1726: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1721: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1722: 'Overlap Detected');
1723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1724: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1725: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1726: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1728: 'Start BB Inner '||to_char(l_start_detail,'DD-MON-YYYY:HH24:MI'));
1729: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1724: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1725: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1726: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1728: 'Start BB Inner '||to_char(l_start_detail,'DD-MON-YYYY:HH24:MI'));
1729: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1730: 'Stop BB Inner '||to_char(l_stop_detail,'DD-MON-YYYY:HH24:MI'));
1731: end if;
1725: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1726: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1728: 'Start BB Inner '||to_char(l_start_detail,'DD-MON-YYYY:HH24:MI'));
1729: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1730: 'Stop BB Inner '||to_char(l_stop_detail,'DD-MON-YYYY:HH24:MI'));
1731: end if;
1732: --
1733: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1836: -- End new code for Bug 2889097
1837: END IF;
1838: END LOOP;
1839:
1840: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1842: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1844: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1837: END IF;
1838: END LOOP;
1839:
1840: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1842: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1844: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1839:
1840: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1842: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1844: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1846: 'DAY_BEFORE:'||to_char(trunc(l_start_day_period-1)));
1847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1842: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1844: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1846: 'DAY_BEFORE:'||to_char(trunc(l_start_day_period-1)));
1847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1848: 'DAY_AFTER:'||to_char(trunc(l_end_day_period+1)));
1849: end if;
1843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1844: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1846: 'DAY_BEFORE:'||to_char(trunc(l_start_day_period-1)));
1847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1848: 'DAY_AFTER:'||to_char(trunc(l_end_day_period+1)));
1849: end if;
1850:
1851: -- Start commented code for Bug 2889097
2232: THEN
2233: if g_debug then
2234: hr_utility.set_location('Processing '||l_proc, 40);
2235: end if;
2236: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'hxc_time_entry_rules', 'after 40');
2238: end if;
2239:
2240: -- GPM v115.87
2233: if g_debug then
2234: hr_utility.set_location('Processing '||l_proc, 40);
2235: end if;
2236: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'hxc_time_entry_rules', 'after 40');
2238: end if;
2239:
2240: -- GPM v115.87
2241: