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

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hxcflxdn.pkb 120.13.12020000.2 2012/09/26 16:02:33 bbayragi ship $ */
3: --
4: -- Global store for the number of global data elements
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: g_global_segment_count NUMBER := 0;
8:
9: FUNCTION check_delete_info_type(p_info_type_basis VARCHAR2)
10: return NUMBER is

Line 379: hr_utility.trace('Entered REMOVE_HXC_ABS_ELEM_INFO');

375: present element type ids and then insert it.
376: */
377:
378: if g_debug then
379: hr_utility.trace('Entered REMOVE_HXC_ABS_ELEM_INFO');
380: end if;
381:
382:
383: IF p_element_type_id is not null and g_abs_incl_flag = 'Y' THEN

Line 398: hr_utility.trace('REMOVE_HXC_ABS_ELEM_INFO for element ='||p_element_type_id);

394: where element_type_id=p_element_type_id;
395:
396: if g_debug then
397:
398: hr_utility.trace('REMOVE_HXC_ABS_ELEM_INFO for element ='||p_element_type_id);
399:
400: end if;
401:
402: --commit;

Line 411: hr_utility.trace('Leaving REMOVE_HXC_ABS_ELEM_INFO');

407:
408: p_error_msg := null;
409:
410: if g_debug then
411: hr_utility.trace('Leaving REMOVE_HXC_ABS_ELEM_INFO');
412: end if;
413:
414:
415:

Line 1431: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');

1427: l_sequence_code := p_context_prefix || 'C - ' || l_sequence_no;
1428: END IF;
1429: CLOSE get_max_sequence;
1430: end if;
1431: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');
1432:
1433:
1434: -- Description of the messages needs to be
1435: --'System context, do not modify.Context Name.

Line 1440: l_message := hr_utility.get_message;

1436: --Description'. So keeping in view to avoid
1437: --translation problems, a message is created
1438: --with the above name and the text as 'System
1439: --context, do not modify''
1440: l_message := hr_utility.get_message;
1441: -- Creates the context
1442: fnd_flex_dsc_api.create_context
1443: (appl_short_name=> p_otc_appl_short_name,
1444: flexfield_name=> p_otc_flex_name,

Line 1584: hr_utility.trace('Entered INSERT_INTO_HXC_ABSENCES');

1580: present element type ids and den insert it.
1581: */
1582:
1583: if g_debug then
1584: hr_utility.trace('Entered INSERT_INTO_HXC_ABSENCES');
1585: end if;
1586:
1587: IF p_abs_info.COUNT > 0 THEN
1588:

Line 1603: hr_utility.trace('Inserting');

1599: IF (chk_abs_elem_exists%NOTFOUND) THEN
1600:
1601: if g_debug then
1602:
1603: hr_utility.trace('Inserting');
1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);
1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);

Line 1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);

1600:
1601: if g_debug then
1602:
1603: hr_utility.trace('Inserting');
1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);
1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);
1608: hr_utility.trace('ABSENCE_CATEGORY = '||p_abs_info(tab_count).ABSENCE_CATEGORY);

Line 1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);

1601: if g_debug then
1602:
1603: hr_utility.trace('Inserting');
1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);
1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);
1608: hr_utility.trace('ABSENCE_CATEGORY = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1609:

Line 1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);

1602:
1603: hr_utility.trace('Inserting');
1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);
1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);
1608: hr_utility.trace('ABSENCE_CATEGORY = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1609:
1610:

Line 1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);

1603: hr_utility.trace('Inserting');
1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);
1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);
1608: hr_utility.trace('ABSENCE_CATEGORY = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1609:
1610:
1611: end if;

Line 1608: hr_utility.trace('ABSENCE_CATEGORY = '||p_abs_info(tab_count).ABSENCE_CATEGORY);

1604: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1605: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1606: hr_utility.trace('EDIT_FLAG = '||p_abs_info(tab_count).EDIT_FLAG);
1607: hr_utility.trace('UOM = '||p_abs_info(tab_count).UOM);
1608: hr_utility.trace('ABSENCE_CATEGORY = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1609:
1610:
1611: end if;
1612:

Line 1633: hr_utility.trace('Updating');

1629: );
1630:
1631: ELSE
1632: if g_debug then
1633: hr_utility.trace('Updating');
1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);
1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);

Line 1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);

1630:
1631: ELSE
1632: if g_debug then
1633: hr_utility.trace('Updating');
1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);
1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);
1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);

Line 1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);

1631: ELSE
1632: if g_debug then
1633: hr_utility.trace('Updating');
1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);
1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);
1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1639: end if;

Line 1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);

1632: if g_debug then
1633: hr_utility.trace('Updating');
1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);
1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);
1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1639: end if;
1640:

Line 1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);

1633: hr_utility.trace('Updating');
1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);
1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);
1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1639: end if;
1640:
1641:

Line 1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);

1634: hr_utility.trace('ABSENCE_ATTENDANCE_TYPE_ID = '||p_abs_info(tab_count).ABSENCE_ATTENDANCE_TYPE_ID);
1635: hr_utility.trace('ELEMENT_TYPE_ID = '||p_abs_info(tab_count).ELEMENT_TYPE_ID);
1636: hr_utility.trace('EDIT_FLAG NEW = '||p_abs_info(tab_count).EDIT_FLAG);
1637: hr_utility.trace('UOM NEW= '||p_abs_info(tab_count).UOM);
1638: hr_utility.trace('ABSENCE_CATEGORY NEW = '||p_abs_info(tab_count).ABSENCE_CATEGORY);
1639: end if;
1640:
1641:
1642: UPDATE hxc_absence_type_elements

Line 1898: hr_utility.trace('In hxc_create_flex_mappings.run process ..');

1894:
1895: BEGIN
1896:
1897: IF g_debug THEN
1898: hr_utility.trace('In hxc_create_flex_mappings.run process ..');
1899: hr_utility.trace('undo ::'||p_undo );
1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );

Line 1899: hr_utility.trace('undo ::'||p_undo );

1895: BEGIN
1896:
1897: IF g_debug THEN
1898: hr_utility.trace('In hxc_create_flex_mappings.run process ..');
1899: hr_utility.trace('undo ::'||p_undo );
1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );

Line 1900: hr_utility.trace('element_set_id ::'||p_element_set_id );

1896:
1897: IF g_debug THEN
1898: hr_utility.trace('In hxc_create_flex_mappings.run process ..');
1899: hr_utility.trace('undo ::'||p_undo );
1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );

Line 1901: hr_utility.trace('effective_date ::'||p_effective_date );

1897: IF g_debug THEN
1898: hr_utility.trace('In hxc_create_flex_mappings.run process ..');
1899: hr_utility.trace('undo ::'||p_undo );
1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );

Line 1902: hr_utility.trace('generate_cost ::'||p_generate_cost );

1898: hr_utility.trace('In hxc_create_flex_mappings.run process ..');
1899: hr_utility.trace('undo ::'||p_undo );
1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );

Line 1903: hr_utility.trace('generate_group ::'||p_generate_group );

1899: hr_utility.trace('undo ::'||p_undo );
1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );
1907: hr_utility.trace('business_group_id ::'||p_business_group_id );

Line 1904: hr_utility.trace('generate_job ::'||p_generate_job );

1900: hr_utility.trace('element_set_id ::'||p_element_set_id );
1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );
1907: hr_utility.trace('business_group_id ::'||p_business_group_id );
1908: hr_utility.trace('incl_abs_flg ::'||p_incl_abs_flg );

Line 1905: hr_utility.trace('generate_pos ::'||p_generate_pos );

1901: hr_utility.trace('effective_date ::'||p_effective_date );
1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );
1907: hr_utility.trace('business_group_id ::'||p_business_group_id );
1908: hr_utility.trace('incl_abs_flg ::'||p_incl_abs_flg );
1909: END IF;

Line 1906: hr_utility.trace('generate_prj ::'||p_generate_prj );

1902: hr_utility.trace('generate_cost ::'||p_generate_cost );
1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );
1907: hr_utility.trace('business_group_id ::'||p_business_group_id );
1908: hr_utility.trace('incl_abs_flg ::'||p_incl_abs_flg );
1909: END IF;
1910: /*

Line 1907: hr_utility.trace('business_group_id ::'||p_business_group_id );

1903: hr_utility.trace('generate_group ::'||p_generate_group );
1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );
1907: hr_utility.trace('business_group_id ::'||p_business_group_id );
1908: hr_utility.trace('incl_abs_flg ::'||p_incl_abs_flg );
1909: END IF;
1910: /*
1911: Added for 8645021 HR OTL Absence Integration

Line 1908: hr_utility.trace('incl_abs_flg ::'||p_incl_abs_flg );

1904: hr_utility.trace('generate_job ::'||p_generate_job );
1905: hr_utility.trace('generate_pos ::'||p_generate_pos );
1906: hr_utility.trace('generate_prj ::'||p_generate_prj );
1907: hr_utility.trace('business_group_id ::'||p_business_group_id );
1908: hr_utility.trace('incl_abs_flg ::'||p_incl_abs_flg );
1909: END IF;
1910: /*
1911: Added for 8645021 HR OTL Absence Integration
1912:

Line 1923: hr_utility.set_message (809, 'HXC_GEN_FLEX_MOD_ALT_WAR_MSG');

1919:
1920:
1921: /* Bug fix for 3353252
1922: Initialize the string for the warning messages which will be printed if there is any duplication in the alternate names*/
1923: hr_utility.set_message (809, 'HXC_GEN_FLEX_MOD_ALT_WAR_MSG');
1924: l_name:=HR_UTILITY.GET_MESSAGE;
1925: /* end of fix for 3353252*/
1926:
1927: --

Line 1924: l_name:=HR_UTILITY.GET_MESSAGE;

1920:
1921: /* Bug fix for 3353252
1922: Initialize the string for the warning messages which will be printed if there is any duplication in the alternate names*/
1923: hr_utility.set_message (809, 'HXC_GEN_FLEX_MOD_ALT_WAR_MSG');
1924: l_name:=HR_UTILITY.GET_MESSAGE;
1925: /* end of fix for 3353252*/
1926:
1927: --
1928: -- Convert the entered date into real date format

Line 2050: hr_utility.trace('hxc_abs_tab.COUNT = '||hxc_abs_tab.COUNT);

2046: END LOOP; -- abs_info
2047:
2048: if g_debug then
2049:
2050: hr_utility.trace('hxc_abs_tab.COUNT = '||hxc_abs_tab.COUNT);
2051:
2052:
2053:
2054: if hxc_abs_tab.count>0 then

Line 2061: hr_utility.trace('hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID = '||hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID);

2057: LOOP
2058:
2059: if hxc_abs_tab.EXISTS(i) then
2060:
2061: hr_utility.trace('hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID = '||hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID);
2062: hr_utility.trace('hxc_abs_tab(i).ELEMENT_TYPE_ID = '||hxc_abs_tab(i).ELEMENT_TYPE_ID);
2063: hr_utility.trace('hxc_abs_tab(i).EDIT_FLAG = '||hxc_abs_tab(i).EDIT_FLAG);
2064: hr_utility.trace('hxc_abs_tab(i).UOM = '||hxc_abs_tab(i).UOM);
2065: hr_utility.trace('hxc_abs_tab(i).ABSENCE_CATEGORY = '||hxc_abs_tab(i).ABSENCE_CATEGORY);

Line 2062: hr_utility.trace('hxc_abs_tab(i).ELEMENT_TYPE_ID = '||hxc_abs_tab(i).ELEMENT_TYPE_ID);

2058:
2059: if hxc_abs_tab.EXISTS(i) then
2060:
2061: hr_utility.trace('hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID = '||hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID);
2062: hr_utility.trace('hxc_abs_tab(i).ELEMENT_TYPE_ID = '||hxc_abs_tab(i).ELEMENT_TYPE_ID);
2063: hr_utility.trace('hxc_abs_tab(i).EDIT_FLAG = '||hxc_abs_tab(i).EDIT_FLAG);
2064: hr_utility.trace('hxc_abs_tab(i).UOM = '||hxc_abs_tab(i).UOM);
2065: hr_utility.trace('hxc_abs_tab(i).ABSENCE_CATEGORY = '||hxc_abs_tab(i).ABSENCE_CATEGORY);
2066:

Line 2063: hr_utility.trace('hxc_abs_tab(i).EDIT_FLAG = '||hxc_abs_tab(i).EDIT_FLAG);

2059: if hxc_abs_tab.EXISTS(i) then
2060:
2061: hr_utility.trace('hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID = '||hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID);
2062: hr_utility.trace('hxc_abs_tab(i).ELEMENT_TYPE_ID = '||hxc_abs_tab(i).ELEMENT_TYPE_ID);
2063: hr_utility.trace('hxc_abs_tab(i).EDIT_FLAG = '||hxc_abs_tab(i).EDIT_FLAG);
2064: hr_utility.trace('hxc_abs_tab(i).UOM = '||hxc_abs_tab(i).UOM);
2065: hr_utility.trace('hxc_abs_tab(i).ABSENCE_CATEGORY = '||hxc_abs_tab(i).ABSENCE_CATEGORY);
2066:
2067: end if;

Line 2064: hr_utility.trace('hxc_abs_tab(i).UOM = '||hxc_abs_tab(i).UOM);

2060:
2061: hr_utility.trace('hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID = '||hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID);
2062: hr_utility.trace('hxc_abs_tab(i).ELEMENT_TYPE_ID = '||hxc_abs_tab(i).ELEMENT_TYPE_ID);
2063: hr_utility.trace('hxc_abs_tab(i).EDIT_FLAG = '||hxc_abs_tab(i).EDIT_FLAG);
2064: hr_utility.trace('hxc_abs_tab(i).UOM = '||hxc_abs_tab(i).UOM);
2065: hr_utility.trace('hxc_abs_tab(i).ABSENCE_CATEGORY = '||hxc_abs_tab(i).ABSENCE_CATEGORY);
2066:
2067: end if;
2068:

Line 2065: hr_utility.trace('hxc_abs_tab(i).ABSENCE_CATEGORY = '||hxc_abs_tab(i).ABSENCE_CATEGORY);

2061: hr_utility.trace('hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID = '||hxc_abs_tab(i).ABSENCE_ATTENDANCE_TYPE_ID);
2062: hr_utility.trace('hxc_abs_tab(i).ELEMENT_TYPE_ID = '||hxc_abs_tab(i).ELEMENT_TYPE_ID);
2063: hr_utility.trace('hxc_abs_tab(i).EDIT_FLAG = '||hxc_abs_tab(i).EDIT_FLAG);
2064: hr_utility.trace('hxc_abs_tab(i).UOM = '||hxc_abs_tab(i).UOM);
2065: hr_utility.trace('hxc_abs_tab(i).ABSENCE_CATEGORY = '||hxc_abs_tab(i).ABSENCE_CATEGORY);
2066:
2067: end if;
2068:
2069: END LOOP;

Line 2085: hr_utility.trace('abs_elem_exists.COUNT = '||abs_elem_exists.COUNT);

2081:
2082: END LOOP; -- hxc_abs_tab plsql table loop
2083:
2084: if g_debug then
2085: hr_utility.trace('abs_elem_exists.COUNT = '||abs_elem_exists.COUNT);
2086: end if;
2087:
2088:
2089: END IF; -- hxc_abs_tab.count

Line 2110: hr_utility.trace('l_non_abs_elem_exists = '||l_non_abs_elem_exists);

2106: END IF; -- p_incl_abs_flg
2107: -- change end
2108:
2109: if g_debug then
2110: hr_utility.trace('l_non_abs_elem_exists = '||l_non_abs_elem_exists);
2111: end if;
2112: --
2113: -- Get the element set name.
2114: --

Line 2162: hr_utility.set_message(809,'HXC_SEED_ALT_NOT_FOUND');

2158: -- change parameters to create_alias_definitions
2159: open c_alias_type(l_an_context);
2160: fetch c_alias_type into l_alias_type_id;
2161: if (l_alias_type_id is null) then
2162: hr_utility.set_message(809,'HXC_SEED_ALT_NOT_FOUND');
2163: hr_utility.raise_error;
2164: end if;
2165: close c_alias_type;
2166:

Line 2163: hr_utility.raise_error;

2159: open c_alias_type(l_an_context);
2160: fetch c_alias_type into l_alias_type_id;
2161: if (l_alias_type_id is null) then
2162: hr_utility.set_message(809,'HXC_SEED_ALT_NOT_FOUND');
2163: hr_utility.raise_error;
2164: end if;
2165: close c_alias_type;
2166:
2167: open c_prompt(l_an_context);

Line 2183: hr_utility.trace('Creating Alias Definitions');

2179: IF l_non_abs_elem_exists = 'Y' then --
2180: -- change end
2181:
2182: if g_debug then
2183: hr_utility.trace('Creating Alias Definitions');
2184: end if;
2185:
2186: IF l_an_en_exists = 'N' THEN
2187: hxc_alias_definitions_api.create_alias_definition

Line 2226: hr_utility.trace('Open the element set cursor, and fetch the elements..');

2222: Open the element type cursor, and fetch the first element
2223: */
2224:
2225: IF g_debug THEN
2226: hr_utility.trace('Open the element set cursor, and fetch the elements..');
2227: END IF;
2228:
2229: for ele_rec in c_elements(p_element_set_id, l_effective_date) LOOP
2230: -- Check if this element already exists in the values for

Line 2273: hr_utility.trace('Creating Alias Values for '||ele_rec.element_type_id);

2269: IF l_abs_elem_flg ='N' then -- svg abs_intg
2270: -- change end
2271:
2272: if g_debug then
2273: hr_utility.trace('Creating Alias Values for '||ele_rec.element_type_id);
2274: end if;
2275:
2276:
2277: IF l_en_value_exists = 'N' THEN

Line 2388: hr_utility.trace('l_element_count ::'||l_element_count);

2384:
2385: l_element_count := l_element_count +1;
2386:
2387: IF g_debug THEN
2388: hr_utility.trace('l_element_count ::'||l_element_count);
2389: hr_utility.trace('call to Create the Building block information type for this context ::'||ele_rec.element_type_id);
2390: END IF;
2391: --
2392: -- Create the Building block information type for this context

Line 2389: hr_utility.trace('call to Create the Building block information type for this context ::'||ele_rec.element_type_id);

2385: l_element_count := l_element_count +1;
2386:
2387: IF g_debug THEN
2388: hr_utility.trace('l_element_count ::'||l_element_count);
2389: hr_utility.trace('call to Create the Building block information type for this context ::'||ele_rec.element_type_id);
2390: END IF;
2391: --
2392: -- Create the Building block information type for this context
2393: --

Line 2403: hr_utility.trace('intial value of l_disp_flag ::'||l_disp_flag);

2399: p_category => 'ELEMENT');
2400:
2401:
2402: IF g_debug THEN
2403: hr_utility.trace('intial value of l_disp_flag ::'||l_disp_flag);
2404: END IF;
2405:
2406: -- Modified for Bug 12741569
2407:

Line 2427: hr_utility.trace('l_disp_flag for element -'||ele_rec.element_type_id||'- ::'||l_disp_flag);

2423:
2424: /* Bug 5919417 End */
2425:
2426: IF g_debug THEN
2427: hr_utility.trace('l_disp_flag for element -'||ele_rec.element_type_id||'- ::'||l_disp_flag);
2428: hr_utility.trace('initial segment count ::'||l_segment_count);
2429: END IF;
2430:
2431: --

Line 2428: hr_utility.trace('initial segment count ::'||l_segment_count);

2424: /* Bug 5919417 End */
2425:
2426: IF g_debug THEN
2427: hr_utility.trace('l_disp_flag for element -'||ele_rec.element_type_id||'- ::'||l_disp_flag);
2428: hr_utility.trace('initial segment count ::'||l_segment_count);
2429: END IF;
2430:
2431: --
2432: -- Now fetch each input value and generate segments, if we are creating

Line 2465: hr_utility.trace('In diplay flag check -- segment count ::'||l_segment_count);

2461: -- Modified for Bug 14570475
2462: if l_segment_count = 11 and l_disp_flag = 'Y' then
2463: l_segment_count := l_segment_count + 4;
2464: IF g_debug THEN
2465: hr_utility.trace('In diplay flag check -- segment count ::'||l_segment_count);
2466: END IF;
2467: end if;
2468:
2469: /* Bug 5919417 Start */