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

Line 6: g_debug BOOLEAN := hr_utility.debug_enabled;

2: /* $Header: hxctsdp.pkb 120.7 2006/04/19 13:27:48 mvilrokx noship $ */
3:
4: -- Global package name
5: g_package CONSTANT VARCHAR2 (33) := 'hxc_timestore_deposit.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7:
8: PROCEDURE get_timecard_tables (
9: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
10: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 121: g_debug := hr_utility.debug_enabled;

117: l_count_building_block PLS_INTEGER;
118: l_parent_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
119: l_parent_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
120: BEGIN
121: g_debug := hr_utility.debug_enabled;
122:
123: IF g_debug
124: THEN
125: l_proc := g_package || 'create_bb';

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

122:
123: IF g_debug
124: THEN
125: l_proc := g_package || 'create_bb';
126: hr_utility.set_location ('Entering:' || l_proc, 10);
127: END IF;
128:
129: l_count_building_block := NVL (p_app_blocks.LAST, 0);
130: p_app_blocks.EXTEND;

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

157: );
158:
159: IF g_debug
160: THEN
161: hr_utility.set_location ('Leaving:' || l_proc, 20);
162: END IF;
163: END create_bb;
164:
165: -----------------------------------------------------------------------------

Line 205: g_debug := hr_utility.debug_enabled;

201: IS
202: l_proc VARCHAR2 (72);
203: l_blocks hxc_block_table_type;
204: BEGIN
205: g_debug := hr_utility.debug_enabled;
206:
207: IF g_debug
208: THEN
209: l_proc := g_package || 'create_bb (Overload)';

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

206:
207: IF g_debug
208: THEN
209: l_proc := g_package || 'create_bb (Overload)';
210: hr_utility.set_location ('Entering:' || l_proc, 10);
211: END IF;
212:
213: l_blocks :=
214: hxc_timestore_deposit_util.convert_tbb_to_type

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

239: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
240:
241: IF g_debug
242: THEN
243: hr_utility.set_location ('Leaving:' || l_proc, 20);
244: END IF;
245: END create_bb;
246:
247: -----------------------------------------------------------------------------

Line 295: g_debug := hr_utility.debug_enabled;

291: -- l_tc_days PLS_INTEGER;
292: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
293: -- l_building_block_index PLS_INTEGER;
294: BEGIN
295: g_debug := hr_utility.debug_enabled;
296:
297: IF g_debug
298: THEN
299: l_proc := g_package || 'create_timecard_bb';

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

296:
297: IF g_debug
298: THEN
299: l_proc := g_package || 'create_timecard_bb';
300: hr_utility.set_location ('Entering:' || l_proc, 10);
301: END IF;
302:
303: -- We are starting with a new timecard so clear the global tables
304: hxc_self_service_time_deposit.initialize_globals;

Line 368: hr_utility.set_location ( 'Leaving:'

364: END LOOP;
365: *************************************************/
366: IF g_debug
367: THEN
368: hr_utility.set_location ( 'Leaving:'
369: || l_proc
370: || ' p_time_building_block_id = '
371: || p_time_building_block_id,
372: 100

Line 411: g_debug := hr_utility.debug_enabled;

407: IS
408: l_proc VARCHAR2 (72);
409: l_blocks hxc_block_table_type;
410: BEGIN
411: g_debug := hr_utility.debug_enabled;
412:
413: IF g_debug
414: THEN
415: l_proc := g_package || 'create_timecard_bb (Overloaded)';

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

412:
413: IF g_debug
414: THEN
415: l_proc := g_package || 'create_timecard_bb (Overloaded)';
416: hr_utility.set_location ('Entering:' || l_proc, 10);
417: END IF;
418:
419: l_blocks :=
420: hxc_timestore_deposit_util.convert_tbb_to_type

Line 437: hr_utility.set_location ( 'Leaving:'

433: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
434:
435: IF g_debug
436: THEN
437: hr_utility.set_location ( 'Leaving:'
438: || l_proc
439: || ' p_time_building_block_id = '
440: || p_time_building_block_id,
441: 100

Line 483: g_debug := hr_utility.debug_enabled;

479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
481: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
482: BEGIN
483: g_debug := hr_utility.debug_enabled;
484:
485: IF g_debug
486: THEN
487: l_proc := g_package || 'create_day_bb (overload)';

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

484:
485: IF g_debug
486: THEN
487: l_proc := g_package || 'create_day_bb (overload)';
488: hr_utility.set_location ('Entering:' || l_proc, 10);
489: END IF;
490:
491: -- First find the TIMECARD TBB to which this DAY TBB belongs
492: hxc_timestore_deposit_util.find_parent_building_block

Line 514: hr_utility.set_location ( 'Leaving:'

510: );
511:
512: IF g_debug
513: THEN
514: hr_utility.set_location ( 'Leaving:'
515: || l_proc
516: || ' p_time_building_block_id = '
517: || p_time_building_block_id,
518: 100

Line 551: g_debug := hr_utility.debug_enabled;

547: IS
548: l_proc VARCHAR2 (72);
549: l_blocks hxc_block_table_type;
550: BEGIN
551: g_debug := hr_utility.debug_enabled;
552:
553: IF g_debug
554: THEN
555: l_proc := g_package || 'create_day_bb (overload)';

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

552:
553: IF g_debug
554: THEN
555: l_proc := g_package || 'create_day_bb (overload)';
556: hr_utility.set_location ('Entering:' || l_proc, 10);
557: END IF;
558:
559: l_blocks :=
560: hxc_timestore_deposit_util.convert_tbb_to_type

Line 576: hr_utility.set_location ( 'Leaving:'

572: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
573:
574: IF g_debug
575: THEN
576: hr_utility.set_location ( 'Leaving:'
577: || l_proc
578: || ' p_time_building_block_id = '
579: || p_time_building_block_id,
580: 100

Line 633: g_debug := hr_utility.debug_enabled;

629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
631: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
632: BEGIN
633: g_debug := hr_utility.debug_enabled;
634:
635: IF g_debug
636: THEN
637: l_proc := g_package || 'create_day_bb';

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

634:
635: IF g_debug
636: THEN
637: l_proc := g_package || 'create_day_bb';
638: hr_utility.set_location ('Entering:' || l_proc, 10);
639: END IF;
640:
641: -- check if a timecard is already present in PL/SQL tables
642: IF (p_app_blocks.COUNT = 0)

Line 736: hr_utility.set_location ( 'Leaving:'

732: );
733:
734: IF g_debug
735: THEN
736: hr_utility.set_location ( 'Leaving:'
737: || l_proc
738: || ' p_time_building_block_id = '
739: || p_time_building_block_id,
740: 100

Line 773: g_debug := hr_utility.debug_enabled;

769: IS
770: l_proc VARCHAR2 (72);
771: l_blocks hxc_block_table_type;
772: BEGIN
773: g_debug := hr_utility.debug_enabled;
774:
775: IF g_debug
776: THEN
777: l_proc := g_package || 'create_day_bb (overload)';

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

774:
775: IF g_debug
776: THEN
777: l_proc := g_package || 'create_day_bb (overload)';
778: hr_utility.set_location ('Entering:' || l_proc, 10);
779: END IF;
780:
781: l_blocks :=
782: hxc_timestore_deposit_util.convert_tbb_to_type

Line 799: hr_utility.set_location ( 'Leaving:'

795: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
796:
797: IF g_debug
798: THEN
799: hr_utility.set_location ( 'Leaving:'
800: || l_proc
801: || ' p_time_building_block_id = '
802: || p_time_building_block_id,
803: 100

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

851: BEGIN
852: IF g_debug
853: THEN
854: l_proc := g_package || 'auto_create_timecard';
855: hr_utility.set_location ('Entering:' || l_proc, 10);
856: END IF;
857:
858: -- clear tables
859: hxc_timestore_deposit_util.clear_building_block_table

Line 884: hr_utility.set_location ( ' We will need to create '

880: l_tc_days := TRUNC (l_stop_time) - TRUNC (l_start_time);
881:
882: IF g_debug
883: THEN
884: hr_utility.set_location ( ' We will need to create '
885: || TO_CHAR (l_tc_days + 1)
886: || ' DAY TBBs',
887: 30
888: );

Line 911: hr_utility.set_location ( 'Leaving:'

907: END LOOP;
908:
909: IF g_debug
910: THEN
911: hr_utility.set_location ( 'Leaving:'
912: || l_proc
913: || ' p_time_building_block_id = '
914: || p_time_building_block_id,
915: 100

Line 982: g_debug := hr_utility.debug_enabled;

978: l_parent_building_block_index PLS_INTEGER;
979: l_parent_is_new VARCHAR2 (1);
980: l_unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE;
981: BEGIN
982: g_debug := hr_utility.debug_enabled;
983:
984: IF g_debug
985: THEN
986: l_proc := g_package || 'create_detail_bb';

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

983:
984: IF g_debug
985: THEN
986: l_proc := g_package || 'create_detail_bb';
987: hr_utility.set_location ('Entering:' || l_proc, 10);
988: END IF;
989:
990: -- check if a timecard is already present in PL/SQL tables
991: IF (p_app_blocks.COUNT = 0)

Line 1084: hr_utility.set_location ( 'Leaving:'

1080: );
1081:
1082: IF g_debug
1083: THEN
1084: hr_utility.set_location ( 'Leaving:'
1085: || l_proc
1086: || ' p_time_building_block_id = '
1087: || p_time_building_block_id,
1088: 100

Line 1134: g_debug := hr_utility.debug_enabled;

1130: IS
1131: l_proc VARCHAR2 (72);
1132: l_blocks hxc_block_table_type;
1133: BEGIN
1134: g_debug := hr_utility.debug_enabled;
1135:
1136: IF g_debug
1137: THEN
1138: l_proc := g_package || 'create_detail_bb (Overloaded)';

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

1135:
1136: IF g_debug
1137: THEN
1138: l_proc := g_package || 'create_detail_bb (Overloaded)';
1139: hr_utility.set_location ('Entering:' || l_proc, 10);
1140: END IF;
1141:
1142: l_blocks :=
1143: hxc_timestore_deposit_util.convert_tbb_to_type

Line 1170: hr_utility.set_location ( 'Leaving:'

1166: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
1167:
1168: IF g_debug
1169: THEN
1170: hr_utility.set_location ( 'Leaving:'
1171: || l_proc
1172: || ' p_time_building_block_id = '
1173: || p_time_building_block_id,
1174: 100

Line 1224: g_debug := hr_utility.debug_enabled;

1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1222: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225:
1226: IF g_debug
1227: THEN
1228: l_proc := g_package || 'create_time_entry';

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

1225:
1226: IF g_debug
1227: THEN
1228: l_proc := g_package || 'create_time_entry';
1229: hr_utility.set_location ('Entering:' || l_proc, 10);
1230: END IF;
1231:
1232: -- First find the DAY TBB to which this DETAIL TBB belongs
1233: hxc_timestore_deposit_util.find_parent_building_block

Line 1275: hr_utility.set_location ( 'Leaving:'

1271: );
1272:
1273: IF g_debug
1274: THEN
1275: hr_utility.set_location ( 'Leaving:'
1276: || l_proc
1277: || ' p_time_building_block_id = '
1278: || p_time_building_block_id,
1279: 100

Line 1316: g_debug := hr_utility.debug_enabled;

1312: IS
1313: l_proc VARCHAR2 (72);
1314: l_blocks hxc_block_table_type;
1315: BEGIN
1316: g_debug := hr_utility.debug_enabled;
1317:
1318: IF g_debug
1319: THEN
1320: l_proc := g_package || 'create_time_entry (Overloaded)';

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

1317:
1318: IF g_debug
1319: THEN
1320: l_proc := g_package || 'create_time_entry (Overloaded)';
1321: hr_utility.set_location ('Entering:' || l_proc, 10);
1322: END IF;
1323:
1324: l_blocks :=
1325: hxc_timestore_deposit_util.convert_tbb_to_type

Line 1342: hr_utility.set_location ( 'Leaving:'

1338: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
1339:
1340: IF g_debug
1341: THEN
1342: hr_utility.set_location ( 'Leaving:'
1343: || l_proc
1344: || ' p_time_building_block_id = '
1345: || p_time_building_block_id,
1346: 100

Line 1397: g_debug := hr_utility.debug_enabled;

1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1395: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1396: BEGIN
1397: g_debug := hr_utility.debug_enabled;
1398:
1399: IF g_debug
1400: THEN
1401: l_proc := g_package || 'create_time_entry (overloaded range)';

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

1398:
1399: IF g_debug
1400: THEN
1401: l_proc := g_package || 'create_time_entry (overloaded range)';
1402: hr_utility.set_location ('Entering:' || l_proc, 10);
1403: END IF;
1404:
1405: -- First find the DAY TBB to which this DETAIL TBB belongs
1406: hxc_timestore_deposit_util.find_parent_building_block

Line 1448: hr_utility.set_location ( 'Leaving:'

1444: );
1445:
1446: IF g_debug
1447: THEN
1448: hr_utility.set_location ( 'Leaving:'
1449: || l_proc
1450: || ' p_time_building_block_id = '
1451: || p_time_building_block_id,
1452: 100

Line 1489: g_debug := hr_utility.debug_enabled;

1485: IS
1486: l_proc VARCHAR2 (72);
1487: l_blocks hxc_block_table_type;
1488: BEGIN
1489: g_debug := hr_utility.debug_enabled;
1490:
1491: IF g_debug
1492: THEN
1493: l_proc := g_package || 'create_time_entry (Overloaded)';

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

1490:
1491: IF g_debug
1492: THEN
1493: l_proc := g_package || 'create_time_entry (Overloaded)';
1494: hr_utility.set_location ('Entering:' || l_proc, 10);
1495: END IF;
1496:
1497: l_blocks :=
1498: hxc_timestore_deposit_util.convert_tbb_to_type

Line 1515: hr_utility.set_location ( 'Leaving:'

1511: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
1512:
1513: IF g_debug
1514: THEN
1515: hr_utility.set_location ( 'Leaving:'
1516: || l_proc
1517: || ' p_time_building_block_id = '
1518: || p_time_building_block_id,
1519: 100

Line 1574: g_debug := hr_utility.debug_enabled;

1570: := NULL;
1571: l_segment hxc_mapping_components.SEGMENT%TYPE;
1572: attr_index PLS_INTEGER;
1573: BEGIN
1574: g_debug := hr_utility.debug_enabled;
1575:
1576: IF g_debug
1577: THEN
1578: l_proc := g_package || 'create_attribute';

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

1575:
1576: IF g_debug
1577: THEN
1578: l_proc := g_package || 'create_attribute';
1579: hr_utility.set_location ('Entering:' || l_proc, 10);
1580: END IF;
1581:
1582: hxc_timestore_deposit_util.get_bld_blk_info_type
1583: (p_attribute_name => p_attribute_name,

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

1650: p_app_attributes (l_attribute_count).changed := hxc_timecard.c_no;
1651:
1652: IF g_debug
1653: THEN
1654: hr_utility.set_location ('Leaving:' || l_proc, 20);
1655: END IF;
1656: END create_attribute;
1657:
1658: -----------------------------------------------------------------------------

Line 1701: g_debug := hr_utility.debug_enabled;

1697: l_proc VARCHAR2 (72);
1698: l_building_block_index PLS_INTEGER;
1699: l_load_new_timecard BOOLEAN;
1700: BEGIN
1701: g_debug := hr_utility.debug_enabled;
1702:
1703: IF g_debug
1704: THEN
1705: l_proc := g_package || 'update_building_block';

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

1702:
1703: IF g_debug
1704: THEN
1705: l_proc := g_package || 'update_building_block';
1706: hr_utility.set_location ('Entering:' || l_proc, 10);
1707: END IF;
1708:
1709: l_load_new_timecard := FALSE;
1710:

Line 1756: hr_utility.set_location ( ' - l_building_block_index = '

1752: );
1753:
1754: IF g_debug
1755: THEN
1756: hr_utility.set_location ( ' - l_building_block_index = '
1757: || l_building_block_index,
1758: 20
1759: );
1760: END IF;

Line 1813: hr_utility.set_location ('Leaving:' || l_proc, 30);

1809: p_app_blocks (l_building_block_index).changed := hxc_timecard.c_yes;
1810:
1811: IF g_debug
1812: THEN
1813: hr_utility.set_location ('Leaving:' || l_proc, 30);
1814: END IF;
1815: END update_building_block;
1816:
1817: -----------------------------------------------------------------------------

Line 1851: g_debug := hr_utility.debug_enabled;

1847: IS
1848: l_proc VARCHAR2 (72);
1849: l_blocks hxc_block_table_type;
1850: BEGIN
1851: g_debug := hr_utility.debug_enabled;
1852:
1853: IF g_debug
1854: THEN
1855: l_proc := g_package || 'update_building_block (Overloaded)';

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

1852:
1853: IF g_debug
1854: THEN
1855: l_proc := g_package || 'update_building_block (Overloaded)';
1856: hr_utility.set_location ('Entering:' || l_proc, 10);
1857: END IF;
1858:
1859: l_blocks :=
1860: hxc_timestore_deposit_util.convert_tbb_to_type

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

1874: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
1875:
1876: IF g_debug
1877: THEN
1878: hr_utility.set_location ('Leaving:' || l_proc, 20);
1879: END IF;
1880: END update_building_block;
1881:
1882: -----------------------------------------------------------------------------

Line 1917: g_debug := hr_utility.debug_enabled;

1913: IS
1914: l_proc VARCHAR2 (72);
1915: l_building_block_index PLS_INTEGER;
1916: BEGIN
1917: g_debug := hr_utility.debug_enabled;
1918:
1919: IF g_debug
1920: THEN
1921: l_proc := g_package || 'delete_detail_bb';

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

1918:
1919: IF g_debug
1920: THEN
1921: l_proc := g_package || 'delete_detail_bb';
1922: hr_utility.set_location ('Entering:' || l_proc, 10);
1923: END IF;
1924:
1925: -- First clear the global tables so no garbage gets loaded with the updated TC
1926: hxc_self_service_time_deposit.initialize_globals;

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

1948: p_app_blocks (l_building_block_index).changed := hxc_timecard.c_yes;
1949:
1950: IF g_debug
1951: THEN
1952: hr_utility.set_location ('Leaving:' || l_proc, 20);
1953: END IF;
1954: END delete_detail_bb;
1955:
1956: -----------------------------------------------------------------------------

Line 1986: g_debug := hr_utility.debug_enabled;

1982: IS
1983: l_proc VARCHAR2 (72);
1984: l_blocks hxc_block_table_type;
1985: BEGIN
1986: g_debug := hr_utility.debug_enabled;
1987:
1988: IF g_debug
1989: THEN
1990: l_proc := g_package || 'delete_detail_bb (Overloaded)';

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

1987:
1988: IF g_debug
1989: THEN
1990: l_proc := g_package || 'delete_detail_bb (Overloaded)';
1991: hr_utility.set_location ('Entering:' || l_proc, 10);
1992: END IF;
1993:
1994: l_blocks :=
1995: hxc_timestore_deposit_util.convert_tbb_to_type

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

2005: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
2006:
2007: IF g_debug
2008: THEN
2009: hr_utility.set_location ('Leaving:' || l_proc, 20);
2010: END IF;
2011: END delete_detail_bb;
2012:
2013: -- Use to delete a complete timecard, TBB id passed in has to be a TIMECARD TBB

Line 2052: g_debug := hr_utility.debug_enabled;

2048: IS
2049: l_proc VARCHAR2 (72);
2050: l_dummy VARCHAR2 (10);
2051: BEGIN
2052: g_debug := hr_utility.debug_enabled;
2053: l_dummy := 'N';
2054:
2055: IF g_debug
2056: THEN

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

2054:
2055: IF g_debug
2056: THEN
2057: l_proc := g_package || 'delete_timecard';
2058: hr_utility.set_location ('Entering:' || l_proc, 10);
2059: END IF;
2060:
2061: IF (NOT hxc_timestore_deposit_util.cla_enabled
2062: (p_building_block_id => p_building_block_id)

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

2072: END IF;
2073:
2074: IF g_debug
2075: THEN
2076: hr_utility.set_location ('Leaving:' || l_proc, 20);
2077: END IF;
2078: END delete_timecard;
2079:
2080: -----------------------------------------------------------------------------

Line 2127: g_debug := hr_utility.debug_enabled;

2123:
2124: l_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2125: --csr_tbb_id%ROWTYPE;
2126: BEGIN
2127: g_debug := hr_utility.debug_enabled;
2128:
2129: IF g_debug
2130: THEN
2131: l_proc := g_package || 'update_attribute';

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

2128:
2129: IF g_debug
2130: THEN
2131: l_proc := g_package || 'update_attribute';
2132: hr_utility.set_location ('Entering:' || l_proc, 10);
2133: END IF;
2134:
2135: l_load_new_timecard := FALSE;
2136:

Line 2216: hr_utility.set_location

2212: p_attribute_value;
2213:
2214: IF g_debug
2215: THEN
2216: hr_utility.set_location
2217: ( ' modifying '
2218: || p_app_attributes (l_attribute_index).attribute_value
2219: || ' to '
2220: || NVL (p_attribute_value, 'NULL'),

Line 2246: hr_utility.set_location ('Leaving:' || l_proc, 100);

2242: END IF;
2243:
2244: IF g_debug
2245: THEN
2246: hr_utility.set_location ('Leaving:' || l_proc, 100);
2247: END IF;
2248: END update_attribute;
2249:
2250: -----------------------------------------------------------------------------

Line 2283: g_debug := hr_utility.debug_enabled;

2279: IS
2280: l_proc VARCHAR2 (72);
2281: l_blocks hxc_block_table_type;
2282: BEGIN
2283: g_debug := hr_utility.debug_enabled;
2284:
2285: IF g_debug
2286: THEN
2287: l_proc := g_package || 'update_attribute';

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

2284:
2285: IF g_debug
2286: THEN
2287: l_proc := g_package || 'update_attribute';
2288: hr_utility.set_location ('Entering:' || l_proc, 10);
2289: END IF;
2290:
2291: l_blocks :=
2292: hxc_timestore_deposit_util.convert_tbb_to_type

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

2305: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
2306:
2307: IF g_debug
2308: THEN
2309: hr_utility.set_location ('Leaving:' || l_proc, 20);
2310: END IF;
2311: END update_attribute;
2312:
2313: -----------------------------------------------------------------------------

Line 2364: g_debug := hr_utility.debug_enabled;

2360: l_released_success BOOLEAN;
2361: l_row_lock_id ROWID;
2362: l_appl_set_id NUMBER;
2363: BEGIN
2364: g_debug := hr_utility.debug_enabled;
2365: l_attributes := hxc_attribute_table_type ();
2366:
2367: IF g_debug
2368: THEN

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

2366:
2367: IF g_debug
2368: THEN
2369: l_proc := g_package || 'execute_deposit_process';
2370: hr_utility.set_location ('Entering:' || l_proc, 10);
2371: END IF;
2372:
2373: -- issue savepoint in case running in validate mode
2374: SAVEPOINT validation_only;

Line 2478: hr_utility.TRACE ('l_attributes.count = ' || l_attributes.COUNT);

2474: );
2475:
2476: IF g_debug
2477: THEN
2478: hr_utility.TRACE ('l_attributes.count = ' || l_attributes.COUNT);
2479: hr_utility.TRACE ( 'p_app_attributes.count = '
2480: || p_app_attributes.COUNT
2481: );
2482: END IF;

Line 2479: hr_utility.TRACE ( 'p_app_attributes.count = '

2475:
2476: IF g_debug
2477: THEN
2478: hr_utility.TRACE ('l_attributes.count = ' || l_attributes.COUNT);
2479: hr_utility.TRACE ( 'p_app_attributes.count = '
2480: || p_app_attributes.COUNT
2481: );
2482: END IF;
2483:

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

2575: END IF;
2576:
2577: IF g_debug
2578: THEN
2579: hr_utility.set_location ('Leaving:' || l_proc, 20);
2580: END IF;
2581: EXCEPTION
2582: --
2583: WHEN hr_api.validate_enabled

Line 2591: hr_utility.set_location ('Leaving (validation mode):' || l_proc,

2587: ROLLBACK TO validation_only;
2588:
2589: IF g_debug
2590: THEN
2591: hr_utility.set_location ('Leaving (validation mode):' || l_proc,
2592: 30
2593: );
2594: END IF;
2595: WHEN OTHERS

Line 2647: g_debug := hr_utility.debug_enabled;

2643: l_blocks hxc_block_table_type;
2644: l_messages hxc_message_table_type;
2645: l_proc VARCHAR2 (72);
2646: BEGIN
2647: g_debug := hr_utility.debug_enabled;
2648:
2649: IF g_debug
2650: THEN
2651: l_proc := g_package || 'execute_deposit_process (Overloaded)';

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

2648:
2649: IF g_debug
2650: THEN
2651: l_proc := g_package || 'execute_deposit_process (Overloaded)';
2652: hr_utility.set_location ('Entering:' || l_proc, 10);
2653: END IF;
2654:
2655: l_blocks :=
2656: hxc_timestore_deposit_util.convert_tbb_to_type

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

2679: (p_messages => l_messages);
2680:
2681: IF g_debug
2682: THEN
2683: hr_utility.set_location ('Leaving:' || l_proc, 20);
2684: END IF;
2685: END execute_deposit_process;
2686:
2687: PROCEDURE clear_building_block_table (