DBA Data[Home] [Help]

APPS.HXC_BLOCK_ATTRIBUTE_UPDATE dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_block_attribute_update AS
2: /* $Header: hxcbkatup.pkb 120.6 2011/10/28 09:24:24 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: type block_list is table of number index by binary_integer;
7: --
8: -- Use this procedure to convert the ids prior to a successful

Line 177: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 0');

173: l_proc varchar2(72):= 'blockattrup.setprocessflags';
174: Begin
175:
176: IF g_debug THEN
177: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 0');
178: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
179: END IF;
180:
181:

Line 178: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

174: Begin
175:
176: IF g_debug THEN
177: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 0');
178: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
179: END IF;
180:
181:
182: l_index := p_blocks.first;

Line 192: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 1');

188:
189: if(hxc_timecard_block_utils.is_new_block(l_block)) then
190:
191: IF g_debug THEN
192: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 1');
193: END IF;
194:
195: hxc_block_attribute_update.g_tc_api_flag := 'N'; -- Added for Bug 12774447
196:

Line 198: hr_utility.trace('In hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);

194:
195: hxc_block_attribute_update.g_tc_api_flag := 'N'; -- Added for Bug 12774447
196:
197: IF g_debug THEN
198: hr_utility.trace('In hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);
199: END IF;
200:
201: if(hxc_timecard_block_utils.is_active_block(l_block)) then
202: p_blocks(l_index).process := 'Y';

Line 215: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 2');

211: ,p_time_building_block_ovn => l_block.object_version_number
212: );
213:
214: IF g_debug THEN
215: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 2');
216: hr_utility.trace('calling hxc_timecard_block_utils.blocks_are_different proc.');
217: END IF;
218:
219:

Line 216: hr_utility.trace('calling hxc_timecard_block_utils.blocks_are_different proc.');

212: );
213:
214: IF g_debug THEN
215: hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 2');
216: hr_utility.trace('calling hxc_timecard_block_utils.blocks_are_different proc.');
217: END IF;
218:
219:
220:

Line 237: hr_utility.trace('In hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);

233: p_blocks(l_index).changed := 'N';
234: end if;
235:
236: IF g_debug THEN
237: hr_utility.trace('In hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);
238: hr_utility.trace('p_blocks(l_index).process ::'|| p_blocks(l_index).process);
239: hr_utility.trace('p_blocks(l_index).changed ::'|| p_blocks(l_index).changed);
240: END IF;
241:

Line 238: hr_utility.trace('p_blocks(l_index).process ::'|| p_blocks(l_index).process);

234: end if;
235:
236: IF g_debug THEN
237: hr_utility.trace('In hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);
238: hr_utility.trace('p_blocks(l_index).process ::'|| p_blocks(l_index).process);
239: hr_utility.trace('p_blocks(l_index).changed ::'|| p_blocks(l_index).changed);
240: END IF;
241:
242: exception

Line 239: hr_utility.trace('p_blocks(l_index).changed ::'|| p_blocks(l_index).changed);

235:
236: IF g_debug THEN
237: hr_utility.trace('In hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);
238: hr_utility.trace('p_blocks(l_index).process ::'|| p_blocks(l_index).process);
239: hr_utility.trace('p_blocks(l_index).changed ::'|| p_blocks(l_index).changed);
240: END IF;
241:
242: exception
243: when others then

Line 273: hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 0');

269:
270: Begin
271:
272: IF g_debug THEN
273: hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 0');
274: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
275: END IF;
276:
277:

Line 274: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

270: Begin
271:
272: IF g_debug THEN
273: hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 0');
274: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
275: END IF;
276:
277:
278: l_index := p_attributes.first;

Line 290: hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 1');

286:
287: p_attributes(l_index).process := 'Y';
288:
289: IF g_debug THEN
290: hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 1');
291: END IF;
292:
293: hxc_block_attribute_update.g_tc_api_flag := 'N'; -- Added for Bug 12774447
294:

Line 296: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

292:
293: hxc_block_attribute_update.g_tc_api_flag := 'N'; -- Added for Bug 12774447
294:
295: IF g_debug THEN
296: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
297: END IF;
298:
299: else
300: if(NOT hxc_timecard_attribute_utils.is_system_context(l_attribute)) then

Line 324: hr_utility.trace(' New element added for '||l_attribute.building_block_id);

320: IF l_attribute.attribute_category LIKE 'ELEMENT%'
321: AND l_old_attribute.attribute_category LIKE 'ELEMENT%'
322: AND l_attribute.attribute_category <> l_old_attribute.attribute_category
323: THEN
324: hr_utility.trace(' New element added for '||l_attribute.building_block_id);
325: pay_hxc_deposit_interface.g_old_attribute(TO_NUMBER(l_attribute.building_block_id)) :=
326: l_old_attribute;
327: END IF;
328:

Line 334: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

330: p_attributes(l_index).process := 'N'; --3025733
331: end if;
332:
333: IF g_debug THEN
334: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
335: hr_utility.trace('In p_attributes(l_index).process ::'|| p_attributes(l_index).process);
336: END IF;
337:
338: if p_attributes(l_index).process='N' then --3025733

Line 335: hr_utility.trace('In p_attributes(l_index).process ::'|| p_attributes(l_index).process);

331: end if;
332:
333: IF g_debug THEN
334: hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);
335: hr_utility.trace('In p_attributes(l_index).process ::'|| p_attributes(l_index).process);
336: END IF;
337:
338: if p_attributes(l_index).process='N' then --3025733
339: p_attributes(l_index).changed:='N';

Line 460: hr_utility.trace(' Allow Deletion - Profile Value: ' ||FND_PROFILE.VALUE('HXC_ALLW_TC_DEL_CLSD_PRJ'));

456: p_blocks(l_block_index).process := hxc_timecard.c_no;
457: end if;
458:
459: -- Modified the following PA Validation code for bug 12916249
460: hr_utility.trace(' Allow Deletion - Profile Value: ' ||FND_PROFILE.VALUE('HXC_ALLW_TC_DEL_CLSD_PRJ'));
461:
462: IF NVL(FND_PROFILE.VALUE('HXC_ALLW_TC_DEL_CLSD_PRJ'),'N') = 'N'
463: THEN
464: -- This is for PA validation

Line 465: hr_utility.trace(' Prof In IF ');

461:
462: IF NVL(FND_PROFILE.VALUE('HXC_ALLW_TC_DEL_CLSD_PRJ'),'N') = 'N'
463: THEN
464: -- This is for PA validation
465: hr_utility.trace(' Prof In IF ');
466:
467: if(hxc_timecard_block_utils.parent_has_changed(p_blocks,p_blocks(l_block_index).parent_building_block_id)) then
468: p_blocks(l_block_index).changed := hxc_timecard.c_yes;
469: end if;

Line 484: hr_utility.trace('In hxc_block_attribute_update.set_process_flage 0');

480: ) is
481: Begin
482:
483: IF g_debug THEN
484: hr_utility.trace('In hxc_block_attribute_update.set_process_flage 0');
485: END IF;
486:
487: hxc_block_attribute_update.g_tc_api_flag := null; -- Added for Bug 12774447
488: