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

Line 4: g_debug boolean :=hr_utility.debug_enabled;

1: PACKAGE BODY hxc_entity_groups_upload_pkg AS
2: /* $Header: hxcetgupl.pkb 120.2 2005/09/23 08:08:24 sechandr noship $ */
3:
4: g_debug boolean :=hr_utility.debug_enabled;
5:
6: FUNCTION GET_ENTITY_GROUP_ID(p_entity_type in varchar2, p_name in varchar2)
7: RETURN NUMBER IS
8:

Line 36: g_debug:=hr_utility.debug_enabled;

32: l_owner VARCHAR2(6);
33:
34: BEGIN
35:
36: g_debug:=hr_utility.debug_enabled;
37: if g_debug then
38: hr_utility.trace('P_NAME ='||P_NAME );
39: end if;
40: SELECT entity_group_id,

Line 38: hr_utility.trace('P_NAME ='||P_NAME );

34: BEGIN
35:
36: g_debug:=hr_utility.debug_enabled;
37: if g_debug then
38: hr_utility.trace('P_NAME ='||P_NAME );
39: end if;
40: SELECT entity_group_id,
41: entity_type,
42: object_version_number,

Line 99: g_debug:=hr_utility.debug_enabled;

95: -- check to see row exists
96:
97:
98: l_entity_group_id := GET_ENTITY_GROUP_ID(P_ENTITY_TYPE,P_NAME);
99: g_debug:=hr_utility.debug_enabled;
100: if g_debug then
101: hr_utility.trace('l_entity_group_id'||l_entity_group_id);
102: end if;
103:

Line 101: hr_utility.trace('l_entity_group_id'||l_entity_group_id);

97:
98: l_entity_group_id := GET_ENTITY_GROUP_ID(P_ENTITY_TYPE,P_NAME);
99: g_debug:=hr_utility.debug_enabled;
100: if g_debug then
101: hr_utility.trace('l_entity_group_id'||l_entity_group_id);
102: end if;
103:
104: SELECT
105: entity_group_comp_id,

Line 117: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);

113: WHERE entity_group_id = l_entity_group_id
114: AND attribute_category = P_ATTRIBUTE_CATEGORY;
115:
116: if g_debug then
117: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);
118: hr_utility.trace('p_custom_mode='||p_custom_mode);
119: hr_utility.trace('l_owner ='||l_owner );
120: end if;
121:

Line 118: hr_utility.trace('p_custom_mode='||p_custom_mode);

114: AND attribute_category = P_ATTRIBUTE_CATEGORY;
115:
116: if g_debug then
117: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);
118: hr_utility.trace('p_custom_mode='||p_custom_mode);
119: hr_utility.trace('l_owner ='||l_owner );
120: end if;
121:
122: -- IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )

Line 119: hr_utility.trace('l_owner ='||l_owner );

115:
116: if g_debug then
117: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);
118: hr_utility.trace('p_custom_mode='||p_custom_mode);
119: hr_utility.trace('l_owner ='||l_owner );
120: end if;
121:
122: -- IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
123: -- THEN

Line 125: hr_utility.trace('Starting to upd --');

121:
122: -- IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
123: -- THEN
124: if g_debug then
125: hr_utility.trace('Starting to upd --');
126: end if;
127: hxc_egc_upd.upd(
128: p_entity_group_comp_id => l_entity_group_comp_id
129: ,p_object_version_number => l_object_version_number

Line 141: hr_utility.trace('Finishing from upd --');

137: ,p_effective_date => sysdate
138: ,p_called_from_form => null
139: );
140: if g_debug then
141: hr_utility.trace('Finishing from upd --');
142: end if;
143: -- END IF;
144:
145: EXCEPTION WHEN NO_DATA_FOUND

Line 149: hr_utility.trace('Starting to ins--');

145: EXCEPTION WHEN NO_DATA_FOUND
146: THEN
147: BEGIN
148: if g_debug then
149: hr_utility.trace('Starting to ins--');
150: end if;
151:
152: hxc_egc_ins.ins(
153: p_entity_group_comp_id => l_entity_group_comp_id

Line 166: hr_utility.trace('Finishing to ins--');

162: ,p_effective_date => sysdate
163: ,p_called_from_form => null
164: );
165: if g_debug then
166: hr_utility.trace('Finishing to ins--');
167: end if;
168: END;
169:
170: END LOAD_ENTITY_GROUP_COMPS_ROW;

Line 191: g_debug:=hr_utility.debug_enabled;

187: BEGIN
188:
189: l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
190: l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
191: g_debug:=hr_utility.debug_enabled;
192:
193: if g_debug then
194: hr_utility.trace('P_NAME ='||P_NAME );
195: end if;

Line 194: hr_utility.trace('P_NAME ='||P_NAME );

190: l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
191: g_debug:=hr_utility.debug_enabled;
192:
193: if g_debug then
194: hr_utility.trace('P_NAME ='||P_NAME );
195: end if;
196:
197: SELECT entity_group_id,
198: entity_type,

Line 269: g_debug:=hr_utility.debug_enabled;

265:
266: l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
267: l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
268: l_entity_group_id := GET_ENTITY_GROUP_ID(P_ENTITY_TYPE,P_NAME);
269: g_debug:=hr_utility.debug_enabled;
270:
271: if g_debug then
272: hr_utility.trace('l_entity_group_id'||l_entity_group_id);
273: end if;

Line 272: hr_utility.trace('l_entity_group_id'||l_entity_group_id);

268: l_entity_group_id := GET_ENTITY_GROUP_ID(P_ENTITY_TYPE,P_NAME);
269: g_debug:=hr_utility.debug_enabled;
270:
271: if g_debug then
272: hr_utility.trace('l_entity_group_id'||l_entity_group_id);
273: end if;
274:
275: SELECT
276: entity_group_comp_id,

Line 290: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);

286: WHERE entity_group_id = l_entity_group_id
287: AND attribute_category = P_ATTRIBUTE_CATEGORY;
288:
289: if g_debug then
290: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);
291: hr_utility.trace('p_custom_mode='||p_custom_mode);
292: end if;
293:
294: IF (fnd_load_util.upload_test( l_last_updated_by_f,

Line 291: hr_utility.trace('p_custom_mode='||p_custom_mode);

287: AND attribute_category = P_ATTRIBUTE_CATEGORY;
288:
289: if g_debug then
290: hr_utility.trace('l_entity_group_comp_id=2='||l_entity_group_comp_id);
291: hr_utility.trace('p_custom_mode='||p_custom_mode);
292: end if;
293:
294: IF (fnd_load_util.upload_test( l_last_updated_by_f,
295: l_last_update_date_f,

Line 301: hr_utility.trace('Starting to upd --');

297: l_last_update_date_db ,
298: p_custom_mode))
299: THEN
300: if g_debug then
301: hr_utility.trace('Starting to upd --');
302: end if;
303: hxc_egc_upd.upd(
304: p_entity_group_comp_id => l_entity_group_comp_id
305: ,p_object_version_number => l_object_version_number

Line 317: hr_utility.trace('Finishing from upd --');

313: ,p_effective_date => sysdate
314: ,p_called_from_form => null
315: );
316: if g_debug then
317: hr_utility.trace('Finishing from upd --');
318: end if;
319: END IF;
320:
321: EXCEPTION WHEN NO_DATA_FOUND

Line 325: hr_utility.trace('Starting to ins--');

321: EXCEPTION WHEN NO_DATA_FOUND
322: THEN
323: BEGIN
324: if g_debug then
325: hr_utility.trace('Starting to ins--');
326: end if;
327:
328: hxc_egc_ins.ins(
329: p_entity_group_comp_id => l_entity_group_comp_id

Line 342: hr_utility.trace('Finishing to ins--');

338: ,p_effective_date => sysdate
339: ,p_called_from_form => null
340: );
341: if g_debug then
342: hr_utility.trace('Finishing to ins--');
343: end if;
344: END;
345:
346: END LOAD_ENTITY_GROUP_COMPS_ROW;