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.

[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_timekeeper_utilities AS
2: /* $Header: hxctkutil.pkb 120.15.12010000.4 2008/11/13 16:59:07 asrajago ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: -------------------------------------------------------------------------------
5: -- this procedure add a block in the block_table
6: -------- -----------------------------------------------------------------------
7: PROCEDURE add_block (

Line 436: g_debug :=hr_utility.debug_enabled;

432: AND z.status = 'I'
433: AND d.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX';
434:
435: BEGIN
436: g_debug :=hr_utility.debug_enabled;
437: --get the number say 3 FROM ATTRIBUTE3 using substr function
438: att_dep_item := TO_NUMBER (SUBSTR (p_base_dff, 10));
439: if g_debug then
440: hr_utility.trace('att_dep_item is '||att_dep_item);

Line 440: hr_utility.trace('att_dep_item is '||att_dep_item);

436: g_debug :=hr_utility.debug_enabled;
437: --get the number say 3 FROM ATTRIBUTE3 using substr function
438: att_dep_item := TO_NUMBER (SUBSTR (p_base_dff, 10));
439: if g_debug then
440: hr_utility.trace('att_dep_item is '||att_dep_item);
441: hr_utility.trace('in detail is '||p_insert_detail.attr_id_3);
442: end if;
443: ---depending upon the number select id value from the timecard block
444: -- for 3 it will be attr_id_3

Line 441: hr_utility.trace('in detail is '||p_insert_detail.attr_id_3);

437: --get the number say 3 FROM ATTRIBUTE3 using substr function
438: att_dep_item := TO_NUMBER (SUBSTR (p_base_dff, 10));
439: if g_debug then
440: hr_utility.trace('att_dep_item is '||att_dep_item);
441: hr_utility.trace('in detail is '||p_insert_detail.attr_id_3);
442: end if;
443: ---depending upon the number select id value from the timecard block
444: -- for 3 it will be attr_id_3
445: IF att_dep_item = 1 THEN

Line 490: hr_utility.trace('new cat is '||new_att_catg);

486: new_att_catg := p_insert_detail.attr_id_20;
487: END IF;
488:
489: if g_debug then
490: hr_utility.trace('new cat is '||new_att_catg);
491: end if;
492: IF new_att_catg IS NOT NULL THEN
493: l_reference_field := NULL;
494: if g_debug then

Line 495: hr_utility.trace('new cat is '||new_att_catg);

491: end if;
492: IF new_att_catg IS NOT NULL THEN
493: l_reference_field := NULL;
494: if g_debug then
495: hr_utility.trace('new cat is '||new_att_catg);
496: end if;
497: OPEN c_reference_field;
498: FETCH c_reference_field INTO l_reference_field;
499: CLOSE c_reference_field;

Line 558: hr_utility.trace('return new cat is '||new_att_catg);

554: FROM DUAL;
555: end if;
556: end if;*/
557: if g_debug then
558: hr_utility.trace('return new cat is '||new_att_catg);
559: end if;
560: RETURN (new_att_catg);
561: END;
562:

Line 1040: g_debug :=hr_utility.debug_enabled;

1036: l_emp_start_date DATE;
1037: l_emp_terminate_date DATE;
1038: l_audit_enabled VARCHAR2 (150);
1039: BEGIN
1040: g_debug :=hr_utility.debug_enabled;
1041: newtab.DELETE;
1042: if g_debug then
1043: hr_utility.trace('p_resource_id '||p_resource_id);
1044: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));

Line 1043: hr_utility.trace('p_resource_id '||p_resource_id);

1039: BEGIN
1040: g_debug :=hr_utility.debug_enabled;
1041: newtab.DELETE;
1042: if g_debug then
1043: hr_utility.trace('p_resource_id '||p_resource_id);
1044: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));
1045: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));
1046: end if;
1047: l_emp_negpref := NULL;

Line 1044: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));

1040: g_debug :=hr_utility.debug_enabled;
1041: newtab.DELETE;
1042: if g_debug then
1043: hr_utility.trace('p_resource_id '||p_resource_id);
1044: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));
1045: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));
1046: end if;
1047: l_emp_negpref := NULL;
1048: l_emp_recpref := NULL;

Line 1045: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));

1041: newtab.DELETE;
1042: if g_debug then
1043: hr_utility.trace('p_resource_id '||p_resource_id);
1044: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));
1045: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));
1046: end if;
1047: l_emp_negpref := NULL;
1048: l_emp_recpref := NULL;
1049: l_emp_appstyle := NULL;

Line 1081: hr_utility.trace(' just checking cout'||p_spemp_tc_info.count);

1077: l_audit_enabled
1078: );
1079:
1080: if g_debug then
1081: hr_utility.trace(' just checking cout'||p_spemp_tc_info.count);
1082: end if;
1083: IF p_spemp_tc_info.COUNT > 0 THEN --this means the person is a mid period change
1084: --and we need to split the timecard.
1085: if g_debug then

Line 1086: hr_utility.trace('get the periods');

1082: end if;
1083: IF p_spemp_tc_info.COUNT > 0 THEN --this means the person is a mid period change
1084: --and we need to split the timecard.
1085: if g_debug then
1086: hr_utility.trace('get the periods');
1087: end if;
1088:
1089: get_resource_time_periods (
1090: p_resource_id => p_resource_id,

Line 1102: hr_utility.trace('newtab.count'||newtab.count);

1098: );
1099: --New tab contains the timecard periods in that range through which
1100: --we loop and save the timecard
1101: if g_debug then
1102: hr_utility.trace('newtab.count'||newtab.count);
1103: end if;
1104: emp_tab_index := p_spemp_tc_info.FIRST;
1105:
1106: LOOP

Line 1110: hr_utility.trace(emp_tab_index);

1106: LOOP
1107: EXIT WHEN NOT p_spemp_tc_info.EXISTS (emp_tab_index);
1108:
1109: if g_debug then
1110: hr_utility.trace(emp_tab_index);
1111: end if;
1112: IF TO_NUMBER (emp_tab_index) < TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))
1113: OR TO_NUMBER (emp_tab_index) > TO_NUMBER (TO_CHAR (TO_DATE (p_end_date, 'dd-mm-rrrr'), 'J')) THEN
1114: --remove the rows from the pl/sql table table which are out of range

Line 1119: hr_utility.trace('in delete emptab ');

1115: --incomplete timecard
1116: IF newtab.EXISTS (emp_tab_index) THEN
1117: newtab.DELETE (emp_tab_index);
1118: if g_debug then
1119: hr_utility.trace('in delete emptab ');
1120: end if;
1121: END IF;
1122: END IF;
1123:

Line 1129: hr_utility.trace('mid hire employee1 ');

1125: END LOOP;
1126: ELSE
1127: IF TO_DATE (TRUNC (p_start_date), 'dd-mm-rrrr') < TO_DATE (l_emp_start_date, 'dd-mm-rrrr') THEN
1128: if g_debug then
1129: hr_utility.trace('mid hire employee1 ');
1130: hr_utility.trace('p_start_date'|| l_emp_start_date);
1131: end if;
1132: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).start_date := l_emp_start_date;
1133: /* changes done by senthil for emp terminate enhancement*/

Line 1130: hr_utility.trace('p_start_date'|| l_emp_start_date);

1126: ELSE
1127: IF TO_DATE (TRUNC (p_start_date), 'dd-mm-rrrr') < TO_DATE (l_emp_start_date, 'dd-mm-rrrr') THEN
1128: if g_debug then
1129: hr_utility.trace('mid hire employee1 ');
1130: hr_utility.trace('p_start_date'|| l_emp_start_date);
1131: end if;
1132: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).start_date := l_emp_start_date;
1133: /* changes done by senthil for emp terminate enhancement*/
1134: IF TO_DATE (TRUNC (p_end_date), 'dd-mm-rrrr') > TO_DATE (nvl(l_emp_terminate_date,p_end_date), 'dd-mm-rrrr') THEN

Line 1136: hr_utility.trace('Terminated employee ');

1132: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).start_date := l_emp_start_date;
1133: /* changes done by senthil for emp terminate enhancement*/
1134: IF TO_DATE (TRUNC (p_end_date), 'dd-mm-rrrr') > TO_DATE (nvl(l_emp_terminate_date,p_end_date), 'dd-mm-rrrr') THEN
1135: if g_debug then
1136: hr_utility.trace('Terminated employee ');
1137: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1138: end if;
1139: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1140: else

Line 1137: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));

1133: /* changes done by senthil for emp terminate enhancement*/
1134: IF TO_DATE (TRUNC (p_end_date), 'dd-mm-rrrr') > TO_DATE (nvl(l_emp_terminate_date,p_end_date), 'dd-mm-rrrr') THEN
1135: if g_debug then
1136: hr_utility.trace('Terminated employee ');
1137: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1138: end if;
1139: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1140: else
1141: if g_debug then

Line 1142: hr_utility.trace(' Normal employee ');

1138: end if;
1139: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1140: else
1141: if g_debug then
1142: hr_utility.trace(' Normal employee ');
1143: hr_utility.trace('p_end_date'|| p_end_date);
1144: end if;
1145: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).end_date := p_end_date;
1146: end if;

Line 1143: hr_utility.trace('p_end_date'|| p_end_date);

1139: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1140: else
1141: if g_debug then
1142: hr_utility.trace(' Normal employee ');
1143: hr_utility.trace('p_end_date'|| p_end_date);
1144: end if;
1145: newtab (TO_NUMBER (TO_CHAR (TO_DATE (l_emp_start_date, 'dd-mm-rrrr'), 'J'))).end_date := p_end_date;
1146: end if;
1147: /* end of changes made by senthil */

Line 1150: hr_utility.trace(' Normal employee ');

1146: end if;
1147: /* end of changes made by senthil */
1148: ELSE
1149: if g_debug then
1150: hr_utility.trace(' Normal employee ');
1151: hr_utility.trace('p_start_date'|| p_start_date);
1152: end if;
1153: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).start_date := p_start_date;
1154: /* changes done by senthil for emp terminate enhancement*/

Line 1151: hr_utility.trace('p_start_date'|| p_start_date);

1147: /* end of changes made by senthil */
1148: ELSE
1149: if g_debug then
1150: hr_utility.trace(' Normal employee ');
1151: hr_utility.trace('p_start_date'|| p_start_date);
1152: end if;
1153: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).start_date := p_start_date;
1154: /* changes done by senthil for emp terminate enhancement*/
1155: IF TO_DATE (TRUNC (p_end_date), 'dd-mm-rrrr') > TO_DATE (nvl(l_emp_terminate_date,p_end_date), 'dd-mm-rrrr') THEN

Line 1157: hr_utility.trace('Terminated employee ');

1153: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).start_date := p_start_date;
1154: /* changes done by senthil for emp terminate enhancement*/
1155: IF TO_DATE (TRUNC (p_end_date), 'dd-mm-rrrr') > TO_DATE (nvl(l_emp_terminate_date,p_end_date), 'dd-mm-rrrr') THEN
1156: if g_debug then
1157: hr_utility.trace('Terminated employee ');
1158: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1159: end if;
1160: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1161: else

Line 1158: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));

1154: /* changes done by senthil for emp terminate enhancement*/
1155: IF TO_DATE (TRUNC (p_end_date), 'dd-mm-rrrr') > TO_DATE (nvl(l_emp_terminate_date,p_end_date), 'dd-mm-rrrr') THEN
1156: if g_debug then
1157: hr_utility.trace('Terminated employee ');
1158: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1159: end if;
1160: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1161: else
1162: if g_debug then

Line 1163: hr_utility.trace(' Normal employee ');

1159: end if;
1160: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1161: else
1162: if g_debug then
1163: hr_utility.trace(' Normal employee ');
1164: hr_utility.trace('p_end_date'|| p_end_date);
1165: end if;
1166: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).end_date := p_end_date;
1167: end if;

Line 1164: hr_utility.trace('p_end_date'|| p_end_date);

1160: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1161: else
1162: if g_debug then
1163: hr_utility.trace(' Normal employee ');
1164: hr_utility.trace('p_end_date'|| p_end_date);
1165: end if;
1166: newtab (TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))).end_date := p_end_date;
1167: end if;
1168: /* end of changes made by senthil */

Line 1173: hr_utility.trace('newtab.count'||newtab.count);

1169: end if;
1170:
1171: END IF;
1172: if g_debug then
1173: hr_utility.trace('newtab.count'||newtab.count);
1174: end if;
1175: p_tc_list := newtab;
1176:
1177: if g_debug then

Line 1178: hr_utility.trace('p_tc_list.count'||p_tc_list.count);

1174: end if;
1175: p_tc_list := newtab;
1176:
1177: if g_debug then
1178: hr_utility.trace('p_tc_list.count'||p_tc_list.count);
1179: end if;
1180: END;
1181:
1182:

Line 1676: g_debug :=hr_utility.debug_enabled;

1672: l_first_rowindex NUMBER(15);
1673: l_last_rowindex NUMBER(15);
1674: l_term_tc_exists NUMBER(15);
1675: BEGIN
1676: g_debug :=hr_utility.debug_enabled;
1677: --
1678: -- look for the recurring period type
1679: --
1680: OPEN c_period_info (p_recurring_period_id => p_recurring_period_id);

Line 1708: hr_utility.trace('terminate end_date'||NVL(l_person_effective_end_date,p_max_date_in_futur));

1704: END IF;
1705: --2789497
1706: /* changes done by senthil for emp terminate enhancement*/
1707: IF g_debug THEN
1708: hr_utility.trace('terminate end_date'||NVL(l_person_effective_end_date,p_max_date_in_futur));
1709: END if;
1710: IF p_max_date_in_futur >= NVL(l_person_effective_end_date,p_max_date_in_futur) THEN
1711: l_emp_max_date_in_futur := NVL(l_person_effective_end_date,p_max_date_in_futur);
1712: ELSE

Line 1716: hr_utility.trace('p_max_date_in_futur'||p_max_date_in_futur);

1712: ELSE
1713: l_emp_max_date_in_futur := p_max_date_in_futur;
1714: END IF;
1715: IF g_debug THEN
1716: hr_utility.trace('p_max_date_in_futur'||p_max_date_in_futur);
1717: hr_utility.trace('l_emp_max_date_in_futur'||l_emp_max_date_in_futur);
1718: END if;
1719: /* Changes done by senthil */
1720:

Line 1717: hr_utility.trace('l_emp_max_date_in_futur'||l_emp_max_date_in_futur);

1713: l_emp_max_date_in_futur := p_max_date_in_futur;
1714: END IF;
1715: IF g_debug THEN
1716: hr_utility.trace('p_max_date_in_futur'||p_max_date_in_futur);
1717: hr_utility.trace('l_emp_max_date_in_futur'||l_emp_max_date_in_futur);
1718: END if;
1719: /* Changes done by senthil */
1720:
1721: ELSE

Line 1876: hr_utility.trace('###################');

1872: LOOP
1873: EXIT WHEN NOT l_temp_periods.EXISTS (l_index);
1874: if g_debug then
1875:
1876: hr_utility.trace('###################');
1877: hr_utility.trace('#### NEW PERIOD #########');
1878: hr_utility.trace('###################');
1879: end if;
1880: l_period_start := l_temp_periods (l_index).start_date;

Line 1877: hr_utility.trace('#### NEW PERIOD #########');

1873: EXIT WHEN NOT l_temp_periods.EXISTS (l_index);
1874: if g_debug then
1875:
1876: hr_utility.trace('###################');
1877: hr_utility.trace('#### NEW PERIOD #########');
1878: hr_utility.trace('###################');
1879: end if;
1880: l_period_start := l_temp_periods (l_index).start_date;
1881: l_period_end := l_temp_periods (l_index).end_date;

Line 1878: hr_utility.trace('###################');

1874: if g_debug then
1875:
1876: hr_utility.trace('###################');
1877: hr_utility.trace('#### NEW PERIOD #########');
1878: hr_utility.trace('###################');
1879: end if;
1880: l_period_start := l_temp_periods (l_index).start_date;
1881: l_period_end := l_temp_periods (l_index).end_date;
1882: -- help to know if during the process the period

Line 1894: hr_utility.trace('####NEW TIMECARD');

1890: EXIT WHEN NOT l_timecard_tab.EXISTS (l_index_timecard_tab);
1891: l_tc_period_start_date := l_timecard_tab (l_index_timecard_tab).start_date;
1892: l_tc_period_end_date := l_timecard_tab (l_index_timecard_tab).end_date;
1893: if g_debug then
1894: hr_utility.trace('####NEW TIMECARD');
1895: hr_utility.trace('l_period_start :'||l_period_start);
1896: hr_utility.trace('l_period_end :'||l_period_end);
1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));

Line 1895: hr_utility.trace('l_period_start :'||l_period_start);

1891: l_tc_period_start_date := l_timecard_tab (l_index_timecard_tab).start_date;
1892: l_tc_period_end_date := l_timecard_tab (l_index_timecard_tab).end_date;
1893: if g_debug then
1894: hr_utility.trace('####NEW TIMECARD');
1895: hr_utility.trace('l_period_start :'||l_period_start);
1896: hr_utility.trace('l_period_end :'||l_period_end);
1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1899: hr_utility.trace('###################');

Line 1896: hr_utility.trace('l_period_end :'||l_period_end);

1892: l_tc_period_end_date := l_timecard_tab (l_index_timecard_tab).end_date;
1893: if g_debug then
1894: hr_utility.trace('####NEW TIMECARD');
1895: hr_utility.trace('l_period_start :'||l_period_start);
1896: hr_utility.trace('l_period_end :'||l_period_end);
1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1899: hr_utility.trace('###################');
1900: end if;

Line 1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));

1893: if g_debug then
1894: hr_utility.trace('####NEW TIMECARD');
1895: hr_utility.trace('l_period_start :'||l_period_start);
1896: hr_utility.trace('l_period_end :'||l_period_end);
1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1899: hr_utility.trace('###################');
1900: end if;
1901: IF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)

Line 1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));

1894: hr_utility.trace('####NEW TIMECARD');
1895: hr_utility.trace('l_period_start :'||l_period_start);
1896: hr_utility.trace('l_period_end :'||l_period_end);
1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1899: hr_utility.trace('###################');
1900: end if;
1901: IF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1902: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN

Line 1899: hr_utility.trace('###################');

1895: hr_utility.trace('l_period_start :'||l_period_start);
1896: hr_utility.trace('l_period_end :'||l_period_end);
1897: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1898: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1899: hr_utility.trace('###################');
1900: end if;
1901: IF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1902: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN
1903: -- the timecard is in the middle of a period

Line 1908: hr_utility.trace('case 1 :');

1904: -- we are splitting the period in 2 + the timecard which
1905: -- is already there.
1906: -- before the timecard
1907: if g_debug then
1908: hr_utility.trace('case 1 :');
1909: end if;
1910: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
1911: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_tc_period_start_date - 1;
1912: if g_debug then

Line 1913: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));

1909: end if;
1910: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
1911: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_tc_period_start_date - 1;
1912: if g_debug then
1913: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1914: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1915: end if;
1916: -- after the timecard
1917: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=

Line 1914: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));

1910: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
1911: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_tc_period_start_date - 1;
1912: if g_debug then
1913: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1914: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1915: end if;
1916: -- after the timecard
1917: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=
1918: l_tc_period_end_date + 1;

Line 1923: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));

1919: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).end_date := l_period_end;
1920: -- now we are overritting the start period
1921: l_period_start := l_tc_period_end_date + 1;
1922: if g_debug then
1923: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1924: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1925: end if;
1926: l_touch_period_in_tc := TRUE;
1927: ELSIF TRUNC (l_tc_period_start_date) < TRUNC (l_period_start)

Line 1924: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));

1920: -- now we are overritting the start period
1921: l_period_start := l_tc_period_end_date + 1;
1922: if g_debug then
1923: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1924: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1925: end if;
1926: l_touch_period_in_tc := TRUE;
1927: ELSIF TRUNC (l_tc_period_start_date) < TRUNC (l_period_start)
1928: AND TRUNC (l_tc_period_end_date) > TRUNC (l_period_end) THEN

Line 1933: hr_utility.trace('case 2 :');

1929: -- the timecard is outside of the period so we have nothing to
1930: -- do
1931: l_touch_period_in_tc := TRUE;
1932: if g_debug then
1933: hr_utility.trace('case 2 :');
1934: end if;
1935: ELSIF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1936: AND TRUNC (l_tc_period_start_date) <= TRUNC (l_period_end)
1937: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_end) THEN

Line 1939: hr_utility.trace('case 3 :');

1935: ELSIF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1936: AND TRUNC (l_tc_period_start_date) <= TRUNC (l_period_end)
1937: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_end) THEN
1938: if g_debug then
1939: hr_utility.trace('case 3 :');
1940: end if;
1941: -- we are splitting the period in 2
1942: -- we are adding the period just before the timecard
1943: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;

Line 1949: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));

1945: -- in this case we can exit of the loop;
1946: l_index_timecard_tab := l_timecard_tab.LAST;
1947: l_touch_period_in_tc := TRUE;
1948: if g_debug then
1949: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1950: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1951: end if;
1952: ELSIF TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1953: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_start)

Line 1950: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));

1946: l_index_timecard_tab := l_timecard_tab.LAST;
1947: l_touch_period_in_tc := TRUE;
1948: if g_debug then
1949: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1950: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1951: end if;
1952: ELSIF TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1953: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_start)
1954: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN

Line 1956: hr_utility.trace('case 4 :');

1952: ELSIF TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1953: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_start)
1954: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN
1955: if g_debug then
1956: hr_utility.trace('case 4 :');
1957: end if;
1958: -- we are splitting the period in 2
1959: -- we are adding the period just before the timecard
1960: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=

Line 1964: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));

1960: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=
1961: l_tc_period_end_date + 1;
1962: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).end_date := l_period_end;
1963: if g_debug then
1964: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1965: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1966: end if;
1967: -- now we are overritting the end/start period
1968: l_period_start := l_tc_period_end_date + 1;

Line 1965: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));

1961: l_tc_period_end_date + 1;
1962: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).end_date := l_period_end;
1963: if g_debug then
1964: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1965: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1966: end if;
1967: -- now we are overritting the end/start period
1968: l_period_start := l_tc_period_end_date + 1;
1969: l_touch_period_in_tc := TRUE;

Line 1977: hr_utility.trace('case 5 :');

1973: OR ( TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1974: AND TRUNC (l_tc_period_end_date) = TRUNC (l_period_end)
1975: ) THEN
1976: if g_debug then
1977: hr_utility.trace('case 5 :');
1978: end if;
1979: -- we are splitting the period in 2
1980: -- we are adding the period just before the timecard
1981: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_start_date, 'J'))).start_date :=

Line 1999: hr_utility.trace('case 6 :');

1995:
1996:
1997: IF NOT (l_touch_period_in_tc) THEN
1998: if g_debug then
1999: hr_utility.trace('case 6 :');
2000: end if;
2001: -- we are adding the period
2002: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
2003: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_period_end;

Line 2007: hr_utility.trace('count'||p_periodtab.count);

2003: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_period_end;
2004: END IF;
2005:
2006: if g_debug then
2007: hr_utility.trace('count'||p_periodtab.count);
2008: end if;
2009: l_index := l_temp_periods.NEXT (l_index);
2010: END LOOP;
2011:

Line 2084: g_debug :=hr_utility.debug_enabled;

2080: VARCHAR2 (72);
2081: l_tc_status hxc_time_building_blocks.approval_status%TYPE;
2082: l_dummy NUMBER (1);
2083: BEGIN
2084: g_debug :=hr_utility.debug_enabled;
2085: if g_debug then
2086: l_proc := 'hxc_timekeeper_utilities'
2087: || 'tc_edit_allowed';
2088: hr_utility.set_location('Entering '||l_proc, 10);

Line 2088: hr_utility.set_location('Entering '||l_proc, 10);

2084: g_debug :=hr_utility.debug_enabled;
2085: if g_debug then
2086: l_proc := 'hxc_timekeeper_utilities'
2087: || 'tc_edit_allowed';
2088: hr_utility.set_location('Entering '||l_proc, 10);
2089: end if;
2090: --l_tc_status := hxc_timecard_search_pkg.get_timecard_status_code(p_timecard_id,p_Timecard_Ovn);
2091: l_tc_status := p_timecard_status;
2092:

Line 2095: hr_utility.set_location('Processing '||l_proc, 20);

2091: l_tc_status := p_timecard_status;
2092:
2093:
2094: if g_debug then
2095: hr_utility.set_location('Processing '||l_proc, 20);
2096: end if;
2097: IF (p_edit_allowed_preference = 'NEW_WORKING_REJECTED') THEN
2098: if g_debug then
2099: hr_utility.set_location('Processing '||l_proc, 30);

Line 2099: hr_utility.set_location('Processing '||l_proc, 30);

2095: hr_utility.set_location('Processing '||l_proc, 20);
2096: end if;
2097: IF (p_edit_allowed_preference = 'NEW_WORKING_REJECTED') THEN
2098: if g_debug then
2099: hr_utility.set_location('Processing '||l_proc, 30);
2100: end if;
2101: IF ((l_tc_status = 'REJECTED') OR (l_tc_status = 'WORKING')) THEN
2102: p_edit_allowed := 'TRUE';
2103: ELSE

Line 2108: hr_utility.set_location('Processing '||l_proc, 40);

2104: p_edit_allowed := 'FALSE';
2105: END IF;
2106: ELSIF (p_edit_allowed_preference = 'SUBMITTED') THEN
2107: if g_debug then
2108: hr_utility.set_location('Processing '||l_proc, 40);
2109: end if;
2110: IF ((l_tc_status = 'REJECTED') OR (l_tc_status = 'WORKING') OR (l_tc_status = 'SUBMITTED')) THEN
2111: p_edit_allowed := 'TRUE';
2112: ELSE

Line 2117: hr_utility.set_location('Processing '||l_proc, 50);

2113: p_edit_allowed := 'FALSE';
2114: END IF;
2115: ELSIF (p_edit_allowed_preference = 'APPROVALS_INITIATED') THEN
2116: if g_debug then
2117: hr_utility.set_location('Processing '||l_proc, 50);
2118: end if;
2119: -- all we need to do here is check that this timecard
2120: -- has not been transferred successfully to any recipient
2121: -- applications

Line 2132: hr_utility.set_location('Processing '||l_proc, 60);

2128: p_edit_allowed := 'TRUE';
2129: END IF;
2130: ELSIF (p_edit_allowed_preference = 'RETRO') THEN
2131: if g_debug then
2132: hr_utility.set_location('Processing '||l_proc, 60);
2133: end if;
2134: IF ( (l_tc_status = 'REJECTED')
2135: OR (l_tc_status = 'WORKING')
2136: OR (l_tc_status = 'SUBMITTED')

Line 2146: hr_utility.set_location('Processing '||l_proc, 70);

2142: p_edit_allowed := 'FALSE';
2143: END IF;
2144: ELSE
2145: if g_debug then
2146: hr_utility.set_location('Processing '||l_proc, 70);
2147: end if;
2148: p_edit_allowed := 'FALSE';
2149: END IF;
2150:

Line 2159: hr_utility.set_location('Leaving '||l_proc, 80);

2155: p_edit_allowed := 'TRUE';
2156: END IF;
2157:
2158: if g_debug then
2159: hr_utility.set_location('Leaving '||l_proc, 80);
2160: end if;
2161: END tc_edit_allowed;
2162:
2163: PROCEDURE convert_type_to_message_table (