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_UTIL dependencies on HXC_TIMECARD

Line 11: p_props IN hxc_timecard_prop_table_type,

7: g_oit_migration CONSTANT VARCHAR2 (30) := 'OIT_MIGRATION';
8: g_debug BOOLEAN := hr_utility.debug_enabled;
9:
10: FUNCTION perform_audit (
11: p_props IN hxc_timecard_prop_table_type,
12: p_blocks IN hxc_block_table_type
13: )
14: RETURN BOOLEAN
15: AS

Line 21: (hxc_timecard_properties.find_property_value

17: l_audit BOOLEAN;
18: BEGIN
19: l_cla_terg_id :=
20: TO_NUMBER
21: (hxc_timecard_properties.find_property_value
22: (p_props,
23: 'TsPerAuditRequirementsAuditRequirements',
24: NULL,
25: NULL,

Line 28: (hxc_timecard_block_utils.find_active_timecard_index

24: NULL,
25: NULL,
26: p_start_date => fnd_date.canonical_to_date
27: (p_blocks
28: (hxc_timecard_block_utils.find_active_timecard_index
29: (p_blocks)
30: ).start_time
31: ),
32: p_stop_date => fnd_date.canonical_to_date

Line 34: (hxc_timecard_block_utils.find_active_timecard_index

30: ).start_time
31: ),
32: p_stop_date => fnd_date.canonical_to_date
33: (p_blocks
34: (hxc_timecard_block_utils.find_active_timecard_index
35: (p_blocks)
36: ).stop_time
37: )
38: )

Line 182: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;

178: p_blocks IN hxc_block_table_type
179: )
180: IS
181: l_proc VARCHAR2 (72);
182: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;
183: l_item_key wf_items.item_key%TYPE := NULL;
184: l_messages hxc_message_table_type := hxc_message_table_type();
185: l_timecard_props hxc_timecard_prop_table_type := hxc_timecard_prop_table_type();
186: l_timecard_index number;

Line 185: l_timecard_props hxc_timecard_prop_table_type := hxc_timecard_prop_table_type();

181: l_proc VARCHAR2 (72);
182: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;
183: l_item_key wf_items.item_key%TYPE := NULL;
184: l_messages hxc_message_table_type := hxc_message_table_type();
185: l_timecard_props hxc_timecard_prop_table_type := hxc_timecard_prop_table_type();
186: l_timecard_index number;
187: l_message fnd_new_messages.message_text%type;
188: TC_APPROVAL_EXCEPTION EXCEPTION;
189: BEGIN

Line 201: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

197:
198: -- set savepoint
199: savepoint TC_APPROVAL_SAVEPOINT;
200:
201: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
202:
203: hxc_timecard_properties.get_preference_properties
204: (p_validate => hxc_timecard.c_no,
205: p_resource_id => p_blocks(l_timecard_index).resource_id,

Line 203: hxc_timecard_properties.get_preference_properties

199: savepoint TC_APPROVAL_SAVEPOINT;
200:
201: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
202:
203: hxc_timecard_properties.get_preference_properties
204: (p_validate => hxc_timecard.c_no,
205: p_resource_id => p_blocks(l_timecard_index).resource_id,
206: p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time),
207: p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time),

Line 204: (p_validate => hxc_timecard.c_no,

200:
201: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
202:
203: hxc_timecard_properties.get_preference_properties
204: (p_validate => hxc_timecard.c_no,
205: p_resource_id => p_blocks(l_timecard_index).resource_id,
206: p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time),
207: p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time),
208: p_for_timecard => false,

Line 206: p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time),

202:
203: hxc_timecard_properties.get_preference_properties
204: (p_validate => hxc_timecard.c_no,
205: p_resource_id => p_blocks(l_timecard_index).resource_id,
206: p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time),
207: p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time),
208: p_for_timecard => false,
209: p_timecard_bb_id => p_timecard_id,
210: p_timecard_bb_ovn => p_blocks(l_timecard_index).object_version_number,

Line 207: p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time),

203: hxc_timecard_properties.get_preference_properties
204: (p_validate => hxc_timecard.c_no,
205: p_resource_id => p_blocks(l_timecard_index).resource_id,
206: p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time),
207: p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time),
208: p_for_timecard => false,
209: p_timecard_bb_id => p_timecard_id,
210: p_timecard_bb_ovn => p_blocks(l_timecard_index).object_version_number,
211: p_messages => l_messages,

Line 215: hxc_timecard_message_helper.processerrors

211: p_messages => l_messages,
212: p_property_table => l_timecard_props
213: );
214:
215: hxc_timecard_message_helper.processerrors
216: (p_messages => l_messages);
217:
218: -- Determine if this is a resubmitted timecard
219: l_timecard_index :=

Line 220: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);

216: (p_messages => l_messages);
217:
218: -- Determine if this is a resubmitted timecard
219: l_timecard_index :=
220: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
221:
222: IF (hxc_timecard_block_utils.date_value
223: (p_blocks (l_timecard_index).date_to
224: ) = hr_general.end_of_time

Line 222: IF (hxc_timecard_block_utils.date_value

218: -- Determine if this is a resubmitted timecard
219: l_timecard_index :=
220: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
221:
222: IF (hxc_timecard_block_utils.date_value
223: (p_blocks (l_timecard_index).date_to
224: ) = hr_general.end_of_time
225: )
226: THEN

Line 228: hxc_timecard_approval.is_timecard_resubmitted

224: ) = hr_general.end_of_time
225: )
226: THEN
227: l_resubmit :=
228: hxc_timecard_approval.is_timecard_resubmitted
229: (p_blocks (l_timecard_index).time_building_block_id,
230: p_blocks (l_timecard_index).object_version_number,
231: p_blocks (l_timecard_index).resource_id,
232: fnd_date.canonical_to_date

Line 240: l_resubmit := hxc_timecard.c_delete;

236: (p_blocks (l_timecard_index).stop_time
237: )
238: );
239: ELSE
240: l_resubmit := hxc_timecard.c_delete;
241: END IF;
242:
243: l_item_key :=
244: hxc_timecard_approval.begin_approval

Line 244: hxc_timecard_approval.begin_approval

240: l_resubmit := hxc_timecard.c_delete;
241: END IF;
242:
243: l_item_key :=
244: hxc_timecard_approval.begin_approval
245: (p_blocks => p_blocks,
246: p_item_type => 'HXCEMP',
247: p_process_name => 'HXC_APPROVAL',
248: p_resubmitted => l_resubmit,

Line 272: hxc_timecard_message_helper.processerrors

268: --dbms_output.put_line('online retrieval error : '||substr(l_message,1,255));
269:
270: rollback to TC_APPROVAL_SAVEPOINT;
271:
272: hxc_timecard_message_helper.processerrors
273: (p_messages => l_messages);
274: end if;
275: END IF;
276:

Line 279: hxc_timecard_message_helper.processerrors

275: END IF;
276:
277: -- Absences end
278:
279: hxc_timecard_message_helper.processerrors
280: (p_messages => l_messages);
281:
282: hxc_timecard_summary_pkg.update_summary_row
283: (p_timecard_id => p_timecard_id,

Line 282: hxc_timecard_summary_pkg.update_summary_row

278:
279: hxc_timecard_message_helper.processerrors
280: (p_messages => l_messages);
281:
282: hxc_timecard_summary_pkg.update_summary_row
283: (p_timecard_id => p_timecard_id,
284: p_approval_item_type => 'HXCEMP',
285: p_approval_process_name => 'HXC_APPROVAL',
286: p_approval_item_key => l_item_key

Line 308: -- the Save as it happens in the deposit wrapper HXC_TIMECARD.

304: --
305: -- Description: Private Procedure that can will be used to Save the timecard
306: -- (as oppose to Submit it). This will store the Timecard in the
307: -- DB with a status of WORKING. This whole procedure is mimicking
308: -- the Save as it happens in the deposit wrapper HXC_TIMECARD.
309: -----------------------------------------------------------------------------
310: PROCEDURE save_timecard (
311: p_blocks IN OUT NOCOPY hxc_block_table_type,
312: p_attributes IN OUT NOCOPY hxc_attribute_table_type,

Line 318: l_timecard_blocks hxc_timecard.block_list;

314: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
315: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
316: )
317: IS
318: l_timecard_blocks hxc_timecard.block_list;
319: l_day_blocks hxc_timecard.block_list;
320: l_detail_blocks hxc_timecard.block_list;
321: l_transaction_info hxc_timecard.transaction_info;
322: l_timecard_props hxc_timecard_prop_table_type;

Line 319: l_day_blocks hxc_timecard.block_list;

315: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
316: )
317: IS
318: l_timecard_blocks hxc_timecard.block_list;
319: l_day_blocks hxc_timecard.block_list;
320: l_detail_blocks hxc_timecard.block_list;
321: l_transaction_info hxc_timecard.transaction_info;
322: l_timecard_props hxc_timecard_prop_table_type;
323: l_proc VARCHAR2 (50) := g_package || 'save_timecard';

Line 320: l_detail_blocks hxc_timecard.block_list;

316: )
317: IS
318: l_timecard_blocks hxc_timecard.block_list;
319: l_day_blocks hxc_timecard.block_list;
320: l_detail_blocks hxc_timecard.block_list;
321: l_transaction_info hxc_timecard.transaction_info;
322: l_timecard_props hxc_timecard_prop_table_type;
323: l_proc VARCHAR2 (50) := g_package || 'save_timecard';
324: l_can_deposit BOOLEAN := TRUE;

Line 321: l_transaction_info hxc_timecard.transaction_info;

317: IS
318: l_timecard_blocks hxc_timecard.block_list;
319: l_day_blocks hxc_timecard.block_list;
320: l_detail_blocks hxc_timecard.block_list;
321: l_transaction_info hxc_timecard.transaction_info;
322: l_timecard_props hxc_timecard_prop_table_type;
323: l_proc VARCHAR2 (50) := g_package || 'save_timecard';
324: l_can_deposit BOOLEAN := TRUE;
325: l_timecard_index NUMBER;

Line 322: l_timecard_props hxc_timecard_prop_table_type;

318: l_timecard_blocks hxc_timecard.block_list;
319: l_day_blocks hxc_timecard.block_list;
320: l_detail_blocks hxc_timecard.block_list;
321: l_transaction_info hxc_timecard.transaction_info;
322: l_timecard_props hxc_timecard_prop_table_type;
323: l_proc VARCHAR2 (50) := g_package || 'save_timecard';
324: l_can_deposit BOOLEAN := TRUE;
325: l_timecard_index NUMBER;
326: l_old_style_blks hxc_self_service_time_deposit.timecard_info;

Line 345: hxc_timecard_message_helper.initializeerrors;

341:
342: l_index NUMBER;
343: BEGIN
344: fnd_msg_pub.initialize;
345: hxc_timecard_message_helper.initializeerrors;
346:
347: --This is done in the call to hxc_timecard_validation.deposit_validation
348: --hxc_time_category_utils_pkg.push_timecard (p_blocks, p_attributes);
349:

Line 347: --This is done in the call to hxc_timecard_validation.deposit_validation

343: BEGIN
344: fnd_msg_pub.initialize;
345: hxc_timecard_message_helper.initializeerrors;
346:
347: --This is done in the call to hxc_timecard_validation.deposit_validation
348: --hxc_time_category_utils_pkg.push_timecard (p_blocks, p_attributes);
349:
350: p_messages := hxc_message_table_type ();
351: hxc_timecard_block_utils.initialize_timecard_index;

Line 351: hxc_timecard_block_utils.initialize_timecard_index;

347: --This is done in the call to hxc_timecard_validation.deposit_validation
348: --hxc_time_category_utils_pkg.push_timecard (p_blocks, p_attributes);
349:
350: p_messages := hxc_message_table_type ();
351: hxc_timecard_block_utils.initialize_timecard_index;
352:
353: -- set savepoint
354: savepoint TC_SAVE_SAVEPOINT;
355:

Line 359: p_deposit_mode => hxc_timecard.c_save,

355:
356: -- Check input parameters
357: hxc_deposit_checks.check_inputs (p_blocks => p_blocks,
358: p_attributes => p_attributes,
359: p_deposit_mode => hxc_timecard.c_save,
360: p_template => hxc_timecard.c_no,
361: p_messages => p_messages
362: );
363: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

Line 360: p_template => hxc_timecard.c_no,

356: -- Check input parameters
357: hxc_deposit_checks.check_inputs (p_blocks => p_blocks,
358: p_attributes => p_attributes,
359: p_deposit_mode => hxc_timecard.c_save,
360: p_template => hxc_timecard.c_no,
361: p_messages => p_messages
362: );
363: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
364: -- First we are getting the preferences

Line 363: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

359: p_deposit_mode => hxc_timecard.c_save,
360: p_template => hxc_timecard.c_no,
361: p_messages => p_messages
362: );
363: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
364: -- First we are getting the preferences
365: l_timecard_index :=
366: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
367:

Line 366: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);

362: );
363: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
364: -- First we are getting the preferences
365: l_timecard_index :=
366: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
367:
368: l_timecard_start_time :=
369: fnd_date.canonical_to_date(p_blocks (l_timecard_index).start_time) ;
370:

Line 388: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');

384: hxc_retrieve_absences.g_stop_time := l_timecard_stop_time;
385:
386:
387: IF g_debug THEN
388: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');
389: hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');
390: hr_utility.trace('ABS: hxc_retrieve_absences.g_person_id '||hxc_retrieve_absences.g_person_id);
391: hr_utility.trace('ABS: hxc_retrieve_absences.g_start_time '||hxc_retrieve_absences.g_start_time);
392: hr_utility.trace('ABS: hxc_retrieve_absences.g_stop_time '||hxc_retrieve_absences.g_stop_time);

Line 401: hxc_timecard_properties.get_preference_properties

397: hxc_retrieve_absences.insert_absence_summary_row;
398: END IF;
399:
400:
401: hxc_timecard_properties.get_preference_properties
402: (p_validate => hxc_timecard.c_yes,
403: p_resource_id => p_blocks (l_timecard_index).resource_id,
404: p_timecard_start_time => l_timecard_start_time,
405: p_timecard_stop_time => l_timecard_stop_time,

Line 402: (p_validate => hxc_timecard.c_yes,

398: END IF;
399:
400:
401: hxc_timecard_properties.get_preference_properties
402: (p_validate => hxc_timecard.c_yes,
403: p_resource_id => p_blocks (l_timecard_index).resource_id,
404: p_timecard_start_time => l_timecard_start_time,
405: p_timecard_stop_time => l_timecard_stop_time,
406: p_for_timecard => FALSE,

Line 410: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

406: p_for_timecard => FALSE,
407: p_messages => p_messages,
408: p_property_table => l_timecard_props
409: );
410: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
411:
412: -- Bug 9023209
413: -- API absences validation
414: hxc_retrieve_absences.verify_view_only_absences

Line 471: hxc_timecard_block_utils.sort_blocks

467:
468:
469: -- p_messages.DELETE;
470: -- Sort blocks
471: hxc_timecard_block_utils.sort_blocks
472: (p_blocks => p_blocks,
473: p_timecard_blocks => l_timecard_blocks,
474: p_day_blocks => l_day_blocks,
475: p_detail_blocks => l_detail_blocks

Line 485: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

481: p_days => l_day_blocks,
482: p_details => l_detail_blocks,
483: p_messages => p_messages
484: );
485: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
486: -- Add the security attributes
487: -- ARR: 115.26 Add message structure
488: hxc_security.add_security_attribute
489: (p_blocks => p_blocks,

Line 494: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

490: p_attributes => p_attributes,
491: p_timecard_props => l_timecard_props,
492: p_messages => p_messages
493: );
494: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
495: -- Translate any aliases
496: hxc_timecard_deposit_common.alias_translation
497: (p_blocks => p_blocks,
498: p_attributes => p_attributes,

Line 496: hxc_timecard_deposit_common.alias_translation

492: p_messages => p_messages
493: );
494: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
495: -- Translate any aliases
496: hxc_timecard_deposit_common.alias_translation
497: (p_blocks => p_blocks,
498: p_attributes => p_attributes,
499: p_messages => p_messages
500: );

Line 501: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

497: (p_blocks => p_blocks,
498: p_attributes => p_attributes,
499: p_messages => p_messages
500: );
501: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
502:
503: -- Set the block and attribute update process flags Based on the data sent
504: -- and in the db
505: hxc_block_attribute_update.set_process_flags

Line 509: hxc_timecard_attribute_utils.remove_deleted_attributes

505: hxc_block_attribute_update.set_process_flags
506: (p_blocks => p_blocks,
507: p_attributes => p_attributes
508: );
509: hxc_timecard_attribute_utils.remove_deleted_attributes
510: (p_attributes => p_attributes);
511: /*
512: Validate the set up for the user
513:

Line 515: (p_deposit_mode => hxc_timecard.c_save

511: /*
512: Validate the set up for the user
513:
514: validate_setup
515: (p_deposit_mode => hxc_timecard.c_save
516: ,p_blocks => p_blocks
517: ,p_attributes => p_attributes
518: ,p_messages => p_messages
519: );

Line 521: hxc_timecard_message_helper.processerrors

517: ,p_attributes => p_attributes
518: ,p_messages => p_messages
519: );
520:
521: hxc_timecard_message_helper.processerrors
522: (p_messages => p_messages);
523: */ -- Call time entry rules for save
524:
525:

Line 528: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks);

524:
525:
526: /*
527: l_old_style_blks :=
528: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks);
529: l_old_style_attrs :=
530: hxc_timecard_attribute_utils.convert_to_dpwr_attributes (p_attributes);
531:
532: hxc_time_entry_rules_utils_pkg.execute_time_entry_rules

Line 530: hxc_timecard_attribute_utils.convert_to_dpwr_attributes (p_attributes);

526: /*
527: l_old_style_blks :=
528: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks);
529: l_old_style_attrs :=
530: hxc_timecard_attribute_utils.convert_to_dpwr_attributes (p_attributes);
531:
532: hxc_time_entry_rules_utils_pkg.execute_time_entry_rules
533: (p_operation => hxc_timecard.c_save,
534: p_time_building_blocks => l_old_style_blks,

Line 533: (p_operation => hxc_timecard.c_save,

529: l_old_style_attrs :=
530: hxc_timecard_attribute_utils.convert_to_dpwr_attributes (p_attributes);
531:
532: hxc_time_entry_rules_utils_pkg.execute_time_entry_rules
533: (p_operation => hxc_timecard.c_save,
534: p_time_building_blocks => l_old_style_blks,
535: p_time_attributes => l_old_style_attrs,
536: p_messages => l_old_messages,
537: p_resubmit => hxc_timecard.c_no,

Line 537: p_resubmit => hxc_timecard.c_no,

533: (p_operation => hxc_timecard.c_save,
534: p_time_building_blocks => l_old_style_blks,
535: p_time_attributes => l_old_style_attrs,
536: p_messages => l_old_messages,
537: p_resubmit => hxc_timecard.c_no,
538: p_blocks => p_blocks,
539: p_attributes => p_attributes
540: );
541: hxc_timecard_message_utils.append_old_messages

Line 541: hxc_timecard_message_utils.append_old_messages

537: p_resubmit => hxc_timecard.c_no,
538: p_blocks => p_blocks,
539: p_attributes => p_attributes
540: );
541: hxc_timecard_message_utils.append_old_messages
542: (p_messages => p_messages,
543: p_old_messages => l_old_messages,
544: p_retrieval_process_id => NULL
545: );

Line 546: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

542: (p_messages => p_messages,
543: p_old_messages => l_old_messages,
544: p_retrieval_process_id => NULL
545: );
546: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
547: */
548:
549: -- Added the following validation code for bug 8900783
550: -- This validation is to check if the timecard start and stop times falls within the

Line 565: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

561: p_timecard_stop_time => trunc(l_timecard_stop_time),
562: p_messages => p_messages
563: );
564:
565: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
566:
567:
568:
569: -- Call hxc_timecard_validation.deposit_validation to do this along with

Line 569: -- Call hxc_timecard_validation.deposit_validation to do this along with

565: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
566:
567:
568:
569: -- Call hxc_timecard_validation.deposit_validation to do this along with
570: -- recipient application validation
571:
572: -- Validate blocks, attributes
573: hxc_timecard_validation.deposit_validation

Line 573: hxc_timecard_validation.deposit_validation

569: -- Call hxc_timecard_validation.deposit_validation to do this along with
570: -- recipient application validation
571:
572: -- Validate blocks, attributes
573: hxc_timecard_validation.deposit_validation
574: (p_blocks => p_blocks,
575: p_attributes => p_attributes,
576: p_messages => p_messages,
577: p_props => l_timecard_props,

Line 578: p_deposit_mode => hxc_timecard.c_save,

574: (p_blocks => p_blocks,
575: p_attributes => p_attributes,
576: p_messages => p_messages,
577: p_props => l_timecard_props,
578: p_deposit_mode => hxc_timecard.c_save,
579: p_template => hxc_timecard.c_no,
580: p_resubmit => hxc_timecard.c_no,
581: p_can_deposit => l_can_deposit
582: );

Line 579: p_template => hxc_timecard.c_no,

575: p_attributes => p_attributes,
576: p_messages => p_messages,
577: p_props => l_timecard_props,
578: p_deposit_mode => hxc_timecard.c_save,
579: p_template => hxc_timecard.c_no,
580: p_resubmit => hxc_timecard.c_no,
581: p_can_deposit => l_can_deposit
582: );
583:

Line 580: p_resubmit => hxc_timecard.c_no,

576: p_messages => p_messages,
577: p_props => l_timecard_props,
578: p_deposit_mode => hxc_timecard.c_save,
579: p_template => hxc_timecard.c_no,
580: p_resubmit => hxc_timecard.c_no,
581: p_can_deposit => l_can_deposit
582: );
583:
584:

Line 585: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

581: p_can_deposit => l_can_deposit
582: );
583:
584:
585: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
586:
587: --svg start Bug 9181950
588: if NOT hxc_timecard_message_helper.noErrors then
589: --HXC_SVG_LOG.record_log('Reached here:svg');

Line 588: if NOT hxc_timecard_message_helper.noErrors then

584:
585: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
586:
587: --svg start Bug 9181950
588: if NOT hxc_timecard_message_helper.noErrors then
589: --HXC_SVG_LOG.record_log('Reached here:svg');
590: if g_debug then
591: hr_utility.trace('SVG: Rollingback to savepoint TC_SAVE_SAVEPOINT for any Projects related updates');
592: end if;

Line 600: IF hxc_timecard_message_helper.noerrors

596:
597:
598:
599: -- Store blocks and attributes
600: IF hxc_timecard_message_helper.noerrors
601: THEN
602: hxc_timecard_deposit.EXECUTE
603: (p_blocks => p_blocks,
604: p_attributes => p_attributes,

Line 602: hxc_timecard_deposit.EXECUTE

598:
599: -- Store blocks and attributes
600: IF hxc_timecard_message_helper.noerrors
601: THEN
602: hxc_timecard_deposit.EXECUTE
603: (p_blocks => p_blocks,
604: p_attributes => p_attributes,
605: p_timecard_blocks => l_timecard_blocks,
606: p_day_blocks => l_day_blocks,

Line 611: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

607: p_detail_blocks => l_detail_blocks,
608: p_messages => p_messages,
609: p_transaction_info => l_transaction_info
610: );
611: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
612: --
613: -- Maintain summary table
614: --
615: hxc_timecard_summary_api.timecard_deposit

Line 615: hxc_timecard_summary_api.timecard_deposit

611: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
612: --
613: -- Maintain summary table
614: --
615: hxc_timecard_summary_api.timecard_deposit
616: (p_blocks => p_blocks,
617: p_approval_item_type => NULL,
618: p_approval_process_name => NULL,
619: p_approval_item_key => NULL,

Line 624: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);

620: p_tk_audit_item_type => NULL,
621: p_tk_audit_process_name => NULL,
622: p_tk_audit_item_key => NULL
623: );
624: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);
625:
626: /* Bug 8888904 */
627: hxc_timecard_audit.maintain_rdb_snapshot
628: (p_blocks => p_blocks,

Line 627: hxc_timecard_audit.maintain_rdb_snapshot

623: );
624: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);
625:
626: /* Bug 8888904 */
627: hxc_timecard_audit.maintain_rdb_snapshot
628: (p_blocks => p_blocks,
629: p_attributes => p_attributes);
630:
631:

Line 632: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

628: (p_blocks => p_blocks,
629: p_attributes => p_attributes);
630:
631:
632: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
633: END IF;
634:
635: -- get all the errors
636: p_messages := hxc_timecard_message_helper.getmessages;

Line 636: p_messages := hxc_timecard_message_helper.getmessages;

632: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
633: END IF;
634:
635: -- get all the errors
636: p_messages := hxc_timecard_message_helper.getmessages;
637: p_timecard_id :=
638: p_blocks
639: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
640: ).time_building_block_id;

Line 639: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

635: -- get all the errors
636: p_messages := hxc_timecard_message_helper.getmessages;
637: p_timecard_id :=
638: p_blocks
639: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
640: ).time_building_block_id;
641: p_timecard_ovn :=
642: p_blocks
643: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

Line 643: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

639: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
640: ).time_building_block_id;
641: p_timecard_ovn :=
642: p_blocks
643: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
644: ).object_version_number;
645:
646:
647: -- OTL-Absences Integration (Bug 8779478)

Line 649: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors

645:
646:
647: -- OTL-Absences Integration (Bug 8779478)
648: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
649: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
650: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN
651:
652: IF g_debug THEN
653: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SAVE_TIMECARD');

Line 650: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN

646:
647: -- OTL-Absences Integration (Bug 8779478)
648: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
649: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
650: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN
651:
652: IF g_debug THEN
653: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SAVE_TIMECARD');
654: END IF;

Line 695: hxc_timecard_message_helper.processerrors

691: EXIT;
692: END IF;
693: END LOOP;
694:
695: hxc_timecard_message_helper.processerrors
696: (p_messages => p_messages);
697:
698: END IF;
699:

Line 731: -- the Submit as it happens in the deposit wrapper HXC_TIMECARD.

727: --
728: -- Description: Private Procedure that can will be used to Submit the timecard
729: -- This will store the Timecard in the DB with a status of
730: -- SUBMITTED. This whole procedure is mimicking
731: -- the Submit as it happens in the deposit wrapper HXC_TIMECARD.
732: -----------------------------------------------------------------------------
733: PROCEDURE submit_timecard (
734: p_item_type IN wf_items.item_type%TYPE,
735: p_approval_prc IN wf_process_activities.process_name%TYPE,

Line 746: l_timecard_blocks hxc_timecard.block_list;

742: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
743: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
744: )
745: IS
746: l_timecard_blocks hxc_timecard.block_list;
747: l_day_blocks hxc_timecard.block_list;
748: l_detail_blocks hxc_timecard.block_list;
749: l_transaction_info hxc_timecard.transaction_info;
750: l_old_transaction_info hxc_deposit_wrapper_utilities.t_transaction;

Line 747: l_day_blocks hxc_timecard.block_list;

743: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
744: )
745: IS
746: l_timecard_blocks hxc_timecard.block_list;
747: l_day_blocks hxc_timecard.block_list;
748: l_detail_blocks hxc_timecard.block_list;
749: l_transaction_info hxc_timecard.transaction_info;
750: l_old_transaction_info hxc_deposit_wrapper_utilities.t_transaction;
751: l_timecard_props hxc_timecard_prop_table_type;

Line 748: l_detail_blocks hxc_timecard.block_list;

744: )
745: IS
746: l_timecard_blocks hxc_timecard.block_list;
747: l_day_blocks hxc_timecard.block_list;
748: l_detail_blocks hxc_timecard.block_list;
749: l_transaction_info hxc_timecard.transaction_info;
750: l_old_transaction_info hxc_deposit_wrapper_utilities.t_transaction;
751: l_timecard_props hxc_timecard_prop_table_type;
752: l_proc VARCHAR2 (50)

Line 749: l_transaction_info hxc_timecard.transaction_info;

745: IS
746: l_timecard_blocks hxc_timecard.block_list;
747: l_day_blocks hxc_timecard.block_list;
748: l_detail_blocks hxc_timecard.block_list;
749: l_transaction_info hxc_timecard.transaction_info;
750: l_old_transaction_info hxc_deposit_wrapper_utilities.t_transaction;
751: l_timecard_props hxc_timecard_prop_table_type;
752: l_proc VARCHAR2 (50)
753: := g_package || 'submit_timecard';

Line 751: l_timecard_props hxc_timecard_prop_table_type;

747: l_day_blocks hxc_timecard.block_list;
748: l_detail_blocks hxc_timecard.block_list;
749: l_transaction_info hxc_timecard.transaction_info;
750: l_old_transaction_info hxc_deposit_wrapper_utilities.t_transaction;
751: l_timecard_props hxc_timecard_prop_table_type;
752: l_proc VARCHAR2 (50)
753: := g_package || 'submit_timecard';
754: l_can_deposit BOOLEAN := TRUE;
755: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;

Line 755: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;

751: l_timecard_props hxc_timecard_prop_table_type;
752: l_proc VARCHAR2 (50)
753: := g_package || 'submit_timecard';
754: l_can_deposit BOOLEAN := TRUE;
755: l_resubmit VARCHAR2 (10) := hxc_timecard.c_no;
756: l_timecard_index NUMBER;
757: l_rollback BOOLEAN := FALSE;
758: l_item_key wf_items.item_key%TYPE := NULL;
759: l_mode VARCHAR2 (30);

Line 775: hxc_timecard_message_helper.initializeerrors;

771:
772: l_index NUMBER;
773: BEGIN
774: fnd_msg_pub.initialize;
775: hxc_timecard_message_helper.initializeerrors;
776:
777: p_messages := hxc_message_table_type ();
778: hxc_timecard_block_utils.initialize_timecard_index;
779:

Line 778: hxc_timecard_block_utils.initialize_timecard_index;

774: fnd_msg_pub.initialize;
775: hxc_timecard_message_helper.initializeerrors;
776:
777: p_messages := hxc_message_table_type ();
778: hxc_timecard_block_utils.initialize_timecard_index;
779:
780: -- set savepoint
781: savepoint TC_SUB_SAVEPOINT ;
782:

Line 787: p_deposit_mode => hxc_timecard.c_submit,

783: -- Check input parameters
784: hxc_deposit_checks.check_inputs
785: (p_blocks => p_blocks,
786: p_attributes => p_attributes,
787: p_deposit_mode => hxc_timecard.c_submit,
788: p_template => hxc_timecard.c_no,
789: p_messages => p_messages
790: );
791: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

Line 788: p_template => hxc_timecard.c_no,

784: hxc_deposit_checks.check_inputs
785: (p_blocks => p_blocks,
786: p_attributes => p_attributes,
787: p_deposit_mode => hxc_timecard.c_submit,
788: p_template => hxc_timecard.c_no,
789: p_messages => p_messages
790: );
791: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
792: -- Determine if this is a resubmitted timecard

Line 791: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

787: p_deposit_mode => hxc_timecard.c_submit,
788: p_template => hxc_timecard.c_no,
789: p_messages => p_messages
790: );
791: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
792: -- Determine if this is a resubmitted timecard
793: l_timecard_index :=
794: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
795:

Line 794: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);

790: );
791: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
792: -- Determine if this is a resubmitted timecard
793: l_timecard_index :=
794: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
795:
796: IF (hxc_timecard_block_utils.date_value
797: (p_blocks (l_timecard_index).date_to
798: ) = hr_general.end_of_time

Line 796: IF (hxc_timecard_block_utils.date_value

792: -- Determine if this is a resubmitted timecard
793: l_timecard_index :=
794: hxc_timecard_block_utils.find_active_timecard_index (p_blocks);
795:
796: IF (hxc_timecard_block_utils.date_value
797: (p_blocks (l_timecard_index).date_to
798: ) = hr_general.end_of_time
799: )
800: THEN

Line 802: hxc_timecard_approval.is_timecard_resubmitted

798: ) = hr_general.end_of_time
799: )
800: THEN
801: l_resubmit :=
802: hxc_timecard_approval.is_timecard_resubmitted
803: (p_blocks (l_timecard_index).time_building_block_id,
804: p_blocks (l_timecard_index).object_version_number,
805: p_blocks (l_timecard_index).resource_id,
806: fnd_date.canonical_to_date

Line 814: l_resubmit := hxc_timecard.c_delete;

810: (p_blocks (l_timecard_index).stop_time
811: )
812: );
813: ELSE
814: l_resubmit := hxc_timecard.c_delete;
815: END IF;
816:
817:
818: l_timecard_start_time :=

Line 839: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');

835: hxc_retrieve_absences.g_stop_time := l_timecard_stop_time;
836:
837:
838: IF g_debug THEN
839: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');
840: hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');
841: hr_utility.trace('ABS: hxc_retrieve_absences.g_person_id '||hxc_retrieve_absences.g_person_id);
842: hr_utility.trace('ABS: hxc_retrieve_absences.g_start_time '||hxc_retrieve_absences.g_start_time);
843: hr_utility.trace('ABS: hxc_retrieve_absences.g_stop_time '||hxc_retrieve_absences.g_stop_time);

Line 853: hxc_timecard_properties.get_preference_properties

849: END IF;
850:
851:
852: -- Obtain the timecard properties
853: hxc_timecard_properties.get_preference_properties
854: (p_validate => hxc_timecard.c_yes,
855: p_resource_id => p_blocks (l_timecard_index).resource_id,
856: p_timecard_start_time => l_timecard_start_time,
857: p_timecard_stop_time => l_timecard_stop_time,

Line 854: (p_validate => hxc_timecard.c_yes,

850:
851:
852: -- Obtain the timecard properties
853: hxc_timecard_properties.get_preference_properties
854: (p_validate => hxc_timecard.c_yes,
855: p_resource_id => p_blocks (l_timecard_index).resource_id,
856: p_timecard_start_time => l_timecard_start_time,
857: p_timecard_stop_time => l_timecard_stop_time,
858: p_for_timecard => FALSE,

Line 862: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

858: p_for_timecard => FALSE,
859: p_messages => p_messages,
860: p_property_table => l_timecard_props
861: );
862: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
863: -- Sort the blocks - needed for deposit and all sorts of short cuts!
864:
865: -- Bug 9023209
866: -- API absences validation

Line 920: hxc_timecard_block_utils.sort_blocks

916: hr_utility.trace(' *****************');
917:
918: END IF;
919: END IF;
920: hxc_timecard_block_utils.sort_blocks
921: (p_blocks => p_blocks,
922: p_timecard_blocks => l_timecard_blocks,
923: p_day_blocks => l_day_blocks,
924: p_detail_blocks => l_detail_blocks

Line 940: IF (p_template = hxc_timecard.c_no)

936: --
937: -- Perform basic checks, e.g.
938: -- Are there any other timecards for this period?
939: --
940: IF (p_template = hxc_timecard.c_no)
941: THEN
942: hxc_deposit_checks.perform_checks
943: (p_blocks => p_blocks,
944: p_attributes => p_attributes,

Line 950: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

946: p_days => l_day_blocks,
947: p_details => l_detail_blocks,
948: p_messages => p_messages
949: );
950: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
951: END IF;
952:
953: -- Add the security attributes
954: -- ARR: 115.26 Add message structure

Line 961: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

957: p_attributes => p_attributes,
958: p_timecard_props => l_timecard_props,
959: p_messages => p_messages
960: );
961: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
962: -- Translate any aliases
963: hxc_timecard_deposit_common.alias_translation
964: (p_blocks => p_blocks,
965: p_attributes => p_attributes,

Line 963: hxc_timecard_deposit_common.alias_translation

959: p_messages => p_messages
960: );
961: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
962: -- Translate any aliases
963: hxc_timecard_deposit_common.alias_translation
964: (p_blocks => p_blocks,
965: p_attributes => p_attributes,
966: p_messages => p_messages
967: );

Line 968: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

964: (p_blocks => p_blocks,
965: p_attributes => p_attributes,
966: p_messages => p_messages
967: );
968: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
969:
970: -- Set the block and attribute update process flags based on the data sent
971: -- and in the db
972: hxc_block_attribute_update.set_process_flags

Line 976: hxc_timecard_attribute_utils.remove_deleted_attributes

972: hxc_block_attribute_update.set_process_flags
973: (p_blocks => p_blocks,
974: p_attributes => p_attributes
975: );
976: hxc_timecard_attribute_utils.remove_deleted_attributes
977: (p_attributes => p_attributes);
978: -- Perform process checks
979: hxc_deposit_checks.perform_process_checks
980: (p_blocks => p_blocks,

Line 985: p_template => hxc_timecard.c_no,

981: p_attributes => p_attributes,
982: p_timecard_props => l_timecard_props,
983: p_days => l_day_blocks,
984: p_details => l_detail_blocks,
985: p_template => hxc_timecard.c_no,
986: p_deposit_mode => hxc_timecard.c_submit,
987: p_messages => p_messages
988: );
989: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

Line 986: p_deposit_mode => hxc_timecard.c_submit,

982: p_timecard_props => l_timecard_props,
983: p_days => l_day_blocks,
984: p_details => l_detail_blocks,
985: p_template => hxc_timecard.c_no,
986: p_deposit_mode => hxc_timecard.c_submit,
987: p_messages => p_messages
988: );
989: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
990:

Line 989: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

985: p_template => hxc_timecard.c_no,
986: p_deposit_mode => hxc_timecard.c_submit,
987: p_messages => p_messages
988: );
989: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
990:
991:
992: -- Added the following validation code for bug 8900783
993: -- This validation is to check if the timecard start and stop times falls within the

Line 1008: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

1004: p_timecard_stop_time => trunc(l_timecard_stop_time),
1005: p_messages => p_messages
1006: );
1007:
1008: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1009:
1010: -- Validate blocks, attributes
1011: IF (p_mode <> hxc_timestore_deposit.c_migration
1012: --AND hxc_timestore_deposit.g_validate <> TRUE) -- Commented this condition for the bug 14494474

Line 1015: hxc_timecard_validation.deposit_validation

1011: IF (p_mode <> hxc_timestore_deposit.c_migration
1012: --AND hxc_timestore_deposit.g_validate <> TRUE) -- Commented this condition for the bug 14494474
1013: )
1014: THEN
1015: hxc_timecard_validation.deposit_validation
1016: (p_blocks => p_blocks,
1017: p_attributes => p_attributes,
1018: p_messages => p_messages,
1019: p_props => l_timecard_props,

Line 1021: p_template => hxc_timecard.c_no,

1017: p_attributes => p_attributes,
1018: p_messages => p_messages,
1019: p_props => l_timecard_props,
1020: p_deposit_mode => p_mode,
1021: p_template => hxc_timecard.c_no,
1022: p_resubmit => l_resubmit,
1023: p_can_deposit => l_can_deposit
1024: );
1025: ELSE -- minimal validation for migration

Line 1026: hxc_timecard_validation.data_set_validation

1022: p_resubmit => l_resubmit,
1023: p_can_deposit => l_can_deposit
1024: );
1025: ELSE -- minimal validation for migration
1026: hxc_timecard_validation.data_set_validation
1027: (p_blocks => p_blocks,
1028: p_messages => p_messages
1029: );
1030: END IF;

Line 1032: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

1028: p_messages => p_messages
1029: );
1030: END IF;
1031:
1032: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1033: -- Validate the set up for the user Do this only for timecards, and not
1034: -- for templates.
1035: /*
1036: hxc_timecard_deposit_common.validate_setup

Line 1036: hxc_timecard_deposit_common.validate_setup

1032: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1033: -- Validate the set up for the user Do this only for timecards, and not
1034: -- for templates.
1035: /*
1036: hxc_timecard_deposit_common.validate_setup
1037: (p_deposit_mode => hxc_timecard.c_submit
1038: ,p_blocks => p_blocks
1039: ,p_attributes => p_attributes
1040: ,p_messages => p_messages

Line 1037: (p_deposit_mode => hxc_timecard.c_submit

1033: -- Validate the set up for the user Do this only for timecards, and not
1034: -- for templates.
1035: /*
1036: hxc_timecard_deposit_common.validate_setup
1037: (p_deposit_mode => hxc_timecard.c_submit
1038: ,p_blocks => p_blocks
1039: ,p_attributes => p_attributes
1040: ,p_messages => p_messages
1041: );

Line 1043: hxc_timecard_message_helper.processerrors

1039: ,p_attributes => p_attributes
1040: ,p_messages => p_messages
1041: );
1042:
1043: hxc_timecard_message_helper.processerrors
1044: (p_messages => p_messages);
1045: */
1046: -- Reform time data, if required e.g Denormalize time data
1047: hxc_block_attribute_update.denormalize_time (p_blocks => p_blocks,

Line 1054: p_messages := hxc_timecard_message_helper.getmessages;

1050:
1051: IF perform_audit (p_props => l_timecard_props, p_blocks => p_blocks)
1052: THEN
1053: -- Get the messages to perform the audit check
1054: p_messages := hxc_timecard_message_helper.getmessages;
1055: -- Perform Audit Checks
1056: -- Mental Note on how this works:)
1057: -- hxc_timecard_validation.deposit_validation called above, raises
1058: -- proper errors if something is really wrong, e.g. during the

Line 1057: -- hxc_timecard_validation.deposit_validation called above, raises

1053: -- Get the messages to perform the audit check
1054: p_messages := hxc_timecard_message_helper.getmessages;
1055: -- Perform Audit Checks
1056: -- Mental Note on how this works:)
1057: -- hxc_timecard_validation.deposit_validation called above, raises
1058: -- proper errors if something is really wrong, e.g. during the
1059: -- project or payroll validation. However for Change and Late Audit
1060: -- (CLA), it stores special messages in message table p_messages.
1061: -- These messages have a message_level of REASON, are not considered

Line 1063: -- hxc_timecard_message_helper.noerrors as errors.

1059: -- project or payroll validation. However for Change and Late Audit
1060: -- (CLA), it stores special messages in message table p_messages.
1061: -- These messages have a message_level of REASON, are not considered
1062: -- errors and will not be recognized by
1063: -- hxc_timecard_message_helper.noerrors as errors.
1064: -- hxc_deposit_checks.audit_checks transforms these REASON errors
1065: -- into proper errors that will be caught by
1066: -- hxc_timecard_message_helper.noerrors.
1067: -- So effectively what we are doing here is converting the audit

Line 1066: -- hxc_timecard_message_helper.noerrors.

1062: -- errors and will not be recognized by
1063: -- hxc_timecard_message_helper.noerrors as errors.
1064: -- hxc_deposit_checks.audit_checks transforms these REASON errors
1065: -- into proper errors that will be caught by
1066: -- hxc_timecard_message_helper.noerrors.
1067: -- So effectively what we are doing here is converting the audit
1068: -- message into errors when the user calls the API and AUDIT is
1069: -- switched on in the preferences of the employee/resource.
1070: -- If the user calls the API and AUDIT is not set, we completely

Line 1076: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

1072: hxc_deposit_checks.audit_checks (p_blocks => p_blocks,
1073: p_attributes => p_attributes,
1074: p_messages => p_messages
1075: );
1076: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1077: END IF;
1078:
1079: --svg start Bug 9181950
1080: if NOT hxc_timecard_message_helper.noErrors then

Line 1080: if NOT hxc_timecard_message_helper.noErrors then

1076: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1077: END IF;
1078:
1079: --svg start Bug 9181950
1080: if NOT hxc_timecard_message_helper.noErrors then
1081: --HXC_SVG_LOG.record_log('Reached here:svg');
1082: if g_debug then
1083: hr_utility.trace('SVG: Rollingback to savepoint TC_SUB_SAVEPOINT for any Projects related updates');
1084: end if;

Line 1092: IF hxc_timecard_message_helper.noerrors

1088:
1089:
1090:
1091: -- Store blocks and attributes
1092: IF hxc_timecard_message_helper.noerrors
1093: THEN
1094: hxc_timecard_deposit.EXECUTE
1095: (p_blocks => p_blocks,
1096: p_attributes => p_attributes,

Line 1094: hxc_timecard_deposit.EXECUTE

1090:
1091: -- Store blocks and attributes
1092: IF hxc_timecard_message_helper.noerrors
1093: THEN
1094: hxc_timecard_deposit.EXECUTE
1095: (p_blocks => p_blocks,
1096: p_attributes => p_attributes,
1097: p_timecard_blocks => l_timecard_blocks,
1098: p_day_blocks => l_day_blocks,

Line 1107: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

1103:
1104:
1105:
1106:
1107: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1108: -- set the out parameters
1109: p_timecard_id :=
1110: p_blocks
1111: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

Line 1111: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

1107: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1108: -- set the out parameters
1109: p_timecard_id :=
1110: p_blocks
1111: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1112: ).time_building_block_id;
1113: p_timecard_ovn :=
1114: p_blocks
1115: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

Line 1115: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)

1111: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1112: ).time_building_block_id;
1113: p_timecard_ovn :=
1114: p_blocks
1115: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1116: ).object_version_number;
1117:
1118: IF ( (p_template <> hxc_timecard.c_yes)
1119: AND (hxc_timecard_message_helper.noerrors)

Line 1118: IF ( (p_template <> hxc_timecard.c_yes)

1114: p_blocks
1115: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1116: ).object_version_number;
1117:
1118: IF ( (p_template <> hxc_timecard.c_yes)
1119: AND (hxc_timecard_message_helper.noerrors)
1120: )
1121: THEN
1122: --

Line 1119: AND (hxc_timecard_message_helper.noerrors)

1115: (hxc_timecard_block_utils.find_active_timecard_index (p_blocks)
1116: ).object_version_number;
1117:
1118: IF ( (p_template <> hxc_timecard.c_yes)
1119: AND (hxc_timecard_message_helper.noerrors)
1120: )
1121: THEN
1122: --
1123: -- Maintain summary table

Line 1129: l_mode := hxc_timecard_summary_pkg.c_normal_mode;

1125: IF (p_mode = hxc_timestore_deposit.c_migration)
1126: THEN
1127: l_mode := g_oit_migration;
1128: ELSE
1129: l_mode := hxc_timecard_summary_pkg.c_normal_mode;
1130: END IF;
1131:
1132: hxc_timecard_summary_api.timecard_deposit
1133: (p_blocks => p_blocks,

Line 1132: hxc_timecard_summary_api.timecard_deposit

1128: ELSE
1129: l_mode := hxc_timecard_summary_pkg.c_normal_mode;
1130: END IF;
1131:
1132: hxc_timecard_summary_api.timecard_deposit
1133: (p_blocks => p_blocks,
1134: p_mode => l_mode,
1135: p_approval_item_type => NULL,
1136: p_approval_process_name => NULL,

Line 1142: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);

1138: p_tk_audit_item_type => NULL,
1139: p_tk_audit_process_name => NULL,
1140: p_tk_audit_item_key => NULL
1141: );
1142: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);
1143:
1144: /* Bug 8888904 */
1145: hxc_timecard_audit.maintain_rdb_snapshot
1146: (p_blocks => p_blocks,

Line 1145: hxc_timecard_audit.maintain_rdb_snapshot

1141: );
1142: hxc_timecard_audit.maintain_latest_details (p_blocks => p_blocks);
1143:
1144: /* Bug 8888904 */
1145: hxc_timecard_audit.maintain_rdb_snapshot
1146: (p_blocks => p_blocks,
1147: p_attributes => p_attributes);
1148:
1149: hxc_timecard_message_helper.processerrors

Line 1149: hxc_timecard_message_helper.processerrors

1145: hxc_timecard_audit.maintain_rdb_snapshot
1146: (p_blocks => p_blocks,
1147: p_attributes => p_attributes);
1148:
1149: hxc_timecard_message_helper.processerrors
1150: (p_messages => p_messages);
1151:
1152: -- OTL-Absences Integration (Bug 8779478)
1153: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')

Line 1155: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors

1151:
1152: -- OTL-Absences Integration (Bug 8779478)
1153: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')
1154: THEN
1155: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
1156: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)
1157: THEN
1158: IF g_debug THEN
1159: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SUBMIT_TIMECARD');

Line 1156: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)

1152: -- OTL-Absences Integration (Bug 8779478)
1153: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')
1154: THEN
1155: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
1156: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)
1157: THEN
1158: IF g_debug THEN
1159: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMESTORE_DEPOSIT_UTIL.SUBMIT_TIMECARD');
1160: END IF;

Line 1202: hxc_timecard_message_helper.processerrors

1198: EXIT;
1199: END IF;
1200: END LOOP;
1201:
1202: hxc_timecard_message_helper.processerrors
1203: (p_messages => p_messages);
1204:
1205: end if;
1206:

Line 1217: hxc_timecard_approval.begin_approval

1213: IF (p_mode <> hxc_timestore_deposit.c_migration
1214: AND hxc_timestore_deposit.g_validate <> TRUE)
1215: THEN
1216: l_item_key :=
1217: hxc_timecard_approval.begin_approval
1218: (p_blocks => p_blocks,
1219: p_item_type => p_item_type,
1220: p_process_name => p_approval_prc,
1221: p_resubmitted => l_resubmit,

Line 1226: hxc_timecard_message_helper.processerrors

1222: p_timecard_props => l_timecard_props,
1223: p_messages => p_messages
1224: );
1225:
1226: hxc_timecard_message_helper.processerrors
1227: (p_messages => p_messages);
1228:
1229: -- Absences start
1230:

Line 1247: hxc_timecard_message_helper.processerrors

1243: --dbms_output.put_line('online retrieval error : '||substr(l_message,1,255));
1244:
1245: rollback to TC_SUB_SAVEPOINT;
1246:
1247: hxc_timecard_message_helper.processerrors
1248: (p_messages => p_messages);
1249: end if;
1250: END IF;
1251:

Line 1254: hxc_timecard_summary_pkg.update_summary_row

1250: END IF;
1251:
1252: -- Absences end
1253:
1254: hxc_timecard_summary_pkg.update_summary_row
1255: (p_timecard_id => p_timecard_id,
1256: p_approval_item_type => p_item_type,
1257: p_approval_process_name => p_approval_prc,
1258: p_approval_item_key => l_item_key

Line 1261: ELSIF ( (p_template = hxc_timecard.c_yes)

1257: p_approval_process_name => p_approval_prc,
1258: p_approval_item_key => l_item_key
1259: );
1260: END IF;
1261: ELSIF ( (p_template = hxc_timecard.c_yes)
1262: AND (hxc_timecard_message_helper.noerrors)
1263: )
1264: THEN
1265: hxc_template_summary_api.template_deposit

Line 1262: AND (hxc_timecard_message_helper.noerrors)

1258: p_approval_item_key => l_item_key
1259: );
1260: END IF;
1261: ELSIF ( (p_template = hxc_timecard.c_yes)
1262: AND (hxc_timecard_message_helper.noerrors)
1263: )
1264: THEN
1265: hxc_template_summary_api.template_deposit
1266: (p_blocks => p_blocks,

Line 1274: hxc_timecard_audit.audit_deposit

1270: END IF;
1271: END IF;
1272:
1273: -- Audit this transaction
1274: hxc_timecard_audit.audit_deposit
1275: (p_transaction_info => l_transaction_info,
1276: p_messages => p_messages
1277: );
1278: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

Line 1278: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

1274: hxc_timecard_audit.audit_deposit
1275: (p_transaction_info => l_transaction_info,
1276: p_messages => p_messages
1277: );
1278: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1279:
1280:
1281:
1282:

Line 1284: AND (hxc_timecard_message_helper.noerrors)

1280:
1281:
1282:
1283: IF ( (p_mode = hxc_timestore_deposit.c_migration)
1284: AND (hxc_timecard_message_helper.noerrors)
1285: )
1286: THEN
1287: l_old_transaction_info :=
1288: convert_new_trans_info_to_old

Line 1299: hxc_timecard_message_helper.processerrors (p_messages => p_messages);

1295: ),
1296: p_overall_status => 'SUCCESS',
1297: p_transaction_tab => l_old_transaction_info
1298: );
1299: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1300: END IF;
1301:
1302: -- get all the errors
1303: p_messages := hxc_timecard_message_helper.getmessages;

Line 1303: p_messages := hxc_timecard_message_helper.getmessages;

1299: hxc_timecard_message_helper.processerrors (p_messages => p_messages);
1300: END IF;
1301:
1302: -- get all the errors
1303: p_messages := hxc_timecard_message_helper.getmessages;
1304:
1305: IF g_debug THEN
1306: hr_utility.trace('Leaving SUBMIT_TIMECARD');
1307: END IF;

Line 1321: -- that can be found in hxc_timecard_block_utils. It is not

1317: --
1318: -- Description: Private Function that will convert the old PL/SQL Timecard
1319: -- structure to the new TYPE that is then returned
1320: -- FYI: This is the reverse function of convert_to_dpwr_blocks
1321: -- that can be found in hxc_timecard_block_utils. It is not
1322: -- defined in that procedure as it is only needed for this API
1323: -- hence we define it here as a provate function
1324: -----------------------------------------------------------------------------
1325: FUNCTION convert_tbb_to_type (

Line 1401: p_transaction_info IN hxc_timecard.transaction_info

1397: -- Description: Public Function that will convert the new PL/SQL Transaction
1398: -- PL/SQL table to the old PL/SQL Table that is then returned
1399: -----------------------------------------------------------------------------
1400: FUNCTION convert_new_trans_info_to_old (
1401: p_transaction_info IN hxc_timecard.transaction_info
1402: )
1403: RETURN hxc_deposit_wrapper_utilities.t_transaction
1404: IS
1405: l_proc VARCHAR2 (72);

Line 1654: IF (p_changed = hxc_timecard.c_yes)

1650: THEN
1651: p_attribute.attribute_category := p_value;
1652: END IF;
1653:
1654: IF (p_changed = hxc_timecard.c_yes)
1655: THEN
1656: p_attribute.changed := hxc_timecard.c_yes;
1657: p_attribute.process := hxc_timecard.c_yes;
1658: END IF;

Line 1656: p_attribute.changed := hxc_timecard.c_yes;

1652: END IF;
1653:
1654: IF (p_changed = hxc_timecard.c_yes)
1655: THEN
1656: p_attribute.changed := hxc_timecard.c_yes;
1657: p_attribute.process := hxc_timecard.c_yes;
1658: END IF;
1659: END set_new_attribute_value;
1660: -----------------------------------------------------------------------------

Line 1657: p_attribute.process := hxc_timecard.c_yes;

1653:
1654: IF (p_changed = hxc_timecard.c_yes)
1655: THEN
1656: p_attribute.changed := hxc_timecard.c_yes;
1657: p_attribute.process := hxc_timecard.c_yes;
1658: END IF;
1659: END set_new_attribute_value;
1660: -----------------------------------------------------------------------------
1661: -- Bug 11896973

Line 1815: l_new := hxc_timecard.c_yes;

1811: END IF;
1812: END IF;
1813: IF (p_app_attributes (p_app_index).attribute_index IS NULL)
1814: THEN
1815: l_new := hxc_timecard.c_yes;
1816: ELSE
1817: l_new := hxc_timecard.c_no;
1818: END IF;
1819:

Line 1817: l_new := hxc_timecard.c_no;

1813: IF (p_app_attributes (p_app_index).attribute_index IS NULL)
1814: THEN
1815: l_new := hxc_timecard.c_yes;
1816: ELSE
1817: l_new := hxc_timecard.c_no;
1818: END IF;
1819:
1820: l_new_attribute :=
1821: hxc_attribute_type

Line 1855: hxc_timecard_attribute_utils.get_bld_blk_info_type_id

1851: NULL,
1852: NULL,
1853: NULL,
1854: NULL,
1855: hxc_timecard_attribute_utils.get_bld_blk_info_type_id
1856: (p_app_attributes (p_app_index).bld_blk_info_type
1857: ),
1858: 1,
1859: l_new,

Line 1860: hxc_timecard.c_no,

1856: (p_app_attributes (p_app_index).bld_blk_info_type
1857: ),
1858: 1,
1859: l_new,
1860: hxc_timecard.c_no,
1861: -- Changed: We will decide later if this is a changed Attribute
1862: p_app_attributes (p_app_index).bld_blk_info_type,
1863: hxc_timecard.c_no,
1864: -- Process: We will decide later if this Attribute needs to get processed

Line 1863: hxc_timecard.c_no,

1859: l_new,
1860: hxc_timecard.c_no,
1861: -- Changed: We will decide later if this is a changed Attribute
1862: p_app_attributes (p_app_index).bld_blk_info_type,
1863: hxc_timecard.c_no,
1864: -- Process: We will decide later if this Attribute needs to get processed
1865: NULL
1866: );
1867: l_index := p_app_attributes.FIRST;

Line 2075: IF p_mode = hxc_timecard.c_save

2071: l_proc := g_package || 'get_approval_status';
2072: hr_utility.set_location ('Entering:' || l_proc, 10);
2073: END IF;
2074:
2075: IF p_mode = hxc_timecard.c_save
2076: THEN
2077: l_appr_stat := hxc_timecard.c_working_status;
2078: ELSIF p_mode = hxc_timecard.c_submit
2079: THEN

Line 2077: l_appr_stat := hxc_timecard.c_working_status;

2073: END IF;
2074:
2075: IF p_mode = hxc_timecard.c_save
2076: THEN
2077: l_appr_stat := hxc_timecard.c_working_status;
2078: ELSIF p_mode = hxc_timecard.c_submit
2079: THEN
2080: l_appr_stat := hxc_timecard.c_submitted_status;
2081: ELSIF p_mode = hxc_timestore_deposit.c_tk_save

Line 2078: ELSIF p_mode = hxc_timecard.c_submit

2074:
2075: IF p_mode = hxc_timecard.c_save
2076: THEN
2077: l_appr_stat := hxc_timecard.c_working_status;
2078: ELSIF p_mode = hxc_timecard.c_submit
2079: THEN
2080: l_appr_stat := hxc_timecard.c_submitted_status;
2081: ELSIF p_mode = hxc_timestore_deposit.c_tk_save
2082: THEN

Line 2080: l_appr_stat := hxc_timecard.c_submitted_status;

2076: THEN
2077: l_appr_stat := hxc_timecard.c_working_status;
2078: ELSIF p_mode = hxc_timecard.c_submit
2079: THEN
2080: l_appr_stat := hxc_timecard.c_submitted_status;
2081: ELSIF p_mode = hxc_timestore_deposit.c_tk_save
2082: THEN
2083: l_appr_stat := hxc_timecard.c_working_status;
2084: ELSIF p_mode = hxc_timestore_deposit.c_tk_submit

Line 2083: l_appr_stat := hxc_timecard.c_working_status;

2079: THEN
2080: l_appr_stat := hxc_timecard.c_submitted_status;
2081: ELSIF p_mode = hxc_timestore_deposit.c_tk_save
2082: THEN
2083: l_appr_stat := hxc_timecard.c_working_status;
2084: ELSIF p_mode = hxc_timestore_deposit.c_tk_submit
2085: THEN
2086: l_appr_stat := hxc_timecard.c_submitted_status;
2087: ELSIF p_mode = hxc_timecard.c_audit

Line 2086: l_appr_stat := hxc_timecard.c_submitted_status;

2082: THEN
2083: l_appr_stat := hxc_timecard.c_working_status;
2084: ELSIF p_mode = hxc_timestore_deposit.c_tk_submit
2085: THEN
2086: l_appr_stat := hxc_timecard.c_submitted_status;
2087: ELSIF p_mode = hxc_timecard.c_audit
2088: THEN
2089: l_appr_stat := hxc_timecard.c_submitted_status;
2090: ELSIF p_mode = hxc_timestore_deposit.c_migration

Line 2087: ELSIF p_mode = hxc_timecard.c_audit

2083: l_appr_stat := hxc_timecard.c_working_status;
2084: ELSIF p_mode = hxc_timestore_deposit.c_tk_submit
2085: THEN
2086: l_appr_stat := hxc_timecard.c_submitted_status;
2087: ELSIF p_mode = hxc_timecard.c_audit
2088: THEN
2089: l_appr_stat := hxc_timecard.c_submitted_status;
2090: ELSIF p_mode = hxc_timestore_deposit.c_migration
2091: THEN

Line 2089: l_appr_stat := hxc_timecard.c_submitted_status;

2085: THEN
2086: l_appr_stat := hxc_timecard.c_submitted_status;
2087: ELSIF p_mode = hxc_timecard.c_audit
2088: THEN
2089: l_appr_stat := hxc_timecard.c_submitted_status;
2090: ELSIF p_mode = hxc_timestore_deposit.c_migration
2091: THEN
2092: l_appr_stat := hxc_timecard.c_submitted_status;
2093: ELSE -- if no mode was supplied (or the wrong one), try working

Line 2092: l_appr_stat := hxc_timecard.c_submitted_status;

2088: THEN
2089: l_appr_stat := hxc_timecard.c_submitted_status;
2090: ELSIF p_mode = hxc_timestore_deposit.c_migration
2091: THEN
2092: l_appr_stat := hxc_timecard.c_submitted_status;
2093: ELSE -- if no mode was supplied (or the wrong one), try working
2094: l_appr_stat := hxc_timecard.c_working_status;
2095: END IF;
2096:

Line 2094: l_appr_stat := hxc_timecard.c_working_status;

2090: ELSIF p_mode = hxc_timestore_deposit.c_migration
2091: THEN
2092: l_appr_stat := hxc_timecard.c_submitted_status;
2093: ELSE -- if no mode was supplied (or the wrong one), try working
2094: l_appr_stat := hxc_timecard.c_working_status;
2095: END IF;
2096:
2097: IF g_debug
2098: THEN

Line 2172: AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope

2168: AND tbb.date_to = hr_general.end_of_time
2169: AND parent_tbb.time_building_block_id = tbb.parent_building_block_id
2170: AND parent_tbb.object_version_number = tbb.parent_building_block_ovn
2171: AND parent_tbb.date_to = hr_general.end_of_time
2172: AND parent_tbb.SCOPE <> hxc_timecard.c_template_scope
2173: GROUP BY tbb.time_building_block_id;
2174:
2175: l_building_block_count PLS_INTEGER;
2176: l_index PLS_INTEGER;

Line 2548: /* hxc_timecard.convert_to_type

2544: p_timecard_bb_id => p_timecard_bb_id,
2545: p_timecard_ovn => p_timecard_ovn
2546: );
2547:
2548: /* hxc_timecard.convert_to_type
2549: (p_attributes => in HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info)
2550: return HXC_ATTRIBUTE_TABLE_TYPE is
2551:
2552: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;

Line 2595: WHERE SCOPE = hxc_timecard.c_timecard_scope

2591: )
2592: IS
2593: SELECT time_building_block_id, MAX (object_version_number)
2594: FROM hxc_time_building_blocks
2595: WHERE SCOPE = hxc_timecard.c_timecard_scope
2596: AND date_to = hr_general.end_of_time
2597: CONNECT BY PRIOR parent_building_block_id = time_building_block_id
2598: AND PRIOR parent_building_block_ovn = object_version_number
2599: START WITH time_building_block_id = v_tc_id

Line 2946: hxc_timecard.load_blocks (p_timecard_id => l_timecard_bb_id,

2942:
2943: -- Then get the complete TC
2944: -- First get all the TBBs ...
2945: p_app_blocks :=
2946: hxc_timecard.load_blocks (p_timecard_id => l_timecard_bb_id,
2947: p_timecard_ovn => l_object_version_number
2948: );
2949: -- ... then all the attributes and store them in the Type structures
2950: l_attributes := hxc_timecard.load_attributes (p_blocks => p_app_blocks);

Line 2950: l_attributes := hxc_timecard.load_attributes (p_blocks => p_app_blocks);

2946: hxc_timecard.load_blocks (p_timecard_id => l_timecard_bb_id,
2947: p_timecard_ovn => l_object_version_number
2948: );
2949: -- ... then all the attributes and store them in the Type structures
2950: l_attributes := hxc_timecard.load_attributes (p_blocks => p_app_blocks);
2951: -- Finally convert the attributes to app_attributes.
2952: p_app_attributes :=
2953: hxc_app_attribute_utils.create_app_attributes
2954: (p_attributes => l_attributes,

Line 3011: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);

3007: p_app_blocks => l_blocks,
3008: p_app_attributes => p_app_attributes
3009: );
3010: p_app_blocks :=
3011: hxc_timecard_block_utils.convert_to_dpwr_blocks (p_blocks => l_blocks);
3012:
3013: IF g_debug
3014: THEN
3015: hr_utility.set_location ('Leaving:' || l_proc, 20);

Line 3229: hxc_timecard_block_utils.find_active_timecard_index (p_app_blocks);

3225: hr_utility.set_location ('Entering:' || l_proc, 10);
3226: END IF;
3227:
3228: l_tc_index :=
3229: hxc_timecard_block_utils.find_active_timecard_index (p_app_blocks);
3230:
3231: IF (hxc_timecard_block_utils.is_new_block (p_app_blocks (l_tc_index)))
3232: THEN
3233: hxc_lock_api.request_lock

Line 3231: IF (hxc_timecard_block_utils.is_new_block (p_app_blocks (l_tc_index)))

3227:
3228: l_tc_index :=
3229: hxc_timecard_block_utils.find_active_timecard_index (p_app_blocks);
3230:
3231: IF (hxc_timecard_block_utils.is_new_block (p_app_blocks (l_tc_index)))
3232: THEN
3233: hxc_lock_api.request_lock
3234: (p_process_locker_type => hxc_lock_util.c_plsql_deposit_action,
3235: p_resource_id => p_app_blocks (l_tc_index).resource_id,

Line 3300: hxc_timecard_block_utils.find_active_timecard_index (p_app_blocks);

3296: hr_utility.set_location ('Entering:' || l_proc, 10);
3297: END IF;
3298:
3299: l_tc_index :=
3300: hxc_timecard_block_utils.find_active_timecard_index (p_app_blocks);
3301:
3302: IF (hxc_timecard_block_utils.is_new_block (p_app_blocks (l_tc_index)))
3303: THEN
3304: hxc_lock_api.release_lock

Line 3302: IF (hxc_timecard_block_utils.is_new_block (p_app_blocks (l_tc_index)))

3298:
3299: l_tc_index :=
3300: hxc_timecard_block_utils.find_active_timecard_index (p_app_blocks);
3301:
3302: IF (hxc_timecard_block_utils.is_new_block (p_app_blocks (l_tc_index)))
3303: THEN
3304: hxc_lock_api.release_lock
3305: (p_row_lock_id => p_row_lock_id,
3306: p_process_locker_type => hxc_lock_util.c_plsql_deposit_action,

Line 3703: hxc_timecard_message_utils.append_old_messages

3699: l_proc := g_package || 'log_messages (Overloaded)';
3700: hr_utility.set_location ('Entering:' || l_proc, 10);
3701: END IF;
3702:
3703: hxc_timecard_message_utils.append_old_messages
3704: (p_messages => l_messages,
3705: p_old_messages => p_messages,
3706: p_retrieval_process_id => NULL
3707: );

Line 3827: l_periods hxc_timecard_utilities.periods;

3823: p_stop_time OUT NOCOPY DATE
3824: )
3825: IS
3826: l_proc VARCHAR2 (72);
3827: l_periods hxc_timecard_utilities.periods;
3828: l_period_idx PLS_INTEGER;
3829: l_period_found BOOLEAN DEFAULT FALSE;
3830: BEGIN
3831: IF g_debug

Line 3837: hxc_timecard_utilities.init_globals (p_resource_id => p_resource_id);

3833: l_proc := g_package || 'find_current_period';
3834: hr_utility.set_location ('Entering:' || l_proc, 10);
3835: END IF;
3836:
3837: hxc_timecard_utilities.init_globals (p_resource_id => p_resource_id);
3838: l_periods :=
3839: hxc_timecard_utilities.get_periods
3840: (p_resource_id => p_resource_id,
3841: p_resource_type => p_resource_type,

Line 3839: hxc_timecard_utilities.get_periods

3835: END IF;
3836:
3837: hxc_timecard_utilities.init_globals (p_resource_id => p_resource_id);
3838: l_periods :=
3839: hxc_timecard_utilities.get_periods
3840: (p_resource_id => p_resource_id,
3841: p_resource_type => p_resource_type,
3842: p_current_date => p_day,
3843: p_show_existing_timecard => 'Y'

Line 4009: hxc_timecard_message_helper.addErrorToCollection

4005: p_timecard_stop_time > l_future_date_limit ) THEN
4006:
4007: hr_utility.trace('Timecard not within the allowed past and future days limit');
4008:
4009: hxc_timecard_message_helper.addErrorToCollection
4010: (p_messages,
4011: 'HXC_NO_PERIODS_TO_CREATE',
4012: hxc_timecard.c_error,
4013: null,

Line 4012: hxc_timecard.c_error,

4008:
4009: hxc_timecard_message_helper.addErrorToCollection
4010: (p_messages,
4011: 'HXC_NO_PERIODS_TO_CREATE',
4012: hxc_timecard.c_error,
4013: null,
4014: null,
4015: hxc_timecard.c_hxc,
4016: null,

Line 4015: hxc_timecard.c_hxc,

4011: 'HXC_NO_PERIODS_TO_CREATE',
4012: hxc_timecard.c_error,
4013: null,
4014: null,
4015: hxc_timecard.c_hxc,
4016: null,
4017: null,
4018: null,
4019: null