DBA Data[Home] [Help]

APPS.HXC_TIMECARD_AUDIT dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_timecard_audit AS
2: /* $Header: hxctcaudit.pkb 120.2 2005/09/23 09:02:16 nissharm noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Function find_overall_status
7: (p_transaction_info in hxc_timecard.transaction_info
8: ) return varchar2 is

Line 201: g_debug := hr_utility.debug_enabled;

197: l_status hxc_time_building_blocks.approval_status%TYPE;
198:
199: BEGIN
200:
201: g_debug := hr_utility.debug_enabled;
202:
203: if g_debug then
204: hr_utility.trace('GAZ in maintain details 1');
205: end if;

Line 204: hr_utility.trace('GAZ in maintain details 1');

200:
201: g_debug := hr_utility.debug_enabled;
202:
203: if g_debug then
204: hr_utility.trace('GAZ in maintain details 1');
205: end if;
206:
207: hxc_timecard_block_utils.sort_blocks
208: (p_blocks => p_blocks

Line 222: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));

218:
219: l_blk_ind := l_detail_blocks(l_detail_ind);
220:
221: --if g_debug then
222: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
223: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
224: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
225: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
226: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);

Line 223: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));

219: l_blk_ind := l_detail_blocks(l_detail_ind);
220:
221: --if g_debug then
222: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
223: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
224: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
225: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
226: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
227: --end if;

Line 224: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));

220:
221: --if g_debug then
222: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
223: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
224: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
225: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
226: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
227: --end if;
228:

Line 225: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);

221: --if g_debug then
222: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
223: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
224: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
225: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
226: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
227: --end if;
228:
229: -- Override status for deleted building blocks. These should always be passed to

Line 226: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);

222: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
223: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
224: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
225: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
226: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
227: --end if;
228:
229: -- Override status for deleted building blocks. These should always be passed to
230: -- recipient applications for processing once deleted.

Line 247: -- hr_utility.trace('gaz about to insert '||to_char(p_blocks(l_blk_ind).time_building_Block_id));

243: IF ( p_blocks(l_blk_ind).object_version_number = 1 AND p_blocks(l_blk_ind).process = 'Y' )
244: THEN
245:
246: --if g_debug then
247: -- hr_utility.trace('gaz about to insert '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
248: --end if;
249:
250: -- insert row
251:

Line 280: -- hr_utility.trace('gaz about to update '||to_char(p_blocks(l_blk_ind).time_building_Block_id));

276:
277: ELSIF ( p_blocks(l_blk_ind).object_version_number > 1 and p_blocks(l_blk_ind).process = 'Y' )
278: THEN
279: --if g_debug then
280: -- hr_utility.trace('gaz about to update '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
281: --end if;
282:
283: -- update row
284:

Line 335: hr_utility.trace(SQLERRM);

331:
332: exception when others then
333:
334: if g_debug then
335: hr_utility.trace(SQLERRM);
336: end if;
337:
338: raise;
339: