DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on FND_LOG

Line 1674: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1670: l_detailovn_right := NULL;
1671:
1672: -- End new code for Bug 2889097
1673:
1674: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1676: 'Number of BBs '||p_time_building_blocks.count);
1677: end if;
1678:

Line 1675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',

1671:
1672: -- End new code for Bug 2889097
1673:
1674: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1676: 'Number of BBs '||p_time_building_blocks.count);
1677: end if;
1678:
1679: l_cnt := p_time_building_blocks.first ;

Line 1699: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1695: l_start_day_period := l_start_time;
1696: l_end_day_period := l_stop_time;
1697: END IF;
1698:
1699: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1701: 'Outer Loop BB_ID '||l_bb_id);
1702: end if;
1703: --

Line 1700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',

1696: l_end_day_period := l_stop_time;
1697: END IF;
1698:
1699: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECK_TIME_OVERLAPS',
1701: 'Outer Loop BB_ID '||l_bb_id);
1702: end if;
1703: --
1704: -- Check for Overlap Time for DETAIL blocks of type RANGE and start_time

Line 1712: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1708: l_start_time is NOT NULL AND l_stop_time is NOT NULL AND
1709: l_date_to = hr_general.end_of_time ) THEN
1710:
1711: --
1712: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1714: 'Outer is a DETAIL RANGE');
1715: end if;
1716:

Line 1713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1709: l_date_to = hr_general.end_of_time ) THEN
1710:
1711: --
1712: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1714: 'Outer is a DETAIL RANGE');
1715: end if;
1716:
1717: -- Keep track of earliest / latest building block start / stop times

Line 1757: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1753: l_scope_detail := p_time_building_blocks(l_detail).SCOPE;
1754: l_date_to_detail := p_time_building_blocks(l_detail).DATE_TO;
1755: l_detail_ovn := p_time_building_blocks(l_detail).OBJECT_VERSION_NUMBER; --added for bug 2796204
1756:
1757: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1759: 'Inner Loop BB_ID '||l_bb_id_detail);
1760: end if;
1761: --

Line 1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1754: l_date_to_detail := p_time_building_blocks(l_detail).DATE_TO;
1755: l_detail_ovn := p_time_building_blocks(l_detail).OBJECT_VERSION_NUMBER; --added for bug 2796204
1756:
1757: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1759: 'Inner Loop BB_ID '||l_bb_id_detail);
1760: end if;
1761: --
1762: IF (l_scope_detail = 'DETAIL' AND l_type_detail = 'RANGE'

Line 1766: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1762: IF (l_scope_detail = 'DETAIL' AND l_type_detail = 'RANGE'
1763: AND l_start_detail is NOT NULL AND l_stop_detail is NOT NULL AND
1764: l_date_to_detail = hr_general.end_of_time ) THEN
1765: --
1766: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1768: 'Inner is a DETAIL RANGE');
1769: end if;
1770:

Line 1767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1763: AND l_start_detail is NOT NULL AND l_stop_detail is NOT NULL AND
1764: l_date_to_detail = hr_general.end_of_time ) THEN
1765: --
1766: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1768: 'Inner is a DETAIL RANGE');
1769: end if;
1770:
1771: IF (l_stop_time > l_start_detail AND

Line 1775: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1771: IF (l_stop_time > l_start_detail AND
1772: l_start_time < l_stop_detail AND
1773: l_bb_id <> l_bb_id_detail)
1774: THEN
1775: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1777: 'Overlap Detected');
1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1779: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));

Line 1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1772: l_start_time < l_stop_detail AND
1773: l_bb_id <> l_bb_id_detail)
1774: THEN
1775: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1777: 'Overlap Detected');
1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1779: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1774: THEN
1775: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1777: 'Overlap Detected');
1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1779: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1781: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1776: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1777: 'Overlap Detected');
1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1779: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1781: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1783: 'Start BB Inner '||to_char(l_start_detail,'DD-MON-YYYY:HH24:MI'));
1784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1779: 'Start BB Outer '||to_char(l_start_time,'DD-MON-YYYY:HH24:MI'));
1780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1781: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1783: 'Start BB Inner '||to_char(l_start_detail,'DD-MON-YYYY:HH24:MI'));
1784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1785: 'Stop BB Inner '||to_char(l_stop_detail,'DD-MON-YYYY:HH24:MI'));
1786: end if;

Line 1784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1781: 'Stop BB Outer '||to_char(l_stop_time,'DD-MON-YYYY:HH24:MI'));
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1783: 'Start BB Inner '||to_char(l_start_detail,'DD-MON-YYYY:HH24:MI'));
1784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1785: 'Stop BB Inner '||to_char(l_stop_detail,'DD-MON-YYYY:HH24:MI'));
1786: end if;
1787: --
1788: hxc_time_entry_rules_utils_pkg.add_error_to_table (

Line 1895: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1891: -- End new code for Bug 2889097
1892: END IF;
1893: END LOOP;
1894:
1895: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1896: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1897: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1899: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));

Line 1896: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1892: END IF;
1893: END LOOP;
1894:
1895: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1896: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1897: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1899: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1900: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1894:
1895: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1896: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1897: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1899: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1900: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1901: 'DAY_BEFORE:'||to_char(trunc(l_start_day_period-1)));
1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

Line 1900: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1896: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1897: 'L_TC_EARLIEST:'||to_char(l_earliest_tc,'DD-MON:HH24:MI'));
1898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1899: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1900: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1901: 'DAY_BEFORE:'||to_char(trunc(l_start_day_period-1)));
1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1903: 'DAY_AFTER:'||to_char(trunc(l_end_day_period+1)));
1904: end if;

Line 1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',

1898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1899: 'L_TC_LATEST:'||to_char(l_latest_tc,'DD-MON:HH24:MI'));
1900: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1901: 'DAY_BEFORE:'||to_char(trunc(l_start_day_period-1)));
1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_CHECKTIME_OVERLAPS',
1903: 'DAY_AFTER:'||to_char(trunc(l_end_day_period+1)));
1904: end if;
1905:
1906: -- Start commented code for Bug 2889097

Line 2291: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2287: THEN
2288: if g_debug then
2289: hr_utility.set_location('Processing '||l_proc, 40);
2290: end if;
2291: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'hxc_time_entry_rules', 'after 40');
2293: end if;
2294:
2295: -- GPM v115.87

Line 2292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'hxc_time_entry_rules', 'after 40');

2288: if g_debug then
2289: hr_utility.set_location('Processing '||l_proc, 40);
2290: end if;
2291: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'hxc_time_entry_rules', 'after 40');
2293: end if;
2294:
2295: -- GPM v115.87
2296: