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

Line 5: g_debug boolean :=hr_utility.debug_enabled;

1: Package Body hxc_elp_utils as
2: /* $Header: hxcelputl.pkb 120.4.12000000.2 2007/03/27 12:52:17 anuthi noship $ */
3:
4: -- global package data type and variables
5: g_debug boolean :=hr_utility.debug_enabled;
6: -- public procedure
7:
8:
9: -- ksethi start new proc for appliation set updation

Line 177: g_debug:=hr_utility.debug_enabled;

173: l_in_attr_st binary_integer;
174: l_proc VARCHAR2 (30);
175: BEGIN
176:
177: g_debug:=hr_utility.debug_enabled;
178: if g_debug then
179: l_proc := 'create_reverse_entry';
180: hr_utility.set_location('Processing '||l_proc, 10);
181: END if;

Line 180: hr_utility.set_location('Processing '||l_proc, 10);

176:
177: g_debug:=hr_utility.debug_enabled;
178: if g_debug then
179: l_proc := 'create_reverse_entry';
180: hr_utility.set_location('Processing '||l_proc, 10);
181: END if;
182: FOR c_get_att in c_get_dropped_attribs(P_TIME_BUILDING_BLOCKS (p_index_bb).TIME_BUILDING_BLOCK_ID,
183: P_TIME_BUILDING_BLOCKS (p_index_bb).OBJECT_VERSION_NUMBER)
184: LOOP

Line 222: hr_utility.trace('-----------------------------');

218: P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE28 := c_get_att.ATTRIBUTE28;
219: P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE29 := c_get_att.ATTRIBUTE29;
220: P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE30 := c_get_att.ATTRIBUTE30;
221: IF g_debug then
222: hr_utility.trace('-----------------------------');
223: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | A1 | A2 | A3| TBB_ID| NEW| CHANGED|');
224: hr_utility.trace('-----------------------------');
225: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_in_attr_st).TIME_ATTRIBUTE_ID
226: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BUILDING_BLOCK_ID

Line 223: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | A1 | A2 | A3| TBB_ID| NEW| CHANGED|');

219: P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE29 := c_get_att.ATTRIBUTE29;
220: P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE30 := c_get_att.ATTRIBUTE30;
221: IF g_debug then
222: hr_utility.trace('-----------------------------');
223: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | A1 | A2 | A3| TBB_ID| NEW| CHANGED|');
224: hr_utility.trace('-----------------------------');
225: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_in_attr_st).TIME_ATTRIBUTE_ID
226: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BUILDING_BLOCK_ID
227: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BLD_BLK_INFO_TYPE

Line 224: hr_utility.trace('-----------------------------');

220: P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE30 := c_get_att.ATTRIBUTE30;
221: IF g_debug then
222: hr_utility.trace('-----------------------------');
223: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | A1 | A2 | A3| TBB_ID| NEW| CHANGED|');
224: hr_utility.trace('-----------------------------');
225: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_in_attr_st).TIME_ATTRIBUTE_ID
226: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BUILDING_BLOCK_ID
227: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BLD_BLK_INFO_TYPE
228: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE_CATEGORY

Line 225: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_in_attr_st).TIME_ATTRIBUTE_ID

221: IF g_debug then
222: hr_utility.trace('-----------------------------');
223: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | A1 | A2 | A3| TBB_ID| NEW| CHANGED|');
224: hr_utility.trace('-----------------------------');
225: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_in_attr_st).TIME_ATTRIBUTE_ID
226: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BUILDING_BLOCK_ID
227: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).BLD_BLK_INFO_TYPE
228: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE_CATEGORY
229: ||' | '||P_TIME_ATTRIBUTES(l_in_attr_st).ATTRIBUTE1

Line 242: hr_utility.set_location('Leaving '||l_proc, 20);

238: end loop;
239:
240: END LOOP;
241: if g_debug then
242: hr_utility.set_location('Leaving '||l_proc, 20);
243: END if;
244: END create_reverse_entry;
245:
246: BEGIN

Line 248: g_debug:=hr_utility.debug_enabled;

244: END create_reverse_entry;
245:
246: BEGIN
247: -- Check if Entry Level Processing has been set or not
248: g_debug:=hr_utility.debug_enabled;
249: if g_debug then
250: l_proc := 'set_time_bb_appl_set_id';
251: hr_utility.set_location('Processing '||l_proc, 10);
252: end if;

Line 251: hr_utility.set_location('Processing '||l_proc, 10);

247: -- Check if Entry Level Processing has been set or not
248: g_debug:=hr_utility.debug_enabled;
249: if g_debug then
250: l_proc := 'set_time_bb_appl_set_id';
251: hr_utility.set_location('Processing '||l_proc, 10);
252: end if;
253: --
254: -- Issue a SavePoint
255: savepoint set_time_bb_appl_set;

Line 258: -- hr_utility.trace('Entered..........'||p_pte_terg_id);

254: -- Issue a SavePoint
255: savepoint set_time_bb_appl_set;
256: --
257: --if g_debug then
258: -- hr_utility.trace('Entered..........'||p_pte_terg_id);
259: --end if;
260: if (p_pte_terg_id is not null) then
261: /*
262: -- ******************START TRACE SECTION***************************************

Line 265: hr_utility.trace('*BEFORE PROCESSING');

261: /*
262: -- ******************START TRACE SECTION***************************************
263: --
264: if g_debug then
265: hr_utility.trace('*******BEFORE PROCESSING******');
266: hr_utility.trace('-----------------------------');
267: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
268: hr_utility.trace('-----------------------------');
269: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last

Line 266: hr_utility.trace('-----------------------------');

262: -- ******************START TRACE SECTION***************************************
263: --
264: if g_debug then
265: hr_utility.trace('*******BEFORE PROCESSING******');
266: hr_utility.trace('-----------------------------');
267: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
268: hr_utility.trace('-----------------------------');
269: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
270: loop

Line 267: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');

263: --
264: if g_debug then
265: hr_utility.trace('*******BEFORE PROCESSING******');
266: hr_utility.trace('-----------------------------');
267: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
268: hr_utility.trace('-----------------------------');
269: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
270: loop
271: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id||

Line 268: hr_utility.trace('-----------------------------');

264: if g_debug then
265: hr_utility.trace('*******BEFORE PROCESSING******');
266: hr_utility.trace('-----------------------------');
267: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
268: hr_utility.trace('-----------------------------');
269: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
270: loop
271: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id||
272: ' | '||P_TIME_BUILDING_BLOCKS(x).application_set_id||

Line 271: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id||

267: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
268: hr_utility.trace('-----------------------------');
269: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
270: loop
271: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id||
272: ' | '||P_TIME_BUILDING_BLOCKS(x).application_set_id||
273: ' | '||p_time_building_blocks(x).SCOPE||' | '||
274: P_TIME_BUILDING_BLOCKS (x).object_version_number||' | '||
275: P_TIME_BUILDING_BLOCKS(x).NEW||' | '||

Line 280: hr_utility.trace('-----------------------------');

Line 281: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | TBB_ID| NEW| CHANGED|');

Line 282: hr_utility.trace('-----------------------------');

Line 288: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_index).TIME_ATTRIBUTE_ID

284: l_index := P_TIME_ATTRIBUTES.first;
285: while l_index is not null
286: loop
287:
288: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_index).TIME_ATTRIBUTE_ID
289: ||' | '||P_TIME_ATTRIBUTES(l_index).BUILDING_BLOCK_ID
290: ||' | '||P_TIME_ATTRIBUTES(l_index).BLD_BLK_INFO_TYPE
291: ||' | '||P_TIME_ATTRIBUTES(l_index).ATTRIBUTE_CATEGORY
292: || ' | '||P_TIME_ATTRIBUTES(l_index).BUILDING_BLOCK_ID

Line 299: hr_utility.trace('-----------------------------');

295: l_index := P_TIME_ATTRIBUTES.NEXT(l_index);
296: end loop;
297:
298:
299: hr_utility.trace('-----------------------------');
300: hr_utility.trace('| MESSAGE_LEVEL | message_name| TBB_OVN | TBB_ID');
301: hr_utility.trace('-----------------------------');
302: for x IN P_MESSAGES.first .. P_MESSAGES.last
303: loop

Line 300: hr_utility.trace('| MESSAGE_LEVEL | message_name| TBB_OVN | TBB_ID');

296: end loop;
297:
298:
299: hr_utility.trace('-----------------------------');
300: hr_utility.trace('| MESSAGE_LEVEL | message_name| TBB_OVN | TBB_ID');
301: hr_utility.trace('-----------------------------');
302: for x IN P_MESSAGES.first .. P_MESSAGES.last
303: loop
304: hr_utility.trace('| '||P_MESSAGES(x).MESSAGE_LEVEL||' | '

Line 301: hr_utility.trace('-----------------------------');

297:
298:
299: hr_utility.trace('-----------------------------');
300: hr_utility.trace('| MESSAGE_LEVEL | message_name| TBB_OVN | TBB_ID');
301: hr_utility.trace('-----------------------------');
302: for x IN P_MESSAGES.first .. P_MESSAGES.last
303: loop
304: hr_utility.trace('| '||P_MESSAGES(x).MESSAGE_LEVEL||' | '
305: ||P_messages(x).message_name||' | '

Line 304: hr_utility.trace('| '||P_MESSAGES(x).MESSAGE_LEVEL||' | '

300: hr_utility.trace('| MESSAGE_LEVEL | message_name| TBB_OVN | TBB_ID');
301: hr_utility.trace('-----------------------------');
302: for x IN P_MESSAGES.first .. P_MESSAGES.last
303: loop
304: hr_utility.trace('| '||P_MESSAGES(x).MESSAGE_LEVEL||' | '
305: ||P_messages(x).message_name||' | '
306: ||p_messages(x).time_building_block_ovn|| ' | '
307: ||p_messages(x).time_building_block_id);
308: end loop;

Line 322: -- hr_utility.trace('p_application_set_id'||p_application_set_id);

318: --
319: l_index := 1;
320: --
321: --if g_debug then
322: -- hr_utility.trace('p_application_set_id'||p_application_set_id);
323: --end if;
324: --
325: FOR appl_set IN csr_app_set_id(p_application_set_id) LOOP
326:

Line 375: --hr_utility.trace('cached_tm_set.COUNT'||cached_tm_set.COUNT);

371: + 1;
372: END LOOP; -- appl_set IN cache_app_set
373:
374: -- if g_debug then
375: --hr_utility.trace('cached_tm_set.COUNT'||cached_tm_set.COUNT);
376: -- end if;
377: --
378:
379: -- here starts the real processing

Line 695: --hr_utility.trace('ks ...nulled and temp_app_set (l_index).application_set_id = '||temp_app_set (l_index).application_set_id);

691: l_null_application_set_id := 'Y';
692: l_index := 0;
693: temp_app_set (l_index).application_set_id := -999999;
694: -- if g_debug then
695: --hr_utility.trace('ks ...nulled and temp_app_set (l_index).application_set_id = '||temp_app_set (l_index).application_set_id);
696: -- end if;
697: end if;
698:
699: -- 115.6 end

Line 798: --hr_utility.trace(' Yes drops and dropped timerecid ='||cached_tm_set (l_index_tmp_rec).time_recipient_id);

794:
795: IF (time_rec_present = 'N')
796: THEN
797: -- if g_debug then
798: --hr_utility.trace(' Yes drops and dropped timerecid ='||cached_tm_set (l_index_tmp_rec).time_recipient_id);
799: -- addding 115.5
800: -- check here first that if time has been transferred to
801: -- this time recipinet.
802: -- hr_utility.trace(' Now to check if time transfer has taken place for this Dropped TimeRec or not....');

Line 802: -- hr_utility.trace(' Now to check if time transfer has taken place for this Dropped TimeRec or not....');

798: --hr_utility.trace(' Yes drops and dropped timerecid ='||cached_tm_set (l_index_tmp_rec).time_recipient_id);
799: -- addding 115.5
800: -- check here first that if time has been transferred to
801: -- this time recipinet.
802: -- hr_utility.trace(' Now to check if time transfer has taken place for this Dropped TimeRec or not....');
803: --end if;
804: --
805: time_rec_transfer := null;
806: --

Line 813: -- hr_utility.trace(' Yes there is a drop n the time transfer has taken palce.... and recp id = '||cached_tm_set (l_index_tmp_rec).time_recipient_id);

809: CLOSE tm_rec_transfer;
810: IF( 'Y' = time_rec_transfer)
811: THEN
812: -- if g_debug then
813: -- hr_utility.trace(' Yes there is a drop n the time transfer has taken palce.... and recp id = '||cached_tm_set (l_index_tmp_rec).time_recipient_id);
814: -- end if;
815:
816: list_tim_rec_drops(l_index_tim_rec_drops).time_recipient_id :=
817: cached_tm_set (l_index_tmp_rec).time_recipient_id;

Line 835: -- hr_utility.trace (

831: list_tim_rec_day (x).time_recipient_id
832: )
833: THEN
834: -- if g_debug then
835: -- hr_utility.trace (
836: -- ' yes TR present in DAY'
837: -- );
838: -- end if;
839: time_rec_present := 'Y';

Line 855: --hr_utility.trace ('poop');

851:
852: IF (time_rec_present = 'N')
853: THEN
854: -- if g_debug then
855: --hr_utility.trace ('poop');
856: -- end if;
857: list_tim_rec_day (l_ind_tim_rec_day).time_recipient_id :=
858: cached_tm_set (l_index_tmp_rec).time_recipient_id;
859: END IF; -- time_rec_present = 'N'

Line 1046: --hr_utility.trace('ADDING.....ROWS HERE....DROPS IN ELP SEEN');

1042: ELSE
1043:
1044: -- and now finally ADD NEW ROWS FOR DROPS IN TBB AND ATTRIBS
1045: -- if g_debug then
1046: --hr_utility.trace('ADDING.....ROWS HERE....DROPS IN ELP SEEN');
1047: -- end if;
1048:
1049: -- Initilaize the index etc to pop
1050: -- 115.7

Line 1338: hr_utility.trace('*POST DROPS STATS');

1334:
1335: /*
1336: -- ****************** CHECKS for STRUCTURE After DROPS ******************
1337: if g_debug then
1338: hr_utility.trace('*******POST DROPS STATS******');
1339: hr_utility.trace('-----------------------------');
1340: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
1341: hr_utility.trace('-----------------------------');
1342: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last

Line 1339: hr_utility.trace('-----------------------------');

1335: /*
1336: -- ****************** CHECKS for STRUCTURE After DROPS ******************
1337: if g_debug then
1338: hr_utility.trace('*******POST DROPS STATS******');
1339: hr_utility.trace('-----------------------------');
1340: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
1341: hr_utility.trace('-----------------------------');
1342: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1343: loop

Line 1340: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');

1336: -- ****************** CHECKS for STRUCTURE After DROPS ******************
1337: if g_debug then
1338: hr_utility.trace('*******POST DROPS STATS******');
1339: hr_utility.trace('-----------------------------');
1340: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
1341: hr_utility.trace('-----------------------------');
1342: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1343: loop
1344: hr_utility.trace('| '

Line 1341: hr_utility.trace('-----------------------------');

1337: if g_debug then
1338: hr_utility.trace('*******POST DROPS STATS******');
1339: hr_utility.trace('-----------------------------');
1340: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
1341: hr_utility.trace('-----------------------------');
1342: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1343: loop
1344: hr_utility.trace('| '
1345: ||P_TIME_BUILDING_BLOCKS(x).time_building_block_id

Line 1344: hr_utility.trace('| '

1340: hr_utility.trace('| TBB_ID | APPL_SET_ID |SCOPE | OVN| NEW| CHANGED|');
1341: hr_utility.trace('-----------------------------');
1342: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1343: loop
1344: hr_utility.trace('| '
1345: ||P_TIME_BUILDING_BLOCKS(x).time_building_block_id
1346: ||' | '||P_TIME_BUILDING_BLOCKS(x).application_set_id
1347: ||' | '||p_time_building_blocks(x).SCOPE||' | '
1348: ||P_TIME_BUILDING_BLOCKS (x).object_version_number||' | '

Line 1354: hr_utility.trace('-----------------------------');

1350: ||P_TIME_BUILDING_BLOCKS(x).CHANGED);
1351: end loop;
1352:
1353:
1354: hr_utility.trace('-----------------------------');
1355: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | TBB_ID| NEW| CHANGED|');
1356: hr_utility.trace('-----------------------------');
1357: l_index := null;
1358: l_index := P_TIME_ATTRIBUTES.first;

Line 1355: hr_utility.trace('| ATTRIB_ID |TBB ID | BLD_BLK_INFO_TYPE| ATTRIBUTE_CATEGORY | TBB_ID| NEW| CHANGED|');

Line 1356: hr_utility.trace('-----------------------------');

Line 1362: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_index).TIME_ATTRIBUTE_ID

1358: l_index := P_TIME_ATTRIBUTES.first;
1359: while l_index is not null
1360: loop
1361:
1362: hr_utility.trace('| '||P_TIME_ATTRIBUTES(l_index).TIME_ATTRIBUTE_ID
1363: ||' | '||P_TIME_ATTRIBUTES(l_index).BUILDING_BLOCK_ID
1364: ||' | '||P_TIME_ATTRIBUTES(l_index).BLD_BLK_INFO_TYPE
1365: ||' | '||P_TIME_ATTRIBUTES(l_index).ATTRIBUTE_CATEGORY
1366: || ' | '||P_TIME_ATTRIBUTES(l_index).BUILDING_BLOCK_ID

Line 1373: hr_utility.trace('-----------------------------');

1369: l_index := P_TIME_ATTRIBUTES.NEXT(l_index);
1370: end loop;
1371:
1372:
1373: hr_utility.trace('-----------------------------');
1374: end if;
1375: -- ****************** ENDING CHECKS for STRUCTURE After DROPS ******************
1376: */
1377:

Line 1769: -- hr_utility.trace('ks NO ELP');

1765: -- update all TBB to have the application set id
1766: -- as the one set on the resource preference
1767: --
1768: -- if g_debug then
1769: -- hr_utility.trace('ks NO ELP');
1770: -- end if;
1771: l_index_tc := NULL;
1772:
1773: l_index_tc := P_TIME_BUILDING_BLOCKS.FIRST;

Line 1797: -- hr_utility.trace('ks ... Yes -ve TBB OVN found which is for the new entry.');

1793: loop
1794: if (P_TIME_BUILDING_BLOCKS(l_index).OBJECT_VERSION_NUMBER = -9999)
1795: then
1796: -- if g_debug then
1797: -- hr_utility.trace('ks ... Yes -ve TBB OVN found which is for the new entry.');
1798: -- end if;
1799: P_TIME_BUILDING_BLOCKS(l_index).OBJECT_VERSION_NUMBER := 1;
1800: end if;
1801: l_index := P_TIME_BUILDING_BLOCKS.NEXT(l_index);

Line 1810: hr_utility.trace('*AFTER PROCESSING');

1806:
1807: /*
1808: -- ************* After Call to Update/Populate Appliation Set
1809: if g_debug then
1810: hr_utility.trace('*******AFTER PROCESSING******');
1811: hr_utility.trace('-----------------------------');
1812: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1813: hr_utility.trace('-----------------------------');
1814: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last

Line 1811: hr_utility.trace('-----------------------------');

1807: /*
1808: -- ************* After Call to Update/Populate Appliation Set
1809: if g_debug then
1810: hr_utility.trace('*******AFTER PROCESSING******');
1811: hr_utility.trace('-----------------------------');
1812: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1813: hr_utility.trace('-----------------------------');
1814: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1815: loop

Line 1812: hr_utility.trace('| TBB_ID | APPL_SET_ID|');

1808: -- ************* After Call to Update/Populate Appliation Set
1809: if g_debug then
1810: hr_utility.trace('*******AFTER PROCESSING******');
1811: hr_utility.trace('-----------------------------');
1812: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1813: hr_utility.trace('-----------------------------');
1814: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1815: loop
1816: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id

Line 1813: hr_utility.trace('-----------------------------');

1809: if g_debug then
1810: hr_utility.trace('*******AFTER PROCESSING******');
1811: hr_utility.trace('-----------------------------');
1812: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1813: hr_utility.trace('-----------------------------');
1814: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1815: loop
1816: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id
1817: ||' | '||P_TIME_BUILDING_BLOCKS(x).application_set_id

Line 1816: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id

1812: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1813: hr_utility.trace('-----------------------------');
1814: for x IN P_TIME_BUILDING_BLOCKS.first .. P_TIME_BUILDING_BLOCKS.last
1815: loop
1816: hr_utility.trace('| '||P_TIME_BUILDING_BLOCKS(x).time_building_block_id
1817: ||' | '||P_TIME_BUILDING_BLOCKS(x).application_set_id
1818: ||' |');
1819: end loop;
1820:

Line 1821: hr_utility.trace('Leaves and messges cnt ='||p_messages.count);

1817: ||' | '||P_TIME_BUILDING_BLOCKS(x).application_set_id
1818: ||' |');
1819: end loop;
1820:
1821: hr_utility.trace('Leaves and messges cnt ='||p_messages.count);
1822: end if;
1823: */
1824:
1825: EXCEPTION

Line 1828: -- hr_utility.set_message (809, 'HXC_ELP_APPL_PROCESS_ERROR');

1824:
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: -- 115.7
1828: -- hr_utility.set_message (809, 'HXC_ELP_APPL_PROCESS_ERROR');
1829: -- hr_utility.raise_error;
1830: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1831: p_message_table => p_messages
1832: , p_message_name => 'EXCEPTION'

Line 1829: -- hr_utility.raise_error;

1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: -- 115.7
1828: -- hr_utility.set_message (809, 'HXC_ELP_APPL_PROCESS_ERROR');
1829: -- hr_utility.raise_error;
1830: hxc_time_entry_rules_utils_pkg.add_error_to_table (
1831: p_message_table => p_messages
1832: , p_message_name => 'EXCEPTION'
1833: , p_message_token => NULL

Line 1888: g_debug:=hr_utility.debug_enabled;

1884: l_proc VARCHAR2 (30);
1885: --
1886: BEGIN
1887: --
1888: g_debug:=hr_utility.debug_enabled;
1889: if g_debug then
1890: l_proc := 'build_elp_objects';
1891: hr_utility.set_location('Processing '||l_proc, 10);
1892: end if;

Line 1891: hr_utility.set_location('Processing '||l_proc, 10);

1887: --
1888: g_debug:=hr_utility.debug_enabled;
1889: if g_debug then
1890: l_proc := 'build_elp_objects';
1891: hr_utility.set_location('Processing '||l_proc, 10);
1892: end if;
1893: --
1894: -- issue a savepoint
1895: savepoint build_elp_objects;

Line 1900: hr_utility.trace('ks enters BUILD P_TIME_RECIPIENT_ID = '||P_TIME_RECIPIENT_ID);

1896: --
1897: /*
1898: -- **************************** START TRACE SECTION ********************
1899: if g_debug then
1900: hr_utility.trace('ks enters BUILD P_TIME_RECIPIENT_ID = '||P_TIME_RECIPIENT_ID);
1901: -- Initialize a local copy of the time builidng block
1902: hr_utility.trace('*******BEFORE PROCESSING******');
1903: hr_utility.trace('-----------------------------');
1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');

Line 1902: hr_utility.trace('*BEFORE PROCESSING');

1898: -- **************************** START TRACE SECTION ********************
1899: if g_debug then
1900: hr_utility.trace('ks enters BUILD P_TIME_RECIPIENT_ID = '||P_TIME_RECIPIENT_ID);
1901: -- Initialize a local copy of the time builidng block
1902: hr_utility.trace('*******BEFORE PROCESSING******');
1903: hr_utility.trace('-----------------------------');
1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1905: hr_utility.trace('-----------------------------');
1906: for x IN P_ELP_TIME_BUILDING_BLOCKS.first .. P_ELP_TIME_BUILDING_BLOCKS.last

Line 1903: hr_utility.trace('-----------------------------');

1899: if g_debug then
1900: hr_utility.trace('ks enters BUILD P_TIME_RECIPIENT_ID = '||P_TIME_RECIPIENT_ID);
1901: -- Initialize a local copy of the time builidng block
1902: hr_utility.trace('*******BEFORE PROCESSING******');
1903: hr_utility.trace('-----------------------------');
1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1905: hr_utility.trace('-----------------------------');
1906: for x IN P_ELP_TIME_BUILDING_BLOCKS.first .. P_ELP_TIME_BUILDING_BLOCKS.last
1907: loop

Line 1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');

1900: hr_utility.trace('ks enters BUILD P_TIME_RECIPIENT_ID = '||P_TIME_RECIPIENT_ID);
1901: -- Initialize a local copy of the time builidng block
1902: hr_utility.trace('*******BEFORE PROCESSING******');
1903: hr_utility.trace('-----------------------------');
1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1905: hr_utility.trace('-----------------------------');
1906: for x IN P_ELP_TIME_BUILDING_BLOCKS.first .. P_ELP_TIME_BUILDING_BLOCKS.last
1907: loop
1908: hr_utility.trace('| '||P_ELP_TIME_BUILDING_BLOCKS(x).time_building_block_id

Line 1905: hr_utility.trace('-----------------------------');

1901: -- Initialize a local copy of the time builidng block
1902: hr_utility.trace('*******BEFORE PROCESSING******');
1903: hr_utility.trace('-----------------------------');
1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1905: hr_utility.trace('-----------------------------');
1906: for x IN P_ELP_TIME_BUILDING_BLOCKS.first .. P_ELP_TIME_BUILDING_BLOCKS.last
1907: loop
1908: hr_utility.trace('| '||P_ELP_TIME_BUILDING_BLOCKS(x).time_building_block_id
1909: ||' | '||P_ELP_TIME_BUILDING_BLOCKS(x).application_set_id

Line 1908: hr_utility.trace('| '||P_ELP_TIME_BUILDING_BLOCKS(x).time_building_block_id

1904: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
1905: hr_utility.trace('-----------------------------');
1906: for x IN P_ELP_TIME_BUILDING_BLOCKS.first .. P_ELP_TIME_BUILDING_BLOCKS.last
1907: loop
1908: hr_utility.trace('| '||P_ELP_TIME_BUILDING_BLOCKS(x).time_building_block_id
1909: ||' | '||P_ELP_TIME_BUILDING_BLOCKS(x).application_set_id
1910: ||' |');
1911: end loop;
1912: end if;

Line 1934: -- hr_utility.trace('valid cached_app_set.COUNT = '||cached_app_set.COUNT);

1930:
1931: l_index := l_index+1;
1932: END LOOP;
1933: -- if g_debug then
1934: -- hr_utility.trace('valid cached_app_set.COUNT = '||cached_app_set.COUNT);
1935: -- end if;
1936:
1937: -- here starts the real processing
1938:

Line 1966: --hr_utility.trace('ks 1208');

1962: )
1963: THEN
1964: -- Intialize the flag to include timecard row to 'N for SCOPE = DAY
1965: -- if g_debug then
1966: --hr_utility.trace('ks 1208');
1967: -- end if;
1968: time_rec_present_day := 'N';
1969:
1970: l_index_det := NULL;

Line 2001: --hr_utility.trace('ks in Yes for all 1240');

1997: time_rec_present_det := 'Y';
1998: time_rec_present_day := 'Y';
1999: time_rec_present_tc := 'Y';
2000: -- if g_debug then
2001: --hr_utility.trace('ks in Yes for all 1240');
2002: -- end if;
2003: END IF; -- check if Time Recipient is already present
2004: END LOOP; -- x IN cached_app_set
2005:

Line 2047: hr_utility.trace('*AFTER PROCESSING');

2043:
2044: /*
2045: -- ********************** START TRACE AFTER PROCESSING***********************
2046: if g_debug then
2047: hr_utility.trace('*******AFTER PROCESSING******');
2048: hr_utility.trace('-----------------------------');
2049: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
2050: hr_utility.trace('-----------------------------');
2051: hr_utility.trace('CNT l_elp_time_builidng_block='||l_elp_time_builidng_block.COUNT);

Line 2048: hr_utility.trace('-----------------------------');

2044: /*
2045: -- ********************** START TRACE AFTER PROCESSING***********************
2046: if g_debug then
2047: hr_utility.trace('*******AFTER PROCESSING******');
2048: hr_utility.trace('-----------------------------');
2049: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
2050: hr_utility.trace('-----------------------------');
2051: hr_utility.trace('CNT l_elp_time_builidng_block='||l_elp_time_builidng_block.COUNT);
2052: if(l_elp_time_builidng_block.COUNT > 0 )

Line 2049: hr_utility.trace('| TBB_ID | APPL_SET_ID|');

2045: -- ********************** START TRACE AFTER PROCESSING***********************
2046: if g_debug then
2047: hr_utility.trace('*******AFTER PROCESSING******');
2048: hr_utility.trace('-----------------------------');
2049: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
2050: hr_utility.trace('-----------------------------');
2051: hr_utility.trace('CNT l_elp_time_builidng_block='||l_elp_time_builidng_block.COUNT);
2052: if(l_elp_time_builidng_block.COUNT > 0 )
2053: then

Line 2050: hr_utility.trace('-----------------------------');

2046: if g_debug then
2047: hr_utility.trace('*******AFTER PROCESSING******');
2048: hr_utility.trace('-----------------------------');
2049: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
2050: hr_utility.trace('-----------------------------');
2051: hr_utility.trace('CNT l_elp_time_builidng_block='||l_elp_time_builidng_block.COUNT);
2052: if(l_elp_time_builidng_block.COUNT > 0 )
2053: then
2054: l_index:=0;

Line 2051: hr_utility.trace('CNT l_elp_time_builidng_block='||l_elp_time_builidng_block.COUNT);

2047: hr_utility.trace('*******AFTER PROCESSING******');
2048: hr_utility.trace('-----------------------------');
2049: hr_utility.trace('| TBB_ID | APPL_SET_ID|');
2050: hr_utility.trace('-----------------------------');
2051: hr_utility.trace('CNT l_elp_time_builidng_block='||l_elp_time_builidng_block.COUNT);
2052: if(l_elp_time_builidng_block.COUNT > 0 )
2053: then
2054: l_index:=0;
2055: l_index:=l_elp_time_builidng_block.FIRST;

Line 2058: hr_utility.trace('| '||l_elp_time_builidng_block(l_index).time_building_block_id||' | '||l_elp_time_builidng_block(l_index).application_set_id||' |');

2054: l_index:=0;
2055: l_index:=l_elp_time_builidng_block.FIRST;
2056: while l_index is not null
2057: loop
2058: hr_utility.trace('| '||l_elp_time_builidng_block(l_index).time_building_block_id||' | '||l_elp_time_builidng_block(l_index).application_set_id||' |');
2059: l_index:=l_elp_time_builidng_block.NEXT(l_index);
2060: end loop; -- l_index is not null
2061: end if; -- l_elp_time_builidng_block.COUNT > 0
2062: end if;

Line 2071: hr_utility.set_message (809, 'HXC_ELP_TC_FILTER_ERROR');

2067: -- here ends the processing
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070:
2071: hr_utility.set_message (809, 'HXC_ELP_TC_FILTER_ERROR');
2072: hr_utility.raise_error;
2073:
2074:
2075: END build_elp_objects;

Line 2072: hr_utility.raise_error;

2068: EXCEPTION
2069: WHEN OTHERS THEN
2070:
2071: hr_utility.set_message (809, 'HXC_ELP_TC_FILTER_ERROR');
2072: hr_utility.raise_error;
2073:
2074:
2075: END build_elp_objects;
2076:

Line 2089: g_debug:=hr_utility.debug_enabled;

2085: l_index_tc BINARY_INTEGER;
2086: l_proc VARCHAR2 (30);
2087:
2088: BEGIN
2089: g_debug:=hr_utility.debug_enabled;
2090: if g_debug then
2091: l_proc := 'set_time_bb_appl_set_tk';
2092: hr_utility.set_location('Processing '||l_proc, 10);
2093: end if;

Line 2092: hr_utility.set_location('Processing '||l_proc, 10);

2088: BEGIN
2089: g_debug:=hr_utility.debug_enabled;
2090: if g_debug then
2091: l_proc := 'set_time_bb_appl_set_tk';
2092: hr_utility.set_location('Processing '||l_proc, 10);
2093: end if;
2094: --
2095: -- Issue a SavePoint
2096: savepoint set_time_bb_appl_tk;

Line 2099: --hr_utility.trace('Entered..........'||p_pte_terg_id);

2095: -- Issue a SavePoint
2096: savepoint set_time_bb_appl_tk;
2097: --
2098: -- if g_debug then
2099: --hr_utility.trace('Entered..........'||p_pte_terg_id);
2100: -- end if;
2101:
2102: -- Here we just update the g_timecard with the
2103: -- Application Set id set at the user pref

Line 2120: hr_utility.set_message (809, 'HXC_ELP_APPL_PROCESS_ERROR');

2116: END LOOP;
2117: --
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: hr_utility.set_message (809, 'HXC_ELP_APPL_PROCESS_ERROR');
2121: hr_utility.raise_error;
2122: --
2123: END set_time_bb_appl_set_tk;
2124:

Line 2121: hr_utility.raise_error;

2117: --
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: hr_utility.set_message (809, 'HXC_ELP_APPL_PROCESS_ERROR');
2121: hr_utility.raise_error;
2122: --
2123: END set_time_bb_appl_set_tk;
2124:
2125: end hxc_elp_utils;